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
Index: lams_tool_larsrc/db/sql/updatescripts/updateTo20080229.sql
===================================================================
diff -u -r36aa2a4d14c54dc5a486aa4b45d3ee94be976f77 -r3d41165c25a2f0e43669d3aa730676a8c62ebaa8
--- lams_tool_larsrc/db/sql/updatescripts/updateTo20080229.sql	(.../updateTo20080229.sql)	(revision 36aa2a4d14c54dc5a486aa4b45d3ee94be976f77)
+++ lams_tool_larsrc/db/sql/updatescripts/updateTo20080229.sql	(.../updateTo20080229.sql)	(revision 3d41165c25a2f0e43669d3aa730676a8c62ebaa8)
@@ -6,16 +6,18 @@
 ALTER TABLE tl_larsrc11_resource_item ENGINE=InnoDB;
 ALTER TABLE tl_larsrc11_session ENGINE=InnoDB;
 ALTER TABLE tl_larsrc11_user ENGINE=InnoDB;
-alter table tl_larsrc11_attachment add foreign key (resource_uid) references tl_larsrc11_resource (uid);
-alter table tl_larsrc11_item_instruction add foreign key (item_uid) references tl_larsrc11_resource_item (uid);
-alter table tl_larsrc11_resource add foreign key (create_by) references tl_larsrc11_user (uid);
-alter table tl_larsrc11_resource_item add foreign key (create_by) references tl_larsrc11_user (uid);
-alter table tl_larsrc11_resource_item add foreign key (resource_uid) references tl_larsrc11_resource (uid);
-alter table tl_larsrc11_resource_item add foreign key (session_uid) references tl_larsrc11_session (uid);
-alter table tl_larsrc11_item_log add foreign key (resource_item_uid) references tl_larsrc11_resource_item (uid);
-alter table tl_larsrc11_item_log add foreign key (user_uid) references tl_larsrc11_user (uid);
-alter table tl_larsrc11_session add foreign key (resource_uid) references tl_larsrc11_resource (uid);
-alter table tl_larsrc11_user add foreign key (session_uid) references tl_larsrc11_session (uid);
-alter table tl_larsrc11_user add foreign key (resource_uid) references tl_larsrc11_resource (uid);
+
+alter table tl_larsrc11_attachment add constraint FK1E7009430E79035 foreign key (resource_uid) references tl_larsrc11_resource (uid);
+alter table tl_larsrc11_item_instruction add constraint FKA5665013980570ED foreign key (item_uid) references tl_larsrc11_resource_item (uid);
+alter table tl_larsrc11_resource add constraint FK89093BF758092FB foreign key (create_by) references tl_larsrc11_user (uid);
+alter table tl_larsrc11_resource_item add constraint FKF52D1F93758092FB foreign key (create_by) references tl_larsrc11_user (uid);
+alter table tl_larsrc11_resource_item add constraint FKF52D1F9330E79035 foreign key (resource_uid) references tl_larsrc11_resource (uid);
+alter table tl_larsrc11_resource_item add constraint FKF52D1F93EC0D3147 foreign key (session_uid) references tl_larsrc11_session (uid);
+alter table tl_larsrc11_item_log add constraint FK693580A438BF8DFE foreign key (resource_item_uid) references tl_larsrc11_resource_item (uid);
+alter table tl_larsrc11_item_log add constraint FK693580A441F9365D foreign key (user_uid) references tl_larsrc11_user (uid);
+alter table tl_larsrc11_session add constraint FK24AA78C530E79035 foreign key (resource_uid) references tl_larsrc11_resource (uid);
+alter table tl_larsrc11_user add constraint FK30113BFCEC0D3147 foreign key (session_uid) references tl_larsrc11_session (uid);
+alter table tl_larsrc11_user add constraint FK30113BFC309ED320 foreign key (resource_uid) references tl_larsrc11_resource (uid);
+
 UPDATE lams_tool SET modified_date_time = NOW() WHERE tool_signature = "larsrc11";
 UPDATE lams_tool SET tool_version = "20080229" WHERE tool_signature = "larsrc11";
Index: lams_tool_scribe/db/sql/updatescripts/updateTo20080229.sql
===================================================================
diff -u -r36aa2a4d14c54dc5a486aa4b45d3ee94be976f77 -r3d41165c25a2f0e43669d3aa730676a8c62ebaa8
--- lams_tool_scribe/db/sql/updatescripts/updateTo20080229.sql	(.../updateTo20080229.sql)	(revision 36aa2a4d14c54dc5a486aa4b45d3ee94be976f77)
+++ lams_tool_scribe/db/sql/updatescripts/updateTo20080229.sql	(.../updateTo20080229.sql)	(revision 3d41165c25a2f0e43669d3aa730676a8c62ebaa8)
@@ -5,12 +5,12 @@
 ALTER TABLE tl_lascrb11_scribe ENGINE=InnoDB;
 ALTER TABLE tl_lascrb11_session ENGINE=InnoDB;
 ALTER TABLE tl_lascrb11_user ENGINE=InnoDB;
