Page MenuHomeWickedGov Phorge
Files F2753074

patch-change_tag-rename-indexes.json
No OneTemporary
Actions

Size
3 KB
Referenced Files
None
Subscribers
None

patch-change_tag-rename-indexes.json
View Options

{
"comment": "Rename all indexes to have uniform ct_ prefix (T270033)",
"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": "change_tag_rc_tag_id",
"columns": [
"ct_rc_id",
"ct_tag_id"
],
"unique": true
},
{
"name": "change_tag_log_tag_id",
"columns": [
"ct_log_id",
"ct_tag_id"
],
"unique": true
},
{
"name": "change_tag_rev_tag_id",
"columns": [
"ct_rev_id",
"ct_tag_id"
],
"unique": true
},
{
"name": "change_tag_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": "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"
]
}
}

File Metadata

Mime Type
application/json
Expires
Fri, Jul 3, 20:45 (1 d, 6 h)
Storage Engine
local-disk
Storage Format
Raw Data
Storage Handle
14/b1/c49bb811675bdf889fbb0d729908
Default Alt Text
patch-change_tag-rename-indexes.json (3 KB)

Event Timeline