delete from player_levelstats where race=9 and class=6;

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 6, 1, 26, 17, 24, 17, 23);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 6, 2, 27, 18, 25, 17, 23);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 6, 3, 29, 19, 26, 17, 24);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 6, 4, 30, 19, 27, 17, 24);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 6, 5, 31, 20, 29, 17, 24);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 6, 6, 32, 21, 30, 17, 24);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 6, 7, 34, 22, 31, 18, 25);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 6, 8, 35, 23, 32, 18, 25);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 6, 9, 37, 24, 34, 18, 25);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 6, 10, 38, 24, 35, 18, 26);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 6, 11, 39, 25, 36, 18, 26);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 6, 12, 41, 26, 37, 18, 26);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 6, 13, 42, 27, 39, 18, 27);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 6, 14, 44, 28, 40, 18, 27);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 6, 15, 45, 29, 41, 18, 27);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 6, 16, 47, 30, 43, 19, 28);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 6, 17, 48, 31, 44, 19, 28);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 6, 18, 50, 32, 45, 19, 28);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 6, 19, 51, 33, 47, 19, 29);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 6, 20, 53, 34, 48, 19, 29);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 6, 21, 54, 34, 50, 19, 29);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 6, 22, 56, 35, 51, 19, 30);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 6, 23, 57, 36, 52, 20, 30);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 6, 24, 59, 37, 54, 20, 30);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 6, 25, 60, 38, 55, 20, 31);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 6, 26, 62, 39, 57, 20, 31);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 6, 27, 64, 40, 58, 20, 32);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 6, 28, 65, 41, 60, 20, 32);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 6, 29, 67, 43, 61, 21, 32);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 6, 30, 69, 44, 63, 21, 33);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 6, 31, 70, 45, 64, 21, 33);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 6, 32, 72, 46, 66, 21, 34);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 6, 33, 74, 47, 67, 21, 34);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 6, 34, 76, 48, 69, 21, 35);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 6, 35, 77, 49, 71, 22, 35);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 6, 36, 79, 50, 72, 22, 36);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 6, 37, 81, 51, 74, 22, 36);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 6, 38, 83, 52, 76, 22, 36);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 6, 39, 84, 53, 77, 22, 37);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 6, 40, 86, 55, 79, 23, 37);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 6, 41, 88, 56, 81, 23, 38);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 6, 42, 90, 57, 82, 23, 38);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 6, 43, 92, 58, 84, 23, 39);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 6, 44, 94, 59, 86, 23, 39);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 6, 45, 96, 60, 87, 24, 40);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 6, 46, 98, 62, 89, 24, 40);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 6, 47, 100, 63, 91, 24, 41);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 6, 48, 101, 64, 93, 24, 41);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 6, 49, 103, 65, 94, 25, 42);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 6, 50, 105, 66, 96, 25, 42);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 6, 51, 107, 68, 98, 25, 43);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 6, 52, 109, 69, 100, 25, 43);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 6, 53, 110, 69, 100, 25, 44);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 6, 54, 111, 70, 101, 26, 45);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 6, 55, 111, 70, 101, 26, 45);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 6, 56, 114, 72, 104, 26, 46);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 6, 57, 116, 73, 106, 26, 46);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 6, 58, 118, 74, 108, 27, 47);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 6, 59, 124, 76, 110, 27, 47);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 6, 60, 126, 77, 112, 27, 48);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 6, 61, 128, 78, 114, 27, 49);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 6, 62, 131, 80, 116, 27, 49);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 6, 63, 133, 81, 119, 28, 50);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 6, 64, 136, 83, 121, 28, 50);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 6, 65, 136, 84, 123, 28, 51);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 6, 66, 142, 86, 126, 28, 52);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 6, 67, 145, 87, 128, 29, 52);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 6, 68, 147, 89, 130, 29, 53);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 6, 69, 150, 90, 133, 29, 54);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 6, 70, 157, 92, 135, 29, 54);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 6, 71, 160, 94, 138, 30, 55);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 6, 72, 163, 95, 140, 30, 56);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 6, 73, 166, 97, 151, 30, 57);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 6, 74, 169, 99, 154, 30, 57);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 6, 75, 172, 100, 156, 31, 58);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 6, 76, 175, 102, 160, 31, 59);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 6, 77, 179, 104, 162, 31, 60);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 6, 78, 182, 105, 165, 31, 60);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 6, 79, 191, 107, 168, 32, 61);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 6, 80, 194, 109, 171, 32, 62);

