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

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

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 9, 2, 17, 22, 21, 27, 22);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 9, 3, 18, 23, 21, 28, 23);

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

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 9, 5, 18, 23, 22, 31, 26);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 9, 6, 18, 24, 23, 32, 27);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 9, 7, 19, 24, 23, 33, 28);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 9, 8, 19, 25, 24, 34, 29);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 9, 9, 19, 25, 25, 36, 30);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 9, 10, 20, 25, 25, 37, 32);

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

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

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 9, 13, 21, 27, 27, 41, 36);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 9, 14, 21, 27, 28, 42, 37);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 9, 15, 21, 27, 28, 43, 38);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 9, 16, 22, 28, 29, 45, 39);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 9, 17, 22, 28, 30, 46, 41);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 9, 18, 23, 29, 30, 47, 42);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 9, 19, 23, 29, 31, 49, 43);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 9, 20, 23, 30, 32, 50, 45);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 9, 21, 24, 30, 32, 51, 46);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 9, 22, 24, 31, 33, 53, 48);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 9, 23, 24, 31, 34, 54, 49);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 9, 24, 25, 31, 34, 56, 50);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 9, 25, 25, 32, 35, 57, 52);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 9, 26, 26, 32, 36, 59, 53);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 9, 27, 26, 33, 37, 60, 55);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 9, 28, 26, 33, 37, 62, 56);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 9, 29, 27, 34, 38, 63, 58);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 9, 30, 27, 34, 39, 65, 59);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 9, 31, 28, 35, 40, 66, 61);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 9, 32, 28, 36, 40, 68, 62);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 9, 33, 29, 36, 41, 69, 64);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 9, 34, 29, 37, 42, 71, 65);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 9, 35, 29, 37, 43, 73, 67);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 9, 36, 30, 38, 43, 74, 69);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 9, 37, 30, 38, 44, 76, 70);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 9, 38, 31, 39, 45, 77, 72);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 9, 39, 31, 39, 46, 79, 73);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 9, 40, 32, 40, 47, 81, 75);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 9, 41, 32, 41, 48, 82, 77);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 9, 42, 33, 41, 48, 84, 78);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 9, 43, 33, 42, 49, 86, 80);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 9, 44, 34, 42, 50, 88, 82);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 9, 45, 34, 43, 51, 89, 83);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 9, 46, 35, 44, 52, 91, 85);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 9, 47, 35, 44, 53, 93, 87);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 9, 48, 36, 45, 54, 95, 89);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 9, 49, 36, 45, 54, 96, 90);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 9, 50, 37, 46, 55, 98, 92);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 9, 51, 37, 47, 56, 100, 94);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 9, 52, 38, 47, 57, 102, 96);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 9, 53, 38, 48, 58, 104, 97);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 9, 54, 39, 49, 59, 105, 99);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 9, 55, 39, 49, 60, 107, 101);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 9, 56, 40, 50, 61, 109, 103);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 9, 57, 40, 51, 62, 111, 105);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 9, 58, 41, 51, 63, 113, 107);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 9, 59, 42, 52, 64, 115, 108);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 9, 60, 42, 53, 65, 117, 110);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 9, 61, 43, 53, 66, 119, 112);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 9, 62, 43, 54, 67, 121, 114);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 9, 63, 44, 55, 68, 123, 116);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 9, 64, 44, 56, 69, 125, 118);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 9, 65, 45, 56, 70, 127, 120);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 9, 66, 46, 57, 71, 129, 122);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 9, 67, 46, 58, 72, 131, 124);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 9, 68, 47, 58, 73, 133, 126);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 9, 69, 47, 59, 74, 135, 128);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 9, 70, 48, 60, 75, 137, 130);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 9, 71, 49, 61, 83, 139, 141);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 9, 72, 50, 61, 84, 142, 143);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 9, 73, 51, 62, 84, 144, 146);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 9, 74, 51, 63, 86, 147, 149);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 9, 75, 52, 64, 89, 149, 151);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 9, 76, 53, 65, 90, 155, 154);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 9, 77, 54, 66, 91, 155, 157);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 9, 78, 54, 67, 93, 157, 160);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 9, 79, 55, 68, 94, 160, 163);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (4, 9, 80, 56, 69, 95, 163, 165);

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

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

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

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

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

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

insert into playercreateinfo_spell (race, class, Spell, Note) values (4, 9, 686, 'Shadow Bolt');

insert into playercreateinfo_spell (race, class, Spell, Note) values (4, 9, 687, 'Demon Skin');

insert into playercreateinfo_spell (race, class, Spell, Note) values (4, 9, 813, 'Language Thalassian');

insert into playercreateinfo_spell (race, class, Spell, Note) values (4, 9, 822, 'Magic Resistance');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

insert into playercreateinfo_spell (race, class, Spell, Note) values (4, 9, 18822, 'Improved Enslave Demon');

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

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

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

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

insert into playercreateinfo_spell (race, class, Spell, Note) values (4, 9, 28730, 'Arcane Torrent');

insert into playercreateinfo_spell (race, class, Spell, Note) values (4, 9, 28877, 'Arcane Affinity');

insert into playercreateinfo_spell (race, class, Spell, Note) values (4, 9, 58284, 'Chaos Bolt Passive');

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

insert into playercreateinfo_spell (race, class, Spell, Note) values (4, 9, 75445, 'Demonic Immolate');

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

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

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

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

insert into playercreateinfo_action (race, class, button, action, type) values (4, 9, 3, 28730, 0);

insert into playercreateinfo_action (race, class, button, action, type) values (4, 9, 11, 20857, 128);