From c8be2a9db581d616c0f77bc74b518fb1900b5b42 Mon Sep 17 00:00:00 2001 From: Alexandre Emsenhuber Date: Sat, 17 Jan 2009 15:47:23 +0000 Subject: [PATCH] svn:eol-style native --- maintenance/archives/patch-index-renames.sql | 20 ++++++++--------- .../archives/patch-pl-tl-il-unique.sql | 22 +++++++++---------- 2 files changed, 21 insertions(+), 21 deletions(-) diff --git a/maintenance/archives/patch-index-renames.sql b/maintenance/archives/patch-index-renames.sql index d961731c96..4a74845c62 100644 --- a/maintenance/archives/patch-index-renames.sql +++ b/maintenance/archives/patch-index-renames.sql @@ -1,11 +1,11 @@ --- --- patch-index-renames.sql --- --- Rename three indices because of naming conflicts - -DROP INDEX user_id ON /*_*/user_newtalk; -DROP INDEX user_ip ON /*_*/user_newtalk; -DROP INDEX usertext_timestamp ON /*_*/archive; -CREATE INDEX un_user_id ON /*_*/user_newtalk (user_id); -CREATE INDEX un_user_ip ON /*_*/user_newtalk (user_ip); +-- +-- patch-index-renames.sql +-- +-- Rename three indices because of naming conflicts + +DROP INDEX user_id ON /*_*/user_newtalk; +DROP INDEX user_ip ON /*_*/user_newtalk; +DROP INDEX usertext_timestamp ON /*_*/archive; +CREATE INDEX un_user_id ON /*_*/user_newtalk (user_id); +CREATE INDEX un_user_ip ON /*_*/user_newtalk (user_ip); CREATE INDEX ar_usertext_timestamp ON /*_*/archive (ar_user_text,ar_timestamp); \ No newline at end of file diff --git a/maintenance/archives/patch-pl-tl-il-unique.sql b/maintenance/archives/patch-pl-tl-il-unique.sql index 0dd452f081..ef48163e3e 100644 --- a/maintenance/archives/patch-pl-tl-il-unique.sql +++ b/maintenance/archives/patch-pl-tl-il-unique.sql @@ -1,11 +1,11 @@ --- --- patch-pl-tl-il-unique-index.sql --- --- Make reorderings of UNIQUE indices UNIQUE as well - -DROP INDEX pl_namespace ON /*_*/pagelinks; -CREATE UNIQUE INDEX pl_namespace ON /*_*/pagelinks (pl_namespace, pl_title, pl_from); -DROP INDEX tl_namespace ON /*_*/templatelinks; -CREATE UNIQUE INDEX tl_namespace ON /*_*/templatelinks (tl_namespace, tl_title, tl_from); -DROP INDEX il_to ON /*_*/imagelinks; -CREATE UNIQUE INDEX il_to ON /*_*/imagelinks (il_to, il_from); +-- +-- patch-pl-tl-il-unique-index.sql +-- +-- Make reorderings of UNIQUE indices UNIQUE as well + +DROP INDEX pl_namespace ON /*_*/pagelinks; +CREATE UNIQUE INDEX pl_namespace ON /*_*/pagelinks (pl_namespace, pl_title, pl_from); +DROP INDEX tl_namespace ON /*_*/templatelinks; +CREATE UNIQUE INDEX tl_namespace ON /*_*/templatelinks (tl_namespace, tl_title, tl_from); +DROP INDEX il_to ON /*_*/imagelinks; +CREATE UNIQUE INDEX il_to ON /*_*/imagelinks (il_to, il_from); -- 2.20.1