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

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

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 8, 2, 19, 18, 21, 22, 28);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 8, 3, 19, 18, 22, 24, 30);

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

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 8, 5, 19, 19, 22, 26, 32);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 8, 6, 19, 19, 22, 28, 34);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 8, 7, 20, 19, 23, 29, 35);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 8, 8, 20, 19, 23, 31, 36);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 8, 9, 20, 19, 23, 32, 38);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 8, 10, 20, 19, 24, 34, 39);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 8, 11, 20, 20, 24, 35, 40);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 8, 12, 20, 20, 24, 37, 42);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 8, 13, 20, 20, 25, 38, 43);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 8, 14, 20, 20, 25, 40, 45);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 8, 15, 20, 20, 25, 41, 46);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 8, 16, 21, 21, 26, 43, 48);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 8, 17, 21, 21, 26, 44, 49);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 8, 18, 21, 21, 26, 46, 51);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 8, 19, 21, 21, 27, 48, 52);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 8, 20, 21, 21, 27, 49, 54);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 8, 21, 21, 22, 27, 51, 55);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 8, 22, 21, 22, 28, 52, 57);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 8, 23, 21, 22, 28, 54, 58);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 8, 24, 22, 22, 29, 56, 60);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 8, 25, 22, 23, 29, 57, 62);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 8, 26, 22, 23, 29, 59, 63);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 8, 27, 22, 23, 30, 61, 65);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 8, 28, 22, 23, 30, 63, 67);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 8, 29, 22, 24, 31, 64, 68);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 8, 30, 23, 24, 31, 66, 70);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 8, 31, 23, 24, 31, 68, 72);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 8, 32, 23, 24, 32, 70, 73);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 8, 33, 23, 25, 32, 72, 75);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 8, 34, 23, 25, 33, 73, 77);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 8, 35, 24, 25, 33, 75, 79);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 8, 36, 24, 25, 34, 77, 80);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 8, 37, 24, 26, 34, 79, 82);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 8, 38, 24, 26, 35, 81, 84);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 8, 39, 24, 26, 35, 83, 86);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 8, 40, 24, 27, 35, 85, 88);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 8, 41, 25, 27, 36, 87, 90);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 8, 42, 25, 27, 36, 89, 91);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 8, 43, 25, 27, 37, 90, 93);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 8, 44, 25, 28, 37, 92, 95);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 8, 45, 26, 28, 38, 94, 97);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 8, 46, 26, 28, 38, 96, 99);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 8, 47, 26, 29, 39, 98, 101);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 8, 48, 26, 29, 39, 100, 103);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 8, 49, 26, 29, 40, 103, 105);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 8, 50, 27, 30, 40, 105, 107);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 8, 51, 27, 30, 41, 107, 109);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 8, 52, 27, 30, 42, 109, 111);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 8, 53, 27, 31, 42, 111, 113);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 8, 54, 28, 31, 43, 113, 115);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 8, 55, 28, 31, 43, 115, 117);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 8, 56, 28, 32, 44, 117, 119);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 8, 57, 28, 32, 44, 119, 121);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 8, 58, 29, 32, 45, 122, 123);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 8, 59, 29, 33, 45, 124, 126);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 8, 60, 29, 33, 46, 126, 128);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 8, 61, 29, 34, 47, 128, 130);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 8, 62, 30, 34, 47, 131, 132);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 8, 63, 30, 34, 48, 133, 134);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 8, 64, 30, 35, 48, 135, 136);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 8, 65, 31, 35, 49, 137, 139);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 8, 66, 31, 35, 50, 140, 141);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 8, 67, 31, 36, 50, 142, 143);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 8, 68, 31, 36, 51, 144, 145);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 8, 69, 32, 37, 51, 147, 148);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 8, 70, 32, 37, 52, 149, 150);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 8, 71, 32, 37, 53, 152, 153);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 8, 72, 32, 38, 54, 155, 156);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 8, 73, 32, 38, 55, 158, 159);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 8, 74, 33, 39, 55, 161, 161);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 8, 75, 33, 39, 56, 164, 164);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 8, 76, 33, 39, 57, 167, 167);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 8, 77, 34, 40, 58, 170, 170);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 8, 78, 34, 40, 58, 173, 173);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 8, 79, 34, 41, 59, 176, 176);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (9, 8, 80, 35, 41, 60, 179, 179);

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

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

insert into playercreateinfo_spell (race, class, Spell, Note) values (9, 8, 133, 'Fireball');

insert into playercreateinfo_spell (race, class, Spell, Note) values (9, 8, 168, 'Frost Armor');

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

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

insert into playercreateinfo_spell (race, class, Spell, Note) values (9, 8, 227, 'Staves');

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

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

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

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

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

insert into playercreateinfo_spell (race, class, Spell, Note) values (9, 8, 5009, 'Wands');

insert into playercreateinfo_spell (race, class, Spell, Note) values (9, 8, 5019, 'Shoot');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

insert into playercreateinfo_spell (race, class, Spell, Note) values (9, 8, 71761, 'Deep Freeze Immunity State');

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

insert into playercreateinfo_action (race, class, button, action, type) values (9, 8, 0, 133, 0);

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

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