BL0eku5f

1-- ----------------------------
2-- Table structure for `character_counters`
3-- ----------------------------
4DROP TABLE IF EXISTS `character_counters`;
5CREATE TABLE `character_counters` (
6  `char_id` int(11) NOT NULL,
7  `highest_karma` int(11) NOT NULL DEFAULT '0',
8  `times_died` int(11) NOT NULL DEFAULT '0',
9  `mobs_killed` int(11) NOT NULL DEFAULT '0',
10  `raids_killed` int(11) NOT NULL DEFAULT '0',
11  `summons_killed` int(11) NOT NULL DEFAULT '0',
12  `recipes_crafted` int(11) NOT NULL DEFAULT '0',
13  `recipes_failed` int(11) NOT NULL DEFAULT '0',
14  `longest_spree` int(11) NOT NULL DEFAULT '0',
15  `sprees_ended` int(11) NOT NULL DEFAULT '0',
16  `crits_done` int(11) NOT NULL DEFAULT '0',
17  `mscrits_done` int(11) NOT NULL DEFAULT '0',
18  `sieges_won` int(11) NOT NULL DEFAULT '0',
19  `fortresses_won` int(11) NOT NULL DEFAULT '0',
20  `most_adena` bigint(22) NOT NULL DEFAULT '0',
21  `achievments_done` int(2) NOT NULL DEFAULT '0',
22  `duels_won` int(11) NOT NULL DEFAULT '0',
23  `players_ressurected` int(11) NOT NULL DEFAULT '0',
24  `seeds_extracted` int(2) NOT NULL DEFAULT '0',
25  `treasure_box_opened` int(11) NOT NULL DEFAULT '0',
26  `fish_catched` int(11) NOT NULL DEFAULT '0',
27  `antharasKilled` int(11) NOT NULL DEFAULT '0',
28  `baiumKilled` int(11) NOT NULL DEFAULT '0',
29  `valakasKilled` int(11) NOT NULL DEFAULT '0',
30  `orfenKilled` int(11) NOT NULL DEFAULT '0',
31  `antQueenKilled` int(11) NOT NULL DEFAULT '0',
32  `coreKilled` int(11) NOT NULL DEFAULT '0',
33  `belethKilled` int(11) NOT NULL DEFAULT '0',
34  `sailrenKilled` int(11) NOT NULL DEFAULT '0',
35  `baylorKilled` int(11) NOT NULL DEFAULT '0',
36  `zakenKilled` int(11) NOT NULL DEFAULT '0',
37  `tiatKilled` int(11) NOT NULL DEFAULT '0',
38  `freyaKilled` int(11) NOT NULL DEFAULT '0',
39  `frintezzaKilled` int(11) NOT NULL DEFAULT '0',
40  `highestEnchant` int(11) NOT NULL DEFAULT '0',
41  `enchantBlessedSucceeded` int(11) NOT NULL DEFAULT '0',
42  `enchantNormalSucceeded` int(11) NOT NULL DEFAULT '0',
43  PRIMARY KEY (`char_id`)
44) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
45
46-- ----------------------------
47-- Records of character_counters
48-- ----------------------------