Page MenuHomeWickedGov Phorge

patch-pagelinks-target_id.json
No OneTemporary

Size
3 KB
Referenced Files
None
Subscribers
None

patch-pagelinks-target_id.json

{
"comment": "Add tl_target_id on pagelinks (T299947)",
"before": {
"name": "pagelinks",
"comment": "Track page-to-page hyperlinks within the wiki. 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": "pl_from",
"comment": "Key to the page_id of the page containing the link.",
"type": "integer",
"options": {
"notnull": true,
"unsigned": true,
"default": 0
}
},
{
"name": "pl_namespace",
"type": "integer",
"options": {
"notnull": true,
"default": 0
}
},
{
"name": "pl_title",
"type": "binary",
"options": {
"notnull": true,
"length": 255,
"default": ""
}
},
{
"name": "pl_from_namespace",
"type": "integer",
"comment": "Namespace for pl_from page",
"options": {
"notnull": true,
"default": 0
}
}
],
"indexes": [
{
"name": "pl_namespace",
"columns": [
"pl_namespace",
"pl_title",
"pl_from"
],
"comment": "Reverse index, for Special:Whatlinkshere",
"unique": false
},
{
"name": "pl_backlinks_namespace",
"columns": [
"pl_from_namespace",
"pl_namespace",
"pl_title",
"pl_from"
],
"comment": "Index for Special:Whatlinkshere with namespace filter",
"unique": false
}
],
"pk": [
"pl_from",
"pl_namespace",
"pl_title"
]
},
"after": {
"name": "pagelinks",
"comment": "Track page-to-page hyperlinks within the wiki. 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": "pl_from",
"comment": "Key to the page_id of the page containing the link.",
"type": "integer",
"options": {
"notnull": true,
"unsigned": true,
"default": 0
}
},
{
"name": "pl_namespace",
"type": "integer",
"options": {
"notnull": true,
"default": 0
}
},
{
"name": "pl_title",
"type": "binary",
"options": {
"notnull": true,
"length": 255,
"default": ""
}
},
{
"name": "pl_from_namespace",
"type": "integer",
"comment": "Namespace for pl_from page",
"options": {
"notnull": true,
"default": 0
}
},
{
"name": "pl_target_id",
"type": "bigint",
"comment": "Foreign key to linktarget.lt_id",
"options": {
"notnull": false,
"unsigned": true
}
}
],
"indexes": [
{
"name": "pl_namespace",
"columns": [
"pl_namespace",
"pl_title",
"pl_from"
],
"comment": "Reverse index, for Special:Whatlinkshere",
"unique": false
},
{
"name": "pl_backlinks_namespace",
"columns": [
"pl_from_namespace",
"pl_namespace",
"pl_title",
"pl_from"
],
"comment": "Index for Special:Whatlinkshere with namespace filter",
"unique": false
},
{
"name": "pl_target_id",
"columns": [
"pl_target_id",
"pl_from"
],
"comment": "Reverse index, for Special:Whatlinkshere",
"unique": false
},
{
"name": "pl_backlinks_namespace_target_id",
"columns": [
"pl_from_namespace",
"pl_target_id",
"pl_from"
],
"comment": "Index for Special:Whatlinkshere with namespace filter",
"unique": false
}
],
"pk": [
"pl_from",
"pl_namespace",
"pl_title"
]
}
}

File Metadata

Mime Type
application/json
Expires
Sat, Nov 21, 15:37 (4 h, 27 m)
Storage Engine
local-disk
Storage Format
Raw Data
Storage Handle
bf/11/efcf26cfbc5fd798990b43406a63
Default Alt Text
patch-pagelinks-target_id.json (3 KB)

Event Timeline