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]