From 5f230a3a1958ee607f2fd3fe73420bbfc84e45c7 Mon Sep 17 00:00:00 2001 From: Sam Reed Date: Tue, 6 Mar 2012 00:26:48 +0000 Subject: [PATCH] Can someone standardi[sz]e SQL already!? Might aswell change mysql to same format as the sqlite one is becoming Ping r113110 --- maintenance/archives/patch-revision-user-page-index.sql | 3 +-- maintenance/sqlite/archives/patch-revision-user-page-index.sql | 3 +-- 2 files changed, 2 insertions(+), 4 deletions(-) diff --git a/maintenance/archives/patch-revision-user-page-index.sql b/maintenance/archives/patch-revision-user-page-index.sql index 9058e4e9fc..a4554c8f33 100644 --- a/maintenance/archives/patch-revision-user-page-index.sql +++ b/maintenance/archives/patch-revision-user-page-index.sql @@ -1,5 +1,4 @@ -- New index on revision table to allow searches for all edits by a given user -- to a given page. Added 2007-08-28 -ALTER TABLE /*$wgDBprefix*/revision - ADD INDEX page_user_timestamp (rev_page,rev_user,rev_timestamp); +CREATE INDEX /*i*/page_user_timestamp ON /*_*/revision (rev_page,rev_user,rev_timestamp); diff --git a/maintenance/sqlite/archives/patch-revision-user-page-index.sql b/maintenance/sqlite/archives/patch-revision-user-page-index.sql index 9058e4e9fc..a4554c8f33 100644 --- a/maintenance/sqlite/archives/patch-revision-user-page-index.sql +++ b/maintenance/sqlite/archives/patch-revision-user-page-index.sql @@ -1,5 +1,4 @@ -- New index on revision table to allow searches for all edits by a given user -- to a given page. Added 2007-08-28 -ALTER TABLE /*$wgDBprefix*/revision - ADD INDEX page_user_timestamp (rev_page,rev_user,rev_timestamp); +CREATE INDEX /*i*/page_user_timestamp ON /*_*/revision (rev_page,rev_user,rev_timestamp); -- 2.20.1