Mercurial > gemma

changeset 2367:0aedae39726e

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Print templates: Removed primary key from templates table and add a unique constraint to template name and country instead to make possible that different countries can use templates with same name.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Thu, 21 Feb 2019 10:46:38 +0100
parents ff1e4f1b54c6
children 96b0314f2bd6
files schema/gemma.sql
diffstat 1 files changed, 3 insertions(+), 2 deletions(-) [+]
line wrap: on
line diff
--- a/schema/gemma.sql	Thu Feb 21 09:58:24 2019 +0100
+++ b/schema/gemma.sql	Thu Feb 21 10:46:38 2019 +0100
@@ -178,10 +178,11 @@
     )
 
     CREATE TABLE templates (
-        template_name varchar PRIMARY KEY,
+        template_name varchar NOT NULL,
         country char(2) REFERENCES countries,
         template_data bytea NOT NULL,
-        date_info timestamp with time zone NOT NULL DEFAULT CURRENT_TIMESTAMP
+        date_info timestamp with time zone NOT NULL DEFAULT CURRENT_TIMESTAMP,
+        UNIQUE (template_name, country)
     )
     CREATE TRIGGER templates_date_info BEFORE UPDATE ON templates
         FOR EACH ROW EXECUTE PROCEDURE update_date_info()