e_ttoa_init_data.sql

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

 VALUES(11149,'个人信息','查看个人的信息','个人办公','普通',16)
;
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(11150,'车辆预订','对可预见的用车时间进行约定','个人办公','普通',6)
;
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(11420,'滚动消息管理','管理个人的滚动消息','个人办公','普通',11)
;
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(11426,'公告板查询','查询公告板信息','个人办公','普通',12)
;
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(11160,'个人工资福利保险','统计个人的工资福利保险信息','个人办公','普通',17)
;
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(11161,'个人通信录','管理个人的通信录','个人办公','普通',18)
;

---***********
---通信       *
---***********
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(10694,'公告板','发布个人的公告信息','通信','普通',20)
;
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(10695,'留言板','发布留言的场所','通信','普通',22)
;
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(10696,'消息板','发布消息的场所','通信','普通',23)
;
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(11164,'讨论区','自由发表意见的场所','通信','普通',21)
;
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(11165,'讨论区管理','管理讨论区，需有讨论区管理员权限','通信','普通',24)
;


---***********
---档案管理   *
---***********
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(3001,'档案管理','管理日常工作的各种文档资料','档案','普通',25)
;
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(3002,'借阅管理','管理文档资料的借阅情况','档案','普通',26)
;
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(11162,'归还管理','管理文档资料的归还情况','档案','普通',27)
;

---***********
---领导查询     *
---***********
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(11140,'信息查询','公司领导查询各部门发布的信息','领导查询','普通',28)
;
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(11141,'信息维护','维护各部门发布的供领导查询的信息','领导查询','普通',29)
;

---***********
---人事管理   *
---***********
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(1000,'组织结构与职位','管理公司组织结构与职位，设置权限','人力资源','普通',30)
;
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(1001,'权限说明','对权限的描述','人力资源','普通',31)
;
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(10681,'工资项目设置','设置员工的工资结构','人力资源','普通',34)
;
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(10682,'员工培训','管理员工的培训信息','人力资源','普通',36)
;
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(11144,'员工信息','管理在职员工的个人信息','人力资源','普通',32)
;
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(11145,'离职员工信息','管理离职员工的个人信息','人力资源','普通',33)
;
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(11146,'薪酬统计','查询员工的薪酬信息','人力资源','普通',35)
;
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(11167,'员工培训统计','统计员工的培训信息','人力资源','普通',37)
;
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(11500,'部门考勤时间设置','部门考勤时间设置','人力资源','普通',37)
;
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(20001,'','指定日期考勤统计','人力资源','普通',37)
;
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(20002,'','指定员工考勤统计','人力资源','普通',37)
;
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(20003,'','所有员工考勤统计','人力资源','普通',37)
;
--****************
--部门考勤时间设置
--****************
INSERT INTO T_DIV_ATT_MODE (ON_DUTY_MODE,OFF_DUTY_MODE)
VALUES( 'MIN','MAX')



---***********
---办公室     *
---***********
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(2001,'收发文管理','办公室收文,发文的管理','办公室','普通',39)
;
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(11163,'固定资产管理','管理公司的固定资产','办公室','普通',38)
;
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(2002,'公用信息维护','维护公司及各部门发布的规章制度,办事指南,内部发行的刊物,客户通信录','办公室','普通',40) 
;
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(11143,'会议室管理','管理公司会议室信息','办公室','普通',47)
;
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(11148,'会议室预定查询','查询预定会议室情况','办公室','普通',48)
;

INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(11151,'车辆管理','管理公司车辆信息','办公室','普通',42)
;
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(11155,'车辆预定管理','管理公司车辆预订信息','办公室','普通',43)
;
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(11156,'司机管理','管理公司司机','办公室','普通',44)
;
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES (11157,'车辆出勤登记','登记公司车辆出勤情况','办公室','普通',45)
;
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(11158,'车辆行使费用','管理公司车辆行使信息','办公室','普通',46)
;
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(11421,'员工通信组维护','维护公司员工通信组','办公室','普通',41)
;


---***********
---财务       *
---***********
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(11126,'项目维护','管理公司各部门的项目费用预算','财务','普通',49)
;
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(11132,'统计查看','汇总或查看各部门预算的使用情况','财务','普通',50)
;


---***********
---公用信息   *
---***********
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(10704,'规章制度','查看公司及各部门发布的规章制度','公用信息','普通',53)
;
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(10705,'办事指南','查看公司为员工提供的办事指南','公用信息','普通',54)
;
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(10706,'外部通讯录','查看公司客户通信录','公用信息','普通',52)
;
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(10707,'内部刊物','查看公司内部发行的刊物','公用信息','普通',55)
;
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(11168,'员工通信录','查看公司员工通信录','公用信息','普通',51)
;

