geronimo-scm mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From pra...@apache.org
Subject svn commit: r588248 [1/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
Author: prasad
Date: Thu Oct 25 08:16:02 2007
New Revision: 588248

URL: http://svn.apache.org/viewvc?rev=588248&view=rev
Log:
* added a new module called jetspeed-database to hold sql scripts for all DBs

Added:
    geronimo/sandbox/jetspeed-integration/jetspeed-database/
    geronimo/sandbox/jetspeed-integration/jetspeed-database/LICENSE.txt   (with props)
    geronimo/sandbox/jetspeed-integration/jetspeed-database/NOTICE.txt   (with props)
    geronimo/sandbox/jetspeed-integration/jetspeed-database/pom.xml   (with props)
    geronimo/sandbox/jetspeed-integration/jetspeed-database/src/
    geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/
    geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/
    geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/db2/
    geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/db2/phase1-schema.sql   (with props)
    geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/db2/phase2-schema.sql   (with props)
    geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/db2/phase3ojb-schema.sql   (with props)
    geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/db2/prefs-schema.sql   (with props)
    geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/db2/registry-schema.sql   (with props)
    geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/db2/security-schema.sql   (with props)
    geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/derby/
    geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/derby/phase1-schema.sql   (with props)
    geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/derby/phase2-schema.sql   (with props)
    geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/derby/phase3ojb-schema.sql   (with props)
    geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/derby/prefs-schema.sql   (with props)
    geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/derby/registry-schema.sql   (with props)
    geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/derby/security-schema.sql   (with props)
    geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/mssql/
    geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/mssql/phase1-schema.sql   (with props)
    geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/mssql/phase2-schema.sql   (with props)
    geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/mssql/phase3ojb-schema.sql   (with props)
    geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/mssql/prefs-schema.sql   (with props)
    geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/mssql/registry-schema.sql   (with props)
    geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/mssql/security-schema.sql   (with props)
    geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/mysql/
    geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/mysql/phase1-schema.sql   (with props)
    geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/mysql/phase2-schema.sql   (with props)
    geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/mysql/phase3ojb-schema.sql   (with props)
    geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/mysql/prefs-schema.sql   (with props)
    geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/mysql/registry-schema.sql   (with props)
    geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/mysql/security-schema.sql   (with props)
    geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/oracle/
    geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/oracle/phase1-schema.sql   (with props)
    geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/oracle/phase2-schema.sql   (with props)
    geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/oracle/phase3ojb-schema.sql   (with props)
    geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/oracle/prefs-schema.sql   (with props)
    geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/oracle/registry-schema.sql   (with props)
    geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/oracle/security-schema.sql   (with props)
    geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/postgres/
    geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/postgres/phase1-schema.sql   (with props)
    geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/postgres/phase2-schema.sql   (with props)
    geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/postgres/phase3ojb-schema.sql   (with props)
    geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/postgres/prefs-schema.sql   (with props)
    geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/postgres/registry-schema.sql   (with props)
    geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/postgres/security-schema.sql   (with props)
    geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/sapdb/
    geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/sapdb/phase1-schema.sql   (with props)
    geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/sapdb/phase2-schema.sql   (with props)
    geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/sapdb/phase3ojb-schema.sql   (with props)
    geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/sapdb/prefs-schema.sql   (with props)
    geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/sapdb/registry-schema.sql   (with props)
    geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/sapdb/security-schema.sql   (with props)
Removed:
    geronimo/sandbox/jetspeed-integration/jetspeed-base/src/main/sql/
Modified:
    geronimo/sandbox/jetspeed-integration/jetspeed-base/pom.xml
    geronimo/sandbox/jetspeed-integration/jetspeed-derby-database/pom.xml
    geronimo/sandbox/jetspeed-integration/jetspeed-derby-database/src/main/plan/plan.xml
    geronimo/sandbox/jetspeed-integration/pom.xml

Modified: geronimo/sandbox/jetspeed-integration/jetspeed-base/pom.xml
URL: http://svn.apache.org/viewvc/geronimo/sandbox/jetspeed-integration/jetspeed-base/pom.xml?rev=588248&r1=588247&r2=588248&view=diff
==============================================================================
--- geronimo/sandbox/jetspeed-integration/jetspeed-base/pom.xml (original)
+++ geronimo/sandbox/jetspeed-integration/jetspeed-base/pom.xml Thu Oct 25 08:16:02 2007
@@ -15,66 +15,59 @@
     See the License for the specific language governing permissions and
     limitations under the License.
 -->
-
 <!-- $Rev$ $Date$ -->
-
 <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">
-
     <modelVersion>4.0.0</modelVersion>
-
     <parent>
         <groupId>org.apache.geronimo.configs</groupId>
         <artifactId>configs</artifactId>
         <version>2.1-SNAPSHOT</version>
     </parent>
-
     <artifactId>jetspeed-base</artifactId>
     <name>Geronimo Configs :: Jetspeed Base Configuration</name>
     <packaging>car</packaging>
-
-     <description>
+    <description>
        This configuration carries Jetspeed's common jars that are shared by all its portlet apps.
-     </description> 
-
-     <properties>
-       <jetspeedVersion>2.0</jetspeedVersion>
-     </properties>
+    </description>
+    <properties>
+        <jetspeedVersion>2.0</jetspeedVersion>
+    </properties>
     
     <dependencies>
-        
+        <dependency>
+            <groupId>org.apache.geronimo.modules</groupId>
+            <artifactId>jetspeed-database</artifactId>
+            <version>${version}</version>
+            <type>jar</type>
+        </dependency>
         <dependency>
             <groupId>org.apache.portals.jetspeed-2</groupId>
             <artifactId>jetspeed-api</artifactId>
             <version>${jetspeedVersion}</version>
             <type>jar</type>
         </dependency>
-
         <dependency>
             <groupId>org.apache.portals.jetspeed-2</groupId>
             <artifactId>jetspeed-commons</artifactId>
             <version>${jetspeedVersion}</version>
             <type>jar</type>
         </dependency>
-
         <dependency>
             <groupId>org.apache.pluto</groupId>
             <artifactId>pluto</artifactId>
             <version>1.0.1</version>
             <type>jar</type>
         </dependency>
-
         <dependency>
             <groupId>javax.portlet</groupId>
             <artifactId>portlet-api</artifactId>
         </dependency>
-
         <dependency>
             <groupId>org.apache.portals.bridges</groupId>
             <artifactId>portals-bridges-common</artifactId>
             <version>1.0.3</version>
             <type>jar</type>
         </dependency>
-
         <dependency>
             <groupId>org.apache.geronimo.configs</groupId>
             <artifactId>system-database</artifactId>
@@ -84,17 +77,6 @@
     </dependencies>
     
     <build>
-        <resources>
-            <resource>
-                <targetPath>META-INF/sql</targetPath>
-                <directory>${pom.basedir}/src/main/sql</directory>
-                <filtering>true</filtering>
-                <includes>
-                  <include>*.sql</include>
-                </includes>
-            </resource>
-        </resources>
-        
         <plugins>
             <plugin>
                 <groupId>org.apache.geronimo.plugins</groupId>

Added: geronimo/sandbox/jetspeed-integration/jetspeed-database/LICENSE.txt
URL: http://svn.apache.org/viewvc/geronimo/sandbox/jetspeed-integration/jetspeed-database/LICENSE.txt?rev=588248&view=auto
==============================================================================
--- geronimo/sandbox/jetspeed-integration/jetspeed-database/LICENSE.txt (added)
+++ geronimo/sandbox/jetspeed-integration/jetspeed-database/LICENSE.txt Thu Oct 25 08:16:02 2007
@@ -0,0 +1,203 @@
+
+                                 Apache License
+                           Version 2.0, January 2004
+                        http://www.apache.org/licenses/
+
+   TERMS AND CONDITIONS FOR USE, REPRODUCTION, AND DISTRIBUTION
+
+   1. Definitions.
+
+      "License" shall mean the terms and conditions for use, reproduction,
+      and distribution as defined by Sections 1 through 9 of this document.
+
+      "Licensor" shall mean the copyright owner or entity authorized by
+      the copyright owner that is granting the License.
+
+      "Legal Entity" shall mean the union of the acting entity and all
+      other entities that control, are controlled by, or are under common
+      control with that entity. For the purposes of this definition,
+      "control" means (i) the power, direct or indirect, to cause the
+      direction or management of such entity, whether by contract or
+      otherwise, or (ii) ownership of fifty percent (50%) or more of the
+      outstanding shares, or (iii) beneficial ownership of such entity.
+
+      "You" (or "Your") shall mean an individual or Legal Entity
+      exercising permissions granted by this License.
+
+      "Source" form shall mean the preferred form for making modifications,
+      including but not limited to software source code, documentation
+      source, and configuration files.
+
+      "Object" form shall mean any form resulting from mechanical
+      transformation or translation of a Source form, including but
+      not limited to compiled object code, generated documentation,
+      and conversions to other media types.
+
+      "Work" shall mean the work of authorship, whether in Source or
+      Object form, made available under the License, as indicated by a
+      copyright notice that is included in or attached to the work
+      (an example is provided in the Appendix below).
+
+      "Derivative Works" shall mean any work, whether in Source or Object
+      form, that is based on (or derived from) the Work and for which the
+      editorial revisions, annotations, elaborations, or other modifications
+      represent, as a whole, an original work of authorship. For the purposes
+      of this License, Derivative Works shall not include works that remain
+      separable from, or merely link (or bind by name) to the interfaces of,
+      the Work and Derivative Works thereof.
+
+      "Contribution" shall mean any work of authorship, including
+      the original version of the Work and any modifications or additions
+      to that Work or Derivative Works thereof, that is intentionally
+      submitted to Licensor for inclusion in the Work by the copyright owner
+      or by an individual or Legal Entity authorized to submit on behalf of
+      the copyright owner. For the purposes of this definition, "submitted"
+      means any form of electronic, verbal, or written communication sent
+      to the Licensor or its representatives, including but not limited to
+      communication on electronic mailing lists, source code control systems,
+      and issue tracking systems that are managed by, or on behalf of, the
+      Licensor for the purpose of discussing and improving the Work, but
+      excluding communication that is conspicuously marked or otherwise
+      designated in writing by the copyright owner as "Not a Contribution."
+
+      "Contributor" shall mean Licensor and any individual or Legal Entity
+      on behalf of whom a Contribution has been received by Licensor and
+      subsequently incorporated within the Work.
+
+   2. Grant of Copyright License. Subject to the terms and conditions of
+      this License, each Contributor hereby grants to You a perpetual,
+      worldwide, non-exclusive, no-charge, royalty-free, irrevocable
+      copyright license to reproduce, prepare Derivative Works of,
+      publicly display, publicly perform, sublicense, and distribute the
+      Work and such Derivative Works in Source or Object form.
+
+   3. Grant of Patent License. Subject to the terms and conditions of
+      this License, each Contributor hereby grants to You a perpetual,
+      worldwide, non-exclusive, no-charge, royalty-free, irrevocable
+      (except as stated in this section) patent license to make, have made,
+      use, offer to sell, sell, import, and otherwise transfer the Work,
+      where such license applies only to those patent claims licensable
+      by such Contributor that are necessarily infringed by their
+      Contribution(s) alone or by combination of their Contribution(s)
+      with the Work to which such Contribution(s) was submitted. If You
+      institute patent litigation against any entity (including a
+      cross-claim or counterclaim in a lawsuit) alleging that the Work
+      or a Contribution incorporated within the Work constitutes direct
+      or contributory patent infringement, then any patent licenses
+      granted to You under this License for that Work shall terminate
+      as of the date such litigation is filed.
+
+   4. Redistribution. You may reproduce and distribute copies of the
+      Work or Derivative Works thereof in any medium, with or without
+      modifications, and in Source or Object form, provided that You
+      meet the following conditions:
+
+      (a) You must give any other recipients of the Work or
+          Derivative Works a copy of this License; and
+
+      (b) You must cause any modified files to carry prominent notices
+          stating that You changed the files; and
+
+      (c) You must retain, in the Source form of any Derivative Works
+          that You distribute, all copyright, patent, trademark, and
+          attribution notices from the Source form of the Work,
+          excluding those notices that do not pertain to any part of
+          the Derivative Works; and
+
+      (d) If the Work includes a "NOTICE" text file as part of its
+          distribution, then any Derivative Works that You distribute must
+          include a readable copy of the attribution notices contained
+          within such NOTICE file, excluding those notices that do not
+          pertain to any part of the Derivative Works, in at least one
+          of the following places: within a NOTICE text file distributed
+          as part of the Derivative Works; within the Source form or
+          documentation, if provided along with the Derivative Works; or,
+          within a display generated by the Derivative Works, if and
+          wherever such third-party notices normally appear. The contents
+          of the NOTICE file are for informational purposes only and
+          do not modify the License. You may add Your own attribution
+          notices within Derivative Works that You distribute, alongside
+          or as an addendum to the NOTICE text from the Work, provided
+          that such additional attribution notices cannot be construed
+          as modifying the License.
+
+      You may add Your own copyright statement to Your modifications and
+      may provide additional or different license terms and conditions
+      for use, reproduction, or distribution of Your modifications, or
+      for any such Derivative Works as a whole, provided Your use,
+      reproduction, and distribution of the Work otherwise complies with
+      the conditions stated in this License.
+
+   5. Submission of Contributions. Unless You explicitly state otherwise,
+      any Contribution intentionally submitted for inclusion in the Work
+      by You to the Licensor shall be under the terms and conditions of
+      this License, without any additional terms or conditions.
+      Notwithstanding the above, nothing herein shall supersede or modify
+      the terms of any separate license agreement you may have executed
+      with Licensor regarding such Contributions.
+
+   6. Trademarks. This License does not grant permission to use the trade
+      names, trademarks, service marks, or product names of the Licensor,
+      except as required for reasonable and customary use in describing the
+      origin of the Work and reproducing the content of the NOTICE file.
+
+   7. Disclaimer of Warranty. Unless required by applicable law or
+      agreed to in writing, Licensor provides the Work (and each
+      Contributor provides its Contributions) on an "AS IS" BASIS,
+      WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or
+      implied, including, without limitation, any warranties or conditions
+      of TITLE, NON-INFRINGEMENT, MERCHANTABILITY, or FITNESS FOR A
+      PARTICULAR PURPOSE. You are solely responsible for determining the
+      appropriateness of using or redistributing the Work and assume any
+      risks associated with Your exercise of permissions under this License.
+
+   8. Limitation of Liability. In no event and under no legal theory,
+      whether in tort (including negligence), contract, or otherwise,
+      unless required by applicable law (such as deliberate and grossly
+      negligent acts) or agreed to in writing, shall any Contributor be
+      liable to You for damages, including any direct, indirect, special,
+      incidental, or consequential damages of any character arising as a
+      result of this License or out of the use or inability to use the
+      Work (including but not limited to damages for loss of goodwill,
+      work stoppage, computer failure or malfunction, or any and all
+      other commercial damages or losses), even if such Contributor
+      has been advised of the possibility of such damages.
+
+   9. Accepting Warranty or Additional Liability. While redistributing
+      the Work or Derivative Works thereof, You may choose to offer,
+      and charge a fee for, acceptance of support, warranty, indemnity,
+      or other liability obligations and/or rights consistent with this
+      License. However, in accepting such obligations, You may act only
+      on Your own behalf and on Your sole responsibility, not on behalf
+      of any other Contributor, and only if You agree to indemnify,
+      defend, and hold each Contributor harmless for any liability
+      incurred by, or claims asserted against, such Contributor by reason
+      of your accepting any such warranty or additional liability.
+
+   END OF TERMS AND CONDITIONS
+
+   APPENDIX: How to apply the Apache License to your work.
+
+      To apply the Apache License to your work, attach the following
+      boilerplate notice, with the fields enclosed by brackets "[]"
+      replaced with your own identifying information. (Don't include
+      the brackets!)  The text should be enclosed in the appropriate
+      comment syntax for the file format. We also recommend that a
+      file or class name and description of purpose be included on the
+      same "printed page" as the copyright notice for easier
+      identification within third-party archives.
+
+   Copyright [yyyy] [name of copyright owner]
+
+   Licensed under the Apache License, Version 2.0 (the "License");
+   you may not use this file except in compliance with the License.
+   You may obtain a copy of the License at
+
+       http://www.apache.org/licenses/LICENSE-2.0
+
+   Unless required by applicable law or agreed to in writing, software
+   distributed under the License is distributed on an "AS IS" BASIS,
+   WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+   See the License for the specific language governing permissions and
+   limitations under the License.
+

Propchange: geronimo/sandbox/jetspeed-integration/jetspeed-database/LICENSE.txt
------------------------------------------------------------------------------
    svn:eol-style = native

Propchange: geronimo/sandbox/jetspeed-integration/jetspeed-database/LICENSE.txt
------------------------------------------------------------------------------
    svn:keywords = Date Revision

Propchange: geronimo/sandbox/jetspeed-integration/jetspeed-database/LICENSE.txt
------------------------------------------------------------------------------
    svn:mime-type = text/plain

Added: geronimo/sandbox/jetspeed-integration/jetspeed-database/NOTICE.txt
URL: http://svn.apache.org/viewvc/geronimo/sandbox/jetspeed-integration/jetspeed-database/NOTICE.txt?rev=588248&view=auto
==============================================================================
--- geronimo/sandbox/jetspeed-integration/jetspeed-database/NOTICE.txt (added)
+++ geronimo/sandbox/jetspeed-integration/jetspeed-database/NOTICE.txt Thu Oct 25 08:16:02 2007
@@ -0,0 +1,6 @@
+Apache Geronimo 
+Copyright 2003-2007 The Apache Software Foundation
+
+This product includes software developed by
+The Apache Software Foundation (http://www.apache.org/).
+

Propchange: geronimo/sandbox/jetspeed-integration/jetspeed-database/NOTICE.txt
------------------------------------------------------------------------------
    svn:eol-style = native

Propchange: geronimo/sandbox/jetspeed-integration/jetspeed-database/NOTICE.txt
------------------------------------------------------------------------------
    svn:keywords = Date Revision

Propchange: geronimo/sandbox/jetspeed-integration/jetspeed-database/NOTICE.txt
------------------------------------------------------------------------------
    svn:mime-type = text/plain

Added: geronimo/sandbox/jetspeed-integration/jetspeed-database/pom.xml
URL: http://svn.apache.org/viewvc/geronimo/sandbox/jetspeed-integration/jetspeed-database/pom.xml?rev=588248&view=auto
==============================================================================
--- geronimo/sandbox/jetspeed-integration/jetspeed-database/pom.xml (added)
+++ geronimo/sandbox/jetspeed-integration/jetspeed-database/pom.xml Thu Oct 25 08:16:02 2007
@@ -0,0 +1,53 @@
+<?xml version="1.0" encoding="ISO-8859-1"?>
+<!--
+    Licensed to the Apache Software Foundation (ASF) under one or more
+    contributor license agreements.  See the NOTICE file distributed with
+    this work for additional information regarding copyright ownership.
+    The ASF licenses this file to You under the Apache License, Version 2.0
+    (the "License"); you may not use this file except in compliance with
+    the License.  You may obtain a copy of the License at
+
+       http://www.apache.org/licenses/LICENSE-2.0
+
+    Unless required by applicable law or agreed to in writing, software
+    distributed under the License is distributed on an "AS IS" BASIS,
+    WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+    See the License for the specific language governing permissions and
+    limitations under the License.
+-->
+
+<!-- $Rev$ $Date$ -->
+
+<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">
+
+    <modelVersion>4.0.0</modelVersion>
+
+    <parent>
+        <groupId>org.apache.geronimo.modules</groupId>
+        <artifactId>modules</artifactId>
+        <version>2.1-SNAPSHOT</version>
+    </parent>
+
+    <artifactId>jetspeed-database</artifactId>
+    <name>Geronimo Modules :: Jetspeed Database Module</name>
+    <packaging>jar</packaging>
+
+     <description>
+       This module carries Jetspeed's SQL scripts for all databases.
+     </description> 
+
+     <properties>
+       <jetspeedVersion>2.0</jetspeedVersion>
+     </properties>
+    
+    <build>
+        <resources>
+            <resource>
+                <directory>${pom.basedir}/src/main</directory>
+                <targetPath>META-INF</targetPath>
+                <filtering>true</filtering>
+            </resource>
+        </resources>
+    </build>
+        
+</project>

Propchange: geronimo/sandbox/jetspeed-integration/jetspeed-database/pom.xml
------------------------------------------------------------------------------
    svn:eol-style = native

Propchange: geronimo/sandbox/jetspeed-integration/jetspeed-database/pom.xml
------------------------------------------------------------------------------
    svn:keywords = Date Revision

Propchange: geronimo/sandbox/jetspeed-integration/jetspeed-database/pom.xml
------------------------------------------------------------------------------
    svn:mime-type = text/xml

Added: geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/db2/phase1-schema.sql
URL: http://svn.apache.org/viewvc/geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/db2/phase1-schema.sql?rev=588248&view=auto
==============================================================================
--- geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/db2/phase1-schema.sql (added)
+++ geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/db2/phase1-schema.sql Thu Oct 25 08:16:02 2007
@@ -0,0 +1,330 @@
+
+-----------------------------------------------------------------------------
+-- 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
+);
+
+ALTER TABLE MEDIA_TYPE
+    ADD 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
+);
+
+ALTER TABLE CLIENT
+    ADD PRIMARY KEY (CLIENT_ID);
+
+
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- MIMETYPE
+-----------------------------------------------------------------------------
+
+CREATE TABLE MIMETYPE
+(
+                    MIMETYPE_ID INTEGER NOT NULL,
+                NAME VARCHAR (80) NOT NULL
+);
+
+ALTER TABLE MIMETYPE
+    ADD PRIMARY KEY (MIMETYPE_ID);
+
+
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- CAPABILITY
+-----------------------------------------------------------------------------
+
+CREATE TABLE CAPABILITY
+(
+                    CAPABILITY_ID INTEGER NOT NULL,
+                CAPABILITY VARCHAR (80) NOT NULL
+);
+
+ALTER TABLE CAPABILITY
+    ADD PRIMARY KEY (CAPABILITY_ID);
+
+
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- CLIENT_TO_CAPABILITY
+-----------------------------------------------------------------------------
+
+CREATE TABLE CLIENT_TO_CAPABILITY
+(
+                    CLIENT_ID INTEGER NOT NULL,
+                    CAPABILITY_ID INTEGER NOT NULL
+);
+
+
+
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- CLIENT_TO_MIMETYPE
+-----------------------------------------------------------------------------
+
+CREATE TABLE CLIENT_TO_MIMETYPE
+(
+                    CLIENT_ID INTEGER NOT NULL,
+                    MIMETYPE_ID INTEGER NOT NULL
+);
+
+
+
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- MEDIATYPE_TO_CAPABILITY
+-----------------------------------------------------------------------------
+
+CREATE TABLE MEDIATYPE_TO_CAPABILITY
+(
+                    MEDIATYPE_ID INTEGER NOT NULL,
+                    CAPABILITY_ID INTEGER NOT NULL
+);
+
+
+
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- MEDIATYPE_TO_MIMETYPE
+-----------------------------------------------------------------------------
+
+CREATE TABLE MEDIATYPE_TO_MIMETYPE
+(
+                    MEDIATYPE_ID INTEGER NOT NULL,
+                    MIMETYPE_ID INTEGER NOT NULL
+);
+
+
+
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- PORTLET_STATISTICS
+-----------------------------------------------------------------------------
+
+CREATE TABLE PORTLET_STATISTICS
+(
+                IPADDRESS VARCHAR (80),
+                USER_NAME VARCHAR (80),
+                TIME_STAMP TIMESTAMP,
+                PAGE VARCHAR (80),
+                PORTLET VARCHAR (255),
+                    STATUS INTEGER,
+                ELAPSED_TIME BIGINT
+);
+
+
+
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- PAGE_STATISTICS
+-----------------------------------------------------------------------------
+
+CREATE TABLE PAGE_STATISTICS
+(
+                IPADDRESS VARCHAR (80),
+                USER_NAME VARCHAR (80),
+                TIME_STAMP TIMESTAMP,
+                PAGE VARCHAR (80),
+                    STATUS INTEGER,
+                ELAPSED_TIME BIGINT
+);
+
+
+
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- USER_STATISTICS
+-----------------------------------------------------------------------------
+
+CREATE TABLE USER_STATISTICS
+(
+                IPADDRESS VARCHAR (80),
+                USER_NAME VARCHAR (80),
+                TIME_STAMP TIMESTAMP,
+                    STATUS INTEGER,
+                ELAPSED_TIME BIGINT
+);
+
+
+
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- ADMIN_ACTIVITY
+-----------------------------------------------------------------------------
+
+CREATE TABLE ADMIN_ACTIVITY
+(
+                ACTIVITY VARCHAR (40),
+                CATEGORY VARCHAR (40),
+                ADMIN VARCHAR (80),
+                USER_NAME VARCHAR (80),
+                TIME_STAMP TIMESTAMP,
+                IPADDRESS VARCHAR (80),
+                ATTR_NAME VARCHAR (40),
+                ATTR_VALUE_BEFORE VARCHAR (80),
+                ATTR_VALUE_AFTER VARCHAR (80),
+                DESCRIPTION VARCHAR (128)
+);
+
+
+
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- USER_ACTIVITY
+-----------------------------------------------------------------------------
+
+CREATE TABLE USER_ACTIVITY
+(
+                ACTIVITY VARCHAR (40),
+                CATEGORY VARCHAR (40),
+                USER_NAME VARCHAR (80),
+                TIME_STAMP TIMESTAMP,
+                IPADDRESS VARCHAR (80),
+                ATTR_NAME VARCHAR (40),
+                ATTR_VALUE_BEFORE VARCHAR (80),
+                ATTR_VALUE_AFTER VARCHAR (80),
+                DESCRIPTION VARCHAR (128)
+);
+
+
+
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- MEDIA_TYPE: FOREIGN KEYS
+-----------------------------------------------------------------------------
+
+
+-----------------------------------------------------------------------------
+-- CLIENT: FOREIGN KEYS
+-----------------------------------------------------------------------------
+
+
+-----------------------------------------------------------------------------
+-- MIMETYPE: FOREIGN KEYS
+-----------------------------------------------------------------------------
+
+
+-----------------------------------------------------------------------------
+-- CAPABILITY: FOREIGN KEYS
+-----------------------------------------------------------------------------
+
+
+-----------------------------------------------------------------------------
+-- CLIENT_TO_CAPABILITY: FOREIGN KEYS
+-----------------------------------------------------------------------------
+
+
+-----------------------------------------------------------------------------
+-- CLIENT_TO_MIMETYPE: FOREIGN KEYS
+-----------------------------------------------------------------------------
+
+
+-----------------------------------------------------------------------------
+-- MEDIATYPE_TO_CAPABILITY: FOREIGN KEYS
+-----------------------------------------------------------------------------
+
+
+-----------------------------------------------------------------------------
+-- MEDIATYPE_TO_MIMETYPE: FOREIGN KEYS
+-----------------------------------------------------------------------------
+
+
+-----------------------------------------------------------------------------
+-- PORTLET_STATISTICS: FOREIGN KEYS
+-----------------------------------------------------------------------------
+
+
+-----------------------------------------------------------------------------
+-- PAGE_STATISTICS: FOREIGN KEYS
+-----------------------------------------------------------------------------
+
+
+-----------------------------------------------------------------------------
+-- USER_STATISTICS: FOREIGN KEYS
+-----------------------------------------------------------------------------
+
+
+-----------------------------------------------------------------------------
+-- ADMIN_ACTIVITY: FOREIGN KEYS
+-----------------------------------------------------------------------------
+
+
+-----------------------------------------------------------------------------
+-- USER_ACTIVITY: FOREIGN KEYS
+-----------------------------------------------------------------------------
+

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

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

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

