MariaDB [demo1]> show create table activities\G;
*************************** 1. row ***************************
       Table: activities
Create Table: CREATE TABLE `activities` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) DEFAULT NULL COMMENT 'activities.id',
  `tree_level` tinyint(4) NOT NULL,
  `type_id` int(11) NOT NULL COMMENT 'tpis_class.class_id',
  `name` varchar(255) NOT NULL,
  `code` varchar(255) DEFAULT NULL,
  `accepted` tinyint(4) NOT NULL DEFAULT 0,
  `begin_date` datetime DEFAULT NULL,
  `end_date` datetime DEFAULT NULL,
  `priority` varchar(100) NOT NULL DEFAULT '',
  `status_id` int(11) DEFAULT NULL COMMENT 'tpis_class.class_id',
  `status_changed_at` datetime DEFAULT NULL,
  `procurement_id` int(11) DEFAULT NULL,
  `procannounce_id` int(11) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `origin_id` int(11) DEFAULT NULL COMMENT 'activities.id',
  `estimate_hours` int(11) DEFAULT NULL,
  `in_budget` tinyint(4) NOT NULL DEFAULT 1,
  `priority_id` int(11) DEFAULT NULL,
  `contract_id` int(11) DEFAULT NULL,
  `procannounce_end_id` int(11) DEFAULT NULL,
  `is_deleted` tinyint(4) DEFAULT NULL,
  `assessment_class_id` int(11) DEFAULT NULL COMMENT 'tpis_class.class_id',
  `law_type_id` int(11) DEFAULT NULL COMMENT 'tpis_class.class_id',
  `lawmaking_milestone_id` int(11) DEFAULT NULL COMMENT 'tpis_class.class_id',
  `percent_done` int(11) DEFAULT NULL,
  `special_field_id` int(11) DEFAULT NULL,
  `starred` bit(1) NOT NULL,
  `spent_hours_total` decimal(8,2) NOT NULL,
  `estimate_hours_total` decimal(8,2) NOT NULL,
  `public` bit(1) NOT NULL,
  `kpi_type` int(11) DEFAULT NULL,
  `kpi_target` decimal(12,2) DEFAULT NULL,
  `kpi_real` decimal(12,2) DEFAULT NULL,
  `default_budget_source_id` int(11) DEFAULT NULL,
  `position` int(11) NOT NULL,
  `owner_account_id` int(11) DEFAULT NULL COMMENT 'accounts.id',
  `scheduling_mode` varchar(31) DEFAULT 'Normal',
  `is_manually_scheduled` tinyint(1) NOT NULL DEFAULT 0,
  `calendar_id` varchar(50) DEFAULT NULL,
  `constraint_type` varchar(31) DEFAULT NULL,
  `constraint_date` datetime DEFAULT NULL,
  `planned_amount` int(11) NOT NULL,
  `import_id` varchar(100) DEFAULT NULL,
  `import_parent_id` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_activities_end_date` (`end_date`),
  KEY `fk_activities_origin` (`origin_id`),
  KEY `fk_activities_parent_idx` (`parent_id`),
  KEY `index_owner_account` (`owner_account_id`),
  KEY `index_activity_owner` (`id`,`owner_account_id`),
  KEY `index_parent_activity` (`parent_id`,`id`),
  KEY `index_status_id_deleted` (`status_id`,`id`,`is_deleted`),
  KEY `index_id_treelevel` (`id`,`tree_level`),
  KEY `fk_activities_type` (`type_id`),
  KEY `fk_activities_status` (`status_id`),
  KEY `fk_activities_procannounce` (`procannounce_id`),
  KEY `fk_activities_procurement` (`procurement_id`),
  KEY `fk_assessment_idx` (`assessment_class_id`),
  KEY `fk_law_type_idx` (`law_type_id`),
  KEY `fk_lawmaking_milestone_idx` (`lawmaking_milestone_id`),
  KEY `index_level_deleted` (`tree_level`,`is_deleted`),
  KEY `index_id_status` (`id`,`status_id`),
  CONSTRAINT `fk_activities_origin` FOREIGN KEY (`origin_id`) REFERENCES `activities` (`id`) ON DELETE SET NULL,
  CONSTRAINT `fk_activities_parent` FOREIGN KEY (`parent_id`) REFERENCES `activities` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=45125 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci
1 row in set (0.001 sec)

ERROR: No query specified

MariaDB [demo1]> show create table fieldlog\G;
*************************** 1. row ***************************
       Table: fieldlog
Create Table: CREATE TABLE `fieldlog` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `audit_id` int(11) NOT NULL,
  `table_name` varchar(30) NOT NULL,
  `record_id` int(11) NOT NULL,
  `connected_id` int(11) DEFAULT NULL,
  `field_name` varchar(50) NOT NULL,
  `old_value` varchar(255) DEFAULT NULL,
  `old_value_text` mediumtext DEFAULT NULL,
  `new_value` varchar(255) DEFAULT NULL,
  `new_value_text` mediumtext DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `audit_id` (`audit_id`),
  CONSTRAINT `fk_fieldlog_auditlog` FOREIGN KEY (`audit_id`) REFERENCES `auditlog` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=182732 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci
1 row in set (0.000 sec)