Create warning app

1 files changed, 10 insertions, 0 deletions

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
+);