From 8510c36ded85740885e67b59ee2ec2360986c0a9 Mon Sep 17 00:00:00 2001
From: Alexander Kavon <me+git@alexkavon.com>
Date: Tue, 23 Jan 2024 01:40:39 -0500
Subject: new tables: tags, post_tags, generated sqlboiler tags model, updated
 posts/get template, updated posts table to take nullable description and
 user_id foreign key

---
 migrations/003_create_posts_table.sql.sql | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

(limited to 'migrations/003_create_posts_table.sql.sql')

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()
 );
-- 
cgit v1.2.3

