diff options
| -rw-r--r-- | src/schema.sql | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/src/schema.sql b/src/schema.sql new file mode 100644 index 0000000..92fba4b --- /dev/null +++ b/src/schema.sql @@ -0,0 +1,18 @@ + +CREATE TABLE posts ( + post_id MEDIUMINT UNSIGNED, + message_id VARCHAR(255) NOT NULL, + in_reply_to VARCHAR(255), + edit_id MEDIUMINT NOT NULL AUTO_INCREMENT, + UNIQUE KEY (message_id), + PRIMARY KEY (edit_id), + INDEX (post_id) +); + +CREATE TABLE forums ( + list_name VARCHAR(255) NOT NULL, + forum_id MEDIUMINT UNSIGNED NOT NULL, + PRIMARY KEY (list_name), + INDEX (forum_id) +); + |