CREATE TABLE SS_USERS(ID INTEGER IDENTITY NOT NULL ,PASSWD VARCHAR(255),NAME VARCHAR(80) NOT NULL,OBJECTGUID VARCHAR(255) NOT NULL,FULLNAME VARCHAR(255),DEPT VARCHAR(255),EMAIL VARCHAR(255),STATUS INTEGER NOT NULL,DESCN VARCHAR(255),CONSTRAINT PK_USERS PRIMARY KEY(ID))
CREATE TABLE SS_ROLES(ID INTEGER  IDENTITY NOT NULL,NAME VARCHAR(80) NOT NULL,DESCN VARCHAR(255),CONSTRAINT PK_ROLES PRIMARY KEY(ID))
CREATE TABLE SS_USER_ROLE(USER_ID INTEGER NOT NULL,ROLE_ID INTEGER NOT NULL,CONSTRAINT PK_USER_ROLE PRIMARY KEY(USER_ID,ROLE_ID),CONSTRAINT FK_USER_ROLE_1 FOREIGN KEY(USER_ID) REFERENCES SS_USERS(ID),CONSTRAINT FK_USER_ROLE_2 FOREIGN KEY(ROLE_ID) REFERENCES SS_ROLES(ID))
CREATE TABLE SS_RESOURCES(ID INTEGER IDENTITY NOT NULL,NAME VARCHAR(80) NOT NULL,RES_TYPE VARCHAR(20) NOT NULL,RES_STRING VARCHAR(255) NOT NULL,DESCN VARCHAR(255),CONSTRAINT PK_RESOURCES PRIMARY KEY(ID))
CREATE TABLE SS_ROLE_RESC(ROLE_ID INTEGER NOT NULL,RESC_ID INTEGER NOT NULL,CONSTRAINT PK_ROLE_RESC PRIMARY KEY(ROLE_ID,RESC_ID),CONSTRAINT FK_ROLE_RESC_1 FOREIGN KEY(ROLE_ID) REFERENCES SS_ROLES(ID),CONSTRAINT FK_ROLE_RESC_2 FOREIGN KEY(RESC_ID) REFERENCES SS_RESOURCES(ID))

SET IDENTITY_INSERT SS_USERS ON
INSERT INTO SS_USERS (ID,PASSWD,NAME,OBJECTGUID,FULLNAME,DEPT,EMAIL,STATUS,DESCN) VALUES(1,'c4ca4238a0b923820dcc509a6f75849b','admin','UGID','系统管理员','管理员','admin@forgon.com',1,'')
SET IDENTITY_INSERT SS_USERS OFF

SET IDENTITY_INSERT SS_ROLES ON
INSERT INTO SS_ROLES (ID,NAME,DESCN) VALUES(1,'ROLE_ADMINISTRATOR','系统管理员')
INSERT INTO SS_ROLES (ID,NAME,DESCN) VALUES(2,'ROLE_CompanyLeader','公司领导')
INSERT INTO SS_ROLES (ID,NAME,DESCN) VALUES(3,'ROLE_DeptManager','部门经理')
INSERT INTO SS_ROLES (ID,NAME,DESCN) VALUES(4,'ROLE_USER','全体用户')
INSERT INTO SS_ROLES (ID,NAME,DESCN) VALUES(5,'ROLE_DocumentManager','文档管理员')
INSERT INTO SS_ROLES (ID,NAME,DESCN) VALUES(6,'ROLE_ANONYMOUS','匿名用户')
INSERT INTO SS_ROLES (ID,NAME,DESCN) VALUES(7,'ROLE_LeaderSecretary','分管秘书')
INSERT INTO SS_ROLES (ID,NAME,DESCN) VALUES(8,'ROLE_UrgeManager','催办督办员')
INSERT INTO SS_ROLES (ID,NAME,DESCN) VALUES(9,'ROLE_ReceiveComposeFileRegister','收发员')
INSERT INTO SS_ROLES (ID,NAME,DESCN) VALUES(10,'ROLE_Distribute','分发员')
INSERT INTO SS_ROLES (ID,NAME,DESCN) VALUES(11,'ROLE_DocManager','文管员')
INSERT INTO SS_ROLES (ID,NAME,DESCN) VALUES(12,'ROLE_InforManager','信息管理员')
INSERT INTO SS_ROLES (ID,NAME,DESCN) VALUES(13,'ROLE_AddrBookManager','通讯录管理员')
INSERT INTO SS_ROLES (ID,NAME,DESCN) VALUES(14,'ROLE_ComposeFileManager','发文管理员')
INSERT INTO SS_ROLES (ID,NAME,DESCN) VALUES(15,'ROLE_ReceiveFileManager','收文管理员')
INSERT INTO SS_ROLES (ID,NAME,DESCN) VALUES(16,'ROLE_InnerFileManager','内部文件管理员')
INSERT INTO SS_ROLES (ID,NAME,DESCN) VALUES(16,'ROLE_KnowledgeManager','知识管理员')
SET IDENTITY_INSERT SS_ROLES OFF

