aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorAmmarpad <ammarpad@yahoo.com>2021-02-17 17:55:12 +0100
committerAmmarpad <ammarpad@yahoo.com>2021-02-17 18:09:08 +0100
commite4852caaa39ad7c27e46c4241ba1ec81dcf40785 (patch)
treea4ba805d4d442115edb2c9c3595d81948bfce8a4
parent3448f20ab931de998dca93ec325b8c9a8a13461a (diff)
downloadmediawikicore-e4852caaa39ad7c27e46c4241ba1ec81dcf40785.tar.gz
mediawikicore-e4852caaa39ad7c27e46c4241ba1ec81dcf40785.zip
Drop 1.25 updgrade patch files.
5 files for MySql/Sqlite/Postgres. MysqlUpdater.php seems to have incorrect comment for 1.26 release The hitcounter table was dropped in 1.25 (I0e5006a), so all the files dropped here are part of schema change for 1.25. Bug: T272199 Change-Id: I6a509a54d31f68e423b3d76d26259b1f88aa22bd
-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 79986c6f0b7d..1fc75f812e83 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));