PHP "十二五" 简易 BLOG 代码- 未测试- 04

install.php

##########

<?PHP
include "inc/mysql.inc.php";
$aa=new mysql;
$bb=new mysql;
$aa->link("mysql");
$query="CREATE DATBASE "blog_db'";
if($aa->excu($query)){
echo"CREATE DB SUCCESS!"<br>";
}
$bb->link("blog_db");
//CREATE TABLE: manage_user_info
$query="CREATE TABLE 'manage_info'(
'id' int(11) NOT NULL auto_increment,
'manage_user' varchar(20) NOT NULL,
'manage_pw' varchar(32) NOT NULL,
'last_time' datetime default '0000-00-00 00:00:00',
UNIQUE KEY 'id' ('id')
)";
$bb->excu($query);
echo "CREATE TABLE: user_info SUCCESS!<br>",
//CREATE TABLE: blog_type_info
$query="CREATE TABLE 'blog_type_info'(
'id' int(11) NOT NULL auto_increment,
'user_id' int(11) NOT NULL,
'type_name' varchar(10)NOT NULL,
'add_time' datetime default '0000-00-00 00:00:00',
'show_order' int(10) default '0',
UNIQUE KEY 'id' ('id')
)";
$bb->excu($query);
echo "CREATE TABLE: blog_type_info SUCCESS!<br>";
//CREATE: blog_info
$query="CREATE TABLE 'blog_info'(
'id' int(11) NOT NULL auto_increment,
'user_id' int(11) NOT NULL,
'type_id' int(11) NOT NULL,
'title' varchar(100) NOT NULL,
'cont' text NOT NULL,
'add_time' datetime default '0000-00-00 00:00:00',
UNIQUE KEY 'id'('id')
);
$bb->excu($query);
echo"CREATE TABLE: blog_ino SUCCESS!<br>";
//CREATE: blog_comm_info
$query="CREATE TABLE 'blog_comm_info'(
'id' int(11) NOT NULL auto_increment,
'blog_id' int(11) default '0',
'comm_name' varchar(32) NOT NULL,
'cont' text NOT NULL,
'add_time' datetime default '0000-00-00 00:00:00',
UNIQYE KEY 'id'('id')
)";
$bb->excu($query);
echo "CREATE: blog_comm_info SUCCESS! <br>";
//CREATE TABLE: pic_info
$query="CREATE TABLE 'pic_info'(
'id' int(11) NOT NULL auto_increment,
'addr' varchar(32) NOT NULL,
'tag' char(2) default'1',
'target' hcar(2) default '0',
'user_id' int(11) NOT NULL,
UNIQUE KEY 'id' ('id')
)";
$bb->excu($query);
echo "CREATE: pic_info SUCCESS!<br>;
// INIT ADMIN AND PASSWORD
$query="INTER INTO 'manage_info' VALUES(1,'admin','admin','0000-00-00 00:00:00')";
if($bb->excu($query)){
echo"INIT ADMIn USERNAME AND PASSWORD: admin,admin<br>";
}
echo "OK!";
?>