wikimedia/mediawiki-core

{
    "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" ]
    }
}