diff options
author | Arun Persaud <arun@nubati.net> | 2007-06-21 16:22:36 +0200 |
---|---|---|
committer | Arun Persaud <arun@nubati.net> | 2007-06-25 09:11:38 +0200 |
commit | 822dd99d21ade0e223428976d5f9d72de1e3439b (patch) | |
tree | be1442873cc115acbd2acb8742cfe94a6f50e39f /create_database.sql | |
parent | 26c07fd03d0bf3bdd6142f0474b625afcfae508b (diff) | |
download | e-DoKo-822dd99d21ade0e223428976d5f9d72de1e3439b.tar.gz e-DoKo-822dd99d21ade0e223428976d5f9d72de1e3439b.tar.bz2 e-DoKo-822dd99d21ade0e223428976d5f9d72de1e3439b.zip |
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
Diffstat (limited to 'create_database.sql')
-rw-r--r-- | create_database.sql | 7 |
1 files changed, 6 insertions, 1 deletions
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; |