www.pudn.com > NewsAssurance.rar > news.sql

 
 
 
drop table secondleveltitle 
drop table firstleveltitle 
drop table creater 
go 
create table creater 
( 
c_id numeric identity(1,1) primary key, 
name varchar(30) not null, 
password varchar(30) not null 
) 
go 
create table firstleveltitle 
( 
f_id numeric identity(1,1) primary key, 
titlename varchar(50) not null, 
createrid numeric foreign key references creater(c_id), 
createtime datetime not null 
) 
go 
create table secondleveltitle 
( 
s_id numeric identity(1,1) primary key, 
titlename varchar(100) not null, 
filepath varchar(200) not null, 
createrid numeric not null foreign key references creater(c_id), 
createtime datetime not null, 
patentid numeric not null foreign key references firstleveltitle(f_id) 
) 
go 
insert into creater values('123','123') 
go 
select *from creater 
select *from firstleveltitle 
select *from secondleveltitle 
 
--delete from firstleveltitle 
--delete from secondleveltitle