doc/database/db_user.md

   1 Table user
   2 ==========
   3
   4 | Field                    | Description                                                                             | Type                | Null | Key | Default             | Extra          |
   5 |--------------------------|-----------------------------------------------------------------------------------------|---------------------|------|-----|---------------------|----------------|
   6 | uid                      | sequential ID                                                                           | int(11)             | NO   | PRI | NULL                | auto_increment |
   7 | guid                     | A unique identifier for this user                                                       | varchar(64)         | NO   |     |                     |                |
   8 | username                 | Name that this user is known by                                                         | varchar(255)        | NO   |     |                     |                |
   9 | password                 | encrypted password                                                                      | varchar(255)        | NO   |     |                     |                |
  10 | nickname                 | nick- and user name                                                                     | varchar(255)        | NO   | MUL |                     |                |
  11 | email                    | the users email address                                                                 | varchar(255)        | NO   |     |                     |                |
  12 | openid                   |                                                                                         | varchar(255)        | NO   |     |                     |                |
  13 | timezone                 | PHP-legal timezone                                                                      | varchar(128)        | NO   |     |                     |                |
  14 | language                 | default language                                                                        | varchar(32)         | NO   |     | en                  |                |
  15 | register_date            | timestamp of registration                                                               | datetime            | NO   |     | 0001-01-01 00:00:00 |                |
  16 | login_date               | timestamp of last login                                                                 | datetime            | NO   |     | 0001-01-01 00:00:00 |                |
  17 | default-location         | Default for item.location                                                               | varchar(255)        | NO   |     |                     |                |
  18 | allow_location           | 1 allows to display the location                                                        | tinyint(1)          | NO   |     | 0                   |                |
  19 | theme                    | user theme preference                                                                   | varchar(255)        | NO   |     |                     |                |
  20 | pubkey                   | RSA public key 4096 bit                                                                 | text                | NO   |     | NULL                |                |
  21 | prvkey                   | RSA private key 4096 bit                                                                | text                | NO   |     | NULL                |                |
  22 | spubkey                  |                                                                                         | text                | NO   |     | NULL                |                |
  23 | sprvkey                  |                                                                                         | text                | NO   |     | NULL                |                |
  24 | verified                 | user is verified through email                                                          | tinyint(1) unsigned | NO   |     | 0                   |                |
  25 | blocked                  | 1 for user is blocked                                                                   | tinyint(1) unsigned | NO   |     | 0                   |                |
  26 | blockwall                | Prohibit contacts to post to the profile page of the user                               | tinyint(1) unsigned | NO   |     | 0                   |                |
  27 | hidewall                 | Hide profile details from unkown viewers                                                | tinyint(1) unsigned | NO   |     | 0                   |                |
  28 | blocktags                | Prohibit contacts to tag the post of this user                                          | tinyint(1) unsigned | NO   |     | 0                   |                |
  29 | unkmail                  | Permit unknown people to send private mails to this user                                | tinyint(1)          | NO   |     | 0                   |                |
  30 | cntunkmail               |                                                                                         | int(11)             | NO   |     | 10                  |                |
  31 | notify-flags             | email notification options                                                              | int(11) unsigned    | NO   |     | 65535               |                |
  32 | page-flags               | page/profile type                                                                       | int(11) unsigned    | NO   |     | 0                   |                |
  33 | prvnets                  |                                                                                         | tinyint(1)          | NO   |     | 0                   |                |
  34 | pwdreset                 |                                                                                         | varchar(255)        | NO   |     |                     |                |
  35 | maxreq                   |                                                                                         | int(11)             | NO   |     | 10                  |                |
  36 | expire                   |                                                                                         | int(11) unsigned    | NO   |     | 0                   |                |
  37 | account_removed          | if 1 the account is removed                                                             | tinyint(1)          | NO   |     | 0                   |                |
  38 | account_expired          |                                                                                         | tinyint(1)          | NO   |     | 0                   |                |
  39 | account_expires_on       | timestamp when account expires and will be deleted                                      | datetime            | NO   |     | 0001-01-01 00:00:00 |                |
  40 | expire_notification_sent | timestamp of last warning of account expiration                                         | datetime            | NO   |     | 0001-01-01 00:00:00 |                |
  41 | service_class            | service class for this account, determines what if any limits/restrictions are in place | varchar(32)         | NO   |     |                     |                |
  42 | def_gid                  |                                                                                         | int(11)             | NO   |     | 0                   |                |
  43 | allow_cid                | default permission for this user                                                        | mediumtext          | NO   |     | NULL                |                |
  44 | allow_gid                | default permission for this user                                                        | mediumtext          | NO   |     | NULL                |                |
  45 | deny_cid                 | default permission for this user                                                        | mediumtext          | NO   |     | NULL                |                |
  46 | deny_gid                 | default permission for this user                                                        | mediumtext          | NO   |     | NULL                |                |
  47 | openidserver             |                                                                                         | text                | NO   |     | NULL                |                |
  48
  49 ```
  50 /**
  51 * page-flags
  52 */
  53 define ( 'PAGE_NORMAL',            0 );
  54 define ( 'PAGE_SOAPBOX',           1 );
  55 define ( 'PAGE_COMMUNITY',         2 );
  56 define ( 'PAGE_FREELOVE',          3 );
  57 define ( 'PAGE_BLOG',              4 );
  58 define ( 'PAGE_PRVGROUP',          5 );
  59
  60 /**
  61 * notify-flags
  62 */
  63 define ( 'NOTIFY_INTRO',    0x0001 );
  64 define ( 'NOTIFY_CONFIRM',  0x0002 );
  65 define ( 'NOTIFY_WALL',     0x0004 );
  66 define ( 'NOTIFY_COMMENT',  0x0008 );
  67 define ( 'NOTIFY_MAIL',     0x0010 );
  68 define ( 'NOTIFY_SUGGEST',  0x0020 );
  69 define ( 'NOTIFY_PROFILE',  0x0040 );
  70 define ( 'NOTIFY_TAGSELF',  0x0080 );
  71 define ( 'NOTIFY_TAGSHARE', 0x0100 );
  72 define ( 'NOTIFY_POKE',     0x0200 );
  73 define ( 'NOTIFY_SHARE',    0x0400 );
  74
  75 define ( 'NOTIFY_SYSTEM',   0x8000 );
  76 ```
  77
  78 Return to [database documentation](help/database)