insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('bristlenose-pleco', 'fish', 'plecos', 'Bristlenose Pleco', 'Ancistrus Cirrhosus', 'fish/plecos/bristlenose.jpg', 6, 10, 15, 'omnivore');
insert into speciesSources (speciesID, source, pricePer, qtyInPack, link) values
	('bristlenose-pleco', 'AquaHuna', 4, 6, 'https://aquahuna.com/collections/plecos/products/bushy-nose-pleco'),
	('bristlenose-pleco', 'PetCo', 6.99, 1, '');
insert into speciesAlternateNames (speciesID, alternateName) values
	('bristlenose-pleco', 'Bristlenose Catfish'),
	('bristlenose-pleco', 'Bushynose Pleco'),
	('bristlenose-pleco', 'Bushynose Catfish');
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('bristlenose-pleco', 'wafers', 0, 1, 0, 0, 0, 1, 0);


insert into speciesSources (speciesID, pattern, source, pricePer, qtyInPack) values
	('bristlenose-pleco', 'longfin', 'PetCo', 13.49, 1),
	('bristlenose-pleco', 'green-dragon', 'PetCo', 49.99, 1),
	('bristlenose-pleco', 'albino', 'PetCo', 6.99, 1),
	('bristlenose-pleco', 'snow-white', 'FB Marketplace', 0, 0),
	('bristlenose-pleco', 'super-red', 'PetCo', 14.99, 1);
insert into speciesPatterns (speciesID, pattern, patternName) values
	('bristlenose-pleco', 'longfin', 'Longfin'),
	('bristlenose-pleco', 'green-dragon', 'Green Dragon'),
	('bristlenose-pleco', 'albino', 'Albino'),
	('bristlenose-pleco', 'snow-white', 'Snow White'),
	('bristlenose-pleco', 'super-red', 'Super Red');



insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('clown-pleco', 'fish', 'plecos', 'Clown Pleco', 'Panaque Maccus', 'fish/plecos/clown.jpg', 3.5, 10, 12, 'omnivore');
insert into speciesSources (speciesID, source, pricePer, qtyInPack) values
	('clown-pleco', 'PetCo', 11.49, 1);
insert into speciesAlternateNames (speciesID, alternateName) values
	('clown-pleco', 'Clown Panaque'),
	('clown-pleco', 'Panaqolus Maccus'),
	('clown-pleco', 'Ringlet Pleco');
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('clown-pleco', 'wafers', 0, 1, 0, 0, 0, 1, 0);


insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('rubberlip-pleco', 'fish', 'plecos', 'Rubberlip Pleco', 'Chaetostoma Milesi', 'fish/plecos/rubberlip.jpg', 4.5, 10, 15, 'omnivore');
insert into speciesSources (speciesID, source, pricePer, qtyInPack) values
	('rubberlip-pleco', 'PetCo', 6.99, 1);
insert into speciesAlternateNames (speciesID, alternateName) values
	('rubberlip-pleco', 'Rubbernose Pleco'),
	('rubberlip-pleco', 'Bulldog Pleco');
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('rubberlip-pleco', 'wafers', 0, 1, 0, 0, 0, 1, 0);


insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('common-pleco', 'fish', 'plecos', 'Common Pleco', 'Hypostomus Plecostomus', 'fish/plecos/common.jpg', 24, 10, 15, 'omnivore');
insert into speciesSources (speciesID, source, pricePer, qtyInPack) values
	('common-pleco', 'PetCo', 20, 1);
insert into speciesAlternateNames (speciesID, alternateName) values
	('common-pleco', 'Janitor Fish'),
	('common-pleco', 'Algae Sucker'),
	('common-pleco', 'Sweeper Fish'),
	('common-pleco', 'Suckermouth Catfish');
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('common-pleco', 'wafers', 0, 1, 0, 0, 0, 1, 0);


insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('orange-seam-pleco', 'fish', 'plecos', 'Orange Seam Pleco', 'Hemiancistrus Guahiborum', 'fish/plecos/orange-seam.jpg', 6, 5, 8, 'omnivore');
insert into speciesSources (speciesID, source, pricePer, qtyInPack) values
	('orange-seam-pleco', 'FB Marketplace', 0, 0);
insert into speciesAlternateNames (speciesID, alternateName) values
	('orange-seam-pleco', 'Spotted Orange Seam'),
	('orange-seam-pleco', 'Orangerandet Sugemalle'),
	('orange-seam-pleco', 'L106');
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('orange-seam-pleco', 'wafers', 0, 1, 0, 0, 0, 1, 0);


insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('blue-phantom-pleco', 'fish', 'plecos', 'Phantom Pleco (Blue)', 'Hemiancistrus Sp.', 'fish/plecos/blue-phantom.jpg', 8, 10, 15, 'omnivore');
insert into speciesSources (speciesID, source, pricePer, qtyInPack) values
	('blue-phantom-pleco', 'FB Marketplace', 0, 0);
insert into speciesAlternateNames (speciesID, alternateName) values
	('blue-phantom-pleco', 'L128');
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('blue-phantom-pleco', 'wafers', 0, 1, 0, 0, 0, 1, 0);

