taylor      2004/12/22 09:52:47

  Modified:    src/schema security-schema.xml
  Log:
  made the FULL_PATH column a unique index 

  i believe that FULL_PATH should be normalized into 2 columns:

PRINCIPAL_TYPE
PRINCIPAL

PR:
  CVS: ----------------------------------------------------------------------
  CVS: PR:
  CVS:   If this change addresses a PR in the problem report tracking
  CVS:   database, then enter the PR number(s) here.
  CVS: Obtained from:
  CVS:   If this change has been taken from another system, such as NCSA,
  CVS:   then name the system in this line, otherwise delete it.
  CVS: Submitted by:
  CVS:   If this code has been contributed to Apache by someone else; i.e.,
  CVS:   they sent us a patch or a new module, then include their name/email
  CVS:   address here. If this is your work then delete this line.
  CVS: Reviewed by:
  CVS:   If we are doing pre-commit code reviews and someone else has
  CVS:   reviewed your changes, include their name(s) here.
  CVS:   If you have not had it reviewed then delete this line.
  
  Revision  Changes    Path
  1.13      +3 -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.12
  retrieving revision 1.13
  diff -u -r1.12 -r1.13
  --- security-schema.xml       4 Dec 2004 22:21:34 -0000       1.12
  +++ security-schema.xml       22 Dec 2004 17:52:47 -0000      1.13
  @@ -36,6 +36,9 @@
           <column name="FULL_PATH" required="true" size="254" type="VARCHAR"/>
           <column name="CREATION_DATE" required="true" type="TIMESTAMP"/>
           <column name="MODIFIED_DATE" required="true" type="TIMESTAMP"/>
  +        <unique name="UIX_SECURITY_PRINCIPAL">
  +          <unique-column name="FULL_PATH" />
  +        </unique>        
       </table>
   
       <!--
  
  
  

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to