Index: trunk/phase3/maintenance/sqlite/archives/patch-iw_api_and_wikiid.sql |
— | — | @@ -15,3 +15,5 @@ |
16 | 16 | INSERT INTO /*_*/interwiki_tmp SELECT iw_prefix, iw_url, '', '', iw_local, iw_trans FROM /*_*/interwiki; |
17 | 17 | DROP TABLE /*_*/interwiki; |
18 | 18 | ALTER TABLE /*_*/interwiki_tmp RENAME TO /*_*/interwiki; |
| 19 | + |
| 20 | +CREATE UNIQUE INDEX /*i*/iw_prefix ON /*_*/interwiki (iw_prefix); |
\ No newline at end of file |