diff options
author | jenkins-bot <jenkins-bot@gerrit.wikimedia.org> | 2021-02-18 06:29:51 +0000 |
---|---|---|
committer | Gerrit Code Review <gerrit@wikimedia.org> | 2021-02-18 06:29:51 +0000 |
commit | cf22176fdd7f8ad1004a1f04f7c3ae4bdfe222c4 (patch) | |
tree | 047c8e1c034cb7a1734e853dca6e392a949aae08 | |
parent | be866df979c27ae0c8124269c8913293864f3b0d (diff) | |
parent | e4852caaa39ad7c27e46c4241ba1ec81dcf40785 (diff) | |
download | mediawikicore-cf22176fdd7f8ad1004a1f04f7c3ae4bdfe222c4.tar.gz mediawikicore-cf22176fdd7f8ad1004a1f04f7c3ae4bdfe222c4.zip |
Merge "Drop 1.25 updgrade patch files."
-rw-r--r-- | includes/installer/MysqlUpdater.php | 9 | ||||
-rw-r--r-- | includes/installer/PostgresUpdater.php | 6 | ||||
-rw-r--r-- | includes/installer/SqliteUpdater.php | 6 | ||||
-rw-r--r-- | maintenance/archives/patch-drop-page_counter.sql | 2 | ||||
-rw-r--r-- | maintenance/archives/patch-drop-ss_total_views.sql | 2 | ||||
-rw-r--r-- | maintenance/sqlite/archives/patch-drop-page_counter.sql | 31 | ||||
-rw-r--r-- | maintenance/sqlite/archives/patch-drop-ss_total_views.sql | 21 | ||||
-rw-r--r-- | maintenance/sqlite/archives/patch-editsummary-length.sql | 64 |
8 files changed, 0 insertions, 141 deletions
diff --git a/includes/installer/MysqlUpdater.php b/includes/installer/MysqlUpdater.php index 09171a8dbf46..c58422240880 100644 --- a/includes/installer/MysqlUpdater.php +++ b/includes/installer/MysqlUpdater.php @@ -37,15 +37,6 @@ class MysqlUpdater extends DatabaseUpdater { // 1.2 [ 'doInterwikiUpdate' ], - // 1.25 - // note this patch covers other _comment and _description fields too - [ 'doExtendCommentLengths' ], - - // 1.26 - [ 'dropTable', 'hitcounter' ], - [ 'dropField', 'site_stats', 'ss_total_views', 'patch-drop-ss_total_views.sql' ], - [ 'dropField', 'page', 'page_counter', 'patch-drop-page_counter.sql' ], - // 1.27 [ 'dropTable', 'msg_resource_links' ], [ 'dropTable', 'msg_resource' ], diff --git a/includes/installer/PostgresUpdater.php b/includes/installer/PostgresUpdater.php index 2954f0ab22fe..49e5bcd0df78 100644 --- a/includes/installer/PostgresUpdater.php +++ b/includes/installer/PostgresUpdater.php @@ -75,12 +75,6 @@ class PostgresUpdater extends DatabaseUpdater { [ 'addPgField', 'templatelinks', 'tl_from_namespace', 'INTEGER NOT NULL DEFAULT 0' ], [ 'addPgField', 'imagelinks', 'il_from_namespace', 'INTEGER NOT NULL DEFAULT 0' ], - // 1.25 - [ 'dropTable', 'hitcounter' ], - [ 'dropField', 'site_stats', 'ss_total_views', 'patch-drop-ss_total_views.sql' ], - [ 'dropField', 'page', 'page_counter', 'patch-drop-page_counter.sql' ], - [ 'dropFkey', 'recentchanges', 'rc_cur_id' ], - // **** T272199 MARKER **** // 1.27 diff --git a/includes/installer/SqliteUpdater.php b/includes/installer/SqliteUpdater.php index fb03b6748368..645e9bc94ca8 100644 --- a/includes/installer/SqliteUpdater.php +++ b/includes/installer/SqliteUpdater.php @@ -34,12 +34,6 @@ class SqliteUpdater extends DatabaseUpdater { protected function getCoreUpdateList() { return [ - // 1.25 - [ 'dropTable', 'hitcounter' ], - [ 'dropField', 'site_stats', 'ss_total_views', 'patch-drop-ss_total_views.sql' ], - [ 'dropField', 'page', 'page_counter', 'patch-drop-page_counter.sql' ], - [ 'modifyField', 'filearchive', 'fa_deleted_reason', 'patch-editsummary-length.sql' ], - // 1.27 [ 'dropTable', 'msg_resource_links' ], [ 'dropTable', 'msg_resource' ], diff --git a/maintenance/archives/patch-drop-page_counter.sql b/maintenance/archives/patch-drop-page_counter.sql deleted file mode 100644 index 1d8e701bc74e..000000000000 --- a/maintenance/archives/patch-drop-page_counter.sql +++ /dev/null @@ -1,2 +0,0 @@ --- field is deprecated and no longer updated as of 1.25 -ALTER TABLE /*_*/page DROP COLUMN page_counter; diff --git a/maintenance/archives/patch-drop-ss_total_views.sql b/maintenance/archives/patch-drop-ss_total_views.sql deleted file mode 100644 index 0059193919f0..000000000000 --- a/maintenance/archives/patch-drop-ss_total_views.sql +++ /dev/null @@ -1,2 +0,0 @@ --- field is deprecated and no longer updated as of 1.24 -ALTER TABLE /*_*/site_stats DROP COLUMN ss_total_views;
\ No newline at end of file diff --git a/maintenance/sqlite/archives/patch-drop-page_counter.sql b/maintenance/sqlite/archives/patch-drop-page_counter.sql deleted file mode 100644 index ac8151da132d..000000000000 --- a/maintenance/sqlite/archives/patch-drop-page_counter.sql +++ /dev/null @@ -1,31 +0,0 @@ --- field is deprecated and no longer updated as of 1.25 -CREATE TABLE /*_*/page_tmp ( - page_id int unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT, - page_namespace int NOT NULL, - page_title varchar(255) binary NOT NULL, - page_restrictions tinyblob NOT NULL, - page_is_redirect tinyint unsigned NOT NULL default 0, - page_is_new tinyint unsigned NOT NULL default 0, - page_random real unsigned NOT NULL, - page_touched binary(14) NOT NULL default '', - page_links_updated varbinary(14) NULL default NULL, - page_latest int unsigned NOT NULL, - page_len int unsigned NOT NULL, - page_content_model varbinary(32) DEFAULT NULL, - page_lang varbinary(35) DEFAULT NULL -) /*$wgDBTableOptions*/; - -INSERT INTO /*_*/page_tmp - SELECT page_id, page_namespace, page_title, page_restrictions, 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; - -ALTER TABLE /*_*/page_tmp RENAME TO /*_*/page; - -CREATE UNIQUE INDEX /*i*/name_title ON /*_*/page (page_namespace,page_title); -CREATE INDEX /*i*/page_random ON /*_*/page (page_random); -CREATE INDEX /*i*/page_len ON /*_*/page (page_len); -CREATE INDEX /*i*/page_redirect_namespace_len ON /*_*/page (page_is_redirect, page_namespace, page_len); diff --git a/maintenance/sqlite/archives/patch-drop-ss_total_views.sql b/maintenance/sqlite/archives/patch-drop-ss_total_views.sql deleted file mode 100644 index ad80988dc0dd..000000000000 --- a/maintenance/sqlite/archives/patch-drop-ss_total_views.sql +++ /dev/null @@ -1,21 +0,0 @@ --- field is deprecated and no longer updated as of 1.25 -CREATE TABLE /*_*/site_stats_tmp ( - ss_row_id int unsigned NOT NULL, - ss_total_edits bigint unsigned default 0, - ss_good_articles bigint unsigned default 0, - ss_total_pages bigint default '-1', - ss_users bigint default '-1', - ss_active_users bigint default '-1', - ss_images int default 0 -) /*$wgDBTableOptions*/; - -INSERT INTO /*_*/site_stats_tmp - SELECT ss_row_id, ss_total_edits, ss_good_articles, ss_total_pages, - ss_users, ss_active_users, ss_images - FROM /*_*/site_stats; - -DROP TABLE /*_*/site_stats; - -ALTER TABLE /*_*/site_stats_tmp RENAME TO /*_*/site_stats; - -CREATE UNIQUE INDEX /*i*/ss_row_id ON /*_*/site_stats (ss_row_id); diff --git a/maintenance/sqlite/archives/patch-editsummary-length.sql b/maintenance/sqlite/archives/patch-editsummary-length.sql deleted file mode 100644 index b1ef3b9c8831..000000000000 --- a/maintenance/sqlite/archives/patch-editsummary-length.sql +++ /dev/null @@ -1,64 +0,0 @@ -CREATE TABLE /*_*/filearchive_tmp ( - -- Unique row id - fa_id int NOT NULL PRIMARY KEY AUTO_INCREMENT, - - -- Original base filename; key to image.img_name, page.page_title, etc - fa_name varchar(255) binary NOT NULL default '', - - -- Filename of archived file, if an old revision - fa_archive_name varchar(255) binary default '', - - -- Which storage bin (directory tree or object store) the file data - -- is stored in. Should be 'deleted' for files that have been deleted; - -- any other bin is not yet in use. - fa_storage_group varbinary(16), - - -- SHA-1 of the file contents plus extension, used as a key for storage. - -- eg 8f8a562add37052a1848ff7771a2c515db94baa9.jpg - -- - -- If NULL, the file was missing at deletion time or has been purged - -- from the archival storage. - fa_storage_key varbinary(64) default '', - - -- Deletion information, if this file is deleted. - fa_deleted_user int, - fa_deleted_timestamp binary(14) default '', - fa_deleted_reason varbinary(767) default '', - -- Duped fields from image - fa_size int unsigned default 0, - fa_width int default 0, - fa_height int default 0, - fa_metadata mediumblob, - fa_bits int default 0, - fa_media_type ENUM("UNKNOWN", "BITMAP", "DRAWING", "AUDIO", "VIDEO", "MULTIMEDIA", "OFFICE", "TEXT", "EXECUTABLE", "ARCHIVE") default NULL, - fa_major_mime ENUM("unknown", "application", "audio", "image", "text", "video", "message", "model", "multipart", "chemical") default "unknown", - fa_minor_mime varbinary(100) default "unknown", - fa_description varbinary(767), - fa_user int unsigned default 0, - fa_user_text varchar(255) binary, - fa_timestamp binary(14) default '', - - -- Visibility of deleted revisions, bitfield - fa_deleted tinyint unsigned NOT NULL default 0, - - -- sha1 hash of file content - fa_sha1 varbinary(32) NOT NULL default '' -) /*$wgDBTableOptions*/; - - -INSERT INTO /*_*/filearchive_tmp - SELECT fa_id, fa_name, fa_archive_name, fa_storage_group, fa_storage_key, fa_deleted_user, fa_deleted_timestamp, - fa_deleted_reason, fa_size, fa_width, fa_height, fa_metadata, fa_bits, fa_media_type, fa_major_mime, - fa_minor_mime, fa_description, fa_user, fa_user_text, fa_timestamp, fa_deleted, fa_sha1 - FROM /*_*/filearchive; - -DROP TABLE /*_*/filearchive; - -ALTER TABLE /*_*/filearchive_tmp RENAME TO /*_*/filearchive; - - -CREATE INDEX /*i*/fa_name ON /*_*/filearchive (fa_name, fa_timestamp); -CREATE INDEX /*i*/fa_storage_group ON /*_*/filearchive (fa_storage_group, fa_storage_key); -CREATE INDEX /*i*/fa_deleted_timestamp ON /*_*/filearchive (fa_deleted_timestamp); -CREATE INDEX /*i*/fa_user_timestamp ON /*_*/filearchive (fa_user_text,fa_timestamp); -CREATE INDEX /*i*/fa_sha1 ON /*_*/filearchive (fa_sha1(10)); |