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';