From bb65748dc98b7a04692d442e7ac8d6b34145ea61 Mon Sep 17 00:00:00 2001 From: Max Semenik Date: Sun, 12 Sep 2010 18:00:28 +0000 Subject: [PATCH] Follow-up r71118: forgot to re-add the index --- maintenance/sqlite/archives/patch-iw_api_and_wikiid.sql | 2 ++ 1 file changed, 2 insertions(+) diff --git a/maintenance/sqlite/archives/patch-iw_api_and_wikiid.sql b/maintenance/sqlite/archives/patch-iw_api_and_wikiid.sql index 1a4e8a5c6d..f9172b5ef1 100644 --- a/maintenance/sqlite/archives/patch-iw_api_and_wikiid.sql +++ b/maintenance/sqlite/archives/patch-iw_api_and_wikiid.sql @@ -15,3 +15,5 @@ CREATE TABLE /*_*/interwiki_tmp ( INSERT INTO /*_*/interwiki_tmp SELECT iw_prefix, iw_url, '', '', iw_local, iw_trans FROM /*_*/interwiki; DROP TABLE /*_*/interwiki; ALTER TABLE /*_*/interwiki_tmp RENAME TO /*_*/interwiki; + +CREATE UNIQUE INDEX /*i*/iw_prefix ON /*_*/interwiki (iw_prefix); \ No newline at end of file -- 2.20.1