wp_cdp_inventory_import

CREATE TABLE Statement

CREATE TABLE `wp_cdp_inventory_import` (\n  `id` bigint NOT NULL AUTO_INCREMENT,\n  `blog_id` int NOT NULL DEFAULT '1',\n  `vms_id` int NOT NULL,\n  `company_id` int NOT NULL,\n  `dealer_id` int NOT NULL,\n  `dealer` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\n  `stock` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\n  `vin` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\n  `saleclass` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\n  `certified` tinyint(1) NOT NULL DEFAULT '0',\n  `make` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\n  `model` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\n  `model_code` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\n  `trim` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\n  `year` int NOT NULL,\n  `askingprice` decimal(18,0) NOT NULL,\n  `saleprice` decimal(18,0) NOT NULL,\n  `retailprice` decimal(18,0) NOT NULL,\n  `msrp` decimal(18,0) NOT NULL,\n  `invoice` decimal(18,0) NOT NULL,\n  `sortprice` decimal(18,0) NOT NULL,\n  `pricesort` int NOT NULL DEFAULT '0',\n  `sale_expire` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\n  `headline` varchar(512) COLLATE utf8mb4_unicode_520_ci NOT NULL,\n  `description` text COLLATE utf8mb4_unicode_520_ci NOT NULL,\n  `exterior` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\n  `interior` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\n  `color_map` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\n  `color_map_int` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\n  `body` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\n  `vehicleclass` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\n  `tags` varchar(350) COLLATE utf8mb4_unicode_520_ci NOT NULL,\n  `drivetrain` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\n  `doors` varchar(10) COLLATE utf8mb4_unicode_520_ci NOT NULL,\n  `engine` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\n  `transmission` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\n  `fuel_type` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\n  `highway` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\n  `city` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\n  `odometer` int NOT NULL,\n  `carfax` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\n  `carfax_image_url` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\n  `autocheck` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\n  `video` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\n  `acode` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\n  `thumbnail` varchar(350) COLLATE utf8mb4_unicode_520_ci NOT NULL,\n  `image_medium` varchar(350) COLLATE utf8mb4_unicode_520_ci NOT NULL,\n  `geo_state` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\n  `geo_city` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\n  `geo_zip` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\n  `location` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\n  `phone` varchar(100) COLLATE utf8mb4_unicode_520_ci NOT NULL,\n  `created` datetime NOT NULL,\n  `updated` datetime NOT NULL,\n  `sold_on` varchar(10) COLLATE utf8mb4_unicode_520_ci DEFAULT '',\n  `sort` int NOT NULL DEFAULT '0',\n  `extra` text COLLATE utf8mb4_unicode_520_ci NOT NULL,\n  `vehicle_url` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\n  `payment` decimal(18,0) NOT NULL,\n  UNIQUE KEY `id` (`id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci

Safe to delete?

How to remove this table

DROP TABLE IF EXISTS `wp_cdp_inventory_import`;

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

Other tables from CarDealerPress