From e010223224b28df4b53e763b2a4f2a4fb37cc339 Mon Sep 17 00:00:00 2001
From: Santo Cariotti <santo@dcariotti.me>
Date: Tue, 20 Sep 2022 16:43:18 +0200
Subject: Create warning app

---
 migrations/20220920135729_add-warnings-table.sql | 10 ++++++++++
 1 file changed, 10 insertions(+)
 create mode 100644 migrations/20220920135729_add-warnings-table.sql

(limited to 'migrations/20220920135729_add-warnings-table.sql')

diff --git a/migrations/20220920135729_add-warnings-table.sql b/migrations/20220920135729_add-warnings-table.sql
new file mode 100644
index 0000000..887e4f5
--- /dev/null
+++ b/migrations/20220920135729_add-warnings-table.sql
@@ -0,0 +1,10 @@
+CREATE TABLE warnings (
+    id SERIAL PRIMARY KEY,
+    user_id INTEGER REFERENCES users(id) ON DELETE SET NULL,
+    model_id INTEGER REFERENCES models(id) ON DELETE SET NULL,
+    resolved_by INTEGER REFERENCES users(id) ON DELETE SET NULL,
+    note TEXT,
+    admin_note TEXT,
+    created TIMESTAMP NOT NULL,
+    updated TIMESTAMP NOT NULL
+);
-- 
cgit v1.2.3-71-g8e6c

