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

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 3, 1, 17, 25, 20, 24, 20);

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

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

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

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 3, 5, 19, 30, 24, 26, 23);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 3, 6, 19, 32, 25, 27, 23);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 3, 7, 20, 33, 26, 27, 24);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 3, 8, 20, 35, 27, 28, 25);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 3, 9, 21, 36, 27, 29, 25);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 3, 10, 21, 38, 28, 29, 26);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 3, 11, 22, 39, 29, 30, 27);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 3, 12, 22, 41, 30, 31, 27);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 3, 13, 23, 42, 31, 31, 28);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 3, 14, 23, 44, 32, 32, 29);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 3, 15, 24, 45, 34, 32, 29);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 3, 16, 24, 47, 35, 33, 30);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 3, 17, 25, 48, 36, 34, 31);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 3, 18, 25, 50, 37, 34, 32);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 3, 19, 26, 51, 38, 35, 32);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 3, 20, 26, 53, 39, 36, 33);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 3, 21, 27, 55, 40, 37, 34);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 3, 22, 27, 56, 41, 37, 35);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 3, 23, 28, 58, 42, 38, 36);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 3, 24, 28, 60, 43, 39, 36);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 3, 25, 29, 61, 44, 39, 37);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 3, 26, 30, 63, 46, 40, 38);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 3, 27, 30, 65, 47, 41, 39);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 3, 28, 31, 66, 48, 42, 40);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 3, 29, 31, 68, 49, 42, 40);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 3, 30, 32, 70, 50, 43, 41);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 3, 31, 33, 72, 52, 44, 42);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 3, 32, 33, 73, 53, 45, 43);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 3, 33, 34, 75, 54, 46, 44);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 3, 34, 34, 77, 55, 46, 45);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 3, 35, 35, 79, 57, 47, 46);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 3, 36, 36, 81, 58, 48, 47);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 3, 37, 36, 83, 59, 49, 47);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 3, 38, 37, 85, 60, 50, 48);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 3, 39, 38, 86, 62, 51, 49);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 3, 40, 38, 88, 63, 51, 50);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 3, 41, 39, 90, 64, 52, 51);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 3, 42, 40, 92, 66, 53, 52);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 3, 43, 40, 94, 67, 54, 53);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 3, 44, 41, 96, 68, 55, 54);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 3, 45, 42, 98, 70, 56, 55);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 3, 46, 42, 100, 71, 57, 56);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 3, 47, 43, 102, 72, 58, 57);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 3, 48, 44, 104, 74, 59, 58);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 3, 49, 45, 106, 75, 60, 59);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 3, 50, 45, 108, 77, 61, 60);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 3, 51, 46, 110, 78, 61, 61);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 3, 52, 47, 113, 79, 62, 62);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 3, 53, 47, 115, 81, 63, 63);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 3, 54, 48, 117, 82, 64, 64);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 3, 55, 49, 119, 84, 65, 65);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 3, 56, 50, 121, 85, 66, 66);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 3, 57, 50, 123, 87, 67, 67);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 3, 58, 51, 126, 88, 68, 68);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 3, 59, 52, 128, 90, 69, 70);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 3, 60, 53, 130, 91, 70, 71);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 3, 61, 54, 132, 93, 71, 72);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 3, 62, 54, 134, 94, 72, 73);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 3, 63, 55, 137, 96, 73, 74);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 3, 64, 56, 139, 97, 75, 75);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 3, 65, 57, 141, 99, 76, 76);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 3, 66, 58, 144, 101, 77, 77);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 3, 67, 58, 146, 102, 78, 78);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 3, 68, 59, 148, 104, 79, 80);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 3, 69, 60, 151, 105, 80, 81);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 3, 70, 61, 153, 107, 81, 82);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 3, 71, 62, 156, 108, 82, 83);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 3, 72, 63, 159, 110, 83, 84);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 3, 73, 64, 162, 112, 84, 86);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 3, 74, 65, 165, 114, 86, 87);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 3, 75, 66, 168, 116, 87, 89);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 3, 76, 67, 171, 118, 89, 90);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 3, 77, 68, 174, 120, 90, 92);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 3, 78, 69, 177, 122, 91, 93);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 3, 79, 70, 180, 124, 92, 95);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (5, 3, 80, 71, 183, 126, 94, 96);

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

insert into playercreateinfo_spell (race, class, Spell, Note) values (5, 3, 75, 'Auto Shot');

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

insert into playercreateinfo_spell (race, class, Spell, Note) values (5, 3, 197, 'Two-Handed Axes');

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

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

insert into playercreateinfo_spell (race, class, Spell, Note) values (5, 3, 264, 'Bows');

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

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

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

insert into playercreateinfo_spell (race, class, Spell, Note) values (5, 3, 1180, 'Daggers');

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

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

insert into playercreateinfo_spell (race, class, Spell, Note) values (5, 3, 2973, 'Raptor Strike');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

insert into playercreateinfo_spell (race, class, Spell, Note) values (5, 3, 13358, 'Defensive State (DND)');

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

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

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

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

insert into playercreateinfo_spell (race, class, Spell, Note) values (5, 3, 24949, 'Defensive State 2 (DND)');

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

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

insert into playercreateinfo_spell (race, class, Spell, Note) values (5, 3, 34082, 'Advantaged State (DND)');

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

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

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

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

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

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

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