update tanks set quarantineStartDate=null;
-- update tanks set quarantineStartDate=null where tankID='quarantine-bottom-right';

update tanks set quarantineStartDate=str_to_date("2025-09-14", "%Y-%m-%d") where tankID in (
    -- 'quarantine-top-1',
    -- 'quarantine-top-2',
    -- 'quarantine-top-3',
    -- 'quarantine-top-4',
    -- 'quarantine-top-5',
    -- 'quarantine-top-6',
    -- 'quarantine-top-7',
    -- 'quarantine-top-8',
    -- 'quarantine-top-9',
    -- 'quarantine-bottom-left',
    -- 'quarantine-bottom-right',
    ''
);


-- insert into tankStocking (tankID, speciesID, planned, have, moveToAfterQuarantine) values ('quarantine-top-1', 'swordtail-pineapple', 1, 1, 'entryway-bottom-right');

-- insert into tankStocking (tankID, speciesID, planned, have, moveToAfterQuarantine) values ('quarantine-top-2', 'tiger-barb', 2, 2, 'tower-bottom');

-- insert into tankStocking (tankID, speciesID, planned, have, moveToAfterQuarantine) values ('quarantine-top-3', 'swordtail-red-velvet', 1, 1, 'entryway-bottom-right');

-- insert into tankStocking (tankID, speciesID, planned, have, moveToAfterQuarantine) values ('quarantine-top-4', 'swordtail-red-wag', 1, 1, 'entryway-bottom-right');

-- insert into tankStocking (tankID, speciesID, planned, have, moveToAfterQuarantine) values ('quarantine-top-5', 'julii-corydoras', 3, 3, 'entryway-middle-left');

-- insert into tankStocking (tankID, speciesID, planned, have, moveToAfterQuarantine) values ('quarantine-top-6', 'julii-corydoras', 2, 2, 'entryway-middle-left');

-- insert into tankStocking (tankID, speciesID, planned, have, moveToAfterQuarantine) values ('quarantine-top-7', 'cherry-barbs', 0, 0, 'tv-top-left-new');

-- insert into tankStocking (tankID, speciesID, planned, have, moveToAfterQuarantine) values ('quarantine-top-8', 'sparkling-gourami', 2, 2, 'tower-top-left');

-- insert into tankStocking (tankID, speciesID, planned, have, moveToAfterQuarantine) values ('quarantine-top-9', 'sparkling-gourami', 2, 2, 'tower-top-left');

-- insert into tankStocking (tankID, speciesID, planned, have, moveToAfterQuarantine) values ('quarantine-bottom-left', 'black-ruby-barb', 8, 8, 'tower-bottom');
-- insert into tankStocking (tankID, speciesID, planned, have, moveToAfterQuarantine) values ('quarantine-bottom-left', 'striped-raphael-catfish', 2, 2, 'divider-closet-bottom-left');

-- insert into tankStocking (tankID, speciesID, planned, have, moveToAfterQuarantine) values ('quarantine-bottom-right', 'synodontis-petricola', 2, 2, 'divider-closet-top-right');
