delete from player_levelstats where race=1 and class=7;

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

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

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 7, 3, 24, 18, 22, 24, 26);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 7, 4, 25, 18, 23, 25, 27);

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

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 7, 6, 26, 19, 25, 27, 29);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 7, 7, 27, 20, 26, 28, 30);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 7, 8, 28, 20, 27, 28, 31);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 7, 9, 29, 21, 28, 29, 32);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 7, 10, 30, 21, 29, 30, 33);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 7, 11, 31, 22, 30, 31, 35);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 7, 12, 32, 22, 31, 32, 36);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 7, 13, 33, 23, 32, 33, 37);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 7, 14, 34, 23, 33, 34, 38);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 7, 15, 34, 24, 35, 35, 39);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 7, 16, 35, 24, 36, 36, 40);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 7, 17, 36, 25, 37, 38, 42);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 7, 18, 37, 25, 38, 39, 43);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 7, 19, 38, 26, 39, 40, 44);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 7, 20, 39, 26, 40, 41, 45);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 7, 21, 40, 27, 41, 42, 46);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 7, 22, 41, 27, 43, 43, 48);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 7, 23, 43, 28, 44, 44, 49);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 7, 24, 44, 28, 45, 45, 50);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 7, 25, 45, 29, 46, 46, 51);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 7, 26, 46, 30, 47, 48, 53);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 7, 27, 47, 30, 49, 49, 54);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 7, 28, 48, 31, 50, 50, 55);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 7, 29, 49, 31, 51, 51, 57);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 7, 30, 50, 32, 53, 52, 58);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 7, 31, 51, 33, 54, 53, 59);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 7, 32, 52, 33, 55, 55, 61);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 7, 33, 53, 34, 56, 56, 62);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 7, 34, 55, 34, 58, 57, 64);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 7, 35, 56, 35, 59, 58, 65);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 7, 36, 57, 36, 60, 60, 66);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 7, 37, 58, 36, 62, 61, 68);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 7, 38, 59, 37, 63, 62, 69);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 7, 39, 61, 38, 65, 63, 71);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 7, 40, 62, 38, 66, 65, 72);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 7, 41, 63, 39, 67, 66, 74);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 7, 42, 64, 40, 69, 67, 75);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 7, 43, 65, 40, 70, 69, 77);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 7, 44, 67, 41, 72, 70, 78);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 7, 45, 68, 42, 73, 71, 80);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 7, 46, 69, 42, 75, 73, 81);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 7, 47, 71, 43, 76, 74, 83);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 7, 48, 72, 44, 78, 76, 84);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 7, 49, 73, 45, 79, 77, 86);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 7, 50, 74, 45, 81, 78, 88);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 7, 51, 76, 46, 82, 80, 89);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 7, 52, 77, 47, 84, 81, 91);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 7, 53, 78, 47, 85, 83, 92);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 7, 54, 80, 48, 87, 84, 94);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 7, 55, 81, 49, 88, 86, 96);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 7, 56, 83, 50, 90, 87, 97);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 7, 57, 84, 50, 91, 89, 99);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 7, 58, 85, 51, 93, 90, 101);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 7, 59, 87, 52, 95, 92, 102);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 7, 60, 88, 53, 96, 93, 104);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 7, 61, 90, 54, 98, 95, 106);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 7, 62, 91, 54, 99, 96, 108);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 7, 63, 93, 55, 101, 98, 109);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 7, 64, 94, 56, 103, 99, 111);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 7, 65, 95, 57, 104, 101, 113);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 7, 66, 97, 58, 106, 103, 115);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 7, 67, 98, 58, 108, 104, 117);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 7, 68, 100, 59, 110, 106, 118);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 7, 69, 101, 60, 111, 107, 120);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 7, 70, 103, 61, 113, 109, 122);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 7, 71, 104, 62, 115, 122, 124);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 7, 72, 106, 63, 117, 124, 127);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 7, 73, 108, 64, 119, 126, 129);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 7, 74, 110, 65, 122, 128, 131);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 7, 75, 112, 66, 124, 130, 133);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 7, 76, 114, 67, 126, 133, 136);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 7, 77, 115, 68, 128, 135, 138);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 7, 78, 117, 69, 130, 137, 140);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 7, 79, 119, 70, 133, 139, 143);

