aboutsummaryrefslogtreecommitdiffstats
path: root/sql/sqlite/patch-user_properties-rename-index.sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql/sqlite/patch-user_properties-rename-index.sql')
-rw-r--r--sql/sqlite/patch-user_properties-rename-index.sql36
1 files changed, 25 insertions, 11 deletions
diff --git a/sql/sqlite/patch-user_properties-rename-index.sql b/sql/sqlite/patch-user_properties-rename-index.sql
index 11ff1b737025..00df750580ce 100644
--- a/sql/sqlite/patch-user_properties-rename-index.sql
+++ b/sql/sqlite/patch-user_properties-rename-index.sql
@@ -1,15 +1,29 @@
-- This file is automatically generated using maintenance/generateSchemaChangeSql.php.
--- Source: maintenance/abstractSchemaChanges/patch-user_properties-rename-index.json
+-- Source: sql/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
+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);