set @tankID = 'entryway-top-center';
set @tankGroupID = 'entryway';
set @aqAdvisor = 'https://aqadvisor.com/AqAdvisor.php?AquTankName=entryway-top-center&AquListBoxTank=Choose&AquTankLength=30&AquTankDepth=12&AquTankHeight=12&AquListBoxFilter=User+Defined&AquTextFilterRate=55&AquListBoxFilter2=User+Defined&AquTextFilterRate2=40&FormSubmit=Update&AquFilterString=hillstream&AquListBoxChooser=Hillstream+Loach+%28Gastromyzon+ctenocephalus%29&AquTextBoxQuantity=&AquTextBoxRemoveQuantity=&AlreadySelected=200909300022%3A8%3A%3A%2C200912051332%3A8%3A%3A%2C200909300153%3A1%3A%3A%2C200909300212%3A6%3A%3A%2C200909300113%3A1%3A%3A%2C200909300097%3A1%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, '20-long-aqueon', 20, 'top-center', null, 'Top Center', @tankGroupID, 1, 0, 'thievel-min-max', null, 209, 46, 102, 75.2, 75.2, 7, 7.5, 5, 15, @aqAdvisor);

/* lighting */
insert into tankLights (tankID, lightID, intensity) values (@tankID, 'aquaneat-30-38', 100);

/* filtration */
insert into tankFilters (tankID, filterID, tankFilterSortOrder) values (@tankID, 'tidal-55', 1);
insert into tankFilters (tankID, filterID, tankFilterSortOrder) values (@tankID, 'aquaneat-corner-double-sponge', 2);

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

/* stocking */
insert into tankStocking (tankID, speciesID, pattern, planned, have, sortOrder) values (@tankID, 'skirt-tetra', 'white', 8, 6, 20);
insert into tankStocking (tankID, speciesID, pattern, planned, have, sortOrder) values (@tankID, 'skirt-tetra', 'black', 8, 6, 20);
insert into tankStocking (tankID, speciesID, planned, have, sortOrder) values (@tankID, 'kribensis', 1, 1, 35);
insert into tankStocking (tankID, speciesID, planned, have, sortOrder) values (@tankID, 'skunk-corydoras', 4, 0, 40);
insert into tankStocking (tankID, speciesID, planned, have, sortOrder) values (@tankID, 'otocinclus', 1, 1, 50);
-- insert into tankStocking (tankID, speciesID, planned, have, sortOrder) values (@tankID, 'hillstream-loach', 1, 0, 60);
insert into tankStocking (tankID, speciesID, planned, have, sortOrder) values (@tankID, 'clown-pleco', 1, 0, 60);

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

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

/* photos */
