diff options
author | Cflip <36554078+cflip@users.noreply.github.com> | 2021-01-24 13:19:07 -0700 |
---|---|---|
committer | Cflip <36554078+cflip@users.noreply.github.com> | 2021-01-24 13:19:07 -0700 |
commit | 2d39a708bdd88dc1601badbc2f58843b757996e9 (patch) | |
tree | 65be372b9dbf6e07751c226be1e2537844292cc3 /setup.sql | |
parent | fcd4a840ab072d8d2956f15b697b81aac415ba06 (diff) | |
parent | 5032ee6dde5b33846570d9ea7af6b508755c708b (diff) |
Merge branch 'master' of https://github.com/cflip/cflip_forums
Diffstat (limited to 'setup.sql')
-rw-r--r-- | setup.sql | 2 |
1 files changed, 2 insertions, 0 deletions
@@ -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"); |