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

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

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

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

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

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

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 2, 6, 28, 23, 27, 23, 25);

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

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 2, 8, 30, 24, 29, 25, 26);

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

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 2, 10, 32, 25, 32, 26, 27);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 2, 11, 33, 26, 33, 27, 28);

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

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 2, 13, 36, 27, 35, 28, 30);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 2, 14, 37, 28, 36, 29, 31);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 2, 15, 38, 29, 37, 30, 31);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 2, 16, 40, 29, 38, 30, 32);

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

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 2, 18, 42, 31, 41, 32, 34);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 2, 19, 43, 31, 42, 33, 35);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 2, 20, 45, 32, 43, 33, 35);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 2, 21, 46, 33, 45, 34, 36);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 2, 22, 47, 33, 46, 35, 37);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 2, 23, 49, 34, 47, 36, 38);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 2, 24, 50, 35, 48, 37, 39);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 2, 25, 51, 36, 50, 37, 40);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 2, 26, 53, 36, 51, 38, 41);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 2, 27, 54, 37, 52, 39, 42);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 2, 28, 56, 38, 54, 40, 43);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 2, 29, 57, 39, 55, 41, 43);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 2, 30, 58, 39, 56, 42, 44);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 2, 31, 60, 40, 58, 43, 45);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 2, 32, 61, 41, 59, 43, 46);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 2, 33, 63, 42, 60, 44, 47);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 2, 34, 64, 43, 62, 45, 48);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 2, 35, 66, 44, 63, 46, 49);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 2, 36, 67, 44, 65, 47, 50);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 2, 37, 69, 45, 66, 48, 51);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 2, 38, 70, 46, 67, 49, 52);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 2, 39, 72, 47, 69, 50, 53);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 2, 40, 73, 48, 70, 51, 54);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 2, 41, 75, 49, 72, 52, 55);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 2, 42, 77, 49, 73, 53, 56);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 2, 43, 78, 50, 75, 54, 57);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 2, 44, 80, 51, 76, 55, 58);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 2, 45, 81, 52, 78, 56, 59);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 2, 46, 83, 53, 79, 57, 61);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 2, 47, 85, 54, 81, 58, 62);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 2, 48, 86, 55, 83, 59, 63);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 2, 49, 88, 56, 84, 60, 64);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 2, 50, 90, 57, 86, 61, 65);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 2, 51, 91, 58, 87, 62, 66);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 2, 52, 93, 59, 89, 63, 67);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 2, 53, 95, 60, 91, 64, 68);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 2, 54, 97, 61, 92, 65, 69);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 2, 55, 98, 61, 94, 66, 71);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 2, 56, 100, 62, 95, 67, 72);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 2, 57, 102, 63, 97, 68, 73);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 2, 58, 104, 64, 99, 69, 74);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 2, 59, 105, 65, 101, 70, 75);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 2, 60, 107, 66, 102, 71, 77);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 2, 61, 109, 67, 104, 73, 78);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 2, 62, 111, 69, 106, 74, 79);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 2, 63, 113, 70, 107, 75, 80);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 2, 64, 115, 71, 109, 76, 81);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 2, 65, 116, 72, 111, 77, 83);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 2, 66, 118, 73, 113, 78, 84);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 2, 67, 120, 74, 115, 79, 85);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 2, 68, 122, 75, 116, 81, 86);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 2, 69, 124, 76, 118, 82, 88);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 2, 70, 126, 77, 120, 83, 89);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 2, 71, 148, 78, 122, 84, 92);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 2, 72, 150, 79, 125, 86, 94);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 2, 73, 152, 80, 127, 87, 96);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 2, 74, 156, 82, 129, 89, 97);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 2, 75, 158, 83, 131, 90, 99);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 2, 76, 162, 84, 134, 92, 100);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 2, 77, 164, 86, 136, 93, 103);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 2, 78, 167, 87, 138, 95, 105);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 2, 79, 170, 88, 153, 96, 106);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (12, 2, 80, 173, 90, 160, 98, 108);

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

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

insert into playercreateinfo_spell (race, class, Spell, Note) values (12, 2, 107, 'Block');

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

insert into playercreateinfo_spell (race, class, Spell, Note) values (12, 2, 199, 'Two-Handed Maces');

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

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

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

insert into playercreateinfo_spell (race, class, Spell, Note) values (12, 2, 635, 'Holy Light');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

insert into playercreateinfo_spell (race, class, Spell, Note) values (12, 2, 8737, 'Mail');

insert into playercreateinfo_spell (race, class, Spell, Note) values (12, 2, 9077, 'Leather');

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

insert into playercreateinfo_spell (race, class, Spell, Note) values (12, 2, 9116, 'Shield');

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

insert into playercreateinfo_spell (race, class, Spell, Note) values (12, 2, 20154, 'Seal of Righteousness');

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

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

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

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

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

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

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

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

insert into playercreateinfo_spell (race, class, Spell, Note) values (12, 2, 27762, 'Libram');

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

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

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

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

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

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

insert into playercreateinfo_action (race, class, button, action, type) values (12, 2, 0, 6603, 0);

insert into playercreateinfo_action (race, class, button, action, type) values (12, 2, 2, 635, 0);

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

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