portals-jetspeed-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From vku...@apache.org
Subject svn commit: r707313 - /portals/jetspeed-2/portal/trunk/jetspeed-portal-resources/src/main/resources/ddl/mssql/create-schema.sql
Date Thu, 23 Oct 2008 08:40:00 GMT
Author: vkumar
Date: Thu Oct 23 01:40:00 2008
New Revision: 707313

URL: http://svn.apache.org/viewvc?rev=707313&view=rev
Log:
Updating scripts for mssql server

Modified:
    portals/jetspeed-2/portal/trunk/jetspeed-portal-resources/src/main/resources/ddl/mssql/create-schema.sql

Modified: portals/jetspeed-2/portal/trunk/jetspeed-portal-resources/src/main/resources/ddl/mssql/create-schema.sql
URL: http://svn.apache.org/viewvc/portals/jetspeed-2/portal/trunk/jetspeed-portal-resources/src/main/resources/ddl/mssql/create-schema.sql?rev=707313&r1=707312&r2=707313&view=diff
==============================================================================
--- portals/jetspeed-2/portal/trunk/jetspeed-portal-resources/src/main/resources/ddl/mssql/create-schema.sql
(original)
+++ portals/jetspeed-2/portal/trunk/jetspeed-portal-resources/src/main/resources/ddl/mssql/create-schema.sql
Thu Oct 23 01:40:00 2008
@@ -27,7 +27,7 @@
     DESCRIPTION TEXT,
     PRIMARY KEY (MEDIATYPE_ID)
 );
-GO
+
 -- ----------------------------------------------------------------------- 
 -- CLIENT 
 -- ----------------------------------------------------------------------- 
@@ -44,7 +44,7 @@
     PREFERRED_MIMETYPE_ID INT NOT NULL,
     PRIMARY KEY (CLIENT_ID)
 );
-GO
+ 
 -- ----------------------------------------------------------------------- 
 -- MIMETYPE 
 -- ----------------------------------------------------------------------- 
@@ -55,7 +55,7 @@
     NAME VARCHAR(80) NOT NULL,
     PRIMARY KEY (MIMETYPE_ID)
 );
-GO
+ 
 -- ----------------------------------------------------------------------- 
 -- CAPABILITY 
 -- ----------------------------------------------------------------------- 
@@ -66,7 +66,7 @@
     CAPABILITY VARCHAR(80) NOT NULL,
     PRIMARY KEY (CAPABILITY_ID)
 );
-GO
+ 
 -- ----------------------------------------------------------------------- 
 -- CLIENT_TO_CAPABILITY 
 -- ----------------------------------------------------------------------- 
@@ -76,7 +76,7 @@
     CLIENT_ID INT NOT NULL,
     CAPABILITY_ID INT NOT NULL
 );
-GO
+ 
 -- ----------------------------------------------------------------------- 
 -- CLIENT_TO_MIMETYPE 
 -- ----------------------------------------------------------------------- 
@@ -86,7 +86,7 @@
     CLIENT_ID INT NOT NULL,
     MIMETYPE_ID INT NOT NULL
 );
-GO
+ 
 -- ----------------------------------------------------------------------- 
 -- MEDIATYPE_TO_CAPABILITY 
 -- ----------------------------------------------------------------------- 
@@ -96,7 +96,7 @@
     MEDIATYPE_ID INT NOT NULL,
     CAPABILITY_ID INT NOT NULL
 );
-GO
+ 
 -- ----------------------------------------------------------------------- 
 -- MEDIATYPE_TO_MIMETYPE 
 -- ----------------------------------------------------------------------- 
@@ -106,7 +106,7 @@
     MEDIATYPE_ID INT NOT NULL,
     MIMETYPE_ID INT NOT NULL
 );
-GO
+ 
 -- ----------------------------------------------------------------------- 
 -- PORTLET_STATISTICS 
 -- ----------------------------------------------------------------------- 
@@ -121,7 +121,7 @@
     STATUS INT,
     ELAPSED_TIME DECIMAL(19,0)
 );
-GO
+ 
 -- ----------------------------------------------------------------------- 
 -- PAGE_STATISTICS 
 -- ----------------------------------------------------------------------- 
@@ -135,7 +135,7 @@
     STATUS INT,
     ELAPSED_TIME DECIMAL(19,0)
 );
-GO
+ 
 -- ----------------------------------------------------------------------- 
 -- USER_STATISTICS 
 -- ----------------------------------------------------------------------- 
@@ -148,7 +148,7 @@
     STATUS INT,
     ELAPSED_TIME DECIMAL(19,0)
 );
-GO
+ 
 -- ----------------------------------------------------------------------- 
 -- ADMIN_ACTIVITY 
 -- ----------------------------------------------------------------------- 
@@ -166,7 +166,7 @@
     ATTR_VALUE_AFTER VARCHAR(80),
     DESCRIPTION VARCHAR(128)
 );
-GO
+ 
 -- ----------------------------------------------------------------------- 
 -- USER_ACTIVITY 
 -- ----------------------------------------------------------------------- 
@@ -183,7 +183,7 @@
     ATTR_VALUE_AFTER VARCHAR(80),
     DESCRIPTION VARCHAR(128)
 );
-GO
+ 
 -- ----------------------------------------------------------------------- 
 -- FOLDER 
 -- ----------------------------------------------------------------------- 
@@ -212,11 +212,11 @@
     OWNER_PRINCIPAL VARCHAR(40),
     PRIMARY KEY (FOLDER_ID)
 );
-GO
+ 
 CREATE INDEX IX_FOLDER_1 ON FOLDER (PARENT_ID);
-GO
+
 CREATE UNIQUE INDEX UN_FOLDER_1 ON FOLDER (PATH);
-GO
+
 -- ----------------------------------------------------------------------- 
 -- FOLDER_METADATA 
 -- ----------------------------------------------------------------------- 
@@ -230,11 +230,11 @@
     VALUE VARCHAR(100) NOT NULL,
     PRIMARY KEY (METADATA_ID)
 );
-GO
+ 
 CREATE INDEX IX_FOLDER_METADATA_1 ON FOLDER_METADATA (FOLDER_ID);
-GO
+
 CREATE UNIQUE INDEX UN_FOLDER_METADATA_1 ON FOLDER_METADATA (FOLDER_ID, NAME, LOCALE, VALUE);
-GO
+
 -- ----------------------------------------------------------------------- 
 -- FOLDER_CONSTRAINT 
 -- ----------------------------------------------------------------------- 
@@ -250,9 +250,9 @@
     PERMISSIONS_ACL VARCHAR(120),
     PRIMARY KEY (CONSTRAINT_ID)
 );
-GO
+
 CREATE INDEX IX_FOLDER_CONSTRAINT_1 ON FOLDER_CONSTRAINT (FOLDER_ID);
