Index: lams_common/db/sql/updatescripts/alter_21_engine.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_common/db/sql/updatescripts/Attic/alter_21_engine.sql,v
diff -u -r1.1 -r1.2
--- lams_common/db/sql/updatescripts/alter_21_engine.sql	29 Feb 2008 03:46:48 -0000	1.1
+++ lams_common/db/sql/updatescripts/alter_21_engine.sql	14 May 2008 00:09:17 -0000	1.2
@@ -1,4 +1,6 @@
 -- LDEV-1511
+SET foreign_key_checks=0;
+
 ALTER TABLE lams_configuration ENGINE=InnoDB;
 ALTER TABLE lams_notebook_entry ENGINE=InnoDB;
 ALTER TABLE lams_qtz_BLOB_TRIGGERS ENGINE=InnoDB;
@@ -13,3 +15,29 @@
 ALTER TABLE lams_qtz_SIMPLE_TRIGGERS ENGINE=InnoDB;
 ALTER TABLE lams_qtz_TRIGGERS ENGINE=InnoDB;
 ALTER TABLE lams_qtz_TRIGGER_LISTENERS ENGINE=InnoDB;
+
+ALTER TABLE tl_lantbk11_attachment ADD CONSTRAINT FK12090F57FC940906 FOREIGN KEY (notebook_uid) REFERENCES tl_lantbk11_notebook (uid);
+
+ALTER TABLE tl_lantbk11_session ADD CONSTRAINT FKB7C198E2FC940906 FOREIGN KEY (notebook_uid) REFERENCES tl_lantbk11_notebook (uid);
+
+ALTER TABLE tl_lantbk11_user ADD CONSTRAINT FKCB8A58FFA3B0FADF FOREIGN KEY (notebook_session_uid) REFERENCES tl_lantbk11_session (uid);
+
+ALTER TABLE lams_qtz_JOB_LISTENERS ADD FOREIGN KEY (JOB_NAME,JOB_GROUP)
+        REFERENCES lams_qtz_JOB_DETAILS (JOB_NAME,JOB_GROUP);
+        
+ALTER TABLE lams_qtz_TRIGGERS ADD FOREIGN KEY (JOB_NAME,JOB_GROUP)
+        REFERENCES lams_qtz_JOB_DETAILS (JOB_NAME,JOB_GROUP);
+
+ALTER TABLE lams_qtz_SIMPLE_TRIGGERS ADD FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP)
+        REFERENCES lams_qtz_TRIGGERS (TRIGGER_NAME,TRIGGER_GROUP);
+
+ALTER TABLE lams_qtz_CRON_TRIGGERS ADD FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP)
+        REFERENCES lams_qtz_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP);
+
+ALTER TABLE lams_qtz_BLOB_TRIGGERS ADD FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP)
+        REFERENCES lams_qtz_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP);
+        
+ALTER TABLE lams_qtz_TRIGGER_LISTENERS ADD FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP)
+        REFERENCES lams_qtz_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP);
+
+SET foreign_key_checks=1;
\ No newline at end of file
Index: lams_tool_chat/db/sql/updatescripts/updateTo20080229.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_chat/db/sql/updatescripts/Attic/updateTo20080229.sql,v
diff -u -r1.1 -r1.2
--- lams_tool_chat/db/sql/updatescripts/updateTo20080229.sql	29 Feb 2008 03:46:49 -0000	1.1
+++ lams_tool_chat/db/sql/updatescripts/updateTo20080229.sql	14 May 2008 00:09:16 -0000	1.2
@@ -4,5 +4,11 @@
 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);
 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
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_larsrc/db/sql/updatescripts/Attic/updateTo20080229.sql,v
diff -u -r1.1 -r1.2
--- lams_tool_larsrc/db/sql/updatescripts/updateTo20080229.sql	29 Feb 2008 03:46:47 -0000	1.1
+++ lams_tool_larsrc/db/sql/updatescripts/updateTo20080229.sql	14 May 2008 00:09:17 -0000	1.2
@@ -6,5 +6,16 @@
 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);
 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
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_scribe/db/sql/updatescripts/Attic/updateTo20080229.sql,v
diff -u -r1.1 -r1.2
--- lams_tool_scribe/db/sql/updatescripts/updateTo20080229.sql	29 Feb 2008 03:46:51 -0000	1.1
+++ lams_tool_scribe/db/sql/updatescripts/updateTo20080229.sql	14 May 2008 00:09:17 -0000	1.2
@@ -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";
Index: lams_tool_survey/db/sql/updatescripts/updateTo20080229.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_survey/db/sql/updatescripts/Attic/updateTo20080229.sql,v
diff -u -r1.1 -r1.2
--- lams_tool_survey/db/sql/updatescripts/updateTo20080229.sql	29 Feb 2008 03:46:45 -0000	1.1
+++ lams_tool_survey/db/sql/updatescripts/updateTo20080229.sql	14 May 2008 00:09:16 -0000	1.2
@@ -6,5 +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);
 UPDATE lams_tool SET modified_date_time = NOW() WHERE tool_signature = "lasurv11";
 UPDATE lams_tool SET tool_version = "20080229" WHERE tool_signature = "lasurv11";