set @tankID = 'long-wall-b-bottom-right-l';
set @tankGroupID = 'long-wall-b';
set @waterType = 'f';
set @substrateType = 'fs';
set @tankSizeID = '40-breeder-imagitarium-halved';
set @sortOrder = 140;
set @url = 'bottom-right-l';
set @photo = null;
set @label = 'Bottom Right (L)';
set @isReady = 1;
set @isCichlidTank = 0;
set @thermometerID = null;
set @heaterID = null;
set @filterPercent = 0;
set @waterChangePercent = 0;
set @stockPercent = 0;
set @tempLow = 0;
set @tempHigh = 0;
set @phLow = 0;
set @phHigh = 0;
set @hardnessLow = 0;
set @hardnessHigh = 0;
set @aqAdvisor = 'https://aqadvisor.com/AqAdvisor.php?AquTankName=&AquListBoxTank=Choose&AquTankLength=18&AquTankDepth=16&AquTankHeight=16&AquListBoxFilter=User+Defined&AquTextFilterRate=50+++&AquListBoxFilter2=User+Defined&AquTextFilterRate2=50+++&AquFilterString=crayfish&AquTextBoxQuantity=&AquTextBoxRemoveQuantity=5&FormSubmit=%3C+Remove&AquListBoxSelected=15+x+Guppy+%28Poecilia+reticulata%29&AlreadySelected=200911030934%3A1%3A%3A%2C200909300093%3A15%3A%3A&FilterMode=Display+only+suitable+species+for+your+tank&AqTempUnit=F&AqVolUnit=gUS&AqLengthUnit=inch&AqSortType=cname&FilterQuantity=2&AqJuvMode=&AqSpeciesWindowSize=short&AqSearchMode=simple';

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

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

/* 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 ('double-rack-pump-middle', @tankID, 'main');

/* stocking */
insert into tankStocking (tankID, speciesID, planned, have, sortOrder) values (@tankID, 'forktail-rainbowfish', 3, 3, 4);
insert into tankStocking (tankID, speciesID, planned, have, sortOrder) values (@tankID, 'ember-tetra', 10, 1, 8);
-- insert into tankStocking (tankID, speciesID, planned, have, sortOrder) values (@tankID, 'ember-tetra', 2, 0, 5);
-- insert into tankStocking (tankID, speciesID, planned, have, sortOrder) values (@tankID, 'shrimp-vampire', 2, 0, 10);
insert into tankStocking (tankID, speciesID, planned, have, sortOrder) values (@tankID, 'shrimp-bamboo', 2, 2, 20);
insert into tankStocking (tankID, speciesID, planned, have, sortOrder) values (@tankID, 'shrimp-amano', 3, 3, 30);
insert into tankStocking (tankID, speciesID, pattern, planned, have, sortOrder) values (@tankID, 'shrimp-neo', 'red-cherry', 1, 1, 40);
insert into tankStocking (tankID, speciesID, pattern, planned, have, sortOrder) values (@tankID, 'shrimp-neo', 'blue-dream', 1, 1, 40);
insert into tankStocking (tankID, speciesID, planned, have, sortOrder) values (@tankID, 'shrimp-ghost', 1, 1, 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, 'shrimpPellets', 0, 1, 0, 1, 0, 1, 0);
-- insert into tankFeeding (tankID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values (@tankID, 'crabFood', 0, 0, 0, 0, 0, 0, 1);

/* plants */

/* photos */
