//
// create members
//
//


INSERT INTO `Members` ( `Position` , `Team` , `Quantity` , `Ma` , `St` , `Ag` , `Av` , `Skills` , `Cost` , `Getgen` , `Getstr` , `Getpas` , `Getagi` , `Getmut` )
VALUES (
'Linewoman', 'Amazon', '12', '6', '3', '3', '7', 'Dodge', '50', 'y', 'n', 'n', 'n', 'n'
), (
'Catcher', 'Amazon', '2', '6', '3', '3', '7', 'Dodge, Catch', '70', 'y', 'n', 'n', 'y', 'n'
);


INSERT INTO `members` ( `Position` , `Team` , `Quantity` , `Ma` , `St` , `Ag` , `Av` , `Skills` , `Cost` , `Getgen` , `Getstr` , `Getpas` , `Getagi` , `Getmut` )
VALUES (
'Beastmen', 'Chaos', '12', '6', '3', '3', '8', 'Horns', '60', 'y', 'y', 'n', 'n', 'y'
), (
'Bestigor', 'Chaos', '4', '5', '4', '3', '9', '', '100', 'y', 'y', 'n', 'n', 'y'
);

INSERT INTO `members` ( `Position` , `Team` , `Quantity` , `Ma` , `St` , `Ag` , `Av` , `Skills` , `Cost` , `Getgen` , `Getstr` , `Getpas` , `Getagi` , `Getmut` )
VALUES (
'Minotaur', 'Chaos', '1', '5', '5', '2', '8', 'Loner, Frenzy, Horns, Mighty Blow, Toughness, Wild Animal', '150', 'n', 'y', 'n', 'n', 'y'
), (
'Hobgoblin', 'Chaos Dwarf', '12', '6', '3', '3', '7', '', '40', 'y', 'n', 'n', 'n', 'n'
);

INSERT INTO `members` ( `Position` , `Team` , `Quantity` , `Ma` , `St` , `Ag` , `Av` , `Skills` , `Cost` , `Getgen` , `Getstr` , `Getpas` , `Getagi` , `Getmut` )
VALUES (
'Chaos Dwarf Blocker', 'Chaos Dwarf', '6', '4', '3', '2', '9', 'Block, Tackle, Toughness', '70', 'y', 'y', 'n', 'n', 'n'
), (
'Bull Centaur', 'Chaos Dwarf', '2', '6', '4', '2', '9', 'Sprint, Sure Feet, Toughness', '130', 'y', 'y', 'n', 'n', 'n'
);

INSERT INTO `members` ( `Position` , `Team` , `Quantity` , `Ma` , `St` , `Ag` , `Av` , `Skills` , `Cost` , `Getgen` , `Getstr` , `Getpas` , `Getagi` , `Getmut` )
VALUES (
'Minotaur', 'Chaos Dwarf', '1', '5', '5', '2', '8', 'Loner, Frenzy, Horns, Mighty Blow, Toughness, Wild Animal', '150', 'n', 'y', 'n', 'n', 'n'
), (
' Linemen', 'Dark Elf', '12', '6', '3', '4', '8', '', '70', 'y', 'n', 'n', 'y', 'n'
);

INSERT INTO `members` ( `Position` , `Team` , `Quantity` , `Ma` , `St` , `Ag` , `Av` , `Skills` , `Cost` , `Getgen` , `Getstr` , `Getpas` , `Getagi` , `Getmut` )
VALUES (
'Thrower', 'Dark Elf', '2', '6', '3', '4', '8', 'Pass', '90', 'y', 'n', 'y', 'y', 'n'
), (
'Blitzers', 'Dark Elf', '4', '7', '4', '3', '8', 'Block', '100', 'y', 'n', 'n', 'y', 'n'
);

INSERT INTO `members` ( `Position` , `Team` , `Quantity` , `Ma` , `St` , `Ag` , `Av` , `Skills` , `Cost` , `Getgen` , `Getstr` , `Getpas` , `Getagi` , `Getmut` )
VALUES (
'Witch Elves', 'Dark Elf', '2', '7', '3', '4', '7', 'Spring Back, Dodge, Frenzy, Jump Up', '110', 'y', 'n', 'n', 'y', 'n'
), (
'Assassin', 'Dark Elf', '1', '6', '3', '4', '8', 'Shadowing, Stab', '110', 'n', 'n', 'n', 'n', 'n'
);

