crea_news.sql

凌云新闻LyNews v1.0

use lyfdat;
create table news(
newbt char(80) not null,
newimg char(12) default '' not null,
newnr text not null,
newlx char(1) not null,
newxlh smallint not null,
newdate date not null,
newtime time not null,
newdjcs smallint not null
);
create table news1(
newlxmc varchar(20) not null,
newlx char(1)
);
insert into news1 values('每日要闻','A');
insert into news1 values('国内国际新闻','B');
create table xtsjk(
xtmc char(10) not null,
xlh smallint not null
);
insert into xtsjk values('news','0');