From 822dd99d21ade0e223428976d5f9d72de1e3439b Mon Sep 17 00:00:00 2001 From: Arun Persaud Date: Thu, 21 Jun 2007 16:22:36 +0200 Subject: CLEANUP: counting points, prepare for keeping track of game points use the database now to add up points, cleaned up the code a bit (counting points was done in different places), don't use score table for points from cards any more --- create_database.sql | 7 ++++++- 1 file changed, 6 insertions(+), 1 deletion(-) (limited to 'create_database.sql') diff --git a/create_database.sql b/create_database.sql index 4be13de..c5de955 100644 --- a/create_database.sql +++ b/create_database.sql @@ -204,9 +204,13 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `Score`; CREATE TABLE `Score` ( `id` int(11) NOT NULL auto_increment, + `create_date` timestamp NOT NULL default '0000-00-00 00:00:00', `game_id` int(11) NOT NULL default '0', `hand_id` int(11) NOT NULL default '0', - `score` tinyint(4) default NULL, + `score` enum('120', 'call120','against120','90','call90','against90', + '60','call60','against60','30','call30','against30', + '0','call0','against0', + 'fox','karlchen','dulle','doko','againstqueens') default NULL, UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; @@ -230,6 +234,7 @@ CREATE TABLE `Trick` ( `create_date` timestamp NOT NULL default '0000-00-00 00:00:00', `id` int(11) NOT NULL auto_increment, `game_id` int(11) NOT NULL default '0', + `winner` tinyint(4) default NULL, UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- cgit v1.2.3-18-g5258