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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
