crea.sql

图书管理系统

use lyfdat;
create table wenxue(
bt varchar(255) not null,
nr mediumtext not null,
smxlh smallint not null,
date date not null,
time time not null
);
create table wenxue2(
mc varchar(255) not null,
lx char(1)
);
create table wenxue1(
sm varchar(255) not null,
zz varchar(255) not null,
smxlh smallint(5) unsigned NOT NULL auto_increment,
djcs smallint unsigned not null,
date date not null,
lx char(1),
PRIMARY KEY (smxlh)
);
insert into wenxue2 values('现代小说','A');
insert into wenxue2 values('古典小说','B');
insert into wenxue2 values('武侠小说','C');
insert into wenxue2 values('科幻小说','D');
insert into wenxue2 values('言情小说','E');
insert into wenxue2 values('外国小说','F');
insert into wenxue2 values('其他小说','G');
insert into xtsjk values('wenxue','0');