aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorjenkins-bot <jenkins-bot@gerrit.wikimedia.org>2021-02-18 06:29:51 +0000
committerGerrit Code Review <gerrit@wikimedia.org>2021-02-18 06:29:51 +0000
commitcf22176fdd7f8ad1004a1f04f7c3ae4bdfe222c4 (patch)
tree047c8e1c034cb7a1734e853dca6e392a949aae08
parentbe866df979c27ae0c8124269c8913293864f3b0d (diff)
parente4852caaa39ad7c27e46c4241ba1ec81dcf40785 (diff)
downloadmediawikicore-cf22176fdd7f8ad1004a1f04f7c3ae4bdfe222c4.tar.gz
mediawikicore-cf22176fdd7f8ad1004a1f04f7c3ae4bdfe222c4.zip
Merge "Drop 1.25 updgrade patch files."
-rw-r--r--includes/installer/MysqlUpdater.php9
-rw-r--r--includes/installer/PostgresUpdater.php6
-rw-r--r--includes/installer/SqliteUpdater.php6
-rw-r--r--maintenance/archives/patch-drop-page_counter.sql2
-rw-r--r--maintenance/archives/patch-drop-ss_total_views.sql2
-rw-r--r--maintenance/sqlite/archives/patch-drop-page_counter.sql31
-rw-r--r--maintenance/sqlite/archives/patch-drop-ss_total_views.sql21
-rw-r--r--maintenance/sqlite/archives/patch-editsummary-length.sql64
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));