insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('mexican-dwarf-crayfish-orange', 'crayfish', 'crayfish', 'Mexican Dwarf Crayfish (Orange)', 'Cambarellus Patzcuarensis', 'crayfish/mexican-dwarf-orange.jpg', 1.5, 1, 2, null);
insert into speciesSources (speciesID, source, pricePer, qtyInPack) values
	('mexican-dwarf-crayfish-orange', 'PetCo', 9.99, 1);
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('mexican-dwarf-crayfish-orange', 'crabFood', 0, 1, 0, 0, 0, 1, 0),
	('mexican-dwarf-crayfish-orange', 'shrimpPellets', 0, 0, 0, 1, 0, 0, 1);

insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('mexican-dwarf-crayfish-blue', 'crayfish', 'crayfish', 'Mexican Dwarf Crayfish (Blue)', 'Cambarellus Texanus Blue', 'crayfish/mexican-dwarf-blue.jpg', 1.5, 1, 2, null);
insert into speciesSources (speciesID, source, pricePer, qtyInPack) values
	('mexican-dwarf-crayfish-blue', 'PetCo', 12.99, 1);
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('mexican-dwarf-crayfish-blue', 'crabFood', 0, 1, 0, 0, 0, 1, 0),
	('mexican-dwarf-crayfish-blue', 'shrimpPellets', 0, 0, 0, 1, 0, 0, 1);

insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('everglades-crayfish', 'crayfish', 'crayfish', 'Everglades Crayfish', 'Procambarus alleni', 'crayfish/blue.jpg', 0, 0, 0, null);
insert into speciesSources (speciesID, source, pricePer, qtyInPack) values
	('everglades-crayfish', 'PetCo', 29.99, 1);
insert into speciesAlternateNames (speciesID, alternateName) values
	('everglades-crayfish', 'Blue lobster'),
	('everglades-crayfish', 'Florida crayfish'),
	('everglades-crayfish', 'Electric blue crayfish'),
	('everglades-crayfish', 'Sapphire crayfish');
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('everglades-crayfish', 'crabFood', 0, 1, 0, 0, 0, 1, 0),
	('everglades-crayfish', 'shrimpPellets', 0, 0, 0, 1, 0, 0, 1);

insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('tangerine-crayfish', 'crayfish', 'crayfish', 'Tangerine Crayfish', 'Procambarus clarkii', 'crayfish/orange.jpg', 0, 0, 0, null);
insert into speciesSources (speciesID, source, pricePer, qtyInPack) values
	('tangerine-crayfish', 'PetCo', 20.99, 1);
insert into speciesAlternateNames (speciesID, alternateName) values
	('tangerine-crayfish', 'Mandarin crayfish');
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('tangerine-crayfish', 'crabFood', 0, 1, 0, 0, 0, 1, 0),
	('tangerine-crayfish', 'shrimpPellets', 0, 0, 0, 1, 0, 0, 1);

insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('quad-crayfish', 'crayfish', 'crayfish', 'Quad Crayfish', 'Cherax quadricarinatus', 'crayfish/quad.jpg', 0, 0, 0, null);
insert into speciesSources (speciesID, source, pricePer, qtyInPack) values
	('quad-crayfish', 'PetCo', 26.99, 1);
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('quad-crayfish', 'crabFood', 0, 1, 0, 0, 0, 1, 0),
	('quad-crayfish', 'shrimpPellets', 0, 0, 0, 1, 0, 0, 1);
