Create Table Queries Mariadb 10.4.2

+-----------------------------------+--------------------------------------------------------------------------------------------------
| Table                             | Create Table
+-----------------------------------+--------------------------------------------------------------------------------------------------
| ehvp_message_conversation_actions | CREATE TABLE `ehvp_message_conversation_actions` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `userid` bigint(10) NOT NULL,
  `conversationid` bigint(10) NOT NULL,
  `action` bigint(10) NOT NULL,
  `timecreated` bigint(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `ehvp_messconvacti_use_ix` (`userid`),
  KEY `ehvp_messconvacti_con_ix` (`conversationid`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Stores all per-user actions on individual conversations' |
+-----------------------------------+--------------------------------------------------------------------------------------------------

+---------------------------+----------------------------------------------------------------------------------------------------------
| Table                     | Create Table
+---------------------------+----------------------------------------------------------------------------------------------------------
| ehvp_message_user_actions | CREATE TABLE `ehvp_message_user_actions` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `userid` bigint(10) NOT NULL,
  `messageid` bigint(10) NOT NULL,
  `action` bigint(10) NOT NULL,
  `timecreated` bigint(10) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ehvp_messuseracti_usemesac_uix` (`userid`,`messageid`,`action`),
  KEY `ehvp_messuseracti_use_ix` (`userid`),
  KEY `ehvp_messuseracti_mes_ix` (`messageid`)
) ENGINE=InnoDB AUTO_INCREMENT=568128 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Stores all per-user actions on individual messages' |
+---------------------------+----------------------------------------------------------------------------------------------------------

+---------------+----------------------------------------------------------------------------------------------------------------------
| Table         | Create Table
+---------------+----------------------------------------------------------------------------------------------------------------------
| ehvp_messages | CREATE TABLE `ehvp_messages` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `useridfrom` bigint(10) NOT NULL,
  `conversationid` bigint(10) NOT NULL,
  `subject` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fullmessage` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fullmessageformat` tinyint(1) NOT NULL DEFAULT 0,
  `fullmessagehtml` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `smallmessage` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `timecreated` bigint(10) NOT NULL,
  `fullmessagetrust` tinyint(2) NOT NULL DEFAULT 0,
  `customdata` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ehvp_mess_contim_ix` (`conversationid`,`timecreated`),
  KEY `ehvp_mess_use_ix` (`useridfrom`),
  KEY `ehvp_mess_con_ix` (`conversationid`)
) ENGINE=InnoDB AUTO_INCREMENT=5795 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Stores all messages' |
+---------------+----------------------------------------------------------------------------------------------------------------------


+-----------------------------------+--------------------------------------------------------------------------------------------------
| Table                             | Create Table
+-----------------------------------+--------------------------------------------------------------------------------------------------
| ehvp_message_conversation_members | CREATE TABLE `ehvp_message_conversation_members` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `conversationid` bigint(10) NOT NULL,
  `userid` bigint(10) NOT NULL,
  `timecreated` bigint(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `ehvp_messconvmemb_con_ix` (`conversationid`),
  KEY `ehvp_messconvmemb_use_ix` (`userid`)
) ENGINE=InnoDB AUTO_INCREMENT=103180 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Stores all members in a conversations' |
+-----------------------------------+--------------------------------------------------------------------------------------------------

+----------------------------+---------------------------------------------------------------------------------------------------------
| Table                      | Create Table
+----------------------------+---------------------------------------------------------------------------------------------------------
| ehvp_message_conversations | CREATE TABLE `ehvp_message_conversations` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `type` bigint(10) NOT NULL DEFAULT 1,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `convhash` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `component` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `itemtype` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `itemid` bigint(10) DEFAULT NULL,
  `contextid` bigint(10) DEFAULT NULL,
  `enabled` tinyint(1) NOT NULL DEFAULT 0,
  `timecreated` bigint(10) NOT NULL,
  `timemodified` bigint(10) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ehvp_messconv_typ_ix` (`type`),
  KEY `ehvp_messconv_con_ix` (`convhash`),
  KEY `ehvp_messconv_comiteitecon_ix` (`component`,`itemtype`,`itemid`,`contextid`),
  KEY `ehvp_messconv_con2_ix` (`contextid`)
) ENGINE=InnoDB AUTO_INCREMENT=54205 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Stores all message conversations' |
+----------------------------+---------------------------------------------------------------------------------------------------------