From b9817d9f2cef0af02936b7ff728c9de64805b79a Mon Sep 17 00:00:00 2001
From: Dan White <dan@whiteaudio.com>
Date: Tue, 2 May 2023 22:12:14 -0500
Subject: [PATCH] Upgrade to v1.103 schema

---
 upgrade-db-schema_2023-05-02.sql | 13 +++++++++++++
 1 file changed, 13 insertions(+)
 create mode 100644 upgrade-db-schema_2023-05-02.sql

diff --git a/upgrade-db-schema_2023-05-02.sql b/upgrade-db-schema_2023-05-02.sql
new file mode 100644
index 0000000..36a19fc
--- /dev/null
+++ b/upgrade-db-schema_2023-05-02.sql
@@ -0,0 +1,13 @@
+-- 2023-05-02 notes
+--   (adding transmitter_unconfirmd INTEGER column)
+-- Rename table observations to observations_v1_103.
+-- Create new observations table with same columns as get-observations.py.
+-- Vacuum to cleanup.
+-- Runs of get-observations.py will fill in the NULL column.
+
+.echo on
+
+ALTER TABLE observations ADD COLUMN transmitter_unconfirmed INTEGER;
+
+VACUUM;
+
-- 
2.25.1