| Index: branches/wmf/1.17wmf1/maintenance/schema-changes-1.17wmf1-initial.sql |
| — | — | @@ -0,0 +1,67 @@ |
| | 2 | +-- schema-changes-1.17wmf1-initial.sql |
| | 3 | + |
| | 4 | +-- patch-archive_ar_revid.sql |
| | 5 | +ALTER TABLE /*$wgDBprefix*/archive |
| | 6 | + ADD INDEX ar_revid ( ar_rev_id ); |
| | 7 | + |
| | 8 | +-- patch-iwlinks.sql |
| | 9 | +CREATE TABLE /*_*/iwlinks ( |
| | 10 | + -- page_id of the referring page |
| | 11 | + iwl_from int unsigned NOT NULL default 0, |
| | 12 | + |
| | 13 | + -- Interwiki prefix code of the target |
| | 14 | + iwl_prefix varbinary(20) NOT NULL default '', |
| | 15 | + |
| | 16 | + -- Title of the target, including namespace |
| | 17 | + iwl_title varchar(255) binary NOT NULL default '' |
| | 18 | +) /*$wgDBTableOptions*/; |
| | 19 | + |
| | 20 | +CREATE UNIQUE INDEX /*i*/iwl_from ON /*_*/iwlinks (iwl_from, iwl_prefix, iwl_title); |
| | 21 | +CREATE UNIQUE INDEX /*i*/iwl_prefix_title_from ON /*_*/iwlinks (iwl_prefix, iwl_title, iwl_from); |
| | 22 | + |
| | 23 | +-- patch-module_deps.sql |
| | 24 | +CREATE TABLE /*_*/module_deps ( |
| | 25 | + -- Module name |
| | 26 | + md_module varbinary(255) NOT NULL, |
| | 27 | + -- Skin name |
| | 28 | + md_skin varbinary(32) NOT NULL, |
| | 29 | + -- JSON blob with file dependencies |
| | 30 | + md_deps mediumblob NOT NULL |
| | 31 | +) /*$wgDBTableOptions*/; |
| | 32 | +CREATE UNIQUE INDEX /*i*/md_module_skin ON /*_*/module_deps (md_module, md_skin); |
| | 33 | + |
| | 34 | +-- patch-msg_resource.sql |
| | 35 | +CREATE TABLE /*_*/msg_resource ( |
| | 36 | + -- Resource name |
| | 37 | + mr_resource varbinary(255) NOT NULL, |
| | 38 | + -- Language code |
| | 39 | + mr_lang varbinary(32) NOT NULL, |
| | 40 | + -- JSON blob. This is an incomplete JSON object, i.e. without the wrapping {} |
| | 41 | + mr_blob mediumblob NOT NULL, |
| | 42 | + -- Timestamp of last update |
| | 43 | + mr_timestamp binary(14) NOT NULL |
| | 44 | +) /*$wgDBTableOptions*/; |
| | 45 | +CREATE UNIQUE INDEX /*i*/mr_resource_lang ON /*_*/msg_resource(mr_resource, mr_lang); |
| | 46 | + |
| | 47 | +CREATE TABLE /*_*/msg_resource_links ( |
| | 48 | + mrl_resource varbinary(255) NOT NULL, |
| | 49 | + -- Message key |
| | 50 | + mrl_message varbinary(255) NOT NULL |
| | 51 | +) /*$wgDBTableOptions*/; |
| | 52 | +CREATE UNIQUE INDEX /*i*/mrl_message_resource ON /*_*/msg_resource_links (mrl_message, mrl_resource); |
| | 53 | + |
| | 54 | +-- patch-iw_api_and_wikiid.sql |
| | 55 | +ALTER TABLE /*_*/interwiki |
| | 56 | + ADD iw_api BLOB NOT NULL; |
| | 57 | +ALTER TABLE /*_*/interwiki |
| | 58 | + ADD iw_wikiid varchar(64) NOT NULL; |
| | 59 | + |
| | 60 | +-- patch-langlinks-ll_lang-20.sql |
| | 61 | +ALTER TABLE /*$wgDBprefix*/langlinks |
| | 62 | + MODIFY `ll_lang` |
| | 63 | + VARBINARY(20) NOT NULL DEFAULT ''; |
| | 64 | + |
| | 65 | +-- patch-afl_change_deleted_patrolled.sql |
| | 66 | +ALTER TABLE /*_*/abuse_filter_log MODIFY afl_deleted tinyint(1) NOT NULL DEFAULT 0; |
| | 67 | +ALTER TABLE /*_*/abuse_filter_log MODIFY afl_patrolled_by int unsigned NOT NULL DEFAULT 0; |
| | 68 | + |
| Property changes on: branches/wmf/1.17wmf1/maintenance/schema-changes-1.17wmf1-initial.sql |
| ___________________________________________________________________ |
| Added: svn:eol-style |
| 1 | 69 | + native |