-GO
+
 -- ----------------------------------------------------------------------- 
 -- FOLDER_CONSTRAINTS_REF 
 -- ----------------------------------------------------------------------- 
@@ -265,11 +265,11 @@
     NAME VARCHAR(40) NOT NULL,
     PRIMARY KEY (CONSTRAINTS_REF_ID)
 );
-GO
+
 CREATE INDEX IX_FOLDER_CONSTRAINTS_REF_1 ON FOLDER_CONSTRAINTS_REF (FOLDER_ID);
-GO
+
 CREATE UNIQUE INDEX UN_FOLDER_CONSTRAINTS_REF_1 ON FOLDER_CONSTRAINTS_REF (FOLDER_ID, NAME);
-GO
+
 -- ----------------------------------------------------------------------- 
 -- FOLDER_ORDER 
 -- ----------------------------------------------------------------------- 
@@ -282,11 +282,11 @@
     NAME VARCHAR(80) NOT NULL,
     PRIMARY KEY (ORDER_ID)
 );
-GO
+
 CREATE INDEX IX_FOLDER_ORDER_1 ON FOLDER_ORDER (FOLDER_ID);
-GO
+
 CREATE UNIQUE INDEX UN_FOLDER_ORDER_1 ON FOLDER_ORDER (FOLDER_ID, NAME);
-GO
+
 -- ----------------------------------------------------------------------- 
 -- FOLDER_MENU 
 -- ----------------------------------------------------------------------- 
@@ -312,11 +312,11 @@
     IS_NEST SMALLINT,
     PRIMARY KEY (MENU_ID)
 );
-GO
+
 CREATE INDEX IX_FOLDER_MENU_1 ON FOLDER_MENU (PARENT_ID);
-GO
+
 CREATE INDEX UN_FOLDER_MENU_1 ON FOLDER_MENU (FOLDER_ID, NAME);
-GO
+
 -- ----------------------------------------------------------------------- 
 -- FOLDER_MENU_METADATA 
 -- ----------------------------------------------------------------------- 
@@ -330,11 +330,11 @@
     VALUE VARCHAR(100) NOT NULL,
     PRIMARY KEY (METADATA_ID)
 );
-GO
+
 CREATE INDEX IX_FOLDER_MENU_METADATA_1 ON FOLDER_MENU_METADATA (MENU_ID);
-GO
+
 CREATE UNIQUE INDEX UN_FOLDER_MENU_METADATA_1 ON FOLDER_MENU_METADATA (MENU_ID, NAME, LOCALE,
VALUE);
-GO
+
 -- ----------------------------------------------------------------------- 
 -- PAGE 
 -- ----------------------------------------------------------------------- 
@@ -363,11 +363,11 @@
     OWNER_PRINCIPAL VARCHAR(40),
     PRIMARY KEY (PAGE_ID)
 );
-GO
+
 CREATE INDEX IX_PAGE_1 ON PAGE (PARENT_ID);
-GO
+
 CREATE UNIQUE INDEX UN_PAGE_1 ON PAGE (PATH);
-GO
+
 -- ----------------------------------------------------------------------- 
 -- PAGE_METADATA 
 -- ----------------------------------------------------------------------- 
@@ -381,11 +381,11 @@
     VALUE VARCHAR(100) NOT NULL,
     PRIMARY KEY (METADATA_ID)
 );
-GO
+
 CREATE INDEX IX_PAGE_METADATA_1 ON PAGE_METADATA (PAGE_ID);
-GO
+
 CREATE UNIQUE INDEX UN_PAGE_METADATA_1 ON PAGE_METADATA (PAGE_ID, NAME, LOCALE, VALUE);
-GO
+
 -- ----------------------------------------------------------------------- 
 -- PAGE_CONSTRAINT 
 -- ----------------------------------------------------------------------- 
@@ -401,9 +401,9 @@
     PERMISSIONS_ACL VARCHAR(120),
     PRIMARY KEY (CONSTRAINT_ID)
 );
-GO
+
 CREATE INDEX IX_PAGE_CONSTRAINT_1 ON PAGE_CONSTRAINT (PAGE_ID);
-GO
+
 -- ----------------------------------------------------------------------- 
 -- PAGE_CONSTRAINTS_REF 
 -- ----------------------------------------------------------------------- 
@@ -416,11 +416,11 @@
     NAME VARCHAR(40) NOT NULL,
     PRIMARY KEY (CONSTRAINTS_REF_ID)
 );
-GO
+
 CREATE INDEX IX_PAGE_CONSTRAINTS_REF_1 ON PAGE_CONSTRAINTS_REF (PAGE_ID);
-GO
+
 CREATE UNIQUE INDEX UN_PAGE_CONSTRAINTS_REF_1 ON PAGE_CONSTRAINTS_REF (PAGE_ID, NAME);
-GO
+
 -- ----------------------------------------------------------------------- 
 -- PAGE_MENU 
 -- ----------------------------------------------------------------------- 
@@ -446,11 +446,11 @@
     IS_NEST SMALLINT,
     PRIMARY KEY (MENU_ID)
 );
-GO
+
 CREATE INDEX IX_PAGE_MENU_1 ON PAGE_MENU (PARENT_ID);
-GO
+
 CREATE INDEX UN_PAGE_MENU_1 ON PAGE_MENU (PAGE_ID, NAME);
-GO
+
 -- ----------------------------------------------------------------------- 
 -- PAGE_MENU_METADATA 
 -- ----------------------------------------------------------------------- 
@@ -464,11 +464,11 @@
     VALUE VARCHAR(100) NOT NULL,
     PRIMARY KEY (METADATA_ID)
 );
-GO
+
 CREATE INDEX IX_PAGE_MENU_METADATA_1 ON PAGE_MENU_METADATA (MENU_ID);
-GO
+
 CREATE UNIQUE INDEX UN_PAGE_MENU_METADATA_1 ON PAGE_MENU_METADATA (MENU_ID, NAME, LOCALE,
VALUE);
-GO
+
 -- ----------------------------------------------------------------------- 
 -- FRAGMENT 
 -- ----------------------------------------------------------------------- 
@@ -501,11 +501,11 @@
     OWNER_PRINCIPAL VARCHAR(40),
     PRIMARY KEY (FRAGMENT_ID)
 );
-GO
+
 CREATE INDEX IX_FRAGMENT_1 ON FRAGMENT (PARENT_ID);
-GO
+
 CREATE INDEX UN_FRAGMENT_1 ON FRAGMENT (PAGE_ID);
-GO
+
 -- ----------------------------------------------------------------------- 
 -- FRAGMENT_CONSTRAINT 
 -- ----------------------------------------------------------------------- 
