e_ttoa_init_data.sql

非常完整的Java开发的网络办公系统

-------------------
--人力资源模块数据初始化--
-------------------
INSERT INTO HR_DD(DD_ID,DD_TYPE_ID,DD_NAME,DD_STATE,DD_DESCRIPTION) VALUES(1,2,'临时合同',NULL,'')
;
INSERT INTO HR_DD(DD_ID,DD_TYPE_ID,DD_NAME,DD_STATE,DD_DESCRIPTION) VALUES(2,2,'正式合同',NULL,'')
;
INSERT INTO HR_DD(DD_ID,DD_TYPE_ID,DD_NAME,DD_STATE,DD_DESCRIPTION) VALUES(3,2,'试用期',NULL,'')
;
INSERT INTO HR_DD(DD_ID,DD_TYPE_ID,DD_NAME,DD_STATE,DD_DESCRIPTION) VALUES(4,1,'小学',NULL,'')
;
INSERT INTO HR_DD(DD_ID,DD_TYPE_ID,DD_NAME,DD_STATE,DD_DESCRIPTION) VALUES(5,1,'初中',NULL,'')
;
INSERT INTO HR_DD(DD_ID,DD_TYPE_ID,DD_NAME,DD_STATE,DD_DESCRIPTION) VALUES(6,1,'高中',NULL,'')
;
INSERT INTO HR_DD(DD_ID,DD_TYPE_ID,DD_NAME,DD_STATE,DD_DESCRIPTION) VALUES(7,1,'大学',NULL,'')
;
INSERT INTO HR_DD(DD_ID,DD_TYPE_ID,DD_NAME,DD_STATE,DD_DESCRIPTION) VALUES(8,1,'硕士',NULL,'')
;
INSERT INTO HR_DD(DD_ID,DD_TYPE_ID,DD_NAME,DD_STATE,DD_DESCRIPTION) VALUES(9,1,'博士',NULL,'')
;
INSERT INTO HR_DD(DD_ID,DD_TYPE_ID,DD_NAME,DD_STATE,DD_DESCRIPTION) VALUES(10,3,'合同未生效',NULL,'')
;
INSERT INTO HR_DD(DD_ID,DD_TYPE_ID,DD_NAME,DD_STATE,DD_DESCRIPTION) VALUES(11,3,'合同履行中',NULL,'')
;
INSERT INTO HR_DD(DD_ID,DD_TYPE_ID,DD_NAME,DD_STATE,DD_DESCRIPTION) VALUES(12,3,'合同结束',NULL,'')
;
INSERT INTO HR_DD(DD_ID,DD_TYPE_ID,DD_NAME,DD_STATE,DD_DESCRIPTION) VALUES(13,0,'群众',NULL,'')
;
INSERT INTO HR_DD(DD_ID,DD_TYPE_ID,DD_NAME,DD_STATE,DD_DESCRIPTION) VALUES(14,0,'其他党派',NULL,'')
;
INSERT INTO HR_DD(DD_ID,DD_TYPE_ID,DD_NAME,DD_STATE,DD_DESCRIPTION) VALUES(16,4,'完成',NULL,'')
;
INSERT INTO HR_DD(DD_ID,DD_TYPE_ID,DD_NAME,DD_STATE,DD_DESCRIPTION) VALUES(17,11,'人民币',NULL,'')
;
INSERT INTO HR_DD(DD_ID,DD_TYPE_ID,DD_NAME,DD_STATE,DD_DESCRIPTION) VALUES(15,4,'未完成',NULL,'')
;
INSERT INTO HR_DD(DD_ID,DD_TYPE_ID,DD_NAME,DD_STATE,DD_DESCRIPTION) VALUES(18,11,'美元',NULL,'')
;
INSERT INTO HR_DD(DD_ID,DD_TYPE_ID,DD_NAME,DD_STATE,DD_DESCRIPTION) VALUES(19,0,'中共预备党员',NULL,'')
;
INSERT INTO HR_DD(DD_ID,DD_TYPE_ID,DD_NAME,DD_STATE,DD_DESCRIPTION) VALUES(20,0,'共青团员',NULL,'')
;
INSERT INTO HR_DD(DD_ID,DD_TYPE_ID,DD_NAME,DD_STATE,DD_DESCRIPTION) VALUES(21,0,'民革会员',NULL,'')
;
INSERT INTO HR_DD(DD_ID,DD_TYPE_ID,DD_NAME,DD_STATE,DD_DESCRIPTION) VALUES(22,0,'民盟盟员',NULL,'')
;
INSERT INTO HR_DD(DD_ID,DD_TYPE_ID,DD_NAME,DD_STATE,DD_DESCRIPTION) VALUES(23,0,'民建会员',NULL,'')
;
INSERT INTO HR_DD(DD_ID,DD_TYPE_ID,DD_NAME,DD_STATE,DD_DESCRIPTION) VALUES(24,0,'民进会员',NULL,'')
;
INSERT INTO HR_DD(DD_ID,DD_TYPE_ID,DD_NAME,DD_STATE,DD_DESCRIPTION) VALUES(25,0,'农工党党员',NULL,'')
;
INSERT INTO HR_DD(DD_ID,DD_TYPE_ID,DD_NAME,DD_STATE,DD_DESCRIPTION) VALUES(26,0,'致公党党员',NULL,'')
;
INSERT INTO HR_DD(DD_ID,DD_TYPE_ID,DD_NAME,DD_STATE,DD_DESCRIPTION) VALUES(27,0,'九三学社社员',NULL,'')
;
INSERT INTO HR_DD(DD_ID,DD_TYPE_ID,DD_NAME,DD_STATE,DD_DESCRIPTION) VALUES(28,0,'台盟盟员',NULL,'')
;
INSERT INTO HR_DD(DD_ID,DD_TYPE_ID,DD_NAME,DD_STATE,DD_DESCRIPTION) VALUES(29,0,'无党派民主人士',NULL,'')
;
INSERT INTO HR_DD(DD_ID,DD_TYPE_ID,DD_NAME,DD_STATE,DD_DESCRIPTION) VALUES(30,0,'中国共产党',NULL,'')
;

