system_model.sql

一段很有意义的源码,看了就知道,不信试一试啊!

insert into sc_role (ID,NAME,REMOVED,TYPE) values (1,'Administrator',0,'S');
insert into sc_role (ID,NAME,REMOVED,TYPE) values (2,'DBA',0,'S');
insert into sc_role (ID,NAME,REMOVED,TYPE) values (3,'Monitor',0,'S');
insert into sc_user (ID,LOGIN_NAME,NAME,PASSWORD,REMOVED,STATUS) values (1,'admin','admin','0ddb5877c896f43e8734e10b001e7f1eb92889cd',0,1);
insert into sc_user_role (SECURITY_USER_ID,SECURITY_ROLE_ID) values (1,1);

insert into MENU_RESOURCE (id,description,resource_name,parent_resource_id,disp_order,linkpath) 
values (1,'组织机构管理','组织机构管理',null,0,'');
insert into MENU_RESOURCE (id,description,resource_name,parent_resource_id,disp_order,linkpath) 
values (2,'资源管理','资源管理',null,1,'');
insert into MENU_RESOURCE (id,description,resource_name,parent_resource_id,disp_order,linkpath) 
values (3,'应用安全管理','应用安全管理',null,2,'');
insert into MENU_RESOURCE (id,description,resource_name,parent_resource_id,disp_order,linkpath) 
values (4,'系统管理','系统管理',null,3,'');
insert into MENU_RESOURCE (id,description,resource_name,parent_resource_id,disp_order,linkpath) 
values (5,'流程管理','流程管理',null,4,'');
insert into MENU_RESOURCE (id,description,resource_name,parent_resource_id,disp_order,linkpath) 
values (6,'群组管理','群组管理',1,0,'');
insert into MENU_RESOURCE (id,description,resource_name,parent_resource_id,disp_order,linkpath) 
values (7,'自定义群组管理','自定义群组管理',6,0,'dorado/group/group.jsp');
insert into MENU_RESOURCE (id,description,resource_name,parent_resource_id,disp_order,linkpath) 
values (8,'动态群组管理','动态群组管理',6,1,'dorado/group/dyna-group.jsp');
insert into MENU_RESOURCE (id,description,resource_name,parent_resource_id,disp_order,linkpath) 
values (9,'组织管理','组织管理',1,1,'');
insert into MENU_RESOURCE (id,description,resource_name,parent_resource_id,disp_order,linkpath) 
values (10,'组织类型管理','组织类型管理',9,0,'dorado/organ/organ-type.jsp');
insert into MENU_RESOURCE (id,description,resource_name,parent_resource_id,disp_order,linkpath) 
values (11,'组织关系类型管理','组织关系类型管理',9,1,'dorado/organ/organ-relation.jsp');
insert into MENU_RESOURCE (id,description,resource_name,parent_resource_id,disp_order,linkpath) 
values (12,'组织树管理','组织树管理',9,2,'dorado/organ/organ.jsp');
insert into MENU_RESOURCE (id,description,resource_name,parent_resource_id,disp_order,linkpath) 
values (13,'应用系统节点管理','应用系统节点管理',2,0,'');
insert into MENU_RESOURCE (id,description,resource_name,parent_resource_id,disp_order,linkpath) 
values (14,'应用系统节点维护','应用系统节点维护',13,0,'dorado/resource/centerNodeList.jsp');
insert into MENU_RESOURCE (id,description,resource_name,parent_resource_id,disp_order,linkpath) 
values (15,'资源类型管理','资源类型管理',2,1,'');
insert into MENU_RESOURCE (id,description,resource_name,parent_resource_id,disp_order,linkpath) 
values (16,'资源类型维护','资源类型维护',15,0,'dorado/resource/resourceTypeList.jsp');
insert into MENU_RESOURCE (id,description,resource_name,parent_resource_id,disp_order,linkpath) 
values (17,'账号管理','账号管理',3,0,'');
insert into MENU_RESOURCE (id,description,resource_name,parent_resource_id,disp_order,linkpath) 
values (18,'统一身份认证','统一身份认证',3,1,'');
insert into MENU_RESOURCE (id,description,resource_name,parent_resource_id,disp_order,linkpath) 
values (19,'统一授权管理','统一授权管理',3,2,'');
insert into MENU_RESOURCE (id,description,resource_name,parent_resource_id,disp_order,linkpath) 
values (20,'用户自助服务','用户自助服务',17,0,'dorado/user/individualUserUpdate.jsp');
insert into MENU_RESOURCE (id,description,resource_name,parent_resource_id,disp_order,linkpath) 
values (21,'管理员维护','管理员维护',17,1,'');
insert into MENU_RESOURCE (id,description,resource_name,parent_resource_id,disp_order,linkpath) 
values (22,'维护账号','维护账号',21,0,'dorado/user/adminManagerUserList.jsp?status=1');
insert into MENU_RESOURCE (id,description,resource_name,parent_resource_id,disp_order,linkpath) 
values (23,'审核账号','审核账号',21,1,'dorado/user/adminAuditUserList.jsp?status=0');
insert into MENU_RESOURCE (id,description,resource_name,parent_resource_id,disp_order,linkpath) 
values (24,'封锁账号','封锁账号',21,2,'dorado/user/adminAuditUserList.jsp?status=1');
insert into MENU_RESOURCE (id,description,resource_name,parent_resource_id,disp_order,linkpath) 
values (25,'解封账号','解封账号',21,3,'dorado/user/adminAuditUserList.jsp?status=-1'); 
insert into MENU_RESOURCE (id,description,resource_name,parent_resource_id,disp_order,linkpath) 
values (26,'注销账号','注销账号',21,4,'dorado/user/adminAuditUserList.jsp'); 
insert into MENU_RESOURCE (id,description,resource_name,parent_resource_id,disp_order,linkpath) 
values (27,'用户代理','用户代理',18,0,''); 
insert into MENU_RESOURCE (id,description,resource_name,parent_resource_id,disp_order,linkpath) 
values (28,'代理维护','代理维护',27,0,'dorado/proxy/proxyList.jsp');
insert into MENU_RESOURCE (id,description,resource_name,parent_resource_id,disp_order,linkpath) 
values (29,'代理登录','代理登录',27,1,'dorado/proxy/proxyUserList.jsp');
insert into MENU_RESOURCE (id,description,resource_name,parent_resource_id,disp_order,linkpath) 
values (30,'用户授权管理','用户授权管理',19,0,''); 
insert into MENU_RESOURCE (id,description,resource_name,parent_resource_id,disp_order,linkpath) 
values (31,'群组授权管理','群组授权管理',19,1,'dorado/auth/group.jsp'); 
insert into MENU_RESOURCE (id,description,resource_name,parent_resource_id,disp_order,linkpath) 
values (32,'委托','委托',31,2,'dorado/auth/group.jsp?input=publish');
insert into MENU_RESOURCE (id,description,resource_name,parent_resource_id,disp_order,linkpath) 
values (33,'字典管理','字典管理',4,0,'');
insert into MENU_RESOURCE (id,description,resource_name,parent_resource_id,disp_order,linkpath) 
values (34,'字典大类','字典大类',33,0,'dorado/dict/code-type.jsp');
insert into MENU_RESOURCE (id,description,resource_name,parent_resource_id,disp_order,linkpath) 
values (35,'字典项','字典项',33,1,'dorado/dict/dict-maintain.jsp');
insert into MENU_RESOURCE (id,description,resource_name,parent_resource_id,disp_order,linkpath) 
values (36,'菜单管理','菜单管理',4,1,'');
insert into MENU_RESOURCE (id,description,resource_name,parent_resource_id,disp_order,linkpath) 
values (37,'菜单设置','菜单设置',36,1,'dorado/menu/menu-maintain.jsp');
insert into MENU_RESOURCE (id,description,resource_name,parent_resource_id,disp_order,linkpath) 
values (38,'流程定义管理','流程定义管理',5,0,'');
insert into MENU_RESOURCE (id,description,resource_name,parent_resource_id,disp_order,linkpath) 
values (39,'建模工具','建模工具',38,0,'pmtool/applet.jsp');
insert into MENU_RESOURCE (id,description,resource_name,parent_resource_id,disp_order,linkpath) 
values (40,'授权','授权',30,0,'dorado/auth/userList.jsp?input=auth');
insert into MENU_RESOURCE (id,description,resource_name,parent_resource_id,disp_order,linkpath) 
values (41,'禁止','禁止',30,1,'dorado/auth/userList.jsp?input=revoke');
insert into MENU_RESOURCE (id,description,resource_name,parent_resource_id,disp_order,linkpath) 
values (42,'委托','委托',30,2,'dorado/auth/userList.jsp?input=publish');
insert into MENU_RESOURCE (id,description,resource_name,parent_resource_id,disp_order,linkpath) 
values (43,'临时授权','临时授权',30,3,'dorado/auth/userList.jsp?input=tempauth');
insert into MENU_RESOURCE (id,description,resource_name,parent_resource_id,disp_order,linkpath) 
values (44,'授权','授权',31,0,'dorado/auth/group.jsp?input=auth');
insert into MENU_RESOURCE (id,description,resource_name,parent_resource_id,disp_order,linkpath) 
values (45,'禁止','禁止',31,1,'dorado/auth/group.jsp?input=revoke');

