From 56e50564e87cc764fc5b815f19aa56560f78e4d3 Mon Sep 17 00:00:00 2001 From: Santo Cariotti Date: Mon, 12 Sep 2022 14:03:12 +0200 Subject: Keep saved filepath in the database --- migrations/20220912114912_add-models-uploads-table.sql | 6 ++++++ 1 file changed, 6 insertions(+) create mode 100644 migrations/20220912114912_add-models-uploads-table.sql (limited to 'migrations/20220912114912_add-models-uploads-table.sql') 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 +); -- cgit v1.2.3-71-g8e6c