diff options
Diffstat (limited to 'sql/sqlite/patch-user_table-updates.sql')
| -rw-r--r-- | sql/sqlite/patch-user_table-updates.sql | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/sql/sqlite/patch-user_table-updates.sql b/sql/sqlite/patch-user_table-updates.sql new file mode 100644 index 000000000000..acaabbb08b74 --- /dev/null +++ b/sql/sqlite/patch-user_table-updates.sql @@ -0,0 +1,19 @@ +-- This file is automatically generated using maintenance/generateSchemaChangeSql.php. +-- Source: maintenance/abstractSchemaChanges/patch-user_table-updates.json +-- Do not modify this file directly. +-- See https://www.mediawiki.org/wiki/Manual:Schema_changes +DROP INDEX user_name; +DROP INDEX user_email_token; +DROP INDEX user_email; +CREATE TEMPORARY TABLE /*_*/__temp__user AS +SELECT user_id, user_name, user_real_name, user_password, user_newpassword, user_newpass_time, user_email, user_touched, user_token, user_email_authenticated, user_email_token, user_email_token_expires, user_registration, user_editcount, user_password_expires +FROM /*_*/user; +DROP TABLE /*_*/user; +CREATE TABLE /*_*/user ( user_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, user_password BLOB NOT NULL, user_newpassword BLOB NOT NULL, user_newpass_time BLOB DEFAULT NULL, user_email CLOB NOT NULL, user_token BLOB DEFAULT '' NOT NULL, user_email_authenticated BLOB DEFAULT NULL, user_email_token BLOB DEFAULT NULL, user_email_token_expires BLOB DEFAULT NULL, user_registration BLOB DEFAULT NULL, user_editcount INTEGER DEFAULT NULL, user_password_expires BLOB DEFAULT NULL, user_name BLOB DEFAULT '' NOT NULL, user_real_name BLOB DEFAULT '' NOT NULL, user_touched BLOB NOT NULL ); +INSERT INTO /*_*/user ( user_id, user_name, user_real_name, user_password, user_newpassword, user_newpass_time, user_email, user_touched, user_token, user_email_authenticated, user_email_token, user_email_token_expires, user_registration, user_editcount, user_password_expires ) +SELECT user_id, user_name, user_real_name, user_password, user_newpassword, user_newpass_time, user_email, user_touched, user_token, user_email_authenticated, user_email_token, user_email_token_expires, user_registration, user_editcount, user_password_expires +FROM /*_*/__temp__user; +DROP TABLE /*_*/__temp__user; +CREATE UNIQUE INDEX user_name ON /*_*/user (user_name); +CREATE INDEX user_email_token ON /*_*/user (user_email_token); +CREATE INDEX user_email ON /*_*/user (user_email);
\ No newline at end of file |