2 CREATE OR REPLACE VIEW verification_needed
AS
6 (topic_id
, callback
, created
) IN (SELECT topic_id
, callback
, max(created
) AS created
FROM verification
GROUP BY topic_id
, callback
)
8 (topic_id
, callback
) NOT IN (SELECT topic_id
, callback
FROM verification_in_progress_active
)
13 DELETE FROM _meta_schema_version
WHERE major
= 1 AND minor
= 0 AND patch
= 1;