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

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

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

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

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

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

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 2, 6, 25, 25, 26, 27, 24);

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

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 2, 8, 27, 26, 28, 29, 25);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 2, 9, 28, 27, 29, 29, 26);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 2, 10, 29, 27, 31, 30, 26);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 2, 11, 30, 28, 32, 31, 27);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 2, 12, 32, 29, 33, 31, 28);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 2, 13, 33, 29, 34, 32, 29);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 2, 14, 34, 30, 35, 33, 30);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 2, 15, 35, 31, 36, 33, 30);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 2, 16, 37, 31, 37, 34, 31);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 2, 17, 38, 32, 39, 35, 32);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 2, 18, 39, 33, 40, 36, 33);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 2, 19, 40, 33, 41, 36, 34);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 2, 20, 42, 34, 42, 37, 35);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 2, 21, 43, 35, 44, 38, 35);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 2, 22, 44, 35, 45, 39, 36);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 2, 23, 46, 36, 46, 40, 37);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 2, 24, 47, 37, 47, 40, 38);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 2, 25, 49, 38, 49, 41, 39);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 2, 26, 50, 38, 50, 42, 40);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 2, 27, 51, 39, 51, 43, 41);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 2, 28, 53, 40, 53, 44, 42);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 2, 29, 54, 41, 54, 45, 43);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 2, 30, 56, 41, 55, 45, 43);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 2, 31, 57, 42, 57, 46, 44);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 2, 32, 58, 43, 58, 47, 45);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 2, 33, 60, 44, 59, 48, 46);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 2, 34, 61, 45, 61, 49, 47);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 2, 35, 63, 45, 62, 50, 48);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 2, 36, 64, 46, 64, 51, 49);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 2, 37, 66, 47, 65, 52, 50);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 2, 38, 67, 48, 67, 53, 51);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 2, 39, 69, 49, 68, 54, 52);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 2, 40, 71, 50, 69, 55, 53);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 2, 41, 72, 50, 71, 55, 54);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 2, 42, 74, 51, 72, 56, 55);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 2, 43, 75, 52, 74, 57, 56);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 2, 44, 77, 53, 75, 58, 57);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 2, 45, 79, 54, 77, 59, 59);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 2, 46, 80, 55, 78, 60, 60);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 2, 47, 82, 56, 80, 61, 61);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 2, 48, 83, 57, 82, 62, 62);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 2, 49, 85, 58, 83, 63, 63);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 2, 50, 87, 59, 85, 64, 64);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 2, 51, 89, 60, 86, 66, 65);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 2, 52, 90, 61, 88, 67, 66);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 2, 53, 92, 61, 90, 68, 67);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 2, 54, 94, 62, 91, 69, 69);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 2, 55, 95, 63, 93, 70, 70);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 2, 56, 97, 64, 95, 71, 71);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 2, 57, 99, 65, 96, 72, 72);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 2, 58, 101, 66, 98, 73, 73);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 2, 59, 102, 67, 100, 74, 74);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 2, 60, 104, 68, 101, 75, 76);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 2, 61, 106, 69, 103, 76, 77);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 2, 62, 108, 70, 105, 78, 78);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 2, 63, 110, 72, 106, 79, 79);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 2, 64, 112, 73, 108, 80, 80);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 2, 65, 113, 74, 110, 81, 82);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 2, 66, 115, 75, 112, 82, 83);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 2, 67, 117, 76, 114, 83, 84);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 2, 68, 119, 77, 115, 85, 85);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 2, 69, 121, 78, 117, 86, 87);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 2, 70, 123, 79, 119, 87, 88);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 2, 71, 125, 80, 120, 88, 89);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 2, 72, 128, 81, 123, 90, 91);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 2, 73, 130, 82, 125, 91, 93);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 2, 74, 133, 84, 127, 93, 94);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 2, 75, 135, 85, 129, 94, 96);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 2, 76, 137, 86, 132, 96, 97);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 2, 77, 140, 88, 134, 97, 99);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 2, 78, 143, 89, 136, 99, 101);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 2, 79, 145, 90, 139, 100, 102);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 2, 80, 148, 92, 141, 102, 104);

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

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

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

insert into playercreateinfo_spell (race, class, Spell, Note) values (5, 2, 201, 'One-Handed Swords');

insert into playercreateinfo_spell (race, class, Spell, Note) values (5, 2, 202, 'Two-Handed Swords');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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