set @tankID = 'gallery';
set @waterType = 'f';
set @tankSizeID = '180-acrylic';
set @sortOrder = 10;
set @url = 'main';
set @photo = null;
set @label = 'Main';
set @tankGroupID = 'gallery';
set @isReady = 1;
set @isCichlidTank = 0;
set @substrateType = 'fs';
set @thermometerID = null;
set @heaterID = null;
set @filterPercent = 0;
set @waterChangePercent = 48;
set @stockPercent = 127;
set @tempLow = 71.8;
set @tempHigh = 73.4;
set @phLow = 6.5;
set @phHigh = 7.5;
set @hardnessLow = 5;
set @hardnessHigh = 15;
set @aqAdvisor = 'https://aqadvisor.com/AqAdvisor.php?AquTankName=&AquListBoxTank=Choose&AquTankLength=72&AquTankDepth=24&AquTankHeight=24&AquListBoxFilter=Choose&AquTextFilterRate=N%2FA+&AquListBoxFilter2=Choose&AquTextFilterRate2=N%2FA+&AquFilterString=Siamese&AquListBoxChooser=Siamese+Algae+Eater+%28Crossocheilus+siamensis%29&AquTextBoxQuantity=&AquTextBoxRemoveQuantity=&FormSubmit=%3C+Remove&AquListBoxSelected=1+x+Green+Phantom+Pleco+%28Hemiancistrus+subviridis+L200%29&AlreadySelected=200909300223%3A6%3A%3A%2C201006201234%3A1%3A%3A%2C200909300030%3A12%3A%3A%2C200909300009%3A1%3A%3A%2C200909300207%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, 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);
insert into tankLights (tankID, lightID, intensity) values (@tankID, 'beamswork-72', 50);

/* filtration */
insert into tankFilters (tankID, filterID, tankFilterSortOrder) values (@tankID, 'sump-75', 1);
insert into tankFilters (tankID, filterID, tankFilterSortOrder) values (@tankID, 'sump-return-pump-35', 2);
insert into tankFilters (tankID, filterID, tankFilterSortOrder) values (@tankID, 'sump-return-pump-35', 3);

/* pumps */

/* stocking */
insert into tankStocking (tankID, speciesID, planned, have, sortOrder) values (@tankID, 'comet-goldfish-white', 1, 0, 1);
insert into tankStocking (tankID, speciesID, planned, have, sortOrder) values (@tankID, 'shubunkin-goldfish', 12, 0, 12);
-- insert into tankStocking (tankID, speciesID, planned, have, sortOrder) values (@tankID, 'calico-veiltail-goldfish', 8, 0, 15);
insert into tankStocking (tankID, speciesID, planned, have, sortOrder) values (@tankID, 'siamese-algae-eater', 1, 0, 20);
insert into tankStocking (tankID, speciesID, planned, have, sortOrder) values (@tankID, 'hoplo-catfish', 6, 0, 50);
insert into tankStocking (tankID, speciesID, planned, have, sortOrder) values (@tankID, 'bristlenose-pleco', 1, 0, 90);
insert into tankStocking (tankID, speciesID, planned, have, sortOrder) values (@tankID, 'common-pleco', 1, 0, 99);

/* feeding */

/* plants */

/* photos */
