set @tankID = 'tower-middle-center';
set @tankGroupID = 'tower';
set @waterType = 'f';
set @substrateType = 'ar';
set @tankSizeID = '5.5-imagitarium';
set @sortOrder = 50;
set @url = 'middle-center';
set @photo = null;
set @label = 'Middle Center';
set @isReady = 0;
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 = '';

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, 'asoko-led-strip-12w', 100, 0.17);

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

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

/* stocking */
insert into tankStocking (tankID, speciesID, planned, have, sortOrder) values (@tankID, 'mexican-dwarf-crayfish-blue', 1, 1, 10);

/* plants */
-- insert into tankPlants (tankID, plantID) values
--     (@tankID, 'anubias-barteri'),
--     (@tankID, 'cryptocoryne-wendtii-red');

/* photos */
