1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
|
-- This file is automatically generated using maintenance/generateSchemaChangeSql.php.
-- Source: sql/abstractSchemaChanges/patch-page_props-pp_page.json
-- Do not modify this file directly.
-- See https://www.mediawiki.org/wiki/Manual:Schema_changes
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);
|
