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/20220903093057_add-users-table.sql  |  2 +-
 migrations/20220906164354_add-models-table.sql | 13 +++++++++++++
 2 files changed, 14 insertions(+), 1 deletion(-)
 create mode 100644 migrations/20220906164354_add-models-table.sql

(limited to 'migrations')

diff --git a/migrations/20220903093057_add-users-table.sql b/migrations/20220903093057_add-users-table.sql
index b55eae6..73c2396 100644
--- a/migrations/20220903093057_add-users-table.sql
+++ b/migrations/20220903093057_add-users-table.sql
@@ -1,5 +1,5 @@
 CREATE TABLE users (
-    id SERIAL UNIQUE PRIMARY KEY,
+    id SERIAL PRIMARY KEY,
     email VARCHAR(100) UNIQUE NOT NULL,
     username VARCHAR(100) UNIQUE NOT NULL,
     password VARCHAR(100) NOT NULL,
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