Index: lams_common/db/sql/create_integration_tables.sql
===================================================================
diff -u -r2f21856ec2ab85b47c93cfcc3fa2c8769be65077 -rd5a281b774f24a41894aac08200627f18e2b25e2
--- lams_common/db/sql/create_integration_tables.sql	(.../create_integration_tables.sql)	(revision 2f21856ec2ab85b47c93cfcc3fa2c8769be65077)
+++ lams_common/db/sql/create_integration_tables.sql	(.../create_integration_tables.sql)	(revision d5a281b774f24a41894aac08200627f18e2b25e2)
@@ -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;
