patch-global_block_whitelist-timestamps.json
No OneTemporary
Actions

Size

1 KB

Referenced Files

None

Subscribers

None

patch-global_block_whitelist-timestamps.json
View Options

	{
	"comment": "Use fixed binary for timestamp and use mediawiki timestamp type",
	"before": {
	"name": "global_block_whitelist",
	"columns": [
	{
	"name": "gbw_id",
	"comment": "Key to gb_id in globalblocks database",
	"type": "integer",
	"options": {
	"notnull": true
	}
	},
	{
	"name": "gbw_address",
	"type": "binary",
	"options": {
	"length": 255,
	"notnull": true
	}
	},
	{
	"name": "gbw_by",
	"comment": "Key to user_id",
	"type": "integer",
	"options": {
	"notnull": true
	}
	},
	{
	"name": "gbw_by_text",
	"type": "binary",
	"options": {
	"length": 255,
	"notnull": true
	}
	},
	{
	"name": "gbw_reason",
	"type": "binary",
	"options": {
	"length": 767,
	"notnull": true
	}
	},
	{
	"name": "gbw_expiry",
	"type": "binary",
	"options": {
	"length": 14,
	"notnull": true
	}
	}
	],
	"indexes": [
	{
	"name": "gbw_by",
	"columns": [
	"gbw_by"
	],
	"unique": false
	}
	],
	"pk": [
	"gbw_id"
	]
	},
	"after": {
	"name": "global_block_whitelist",
	"columns": [
	{
	"name": "gbw_id",
	"comment": "Key to gb_id in globalblocks database",
	"type": "integer",
	"options": {
	"notnull": true
	}
	},
	{
	"name": "gbw_address",
	"type": "binary",
	"options": {
	"length": 255,
	"notnull": true
	}
	},
	{
	"name": "gbw_by",
	"comment": "Key to user_id",
	"type": "integer",
	"options": {
	"notnull": true
	}
	},
	{
	"name": "gbw_by_text",
	"type": "binary",
	"options": {
	"length": 255,
	"notnull": true
	}
	},
	{
	"name": "gbw_reason",
	"type": "binary",
	"options": {
	"length": 767,
	"notnull": true
	}
	},
	{
	"name": "gbw_expiry",
	"type": "mwtimestamp",
	"options": {
	"notnull": true,
	"CustomSchemaOptions": {
	"allowInfinite": true
	}
	}
	}
	],
	"indexes": [
	{
	"name": "gbw_by",
	"columns": [
	"gbw_by"
	],
	"unique": false
	}
	],
	"pk": [
	"gbw_id"
	]
	}
	}