Index: lams_common/db/model/lams_11.clay
===================================================================
diff -u -rfef86e6ad47f2ca7468d42de92b6276ba728e5c4 -rf6ea25a4367fbaab368bc9835f2147f5b1e8d12f
--- lams_common/db/model/lams_11.clay	(.../lams_11.clay)	(revision fef86e6ad47f2ca7468d42de92b6276ba728e5c4)
+++ lams_common/db/model/lams_11.clay	(.../lams_11.clay)	(revision f6ea25a4367fbaab368bc9835f2147f5b1e8d12f)
@@ -1858,7 +1858,7 @@
 <variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n) BINARY"/>
 </data-type>
 </column>
-<column alias="" auto-increment="false" column-size="64" decimal-digits="0" default-value="" mandatory="false" name="first_name" remarks="">
+<column alias="" auto-increment="false" column-size="128" decimal-digits="0" default-value="" mandatory="false" name="first_name" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="12" literal-prefix="'" literal-suffix="'" name="VARCHAR" selected-variant-pattern="VARCHAR(%n)">
 <variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n)"/>
@@ -1907,6 +1907,13 @@
 <variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n) BINARY"/>
 </data-type>
 </column>
+<column alias="" auto-increment="false" column-size="10" decimal-digits="0" default-value="" mandatory="false" name="postcode" remarks="">
+<column-description></column-description>
+<data-type jdbc-type="12" literal-prefix="'" literal-suffix="'" name="VARCHAR" selected-variant-pattern="VARCHAR(%n)">
+<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n)"/>
+<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n) BINARY"/>
+</data-type>
+</column>
 <column alias="" auto-increment="false" column-size="64" decimal-digits="0" default-value="" mandatory="false" name="country" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="12" literal-prefix="'" literal-suffix="'" name="VARCHAR" selected-variant-pattern="VARCHAR(%n)">
@@ -2040,6 +2047,19 @@
 <variant type-name-pattern="TINYINT ZEROFILL"/>
 </data-type>
 </column>
+<column alias="" auto-increment="false" column-size="20" decimal-digits="0" default-value="" mandatory="false" name="portrait_uuid" remarks="">
+<column-description></column-description>
+<data-type jdbc-type="-5" name="BIGINT" selected-variant-pattern="BIGINT(%n)">
+<variant type-name-pattern="BIGINT"/>
+<variant precision-max="19" precision-min="0" precision-variable="%n" type-name-pattern="BIGINT(%n)"/>
+<variant precision-max="19" precision-min="0" precision-variable="%n" type-name-pattern="BIGINT(%n) UNSIGNED"/>
+<variant precision-max="19" precision-min="0" precision-variable="%n" type-name-pattern="BIGINT(%n) UNSIGNED ZEROFILL"/>
+<variant precision-max="19" precision-min="0" precision-variable="%n" type-name-pattern="BIGINT(%n) ZEROFILL"/>
+<variant type-name-pattern="BIGINT UNSIGNED"/>
+<variant type-name-pattern="BIGINT UNSIGNED ZEROFILL"/>
+<variant type-name-pattern="BIGINT ZEROFILL"/>
+</data-type>
+</column>
 </column-list>
 <primary-key alias="" name="PRIMARY" remarks="">
 <primary-key-description></primary-key-description>
Index: lams_common/db/sql/create_lams_11_tables.sql
===================================================================
diff -u -rfef86e6ad47f2ca7468d42de92b6276ba728e5c4 -rf6ea25a4367fbaab368bc9835f2147f5b1e8d12f
--- lams_common/db/sql/create_lams_11_tables.sql	(.../create_lams_11_tables.sql)	(revision fef86e6ad47f2ca7468d42de92b6276ba728e5c4)
+++ lams_common/db/sql/create_lams_11_tables.sql	(.../create_lams_11_tables.sql)	(revision f6ea25a4367fbaab368bc9835f2147f5b1e8d12f)
@@ -283,13 +283,14 @@
      , login VARCHAR(20) NOT NULL
      , password VARCHAR(50) NOT NULL
      , title VARCHAR(32)
-     , first_name VARCHAR(64)
+     , first_name VARCHAR(128)
      , last_name VARCHAR(128)
      , address_line_1 VARCHAR(64)
      , address_line_2 VARCHAR(64)
      , address_line_3 VARCHAR(64)
      , city VARCHAR(64)
      , state VARCHAR(64)
+     , postcode VARCHAR(10)
      , country VARCHAR(64)
      , day_phone VARCHAR(64)
      , evening_phone VARCHAR(64)
@@ -304,6 +305,7 @@
      , html_theme_id BIGINT(20)
      , chat_id VARCHAR(255)
      , locale_id TINYINT(4)
+     , portrait_uuid BIGINT(20)
      , PRIMARY KEY (user_id)
      , INDEX (authentication_method_id)
      , CONSTRAINT FK_lams_user_1 FOREIGN KEY (authentication_method_id)
@@ -317,6 +319,9 @@
      , INDEX (html_theme_id)
      , CONSTRAINT FK_lams_user_5 FOREIGN KEY (html_theme_id)
                   REFERENCES lams_css_theme_ve (theme_ve_id) ON DELETE NO ACTION ON UPDATE NO ACTION
+     , INDEX (locale_id)
+     , CONSTRAINT FK_lams_user_6 FOREIGN KEY (locale_id)
+                  REFERENCES lams_supported_locale (locale_id) ON DELETE NO ACTION ON UPDATE NO ACTION
 )TYPE=InnoDB;
 ALTER TABLE lams_user MODIFY COLUMN chat_id VARCHAR(255)
       COMMENT 'ID used for Jabber';