doc/database/db_application.md

   1 Table application
   2 ===========
   3
   4 OAuth application
   5
   6 Fields
   7 ------
   8
   9 | Field         | Description     | Type           | Null | Key | Default | Extra          |
  10 | ------------- | --------------- | -------------- | ---- | --- | ------- | -------------- |
  11 | id            | generated index | int unsigned   | NO   | PRI | NULL    | auto_increment |
  12 | client_id     |                 | varchar(64)    | NO   |     | NULL    |                |
  13 | client_secret |                 | varchar(64)    | NO   |     | NULL    |                |
  14 | name          |                 | varchar(255)   | NO   |     | NULL    |                |
  15 | redirect_uri  |                 | varbinary(383) | NO   |     | NULL    |                |
  16 | website       |                 | varbinary(383) | YES  |     | NULL    |                |
  17 | scopes        |                 | varchar(255)   | YES  |     | NULL    |                |
  18 | read          | Read scope      | boolean        | YES  |     | NULL    |                |
  19 | write         | Write scope     | boolean        | YES  |     | NULL    |                |
  20 | follow        | Follow scope    | boolean        | YES  |     | NULL    |                |
  21 | push          | Push scope      | boolean        | YES  |     | NULL    |                |
  22
  23 Indexes
  24 ------------
  25
  26 | Name      | Fields            |
  27 | --------- | ----------------- |
  28 | PRIMARY   | id                |
  29 | client_id | UNIQUE, client_id |
  30
  31
  32 Return to [database documentation](help/database)