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

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

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

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

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

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

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (7, 5, 6, 21, 21, 22, 29, 30);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (7, 5, 7, 21, 21, 22, 30, 31);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (7, 5, 8, 21, 22, 23, 31, 33);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (7, 5, 9, 21, 22, 23, 33, 34);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (7, 5, 10, 21, 22, 23, 34, 36);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (7, 5, 11, 22, 22, 24, 36, 37);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (7, 5, 12, 22, 23, 24, 37, 39);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (7, 5, 13, 22, 23, 25, 38, 40);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (7, 5, 14, 22, 23, 25, 40, 42);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (7, 5, 15, 22, 23, 25, 41, 43);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (7, 5, 16, 23, 24, 26, 43, 45);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (7, 5, 17, 23, 24, 26, 44, 46);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (7, 5, 18, 23, 24, 27, 46, 48);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (7, 5, 19, 23, 24, 27, 47, 49);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (7, 5, 20, 23, 25, 28, 49, 51);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (7, 5, 21, 24, 25, 28, 51, 53);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (7, 5, 22, 24, 25, 29, 52, 54);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (7, 5, 23, 24, 26, 29, 54, 56);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (7, 5, 24, 24, 26, 30, 55, 58);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (7, 5, 25, 25, 26, 30, 57, 59);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (7, 5, 26, 25, 27, 31, 59, 61);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (7, 5, 27, 25, 27, 31, 60, 63);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (7, 5, 28, 25, 27, 32, 62, 65);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (7, 5, 29, 25, 28, 32, 64, 66);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (7, 5, 30, 26, 28, 33, 65, 68);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (7, 5, 31, 26, 28, 33, 67, 70);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (7, 5, 32, 26, 29, 34, 69, 72);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (7, 5, 33, 27, 29, 34, 70, 73);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (7, 5, 34, 27, 29, 35, 72, 75);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (7, 5, 35, 27, 30, 35, 74, 77);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (7, 5, 36, 27, 30, 36, 76, 79);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (7, 5, 37, 28, 30, 36, 78, 81);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (7, 5, 38, 28, 31, 37, 79, 83);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (7, 5, 39, 28, 31, 38, 81, 85);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (7, 5, 40, 28, 31, 38, 83, 87);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (7, 5, 41, 29, 32, 39, 85, 88);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (7, 5, 42, 29, 32, 39, 87, 90);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (7, 5, 43, 29, 33, 40, 89, 92);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (7, 5, 44, 30, 33, 40, 91, 94);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (7, 5, 45, 30, 33, 41, 92, 96);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (7, 5, 46, 30, 34, 42, 94, 98);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (7, 5, 47, 31, 34, 42, 96, 100);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (7, 5, 48, 31, 35, 43, 98, 102);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (7, 5, 49, 31, 35, 44, 100, 104);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (7, 5, 50, 32, 36, 44, 102, 106);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (7, 5, 51, 32, 36, 45, 104, 109);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (7, 5, 52, 32, 36, 45, 106, 111);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (7, 5, 53, 33, 37, 46, 108, 113);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (7, 5, 54, 33, 37, 47, 110, 115);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (7, 5, 55, 33, 38, 47, 112, 117);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (7, 5, 56, 34, 38, 48, 114, 119);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (7, 5, 57, 34, 39, 49, 117, 121);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (7, 5, 58, 34, 39, 49, 119, 124);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (7, 5, 59, 35, 40, 50, 121, 126);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (7, 5, 60, 35, 40, 51, 123, 128);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (7, 5, 61, 35, 41, 51, 125, 130);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (7, 5, 62, 36, 41, 52, 127, 132);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (7, 5, 63, 36, 41, 53, 129, 135);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (7, 5, 64, 37, 42, 54, 132, 137);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (7, 5, 65, 37, 42, 54, 134, 139);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (7, 5, 66, 37, 43, 55, 136, 142);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (7, 5, 67, 38, 43, 56, 138, 144);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (7, 5, 68, 38, 44, 57, 140, 146);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (7, 5, 69, 39, 44, 57, 143, 149);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (7, 5, 70, 39, 45, 58, 145, 151);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (7, 5, 71, 39, 46, 59, 148, 158);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (7, 5, 72, 40, 46, 59, 151, 161);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (7, 5, 73, 40, 47, 60, 154, 164);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (7, 5, 74, 41, 47, 61, 156, 167);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (7, 5, 75, 41, 48, 62, 159, 170);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (7, 5, 76, 41, 49, 63, 162, 174);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (7, 5, 77, 42, 49, 64, 165, 177);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (7, 5, 78, 42, 50, 65, 168, 180);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (7, 5, 79, 43, 50, 66, 171, 183);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (7, 5, 80, 43, 51, 67, 174, 186);

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

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

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

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

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

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

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

insert into playercreateinfo_spell (race, class, Spell, Note) values (7, 5, 585, 'Smite');

insert into playercreateinfo_spell (race, class, Spell, Note) values (7, 5, 2050, 'Lesser Heal');

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

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

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

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

insert into playercreateinfo_spell (race, class, Spell, Note) values (7, 5, 5009, 'Wands');

insert into playercreateinfo_spell (race, class, Spell, Note) values (7, 5, 5019, 'Shoot');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

insert into playercreateinfo_spell (race, class, Spell, Note) values (7, 5, 20599, 'Diplomacy');

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

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

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

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

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

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

insert into playercreateinfo_spell (race, class, Spell, Note) values (7, 5, 58985, 'Perception');

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

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

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

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

insert into playercreateinfo_action (race, class, button, action, type) values (7, 5, 0, 585, 0);

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

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