mirror of
https://github.com/mod-playerbots/mod-playerbots
synced 2025-11-29 15:58:20 +08:00
41 lines
1.1 KiB
SQL
41 lines
1.1 KiB
SQL
DROP TABLE IF EXISTS `playerbots_weightscales`;
|
|
CREATE TABLE IF NOT EXISTS `playerbots_weightscales` (
|
|
`id` int(32) NOT NULL AUTO_INCREMENT,
|
|
`name` varchar(32) NOT NULL,
|
|
`class` tinyint(3) unsigned NOT NULL DEFAULT '0',
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
|
|
|
|
INSERT INTO `playerbots_weightscales` (`id`, `name`, `class`) VALUES
|
|
(1, 'arms', 1),
|
|
(2, 'fury', 1),
|
|
(3, 'prot', 1),
|
|
(4, 'holy', 2),
|
|
(5, 'prot', 2),
|
|
(6, 'retrib', 2),
|
|
(7, 'beast', 3),
|
|
(8, 'marks', 3),
|
|
(9, 'surv', 3),
|
|
(10, 'assas', 4),
|
|
(11, 'combat', 4),
|
|
(12, 'subtle', 4),
|
|
(13, 'disc', 5),
|
|
(14, 'holy', 5),
|
|
(15, 'shadow', 5),
|
|
(16, 'blooddps', 6),
|
|
(17, 'frostdps', 6),
|
|
(18, 'frosttank', 6),
|
|
(19, 'unholydps', 6),
|
|
(20, 'elem', 7),
|
|
(21, 'enhance', 7),
|
|
(22, 'resto', 7),
|
|
(23, 'arcane', 8),
|
|
(24, 'fire', 8),
|
|
(25, 'frost', 8),
|
|
(26, 'afflic', 9),
|
|
(27, 'demo', 9),
|
|
(28, 'destro', 9),
|
|
(29, 'balance', 11),
|
|
(30, 'feraltank', 11),
|
|
(31, 'resto', 11),
|
|
(32, 'feraldps', 11); |