diff options
Diffstat (limited to 'sql/sqlite/patch-user_properties-rename-index.sql')
| -rw-r--r-- | sql/sqlite/patch-user_properties-rename-index.sql | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/sql/sqlite/patch-user_properties-rename-index.sql b/sql/sqlite/patch-user_properties-rename-index.sql new file mode 100644 index 000000000000..11ff1b737025 --- /dev/null +++ b/sql/sqlite/patch-user_properties-rename-index.sql @@ -0,0 +1,15 @@ +-- This file is automatically generated using maintenance/generateSchemaChangeSql.php. +-- Source: maintenance/abstractSchemaChanges/patch-user_properties-rename-index.json +-- Do not modify this file directly. +-- See https://www.mediawiki.org/wiki/Manual:Schema_changes +DROP INDEX user_properties_property; +CREATE TEMPORARY TABLE /*_*/__temp__user_properties AS +SELECT up_user, up_property, up_value +FROM /*_*/user_properties; +DROP TABLE /*_*/user_properties; +CREATE TABLE /*_*/user_properties ( up_user INTEGER UNSIGNED NOT NULL, up_property BLOB NOT NULL, up_value BLOB DEFAULT NULL, PRIMARY KEY(up_user, up_property) ); +INSERT INTO /*_*/user_properties (up_user, up_property, up_value) +SELECT up_user, up_property, up_value +FROM /*_*/__temp__user_properties; +DROP TABLE /*_*/__temp__user_properties; +CREATE INDEX up_property ON /*_*/user_properties (up_property);
\ No newline at end of file |