insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('honey-gourami', 'fish', 'gourami', 'Honey Gourami', 'Trichogaster Chuna', 'fish/gourami/honey.jpg', 2, 3, 4, 'omnivore');
insert into speciesSources (speciesID, pattern, source, pricePer, qtyInPack, link) values
	('honey-gourami', '', 'Aquahuna', 5, 6, 'https://aquahuna.com/collections/gourami/products/gold-honey-gourami'),
	('honey-gourami', '', 'PetCo', 6.99, 1, ''),
	('honey-gourami', 'red', 'Aquahuna', 6, 6, 'https://aquahuna.com/collections/gourami/products/red-honey-gourami'),
	('honey-gourami', 'red', 'PetCo', 8.99, 1, '');
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('honey-gourami', 'flakes', 0, 1, 0, 1, 0, 1, 1);
insert into speciesPatterns (speciesID, pattern, patternName) values
	('honey-gourami', 'red', 'Red');



insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('pearl-gourami', 'fish', 'gourami', 'Pearl Gourami', 'Trichopodus Leerii', 'fish/gourami/pearl.jpg', 5, 4, 5, 'omnivore');
insert into speciesSources (speciesID, source, pricePer, qtyInPack) values
	('pearl-gourami', 'PetCo', 4.99, 1);
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('pearl-gourami', 'flakes', 0, 1, 0, 1, 0, 1, 1);



insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('sparkling-gourami', 'fish', 'gourami', 'Sparkling Gourami', 'Trichopsis Pumila', 'fish/gourami/sparkling.jpg', 1.6, 4, 5, 'omnivore');
insert into speciesSources (speciesID, source, pricePer, qtyInPack, link) values
	('sparkling-gourami', 'Aquahuna', 3.33, 6, 'https://aquahuna.com/products/sparking-gourami?variant=30267474149419'),
	('sparkling-gourami', 'PetCo', 3.99, 1, '');
insert into speciesAlternateNames (speciesID, alternateName) values
	('sparkling-gourami', 'Pygmy Gourami');
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('sparkling-gourami', 'flakes', 0, 1, 0, 1, 0, 1, 1);



insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('dwarf-gourami', 'fish', 'gourami', 'Dwarf Gourami', 'Trichogaster Lalius', 'fish/gourami/dwarf.jpg', 3.5, 3, 4, 'omnivore');
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('dwarf-gourami', 'flakes', 0, 1, 0, 1, 0, 1, 1);
insert into speciesPatterns (speciesID, pattern, patternName) values
	('dwarf-gourami', 'flame', 'Flame'),
	('dwarf-gourami', 'wild', 'Wild'),
	('dwarf-gourami', 'powder-blue', 'Powder Blue');
insert into speciesSources (speciesID, pattern, source, pricePer, qtyInPack) values
	('dwarf-gourami', 'flame', 'PetCo', 0, 1),
	('dwarf-gourami', 'wild', 'PetCo', 9.99, 1),
 	('dwarf-gourami', 'powder-blue', 'PetCo', 8.99, 1);



insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('three-spot-gourami', 'fish', 'gourami', 'Three Spot Gourami', 'Trichopodus Trichopterus', 'fish/gourami/three-spot.jpg', 6, 4, 6, 'omnivore');
insert into speciesSources (speciesID, source, pricePer, qtyInPack) values
	('three-spot-gourami', 'PetCo', 0, 1),
	('three-spot-gourami', 'PetSmart', 3.99, 1);
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('three-spot-gourami', 'flakes', 0, 1, 0, 1, 0, 1, 1);

insert into speciesAlternateNames (speciesID, alternateName) values
	('three-spot-gourami', 'Blue Gourami'),
	('three-spot-gourami', 'Golden Gourami'),
	('three-spot-gourami', 'Opaline Gourami'),
	('three-spot-gourami', 'Lavender Gourami');
insert into speciesSources (speciesID, pattern, source, pricePer, qtyInPack) values
	('three-spot-gourami', 'blue', 'PetCo', 3.99, 1),
	('three-spot-gourami', 'golden', 'PetCo', 3.99, 1),
	('three-spot-gourami', 'opaline', 'PetCo', 0, 1),
	('three-spot-gourami', 'lavender', 'PetCo', 3.99, 1);
insert into speciesPatterns (speciesID, pattern, patternName) values
	('three-spot-gourami', 'blue', 'Blue'),
	('three-spot-gourami', 'golden', 'Golden'),
	('three-spot-gourami', 'opaline', 'Opaline'),
	('three-spot-gourami', 'lavender', 'Lavender');


insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('paradise-gourami', 'fish', 'gourami', 'Paradise Gourami', 'Macropodus Opercularis', 'fish/gourami/paradise.jpg', 2.5, 8, 10, 'omnivore');
insert into speciesSources (speciesID, source, pricePer, qtyInPack) values
	('paradise-gourami', 'PetCo', 4.99, 1);
insert into speciesAlternateNames (speciesID, alternateName) values
	('paradise-gourami', 'Paradise Fish');
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('paradise-gourami', 'flakes', 0, 1, 0, 1, 0, 1, 1);

insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('moonlight-gourami', 'fish', 'gourami', 'Moonlight Gourami', 'Trichopodus Microlepsis', 'fish/gourami/moonlight.jpg', 2.5, 8, 10, 'omnivore');
insert into speciesSources (speciesID, source, pricePer, qtyInPack) values
	('moonlight-gourami', 'PetCo', 9.99, 1);
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('moonlight-gourami', 'flakes', 0, 1, 0, 1, 0, 1, 1);
