· 8 years ago · Jul 17, 2018, 08:26 PM
1SET FOREIGN_KEY_CHECKS=0;
2
3DROP TABLE IF EXISTS `bounties`;
4CREATE TABLE `bounties` (
5 `guid` int(200) unsigned NOT NULL,
6 `visual` varchar(200) NOT NULL,
7 `price` int(200) NOT NULL,
8 PRIMARY KEY (`guid`)
9) ENGINE=InnoDB DEFAULT CHARSET=latin1;
10
11DROP TABLE IF EXISTS `bounty_hunters`;
12CREATE TABLE `bounty_hunters` (
13 `guid` int(10) unsigned NOT NULL,
14 `is_hunter` tinyint(1) NOT NULL,
15 `hunters_killed` int(100) NOT NULL,
16 PRIMARY KEY (`guid`)
17) ENGINE=MyISAM DEFAULT CHARSET=latin1;