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 at...@apache.org on 2007/12/22 00:36:26 UTC
svn commit: r606343 -
/portals/jetspeed-2/branches/JETSPEED-2.1.3/etc/sql/derby/schema/prefs-schema.sql
Author: ate
Date: Fri Dec 21 15:36:24 2007
New Revision: 606343
URL: http://svn.apache.org/viewvc?rev=606343&view=rev
Log:
I missed one DELETE CASCADE update on Derby sql for JS2-786
Modified:
portals/jetspeed-2/branches/JETSPEED-2.1.3/etc/sql/derby/schema/prefs-schema.sql
Modified: portals/jetspeed-2/branches/JETSPEED-2.1.3/etc/sql/derby/schema/prefs-schema.sql
URL: http://svn.apache.org/viewvc/portals/jetspeed-2/branches/JETSPEED-2.1.3/etc/sql/derby/schema/prefs-schema.sql?rev=606343&r1=606342&r2=606343&view=diff
==============================================================================
--- portals/jetspeed-2/branches/JETSPEED-2.1.3/etc/sql/derby/schema/prefs-schema.sql (original)
+++ portals/jetspeed-2/branches/JETSPEED-2.1.3/etc/sql/derby/schema/prefs-schema.sql Fri Dec 21 15:36:24 2007
@@ -27,7 +27,8 @@
CREATION_DATE TIMESTAMP,
MODIFIED_DATE TIMESTAMP,
PRIMARY KEY(NODE_ID),
- FOREIGN KEY (PARENT_NODE_ID) REFERENCES PREFS_NODE (NODE_ID)
+ FOREIGN KEY (PARENT_NODE_ID) REFERENCES PREFS_NODE (NODE_ID)
+ ON DELETE CASCADE
);
CREATE INDEX IX_PREFS_NODE_1 ON PREFS_NODE (PARENT_NODE_ID);
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-dev-help@portals.apache.org