Index: lams_tool_scribe/db/sql/updatescripts/updateTo20080229.sql
===================================================================
diff -u -r98f10c35c8f290b7f3bcea1908f22cd77e7e8943 -r36aa2a4d14c54dc5a486aa4b45d3ee94be976f77
--- lams_tool_scribe/db/sql/updatescripts/updateTo20080229.sql	(.../updateTo20080229.sql)	(revision 98f10c35c8f290b7f3bcea1908f22cd77e7e8943)
+++ lams_tool_scribe/db/sql/updatescripts/updateTo20080229.sql	(.../updateTo20080229.sql)	(revision 36aa2a4d14c54dc5a486aa4b45d3ee94be976f77)
@@ -5,5 +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);
 UPDATE lams_tool SET modified_date_time = NOW() WHERE tool_signature = "lascrb11";
 UPDATE lams_tool SET tool_version = "20080229" WHERE tool_signature = "lascrb11";