portals-jetspeed-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From rwat...@apache.org
Subject svn commit: r331694 - in /portals/jetspeed-2/trunk/etc: schema/phase2-schema.xml sql/drop.sql sql/oracle/drop.sql
Date Tue, 08 Nov 2005 05:44:21 GMT
Author: rwatler
Date: Mon Nov  7 21:44:18 2005
New Revision: 331694

URL: http://svn.apache.org/viewcvs?rev=331694&view=rev
Log:
correct misc typos in schema/sql scripts related to PageManager

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=331694&r1=331693&r2=331694&view=diff
==============================================================================
--- portals/jetspeed-2/trunk/etc/schema/phase2-schema.xml (original)
+++ portals/jetspeed-2/trunk/etc/schema/phase2-schema.xml Mon Nov  7 21:44:18 2005
@@ -23,7 +23,7 @@
 
     <table name="FOLDER">
         <column name="FOLDER_ID" primaryKey="true" required="true" type="INTEGER"/>
-		<column name="PARENT_ID" type="INTEGER"/>
+        <column name="PARENT_ID" type="INTEGER"/>
         <column name="PATH" required="true" size="160" type="VARCHAR"/>
         <column name="NAME" required="true" size="80" type="VARCHAR"/>
         <column name="TITLE" size="100" type="VARCHAR"/>
@@ -39,72 +39,72 @@
         <column name="EXT_ATTR_NAME" required="true" size="15" type="VARCHAR"/>
         <column name="EXT_ATTR_VALUE" required="true" size="40" type="VARCHAR"/>
         <column name="OWNER_PRINCIPAL" size="40" type="VARCHAR"/>
-		<foreign-key foreignTable="FOLDER" onDelete="cascade">
-			<reference foreign="FOLDER_ID" local="PARENT_ID"/>
-		</foreign-key>
-		<index name="IX_FOLDER_1">
-			<index-column name="PARENT_ID"/>
-		</index>
-		<unique name="UN_FOLDER_1">
-			<unique-column name="PATH"/>
-			<unique-column name="SUBSITE"/>
-			<unique-column name="USER_PRINCIPAL"/>
-			<unique-column name="ROLE_PRINCIPAL"/>
-			<unique-column name="GROUP_PRINCIPAL"/>
-			<unique-column name="MEDIATYPE"/>
-			<unique-column name="LOCALE"/>
-			<unique-column name="EXT_ATTR_NAME"/>
-			<unique-column name="EXT_ATTR_VALUE"/>
-		</unique>
+        <foreign-key foreignTable="FOLDER" onDelete="cascade">
+            <reference foreign="FOLDER_ID" local="PARENT_ID"/>
+        </foreign-key>
+        <index name="IX_FOLDER_1">
+            <index-column name="PARENT_ID"/>
+        </index>
+        <unique name="UN_FOLDER_1">
+            <unique-column name="PATH"/>
+            <unique-column name="SUBSITE"/>
+            <unique-column name="USER_PRINCIPAL"/>
+            <unique-column name="ROLE_PRINCIPAL"/>
+            <unique-column name="GROUP_PRINCIPAL"/>
+            <unique-column name="MEDIATYPE"/>
+            <unique-column name="LOCALE"/>
+            <unique-column name="EXT_ATTR_NAME"/>
+            <unique-column name="EXT_ATTR_VALUE"/>
+        </unique>
     </table>
     
     <table name="FOLDER_METADATA">
         <column name="METADATA_ID" primaryKey="true" required="true" type="INTEGER"/>
-		<column name="FOLDER_ID" type="INTEGER" required="true"/>
+        <column name="FOLDER_ID" type="INTEGER" required="true"/>
         <column name="NAME" required="true" size="15" type="VARCHAR"/>
         <column name="LOCALE" required="true" size="20" type="VARCHAR"/>
         <column name="VALUE" required="true" size="100" type="VARCHAR"/>
