From 95231cf6650d277fc13f5c0e1c1a0e1bb9c30edb Mon Sep 17 00:00:00 2001 From: Arun Persaud Date: Sat, 4 Feb 2012 11:16:42 -0800 Subject: 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 --- create_database.sql | 1 + 1 file changed, 1 insertion(+) (limited to 'create_database.sql') 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`) -- cgit v1.2.3-18-g5258