insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('bumblebee-catfish', 'fish', 'catfish', 'Bumblebee Catfish', 'Microglanis Iheringi', 'fish/catfish/bumblebee.jpg', 3.5, 4, 5, 'Omnivore');
insert into speciesSources (speciesID, source, pricePer, qtyInPack) values
	('bumblebee-catfish', 'PetCo', 5.49, 1);
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('bumblebee-catfish', 'bugBites', 0, 1, 0, 1, 0, 0, 0),
	('bumblebee-catfish', 'wafers', 0, 0, 0, 0, 0, 1, 0);


insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('otocinclus', 'fish', 'catfish', 'Otocinclus', 'Otocinclus Vestitus', 'fish/catfish/oto.jpg', 1.5, 3, 5, 'Omnivore');
insert into speciesSources (speciesID, source, pricePer, qtyInPack, link) values
	('otocinclus', 'AquaHuna', 6, 6, 'https://aquahuna.com/collections/algae-eater/products/otocinclus'),
	('otocinclus', 'PetSmart', 2.99, 1, ''),
	('otocinclus', 'PetCo', 3.99, 1, '');
insert into speciesAlternateNames (speciesID, alternateName) values
	('otocinclus', 'Dwarf Sucker'),
	('otocinclus', 'Oto');
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('otocinclus', 'bugBites', 0, 1, 0, 1, 0, 0, 0),
	('otocinclus', 'wafers', 0, 0, 0, 0, 0, 1, 0);


insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('pictus-catfish', 'fish', 'catfish', 'Pictus Catfish', 'Pimelodus Pictus', 'fish/catfish/pictus.jpg', 5, 8, 10, 'Omnivore');
insert into speciesSources (speciesID, source, pricePer, qtyInPack) values
	('pictus-catfish', 'PetCo', 13.99, 1),
	('pictus-catfish', 'PetSmart', 11.99, 1);
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('pictus-catfish', 'bugBites', 0, 1, 0, 1, 0, 0, 0),
	('pictus-catfish', 'wafers', 0, 0, 0, 0, 0, 1, 0);


insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('spotted-raphael-catfish', 'fish', 'catfish', 'Spotted Raphael Catfish', 'Agamyxis Pectinifrons', 'fish/catfish/spotted-raphael.jpg', 5.9, 8, 10, 'Omnivore');
insert into speciesSources (speciesID, source, pricePer, qtyInPack) values
	('spotted-raphael-catfish', 'PetCo', 11.99, 1);
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('spotted-raphael-catfish', 'bugBites', 0, 1, 0, 1, 0, 0, 0),
	('spotted-raphael-catfish', 'wafers', 0, 0, 0, 0, 0, 1, 0);


insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('striped-raphael-catfish', 'fish', 'catfish', 'Striped Raphael Catfish', 'Platydoras armatulus', 'fish/catfish/striped-raphael.jpg', 9.4, 8, 10, 'Omnivore');
insert into speciesSources (speciesID, source, pricePer, qtyInPack) values
	('striped-raphael-catfish', 'PetCo', 11.99, 1);
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('striped-raphael-catfish', 'bugBites', 0, 1, 0, 1, 0, 0, 0),
	('striped-raphael-catfish', 'wafers', 0, 0, 0, 0, 0, 1, 0);


insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('siamese-algae-eater', 'fish', 'catfish', 'Siamese Algae Eater', 'Crossocheilus Oblongus', 'fish/catfish/siamese-algae-eater.jpg', 6, 5, 10, 'Omnivore');
insert into speciesSources (speciesID, source, pricePer, qtyInPack) values
	('siamese-algae-eater', 'PetCo', 4.99, 1);
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('siamese-algae-eater', 'bugBites', 0, 1, 0, 1, 0, 0, 0),
	('siamese-algae-eater', 'wafers', 0, 0, 0, 0, 0, 1, 0);


insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('royal-farlowella', 'fish', 'catfish', 'Royal Farlowella', 'Sturisoma Panamense', 'fish/catfish/royal-farlowella.jpg', 8, 8, 10, 'Omnivore');
insert into speciesSources (speciesID, source, pricePer, qtyInPack) values
	('royal-farlowella', 'PetCo', 10.99, 1);
insert into speciesAlternateNames (speciesID, alternateName) values
	('royal-farlowella', 'Whiptail Catfish'),
	('royal-farlowella', 'Twig Catfish'),
	('royal-farlowella', 'Royal Stickfish');
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('royal-farlowella', 'bugBites', 0, 1, 0, 1, 0, 0, 0),
	('royal-farlowella', 'wafers', 0, 0, 0, 0, 0, 1, 0);


insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('glass-catfish', 'fish', 'catfish', 'Glass Catfish', 'Kryptopterus Vitreolus', 'fish/catfish/glass.jpg', 2.6, 5, 8, 'Omnivore');
insert into speciesSources (speciesID, source, pricePer, qtyInPack) values
	('glass-catfish', 'PetCo', 0, 1);
insert into speciesAlternateNames (speciesID, alternateName) values
	('glass-catfish', 'Glass Cat'),
	('glass-catfish', 'Ghost Catfish'),
	('glass-catfish', 'Phantom Catfish');
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('glass-catfish', 'bugBites', 0, 1, 0, 1, 0, 0, 0),
	('glass-catfish', 'wafers', 0, 0, 0, 0, 0, 1, 0);


insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('synodontis-petricola', 'fish', 'catfish', 'Synodontis Petricola', 'Synodontis Petricola', 'fish/catfish/synodontis-petricola.jpg', 5.3, 8, 10, 'Omnivore');
insert into speciesSources (speciesID, source, pricePer, qtyInPack) values
	('synodontis-petricola', 'PetCo', 19.99, 1);
insert into speciesAlternateNames (speciesID, alternateName) values
	('synodontis-petricola', 'Cuckoo Catfish'),
	('synodontis-petricola', 'Pygmy Leopard Catfish');
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('synodontis-petricola', 'bugBites', 0, 1, 0, 1, 0, 0, 0),
	('synodontis-petricola', 'wafers', 0, 0, 0, 0, 0, 1, 0);


insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('hoplo-catfish', 'fish', 'catfish', 'Hoplo Catfish', 'Megalechis Thoracata', 'fish/catfish/hoplo.jpg', 6, 5, 8, 'Omnivore');


insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('banjo-catfish', 'fish', 'catfish', 'Banjo Catfish', 'Bunocephalus Coracoideus', 'fish/catfish/banjo.jpg', 6, 6, 12, 'Omnivore');