-alter table tl_lascrb11_attachment add foreign key (scribe_uid) references tl_lascrb11_scribe (uid);
-alter table tl_lascrb11_heading add foreign key (scribe_uid) references tl_lascrb11_scribe (uid);
-alter table tl_lascrb11_report_entry add foreign key (scribe_heading_uid) references tl_lascrb11_heading (uid);
-alter table tl_lascrb11_report_entry add foreign key (scribe_session_uid) references tl_lascrb11_session (uid);
-alter table tl_lascrb11_session add foreign key (scribe_uid) references tl_lascrb11_scribe (uid);
-alter table tl_lascrb11_session add foreign key (appointed_scribe_uid) references tl_lascrb11_user (uid);
-alter table tl_lascrb11_user add foreign key (scribe_session_uid) references tl_lascrb11_session (uid);
+alter table tl_lascrb11_attachment add constraint FK57953706B3FA1495 foreign key (scribe_uid) references tl_lascrb11_scribe (uid);
+alter table tl_lascrb11_heading add constraint FK428A22FFB3FA1495 foreign key (scribe_uid) references tl_lascrb11_scribe (uid);
+alter table tl_lascrb11_report_entry add constraint FK5439FACAEA50D086 foreign key (scribe_heading_uid) references tl_lascrb11_heading (uid);
+alter table tl_lascrb11_report_entry add constraint FK5439FACA1C266FAE foreign key (scribe_session_uid) references tl_lascrb11_session (uid);
+alter table tl_lascrb11_session add constraint FK89732793B3FA1495 foreign key (scribe_uid) references tl_lascrb11_scribe (uid);
+alter table tl_lascrb11_session add constraint FK89732793E46919FF foreign key (appointed_scribe_uid) references tl_lascrb11_user (uid);
+alter table tl_lascrb11_user add constraint FK187DAFEE1C266FAE foreign key (scribe_session_uid) references tl_lascrb11_session (uid);
 UPDATE lams_tool SET modified_date_time = NOW() WHERE tool_signature = "lascrb11";
 UPDATE lams_tool SET tool_version = "20080229" WHERE tool_signature = "lascrb11";
Index: lams_tool_survey/db/sql/updatescripts/updateTo20080229.sql
===================================================================
diff -u -r36aa2a4d14c54dc5a486aa4b45d3ee94be976f77 -r3d41165c25a2f0e43669d3aa730676a8c62ebaa8
--- lams_tool_survey/db/sql/updatescripts/updateTo20080229.sql	(.../updateTo20080229.sql)	(revision 36aa2a4d14c54dc5a486aa4b45d3ee94be976f77)
+++ lams_tool_survey/db/sql/updatescripts/updateTo20080229.sql	(.../updateTo20080229.sql)	(revision 3d41165c25a2f0e43669d3aa730676a8c62ebaa8)
@@ -6,15 +6,15 @@
 ALTER TABLE tl_lasurv11_session ENGINE=InnoDB;
 ALTER TABLE tl_lasurv11_survey ENGINE=InnoDB;
 ALTER TABLE tl_lasurv11_user ENGINE=InnoDB;
-alter table tl_lasurv11_answer add foreign key (user_uid) references tl_lasurv11_user (uid);
-alter table tl_lasurv11_answer add foreign key (question_uid) references tl_lasurv11_question (uid);
-alter table tl_lasurv11_attachment add foreign key (survey_uid) references tl_lasurv11_survey (uid);
-alter table tl_lasurv11_option add foreign key (question_uid) references tl_lasurv11_question (uid);
-alter table tl_lasurv11_question add foreign key (survey_uid) references tl_lasurv11_survey (uid);
-alter table tl_lasurv11_question add foreign key (create_by) references tl_lasurv11_user (uid);
-alter table tl_lasurv11_session add foreign key (survey_uid) references tl_lasurv11_survey (uid);
-alter table tl_lasurv11_survey add foreign key (create_by) references tl_lasurv11_user (uid);
-alter table tl_lasurv11_user add foreign key (session_uid) references tl_lasurv11_session (uid);
-alter table tl_lasurv11_user add foreign key (survey_uid) references tl_lasurv11_survey (uid);
+alter table tl_lasurv11_answer add constraint FK6DAAFE3BB1423DC1 foreign key (user_uid) references tl_lasurv11_user (uid);
+alter table tl_lasurv11_answer add constraint FK6DAAFE3B25F3BB77 foreign key (question_uid) references tl_lasurv11_question (uid);
+alter table tl_lasurv11_attachment add constraint FKD92A9120D14146E5 foreign key (survey_uid) references tl_lasurv11_survey (uid);
+alter table tl_lasurv11_option add constraint FK85AB46F26966134F foreign key (question_uid) references tl_lasurv11_question (uid);
+alter table tl_lasurv11_question add constraint FK872D4F23D14146E5 foreign key (survey_uid) references tl_lasurv11_survey (uid);
+alter table tl_lasurv11_question add constraint FK872D4F23E4C99A5F foreign key (create_by) references tl_lasurv11_user (uid);
+alter table tl_lasurv11_session add constraint FKF08793B9D14146E5 foreign key (survey_uid) references tl_lasurv11_survey (uid);
+alter table tl_lasurv11_survey add constraint FK8CC465D7E4C99A5F foreign key (create_by) references tl_lasurv11_user (uid);
+alter table tl_lasurv11_user add constraint FK633F25884F803F63 foreign key (session_uid) references tl_lasurv11_session (uid);
+alter table tl_lasurv11_user add constraint FK633F2588D14146E5 foreign key (survey_uid) references tl_lasurv11_survey (uid);
 UPDATE lams_tool SET modified_date_time = NOW() WHERE tool_signature = "lasurv11";
 UPDATE lams_tool SET tool_version = "20080229" WHERE tool_signature = "lasurv11";