From acc32ccc1650b99e03c390a87e71b0a85b073162 Mon Sep 17 00:00:00 2001
From: Santo Cariotti <santo@dcariotti.me>
Date: Tue, 6 Sep 2022 19:58:35 +0200
Subject: Create a 3d model object

---
 migrations/20220906164354_add-models-table.sql | 13 +++++++++++++
 1 file changed, 13 insertions(+)
 create mode 100644 migrations/20220906164354_add-models-table.sql

(limited to 'migrations/20220906164354_add-models-table.sql')

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
+);
-- 
cgit v1.2.3-71-g8e6c

