# HG changeset patch
# User Sascha L. Teichmann <sascha.teichmann@intevation.de>
# Date 1707573519 -3600
# Node ID 689f55d73bf0094eae44505593df29f8a655e0a4
# Parent  4bfcbb7477687dd626d0e13934fda6faaa230a3e
Extend schema to hold version of the mesh_index.

diff -r 4bfcbb747768 -r 689f55d73bf0 schema/gemma.sql
--- a/schema/gemma.sql	Fri Dec 15 18:17:40 2023 +0100
+++ b/schema/gemma.sql	Sat Feb 10 14:58:39 2024 +0100
@@ -811,6 +811,7 @@
         depth_reference varchar NOT NULL, -- REFERENCES depth_references,
         zpg_exception bool NOT NULL DEFAULT FALSE, -- Found no LDC in ZPG case.
         mesh_checksum varchar,
+        mesh_index_version int,
         mesh_index bytea,
         staging_done boolean NOT NULL DEFAULT false
     )
diff -r 4bfcbb747768 -r 689f55d73bf0 schema/updates/1473/01.sr_v2.sql
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/schema/updates/1473/01.sr_v2.sql	Sat Feb 10 14:58:39 2024 +0100
@@ -0,0 +1,2 @@
+ALTER TABLE waterway.sounding_results
+    ADD COLUMN mesh_index_version int;
diff -r 4bfcbb747768 -r 689f55d73bf0 schema/version.sql
--- a/schema/version.sql	Fri Dec 15 18:17:40 2023 +0100
+++ b/schema/version.sql	Sat Feb 10 14:58:39 2024 +0100
@@ -1,1 +1,1 @@
-INSERT INTO gemma_schema_version(version) VALUES (1472);
+INSERT INTO gemma_schema_version(version) VALUES (1473);