rendered paste body
DROP TABLE IF EXISTS `buff_templates`;
CREATE TABLE IF NOT EXISTS `buff_templates` (
`id` int(11) unsigned NOT NULL,
`name` varchar(35) NOT NULL default '',
`skill_id` int(10) unsigned NOT NULL,
`skill_name` varchar(35) default NULL,
`skill_level` int(10) unsigned NOT NULL default '1',
`skill_force` int(1) NOT NULL default '1',
`skill_order` int(10) unsigned NOT NULL,
`char_min_level` int(10) unsigned NOT NULL default '0',
`char_max_level` int(10) unsigned NOT NULL default '0',
`char_race` int(1) unsigned NOT NULL default '0',
`char_class` int(1) NOT NULL default '0',
`char_faction` int(10) unsigned NOT NULL default '0',
`price_adena` int(10) unsigned NOT NULL default '0',
`price_points` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`id`,`name`,`skill_order`)
) DEFAULT CHARSET=utf8;
INSERT INTO `buff_templates` VALUES
(1, 'SupportMagic', 4342, 'WindWalk', 2, 1, 1, 8, 25, 0, 0, 0, 0, 0),
(1, 'SupportMagic', 4343, 'Decrease Weight', 3, 1, 2, 8, 25, 0, 0, 0, 0, 0),
(1, 'SupportMagic', 4344, 'Shield', 3, 1, 3, 8, 25, 0, 0, 0, 0, 0),
(1, 'SupportMagic', 4345, 'Might', 3, 1, 4, 8, 25, 0, 0, 0, 0, 0),
(1, 'SupportMagic', 4346, 'Mental Shield', 4, 1, 5, 8, 25, 0, 0, 0, 0, 0),
(1, 'SupportMagic', 4347, 'Bless the Body', 6, 1, 6, 8, 25, 0, 0, 0, 0, 0),
(1, 'SupportMagic', 4348, 'Bless the Soul', 6, 1, 7, 8, 25, 0, 0, 0, 0, 0),
(1, 'SupportMagic', 4349, 'Magic Barrier', 2, 1, 8, 8, 25, 0, 0, 0, 0, 0),
(1, 'SupportMagic', 4350, 'Resist Shock', 4, 1, 9, 8, 25, 0, 0, 0, 0, 0),
(1, 'SupportMagic', 4351, 'Concentration', 6, 1, 10, 8, 25, 0, 0, 0, 0, 0),
(1, 'SupportMagic', 4352, 'Berserker Spirit', 2, 1, 11, 8, 25, 0, 0, 0, 0, 0),
(1, 'SupportMagic', 4353, 'Bless Shield', 6, 1, 12, 8, 25, 0, 0, 0, 0, 0),
(1, 'SupportMagic', 4354, 'Vampiric Rage', 4, 1, 13, 8, 25, 0, 0, 0, 0, 0),
(1, 'SupportMagic', 4355, 'Acumen', 4, 1, 14, 8, 25, 0, 0, 0, 0, 0),
(1, 'SupportMagic', 4356, 'Empower', 3, 1, 15, 8, 25, 0, 0, 0, 0, 0),
(1, 'SupportMagic', 4357, 'Haste', 2, 1, 16, 8, 25, 0, 0, 0, 0, 0),
(1, 'SupportMagic', 4358, 'Guidance', 3, 1, 17, 8, 25, 0, 0, 0, 0, 0),
(1, 'SupportMagic', 4359, 'Focus', 3, 1, 18, 8, 25, 0, 0, 0, 0, 0),
(1, 'SupportMagic', 4360, 'Death Whisper', 3, 19, 8, 25, 0, 0, 0, 0, 0),
(1, 'SupportMagic', 271, 'Dance', 1, 1, 20, 8, 25, 0, 0, 0, 0, 0),
(1, 'SupportMagic', 273, '273', 1, 1, 21, 8, 25, 0, 0, 0, 0, 0),
(1, 'SupportMagic', 274, 'WindWalk', 1, 1, 22, 8, 25, 0, 0, 0, 0, 0),
(1, 'SupportMagic', 275, 'WindWalk', 1, 1, 23, 8, 25, 0, 0, 0, 0, 0),
(1, 'SupportMagic', 276, 'WindWalk', 1, 1, 24, 8, 25, 0, 0, 0, 0, 0),
(1, 'SupportMagic', 277, 'WindWalk', 1, 1, 25, 8, 25, 0, 0, 0, 0, 0),
(1, 'SupportMagic', 307, 'WindWalk', 1, 1, 26, 8, 25, 0, 0, 0, 0, 0),
(1, 'SupportMagic', 309, 'WindWalk', 1, 1, 27, 8, 25, 0, 0, 0, 0, 0),
(1, 'SupportMagic', 310, 'WindWalk', 1, 1, 28, 8, 25, 0, 0, 0, 0, 0),
(1, 'SupportMagic', 311, 'WindWalk', 1, 1, 29, 8, 25, 0, 0, 0, 0, 0),
(1, 'SupportMagic', 366, 'WindWalk', 1, 1, 30, 8, 25, 0, 0, 0, 0, 0),
(1, 'SupportMagic', 365, 'WindWalk', 1, 1, 31, 8, 25, 0, 0, 0, 0, 0),
(1, 'SupportMagic', 264, 'WindWalk', 1, 1, 32, 8, 25, 0, 0, 0, 0, 0),
(1, 'SupportMagic', 265, 'WindWalk', 1, 1, 33, 8, 25, 0, 0, 0, 0, 0),
(1, 'SupportMagic', 266, 'WindWalk', 1, 1, 34, 8, 25, 0, 0, 0, 0, 0),
(1, 'SupportMagic', 267, 'WindWalk', 1, 1, 35, 8, 25, 0, 0, 0, 0, 0),
(1, 'SupportMagic', 268, 'WindWalk', 1, 1, 36, 8, 25, 0, 0, 0, 0, 0),
(1, 'SupportMagic', 269, 'WindWalk', 1, 1, 37, 8, 25, 0, 0, 0, 0, 0),
(1, 'SupportMagic', 270, 'WindWalk', 1, 1, 38, 8, 25, 0, 0, 0, 0, 0),
(1, 'SupportMagic', 304, 'WindWalk', 1, 1, 39, 8, 25, 0, 0, 0, 0, 0),
(1, 'SupportMagic', 305, 'WindWalk', 1, 1, 40, 8, 25, 0, 0, 0, 0, 0),
(1, 'SupportMagic', 306, 'WindWalk', 1, 1, 41, 8, 25, 0, 0, 0, 0, 0),
(1, 'SupportMagic', 308, 'WindWalk', 1, 1, 42, 8, 25, 0, 0, 0, 0, 0),
(1, 'SupportMagic', 363, 'WindWalk', 1, 1, 43, 8, 25, 0, 0, 0, 0, 0),
(1, 'SupportMagic', 364, 'WindWalk', 1, 1, 44, 8, 25, 0, 0, 0, 0, 0),
(1, 'SupportMagic', 349, 'WindWalk', 1, 1, 45, 8, 25, 0, 0, 0, 0, 0),