set @tankID = 'long-wall-a-bottom-right';
set @tankGroupID = 'long-wall-a';
set @waterType = 's';
set @substrateType = 'ar,caa';
set @tankSizeID = '40-breeder-imagitarium';
set @sortOrder = 150;
set @url = 'bottom-right';
set @photo = null;
set @label = 'Bottom Right';
set @isReady = 1;
set @isCichlidTank = 0;
set @thermometerID = null;
set @heaterID = null;
set @filterPercent = 108;
set @waterChangePercent = 41;
set @stockPercent = 102;
set @tempLow = 77;
set @tempHigh = 80.6;
set @phLow = 7;
set @phHigh = 7.5;
set @hardnessLow = 6;
set @hardnessHigh = 15;
set @aqAdvisor = 'https://aqadvisor.com/AqAdvisorMarine.php?AquTankName=&AquListBoxTank=Choose&AquTankLength=36&AquTankDepth=18&AquTankHeight=16&AquFilterString=Fairy&AquListBoxChooser=Blue+and+Red+Fairy+Wrasse+%28Cirrhilabrus+rubriventralis%29&AquTextBoxQuantity=1&FormSubmit=Add+%3E&AquTextBoxRemoveQuantity=&AlreadySelected=201005041430%3A1%3A%3A%2C201005021931%3A1%3A%3A%2C201003260015%3A1%3A%3A%2C201005041424%3A1%3A%3A%2C201005041427%3A1%3A%3A%2C201003260000%3A1%3A%3A&FilterMode=Display+only+suitable+species+for+your+tank&AqTempUnit=C&AqVolUnit=gUS&AqLengthUnit=inch&AqSortType=cname&FilterQuantity=2&AqJuvMode=&AqSpeciesWindowSize=long&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, shareRatio) values (@tankID, 'beamswork-48', 50, 0.5);

/* filtration */
insert into tankFilters (tankID, filterID, tankFilterSortOrder) values (@tankID, 'tidal-55', 1);
insert into tankFilters (tankID, filterID, tankFilterSortOrder) values (@tankID, 'tidal-55', 2);
insert into tankFilters (tankID, filterID, tankFilterSortOrder) values (@tankID, 'fluval-ps1', 3);

/* 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, 'chalk-bass', 5, 0, 20);
-- insert into tankStocking (tankID, speciesID, planned, have, sortOrder) values (@tankID, 'bangai-cardinal', 5, 0, 10);
insert into tankStocking (tankID, speciesID, planned, have, sortOrder) values (@tankID, 'purple-striped-dottyback', 5, 0, 20);
insert into tankStocking (tankID, speciesID, planned, have, sortOrder) values (@tankID, 'blue-damsel', 5, 0, 24);
insert into tankStocking (tankID, speciesID, planned, have, sortOrder) values (@tankID, 'blue-and-red-fairy-wrasse', 5, 0, 28);
insert into tankStocking (tankID, speciesID, planned, have, sortOrder) values (@tankID, 'royal-gramma-basslet', 1, 0, 30);
insert into tankStocking (tankID, speciesID, planned, have, sortOrder) values (@tankID, 'firefish-goby', 1, 0, 40);
insert into tankStocking (tankID, speciesID, planned, have, sortOrder) values (@tankID, 'tail-spot-blenny', 1, 0, 50);
insert into tankStocking (tankID, speciesID, planned, have, sortOrder) values (@tankID, 'emerald-crab', 1, 0, 70);
insert into tankStocking (tankID, speciesID, planned, have, sortOrder) values (@tankID, 'hermit-crabs', 3, 0, 99);
-- insert into tankStocking (tankID, speciesID, planned, have, sortOrder) values (@tankID, 'coral-beauty-angelfish', 1, 0, 30);

/* feeding */

/* plants */

/* photos */
