Page MenuHomeWickedGov Phorge
Files F4049328

patch-global_block_whitelist-modify-gbw_id-unsigned.json
No OneTemporary
Actions

Size
2 KB
Referenced Files
None
Subscribers
None

patch-global_block_whitelist-modify-gbw_id-unsigned.json
View Options

{
"comment": "Make gbw_id unsigned so that it matches the maximum limit of gb_id in the globalblocks table.",
"before": {
"name": "global_block_whitelist",
"comment": "A table which is on each local wiki, which when a row exists indicates that the associated global block is disabled on that local wiki.",
"columns": [
{
"name": "gbw_id",
"comment": "Key to gb_id in globalblocks database",
"type": "integer",
"options": {
"notnull": true
}
},
{
"name": "gbw_by",
"comment": "Key to user_id of the user who disabled the block locally.",
"type": "integer",
"options": {
"notnull": true
}
},
{
"name": "gbw_by_text",
"comment": "The username of the user who disabled the block locally.",
"type": "binary",
"options": {
"length": 255,
"notnull": true
}
},
{
"name": "gbw_reason",
"comment": "The reason given for disabling the global block locally.",
"type": "binary",
"options": {
"length": 767,
"notnull": true
}
},
{
"name": "gbw_expiry",
"comment": "The expiry timestamp for the global block. Blocks can have an infinite expiry.",
"type": "mwtimestamp",
"options": {
"notnull": true,
"PlatformOptions": {
"allowInfinite": true
}
}
}
],
"indexes": [
{
"name": "gbw_by",
"comment": "Used to find all global blocks disabled by a given user, to allow user merging.",
"columns": [
"gbw_by"
],
"unique": false
}
],
"pk": [
"gbw_id"
]
},
"after": {
"name": "global_block_whitelist",
"comment": "A table which is on each local wiki, which when a row exists indicates that the associated global block is disabled on that local wiki.",
"columns": [
{
"name": "gbw_id",
"comment": "Key to gb_id in globalblocks database",
"type": "integer",
"options": {
"notnull": true,
"unsigned": true
}
},
{
"name": "gbw_by",
"comment": "Key to user_id of the user who disabled the block locally.",
"type": "integer",
"options": {
"notnull": true
}
},
{
"name": "gbw_by_text",
"comment": "The username of the user who disabled the block locally.",
"type": "binary",
"options": {
"length": 255,
"notnull": true
}
},
{
"name": "gbw_reason",
"comment": "The reason given for disabling the global block locally.",
"type": "binary",
"options": {
"length": 767,
"notnull": true
}
},
{
"name": "gbw_expiry",
"comment": "The expiry timestamp for the global block. Blocks can have an infinite expiry.",
"type": "mwtimestamp",
"options": {
"notnull": true,
"PlatformOptions": {
"allowInfinite": true
}
}
}
],
"indexes": [
{
"name": "gbw_by",
"comment": "Used to find all global blocks disabled by a given user, to allow user merging.",
"columns": [
"gbw_by"
],
"unique": false
}
],
"pk": [
"gbw_id"
]
}
}

File Metadata

Mime Type
application/json
Expires
Aug 15 2026, 15:26 (12 w, 3 d ago)
Storage Engine
local-disk
Storage Format
Raw Data
Storage Handle
23/05/9963917fb749b0c66e2af20bda45
Default Alt Text
patch-global_block_whitelist-modify-gbw_id-unsigned.json (2 KB)

Event Timeline