INSERT INTO `members` ( `Position` , `Team` , `Quantity` , `Ma` , `St` , `Ag` , `Av` , `Skills` , `Cost` , `Getgen` , `Getstr` , `Getpas` , `Getagi` , `Getmut` )
VALUES (
'Long Beard', 'Dwarf', '12', '4', '3', '2', '9', 'Block, Tackle, Toughness', '70', 'y', 'y', 'n', 'n', 'n'
), (
'Runners', 'Dwarf', '2', '6', '3', '3', '8', 'Sure Hands, Toughness', '80', 'y', 'n', 'y', 'n', 'n'
);

INSERT INTO `members` ( `Position` , `Team` , `Quantity` , `Ma` , `St` , `Ag` , `Av` , `Skills` , `Cost` , `Getgen` , `Getstr` , `Getpas` , `Getagi` , `Getmut` )
VALUES (
'Blitzers', 'Dwarf', '2', '5', '3', '3', '9', 'Block, Toughness', '80', 'y', 'y', 'n', 'n', 'n'
), (
'Troll Slayers', 'Dwarf', '2', '5', '3', '2', '8', 'Block, Frenzy, Dauntless, Toughness', '90', 'y', 'y', 'n', 'n', 'n'
);

INSERT INTO `members` ( `Position` , `Team` , `Quantity` , `Ma` , `St` , `Ag` , `Av` , `Skills` , `Cost` , `Getgen` , `Getstr` , `Getpas` , `Getagi` , `Getmut` )
VALUES (
'Deathroller', 'Dwarf', '1', '4', '7', '1', '10', 'Break Tackle, Dirty Player, Juggernaut, Mighty Blow, No Hands, Secret Weapon, Stand Firm', '160', 'n', 'y', 'n', 'n', 'n'
), (
'Linemen', 'Elf', '12', '6', '3', '4', '7', '', '60', 'y', 'n', 'n', 'y', 'n'
);

INSERT INTO `members` ( `Position` , `Team` , `Quantity` , `Ma` , `St` , `Ag` , `Av` , `Skills` , `Cost` , `Getgen` , `Getstr` , `Getpas` , `Getagi` , `Getmut` )
VALUES (
'Throwers', 'Elf', '2', '6', '3', '4', '7', 'Pass', '70', 'y', 'n', 'y', 'y', 'n'
), (
'Catchers', 'Elf', '4', '8', '3', '4', '7', 'Catch, Nerves Of Steel', '100', 'y', 'n', 'n', 'y', 'n'
);


INSERT INTO `members` ( `Position` , `Team` , `Quantity` , `Ma` , `St` , `Ag` , `Av` , `Skills` , `Cost` , `Getgen` , `Getstr` , `Getpas` , `Getagi` , `Getmut` )
VALUES (
'Blitzers', 'Elf', '2', '7', '3', '4', '8', 'Block, Side Step', '110', 'y', 'n', 'n', 'y', 'n'
), (
'Goblins', 'Goblin', '16', '6', '2', '3', '7', 'Dodge, Right Stuff, Stunty', '40', 'n', 'n', 'n', 'y', 'n'
);

INSERT INTO `members` ( `Position` , `Team` , `Quantity` , `Ma` , `St` , `Ag` , `Av` , `Skills` , `Cost` , `Getgen` , `Getstr` , `Getpas` , `Getagi` , `Getmut` )
VALUES (
'Bombardier', 'Goblin', '1', '6', '2', '3', '7', 'Bombardier, Dodge, No Hands, Secret Weapon, Stunty', '40', 'n', 'n', 'n', 'y', 'n'
), (
'Pogoer', 'Goblin', '1', '7', '2', '3', '7', 'Dirty Player, Dodge, Leap, Secret Weapon, Sprint, Stunty', '40', 'n', 'n', 'n', 'y', 'n'
);

