insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('axolotl', 'amphibian', 'amphibian', 'Axolotl', 'Ambystoma Mexicanum', 'amphibians/axolotl.jpg', 12, 0, 0, 'Carnivore');
insert into speciesSources (speciesID, source, pricePer, qtyInPack) values
	('axolotl', 'FB Marketplace', 20, 1);
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('axolotl', 'axolotlFood', 0, 1, 0, 1, 0, 1, 1);
insert into speciesPatterns (speciesID, pattern, patternName) values
	('axolotl', 'leucistic', 'Leucistic');


insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('african-dwarf-frog', 'amphibian', 'amphibian', 'African Dwarf Frog', 'Hymenochirus Boettgeri', 'amphibians/african-dwarf-frog.jpg', 3, 3, 5, 'Omnivore');
insert into speciesSources (speciesID, source, pricePer, qtyInPack) values
	('african-dwarf-frog', 'PetCo', 3.99, 1);
insert into speciesSources (speciesID, source, pricePer, qtyInPack) values
	('african-dwarf-frog', 'PetSmart', 5.99, 1);
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('african-dwarf-frog', 'frogFood', 0, 1, 0, 1, 0, 1, 1);

insert into speciesPatterns (speciesID, pattern, patternName) values
	('african-dwarf-frog', 'albino', 'Albino');
insert into speciesSources (speciesID, pattern, source, pricePer, qtyInPack) values
	('african-dwarf-frog', 'albino', 'PetCo', 5.99, 1);


insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('african-clawed-frog', 'amphibian', 'amphibian', 'African Clawed Frog', 'Xenopus Laevis', 'amphibians/african-clawed-frog.jpg', 5, 10, 15, 'Omnivore');
insert into speciesSources (speciesID, source, pricePer, qtyInPack) values
	('african-clawed-frog', 'PetCo', 7.99, 1);
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('african-clawed-frog', 'frogFood', 0, 1, 0, 1, 0, 1, 1);

insert into speciesPatterns (speciesID, pattern, patternName) values
	('african-clawed-frog', 'albino', 'Albino');
insert into speciesSources (speciesID, pattern, source, pricePer, qtyInPack) values
	('african-clawed-frog', 'albino', 'PetCo', 7.99, 1);
