//------------------------------------------------------------------------
//建立"笃信民大"(duxinmd)表
create table md_duxin(id int(10) not null,title varchar(100) not null,
content longblob not null,author varchar(100) not null,posttime date not null);
//建立"好学民大"(haoxuemd)表
//最好前面带上前缀md_,易于维护
create table md_haoxue(id int(10) not null,title varchar(100) not null,
content longblob not null,author varchar(100) not null,posttime date not null);
//建立"自然民大"(zhiranmd)表
create table md_zhiran(id int(10) not null,title varchar(100) not null,
content longblob not null,author varchar(100) not null,posttime date not null);
//建立"宽和民大"(kuanhemd)表
create table md_kuanhe(id int(10) not null,title varchar(100) not null,
content longblob not null,author varchar(100) not null,posttime date not null);
//问题是没建创建表的时候指定普通索引.下面就以id建立index,以title建立索引.
create table md_***(id int(10) not null,title varchar(100) not null,
content longblob not null,author varchar(100) not null,posttime date not null,
index id(id),index title(title));
//-------------------------------------------------------------------------
//建立工“要闻导读”表
create table md_ywdd(id int(10) not null,title varchar(100) not null,
content longblob not null,author varchar(100) not null,posttime date not null,
index id(id),index title(title));
//建立工“公告栏”表
create table md_gg(id int(10) not null,title varchar(100) not null,
content longblob not null,author varchar(100) not null,posttime date not null,
index id(id),index title(title));
//建立工“工作动态”表
create table md_gzdt(id int(10) not null,title varchar(100) not null,
content longblob not null,author varchar(100) not null,posttime date not null,
index id(id),index title(title));
//建立工“专题活动”表
create table md_zthd(id int(10) not null,title varchar(100) not null,
content longblob not null,author varchar(100) not null,posttime date not null,
index id(id),index title(title));
//-------------------------------------------------------------------------