INSERT INTO `members` ( `Position` , `Team` , `Quantity` , `Ma` , `St` , `Ag` , `Av` , `Skills` , `Cost` , `Getgen` , `Getstr` , `Getpas` , `Getagi` , `Getmut` )
VALUES (
'Looney', 'Goblin', '1', '6', '2', '3', '7', 'Chainsaw, No Hands, Secret Weapon, Stunty', '40', 'n', 'n', 'n', 'y', 'n'
), (
'Fanatic', 'Goblin', '1', '3', '7', '3', '7', 'Ball & Chain, No Hands, Secret Weapon, Stunty', '70', 'n', 'y', 'n', 'n', 'n'
);

INSERT INTO `members` ( `Position` , `Team` , `Quantity` , `Ma` , `St` , `Ag` , `Av` , `Skills` , `Cost` , `Getgen` , `Getstr` , `Getpas` , `Getagi` , `Getmut` )
VALUES (
'Trolls', 'Goblin', '2', '4', '5', '1', '9', 'Always Hungry, Loner, Mighty Blow, Really Stupid, Regenerate, Throw Team-mate', '110', 'n', 'y', 'n', 'n', 'n'
), (
'Halflings', 'Halfling', '16', '5', '2', '3', '6', 'Dodge, Right Stuff, Stunty', '30', 'n', 'n', 'n', 'y', 'n'
);

INSERT INTO `members` ( `Position` , `Team` , `Quantity` , `Ma` , `St` , `Ag` , `Av` , `Skills` , `Cost` , `Getgen` , `Getstr` , `Getpas` , `Getagi` , `Getmut` )
VALUES (
'Treeman', 'Halfling', '2', '2', '6', '1', '10', 'Loner, Mighty Blow, Stand Firm, Take Root, Toughness, Throw Team-mate', '120', 'n', 'n', 'n', 'n', 'n'
), (
'Linemen', 'High Elf', '12', '6', '3', '4', '8', '', '70', 'y', 'n', 'n', 'y', 'n'
);

INSERT INTO `members` ( `Position` , `Team` , `Quantity` , `Ma` , `St` , `Ag` , `Av` , `Skills` , `Cost` , `Getgen` , `Getstr` , `Getpas` , `Getagi` , `Getmut` )
VALUES (
'Phoenix Warriors', 'High Elf', '2', '6', '3', '4', '8', 'Pass', '80', 'y', 'n', 'y', 'y', 'n'
), (
'Lion Warriors', 'High Elf', '4', '8', '3', '4', '7', 'Catch', '90', 'y', 'n', 'n', 'y', 'n'
);

INSERT INTO `members` ( `Position` , `Team` , `Quantity` , `Ma` , `St` , `Ag` , `Av` , `Skills` , `Cost` , `Getgen` , `Getstr` , `Getpas` , `Getagi` , `Getmut` )
VALUES (
'Dragon Warriors', 'High Elf', '2', '7', '3', '4', '8', 'Block', '100', 'y', 'n', 'n', 'y', 'n'
), (
'Linemen', 'Human', '12', '6', '3', '3', '8', '', '50', 'y', 'n', 'n', 'n', 'n'
);

INSERT INTO `members` ( `Position` , `Team` , `Quantity` , `Ma` , `St` , `Ag` , `Av` , `Skills` , `Cost` , `Getgen` , `Getstr` , `Getpas` , `Getagi` , `Getmut` )
VALUES (
'Catchers', 'Human', '4', '6', '3', '3', '8', 'Catch, Dodge', '70', 'y', 'n', 'n', 'y', 'n'
), (
'Thrower', 'Human', '2', '6', '3', '3', '8', 'Pass, Sure Hands', '70', 'y', 'n', 'y', 'n', 'n'
);

INSERT INTO `members` ( `Position` , `Team` , `Quantity` , `Ma` , `St` , `Ag` , `Av` , `Skills` , `Cost` , `Getgen` , `Getstr` , `Getpas` , `Getagi` , `Getmut` )
VALUES (
'Blitzers', 'Human', '4', '7', '3', '3', '8', 'Block', '90', 'y', 'y', 'n', 'n', 'n'
), (
'Ogre', 'Human', '1', '5', '5', '2', '9', 'Loner, Bone-head, Mighty Blow, Toughness, Throw Team-mate', '140', 'n', 'y', 'n', 'n', 'n'
);

