geronimo-scm mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From pra...@apache.org
Subject svn commit: r588248 [6/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...
Date Thu, 25 Oct 2007 15:16:11 GMT
Added: geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/mysql/phase2-schema.sql
URL: http://svn.apache.org/viewvc/geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/mysql/phase2-schema.sql?rev=588248&view=auto
==============================================================================
--- geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/mysql/phase2-schema.sql (added)
+++ geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/mysql/phase2-schema.sql Thu Oct 25 08:16:02 2007
@@ -0,0 +1,696 @@
+
+# -----------------------------------------------------------------------
+# FOLDER
+# -----------------------------------------------------------------------
+drop table if exists FOLDER;
+
+CREATE TABLE FOLDER
+(
+    FOLDER_ID MEDIUMINT NOT NULL,
+    PARENT_ID MEDIUMINT,
+    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),
+    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),
+    INDEX IX_FOLDER_1 (PARENT_ID));
+
+# -----------------------------------------------------------------------
+# FOLDER_METADATA
+# -----------------------------------------------------------------------
+drop table if exists FOLDER_METADATA;
+
+CREATE TABLE FOLDER_METADATA
+(
+    METADATA_ID MEDIUMINT NOT NULL,
+    FOLDER_ID MEDIUMINT 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),
+    INDEX IX_FOLDER_METADATA_1 (FOLDER_ID));
+
+# -----------------------------------------------------------------------
+# FOLDER_CONSTRAINT
+# -----------------------------------------------------------------------
+drop table if exists FOLDER_CONSTRAINT;
+
+CREATE TABLE FOLDER_CONSTRAINT
+(
+    CONSTRAINT_ID MEDIUMINT NOT NULL,
+    FOLDER_ID MEDIUMINT NOT NULL,
+    APPLY_ORDER MEDIUMINT 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 
+  ,
+    INDEX IX_FOLDER_CONSTRAINT_1 (FOLDER_ID));
+
+# -----------------------------------------------------------------------
+# FOLDER_CONSTRAINTS_REF
+# -----------------------------------------------------------------------
+drop table if exists FOLDER_CONSTRAINTS_REF;
+
+CREATE TABLE FOLDER_CONSTRAINTS_REF
+(
+    CONSTRAINTS_REF_ID MEDIUMINT NOT NULL,
+    FOLDER_ID MEDIUMINT NOT NULL,
+    APPLY_ORDER MEDIUMINT NOT NULL,
+    NAME VARCHAR(40) NOT NULL,
+    PRIMARY KEY(CONSTRAINTS_REF_ID),
+    FOREIGN KEY (FOLDER_ID) REFERENCES FOLDER (FOLDER_ID)
+        ON DELETE CASCADE 
+  ,
+    UNIQUE (FOLDER_ID, NAME),
+    INDEX IX_FOLDER_CONSTRAINTS_REF_1 (FOLDER_ID));
+
+# -----------------------------------------------------------------------
+# FOLDER_ORDER
+# -----------------------------------------------------------------------
+drop table if exists FOLDER_ORDER;
+
+CREATE TABLE FOLDER_ORDER
+(
+    ORDER_ID MEDIUMINT NOT NULL,
+    FOLDER_ID MEDIUMINT NOT NULL,
+    SORT_ORDER MEDIUMINT NOT NULL,
+    NAME VARCHAR(80) NOT NULL,
+    PRIMARY KEY(ORDER_ID),
+    FOREIGN KEY (FOLDER_ID) REFERENCES FOLDER (FOLDER_ID)
+        ON DELETE CASCADE 
+  ,
+    UNIQUE (FOLDER_ID, NAME),
+    INDEX IX_FOLDER_ORDER_1 (FOLDER_ID));
+
+# -----------------------------------------------------------------------
+# FOLDER_MENU
+# -----------------------------------------------------------------------
+drop table if exists FOLDER_MENU;
+
+CREATE TABLE FOLDER_MENU
+(
+    MENU_ID MEDIUMINT NOT NULL,
+    CLASS_NAME VARCHAR(100) NOT NULL,
+    PARENT_ID MEDIUMINT,
+    FOLDER_ID MEDIUMINT,
+    ELEMENT_ORDER MEDIUMINT,
+    NAME VARCHAR(100),
+    TITLE VARCHAR(100),
+    SHORT_TITLE VARCHAR(40),
+    TEXT VARCHAR(100),
+    OPTIONS VARCHAR(255),
+    DEPTH MEDIUMINT,
+    IS_PATHS INTEGER,
+    IS_REGEXP INTEGER,
+    PROFILE VARCHAR(80),
+    OPTIONS_ORDER VARCHAR(255),
+    SKIN VARCHAR(80),
+    IS_NEST INTEGER,
+    PRIMARY KEY(MENU_ID),
+    FOREIGN KEY (PARENT_ID) REFERENCES FOLDER_MENU (MENU_ID)
+        ON DELETE CASCADE 
+  ,
+    FOREIGN KEY (FOLDER_ID) REFERENCES FOLDER (FOLDER_ID)
+        ON DELETE CASCADE 
+  ,
+    INDEX IX_FOLDER_MENU_1 (PARENT_ID),
+    INDEX UN_FOLDER_MENU_1 (FOLDER_ID, NAME));
+
+# -----------------------------------------------------------------------
+# FOLDER_MENU_METADATA
+# -----------------------------------------------------------------------
+drop table if exists FOLDER_MENU_METADATA;
+
+CREATE TABLE FOLDER_MENU_METADATA
+(
+    METADATA_ID MEDIUMINT NOT NULL,
+    MENU_ID MEDIUMINT NOT NULL,
+    NAME VARCHAR(15) NOT NULL,
+    LOCALE VARCHAR(20) NOT NULL,
+    VALUE VARCHAR(100) NOT NULL,
+    PRIMARY KEY(METADATA_ID),
+    FOREIGN KEY (MENU_ID) REFERENCES FOLDER_MENU (MENU_ID)
+        ON DELETE CASCADE 
+  ,
+    UNIQUE (MENU_ID, NAME, LOCALE, VALUE),
+    INDEX IX_FOLDER_MENU_METADATA_1 (MENU_ID));
+
+# -----------------------------------------------------------------------
+# PAGE
+# -----------------------------------------------------------------------
+drop table if exists PAGE;
+
+CREATE TABLE PAGE
+(
+    PAGE_ID MEDIUMINT NOT NULL,
+    PARENT_ID MEDIUMINT NOT NULL,
+    PATH VARCHAR(240) NOT NULL,
+    NAME VARCHAR(80) NOT NULL,
+    VERSION VARCHAR(40),
+    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),
+    INDEX IX_PAGE_1 (PARENT_ID));
+
+# -----------------------------------------------------------------------
+# PAGE_METADATA
+# -----------------------------------------------------------------------
+drop table if exists PAGE_METADATA;
+
+CREATE TABLE PAGE_METADATA
+(
+    METADATA_ID MEDIUMINT NOT NULL,
+    PAGE_ID MEDIUMINT 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),
+    INDEX IX_PAGE_METADATA_1 (PAGE_ID));
+
+# -----------------------------------------------------------------------
+# PAGE_CONSTRAINT
+# -----------------------------------------------------------------------
+drop table if exists PAGE_CONSTRAINT;
+
+CREATE TABLE PAGE_CONSTRAINT
+(
+    CONSTRAINT_ID MEDIUMINT NOT NULL,
+    PAGE_ID MEDIUMINT NOT NULL,
+    APPLY_ORDER MEDIUMINT 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 
+  ,
+    INDEX IX_PAGE_CONSTRAINT_1 (PAGE_ID));
+
+# -----------------------------------------------------------------------
+# PAGE_CONSTRAINTS_REF
+# -----------------------------------------------------------------------
+drop table if exists PAGE_CONSTRAINTS_REF;
+
+CREATE TABLE PAGE_CONSTRAINTS_REF
+(
+    CONSTRAINTS_REF_ID MEDIUMINT NOT NULL,
+    PAGE_ID MEDIUMINT NOT NULL,
+    APPLY_ORDER MEDIUMINT NOT NULL,
+    NAME VARCHAR(40) NOT NULL,
+    PRIMARY KEY(CONSTRAINTS_REF_ID),
+    FOREIGN KEY (PAGE_ID) REFERENCES PAGE (PAGE_ID)
+        ON DELETE CASCADE 
+  ,
+    UNIQUE (PAGE_ID, NAME),
+    INDEX IX_PAGE_CONSTRAINTS_REF_1 (PAGE_ID));
+
+# -----------------------------------------------------------------------
+# PAGE_MENU
+# -----------------------------------------------------------------------
+drop table if exists PAGE_MENU;
+
+CREATE TABLE PAGE_MENU
+(
+    MENU_ID MEDIUMINT NOT NULL,
+    CLASS_NAME VARCHAR(100) NOT NULL,
+    PARENT_ID MEDIUMINT,
+    PAGE_ID MEDIUMINT,
+    ELEMENT_ORDER MEDIUMINT,
+    NAME VARCHAR(100),
+    TITLE VARCHAR(100),
+    SHORT_TITLE VARCHAR(40),
+    TEXT VARCHAR(100),
+    OPTIONS VARCHAR(255),
+    DEPTH MEDIUMINT,
+    IS_PATHS INTEGER,
+    IS_REGEXP INTEGER,
+    PROFILE VARCHAR(80),
+    OPTIONS_ORDER VARCHAR(255),
+    SKIN VARCHAR(80),
+    IS_NEST INTEGER,
+    PRIMARY KEY(MENU_ID),
+    FOREIGN KEY (PARENT_ID) REFERENCES PAGE_MENU (MENU_ID)
+        ON DELETE CASCADE 
+  ,
+    FOREIGN KEY (PAGE_ID) REFERENCES PAGE (PAGE_ID)
+        ON DELETE CASCADE 
+  ,
+    INDEX IX_PAGE_MENU_1 (PARENT_ID),
+    INDEX UN_PAGE_MENU_1 (PAGE_ID, NAME));
+
+# -----------------------------------------------------------------------
+# PAGE_MENU_METADATA
+# -----------------------------------------------------------------------
+drop table if exists PAGE_MENU_METADATA;
+
+CREATE TABLE PAGE_MENU_METADATA
+(
+    METADATA_ID MEDIUMINT NOT NULL,
+    MENU_ID MEDIUMINT NOT NULL,
+    NAME VARCHAR(15) NOT NULL,
+    LOCALE VARCHAR(20) NOT NULL,
+    VALUE VARCHAR(100) NOT NULL,
+    PRIMARY KEY(METADATA_ID),
+    FOREIGN KEY (MENU_ID) REFERENCES PAGE_MENU (MENU_ID)
+        ON DELETE CASCADE 
+  ,
+    UNIQUE (MENU_ID, NAME, LOCALE, VALUE),
+    INDEX IX_PAGE_MENU_METADATA_1 (MENU_ID));
+
+# -----------------------------------------------------------------------
+# FRAGMENT
+# -----------------------------------------------------------------------
+drop table if exists FRAGMENT;
+
+CREATE TABLE FRAGMENT
+(
+    FRAGMENT_ID MEDIUMINT NOT NULL,
+    PARENT_ID MEDIUMINT,
+    PAGE_ID MEDIUMINT,
+    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 MEDIUMINT,
+    LAYOUT_COLUMN MEDIUMINT,
+    LAYOUT_SIZES VARCHAR(20),
+    LAYOUT_X REAL,
+    LAYOUT_Y REAL,
+    LAYOUT_Z REAL,
+    LAYOUT_WIDTH REAL,
+    LAYOUT_HEIGHT REAL,
+    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 
+  ,
+    INDEX IX_FRAGMENT_1 (PARENT_ID),
+    INDEX UN_FRAGMENT_1 (PAGE_ID));
+
+# -----------------------------------------------------------------------
+# FRAGMENT_CONSTRAINT
+# -----------------------------------------------------------------------
+drop table if exists FRAGMENT_CONSTRAINT;
+
+CREATE TABLE FRAGMENT_CONSTRAINT
+(
+    CONSTRAINT_ID MEDIUMINT NOT NULL,
+    FRAGMENT_ID MEDIUMINT NOT NULL,
+    APPLY_ORDER MEDIUMINT 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 
+  ,
+    INDEX IX_FRAGMENT_CONSTRAINT_1 (FRAGMENT_ID));
+
+# -----------------------------------------------------------------------
+# FRAGMENT_CONSTRAINTS_REF
+# -----------------------------------------------------------------------
+drop table if exists FRAGMENT_CONSTRAINTS_REF;
+
+CREATE TABLE FRAGMENT_CONSTRAINTS_REF
+(
+    CONSTRAINTS_REF_ID MEDIUMINT NOT NULL,
+    FRAGMENT_ID MEDIUMINT NOT NULL,
+    APPLY_ORDER MEDIUMINT NOT NULL,
+    NAME VARCHAR(40) NOT NULL,
+    PRIMARY KEY(CONSTRAINTS_REF_ID),
+    FOREIGN KEY (FRAGMENT_ID) REFERENCES FRAGMENT (FRAGMENT_ID)
+        ON DELETE CASCADE 
+  ,
+    UNIQUE (FRAGMENT_ID, NAME),
+    INDEX IX_FRAGMENT_CONSTRAINTS_REF_1 (FRAGMENT_ID));
+
+# -----------------------------------------------------------------------
+# FRAGMENT_PREF
+# -----------------------------------------------------------------------
+drop table if exists FRAGMENT_PREF;
+
+CREATE TABLE FRAGMENT_PREF
+(
+    PREF_ID MEDIUMINT NOT NULL,
+    FRAGMENT_ID MEDIUMINT NOT NULL,
+    NAME VARCHAR(40) NOT NULL,
+    IS_READ_ONLY INTEGER NOT NULL,
+    PRIMARY KEY(PREF_ID),
+    FOREIGN KEY (FRAGMENT_ID) REFERENCES FRAGMENT (FRAGMENT_ID)
+        ON DELETE CASCADE 
+  ,
+    UNIQUE (FRAGMENT_ID, NAME),
+    INDEX IX_FRAGMENT_PREF_1 (FRAGMENT_ID));
+
+# -----------------------------------------------------------------------
+# FRAGMENT_PREF_VALUE
+# -----------------------------------------------------------------------
+drop table if exists FRAGMENT_PREF_VALUE;
+
+CREATE TABLE FRAGMENT_PREF_VALUE
+(
+    PREF_VALUE_ID MEDIUMINT NOT NULL,
+    PREF_ID MEDIUMINT NOT NULL,
+    VALUE_ORDER MEDIUMINT NOT NULL,
+    VALUE VARCHAR(100) NOT NULL,
+    PRIMARY KEY(PREF_VALUE_ID),
+    FOREIGN KEY (PREF_ID) REFERENCES FRAGMENT_PREF (PREF_ID)
+        ON DELETE CASCADE 
+  ,
+    INDEX IX_FRAGMENT_PREF_VALUE_1 (PREF_ID));
+
+# -----------------------------------------------------------------------
+# LINK
+# -----------------------------------------------------------------------
+drop table if exists LINK;
+
+CREATE TABLE LINK
+(
+    LINK_ID MEDIUMINT NOT NULL,
+    PARENT_ID MEDIUMINT NOT NULL,
+    PATH VARCHAR(240) NOT NULL,
+    NAME VARCHAR(80) NOT NULL,
+    VERSION VARCHAR(40),
+    TITLE VARCHAR(100),
+    SHORT_TITLE VARCHAR(40),
+    IS_HIDDEN INTEGER 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),
+    FOREIGN KEY (PARENT_ID) REFERENCES FOLDER (FOLDER_ID)
+        ON DELETE CASCADE 
+  ,
+    UNIQUE (PATH),
+    INDEX IX_LINK_1 (PARENT_ID));
+
+# -----------------------------------------------------------------------
+# LINK_METADATA
+# -----------------------------------------------------------------------
+drop table if exists LINK_METADATA;
+
+CREATE TABLE LINK_METADATA
+(
+    METADATA_ID MEDIUMINT NOT NULL,
+    LINK_ID MEDIUMINT NOT NULL,
+    NAME VARCHAR(15) NOT NULL,
+    LOCALE VARCHAR(20) NOT NULL,
+    VALUE VARCHAR(100) NOT NULL,
+    PRIMARY KEY(METADATA_ID),
+    FOREIGN KEY (LINK_ID) REFERENCES LINK (LINK_ID)
+        ON DELETE CASCADE 
+  ,
+    UNIQUE (LINK_ID, NAME, LOCALE, VALUE),
+    INDEX IX_LINK_METADATA_1 (LINK_ID));
+
+# -----------------------------------------------------------------------
+# LINK_CONSTRAINT
+# -----------------------------------------------------------------------
+drop table if exists LINK_CONSTRAINT;
+
+CREATE TABLE LINK_CONSTRAINT
+(
+    CONSTRAINT_ID MEDIUMINT NOT NULL,
+    LINK_ID MEDIUMINT NOT NULL,
+    APPLY_ORDER MEDIUMINT 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 (LINK_ID) REFERENCES LINK (LINK_ID)
+        ON DELETE CASCADE 
+  ,
+    INDEX IX_LINK_CONSTRAINT_1 (LINK_ID));
+
+# -----------------------------------------------------------------------
+# LINK_CONSTRAINTS_REF
+# -----------------------------------------------------------------------
+drop table if exists LINK_CONSTRAINTS_REF;
+
+CREATE TABLE LINK_CONSTRAINTS_REF
+(
+    CONSTRAINTS_REF_ID MEDIUMINT NOT NULL,
+    LINK_ID MEDIUMINT NOT NULL,
+    APPLY_ORDER MEDIUMINT NOT NULL,
+    NAME VARCHAR(40) NOT NULL,
+    PRIMARY KEY(CONSTRAINTS_REF_ID),
+    FOREIGN KEY (LINK_ID) REFERENCES LINK (LINK_ID)
+        ON DELETE CASCADE 
+  ,
+    UNIQUE (LINK_ID, NAME),
+    INDEX IX_LINK_CONSTRAINTS_REF_1 (LINK_ID));
+
+# -----------------------------------------------------------------------
+# PAGE_SECURITY
+# -----------------------------------------------------------------------
+drop table if exists PAGE_SECURITY;
+
+CREATE TABLE PAGE_SECURITY
+(
+    PAGE_SECURITY_ID MEDIUMINT NOT NULL,
+    PARENT_ID MEDIUMINT 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),
+    FOREIGN KEY (PARENT_ID) REFERENCES FOLDER (FOLDER_ID)
+        ON DELETE CASCADE 
+  ,
+    UNIQUE (PARENT_ID),
+    UNIQUE (PATH));
+
+# -----------------------------------------------------------------------
+# PAGE_SEC_CONSTRAINTS_DEF
+# -----------------------------------------------------------------------
+drop table if exists PAGE_SEC_CONSTRAINTS_DEF;
+
+CREATE TABLE PAGE_SEC_CONSTRAINTS_DEF
+(
+    CONSTRAINTS_DEF_ID MEDIUMINT NOT NULL,
+    PAGE_SECURITY_ID MEDIUMINT NOT NULL,
+    NAME VARCHAR(40) NOT NULL,
+    PRIMARY KEY(CONSTRAINTS_DEF_ID),
+    FOREIGN KEY (PAGE_SECURITY_ID) REFERENCES PAGE_SECURITY (PAGE_SECURITY_ID)
+        ON DELETE CASCADE 
+  ,
+    UNIQUE (PAGE_SECURITY_ID, NAME),
+    INDEX IX_PAGE_SEC_CONSTRAINTS_DEF_1 (PAGE_SECURITY_ID));
+
+# -----------------------------------------------------------------------
+# PAGE_SEC_CONSTRAINT_DEF
+# -----------------------------------------------------------------------
+drop table if exists PAGE_SEC_CONSTRAINT_DEF;
+
+CREATE TABLE PAGE_SEC_CONSTRAINT_DEF
+(
+    CONSTRAINT_DEF_ID MEDIUMINT NOT NULL,
+    CONSTRAINTS_DEF_ID MEDIUMINT NOT NULL,
+    APPLY_ORDER MEDIUMINT 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),
+    FOREIGN KEY (CONSTRAINTS_DEF_ID) REFERENCES PAGE_SEC_CONSTRAINTS_DEF (CONSTRAINTS_DEF_ID)
+        ON DELETE CASCADE 
+  ,
+    INDEX IX_PAGE_SEC_CONSTRAINT_DEF_1 (CONSTRAINTS_DEF_ID));
+
+# -----------------------------------------------------------------------
+# PAGE_SEC_CONSTRAINTS_REF
+# -----------------------------------------------------------------------
+drop table if exists PAGE_SEC_CONSTRAINTS_REF;
+
+CREATE TABLE PAGE_SEC_CONSTRAINTS_REF
+(
+    CONSTRAINTS_REF_ID MEDIUMINT NOT NULL,
+    PAGE_SECURITY_ID MEDIUMINT NOT NULL,
+    APPLY_ORDER MEDIUMINT 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 
+  ,
+    UNIQUE (PAGE_SECURITY_ID, NAME),
+    INDEX IX_PAGE_SEC_CONSTRAINTS_REF_1 (PAGE_SECURITY_ID));
+
+# -----------------------------------------------------------------------
+# PROFILING_RULE
+# -----------------------------------------------------------------------
+drop table if exists 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
+# -----------------------------------------------------------------------
+drop table if exists RULE_CRITERION;
+
+CREATE TABLE RULE_CRITERION
+(
+    CRITERION_ID VARCHAR(80) NOT NULL,
+    RULE_ID VARCHAR(80) NOT NULL,
+    FALLBACK_ORDER MEDIUMINT NOT NULL,
+    REQUEST_TYPE VARCHAR(40) NOT NULL,
+    NAME VARCHAR(80) NOT NULL,
+    COLUMN_VALUE VARCHAR(128),
+    FALLBACK_TYPE MEDIUMINT default 1,
+    PRIMARY KEY(CRITERION_ID),
+    FOREIGN KEY (RULE_ID) REFERENCES PROFILING_RULE (RULE_ID)
+        ON DELETE CASCADE 
+  ,
+    INDEX IX_RULE_CRITERION_1 (RULE_ID, FALLBACK_ORDER));
+
+# -----------------------------------------------------------------------
+# PRINCIPAL_RULE_ASSOC
+# -----------------------------------------------------------------------
+drop table if exists 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
+# -----------------------------------------------------------------------
+drop table if exists 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
+# -----------------------------------------------------------------------
+drop table if exists 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 MEDIUMINT,
+    FOUNDED MEDIUMINT,
+    PITCH VARCHAR(40),
+    NICKNAME VARCHAR(40),
+    PRIMARY KEY(NAME));
+  
+  
+  
+  
+  
+  
+  
+  
+  
+  
+  
+  
+  
+  
+  
+  
+  
+  
+  
+  
+  
+  
+  
+  
+  
+  
+  
+  
+  
+  
+  

