rogerrut 2004/11/21 22:12:46
Modified: src/schema security-schema.xml
Log:
Implemented SSO API except for addBasicAuthenticationForSite()
Completed Unit Test for SSO
Revision Changes Path
1.8 +17 -6 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.7
retrieving revision 1.8
diff -u -r1.7 -r1.8
--- security-schema.xml 16 Nov 2004 19:01:26 -0000 1.7
+++ security-schema.xml 22 Nov 2004 06:12:46 -0000 1.8
@@ -27,17 +27,28 @@
-->
<table name="SSO_SITE_TO_CREDENTIALS">
- <column name="SITE_ID" required="true" type="INTEGER"/>
- <column name="PRINCIPAL_ID" required="true" type="INTEGER"/>
- <column name="CREDENTIAL_ID" required="true" type="INTEGER"/>
+ <column name="SITE_ID" primaryKey="true" required="true"
type="INTEGER"/>
+ <column name="CREDENTIAL_ID" primaryKey="true" required="true"
type="INTEGER"/>
<foreign-key foreignTable="SSO_SITE">
<reference foreign="SITE_ID" local="SITE_ID"/>
</foreign-key>
- <foreign-key foreignTable="SECURITY_PRINCIPAL">
- <reference foreign="PRINCIPAL_ID" local="PRINCIPAL_ID"/>
- </foreign-key>
<foreign-key foreignTable="SECURITY_CREDENTIAL">
<reference foreign="CREDENTIAL_ID" local="CREDENTIAL_ID"/>
+ </foreign-key>
+ </table>
+
+ <!--
+ Create Site to Principals association Table
+ -->
+
+ <table name="SSO_SITE_TO_PRINCIPALS">
+ <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">
+ <reference foreign="SITE_ID" local="SITE_ID"/>
+ </foreign-key>
+ <foreign-key foreignTable="SECURITY_PRINCIPAL">
+ <reference foreign="PRINCIPAL_ID" local="PRINCIPAL_ID"/>
</foreign-key>
</table>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]