Use Mastodon standard edited_at field for tracking edit time

[friendica.git] / doc / database / db_gserver.md

diff --git a/doc/database/db_gserver.md b/doc/database/db_gserver.md
index d75c7335b330c184531fe6b882802dc5322f5570..8ba9e3d9b147f3d8351a73ff420d27fd7f9efb54 100644 (file)
--- a/doc/database/db_gserver.md
+++ b/doc/database/db_gserver.md
@@ -9,8 +9,8 @@ Fields
 | Field                 | Description                                        | Type             | Null | Key | Default             | Extra          |
 | --------------------- | -------------------------------------------------- | ---------------- | ---- | --- | ------------------- | -------------- |
 | id                    | sequential ID                                      | int unsigned     | NO   | PRI | NULL                | auto_increment |
-| url                   |                                                    | varchar(255)     | NO   |     |                     |                |
-| nurl                  |                                                    | varchar(255)     | NO   |     |                     |                |
+| url                   |                                                    | varbinary(383)   | NO   |     |                     |                |
+| nurl                  |                                                    | varbinary(383)   | NO   |     |                     |                |
 | version               |                                                    | varchar(255)     | NO   |     |                     |                |
 | site_name             |                                                    | varchar(255)     | NO   |     |                     |                |
 | info                  |                                                    | text             | YES  |     | NULL                |                |
@@ -22,8 +22,8 @@ Fields
 | local-posts           | Number of local posts                              | int unsigned     | YES  |     | NULL                |                |
 | local-comments        | Number of local comments                           | int unsigned     | YES  |     | NULL                |                |
 | directory-type        | Type of directory service (Poco, Mastodon)         | tinyint          | YES  |     | 0                   |                |
-| poco                  |                                                    | varchar(255)     | NO   |     |                     |                |
-| noscrape              |                                                    | varchar(255)     | NO   |     |                     |                |
+| poco                  |                                                    | varbinary(383)   | NO   |     |                     |                |
+| noscrape              |                                                    | varbinary(383)   | NO   |     |                     |                |
 | network               |                                                    | char(4)          | NO   |     |                     |                |
 | protocol              | The protocol of the server                         | tinyint unsigned | YES  |     | NULL                |                |
 | platform              |                                                    | varchar(255)     | NO   |     |                     |                |
@@ -34,6 +34,7 @@ Fields
 | last_poco_query       |                                                    | datetime         | YES  |     | 0001-01-01 00:00:00 |                |
 | last_contact          | Last successful connection request                 | datetime         | YES  |     | 0001-01-01 00:00:00 |                |
 | last_failure          | Last failed connection request                     | datetime         | YES  |     | 0001-01-01 00:00:00 |                |
+| blocked               | Server is blocked                                  | boolean          | YES  |     | NULL                |                |
 | failed                | Connection failed                                  | boolean          | YES  |     | NULL                |                |
 | next_contact          | Next connection request                            | datetime         | YES  |     | 0001-01-01 00:00:00 |                |