---------------------
--工作流数据模块初始化--
---------------------
INSERT INTO T_WORKFLOW_STATUS_SPEC(STATUS_ID,STATUS_NAME) VALUES(0,'创建')
;
INSERT INTO T_WORKFLOW_STATUS_SPEC(STATUS_ID,STATUS_NAME) VALUES(1,'执行中')
;
INSERT INTO T_WORKFLOW_STATUS_SPEC(STATUS_ID,STATUS_NAME) VALUES(2,'完成')
;
INSERT INTO T_WORKFLOW_STATUS_SPEC(STATUS_ID,STATUS_NAME) VALUES(3,'回退')
;
INSERT INTO T_WORKFLOW_TYPE_SPEC(TYPE_ID,TYPE_NAME) VALUES(1,'项目管理')
;
INSERT INTO T_WORKFLOW_TYPE_SPEC(TYPE_ID,TYPE_NAME) VALUES(2,'办公室发文')
;
INSERT INTO T_WORKFLOW_TYPE_SPEC(TYPE_ID,TYPE_NAME) VALUES(4,'个人发文')
;
INSERT INTO T_WORKFLOW_TYPE_SPEC(TYPE_ID,TYPE_NAME) VALUES(5,'会议通知')
;
INSERT INTO T_SUBTASK_STATUS_SPEC(STATUS_ID,STATUS_NAME) VALUES(0,'未执行')
;
INSERT INTO T_SUBTASK_STATUS_SPEC(STATUS_ID,STATUS_NAME) VALUES(1,'等待执行')
;
INSERT INTO T_SUBTASK_STATUS_SPEC(STATUS_ID,STATUS_NAME) VALUES(2,'完成')
;
INSERT INTO T_SUBTASK_STATUS_SPEC(STATUS_ID,STATUS_NAME) VALUES(3,'等待回退')
;
INSERT INTO T_SUBTASK_STATUS_SPEC(STATUS_ID,STATUS_NAME) VALUES(4,'回退完成')
;
INSERT INTO T_SUBTASK_TYPE_SPEC(TYPE_ID,TYPE_NAME) VALUES(1,'审批')
;
INSERT INTO T_SUBTASK_TYPE_SPEC(TYPE_ID,TYPE_NAME) VALUES(2,'执行')
;
INSERT INTO T_SUBTASK_TYPE_SPEC(TYPE_ID,TYPE_NAME) VALUES(3,'传阅')
;
INSERT INTO T_SUBTASK_TYPE_SPEC(TYPE_ID,TYPE_NAME) VALUES(4,'撤销')
;
INSERT INTO T_EXECUTOR_STATUS_SPEC(STATUS_ID,STATUS_NAME) VALUES(0,'未执行')
;
INSERT INTO T_EXECUTOR_STATUS_SPEC(STATUS_ID,STATUS_NAME) VALUES(1,'等待执行')
;
INSERT INTO T_EXECUTOR_STATUS_SPEC(STATUS_ID,STATUS_NAME) VALUES(2,'同意')
;
INSERT INTO T_EXECUTOR_STATUS_SPEC(STATUS_ID,STATUS_NAME) VALUES(3,'拒绝')
;
INSERT INTO T_EXECUTOR_STATUS_SPEC(STATUS_ID,STATUS_NAME) VALUES (4,'回退')
;
INSERT INTO T_WORKFLOW_INSTANCY_TYPE(ID,NAME) VALUES(1,'一般')
;
INSERT INTO T_WORKFLOW_INSTANCY_TYPE(ID,NAME) VALUES(2,'急')
;
INSERT INTO T_WORKFLOW_INSTANCY_TYPE(ID,NAME) VALUES(3,'特急')
;
INSERT INTO T_WORKFLOW_SECURITY_TYPE(ID,NAME) VALUES(1,'一般')
;
INSERT INTO T_WORKFLOW_SECURITY_TYPE(ID,NAME) VALUES(2,'秘密')
;
INSERT INTO T_WORKFLOW_SECURITY_TYPE(ID,NAME) VALUES(3,'机密')
;
INSERT INTO T_WORKFLOW_SECURITY_TYPE(ID,NAME) VALUES(4,'绝密')
;
INSERT INTO T_DOC_RECEIVED_TYPE(ID,NAME) VALUES(1,'上级来文')
;
INSERT INTO T_DOC_RECEIVED_TYPE(ID,NAME) VALUES(2,'下级来文')
;
INSERT INTO T_WORKFLOW_TEMPLATE_TYPE_SPEC(TYPE_ID,NAME,DESCRIPTION) VALUES(1,'个人工作流模板','个人工作流模板')
;
INSERT INTO T_WORKFLOW_TEMPLATE_TYPE_SPEC(TYPE_ID,NAME,DESCRIPTION) VALUES(2,'标准工作流模板','标准工作流模板')
;

