summaryrefslogtreecommitdiffstats
path: root/migrations/20220906164354_add-models-table.sql
diff options
context:
space:
mode:
Diffstat (limited to 'migrations/20220906164354_add-models-table.sql')
-rw-r--r--migrations/20220906164354_add-models-table.sql13
1 files changed, 13 insertions, 0 deletions
diff --git a/migrations/20220906164354_add-models-table.sql b/migrations/20220906164354_add-models-table.sql
new file mode 100644
index 0000000..84425ba
--- /dev/null
+++ b/migrations/20220906164354_add-models-table.sql
@@ -0,0 +1,13 @@
+CREATE TABLE models (
+ id SERIAL PRIMARY KEY,
+ name VARCHAR NOT NULL,
+ description TEXT,
+ duration INTEGER NOT NULL,
+ height INTEGER NOT NULL,
+ weight INTEGER NOT NULL,
+ printer VARCHAR,
+ material VARCHAR,
+ author_id INTEGER REFERENCES users(id) NOT NULL,
+ created TIMESTAMP NOT NULL,
+ updated TIMESTAMP NOT NULL
+);