/*blog基本信息表*/
CREATE TABLE blog(
id int(11) NOT NULL auto_increment,
username varchar(20) NOT NULL,
password varchar(20) NOT NULL,
subject varchar(100) NOT NULL,
email varchar(50) NOT NULL,
image varchar(100) NOT NULL,
visitcount int(11) NULL,
PRIMARY KEY (id)
)ENGINE=MyISAM DEFAULT CHARSET=gbk;
/*文章分类基本信息表*/
CREATE TABLE sort(
id int(11) NOT NULL auto_increment,
name varchar (40) NOT NULL,
blogid int(11) NOT NULL
REFERENCES blog(id) ON DELETE CASCADE,
PRIMARY KEY (id)
)ENGINE=MyISAM DEFAULT CHARSET=gbk;
/*文章基本信息表*/
CREATE TABLE article(
id int(11) NOT NULL auto_increment,
title varchar (20) NOT NULL,
content TEXT NULL,
pubtime DATETIME NOT NULL,
blogid int(11) NOT NULL
REFERENCES blog(id) ON DELETE CASCADE,
sortid int(11) NULL
REFERENCES sort(id) ON DELETE CASCADE,
PRIMARY KEY (id)
)ENGINE=MyISAM DEFAULT CHARSET=gbk;
/*评论基本信息表*/
CREATE TABLE feedback(
id int(11) NOT NULL auto_increment,
uname varchar (20) NOT NULL,
content TEXT(5000) NULL,
pubtime DATETIME NOT NULL,
articleid int(11) NOT NULL
REFERENCES article(id) ON DELETE CASCADE,
PRIMARY KEY (id)
)ENGINE=MyISAM DEFAULT CHARSET=gbk;
/*友情连接基本信息表*/
CREATE TABLE links(
id int(11) NOT NULL auto_increment,
name varchar (40) NOT NULL,
url varchar (100) NOT NULL,
blogid int(11) NOT NULL
REFERENCES blog(id) ON DELETE CASCADE,
PRIMARY KEY (id)
)ENGINE=MyISAM DEFAULT CHARSET=gbk;/*
其中blogid与blog表的id相关联,
sortid与sort表的id相关联,
articleid与article表的id相关联。
*/
CREATE TABLE blog(
id int(11) NOT NULL auto_increment,
username varchar(20) NOT NULL,
password varchar(20) NOT NULL,
subject varchar(100) NOT NULL,
email varchar(50) NOT NULL,
image varchar(100) NOT NULL,
visitcount int(11) NULL,
PRIMARY KEY (id)
)ENGINE=MyISAM DEFAULT CHARSET=gbk;
/*文章分类基本信息表*/
CREATE TABLE sort(
id int(11) NOT NULL auto_increment,
name varchar (40) NOT NULL,
blogid int(11) NOT NULL
REFERENCES blog(id) ON DELETE CASCADE,
PRIMARY KEY (id)
)ENGINE=MyISAM DEFAULT CHARSET=gbk;
/*文章基本信息表*/
CREATE TABLE article(
id int(11) NOT NULL auto_increment,
title varchar (20) NOT NULL,
content TEXT NULL,
pubtime DATETIME NOT NULL,
blogid int(11) NOT NULL
REFERENCES blog(id) ON DELETE CASCADE,
sortid int(11) NULL
REFERENCES sort(id) ON DELETE CASCADE,
PRIMARY KEY (id)
)ENGINE=MyISAM DEFAULT CHARSET=gbk;
/*评论基本信息表*/
CREATE TABLE feedback(
id int(11) NOT NULL auto_increment,
uname varchar (20) NOT NULL,
content TEXT(5000) NULL,
pubtime DATETIME NOT NULL,
articleid int(11) NOT NULL
REFERENCES article(id) ON DELETE CASCADE,
PRIMARY KEY (id)
)ENGINE=MyISAM DEFAULT CHARSET=gbk;
/*友情连接基本信息表*/
CREATE TABLE links(
id int(11) NOT NULL auto_increment,
name varchar (40) NOT NULL,
url varchar (100) NOT NULL,
blogid int(11) NOT NULL
REFERENCES blog(id) ON DELETE CASCADE,
PRIMARY KEY (id)
)ENGINE=MyISAM DEFAULT CHARSET=gbk;/*
其中blogid与blog表的id相关联,
sortid与sort表的id相关联,
articleid与article表的id相关联。
*/
解决方案 »
- auto_increment 到上限了, 该怎么处理
- 数据库权限问题
- 远程连接mysql"Can't connect to mysql server on IP(10060)"
- 不同的数值怎么会让相同的查询使用不同的索引?
- 这样结果的SQL语句能实现吗?
- 请教join 语法的问题
- Postgres的permission deniey问题
- mysql支持group by all吗
- 请问我从mysql数据库中取出来的数据,用MFC的listCtrl控件来显示,但是中文却显示乱码,应该怎样解决呢?
- 请教mysql的一个疑问 io写入很大
- 有什么办法,可以在WINXP上把LINUX里的MYSQL数据库完全备份到WINXP机器??或者是导出到WINXP机器?
- 创建约束后,插入数据失败?
CREATE TABLE blog(
id int(11) NOT NULL auto_increment,
usernamevarchar(20)NOT NULL,
passwordvarchar(20)NOT NULL,
subjectvarchar(100)NOT NULL,
emailvarchar(50)NOT NULL,
imagevarchar(100)NOT NULL,
visitcountint(11)NULL,
PRIMARY KEY(id)
)ENGINE=MyISAM DEFAULT CHARSET=gbk;字段名和字段类型之间都没有空格?
CREATE TABLE blog(
id int(11) NOT NULL auto_increment,
username varchar(20) NOT NULL,
password varchar(20) NOT NULL,
subject varchar(100) NOT NULL,
email varchar(50) NOT NULL,
image varchar(100) NOT NULL,
visitcount int(11) NULL,
PRIMARY KEY(id)
)ENGINE=MyISAM DEFAULT CHARSET=gbk;/*文章分类基本信息表*/
CREATE TABLE sort(
id int(11) NOT NULL auto_increment,
name varchar(40) NOT NULL,
blogid int(11) NOT NULL
REFERENCES blog(id) ON DELETE CASCADE,
PRIMARY KEY (id)
)ENGINE=MyISAM DEFAULT CHARSET=gbk;/*文章基本信息表*/
CREATE TABLE article(
id int(11) NOT NULL auto_increment,
title varchar (20)NOT NULL,
content TEXT NULL,
pubtime DATETIME NOT NULL,
blogid int(11) NOT NULL
REFERENCES blog(id) ON DELETE CASCADE,
sortid int(11) NULL
REFERENCES sort(id) ON DELETE CASCADE,
PRIMARY KEY(id)
)ENGINE=MyISAM DEFAULT CHARSET=gbk;/*评论基本信息表*/
CREATE TABLE feedback(
id int(11) NOT NULL auto_increment,
uname varchar (20)NOT NULL,
content TEXT(5000) NULL,
pubtime DATETIME NOT NULL,
articleid int(11) NOT NULL
REFERENCES article(id) ON DELETE CASCADE,
PRIMARY KEY(id)
)ENGINE=MyISAM DEFAULT CHARSET=gbk;/*友情连接基本信息表*/
CREATE TABLE links(
id int(11) NOT NULL auto_increment,
name varchar(40) NOT NULL,
url varchar(100) NOT NULL,
blogid int(11) NOT NULL
REFERENCES blog(id) ON DELETE CASCADE,
PRIMARY KEY(id)
)ENGINE=MyISAM DEFAULT CHARSET=gbk;/*
其中blogid与blog表的id相关联,
sortid与sort表的id相关联,
articleid与article表的id相关联。
*/
ENGINE=MyISAM DEFAULT CHARSET=gbk
感谢各位的关注!封帖