-------------------
--文档数据模块初始化--
-------------------
INSERT INTO T_ARCHIVE_TYPE_SPEC(ARCHIVE_TYPE_ID,ARCHIVE_TYPE_SPEC) VALUES(1,'合同')
;
INSERT INTO T_ARCHIVE_TYPE_SPEC(ARCHIVE_TYPE_ID,ARCHIVE_TYPE_SPEC) VALUES(2,'协议')
;
INSERT INTO T_ARCHIVE_TYPE_SPEC(ARCHIVE_TYPE_ID,ARCHIVE_TYPE_SPEC) VALUES(3,'正式公文')
;
INSERT INTO T_ARCHIVE_TYPE_SPEC(ARCHIVE_TYPE_ID,ARCHIVE_TYPE_SPEC) VALUES(4,'请示')
; 
INSERT INTO T_ARCHIVE_TYPE_SPEC(ARCHIVE_TYPE_ID,ARCHIVE_TYPE_SPEC) VALUES(5,'汇报')
;

-------------------
--车辆数据模块初始化--
-------------------
INSERT INTO T_AUTOMOBILE_TYPE(TYPE_ID,TYPE_NAME) VALUES(1,'大型客车')
;
INSERT INTO T_AUTOMOBILE_TYPE(TYPE_ID,TYPE_NAME) VALUES(2,'大型货车')
;
INSERT INTO T_AUTOMOBILE_TYPE(TYPE_ID,TYPE_NAME) VALUES(3,'小型客车')
;
INSERT INTO T_AUTOMOBILE_TYPE(TYPE_ID,TYPE_NAME) VALUES(4,'小型货车')
;
INSERT INTO T_AUTOMOBILE_BOOKING_STATUS(STATUS_ID,STATUS_NAME) VALUES(1,'等待')
;
INSERT INTO T_AUTOMOBILE_BOOKING_STATUS(STATUS_ID,STATUS_NAME) VALUES(2,'同意')
;
INSERT INTO T_AUTOMOBILE_BOOKING_STATUS(STATUS_ID,STATUS_NAME) VALUES(3,'拒绝')
;

