portals-jetspeed-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From rwat...@apache.org
Subject svn commit: r345136 - /portals/jetspeed-2/trunk/etc/sql/derby/schema/phase2-schema.sql
Date Wed, 16 Nov 2005 22:12:00 GMT
Author: rwatler
Date: Wed Nov 16 14:11:58 2005
New Revision: 345136

URL: http://svn.apache.org/viewcvs?rev=345136&view=rev
Log:
add plain index to replace unique index on nullable column: FRAGMENT.PAGE_ID must be nullable

Modified:
    portals/jetspeed-2/trunk/etc/sql/derby/schema/phase2-schema.sql

Modified: portals/jetspeed-2/trunk/etc/sql/derby/schema/phase2-schema.sql
URL: http://svn.apache.org/viewcvs/portals/jetspeed-2/trunk/etc/sql/derby/schema/phase2-schema.sql?rev=345136&r1=345135&r2=345136&view=diff
==============================================================================
--- portals/jetspeed-2/trunk/etc/sql/derby/schema/phase2-schema.sql (original)
+++ portals/jetspeed-2/trunk/etc/sql/derby/schema/phase2-schema.sql Wed Nov 16 14:11:58 2005
@@ -199,10 +199,11 @@
         ON DELETE CASCADE 
 
 -- Derby doesn't support UNIQUE constraints on nullable columns !!!  
---,   UNIQUE (PAGE_ID)
+-- replace UNIQUE (PAGE_ID) with IX_FRAGMENT_UNIQUE_PAGE_ID index below...
   );
 
 CREATE  INDEX IX_FRAGMENT_1 ON FRAGMENT (PARENT_ID);
+CREATE  INDEX IX_FRAGMENT_UNIQUE_PAGE_ID ON FRAGMENT (PAGE_ID);
 -----------------------------------------------------------------------------
 -- 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