set @tankID = 'tv-bottom';
set @tankGroupID = 'tv';
set @aqAdvisor = 'https://aqadvisor.com/AqAdvisor.php?AquTankName=60G+with+FX4&AquListBoxTank=Choose&AquTankLength=48.5&AquTankDepth=18.5&AquTankHeight=16&AquListBoxFilter=User+Defined&AquTextFilterRate=250+++++++++++++++++++++++++++++&AquListBoxFilter2=User+Defined&AquTextFilterRate2=50+++++++++++++++++++++++++++++&AquFilterString=bumblebee&AquListBoxChooser=Bumblebee+Catfish+SA+%28Microglanis+Iheringi%29&AquTextBoxQuantity=2&FormSubmit=Add+%3E&AquTextBoxRemoveQuantity=&AlreadySelected=200909300246%3A4%3A%3A%2C200909300186%3A1%3A%3A%2C200909300232%3A15%3A%3A%2C201001131514%3A15%3A%3A%2C200911161254%3A15%3A%3A&FilterMode=Display+all+species&AqTempUnit=F&AqVolUnit=gUS&AqLengthUnit=inch&AqSortType=cname&FilterQuantity=2&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, '60-breeder-aqueon', 30, 'bottom', null, 'Bottom', @tankGroupID, 1, 0, 'thievel-min-max', null, 203, 45, 106, 75.2, 75.2, 6.5, 7, 5, 15, @aqAdvisor);

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

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

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

/* stocking */
insert into tankStocking (tankID, speciesID, planned, have, sortOrder) values (@tankID, 'black-ruby-barb', 12, 8, 10);
insert into tankStocking (tankID, speciesID, planned, have, sortOrder) values (@tankID, 'odessa-barb', 12, 0, 20);
insert into tankStocking (tankID, speciesID, planned, have, sortOrder) values (@tankID, 'tiger-barb', 12, 10, 30);
insert into tankStocking (tankID, speciesID, planned, have, sortOrder) values (@tankID, 'siamese-algae-eater', 1, 1, 35);
insert into tankStocking (tankID, speciesID, planned, have, sortOrder) values (@tankID, 'red-tailed-black-shark', 1, 0, 40);
insert into tankStocking (tankID, speciesID, planned, have, sortOrder) values (@tankID, 'yoyo-loach', 4, 0, 50);
insert into tankStocking (tankID, speciesID, planned, have, sortOrder) values (@tankID, 'bumblebee-catfish', 1, 1, 60);
insert into tankStocking (tankID, speciesID, pattern, planned, have, sortOrder) values (@tankID, 'snail-nerite', 'black', 2, 2, 70);

/* 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, 'bugBites', 0, 1, 0, 1, 0, 1, 1);

/* plants */
insert into tankPlants (tankID, plantID) values
    (@tankID, 'rosette-sword'),
    (@tankID, 'jungle-val'),
    (@tankID, 'cryptocoryne-wendtii-bronze'),
    (@tankID, 'cryptocoryne-wendtii-red');

/* photos */
