portals-jetspeed-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From rwat...@apache.org
Subject svn commit: r331748 - in /portals/jetspeed-2/trunk: components/page-manager/src/java/JETSPEED-INF/ojb/ components/page-manager/src/test/org/apache/jetspeed/page/ etc/schema/ etc/sql/ etc/sql/oracle/
Date Tue, 08 Nov 2005 09:09:37 GMT
Author: rwatler
Date: Tue Nov  8 01:09:31 2005
New Revision: 331748

URL: http://svn.apache.org/viewcvs?rev=331748&view=rev
Log:
Shorten DDL table/column names for Oracle; remove compound keys for Page, Folder, and PageSecurity,
restoring PATH as primary lookup key; comment out portions of test case to be replaced by
this key modification

Modified:
    portals/jetspeed-2/trunk/components/page-manager/src/java/JETSPEED-INF/ojb/page-manager-repository.xml
    portals/jetspeed-2/trunk/components/page-manager/src/test/org/apache/jetspeed/page/TestDatabasePageManager.java
    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/components/page-manager/src/java/JETSPEED-INF/ojb/page-manager-repository.xml
URL: http://svn.apache.org/viewcvs/portals/jetspeed-2/trunk/components/page-manager/src/java/JETSPEED-INF/ojb/page-manager-repository.xml?rev=331748&r1=331747&r2=331748&view=diff
==============================================================================
--- portals/jetspeed-2/trunk/components/page-manager/src/java/JETSPEED-INF/ojb/page-manager-repository.xml
(original)
+++ portals/jetspeed-2/trunk/components/page-manager/src/java/JETSPEED-INF/ojb/page-manager-repository.xml
Tue Nov  8 01:09:31 2005
@@ -249,11 +249,11 @@
 
    <class-descriptor
       class="org.apache.jetspeed.om.folder.impl.FolderSecurityConstraint"
-      table="FOLDER_SECURITY_CONSTRAINT"
+      table="FOLDER_CNSTRNT"
    >
       <field-descriptor
          name="id"
-         column="CONSTRAINT_ID"
+         column="CNSTRNT_ID"
          jdbc-type="INTEGER"
          primarykey="true"
          autoincrement="true"
@@ -303,11 +303,11 @@
 
    <class-descriptor
       class="org.apache.jetspeed.om.folder.impl.FolderSecurityConstraintsRef"
-      table="FOLDER_SECURITY_CONSTRAINTS_REF"
+      table="FOLDER_CNSTRNTS_REF"
    >
       <field-descriptor
          name="id"
-         column="CONSTRAINTS_REF_ID"
+         column="CNSTRNTS_REF_ID"
          jdbc-type="INTEGER"
          primarykey="true"
          autoincrement="true"
@@ -554,11 +554,11 @@
 
    <class-descriptor
       class="org.apache.jetspeed.om.page.impl.PageSecurityConstraint"
-      table="PAGE_SECURITY_CONSTRAINT"
+      table="PAGE_CNSTRNT"
    >
       <field-descriptor
          name="id"
-         column="CONSTRAINT_ID"
+         column="CNSTRNT_ID"
          jdbc-type="INTEGER"
          primarykey="true"
          autoincrement="true"
@@ -608,11 +608,11 @@
 
    <class-descriptor
       class="org.apache.jetspeed.om.page.impl.PageSecurityConstraintsRef"
-      table="PAGE_SECURITY_CONSTRAINTS_REF"
+      table="PAGE_CNSTRNTS_REF"
    >
       <field-descriptor
          name="id"
-         column="CONSTRAINTS_REF_ID"
+         column="CNSTRNTS_REF_ID"
          jdbc-type="INTEGER"
          primarykey="true"
          autoincrement="true"
@@ -793,11 +793,11 @@
 
    <class-descriptor
       class="org.apache.jetspeed.om.page.impl.FragmentSecurityConstraint"
-      table="FRAGMENT_SECURITY_CONSTRAINT"
+      table="FRAGMENT_CNSTRNT"
    >
       <field-descriptor
          name="id"
-         column="CONSTRAINT_ID"
+         column="CNSTRNT_ID"
          jdbc-type="INTEGER"
          primarykey="true"
          autoincrement="true"
@@ -847,11 +847,11 @@
 
    <class-descriptor
       class="org.apache.jetspeed.om.page.impl.FragmentSecurityConstraintsRef"
-      table="FRAGMENT_SECURITY_CONSTRAINTS_REF"
+      table="FRAGMENT_CNSTRNTS_REF"
    >
       <field-descriptor
          name="id"
-         column="CONSTRAINTS_REF_ID"
+         column="CNSTRNTS_REF_ID"
          jdbc-type="INTEGER"
          primarykey="true"
          autoincrement="true"