---***********
---系统管理   *
---***********
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(6001,'数据字典管理','管理系统数据字典','系统管理','普通',56)
;
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(11391,'系统参数设置','设置系统参数','系统管理','普通',57)
;
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(10689,'标准工作流模板维护','管理标准工作流模板','系统管理','普通',58)
;



---------------------
--组织结构模块数据初始化-
---------------------
INSERT INTO T_DIRECTORIES
(DIRECTORY_ID,DIRECTORY_NAME,SUPER_DIRECTORY_ID,OWNER_ID,IS_LEAF,
 CREATE_DATE,WRITE_CONTROL,READ_CONTROL,TYPE)
 VALUES(1,'root',NULL,10000,0,NULL,1,0,0)
;

INSERT INTO T_DIVISION
(DIVISION_ID,P_DIVISION_ID,DIVISION_NAME,LOCATION,TELEPHONE,
 FAX,ZIP_CODE,PROVINCE,CITY,MANAGER_ID,DIVISION_DUTY,EMAIL,DIVISION_TYPE)
 VALUES(1,NULL,'铁通总公司','','','','','','',10000,'','','')
;
INSERT INTO T_DIVISION
(DIVISION_ID,P_DIVISION_ID,DIVISION_NAME,LOCATION,TELEPHONE,FAX,ZIP_CODE,
PROVINCE,CITY,MANAGER_ID,DIVISION_DUTY,EMAIL,DIVISION_TYPE) 
 VALUES(2,1,'人事部','','','','','','',10000,'','','')
;
--**********************************************************
-- Creating the "Administrator" account of Net-Office System.
--**********************************************************
INSERT INTO T_EMP(EMP_ID,TITLE,NAME,USERNAME,DIVISION_ID,PASSWORD) VALUES(10000,'','管理员','Administrator',2,'b59c67bf196a4758191e42f76670ceba')

;
---------------------
--职位权限模块数据初始化-
---------------------
INSERT INTO T_DUTY(DUTY_ID,DIVISION_ID,DUTY_TITLE,CURRENT_NUMBER) VALUES(10000,2,'人事部门经理',1)
;
INSERT INTO T_DUTY_X_PRIVILEGE(DUTY_ID,PRIVILEGE_ID,ASSIGNER_NO) VALUES(10000,1000,10000)
;
INSERT INTO T_DUTY_X_PRIVILEGE(DUTY_ID,PRIVILEGE_ID,ASSIGNER_NO) VALUES(10000,1001,10000)
;
INSERT INTO T_DUTY_X_PRIVILEGE(DUTY_ID,PRIVILEGE_ID,ASSIGNER_NO) VALUES(10000,11144,10000)
;
INSERT INTO T_DUTY_X_PRIVILEGE(DUTY_ID,PRIVILEGE_ID,ASSIGNER_NO) VALUES(10000,11145,10000)
;
INSERT INTO T_DUTY_X_PRIVILEGE(DUTY_ID,PRIVILEGE_ID,ASSIGNER_NO) VALUES(10000,11146,10000)
;
INSERT INTO T_DUTY_X_PRIVILEGE(DUTY_ID,PRIVILEGE_ID,ASSIGNER_NO) VALUES(10000,10681,10000)
;
INSERT INTO T_DUTY_X_PRIVILEGE(DUTY_ID,PRIVILEGE_ID,ASSIGNER_NO) VALUES(10000,10682,10000)
;
INSERT INTO T_DUTY_X_PRIVILEGE(DUTY_ID,PRIVILEGE_ID,ASSIGNER_NO) VALUES(10000,11167,10000)
;
INSERT INTO T_EMP_X_DUTY(EMP_ID,DUTY_ID,ASSIGNMENT_DATE,ASSIGNER_ID,IS_MAIN_DUTY) VALUES(10000,10000,getDate(),10000,1)
;
INSERT INTO T_DUTY_X_PRIVILEGE(DUTY_ID,PRIVILEGE_ID,ASSIGNER_NO) VALUES(10000,11500,10000)
;

---------------------
--分类模块数据初始化-
---------------------
INSERT INTO T_CATEGORY(CATEGORY_ID,PARENT_ID,ISLEAF,CATEGORY_NAME,CREATOR_ID,CREATE_DATE)
 VALUES(1000,NULL,0,'分类根目录',NULL,'2001-10-15')
;
INSERT INTO T_CATEGORY (CATEGORY_ID,PARENT_ID,ISLEAF,CATEGORY_NAME,CREATOR_ID,CREATE_DATE)
 VALUES(2000,1000,0,'固定资产',10000,'2001-10-15')
;
INSERT INTO T_CATEGORY (CATEGORY_ID,PARENT_ID,ISLEAF,CATEGORY_NAME,CREATOR_ID,CREATE_DATE)
 VALUES(3000,1000,0,'文件来源单位',10000,'2001-10-15')
;