-------------------
--会议数据模块初始化--
-------------------
INSERT INTO T_CONFERENCE_STATUS(STATUS_ID,STATUS_NAME,DESCRIPTION) VALUES(4,'已被取消',' CANCLED_CONFERENCE ')
;
INSERT INTO T_CONFERENCE_STATUS(STATUS_ID,STATUS_NAME,DESCRIPTION) VALUES(1,'将要召开','NEW_CONFERENCE')
;
INSERT INTO T_CONFERENCE_STATUS(STATUS_ID,STATUS_NAME,DESCRIPTION) VALUES(2,'正在进行','GOINGON_CONFERENCE')
;
INSERT INTO T_CONFERENCE_STATUS(STATUS_ID,STATUS_NAME,DESCRIPTION) VALUES(3,'已结束','FINISHED_CONFERENCE')
;
INSERT INTO T_BOARDROOM_STATUS(STATUS_ID,STATUS_NAME,DESCRIPTION) VALUES(4,'已被预定','BOOKED_BOARDROOM')
;
INSERT INTO T_BOARDROOM_STATUS(STATUS_ID,STATUS_NAME,DESCRIPTION) VALUES(1,'空闲','EMPTY_BOARDROOM')
;
INSERT INTO T_BOARDROOM_STATUS(STATUS_ID,STATUS_NAME,DESCRIPTION) VALUES(2,'正在使用','USING_BOARDROOM')
;
INSERT INTO T_BOARDROOM_STATUS(STATUS_ID,STATUS_NAME,DESCRIPTION) VALUES(3,'停止使用','PAUSED_BOARDROOM')
;

---------------------
--讨论区数据模块初始化--
---------------------
INSERT INTO JIVEUSER(USERID,USERNAME,PASSWORDhASH,NAME,EMAIL,EMAILVISIBLE,NAMEVISIBLE)
 VALUES(1,'Administrator','31313131','管理员','',1,1)
;
INSERT INTO jiveUserPerm(forumID,userID,permission) VALUES(-1,1,0)
;
INSERT INTO jiveUserPerm(forumID,userID,permission) VALUES(-1,1,1)
;
INSERT INTO jiveUserPerm(forumID,userID,permission) VALUES(-1,1,2)
;
INSERT INTO jiveUserPerm(forumID,userID,permission) VALUES(-1,1,3)
;
INSERT INTO jiveUserPerm(forumID,userID,permission) VALUES(-1,1,4)
;
INSERT INTO jiveUserPerm(forumID,userID,permission) VALUES(-1,1,5)
;
INSERT INTO jiveUserPerm(forumID,userID,permission) VALUES(-1,1,6)
;
INSERT INTO jiveUserPerm(forumID,userID,permission) VALUES(-1,1,7)
;

---------------------
--权限模块数据初始化----
---------------------
---***********
---个人办公   *
---***********
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(4001,'权限分发','赋予本部门员工一定的权限','个人办公','普通',9)
;
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(10692,'登记考勤','登记上、下班信息','个人办公',' 普通',1)
;
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(10693,'今日考勤','查看今日考勤信息','个人办公','普通',2)
;
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(10697,'发文','管理个人发文','个人办公','普通',13)
;
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(10698,'待办事宜','目前等待办理的事宜','个人办公','普通',3)
;
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(10699,'已办事宜','查看已经办理的事宜','个人办公','普通',4)
;
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(10700,'日程安排','对未来的工作做出时间安排','个人办公','普通',5)
;
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(10701,'项目管理','管理工程项目','个人办公','普通',14)
;
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES (10702,'档案查询','查询已备案的电子档案','个人办公','普通',10)
;
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(10708,'个人工作流模板','管理个人定义的工作流模板','个人办公','普通',15)
;
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(10720,'密码修改','修改个人密码','个人办公','普通',19)
;
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(11127,'部门预算',' 制定、查看本部门的项目预算 ','个人办公','普通',8)
;
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(11147,'会议安排','制定本人的会议计划','个人办公','普通',7)
;
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)