{"table_name":"cdp_inventory_import","full_table_name":"wp_cdp_inventory_import","description":"Stores cdp inventory import data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"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","columns":[],"plugin":{"slug":"cardealerpress","name":"CarDealerPress","active_installs":30,"version":"7.0.2606.01","wp_org_url":"https://wordpress.org/plugins/cardealerpress/"}}