diff options
| -rw-r--r-- | setup.sql | 9 |
1 files changed, 6 insertions, 3 deletions
@@ -11,6 +11,8 @@ CREATE TABLE categories ( cat_id INT(8) NOT NULL AUTO_INCREMENT, cat_name VARCHAR(255) NOT NULL, cat_description VARCHAR(255) NOT NULL, + cat_thread_count INT(8) NOT NULL DEFAULT 0, + cat_post_count INT(8) NOT NULL DEFAULT 0, UNIQUE INDEX cat_name_unique (cat_name), PRIMARY KEY (cat_id) ) ENGINE = InnoDB; @@ -18,8 +20,9 @@ CREATE TABLE categories ( CREATE TABLE threads ( thread_id INT(8) NOT NULL AUTO_INCREMENT, thread_subject VARCHAR(255) NOT NULL, - thread_date DATETIME NOT NULL, - thread_cat INT(8) NOT NULL, + thread_date_created DATETIME NOT NULL, + thread_date_lastpost DATETIME NOT NULL, + thread_category INT(8) NOT NULL, thread_author INT(8) NOT NULL, PRIMARY KEY (thread_id) ) ENGINE = InnoDB; @@ -33,7 +36,7 @@ CREATE TABLE posts ( PRIMARY KEY (post_id) ) ENGINE = InnoDB; -ALTER TABLE threads ADD FOREIGN KEY(thread_cat) REFERENCES categories(cat_id) ON DELETE CASCADE ON UPDATE CASCADE; +ALTER TABLE threads ADD FOREIGN KEY(thread_category) REFERENCES categories(cat_id) ON DELETE CASCADE ON UPDATE CASCADE; 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; |