insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('snail-nerite', 'snail', 'snail', 'Nerite', 'Neritidae', 'snails/nerite.jpg', 0, 0, 0, null);
insert into speciesSources (speciesID, pattern, source, pricePer, qtyInPack, link) values
	('snail-nerite', 'black', 'PetCo', 3.49, 1, ''),
	('snail-nerite', 'horned', 'PetCo', 2.99, 1, ''),
	('snail-nerite', 'horned', 'AquaHuna', 2.5, 2, 'https://aquahuna.com/collections/snail-crab-clam/products/assorted-horned-nerite-snail-2-pack'),
	('snail-nerite', 'red-spotted', 'AquaHuna', 2.5, 2, 'https://aquahuna.com/collections/snail-crab-clam/products/red-spotted-nerite-snail'),
	('snail-nerite', 'tiger', 'QuinnsFins', 2.38, 1, 'https://www.quinnsfins.com/Snail-Tiger-Nerite-Snail_p_753.html'),
	('snail-nerite', 'zebra', 'AquaHuna', 2.5, 2, 'https://aquahuna.com/collections/snail-crab-clam/products/zebra-nerite-snail');
insert into speciesPatterns (speciesID, pattern, patternName) values
	('snail-nerite', 'black', 'Black'),
	('snail-nerite', 'horned', 'Horned'),
	('snail-nerite', 'red-spotted', 'Red Spotted'),
	('snail-nerite', 'tiger', 'Tiger'),
	('snail-nerite', 'zebra', 'Zebra');

insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('snail-mystery', 'snail', 'snail', 'Mystery Snail', 'Pomacea Bridgesii', 'snails/mystery.jpg', 0, 0, 0, null);
insert into speciesSources (speciesID, pattern, source, pricePer, qtyInPack) values
	('snail-mystery', '', 'PetCo', 3.99, 1),
	('snail-mystery', 'blue', 'PetCo', 3.99, 1),
	('snail-mystery', 'brown', 'PetCo', 3.99, 1);
insert into speciesPatterns (speciesID, pattern, patternName) values
	('snail-mystery', 'brown', 'Brown'),
	('snail-mystery', 'blue', 'Blue');
