You are viewing a plain text version of this content. The canonical link for it is here.
Posted to scm@geronimo.apache.org by pr...@apache.org on 2007/10/25 17:16:11 UTC
svn commit: r588248 [7/8] - in /geronimo/sandbox/jetspeed-integration: ./
jetspeed-base/ jetspeed-base/src/main/sql/ jetspeed-database/
jetspeed-database/src/ jetspeed-database/src/main/
jetspeed-database/src/main/database/ jetspeed-database/src/main/d...
Added: geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/oracle/registry-schema.sql
URL: http://svn.apache.org/viewvc/geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/oracle/registry-schema.sql?rev=588248&view=auto
==============================================================================
--- geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/oracle/registry-schema.sql (added)
+++ geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/oracle/registry-schema.sql Thu Oct 25 08:16:02 2007
@@ -0,0 +1,468 @@
+
+-----------------------------------------------------------------------------
+-- PORTLET_DEFINITION
+-----------------------------------------------------------------------------
+
+CREATE TABLE PORTLET_DEFINITION
+(
+ ID NUMBER(10,0) NOT NULL,
+ NAME VARCHAR2(80),
+ CLASS_NAME VARCHAR2(255),
+ APPLICATION_ID NUMBER(10,0) NOT NULL,
+ PORTLET_IDENTIFIER VARCHAR2(80),
+ EXPIRATION_CACHE VARCHAR2(30),
+ RESOURCE_BUNDLE VARCHAR2(255),
+ PREFERENCE_VALIDATOR VARCHAR2(255),
+ SECURITY_REF VARCHAR2(40)
+);
+
+ALTER TABLE PORTLET_DEFINITION
+ ADD CONSTRAINT PORTLET_DEFINITION_PK
+PRIMARY KEY (ID);
+
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- PORTLET_APPLICATION
+-----------------------------------------------------------------------------
+
+CREATE TABLE PORTLET_APPLICATION
+(
+ APPLICATION_ID NUMBER(10,0) NOT NULL,
+ APP_NAME VARCHAR2(80) NOT NULL,
+ APP_IDENTIFIER VARCHAR2(80),
+ VERSION VARCHAR2(80),
+ APP_TYPE NUMBER(10,0),
+ CHECKSUM VARCHAR2(80),
+ DESCRIPTION VARCHAR2(80),
+ WEB_APP_ID NUMBER(10,0) NOT NULL,
+ SECURITY_REF VARCHAR2(40),
+ CONSTRAINT UK_APPLICATION UNIQUE (APP_NAME)
+);
+
+ALTER TABLE PORTLET_APPLICATION
+ ADD CONSTRAINT PORTLET_APPLICATION_PK
+PRIMARY KEY (APPLICATION_ID);
+
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- WEB_APPLICATION
+-----------------------------------------------------------------------------
+
+CREATE TABLE WEB_APPLICATION
+(
+ ID NUMBER(10,0) NOT NULL,
+ CONTEXT_ROOT VARCHAR2(255) NOT NULL
+);
+
+ALTER TABLE WEB_APPLICATION
+ ADD CONSTRAINT WEB_APPLICATION_PK
+PRIMARY KEY (ID);
+
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- PA_METADATA_FIELDS
+-----------------------------------------------------------------------------
+
+CREATE TABLE PA_METADATA_FIELDS
+(
+ ID NUMBER(10,0) NOT NULL,
+ OBJECT_ID NUMBER(10,0) NOT NULL,
+ COLUMN_VALUE VARCHAR2(2000) NOT NULL,
+ NAME VARCHAR2(100) NOT NULL,
+ LOCALE_STRING VARCHAR2(50) NOT NULL
+);
+
+ALTER TABLE PA_METADATA_FIELDS
+ ADD CONSTRAINT PA_METADATA_FIELDS_PK
+PRIMARY KEY (ID);
+
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- PD_METADATA_FIELDS
+-----------------------------------------------------------------------------
+
+CREATE TABLE PD_METADATA_FIELDS
+(
+ ID NUMBER(10,0) NOT NULL,
+ OBJECT_ID NUMBER(10,0) NOT NULL,
+ COLUMN_VALUE VARCHAR2(2000) NOT NULL,
+ NAME VARCHAR2(100) NOT NULL,
+ LOCALE_STRING VARCHAR2(50) NOT NULL
+);
+
+ALTER TABLE PD_METADATA_FIELDS
+ ADD CONSTRAINT PD_METADATA_FIELDS_PK
+PRIMARY KEY (ID);
+
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- LANGUAGE
+-----------------------------------------------------------------------------
+
+CREATE TABLE LANGUAGE
+(
+ ID NUMBER(10,0) NOT NULL,
+ PORTLET_ID NUMBER(10,0) NOT NULL,
+ TITLE VARCHAR2(100),
+ SHORT_TITLE VARCHAR2(100),
+ LOCALE_STRING VARCHAR2(50) NOT NULL,
+ KEYWORDS VARCHAR2(2000)
+);
+
+ALTER TABLE LANGUAGE
+ ADD CONSTRAINT LANGUAGE_PK
+PRIMARY KEY (ID);
+
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- PORTLET_CONTENT_TYPE
+-----------------------------------------------------------------------------
+
+CREATE TABLE PORTLET_CONTENT_TYPE
+(
+ CONTENT_TYPE_ID NUMBER(10,0) NOT NULL,
+ PORTLET_ID NUMBER(10,0) NOT NULL,
+ CONTENT_TYPE VARCHAR2(30) NOT NULL,
+ MODES VARCHAR2(2000)
+);
+
+ALTER TABLE PORTLET_CONTENT_TYPE
+ ADD CONSTRAINT PORTLET_CONTENT_TYPE_PK
+PRIMARY KEY (CONTENT_TYPE_ID);
+
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- PARAMETER
+-----------------------------------------------------------------------------
+
+CREATE TABLE PARAMETER
+(
+ PARAMETER_ID NUMBER(10,0) NOT NULL,
+ PARENT_ID NUMBER(10,0) NOT NULL,
+ CLASS_NAME VARCHAR2(255) NOT NULL,
+ NAME VARCHAR2(80) NOT NULL,
+ PARAMETER_VALUE VARCHAR2(2000) NOT NULL
+);
+
+ALTER TABLE PARAMETER
+ ADD CONSTRAINT PARAMETER_PK
+PRIMARY KEY (PARAMETER_ID);
+
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- PORTLET_ENTITY
+-----------------------------------------------------------------------------
+
+CREATE TABLE PORTLET_ENTITY
+(
+ PEID NUMBER(10,0) NOT NULL,
+ ID VARCHAR2(255) NOT NULL,
+ APP_NAME VARCHAR2(255) NOT NULL,
+ PORTLET_NAME VARCHAR2(255) NOT NULL,
+ CONSTRAINT UK_ENTITY_ID UNIQUE (ID)
+);
+
+ALTER TABLE PORTLET_ENTITY
+ ADD CONSTRAINT PORTLET_ENTITY_PK
+PRIMARY KEY (PEID);
+
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- SECURITY_ROLE_REFERENCE
+-----------------------------------------------------------------------------
+
+CREATE TABLE SECURITY_ROLE_REFERENCE
+(
+ ID NUMBER(10,0) NOT NULL,
+ PORTLET_DEFINITION_ID NUMBER(10,0) NOT NULL,
+ ROLE_NAME VARCHAR2(150) NOT NULL,
+ ROLE_LINK VARCHAR2(150)
+);
+
+ALTER TABLE SECURITY_ROLE_REFERENCE
+ ADD CONSTRAINT SECURITY_ROLE_REFERENCE_PK
+PRIMARY KEY (ID);
+
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- SECURITY_ROLE
+-----------------------------------------------------------------------------
+
+CREATE TABLE SECURITY_ROLE
+(
+ ID NUMBER(10,0) NOT NULL,
+ WEB_APPLICATION_ID NUMBER(10,0) NOT NULL,
+ ROLE_NAME VARCHAR2(150) NOT NULL,
+ DESCRIPTION VARCHAR2(150)
+);
+
+ALTER TABLE SECURITY_ROLE
+ ADD CONSTRAINT SECURITY_ROLE_PK
+PRIMARY KEY (ID);
+
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- USER_ATTRIBUTE_REF
+-----------------------------------------------------------------------------
+
+CREATE TABLE USER_ATTRIBUTE_REF
+(
+ ID NUMBER(10,0) NOT NULL,
+ APPLICATION_ID NUMBER(10,0) NOT NULL,
+ NAME VARCHAR2(150),
+ NAME_LINK VARCHAR2(150)
+);
+
+ALTER TABLE USER_ATTRIBUTE_REF
+ ADD CONSTRAINT USER_ATTRIBUTE_REF_PK
+PRIMARY KEY (ID);
+
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- USER_ATTRIBUTE
+-----------------------------------------------------------------------------
+
+CREATE TABLE USER_ATTRIBUTE
+(
+ ID NUMBER(10,0) NOT NULL,
+ APPLICATION_ID NUMBER(10,0) NOT NULL,
+ NAME VARCHAR2(150),
+ DESCRIPTION VARCHAR2(150)
+);
+
+ALTER TABLE USER_ATTRIBUTE
+ ADD CONSTRAINT USER_ATTRIBUTE_PK
+PRIMARY KEY (ID);
+
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- JETSPEED_SERVICE
+-----------------------------------------------------------------------------
+
+CREATE TABLE JETSPEED_SERVICE
+(
+ ID NUMBER(10,0) NOT NULL,
+ APPLICATION_ID NUMBER(10,0) NOT NULL,
+ NAME VARCHAR2(150)
+);
+
+ALTER TABLE JETSPEED_SERVICE
+ ADD CONSTRAINT JETSPEED_SERVICE_PK
+PRIMARY KEY (ID);
+
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- LOCALIZED_DESCRIPTION
+-----------------------------------------------------------------------------
+
+CREATE TABLE LOCALIZED_DESCRIPTION
+(
+ ID NUMBER(10,0) NOT NULL,
+ OBJECT_ID NUMBER(10,0) NOT NULL,
+ CLASS_NAME VARCHAR2(255) NOT NULL,
+ DESCRIPTION VARCHAR2(2000) NOT NULL,
+ LOCALE_STRING VARCHAR2(50) NOT NULL
+);
+
+ALTER TABLE LOCALIZED_DESCRIPTION
+ ADD CONSTRAINT LOCALIZED_DESCRIPTION_PK
+PRIMARY KEY (ID);
+
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- LOCALIZED_DISPLAY_NAME
+-----------------------------------------------------------------------------
+
+CREATE TABLE LOCALIZED_DISPLAY_NAME
+(
+ ID NUMBER(10,0) NOT NULL,
+ OBJECT_ID NUMBER(10,0) NOT NULL,
+ CLASS_NAME VARCHAR2(255),
+ DISPLAY_NAME VARCHAR2(2000) NOT NULL,
+ LOCALE_STRING VARCHAR2(50) NOT NULL
+);
+
+ALTER TABLE LOCALIZED_DISPLAY_NAME
+ ADD CONSTRAINT LOCALIZED_DISPLAY_NAME_PK
+PRIMARY KEY (ID);
+
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- CUSTOM_PORTLET_MODE
+-----------------------------------------------------------------------------
+
+CREATE TABLE CUSTOM_PORTLET_MODE
+(
+ ID NUMBER(10,0) NOT NULL,
+ APPLICATION_ID NUMBER(10,0) NOT NULL,
+ CUSTOM_NAME VARCHAR2(150) NOT NULL,
+ MAPPED_NAME VARCHAR2(150),
+ DESCRIPTION VARCHAR2(2000)
+);
+
+ALTER TABLE CUSTOM_PORTLET_MODE
+ ADD CONSTRAINT CUSTOM_PORTLET_MODE_PK
+PRIMARY KEY (ID);
+
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- CUSTOM_WINDOW_STATE
+-----------------------------------------------------------------------------
+
+CREATE TABLE CUSTOM_WINDOW_STATE
+(
+ ID NUMBER(10,0) NOT NULL,
+ APPLICATION_ID NUMBER(10,0) NOT NULL,
+ CUSTOM_NAME VARCHAR2(150) NOT NULL,
+ MAPPED_NAME VARCHAR2(150),
+ DESCRIPTION VARCHAR2(2000)
+);
+
+ALTER TABLE CUSTOM_WINDOW_STATE
+ ADD CONSTRAINT CUSTOM_WINDOW_STATE_PK
+PRIMARY KEY (ID);
+
+
+
+
+
+
+
+
+
+
+
+ALTER TABLE PA_METADATA_FIELDS
+ ADD CONSTRAINT FK_PA_METADATA_FIELDS_1 FOREIGN KEY (OBJECT_ID)
+ REFERENCES PORTLET_APPLICATION (APPLICATION_ID)
+ON DELETE CASCADE
+;
+
+
+
+ALTER TABLE PD_METADATA_FIELDS
+ ADD CONSTRAINT FK_PD_METADATA_FIELDS_1 FOREIGN KEY (OBJECT_ID)
+ REFERENCES PORTLET_DEFINITION (ID)
+ON DELETE CASCADE
+;
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ALTER TABLE USER_ATTRIBUTE_REF
+ ADD CONSTRAINT FK_USER_ATTRIBUTE_REF_1 FOREIGN KEY (APPLICATION_ID)
+ REFERENCES PORTLET_APPLICATION (APPLICATION_ID)
+ON DELETE CASCADE
+;
+
+
+
+ALTER TABLE USER_ATTRIBUTE
+ ADD CONSTRAINT FK_USER_ATTRIBUTE_1 FOREIGN KEY (APPLICATION_ID)
+ REFERENCES PORTLET_APPLICATION (APPLICATION_ID)
+ON DELETE CASCADE
+;
+
+
+
+
+
+
+
+
+
+ALTER TABLE CUSTOM_PORTLET_MODE
+ ADD CONSTRAINT FK_CUSTOM_PORTLET_MODE_1 FOREIGN KEY (APPLICATION_ID)
+ REFERENCES PORTLET_APPLICATION (APPLICATION_ID)
+ON DELETE CASCADE
+;
+
+
+
+ALTER TABLE CUSTOM_WINDOW_STATE
+ ADD CONSTRAINT FK_CUSTOM_WINDOW_STATE_1 FOREIGN KEY (APPLICATION_ID)
+ REFERENCES PORTLET_APPLICATION (APPLICATION_ID)
+ON DELETE CASCADE
+;
+
+
+
Propchange: geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/oracle/registry-schema.sql
------------------------------------------------------------------------------
svn:eol-style = native
Propchange: geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/oracle/registry-schema.sql
------------------------------------------------------------------------------
svn:keywords = Date Revision
Propchange: geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/oracle/registry-schema.sql
------------------------------------------------------------------------------
svn:mime-type = text/plain
Added: geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/oracle/security-schema.sql
URL: http://svn.apache.org/viewvc/geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/oracle/security-schema.sql?rev=588248&view=auto
==============================================================================
--- geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/oracle/security-schema.sql (added)
+++ geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/oracle/security-schema.sql Thu Oct 25 08:16:02 2007
@@ -0,0 +1,408 @@
+
+-----------------------------------------------------------------------------
+-- SECURITY_PRINCIPAL
+-----------------------------------------------------------------------------
+
+CREATE TABLE SECURITY_PRINCIPAL
+(
+ PRINCIPAL_ID NUMBER(10,0) NOT NULL,
+ CLASSNAME VARCHAR2(254) NOT NULL,
+ IS_MAPPING_ONLY NUMBER(1,0) NOT NULL,
+ IS_ENABLED NUMBER(1,0) NOT NULL,
+ FULL_PATH VARCHAR2(254) NOT NULL,
+ CREATION_DATE TIMESTAMP NOT NULL,
+ MODIFIED_DATE TIMESTAMP NOT NULL,
+ CONSTRAINT UIX_SECURITY_PRINCIPAL UNIQUE (FULL_PATH)
+);
+
+ALTER TABLE SECURITY_PRINCIPAL
+ ADD CONSTRAINT SECURITY_PRINCIPAL_PK
+PRIMARY KEY (PRINCIPAL_ID);
+
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- SECURITY_PERMISSION
+-----------------------------------------------------------------------------
+
+CREATE TABLE SECURITY_PERMISSION
+(
+ PERMISSION_ID NUMBER(10,0) NOT NULL,
+ CLASSNAME VARCHAR2(254) NOT NULL,
+ NAME VARCHAR2(254) NOT NULL,
+ ACTIONS VARCHAR2(254) NOT NULL,
+ CREATION_DATE TIMESTAMP NOT NULL,
+ MODIFIED_DATE TIMESTAMP NOT NULL
+);
+
+ALTER TABLE SECURITY_PERMISSION
+ ADD CONSTRAINT SECURITY_PERMISSION_PK
+PRIMARY KEY (PERMISSION_ID);
+
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- PRINCIPAL_PERMISSION
+-----------------------------------------------------------------------------
+
+CREATE TABLE PRINCIPAL_PERMISSION
+(
+ PRINCIPAL_ID NUMBER(10,0) NOT NULL,
+ PERMISSION_ID NUMBER(10,0) NOT NULL
+);
+
+ALTER TABLE PRINCIPAL_PERMISSION
+ ADD CONSTRAINT PRINCIPAL_PERMISSION_PK
+PRIMARY KEY (PRINCIPAL_ID,PERMISSION_ID);
+
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- SECURITY_CREDENTIAL
+-----------------------------------------------------------------------------
+
+CREATE TABLE SECURITY_CREDENTIAL
+(
+ CREDENTIAL_ID NUMBER(10,0) NOT NULL,
+ PRINCIPAL_ID NUMBER(10,0) NOT NULL,
+ COLUMN_VALUE VARCHAR2(254) NOT NULL,
+ TYPE NUMBER(5,0) NOT NULL,
+ CLASSNAME VARCHAR2(254),
+ UPDATE_REQUIRED NUMBER(1,0) NOT NULL,
+ IS_ENCODED NUMBER(1,0) NOT NULL,
+ IS_ENABLED NUMBER(1,0) NOT NULL,
+ AUTH_FAILURES NUMBER(5,0) NOT NULL,
+ IS_EXPIRED NUMBER(1,0) NOT NULL,
+ CREATION_DATE TIMESTAMP NOT NULL,
+ MODIFIED_DATE TIMESTAMP NOT NULL,
+ PREV_AUTH_DATE TIMESTAMP,
+ LAST_AUTH_DATE TIMESTAMP,
+ EXPIRATION_DATE DATE
+);
+
+ALTER TABLE SECURITY_CREDENTIAL
+ ADD CONSTRAINT SECURITY_CREDENTIAL_PK
+PRIMARY KEY (CREDENTIAL_ID);
+
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- SSO_SITE
+-----------------------------------------------------------------------------
+
+CREATE TABLE SSO_SITE
+(
+ SITE_ID NUMBER(10,0) NOT NULL,
+ NAME VARCHAR2(254) NOT NULL,
+ URL VARCHAR2(254) NOT NULL,
+ ALLOW_USER_SET NUMBER(1,0) default 0,
+ REQUIRES_CERTIFICATE NUMBER(1,0) default 0,
+ CHALLENGE_RESPONSE_AUTH NUMBER(1,0) default 0,
+ FORM_AUTH NUMBER(1,0) default 0,
+ FORM_USER_FIELD VARCHAR2(128),
+ FORM_PWD_FIELD VARCHAR2(128),
+ REALM VARCHAR2(128),
+ CONSTRAINT UIX_SITE_URL UNIQUE (URL)
+);
+
+ALTER TABLE SSO_SITE
+ ADD CONSTRAINT SSO_SITE_PK
+PRIMARY KEY (SITE_ID);
+
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- SSO_COOKIE
+-----------------------------------------------------------------------------
+
+CREATE TABLE SSO_COOKIE
+(
+ COOKIE_ID NUMBER(10,0) NOT NULL,
+ COOKIE VARCHAR2(1024) NOT NULL,
+ CREATE_DATE TIMESTAMP NOT NULL
+);
+
+ALTER TABLE SSO_COOKIE
+ ADD CONSTRAINT SSO_COOKIE_PK
+PRIMARY KEY (COOKIE_ID);
+
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- SSO_SITE_TO_PRINCIPALS
+-----------------------------------------------------------------------------
+
+CREATE TABLE SSO_SITE_TO_PRINCIPALS
+(
+ SITE_ID NUMBER(10,0) NOT NULL,
+ PRINCIPAL_ID NUMBER(10,0) NOT NULL
+);
+
+ALTER TABLE SSO_SITE_TO_PRINCIPALS
+ ADD CONSTRAINT SSO_SITE_TO_PRINCIPALS_PK
+PRIMARY KEY (SITE_ID,PRINCIPAL_ID);
+
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- SSO_PRINCIPAL_TO_REMOTE
+-----------------------------------------------------------------------------
+
+CREATE TABLE SSO_PRINCIPAL_TO_REMOTE
+(
+ PRINCIPAL_ID NUMBER(10,0) NOT NULL,
+ REMOTE_PRINCIPAL_ID NUMBER(10,0) NOT NULL
+);
+
+ALTER TABLE SSO_PRINCIPAL_TO_REMOTE
+ ADD CONSTRAINT SSO_PRINCIPAL_TO_REMOTE_PK
+PRIMARY KEY (PRINCIPAL_ID,REMOTE_PRINCIPAL_ID);
+
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- SSO_SITE_TO_REMOTE
+-----------------------------------------------------------------------------
+
+CREATE TABLE SSO_SITE_TO_REMOTE
+(
+ SITE_ID NUMBER(10,0) NOT NULL,
+ PRINCIPAL_ID NUMBER(10,0) NOT NULL
+);
+
+ALTER TABLE SSO_SITE_TO_REMOTE
+ ADD CONSTRAINT SSO_SITE_TO_REMOTE_PK
+PRIMARY KEY (SITE_ID,PRINCIPAL_ID);
+
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- SSO_COOKIE_TO_REMOTE
+-----------------------------------------------------------------------------
+
+CREATE TABLE SSO_COOKIE_TO_REMOTE
+(
+ COOKIE_ID NUMBER(10,0) NOT NULL,
+ REMOTE_PRINCIPAL_ID NUMBER(10,0) NOT NULL
+);
+
+ALTER TABLE SSO_COOKIE_TO_REMOTE
+ ADD CONSTRAINT SSO_COOKIE_TO_REMOTE_PK
+PRIMARY KEY (COOKIE_ID,REMOTE_PRINCIPAL_ID);
+
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- SECURITY_USER_ROLE
+-----------------------------------------------------------------------------
+
+CREATE TABLE SECURITY_USER_ROLE
+(
+ USER_ID NUMBER(10,0) NOT NULL,
+ ROLE_ID NUMBER(10,0) NOT NULL
+);
+
+ALTER TABLE SECURITY_USER_ROLE
+ ADD CONSTRAINT SECURITY_USER_ROLE_PK
+PRIMARY KEY (USER_ID,ROLE_ID);
+
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- SECURITY_USER_GROUP
+-----------------------------------------------------------------------------
+
+CREATE TABLE SECURITY_USER_GROUP
+(
+ USER_ID NUMBER(10,0) NOT NULL,
+ GROUP_ID NUMBER(10,0) NOT NULL
+);
+
+ALTER TABLE SECURITY_USER_GROUP
+ ADD CONSTRAINT SECURITY_USER_GROUP_PK
+PRIMARY KEY (USER_ID,GROUP_ID);
+
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- SECURITY_GROUP_ROLE
+-----------------------------------------------------------------------------
+
+CREATE TABLE SECURITY_GROUP_ROLE
+(
+ GROUP_ID NUMBER(10,0) NOT NULL,
+ ROLE_ID NUMBER(10,0) NOT NULL
+);
+
+ALTER TABLE SECURITY_GROUP_ROLE
+ ADD CONSTRAINT SECURITY_GROUP_ROLE_PK
+PRIMARY KEY (GROUP_ID,ROLE_ID);
+
+
+
+
+
+
+
+
+
+ALTER TABLE PRINCIPAL_PERMISSION
+ ADD CONSTRAINT FK_PRINCIPAL_PERMISSION_1 FOREIGN KEY (PERMISSION_ID)
+ REFERENCES SECURITY_PERMISSION (PERMISSION_ID)
+ON DELETE CASCADE
+;
+
+ALTER TABLE PRINCIPAL_PERMISSION
+ ADD CONSTRAINT FK_PRINCIPAL_PERMISSION_2 FOREIGN KEY (PRINCIPAL_ID)
+ REFERENCES SECURITY_PRINCIPAL (PRINCIPAL_ID)
+ON DELETE CASCADE
+;
+
+
+
+ALTER TABLE SECURITY_CREDENTIAL
+ ADD CONSTRAINT FK_SECURITY_CREDENTIAL_1 FOREIGN KEY (PRINCIPAL_ID)
+ REFERENCES SECURITY_PRINCIPAL (PRINCIPAL_ID)
+ON DELETE CASCADE
+;
+
+
+
+
+
+
+
+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
+;
+
+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
+;
+
+
+
+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
+;
+
+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 CASCADE
+;
+
+
+
+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
+;
+
+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
+;
+
+
+
+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
+;
+
+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
+;
+
+
+
+ALTER TABLE SECURITY_USER_ROLE
+ ADD CONSTRAINT FK_SECURITY_USER_ROLE_1 FOREIGN KEY (ROLE_ID)
+ REFERENCES SECURITY_PRINCIPAL (PRINCIPAL_ID)
+ON DELETE CASCADE
+;
+
+ALTER TABLE SECURITY_USER_ROLE
+ ADD CONSTRAINT FK_SECURITY_USER_ROLE_2 FOREIGN KEY (USER_ID)
+ REFERENCES SECURITY_PRINCIPAL (PRINCIPAL_ID)
+ON DELETE CASCADE
+;
+
+
+
+ALTER TABLE SECURITY_USER_GROUP
+ ADD CONSTRAINT FK_SECURITY_USER_GROUP_1 FOREIGN KEY (GROUP_ID)
+ REFERENCES SECURITY_PRINCIPAL (PRINCIPAL_ID)
+ON DELETE CASCADE
+;
+
+ALTER TABLE SECURITY_USER_GROUP
+ ADD CONSTRAINT FK_SECURITY_USER_GROUP_2 FOREIGN KEY (USER_ID)
+ REFERENCES SECURITY_PRINCIPAL (PRINCIPAL_ID)
+ON DELETE CASCADE
+;
+
+
+
+ALTER TABLE SECURITY_GROUP_ROLE
+ ADD CONSTRAINT FK_SECURITY_GROUP_ROLE_1 FOREIGN KEY (GROUP_ID)
+ REFERENCES SECURITY_PRINCIPAL (PRINCIPAL_ID)
+ON DELETE CASCADE
+;
+
+ALTER TABLE SECURITY_GROUP_ROLE
+ ADD CONSTRAINT FK_SECURITY_GROUP_ROLE_2 FOREIGN KEY (ROLE_ID)
+ REFERENCES SECURITY_PRINCIPAL (PRINCIPAL_ID)
+ON DELETE CASCADE
+;
+
+
+
Propchange: geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/oracle/security-schema.sql
------------------------------------------------------------------------------
svn:eol-style = native
Propchange: geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/oracle/security-schema.sql
------------------------------------------------------------------------------
svn:keywords = Date Revision
Propchange: geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/oracle/security-schema.sql
------------------------------------------------------------------------------
svn:mime-type = text/plain
Added: geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/postgres/phase1-schema.sql
URL: http://svn.apache.org/viewvc/geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/postgres/phase1-schema.sql?rev=588248&view=auto
==============================================================================
--- geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/postgres/phase1-schema.sql (added)
+++ geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/postgres/phase1-schema.sql Thu Oct 25 08:16:02 2007
@@ -0,0 +1,300 @@
+
+-----------------------------------------------------------------------------
+-- MEDIA_TYPE
+-----------------------------------------------------------------------------
+
+
+
+CREATE TABLE MEDIA_TYPE
+(
+ MEDIATYPE_ID INTEGER NOT NULL,
+ NAME VARCHAR(80) NOT NULL,
+ CHARACTER_SET VARCHAR(40),
+ TITLE VARCHAR(80),
+ DESCRIPTION TEXT,
+ PRIMARY KEY (MEDIATYPE_ID)
+);
+
+
+
+
+-----------------------------------------------------------------------------
+-- CLIENT
+-----------------------------------------------------------------------------
+
+
+
+CREATE TABLE CLIENT
+(
+ CLIENT_ID INTEGER NOT NULL,
+ EVAL_ORDER INTEGER NOT NULL,
+ NAME VARCHAR(80) NOT NULL,
+ USER_AGENT_PATTERN VARCHAR(128),
+ MANUFACTURER VARCHAR(80),
+ MODEL VARCHAR(80),
+ VERSION VARCHAR(40),
+ PREFERRED_MIMETYPE_ID INTEGER NOT NULL,
+ PRIMARY KEY (CLIENT_ID)
+);
+
+
+
+
+-----------------------------------------------------------------------------
+-- MIMETYPE
+-----------------------------------------------------------------------------
+
+
+
+CREATE TABLE MIMETYPE
+(
+ MIMETYPE_ID INTEGER NOT NULL,
+ NAME VARCHAR(80) NOT NULL,
+ PRIMARY KEY (MIMETYPE_ID)
+);
+
+
+
+
+-----------------------------------------------------------------------------
+-- CAPABILITY
+-----------------------------------------------------------------------------
+
+
+
+CREATE TABLE CAPABILITY
+(
+ CAPABILITY_ID INTEGER NOT NULL,
+ CAPABILITY VARCHAR(80) NOT NULL,
+ PRIMARY KEY (CAPABILITY_ID)
+);
+
+
+
+
+-----------------------------------------------------------------------------
+-- CLIENT_TO_CAPABILITY
+-----------------------------------------------------------------------------
+
+
+
+CREATE TABLE CLIENT_TO_CAPABILITY
+(
+ CLIENT_ID INTEGER NOT NULL,
+ CAPABILITY_ID INTEGER NOT NULL
+);
+
+
+
+
+-----------------------------------------------------------------------------
+-- CLIENT_TO_MIMETYPE
+-----------------------------------------------------------------------------
+
+
+
+CREATE TABLE CLIENT_TO_MIMETYPE
+(
+ CLIENT_ID INTEGER NOT NULL,
+ MIMETYPE_ID INTEGER NOT NULL
+);
+
+
+
+
+-----------------------------------------------------------------------------
+-- MEDIATYPE_TO_CAPABILITY
+-----------------------------------------------------------------------------
+
+
+
+CREATE TABLE MEDIATYPE_TO_CAPABILITY
+(
+ MEDIATYPE_ID INTEGER NOT NULL,
+ CAPABILITY_ID INTEGER NOT NULL
+);
+
+
+
+
+-----------------------------------------------------------------------------
+-- MEDIATYPE_TO_MIMETYPE
+-----------------------------------------------------------------------------
+
+
+
+CREATE TABLE MEDIATYPE_TO_MIMETYPE
+(
+ MEDIATYPE_ID INTEGER NOT NULL,
+ MIMETYPE_ID INTEGER NOT NULL
+);
+
+
+
+
+-----------------------------------------------------------------------------
+-- PORTLET_STATISTICS
+-----------------------------------------------------------------------------
+
+
+
+CREATE TABLE PORTLET_STATISTICS
+(
+ IPADDRESS VARCHAR(80),
+ USER_NAME VARCHAR(80),
+ TIME_STAMP TIMESTAMP,
+ PAGE VARCHAR(80),
+ PORTLET VARCHAR(255),
+ STATUS INTEGER,
+ ELAPSED_TIME INT8
+);
+
+
+
+
+-----------------------------------------------------------------------------
+-- PAGE_STATISTICS
+-----------------------------------------------------------------------------
+
+
+
+CREATE TABLE PAGE_STATISTICS
+(
+ IPADDRESS VARCHAR(80),
+ USER_NAME VARCHAR(80),
+ TIME_STAMP TIMESTAMP,
+ PAGE VARCHAR(80),
+ STATUS INTEGER,
+ ELAPSED_TIME INT8
+);
+
+
+
+
+-----------------------------------------------------------------------------
+-- USER_STATISTICS
+-----------------------------------------------------------------------------
+
+
+
+CREATE TABLE USER_STATISTICS
+(
+ IPADDRESS VARCHAR(80),
+ USER_NAME VARCHAR(80),
+ TIME_STAMP TIMESTAMP,
+ STATUS INTEGER,
+ ELAPSED_TIME INT8
+);
+
+
+
+
+-----------------------------------------------------------------------------
+-- ADMIN_ACTIVITY
+-----------------------------------------------------------------------------
+
+
+
+CREATE TABLE ADMIN_ACTIVITY
+(
+ ACTIVITY VARCHAR(40),
+ CATEGORY VARCHAR(40),
+ ADMIN VARCHAR(80),
+ USER_NAME VARCHAR(80),
+ TIME_STAMP TIMESTAMP,
+ IPADDRESS VARCHAR(80),
+ ATTR_NAME VARCHAR(40),
+ ATTR_VALUE_BEFORE VARCHAR(80),
+ ATTR_VALUE_AFTER VARCHAR(80),
+ DESCRIPTION VARCHAR(128)
+);
+
+
+
+
+-----------------------------------------------------------------------------
+-- USER_ACTIVITY
+-----------------------------------------------------------------------------
+
+
+
+CREATE TABLE USER_ACTIVITY
+(
+ ACTIVITY VARCHAR(40),
+ CATEGORY VARCHAR(40),
+ USER_NAME VARCHAR(80),
+ TIME_STAMP TIMESTAMP,
+ IPADDRESS VARCHAR(80),
+ ATTR_NAME VARCHAR(40),
+ ATTR_VALUE_BEFORE VARCHAR(80),
+ ATTR_VALUE_AFTER VARCHAR(80),
+ DESCRIPTION VARCHAR(128)
+);
+
+
+
+
+----------------------------------------------------------------------
+-- USER_ACTIVITY
+----------------------------------------------------------------------
+
+
+----------------------------------------------------------------------
+-- MEDIA_TYPE
+----------------------------------------------------------------------
+
+
+----------------------------------------------------------------------
+-- CLIENT
+----------------------------------------------------------------------
+
+
+----------------------------------------------------------------------
+-- MIMETYPE
+----------------------------------------------------------------------
+
+
+----------------------------------------------------------------------
+-- CAPABILITY
+----------------------------------------------------------------------
+
+
+----------------------------------------------------------------------
+-- CLIENT_TO_CAPABILITY
+----------------------------------------------------------------------
+
+
+----------------------------------------------------------------------
+-- CLIENT_TO_MIMETYPE
+----------------------------------------------------------------------
+
+
+----------------------------------------------------------------------
+-- MEDIATYPE_TO_CAPABILITY
+----------------------------------------------------------------------
+
+
+----------------------------------------------------------------------
+-- MEDIATYPE_TO_MIMETYPE
+----------------------------------------------------------------------
+
+
+----------------------------------------------------------------------
+-- PORTLET_STATISTICS
+----------------------------------------------------------------------
+
+
+----------------------------------------------------------------------
+-- PAGE_STATISTICS
+----------------------------------------------------------------------
+
+
+----------------------------------------------------------------------
+-- USER_STATISTICS
+----------------------------------------------------------------------
+
+
+----------------------------------------------------------------------
+-- ADMIN_ACTIVITY
+----------------------------------------------------------------------
+
Propchange: geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/postgres/phase1-schema.sql
------------------------------------------------------------------------------
svn:eol-style = native
Propchange: geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/postgres/phase1-schema.sql
------------------------------------------------------------------------------
svn:keywords = Date Revision
Propchange: geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/postgres/phase1-schema.sql
------------------------------------------------------------------------------
svn:mime-type = text/plain
Added: geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/postgres/phase2-schema.sql
URL: http://svn.apache.org/viewvc/geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/postgres/phase2-schema.sql?rev=588248&view=auto
==============================================================================
--- geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/postgres/phase2-schema.sql (added)
+++ geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/postgres/phase2-schema.sql Thu Oct 25 08:16:02 2007
@@ -0,0 +1,1035 @@
+
+-----------------------------------------------------------------------------
+-- FOLDER
+-----------------------------------------------------------------------------
+
+
+
+CREATE TABLE FOLDER
+(
+ FOLDER_ID INTEGER NOT NULL,
+ PARENT_ID INTEGER,
+ PATH VARCHAR(240) NOT NULL,
+ NAME VARCHAR(80) NOT NULL,
+ TITLE VARCHAR(100),
+ SHORT_TITLE VARCHAR(40),
+ IS_HIDDEN INT2 NOT NULL,
+ SKIN VARCHAR(80),
+ DEFAULT_LAYOUT_DECORATOR VARCHAR(80),
+ DEFAULT_PORTLET_DECORATOR VARCHAR(80),
+ DEFAULT_PAGE_NAME VARCHAR(80),
+ SUBSITE VARCHAR(40),
+ USER_PRINCIPAL VARCHAR(40),
+ ROLE_PRINCIPAL VARCHAR(40),
+ GROUP_PRINCIPAL VARCHAR(40),
+ MEDIATYPE VARCHAR(15),
+ LOCALE VARCHAR(20),
+ EXT_ATTR_NAME VARCHAR(15),
+ EXT_ATTR_VALUE VARCHAR(40),
+ OWNER_PRINCIPAL VARCHAR(40),
+ PRIMARY KEY (FOLDER_ID),
+ CONSTRAINT UN_FOLDER_1 UNIQUE (PATH)
+);
+CREATE INDEX IX_FOLDER_1 ON FOLDER (PARENT_ID);
+
+
+
+
+-----------------------------------------------------------------------------
+-- FOLDER_METADATA
+-----------------------------------------------------------------------------
+
+
+
+CREATE TABLE FOLDER_METADATA
+(
+ METADATA_ID INTEGER NOT NULL,
+ FOLDER_ID INTEGER NOT NULL,
+ NAME VARCHAR(15) NOT NULL,
+ LOCALE VARCHAR(20) NOT NULL,
+ VALUE VARCHAR(100) NOT NULL,
+ PRIMARY KEY (METADATA_ID),
+ CONSTRAINT UN_FOLDER_METADATA_1 UNIQUE (FOLDER_ID, NAME, LOCALE, VALUE)
+);
+CREATE INDEX IX_FOLDER_METADATA_1 ON FOLDER_METADATA (FOLDER_ID);
+
+
+
+
+-----------------------------------------------------------------------------
+-- FOLDER_CONSTRAINT
+-----------------------------------------------------------------------------
+
+
+
+CREATE TABLE FOLDER_CONSTRAINT
+(
+ CONSTRAINT_ID INTEGER NOT NULL,
+ FOLDER_ID INTEGER NOT NULL,
+ APPLY_ORDER INTEGER NOT NULL,
+ USER_PRINCIPALS_ACL VARCHAR(120),
+ ROLE_PRINCIPALS_ACL VARCHAR(120),
+ GROUP_PRINCIPALS_ACL VARCHAR(120),
+ PERMISSIONS_ACL VARCHAR(120),
+ PRIMARY KEY (CONSTRAINT_ID)
+);
+CREATE INDEX IX_FOLDER_CONSTRAINT_1 ON FOLDER_CONSTRAINT (FOLDER_ID);
+
+
+
+
+-----------------------------------------------------------------------------
+-- FOLDER_CONSTRAINTS_REF
+-----------------------------------------------------------------------------
+
+
+
+CREATE TABLE FOLDER_CONSTRAINTS_REF
+(
+ CONSTRAINTS_REF_ID INTEGER NOT NULL,
+ FOLDER_ID INTEGER NOT NULL,
+ APPLY_ORDER INTEGER NOT NULL,
+ NAME VARCHAR(40) NOT NULL,
+ PRIMARY KEY (CONSTRAINTS_REF_ID),
+ CONSTRAINT UN_FOLDER_CONSTRAINTS_REF_1 UNIQUE (FOLDER_ID, NAME)
+);
+CREATE INDEX IX_FOLDER_CONSTRAINTS_REF_1 ON FOLDER_CONSTRAINTS_REF (FOLDER_ID);
+
+
+
+
+-----------------------------------------------------------------------------
+-- FOLDER_ORDER
+-----------------------------------------------------------------------------
+
+
+
+CREATE TABLE FOLDER_ORDER
+(
+ ORDER_ID INTEGER NOT NULL,
+ FOLDER_ID INTEGER NOT NULL,
+ SORT_ORDER INTEGER NOT NULL,
+ NAME VARCHAR(80) NOT NULL,
+ PRIMARY KEY (ORDER_ID),
+ CONSTRAINT UN_FOLDER_ORDER_1 UNIQUE (FOLDER_ID, NAME)
+);
+CREATE INDEX IX_FOLDER_ORDER_1 ON FOLDER_ORDER (FOLDER_ID);
+
+
+
+
+-----------------------------------------------------------------------------
+-- FOLDER_MENU
+-----------------------------------------------------------------------------
+
+
+
+CREATE TABLE FOLDER_MENU
+(
+ MENU_ID INTEGER NOT NULL,
+ CLASS_NAME VARCHAR(100) NOT NULL,
+ PARENT_ID INTEGER,
+ FOLDER_ID INTEGER,
+ ELEMENT_ORDER INTEGER,
+ NAME VARCHAR(100),
+ TITLE VARCHAR(100),
+ SHORT_TITLE VARCHAR(40),
+ TEXT VARCHAR(100),
+ OPTIONS VARCHAR(255),
+ DEPTH INTEGER,
+ IS_PATHS INT2,
+ IS_REGEXP INT2,
+ PROFILE VARCHAR(80),
+ OPTIONS_ORDER VARCHAR(255),
+ SKIN VARCHAR(80),
+ IS_NEST INT2,
+ PRIMARY KEY (MENU_ID)
+);
+CREATE INDEX IX_FOLDER_MENU_1 ON FOLDER_MENU (PARENT_ID);
+CREATE INDEX UN_FOLDER_MENU_1 ON FOLDER_MENU (FOLDER_ID, NAME);
+
+
+
+
+-----------------------------------------------------------------------------
+-- FOLDER_MENU_METADATA
+-----------------------------------------------------------------------------
+
+
+
+CREATE TABLE FOLDER_MENU_METADATA
+(
+ METADATA_ID INTEGER NOT NULL,
+ MENU_ID INTEGER NOT NULL,
+ NAME VARCHAR(15) NOT NULL,
+ LOCALE VARCHAR(20) NOT NULL,
+ VALUE VARCHAR(100) NOT NULL,
+ PRIMARY KEY (METADATA_ID),
+ CONSTRAINT UN_FOLDER_MENU_METADATA_1 UNIQUE (MENU_ID, NAME, LOCALE, VALUE)
+);
+CREATE INDEX IX_FOLDER_MENU_METADATA_1 ON FOLDER_MENU_METADATA (MENU_ID);
+
+
+
+
+-----------------------------------------------------------------------------
+-- PAGE
+-----------------------------------------------------------------------------
+
+
+
+CREATE TABLE PAGE
+(
+ PAGE_ID INTEGER NOT NULL,
+ PARENT_ID INTEGER NOT NULL,
+ PATH VARCHAR(240) NOT NULL,
+ NAME VARCHAR(80) NOT NULL,
+ VERSION VARCHAR(40),
+ TITLE VARCHAR(100),
+ SHORT_TITLE VARCHAR(40),
+ IS_HIDDEN INT2 NOT NULL,
+ SKIN VARCHAR(80),
+ DEFAULT_LAYOUT_DECORATOR VARCHAR(80),
+ DEFAULT_PORTLET_DECORATOR VARCHAR(80),
+ SUBSITE VARCHAR(40),
+ USER_PRINCIPAL VARCHAR(40),
+ ROLE_PRINCIPAL VARCHAR(40),
+ GROUP_PRINCIPAL VARCHAR(40),
+ MEDIATYPE VARCHAR(15),
+ LOCALE VARCHAR(20),
+ EXT_ATTR_NAME VARCHAR(15),
+ EXT_ATTR_VALUE VARCHAR(40),
+ OWNER_PRINCIPAL VARCHAR(40),
+ PRIMARY KEY (PAGE_ID),
+ CONSTRAINT UN_PAGE_1 UNIQUE (PATH)
+);
+CREATE INDEX IX_PAGE_1 ON PAGE (PARENT_ID);
+
+
+
+
+-----------------------------------------------------------------------------
+-- PAGE_METADATA
+-----------------------------------------------------------------------------
+
+
+
+CREATE TABLE PAGE_METADATA
+(
+ METADATA_ID INTEGER NOT NULL,
+ PAGE_ID INTEGER NOT NULL,
+ NAME VARCHAR(15) NOT NULL,
+ LOCALE VARCHAR(20) NOT NULL,
+ VALUE VARCHAR(100) NOT NULL,
+ PRIMARY KEY (METADATA_ID),
+ CONSTRAINT UN_PAGE_METADATA_1 UNIQUE (PAGE_ID, NAME, LOCALE, VALUE)
+);
+CREATE INDEX IX_PAGE_METADATA_1 ON PAGE_METADATA (PAGE_ID);
+
+
+
+
+-----------------------------------------------------------------------------
+-- PAGE_CONSTRAINT
+-----------------------------------------------------------------------------
+
+
+
+CREATE TABLE PAGE_CONSTRAINT
+(
+ CONSTRAINT_ID INTEGER NOT NULL,
+ PAGE_ID INTEGER NOT NULL,
+ APPLY_ORDER INTEGER NOT NULL,
+ USER_PRINCIPALS_ACL VARCHAR(120),
+ ROLE_PRINCIPALS_ACL VARCHAR(120),
+ GROUP_PRINCIPALS_ACL VARCHAR(120),
+ PERMISSIONS_ACL VARCHAR(120),
+ PRIMARY KEY (CONSTRAINT_ID)
+);
+CREATE INDEX IX_PAGE_CONSTRAINT_1 ON PAGE_CONSTRAINT (PAGE_ID);
+
+
+
+
+-----------------------------------------------------------------------------
+-- PAGE_CONSTRAINTS_REF
+-----------------------------------------------------------------------------
+
+
+
+CREATE TABLE PAGE_CONSTRAINTS_REF
+(
+ CONSTRAINTS_REF_ID INTEGER NOT NULL,
+ PAGE_ID INTEGER NOT NULL,
+ APPLY_ORDER INTEGER NOT NULL,
+ NAME VARCHAR(40) NOT NULL,
+ PRIMARY KEY (CONSTRAINTS_REF_ID),
+ CONSTRAINT UN_PAGE_CONSTRAINTS_REF_1 UNIQUE (PAGE_ID, NAME)
+);
+CREATE INDEX IX_PAGE_CONSTRAINTS_REF_1 ON PAGE_CONSTRAINTS_REF (PAGE_ID);
+
+
+
+
+-----------------------------------------------------------------------------
+-- PAGE_MENU
+-----------------------------------------------------------------------------
+
+
+
+CREATE TABLE PAGE_MENU
+(
+ MENU_ID INTEGER NOT NULL,
+ CLASS_NAME VARCHAR(100) NOT NULL,
+ PARENT_ID INTEGER,
+ PAGE_ID INTEGER,
+ ELEMENT_ORDER INTEGER,
+ NAME VARCHAR(100),
+ TITLE VARCHAR(100),
+ SHORT_TITLE VARCHAR(40),
+ TEXT VARCHAR(100),
+ OPTIONS VARCHAR(255),
+ DEPTH INTEGER,
+ IS_PATHS INT2,
+ IS_REGEXP INT2,
+ PROFILE VARCHAR(80),
+ OPTIONS_ORDER VARCHAR(255),
+ SKIN VARCHAR(80),
+ IS_NEST INT2,
+ PRIMARY KEY (MENU_ID)
+);
+CREATE INDEX IX_PAGE_MENU_1 ON PAGE_MENU (PARENT_ID);
+CREATE INDEX UN_PAGE_MENU_1 ON PAGE_MENU (PAGE_ID, NAME);
+
+
+
+
+-----------------------------------------------------------------------------
+-- PAGE_MENU_METADATA
+-----------------------------------------------------------------------------
+
+
+
+CREATE TABLE PAGE_MENU_METADATA
+(
+ METADATA_ID INTEGER NOT NULL,
+ MENU_ID INTEGER NOT NULL,
+ NAME VARCHAR(15) NOT NULL,
+ LOCALE VARCHAR(20) NOT NULL,
+ VALUE VARCHAR(100) NOT NULL,
+ PRIMARY KEY (METADATA_ID),
+ CONSTRAINT UN_PAGE_MENU_METADATA_1 UNIQUE (MENU_ID, NAME, LOCALE, VALUE)
+);
+CREATE INDEX IX_PAGE_MENU_METADATA_1 ON PAGE_MENU_METADATA (MENU_ID);
+
+
+
+
+-----------------------------------------------------------------------------
+-- FRAGMENT
+-----------------------------------------------------------------------------
+
+
+
+CREATE TABLE FRAGMENT
+(
+ FRAGMENT_ID INTEGER NOT NULL,
+ PARENT_ID INTEGER,
+ PAGE_ID INTEGER,
+ NAME VARCHAR(100),
+ TITLE VARCHAR(100),
+ SHORT_TITLE VARCHAR(40),
+ TYPE VARCHAR(40),
+ SKIN VARCHAR(80),
+ DECORATOR VARCHAR(80),
+ STATE VARCHAR(10),
+ PMODE VARCHAR(10),
+ LAYOUT_ROW INTEGER,
+ LAYOUT_COLUMN INTEGER,
+ LAYOUT_SIZES VARCHAR(20),
+ LAYOUT_X FLOAT,
+ LAYOUT_Y FLOAT,
+ LAYOUT_Z FLOAT,
+ LAYOUT_WIDTH FLOAT,
+ LAYOUT_HEIGHT FLOAT,
+ EXT_PROP_NAME_1 VARCHAR(40),
+ EXT_PROP_VALUE_1 VARCHAR(80),
+ EXT_PROP_NAME_2 VARCHAR(40),
+ EXT_PROP_VALUE_2 VARCHAR(80),
+ OWNER_PRINCIPAL VARCHAR(40),
+ PRIMARY KEY (FRAGMENT_ID)
+);
+CREATE INDEX IX_FRAGMENT_1 ON FRAGMENT (PARENT_ID);
+CREATE INDEX UN_FRAGMENT_1 ON FRAGMENT (PAGE_ID);
+
+
+
+
+-----------------------------------------------------------------------------
+-- FRAGMENT_CONSTRAINT
+-----------------------------------------------------------------------------
+
+
+
+CREATE TABLE FRAGMENT_CONSTRAINT
+(
+ CONSTRAINT_ID INTEGER NOT NULL,
+ FRAGMENT_ID INTEGER NOT NULL,
+ APPLY_ORDER INTEGER NOT NULL,
+ USER_PRINCIPALS_ACL VARCHAR(120),
+ ROLE_PRINCIPALS_ACL VARCHAR(120),
+ GROUP_PRINCIPALS_ACL VARCHAR(120),
+ PERMISSIONS_ACL VARCHAR(120),
+ PRIMARY KEY (CONSTRAINT_ID)
+);
+CREATE INDEX IX_FRAGMENT_CONSTRAINT_1 ON FRAGMENT_CONSTRAINT (FRAGMENT_ID);
+
+
+
+
+-----------------------------------------------------------------------------
+-- FRAGMENT_CONSTRAINTS_REF
+-----------------------------------------------------------------------------
+
+
+
+CREATE TABLE FRAGMENT_CONSTRAINTS_REF
+(
+ CONSTRAINTS_REF_ID INTEGER NOT NULL,
+ FRAGMENT_ID INTEGER NOT NULL,
+ APPLY_ORDER INTEGER NOT NULL,
+ NAME VARCHAR(40) NOT NULL,
+ PRIMARY KEY (CONSTRAINTS_REF_ID),
+ CONSTRAINT UN_FRAGMENT_CONSTRAINTS_REF_1 UNIQUE (FRAGMENT_ID, NAME)
+);
+CREATE INDEX IX_FRAGMENT_CONSTRAINTS_REF_1 ON FRAGMENT_CONSTRAINTS_REF (FRAGMENT_ID);
+
+
+
+
+-----------------------------------------------------------------------------
+-- FRAGMENT_PREF
+-----------------------------------------------------------------------------
+
+
+
+CREATE TABLE FRAGMENT_PREF
+(
+ PREF_ID INTEGER NOT NULL,
+ FRAGMENT_ID INTEGER NOT NULL,
+ NAME VARCHAR(40) NOT NULL,
+ IS_READ_ONLY INT2 NOT NULL,
+ PRIMARY KEY (PREF_ID),
+ CONSTRAINT UN_FRAGMENT_PREF_1 UNIQUE (FRAGMENT_ID, NAME)
+);
+CREATE INDEX IX_FRAGMENT_PREF_1 ON FRAGMENT_PREF (FRAGMENT_ID);
+
+
+
+
+-----------------------------------------------------------------------------
+-- FRAGMENT_PREF_VALUE
+-----------------------------------------------------------------------------
+
+
+
+CREATE TABLE FRAGMENT_PREF_VALUE
+(
+ PREF_VALUE_ID INTEGER NOT NULL,
+ PREF_ID INTEGER NOT NULL,
+ VALUE_ORDER INTEGER NOT NULL,
+ VALUE VARCHAR(100) NOT NULL,
+ PRIMARY KEY (PREF_VALUE_ID)
+);
+CREATE INDEX IX_FRAGMENT_PREF_VALUE_1 ON FRAGMENT_PREF_VALUE (PREF_ID);
+
+
+
+
+-----------------------------------------------------------------------------
+-- LINK
+-----------------------------------------------------------------------------
+
+
+
+CREATE TABLE LINK
+(
+ LINK_ID INTEGER NOT NULL,
+ PARENT_ID INTEGER NOT NULL,
+ PATH VARCHAR(240) NOT NULL,
+ NAME VARCHAR(80) NOT NULL,
+ VERSION VARCHAR(40),
+ TITLE VARCHAR(100),
+ SHORT_TITLE VARCHAR(40),
+ IS_HIDDEN INT2 NOT NULL,
+ SKIN VARCHAR(80),
+ TARGET VARCHAR(80),
+ URL VARCHAR(255),
+ SUBSITE VARCHAR(40),
+ USER_PRINCIPAL VARCHAR(40),
+ ROLE_PRINCIPAL VARCHAR(40),
+ GROUP_PRINCIPAL VARCHAR(40),
+ MEDIATYPE VARCHAR(15),
+ LOCALE VARCHAR(20),
+ EXT_ATTR_NAME VARCHAR(15),
+ EXT_ATTR_VALUE VARCHAR(40),
+ OWNER_PRINCIPAL VARCHAR(40),
+ PRIMARY KEY (LINK_ID),
+ CONSTRAINT UN_LINK_1 UNIQUE (PATH)
+);
+CREATE INDEX IX_LINK_1 ON LINK (PARENT_ID);
+
+
+
+
+-----------------------------------------------------------------------------
+-- LINK_METADATA
+-----------------------------------------------------------------------------
+
+
+
+CREATE TABLE LINK_METADATA
+(
+ METADATA_ID INTEGER NOT NULL,
+ LINK_ID INTEGER NOT NULL,
+ NAME VARCHAR(15) NOT NULL,
+ LOCALE VARCHAR(20) NOT NULL,
+ VALUE VARCHAR(100) NOT NULL,
+ PRIMARY KEY (METADATA_ID),
+ CONSTRAINT UN_LINK_METADATA_1 UNIQUE (LINK_ID, NAME, LOCALE, VALUE)
+);
+CREATE INDEX IX_LINK_METADATA_1 ON LINK_METADATA (LINK_ID);
+
+
+
+
+-----------------------------------------------------------------------------
+-- LINK_CONSTRAINT
+-----------------------------------------------------------------------------
+
+
+
+CREATE TABLE LINK_CONSTRAINT
+(
+ CONSTRAINT_ID INTEGER NOT NULL,
+ LINK_ID INTEGER NOT NULL,
+ APPLY_ORDER INTEGER NOT NULL,
+ USER_PRINCIPALS_ACL VARCHAR(120),
+ ROLE_PRINCIPALS_ACL VARCHAR(120),
+ GROUP_PRINCIPALS_ACL VARCHAR(120),
+ PERMISSIONS_ACL VARCHAR(120),
+ PRIMARY KEY (CONSTRAINT_ID)
+);
+CREATE INDEX IX_LINK_CONSTRAINT_1 ON LINK_CONSTRAINT (LINK_ID);
+
+
+
+
+-----------------------------------------------------------------------------
+-- LINK_CONSTRAINTS_REF
+-----------------------------------------------------------------------------
+
+
+
+CREATE TABLE LINK_CONSTRAINTS_REF
+(
+ CONSTRAINTS_REF_ID INTEGER NOT NULL,
+ LINK_ID INTEGER NOT NULL,
+ APPLY_ORDER INTEGER NOT NULL,
+ NAME VARCHAR(40) NOT NULL,
+ PRIMARY KEY (CONSTRAINTS_REF_ID),
+ CONSTRAINT UN_LINK_CONSTRAINTS_REF_1 UNIQUE (LINK_ID, NAME)
+);
+CREATE INDEX IX_LINK_CONSTRAINTS_REF_1 ON LINK_CONSTRAINTS_REF (LINK_ID);
+
+
+
+
+-----------------------------------------------------------------------------
+-- PAGE_SECURITY
+-----------------------------------------------------------------------------
+
+
+
+CREATE TABLE PAGE_SECURITY
+(
+ PAGE_SECURITY_ID INTEGER NOT NULL,
+ PARENT_ID INTEGER NOT NULL,
+ PATH VARCHAR(240) NOT NULL,
+ NAME VARCHAR(80) NOT NULL,
+ VERSION VARCHAR(40),
+ SUBSITE VARCHAR(40),
+ USER_PRINCIPAL VARCHAR(40),
+ ROLE_PRINCIPAL VARCHAR(40),
+ GROUP_PRINCIPAL VARCHAR(40),
+ MEDIATYPE VARCHAR(15),
+ LOCALE VARCHAR(20),
+ EXT_ATTR_NAME VARCHAR(15),
+ EXT_ATTR_VALUE VARCHAR(40),
+ PRIMARY KEY (PAGE_SECURITY_ID),
+ CONSTRAINT UN_PAGE_SECURITY_1 UNIQUE (PARENT_ID),
+ CONSTRAINT UN_PAGE_SECURITY_2 UNIQUE (PATH)
+);
+
+
+
+
+-----------------------------------------------------------------------------
+-- PAGE_SEC_CONSTRAINTS_DEF
+-----------------------------------------------------------------------------
+
+
+
+CREATE TABLE PAGE_SEC_CONSTRAINTS_DEF
+(
+ CONSTRAINTS_DEF_ID INTEGER NOT NULL,
+ PAGE_SECURITY_ID INTEGER NOT NULL,
+ NAME VARCHAR(40) NOT NULL,
+ PRIMARY KEY (CONSTRAINTS_DEF_ID),
+ CONSTRAINT UN_PAGE_SEC_CONSTRAINTS_DEF_1 UNIQUE (PAGE_SECURITY_ID, NAME)
+);
+CREATE INDEX IX_PAGE_SEC_CONSTRAINTS_DEF_1 ON PAGE_SEC_CONSTRAINTS_DEF (PAGE_SECURITY_ID);
+
+
+
+
+-----------------------------------------------------------------------------
+-- PAGE_SEC_CONSTRAINT_DEF
+-----------------------------------------------------------------------------
+
+
+
+CREATE TABLE PAGE_SEC_CONSTRAINT_DEF
+(
+ CONSTRAINT_DEF_ID INTEGER NOT NULL,
+ CONSTRAINTS_DEF_ID INTEGER NOT NULL,
+ APPLY_ORDER INTEGER NOT NULL,
+ USER_PRINCIPALS_ACL VARCHAR(120),
+ ROLE_PRINCIPALS_ACL VARCHAR(120),
+ GROUP_PRINCIPALS_ACL VARCHAR(120),
+ PERMISSIONS_ACL VARCHAR(120),
+ PRIMARY KEY (CONSTRAINT_DEF_ID)
+);
+CREATE INDEX IX_PAGE_SEC_CONSTRAINT_DEF_1 ON PAGE_SEC_CONSTRAINT_DEF (CONSTRAINTS_DEF_ID);
+
+
+
+
+-----------------------------------------------------------------------------
+-- PAGE_SEC_CONSTRAINTS_REF
+-----------------------------------------------------------------------------
+
+
+
+CREATE TABLE PAGE_SEC_CONSTRAINTS_REF
+(
+ CONSTRAINTS_REF_ID INTEGER NOT NULL,
+ PAGE_SECURITY_ID INTEGER NOT NULL,
+ APPLY_ORDER INTEGER NOT NULL,
+ NAME VARCHAR(40) NOT NULL,
+ PRIMARY KEY (CONSTRAINTS_REF_ID),
+ CONSTRAINT UN_PAGE_SEC_CONSTRAINTS_REF_1 UNIQUE (PAGE_SECURITY_ID, NAME)
+);
+CREATE INDEX IX_PAGE_SEC_CONSTRAINTS_REF_1 ON PAGE_SEC_CONSTRAINTS_REF (PAGE_SECURITY_ID);
+
+
+
+
+-----------------------------------------------------------------------------
+-- PROFILING_RULE
+-----------------------------------------------------------------------------
+
+
+
+CREATE TABLE PROFILING_RULE
+(
+ RULE_ID VARCHAR(80) NOT NULL,
+ CLASS_NAME VARCHAR(100) NOT NULL,
+ TITLE VARCHAR(100),
+ PRIMARY KEY (RULE_ID)
+);
+
+
+
+
+-----------------------------------------------------------------------------
+-- RULE_CRITERION
+-----------------------------------------------------------------------------
+
+
+
+CREATE TABLE RULE_CRITERION
+(
+ CRITERION_ID VARCHAR(80) NOT NULL,
+ RULE_ID VARCHAR(80) NOT NULL,
+ FALLBACK_ORDER INTEGER NOT NULL,
+ REQUEST_TYPE VARCHAR(40) NOT NULL,
+ NAME VARCHAR(80) NOT NULL,
+ COLUMN_VALUE VARCHAR(128),
+ FALLBACK_TYPE INTEGER default 1,
+ PRIMARY KEY (CRITERION_ID)
+);
+CREATE INDEX IX_RULE_CRITERION_1 ON RULE_CRITERION (RULE_ID, FALLBACK_ORDER);
+
+
+
+
+-----------------------------------------------------------------------------
+-- PRINCIPAL_RULE_ASSOC
+-----------------------------------------------------------------------------
+
+
+
+CREATE TABLE PRINCIPAL_RULE_ASSOC
+(
+ PRINCIPAL_NAME VARCHAR(80) NOT NULL,
+ LOCATOR_NAME VARCHAR(80) NOT NULL,
+ RULE_ID VARCHAR(80) NOT NULL,
+ PRIMARY KEY (PRINCIPAL_NAME,LOCATOR_NAME)
+);
+
+
+
+
+-----------------------------------------------------------------------------
+-- PROFILE_PAGE_ASSOC
+-----------------------------------------------------------------------------
+
+
+
+CREATE TABLE PROFILE_PAGE_ASSOC
+(
+ LOCATOR_HASH VARCHAR(40) NOT NULL,
+ PAGE_ID VARCHAR(80) NOT NULL,
+ CONSTRAINT UN_PROFILE_PAGE_1 UNIQUE (LOCATOR_HASH, PAGE_ID)
+);
+
+
+
+
+-----------------------------------------------------------------------------
+-- CLUBS
+-----------------------------------------------------------------------------
+
+
+
+CREATE TABLE CLUBS
+(
+ NAME VARCHAR(80) NOT NULL,
+ COUNTRY VARCHAR(40) NOT NULL,
+ CITY VARCHAR(40) NOT NULL,
+ STADIUM VARCHAR(80) NOT NULL,
+ CAPACITY INTEGER,
+ FOUNDED INTEGER,
+ PITCH VARCHAR(40),
+ NICKNAME VARCHAR(40),
+ PRIMARY KEY (NAME)
+);
+
+
+
+
+----------------------------------------------------------------------
+-- CLUBS
+----------------------------------------------------------------------
+
+ALTER TABLE FOLDER
+ ADD CONSTRAINT FK_FOLDER_1 FOREIGN KEY (PARENT_ID)
+ REFERENCES FOLDER (FOLDER_ID)
+ ON DELETE CASCADE
+;
+
+----------------------------------------------------------------------
+-- FOLDER
+----------------------------------------------------------------------
+
+ALTER TABLE FOLDER_METADATA
+ ADD CONSTRAINT FK_FOLDER_METADATA_1 FOREIGN KEY (FOLDER_ID)
+ REFERENCES FOLDER (FOLDER_ID)
+ ON DELETE CASCADE
+;
+
+----------------------------------------------------------------------
+-- FOLDER_METADATA
+----------------------------------------------------------------------
+
+ALTER TABLE FOLDER_CONSTRAINT
+ ADD CONSTRAINT FK_FOLDER_CONSTRAINT_1 FOREIGN KEY (FOLDER_ID)
+ REFERENCES FOLDER (FOLDER_ID)
+ ON DELETE CASCADE
+;
+
+----------------------------------------------------------------------
+-- FOLDER_CONSTRAINT
+----------------------------------------------------------------------
+
+ALTER TABLE FOLDER_CONSTRAINTS_REF
+ ADD CONSTRAINT FK_FOLDER_CONSTRAINTS_REF_1 FOREIGN KEY (FOLDER_ID)
+ REFERENCES FOLDER (FOLDER_ID)
+ ON DELETE CASCADE
+;
+
+----------------------------------------------------------------------
+-- FOLDER_CONSTRAINTS_REF
+----------------------------------------------------------------------
+
+ALTER TABLE FOLDER_ORDER
+ ADD CONSTRAINT FK_FOLDER_ORDER_1 FOREIGN KEY (FOLDER_ID)
+ REFERENCES FOLDER (FOLDER_ID)
+ ON DELETE CASCADE
+;
+
+----------------------------------------------------------------------
+-- FOLDER_ORDER
+----------------------------------------------------------------------
+
+ALTER TABLE FOLDER_MENU
+ ADD CONSTRAINT FK_FOLDER_MENU_1 FOREIGN KEY (PARENT_ID)
+ REFERENCES FOLDER_MENU (MENU_ID)
+ ON DELETE CASCADE
+;
+ALTER TABLE FOLDER_MENU
+ ADD CONSTRAINT FK_FOLDER_MENU_2 FOREIGN KEY (FOLDER_ID)
+ REFERENCES FOLDER (FOLDER_ID)
+ ON DELETE CASCADE
+;
+
+----------------------------------------------------------------------
+-- FOLDER_MENU
+----------------------------------------------------------------------
+
+ALTER TABLE FOLDER_MENU_METADATA
+ ADD CONSTRAINT FK_FOLDER_MENU_METADATA_1 FOREIGN KEY (MENU_ID)
+ REFERENCES FOLDER_MENU (MENU_ID)
+ ON DELETE CASCADE
+;
+
+----------------------------------------------------------------------
+-- FOLDER_MENU_METADATA
+----------------------------------------------------------------------
+
+ALTER TABLE PAGE
+ ADD CONSTRAINT FK_PAGE_1 FOREIGN KEY (PARENT_ID)
+ REFERENCES FOLDER (FOLDER_ID)
+ ON DELETE CASCADE
+;
+
+----------------------------------------------------------------------
+-- PAGE
+----------------------------------------------------------------------
+
+ALTER TABLE PAGE_METADATA
+ ADD CONSTRAINT FK_PAGE_METADATA_1 FOREIGN KEY (PAGE_ID)
+ REFERENCES PAGE (PAGE_ID)
+ ON DELETE CASCADE
+;
+
+----------------------------------------------------------------------
+-- PAGE_METADATA
+----------------------------------------------------------------------
+
+ALTER TABLE PAGE_CONSTRAINT
+ ADD CONSTRAINT FK_PAGE_CONSTRAINT_1 FOREIGN KEY (PAGE_ID)
+ REFERENCES PAGE (PAGE_ID)
+ ON DELETE CASCADE
+;
+
+----------------------------------------------------------------------
+-- PAGE_CONSTRAINT
+----------------------------------------------------------------------
+
+ALTER TABLE PAGE_CONSTRAINTS_REF
+ ADD CONSTRAINT FK_PAGE_CONSTRAINTS_REF_1 FOREIGN KEY (PAGE_ID)
+ REFERENCES PAGE (PAGE_ID)
+ ON DELETE CASCADE
+;
+
+----------------------------------------------------------------------
+-- PAGE_CONSTRAINTS_REF
+----------------------------------------------------------------------
+
+ALTER TABLE PAGE_MENU
+ ADD CONSTRAINT FK_PAGE_MENU_1 FOREIGN KEY (PARENT_ID)
+ REFERENCES PAGE_MENU (MENU_ID)
+ ON DELETE CASCADE
+;
+ALTER TABLE PAGE_MENU
+ ADD CONSTRAINT PM_M_FK_PAGE_ID_PAGE FOREIGN KEY (PAGE_ID)
+ REFERENCES PAGE (PAGE_ID)
+ ON DELETE CASCADE
+;
+
+----------------------------------------------------------------------
+-- PAGE_MENU
+----------------------------------------------------------------------
+
+ALTER TABLE PAGE_MENU_METADATA
+ ADD CONSTRAINT FK_PAGE_MENU_METADATA_1 FOREIGN KEY (MENU_ID)
+ REFERENCES PAGE_MENU (MENU_ID)
+ ON DELETE CASCADE
+;
+
+----------------------------------------------------------------------
+-- PAGE_MENU_METADATA
+----------------------------------------------------------------------
+
+ALTER TABLE FRAGMENT
+ ADD CONSTRAINT FK_FRAGMENT_1 FOREIGN KEY (PARENT_ID)
+ REFERENCES FRAGMENT (FRAGMENT_ID)
+ ON DELETE CASCADE
+;
+ALTER TABLE FRAGMENT
+ ADD CONSTRAINT FK_FRAGMENT_2 FOREIGN KEY (PAGE_ID)
+ REFERENCES PAGE (PAGE_ID)
+ ON DELETE CASCADE
+;
+
+----------------------------------------------------------------------
+-- FRAGMENT
+----------------------------------------------------------------------
+
+ALTER TABLE FRAGMENT_CONSTRAINT
+ ADD CONSTRAINT FK_FRAGMENT_CONSTRAINT_1 FOREIGN KEY (FRAGMENT_ID)
+ REFERENCES FRAGMENT (FRAGMENT_ID)
+ ON DELETE CASCADE
+;
+
+----------------------------------------------------------------------
+-- FRAGMENT_CONSTRAINT
+----------------------------------------------------------------------
+
+ALTER TABLE FRAGMENT_CONSTRAINTS_REF
+ ADD CONSTRAINT FK_FRAGMENT_CONSTRAINTS_REF_1 FOREIGN KEY (FRAGMENT_ID)
+ REFERENCES FRAGMENT (FRAGMENT_ID)
+ ON DELETE CASCADE
+;
+
+----------------------------------------------------------------------
+-- FRAGMENT_CONSTRAINTS_REF
+----------------------------------------------------------------------
+
+ALTER TABLE FRAGMENT_PREF
+ ADD CONSTRAINT FK_FRAGMENT_PREF_1 FOREIGN KEY (FRAGMENT_ID)
+ REFERENCES FRAGMENT (FRAGMENT_ID)
+ ON DELETE CASCADE
+;
+
+----------------------------------------------------------------------
+-- FRAGMENT_PREF
+----------------------------------------------------------------------
+
+ALTER TABLE FRAGMENT_PREF_VALUE
+ ADD CONSTRAINT FK_FRAGMENT_PREF_VALUE_1 FOREIGN KEY (PREF_ID)
+ REFERENCES FRAGMENT_PREF (PREF_ID)
+ ON DELETE CASCADE
+;
+
+----------------------------------------------------------------------
+-- FRAGMENT_PREF_VALUE
+----------------------------------------------------------------------
+
+ALTER TABLE LINK
+ ADD CONSTRAINT FK_LINK_1 FOREIGN KEY (PARENT_ID)
+ REFERENCES FOLDER (FOLDER_ID)
+ ON DELETE CASCADE
+;
+
+----------------------------------------------------------------------
+-- LINK
+----------------------------------------------------------------------
+
+ALTER TABLE LINK_METADATA
+ ADD CONSTRAINT FK_LINK_METADATA_1 FOREIGN KEY (LINK_ID)
+ REFERENCES LINK (LINK_ID)
+ ON DELETE CASCADE
+;
+
+----------------------------------------------------------------------
+-- LINK_METADATA
+----------------------------------------------------------------------
+
+ALTER TABLE LINK_CONSTRAINT
+ ADD CONSTRAINT FK_LINK_CONSTRAINT_1 FOREIGN KEY (LINK_ID)
+ REFERENCES LINK (LINK_ID)
+ ON DELETE CASCADE
+;
+
+----------------------------------------------------------------------
+-- LINK_CONSTRAINT
+----------------------------------------------------------------------
+
+ALTER TABLE LINK_CONSTRAINTS_REF
+ ADD CONSTRAINT FK_LINK_CONSTRAINTS_REF_1 FOREIGN KEY (LINK_ID)
+ REFERENCES LINK (LINK_ID)
+ ON DELETE CASCADE
+;
+
+----------------------------------------------------------------------
+-- LINK_CONSTRAINTS_REF
+----------------------------------------------------------------------
+
+ALTER TABLE PAGE_SECURITY
+ ADD CONSTRAINT FK_PAGE_SECURITY_1 FOREIGN KEY (PARENT_ID)
+ REFERENCES FOLDER (FOLDER_ID)
+ ON DELETE CASCADE
+;
+
+----------------------------------------------------------------------
+-- PAGE_SECURITY
+----------------------------------------------------------------------
+
+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
+;
+
+----------------------------------------------------------------------
+-- PAGE_SEC_CONSTRAINTS_DEF
+----------------------------------------------------------------------
+
+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
+;
+
+----------------------------------------------------------------------
+-- PAGE_SEC_CONSTRAINT_DEF
+----------------------------------------------------------------------
+
+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
+;
+
+----------------------------------------------------------------------
+-- PAGE_SEC_CONSTRAINTS_REF
+----------------------------------------------------------------------
+
+
+----------------------------------------------------------------------
+-- PROFILING_RULE
+----------------------------------------------------------------------
+
+ALTER TABLE RULE_CRITERION
+ ADD CONSTRAINT FK_RULE_CRITERION_1 FOREIGN KEY (RULE_ID)
+ REFERENCES PROFILING_RULE (RULE_ID)
+ ON DELETE CASCADE
+;
+
+----------------------------------------------------------------------
+-- RULE_CRITERION
+----------------------------------------------------------------------
+
+
+----------------------------------------------------------------------
+-- PRINCIPAL_RULE_ASSOC
+----------------------------------------------------------------------
+
+
+----------------------------------------------------------------------
+-- PROFILE_PAGE_ASSOC
+----------------------------------------------------------------------
+
Propchange: geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/postgres/phase2-schema.sql
------------------------------------------------------------------------------
svn:eol-style = native
Propchange: geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/postgres/phase2-schema.sql
------------------------------------------------------------------------------
svn:keywords = Date Revision
Propchange: geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/postgres/phase2-schema.sql
------------------------------------------------------------------------------
svn:mime-type = text/plain
Added: geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/postgres/phase3ojb-schema.sql
URL: http://svn.apache.org/viewvc/geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/postgres/phase3ojb-schema.sql?rev=588248&view=auto
==============================================================================
--- geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/postgres/phase3ojb-schema.sql (added)
+++ geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/postgres/phase3ojb-schema.sql Thu Oct 25 08:16:02 2007
@@ -0,0 +1,178 @@
+
+-----------------------------------------------------------------------------
+-- OJB_HL_SEQ
+-----------------------------------------------------------------------------
+
+
+
+CREATE TABLE OJB_HL_SEQ
+(
+ TABLENAME VARCHAR(175) NOT NULL,
+ FIELDNAME VARCHAR(70) NOT NULL,
+ MAX_KEY INTEGER,
+ GRAB_SIZE INTEGER,
+ VERSION INTEGER,
+ PRIMARY KEY (TABLENAME,FIELDNAME)
+);
+
+
+
+
+-----------------------------------------------------------------------------
+-- OJB_LOCKENTRY
+-----------------------------------------------------------------------------
+
+
+
+CREATE TABLE OJB_LOCKENTRY
+(
+ OID_ VARCHAR(250) NOT NULL,
+ TX_ID VARCHAR(50) NOT NULL,
+ TIMESTAMP_ TIMESTAMP,
+ ISOLATIONLEVEL INTEGER,
+ LOCKTYPE INTEGER,
+ PRIMARY KEY (OID_,TX_ID)
+);
+
+
+
+
+-----------------------------------------------------------------------------
+-- OJB_NRM
+-----------------------------------------------------------------------------
+
+
+
+CREATE TABLE OJB_NRM
+(
+ NAME VARCHAR(250) NOT NULL,
+ OID_ BYTEA,
+ PRIMARY KEY (NAME)
+);
+
+
+
+
+-----------------------------------------------------------------------------
+-- OJB_DLIST
+-----------------------------------------------------------------------------
+
+
+
+CREATE TABLE OJB_DLIST
+(
+ ID INTEGER NOT NULL,
+ SIZE_ INTEGER,
+ PRIMARY KEY (ID)
+);
+
+
+
+
+-----------------------------------------------------------------------------
+-- OJB_DLIST_ENTRIES
+-----------------------------------------------------------------------------
+
+
+
+CREATE TABLE OJB_DLIST_ENTRIES
+(
+ ID INTEGER NOT NULL,
+ DLIST_ID INTEGER,
+ POSITION_ INTEGER,
+ OID_ BYTEA,
+ PRIMARY KEY (ID)
+);
+
+
+
+
+-----------------------------------------------------------------------------
+-- OJB_DSET
+-----------------------------------------------------------------------------
+
+
+
+CREATE TABLE OJB_DSET
+(
+ ID INTEGER NOT NULL,
+ SIZE_ INTEGER,
+ PRIMARY KEY (ID)
+);
+
+
+
+
+-----------------------------------------------------------------------------
+-- OJB_DSET_ENTRIES
+-----------------------------------------------------------------------------
+
+
+
+CREATE TABLE OJB_DSET_ENTRIES
+(
+ ID INTEGER NOT NULL,
+ DLIST_ID INTEGER,
+ POSITION_ INTEGER,
+ OID_ BYTEA,
+ PRIMARY KEY (ID)
+);
+
+
+
+
+-----------------------------------------------------------------------------
+-- OJB_DMAP
+-----------------------------------------------------------------------------
+
+
+
+CREATE TABLE OJB_DMAP
+(
+ ID INTEGER NOT NULL,
+ SIZE_ INTEGER,
+ PRIMARY KEY (ID)
+);
+
+
+
+
+----------------------------------------------------------------------
+-- OJB_DMAP
+----------------------------------------------------------------------
+
+
+----------------------------------------------------------------------
+-- OJB_HL_SEQ
+----------------------------------------------------------------------
+
+
+----------------------------------------------------------------------
+-- OJB_LOCKENTRY
+----------------------------------------------------------------------
+
+
+----------------------------------------------------------------------
+-- OJB_NRM
+----------------------------------------------------------------------
+
+
+----------------------------------------------------------------------
+-- OJB_DLIST
+----------------------------------------------------------------------
+
+
+----------------------------------------------------------------------
+-- OJB_DLIST_ENTRIES
+----------------------------------------------------------------------
+
+
+----------------------------------------------------------------------
+-- OJB_DSET
+----------------------------------------------------------------------
+
+
+----------------------------------------------------------------------
+-- OJB_DSET_ENTRIES
+----------------------------------------------------------------------
+
Propchange: geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/postgres/phase3ojb-schema.sql
------------------------------------------------------------------------------
svn:eol-style = native
Propchange: geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/postgres/phase3ojb-schema.sql
------------------------------------------------------------------------------
svn:keywords = Date Revision
Propchange: geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/postgres/phase3ojb-schema.sql
------------------------------------------------------------------------------
svn:mime-type = text/plain
Added: geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/postgres/prefs-schema.sql
URL: http://svn.apache.org/viewvc/geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/postgres/prefs-schema.sql?rev=588248&view=auto
==============================================================================
--- geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/postgres/prefs-schema.sql (added)
+++ geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/postgres/prefs-schema.sql Thu Oct 25 08:16:02 2007
@@ -0,0 +1,55 @@
+
+-----------------------------------------------------------------------------
+-- PREFS_PROPERTY_VALUE
+-----------------------------------------------------------------------------
+
+
+
+CREATE TABLE PREFS_PROPERTY_VALUE
+(
+ PROPERTY_VALUE_ID INTEGER NOT NULL,
+ NODE_ID INTEGER,
+ PROPERTY_NAME VARCHAR(100),
+ PROPERTY_VALUE VARCHAR(254),
+ CREATION_DATE TIMESTAMP,
+ MODIFIED_DATE TIMESTAMP,
+ PRIMARY KEY (PROPERTY_VALUE_ID)
+);
+
+
+
+
+-----------------------------------------------------------------------------
+-- PREFS_NODE
+-----------------------------------------------------------------------------
+
+
+
+CREATE TABLE PREFS_NODE
+(
+ NODE_ID INTEGER NOT NULL,
+ PARENT_NODE_ID INTEGER,
+ NODE_NAME VARCHAR(100),
+ NODE_TYPE INT2,
+ FULL_PATH VARCHAR(254),
+ CREATION_DATE TIMESTAMP,
+ MODIFIED_DATE TIMESTAMP,
+ PRIMARY KEY (NODE_ID)
+);
+
+
+
+
+----------------------------------------------------------------------
+-- PREFS_NODE
+----------------------------------------------------------------------
+
+
+----------------------------------------------------------------------
+-- PREFS_PROPERTY_VALUE
+----------------------------------------------------------------------
+
+ALTER TABLE PREFS_NODE
+ ADD CONSTRAINT FK_PREFS_NODE_1 FOREIGN KEY (PARENT_NODE_ID)
+ REFERENCES PREFS_NODE (NODE_ID)
+;
Propchange: geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/postgres/prefs-schema.sql
------------------------------------------------------------------------------
svn:eol-style = native
Propchange: geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/postgres/prefs-schema.sql
------------------------------------------------------------------------------
svn:keywords = Date Revision
Propchange: geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/postgres/prefs-schema.sql
------------------------------------------------------------------------------
svn:mime-type = text/plain
Added: geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/postgres/registry-schema.sql
URL: http://svn.apache.org/viewvc/geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/postgres/registry-schema.sql?rev=588248&view=auto
==============================================================================
--- geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/postgres/registry-schema.sql (added)
+++ geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/postgres/registry-schema.sql Thu Oct 25 08:16:02 2007
@@ -0,0 +1,462 @@
+
+-----------------------------------------------------------------------------
+-- PORTLET_DEFINITION
+-----------------------------------------------------------------------------
+
+
+
+CREATE TABLE PORTLET_DEFINITION
+(
+ ID INTEGER NOT NULL,
+ NAME VARCHAR(80),
+ CLASS_NAME VARCHAR(255),
+ APPLICATION_ID INTEGER NOT NULL,
+ PORTLET_IDENTIFIER VARCHAR(80),
+ EXPIRATION_CACHE VARCHAR(30),
+ RESOURCE_BUNDLE VARCHAR(255),
+ PREFERENCE_VALIDATOR VARCHAR(255),
+ SECURITY_REF VARCHAR(40),
+ PRIMARY KEY (ID)
+);
+
+
+
+
+-----------------------------------------------------------------------------
+-- PORTLET_APPLICATION
+-----------------------------------------------------------------------------
+
+
+
+CREATE TABLE PORTLET_APPLICATION
+(
+ APPLICATION_ID INTEGER NOT NULL,
+ APP_NAME VARCHAR(80) NOT NULL,
+ APP_IDENTIFIER VARCHAR(80),
+ VERSION VARCHAR(80),
+ APP_TYPE INTEGER,
+ CHECKSUM VARCHAR(80),
+ DESCRIPTION VARCHAR(80),
+ WEB_APP_ID INTEGER NOT NULL,
+ SECURITY_REF VARCHAR(40),
+ PRIMARY KEY (APPLICATION_ID),
+ CONSTRAINT UK_APPLICATION UNIQUE (APP_NAME)
+);
+
+
+
+
+-----------------------------------------------------------------------------
+-- WEB_APPLICATION
+-----------------------------------------------------------------------------
+
+
+
+CREATE TABLE WEB_APPLICATION
+(
+ ID INTEGER NOT NULL,
+ CONTEXT_ROOT VARCHAR(255) NOT NULL,
+ PRIMARY KEY (ID)
+);
+
+
+
+
+-----------------------------------------------------------------------------
+-- PA_METADATA_FIELDS
+-----------------------------------------------------------------------------
+
+
+
+CREATE TABLE PA_METADATA_FIELDS
+(
+ ID INTEGER NOT NULL,
+ OBJECT_ID INTEGER NOT NULL,
+ COLUMN_VALUE TEXT NOT NULL,
+ NAME VARCHAR(100) NOT NULL,
+ LOCALE_STRING VARCHAR(50) NOT NULL,
+ PRIMARY KEY (ID)
+);
+
+
+
+
+-----------------------------------------------------------------------------
+-- PD_METADATA_FIELDS
+-----------------------------------------------------------------------------
+
+
+
+CREATE TABLE PD_METADATA_FIELDS
+(
+ ID INTEGER NOT NULL,
+ OBJECT_ID INTEGER NOT NULL,
+ COLUMN_VALUE TEXT NOT NULL,
+ NAME VARCHAR(100) NOT NULL,
+ LOCALE_STRING VARCHAR(50) NOT NULL,
+ PRIMARY KEY (ID)
+);
+
+
+
+
+-----------------------------------------------------------------------------
+-- LANGUAGE
+-----------------------------------------------------------------------------
+
+
+
+CREATE TABLE LANGUAGE
+(
+ ID INTEGER NOT NULL,
+ PORTLET_ID INTEGER NOT NULL,
+ TITLE VARCHAR(100),
+ SHORT_TITLE VARCHAR(100),
+ LOCALE_STRING VARCHAR(50) NOT NULL,
+ KEYWORDS TEXT,
+ PRIMARY KEY (ID)
+);
+
+
+
+
+-----------------------------------------------------------------------------
+-- PORTLET_CONTENT_TYPE
+-----------------------------------------------------------------------------
+
+
+
+CREATE TABLE PORTLET_CONTENT_TYPE
+(
+ CONTENT_TYPE_ID INTEGER NOT NULL,
+ PORTLET_ID INTEGER NOT NULL,
+ CONTENT_TYPE VARCHAR(30) NOT NULL,
+ MODES TEXT,
+ PRIMARY KEY (CONTENT_TYPE_ID)
+);
+
+
+
+
+-----------------------------------------------------------------------------
+-- PARAMETER
+-----------------------------------------------------------------------------
+
+
+
+CREATE TABLE PARAMETER
+(
+ PARAMETER_ID INTEGER NOT NULL,
+ PARENT_ID INTEGER NOT NULL,
+ CLASS_NAME VARCHAR(255) NOT NULL,
+ NAME VARCHAR(80) NOT NULL,
+ PARAMETER_VALUE TEXT NOT NULL,
+ PRIMARY KEY (PARAMETER_ID)
+);
+
+
+
+
+-----------------------------------------------------------------------------
+-- PORTLET_ENTITY
+-----------------------------------------------------------------------------
+
+
+
+CREATE TABLE PORTLET_ENTITY
+(
+ PEID INTEGER NOT NULL,
+ ID VARCHAR(255) NOT NULL,
+ APP_NAME VARCHAR(255) NOT NULL,
+ PORTLET_NAME VARCHAR(255) NOT NULL,
+ PRIMARY KEY (PEID),
+ CONSTRAINT UK_ENTITY_ID UNIQUE (ID)
+);
+
+
+
+
+-----------------------------------------------------------------------------
+-- SECURITY_ROLE_REFERENCE
+-----------------------------------------------------------------------------
+
+
+
+CREATE TABLE SECURITY_ROLE_REFERENCE
+(
+ ID INTEGER NOT NULL,
+ PORTLET_DEFINITION_ID INTEGER NOT NULL,
+ ROLE_NAME VARCHAR(150) NOT NULL,
+ ROLE_LINK VARCHAR(150),
+ PRIMARY KEY (ID)
+);
+
+
+
+
+-----------------------------------------------------------------------------
+-- SECURITY_ROLE
+-----------------------------------------------------------------------------
+
+
+
+CREATE TABLE SECURITY_ROLE
+(
+ ID INTEGER NOT NULL,
+ WEB_APPLICATION_ID INTEGER NOT NULL,
+ ROLE_NAME VARCHAR(150) NOT NULL,
+ DESCRIPTION VARCHAR(150),
+ PRIMARY KEY (ID)
+);
+
+
+
+
+-----------------------------------------------------------------------------
+-- USER_ATTRIBUTE_REF
+-----------------------------------------------------------------------------
+
+
+
+CREATE TABLE USER_ATTRIBUTE_REF
+(
+ ID INTEGER NOT NULL,
+ APPLICATION_ID INTEGER NOT NULL,
+ NAME VARCHAR(150),
+ NAME_LINK VARCHAR(150),
+ PRIMARY KEY (ID)
+);
+
+
+
+
+-----------------------------------------------------------------------------
+-- USER_ATTRIBUTE
+-----------------------------------------------------------------------------
+
+
+
+CREATE TABLE USER_ATTRIBUTE
+(
+ ID INTEGER NOT NULL,
+ APPLICATION_ID INTEGER NOT NULL,
+ NAME VARCHAR(150),
+ DESCRIPTION VARCHAR(150),
+ PRIMARY KEY (ID)
+);
+
+
+
+
+-----------------------------------------------------------------------------
+-- JETSPEED_SERVICE
+-----------------------------------------------------------------------------
+
+
+
+CREATE TABLE JETSPEED_SERVICE
+(
+ ID INTEGER NOT NULL,
+ APPLICATION_ID INTEGER NOT NULL,
+ NAME VARCHAR(150),
+ PRIMARY KEY (ID)
+);
+
+
+
+
+-----------------------------------------------------------------------------
+-- LOCALIZED_DESCRIPTION
+-----------------------------------------------------------------------------
+
+
+
+CREATE TABLE LOCALIZED_DESCRIPTION
+(
+ ID INTEGER NOT NULL,
+ OBJECT_ID INTEGER NOT NULL,
+ CLASS_NAME VARCHAR(255) NOT NULL,
+ DESCRIPTION TEXT NOT NULL,
+ LOCALE_STRING VARCHAR(50) NOT NULL,
+ PRIMARY KEY (ID)
+);
+
+
+
+
+-----------------------------------------------------------------------------
+-- LOCALIZED_DISPLAY_NAME
+-----------------------------------------------------------------------------
+
+
+
+CREATE TABLE LOCALIZED_DISPLAY_NAME
+(
+ ID INTEGER NOT NULL,
+ OBJECT_ID INTEGER NOT NULL,
+ CLASS_NAME VARCHAR(255),
+ DISPLAY_NAME TEXT NOT NULL,
+ LOCALE_STRING VARCHAR(50) NOT NULL,
+ PRIMARY KEY (ID)
+);
+
+
+
+
+-----------------------------------------------------------------------------
+-- CUSTOM_PORTLET_MODE
+-----------------------------------------------------------------------------
+
+
+
+CREATE TABLE CUSTOM_PORTLET_MODE
+(
+ ID INTEGER NOT NULL,
+ APPLICATION_ID INTEGER NOT NULL,
+ CUSTOM_NAME VARCHAR(150) NOT NULL,
+ MAPPED_NAME VARCHAR(150),
+ DESCRIPTION TEXT,
+ PRIMARY KEY (ID)
+);
+
+
+
+
+-----------------------------------------------------------------------------
+-- CUSTOM_WINDOW_STATE
+-----------------------------------------------------------------------------
+
+
+
+CREATE TABLE CUSTOM_WINDOW_STATE
+(
+ ID INTEGER NOT NULL,
+ APPLICATION_ID INTEGER NOT NULL,
+ CUSTOM_NAME VARCHAR(150) NOT NULL,
+ MAPPED_NAME VARCHAR(150),
+ DESCRIPTION TEXT,
+ PRIMARY KEY (ID)
+);
+
+
+
+
+----------------------------------------------------------------------
+-- CUSTOM_WINDOW_STATE
+----------------------------------------------------------------------
+
+
+----------------------------------------------------------------------
+-- PORTLET_DEFINITION
+----------------------------------------------------------------------
+
+
+----------------------------------------------------------------------
+-- PORTLET_APPLICATION
+----------------------------------------------------------------------
+
+
+----------------------------------------------------------------------
+-- WEB_APPLICATION
+----------------------------------------------------------------------
+
+ALTER TABLE PA_METADATA_FIELDS
+ ADD CONSTRAINT FK_PA_METADATA_FIELDS_1 FOREIGN KEY (OBJECT_ID)
+ REFERENCES PORTLET_APPLICATION (APPLICATION_ID)
+ ON DELETE CASCADE
+;
+
+----------------------------------------------------------------------
+-- PA_METADATA_FIELDS
+----------------------------------------------------------------------
+
+ALTER TABLE PD_METADATA_FIELDS
+ ADD CONSTRAINT FK_PD_METADATA_FIELDS_1 FOREIGN KEY (OBJECT_ID)
+ REFERENCES PORTLET_DEFINITION (ID)
+ ON DELETE CASCADE
+;
+
+----------------------------------------------------------------------
+-- PD_METADATA_FIELDS
+----------------------------------------------------------------------
+
+
+----------------------------------------------------------------------
+-- LANGUAGE
+----------------------------------------------------------------------
+
+
+----------------------------------------------------------------------
+-- PORTLET_CONTENT_TYPE
+----------------------------------------------------------------------
+
+
+----------------------------------------------------------------------
+-- PARAMETER
+----------------------------------------------------------------------
+
+
+----------------------------------------------------------------------
+-- PORTLET_ENTITY
+----------------------------------------------------------------------
+
+
+----------------------------------------------------------------------
+-- SECURITY_ROLE_REFERENCE
+----------------------------------------------------------------------
+
+
+----------------------------------------------------------------------
+-- SECURITY_ROLE
+----------------------------------------------------------------------
+
+ALTER TABLE USER_ATTRIBUTE_REF
+ ADD CONSTRAINT FK_USER_ATTRIBUTE_REF_1 FOREIGN KEY (APPLICATION_ID)
+ REFERENCES PORTLET_APPLICATION (APPLICATION_ID)
+ ON DELETE CASCADE
+;
+
+----------------------------------------------------------------------
+-- USER_ATTRIBUTE_REF
+----------------------------------------------------------------------
+
+ALTER TABLE USER_ATTRIBUTE
+ ADD CONSTRAINT FK_USER_ATTRIBUTE_1 FOREIGN KEY (APPLICATION_ID)
+ REFERENCES PORTLET_APPLICATION (APPLICATION_ID)
+ ON DELETE CASCADE
+;
+
+----------------------------------------------------------------------
+-- USER_ATTRIBUTE
+----------------------------------------------------------------------
+
+
+----------------------------------------------------------------------
+-- JETSPEED_SERVICE
+----------------------------------------------------------------------
+
+
+----------------------------------------------------------------------
+-- LOCALIZED_DESCRIPTION
+----------------------------------------------------------------------
+
+
+----------------------------------------------------------------------
+-- LOCALIZED_DISPLAY_NAME
+----------------------------------------------------------------------
+
+ALTER TABLE CUSTOM_PORTLET_MODE
+ ADD CONSTRAINT FK_CUSTOM_PORTLET_MODE_1 FOREIGN KEY (APPLICATION_ID)
+ REFERENCES PORTLET_APPLICATION (APPLICATION_ID)
+ ON DELETE CASCADE
+;
+
+----------------------------------------------------------------------
+-- CUSTOM_PORTLET_MODE
+----------------------------------------------------------------------
+
+ALTER TABLE CUSTOM_WINDOW_STATE
+ ADD CONSTRAINT FK_CUSTOM_WINDOW_STATE_1 FOREIGN KEY (APPLICATION_ID)
+ REFERENCES PORTLET_APPLICATION (APPLICATION_ID)
+ ON DELETE CASCADE
+;
Propchange: geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/postgres/registry-schema.sql
------------------------------------------------------------------------------
svn:eol-style = native
Propchange: geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/postgres/registry-schema.sql
------------------------------------------------------------------------------
svn:keywords = Date Revision
Propchange: geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/postgres/registry-schema.sql
------------------------------------------------------------------------------
svn:mime-type = text/plain