2 DROP VIEW verification_needed
;
3 CREATE VIEW verification_needed
AS
7 (topic_id
, callback
, created
) IN (SELECT topic_id
, callback
, max(created
) AS created
FROM verification
GROUP BY topic_id
, callback
)
9 (topic_id
, callback
) NOT IN (SELECT topic_id
, callback
FROM verification_in_progress_active
)
11 next_attempt
<= (strftime('%s', 'now'))
14 DELETE FROM _meta_schema_version
WHERE major
= 1 AND minor
= 0 AND patch
= 1;