Page MenuHomeWickedGov Phorge
Files F1427510

patch-templatelinks-drop-tl_title.json
No OneTemporary
Actions

Size
2 KB
Referenced Files
None
Subscribers
None

patch-templatelinks-drop-tl_title.json
View Options

{
"comment": "Drop tl_title column (and more) on templatelinks (T299417)",
"before": {
"name": "templatelinks",
"comment": "Track template inclusions. The target page may or may not exist, and due to renames and deletions may refer to different page records as time goes by.",
"columns": [
{
"name": "tl_from",
"comment": "Key to the page_id of the page containing the link.",
"type": "integer",
"options": {
"notnull": true,
"unsigned": true,
"default": 0
}
},
{
"name": "tl_from_namespace",
"type": "integer",
"comment": "Namespace for this page",
"options": {
"notnull": true,
"default": 0
}
},
{
"name": "tl_namespace",
"type": "integer",
"options": {
"default": 0
}
},
{
"name": "tl_title",
"type": "binary",
"options": {
"length": 255,
"default": ""
}
},
{
"name": "tl_target_id",
"type": "bigint",
"comment": "Foreign key to linktarget.lt_id",
"options": {
"notnull": true,
"unsigned": true
}
}
],
"indexes": [
{
"name": "tl_namespace",
"columns": [
"tl_namespace",
"tl_title",
"tl_from"
],
"comment": "Reverse index, for Special:Whatlinkshere",
"unique": false
},
{
"name": "tl_backlinks_namespace",
"columns": [
"tl_from_namespace",
"tl_namespace",
"tl_title",
"tl_from"
],
"comment": "Index for Special:Whatlinkshere with namespace filter",
"unique": false
},
{
"name": "tl_target_id",
"columns": [
"tl_target_id",
"tl_from"
],
"comment": "Reverse index, for Special:Whatlinkshere",
"unique": false
},
{
"name": "tl_backlinks_namespace_target_id",
"columns": [
"tl_from_namespace",
"tl_target_id",
"tl_from"
],
"comment": "Index for Special:Whatlinkshere with namespace filter",
"unique": false
}
],
"pk": [
"tl_from",
"tl_target_id"
]
},
"after": {
"name": "templatelinks",
"comment": "Track template inclusions. The target page may or may not exist, and due to renames and deletions may refer to different page records as time goes by.",
"columns": [
{
"name": "tl_from",
"comment": "Key to the page_id of the page containing the link.",
"type": "integer",
"options": {
"notnull": true,
"unsigned": true,
"default": 0
}
},
{
"name": "tl_from_namespace",
"type": "integer",
"comment": "Namespace for this page",
"options": {
"notnull": true,
"default": 0
}
},
{
"name": "tl_target_id",
"type": "bigint",
"comment": "Foreign key to linktarget.lt_id",
"options": {
"notnull": true,
"unsigned": true
}
}
],
"indexes": [
{
"name": "tl_target_id",
"columns": [
"tl_target_id",
"tl_from"
],
"comment": "Reverse index, for Special:Whatlinkshere",
"unique": false
},
{
"name": "tl_backlinks_namespace_target_id",
"columns": [
"tl_from_namespace",
"tl_target_id",
"tl_from"
],
"comment": "Index for Special:Whatlinkshere with namespace filter",
"unique": false
}
],
"pk": [
"tl_from",
"tl_target_id"
]
}
}

File Metadata

Mime Type
application/json
Expires
Sat, May 16, 14:42 (1 d, 18 m)
Storage Engine
local-disk
Storage Format
Raw Data
Storage Handle
1d/d0/d80647ede1483d58dbf7d2585f25
Default Alt Text
patch-templatelinks-drop-tl_title.json (2 KB)

Event Timeline