http://atutor.ca/atutor/mantis/view.php?id=4830

[atutor.git] / docs / install / db / atutor_upgrade_2.0.2_to_2.0.3.sql

diff --git a/docs/install/db/atutor_upgrade_2.0.2_to_2.0.3.sql b/docs/install/db/atutor_upgrade_2.0.2_to_2.0.3.sql
index 54ac698..ffbbe2b 100644 (file)
--- a/docs/install/db/atutor_upgrade_2.0.2_to_2.0.3.sql
+++ b/docs/install/db/atutor_upgrade_2.0.2_to_2.0.3.sql
@@ -84,9 +84,10 @@ CREATE TABLE `basiclti_content` (
 ) ENGINE = MyISAM;
 
 # Add BasicLTI to modules
-INSERT INTO `modules` VALUES('_standard/basiclti', 2, 67108864, 16384, 0, 0);
+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`;
+
 # Add Assignment Dropbox to modules
-INSERT INTO `modules` VALUES('_standard/assignment_dropbox', 2, 134217728, 0, 0, 0);
+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`;
 
 # -------------- External Tools/BasicLTI  Ends -----------------