You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jetspeed-dev@portals.apache.org by vk...@apache.org on 2008/10/23 10:40:00 UTC
svn commit: r707313 -
/portals/jetspeed-2/portal/trunk/jetspeed-portal-resources/src/main/resources/ddl/mssql/create-schema.sql
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