Page MenuHomeWickedGov Phorge
Files F5984195

patch-revtag-unique-to-pk.sql
No OneTemporary
Actions

Size
909 B
Referenced Files
None
Subscribers
None

patch-revtag-unique-to-pk.sql
View Options

-- This file is automatically generated using maintenance/generateSchemaChangeSql.php.
-- Source: sql/abstractSchemaChanges/patch-revtag-unique-to-pk.json
-- Do not modify this file directly.
-- See https://www.mediawiki.org/wiki/Manual:Schema_changes
DROP INDEX rt_type_page_revision;
DROP INDEX rt_revision_type;
CREATE TEMPORARY TABLE /*_*/__temp__revtag AS
SELECT rt_type, rt_page, rt_revision, rt_value
FROM /*_*/revtag;
DROP TABLE /*_*/revtag;
CREATE TABLE /*_*/revtag ( rt_type BLOB NOT NULL, rt_page INTEGER NOT NULL, rt_revision INTEGER NOT NULL, rt_value BLOB DEFAULT NULL, PRIMARY KEY(rt_type, rt_page, rt_revision) );
INSERT INTO /*_*/revtag ( rt_type, rt_page, rt_revision, rt_value )
SELECT rt_type, rt_page, rt_revision, rt_value
FROM /*_*/__temp__revtag;
DROP TABLE /*_*/__temp__revtag;
CREATE INDEX rt_revision_type ON /*_*/revtag (rt_revision, rt_type);

File Metadata

Mime Type
text/plain
Expires
Sat, Oct 3, 23:13 (2 w, 22 m ago)
Storage Engine
local-disk
Storage Format
Raw Data
Storage Handle
63/94/c90dc49b941855b490257ba477e0
Default Alt Text
patch-revtag-unique-to-pk.sql (909 B)

Event Timeline