diff options
| author | Mathijs van Veluw <[email protected]> | 2024-09-20 12:06:06 +0200 |
|---|---|---|
| committer | GitHub <[email protected]> | 2024-09-20 12:06:06 +0200 |
| commit | de01111082cea605ad1788e9596b0078ef4fcc73 (patch) | |
| tree | 2f2e1c4ea96c794a8b4925ff8fe040098d740d24 /migrations | |
| parent | 0bd8f607cb47ea905f33cba22d24f243e712d652 (diff) | |
| download | vaultwarden-de01111082cea605ad1788e9596b0078ef4fcc73.tar.gz vaultwarden-de01111082cea605ad1788e9596b0078ef4fcc73.zip | |
Fix Device Type column for 2FA migration (#4971)
Diffstat (limited to 'migrations')
3 files changed, 3 insertions, 3 deletions
diff --git a/migrations/mysql/2024-09-04-091351_use_device_type_for_mails/up.sql b/migrations/mysql/2024-09-04-091351_use_device_type_for_mails/up.sql index 423e16c1..a8fc7dfd 100644 --- a/migrations/mysql/2024-09-04-091351_use_device_type_for_mails/up.sql +++ b/migrations/mysql/2024-09-04-091351_use_device_type_for_mails/up.sql @@ -1 +1 @@ -ALTER TABLE `twofactor_incomplete` ADD COLUMN `device_type` INTEGER NOT NULL; +ALTER TABLE twofactor_incomplete ADD COLUMN device_type INTEGER NOT NULL DEFAULT 14; -- 14 = Unknown Browser diff --git a/migrations/postgresql/2024-09-04-091351_use_device_type_for_mails/up.sql b/migrations/postgresql/2024-09-04-091351_use_device_type_for_mails/up.sql index f0641cb2..a8fc7dfd 100644 --- a/migrations/postgresql/2024-09-04-091351_use_device_type_for_mails/up.sql +++ b/migrations/postgresql/2024-09-04-091351_use_device_type_for_mails/up.sql @@ -1 +1 @@ -ALTER TABLE twofactor_incomplete ADD COLUMN device_type INTEGER NOT NULL; +ALTER TABLE twofactor_incomplete ADD COLUMN device_type INTEGER NOT NULL DEFAULT 14; -- 14 = Unknown Browser diff --git a/migrations/sqlite/2024-09-04-091351_use_device_type_for_mails/up.sql b/migrations/sqlite/2024-09-04-091351_use_device_type_for_mails/up.sql index 423e16c1..a8fc7dfd 100644 --- a/migrations/sqlite/2024-09-04-091351_use_device_type_for_mails/up.sql +++ b/migrations/sqlite/2024-09-04-091351_use_device_type_for_mails/up.sql @@ -1 +1 @@ -ALTER TABLE `twofactor_incomplete` ADD COLUMN `device_type` INTEGER NOT NULL; +ALTER TABLE twofactor_incomplete ADD COLUMN device_type INTEGER NOT NULL DEFAULT 14; -- 14 = Unknown Browser |