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 ro...@apache.org on 2004/12/04 23:21:34 UTC
cvs commit: jakarta-jetspeed-2/src/schema security-schema.xml
rogerrut 2004/12/04 14:21:34
Modified: src/schema security-schema.xml
Log:
Fix for SSO
Entries where not unique to a user/site which required an new association table (SSO_SITE_TO_REMOTE)
Re factored the code for the API to include the mapping table
Updated Unit test
Revision Changes Path
1.12 +11 -0 jakarta-jetspeed-2/src/schema/security-schema.xml
Index: security-schema.xml
===================================================================
RCS file: /home/cvs/jakarta-jetspeed-2/src/schema/security-schema.xml,v
retrieving revision 1.11
retrieving revision 1.12
diff -u -r1.11 -r1.12
--- security-schema.xml 3 Dec 2004 22:00:22 -0000 1.11
+++ security-schema.xml 4 Dec 2004 22:21:34 -0000 1.12
@@ -126,6 +126,17 @@
<reference foreign="PRINCIPAL_ID" local="REMOTE_PRINCIPAL_ID"/>
</foreign-key>
</table>
+
+ <table name="SSO_SITE_TO_REMOTE">
+ <column name="SITE_ID" primaryKey="true" required="true" type="INTEGER"/>
+ <column name="PRINCIPAL_ID" primaryKey="true" required="true" type="INTEGER"/>
+ <foreign-key foreignTable="SSO_SITE" onDelete="cascade">
+ <reference foreign="SITE_ID" local="SITE_ID"/>
+ </foreign-key>
+ <foreign-key foreignTable="SECURITY_PRINCIPAL" onDelete="cascade">
+ <reference foreign="PRINCIPAL_ID" local="PRINCIPAL_ID"/>
+ </foreign-key>
+ </table>
<!--
Create Security User Role Table
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-dev-help@jakarta.apache.org