vw_small

Hardened fork of Vaultwarden (https://github.com/dani-garcia/vaultwarden) with fewer features.
git clone https://git.philomathiclife.com/repos/vw_small
Log | Files | Refs | README

commit 2e7bd62353859b7d13f3461011b77fea3954cb73
parent 3a90364b3282918fbc0cd590fc7fbe22b20439ee
Author: Daniel GarcĂ­a <dani-garcia@users.noreply.github.com>
Date:   Tue, 17 Sep 2019 18:50:40 +0200

Merge pull request #624 from swedishborgie/postgresql

Fix issue with downloading attachments and PostgreSQL backend.
Diffstat:
Amigrations/postgresql/2019-09-16-150000_fix_attachments/down.sql | 27+++++++++++++++++++++++++++
Amigrations/postgresql/2019-09-16-150000_fix_attachments/up.sql | 28++++++++++++++++++++++++++++
2 files changed, 55 insertions(+), 0 deletions(-)

diff --git a/migrations/postgresql/2019-09-16-150000_fix_attachments/down.sql b/migrations/postgresql/2019-09-16-150000_fix_attachments/down.sql @@ -0,0 +1,26 @@ +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); +\ No newline at end of file diff --git a/migrations/postgresql/2019-09-16-150000_fix_attachments/up.sql b/migrations/postgresql/2019-09-16-150000_fix_attachments/up.sql @@ -0,0 +1,27 @@ +-- Switch from CHAR() types to VARCHAR() types to avoid padding issues. +ALTER TABLE attachments ALTER COLUMN id TYPE TEXT; +ALTER TABLE attachments ALTER COLUMN cipher_uuid TYPE VARCHAR(40); +ALTER TABLE users ALTER COLUMN uuid TYPE VARCHAR(40); +ALTER TABLE users ALTER COLUMN email TYPE TEXT; +ALTER TABLE devices ALTER COLUMN uuid TYPE VARCHAR(40); +ALTER TABLE devices ALTER COLUMN user_uuid TYPE VARCHAR(40); +ALTER TABLE organizations ALTER COLUMN uuid TYPE VARCHAR(40); +ALTER TABLE ciphers ALTER COLUMN uuid TYPE VARCHAR(40); +ALTER TABLE ciphers ALTER COLUMN user_uuid TYPE VARCHAR(40); +ALTER TABLE ciphers ALTER COLUMN organization_uuid TYPE VARCHAR(40); +ALTER TABLE folders ALTER COLUMN uuid TYPE VARCHAR(40); +ALTER TABLE folders ALTER COLUMN user_uuid TYPE VARCHAR(40); +ALTER TABLE collections ALTER COLUMN uuid TYPE VARCHAR(40); +ALTER TABLE collections ALTER COLUMN org_uuid TYPE VARCHAR(40); +ALTER TABLE users_collections ALTER COLUMN user_uuid TYPE VARCHAR(40); +ALTER TABLE users_collections ALTER COLUMN collection_uuid TYPE VARCHAR(40); +ALTER TABLE users_organizations ALTER COLUMN uuid TYPE VARCHAR(40); +ALTER TABLE users_organizations ALTER COLUMN user_uuid TYPE VARCHAR(40); +ALTER TABLE users_organizations ALTER COLUMN org_uuid TYPE VARCHAR(40); +ALTER TABLE folders_ciphers ALTER COLUMN cipher_uuid TYPE VARCHAR(40); +ALTER TABLE folders_ciphers ALTER COLUMN folder_uuid TYPE VARCHAR(40); +ALTER TABLE ciphers_collections ALTER COLUMN cipher_uuid TYPE VARCHAR(40); +ALTER TABLE ciphers_collections ALTER COLUMN collection_uuid TYPE VARCHAR(40); +ALTER TABLE twofactor ALTER COLUMN uuid TYPE VARCHAR(40); +ALTER TABLE twofactor ALTER COLUMN user_uuid TYPE VARCHAR(40); +ALTER TABLE invitations ALTER COLUMN email TYPE TEXT; +\ No newline at end of file