--- a/schema/gemma.sql	Wed Jul 17 11:38:24 2019 +0200
+++ b/schema/gemma.sql	Wed Jul 17 12:05:06 2019 +0200
@@ -206,6 +206,23 @@
 
 
 --
+-- GEMA meta data
+--
+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;
+$$;
+
+
+--
 -- GEMMA data
 --