# HG changeset patch
# User jbe
# Date 1345021627 -7200
# Node ID 5a32f862b2dd974a51afb52278def06ff79133d1
# Parent  03897de17853fb5af74ff879ac3d38d3478bcaf0
Unique "client_identifier" for "registered_client", No foreign key in table "authorized_client"

diff -r 03897de17853 -r 5a32f862b2dd core.sql
--- a/core.sql	Wed Aug 15 01:13:44 2012 +0200
+++ b/core.sql	Wed Aug 15 11:07:07 2012 +0200
@@ -203,10 +203,9 @@
 
 
 CREATE TABLE "registered_client" (
-        UNIQUE ("client_identifier", "id"),  -- index needed for foreign-key on table "authorized_client"
         "id"                    SERIAL8         PRIMARY KEY,
         "name"                  TEXT            NOT NULL,
-        "client_identifier"     TEXT            NOT NULL,
+        "client_identifier"     TEXT            NOT NULL UNIQUE,
         "client_secret"         TEXT,
         "code_grant"            BOOLEAN         NOT NULL,
         "implicit_grant"        BOOLEAN         NOT NULL,
@@ -244,12 +243,8 @@
 
 CREATE TABLE "authorized_client" (
         "id"                    SERIAL8         PRIMARY KEY,
-        "registered_client_id"  INT8            REFERENCES "registered_client" ("id")
-                                                ON DELETE CASCADE ON UPDATE CASCADE,
+        UNIQUE ("client_identifier", "member_id"),
         "client_identifier"     TEXT            NOT NULL,
-        FOREIGN KEY ("registered_client_id", "client_identifier")
-          REFERENCES "registered_client" ("id", "client_identifier")
-          ON DELETE CASCADE ON UPDATE CASCADE,
         "member_id"             INT4            NOT NULL REFERENCES "member" ("id")
                                                 ON DELETE CASCADE ON UPDATE CASCADE,
         "access_level"          "api_access_level" NOT NULL,
@@ -259,7 +254,6 @@
 
 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';
 
-COMMENT ON COLUMN "authorized_client"."registered_client_id" IS 'Set, if client is a registered client';
 COMMENT ON COLUMN "authorized_client"."client_identifier"    IS 'OAuth2 client id, also used as redirection endpoint';
 COMMENT ON COLUMN "authorized_client"."member_id"            IS 'Member who authorized the client';
 COMMENT ON COLUMN "authorized_client"."access_level"         IS 'Authorized access level';