Index: lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch02030501.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_common/src/java/org/lamsfoundation/lams/dbupdates/Attic/patch02030501.sql,v
diff -u -r1.1.2.2 -r1.1.2.3
--- lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch02030501.sql	11 Feb 2011 22:09:06 -0000	1.1.2.2
+++ lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch02030501.sql	15 Feb 2011 20:53:57 -0000	1.1.2.3
@@ -10,6 +10,16 @@
 -- LDEV-2628 Report instant completion
 ALTER TABLE lams_ext_server_org_map ADD COLUMN lesson_finish_url text DEFAULT NULL;
 
+CREATE TABLE lams_ext_server_lesson_map (
+  uid BIGINT(20) NOT NULL auto_increment,
+  lesson_id BIGINT(20) NOT NULL,
+  ext_server_org_map_id int(11) NOT NULL,
+  PRIMARY KEY  (uid),
+  UNIQUE KEY `lesson_id` (`lesson_id`),
+  CONSTRAINT lams_ext_server_lesson_map_fk1 FOREIGN KEY (ext_server_org_map_id) REFERENCES lams_ext_server_org_map (sid) ON DELETE CASCADE ON UPDATE CASCADE,
+  CONSTRAINT lams_ext_server_lesson_map_fk2 FOREIGN KEY (lesson_id) REFERENCES lams_lesson (lesson_id) ON DELETE CASCADE ON UPDATE CASCADE
+) TYPE=InnoDB;
+
 -- If there were no errors, commit and restore autocommit to on
 COMMIT;
 SET AUTOCOMMIT = 1;
\ No newline at end of file