Page MenuHomeWickedGov Phorge

patch-add-af_actor.json
No OneTemporary

Size
4 KB
Referenced Files
None
Subscribers
None

patch-add-af_actor.json

{
"comment": "Add af_actor field to abuse_filter",
"before": {
"name": "abuse_filter",
"columns": [
{
"name": "af_id",
"type": "bigint",
"options": {
"notnull": true,
"autoincrement": true,
"unsigned": true
}
},
{
"name": "af_pattern",
"type": "blob",
"options": {
"notnull": true,
"length": 65530
}
},
{
"name": "af_user",
"type": "bigint",
"options": {
"notnull": true,
"unsigned": true
}
},
{
"name": "af_user_text",
"type": "binary",
"options": {
"notnull": true,
"length": 255
}
},
{
"name": "af_timestamp",
"type": "mwtimestamp",
"options": {
"notnull": true
}
},
{
"name": "af_enabled",
"type": "mwtinyint",
"options": {
"notnull": true,
"length": 1,
"default": 1
}
},
{
"name": "af_comments",
"type": "blob",
"options": {
"notnull": false,
"length": 65530
}
},
{
"name": "af_public_comments",
"type": "blob",
"options": {
"notnull": false,
"length": 255
}
},
{
"name": "af_hidden",
"type": "mwtinyint",
"options": {
"notnull": true,
"length": 1,
"default": 0
}
},
{
"name": "af_hit_count",
"type": "bigint",
"options": {
"notnull": true,
"default": 0
}
},
{
"name": "af_throttled",
"type": "mwtinyint",
"options": {
"notnull": true,
"length": 1,
"default": 0
}
},
{
"name": "af_deleted",
"type": "mwtinyint",
"options": {
"notnull": true,
"length": 1,
"default": 0
}
},
{
"name": "af_actions",
"type": "string",
"options": {
"notnull": true,
"length": 255,
"default": ""
}
},
{
"name": "af_global",
"type": "mwtinyint",
"options": {
"notnull": true,
"length": 1,
"default": 0
}
},
{
"name": "af_group",
"type": "binary",
"options": {
"notnull": true,
"length": 64,
"default": "default"
}
}
],
"indexes": [
{
"name": "af_user",
"columns": [
"af_user"
],
"unique": false
},
{
"name": "af_group_enabled",
"columns": [
"af_group",
"af_enabled",
"af_id"
],
"unique": false
}
],
"pk": [
"af_id"
]
},
"after": {
"name": "abuse_filter",
"columns": [
{
"name": "af_id",
"type": "bigint",
"options": {
"notnull": true,
"autoincrement": true,
"unsigned": true
}
},
{
"name": "af_pattern",
"type": "blob",
"options": {
"notnull": true,
"length": 65530
}
},
{
"name": "af_user",
"type": "bigint",
"options": {
"notnull": true,
"unsigned": true,
"default": 0
}
},
{
"name": "af_user_text",
"type": "binary",
"options": {
"notnull": true,
"length": 255,
"default": ""
}
},
{
"name": "af_actor",
"type": "bigint",
"options": {
"notnull": true,
"unsigned": true,
"default": 0
}
},
{
"name": "af_timestamp",
"type": "mwtimestamp",
"options": {
"notnull": true
}
},
{
"name": "af_enabled",
"type": "mwtinyint",
"options": {
"notnull": true,
"length": 1,
"default": 1
}
},
{
"name": "af_comments",
"type": "blob",
"options": {
"notnull": false,
"length": 65530
}
},
{
"name": "af_public_comments",
"type": "blob",
"options": {
"notnull": false,
"length": 255
}
},
{
"name": "af_hidden",
"type": "mwtinyint",
"options": {
"notnull": true,
"length": 1,
"default": 0
}
},
{
"name": "af_hit_count",
"type": "bigint",
"options": {
"notnull": true,
"default": 0
}
},
{
"name": "af_throttled",
"type": "mwtinyint",
"options": {
"notnull": true,
"length": 1,
"default": 0
}
},
{
"name": "af_deleted",
"type": "mwtinyint",
"options": {
"notnull": true,
"length": 1,
"default": 0
}
},
{
"name": "af_actions",
"type": "string",
"options": {
"notnull": true,
"length": 255,
"default": ""
}
},
{
"name": "af_global",
"type": "mwtinyint",
"options": {
"notnull": true,
"length": 1,
"default": 0
}
},
{
"name": "af_group",
"type": "binary",
"options": {
"notnull": true,
"length": 64,
"default": "default"
}
}
],
"indexes": [
{
"name": "af_user",
"columns": [
"af_user"
],
"unique": false
},
{
"name": "af_actor",
"columns": [
"af_actor"
],
"unique": false
},
{
"name": "af_group_enabled",
"columns": [
"af_group",
"af_enabled",
"af_id"
],
"unique": false
}
],
"pk": [
"af_id"
]
}
}

File Metadata

Mime Type
application/json
Expires
Aug 18 2026, 09:36 (6 w, 3 d ago)
Storage Engine
local-disk
Storage Format
Raw Data
Storage Handle
25/96/78d492fff856b014a7d80a463f92
Default Alt Text
patch-add-af_actor.json (4 KB)

Event Timeline