Added: geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/db2/phase2-schema.sql
URL: http://svn.apache.org/viewvc/geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/db2/phase2-schema.sql?rev=588248&view=auto
==============================================================================
--- geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/db2/phase2-schema.sql (added)
+++ geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/db2/phase2-schema.sql Thu Oct 25 08:16:02 2007
@@ -0,0 +1,1127 @@
+
+-----------------------------------------------------------------------------
+-- 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,
+                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),
+    UNIQUE (PATH)
+);
+
+ALTER TABLE FOLDER
+    ADD PRIMARY KEY (FOLDER_ID);
+
+
+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,
+    UNIQUE (FOLDER_ID, NAME, LOCALE, VALUE)
+);
+
+ALTER TABLE FOLDER_METADATA
+    ADD PRIMARY KEY (METADATA_ID);
+
+
+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)
+);
+
+ALTER TABLE FOLDER_CONSTRAINT
+    ADD PRIMARY KEY (CONSTRAINT_ID);
+
+
+CREATE  INDEX IX_FOLDER_CONSTRAINT_1 ON FOLDER_CONSTRAINT (FOLDER_ID);
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- FOLDER_CONSTRAINTS_REF
+-----------------------------------------------------------------------------
+
+CREATE TABLE FOLDER_CONSTRAINTS_REF
+(
+                    CONSTRAINTS_REF_ID INTEGER NOT NULL,
+                    FOLDER_ID INTEGER NOT NULL,
+                    APPLY_ORDER INTEGER NOT NULL,
+                NAME VARCHAR (40) NOT NULL,
+    UNIQUE (FOLDER_ID, NAME)
+);
+
+ALTER TABLE FOLDER_CONSTRAINTS_REF
+    ADD 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 INTEGER NOT NULL,
+                    FOLDER_ID INTEGER NOT NULL,
+                    SORT_ORDER INTEGER NOT NULL,
+                NAME VARCHAR (80) NOT NULL,
+    UNIQUE (FOLDER_ID, NAME)
+);
+
+ALTER TABLE FOLDER_ORDER
+    ADD PRIMARY KEY (ORDER_ID);
+
+
+CREATE  INDEX IX_FOLDER_ORDER_1 ON FOLDER_ORDER (FOLDER_ID);
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- FOLDER_MENU
+-----------------------------------------------------------------------------
+
+CREATE TABLE FOLDER_MENU
+(
+                    MENU_ID INTEGER NOT NULL,
+                CLASS_NAME VARCHAR (100) NOT NULL,
+                    PARENT_ID INTEGER,
+                    FOLDER_ID INTEGER,
+                    ELEMENT_ORDER INTEGER,
+                NAME VARCHAR (100),
+                TITLE VARCHAR (100),
+                SHORT_TITLE VARCHAR (40),
+                TEXT VARCHAR (100),
+                OPTIONS VARCHAR (255),
+                    DEPTH INTEGER,
+                    IS_PATHS INTEGER,
+                    IS_REGEXP INTEGER,
+                PROFILE VARCHAR (80),
+                OPTIONS_ORDER VARCHAR (255),
+                SKIN VARCHAR (80),
+                    IS_NEST INTEGER
+);
+
+ALTER TABLE FOLDER_MENU
+    ADD PRIMARY KEY (MENU_ID);
+
+
+CREATE  INDEX IX_FOLDER_MENU_1 ON FOLDER_MENU (PARENT_ID);
+CREATE  INDEX UN_FOLDER_MENU_1 ON FOLDER_MENU (FOLDER_ID, NAME);
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- FOLDER_MENU_METADATA
+-----------------------------------------------------------------------------
+
+CREATE TABLE FOLDER_MENU_METADATA
+(
+                    METADATA_ID INTEGER NOT NULL,
+                    MENU_ID INTEGER NOT NULL,
+                NAME VARCHAR (15) NOT NULL,
+                LOCALE VARCHAR (20) NOT NULL,
+                VALUE VARCHAR (100) NOT NULL,
+    UNIQUE (MENU_ID, NAME, LOCALE, VALUE)
+);
+
+ALTER TABLE FOLDER_MENU_METADATA
+    ADD PRIMARY KEY (METADATA_ID);
+
+
+CREATE  INDEX IX_FOLDER_MENU_METADATA_1 ON FOLDER_MENU_METADATA (MENU_ID);
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- PAGE
+-----------------------------------------------------------------------------
+
+CREATE TABLE PAGE
+(
+                    PAGE_ID INTEGER NOT NULL,
+                    PARENT_ID INTEGER NOT NULL,
+                PATH VARCHAR (240) NOT NULL,
+                NAME VARCHAR (80) NOT NULL,
+                VERSION VARCHAR (40),
+                TITLE VARCHAR (100),
+                SHORT_TITLE VARCHAR (40),
+                    IS_HIDDEN 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),
+    UNIQUE (PATH)
+);
+
+ALTER TABLE PAGE
+    ADD PRIMARY KEY (PAGE_ID);
+
+
+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,
+    UNIQUE (PAGE_ID, NAME, LOCALE, VALUE)
+);
+
+ALTER TABLE PAGE_METADATA
+    ADD PRIMARY KEY (METADATA_ID);
+
+
+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)
+);
+
+ALTER TABLE PAGE_CONSTRAINT
+    ADD PRIMARY KEY (CONSTRAINT_ID);
+
+
+CREATE  INDEX IX_PAGE_CONSTRAINT_1 ON PAGE_CONSTRAINT (PAGE_ID);
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- PAGE_CONSTRAINTS_REF
+-----------------------------------------------------------------------------
+
+CREATE TABLE PAGE_CONSTRAINTS_REF
+(
+                    CONSTRAINTS_REF_ID INTEGER NOT NULL,
+                    PAGE_ID INTEGER NOT NULL,
+                    APPLY_ORDER INTEGER NOT NULL,
+                NAME VARCHAR (40) NOT NULL,
+    UNIQUE (PAGE_ID, NAME)
+);
+
+ALTER TABLE PAGE_CONSTRAINTS_REF
+    ADD 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 INTEGER NOT NULL,
+                CLASS_NAME VARCHAR (100) NOT NULL,
+                    PARENT_ID INTEGER,
+                    PAGE_ID INTEGER,
+                    ELEMENT_ORDER INTEGER,
+                NAME VARCHAR (100),
+                TITLE VARCHAR (100),
+                SHORT_TITLE VARCHAR (40),
+                TEXT VARCHAR (100),
+                OPTIONS VARCHAR (255),
+                    DEPTH INTEGER,
+                    IS_PATHS INTEGER,
+                    IS_REGEXP INTEGER,
+                PROFILE VARCHAR (80),
+                OPTIONS_ORDER VARCHAR (255),
+                SKIN VARCHAR (80),
+                    IS_NEST INTEGER
+);
+
+ALTER TABLE PAGE_MENU
+    ADD PRIMARY KEY (MENU_ID);
+
+
+CREATE  INDEX IX_PAGE_MENU_1 ON PAGE_MENU (PARENT_ID);
+CREATE  INDEX UN_PAGE_MENU_1 ON PAGE_MENU (PAGE_ID, NAME);
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- PAGE_MENU_METADATA
+-----------------------------------------------------------------------------
+
+CREATE TABLE PAGE_MENU_METADATA
+(
+                    METADATA_ID INTEGER NOT NULL,
+                    MENU_ID INTEGER NOT NULL,
+                NAME VARCHAR (15) NOT NULL,
+                LOCALE VARCHAR (20) NOT NULL,
+                VALUE VARCHAR (100) NOT NULL,
+    UNIQUE (MENU_ID, NAME, LOCALE, VALUE)
+);
+
+ALTER TABLE PAGE_MENU_METADATA
+    ADD PRIMARY KEY (METADATA_ID);
+
+
+CREATE  INDEX IX_PAGE_MENU_METADATA_1 ON PAGE_MENU_METADATA (MENU_ID);
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- FRAGMENT
+-----------------------------------------------------------------------------
+
+CREATE TABLE FRAGMENT
+(
+                    FRAGMENT_ID INTEGER NOT NULL,
+                    PARENT_ID INTEGER,
+                    PAGE_ID INTEGER,
+                NAME VARCHAR (100),
+                TITLE VARCHAR (100),
+                SHORT_TITLE VARCHAR (40),
+                TYPE VARCHAR (40),
+                SKIN VARCHAR (80),
+                DECORATOR VARCHAR (80),
+                STATE VARCHAR (10),
+                PMODE VARCHAR (10),
+                    LAYOUT_ROW INTEGER,
+                    LAYOUT_COLUMN INTEGER,
+                LAYOUT_SIZES VARCHAR (20),
+                LAYOUT_X 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)
+);
+
+ALTER TABLE FRAGMENT
+    ADD PRIMARY KEY (FRAGMENT_ID);
+
+
+CREATE  INDEX IX_FRAGMENT_1 ON FRAGMENT (PARENT_ID);
+CREATE  INDEX UN_FRAGMENT_1 ON FRAGMENT (PAGE_ID);
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- FRAGMENT_CONSTRAINT
+-----------------------------------------------------------------------------
+
+CREATE TABLE FRAGMENT_CONSTRAINT
+(
+                    CONSTRAINT_ID INTEGER NOT NULL,
+                    FRAGMENT_ID INTEGER NOT NULL,
+                    APPLY_ORDER INTEGER NOT NULL,
+                USER_PRINCIPALS_ACL VARCHAR (120),
+                ROLE_PRINCIPALS_ACL VARCHAR (120),
+                GROUP_PRINCIPALS_ACL VARCHAR (120),
+                PERMISSIONS_ACL VARCHAR (120)
+);
+
+ALTER TABLE FRAGMENT_CONSTRAINT
+    ADD PRIMARY KEY (CONSTRAINT_ID);
+
+
+CREATE  INDEX IX_FRAGMENT_CONSTRAINT_1 ON FRAGMENT_CONSTRAINT (FRAGMENT_ID);
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- FRAGMENT_CONSTRAINTS_REF
+-----------------------------------------------------------------------------
+
+CREATE TABLE FRAGMENT_CONSTRAINTS_REF
+(
+                    CONSTRAINTS_REF_ID INTEGER NOT NULL,
+                    FRAGMENT_ID INTEGER NOT NULL,
+                    APPLY_ORDER INTEGER NOT NULL,
+                NAME VARCHAR (40) NOT NULL,
+    UNIQUE (FRAGMENT_ID, NAME)
+);
+
+ALTER TABLE FRAGMENT_CONSTRAINTS_REF
+    ADD 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 INTEGER NOT NULL,
+                    FRAGMENT_ID INTEGER NOT NULL,
+                NAME VARCHAR (40) NOT NULL,
+                    IS_READ_ONLY INTEGER NOT NULL,
+    UNIQUE (FRAGMENT_ID, NAME)
+);
+
+ALTER TABLE FRAGMENT_PREF
+    ADD 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 INTEGER NOT NULL,
+                    PREF_ID INTEGER NOT NULL,
+                    VALUE_ORDER INTEGER NOT NULL,
+                VALUE VARCHAR (100) NOT NULL
+);
+
+ALTER TABLE FRAGMENT_PREF_VALUE
+    ADD PRIMARY KEY (PREF_VALUE_ID);
+
+
+CREATE  INDEX IX_FRAGMENT_PREF_VALUE_1 ON FRAGMENT_PREF_VALUE (PREF_ID);
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- LINK
+-----------------------------------------------------------------------------
+
+CREATE TABLE LINK
+(
+                    LINK_ID INTEGER NOT NULL,
+                    PARENT_ID INTEGER NOT NULL,
+                PATH VARCHAR (240) NOT NULL,
+                NAME VARCHAR (80) NOT NULL,
+                VERSION VARCHAR (40),
+                TITLE VARCHAR (100),
+                SHORT_TITLE VARCHAR (40),
+                    IS_HIDDEN 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),
+    UNIQUE (PATH)
+);
+
+ALTER TABLE LINK
+    ADD PRIMARY KEY (LINK_ID);
+
+
+CREATE  INDEX IX_LINK_1 ON LINK (PARENT_ID);
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- LINK_METADATA
+-----------------------------------------------------------------------------
+
+CREATE TABLE LINK_METADATA
+(
+                    METADATA_ID INTEGER NOT NULL,
+                    LINK_ID INTEGER NOT NULL,
+                NAME VARCHAR (15) NOT NULL,
+                LOCALE VARCHAR (20) NOT NULL,
+                VALUE VARCHAR (100) NOT NULL,
+    UNIQUE (LINK_ID, NAME, LOCALE, VALUE)
+);
+
+ALTER TABLE LINK_METADATA
+    ADD PRIMARY KEY (METADATA_ID);
+
+
+CREATE  INDEX IX_LINK_METADATA_1 ON LINK_METADATA (LINK_ID);
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- LINK_CONSTRAINT
+-----------------------------------------------------------------------------
+
+CREATE TABLE LINK_CONSTRAINT
+(
+                    CONSTRAINT_ID INTEGER NOT NULL,
+                    LINK_ID INTEGER NOT NULL,
+                    APPLY_ORDER INTEGER NOT NULL,
+                USER_PRINCIPALS_ACL VARCHAR (120),
+                ROLE_PRINCIPALS_ACL VARCHAR (120),
+                GROUP_PRINCIPALS_ACL VARCHAR (120),
+                PERMISSIONS_ACL VARCHAR (120)
+);
+
+ALTER TABLE LINK_CONSTRAINT
+    ADD PRIMARY KEY (CONSTRAINT_ID);
+
+
+CREATE  INDEX IX_LINK_CONSTRAINT_1 ON LINK_CONSTRAINT (LINK_ID);
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- LINK_CONSTRAINTS_REF
+-----------------------------------------------------------------------------
+
+CREATE TABLE LINK_CONSTRAINTS_REF
+(
+                    CONSTRAINTS_REF_ID INTEGER NOT NULL,
+                    LINK_ID INTEGER NOT NULL,
+                    APPLY_ORDER INTEGER NOT NULL,
+                NAME VARCHAR (40) NOT NULL,
+    UNIQUE (LINK_ID, NAME)
+);
+
+ALTER TABLE LINK_CONSTRAINTS_REF
+    ADD 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 INTEGER NOT NULL,
+                    PARENT_ID INTEGER NOT NULL,
+                PATH VARCHAR (240) NOT NULL,
+                NAME VARCHAR (80) NOT NULL,
+                VERSION VARCHAR (40),
+                SUBSITE VARCHAR (40),
+                USER_PRINCIPAL VARCHAR (40),
+                ROLE_PRINCIPAL VARCHAR (40),
+                GROUP_PRINCIPAL VARCHAR (40),
+                MEDIATYPE VARCHAR (15),
+                LOCALE VARCHAR (20),
+                EXT_ATTR_NAME VARCHAR (15),
+                EXT_ATTR_VALUE VARCHAR (40),
+    UNIQUE (PARENT_ID),
+    UNIQUE (PATH)
+);
+
+ALTER TABLE PAGE_SECURITY
+    ADD PRIMARY KEY (PAGE_SECURITY_ID);
+
+
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- PAGE_SEC_CONSTRAINTS_DEF
+-----------------------------------------------------------------------------
+
+CREATE TABLE PAGE_SEC_CONSTRAINTS_DEF
+(
+                    CONSTRAINTS_DEF_ID INTEGER NOT NULL,
+                    PAGE_SECURITY_ID INTEGER NOT NULL,
+                NAME VARCHAR (40) NOT NULL,
+    UNIQUE (PAGE_SECURITY_ID, NAME)
+);
+
+ALTER TABLE PAGE_SEC_CONSTRAINTS_DEF
+    ADD 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 INTEGER NOT NULL,
+                    CONSTRAINTS_DEF_ID INTEGER NOT NULL,
+                    APPLY_ORDER INTEGER NOT NULL,
+                USER_PRINCIPALS_ACL VARCHAR (120),
+                ROLE_PRINCIPALS_ACL VARCHAR (120),
+                GROUP_PRINCIPALS_ACL VARCHAR (120),
+                PERMISSIONS_ACL VARCHAR (120)
+);
+
+ALTER TABLE PAGE_SEC_CONSTRAINT_DEF
+    ADD PRIMARY KEY (CONSTRAINT_DEF_ID);
+
+
+CREATE  INDEX IX_PAGE_SEC_CONSTRAINT_DEF_1 ON PAGE_SEC_CONSTRAINT_DEF (CONSTRAINTS_DEF_ID);
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- PAGE_SEC_CONSTRAINTS_REF
+-----------------------------------------------------------------------------
+
+CREATE TABLE PAGE_SEC_CONSTRAINTS_REF
+(
+                    CONSTRAINTS_REF_ID INTEGER NOT NULL,
+                    PAGE_SECURITY_ID INTEGER NOT NULL,
+                    APPLY_ORDER INTEGER NOT NULL,
+                NAME VARCHAR (40) NOT NULL,
+    UNIQUE (PAGE_SECURITY_ID, NAME)
+);
+
+ALTER TABLE PAGE_SEC_CONSTRAINTS_REF
+    ADD 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 VARCHAR (80) NOT NULL,
+                CLASS_NAME VARCHAR (100) NOT NULL,
+                TITLE VARCHAR (100)
+);
+
+ALTER TABLE PROFILING_RULE
+    ADD 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
+);
+
+ALTER TABLE RULE_CRITERION
+    ADD PRIMARY KEY (CRITERION_ID);
+
+
+CREATE  INDEX IX_RULE_CRITERION_1 ON RULE_CRITERION (RULE_ID, FALLBACK_ORDER);
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- PRINCIPAL_RULE_ASSOC
+-----------------------------------------------------------------------------
+
+CREATE TABLE PRINCIPAL_RULE_ASSOC
+(
+                PRINCIPAL_NAME VARCHAR (80) NOT NULL,
+                LOCATOR_NAME VARCHAR (80) NOT NULL,
+                RULE_ID VARCHAR (80) NOT NULL
+);
+
+ALTER TABLE PRINCIPAL_RULE_ASSOC
+    ADD 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)
+);
+
+ALTER TABLE CLUBS
+    ADD PRIMARY KEY (NAME);
+
+
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- FOLDER: FOREIGN KEYS
+-----------------------------------------------------------------------------
+ALTER TABLE FOLDER
+    ADD CONSTRAINT FK_FOLDER_1 FOREIGN KEY (PARENT_ID)
+    REFERENCES FOLDER (FOLDER_ID)
+    ON DELETE CASCADE 
+;
+
+
+-----------------------------------------------------------------------------
+-- FOLDER_METADATA: FOREIGN KEYS
+-----------------------------------------------------------------------------
+ALTER TABLE FOLDER_METADATA
+    ADD CONSTRAINT FK_FOLDER_METADATA_1 FOREIGN KEY (FOLDER_ID)
+    REFERENCES FOLDER (FOLDER_ID)
+    ON DELETE CASCADE 
+;
+
+
+-----------------------------------------------------------------------------
+-- FOLDER_CONSTRAINT: FOREIGN KEYS
+-----------------------------------------------------------------------------
+ALTER TABLE FOLDER_CONSTRAINT
+    ADD CONSTRAINT FK_FOLDER_CONSTRAINT_1 FOREIGN KEY (FOLDER_ID)
+    REFERENCES FOLDER (FOLDER_ID)
+    ON DELETE CASCADE 
+;
+
+
+-----------------------------------------------------------------------------
+-- FOLDER_CONSTRAINTS_REF: FOREIGN KEYS
+-----------------------------------------------------------------------------
+ALTER TABLE FOLDER_CONSTRAINTS_REF
+    ADD CONSTRAINT FK_FOLDER_CONSTRAINTS_REF_1 FOREIGN KEY (FOLDER_ID)
+    REFERENCES FOLDER (FOLDER_ID)
+    ON DELETE CASCADE 
+;
+
+
+-----------------------------------------------------------------------------
+-- FOLDER_ORDER: FOREIGN KEYS
+-----------------------------------------------------------------------------
+ALTER TABLE FOLDER_ORDER
+    ADD CONSTRAINT FK_FOLDER_ORDER_1 FOREIGN KEY (FOLDER_ID)
+    REFERENCES FOLDER (FOLDER_ID)
+    ON DELETE CASCADE 
+;
+
+
+-----------------------------------------------------------------------------
+-- FOLDER_MENU: FOREIGN KEYS
+-----------------------------------------------------------------------------
+ALTER TABLE FOLDER_MENU
+    ADD CONSTRAINT FK_FOLDER_MENU_1 FOREIGN KEY (PARENT_ID)
+    REFERENCES FOLDER_MENU (MENU_ID)
+    ON DELETE CASCADE 
+;
+ALTER TABLE FOLDER_MENU
+    ADD CONSTRAINT FK_FOLDER_MENU_2 FOREIGN KEY (FOLDER_ID)
+    REFERENCES FOLDER (FOLDER_ID)
+    ON DELETE CASCADE 
+;
+
+
+-----------------------------------------------------------------------------
+-- FOLDER_MENU_METADATA: FOREIGN KEYS
+-----------------------------------------------------------------------------
+ALTER TABLE FOLDER_MENU_METADATA
+    ADD CONSTRAINT FK_FOLDER_MENU_METADATA_1 FOREIGN KEY (MENU_ID)
+    REFERENCES FOLDER_MENU (MENU_ID)
+    ON DELETE CASCADE 
+;
+
+
+-----------------------------------------------------------------------------
+-- PAGE: FOREIGN KEYS
+-----------------------------------------------------------------------------
+ALTER TABLE PAGE
+    ADD CONSTRAINT FK_PAGE_1 FOREIGN KEY (PARENT_ID)
+    REFERENCES FOLDER (FOLDER_ID)
+    ON DELETE CASCADE 
+;
+
+
+-----------------------------------------------------------------------------
+-- PAGE_METADATA: FOREIGN KEYS
+-----------------------------------------------------------------------------
+ALTER TABLE PAGE_METADATA
+    ADD CONSTRAINT FK_PAGE_METADATA_1 FOREIGN KEY (PAGE_ID)
+    REFERENCES PAGE (PAGE_ID)
+    ON DELETE CASCADE 
+;
+
+
+-----------------------------------------------------------------------------
+-- PAGE_CONSTRAINT: FOREIGN KEYS
+-----------------------------------------------------------------------------
+ALTER TABLE PAGE_CONSTRAINT
+    ADD CONSTRAINT FK_PAGE_CONSTRAINT_1 FOREIGN KEY (PAGE_ID)
+    REFERENCES PAGE (PAGE_ID)
+    ON DELETE CASCADE 
+;
+
+
+-----------------------------------------------------------------------------
+-- PAGE_CONSTRAINTS_REF: FOREIGN KEYS
+-----------------------------------------------------------------------------
+ALTER TABLE PAGE_CONSTRAINTS_REF
+    ADD CONSTRAINT FK_PAGE_CONSTRAINTS_REF_1 FOREIGN KEY (PAGE_ID)
+    REFERENCES PAGE (PAGE_ID)
+    ON DELETE CASCADE 
+;
+
+
+-----------------------------------------------------------------------------
+-- PAGE_MENU: FOREIGN KEYS
+-----------------------------------------------------------------------------
+ALTER TABLE PAGE_MENU
+    ADD CONSTRAINT FK_PAGE_MENU_1 FOREIGN KEY (PARENT_ID)
+    REFERENCES PAGE_MENU (MENU_ID)
+    ON DELETE CASCADE 
+;
+ALTER TABLE PAGE_MENU
+    ADD CONSTRAINT PM_M_FK_PAGE_ID_PAGE FOREIGN KEY (PAGE_ID)
+    REFERENCES PAGE (PAGE_ID)
+    ON DELETE CASCADE 
+;
+
+
+-----------------------------------------------------------------------------
+-- PAGE_MENU_METADATA: FOREIGN KEYS
+-----------------------------------------------------------------------------
+ALTER TABLE PAGE_MENU_METADATA
+    ADD CONSTRAINT FK_PAGE_MENU_METADATA_1 FOREIGN KEY (MENU_ID)
+    REFERENCES PAGE_MENU (MENU_ID)
+    ON DELETE CASCADE 
+;
+
+
+-----------------------------------------------------------------------------
+-- FRAGMENT: FOREIGN KEYS
+-----------------------------------------------------------------------------
+ALTER TABLE FRAGMENT
+    ADD CONSTRAINT FK_FRAGMENT_1 FOREIGN KEY (PARENT_ID)
+    REFERENCES FRAGMENT (FRAGMENT_ID)
+    ON DELETE CASCADE 
+;
+ALTER TABLE FRAGMENT
+    ADD CONSTRAINT FK_FRAGMENT_2 FOREIGN KEY (PAGE_ID)
+    REFERENCES PAGE (PAGE_ID)
+    ON DELETE CASCADE 
+;
+
+
+-----------------------------------------------------------------------------
+-- FRAGMENT_CONSTRAINT: FOREIGN KEYS
+-----------------------------------------------------------------------------
+ALTER TABLE FRAGMENT_CONSTRAINT
+    ADD CONSTRAINT FK_FRAGMENT_CONSTRAINT_1 FOREIGN KEY (FRAGMENT_ID)
+    REFERENCES FRAGMENT (FRAGMENT_ID)
+    ON DELETE CASCADE 
+;
+
+
+-----------------------------------------------------------------------------
+-- FRAGMENT_CONSTRAINTS_REF: FOREIGN KEYS
+-----------------------------------------------------------------------------
+ALTER TABLE FRAGMENT_CONSTRAINTS_REF
+    ADD CONSTRAINT FK_FRAGMENT_CONSTRAINTS_REF_1 FOREIGN KEY (FRAGMENT_ID)
+    REFERENCES FRAGMENT (FRAGMENT_ID)
+    ON DELETE CASCADE 
+;
+
+
+-----------------------------------------------------------------------------
+-- FRAGMENT_PREF: FOREIGN KEYS
+-----------------------------------------------------------------------------
+ALTER TABLE FRAGMENT_PREF
+    ADD CONSTRAINT FK_FRAGMENT_PREF_1 FOREIGN KEY (FRAGMENT_ID)
+    REFERENCES FRAGMENT (FRAGMENT_ID)
+    ON DELETE CASCADE 
+;
+
+
+-----------------------------------------------------------------------------
+-- FRAGMENT_PREF_VALUE: FOREIGN KEYS
+-----------------------------------------------------------------------------
+ALTER TABLE FRAGMENT_PREF_VALUE
+    ADD CONSTRAINT FK_FRAGMENT_PREF_VALUE_1 FOREIGN KEY (PREF_ID)
+    REFERENCES FRAGMENT_PREF (PREF_ID)
+    ON DELETE CASCADE 
+;
+
+
+-----------------------------------------------------------------------------
+-- LINK: FOREIGN KEYS
+-----------------------------------------------------------------------------
+ALTER TABLE LINK
+    ADD CONSTRAINT FK_LINK_1 FOREIGN KEY (PARENT_ID)
+    REFERENCES FOLDER (FOLDER_ID)
+    ON DELETE CASCADE 
+;
+
+
+-----------------------------------------------------------------------------
+-- LINK_METADATA: FOREIGN KEYS
+-----------------------------------------------------------------------------
+ALTER TABLE LINK_METADATA
+    ADD CONSTRAINT FK_LINK_METADATA_1 FOREIGN KEY (LINK_ID)
+    REFERENCES LINK (LINK_ID)
+    ON DELETE CASCADE 
+;
+
+
+-----------------------------------------------------------------------------
+-- LINK_CONSTRAINT: FOREIGN KEYS
+-----------------------------------------------------------------------------
+ALTER TABLE LINK_CONSTRAINT
+    ADD CONSTRAINT FK_LINK_CONSTRAINT_1 FOREIGN KEY (LINK_ID)
+    REFERENCES LINK (LINK_ID)
+    ON DELETE CASCADE 
+;
+
+
+-----------------------------------------------------------------------------
+-- LINK_CONSTRAINTS_REF: FOREIGN KEYS
+-----------------------------------------------------------------------------
+ALTER TABLE LINK_CONSTRAINTS_REF
+    ADD CONSTRAINT FK_LINK_CONSTRAINTS_REF_1 FOREIGN KEY (LINK_ID)
+    REFERENCES LINK (LINK_ID)
+    ON DELETE CASCADE 
+;
+
+
+-----------------------------------------------------------------------------
+-- PAGE_SECURITY: FOREIGN KEYS
+-----------------------------------------------------------------------------
+ALTER TABLE PAGE_SECURITY
+    ADD CONSTRAINT FK_PAGE_SECURITY_1 FOREIGN KEY (PARENT_ID)
+    REFERENCES FOLDER (FOLDER_ID)
+    ON DELETE CASCADE 
+;
+
+
+-----------------------------------------------------------------------------
+-- PAGE_SEC_CONSTRAINTS_DEF: FOREIGN KEYS
+-----------------------------------------------------------------------------
+ALTER TABLE PAGE_SEC_CONSTRAINTS_DEF
+    ADD CONSTRAINT FK_PAGE_SEC_CONSTRAINTS_DEF_1 FOREIGN KEY (PAGE_SECURITY_ID)
+    REFERENCES PAGE_SECURITY (PAGE_SECURITY_ID)
+    ON DELETE CASCADE 
+;
+
+
+-----------------------------------------------------------------------------
+-- PAGE_SEC_CONSTRAINT_DEF: FOREIGN KEYS
+-----------------------------------------------------------------------------
+ALTER TABLE PAGE_SEC_CONSTRAINT_DEF
+    ADD CONSTRAINT FK_PAGE_SEC_CONSTRAINT_DEF_1 FOREIGN KEY (CONSTRAINTS_DEF_ID)
+    REFERENCES PAGE_SEC_CONSTRAINTS_DEF (CONSTRAINTS_DEF_ID)
+    ON DELETE CASCADE 
+;
+
+
+-----------------------------------------------------------------------------
+-- PAGE_SEC_CONSTRAINTS_REF: FOREIGN KEYS
+-----------------------------------------------------------------------------
+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 
+;
+
+
+-----------------------------------------------------------------------------
+-- PROFILING_RULE: FOREIGN KEYS
+-----------------------------------------------------------------------------
+
+
+-----------------------------------------------------------------------------
+-- RULE_CRITERION: FOREIGN KEYS
+-----------------------------------------------------------------------------
+ALTER TABLE RULE_CRITERION
+    ADD CONSTRAINT FK_RULE_CRITERION_1 FOREIGN KEY (RULE_ID)
+    REFERENCES PROFILING_RULE (RULE_ID)
+    ON DELETE CASCADE 
+;
+
+
+-----------------------------------------------------------------------------
+-- PRINCIPAL_RULE_ASSOC: FOREIGN KEYS
+-----------------------------------------------------------------------------
+
+
+-----------------------------------------------------------------------------
+-- PROFILE_PAGE_ASSOC: FOREIGN KEYS
+-----------------------------------------------------------------------------
+
+
+-----------------------------------------------------------------------------
+-- CLUBS: FOREIGN KEYS
+-----------------------------------------------------------------------------
+

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

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

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

