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]

Reply via email to