Author: weaver
Date: Thu Jul 14 13:48:08 2005
New Revision: 219094
URL: http://svn.apache.org/viewcvs?rev=219094&view=rev
Log:
Fully functional MS SQL2000 version of the security-schema.sql. Big thanks go
out to Frank Villarreal
for submitting this fix.
Added:
portals/jetspeed-2/trunk/maven-plugin/src/plugin-resources/sql/mssql/override/security-schema.sql
Added:
portals/jetspeed-2/trunk/maven-plugin/src/plugin-resources/sql/mssql/override/security-schema.sql
URL:
http://svn.apache.org/viewcvs/portals/jetspeed-2/trunk/maven-plugin/src/plugin-resources/sql/mssql/override/security-schema.sql?rev=219094&view=auto
==============================================================================
---
portals/jetspeed-2/trunk/maven-plugin/src/plugin-resources/sql/mssql/override/security-schema.sql
(added)
+++
portals/jetspeed-2/trunk/maven-plugin/src/plugin-resources/sql/mssql/override/security-schema.sql
Thu Jul 14 13:48:08 2005
@@ -0,0 +1,698 @@
+
+/* ---------------------------------------------------------------------- */
+/* SECURITY_PRINCIPAL */
+/* ---------------------------------------------------------------------- */
+
+IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name =
'SECURITY_PRINCIPAL')
+BEGIN
+ DECLARE @reftable_1 nvarchar(60), @constraintname_1 nvarchar(60)
+ DECLARE refcursor CURSOR FOR
+ select reftables.name tablename, cons.name constraintname
+ from sysobjects tables,
+ sysobjects reftables,
+ sysobjects cons,
+ sysreferences ref
+ where tables.id = ref.rkeyid
+ and cons.id = ref.constid
+ and reftables.id = ref.fkeyid
+ and tables.name = 'SECURITY_PRINCIPAL'
+ OPEN refcursor
+ FETCH NEXT from refcursor into @reftable_1, @constraintname_1
+ while @@FETCH_STATUS = 0
+ BEGIN
+ exec ('alter table '[EMAIL PROTECTED]' drop constraint '[EMAIL
PROTECTED])
+ FETCH NEXT from refcursor into @reftable_1, @constraintname_1
+ END
+ CLOSE refcursor
+ DEALLOCATE refcursor
+ DROP TABLE SECURITY_PRINCIPAL
+END
+;
+
+CREATE TABLE SECURITY_PRINCIPAL
+(
+ PRINCIPAL_ID INT NOT NULL,
+ CLASSNAME VARCHAR (254) NOT NULL,
+ IS_MAPPING_ONLY BIT NOT NULL,
+ IS_ENABLED BIT NOT NULL,
+ FULL_PATH VARCHAR (254) NOT NULL,
+ CREATION_DATE DATETIME NOT NULL,
+ MODIFIED_DATE DATETIME NOT NULL,
+
+ CONSTRAINT SECURITY_PRINCIPAL_PK PRIMARY KEY(PRINCIPAL_ID),
+ UNIQUE (FULL_PATH));
+
+
+
+
+
+/* ---------------------------------------------------------------------- */
+/* SECURITY_PERMISSION */
+/* ---------------------------------------------------------------------- */
+
+IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name =
'SECURITY_PERMISSION')
+BEGIN
+ DECLARE @reftable_2 nvarchar(60), @constraintname_2 nvarchar(60)
+ DECLARE refcursor CURSOR FOR
+ select reftables.name tablename, cons.name constraintname
+ from sysobjects tables,
+ sysobjects reftables,
+ sysobjects cons,
+ sysreferences ref
+ where tables.id = ref.rkeyid
+ and cons.id = ref.constid
+ and reftables.id = ref.fkeyid
+ and tables.name = 'SECURITY_PERMISSION'
+ OPEN refcursor
+ FETCH NEXT from refcursor into @reftable_2, @constraintname_2
+ while @@FETCH_STATUS = 0
+ BEGIN
+ exec ('alter table '[EMAIL PROTECTED]' drop constraint '[EMAIL
PROTECTED])
+ FETCH NEXT from refcursor into @reftable_2, @constraintname_2
+ END
+ CLOSE refcursor
+ DEALLOCATE refcursor
+ DROP TABLE SECURITY_PERMISSION
+END
+;
+
+CREATE TABLE SECURITY_PERMISSION
+(
+ PERMISSION_ID INT NOT NULL,
+ CLASSNAME VARCHAR (254) NOT NULL,
+ NAME VARCHAR (254) NOT NULL,
+ ACTIONS VARCHAR (254) NOT NULL,
+ CREATION_DATE DATETIME NOT NULL,
+ MODIFIED_DATE DATETIME NOT NULL,
+
+ CONSTRAINT SECURITY_PERMISSION_PK PRIMARY KEY(PERMISSION_ID));
+
+
+
+
+
+/* ---------------------------------------------------------------------- */
+/* PRINCIPAL_PERMISSION */
+/* ---------------------------------------------------------------------- */
+
+IF EXISTS (SELECT 1 FROM sysobjects WHERE type ='RI' AND
name='PRINCIPAL_PERMISSION_FK_1')
+ ALTER TABLE PRINCIPAL_PERMISSION DROP CONSTRAINT PRINCIPAL_PERMISSION_FK_1;
+IF EXISTS (SELECT 1 FROM sysobjects WHERE type ='RI' AND
name='PRINCIPAL_PERMISSION_FK_2')
+ ALTER TABLE PRINCIPAL_PERMISSION DROP CONSTRAINT PRINCIPAL_PERMISSION_FK_2;
+IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name =
'PRINCIPAL_PERMISSION')
+BEGIN
+ DECLARE @reftable_3 nvarchar(60), @constraintname_3 nvarchar(60)
+ DECLARE refcursor CURSOR FOR
+ select reftables.name tablename, cons.name constraintname
+ from sysobjects tables,
+ sysobjects reftables,
+ sysobjects cons,
+ sysreferences ref
+ where tables.id = ref.rkeyid
+ and cons.id = ref.constid
+ and reftables.id = ref.fkeyid
+ and tables.name = 'PRINCIPAL_PERMISSION'
+ OPEN refcursor
+ FETCH NEXT from refcursor into @reftable_3, @constraintname_3
+ while @@FETCH_STATUS = 0
+ BEGIN
+ exec ('alter table '[EMAIL PROTECTED]' drop constraint '[EMAIL
PROTECTED])
+ FETCH NEXT from refcursor into @reftable_3, @constraintname_3
+ END
+ CLOSE refcursor
+ DEALLOCATE refcursor
+ DROP TABLE PRINCIPAL_PERMISSION
+END
+;
+
+CREATE TABLE PRINCIPAL_PERMISSION
+(
+ PRINCIPAL_ID INT NOT NULL,
+ PERMISSION_ID INT NOT NULL,
+
+ CONSTRAINT PRINCIPAL_PERMISSION_PK PRIMARY
KEY(PRINCIPAL_ID,PERMISSION_ID));
+
+
+
+
+
+/* ---------------------------------------------------------------------- */
+/* SECURITY_CREDENTIAL */
+/* ---------------------------------------------------------------------- */
+
+IF EXISTS (SELECT 1 FROM sysobjects WHERE type ='RI' AND
name='SECURITY_CREDENTIAL_FK_1')
+ ALTER TABLE SECURITY_CREDENTIAL DROP CONSTRAINT SECURITY_CREDENTIAL_FK_1;
+IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name =
'SECURITY_CREDENTIAL')
+BEGIN
+ DECLARE @reftable_4 nvarchar(60), @constraintname_4 nvarchar(60)
+ DECLARE refcursor CURSOR FOR
+ select reftables.name tablename, cons.name constraintname
+ from sysobjects tables,
+ sysobjects reftables,
+ sysobjects cons,
+ sysreferences ref
+ where tables.id = ref.rkeyid
+ and cons.id = ref.constid
+ and reftables.id = ref.fkeyid
+ and tables.name = 'SECURITY_CREDENTIAL'
+ OPEN refcursor
+ FETCH NEXT from refcursor into @reftable_4, @constraintname_4
+ while @@FETCH_STATUS = 0
+ BEGIN
+ exec ('alter table '[EMAIL PROTECTED]' drop constraint '[EMAIL
PROTECTED])
+ FETCH NEXT from refcursor into @reftable_4, @constraintname_4
+ END
+ CLOSE refcursor
+ DEALLOCATE refcursor
+ DROP TABLE SECURITY_CREDENTIAL
+END
+;
+
+CREATE TABLE SECURITY_CREDENTIAL
+(
+ CREDENTIAL_ID INT NOT NULL,
+ PRINCIPAL_ID INT NOT NULL,
+ VALUE VARCHAR (254) NOT NULL,
+ TYPE SMALLINT NOT NULL,
+ CLASSNAME VARCHAR (254) NULL,
+ UPDATE_REQUIRED BIT NOT NULL,
+ IS_ENCODED BIT NOT NULL,
+ IS_ENABLED BIT NOT NULL,
+ AUTH_FAILURES SMALLINT NOT NULL,
+ IS_EXPIRED BIT NOT NULL,
+ CREATION_DATE DATETIME NOT NULL,
+ MODIFIED_DATE DATETIME NOT NULL,
+ PREV_AUTH_DATE DATETIME NULL,
+ LAST_AUTH_DATE DATETIME NULL,
+ EXPIRATION_DATE DATETIME NULL,
+
+ CONSTRAINT SECURITY_CREDENTIAL_PK PRIMARY KEY(CREDENTIAL_ID));
+
+
+
+
+
+/* ---------------------------------------------------------------------- */
+/* SSO_SITE */
+/* ---------------------------------------------------------------------- */
+
+IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'SSO_SITE')
+BEGIN
+ DECLARE @reftable_5 nvarchar(60), @constraintname_5 nvarchar(60)
+ DECLARE refcursor CURSOR FOR
+ select reftables.name tablename, cons.name constraintname
+ from sysobjects tables,
+ sysobjects reftables,
+ sysobjects cons,
+ sysreferences ref
+ where tables.id = ref.rkeyid
+ and cons.id = ref.constid
+ and reftables.id = ref.fkeyid
+ and tables.name = 'SSO_SITE'
+ OPEN refcursor
+ FETCH NEXT from refcursor into @reftable_5, @constraintname_5
+ while @@FETCH_STATUS = 0
+ BEGIN
+ exec ('alter table '[EMAIL PROTECTED]' drop constraint '[EMAIL
PROTECTED])
+ FETCH NEXT from refcursor into @reftable_5, @constraintname_5
+ END
+ CLOSE refcursor
+ DEALLOCATE refcursor
+ DROP TABLE SSO_SITE
+END
+;
+
+CREATE TABLE SSO_SITE
+(
+ SITE_ID INT NOT NULL,
+ NAME VARCHAR (254) NOT NULL,
+ URL VARCHAR (254) NOT NULL,
+ ALLOW_USER_SET BIT default 0 NULL,
+ REQUIRES_CERTIFICATE BIT default 0 NULL,
+
+ CONSTRAINT SSO_SITE_PK PRIMARY KEY(SITE_ID),
+ UNIQUE (URL));
+
+
+
+
+
+/* ---------------------------------------------------------------------- */
+/* SSO_SITE_TO_PRINCIPALS
*/
+/* ---------------------------------------------------------------------- */
+
+IF EXISTS (SELECT 1 FROM sysobjects WHERE type ='RI' AND
name='SSO_SITE_TO_PRINCIPALS_FK_1')
+ ALTER TABLE SSO_SITE_TO_PRINCIPALS DROP CONSTRAINT
SSO_SITE_TO_PRINCIPALS_FK_1;
+IF EXISTS (SELECT 1 FROM sysobjects WHERE type ='RI' AND
name='SSO_SITE_TO_PRINCIPALS_FK_2')
+ ALTER TABLE SSO_SITE_TO_PRINCIPALS DROP CONSTRAINT
SSO_SITE_TO_PRINCIPALS_FK_2;
+IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name =
'SSO_SITE_TO_PRINCIPALS')
+BEGIN
+ DECLARE @reftable_6 nvarchar(60), @constraintname_6 nvarchar(60)
+ DECLARE refcursor CURSOR FOR
+ select reftables.name tablename, cons.name constraintname
+ from sysobjects tables,
+ sysobjects reftables,
+ sysobjects cons,
+ sysreferences ref
+ where tables.id = ref.rkeyid
+ and cons.id = ref.constid
+ and reftables.id = ref.fkeyid
+ and tables.name = 'SSO_SITE_TO_PRINCIPALS'
+ OPEN refcursor
+ FETCH NEXT from refcursor into @reftable_6, @constraintname_6
+ while @@FETCH_STATUS = 0
+ BEGIN
+ exec ('alter table '[EMAIL PROTECTED]' drop constraint '[EMAIL
PROTECTED])
+ FETCH NEXT from refcursor into @reftable_6, @constraintname_6
+ END
+ CLOSE refcursor
+ DEALLOCATE refcursor
+ DROP TABLE SSO_SITE_TO_PRINCIPALS
+END
+;
+
+CREATE TABLE SSO_SITE_TO_PRINCIPALS
+(
+ SITE_ID INT NOT NULL,
+ PRINCIPAL_ID INT NOT NULL,
+
+ CONSTRAINT SSO_SITE_TO_PRINCIPALS_PK PRIMARY KEY(SITE_ID,PRINCIPAL_ID));
+
+
+
+
+
+/* ---------------------------------------------------------------------- */
+/* SSO_PRINCIPAL_TO_REMOTE
*/
+/* ---------------------------------------------------------------------- */
+
+IF EXISTS (SELECT 1 FROM sysobjects WHERE type ='RI' AND
name='SSO_PRINCIPAL_TO_REMOTE_FK_1')
+ ALTER TABLE SSO_PRINCIPAL_TO_REMOTE DROP CONSTRAINT
SSO_PRINCIPAL_TO_REMOTE_FK_1;
+IF EXISTS (SELECT 1 FROM sysobjects WHERE type ='RI' AND
name='SSO_PRINCIPAL_TO_REMOTE_FK_2')
+ ALTER TABLE SSO_PRINCIPAL_TO_REMOTE DROP CONSTRAINT
SSO_PRINCIPAL_TO_REMOTE_FK_2;
+IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name =
'SSO_PRINCIPAL_TO_REMOTE')
+BEGIN
+ DECLARE @reftable_7 nvarchar(60), @constraintname_7 nvarchar(60)
+ DECLARE refcursor CURSOR FOR
+ select reftables.name tablename, cons.name constraintname
+ from sysobjects tables,
+ sysobjects reftables,
+ sysobjects cons,
+ sysreferences ref
+ where tables.id = ref.rkeyid
+ and cons.id = ref.constid
+ and reftables.id = ref.fkeyid
+ and tables.name = 'SSO_PRINCIPAL_TO_REMOTE'
+ OPEN refcursor
+ FETCH NEXT from refcursor into @reftable_7, @constraintname_7
+ while @@FETCH_STATUS = 0
+ BEGIN
+ exec ('alter table '[EMAIL PROTECTED]' drop constraint '[EMAIL
PROTECTED])
+ FETCH NEXT from refcursor into @reftable_7, @constraintname_7
+ END
+ CLOSE refcursor
+ DEALLOCATE refcursor
+ DROP TABLE SSO_PRINCIPAL_TO_REMOTE
+END
+;
+
+CREATE TABLE SSO_PRINCIPAL_TO_REMOTE
+(
+ PRINCIPAL_ID INT NOT NULL,
+ REMOTE_PRINCIPAL_ID INT NOT NULL,
+
+ CONSTRAINT SSO_PRINCIPAL_TO_REMOTE_PK PRIMARY
KEY(PRINCIPAL_ID,REMOTE_PRINCIPAL_ID));
+
+
+
+
+
+/* ---------------------------------------------------------------------- */
+/* SSO_SITE_TO_REMOTE */
+/* ---------------------------------------------------------------------- */
+
+IF EXISTS (SELECT 1 FROM sysobjects WHERE type ='RI' AND
name='SSO_SITE_TO_REMOTE_FK_1')
+ ALTER TABLE SSO_SITE_TO_REMOTE DROP CONSTRAINT SSO_SITE_TO_REMOTE_FK_1;
+IF EXISTS (SELECT 1 FROM sysobjects WHERE type ='RI' AND
name='SSO_SITE_TO_REMOTE_FK_2')
+ ALTER TABLE SSO_SITE_TO_REMOTE DROP CONSTRAINT SSO_SITE_TO_REMOTE_FK_2;
+IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name =
'SSO_SITE_TO_REMOTE')
+BEGIN
+ DECLARE @reftable_8 nvarchar(60), @constraintname_8 nvarchar(60)
+ DECLARE refcursor CURSOR FOR
+ select reftables.name tablename, cons.name constraintname
+ from sysobjects tables,
+ sysobjects reftables,
+ sysobjects cons,
+ sysreferences ref
+ where tables.id = ref.rkeyid
+ and cons.id = ref.constid
+ and reftables.id = ref.fkeyid
+ and tables.name = 'SSO_SITE_TO_REMOTE'
+ OPEN refcursor
+ FETCH NEXT from refcursor into @reftable_8, @constraintname_8
+ while @@FETCH_STATUS = 0
+ BEGIN
+ exec ('alter table '[EMAIL PROTECTED]' drop constraint '[EMAIL
PROTECTED])
+ FETCH NEXT from refcursor into @reftable_8, @constraintname_8
+ END
+ CLOSE refcursor
+ DEALLOCATE refcursor
+ DROP TABLE SSO_SITE_TO_REMOTE
+END
+;
+
+CREATE TABLE SSO_SITE_TO_REMOTE
+(
+ SITE_ID INT NOT NULL,
+ PRINCIPAL_ID INT NOT NULL,
+
+ CONSTRAINT SSO_SITE_TO_REMOTE_PK PRIMARY KEY(SITE_ID,PRINCIPAL_ID));
+
+
+
+
+
+/* ---------------------------------------------------------------------- */
+/* SECURITY_USER_ROLE */
+/* ---------------------------------------------------------------------- */
+
+IF EXISTS (SELECT 1 FROM sysobjects WHERE type ='RI' AND
name='SECURITY_USER_ROLE_FK_1')
+ ALTER TABLE SECURITY_USER_ROLE DROP CONSTRAINT SECURITY_USER_ROLE_FK_1;
+IF EXISTS (SELECT 1 FROM sysobjects WHERE type ='RI' AND
name='SECURITY_USER_ROLE_FK_2')
+ ALTER TABLE SECURITY_USER_ROLE DROP CONSTRAINT SECURITY_USER_ROLE_FK_2;
+IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name =
'SECURITY_USER_ROLE')
+BEGIN
+ DECLARE @reftable_9 nvarchar(60), @constraintname_9 nvarchar(60)
+ DECLARE refcursor CURSOR FOR
+ select reftables.name tablename, cons.name constraintname
+ from sysobjects tables,
+ sysobjects reftables,
+ sysobjects cons,
+ sysreferences ref
+ where tables.id = ref.rkeyid
+ and cons.id = ref.constid
+ and reftables.id = ref.fkeyid
+ and tables.name = 'SECURITY_USER_ROLE'
+ OPEN refcursor
+ FETCH NEXT from refcursor into @reftable_9, @constraintname_9
+ while @@FETCH_STATUS = 0
+ BEGIN
+ exec ('alter table '[EMAIL PROTECTED]' drop constraint '[EMAIL
PROTECTED])
+ FETCH NEXT from refcursor into @reftable_9, @constraintname_9
+ END
+ CLOSE refcursor
+ DEALLOCATE refcursor
+ DROP TABLE SECURITY_USER_ROLE
+END
+;
+
+CREATE TABLE SECURITY_USER_ROLE
+(
+ USER_ID INT NOT NULL,
+ ROLE_ID INT NOT NULL,
+
+ CONSTRAINT SECURITY_USER_ROLE_PK PRIMARY KEY(USER_ID,ROLE_ID));
+
+
+
+
+
+/* ---------------------------------------------------------------------- */
+/* SECURITY_USER_GROUP */
+/* ---------------------------------------------------------------------- */
+
+IF EXISTS (SELECT 1 FROM sysobjects WHERE type ='RI' AND
name='SECURITY_USER_GROUP_FK_1')
+ ALTER TABLE SECURITY_USER_GROUP DROP CONSTRAINT SECURITY_USER_GROUP_FK_1;
+IF EXISTS (SELECT 1 FROM sysobjects WHERE type ='RI' AND
name='SECURITY_USER_GROUP_FK_2')
+ ALTER TABLE SECURITY_USER_GROUP DROP CONSTRAINT SECURITY_USER_GROUP_FK_2;
+IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name =
'SECURITY_USER_GROUP')
+BEGIN
+ DECLARE @reftable_10 nvarchar(60), @constraintname_10 nvarchar(60)
+ DECLARE refcursor CURSOR FOR
+ select reftables.name tablename, cons.name constraintname
+ from sysobjects tables,
+ sysobjects reftables,
+ sysobjects cons,
+ sysreferences ref
+ where tables.id = ref.rkeyid
+ and cons.id = ref.constid
+ and reftables.id = ref.fkeyid
+ and tables.name = 'SECURITY_USER_GROUP'
+ OPEN refcursor
+ FETCH NEXT from refcursor into @reftable_10, @constraintname_10
+ while @@FETCH_STATUS = 0
+ BEGIN
+ exec ('alter table '[EMAIL PROTECTED]' drop constraint '[EMAIL
PROTECTED])
+ FETCH NEXT from refcursor into @reftable_10, @constraintname_10
+ END
+ CLOSE refcursor
+ DEALLOCATE refcursor
+ DROP TABLE SECURITY_USER_GROUP
+END
+;
+
+CREATE TABLE SECURITY_USER_GROUP
+(
+ USER_ID INT NOT NULL,
+ GROUP_ID INT NOT NULL,
+
+ CONSTRAINT SECURITY_USER_GROUP_PK PRIMARY KEY(USER_ID,GROUP_ID));
+
+
+
+
+
+/* ---------------------------------------------------------------------- */
+/* SECURITY_GROUP_ROLE */
+/* ---------------------------------------------------------------------- */
+
+IF EXISTS (SELECT 1 FROM sysobjects WHERE type ='RI' AND
name='SECURITY_GROUP_ROLE_FK_1')
+ ALTER TABLE SECURITY_GROUP_ROLE DROP CONSTRAINT SECURITY_GROUP_ROLE_FK_1;
+IF EXISTS (SELECT 1 FROM sysobjects WHERE type ='RI' AND
name='SECURITY_GROUP_ROLE_FK_2')
+ ALTER TABLE SECURITY_GROUP_ROLE DROP CONSTRAINT SECURITY_GROUP_ROLE_FK_2;
+IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name =
'SECURITY_GROUP_ROLE')
+BEGIN
+ DECLARE @reftable_11 nvarchar(60), @constraintname_11 nvarchar(60)
+ DECLARE refcursor CURSOR FOR
+ select reftables.name tablename, cons.name constraintname
+ from sysobjects tables,
+ sysobjects reftables,
+ sysobjects cons,
+ sysreferences ref
+ where tables.id = ref.rkeyid
+ and cons.id = ref.constid
+ and reftables.id = ref.fkeyid
+ and tables.name = 'SECURITY_GROUP_ROLE'
+ OPEN refcursor
+ FETCH NEXT from refcursor into @reftable_11, @constraintname_11
+ while @@FETCH_STATUS = 0
+ BEGIN
+ exec ('alter table '[EMAIL PROTECTED]' drop constraint '[EMAIL
PROTECTED])
+ FETCH NEXT from refcursor into @reftable_11, @constraintname_11
+ END
+ CLOSE refcursor
+ DEALLOCATE refcursor
+ DROP TABLE SECURITY_GROUP_ROLE
+END
+;
+
+CREATE TABLE SECURITY_GROUP_ROLE
+(
+ GROUP_ID INT NOT NULL,
+ ROLE_ID INT NOT NULL,
+
+ CONSTRAINT SECURITY_GROUP_ROLE_PK PRIMARY KEY(GROUP_ID,ROLE_ID));
+
+
+
+
+
+/* ---------------------------------------------------------------------- */
+/* SECURITY_GROUP_ROLE */
+/* ---------------------------------------------------------------------- */
+
+
+
+
+/* ---------------------------------------------------------------------- */
+/* SECURITY_PRINCIPAL */
+/* ---------------------------------------------------------------------- */
+
+
+
+
+/* ---------------------------------------------------------------------- */
+/* SECURITY_PERMISSION */
+/* ---------------------------------------------------------------------- */
+
+BEGIN
+ALTER TABLE PRINCIPAL_PERMISSION
+ ADD CONSTRAINT PRINCIPAL_PERMISSION_FK_1 FOREIGN KEY (PERMISSION_ID)
+ REFERENCES SECURITY_PERMISSION (PERMISSION_ID)
+ ON DELETE CASCADE
+END
+;
+
+BEGIN
+ALTER TABLE PRINCIPAL_PERMISSION
+ ADD CONSTRAINT PRINCIPAL_PERMISSION_FK_2 FOREIGN KEY (PRINCIPAL_ID)
+ REFERENCES SECURITY_PRINCIPAL (PRINCIPAL_ID)
+ ON DELETE CASCADE
+END
+;
+
+
+
+
+/* ---------------------------------------------------------------------- */
+/* PRINCIPAL_PERMISSION */
+/* ---------------------------------------------------------------------- */
+
+BEGIN
+ALTER TABLE SECURITY_CREDENTIAL
+ ADD CONSTRAINT SECURITY_CREDENTIAL_FK_1 FOREIGN KEY (PRINCIPAL_ID)
+ REFERENCES SECURITY_PRINCIPAL (PRINCIPAL_ID)
+ ON DELETE CASCADE
+END
+;
+
+
+
+
+/* ---------------------------------------------------------------------- */
+/* SECURITY_CREDENTIAL */
+/* ---------------------------------------------------------------------- */
+
+
+
+
+/* ---------------------------------------------------------------------- */
+/* SSO_SITE */
+/* ---------------------------------------------------------------------- */
+
+BEGIN
+ALTER TABLE SSO_SITE_TO_PRINCIPALS
+ ADD CONSTRAINT SSO_SITE_TO_PRINCIPALS_FK_1 FOREIGN KEY (SITE_ID)
+ REFERENCES SSO_SITE (SITE_ID)
+ ON DELETE CASCADE
+END
+;
+
+BEGIN
+ALTER TABLE SSO_SITE_TO_PRINCIPALS
+ ADD CONSTRAINT SSO_SITE_TO_PRINCIPALS_FK_2 FOREIGN KEY (PRINCIPAL_ID)
+ REFERENCES SECURITY_PRINCIPAL (PRINCIPAL_ID)
+ ON DELETE CASCADE
+END
+;
+
+
+
+
+/* ---------------------------------------------------------------------- */
+/* SSO_SITE_TO_PRINCIPALS
*/
+/* ---------------------------------------------------------------------- */
+
+BEGIN
+ALTER TABLE SSO_PRINCIPAL_TO_REMOTE
+ ADD CONSTRAINT SSO_PRINCIPAL_TO_REMOTE_FK_1 FOREIGN KEY (PRINCIPAL_ID)
+ REFERENCES SECURITY_PRINCIPAL (PRINCIPAL_ID)
+ ON DELETE CASCADE
+END
+;
+
+BEGIN
+ALTER TABLE SSO_PRINCIPAL_TO_REMOTE
+ ADD CONSTRAINT SSO_PRINCIPAL_TO_REMOTE_FK_2 FOREIGN KEY
(REMOTE_PRINCIPAL_ID)
+ REFERENCES SECURITY_PRINCIPAL (PRINCIPAL_ID)
+END
+;
+
+
+
+
+/* ---------------------------------------------------------------------- */
+/* SSO_PRINCIPAL_TO_REMOTE
*/
+/* ---------------------------------------------------------------------- */
+
+BEGIN
+ALTER TABLE SSO_SITE_TO_REMOTE
+ ADD CONSTRAINT SSO_SITE_TO_REMOTE_FK_1 FOREIGN KEY (SITE_ID)
+ REFERENCES SSO_SITE (SITE_ID)
+ ON DELETE CASCADE
+END
+;
+
+BEGIN
+ALTER TABLE SSO_SITE_TO_REMOTE
+ ADD CONSTRAINT SSO_SITE_TO_REMOTE_FK_2 FOREIGN KEY (PRINCIPAL_ID)
+ REFERENCES SECURITY_PRINCIPAL (PRINCIPAL_ID)
+ ON DELETE CASCADE
+END
+;
+
+
+
+
+/* ---------------------------------------------------------------------- */
+/* SSO_SITE_TO_REMOTE */
+/* ---------------------------------------------------------------------- */
+
+BEGIN
+ALTER TABLE SECURITY_USER_ROLE
+ ADD CONSTRAINT SECURITY_USER_ROLE_FK_1 FOREIGN KEY (ROLE_ID)
+ REFERENCES SECURITY_PRINCIPAL (PRINCIPAL_ID)
+ ON DELETE CASCADE
+END
+;
+
+BEGIN
+ALTER TABLE SECURITY_USER_ROLE
+ ADD CONSTRAINT SECURITY_USER_ROLE_FK_2 FOREIGN KEY (USER_ID)
+ REFERENCES SECURITY_PRINCIPAL (PRINCIPAL_ID)
+END
+;
+
+
+
+
+/* ---------------------------------------------------------------------- */
+/* SECURITY_USER_ROLE */
+/* ---------------------------------------------------------------------- */
+
+BEGIN
+ALTER TABLE SECURITY_USER_GROUP
+ ADD CONSTRAINT SECURITY_USER_GROUP_FK_1 FOREIGN KEY (GROUP_ID)
+ REFERENCES SECURITY_PRINCIPAL (PRINCIPAL_ID)
+ ON DELETE CASCADE
+END
+;
+
+BEGIN
+ALTER TABLE SECURITY_USER_GROUP
+ ADD CONSTRAINT SECURITY_USER_GROUP_FK_2 FOREIGN KEY (USER_ID)
+ REFERENCES SECURITY_PRINCIPAL (PRINCIPAL_ID)
+END
+;
+
+
+
+
+/* ---------------------------------------------------------------------- */
+/* SECURITY_USER_GROUP */
+/* ---------------------------------------------------------------------- */
+
+BEGIN
+ALTER TABLE SECURITY_GROUP_ROLE
+ ADD CONSTRAINT SECURITY_GROUP_ROLE_FK_1 FOREIGN KEY (GROUP_ID)
+ REFERENCES SECURITY_PRINCIPAL (PRINCIPAL_ID)
+ ON DELETE CASCADE
+END
+;
+
+BEGIN
+ALTER TABLE SECURITY_GROUP_ROLE
+ ADD CONSTRAINT SECURITY_GROUP_ROLE_FK_2 FOREIGN KEY (ROLE_ID)
+ REFERENCES SECURITY_PRINCIPAL (PRINCIPAL_ID)
+END
+;
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
