LQPP/man half freeze short verification.sql
< LQPP
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;