insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('ropefish', 'fish', 'bichir', 'Ropefish', 'Erpetoichthys Calabaricus', 'fish/bichir/ropefish.jpg', 12, 15, 20, 'Carnivore');
insert into speciesSources (speciesID, source, pricePer, qtyInPack) values
	('ropefish', 'PetCo', 15.49, 1);
insert into speciesAlternateNames (speciesID, alternateName) values
	('ropefish', 'African Rope Fish'),
	('ropefish', 'Reed Fish'),
	('ropefish', 'Snake Fish');
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('ropefish', 'shrimpPellets', 0, 1, 0, 1, 0, 1, 0),
	('ropefish', 'frozen', 0, 0, 0, 0, 0, 0, 1);


insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('senegal-bichir', 'fish', 'bichir', 'Senegal Bichir', 'Polypterus Senegalus', 'fish/bichir/senegal.jpg', 12, 15, 18, 'Carnivore');
insert into speciesSources (speciesID, source, pricePer, qtyInPack) values
	('senegal-bichir', 'PetSmart', 7.99, 1);
insert into speciesAlternateNames (speciesID, alternateName) values
	('senegal-bichir', 'Gray Bichir'),
	('senegal-bichir', 'Cuvier''s Bichir'),
	('senegal-bichir', 'Dinosaur Bichir'),
	('senegal-bichir', 'Swamp Dragon'),
	('senegal-bichir', 'Dragon Bichir'),
	('senegal-bichir', 'Dragon Fin');
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('senegal-bichir', 'shrimpPellets', 0, 1, 0, 1, 0, 1, 0),
	('senegal-bichir', 'frozen', 0, 0, 0, 0, 0, 0, 1);


insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('armored-bichir', 'fish', 'bichir', 'Armored Bichir', 'Polypterus Delhezi', 'fish/bichir/delhezi.jpg', 16, 15, 18, 'Carnivore');
insert into speciesAlternateNames (speciesID, alternateName) values
	('armored-bichir', 'Barred Bichir'),
	('armored-bichir', 'Banded Bichir'),
	('armored-bichir', 'Bandback Bichir');
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('armored-bichir', 'shrimpPellets', 0, 1, 0, 1, 0, 1, 0),
	('armored-bichir', 'frozen', 0, 0, 0, 0, 0, 0, 1);
