# HG changeset patch
# User jbe
# Date 1345021693 -7200
# Node ID 2fd3ac2f8323dd488ecbdd7e4204df219dd8d312
# Parent  5a32f862b2dd974a51afb52278def06ff79133d1
URL for registered (web) API clients

diff -r 5a32f862b2dd -r 2fd3ac2f8323 core.sql
--- a/core.sql	Wed Aug 15 11:07:07 2012 +0200
+++ b/core.sql	Wed Aug 15 11:08:13 2012 +0200
@@ -205,6 +205,7 @@
 CREATE TABLE "registered_client" (
         "id"                    SERIAL8         PRIMARY KEY,
         "name"                  TEXT            NOT NULL,
+        "url"                   TEXT,
         "client_identifier"     TEXT            NOT NULL UNIQUE,
         "client_secret"         TEXT,
         "code_grant"            BOOLEAN         NOT NULL,
@@ -226,6 +227,7 @@
 COMMENT ON TABLE "registered_client" IS 'PRELIMINARY, SUBJECT TO CHANGE! OAuth2 client registered by administrator';
 
 COMMENT ON COLUMN "registered_client"."name"                      IS 'Name of the registered client';
+COMMENT ON COLUMN "registered_client"."url"                       IS 'Optional URL for web clients';
 COMMENT ON COLUMN "registered_client"."client_identifier"         IS 'OAuth2 client id, also used as redirection endpoint if "code_grant" or "implicit_grant" is set to TRUE';
 COMMENT ON COLUMN "registered_client"."client_secret"             IS 'Secret for client authentication';
 COMMENT ON COLUMN "registered_client"."code_grant"                IS 'Enable OAuth2 Authorization Code Grant';