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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
