diff options
author | arun <arun@nubati.net> | 2007-02-07 17:48:24 +0000 |
---|---|---|
committer | arun <arun> | 2007-02-07 17:48:24 +0000 |
commit | 9fd03423a0e5e26397250e8924d2be0e01e2ceaf (patch) | |
tree | b4275c469a7c7966b0cd7048b1135148d73f8239 /create_database.sql | |
parent | 7ecd66ab61eb1f0e8d32e75570b4809b57ae79d5 (diff) | |
download | e-DoKo-9fd03423a0e5e26397250e8924d2be0e01e2ceaf.tar.gz e-DoKo-9fd03423a0e5e26397250e8924d2be0e01e2ceaf.tar.bz2 e-DoKo-9fd03423a0e5e26397250e8924d2be0e01e2ceaf.zip |
fixed: bug in routine to figure out the next player
added rulesets (change in database): at the beginning of a game differnt rules can be chosen
Diffstat (limited to 'create_database.sql')
-rw-r--r-- | create_database.sql | 28 |
1 files changed, 28 insertions, 0 deletions
diff --git a/create_database.sql b/create_database.sql index bec2325..e4476ef 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, `startplayer` tinyint(4) default '1', `status` enum('pre','play','gameover') default NULL, + `ruleset` int(11) default NULL, `session` int(11) default NULL, `id` int(11) NOT NULL auto_increment, UNIQUE KEY `id` (`id`) @@ -89,6 +90,33 @@ LOCK TABLES `Game` WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE `Game` ENABLE KEYS */; + +-- +-- Table structure for table `Ruleset` +-- + +DROP TABLE IF EXISTS `Rulesets`; +CREATE TABLE `Rulesets` ( + `mod_date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, + `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', + `id` int(11) NOT NULL auto_increment, + UNIQUE KEY `id` (`id`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +-- +-- Dumping data for table `Rulesets` +-- + + +/*!40000 ALTER TABLE `Rulesets` DISABLE KEYS */; +LOCK TABLES `Rulesets` WRITE; +UNLOCK TABLES; +/*!40000 ALTER TABLE `Rulesets` ENABLE KEYS */; + + + -- -- Table structure for table `Hand` -- |