insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('comet-goldfish-white', 'fish', 'goldfish', 'Comet Goldfish (White)', 'Carassius Auratus', 'fish/goldfish/comet-white.jpg', 12, 10, 20, 'Omnivore');
-- insert into speciesSources (speciesID, source, pricePer, qtyInPack) values
-- 	('comet-goldfish-white', 'PetCo', 14.99, 1);
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('comet-goldfish-white', 'flakes', 0, 1, 0, 1, 0, 1, 1);

insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('shubunkin-goldfish', 'fish', 'goldfish', 'Shubunkin Goldfish (Calico)', 'Carassius Auratus', 'fish/goldfish/shubunkin.jpg', 8, 10, 15, 'Omnivore');

insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('calico-veiltail-goldfish', 'fish', 'goldfish', 'Veiltail Goldfish (Calico)', 'Carassius Auratus', 'fish/goldfish/calico-veiltail.jpg', 6, 10, 15, 'Omnivore');
