From 319a0a0f0cf9f67d9ffebc32dc9aac580255c521 Mon Sep 17 00:00:00 2001
From: Dan White <dan@whiteaudio.com>
Date: Thu, 12 Dec 2024 11:52:32 -0600
Subject: [PATCH] Upgrade observations.db to v1.119

---
 upgrade-db-schema_2024-12-12.sql | 10 ++++++++++
 1 file changed, 10 insertions(+)
 create mode 100644 upgrade-db-schema_2024-12-12.sql

diff --git a/upgrade-db-schema_2024-12-12.sql b/upgrade-db-schema_2024-12-12.sql
new file mode 100644
index 0000000..6a28065
--- /dev/null
+++ b/upgrade-db-schema_2024-12-12.sql
@@ -0,0 +1,10 @@
+-- 2024-12-12 notes
+--   (adding tle_source TEXT column) added in v1.119 release
+-- Add new column to observations table.
+-- NB: DB columns are not created in the same order.
+
+.echo on
+
+ALTER TABLE observations ADD COLUMN tle_source TEXT;
+
+
-- 
2.25.1