insert into player_levelstats (race, class, level, str, agi, sta, inte, spi) values (1, 7, 80, 121, 71, 135, 141, 145);

delete from playercreateinfo_spell where race=1 and class=7;

insert into playercreateinfo_spell (race, class, Spell, Note) values (1, 7, 81, 'Dodge');

insert into playercreateinfo_spell (race, class, Spell, Note) values (1, 7, 107, 'Block');

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

insert into playercreateinfo_spell (race, class, Spell, Note) values (1, 7, 203, 'Unarmed');

insert into playercreateinfo_spell (race, class, Spell, Note) values (1, 7, 204, 'Defense');

insert into playercreateinfo_spell (race, class, Spell, Note) values (1, 7, 227, 'Staves');

insert into playercreateinfo_spell (race, class, Spell, Note) values (1, 7, 331, 'Healing Wave');

insert into playercreateinfo_spell (race, class, Spell, Note) values (1, 7, 403, 'Lightning Bolt');

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

insert into playercreateinfo_spell (race, class, Spell, Note) values (1, 7, 2382, 'Generic');

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

insert into playercreateinfo_spell (race, class, Spell, Note) values (1, 7, 3050, 'Detect');

insert into playercreateinfo_spell (race, class, Spell, Note) values (1, 7, 3365, 'Opening');

insert into playercreateinfo_spell (race, class, Spell, Note) values (1, 7, 6233, 'Closing');

insert into playercreateinfo_spell (race, class, Spell, Note) values (1, 7, 6246, 'Closing');

insert into playercreateinfo_spell (race, class, Spell, Note) values (1, 7, 6247, 'Opening');

insert into playercreateinfo_spell (race, class, Spell, Note) values (1, 7, 6477, 'Opening');

insert into playercreateinfo_spell (race, class, Spell, Note) values (1, 7, 6478, 'Opening');

insert into playercreateinfo_spell (race, class, Spell, Note) values (1, 7, 6603, 'Attack');

insert into playercreateinfo_spell (race, class, Spell, Note) values (1, 7, 7266, 'Duel');

insert into playercreateinfo_spell (race, class, Spell, Note) values (1, 7, 7267, 'Grovel');

insert into playercreateinfo_spell (race, class, Spell, Note) values (1, 7, 7355, 'Stuck');

insert into playercreateinfo_spell (race, class, Spell, Note) values (1, 7, 8386, 'Attacking');

insert into playercreateinfo_spell (race, class, Spell, Note) values (1, 7, 9077, 'Leather');

insert into playercreateinfo_spell (race, class, Spell, Note) values (1, 7, 9078, 'Cloth');

insert into playercreateinfo_spell (race, class, Spell, Note) values (1, 7, 9116, 'Shield');

insert into playercreateinfo_spell (race, class, Spell, Note) values (1, 7, 9125, 'Generic');

insert into playercreateinfo_spell (race, class, Spell, Note) values (1, 7, 21651, 'Opening');

insert into playercreateinfo_spell (race, class, Spell, Note) values (1, 7, 21652, 'Closing');

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

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

insert into playercreateinfo_spell (race, class, Spell, Note) values (1, 7, 27763, 'Totem');

insert into playercreateinfo_spell (race, class, Spell, Note) values (1, 7, 28875, 'Gemcutting');

insert into playercreateinfo_spell (race, class, Spell, Note) values (1, 7, 28878, 'Inspiring Presence');

insert into playercreateinfo_spell (race, class, Spell, Note) values (1, 7, 29932, 'Language Draenei');

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

insert into playercreateinfo_spell (race, class, Spell, Note) values (1, 7, 59221, 'Shadow Resistance');

insert into playercreateinfo_spell (race, class, Spell, Note) values (1, 7, 59547, 'Gift of the Naaru');

insert into playercreateinfo_spell (race, class, Spell, Note) values (1, 7, 61437, 'Opening');

insert into playercreateinfo_spell (race, class, Spell, Note) values (1, 7, 68398, 'Opening');

insert into playercreateinfo_spell (race, class, Spell, Note) values (1, 7, 75461, 'Flame Shock Passive');

delete from playercreateinfo_action where race=1 and class=7;

insert into playercreateinfo_action (race, class, button, action, type) values (1, 7, 0, 6603, 0);

insert into playercreateinfo_action (race, class, button, action, type) values (1, 7, 1, 403, 0);

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

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