vw_small

commit d69d4d0d30001d77eb0912eb371025d3c26b423b
parent 2cf46e1a5f6eec563ae8dc57dd4b5dff56515fdb
Author: Daniel García <dani-garcia@users.noreply.github.com>
Date:   Sat, 26 May 2018 23:05:55 +0200

Merge pull request #29 from mprasil/attachments_fix

Fix reference in attachments table
Diffstat:
A
migrations/2018-05-25-232323_update_attachments_reference/down.sql
 | 
0

A
migrations/2018-05-25-232323_update_attachments_reference/up.sql
 | 
15
+++++++++++++++

2 files changed, 15 insertions(+), 0 deletions(-)
diff --git a/migrations/2018-05-25-232323_update_attachments_reference/down.sql b/migrations/2018-05-25-232323_update_attachments_reference/down.sql
diff --git a/migrations/2018-05-25-232323_update_attachments_reference/up.sql b/migrations/2018-05-25-232323_update_attachments_reference/up.sql
@@ -0,0 +1,14 @@
+ALTER TABLE attachments RENAME TO oldAttachments;
+
+CREATE TABLE attachments (
+  id          TEXT    NOT NULL PRIMARY KEY,
+  cipher_uuid TEXT    NOT NULL REFERENCES ciphers (uuid),
+  file_name   TEXT    NOT NULL,
+  file_size   INTEGER NOT NULL
+
+);
+
+INSERT INTO attachments (id, cipher_uuid, file_name, file_size) 
+SELECT id, cipher_uuid, file_name, file_size FROM oldAttachments;
+
+DROP TABLE oldAttachments;
+\ No newline at end of file