set @tankID = 'divider-closet-top-right';
set @tankGroupID = 'divider';
set @waterType = 'f';
set @tankSizeID = '75-aqueon';
set @sortOrder = 50;
set @url = 'top-right';
set @photo = null;
set @label = 'Closet, Top Right';
set @isReady = 1;
set @isCichlidTank = 0;
set @substrateType = 'fs,cec,csn,gpg';
set @thermometerID = 'thievel-min-max';
set @heaterID = null;
set @filterPercent = 117;
set @waterChangePercent = 46;
set @stockPercent = 126;
set @tempLow = 75.2;
set @tempHigh = 80.6;
set @phLow = 7.6;
set @phHigh = 7.8;
set @hardnessLow = 10;
set @hardnessHigh = 15;
set @aqAdvisor = 'https://aqadvisor.com/AqAdvisor.php?AquTankName=TopRight&AquListBoxTank=Choose&AquTankLength=48&AquTankDepth=18&AquTankHeight=20&AquListBoxFilter=User+Defined&AquTextFilterRate=110&AquListBoxFilter2=User+Defined&AquTextFilterRate2=50&AquListBoxFilter3=User+Defined&AquTextFilterRate3=50&FormSubmit=Update&AquFilterString=Elongatus&AquListBoxChooser=Pseudotropheus+Elongatus+%28Pseudotropheus+elongatus%29&AquTextBoxQuantity=&AquTextBoxRemoveQuantity=&AlreadySelected=200909300224%3A4%3A%3A%2C200909300243%3A6%3A%3A%2C200909300033%3A1%3A%3A%2C200909300166%3A6%3A%3A%2C200909300169%3A6%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, 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-48', 50);

/* 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);
insert into tankFilters (tankID, filterID, tankFilterSortOrder) values (@tankID, 'aco-powerhead', 3);

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

/* stocking */
insert into tankStocking (tankID, speciesID, planned, have, sortOrder) values (@tankID, 'pseudotropheus-elongatus', 6, 0, 10);
insert into tankStocking (tankID, speciesID, planned, have, sortOrder) values (@tankID, 'yellow-lab-mbuna', 6, 0, 20);
insert into tankStocking (tankID, speciesID, planned, have, sortOrder) values (@tankID, 'yellow-tail-acei', 6, 0, 30);
-- insert into tankStocking (tankID, speciesID, planned, have, sortOrder, isTemporary, moveToAfterQuarantine) values (@tankID, 'siamese-algae-eater', 1, 1, 40, 1, 'entryway-middle-left');
-- insert into tankStocking (tankID, speciesID, planned, have, sortOrder, isTemporary, moveToAfterQuarantine) values (@tankID, 'siamese-algae-eater', 1, 1, 40, 1, 'entryway-middle-right');
-- insert into tankStocking (tankID, speciesID, planned, have, sortOrder, isTemporary, moveToAfterQuarantine) values (@tankID, 'siamese-algae-eater', 1, 1, 40, 1, 'entryway-bottom-left');
-- insert into tankStocking (tankID, speciesID, planned, have, sortOrder, isTemporary, moveToAfterQuarantine) values (@tankID, 'siamese-algae-eater', 1, 1, 40, 1, 'divider-closet-bottom-left');
-- insert into tankStocking (tankID, speciesID, planned, have, sortOrder, isTemporary, moveToAfterQuarantine) values (@tankID, 'siamese-algae-eater', 1, 1, 40, 1, 'divider-closet-bottom-right');
-- insert into tankStocking (tankID, speciesID, planned, have, sortOrder, isTemporary, moveToAfterQuarantine) values (@tankID, 'siamese-algae-eater', 1, 1, 40, 1, 'long-wall-b-middle-right');
-- insert into tankStocking (tankID, speciesID, planned, have, sortOrder, isTemporary, moveToAfterQuarantine) values (@tankID, 'siamese-algae-eater', 1, 1, 40, 1, 'tv-bottom');
insert into tankStocking (tankID, speciesID, planned, have, sortOrder) values (@tankID, 'siamese-algae-eater', 1, 1, 40);
-- insert into tankStocking (tankID, speciesID, planned, have, sortOrder, isTemporary) values (@tankID, 'siamese-algae-eater', 1, 1, 40, 1);
insert into tankStocking (tankID, speciesID, planned, have, sortOrder) values (@tankID, 'synodontis-petricola', 7, 7, 50);
insert into tankStocking (tankID, speciesID, pattern, planned, have, sortOrder) values (@tankID, 'bristlenose-pleco', 'super-red', 1, 0, 60);
insert into tankStocking (tankID, speciesID, pattern, planned, have, sortOrder) values (@tankID, 'snail-mystery', 'blue', 1, 1, 99);
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, 1, 0, 1, 0, 1, 1);

/* plants */

/* photos */
