2 DROP VIEW verification_needed
;
3 CREATE VIEW verification_needed
AS
5 FROM verification v
JOIN topic t
ON v.topic_id
= t.
id
9 (v.topic_id
, v.callback
, v.created
) IN (SELECT topic_id
, callback
, max(created
) AS created
FROM verification
GROUP BY topic_id
, callback
)
11 (v.topic_id
, v.callback
) NOT IN (SELECT topic_id
, callback
FROM verification_in_progress_active
)
13 v.next_attempt
<= (strftime('%s', 'now'))
16 INSERT INTO _meta_schema_version (major
, minor
, patch
) VALUES (1, 0, 1);