Author: rogerrut
Date: Tue Dec 6 15:01:19 2005
New Revision: 354601
URL: http://svn.apache.org/viewcvs?rev=354601&view=rev
Log:
Updated Derby schema for SSO changes since derby is not supported by Torque
Modified:
portals/jetspeed-2/trunk/etc/sql/derby/schema/security-schema.sql
Modified: portals/jetspeed-2/trunk/etc/sql/derby/schema/security-schema.sql
URL:
http://svn.apache.org/viewcvs/portals/jetspeed-2/trunk/etc/sql/derby/schema/security-schema.sql?rev=354601&r1=354600&r2=354601&view=diff
==============================================================================
--- portals/jetspeed-2/trunk/etc/sql/derby/schema/security-schema.sql (original)
+++ portals/jetspeed-2/trunk/etc/sql/derby/schema/security-schema.sql Tue Dec
6 15:01:19 2005
@@ -156,8 +156,8 @@
(
COOKIE_ID INTEGER NOT NULL,
REMOTE_PRINCIPAL_ID INTEGER NOT NULL,
- PRIMARY KEY(SITE_ID,REMOTE_PRINCIPAL_ID),
- FOREIGN KEY (SITE_ID) REFERENCES SSO_SITE (SITE_ID)
+ PRIMARY KEY(COOKIE_ID,REMOTE_PRINCIPAL_ID),
+ FOREIGN KEY (COOKIE_ID) REFERENCES SSO_COOKIE (COOKIE_ID)
ON DELETE CASCADE
,
FOREIGN KEY (REMOTE_PRINCIPAL_ID) REFERENCES SECURITY_PRINCIPAL
(PRINCIPAL_ID)
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
