delete from player_levelstats where race=1 and class=3;

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 3, 1, 21, 25, 22, 16, 22);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 3, 2, 21, 26, 23, 17, 23);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 3, 3, 22, 28, 24, 17, 23);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 3, 4, 22, 29, 25, 18, 24);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 3, 5, 23, 30, 26, 18, 25);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 3, 6, 23, 32, 27, 19, 25);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 3, 7, 24, 33, 28, 20, 26);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 3, 8, 24, 35, 28, 20, 26);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 3, 9, 25, 36, 29, 21, 27);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 3, 10, 25, 38, 30, 21, 28);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 3, 11, 25, 39, 31, 22, 29);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 3, 12, 26, 41, 32, 23, 29);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 3, 13, 26, 42, 33, 23, 30);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 3, 14, 27, 44, 34, 24, 31);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 3, 15, 27, 45, 35, 25, 31);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 3, 16, 28, 47, 36, 25, 32);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 3, 17, 28, 48, 38, 26, 33);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 3, 18, 29, 50, 39, 27, 34);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 3, 19, 29, 51, 40, 28, 34);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 3, 20, 30, 53, 41, 28, 35);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 3, 21, 31, 55, 42, 29, 36);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 3, 22, 31, 56, 43, 30, 37);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 3, 23, 32, 58, 44, 30, 37);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 3, 24, 32, 60, 45, 31, 38);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 3, 25, 33, 61, 46, 32, 39);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 3, 26, 33, 63, 48, 33, 40);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 3, 27, 34, 65, 49, 33, 41);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 3, 28, 35, 66, 50, 34, 41);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 3, 29, 35, 68, 51, 35, 42);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 3, 30, 36, 70, 52, 36, 43);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 3, 31, 36, 72, 53, 37, 44);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 3, 32, 37, 73, 55, 37, 45);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 3, 33, 38, 75, 56, 38, 46);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 3, 34, 38, 77, 57, 39, 47);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 3, 35, 39, 79, 58, 40, 48);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 3, 36, 39, 81, 60, 41, 48);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 3, 37, 40, 83, 61, 41, 49);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 3, 38, 41, 85, 62, 42, 50);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 3, 39, 41, 86, 63, 43, 51);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 3, 40, 42, 88, 65, 44, 52);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 3, 41, 43, 90, 66, 45, 53);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 3, 42, 43, 92, 67, 46, 54);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 3, 43, 44, 94, 69, 47, 55);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 3, 44, 45, 96, 70, 47, 56);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 3, 45, 45, 98, 71, 48, 57);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 3, 46, 46, 100, 73, 49, 58);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 3, 47, 47, 102, 74, 50, 59);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 3, 48, 48, 104, 76, 51, 60);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 3, 49, 48, 106, 77, 52, 61);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 3, 50, 49, 108, 78, 53, 62);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 3, 51, 50, 110, 80, 54, 63);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 3, 52, 51, 113, 81, 55, 64);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 3, 53, 51, 115, 83, 56, 65);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 3, 54, 52, 117, 84, 57, 66);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 3, 55, 53, 119, 86, 58, 67);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 3, 56, 54, 121, 87, 59, 68);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 3, 57, 54, 123, 89, 60, 69);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 3, 58, 55, 126, 90, 61, 70);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 3, 59, 56, 128, 92, 62, 71);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 3, 60, 57, 130, 93, 63, 73);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 3, 61, 58, 132, 95, 64, 74);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 3, 62, 58, 134, 96, 65, 75);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 3, 63, 59, 137, 98, 66, 76);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 3, 64, 60, 139, 99, 67, 77);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 3, 65, 61, 141, 101, 68, 78);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 3, 66, 62, 144, 103, 69, 79);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 3, 67, 62, 146, 104, 70, 80);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 3, 68, 63, 148, 106, 71, 82);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 3, 69, 64, 151, 107, 72, 83);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 3, 70, 65, 153, 109, 73, 84);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 3, 71, 66, 156, 111, 74, 85);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 3, 72, 67, 159, 113, 75, 86);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 3, 73, 68, 162, 115, 76, 88);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 3, 74, 69, 165, 117, 78, 89);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 3, 75, 70, 174, 119, 82, 91);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 3, 76, 71, 177, 121, 83, 92);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 3, 77, 72, 180, 123, 85, 94);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 3, 78, 73, 184, 125, 86, 95);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 3, 79, 74, 187, 127, 87, 97);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 3, 80, 75, 190, 129, 89, 98);

delete from playercreateinfo_spell where race=1 and class=3;

insert into playercreateinfo_spell (race, class, Spell, Note) values (1, 3, 75, 'Auto Shot');

insert into playercreateinfo_spell (race, class, Spell, Note) values (1, 3, 81, 'Dodge');

insert into playercreateinfo_spell (race, class, Spell, Note) values (1, 3, 196, 'One-Handed Axes');

insert into playercreateinfo_spell (race, class, Spell, Note) values (1, 3, 197, 'Two-Handed Axes');

