summaryrefslogtreecommitdiff
path: root/setup.sql
diff options
context:
space:
mode:
authorCflip <36554078+cflip@users.noreply.github.com>2021-01-24 13:19:07 -0700
committerCflip <36554078+cflip@users.noreply.github.com>2021-01-24 13:19:07 -0700
commit2d39a708bdd88dc1601badbc2f58843b757996e9 (patch)
tree65be372b9dbf6e07751c226be1e2537844292cc3 /setup.sql
parentfcd4a840ab072d8d2956f15b697b81aac415ba06 (diff)
parent5032ee6dde5b33846570d9ea7af6b508755c708b (diff)
Merge branch 'master' of https://github.com/cflip/cflip_forums
Diffstat (limited to 'setup.sql')
-rw-r--r--setup.sql2
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");