insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('white-cloud-mountain-minnow', 'fish', 'minnow', 'White Cloud Mountain Minnow', 'Tanichthys Albonubes', 'fish/minnows/white-cloud.jpg', 1.6, 3, 5, 'omnivore');
insert into speciesSources (speciesID, source, pricePer, qtyInPack, link) values
	('white-cloud-mountain-minnow', 'Aquahuna', 1.33, 15, 'https://aquahuna.com/collections/white-cloud-mountain-minnow/products/white-cloud'),
	('white-cloud-mountain-minnow', 'PetCo', 2.49, 1, '');
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('white-cloud-mountain-minnow', 'flakes', 0, 1, 0, 1, 0, 1, 1);

insert into speciesSources (speciesID, pattern, source, pricePer, qtyInPack, link) values
	('white-cloud-mountain-minnow', 'golden', 'Aquahuna', 1.67, 12, 'https://aquahuna.com/collections/white-cloud-mountain-minnow/products/gold-white-cloud'),
	('white-cloud-mountain-minnow', 'golden', 'PetCo', 2.99, 1, '');
insert into speciesPatterns (speciesID, pattern, patternName) values
	('white-cloud-mountain-minnow', 'golden', 'Golden');




insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('rosy-red-minnow', 'fish', 'minnow', 'Rosy Red Minnow', 'Pimephales Promelas', 'fish/minnows/rosy-red.jpg', 3, 1, 3, 'Omnivore');
insert into speciesSources (speciesID, source, pricePer, qtyInPack) values
	('rosy-red-minnow', 'PetCo', 0.22, 1);
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('rosy-red-minnow', 'flakes', 0, 1, 0, 1, 0, 1, 1);
