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 ta...@apache.org on 2005/11/11 03:33:11 UTC
svn commit: r332424 - in /portals/jetspeed-2/trunk/etc/sql/derby/schema: ./
phase1-schema.sql phase2-schema.sql phase3ojb-schema.sql prefs-schema.sql
registry-schema.sql security-schema.sql
Author: taylor
Date: Thu Nov 10 18:33:10 2005
New Revision: 332424
URL: http://svn.apache.org/viewcvs?rev=332424&view=rev
Log:
schema for derby
almost had derby integration going
now have 2 problems
1. db browser cant connect
2. statistics fail to write, not seeing any logging though
Added:
portals/jetspeed-2/trunk/etc/sql/derby/schema/
portals/jetspeed-2/trunk/etc/sql/derby/schema/phase1-schema.sql
portals/jetspeed-2/trunk/etc/sql/derby/schema/phase2-schema.sql
portals/jetspeed-2/trunk/etc/sql/derby/schema/phase3ojb-schema.sql
portals/jetspeed-2/trunk/etc/sql/derby/schema/prefs-schema.sql
portals/jetspeed-2/trunk/etc/sql/derby/schema/registry-schema.sql
portals/jetspeed-2/trunk/etc/sql/derby/schema/security-schema.sql
Added: portals/jetspeed-2/trunk/etc/sql/derby/schema/phase1-schema.sql
URL: http://svn.apache.org/viewcvs/portals/jetspeed-2/trunk/etc/sql/derby/schema/phase1-schema.sql?rev=332424&view=auto
==============================================================================
--- portals/jetspeed-2/trunk/etc/sql/derby/schema/phase1-schema.sql (added)
+++ portals/jetspeed-2/trunk/etc/sql/derby/schema/phase1-schema.sql Thu Nov 10 18:33:10 2005
@@ -0,0 +1,124 @@
+-----------------------------------------------------------------------------
+-- MEDIA_TYPE
+-----------------------------------------------------------------------------
+
+CREATE TABLE MEDIA_TYPE
+(
+ MEDIATYPE_ID INTEGER NOT NULL,
+ NAME VARCHAR(80) NOT NULL,
+ CHARACTER_SET VARCHAR(40),
+ TITLE VARCHAR(80),
+ DESCRIPTION LONG VARCHAR,
+ 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(80),
+ STATUS INTEGER,
+ ELAPSED_TIME INTEGER);
+
+-----------------------------------------------------------------------------
+-- PAGE_STATISTICS
+-----------------------------------------------------------------------------
+
+CREATE TABLE PAGE_STATISTICS
+(
+ IPADDRESS VARCHAR(80),
+ USER_NAME VARCHAR(80),
+ TIME_STAMP TIMESTAMP,
+ PAGE VARCHAR(80),
+ STATUS INTEGER,
+ ELAPSED_TIME INTEGER);
+
+-----------------------------------------------------------------------------
+-- USER_STATISTICS
+-----------------------------------------------------------------------------
+
+CREATE TABLE USER_STATISTICS
+(
+ IPADDRESS VARCHAR(80),
+ USER_NAME VARCHAR(80),
+ TIME_STAMP TIMESTAMP,
+ STATUS INTEGER,
+ ELAPSED_TIME INTEGER);
+
Added: portals/jetspeed-2/trunk/etc/sql/derby/schema/phase2-schema.sql
URL: http://svn.apache.org/viewcvs/portals/jetspeed-2/trunk/etc/sql/derby/schema/phase2-schema.sql?rev=332424&view=auto
==============================================================================
--- portals/jetspeed-2/trunk/etc/sql/derby/schema/phase2-schema.sql (added)
+++ portals/jetspeed-2/trunk/etc/sql/derby/schema/phase2-schema.sql Thu Nov 10 18:33:10 2005
@@ -0,0 +1,365 @@
+-----------------------------------------------------------------------------
+-- 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 INTEGER NOT NULL,
+ 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),
+ FOREIGN KEY (PARENT_ID) REFERENCES FOLDER (FOLDER_ID)
+ ON DELETE CASCADE
+ ,
+ 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),
+ FOREIGN KEY (FOLDER_ID) REFERENCES FOLDER (FOLDER_ID)
+ ON DELETE CASCADE
+ ,
+ 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),
+ FOREIGN KEY (FOLDER_ID) REFERENCES FOLDER (FOLDER_ID)
+ ON DELETE CASCADE
+);
+
+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),
+ FOREIGN KEY (FOLDER_ID) REFERENCES FOLDER (FOLDER_ID)
+ ON DELETE CASCADE
+);
+
+CREATE INDEX IX_FOLDER_CONSTRAINTS_REF_1 ON FOLDER_CONSTRAINTS_REF (FOLDER_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,
+ TITLE VARCHAR(100),
+ SHORT_TITLE VARCHAR(40),
+ IS_HIDDEN INTEGER 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),
+ FOREIGN KEY (PARENT_ID) REFERENCES FOLDER (FOLDER_ID)
+ ON DELETE CASCADE
+ ,
+ 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),
+ FOREIGN KEY (PAGE_ID) REFERENCES PAGE (PAGE_ID)
+ ON DELETE CASCADE
+ ,
+ 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),
+ FOREIGN KEY (PAGE_ID) REFERENCES PAGE (PAGE_ID)
+ ON DELETE CASCADE
+);
+
+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),
+ FOREIGN KEY (PAGE_ID) REFERENCES PAGE (PAGE_ID)
+ ON DELETE CASCADE
+);
+
+CREATE INDEX IX_PAGE_CONSTRAINTS_REF_1 ON PAGE_CONSTRAINTS_REF (PAGE_ID);
+-----------------------------------------------------------------------------
+-- FRAGMENT
+-----------------------------------------------------------------------------
+
+CREATE TABLE FRAGMENT
+(
+ FRAGMENT_ID INTEGER NOT NULL,
+ PARENT_ID INTEGER,
+ PAGE_ID INTEGER NOT NULL,
+ NAME VARCHAR(100),
+ TITLE VARCHAR(100),
+ SHORT_TITLE VARCHAR(40),
+ TYPE VARCHAR(40),
+ SKIN VARCHAR(80),
+ DECORATOR VARCHAR(80),
+ STATE VARCHAR(40),
+ LAYOUT_ROW INTEGER,
+ LAYOUT_COLUMN INTEGER,
+ LAYOUT_SIZES VARCHAR(20),
+ 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),
+ FOREIGN KEY (PARENT_ID) REFERENCES FRAGMENT (FRAGMENT_ID)
+ ON DELETE CASCADE
+ ,
+ FOREIGN KEY (PAGE_ID) REFERENCES PAGE (PAGE_ID)
+ ON DELETE CASCADE
+ ,
+ UNIQUE (PAGE_ID));
+
+CREATE INDEX IX_FRAGMENT_1 ON FRAGMENT (PARENT_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),
+ FOREIGN KEY (FRAGMENT_ID) REFERENCES FRAGMENT (FRAGMENT_ID)
+ ON DELETE CASCADE
+);
+
+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),
+ FOREIGN KEY (FRAGMENT_ID) REFERENCES FRAGMENT (FRAGMENT_ID)
+ ON DELETE CASCADE
+);
+
+CREATE INDEX IX_FRAGMENT_CONSTRAINTS_REF_1 ON FRAGMENT_CONSTRAINTS_REF (FRAGMENT_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,
+ 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),
+ FOREIGN KEY (PARENT_ID) REFERENCES FOLDER (FOLDER_ID)
+ ON DELETE CASCADE
+ ,
+ UNIQUE (PARENT_ID),
+ UNIQUE (PATH));
+
+-----------------------------------------------------------------------------
+-- PAGE_SECURITY_CONSTRAINTS_DEF
+-----------------------------------------------------------------------------
+
+CREATE TABLE PAGE_SECURITY_CONSTRAINTS_DEF
+(
+ CONSTRAINTS_DEF_ID INTEGER NOT NULL,
+ PAGE_SECURITY_ID INTEGER NOT NULL,
+ NAME VARCHAR(40) 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(CONSTRAINTS_DEF_ID),
+ FOREIGN KEY (PAGE_SECURITY_ID) REFERENCES PAGE_SECURITY (PAGE_SECURITY_ID)
+ ON DELETE CASCADE
+);
+
+CREATE INDEX IX_PAGE_SEC_CONSTRAINTS_DEF_1 ON PAGE_SECURITY_CONSTRAINTS_DEF (PAGE_SECURITY_ID);
+-----------------------------------------------------------------------------
+-- PAGE_SECURITY_CONSTRAINTS_REF
+-----------------------------------------------------------------------------
+
+CREATE TABLE PAGE_SECURITY_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),
+ FOREIGN KEY (PAGE_SECURITY_ID) REFERENCES PAGE_SECURITY (PAGE_SECURITY_ID)
+ ON DELETE CASCADE
+);
+
+CREATE INDEX IX_PAGE_SEC_CONSTRAINTS_REF_1 ON PAGE_SECURITY_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),
+ FOREIGN KEY (RULE_ID) REFERENCES PROFILING_RULE (RULE_ID)
+ ON DELETE CASCADE
+);
+
+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,
+ 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));
+
Added: portals/jetspeed-2/trunk/etc/sql/derby/schema/phase3ojb-schema.sql
URL: http://svn.apache.org/viewcvs/portals/jetspeed-2/trunk/etc/sql/derby/schema/phase3ojb-schema.sql?rev=332424&view=auto
==============================================================================
--- portals/jetspeed-2/trunk/etc/sql/derby/schema/phase3ojb-schema.sql (added)
+++ portals/jetspeed-2/trunk/etc/sql/derby/schema/phase3ojb-schema.sql Thu Nov 10 18:33:10 2005
@@ -0,0 +1,90 @@
+-----------------------------------------------------------------------------
+-- 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_ BLOB,
+ 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_ BLOB,
+ 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_ BLOB,
+ PRIMARY KEY(ID));
+
+-----------------------------------------------------------------------------
+-- OJB_DMAP
+-----------------------------------------------------------------------------
+
+CREATE TABLE OJB_DMAP
+(
+ ID INTEGER NOT NULL,
+ SIZE_ INTEGER,
+ PRIMARY KEY(ID));
+
Added: portals/jetspeed-2/trunk/etc/sql/derby/schema/prefs-schema.sql
URL: http://svn.apache.org/viewcvs/portals/jetspeed-2/trunk/etc/sql/derby/schema/prefs-schema.sql?rev=332424&view=auto
==============================================================================
--- portals/jetspeed-2/trunk/etc/sql/derby/schema/prefs-schema.sql (added)
+++ portals/jetspeed-2/trunk/etc/sql/derby/schema/prefs-schema.sql Thu Nov 10 18:33:10 2005
@@ -0,0 +1,58 @@
+-----------------------------------------------------------------------------
+-- PREFS_PROPERTY_VALUE
+-----------------------------------------------------------------------------
+
+CREATE TABLE PREFS_PROPERTY_VALUE
+(
+ PROPERTY_VALUE_ID INTEGER NOT NULL,
+ NODE_ID INTEGER,
+ PROPERTY_KEY_ID INTEGER,
+ BOOLEAN_VALUE INTEGER,
+ DATETIME_VALUE TIMESTAMP,
+ LONG_VALUE INTEGER,
+ DOUBLE_VALUE DOUBLE,
+ TEXT_VALUE VARCHAR(254),
+ CREATION_DATE TIMESTAMP,
+ MODIFIED_DATE TIMESTAMP,
+ PRIMARY KEY(PROPERTY_VALUE_ID));
+
+-----------------------------------------------------------------------------
+-- PREFS_NODE_PROPERTY_KEY
+-----------------------------------------------------------------------------
+
+CREATE TABLE PREFS_NODE_PROPERTY_KEY
+(
+ NODE_ID INTEGER NOT NULL,
+ PROPERTY_KEY_ID INTEGER NOT NULL,
+ PRIMARY KEY(NODE_ID,PROPERTY_KEY_ID));
+
+-----------------------------------------------------------------------------
+-- PREFS_PROPERTY_KEY
+-----------------------------------------------------------------------------
+
+CREATE TABLE PREFS_PROPERTY_KEY
+(
+ PROPERTY_KEY_ID INTEGER NOT NULL,
+ PROPERTY_NAME VARCHAR(100),
+ PROPERTY_TYPE SMALLINT,
+ CREATION_DATE TIMESTAMP,
+ MODIFIED_DATE TIMESTAMP,
+ PRIMARY KEY(PROPERTY_KEY_ID));
+
+-----------------------------------------------------------------------------
+-- PREFS_NODE
+-----------------------------------------------------------------------------
+
+CREATE TABLE PREFS_NODE
+(
+ NODE_ID INTEGER NOT NULL,
+ PARENT_NODE_ID INTEGER,
+ NODE_NAME VARCHAR(100),
+ NODE_TYPE SMALLINT,
+ FULL_PATH VARCHAR(254),
+ CREATION_DATE TIMESTAMP,
+ MODIFIED_DATE TIMESTAMP,
+ PRIMARY KEY(NODE_ID),
+ FOREIGN KEY (PARENT_NODE_ID) REFERENCES PREFS_NODE (NODE_ID)
+ );
+
Added: portals/jetspeed-2/trunk/etc/sql/derby/schema/registry-schema.sql
URL: http://svn.apache.org/viewcvs/portals/jetspeed-2/trunk/etc/sql/derby/schema/registry-schema.sql?rev=332424&view=auto
==============================================================================
--- portals/jetspeed-2/trunk/etc/sql/derby/schema/registry-schema.sql (added)
+++ portals/jetspeed-2/trunk/etc/sql/derby/schema/registry-schema.sql Thu Nov 10 18:33:10 2005
@@ -0,0 +1,218 @@
+-----------------------------------------------------------------------------
+-- 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),
+ 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,
+ PRIMARY KEY(APPLICATION_ID),
+ 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 LONG VARCHAR NOT NULL,
+ NAME VARCHAR(100) NOT NULL,
+ LOCALE_STRING VARCHAR(50) NOT NULL,
+ PRIMARY KEY(ID),
+ FOREIGN KEY (OBJECT_ID) REFERENCES PORTLET_APPLICATION (APPLICATION_ID)
+ ON DELETE CASCADE
+ );
+
+-----------------------------------------------------------------------------
+-- PD_METADATA_FIELDS
+-----------------------------------------------------------------------------
+
+CREATE TABLE PD_METADATA_FIELDS
+(
+ ID INTEGER NOT NULL,
+ OBJECT_ID INTEGER NOT NULL,
+ COLUMN_VALUE LONG VARCHAR NOT NULL,
+ NAME VARCHAR(100) NOT NULL,
+ LOCALE_STRING VARCHAR(50) NOT NULL,
+ PRIMARY KEY(ID),
+ FOREIGN KEY (OBJECT_ID) REFERENCES PORTLET_DEFINITION (ID)
+ ON DELETE CASCADE
+ );
+
+-----------------------------------------------------------------------------
+-- 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 LONG VARCHAR,
+ 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 LONG VARCHAR,
+ 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 LONG VARCHAR 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),
+ 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),
+ FOREIGN KEY (APPLICATION_ID) REFERENCES PORTLET_APPLICATION (APPLICATION_ID)
+ ON DELETE CASCADE
+ );
+
+-----------------------------------------------------------------------------
+-- USER_ATTRIBUTE
+-----------------------------------------------------------------------------
+
+CREATE TABLE USER_ATTRIBUTE
+(
+ ID INTEGER NOT NULL,
+ APPLICATION_ID INTEGER NOT NULL,
+ NAME VARCHAR(150),
+ DESCRIPTION VARCHAR(150),
+ PRIMARY KEY(ID),
+ FOREIGN KEY (APPLICATION_ID) REFERENCES PORTLET_APPLICATION (APPLICATION_ID)
+ ON DELETE CASCADE
+ );
+
+-----------------------------------------------------------------------------
+-- 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 LONG VARCHAR 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 LONG VARCHAR NOT NULL,
+ LOCALE_STRING VARCHAR(50) NOT NULL,
+ PRIMARY KEY(ID));
+
Added: portals/jetspeed-2/trunk/etc/sql/derby/schema/security-schema.sql
URL: http://svn.apache.org/viewcvs/portals/jetspeed-2/trunk/etc/sql/derby/schema/security-schema.sql?rev=332424&view=auto
==============================================================================
--- portals/jetspeed-2/trunk/etc/sql/derby/schema/security-schema.sql (added)
+++ portals/jetspeed-2/trunk/etc/sql/derby/schema/security-schema.sql Thu Nov 10 18:33:10 2005
@@ -0,0 +1,182 @@
+-----------------------------------------------------------------------------
+-- SECURITY_PRINCIPAL
+-----------------------------------------------------------------------------
+
+CREATE TABLE SECURITY_PRINCIPAL
+(
+ PRINCIPAL_ID INTEGER NOT NULL,
+ CLASSNAME VARCHAR(254) NOT NULL,
+ IS_MAPPING_ONLY INTEGER NOT NULL,
+ IS_ENABLED INTEGER NOT NULL,
+ FULL_PATH VARCHAR(254) NOT NULL,
+ CREATION_DATE TIMESTAMP NOT NULL,
+ MODIFIED_DATE TIMESTAMP NOT NULL,
+ PRIMARY KEY(PRINCIPAL_ID),
+ UNIQUE (FULL_PATH));
+
+-----------------------------------------------------------------------------
+-- SECURITY_PERMISSION
+-----------------------------------------------------------------------------
+
+CREATE TABLE SECURITY_PERMISSION
+(
+ PERMISSION_ID INTEGER NOT NULL,
+ CLASSNAME VARCHAR(254) NOT NULL,
+ NAME VARCHAR(254) NOT NULL,
+ ACTIONS VARCHAR(254) NOT NULL,
+ CREATION_DATE TIMESTAMP NOT NULL,
+ MODIFIED_DATE TIMESTAMP NOT NULL,
+ PRIMARY KEY(PERMISSION_ID));
+
+-----------------------------------------------------------------------------
+-- PRINCIPAL_PERMISSION
+-----------------------------------------------------------------------------
+
+CREATE TABLE PRINCIPAL_PERMISSION
+(
+ PRINCIPAL_ID INTEGER NOT NULL,
+ PERMISSION_ID INTEGER NOT NULL,
+ PRIMARY KEY(PRINCIPAL_ID,PERMISSION_ID),
+ FOREIGN KEY (PERMISSION_ID) REFERENCES SECURITY_PERMISSION (PERMISSION_ID)
+ ON DELETE CASCADE
+ ,
+ FOREIGN KEY (PRINCIPAL_ID) REFERENCES SECURITY_PRINCIPAL (PRINCIPAL_ID)
+ ON DELETE CASCADE
+ );
+
+-----------------------------------------------------------------------------
+-- SECURITY_CREDENTIAL
+-----------------------------------------------------------------------------
+
+CREATE TABLE SECURITY_CREDENTIAL
+(
+ CREDENTIAL_ID INTEGER NOT NULL,
+ PRINCIPAL_ID INTEGER NOT NULL,
+ COLUMN_VALUE VARCHAR(254) NOT NULL,
+ TYPE SMALLINT NOT NULL,
+ CLASSNAME VARCHAR(254),
+ UPDATE_REQUIRED INTEGER NOT NULL,
+ IS_ENCODED INTEGER NOT NULL,
+ IS_ENABLED INTEGER NOT NULL,
+ AUTH_FAILURES SMALLINT NOT NULL,
+ IS_EXPIRED INTEGER NOT NULL,
+ CREATION_DATE TIMESTAMP NOT NULL,
+ MODIFIED_DATE TIMESTAMP NOT NULL,
+ PREV_AUTH_DATE TIMESTAMP,
+ LAST_AUTH_DATE TIMESTAMP,
+ EXPIRATION_DATE DATE,
+ PRIMARY KEY(CREDENTIAL_ID),
+ FOREIGN KEY (PRINCIPAL_ID) REFERENCES SECURITY_PRINCIPAL (PRINCIPAL_ID)
+ ON DELETE CASCADE
+ );
+
+-----------------------------------------------------------------------------
+-- SSO_SITE
+-----------------------------------------------------------------------------
+
+CREATE TABLE SSO_SITE
+(
+ SITE_ID INTEGER NOT NULL,
+ NAME VARCHAR(254) NOT NULL,
+ URL VARCHAR(254) NOT NULL,
+ ALLOW_USER_SET INTEGER default 0,
+ REQUIRES_CERTIFICATE INTEGER default 0,
+ PRIMARY KEY(SITE_ID),
+ UNIQUE (URL));
+
+-----------------------------------------------------------------------------
+-- SSO_SITE_TO_PRINCIPALS
+-----------------------------------------------------------------------------
+
+CREATE TABLE SSO_SITE_TO_PRINCIPALS
+(
+ SITE_ID INTEGER NOT NULL,
+ PRINCIPAL_ID INTEGER NOT NULL,
+ PRIMARY KEY(SITE_ID,PRINCIPAL_ID),
+ FOREIGN KEY (SITE_ID) REFERENCES SSO_SITE (SITE_ID)
+ ON DELETE CASCADE
+ ,
+ FOREIGN KEY (PRINCIPAL_ID) REFERENCES SECURITY_PRINCIPAL (PRINCIPAL_ID)
+ ON DELETE CASCADE
+ );
+
+-----------------------------------------------------------------------------
+-- SSO_PRINCIPAL_TO_REMOTE
+-----------------------------------------------------------------------------
+
+CREATE TABLE SSO_PRINCIPAL_TO_REMOTE
+(
+ PRINCIPAL_ID INTEGER NOT NULL,
+ REMOTE_PRINCIPAL_ID INTEGER NOT NULL,
+ PRIMARY KEY(PRINCIPAL_ID,REMOTE_PRINCIPAL_ID),
+ FOREIGN KEY (PRINCIPAL_ID) REFERENCES SECURITY_PRINCIPAL (PRINCIPAL_ID)
+ ON DELETE CASCADE
+ ,
+ FOREIGN KEY (REMOTE_PRINCIPAL_ID) REFERENCES SECURITY_PRINCIPAL (PRINCIPAL_ID)
+ ON DELETE CASCADE
+ );
+
+-----------------------------------------------------------------------------
+-- SSO_SITE_TO_REMOTE
+-----------------------------------------------------------------------------
+
+CREATE TABLE SSO_SITE_TO_REMOTE
+(
+ SITE_ID INTEGER NOT NULL,
+ PRINCIPAL_ID INTEGER NOT NULL,
+ PRIMARY KEY(SITE_ID,PRINCIPAL_ID),
+ FOREIGN KEY (SITE_ID) REFERENCES SSO_SITE (SITE_ID)
+ ON DELETE CASCADE
+ ,
+ FOREIGN KEY (PRINCIPAL_ID) REFERENCES SECURITY_PRINCIPAL (PRINCIPAL_ID)
+ ON DELETE CASCADE
+ );
+
+-----------------------------------------------------------------------------
+-- SECURITY_USER_ROLE
+-----------------------------------------------------------------------------
+
+CREATE TABLE SECURITY_USER_ROLE
+(
+ USER_ID INTEGER NOT NULL,
+ ROLE_ID INTEGER NOT NULL,
+ PRIMARY KEY(USER_ID,ROLE_ID),
+ FOREIGN KEY (ROLE_ID) REFERENCES SECURITY_PRINCIPAL (PRINCIPAL_ID)
+ ON DELETE CASCADE
+ ,
+ FOREIGN KEY (USER_ID) REFERENCES SECURITY_PRINCIPAL (PRINCIPAL_ID)
+ ON DELETE CASCADE
+ );
+
+-----------------------------------------------------------------------------
+-- SECURITY_USER_GROUP
+-----------------------------------------------------------------------------
+
+CREATE TABLE SECURITY_USER_GROUP
+(
+ USER_ID INTEGER NOT NULL,
+ GROUP_ID INTEGER NOT NULL,
+ PRIMARY KEY(USER_ID,GROUP_ID),
+ FOREIGN KEY (GROUP_ID) REFERENCES SECURITY_PRINCIPAL (PRINCIPAL_ID)
+ ON DELETE CASCADE
+ ,
+ FOREIGN KEY (USER_ID) REFERENCES SECURITY_PRINCIPAL (PRINCIPAL_ID)
+ ON DELETE CASCADE
+ );
+
+-----------------------------------------------------------------------------
+-- SECURITY_GROUP_ROLE
+-----------------------------------------------------------------------------
+
+CREATE TABLE SECURITY_GROUP_ROLE
+(
+ GROUP_ID INTEGER NOT NULL,
+ ROLE_ID INTEGER NOT NULL,
+ PRIMARY KEY(GROUP_ID,ROLE_ID),
+ FOREIGN KEY (GROUP_ID) REFERENCES SECURITY_PRINCIPAL (PRINCIPAL_ID)
+ ON DELETE CASCADE
+ ,
+ FOREIGN KEY (ROLE_ID) REFERENCES SECURITY_PRINCIPAL (PRINCIPAL_ID)
+ ON DELETE CASCADE
+ );
+
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-dev-help@portals.apache.org