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

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

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 7, 2, 23, 22, 23, 18, 24);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 7, 3, 24, 23, 24, 19, 25);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 7, 4, 25, 23, 25, 20, 26);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 7, 5, 25, 24, 26, 21, 27);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 7, 6, 26, 24, 27, 22, 28);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 7, 7, 27, 25, 28, 23, 29);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 7, 8, 28, 25, 29, 24, 30);

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

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 7, 10, 30, 26, 31, 26, 33);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 7, 11, 31, 26, 32, 27, 34);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 7, 12, 32, 27, 33, 28, 35);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 7, 13, 33, 27, 34, 29, 36);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 7, 14, 34, 28, 35, 30, 37);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 7, 15, 34, 28, 36, 31, 38);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 7, 16, 35, 29, 38, 32, 39);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 7, 17, 36, 29, 39, 33, 41);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 7, 18, 37, 30, 40, 34, 42);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 7, 19, 38, 30, 41, 35, 43);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 7, 20, 39, 31, 42, 36, 44);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 7, 21, 40, 32, 43, 37, 45);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 7, 22, 41, 32, 45, 38, 47);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 7, 23, 43, 33, 46, 39, 48);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 7, 24, 44, 33, 47, 40, 49);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 7, 25, 45, 34, 48, 42, 51);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 7, 26, 46, 34, 49, 43, 52);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 7, 27, 47, 35, 51, 44, 53);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 7, 28, 48, 35, 52, 45, 54);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 7, 29, 49, 36, 53, 46, 56);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 7, 30, 50, 37, 54, 48, 57);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 7, 31, 51, 37, 56, 49, 59);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 7, 32, 52, 38, 57, 50, 60);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 7, 33, 53, 38, 58, 51, 61);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 7, 34, 55, 39, 60, 52, 63);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 7, 35, 56, 40, 61, 54, 64);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 7, 36, 57, 40, 62, 55, 66);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 7, 37, 58, 41, 64, 56, 67);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 7, 38, 59, 42, 65, 57, 68);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 7, 39, 61, 42, 66, 59, 70);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 7, 40, 62, 43, 68, 60, 71);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 7, 41, 63, 44, 69, 61, 73);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 7, 42, 64, 44, 71, 63, 74);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 7, 43, 65, 45, 72, 64, 76);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 7, 44, 67, 46, 74, 65, 77);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 7, 45, 68, 46, 75, 67, 79);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 7, 46, 69, 47, 76, 68, 80);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 7, 47, 71, 48, 78, 69, 82);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 7, 48, 72, 49, 79, 71, 83);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 7, 49, 73, 49, 81, 72, 85);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 7, 50, 74, 50, 82, 74, 87);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 7, 51, 76, 51, 84, 75, 88);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 7, 52, 77, 51, 85, 77, 90);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 7, 53, 78, 52, 87, 78, 92);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 7, 54, 80, 53, 89, 79, 93);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 7, 55, 81, 54, 90, 81, 95);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 7, 56, 83, 55, 92, 82, 96);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 7, 57, 84, 55, 93, 84, 98);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 7, 58, 85, 56, 95, 85, 100);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 7, 59, 87, 57, 97, 87, 102);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 7, 60, 88, 58, 98, 88, 103);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 7, 61, 90, 58, 100, 90, 105);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 7, 62, 91, 59, 101, 91, 107);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 7, 63, 93, 60, 103, 93, 108);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 7, 64, 94, 61, 105, 94, 110);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 7, 65, 95, 62, 106, 96, 112);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 7, 66, 97, 63, 108, 98, 114);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 7, 67, 98, 63, 110, 99, 116);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 7, 68, 100, 64, 112, 101, 117);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 7, 69, 101, 65, 113, 102, 119);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 7, 70, 103, 66, 115, 104, 121);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 7, 71, 104, 67, 117, 116, 123);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 7, 72, 106, 68, 119, 118, 126);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 7, 73, 108, 69, 121, 121, 128);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 7, 74, 110, 70, 124, 123, 130);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 7, 75, 112, 71, 126, 125, 132);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 7, 76, 114, 72, 128, 127, 135);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 7, 77, 115, 73, 130, 129, 137);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 7, 78, 117, 74, 132, 132, 139);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 7, 79, 119, 75, 135, 134, 142);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (10, 7, 80, 121, 76, 137, 136, 144);

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

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

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

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

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

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

insert into playercreateinfo_spell (race, class, Spell, Note) values (10, 7, 227, 'Staves');

insert into playercreateinfo_spell (race, class, Spell, Note) values (10, 7, 331, 'Healing Wave');

insert into playercreateinfo_spell (race, class, Spell, Note) values (10, 7, 403, 'Lightning Bolt');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

insert into playercreateinfo_spell (race, class, Spell, Note) values (10, 7, 20555, 'Regeneration');

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

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

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

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

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

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

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

insert into playercreateinfo_spell (race, class, Spell, Note) values (10, 7, 26297, 'Berserking');

insert into playercreateinfo_spell (race, class, Spell, Note) values (10, 7, 27763, 'Totem');

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

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

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

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

insert into playercreateinfo_spell (race, class, Spell, Note) values (10, 7, 75461, 'Flame Shock Passive');

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

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

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

insert into playercreateinfo_action (race, class, button, action, type) values (10, 7, 2, 331, 0);

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