Index: lams_common/db/sql/create_lams_11_tables.sql =================================================================== diff -u -ra0f3adf1d8701263b284822c4fcb6661bb519dac -r21e9dc2239df1ec1c53d9fb911620d3a85fd0e6e --- lams_common/db/sql/create_lams_11_tables.sql (.../create_lams_11_tables.sql) (revision a0f3adf1d8701263b284822c4fcb6661bb519dac) +++ lams_common/db/sql/create_lams_11_tables.sql (.../create_lams_11_tables.sql) (revision 21e9dc2239df1ec1c53d9fb911620d3a85fd0e6e) @@ -240,9 +240,6 @@ , INDEX (organisation_state_id) , CONSTRAINT FK_lams_organisation_4 FOREIGN KEY (organisation_state_id) REFERENCES lams_organisation_state (organisation_state_id) ON DELETE NO ACTION ON UPDATE NO ACTION - , INDEX (locale_id) - , CONSTRAINT FK_lams_organisation_5 FOREIGN KEY (locale_id) - REFERENCES lams_supported_locale (locale_id) )TYPE=InnoDB; CREATE TABLE lams_css_theme_ve ( @@ -320,9 +317,6 @@ , 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';