performance_model.sql

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

drop sequence security_user_seq;
create sequence security_user_seq start with 1000;
drop sequence security_group_seq;
create sequence security_group_seq start with 1000;
drop sequence security_role_seq;
create sequence security_role_seq start with 1000;
drop sequence security_acl_resource_type_seq;
create sequence security_acl_resource_type_seq start with 1000;
drop sequence security_acl_resource_seq;
create sequence security_acl_resource_seq start with 1000;
drop sequence security_acl_operation_seq;
create sequence security_acl_operation_seq start with 1000;
drop sequence security_acl_permission_seq;
create sequence security_acl_permission_seq start with 1000;
drop sequence SAMPLE_file_RESOURCE_SEQ
create sequence SAMPLE_FILE_RESOURCE_SEQ start with 1000;
drop sequence SAMPLE_tree_RESOURCE_SEQ
create sequence SAMPLE_TREE_RESOURCE_SEQ start with 1000;
drop sequence SAMPLE_dir_RESOURCE_SEQ
create sequence SAMPLE_dir_RESOURCE_SEQ start with 1000;
drop sequence SAMPLE_url_RESOURCE_SEQ
create sequence SAMPLE_url_RESOURCE_SEQ start with 1000;
drop sequence SAMPLE_portlet_RESOURCE_SEQ
create sequence SAMPLE_portlet_RESOURCE_SEQ start with 1000;

--------------------------------------------------------------

delete from sc_user_group;
delete from sc_user_role;
delete from sc_group_role;
delete from sc_acc_permission;
delete from sc_rev_permission;
delete from sc_pub_permission;
delete from sc_acl_permission;
delete from sc_user;
delete from sc_group;
delete from sc_role;

delete from sc_acl_resource;
delete from sc_acl_operation;
delete from sc_acl_res_type;

delete from SAMPLE_TREE_RESOURCE;
delete from SAMPLE_FILE_RESOURCE;
delete from SAMPLE_URL_RESOURCE;
delete from SAMPLE_DIR_RESOURCE;
delete from SAMPLE_PORTLET_RESOURCE;


--------------------------------------------------------------

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_acl_res_type (ID,NAME,CLASS_NAME) values (1,'File','fileService:S');
insert into sc_acl_res_type (ID,NAME,CLASS_NAME) values (2,'Menu','menuService:S');
insert into sc_acl_res_type (ID,NAME,CLASS_NAME) values (3,'Dir','dirService:S');
insert into sc_acl_res_type (ID,NAME,CLASS_NAME) values (4,'Tree','treeService:S');
insert into sc_acl_res_type (ID,NAME,CLASS_NAME) values (5,'Url','urlService:S');
insert into sc_acl_res_type (ID,NAME,CLASS_NAME) values (6,'Portlet','portletService:S');

insert into sc_acl_operation (ID,NAME,MASK,ACL_RESOURCE_TYPE_ID) values (1,'Read','1',1);
insert into sc_acl_operation (ID,NAME,MASK,ACL_RESOURCE_TYPE_ID) values (2,'Write','2',1);
insert into sc_acl_operation (ID,NAME,MASK,ACL_RESOURCE_TYPE_ID) values (3,'Modify','3',1);
insert into sc_acl_operation (ID,NAME,MASK,ACL_RESOURCE_TYPE_ID) values (4,'Delete','4',1);
insert into sc_acl_operation (ID,NAME,MASK,ACL_RESOURCE_TYPE_ID) values (5,'Check','5',1);

insert into sc_acl_operation (ID,NAME,MASK,ACL_RESOURCE_TYPE_ID) values (11,'Read','1',2);
insert into sc_acl_operation (ID,NAME,MASK,ACL_RESOURCE_TYPE_ID) values (12,'Delete','2',2);
insert into sc_acl_operation (ID,NAME,MASK,ACL_RESOURCE_TYPE_ID) values (13,'Publish','3',2);
insert into sc_acl_operation (ID,NAME,MASK,ACL_RESOURCE_TYPE_ID) values (14,'Create','4',2);
insert into sc_acl_operation (ID,NAME,MASK,ACL_RESOURCE_TYPE_ID) values (15,'Check','5',2);

insert into sc_acl_operation (ID,NAME,MASK,ACL_RESOURCE_TYPE_ID) values (21,'Read','1',3);
insert into sc_acl_operation (ID,NAME,MASK,ACL_RESOURCE_TYPE_ID) values (22,'Write','2',3);
insert into sc_acl_operation (ID,NAME,MASK,ACL_RESOURCE_TYPE_ID) values (23,'Modify','3',3);
insert into sc_acl_operation (ID,NAME,MASK,ACL_RESOURCE_TYPE_ID) values (24,'Delete','4',3);
insert into sc_acl_operation (ID,NAME,MASK,ACL_RESOURCE_TYPE_ID) values (25,'Check','5',3);

insert into sc_acl_operation (ID,NAME,MASK,ACL_RESOURCE_TYPE_ID) values (31,'Read','1',4);
insert into sc_acl_operation (ID,NAME,MASK,ACL_RESOURCE_TYPE_ID) values (32,'Write','2',4);
insert into sc_acl_operation (ID,NAME,MASK,ACL_RESOURCE_TYPE_ID) values (33,'Modify','3',4);
insert into sc_acl_operation (ID,NAME,MASK,ACL_RESOURCE_TYPE_ID) values (34,'Delete','4',4);
insert into sc_acl_operation (ID,NAME,MASK,ACL_RESOURCE_TYPE_ID) values (35,'Check','5',4);

insert into sc_acl_operation (ID,NAME,MASK,ACL_RESOURCE_TYPE_ID) values (41,'Read','1',5);
insert into sc_acl_operation (ID,NAME,MASK,ACL_RESOURCE_TYPE_ID) values (42,'Write','2',5);
insert into sc_acl_operation (ID,NAME,MASK,ACL_RESOURCE_TYPE_ID) values (43,'Modify','3',5);
insert into sc_acl_operation (ID,NAME,MASK,ACL_RESOURCE_TYPE_ID) values (44,'Delete','4',5);
insert into sc_acl_operation (ID,NAME,MASK,ACL_RESOURCE_TYPE_ID) values (45,'Check','5',5);

insert into sc_acl_operation (ID,NAME,MASK,ACL_RESOURCE_TYPE_ID) values (46,'Read','1',6);
insert into sc_acl_operation (ID,NAME,MASK,ACL_RESOURCE_TYPE_ID) values (47,'Write','2',6);
insert into sc_acl_operation (ID,NAME,MASK,ACL_RESOURCE_TYPE_ID) values (48,'Modify','3',6);
insert into sc_acl_operation (ID,NAME,MASK,ACL_RESOURCE_TYPE_ID) values (49,'Delete','4',6);
insert into sc_acl_operation (ID,NAME,MASK,ACL_RESOURCE_TYPE_ID) values (50,'Check','5',6);

insert into sc_user (ID,LOGIN_NAME,NAME,PASSWORD,REMOVED) values (5000,'admin','admin','0ddb5877c896f43e8734e10b001e7f1eb92889cd',0);
insert into sc_user_role (SECURITY_USER_ID,SECURITY_ROLE_ID) values (5000,1);

--------------------------------------------------------------