From 53c988a40319f145535729d7745511171f673b9f Mon Sep 17 00:00:00 2001 From: vyshane Date: Wed, 22 Mar 2006 07:07:57 +0000 Subject: [PATCH] Fix for Bug #4954 Patch submitted by jun at catalyst dot net dot nz --- lib/db/postgres7.php | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) diff --git a/lib/db/postgres7.php b/lib/db/postgres7.php index 4ab21ef1ed..c47a0eadc6 100644 --- a/lib/db/postgres7.php +++ b/lib/db/postgres7.php @@ -1473,14 +1473,14 @@ function main_upgrade($oldversion=0) { if ($oldversion < 2006032000) { table_column('post','','module','varchar','20','','','not null', 'id'); - modify_database('',"ALTER TABLE prefix_post ADD INDEX post_module_idx (module);"); + modify_database('',"CREATE INDEX post_module_idx ON prefix_post (module);"); modify_database('',"UPDATE prefix_post SET module = 'blog';"); } if ($oldversion < 2006032001) { - table_column('blog_tag_instance','','timemodified','integer','10','unsigned','0','not null', 'userid'); - modify_database('',"ALTER TABLE prefix_blog_tag_instance ADD INDEX bti_entryid_idx (entryid);"); - modify_database('',"ALTER TABLE prefix_blog_tag_instance ADD INDEX bti_tagid_idx (tagid);"); + table_column('blog_tag_instance','','timemodified','integer','10','unsigned','0','not null', 'userid'); + modify_database('',"CREATE INDEX bti_entryid_idx ON prefix_blog_tag_instance (entryid);"); + modify_database('',"CREATE INDEX bti_tagid_idx ON prefix_blog_tag_instance (tagid);"); modify_database('',"UPDATE prefix_blog_tag_instance SET timemodified = '".time()."';"); } -- 2.39.5