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";