Propchange: geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/mysql/phase2-schema.sql
------------------------------------------------------------------------------
    svn:eol-style = native

Propchange: geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/mysql/phase2-schema.sql
------------------------------------------------------------------------------
    svn:keywords = Date Revision

Propchange: geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/mysql/phase2-schema.sql
------------------------------------------------------------------------------
    svn:mime-type = text/plain

Added: geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/mysql/phase3ojb-schema.sql
URL: http://svn.apache.org/viewvc/geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/mysql/phase3ojb-schema.sql?rev=588248&view=auto
==============================================================================
--- geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/mysql/phase3ojb-schema.sql (added)
+++ geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/mysql/phase3ojb-schema.sql Thu Oct 25 08:16:02 2007
@@ -0,0 +1,106 @@
+
+# -----------------------------------------------------------------------
+# OJB_HL_SEQ
+# -----------------------------------------------------------------------
+drop table if exists OJB_HL_SEQ;
+
+CREATE TABLE OJB_HL_SEQ
+(
+    TABLENAME VARCHAR(175) NOT NULL,
+    FIELDNAME VARCHAR(70) NOT NULL,
+    MAX_KEY MEDIUMINT,
+    GRAB_SIZE MEDIUMINT,
+    VERSION MEDIUMINT,
+    PRIMARY KEY(TABLENAME,FIELDNAME));
+
+# -----------------------------------------------------------------------
+# OJB_LOCKENTRY
+# -----------------------------------------------------------------------
+drop table if exists OJB_LOCKENTRY;
+
+CREATE TABLE OJB_LOCKENTRY
+(
+    OID_ VARCHAR(250) NOT NULL,
+    TX_ID VARCHAR(50) NOT NULL,
+    TIMESTAMP_ TIMESTAMP,
+    ISOLATIONLEVEL MEDIUMINT,
+    LOCKTYPE MEDIUMINT,
+    PRIMARY KEY(OID_,TX_ID));
+
+# -----------------------------------------------------------------------
+# OJB_NRM
+# -----------------------------------------------------------------------
+drop table if exists OJB_NRM;
+
+CREATE TABLE OJB_NRM
+(
+    NAME VARCHAR(250) NOT NULL,
+    OID_ LONGBLOB,
+    PRIMARY KEY(NAME));
+
+# -----------------------------------------------------------------------
+# OJB_DLIST
+# -----------------------------------------------------------------------
+drop table if exists OJB_DLIST;
+
+CREATE TABLE OJB_DLIST
+(
+    ID MEDIUMINT NOT NULL,
+    SIZE_ MEDIUMINT,
+    PRIMARY KEY(ID));
+
+# -----------------------------------------------------------------------
+# OJB_DLIST_ENTRIES
+# -----------------------------------------------------------------------
+drop table if exists OJB_DLIST_ENTRIES;
+
+CREATE TABLE OJB_DLIST_ENTRIES
+(
+    ID MEDIUMINT NOT NULL,
+    DLIST_ID MEDIUMINT,
+    POSITION_ MEDIUMINT,
+    OID_ LONGBLOB,
+    PRIMARY KEY(ID));
+
+# -----------------------------------------------------------------------
+# OJB_DSET
+# -----------------------------------------------------------------------
+drop table if exists OJB_DSET;
+
+CREATE TABLE OJB_DSET
+(
+    ID MEDIUMINT NOT NULL,
+    SIZE_ MEDIUMINT,
+    PRIMARY KEY(ID));
+
+# -----------------------------------------------------------------------
+# OJB_DSET_ENTRIES
+# -----------------------------------------------------------------------
+drop table if exists OJB_DSET_ENTRIES;
+
+CREATE TABLE OJB_DSET_ENTRIES
+(
+    ID MEDIUMINT NOT NULL,
+    DLIST_ID MEDIUMINT,
+    POSITION_ MEDIUMINT,
+    OID_ LONGBLOB,
+    PRIMARY KEY(ID));
+
+# -----------------------------------------------------------------------
+# OJB_DMAP
+# -----------------------------------------------------------------------
+drop table if exists OJB_DMAP;
+
+CREATE TABLE OJB_DMAP
+(
+    ID MEDIUMINT NOT NULL,
+    SIZE_ MEDIUMINT,
+    PRIMARY KEY(ID));
+  
+  
+  
+  
+  
+  
+  
+  

