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

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

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 9, 2, 20, 20, 22, 23, 23);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 9, 3, 21, 21, 22, 24, 24);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 9, 4, 21, 21, 23, 26, 25);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 9, 5, 21, 21, 23, 27, 27);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 9, 6, 21, 22, 24, 28, 28);

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

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

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

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 9, 10, 23, 23, 26, 33, 33);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 9, 11, 23, 24, 27, 34, 34);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 9, 12, 23, 24, 27, 35, 35);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 9, 13, 24, 25, 28, 37, 36);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 9, 14, 24, 25, 29, 38, 38);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 9, 15, 24, 25, 29, 39, 39);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 9, 16, 25, 26, 30, 41, 40);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 9, 17, 25, 26, 31, 42, 42);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 9, 18, 25, 27, 31, 43, 43);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 9, 19, 26, 27, 32, 45, 44);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 9, 20, 26, 28, 33, 46, 46);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 9, 21, 26, 28, 33, 48, 47);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 9, 22, 27, 29, 34, 49, 49);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 9, 23, 27, 29, 35, 51, 50);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 9, 24, 28, 30, 35, 52, 51);

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

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 9, 26, 28, 31, 37, 55, 54);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 9, 27, 29, 31, 37, 56, 56);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 9, 28, 29, 32, 38, 58, 57);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 9, 29, 30, 32, 39, 59, 59);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 9, 30, 30, 33, 40, 61, 60);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 9, 31, 30, 33, 40, 62, 62);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 9, 32, 31, 34, 41, 64, 63);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 9, 33, 31, 34, 42, 66, 65);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 9, 34, 32, 35, 43, 67, 66);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 9, 35, 32, 35, 44, 69, 68);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 9, 36, 33, 36, 44, 70, 69);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 9, 37, 33, 36, 45, 72, 71);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 9, 38, 34, 37, 46, 74, 73);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 9, 39, 34, 38, 47, 75, 74);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 9, 40, 35, 38, 48, 77, 76);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 9, 41, 35, 39, 48, 79, 78);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 9, 42, 35, 39, 49, 80, 79);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 9, 43, 36, 40, 50, 82, 81);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 9, 44, 36, 40, 51, 84, 83);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 9, 45, 37, 41, 52, 85, 84);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 9, 46, 37, 42, 53, 87, 86);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 9, 47, 38, 42, 54, 89, 88);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 9, 48, 38, 43, 55, 91, 89);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 9, 49, 39, 44, 55, 93, 91);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 9, 50, 40, 44, 56, 94, 93);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 9, 51, 40, 45, 57, 96, 95);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 9, 52, 41, 45, 58, 98, 97);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 9, 53, 41, 46, 59, 100, 98);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 9, 54, 42, 47, 60, 102, 100);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 9, 55, 42, 47, 61, 103, 102);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 9, 56, 43, 48, 62, 105, 104);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 9, 57, 43, 49, 63, 107, 106);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 9, 58, 44, 49, 64, 109, 108);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 9, 59, 44, 50, 65, 111, 109);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 9, 60, 45, 51, 66, 113, 111);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 9, 61, 46, 51, 67, 115, 113);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 9, 62, 46, 52, 68, 117, 115);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 9, 63, 47, 53, 69, 119, 117);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 9, 64, 47, 54, 70, 121, 119);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 9, 65, 48, 54, 71, 123, 121);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 9, 66, 49, 55, 72, 125, 123);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 9, 67, 49, 56, 73, 127, 125);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 9, 68, 50, 57, 74, 129, 127);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 9, 69, 50, 57, 75, 131, 129);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 9, 70, 51, 58, 76, 133, 131);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 9, 71, 52, 59, 78, 135, 146);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 9, 72, 53, 59, 79, 138, 148);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 9, 73, 54, 60, 80, 140, 151);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 9, 74, 54, 61, 89, 143, 154);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 9, 75, 55, 62, 91, 145, 156);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 9, 76, 56, 63, 92, 148, 159);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 9, 77, 57, 64, 93, 151, 162);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 9, 78, 57, 65, 95, 153, 165);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 9, 79, 58, 66, 96, 156, 168);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 9, 80, 59, 67, 97, 159, 170);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

insert into playercreateinfo_spell (race, class, Spell, Note) values (12, 9, 20599, 'Diplomacy');

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

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

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

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

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

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

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

insert into playercreateinfo_spell (race, class, Spell, Note) values (12, 9, 58985, 'Perception');

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

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

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

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

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

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

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

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

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