Index: lams_common/db/model/lams_11.clay
===================================================================
RCS file: /usr/local/cvsroot/lams_common/db/model/lams_11.clay,v
diff -u -r1.97 -r1.98
--- lams_common/db/model/lams_11.clay	18 Mar 2008 04:20:37 -0000	1.97
+++ lams_common/db/model/lams_11.clay	15 Apr 2008 03:39:50 -0000	1.98
@@ -2281,6 +2281,10 @@
 <index-description></index-description>
 <index-column name="login" sort="ASC"/>
 </index>
+<index alias="" name="email" remarks="" uid="463940:1194f45836a:-7fc1" unique="false">
+<index-description></index-description>
+<index-column name="email" sort="ASC"/>
+</index>
 </index-list>
 </table>
 <table alias="" name="lams_user_organisation" remarks="" uid="7725df:115cb718d5c:-7bf0">
@@ -3251,11 +3255,11 @@
 <column alias="" auto-increment="false" column-size="1" decimal-digits="0" default-value="0" mandatory="false" name="supports_outputs" remarks="" uid="776368:118bf867979:-7fbf">
 <column-description></column-description>
 <data-type jdbc-type="-6" name="TINYINT" selected-variant-pattern="TINYINT(%n)">
+<variant precision-max="1" precision-min="0" precision-variable="%n" type-name-pattern="TINYINT(%n)"/>
 <variant type-name-pattern="TINYINT"/>
 <variant type-name-pattern="TINYINT UNSIGNED"/>
 <variant type-name-pattern="TINYINT UNSIGNED ZEROFILL"/>
 <variant type-name-pattern="TINYINT ZEROFILL"/>
-<variant precision-max="1" precision-min="0" precision-variable="%n" type-name-pattern="TINYINT(%n)"/>
 <variant precision-max="1" precision-min="0" precision-variable="%n" type-name-pattern="TINYINT(%n) UNSIGNED"/>
 <variant precision-max="1" precision-min="0" precision-variable="%n" type-name-pattern="TINYINT(%n) UNSIGNED ZEROFILL"/>
 <variant precision-max="1" precision-min="0" precision-variable="%n" type-name-pattern="TINYINT(%n) ZEROFILL"/>