You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jetspeed-dev@portals.apache.org by rw...@apache.org on 2005/11/16 23:12:00 UTC
svn commit: r345136 -
/portals/jetspeed-2/trunk/etc/sql/derby/schema/phase2-schema.sql
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