@@ -521,9 +521,9 @@
     PERMISSIONS_ACL VARCHAR(120),
     PRIMARY KEY (CONSTRAINT_ID)
 );
-GO
+
 CREATE INDEX IX_FRAGMENT_CONSTRAINT_1 ON FRAGMENT_CONSTRAINT (FRAGMENT_ID);
-GO
+
 -- ----------------------------------------------------------------------- 
 -- FRAGMENT_CONSTRAINTS_REF 
 -- ----------------------------------------------------------------------- 
@@ -536,11 +536,11 @@
     NAME VARCHAR(40) NOT NULL,
     PRIMARY KEY (CONSTRAINTS_REF_ID)
 );
-GO
+
 CREATE INDEX IX_FRAGMENT_CONSTRAINTS_REF_1 ON FRAGMENT_CONSTRAINTS_REF (FRAGMENT_ID);
-GO
+
 CREATE UNIQUE INDEX UN_FRAGMENT_CONSTRAINTS_REF_1 ON FRAGMENT_CONSTRAINTS_REF (FRAGMENT_ID,
NAME);
-GO
+
 -- ----------------------------------------------------------------------- 
 -- FRAGMENT_PREF 
 -- ----------------------------------------------------------------------- 
@@ -553,11 +553,11 @@
     IS_READ_ONLY SMALLINT NOT NULL,
     PRIMARY KEY (PREF_ID)
 );
-GO
+
 CREATE INDEX IX_FRAGMENT_PREF_1 ON FRAGMENT_PREF (FRAGMENT_ID);
-GO
+
 CREATE UNIQUE INDEX UN_FRAGMENT_PREF_1 ON FRAGMENT_PREF (FRAGMENT_ID, NAME);
-GO
+
 -- ----------------------------------------------------------------------- 
 -- FRAGMENT_PREF_VALUE 
 -- ----------------------------------------------------------------------- 
@@ -570,9 +570,9 @@
     VALUE VARCHAR(100) NOT NULL,
     PRIMARY KEY (PREF_VALUE_ID)
 );
-GO
+
 CREATE INDEX IX_FRAGMENT_PREF_VALUE_1 ON FRAGMENT_PREF_VALUE (PREF_ID);
-GO
+
 -- ----------------------------------------------------------------------- 
 -- LINK 
 -- ----------------------------------------------------------------------- 
@@ -601,11 +601,11 @@
     OWNER_PRINCIPAL VARCHAR(40),
     PRIMARY KEY (LINK_ID)
 );
-GO
+
 CREATE INDEX IX_LINK_1 ON LINK (PARENT_ID);
-GO
+
 CREATE UNIQUE INDEX UN_LINK_1 ON LINK (PATH);
-GO
+
 -- ----------------------------------------------------------------------- 
 -- LINK_METADATA 
 -- ----------------------------------------------------------------------- 
@@ -619,11 +619,11 @@
     VALUE VARCHAR(100) NOT NULL,
     PRIMARY KEY (METADATA_ID)
 );
-GO
+
 CREATE INDEX IX_LINK_METADATA_1 ON LINK_METADATA (LINK_ID);
-GO
+
 CREATE UNIQUE INDEX UN_LINK_METADATA_1 ON LINK_METADATA (LINK_ID, NAME, LOCALE, VALUE);
-GO
+
 -- ----------------------------------------------------------------------- 
 -- LINK_CONSTRAINT 
 -- ----------------------------------------------------------------------- 
@@ -639,9 +639,9 @@
     PERMISSIONS_ACL VARCHAR(120),
     PRIMARY KEY (CONSTRAINT_ID)
 );
-GO
+
 CREATE INDEX IX_LINK_CONSTRAINT_1 ON LINK_CONSTRAINT (LINK_ID);
-GO
+
 -- ----------------------------------------------------------------------- 
 -- LINK_CONSTRAINTS_REF 
 -- ----------------------------------------------------------------------- 
@@ -654,11 +654,11 @@
     NAME VARCHAR(40) NOT NULL,
     PRIMARY KEY (CONSTRAINTS_REF_ID)
 );
-GO
+
 CREATE INDEX IX_LINK_CONSTRAINTS_REF_1 ON LINK_CONSTRAINTS_REF (LINK_ID);
-GO
+
 CREATE UNIQUE INDEX UN_LINK_CONSTRAINTS_REF_1 ON LINK_CONSTRAINTS_REF (LINK_ID, NAME);
-GO
+
 -- ----------------------------------------------------------------------- 
 -- PAGE_SECURITY 
 -- ----------------------------------------------------------------------- 
@@ -680,11 +680,11 @@
     EXT_ATTR_VALUE VARCHAR(40),
     PRIMARY KEY (PAGE_SECURITY_ID)
 );
-GO
+
 CREATE UNIQUE INDEX UN_PAGE_SECURITY_1 ON PAGE_SECURITY (PARENT_ID);
-GO
+
 CREATE UNIQUE INDEX UN_PAGE_SECURITY_2 ON PAGE_SECURITY (PATH);
-GO
+
 -- ----------------------------------------------------------------------- 
 -- PAGE_SEC_CONSTRAINTS_DEF 
 -- ----------------------------------------------------------------------- 
@@ -696,11 +696,11 @@
     NAME VARCHAR(40) NOT NULL,
     PRIMARY KEY (CONSTRAINTS_DEF_ID)
 );
-GO
+
 CREATE INDEX IX_PAGE_SEC_CONSTRAINTS_DEF_1 ON PAGE_SEC_CONSTRAINTS_DEF (PAGE_SECURITY_ID);
-GO
+
 CREATE UNIQUE INDEX UN_PAGE_SEC_CONSTRAINTS_DEF_1 ON PAGE_SEC_CONSTRAINTS_DEF (PAGE_SECURITY_ID,
NAME);
-GO
+
 -- ----------------------------------------------------------------------- 
 -- PAGE_SEC_CONSTRAINT_DEF 
 -- ----------------------------------------------------------------------- 
@@ -716,9 +716,9 @@
     PERMISSIONS_ACL VARCHAR(120),
     PRIMARY KEY (CONSTRAINT_DEF_ID)
 );
-GO
+
 CREATE INDEX IX_PAGE_SEC_CONSTRAINT_DEF_1 ON PAGE_SEC_CONSTRAINT_DEF (CONSTRAINTS_DEF_ID);
-GO
+
 -- ----------------------------------------------------------------------- 
 -- PAGE_SEC_CONSTRAINTS_REF 
 -- ----------------------------------------------------------------------- 
@@ -731,11 +731,11 @@
     NAME VARCHAR(40) NOT NULL,
     PRIMARY KEY (CONSTRAINTS_REF_ID)
 );
