You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jetspeed-dev@portals.apache.org by rw...@apache.org on 2005/10/08 06:30:13 UTC
svn commit: r307258 - in /portals/jetspeed-2/trunk/etc:
schema/phase2-schema.xml sql/drop.sql sql/oracle/drop.sql
Author: rwatler
Date: Fri Oct 7 21:30:08 2005
New Revision: 307258
URL: http://svn.apache.org/viewcvs?rev=307258&view=rev
Log:
DBPageManager schema updates, (from dst)
Modified:
portals/jetspeed-2/trunk/etc/schema/phase2-schema.xml
portals/jetspeed-2/trunk/etc/sql/drop.sql
portals/jetspeed-2/trunk/etc/sql/oracle/drop.sql
Modified: portals/jetspeed-2/trunk/etc/schema/phase2-schema.xml
URL: http://svn.apache.org/viewcvs/portals/jetspeed-2/trunk/etc/schema/phase2-schema.xml?rev=307258&r1=307257&r2=307258&view=diff
==============================================================================
--- portals/jetspeed-2/trunk/etc/schema/phase2-schema.xml (original)
+++ portals/jetspeed-2/trunk/etc/schema/phase2-schema.xml Fri Oct 7 21:30:08 2005
@@ -17,16 +17,39 @@
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database_3_2.dtd">
<!-- Autogenerated by JDBCToXMLSchema! -->
<database name="j2">
+
+
+ <table name="FOLDER">
+ <column name="FOLDER_ID" primaryKey="true" required="true"
+ size="80" type="VARCHAR"/>
+ <column name="PARENT_ID" type="VARCHAR" size="80"/>
+ <column name="TITLE" size="100" type="VARCHAR"/>
+ <foreign-key foreignTable="FOLDER" onDelete="cascade">
+ <reference foreign="FOLDER_ID" local="PARENT_ID"/>
+ </foreign-key>
+ <index name="FOLDER_IDX1">
+ <index-column name="PARENT_ID" />
+ </index >
+ </table>
<!-- associates a page with its sub group pages -->
<table name="SUB_PAGES">
- <column name="PAGE_ID" required="true" size="80" type="VARCHAR"/>
+ <column name="FOLDER_ID" required="true" size="80" type="VARCHAR"/>
<column name="SUB_PAGE_ID" required="true" size="80" type="VARCHAR"/>
<index name="IX_SUB_PAGES_1">
- <index-column name="PAGE_ID" />
+ <index-column name="FOLDER_ID" />
<index-column name="SUB_PAGE_ID" />
</index>
</table>
+
+ <table name="SUB_FOLDERS">
+ <column name="FOLDER_ID" required="true" size="80" type="VARCHAR"/>
+ <column name="SUB_FOLDER_ID" required="true" size="80" type="VARCHAR"/>
+ <index name="IX_SUB_FOLDER_1">
+ <index-column name="FOLDER_ID" />
+ <index-column name="SUB_FOLDER_ID" />
+ </index>
+ </table>
<!--
Page Definitions
@@ -35,11 +58,18 @@
<table name="PAGE">
<column name="PAGE_ID" primaryKey="true" required="true"
size="80" type="VARCHAR"/>
+ <column name="PARENT_ID" type="VARCHAR" size="80"/>
<column name="TITLE" size="100" type="VARCHAR"/>
- <column name="DEFAULT_SKIN" size="100" type="VARCHAR"/>
<column name="DEFAULT_DECORATOR" size="100" type="VARCHAR"/>
<column name="DEFAULT_PORTLET_DECORATOR" size="100" type="VARCHAR"/>
<column name="ACL" size="80" type="VARCHAR"/>
+ <foreign-key foreignTable="FOLDER" onDelete="cascade">
+ <reference foreign="FOLDER_ID" local="PARENT_ID"/>
+ </foreign-key>
+ <index name="PAGE_IDX1">
+ <index-column name="PARENT_ID" />
+ </index >
+
</table>
<!--
Modified: portals/jetspeed-2/trunk/etc/sql/drop.sql
URL: http://svn.apache.org/viewcvs/portals/jetspeed-2/trunk/etc/sql/drop.sql?rev=307258&r1=307257&r2=307258&view=diff
==============================================================================
--- portals/jetspeed-2/trunk/etc/sql/drop.sql (original)
+++ portals/jetspeed-2/trunk/etc/sql/drop.sql Fri Oct 7 21:30:08 2005
@@ -15,14 +15,16 @@
DROP TABLE CLIENT_TO_MIMETYPE;
DROP TABLE MEDIATYPE_TO_CAPABILITY;
DROP TABLE MEDIATYPE_TO_MIMETYPE;
-DROP TABLE SUB_PAGES;
-DROP TABLE PAGE;
DROP TABLE FRAGMENT;
DROP TABLE PAGE_FRAGMENTS;
DROP TABLE SUB_FRAGMENTS;
DROP TABLE FRAGMENT_PARAMETER;
DROP TABLE FRAGMENT_REF;
DROP TABLE FRAGMENT_REFS;
+DROP TABLE SUB_PAGES;
+DROP TABLE PAGE;
+DROP TABLE SUB_FOLDERS;
+DROP TABLE FOLDER;
DROP TABLE RULE_CRITERION;
DROP TABLE PRINCIPAL_RULE_ASSOC;
DROP TABLE PROFILE_PAGE_ASSOC;
Modified: portals/jetspeed-2/trunk/etc/sql/oracle/drop.sql
URL: http://svn.apache.org/viewcvs/portals/jetspeed-2/trunk/etc/sql/oracle/drop.sql?rev=307258&r1=307257&r2=307258&view=diff
==============================================================================
--- portals/jetspeed-2/trunk/etc/sql/oracle/drop.sql (original)
+++ portals/jetspeed-2/trunk/etc/sql/oracle/drop.sql Fri Oct 7 21:30:08 2005
@@ -21,14 +21,19 @@
DROP TABLE MEDIATYPE_TO_CAPABILITY;
DROP TABLE MEDIATYPE_TO_MIMETYPE;
-DROP TABLE SUB_PAGES;
-DROP TABLE PAGE;
DROP TABLE FRAGMENT;
DROP TABLE PAGE_FRAGMENTS;
DROP TABLE SUB_FRAGMENTS;
DROP TABLE FRAGMENT_PARAMETER;
DROP TABLE FRAGMENT_REF;
DROP TABLE FRAGMENT_REFS;
+
+DROP TABLE SUB_PAGES;
+DROP TABLE PAGE;
+
+DROP TABLE SUB_FOLDERS;
+DROP TABLE FOLDER;
+
DROP TABLE RULE_CRITERION;
DROP TABLE PRINCIPAL_RULE_ASSOC;
DROP TABLE PROFILE_PAGE_ASSOC;
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-dev-help@portals.apache.org