Mercurial > gemma

changeset 5673:689f55d73bf0 sr-v2

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Extend schema to hold version of the mesh_index.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Sat, 10 Feb 2024 14:58:39 +0100
parents 4bfcbb747768
children e54635c20d43
files schema/gemma.sql schema/updates/1473/01.sr_v2.sql schema/version.sql
diffstat 3 files changed, 4 insertions(+), 1 deletions(-) [+]
line wrap: on
line diff
--- 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
     )
--- /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;
--- 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);