summaryrefslogtreecommitdiffstats
path: root/create_database.sql
diff options
context:
space:
mode:
authorarun <arun@nubati.net>2007-01-08 09:16:20 +0000
committerarun <arun>2007-01-08 09:16:20 +0000
commitf91a22b698415eacda6af7403814caa6f34ad7e5 (patch)
tree9c1ffdca2fb8738a41f4fddb062a143481bce5cc /create_database.sql
parenta260a1abdfb22b421fbb4305cf2a0c8d57b89c9e (diff)
downloade-DoKo-f91a22b698415eacda6af7403814caa6f34ad7e5.tar.gz
e-DoKo-f91a22b698415eacda6af7403814caa6f34ad7e5.tar.bz2
e-DoKo-f91a22b698415eacda6af7403814caa6f34ad7e5.zip
FEATURE: added solo and now you also can only play cards that are valid on a trick
Diffstat (limited to 'create_database.sql')
-rw-r--r--create_database.sql3
1 files changed, 2 insertions, 1 deletions
diff --git a/create_database.sql b/create_database.sql
index 66c0cc3..88c41d9 100644
--- a/create_database.sql
+++ b/create_database.sql
@@ -70,8 +70,9 @@ CREATE TABLE `Game` (
`mod_date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`create_date` timestamp NOT NULL default '0000-00-00 00:00:00',
`randomnumbers` varchar(136) default NULL,
- `type` enum('solo','wedding','poverty','dpoverty') default NULL,
+ `type` enum('normal','solo','wedding','poverty','dpoverty') default NULL,
`solo` enum('trumpless','jack','queen','trump','club','spade','heart','silent') default NULL,
+ `startplayer` tinyint(4) default '1',
`status` enum('pre','play','gameover') default NULL,
`followup_of` int(11) default NULL,
`id` int(11) NOT NULL auto_increment,