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

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 1, 1, 23, 20, 22, 20, 20);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 1, 2, 24, 21, 23, 20, 20);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 1, 3, 26, 22, 24, 20, 21);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 1, 4, 27, 22, 26, 20, 21);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 1, 5, 28, 23, 27, 20, 21);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 1, 6, 30, 24, 28, 20, 21);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 1, 7, 31, 25, 29, 21, 22);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 1, 8, 32, 26, 30, 21, 22);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 1, 9, 34, 26, 32, 21, 22);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 1, 10, 35, 27, 33, 21, 23);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 1, 11, 36, 28, 34, 21, 23);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 1, 12, 38, 29, 35, 21, 23);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 1, 13, 39, 30, 37, 21, 24);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 1, 14, 41, 31, 38, 21, 24);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 1, 15, 42, 32, 39, 21, 24);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 1, 16, 44, 33, 41, 21, 25);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 1, 17, 45, 34, 42, 22, 25);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 1, 18, 47, 34, 43, 22, 25);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 1, 19, 48, 35, 45, 22, 26);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 1, 20, 50, 36, 46, 22, 26);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 1, 21, 51, 37, 48, 22, 26);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 1, 22, 53, 38, 49, 22, 27);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 1, 23, 54, 39, 51, 22, 27);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 1, 24, 56, 40, 52, 23, 28);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 1, 25, 58, 41, 53, 23, 28);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 1, 26, 59, 42, 55, 23, 28);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 1, 27, 61, 43, 56, 23, 29);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 1, 28, 63, 44, 58, 23, 29);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 1, 29, 64, 45, 59, 23, 30);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 1, 30, 66, 46, 61, 24, 30);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 1, 31, 68, 47, 62, 24, 30);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 1, 32, 69, 48, 64, 24, 31);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 1, 33, 71, 50, 66, 24, 31);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 1, 34, 73, 51, 67, 24, 32);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 1, 35, 74, 52, 69, 24, 32);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 1, 36, 76, 53, 70, 25, 33);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 1, 37, 78, 54, 72, 25, 33);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 1, 38, 80, 55, 74, 25, 34);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 1, 39, 82, 56, 75, 25, 34);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 1, 40, 83, 57, 77, 25, 35);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 1, 41, 85, 58, 79, 26, 35);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 1, 42, 87, 60, 80, 26, 35);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 1, 43, 89, 61, 82, 26, 36);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 1, 44, 91, 62, 84, 26, 36);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 1, 45, 93, 63, 85, 26, 37);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 1, 46, 95, 64, 87, 27, 37);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 1, 47, 97, 66, 89, 27, 38);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 1, 48, 99, 67, 91, 27, 38);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 1, 49, 101, 68, 93, 27, 39);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 1, 50, 103, 69, 94, 28, 40);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 1, 51, 105, 71, 96, 28, 40);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 1, 52, 107, 72, 98, 28, 41);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 1, 53, 109, 73, 100, 28, 41);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 1, 54, 111, 74, 102, 29, 42);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 1, 55, 113, 76, 103, 29, 42);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 1, 56, 115, 77, 105, 29, 43);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 1, 57, 117, 78, 107, 29, 43);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 1, 58, 119, 79, 109, 30, 44);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 1, 59, 121, 81, 111, 30, 44);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 1, 60, 123, 82, 113, 30, 45);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 1, 61, 125, 83, 115, 30, 46);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 1, 62, 127, 85, 117, 31, 46);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 1, 63, 129, 86, 119, 31, 47);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 1, 64, 132, 88, 121, 31, 47);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 1, 65, 134, 89, 123, 32, 48);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 1, 66, 136, 90, 125, 32, 49);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 1, 67, 138, 92, 127, 32, 49);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 1, 68, 140, 93, 129, 32, 50);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 1, 69, 143, 95, 131, 33, 50);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 1, 70, 145, 96, 133, 33, 51);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 1, 71, 148, 97, 140, 33, 53);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 1, 72, 156, 99, 143, 33, 54);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 1, 73, 162, 101, 148, 33, 55);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 1, 74, 162, 102, 148, 34, 55);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 1, 75, 165, 104, 150, 34, 56);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 1, 76, 171, 106, 156, 34, 57);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 1, 77, 171, 108, 157, 35, 58);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 1, 78, 174, 109, 159, 35, 58);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 1, 79, 181, 111, 165, 35, 59);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 1, 80, 184, 113, 168, 36, 60);

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

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

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

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

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

insert into playercreateinfo_spell (race, class, Spell, Note) values (10, 1, 198, 'One-Handed Maces');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

insert into playercreateinfo_spell (race, class, Spell, Note) values (10, 1, 20597, 'Sword Specialization');

insert into playercreateinfo_spell (race, class, Spell, Note) values (10, 1, 20598, 'The Human Spirit');

insert into playercreateinfo_spell (race, class, Spell, Note) values (10, 1, 20599, 'Diplomacy');

insert into playercreateinfo_spell (race, class, Spell, Note) values (10, 1, 20864, 'Mace Specialization');

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

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

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

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

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

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

insert into playercreateinfo_spell (race, class, Spell, Note) values (10, 1, 58985, 'Perception');

insert into playercreateinfo_spell (race, class, Spell, Note) values (10, 1, 59752, 'Every Man for Himself');

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

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

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

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

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

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

insert into playercreateinfo_action (race, class, button, action, type) values (10, 1, 82, 59752, 0);

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

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

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

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

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