Index: lams_tool_chat/db/sql/updatescripts/updateTo20080229.sql =================================================================== diff -u -r36aa2a4d14c54dc5a486aa4b45d3ee94be976f77 -r3d41165c25a2f0e43669d3aa730676a8c62ebaa8 --- lams_tool_chat/db/sql/updatescripts/updateTo20080229.sql (.../updateTo20080229.sql) (revision 36aa2a4d14c54dc5a486aa4b45d3ee94be976f77) +++ lams_tool_chat/db/sql/updatescripts/updateTo20080229.sql (.../updateTo20080229.sql) (revision 3d41165c25a2f0e43669d3aa730676a8c62ebaa8) @@ -4,11 +4,13 @@ ALTER TABLE tl_lachat11_message ENGINE=InnoDB; ALTER TABLE tl_lachat11_session ENGINE=InnoDB; ALTER TABLE tl_lachat11_user ENGINE=InnoDB; -alter table tl_lachat11_attachment add foreign key (chat_uid) references tl_lachat11_chat (uid); -alter table tl_lachat11_message add foreign key (to_user_uid) references tl_lachat11_user (uid); -alter table tl_lachat11_message add foreign key (chat_session_uid) references tl_lachat11_session (uid); -alter table tl_lachat11_message add foreign key (from_user_uid) references tl_lachat11_user (uid); -alter table tl_lachat11_session add foreign key (chat_uid) references tl_lachat11_chat (uid); -alter table tl_lachat11_user add foreign key (chat_session_uid) references tl_lachat11_session (uid); + +alter table tl_lachat11_attachment add constraint FK9ED6CB2E1A3926E3 foreign key (chat_uid) references tl_lachat11_chat (uid); +alter table tl_lachat11_message add constraint FKCC08C1DC2AF61E05 foreign key (to_user_uid) references tl_lachat11_user (uid); +alter table tl_lachat11_message add constraint FKCC08C1DC9C8469FC foreign key (chat_session_uid) references tl_lachat11_session (uid); +alter table tl_lachat11_message add constraint FKCC08C1DCCF3BF9B6 foreign key (from_user_uid) references tl_lachat11_user (uid); +alter table tl_lachat11_session add constraint FK96E446B1A3926E3 foreign key (chat_uid) references tl_lachat11_chat (uid); +alter table tl_lachat11_user add constraint FK4EB82169C8469FC foreign key (chat_session_uid) references tl_lachat11_session (uid); + UPDATE lams_tool SET modified_date_time = NOW() WHERE tool_signature = "lachat11"; UPDATE lams_tool SET tool_version = "20080229" WHERE tool_signature = "lachat11"; \ No newline at end of file