changeset 102:3780a1afdc98

Auto-generate template IDs.
author Tom Gottfried <tom@intevation.de>
date Fri, 15 Jun 2018 17:33:39 +0200
parents aa32ffd5060b
children b29538ac409d
files wamos.sql
diffstat 1 files changed, 1 insertions(+), 1 deletions(-) [+]
line wrap: on
line diff
--- a/wamos.sql	Fri Jun 15 17:32:49 2018 +0200
+++ b/wamos.sql	Fri Jun 15 17:33:39 2018 +0200
@@ -76,7 +76,7 @@
        );
 
 CREATE TABLE wamos.templates (
-       id int PRIMARY KEY,
+       id int PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY,
        dummy_attrib varchar,
        "..." varchar
        -- TODO: template attributes tbd.