liquid_feedback_core

diff core.sql @ 190:9d811ba751c6
UNIQUE constraint for "member_application"."key"
author: jbe
date: Sat Jul 30 15:18:45 2011 +0200 (2011-07-30)
parents: 8b496fa85a65
children: 055d232404d6
     1.1 --- a/core.sql	Sat Jul 30 03:03:25 2011 +0200
     1.2 +++ b/core.sql	Sat Jul 30 15:18:45 2011 +0200
     1.3 @@ -178,7 +178,7 @@
     1.4          "name"                  TEXT            NOT NULL,
     1.5          "comment"               TEXT,
     1.6          "access_level" "application_access_level" NOT NULL,
     1.7 -        "key"                   TEXT            NOT NULL,
     1.8 +        "key"                   TEXT            NOT NULL UNIQUE,
     1.9          "last_usage"            TIMESTAMPTZ );
    1.10  
    1.11  COMMENT ON TABLE "member_application" IS 'Registered application being allowed to use the API';