set @tankID = 'quarantine-top-1';
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, '10-imagitarium', 10, 'top-1', null, 'Top 1', @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, 'asoko-led-strip-18w', 100, 0.17);

/* filtration */
insert into tankFilters (tankID, filterID, tankFilterSortOrder) values (@tankID, 'aquaneat-corner-double-sponge', 1);

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

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

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

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

/* photos */
