Page MenuHomeWickedGov Phorge

patch-add-afl_ip_hex.json
No OneTemporary

Size
5 KB
Referenced Files
None
Subscribers
None

patch-add-afl_ip_hex.json

{
"before": {
"name": "abuse_filter_log",
"columns": [
{
"name": "afl_id",
"type": "bigint",
"options": {
"notnull": true,
"autoincrement": true,
"unsigned": true
}
},
{
"name": "afl_global",
"type": "mwtinyint",
"options": {
"notnull": true,
"length": 1
}
},
{
"name": "afl_filter_id",
"type": "bigint",
"options": {
"notnull": true,
"unsigned": true
}
},
{
"name": "afl_user",
"type": "bigint",
"options": {
"notnull": true,
"unsigned": true
}
},
{
"name": "afl_user_text",
"type": "binary",
"options": {
"notnull": true,
"length": 255
}
},
{
"name": "afl_ip",
"type": "string",
"options": {
"notnull": true,
"length": 255
}
},
{
"name": "afl_action",
"type": "binary",
"options": {
"notnull": true,
"length": 255
}
},
{
"name": "afl_actions",
"type": "binary",
"options": {
"notnull": true,
"length": 255
}
},
{
"name": "afl_var_dump",
"type": "blob",
"options": {
"notnull": true,
"length": 65530
}
},
{
"name": "afl_timestamp",
"type": "mwtimestamp",
"options": {
"notnull": true
}
},
{
"name": "afl_namespace",
"type": "integer",
"options": {
"notnull": true
}
},
{
"name": "afl_title",
"type": "binary",
"options": {
"notnull": true,
"length": 255
}
},
{
"name": "afl_wiki",
"type": "binary",
"options": {
"notnull": false,
"length": 64
}
},
{
"name": "afl_deleted",
"type": "mwtinyint",
"options": {
"notnull": true,
"length": 1,
"default": 0
}
},
{
"name": "afl_rev_id",
"type": "integer",
"options": {
"notnull": false,
"unsigned": true
}
}
],
"indexes": [
{
"name": "afl_filter_timestamp_full",
"columns": [
"afl_global",
"afl_filter_id",
"afl_timestamp"
],
"unique": false
},
{
"name": "afl_user_timestamp",
"columns": [
"afl_user",
"afl_user_text",
"afl_timestamp"
],
"unique": false
},
{
"name": "afl_timestamp",
"columns": [
"afl_timestamp"
],
"unique": false
},
{
"name": "afl_page_timestamp",
"columns": [
"afl_namespace",
"afl_title",
"afl_timestamp"
],
"unique": false
},
{
"name": "afl_ip_timestamp",
"columns": [
"afl_ip",
"afl_timestamp"
],
"unique": false
},
{
"name": "afl_rev_id",
"columns": [
"afl_rev_id"
],
"unique": false
},
{
"name": "afl_wiki_timestamp",
"columns": [
"afl_wiki",
"afl_timestamp"
],
"unique": false
},
{
"name": "afl_var_dump_timestamp",
"columns": [
"afl_var_dump",
"afl_timestamp"
],
"unique": false,
"options": {
"lengths": [
4,
null
]
}
}
],
"pk": [
"afl_id"
]
},
"after": {
"name": "abuse_filter_log",
"columns": [
{
"name": "afl_id",
"type": "bigint",
"options": {
"notnull": true,
"autoincrement": true,
"unsigned": true
}
},
{
"name": "afl_global",
"type": "mwtinyint",
"options": {
"notnull": true,
"length": 1
}
},
{
"name": "afl_filter_id",
"type": "bigint",
"options": {
"notnull": true,
"unsigned": true
}
},
{
"name": "afl_user",
"type": "bigint",
"options": {
"notnull": true,
"unsigned": true
}
},
{
"name": "afl_user_text",
"type": "binary",
"options": {
"notnull": true,
"length": 255
}
},
{
"name": "afl_ip",
"type": "string",
"options": {
"notnull": true,
"length": 255
}
},
{
"name": "afl_ip_hex",
"comment": "IP address used by the user when triggering the filter as hexadecimal",
"type": "string",
"options": {
"notnull": true,
"length": 255,
"default": ""
}
},
{
"name": "afl_action",
"type": "binary",
"options": {
"notnull": true,
"length": 255
}
},
{
"name": "afl_actions",
"type": "binary",
"options": {
"notnull": true,
"length": 255
}
},
{
"name": "afl_var_dump",
"type": "blob",
"options": {
"notnull": true,
"length": 65530
}
},
{
"name": "afl_timestamp",
"type": "mwtimestamp",
"options": {
"notnull": true
}
},
{
"name": "afl_namespace",
"type": "integer",
"options": {
"notnull": true
}
},
{
"name": "afl_title",
"type": "binary",
"options": {
"notnull": true,
"length": 255
}
},
{
"name": "afl_wiki",
"type": "binary",
"options": {
"notnull": false,
"length": 64
}
},
{
"name": "afl_deleted",
"type": "mwtinyint",
"options": {
"notnull": true,
"length": 1,
"default": 0
}
},
{
"name": "afl_rev_id",
"type": "integer",
"options": {
"notnull": false,
"unsigned": true
}
}
],
"indexes": [
{
"name": "afl_filter_timestamp_full",
"columns": [
"afl_global",
"afl_filter_id",
"afl_timestamp"
],
"unique": false
},
{
"name": "afl_user_timestamp",
"columns": [
"afl_user",
"afl_user_text",
"afl_timestamp"
],
"unique": false
},
{
"name": "afl_timestamp",
"columns": [
"afl_timestamp"
],
"unique": false
},
{
"name": "afl_page_timestamp",
"columns": [
"afl_namespace",
"afl_title",
"afl_timestamp"
],
"unique": false
},
{
"name": "afl_ip_timestamp",
"columns": [
"afl_ip",
"afl_timestamp"
],
"unique": false
},
{
"name": "afl_ip_hex_timestamp",
"columns": [
"afl_ip_hex",
"afl_timestamp"
],
"unique": false
},
{
"name": "afl_rev_id",
"columns": [
"afl_rev_id"
],
"unique": false
},
{
"name": "afl_wiki_timestamp",
"columns": [
"afl_wiki",
"afl_timestamp"
],
"unique": false
},
{
"name": "afl_var_dump_timestamp",
"columns": [
"afl_var_dump",
"afl_timestamp"
],
"unique": false,
"options": {
"lengths": [
4,
null
]
}
}
],
"pk": [
"afl_id"
]
}
}

File Metadata

Mime Type
application/json
Expires
Oct 2 2026, 17:42 (6 w, 4 d ago)
Storage Engine
local-disk
Storage Format
Raw Data
Storage Handle
d2/5e/23d307acee4bab781152df435ab9
Default Alt Text
patch-add-afl_ip_hex.json (5 KB)

Event Timeline