Index: lams_common/db/model/lams_11.clay
===================================================================
diff -u -rc972dd1d137b9d9a0a261ff1b46447229596a734 -r84c9c8b927413215c8b22d2418be83f0a0931841
--- lams_common/db/model/lams_11.clay (.../lams_11.clay) (revision c972dd1d137b9d9a0a261ff1b46447229596a734)
+++ lams_common/db/model/lams_11.clay (.../lams_11.clay) (revision 84c9c8b927413215c8b22d2418be83f0a0931841)
@@ -5764,6 +5764,63 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
Index: lams_common/db/sql/create_lams_11_tables.sql
===================================================================
diff -u -r7bbde598d2ac8811abb59813b3da4ac67349fe66 -r84c9c8b927413215c8b22d2418be83f0a0931841
--- lams_common/db/sql/create_lams_11_tables.sql (.../create_lams_11_tables.sql) (revision 7bbde598d2ac8811abb59813b3da4ac67349fe66)
+++ lams_common/db/sql/create_lams_11_tables.sql (.../create_lams_11_tables.sql) (revision 84c9c8b927413215c8b22d2418be83f0a0931841)
@@ -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
===================================================================
diff -u -r19a952c41eb3d7468438a021b7b0c806c3ee2564 -r84c9c8b927413215c8b22d2418be83f0a0931841
--- lams_common/db/sql/updatescripts/alter_21_groupings_fckeditor.sql (.../alter_21_groupings_fckeditor.sql) (revision 19a952c41eb3d7468438a021b7b0c806c3ee2564)
+++ lams_common/db/sql/updatescripts/alter_21_groupings_fckeditor.sql (.../alter_21_groupings_fckeditor.sql) (revision 84c9c8b927413215c8b22d2418be83f0a0931841)
@@ -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);