mirror of
https://github.com/dani-garcia/vaultwarden
synced 2024-12-13 09:13:01 +01:00
1264eb640a
for the PostgreSQL backend. Also converts any CHAR types to VARCHAR to prevent the same issue from causing problems down the line.
26 lines
No EOL
1.6 KiB
SQL
26 lines
No EOL
1.6 KiB
SQL
ALTER TABLE attachments ALTER COLUMN id TYPE CHAR(36);
|
|
ALTER TABLE attachments ALTER COLUMN cipher_uuid TYPE CHAR(36);
|
|
ALTER TABLE users ALTER COLUMN uuid TYPE CHAR(36);
|
|
ALTER TABLE users ALTER COLUMN email TYPE VARCHAR(255);
|
|
ALTER TABLE devices ALTER COLUMN uuid TYPE CHAR(36);
|
|
ALTER TABLE devices ALTER COLUMN user_uuid TYPE CHAR(36);
|
|
ALTER TABLE organizations ALTER COLUMN uuid TYPE CHAR(40);
|
|
ALTER TABLE ciphers ALTER COLUMN uuid TYPE CHAR(36);
|
|
ALTER TABLE ciphers ALTER COLUMN user_uuid TYPE CHAR(36);
|
|
ALTER TABLE ciphers ALTER COLUMN organization_uuid TYPE CHAR(36);
|
|
ALTER TABLE folders ALTER COLUMN uuid TYPE CHAR(36);
|
|
ALTER TABLE folders ALTER COLUMN user_uuid TYPE CHAR(36);
|
|
ALTER TABLE collections ALTER COLUMN uuid TYPE CHAR(40);
|
|
ALTER TABLE collections ALTER COLUMN org_uuid TYPE CHAR(40);
|
|
ALTER TABLE users_collections ALTER COLUMN user_uuid TYPE CHAR(36);
|
|
ALTER TABLE users_collections ALTER COLUMN collection_uuid TYPE CHAR(36);
|
|
ALTER TABLE users_organizations ALTER COLUMN uuid TYPE CHAR(36);
|
|
ALTER TABLE users_organizations ALTER COLUMN user_uuid TYPE CHAR(36);
|
|
ALTER TABLE users_organizations ALTER COLUMN org_uuid TYPE CHAR(36);
|
|
ALTER TABLE folders_ciphers ALTER COLUMN cipher_uuid TYPE CHAR(36);
|
|
ALTER TABLE folders_ciphers ALTER COLUMN folder_uuid TYPE CHAR(36);
|
|
ALTER TABLE ciphers_collections ALTER COLUMN cipher_uuid TYPE CHAR(36);
|
|
ALTER TABLE ciphers_collections ALTER COLUMN collection_uuid TYPE CHAR(36);
|
|
ALTER TABLE twofactor ALTER COLUMN uuid TYPE CHAR(36);
|
|
ALTER TABLE twofactor ALTER COLUMN user_uuid TYPE CHAR(36);
|
|
ALTER TABLE invitations ALTER COLUMN email TYPE VARCHAR(255); |