summaryrefslogtreecommitdiff
path: root/migrations/postgresql/2019-09-12-100000_create_tables/down.sql
diff options
context:
space:
mode:
authorMichael Powers <[email protected]>2019-09-12 16:12:22 -0400
committerMichael Powers <[email protected]>2019-09-12 16:12:22 -0400
commitf5f9861a78c1a4b6322e27739e7886d8d0f15759 (patch)
treed938e44eb9b946a52c8b0de549dcdc8fa33d286d /migrations/postgresql/2019-09-12-100000_create_tables/down.sql
parentf9408a00c6dbbf28ac9b29b0e7ee8f04bc76925c (diff)
downloadvaultwarden-f5f9861a78c1a4b6322e27739e7886d8d0f15759.tar.gz
vaultwarden-f5f9861a78c1a4b6322e27739e7886d8d0f15759.zip
Adds support for PostgreSQL which resolves #87 and is mentioned in #246.
This includes migrations as well as Dockerfile's for amd64. The biggest change is that replace_into isn't supported by Diesel for the PostgreSQL backend, instead requiring the use of on_conflict. This unfortunately requires a branch for save() on all of the models currently using replace_into.
Diffstat (limited to 'migrations/postgresql/2019-09-12-100000_create_tables/down.sql')
-rw-r--r--migrations/postgresql/2019-09-12-100000_create_tables/down.sql13
1 files changed, 13 insertions, 0 deletions
diff --git a/migrations/postgresql/2019-09-12-100000_create_tables/down.sql b/migrations/postgresql/2019-09-12-100000_create_tables/down.sql
new file mode 100644
index 00000000..e4561c37
--- /dev/null
+++ b/migrations/postgresql/2019-09-12-100000_create_tables/down.sql
@@ -0,0 +1,13 @@
+DROP TABLE devices;
+DROP TABLE attachments;
+DROP TABLE users_collections;
+DROP TABLE users_organizations;
+DROP TABLE folders_ciphers;
+DROP TABLE ciphers_collections;
+DROP TABLE twofactor;
+DROP TABLE invitations;
+DROP TABLE collections;
+DROP TABLE folders;
+DROP TABLE ciphers;
+DROP TABLE users;
+DROP TABLE organizations;