portals-jetspeed-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From rwat...@apache.org
Subject svn commit: r332332 - in /portals/jetspeed-2/trunk/etc: schema/phase2-schema.xml sql/drop.sql sql/oracle/drop.sql
Date Thu, 10 Nov 2005 17:05:52 GMT
Author: rwatler
Date: Thu Nov 10 09:05:49 2005
New Revision: 332332

URL: http://svn.apache.org/viewcvs?rev=332332&view=rev
Log:
shorten PAGE_SECURITY_CONSTRAINTS_[DEF|REF] table names: oracle+torque has an effective 25
characater limit on table names, (oracle at 30 and torque appends '_FK_'+N)

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=332332&r1=332331&r2=332332&view=diff
==============================================================================
--- portals/jetspeed-2/trunk/etc/schema/phase2-schema.xml (original)
+++ portals/jetspeed-2/trunk/etc/schema/phase2-schema.xml Thu Nov 10 09:05:49 2005
@@ -279,7 +279,7 @@
         </unique>
     </table>
     
-    <table name="PAGE_SECURITY_CONSTRAINTS_DEF">
+    <table name="PAGE_SEC_CONSTRAINTS_DEF">
         <column name="CONSTRAINTS_DEF_ID" primaryKey="true" required="true" type="INTEGER"/>
         <column name="PAGE_SECURITY_ID" type="INTEGER" required="true"/>
         <column name="NAME" required="true" size="40" type="VARCHAR"/>
@@ -296,7 +296,7 @@
         </index>
     </table>
 
-    <table name="PAGE_SECURITY_CONSTRAINTS_REF">
+    <table name="PAGE_SEC_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"/>

Modified: portals/jetspeed-2/trunk/etc/sql/drop.sql
URL: http://svn.apache.org/viewcvs/portals/jetspeed-2/trunk/etc/sql/drop.sql?rev=332332&r1=332331&r2=332332&view=diff
==============================================================================
--- portals/jetspeed-2/trunk/etc/sql/drop.sql (original)
+++ portals/jetspeed-2/trunk/etc/sql/drop.sql Thu Nov 10 09:05:49 2005
@@ -16,8 +16,8 @@
 DROP TABLE MEDIATYPE_TO_CAPABILITY;
 DROP TABLE MEDIATYPE_TO_MIMETYPE;
 
-DROP TABLE PAGE_SECURITY_CONSTRAINTS_REF;
-DROP TABLE PAGE_SECURITY_CONSTRAINTS_DEF;
+DROP TABLE PAGE_SEC_CONSTRAINTS_REF;
+DROP TABLE PAGE_SEC_CONSTRAINTS_DEF;
 DROP TABLE PAGE_SECURITY;
 DROP TABLE FRAGMENT_CONSTRAINTS_REF;
 DROP TABLE FRAGMENT_CONSTRAINT;

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=332332&r1=332331&r2=332332&view=diff
==============================================================================
--- portals/jetspeed-2/trunk/etc/sql/oracle/drop.sql (original)
+++ portals/jetspeed-2/trunk/etc/sql/oracle/drop.sql Thu Nov 10 09:05:49 2005
@@ -21,8 +21,8 @@
 DROP TABLE MEDIATYPE_TO_CAPABILITY;
 DROP TABLE MEDIATYPE_TO_MIMETYPE;
 
-DROP TABLE PAGE_SECURITY_CONSTRAINTS_REF;
-DROP TABLE PAGE_SECURITY_CONSTRAINTS_DEF;
+DROP TABLE PAGE_SEC_CONSTRAINTS_REF;
+DROP TABLE PAGE_SEC_CONSTRAINTS_DEF;
 DROP TABLE PAGE_SECURITY;
 DROP TABLE FRAGMENT_CONSTRAINTS_REF;
 DROP TABLE FRAGMENT_CONSTRAINT;



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