wp_i2_azon_items

Verified

Stores i2 azon items data created by this plugin.

CREATE TABLE Statement

CREATE TABLE `wp_i2_azon_items` (\n  `id` bigint NOT NULL AUTO_INCREMENT,\n  `status` varchar(20) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\n  `asin` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL,\n  `product_group` varchar(500) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\n  `title` text COLLATE utf8mb4_unicode_520_ci,\n  `brand` varchar(500) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\n  `url` longtext COLLATE utf8mb4_unicode_520_ci,\n  `features` longtext COLLATE utf8mb4_unicode_520_ci,\n  `contributors` longtext COLLATE utf8mb4_unicode_520_ci,\n  `content_info` longtext COLLATE utf8mb4_unicode_520_ci,\n  `manufacturer` varchar(500) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\n  `item_part_number` varchar(500) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\n  `model` varchar(500) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\n  `salesrank` bigint DEFAULT NULL,\n  `image_ids` longtext COLLATE utf8mb4_unicode_520_ci,\n  `availability` varchar(200) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\n  `conditions` varchar(200) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\n  `is_amazon_fulfilled` tinyint(1) DEFAULT NULL,\n  `is_prime_eligible` tinyint(1) DEFAULT NULL,\n  `price` varchar(50) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\n  `display_price` varchar(50) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\n  `currency` varchar(10) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\n  `saving_percentage` tinyint DEFAULT NULL,\n  `saving_amount` varchar(50) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\n  `rating` varchar(10) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\n  `reviews` bigint DEFAULT NULL,\n  `reviews_updated` datetime DEFAULT NULL,\n  `date_created` datetime NOT NULL,\n  `date_updated` datetime NOT NULL,\n  `is_modified` tinyint(1) DEFAULT NULL,\n  `added_by_extention` tinyint(1) DEFAULT '0',\n  PRIMARY KEY (`id`),\n  UNIQUE KEY `asin` (`asin`),\n  KEY `status` (`status`),\n  KEY `reviews` (`reviews`),\n  KEY `reviews_updated` (`reviews_updated`),\n  KEY `date_updated` (`date_updated`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci

Safe to delete?

If you have uninstalled i2 AZON, this table is generally safe to remove. However, always back up your database first.

Note: Some plugins share tables or are dependencies of other plugins. Verify nothing else depends on this table before dropping it.

How to remove this table

DROP TABLE IF EXISTS `wp_i2_azon_items`;

Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.