diff options
| author | uckelman <uckelman@nomic.net> | 2010-07-04 18:23:23 +0000 |
|---|---|---|
| committer | uckelman <uckelman@nomic.net> | 2010-07-04 18:23:23 +0000 |
| commit | 1c22d704254cfbee50e0e0456bc1ac066885690f (patch) | |
| tree | 3982c867dc1362792b11a08447d8dade9bb83976 | |
| parent | afe35c6acfa286cac5c14883068e85d259008780 (diff) | |
Added SQL schema.
git-svn-id: https://vassalengine.svn.sourceforge.net/svnroot/vassalengine/site-src/trunk@6973 67b53d14-2c14-4ace-a08f-0dab2b34000c
| -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) +); + |