-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `integracionmarketplacev2`
--

-- --------------------------------------------------------

--
-- Table structure for table `app_proceso`
--

CREATE TABLE `app_proceso` (
  `id_app_proceso` int(11) NOT NULL,
  `marketplace` varchar(100) NOT NULL,
  `id_cliente` bigint(20) DEFAULT NULL,
  `proceso` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `inicio` datetime DEFAULT NULL,
  `fin` datetime DEFAULT NULL,
  `comentario` longtext DEFAULT NULL,
  `estado` tinyint(1) NOT NULL COMMENT '1:iniciado - 2:terminado - 3: Fallido',
  `registro` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `app_proceso`
--

INSERT INTO `app_proceso` (`id_app_proceso`, `marketplace`, `id_cliente`, `proceso`, `inicio`, `fin`, `comentario`, `estado`, `registro`) VALUES
(1, '', 1, 'INVENTARIO-PRECIO', '2023-10-17 15:47:23', NULL, NULL, 1, '2023-10-17 15:47:23'),
(2, '', 1, 'INVENTARIO-PRECIO', '2023-10-17 15:47:55', NULL, NULL, 1, '2023-10-17 15:47:55'),
(3, '', 1, 'INVENTARIO-PRECIO', '2023-10-17 15:59:53', NULL, NULL, 1, '2023-10-17 15:59:53'),
(4, '', 1, 'INVENTARIO-PRECIO', '2023-10-17 11:01:38', NULL, NULL, 1, '2023-10-17 11:01:38'),
(5, '', 1, 'INVENTARIO-PRECIO', '2023-10-17 11:27:03', NULL, NULL, 1, '2023-10-17 11:27:03'),
(6, '', 1, 'INVENTARIO-PRECIO', '2023-10-17 12:22:15', '2023-10-17 12:22:21', '', 2, '2023-10-17 12:22:15'),
(7, '', 1, 'INVENTARIO-PRECIO', '2023-10-17 12:22:48', NULL, NULL, 1, '2023-10-17 12:22:48'),
(8, '', 1, 'INVENTARIO-PRECIO', '2023-10-17 12:24:08', '2023-10-17 12:24:42', '/var/www/html/integracionmarketplace/app/Console/Commands/Mercadolibre/sincronizarInventarioPrecio.php - 86 - Undefined array key \"precio_normal\"', 3, '2023-10-17 12:24:08'),
(9, '', 1, 'INVENTARIO-PRECIO', '2023-10-17 12:33:05', NULL, NULL, 1, '2023-10-17 12:33:05'),
(10, '', 1, 'INVENTARIO-PRECIO', '2023-10-17 13:02:04', NULL, NULL, 1, '2023-10-17 13:02:04'),
(11, '', 1, 'INVENTARIO-PRECIO', '2023-10-17 13:10:39', NULL, NULL, 1, '2023-10-17 13:10:39'),
(12, '', 1, 'INVENTARIO-PRECIO', '2023-10-17 14:18:03', '2023-10-17 14:18:09', '', 2, '2023-10-17 14:18:03'),
(13, '', 1, 'INVENTARIO-PRECIO', '2023-10-17 14:20:43', '2023-10-17 14:20:49', '', 2, '2023-10-17 14:20:43'),
(14, '', 1, 'INVENTARIO-PRECIO', '2023-10-17 14:23:32', NULL, NULL, 1, '2023-10-17 14:23:32'),
(15, '', 1, 'INVENTARIO-PRECIO', '2023-10-17 14:39:48', '2023-10-17 14:40:49', '/var/www/html/integracionmarketplace/app/Service/MercadoLibre/SvcMercadoLibre.php - 1273 - Undefined array key \"attributes\"', 3, '2023-10-17 14:39:48'),
(16, '', 1, 'INVENTARIO-PRECIO', '2023-10-17 15:10:15', '2023-10-17 15:10:17', '/var/www/html/integracionmarketplace/app/Service/MercadoLibre/SvcMercadoLibre.php - 1273 - Undefined array key \"attributes\"', 3, '2023-10-17 15:10:15'),
(17, '', 1, 'INVENTARIO-PRECIO', '2023-10-17 15:11:02', '2023-10-17 15:11:04', '/var/www/html/integracionmarketplace/app/Service/MercadoLibre/SvcMercadoLibre.php - 1273 - Undefined array key \"attributes\"', 3, '2023-10-17 15:11:02'),
(18, '', 1, 'INVENTARIO-PRECIO', '2023-10-17 15:11:20', NULL, NULL, 1, '2023-10-17 15:11:20'),
(19, '', 1, 'INVENTARIO-PRECIO', '2023-10-17 15:12:19', '2023-10-17 15:13:42', '/var/www/html/integracionmarketplace/app/Service/MercadoLibre/SvcMercadoLibre.php - 1273 - Undefined array key \"attributes\"', 3, '2023-10-17 15:12:19'),
(20, '', 1, 'INVENTARIO-PRECIO', '2023-10-17 15:14:05', NULL, NULL, 1, '2023-10-17 15:14:05'),
(21, '', 1, 'INVENTARIO-PRECIO', '2023-10-17 15:15:19', NULL, NULL, 1, '2023-10-17 15:15:19'),
(22, '', 1, 'INVENTARIO-PRECIO', '2023-10-17 15:16:07', NULL, NULL, 1, '2023-10-17 15:16:07'),
(23, '', 1, 'INVENTARIO-PRECIO', '2023-10-17 15:17:44', NULL, NULL, 1, '2023-10-17 15:17:44'),
(24, '', 1, 'INVENTARIO-PRECIO', '2023-10-17 15:20:02', '2023-10-17 15:20:48', '', 2, '2023-10-17 15:20:02'),
(25, '', 1, 'INVENTARIO-PRECIO', '2023-10-17 15:21:10', '2023-10-17 15:21:19', '', 2, '2023-10-17 15:21:10'),
(26, '', 1, 'INVENTARIO-PRECIO', '2023-10-17 15:22:40', NULL, NULL, 1, '2023-10-17 15:22:40'),
(27, '', 1, 'INVENTARIO-PRECIO', '2023-10-17 15:24:19', '2023-10-17 15:24:25', '', 2, '2023-10-17 15:24:19'),
(28, '', 1, 'INVENTARIO-PRECIO', '2023-10-17 15:24:48', NULL, NULL, 1, '2023-10-17 15:24:48'),
(29, '', 1, 'INVENTARIO-PRECIO', '2023-10-17 15:25:46', NULL, NULL, 1, '2023-10-17 15:25:46'),
(30, '', 1, 'INVENTARIO-PRECIO', '2023-10-17 15:26:02', NULL, NULL, 1, '2023-10-17 15:26:02'),
(31, '', 1, 'INVENTARIO-PRECIO', '2023-10-17 15:27:29', NULL, NULL, 1, '2023-10-17 15:27:29'),
(32, '', 1, 'INVENTARIO-PRECIO', '2023-10-17 15:28:23', NULL, NULL, 1, '2023-10-17 15:28:23'),
(33, '', 1, 'INVENTARIO-PRECIO', '2023-10-17 15:30:35', '2023-10-17 15:30:48', '', 2, '2023-10-17 15:30:35'),
(34, '', 1, 'INVENTARIO-PRECIO', '2023-10-17 15:31:07', '2023-10-17 15:31:13', '', 2, '2023-10-17 15:31:07'),
(35, '', 1, 'INVENTARIO-PRECIO', '2023-10-17 15:32:36', '2023-10-17 15:32:42', '', 2, '2023-10-17 15:32:36'),
(36, '', 1, 'INVENTARIO-PRECIO', '2023-10-17 15:34:13', '2023-10-17 15:34:19', '', 2, '2023-10-17 15:34:13'),
(37, '', 1, 'INVENTARIO-PRECIO', '2023-10-17 15:39:32', '2023-10-17 15:39:46', '', 2, '2023-10-17 15:39:32'),
(38, '', 1, 'INVENTARIO-PRECIO', '2023-10-17 15:41:08', '2023-10-17 15:41:14', '', 2, '2023-10-17 15:41:08'),
(39, '', 1, 'INVENTARIO-PRECIO', '2023-10-17 15:43:11', '2023-10-17 15:43:17', '', 2, '2023-10-17 15:43:11'),
(40, '', 1, 'INVENTARIO-PRECIO', '2023-10-17 15:45:21', '2023-10-17 15:45:27', '', 2, '2023-10-17 15:45:21'),
(41, '', 1, 'INVENTARIO-PRECIO', '2023-10-17 15:47:55', '2023-10-17 15:48:01', '', 2, '2023-10-17 15:47:55'),
(42, '', 1, 'INVENTARIO-PRECIO', '2023-10-17 15:48:13', '2023-10-17 15:48:19', '', 2, '2023-10-17 15:48:13'),
(43, '', 1, 'INVENTARIO-PRECIO', '2023-10-17 16:33:18', '2023-10-17 16:48:23', '', 2, '2023-10-17 16:33:18'),
(44, '', 1, 'INVENTARIO-PRECIO', '2023-10-17 16:53:34', '2023-10-17 16:53:39', '', 2, '2023-10-17 16:53:34'),
(45, '', 1, 'INVENTARIO-PRECIO', '2023-10-17 16:53:55', '2023-10-17 16:54:19', '', 2, '2023-10-17 16:53:55'),
(46, '', 1, 'INVENTARIO-PRECIO', '2023-10-17 16:54:33', NULL, NULL, 1, '2023-10-17 16:54:33'),
(47, '', 1, 'INVENTARIO-PRECIO', '2023-10-17 17:00:17', '2023-10-17 17:01:06', '', 2, '2023-10-17 17:00:17'),
(48, '', 1, 'INVENTARIO-PRECIO', '2023-10-17 17:01:54', '2023-10-17 17:01:59', '', 2, '2023-10-17 17:01:54'),
(49, '', 1, 'INVENTARIO-PRECIO', '2023-10-17 17:06:38', NULL, NULL, 1, '2023-10-17 17:06:38'),
(50, '', 1, 'INVENTARIO-PRECIO', '2023-10-17 17:07:51', '2023-10-17 17:07:56', '', 2, '2023-10-17 17:07:51'),
(51, '', 1, 'INVENTARIO-PRECIO', '2023-10-17 17:16:52', '2023-10-17 17:16:57', '', 2, '2023-10-17 17:16:52'),
(52, '', 1, 'INVENTARIO-PRECIO', '2023-10-17 17:17:33', '2023-10-17 17:17:38', '', 2, '2023-10-17 17:17:33'),
(53, '', 1, 'INVENTARIO-PRECIO', '2023-10-17 17:19:59', '2023-10-17 17:20:06', '', 2, '2023-10-17 17:19:59'),
(54, '', 1, 'INVENTARIO-PRECIO', '2023-10-17 17:20:30', '2023-10-17 17:20:36', '', 2, '2023-10-17 17:20:30'),
(55, '', 1, 'INVENTARIO-PRECIO', '2023-10-17 17:21:14', '2023-10-17 17:21:20', '', 2, '2023-10-17 17:21:14'),
(56, 'mercadolibre', 1, 'INVENTARIO-PRECIO', '2023-10-18 09:44:35', NULL, NULL, 1, '2023-10-18 09:44:35'),
(57, 'mercadolibre', 1, 'INVENTARIO-PRECIO', '2023-10-18 10:07:59', '2023-10-18 10:11:18', '', 2, '2023-10-18 10:07:59'),
(58, 'mercadolibre', 1, 'INVENTARIO-PRECIO', '2023-10-18 11:14:51', '2023-10-18 11:14:55', '/var/www/html/integracionmarketplace/app/Console/Commands/Mercadolibre/sincronizarInventarioPrecio.php - 146 - Trying to access array offset on value of type null', 3, '2023-10-18 11:14:51'),
(59, 'mercadolibre', 1, 'INVENTARIO-PRECIO', '2023-10-18 11:27:24', '2023-10-18 11:27:27', '/var/www/html/integracionmarketplace/app/Console/Commands/Mercadolibre/sincronizarInventarioPrecio.php - 160 - Trying to access array offset on value of type null', 3, '2023-10-18 11:27:24'),
(60, 'mercadolibre', 1, 'INVENTARIO-PRECIO', '2023-10-18 11:29:33', '2023-10-18 11:29:39', '/var/www/html/integracionmarketplace/app/Console/Commands/Mercadolibre/sincronizarInventarioPrecio.php - 176 - Trying to access array offset on value of type null', 3, '2023-10-18 11:29:33'),
(61, 'mercadolibre', 1, 'INVENTARIO-PRECIO', '2023-10-18 11:30:45', '2023-10-18 11:30:51', '', 2, '2023-10-18 11:30:45');

-- --------------------------------------------------------

--
-- Table structure for table `cliente_configuracion`
--

CREATE TABLE `cliente_configuracion` (
  `id_configuracion` bigint(20) UNSIGNED NOT NULL,
  `id_cliente` bigint(20) UNSIGNED NOT NULL,
  `campo` varchar(40) NOT NULL,
  `valor` varchar(250) NOT NULL,
  `registro` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cliente_configuracion`
--

INSERT INTO `cliente_configuracion` (`id_configuracion`, `id_cliente`, `campo`, `valor`, `registro`) VALUES
(1, 1, 'ml_porcentaje_aumento', '10', '2023-07-26 21:20:01'),
(2, 1, 'ml_precio_dif_porcentaje', '2', '2023-07-26 21:20:01'),
(4, 1, 'ml_tipo_publicacion', 'gold_premium', '2023-07-27 13:22:07'),
(5, 1, 'ml_metodo_pago', 'mercado_pago', '2023-07-27 13:22:07'),
(6, 1, 'ml_predecir_categoria', 'true', '2023-07-27 13:22:34'),
(7, 1, 'ml_recortar_titulo', 'true', '2023-07-27 13:22:34'),
(8, 1, 'ml_estado_producto', 'new', '2023-07-27 13:27:57'),
(9, 1, 'ml_retirar_en_local', 'false', '2023-07-27 13:27:57'),
(10, 1, 'ml_envio_gratis', 'true', '2023-07-27 13:27:57'),
(11, 1, 'ml_garantia', 'TTE', '2023-07-27 14:08:23'),
(12, 1, 'ml_pais_codigo', 'MCO', '2023-07-27 14:08:23'),
(13, 1, 'ml_token_actual', 'APP_USR-8830017051799690-102010-ab14e46d9124f4ad1aa883590a42960a-1421612009', '2023-09-26 16:34:51'),
(14, 1, 'ml_refresh_token', 'TG-6532933d7d1cdf0001d3941f-1421612009', '2023-09-26 16:34:51'),
(15, 1, 'ml_expira_token', '1697834908', '2023-09-26 16:34:51'),
(16, 1, 'ml_cliente_id', '1421612009', '2023-09-26 16:34:51'),
(17, 1, 'api_sincroniza_getcategoria', 'https://virtualllantas.com/conectaproductosws/magento/RestControlador.php?accion=categorias', '2023-09-26 16:34:51'),
(18, 1, 'api_sincroniza_url_producto_info', 'http://localhost/integracionmarketplace/public/api-test/consultar-inventario', '2023-09-26 16:34:51'),
(19, 1, 'api_sincroniza_url_inv_precio', 'http://localhost/integracionmarketplace/public/api-test/consultar-inventario', '2023-09-26 16:34:51');

-- --------------------------------------------------------

--
-- Table structure for table `maestro_atributo`
--

CREATE TABLE `maestro_atributo` (
  `id_atributo` bigint(20) UNSIGNED NOT NULL,
  `id_pais` bigint(20) UNSIGNED NOT NULL,
  `nombre` varchar(255) NOT NULL,
  `ml_codigo` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `maestro_atributo`
--

INSERT INTO `maestro_atributo` (`id_atributo`, `id_pais`, `nombre`, `ml_codigo`) VALUES
(1, 1, 'Color Primario', '11000');

-- --------------------------------------------------------

--
-- Table structure for table `maestro_pais`
--

CREATE TABLE `maestro_pais` (
  `id_pais` bigint(20) UNSIGNED NOT NULL,
  `iso_2` varchar(2) NOT NULL,
  `iso_3` varchar(3) NOT NULL,
  `cod_moneda` varchar(3) NOT NULL,
  `nombre` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `maestro_pais`
--

INSERT INTO `maestro_pais` (`id_pais`, `iso_2`, `iso_3`, `cod_moneda`, `nombre`) VALUES
(1, 'CO', 'COL', 'COP', 'COLOMBIA'),
(2, 'MX', 'MEX', 'MXN', 'MÉXICO'),
(3, 'CL', 'CLP', 'CLP', 'CHILE'),
(4, 'PE', 'PER', 'PEN', 'PERU');

-- --------------------------------------------------------

--
-- Table structure for table `maestro_producto_atributo_equiv`
--

CREATE TABLE `maestro_producto_atributo_equiv` (
  `id_equivalencia` bigint(20) UNSIGNED NOT NULL,
  `id_cliente` bigint(20) UNSIGNED NOT NULL,
  `id_atributo` bigint(20) UNSIGNED NOT NULL,
  `cliente_valor` varchar(50) NOT NULL,
  `ml_etiqueta` varchar(50) NOT NULL,
  `ml_codigo` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `maestro_producto_cat_equiv`
--

CREATE TABLE `maestro_producto_cat_equiv` (
  `id_equivalencia` bigint(20) UNSIGNED NOT NULL,
  `id_cliente` bigint(20) UNSIGNED NOT NULL,
  `categoria_externa` varchar(150) NOT NULL,
  `categoria_ml_codigo` varchar(20) NOT NULL,
  `categoria_ml_nombre` varchar(150) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2019_12_14_000001_create_personal_access_tokens_table', 1);

-- --------------------------------------------------------

--
-- Table structure for table `producto`
--

CREATE TABLE `producto` (
  `id_producto` bigint(20) UNSIGNED NOT NULL,
  `id_cliente` bigint(20) UNSIGNED NOT NULL,
  `origen_url` varchar(255) NOT NULL,
  `origen_url_imagen` varchar(255) NOT NULL,
  `codigo` varchar(255) NOT NULL,
  `nombre` varchar(255) NOT NULL,
  `inventario_minimo` int(11) NOT NULL,
  `cantidad` int(11) NOT NULL DEFAULT 0,
  `precio_normal` double(12,2) NOT NULL,
  `ultimo_precio` double(12,2) NOT NULL,
  `sincronizar_inventario` tinyint(4) NOT NULL DEFAULT 1,
  `sincronizar_precio` tinyint(4) NOT NULL DEFAULT 1,
  `inv_actualizado` datetime DEFAULT NULL,
  `registro_fecha` datetime NOT NULL,
  `actualizado` datetime DEFAULT NULL,
  `estado_general` tinyint(4) NOT NULL COMMENT 'Indica si el producto esta deshabilitado en ML para vender'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `producto`
--

INSERT INTO `producto` (`id_producto`, `id_cliente`, `origen_url`, `origen_url_imagen`, `codigo`, `nombre`, `inventario_minimo`, `cantidad`, `precio_normal`, `ultimo_precio`, `sincronizar_inventario`, `sincronizar_precio`, `inv_actualizado`, `registro_fecha`, `actualizado`, `estado_general`) VALUES
(55, 1, '', '', '', 'Combo 4 Llantas Acenda 265/65 R17 Item De Prueba - Por Favo', 0, 0, 593900.00, 593900.00, 1, 1, NULL, '2023-10-20 11:11:23', NULL, 0),
(56, 1, '', '', '', 'Llanta Bridgestone Ecopia Ep422 195/55r16 86 V', 0, 30, 2639555.00, 2639555.00, 1, 1, NULL, '2023-10-20 11:11:23', NULL, 0),
(57, 1, '', '', '', 'Combo 4 Llantas Acenda 265/65 R17 Item De Prueba - Por Favo', 0, 0, 593900.00, 593900.00, 1, 1, NULL, '2023-10-20 11:11:23', NULL, 0),
(58, 1, '', '', '', 'Llanta Ceat 90/90-17 Zoom X3 F Envío Gratis', 0, 10, 659888.00, 659888.00, 1, 1, NULL, '2023-10-20 11:11:24', NULL, 0),
(59, 1, '', '', '', 'Llanta Hifly Hf201 P 165/65r14 79 Ta', 0, 0, 11905.00, 11905.00, 1, 1, NULL, '2023-10-20 11:11:24', NULL, 0),
(60, 1, '', '', '', 'Llanta Michelin 245/70 R16 Ltx Force Envío Gratis', 0, 10, 593900.00, 593900.00, 1, 1, NULL, '2023-10-20 11:11:24', NULL, 0);

-- --------------------------------------------------------

--
-- Table structure for table `producto_historico_inventario`
--

CREATE TABLE `producto_historico_inventario` (
  `id_producto_historico_inventario` int(11) NOT NULL,
  `id_proceso` int(11) DEFAULT NULL,
  `id_producto` bigint(20) UNSIGNED NOT NULL,
  `inventario` double(12,2) NOT NULL,
  `precio` double(12,2) NOT NULL,
  `registro` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `producto_mercadolibre`
--

CREATE TABLE `producto_mercadolibre` (
  `id_producto_mercadolibre` bigint(20) UNSIGNED NOT NULL,
  `id_producto` bigint(20) UNSIGNED NOT NULL,
  `identificador` varchar(20) NOT NULL,
  `url` varchar(250) NOT NULL,
  `url_imagen` varchar(250) NOT NULL,
  `sincronizar_inventario` tinyint(4) NOT NULL,
  `sincronizar_precio` tinyint(4) NOT NULL,
  `estado` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `producto_mercadolibre`
--

INSERT INTO `producto_mercadolibre` (`id_producto_mercadolibre`, `id_producto`, `identificador`, `url`, `url_imagen`, `sincronizar_inventario`, `sincronizar_precio`, `estado`) VALUES
(1, 55, 'MCO1314512443', 'https://articulo.mercadolibre.com.co/MCO-1314512443-combo-4-llantas-acenda-26565-r17-item-de-prueba-por-favo-_JM', 'http://http2.mlstatic.com/resources/frontend/statics/processing-image/1.0.0/I-ES.jpg', 1, 1, 'paused'),
(2, 56, 'MCO1342672227', 'https://articulo.mercadolibre.com.co/MCO-1342672227-llanta-bridgestone-ecopia-ep422-19555r16-86-v-_JM', 'http://http2.mlstatic.com/D_937640-MLA31181893020_062019-I.jpg', 1, 1, 'active'),
(3, 57, 'MCO1314450185', 'https://articulo.mercadolibre.com.co/MCO-1314450185-combo-4-llantas-acenda-26565-r17-item-de-prueba-por-favo-_JM', 'http://http2.mlstatic.com/resources/frontend/statics/processing-image/1.0.0/I-ES.jpg', 1, 1, 'paused'),
(4, 58, 'MCO1335775869', 'https://articulo.mercadolibre.com.co/MCO-1335775869-llanta-ceat-9090-17-zoom-x3-f-envio-gratis-_JM', 'http://http2.mlstatic.com/D_679116-MCO72245694776_102023-I.jpg', 1, 1, 'active'),
(5, 59, 'MCO1342633629', 'https://articulo.mercadolibre.com.co/MCO-1342633629-llanta-hifly-hf201-p-16565r14-79-ta-_JM', 'http://http2.mlstatic.com/D_800532-MLA51173829386_082022-I.jpg', 1, 1, 'paused'),
(6, 60, 'MCO1335547329', 'https://articulo.mercadolibre.com.co/MCO-1335547329-llanta-michelin-24570-r16-ltx-force-envio-gratis-_JM', 'http://http2.mlstatic.com/D_773084-MCO72382790237_102023-I.jpg', 1, 1, 'active');

-- --------------------------------------------------------

--
-- Table structure for table `producto_mercadolibre_variacion`
--

CREATE TABLE `producto_mercadolibre_variacion` (
  `producto_variacion` bigint(20) UNSIGNED NOT NULL,
  `id_producto` bigint(20) UNSIGNED NOT NULL,
  `producto_codigo` varchar(50) NOT NULL,
  `inventario` double(8,2) NOT NULL,
  `variacion_id` varchar(30) NOT NULL,
  `variacion_imagen` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `producto_mercadolibre_variacion`
--

INSERT INTO `producto_mercadolibre_variacion` (`producto_variacion`, `id_producto`, `producto_codigo`, `inventario`, `variacion_id`, `variacion_imagen`) VALUES
(1, 56, '', 30.00, '180063000211', ''),
(2, 59, '', 0.00, '180170736377', ''),
(3, 59, '', 0.00, '180171943099', '');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `app_proceso`
--
ALTER TABLE `app_proceso`
  ADD PRIMARY KEY (`id_app_proceso`);

--
-- Indexes for table `cliente_configuracion`
--
ALTER TABLE `cliente_configuracion`
  ADD PRIMARY KEY (`id_configuracion`),
  ADD KEY `config_id_cliente` (`id_cliente`);

--
-- Indexes for table `maestro_atributo`
--
ALTER TABLE `maestro_atributo`
  ADD PRIMARY KEY (`id_atributo`),
  ADD KEY `maestro_id_pais` (`id_pais`);

--
-- Indexes for table `maestro_pais`
--
ALTER TABLE `maestro_pais`
  ADD PRIMARY KEY (`id_pais`);

--
-- Indexes for table `maestro_producto_atributo_equiv`
--
ALTER TABLE `maestro_producto_atributo_equiv`
  ADD PRIMARY KEY (`id_equivalencia`),
  ADD KEY `maestro_prod_cat_equiv_id_cliente` (`id_cliente`),
  ADD KEY `maestro_id_atributo` (`id_atributo`);

--
-- Indexes for table `maestro_producto_cat_equiv`
--
ALTER TABLE `maestro_producto_cat_equiv`
  ADD PRIMARY KEY (`id_equivalencia`),
  ADD KEY `maestro_cat_equiv_id_cliente` (`id_cliente`);

--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `producto`
--
ALTER TABLE `producto`
  ADD PRIMARY KEY (`id_producto`),
  ADD KEY `producto_id_cliente` (`id_cliente`);

--
-- Indexes for table `producto_historico_inventario`
--
ALTER TABLE `producto_historico_inventario`
  ADD PRIMARY KEY (`id_producto_historico_inventario`),
  ADD KEY `producto_idx` (`id_producto`),
  ADD KEY `proceso_idx` (`id_proceso`);

--
-- Indexes for table `producto_mercadolibre`
--
ALTER TABLE `producto_mercadolibre`
  ADD PRIMARY KEY (`id_producto_mercadolibre`),
  ADD KEY `producto_ml_id_producto` (`id_producto`);

--
-- Indexes for table `producto_mercadolibre_variacion`
--
ALTER TABLE `producto_mercadolibre_variacion`
  ADD PRIMARY KEY (`producto_variacion`),
  ADD UNIQUE KEY `producto_mercadolibre_variacion_variacion_id_unique` (`variacion_id`),
  ADD KEY `producto_ml_vr_id_producto` (`id_producto`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `app_proceso`
--
ALTER TABLE `app_proceso`
  MODIFY `id_app_proceso` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=62;

--
-- AUTO_INCREMENT for table `cliente_configuracion`
--
ALTER TABLE `cliente_configuracion`
  MODIFY `id_configuracion` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;

--
-- AUTO_INCREMENT for table `maestro_atributo`
--
ALTER TABLE `maestro_atributo`
  MODIFY `id_atributo` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `maestro_pais`
--
ALTER TABLE `maestro_pais`
  MODIFY `id_pais` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `maestro_producto_atributo_equiv`
--
ALTER TABLE `maestro_producto_atributo_equiv`
  MODIFY `id_equivalencia` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `maestro_producto_cat_equiv`
--
ALTER TABLE `maestro_producto_cat_equiv`
  MODIFY `id_equivalencia` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT for table `producto`
--
ALTER TABLE `producto`
  MODIFY `id_producto` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=61;

--
-- AUTO_INCREMENT for table `producto_historico_inventario`
--
ALTER TABLE `producto_historico_inventario`
  MODIFY `id_producto_historico_inventario` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `producto_mercadolibre`
--
ALTER TABLE `producto_mercadolibre`
  MODIFY `id_producto_mercadolibre` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `producto_mercadolibre_variacion`
--
ALTER TABLE `producto_mercadolibre_variacion`
  MODIFY `producto_variacion` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `cliente_configuracion`
--
ALTER TABLE `cliente_configuracion`
  ADD CONSTRAINT `config_id_cliente` FOREIGN KEY (`id_cliente`) REFERENCES `cliente` (`id_cliente`);

--
-- Constraints for table `maestro_atributo`
--
ALTER TABLE `maestro_atributo`
  ADD CONSTRAINT `maestro_id_pais` FOREIGN KEY (`id_pais`) REFERENCES `maestro_pais` (`id_pais`);

--
-- Constraints for table `maestro_producto_atributo_equiv`
--
ALTER TABLE `maestro_producto_atributo_equiv`
  ADD CONSTRAINT `maestro_id_atributo` FOREIGN KEY (`id_atributo`) REFERENCES `maestro_atributo` (`id_atributo`),
  ADD CONSTRAINT `maestro_prod_cat_equiv_id_cliente` FOREIGN KEY (`id_cliente`) REFERENCES `maestro_producto_cat_equiv` (`id_cliente`);

--
-- Constraints for table `maestro_producto_cat_equiv`
--
ALTER TABLE `maestro_producto_cat_equiv`
  ADD CONSTRAINT `maestro_cat_equiv_id_cliente` FOREIGN KEY (`id_cliente`) REFERENCES `cliente` (`id_cliente`);

--
-- Constraints for table `producto`
--
ALTER TABLE `producto`
  ADD CONSTRAINT `producto_id_cliente` FOREIGN KEY (`id_cliente`) REFERENCES `cliente` (`id_cliente`);

--
-- Constraints for table `producto_historico_inventario`
--
ALTER TABLE `producto_historico_inventario`
  ADD CONSTRAINT `proceso` FOREIGN KEY (`id_proceso`) REFERENCES `app_proceso` (`id_app_proceso`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `producto` FOREIGN KEY (`id_producto`) REFERENCES `producto` (`id_producto`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Constraints for table `producto_mercadolibre`
--
ALTER TABLE `producto_mercadolibre`
  ADD CONSTRAINT `producto_ml_id_producto` FOREIGN KEY (`id_producto`) REFERENCES `producto` (`id_producto`);

--
-- Constraints for table `producto_mercadolibre_variacion`
--
ALTER TABLE `producto_mercadolibre_variacion`
  ADD CONSTRAINT `producto_ml_vr_id_producto` FOREIGN KEY (`id_producto`) REFERENCES `producto` (`id_producto`);
COMMIT;

