insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('checkered-barb', 'fish', 'barbs', 'Checkered Barb', 'Oliotius Oligolepis', 'fish/barbs/checkered.jpg', 2, 4, 6, 'Omnivore');
insert into speciesSources (speciesID, source, pricePer, qtyInPack, link) values
	('checkered-barb', 'AquaHuna', 14.99, 1, 'https://aquahuna.com/products/checkered-barb');
insert into speciesAlternateNames (speciesID, alternateName) values
	('checkered-barb', 'Checker Barb'),
	('checkered-barb', 'Checkerboard Barb');
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('checkered-barb', 'flakes', 0, 1, 0, 1, 0, 1, 1);


insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('cherry-barb', 'fish', 'barbs', 'Cherry Barb', 'Puntius Titteya', 'fish/barbs/cherry.jpg', 2, 4, 6, 'Omnivore');
insert into speciesSources (speciesID, source, pricePer, qtyInPack, link) values
	('cherry-barb', 'Aquahuna', 2.5, 8, 'https://aquahuna.com/collections/barbs/products/cherry-barb'),
	('cherry-barb', 'PetCo', 2.99, 1, null),
	('cherry-barb', 'PetSmart', 2.99, 1, null);
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('cherry-barb', 'flakes', 0, 1, 0, 1, 0, 1, 1);


insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('redline-barb', 'fish', 'barbs', 'Redline Barb', 'Puntius Denisonii', 'fish/barbs/redline.jpg', 5.5, 5, 8, 'Omnivore');
insert into speciesSources (speciesID, source, pricePer, qtyInPack, link) values
	('redline-barb', 'Aquahuna', 12, 2, 'https://aquahuna.com/products/roseline-shark-red-line-torpedo-barb'),
	('redline-barb', 'AquaticArts', 114.99, 12, 'https://aquaticarts.com/products/denisons-barb?variant=35517990668' ),
	('redline-barb', 'PetCo', 12.99, 1, '');
insert into speciesAlternateNames (speciesID, alternateName) values
	('redline-barb', 'Redline Torpedo Barb'),
	('redline-barb', 'Roseline Shark'),
	('redline-barb', 'Denisonii Barb'),
	('redline-barb', 'Miss Kerala');
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('redline-barb', 'flakes', 0, 1, 0, 1, 0, 1, 1);


-- insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	-- ('rosy-barb', 'fish', 'barbs', 'Rosy Barb', 'Pethia Conchonius', 'fish/barbs/rosy.jpg', 5, 3, 5, 'Omnivore');
-- insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
-- 	('rosy-barb', 'flakes', 0, 1, 0, 1, 0, 1, 1);


-- insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
-- 	('gold-barb', 'fish', 'barbs', 'Gold Barb', 'Puntius Semifasciolatus', 'fish/barbs/gold.jpg', 2.8, 3, 5, 'Omnivore');
-- insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
-- 	('gold-barb', 'flakes', 0, 1, 0, 1, 0, 1, 1);


insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('tiger-barb', 'fish', 'barbs', 'Tiger Barb', 'Puntigrus Tetrazona', 'fish/barbs/tiger.jpg', 2.8, 5, 7, 'Omnivore');
insert into speciesSources (speciesID, source, pricePer, qtyInPack, link) values
	('tiger-barb', 'Aquahuna', 3.5, 6, 'https://aquahuna.com/collections/barbs/products/tiger-barb'),
	('tiger-barb', 'PetCo', 4.99, 1, ''),
	('tiger-barb', 'PetSmart', 2.99, 1, '');
insert into speciesAlternateNames (speciesID, alternateName) values
	('tiger-barb', 'Tetrazona Barb');
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('tiger-barb', 'flakes', 0, 1, 0, 1, 0, 1, 1);
insert into speciesPatterns (speciesID, pattern, patternName) values
	('tiger-barb', 'albino', 'Albino'),
	('tiger-barb', 'green', 'Green');


insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('odessa-barb', 'fish', 'barbs', 'Odessa Barb', 'Pethia Padamya', 'fish/barbs/odessa.jpg', 2.8, 3, 5, 'Omnivore');
insert into speciesSources (speciesID, source, pricePer, qtyInPack) values
	('odessa-barb', 'PetCo', 6.99, 1);
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('odessa-barb', 'flakes', 0, 1, 0, 1, 0, 1, 1);


insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('black-ruby-barb', 'fish', 'barbs', 'Black Ruby Barb', 'Pethia Nigrofasciata', 'fish/barbs/black-ruby.jpg', 3, 3, 5, 'Omnivore');
insert into speciesSources (speciesID, source, pricePer, qtyInPack) values
	('black-ruby-barb', 'PetCo', 2.99, 1);
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('black-ruby-barb', 'flakes', 0, 1, 0, 1, 0, 1, 1);

