# HG changeset patch
# User Björn Ricks <bjoern.ricks@intevation.de>
# Date 1366105895 -7200
# Node ID 561441fde2acf67c508136748a2b6063fd03bb8a
# Parent  0746534b7f9719abccc9e6f37a5864e4ab8e29d3
Set unique constraint on project key

Thanks to Tom Gottfried

diff -r 0746534b7f97 -r 561441fde2ac getan/backend.py
--- a/getan/backend.py	Tue Apr 16 09:47:07 2013 +0200
+++ b/getan/backend.py	Tue Apr 16 11:51:35 2013 +0200
@@ -25,7 +25,7 @@
 """
 CREATE TABLE projects (
     id          INTEGER PRIMARY KEY AUTOINCREMENT,
-    key         VARCHAR(16) NOT NULL,
+    key         VARCHAR(16) NOT NULL CONSTRAINT unique_key UNIQUE,
     description VARCHAR(256),
     active      BOOLEAN DEFAULT 1
 )