]> git.mxchange.org Git - friendica.git/blob - doc/database/db_user.md
add $contact.change_member to the js template. At the present time we don't make...
[friendica.git] / 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)