]> git.mxchange.org Git - friendica.git/blob - doc/database/db_attach.md
add $contact.change_member to the js template. At the present time we don't make...
[friendica.git] / doc / database / db_attach.md
1 Table attach
2 ============
3
4 | Field      | Description                                           | Type         | Null | Key | Default             | Extra           |
5 | ---------- | ------------------------------------------------------| ------------ | ---- | --- | ------------------- | --------------- |
6 | id         | generated index                                       | int(11)      | NO   | PRI | NULL                | auto_increment  |
7 | uid        | user_id of owner                                      | int(11)      | NO   |     | 0                   |                 |
8 | hash       | hash                                                  | varchar(64)  | NO   |     |                     |                 |
9 | filename   | filename of original                                  | varchar(255) | NO   |     |                     |                 |
10 | filetype   | mimetype                                              | varchar(64)  | NO   |     |                     |                 |
11 | filesize   | size in bytes                                         | int(11)      | NO   |     | 0                   |                 |
12 | data       | file data                                             | longblob     | NO   |     | NULL                |                 |
13 | created    | creation time                                         | datetime     | NO   |     | 0001-01-01 00:00:00 |                 |
14 | edited     | last edit time                                        | datetime     | NO   |     | 0001-01-01 00:00:00 |                 |
15 | allow_cid  | Access Control - list of allowed contact.id '<19><78> | mediumtext   | NO   |     | NULL                |                 |
16 | allow_gid  | Access Control - list of allowed groups               | mediumtext   | NO   |     | NULL                |                 |
17 | deny_cid   | Access Control - list of denied contact.id            | mediumtext   | NO   |     | NULL                |                 |
18 | deny_gid   | Access Control - list of denied groups                | mediumtext   | NO   |     | NULL                |                 |
19
20 Notes: Permissions are surrounded by angle chars. e.g. <4>
21
22 Return to [database documentation](help/database)