| Index: trunk/extensions/Contest/Contest.sql |
| — | — | @@ -3,7 +3,7 @@ |
| 4 | 4 | -- Author: Jeroen De Dauw < jeroendedauw@gmail.com > |
| 5 | 5 | |
| 6 | 6 | -- Contests |
| 7 | | -CREATE TABLE IF NOT EXISTS /*$wgDBprefix*/contests ( |
| | 7 | +CREATE TABLE IF NOT EXISTS /*_*/contests ( |
| 8 | 8 | contest_id SMALLINT unsigned NOT NULL auto_increment PRIMARY KEY, |
| 9 | 9 | contest_name VARCHAR(255) NOT NULL, -- String indentifier for the contest |
| 10 | 10 | contest_status TINYINT unsigned NOT NULL default '0', -- Status of the contest |
| — | — | @@ -11,8 +11,8 @@ |
| 12 | 12 | ) /*$wgDBTableOptions*/; |
| 13 | 13 | |
| 14 | 14 | -- Contestants |
| 15 | | -CREATE TABLE IF NOT EXISTS /*$wgDBprefix*/contest_contestants ( |
| 16 | | - contestant_id INT(10) unsigned NOT NULL auto_increment PRIMARY KEY, -- Contestant id (unique id per user per contest) |
| | 15 | +CREATE TABLE IF NOT EXISTS /*_*/contest_contestants ( |
| | 16 | + contestant_id INT unsigned NOT NULL auto_increment PRIMARY KEY, -- Contestant id (unique id per user per contest) |
| 17 | 17 | contestant_contest_id SMALLINT unsigned NOT NULL, -- Foreign key on contests.contest_id |
| 18 | 18 | contestant_user_id INT(10) unsigned NOT NULL, -- Foreign key on user.user_id |
| 19 | 19 | |
| — | — | @@ -27,18 +27,18 @@ |
| 28 | 28 | ) /*$wgDBTableOptions*/; |
| 29 | 29 | |
| 30 | 30 | -- Judge votes |
| 31 | | -CREATE TABLE IF NOT EXISTS /*$wgDBprefix*/contest_votes ( |
| 32 | | - vote_id INT(10) unsigned NOT NULL auto_increment PRIMARY KEY, |
| 33 | | - vote_contestant_id INT(10) unsigned NOT NULL, -- Foreign key on contest_contestants.contestant_id |
| | 31 | +CREATE TABLE IF NOT EXISTS /*_*/contest_votes ( |
| | 32 | + vote_id INT unsigned NOT NULL auto_increment PRIMARY KEY, |
| | 33 | + vote_contestant_id INT unsigned NOT NULL, -- Foreign key on contest_contestants.contestant_id |
| 34 | 34 | vote_user_id INT(10) unsigned NOT NULL, -- Judge user id |
| 35 | 35 | vote_value SMALLINT NOT NULL -- The value of the vote |
| 36 | 36 | ) /*$wgDBTableOptions*/; |
| 37 | 37 | |
| 38 | 38 | -- Judge comments |
| 39 | | -CREATE TABLE IF NOT EXISTS /*$wgDBprefix*/contest_comments ( |
| 40 | | - comment_id INT(10) unsigned NOT NULL auto_increment PRIMARY KEY, |
| 41 | | - comment_contestant_id INT(10) unsigned NOT NULL, -- Foreign key on contest_contestants.contestant_id |
| | 39 | +CREATE TABLE IF NOT EXISTS /*_*/contest_comments ( |
| | 40 | + comment_id INT unsigned NOT NULL auto_increment PRIMARY KEY, |
| | 41 | + comment_contestant_id INT unsigned NOT NULL, -- Foreign key on contest_contestants.contestant_id |
| 42 | 42 | comment_user_id INT(10) unsigned NOT NULL, -- Judge user id |
| 43 | 43 | comment_text TEXT NOT NULL, -- The comment text |
| 44 | | - comment_time CHAR(14) binary NOT NULL default '' -- The time at which the comment was made |
| | 44 | + comment_time binary(14) binary NOT NULL default '' -- The time at which the comment was made |
| 45 | 45 | ) /*$wgDBTableOptions*/; |
| \ No newline at end of file |