insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('shrimp-amano', 'shrimp', 'shrimp', 'Amano Shrimp', 'Caridina Multidentata', 'shrimp/amano.jpg', 0, 0, 0, null);
insert into speciesSources (speciesID, source, pricePer, qtyInPack) values
	('shrimp-amano', 'PetCo', 3.99, 1);
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('shrimp-amano', 'shrimpBites', 0, 0, 0, 1, 0, 0, 1);


insert into species (speciesID, categoryID, subCategoryID, commonName,scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('shrimp-bamboo', 'shrimp', 'shrimp', 'Bamboo Shrimp', 'Atyopsis Moluccensis', 'shrimp/bamboo.jpg', 4, 2, 3, null);
insert into speciesSources (speciesID, source, pricePer, qtyInPack) values
	('shrimp-bamboo', 'PetCo', 14.99, 1);
insert into speciesAlternateNames (speciesID, alternateName) values
	('shrimp-bamboo', 'Singapore Shrimp'),
	('shrimp-bamboo', 'Wood Shrimp'),
	('shrimp-bamboo', 'Fan Shrimp'),
	('shrimp-bamboo', 'Filter Shrimp'),
	('shrimp-bamboo', 'Flower Shrimp');
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('shrimp-bamboo', 'shrimpBites', 0, 0, 0, 1, 0, 0, 1);


insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('shrimp-ghost', 'shrimp', 'shrimp', 'Ghost Shrimp', 'Palaemonetes Paludosus', 'shrimp/ghost.jpg', 0, 0, 0, null);
insert into speciesSources (speciesID, source, pricePer, qtyInPack) values
	('shrimp-ghost', 'PetCo', 0.79, 1);
insert into speciesSources (speciesID, source) values
	('shrimp-ghost', 'Amazon');
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('shrimp-ghost', 'shrimpBites', 0, 0, 0, 1, 0, 0, 1);


insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('shrimp-neo', 'shrimp', 'shrimp', 'Neocaridina Shrimp', 'Neocaridina davidi', 'shrimp/neo.jpg', 0, 0, 0, null);
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('shrimp-neo', 'shrimpBites', 0, 0, 0, 1, 0, 0, 1);
insert into speciesSources (speciesID, pattern, source) values
	('shrimp-neo', 'red-cherry', 'Amazon'),
	('shrimp-neo', 'blue-dream', 'Amazon'),
	('shrimp-neo', 'orange-sunkist', 'Amazon'),
 	('shrimp-neo', 'yellow-rice', 'Amazon'),
	('shrimp-neo', 'white-snowball', 'Amazon'),
	('shrimp-neo', 'black-rose', 'Amazon');
insert into speciesPatterns (speciesID, pattern, patternName) values
	('shrimp-neo', 'red-cherry', 'Red Cherry'),
	('shrimp-neo', 'blue-dream', 'Blue Dream'),
	('shrimp-neo', 'orange-sunkist', 'Orange Sunkist'),
 	('shrimp-neo', 'yellow-rice', 'Yellow Rice'),
	('shrimp-neo', 'white-snowball', 'White Snowball'),
	('shrimp-neo', 'black-rose', 'Black Rose');


insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('shrimp-vampire', 'shrimp', 'shrimp', 'Vampire Shrimp', 'Atya Gabonesis', 'shrimp/vampire.jpg', 6, 3, 6, null);
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('shrimp-vampire', 'shrimpBites', 0, 0, 0, 1, 0, 0, 1);

