set @tankID = 'entryway-middle-left';
set @tankGroupID = 'entryway';
set @aqAdvisor = 'https://aqadvisor.com/AqAdvisor.php?AquTankName=40G-MiddleLeft&AquListBoxTank=Choose&AquTankLength=36&AquTankDepth=18&AquTankHeight=16&AquListBoxFilter=User+Defined&AquTextFilterRate=55++++++++++++++++&AquListBoxFilter2=User+Defined&AquTextFilterRate2=55++++++++++++++++&AquListBoxFilter3=User+Defined&AquTextFilterRate3=50++++++++++++++++&AquFilterString=julii&AquListBoxChooser=Julii+Cory+%28Corydoras+julii%29&AquTextBoxQuantity=&AquTextBoxRemoveQuantity=4&FormSubmit=%3C+Remove&AquListBoxSelected=20+x+Von+Rio+Tetra+%28Hyphessobrycon+flammeus%29&AlreadySelected=200911171015%3A20%3A%3A%2C200909300158%3A6%3A%3A%2C200912111343%3A1%3A%3A%2C200911150130%3A12%3A%3A%2C200909300207%3A1%3A%3A%2C200909300109%3A8%3A%3A&FilterMode=Display+all+species&AqTempUnit=F&AqVolUnit=gUS&AqLengthUnit=inch&AqSortType=cname&FilterQuantity=3&AqJuvMode=&AqSpeciesWindowSize=short&AqSearchMode=simple';

insert into tanks (tankID, tankSizeID, sortOrder, url, photo, label, tankGroupID, isReady, isCichlidTank, thermometerID, heaterID, filterPercent, waterChangePercent, stockPercent, tempLow, tempHigh, phLow, phHigh, hardnessLow, hardnessHigh, aqAdvisor)
    values (@tankID, '40-breeder-aqueon', 40, 'middle-left', null, 'Middle Left', @tankGroupID, 1, 0, 'thievel-min-max', null, 145, 47, 113, 77, 80.6, 6, 7.5, 5, 15, @aqAdvisor);

/* lighting */
insert into tankLights (tankID, lightID, intensity) values (@tankID, 'beamswork-30', 40);

/* filtration */
insert into tankFilters (tankID, filterID, tankFilterSortOrder) values (@tankID, 'tidal-55', 1);
insert into tankFilters (tankID, filterID, tankFilterSortOrder) values (@tankID, 'dvhey-80-gallon-sponge', 2);

/* pumps */
insert into airPumpGroupTanks (airPumpGroupID, tankID, sponge) values ('entryway-pump2', @tankID, 'main');

/* stocking */
insert into tankStocking (tankID, speciesID, planned, have, sortOrder) values (@tankID, 'pearl-gourami', 3, 3, 10);
insert into tankStocking (tankID, speciesID, planned, have, sortOrder) values (@tankID, 'cochu-blue-tetra', 12, 12, 20);
insert into tankStocking (tankID, speciesID, planned, have, sortOrder) values (@tankID, 'von-rio-tetra', 16, 8, 30);
insert into tankStocking (tankID, speciesID, planned, have, sortOrder) values (@tankID, 'siamese-algae-eater', 1, 1, 25);
insert into tankStocking (tankID, speciesID, planned, have, sortOrder) values (@tankID, 'julii-corydoras', 8, 5, 40);
insert into tankStocking (tankID, speciesID, pattern, planned, have, sortOrder) values (@tankID, 'bristlenose-pleco', 'albino', 1, 1, 50);
insert into tankStocking (tankID, speciesID, pattern, planned, have, sortOrder) values (@tankID, 'snail-nerite', 'red-spotted', 1, 1, 70);
insert into tankStocking (tankID, speciesID, pattern, planned, have, sortOrder) values (@tankID, 'snail-nerite', 'zebra', 1, 1, 70);
insert into tankStocking (tankID, speciesID, pattern, planned, have, sortOrder) values (@tankID, 'snail-mystery', 'brown', 1, 1, 99);

/* feeding */
-- insert into tankFeeding (tankID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values (@tankID, 'flakes', 0, 1, 0, 1, 0, 1, 1);
-- insert into tankFeeding (tankID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values (@tankID, 'wafers', 0, 0, 0, 1, 0, 0, 1);

/* plants */
insert into tankPlants (tankID, plantID) values
    (@tankID, 'cabomba-caroliniana'),
    (@tankID, 'water-wisteria'),
    (@tankID, 'cryptocoryne-wendtii-red'),
    (@tankID, 'cryptocoryne-parva');

/* photos */
