support message deletion0.1.4

2 files changed, 8 insertions, 0 deletions

diff --git a/migrations/2018-05-04-010249_deletion_record/down.sql b/migrations/2018-05-04-010249_deletion_record/down.sql
new file mode 100644
index 0000000..2a393f0
--- /dev/null
+++ b/migrations/2018-05-04-010249_deletion_record/down.sql
@@ -0,0 +1 @@
+DROP TABLE tombstones;
diff --git a/migrations/2018-05-04-010249_deletion_record/up.sql b/migrations/2018-05-04-010249_deletion_record/up.sql
new file mode 100644
index 0000000..64f6220
--- /dev/null
+++ b/migrations/2018-05-04-010249_deletion_record/up.sql
@@ -0,0 +1,7 @@
+CREATE TABLE tombstones (
+    id          SERIAL PRIMARY KEY,
+    meme_id     INTEGER NOT NULL,
+    deleted_by  BIGINT NOT NULL,
+    deleted_at  TIMESTAMP NOT NULL DEFAULT current_timestamp,
+    metadata_id INTEGER REFERENCES metadata
+);