diff options
| author | uckelman <uckelman@nomic.net> | 2010-07-16 21:37:14 +0000 |
|---|---|---|
| committer | uckelman <uckelman@nomic.net> | 2010-07-16 21:37:14 +0000 |
| commit | 222ef63558938c27c38b302bfb6a4f71bcd4c1b0 (patch) | |
| tree | d96e3180c89d1de7587145e44fb51af1067ed037 /src/schema.sql | |
| parent | 8bf43475d437e8fa41bcade5cba830b13f809c7f (diff) | |
Added lists table for mapping forum ids to lists.
git-svn-id: https://vassalengine.svn.sourceforge.net/svnroot/vassalengine/site-src/trunk@6993 67b53d14-2c14-4ace-a08f-0dab2b34000c
Diffstat (limited to 'src/schema.sql')
| -rw-r--r-- | src/schema.sql | 9 |
1 files changed, 6 insertions, 3 deletions
diff --git a/src/schema.sql b/src/schema.sql index 92fba4b..0a89f75 100644 --- a/src/schema.sql +++ b/src/schema.sql @@ -1,4 +1,3 @@ - CREATE TABLE posts ( post_id MEDIUMINT UNSIGNED, message_id VARCHAR(255) NOT NULL, @@ -12,7 +11,11 @@ CREATE TABLE posts ( CREATE TABLE forums ( list_name VARCHAR(255) NOT NULL, forum_id MEDIUMINT UNSIGNED NOT NULL, - PRIMARY KEY (list_name), - INDEX (forum_id) + PRIMARY KEY (list_name) ); +CREATE TABLE lists ( + list_name VARCHAR(255) NOT NULL, + forum_id MEDIUMINT UNSIGNED NOT NULL, + PRIMARY KEY (forum_id) +); |