Index: lams_common/db/sql/create_integration_tables.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_common/db/sql/create_integration_tables.sql,v
diff -u -r1.4 -r1.5
--- lams_common/db/sql/create_integration_tables.sql	1 Jul 2009 02:47:09 -0000	1.4
+++ lams_common/db/sql/create_integration_tables.sql	16 Feb 2011 10:37:42 -0000	1.5
@@ -12,6 +12,7 @@
   `userinfo_url` text NOT NULL,
   `server_url` varchar(255) DEFAULT NULL,
   `timeout_url` text NOT NULL,
+  `lesson_finish_url` text DEFAULT NULL,
   `disabled` bit(1) NOT NULL,
   `orgid` bigint(20),
   PRIMARY KEY  (`sid`),
@@ -67,3 +68,17 @@
   CONSTRAINT lams_ext_server_tool_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_tool_map_fk2 FOREIGN KEY (tool_id) REFERENCES lams_tool (tool_id) ON DELETE CASCADE ON UPDATE CASCADE
 ) TYPE=InnoDB;
+
+--
+-- Table structure for table `lams_ext_server_lesson_map`
+--
+DROP TABLE IF EXISTS lams_ext_server_lesson_map;
+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;