Mercurial > gemma

diff schema/updates/0000/01.add_schema_version.sql @ 3978:7b7c324b318f

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Added database schema versioning and db update script.
author Sascha Wilde <wilde@intevation.de>
date Wed, 17 Jul 2019 12:05:06 +0200
parents
children
line wrap: on
line diff
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/schema/updates/0000/01.add_schema_version.sql	Wed Jul 17 12:05:06 2019 +0200
@@ -0,0 +1,12 @@
+CREATE TABLE gemma_schema_version (
+    version int PRIMARY KEY,
+    update_date timestamp with time zone NOT NULL DEFAULT CURRENT_TIMESTAMP
+);
+
+CREATE OR REPLACE FUNCTION get_schema_version() RETURNS int
+    LANGUAGE plpgsql
+    AS $$
+    BEGIN
+        RETURN ( SELECT max(version) FROM gemma_schema_version );
+    END;
+$$;