Page Menu
Home
WickedGov Phorge
Search
Configure Global Search
Log In
Files
F7420924
patch-revtag-unique-to-pk.json
No One
Temporary
Actions
Download File
Edit File
Delete File
View Transforms
Subscribe
Flag For Later
Award Token
Size
1 KB
Referenced Files
None
Subscribers
None
patch-revtag-unique-to-pk.json
View Options
{
"comment"
:
"Convert unique index to primary key (T243985)"
,
"before"
:
{
"name"
:
"revtag"
,
"comment"
:
"Revision tags"
,
"columns"
:
[
{
"name"
:
"rt_type"
,
"type"
:
"binary"
,
"options"
:
{
"notnull"
:
true
,
"length"
:
60
}
},
{
"name"
:
"rt_page"
,
"comment"
:
"Link to page.page_id"
,
"type"
:
"integer"
,
"options"
:
{
"notnull"
:
true
}
},
{
"name"
:
"rt_revision"
,
"comment"
:
"Link to revision.rev_id"
,
"type"
:
"integer"
,
"options"
:
{
"notnull"
:
true
}
},
{
"name"
:
"rt_value"
,
"type"
:
"blob"
,
"options"
:
{
"length"
:
65530
,
"notnull"
:
false
}
}
],
"indexes"
:
[
{
"name"
:
"rt_type_page_revision"
,
"comment"
:
"Index for finding all revisions in a page with a given tag"
,
"columns"
:
[
"rt_type"
,
"rt_page"
,
"rt_revision"
],
"unique"
:
true
},
{
"name"
:
"rt_revision_type"
,
"comment"
:
"Index for finding the tags on a given revision"
,
"columns"
:
[
"rt_revision"
,
"rt_type"
],
"unique"
:
false
}
]
},
"after"
:
{
"name"
:
"revtag"
,
"comment"
:
"Revision tags"
,
"columns"
:
[
{
"name"
:
"rt_type"
,
"type"
:
"binary"
,
"options"
:
{
"notnull"
:
true
,
"length"
:
60
}
},
{
"name"
:
"rt_page"
,
"comment"
:
"Link to page.page_id"
,
"type"
:
"integer"
,
"options"
:
{
"notnull"
:
true
}
},
{
"name"
:
"rt_revision"
,
"comment"
:
"Link to revision.rev_id"
,
"type"
:
"integer"
,
"options"
:
{
"notnull"
:
true
}
},
{
"name"
:
"rt_value"
,
"type"
:
"blob"
,
"options"
:
{
"length"
:
65530
,
"notnull"
:
false
}
}
],
"indexes"
:
[
{
"name"
:
"rt_revision_type"
,
"comment"
:
"Index for finding the tags on a given revision"
,
"columns"
:
[
"rt_revision"
,
"rt_type"
],
"unique"
:
false
}
],
"pk"
:
[
"rt_type"
,
"rt_page"
,
"rt_revision"
]
}
}
File Metadata
Details
Attached
Mime Type
application/json
Expires
Sun, Nov 22, 05:12 (1 d, 1 h)
Storage Engine
local-disk
Storage Format
Raw Data
Storage Handle
09/55/2279d3ad1cb90fd65176eba831bf
Default Alt Text
patch-revtag-unique-to-pk.json (1 KB)
Attached To
Mode
rMWPROD MediaWiki Production
Attached
Detach File
Event Timeline
Log In to Comment