INSERT INTO `members` ( `Position` , `Team` , `Quantity` , `Ma` , `St` , `Ag` , `Av` , `Skills` , `Cost` , `Getgen` , `Getstr` , `Getpas` , `Getagi` , `Getmut` )
VALUES (
'Skeletons', 'Khemri', '12', '5', '3', '2', '7', 'Regenerate', '30', 'y', 'n', 'n', 'n', 'n'
), (
'Blitz-Ra', 'Khemri', '2', '6', '3', '2', '8', 'Block, Regenerate', '90', 'y', 'y', 'n', 'n', 'n'
);

INSERT INTO `members` ( `Position` , `Team` , `Quantity` , `Ma` , `St` , `Ag` , `Av` , `Skills` , `Cost` , `Getgen` , `Getstr` , `Getpas` , `Getagi` , `Getmut` )
VALUES (
'Thro-Ra', 'Khemri', '2', '5', '3', '2', '7', 'Pass, Regenerate, Sure Hands', '70', 'y', 'n', 'y', 'n', 'n'
), (
'Mummies', 'Khemri', '4', '3', '5', '1', '9', 'Mighty Blow, Regenerate', '110', 'y', 'y', 'n', 'n', 'n'
);


INSERT INTO `members` ( `Position` , `Team` , `Quantity` , `Ma` , `St` , `Ag` , `Av` , `Skills` , `Cost` , `Getgen` , `Getstr` , `Getpas` , `Getagi` , `Getmut` )
VALUES (
'Skink', 'Lizardmen', '12', '8', '2', '3', '7', 'Dodge, Stunty', '60', 'n', 'n', 'n', 'y', 'n'
), (
'Saurus', 'Lizardmen', '6', '6', '4', '1', '9', '', '80', 'y', 'y', 'n', 'n', 'n'
);

INSERT INTO `members` ( `Position` , `Team` , `Quantity` , `Ma` , `St` , `Ag` , `Av` , `Skills` , `Cost` , `Getgen` , `Getstr` , `Getpas` , `Getagi` , `Getmut` )
VALUES (
'Kroxigor', 'Lizardmen', '1', '6', '5', '1', '9', 'Loner, Bone Head, Mighty Blow, Prehensile Tail', '140', 'n', 'y', 'n', 'n', 'n'
), (
'Zombies', 'Necomantic', '12', '4', '3', '2', '8', 'Regenerate', '30', 'y', 'n', 'n', 'n', 'n'
);

INSERT INTO `members` ( `Position` , `Team` , `Quantity` , `Ma` , `St` , `Ag` , `Av` , `Skills` , `Cost` , `Getgen` , `Getstr` , `Getpas` , `Getagi` , `Getmut` )
VALUES (
'Ghouls', 'Necromantic', '2', '7', '3', '3', '7', 'Dodge', '70', 'y', 'n', 'n', 'y', 'n'
), (
'Wights', 'Necromantic', '2', '6', '3', '3', '8', 'Block, Regenerate', '90', 'y', 'n', 'n', 'n', 'n'
);

INSERT INTO `members` ( `Position` , `Team` , `Quantity` , `Ma` , `St` , `Ag` , `Av` , `Skills` , `Cost` , `Getgen` , `Getstr` , `Getpas` , `Getagi` , `Getmut` )
VALUES (
'Flesh Golems', 'Necromantic', '2', '4', '4', '2', '9', 'Regenerate, Stand Firm', '120', 'y', 'y', 'n', 'n', 'n'
), (
'Werewolves', 'Necromantic', '2', '8', '3', '3', '8', 'Catch, Claws, Frenzy', '120', 'y', 'n', 'n', 'y', 'n'
);

INSERT INTO `members` ( `Position` , `Team` , `Quantity` , `Ma` , `St` , `Ag` , `Av` , `Skills` , `Cost` , `Getgen` , `Getstr` , `Getpas` , `Getagi` , `Getmut` )
VALUES (
'Linemen', 'Norse', '12', '6', '3', '3', '7', 'Block', '50', 'y', 'n', 'n', 'n', 'n'
), (
'Thrower', 'Norse', '2', '6', '3', '3', '7', 'Block, Pass', '70', 'y', 'n', 'y', 'n', 'n'
);

