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

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 4, 1, 20, 21, 22, 18, 25);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 4, 2, 21, 22, 23, 18, 25);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 4, 3, 22, 24, 23, 18, 26);

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

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 4, 5, 23, 27, 25, 19, 26);

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

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 4, 7, 25, 30, 26, 19, 27);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 4, 8, 25, 31, 27, 19, 27);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 4, 9, 26, 33, 28, 19, 28);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 4, 10, 27, 34, 28, 19, 28);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 4, 11, 28, 36, 29, 20, 29);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 4, 12, 29, 38, 30, 20, 29);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 4, 13, 30, 39, 31, 20, 29);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 4, 14, 31, 41, 32, 20, 30);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 4, 15, 31, 42, 32, 20, 30);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 4, 16, 32, 44, 33, 21, 31);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 4, 17, 33, 46, 34, 21, 31);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 4, 18, 34, 47, 35, 21, 32);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 4, 19, 35, 49, 36, 21, 32);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 4, 20, 36, 51, 36, 21, 32);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 4, 21, 37, 52, 37, 22, 33);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 4, 22, 38, 54, 38, 22, 33);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 4, 23, 39, 56, 39, 22, 34);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 4, 24, 40, 58, 40, 22, 34);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 4, 25, 41, 60, 41, 23, 35);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 4, 26, 42, 61, 42, 23, 35);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 4, 27, 43, 63, 43, 23, 36);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 4, 28, 44, 65, 44, 23, 36);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 4, 29, 45, 67, 44, 24, 37);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 4, 30, 46, 69, 45, 24, 37);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 4, 31, 47, 71, 46, 24, 38);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 4, 32, 48, 72, 47, 24, 38);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 4, 33, 49, 74, 48, 25, 39);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 4, 34, 50, 76, 49, 25, 39);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 4, 35, 51, 78, 50, 25, 40);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 4, 36, 52, 80, 51, 25, 41);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 4, 37, 53, 82, 52, 26, 41);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 4, 38, 54, 84, 53, 26, 42);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 4, 39, 55, 86, 54, 26, 42);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 4, 40, 56, 88, 55, 27, 43);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 4, 41, 57, 90, 56, 27, 43);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 4, 42, 59, 92, 57, 27, 44);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 4, 43, 60, 94, 58, 27, 45);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 4, 44, 61, 96, 59, 28, 45);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 4, 45, 62, 99, 60, 28, 46);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 4, 46, 63, 101, 61, 28, 46);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 4, 47, 64, 103, 63, 29, 47);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 4, 48, 66, 105, 64, 29, 48);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 4, 49, 67, 107, 65, 29, 48);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 4, 50, 68, 109, 66, 30, 49);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 4, 51, 69, 111, 67, 30, 50);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 4, 52, 70, 114, 68, 30, 50);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 4, 53, 72, 116, 69, 31, 51);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 4, 54, 73, 118, 70, 31, 52);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 4, 55, 74, 120, 72, 31, 52);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 4, 56, 75, 123, 73, 32, 53);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 4, 57, 77, 125, 74, 32, 54);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 4, 58, 78, 127, 75, 32, 54);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 4, 59, 79, 130, 76, 33, 55);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 4, 60, 81, 132, 77, 33, 56);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 4, 61, 82, 134, 79, 34, 56);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 4, 62, 83, 137, 80, 34, 57);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 4, 63, 84, 139, 81, 34, 58);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 4, 64, 86, 141, 82, 35, 59);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 4, 65, 87, 144, 84, 35, 59);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 4, 66, 88, 146, 85, 35, 60);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 4, 67, 90, 149, 86, 36, 61);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 4, 68, 91, 151, 87, 36, 61);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 4, 69, 93, 154, 89, 37, 62);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 4, 70, 94, 156, 90, 37, 63);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 4, 71, 96, 159, 91, 37, 64);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 4, 72, 98, 162, 93, 38, 64);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 4, 73, 99, 165, 95, 38, 65);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 4, 74, 101, 168, 96, 39, 66);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 4, 75, 103, 171, 98, 39, 67);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 4, 76, 104, 174, 99, 39, 68);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 4, 77, 106, 177, 101, 40, 69);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 4, 78, 108, 181, 103, 40, 70);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 4, 79, 110, 184, 104, 41, 71);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 4, 80, 112, 187, 106, 41, 72);

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

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

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

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

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

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

insert into playercreateinfo_spell (race, class, Spell, Note) values (9, 4, 1180, 'Daggers');

insert into playercreateinfo_spell (race, class, Spell, Note) values (9, 4, 1752, 'Sinister Strike');

insert into playercreateinfo_spell (race, class, Spell, Note) values (9, 4, 2098, 'Eviscerate');

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

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

insert into playercreateinfo_spell (race, class, Spell, Note) values (9, 4, 2567, 'Thrown');

insert into playercreateinfo_spell (race, class, Spell, Note) values (9, 4, 2764, 'Throw');

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

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

insert into playercreateinfo_spell (race, class, Spell, Note) values (9, 4, 5227, 'Underwater Breathing');

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

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

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

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

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

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

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

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

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

insert into playercreateinfo_spell (race, class, Spell, Note) values (9, 4, 7744, 'Will of the Forsaken');

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

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

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

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

insert into playercreateinfo_spell (race, class, Spell, Note) values (9, 4, 16092, 'Defensive State (DND)');

insert into playercreateinfo_spell (race, class, Spell, Note) values (9, 4, 17737, 'Language Gutterspeak');

insert into playercreateinfo_spell (race, class, Spell, Note) values (9, 4, 20577, 'Cannibalize');

insert into playercreateinfo_spell (race, class, Spell, Note) values (9, 4, 20579, 'Shadow Resistance');

insert into playercreateinfo_spell (race, class, Spell, Note) values (9, 4, 21184, 'Rogue Passive (DND)');

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

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

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

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

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

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

insert into playercreateinfo_spell (race, class, Spell, Note) values (9, 4, 68398, 'Opening');

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

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

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

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

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

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

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