Propchange: geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/mysql/phase3ojb-schema.sql
------------------------------------------------------------------------------
    svn:eol-style = native

Propchange: geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/mysql/phase3ojb-schema.sql
------------------------------------------------------------------------------
    svn:keywords = Date Revision

Propchange: geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/mysql/phase3ojb-schema.sql
------------------------------------------------------------------------------
    svn:mime-type = text/plain

Added: geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/mysql/prefs-schema.sql
URL: http://svn.apache.org/viewvc/geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/mysql/prefs-schema.sql?rev=588248&view=auto
==============================================================================
--- geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/mysql/prefs-schema.sql (added)
+++ geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/mysql/prefs-schema.sql Thu Oct 25 08:16:02 2007
@@ -0,0 +1,35 @@
+
+# -----------------------------------------------------------------------
+# PREFS_PROPERTY_VALUE
+# -----------------------------------------------------------------------
+drop table if exists PREFS_PROPERTY_VALUE;
+
+CREATE TABLE PREFS_PROPERTY_VALUE
+(
+    PROPERTY_VALUE_ID MEDIUMINT NOT NULL,
+    NODE_ID MEDIUMINT,
+    PROPERTY_NAME VARCHAR(100),
+    PROPERTY_VALUE VARCHAR(254),
+    CREATION_DATE TIMESTAMP,
+    MODIFIED_DATE TIMESTAMP,
+    PRIMARY KEY(PROPERTY_VALUE_ID));
+
+# -----------------------------------------------------------------------
+# PREFS_NODE
+# -----------------------------------------------------------------------
+drop table if exists PREFS_NODE;
+
+CREATE TABLE PREFS_NODE
+(
+    NODE_ID MEDIUMINT NOT NULL,
+    PARENT_NODE_ID MEDIUMINT,
+    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)
+    );
+  
+  

Propchange: geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/mysql/prefs-schema.sql
------------------------------------------------------------------------------
    svn:eol-style = native

Propchange: geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/mysql/prefs-schema.sql
------------------------------------------------------------------------------
    svn:keywords = Date Revision

Propchange: geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/mysql/prefs-schema.sql
------------------------------------------------------------------------------
    svn:mime-type = text/plain

