insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('swordtail', 'fish', 'swordtails', 'Swordtail', 'Xiphophorus Hellerii', 'fish/swordtails/swordtail.jpg', 6.3, 3, 5, 'omnivore');
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('swordtail', 'flakes', 0, 1, 0, 1, 0, 1, 1);

insert into speciesPatterns (speciesID, pattern, patternName) values
	('swordtail', 'green', 'Green'),
	('swordtail', 'blue', 'Blue'),
	('swordtail', 'red-wag', 'Red Wag'),
	('swordtail', 'red-velvet', 'Red Velvet'),
	('swordtail', 'pineapple', 'Pineapple'),
	('swordtail', 'koi-sanke', 'Koi Sanke');
insert into speciesSources (speciesID, pattern, source, pricePer, qtyInPack) values
	('swordtail', 'green', 'PetCo', 3.99, 1),
	('swordtail', 'blue', 'PetCo', 3.49, 1),
	('swordtail', 'red-wag', 'PetCo', 3.49, 1),
	('swordtail', 'red-velvet', 'PetCo', 3.99, 1),
	('swordtail', 'pineapple', 'PetCo', 3.99, 1),
	('swordtail', 'koi-sanke', 'PetSmart', 3.99, 1),
	('swordtail', 'koi-sanke', 'PetCo', 1.00, 1);
