0ZaBTTrR

1CREATE TABLE IF NOT EXISTS `tmg_mines_data` (
2  `mine_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
3  `mine_location` int(11) unsigned NOT NULL,
4  `mine_level` int(11) unsigned NOT NULL,
5  `mine_copper_min` int(11) unsigned NOT NULL,
6  `mine_copper_max` int(11) unsigned NOT NULL,
7  `mine_silver_min` int(11) unsigned NOT NULL,
8  `mine_silver_max` int(11) unsigned NOT NULL,
9  `mine_gold_min` int(11) unsigned NOT NULL,
10  `mine_gold_max` int(11) unsigned NOT NULL,
11  `mine_pickaxe` int(11) unsigned NOT NULL,
12  `mine_iq` int(11) unsigned NOT NULL,
13  `mine_power_use` int(11) unsigned NOT NULL,
14  `mine_copper_item` int(11) unsigned NOT NULL,
15  `mine_silver_item` int(11) unsigned NOT NULL,
16  `mine_gold_item` int(11) unsigned NOT NULL,
17  `mine_gem_item` int(11) unsigned NOT NULL,
18  PRIMARY KEY (`mine_id`)
19) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
20
21CREATE TABLE IF NOT EXISTS `tmg_mining` (
22  `userid` int(11) unsigned NOT NULL,
23  `max_miningpower` int(11) NOT NULL,
24  `miningpower` int(11) NOT NULL,
25  `miningxp` varchar(11) NOT NULL,
26  `buyable_power` smallint(11) NOT NULL,
27  `mining_level` int(11) NOT NULL,
28  PRIMARY KEY (`userid`)
29) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Mining Mod Update from TMG';