aboutsummaryrefslogtreecommitdiffstats
path: root/sql
diff options
context:
space:
mode:
authorDaimona Eaytoy <daimona.wiki@gmail.com>2024-12-13 00:02:40 +0100
committerDaimona Eaytoy <daimona.wiki@gmail.com>2024-12-13 14:59:44 +0000
commit263b069c7f2bb6f9bc866a06ef083224733bbe5e (patch)
tree3147b43e2ce63627487c6ad76a5ba61d18abffc0 /sql
parent09cdb3b66869998615a742caabe3a9cc32d8e991 (diff)
downloadmediawikicore-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.json124
-rw-r--r--sql/abstractSchemaChanges/patch-extend-iwlinks-iwl_prefix.json81
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" ]
- }
-}