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.3.6.2 -r1.3.6.2.2.1
--- lams_common/db/sql/create_integration_tables.sql	19 Jun 2009 04:32:54 -0000	1.3.6.2
+++ lams_common/db/sql/create_integration_tables.sql	11 Feb 2011 22:09:05 -0000	1.3.6.2.2.1
@@ -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,18 @@
   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;
+
