diff options
| author | Ammarpad <ammarpad@yahoo.com> | 2021-03-27 10:28:18 +0100 |
|---|---|---|
| committer | Ammarpad <ammarpad@yahoo.com> | 2021-03-28 09:55:07 +0100 |
| commit | c697406d3f67fa9cd90fad14cdd4dbf680daa4d8 (patch) | |
| tree | 77b76299e3906feada4362bd6074c5630da5c5e3 /maintenance/postgres | |
| parent | 9e644bbac47ae08e580142a27308b38b383f5f15 (diff) | |
| download | mediawikicore-c697406d3f67fa9cd90fad14cdd4dbf680daa4d8.tar.gz mediawikicore-c697406d3f67fa9cd90fad14cdd4dbf680daa4d8.zip | |
Prepare for migrating `user` to abstract schema
Split off to make the migration patch smaller
Postgres:
- Make user_touched not nullable
MySQL/SQlite
- Change user_name from varchar to varbinary
- Change user_name from varchar to varbinary
- Drop empty string default from user_touched (Timestamp field)
Bug: T230428
Bug: T164898
Change-Id: I8fe0b1fb2af3149a2e2fdae7bb056ac6f863b09c
Diffstat (limited to 'maintenance/postgres')
| -rw-r--r-- | maintenance/postgres/tables.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/maintenance/postgres/tables.sql b/maintenance/postgres/tables.sql index 44bd6f7d7649..6c018cc7bd1d 100644 --- a/maintenance/postgres/tables.sql +++ b/maintenance/postgres/tables.sql @@ -22,7 +22,7 @@ CREATE TABLE mwuser ( -- replace reserved word 'user' user_email_token TEXT, user_email_token_expires TIMESTAMPTZ, user_email_authenticated TIMESTAMPTZ, - user_touched TIMESTAMPTZ, + user_touched TIMESTAMPTZ NOT NULL, user_registration TIMESTAMPTZ, user_editcount INTEGER, user_password_expires TIMESTAMPTZ NULL |