X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=doc%2Fdatabase%2Fdb_application.md;h=d5d59b5ba642a93effa8f086b40c329fd9542244;hb=acaa15b6fbb4b20f7772f90930bbf506442646bd;hp=65281f394f74e3a882d1de88070f693badaccf5e;hpb=4095e6c9be01943c3b074d9a9061a01ff5fafcee;p=friendica.git

diff --git a/doc/database/db_application.md b/doc/database/db_application.md
index 65281f394f..d5d59b5ba6 100644
--- a/doc/database/db_application.md
+++ b/doc/database/db_application.md
@@ -1,19 +1,32 @@
 Table application
 ===========
+
 OAuth application
 
-| Field | Description | Type | Null | Key | Default | Extra |
-| ----- | ----------- | ---- | ---- | --- | ------- | ----- |
-| id            | generated index | int unsigned | NO  | PRI | NULL | auto_increment |    
-| client_id     |                 | varchar(64)  | NO  |     | NULL |                |    
-| client_secret |                 | varchar(64)  | NO  |     | NULL |                |    
-| name          |                 | varchar(255) | NO  |     | NULL |                |    
-| redirect_uri  |                 | varchar(255) | NO  |     | NULL |                |    
-| website       |                 | varchar(255) | YES |     | NULL |                |    
-| scopes        |                 | varchar(255) | YES |     | NULL |                |    
-| read          | Read scope      | boolean      | YES |     | NULL |                |    
-| write         | Write scope     | boolean      | YES |     | NULL |                |    
-| follow        | Follow scope    | boolean      | YES |     | NULL |                |    
-| push          | Push scope      | boolean      | YES |     | NULL |                |    
+Fields
+------
+
+| Field         | Description     | Type           | Null | Key | Default | Extra          |
+| ------------- | --------------- | -------------- | ---- | --- | ------- | -------------- |
+| id            | generated index | int unsigned   | NO   | PRI | NULL    | auto_increment |
+| client_id     |                 | varchar(64)    | NO   |     | NULL    |                |
+| client_secret |                 | varchar(64)    | NO   |     | NULL    |                |
+| name          |                 | varchar(255)   | NO   |     | NULL    |                |
+| redirect_uri  |                 | varbinary(383) | NO   |     | NULL    |                |
+| website       |                 | varbinary(383) | YES  |     | NULL    |                |
+| scopes        |                 | varchar(255)   | YES  |     | NULL    |                |
+| read          | Read scope      | boolean        | YES  |     | NULL    |                |
+| write         | Write scope     | boolean        | YES  |     | NULL    |                |
+| follow        | Follow scope    | boolean        | YES  |     | NULL    |                |
+| push          | Push scope      | boolean        | YES  |     | NULL    |                |
+
+Indexes
+------------
+
+| Name      | Fields            |
+| --------- | ----------------- |
+| PRIMARY   | id                |
+| client_id | UNIQUE, client_id |
+
 
 Return to [database documentation](help/database)