Added: geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/mysql/registry-schema.sql
URL: http://svn.apache.org/viewvc/geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/mysql/registry-schema.sql?rev=588248&view=auto
==============================================================================
--- geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/mysql/registry-schema.sql (added)
+++ geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/mysql/registry-schema.sql Thu Oct 25 08:16:02 2007
@@ -0,0 +1,288 @@
+
+# -----------------------------------------------------------------------
+# PORTLET_DEFINITION
+# -----------------------------------------------------------------------
+drop table if exists PORTLET_DEFINITION;
+
+CREATE TABLE PORTLET_DEFINITION
+(
+    ID MEDIUMINT NOT NULL,
+    NAME VARCHAR(80),
+    CLASS_NAME VARCHAR(255),
+    APPLICATION_ID MEDIUMINT 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
+# -----------------------------------------------------------------------
+drop table if exists PORTLET_APPLICATION;
+
+CREATE TABLE PORTLET_APPLICATION
+(
+    APPLICATION_ID MEDIUMINT NOT NULL,
+    APP_NAME VARCHAR(80) NOT NULL,
+    APP_IDENTIFIER VARCHAR(80),
+    VERSION VARCHAR(80),
+    APP_TYPE MEDIUMINT,
+    CHECKSUM VARCHAR(80),
+    DESCRIPTION VARCHAR(80),
+    WEB_APP_ID MEDIUMINT NOT NULL,
+    SECURITY_REF VARCHAR(40),
+    PRIMARY KEY(APPLICATION_ID),
+    UNIQUE (APP_NAME));
+
+# -----------------------------------------------------------------------
+# WEB_APPLICATION
+# -----------------------------------------------------------------------
+drop table if exists WEB_APPLICATION;
+
+CREATE TABLE WEB_APPLICATION
+(
+    ID MEDIUMINT NOT NULL,
+    CONTEXT_ROOT VARCHAR(255) NOT NULL,
+    PRIMARY KEY(ID));
+
+# -----------------------------------------------------------------------
+# PA_METADATA_FIELDS
+# -----------------------------------------------------------------------
+drop table if exists PA_METADATA_FIELDS;
+
+CREATE TABLE PA_METADATA_FIELDS
+(
+    ID MEDIUMINT NOT NULL,
+    OBJECT_ID MEDIUMINT NOT NULL,
+    COLUMN_VALUE MEDIUMTEXT 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
+# -----------------------------------------------------------------------
+drop table if exists PD_METADATA_FIELDS;
+
+CREATE TABLE PD_METADATA_FIELDS
+(
+    ID MEDIUMINT NOT NULL,
+    OBJECT_ID MEDIUMINT NOT NULL,
+    COLUMN_VALUE MEDIUMTEXT 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
+# -----------------------------------------------------------------------
+drop table if exists LANGUAGE;
+
+CREATE TABLE LANGUAGE
+(
+    ID MEDIUMINT NOT NULL,
+    PORTLET_ID MEDIUMINT NOT NULL,
+    TITLE VARCHAR(100),
+    SHORT_TITLE VARCHAR(100),
+    LOCALE_STRING VARCHAR(50) NOT NULL,
+    KEYWORDS MEDIUMTEXT,
+    PRIMARY KEY(ID));
+
+# -----------------------------------------------------------------------
+# PORTLET_CONTENT_TYPE
+# -----------------------------------------------------------------------
+drop table if exists PORTLET_CONTENT_TYPE;
+
+CREATE TABLE PORTLET_CONTENT_TYPE
+(
+    CONTENT_TYPE_ID MEDIUMINT NOT NULL,
+    PORTLET_ID MEDIUMINT NOT NULL,
+    CONTENT_TYPE VARCHAR(30) NOT NULL,
+    MODES MEDIUMTEXT,
+    PRIMARY KEY(CONTENT_TYPE_ID));
+
+# -----------------------------------------------------------------------
+# PARAMETER
+# -----------------------------------------------------------------------
+drop table if exists PARAMETER;
+
+CREATE TABLE PARAMETER
+(
+    PARAMETER_ID MEDIUMINT NOT NULL,
+    PARENT_ID MEDIUMINT NOT NULL,
+    CLASS_NAME VARCHAR(255) NOT NULL,
+    NAME VARCHAR(80) NOT NULL,
+    PARAMETER_VALUE MEDIUMTEXT NOT NULL,
+    PRIMARY KEY(PARAMETER_ID));
+
+# -----------------------------------------------------------------------
+# PORTLET_ENTITY
+# -----------------------------------------------------------------------
+drop table if exists PORTLET_ENTITY;
+
+CREATE TABLE PORTLET_ENTITY
+(
+    PEID MEDIUMINT 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
+# -----------------------------------------------------------------------
+drop table if exists SECURITY_ROLE_REFERENCE;
+
+CREATE TABLE SECURITY_ROLE_REFERENCE
+(
+    ID MEDIUMINT NOT NULL,
+    PORTLET_DEFINITION_ID MEDIUMINT NOT NULL,
+    ROLE_NAME VARCHAR(150) NOT NULL,
+    ROLE_LINK VARCHAR(150),
+    PRIMARY KEY(ID));
+
+# -----------------------------------------------------------------------
+# SECURITY_ROLE
+# -----------------------------------------------------------------------
+drop table if exists SECURITY_ROLE;
+
+CREATE TABLE SECURITY_ROLE
+(
+    ID MEDIUMINT NOT NULL,
+    WEB_APPLICATION_ID MEDIUMINT NOT NULL,
+    ROLE_NAME VARCHAR(150) NOT NULL,
+    DESCRIPTION VARCHAR(150),
+    PRIMARY KEY(ID));
+
+# -----------------------------------------------------------------------
+# USER_ATTRIBUTE_REF
+# -----------------------------------------------------------------------
+drop table if exists USER_ATTRIBUTE_REF;
+
+CREATE TABLE USER_ATTRIBUTE_REF
+(
+    ID MEDIUMINT NOT NULL,
+    APPLICATION_ID MEDIUMINT 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
+# -----------------------------------------------------------------------
+drop table if exists USER_ATTRIBUTE;
+
+CREATE TABLE USER_ATTRIBUTE
+(
+    ID MEDIUMINT NOT NULL,
+    APPLICATION_ID MEDIUMINT 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
+# -----------------------------------------------------------------------
+drop table if exists JETSPEED_SERVICE;
+
+CREATE TABLE JETSPEED_SERVICE
+(
+    ID MEDIUMINT NOT NULL,
+    APPLICATION_ID MEDIUMINT NOT NULL,
+    NAME VARCHAR(150),
+    PRIMARY KEY(ID));
+
+# -----------------------------------------------------------------------
+# LOCALIZED_DESCRIPTION
+# -----------------------------------------------------------------------
+drop table if exists LOCALIZED_DESCRIPTION;
+
+CREATE TABLE LOCALIZED_DESCRIPTION
+(
+    ID MEDIUMINT NOT NULL,
+    OBJECT_ID MEDIUMINT NOT NULL,
+    CLASS_NAME VARCHAR(255) NOT NULL,
+    DESCRIPTION MEDIUMTEXT NOT NULL,
+    LOCALE_STRING VARCHAR(50) NOT NULL,
+    PRIMARY KEY(ID));
+
+# -----------------------------------------------------------------------
+# LOCALIZED_DISPLAY_NAME
+# -----------------------------------------------------------------------
+drop table if exists LOCALIZED_DISPLAY_NAME;
+
+CREATE TABLE LOCALIZED_DISPLAY_NAME
+(
+    ID MEDIUMINT NOT NULL,
+    OBJECT_ID MEDIUMINT NOT NULL,
+    CLASS_NAME VARCHAR(255),
+    DISPLAY_NAME MEDIUMTEXT NOT NULL,
+    LOCALE_STRING VARCHAR(50) NOT NULL,
+    PRIMARY KEY(ID));
+
+# -----------------------------------------------------------------------
+# CUSTOM_PORTLET_MODE
+# -----------------------------------------------------------------------
+drop table if exists CUSTOM_PORTLET_MODE;
+
+CREATE TABLE CUSTOM_PORTLET_MODE
+(
+    ID MEDIUMINT NOT NULL,
+    APPLICATION_ID MEDIUMINT NOT NULL,
+    CUSTOM_NAME VARCHAR(150) NOT NULL,
+    MAPPED_NAME VARCHAR(150),
+    DESCRIPTION MEDIUMTEXT,
+    PRIMARY KEY(ID),
+    FOREIGN KEY (APPLICATION_ID) REFERENCES PORTLET_APPLICATION (APPLICATION_ID)
+        ON DELETE CASCADE 
+  );
+
+# -----------------------------------------------------------------------
+# CUSTOM_WINDOW_STATE
+# -----------------------------------------------------------------------
+drop table if exists CUSTOM_WINDOW_STATE;
+
+CREATE TABLE CUSTOM_WINDOW_STATE
+(
+    ID MEDIUMINT NOT NULL,
+    APPLICATION_ID MEDIUMINT NOT NULL,
+    CUSTOM_NAME VARCHAR(150) NOT NULL,
+    MAPPED_NAME VARCHAR(150),
+    DESCRIPTION MEDIUMTEXT,
+    PRIMARY KEY(ID),
+    FOREIGN KEY (APPLICATION_ID) REFERENCES PORTLET_APPLICATION (APPLICATION_ID)
+        ON DELETE CASCADE 
+  );
+  
+  
+  
+  
+  
+  
+  
+  
+  
+  
+  
+  
+  
+  
+  
+  
+  
+  

Propchange: geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/mysql/registry-schema.sql
------------------------------------------------------------------------------
    svn:eol-style = native

Propchange: geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/mysql/registry-schema.sql
------------------------------------------------------------------------------
    svn:keywords = Date Revision

Propchange: geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/mysql/registry-schema.sql
------------------------------------------------------------------------------
    svn:mime-type = text/plain

Added: geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/mysql/security-schema.sql
URL: http://svn.apache.org/viewvc/geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/mysql/security-schema.sql?rev=588248&view=auto
==============================================================================
--- geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/mysql/security-schema.sql (added)
+++ geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/mysql/security-schema.sql Thu Oct 25 08:16:02 2007
@@ -0,0 +1,240 @@
+
+# -----------------------------------------------------------------------
+# SECURITY_PRINCIPAL
+# -----------------------------------------------------------------------
+drop table if exists SECURITY_PRINCIPAL;
+
+CREATE TABLE SECURITY_PRINCIPAL
+(
+    PRINCIPAL_ID MEDIUMINT 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
+# -----------------------------------------------------------------------
+drop table if exists SECURITY_PERMISSION;
+
+CREATE TABLE SECURITY_PERMISSION
+(
+    PERMISSION_ID MEDIUMINT 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
+# -----------------------------------------------------------------------
+drop table if exists PRINCIPAL_PERMISSION;
+
+CREATE TABLE PRINCIPAL_PERMISSION
+(
+    PRINCIPAL_ID MEDIUMINT NOT NULL,
+    PERMISSION_ID MEDIUMINT 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
+# -----------------------------------------------------------------------
+drop table if exists SECURITY_CREDENTIAL;
+
+CREATE TABLE SECURITY_CREDENTIAL
+(
+    CREDENTIAL_ID MEDIUMINT NOT NULL,
+    PRINCIPAL_ID MEDIUMINT 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 DATETIME,
+    PRIMARY KEY(CREDENTIAL_ID),
+    FOREIGN KEY (PRINCIPAL_ID) REFERENCES SECURITY_PRINCIPAL (PRINCIPAL_ID)
+        ON DELETE CASCADE 
+  );
+
+# -----------------------------------------------------------------------
+# SSO_SITE
+# -----------------------------------------------------------------------
+drop table if exists SSO_SITE;
+
+CREATE TABLE SSO_SITE
+(
+    SITE_ID MEDIUMINT NOT NULL,
+    NAME VARCHAR(254) NOT NULL,
+    URL VARCHAR(254) NOT NULL,
+    ALLOW_USER_SET INTEGER default 0,
+    REQUIRES_CERTIFICATE INTEGER default 0,
+    CHALLENGE_RESPONSE_AUTH INTEGER default 0,
+    FORM_AUTH INTEGER default 0,
+    FORM_USER_FIELD VARCHAR(128),
+    FORM_PWD_FIELD VARCHAR(128),
+    REALM VARCHAR(128),
+    PRIMARY KEY(SITE_ID),
+    UNIQUE (URL));
+
+# -----------------------------------------------------------------------
+# SSO_COOKIE
+# -----------------------------------------------------------------------
+drop table if exists SSO_COOKIE;
+
+CREATE TABLE SSO_COOKIE
+(
+    COOKIE_ID MEDIUMINT NOT NULL,
+    COOKIE VARCHAR(1024) NOT NULL,
+    CREATE_DATE TIMESTAMP NOT NULL,
+    PRIMARY KEY(COOKIE_ID));
+
+# -----------------------------------------------------------------------
+# SSO_SITE_TO_PRINCIPALS
+# -----------------------------------------------------------------------
+drop table if exists SSO_SITE_TO_PRINCIPALS;
+
+CREATE TABLE SSO_SITE_TO_PRINCIPALS
+(
+    SITE_ID MEDIUMINT NOT NULL,
+    PRINCIPAL_ID MEDIUMINT 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
+# -----------------------------------------------------------------------
+drop table if exists SSO_PRINCIPAL_TO_REMOTE;
+
+CREATE TABLE SSO_PRINCIPAL_TO_REMOTE
+(
+    PRINCIPAL_ID MEDIUMINT NOT NULL,
+    REMOTE_PRINCIPAL_ID MEDIUMINT 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
+# -----------------------------------------------------------------------
+drop table if exists SSO_SITE_TO_REMOTE;
+
+CREATE TABLE SSO_SITE_TO_REMOTE
+(
+    SITE_ID MEDIUMINT NOT NULL,
+    PRINCIPAL_ID MEDIUMINT 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_COOKIE_TO_REMOTE
+# -----------------------------------------------------------------------
+drop table if exists SSO_COOKIE_TO_REMOTE;
+
+CREATE TABLE SSO_COOKIE_TO_REMOTE
+(
+    COOKIE_ID MEDIUMINT NOT NULL,
+    REMOTE_PRINCIPAL_ID MEDIUMINT NOT NULL,
+    PRIMARY KEY(COOKIE_ID,REMOTE_PRINCIPAL_ID),
+    FOREIGN KEY (COOKIE_ID) REFERENCES SSO_COOKIE (COOKIE_ID)
+        ON DELETE CASCADE 
+  ,
+    FOREIGN KEY (REMOTE_PRINCIPAL_ID) REFERENCES SECURITY_PRINCIPAL (PRINCIPAL_ID)
+        ON DELETE CASCADE 
+  );
+
+# -----------------------------------------------------------------------
+# SECURITY_USER_ROLE
+# -----------------------------------------------------------------------
+drop table if exists SECURITY_USER_ROLE;
+
+CREATE TABLE SECURITY_USER_ROLE
+(
+    USER_ID MEDIUMINT NOT NULL,
+    ROLE_ID MEDIUMINT 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
+# -----------------------------------------------------------------------
+drop table if exists SECURITY_USER_GROUP;
+
+CREATE TABLE SECURITY_USER_GROUP
+(
+    USER_ID MEDIUMINT NOT NULL,
+    GROUP_ID MEDIUMINT 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
+# -----------------------------------------------------------------------
+drop table if exists SECURITY_GROUP_ROLE;
+
+CREATE TABLE SECURITY_GROUP_ROLE
+(
+    GROUP_ID MEDIUMINT NOT NULL,
+    ROLE_ID MEDIUMINT 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 
+  );
+  
+  
+  
+  
+  
+  
+  
+  
+  
+  
+  
+  
+  

Propchange: geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/mysql/security-schema.sql
------------------------------------------------------------------------------
    svn:eol-style = native

Propchange: geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/mysql/security-schema.sql
------------------------------------------------------------------------------
    svn:keywords = Date Revision

Propchange: geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/mysql/security-schema.sql
------------------------------------------------------------------------------
    svn:mime-type = text/plain

Added: geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/oracle/phase1-schema.sql
URL: http://svn.apache.org/viewvc/geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/oracle/phase1-schema.sql?rev=588248&view=auto
==============================================================================
--- geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/oracle/phase1-schema.sql (added)
+++ geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/oracle/phase1-schema.sql Thu Oct 25 08:16:02 2007
@@ -0,0 +1,282 @@
+
+-----------------------------------------------------------------------------
+-- MEDIA_TYPE
+-----------------------------------------------------------------------------
+
+CREATE TABLE MEDIA_TYPE
+(
+    MEDIATYPE_ID NUMBER(10,0) NOT NULL,
+    NAME VARCHAR2(80) NOT NULL,
+    CHARACTER_SET VARCHAR2(40),
+    TITLE VARCHAR2(80),
+    DESCRIPTION VARCHAR2(2000)
+);
+
+ALTER TABLE MEDIA_TYPE
+    ADD CONSTRAINT MEDIA_TYPE_PK
+PRIMARY KEY (MEDIATYPE_ID);
+
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- CLIENT
+-----------------------------------------------------------------------------
+
+CREATE TABLE CLIENT
+(
+    CLIENT_ID NUMBER(10,0) NOT NULL,
+    EVAL_ORDER NUMBER(10,0) NOT NULL,
+    NAME VARCHAR2(80) NOT NULL,
+    USER_AGENT_PATTERN VARCHAR2(128),
+    MANUFACTURER VARCHAR2(80),
+    MODEL VARCHAR2(80),
+    VERSION VARCHAR2(40),
+    PREFERRED_MIMETYPE_ID NUMBER(10,0) NOT NULL
+);
+
+ALTER TABLE CLIENT
+    ADD CONSTRAINT CLIENT_PK
+PRIMARY KEY (CLIENT_ID);
+
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- MIMETYPE
+-----------------------------------------------------------------------------
+
+CREATE TABLE MIMETYPE
+(
+    MIMETYPE_ID NUMBER(10,0) NOT NULL,
+    NAME VARCHAR2(80) NOT NULL
+);
+
+ALTER TABLE MIMETYPE
+    ADD CONSTRAINT MIMETYPE_PK
+PRIMARY KEY (MIMETYPE_ID);
+
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- CAPABILITY
+-----------------------------------------------------------------------------
+
+CREATE TABLE CAPABILITY
+(
+    CAPABILITY_ID NUMBER(10,0) NOT NULL,
+    CAPABILITY VARCHAR2(80) NOT NULL
+);
+
+ALTER TABLE CAPABILITY
+    ADD CONSTRAINT CAPABILITY_PK
+PRIMARY KEY (CAPABILITY_ID);
+
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- CLIENT_TO_CAPABILITY
+-----------------------------------------------------------------------------
+
+CREATE TABLE CLIENT_TO_CAPABILITY
+(
+    CLIENT_ID NUMBER(10,0) NOT NULL,
+    CAPABILITY_ID NUMBER(10,0) NOT NULL
+);
+
+
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- CLIENT_TO_MIMETYPE
+-----------------------------------------------------------------------------
+
+CREATE TABLE CLIENT_TO_MIMETYPE
+(
+    CLIENT_ID NUMBER(10,0) NOT NULL,
+    MIMETYPE_ID NUMBER(10,0) NOT NULL
+);
+
+
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- MEDIATYPE_TO_CAPABILITY
+-----------------------------------------------------------------------------
+
+CREATE TABLE MEDIATYPE_TO_CAPABILITY
+(
+    MEDIATYPE_ID NUMBER(10,0) NOT NULL,
+    CAPABILITY_ID NUMBER(10,0) NOT NULL
+);
+
+
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- MEDIATYPE_TO_MIMETYPE
+-----------------------------------------------------------------------------
+
+CREATE TABLE MEDIATYPE_TO_MIMETYPE
+(
+    MEDIATYPE_ID NUMBER(10,0) NOT NULL,
+    MIMETYPE_ID NUMBER(10,0) NOT NULL
+);
+
+
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- PORTLET_STATISTICS
+-----------------------------------------------------------------------------
+
+CREATE TABLE PORTLET_STATISTICS
+(
+    IPADDRESS VARCHAR2(80),
+    USER_NAME VARCHAR2(80),
+    TIME_STAMP TIMESTAMP,
+    PAGE VARCHAR2(80),
+    PORTLET VARCHAR2(255),
+    STATUS NUMBER(10,0),
+    ELAPSED_TIME NUMBER(20,0)
+);
+
+
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- PAGE_STATISTICS
+-----------------------------------------------------------------------------
+
+CREATE TABLE PAGE_STATISTICS
+(
+    IPADDRESS VARCHAR2(80),
+    USER_NAME VARCHAR2(80),
+    TIME_STAMP TIMESTAMP,
+    PAGE VARCHAR2(80),
+    STATUS NUMBER(10,0),
+    ELAPSED_TIME NUMBER(20,0)
+);
+
+
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- USER_STATISTICS
+-----------------------------------------------------------------------------
+
+CREATE TABLE USER_STATISTICS
+(
+    IPADDRESS VARCHAR2(80),
+    USER_NAME VARCHAR2(80),
+    TIME_STAMP TIMESTAMP,
+    STATUS NUMBER(10,0),
+    ELAPSED_TIME NUMBER(20,0)
+);
+
+
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- ADMIN_ACTIVITY
+-----------------------------------------------------------------------------
+
+CREATE TABLE ADMIN_ACTIVITY
+(
+    ACTIVITY VARCHAR2(40),
+    CATEGORY VARCHAR2(40),
+    ADMIN VARCHAR2(80),
+    USER_NAME VARCHAR2(80),
+    TIME_STAMP TIMESTAMP,
+    IPADDRESS VARCHAR2(80),
+    ATTR_NAME VARCHAR2(40),
+    ATTR_VALUE_BEFORE VARCHAR2(80),
+    ATTR_VALUE_AFTER VARCHAR2(80),
+    DESCRIPTION VARCHAR2(128)
+);
+
+
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- USER_ACTIVITY
+-----------------------------------------------------------------------------
+
+CREATE TABLE USER_ACTIVITY
+(
+    ACTIVITY VARCHAR2(40),
+    CATEGORY VARCHAR2(40),
+    USER_NAME VARCHAR2(80),
+    TIME_STAMP TIMESTAMP,
+    IPADDRESS VARCHAR2(80),
+    ATTR_NAME VARCHAR2(40),
+    ATTR_VALUE_BEFORE VARCHAR2(80),
+    ATTR_VALUE_AFTER VARCHAR2(80),
+    DESCRIPTION VARCHAR2(128)
+);
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+

Propchange: geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/oracle/phase1-schema.sql
------------------------------------------------------------------------------
    svn:eol-style = native

Propchange: geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/oracle/phase1-schema.sql
------------------------------------------------------------------------------
    svn:keywords = Date Revision

Propchange: geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/oracle/phase1-schema.sql
------------------------------------------------------------------------------
    svn:mime-type = text/plain

Added: geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/oracle/phase2-schema.sql
URL: http://svn.apache.org/viewvc/geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/oracle/phase2-schema.sql?rev=588248&view=auto
==============================================================================
--- geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/oracle/phase2-schema.sql (added)
+++ geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/oracle/phase2-schema.sql Thu Oct 25 08:16:02 2007
@@ -0,0 +1,1063 @@
+
+-----------------------------------------------------------------------------
+-- FOLDER
+-----------------------------------------------------------------------------
+
+CREATE TABLE FOLDER
+(
+    FOLDER_ID NUMBER(10,0) NOT NULL,
+    PARENT_ID NUMBER(10,0),
+    PATH VARCHAR2(240) NOT NULL,
+    NAME VARCHAR2(80) NOT NULL,
+    TITLE VARCHAR2(100),
+    SHORT_TITLE VARCHAR2(40),
+    IS_HIDDEN NUMBER(1,0) NOT NULL,
+    SKIN VARCHAR2(80),
+    DEFAULT_LAYOUT_DECORATOR VARCHAR2(80),
+    DEFAULT_PORTLET_DECORATOR VARCHAR2(80),
+    DEFAULT_PAGE_NAME VARCHAR2(80),
+    SUBSITE VARCHAR2(40),
+    USER_PRINCIPAL VARCHAR2(40),
+    ROLE_PRINCIPAL VARCHAR2(40),
+    GROUP_PRINCIPAL VARCHAR2(40),
+    MEDIATYPE VARCHAR2(15),
+    LOCALE VARCHAR2(20),
+    EXT_ATTR_NAME VARCHAR2(15),
+    EXT_ATTR_VALUE VARCHAR2(40),
+    OWNER_PRINCIPAL VARCHAR2(40),
+    CONSTRAINT UN_FOLDER_1 UNIQUE (PATH)
+);
+
+ALTER TABLE FOLDER
+    ADD CONSTRAINT FOLDER_PK
+PRIMARY KEY (FOLDER_ID);
+
+CREATE INDEX IX_FOLDER_1 ON FOLDER (PARENT_ID);
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- FOLDER_METADATA
+-----------------------------------------------------------------------------
+
+CREATE TABLE FOLDER_METADATA
+(
+    METADATA_ID NUMBER(10,0) NOT NULL,
+    FOLDER_ID NUMBER(10,0) NOT NULL,
+    NAME VARCHAR2(15) NOT NULL,
+    LOCALE VARCHAR2(20) NOT NULL,
+    VALUE VARCHAR2(100) NOT NULL,
+    CONSTRAINT UN_FOLDER_METADATA_1 UNIQUE (FOLDER_ID, NAME, LOCALE, VALUE)
+);
+
+ALTER TABLE FOLDER_METADATA
+    ADD CONSTRAINT FOLDER_METADATA_PK
+PRIMARY KEY (METADATA_ID);
+
+CREATE INDEX IX_FOLDER_METADATA_1 ON FOLDER_METADATA (FOLDER_ID);
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- FOLDER_CONSTRAINT
+-----------------------------------------------------------------------------
+
+CREATE TABLE FOLDER_CONSTRAINT
+(
+    CONSTRAINT_ID NUMBER(10,0) NOT NULL,
+    FOLDER_ID NUMBER(10,0) NOT NULL,
+    APPLY_ORDER NUMBER(10,0) NOT NULL,
+    USER_PRINCIPALS_ACL VARCHAR2(120),
+    ROLE_PRINCIPALS_ACL VARCHAR2(120),
+    GROUP_PRINCIPALS_ACL VARCHAR2(120),
+    PERMISSIONS_ACL VARCHAR2(120)
+);
+
+ALTER TABLE FOLDER_CONSTRAINT
+    ADD CONSTRAINT FOLDER_CONSTRAINT_PK
+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 NUMBER(10,0) NOT NULL,
+    FOLDER_ID NUMBER(10,0) NOT NULL,
+    APPLY_ORDER NUMBER(10,0) NOT NULL,
+    NAME VARCHAR2(40) NOT NULL,
+    CONSTRAINT UN_FOLDER_CONSTRAINTS_REF_1 UNIQUE (FOLDER_ID, NAME)
+);
+
+ALTER TABLE FOLDER_CONSTRAINTS_REF
+    ADD CONSTRAINT FOLDER_CONSTRAINTS_REF_PK
+PRIMARY KEY (CONSTRAINTS_REF_ID);
+
+CREATE INDEX IX_FOLDER_CONSTRAINTS_REF_1 ON FOLDER_CONSTRAINTS_REF (FOLDER_ID);
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- FOLDER_ORDER
+-----------------------------------------------------------------------------
+
+CREATE TABLE FOLDER_ORDER
+(
+    ORDER_ID NUMBER(10,0) NOT NULL,
+    FOLDER_ID NUMBER(10,0) NOT NULL,
+    SORT_ORDER NUMBER(10,0) NOT NULL,
+    NAME VARCHAR2(80) NOT NULL,
+    CONSTRAINT UN_FOLDER_ORDER_1 UNIQUE (FOLDER_ID, NAME)
+);
+
+ALTER TABLE FOLDER_ORDER
+    ADD CONSTRAINT FOLDER_ORDER_PK
+PRIMARY KEY (ORDER_ID);
+
+CREATE INDEX IX_FOLDER_ORDER_1 ON FOLDER_ORDER (FOLDER_ID);
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- FOLDER_MENU
+-----------------------------------------------------------------------------
+
+CREATE TABLE FOLDER_MENU
+(
+    MENU_ID NUMBER(10,0) NOT NULL,
+    CLASS_NAME VARCHAR2(100) NOT NULL,
+    PARENT_ID NUMBER(10,0),
+    FOLDER_ID NUMBER(10,0),
+    ELEMENT_ORDER NUMBER(10,0),
+    NAME VARCHAR2(100),
+    TITLE VARCHAR2(100),
+    SHORT_TITLE VARCHAR2(40),
+    TEXT VARCHAR2(100),
+    OPTIONS VARCHAR2(255),
+    DEPTH NUMBER(10,0),
+    IS_PATHS NUMBER(1,0),
+    IS_REGEXP NUMBER(1,0),
+    PROFILE VARCHAR2(80),
+    OPTIONS_ORDER VARCHAR2(255),
+    SKIN VARCHAR2(80),
+    IS_NEST NUMBER(1,0)
+);
+
+ALTER TABLE FOLDER_MENU
+    ADD CONSTRAINT FOLDER_MENU_PK
+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 NUMBER(10,0) NOT NULL,
+    MENU_ID NUMBER(10,0) NOT NULL,
+    NAME VARCHAR2(15) NOT NULL,
+    LOCALE VARCHAR2(20) NOT NULL,
+    VALUE VARCHAR2(100) NOT NULL,
+    CONSTRAINT UN_FOLDER_MENU_METADATA_1 UNIQUE (MENU_ID, NAME, LOCALE, VALUE)
+);
+
+ALTER TABLE FOLDER_MENU_METADATA
+    ADD CONSTRAINT FOLDER_MENU_METADATA_PK
+PRIMARY KEY (METADATA_ID);
+
+CREATE INDEX IX_FOLDER_MENU_METADATA_1 ON FOLDER_MENU_METADATA (MENU_ID);
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- PAGE
+-----------------------------------------------------------------------------
+
+CREATE TABLE PAGE
+(
+    PAGE_ID NUMBER(10,0) NOT NULL,
+    PARENT_ID NUMBER(10,0) NOT NULL,
+    PATH VARCHAR2(240) NOT NULL,
+    NAME VARCHAR2(80) NOT NULL,
+    VERSION VARCHAR2(40),
+    TITLE VARCHAR2(100),
+    SHORT_TITLE VARCHAR2(40),
+    IS_HIDDEN NUMBER(1,0) NOT NULL,
+    SKIN VARCHAR2(80),
+    DEFAULT_LAYOUT_DECORATOR VARCHAR2(80),
+    DEFAULT_PORTLET_DECORATOR VARCHAR2(80),
+    SUBSITE VARCHAR2(40),
+    USER_PRINCIPAL VARCHAR2(40),
+    ROLE_PRINCIPAL VARCHAR2(40),
+    GROUP_PRINCIPAL VARCHAR2(40),
+    MEDIATYPE VARCHAR2(15),
+    LOCALE VARCHAR2(20),
+    EXT_ATTR_NAME VARCHAR2(15),
+    EXT_ATTR_VALUE VARCHAR2(40),
+    OWNER_PRINCIPAL VARCHAR2(40),
+    CONSTRAINT UN_PAGE_1 UNIQUE (PATH)
+);
+
+ALTER TABLE PAGE
+    ADD CONSTRAINT PAGE_PK
+PRIMARY KEY (PAGE_ID);
+
+CREATE INDEX IX_PAGE_1 ON PAGE (PARENT_ID);
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- PAGE_METADATA
+-----------------------------------------------------------------------------
+
+CREATE TABLE PAGE_METADATA
+(
+    METADATA_ID NUMBER(10,0) NOT NULL,
+    PAGE_ID NUMBER(10,0) NOT NULL,
+    NAME VARCHAR2(15) NOT NULL,
+    LOCALE VARCHAR2(20) NOT NULL,
+    VALUE VARCHAR2(100) NOT NULL,
+    CONSTRAINT UN_PAGE_METADATA_1 UNIQUE (PAGE_ID, NAME, LOCALE, VALUE)
+);
+
+ALTER TABLE PAGE_METADATA
+    ADD CONSTRAINT PAGE_METADATA_PK
+PRIMARY KEY (METADATA_ID);
+
+CREATE INDEX IX_PAGE_METADATA_1 ON PAGE_METADATA (PAGE_ID);
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- PAGE_CONSTRAINT
+-----------------------------------------------------------------------------
+
+CREATE TABLE PAGE_CONSTRAINT
+(
+    CONSTRAINT_ID NUMBER(10,0) NOT NULL,
+    PAGE_ID NUMBER(10,0) NOT NULL,
+    APPLY_ORDER NUMBER(10,0) NOT NULL,
+    USER_PRINCIPALS_ACL VARCHAR2(120),
+    ROLE_PRINCIPALS_ACL VARCHAR2(120),
+    GROUP_PRINCIPALS_ACL VARCHAR2(120),
+    PERMISSIONS_ACL VARCHAR2(120)
+);
+
+ALTER TABLE PAGE_CONSTRAINT
+    ADD CONSTRAINT PAGE_CONSTRAINT_PK
+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 NUMBER(10,0) NOT NULL,
+    PAGE_ID NUMBER(10,0) NOT NULL,
+    APPLY_ORDER NUMBER(10,0) NOT NULL,
+    NAME VARCHAR2(40) NOT NULL,
+    CONSTRAINT UN_PAGE_CONSTRAINTS_REF_1 UNIQUE (PAGE_ID, NAME)
+);
+
+ALTER TABLE PAGE_CONSTRAINTS_REF
+    ADD CONSTRAINT PAGE_CONSTRAINTS_REF_PK
+PRIMARY KEY (CONSTRAINTS_REF_ID);
+
+CREATE INDEX IX_PAGE_CONSTRAINTS_REF_1 ON PAGE_CONSTRAINTS_REF (PAGE_ID);
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- PAGE_MENU
+-----------------------------------------------------------------------------
+
+CREATE TABLE PAGE_MENU
+(
+    MENU_ID NUMBER(10,0) NOT NULL,
+    CLASS_NAME VARCHAR2(100) NOT NULL,
+    PARENT_ID NUMBER(10,0),
+    PAGE_ID NUMBER(10,0),
+    ELEMENT_ORDER NUMBER(10,0),
+    NAME VARCHAR2(100),
+    TITLE VARCHAR2(100),
+    SHORT_TITLE VARCHAR2(40),
+    TEXT VARCHAR2(100),
+    OPTIONS VARCHAR2(255),
+    DEPTH NUMBER(10,0),
+    IS_PATHS NUMBER(1,0),
+    IS_REGEXP NUMBER(1,0),
+    PROFILE VARCHAR2(80),
+    OPTIONS_ORDER VARCHAR2(255),
+    SKIN VARCHAR2(80),
+    IS_NEST NUMBER(1,0)
+);
+
+ALTER TABLE PAGE_MENU
+    ADD CONSTRAINT PAGE_MENU_PK
+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 NUMBER(10,0) NOT NULL,
+    MENU_ID NUMBER(10,0) NOT NULL,
+    NAME VARCHAR2(15) NOT NULL,
+    LOCALE VARCHAR2(20) NOT NULL,
+    VALUE VARCHAR2(100) NOT NULL,
+    CONSTRAINT UN_PAGE_MENU_METADATA_1 UNIQUE (MENU_ID, NAME, LOCALE, VALUE)
+);
+
+ALTER TABLE PAGE_MENU_METADATA
+    ADD CONSTRAINT PAGE_MENU_METADATA_PK
+PRIMARY KEY (METADATA_ID);
+
+CREATE INDEX IX_PAGE_MENU_METADATA_1 ON PAGE_MENU_METADATA (MENU_ID);
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- FRAGMENT
+-----------------------------------------------------------------------------
+
+CREATE TABLE FRAGMENT
+(
+    FRAGMENT_ID NUMBER(10,0) NOT NULL,
+    PARENT_ID NUMBER(10,0),
+    PAGE_ID NUMBER(10,0),
+    NAME VARCHAR2(100),
+    TITLE VARCHAR2(100),
+    SHORT_TITLE VARCHAR2(40),
+    TYPE VARCHAR2(40),
+    SKIN VARCHAR2(80),
+    DECORATOR VARCHAR2(80),
+    STATE VARCHAR2(10),
+    PMODE VARCHAR2(10),
+    LAYOUT_ROW NUMBER(10,0),
+    LAYOUT_COLUMN NUMBER(10,0),
+    LAYOUT_SIZES VARCHAR2(20),
+    LAYOUT_X NUMBER,
+    LAYOUT_Y NUMBER,
+    LAYOUT_Z NUMBER,
+    LAYOUT_WIDTH NUMBER,
+    LAYOUT_HEIGHT NUMBER,
+    EXT_PROP_NAME_1 VARCHAR2(40),
+    EXT_PROP_VALUE_1 VARCHAR2(80),
+    EXT_PROP_NAME_2 VARCHAR2(40),
+    EXT_PROP_VALUE_2 VARCHAR2(80),
+    OWNER_PRINCIPAL VARCHAR2(40)
+);
+
+ALTER TABLE FRAGMENT
+    ADD CONSTRAINT FRAGMENT_PK
+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 NUMBER(10,0) NOT NULL,
+    FRAGMENT_ID NUMBER(10,0) NOT NULL,
+    APPLY_ORDER NUMBER(10,0) NOT NULL,
+    USER_PRINCIPALS_ACL VARCHAR2(120),
+    ROLE_PRINCIPALS_ACL VARCHAR2(120),
+    GROUP_PRINCIPALS_ACL VARCHAR2(120),
+    PERMISSIONS_ACL VARCHAR2(120)
+);
+
+ALTER TABLE FRAGMENT_CONSTRAINT
+    ADD CONSTRAINT FRAGMENT_CONSTRAINT_PK
+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 NUMBER(10,0) NOT NULL,
+    FRAGMENT_ID NUMBER(10,0) NOT NULL,
+    APPLY_ORDER NUMBER(10,0) NOT NULL,
+    NAME VARCHAR2(40) NOT NULL,
+    CONSTRAINT UN_FRAGMENT_CONSTRAINTS_REF_1 UNIQUE (FRAGMENT_ID, NAME)
+);
+
+ALTER TABLE FRAGMENT_CONSTRAINTS_REF
+    ADD CONSTRAINT FRAGMENT_CONSTRAINTS_REF_PK
+PRIMARY KEY (CONSTRAINTS_REF_ID);
+
+CREATE INDEX IX_FRAGMENT_CONSTRAINTS_REF_1 ON FRAGMENT_CONSTRAINTS_REF (FRAGMENT_ID);
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- FRAGMENT_PREF
+-----------------------------------------------------------------------------
+
+CREATE TABLE FRAGMENT_PREF
+(
+    PREF_ID NUMBER(10,0) NOT NULL,
+    FRAGMENT_ID NUMBER(10,0) NOT NULL,
+    NAME VARCHAR2(40) NOT NULL,
+    IS_READ_ONLY NUMBER(1,0) NOT NULL,
+    CONSTRAINT UN_FRAGMENT_PREF_1 UNIQUE (FRAGMENT_ID, NAME)
+);
+
+ALTER TABLE FRAGMENT_PREF
+    ADD CONSTRAINT FRAGMENT_PREF_PK
+PRIMARY KEY (PREF_ID);
+
+CREATE INDEX IX_FRAGMENT_PREF_1 ON FRAGMENT_PREF (FRAGMENT_ID);
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- FRAGMENT_PREF_VALUE
+-----------------------------------------------------------------------------
+
+CREATE TABLE FRAGMENT_PREF_VALUE
+(
+    PREF_VALUE_ID NUMBER(10,0) NOT NULL,
+    PREF_ID NUMBER(10,0) NOT NULL,
+    VALUE_ORDER NUMBER(10,0) NOT NULL,
+    VALUE VARCHAR2(100) NOT NULL
+);
+
+ALTER TABLE FRAGMENT_PREF_VALUE
+    ADD CONSTRAINT FRAGMENT_PREF_VALUE_PK
+PRIMARY KEY (PREF_VALUE_ID);
+
+CREATE INDEX IX_FRAGMENT_PREF_VALUE_1 ON FRAGMENT_PREF_VALUE (PREF_ID);
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- LINK
+-----------------------------------------------------------------------------
+
+CREATE TABLE LINK
+(
+    LINK_ID NUMBER(10,0) NOT NULL,
+    PARENT_ID NUMBER(10,0) NOT NULL,
+    PATH VARCHAR2(240) NOT NULL,
+    NAME VARCHAR2(80) NOT NULL,
+    VERSION VARCHAR2(40),
+    TITLE VARCHAR2(100),
+    SHORT_TITLE VARCHAR2(40),
+    IS_HIDDEN NUMBER(1,0) NOT NULL,
+    SKIN VARCHAR2(80),
+    TARGET VARCHAR2(80),
+    URL VARCHAR2(255),
+    SUBSITE VARCHAR2(40),
+    USER_PRINCIPAL VARCHAR2(40),
+    ROLE_PRINCIPAL VARCHAR2(40),
+    GROUP_PRINCIPAL VARCHAR2(40),
+    MEDIATYPE VARCHAR2(15),
+    LOCALE VARCHAR2(20),
+    EXT_ATTR_NAME VARCHAR2(15),
+    EXT_ATTR_VALUE VARCHAR2(40),
+    OWNER_PRINCIPAL VARCHAR2(40),
+    CONSTRAINT UN_LINK_1 UNIQUE (PATH)
+);
+
+ALTER TABLE LINK
+    ADD CONSTRAINT LINK_PK
+PRIMARY KEY (LINK_ID);
+
+CREATE INDEX IX_LINK_1 ON LINK (PARENT_ID);
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- LINK_METADATA
+-----------------------------------------------------------------------------
+
+CREATE TABLE LINK_METADATA
+(
+    METADATA_ID NUMBER(10,0) NOT NULL,
+    LINK_ID NUMBER(10,0) NOT NULL,
+    NAME VARCHAR2(15) NOT NULL,
+    LOCALE VARCHAR2(20) NOT NULL,
+    VALUE VARCHAR2(100) NOT NULL,
+    CONSTRAINT UN_LINK_METADATA_1 UNIQUE (LINK_ID, NAME, LOCALE, VALUE)
+);
+
+ALTER TABLE LINK_METADATA
+    ADD CONSTRAINT LINK_METADATA_PK
+PRIMARY KEY (METADATA_ID);
+
+CREATE INDEX IX_LINK_METADATA_1 ON LINK_METADATA (LINK_ID);
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- LINK_CONSTRAINT
+-----------------------------------------------------------------------------
+
+CREATE TABLE LINK_CONSTRAINT
+(
+    CONSTRAINT_ID NUMBER(10,0) NOT NULL,
+    LINK_ID NUMBER(10,0) NOT NULL,
+    APPLY_ORDER NUMBER(10,0) NOT NULL,
+    USER_PRINCIPALS_ACL VARCHAR2(120),
+    ROLE_PRINCIPALS_ACL VARCHAR2(120),
+    GROUP_PRINCIPALS_ACL VARCHAR2(120),
+    PERMISSIONS_ACL VARCHAR2(120)
+);
+
+ALTER TABLE LINK_CONSTRAINT
+    ADD CONSTRAINT LINK_CONSTRAINT_PK
+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 NUMBER(10,0) NOT NULL,
+    LINK_ID NUMBER(10,0) NOT NULL,
+    APPLY_ORDER NUMBER(10,0) NOT NULL,
+    NAME VARCHAR2(40) NOT NULL,
+    CONSTRAINT UN_LINK_CONSTRAINTS_REF_1 UNIQUE (LINK_ID, NAME)
+);
+
+ALTER TABLE LINK_CONSTRAINTS_REF
+    ADD CONSTRAINT LINK_CONSTRAINTS_REF_PK
+PRIMARY KEY (CONSTRAINTS_REF_ID);
+
+CREATE INDEX IX_LINK_CONSTRAINTS_REF_1 ON LINK_CONSTRAINTS_REF (LINK_ID);
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- PAGE_SECURITY
+-----------------------------------------------------------------------------
+
+CREATE TABLE PAGE_SECURITY
+(
+    PAGE_SECURITY_ID NUMBER(10,0) NOT NULL,
+    PARENT_ID NUMBER(10,0) NOT NULL,
+    PATH VARCHAR2(240) NOT NULL,
+    NAME VARCHAR2(80) NOT NULL,
+    VERSION VARCHAR2(40),
+    SUBSITE VARCHAR2(40),
+    USER_PRINCIPAL VARCHAR2(40),
+    ROLE_PRINCIPAL VARCHAR2(40),
+    GROUP_PRINCIPAL VARCHAR2(40),
+    MEDIATYPE VARCHAR2(15),
+    LOCALE VARCHAR2(20),
+    EXT_ATTR_NAME VARCHAR2(15),
+    EXT_ATTR_VALUE VARCHAR2(40),
+    CONSTRAINT UN_PAGE_SECURITY_1 UNIQUE (PARENT_ID),
+    CONSTRAINT UN_PAGE_SECURITY_2 UNIQUE (PATH)
+);
+
+ALTER TABLE PAGE_SECURITY
+    ADD CONSTRAINT PAGE_SECURITY_PK
+PRIMARY KEY (PAGE_SECURITY_ID);
+
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- PAGE_SEC_CONSTRAINTS_DEF
+-----------------------------------------------------------------------------
+
+CREATE TABLE PAGE_SEC_CONSTRAINTS_DEF
+(
+    CONSTRAINTS_DEF_ID NUMBER(10,0) NOT NULL,
+    PAGE_SECURITY_ID NUMBER(10,0) NOT NULL,
+    NAME VARCHAR2(40) NOT NULL,
+    CONSTRAINT UN_PAGE_SEC_CONSTRAINTS_DEF_1 UNIQUE (PAGE_SECURITY_ID, NAME)
+);
+
+ALTER TABLE PAGE_SEC_CONSTRAINTS_DEF
+    ADD CONSTRAINT PAGE_SEC_CONSTRAINTS_DEF_PK
+PRIMARY KEY (CONSTRAINTS_DEF_ID);
+
+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 NUMBER(10,0) NOT NULL,
+    CONSTRAINTS_DEF_ID NUMBER(10,0) NOT NULL,
+    APPLY_ORDER NUMBER(10,0) NOT NULL,
+    USER_PRINCIPALS_ACL VARCHAR2(120),
+    ROLE_PRINCIPALS_ACL VARCHAR2(120),
+    GROUP_PRINCIPALS_ACL VARCHAR2(120),
+    PERMISSIONS_ACL VARCHAR2(120)
+);
+
+ALTER TABLE PAGE_SEC_CONSTRAINT_DEF
+    ADD CONSTRAINT PAGE_SEC_CONSTRAINT_DEF_PK
+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 NUMBER(10,0) NOT NULL,
+    PAGE_SECURITY_ID NUMBER(10,0) NOT NULL,
+    APPLY_ORDER NUMBER(10,0) NOT NULL,
+    NAME VARCHAR2(40) NOT NULL,
+    CONSTRAINT UN_PAGE_SEC_CONSTRAINTS_REF_1 UNIQUE (PAGE_SECURITY_ID, NAME)
+);
+
+ALTER TABLE PAGE_SEC_CONSTRAINTS_REF
+    ADD CONSTRAINT PAGE_SEC_CONSTRAINTS_REF_PK
+PRIMARY KEY (CONSTRAINTS_REF_ID);
+
+CREATE INDEX IX_PAGE_SEC_CONSTRAINTS_REF_1 ON PAGE_SEC_CONSTRAINTS_REF (PAGE_SECURITY_ID);
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- PROFILING_RULE
+-----------------------------------------------------------------------------
+
+CREATE TABLE PROFILING_RULE
+(
+    RULE_ID VARCHAR2(80) NOT NULL,
+    CLASS_NAME VARCHAR2(100) NOT NULL,
+    TITLE VARCHAR2(100)
+);
+
+ALTER TABLE PROFILING_RULE
+    ADD CONSTRAINT PROFILING_RULE_PK
+PRIMARY KEY (RULE_ID);
+
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- RULE_CRITERION
+-----------------------------------------------------------------------------
+
+CREATE TABLE RULE_CRITERION
+(
+    CRITERION_ID VARCHAR2(80) NOT NULL,
+    RULE_ID VARCHAR2(80) NOT NULL,
+    FALLBACK_ORDER NUMBER(10,0) NOT NULL,
+    REQUEST_TYPE VARCHAR2(40) NOT NULL,
+    NAME VARCHAR2(80) NOT NULL,
+    COLUMN_VALUE VARCHAR2(128),
+    FALLBACK_TYPE NUMBER(10,0) default 1
+);
+
+ALTER TABLE RULE_CRITERION
+    ADD CONSTRAINT RULE_CRITERION_PK
+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 VARCHAR2(80) NOT NULL,
+    LOCATOR_NAME VARCHAR2(80) NOT NULL,
+    RULE_ID VARCHAR2(80) NOT NULL
+);
+
+ALTER TABLE PRINCIPAL_RULE_ASSOC
+    ADD CONSTRAINT PRINCIPAL_RULE_ASSOC_PK
+PRIMARY KEY (PRINCIPAL_NAME,LOCATOR_NAME);
+
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- PROFILE_PAGE_ASSOC
+-----------------------------------------------------------------------------
+
+CREATE TABLE PROFILE_PAGE_ASSOC
+(
+    LOCATOR_HASH VARCHAR2(40) NOT NULL,
+    PAGE_ID VARCHAR2(80) NOT NULL,
+    CONSTRAINT UN_PROFILE_PAGE_1 UNIQUE (LOCATOR_HASH, PAGE_ID)
+);
+
+
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- CLUBS
+-----------------------------------------------------------------------------
+
+CREATE TABLE CLUBS
+(
+    NAME VARCHAR2(80) NOT NULL,
+    COUNTRY VARCHAR2(40) NOT NULL,
+    CITY VARCHAR2(40) NOT NULL,
+    STADIUM VARCHAR2(80) NOT NULL,
+    CAPACITY NUMBER(10,0),
+    FOUNDED NUMBER(10,0),
+    PITCH VARCHAR2(40),
+    NICKNAME VARCHAR2(40)
+);
+
+ALTER TABLE CLUBS
+    ADD CONSTRAINT CLUBS_PK
+PRIMARY KEY (NAME);
+
+
+
+
+
+ALTER TABLE FOLDER
+    ADD CONSTRAINT FK_FOLDER_1 FOREIGN KEY (PARENT_ID)
+    REFERENCES FOLDER (FOLDER_ID)
+ON DELETE CASCADE
+;
+
+
+
+ALTER TABLE FOLDER_METADATA
+    ADD CONSTRAINT FK_FOLDER_METADATA_1 FOREIGN KEY (FOLDER_ID)
+    REFERENCES FOLDER (FOLDER_ID)
+ON DELETE CASCADE
+;
+
+
+
+ALTER TABLE FOLDER_CONSTRAINT
+    ADD CONSTRAINT FK_FOLDER_CONSTRAINT_1 FOREIGN KEY (FOLDER_ID)
+    REFERENCES FOLDER (FOLDER_ID)
+ON DELETE CASCADE
+;
+
+
+
+ALTER TABLE FOLDER_CONSTRAINTS_REF
+    ADD CONSTRAINT FK_FOLDER_CONSTRAINTS_REF_1 FOREIGN KEY (FOLDER_ID)
+    REFERENCES FOLDER (FOLDER_ID)
+ON DELETE CASCADE
+;
+
+
+
+ALTER TABLE FOLDER_ORDER
+    ADD CONSTRAINT FK_FOLDER_ORDER_1 FOREIGN KEY (FOLDER_ID)
+    REFERENCES FOLDER (FOLDER_ID)
+ON DELETE CASCADE
+;
+
+
+
+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
+;
+
+
+
+ALTER TABLE FOLDER_MENU_METADATA
+    ADD CONSTRAINT FK_FOLDER_MENU_METADATA_1 FOREIGN KEY (MENU_ID)
+    REFERENCES FOLDER_MENU (MENU_ID)
+ON DELETE CASCADE
+;
+
+
+
+ALTER TABLE PAGE
+    ADD CONSTRAINT FK_PAGE_1 FOREIGN KEY (PARENT_ID)
+    REFERENCES FOLDER (FOLDER_ID)
+ON DELETE CASCADE
+;
+
+
+
+ALTER TABLE PAGE_METADATA
+    ADD CONSTRAINT FK_PAGE_METADATA_1 FOREIGN KEY (PAGE_ID)
+    REFERENCES PAGE (PAGE_ID)
+ON DELETE CASCADE
+;
+
+
+
+ALTER TABLE PAGE_CONSTRAINT
+    ADD CONSTRAINT FK_PAGE_CONSTRAINT_1 FOREIGN KEY (PAGE_ID)
+    REFERENCES PAGE (PAGE_ID)
+ON DELETE CASCADE
+;
+
+
+
+ALTER TABLE PAGE_CONSTRAINTS_REF
+    ADD CONSTRAINT FK_PAGE_CONSTRAINTS_REF_1 FOREIGN KEY (PAGE_ID)
+    REFERENCES PAGE (PAGE_ID)
+ON DELETE CASCADE
+;
+
+
+
+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
+;
+
+
+
+ALTER TABLE PAGE_MENU_METADATA
+    ADD CONSTRAINT FK_PAGE_MENU_METADATA_1 FOREIGN KEY (MENU_ID)
+    REFERENCES PAGE_MENU (MENU_ID)
+ON DELETE CASCADE
+;
+
+
+
+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
+;
+
+
+
+ALTER TABLE FRAGMENT_CONSTRAINT
+    ADD CONSTRAINT FK_FRAGMENT_CONSTRAINT_1 FOREIGN KEY (FRAGMENT_ID)
+    REFERENCES FRAGMENT (FRAGMENT_ID)
+ON DELETE CASCADE
+;
+
+
+
+ALTER TABLE FRAGMENT_CONSTRAINTS_REF
+    ADD CONSTRAINT FK_FRAGMENT_CONSTRAINTS_REF_1 FOREIGN KEY (FRAGMENT_ID)
+    REFERENCES FRAGMENT (FRAGMENT_ID)
+ON DELETE CASCADE
+;
+
+
+
+ALTER TABLE FRAGMENT_PREF
+    ADD CONSTRAINT FK_FRAGMENT_PREF_1 FOREIGN KEY (FRAGMENT_ID)
+    REFERENCES FRAGMENT (FRAGMENT_ID)
+ON DELETE CASCADE
+;
+
+
+
+ALTER TABLE FRAGMENT_PREF_VALUE
+    ADD CONSTRAINT FK_FRAGMENT_PREF_VALUE_1 FOREIGN KEY (PREF_ID)
+    REFERENCES FRAGMENT_PREF (PREF_ID)
+ON DELETE CASCADE
+;
+
+
+
+ALTER TABLE LINK
+    ADD CONSTRAINT FK_LINK_1 FOREIGN KEY (PARENT_ID)
+    REFERENCES FOLDER (FOLDER_ID)
+ON DELETE CASCADE
+;
+
+
+
+ALTER TABLE LINK_METADATA
+    ADD CONSTRAINT FK_LINK_METADATA_1 FOREIGN KEY (LINK_ID)
+    REFERENCES LINK (LINK_ID)
+ON DELETE CASCADE
+;
+
+
+
+ALTER TABLE LINK_CONSTRAINT
+    ADD CONSTRAINT FK_LINK_CONSTRAINT_1 FOREIGN KEY (LINK_ID)
+    REFERENCES LINK (LINK_ID)
+ON DELETE CASCADE
+;
+
+
+
+ALTER TABLE LINK_CONSTRAINTS_REF
+    ADD CONSTRAINT FK_LINK_CONSTRAINTS_REF_1 FOREIGN KEY (LINK_ID)
+    REFERENCES LINK (LINK_ID)
+ON DELETE CASCADE
+;
+
+
+
+ALTER TABLE PAGE_SECURITY
+    ADD CONSTRAINT FK_PAGE_SECURITY_1 FOREIGN KEY (PARENT_ID)
+    REFERENCES FOLDER (FOLDER_ID)
+ON DELETE CASCADE
+;
+
+
+
+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
+;
+
+
+
+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
+;
+
+
+
+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
+;
+
+
+
+
+
+ALTER TABLE RULE_CRITERION
+    ADD CONSTRAINT FK_RULE_CRITERION_1 FOREIGN KEY (RULE_ID)
+    REFERENCES PROFILING_RULE (RULE_ID)
+ON DELETE CASCADE
+;
+
+
+
+
+
+
+
+
+

Propchange: geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/oracle/phase2-schema.sql
------------------------------------------------------------------------------
    svn:eol-style = native

Propchange: geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/oracle/phase2-schema.sql
------------------------------------------------------------------------------
    svn:keywords = Date Revision

Propchange: geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/oracle/phase2-schema.sql
------------------------------------------------------------------------------
    svn:mime-type = text/plain

Added: geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/oracle/phase3ojb-schema.sql
URL: http://svn.apache.org/viewvc/geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/oracle/phase3ojb-schema.sql?rev=588248&view=auto
==============================================================================
--- geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/oracle/phase3ojb-schema.sql (added)
+++ geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/oracle/phase3ojb-schema.sql Thu Oct 25 08:16:02 2007
@@ -0,0 +1,178 @@
+
+-----------------------------------------------------------------------------
+-- OJB_HL_SEQ
+-----------------------------------------------------------------------------
+
+CREATE TABLE OJB_HL_SEQ
+(
+    TABLENAME VARCHAR2(175) NOT NULL,
+    FIELDNAME VARCHAR2(70) NOT NULL,
+    MAX_KEY NUMBER(10,0),
+    GRAB_SIZE NUMBER(10,0),
+    VERSION NUMBER(10,0)
+);
+
+ALTER TABLE OJB_HL_SEQ
+    ADD CONSTRAINT OJB_HL_SEQ_PK
+PRIMARY KEY (TABLENAME,FIELDNAME);
+
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- OJB_LOCKENTRY
+-----------------------------------------------------------------------------
+
+CREATE TABLE OJB_LOCKENTRY
+(
+    OID_ VARCHAR2(250) NOT NULL,
+    TX_ID VARCHAR2(50) NOT NULL,
+    TIMESTAMP_ TIMESTAMP,
+    ISOLATIONLEVEL NUMBER(10,0),
+    LOCKTYPE NUMBER(10,0)
+);
+
+ALTER TABLE OJB_LOCKENTRY
+    ADD CONSTRAINT OJB_LOCKENTRY_PK
+PRIMARY KEY (OID_,TX_ID);
+
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- OJB_NRM
+-----------------------------------------------------------------------------
+
+CREATE TABLE OJB_NRM
+(
+    NAME VARCHAR2(250) NOT NULL,
+    OID_ LONG RAW
+);
+
+ALTER TABLE OJB_NRM
+    ADD CONSTRAINT OJB_NRM_PK
+PRIMARY KEY (NAME);
+
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- OJB_DLIST
+-----------------------------------------------------------------------------
+
+CREATE TABLE OJB_DLIST
+(
+    ID NUMBER(10,0) NOT NULL,
+    SIZE_ NUMBER(10,0)
+);
+
+ALTER TABLE OJB_DLIST
+    ADD CONSTRAINT OJB_DLIST_PK
+PRIMARY KEY (ID);
+
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- OJB_DLIST_ENTRIES
+-----------------------------------------------------------------------------
+
+CREATE TABLE OJB_DLIST_ENTRIES
+(
+    ID NUMBER(10,0) NOT NULL,
+    DLIST_ID NUMBER(10,0),
+    POSITION_ NUMBER(10,0),
+    OID_ LONG RAW
+);
+
+ALTER TABLE OJB_DLIST_ENTRIES
+    ADD CONSTRAINT OJB_DLIST_ENTRIES_PK
+PRIMARY KEY (ID);
+
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- OJB_DSET
+-----------------------------------------------------------------------------
+
+CREATE TABLE OJB_DSET
+(
+    ID NUMBER(10,0) NOT NULL,
+    SIZE_ NUMBER(10,0)
+);
+
+ALTER TABLE OJB_DSET
+    ADD CONSTRAINT OJB_DSET_PK
+PRIMARY KEY (ID);
+
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- OJB_DSET_ENTRIES
+-----------------------------------------------------------------------------
+
+CREATE TABLE OJB_DSET_ENTRIES
+(
+    ID NUMBER(10,0) NOT NULL,
+    DLIST_ID NUMBER(10,0),
+    POSITION_ NUMBER(10,0),
+    OID_ LONG RAW
+);
+
+ALTER TABLE OJB_DSET_ENTRIES
+    ADD CONSTRAINT OJB_DSET_ENTRIES_PK
+PRIMARY KEY (ID);
+
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- OJB_DMAP
+-----------------------------------------------------------------------------
+
+CREATE TABLE OJB_DMAP
+(
+    ID NUMBER(10,0) NOT NULL,
+    SIZE_ NUMBER(10,0)
+);
+
+ALTER TABLE OJB_DMAP
+    ADD CONSTRAINT OJB_DMAP_PK
+PRIMARY KEY (ID);
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+

Propchange: geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/oracle/phase3ojb-schema.sql
------------------------------------------------------------------------------
    svn:eol-style = native

Propchange: geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/oracle/phase3ojb-schema.sql
------------------------------------------------------------------------------
    svn:keywords = Date Revision

Propchange: geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/oracle/phase3ojb-schema.sql
------------------------------------------------------------------------------
    svn:mime-type = text/plain

Added: geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/oracle/prefs-schema.sql
URL: http://svn.apache.org/viewvc/geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/oracle/prefs-schema.sql?rev=588248&view=auto
==============================================================================
--- geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/oracle/prefs-schema.sql (added)
+++ geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/oracle/prefs-schema.sql Thu Oct 25 08:16:02 2007
@@ -0,0 +1,56 @@
+
+-----------------------------------------------------------------------------
+-- PREFS_PROPERTY_VALUE
+-----------------------------------------------------------------------------
+
+CREATE TABLE PREFS_PROPERTY_VALUE
+(
+    PROPERTY_VALUE_ID NUMBER(10,0) NOT NULL,
+    NODE_ID NUMBER(10,0),
+    PROPERTY_NAME VARCHAR2(100),
+    PROPERTY_VALUE VARCHAR2(254),
+    CREATION_DATE TIMESTAMP,
+    MODIFIED_DATE TIMESTAMP
+);
+
+ALTER TABLE PREFS_PROPERTY_VALUE
+    ADD CONSTRAINT PREFS_PROPERTY_VALUE_PK
+PRIMARY KEY (PROPERTY_VALUE_ID);
+
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- PREFS_NODE
+-----------------------------------------------------------------------------
+
+CREATE TABLE PREFS_NODE
+(
+    NODE_ID NUMBER(10,0) NOT NULL,
+    PARENT_NODE_ID NUMBER(10,0),
+    NODE_NAME VARCHAR2(100),
+    NODE_TYPE NUMBER(5,0),
+    FULL_PATH VARCHAR2(254),
+    CREATION_DATE TIMESTAMP,
+    MODIFIED_DATE TIMESTAMP
+);
+
+ALTER TABLE PREFS_NODE
+    ADD CONSTRAINT PREFS_NODE_PK
+PRIMARY KEY (NODE_ID);
+
+
+
+
+
+
+
+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/oracle/prefs-schema.sql
------------------------------------------------------------------------------
    svn:eol-style = native

Propchange: geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/oracle/prefs-schema.sql
------------------------------------------------------------------------------
    svn:keywords = Date Revision

Propchange: geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/oracle/prefs-schema.sql
------------------------------------------------------------------------------
    svn:mime-type = text/plain



Mime
View raw message