Index: lams_common/db/model/lams_11.clay =================================================================== RCS file: /usr/local/cvsroot/lams_common/db/model/lams_11.clay,v diff -u -r1.94 -r1.95 --- lams_common/db/model/lams_11.clay 16 Jan 2008 05:09:27 -0000 1.94 +++ lams_common/db/model/lams_11.clay 21 Jan 2008 00:08:03 -0000 1.95 @@ -5764,6 +5764,63 @@ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
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.109 -r1.110 --- lams_common/db/sql/create_lams_11_tables.sql 16 Jan 2008 05:01:32 -0000 1.109 +++ lams_common/db/sql/create_lams_11_tables.sql 21 Jan 2008 00:08:27 -0000 1.110 @@ -960,6 +960,14 @@ REFERENCES lams_user_organisation (user_organisation_id) )TYPE=InnoDB; +CREATE TABLE lams_password_request ( + request_id BIGINT(20) NOT NULL AUTO_INCREMENT + , user_id BIGINT(20) NOT NULL + , request_key VARCHAR(32) NOT NULL + , request_date DATETIME NOT NULL + , PRIMARY KEY (request_id) +)TYPE=InnoDB; +CREATE UNIQUE INDEX IX_lams_psswd_rqst_key ON lams_password_request (request_key ASC); Index: lams_common/db/sql/updatescripts/alter_21_groupings_fckeditor.sql =================================================================== RCS file: /usr/local/cvsroot/lams_common/db/sql/updatescripts/Attic/alter_21_groupings_fckeditor.sql,v diff -u -r1.2 -r1.3 --- lams_common/db/sql/updatescripts/alter_21_groupings_fckeditor.sql 16 Jan 2008 23:00:46 -0000 1.2 +++ lams_common/db/sql/updatescripts/alter_21_groupings_fckeditor.sql 21 Jan 2008 00:08:33 -0000 1.3 @@ -35,3 +35,12 @@ UPDATE lams_supported_locale SET fckeditor_code='ja' WHERE language_iso_code='ja' AND country_iso_code='JP'; UPDATE lams_supported_locale SET fckeditor_code='ms' WHERE language_iso_code='ms' AND country_iso_code='MY'; +-- See LDEV-273 +CREATE TABLE lams_password_request ( + request_id BIGINT(20) NOT NULL AUTO_INCREMENT + , user_id BIGINT(20) NOT NULL + , request_key VARCHAR(32) NOT NULL + , request_date DATETIME NOT NULL + , PRIMARY KEY (request_id) +)TYPE=InnoDB; +CREATE UNIQUE INDEX IX_lams_psswd_rqst_key ON lams_password_request (request_key ASC);