From 7f17a1954f153ecdfecd524d3f7c921b3b0bd08a Mon Sep 17 00:00:00 2001
From: Arun Persaud <arun@nubati.net>
Date: Fri, 2 Nov 2007 11:23:45 +0100
Subject: NEW FEATURE: count game points, partly done ;)

a table will be shown now for score keeping.
fox, karlchen and dokos are accounted for
normal win, calling something and winning should be accounted for

still missing:
 both parties call or one party calls and doesn't acchieve it's goal
---
 create_database.sql | 4 +++-
 1 file changed, 3 insertions(+), 1 deletion(-)

(limited to 'create_database.sql')

diff --git a/create_database.sql b/create_database.sql
index d552be5..4408426 100644
--- a/create_database.sql
+++ b/create_database.sql
@@ -206,7 +206,9 @@ 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',
+  `party` enum('re','contra') default NULL ,
+  `winner_id` int(11) default NULL ,
+  `looser_id` int(11) default NULL ,
   `score` enum('120', 'call120','against120','90','call90','against90',
           '60','call60','against60','30','call30','against30',
           '0','call0','against0',
-- 
cgit v1.2.3-18-g5258