-		<foreign-key foreignTable="FOLDER" onDelete="cascade">
-			<reference foreign="FOLDER_ID" local="FOLDER_ID"/>
-		</foreign-key>
-		<index name="IX_FOLDER_METADATA_1">
-			<index-column name="FOLDER_ID"/>
-		</index>
-		<unique name="UN_FOLDER_METADATA_1">
-			<unique-column name="FOLDER_ID"/>
-			<unique-column name="NAME"/>
-			<unique-column name="LOCALE"/>
-			<unique-column name="VALUE"/>
-		</unique>
+        <foreign-key foreignTable="FOLDER" onDelete="cascade">
+            <reference foreign="FOLDER_ID" local="FOLDER_ID"/>
+        </foreign-key>
+        <index name="IX_FOLDER_METADATA_1">
+            <index-column name="FOLDER_ID"/>
+        </index>
+        <unique name="UN_FOLDER_METADATA_1">
+            <unique-column name="FOLDER_ID"/>
+            <unique-column name="NAME"/>
+            <unique-column name="LOCALE"/>
+            <unique-column name="VALUE"/>
+        </unique>
     </table>
 
     <table name="FOLDER_SECURITY_CONSTRAINT">
         <column name="CONSTRAINT_ID" primaryKey="true" required="true" type="INTEGER"/>
-		<column name="FOLDER_ID" type="INTEGER" required="true"/>
-		<column name="APPLY_ORDER" type="INTEGER" required="true"/>
+        <column name="FOLDER_ID" type="INTEGER" required="true"/>
+        <column name="APPLY_ORDER" type="INTEGER" required="true"/>
         <column name="USER_PRINCIPALS_ACL" size="120" type="VARCHAR"/>
         <column name="ROLE_PRINCIPALS_ACL" size="120" type="VARCHAR"/>
         <column name="GROUP_PRINCIPALS_ACL" size="120" type="VARCHAR"/>
         <column name="PERMISSIONS_ACL" size="120" type="VARCHAR"/>
-		<foreign-key foreignTable="FOLDER" onDelete="cascade">
-			<reference foreign="FOLDER_ID" local="FOLDER_ID"/>
-		</foreign-key>
-		<index name="IX_FOLDER_SECURITY_CONSTRAINT_1">
-			<index-column name="FOLDER_ID"/>
-		</index>
+        <foreign-key foreignTable="FOLDER" onDelete="cascade">
+            <reference foreign="FOLDER_ID" local="FOLDER_ID"/>
+        </foreign-key>
+        <index name="IX_FOLDER_SECURITY_CONSTRAINT_1">
+            <index-column name="FOLDER_ID"/>
+        </index>
     </table>
 
     <table name="FOLDER_SECURITY_CONSTRAINTS_REF">
         <column name="CONSTRAINTS_REF_ID" primaryKey="true" required="true" type="INTEGER"/>
-		<column name="FOLDER_ID" type="INTEGER" required="true"/>
-		<column name="APPLY_ORDER" type="INTEGER" required="true"/>
+        <column name="FOLDER_ID" type="INTEGER" required="true"/>
+        <column name="APPLY_ORDER" type="INTEGER" required="true"/>
         <column name="NAME" size="40" type="VARCHAR" required="true"/>
-		<foreign-key foreignTable="FOLDER" onDelete="cascade">
-			<reference foreign="FOLDER_ID" local="FOLDER_ID"/>
-		</foreign-key>
-		<index name="IX_FOLDER_SECURITY_CONSTRAINTS_REF_1">
-			<index-column name="FOLDER_ID"/>
-		</index>
+        <foreign-key foreignTable="FOLDER" onDelete="cascade">
+            <reference foreign="FOLDER_ID" local="FOLDER_ID"/>
+        </foreign-key>
+        <index name="IX_FOLDER_SECURITY_CONSTRAINTS_REF_1">
+            <index-column name="FOLDER_ID"/>
+        </index>
     </table>
 
     <!--
@@ -113,7 +113,7 @@
 
     <table name="PAGE">
         <column name="PAGE_ID" primaryKey="true" required="true" type="INTEGER"/>
-		<column name="PARENT_ID" type="INTEGER" required="true"/>
+        <column name="PARENT_ID" type="INTEGER" required="true"/>
         <column name="PATH" required="true" size="160" type="VARCHAR"/>
         <column name="NAME" required="true" size="80" type="VARCHAR"/>
         <column name="TITLE" size="100" type="VARCHAR"/>
