From 6b4f18622d9bf62b985c26f33f60dbdde13afaa1 Mon Sep 17 00:00:00 2001 From: ethem Date: Thu, 18 May 2006 07:13:43 +0000 Subject: [PATCH] Put back tjhunt's changes. Invalid merge. Tabs aren't more important than indexes. --- enrol/authorize/db/postgres7.php | 5 +++++ 1 file changed, 5 insertions(+) diff --git a/enrol/authorize/db/postgres7.php b/enrol/authorize/db/postgres7.php index a04f167515..d1ff1cf974 100644 --- a/enrol/authorize/db/postgres7.php +++ b/enrol/authorize/db/postgres7.php @@ -115,6 +115,11 @@ function enrol_authorize_upgrade($oldversion=0) { table_column('enrol_authorize', 'transid', 'transid', 'integer', '10', 'unsigned', '0', 'not null'); } + if ($oldversion < 2006050400) { // Create transid indexes for backup & restore speed. + execute_sql("CREATE INDEX {$CFG->prefix}enrol_authorize_transid_idx ON {$CFG->prefix}enrol_authorize(transid);", false); + execute_sql("CREATE INDEX {$CFG->prefix}enrol_authorize_refunds_transid_idx ON {$CFG->prefix}enrol_authorize_refunds(transid);", false); + } + return $result; } -- 2.39.5