Page MenuHomeWickedGov Phorge
Files F1429052

patch-page_restrictions-pr_page.json
No OneTemporary
Actions

Size
3 KB
Referenced Files
None
Subscribers
None

patch-page_restrictions-pr_page.json
View Options

{
"comment": "Set unsigned true for pr_page in page_restrictions table",
"before": {
"name": "page_restrictions",
"comment": "Used for storing page restrictions (i.e. protection levels)",
"columns": [
{
"name": "pr_id",
"comment": "Field for an ID for this restrictions row (sort-key for Special:ProtectedPages)",
"type": "integer",
"options": {
"unsigned": true,
"notnull": true,
"autoincrement": true
}
},
{
"name": "pr_page",
"comment": "Page to apply restrictions to (Foreign Key to page).",
"type": "integer",
"options": {
"notnull": true
}
},
{
"name": "pr_type",
"comment": "The protection type (edit, move, etc)",
"type": "binary",
"options": {
"length": 60,
"notnull": true
}
},
{
"name": "pr_level",
"comment": "The protection level (Sysop, autoconfirmed, etc)",
"type": "binary",
"options": {
"length": 60,
"notnull": true
}
},
{
"name": "pr_cascade",
"type": "mwtinyint",
"options": {
"notnull": true
}
},
{
"name": "pr_expiry",
"comment": "Field for time-limited protection.",
"type": "mwtimestamp",
"options": {
"notnull": false,
"CustomSchemaOptions": {
"allowInfinite": true
}
}
}
],
"indexes": [
{
"name": "pr_pagetype",
"columns": [
"pr_page",
"pr_type"
],
"unique": true
},
{
"name": "pr_typelevel",
"columns": [
"pr_type",
"pr_level"
],
"unique": false
},
{
"name": "pr_level",
"columns": [
"pr_level"
],
"unique": false
},
{
"name": "pr_cascade",
"columns": [
"pr_cascade"
],
"unique": false
}
],
"pk": [
"pr_id"
]
},
"after": {
"name": "page_restrictions",
"comment": "Used for storing page restrictions (i.e. protection levels)",
"columns": [
{
"name": "pr_id",
"comment": "Field for an ID for this restrictions row (sort-key for Special:ProtectedPages)",
"type": "integer",
"options": {
"unsigned": true,
"notnull": true,
"autoincrement": true
}
},
{
"name": "pr_page",
"comment": "Page to apply restrictions to (Foreign Key to page).",
"type": "integer",
"options": {
"notnull": true,
"unsigned": true
}
},
{
"name": "pr_type",
"comment": "The protection type (edit, move, etc)",
"type": "binary",
"options": {
"length": 60,
"notnull": true
}
},
{
"name": "pr_level",
"comment": "The protection level (Sysop, autoconfirmed, etc)",
"type": "binary",
"options": {
"length": 60,
"notnull": true
}
},
{
"name": "pr_cascade",
"type": "mwtinyint",
"options": {
"notnull": true
}
},
{
"name": "pr_expiry",
"comment": "Field for time-limited protection.",
"type": "mwtimestamp",
"options": {
"notnull": false,
"CustomSchemaOptions": {
"allowInfinite": true
}
}
}
],
"indexes": [
{
"name": "pr_pagetype",
"columns": [
"pr_page",
"pr_type"
],
"unique": true
},
{
"name": "pr_typelevel",
"columns": [
"pr_type",
"pr_level"
],
"unique": false
},
{
"name": "pr_level",
"columns": [
"pr_level"
],
"unique": false
},
{
"name": "pr_cascade",
"columns": [
"pr_cascade"
],
"unique": false
}
],
"pk": [
"pr_id"
]
}
}

File Metadata

Mime Type
application/json
Expires
Sat, May 16, 16:59 (10 h, 48 m)
Storage Engine
local-disk
Storage Format
Raw Data
Storage Handle
00/b9/c64cf1e373b0b5b132fb4772db3a
Default Alt Text
patch-page_restrictions-pr_page.json (3 KB)

Event Timeline