Page MenuHomeWickedGov Phorge
Files F2754033

patch-cu_private_event-modify-cupe_actor-nullable.json
No OneTemporary
Actions

Size
6 KB
Referenced Files
None
Subscribers
None

patch-cu_private_event-modify-cupe_actor-nullable.json
View Options

{
"before": {
"name": "cu_private_event",
"comment": "Table for events that are not logged in the logging table, and thus do not have a log ID (such as logins).",
"columns": [
{
"name": "cupe_id",
"comment": "Primary key",
"type": "bigint",
"options": {
"autoincrement": true,
"notnull": true,
"unsigned": true
}
},
{
"name": "cupe_namespace",
"comment": "Key to the namespace of the page affected",
"type": "integer",
"options": {
"notnull": true,
"default": 0
}
},
{
"name": "cupe_title",
"type": "binary",
"options": {
"notnull": true,
"length": 255,
"default": ""
}
},
{
"name": "cupe_actor",
"type": "bigint",
"options": {
"notnull": true,
"unsigned": true,
"default": 0
}
},
{
"name": "cupe_log_type",
"comment": "Very similar to logging table's log_type.",
"type": "binary",
"options": {
"notnull": true,
"default": "",
"length": 32
}
},
{
"name": "cupe_log_action",
"comment": "Very similar to logging table's log_action.",
"type": "binary",
"options": {
"notnull": true,
"default": "",
"length": 32
}
},
{
"name": "cupe_params",
"comment": "Very similar to logging table's log_params. LF separated list (old system) or serialized PHP array (new system).",
"type": "blob",
"options": {
"notnull": true,
"length": 65530
}
},
{
"name": "cupe_comment_id",
"comment": "Very similar to logging table's log_comment_id. References a comment ID in the comment table.",
"type": "bigint",
"options": {
"notnull": true,
"unsigned": true,
"default": 0
}
},
{
"name": "cupe_page",
"comment": "Key to page_id.",
"type": "integer",
"options": {
"notnull": true,
"unsigned": true,
"default": 0
}
},
{
"name": "cupe_timestamp",
"comment": "Event timestamp",
"type": "mwtimestamp",
"options": {
"notnull": true
}
},
{
"name": "cupe_ip",
"comment": "IP address, visible",
"type": "string",
"options": {
"notnull": false,
"length": 255,
"default": ""
}
},
{
"name": "cupe_ip_hex",
"comment": "IP address as hexadecimal",
"type": "string",
"options": {
"notnull": false,
"length": 255
}
},
{
"name": "cupe_xff",
"comment": "XFF header, visible, all data",
"type": "binary",
"options": {
"notnull": false,
"length": 255,
"default": ""
}
},
{
"name": "cupe_xff_hex",
"comment": "XFF header, last IP, as hexadecimal",
"type": "string",
"options": {
"notnull": false,
"length": 255
}
},
{
"name": "cupe_agent",
"comment": "User agent",
"type": "binary",
"options": {
"notnull": false,
"length": 255
}
},
{
"name": "cupe_private",
"comment": "Private Data",
"type": "blob",
"options": {
"notnull": false,
"length": 16777215
}
}
],
"indexes": [
{
"name": "cupe_ip_hex_time",
"columns": [
"cupe_ip_hex",
"cupe_timestamp"
],
"unique": false
},
{
"name": "cupe_xff_hex_time",
"columns": [
"cupe_xff_hex",
"cupe_timestamp"
],
"unique": false
},
{
"name": "cupe_timestamp",
"columns": [
"cupe_timestamp"
],
"unique": false
},
{
"name": "cupe_actor_ip_time",
"columns": [
"cupe_actor",
"cupe_ip",
"cupe_timestamp"
],
"unique": false
}
],
"pk": [
"cupe_id"
]
},
"after": {
"name": "cu_private_event",
"comment": "Table for events that are not logged in the logging table, and thus do not have a log ID (such as logins).",
"columns": [
{
"name": "cupe_id",
"comment": "Primary key",
"type": "bigint",
"options": {
"autoincrement": true,
"notnull": true,
"unsigned": true
}
},
{
"name": "cupe_namespace",
"comment": "Key to the namespace of the page affected",
"type": "integer",
"options": {
"notnull": true,
"default": 0
}
},
{
"name": "cupe_title",
"type": "binary",
"options": {
"notnull": true,
"length": 255,
"default": ""
}
},
{
"name": "cupe_actor",
"type": "bigint",
"options": {
"notnull": false,
"unsigned": true,
"default": 0
}
},
{
"name": "cupe_log_type",
"comment": "Very similar to logging table's log_type.",
"type": "binary",
"options": {
"notnull": true,
"default": "",
"length": 32
}
},
{
"name": "cupe_log_action",
"comment": "Very similar to logging table's log_action.",
"type": "binary",
"options": {
"notnull": true,
"default": "",
"length": 32
}
},
{
"name": "cupe_params",
"comment": "Very similar to logging table's log_params. LF separated list (old system) or serialized PHP array (new system).",
"type": "blob",
"options": {
"notnull": true,
"length": 65530
}
},
{
"name": "cupe_comment_id",
"comment": "Very similar to logging table's log_comment_id. References a comment ID in the comment table.",
"type": "bigint",
"options": {
"notnull": true,
"unsigned": true,
"default": 0
}
},
{
"name": "cupe_page",
"comment": "Key to page_id.",
"type": "integer",
"options": {
"notnull": true,
"unsigned": true,
"default": 0
}
},
{
"name": "cupe_timestamp",
"comment": "Event timestamp",
"type": "mwtimestamp",
"options": {
"notnull": true
}
},
{
"name": "cupe_ip",
"comment": "IP address, visible",
"type": "string",
"options": {
"notnull": false,
"length": 255,
"default": ""
}
},
{
"name": "cupe_ip_hex",
"comment": "IP address as hexadecimal",
"type": "string",
"options": {
"notnull": false,
"length": 255
}
},
{
"name": "cupe_xff",
"comment": "XFF header, visible, all data",
"type": "binary",
"options": {
"notnull": false,
"length": 255,
"default": ""
}
},
{
"name": "cupe_xff_hex",
"comment": "XFF header, last IP, as hexadecimal",
"type": "string",
"options": {
"notnull": false,
"length": 255
}
},
{
"name": "cupe_agent",
"comment": "User agent",
"type": "binary",
"options": {
"notnull": false,
"length": 255
}
},
{
"name": "cupe_private",
"comment": "Private Data",
"type": "blob",
"options": {
"notnull": false,
"length": 16777215
}
}
],
"indexes": [
{
"name": "cupe_ip_hex_time",
"columns": [
"cupe_ip_hex",
"cupe_timestamp"
],
"unique": false
},
{
"name": "cupe_xff_hex_time",
"columns": [
"cupe_xff_hex",
"cupe_timestamp"
],
"unique": false
},
{
"name": "cupe_timestamp",
"columns": [
"cupe_timestamp"
],
"unique": false
},
{
"name": "cupe_actor_ip_time",
"columns": [
"cupe_actor",
"cupe_ip",
"cupe_timestamp"
],
"unique": false
}
],
"pk": [
"cupe_id"
]
}
}

File Metadata

Mime Type
application/json
Expires
Fri, Jul 3, 22:03 (2 h, 19 m)
Storage Engine
local-disk
Storage Format
Raw Data
Storage Handle
79/ee/24700b703021625dff368ef800e2
Default Alt Text
patch-cu_private_event-modify-cupe_actor-nullable.json (6 KB)

Event Timeline