@@ -131,72 +131,72 @@
         <column name="EXT_ATTR_NAME" required="true" size="15" type="VARCHAR"/>
         <column name="EXT_ATTR_VALUE" required="true" size="40" type="VARCHAR"/>
         <column name="OWNER_PRINCIPAL" size="40" type="VARCHAR"/>
-		<foreign-key foreignTable="FOLDER" onDelete="cascade">
-			<reference foreign="FOLDER_ID" local="PARENT_ID"/>
-		</foreign-key>
-		<index name="IX_PAGE_1">
-			<index-column name="PARENT_ID"/>
-		</index>
-		<unique name="UN_PAGE_1">
-			<unique-column name="PATH"/>
-			<unique-column name="SUBSITE"/>
-			<unique-column name="USER_PRINCIPAL"/>
-			<unique-column name="ROLE_PRINCIPAL"/>
-			<unique-column name="GROUP_PRINCIPAL"/>
-			<unique-column name="MEDIATYPE"/>
-			<unique-column name="LOCALE"/>
-			<unique-column name="EXT_ATTR_NAME"/>
-			<unique-column name="EXT_ATTR_VALUE"/>
-		</unique>
+        <foreign-key foreignTable="FOLDER" onDelete="cascade">
+            <reference foreign="FOLDER_ID" local="PARENT_ID"/>
+        </foreign-key>
+        <index name="IX_PAGE_1">
+            <index-column name="PARENT_ID"/>
+        </index>
+        <unique name="UN_PAGE_1">
+            <unique-column name="PATH"/>
+            <unique-column name="SUBSITE"/>
+            <unique-column name="USER_PRINCIPAL"/>
+            <unique-column name="ROLE_PRINCIPAL"/>
+            <unique-column name="GROUP_PRINCIPAL"/>
+            <unique-column name="MEDIATYPE"/>
+            <unique-column name="LOCALE"/>
+            <unique-column name="EXT_ATTR_NAME"/>
+            <unique-column name="EXT_ATTR_VALUE"/>
+        </unique>
     </table>
     
     <table name="PAGE_METADATA">
         <column name="METADATA_ID" primaryKey="true" required="true" type="INTEGER"/>
-		<column name="PAGE_ID" type="INTEGER" required="true"/>
+        <column name="PAGE_ID" type="INTEGER" required="true"/>
         <column name="NAME" required="true" size="15" type="VARCHAR"/>
         <column name="LOCALE" required="true" size="20" type="VARCHAR"/>
         <column name="VALUE" required="true" size="100" type="VARCHAR"/>
-		<foreign-key foreignTable="PAGE" onDelete="cascade">
-			<reference foreign="PAGE_ID" local="PAGE_ID"/>
-		</foreign-key>
-		<index name="IX_PAGE_METADATA_1">
-			<index-column name="PAGE_ID"/>
-		</index>
-		<unique name="UN_PAGE_METADATA_1">
-			<unique-column name="PAGE_ID"/>
-			<unique-column name="NAME"/>
-			<unique-column name="LOCALE"/>
-			<unique-column name="VALUE"/>
-		</unique>
+        <foreign-key foreignTable="PAGE" onDelete="cascade">
+            <reference foreign="PAGE_ID" local="PAGE_ID"/>
+        </foreign-key>
+        <index name="IX_PAGE_METADATA_1">
+            <index-column name="PAGE_ID"/>
+        </index>
+        <unique name="UN_PAGE_METADATA_1">
+            <unique-column name="PAGE_ID"/>
+            <unique-column name="NAME"/>
+            <unique-column name="LOCALE"/>
+            <unique-column name="VALUE"/>
+        </unique>
     </table>
 
     <table name="PAGE_SECURITY_CONSTRAINT">
         <column name="CONSTRAINT_ID" primaryKey="true" required="true" type="INTEGER"/>
