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

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

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 1, 2, 23, 19, 24, 18, 25);

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

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

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 1, 5, 27, 21, 28, 18, 26);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 1, 6, 29, 22, 29, 18, 26);

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

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

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

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

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

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 1, 12, 37, 27, 36, 19, 28);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 1, 13, 38, 28, 38, 19, 28);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 1, 14, 40, 29, 39, 19, 29);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 1, 15, 41, 30, 40, 19, 29);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 1, 16, 43, 31, 42, 20, 29);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 1, 17, 44, 32, 43, 20, 30);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 1, 18, 46, 33, 44, 20, 30);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 1, 19, 47, 34, 46, 20, 31);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 1, 20, 49, 34, 47, 20, 31);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 1, 21, 50, 35, 49, 20, 31);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 1, 22, 52, 36, 50, 20, 32);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 1, 23, 53, 37, 51, 21, 32);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 1, 24, 55, 38, 53, 21, 32);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 1, 25, 57, 39, 54, 21, 33);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 1, 26, 58, 40, 56, 21, 33);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 1, 27, 60, 41, 57, 21, 34);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 1, 28, 62, 42, 59, 21, 34);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 1, 29, 63, 43, 60, 21, 34);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 1, 30, 65, 44, 62, 22, 35);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 1, 31, 67, 46, 63, 22, 35);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 1, 32, 68, 47, 65, 22, 36);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 1, 33, 70, 48, 67, 22, 36);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 1, 34, 72, 49, 68, 22, 36);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 1, 35, 74, 50, 70, 23, 37);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 1, 36, 75, 51, 71, 23, 37);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 1, 37, 77, 52, 73, 23, 38);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 1, 38, 79, 53, 75, 23, 38);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 1, 39, 81, 54, 76, 23, 39);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 1, 40, 83, 55, 78, 24, 39);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 1, 41, 84, 57, 80, 24, 40);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 1, 42, 86, 58, 81, 24, 40);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 1, 43, 88, 59, 83, 24, 41);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 1, 44, 90, 60, 85, 24, 41);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 1, 45, 92, 61, 86, 25, 42);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 1, 46, 94, 62, 88, 25, 42);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 1, 47, 96, 64, 90, 25, 43);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 1, 48, 98, 65, 92, 25, 43);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 1, 49, 100, 66, 93, 25, 44);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 1, 50, 102, 67, 95, 26, 44);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 1, 51, 104, 69, 97, 26, 45);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 1, 52, 106, 70, 99, 26, 45);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 1, 53, 108, 71, 101, 26, 46);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 1, 54, 110, 72, 103, 27, 46);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 1, 55, 112, 74, 104, 27, 47);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 1, 56, 114, 75, 106, 27, 48);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 1, 57, 116, 76, 108, 27, 48);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 1, 58, 118, 78, 110, 28, 49);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 1, 59, 120, 79, 112, 28, 49);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 1, 60, 122, 80, 114, 28, 50);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 1, 61, 124, 82, 116, 28, 50);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 1, 62, 126, 83, 118, 29, 51);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 1, 63, 128, 84, 120, 29, 52);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 1, 64, 131, 86, 122, 29, 52);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 1, 65, 133, 87, 124, 30, 53);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 1, 66, 135, 88, 126, 30, 53);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 1, 67, 137, 90, 128, 30, 54);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 1, 68, 139, 91, 130, 30, 55);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 1, 69, 142, 93, 132, 31, 55);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 1, 70, 144, 94, 134, 31, 56);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 1, 71, 147, 95, 136, 31, 57);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 1, 72, 150, 97, 139, 31, 58);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 1, 73, 152, 99, 141, 31, 59);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 1, 74, 155, 100, 144, 32, 59);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 1, 75, 158, 102, 146, 32, 60);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 1, 76, 163, 104, 149, 32, 61);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 1, 77, 167, 106, 152, 33, 62);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 1, 78, 167, 107, 154, 33, 62);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 1, 79, 170, 109, 157, 33, 63);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 1, 80, 173, 111, 160, 34, 64);

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

insert into playercreateinfo_spell (race, class, Spell, Note) values (9, 1, 78, 'Heroic Strike');

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

insert into playercreateinfo_spell (race, class, Spell, Note) values (9, 1, 107, 'Block');

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

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

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

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

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

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

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

insert into playercreateinfo_spell (race, class, Spell, Note) values (9, 1, 2457, 'Battle Stance');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

insert into playercreateinfo_spell (race, class, Spell, Note) values (9, 1, 9116, 'Shield');

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

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

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

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

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

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

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

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

insert into playercreateinfo_spell (race, class, Spell, Note) values (9, 1, 32215, 'Victorious State');

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

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

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

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

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

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

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

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

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

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

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

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

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

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