insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('molly-sailfin', 'fish', 'molly', 'Molly, Sailfin', 'Poecilia Latipinna', 'fish/mollies/sailfin.jpg', 4, 1, 2, 'Omnivore');
insert into speciesSources (speciesID, source, pricePer, qtyInPack) values
	('molly-sailfin', 'PetCo', 0, 1);
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('molly-sailfin', 'flakes', 0, 1, 0, 1, 0, 1, 1);

insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('molly', 'fish', 'molly', 'Molly', 'Poecilia Sphenops', 'fish/mollies/molly.jpg', 4.5, 3, 5, 'Omnivore');
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('molly', 'flakes', 0, 1, 0, 1, 0, 1, 1);
insert into speciesSources (speciesID, pattern, source, pricePer, qtyInPack, link) values
	('molly', 'orange-panda', 'PetCo', 5.99, 1, ''),
	('molly', 'dalmatian', 'PetCo', 5.99, 1, ''),
	('molly', 'lyretail', 'PetCo', 0, 1, ''),
	('molly', 'marble', 'PetCo', 0, 1, ''),
	('molly', 'platinum', 'PetCo', 0, 1, ''),
	('molly', 'black-velvet', 'PetCo', 3.99, 1, ''),
	('molly', 'assorted', 'PetCo', 3.99, 1, '');
insert into speciesPatterns (speciesID, pattern, patternName) values
	('molly', 'orange-panda', 'Orange Panda'),
	('molly', 'dalmatian', 'Dalmatian'),
	('molly', 'lyretail', 'Lyretail'),
	('molly', 'marble', 'Marble'),
	('molly', 'platinum', 'Platinum'),
	('molly', 'black-velvet', 'Black Velvet'),
	('molly', 'assorted', 'Assorted');
