diff options
Diffstat (limited to 'migrations')
| -rw-r--r-- | migrations/20220920135729_add-warnings-table.sql | 10 |
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 +); |