Fisheye: Tag 1.1.2.2 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.3 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.1 -r1.1.2.2 --- lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch0017_updateFrom23-231.sql 19 Jun 2009 04:32:09 -0000 1.1.2.1 +++ lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch0017_updateFrom23-231.sql 19 Jun 2009 10:50:33 -0000 1.1.2.2 @@ -6,8 +6,20 @@ ----------------------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) default null; +ALTER TABLE lams_ext_server_org_map ADD COLUMN server_url varchar(255); +-- 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; + +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?