From 3e07ecbf6f6b1f9f027bc5895a43d5efa774d083 Mon Sep 17 00:00:00 2001 From: Arun Persaud Date: Sun, 13 Jul 2008 14:40:59 -0700 Subject: 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 --- create_database.sql | 26 ++++++++++++++++++++++++++ 1 file changed, 26 insertions(+) (limited to 'create_database.sql') diff --git a/create_database.sql b/create_database.sql index 0ac02f0..5ec47eb 100644 --- a/create_database.sql +++ b/create_database.sql @@ -200,6 +200,32 @@ LOCK TABLES `Hand_Card` WRITE; 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` -- -- cgit v1.2.3-18-g5258