insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('brilliant-rasbora', 'fish', 'rasbora', 'Briliiant Rasbora', 'Rasbora Borapetensis', 'fish/rasbora/brilliant.jpg', 3, 2, 3, 'Omnivore');
insert into speciesSources (speciesID, source, pricePer, qtyInPack) values
	('brilliant-rasbora', 'PetCo', 2.99, 1);
insert into speciesAlternateNames (speciesID, alternateName) values
	('brilliant-rasbora', 'Blackline Rasbora'),
	('brilliant-rasbora', 'Red-Tailed Rasbora');
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('brilliant-rasbora', 'flakes', 0, 1, 0, 1, 0, 1, 1);


insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('harlequin-rasbora', 'fish', 'rasbora', 'Harlequin Rasbora', 'Trigonostigma Heteromorpha', 'fish/rasbora/harlequin.jpg', 2, 5, 8, null);
insert into speciesSources (speciesID, source, pricePer, qtyInPack, link) values
	('harlequin-rasbora', 'AquaHuna', 3.5, 8, 'https://aquahuna.com/collections/rasbora/products/harlequin-rasbora');
insert into speciesSources (speciesID, source, pricePer, qtyInPack) values
	('harlequin-rasbora', 'PetCo', 3.99, 1);
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('harlequin-rasbora', 'flakes', 0, 1, 0, 1, 0, 1, 1);


-- insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
-- 	('green-neon-rasbora', 'fish', 'rasbora', 'Green Neon Rasbora', 'Microdevario Kubotai', 'fish/rasbora/green-neon.jpg', 0, 0, 0, null);
-- insert into speciesSources (speciesID, source, pricePer, qtyInPack, link) values
-- 	('green-neon-rasbora', 'AquaHuna', 3.75, 8, 'https://aquahuna.com/collections/rasbora/products/green-neon-rasbora');
-- insert into speciesAlternateNames (speciesID, alternateName) values
-- 	('green-neon-rasbora', 'Neon Green Rasbora'),
-- 	('green-neon-rasbora', 'Kubotai Rasbora'),
-- 	('green-neon-rasbora', 'Green Rasbora');
-- insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
-- 	('green-neon-rasbora', 'flakes', 0, 1, 0, 1, 0, 1, 1);


insert into species (speciesID, categoryID, subCategoryID, commonName, scientificName, imagePath, maxLength, lifeSpanLow, lifeSpanHigh, diet) values
	('emerald-dwarf-rasbora', 'fish', 'rasbora', 'Emerald Dwarf Rasbora', 'Danio erythromicron', 'fish/rasbora/emerald-dwarf.jpg', 1, 3, 5, null);
insert into speciesSources (speciesID, source, pricePer, qtyInPack, link) values
	('emerald-dwarf-rasbora', 'AquaHuna', 3.30, 8, 'https://aquahuna.com/products/emerald-dwarf-rasbora');
insert into speciesAlternateNames (speciesID, alternateName) values
	('emerald-dwarf-rasbora', 'Emerald Dwarf Danio'),
	('emerald-dwarf-rasbora', 'Thick-band Purple Zebra Danio '),
	('emerald-dwarf-rasbora', 'Cross-banded Dwarf Rasbora'),
	('emerald-dwarf-rasbora', 'Microrasbora erythromicron');
insert into speciesFeeding (speciesID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values
	('emerald-dwarf-rasbora', 'flakes', 0, 1, 0, 1, 0, 1, 1);

