patch-ipblocks_restrictions-ir_value.json
No OneTemporary
Actions

Size

1 KB

Referenced Files

None

Subscribers

None

patch-ipblocks_restrictions-ir_value.json
View Options

	{
	"comment": "Set unsigned true for ir_value in ipblocks_restrictions table",
	"before": {
	"name": "ipblocks_restrictions",
	"comment": "Partial Block Restrictions",
	"columns": [
	{
	"name": "ir_ipb_id",
	"comment": "The ipb_id from ipblocks",
	"type": "integer",
	"options": {
	"notnull": true
	}
	},
	{
	"name": "ir_type",
	"comment": "The restriction type id.",
	"type": "mwtinyint",
	"options": {
	"notnull": true,
	"length": 4
	}
	},
	{
	"name": "ir_value",
	"comment": "The restriction id that corresponds to the type. Typically a Page ID or a Namespace ID.",
	"type": "integer",
	"options": {
	"notnull": true
	}
	}
	],
	"indexes": [
	{
	"name": "ir_type_value",
	"comment": "Index to query restrictions by the page or namespace.",
	"columns": [
	"ir_type",
	"ir_value"
	],
	"unique": false
	}
	],
	"pk": [
	"ir_ipb_id",
	"ir_type",
	"ir_value"
	]
	},
	"after": {
	"name": "ipblocks_restrictions",
	"comment": "Partial Block Restrictions",
	"columns": [
	{
	"name": "ir_ipb_id",
	"comment": "The ipb_id from ipblocks",
	"type": "integer",
	"options": {
	"notnull": true
	}
	},
	{
	"name": "ir_type",
	"comment": "The restriction type id.",
	"type": "mwtinyint",
	"options": {
	"notnull": true,
	"length": 4
	}
	},
	{
	"name": "ir_value",
	"comment": "The restriction id that corresponds to the type. Typically a Page ID or a Namespace ID.",
	"type": "integer",
	"options": {
	"notnull": true,
	"unsigned": true
	}
	}
	],
	"indexes": [
	{
	"name": "ir_type_value",
	"comment": "Index to query restrictions by the page or namespace.",
	"columns": [
	"ir_type",
	"ir_value"
	],
	"unique": false
	}
	],
	"pk": [
	"ir_ipb_id",
	"ir_type",
	"ir_value"
	]
	}
	}