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

Impressum / About Us