delete from playercreateinfo_spell where race=9 and class=6;

insert into playercreateinfo_spell (race, class, Spell, Note) values (9, 6, 81, 'Dodge');

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

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

insert into playercreateinfo_spell (race, class, Spell, Note) values (9, 6, 200, 'Polearms');

insert into playercreateinfo_spell (race, class, Spell, Note) values (9, 6, 201, 'One-Handed Swords');

insert into playercreateinfo_spell (race, class, Spell, Note) values (9, 6, 202, 'Two-Handed Swords');

insert into playercreateinfo_spell (race, class, Spell, Note) values (9, 6, 203, 'Unarmed');

insert into playercreateinfo_spell (race, class, Spell, Note) values (9, 6, 204, 'Defense');

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

insert into playercreateinfo_spell (race, class, Spell, Note) values (9, 6, 669, 'Language Orcish');

insert into playercreateinfo_spell (race, class, Spell, Note) values (9, 6, 674, 'Dual Wield');

insert into playercreateinfo_spell (race, class, Spell, Note) values (9, 6, 750, 'Plate Mail');

insert into playercreateinfo_spell (race, class, Spell, Note) values (9, 6, 1843, 'Disarm');

insert into playercreateinfo_spell (race, class, Spell, Note) values (9, 6, 2382, 'Generic');

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

insert into playercreateinfo_spell (race, class, Spell, Note) values (9, 6, 3050, 'Detect');

insert into playercreateinfo_spell (race, class, Spell, Note) values (9, 6, 3127, 'Parry');

insert into playercreateinfo_spell (race, class, Spell, Note) values (9, 6, 3275, 'Linen Bandage');

insert into playercreateinfo_spell (race, class, Spell, Note) values (9, 6, 3276, 'Heavy Linen Bandage');

insert into playercreateinfo_spell (race, class, Spell, Note) values (9, 6, 3277, 'Wool Bandage');

insert into playercreateinfo_spell (race, class, Spell, Note) values (9, 6, 3278, 'Heavy Wool Bandage');

insert into playercreateinfo_spell (race, class, Spell, Note) values (9, 6, 3365, 'Opening');

insert into playercreateinfo_spell (race, class, Spell, Note) values (9, 6, 6233, 'Closing');

insert into playercreateinfo_spell (race, class, Spell, Note) values (9, 6, 6246, 'Closing');

insert into playercreateinfo_spell (race, class, Spell, Note) values (9, 6, 6247, 'Opening');

insert into playercreateinfo_spell (race, class, Spell, Note) values (9, 6, 6477, 'Opening');

insert into playercreateinfo_spell (race, class, Spell, Note) values (9, 6, 6478, 'Opening');

insert into playercreateinfo_spell (race, class, Spell, Note) values (9, 6, 6603, 'Attack');

insert into playercreateinfo_spell (race, class, Spell, Note) values (9, 6, 7266, 'Duel');

insert into playercreateinfo_spell (race, class, Spell, Note) values (9, 6, 7267, 'Grovel');

insert into playercreateinfo_spell (race, class, Spell, Note) values (9, 6, 7355, 'Stuck');

insert into playercreateinfo_spell (race, class, Spell, Note) values (9, 6, 7928, 'Silk Bandage');

insert into playercreateinfo_spell (race, class, Spell, Note) values (9, 6, 7929, 'Heavy Silk Bandage');

insert into playercreateinfo_spell (race, class, Spell, Note) values (9, 6, 7934, 'Anti-Venom');

insert into playercreateinfo_spell (race, class, Spell, Note) values (9, 6, 8386, 'Attacking');

insert into playercreateinfo_spell (race, class, Spell, Note) values (9, 6, 8737, 'Mail');

