Page MenuHomeWickedGov Phorge
Files F4117033

patch-page_props-pp_page.sql
No OneTemporary
Actions

Size
1 KB
Referenced Files
None
Subscribers
None

patch-page_props-pp_page.sql
View Options

-- This file is automatically generated using maintenance/generateSchemaChangeSql.php.
-- Source: maintenance/abstractSchemaChanges/patch-page_props-pp_page.json
-- Do not modify this file directly.
-- See https://www.mediawiki.org/wiki/Manual:Schema_changes
DROP INDEX pp_propname_page;
DROP INDEX pp_propname_sortkey_page;
CREATE TEMPORARY TABLE /*_*/__temp__page_props AS
SELECT pp_page, pp_propname, pp_value, pp_sortkey
FROM /*_*/page_props;
DROP TABLE /*_*/page_props;
CREATE TABLE /*_*/page_props ( pp_page INTEGER UNSIGNED NOT NULL, pp_propname BLOB NOT NULL, pp_value BLOB NOT NULL, pp_sortkey DOUBLE PRECISION DEFAULT NULL, PRIMARY KEY(pp_page, pp_propname) );
INSERT INTO /*_*/page_props ( pp_page, pp_propname, pp_value, pp_sortkey )
SELECT pp_page, pp_propname, pp_value, pp_sortkey
FROM /*_*/__temp__page_props;
DROP TABLE /*_*/__temp__page_props;
CREATE UNIQUE INDEX pp_propname_page ON /*_*/page_props (pp_propname, pp_page);
CREATE UNIQUE INDEX pp_propname_sortkey_page ON /*_*/page_props (pp_propname, pp_sortkey, pp_page);

File Metadata

Mime Type
text/plain
Expires
Wed, Aug 19, 01:59 (2 w, 3 d ago)
Storage Engine
local-disk
Storage Format
Raw Data
Storage Handle
b8/3c/016c0197ce1908ba9af3ad18bbe4
Default Alt Text
patch-page_props-pp_page.sql (1 KB)

Event Timeline