SET IDENTITY_INSERT SS_RESOURCES ON
INSERT INTO SS_RESOURCES (ID,NAME,RES_TYPE,RES_STRING,DESCN) VALUES(1,'系统管理','URL','/admin/**','')
INSERT INTO SS_RESOURCES (ID,NAME,RES_TYPE,RES_STRING,DESCN) VALUES(2,'用户管理','URL','/user.do/**','')
INSERT INTO SS_RESOURCES (ID,NAME,RES_TYPE,RES_STRING,DESCN) VALUES(3,'角色管理','URL','/role.do/**','')
INSERT INTO SS_RESOURCES (ID,NAME,RES_TYPE,RES_STRING,DESCN) VALUES(4,'资源管理','URL','/resc.do/**','')
INSERT INTO SS_RESOURCES (ID,NAME,RES_TYPE,RES_STRING,DESCN) VALUES(5,'登录页面','URL','/logon.jsp','')
INSERT INTO SS_RESOURCES (ID,NAME,RES_TYPE,RES_STRING,DESCN) VALUES(6,'共享脚本','URL','/js/**','')
INSERT INTO SS_RESOURCES (ID,NAME,RES_TYPE,RES_STRING,DESCN) VALUES(7,'共享图片','URL','/images/**','')
INSERT INTO SS_RESOURCES (ID,NAME,RES_TYPE,RES_STRING,DESCN) VALUES(8,'发文管理','URL','/composefile/**','')
INSERT INTO SS_RESOURCES (ID,NAME,RES_TYPE,RES_STRING,DESCN) VALUES(9,'错误页面','URL','/error.jsp','')
INSERT INTO SS_RESOURCES (ID,NAME,RES_TYPE,RES_STRING,DESCN) VALUES(10,'拒绝访问页面','URL','/accessDenied.jsp','')

SET IDENTITY_INSERT SS_RESOURCES OFF

INSERT INTO SS_USER_ROLE VALUES(1,1)
INSERT INTO SS_USER_ROLE VALUES(1,2)
INSERT INTO SS_USER_ROLE VALUES(1,3)
INSERT INTO SS_USER_ROLE VALUES(1,4)
INSERT INTO SS_USER_ROLE VALUES(1,5)
INSERT INTO SS_USER_ROLE VALUES(1,7)
INSERT INTO SS_USER_ROLE VALUES(1,8)
INSERT INTO SS_USER_ROLE VALUES(1,9)
INSERT INTO SS_USER_ROLE VALUES(1,10)
INSERT INTO SS_USER_ROLE VALUES(1,11)
INSERT INTO SS_USER_ROLE VALUES(1,12)
INSERT INTO SS_USER_ROLE VALUES(1,13)

INSERT INTO SS_ROLE_RESC VALUES(1,1)
INSERT INTO SS_ROLE_RESC VALUES(1,2)
INSERT INTO SS_ROLE_RESC VALUES(1,3)
INSERT INTO SS_ROLE_RESC VALUES(1,4)

INSERT INTO SS_ROLE_RESC VALUES(2,8)

INSERT INTO SS_ROLE_RESC VALUES(3,8)

INSERT INTO SS_ROLE_RESC VALUES(4,5)
INSERT INTO SS_ROLE_RESC VALUES(4,6)
INSERT INTO SS_ROLE_RESC VALUES(4,7)
INSERT INTO SS_ROLE_RESC VALUES(4,9)
INSERT INTO SS_ROLE_RESC VALUES(4,10)

INSERT INTO SS_ROLE_RESC VALUES(6,5)
INSERT INTO SS_ROLE_RESC VALUES(6,6)
INSERT INTO SS_ROLE_RESC VALUES(6,7)

SET IDENTITY_INSERT FolderNode ON
INSERT INTO FolderNode (id,name,createDate, creator, maxSize, version, readers, managers, remark,sequenceNumber) VALUES(0,'资源库','2007-07-01','Administrator',0.0,'1.0','','','',0)
SET IDENTITY_INSERT FolderNode OFF

SET IDENTITY_INSERT OrgUnit ON
INSERT INTO OrgUnit (id,name,sequenceNumber) VALUES(0,'组织机构',0)
SET IDENTITY_INSERT OrgUnit OFF

SET IDENTITY_INSERT ContactGroup ON
INSERT INTO ContactGroup (id,name,sequenceNumber) VALUES(0,'通讯录',0)
SET IDENTITY_INSERT ContactGroup OFF