database migration 1.0.4, store topic fetch etag/last-modified, provide these when...

[websub-hub] / src / db / sqlite / sql / schema / 1.0.4 / revert.sql

diff --git a/src/db/sqlite/sql/schema/1.0.4/revert.sql b/src/db/sqlite/sql/schema/1.0.4/revert.sql
new file mode 100644 (file)
index 0000000..4cdf004
--- /dev/null
+++ b/src/db/sqlite/sql/schema/1.0.4/revert.sql
@@ -0,0 +1,8 @@
+BEGIN;
+
+       ALTER TABLE topic DROP COLUMN http_etag;
+       ALTER TABLE topic DROP COLUMN http_last_modified;
+
+       DELETE FROM _meta_schema_version WHERE major = 1 AND minor = 0 AND PATCH = 4;
+
+COMMIT;