@@ -881,11 +881,11 @@
 
    <class-descriptor
       class="org.apache.jetspeed.om.page.impl.PageSecurityImpl"
-      table="PAGE_SECURITY"
+      table="PAGE_SEC"
    >
       <field-descriptor
          name="id"
-         column="PAGE_SECURITY_ID"
+         column="PAGE_SEC_ID"
          jdbc-type="INTEGER"
          primarykey="true"
          autoincrement="true"
@@ -995,11 +995,11 @@
 
    <class-descriptor
       class="org.apache.jetspeed.om.page.impl.PageSecuritySecurityConstraintsDef"
-      table="PAGE_SECURITY_SECURITY_CONSTRAINTS_DEF"
+      table="PAGE_SEC_CNSTRNTS_DEF"
    >
       <field-descriptor
          name="id"
-         column="CONSTRAINTS_DEF_ID"
+         column="CNSTRNTS_DEF_ID"
          jdbc-type="INTEGER"
          primarykey="true"
          autoincrement="true"
@@ -1007,7 +1007,7 @@
 
       <field-descriptor
         name="pageSecurityId"
-        column="PAGE_SECURITY_ID"
+        column="PAGE_SEC_ID"
         jdbc-type="INTEGER"
         access="anonymous"
       />
@@ -1055,11 +1055,11 @@
 
    <class-descriptor
       class="org.apache.jetspeed.om.page.impl.PageSecurityGlobalSecurityConstraintsRef"
-      table="PAGE_SECURITY_GLOBAL_SECURITY_CONSTRAINTS_REF"
+      table="PAGE_SEC_CNSTRNTS_REF"
    >
       <field-descriptor
          name="id"
-         column="CONSTRAINTS_REF_ID"
+         column="CNSTRNTS_REF_ID"
          jdbc-type="INTEGER"
          primarykey="true"
          autoincrement="true"
@@ -1067,7 +1067,7 @@
 
       <field-descriptor
         name="pageSecurityId"
-        column="PAGE_SECURITY_ID"
+        column="PAGE_SEC_ID"
         jdbc-type="INTEGER"
         access="anonymous"
       />

