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.83 -r1.84 --- lams_common/db/sql/create_lams_11_tables.sql 16 Oct 2006 07:25:23 -0000 1.83 +++ lams_common/db/sql/create_lams_11_tables.sql 30 Oct 2006 23:59:48 -0000 1.84 @@ -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