insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('bala-shark', 'fish', 'sharks', 'Bala Shark', 'Balantiocheilos Melanopterus', 'fish/sharks/bala.jpg', 14, 8, 10, 'omnivore');
insert into speciesSources (speciesID, source, pricePer, qtyInPack) values
	('bala-shark', 'PetCo', 5.99, 1),
	('bala-shark', 'PetSmart', 5.99, 1);
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('bala-shark', 'flakes', 0, 1, 0, 1, 0, 1, 1);


insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('red-tailed-black-shark', 'fish', 'sharks', 'Red Tailed Black Shark', 'Epalzeorhynchos Bicolor', 'fish/sharks/red-tailed-black.jpg', 6, 6, 10, 'omnivore');
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('red-tailed-black-shark', 'flakes', 0, 1, 0, 1, 0, 1, 1);


insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('rainbow-shark', 'fish', 'sharks', 'Rainbow Shark', 'Epalzeorhynchos Frenatum', 'fish/sharks/rainbow.jpg', 5, 4, 6, 'omnivore');
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('rainbow-shark', 'flakes', 0, 1, 0, 1, 0, 1, 1);
insert into speciesSources (speciesID, pattern, source, pricePer, qtyInPack) values
	('rainbow-shark', 'albino', 'PetCo', 7.99, 1);
insert into speciesPatterns (speciesID, pattern, patternName) values
	('rainbow-shark', 'albino', 'Albino'),
	('rainbow-shark', 'glofish-blue', 'Glofish Blue'),
	('rainbow-shark', 'glofish-green', 'Glofish Green'),
	('rainbow-shark', 'glofish-orange', 'Glofish Orange'),
	('rainbow-shark', 'glofish-purple', 'Glofish Purple');
