insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('betta', 'fish', 'betta', 'Betta', 'Betta Splendens', 'fish/betta/betta.jpg', 0, 0, 0, 'Omnivore');
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('betta', 'bettaPellets', 0, 1, 1, 1, 1, 1, 1);
insert into speciesPatterns (speciesID, pattern, patternName) values
	('betta', 'mermaid', 'Mermaid'),
	('betta', 'delta-tail', 'Delta Tail'),
	('betta', 'tangerine-koi', 'Tangerine Koi'),
	('betta', 'crowntail-white', 'Crowntail (White)'),
	('betta', 'crowntail-male', 'Crowntail (Male)'),
	('betta', 'female-assorted', 'Female Assorted'),
	('betta', 'female-tower-left', 'Female (Tower Left)'),
	('betta', 'female-tower-right', 'Female (Tower Right)');
insert into speciesSources (speciesID, pattern, source, pricePer, qtyInPack) values
	('betta', 'mermaid', 'PetCo', 9.99, 1),
	('betta', 'male-delta-tail', 'PetCo', 7.99, 1),
	('betta', 'splendens', 'PetCo', 7.99, 1),
	('betta', 'tangerine-koi', 'PetCo', 9.99, 1),
	('betta', 'crowntail-white', 'PetCo', 14.99, 1),
	('betta', 'crowntail-male', 'PetCo', 9.99, 1),
	('betta', 'female-assorted', 'PetCo', 2.99, 1),
	('betta', 'female-tower-left', 'PetCo', 2.99, 1),
	('betta', 'female-tower-right', 'PetCo', 2.99, 1);