-		<column name="PAGE_ID" type="INTEGER" required="true"/>
-		<column name="APPLY_ORDER" type="INTEGER" required="true"/>
+        <column name="PAGE_ID" type="INTEGER" required="true"/>
+        <column name="APPLY_ORDER" type="INTEGER" required="true"/>
         <column name="USER_PRINCIPALS_ACL" size="120" type="VARCHAR"/>
         <column name="ROLE_PRINCIPALS_ACL" size="120" type="VARCHAR"/>
         <column name="GROUP_PRINCIPALS_ACL" size="120" type="VARCHAR"/>
         <column name="PERMISSIONS_ACL" size="120" type="VARCHAR"/>
-		<foreign-key foreignTable="PAGE" onDelete="cascade">
-			<reference foreign="PAGE_ID" local="PAGE_ID"/>
-		</foreign-key>
-		<index name="IX_PAGE_SECURITY_CONSTRAINT_1">
-			<index-column name="PAGE_ID"/>
-		</index>
+        <foreign-key foreignTable="PAGE" onDelete="cascade">
+            <reference foreign="PAGE_ID" local="PAGE_ID"/>
+        </foreign-key>
+        <index name="IX_PAGE_SECURITY_CONSTRAINT_1">
+            <index-column name="PAGE_ID"/>
+        </index>
     </table>
 
     <table name="PAGE_SECURITY_CONSTRAINTS_REF">
         <column name="CONSTRAINTS_REF_ID" primaryKey="true" required="true" type="INTEGER"/>
-		<column name="PAGE_ID" type="INTEGER" required="true"/>
-		<column name="APPLY_ORDER" type="INTEGER" required="true"/>
+        <column name="PAGE_ID" type="INTEGER" required="true"/>
+        <column name="APPLY_ORDER" type="INTEGER" required="true"/>
         <column name="NAME" size="40" type="VARCHAR" required="true"/>
-		<foreign-key foreignTable="PAGE" onDelete="cascade">
-			<reference foreign="PAGE_ID" local="PAGE_ID"/>
-		</foreign-key>
-		<index name="IX_PAGE_SECURITY_CONSTRAINTS_REF_1">
-			<index-column name="PAGE_ID"/>
-		</index>
+        <foreign-key foreignTable="PAGE" onDelete="cascade">
+            <reference foreign="PAGE_ID" local="PAGE_ID"/>
+        </foreign-key>
+        <index name="IX_PAGE_SECURITY_CONSTRAINTS_REF_1">
+            <index-column name="PAGE_ID"/>
+        </index>
     </table>
 
     <!--
@@ -205,8 +205,8 @@
 
     <table name="FRAGMENT">
         <column name="FRAGMENT_ID" primaryKey="true" required="true" type="INTEGER"/>
-		<column name="PARENT_ID" type="INTEGER"/>
-		<column name="PAGE_ID" type="INTEGER"/>
+        <column name="PARENT_ID" type="INTEGER"/>
+        <column name="PAGE_ID" type="INTEGER"/>
         <column name="NAME" size="100" type="VARCHAR"/>
         <column name="TITLE" size="100" type="VARCHAR"/>
         <column name="SHORT_TITLE" size="40" type="VARCHAR"/>
@@ -222,47 +222,47 @@
         <column name="EXT_PROP_NAME_2" size="40" type="VARCHAR"/>
         <column name="EXT_PROP_VALUE_2" size="80" type="VARCHAR"/>
         <column name="OWNER_PRINCIPAL" size="40" type="VARCHAR"/>
-		<foreign-key foreignTable="FRAGMENT" onDelete="cascade">
-			<reference foreign="FRAGMENT_ID" local="PARENT_ID"/>
-		</foreign-key>
-		<foreign-key foreignTable="PAGE" onDelete="cascade">
-			<reference foreign="PAGE_ID" local="PAGE_ID"/>
-		</foreign-key>
-		<index name="IX_FRAGMENT_1">
-			<index-column name="PARENT_ID"/>
-		</index>        
-		<unique name="UN_FRAGMENT_1">
-			<unique-column name="PAGE_ID"/>
-		</unique>
+        <foreign-key foreignTable="FRAGMENT" onDelete="cascade">
+            <reference foreign="FRAGMENT_ID" local="PARENT_ID"/>
+        </foreign-key>
+        <foreign-key foreignTable="PAGE" onDelete="cascade">
+            <reference foreign="PAGE_ID" local="PAGE_ID"/>
+        </foreign-key>
+        <index name="IX_FRAGMENT_1">
+            <index-column name="PARENT_ID"/>
+        </index>        
+        <unique name="UN_FRAGMENT_1">
+            <unique-column name="PAGE_ID"/>
+        </unique>
     </table>
 
     <table name="FRAGMENT_SECURITY_CONSTRAINT">
         <column name="CONSTRAINT_ID" primaryKey="true" required="true" type="INTEGER"/>
