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

