set @tankID = 'divider-desk-top';
set @tankGroupID = 'divider';
set @waterType = 'f';
set @tankSizeID = '125-naa';
set @sortOrder = 10;
set @url = 'top';
set @photo = null;
set @label = 'Desk, Top';
set @isReady = 1;
set @isCichlidTank = 0;
set @substrateType = 'fs';
set @thermometerID = 'thievel-min-max';
set @heaterID = null;
set @filterPercent = 122;
set @waterChangePercent = 40;
set @stockPercent = 120;
set @tempLow = 77;
set @tempHigh = 77;
set @phLow = 6;
set @phHigh = 7.5;
set @hardnessLow = 5;
set @hardnessHigh = 15;
set @aqAdvisor = 'https://aqadvisor.com/AqAdvisor.php?AquTankName=Top&AquListBoxTank=Choose&AquTankLength=72&AquTankDepth=18&AquTankHeight=22&AquListBoxFilter=User+Defined&AquTextFilterRate=110++++++++++++&AquListBoxFilter2=User+Defined&AquTextFilterRate2=110++++++++++++&AquListBoxFilter3=User+Defined&AquTextFilterRate3=50++++++++++++&AquListBoxFilter4=User+Defined&AquTextFilterRate4=50++++++++++++&AquFilterString=Phantom+&AquListBoxChooser=Green+Phantom+Pleco+%28Hemiancistrus+subviridis+L200%29&AquTextBoxQuantity=&AquTextBoxRemoveQuantity=&FormSubmit=%3C+Remove&AquListBoxSelected=1+x+Bristlenose+Pleco+%28Ancistrus+sp.%29&AlreadySelected=200910160234%3A3%3A%3A%2C201001041370%3A3%3A%3A%2C200909300207%3A1%3A%3A%2C200909300231%3A1%3A%3A%2C200909300080%3A8%3A%3A%2C200909300033%3A1%3A%3A%2C201006201234%3A1%3A%3A&FilterMode=Display+all+species&AqTempUnit=F&AqVolUnit=gUS&AqLengthUnit=inch&AqSortType=cname&FilterQuantity=4&AqJuvMode=&AqSpeciesWindowSize=short&AqSearchMode=simple';


insert into tanks (tankID, waterType, tankSizeID, sortOrder, url, photo, label, tankGroupID, isReady, substrateType, isCichlidTank, thermometerID, heaterID, filterPercent, waterChangePercent, stockPercent, tempLow, tempHigh, phLow, phHigh, hardnessLow, hardnessHigh, aqAdvisor)
    values (@tankID, @waterType, @tankSizeID, @sortOrder, @url, @photo, @label, @tankGroupID, @isReady, @substrateType, @isCichlidTank, @thermometerID, @heaterID, @filterPercent, @waterChangePercent, @stockPercent, @tempLow, @tempHigh, @phLow, @phHigh, @hardnessLow, @hardnessHigh, @aqAdvisor);

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

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

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

/* stocking */
insert into tankStocking (tankID, speciesID, planned, have, sortOrder) values (@tankID, 'giant-danio', 8, 8, 1);
insert into tankStocking (tankID, speciesID, planned, have, sortOrder) values (@tankID, 'three-spot-gourami', 1, 1, 2);
insert into tankStocking (tankID, speciesID, planned, have, sortOrder) values (@tankID, 'siamese-algae-eater', 1, 1, 3);
insert into tankStocking (tankID, speciesID, planned, have, sortOrder) values (@tankID, 'senegal-bichir', 3, 3, 4);
insert into tankStocking (tankID, speciesID, planned, have, sortOrder) values (@tankID, 'ropefish', 3, 3, 5);
insert into tankStocking (tankID, speciesID, planned, have, sortOrder) values (@tankID, 'blue-phantom-pleco', 1, 1, 6);

/* 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, 'shrimpPellets', 0, 1, 0, 1, 0, 1, 1);
-- insert into tankFeeding (tankID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values (@tankID, 'frozen', 0, 1, 0, 1, 0, 1, 0);

/* plants */
insert into tankPlants (tankID, plantID) values
    (@tankID, 'amazon-sword'),
    (@tankID, 'anubias-barteri'),
    (@tankID, 'cabomba-caroliniana'),
    (@tankID, 'water-wisteria'),
    (@tankID, 'brazilian-pennywort'),
    (@tankID, 'cryptocoryne-wendtii-green');

/* photos */
