Index: lams_tool_deploy/test/file/sql/lams_common/create_lams_11_tables.sql =================================================================== RCS file: /usr/local/cvsroot/lams_tool_deploy/test/file/sql/lams_common/Attic/create_lams_11_tables.sql,v diff -u -r1.1 -r1.2 --- lams_tool_deploy/test/file/sql/lams_common/create_lams_11_tables.sql 7 Apr 2005 06:22:14 -0000 1.1 +++ lams_tool_deploy/test/file/sql/lams_common/create_lams_11_tables.sql 17 Jun 2005 01:55:20 -0000 1.2 @@ -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;