Index: lams_common/db/sql/create_lams_11_tables.sql =================================================================== diff -u -r71d1ff69d56ec38b525fab3a282fa29c1d163e5a -r0cc2f66ffca1eb4172a7f29fa90443534d1cdedc --- lams_common/db/sql/create_lams_11_tables.sql (.../create_lams_11_tables.sql) (revision 71d1ff69d56ec38b525fab3a282fa29c1d163e5a) +++ lams_common/db/sql/create_lams_11_tables.sql (.../create_lams_11_tables.sql) (revision 0cc2f66ffca1eb4172a7f29fa90443534d1cdedc) @@ -145,11 +145,11 @@ , direction VARCHAR(3) NOT NULL , PRIMARY KEY (locale_id) )TYPE=InnoDB; -ALTER TABLE lams_supported_locale COMMENT='Describes the valid language/country combinations. Can''t make language_iso_code and country_iso_code a unique key as MySQL considers that "NULL=NULL" is not true.'; -ALTER TABLE lams_supported_locale MODIFY COLUMN language_iso_code VARCHAR(2) NOT NULL - COMMENT 'ISO 639-1 Language Code (2 letter version) Java only supports 2 letter properly, not the 3 letter codes.'; -ALTER TABLE lams_supported_locale MODIFY COLUMN country_iso_code VARCHAR(2) - COMMENT 'ISO 3166 Country Code'; +ALTER TABLE lams_supported_locale COMMENT='Describes the valid language/country combinations.'; +ALTER TABLE lams_supported_locale MODIFY COLUMN language_iso_code VARCHAR(2) NOT NULL + COMMENT 'ISO 639-1 Language Code (2 letter version) Java only supports 2 letter properly, not the 3 letter codes.'; +ALTER TABLE lams_supported_locale MODIFY COLUMN country_iso_code VARCHAR(2) + COMMENT 'ISO 3166 Country Code. Cannot use in unique key as allows null.'; CREATE TABLE lams_auth_method_type ( authentication_method_type_id INT(3) NOT NULL