insert into playercreateinfo_spell (race, class, Spell, Note) values (1, 3, 203, 'Unarmed');

insert into playercreateinfo_spell (race, class, Spell, Note) values (1, 3, 204, 'Defense');

insert into playercreateinfo_spell (race, class, Spell, Note) values (1, 3, 264, 'Bows');

insert into playercreateinfo_spell (race, class, Spell, Note) values (1, 3, 522, 'SPELLDEFENSE (DND)');

insert into playercreateinfo_spell (race, class, Spell, Note) values (1, 3, 2382, 'Generic');

insert into playercreateinfo_spell (race, class, Spell, Note) values (1, 3, 2479, 'Honorless Target');

insert into playercreateinfo_spell (race, class, Spell, Note) values (1, 3, 2973, 'Raptor Strike');

insert into playercreateinfo_spell (race, class, Spell, Note) values (1, 3, 3050, 'Detect');

insert into playercreateinfo_spell (race, class, Spell, Note) values (1, 3, 3365, 'Opening');

insert into playercreateinfo_spell (race, class, Spell, Note) values (1, 3, 6233, 'Closing');

insert into playercreateinfo_spell (race, class, Spell, Note) values (1, 3, 6246, 'Closing');

insert into playercreateinfo_spell (race, class, Spell, Note) values (1, 3, 6247, 'Opening');

insert into playercreateinfo_spell (race, class, Spell, Note) values (1, 3, 6477, 'Opening');

insert into playercreateinfo_spell (race, class, Spell, Note) values (1, 3, 6478, 'Opening');

insert into playercreateinfo_spell (race, class, Spell, Note) values (1, 3, 6603, 'Attack');

insert into playercreateinfo_spell (race, class, Spell, Note) values (1, 3, 7266, 'Duel');

insert into playercreateinfo_spell (race, class, Spell, Note) values (1, 3, 7267, 'Grovel');

insert into playercreateinfo_spell (race, class, Spell, Note) values (1, 3, 7341, 'Language Troll');

insert into playercreateinfo_spell (race, class, Spell, Note) values (1, 3, 7355, 'Stuck');

insert into playercreateinfo_spell (race, class, Spell, Note) values (1, 3, 8386, 'Attacking');

insert into playercreateinfo_spell (race, class, Spell, Note) values (1, 3, 9077, 'Leather');

insert into playercreateinfo_spell (race, class, Spell, Note) values (1, 3, 9078, 'Cloth');

insert into playercreateinfo_spell (race, class, Spell, Note) values (1, 3, 9125, 'Generic');

insert into playercreateinfo_spell (race, class, Spell, Note) values (1, 3, 13358, 'Defensive State (DND)');

insert into playercreateinfo_spell (race, class, Spell, Note) values (1, 3, 20555, 'Regeneration');

insert into playercreateinfo_spell (race, class, Spell, Note) values (1, 3, 20557, 'Beast Slaying');

insert into playercreateinfo_spell (race, class, Spell, Note) values (1, 3, 20558, 'Throwing Specialization');

insert into playercreateinfo_spell (race, class, Spell, Note) values (1, 3, 21651, 'Opening');

insert into playercreateinfo_spell (race, class, Spell, Note) values (1, 3, 21652, 'Closing');

insert into playercreateinfo_spell (race, class, Spell, Note) values (1, 3, 22027, 'Remove Insignia');

insert into playercreateinfo_spell (race, class, Spell, Note) values (1, 3, 22810, 'Opening - No Text');

insert into playercreateinfo_spell (race, class, Spell, Note) values (1, 3, 24949, 'Defensive State 2 (DND)');

insert into playercreateinfo_spell (race, class, Spell, Note) values (1, 3, 26290, 'Bow Specialization');

insert into playercreateinfo_spell (race, class, Spell, Note) values (1, 3, 26297, 'Berserking');

insert into playercreateinfo_spell (race, class, Spell, Note) values (1, 3, 34082, 'Advantaged State (DND)');

insert into playercreateinfo_spell (race, class, Spell, Note) values (1, 3, 45927, 'Summon Friend');

insert into playercreateinfo_spell (race, class, Spell, Note) values (1, 3, 58943, 'Da Voodoo Shuffle');

insert into playercreateinfo_spell (race, class, Spell, Note) values (1, 3, 61437, 'Opening');

insert into playercreateinfo_spell (race, class, Spell, Note) values (1, 3, 68398, 'Opening');

delete from playercreateinfo_action where race=1 and class=3;

insert into playercreateinfo_action (race, class, button, action, type) values (1, 3, 0, 6603, 0);

insert into playercreateinfo_action (race, class, button, action, type) values (1, 3, 1, 2973, 0);

insert into playercreateinfo_action (race, class, button, action, type) values (1, 3, 2, 75, 0);

insert into playercreateinfo_action (race, class, button, action, type) values (1, 3, 3, 26297, 0);

insert into playercreateinfo_action (race, class, button, action, type) values (1, 3, 11, 4604, 128);