WordPress database error: [Unknown storage engine 'InnoDB']CREATE TABLE IF NOT EXISTS `wp_amz_amazon_cache` (
`ID` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
`cache_name` VARCHAR(100) NOT NULL,
`cache_type` VARCHAR(20) NOT NULL,
`country` VARCHAR(30) NOT NULL,
`response` LONGTEXT NOT NULL,
`response_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`provider` VARCHAR(20) NOT NULL DEFAULT 'amazon',
PRIMARY KEY (`ID`),
UNIQUE INDEX `cache_name_cache_type` (`cache_name`, `cache_type`),
INDEX `cache_type` (`cache_type`),
INDEX `response_date` (`response_date`),
INDEX `provider` (`provider`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci
WordPress database error: [Unknown storage engine 'InnoDB']CREATE TABLE IF NOT EXISTS `wp_amz_import_stats` (
`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
`post_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
`post_title` TEXT NOT NULL,
`asin` VARCHAR(100) NOT NULL,
`provider` VARCHAR(20) NOT NULL DEFAULT 'amazon',
`country` VARCHAR(30) NOT NULL,
`from_op` VARCHAR(40) NOT NULL COMMENT '[insane|direct|auto|search]#[some code]',
`from_op_p1` VARCHAR(20) NOT NULL,
`from_op_p2` VARCHAR(40) NOT NULL,
`imported_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
`import_status_msg` TEXT NOT NULL,
`duration_spin` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`duration_attributes` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`duration_vars` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`duration_nb_vars` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`duration_img` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`duration_nb_img` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`duration_img_dw` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`duration_nb_img_dw` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`duration_product` INT(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'duration_spin, duration_attributes, duration_vars, duration_img, other product import operations, but does not contain duration_img_dw',
`db_calc` TEXT NOT NULL,
PRIMARY KEY (`id`),
INDEX `post_id` (`post_id`),
INDEX `asin` (`asin`),
INDEX `provider` (`provider`),
INDEX `country` (`country`),
INDEX `from_op_p1` (`from_op_p1`),
INDEX `from_op_p2` (`from_op_p2`),
INDEX `from_op` (`from_op`),
INDEX `duration_product` (`duration_product`),
INDEX `duration_img_dw` (`duration_img_dw`),
INDEX `duration_nb_img_dw` (`duration_nb_img_dw`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci
WordPress database error: [Unknown storage engine 'InnoDB']CREATE TABLE `wp_amz_sync_widget` (
`ID` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
`bulk_code` VARCHAR(32) NOT NULL COMMENT 'md5( concate( bulk_asins, country ) )',
`bulk_asins` TEXT NOT NULL COMMENT 'array_serialized( post_id => asin )',
`country` VARCHAR(30) NOT NULL,
`status` VARCHAR(20) NULL DEFAULT NULL,
`status_msg` TEXT NULL COMMENT 'array_serialized( msg => text, msg_full => text )',
`widget_response` MEDIUMTEXT NULL COMMENT 'widget_response and widget_response_date are used also as a mini-cache system',
`widget_response_date` DATETIME NULL DEFAULT NULL,
`created_date` DATETIME NOT NULL,
PRIMARY KEY (`ID`),
UNIQUE INDEX `bulk_code` (`bulk_code`),
INDEX `country` (`country`),
INDEX `status` (`status`),
INDEX `created_date` (`created_date`),
INDEX `widget_response_date` (`widget_response_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci
WordPress database error: [Unknown storage engine 'InnoDB']CREATE TABLE `wp_amz_sync_widget_asins` (
`asin` VARCHAR(50) NOT NULL,
`country` VARCHAR(30) NOT NULL,
`post_id` BIGINT(20) UNSIGNED NOT NULL,
UNIQUE INDEX `post_id` (`post_id`),
INDEX `country` (`country`),
INDEX `asin_country` (`asin`, `country`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci