portals-jetspeed-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From tay...@apache.org
Subject svn commit: r499103 - /portals/jetspeed-1/trunk/src/sql/external/turbine-postgres.sql
Date Tue, 23 Jan 2007 19:26:17 GMT
Author: taylor
Date: Tue Jan 23 11:26:16 2007
New Revision: 499103

URL: http://svn.apache.org/viewvc?view=rev&rev=499103
Log:
missing delete cascade constraints

Modified:
    portals/jetspeed-1/trunk/src/sql/external/turbine-postgres.sql

Modified: portals/jetspeed-1/trunk/src/sql/external/turbine-postgres.sql
URL: http://svn.apache.org/viewvc/portals/jetspeed-1/trunk/src/sql/external/turbine-postgres.sql?view=diff&rev=499103&r1=499102&r2=499103
==============================================================================
--- portals/jetspeed-1/trunk/src/sql/external/turbine-postgres.sql (original)
+++ portals/jetspeed-1/trunk/src/sql/external/turbine-postgres.sql Tue Jan 23 11:26:16 2007
@@ -84,8 +84,8 @@
     ROLE_ID integer NOT NULL,
     PERMISSION_ID integer NOT NULL,
     PRIMARY KEY(ROLE_ID,PERMISSION_ID),
-    FOREIGN KEY (ROLE_ID) REFERENCES TURBINE_ROLE (ROLE_ID),
-    FOREIGN KEY (PERMISSION_ID) REFERENCES TURBINE_PERMISSION (PERMISSION_ID)
+    FOREIGN KEY (ROLE_ID) REFERENCES TURBINE_ROLE (ROLE_ID) ON DELETE CASCADE,
+    FOREIGN KEY (PERMISSION_ID) REFERENCES TURBINE_PERMISSION (PERMISSION_ID) ON DELETE CASCADE
 );
 create  INDEX ROLE_PERMISSION_INDEX ON TURBINE_ROLE_PERMISSION (ROLE_ID, PERMISSION_ID);
 
@@ -121,9 +121,9 @@
     GROUP_ID integer NOT NULL,
     ROLE_ID integer NOT NULL,
     PRIMARY KEY(USER_ID,GROUP_ID,ROLE_ID),
-    FOREIGN KEY (USER_ID) REFERENCES TURBINE_USER (USER_ID),
-    FOREIGN KEY (GROUP_ID) REFERENCES TURBINE_GROUP (GROUP_ID),
-    FOREIGN KEY (ROLE_ID) REFERENCES TURBINE_ROLE (ROLE_ID)
+    FOREIGN KEY (USER_ID) REFERENCES TURBINE_USER (USER_ID) ON DELETE CASCADE,
+    FOREIGN KEY (GROUP_ID) REFERENCES TURBINE_GROUP (GROUP_ID) ON DELETE CASCADE,
+    FOREIGN KEY (ROLE_ID) REFERENCES TURBINE_ROLE (ROLE_ID) ON DELETE CASCADE
 );
 create  INDEX USER_GROUP_ROLE_INDEX ON TURBINE_USER_GROUP_ROLE (USER_ID, GROUP_ID, ROLE_ID);
 



---------------------------------------------------------------------
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