doc/database/db_user.md

   1 Table user
   2 ===========
   3
   4 The local users
   5
   6 | Field                    | Description                                               | Type               | Null | Key | Default             | Extra          |
   7 | ------------------------ | --------------------------------------------------------- | ------------------ | ---- | --- | ------------------- | -------------- |
   8 | uid                      | sequential ID                                             | mediumint unsigned | NO   | PRI | NULL                | auto_increment |
   9 | parent-uid               | The parent user that has full control about this user     | mediumint unsigned | YES  |     | NULL                |                |
  10 | guid                     | A unique identifier for this user                         | varchar(64)        | NO   |     |                     |                |
  11 | username                 | Name that this user is known by                           | varchar(255)       | NO   |     |                     |                |
  12 | password                 | encrypted password                                        | varchar(255)       | NO   |     |                     |                |
  13 | legacy_password          | Is the password hash double-hashed?                       | boolean            | NO   |     | 0                   |                |
  14 | nickname                 | nick- and user name                                       | varchar(255)       | NO   |     |                     |                |
  15 | email                    | the users email address                                   | varchar(255)       | NO   |     |                     |                |
  16 | openid                   |                                                           | varchar(255)       | NO   |     |                     |                |
  17 | timezone                 | PHP-legal timezone                                        | varchar(128)       | NO   |     |                     |                |
  18 | language                 | default language                                          | varchar(32)        | NO   |     | en                  |                |
  19 | register_date            | timestamp of registration                                 | datetime           | NO   |     | 0001-01-01 00:00:00 |                |
  20 | login_date               | timestamp of last login                                   | datetime           | NO   |     | 0001-01-01 00:00:00 |                |
  21 | default-location         | Default for item.location                                 | varchar(255)       | NO   |     |                     |                |
  22 | allow_location           | 1 allows to display the location                          | boolean            | NO   |     | 0                   |                |
  23 | theme                    | user theme preference                                     | varchar(255)       | NO   |     |                     |                |
  24 | pubkey                   | RSA public key 4096 bit                                   | text               | YES  |     | NULL                |                |
  25 | prvkey                   | RSA private key 4096 bit                                  | text               | YES  |     | NULL                |                |
  26 | spubkey                  |                                                           | text               | YES  |     | NULL                |                |
  27 | sprvkey                  |                                                           | text               | YES  |     | NULL                |                |
  28 | verified                 | user is verified through email                            | boolean            | NO   |     | 0                   |                |
  29 | blocked                  | 1 for user is blocked                                     | boolean            | NO   |     | 0                   |                |
  30 | blockwall                | Prohibit contacts to post to the profile page of the user | boolean            | NO   |     | 0                   |                |
  31 | hidewall                 | Hide profile details from unkown viewers                  | boolean            | NO   |     | 0                   |                |
  32 | blocktags                | Prohibit contacts to tag the post of this user            | boolean            | NO   |     | 0                   |                |
  33 | unkmail                  | Permit unknown people to send private mails to this user  | boolean            | NO   |     | 0                   |                |
  34 | cntunkmail               |                                                           | int unsigned       | NO   |     | 10                  |                |
  35 | notify-flags             | email notification options                                | smallint unsigned  | NO   |     | 65535               |                |
  36 | page-flags               | page/profile type                                         | tinyint unsigned   | NO   |     | 0                   |                |
  37 | account-type             |                                                           | tinyint unsigned   | NO   |     | 0                   |                |
  38 | prvnets                  |                                                           | boolean            | NO   |     | 0                   |                |
  39 | pwdreset                 | Password reset request token                              | varchar(255)       | YES  |     | NULL                |                |
  40 | pwdreset_time            | Timestamp of the last password reset request              | datetime           | YES  |     | NULL                |                |
  41 | maxreq                   |                                                           | int unsigned       | NO   |     | 10                  |                |
  42 | expire                   |                                                           | int unsigned       | NO   |     | 0                   |                |
  43 | account_removed          | if 1 the account is removed                               | boolean            | NO   |     | 0                   |                |
  44 | account_expired          |                                                           | boolean            | NO   |     | 0                   |                |
  45 | account_expires_on       | timestamp when account expires and will be deleted        | datetime           | NO   |     | 0001-01-01 00:00:00 |                |
  46 | expire_notification_sent | timestamp of last warning of account expiration           | datetime           | NO   |     | 0001-01-01 00:00:00 |                |
  47 | def_gid                  |                                                           | int unsigned       | NO   |     | 0                   |                |
  48 | allow_cid                | default permission for this user                          | mediumtext         | YES  |     | NULL                |                |
  49 | allow_gid                | default permission for this user                          | mediumtext         | YES  |     | NULL                |                |
  50 | deny_cid                 | default permission for this user                          | mediumtext         | YES  |     | NULL                |                |
  51 | deny_gid                 | default permission for this user                          | mediumtext         | YES  |     | NULL                |                |
  52 | openidserver             |                                                           | text               | YES  |     | NULL                |                |
  53
  54 Return to [database documentation](help/database)