-GO
+
 CREATE INDEX IX_PAGE_SEC_CONSTRAINTS_REF_1 ON PAGE_SEC_CONSTRAINTS_REF (PAGE_SECURITY_ID);
-GO
+
 CREATE UNIQUE INDEX UN_PAGE_SEC_CONSTRAINTS_REF_1 ON PAGE_SEC_CONSTRAINTS_REF (PAGE_SECURITY_ID,
NAME);
-GO
+
 -- ----------------------------------------------------------------------- 
 -- PROFILING_RULE 
 -- ----------------------------------------------------------------------- 
@@ -747,7 +747,7 @@
     TITLE VARCHAR(100),
     PRIMARY KEY (RULE_ID)
 );
-GO
+
 -- ----------------------------------------------------------------------- 
 -- RULE_CRITERION 
 -- ----------------------------------------------------------------------- 
@@ -763,9 +763,9 @@
     FALLBACK_TYPE INT DEFAULT 1,
     PRIMARY KEY (CRITERION_ID)
 );
-GO
+
 CREATE INDEX IX_RULE_CRITERION_1 ON RULE_CRITERION (RULE_ID, FALLBACK_ORDER);
-GO
+
 -- ----------------------------------------------------------------------- 
 -- PRINCIPAL_RULE_ASSOC 
 -- ----------------------------------------------------------------------- 
@@ -777,7 +777,7 @@
     RULE_ID VARCHAR(80) NOT NULL,
     PRIMARY KEY (PRINCIPAL_NAME, LOCATOR_NAME)
 );
-GO
+
 -- ----------------------------------------------------------------------- 
 -- PROFILE_PAGE_ASSOC 
 -- ----------------------------------------------------------------------- 
@@ -787,9 +787,9 @@
     LOCATOR_HASH VARCHAR(40) NOT NULL,
     PAGE_ID VARCHAR(80) NOT NULL
 );
-GO
+
 CREATE UNIQUE INDEX UN_PROFILE_PAGE_1 ON PROFILE_PAGE_ASSOC (LOCATOR_HASH, PAGE_ID);
-GO
+
 -- ----------------------------------------------------------------------- 
 -- CLUBS 
 -- ----------------------------------------------------------------------- 
@@ -806,7 +806,7 @@
     NICKNAME VARCHAR(40),
     PRIMARY KEY (NAME)
 );
-GO
+
 -- ----------------------------------------------------------------------- 
 -- OJB_HL_SEQ 
 -- ----------------------------------------------------------------------- 
@@ -820,7 +820,7 @@
     VERSION INT,
     PRIMARY KEY (TABLENAME, FIELDNAME)
 );
-GO
+
 -- ----------------------------------------------------------------------- 
 -- OJB_LOCKENTRY 
 -- ----------------------------------------------------------------------- 
@@ -834,7 +834,7 @@
     LOCKTYPE INT,
     PRIMARY KEY (OID_, TX_ID)
 );
-GO
+
 -- ----------------------------------------------------------------------- 
 -- OJB_NRM 
 -- ----------------------------------------------------------------------- 
@@ -845,7 +845,7 @@
     OID_ IMAGE,
     PRIMARY KEY (NAME)
 );
-GO
+
 -- ----------------------------------------------------------------------- 
 -- OJB_DLIST 
 -- ----------------------------------------------------------------------- 
@@ -856,7 +856,7 @@
     SIZE_ INT,
     PRIMARY KEY (ID)
 );
-GO
+
 -- ----------------------------------------------------------------------- 
 -- OJB_DLIST_ENTRIES 
 -- ----------------------------------------------------------------------- 
@@ -869,7 +869,7 @@
     OID_ IMAGE,
     PRIMARY KEY (ID)
 );
-GO
+
 -- ----------------------------------------------------------------------- 
 -- OJB_DSET 
 -- ----------------------------------------------------------------------- 
@@ -880,7 +880,7 @@
     SIZE_ INT,
     PRIMARY KEY (ID)
 );
-GO
+
 -- ----------------------------------------------------------------------- 
 -- OJB_DSET_ENTRIES 
 -- ----------------------------------------------------------------------- 
@@ -893,7 +893,7 @@
     OID_ IMAGE,
     PRIMARY KEY (ID)
 );
-GO
+
 -- ----------------------------------------------------------------------- 
 -- OJB_DMAP 
 -- ----------------------------------------------------------------------- 
@@ -904,7 +904,7 @@
     SIZE_ INT,
     PRIMARY KEY (ID)
 );
-GO
+
 -- ----------------------------------------------------------------------- 
 -- PORTLET_DEFINITION 
 -- ----------------------------------------------------------------------- 
@@ -922,7 +922,7 @@
     SECURITY_REF VARCHAR(40),
     PRIMARY KEY (ID)
 );
-GO
+
 -- ----------------------------------------------------------------------- 
 -- PORTLET_APPLICATION 
 -- ----------------------------------------------------------------------- 
@@ -940,9 +940,9 @@
     SECURITY_REF VARCHAR(40),
     PRIMARY KEY (APPLICATION_ID)
 );
-GO
+
 CREATE UNIQUE INDEX UK_APPLICATION ON PORTLET_APPLICATION (APP_NAME);
-GO
+
 -- ----------------------------------------------------------------------- 
 -- WEB_APPLICATION 
 -- ----------------------------------------------------------------------- 
@@ -953,7 +953,7 @@
     CONTEXT_ROOT VARCHAR(255) NOT NULL,
     PRIMARY KEY (ID)
 );
-GO
+
 -- ----------------------------------------------------------------------- 
 -- PA_METADATA_FIELDS 
 -- ----------------------------------------------------------------------- 
@@ -967,7 +967,7 @@
     LOCALE_STRING VARCHAR(50) NOT NULL,
     PRIMARY KEY (ID)
 );
-GO
+
 -- ----------------------------------------------------------------------- 
 -- PD_METADATA_FIELDS 
 -- ----------------------------------------------------------------------- 
@@ -981,7 +981,7 @@
     LOCALE_STRING VARCHAR(50) NOT NULL,
     PRIMARY KEY (ID)
 );
-GO
+
 -- ----------------------------------------------------------------------- 
 -- LANGUAGE 
 -- ----------------------------------------------------------------------- 
@@ -996,7 +996,7 @@
     KEYWORDS TEXT,
     PRIMARY KEY (ID)
 );
-GO
+
 -- ----------------------------------------------------------------------- 
 -- PORTLET_CONTENT_TYPE 
 -- ----------------------------------------------------------------------- 
@@ -1009,7 +1009,7 @@
     MODES TEXT,
     PRIMARY KEY (CONTENT_TYPE_ID)
 );
-GO
+
 -- ----------------------------------------------------------------------- 
 -- PARAMETER 
 -- ----------------------------------------------------------------------- 
