2 DROP TABLE topic
CASCADE;
3 DROP TABLE topic_fetch_in_progress
CASCADE;
4 DROP TABLE subscription
CASCADE;
5 DROP TABLE subscription_delivery_in_progress
CASCADE;
6 DROP TABLE verification
CASCADE;
7 DROP TABLE verification_in_progress
CASCADE;
8 DROP TABLE authentication
CASCADE;
10 DELETE FROM _meta_schema_version
WHERE major
= 1 AND minor
= 0 AND patch
= 0;