liquid_feedback_core

changeset 190:9d811ba751c6

UNIQUE constraint for "member_application"."key"
author jbe
date Sat Jul 30 15:18:45 2011 +0200 (2011-07-30)
parents 548152fa67e5
children 44e489d77306
files core.sql update/core-update.v1.4.0_rc4-v1.5.0_rc1.sql
line diff
     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';
     2.1 --- a/update/core-update.v1.4.0_rc4-v1.5.0_rc1.sql	Sat Jul 30 03:03:25 2011 +0200
     2.2 +++ b/update/core-update.v1.4.0_rc4-v1.5.0_rc1.sql	Sat Jul 30 15:18:45 2011 +0200
     2.3 @@ -35,7 +35,7 @@
     2.4          "name"                  TEXT            NOT NULL,
     2.5          "comment"               TEXT,
     2.6          "access_level" "application_access_level" NOT NULL,
     2.7 -        "key"                   TEXT            NOT NULL,
     2.8 +        "key"                   TEXT            NOT NULL UNIQUE,
     2.9          "last_usage"            TIMESTAMPTZ );
    2.10  
    2.11  COMMENT ON TABLE "member_application" IS 'Registered application being allowed to use the API';

Impressum / About Us