Fisheye: Tag 1.1.2.4 refers to a dead (removed) revision in file `lams_central/src/java/org/lamsfoundation/lams/web/TutorialAction.java'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 1.1.2.5 refers to a dead (removed) revision in file `lams_central/web/tutorialVideo.jsp'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 1.3.6.1 refers to a dead (removed) revision in file `lams_central/web/includes/javascript/thickbox-compressed.js'.
Fisheye: No comparison available.  Pass `N' to diff?
Index: lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch0017_updateFrom23-231.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch0017_updateFrom23-231.sql,v
diff -u -r1.1.2.2 -r1.1.2.3
--- lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch0017_updateFrom23-231.sql	19 Jun 2009 10:50:33 -0000	1.1.2.2
+++ lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch0017_updateFrom23-231.sql	25 Jun 2009 03:13:49 -0000	1.1.2.3
@@ -6,20 +6,22 @@
 ----------------------Put all sql statements below here-------------------------
 
 -- Adding new column to external organisation table for tool adapters
-ALTER TABLE lams_ext_server_org_map ADD COLUMN server_url varchar(255);
+ALTER TABLE lams_ext_server_org_map ADD COLUMN server_url varchar(255) default null;
 
--- LDEV-2369 Add tutorial video support
-ALTER TABLE lams_user ADD COLUMN tutorials_disabled TINYINT(1) DEFAULT 0,
-				 	  ADD COLUMN first_login TINYINT(1) DEFAULT 1;
+--
+-- Table structure for table `lams_ext_server_tool_map`
+--
+DROP TABLE IF EXISTS lams_ext_server_tool_map;
+CREATE TABLE lams_ext_server_tool_map (
+  uid BIGINT(20) NOT NULL auto_increment,
+  tool_id BIGINT(20) NOT NULL,
+  ext_server_org_map_id int(11) NOT NULL,
+  PRIMARY KEY  (uid),
+  UNIQUE KEY unique_adapter_map (ext_server_org_map_id, tool_id),
+  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;
 
-CREATE TABLE lams_user_disabled_tutorials (
-     user_id BIGINT(20) NOT NULL
-   , page_str CHAR(5) NOT NULL
-   , CONSTRAINT FK_lams_user_disabled_tutorials_1 FOREIGN KEY (user_id)
-                  REFERENCES lams_user (user_id) ON DELETE CASCADE ON UPDATE CASCADE
-   , PRIMARY KEY (user_id,page_str)
-)TYPE=InnoDB;
-
 ----------------------Put all sql statements above here-------------------------
 
 -- If there were no errors, commit and restore autocommit to on
Fisheye: Tag 1.1.4.1 refers to a dead (removed) revision in file `lams_tool_assessment/web/includes/css/thickbox.css'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 1.1.4.1 refers to a dead (removed) revision in file `lams_tool_assessment/web/includes/javascript/thickbox.js'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 1.1.6.1 refers to a dead (removed) revision in file `lams_tool_images/web/includes/css/thickbox.css'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 1.5.4.1 refers to a dead (removed) revision in file `lams_tool_images/web/includes/javascript/thickbox.js'.
Fisheye: No comparison available.  Pass `N' to diff?