Added: geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/db2/phase3ojb-schema.sql
URL: http://svn.apache.org/viewvc/geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/db2/phase3ojb-schema.sql?rev=588248&view=auto
==============================================================================
--- geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/db2/phase3ojb-schema.sql (added)
+++ geronimo/sandbox/jetspeed-integration/jetspeed-database/src/main/database/db2/phase3ojb-schema.sql Thu Oct 25 08:16:02 2007
@@ -0,0 +1,202 @@
+
+-----------------------------------------------------------------------------
+-- 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
+);
+
+ALTER TABLE OJB_HL_SEQ
+    ADD 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
+);
+
+ALTER TABLE OJB_LOCKENTRY
+    ADD PRIMARY KEY (OID_,TX_ID);
+
+
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- OJB_NRM
+-----------------------------------------------------------------------------
+
+CREATE TABLE OJB_NRM
+(
+                NAME VARCHAR (250) NOT NULL,
+                OID_ LONG VARCHAR FOR BIT DATA
+);
+
+ALTER TABLE OJB_NRM
+    ADD PRIMARY KEY (NAME);
+
+
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- OJB_DLIST
+-----------------------------------------------------------------------------
+
+CREATE TABLE OJB_DLIST
+(
+                    ID INTEGER NOT NULL,
+                    SIZE_ INTEGER
+);
+
+ALTER TABLE OJB_DLIST
+    ADD PRIMARY KEY (ID);
+
+
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- OJB_DLIST_ENTRIES
+-----------------------------------------------------------------------------
+
+CREATE TABLE OJB_DLIST_ENTRIES
+(
+                    ID INTEGER NOT NULL,
+                    DLIST_ID INTEGER,
+                    POSITION_ INTEGER,
+                OID_ LONG VARCHAR FOR BIT DATA
+);
+
+ALTER TABLE OJB_DLIST_ENTRIES
+    ADD PRIMARY KEY (ID);
+
+
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- OJB_DSET
+-----------------------------------------------------------------------------
+
+CREATE TABLE OJB_DSET
+(
+                    ID INTEGER NOT NULL,
+                    SIZE_ INTEGER
+);
+
+ALTER TABLE OJB_DSET
+    ADD PRIMARY KEY (ID);
+
+
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- OJB_DSET_ENTRIES
+-----------------------------------------------------------------------------
+
+CREATE TABLE OJB_DSET_ENTRIES
+(
+                    ID INTEGER NOT NULL,
+                    DLIST_ID INTEGER,
+                    POSITION_ INTEGER,
+                OID_ LONG VARCHAR FOR BIT DATA
+);
+
+ALTER TABLE OJB_DSET_ENTRIES
+    ADD PRIMARY KEY (ID);
+
+
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- OJB_DMAP
+-----------------------------------------------------------------------------
+
+CREATE TABLE OJB_DMAP
+(
+                    ID INTEGER NOT NULL,
+                    SIZE_ INTEGER
+);
+
+ALTER TABLE OJB_DMAP
+    ADD PRIMARY KEY (ID);
+
+
+
+
+
+
+
+-----------------------------------------------------------------------------
+-- OJB_HL_SEQ: FOREIGN KEYS
+-----------------------------------------------------------------------------
+
+
+-----------------------------------------------------------------------------
+-- OJB_LOCKENTRY: FOREIGN KEYS
+-----------------------------------------------------------------------------
+
+
+-----------------------------------------------------------------------------
+-- OJB_NRM: FOREIGN KEYS
+-----------------------------------------------------------------------------
+
+
+-----------------------------------------------------------------------------
+-- OJB_DLIST: FOREIGN KEYS
+-----------------------------------------------------------------------------
+
+
+-----------------------------------------------------------------------------
+-- OJB_DLIST_ENTRIES: FOREIGN KEYS
+-----------------------------------------------------------------------------
+
+
+-----------------------------------------------------------------------------
+-- OJB_DSET: FOREIGN KEYS
+-----------------------------------------------------------------------------
+
+
+-----------------------------------------------------------------------------
+-- OJB_DSET_ENTRIES: FOREIGN KEYS
+-----------------------------------------------------------------------------
+
+
+-----------------------------------------------------------------------------
+-- OJB_DMAP: FOREIGN KEYS
+-----------------------------------------------------------------------------
+

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

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

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

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

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

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



Mime
View raw message