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

   1 BEGIN;
   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;
   9
  10         DELETE FROM _meta_schema_version WHERE major = 1 AND minor = 0 AND patch = 0;
  11 COMMIT;