insert into sc_acl_res_type (ID,NAME,CLASS_NAME,CATALOG,CODE,REMOVED) values (1,'Menu','menuService:S',1,'Menu',0);
insert into sc_acl_operation (ID,NAME,ACL_RES_TYPE_ID,CODE,REMOVED) values (1,'Read',1,'Read',0);

insert into ORG_TYPE (ID,DOWN,PEOPLE,IS_TOP,REMOVED,CODE,NAME) values(1,0,1,0,0,'CODE1','普通职员');
insert into ORG_TYPE (ID,DOWN,PEOPLE,IS_TOP,REMOVED,CODE,NAME) values(2,0,1,0,0,'CODE2','部门负责人');
insert into ORG_TYPE (ID,DOWN,PEOPLE,IS_TOP,REMOVED,CODE,NAME) values(3,1,0,1,0,'CODE3','机构');

insert into ORGAN_RELATION(ID,REMOVED,CODE,NAME)values (1,0,'CODE1','行政上下级');
insert into ORGAN_RELATION(ID,REMOVED,CODE,NAME)values (2,0,'CODE2','业务指导');
insert into ORGAN_RELATION(ID,REMOVED,CODE,NAME)values (3,0,'CODE3','业务委托');
insert into ORGAN_RELATION(ID,REMOVED,CODE,NAME)values (4,0,'CODE4','行政管理');

insert into CODE_TYPE (ID,SYSTEM_TYPE,DISP_ORDER,REMOVED,CODE,NAME) values(1,1,0,0,'DyanGroupClass','动态组访问类');
insert into CODE_TYPE (ID,SYSTEM_TYPE,DISP_ORDER,REMOVED,CODE,NAME) values(2,1,0,0,'image','图片');

insert into CODE_INFO (ID,TYPE_ID,DISP_ORDER,REMOVED,CODE,NAME,DESCRIPTION) values (1,2,0,0,'CODE1','组织','../../images/org.gif');
insert into CODE_INFO (ID,TYPE_ID,DISP_ORDER,REMOVED,CODE,NAME,DESCRIPTION) values (2,2,0,0,'CODE2','人员','../../images/commander.gif');
insert into CODE_INFO (ID,TYPE_ID,DISP_ORDER,REMOVED,CODE,NAME,DESCRIPTION) values (3,2,0,0,'CODE3','普通人员','../../images/people.gif');
insert into CODE_INFO (ID,TYPE_ID,DISP_ORDER,REMOVED,CODE,NAME,DESCRIPTION) values (4,1,0,0,'CODE4','查询用户','DynaGroupTest');