kk.txt

图书管理系统

use lyfdat;
drop table wenxue;
drop table wenxue1;
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 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)
);