From aec6df38ac9646a38c3d5c73b45aa37659954f1a Mon Sep 17 00:00:00 2001 From: martinlanghoff Date: Wed, 17 May 2006 06:36:14 +0000 Subject: [PATCH] moodle16cleanup: backup/ set the correct column datatype and default value --- backup/db/postgres7.php | 21 +++++++++++++++++++++ backup/version.php | 2 +- 2 files changed, 22 insertions(+), 1 deletion(-) diff --git a/backup/db/postgres7.php b/backup/db/postgres7.php index 611bf1e5a8..0ddafc5b7d 100644 --- a/backup/db/postgres7.php +++ b/backup/db/postgres7.php @@ -50,6 +50,27 @@ function backup_upgrade($oldversion=0) { } } + if ($oldversion < 2006042801) { + modify_database('', 'ALTER TABLE prefix_backup_log + ALTER COLUMN "time" TYPE integer, + ALTER COLUMN "time" SET DEFAULT 0, + ALTER COLUMN laststarttime TYPE integer, + ALTER COLUMN laststarttime SET DEFAULT 0, + ALTER COLUMN courseid TYPE integer, + ALTER COLUMN courseid SET DEFAULT 0'); + + modify_database('', 'ALTER TABLE mdl_backup_courses + ALTER COLUMN lastendtime TYPE integer, + ALTER COLUMN lastendtime SET DEFAULT 0, + ALTER COLUMN laststarttime TYPE integer, + ALTER COLUMN laststarttime SET DEFAULT 0, + ALTER COLUMN courseid TYPE integer, + ALTER COLUMN courseid SET DEFAULT 0, + ALTER COLUMN nextstarttime TYPE integer, + ALTER COLUMN nextstarttime SET DEFAULT 0'); + + } + //Finally, return result return $result; diff --git a/backup/version.php b/backup/version.php index ddc2374518..bbaed826fd 100644 --- a/backup/version.php +++ b/backup/version.php @@ -5,6 +5,6 @@ // database (backup_version) to determine whether upgrades should // be performed (see db/backup_*.php) -$backup_version = 2006042800; // The current version is a date (YYYYMMDDXX) +$backup_version = 2006042801; // The current version is a date (YYYYMMDDXX) $backup_release = "1.6beta4"; // User-friendly version number -- 2.39.5