X-Git-Url: https://git.heureux-cyclage.org/?p=lhc%2Fweb%2Fwiklou.git;a=blobdiff_plain;f=maintenance%2Farchives%2Fpatch-pl_from_namespace.sql;h=dcf2b60a1f3931a0d35757d6ab6ad68fb0511a1b;hp=2f7ff046dd93c74458ad1dbe6deb63d96a5e0583;hb=c00c34f288c13b5360e30c694d929e4c65e3a3a1;hpb=b88d4628dcde8babb4990fc4f622673e3f275650 diff --git a/maintenance/archives/patch-pl_from_namespace.sql b/maintenance/archives/patch-pl_from_namespace.sql index 2f7ff046dd..dcf2b60a1f 100644 --- a/maintenance/archives/patch-pl_from_namespace.sql +++ b/maintenance/archives/patch-pl_from_namespace.sql @@ -1,4 +1,4 @@ ALTER TABLE /*_*/pagelinks ADD COLUMN pl_from_namespace int NOT NULL default 0; -CREATE INDEX /*i*/pl_backlinks_namespace ON /*_*/pagelinks (pl_namespace,pl_title,pl_from_namespace,pl_from); +CREATE INDEX /*i*/pl_backlinks_namespace ON /*_*/pagelinks (pl_from_namespace,pl_namespace,pl_title,pl_from);