Modified: portals/jetspeed-2/trunk/components/page-manager/src/test/org/apache/jetspeed/page/TestDatabasePageManager.java
URL: http://svn.apache.org/viewcvs/portals/jetspeed-2/trunk/components/page-manager/src/test/org/apache/jetspeed/page/TestDatabasePageManager.java?rev=331748&r1=331747&r2=331748&view=diff
==============================================================================
--- portals/jetspeed-2/trunk/components/page-manager/src/test/org/apache/jetspeed/page/TestDatabasePageManager.java
(original)
+++ portals/jetspeed-2/trunk/components/page-manager/src/test/org/apache/jetspeed/page/TestDatabasePageManager.java
Tue Nov  8 01:09:31 2005
@@ -44,8 +44,10 @@
  */
 public class TestDatabasePageManager extends AbstractSpringTestCase
 {
+    /*
     private String testAttributesPath = "/__subsite-rootX/_user/userX/_role/roleX/_group/groupX/_mediatype/xhtml/_language/en/_country/us/_custom/customX";
     private String verifyTestAttributesPath = "/__subsite-rootx/_user/userx/_role/rolex/_group/groupx/_mediatype/xhtml/_language/en/_country/us/_custom/customx";
+    */
 
     private PageManager pageManager;
     
@@ -229,6 +231,7 @@
             {
             }
 
+            /*
             // test folder/page creation with attributes
             folder = pageManager.newFolder(testAttributesPath);
             pageManager.updateFolder(folder);
@@ -239,6 +242,7 @@
 
             assertNotNull(page.getParent());
             assertEquals(page.getParent().getId(), folder.getId());
+            */
         }
         catch (Exception e)
         {
@@ -345,6 +349,7 @@
             {
                 assertTrue("Folder / NOT FOUND", false);
             }
+            /*
             try
             {
                 Page check = pageManager.getPage(testAttributesPath + "/default-page.psml");
@@ -363,6 +368,7 @@
             {
                 assertTrue("Folder " + testAttributesPath + " NOT FOUND", false);
             }
+            */
         }
         catch (Exception e)
         {
@@ -389,6 +395,7 @@
             {
                 assertTrue("Folder / NOT FOUND", false);
             }
+            /*
             try
             {
                 Folder remove = pageManager.getFolder(testAttributesPath);
@@ -399,6 +406,7 @@
             {
                 assertTrue("Folder " + testAttributesPath + " NOT FOUND", false);
             }
+            */
 
             // reset page manager cache
             pageManager.reset();
@@ -412,6 +420,7 @@
             catch (FolderNotFoundException e)
             {
             }
+            /*
             try
             {
                 Folder check = pageManager.getFolder(testAttributesPath);
@@ -420,6 +429,7 @@
             catch (FolderNotFoundException e)
             {
             }
+            */
         }
         catch (Exception e)
         {

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=331748&r1=331747&r2=331748&view=diff
==============================================================================
--- portals/jetspeed-2/trunk/etc/schema/phase2-schema.xml (original)
+++ portals/jetspeed-2/trunk/etc/schema/phase2-schema.xml Tue Nov  8 01:09:31 2005
@@ -47,14 +47,6 @@
         </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>
     
@@ -78,8 +70,8 @@
         </unique>
     </table>
 
-    <table name="FOLDER_SECURITY_CONSTRAINT">
-        <column name="CONSTRAINT_ID" primaryKey="true" required="true" type="INTEGER"/>
+    <table name="FOLDER_CNSTRNT">
+        <column name="CNSTRNT_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="USER_PRINCIPALS_ACL" size="120" type="VARCHAR"/>
@@ -89,20 +81,20 @@
         <foreign-key foreignTable="FOLDER" onDelete="cascade">
             <reference foreign="FOLDER_ID" local="FOLDER_ID"/>
         </foreign-key>
-        <index name="IX_FOLDER_SECURITY_CONSTRAINT_1">
+        <index name="IX_FOLDER_CNSTRNT_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"/>
+    <table name="FOLDER_CNSTRNTS_REF">
+        <column name="CNSTRNTS_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="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 name="IX_FOLDER_CNSTRNTS_REF_1">
             <index-column name="FOLDER_ID"/>
         </index>
     </table>
@@ -139,14 +131,6 @@
         </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>
     
@@ -170,8 +154,8 @@
         </unique>
     </table>
 
-    <table name="PAGE_SECURITY_CONSTRAINT">
-        <column name="CONSTRAINT_ID" primaryKey="true" required="true" type="INTEGER"/>
+    <table name="PAGE_CNSTRNT">
+        <column name="CNSTRNT_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="USER_PRINCIPALS_ACL" size="120" type="VARCHAR"/>
@@ -181,20 +165,20 @@
         <foreign-key foreignTable="PAGE" onDelete="cascade">
             <reference foreign="PAGE_ID" local="PAGE_ID"/>
         </foreign-key>
-        <index name="IX_PAGE_SECURITY_CONSTRAINT_1">
+        <index name="IX_PAGE_CNSTRNT_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"/>
+    <table name="PAGE_CNSTRNTS_REF">
+        <column name="CNSTRNTS_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="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 name="IX_PAGE_CNSTRNTS_REF_1">
             <index-column name="PAGE_ID"/>
         </index>
     </table>
@@ -236,8 +220,8 @@
         </unique>
     </table>
 
-    <table name="FRAGMENT_SECURITY_CONSTRAINT">
-        <column name="CONSTRAINT_ID" primaryKey="true" required="true" type="INTEGER"/>
+    <table name="FRAGMENT_CNSTRNT">
+        <column name="CNSTRNT_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="USER_PRINCIPALS_ACL" size="120" type="VARCHAR"/>
@@ -247,20 +231,20 @@
         <foreign-key foreignTable="FRAGMENT" onDelete="cascade">
             <reference foreign="FRAGMENT_ID" local="FRAGMENT_ID"/>
         </foreign-key>
-        <index name="IX_FRAGMENT_SECURITY_CONSTRAINT_1">
+        <index name="IX_FRAGMENT_CNSTRNT_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"/>
+    <table name="FRAGMENT_CNSTRNTS_REF">
+        <column name="CNSTRNTS_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="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 name="IX_FRAGMENT_CNSTRNTS_REF_1">
             <index-column name="FRAGMENT_ID"/>
         </index>
     </table>
@@ -269,8 +253,8 @@
        Page Security Definition
     -->
 
-    <table name="PAGE_SECURITY">
-        <column name="PAGE_SECURITY_ID" primaryKey="true" required="true" type="INTEGER"/>
+    <table name="PAGE_SEC">
+        <column name="PAGE_SEC_ID" primaryKey="true" required="true" type="INTEGER"/>
         <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"/>
@@ -285,49 +269,41 @@
         <foreign-key foreignTable="FOLDER" onDelete="cascade">
             <reference foreign="FOLDER_ID" local="PARENT_ID"/>
         </foreign-key>
-        <unique name="UN_PAGE_SECURITY_1">
+        <unique name="UN_PAGE_SEC_1">
             <unique-column name="PARENT_ID"/>
         </unique>
-        <unique name="UN_PAGE_SECURITY_2">
+        <unique name="UN_PAGE_SEC_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"/>
+    <table name="PAGE_SEC_CNSTRNTS_DEF">
+        <column name="CNSTRNTS_DEF_ID" primaryKey="true" required="true" type="INTEGER"/>
+        <column name="PAGE_SEC_ID" type="INTEGER" required="true"/>
         <column name="NAME" required="true" size="40" type="VARCHAR"/>
         <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 foreignTable="PAGE_SEC" onDelete="cascade">
+            <reference foreign="PAGE_SEC_ID" local="PAGE_SEC_ID"/>
         </foreign-key>
-        <index name="IX_PAGE_SECURITY_SECURITY_CONSTRAINTS_DEF_1">
-            <index-column name="PAGE_SECURITY_ID"/>
+        <index name="IX_PAGE_SEC_CNSTRNTS_DEF_1">
+            <index-column name="PAGE_SEC_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"/>
+    <table name="PAGE_SEC_CNSTRNTS_REF">
+        <column name="CNSTRNTS_REF_ID" primaryKey="true" required="true" type="INTEGER"/>
+        <column name="PAGE_SEC_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 foreignTable="PAGE_SEC" onDelete="cascade">
+            <reference foreign="PAGE_SEC_ID" local="PAGE_SEC_ID"/>
         </foreign-key>
-        <index name="IX_PAGE_SECURITY_GLOBAL_SECURITY_CONSTRAINTS_REF_1">
-            <index-column name="PAGE_SECURITY_ID"/>
+        <index name="IX_PAGE_SEC_CNSTRNTS_REF_1">
+            <index-column name="PAGE_SEC_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=331748&r1=331747&r2=331748&view=diff
==============================================================================
--- portals/jetspeed-2/trunk/etc/sql/drop.sql (original)
+++ portals/jetspeed-2/trunk/etc/sql/drop.sql Tue Nov  8 01:09:31 2005
@@ -16,18 +16,18 @@
 DROP TABLE MEDIATYPE_TO_CAPABILITY;
 DROP TABLE MEDIATYPE_TO_MIMETYPE;
 
-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;
-DROP TABLE FRAGMENT_SECURITY_CONSTRAINT;
+DROP TABLE PAGE_SEC_CNSTRNTS_REF;
+DROP TABLE PAGE_SEC_CNSTRNTS_DEF;
+DROP TABLE PAGE_SEC;
+DROP TABLE FRAGMENT_CNSTRNTS_REF;
+DROP TABLE FRAGMENT_CNSTRNT;
 DROP TABLE FRAGMENT;
-DROP TABLE PAGE_SECURITY_CONSTRAINTS_REF;
-DROP TABLE PAGE_SECURITY_CONSTRAINT;
+DROP TABLE PAGE_CNSTRNTS_REF;
+DROP TABLE PAGE_CNSTRNT;
 DROP TABLE PAGE_METADATA;
 DROP TABLE PAGE;
-DROP TABLE FOLDER_SECURITY_CONSTRAINTS_REF;
-DROP TABLE FOLDER_SECURITY_CONSTRAINT;
+DROP TABLE FOLDER_CNSTRNTS_REF;
+DROP TABLE FOLDER_CNSTRNT;
 DROP TABLE FOLDER_METADATA;
 DROP TABLE FOLDER;
 

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=331748&r1=331747&r2=331748&view=diff
==============================================================================
--- portals/jetspeed-2/trunk/etc/sql/oracle/drop.sql (original)
+++ portals/jetspeed-2/trunk/etc/sql/oracle/drop.sql Tue Nov  8 01:09:31 2005
@@ -21,18 +21,18 @@
 DROP TABLE MEDIATYPE_TO_CAPABILITY;
 DROP TABLE MEDIATYPE_TO_MIMETYPE;
 
-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;
-DROP TABLE FRAGMENT_SECURITY_CONSTRAINT;
+DROP TABLE PAGE_SEC_CNSTRNTS_REF;
+DROP TABLE PAGE_SEC_CNSTRNTS_DEF;
+DROP TABLE PAGE_SEC;
+DROP TABLE FRAGMENT_CNSTRNTS_REF;
+DROP TABLE FRAGMENT_CNSTRNT;
 DROP TABLE FRAGMENT;
-DROP TABLE PAGE_SECURITY_CONSTRAINTS_REF;
-DROP TABLE PAGE_SECURITY_CONSTRAINT;
+DROP TABLE PAGE_CNSTRNTS_REF;
+DROP TABLE PAGE_CNSTRNT;
 DROP TABLE PAGE_METADATA;
 DROP TABLE PAGE;
-DROP TABLE FOLDER_SECURITY_CONSTRAINTS_REF;
-DROP TABLE FOLDER_SECURITY_CONSTRAINT;
+DROP TABLE FOLDER_CNSTRNTS_REF;
+DROP TABLE FOLDER_CNSTRNT;
 DROP TABLE FOLDER_METADATA;
 DROP TABLE FOLDER;
 



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