diff options
| author | Daimona Eaytoy <daimona.wiki@gmail.com> | 2024-12-12 23:47:46 +0100 |
|---|---|---|
| committer | Daimona Eaytoy <daimona.wiki@gmail.com> | 2024-12-13 14:59:35 +0000 |
| commit | 09cdb3b66869998615a742caabe3a9cc32d8e991 (patch) | |
| tree | a131090755c519bdfca581fd59274310e786c1c1 /sql | |
| parent | 2d8285583f1866a0b00ec4df8365fb5fc63e0072 (diff) | |
| download | mediawikicore-09cdb3b66869998615a742caabe3a9cc32d8e991.tar.gz mediawikicore-09cdb3b66869998615a742caabe3a9cc32d8e991.zip | |
Re-generate all schema change files
This gives us a solid baseline to use for automated tests. Whitespace
differences will be ignored by the test, but regenerate these anyway
because they're much more readable now, and it's generally nice to have
a clean baseline.
Differences are due to:
- JSON files being moved in T382030
- JSON paths in the autogenerated comment are now standardized
(I358cc24798f518d7)
- Whitespace changes from Ib2f60b492ced8ff
- Actual SQL changes from newer versions of doctrine/dbal
There's also one important exception: the SQLite schema change for
patch-page-rename-name_title-index no longer matches the JSON file since
I17e73d5ef1. There doesn't seem to be a super-simple way around this,
because we don't know the state of the database pre-update. On top of
that, I believe that removing the field from the .sql file as done in
I17e73d5ef1 could've caused data loss when upgrading from old versions:
the column could be silently dropped before running the DB update that
correctly migrates and drop the column. This is something to keep in
mind going forwards, and T381981 will prevent it from happening that
easily. But for the update in question, it's probably too late, so just
update the JSON file to match the .sql files.
Bug: T381981
Bug: T382030
Change-Id: I3a3acc0935409d4601eb172664580b13d5fe2340
Diffstat (limited to 'sql')
109 files changed, 2053 insertions, 785 deletions
diff --git a/sql/abstractSchemaChanges/patch-page-rename-name_title-index.json b/sql/abstractSchemaChanges/patch-page-rename-name_title-index.json index 728548199220..b413571176e9 100644 --- a/sql/abstractSchemaChanges/patch-page-rename-name_title-index.json +++ b/sql/abstractSchemaChanges/patch-page-rename-name_title-index.json @@ -23,12 +23,6 @@ "options": { "notnull": true, "length": 255 } }, { - "name": "page_restrictions", - "comment": "Comma-separated set of permission keys indicating who can move or edit the page.", - "type": "blob", - "options": { "notnull": false, "length": 255 } - }, - { "name": "page_is_redirect", "comment": "1 indicates the article is a redirect.", "type": "mwtinyint", @@ -146,12 +140,6 @@ "options": { "notnull": true, "length": 255 } }, { - "name": "page_restrictions", - "comment": "Comma-separated set of permission keys indicating who can move or edit the page.", - "type": "blob", - "options": { "notnull": false, "length": 255 } - }, - { "name": "page_is_redirect", "comment": "1 indicates the article is a redirect.", "type": "mwtinyint", diff --git a/sql/mysql/patch-change_tag-ct_rc_id.sql b/sql/mysql/patch-change_tag-ct_rc_id.sql index 80fe84e4fc9a..c562dc285f9a 100644 --- a/sql/mysql/patch-change_tag-ct_rc_id.sql +++ b/sql/mysql/patch-change_tag-ct_rc_id.sql @@ -1,6 +1,6 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-change_tag-ct_rc_id.json +-- Source: sql/abstractSchemaChanges/patch-change_tag-ct_rc_id.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes -ALTER TABLE /*_*/change_tag -CHANGE ct_rc_id ct_rc_id BIGINT UNSIGNED DEFAULT NULL;
\ No newline at end of file +ALTER TABLE /*_*/change_tag + CHANGE ct_rc_id ct_rc_id BIGINT UNSIGNED DEFAULT NULL; diff --git a/sql/mysql/patch-change_tag-rename-indexes.sql b/sql/mysql/patch-change_tag-rename-indexes.sql index ef3cba025a15..8eec1f22b437 100644 --- a/sql/mysql/patch-change_tag-rename-indexes.sql +++ b/sql/mysql/patch-change_tag-rename-indexes.sql @@ -1,12 +1,18 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-change_tag-rename-indexes.json +-- Source: sql/abstractSchemaChanges/patch-change_tag-rename-indexes.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes -DROP INDEX change_tag_rc_tag_id ON /*_*/change_tag; -CREATE UNIQUE INDEX ct_rc_tag_id ON /*_*/change_tag (ct_rc_id, ct_tag_id); -DROP INDEX change_tag_log_tag_id ON /*_*/change_tag; -CREATE UNIQUE INDEX ct_log_tag_id ON /*_*/change_tag (ct_log_id, ct_tag_id); -DROP INDEX change_tag_rev_tag_id ON /*_*/change_tag; -CREATE UNIQUE INDEX ct_rev_tag_id ON /*_*/change_tag (ct_rev_id, ct_tag_id); -DROP INDEX change_tag_tag_id_id ON /*_*/change_tag; -CREATE INDEX ct_tag_id_id ON /*_*/change_tag ( ct_tag_id, ct_rc_id, ct_rev_id, ct_log_id );
\ No newline at end of file +DROP INDEX change_tag_rc_tag_id ON /*_*/change_tag; + +CREATE UNIQUE INDEX ct_rc_tag_id ON /*_*/change_tag (ct_rc_id, ct_tag_id); +DROP INDEX change_tag_log_tag_id ON /*_*/change_tag; + +CREATE UNIQUE INDEX ct_log_tag_id ON /*_*/change_tag (ct_log_id, ct_tag_id); +DROP INDEX change_tag_rev_tag_id ON /*_*/change_tag; + +CREATE UNIQUE INDEX ct_rev_tag_id ON /*_*/change_tag (ct_rev_id, ct_tag_id); +DROP INDEX change_tag_tag_id_id ON /*_*/change_tag; + +CREATE INDEX ct_tag_id_id ON /*_*/change_tag ( + ct_tag_id, ct_rc_id, ct_rev_id, ct_log_id + ); diff --git a/sql/mysql/patch-drop-cl_collation_ext.sql b/sql/mysql/patch-drop-cl_collation_ext.sql index aebe7e917d0b..e8890b57fa23 100644 --- a/sql/mysql/patch-drop-cl_collation_ext.sql +++ b/sql/mysql/patch-drop-cl_collation_ext.sql @@ -1,5 +1,5 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-drop-cl_collation_ext.json +-- Source: sql/abstractSchemaChanges/patch-drop-cl_collation_ext.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes DROP INDEX cl_collation_ext ON /*_*/categorylinks; diff --git a/sql/mysql/patch-drop-page_restrictions-pr_user.sql b/sql/mysql/patch-drop-page_restrictions-pr_user.sql index 1b630af6d01e..f22f53149fc5 100644 --- a/sql/mysql/patch-drop-page_restrictions-pr_user.sql +++ b/sql/mysql/patch-drop-page_restrictions-pr_user.sql @@ -1,6 +1,6 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-drop-page_restrictions-pr_user.json +-- Source: sql/abstractSchemaChanges/patch-drop-page_restrictions-pr_user.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes -ALTER TABLE /*_*/page_restrictions -DROP pr_user; +ALTER TABLE /*_*/page_restrictions + DROP pr_user; diff --git a/sql/mysql/patch-drop-rev_page_id.sql b/sql/mysql/patch-drop-rev_page_id.sql index 80975a881405..3700ab2ea384 100644 --- a/sql/mysql/patch-drop-rev_page_id.sql +++ b/sql/mysql/patch-drop-rev_page_id.sql @@ -1,5 +1,5 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-drop-rev_page_id.json +-- Source: sql/abstractSchemaChanges/patch-drop-rev_page_id.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes -DROP INDEX rev_page_id ON /*_*/revision;
\ No newline at end of file +DROP INDEX rev_page_id ON /*_*/revision; diff --git a/sql/mysql/patch-externallinks-drop-el_to.sql b/sql/mysql/patch-externallinks-drop-el_to.sql index 5316a0b257e7..055b9d402d83 100644 --- a/sql/mysql/patch-externallinks-drop-el_to.sql +++ b/sql/mysql/patch-externallinks-drop-el_to.sql @@ -1,12 +1,12 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-externallinks-drop-el_to.json +-- Source: sql/abstractSchemaChanges/patch-externallinks-drop-el_to.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes -DROP INDEX el_to ON /*_*/externallinks; -DROP INDEX el_index ON /*_*/externallinks; -DROP INDEX el_index_60 ON /*_*/externallinks; -DROP INDEX el_from_index_60 ON /*_*/externallinks; -ALTER TABLE /*_*/externallinks -DROP el_to, -DROP el_index, -DROP el_index_60;
\ No newline at end of file +DROP INDEX el_to ON /*_*/externallinks; +DROP INDEX el_index ON /*_*/externallinks; +DROP INDEX el_index_60 ON /*_*/externallinks; +DROP INDEX el_from_index_60 ON /*_*/externallinks; +ALTER TABLE /*_*/externallinks + DROP el_to, + DROP el_index, + DROP el_index_60; diff --git a/sql/mysql/patch-externallinks-el_to_default.sql b/sql/mysql/patch-externallinks-el_to_default.sql index 41a4e1f8f29d..24eebf1c200f 100644 --- a/sql/mysql/patch-externallinks-el_to_default.sql +++ b/sql/mysql/patch-externallinks-el_to_default.sql @@ -1,8 +1,8 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-externallinks-el_to_default.json +-- Source: sql/abstractSchemaChanges/patch-externallinks-el_to_default.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes -ALTER TABLE /*_*/externallinks -CHANGE el_to el_to BLOB DEFAULT NULL, -CHANGE el_index el_index BLOB DEFAULT NULL, -CHANGE el_index_60 el_index_60 VARBINARY(60) DEFAULT '' NOT NULL;
\ No newline at end of file +ALTER TABLE /*_*/externallinks + CHANGE el_to el_to BLOB DEFAULT NULL, + CHANGE el_index el_index BLOB DEFAULT NULL, + CHANGE el_index_60 el_index_60 VARBINARY(60) DEFAULT '' NOT NULL; diff --git a/sql/mysql/patch-externallinks-el_to_path.sql b/sql/mysql/patch-externallinks-el_to_path.sql index 189b7b14a13d..856bce709cd9 100644 --- a/sql/mysql/patch-externallinks-el_to_path.sql +++ b/sql/mysql/patch-externallinks-el_to_path.sql @@ -1,10 +1,15 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-externallinks-el_to_path.json +-- Source: sql/abstractSchemaChanges/patch-externallinks-el_to_path.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes -DROP INDEX el_from ON /*_*/externallinks; -ALTER TABLE /*_*/externallinks -ADD el_to_domain_index VARBINARY(255) DEFAULT '' NOT NULL, -ADD el_to_path BLOB DEFAULT NULL; -CREATE INDEX el_to_domain_index_to_path ON /*_*/externallinks ( el_to_domain_index, el_to_path(60) ); -CREATE INDEX el_from ON /*_*/externallinks (el_from);
\ No newline at end of file +DROP INDEX el_from ON /*_*/externallinks; +ALTER TABLE /*_*/externallinks + ADD el_to_domain_index VARBINARY(255) DEFAULT '' NOT NULL, + ADD el_to_path BLOB DEFAULT NULL; + +CREATE INDEX el_to_domain_index_to_path ON /*_*/externallinks ( + el_to_domain_index, + el_to_path(60) + ); + +CREATE INDEX el_from ON /*_*/externallinks (el_from); diff --git a/sql/mysql/patch-filearchive-fa_id.sql b/sql/mysql/patch-filearchive-fa_id.sql index 2a651cfed072..89d2a65cf404 100644 --- a/sql/mysql/patch-filearchive-fa_id.sql +++ b/sql/mysql/patch-filearchive-fa_id.sql @@ -1,6 +1,6 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-filearchive-fa_id.json +-- Source: sql/abstractSchemaChanges/patch-filearchive-fa_id.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes -ALTER TABLE /*_*/filearchive -CHANGE fa_id fa_id INT UNSIGNED AUTO_INCREMENT NOT NULL;
\ No newline at end of file +ALTER TABLE /*_*/filearchive + CHANGE fa_id fa_id INT UNSIGNED AUTO_INCREMENT NOT NULL; diff --git a/sql/mysql/patch-filearchive-fa_size_to_bigint.sql b/sql/mysql/patch-filearchive-fa_size_to_bigint.sql index 07aa6660559c..348275845bf0 100644 --- a/sql/mysql/patch-filearchive-fa_size_to_bigint.sql +++ b/sql/mysql/patch-filearchive-fa_size_to_bigint.sql @@ -1,6 +1,6 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: abstractSchemaChanges/patch-filearchive-fa_size_to_bigint.json +-- Source: sql/abstractSchemaChanges/patch-filearchive-fa_size_to_bigint.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes -ALTER TABLE /*_*/filearchive -CHANGE fa_size fa_size BIGINT UNSIGNED DEFAULT 0;
\ No newline at end of file +ALTER TABLE /*_*/filearchive + CHANGE fa_size fa_size BIGINT UNSIGNED DEFAULT 0; diff --git a/sql/mysql/patch-image-img_size_to_bigint.sql b/sql/mysql/patch-image-img_size_to_bigint.sql index 1c066fbfb7a8..9cd2e06c0d6b 100644 --- a/sql/mysql/patch-image-img_size_to_bigint.sql +++ b/sql/mysql/patch-image-img_size_to_bigint.sql @@ -1,6 +1,6 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: abstractSchemaChanges/patch-image-img_size_to_bigint.json +-- Source: sql/abstractSchemaChanges/patch-image-img_size_to_bigint.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes -ALTER TABLE /*_*/image -CHANGE img_size img_size BIGINT UNSIGNED DEFAULT 0 NOT NULL;
\ No newline at end of file +ALTER TABLE /*_*/image + CHANGE img_size img_size BIGINT UNSIGNED DEFAULT 0 NOT NULL; diff --git a/sql/mysql/patch-ipblocks-ipb_id.sql b/sql/mysql/patch-ipblocks-ipb_id.sql index b05d8ab779bc..fd8df86efe2f 100644 --- a/sql/mysql/patch-ipblocks-ipb_id.sql +++ b/sql/mysql/patch-ipblocks-ipb_id.sql @@ -1,7 +1,7 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-ipblocks-ipb_id.json +-- Source: sql/abstractSchemaChanges/patch-ipblocks-ipb_id.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes -ALTER TABLE /*_*/ipblocks -CHANGE ipb_id ipb_id INT UNSIGNED AUTO_INCREMENT NOT NULL, -CHANGE ipb_parent_block_id ipb_parent_block_id INT UNSIGNED DEFAULT NULL;
\ No newline at end of file +ALTER TABLE /*_*/ipblocks + CHANGE ipb_id ipb_id INT UNSIGNED AUTO_INCREMENT NOT NULL, + CHANGE ipb_parent_block_id ipb_parent_block_id INT UNSIGNED DEFAULT NULL; diff --git a/sql/mysql/patch-ipblocks_restrictions-ir_ipb_id.sql b/sql/mysql/patch-ipblocks_restrictions-ir_ipb_id.sql index 413b290dc3eb..78017b851ccb 100644 --- a/sql/mysql/patch-ipblocks_restrictions-ir_ipb_id.sql +++ b/sql/mysql/patch-ipblocks_restrictions-ir_ipb_id.sql @@ -1,6 +1,6 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-ipblocks_restrictions-ir_ipb_id.json +-- Source: sql/abstractSchemaChanges/patch-ipblocks_restrictions-ir_ipb_id.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes -ALTER TABLE /*_*/ipblocks_restrictions -CHANGE ir_ipb_id ir_ipb_id INT UNSIGNED NOT NULL;
\ No newline at end of file +ALTER TABLE /*_*/ipblocks_restrictions + CHANGE ir_ipb_id ir_ipb_id INT UNSIGNED NOT NULL; diff --git a/sql/mysql/patch-ipblocks_restrictions-ir_value.sql b/sql/mysql/patch-ipblocks_restrictions-ir_value.sql index c0ec90d1aa56..81bbac1259d6 100644 --- a/sql/mysql/patch-ipblocks_restrictions-ir_value.sql +++ b/sql/mysql/patch-ipblocks_restrictions-ir_value.sql @@ -1,6 +1,6 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-ipblocks_restrictions-ir_value.json +-- Source: sql/abstractSchemaChanges/patch-ipblocks_restrictions-ir_value.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes -ALTER TABLE /*_*/ipblocks_restrictions -CHANGE ir_value ir_value INT UNSIGNED NOT NULL;
\ No newline at end of file +ALTER TABLE /*_*/ipblocks_restrictions + CHANGE ir_value ir_value INT UNSIGNED NOT NULL; diff --git a/sql/mysql/patch-iwlinks-drop-iwl_prefix_from_title.sql b/sql/mysql/patch-iwlinks-drop-iwl_prefix_from_title.sql index 14d434eab661..01442f211919 100644 --- a/sql/mysql/patch-iwlinks-drop-iwl_prefix_from_title.sql +++ b/sql/mysql/patch-iwlinks-drop-iwl_prefix_from_title.sql @@ -1,5 +1,5 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-iwlinks-drop-iwl_prefix_from_title.json +-- Source: sql/abstractSchemaChanges/patch-iwlinks-drop-iwl_prefix_from_title.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes DROP INDEX iwl_prefix_from_title ON /*_*/iwlinks; diff --git a/sql/mysql/patch-logging-rename-indexes.sql b/sql/mysql/patch-logging-rename-indexes.sql index 551ae2128793..ec3cb19f45a6 100644 --- a/sql/mysql/patch-logging-rename-indexes.sql +++ b/sql/mysql/patch-logging-rename-indexes.sql @@ -1,12 +1,18 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-logging-rename-indexes.json +-- Source: sql/abstractSchemaChanges/patch-logging-rename-indexes.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes -DROP INDEX type_time ON /*_*/logging; -CREATE INDEX log_type_time ON /*_*/logging (log_type, log_timestamp); -DROP INDEX actor_time ON /*_*/logging; -CREATE INDEX log_actor_time ON /*_*/logging (log_actor, log_timestamp); -DROP INDEX page_time ON /*_*/logging; -CREATE INDEX log_page_time ON /*_*/logging ( log_namespace, log_title, log_timestamp ); -DROP INDEX times ON /*_*/logging; -CREATE INDEX log_times ON /*_*/logging (log_timestamp);
\ No newline at end of file +DROP INDEX type_time ON /*_*/logging; + +CREATE INDEX log_type_time ON /*_*/logging (log_type, log_timestamp); +DROP INDEX actor_time ON /*_*/logging; + +CREATE INDEX log_actor_time ON /*_*/logging (log_actor, log_timestamp); +DROP INDEX page_time ON /*_*/logging; + +CREATE INDEX log_page_time ON /*_*/logging ( + log_namespace, log_title, log_timestamp + ); +DROP INDEX times ON /*_*/logging; + +CREATE INDEX log_times ON /*_*/logging (log_timestamp); diff --git a/sql/mysql/patch-objectcache-modtoken.sql b/sql/mysql/patch-objectcache-modtoken.sql index a771643c0339..a8818f4d6035 100644 --- a/sql/mysql/patch-objectcache-modtoken.sql +++ b/sql/mysql/patch-objectcache-modtoken.sql @@ -1,7 +1,7 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-objectcache-modtoken.json +-- Source: sql/abstractSchemaChanges/patch-objectcache-modtoken.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes -ALTER TABLE /*_*/objectcache -ADD modtoken VARCHAR(17) DEFAULT '00000000000000000' NOT NULL, -ADD flags INT UNSIGNED DEFAULT NULL;
\ No newline at end of file +ALTER TABLE /*_*/objectcache + ADD modtoken VARCHAR(17) DEFAULT '00000000000000000' NOT NULL, + ADD flags INT UNSIGNED DEFAULT NULL; diff --git a/sql/mysql/patch-oldimage-oi_size_to_bigint.sql b/sql/mysql/patch-oldimage-oi_size_to_bigint.sql index 32cee222a57b..492620be206b 100644 --- a/sql/mysql/patch-oldimage-oi_size_to_bigint.sql +++ b/sql/mysql/patch-oldimage-oi_size_to_bigint.sql @@ -1,6 +1,6 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: abstractSchemaChanges/patch-oldimage-oi_size_to_bigint.json +-- Source: sql/abstractSchemaChanges/patch-oldimage-oi_size_to_bigint.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes -ALTER TABLE /*_*/oldimage -CHANGE oi_size oi_size BIGINT UNSIGNED DEFAULT 0 NOT NULL;
\ No newline at end of file +ALTER TABLE /*_*/oldimage + CHANGE oi_size oi_size BIGINT UNSIGNED DEFAULT 0 NOT NULL; diff --git a/sql/mysql/patch-oldimage-oi_timestamp.sql b/sql/mysql/patch-oldimage-oi_timestamp.sql index d7b20fb086dd..b98db8ae294a 100644 --- a/sql/mysql/patch-oldimage-oi_timestamp.sql +++ b/sql/mysql/patch-oldimage-oi_timestamp.sql @@ -1,5 +1,5 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-oldimage-oi_timestamp.json +-- Source: sql/abstractSchemaChanges/patch-oldimage-oi_timestamp.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes -CREATE INDEX oi_timestamp ON /*_*/oldimage (oi_timestamp);
\ No newline at end of file +CREATE INDEX oi_timestamp ON /*_*/oldimage (oi_timestamp); diff --git a/sql/mysql/patch-page-drop-page_restrictions.sql b/sql/mysql/patch-page-drop-page_restrictions.sql index c32a889d7e40..932d71f1d92d 100644 --- a/sql/mysql/patch-page-drop-page_restrictions.sql +++ b/sql/mysql/patch-page-drop-page_restrictions.sql @@ -1,6 +1,6 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-page-drop-page_restrictions.json +-- Source: sql/abstractSchemaChanges/patch-page-drop-page_restrictions.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes -ALTER TABLE /*_*/page -DROP page_restrictions;
\ No newline at end of file +ALTER TABLE /*_*/page + DROP page_restrictions; diff --git a/sql/mysql/patch-page-page_links_updated-noinfinite.sql b/sql/mysql/patch-page-page_links_updated-noinfinite.sql index a63869144c9f..cc8222c60c49 100644 --- a/sql/mysql/patch-page-page_links_updated-noinfinite.sql +++ b/sql/mysql/patch-page-page_links_updated-noinfinite.sql @@ -1,5 +1,5 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-page-page_links_updated-noinfinite.json +-- Source: sql/abstractSchemaChanges/patch-page-page_links_updated-noinfinite.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes ALTER TABLE /*_*/page diff --git a/sql/mysql/patch-page-rename-name_title-index.sql b/sql/mysql/patch-page-rename-name_title-index.sql index fb3c63b3e681..8945e8dee9d2 100644 --- a/sql/mysql/patch-page-rename-name_title-index.sql +++ b/sql/mysql/patch-page-rename-name_title-index.sql @@ -1,6 +1,7 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-page-rename-name_title-index.json +-- Source: sql/abstractSchemaChanges/patch-page-rename-name_title-index.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes -DROP INDEX name_title ON /*_*/page; -CREATE UNIQUE INDEX page_name_title ON /*_*/page (page_namespace, page_title);
\ No newline at end of file +DROP INDEX name_title ON /*_*/page; + +CREATE UNIQUE INDEX page_name_title ON /*_*/page (page_namespace, page_title); diff --git a/sql/mysql/patch-page_props-pp_page.sql b/sql/mysql/patch-page_props-pp_page.sql index bf905afec4c8..89d445a88bc1 100644 --- a/sql/mysql/patch-page_props-pp_page.sql +++ b/sql/mysql/patch-page_props-pp_page.sql @@ -1,6 +1,6 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-page_props-pp_page.json +-- Source: sql/abstractSchemaChanges/patch-page_props-pp_page.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes -ALTER TABLE /*_*/page_props -CHANGE pp_page pp_page INT UNSIGNED NOT NULL;
\ No newline at end of file +ALTER TABLE /*_*/page_props + CHANGE pp_page pp_page INT UNSIGNED NOT NULL; diff --git a/sql/mysql/patch-page_restrictions-pr_page.sql b/sql/mysql/patch-page_restrictions-pr_page.sql index cd433872d592..c4d579c51a67 100644 --- a/sql/mysql/patch-page_restrictions-pr_page.sql +++ b/sql/mysql/patch-page_restrictions-pr_page.sql @@ -1,6 +1,6 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-page_restrictions-pr_page.json +-- Source: sql/abstractSchemaChanges/patch-page_restrictions-pr_page.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes -ALTER TABLE /*_*/page_restrictions -CHANGE pr_page pr_page INT UNSIGNED NOT NULL;
\ No newline at end of file +ALTER TABLE /*_*/page_restrictions + CHANGE pr_page pr_page INT UNSIGNED NOT NULL; diff --git a/sql/mysql/patch-pagelinks-drop-pl_title.sql b/sql/mysql/patch-pagelinks-drop-pl_title.sql index b0ea1e80605c..272665fcb52e 100644 --- a/sql/mysql/patch-pagelinks-drop-pl_title.sql +++ b/sql/mysql/patch-pagelinks-drop-pl_title.sql @@ -1,5 +1,5 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-pagelinks-drop-pl_title.json +-- Source: sql/abstractSchemaChanges/patch-pagelinks-drop-pl_title.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes DROP INDEX pl_namespace ON /*_*/pagelinks; diff --git a/sql/mysql/patch-pagelinks-target_id.sql b/sql/mysql/patch-pagelinks-target_id.sql index 7039e2777f78..25ea05628985 100644 --- a/sql/mysql/patch-pagelinks-target_id.sql +++ b/sql/mysql/patch-pagelinks-target_id.sql @@ -1,8 +1,13 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-pagelinks-target_id.json +-- Source: sql/abstractSchemaChanges/patch-pagelinks-target_id.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes -ALTER TABLE /*_*/pagelinks -ADD pl_target_id BIGINT UNSIGNED DEFAULT NULL; -CREATE INDEX pl_target_id ON /*_*/pagelinks (pl_target_id, pl_from); -CREATE INDEX pl_backlinks_namespace_target_id ON /*_*/pagelinks ( pl_from_namespace, pl_target_id, pl_from );
\ No newline at end of file +ALTER TABLE /*_*/pagelinks + ADD pl_target_id BIGINT UNSIGNED DEFAULT NULL; + +CREATE INDEX pl_target_id ON /*_*/pagelinks (pl_target_id, pl_from); + +CREATE INDEX pl_backlinks_namespace_target_id ON /*_*/pagelinks ( + pl_from_namespace, pl_target_id, + pl_from + ); diff --git a/sql/mysql/patch-recentchanges-rc_id-bigint.sql b/sql/mysql/patch-recentchanges-rc_id-bigint.sql index 8d0a2d58381a..2915757c8b13 100644 --- a/sql/mysql/patch-recentchanges-rc_id-bigint.sql +++ b/sql/mysql/patch-recentchanges-rc_id-bigint.sql @@ -1,6 +1,6 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-recentchanges-rc_id-bigint.json +-- Source: sql/abstractSchemaChanges/patch-recentchanges-rc_id-bigint.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes -ALTER TABLE /*_*/recentchanges -CHANGE rc_id rc_id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL;
\ No newline at end of file +ALTER TABLE /*_*/recentchanges + CHANGE rc_id rc_id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL; diff --git a/sql/mysql/patch-recentchanges-rc_id.sql b/sql/mysql/patch-recentchanges-rc_id.sql index 940a38aace01..3d20ada6ca0f 100644 --- a/sql/mysql/patch-recentchanges-rc_id.sql +++ b/sql/mysql/patch-recentchanges-rc_id.sql @@ -1,6 +1,6 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-recentchanges-rc_id.json +-- Source: sql/abstractSchemaChanges/patch-recentchanges-rc_id.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes -ALTER TABLE /*_*/recentchanges -CHANGE rc_id rc_id INT UNSIGNED AUTO_INCREMENT NOT NULL;
\ No newline at end of file +ALTER TABLE /*_*/recentchanges + CHANGE rc_id rc_id INT UNSIGNED AUTO_INCREMENT NOT NULL; diff --git a/sql/mysql/patch-recentchanges-rc_new_name_timestamp.sql b/sql/mysql/patch-recentchanges-rc_new_name_timestamp.sql index a138bc63fdf5..00eac9a38fa3 100644 --- a/sql/mysql/patch-recentchanges-rc_new_name_timestamp.sql +++ b/sql/mysql/patch-recentchanges-rc_new_name_timestamp.sql @@ -1,6 +1,9 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-recentchanges-rc_new_name_timestamp.json +-- Source: sql/abstractSchemaChanges/patch-recentchanges-rc_new_name_timestamp.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes -DROP INDEX new_name_timestamp ON /*_*/recentchanges; -CREATE INDEX rc_new_name_timestamp ON /*_*/recentchanges ( rc_new, rc_namespace, rc_timestamp );
\ No newline at end of file +DROP INDEX new_name_timestamp ON /*_*/recentchanges; + +CREATE INDEX rc_new_name_timestamp ON /*_*/recentchanges ( + rc_new, rc_namespace, rc_timestamp + ); diff --git a/sql/mysql/patch-revision-cleanup.sql b/sql/mysql/patch-revision-cleanup.sql index 87f1b8e0cd57..bfc716db408e 100644 --- a/sql/mysql/patch-revision-cleanup.sql +++ b/sql/mysql/patch-revision-cleanup.sql @@ -1,5 +1,5 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-revision-cleanup.json +-- Source: sql/abstractSchemaChanges/patch-revision-cleanup.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes ALTER TABLE /*_*/revision diff --git a/sql/mysql/patch-revision-rename-index.sql b/sql/mysql/patch-revision-rename-index.sql index d771b4046384..b51dc41d540b 100644 --- a/sql/mysql/patch-revision-rename-index.sql +++ b/sql/mysql/patch-revision-rename-index.sql @@ -1,6 +1,7 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-revision-rename-index.json +-- Source: sql/abstractSchemaChanges/patch-revision-rename-index.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes -DROP INDEX page_timestamp ON /*_*/revision; -CREATE INDEX rev_page_timestamp ON /*_*/revision (rev_page, rev_timestamp);
\ No newline at end of file +DROP INDEX page_timestamp ON /*_*/revision; + +CREATE INDEX rev_page_timestamp ON /*_*/revision (rev_page, rev_timestamp); diff --git a/sql/mysql/patch-searchindex-pk-titlelength.sql b/sql/mysql/patch-searchindex-pk-titlelength.sql index 5e37ce32627c..2b28922a80e8 100644 --- a/sql/mysql/patch-searchindex-pk-titlelength.sql +++ b/sql/mysql/patch-searchindex-pk-titlelength.sql @@ -1,5 +1,5 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-searchindex-innodb-pk-titlelength.json +-- Source: sql/abstractSchemaChanges/patch-searchindex-pk-titlelength.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes DROP INDEX si_page ON /*_*/searchindex; diff --git a/sql/mysql/patch-site_identifiers-rename-indexes.sql b/sql/mysql/patch-site_identifiers-rename-indexes.sql index acf14c53422e..10128cc065a5 100644 --- a/sql/mysql/patch-site_identifiers-rename-indexes.sql +++ b/sql/mysql/patch-site_identifiers-rename-indexes.sql @@ -1,8 +1,10 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-site_identifiers-rename-indexes.json +-- Source: sql/abstractSchemaChanges/patch-site_identifiers-rename-indexes.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes -DROP INDEX site_ids_site ON /*_*/site_identifiers; -CREATE INDEX si_site ON /*_*/site_identifiers (si_site); -DROP INDEX site_ids_key ON /*_*/site_identifiers; -CREATE INDEX si_key ON /*_*/site_identifiers (si_key);
\ No newline at end of file +DROP INDEX site_ids_site ON /*_*/site_identifiers; + +CREATE INDEX si_site ON /*_*/site_identifiers (si_site); +DROP INDEX site_ids_key ON /*_*/site_identifiers; + +CREATE INDEX si_key ON /*_*/site_identifiers (si_key); diff --git a/sql/mysql/patch-sites-drop_indexes.sql b/sql/mysql/patch-sites-drop_indexes.sql index 5f413316af04..f5cb48c1eb35 100644 --- a/sql/mysql/patch-sites-drop_indexes.sql +++ b/sql/mysql/patch-sites-drop_indexes.sql @@ -1,5 +1,5 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-sites-drop_indexes.json +-- Source: sql/abstractSchemaChanges/patch-sites-drop_indexes.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes DROP INDEX site_type ON /*_*/sites; diff --git a/sql/mysql/patch-sites-rename-indexes.sql b/sql/mysql/patch-sites-rename-indexes.sql index bcfd2604475a..c4a1fa051be3 100644 --- a/sql/mysql/patch-sites-rename-indexes.sql +++ b/sql/mysql/patch-sites-rename-indexes.sql @@ -1,20 +1,28 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-sites-rename-indexes.json +-- Source: sql/abstractSchemaChanges/patch-sites-rename-indexes.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes -DROP INDEX sites_global_key ON /*_*/sites; -CREATE UNIQUE INDEX site_global_key ON /*_*/sites (site_global_key); -DROP INDEX sites_type ON /*_*/sites; -CREATE INDEX site_type ON /*_*/sites (site_type); -DROP INDEX sites_group ON /*_*/sites; -CREATE INDEX site_group ON /*_*/sites (site_group); -DROP INDEX sites_source ON /*_*/sites; -CREATE INDEX site_source ON /*_*/sites (site_source); -DROP INDEX sites_language ON /*_*/sites; -CREATE INDEX site_language ON /*_*/sites (site_language); -DROP INDEX sites_protocol ON /*_*/sites; -CREATE INDEX site_protocol ON /*_*/sites (site_protocol); -DROP INDEX sites_domain ON /*_*/sites; -CREATE INDEX site_domain ON /*_*/sites (site_domain); -DROP INDEX sites_forward ON /*_*/sites; -CREATE INDEX site_forward ON /*_*/sites (site_forward);
\ No newline at end of file +DROP INDEX sites_global_key ON /*_*/sites; + +CREATE UNIQUE INDEX site_global_key ON /*_*/sites (site_global_key); +DROP INDEX sites_type ON /*_*/sites; + +CREATE INDEX site_type ON /*_*/sites (site_type); +DROP INDEX sites_group ON /*_*/sites; + +CREATE INDEX site_group ON /*_*/sites (site_group); +DROP INDEX sites_source ON /*_*/sites; + +CREATE INDEX site_source ON /*_*/sites (site_source); +DROP INDEX sites_language ON /*_*/sites; + +CREATE INDEX site_language ON /*_*/sites (site_language); +DROP INDEX sites_protocol ON /*_*/sites; + +CREATE INDEX site_protocol ON /*_*/sites (site_protocol); +DROP INDEX sites_domain ON /*_*/sites; + +CREATE INDEX site_domain ON /*_*/sites (site_domain); +DROP INDEX sites_forward ON /*_*/sites; + +CREATE INDEX site_forward ON /*_*/sites (site_forward); diff --git a/sql/mysql/patch-templatelinks-drop-tl_title.sql b/sql/mysql/patch-templatelinks-drop-tl_title.sql index 2332d2c230f8..c7a58aca3960 100644 --- a/sql/mysql/patch-templatelinks-drop-tl_title.sql +++ b/sql/mysql/patch-templatelinks-drop-tl_title.sql @@ -1,9 +1,9 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-templatelinks-drop-tl_title.json +-- Source: sql/abstractSchemaChanges/patch-templatelinks-drop-tl_title.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes -DROP INDEX tl_namespace ON /*_*/templatelinks; -DROP INDEX tl_backlinks_namespace ON /*_*/templatelinks; -ALTER TABLE /*_*/templatelinks -DROP tl_namespace, -DROP tl_title;
\ No newline at end of file +DROP INDEX tl_namespace ON /*_*/templatelinks; +DROP INDEX tl_backlinks_namespace ON /*_*/templatelinks; +ALTER TABLE /*_*/templatelinks + DROP tl_namespace, + DROP tl_title; diff --git a/sql/mysql/patch-templatelinks-target_id.sql b/sql/mysql/patch-templatelinks-target_id.sql index 43cc6f53e784..58eafabc7680 100644 --- a/sql/mysql/patch-templatelinks-target_id.sql +++ b/sql/mysql/patch-templatelinks-target_id.sql @@ -1,8 +1,13 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-templatelinks-target_id.json +-- Source: sql/abstractSchemaChanges/patch-templatelinks-target_id.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes -ALTER TABLE /*_*/templatelinks -ADD tl_target_id BIGINT UNSIGNED DEFAULT NULL; -CREATE INDEX tl_target_id ON /*_*/templatelinks (tl_target_id, tl_from); -CREATE INDEX tl_backlinks_namespace_target_id ON /*_*/templatelinks ( tl_from_namespace, tl_target_id, tl_from );
\ No newline at end of file +ALTER TABLE /*_*/templatelinks + ADD tl_target_id BIGINT UNSIGNED DEFAULT NULL; + +CREATE INDEX tl_target_id ON /*_*/templatelinks (tl_target_id, tl_from); + +CREATE INDEX tl_backlinks_namespace_target_id ON /*_*/templatelinks ( + tl_from_namespace, tl_target_id, + tl_from + ); diff --git a/sql/mysql/patch-templatelinks-tl_title-nullable.sql b/sql/mysql/patch-templatelinks-tl_title-nullable.sql index 5770482e8c68..15ef1f767cca 100644 --- a/sql/mysql/patch-templatelinks-tl_title-nullable.sql +++ b/sql/mysql/patch-templatelinks-tl_title-nullable.sql @@ -1,10 +1,9 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-templatelinks-tl_title-nullable.json +-- Source: sql/abstractSchemaChanges/patch-templatelinks-tl_title-nullable.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes -ALTER TABLE /*_*/templatelinks -DROP PRIMARY KEY; -ALTER TABLE /*_*/templatelinks -CHANGE tl_target_id tl_target_id BIGINT UNSIGNED NOT NULL; -ALTER TABLE /*_*/templatelinks -ADD PRIMARY KEY (tl_from, tl_target_id);
\ No newline at end of file +DROP INDEX `primary` ON /*_*/templatelinks; +ALTER TABLE /*_*/templatelinks + CHANGE tl_target_id tl_target_id BIGINT UNSIGNED NOT NULL; +ALTER TABLE /*_*/templatelinks + ADD PRIMARY KEY (tl_from, tl_target_id); diff --git a/sql/mysql/patch-uploadstash-us_size_to_bigint.sql b/sql/mysql/patch-uploadstash-us_size_to_bigint.sql index 8bc37d5d72c7..39d3207748d6 100644 --- a/sql/mysql/patch-uploadstash-us_size_to_bigint.sql +++ b/sql/mysql/patch-uploadstash-us_size_to_bigint.sql @@ -1,6 +1,6 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: abstractSchemaChanges/patch-uploadstash-us_size_to_bigint.json +-- Source: sql/abstractSchemaChanges/patch-uploadstash-us_size_to_bigint.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes -ALTER TABLE /*_*/uploadstash -CHANGE us_size us_size BIGINT UNSIGNED NOT NULL;
\ No newline at end of file +ALTER TABLE /*_*/uploadstash + CHANGE us_size us_size BIGINT UNSIGNED NOT NULL; diff --git a/sql/mysql/patch-user-user_editcount.sql b/sql/mysql/patch-user-user_editcount.sql index 5c04e1ae77b5..5c2a675e4253 100644 --- a/sql/mysql/patch-user-user_editcount.sql +++ b/sql/mysql/patch-user-user_editcount.sql @@ -1,6 +1,6 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-user-user_editcount.json +-- Source: sql/abstractSchemaChanges/patch-user-user_editcount.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes -ALTER TABLE /*_*/user -CHANGE user_editcount user_editcount INT UNSIGNED DEFAULT NULL;
\ No newline at end of file +ALTER TABLE /*_*/user + CHANGE user_editcount user_editcount INT UNSIGNED DEFAULT NULL; diff --git a/sql/mysql/patch-user-user_is_temp.sql b/sql/mysql/patch-user-user_is_temp.sql index a64c6d34ff86..a4a7c6716970 100644 --- a/sql/mysql/patch-user-user_is_temp.sql +++ b/sql/mysql/patch-user-user_is_temp.sql @@ -1,6 +1,6 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-user-user_is_temp.json +-- Source: sql/abstractSchemaChanges/patch-user-user_is_temp.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes -ALTER TABLE /*_*/user -ADD user_is_temp TINYINT(1) DEFAULT 0 NOT NULL;
\ No newline at end of file +ALTER TABLE /*_*/user + ADD user_is_temp TINYINT(1) DEFAULT 0 NOT NULL; diff --git a/sql/mysql/patch-user_autocreate_serial-uas_year.sql b/sql/mysql/patch-user_autocreate_serial-uas_year.sql index 5065c07808c3..4b3fcf99d903 100644 --- a/sql/mysql/patch-user_autocreate_serial-uas_year.sql +++ b/sql/mysql/patch-user_autocreate_serial-uas_year.sql @@ -1,5 +1,5 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-user_autocreate_serial-uas_year.json +-- Source: sql/abstractSchemaChanges/patch-user_autocreate_serial-uas_year.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes DROP INDEX `primary` ON /*_*/user_autocreate_serial; diff --git a/sql/mysql/patch-user_properties-rename-index.sql b/sql/mysql/patch-user_properties-rename-index.sql index 6547e77c342a..7c38b07ccabf 100644 --- a/sql/mysql/patch-user_properties-rename-index.sql +++ b/sql/mysql/patch-user_properties-rename-index.sql @@ -1,6 +1,7 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-user_properties-rename-index.json +-- Source: sql/abstractSchemaChanges/patch-user_properties-rename-index.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes -DROP INDEX user_properties_property ON /*_*/user_properties; -CREATE INDEX up_property ON /*_*/user_properties (up_property);
\ No newline at end of file +DROP INDEX user_properties_property ON /*_*/user_properties; + +CREATE INDEX up_property ON /*_*/user_properties (up_property); diff --git a/sql/mysql/patch-user_table-updates.sql b/sql/mysql/patch-user_table-updates.sql index d2e072a98225..9bed8ddec870 100644 --- a/sql/mysql/patch-user_table-updates.sql +++ b/sql/mysql/patch-user_table-updates.sql @@ -1,8 +1,8 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-user_table-updates.json +-- Source: sql/abstractSchemaChanges/patch-user_table-updates.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes -ALTER TABLE /*_*/user -CHANGE user_name user_name VARBINARY(255) DEFAULT '' NOT NULL, -CHANGE user_real_name user_real_name VARBINARY(255) DEFAULT '' NOT NULL, -CHANGE user_touched user_touched BINARY(14) NOT NULL;
\ No newline at end of file +ALTER TABLE /*_*/user + CHANGE user_name user_name VARBINARY(255) DEFAULT '' NOT NULL, + CHANGE user_real_name user_real_name VARBINARY(255) DEFAULT '' NOT NULL, + CHANGE user_touched user_touched BINARY(14) NOT NULL; diff --git a/sql/mysql/patch-watchlist-namespace_title-rename-index.sql b/sql/mysql/patch-watchlist-namespace_title-rename-index.sql index 3974c4a7b19a..207f33f6ca44 100644 --- a/sql/mysql/patch-watchlist-namespace_title-rename-index.sql +++ b/sql/mysql/patch-watchlist-namespace_title-rename-index.sql @@ -1,6 +1,7 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-watchlist-namespace_title-rename-index.json +-- Source: sql/abstractSchemaChanges/patch-watchlist-namespace_title-rename-index.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes -DROP INDEX namespace_title ON /*_*/watchlist; -CREATE INDEX wl_namespace_title ON /*_*/watchlist (wl_namespace, wl_title);
\ No newline at end of file +DROP INDEX namespace_title ON /*_*/watchlist; + +CREATE INDEX wl_namespace_title ON /*_*/watchlist (wl_namespace, wl_title); diff --git a/sql/postgres/patch-change_tag-ct_rc_id.sql b/sql/postgres/patch-change_tag-ct_rc_id.sql index 6f1cd797f3aa..fe2a66ab5a5d 100644 --- a/sql/postgres/patch-change_tag-ct_rc_id.sql +++ b/sql/postgres/patch-change_tag-ct_rc_id.sql @@ -1,5 +1,6 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-change_tag-ct_rc_id.json +-- Source: sql/abstractSchemaChanges/patch-change_tag-ct_rc_id.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes -ALTER TABLE change_tag ALTER ct_rc_id TYPE BIGINT;
\ No newline at end of file +ALTER TABLE change_tag + ALTER ct_rc_id TYPE BIGINT; diff --git a/sql/postgres/patch-drop-cl_collation_ext.sql b/sql/postgres/patch-drop-cl_collation_ext.sql index d87903453afb..fdc0502664d1 100644 --- a/sql/postgres/patch-drop-cl_collation_ext.sql +++ b/sql/postgres/patch-drop-cl_collation_ext.sql @@ -1,5 +1,5 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-drop-cl_collation_ext.json +-- Source: sql/abstractSchemaChanges/patch-drop-cl_collation_ext.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes DROP INDEX cl_collation_ext; diff --git a/sql/postgres/patch-drop-rev_page_id.sql b/sql/postgres/patch-drop-rev_page_id.sql index eeaeffccea9a..7b1bf10338bd 100644 --- a/sql/postgres/patch-drop-rev_page_id.sql +++ b/sql/postgres/patch-drop-rev_page_id.sql @@ -1,5 +1,5 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-drop-rev_page_id.json +-- Source: sql/abstractSchemaChanges/patch-drop-rev_page_id.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes -DROP INDEX rev_page_id;
\ No newline at end of file +DROP INDEX rev_page_id; diff --git a/sql/postgres/patch-externallinks-drop-el_to.sql b/sql/postgres/patch-externallinks-drop-el_to.sql index db90fc7d962a..aa4d4399b01f 100644 --- a/sql/postgres/patch-externallinks-drop-el_to.sql +++ b/sql/postgres/patch-externallinks-drop-el_to.sql @@ -1,14 +1,14 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-externallinks-drop-el_to.json +-- Source: sql/abstractSchemaChanges/patch-externallinks-drop-el_to.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes -DROP INDEX el_to; -DROP INDEX el_index; -DROP INDEX el_index_60; -DROP INDEX el_from_index_60; -ALTER TABLE externallinks -DROP el_to; -ALTER TABLE externallinks -DROP el_index; -ALTER TABLE externallinks -DROP el_index_60;
\ No newline at end of file +DROP INDEX el_to; +DROP INDEX el_index; +DROP INDEX el_index_60; +DROP INDEX el_from_index_60; +ALTER TABLE externallinks + DROP el_to; +ALTER TABLE externallinks + DROP el_index; +ALTER TABLE externallinks + DROP el_index_60; diff --git a/sql/postgres/patch-externallinks-el_to_default.sql b/sql/postgres/patch-externallinks-el_to_default.sql index 9937c5c6dd5b..ce1cf15f2af3 100644 --- a/sql/postgres/patch-externallinks-el_to_default.sql +++ b/sql/postgres/patch-externallinks-el_to_default.sql @@ -1,14 +1,22 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-externallinks-el_to_default.json +-- Source: sql/abstractSchemaChanges/patch-externallinks-el_to_default.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes -ALTER TABLE externallinks ALTER el_to -SET DEFAULT ''; -ALTER TABLE externallinks ALTER el_to -DROP NOT NULL; -ALTER TABLE externallinks ALTER el_index -SET DEFAULT ''; -ALTER TABLE externallinks ALTER el_index -DROP NOT NULL; -ALTER TABLE externallinks ALTER el_index_60 -SET DEFAULT '';
\ No newline at end of file +ALTER TABLE externallinks + ALTER el_to +SET + DEFAULT ''; +ALTER TABLE externallinks + ALTER el_to + DROP NOT NULL; +ALTER TABLE externallinks + ALTER el_index +SET + DEFAULT ''; +ALTER TABLE externallinks + ALTER el_index + DROP NOT NULL; +ALTER TABLE externallinks + ALTER el_index_60 +SET + DEFAULT ''; diff --git a/sql/postgres/patch-externallinks-el_to_path.sql b/sql/postgres/patch-externallinks-el_to_path.sql index cc41845570a1..ec34e4fd2db8 100644 --- a/sql/postgres/patch-externallinks-el_to_path.sql +++ b/sql/postgres/patch-externallinks-el_to_path.sql @@ -1,11 +1,13 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-externallinks-el_to_path.json +-- Source: sql/abstractSchemaChanges/patch-externallinks-el_to_path.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes -DROP INDEX el_from; -ALTER TABLE externallinks -ADD el_to_domain_index TEXT DEFAULT '' NOT NULL; -ALTER TABLE externallinks -ADD el_to_path TEXT DEFAULT NULL; +DROP INDEX el_from; +ALTER TABLE externallinks + ADD el_to_domain_index TEXT DEFAULT '' NOT NULL; +ALTER TABLE externallinks + ADD el_to_path TEXT DEFAULT NULL; + CREATE INDEX el_to_domain_index_to_path ON externallinks (el_to_domain_index, el_to_path); -CREATE INDEX el_from ON externallinks (el_from);
\ No newline at end of file + +CREATE INDEX el_from ON externallinks (el_from); diff --git a/sql/postgres/patch-filearchive-fa_size_to_bigint.sql b/sql/postgres/patch-filearchive-fa_size_to_bigint.sql index df282d5ca67f..f95f22cae16e 100644 --- a/sql/postgres/patch-filearchive-fa_size_to_bigint.sql +++ b/sql/postgres/patch-filearchive-fa_size_to_bigint.sql @@ -1,5 +1,6 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: abstractSchemaChanges/patch-filearchive-fa_size_to_bigint.json +-- Source: sql/abstractSchemaChanges/patch-filearchive-fa_size_to_bigint.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes -ALTER TABLE filearchive ALTER fa_size TYPE BIGINT;
\ No newline at end of file +ALTER TABLE filearchive + ALTER fa_size TYPE BIGINT; diff --git a/sql/postgres/patch-image-img_size_to_bigint.sql b/sql/postgres/patch-image-img_size_to_bigint.sql index bb036d867a29..e32fb0599433 100644 --- a/sql/postgres/patch-image-img_size_to_bigint.sql +++ b/sql/postgres/patch-image-img_size_to_bigint.sql @@ -1,5 +1,6 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: abstractSchemaChanges/patch-image-img_size_to_bigint.json +-- Source: sql/abstractSchemaChanges/patch-image-img_size_to_bigint.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes -ALTER TABLE image ALTER img_size TYPE BIGINT;
\ No newline at end of file +ALTER TABLE image + ALTER img_size TYPE BIGINT; diff --git a/sql/postgres/patch-iwlinks-drop-iwl_prefix_from_title.sql b/sql/postgres/patch-iwlinks-drop-iwl_prefix_from_title.sql index 9bb9ad801463..577d0268339c 100644 --- a/sql/postgres/patch-iwlinks-drop-iwl_prefix_from_title.sql +++ b/sql/postgres/patch-iwlinks-drop-iwl_prefix_from_title.sql @@ -1,5 +1,5 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-iwlinks-drop-iwl_prefix_from_title.json +-- Source: sql/abstractSchemaChanges/patch-iwlinks-drop-iwl_prefix_from_title.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes DROP INDEX iwl_prefix_from_title; diff --git a/sql/postgres/patch-objectcache-modtoken.sql b/sql/postgres/patch-objectcache-modtoken.sql index 4fb2a325baec..e0f01df81be0 100644 --- a/sql/postgres/patch-objectcache-modtoken.sql +++ b/sql/postgres/patch-objectcache-modtoken.sql @@ -1,8 +1,8 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-objectcache-modtoken.json +-- Source: sql/abstractSchemaChanges/patch-objectcache-modtoken.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes -ALTER TABLE objectcache -ADD modtoken VARCHAR(17) DEFAULT '00000000000000000' NOT NULL; -ALTER TABLE objectcache -ADD flags INT DEFAULT NULL;
\ No newline at end of file +ALTER TABLE objectcache + ADD modtoken VARCHAR(17) DEFAULT '00000000000000000' NOT NULL; +ALTER TABLE objectcache + ADD flags INT DEFAULT NULL; diff --git a/sql/postgres/patch-oldimage-oi_size_to_bigint.sql b/sql/postgres/patch-oldimage-oi_size_to_bigint.sql index 39ba403324a1..297e3d7fa157 100644 --- a/sql/postgres/patch-oldimage-oi_size_to_bigint.sql +++ b/sql/postgres/patch-oldimage-oi_size_to_bigint.sql @@ -1,5 +1,6 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: abstractSchemaChanges/patch-oldimage-oi_size_to_bigint.json +-- Source: sql/abstractSchemaChanges/patch-oldimage-oi_size_to_bigint.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes -ALTER TABLE oldimage ALTER oi_size TYPE BIGINT;
\ No newline at end of file +ALTER TABLE oldimage + ALTER oi_size TYPE BIGINT; diff --git a/sql/postgres/patch-pagelinks-drop-pl_title.sql b/sql/postgres/patch-pagelinks-drop-pl_title.sql index 61330c70bbef..7068c92856f1 100644 --- a/sql/postgres/patch-pagelinks-drop-pl_title.sql +++ b/sql/postgres/patch-pagelinks-drop-pl_title.sql @@ -1,5 +1,5 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-pagelinks-drop-pl_title.json +-- Source: sql/abstractSchemaChanges/patch-pagelinks-drop-pl_title.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes DROP INDEX pl_namespace; diff --git a/sql/postgres/patch-pagelinks-target_id.sql b/sql/postgres/patch-pagelinks-target_id.sql index 1090ca85006c..d9d8fe8eb633 100644 --- a/sql/postgres/patch-pagelinks-target_id.sql +++ b/sql/postgres/patch-pagelinks-target_id.sql @@ -1,8 +1,13 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-pagelinks-target_id.json +-- Source: sql/abstractSchemaChanges/patch-pagelinks-target_id.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes -ALTER TABLE pagelinks -ADD pl_target_id BIGINT DEFAULT NULL; +ALTER TABLE pagelinks + ADD pl_target_id BIGINT DEFAULT NULL; + CREATE INDEX pl_target_id ON pagelinks (pl_target_id, pl_from); -CREATE INDEX pl_backlinks_namespace_target_id ON pagelinks ( pl_from_namespace, pl_target_id, pl_from );
\ No newline at end of file + +CREATE INDEX pl_backlinks_namespace_target_id ON pagelinks ( + pl_from_namespace, pl_target_id, + pl_from +); diff --git a/sql/postgres/patch-recentchanges-rc_id-bigint.sql b/sql/postgres/patch-recentchanges-rc_id-bigint.sql index 4ad0ece047e7..36ba4287b01d 100644 --- a/sql/postgres/patch-recentchanges-rc_id-bigint.sql +++ b/sql/postgres/patch-recentchanges-rc_id-bigint.sql @@ -1,5 +1,6 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-recentchanges-rc_id-bigint.json +-- Source: sql/abstractSchemaChanges/patch-recentchanges-rc_id-bigint.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes -ALTER TABLE recentchanges ALTER rc_id TYPE BIGINT;
\ No newline at end of file +ALTER TABLE recentchanges + ALTER rc_id TYPE BIGINT; diff --git a/sql/postgres/patch-recentchanges-rc_new_name_timestamp.sql b/sql/postgres/patch-recentchanges-rc_new_name_timestamp.sql index 97da1a5ad11e..a98597cc7d50 100644 --- a/sql/postgres/patch-recentchanges-rc_new_name_timestamp.sql +++ b/sql/postgres/patch-recentchanges-rc_new_name_timestamp.sql @@ -1,5 +1,6 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-recentchanges-rc_new_name_timestamp.json +-- Source: sql/abstractSchemaChanges/patch-recentchanges-rc_new_name_timestamp.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes -ALTER INDEX new_name_timestamp RENAME TO rc_new_name_timestamp;
\ No newline at end of file +ALTER INDEX new_name_timestamp + RENAME TO rc_new_name_timestamp; diff --git a/sql/postgres/patch-revision-cleanup.sql b/sql/postgres/patch-revision-cleanup.sql index 483d4b1ecfaa..fe4da0696a45 100644 --- a/sql/postgres/patch-revision-cleanup.sql +++ b/sql/postgres/patch-revision-cleanup.sql @@ -1,5 +1,5 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-revision-cleanup.json +-- Source: sql/abstractSchemaChanges/patch-revision-cleanup.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes ALTER TABLE revision diff --git a/sql/postgres/patch-searchindex-pk-titlelength.sql b/sql/postgres/patch-searchindex-pk-titlelength.sql index cee04e5b2aa9..ea1a06620d43 100644 --- a/sql/postgres/patch-searchindex-pk-titlelength.sql +++ b/sql/postgres/patch-searchindex-pk-titlelength.sql @@ -1,5 +1,5 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-searchindex-innodb-pk-titlelength.json +-- Source: sql/abstractSchemaChanges/patch-searchindex-pk-titlelength.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes DROP INDEX si_page; diff --git a/sql/postgres/patch-sites-drop_indexes.sql b/sql/postgres/patch-sites-drop_indexes.sql index 351756a420a2..59bf6a4df36f 100644 --- a/sql/postgres/patch-sites-drop_indexes.sql +++ b/sql/postgres/patch-sites-drop_indexes.sql @@ -1,5 +1,5 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-sites-drop_indexes.json +-- Source: sql/abstractSchemaChanges/patch-sites-drop_indexes.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes DROP INDEX site_type; diff --git a/sql/postgres/patch-templatelinks-drop-tl_title.sql b/sql/postgres/patch-templatelinks-drop-tl_title.sql index 4678d22717a6..4ea9ffc5781a 100644 --- a/sql/postgres/patch-templatelinks-drop-tl_title.sql +++ b/sql/postgres/patch-templatelinks-drop-tl_title.sql @@ -1,6 +1,10 @@ -DROP INDEX IF EXISTS tl_namespace; -DROP INDEX IF EXISTS tl_backlinks_namespace; -ALTER TABLE templatelinks -DROP tl_namespace; -ALTER TABLE templatelinks -DROP tl_title; +-- This file is automatically generated using maintenance/generateSchemaChangeSql.php. +-- Source: sql/abstractSchemaChanges/patch-templatelinks-drop-tl_title.json +-- Do not modify this file directly. +-- See https://www.mediawiki.org/wiki/Manual:Schema_changes +DROP INDEX tl_namespace; +DROP INDEX tl_backlinks_namespace; +ALTER TABLE templatelinks + DROP tl_namespace; +ALTER TABLE templatelinks + DROP tl_title; diff --git a/sql/postgres/patch-templatelinks-target_id.sql b/sql/postgres/patch-templatelinks-target_id.sql index 97ffddfd9003..6d7cf36efce8 100644 --- a/sql/postgres/patch-templatelinks-target_id.sql +++ b/sql/postgres/patch-templatelinks-target_id.sql @@ -1,8 +1,13 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-templatelinks-target_id.json +-- Source: sql/abstractSchemaChanges/patch-templatelinks-target_id.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes -ALTER TABLE templatelinks -ADD tl_target_id BIGINT DEFAULT NULL; +ALTER TABLE templatelinks + ADD tl_target_id BIGINT DEFAULT NULL; + CREATE INDEX tl_target_id ON templatelinks (tl_target_id, tl_from); -CREATE INDEX tl_backlinks_namespace_target_id ON templatelinks ( tl_from_namespace, tl_target_id, tl_from );
\ No newline at end of file + +CREATE INDEX tl_backlinks_namespace_target_id ON templatelinks ( + tl_from_namespace, tl_target_id, + tl_from +); diff --git a/sql/postgres/patch-uploadstash-us_size_to_bigint.sql b/sql/postgres/patch-uploadstash-us_size_to_bigint.sql index f8618a310118..04f283f04a75 100644 --- a/sql/postgres/patch-uploadstash-us_size_to_bigint.sql +++ b/sql/postgres/patch-uploadstash-us_size_to_bigint.sql @@ -1,5 +1,6 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: abstractSchemaChanges/patch-uploadstash-us_size_to_bigint.json +-- Source: sql/abstractSchemaChanges/patch-uploadstash-us_size_to_bigint.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes -ALTER TABLE uploadstash ALTER us_size TYPE BIGINT;
\ No newline at end of file +ALTER TABLE uploadstash + ALTER us_size TYPE BIGINT; diff --git a/sql/postgres/patch-user-user_is_temp.sql b/sql/postgres/patch-user-user_is_temp.sql index 7b84a93fca18..5dc790a69d7e 100644 --- a/sql/postgres/patch-user-user_is_temp.sql +++ b/sql/postgres/patch-user-user_is_temp.sql @@ -1,6 +1,6 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-user-user_is_temp.json +-- Source: sql/abstractSchemaChanges/patch-user-user_is_temp.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes -ALTER TABLE "user" -ADD user_is_temp SMALLINT DEFAULT 0 NOT NULL;
\ No newline at end of file +ALTER TABLE "user" + ADD user_is_temp SMALLINT DEFAULT 0 NOT NULL; diff --git a/sql/postgres/patch-user_autocreate_serial-uas_year.sql b/sql/postgres/patch-user_autocreate_serial-uas_year.sql index d00601b11f77..4f2e7e716f06 100644 --- a/sql/postgres/patch-user_autocreate_serial-uas_year.sql +++ b/sql/postgres/patch-user_autocreate_serial-uas_year.sql @@ -1,5 +1,5 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-user_autocreate_serial-uas_year.json +-- Source: sql/abstractSchemaChanges/patch-user_autocreate_serial-uas_year.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes ALTER TABLE user_autocreate_serial diff --git a/sql/sqlite/patch-change_tag-ct_rc_id.sql b/sql/sqlite/patch-change_tag-ct_rc_id.sql index 331d47d2b87e..29e84b525786 100644 --- a/sql/sqlite/patch-change_tag-ct_rc_id.sql +++ b/sql/sqlite/patch-change_tag-ct_rc_id.sql @@ -1,17 +1,47 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-change_tag-ct_rc_id.json +-- Source: sql/abstractSchemaChanges/patch-change_tag-ct_rc_id.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes CREATE TEMPORARY TABLE /*_*/__temp__change_tag AS -SELECT ct_id, ct_rc_id, ct_log_id, ct_rev_id, ct_params, ct_tag_id -FROM /*_*/change_tag; -DROP TABLE /*_*/change_tag; -CREATE TABLE /*_*/change_tag ( ct_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, ct_rc_id BIGINT UNSIGNED DEFAULT NULL, ct_log_id INTEGER UNSIGNED DEFAULT NULL, ct_rev_id INTEGER UNSIGNED DEFAULT NULL, ct_params BLOB DEFAULT NULL, ct_tag_id INTEGER UNSIGNED NOT NULL ); -INSERT INTO /*_*/change_tag ( ct_id, ct_rc_id, ct_log_id, ct_rev_id, ct_params, ct_tag_id ) -SELECT ct_id, ct_rc_id, ct_log_id, ct_rev_id, ct_params, ct_tag_id -FROM /*_*/__temp__change_tag; -DROP TABLE /*_*/__temp__change_tag; -CREATE UNIQUE INDEX ct_rc_tag_id ON /*_*/change_tag (ct_rc_id, ct_tag_id); -CREATE UNIQUE INDEX ct_log_tag_id ON /*_*/change_tag (ct_log_id, ct_tag_id); -CREATE UNIQUE INDEX ct_rev_tag_id ON /*_*/change_tag (ct_rev_id, ct_tag_id); -CREATE INDEX ct_tag_id_id ON /*_*/change_tag ( ct_tag_id, ct_rc_id, ct_rev_id, ct_log_id );
\ No newline at end of file +SELECT + ct_id, + ct_rc_id, + ct_log_id, + ct_rev_id, + ct_params, + ct_tag_id +FROM /*_*/change_tag; +DROP TABLE /*_*/change_tag; + + +CREATE TABLE /*_*/change_tag ( + ct_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, + ct_rc_id BIGINT UNSIGNED DEFAULT NULL, + ct_log_id INTEGER UNSIGNED DEFAULT NULL, + ct_rev_id INTEGER UNSIGNED DEFAULT NULL, + ct_params BLOB DEFAULT NULL, ct_tag_id INTEGER UNSIGNED NOT NULL + ); +INSERT INTO /*_*/change_tag ( + ct_id, ct_rc_id, ct_log_id, ct_rev_id, + ct_params, ct_tag_id + ) +SELECT + ct_id, + ct_rc_id, + ct_log_id, + ct_rev_id, + ct_params, + ct_tag_id +FROM + /*_*/__temp__change_tag; +DROP TABLE /*_*/__temp__change_tag; + +CREATE UNIQUE INDEX ct_rc_tag_id ON /*_*/change_tag (ct_rc_id, ct_tag_id); + +CREATE UNIQUE INDEX ct_log_tag_id ON /*_*/change_tag (ct_log_id, ct_tag_id); + +CREATE UNIQUE INDEX ct_rev_tag_id ON /*_*/change_tag (ct_rev_id, ct_tag_id); + +CREATE INDEX ct_tag_id_id ON /*_*/change_tag ( + ct_tag_id, ct_rc_id, ct_rev_id, ct_log_id + ); diff --git a/sql/sqlite/patch-change_tag-rename-indexes.sql b/sql/sqlite/patch-change_tag-rename-indexes.sql index 4da9f70cb499..0e5cb5c6f18c 100644 --- a/sql/sqlite/patch-change_tag-rename-indexes.sql +++ b/sql/sqlite/patch-change_tag-rename-indexes.sql @@ -1,21 +1,47 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-change_tag-rename-indexes.json +-- Source: sql/abstractSchemaChanges/patch-change_tag-rename-indexes.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes -DROP INDEX change_tag_rc_tag_id; -DROP INDEX change_tag_log_tag_id; -DROP INDEX change_tag_rev_tag_id; -DROP INDEX change_tag_tag_id_id; CREATE TEMPORARY TABLE /*_*/__temp__change_tag AS -SELECT ct_id, ct_rc_id, ct_log_id, ct_rev_id, ct_params, ct_tag_id -FROM /*_*/change_tag; -DROP TABLE /*_*/change_tag; -CREATE TABLE /*_*/change_tag ( ct_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, ct_rc_id INTEGER UNSIGNED DEFAULT NULL, ct_log_id INTEGER UNSIGNED DEFAULT NULL, ct_rev_id INTEGER UNSIGNED DEFAULT NULL, ct_params BLOB DEFAULT NULL, ct_tag_id INTEGER UNSIGNED NOT NULL ); -INSERT INTO /*_*/change_tag ( ct_id, ct_rc_id, ct_log_id, ct_rev_id, ct_params, ct_tag_id ) -SELECT ct_id, ct_rc_id, ct_log_id, ct_rev_id, ct_params, ct_tag_id -FROM /*_*/__temp__change_tag; -DROP TABLE /*_*/__temp__change_tag; -CREATE UNIQUE INDEX ct_rc_tag_id ON /*_*/change_tag (ct_rc_id, ct_tag_id); -CREATE UNIQUE INDEX ct_log_tag_id ON /*_*/change_tag (ct_log_id, ct_tag_id); -CREATE UNIQUE INDEX ct_rev_tag_id ON /*_*/change_tag (ct_rev_id, ct_tag_id); -CREATE INDEX ct_tag_id_id ON /*_*/change_tag ( ct_tag_id, ct_rc_id, ct_rev_id, ct_log_id );
\ No newline at end of file +SELECT + ct_id, + ct_rc_id, + ct_log_id, + ct_rev_id, + ct_params, + ct_tag_id +FROM /*_*/change_tag; +DROP TABLE /*_*/change_tag; + + +CREATE TABLE /*_*/change_tag ( + ct_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, + ct_rc_id INTEGER UNSIGNED DEFAULT NULL, + ct_log_id INTEGER UNSIGNED DEFAULT NULL, + ct_rev_id INTEGER UNSIGNED DEFAULT NULL, + ct_params BLOB DEFAULT NULL, ct_tag_id INTEGER UNSIGNED NOT NULL + ); +INSERT INTO /*_*/change_tag ( + ct_id, ct_rc_id, ct_log_id, ct_rev_id, + ct_params, ct_tag_id + ) +SELECT + ct_id, + ct_rc_id, + ct_log_id, + ct_rev_id, + ct_params, + ct_tag_id +FROM + /*_*/__temp__change_tag; +DROP TABLE /*_*/__temp__change_tag; + +CREATE UNIQUE INDEX ct_rc_tag_id ON /*_*/change_tag (ct_rc_id, ct_tag_id); + +CREATE UNIQUE INDEX ct_log_tag_id ON /*_*/change_tag (ct_log_id, ct_tag_id); + +CREATE UNIQUE INDEX ct_rev_tag_id ON /*_*/change_tag (ct_rev_id, ct_tag_id); + +CREATE INDEX ct_tag_id_id ON /*_*/change_tag ( + ct_tag_id, ct_rc_id, ct_rev_id, ct_log_id + ); diff --git a/sql/sqlite/patch-drop-cl_collation_ext.sql b/sql/sqlite/patch-drop-cl_collation_ext.sql index 2a8561080c7d..7243b71c6731 100644 --- a/sql/sqlite/patch-drop-cl_collation_ext.sql +++ b/sql/sqlite/patch-drop-cl_collation_ext.sql @@ -1,5 +1,5 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-drop-cl_collation_ext.json +-- Source: sql/abstractSchemaChanges/patch-drop-cl_collation_ext.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes CREATE TEMPORARY TABLE /*_*/__temp__categorylinks AS diff --git a/sql/sqlite/patch-drop-page_restrictions-pr_user.sql b/sql/sqlite/patch-drop-page_restrictions-pr_user.sql index f0880ae6797b..0971beddf76e 100644 --- a/sql/sqlite/patch-drop-page_restrictions-pr_user.sql +++ b/sql/sqlite/patch-drop-page_restrictions-pr_user.sql @@ -1,21 +1,44 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-drop-page_restrictions-pr_user.json +-- Source: sql/abstractSchemaChanges/patch-drop-page_restrictions-pr_user.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes -DROP INDEX pr_pagetype; -DROP INDEX pr_typelevel; -DROP INDEX pr_level; -DROP INDEX pr_cascade; CREATE TEMPORARY TABLE /*_*/__temp__page_restrictions AS -SELECT pr_id, pr_page, pr_type, pr_level, pr_cascade, pr_expiry -FROM /*_*/page_restrictions; -DROP TABLE /*_*/page_restrictions; -CREATE TABLE /*_*/page_restrictions ( pr_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, pr_page INTEGER NOT NULL, pr_type BLOB NOT NULL, pr_level BLOB NOT NULL, pr_cascade SMALLINT NOT NULL, pr_expiry BLOB DEFAULT NULL ); -INSERT INTO /*_*/page_restrictions ( pr_id, pr_page, pr_type, pr_level, pr_cascade, pr_expiry ) -SELECT pr_id, pr_page, pr_type, pr_level, pr_cascade, pr_expiry -FROM /*_*/__temp__page_restrictions; -DROP TABLE /*_*/__temp__page_restrictions; -CREATE UNIQUE INDEX pr_pagetype ON /*_*/page_restrictions (pr_page, pr_type); -CREATE INDEX pr_typelevel ON /*_*/page_restrictions (pr_type, pr_level); -CREATE INDEX pr_level ON /*_*/page_restrictions (pr_level); -CREATE INDEX pr_cascade ON /*_*/page_restrictions (pr_cascade); +SELECT + pr_id, + pr_page, + pr_type, + pr_level, + pr_cascade, + pr_expiry +FROM /*_*/page_restrictions; +DROP TABLE /*_*/page_restrictions; + + +CREATE TABLE /*_*/page_restrictions ( + pr_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, + pr_page INTEGER NOT NULL, pr_type BLOB NOT NULL, + pr_level BLOB NOT NULL, pr_cascade SMALLINT NOT NULL, + pr_expiry BLOB DEFAULT NULL + ); +INSERT INTO /*_*/page_restrictions ( + pr_id, pr_page, pr_type, pr_level, + pr_cascade, pr_expiry + ) +SELECT + pr_id, + pr_page, + pr_type, + pr_level, + pr_cascade, + pr_expiry +FROM + /*_*/__temp__page_restrictions; +DROP TABLE /*_*/__temp__page_restrictions; + +CREATE UNIQUE INDEX pr_pagetype ON /*_*/page_restrictions (pr_page, pr_type); + +CREATE INDEX pr_typelevel ON /*_*/page_restrictions (pr_type, pr_level); + +CREATE INDEX pr_level ON /*_*/page_restrictions (pr_level); + +CREATE INDEX pr_cascade ON /*_*/page_restrictions (pr_cascade); diff --git a/sql/sqlite/patch-drop-rev_page_id.sql b/sql/sqlite/patch-drop-rev_page_id.sql index 37683a787461..793a717fc5d1 100644 --- a/sql/sqlite/patch-drop-rev_page_id.sql +++ b/sql/sqlite/patch-drop-rev_page_id.sql @@ -1,22 +1,61 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-drop-rev_page_id.json +-- Source: sql/abstractSchemaChanges/patch-drop-rev_page_id.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes -DROP INDEX rev_page_id; -DROP INDEX rev_timestamp; -DROP INDEX rev_page_timestamp; -DROP INDEX rev_actor_timestamp; -DROP INDEX rev_page_actor_timestamp; CREATE TEMPORARY TABLE /*_*/__temp__revision AS -SELECT rev_id, rev_page, rev_comment_id, rev_actor, rev_timestamp, rev_minor_edit, rev_deleted, rev_len, rev_parent_id, rev_sha1 -FROM /*_*/revision; -DROP TABLE /*_*/revision; -CREATE TABLE /*_*/revision ( rev_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, rev_page INTEGER UNSIGNED NOT NULL, rev_comment_id BIGINT UNSIGNED DEFAULT 0 NOT NULL, rev_actor BIGINT UNSIGNED DEFAULT 0 NOT NULL, rev_timestamp BLOB NOT NULL, rev_minor_edit SMALLINT UNSIGNED DEFAULT 0 NOT NULL, rev_deleted SMALLINT UNSIGNED DEFAULT 0 NOT NULL, rev_len INTEGER UNSIGNED DEFAULT NULL, rev_parent_id INTEGER UNSIGNED DEFAULT NULL, rev_sha1 BLOB DEFAULT '' NOT NULL ); -INSERT INTO /*_*/revision ( rev_id, rev_page, rev_comment_id, rev_actor, rev_timestamp, rev_minor_edit, rev_deleted, rev_len, rev_parent_id, rev_sha1 ) -SELECT rev_id, rev_page, rev_comment_id, rev_actor, rev_timestamp, rev_minor_edit, rev_deleted, rev_len, rev_parent_id, rev_sha1 -FROM /*_*/__temp__revision; -DROP TABLE /*_*/__temp__revision; -CREATE INDEX rev_timestamp ON /*_*/revision (rev_timestamp); -CREATE INDEX rev_page_timestamp ON /*_*/revision (rev_page, rev_timestamp); -CREATE INDEX rev_actor_timestamp ON /*_*/revision (rev_actor, rev_timestamp, rev_id); -CREATE INDEX rev_page_actor_timestamp ON /*_*/revision ( rev_page, rev_actor, rev_timestamp );
\ No newline at end of file +SELECT + rev_id, + rev_page, + rev_comment_id, + rev_actor, + rev_timestamp, + rev_minor_edit, + rev_deleted, + rev_len, + rev_parent_id, + rev_sha1 +FROM /*_*/revision; +DROP TABLE /*_*/revision; + + +CREATE TABLE /*_*/revision ( + rev_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, + rev_page INTEGER UNSIGNED NOT NULL, + rev_comment_id BIGINT UNSIGNED DEFAULT 0 NOT NULL, + rev_actor BIGINT UNSIGNED DEFAULT 0 NOT NULL, + rev_timestamp BLOB NOT NULL, rev_minor_edit SMALLINT UNSIGNED DEFAULT 0 NOT NULL, + rev_deleted SMALLINT UNSIGNED DEFAULT 0 NOT NULL, + rev_len INTEGER UNSIGNED DEFAULT NULL, + rev_parent_id INTEGER UNSIGNED DEFAULT NULL, + rev_sha1 BLOB DEFAULT '' NOT NULL + ); +INSERT INTO /*_*/revision ( + rev_id, rev_page, rev_comment_id, + rev_actor, rev_timestamp, rev_minor_edit, + rev_deleted, rev_len, rev_parent_id, + rev_sha1 + ) +SELECT + rev_id, + rev_page, + rev_comment_id, + rev_actor, + rev_timestamp, + rev_minor_edit, + rev_deleted, + rev_len, + rev_parent_id, + rev_sha1 +FROM + /*_*/__temp__revision; +DROP TABLE /*_*/__temp__revision; + +CREATE INDEX rev_timestamp ON /*_*/revision (rev_timestamp); + +CREATE INDEX rev_page_timestamp ON /*_*/revision (rev_page, rev_timestamp); + +CREATE INDEX rev_actor_timestamp ON /*_*/revision (rev_actor, rev_timestamp, rev_id); + +CREATE INDEX rev_page_actor_timestamp ON /*_*/revision ( + rev_page, rev_actor, rev_timestamp + ); diff --git a/sql/sqlite/patch-externallinks-drop-el_to.sql b/sql/sqlite/patch-externallinks-drop-el_to.sql index d8041c8c03fd..e0d4b63bc3f6 100644 --- a/sql/sqlite/patch-externallinks-drop-el_to.sql +++ b/sql/sqlite/patch-externallinks-drop-el_to.sql @@ -1,15 +1,36 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-externallinks-drop-el_to.json +-- Source: sql/abstractSchemaChanges/patch-externallinks-drop-el_to.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes CREATE TEMPORARY TABLE /*_*/__temp__externallinks AS -SELECT el_id, el_from, el_to_domain_index, el_to_path -FROM /*_*/externallinks; -DROP TABLE /*_*/externallinks; -CREATE TABLE /*_*/externallinks ( el_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, el_from INTEGER UNSIGNED DEFAULT 0 NOT NULL, el_to_domain_index BLOB DEFAULT '' NOT NULL, el_to_path BLOB DEFAULT NULL ); -INSERT INTO /*_*/externallinks ( el_id, el_from, el_to_domain_index, el_to_path ) -SELECT el_id, el_from, el_to_domain_index, el_to_path -FROM /*_*/__temp__externallinks; -DROP TABLE /*_*/__temp__externallinks; -CREATE INDEX el_from ON /*_*/externallinks (el_from); -CREATE INDEX el_to_domain_index_to_path ON /*_*/externallinks (el_to_domain_index, el_to_path);
\ No newline at end of file +SELECT + el_id, + el_from, + el_to_domain_index, + el_to_path +FROM /*_*/externallinks; +DROP TABLE /*_*/externallinks; + + +CREATE TABLE /*_*/externallinks ( + el_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, + el_from INTEGER UNSIGNED DEFAULT 0 NOT NULL, + el_to_domain_index BLOB DEFAULT '' NOT NULL, + el_to_path BLOB DEFAULT NULL + ); +INSERT INTO /*_*/externallinks ( + el_id, el_from, el_to_domain_index, + el_to_path + ) +SELECT + el_id, + el_from, + el_to_domain_index, + el_to_path +FROM + /*_*/__temp__externallinks; +DROP TABLE /*_*/__temp__externallinks; + +CREATE INDEX el_from ON /*_*/externallinks (el_from); + +CREATE INDEX el_to_domain_index_to_path ON /*_*/externallinks (el_to_domain_index, el_to_path); diff --git a/sql/sqlite/patch-externallinks-el_to_default.sql b/sql/sqlite/patch-externallinks-el_to_default.sql index eb00d698701f..9e475c12b9f4 100644 --- a/sql/sqlite/patch-externallinks-el_to_default.sql +++ b/sql/sqlite/patch-externallinks-el_to_default.sql @@ -1,19 +1,52 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-externallinks-el_to_default.json +-- Source: sql/abstractSchemaChanges/patch-externallinks-el_to_default.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes CREATE TEMPORARY TABLE /*_*/__temp__externallinks AS -SELECT el_id, el_from, el_to, el_index, el_index_60, el_to_domain_index, el_to_path -FROM /*_*/externallinks; -DROP TABLE /*_*/externallinks; -CREATE TABLE /*_*/externallinks ( el_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, el_from INTEGER UNSIGNED DEFAULT 0 NOT NULL, el_to BLOB DEFAULT '', el_index BLOB DEFAULT '', el_index_60 BLOB DEFAULT '' NOT NULL, el_to_domain_index BLOB DEFAULT '' NOT NULL, el_to_path BLOB DEFAULT NULL ); -INSERT INTO /*_*/externallinks ( el_id, el_from, el_to, el_index, el_index_60, el_to_domain_index, el_to_path ) -SELECT el_id, el_from, el_to, el_index, el_index_60, el_to_domain_index, el_to_path -FROM /*_*/__temp__externallinks; -DROP TABLE /*_*/__temp__externallinks; -CREATE INDEX el_from ON /*_*/externallinks (el_from); -CREATE INDEX el_to ON /*_*/externallinks (el_to, el_from); -CREATE INDEX el_index ON /*_*/externallinks (el_index); -CREATE INDEX el_index_60 ON /*_*/externallinks (el_index_60, el_id); -CREATE INDEX el_from_index_60 ON /*_*/externallinks (el_from, el_index_60, el_id); -CREATE INDEX el_to_domain_index_to_path ON /*_*/externallinks (el_to_domain_index, el_to_path);
\ No newline at end of file +SELECT + el_id, + el_from, + el_to, + el_index, + el_index_60, + el_to_domain_index, + el_to_path +FROM /*_*/externallinks; +DROP TABLE /*_*/externallinks; + + +CREATE TABLE /*_*/externallinks ( + el_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, + el_from INTEGER UNSIGNED DEFAULT 0 NOT NULL, + el_to BLOB DEFAULT '', el_index BLOB DEFAULT '', + el_index_60 BLOB DEFAULT '' NOT NULL, + el_to_domain_index BLOB DEFAULT '' NOT NULL, + el_to_path BLOB DEFAULT NULL + ); +INSERT INTO /*_*/externallinks ( + el_id, el_from, el_to, el_index, el_index_60, + el_to_domain_index, el_to_path + ) +SELECT + el_id, + el_from, + el_to, + el_index, + el_index_60, + el_to_domain_index, + el_to_path +FROM + /*_*/__temp__externallinks; +DROP TABLE /*_*/__temp__externallinks; + +CREATE INDEX el_from ON /*_*/externallinks (el_from); + +CREATE INDEX el_to ON /*_*/externallinks (el_to, el_from); + +CREATE INDEX el_index ON /*_*/externallinks (el_index); + +CREATE INDEX el_index_60 ON /*_*/externallinks (el_index_60, el_id); + +CREATE INDEX el_from_index_60 ON /*_*/externallinks (el_from, el_index_60, el_id); + +CREATE INDEX el_to_domain_index_to_path ON /*_*/externallinks (el_to_domain_index, el_to_path); diff --git a/sql/sqlite/patch-externallinks-el_to_path.sql b/sql/sqlite/patch-externallinks-el_to_path.sql index 6ab5b1257ca8..9c4207361a89 100644 --- a/sql/sqlite/patch-externallinks-el_to_path.sql +++ b/sql/sqlite/patch-externallinks-el_to_path.sql @@ -1,24 +1,46 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-externallinks-el_to_path.json +-- Source: sql/abstractSchemaChanges/patch-externallinks-el_to_path.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes -DROP INDEX el_from; -DROP INDEX el_to; -DROP INDEX el_index; -DROP INDEX el_index_60; -DROP INDEX el_from_index_60; CREATE TEMPORARY TABLE /*_*/__temp__externallinks AS -SELECT el_id, el_from, el_to, el_index, el_index_60 -FROM /*_*/externallinks; -DROP TABLE /*_*/externallinks; -CREATE TABLE /*_*/externallinks ( el_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, el_from INTEGER UNSIGNED DEFAULT 0 NOT NULL, el_to BLOB NOT NULL, el_index BLOB NOT NULL, el_index_60 BLOB NOT NULL, el_to_domain_index BLOB DEFAULT '' NOT NULL, el_to_path BLOB DEFAULT NULL ); -INSERT INTO /*_*/externallinks ( el_id, el_from, el_to, el_index, el_index_60 ) -SELECT el_id, el_from, el_to, el_index, el_index_60 -FROM /*_*/__temp__externallinks; -DROP TABLE /*_*/__temp__externallinks; -CREATE INDEX el_from ON /*_*/externallinks (el_from); -CREATE INDEX el_to ON /*_*/externallinks (el_to, el_from); -CREATE INDEX el_index ON /*_*/externallinks (el_index); -CREATE INDEX el_index_60 ON /*_*/externallinks (el_index_60, el_id); -CREATE INDEX el_from_index_60 ON /*_*/externallinks (el_from, el_index_60, el_id); -CREATE INDEX el_to_domain_index_to_path ON /*_*/externallinks (el_to_domain_index, el_to_path);
\ No newline at end of file +SELECT + el_id, + el_from, + el_to, + el_index, + el_index_60 +FROM /*_*/externallinks; +DROP TABLE /*_*/externallinks; + + +CREATE TABLE /*_*/externallinks ( + el_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, + el_from INTEGER UNSIGNED DEFAULT 0 NOT NULL, + el_to BLOB NOT NULL, el_index BLOB NOT NULL, + el_index_60 BLOB NOT NULL, el_to_domain_index BLOB DEFAULT '' NOT NULL, + el_to_path BLOB DEFAULT NULL + ); +INSERT INTO /*_*/externallinks ( + el_id, el_from, el_to, el_index, el_index_60 + ) +SELECT + el_id, + el_from, + el_to, + el_index, + el_index_60 +FROM + /*_*/__temp__externallinks; +DROP TABLE /*_*/__temp__externallinks; + +CREATE INDEX el_from ON /*_*/externallinks (el_from); + +CREATE INDEX el_to ON /*_*/externallinks (el_to, el_from); + +CREATE INDEX el_index ON /*_*/externallinks (el_index); + +CREATE INDEX el_index_60 ON /*_*/externallinks (el_index_60, el_id); + +CREATE INDEX el_from_index_60 ON /*_*/externallinks (el_from, el_index_60, el_id); + +CREATE INDEX el_to_domain_index_to_path ON /*_*/externallinks (el_to_domain_index, el_to_path); diff --git a/sql/sqlite/patch-filearchive-fa_size_to_bigint.sql b/sql/sqlite/patch-filearchive-fa_size_to_bigint.sql index c350c1da210f..c199b0912ee3 100644 --- a/sql/sqlite/patch-filearchive-fa_size_to_bigint.sql +++ b/sql/sqlite/patch-filearchive-fa_size_to_bigint.sql @@ -1,18 +1,95 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: abstractSchemaChanges/patch-filearchive-fa_size_to_bigint.json +-- Source: sql/abstractSchemaChanges/patch-filearchive-fa_size_to_bigint.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes CREATE TEMPORARY TABLE /*_*/__temp__filearchive AS -SELECT fa_id, fa_name, fa_archive_name, fa_storage_group, fa_storage_key, fa_deleted_user, fa_deleted_timestamp, fa_deleted_reason_id, fa_size, fa_width, fa_height, fa_metadata, fa_bits, fa_media_type, fa_major_mime, fa_minor_mime, fa_description_id, fa_actor, fa_timestamp, fa_deleted, fa_sha1 -FROM /*_*/filearchive; -DROP TABLE /*_*/filearchive; -CREATE TABLE /*_*/filearchive ( fa_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, fa_name BLOB DEFAULT '' NOT NULL, fa_archive_name BLOB DEFAULT '', fa_storage_group BLOB DEFAULT NULL, fa_storage_key BLOB DEFAULT '', fa_deleted_user INTEGER DEFAULT NULL, fa_deleted_timestamp BLOB DEFAULT NULL, fa_deleted_reason_id BIGINT UNSIGNED NOT NULL, fa_size BIGINT UNSIGNED DEFAULT 0, fa_width INTEGER DEFAULT 0, fa_height INTEGER DEFAULT 0, fa_metadata BLOB DEFAULT NULL, fa_bits INTEGER DEFAULT 0, fa_media_type TEXT DEFAULT NULL, fa_major_mime TEXT DEFAULT 'unknown', fa_minor_mime BLOB DEFAULT 'unknown', fa_description_id BIGINT UNSIGNED NOT NULL, fa_actor BIGINT UNSIGNED NOT NULL, fa_timestamp BLOB DEFAULT NULL, fa_deleted SMALLINT UNSIGNED DEFAULT 0 NOT NULL, fa_sha1 BLOB DEFAULT '' NOT NULL ); -INSERT INTO /*_*/filearchive ( fa_id, fa_name, fa_archive_name, fa_storage_group, fa_storage_key, fa_deleted_user, fa_deleted_timestamp, fa_deleted_reason_id, fa_size, fa_width, fa_height, fa_metadata, fa_bits, fa_media_type, fa_major_mime, fa_minor_mime, fa_description_id, fa_actor, fa_timestamp, fa_deleted, fa_sha1 ) -SELECT fa_id, fa_name, fa_archive_name, fa_storage_group, fa_storage_key, fa_deleted_user, fa_deleted_timestamp, fa_deleted_reason_id, fa_size, fa_width, fa_height, fa_metadata, fa_bits, fa_media_type, fa_major_mime, fa_minor_mime, fa_description_id, fa_actor, fa_timestamp, fa_deleted, fa_sha1 -FROM /*_*/__temp__filearchive; -DROP TABLE /*_*/__temp__filearchive; -CREATE INDEX fa_name ON /*_*/filearchive (fa_name, fa_timestamp); -CREATE INDEX fa_storage_group ON /*_*/filearchive ( fa_storage_group, fa_storage_key ); -CREATE INDEX fa_deleted_timestamp ON /*_*/filearchive (fa_deleted_timestamp); -CREATE INDEX fa_actor_timestamp ON /*_*/filearchive (fa_actor, fa_timestamp); -CREATE INDEX fa_sha1 ON /*_*/filearchive (fa_sha1);
\ No newline at end of file +SELECT + fa_id, + fa_name, + fa_archive_name, + fa_storage_group, + fa_storage_key, + fa_deleted_user, + fa_deleted_timestamp, + fa_deleted_reason_id, + fa_size, + fa_width, + fa_height, + fa_metadata, + fa_bits, + fa_media_type, + fa_major_mime, + fa_minor_mime, + fa_description_id, + fa_actor, + fa_timestamp, + fa_deleted, + fa_sha1 +FROM /*_*/filearchive; +DROP TABLE /*_*/filearchive; + + +CREATE TABLE /*_*/filearchive ( + fa_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, + fa_name BLOB DEFAULT '' NOT NULL, fa_archive_name BLOB DEFAULT '', + fa_storage_group BLOB DEFAULT NULL, + fa_storage_key BLOB DEFAULT '', fa_deleted_user INTEGER DEFAULT NULL, + fa_deleted_timestamp BLOB DEFAULT NULL, + fa_deleted_reason_id BIGINT UNSIGNED NOT NULL, + fa_size BIGINT UNSIGNED DEFAULT 0, + fa_width INTEGER DEFAULT 0, fa_height INTEGER DEFAULT 0, + fa_metadata BLOB DEFAULT NULL, fa_bits INTEGER DEFAULT 0, + fa_media_type TEXT DEFAULT NULL, fa_major_mime TEXT DEFAULT 'unknown', + fa_minor_mime BLOB DEFAULT 'unknown', + fa_description_id BIGINT UNSIGNED NOT NULL, + fa_actor BIGINT UNSIGNED NOT NULL, + fa_timestamp BLOB DEFAULT NULL, fa_deleted SMALLINT UNSIGNED DEFAULT 0 NOT NULL, + fa_sha1 BLOB DEFAULT '' NOT NULL + ); +INSERT INTO /*_*/filearchive ( + fa_id, fa_name, fa_archive_name, fa_storage_group, + fa_storage_key, fa_deleted_user, + fa_deleted_timestamp, fa_deleted_reason_id, + fa_size, fa_width, fa_height, fa_metadata, + fa_bits, fa_media_type, fa_major_mime, + fa_minor_mime, fa_description_id, + fa_actor, fa_timestamp, fa_deleted, + fa_sha1 + ) +SELECT + fa_id, + fa_name, + fa_archive_name, + fa_storage_group, + fa_storage_key, + fa_deleted_user, + fa_deleted_timestamp, + fa_deleted_reason_id, + fa_size, + fa_width, + fa_height, + fa_metadata, + fa_bits, + fa_media_type, + fa_major_mime, + fa_minor_mime, + fa_description_id, + fa_actor, + fa_timestamp, + fa_deleted, + fa_sha1 +FROM + /*_*/__temp__filearchive; +DROP TABLE /*_*/__temp__filearchive; + +CREATE INDEX fa_name ON /*_*/filearchive (fa_name, fa_timestamp); + +CREATE INDEX fa_storage_group ON /*_*/filearchive ( + fa_storage_group, fa_storage_key + ); + +CREATE INDEX fa_deleted_timestamp ON /*_*/filearchive (fa_deleted_timestamp); + +CREATE INDEX fa_actor_timestamp ON /*_*/filearchive (fa_actor, fa_timestamp); + +CREATE INDEX fa_sha1 ON /*_*/filearchive (fa_sha1); diff --git a/sql/sqlite/patch-image-img_size_to_bigint.sql b/sql/sqlite/patch-image-img_size_to_bigint.sql index 05fa7871d3c2..29e6e20685b9 100644 --- a/sql/sqlite/patch-image-img_size_to_bigint.sql +++ b/sql/sqlite/patch-image-img_size_to_bigint.sql @@ -1,18 +1,75 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: abstractSchemaChanges/patch-image-img_size_to_bigint.json +-- Source: sql/abstractSchemaChanges/patch-image-img_size_to_bigint.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes CREATE TEMPORARY TABLE /*_*/__temp__image AS -SELECT img_name, img_size, img_width, img_height, img_metadata, img_bits, img_media_type, img_major_mime, img_minor_mime, img_description_id, img_actor, img_timestamp, img_sha1 -FROM /*_*/image; -DROP TABLE /*_*/image; -CREATE TABLE /*_*/image ( img_name BLOB DEFAULT '' NOT NULL, img_size BIGINT UNSIGNED DEFAULT 0 NOT NULL, img_width INTEGER DEFAULT 0 NOT NULL, img_height INTEGER DEFAULT 0 NOT NULL, img_metadata BLOB NOT NULL, img_bits INTEGER DEFAULT 0 NOT NULL, img_media_type TEXT DEFAULT NULL, img_major_mime TEXT DEFAULT 'unknown' NOT NULL, img_minor_mime BLOB DEFAULT 'unknown' NOT NULL, img_description_id BIGINT UNSIGNED NOT NULL, img_actor BIGINT UNSIGNED NOT NULL, img_timestamp BLOB NOT NULL, img_sha1 BLOB DEFAULT '' NOT NULL, PRIMARY KEY(img_name) ); -INSERT INTO /*_*/image ( img_name, img_size, img_width, img_height, img_metadata, img_bits, img_media_type, img_major_mime, img_minor_mime, img_description_id, img_actor, img_timestamp, img_sha1 ) -SELECT img_name, img_size, img_width, img_height, img_metadata, img_bits, img_media_type, img_major_mime, img_minor_mime, img_description_id, img_actor, img_timestamp, img_sha1 -FROM /*_*/__temp__image; -DROP TABLE /*_*/__temp__image; -CREATE INDEX img_actor_timestamp ON /*_*/image (img_actor, img_timestamp); -CREATE INDEX img_size ON /*_*/image (img_size); -CREATE INDEX img_timestamp ON /*_*/image (img_timestamp); -CREATE INDEX img_sha1 ON /*_*/image (img_sha1); -CREATE INDEX img_media_mime ON /*_*/image ( img_media_type, img_major_mime, img_minor_mime );
\ No newline at end of file +SELECT + img_name, + img_size, + img_width, + img_height, + img_metadata, + img_bits, + img_media_type, + img_major_mime, + img_minor_mime, + img_description_id, + img_actor, + img_timestamp, + img_sha1 +FROM /*_*/image; +DROP TABLE /*_*/image; + + +CREATE TABLE /*_*/image ( + img_name BLOB DEFAULT '' NOT NULL, + img_size BIGINT UNSIGNED DEFAULT 0 NOT NULL, + img_width INTEGER DEFAULT 0 NOT NULL, + img_height INTEGER DEFAULT 0 NOT NULL, + img_metadata BLOB NOT NULL, + img_bits INTEGER DEFAULT 0 NOT NULL, + img_media_type TEXT DEFAULT NULL, + img_major_mime TEXT DEFAULT 'unknown' NOT NULL, + img_minor_mime BLOB DEFAULT 'unknown' NOT NULL, + img_description_id BIGINT UNSIGNED NOT NULL, + img_actor BIGINT UNSIGNED NOT NULL, + img_timestamp BLOB NOT NULL, + img_sha1 BLOB DEFAULT '' NOT NULL, + PRIMARY KEY(img_name) + ); +INSERT INTO /*_*/image ( + img_name, img_size, img_width, img_height, + img_metadata, img_bits, img_media_type, + img_major_mime, img_minor_mime, + img_description_id, img_actor, img_timestamp, + img_sha1 + ) +SELECT + img_name, + img_size, + img_width, + img_height, + img_metadata, + img_bits, + img_media_type, + img_major_mime, + img_minor_mime, + img_description_id, + img_actor, + img_timestamp, + img_sha1 +FROM + /*_*/__temp__image; +DROP TABLE /*_*/__temp__image; + +CREATE INDEX img_actor_timestamp ON /*_*/image (img_actor, img_timestamp); + +CREATE INDEX img_size ON /*_*/image (img_size); + +CREATE INDEX img_timestamp ON /*_*/image (img_timestamp); + +CREATE INDEX img_sha1 ON /*_*/image (img_sha1); + +CREATE INDEX img_media_mime ON /*_*/image ( + img_media_type, img_major_mime, img_minor_mime + ); diff --git a/sql/sqlite/patch-ipblocks-ipb_id.sql b/sql/sqlite/patch-ipblocks-ipb_id.sql index 832214f735d9..1c475126b638 100644 --- a/sql/sqlite/patch-ipblocks-ipb_id.sql +++ b/sql/sqlite/patch-ipblocks-ipb_id.sql @@ -1,25 +1,87 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-ipblocks-ipb_id.json +-- Source: sql/abstractSchemaChanges/patch-ipblocks-ipb_id.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes -DROP INDEX ipb_address_unique; -DROP INDEX ipb_user; -DROP INDEX ipb_range; -DROP INDEX ipb_timestamp; -DROP INDEX ipb_expiry; -DROP INDEX ipb_parent_block_id; CREATE TEMPORARY TABLE /*_*/__temp__ipblocks AS -SELECT ipb_id, ipb_address, ipb_user, ipb_by_actor, ipb_reason_id, ipb_timestamp, ipb_auto, ipb_anon_only, ipb_create_account, ipb_enable_autoblock, ipb_expiry, ipb_range_start, ipb_range_end, ipb_deleted, ipb_block_email, ipb_allow_usertalk, ipb_parent_block_id, ipb_sitewide -FROM /*_*/ipblocks; -DROP TABLE /*_*/ipblocks; -CREATE TABLE /*_*/ipblocks ( ipb_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, ipb_address BLOB NOT NULL, ipb_user INTEGER UNSIGNED DEFAULT 0 NOT NULL, ipb_by_actor BIGINT UNSIGNED NOT NULL, ipb_reason_id BIGINT UNSIGNED NOT NULL, ipb_timestamp BLOB NOT NULL, ipb_auto SMALLINT DEFAULT 0 NOT NULL, ipb_anon_only SMALLINT DEFAULT 0 NOT NULL, ipb_create_account SMALLINT DEFAULT 1 NOT NULL, ipb_enable_autoblock SMALLINT DEFAULT 1 NOT NULL, ipb_expiry BLOB NOT NULL, ipb_range_start BLOB NOT NULL, ipb_range_end BLOB NOT NULL, ipb_deleted SMALLINT DEFAULT 0 NOT NULL, ipb_block_email SMALLINT DEFAULT 0 NOT NULL, ipb_allow_usertalk SMALLINT DEFAULT 0 NOT NULL, ipb_parent_block_id INTEGER UNSIGNED DEFAULT NULL, ipb_sitewide SMALLINT DEFAULT 1 NOT NULL ); -INSERT INTO /*_*/ipblocks ( ipb_id, ipb_address, ipb_user, ipb_by_actor, ipb_reason_id, ipb_timestamp, ipb_auto, ipb_anon_only, ipb_create_account, ipb_enable_autoblock, ipb_expiry, ipb_range_start, ipb_range_end, ipb_deleted, ipb_block_email, ipb_allow_usertalk, ipb_parent_block_id, ipb_sitewide ) -SELECT ipb_id, ipb_address, ipb_user, ipb_by_actor, ipb_reason_id, ipb_timestamp, ipb_auto, ipb_anon_only, ipb_create_account, ipb_enable_autoblock, ipb_expiry, ipb_range_start, ipb_range_end, ipb_deleted, ipb_block_email, ipb_allow_usertalk, ipb_parent_block_id, ipb_sitewide -FROM /*_*/__temp__ipblocks; -DROP TABLE /*_*/__temp__ipblocks; -CREATE UNIQUE INDEX ipb_address_unique ON /*_*/ipblocks (ipb_address, ipb_user, ipb_auto); -CREATE INDEX ipb_user ON /*_*/ipblocks (ipb_user); -CREATE INDEX ipb_range ON /*_*/ipblocks (ipb_range_start, ipb_range_end); -CREATE INDEX ipb_timestamp ON /*_*/ipblocks (ipb_timestamp); -CREATE INDEX ipb_expiry ON /*_*/ipblocks (ipb_expiry); -CREATE INDEX ipb_parent_block_id ON /*_*/ipblocks (ipb_parent_block_id);
\ No newline at end of file +SELECT + ipb_id, + ipb_address, + ipb_user, + ipb_by_actor, + ipb_reason_id, + ipb_timestamp, + ipb_auto, + ipb_anon_only, + ipb_create_account, + ipb_enable_autoblock, + ipb_expiry, + ipb_range_start, + ipb_range_end, + ipb_deleted, + ipb_block_email, + ipb_allow_usertalk, + ipb_parent_block_id, + ipb_sitewide +FROM /*_*/ipblocks; +DROP TABLE /*_*/ipblocks; + + +CREATE TABLE /*_*/ipblocks ( + ipb_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, + ipb_address BLOB NOT NULL, ipb_user INTEGER UNSIGNED DEFAULT 0 NOT NULL, + ipb_by_actor BIGINT UNSIGNED NOT NULL, + ipb_reason_id BIGINT UNSIGNED NOT NULL, + ipb_timestamp BLOB NOT NULL, ipb_auto SMALLINT DEFAULT 0 NOT NULL, + ipb_anon_only SMALLINT DEFAULT 0 NOT NULL, + ipb_create_account SMALLINT DEFAULT 1 NOT NULL, + ipb_enable_autoblock SMALLINT DEFAULT 1 NOT NULL, + ipb_expiry BLOB NOT NULL, ipb_range_start BLOB NOT NULL, + ipb_range_end BLOB NOT NULL, ipb_deleted SMALLINT DEFAULT 0 NOT NULL, + ipb_block_email SMALLINT DEFAULT 0 NOT NULL, + ipb_allow_usertalk SMALLINT DEFAULT 0 NOT NULL, + ipb_parent_block_id INTEGER UNSIGNED DEFAULT NULL, + ipb_sitewide SMALLINT DEFAULT 1 NOT NULL + ); +INSERT INTO /*_*/ipblocks ( + ipb_id, ipb_address, ipb_user, ipb_by_actor, + ipb_reason_id, ipb_timestamp, ipb_auto, + ipb_anon_only, ipb_create_account, + ipb_enable_autoblock, ipb_expiry, + ipb_range_start, ipb_range_end, + ipb_deleted, ipb_block_email, ipb_allow_usertalk, + ipb_parent_block_id, ipb_sitewide + ) +SELECT + ipb_id, + ipb_address, + ipb_user, + ipb_by_actor, + ipb_reason_id, + ipb_timestamp, + ipb_auto, + ipb_anon_only, + ipb_create_account, + ipb_enable_autoblock, + ipb_expiry, + ipb_range_start, + ipb_range_end, + ipb_deleted, + ipb_block_email, + ipb_allow_usertalk, + ipb_parent_block_id, + ipb_sitewide +FROM + /*_*/__temp__ipblocks; +DROP TABLE /*_*/__temp__ipblocks; + +CREATE UNIQUE INDEX ipb_address_unique ON /*_*/ipblocks (ipb_address, ipb_user, ipb_auto); + +CREATE INDEX ipb_user ON /*_*/ipblocks (ipb_user); + +CREATE INDEX ipb_range ON /*_*/ipblocks (ipb_range_start, ipb_range_end); + +CREATE INDEX ipb_timestamp ON /*_*/ipblocks (ipb_timestamp); + +CREATE INDEX ipb_expiry ON /*_*/ipblocks (ipb_expiry); + +CREATE INDEX ipb_parent_block_id ON /*_*/ipblocks (ipb_parent_block_id); diff --git a/sql/sqlite/patch-ipblocks_restrictions-ir_ipb_id.sql b/sql/sqlite/patch-ipblocks_restrictions-ir_ipb_id.sql index 49e6a7b05909..b1defaee4cd3 100644 --- a/sql/sqlite/patch-ipblocks_restrictions-ir_ipb_id.sql +++ b/sql/sqlite/patch-ipblocks_restrictions-ir_ipb_id.sql @@ -1,15 +1,29 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-ipblocks_restrictions-ir_ipb_id.json +-- Source: sql/abstractSchemaChanges/patch-ipblocks_restrictions-ir_ipb_id.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes -DROP INDEX ir_type_value; CREATE TEMPORARY TABLE /*_*/__temp__ipblocks_restrictions AS -SELECT ir_ipb_id, ir_type, ir_value -FROM /*_*/ipblocks_restrictions; -DROP TABLE /*_*/ipblocks_restrictions; -CREATE TABLE /*_*/ipblocks_restrictions ( ir_ipb_id INTEGER UNSIGNED NOT NULL, ir_type SMALLINT NOT NULL, ir_value INTEGER UNSIGNED NOT NULL, PRIMARY KEY(ir_ipb_id, ir_type, ir_value) ); -INSERT INTO /*_*/ipblocks_restrictions (ir_ipb_id, ir_type, ir_value) -SELECT ir_ipb_id, ir_type, ir_value -FROM /*_*/__temp__ipblocks_restrictions; -DROP TABLE /*_*/__temp__ipblocks_restrictions; -CREATE INDEX ir_type_value ON /*_*/ipblocks_restrictions (ir_type, ir_value);
\ No newline at end of file +SELECT + ir_ipb_id, + ir_type, + ir_value +FROM /*_*/ipblocks_restrictions; +DROP TABLE /*_*/ipblocks_restrictions; + + +CREATE TABLE /*_*/ipblocks_restrictions ( + ir_ipb_id INTEGER UNSIGNED NOT NULL, + ir_type SMALLINT NOT NULL, + ir_value INTEGER UNSIGNED NOT NULL, + PRIMARY KEY(ir_ipb_id, ir_type, ir_value) + ); +INSERT INTO /*_*/ipblocks_restrictions (ir_ipb_id, ir_type, ir_value) +SELECT + ir_ipb_id, + ir_type, + ir_value +FROM + /*_*/__temp__ipblocks_restrictions; +DROP TABLE /*_*/__temp__ipblocks_restrictions; + +CREATE INDEX ir_type_value ON /*_*/ipblocks_restrictions (ir_type, ir_value); diff --git a/sql/sqlite/patch-ipblocks_restrictions-ir_value.sql b/sql/sqlite/patch-ipblocks_restrictions-ir_value.sql index 4fdac77adf56..93e2245a47b6 100644 --- a/sql/sqlite/patch-ipblocks_restrictions-ir_value.sql +++ b/sql/sqlite/patch-ipblocks_restrictions-ir_value.sql @@ -1,15 +1,29 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-ipblocks_restrictions-ir_value.json +-- Source: sql/abstractSchemaChanges/patch-ipblocks_restrictions-ir_value.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes -DROP INDEX ir_type_value; CREATE TEMPORARY TABLE /*_*/__temp__ipblocks_restrictions AS -SELECT ir_ipb_id, ir_type, ir_value -FROM /*_*/ipblocks_restrictions; -DROP TABLE /*_*/ipblocks_restrictions; -CREATE TABLE /*_*/ipblocks_restrictions ( ir_ipb_id INTEGER NOT NULL, ir_type SMALLINT NOT NULL, ir_value INTEGER UNSIGNED NOT NULL, PRIMARY KEY(ir_ipb_id, ir_type, ir_value) ); -INSERT INTO /*_*/ipblocks_restrictions (ir_ipb_id, ir_type, ir_value) -SELECT ir_ipb_id, ir_type, ir_value -FROM /*_*/__temp__ipblocks_restrictions; -DROP TABLE /*_*/__temp__ipblocks_restrictions; -CREATE INDEX ir_type_value ON /*_*/ipblocks_restrictions (ir_type, ir_value);
\ No newline at end of file +SELECT + ir_ipb_id, + ir_type, + ir_value +FROM /*_*/ipblocks_restrictions; +DROP TABLE /*_*/ipblocks_restrictions; + + +CREATE TABLE /*_*/ipblocks_restrictions ( + ir_ipb_id INTEGER NOT NULL, + ir_type SMALLINT NOT NULL, + ir_value INTEGER UNSIGNED NOT NULL, + PRIMARY KEY(ir_ipb_id, ir_type, ir_value) + ); +INSERT INTO /*_*/ipblocks_restrictions (ir_ipb_id, ir_type, ir_value) +SELECT + ir_ipb_id, + ir_type, + ir_value +FROM + /*_*/__temp__ipblocks_restrictions; +DROP TABLE /*_*/__temp__ipblocks_restrictions; + +CREATE INDEX ir_type_value ON /*_*/ipblocks_restrictions (ir_type, ir_value); diff --git a/sql/sqlite/patch-iwlinks-drop-iwl_prefix_from_title.sql b/sql/sqlite/patch-iwlinks-drop-iwl_prefix_from_title.sql index f37b4ab29f3e..104220f67363 100644 --- a/sql/sqlite/patch-iwlinks-drop-iwl_prefix_from_title.sql +++ b/sql/sqlite/patch-iwlinks-drop-iwl_prefix_from_title.sql @@ -1,5 +1,5 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-iwlinks-drop-iwl_prefix_from_title.json +-- Source: sql/abstractSchemaChanges/patch-iwlinks-drop-iwl_prefix_from_title.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes CREATE TEMPORARY TABLE /*_*/__temp__iwlinks AS diff --git a/sql/sqlite/patch-logging-rename-indexes.sql b/sql/sqlite/patch-logging-rename-indexes.sql index f2da25425437..cf627d1816a7 100644 --- a/sql/sqlite/patch-logging-rename-indexes.sql +++ b/sql/sqlite/patch-logging-rename-indexes.sql @@ -1,27 +1,73 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-logging-rename-indexes.json +-- Source: sql/abstractSchemaChanges/patch-logging-rename-indexes.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes -DROP INDEX type_time; -DROP INDEX actor_time; -DROP INDEX page_time; -DROP INDEX times; -DROP INDEX log_actor_type_time; -DROP INDEX log_page_id_time; -DROP INDEX log_type_action; CREATE TEMPORARY TABLE /*_*/__temp__logging AS -SELECT log_id, log_type, log_action, log_timestamp, log_actor, log_namespace, log_title, log_page, log_comment_id, log_params, log_deleted -FROM /*_*/logging; -DROP TABLE /*_*/logging; -CREATE TABLE /*_*/logging ( log_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, log_type BLOB DEFAULT '' NOT NULL, log_action BLOB DEFAULT '' NOT NULL, log_timestamp BLOB DEFAULT '19700101000000' NOT NULL, log_actor BIGINT UNSIGNED NOT NULL, log_namespace INTEGER DEFAULT 0 NOT NULL, log_title BLOB DEFAULT '' NOT NULL, log_page INTEGER UNSIGNED DEFAULT NULL, log_comment_id BIGINT UNSIGNED NOT NULL, log_params BLOB NOT NULL, log_deleted SMALLINT UNSIGNED DEFAULT 0 NOT NULL ); -INSERT INTO /*_*/logging ( log_id, log_type, log_action, log_timestamp, log_actor, log_namespace, log_title, log_page, log_comment_id, log_params, log_deleted ) -SELECT log_id, log_type, log_action, log_timestamp, log_actor, log_namespace, log_title, log_page, log_comment_id, log_params, log_deleted -FROM /*_*/__temp__logging; -DROP TABLE /*_*/__temp__logging; -CREATE INDEX log_actor_type_time ON /*_*/logging ( log_actor, log_type, log_timestamp ); -CREATE INDEX log_page_id_time ON /*_*/logging (log_page, log_timestamp); -CREATE INDEX log_type_action ON /*_*/logging ( log_type, log_action, log_timestamp ); -CREATE INDEX log_type_time ON /*_*/logging (log_type, log_timestamp); -CREATE INDEX log_actor_time ON /*_*/logging (log_actor, log_timestamp); -CREATE INDEX log_page_time ON /*_*/logging ( log_namespace, log_title, log_timestamp ); -CREATE INDEX log_times ON /*_*/logging (log_timestamp);
\ No newline at end of file +SELECT + log_id, + log_type, + log_action, + log_timestamp, + log_actor, + log_namespace, + log_title, + log_page, + log_comment_id, + log_params, + log_deleted +FROM /*_*/logging; +DROP TABLE /*_*/logging; + + +CREATE TABLE /*_*/logging ( + log_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, + log_type BLOB DEFAULT '' NOT NULL, log_action BLOB DEFAULT '' NOT NULL, + log_timestamp BLOB DEFAULT '19700101000000' NOT NULL, + log_actor BIGINT UNSIGNED NOT NULL, + log_namespace INTEGER DEFAULT 0 NOT NULL, + log_title BLOB DEFAULT '' NOT NULL, + log_page INTEGER UNSIGNED DEFAULT NULL, + log_comment_id BIGINT UNSIGNED NOT NULL, + log_params BLOB NOT NULL, log_deleted SMALLINT UNSIGNED DEFAULT 0 NOT NULL + ); +INSERT INTO /*_*/logging ( + log_id, log_type, log_action, log_timestamp, + log_actor, log_namespace, log_title, + log_page, log_comment_id, log_params, + log_deleted + ) +SELECT + log_id, + log_type, + log_action, + log_timestamp, + log_actor, + log_namespace, + log_title, + log_page, + log_comment_id, + log_params, + log_deleted +FROM + /*_*/__temp__logging; +DROP TABLE /*_*/__temp__logging; + +CREATE INDEX log_actor_type_time ON /*_*/logging ( + log_actor, log_type, log_timestamp + ); + +CREATE INDEX log_page_id_time ON /*_*/logging (log_page, log_timestamp); + +CREATE INDEX log_type_action ON /*_*/logging ( + log_type, log_action, log_timestamp + ); + +CREATE INDEX log_type_time ON /*_*/logging (log_type, log_timestamp); + +CREATE INDEX log_actor_time ON /*_*/logging (log_actor, log_timestamp); + +CREATE INDEX log_page_time ON /*_*/logging ( + log_namespace, log_title, log_timestamp + ); + +CREATE INDEX log_times ON /*_*/logging (log_timestamp); diff --git a/sql/sqlite/patch-objectcache-modtoken.sql b/sql/sqlite/patch-objectcache-modtoken.sql index df327813d3d3..4f2b6c6a2b90 100644 --- a/sql/sqlite/patch-objectcache-modtoken.sql +++ b/sql/sqlite/patch-objectcache-modtoken.sql @@ -1,8 +1,8 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-objectcache-modtoken.json +-- Source: sql/abstractSchemaChanges/patch-objectcache-modtoken.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes -ALTER TABLE /*_*/objectcache -ADD COLUMN modtoken VARCHAR(17) DEFAULT '00000000000000000' NOT NULL; -ALTER TABLE /*_*/objectcache -ADD COLUMN flags INTEGER UNSIGNED DEFAULT NULL;
\ No newline at end of file +ALTER TABLE /*_*/objectcache + ADD COLUMN modtoken VARCHAR(17) DEFAULT '00000000000000000' NOT NULL; +ALTER TABLE /*_*/objectcache + ADD COLUMN flags INTEGER UNSIGNED DEFAULT NULL; diff --git a/sql/sqlite/patch-oldimage-oi_size_to_bigint.sql b/sql/sqlite/patch-oldimage-oi_size_to_bigint.sql index b6c813821196..bd0e987b7838 100644 --- a/sql/sqlite/patch-oldimage-oi_size_to_bigint.sql +++ b/sql/sqlite/patch-oldimage-oi_size_to_bigint.sql @@ -1,18 +1,75 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: abstractSchemaChanges/patch-oldimage-oi_size_to_bigint.json +-- Source: sql/abstractSchemaChanges/patch-oldimage-oi_size_to_bigint.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes CREATE TEMPORARY TABLE /*_*/__temp__oldimage AS -SELECT oi_name, oi_archive_name, oi_size, oi_width, oi_height, oi_bits, oi_description_id, oi_actor, oi_timestamp, oi_metadata, oi_media_type, oi_major_mime, oi_minor_mime, oi_deleted, oi_sha1 -FROM /*_*/oldimage; -DROP TABLE /*_*/oldimage; -CREATE TABLE /*_*/oldimage ( oi_name BLOB DEFAULT '' NOT NULL, oi_archive_name BLOB DEFAULT '' NOT NULL, oi_size BIGINT UNSIGNED DEFAULT 0 NOT NULL, oi_width INTEGER DEFAULT 0 NOT NULL, oi_height INTEGER DEFAULT 0 NOT NULL, oi_bits INTEGER DEFAULT 0 NOT NULL, oi_description_id BIGINT UNSIGNED NOT NULL, oi_actor BIGINT UNSIGNED NOT NULL, oi_timestamp BLOB NOT NULL, oi_metadata BLOB NOT NULL, oi_media_type TEXT DEFAULT NULL, oi_major_mime TEXT DEFAULT 'unknown' NOT NULL, oi_minor_mime BLOB DEFAULT 'unknown' NOT NULL, oi_deleted SMALLINT UNSIGNED DEFAULT 0 NOT NULL, oi_sha1 BLOB DEFAULT '' NOT NULL ); -INSERT INTO /*_*/oldimage ( oi_name, oi_archive_name, oi_size, oi_width, oi_height, oi_bits, oi_description_id, oi_actor, oi_timestamp, oi_metadata, oi_media_type, oi_major_mime, oi_minor_mime, oi_deleted, oi_sha1 ) -SELECT oi_name, oi_archive_name, oi_size, oi_width, oi_height, oi_bits, oi_description_id, oi_actor, oi_timestamp, oi_metadata, oi_media_type, oi_major_mime, oi_minor_mime, oi_deleted, oi_sha1 -FROM /*_*/__temp__oldimage; -DROP TABLE /*_*/__temp__oldimage; -CREATE INDEX oi_actor_timestamp ON /*_*/oldimage (oi_actor, oi_timestamp); -CREATE INDEX oi_name_timestamp ON /*_*/oldimage (oi_name, oi_timestamp); -CREATE INDEX oi_name_archive_name ON /*_*/oldimage (oi_name, oi_archive_name); -CREATE INDEX oi_sha1 ON /*_*/oldimage (oi_sha1); -CREATE INDEX oi_timestamp ON /*_*/oldimage (oi_timestamp);
\ No newline at end of file +SELECT + oi_name, + oi_archive_name, + oi_size, + oi_width, + oi_height, + oi_bits, + oi_description_id, + oi_actor, + oi_timestamp, + oi_metadata, + oi_media_type, + oi_major_mime, + oi_minor_mime, + oi_deleted, + oi_sha1 +FROM /*_*/oldimage; +DROP TABLE /*_*/oldimage; + + +CREATE TABLE /*_*/oldimage ( + oi_name BLOB DEFAULT '' NOT NULL, oi_archive_name BLOB DEFAULT '' NOT NULL, + oi_size BIGINT UNSIGNED DEFAULT 0 NOT NULL, + oi_width INTEGER DEFAULT 0 NOT NULL, + oi_height INTEGER DEFAULT 0 NOT NULL, + oi_bits INTEGER DEFAULT 0 NOT NULL, + oi_description_id BIGINT UNSIGNED NOT NULL, + oi_actor BIGINT UNSIGNED NOT NULL, + oi_timestamp BLOB NOT NULL, oi_metadata BLOB NOT NULL, + oi_media_type TEXT DEFAULT NULL, oi_major_mime TEXT DEFAULT 'unknown' NOT NULL, + oi_minor_mime BLOB DEFAULT 'unknown' NOT NULL, + oi_deleted SMALLINT UNSIGNED DEFAULT 0 NOT NULL, + oi_sha1 BLOB DEFAULT '' NOT NULL + ); +INSERT INTO /*_*/oldimage ( + oi_name, oi_archive_name, oi_size, + oi_width, oi_height, oi_bits, oi_description_id, + oi_actor, oi_timestamp, oi_metadata, + oi_media_type, oi_major_mime, oi_minor_mime, + oi_deleted, oi_sha1 + ) +SELECT + oi_name, + oi_archive_name, + oi_size, + oi_width, + oi_height, + oi_bits, + oi_description_id, + oi_actor, + oi_timestamp, + oi_metadata, + oi_media_type, + oi_major_mime, + oi_minor_mime, + oi_deleted, + oi_sha1 +FROM + /*_*/__temp__oldimage; +DROP TABLE /*_*/__temp__oldimage; + +CREATE INDEX oi_actor_timestamp ON /*_*/oldimage (oi_actor, oi_timestamp); + +CREATE INDEX oi_name_timestamp ON /*_*/oldimage (oi_name, oi_timestamp); + +CREATE INDEX oi_name_archive_name ON /*_*/oldimage (oi_name, oi_archive_name); + +CREATE INDEX oi_sha1 ON /*_*/oldimage (oi_sha1); + +CREATE INDEX oi_timestamp ON /*_*/oldimage (oi_timestamp); diff --git a/sql/sqlite/patch-oldimage-oi_timestamp.sql b/sql/sqlite/patch-oldimage-oi_timestamp.sql index 411a6f8ed277..c9c648c6d208 100644 --- a/sql/sqlite/patch-oldimage-oi_timestamp.sql +++ b/sql/sqlite/patch-oldimage-oi_timestamp.sql @@ -1,22 +1,75 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-oldimage-oi_timestamp.json +-- Source: sql/abstractSchemaChanges/patch-oldimage-oi_timestamp.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes -DROP INDEX oi_actor_timestamp; -DROP INDEX oi_name_timestamp; -DROP INDEX oi_name_archive_name; -DROP INDEX oi_sha1; CREATE TEMPORARY TABLE /*_*/__temp__oldimage AS -SELECT oi_name, oi_archive_name, oi_size, oi_width, oi_height, oi_bits, oi_description_id, oi_actor, oi_timestamp, oi_metadata, oi_media_type, oi_major_mime, oi_minor_mime, oi_deleted, oi_sha1 -FROM /*_*/oldimage; -DROP TABLE /*_*/oldimage; -CREATE TABLE /*_*/oldimage ( oi_name BLOB DEFAULT '' NOT NULL, oi_archive_name BLOB DEFAULT '' NOT NULL, oi_size INTEGER UNSIGNED DEFAULT 0 NOT NULL, oi_width INTEGER DEFAULT 0 NOT NULL, oi_height INTEGER DEFAULT 0 NOT NULL, oi_bits INTEGER DEFAULT 0 NOT NULL, oi_description_id BIGINT UNSIGNED NOT NULL, oi_actor BIGINT UNSIGNED NOT NULL, oi_timestamp BLOB NOT NULL, oi_metadata BLOB NOT NULL, oi_media_type TEXT DEFAULT NULL, oi_major_mime TEXT DEFAULT 'unknown' NOT NULL, oi_minor_mime BLOB DEFAULT 'unknown' NOT NULL, oi_deleted SMALLINT UNSIGNED DEFAULT 0 NOT NULL, oi_sha1 BLOB DEFAULT '' NOT NULL ); -INSERT INTO /*_*/oldimage ( oi_name, oi_archive_name, oi_size, oi_width, oi_height, oi_bits, oi_description_id, oi_actor, oi_timestamp, oi_metadata, oi_media_type, oi_major_mime, oi_minor_mime, oi_deleted, oi_sha1 ) -SELECT oi_name, oi_archive_name, oi_size, oi_width, oi_height, oi_bits, oi_description_id, oi_actor, oi_timestamp, oi_metadata, oi_media_type, oi_major_mime, oi_minor_mime, oi_deleted, oi_sha1 -FROM /*_*/__temp__oldimage; -DROP TABLE /*_*/__temp__oldimage; -CREATE INDEX oi_actor_timestamp ON /*_*/oldimage (oi_actor, oi_timestamp); -CREATE INDEX oi_name_timestamp ON /*_*/oldimage (oi_name, oi_timestamp); -CREATE INDEX oi_name_archive_name ON /*_*/oldimage (oi_name, oi_archive_name); -CREATE INDEX oi_sha1 ON /*_*/oldimage (oi_sha1); -CREATE INDEX oi_timestamp ON /*_*/oldimage (oi_timestamp);
\ No newline at end of file +SELECT + oi_name, + oi_archive_name, + oi_size, + oi_width, + oi_height, + oi_bits, + oi_description_id, + oi_actor, + oi_timestamp, + oi_metadata, + oi_media_type, + oi_major_mime, + oi_minor_mime, + oi_deleted, + oi_sha1 +FROM /*_*/oldimage; +DROP TABLE /*_*/oldimage; + + +CREATE TABLE /*_*/oldimage ( + oi_name BLOB DEFAULT '' NOT NULL, oi_archive_name BLOB DEFAULT '' NOT NULL, + oi_size INTEGER UNSIGNED DEFAULT 0 NOT NULL, + oi_width INTEGER DEFAULT 0 NOT NULL, + oi_height INTEGER DEFAULT 0 NOT NULL, + oi_bits INTEGER DEFAULT 0 NOT NULL, + oi_description_id BIGINT UNSIGNED NOT NULL, + oi_actor BIGINT UNSIGNED NOT NULL, + oi_timestamp BLOB NOT NULL, oi_metadata BLOB NOT NULL, + oi_media_type TEXT DEFAULT NULL, oi_major_mime TEXT DEFAULT 'unknown' NOT NULL, + oi_minor_mime BLOB DEFAULT 'unknown' NOT NULL, + oi_deleted SMALLINT UNSIGNED DEFAULT 0 NOT NULL, + oi_sha1 BLOB DEFAULT '' NOT NULL + ); +INSERT INTO /*_*/oldimage ( + oi_name, oi_archive_name, oi_size, + oi_width, oi_height, oi_bits, oi_description_id, + oi_actor, oi_timestamp, oi_metadata, + oi_media_type, oi_major_mime, oi_minor_mime, + oi_deleted, oi_sha1 + ) +SELECT + oi_name, + oi_archive_name, + oi_size, + oi_width, + oi_height, + oi_bits, + oi_description_id, + oi_actor, + oi_timestamp, + oi_metadata, + oi_media_type, + oi_major_mime, + oi_minor_mime, + oi_deleted, + oi_sha1 +FROM + /*_*/__temp__oldimage; +DROP TABLE /*_*/__temp__oldimage; + +CREATE INDEX oi_actor_timestamp ON /*_*/oldimage (oi_actor, oi_timestamp); + +CREATE INDEX oi_name_timestamp ON /*_*/oldimage (oi_name, oi_timestamp); + +CREATE INDEX oi_name_archive_name ON /*_*/oldimage (oi_name, oi_archive_name); + +CREATE INDEX oi_sha1 ON /*_*/oldimage (oi_sha1); + +CREATE INDEX oi_timestamp ON /*_*/oldimage (oi_timestamp); diff --git a/sql/sqlite/patch-page-drop-page_restrictions.sql b/sql/sqlite/patch-page-drop-page_restrictions.sql index 6b033808ef05..e21c06a34fe0 100644 --- a/sql/sqlite/patch-page-drop-page_restrictions.sql +++ b/sql/sqlite/patch-page-drop-page_restrictions.sql @@ -1,21 +1,68 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-page-drop-page_restrictions.json +-- Source: sql/abstractSchemaChanges/patch-page-drop-page_restrictions.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes -DROP INDEX page_name_title; -DROP INDEX page_random; -DROP INDEX page_len; -DROP INDEX page_redirect_namespace_len; CREATE TEMPORARY TABLE /*_*/__temp__page AS -SELECT page_id, page_namespace, page_title, page_is_redirect, page_is_new, page_random, page_touched, page_links_updated, page_latest, page_len, page_content_model, page_lang -FROM /*_*/page; -DROP TABLE /*_*/page; -CREATE TABLE /*_*/page ( page_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, page_namespace INTEGER NOT NULL, page_title BLOB NOT NULL, page_is_redirect SMALLINT UNSIGNED DEFAULT 0 NOT NULL, page_is_new SMALLINT UNSIGNED DEFAULT 0 NOT NULL, page_random DOUBLE PRECISION NOT NULL, page_touched BLOB NOT NULL, page_links_updated BLOB DEFAULT NULL, page_latest INTEGER UNSIGNED NOT NULL, page_len INTEGER UNSIGNED NOT NULL, page_content_model BLOB DEFAULT NULL, page_lang BLOB DEFAULT NULL ); -INSERT INTO /*_*/page ( page_id, page_namespace, page_title, page_is_redirect, page_is_new, page_random, page_touched, page_links_updated, page_latest, page_len, page_content_model, page_lang ) -SELECT page_id, page_namespace, page_title, page_is_redirect, page_is_new, page_random, page_touched, page_links_updated, page_latest, page_len, page_content_model, page_lang -FROM /*_*/__temp__page; -DROP TABLE /*_*/__temp__page; -CREATE UNIQUE INDEX page_name_title ON /*_*/page (page_namespace, page_title); -CREATE INDEX page_random ON /*_*/page (page_random); -CREATE INDEX page_len ON /*_*/page (page_len); -CREATE INDEX page_redirect_namespace_len ON /*_*/page ( page_is_redirect, page_namespace, page_len );
\ No newline at end of file +SELECT + page_id, + page_namespace, + page_title, + page_is_redirect, + page_is_new, + page_random, + page_touched, + page_links_updated, + page_latest, + page_len, + page_content_model, + page_lang +FROM /*_*/page; +DROP TABLE /*_*/page; + + +CREATE TABLE /*_*/page ( + page_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, + page_namespace INTEGER NOT NULL, page_title BLOB NOT NULL, + page_is_redirect SMALLINT UNSIGNED DEFAULT 0 NOT NULL, + page_is_new SMALLINT UNSIGNED DEFAULT 0 NOT NULL, + page_random DOUBLE PRECISION NOT NULL, + page_touched BLOB NOT NULL, page_links_updated BLOB DEFAULT NULL, + page_latest INTEGER UNSIGNED NOT NULL, + page_len INTEGER UNSIGNED NOT NULL, + page_content_model BLOB DEFAULT NULL, + page_lang BLOB DEFAULT NULL + ); +INSERT INTO /*_*/page ( + page_id, page_namespace, page_title, + page_is_redirect, page_is_new, page_random, + page_touched, page_links_updated, + page_latest, page_len, page_content_model, + page_lang + ) +SELECT + page_id, + page_namespace, + page_title, + page_is_redirect, + page_is_new, + page_random, + page_touched, + page_links_updated, + page_latest, + page_len, + page_content_model, + page_lang +FROM + /*_*/__temp__page; +DROP TABLE /*_*/__temp__page; + +CREATE UNIQUE INDEX page_name_title ON /*_*/page (page_namespace, page_title); + +CREATE INDEX page_random ON /*_*/page (page_random); + +CREATE INDEX page_len ON /*_*/page (page_len); + +CREATE INDEX page_redirect_namespace_len ON /*_*/page ( + page_is_redirect, page_namespace, + page_len + ); diff --git a/sql/sqlite/patch-page-rename-name_title-index.sql b/sql/sqlite/patch-page-rename-name_title-index.sql index d1f2f1ff1bae..5bcd56225c2e 100644 --- a/sql/sqlite/patch-page-rename-name_title-index.sql +++ b/sql/sqlite/patch-page-rename-name_title-index.sql @@ -1,21 +1,68 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-page-rename-name_title-index.json +-- Source: sql/abstractSchemaChanges/patch-page-rename-name_title-index.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes -DROP INDEX name_title; -DROP INDEX page_random; -DROP INDEX page_len; -DROP INDEX page_redirect_namespace_len; CREATE TEMPORARY TABLE /*_*/__temp__page AS -SELECT page_id, page_namespace, page_title, page_is_redirect, page_is_new, page_random, page_touched, page_links_updated, page_latest, page_len, page_content_model, page_lang -FROM /*_*/page; -DROP TABLE /*_*/page; -CREATE TABLE /*_*/page ( page_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, page_namespace INTEGER NOT NULL, page_title BLOB NOT NULL, page_is_redirect SMALLINT DEFAULT 0 NOT NULL, page_is_new SMALLINT DEFAULT 0 NOT NULL, page_random DOUBLE PRECISION NOT NULL, page_touched BLOB NOT NULL, page_links_updated BLOB DEFAULT NULL, page_latest INTEGER UNSIGNED NOT NULL, page_len INTEGER UNSIGNED NOT NULL, page_content_model BLOB DEFAULT NULL, page_lang BLOB DEFAULT NULL ); -INSERT INTO /*_*/page ( page_id, page_namespace, page_title, page_is_redirect, page_is_new, page_random, page_touched, page_links_updated, page_latest, page_len, page_content_model, page_lang ) -SELECT page_id, page_namespace, page_title, page_is_redirect, page_is_new, page_random, page_touched, page_links_updated, page_latest, page_len, page_content_model, page_lang -FROM /*_*/__temp__page; -DROP TABLE /*_*/__temp__page; -CREATE INDEX page_random ON /*_*/page (page_random); -CREATE INDEX page_len ON /*_*/page (page_len); -CREATE INDEX page_redirect_namespace_len ON /*_*/page ( page_is_redirect, page_namespace, page_len ); -CREATE UNIQUE INDEX page_name_title ON /*_*/page (page_namespace, page_title); +SELECT + page_id, + page_namespace, + page_title, + page_is_redirect, + page_is_new, + page_random, + page_touched, + page_links_updated, + page_latest, + page_len, + page_content_model, + page_lang +FROM /*_*/page; +DROP TABLE /*_*/page; + + +CREATE TABLE /*_*/page ( + page_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, + page_namespace INTEGER NOT NULL, page_title BLOB NOT NULL, + page_is_redirect SMALLINT DEFAULT 0 NOT NULL, + page_is_new SMALLINT DEFAULT 0 NOT NULL, + page_random DOUBLE PRECISION NOT NULL, + page_touched BLOB NOT NULL, page_links_updated BLOB DEFAULT NULL, + page_latest INTEGER UNSIGNED NOT NULL, + page_len INTEGER UNSIGNED NOT NULL, + page_content_model BLOB DEFAULT NULL, + page_lang BLOB DEFAULT NULL + ); +INSERT INTO /*_*/page ( + page_id, page_namespace, page_title, + page_is_redirect, page_is_new, page_random, + page_touched, page_links_updated, + page_latest, page_len, page_content_model, + page_lang + ) +SELECT + page_id, + page_namespace, + page_title, + page_is_redirect, + page_is_new, + page_random, + page_touched, + page_links_updated, + page_latest, + page_len, + page_content_model, + page_lang +FROM + /*_*/__temp__page; +DROP TABLE /*_*/__temp__page; + +CREATE INDEX page_random ON /*_*/page (page_random); + +CREATE INDEX page_len ON /*_*/page (page_len); + +CREATE INDEX page_redirect_namespace_len ON /*_*/page ( + page_is_redirect, page_namespace, + page_len + ); + +CREATE UNIQUE INDEX page_name_title ON /*_*/page (page_namespace, page_title); diff --git a/sql/sqlite/patch-page_props-pp_page.sql b/sql/sqlite/patch-page_props-pp_page.sql index b69252ac4a66..382185a1db0d 100644 --- a/sql/sqlite/patch-page_props-pp_page.sql +++ b/sql/sqlite/patch-page_props-pp_page.sql @@ -1,17 +1,36 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-page_props-pp_page.json +-- Source: sql/abstractSchemaChanges/patch-page_props-pp_page.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes -DROP INDEX pp_propname_page; -DROP INDEX pp_propname_sortkey_page; CREATE TEMPORARY TABLE /*_*/__temp__page_props AS -SELECT pp_page, pp_propname, pp_value, pp_sortkey -FROM /*_*/page_props; -DROP TABLE /*_*/page_props; -CREATE TABLE /*_*/page_props ( pp_page INTEGER UNSIGNED NOT NULL, pp_propname BLOB NOT NULL, pp_value BLOB NOT NULL, pp_sortkey DOUBLE PRECISION DEFAULT NULL, PRIMARY KEY(pp_page, pp_propname) ); -INSERT INTO /*_*/page_props ( pp_page, pp_propname, pp_value, pp_sortkey ) -SELECT pp_page, pp_propname, pp_value, pp_sortkey -FROM /*_*/__temp__page_props; -DROP TABLE /*_*/__temp__page_props; -CREATE UNIQUE INDEX pp_propname_page ON /*_*/page_props (pp_propname, pp_page); -CREATE UNIQUE INDEX pp_propname_sortkey_page ON /*_*/page_props (pp_propname, pp_sortkey, pp_page);
\ No newline at end of file +SELECT + pp_page, + pp_propname, + pp_value, + pp_sortkey +FROM /*_*/page_props; +DROP TABLE /*_*/page_props; + + +CREATE TABLE /*_*/page_props ( + pp_page INTEGER UNSIGNED NOT NULL, + pp_propname BLOB NOT NULL, + pp_value BLOB NOT NULL, + pp_sortkey DOUBLE PRECISION DEFAULT NULL, + PRIMARY KEY(pp_page, pp_propname) + ); +INSERT INTO /*_*/page_props ( + pp_page, pp_propname, pp_value, pp_sortkey + ) +SELECT + pp_page, + pp_propname, + pp_value, + pp_sortkey +FROM + /*_*/__temp__page_props; +DROP TABLE /*_*/__temp__page_props; + +CREATE UNIQUE INDEX pp_propname_page ON /*_*/page_props (pp_propname, pp_page); + +CREATE UNIQUE INDEX pp_propname_sortkey_page ON /*_*/page_props (pp_propname, pp_sortkey, pp_page); diff --git a/sql/sqlite/patch-page_restrictions-pr_page.sql b/sql/sqlite/patch-page_restrictions-pr_page.sql index e215c1c3b78e..6dcb35c3a001 100644 --- a/sql/sqlite/patch-page_restrictions-pr_page.sql +++ b/sql/sqlite/patch-page_restrictions-pr_page.sql @@ -1,21 +1,44 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-page_restrictions-pr_page.json +-- Source: sql/abstractSchemaChanges/patch-page_restrictions-pr_page.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes -DROP INDEX pr_pagetype; -DROP INDEX pr_typelevel; -DROP INDEX pr_level; -DROP INDEX pr_cascade; CREATE TEMPORARY TABLE /*_*/__temp__page_restrictions AS -SELECT pr_id, pr_page, pr_type, pr_level, pr_cascade, pr_expiry -FROM /*_*/page_restrictions; -DROP TABLE /*_*/page_restrictions; -CREATE TABLE /*_*/page_restrictions ( pr_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, pr_page INTEGER UNSIGNED NOT NULL, pr_type BLOB NOT NULL, pr_level BLOB NOT NULL, pr_cascade SMALLINT NOT NULL, pr_expiry BLOB DEFAULT NULL ); -INSERT INTO /*_*/page_restrictions ( pr_id, pr_page, pr_type, pr_level, pr_cascade, pr_expiry ) -SELECT pr_id, pr_page, pr_type, pr_level, pr_cascade, pr_expiry -FROM /*_*/__temp__page_restrictions; -DROP TABLE /*_*/__temp__page_restrictions; -CREATE UNIQUE INDEX pr_pagetype ON /*_*/page_restrictions (pr_page, pr_type); -CREATE INDEX pr_typelevel ON /*_*/page_restrictions (pr_type, pr_level); -CREATE INDEX pr_level ON /*_*/page_restrictions (pr_level); -CREATE INDEX pr_cascade ON /*_*/page_restrictions (pr_cascade);
\ No newline at end of file +SELECT + pr_id, + pr_page, + pr_type, + pr_level, + pr_cascade, + pr_expiry +FROM /*_*/page_restrictions; +DROP TABLE /*_*/page_restrictions; + + +CREATE TABLE /*_*/page_restrictions ( + pr_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, + pr_page INTEGER UNSIGNED NOT NULL, + pr_type BLOB NOT NULL, pr_level BLOB NOT NULL, + pr_cascade SMALLINT NOT NULL, pr_expiry BLOB DEFAULT NULL + ); +INSERT INTO /*_*/page_restrictions ( + pr_id, pr_page, pr_type, pr_level, + pr_cascade, pr_expiry + ) +SELECT + pr_id, + pr_page, + pr_type, + pr_level, + pr_cascade, + pr_expiry +FROM + /*_*/__temp__page_restrictions; +DROP TABLE /*_*/__temp__page_restrictions; + +CREATE UNIQUE INDEX pr_pagetype ON /*_*/page_restrictions (pr_page, pr_type); + +CREATE INDEX pr_typelevel ON /*_*/page_restrictions (pr_type, pr_level); + +CREATE INDEX pr_level ON /*_*/page_restrictions (pr_level); + +CREATE INDEX pr_cascade ON /*_*/page_restrictions (pr_cascade); diff --git a/sql/sqlite/patch-pagelinks-drop-pl_title.sql b/sql/sqlite/patch-pagelinks-drop-pl_title.sql index 9f2840e8c3ec..45416c3bea9a 100644 --- a/sql/sqlite/patch-pagelinks-drop-pl_title.sql +++ b/sql/sqlite/patch-pagelinks-drop-pl_title.sql @@ -1,5 +1,5 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-pagelinks-drop-pl_title.json +-- Source: sql/abstractSchemaChanges/patch-pagelinks-drop-pl_title.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes CREATE TEMPORARY TABLE /*_*/__temp__pagelinks AS diff --git a/sql/sqlite/patch-pagelinks-target_id.sql b/sql/sqlite/patch-pagelinks-target_id.sql index d8e80ca85913..f2821143dbd6 100644 --- a/sql/sqlite/patch-pagelinks-target_id.sql +++ b/sql/sqlite/patch-pagelinks-target_id.sql @@ -1,17 +1,47 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-pagelinks-target_id.json +-- Source: sql/abstractSchemaChanges/patch-pagelinks-target_id.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes CREATE TEMPORARY TABLE /*_*/__temp__pagelinks AS -SELECT pl_from, pl_namespace, pl_title, pl_from_namespace -FROM /*_*/pagelinks; -DROP TABLE /*_*/pagelinks; -CREATE TABLE /*_*/pagelinks ( pl_from INTEGER UNSIGNED DEFAULT 0 NOT NULL, pl_namespace INTEGER DEFAULT 0 NOT NULL, pl_title BLOB DEFAULT '' NOT NULL, pl_from_namespace INTEGER DEFAULT 0 NOT NULL, pl_target_id BIGINT UNSIGNED DEFAULT NULL, PRIMARY KEY(pl_from, pl_namespace, pl_title) ); -INSERT INTO /*_*/pagelinks ( pl_from, pl_namespace, pl_title, pl_from_namespace ) -SELECT pl_from, pl_namespace, pl_title, pl_from_namespace -FROM /*_*/__temp__pagelinks; -DROP TABLE /*_*/__temp__pagelinks; -CREATE INDEX pl_namespace ON /*_*/pagelinks (pl_namespace, pl_title, pl_from); -CREATE INDEX pl_backlinks_namespace ON /*_*/pagelinks ( pl_from_namespace, pl_namespace, pl_title, pl_from ); -CREATE INDEX pl_target_id ON /*_*/pagelinks (pl_target_id, pl_from); -CREATE INDEX pl_backlinks_namespace_target_id ON /*_*/pagelinks ( pl_from_namespace, pl_target_id, pl_from );
\ No newline at end of file +SELECT + pl_from, + pl_namespace, + pl_title, + pl_from_namespace +FROM /*_*/pagelinks; +DROP TABLE /*_*/pagelinks; + + +CREATE TABLE /*_*/pagelinks ( + pl_from INTEGER UNSIGNED DEFAULT 0 NOT NULL, + pl_namespace INTEGER DEFAULT 0 NOT NULL, + pl_title BLOB DEFAULT '' NOT NULL, + pl_from_namespace INTEGER DEFAULT 0 NOT NULL, + pl_target_id BIGINT UNSIGNED DEFAULT NULL, + PRIMARY KEY(pl_from, pl_namespace, pl_title) + ); +INSERT INTO /*_*/pagelinks ( + pl_from, pl_namespace, pl_title, pl_from_namespace + ) +SELECT + pl_from, + pl_namespace, + pl_title, + pl_from_namespace +FROM + /*_*/__temp__pagelinks; +DROP TABLE /*_*/__temp__pagelinks; + +CREATE INDEX pl_namespace ON /*_*/pagelinks (pl_namespace, pl_title, pl_from); + +CREATE INDEX pl_backlinks_namespace ON /*_*/pagelinks ( + pl_from_namespace, pl_namespace, + pl_title, pl_from + ); + +CREATE INDEX pl_target_id ON /*_*/pagelinks (pl_target_id, pl_from); + +CREATE INDEX pl_backlinks_namespace_target_id ON /*_*/pagelinks ( + pl_from_namespace, pl_target_id, + pl_from + ); diff --git a/sql/sqlite/patch-recentchanges-rc_new_name_timestamp.sql b/sql/sqlite/patch-recentchanges-rc_new_name_timestamp.sql index 3acbb592ad36..b55ca6a99cea 100644 --- a/sql/sqlite/patch-recentchanges-rc_new_name_timestamp.sql +++ b/sql/sqlite/patch-recentchanges-rc_new_name_timestamp.sql @@ -1,31 +1,114 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-recentchanges-rc_new_name_timestamp.json +-- Source: sql/abstractSchemaChanges/patch-recentchanges-rc_new_name_timestamp.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes -DROP INDEX rc_timestamp; -DROP INDEX rc_namespace_title_timestamp; -DROP INDEX rc_cur_id; -DROP INDEX new_name_timestamp; -DROP INDEX rc_ip; -DROP INDEX rc_ns_actor; -DROP INDEX rc_actor; -DROP INDEX rc_name_type_patrolled_timestamp; -DROP INDEX rc_this_oldid; CREATE TEMPORARY TABLE /*_*/__temp__recentchanges AS -SELECT rc_id, rc_timestamp, rc_actor, rc_namespace, rc_title, rc_comment_id, rc_minor, rc_bot, rc_new, rc_cur_id, rc_this_oldid, rc_last_oldid, rc_type, rc_source, rc_patrolled, rc_ip, rc_old_len, rc_new_len, rc_deleted, rc_logid, rc_log_type, rc_log_action, rc_params -FROM /*_*/recentchanges; -DROP TABLE /*_*/recentchanges; -CREATE TABLE /*_*/recentchanges ( rc_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, rc_timestamp BLOB NOT NULL, rc_actor BIGINT UNSIGNED NOT NULL, rc_namespace INTEGER DEFAULT 0 NOT NULL, rc_title BLOB DEFAULT '' NOT NULL, rc_comment_id BIGINT UNSIGNED NOT NULL, rc_minor SMALLINT UNSIGNED DEFAULT 0 NOT NULL, rc_bot SMALLINT UNSIGNED DEFAULT 0 NOT NULL, rc_new SMALLINT UNSIGNED DEFAULT 0 NOT NULL, rc_cur_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, rc_this_oldid INTEGER UNSIGNED DEFAULT 0 NOT NULL, rc_last_oldid INTEGER UNSIGNED DEFAULT 0 NOT NULL, rc_type SMALLINT UNSIGNED DEFAULT 0 NOT NULL, rc_source BLOB DEFAULT '' NOT NULL, rc_patrolled SMALLINT UNSIGNED DEFAULT 0 NOT NULL, rc_ip BLOB DEFAULT '' NOT NULL, rc_old_len INTEGER DEFAULT NULL, rc_new_len INTEGER DEFAULT NULL, rc_deleted SMALLINT UNSIGNED DEFAULT 0 NOT NULL, rc_logid INTEGER UNSIGNED DEFAULT 0 NOT NULL, rc_log_type BLOB DEFAULT NULL, rc_log_action BLOB DEFAULT NULL, rc_params BLOB DEFAULT NULL ); -INSERT INTO /*_*/recentchanges ( rc_id, rc_timestamp, rc_actor, rc_namespace, rc_title, rc_comment_id, rc_minor, rc_bot, rc_new, rc_cur_id, rc_this_oldid, rc_last_oldid, rc_type, rc_source, rc_patrolled, rc_ip, rc_old_len, rc_new_len, rc_deleted, rc_logid, rc_log_type, rc_log_action, rc_params ) -SELECT rc_id, rc_timestamp, rc_actor, rc_namespace, rc_title, rc_comment_id, rc_minor, rc_bot, rc_new, rc_cur_id, rc_this_oldid, rc_last_oldid, rc_type, rc_source, rc_patrolled, rc_ip, rc_old_len, rc_new_len, rc_deleted, rc_logid, rc_log_type, rc_log_action, rc_params -FROM /*_*/__temp__recentchanges; -DROP TABLE /*_*/__temp__recentchanges; -CREATE INDEX rc_timestamp ON /*_*/recentchanges (rc_timestamp); -CREATE INDEX rc_namespace_title_timestamp ON /*_*/recentchanges ( rc_namespace, rc_title, rc_timestamp ); -CREATE INDEX rc_cur_id ON /*_*/recentchanges (rc_cur_id); -CREATE INDEX rc_ip ON /*_*/recentchanges (rc_ip); -CREATE INDEX rc_ns_actor ON /*_*/recentchanges (rc_namespace, rc_actor); -CREATE INDEX rc_actor ON /*_*/recentchanges (rc_actor, rc_timestamp); -CREATE INDEX rc_name_type_patrolled_timestamp ON /*_*/recentchanges ( rc_namespace, rc_type, rc_patrolled, rc_timestamp ); -CREATE INDEX rc_this_oldid ON /*_*/recentchanges (rc_this_oldid); -CREATE INDEX rc_new_name_timestamp ON /*_*/recentchanges ( rc_new, rc_namespace, rc_timestamp );
\ No newline at end of file +SELECT + rc_id, + rc_timestamp, + rc_actor, + rc_namespace, + rc_title, + rc_comment_id, + rc_minor, + rc_bot, + rc_new, + rc_cur_id, + rc_this_oldid, + rc_last_oldid, + rc_type, + rc_source, + rc_patrolled, + rc_ip, + rc_old_len, + rc_new_len, + rc_deleted, + rc_logid, + rc_log_type, + rc_log_action, + rc_params +FROM /*_*/recentchanges; +DROP TABLE /*_*/recentchanges; + + +CREATE TABLE /*_*/recentchanges ( + rc_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, + rc_timestamp BLOB NOT NULL, rc_actor BIGINT UNSIGNED NOT NULL, + rc_namespace INTEGER DEFAULT 0 NOT NULL, + rc_title BLOB DEFAULT '' NOT NULL, rc_comment_id BIGINT UNSIGNED NOT NULL, + rc_minor SMALLINT UNSIGNED DEFAULT 0 NOT NULL, + rc_bot SMALLINT UNSIGNED DEFAULT 0 NOT NULL, + rc_new SMALLINT UNSIGNED DEFAULT 0 NOT NULL, + rc_cur_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, + rc_this_oldid INTEGER UNSIGNED DEFAULT 0 NOT NULL, + rc_last_oldid INTEGER UNSIGNED DEFAULT 0 NOT NULL, + rc_type SMALLINT UNSIGNED DEFAULT 0 NOT NULL, + rc_source BLOB DEFAULT '' NOT NULL, + rc_patrolled SMALLINT UNSIGNED DEFAULT 0 NOT NULL, + rc_ip BLOB DEFAULT '' NOT NULL, rc_old_len INTEGER DEFAULT NULL, + rc_new_len INTEGER DEFAULT NULL, rc_deleted SMALLINT UNSIGNED DEFAULT 0 NOT NULL, + rc_logid INTEGER UNSIGNED DEFAULT 0 NOT NULL, + rc_log_type BLOB DEFAULT NULL, rc_log_action BLOB DEFAULT NULL, + rc_params BLOB DEFAULT NULL + ); +INSERT INTO /*_*/recentchanges ( + rc_id, rc_timestamp, rc_actor, rc_namespace, + rc_title, rc_comment_id, rc_minor, + rc_bot, rc_new, rc_cur_id, rc_this_oldid, + rc_last_oldid, rc_type, rc_source, + rc_patrolled, rc_ip, rc_old_len, + rc_new_len, rc_deleted, rc_logid, + rc_log_type, rc_log_action, rc_params + ) +SELECT + rc_id, + rc_timestamp, + rc_actor, + rc_namespace, + rc_title, + rc_comment_id, + rc_minor, + rc_bot, + rc_new, + rc_cur_id, + rc_this_oldid, + rc_last_oldid, + rc_type, + rc_source, + rc_patrolled, + rc_ip, + rc_old_len, + rc_new_len, + rc_deleted, + rc_logid, + rc_log_type, + rc_log_action, + rc_params +FROM + /*_*/__temp__recentchanges; +DROP TABLE /*_*/__temp__recentchanges; + +CREATE INDEX rc_timestamp ON /*_*/recentchanges (rc_timestamp); + +CREATE INDEX rc_namespace_title_timestamp ON /*_*/recentchanges ( + rc_namespace, rc_title, rc_timestamp + ); + +CREATE INDEX rc_cur_id ON /*_*/recentchanges (rc_cur_id); + +CREATE INDEX rc_ip ON /*_*/recentchanges (rc_ip); + +CREATE INDEX rc_ns_actor ON /*_*/recentchanges (rc_namespace, rc_actor); + +CREATE INDEX rc_actor ON /*_*/recentchanges (rc_actor, rc_timestamp); + +CREATE INDEX rc_name_type_patrolled_timestamp ON /*_*/recentchanges ( + rc_namespace, rc_type, rc_patrolled, + rc_timestamp + ); + +CREATE INDEX rc_this_oldid ON /*_*/recentchanges (rc_this_oldid); + +CREATE INDEX rc_new_name_timestamp ON /*_*/recentchanges ( + rc_new, rc_namespace, rc_timestamp + ); diff --git a/sql/sqlite/patch-revision-cleanup.sql b/sql/sqlite/patch-revision-cleanup.sql index 0b070f11a755..51d69b7197a4 100644 --- a/sql/sqlite/patch-revision-cleanup.sql +++ b/sql/sqlite/patch-revision-cleanup.sql @@ -1,5 +1,5 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-revision-cleanup.json +-- Source: sql/abstractSchemaChanges/patch-revision-cleanup.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes CREATE TEMPORARY TABLE /*_*/__temp__revision AS diff --git a/sql/sqlite/patch-revision-rename-index.sql b/sql/sqlite/patch-revision-rename-index.sql index b21293fd2a43..de9aeec03f85 100644 --- a/sql/sqlite/patch-revision-rename-index.sql +++ b/sql/sqlite/patch-revision-rename-index.sql @@ -1,23 +1,64 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-revision-rename-index.json +-- Source: sql/abstractSchemaChanges/patch-revision-rename-index.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes -DROP INDEX rev_page_id; -DROP INDEX rev_timestamp; -DROP INDEX page_timestamp; -DROP INDEX rev_actor_timestamp; -DROP INDEX rev_page_actor_timestamp; CREATE TEMPORARY TABLE /*_*/__temp__revision AS -SELECT rev_id, rev_page, rev_comment_id, rev_actor, rev_timestamp, rev_minor_edit, rev_deleted, rev_len, rev_parent_id, rev_sha1 -FROM /*_*/revision; -DROP TABLE /*_*/revision; -CREATE TABLE /*_*/revision ( rev_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, rev_page INTEGER UNSIGNED NOT NULL, rev_comment_id BIGINT UNSIGNED DEFAULT 0 NOT NULL, rev_actor BIGINT UNSIGNED DEFAULT 0 NOT NULL, rev_timestamp BLOB DEFAULT '' NOT NULL, rev_minor_edit SMALLINT UNSIGNED DEFAULT 0 NOT NULL, rev_deleted SMALLINT UNSIGNED DEFAULT 0 NOT NULL, rev_len INTEGER UNSIGNED DEFAULT NULL, rev_parent_id INTEGER UNSIGNED DEFAULT NULL, rev_sha1 BLOB DEFAULT '' NOT NULL ); -INSERT INTO /*_*/revision ( rev_id, rev_page, rev_comment_id, rev_actor, rev_timestamp, rev_minor_edit, rev_deleted, rev_len, rev_parent_id, rev_sha1 ) -SELECT rev_id, rev_page, rev_comment_id, rev_actor, rev_timestamp, rev_minor_edit, rev_deleted, rev_len, rev_parent_id, rev_sha1 -FROM /*_*/__temp__revision; -DROP TABLE /*_*/__temp__revision; -CREATE INDEX rev_page_id ON /*_*/revision (rev_page, rev_id); -CREATE INDEX rev_timestamp ON /*_*/revision (rev_timestamp); -CREATE INDEX rev_actor_timestamp ON /*_*/revision (rev_actor, rev_timestamp, rev_id); -CREATE INDEX rev_page_actor_timestamp ON /*_*/revision ( rev_page, rev_actor, rev_timestamp ); -CREATE INDEX rev_page_timestamp ON /*_*/revision (rev_page, rev_timestamp);
\ No newline at end of file +SELECT + rev_id, + rev_page, + rev_comment_id, + rev_actor, + rev_timestamp, + rev_minor_edit, + rev_deleted, + rev_len, + rev_parent_id, + rev_sha1 +FROM /*_*/revision; +DROP TABLE /*_*/revision; + + +CREATE TABLE /*_*/revision ( + rev_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, + rev_page INTEGER UNSIGNED NOT NULL, + rev_comment_id BIGINT UNSIGNED DEFAULT 0 NOT NULL, + rev_actor BIGINT UNSIGNED DEFAULT 0 NOT NULL, + rev_timestamp BLOB DEFAULT '' NOT NULL, + rev_minor_edit SMALLINT UNSIGNED DEFAULT 0 NOT NULL, + rev_deleted SMALLINT UNSIGNED DEFAULT 0 NOT NULL, + rev_len INTEGER UNSIGNED DEFAULT NULL, + rev_parent_id INTEGER UNSIGNED DEFAULT NULL, + rev_sha1 BLOB DEFAULT '' NOT NULL + ); +INSERT INTO /*_*/revision ( + rev_id, rev_page, rev_comment_id, + rev_actor, rev_timestamp, rev_minor_edit, + rev_deleted, rev_len, rev_parent_id, + rev_sha1 + ) +SELECT + rev_id, + rev_page, + rev_comment_id, + rev_actor, + rev_timestamp, + rev_minor_edit, + rev_deleted, + rev_len, + rev_parent_id, + rev_sha1 +FROM + /*_*/__temp__revision; +DROP TABLE /*_*/__temp__revision; + +CREATE INDEX rev_page_id ON /*_*/revision (rev_page, rev_id); + +CREATE INDEX rev_timestamp ON /*_*/revision (rev_timestamp); + +CREATE INDEX rev_actor_timestamp ON /*_*/revision (rev_actor, rev_timestamp, rev_id); + +CREATE INDEX rev_page_actor_timestamp ON /*_*/revision ( + rev_page, rev_actor, rev_timestamp + ); + +CREATE INDEX rev_page_timestamp ON /*_*/revision (rev_page, rev_timestamp); diff --git a/sql/sqlite/patch-site_identifiers-rename-indexes.sql b/sql/sqlite/patch-site_identifiers-rename-indexes.sql index e763a1faba02..914c10527360 100644 --- a/sql/sqlite/patch-site_identifiers-rename-indexes.sql +++ b/sql/sqlite/patch-site_identifiers-rename-indexes.sql @@ -1,17 +1,31 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-site_identifiers-rename-indexes.json +-- Source: sql/abstractSchemaChanges/patch-site_identifiers-rename-indexes.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes -DROP INDEX site_ids_site; -DROP INDEX site_ids_key; CREATE TEMPORARY TABLE /*_*/__temp__site_identifiers AS -SELECT si_type, si_key, si_site -FROM /*_*/site_identifiers; -DROP TABLE /*_*/site_identifiers; -CREATE TABLE /*_*/site_identifiers ( si_type BLOB NOT NULL, si_key BLOB NOT NULL, si_site INTEGER UNSIGNED NOT NULL, PRIMARY KEY(si_type, si_key) ); -INSERT INTO /*_*/site_identifiers (si_type, si_key, si_site) -SELECT si_type, si_key, si_site -FROM /*_*/__temp__site_identifiers; -DROP TABLE /*_*/__temp__site_identifiers; -CREATE INDEX si_site ON /*_*/site_identifiers (si_site); -CREATE INDEX si_key ON /*_*/site_identifiers (si_key);
\ No newline at end of file +SELECT + si_type, + si_key, + si_site +FROM /*_*/site_identifiers; +DROP TABLE /*_*/site_identifiers; + + +CREATE TABLE /*_*/site_identifiers ( + si_type BLOB NOT NULL, + si_key BLOB NOT NULL, + si_site INTEGER UNSIGNED NOT NULL, + PRIMARY KEY(si_type, si_key) + ); +INSERT INTO /*_*/site_identifiers (si_type, si_key, si_site) +SELECT + si_type, + si_key, + si_site +FROM + /*_*/__temp__site_identifiers; +DROP TABLE /*_*/__temp__site_identifiers; + +CREATE INDEX si_site ON /*_*/site_identifiers (si_site); + +CREATE INDEX si_key ON /*_*/site_identifiers (si_key); diff --git a/sql/sqlite/patch-sites-drop_indexes.sql b/sql/sqlite/patch-sites-drop_indexes.sql index 1a92e6eec94f..20a364fe4997 100644 --- a/sql/sqlite/patch-sites-drop_indexes.sql +++ b/sql/sqlite/patch-sites-drop_indexes.sql @@ -1,5 +1,5 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-sites-drop_indexes.json +-- Source: sql/abstractSchemaChanges/patch-sites-drop_indexes.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes CREATE TEMPORARY TABLE /*_*/__temp__sites AS diff --git a/sql/sqlite/patch-sites-rename-indexes.sql b/sql/sqlite/patch-sites-rename-indexes.sql index fdd09f141339..b32ab8f82c20 100644 --- a/sql/sqlite/patch-sites-rename-indexes.sql +++ b/sql/sqlite/patch-sites-rename-indexes.sql @@ -1,29 +1,71 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-sites-rename-indexes.json +-- Source: sql/abstractSchemaChanges/patch-sites-rename-indexes.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes -DROP INDEX sites_global_key; -DROP INDEX sites_type; -DROP INDEX sites_group; -DROP INDEX sites_source; -DROP INDEX sites_language; -DROP INDEX sites_protocol; -DROP INDEX sites_domain; -DROP INDEX sites_forward; CREATE TEMPORARY TABLE /*_*/__temp__sites AS -SELECT site_id, site_global_key, site_type, site_group, site_source, site_language, site_protocol, site_domain, site_data, site_forward, site_config -FROM /*_*/sites; -DROP TABLE /*_*/sites; -CREATE TABLE /*_*/sites ( site_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, site_global_key BLOB NOT NULL, site_type BLOB NOT NULL, site_group BLOB NOT NULL, site_source BLOB NOT NULL, site_language BLOB NOT NULL, site_protocol BLOB NOT NULL, site_domain VARCHAR(255) NOT NULL, site_data BLOB NOT NULL, site_forward SMALLINT NOT NULL, site_config BLOB NOT NULL ); -INSERT INTO /*_*/sites ( site_id, site_global_key, site_type, site_group, site_source, site_language, site_protocol, site_domain, site_data, site_forward, site_config ) -SELECT site_id, site_global_key, site_type, site_group, site_source, site_language, site_protocol, site_domain, site_data, site_forward, site_config -FROM /*_*/__temp__sites; -DROP TABLE /*_*/__temp__sites; -CREATE UNIQUE INDEX site_global_key ON /*_*/sites (site_global_key); -CREATE INDEX site_type ON /*_*/sites (site_type); -CREATE INDEX site_group ON /*_*/sites (site_group); -CREATE INDEX site_source ON /*_*/sites (site_source); -CREATE INDEX site_language ON /*_*/sites (site_language); -CREATE INDEX site_protocol ON /*_*/sites (site_protocol); -CREATE INDEX site_domain ON /*_*/sites (site_domain); -CREATE INDEX site_forward ON /*_*/sites (site_forward);
\ No newline at end of file +SELECT + site_id, + site_global_key, + site_type, + site_group, + site_source, + site_language, + site_protocol, + site_domain, + site_data, + site_forward, + site_config +FROM /*_*/sites; +DROP TABLE /*_*/sites; + + +CREATE TABLE /*_*/sites ( + site_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, + site_global_key BLOB NOT NULL, + site_type BLOB NOT NULL, + site_group BLOB NOT NULL, + site_source BLOB NOT NULL, + site_language BLOB NOT NULL, + site_protocol BLOB NOT NULL, + site_domain VARCHAR(255) NOT NULL, + site_data BLOB NOT NULL, + site_forward SMALLINT NOT NULL, + site_config BLOB NOT NULL + ); +INSERT INTO /*_*/sites ( + site_id, site_global_key, site_type, + site_group, site_source, site_language, + site_protocol, site_domain, site_data, + site_forward, site_config + ) +SELECT + site_id, + site_global_key, + site_type, + site_group, + site_source, + site_language, + site_protocol, + site_domain, + site_data, + site_forward, + site_config +FROM + /*_*/__temp__sites; +DROP TABLE /*_*/__temp__sites; + +CREATE UNIQUE INDEX site_global_key ON /*_*/sites (site_global_key); + +CREATE INDEX site_type ON /*_*/sites (site_type); + +CREATE INDEX site_group ON /*_*/sites (site_group); + +CREATE INDEX site_source ON /*_*/sites (site_source); + +CREATE INDEX site_language ON /*_*/sites (site_language); + +CREATE INDEX site_protocol ON /*_*/sites (site_protocol); + +CREATE INDEX site_domain ON /*_*/sites (site_domain); + +CREATE INDEX site_forward ON /*_*/sites (site_forward); diff --git a/sql/sqlite/patch-templatelinks-drop-tl_title.sql b/sql/sqlite/patch-templatelinks-drop-tl_title.sql index 5bc26ae30893..509dedf09be2 100644 --- a/sql/sqlite/patch-templatelinks-drop-tl_title.sql +++ b/sql/sqlite/patch-templatelinks-drop-tl_title.sql @@ -1,19 +1,36 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-templatelinks-drop-tl_title.json +-- Source: sql/abstractSchemaChanges/patch-templatelinks-drop-tl_title.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes -DROP INDEX tl_namespace; -DROP INDEX tl_backlinks_namespace; -DROP INDEX tl_target_id; -DROP INDEX tl_backlinks_namespace_target_id; CREATE TEMPORARY TABLE /*_*/__temp__templatelinks AS -SELECT tl_from, tl_target_id, tl_from_namespace -FROM /*_*/templatelinks; -DROP TABLE /*_*/templatelinks; -CREATE TABLE /*_*/templatelinks ( tl_from INTEGER UNSIGNED DEFAULT 0 NOT NULL, tl_target_id BIGINT UNSIGNED NOT NULL, tl_from_namespace INTEGER DEFAULT 0 NOT NULL, PRIMARY KEY(tl_from, tl_target_id) ); -INSERT INTO /*_*/templatelinks ( tl_from, tl_target_id, tl_from_namespace ) -SELECT tl_from, tl_target_id, tl_from_namespace -FROM /*_*/__temp__templatelinks; -DROP TABLE /*_*/__temp__templatelinks; -CREATE INDEX tl_target_id ON /*_*/templatelinks (tl_target_id, tl_from); -CREATE INDEX tl_backlinks_namespace_target_id ON /*_*/templatelinks ( tl_from_namespace, tl_target_id, tl_from );
\ No newline at end of file +SELECT + tl_from, + tl_target_id, + tl_from_namespace +FROM /*_*/templatelinks; +DROP TABLE /*_*/templatelinks; + + +CREATE TABLE /*_*/templatelinks ( + tl_from INTEGER UNSIGNED DEFAULT 0 NOT NULL, + tl_target_id BIGINT UNSIGNED NOT NULL, + tl_from_namespace INTEGER DEFAULT 0 NOT NULL, + PRIMARY KEY(tl_from, tl_target_id) + ); +INSERT INTO /*_*/templatelinks ( + tl_from, tl_target_id, tl_from_namespace + ) +SELECT + tl_from, + tl_target_id, + tl_from_namespace +FROM + /*_*/__temp__templatelinks; +DROP TABLE /*_*/__temp__templatelinks; + +CREATE INDEX tl_target_id ON /*_*/templatelinks (tl_target_id, tl_from); + +CREATE INDEX tl_backlinks_namespace_target_id ON /*_*/templatelinks ( + tl_from_namespace, tl_target_id, + tl_from + ); diff --git a/sql/sqlite/patch-templatelinks-target_id.sql b/sql/sqlite/patch-templatelinks-target_id.sql index d9e07830fdaa..ef19727ab70c 100644 --- a/sql/sqlite/patch-templatelinks-target_id.sql +++ b/sql/sqlite/patch-templatelinks-target_id.sql @@ -1,19 +1,47 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-templatelinks-target_id.json +-- Source: sql/abstractSchemaChanges/patch-templatelinks-target_id.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes -DROP INDEX tl_namespace; -DROP INDEX tl_backlinks_namespace; CREATE TEMPORARY TABLE /*_*/__temp__templatelinks AS -SELECT tl_from, tl_namespace, tl_title, tl_from_namespace -FROM /*_*/templatelinks; -DROP TABLE /*_*/templatelinks; -CREATE TABLE /*_*/templatelinks ( tl_from INTEGER UNSIGNED DEFAULT 0 NOT NULL, tl_namespace INTEGER DEFAULT 0 NOT NULL, tl_title BLOB DEFAULT '' NOT NULL, tl_from_namespace INTEGER DEFAULT 0 NOT NULL, tl_target_id BIGINT UNSIGNED DEFAULT NULL, PRIMARY KEY(tl_from, tl_namespace, tl_title) ); -INSERT INTO /*_*/templatelinks ( tl_from, tl_namespace, tl_title, tl_from_namespace ) -SELECT tl_from, tl_namespace, tl_title, tl_from_namespace -FROM /*_*/__temp__templatelinks; -DROP TABLE /*_*/__temp__templatelinks; -CREATE INDEX tl_namespace ON /*_*/templatelinks (tl_namespace, tl_title, tl_from); -CREATE INDEX tl_backlinks_namespace ON /*_*/templatelinks ( tl_from_namespace, tl_namespace, tl_title, tl_from ); -CREATE INDEX tl_target_id ON /*_*/templatelinks (tl_target_id, tl_from); -CREATE INDEX tl_backlinks_namespace_target_id ON /*_*/templatelinks ( tl_from_namespace, tl_target_id, tl_from );
\ No newline at end of file +SELECT + tl_from, + tl_namespace, + tl_title, + tl_from_namespace +FROM /*_*/templatelinks; +DROP TABLE /*_*/templatelinks; + + +CREATE TABLE /*_*/templatelinks ( + tl_from INTEGER UNSIGNED DEFAULT 0 NOT NULL, + tl_namespace INTEGER DEFAULT 0 NOT NULL, + tl_title BLOB DEFAULT '' NOT NULL, + tl_from_namespace INTEGER DEFAULT 0 NOT NULL, + tl_target_id BIGINT UNSIGNED DEFAULT NULL, + PRIMARY KEY(tl_from, tl_namespace, tl_title) + ); +INSERT INTO /*_*/templatelinks ( + tl_from, tl_namespace, tl_title, tl_from_namespace + ) +SELECT + tl_from, + tl_namespace, + tl_title, + tl_from_namespace +FROM + /*_*/__temp__templatelinks; +DROP TABLE /*_*/__temp__templatelinks; + +CREATE INDEX tl_namespace ON /*_*/templatelinks (tl_namespace, tl_title, tl_from); + +CREATE INDEX tl_backlinks_namespace ON /*_*/templatelinks ( + tl_from_namespace, tl_namespace, + tl_title, tl_from + ); + +CREATE INDEX tl_target_id ON /*_*/templatelinks (tl_target_id, tl_from); + +CREATE INDEX tl_backlinks_namespace_target_id ON /*_*/templatelinks ( + tl_from_namespace, tl_target_id, + tl_from + ); diff --git a/sql/sqlite/patch-templatelinks-tl_title-nullable.sql b/sql/sqlite/patch-templatelinks-tl_title-nullable.sql index 0513f9e94637..01149c38a299 100644 --- a/sql/sqlite/patch-templatelinks-tl_title-nullable.sql +++ b/sql/sqlite/patch-templatelinks-tl_title-nullable.sql @@ -1,21 +1,50 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-templatelinks-tl_title-nullable.json +-- Source: sql/abstractSchemaChanges/patch-templatelinks-tl_title-nullable.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes -DROP INDEX tl_namespace; -DROP INDEX tl_backlinks_namespace; -DROP INDEX tl_target_id; -DROP INDEX tl_backlinks_namespace_target_id; CREATE TEMPORARY TABLE /*_*/__temp__templatelinks AS -SELECT tl_from, tl_namespace, tl_title, tl_from_namespace, tl_target_id -FROM /*_*/templatelinks; -DROP TABLE /*_*/templatelinks; -CREATE TABLE /*_*/templatelinks ( tl_from INTEGER UNSIGNED DEFAULT 0 NOT NULL, tl_target_id BIGINT UNSIGNED NOT NULL, tl_namespace INTEGER DEFAULT 0 NOT NULL, tl_title BLOB DEFAULT '' NOT NULL, tl_from_namespace INTEGER DEFAULT 0 NOT NULL, PRIMARY KEY(tl_from, tl_target_id) ); -INSERT INTO /*_*/templatelinks ( tl_from, tl_namespace, tl_title, tl_from_namespace, tl_target_id ) -SELECT tl_from, tl_namespace, tl_title, tl_from_namespace, tl_target_id -FROM /*_*/__temp__templatelinks; -DROP TABLE /*_*/__temp__templatelinks; -CREATE INDEX tl_namespace ON /*_*/templatelinks (tl_namespace, tl_title, tl_from); -CREATE INDEX tl_backlinks_namespace ON /*_*/templatelinks ( tl_from_namespace, tl_namespace, tl_title, tl_from ); -CREATE INDEX tl_target_id ON /*_*/templatelinks (tl_target_id, tl_from); -CREATE INDEX tl_backlinks_namespace_target_id ON /*_*/templatelinks ( tl_from_namespace, tl_target_id, tl_from );
\ No newline at end of file +SELECT + tl_from, + tl_namespace, + tl_title, + tl_from_namespace, + tl_target_id +FROM /*_*/templatelinks; +DROP TABLE /*_*/templatelinks; + + +CREATE TABLE /*_*/templatelinks ( + tl_from INTEGER UNSIGNED DEFAULT 0 NOT NULL, + tl_target_id BIGINT UNSIGNED NOT NULL, + tl_namespace INTEGER DEFAULT 0 NOT NULL, + tl_title BLOB DEFAULT '' NOT NULL, + tl_from_namespace INTEGER DEFAULT 0 NOT NULL, + PRIMARY KEY(tl_from, tl_target_id) + ); +INSERT INTO /*_*/templatelinks ( + tl_from, tl_namespace, tl_title, tl_from_namespace, + tl_target_id + ) +SELECT + tl_from, + tl_namespace, + tl_title, + tl_from_namespace, + tl_target_id +FROM + /*_*/__temp__templatelinks; +DROP TABLE /*_*/__temp__templatelinks; + +CREATE INDEX tl_namespace ON /*_*/templatelinks (tl_namespace, tl_title, tl_from); + +CREATE INDEX tl_backlinks_namespace ON /*_*/templatelinks ( + tl_from_namespace, tl_namespace, + tl_title, tl_from + ); + +CREATE INDEX tl_target_id ON /*_*/templatelinks (tl_target_id, tl_from); + +CREATE INDEX tl_backlinks_namespace_target_id ON /*_*/templatelinks ( + tl_from_namespace, tl_target_id, + tl_from + ); diff --git a/sql/sqlite/patch-uploadstash-us_size_to_bigint.sql b/sql/sqlite/patch-uploadstash-us_size_to_bigint.sql index a760235d8c03..61610e8475c0 100644 --- a/sql/sqlite/patch-uploadstash-us_size_to_bigint.sql +++ b/sql/sqlite/patch-uploadstash-us_size_to_bigint.sql @@ -1,16 +1,81 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: abstractSchemaChanges/patch-uploadstash-us_size_to_bigint.json +-- Source: sql/abstractSchemaChanges/patch-uploadstash-us_size_to_bigint.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes CREATE TEMPORARY TABLE /*_*/__temp__uploadstash AS -SELECT us_id, us_user, us_key, us_orig_path, us_path, us_source_type, us_timestamp, us_status, us_chunk_inx, us_props, us_size, us_sha1, us_mime, us_media_type, us_image_width, us_image_height, us_image_bits -FROM /*_*/uploadstash; -DROP TABLE /*_*/uploadstash; -CREATE TABLE /*_*/uploadstash ( us_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, us_user INTEGER UNSIGNED NOT NULL, us_key VARCHAR(255) NOT NULL, us_orig_path VARCHAR(255) NOT NULL, us_path VARCHAR(255) NOT NULL, us_source_type VARCHAR(50) DEFAULT NULL, us_timestamp BLOB NOT NULL, us_status VARCHAR(50) NOT NULL, us_chunk_inx INTEGER UNSIGNED DEFAULT NULL, us_props BLOB DEFAULT NULL, us_size BIGINT UNSIGNED NOT NULL, us_sha1 VARCHAR(31) NOT NULL, us_mime VARCHAR(255) DEFAULT NULL, us_media_type TEXT DEFAULT NULL, us_image_width INTEGER UNSIGNED DEFAULT NULL, us_image_height INTEGER UNSIGNED DEFAULT NULL, us_image_bits SMALLINT UNSIGNED DEFAULT NULL ); -INSERT INTO /*_*/uploadstash ( us_id, us_user, us_key, us_orig_path, us_path, us_source_type, us_timestamp, us_status, us_chunk_inx, us_props, us_size, us_sha1, us_mime, us_media_type, us_image_width, us_image_height, us_image_bits ) -SELECT us_id, us_user, us_key, us_orig_path, us_path, us_source_type, us_timestamp, us_status, us_chunk_inx, us_props, us_size, us_sha1, us_mime, us_media_type, us_image_width, us_image_height, us_image_bits -FROM /*_*/__temp__uploadstash; -DROP TABLE /*_*/__temp__uploadstash; -CREATE INDEX us_user ON /*_*/uploadstash (us_user); -CREATE UNIQUE INDEX us_key ON /*_*/uploadstash (us_key); -CREATE INDEX us_timestamp ON /*_*/uploadstash (us_timestamp);
\ No newline at end of file +SELECT + us_id, + us_user, + us_key, + us_orig_path, + us_path, + us_source_type, + us_timestamp, + us_status, + us_chunk_inx, + us_props, + us_size, + us_sha1, + us_mime, + us_media_type, + us_image_width, + us_image_height, + us_image_bits +FROM /*_*/uploadstash; +DROP TABLE /*_*/uploadstash; + + +CREATE TABLE /*_*/uploadstash ( + us_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, + us_user INTEGER UNSIGNED NOT NULL, + us_key VARCHAR(255) NOT NULL, + us_orig_path VARCHAR(255) NOT NULL, + us_path VARCHAR(255) NOT NULL, + us_source_type VARCHAR(50) DEFAULT NULL, + us_timestamp BLOB NOT NULL, + us_status VARCHAR(50) NOT NULL, + us_chunk_inx INTEGER UNSIGNED DEFAULT NULL, + us_props BLOB DEFAULT NULL, + us_size BIGINT UNSIGNED NOT NULL, + us_sha1 VARCHAR(31) NOT NULL, + us_mime VARCHAR(255) DEFAULT NULL, + us_media_type TEXT DEFAULT NULL, + us_image_width INTEGER UNSIGNED DEFAULT NULL, + us_image_height INTEGER UNSIGNED DEFAULT NULL, + us_image_bits SMALLINT UNSIGNED DEFAULT NULL + ); +INSERT INTO /*_*/uploadstash ( + us_id, us_user, us_key, us_orig_path, + us_path, us_source_type, us_timestamp, + us_status, us_chunk_inx, us_props, + us_size, us_sha1, us_mime, us_media_type, + us_image_width, us_image_height, + us_image_bits + ) +SELECT + us_id, + us_user, + us_key, + us_orig_path, + us_path, + us_source_type, + us_timestamp, + us_status, + us_chunk_inx, + us_props, + us_size, + us_sha1, + us_mime, + us_media_type, + us_image_width, + us_image_height, + us_image_bits +FROM + /*_*/__temp__uploadstash; +DROP TABLE /*_*/__temp__uploadstash; + +CREATE INDEX us_user ON /*_*/uploadstash (us_user); + +CREATE UNIQUE INDEX us_key ON /*_*/uploadstash (us_key); + +CREATE INDEX us_timestamp ON /*_*/uploadstash (us_timestamp); diff --git a/sql/sqlite/patch-user-user_editcount.sql b/sql/sqlite/patch-user-user_editcount.sql index 3264feb2db9b..fb105df81c48 100644 --- a/sql/sqlite/patch-user-user_editcount.sql +++ b/sql/sqlite/patch-user-user_editcount.sql @@ -1,19 +1,74 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-user-user_editcount.json +-- Source: sql/abstractSchemaChanges/patch-user-user_editcount.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes -DROP INDEX user_name; -DROP INDEX user_email_token; -DROP INDEX user_email; CREATE TEMPORARY TABLE /*_*/__temp__user AS -SELECT user_id, user_name, user_real_name, user_password, user_newpassword, user_newpass_time, user_email, user_touched, user_token, user_email_authenticated, user_email_token, user_email_token_expires, user_registration, user_editcount, user_password_expires -FROM /*_*/user; -DROP TABLE /*_*/user; -CREATE TABLE /*_*/user ( user_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, user_name BLOB DEFAULT '' NOT NULL, user_real_name BLOB DEFAULT '' NOT NULL, user_password BLOB NOT NULL, user_newpassword BLOB NOT NULL, user_newpass_time BLOB DEFAULT NULL, user_email BLOB NOT NULL, user_touched BLOB NOT NULL, user_token BLOB DEFAULT '' NOT NULL, user_email_authenticated BLOB DEFAULT NULL, user_email_token BLOB DEFAULT NULL, user_email_token_expires BLOB DEFAULT NULL, user_registration BLOB DEFAULT NULL, user_editcount INTEGER UNSIGNED DEFAULT NULL, user_password_expires BLOB DEFAULT NULL ); -INSERT INTO /*_*/user ( user_id, user_name, user_real_name, user_password, user_newpassword, user_newpass_time, user_email, user_touched, user_token, user_email_authenticated, user_email_token, user_email_token_expires, user_registration, user_editcount, user_password_expires ) -SELECT user_id, user_name, user_real_name, user_password, user_newpassword, user_newpass_time, user_email, user_touched, user_token, user_email_authenticated, user_email_token, user_email_token_expires, user_registration, user_editcount, user_password_expires -FROM /*_*/__temp__user; -DROP TABLE /*_*/__temp__user; -CREATE UNIQUE INDEX user_name ON /*_*/user (user_name); -CREATE INDEX user_email_token ON /*_*/user (user_email_token); -CREATE INDEX user_email ON /*_*/user (user_email);
\ No newline at end of file +SELECT + user_id, + user_name, + user_real_name, + user_password, + user_newpassword, + user_newpass_time, + user_email, + user_touched, + user_token, + user_email_authenticated, + user_email_token, + user_email_token_expires, + user_registration, + user_editcount, + user_password_expires +FROM /*_*/user; +DROP TABLE /*_*/user; + + +CREATE TABLE /*_*/user ( + user_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, + user_name BLOB DEFAULT '' NOT NULL, + user_real_name BLOB DEFAULT '' NOT NULL, + user_password BLOB NOT NULL, user_newpassword BLOB NOT NULL, + user_newpass_time BLOB DEFAULT NULL, + user_email BLOB NOT NULL, user_touched BLOB NOT NULL, + user_token BLOB DEFAULT '' NOT NULL, + user_email_authenticated BLOB DEFAULT NULL, + user_email_token BLOB DEFAULT NULL, + user_email_token_expires BLOB DEFAULT NULL, + user_registration BLOB DEFAULT NULL, + user_editcount INTEGER UNSIGNED DEFAULT NULL, + user_password_expires BLOB DEFAULT NULL + ); +INSERT INTO /*_*/user ( + user_id, user_name, user_real_name, + user_password, user_newpassword, + user_newpass_time, user_email, user_touched, + user_token, user_email_authenticated, + user_email_token, user_email_token_expires, + user_registration, user_editcount, + user_password_expires + ) +SELECT + user_id, + user_name, + user_real_name, + user_password, + user_newpassword, + user_newpass_time, + user_email, + user_touched, + user_token, + user_email_authenticated, + user_email_token, + user_email_token_expires, + user_registration, + user_editcount, + user_password_expires +FROM + /*_*/__temp__user; +DROP TABLE /*_*/__temp__user; + +CREATE UNIQUE INDEX user_name ON /*_*/user (user_name); + +CREATE INDEX user_email_token ON /*_*/user (user_email_token); + +CREATE INDEX user_email ON /*_*/user (user_email); diff --git a/sql/sqlite/patch-user-user_is_temp.sql b/sql/sqlite/patch-user-user_is_temp.sql index 4831c362d38f..fe3cb3d5415f 100644 --- a/sql/sqlite/patch-user-user_is_temp.sql +++ b/sql/sqlite/patch-user-user_is_temp.sql @@ -1,6 +1,6 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-user-user_is_temp.json +-- Source: sql/abstractSchemaChanges/patch-user-user_is_temp.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes -ALTER TABLE /*_*/user -ADD COLUMN user_is_temp SMALLINT DEFAULT 0 NOT NULL;
\ No newline at end of file +ALTER TABLE /*_*/user + ADD COLUMN user_is_temp SMALLINT DEFAULT 0 NOT NULL; diff --git a/sql/sqlite/patch-user_autocreate_serial-uas_year.sql b/sql/sqlite/patch-user_autocreate_serial-uas_year.sql index 390a7dfd787b..085ee4b72cb2 100644 --- a/sql/sqlite/patch-user_autocreate_serial-uas_year.sql +++ b/sql/sqlite/patch-user_autocreate_serial-uas_year.sql @@ -1,5 +1,5 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-user_autocreate_serial-uas_year.json +-- Source: sql/abstractSchemaChanges/patch-user_autocreate_serial-uas_year.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes CREATE TEMPORARY TABLE /*_*/__temp__user_autocreate_serial AS diff --git a/sql/sqlite/patch-user_properties-rename-index.sql b/sql/sqlite/patch-user_properties-rename-index.sql index 11ff1b737025..00df750580ce 100644 --- a/sql/sqlite/patch-user_properties-rename-index.sql +++ b/sql/sqlite/patch-user_properties-rename-index.sql @@ -1,15 +1,29 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-user_properties-rename-index.json +-- Source: sql/abstractSchemaChanges/patch-user_properties-rename-index.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes -DROP INDEX user_properties_property; CREATE TEMPORARY TABLE /*_*/__temp__user_properties AS -SELECT up_user, up_property, up_value -FROM /*_*/user_properties; -DROP TABLE /*_*/user_properties; -CREATE TABLE /*_*/user_properties ( up_user INTEGER UNSIGNED NOT NULL, up_property BLOB NOT NULL, up_value BLOB DEFAULT NULL, PRIMARY KEY(up_user, up_property) ); -INSERT INTO /*_*/user_properties (up_user, up_property, up_value) -SELECT up_user, up_property, up_value -FROM /*_*/__temp__user_properties; -DROP TABLE /*_*/__temp__user_properties; -CREATE INDEX up_property ON /*_*/user_properties (up_property);
\ No newline at end of file +SELECT + up_user, + up_property, + up_value +FROM /*_*/user_properties; +DROP TABLE /*_*/user_properties; + + +CREATE TABLE /*_*/user_properties ( + up_user INTEGER UNSIGNED NOT NULL, + up_property BLOB NOT NULL, + up_value BLOB DEFAULT NULL, + PRIMARY KEY(up_user, up_property) + ); +INSERT INTO /*_*/user_properties (up_user, up_property, up_value) +SELECT + up_user, + up_property, + up_value +FROM + /*_*/__temp__user_properties; +DROP TABLE /*_*/__temp__user_properties; + +CREATE INDEX up_property ON /*_*/user_properties (up_property); diff --git a/sql/sqlite/patch-user_table-updates.sql b/sql/sqlite/patch-user_table-updates.sql index acaabbb08b74..8ec9ba2b0860 100644 --- a/sql/sqlite/patch-user_table-updates.sql +++ b/sql/sqlite/patch-user_table-updates.sql @@ -1,19 +1,74 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-user_table-updates.json +-- Source: sql/abstractSchemaChanges/patch-user_table-updates.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes -DROP INDEX user_name; -DROP INDEX user_email_token; -DROP INDEX user_email; CREATE TEMPORARY TABLE /*_*/__temp__user AS -SELECT user_id, user_name, user_real_name, user_password, user_newpassword, user_newpass_time, user_email, user_touched, user_token, user_email_authenticated, user_email_token, user_email_token_expires, user_registration, user_editcount, user_password_expires -FROM /*_*/user; -DROP TABLE /*_*/user; -CREATE TABLE /*_*/user ( user_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, user_password BLOB NOT NULL, user_newpassword BLOB NOT NULL, user_newpass_time BLOB DEFAULT NULL, user_email CLOB NOT NULL, user_token BLOB DEFAULT '' NOT NULL, user_email_authenticated BLOB DEFAULT NULL, user_email_token BLOB DEFAULT NULL, user_email_token_expires BLOB DEFAULT NULL, user_registration BLOB DEFAULT NULL, user_editcount INTEGER DEFAULT NULL, user_password_expires BLOB DEFAULT NULL, user_name BLOB DEFAULT '' NOT NULL, user_real_name BLOB DEFAULT '' NOT NULL, user_touched BLOB NOT NULL ); -INSERT INTO /*_*/user ( user_id, user_name, user_real_name, user_password, user_newpassword, user_newpass_time, user_email, user_touched, user_token, user_email_authenticated, user_email_token, user_email_token_expires, user_registration, user_editcount, user_password_expires ) -SELECT user_id, user_name, user_real_name, user_password, user_newpassword, user_newpass_time, user_email, user_touched, user_token, user_email_authenticated, user_email_token, user_email_token_expires, user_registration, user_editcount, user_password_expires -FROM /*_*/__temp__user; -DROP TABLE /*_*/__temp__user; -CREATE UNIQUE INDEX user_name ON /*_*/user (user_name); -CREATE INDEX user_email_token ON /*_*/user (user_email_token); -CREATE INDEX user_email ON /*_*/user (user_email);
\ No newline at end of file +SELECT + user_id, + user_name, + user_real_name, + user_password, + user_newpassword, + user_newpass_time, + user_email, + user_touched, + user_token, + user_email_authenticated, + user_email_token, + user_email_token_expires, + user_registration, + user_editcount, + user_password_expires +FROM /*_*/user; +DROP TABLE /*_*/user; + + +CREATE TABLE /*_*/user ( + user_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, + user_name BLOB DEFAULT '' NOT NULL, + user_real_name BLOB DEFAULT '' NOT NULL, + user_password BLOB NOT NULL, user_newpassword BLOB NOT NULL, + user_newpass_time BLOB DEFAULT NULL, + user_email CLOB NOT NULL, user_touched BLOB NOT NULL, + user_token BLOB DEFAULT '' NOT NULL, + user_email_authenticated BLOB DEFAULT NULL, + user_email_token BLOB DEFAULT NULL, + user_email_token_expires BLOB DEFAULT NULL, + user_registration BLOB DEFAULT NULL, + user_editcount INTEGER DEFAULT NULL, + user_password_expires BLOB DEFAULT NULL + ); +INSERT INTO /*_*/user ( + user_id, user_name, user_real_name, + user_password, user_newpassword, + user_newpass_time, user_email, user_touched, + user_token, user_email_authenticated, + user_email_token, user_email_token_expires, + user_registration, user_editcount, + user_password_expires + ) +SELECT + user_id, + user_name, + user_real_name, + user_password, + user_newpassword, + user_newpass_time, + user_email, + user_touched, + user_token, + user_email_authenticated, + user_email_token, + user_email_token_expires, + user_registration, + user_editcount, + user_password_expires +FROM + /*_*/__temp__user; +DROP TABLE /*_*/__temp__user; + +CREATE UNIQUE INDEX user_name ON /*_*/user (user_name); + +CREATE INDEX user_email_token ON /*_*/user (user_email_token); + +CREATE INDEX user_email ON /*_*/user (user_email); diff --git a/sql/sqlite/patch-watchlist-namespace_title-rename-index.sql b/sql/sqlite/patch-watchlist-namespace_title-rename-index.sql index ad89c87b3ecd..006a6b6c10e7 100644 --- a/sql/sqlite/patch-watchlist-namespace_title-rename-index.sql +++ b/sql/sqlite/patch-watchlist-namespace_title-rename-index.sql @@ -1,19 +1,42 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-watchlist-namespace_title-rename-index.json +-- Source: sql/abstractSchemaChanges/patch-watchlist-namespace_title-rename-index.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes -DROP INDEX wl_user; -DROP INDEX namespace_title; -DROP INDEX wl_user_notificationtimestamp; CREATE TEMPORARY TABLE /*_*/__temp__watchlist AS -SELECT wl_id, wl_user, wl_namespace, wl_title, wl_notificationtimestamp -FROM /*_*/watchlist; -DROP TABLE /*_*/watchlist; -CREATE TABLE /*_*/watchlist ( wl_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, wl_user INTEGER UNSIGNED NOT NULL, wl_namespace INTEGER DEFAULT 0 NOT NULL, wl_title BLOB DEFAULT '' NOT NULL, wl_notificationtimestamp BLOB DEFAULT NULL ); -INSERT INTO /*_*/watchlist ( wl_id, wl_user, wl_namespace, wl_title, wl_notificationtimestamp ) -SELECT wl_id, wl_user, wl_namespace, wl_title, wl_notificationtimestamp -FROM /*_*/__temp__watchlist; -DROP TABLE /*_*/__temp__watchlist; -CREATE UNIQUE INDEX wl_user ON /*_*/watchlist (wl_user, wl_namespace, wl_title); -CREATE INDEX wl_user_notificationtimestamp ON /*_*/watchlist ( wl_user, wl_notificationtimestamp ); -CREATE INDEX wl_namespace_title ON /*_*/watchlist (wl_namespace, wl_title);
\ No newline at end of file +SELECT + wl_id, + wl_user, + wl_namespace, + wl_title, + wl_notificationtimestamp +FROM /*_*/watchlist; +DROP TABLE /*_*/watchlist; + + +CREATE TABLE /*_*/watchlist ( + wl_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, + wl_user INTEGER UNSIGNED NOT NULL, + wl_namespace INTEGER DEFAULT 0 NOT NULL, + wl_title BLOB DEFAULT '' NOT NULL, wl_notificationtimestamp BLOB DEFAULT NULL + ); +INSERT INTO /*_*/watchlist ( + wl_id, wl_user, wl_namespace, wl_title, + wl_notificationtimestamp + ) +SELECT + wl_id, + wl_user, + wl_namespace, + wl_title, + wl_notificationtimestamp +FROM + /*_*/__temp__watchlist; +DROP TABLE /*_*/__temp__watchlist; + +CREATE UNIQUE INDEX wl_user ON /*_*/watchlist (wl_user, wl_namespace, wl_title); + +CREATE INDEX wl_user_notificationtimestamp ON /*_*/watchlist ( + wl_user, wl_notificationtimestamp + ); + +CREATE INDEX wl_namespace_title ON /*_*/watchlist (wl_namespace, wl_title); |