Merge pull request #12407 from HankG/friendica-api-photo-endpoint-updates

[friendica.git] / doc / database / db_application.md

diff --git a/doc/database/db_application.md b/doc/database/db_application.md
index 799b01fa164159b8f7bbdef3d4b6ddb6e21554d1..d5d59b5ba642a93effa8f086b40c329fd9542244 100644 (file)
--- 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)