diff options
| author | Amir Sarabadani <ladsgroup@gmail.com> | 2022-09-26 18:34:31 +0200 |
|---|---|---|
| committer | Amir Sarabadani <ladsgroup@gmail.com> | 2022-09-26 18:34:31 +0200 |
| commit | 4bde06772273ae6091290d178ea669b822f137aa (patch) | |
| tree | 9bca94d9daa4ee3da2240d1f258245a0ad00eb0f /maintenance/postgres | |
| parent | b8e4073804f8b1aff5ac15d42073ac503f1b2e42 (diff) | |
| download | mediawikicore-4bde06772273ae6091290d178ea669b822f137aa.tar.gz mediawikicore-4bde06772273ae6091290d178ea669b822f137aa.zip | |
Drop 1.32 and 1.33 db updates
Per official policy, updates from versions older than two TLS releases
are not supported.
Finding the implicit marker is a bit tricky. The user might try to
upgrade from a really old version that doesn't have tag_summary table
and mistakenly think it's new and allow upgrade. So turning the check
logic into a boolean AND where it must be new enough to have
change_tag_def table AND new enough not to have tag_summary table.
Change-Id: I5ff9630a6539a587a47930847e108ac53757106f
Diffstat (limited to 'maintenance/postgres')
4 files changed, 0 insertions, 51 deletions
diff --git a/maintenance/postgres/archives/patch-change_tag-change_tag_rc_tag_id.sql b/maintenance/postgres/archives/patch-change_tag-change_tag_rc_tag_id.sql deleted file mode 100644 index 930aebe862cf..000000000000 --- a/maintenance/postgres/archives/patch-change_tag-change_tag_rc_tag_id.sql +++ /dev/null @@ -1,16 +0,0 @@ --- T193874: Add new indexes to change_tag table using ct_tag_id instead of ct_tag - -CREATE UNIQUE INDEX /*i*/change_tag_rc_tag_id ON /*_*/change_tag (ct_rc_id,ct_tag_id); -CREATE UNIQUE INDEX /*i*/change_tag_log_tag_id ON /*_*/change_tag (ct_log_id,ct_tag_id); -CREATE UNIQUE INDEX /*i*/change_tag_rev_tag_id ON /*_*/change_tag (ct_rev_id,ct_tag_id); - -CREATE INDEX /*i*/change_tag_rc_tag_nonuniq ON /*_*/change_tag (ct_rc_id,ct_tag); -CREATE INDEX /*i*/change_tag_log_tag_nonuniq ON /*_*/change_tag (ct_log_id,ct_tag); -CREATE INDEX /*i*/change_tag_rev_tag_nonuniq ON /*_*/change_tag (ct_rev_id,ct_tag); - -DROP INDEX /*i*/change_tag_rc_tag; -DROP INDEX /*i*/change_tag_log_tag; -DROP INDEX /*i*/change_tag_rev_tag; - -ALTER TABLE /*_*/change_tag - ALTER COLUMN ct_tag SET DEFAULT ''; diff --git a/maintenance/postgres/archives/patch-change_tag_def.sql b/maintenance/postgres/archives/patch-change_tag_def.sql deleted file mode 100644 index c16597d643ce..000000000000 --- a/maintenance/postgres/archives/patch-change_tag_def.sql +++ /dev/null @@ -1,14 +0,0 @@ --- Table defining tag names for IDs. Also stores hit counts to avoid expensive queries on change_tag - -CREATE SEQUENCE change_tag_def_ctd_id_seq; -CREATE TABLE change_tag_def ( - ctd_id int NOT NULL PRIMARY KEY DEFAULT nextval('change_tag_def_ctd_id_seq'), - ctd_name TEXT NOT NULL, - ctd_user_defined SMALLINT NOT NULL DEFAULT 0, - ctd_count INTEGER NOT NULL DEFAULT 0 -); -ALTER SEQUENCE change_tag_def_ctd_id_seq OWNED BY change_tag_def.ctd_id; - -CREATE UNIQUE INDEX ctd_name ON change_tag_def (ctd_name); -CREATE INDEX ctd_count ON change_tag_def (ctd_count); -CREATE INDEX ctd_user_defined ON change_tag_def (ctd_user_defined);
\ No newline at end of file diff --git a/maintenance/postgres/archives/patch-drop-ct_tag.sql b/maintenance/postgres/archives/patch-drop-ct_tag.sql deleted file mode 100644 index fc4d7ff51db7..000000000000 --- a/maintenance/postgres/archives/patch-drop-ct_tag.sql +++ /dev/null @@ -1,10 +0,0 @@ --- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-drop-ct_tag.json --- Do not modify this file directly. --- See https://www.mediawiki.org/wiki/Manual:Schema_changes -DROP INDEX change_tag_rc_tag_nonuniq; -DROP INDEX change_tag_log_tag_nonuniq; -DROP INDEX change_tag_rev_tag_nonuniq; -DROP INDEX change_tag_tag_id; -ALTER TABLE /*_*/change_tag -DROP ct_tag;
\ No newline at end of file diff --git a/maintenance/postgres/archives/patch-ipblocks_restrictions-table.sql b/maintenance/postgres/archives/patch-ipblocks_restrictions-table.sql deleted file mode 100644 index f3317cdf5909..000000000000 --- a/maintenance/postgres/archives/patch-ipblocks_restrictions-table.sql +++ /dev/null @@ -1,11 +0,0 @@ --- For partial block restrictions -- - -CREATE TABLE ipblocks_restrictions ( - ir_ipb_id INTEGER NOT NULL REFERENCES ipblocks(ipb_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED, - ir_type SMALLINT NOT NULL, - ir_value INTEGER NOT NULL, - PRIMARY KEY (ir_ipb_id, ir_type, ir_value) -); - --- Index to query restrictions by the page or namespace. -CREATE INDEX /*i*/ir_type_value ON /*_*/ipblocks_restrictions (ir_type, ir_value); |