@@ -1023,7 +1023,7 @@
     PARAMETER_VALUE TEXT,
     PRIMARY KEY (PARAMETER_ID)
 );
-GO
+
 -- ----------------------------------------------------------------------- 
 -- PORTLET_ENTITY 
 -- ----------------------------------------------------------------------- 
@@ -1036,9 +1036,9 @@
     PORTLET_NAME VARCHAR(80) NOT NULL,
     PRIMARY KEY (PEID)
 );
-GO
+
 CREATE UNIQUE INDEX UK_ENTITY_ID ON PORTLET_ENTITY (ID);
-GO
+
 -- ----------------------------------------------------------------------- 
 -- PORTLET_PREFERENCE 
 -- ----------------------------------------------------------------------- 
@@ -1051,9 +1051,9 @@
     NAME VARCHAR(254) NOT NULL,
     PRIMARY KEY (ID)
 );
-GO
+
 CREATE UNIQUE INDEX UIX_PORTLET_PREFERENCE ON PORTLET_PREFERENCE (APPLICATION_NAME, PORTLET_NAME,
NAME);
-GO
+
 -- ----------------------------------------------------------------------- 
 -- PORTLET_PREFERENCE_VALUE 
 -- ----------------------------------------------------------------------- 
@@ -1070,9 +1070,9 @@
     PREF_VALUE VARCHAR(4000),
     PRIMARY KEY (PREF_ID, IDX, ENTITY_OID, USER_NAME)
 );
-GO
+
 CREATE INDEX IX_PREFS_PREF_ID ON PORTLET_PREFERENCE_VALUE (PREF_ID);
-GO
+
 -- ----------------------------------------------------------------------- 
 -- SECURITY_ROLE_REFERENCE 
 -- ----------------------------------------------------------------------- 
@@ -1085,7 +1085,7 @@
     ROLE_LINK VARCHAR(150),
     PRIMARY KEY (ID)
 );
-GO
+
 -- ----------------------------------------------------------------------- 
 -- SECURITY_ROLE 
 -- ----------------------------------------------------------------------- 
@@ -1098,7 +1098,7 @@
     DESCRIPTION VARCHAR(150),
     PRIMARY KEY (ID)
 );
-GO
+
 -- ----------------------------------------------------------------------- 
 -- USER_ATTRIBUTE_REF 
 -- ----------------------------------------------------------------------- 
@@ -1111,7 +1111,7 @@
     NAME_LINK VARCHAR(150),
     PRIMARY KEY (ID)
 );
-GO
+
 -- ----------------------------------------------------------------------- 
 -- USER_ATTRIBUTE 
 -- ----------------------------------------------------------------------- 
@@ -1124,7 +1124,7 @@
     DESCRIPTION VARCHAR(150),
     PRIMARY KEY (ID)
 );
-GO
+
 -- ----------------------------------------------------------------------- 
 -- JETSPEED_SERVICE 
 -- ----------------------------------------------------------------------- 
@@ -1136,7 +1136,7 @@
     NAME VARCHAR(150),
     PRIMARY KEY (ID)
 );
-GO
+
 -- ----------------------------------------------------------------------- 
 -- LOCALIZED_DESCRIPTION 
 -- ----------------------------------------------------------------------- 
@@ -1150,7 +1150,7 @@
     LOCALE_STRING VARCHAR(50) NOT NULL,
     PRIMARY KEY (ID)
 );
-GO
+
 -- ----------------------------------------------------------------------- 
 -- LOCALIZED_DISPLAY_NAME 
 -- ----------------------------------------------------------------------- 
@@ -1164,7 +1164,7 @@
     LOCALE_STRING VARCHAR(50) NOT NULL,
     PRIMARY KEY (ID)
 );
-GO
+
 -- ----------------------------------------------------------------------- 
 -- CUSTOM_PORTLET_MODE 
 -- ----------------------------------------------------------------------- 
@@ -1178,7 +1178,7 @@
     DESCRIPTION TEXT,
     PRIMARY KEY (ID)
 );
-GO
+
 -- ----------------------------------------------------------------------- 
 -- CUSTOM_WINDOW_STATE 
 -- ----------------------------------------------------------------------- 
@@ -1192,7 +1192,7 @@
     DESCRIPTION TEXT,
     PRIMARY KEY (ID)
 );
-GO
+
 -- ----------------------------------------------------------------------- 
 -- SECURITY_PRINCIPAL 
 -- ----------------------------------------------------------------------- 
@@ -1210,9 +1210,9 @@
     MODIFIED_DATE DATETIME NOT NULL,
     PRIMARY KEY (PRINCIPAL_ID)
 );
-GO
+
 CREATE UNIQUE INDEX UIX_SECURITY_PRINCIPAL ON SECURITY_PRINCIPAL (PRINCIPAL_TYPE, PRINCIPAL_NAME);
-GO
+
 -- ----------------------------------------------------------------------- 
 -- SECURITY_ATTRIBUTE 
 -- ----------------------------------------------------------------------- 
@@ -1225,9 +1225,9 @@
     ATTR_VALUE VARCHAR(1000),
     PRIMARY KEY (ATTR_ID, PRINCIPAL_ID, ATTR_NAME)
 );
-GO
+
 CREATE INDEX IX_NAME_LOOKUP ON SECURITY_ATTRIBUTE (ATTR_NAME);
-GO
+
 -- ----------------------------------------------------------------------- 
 -- SECURITY_PRINCIPAL_ASSOC 
 -- ----------------------------------------------------------------------- 
@@ -1239,9 +1239,9 @@
     TO_PRINCIPAL_ID INT NOT NULL,
     PRIMARY KEY (ASSOC_NAME, FROM_PRINCIPAL_ID, TO_PRINCIPAL_ID)
 );
-GO
+
 CREATE INDEX IX_TO_PRINCIPAL_ASSOC_LOOKUP ON SECURITY_PRINCIPAL_ASSOC (ASSOC_NAME, TO_PRINCIPAL_ID);
-GO
+
 -- ----------------------------------------------------------------------- 
 -- SECURITY_PERMISSION 
 -- ----------------------------------------------------------------------- 
@@ -1254,9 +1254,9 @@
     ACTIONS VARCHAR(254) NOT NULL,
     PRIMARY KEY (PERMISSION_ID)
 );
-GO
+
 CREATE UNIQUE INDEX UIX_SECURITY_PERMISSION ON SECURITY_PERMISSION (PERMISSION_TYPE, NAME);
-GO
+
 -- ----------------------------------------------------------------------- 
 -- PRINCIPAL_PERMISSION 
 -- ----------------------------------------------------------------------- 
@@ -1267,7 +1267,7 @@
     PERMISSION_ID INT NOT NULL,
     PRIMARY KEY (PRINCIPAL_ID, PERMISSION_ID)
 );
