insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('celestial-pearl-danio', 'fish', 'danio', 'Celestial Pearl Danio', 'Danio Margaritatus', 'fish/danio/celestial-pearl.jpg', 1, 3, 5, 'omnivore');
insert into speciesSources (speciesID, source, pricePer, qtyInPack, link) values
	('celestial-pearl-danio', 'AquaHuna', 3.99, 8, 'https://aquahuna.com/collections/rasbora/products/galaxy-rasbora-celestial-pearl-danio');
insert into speciesAlternateNames (speciesID, alternateName) values
	('celestial-pearl-danio', 'CPD'),
	('celestial-pearl-danio', 'Galaxy Rasbora');
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('celestial-pearl-danio', 'flakes', 0, 1, 0, 1, 0, 1, 1);


insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('giant-danio', 'fish', 'danio', 'Giant Danio', 'Devario Aequipinnatus', 'fish/danio/giant.jpg', 6, 4, 5, 'omnivore');
insert into speciesSources (speciesID, source, pricePer, qtyInPack) values
	('giant-danio', 'PetCo', 3.99, 1),
	('giant-danio', 'PetSmart', 3.49, 1);
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('giant-danio', 'flakes', 0, 1, 0, 1, 0, 1, 1);


insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('leopard-danio', 'fish', 'danio', 'Leopard Danio', 'Danio Rerio var Leopard', 'fish/danio/leopard.jpg', 1, 3, 5, 'omnivore');
insert into speciesSources (speciesID, source, pricePer, qtyInPack, link) values
	('leopard-danio', 'QuinnsFins', 2.5, 1, 'https://www.quinnsfins.com/Danio--Leopard_p_1067.html');
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('leopard-danio', 'flakes', 0, 1, 0, 1, 0, 1, 1);


insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('zebra-danio', 'fish', 'danio', 'Zebra Danio', 'Danio Rerio', 'fish/danio/zebra.jpg', 1, 3, 5, 'omnivore');
insert into speciesSources (speciesID, source, pricePer, qtyInPack, link) values
	('zebra-danio', 'AquaHuna', 1.5, 12, 'https://aquahuna.com/collections/white-cloud-mountain-minnow/products/zebra-danio'),
	('zebra-danio', 'PetCo', 2.49, 1, '');
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('zebra-danio', 'flakes', 0, 1, 0, 1, 0, 1, 1);


insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('pearl-danio', 'fish', 'danio', 'Pearl Danio', 'Danio Albolineatus', 'fish/danio/pearl.jpg', 2.6, 3, 5, 'omnivore');
insert into speciesSources (speciesID, source, pricePer, qtyInPack, link) values
	('pearl-danio', 'QuinnsFins', 3.79, 1, 'https://www.quinnsfins.com/Danio--Pearl_p_1070.html'),
	('pearl-danio', 'PetCo', 1.99, 1, '');
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('pearl-danio', 'flakes', 0, 1, 0, 1, 0, 1, 1);