-		<column name="FRAGMENT_ID" type="INTEGER" required="true"/>
-		<column name="APPLY_ORDER" type="INTEGER" required="true"/>
+        <column name="FRAGMENT_ID" type="INTEGER" required="true"/>
+        <column name="APPLY_ORDER" type="INTEGER" required="true"/>
         <column name="USER_PRINCIPALS_ACL" size="120" type="VARCHAR"/>
         <column name="ROLE_PRINCIPALS_ACL" size="120" type="VARCHAR"/>
         <column name="GROUP_PRINCIPALS_ACL" size="120" type="VARCHAR"/>
         <column name="PERMISSIONS_ACL" size="120" type="VARCHAR"/>
-		<foreign-key foreignTable="FRAGMENT" onDelete="cascade">
-			<reference foreign="FRAGMENT_ID" local="FRAGMENT_ID"/>
-		</foreign-key>
-		<index name="IX_FRAGMENT_SECURITY_CONSTRAINT_1">
-			<index-column name="FRAGMENT_ID"/>
-		</index>
+        <foreign-key foreignTable="FRAGMENT" onDelete="cascade">
+            <reference foreign="FRAGMENT_ID" local="FRAGMENT_ID"/>
+        </foreign-key>
+        <index name="IX_FRAGMENT_SECURITY_CONSTRAINT_1">
+            <index-column name="FRAGMENT_ID"/>
+        </index>
     </table>
 
     <table name="FRAGMENT_SECURITY_CONSTRAINTS_REF">
         <column name="CONSTRAINTS_REF_ID" primaryKey="true" required="true" type="INTEGER"/>
-		<column name="FRAGMENT_ID" type="INTEGER" required="true"/>
-		<column name="APPLY_ORDER" type="INTEGER" required="true"/>
+        <column name="FRAGMENT_ID" type="INTEGER" required="true"/>
+        <column name="APPLY_ORDER" type="INTEGER" required="true"/>
         <column name="NAME" size="40" type="VARCHAR" required="true"/>
-		<foreign-key foreignTable="FRAGMENT" onDelete="cascade">
-			<reference foreign="FRAGMENT_ID" local="FRAGMENT_ID"/>
-		</foreign-key>
-		<index name="IX_FRAGMENT_SECURITY_CONSTRAINTS_REF_1">
-			<index-column name="FRAGMENT_ID"/>
-		</index>
+        <foreign-key foreignTable="FRAGMENT" onDelete="cascade">
+            <reference foreign="FRAGMENT_ID" local="FRAGMENT_ID"/>
+        </foreign-key>
+        <index name="IX_FRAGMENT_SECURITY_CONSTRAINTS_REF_1">
+            <index-column name="FRAGMENT_ID"/>
+        </index>
     </table>
 
     <!--
@@ -271,7 +271,7 @@
 
     <table name="PAGE_SECURITY">
         <column name="PAGE_SECURITY_ID" primaryKey="true" required="true" type="INTEGER"/>
-		<column name="PARENT_ID" type="INTEGER" required="true"/>
+        <column name="PARENT_ID" type="INTEGER" required="true"/>
         <column name="PATH" required="true" size="160" type="VARCHAR"/>
         <column name="NAME" required="true" size="80" type="VARCHAR"/>
         <column name="SUBSITE" required="true" size="40" type="VARCHAR"/>