-GO
+
 -- ----------------------------------------------------------------------- 
 -- SECURITY_CREDENTIAL 
 -- ----------------------------------------------------------------------- 
@@ -1292,7 +1292,7 @@
     EXPIRATION_DATE DATETIME,
     PRIMARY KEY (CREDENTIAL_ID)
 );
-GO
+
 -- ----------------------------------------------------------------------- 
 -- SSO_SITE 
 -- ----------------------------------------------------------------------- 
@@ -1311,9 +1311,9 @@
     REALM VARCHAR(128),
     PRIMARY KEY (SITE_ID)
 );
-GO
+
 CREATE UNIQUE INDEX UIX_SITE_URL ON SSO_SITE (URL);
-GO
+
 -- ----------------------------------------------------------------------- 
 -- SSO_COOKIE 
 -- ----------------------------------------------------------------------- 
@@ -1325,7 +1325,7 @@
     CREATE_DATE DATETIME NOT NULL,
     PRIMARY KEY (COOKIE_ID)
 );
-GO
+
 -- ----------------------------------------------------------------------- 
 -- SSO_SITE_TO_PRINCIPALS 
 -- ----------------------------------------------------------------------- 
@@ -1336,7 +1336,7 @@
     PRINCIPAL_ID INT NOT NULL,
     PRIMARY KEY (SITE_ID, PRINCIPAL_ID)
 );
-GO
+
 -- ----------------------------------------------------------------------- 
 -- SSO_PRINCIPAL_TO_REMOTE 
 -- ----------------------------------------------------------------------- 
@@ -1347,7 +1347,7 @@
     REMOTE_PRINCIPAL_ID INT NOT NULL,
     PRIMARY KEY (PRINCIPAL_ID, REMOTE_PRINCIPAL_ID)
 );
-GO
+
 -- ----------------------------------------------------------------------- 
 -- SSO_SITE_TO_REMOTE 
 -- ----------------------------------------------------------------------- 
@@ -1358,7 +1358,7 @@
     PRINCIPAL_ID INT NOT NULL,
     PRIMARY KEY (SITE_ID, PRINCIPAL_ID)
 );
-GO
+
 -- ----------------------------------------------------------------------- 
 -- SSO_COOKIE_TO_REMOTE 
 -- ----------------------------------------------------------------------- 
@@ -1369,212 +1369,157 @@
     REMOTE_PRINCIPAL_ID INT NOT NULL,
     PRIMARY KEY (COOKIE_ID, REMOTE_PRINCIPAL_ID)
 );
-GO
-
-/*CREATE TRIGGER trig_PREFS_NODE
-  ON PREFS_NODE 
-  INSTEAD OF DELETE 
-  AS 
-  SET NOCOUNT ON;
-
-  WITH cte AS 
-  ( SELECT NODE_ID, PARENT_NODE_ID 
-    FROM DELETED 
-    UNION ALL 
-    SELECT c.NODE_ID, c.PARENT_NODE_ID
-    FROM PREFS_NODE AS c 
-    INNER JOIN cte AS p 
-    ON c.PARENT_NODE_ID = p.NODE_ID 
-  ) 
-  SELECT * 
-  into #tmp
-  FROM cte
-  OPTION (MAXRECURSION 32767)
-  
-  DELETE FROM PREFS_PROPERTY_VALUE
-    WHERE NODE_ID IN (SELECT NODE_ID FROM #tmp);   
-
-  DELETE FROM PREFS_NODE 
-    WHERE NODE_ID IN(
-      SELECT NODE_ID FROM #TMP)
-  drop table #tmp;
-*/
-GO
-CREATE TRIGGER trig_SECURITY_PRINCIPAL
-  ON SECURITY_PRINCIPAL
-  INSTEAD OF DELETE 
-  AS 
-  
-  SET NOCOUNT ON;
-
-  DELETE FROM SSO_PRINCIPAL_TO_REMOTE
-    WHERE REMOTE_PRINCIPAL_ID IN (SELECT PRINCIPAL_ID FROM DELETED)
-;
-  DELETE FROM SECURITY_USER_ROLE
-    WHERE USER_ID IN (SELECT PRINCIPAL_ID FROM DELETED)
-;
-  DELETE FROM SECURITY_USER_GROUP
-    WHERE USER_ID IN (SELECT PRINCIPAL_ID FROM DELETED)
-;
-  DELETE FROM SECURITY_GROUP_ROLE
-    WHERE ROLE_ID IN (SELECT PRINCIPAL_ID FROM DELETED)
-;
-  DELETE FROM SECURITY_PRINCIPAL
-    WHERE PRINCIPAL_ID IN (SELECT PRINCIPAL_ID FROM DELETED)
-;
-
-GO
 
 ALTER TABLE FOLDER
     ADD CONSTRAINT FK_FOLDER_1 FOREIGN KEY (PARENT_ID) REFERENCES FOLDER (FOLDER_ID) ON DELETE
NO ACTION;
-GO
+
 ALTER TABLE FOLDER_METADATA
     ADD CONSTRAINT FK_FOLDER_METADATA_1 FOREIGN KEY (FOLDER_ID) REFERENCES FOLDER (FOLDER_ID)
ON DELETE CASCADE;
-GO
+
 ALTER TABLE FOLDER_CONSTRAINT
     ADD CONSTRAINT FK_FOLDER_CONSTRAINT_1 FOREIGN KEY (FOLDER_ID) REFERENCES FOLDER (FOLDER_ID)
ON DELETE CASCADE;
-GO
+
 ALTER TABLE FOLDER_CONSTRAINTS_REF
     ADD CONSTRAINT FK_FOLDER_CONSTRAINTS_REF_1 FOREIGN KEY (FOLDER_ID) REFERENCES FOLDER
(FOLDER_ID) ON DELETE CASCADE;
-GO
+
 ALTER TABLE FOLDER_ORDER
     ADD CONSTRAINT FK_FOLDER_ORDER_1 FOREIGN KEY (FOLDER_ID) REFERENCES FOLDER (FOLDER_ID)
ON DELETE CASCADE;
-GO
+
 ALTER TABLE FOLDER_MENU
     ADD CONSTRAINT FK_FOLDER_MENU_1 FOREIGN KEY (PARENT_ID) REFERENCES FOLDER_MENU (MENU_ID)
ON DELETE NO ACTION;
-GO
+
 ALTER TABLE FOLDER_MENU
     ADD CONSTRAINT FK_FOLDER_MENU_2 FOREIGN KEY (FOLDER_ID) REFERENCES FOLDER (FOLDER_ID)
