diff options
| author | jenkins-bot <jenkins-bot@gerrit.wikimedia.org> | 2024-12-13 14:54:36 +0000 |
|---|---|---|
| committer | Gerrit Code Review <gerrit@wikimedia.org> | 2024-12-13 14:54:36 +0000 |
| commit | 2d8285583f1866a0b00ec4df8365fb5fc63e0072 (patch) | |
| tree | 6375b9e4e1001936f3259f7f4674bfbad369b080 /sql/sqlite/patch-page_props-pp_page.sql | |
| parent | a42ef21f4f2fed3f76214568c4c9b91bd45435e6 (diff) | |
| parent | 251f4395865f8a33bcf32c6faa11748a14753492 (diff) | |
| download | mediawikicore-2d8285583f1866a0b00ec4df8365fb5fc63e0072.tar.gz mediawikicore-2d8285583f1866a0b00ec4df8365fb5fc63e0072.zip | |
Merge "Move SQL schema and schema changes to new sql/ top-level directory"
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 |