portals-jetspeed-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From tay...@apache.org
Subject svn commit: r426654 - /portals/jetspeed-1/trunk/src/sql/external/turbine-db2.sql
Date Fri, 28 Jul 2006 19:47:53 GMT
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


Mime
View raw message