2 -- Add iw_api and iw_wikiid to interwiki table
6 CREATE TABLE /*_*/interwiki_tmp (
7 iw_prefix
TEXT NOT NULL,
10 iw_wikiid
TEXT NOT NULL,
11 iw_local
INTEGER NOT NULL,
12 iw_trans
INTEGER NOT NULL default 0
13 ) /*$wgDBTableOptions*/;
15 INSERT INTO /*_*/interwiki_tmp
SELECT iw_prefix
, iw_url
, '', '', iw_local
, iw_trans
FROM /*_*/interwiki
;
16 DROP TABLE /*_*/interwiki
;
17 ALTER TABLE /*_*/interwiki_tmp
RENAME TO /*_*/interwiki
;
19 CREATE UNIQUE INDEX /*i*/iw_prefix
ON /*_*/interwiki (iw_prefix
);