insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('yellow-lab-mbuna', 'fish', 'cichlid-mbuna', 'Yellow Lab Mbuna', 'Labidochromis Caeruleus', 'fish/cichlid-mbuna/yellow-lab.jpg', 6, 6, 10, "Omnivore");
insert into speciesAlternateNames (speciesID, alternateName) values
	('yellow-lab-mbuna', 'Lemon Yellow Lab'),
	('yellow-lab-mbuna', 'Electric Yellow Cichild');
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('yellow-lab-mbuna', 'flakes', 0, 1, 0, 1, 0, 1, 1);


insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('yellow-tail-acei', 'fish', 'cichlid-mbuna', 'Yellow Tail Acei', 'Pseudotropheus Acei', 'fish/cichlid-mbuna/yellow-tail-acei.jpg', 5.5, 8, 10, "Omnivore");
insert into speciesAlternateNames (speciesID, alternateName) values
	('yellow-tail-acei', 'Acei');
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('yellow-tail-acei', 'flakes', 0, 1, 0, 1, 0, 1, 1);


insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('pseudotropheus-elongatus', 'fish', 'cichlid-mbuna', 'Elongate Mbuna', 'Pseudotropheus Elongatus', 'fish/cichlid-mbuna/pseudotropheus-elongatus.jpg', 3.7, 5, 8, "Omnivore");
insert into speciesSources (speciesID, source, pricePer, qtyInPack) values
	('pseudotropheus-elongatus', 'Quinns Fins', 0, 1);
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('pseudotropheus-elongatus', 'flakes', 0, 1, 0, 1, 0, 1, 1);


insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('cockatoo-apisto', 'fish', 'cichlid-mbuna', 'Cockatoo Apisto', 'Apistogramma Caucatoides', 'fish/cichlid-mbuna/cockatoo-apisto.jpg', 3, 5, 10, "Omnivore");
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('cockatoo-apisto', 'flakes', 0, 1, 0, 1, 0, 1, 1);

