1 # Explicitly set engine option on the tables that this option was initially missed out
2 ALTER TABLE `feeds` ENGINE = MyISAM;
3 ALTER TABLE `patches` ENGINE = MyISAM;
4 ALTER TABLE `patches_files` ENGINE = MyISAM;
5 ALTER TABLE `patches_files_actions` ENGINE = MyISAM;
6 ALTER TABLE `myown_patches` ENGINE = MyISAM;
7 ALTER TABLE `myown_patches_dependent` ENGINE = MyISAM;
8 ALTER TABLE `myown_patches_files` ENGINE = MyISAM;
9 ALTER TABLE `auto_enroll` ENGINE = MyISAM;
10 ALTER TABLE `auto_enroll_courses` ENGINE = MyISAM;
11 ALTER TABLE `grade_scales` ENGINE = MyISAM;
12 ALTER TABLE `grade_scales_detail` ENGINE = MyISAM;
13 ALTER TABLE `gradebook_tests` ENGINE = MyISAM;
14 ALTER TABLE `gradebook_detail` ENGINE = MyISAM;
15 ALTER TABLE `fha_student_tools` ENGINE = MyISAM;
17 # --------------------------------------------------------
18 # Replace (TEXT NOT NULL) with (TEXT)
19 ALTER TABLE `social_member_contact` MODIFY `con_address` TEXT;
21 ALTER TABLE `social_member_representation` MODIFY `rep_address` TEXT;
23 ALTER TABLE `oauth_client_servers` MODIFY `consumer_key` TEXT, MODIFY `consumer_secret` TEXT;
25 ALTER TABLE `oauth_client_tokens` MODIFY `token_secret` TEXT;
27 ALTER TABLE `pa_albums` MODIFY `description` TEXT;
29 ALTER TABLE `pa_album_comments` MODIFY `comment` TEXT;
31 ALTER TABLE `pa_photo_comments` MODIFY `comment` TEXT;
33 # add the BasicLTI module
35 # -------------- External Tools/BasicLTI Starts -----------------
36 CREATE TABLE `basiclti_tools` (
37 `id` mediumint(10) NOT NULL AUTO_INCREMENT,
38 `toolid` varchar(32) NOT NULL,
39 `course_id` mediumint(10) NOT NULL DEFAULT '0',
40 `title` varchar(255) NOT NULL,
41 `description` varchar(1024),
42 `timecreated` TIMESTAMP,
43 `timemodified` TIMESTAMP,
44 `toolurl` varchar(1023) NOT NULL,
45 `resourcekey` varchar(1023) NOT NULL,
46 `password` varchar(1023) NOT NULL,
47 `preferheight` mediumint(4) NOT NULL DEFAULT '0',
48 `allowpreferheight` mediumint(1) NOT NULL DEFAULT '0',
49 `sendname` mediumint(1) NOT NULL DEFAULT '0',
50 `sendemailaddr` mediumint(1) NOT NULL DEFAULT '0',
51 `acceptgrades` mediumint(1) NOT NULL DEFAULT '0',
52 `allowroster` mediumint(1) NOT NULL DEFAULT '0',
53 `allowsetting` mediumint(1) NOT NULL DEFAULT '0',
54 `allowcustomparameters` mediumint(1) NOT NULL DEFAULT '0',
55 `customparameters` text,
56 `organizationid` varchar(64),
57 `organizationurl` varchar(255),
58 `organizationdescr` varchar(255),
59 `launchinpopup` mediumint(1) NOT NULL DEFAULT '0',
60 `debuglaunch` mediumint(1) NOT NULL DEFAULT '0',
61 PRIMARY KEY ( `id`, `toolid` )
64 CREATE TABLE `basiclti_content` (
65 `id` mediumint(10) NOT NULL AUTO_INCREMENT,
66 `content_id` mediumint(10) NOT NULL DEFAULT '0',
67 `course_id` mediumint(10) NOT NULL DEFAULT '0',
68 `toolid` varchar(32) NOT NULL DEFAULT '',
69 `preferheight` mediumint(4) NOT NULL DEFAULT '0',
70 `sendname` mediumint(1) NOT NULL DEFAULT '0',
71 `sendemailaddr` mediumint(1) NOT NULL DEFAULT '0',
72 `gradebook_test_id` mediumint(10) NOT NULL DEFAULT '0',
73 `allowroster` mediumint(1) NOT NULL DEFAULT '0',
74 `allowsetting` mediumint(1) NOT NULL DEFAULT '0',
75 `customparameters` text,
76 `launchinpopup` mediumint(1) NOT NULL DEFAULT '0',
77 `debuglaunch` mediumint(1) NOT NULL DEFAULT '0',
78 `placementsecret` varchar(1023),
79 `timeplacementsecret` mediumint(10) NOT NULL DEFAULT '0',
80 `oldplacementsecret` varchar(1023),
82 `xmlimport` text(16384),
83 PRIMARY KEY ( `id`, `course_id`, `content_id` )
86 # Add BasicLTI to modules
87 INSERT INTO `modules` (dir_name, status, privilege, admin_privilege, cron_interval, cron_last_run) SELECT '_standard/basiclti', 2, max(privilege)*2, max(admin_privilege) * 2, 0, 0 FROM `modules`;
89 # Add Assignment Dropbox to modules
90 INSERT INTO `modules` (dir_name, status, privilege, admin_privilege, cron_interval, cron_last_run) SELECT '_standard/assignment_dropbox', 2, max(privilege)*2, 0, 0, 0 FROM `modules`;
92 # -------------- External Tools/BasicLTI Ends -----------------
94 # -------------- Update theme version, not changes in this release ---------
95 UPDATE `themes` SET `version` = '2.0.3' WHERE `title` = 'ATutor';
96 UPDATE `themes` SET `version` = '2.0.3' WHERE `title` = 'Fluid';
97 UPDATE `themes` SET `version` = '2.0.3' WHERE `title` = 'ATutor Classic';
98 UPDATE `themes` SET `version` = '2.0.3' WHERE `title` = 'Blumin';
99 UPDATE `themes` SET `version` = '2.0.3' WHERE `title` = 'Greenmin';
100 UPDATE `themes` SET `version` = '2.0.3' WHERE `title` = 'ATutor 1.5';
101 UPDATE `themes` SET `version` = '2.0.3' WHERE `title` = 'Mobile';
102 UPDATE `themes` SET `version` = '2.0.3' WHERE `title` = 'ATutor 1.6';
103 UPDATE `themes` SET `version` = '2.0.3' WHERE `title` = 'IDI Theme';
105 # more modules now, need space for bigger privilege numbers
106 ALTER TABLE `modules` CHANGE `privilege` `privilege` BIGINT( 20 ) UNSIGNED NOT NULL DEFAULT '0';