insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('platy', 'fish', 'platy', 'Platy', 'Xiphophorus Maculatus', 'fish/platy/platy.jpg', 2.8, 3, 4, 'omnivore');
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('platy', 'flakes', 0, 1, 0, 1, 0, 1, 1);
insert into speciesSources (speciesID, pattern, source, pricePer, qtyInPack) values
	('platy', 'bumblebee', 'PetCo', 0, 1),
	('platy', 'green-lantern', 'PetCo', 3.99, 1),
	('platy', 'mickey-mouse', 'PetCo', 0, 1),
	('platy', 'panda', 'PetCo', 5.49, 1),
	('platy', 'sunburst', 'PetCo', 2.99, 1),
	('platy', 'pineapple', 'PetCo', 0, 1),
	('platy', 'black', 'PetCo', 2.99, 1);
insert into speciesPatterns (speciesID, pattern, patternName) values
	('platy', 'bumblebee', 'Bumblebee'),
	('platy', 'green-lantern', 'Green Lantern'),
	('platy', 'mickey-mouse', 'Mickey Mouse'),
	('platy', 'panda', 'Panda'),
	('platy', 'sunburst', 'Sunburst'),
	('platy', 'pineapple', 'Pineapple'),
	('platy', 'black', 'Black');
