diff options
| author | arun <arun@nubati.net> | 2007-06-07 18:09:08 +0000 |
|---|---|---|
| committer | arun <arun> | 2007-06-07 18:09:08 +0000 |
| commit | e68d4598c0d0a5e1f138b9c891f5c1c9ae0e8541 (patch) | |
| tree | 2854695034eba9e832ba486bc8443ffa3a4383a2 /create_database.sql | |
| parent | 337229f87e4507dd1ea9fa80cfc981f19822b726 (diff) | |
| download | e-DoKo-e68d4598c0d0a5e1f138b9c891f5c1c9ae0e8541.tar.gz e-DoKo-e68d4598c0d0a5e1f138b9c891f5c1c9ae0e8541.tar.bz2 e-DoKo-e68d4598c0d0a5e1f138b9c891f5c1c9ae0e8541.zip | |
* 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
Diffstat (limited to 'create_database.sql')
| -rw-r--r-- | create_database.sql | 2 |
1 files changed, 2 insertions, 0 deletions
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; |