@Michael 🇺🇦
Ja scheint zu existieren:
SHOW TABLES LIKE 'post-timeline-view';
+--------------------------------------------+
| Tables_in_friendicadb (post-timeline-view) |
+--------------------------------------------+
| post-timeline-view |
+--------------------------------------------+
1 row in set (0,001 sec)Es sind folgende Felder vorhanden:
DESCRIBE `post-timeline-view`;
+------------------+-----------------------+------+-----+---------------------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------------+-----------------------+------+-----+---------------------+-------+
| uid | mediumint(8) unsigned | NO | | NULL | |
| uri-id | int(10) unsigned | NO | | NULL | |
| gravity | tinyint(3) unsigned | NO | | 0 | |
| created | datetime | NO | | 0001-01-01 00:00:00 | |
| edited | datetime | NO | | 0001-01-01 00:00:00 | |
| commented | datetime | YES | | 0001-01-01 00:00:00 | |
| received | datetime | NO | | 0001-01-01 00:00:00 | |
| changed | datetime | YES | | 0001-01-01 00:00:00 | |
| private | tinyint(3) unsigned | NO | | 0 | |
| visible | tinyint(1) | NO | | 0 | |
| deleted | tinyint(1) | NO | | 0 | |
| origin | tinyint(1) | NO | | 0 | |
| global | tinyint(1) | NO | | 0 | |
| network | char(4) | NO | | | |
| protocol | tinyint(3) unsigned | YES | | NULL | |
| vid | smallint(5) unsigned | YES | | NULL | |
| contact-id | int(10) unsigned | NO | | 0 | |
| contact-blocked | tinyint(1) | NO | | 1 | |
| contact-readonly | tinyint(1) | NO | | 0 | |
| contact-pending | tinyint(1) | NO | | 1 | |
| contact-rel | tinyint(3) unsigned | NO | | 0 | |
| contact-uid | mediumint(8) unsigned | NO | | 0 | |
| self | tinyint(1) | NO | | 0 | |
| author-id | int(10) unsigned | NO | | 0 | |
| author-blocked | tinyint(1) | NO | | 1 | |
| author-hidden | tinyint(1) | NO | | 0 | |
| author-gsid | int(10) unsigned | YES | | NULL | |
| owner-id | int(10) unsigned | NO | | 0 | |
| owner-blocked | tinyint(1) | NO | | 1 | |
| owner-gsid | int(10) unsigned | YES | | NULL | |
| causer-id | int(10) unsigned | YES | | NULL | |
| causer-blocked | tinyint(1) | YES | | 1 | |
| causer-gsid | int(10) unsigned | YES | | NULL | |
| parent-network | char(4) | YES | | | |
| parent-owner-id | int(10) unsigned | YES | | 0 | |
| parent-author-id | int(10) unsigned | YES | | 0 | |
+------------------+-----------------------+------+-----+---------------------+-------+
36 rows in set (0,002 sec)