From e68d4598c0d0a5e1f138b9c891f5c1c9ae0e8541 Mon Sep 17 00:00:00 2001 From: arun Date: Thu, 7 Jun 2007 18:09:08 +0000 Subject: * FIX: added extra check for calling 120, etc. so that people can't cheat * NEW: display sessions * NEW: display who's turn it is on the userpage (change in DB) * NEW: different ways when to say 90, 60, etc. (change in DB) * MISC: some clean up, e.g. display of final score --- create_database.sql | 2 ++ 1 file changed, 2 insertions(+) (limited to 'create_database.sql') diff --git a/create_database.sql b/create_database.sql index 4b75c47..b480bf3 100644 --- a/create_database.sql +++ b/create_database.sql @@ -74,6 +74,7 @@ CREATE TABLE `Game` ( `solo` enum('trumpless','jack','queen','trump','club','spade','heart','silent') default NULL, `sickness` int(11) default NULL, `startplayer` tinyint(4) default '1', + `playerid` int(11) default NULL, `status` enum('pre','play','gameover') default NULL, `ruleset` int(11) default NULL, `session` int(11) default NULL, @@ -102,6 +103,7 @@ CREATE TABLE `Rulesets` ( `create_date` timestamp NOT NULL default '0000-00-00 00:00:00', `dullen` enum('none','firstwins','secondwins') default 'secondwins', `schweinchen` enum ('none','both','second','secondaftercall') default 'second', + `call` enum ('1st-own-card','5th-card','9-cards') default '1st-own-card', `id` int(11) NOT NULL auto_increment, UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- cgit v1.2.3-18-g5258