vw_small

commit 9b017bbbb9b5384bdfedbea5a1b8bdf14c3d61d0
parent ca01fa141945208c20e5e8c00e7cd274761bf10f
Author: Miroslav Prasil <miroslav@prasil.info>
Date:   Sat, 26 May 2018 00:39:19 +0100

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