add 'empty category' message

1 files changed, 2 insertions, 0 deletions

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");