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 2007/01/23 20:26:17 UTC
svn commit: r499103 -
/portals/jetspeed-1/trunk/src/sql/external/turbine-postgres.sql
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