X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=doc%2Fdatabase%2Fdb_application.md;h=d5d59b5ba642a93effa8f086b40c329fd9542244;hb=d26b0ed5a2b5cd66954816096ba87c05043826f0;hp=799b01fa164159b8f7bbdef3d4b6ddb6e21554d1;hpb=31db9dbef7f6a4f98a6c29d15493bcffb0c39929;p=friendica.git

diff --git a/doc/database/db_application.md b/doc/database/db_application.md
index 799b01fa16..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 | YES | PRI | NULL | auto_increment |    
-| client_id |  | varchar(64) | YES |  | NULL |  |    
-| client_secret |  | varchar(64) | YES |  | NULL |  |    
-| name |  | varchar(255) | YES |  | NULL |  |    
-| redirect_uri |  | varchar(255) | YES |  | NULL |  |    
-| website |  | varchar(255) | NO |  | NULL |  |    
-| scopes |  | varchar(255) | NO |  | NULL |  |    
-| read | Read scope | boolean | NO |  | NULL |  |    
-| write | Write scope | boolean | NO |  | NULL |  |    
-| follow | Follow scope | boolean | NO |  | NULL |  |    
-| push | Push scope | boolean | NO |  | 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)