PHP "十二五" 简易 BLOG 代码- 未测试- 01-CSDN博客

CreateDB.txt

#############

CREATE DATABASE "blog_db';

CREATE TABLE IF NOT EXISTS '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',
UNIQUE KEY 'id'('id')
);

CREATE DATA TABLE blog_info:

CREATE TABLE IF NOT EXITS 'blog_info'(
'id' int(11) NOT NULL auto_increment,
'user_id' int(11) NOT NULL,
'type_id' varchar(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')
);

CREATE DATA TABLE blog_type_info:

CREATE TABLE IF NOT EXITS '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',
UNIQUE KEY'id'('id')
);

CREATE DATA TABLE manage_info:

CREATE TABLE IF NOT EXISTS 'manage/0info'(
'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',
UNIQYE KEY 'id'('id)
);

CREATE DATA TABLE pic_info:

CREATE TABLE IF NOT EXISTS'pic_info'(
'id' int(11) NOT NULL auto_increment,
'addr, varchat(32) NOT NULL,
'tag' char(2) default '1',
'target' char(2) default '0',
'yser_id' int(11) NOT NULL,
UNIQUE KEY'id('id')
);

CREATE DATA TABLE user_info:

CREATE TABLE IF NOT EXITS 'user_info' (
'id' int(11) NOT NULL auto_increment,
'user_name' varchar(20) NOT NULL,
'user_pw' varchar(32) NOT NULL,
'tag' char(2) default '1',
'r_time' datetime default '0000-00-00 00:00:00',
'last_time' datetime defaulr '0000-00-00 00:00:00',
UNIQUE KEY 'id'('id')
);