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 ta...@apache.org on 2006/07/28 21:47:53 UTC
svn commit: r426654 -
/portals/jetspeed-1/trunk/src/sql/external/turbine-db2.sql
Author: taylor
Date: Fri Jul 28 12:47:53 2006
New Revision: 426654
URL: http://svn.apache.org/viewvc?rev=426654&view=rev
Log:
db2 supports declarative cascading deletes, might as well use em
Modified:
portals/jetspeed-1/trunk/src/sql/external/turbine-db2.sql
Modified: portals/jetspeed-1/trunk/src/sql/external/turbine-db2.sql
URL: http://svn.apache.org/viewvc/portals/jetspeed-1/trunk/src/sql/external/turbine-db2.sql?rev=426654&r1=426653&r2=426654&view=diff
==============================================================================
--- portals/jetspeed-1/trunk/src/sql/external/turbine-db2.sql (original)
+++ portals/jetspeed-1/trunk/src/sql/external/turbine-db2.sql Fri Jul 28 12:47:53 2006
@@ -114,14 +114,10 @@
ALTER TABLE TURBINE_ROLE_PERMISSION
ADD CONSTRAINT TURBINE_ROLE__FK_1 FOREIGN KEY (ROLE_ID)
- REFERENCES TURBINE_ROLE (ROLE_ID)
-;
+ REFERENCES TURBINE_ROLE (ROLE_ID) ON DELETE CASCADE;
ALTER TABLE TURBINE_ROLE_PERMISSION
ADD CONSTRAINT TURBINE_ROLE__FK_2 FOREIGN KEY (PERMISSION_ID)
- REFERENCES TURBINE_PERMISSION (PERMISSION_ID)
-;
-
-
+ REFERENCES TURBINE_PERMISSION (PERMISSION_ID) ON DELETE CASCADE;
-----------------------------------------------------------------------------
-- TURBINE_USER_GROUP_ROLE
@@ -140,16 +136,13 @@
ALTER TABLE TURBINE_USER_GROUP_ROLE
ADD CONSTRAINT TURBINE_USER__FK_1 FOREIGN KEY (USER_ID)
- REFERENCES TURBINE_USER (USER_ID)
-;
+ REFERENCES TURBINE_USER (USER_ID) ON DELETE CASCADE;
ALTER TABLE TURBINE_USER_GROUP_ROLE
ADD CONSTRAINT TURBINE_USER__FK_2 FOREIGN KEY (GROUP_ID)
- REFERENCES TURBINE_GROUP (GROUP_ID)
-;
+ REFERENCES TURBINE_GROUP (GROUP_ID) ON DELETE CASCADE;
ALTER TABLE TURBINE_USER_GROUP_ROLE
ADD CONSTRAINT TURBINE_USER__FK_3 FOREIGN KEY (ROLE_ID)
- REFERENCES TURBINE_ROLE (ROLE_ID)
-;
+ REFERENCES TURBINE_ROLE (ROLE_ID) ON DELETE CASCADE;
-----------------------------------------------------------------------------
-- JETSPEED_USER_PROFILE
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-dev-help@portals.apache.org