liquid_feedback_core
changeset 280:5a32f862b2dd
Unique "client_identifier" for "registered_client", No foreign key in table "authorized_client"
author | jbe |
---|---|
date | Wed Aug 15 11:07:07 2012 +0200 (2012-08-15) |
parents | 03897de17853 |
children | 2fd3ac2f8323 |
files | core.sql |
line diff
1.1 --- a/core.sql Wed Aug 15 01:13:44 2012 +0200 1.2 +++ b/core.sql Wed Aug 15 11:07:07 2012 +0200 1.3 @@ -203,10 +203,9 @@ 1.4 1.5 1.6 CREATE TABLE "registered_client" ( 1.7 - UNIQUE ("client_identifier", "id"), -- index needed for foreign-key on table "authorized_client" 1.8 "id" SERIAL8 PRIMARY KEY, 1.9 "name" TEXT NOT NULL, 1.10 - "client_identifier" TEXT NOT NULL, 1.11 + "client_identifier" TEXT NOT NULL UNIQUE, 1.12 "client_secret" TEXT, 1.13 "code_grant" BOOLEAN NOT NULL, 1.14 "implicit_grant" BOOLEAN NOT NULL, 1.15 @@ -244,12 +243,8 @@ 1.16 1.17 CREATE TABLE "authorized_client" ( 1.18 "id" SERIAL8 PRIMARY KEY, 1.19 - "registered_client_id" INT8 REFERENCES "registered_client" ("id") 1.20 - ON DELETE CASCADE ON UPDATE CASCADE, 1.21 + UNIQUE ("client_identifier", "member_id"), 1.22 "client_identifier" TEXT NOT NULL, 1.23 - FOREIGN KEY ("registered_client_id", "client_identifier") 1.24 - REFERENCES "registered_client" ("id", "client_identifier") 1.25 - ON DELETE CASCADE ON UPDATE CASCADE, 1.26 "member_id" INT4 NOT NULL REFERENCES "member" ("id") 1.27 ON DELETE CASCADE ON UPDATE CASCADE, 1.28 "access_level" "api_access_level" NOT NULL, 1.29 @@ -259,7 +254,6 @@ 1.30 1.31 COMMENT ON TABLE "authorized_client" IS 'PRELIMINARY, SUBJECT TO CHANGE! OAuth2 client authorized by member, or automatically authorized for a member if "registered_client"."always_authorized" is set'; 1.32 1.33 -COMMENT ON COLUMN "authorized_client"."registered_client_id" IS 'Set, if client is a registered client'; 1.34 COMMENT ON COLUMN "authorized_client"."client_identifier" IS 'OAuth2 client id, also used as redirection endpoint'; 1.35 COMMENT ON COLUMN "authorized_client"."member_id" IS 'Member who authorized the client'; 1.36 COMMENT ON COLUMN "authorized_client"."access_level" IS 'Authorized access level';