ON DELETE CASCADE;
-GO
+
 ALTER TABLE FOLDER_MENU_METADATA
     ADD CONSTRAINT FK_FOLDER_MENU_METADATA_1 FOREIGN KEY (MENU_ID) REFERENCES FOLDER_MENU
(MENU_ID) ON DELETE CASCADE;
-GO
+
 ALTER TABLE PAGE
     ADD CONSTRAINT FK_PAGE_1 FOREIGN KEY (PARENT_ID) REFERENCES FOLDER (FOLDER_ID) ON DELETE
CASCADE;
-GO
+
 ALTER TABLE PAGE_METADATA
     ADD CONSTRAINT FK_PAGE_METADATA_1 FOREIGN KEY (PAGE_ID) REFERENCES PAGE (PAGE_ID) ON
DELETE CASCADE;
-GO
+
 ALTER TABLE PAGE_CONSTRAINT
     ADD CONSTRAINT FK_PAGE_CONSTRAINT_1 FOREIGN KEY (PAGE_ID) REFERENCES PAGE (PAGE_ID) ON
DELETE CASCADE;
-GO
+
 ALTER TABLE PAGE_CONSTRAINTS_REF
     ADD CONSTRAINT FK_PAGE_CONSTRAINTS_REF_1 FOREIGN KEY (PAGE_ID) REFERENCES PAGE (PAGE_ID)
ON DELETE CASCADE;
-GO
+
 ALTER TABLE PAGE_MENU
     ADD CONSTRAINT FK_PAGE_MENU_1 FOREIGN KEY (PARENT_ID) REFERENCES PAGE_MENU (MENU_ID)
ON DELETE NO ACTION;;
-GO
+
 ALTER TABLE PAGE_MENU
     ADD CONSTRAINT PM_M_FK_PAGE_ID_PAGE FOREIGN KEY (PAGE_ID) REFERENCES PAGE (PAGE_ID) ON
DELETE CASCADE;
-GO
+
 ALTER TABLE PAGE_MENU_METADATA
     ADD CONSTRAINT FK_PAGE_MENU_METADATA_1 FOREIGN KEY (MENU_ID) REFERENCES PAGE_MENU (MENU_ID)
ON DELETE CASCADE;
-GO
+
 ALTER TABLE FRAGMENT
     ADD CONSTRAINT FK_FRAGMENT_1 FOREIGN KEY (PARENT_ID) REFERENCES FRAGMENT (FRAGMENT_ID)
ON DELETE NO ACTION;
-GO
+
 ALTER TABLE FRAGMENT
     ADD CONSTRAINT FK_FRAGMENT_2 FOREIGN KEY (PAGE_ID) REFERENCES PAGE (PAGE_ID) ON DELETE
CASCADE;
-GO
+
 ALTER TABLE FRAGMENT_CONSTRAINT
     ADD CONSTRAINT FK_FRAGMENT_CONSTRAINT_1 FOREIGN KEY (FRAGMENT_ID) REFERENCES FRAGMENT
(FRAGMENT_ID) ON DELETE CASCADE;
-GO
+
 ALTER TABLE FRAGMENT_CONSTRAINTS_REF
     ADD CONSTRAINT FK_FRAGMENT_CONSTRAINTS_REF_1 FOREIGN KEY (FRAGMENT_ID) REFERENCES FRAGMENT
(FRAGMENT_ID) ON DELETE CASCADE;
-GO
+
 ALTER TABLE FRAGMENT_PREF
     ADD CONSTRAINT FK_FRAGMENT_PREF_1 FOREIGN KEY (FRAGMENT_ID) REFERENCES FRAGMENT (FRAGMENT_ID)
ON DELETE CASCADE;
-GO
+
 ALTER TABLE FRAGMENT_PREF_VALUE
     ADD CONSTRAINT FK_FRAGMENT_PREF_VALUE_1 FOREIGN KEY (PREF_ID) REFERENCES FRAGMENT_PREF
(PREF_ID) ON DELETE CASCADE;
-GO
+
 ALTER TABLE LINK
     ADD CONSTRAINT FK_LINK_1 FOREIGN KEY (PARENT_ID) REFERENCES FOLDER (FOLDER_ID) ON DELETE
CASCADE;
-GO
+
 ALTER TABLE LINK_METADATA
     ADD CONSTRAINT FK_LINK_METADATA_1 FOREIGN KEY (LINK_ID) REFERENCES LINK (LINK_ID) ON
DELETE CASCADE;
-GO
+
 ALTER TABLE LINK_CONSTRAINT
     ADD CONSTRAINT FK_LINK_CONSTRAINT_1 FOREIGN KEY (LINK_ID) REFERENCES LINK (LINK_ID) ON
DELETE CASCADE;
-GO
+
 ALTER TABLE LINK_CONSTRAINTS_REF
     ADD CONSTRAINT FK_LINK_CONSTRAINTS_REF_1 FOREIGN KEY (LINK_ID) REFERENCES LINK (LINK_ID)
ON DELETE CASCADE;
-GO
+
 ALTER TABLE PAGE_SECURITY
     ADD CONSTRAINT FK_PAGE_SECURITY_1 FOREIGN KEY (PARENT_ID) REFERENCES FOLDER (FOLDER_ID)
ON DELETE CASCADE;
-GO
+
 ALTER TABLE PAGE_SEC_CONSTRAINTS_DEF
     ADD CONSTRAINT FK_PAGE_SEC_CONSTRAINTS_DEF_1 FOREIGN KEY (PAGE_SECURITY_ID) REFERENCES
PAGE_SECURITY (PAGE_SECURITY_ID) ON DELETE CASCADE;
-GO
+
 ALTER TABLE PAGE_SEC_CONSTRAINT_DEF
     ADD CONSTRAINT FK_PAGE_SEC_CONSTRAINT_DEF_1 FOREIGN KEY (CONSTRAINTS_DEF_ID) REFERENCES
PAGE_SEC_CONSTRAINTS_DEF (CONSTRAINTS_DEF_ID) ON DELETE CASCADE;
-GO
+
 ALTER TABLE PAGE_SEC_CONSTRAINTS_REF
     ADD CONSTRAINT FK_PAGE_SEC_CONSTRAINTS_REF_1 FOREIGN KEY (PAGE_SECURITY_ID) REFERENCES
PAGE_SECURITY (PAGE_SECURITY_ID) ON DELETE CASCADE;
-GO
+
 ALTER TABLE RULE_CRITERION
     ADD CONSTRAINT FK_RULE_CRITERION_1 FOREIGN KEY (RULE_ID) REFERENCES PROFILING_RULE (RULE_ID)
ON DELETE CASCADE;
-GO
+
 ALTER TABLE PA_METADATA_FIELDS
     ADD CONSTRAINT FK_PA_METADATA_FIELDS_1 FOREIGN KEY (OBJECT_ID) REFERENCES PORTLET_APPLICATION
