]> git.mxchange.org Git - friendica.git/blobdiff - doc/database/db_post-thread-user.md
Revert "Rename contact table column to ffi_keyword_denylist"
[friendica.git] / doc / database / db_post-thread-user.md
index e4f5e39bdae85b91733a3698f68a53c094bf4ef4..a89d94c96fa09fa7346cc2a0836014b9072a9f7c 100644 (file)
@@ -36,25 +36,31 @@ Fields
 Indexes
 ------------
 
-| Name              | Fields              |
-| ----------------- | ------------------- |
-| PRIMARY           | uid, uri-id         |
-| uri-id            | uri-id              |
-| conversation-id   | conversation-id     |
-| owner-id          | owner-id            |
-| author-id         | author-id           |
-| causer-id         | causer-id           |
-| uid               | uid                 |
-| contact-id        | contact-id          |
-| psid              | psid                |
-| post-user-id      | post-user-id        |
-| commented         | commented           |
-| received          | received            |
-| uid_received      | uid, received       |
-| uid_wall_received | uid, wall, received |
-| uid_commented     | uid, commented      |
-| uid_starred       | uid, starred        |
-| uid_mention       | uid, mention        |
+| Name                 | Fields                |
+| -------------------- | --------------------- |
+| PRIMARY              | uid, uri-id           |
+| uri-id               | uri-id                |
+| conversation-id      | conversation-id       |
+| owner-id             | owner-id              |
+| author-id            | author-id             |
+| causer-id            | causer-id             |
+| uid                  | uid                   |
+| contact-id           | contact-id            |
+| psid                 | psid                  |
+| post-user-id         | post-user-id          |
+| commented            | commented             |
+| received             | received              |
+| author-id_created    | author-id, created    |
+| owner-id_created     | owner-id, created     |
+| uid_received         | uid, received         |
+| uid_wall_received    | uid, wall, received   |
+| uid_commented        | uid, commented        |
+| uid_created          | uid, created          |
+| uid_starred          | uid, starred          |
+| uid_mention          | uid, mention          |
+| contact-id_commented | contact-id, commented |
+| contact-id_received  | contact-id, received  |
+| contact-id_created   | contact-id, created   |
 
 Foreign Keys
 ------------