-- insert into tankSizes (tankSizeID, abbreviation, length, width, height, gallonsCommon, manufacturerID, link) values ('2.5-imagitarium',               '', 12.2,  6.14,    9.09,  2.5, 'imagitarium', NULL);
insert into tankSizes (tankSizeID, abbreviation, length, width, height, gallonsCommon, manufacturerID, link) values ('5.5-aqueon',                    '', 16.5,  8.75,   10.75,  5.5, 'aqueon', NULL);
insert into tankSizes (tankSizeID, abbreviation, length, width, height, gallonsCommon, manufacturerID, link) values ('5.5-imagitarium',               '', 16.18, 8.42,   10.47,  5.5, 'imagitarium', NULL);
insert into tankSizes (tankSizeID, abbreviation, length, width, height, gallonsCommon, manufacturerID, link) values ('10-aqueon',                     '', 20.25, 10.5,   12.625, 10,  'aqueon', NULL);
insert into tankSizes (tankSizeID, abbreviation, length, width, height, gallonsCommon, manufacturerID, link) values ('10-imagitarium',                '', 20.15, 10.19,  12.75,  10,  'imagitarium', NULL);
insert into tankSizes (tankSizeID, abbreviation, length, width, height, gallonsCommon, manufacturerID, link) values ('20-long-aqueon',                '20L', 30.25,  12.5, 12.75,     20,  'aqueon', NULL);
-- insert into tankSizes (tankSizeID, abbreviation, length, width, height, gallonsCommon, manufacturerID, link) values ('20-long-imagitarium',           '', 30.19, 12.4,   14.13,  20,  'imagitarium', NULL);
-- insert into tankSizes (tankSizeID, abbreviation, length, width, height, gallonsCommon, manufacturerID, link) values ('20-long-imagitarium-halved',    '', 15.1,  12.4,   14.13,  10,  'imagitarium', NULL);
insert into tankSizes (tankSizeID, abbreviation, length, width, height, gallonsCommon, manufacturerID, link) values ('20-tall-aqueon',                '20T', 24.25, 12.5,   16.75,  20,  'aqueon', NULL);
insert into tankSizes (tankSizeID, abbreviation, length, width, height, gallonsCommon, manufacturerID, link) values ('28-shallow-imagitarium',        '28S', 32.00, 15.87,  13.66,  28,  'imagitarium', NULL);
insert into tankSizes (tankSizeID, abbreviation, length, width, height, gallonsCommon, manufacturerID, link) values ('40-breeder-aqueon',             '40B', 36.19, 18.25,  16.94,  40,  'aqueon', NULL);
insert into tankSizes (tankSizeID, abbreviation, length, width, height, gallonsCommon, manufacturerID, link) values ('40-breeder-imagitarium',        '40B', 36.33, 18.34,  15.9,   40,  'imagitarium', NULL);
insert into tankSizes (tankSizeID, abbreviation, length, width, height, gallonsCommon, manufacturerID, link) values ('40-breeder-imagitarium-halved', '40B (1/2)', 18.16, 18.34,  15.9,   20,  'imagitarium', NULL);
insert into tankSizes (tankSizeID, abbreviation, length, width, height, gallonsCommon, manufacturerID, link) values ('60-breeder-aqueon',             '60B', 48.5,  18.5,   16,     60,  'aqueon', NULL);
insert into tankSizes (tankSizeID, abbreviation, length, width, height, gallonsCommon, manufacturerID, link) values ('60-breeder-imagitarium',        '60B', 48.03, 18.03,  18.15,  60,  'imagitarium', NULL);
insert into tankSizes (tankSizeID, abbreviation, length, width, height, gallonsCommon, manufacturerID, link) values ('75-aqueon',                     '', 49,    19.5,   21.25,  75,  'aqueon', NULL);
insert into tankSizes (tankSizeID, abbreviation, length, width, height, gallonsCommon, manufacturerID, link) values ('75-marineland',                 '', 49,    19.5,   21.25,  75,  'marineland', NULL);
insert into tankSizes (tankSizeID, abbreviation, length, width, height, gallonsCommon, manufacturerID, link) values ('90-glasscages',                 '', 49,    19.5,   24.25,  90,  'glasscages', NULL);
insert into tankSizes (tankSizeID, abbreviation, length, width, height, gallonsCommon, manufacturerID, link) values ('125-naa',                       '', 72,    18,     22,     125, 'naa', NULL);
insert into tankSizes (tankSizeID, abbreviation, length, width, height, gallonsCommon, manufacturerID, link) values ('180-acrylic',                   '', 72,    24,     24,     180, 'unknown', NULL);
insert into tankSizes (tankSizeID, abbreviation, length, width, height, gallonsCommon, manufacturerID, link) values ('tsunami-72x48x24',              '', 72,    48,     24,     360, 'tsunami','https://fishtanksdirect.com/tsunami-330-gallon-72lx48wx24h-acrylic-aquarium/');


update tankSizes set gallonsExact = round(length * width * height / 231, 2);
