From 5032ee6dde5b33846570d9ea7af6b508755c708b Mon Sep 17 00:00:00 2001
From: h5p9sl <21267024+h5p9sl@users.noreply.github.com>
Date: Sun, 24 Jan 2021 09:12:33 -0700
Subject: add 'empty category' message

---
 setup.sql | 2 ++
 1 file changed, 2 insertions(+)

(limited to 'setup.sql')

diff --git a/setup.sql b/setup.sql
index f51250b..5934e3e 100644
--- a/setup.sql
+++ b/setup.sql
@@ -37,3 +37,5 @@ ALTER TABLE threads ADD FOREIGN KEY(thread_cat) REFERENCES categories(cat_id) ON
 ALTER TABLE threads ADD FOREIGN KEY(thread_author) REFERENCES users(user_id) ON DELETE RESTRICT ON UPDATE CASCADE;
 ALTER TABLE posts ADD FOREIGN KEY(post_thread) REFERENCES threads(thread_id) ON DELETE CASCADE ON UPDATE CASCADE;
 ALTER TABLE posts ADD FOREIGN KEY(post_author) REFERENCES users(user_id) ON DELETE RESTRICT ON UPDATE CASCADE;
+
+INSERT INTO categories (cat_name, cat_description) VALUES ("General", "Discussion of anything that doesn't fit in the other categories");
-- 
cgit v1.2.3