insert into playercreateinfo_spell (race, class, Spell, Note) values (9, 6, 9077, 'Leather');

insert into playercreateinfo_spell (race, class, Spell, Note) values (9, 6, 9078, 'Cloth');

insert into playercreateinfo_spell (race, class, Spell, Note) values (9, 6, 9125, 'Generic');

insert into playercreateinfo_spell (race, class, Spell, Note) values (9, 6, 10840, 'Mageweave Bandage');

insert into playercreateinfo_spell (race, class, Spell, Note) values (9, 6, 10841, 'Heavy Mageweave Bandage');

insert into playercreateinfo_spell (race, class, Spell, Note) values (9, 6, 10846, 'First Aid');

insert into playercreateinfo_spell (race, class, Spell, Note) values (9, 6, 18629, 'Runecloth Bandage');

insert into playercreateinfo_spell (race, class, Spell, Note) values (9, 6, 18630, 'Heavy Runecloth Bandage');

insert into playercreateinfo_spell (race, class, Spell, Note) values (9, 6, 20572, 'Blood Fury');

insert into playercreateinfo_spell (race, class, Spell, Note) values (9, 6, 20573, 'Hardiness');

insert into playercreateinfo_spell (race, class, Spell, Note) values (9, 6, 20574, 'Axe Specialization');

insert into playercreateinfo_spell (race, class, Spell, Note) values (9, 6, 21651, 'Opening');

insert into playercreateinfo_spell (race, class, Spell, Note) values (9, 6, 21652, 'Closing');

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

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

insert into playercreateinfo_spell (race, class, Spell, Note) values (9, 6, 33391, 'Journeyman Riding');

insert into playercreateinfo_spell (race, class, Spell, Note) values (9, 6, 45462, 'Plague Strike');

insert into playercreateinfo_spell (race, class, Spell, Note) values (9, 6, 45477, 'Icy Touch');

insert into playercreateinfo_spell (race, class, Spell, Note) values (9, 6, 45902, 'Blood Strike');

insert into playercreateinfo_spell (race, class, Spell, Note) values (9, 6, 45903, 'Offensive State (DND)');

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

insert into playercreateinfo_spell (race, class, Spell, Note) values (9, 6, 47541, 'Death Coil');

insert into playercreateinfo_spell (race, class, Spell, Note) values (9, 6, 48266, 'Blood Presence');

insert into playercreateinfo_spell (race, class, Spell, Note) values (9, 6, 49410, 'Forceful Deflection');

insert into playercreateinfo_spell (race, class, Spell, Note) values (9, 6, 49576, 'Death Grip');

insert into playercreateinfo_spell (race, class, Spell, Note) values (9, 6, 52665, 'Sigil');

insert into playercreateinfo_spell (race, class, Spell, Note) values (9, 6, 54562, 'Command');

insert into playercreateinfo_spell (race, class, Spell, Note) values (9, 6, 59879, 'Blood Plague');

insert into playercreateinfo_spell (race, class, Spell, Note) values (9, 6, 59921, 'Frost Fever');

insert into playercreateinfo_spell (race, class, Spell, Note) values (9, 6, 61437, 'Opening');

insert into playercreateinfo_spell (race, class, Spell, Note) values (9, 6, 61455, 'Runic Focus');

delete from playercreateinfo_action where race=9 and class=6;

insert into playercreateinfo_action (race, class, button, action, type) values (9, 6, 0, 6603, 0);

insert into playercreateinfo_action (race, class, button, action, type) values (9, 6, 1, 49576, 0);

insert into playercreateinfo_action (race, class, button, action, type) values (9, 6, 2, 45477, 0);

insert into playercreateinfo_action (race, class, button, action, type) values (9, 6, 3, 45462, 0);

insert into playercreateinfo_action (race, class, button, action, type) values (9, 6, 4, 45902, 0);

insert into playercreateinfo_action (race, class, button, action, type) values (9, 6, 5, 47541, 0);

insert into playercreateinfo_action (race, class, button, action, type) values (9, 6, 10, 20572, 0);