Index: lams_tool_deploy/test/file/sql/lams_common/create_lams_11_tables.sql =================================================================== diff -u -r922473f5ee7930d8f2ddbf3f3e2d1d00cd9deee9 -rbba5edf85e23d78559441e9c8b647756eeef4368 --- lams_tool_deploy/test/file/sql/lams_common/create_lams_11_tables.sql (.../create_lams_11_tables.sql) (revision 922473f5ee7930d8f2ddbf3f3e2d1d00cd9deee9) +++ lams_tool_deploy/test/file/sql/lams_common/create_lams_11_tables.sql (.../create_lams_11_tables.sql) (revision bba5edf85e23d78559441e9c8b647756eeef4368) @@ -293,10 +293,10 @@ , user_id BIGINT(20) NOT NULL , PRIMARY KEY (user_organisation_id) , INDEX (user_id) - , CONSTRAINT u_user_organisation_ibfk_1 FOREIGN KEY (user_id) + , CONSTRAINT FK_lams_user_organisation_1 FOREIGN KEY (user_id) REFERENCES lams_user (user_id) ON DELETE NO ACTION ON UPDATE NO ACTION , INDEX (organisation_id) - , CONSTRAINT u_user_organisation_ibfk_2 FOREIGN KEY (organisation_id) + , CONSTRAINT FK_lams_user_organisation_2 FOREIGN KEY (organisation_id) REFERENCES lams_organisation (organisation_id) ON DELETE NO ACTION ON UPDATE NO ACTION )TYPE=InnoDB;