diff options
| author | Arun Persaud <arun@nubati.net> | 2008-07-13 14:40:59 -0700 |
|---|---|---|
| committer | Arun Persaud <arun@nubati.net> | 2008-07-13 20:35:17 -0700 |
| commit | 3e07ecbf6f6b1f9f027bc5895a43d5efa774d083 (patch) | |
| tree | 3fd80e735d3f738e597f2b60f59359e7b5794e4d /create_database.sql | |
| parent | 4f932986e02718cba7aef75d69702e2b7daa88fe (diff) | |
| download | e-DoKo-3e07ecbf6f6b1f9f027bc5895a43d5efa774d083.tar.gz e-DoKo-3e07ecbf6f6b1f9f027bc5895a43d5efa774d083.tar.bz2 e-DoKo-3e07ecbf6f6b1f9f027bc5895a43d5efa774d083.zip | |
NEW FEATURE: in poverty you can now see what cards have been handed over
cards exchanged during poverty show now up in the pre-game trick.
Signed-off-by: Arun Persaud <arun@nubati.net>
Diffstat (limited to 'create_database.sql')
| -rw-r--r-- | create_database.sql | 26 |
1 files changed, 26 insertions, 0 deletions
diff --git a/create_database.sql b/create_database.sql index 0ac02f0..5ec47eb 100644 --- a/create_database.sql +++ b/create_database.sql @@ -201,6 +201,32 @@ UNLOCK TABLES; /*!40000 ALTER TABLE `Hand_Card` ENABLE KEYS */; -- +-- Table structure for table `Card_Exchange` +-- + +DROP TABLE IF EXISTS `Card_Exchange`; +CREATE TABLE `Card_Exchange` ( + `id` int(11) NOT NULL auto_increment, + `orig_hand_id` int(11) NOT NULL default '0', + `new_hand_id` int(11) NOT NULL default '0', + `card_id` int(11) NOT NULL default '0', + UNIQUE KEY `id` (`id`), + KEY `orig_hand_id` (`orig_hand_id`), + KEY `new_hand_id` (`new_hand_id`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +-- +-- Dumping data for table `Hand_Card` +-- + + +/*!40000 ALTER TABLE `Hand_Card` DISABLE KEYS */; +LOCK TABLES `Hand_Card` WRITE; +UNLOCK TABLES; +/*!40000 ALTER TABLE `Hand_Card` ENABLE KEYS */; + + +-- -- Table structure for table `Play` -- |