Initial release

[websub-hub] / src / db / postgres / sql / schema / 1.0.0 / revert.sql

diff --git a/src/db/postgres/sql/schema/1.0.0/revert.sql b/src/db/postgres/sql/schema/1.0.0/revert.sql
new file mode 100644 (file)
index 0000000..5e22ed0
--- /dev/null
+++ b/src/db/postgres/sql/schema/1.0.0/revert.sql
@@ -0,0 +1,11 @@
+BEGIN;
+       DROP TABLE topic CASCADE;
+       DROP TABLE topic_fetch_in_progress CASCADE;
+       DROP TABLE subscription CASCADE;
+       DROP TABLE subscription_delivery_in_progress CASCADE;
+       DROP TABLE verification CASCADE;
+       DROP TABLE verification_in_progress CASCADE;
+       DROP TABLE authentication CASCADE;
+
+       DELETE FROM _meta_schema_version WHERE major = 1 AND minor = 0 AND patch = 0;
+COMMIT;