diff options
| author | Arun Persaud <arun@nubati.net> | 2012-02-04 11:16:42 -0800 |
|---|---|---|
| committer | Arun Persaud <apersaud@lbl.gov> | 2012-02-04 11:16:42 -0800 |
| commit | 95231cf6650d277fc13f5c0e1c1a0e1bb9c30edb (patch) | |
| tree | 730b3980d9eaad8a840ab11bac4f0a720ff7e757 /create_database.sql | |
| parent | af2046f113109cc6ceaafcbce96377978e12c5a5 (diff) | |
| download | e-DoKo-95231cf6650d277fc13f5c0e1c1a0e1bb9c30edb.tar.gz e-DoKo-95231cf6650d277fc13f5c0e1c1a0e1bb9c30edb.tar.bz2 e-DoKo-95231cf6650d277fc13f5c0e1c1a0e1bb9c30edb.zip | |
fixed showing re/contra call at beginning of game; allowed pre-game comments; DB upgrade
the problem with re/contra at the beginning of a game was that no playid was set
yet, so we couldn't record when the call was made. Added two special playid (-1 and -2),
for pre-game comments and re/contra calls before the first card is played.
For this we need to record the gameid in the comment table => DB update
Diffstat (limited to 'create_database.sql')
| -rw-r--r-- | create_database.sql | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/create_database.sql b/create_database.sql index 71a6dfc..9db587a 100644 --- a/create_database.sql +++ b/create_database.sql @@ -88,6 +88,7 @@ CREATE TABLE `Comment` ( `id` int(11) NOT NULL auto_increment, `user_id` int(11) default NULL, `play_id` int(11) default NULL, + `game_id` int(11) default NULL, `comment` text, UNIQUE KEY `id` (`id`), KEY `play_id` (`play_id`) |