INSERT INTO `members` ( `Position` , `Team` , `Quantity` , `Ma` , `St` , `Ag` , `Av` , `Skills` , `Cost` , `Getgen` , `Getstr` , `Getpas` , `Getagi` , `Getmut` )
VALUES (
'Catcher', 'Norse', '2', '6', '3', '3', '7', 'Block, Catch', '70', 'y', 'n', 'n', 'y', 'n'
), (
'Blitzer', 'Norse', '4', '6', '3', '3', '7', 'Spring Back, Block, Jump Up, Frenzy', '90', 'y', 'y', 'n', 'n', 'n'
);

INSERT INTO `members` ( `Position` , `Team` , `Quantity` , `Ma` , `St` , `Ag` , `Av` , `Skills` , `Cost` , `Getgen` , `Getstr` , `Getpas` , `Getagi` , `Getmut` )
VALUES (
'Rotter', 'Nurgle', '12', '5', '3', '3', '8', '', '40', 'y', 'n', 'n', 'n', 'n'
), (
'Pestigor', 'Nurgle', '4', '6', '3', '3', '8', 'Regenerate, Horns', '80', 'y', 'y', 'n', 'n', 'n'
);

INSERT INTO `members` ( `Position` , `Team` , `Quantity` , `Ma` , `St` , `Ag` , `Av` , `Skills` , `Cost` , `Getgen` , `Getstr` , `Getpas` , `Getagi` , `Getmut` )
VALUES (
'Nurgle Warrior', 'Nurgle', '4', '4', '4', '2', '9', 'Foul Appearence, Regenerate', '110', 'y', 'y', 'n', 'n', 'n'
), (
'Beast of Nurgle', 'Nurgle', '1', '4', '6', '1', '9', 'Loner, Foul Appearence, Mighty Blow, No Hands, Really Stupid, Regenerate, Tentacles', '140', 'n', 'y', 'n', 'n', 'n'
);

INSERT INTO `members` ( `Position` , `Team` , `Quantity` , `Ma` , `St` , `Ag` , `Av` , `Skills` , `Cost` , `Getgen` , `Getstr` , `Getpas` , `Getagi` , `Getmut` )
VALUES (
'Ogres', 'Ogre', '12', '5', '5', '2', '9', 'Bone Head, Loner, Mighty Blow, Toughness, Throw Team-mate', '140', 'n', 'y', 'n', 'n', 'n'
), (
'Goblins', 'Ogre', '6', '6', '2', '3', '7', 'Dodge, Right Stuff, Stunty', '40', 'n', 'n', 'n', 'y', 'n'
);

INSERT INTO `members` ( `Position` , `Team` , `Quantity` , `Ma` , `St` , `Ag` , `Av` , `Skills` , `Cost` , `Getgen` , `Getstr` , `Getpas` , `Getagi` , `Getmut` )
VALUES (
'Linemen', 'Orc', '5', '3', '3', '9', '0', '', '50', 'y', 'n', 'n', 'n', 'n'
), (
'Goblins', 'Orc', '4', '6', '2', '3', '7', 'Dodge, Right Stuff, Stunty', '40', 'n', 'n', 'n', 'y', 'n'
);

INSERT INTO `members` ( `Position` , `Team` , `Quantity` , `Ma` , `St` , `Ag` , `Av` , `Skills` , `Cost` , `Getgen` , `Getstr` , `Getpas` , `Getagi` , `Getmut` )
VALUES (
'Throwers', 'Orc', '2', '5', '3', '3', '8', 'Pass, Sure Hands', '70', 'y', 'n', 'y', 'n', 'n'
), (
'Black Orc Blockers', 'Orc', '4', '4', '4', '2', '9', '', '80', 'y', 'y', 'n', 'n', 'n'
);

INSERT INTO `members` ( `Position` , `Team` , `Quantity` , `Ma` , `St` , `Ag` , `Av` , `Skills` , `Cost` , `Getgen` , `Getstr` , `Getpas` , `Getagi` , `Getmut` )
VALUES (
'Blitzers', 'Orc', '4', '6', '3', '3', '9', 'Block', '80', 'y', 'y', 'n', 'n', 'n'
), (
'Trolls', 'Orc', '1', '4', '5', '1', '9', 'Always Hungry, Loner, Mighty Blow, Really Stupid, Regenerate, Throw Team-mate', '110', 'n', 'y', 'n', 'n', 'n'
);

