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

diff --git a/docs/install/db/atutor_schema.sql b/docs/install/db/atutor_schema.sql
index 7b06b01..02104b7 100644 (file)
--- a/docs/install/db/atutor_schema.sql
+++ b/docs/install/db/atutor_schema.sql
@@ -501,7 +501,7 @@ CREATE TABLE `language_pages` (
 CREATE TABLE `master_list` (
   `public_field` CHAR( 30 ) NOT NULL default '',
   `hash_field` CHAR( 40 ) NOT NULL default '',
-  `member_id` MEDIUMINT UNSIGNED NOT NULL default '',
+  `member_id` MEDIUMINT UNSIGNED NOT NULL default 0,
   PRIMARY KEY ( `public_field` )
 );
 
@@ -697,8 +697,8 @@ CREATE TABLE `related_content` (
 
 CREATE TABLE `reading_list` (
        `reading_id` MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT,
-       `course_id` MEDIUMINT UNSIGNED NOT NULL default '',
-       `resource_id` MEDIUMINT UNSIGNED NOT NULL default '',
+       `course_id` MEDIUMINT UNSIGNED NOT NULL default 0,
+       `resource_id` MEDIUMINT UNSIGNED NOT NULL default 0,
        `required` enum('required','optional') NOT NULL DEFAULT 'required',
        `date_start` DATE NOT NULL DEFAULT '0000-00-00',
        `date_end` DATE NOT NULL DEFAULT '0000-00-00',
@@ -712,7 +712,7 @@ CREATE TABLE `reading_list` (
 
 CREATE TABLE `external_resources` (
        `resource_id` MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT,
-       `course_id` MEDIUMINT UNSIGNED NOT NULL default '',
+       `course_id` MEDIUMINT UNSIGNED NOT NULL default 0,
        `type` TINYINT UNSIGNED NOT NULL DEFAULT 0,
        `title` varchar(255) NOT NULL DEFAULT '',
        `author` varchar(150) NOT NULL DEFAULT '',

diff --git a/docs/install/db/atutor_upgrade_1.4.3_to_1.5.sql b/docs/install/db/atutor_upgrade_1.4.3_to_1.5.sql
index 05d021b..2531c0c 100644 (file)
--- a/docs/install/db/atutor_upgrade_1.4.3_to_1.5.sql
+++ b/docs/install/db/atutor_upgrade_1.4.3_to_1.5.sql
@@ -75,6 +75,6 @@ ALTER TABLE `messages` ADD `course_id` MEDIUMINT( 8 ) UNSIGNED DEFAULT '0' NOT N
 CREATE TABLE `master_list` (\r
   `public_field` CHAR( 30 ) NOT NULL ,\r
   `hash_field` CHAR( 40 ) NOT NULL ,\r
-  `member_id` MEDIUMINT UNSIGNED NOT NULL ,\r
+  `member_id` MEDIUMINT UNSIGNED NOT NULL 0,\r
   PRIMARY KEY ( `public_field` )\r
 );\r

diff --git a/docs/install/db/atutor_upgrade_1.5.2_to_1.5.3.sql b/docs/install/db/atutor_upgrade_1.5.2_to_1.5.3.sql
index 4d85e2a..5292f1e 100644 (file)
--- a/docs/install/db/atutor_upgrade_1.5.2_to_1.5.3.sql
+++ b/docs/install/db/atutor_upgrade_1.5.2_to_1.5.3.sql
@@ -56,8 +56,8 @@ ALTER TABLE `courses` ADD `banner` TEXT NOT NULL default '';
 \r
 CREATE TABLE `reading_list` (\r
        `reading_id` MEDIUMINT(6) UNSIGNED NOT NULL AUTO_INCREMENT,\r
-       `course_id` MEDIUMINT UNSIGNED NOT NULL default '0',\r
-       `resource_id` MEDIUMINT UNSIGNED NOT NULL default '0',\r
+       `course_id` MEDIUMINT UNSIGNED NOT NULL default 0,\r
+       `resource_id` MEDIUMINT UNSIGNED NOT NULL default 0,\r
        `required` enum('required','optional') NOT NULL DEFAULT 'required',\r
        `date_start` DATE NOT NULL DEFAULT '0000-00-00',\r
        `date_end` DATE NOT NULL DEFAULT '0000-00-00',\r
@@ -70,7 +70,7 @@ CREATE TABLE `reading_list` (
 \r
 CREATE TABLE `external_resources` (\r
        `resource_id` MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT,\r
-       `course_id` MEDIUMINT UNSIGNED NOT NULL default '',\r
+       `course_id` MEDIUMINT UNSIGNED NOT NULL default 0,\r
        `type` TINYINT UNSIGNED NOT NULL DEFAULT 0,\r
        `title` varchar(255) NOT NULL DEFAULT '',\r
        `author` varchar(150) NOT NULL DEFAULT '',\r