SQL

CREATE TABLE IF NOT EXISTS `tmg_mines_data` (
  `mine_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `mine_location` int(11) unsigned NOT NULL,
  `mine_level` int(11) unsigned NOT NULL,
  `mine_copper_min` int(11) unsigned NOT NULL,
  `mine_copper_max` int(11) unsigned NOT NULL,
  `mine_silver_min` int(11) unsigned NOT NULL,
  `mine_silver_max` int(11) unsigned NOT NULL,
  `mine_gold_min` int(11) unsigned NOT NULL,
  `mine_gold_max` int(11) unsigned NOT NULL,
  `mine_pickaxe` int(11) unsigned NOT NULL,
  `mine_iq` int(11) unsigned NOT NULL,
  `mine_power_use` int(11) unsigned NOT NULL,
  `mine_copper_item` int(11) unsigned NOT NULL,
  `mine_silver_item` int(11) unsigned NOT NULL,
  `mine_gold_item` int(11) unsigned NOT NULL,
  `mine_gem_item` int(11) unsigned NOT NULL,
  PRIMARY KEY (`mine_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `tmg_mining` (
  `userid` int(11) unsigned NOT NULL,
  `max_miningpower` int(11) NOT NULL,
  `miningpower` int(11) NOT NULL,
  `miningxp` varchar(11) NOT NULL,
  `buyable_power` smallint(11) NOT NULL,
  `mining_level` int(11) NOT NULL,
  PRIMARY KEY (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Mining Mod Update from TMG';