· 8 years ago · Apr 08, 2018, 09:36 PM
1DROP TABLE IF EXISTS `character_xp_rates`;
2CREATE TABLE `character_xp_rates` (
3 `guid` INT(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier' ,
4 `kill_xp_rate` INT(11) UNSIGNED NOT NULL DEFAULT 1 COMMENT 'Experience Multiplier' ,
5 `quest_xp_rate` INT(11) UNSIGNED NOT NULL DEFAULT 1 COMMENT 'Experience Multiplier' ,
6 `explore_xp_rate` INT(11) UNSIGNED NOT NULL DEFAULT 1 COMMENT 'Experience Multiplier' ,
7PRIMARY KEY (`guid`)
8
9) ENGINE=INNODB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;