insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('endler', 'fish', 'guppy', 'Endler''s Guppy', 'Poecilia Wingei', 'fish/guppy/endler.jpg', 1.8, 1, 2, 'omnivore');
insert into speciesSources (speciesID, source, pricePer, qtyInPack, link) values
	('endler', 'Aquahuna', 2.6, 10, 'https://aquahuna.com/collections/guppy-endler/products/assorted-endler-males'),
	('endler', 'PetCo', 4.49, 1, '');
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('endler', 'flakes', 0, 1, 0, 1, 0, 1, 1);


insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('guppy', 'fish', 'guppy', 'Guppy', 'Poecilia Reticulata', 'fish/guppy/guppy.jpg', 2.3, 2, 3, 'omnivore');
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('guppy', 'flakes', 0, 1, 0, 1, 0, 1, 1);
insert into speciesSources (speciesID, pattern, source, pricePer, qtyInPack, link) values
	('guppy', 'assorted-male', 'Aquahuna', 2.6, 8, 'https://aquahuna.com/collections/guppy-endler/products/assorted-guppy-males'),
	('guppy', 'assorted-male', 'PetCo', 3.99, 1, ''),
	('guppy', 'assorted-female', 'Aquahuna', 2.75, 8, 'https://aquahuna.com/collections/guppy-endler/products/assorted-guppy-female'),
	('guppy', 'assorted-female', 'PetCo', 3.49, 1, ''),
	('guppy', 'feeder', 'PetCo', 0.15, 1, ''),
	('guppy', 'koi', 'PetCo', 7.99, 1, ''),
	('guppy', 'blue-grass', 'PetCo', 5.99, 1, ''),
	('guppy', 'gold-lace', 'PetCo', 3.99, 1, ''),
	('guppy', 'lyretail', 'PetCo', 3.99, 1, ''),
	('guppy', 'red-flamingo', 'PetCo', 3.99, 1, '');
insert into speciesPatterns (speciesID, pattern, patternName) values
	('guppy', 'assorted-male', 'Assorted (Male)'),
	('guppy', 'assorted-female', 'Assorted (Female)'),
	('guppy', 'feeder', 'Feeder'),
	('guppy', 'koi', 'Koi'),
	('guppy', 'blue-grass', 'Blue Grass'),
	('guppy', 'gold-lace', 'Gold Lace'),
	('guppy', 'lyretail', 'Lyretail'),
	('guppy', 'red-flamingo', 'Red Flamingo');
