set @tankID = 'quarantine-bottom-left';
set @tankGroupID = 'quarantine';
set @aqAdvisor = '';

insert into tanks (tankID, isQuarantineTank, tankSizeID, sortOrder, url, photo, label, tankGroupID, isReady, isCichlidTank, thermometerID, heaterID, filterPercent, waterChangePercent, stockPercent, tempLow, tempHigh, phLow, phHigh, hardnessLow, hardnessHigh, aqAdvisor)
    values (@tankID, 1, '40-breeder-imagitarium', 200, 'bottom-left', null, 'Bottom Left', @tankGroupID, 1, 0, null, null, 0, 0, 0, 0, 0, 0, 0, 0, 0, @aqAdvisor);

-- -- update tanks set quarantineStartDate=null where tankID=@tankID;
-- update tanks set quarantineStartDate=str_to_date("2025-09-14", "%Y-%m-%d") where tankID=@tankID;

/* lighting */
insert into tankLights (tankID, lightID, intensity, shareRatio) values (@tankID, 'aquaneat-48', 100, 0.5);

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

/* pumps */
insert into airPumpGroupTanks (airPumpGroupID, tankID, sponge) values ('quarantine-pump3', @tankID, 'left' );
insert into airPumpGroupTanks (airPumpGroupID, tankID, sponge) values ('quarantine-pump3', @tankID, 'right' );

/* stocking */
/* MOVED TO CONSOLIDATED FILE!!!! */

/* feeding */
-- insert into tankFeeding (tankID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values (@tankID, 'flakes', 0, 1, 0, 1, 0, 1, 1);

/* plants */
insert into tankPlants (tankID, plantID) values
    (@tankID, 'pothos');

/* photos */
