diff options
author | Daimona Eaytoy <daimona.wiki@gmail.com> | 2024-12-13 00:02:40 +0100 |
---|---|---|
committer | Daimona Eaytoy <daimona.wiki@gmail.com> | 2024-12-13 14:59:44 +0000 |
commit | 263b069c7f2bb6f9bc866a06ef083224733bbe5e (patch) | |
tree | 3147b43e2ce63627487c6ad76a5ba61d18abffc0 /sql | |
parent | 09cdb3b66869998615a742caabe3a9cc32d8e991 (diff) | |
download | mediawikicore-263b069c7f2bb6f9bc866a06ef083224733bbe5e.tar.gz mediawikicore-263b069c7f2bb6f9bc866a06ef083224733bbe5e.zip |
Drop orphaned JSON schema change files
The SQL files and wiring for patch-drop-ct_tag.json have been dropped in
I5ff9630a6539a5.
The SQL file and wiring for patch-extend-iwlinks-iwl_prefix.json have
been dropped in I8fb08e226c1a3.
Bug: T381981
Change-Id: I998264c4b14b8b6f0a18c84e165af048cfa2dfe0
Diffstat (limited to 'sql')
-rw-r--r-- | sql/abstractSchemaChanges/patch-drop-ct_tag.json | 124 | ||||
-rw-r--r-- | sql/abstractSchemaChanges/patch-extend-iwlinks-iwl_prefix.json | 81 |
2 files changed, 0 insertions, 205 deletions
diff --git a/sql/abstractSchemaChanges/patch-drop-ct_tag.json b/sql/abstractSchemaChanges/patch-drop-ct_tag.json deleted file mode 100644 index 08c102f041e0..000000000000 --- a/sql/abstractSchemaChanges/patch-drop-ct_tag.json +++ /dev/null @@ -1,124 +0,0 @@ -{ - "comment": "Drop change_tag.ct_tag field (T185355)", - "before": { - "name": "change_tag", - "comment": "A table to track tags for revisions, logs and recent changes", - "columns": [ - { - "name": "ct_id", - "type": "integer", - "options": { "unsigned": true, "notnull": true, "autoincrement": true } - }, - { - "name": "ct_rc_id", - "comment": "RCID for the change", - "type": "integer", - "options": { "unsigned": true, "notnull": false, "default": null } - }, - { - "name": "ct_log_id", - "comment": "LOGID for the change", - "type": "integer", - "options": { "unsigned": true, "notnull": false, "default": null } - }, - { - "name": "ct_rev_id", - "comment": "REVID for the change", - "type": "integer", - "options": { "unsigned": true, "notnull": false, "default": null } - }, - { - "name": "ct_tag", - "comment": "Tag applied, this will go away and be replaced with ct_tag_id", - "type": "string", - "options": { "length": 255, "notnull": true, "default": "" } - }, - { - "name": "ct_params", - "comment": "Parameters for the tag; used by some extensions", - "type": "blob", - "options": { "length": 65530, "notnull": false, "default": null } - }, - { - "name": "ct_tag_id", - "comment": "Foreign key to change_tag_def row", - "type": "integer", - "options": { "unsigned": false, "notnull": true } - } - ], - "indexes": [ - { "name": "change_tag_rc_tag_id", "columns": [ "ct_rc_id", "ct_tag_id" ], "unique": true }, - { "name": "change_tag_log_tag_id", "columns": [ "ct_log_id", "ct_tag_id" ], "unique": true }, - { "name": "change_tag_rev_tag_id", "columns": [ "ct_rev_id", "ct_tag_id" ], "unique": true }, - { "name": "change_tag_rc_tag_nonuniq", "columns": [ "ct_rc_id", "ct_tag" ], "unique": true }, - { "name": "change_tag_log_tag_nonuniq", "columns": [ "ct_log_id", "ct_tag" ], "unique": true }, - { "name": "change_tag_rev_tag_nonuniq", "columns": [ "ct_rev_id", "ct_tag" ], "unique": true }, - { - "name": "change_tag_tag_id", - "comment": "Covering index, so we can pull all the info only out of the index.", - "columns": [ "ct_tag", "ct_rc_id", "ct_rev_id", "ct_log_id" ], - "unique": false - }, - { - "name": "change_tag_tag_id_id", - "comment": "Covering index, so we can pull all the info only out of the index.", - "columns": [ "ct_tag_id", "ct_rc_id", "ct_rev_id", "ct_log_id" ], - "unique": false - } - ], - "pk": [ "ct_id" ] - }, - "after": { - "name": "change_tag", - "comment": "A table to track tags for revisions, logs and recent changes", - "columns": [ - { - "name": "ct_id", - "type": "integer", - "options": { "unsigned": true, "notnull": true, "autoincrement": true } - }, - { - "name": "ct_rc_id", - "comment": "RCID for the change", - "type": "integer", - "options": { "unsigned": true, "notnull": false, "default": null } - }, - { - "name": "ct_log_id", - "comment": "LOGID for the change", - "type": "integer", - "options": { "unsigned": true, "notnull": false, "default": null } - }, - { - "name": "ct_rev_id", - "comment": "REVID for the change", - "type": "integer", - "options": { "unsigned": true, "notnull": false, "default": null } - }, - { - "name": "ct_params", - "comment": "Parameters for the tag; used by some extensions", - "type": "blob", - "options": { "length": 65530, "notnull": false, "default": null } - }, - { - "name": "ct_tag_id", - "comment": "Foreign key to change_tag_def row", - "type": "integer", - "options": { "unsigned": true, "notnull": true } - } - ], - "indexes": [ - { "name": "change_tag_rc_tag_id", "columns": [ "ct_rc_id", "ct_tag_id" ], "unique": true }, - { "name": "change_tag_log_tag_id", "columns": [ "ct_log_id", "ct_tag_id" ], "unique": true }, - { "name": "change_tag_rev_tag_id", "columns": [ "ct_rev_id", "ct_tag_id" ], "unique": true }, - { - "name": "change_tag_tag_id_id", - "comment": "Covering index, so we can pull all the info only out of the index.", - "columns": [ "ct_tag_id", "ct_rc_id", "ct_rev_id", "ct_log_id" ], - "unique": false - } - ], - "pk": [ "ct_id" ] - } -} diff --git a/sql/abstractSchemaChanges/patch-extend-iwlinks-iwl_prefix.json b/sql/abstractSchemaChanges/patch-extend-iwlinks-iwl_prefix.json deleted file mode 100644 index 96c08bbc1b29..000000000000 --- a/sql/abstractSchemaChanges/patch-extend-iwlinks-iwl_prefix.json +++ /dev/null @@ -1,81 +0,0 @@ -{ - "comment": "T275242 - increase size of iwl_prefix from VARBINARY(20) to VARBINARY(32)", - "before": { - "name": "iwlinks", - "comment": "Track inline interwiki links", - "columns": [ - { - "name": "iwl_from", - "comment": "page_id of the referring page", - "type": "integer", - "options": { "notnull": true, "unsigned": true, "default": 0 } - }, - { - "name": "iwl_prefix", - "type": "binary", - "comment": "Interwiki prefix code of the target", - "options": { "notnull": true, "length": 20, "default": "" } - }, - { - "name": "iwl_title", - "type": "binary", - "comment": "Title of the target, including namespace", - "options": { "notnull": true, "length": 255, "default": "" } - } - ], - "indexes": [ - { - "name": "iwl_prefix_title_from", - "columns": [ "iwl_prefix", "iwl_title", "iwl_from" ], - "comment": "Index for ApiQueryIWBacklinks", - "unique": false - }, - { - "name": "iwl_prefix_from_title", - "columns": [ "iwl_prefix", "iwl_from", "iwl_title" ], - "comment": "Index for ApiQueryIWLinks", - "unique": false - } - ], - "pk": [ "iwl_from", "iwl_prefix", "iwl_title" ] - }, - "after": { - "name": "iwlinks", - "comment": "Track inline interwiki links", - "columns": [ - { - "name": "iwl_from", - "comment": "page_id of the referring page", - "type": "integer", - "options": { "notnull": true, "unsigned": true, "default": 0 } - }, - { - "name": "iwl_prefix", - "type": "binary", - "comment": "Interwiki prefix code of the target", - "options": { "notnull": true, "length": 32, "default": "" } - }, - { - "name": "iwl_title", - "type": "binary", - "comment": "Title of the target, including namespace", - "options": { "notnull": true, "length": 255, "default": "" } - } - ], - "indexes": [ - { - "name": "iwl_prefix_title_from", - "columns": [ "iwl_prefix", "iwl_title", "iwl_from" ], - "comment": "Index for ApiQueryIWBacklinks", - "unique": false - }, - { - "name": "iwl_prefix_from_title", - "columns": [ "iwl_prefix", "iwl_from", "iwl_title" ], - "comment": "Index for ApiQueryIWLinks", - "unique": false - } - ], - "pk": [ "iwl_from", "iwl_prefix", "iwl_title" ] - } -} |