set @tankID = 'long-wall-b-middle-right';
set @tankGroupID = 'long-wall-b';
set @waterType = 'f';
set @substrateType = 'fs';
set @tankSizeID = '40-breeder-imagitarium';
set @sortOrder = 120;
set @url = 'middle-right';
set @photo = null;
set @label = 'Middle Right';
set @isReady = 1;
set @isCichlidTank = 0;
set @thermometerID = null;
set @heaterID = null;
set @filterPercent = 104;
set @waterChangePercent = 51;
set @stockPercent = 105;
set @tempLow = 71.6;
set @tempHigh = 77;
set @phLow = 6;
set @phHigh = 7.8;
set @hardnessLow = 5;
set @hardnessHigh = 15;
set @aqAdvisor = 'https://aqadvisor.com/AqAdvisor.php?AquTankName=&AquListBoxTank=Choose&AquTankLength=36&AquTankDepth=18&AquTankHeight=16&AquListBoxFilter=Choose&AquTextFilterRate=N%2FA+&AquListBoxFilter2=Choose&AquTextFilterRate2=N%2FA+&AquFilterString=Bristlenose+&AquListBoxChooser=Bristlenose+Pleco+%28Ancistrus+sp.%29&AquTextBoxQuantity=1&FormSubmit=Add+%3E&AquTextBoxRemoveQuantity=&AlreadySelected=200912081400%3A1%3A%3A%2C200909300249%3A4%3A%3A%2C200909300131%3A16%3A%3A%2C200909300207%3A1%3A%3A&FilterMode=Display+all+species&AqTempUnit=C&AqVolUnit=gUS&AqLengthUnit=inch&AqSortType=cname&FilterQuantity=2&AqJuvMode=&AqSpeciesWindowSize=short&AqSearchMode=simple#google_vignette';

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.5);

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

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

/* stocking */
insert into tankStocking (tankID, speciesID, pattern, planned, have, sortOrder) values (@tankID, 'three-spot-gourami', 'lavender', 1, 1, 10);
-- insert into tankStocking (tankID, speciesID, planned, have, sortOrder) values (@tankID, 'blue-acara', 1, 0, 10);

insert into tankStocking (tankID, speciesID, pattern, planned, have, sortOrder) values (@tankID, 'molly', 'dalmatian', 8, 8, 10);
insert into tankStocking (tankID, speciesID, pattern, planned, have, sortOrder) values (@tankID, 'molly', 'orange-panda', 2, 2, 10);
-- insert into tankStocking (tankID, speciesID, pattern, planned, have, sortOrder) values (@tankID, 'molly', 'marble', 2, 0, 10);
insert into tankStocking (tankID, speciesID, pattern, planned, have, sortOrder) values (@tankID, 'molly', 'platinum', 2, 0, 10);
insert into tankStocking (tankID, speciesID, pattern, planned, have, sortOrder) values (@tankID, 'molly', 'lyretail', 2, 0, 10);
insert into tankStocking (tankID, speciesID, pattern, planned, have, sortOrder) values (@tankID, 'molly', 'sailfin', 2, 0, 10);

insert into tankStocking (tankID, speciesID, planned, have, sortOrder) values (@tankID, 'siamese-algae-eater', 1, 1, 80);
-- insert into tankStocking (tankID, speciesID, planned, have, sortOrder) values (@tankID, 'tiger-loach', 1, 1, 90);
insert into tankStocking (tankID, speciesID, planned, have, sortOrder) values (@tankID, 'zebra-loach', 4, 3, 90);
insert into tankStocking (tankID, speciesID, planned, have, sortOrder) values (@tankID, 'bristlenose-pleco', 1, 0, 99);
insert into tankStocking (tankID, speciesID, pattern, planned, have, sortOrder) values (@tankID, 'snail-mystery', 'brown', 1, 1, 99);

/* feeding */

/* plants */

/* photos */