INSERT INTO `members` ( `Position` , `Team` , `Quantity` , `Ma` , `St` , `Ag` , `Av` , `Skills` , `Cost` , `Getgen` , `Getstr` , `Getpas` , `Getagi` , `Getmut` )
VALUES (
'Linemen', 'Skaven', '12', '7', '3', '3', '7', '', '50', 'y', 'n', 'n', 'n', 'n'
), (
'Throwers', 'Skaven', '2', '7', '3', '3', '7', 'Pass, Sure Hands', '70', 'y', 'n', 'y', 'n', 'n'
);

INSERT INTO `members` ( `Position` , `Team` , `Quantity` , `Ma` , `St` , `Ag` , `Av` , `Skills` , `Cost` , `Getgen` , `Getstr` , `Getpas` , `Getagi` , `Getmut` )
VALUES (
'Gutter Runners', 'Skaven', '4', '9', '2', '4', '7', 'Dodge', '80', 'y', 'n', 'n', 'y', 'y'
), (
'Storm Vermin', 'Skaven', '2', '7', '3', '3', '8', 'Block', '90', 'y', 'y', 'n', 'n', 'n'
);

INSERT INTO `members` ( `Position` , `Team` , `Quantity` , `Ma` , `St` , `Ag` , `Av` , `Skills` , `Cost` , `Getgen` , `Getstr` , `Getpas` , `Getagi` , `Getmut` )
VALUES (
'Skeletons', 'Undead', '12', '5', '3', '2', '7', 'Regenerate', '30', 'y', 'n', 'n', 'n', 'n'
), (
'Zombies', 'Undead', '12', '4', '3', '2', '8', 'Regenerate', '30', 'y', 'n', 'n', 'n', 'n'
);

INSERT INTO `members` ( `Position` , `Team` , `Quantity` , `Ma` , `St` , `Ag` , `Av` , `Skills` , `Cost` , `Getgen` , `Getstr` , `Getpas` , `Getagi` , `Getmut` )
VALUES (
'Ghouls', 'Undead', '4', '7', '3', '3', '7', 'Dodge', '70', 'y', 'n', 'n', 'y', 'n'
), (
'Wights', 'Undead', '2', '6', '3', '3', '8', 'Block, Regenerate', '90', 'y', 'y', 'n', 'n', 'n'
);

INSERT INTO `members` ( `Position` , `Team` , `Quantity` , `Ma` , `St` , `Ag` , `Av` , `Skills` , `Cost` , `Getgen` , `Getstr` , `Getpas` , `Getagi` , `Getmut` )
VALUES (
'Mummies', 'Undead', '2', '3', '5', '1', '9', 'Mighty Blow, Regenerate', '110', 'y', 'y', 'n', 'n', 'n'
), (
'Vampires', 'Vampire', '6', '6', '4', '4', '8', 'Hypnotic Gaze, Regenerate', '110', 'y', 'y', 'n', 'y', 'n'
);

INSERT INTO `members` ( `Position` , `Team` , `Quantity` , `Ma` , `St` , `Ag` , `Av` , `Skills` , `Cost` , `Getgen` , `Getstr` , `Getpas` , `Getagi` , `Getmut` )
VALUES (
'Thralls', 'Vampire', '12', '6', '3', '3', '7', '', '40', 'y', 'n', 'n', 'n', 'n'
), (
'Linemen', 'Wood Elf', '12', '7', '3', '4', '7', '', '70', 'y', 'n', 'n', 'y', 'n'
);

INSERT INTO `members` ( `Position` , `Team` , `Quantity` , `Ma` , `St` , `Ag` , `Av` , `Skills` , `Cost` , `Getgen` , `Getstr` , `Getpas` , `Getagi` , `Getmut` )
VALUES (
'Catchers', 'Wood Elf', '4', '9', '2', '4', '7', 'Catch, Dodge', '90', 'y', 'n', 'n', 'y', 'n'
), (
'Throwers', 'Wood Elf', '2', '7', '3', '4', '7', 'Pass', '90', 'y', 'n', 'y', 'n', 'n'
);