insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('pristella-tetra', 'fish', 'tetras', 'Pristella Tetra', 'Pristella Maxillaris', 'fish/tetras/pristella.jpg', 2, 3, 4, 'omnivore');
insert into speciesSources (speciesID, source, pricePer, qtyInPack) values
	('pristella-tetra', 'PetCo', 3.99, 1);
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('pristella-tetra', 'flakes', 0, 1, 0, 1, 0, 1, 1);
insert into speciesPatterns (speciesID, pattern, patternName) values
	('pristella-tetra', 'albino', 'Albino');


insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('buenos-aires-tetra', 'fish', 'tetras', 'Buenos Aires Tetra', 'Hyphessobrycon Anisitsi', 'fish/tetras/buenos-aires.jpg', 2.5, 5, 6, 'omnivore');
insert into speciesSources (speciesID, source, pricePer, qtyInPack) values
	('buenos-aires-tetra', 'PetCo', 2.49, 1);
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('buenos-aires-tetra', 'flakes', 0, 1, 0, 1, 0, 1, 1);


insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('congo-tetra', 'fish', 'tetras', 'Congo Tetra', 'Phenocogrammus Interruptus', 'fish/tetras/congo.jpg', 3, 3, 5, 'omnivore');
insert into speciesSources (speciesID, source, pricePer, qtyInPack, link) values
	('congo-tetra', 'AquaHuna', 6, 4, 'https://aquahuna.com/products/congo-tetra'),
	('congo-tetra', 'PetCo', 6.99, 1, '');
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('congo-tetra', 'flakes', 0, 1, 0, 1, 0, 1, 1);


insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('diamond-tetra', 'fish', 'tetras', 'Diamond Tetra', 'Moenkhausia Pittieri', 'fish/tetras/diamond.jpg', 2, 5, 6, 'omnivore');
insert into speciesSources (speciesID, source, pricePer, qtyInPack, link) values
	('diamond-tetra', 'AquaHuna', 4, 6, 'https://aquahuna.com/collections/tetra/products/diamond-tetra'),
	('diamond-tetra', 'PetCo', 4.99, 1, '');
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('diamond-tetra', 'flakes', 0, 1, 0, 1, 0, 1, 1);


insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('ember-tetra', 'fish', 'tetras', 'Ember Tetra', 'Hyphessobrycon Amandae', 'fish/tetras/ember.jpg', 1.2, 4, 6, 'omnivore');
insert into speciesSources (speciesID, source, pricePer, qtyInPack, link) values
	('ember-tetra', 'AquaHuna', 2, 10, 'https://aquahuna.com/collections/tetra/products/ember-tetra'),
	('ember-tetra', 'PetCo', 2.99, 1, '');
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('ember-tetra', 'flakes', 0, 1, 0, 1, 0, 1, 1);


insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('emperor-tetra', 'fish', 'tetras', 'Emperor Tetra', 'Nematobrycon Palmeri', 'fish/tetras/emperor.jpg', 1.5, 4, 6, 'omnivore');
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('emperor-tetra', 'flakes', 0, 1, 0, 1, 0, 1, 1);
insert into speciesSources (speciesID, pattern, source, pricePer, qtyInPack, link) values
	('emperor-tetra', '', 'AquaHuna', 3.5, 8, 'https://aquahuna.com/products/emperor-tetra'),
	('emperor-tetra', '', 'AquaticArts', 20.99, 6, 'https://aquaticarts.com/products/emperor-tetra?variant=30432229004'),
	('emperor-tetra', 'albino', 'AquaticArts', 20.99, 6, 'https://aquaticarts.com/products/albino-emperor-tetra?variant=1577593372684'),
	('emperor-tetra', 'black', 'AquaHuna', 3.75, 8, 'https://aquahuna.com/collections/tetra/products/black-emperor-tetra-8-pack'),
	('emperor-tetra', 'black', 'AquaticArts', 20.99, 6, 'https://aquaticarts.com/products/black-emperor-tetra?variant=12744658190422');
insert into speciesPatterns (speciesID, pattern, patternName) values
	('emperor-tetra', 'albino', 'Albino'),
	('emperor-tetra', 'black', 'Black');


insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('emperor-tetra-blue', 'fish', 'tetras', 'Emperor Tetra (Blue)', 'Inpaichthys Kerri', 'fish/tetras/emperor-blue.jpg', 1.5, 4, 6, 'omnivore');
insert into speciesSources (speciesID, source, pricePer, qtyInPack, link) values
	('emperor-tetra-blue', 'AquaHuna', 3.5, 8, 'https://aquahuna.com/collections/tetra/products/blue-emperor-tetra'),
	('emperor-tetra-blue', 'AquaticArts', 24.99, 6, 'https://aquaticarts.com/products/blue-purple-emperor-tetra?variant=19598032928854');


insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('ghost-tetra', 'fish', 'tetras', 'Ghost Tetra', 'Megalamphodus Megalopterus', 'fish/tetras/ghost.jpg', 2, 5, 8, 'omnivore');
insert into speciesSources (speciesID, source, pricePer, qtyInPack) values
	('ghost-tetra', 'PetCo', 14.99, 1);
insert into speciesAlternateNames (speciesID, alternateName) values
	('ghost-tetra', 'Glass Tetra');
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('ghost-tetra', 'flakes', 0, 1, 0, 1, 0, 1, 1);


insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('glowlight-tetra', 'fish', 'tetras', 'Glowlight Tetra', 'Hemigrammus Erythrozonus', 'fish/tetras/glowlight.jpg', 1.5, 2, 5, 'omnivore');
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('glowlight-tetra', 'flakes', 0, 1, 0, 1, 0, 1, 1);
insert into speciesSources (speciesID, pattern, source, pricePer, qtyInPack, link) values
	('glowlight-tetra', '', 'AquaHuna', 2.2, 10, 'https://aquahuna.com/collections/tetra/products/glowlight-tetra'),
	('glowlight-tetra', '', 'PetCo', 2.49, 1, ''),
	('glowlight-tetra', 'albino', 'PetCo', 2.99, 1, '');
insert into speciesPatterns (speciesID, pattern, patternName) values
	('glowlight-tetra', 'albino', 'Albino');


insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('red-eye-tetra', 'fish', 'tetras', 'Red Eye Tetra', 'Moenkhausia Sanctaefilomenae', 'fish/tetras/red-eye.jpg', 0, 0, 0, 'omnivore');
insert into speciesSources (speciesID, source, pricePer, qtyInPack) values
	('red-eye-tetra', 'PetCo', 2.99, 1);
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('red-eye-tetra', 'flakes', 0, 1, 0, 1, 0, 1, 1);


insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('rummynose-tetra', 'fish', 'tetras', 'Rummynose Tetra', 'Hemigrammus Rhodostomus', 'fish/tetras/rummynose.jpg', 2.5, 5, 6, 'omnivore');
insert into speciesSources (speciesID, source, pricePer, qtyInPack, link) values
	('rummynose-tetra', 'AquaHuna', 2.8, 10, 'https://aquahuna.com/products/rummynose-tetra-medium-7-pack'),
	('rummynose-tetra', 'PetCo', 3.99, 1, '');
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('rummynose-tetra', 'flakes', 0, 1, 0, 1, 0, 1, 1);


insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('serpae-tetra', 'fish', 'tetras', 'Serpae Tetra', 'Hyphessobrycon Eques', 'fish/tetras/serpae.jpg', 1.75, 5, 7, 'omnivore');
insert into speciesSources (speciesID, source, pricePer, qtyInPack, link) values
	('serpae-tetra', 'AquaHuna', 2.75, 8, 'https://aquahuna.com/collections/tetra/products/serpae-tetra'),
	('serpae-tetra', 'PetCo', 2.99, 1, '');
insert into speciesAlternateNames (speciesID, alternateName) values
	('serpae-tetra', 'Jewel Tetra'),
	('serpae-tetra', 'Callistus Tetra');
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('serpae-tetra', 'flakes', 0, 1, 0, 1, 0, 1, 1);


-- insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
-- 	('neon-tetra', 'fish', 'tetras', 'Neon Tetra', 'Paracheirodon Innesi', 'fish/tetras/neon.jpg', 1.5, 2, 4, 'omnivore');
-- insert into speciesSources (speciesID, source, pricePer, qtyInPack, link) values
-- 	('neon-tetra', 'AquaHuna', 2, 14, 'https://aquahuna.com/collections/tetra/products/neon-tetra'),
-- 	('neon-tetra', 'PetCo', 2.49, 1, '');


insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('cardinal-tetra', 'fish', 'tetras', 'Cardinal Tetra', 'Paracheirodon Axelrodi', 'fish/tetras/cardinal.jpg', 0, 0, 0, 'omnivore');
insert into speciesSources (speciesID, source, pricePer, qtyInPack) values
	('cardinal-tetra', 'PetCo', 3.99, 1);
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('cardinal-tetra', 'flakes', 0, 1, 0, 1, 0, 1, 1);


-- insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
-- 	('black-neon-tetra', 'fish', 'tetras', 'Black Neon Tetra', 'Hyphessobrycon Herbertaxelrodi', 'fish/tetras/black-neon.jpg', 0, 0, 0, 'omnivore');
-- insert into speciesSources (speciesID, source, pricePer, qtyInPack) values
-- 	('black-neon-tetra', 'PetCo', 2.49, 1);


insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('silvertip-tetra', 'fish', 'tetras', 'Silvertip Tetra', 'Hasemania Nana', 'fish/tetras/silvertip.jpg', 1.2, 5, 8, 'omnivore');
insert into speciesSources (speciesID, source, pricePer, qtyInPack, link) values
	('silvertip-tetra', 'AquaHuna', 2.5, 8, 'https://aquahuna.com/collections/tetra/products/silvertip-tetra');
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('silvertip-tetra', 'flakes', 0, 1, 0, 1, 0, 1, 1);


insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('skirt-tetra', 'fish', 'tetras', 'Skirt Tetra', 'Gymnocorymbus Ternetzi', 'fish/tetras/skirt.jpg', 2, 3, 5, 'omnivore');
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('skirt-tetra', 'flakes', 0, 1, 0, 1, 0, 1, 1);
insert into speciesSources (speciesID, pattern, source, pricePer, qtyInPack) values
	('skirt-tetra', 'black', 'PetCo', 2.99, 1),
	('skirt-tetra', 'white', 'PetCo', 4.49, 1);
insert into speciesAlternateNames (speciesID, alternateName) values
	('skirt-tetra', 'Petticoat Tetra'),
	('skirt-tetra', 'Black Widow Tetra'),
	('skirt-tetra', 'Blackamoor');
insert into speciesPatterns (speciesID, pattern, patternName) values
	('skirt-tetra', 'white', 'White'),
	('skirt-tetra', 'black', 'Black');


insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('von-rio-tetra', 'fish', 'tetras', 'Von Rio Tetra', 'Hyphessobrycon Flammeus', 'fish/tetras/von-rio.jpg', 1.6, 2, 4, 'omnivore');
insert into speciesSources (speciesID, source, pricePer, qtyInPack, link) values
	('von-rio-tetra', 'AquaHuna', 2.8, 8, 'https://aquahuna.com/collections/tetra/products/flame-von-rio-tetra?variant=32354276737099'),
	('von-rio-tetra', 'PetCo', 0, 1, '');
insert into speciesAlternateNames (speciesID, alternateName) values
	('von-rio-tetra', 'Red Tetra'),
	('von-rio-tetra', 'Fire Tetra'),
	('von-rio-tetra', 'Flame Tetra'),
	('von-rio-tetra', 'Orange Von Rio Tetra');
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('von-rio-tetra', 'flakes', 0, 1, 0, 1, 0, 1, 1);


insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('cochu-blue-tetra', 'fish', 'tetras', 'Cochu Blue Tetra', 'Boehlkea Fredcochui', 'fish/tetras/cochu-blue.jpg', 1.5, 2, 4, 'omnivore');
insert into speciesSources (speciesID, source, pricePer, qtyInPack) values
	('cochu-blue-tetra', 'PetCo', 3.99, 1);
insert into speciesAlternateNames (speciesID, alternateName) values
	('cochu-blue-tetra', 'Blue King Tetra');
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('cochu-blue-tetra', 'flakes', 0, 1, 0, 1, 0, 1, 1);


insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('bloodfin-tetra', 'fish', 'tetras', 'Bloodfin Tetra', 'Aphyocharax Anisitsi', 'fish/tetras/bloodfin.jpg', 2, 5, 8, 'omnivore');
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('bloodfin-tetra', 'flakes', 0, 1, 0, 1, 0, 1, 1);


insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('blind-cave-tetra', 'fish', 'tetras', 'Blind Cave Tetra', 'Astyanax Jordani', 'fish/tetras/blind-cave.jpg', 4, 3, 5, 'omnivore');
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('blind-cave-tetra', 'flakes', 0, 1, 0, 1, 0, 1, 1);