(APPLICATION_ID) ON DELETE CASCADE;
-GO
+
 ALTER TABLE PD_METADATA_FIELDS
     ADD CONSTRAINT FK_PD_METADATA_FIELDS_1 FOREIGN KEY (OBJECT_ID) REFERENCES PORTLET_DEFINITION
(ID) ON DELETE CASCADE;
-GO
+
 ALTER TABLE PORTLET_PREFERENCE_VALUE
     ADD CONSTRAINT FK_PORTLET_PREFERENCE FOREIGN KEY (PREF_ID) REFERENCES PORTLET_PREFERENCE
(ID) ON DELETE CASCADE;
-GO
+
 ALTER TABLE USER_ATTRIBUTE_REF
     ADD CONSTRAINT FK_USER_ATTRIBUTE_REF_1 FOREIGN KEY (APPLICATION_ID) REFERENCES PORTLET_APPLICATION
(APPLICATION_ID) ON DELETE CASCADE;
-GO
+
 ALTER TABLE USER_ATTRIBUTE
     ADD CONSTRAINT FK_USER_ATTRIBUTE_1 FOREIGN KEY (APPLICATION_ID) REFERENCES PORTLET_APPLICATION
(APPLICATION_ID) ON DELETE CASCADE;
-GO
+
 ALTER TABLE CUSTOM_PORTLET_MODE
     ADD CONSTRAINT FK_CUSTOM_PORTLET_MODE_1 FOREIGN KEY (APPLICATION_ID) REFERENCES PORTLET_APPLICATION
(APPLICATION_ID) ON DELETE CASCADE;
-GO
+
 ALTER TABLE CUSTOM_WINDOW_STATE
     ADD CONSTRAINT FK_CUSTOM_WINDOW_STATE_1 FOREIGN KEY (APPLICATION_ID) REFERENCES PORTLET_APPLICATION
(APPLICATION_ID) ON DELETE CASCADE;
-GO
+
 ALTER TABLE SECURITY_ATTRIBUTE
     ADD CONSTRAINT FK_PRINCIPAL_ATTR FOREIGN KEY (PRINCIPAL_ID) REFERENCES SECURITY_PRINCIPAL
(PRINCIPAL_ID) ON DELETE CASCADE;
-GO
+
 ALTER TABLE SECURITY_PRINCIPAL_ASSOC
     ADD CONSTRAINT FK_FROM_PRINCIPAL_ASSOC FOREIGN KEY (FROM_PRINCIPAL_ID) REFERENCES SECURITY_PRINCIPAL
(PRINCIPAL_ID) ON DELETE CASCADE;
-GO
+
 ALTER TABLE SECURITY_PRINCIPAL_ASSOC
     ADD CONSTRAINT FK_TO_PRINCIPAL_ASSOC FOREIGN KEY (TO_PRINCIPAL_ID) REFERENCES SECURITY_PRINCIPAL
(PRINCIPAL_ID) ON DELETE NO ACTION;
-GO
+
 ALTER TABLE PRINCIPAL_PERMISSION
     ADD CONSTRAINT FK_PRINCIPAL_PERMISSION_1 FOREIGN KEY (PERMISSION_ID) REFERENCES SECURITY_PERMISSION
(PERMISSION_ID) ON DELETE CASCADE;
-GO
+
 ALTER TABLE PRINCIPAL_PERMISSION
     ADD CONSTRAINT FK_PRINCIPAL_PERMISSION_2 FOREIGN KEY (PRINCIPAL_ID) REFERENCES SECURITY_PRINCIPAL
(PRINCIPAL_ID) ON DELETE CASCADE;
-GO
+
 ALTER TABLE SECURITY_CREDENTIAL
     ADD CONSTRAINT FK_SECURITY_CREDENTIAL_1 FOREIGN KEY (PRINCIPAL_ID) REFERENCES SECURITY_PRINCIPAL
(PRINCIPAL_ID) ON DELETE CASCADE;
-GO
+
 ALTER TABLE SSO_SITE_TO_PRINCIPALS
     ADD CONSTRAINT SSO_SITE_TO_PRINC_FK1 FOREIGN KEY (SITE_ID) REFERENCES SSO_SITE (SITE_ID)
ON DELETE CASCADE;
-GO
+
 ALTER TABLE SSO_SITE_TO_PRINCIPALS
     ADD CONSTRAINT SSO_SITE_TO_PRINC_FK2 FOREIGN KEY (PRINCIPAL_ID) REFERENCES SECURITY_PRINCIPAL
(PRINCIPAL_ID) ON DELETE CASCADE;
-GO
+
 ALTER TABLE SSO_PRINCIPAL_TO_REMOTE
     ADD CONSTRAINT FK_SSO_PRINCIPAL_TO_REMOTE_1 FOREIGN KEY (PRINCIPAL_ID) REFERENCES SECURITY_PRINCIPAL
(PRINCIPAL_ID) ON DELETE CASCADE;
-GO
+
 ALTER TABLE SSO_PRINCIPAL_TO_REMOTE
     ADD CONSTRAINT FK_SSO_PRINCIPAL_TO_REMOTE_2 FOREIGN KEY (REMOTE_PRINCIPAL_ID) REFERENCES
SECURITY_PRINCIPAL (PRINCIPAL_ID) ON DELETE NO ACTION;
-GO
+
 ALTER TABLE SSO_SITE_TO_REMOTE
     ADD CONSTRAINT FK_SSO_SITE_TO_REMOTE_1 FOREIGN KEY (SITE_ID) REFERENCES SSO_SITE (SITE_ID)
ON DELETE CASCADE;
-GO
+
 ALTER TABLE SSO_SITE_TO_REMOTE
     ADD CONSTRAINT FK_SSO_SITE_TO_REMOTE_2 FOREIGN KEY (PRINCIPAL_ID) REFERENCES SECURITY_PRINCIPAL
(PRINCIPAL_ID) ON DELETE CASCADE;
-GO
+
 ALTER TABLE SSO_COOKIE_TO_REMOTE
     ADD CONSTRAINT FK_SSO_COOKIE_TO_REMOTE_1 FOREIGN KEY (COOKIE_ID) REFERENCES SSO_COOKIE
(COOKIE_ID) ON DELETE CASCADE;
-GO
+
 ALTER TABLE SSO_COOKIE_TO_REMOTE
     ADD CONSTRAINT FK_SSO_COOKIE_TO_REMOTE_2 FOREIGN KEY (REMOTE_PRINCIPAL_ID) REFERENCES
SECURITY_PRINCIPAL (PRINCIPAL_ID) ON DELETE CASCADE;
-GO
+



---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-dev-help@portals.apache.org


Mime
View raw message