diff options
Diffstat (limited to 'sql/sqlite/patch-page_props-pp_page.sql')
| -rw-r--r-- | sql/sqlite/patch-page_props-pp_page.sql | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/sql/sqlite/patch-page_props-pp_page.sql b/sql/sqlite/patch-page_props-pp_page.sql new file mode 100644 index 000000000000..b69252ac4a66 --- /dev/null +++ b/sql/sqlite/patch-page_props-pp_page.sql @@ -0,0 +1,17 @@ +-- 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);
\ No newline at end of file |