forum.sql

来自「电子书店管理系统」· SQL 代码 · 共 6 行

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);