【SQL开源代码栏目提醒】:网学会员为广大网友收集整理了,work.sql,希望对大家有所帮助!
create table user(user varchar(10) not null,
pass
word varchar(10),
name varchar(20),
sex varchar(2),
mobile varchar(15),
age int,
email varchar(40),
role varchar(1),
remark varchar(200),
superuser int,
constraint pk_user primary key(user));
create table report(
reportid varchar(10) not null,
user varchar(10),
begindate date,
enddate date,
reportdate date,
reportcontent varchar(4000),
verifydate date,
verifycontent varchar(4000),
constraint pk_report primary key(reportid));
insert into user values('0001','888888','
系统管理员','男','',44,'abc@sina.com','1',null,null);
insert into user values('0002','888888','张长','男','',34,'abc@sina.com','0',null,null);
insert into user values('0003','888888','李员','男','',26,'abc@sina.com','0',00001,null);