insert into species (speciesID, categoryID, subCategoryID, commonName,  scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('clown-loach', 'fish', 'loach', 'Clown Loach', 'Chromobotia Macracantha', 'fish/loach/clown.jpg', 10, 5, 10, 'omnivore');
insert into speciesSources (speciesID, source, pricePer, qtyInPack, link) values
	('clown-loach', 'PetCo', 9.99, 1, '');
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('clown-loach', 'bugBites', 0, 1, 0, 1, 0, 0, 0),
	('clown-loach', 'wafers', 0, 0, 0, 0, 0, 1, 0);


insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('dojo-loach', 'fish', 'loach', 'Dojo Loach', 'Misgurnus Anguillicaudatus', 'fish/loach/dojo.jpg', 11, 8, 10, 'omnivore');
insert into speciesSources (speciesID, pattern, source, pricePer, qtyInPack, link) values
	('dojo-loach', 'golden', 'Quinns Fins', 14.99, 1, ''),
	('dojo-loach', 'golden', 'PetCo', 10.99, 1, ''),
	('dojo-loach', '', 'Quinns Fins', 9.99, 1, ''),
	('dojo-loach', '', 'PetCo', 4.99, 1, '');
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('dojo-loach', 'bugBites', 0, 1, 0, 1, 0, 0, 0),
	('dojo-loach', 'wafers', 0, 0, 0, 0, 0, 1, 0);
insert into speciesPatterns (speciesID, pattern, patternName) values
	('dojo-loach', 'golden', 'Golden');


insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('hillstream-loach', 'fish', 'loach', 'Hillstream Loach', 'Sewalia Lineolata', 'fish/loach/hillstream.jpg', 2.5, 5, 10, 'omnivore');
insert into speciesSources (speciesID, source, pricePer, qtyInPack, link) values
	('hillstream-loach', 'AquaHuna', 10, 2, 'https://aquahuna.com/collections/loach/products/hillstream-loach-small'),
	('hillstream-loach', 'PetCo', 9.99, 1, '');
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('hillstream-loach', 'bugBites', 0, 1, 0, 1, 0, 0, 0),
	('hillstream-loach', 'wafers', 0, 0, 0, 0, 0, 1, 0);


insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('butterfly-loach', 'fish', 'loach', 'Butterfly Loach', 'Beaufortia Kweichowensis', 'fish/loach/butterfly.jpg', 3.5, 5, 10, 'omnivore');
insert into speciesSources (speciesID, source, pricePer, qtyInPack, link) values
	('butterfly-loach', 'PetCo', 9.99, 1, '');
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('butterfly-loach', 'bugBites', 0, 1, 0, 1, 0, 0, 0),
	('butterfly-loach', 'wafers', 0, 0, 0, 0, 0, 1, 0);


insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('yoyo-loach', 'fish', 'loach', 'Yoyo Loach', 'Botia Almorhae', 'fish/loach/yoyo.jpg', 2.5, 5, 8, 'omnivore');
insert into speciesSources (speciesID, source, pricePer, qtyInPack, link) values
	('yoyo-loach', 'AquaHuna', 5, 4, 'https://aquahuna.com/products/yoyo-loach'),
	('yoyo-loach', 'PetCo', 5.99, 1, ''),
	('yoyo-loach', 'PetSmart', 7.99, 1, '');
insert into speciesAlternateNames (speciesID, alternateName) values
	('yoyo-loach', 'Pakistani Loach');
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('yoyo-loach', 'bugBites', 0, 1, 0, 1, 0, 0, 0),
	('yoyo-loach', 'wafers', 0, 0, 0, 0, 0, 1, 0);


insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('zebra-loach', 'fish', 'loach', 'Zebra Loach', 'Botia Striata', 'fish/loach/zebra.jpg', 4, 8, 10, 'omnivore');
insert into speciesSources (speciesID, source, pricePer, qtyInPack, link) values
	('zebra-loach', 'PetCo', 16.99, 1, '');
insert into speciesAlternateNames (speciesID, alternateName) values
	('zebra-loach', 'Candystripe Loach'),
	('zebra-loach', 'Crossbanded Loach'),
	('zebra-loach', 'Lined Loach'),
	('zebra-loach', 'Striped Loach'),
	('zebra-loach', 'Tiger Loach');
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('zebra-loach', 'bugBites', 0, 1, 0, 1, 0, 0, 0),
	('zebra-loach', 'wafers', 0, 0, 0, 0, 0, 1, 0);


insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('kuhli-loach', 'fish', 'loach', 'Kuhli Loach', 'Pangio Kuhli', 'fish/loach/kuhli.jpg', 4, 8, 10, 'omnivore');
insert into speciesSources (speciesID, source, pricePer, qtyInPack, link) values
	('kuhli-loach', 'PetCo', 4.99, 1, '');
insert into speciesAlternateNames (speciesID, alternateName) values
	('kuhli-loach', 'Coolie Loach'),
	('kuhli-loach', 'Eel Loach');
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('kuhli-loach', 'bugBites', 0, 1, 0, 1, 0, 0, 0),
	('kuhli-loach', 'wafers', 0, 0, 0, 0, 0, 1, 0);
insert into speciesPatterns (speciesID, pattern, patternName) values
	('kuhli-loach', 'black', 'Black');
