MariaDB [amical]> show create table `post-engagement`;
+-----------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table           | Create Table                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |
+-----------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| post-engagement | CREATE TABLE `post-engagement` (
  `uri-id` int(10) unsigned NOT NULL COMMENT 'Id of the item-uri table entry that contains the item uri',
  `owner-id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Item owner',
  `contact-type` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'Person, organisation, news, community, relay',
  `media-type` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'Type of media in a bit array (1 = image, 2 = video, 4 = audio',
  `language` varbinary(128) DEFAULT NULL COMMENT 'Language information about this post',
  `created` datetime DEFAULT NULL,
  `comments` mediumint(8) unsigned DEFAULT NULL COMMENT 'Number of comments',
  `activities` mediumint(8) unsigned DEFAULT NULL COMMENT 'Number of activities (like, dislike, ...)',
  `restricted` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'If true, this post is either unlisted or not from a federated network',
  `searchtext` mediumtext DEFAULT NULL COMMENT 'Simplified text for the full text search',
  PRIMARY KEY (`uri-id`),
  KEY `owner-id` (`owner-id`),
  KEY `created` (`created`),
  FULLTEXT KEY `searchtext` (`searchtext`),
  CONSTRAINT `post-engagement_ibfk_2` FOREIGN KEY (`owner-id`) REFERENCES `contact` (`id`),
  CONSTRAINT `post-engagement_ibfk_3` FOREIGN KEY (`uri-id`) REFERENCES `item-uri` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Engagement data per post' |
+-----------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.001 sec)