insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('angelfish', 'fish', 'cichlid', 'Angelfish', 'Pterophyllum Scalare', 'fish/cichlid/angelfish.jpg', 4, 10, 12, 'Omnivore');
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('angelfish', 'flakes', 0, 1, 0, 1, 0, 1, 1);
insert into speciesSources (speciesID, pattern, source, pricePer, qtyInPack) values
	('angelfish', 'koi', 'PetCo', 19.99, 1),
	('angelfish', 'koi', 'PetSmart', 12.99, 1),
	('angelfish', 'zebra', 'PetCo', 3.99, 1);
insert into speciesPatterns (speciesID, pattern, patternName) values
	('angelfish', 'koi', 'Koi'),
	('angelfish', 'zebra', 'Zebra');


insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('blue-acara', 'fish', 'cichlid', 'Blue Acara', 'Andinoacara Pulcher', 'fish/cichlid/blue-acara.jpg', 6.3, 8, 10, 'Omnivore');
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('blue-acara', 'flakes', 0, 1, 0, 1, 0, 1, 1);


insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('kribensis', 'fish', 'cichlid', 'Kribensis', 'Pelvicachromis Pulcher', 'fish/cichlid/kribensis.jpg', 4, 3, 5, 'Omnivore');
insert into speciesSources (speciesID, source, pricePer, qtyInPack) values
	('kribensis', 'PetCo', 10.99, 1);
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('kribensis', 'flakes', 0, 1, 0, 1, 0, 1, 1);


-- insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
-- 	('blood-parrot', 'fish', 'cichlid', 'Blood Parrot', 'Amphilophus Citrinellus × Vieja Melanurus', 'fish/cichlid/blood-parrot.jpg', 0, 0, 0, 'Omnivore');
-- insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
-- 	('blood-parrot', 'flakes', 0, 1, 0, 1, 0, 1, 1);


insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('maison-peacock', 'fish', 'cichlid', 'Maison Peacock', 'Aulonocara Masoni', 'fish/cichlid/maison-peacock.jpg', 7, 6, 8, 'Omnivore');
insert into speciesAlternateNames (speciesID, alternateName) values
	('maison-peacock', 'Mason''s Peacock'),
	('maison-peacock', 'Maisoni Chitimba'),
	('maison-peacock', 'Masoni Chitimba');
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('maison-peacock', 'flakes', 0, 1, 0, 1, 0, 1, 1);


insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('haplochromis-nyererei', 'fish', 'cichlid', 'Haplochromis Nyererei', 'Haplochromis Nyererei', 'fish/cichlid/haplochromis-nyererei.jpg', 3, 5, 8, 'Omnivore');
insert into speciesAlternateNames (speciesID, alternateName) values
	('haplochromis-nyererei', 'Pundamilla Nyererei');
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('haplochromis-nyererei', 'flakes', 0, 1, 0, 1, 0, 1, 1);


insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('neolamprologus-similis', 'fish', 'cichlid', 'Neolamprologus Similis', 'Neolamprologus Similis', 'fish/cichlid/neolamprologus-similis.jpg', 2, 7, 10, 'Carnivore');
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('neolamprologus-similis', 'flakes', 0, 1, 0, 1, 0, 1, 1);


insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('neolamprologus-brichardi', 'fish', 'cichlid', 'Neolamprologus Brichardi', 'Neolamprologus Brichardi', 'fish/cichlid/neolamprologus-brichardi.jpg', 4, 5, 8, 'Omnivore');
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('neolamprologus-brichardi', 'flakes', 0, 1, 0, 1, 0, 1, 1);


insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('keyhole-cichlid', 'fish', 'cichlid', 'Keyhole Cichlid', 'Cleithracara Maronii', 'fish/cichlid/keyhole-cichlid.jpg', 6, 7, 10, 'Omnivore');
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('keyhole-cichlid', 'flakes', 0, 1, 0, 1, 0, 1, 1);


insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('bolivian-ram', 'fish', 'cichlid', 'Bolivan Ram', 'Mikrogeophagus Altispinosus', 'fish/cichlid/bolivian-ram.jpg', 3.5, 5, 6, 'Omnivore');
insert into speciesAlternateNames (speciesID, alternateName) values
	('bolivian-ram', 'Ruby Clown Ram');
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('bolivian-ram', 'flakes', 0, 1, 0, 1, 0, 1, 1);

