| Index: trunk/phase3/maintenance/sqlite/archives/patch-iw_api_and_wikiid.sql |
| — | — | @@ -0,0 +1,17 @@ |
| | 2 | +-- |
| | 3 | +-- Add iw_api and iw_wikiid to interwiki table |
| | 4 | +-- |
| | 5 | + |
| | 6 | + |
| | 7 | +CREATE TABLE /*_*/interwiki_tmp ( |
| | 8 | + iw_prefix TEXT NOT NULL, |
| | 9 | + iw_url BLOB NOT NULL, |
| | 10 | + iw_api BLOB NOT NULL, |
| | 11 | + iw_wikiid TEXT NOT NULL, |
| | 12 | + iw_local INTEGER NOT NULL, |
| | 13 | + iw_trans INTEGER NOT NULL default 0 |
| | 14 | +) /*$wgDBTableOptions*/; |
| | 15 | + |
| | 16 | +INSERT INTO /*_*/interwiki_tmp SELECT iw_prefix, iw_url, '', '', iw_local, iw_trans FROM /*_*/interwiki; |
| | 17 | +DROP TABLE /*_*/interwiki; |
| | 18 | +ALTER TABLE /*_*/interwiki_tmp RENAME TO /*_*/interwiki; |
| Property changes on: trunk/phase3/maintenance/sqlite/archives/patch-iw_api_and_wikiid.sql |
| ___________________________________________________________________ |
| Added: svn:eol-style |
| 1 | 19 | + native |