@@ -282,53 +282,53 @@
         <column name="LOCALE" required="true" size="20" type="VARCHAR"/>
         <column name="EXT_ATTR_NAME" required="true" size="15" type="VARCHAR"/>
         <column name="EXT_ATTR_VALUE" required="true" size="40" type="VARCHAR"/>
-		<foreign-key foreignTable="FOLDER" onDelete="cascade">
-			<reference foreign="FOLDER_ID" local="PARENT_ID"/>
-		</foreign-key>
-		<unique name="UN_PAGE_SECURITY_1">
-			<unique-column name="PARENT_ID"/>
-		</unique>
-		<unique name="UN_PAGE_SECURITY_2">
-			<unique-column name="PATH"/>
-			<unique-column name="SUBSITE"/>
-			<unique-column name="USER_PRINCIPAL"/>
-			<unique-column name="ROLE_PRINCIPAL"/>
-			<unique-column name="GROUP_PRINCIPAL"/>
-			<unique-column name="MEDIATYPE"/>
-			<unique-column name="LOCALE"/>
-			<unique-column name="EXT_ATTR_NAME"/>
-			<unique-column name="EXT_ATTR_VALUE"/>
-		</unique>
+        <foreign-key foreignTable="FOLDER" onDelete="cascade">
+            <reference foreign="FOLDER_ID" local="PARENT_ID"/>
+        </foreign-key>
+        <unique name="UN_PAGE_SECURITY_1">
+            <unique-column name="PARENT_ID"/>
+        </unique>
+        <unique name="UN_PAGE_SECURITY_2">
+            <unique-column name="PATH"/>
+            <unique-column name="SUBSITE"/>
+            <unique-column name="USER_PRINCIPAL"/>
+            <unique-column name="ROLE_PRINCIPAL"/>
+            <unique-column name="GROUP_PRINCIPAL"/>
+            <unique-column name="MEDIATYPE"/>
+            <unique-column name="LOCALE"/>
+            <unique-column name="EXT_ATTR_NAME"/>
+            <unique-column name="EXT_ATTR_VALUE"/>
+        </unique>
     </table>
     
     <table name="PAGE_SECURITY_SECURITY_CONSTRAINTS_DEF">
         <column name="CONSTRAINTS_DEF_ID" primaryKey="true" required="true" type="INTEGER"/>
-		<column name="PAGE_SECURITY_ID" type="INTEGER" required="true"/>
+        <column name="PAGE_SECURITY_ID" type="INTEGER" required="true"/>
         <column name="NAME" required="true" size="40" type="VARCHAR"/>
-		<column name="APPLY_ORDER" type="INTEGER" required="true"/>
+        <column name="APPLY_ORDER" type="INTEGER" required="true"/>
         <column name="USER_PRINCIPALS_ACL" size="120" type="VARCHAR"/>
         <column name="ROLE_PRINCIPALS_ACL" size="120" type="VARCHAR"/>
         <column name="GROUP_PRINCIPALS_ACL" size="120" type="VARCHAR"/>
         <column name="PERMISSIONS_ACL" size="120" type="VARCHAR"/>
-		<foreign-key foreignTable="PAGE_SECURITY" onDelete="cascade">
-			<reference foreign="PAGE_SECURITY_ID" local="PAGE_SECURITY_ID"/>
-		</foreign-key>
-		<index name="IX_PAGE_SECURITY_CONSTRAINT_1">
-			<index-column name="PAGE_SECURITY_ID"/>
-		</index>
+        <foreign-key foreignTable="PAGE_SECURITY" onDelete="cascade">
+            <reference foreign="PAGE_SECURITY_ID" local="PAGE_SECURITY_ID"/>
+        </foreign-key>
+        <index name="IX_PAGE_SECURITY_SECURITY_CONSTRAINTS_DEF_1">
+            <index-column name="PAGE_SECURITY_ID"/>
+        </index>
     </table>
 
     <table name="PAGE_SECURITY_GLOBAL_SECURITY_CONSTRAINTS_REF">
         <column name="CONSTRAINTS_REF_ID" primaryKey="true" required="true" type="INTEGER"/>
