insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('purple-striped-dottyback', 'fish', 'saltwater', 'Purple Striped Dottyback', '(scientific name)', 'fish/saltwater/purple-striped-dottyback.jpg', 0, 0, 0, ''),
	('blue-damsel', 'fish', 'saltwater', 'Blue Damsel', '(scientific name)', 'fish/saltwater/blue-damsel.jpg', 0, 0, 0, ''),
	('blue-and-red-fairy-wrasse', 'fish', 'saltwater', 'Blue and Red Fairy Wrasse', '(scientific name)', 'fish/saltwater/blue-and-red-fairy-wrasse.jpg', 0, 0, 0, ''),
	('royal-gramma-basslet', 'fish', 'saltwater', 'Royal Gramma Basslet', '(scientific name)', 'fish/saltwater/royal-gramma-basslet.jpg', 0, 0, 0, ''),
	('firefish-goby', 'fish', 'saltwater', 'Firefish Goby', '(scientific name)', 'fish/saltwater/firefish-goby.jpg', 0, 0, 0, ''),
	('tail-spot-blenny', 'fish', 'saltwater', 'Tail Spot Blenny', '(scientific name)', 'fish/saltwater/tail-spot-blenny.jpg', 0, 0, 0, ''),
	('emerald-crab', 'crab', 'crab', 'Emerald Crab', '(scientific name)', 'crabs/emerald.jpg', 0, 0, 0, ''),
	('hermit-crabs', 'crab', 'crab', 'Hermit Crabs', '(scientific name)', 'crabs/hermit.jpg', 0, 0, 0, '');

insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
    ('ocellaris-clown-fish', 'fish', 'saltwater', 'Ocellaris Clown Fish', '(scientific name)', 'fish/saltwater/ocellaris-clown-fish.jpg', 0, 0, 0, ''),
    ('ruby-finned-fairy-wrasse', 'fish', 'saltwater', 'Ruby-Finned Fairy Wrasse', '(scientific name)', 'fish/saltwater/ruby-finned-fairy-wrasse.jpg', 0, 0, 0, ''),
    ('bangai-cardinalfish', 'fish', 'saltwater', 'Bangai Cardinalfish', '(scientific name)', 'fish/saltwater/bangai-cardinalfish.jpg', 0, 0, 0, ''),
    ('watchman-goby', 'fish', 'saltwater', 'Watchman Goby', '(scientific name)', 'fish/saltwater/watchman-goby.jpg', 0, 0, 0, ''),
    ('pistol-shrimp', 'shrimp', 'shrimp', 'Pistol Shrimp', '(scientific name)', 'shrimp/pistol.jpg', 0, 0, 0, ''),
    ('brittle-starfish', 'starfish', 'starfish', 'Brittle Starfish', '(scientific name)', 'starfish/brittle.jpg', 0, 0, 0, '');
