green.sql

spring+hibernate+struts开发的校务oa系统

prompt Disabling triggers for USER_GROUPLINK...
alter table USER_GROUPLINK disable all triggers;
prompt Disabling foreign key constraints for OPERATOR...
alter table OPERATOR disable constraint REFPOPEDOM67;
alter table OPERATOR disable constraint REFUSERINFO63;
prompt Disabling foreign key constraints for FORUM...
alter table FORUM disable constraint REFOPERATOR77;
prompt Disabling foreign key constraints for BBSUSER...
alter table BBSUSER disable constraint REFFORUM79;
alter table BBSUSER disable constraint REFOPERATOR80;
prompt Disabling foreign key constraints for TOPIC...
alter table TOPIC disable constraint REFBBSUSER81;
alter table TOPIC disable constraint REFFORUM78;
prompt Disabling foreign key constraints for REPLYTOPIC...
alter table REPLYTOPIC disable constraint REFBBSUSER83;
alter table REPLYTOPIC disable constraint REFTOPIC84;
prompt Disabling foreign key constraints for USER_GROUPLINK...
alter table USER_GROUPLINK disable constraint REFOPERATOR90;
alter table USER_GROUPLINK disable constraint REFUSERGROUP71;
prompt Loading POPEDOM...
insert into POPEDOM (POPEDOMID, PARENTID, IDENTIFIER, NAME, DESCRIPTION)
values (2, null, 'test      ', '测试', '测试');
insert into POPEDOM (POPEDOMID, PARENTID, IDENTIFIER, NAME, DESCRIPTION)
values (0, null, 'sys       ', '系统管理员', null);
insert into POPEDOM (POPEDOMID, PARENTID, IDENTIFIER, NAME, DESCRIPTION)
values (1, null, 'nom       ', '普通用户', null);
insert into POPEDOM (POPEDOMID, PARENTID, IDENTIFIER, NAME, DESCRIPTION)
values (3, null, 'bb        ', '3', null);
insert into POPEDOM (POPEDOMID, PARENTID, IDENTIFIER, NAME, DESCRIPTION)
values (4, null, 'qq        ', '4', null);
insert into POPEDOM (POPEDOMID, PARENTID, IDENTIFIER, NAME, DESCRIPTION)
values (6, null, '....      ', '6', null);
insert into POPEDOM (POPEDOMID, PARENTID, IDENTIFIER, NAME, DESCRIPTION)
values (7, null, '777       ', '7', null);
insert into POPEDOM (POPEDOMID, PARENTID, IDENTIFIER, NAME, DESCRIPTION)
values (8, null, 'apple     ', '8', null);
commit;
prompt 8 records loaded
prompt Loading USERINFO...
insert into USERINFO (USERINFOID, FIRSTNAME, LASTNAME, SEX, AGE, MOBILETEL, TELEPHONE, ADDRESS, DUTY, HOLS)
values (54, '你好', '你好', 'M', 0, 0, 0, null, '你好', 12);
insert into USERINFO (USERINFOID, FIRSTNAME, LASTNAME, SEX, AGE, MOBILETEL, TELEPHONE, ADDRESS, DUTY, HOLS)
values (55, '你好', '你好', 'M', 0, 0, 0, null, '你好', 12);
insert into USERINFO (USERINFOID, FIRSTNAME, LASTNAME, SEX, AGE, MOBILETEL, TELEPHONE, ADDRESS, DUTY, HOLS)
values (56, '你好', '你好', 'M', 0, 0, 0, null, '你好', 12);
insert into USERINFO (USERINFOID, FIRSTNAME, LASTNAME, SEX, AGE, MOBILETEL, TELEPHONE, ADDRESS, DUTY, HOLS)
values (8, '你好', '你好', null, 0, 0, 0, null, '你好', 12);
insert into USERINFO (USERINFOID, FIRSTNAME, LASTNAME, SEX, AGE, MOBILETEL, TELEPHONE, ADDRESS, DUTY, HOLS)
values (9, '你好', '你好', null, 0, 0, 0, null, '你好', 12);
insert into USERINFO (USERINFOID, FIRSTNAME, LASTNAME, SEX, AGE, MOBILETEL, TELEPHONE, ADDRESS, DUTY, HOLS)
values (11, '你好', '你好', null, 0, 0, 0, null, '你好', 12);
insert into USERINFO (USERINFOID, FIRSTNAME, LASTNAME, SEX, AGE, MOBILETEL, TELEPHONE, ADDRESS, DUTY, HOLS)
values (22, 'fdas', 'fasd', 'M', 0, 0, 0, 'dfasf', 'fsa', 0);
insert into USERINFO (USERINFOID, FIRSTNAME, LASTNAME, SEX, AGE, MOBILETEL, TELEPHONE, ADDRESS, DUTY, HOLS)
values (2, 'new NAME', null, null, null, null, null, null, null, null);
insert into USERINFO (USERINFOID, FIRSTNAME, LASTNAME, SEX, AGE, MOBILETEL, TELEPHONE, ADDRESS, DUTY, HOLS)
values (3, 'new NAME', null, null, null, null, null, null, null, 80);
insert into USERINFO (USERINFOID, FIRSTNAME, LASTNAME, SEX, AGE, MOBILETEL, TELEPHONE, ADDRESS, DUTY, HOLS)
values (1, '哈哈', '哈哈', 'M', 25, 22, 222, '222', '哈哈', 20);
insert into USERINFO (USERINFOID, FIRSTNAME, LASTNAME, SEX, AGE, MOBILETEL, TELEPHONE, ADDRESS, DUTY, HOLS)
values (14, '你好', '你好', null, 0, 0, 0, null, '你好', 12);
insert into USERINFO (USERINFOID, FIRSTNAME, LASTNAME, SEX, AGE, MOBILETEL, TELEPHONE, ADDRESS, DUTY, HOLS)
values (15, '你好', '你好', null, 0, 0, 0, null, '你好', 12);
insert into USERINFO (USERINFOID, FIRSTNAME, LASTNAME, SEX, AGE, MOBILETEL, TELEPHONE, ADDRESS, DUTY, HOLS)
values (16, '你好', '你好', null, 0, 0, 0, null, '你好', 12);
insert into USERINFO (USERINFOID, FIRSTNAME, LASTNAME, SEX, AGE, MOBILETEL, TELEPHONE, ADDRESS, DUTY, HOLS)
values (17, '你好', '你好', null, 0, 0, 0, null, '你好', 12);
insert into USERINFO (USERINFOID, FIRSTNAME, LASTNAME, SEX, AGE, MOBILETEL, TELEPHONE, ADDRESS, DUTY, HOLS)
values (18, '你好', '你好', null, 0, 0, 0, null, '你好', 12);
insert into USERINFO (USERINFOID, FIRSTNAME, LASTNAME, SEX, AGE, MOBILETEL, TELEPHONE, ADDRESS, DUTY, HOLS)
values (19, '你好', '你好', null, 0, 0, 0, null, '你好', 12);
insert into USERINFO (USERINFOID, FIRSTNAME, LASTNAME, SEX, AGE, MOBILETEL, TELEPHONE, ADDRESS, DUTY, HOLS)
values (20, '你好', '你好', null, 0, 0, 0, null, '你好', 12);
insert into USERINFO (USERINFOID, FIRSTNAME, LASTNAME, SEX, AGE, MOBILETEL, TELEPHONE, ADDRESS, DUTY, HOLS)
values (0, '0', '0', '0', 0, 0, 0, '0', '0', 0);
insert into USERINFO (USERINFOID, FIRSTNAME, LASTNAME, SEX, AGE, MOBILETEL, TELEPHONE, ADDRESS, DUTY, HOLS)
values (21, '你好', '你好', 'M', 0, 0, 0, null, '你好', 12);
insert into USERINFO (USERINFOID, FIRSTNAME, LASTNAME, SEX, AGE, MOBILETEL, TELEPHONE, ADDRESS, DUTY, HOLS)
values (4, null, null, null, null, null, null, null, null, null);
insert into USERINFO (USERINFOID, FIRSTNAME, LASTNAME, SEX, AGE, MOBILETEL, TELEPHONE, ADDRESS, DUTY, HOLS)
values (5, null, null, null, null, null, null, null, null, null);
insert into USERINFO (USERINFOID, FIRSTNAME, LASTNAME, SEX, AGE, MOBILETEL, TELEPHONE, ADDRESS, DUTY, HOLS)
values (6, null, null, null, null, null, null, null, null, null);
insert into USERINFO (USERINFOID, FIRSTNAME, LASTNAME, SEX, AGE, MOBILETEL, TELEPHONE, ADDRESS, DUTY, HOLS)
values (7, '你好', '你好', null, 0, 0, 0, null, '你好', 12);
insert into USERINFO (USERINFOID, FIRSTNAME, LASTNAME, SEX, AGE, MOBILETEL, TELEPHONE, ADDRESS, DUTY, HOLS)
values (10, '你好', '你好', null, 0, 0, 0, null, '你好', 12);
insert into USERINFO (USERINFOID, FIRSTNAME, LASTNAME, SEX, AGE, MOBILETEL, TELEPHONE, ADDRESS, DUTY, HOLS)
values (12, '你好', '你好', null, 0, 0, 0, null, '你好', 12);
insert into USERINFO (USERINFOID, FIRSTNAME, LASTNAME, SEX, AGE, MOBILETEL, TELEPHONE, ADDRESS, DUTY, HOLS)
values (13, '你好', '你好', null, 0, 0, 0, null, '你好', 12);
insert into USERINFO (USERINFOID, FIRSTNAME, LASTNAME, SEX, AGE, MOBILETEL, TELEPHONE, ADDRESS, DUTY, HOLS)
values (23, '你好', '你好', 'M', 0, 0, 0, null, '你好', 12);
insert into USERINFO (USERINFOID, FIRSTNAME, LASTNAME, SEX, AGE, MOBILETEL, TELEPHONE, ADDRESS, DUTY, HOLS)
values (51, '哈哈', '哈哈', 'M', 25, 22, 222, '222', '哈哈', 86);
insert into USERINFO (USERINFOID, FIRSTNAME, LASTNAME, SEX, AGE, MOBILETEL, TELEPHONE, ADDRESS, DUTY, HOLS)
values (53, '哈哈', '哈哈', 'M', 25, 22, 222, '222', '哈哈', 86);
insert into USERINFO (USERINFOID, FIRSTNAME, LASTNAME, SEX, AGE, MOBILETEL, TELEPHONE, ADDRESS, DUTY, HOLS)
values (57, '你好', '你好', 'M', 0, 0, 0, null, '你好', 12);
insert into USERINFO (USERINFOID, FIRSTNAME, LASTNAME, SEX, AGE, MOBILETEL, TELEPHONE, ADDRESS, DUTY, HOLS)
values (58, '你好', '你好', 'M', 0, 0, 0, null, '你好', 12);
insert into USERINFO (USERINFOID, FIRSTNAME, LASTNAME, SEX, AGE, MOBILETEL, TELEPHONE, ADDRESS, DUTY, HOLS)
values (24, '你好', '你好', 'M', 0, 0, 0, null, '你好', 12);
insert into USERINFO (USERINFOID, FIRSTNAME, LASTNAME, SEX, AGE, MOBILETEL, TELEPHONE, ADDRESS, DUTY, HOLS)
values (25, '你好', '你好', 'M', 0, 0, 0, '中山', '你好', 12);
insert into USERINFO (USERINFOID, FIRSTNAME, LASTNAME, SEX, AGE, MOBILETEL, TELEPHONE, ADDRESS, DUTY, HOLS)
values (26, '你好', '你好', 'M', 0, 0, 0, null, '你好', 12);
insert into USERINFO (USERINFOID, FIRSTNAME, LASTNAME, SEX, AGE, MOBILETEL, TELEPHONE, ADDRESS, DUTY, HOLS)
values (27, '你好', '你好', 'M', 0, 0, 0, null, '你好', 12);
insert into USERINFO (USERINFOID, FIRSTNAME, LASTNAME, SEX, AGE, MOBILETEL, TELEPHONE, ADDRESS, DUTY, HOLS)
values (46, '你好', '你好', 'M', 0, 0, 0, null, '你好', 12);
insert into USERINFO (USERINFOID, FIRSTNAME, LASTNAME, SEX, AGE, MOBILETEL, TELEPHONE, ADDRESS, DUTY, HOLS)
values (47, '你好', '你好', 'M', 0, 0, 0, null, '你好', 12);
insert into USERINFO (USERINFOID, FIRSTNAME, LASTNAME, SEX, AGE, MOBILETEL, TELEPHONE, ADDRESS, DUTY, HOLS)
values (48, '你好', '你好', 'M', 0, 0, 0, null, '你好', 12);
insert into USERINFO (USERINFOID, FIRSTNAME, LASTNAME, SEX, AGE, MOBILETEL, TELEPHONE, ADDRESS, DUTY, HOLS)
values (49, '你好', '你好', 'M', 0, 0, 0, null, '你好', 12);
insert into USERINFO (USERINFOID, FIRSTNAME, LASTNAME, SEX, AGE, MOBILETEL, TELEPHONE, ADDRESS, DUTY, HOLS)
values (50, '你好', '你好', 'M', 0, 0, 0, null, '你好', 12);
insert into USERINFO (USERINFOID, FIRSTNAME, LASTNAME, SEX, AGE, MOBILETEL, TELEPHONE, ADDRESS, DUTY, HOLS)
values (28, '你好', '你好', 'M', 0, 0, 0, '中山', '你好', 12);
insert into USERINFO (USERINFOID, FIRSTNAME, LASTNAME, SEX, AGE, MOBILETEL, TELEPHONE, ADDRESS, DUTY, HOLS)
values (29, '你好', '你好', 'M', 0, 0, 0, '中山', '你好', 12);
insert into USERINFO (USERINFOID, FIRSTNAME, LASTNAME, SEX, AGE, MOBILETEL, TELEPHONE, ADDRESS, DUTY, HOLS)
values (30, '你好', '你好', 'M', 0, 0, 0, '中山', '你好', 12);
insert into USERINFO (USERINFOID, FIRSTNAME, LASTNAME, SEX, AGE, MOBILETEL, TELEPHONE, ADDRESS, DUTY, HOLS)
values (31, '你好', '你好', 'M', 0, 0, 0, '中山', '你好', 12);
insert into USERINFO (USERINFOID, FIRSTNAME, LASTNAME, SEX, AGE, MOBILETEL, TELEPHONE, ADDRESS, DUTY, HOLS)
values (32, '你好', '你好', 'M', 0, 0, 0, '中山', '你好', 12);
insert into USERINFO (USERINFOID, FIRSTNAME, LASTNAME, SEX, AGE, MOBILETEL, TELEPHONE, ADDRESS, DUTY, HOLS)
values (33, '你好', '你好', 'M', 0, 0, 0, '中山', '你好', 12);
insert into USERINFO (USERINFOID, FIRSTNAME, LASTNAME, SEX, AGE, MOBILETEL, TELEPHONE, ADDRESS, DUTY, HOLS)
values (34, '你好', '你好', 'M', 0, 0, 0, '中山', '你好', 12);
insert into USERINFO (USERINFOID, FIRSTNAME, LASTNAME, SEX, AGE, MOBILETEL, TELEPHONE, ADDRESS, DUTY, HOLS)
values (35, '你好', '你好', 'M', 0, 0, 0, null, '你好', 12);
insert into USERINFO (USERINFOID, FIRSTNAME, LASTNAME, SEX, AGE, MOBILETEL, TELEPHONE, ADDRESS, DUTY, HOLS)
values (36, '你好', '你好', 'M', 0, 0, 0, '中山', '你好', 12);
insert into USERINFO (USERINFOID, FIRSTNAME, LASTNAME, SEX, AGE, MOBILETEL, TELEPHONE, ADDRESS, DUTY, HOLS)
values (37, '你好', '你好', 'W', 0, 0, 0, '中山', '你好', 12);
insert into USERINFO (USERINFOID, FIRSTNAME, LASTNAME, SEX, AGE, MOBILETEL, TELEPHONE, ADDRESS, DUTY, HOLS)
values (38, '你好', '你好', 'M', 0, 0, 0, null, '你好', 12);
insert into USERINFO (USERINFOID, FIRSTNAME, LASTNAME, SEX, AGE, MOBILETEL, TELEPHONE, ADDRESS, DUTY, HOLS)
values (39, '你好', '你好', 'M', 0, 0, 0, null, '你好', 12);
insert into USERINFO (USERINFOID, FIRSTNAME, LASTNAME, SEX, AGE, MOBILETEL, TELEPHONE, ADDRESS, DUTY, HOLS)
values (40, '你好', '你好', 'M', 0, 0, 0, null, '你好', 12);
insert into USERINFO (USERINFOID, FIRSTNAME, LASTNAME, SEX, AGE, MOBILETEL, TELEPHONE, ADDRESS, DUTY, HOLS)
values (41, '你好', '你好', 'W', 0, 0, 0, null, '你好', 12);
insert into USERINFO (USERINFOID, FIRSTNAME, LASTNAME, SEX, AGE, MOBILETEL, TELEPHONE, ADDRESS, DUTY, HOLS)
values (42, '你好', '你好', 'W', 0, 0, 0, null, '你好', 12);
insert into USERINFO (USERINFOID, FIRSTNAME, LASTNAME, SEX, AGE, MOBILETEL, TELEPHONE, ADDRESS, DUTY, HOLS)
values (43, '你好', '你好', 'W', 0, 0, 0, null, '你好', 12);
insert into USERINFO (USERINFOID, FIRSTNAME, LASTNAME, SEX, AGE, MOBILETEL, TELEPHONE, ADDRESS, DUTY, HOLS)
values (44, '你好', '你好', 'W', 0, 0, 0, '中山', '你好', 12);
insert into USERINFO (USERINFOID, FIRSTNAME, LASTNAME, SEX, AGE, MOBILETEL, TELEPHONE, ADDRESS, DUTY, HOLS)
values (45, '你好', '你好', 'W', 13, 0, 0, '中山', '你好', 12);
commit;
prompt 58 records loaded
prompt Loading OPERATOR...
insert into OPERATOR (OPERATORID, USERNAME, PASSWORD, RGISTERTIME, STOPTIME, STATE, LOGINCOUNT, USERINFOID, POPEDOMID)
values (3, 'Allan', '123', null, null, 2, 282, 1, 1);
insert into OPERATOR (OPERATORID, USERNAME, PASSWORD, RGISTERTIME, STOPTIME, STATE, LOGINCOUNT, USERINFOID, POPEDOMID)
values (66, 'cjrlt', '123', to_date('07-03-2007 18:22:03', 'dd-mm-yyyy hh24:mi:ss'), null, 2, 3, 1, 1);
insert into OPERATOR (OPERATORID, USERNAME, PASSWORD, RGISTERTIME, STOPTIME, STATE, LOGINCOUNT, USERINFOID, POPEDOMID)
values (1, 'admin', 'admin', null, null, 2, 76, 1, 0);
insert into OPERATOR (OPERATORID, USERNAME, PASSWORD, RGISTERTIME, STOPTIME, STATE, LOGINCOUNT, USERINFOID, POPEDOMID)
values (10, 'aaa', '123456', to_date('02-03-2007 12:28:05', 'dd-mm-yyyy hh24:mi:ss'), null, 2, 5, 43, 2);
insert into OPERATOR (OPERATORID, USERNAME, PASSWORD, RGISTERTIME, STOPTIME, STATE, LOGINCOUNT, USERINFOID, POPEDOMID)
values (11, 'abc', '123456', to_date('02-03-2007 12:38:05', 'dd-mm-yyyy hh24:mi:ss'), null, 1, 1, 45, 2);
insert into OPERATOR (OPERATORID, USERNAME, PASSWORD, RGISTERTIME, STOPTIME, STATE, LOGINCOUNT, USERINFOID, POPEDOMID)
values (67, 'all', '123456', to_date('16-03-2007 10:24:08', 'dd-mm-yyyy hh24:mi:ss'), null, 2, 0, 23, 2);
insert into OPERATOR (OPERATORID, USERNAME, PASSWORD, RGISTERTIME, STOPTIME, STATE, LOGINCOUNT, USERINFOID, POPEDOMID)
values (74, 'vbvbvb', null, to_date('17-03-2007 15:28:05', 'dd-mm-yyyy hh24:mi:ss'), null, 2, 0, 58, 2);
insert into OPERATOR (OPERATORID, USERNAME, PASSWORD, RGISTERTIME, STOPTIME, STATE, LOGINCOUNT, USERINFOID, POPEDOMID)
values (68, 'a', '123456', to_date('16-03-2007 13:51:10', 'dd-mm-yyyy hh24:mi:ss'), null, 2, 0, 27, 2);
insert into OPERATOR (OPERATORID, USERNAME, PASSWORD, RGISTERTIME, STOPTIME, STATE, LOGINCOUNT, USERINFOID, POPEDOMID)
values (69, 'aa', '123456', to_date('16-03-2007 14:54:48', 'dd-mm-yyyy hh24:mi:ss'), null, 2, 1, 35, 2);
insert into OPERATOR (OPERATORID, USERNAME, PASSWORD, RGISTERTIME, STOPTIME, STATE, LOGINCOUNT, USERINFOID, POPEDOMID)
values (72, 'vv', '123456', to_date('16-03-2007 16:15:55', 'dd-mm-yyyy hh24:mi:ss'), null, 2, 1, 40, 0);
commit;
prompt 10 records loaded
prompt Loading FORUM...
prompt Table is empty
prompt Loading BBSUSER...
prompt Table is empty
prompt Loading CONTENT...
prompt Table is empty
prompt Loading EQUIPMENTAPPLY...
prompt Table is empty
prompt Loading GREENSYSPARAM...
insert into GREENSYSPARAM (GREENSYSPARAMID, GCODE, MCODE, MNAME, PARAM1, PARAM2, PARAM3, STATE, NUMS)
values (16, 'SFlag', 'S', '发送', null, null, null, null, null);
insert into GREENSYSPARAM (GREENSYSPARAMID, GCODE, MCODE, MNAME, PARAM1, PARAM2, PARAM3, STATE, NUMS)
values (17, 'SFlag', 'R', '接收', null, null, null, null, null);
insert into GREENSYSPARAM (GREENSYSPARAMID, GCODE, MCODE, MNAME, PARAM1, PARAM2, PARAM3, STATE, NUMS)
values (8, 'IsCheck', '0', '未审核', null, null, null, null, null);
insert into GREENSYSPARAM (GREENSYSPARAMID, GCODE, MCODE, MNAME, PARAM1, PARAM2, PARAM3, STATE, NUMS)
values (6, 'Hols', '1', '事假', null, null, null, null, null);
insert into GREENSYSPARAM (GREENSYSPARAMID, GCODE, MCODE, MNAME, PARAM1, PARAM2, PARAM3, STATE, NUMS)
values (7, 'Hols', '2', '病假', null, null, null, null, null);
insert into GREENSYSPARAM (GREENSYSPARAMID, GCODE, MCODE, MNAME, PARAM1, PARAM2, PARAM3, STATE, NUMS)
values (5, 'Hols', '0', '公休', null, null, null, null, null);
insert into GREENSYSPARAM (GREENSYSPARAMID, GCODE, MCODE, MNAME, PARAM1, PARAM2, PARAM3, STATE, NUMS)
values (9, 'IsCheck', '1', '已审核', null, null, null, null, null);
insert into GREENSYSPARAM (GREENSYSPARAMID, GCODE, MCODE, MNAME, PARAM1, PARAM2, PARAM3, STATE, NUMS)
values (3, 'MessageType', 'P', '公告信息', null, null, null, null, null);
insert into GREENSYSPARAM (GREENSYSPARAMID, GCODE, MCODE, MNAME, PARAM1, PARAM2, PARAM3, STATE, NUMS)
values (14, 'IsPass', '0', '未通过', null, null, null, null, null);
insert into GREENSYSPARAM (GREENSYSPARAMID, GCODE, MCODE, MNAME, PARAM1, PARAM2, PARAM3, STATE, NUMS)
values (4, 'MessageType', 'C', '普通信息', null, null, null, null, null);
insert into GREENSYSPARAM (GREENSYSPARAMID, GCODE, MCODE, MNAME, PARAM1, PARAM2, PARAM3, STATE, NUMS)
values (15, 'IsPass', '1', '已通过', null, null, null, null, null);
insert into GREENSYSPARAM (GREENSYSPARAMID, GCODE, MCODE, MNAME, PARAM1, PARAM2, PARAM3, STATE, NUMS)
values (10, 'IsRead', '1', '已查看', null, null, null, null, null);
insert into GREENSYSPARAM (GREENSYSPARAMID, GCODE, MCODE, MNAME, PARAM1, PARAM2, PARAM3, STATE, NUMS)
values (11, 'IsRead', '0', '未查看', null, null, null, null, null);
insert into GREENSYSPARAM (GREENSYSPARAMID, GCODE, MCODE, MNAME, PARAM1, PARAM2, PARAM3, STATE, NUMS)
values (12, 'IsFinish', '0', '未完成', null, null, null, null, null);
insert into GREENSYSPARAM (GREENSYSPARAMID, GCODE, MCODE, MNAME, PARAM1, PARAM2, PARAM3, STATE, NUMS)
values (13, 'IsFinish', '1', '已完成', null, null, null, null, null);
insert into GREENSYSPARAM (GREENSYSPARAMID, GCODE, MCODE, MNAME, PARAM1, PARAM2, PARAM3, STATE, NUMS)
values (1, 'State', '0', '禁用', null, null, null, null, null);
insert into GREENSYSPARAM (GREENSYSPARAMID, GCODE, MCODE, MNAME, PARAM1, PARAM2, PARAM3, STATE, NUMS)
values (2, 'State', '1', '正常', null, null, null, null, null);
commit;
prompt 17 records loaded
prompt Loading HOLSAPPLY...
insert into HOLSAPPLY (HOLSAPPLYID, APPLYTIME, TYPE, APPLYCAUSE, STARTTIME, ENDTIME, COUNT, APPLYOP, REPLYOP, ISREAD, ISCHECK, SFLAG)
values (16, null, 6, '2', to_date('17-03-2007', 'dd-mm-yyyy'), to_date('17-03-2007', 'dd-mm-yyyy'), null, 3, 66, 11, 8, 17);
insert into HOLSAPPLY (HOLSAPPLYID, APPLYTIME, TYPE, APPLYCAUSE, STARTTIME, ENDTIME, COUNT, APPLYOP, REPLYOP, ISREAD, ISCHECK, SFLAG)
values (15, null, 6, '2', to_date('17-03-2007', 'dd-mm-yyyy'), to_date('17-03-2007', 'dd-mm-yyyy'), null, 3, 66, 11, 8, 16);
insert into HOLSAPPLY (HOLSAPPLYID, APPLYTIME, TYPE, APPLYCAUSE, STARTTIME, ENDTIME, COUNT, APPLYOP, REPLYOP, ISREAD, ISCHECK, SFLAG)
values (17, null, 6, '1', to_date('17-03-2007', 'dd-mm-yyyy'), to_date('24-03-2007', 'dd-mm-yyyy'), null, 3, 3, 11, 8, 16);
insert into HOLSAPPLY (HOLSAPPLYID, APPLYTIME, TYPE, APPLYCAUSE, STARTTIME, ENDTIME, COUNT, APPLYOP, REPLYOP, ISREAD, ISCHECK, SFLAG)
values (18, null, 6, '1', to_date('17-03-2007', 'dd-mm-yyyy'), to_date('24-03-2007', 'dd-mm-yyyy'), null, 3, 3, 11, 8, 17);
insert into HOLSAPPLY (HOLSAPPLYID, APPLYTIME, TYPE, APPLYCAUSE, STARTTIME, ENDTIME, COUNT, APPLYOP, REPLYOP, ISREAD, ISCHECK, SFLAG)
values (19, null, 7, '2', to_date('17-03-2007', 'dd-mm-yyyy'), to_date('18-03-2007', 'dd-mm-yyyy'), null, 3, 66, 11, 8, 16);
insert into HOLSAPPLY (HOLSAPPLYID, APPLYTIME, TYPE, APPLYCAUSE, STARTTIME, ENDTIME, COUNT, APPLYOP, REPLYOP, ISREAD, ISCHECK, SFLAG)
values (20, null, 7, '2', to_date('17-03-2007', 'dd-mm-yyyy'), to_date('18-03-2007', 'dd-mm-yyyy'), null, 3, 66, 11, 8, 17);
commit;
prompt 6 records loaded
prompt Loading LOGIDIO...
prompt Table is empty
prompt Loading LOGWORK...
prompt Table is empty
prompt Loading MANGLEAPPLY...
prompt Table is empty
prompt Loading MESSAGE...
insert into MESSAGE (MESSAGEID, TITLE, CONTENT, SENDOP, RECEVIEOP, FILEPATH, TYPE, ISREAD, SENDTIME, SFLAG)
values (23, 'title', '333', 66, 3, null, 4, 10, null, null);
insert into MESSAGE (MESSAGEID, TITLE, CONTENT, SENDOP, RECEVIEOP, FILEPATH, TYPE, ISREAD, SENDTIME, SFLAG)
values (10, null, 'sssssss', null, null, null, null, null, null, null);
insert into MESSAGE (MESSAGEID, TITLE, CONTENT, SENDOP, RECEVIEOP, FILEPATH, TYPE, ISREAD, SENDTIME, SFLAG)
values (14, 'xxxxxxxx', 'sssssssssss', 3, 66, null, 4, 10, null, null);
insert into MESSAGE (MESSAGEID, TITLE, CONTENT, SENDOP, RECEVIEOP, FILEPATH, TYPE, ISREAD, SENDTIME, SFLAG)
values (16, 'cjr', 'sssssssssss', 3, 66, null, 4, 10, null, null);
insert into MESSAGE (MESSAGEID, TITLE, CONTENT, SENDOP, RECEVIEOP, FILEPATH, TYPE, ISREAD, SENDTIME, SFLAG)
values (17, 'xxxxxxxx', 'sssssssssss', 3, 66, null, 4, 10, null, null);
insert into MESSAGE (MESSAGEID, TITLE, CONTENT, SENDOP, RECEVIEOP, FILEPATH, TYPE, ISREAD, SENDTIME, SFLAG)
values (1, '好好', '好好', 3, null, null, 3, 10, null, null);
insert into MESSAGE (MESSAGEID, TITLE, CONTENT, SENDOP, RECEVIEOP, FILEPATH, TYPE, ISREAD, SENDTIME, SFLAG)
values (2, '不好', 'bb', 3, null, null, 3, 10, null, null);
insert into MESSAGE (MESSAGEID, TITLE, CONTENT, SENDOP, RECEVIEOP, FILEPATH, TYPE, ISREAD, SENDTIME, SFLAG)
values (3, 'aa', '好好', 3, 66, null, 4, 10, null, null);
insert into MESSAGE (MESSAGEID, TITLE, CONTENT, SENDOP, RECEVIEOP, FILEPATH, TYPE, ISREAD, SENDTIME, SFLAG)
values (11, null, null, null, null, null, null, null, null, null);
insert into MESSAGE (MESSAGEID, TITLE, CONTENT, SENDOP, RECEVIEOP, FILEPATH, TYPE, ISREAD, SENDTIME, SFLAG)
values (12, null, null, null, null, null, null, null, null, null);
insert into MESSAGE (MESSAGEID, TITLE, CONTENT, SENDOP, RECEVIEOP, FILEPATH, TYPE, ISREAD, SENDTIME, SFLAG)
values (13, 'xxxxxxxx', 'sssssssssss', null, null, null, null, null, null, null);
insert into MESSAGE (MESSAGEID, TITLE, CONTENT, SENDOP, RECEVIEOP, FILEPATH, TYPE, ISREAD, SENDTIME, SFLAG)
values (6, 'Test', 'TestTestTest', 66, 3, null, 4, 10, to_date('02-02-2007', 'dd-mm-yyyy'), null);
insert into MESSAGE (MESSAGEID, TITLE, CONTENT, SENDOP, RECEVIEOP, FILEPATH, TYPE, ISREAD, SENDTIME, SFLAG)
values (4, '22', '222', 66, 3, null, 3, 11, to_date('09-09-2009', 'dd-mm-yyyy'), null);
commit;
prompt 13 records loaded
prompt Loading TOPIC...
prompt Table is empty
prompt Loading REPLYTOPIC...
prompt Table is empty
prompt Loading TRANSACTION...
insert into TRANSACTION (TRANSACTIONID, TITLE, CONTENT, SENDTIME, FINISHTIME, FINISHTIME2, TRANBEGINTIME, TRANENDTIME, SENDOP, RECEVIEOP, ISCHECK, ISFINISH, ISREAD, REMARK, ISPASS, PREID, SFLAG)
values (49, '申请4', 'xxx', to_date('14-03-2007 09:50:53', 'dd-mm-yyyy hh24:mi:ss'), null, null, to_date('14-03-2007', 'dd-mm-yyyy'), to_date('15-03-2007', 'dd-mm-yyyy'), 3, 1, null, 12, 11, null, null, -1, null);
insert into TRANSACTION (TRANSACTIONID, TITLE, CONTENT, SENDTIME, FINISHTIME, FINISHTIME2, TRANBEGINTIME, TRANENDTIME, SENDOP, RECEVIEOP, ISCHECK, ISFINISH, ISREAD, REMARK, ISPASS, PREID, SFLAG)
values (47, '444', '444', to_date('12-03-2007 10:21:57', 'dd-mm-yyyy hh24:mi:ss'), null, null, to_date('15-03-2007', 'dd-mm-yyyy'), to_date('16-03-2007', 'dd-mm-yyyy'), 3, 10, null, 13, 10, null, null, 43, null);
insert into TRANSACTION (TRANSACTIONID, TITLE, CONTENT, SENDTIME, FINISHTIME, FINISHTIME2, TRANBEGINTIME, TRANENDTIME, SENDOP, RECEVIEOP, ISCHECK, ISFINISH, ISREAD, REMARK, ISPASS, PREID, SFLAG)
values (48, '555', '555', to_date('12-03-2007 10:33:08', 'dd-mm-yyyy hh24:mi:ss'), null, null, to_date('15-03-2007', 'dd-mm-yyyy'), to_date('16-03-2007', 'dd-mm-yyyy'), 3, 3, null, 12, 10, null, null, -1, null);
insert into TRANSACTION (TRANSACTIONID, TITLE, CONTENT, SENDTIME, FINISHTIME, FINISHTIME2, TRANBEGINTIME, TRANENDTIME, SENDOP, RECEVIEOP, ISCHECK, ISFINISH, ISREAD, REMARK, ISPASS, PREID, SFLAG)
values (46, '申请3', '申请3申请3申请3申请3', to_date('14-03-2007 10:20:54', 'dd-mm-yyyy hh24:mi:ss'), null, null, to_date('12-03-2007', 'dd-mm-yyyy'), to_date('17-03-2007', 'dd-mm-yyyy'), 3, 3, 9, null, 10, null, 14, -1, null);
insert into TRANSACTION (TRANSACTIONID, TITLE, CONTENT, SENDTIME, FINISHTIME, FINISHTIME2, TRANBEGINTIME, TRANENDTIME, SENDOP, RECEVIEOP, ISCHECK, ISFINISH, ISREAD, REMARK, ISPASS, PREID, SFLAG)
values (44, '申请1', '申请1', to_date('12-03-2007 10:15:03', 'dd-mm-yyyy hh24:mi:ss'), null, null, to_date('31-03-2007', 'dd-mm-yyyy'), to_date('01-05-2007', 'dd-mm-yyyy'), 3, 3, 8, null, 11, null, null, -1, null);
insert into TRANSACTION (TRANSACTIONID, TITLE, CONTENT, SENDTIME, FINISHTIME, FINISHTIME2, TRANBEGINTIME, TRANENDTIME, SENDOP, RECEVIEOP, ISCHECK, ISFINISH, ISREAD, REMARK, ISPASS, PREID, SFLAG)
values (45, '申请2', '申请2', to_date('13-03-2007 10:15:53', 'dd-mm-yyyy hh24:mi:ss'), null, null, to_date('29-03-2007', 'dd-mm-yyyy'), to_date('30-03-2007', 'dd-mm-yyyy'), 3, 3, 9, null, 10, null, 15, -1, null);
insert into TRANSACTION (TRANSACTIONID, TITLE, CONTENT, SENDTIME, FINISHTIME, FINISHTIME2, TRANBEGINTIME, TRANENDTIME, SENDOP, RECEVIEOP, ISCHECK, ISFINISH, ISREAD, REMARK, ISPASS, PREID, SFLAG)
values (42, '123', '123', to_date('12-03-2007 10:12:16', 'dd-mm-yyyy hh24:mi:ss'), null, null, to_date('13-03-2007', 'dd-mm-yyyy'), to_date('14-03-2007', 'dd-mm-yyyy'), 3, 3, null, 13, 10, null, null, -1, null);
insert into TRANSACTION (TRANSACTIONID, TITLE, CONTENT, SENDTIME, FINISHTIME, FINISHTIME2, TRANBEGINTIME, TRANENDTIME, SENDOP, RECEVIEOP, ISCHECK, ISFINISH, ISREAD, REMARK, ISPASS, PREID, SFLAG)
values (43, '333', '333', to_date('12-03-2007 10:13:08', 'dd-mm-yyyy hh24:mi:ss'), null, null, to_date('13-03-2007', 'dd-mm-yyyy'), to_date('31-03-2007', 'dd-mm-yyyy'), 3, 3, null, 13, 10, null, null, -1, null);
commit;
prompt 8 records loaded
prompt Loading USERGROUP...
insert into USERGROUP (USERGROUPID, GROUPNAME, DESCRIPTION)
values (16, 'bb', 'bb');
insert into USERGROUP (USERGROUPID, GROUPNAME, DESCRIPTION)
values (17, 'cc', 'cc');
insert into USERGROUP (USERGROUPID, GROUPNAME, DESCRIPTION)
values (18, 'g', 'g');
insert into USERGROUP (USERGROUPID, GROUPNAME, DESCRIPTION)
values (13, 'test', 'test');
insert into USERGROUP (USERGROUPID, GROUPNAME, DESCRIPTION)
values (15, 't', 't');
insert into USERGROUP (USERGROUPID, GROUPNAME, DESCRIPTION)
values (11, 'aa', null);
commit;
prompt 6 records loaded
prompt Loading USER_GROUPLINK...
insert into USER_GROUPLINK (USER_GROUPLINKID, USERGROUPID, OPERATORID)
values (3, 17, 74);
commit;
prompt 1 records loaded
prompt Enabling foreign key constraints for OPERATOR...
alter table OPERATOR enable constraint REFPOPEDOM67;
alter table OPERATOR enable constraint REFUSERINFO63;
prompt Enabling foreign key constraints for FORUM...
alter table FORUM enable constraint REFOPERATOR77;
prompt Enabling foreign key constraints for BBSUSER...
alter table BBSUSER enable constraint REFFORUM79;
alter table BBSUSER enable constraint REFOPERATOR80;
prompt Enabling foreign key constraints for TOPIC...
alter table TOPIC enable constraint REFBBSUSER81;
alter table TOPIC enable constraint REFFORUM78;
prompt Enabling foreign key constraints for REPLYTOPIC...
alter table REPLYTOPIC enable constraint REFBBSUSER83;
alter table REPLYTOPIC enable constraint REFTOPIC84;
prompt Enabling foreign key constraints for USER_GROUPLINK...
alter table USER_GROUPLINK enable constraint REFOPERATOR90;
alter table USER_GROUPLINK enable constraint REFUSERGROUP71;
prompt Enabling triggers for POPEDOM...
alter table POPEDOM enable all triggers;
prompt Enabling triggers for USERINFO...
alter table USERINFO enable all triggers;
prompt Enabling triggers for OPERATOR...
alter table OPERATOR enable all triggers;
prompt Enabling triggers for FORUM...
alter table FORUM enable all triggers;
prompt Enabling triggers for BBSUSER...
alter table BBSUSER enable all triggers;
prompt Enabling triggers for CONTENT...
alter table CONTENT enable all triggers;
prompt Enabling triggers for EQUIPMENTAPPLY...
alter table EQUIPMENTAPPLY enable all triggers;
prompt Enabling triggers for GREENSYSPARAM...
alter table GREENSYSPARAM enable all triggers;
prompt Enabling triggers for HOLSAPPLY...
alter table HOLSAPPLY enable all triggers;
prompt Enabling triggers for LOGIDIO...
alter table LOGIDIO enable all triggers;
prompt Enabling triggers for LOGWORK...
alter table LOGWORK enable all triggers;
prompt Enabling triggers for MANGLEAPPLY...
alter table MANGLEAPPLY enable all triggers;
prompt Enabling triggers for MESSAGE...
alter table MESSAGE enable all triggers;
prompt Enabling triggers for TOPIC...
alter table TOPIC enable all triggers;
prompt Enabling triggers for REPLYTOPIC...
alter table REPLYTOPIC enable all triggers;
prompt Enabling triggers for TRANSACTION...
alter table TRANSACTION enable all triggers;
prompt Enabling triggers for USERGROUP...
alter table USERGROUP enable all triggers;
prompt Enabling triggers for USER_GROUPLINK...
alter table USER_GROUPLINK enable all triggers;
set feedback on
set define on
prompt Done.