aboutsummaryrefslogtreecommitdiff
path: root/migrations/003_create_posts_table.sql.sql
diff options
context:
space:
mode:
Diffstat (limited to 'migrations/003_create_posts_table.sql.sql')
-rw-r--r--migrations/003_create_posts_table.sql.sql3
1 files changed, 2 insertions, 1 deletions
diff --git a/migrations/003_create_posts_table.sql.sql b/migrations/003_create_posts_table.sql.sql
index 81dab8f..584b7b4 100644
--- a/migrations/003_create_posts_table.sql.sql
+++ b/migrations/003_create_posts_table.sql.sql
@@ -1,8 +1,9 @@
CREATE TABLE posts(
id SERIAL NOT NULL PRIMARY KEY,
title VARCHAR(100) NOT NULL,
- description TEXT NOT NULL,
+ description TEXT,
url VARCHAR(255) UNIQUE,
+ user_id INT NOT NULL REFERENCES users(id),
created_at TIMESTAMPTZ NOT NULL DEFAULT NOW(),
updated_at TIMESTAMPTZ NOT NULL DEFAULT NOW()
);