Mercurial > gemma

changeset 3189:6f8fb2053881

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Schema: Added type column for users.templates. TODO: Add backend code to filter by it.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Wed, 08 May 2019 10:37:47 +0200
parents c36940e53788
children 54a3e40cfbed
files schema/gemma.sql
diffstat 1 files changed, 6 insertions(+), 0 deletions(-) [+]
line wrap: on
line diff
--- a/schema/gemma.sql	Tue May 07 18:51:11 2019 +0200
+++ b/schema/gemma.sql	Wed May 08 10:37:47 2019 +0200
@@ -200,6 +200,11 @@
     measure_type varchar PRIMARY KEY
 );
 
+CREATE TYPE template_types AS ENUM (
+    'map',
+    'diagram',
+    'report'
+);
 
 -- Namespace for user management related data
 CREATE SCHEMA users
@@ -211,6 +216,7 @@
 
     CREATE TABLE templates (
         template_name varchar NOT NULL,
+        template_type template_types NOT NULL DEFAULT 'map'::template_types,
         country char(2) REFERENCES countries,
         template_data bytea NOT NULL,
         date_info timestamp with time zone NOT NULL DEFAULT CURRENT_TIMESTAMP,