From c670cbd0a9983d65cf69467c255ed68b9a1f6f02 Mon Sep 17 00:00:00 2001 From: paca70 Date: Fri, 30 Jul 2004 11:09:47 +0000 Subject: [PATCH] More updates, but wiki is still working only partical. --- mod/wiki/db/postgres7.php | 5 +++++ mod/wiki/db/postgres7.sql | 2 +- mod/wiki/version.php | 2 +- 3 files changed, 7 insertions(+), 2 deletions(-) diff --git a/mod/wiki/db/postgres7.php b/mod/wiki/db/postgres7.php index b6e7a1b7e5..b3db1fafc9 100644 --- a/mod/wiki/db/postgres7.php +++ b/mod/wiki/db/postgres7.php @@ -12,7 +12,12 @@ function wiki_upgrade($oldversion) { modify_database("", "ALTER TABLE ONLY prefix_wiki_pages ADD CONSTRAINT id PRIMARY KEY (pagename, \"version\");"); } + if ($oldversion < 2004073001) { + modify_database("", "ALTER TABLE prefix_wiki_pages DROP CONSTRAINT id;"); + modify_database("", "ALTER TABLE ONLY prefix_wiki_pages + ADD CONSTRAINT id PRIMARY KEY (pagename, \"version\", wiki);"); + } return true; } diff --git a/mod/wiki/db/postgres7.sql b/mod/wiki/db/postgres7.sql index 7ed97cdc64..2cf8eb4450 100644 --- a/mod/wiki/db/postgres7.sql +++ b/mod/wiki/db/postgres7.sql @@ -55,6 +55,6 @@ CREATE TABLE prefix_wiki_pages ( ) ; ALTER TABLE ONLY prefix_wiki_pages - ADD CONSTRAINT id PRIMARY KEY (pagename, "version"); + ADD CONSTRAINT id PRIMARY KEY (pagename, version, wiki); CREATE INDEX prefix_wiki_pages_pagename_version_wiki_idx ON prefix_wiki_pages (pagename, version, wiki) ; diff --git a/mod/wiki/version.php b/mod/wiki/version.php index 930081f288..65719e4ddb 100644 --- a/mod/wiki/version.php +++ b/mod/wiki/version.php @@ -5,7 +5,7 @@ /// This fragment is called by moodle_needs_upgrading() and /admin/index.php ///////////////////////////////////////////////////////////////////////////////// -$module->version = 2004073000; // The current module version (Date: YYYYMMDDXX) +$module->version = 2004073001; // The current module version (Date: YYYYMMDDXX) $module->cron = 0; // Period for cron to check this module (secs) ?> -- 2.39.5