]> git.mxchange.org Git - friendica.git/blobdiff - doc/database/db_notify.md
Merge pull request #5740 from annando/fix-fatal
[friendica.git] / doc / database / db_notify.md
index 5ef2aa7ebc68518114b4569f9b77b601c7fdb478..fbf0db7705ed2af9cb232d9cec136dc84787df72 100644 (file)
@@ -1,22 +1,24 @@
 Table notify
 ============
 
-| Field  | Description                       | Type         | Null | Key | Default             | Extra           |
-| ------ | --------------------------------- | ------------ | ---- | --- | ------------------- | --------------- |
-| id     | sequential ID                     | int(11)      | NO   | PRI | NULL                | auto_increment  |
-| hash   |                                   | varchar(64)  | NO   |     |                     |                 |
-| type   |                                   | int(11)      | NO   |     | 0                   |                 |
-| name   |                                   | varchar(255) | NO   |     |                     |                 |
-| url    |                                   | varchar(255) | NO   |     |                     |                 |
-| photo  |                                   | varchar(255) | NO   |     |                     |                 |
-| date   |                                   | datetime     | NO   |     | 0000-00-00 00:00:00 |                 |
-| msg    |                                   | mediumtext   | NO   |     | NULL                |                 |
-| uid    | user.id of the owner of this data | int(11)      | NO   | MUL | 0                   |                 |
-| link   |                                   | varchar(255) | NO   |     |                     |                 |
-| parent |                                   | int(11)      | NO   |     | 0                   |                 |
-| seen   |                                   | tinyint(1)   | NO   |     | 0                   |                 |
-| verb   |                                   | varchar(255) | NO   |     |                     |                 |
-| otype  |                                   | varchar(16)  | NO   |     |                     |                 |
-| iid    | item.id                           | int(11)      | NO   |     | 0                   |                 |
+| Field      | Description                       | Type         | Null | Key | Default             | Extra           |
+| ---------- | --------------------------------- | ------------ | ---- | --- | ------------------- | --------------- |
+| id         | sequential ID                     | int(11)      | NO   | PRI | NULL                | auto_increment  |
+| hash       |                                   | varchar(64)  | NO   |     |                     |                 |
+| type       |                                   | int(11)      | NO   |     | 0                   |                 |
+| name       |                                   | varchar(255) | NO   |     |                     |                 |
+| url        |                                   | varchar(255) | NO   |     |                     |                 |
+| photo      |                                   | varchar(255) | NO   |     |                     |                 |
+| date       |                                   | datetime     | NO   |     | 0001-01-01 00:00:00 |                 |
+| msg        |                                   | mediumtext   | YES  |     | NULL                |                 |
+| uid        | user.id of the owner of this data | int(11)      | NO   | MUL | 0                   |                 |
+| link       |                                   | varchar(255) | NO   |     |                     |                 |
+| iid        | item.id                           | int(11)      | NO   |     | 0                   |                 |
+| parent     |                                   | int(11)      | NO   |     | 0                   |                 |
+| seen       |                                   | tinyint(1)   | NO   |     | 0                   |                 |
+| verb       |                                   | varchar(255) | NO   |     |                     |                 |
+| otype      |                                   | varchar(16)  | NO   |     |                     |                 |
+| name_cache | Cached bbcode parsing of name     | tinytext     | YES  |     | NULL                |                 |
+| msg_cache  | Cached bbcode parsing of msg      | mediumtext   | YES  |     | NULL                |                 |
 
 Return to [database documentation](help/database)