Index: lams_common/db/model/lams_11.clay
===================================================================
RCS file: /usr/local/cvsroot/lams_common/db/model/lams_11.clay,v
diff -u -r1.64 -r1.65
--- lams_common/db/model/lams_11.clay 21 Aug 2006 05:56:52 -0000 1.64
+++ lams_common/db/model/lams_11.clay 23 Aug 2006 07:55:53 -0000 1.65
@@ -1858,7 +1858,7 @@
-
+
@@ -1907,6 +1907,13 @@
+
+
+
+
+
+
+
@@ -2040,6 +2047,19 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
Index: lams_common/db/sql/create_lams_11_tables.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_common/db/sql/create_lams_11_tables.sql,v
diff -u -r1.79 -r1.80
--- lams_common/db/sql/create_lams_11_tables.sql 21 Aug 2006 05:56:52 -0000 1.79
+++ lams_common/db/sql/create_lams_11_tables.sql 23 Aug 2006 07:55:52 -0000 1.80
@@ -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';