git.squeep.com Git - websub-hub/blob - src/db/sqlite/sql/schema/1.0.0/revert.sql

   1 BEGIN;
   2         DROP TABLE topic;
   3         DROP VIEW topic_fetch_needed;
   4         DROP TABLE topic_fetch_in_progress;
   5         DROP VIEW topic_fetch_in_progress_active;
   6         DROP TABLE subscription;
   7         DROP VIEW subscription_delivery_needed;
   8         DROP TABLE subscription_delivery_in_progress;
   9         DROP VIEW subscription_delivery_in_progress_active;
  10         DROP TABLE verification;
  11         DROP VIEW verification_needed;
  12         DROP TABLE verification_in_progress;
  13         DROP VIEW verification_in_progress_active;
  14         DROP TABLE authentication;
  15
  16         DELETE FROM _meta_schema_version WHERE major = 1 AND minor = 0 AND patch = 0;
  17 COMMIT;