forum.sql

· 电子书店管理系统 很容易学习!!初学者的天堂

create table topic(id varchar(30) not null,title varchar(100),author varchar(30),email varchar(50),content varchar(1000),pubtime datetime default getdate(),constraint pk_topic primary key(id));

create table reply(id varchar(30) not null,topicId varchar(30),title varchar(100),author varchar(30),email varchar(50),content varchar(1000),pubtime datetime default getdate(),constraint pk_reply primary key(id),constraint fk_reply_1 foreign key (topicId)references topic(id));

create index topic on topic (id);
create index reply on reply (id);