{"slug":"cardealerpress","name":"CarDealerPress","description":"In order to use CarDealerPress a subscription is required with DealerTrend. The plugin utilizes their API to pull automotive data.","author":"DealerTrend","active_installs":30,"version":"7.0.2606.01","wp_org_url":"https://wordpress.org/plugins/cardealerpress/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"cdp_companies","full_table_name":"wp_cdp_companies","description":"Stores cdp companies data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_cdp_companies` (\\n  `id` bigint NOT NULL AUTO_INCREMENT,\\n  `blog_id` int NOT NULL,\\n  `company_id` int NOT NULL,\\n  `dealer_id` int NOT NULL,\\n  `name` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `street` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `city` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `state` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `zip` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `phone` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `country_code` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `apikeys` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `automalls` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `created` date NOT NULL,\\n  `last_updated` datetime NOT NULL,\\n  `inventory_last_updated` datetime NOT NULL,\\n  `inventory_api_last_modified` datetime NOT NULL,\\n  `inventory_last_checked` datetime NOT NULL,\\n  `inventory_last_checked_response` datetime NOT NULL,\\n  `seo` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  PRIMARY KEY (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"cdp_data","full_table_name":"wp_cdp_data","description":"Stores cdp data data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_cdp_data` (\\n  `data_id` bigint NOT NULL AUTO_INCREMENT,\\n  `blog_id` int NOT NULL,\\n  `dealer_id` int NOT NULL,\\n  `data_key` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `data_value` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  UNIQUE KEY `data_id` (`data_id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"cdp_inventory","full_table_name":"wp_cdp_inventory","description":"Stores cdp inventory data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_cdp_inventory` (\\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"},{"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","columns":[],"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"}],"table_count":4}