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

[websub-hub] / src / db / postgres / sql / schema / 1.0.4 / apply.sql

diff --git a/src/db/postgres/sql/schema/1.0.4/apply.sql b/src/db/postgres/sql/schema/1.0.4/apply.sql
new file mode 100644 (file)
index 0000000..514a6be
--- /dev/null
+++ b/src/db/postgres/sql/schema/1.0.4/apply.sql
@@ -0,0 +1,10 @@
+BEGIN;
+
+       ALTER TABLE topic
+               ADD COLUMN http_etag TEXT,
+               ADD COLUMN http_last_modified TEXT
+       ;
+
+       INSERT INTO _meta_schema_version (major, minor, patch) VALUES (1, 0, 4);
+
+COMMIT;
\ No newline at end of file