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]