Page MenuHomeWickedGov Phorge
Files F4211981

patch-change_tag-ct_rc_id.json
No OneTemporary
Actions

Size
3 KB
Referenced Files
None
Subscribers
None

patch-change_tag-ct_rc_id.json
View Options

{
"before": {
"name": "change_tag",
"comment": "A table to track tags for revisions, logs and recent changes",
"columns": [
{
"name": "ct_id",
"type": "integer",
"options": {
"unsigned": true,
"notnull": true,
"autoincrement": true
}
},
{
"name": "ct_rc_id",
"comment": "RCID for the change",
"type": "integer",
"options": {
"unsigned": true,
"notnull": false,
"default": null
}
},
{
"name": "ct_log_id",
"comment": "LOGID for the change",
"type": "integer",
"options": {
"unsigned": true,
"notnull": false,
"default": null
}
},
{
"name": "ct_rev_id",
"comment": "REVID for the change",
"type": "integer",
"options": {
"unsigned": true,
"notnull": false,
"default": null
}
},
{
"name": "ct_params",
"comment": "Parameters for the tag; used by some extensions",
"type": "blob",
"options": {
"length": 65530,
"notnull": false,
"default": null
}
},
{
"name": "ct_tag_id",
"comment": "Foreign key to change_tag_def row",
"type": "integer",
"options": {
"unsigned": true,
"notnull": true
}
}
],
"indexes": [
{
"name": "ct_rc_tag_id",
"columns": [
"ct_rc_id",
"ct_tag_id"
],
"unique": true
},
{
"name": "ct_log_tag_id",
"columns": [
"ct_log_id",
"ct_tag_id"
],
"unique": true
},
{
"name": "ct_rev_tag_id",
"columns": [
"ct_rev_id",
"ct_tag_id"
],
"unique": true
},
{
"name": "ct_tag_id_id",
"comment": "Covering index, so we can pull all the info only out of the index.",
"columns": [
"ct_tag_id",
"ct_rc_id",
"ct_rev_id",
"ct_log_id"
],
"unique": false
}
],
"pk": [
"ct_id"
]
},
"after": {
"name": "change_tag",
"comment": "A table to track tags for revisions, logs and recent changes",
"columns": [
{
"name": "ct_id",
"type": "integer",
"options": {
"unsigned": true,
"notnull": true,
"autoincrement": true
}
},
{
"name": "ct_rc_id",
"comment": "RCID for the change",
"type": "bigint",
"options": {
"unsigned": true,
"notnull": false,
"default": null
}
},
{
"name": "ct_log_id",
"comment": "LOGID for the change",
"type": "integer",
"options": {
"unsigned": true,
"notnull": false,
"default": null
}
},
{
"name": "ct_rev_id",
"comment": "REVID for the change",
"type": "integer",
"options": {
"unsigned": true,
"notnull": false,
"default": null
}
},
{
"name": "ct_params",
"comment": "Parameters for the tag; used by some extensions",
"type": "blob",
"options": {
"length": 65530,
"notnull": false,
"default": null
}
},
{
"name": "ct_tag_id",
"comment": "Foreign key to change_tag_def row",
"type": "integer",
"options": {
"unsigned": true,
"notnull": true
}
}
],
"indexes": [
{
"name": "ct_rc_tag_id",
"columns": [
"ct_rc_id",
"ct_tag_id"
],
"unique": true
},
{
"name": "ct_log_tag_id",
"columns": [
"ct_log_id",
"ct_tag_id"
],
"unique": true
},
{
"name": "ct_rev_tag_id",
"columns": [
"ct_rev_id",
"ct_tag_id"
],
"unique": true
},
{
"name": "ct_tag_id_id",
"comment": "Covering index, so we can pull all the info only out of the index.",
"columns": [
"ct_tag_id",
"ct_rc_id",
"ct_rev_id",
"ct_log_id"
],
"unique": false
}
],
"pk": [
"ct_id"
]
}
}

File Metadata

Mime Type
application/json
Expires
Aug 21 2026, 07:02 (12 w, 13 h ago)
Storage Engine
local-disk
Storage Format
Raw Data
Storage Handle
f6/5d/26c8f28e7931a0590f48bb659d2d
Default Alt Text
patch-change_tag-ct_rc_id.json (3 KB)

Event Timeline