summaryrefslogtreecommitdiffstats
path: root/migrations
diff options
context:
space:
mode:
authorSanto Cariotti <santo@dcariotti.me>2022-09-12 12:03:12 +0000
committerSanto Cariotti <santo@dcariotti.me>2022-09-12 12:03:12 +0000
commit56e50564e87cc764fc5b815f19aa56560f78e4d3 (patch)
treef97899198cb722b6b9b2eab00d3a7f20fef5f354 /migrations
parent63b49b0876457a1bce9405a571f3c9b97a270fb4 (diff)
Keep saved filepath in the database
Diffstat (limited to 'migrations')
-rw-r--r--migrations/20220912114912_add-models-uploads-table.sql6
1 files changed, 6 insertions, 0 deletions
diff --git a/migrations/20220912114912_add-models-uploads-table.sql b/migrations/20220912114912_add-models-uploads-table.sql
new file mode 100644
index 0000000..6647c69
--- /dev/null
+++ b/migrations/20220912114912_add-models-uploads-table.sql
@@ -0,0 +1,6 @@
+CREATE TABLE uploads (
+ id SERIAL PRIMARY KEY,
+ model_id INTEGER REFERENCES models(id) NOT NULL,
+ filepath VARCHAR NOT NULL,
+ created TIMESTAMP NOT NULL
+);