-		<column name="PAGE_SECURITY_ID" type="INTEGER" required="true"/>
-		<column name="APPLY_ORDER" type="INTEGER" required="true"/>
+        <column name="PAGE_SECURITY_ID" type="INTEGER" required="true"/>
+        <column name="APPLY_ORDER" type="INTEGER" required="true"/>
         <column name="NAME" size="40" type="VARCHAR" required="true"/>
-		<foreign-key foreignTable="PAGE_SECURITY" onDelete="cascade">
-			<reference foreign="PAGE_SECURITY_ID" local="PAGE_SECURITY_ID"/>
-		</foreign-key>
-		<index name="IX_PAGE_SECURITY_SECURITY_CONSTRAINTS_REF_1">
-			<index-column name="PAGE_SECURITY_ID"/>
-		</index>
+        <foreign-key foreignTable="PAGE_SECURITY" onDelete="cascade">
+            <reference foreign="PAGE_SECURITY_ID" local="PAGE_SECURITY_ID"/>
+        </foreign-key>
+        <index name="IX_PAGE_SECURITY_GLOBAL_SECURITY_CONSTRAINTS_REF_1">
+            <index-column name="PAGE_SECURITY_ID"/>
+        </index>
     </table>
 
     <!--
@@ -365,7 +365,7 @@
         <column name="LOCATOR_NAME" primaryKey="true" required="true" size="80" type="VARCHAR"/>
         <column name="RULE_ID" required="true" size="80" type="VARCHAR"/>
     </table>
-        	    
+                
     <table name="PROFILE_PAGE_ASSOC">
         <column name="LOCATOR_HASH" required="true" size="40" type="VARCHAR"/>
         <column name="PAGE_ID" required="true" size="80" type="VARCHAR"/>

Modified: portals/jetspeed-2/trunk/etc/sql/drop.sql
URL: http://svn.apache.org/viewcvs/portals/jetspeed-2/trunk/etc/sql/drop.sql?rev=331694&r1=331693&r2=331694&view=diff
==============================================================================
--- portals/jetspeed-2/trunk/etc/sql/drop.sql (original)
+++ portals/jetspeed-2/trunk/etc/sql/drop.sql Mon Nov  7 21:44:18 2005
@@ -16,7 +16,7 @@
 DROP TABLE MEDIATYPE_TO_CAPABILITY;
 DROP TABLE MEDIATYPE_TO_MIMETYPE;
 
-DROP TABLE PAGE_SECURITY_SECURITY_GLOBAL_CONSTRAINTS_REF;
+DROP TABLE PAGE_SECURITY_GLOBAL_SECURITY_CONSTRAINTS_REF;
 DROP TABLE PAGE_SECURITY_SECURITY_CONSTRAINTS_DEF;
 DROP TABLE PAGE_SECURITY;
 DROP TABLE FRAGMENT_SECURITY_CONSTRAINTS_REF;
@@ -69,4 +69,4 @@
 drop table SECURITY_PRINCIPAL;
 drop table PORTLET_STATISTICS;
 drop table PAGE_STATISTICS;
-drop table USER_STATISTICS;
\ No newline at end of file
+drop table USER_STATISTICS;

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=331694&r1=331693&r2=331694&view=diff
==============================================================================
--- portals/jetspeed-2/trunk/etc/sql/oracle/drop.sql (original)
+++ portals/jetspeed-2/trunk/etc/sql/oracle/drop.sql Mon Nov  7 21:44:18 2005
@@ -21,7 +21,7 @@
 DROP TABLE MEDIATYPE_TO_CAPABILITY;
 DROP TABLE MEDIATYPE_TO_MIMETYPE;
 
-DROP TABLE PAGE_SECURITY_SECURITY_GLOBAL_CONSTRAINTS_REF;
+DROP TABLE PAGE_SECURITY_GLOBAL_SECURITY_CONSTRAINTS_REF;
 DROP TABLE PAGE_SECURITY_SECURITY_CONSTRAINTS_DEF;
 DROP TABLE PAGE_SECURITY;
 DROP TABLE FRAGMENT_SECURITY_CONSTRAINTS_REF;



---------------------------------------------------------------------
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