portals-jetspeed-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From rwat...@apache.org
Subject svn commit: r307258 - in /portals/jetspeed-2/trunk/etc: schema/phase2-schema.xml sql/drop.sql sql/oracle/drop.sql
Date Sat, 08 Oct 2005 04:30:13 GMT
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


Mime
View raw message