data.sql

来自「采用jsp+servlet技术」· SQL 代码 · 共 31 行

insert into staff(id,name,email,loginid,password)values(seq_staff.nextval,'admin','','admin','admin');

insert into staff(id,name,email,loginid,password)values(seq_staff.nextval,'lz','','lz','lz');
insert into staff(id,name,email,loginid,password)values(seq_staff.nextval,'后腿宋','','song','song');
insert into staff(id,name,email,loginid,password)values(seq_staff.nextval,'胡涛','','hu','hu');
insert into staff(id,name,email,loginid,password)values(seq_staff.nextval,'李久林','','li','li');



insert into mailstatus(id,name)values(10,'收件人');
insert into mailstatus(id,name)values(11,'抄送人');
insert into mailstatus(id,name)values(12,'密抄人');
insert into mailstatus(id,name)values(13,'发件人');
insert into mailstatus(id,name)values(20,'收件箱');
insert into mailstatus(id,name)values(21,'发件箱');
insert into mailstatus(id,name)values(22,'废件箱');




insert into mail(id,sheme,sizes,isread,importance,content)
values(seq_mail.nextval,'title',2000,0,1,'111111111');

insert into mailrealation(senderid,receiverid,ownerid,mailid,mail_sta,receive_sta,id)
values(1,3,1,seq_mail.currval,21,13,seq_mail_realation.nextval);

insert into maildocument(id,mailid,docname,realpath)
values(seq_maildoc.nextval,seq_mail.currval,'fdfdfsdfdsfsd','ddddddddddddddddddd');

insert into mailrealation(senderid,receiverid,ownerid,mailid,mail_sta,receive_sta,id)
values(1,3,3,seq_mail.currval,20,13,seq_mail_realation.nextval);