Query for mo_files_domains
DROP TABLE IF EXISTS `ariz_icl_mo_files_domains`;
CREATE TABLE `ariz_icl_mo_files_domains` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`file_path` varchar(250) COLLATE utf8mb4_unicode_520_ci NOT NULL,
`file_path_md5` varchar(32) COLLATE utf8mb4_unicode_520_ci NOT NULL,
`domain` varchar(45) COLLATE utf8mb4_unicode_520_ci NOT NULL,
`status` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'not_imported',
`num_of_strings` int(11) NOT NULL DEFAULT '0',
`last_modified` int(11) NOT NULL,
`component_type` enum('plugin','theme','other') COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'other',
`component_id` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `file_path_md5_UNIQUE` (`file_path_md5`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
Query for string_packages
DROP TABLE IF EXISTS `ariz_icl_string_packages`;
CREATE TABLE `ariz_icl_string_packages` (
`ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`kind_slug` varchar(160) COLLATE utf8mb4_unicode_ci NOT NULL,
`kind` varchar(160) COLLATE utf8mb4_unicode_ci NOT NULL,
`name` varchar(160) COLLATE utf8mb4_unicode_ci NOT NULL,
`title` varchar(160) COLLATE utf8mb4_unicode_ci NOT NULL,
`edit_link` text COLLATE utf8mb4_unicode_ci NOT NULL,
`view_link` text COLLATE utf8mb4_unicode_ci NOT NULL,
`post_id` int(11) DEFAULT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;