LQPP/man half freeze short verification.sql

BEGIN;

UPDATE issue SET verification_time='13 days' WHERE issue.policy_id IN (1,2,3) AND accepted NOTNULL AND half_frozen ISNULL AND closed ISNULL;
UPDATE issue SET half_frozen=now() WHERE issue.policy_id IN (1,2,3) AND accepted NOTNULL AND half_frozen ISNULL AND closed ISNULL;

COMMIT;