表的定义如下:
create table thesis(
TID int primary key unsigned auto_increment,
FID tinyint,
UID varchar(15),
M_TID int,
title varchar(50),
content text,
index(M_TID),
index(UID),
index(FID)
);
create table thesis(
TID int primary key unsigned auto_increment,
FID tinyint,
UID varchar(15),
M_TID int,
title varchar(50),
content text,
index(M_TID),
index(UID),
index(FID)
);
TID int(10) unsigned zerofill NOT NULL auto_increment,
FID tinyint(4) NOT NULL default '0',
UID varchar(15) NOT NULL default '',
M_TID int(11) NOT NULL default '0',
title varchar(50) NOT NULL default '',
content text NOT NULL,
PRIMARY KEY (TID)
)