-------------------
--人力資源模塊數據初始化--
-------------------
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,'創(chuàng)建')
;
INSERT INTO T_WORKFLOW_STATUS_SPEC(STATUS_ID,STATUS_NAME) VALUES(1,'執(zhí)行中')
;
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,'辦公室發(fā)文')
;
INSERT INTO T_WORKFLOW_TYPE_SPEC(TYPE_ID,TYPE_NAME) VALUES(4,'個人發(fā)文')
;
INSERT INTO T_WORKFLOW_TYPE_SPEC(TYPE_ID,TYPE_NAME) VALUES(5,'會議通知')
;
INSERT INTO T_SUBTASK_STATUS_SPEC(STATUS_ID,STATUS_NAME) VALUES(0,'未執(zhí)行')
;
INSERT INTO T_SUBTASK_STATUS_SPEC(STATUS_ID,STATUS_NAME) VALUES(1,'等待執(zhí)行')
;
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,'執(zhí)行')
;
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,'未執(zhí)行')
;
INSERT INTO T_EXECUTOR_STATUS_SPEC(STATUS_ID,STATUS_NAME) VALUES(1,'等待執(zhí)行')
;
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')
;

---------------------
--討論區(qū)數據模塊初始化--
---------------------
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,'權限分發(fā)','賦予本部門員工一定的權限','個人辦公','普通',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,'發(fā)文','管理個人發(fā)文','個人辦公','普通',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)