# HG changeset patch
# User jbe
# Date 1312031925 -7200
# Node ID 9d811ba751c6cbfb444c0dd3e0cef075ce2884e8
# Parent  548152fa67e53f731fe4964d7421f2497b4fdc09
UNIQUE constraint for "member_application"."key"

diff -r 548152fa67e5 -r 9d811ba751c6 core.sql
--- a/core.sql	Sat Jul 30 03:03:25 2011 +0200
+++ b/core.sql	Sat Jul 30 15:18:45 2011 +0200
@@ -178,7 +178,7 @@
         "name"                  TEXT            NOT NULL,
         "comment"               TEXT,
         "access_level" "application_access_level" NOT NULL,
-        "key"                   TEXT            NOT NULL,
+        "key"                   TEXT            NOT NULL UNIQUE,
         "last_usage"            TIMESTAMPTZ );
 
 COMMENT ON TABLE "member_application" IS 'Registered application being allowed to use the API';
diff -r 548152fa67e5 -r 9d811ba751c6 update/core-update.v1.4.0_rc4-v1.5.0_rc1.sql
--- a/update/core-update.v1.4.0_rc4-v1.5.0_rc1.sql	Sat Jul 30 03:03:25 2011 +0200
+++ b/update/core-update.v1.4.0_rc4-v1.5.0_rc1.sql	Sat Jul 30 15:18:45 2011 +0200
@@ -35,7 +35,7 @@
         "name"                  TEXT            NOT NULL,
         "comment"               TEXT,
         "access_level" "application_access_level" NOT NULL,
-        "key"                   TEXT            NOT NULL,
+        "key"                   TEXT            NOT NULL UNIQUE,
         "last_usage"            TIMESTAMPTZ );
 
 COMMENT ON TABLE "member_application" IS 'Registered application being allowed to use the API';