From 95231cf6650d277fc13f5c0e1c1a0e1bb9c30edb Mon Sep 17 00:00:00 2001
From: Arun Persaud <arun@nubati.net>
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

