diff options
| author | Umherirrender <umherirrender_de.wp@web.de> | 2021-12-01 00:08:07 +0100 |
|---|---|---|
| committer | Umherirrender <umherirrender_de.wp@web.de> | 2022-01-27 20:20:00 +0100 |
| commit | fa4011067161be9c972b97383e35e906cc1aa6e7 (patch) | |
| tree | d86c2558a062403129abf95dbf51b21f2f72b1a8 /maintenance/sqlite/archives/patch-page_props-pp_page.sql | |
| parent | e2a2a393f9fab1cea9bfe430d49b0b0d9e64ebf0 (diff) | |
| download | mediawikicore-fa4011067161be9c972b97383e35e906cc1aa6e7.tar.gz mediawikicore-fa4011067161be9c972b97383e35e906cc1aa6e7.zip | |
schema: Make page_id references unsigned
This includes:
page_props.pp_page
page_restrictions.pr_page
ipblocks_restrictions.ir_value
These columns must hold all possible values from page.page_id,
which is an unsigned integer.
These patches doesn't apply to Postgres.
Bug: T297212
Change-Id: I789f19f4d52daeab08f3090771404d078f86d0b3
Diffstat (limited to 'maintenance/sqlite/archives/patch-page_props-pp_page.sql')
| -rw-r--r-- | maintenance/sqlite/archives/patch-page_props-pp_page.sql | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/maintenance/sqlite/archives/patch-page_props-pp_page.sql b/maintenance/sqlite/archives/patch-page_props-pp_page.sql new file mode 100644 index 000000000000..b69252ac4a66 --- /dev/null +++ b/maintenance/sqlite/archives/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 |