-- phpMyAdmin SQL Dump -- version 4.9.7 -- https://www.phpmyadmin.net/ -- -- Servidor: localhost:3306 -- Tiempo de generación: 10-07-2022 a las 17:23:43 -- Versión del servidor: 10.3.35-MariaDB-log-cll-lve -- Versión de PHP: 7.4.29 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET AUTOCOMMIT = 0; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Base de datos: `grupkllq_elrefugio` -- -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `abonos_proveedores` -- CREATE TABLE `abonos_proveedores` ( `id` bigint(20) UNSIGNED NOT NULL, `proveedor_id` bigint(20) UNSIGNED NOT NULL, `valor` double NOT NULL, `tipo` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `descripcion` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `fecha_cobro` date DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Volcado de datos para la tabla `abonos_proveedores` -- INSERT INTO `abonos_proveedores` (`id`, `proveedor_id`, `valor`, `tipo`, `descripcion`, `fecha_cobro`, `created_at`, `updated_at`) VALUES (2, 4, 4000, 'EFECTIVO', 'ANTICIPO', '2022-01-27', '2022-01-28 20:12:56', '2022-01-28 20:12:56'); -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `abono_clientes` -- CREATE TABLE `abono_clientes` ( `id` bigint(20) UNSIGNED NOT NULL, `cliente_id` bigint(20) UNSIGNED NOT NULL, `descripcion` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `total` double NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Volcado de datos para la tabla `abono_clientes` -- INSERT INTO `abono_clientes` (`id`, `cliente_id`, `descripcion`, `total`, `created_at`, `updated_at`) VALUES (1, 30, 'ABONO', 221, '2022-07-06 18:52:36', '2022-07-06 18:52:36'), (2, 15, 'CANCELO HENO', 375, '2022-07-06 19:36:58', '2022-07-06 19:36:58'), (3, 31, NULL, 545, '2022-07-06 19:42:13', '2022-07-06 19:42:13'), (4, 22, 'pago de vita postura fase 1', 1440, '2022-07-07 17:11:26', '2022-07-07 17:11:26'), (5, 15, 'cancelo flumeg y dipiron', 240, '2022-07-07 19:33:39', '2022-07-07 19:33:39'), (6, 28, 'cancelo', 640, '2022-07-08 13:34:22', '2022-07-08 13:34:22'), (7, 20, 'abono de deuda', 1150, '2022-07-08 15:51:30', '2022-07-08 15:51:30'), (8, 20, NULL, 200, '2022-07-08 19:30:37', '2022-07-08 19:30:37'), (9, 30, NULL, 58, '2022-07-08 20:01:39', '2022-07-08 20:01:39'); -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `articulos` -- CREATE TABLE `articulos` ( `id` bigint(20) UNSIGNED NOT NULL, `categoria_id` bigint(20) UNSIGNED NOT NULL, `proveedor_id` bigint(20) UNSIGNED NOT NULL, `nombre` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `cod_barras` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `descripcion` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `descripcion_interna` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `p_venta` double(7,2) NOT NULL, `p_costo` double(7,2) NOT NULL, `p_descuento` double DEFAULT NULL, `stock` double(7,2) NOT NULL DEFAULT 0.00, `min_stock` double DEFAULT 0, `img` text COLLATE utf8mb4_unicode_ci DEFAULT '', `img2` text COLLATE utf8mb4_unicode_ci DEFAULT '', `fecha_promo` date DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `url_articulo` text COLLATE utf8mb4_unicode_ci DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Volcado de datos para la tabla `articulos` -- INSERT INTO `articulos` (`id`, `categoria_id`, `proveedor_id`, `nombre`, `cod_barras`, `descripcion`, `descripcion_interna`, `p_venta`, `p_costo`, `p_descuento`, `stock`, `min_stock`, `img`, `img2`, `fecha_promo`, `deleted_at`, `created_at`, `updated_at`, `url_articulo`) VALUES (1, 3, 2, 'VITAENGORDE FIN', '01202225081057', '

Alimento para aves de engorde

', NULL, 285.00, 269.00, NULL, -31.00, 5, NULL, NULL, NULL, NULL, '2022-01-25 15:08:57', '2022-07-09 16:50:03', NULL), (2, 3, 2, 'VITAENGORDE INICIO', '01202225101008', '

Alimento para aves de engorde inicio

', NULL, 285.00, 269.00, NULL, 9.00, 5, NULL, NULL, NULL, NULL, '2022-01-25 15:10:08', '2022-07-08 18:51:14', NULL), (3, 3, 2, 'ALIENGORDE PELETIZADO 1', '01202225111047', '

ALIMENTO PARA POLLO DE ENGORDE

', NULL, 295.00, 274.00, NULL, 4.00, 2, NULL, NULL, NULL, NULL, '2022-01-25 15:11:47', '2022-07-09 16:50:03', NULL), (4, 3, 2, 'ALIENGORDE PELETIZADO 2', '01202225121054', '

ALIMENTO PARA POLLO DE ENGORDE

\r\n\r\n

 

', NULL, 295.00, 274.00, NULL, -2.00, 1, NULL, NULL, NULL, NULL, '2022-01-25 15:12:54', '2022-07-08 21:12:05', NULL), (5, 3, 2, 'HARINA ENERGETICA DE MAIZ', '01202225171044', 'Harina Energetica', NULL, 177.00, 150.00, NULL, 5.00, 2, NULL, NULL, NULL, '2022-01-25 16:05:15', '2022-01-25 15:17:44', '2022-01-25 16:05:15', NULL), (6, 3, 2, 'HARINA ENERGETICA DE MAIZ', '01202225171044', '

Harina Energetica

', NULL, 195.00, 185.00, NULL, 12.00, 2, NULL, NULL, NULL, NULL, '2022-01-25 15:17:44', '2022-07-08 21:10:24', NULL), (7, 3, 2, 'VITAPOSTURA FASE 1', '01202225201052', '

Alimento para aves de Postura

', NULL, 245.00, 234.00, NULL, 28.00, 7, NULL, NULL, NULL, NULL, '2022-01-25 15:20:52', '2022-07-09 15:38:51', NULL), (8, 3, 2, 'ALIPONEDORA 1', '01202225221012', '

ALIMENTO PARA GALLINA PONEDORA

', NULL, 230.00, 205.00, NULL, 3.00, 3, NULL, NULL, NULL, NULL, '2022-01-25 15:22:12', '2022-07-08 18:45:07', NULL), (9, 3, 2, 'VITA LECHERO 16', '01202225271050', '

Alimento para ganado lechero - a 17 ltr.

', NULL, 190.00, 174.00, NULL, 12.00, 3, NULL, NULL, NULL, NULL, '2022-01-25 15:27:50', '2022-07-07 19:47:00', NULL), (10, 3, 2, 'VITA LECHERO 18', '01202225291008', '

Alimento para ganado lechero Altas productoras

', NULL, 205.00, 189.00, NULL, 6.00, 5, NULL, NULL, NULL, NULL, '2022-01-25 15:29:08', '2022-07-09 15:38:51', NULL), (11, 3, 2, 'ECONOGANADO', '01202225581000', '

Alimento para Mantenimiento y produccion de Bovinos

', NULL, 155.00, 143.00, NULL, 13.00, 5, NULL, NULL, NULL, NULL, '2022-01-25 15:58:00', '2022-07-09 13:26:51', NULL), (12, 3, 2, 'TORO GRAN CANPEON', '01202225001110', '

Alimento para toretes en crecimiento y toros en servicio

', NULL, 180.00, 167.00, NULL, 4.00, 5, NULL, NULL, NULL, NULL, '2022-01-25 16:00:10', '2022-07-08 19:20:16', NULL), (13, 3, 2, 'ALICERDO 1', '01202225021133', '

Alimento para cerdos

', NULL, 255.00, 235.00, NULL, 6.00, 1, NULL, NULL, NULL, NULL, '2022-01-25 16:02:33', '2022-07-09 13:47:25', NULL), (14, 3, 2, 'ALICERDO 2', '01202225031143', '

ALIMENTO PARA CERDO FINALIZADOR O ENGORDE 

', NULL, 250.00, 229.00, NULL, 20.00, 3, NULL, NULL, NULL, NULL, '2022-01-25 16:03:43', '2022-07-09 16:11:24', NULL), (15, 3, 2, 'ALIENGORDE PELETIZADO 2', '01202225081106', '

Alimento de Pollo de Engorde

', NULL, 250.00, 200.00, NULL, 3.00, 3, NULL, NULL, NULL, '2022-01-28 21:33:44', '2022-01-25 16:08:06', '2022-01-28 21:33:44', NULL), (16, 3, 3, 'CRECI ENGORDINA PURINA', '01202225091130', '

POLLITO EN CRECIMIENTO

', NULL, 277.00, 249.00, NULL, 3.00, 5, NULL, NULL, NULL, NULL, '2022-01-25 16:09:30', '2022-07-08 20:19:49', NULL), (17, 3, 3, 'GESTACION ALIANSA', '01202225101140', '

Alimento para Bovino

', NULL, 267.00, 235.00, NULL, 1.00, 3, NULL, NULL, NULL, NULL, '2022-01-25 16:10:40', '2022-07-04 20:56:09', NULL), (18, 3, 3, 'LACTANCIA ALIANSA', '01202225111115', '

Alimento para Bovino

', NULL, 275.00, 264.00, NULL, 1.00, 3, NULL, NULL, NULL, NULL, '2022-01-25 16:11:15', '2022-07-04 20:55:21', NULL), (19, 3, 3, 'PONEDORA CINTA AZUL', '01202225121116', 'Alimento para Gallina Ponedora', NULL, 225.00, 200.00, NULL, 0.00, 3, NULL, NULL, NULL, NULL, '2022-01-25 16:12:16', '2022-01-25 16:12:16', NULL), (20, 3, 3, 'VITALECHON 4 ALIANSA', '01202225281115', '

Alimento para Cerdos

', NULL, 330.00, 307.00, NULL, 2.00, 3, NULL, NULL, NULL, NULL, '2022-01-25 16:28:15', '2022-07-04 20:24:43', NULL), (21, 3, 3, 'FINALIZADOR', '01202225291148', '

ALIMENTO PARA CERDO

', NULL, 245.00, 230.00, NULL, 0.00, 3, NULL, NULL, NULL, NULL, '2022-01-25 16:29:48', '2022-07-04 19:59:01', NULL), (22, 3, 3, 'MOISA / AFRECHO', '01202225311147', '

Alimento para Consumo Animal

', NULL, 195.00, 150.00, NULL, 2.00, 5, NULL, NULL, NULL, NULL, '2022-01-25 16:31:47', '2022-07-09 15:38:51', NULL), (23, 3, 2, 'VITANOVILLA', '01202225321156', '

Alimento para Ganado Lechero

', NULL, 205.00, 167.00, NULL, 4.00, 3, NULL, NULL, NULL, NULL, '2022-01-25 16:32:56', '2022-07-07 17:12:55', NULL), (24, 3, 3, 'DESARROLLO CINTA AZUL', '01202225341103', '

Alimento para Cerdos

', NULL, 245.00, 230.00, NULL, 0.00, 5, NULL, NULL, NULL, NULL, '2022-01-25 16:34:03', '2022-07-04 19:39:43', NULL), (25, 3, 3, 'SANGRE REAL', '01202228130130', '

ALIMENTO PARA CABALLOS

', NULL, 145.00, 113.00, NULL, 0.00, 2, NULL, NULL, NULL, NULL, '2022-01-28 18:13:30', '2022-07-04 21:22:45', NULL), (26, 3, 4, 'MAIZ MOLIDO', '01202228370132', NULL, NULL, 190.00, 174.00, NULL, 0.00, 2, NULL, NULL, NULL, NULL, '2022-01-28 18:37:32', '2022-07-04 20:58:57', NULL), (27, 3, 2, 'ALPISTE', '01202228380148', '

ALIMENTO PARA PAJARITOS

', NULL, 850.00, 600.00, NULL, 0.00, 1, NULL, NULL, NULL, NULL, '2022-01-28 18:38:48', '2022-05-02 19:03:26', NULL), (28, 3, 4, 'NUTRAMIX FASE 1', '01202228400114', 'CONCENTRADO DE PONEDORA FASE 1', NULL, 210.00, 201.00, NULL, 0.00, 5, NULL, NULL, NULL, NULL, '2022-01-28 18:40:14', '2022-01-28 18:40:14', NULL), (29, 1, 2, 'ALPISTE LIBRAS', '01202228480118', '

ALPISTE POR LIBRA

', NULL, 10.00, 8.50, NULL, 0.00, 5, NULL, NULL, NULL, NULL, '2022-01-28 18:48:18', '2022-05-02 19:05:54', NULL), (171, 1, 14, 'bovinovet', '07202205410119', NULL, NULL, 65.00, 37.00, NULL, 22.00, 3, NULL, NULL, NULL, NULL, '2022-07-05 17:41:19', '2022-07-05 17:41:19', NULL), (30, 1, 8, 'PACAS HENO', '01202228590306', '

PACAS DE HENO CABALLOS O VACAS

', NULL, 25.00, 19.00, NULL, 0.00, 10, NULL, NULL, NULL, NULL, '2022-01-28 20:59:06', '2022-07-04 21:08:24', NULL), (31, 1, 9, 'VITAFAST 5ml', '03202205051153', '

VITAMINA B12 ' B15 CABALLOS, POLLOS

', NULL, 35.00, 25.00, NULL, 9.00, 5, NULL, NULL, NULL, NULL, '2022-03-05 16:05:53', '2022-03-21 16:23:44', NULL), (32, 1, 9, 'RUMENN VET', '03202205071130', '

ESTIMULATE DE FUNCIONES DEL RUMEN

', NULL, 15.00, 7.00, NULL, 45.00, 5, NULL, NULL, NULL, NULL, '2022-03-05 16:07:30', '2022-07-04 21:22:11', NULL), (33, 1, 10, 'LABIVIT HIERRO 50ML', '03202205081155', '

DEFICIENCIA DE HIERRO

', NULL, 45.00, 30.00, NULL, 4.00, 2, NULL, NULL, NULL, NULL, '2022-03-05 16:08:55', '2022-07-04 20:50:16', NULL), (34, 1, 10, 'LABIVIT HIERRO 10ml', '03202205091150', '

DEFICIENCIA DE HIERRO

', NULL, 25.00, 15.00, NULL, 10.00, 3, NULL, NULL, NULL, NULL, '2022-03-05 16:09:50', '2022-07-04 20:49:33', NULL), (35, 1, 10, 'LABIMECTIN 1% L.A. 100ml', '03202205431158', '

TRATAMIENTO PARA PARASITOS EXTERNOS

', NULL, 95.00, 50.00, NULL, 1.00, 1, NULL, NULL, NULL, NULL, '2022-03-05 16:43:58', '2022-07-04 20:43:17', NULL), (36, 1, 10, 'LABIMECTIN 1% L.A. 2ml', '03202205451119', '

CONTROL DE PARACITOS INTERNOS / EXTERNOS

', NULL, 15.00, 7.00, NULL, 15.00, 5, NULL, NULL, NULL, NULL, '2022-03-05 16:45:19', '2022-07-04 20:45:51', NULL), (37, 1, 10, 'LABIZOL 15% CO 100ml', '03202205461146', '

DESPARASITANTE DE AMPLIO ESPECTRO

', NULL, 38.00, 25.00, NULL, 2.00, 2, NULL, NULL, NULL, NULL, '2022-03-05 16:46:46', '2022-07-04 20:52:44', NULL), (38, 1, 10, 'LABIZOL 10% CO 100ml', '03202205471159', '

DESPARASITANTE DE AMPLIO ESPECTRO

', NULL, 35.00, 25.00, NULL, 0.00, 2, NULL, NULL, NULL, NULL, '2022-03-05 16:47:59', '2022-07-04 20:52:01', NULL), (39, 1, 10, 'LABIFEN 10% 100ml', '03202205491147', '

DESPARASITANTE DE ALTO ESPECTRO

', NULL, 38.00, 25.00, NULL, 2.00, 2, NULL, NULL, NULL, NULL, '2022-03-05 16:49:47', '2022-07-04 20:41:43', NULL), (40, 1, 10, 'LAVIBIT AD3E COMPLEJO B 10ml', '03202205501149', '

VITAMINAS CON COMPLEJO B

', NULL, 25.00, 15.00, NULL, 11.00, 1, NULL, NULL, NULL, NULL, '2022-03-05 16:50:49', '2022-07-04 20:57:07', NULL), (41, 1, 10, 'LAVIBIT AD3E COMPLEJO B 50ml', '03202205521141', '

VITAMINAS Y COMPLEJO B

', NULL, 55.00, 40.00, NULL, 5.00, 2, NULL, NULL, NULL, NULL, '2022-03-05 16:52:41', '2022-07-04 20:58:22', NULL), (42, 1, 10, 'DIPIRON 500 30ml', '03202205531150', '

ANALGESICO ANTI INFAMATORIO

', NULL, 40.00, 30.00, NULL, 1.00, 1, NULL, NULL, NULL, NULL, '2022-03-05 16:53:50', '2022-07-07 13:44:43', NULL), (43, 1, 11, 'PYROGAN 25ml', '03202205551134', 'PIROPLASMICIDA Y ANTIPIRETICO INYECTABLE', NULL, 40.00, 27.00, NULL, 2.00, 1, NULL, NULL, NULL, NULL, '2022-03-05 16:55:34', '2022-03-05 16:55:34', NULL), (44, 1, 11, 'ATROSULF 20ML', '03202205571138', '

ANTIDIAREICO IYECTABLE

', NULL, 40.00, 30.00, NULL, 6.00, 4, NULL, NULL, NULL, NULL, '2022-03-05 16:57:38', '2022-07-04 19:07:19', NULL), (45, 1, 11, 'PYROGAN 100ml', '03202205001213', '

PIROPLASMICIDA Y ANTIPIRETICO INYECTABLE

', NULL, 85.00, 65.00, NULL, 1.00, 1, NULL, NULL, NULL, NULL, '2022-03-05 17:00:13', '2022-07-04 21:19:40', NULL), (46, 1, 11, 'ATROSULF 100ml', '03202205021241', '

ANTIDIAREICO IYECTABLE

', NULL, 90.00, 70.00, NULL, 10.00, 3, NULL, NULL, NULL, NULL, '2022-03-05 17:02:41', '2022-07-04 19:06:35', NULL), (47, 1, 11, 'OXITETRACICLINA PLUS 100ml', '03202205041246', '

ANTIBIOTICO, ANTIINFLAMATORIO, ANTIPIRETICO, ANAGESICO

', NULL, 70.00, 50.00, NULL, 0.00, 2, NULL, NULL, NULL, NULL, '2022-03-05 17:04:46', '2022-07-07 21:22:02', NULL), (48, 1, 11, 'OXITETRACILCINA 200LA 100mL', '03202205051257', '

ANTIBIOTICO DE ACCION PROLONGADA DE AMPLIO ESPECTRO

', NULL, 90.00, 70.00, NULL, 0.00, 2, NULL, NULL, NULL, NULL, '2022-03-05 17:05:57', '2022-07-04 21:07:51', NULL), (49, 1, 11, 'VETSULFRIM 15ml', '03202205071210', '

ANTIBACTERIANO

', NULL, 35.00, 25.00, NULL, 5.00, 3, NULL, NULL, NULL, NULL, '2022-03-05 17:07:10', '2022-07-04 21:33:42', NULL), (50, 1, 11, 'VERRUGAN 20ml', '03202205081203', '

CONTROL VERRUGAS Y PAPILOMAS

', NULL, 60.00, 40.00, NULL, 1.00, 1, NULL, NULL, NULL, NULL, '2022-03-05 17:08:03', '2022-07-04 21:32:30', NULL), (51, 1, 11, 'VITAMINA V12 50,00 50ML', '03202205091214', '

VITAMINA V12

', NULL, 35.00, 20.00, NULL, 4.00, 1, NULL, NULL, NULL, NULL, '2022-03-05 17:09:14', '2022-07-04 21:44:51', NULL), (52, 1, 7, 'NEOMIN PET 100ML', '03202221481106', '

ANTI DIARREICO

', NULL, 45.00, 32.00, NULL, 5.00, 2, NULL, NULL, NULL, NULL, '2022-03-21 15:48:06', '2022-07-04 21:04:42', NULL), (53, 1, 12, 'KIROSTOP-D 30ml', '03202221511127', '

Suspencion oral, Desparasitante

', NULL, 45.00, 32.00, NULL, 13.00, 2, NULL, NULL, NULL, NULL, '2022-03-21 15:51:27', '2022-07-04 20:40:35', NULL), (54, 1, 10, 'IVOMEC F 50ml', '03202221561153', '

DESPARASITANTE

', NULL, 250.00, 200.00, NULL, 0.00, 1, NULL, NULL, NULL, NULL, '2022-03-21 15:56:53', '2022-07-04 20:33:36', NULL), (55, 1, 7, 'ALBENDAZOL 10% 100ml', '03202221581119', '

DESPARASITANTE

', NULL, 35.00, 25.00, NULL, 0.00, 1, NULL, NULL, NULL, NULL, '2022-03-21 15:58:19', '2022-05-02 18:55:22', NULL), (56, 1, 12, 'IVERMECTINA 1% 20ml', '03202221591137', '

DESPARASITANTE INYTECTADO

', NULL, 35.00, 25.00, NULL, 2.00, 5, NULL, NULL, NULL, NULL, '2022-03-21 15:59:37', '2022-07-07 19:08:03', NULL), (57, 1, 12, 'KIRON KIR-ANTHEL', '03202221011254', '

DESPARASITANTE

', NULL, 20.00, 3.00, NULL, 54.00, 1, NULL, NULL, NULL, NULL, '2022-03-21 16:01:54', '2022-07-09 13:19:46', NULL), (58, 1, 8, 'GANADOR D DORAMECTINA 1% 50ml', '03202221061250', '

DESPARASITANTE

', NULL, 120.00, 84.00, NULL, 1.00, NULL, NULL, NULL, NULL, NULL, '2022-03-21 16:06:50', '2022-07-04 20:14:59', NULL), (59, 1, 12, 'GANADOR E 1% 50ml', '03202221071255', '

DESPARASITANTE INYECTADO

', NULL, 150.00, 120.00, NULL, 2.00, 1, NULL, NULL, NULL, NULL, '2022-03-21 16:07:55', '2022-03-21 16:20:05', NULL), (60, 1, 7, 'CORRALON 20g', '03202221091231', '

DESPARACITANTE GRANULADO

', NULL, 18.00, 10.00, NULL, 12.00, 5, NULL, NULL, NULL, NULL, '2022-03-21 16:09:31', '2022-07-04 19:26:23', NULL), (61, 1, 7, 'CORRALITO VITAMINADO 6g', '03202221101245', '

DESPARASITANTE ALBENDAZOLE AL 6%

', NULL, 10.00, 5.00, NULL, 21.00, NULL, NULL, NULL, NULL, NULL, '2022-03-21 16:10:45', '2022-07-09 14:25:12', NULL), (62, 1, 12, 'OVID CID 20g', '03202221121238', '

DESPARASITANTE PARA CABALLO EN PASTA

', NULL, 90.00, 63.00, NULL, 4.00, 2, NULL, NULL, NULL, NULL, '2022-03-21 16:12:38', '2022-07-04 21:05:42', NULL), (63, 1, 12, 'UNIDEXIN PASTA ORAL', '03202221131258', '

DESPARASITANTE ORAL PARA CABALLOS

', NULL, 100.00, 80.00, NULL, 0.00, 1, NULL, NULL, NULL, NULL, '2022-03-21 16:13:58', '2022-07-04 21:31:43', NULL), (64, 1, 7, 'IVERHORSE 1.85%', '03202221221230', '

GEL ORAL DE 6.42g

', NULL, 120.00, 100.00, NULL, 0.00, 1, NULL, NULL, NULL, NULL, '2022-03-21 16:22:30', '2022-07-04 20:26:24', NULL), (65, 1, 7, 'VITAFAST 10ml', '03202221251203', '

VITAMINA B12 Y 15

', NULL, 45.00, 31.50, NULL, 0.00, 2, NULL, NULL, NULL, NULL, '2022-03-21 16:25:03', '2022-07-04 21:38:49', NULL), (66, 1, 12, 'ERITROVET 30g', '03202221501237', '

ANTIBIOTICO OTRAL

', NULL, 25.00, 14.00, NULL, 9.00, 2, NULL, NULL, NULL, NULL, '2022-03-21 16:50:37', '2022-07-04 19:53:50', NULL), (67, 1, 7, 'CALCITON 500ml', '03202221060112', '

VITAMINAS

', NULL, 90.00, 63.00, NULL, 1.00, 1, NULL, NULL, NULL, NULL, '2022-03-21 17:06:12', '2022-07-04 19:17:44', NULL), (68, 1, 7, 'CALCITON 250ml', '03202221100129', '

VITAMINAS

', NULL, 65.00, 45.50, NULL, 0.00, 1, NULL, NULL, NULL, NULL, '2022-03-21 17:10:29', '2022-05-02 19:41:36', NULL), (69, 1, 7, 'PARTO 20 REFORZADO', '03202221130110', '

OXITOCICO INYECTABLE

', NULL, 25.00, 17.50, NULL, 12.00, 5, NULL, NULL, NULL, NULL, '2022-03-21 17:13:10', '2022-07-04 21:09:40', NULL), (70, 1, 12, 'ENROX 25g', '03202221210144', '

ENROFLOXASINA

', NULL, 2.50, 1.40, NULL, 70.00, NULL, NULL, NULL, NULL, NULL, '2022-03-21 17:21:44', '2022-07-09 15:28:16', NULL), (71, 1, 7, 'DISPOCICLINA 100gr', '03202221270132', '

ANTIBIOTICO

', NULL, 30.00, 19.50, NULL, 0.00, 1, NULL, NULL, NULL, NULL, '2022-03-21 17:27:32', '2022-07-04 19:43:08', NULL), (72, 1, 12, 'SOLUDEX', '03202221290123', 'ATIINFLAMATORIO', NULL, 25.00, 17.50, NULL, 1.00, 1, NULL, NULL, NULL, NULL, '2022-03-21 17:29:23', '2022-03-21 17:29:23', NULL), (73, 1, 11, 'ADEVET', '03202221310107', '

SUPLEMENTO CON VITAMINA A, D,E

', NULL, 150.00, 105.00, NULL, 0.00, 1, NULL, NULL, NULL, NULL, '2022-03-21 17:31:07', '2022-07-04 19:00:15', NULL), (74, 1, 7, 'FERVET B 100mL', '03202221330100', '

HIERRO

', NULL, 110.00, 77.00, NULL, 3.00, NULL, NULL, NULL, NULL, NULL, '2022-03-21 17:33:00', '2022-07-04 19:57:05', NULL), (75, 1, 7, 'ENROXI PLUS 25ml', '03202221330129', '

PARA TRATAMIENTO DE ENFERMEDADES RESPIRATORIAS

', NULL, 22.00, 15.40, NULL, 0.00, NULL, NULL, NULL, NULL, NULL, '2022-03-21 17:33:29', '2022-07-04 19:49:14', NULL), (76, 1, 7, 'ENROXI PLUS 15ml', '03202221340125', '

AVES

', NULL, 15.00, 10.00, NULL, 4.00, 2, NULL, NULL, NULL, NULL, '2022-03-21 17:34:25', '2022-07-04 19:48:21', NULL), (77, 1, 7, 'TIDOSINA 10ml', '03202221340146', '

MEDICAMENTO

', NULL, 25.00, 15.40, NULL, 5.00, 0, NULL, NULL, NULL, NULL, '2022-03-21 17:34:46', '2022-07-04 21:28:35', NULL), (78, 1, 7, 'CURA AVES 10ml', '03202221350145', NULL, NULL, 22.00, 15.40, NULL, 0.00, 1, NULL, NULL, NULL, NULL, '2022-03-21 17:35:45', '2022-07-04 19:34:10', NULL), (79, 1, 7, 'ENRODEL PLUS', '03202221360106', '

ANTIBACTERIANO

', NULL, 45.00, 31.50, NULL, 0.00, 1, NULL, NULL, NULL, NULL, '2022-03-21 17:36:06', '2022-07-04 19:45:56', NULL), (80, 1, 7, 'BRONCO PLUS 20% VITAMINDO', '03202221360138', '

ANTIBIOTICO DE ALTO ESPECTRO

', NULL, 45.00, 27.27, NULL, 33.00, 2, NULL, NULL, NULL, NULL, '2022-03-21 17:36:38', '2022-07-07 15:15:38', NULL), (81, 1, 7, 'CRONIXIN 10ml', '03202221370120', '

ANTIBIOTICO DE ALTO ESPECTRO

', NULL, 22.00, 14.40, NULL, 8.00, 2, NULL, NULL, NULL, NULL, '2022-03-21 17:37:20', '2022-07-04 19:29:58', NULL), (82, 1, 7, 'MAXIFORT 100ml', '03202221370140', '

VITAMINAS

', NULL, 30.00, 21.00, NULL, 4.00, 2, NULL, NULL, NULL, NULL, '2022-03-21 17:37:40', '2022-07-04 20:59:50', NULL), (83, 1, 7, 'Cura Aves de 15 gr', '03202221450140', '

Antibiotico auxiliar en viruela, soco, moco e infecciones respiratorias en aves y cerdos

', NULL, 20.00, 13.00, NULL, 2.00, 1, NULL, NULL, NULL, NULL, '2022-03-21 17:45:40', '2022-07-04 19:38:55', NULL), (84, 1, 7, 'Bronco Plus oral 20% Vitaminado 10 ml', '03202221480119', '

Antibiotico de Amplio espectro para aves y porcinos

', NULL, 30.00, 10.50, NULL, 11.00, 3, NULL, NULL, NULL, NULL, '2022-03-21 17:48:19', '2022-07-04 19:14:34', NULL), (85, 1, 11, 'Agripen 2.4 de 7ml', '03202222101040', '

Penicilina + estreptomicina, es antinflamatorio, antipirético, antibiótico

', NULL, 38.00, 25.00, NULL, 11.00, 1, NULL, NULL, NULL, NULL, '2022-03-22 14:10:40', '2022-07-04 19:02:17', NULL), (86, 1, 11, 'Agripen Forte 6,000,000 de 15ml', '03202222121050', '

Antibiótico, antinflamatorio, antipirético, analgésico, inyectable

', NULL, 60.00, 45.00, NULL, 8.00, 2, NULL, NULL, NULL, NULL, '2022-03-22 14:12:50', '2022-07-04 19:03:29', NULL), (87, 1, 11, 'Dexasol de 100 ml', '03202222281046', '

Dexamentasona, sirve para tratar inflamación e infecciones agudas y crónicas

', NULL, 60.00, 42.00, NULL, 1.00, 1, NULL, NULL, NULL, NULL, '2022-03-22 14:28:46', '2022-07-04 19:40:43', NULL), (88, 1, 12, 'Vitapio de 10gr.', '03202222381050', '

Multivitaminico para pollo

', NULL, 20.00, 14.00, NULL, 11.00, 3, NULL, NULL, NULL, NULL, '2022-03-22 14:38:50', '2022-07-04 21:46:30', NULL), (89, 1, 10, 'Labivitasan de 50ml', '03202222091131', '

Reconstituyente, Energizante y Estimulante

', NULL, 50.00, 35.00, NULL, 0.00, 1, NULL, NULL, NULL, NULL, '2022-03-22 15:09:31', '2022-07-04 20:51:16', NULL), (90, 1, 10, 'Floxin 200 BR de 15ml', '03202222131115', '

Antimicrobiano de Amplio Espectro y Fludificante, solucion Orale

', NULL, 30.00, 21.00, NULL, 15.00, 3, NULL, NULL, NULL, NULL, '2022-03-22 15:13:15', '2022-07-04 20:02:09', NULL), (91, 1, 7, 'Promofull \"L\"', '03202222191130', '

Vitaminas + Aminoacidos, Promotor de Alto rendimiento

', NULL, 45.00, 30.00, NULL, 0.00, 1, NULL, NULL, NULL, NULL, '2022-03-22 15:19:30', '2022-07-04 21:18:43', NULL), (92, 1, 11, 'Vitamina B-12, 50.000 de 10ml', '03202222211118', '

Vitamínico Solución Inyectable

', NULL, 30.00, 20.00, NULL, 0.00, 1, NULL, NULL, NULL, NULL, '2022-03-22 15:21:18', '2022-07-04 21:39:50', NULL), (93, 1, 12, 'Flativet de 120 ml', '03202222071207', '

-Antiespumante -Antiflatulento Suspensión oral

', NULL, 90.00, 63.00, NULL, 6.00, 3, NULL, NULL, NULL, NULL, '2022-03-22 16:07:07', '2022-07-04 20:00:08', NULL), (94, 1, 12, 'Meloxic de 100gr.', '03202222091229', '

Pomada: -Analgésico -Antiflogístico -Antiinflamatorio -Rubefaciente

', NULL, 50.00, 35.00, NULL, 3.00, 2, NULL, NULL, NULL, NULL, '2022-03-22 16:09:29', '2022-07-04 21:00:59', NULL), (95, 1, 12, 'PezosaN-N de 30gr.', '03202222221208', '

Ungüento N.F. para el tratamiento de escoriaciones de los pezones y como coadyuvante en su cicatrización

', NULL, 40.00, 28.00, NULL, 2.00, 1, NULL, NULL, NULL, NULL, '2022-03-22 16:22:08', '2022-07-04 21:10:19', NULL), (96, 1, 7, 'Frota Ubre de 4 oz.', '03202222251209', '

Pomada revulsiva, indicada para friccionar áreas inflamadas

', NULL, 27.00, 18.90, NULL, 0.00, 2, NULL, NULL, NULL, NULL, '2022-03-22 16:25:09', '2022-07-04 20:13:32', NULL), (97, 1, 7, 'Frota Ubre de 2 oz.', '03202222271223', '

Pomada revulsiva, para el ubre de las vacas

', NULL, 20.00, 14.00, NULL, 12.00, 2, NULL, NULL, NULL, NULL, '2022-03-22 16:27:23', '2022-07-04 20:08:51', NULL), (98, 1, 7, 'Cipergan de 20ml', '03202222311255', '

Mosquicida y Garrapatacida

', NULL, 35.00, 12.00, NULL, 9.00, 3, NULL, NULL, NULL, NULL, '2022-03-22 16:31:55', '2022-07-09 13:19:46', NULL), (99, 1, 7, 'Cipergan de 100ml', '03202222321257', '

Mosquicida y Garrapatacida

', NULL, 65.00, 45.50, NULL, 3.00, 2, NULL, NULL, NULL, NULL, '2022-03-22 16:32:57', '2022-07-04 19:18:56', NULL), (100, 1, 12, 'Singap de 20ml', '03202222361251', '

Garrapatacida Controla la garrapata de los bovinos

', NULL, 45.00, 31.50, NULL, 8.00, 2, NULL, NULL, NULL, NULL, '2022-03-22 16:36:51', '2022-07-04 21:23:46', NULL), (101, 1, 12, 'Tino de 20ml', '03202222371258', '

Insecticida y Garrapaticida con cipermectrina

', NULL, 40.00, 28.00, NULL, 2.00, 2, NULL, NULL, NULL, NULL, '2022-03-22 16:37:58', '2022-07-04 21:29:22', NULL), (102, 1, 12, 'Metrivet de 12 Ovulos', '03202222401227', '

Oxitetraciclina Ovulo Uterino espumante

', NULL, 70.00, 49.00, NULL, 3.00, 3, NULL, NULL, NULL, NULL, '2022-03-22 16:40:27', '2022-07-04 21:02:15', NULL), (103, 1, 12, 'Coccigan de 25 gr.', '03202222421239', '

Para el Control y Tratamiento de la cocciodiosis -Amprolio al 20%

', NULL, 24.00, 16.80, NULL, 6.00, 2, NULL, NULL, NULL, NULL, '2022-03-22 16:42:39', '2022-07-04 19:22:21', NULL), (104, 1, 7, 'Super-Creolina 1/8', '03202222441206', '

Desinfección de Galeras

', NULL, 15.00, 10.50, NULL, 13.00, 5, NULL, NULL, NULL, NULL, '2022-03-22 16:44:06', '2022-07-04 21:25:43', NULL), (105, 1, 7, 'Super-Creolina 500 ml', '03202222451229', '

Desinfección de Galeras

', NULL, 35.00, 24.50, NULL, 3.00, 2, NULL, NULL, NULL, NULL, '2022-03-22 16:45:29', '2022-07-04 21:26:41', NULL), (106, 1, 7, 'Folidolio 48 EC de 100 ml', '03202222471231', '

Insecticida para plantas

', NULL, 22.00, 15.40, NULL, 0.00, 2, NULL, NULL, NULL, NULL, '2022-03-22 16:47:31', '2022-07-04 20:06:22', NULL), (107, 1, 7, 'Cipermetrina 25EC', '03202222481244', '

Insecticida piretroide para plantas

', NULL, 22.00, 15.40, NULL, 0.00, 3, NULL, NULL, NULL, NULL, '2022-03-22 16:48:44', '2022-07-04 19:20:23', NULL), (108, 1, 7, 'karate zeon 5CS', '03202222501243', '

Insecticida Piretroide, para plantas Formula para cogoyero en maiz

', NULL, 40.00, 28.00, NULL, 0.00, 1, NULL, NULL, NULL, NULL, '2022-03-22 16:50:43', '2022-07-04 20:38:02', NULL), (109, 1, 10, 'LABIBOL 50 250 ML', '07202204530515', 'anabólico boldenona', 'Ganador de peso', 495.00, 321.00, NULL, 4.00, 2, NULL, NULL, NULL, NULL, '2022-07-04 21:53:15', '2022-07-04 21:53:15', NULL), (110, 1, 11, 'Vitamina B 12 50,000 100ml', '07202204550533', 'Vitaminas', NULL, 75.00, 48.75, NULL, 5.00, NULL, NULL, NULL, NULL, NULL, '2022-07-04 21:55:33', '2022-07-04 21:55:33', NULL), (111, 1, 10, 'Labimectin 1%l.a. 50 ml', '07202204570551', 'Ivermectina al 1%', 'Desparasitante interno y externo', 47.00, 30.55, NULL, 5.00, NULL, NULL, NULL, NULL, NULL, '2022-07-04 21:57:51', '2022-07-04 21:57:51', NULL), (112, 1, 10, 'Labimectin 1% 30 ml', '07202204590518', 'ivermectina al 1%', 'Desparasitante interno y externo', 37.00, 24.05, NULL, 4.00, NULL, NULL, NULL, NULL, NULL, '2022-07-04 21:59:18', '2022-07-07 13:11:18', NULL), (113, 1, 11, 'ANABOLEX 50ML', '07202204030643', 'ANABOLICO', 'GANADOR DE PESO', 150.00, 97.50, NULL, 2.00, NULL, NULL, NULL, NULL, NULL, '2022-07-04 22:03:43', '2022-07-04 22:03:43', NULL), (114, 1, 11, 'BRONQUIVET 15ML SUSPENSION INYECTABLE', '07202204090601', 'ANTIBIOTICO, ANTHISTAMINICO, MUCOLITICO, EXPECTORANTE, ANALGESICO, ANTIINFLAMATORIO', NULL, 68.00, 44.20, NULL, 5.00, NULL, NULL, NULL, NULL, NULL, '2022-07-04 22:09:01', '2022-07-04 22:09:01', NULL), (115, 1, 11, 'FOSFOSEL B-12 20 ML INYECTADO', '07202204110624', 'ESTIMULANTE Y RESCONSTITUYENTE', NULL, 30.00, 19.50, NULL, 8.00, NULL, NULL, NULL, NULL, NULL, '2022-07-04 22:11:24', '2022-07-09 15:28:16', NULL), (116, 1, 11, 'AGRIPEN PLUSS 12 INYECTADO', '07202204130643', 'ANTIBIOTICO Y ANTIINFLAMATORIO PARA BOVINOS, EQUINOS Y PORCINOS', NULL, 73.00, 47.45, NULL, 11.00, NULL, NULL, NULL, NULL, NULL, '2022-07-04 22:13:43', '2022-07-07 21:22:02', NULL), (117, 1, 10, 'FLOXIN 100 100ML INYECTADO', '07202204150656', 'ENROFLOXACINA, DE AMPLIO ASPECTRO , ANTIMICROBIANO', NULL, 150.00, 97.50, NULL, 2.00, NULL, NULL, NULL, NULL, NULL, '2022-07-04 22:15:56', '2022-07-04 22:15:56', NULL), (118, 1, 10, 'FLOXIN 100 50ML INYECTADO', '07202204170642', 'ENROFLAXACINA, ANTIMICROBIANO DE AMPLIO ASPECTRO', NULL, 75.00, 48.75, NULL, 4.00, NULL, NULL, NULL, NULL, NULL, '2022-07-04 22:17:42', '2022-07-04 22:17:42', NULL), (119, 1, 7, 'BRONCOBION 10 ML', '07202204200637', 'ANTIBIOTICO ROJO', NULL, 30.00, 19.50, NULL, 14.00, NULL, NULL, NULL, NULL, NULL, '2022-07-04 22:20:37', '2022-07-04 22:20:37', NULL), (120, 1, 7, 'BRONCOBION 30 ML', '07202204210634', 'ANTIBIOTICO ROJO', NULL, 45.00, 29.25, NULL, 10.00, NULL, NULL, NULL, NULL, NULL, '2022-07-04 22:21:34', '2022-07-04 22:21:34', NULL), (121, 1, 10, 'FLOXIN 100 15ML', '07202204220640', 'ENROFLOXACINA', NULL, 20.00, 13.00, NULL, 5.00, NULL, NULL, NULL, NULL, NULL, '2022-07-04 22:22:40', '2022-07-04 22:22:40', NULL), (122, 1, 7, 'BRONCO PLUS ORAL 30 ML', '07202204240635', 'ANTIBIOTICO', NULL, 45.00, 29.25, NULL, 3.00, 2, NULL, NULL, NULL, NULL, '2022-07-04 22:24:35', '2022-07-04 22:24:35', NULL), (123, 1, 10, 'FLOXIN 200 BR 100ML', '07202204260625', 'ENROFLOXACINA', NULL, 85.00, 55.25, NULL, 7.00, 2, NULL, NULL, NULL, NULL, '2022-07-04 22:26:25', '2022-07-04 22:26:25', NULL), (124, 1, 10, 'FLOXIN 100 GOTERO 100ML', '07202204270633', 'ENROFLOXACINA', NULL, 75.00, 48.75, NULL, 13.00, 2, NULL, NULL, NULL, NULL, '2022-07-04 22:27:33', '2022-07-04 22:27:33', NULL), (125, 1, 5, 'fLUMEG 100 ML', '07202204290649', 'ANTIINFLAMATORIO', NULL, 215.00, 139.75, NULL, 3.00, NULL, NULL, NULL, NULL, NULL, '2022-07-04 22:29:49', '2022-07-04 22:29:49', NULL), (126, 1, 10, 'LABIMIN 100ML', '07202204310606', 'SUPLEMENTO MINERALES', NULL, 60.00, 39.00, NULL, 1.00, NULL, NULL, NULL, NULL, NULL, '2022-07-04 22:31:06', '2022-07-04 22:31:06', NULL), (127, 1, 10, 'LABICAINA 2% 50ML', '07202204320627', 'LIDOCAINA', NULL, 60.00, 39.00, NULL, 1.00, NULL, NULL, NULL, NULL, NULL, '2022-07-04 22:32:27', '2022-07-04 22:32:27', NULL), (128, 1, 10, 'LABIPHOS B 12 100ML', '07202204340623', 'ENERGIZANTE, RECONSTITUYENTE Y ESTIMULANTE', NULL, 80.00, 52.00, NULL, 0.00, NULL, NULL, NULL, NULL, NULL, '2022-07-04 22:34:23', '2022-07-04 22:34:23', NULL), (129, 1, 10, 'LABIPHOS B12 50ML', '07202204350629', 'ENERGIZANTE, RECONSTITUYENTE Y ESTIMULANTE', NULL, 50.00, 32.50, NULL, 2.00, NULL, NULL, NULL, NULL, NULL, '2022-07-04 22:35:29', '2022-07-04 22:35:29', NULL), (130, 1, 10, 'LABIVIT AD3E CON COMPLEJO B 30ML', '07202204360651', 'SUMPLEMENTO VITAMINICO', NULL, 45.00, 29.25, NULL, 1.00, NULL, NULL, NULL, NULL, NULL, '2022-07-04 22:36:51', '2022-07-04 22:36:51', NULL), (131, 1, 5, 'DEFENDER 10ML', '07202204380639', 'TRIMETOPRIM + SULFAMETOXAZOL', NULL, 30.00, 19.50, NULL, 2.00, NULL, NULL, NULL, NULL, NULL, '2022-07-04 22:38:39', '2022-07-04 22:38:39', NULL), (132, 1, 5, 'TIDOSINA 15 G', '07202204390659', 'POLVO SALUDABLE ORAL', NULL, 25.00, 16.25, NULL, 3.00, NULL, NULL, NULL, NULL, NULL, '2022-07-04 22:39:59', '2022-07-04 22:39:59', NULL), (133, 1, 7, 'MAKIVET PASTILLA ROSADA', '07202204410623', 'PASTILLA ROSADA', NULL, 2.00, 1.00, NULL, 63.00, NULL, NULL, NULL, NULL, NULL, '2022-07-04 22:41:23', '2022-07-08 14:39:42', NULL), (134, 1, 7, 'ERITROKINGS PASTILLA', '07202204420629', 'ANTIBIOTICO', NULL, 2.00, 1.00, NULL, 80.00, NULL, NULL, NULL, NULL, NULL, '2022-07-04 22:42:29', '2022-07-08 14:39:42', NULL), (135, 1, 7, 'SOCOFIN BD 10G', '07202204430620', 'ANTIBIOTICO PARA SOCK Y EL MOCO', NULL, 25.00, 12.00, NULL, 10.00, NULL, NULL, NULL, NULL, NULL, '2022-07-04 22:43:20', '2022-07-04 22:43:20', NULL), (136, 1, 7, 'KIRO DERMAL JABON', '07202204450631', '

JABON DERMATOLOGICO

', NULL, 55.00, 30.00, NULL, 3.00, NULL, NULL, NULL, NULL, NULL, '2022-07-04 22:45:31', '2022-07-04 23:34:42', NULL), (137, 1, 12, 'JABON POMPAS', '07202204540601', 'ANTIPULGAS', NULL, 20.00, 10.00, NULL, 8.00, NULL, NULL, NULL, NULL, NULL, '2022-07-04 22:54:01', '2022-07-04 22:54:01', NULL), (138, 1, 7, 'OXIVIOL PLUS', '07202204550629', 'CICATRIZANTE', NULL, 45.00, 29.25, NULL, 6.00, NULL, NULL, NULL, NULL, NULL, '2022-07-04 22:55:29', '2022-07-04 22:55:29', NULL), (139, 1, 7, 'OXIVIL PLUS PEQUEÑO', '07202204560617', 'CICATRIZANTE', NULL, 15.00, 6.00, NULL, 20.00, NULL, NULL, NULL, NULL, NULL, '2022-07-04 22:56:17', '2022-07-04 22:56:17', NULL), (140, 1, 7, 'SHAMPOO SHARPEI', '07202204570609', 'ANTIPULGAS', NULL, 35.00, 22.75, NULL, 3.00, NULL, NULL, NULL, NULL, NULL, '2022-07-04 22:57:09', '2022-07-04 22:57:09', NULL), (141, 1, 7, 'SHAMPOO DR. PETS', '07202204580611', 'ANTIPULGAS', NULL, 28.00, 15.00, NULL, 1.00, NULL, NULL, NULL, NULL, NULL, '2022-07-04 22:58:11', '2022-07-04 22:58:11', NULL), (142, 1, 7, 'ACEITE MINERAL 500ML', '07202204590615', 'ACEITE MINERAL', NULL, 80.00, 50.00, NULL, 2.00, NULL, NULL, NULL, NULL, NULL, '2022-07-04 22:59:15', '2022-07-04 22:59:15', NULL), (143, 1, 11, 'ECTOGAN', '07202204010715', 'PARA LA MOSCA', NULL, 90.00, 58.50, NULL, 2.00, NULL, NULL, NULL, NULL, NULL, '2022-07-04 23:01:15', '2022-07-07 19:28:32', NULL), (144, 1, 7, 'CERDI VET PLUS', '07202204020711', '

DESPARASITANTE

', NULL, 15.00, 9.75, NULL, 30.00, NULL, NULL, NULL, NULL, NULL, '2022-07-04 23:02:11', '2022-07-04 23:02:38', NULL), (145, 1, 7, 'PANACUR DESPARASITANTE', '07202204030759', 'DESPARASITANTE', NULL, 30.00, 19.50, NULL, 42.00, NULL, NULL, NULL, NULL, NULL, '2022-07-04 23:03:59', '2022-07-08 13:40:33', NULL), (146, 1, 12, 'TINO', '07202204050734', 'GARRAPASTISIDA', NULL, 40.00, 26.00, NULL, 2.00, NULL, NULL, NULL, NULL, NULL, '2022-07-04 23:05:34', '2022-07-04 23:05:34', NULL), (147, 1, 7, 'MATAPIOJILLO 200G', '07202204070726', '

MATA PIOJILLO

', NULL, 20.00, 6.91, NULL, 35.00, NULL, NULL, NULL, NULL, NULL, '2022-07-04 23:07:26', '2022-07-07 15:16:48', NULL), (148, 1, 7, 'MATAPIOJILLO BOLSA 400G', '07202204080722', 'MATA PIOJILLO', NULL, 22.00, 14.00, NULL, 3.00, NULL, NULL, NULL, NULL, NULL, '2022-07-04 23:08:22', '2022-07-04 23:08:22', NULL), (149, 1, 7, 'MATAPIOJILLO EN BOTE 400G', '07202204090702', NULL, NULL, 25.00, 11.60, NULL, 0.00, NULL, NULL, NULL, NULL, NULL, '2022-07-04 23:09:02', '2022-07-07 19:28:32', NULL), (150, 1, 13, 'AVINTIL 20', '07202204130747', 'SANA SOCK', NULL, 20.00, 13.00, NULL, 11.00, NULL, NULL, NULL, NULL, NULL, '2022-07-04 23:13:47', '2022-07-04 23:13:47', NULL), (151, 1, 13, 'TRIMFULSA PLUS 15G', '07202204140742', 'ANTIDIARREICOS', NULL, 18.00, 11.70, NULL, 13.00, 5, NULL, NULL, NULL, NULL, '2022-07-04 23:14:42', '2022-07-04 23:14:42', NULL), (152, 1, 13, 'VITEL MLT', '07202204150740', 'ELECTROLITOS', NULL, 15.00, 9.75, NULL, 17.00, NULL, NULL, NULL, NULL, NULL, '2022-07-04 23:15:40', '2022-07-04 23:15:40', NULL), (153, 1, 13, 'VITEL 10G', '07202204160708', 'ELECTROLITOS', NULL, 15.00, 9.75, NULL, 8.00, NULL, NULL, NULL, NULL, NULL, '2022-07-04 23:16:08', '2022-07-04 23:16:08', NULL), (154, 1, 13, 'AVIZINA 15G', '07202204160755', 'DESPARASITANTE', NULL, 15.00, 9.75, NULL, 10.00, NULL, NULL, NULL, NULL, NULL, '2022-07-04 23:16:55', '2022-07-04 23:16:55', NULL), (155, 1, 13, 'AVIZINA 150G', '07202204170737', 'DESPARASITANTE', NULL, 35.00, 22.75, NULL, 2.00, NULL, NULL, NULL, NULL, NULL, '2022-07-04 23:17:37', '2022-07-04 23:17:37', NULL), (156, 1, 13, 'TRIMSULFA PLUS 100G', '07202204180729', 'ELECTROLITOS+ TRIMETROPRIN', NULL, 40.00, 26.00, NULL, 8.00, 3, NULL, NULL, NULL, NULL, '2022-07-04 23:18:29', '2022-07-08 14:42:42', NULL), (157, 1, 13, 'VITEL MLT 100G', '07202204190719', '

ELECTROLITOS

', NULL, 45.00, 34.50, NULL, 16.00, 2, NULL, NULL, NULL, NULL, '2022-07-04 23:19:19', '2022-07-09 23:02:32', NULL), (158, 1, 13, 'CORI PLUS', '07202204200719', 'PESTE, DIARREA, SOCK', NULL, 45.00, 29.25, NULL, 8.00, NULL, NULL, NULL, NULL, NULL, '2022-07-04 23:20:19', '2022-07-04 23:20:19', NULL), (159, 1, 7, 'BRONCO PLUS SOBRES 10G', '07202204220702', 'DIARREAS Y ENFERMEDADES RESPIRATORIOS', NULL, 15.00, 9.25, NULL, 11.00, NULL, NULL, NULL, NULL, NULL, '2022-07-04 23:22:02', '2022-07-04 23:22:02', NULL), (160, 1, 7, 'SOCO STOP', '07202204230707', 'SOCO', NULL, 12.00, 7.80, NULL, 11.00, 2, NULL, NULL, NULL, NULL, '2022-07-04 23:23:07', '2022-07-04 23:23:07', NULL), (161, 1, 12, 'PORCINO SOBRE 5G', '07202204240741', 'DESPARASITANTE', NULL, 15.00, 9.75, NULL, 31.00, NULL, NULL, NULL, NULL, NULL, '2022-07-04 23:24:41', '2022-07-04 23:24:41', NULL), (162, 1, 7, 'gallo forte', '07202205190819', 'vitaminas para gallos de pelea', NULL, 2.00, 70.00, NULL, 134.00, 15, NULL, NULL, NULL, NULL, '2022-07-05 12:19:19', '2022-07-05 12:19:19', NULL), (163, 1, 6, 'ascorbol pastilla', '07202205210800', 'vitaminas para gallos', NULL, 2.00, 1.00, NULL, 207.00, 15, NULL, NULL, NULL, NULL, '2022-07-05 12:21:00', '2022-07-05 12:21:00', NULL), (164, 1, 6, 'ascorbol pastilla', '07202205210801', 'vitaminas para gallos', NULL, 2.00, 1.00, NULL, 207.00, 15, NULL, NULL, NULL, NULL, '2022-07-05 12:21:01', '2022-07-05 12:21:01', NULL), (165, 1, 6, 'trifen plius', '07202205240850', NULL, NULL, 2.00, 1.00, NULL, 156.00, 15, NULL, NULL, NULL, NULL, '2022-07-05 12:24:50', '2022-07-08 14:42:42', NULL), (166, 1, 5, 'labizole 10%', '07202205251152', 'desparasitante para ganado litro', NULL, 165.00, 87.75, NULL, 1.00, 0, NULL, NULL, NULL, NULL, '2022-07-05 15:25:52', '2022-07-05 15:25:52', NULL), (167, 1, 5, 'labifen 10% litro', '07202205351154', 'desparasitante para ganado', NULL, 220.00, 143.00, NULL, 1.00, 1, NULL, NULL, NULL, NULL, '2022-07-05 15:35:54', '2022-07-05 15:35:54', NULL), (168, 1, 5, 'floxin 100 500ml', '07202205481108', 'enrofloxacina \r\nantimicrobiano de amplio aspectro', NULL, 120.00, 78.00, NULL, 1.00, 1, NULL, NULL, NULL, NULL, '2022-07-05 15:48:08', '2022-07-05 15:48:08', NULL), (169, 1, 6, 'promofull L', '07202205491123', 'promotor de gallinas en postura', NULL, 35.00, 22.75, NULL, 1.00, 1, NULL, NULL, NULL, NULL, '2022-07-05 15:49:23', '2022-07-05 15:49:23', NULL), (170, 1, 7, 'fierro', '07202205501123', 'marcador para animales', NULL, 45.00, 29.25, NULL, 1.00, 1, NULL, NULL, NULL, NULL, '2022-07-05 15:50:23', '2022-07-05 15:50:23', NULL), (172, 1, 16, 'Comedero de 12kg', '07202206151154', 'comederos tolva amarilla', NULL, 90.00, 52.00, NULL, 35.00, 5, NULL, NULL, NULL, NULL, '2022-07-06 15:15:54', '2022-07-06 15:15:54', NULL), (173, 1, 17, 'comederos de cubeta', '07202206211133', NULL, NULL, 80.00, 52.00, NULL, 3.00, 1, NULL, NULL, NULL, NULL, '2022-07-06 15:21:33', '2022-07-06 15:21:33', NULL), (174, 1, 17, 'bebederos de galon amarillo blanco', '07202206241145', NULL, NULL, 40.00, 26.00, NULL, 21.00, 5, NULL, NULL, NULL, NULL, '2022-07-06 15:24:45', '2022-07-06 15:24:45', NULL), (175, 1, 16, 'bebederos de 10litros', '07202206281120', NULL, NULL, 125.00, 85.00, NULL, 17.00, 5, NULL, NULL, NULL, NULL, '2022-07-06 15:28:20', '2022-07-06 15:28:20', NULL), (176, 1, 16, 'bebederps 10lt', '07202206331151', NULL, NULL, 90.00, 58.00, NULL, 8.00, 2, NULL, NULL, NULL, NULL, '2022-07-06 15:33:51', '2022-07-06 15:33:51', NULL), (177, 1, 16, 'Comederos largos rojos', '07202206341143', NULL, NULL, 40.00, 22.00, NULL, 5.00, 1, NULL, NULL, NULL, NULL, '2022-07-06 15:34:43', '2022-07-06 15:34:43', NULL), (178, 1, 16, 'Comederos verdes G', '07202206351133', NULL, NULL, 18.00, 9.00, NULL, 6.00, 2, NULL, NULL, NULL, NULL, '2022-07-06 15:35:33', '2022-07-06 15:35:33', NULL), (179, 1, 16, 'Comederos 10kg naranja', '07202206391106', NULL, NULL, 75.00, 47.00, NULL, 8.00, 2, NULL, NULL, NULL, NULL, '2022-07-06 15:39:06', '2022-07-06 15:39:06', NULL), (180, 1, 16, 'Comederos 5.5kg rojo', '07202206411106', NULL, NULL, 85.00, 55.00, NULL, 6.00, 2, NULL, NULL, NULL, NULL, '2022-07-06 15:41:06', '2022-07-06 15:41:06', NULL), (181, 1, 16, 'Comederos rojos 12kg', '07202206421154', NULL, NULL, 115.00, 75.00, NULL, 6.00, 2, NULL, NULL, NULL, NULL, '2022-07-06 15:42:54', '2022-07-06 15:42:54', NULL), (182, 1, 13, 'Comederos de gallo', '07202206091210', NULL, NULL, 15.00, 9.00, NULL, 13.00, 2, NULL, NULL, NULL, NULL, '2022-07-06 16:09:10', '2022-07-06 16:09:10', NULL), (183, 3, 18, 'bio nova 2', '07202207291210', 'nutrimento valanceado para cerdos de 15dias', NULL, 315.00, 297.00, NULL, 1.00, 1, NULL, NULL, NULL, NULL, '2022-07-07 16:29:10', '2022-07-07 16:29:10', NULL), (184, 1, 2, 'PRUEBA', '123123123', '

hola mundo

', NULL, 100.00, 80.00, NULL, 2.00, 0, NULL, NULL, NULL, NULL, '2022-07-09 15:14:04', '2022-07-09 15:43:49', NULL), (185, 1, 13, 'Electrolitos 100g', '07202209500613', '

electrolitos con vitaminas

', NULL, 35.00, 15.46, NULL, 16.00, 4, NULL, NULL, NULL, NULL, '2022-07-09 22:50:13', '2022-07-09 23:03:11', NULL), (186, 1, 13, 'VITEL 100G', '07202209230727', 'VITAMINAS Y ELECTROLITOS', NULL, 40.00, 27.00, NULL, 16.00, 4, NULL, NULL, NULL, NULL, '2022-07-09 23:23:27', '2022-07-09 23:23:27', NULL); -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `articulos_catalogo` -- CREATE TABLE `articulos_catalogo` ( `id` bigint(20) UNSIGNED NOT NULL, `nombre` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `descripcion` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `costo` double NOT NULL, `descuento` double NOT NULL, `imagen` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `imagen2` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `caja` -- CREATE TABLE `caja` ( `id` bigint(20) UNSIGNED NOT NULL, `valor` double NOT NULL DEFAULT 0, `descripcion` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `operacion` varchar(5) COLLATE utf8mb4_unicode_ci NOT NULL, `fecha` date NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Volcado de datos para la tabla `caja` -- INSERT INTO `caja` (`id`, `valor`, `descripcion`, `operacion`, `fecha`, `created_at`, `updated_at`) VALUES (1, 375, 'CREDITO DE MONICA AGUIRRE por: 15 PACAS DE HENO', 'd', '2022-01-31', NULL, NULL), (2, 10, '0', 'e', '2022-01-31', NULL, NULL), (3, 9, '9', 's', '2022-01-31', NULL, NULL), (4, 2146, 'CREDITO DE Dinael Rivas por: saldo anteriro de deuda', 'd', '2022-07-05', NULL, NULL), (5, 245, 'CREDITO DE Norma Rivas por: Vita postura f1', 'd', '2022-07-05', NULL, NULL), (6, 640, 'CREDITO DE Saulo rivas por: saco de exelent', 'd', '2022-07-05', NULL, NULL), (7, 480, 'CREDITO DE David (picop rojo) por: deuda de concentrado vita fin y aliengorde 2', 'd', '2022-07-05', NULL, NULL), (8, 255, 'CREDITO DE mainor rivas (nito) por: pago de renta', 'd', '2022-07-05', NULL, NULL), (9, 675, 'CREDITO DE doña leida por: vita fin 2 quintales del dia 4/7/', 'd', '2022-07-05', NULL, NULL), (10, 1262, 'CREDITO DE vicente vasquez por: 4 vita 18\r\n1 molsa \r\n1 econocriollo', 'd', '2022-07-05', NULL, NULL), (11, 545, 'CREDITO DE Rogelio GUIRRE por: pet masterdos bolsas \r\ndesparasitante y antidiarreico', 'd', '2022-07-05', NULL, NULL), (12, 545, 'CREDITO DE Rogelio GUIRRE por: pet masterdos bolsas \r\ndesparasitante y antidiarreico', 'd', '2022-07-05', NULL, NULL), (13, 240, 'CREDITO DE MONICA AGUIRRE por: flumeg y dipiron', 'd', '2022-07-05', NULL, NULL), (14, 700, 'CREDITO DE Jose Maria Aguirre por: prestamo de compra de cel', 'd', '2022-07-05', NULL, NULL), (15, 160, 'CREDITO DE abraham colocho (paca) por: econogando', 'd', '2022-07-05', NULL, NULL), (16, 1440, 'CREDITO DE Ronal mashita por: 6 vita postura', 'd', '2022-07-06', NULL, NULL), (17, 780, 'CREDITO DE byron hernandez por: 4 harina de maiz', 'd', '2022-07-06', NULL, NULL), (18, 277, 'CREDITO DE doña leida por: 1 vita inicio', 'd', '2022-07-06', NULL, NULL), (19, 279, 'CREDITO DE Misael rivas por: VITA FIN', 'd', '2022-07-06', NULL, NULL), (20, 221, 'ABONO Misael rivas por: ABONO', 'e', '2022-07-06', NULL, NULL), (21, 375, 'ABONO MONICA AGUIRRE por: CANCELO HENO', 'e', '2022-07-06', NULL, NULL), (22, 545, 'ABONO Rogelio GUIRRE por: ', 'e', '2022-07-06', NULL, NULL), (23, 240, 'CREDITO DE Rogelio GUIRRE por: VACUNA CACHORROS', 'd', '2022-07-06', NULL, NULL), (24, 398, 'CREDITO DE vicente vasquez por: 1 VITA 18\r\n1 VITA NOVILLA', 'd', '2022-07-06', NULL, NULL), (25, 315, 'CREDITO DE Carlos vasquez por: bio nova 2', 'd', '2022-07-07', NULL, NULL), (26, 1440, 'ABONO Ronal mashita por: pago de vita postura fase 1', 'e', '2022-07-07', NULL, NULL), (27, 240, 'ABONO MONICA AGUIRRE por: cancelo flumeg y dipiron', 'e', '2022-07-07', NULL, NULL), (28, 640, 'ABONO Saulo rivas por: cancelo', 'e', '2022-07-08', NULL, NULL), (29, 120, 'CREDITO DE mainor rivas (nito) por: 1 trimsulfa \r\n10 trifen plus', 'd', '2022-07-08', NULL, NULL), (30, 786, 'CREDITO DE vicente vasquez por: 3 vita 18 \r\n1 molsa', 'd', '2022-07-08', NULL, NULL), (31, 1150, 'ABONO Dinael Rivas por: abono de deuda', 'e', '2022-07-08', NULL, NULL), (32, 200, 'ABONO Dinael Rivas por: ', 'e', '2022-07-08', NULL, NULL), (33, 597, 'CREDITO DE Dinael Rivas por: 1 molsa \r\n2 harina', 'd', '2022-07-08', NULL, NULL), (34, 58, 'ABONO Misael rivas por: ', 'e', '2022-07-08', NULL, NULL), (35, 2075, 'CREDITO DE Ronal mashita por: 6 vita post\r\n1 molsa \r\n1 vita 18\r\n1 alicerdo 2', 'd', '2022-07-09', NULL, NULL), (36, 50, 'CREDITO DE mainor rivas (nito) por: fosfosel \r\n10 enrox', 'd', '2022-07-09', NULL, NULL); -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `categoria` -- CREATE TABLE `categoria` ( `id` bigint(20) UNSIGNED NOT NULL, `nombre` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0', `tipo` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0', `deleted_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Volcado de datos para la tabla `categoria` -- INSERT INTO `categoria` (`id`, `nombre`, `tipo`, `deleted_at`, `created_at`, `updated_at`) VALUES (1, 'UNDAD', 'UNIDAD', NULL, '2022-01-24 23:35:32', '2022-01-24 23:35:32'), (2, 'CAJA', 'CAJA', NULL, '2022-01-24 23:35:32', '2022-01-24 23:35:32'), (3, 'Quintal', 'Quintal', NULL, '2022-01-25 15:04:18', '2022-01-25 15:04:18'); -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `clientes` -- CREATE TABLE `clientes` ( `id` bigint(20) UNSIGNED NOT NULL, `nombre` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `nit` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT 'C/F', `direccion` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT 'Ciudad', `telefono1` varchar(12) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `telefono2` varchar(12) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Volcado de datos para la tabla `clientes` -- INSERT INTO `clientes` (`id`, `nombre`, `nit`, `direccion`, `telefono1`, `telefono2`, `deleted_at`, `created_at`, `updated_at`) VALUES (14, 'Consumidor Final', 'CF', 'ciudad', NULL, NULL, NULL, '2022-01-24 23:35:32', '2022-01-24 23:35:32'), (15, 'MONICA AGUIRRE', 'CF', 'CIUDAD', '55219408', '000', NULL, '2022-02-01 00:22:39', '2022-02-01 00:22:39'), (16, 'jose de jesus rivas', NULL, 'chinaca', '50659543', NULL, NULL, '2022-07-05 12:42:10', '2022-07-05 12:42:10'), (17, 'vicente vasquez', NULL, 'la estancia', '55717775', '40773755', NULL, '2022-07-05 12:43:16', '2022-07-05 12:43:16'), (18, 'mainor rivas (nito)', NULL, 'chinaca', '46905836', NULL, NULL, '2022-07-05 12:44:25', '2022-07-05 12:44:25'), (19, 'byron hernandez', NULL, 'chinaca', '46429997', NULL, NULL, '2022-07-05 12:45:37', '2022-07-05 12:45:37'), (20, 'Dinael Rivas', NULL, 'chinaca', '50599031', NULL, NULL, '2022-07-05 12:46:20', '2022-07-05 12:46:20'), (21, 'Ronal Oliva', NULL, 'zona 9 zaculeu', '57408391', NULL, NULL, '2022-07-05 12:47:25', '2022-07-05 12:47:25'), (22, 'Ronal mashita', NULL, 'La estancia chinaca', '59404456', NULL, NULL, '2022-07-05 12:48:12', '2022-07-05 12:48:12'), (23, 'Geovany sosa', NULL, 'La estancia posh', '53264832', NULL, NULL, '2022-07-05 12:49:10', '2022-07-05 12:49:10'), (24, 'Ariel Gomez', NULL, 'pox', '45289415', NULL, NULL, '2022-07-05 12:49:52', '2022-07-05 12:49:52'), (25, 'Edvin Vasquez', NULL, 'ocubila', '57534554', NULL, NULL, '2022-07-05 12:57:50', '2022-07-05 12:57:50'), (26, 'Norma Rivas', NULL, 'chinaca', NULL, NULL, NULL, '2022-07-05 13:35:54', '2022-07-05 13:35:54'), (27, 'yoni tomas', NULL, 'aldea el oregano', '51999765', '49337848', NULL, '2022-07-05 13:53:16', '2022-07-05 13:53:16'), (28, 'Saulo rivas', NULL, 'chinaca', '53462283', NULL, NULL, '2022-07-05 14:16:51', '2022-07-05 14:16:51'), (29, 'doña leida', NULL, 'chinaca', '53457350', NULL, NULL, '2022-07-05 14:18:43', '2022-07-05 14:18:43'), (30, 'Misael rivas', NULL, 'chinaca llano grande', '53235491', NULL, NULL, '2022-07-05 14:19:23', '2022-07-05 14:19:23'), (31, 'Rogelio GUIRRE', NULL, 'HUEHUETENANGO', '45450041', NULL, NULL, '2022-07-05 14:26:20', '2022-07-05 14:26:20'), (32, 'David (picop rojo)', NULL, 'chinaca yano grande', '48199390', NULL, NULL, '2022-07-05 14:29:41', '2022-07-05 14:29:41'), (33, 'Jose Maria Aguirre', NULL, 'huehue zona 3', '32812144', NULL, NULL, '2022-07-05 15:11:14', '2022-07-05 15:11:14'), (34, 'rony vasquez (yerno jorge)', NULL, 'chinaca', '51509443', NULL, NULL, '2022-07-05 15:59:44', '2022-07-05 15:59:44'), (35, 'herman ezequiel', NULL, 'comitansillo', '31390127', NULL, NULL, '2022-07-05 16:23:54', '2022-07-05 16:23:54'), (36, 'abraham colocho (paca)', NULL, 'chinaca', '58833965', NULL, NULL, '2022-07-05 17:11:42', '2022-07-05 17:11:42'), (37, 'Leocadio', NULL, 'chinaca', NULL, NULL, NULL, '2022-07-05 20:41:25', '2022-07-05 20:41:25'), (38, 'alexander gomez', NULL, 'chinaca llano grande', '40694486', NULL, NULL, '2022-07-05 21:40:50', '2022-07-05 21:40:50'), (39, 'Neftalyy (piquete)', NULL, 'chinaca', '57428613', NULL, NULL, '2022-07-06 18:29:10', '2022-07-06 18:29:10'), (40, 'GUILLERMO', NULL, 'ENTRADA LLANO GRANDE', '0150150', NULL, NULL, '2022-07-06 21:17:02', '2022-07-06 21:17:02'), (41, 'EMILIANO LOPEZ', NULL, 'CASERIO EL VALLE LA ESTANCIA', '47163231', NULL, NULL, '2022-07-06 21:37:41', '2022-07-06 21:37:41'), (42, 'sensey jorge', NULL, NULL, NULL, NULL, NULL, '2022-07-07 13:11:18', '2022-07-07 13:11:18'), (43, 'granja llano grande', NULL, 'chinaca llano grande', '42145929', NULL, NULL, '2022-07-07 14:31:22', '2022-07-07 14:31:22'), (44, 'Alezander Gilberto Castillo', NULL, 'huehue-chiantla', '47946311', NULL, NULL, '2022-07-07 15:50:02', '2022-07-07 15:50:02'), (45, 'Carlos vasquez', NULL, 'canton laguna ceca', '32664950', NULL, NULL, '2022-07-07 16:16:56', '2022-07-07 16:16:56'), (47, 'ingrid Tomas', NULL, 'el rancho', '45396794', NULL, NULL, '2022-07-07 20:34:02', '2022-07-07 20:34:02'), (48, 'carlos valdez', 'cf', 'chinaca', NULL, NULL, NULL, '2022-07-07 21:22:02', '2022-07-07 21:22:02'), (49, 'ARIEL RAMIREZ LOPEZ', '1201238', 'HUEHUETENANGO', '394887', '987234', NULL, '2022-07-09 15:12:58', '2022-07-09 15:12:58'); -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `compra_articulos` -- CREATE TABLE `compra_articulos` ( `id` bigint(20) UNSIGNED NOT NULL, `articulo_id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) UNSIGNED NOT NULL, `cantidad` double NOT NULL, `factura` char(35) COLLATE utf8mb4_unicode_ci NOT NULL, `fecha` date DEFAULT NULL, `fecha_vencimiento` date DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Volcado de datos para la tabla `compra_articulos` -- INSERT INTO `compra_articulos` (`id`, `articulo_id`, `user_id`, `cantidad`, `factura`, `fecha`, `fecha_vencimiento`, `created_at`, `updated_at`) VALUES (1, 9, 1, 12, '1162011441', '2022-01-28', '2023-01-28', NULL, NULL), (2, 10, 1, 20, '1162011441', '2022-01-28', '2023-01-28', NULL, NULL), (3, 7, 1, 35, '1162011441', '2022-01-28', '2023-01-28', NULL, NULL), (4, 1, 3, 20, '1056997', '2022-07-06', '2023-07-06', NULL, NULL), (5, 2, 3, 5, '1056997', '2022-07-06', '2023-07-06', NULL, NULL), (6, 7, 3, 30, '1056997', '2022-07-06', '2023-07-06', NULL, NULL), (7, 6, 3, 15, '1056997', '2022-07-06', '2023-07-06', NULL, NULL), (8, 23, 3, 3, '1056997', '2022-07-06', '2023-07-06', NULL, NULL), (9, 10, 3, 5, '1056997', '2022-07-06', '2023-07-06', NULL, NULL), (10, 9, 3, 5, '1056997', '2022-07-06', '2023-07-06', NULL, NULL), (11, 11, 3, 10, '1056997', '2022-07-06', '2023-07-06', NULL, NULL), (12, 13, 3, 5, '1056997', '2022-07-06', '2023-07-06', NULL, NULL), (13, 80, 3, 33, '8038', '2022-07-06', '2023-07-06', NULL, NULL), (14, 98, 3, 13, '8038', '2022-07-06', '2023-07-06', NULL, NULL), (15, 147, 3, 28, '8038', '2022-07-06', '2023-07-06', NULL, NULL), (16, 1, 3, 45, '1162056174', '2022-07-08', '2023-07-08', NULL, NULL); -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `compra_proveedores` -- CREATE TABLE `compra_proveedores` ( `id` bigint(20) UNSIGNED NOT NULL, `proveedor_id` bigint(20) UNSIGNED NOT NULL, `articulo_id` bigint(20) UNSIGNED NOT NULL, `cantidad` double NOT NULL, `factura` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `fecha_de_compra` date NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Volcado de datos para la tabla `compra_proveedores` -- INSERT INTO `compra_proveedores` (`id`, `proveedor_id`, `articulo_id`, `cantidad`, `factura`, `fecha_de_compra`, `created_at`, `updated_at`) VALUES (1, 2, 9, 12, '1162011441', '2022-01-28', '2022-01-28 19:09:25', '2022-01-28 19:09:25'), (2, 2, 10, 20, '1162011441', '2022-01-28', '2022-01-28 19:11:10', '2022-01-28 19:11:10'), (3, 2, 7, 35, '1162011441', '2022-01-28', '2022-01-28 19:14:18', '2022-01-28 19:14:18'), (4, 2, 1, 20, '1056997', '2022-07-06', '2022-07-06 18:39:28', '2022-07-06 18:39:28'), (5, 2, 2, 5, '1056997', '2022-07-06', '2022-07-06 18:39:28', '2022-07-06 18:39:28'), (6, 2, 7, 30, '1056997', '2022-07-06', '2022-07-06 18:39:28', '2022-07-06 18:39:28'), (7, 2, 6, 15, '1056997', '2022-07-06', '2022-07-06 18:39:28', '2022-07-06 18:39:28'), (8, 2, 23, 3, '1056997', '2022-07-06', '2022-07-06 18:39:28', '2022-07-06 18:39:28'), (9, 2, 10, 5, '1056997', '2022-07-06', '2022-07-06 18:39:28', '2022-07-06 18:39:28'), (10, 2, 9, 5, '1056997', '2022-07-06', '2022-07-06 18:39:28', '2022-07-06 18:39:28'), (11, 2, 11, 10, '1056997', '2022-07-06', '2022-07-06 18:39:28', '2022-07-06 18:39:28'), (12, 2, 13, 5, '1056997', '2022-07-06', '2022-07-06 18:40:00', '2022-07-06 18:40:00'), (13, 7, 80, 33, '8038', '2022-07-06', '2022-07-06 19:54:18', '2022-07-06 19:54:18'), (14, 7, 98, 13, '8038', '2022-07-06', '2022-07-06 19:54:18', '2022-07-06 19:54:18'), (15, 7, 147, 28, '8038', '2022-07-06', '2022-07-06 19:55:08', '2022-07-06 19:55:08'), (16, 2, 1, 45, '1162056174', '2022-07-08', '2022-07-08 17:35:36', '2022-07-08 17:35:36'); -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `cotizacion` -- CREATE TABLE `cotizacion` ( `id` bigint(20) UNSIGNED NOT NULL, `nombre` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `nit` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `articulo_id` bigint(20) UNSIGNED NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `codigo` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `cantidad` double NOT NULL, `total` double NOT NULL, `descuento` double DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `cuadre` -- CREATE TABLE `cuadre` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) UNSIGNED NOT NULL, `entrada` double(7,2) NOT NULL, `salida` double(7,2) NOT NULL, `cuadre` double(7,2) NOT NULL, `boleta` char(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `totalEfectico` double(7,2) NOT NULL, `faltante` double(7,2) NOT NULL, `totalVisas` double(7,2) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Volcado de datos para la tabla `cuadre` -- INSERT INTO `cuadre` (`id`, `user_id`, `entrada`, `salida`, `cuadre`, `boleta`, `totalEfectico`, `faltante`, `totalVisas`, `created_at`, `updated_at`) VALUES (1, 3, 0.00, 0.00, 0.00, NULL, 0.00, 0.00, 0.00, '2022-02-01 00:25:01', '2022-02-01 00:25:01'); -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `deuda_cliente` -- CREATE TABLE `deuda_cliente` ( `id` bigint(20) UNSIGNED NOT NULL, `cliente_id` bigint(20) UNSIGNED NOT NULL, `descripcion` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `total` double NOT NULL, `fecha_pago` date DEFAULT NULL, `estado` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'DEUDA', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Volcado de datos para la tabla `deuda_cliente` -- INSERT INTO `deuda_cliente` (`id`, `cliente_id`, `descripcion`, `total`, `fecha_pago`, `estado`, `created_at`, `updated_at`) VALUES (1, 15, '15 PACAS DE HENO', 375, '2022-02-02', 'DEUDA', '2022-02-01 00:23:26', '2022-02-01 00:23:26'), (2, 20, 'saldo anteriro de deuda', 2146, NULL, 'DEUDA', '2022-07-05 13:49:21', '2022-07-05 13:49:21'), (3, 26, 'Vita postura f1', 245, '2022-07-08', 'DEUDA', '2022-07-05 13:51:30', '2022-07-05 13:51:30'), (4, 28, 'saco de exelent', 640, '2022-07-08', 'DEUDA', '2022-07-05 14:17:54', '2022-07-05 14:17:54'), (5, 32, 'deuda de concentrado vita fin y aliengorde 2', 480, '2022-07-09', 'DEUDA', '2022-07-05 14:31:45', '2022-07-05 14:31:45'), (6, 18, 'pago de renta', 255, '2022-07-10', 'DEUDA', '2022-07-05 14:35:42', '2022-07-05 14:35:42'), (7, 29, 'vita fin 2 quintales del dia 4/7/', 675, '2022-07-07', 'DEUDA', '2022-07-05 14:37:55', '2022-07-05 14:37:55'), (8, 17, '4 vita 18\r\n1 molsa \r\n1 econocriollo', 1262, '2022-07-08', 'DEUDA', '2022-07-05 14:39:52', '2022-07-05 14:39:52'), (9, 31, 'pet masterdos bolsas \r\ndesparasitante y antidiarreico', 545, '2022-07-15', 'DEUDA', '2022-07-05 14:41:54', '2022-07-05 14:41:54'), (10, 31, 'pet masterdos bolsas \r\ndesparasitante y antidiarreico', 545, '2022-07-15', 'DEUDA', '2022-07-05 14:41:54', '2022-07-05 14:41:54'), (11, 15, 'flumeg y dipiron', 240, '2022-07-05', 'DEUDA', '2022-07-05 14:42:32', '2022-07-05 14:42:32'), (12, 33, 'prestamo de compra de cel', 700, '2022-07-15', 'DEUDA', '2022-07-05 15:19:44', '2022-07-05 15:19:44'), (13, 36, 'econogando', 160, '2022-07-09', 'DEUDA', '2022-07-05 17:12:39', '2022-07-05 17:12:39'), (14, 22, '6 vita postura', 1440, '2022-07-07', 'DEUDA', '2022-07-06 15:47:33', '2022-07-06 15:47:33'), (15, 19, '4 harina de maiz', 780, '2022-07-09', 'DEUDA', '2022-07-06 18:16:39', '2022-07-06 18:16:39'), (16, 29, '1 vita inicio', 277, '2022-07-09', 'DEUDA', '2022-07-06 18:17:27', '2022-07-06 18:17:27'), (17, 30, 'VITA FIN', 279, '2022-07-06', 'DEUDA', '2022-07-06 18:52:10', '2022-07-06 18:52:10'), (18, 31, 'VACUNA CACHORROS', 240, '2022-07-09', 'DEUDA', '2022-07-06 19:43:06', '2022-07-06 19:43:06'), (19, 17, '1 VITA 18\r\n1 VITA NOVILLA', 398, '2022-07-11', 'DEUDA', '2022-07-06 21:41:42', '2022-07-06 21:41:42'), (20, 45, 'bio nova 2', 315, '2022-07-14', 'DEUDA', '2022-07-07 16:29:59', '2022-07-07 16:29:59'), (21, 18, '1 trimsulfa \r\n10 trifen plus', 120, '2022-07-09', 'DEUDA', '2022-07-08 14:40:40', '2022-07-08 14:40:40'), (22, 17, '3 vita 18 \r\n1 molsa', 786, '2022-07-11', 'DEUDA', '2022-07-08 15:40:48', '2022-07-08 15:40:48'), (23, 20, '1 molsa \r\n2 harina', 597, '2022-07-15', 'DEUDA', '2022-07-08 19:31:10', '2022-07-08 19:31:10'), (24, 22, '6 vita post\r\n1 molsa \r\n1 vita 18\r\n1 alicerdo 2', 2075, '2022-07-10', 'DEUDA', '2022-07-09 12:55:04', '2022-07-09 12:55:04'), (25, 18, 'fosfosel \r\n10 enrox', 50, '2022-07-12', 'DEUDA', '2022-07-09 15:26:44', '2022-07-09 15:26:44'); -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `facturas` -- CREATE TABLE `facturas` ( `id` bigint(20) UNSIGNED NOT NULL, `descuento` double DEFAULT NULL, `descripcion` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `total` double(7,2) DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `factura` varchar(3) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `nombre` varchar(70) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `nit` varchar(15) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `direccion` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Volcado de datos para la tabla `facturas` -- INSERT INTO `facturas` (`id`, `descuento`, `descripcion`, `total`, `deleted_at`, `created_at`, `updated_at`, `factura`, `nombre`, `nit`, `direccion`) VALUES (1, NULL, NULL, 1100.00, NULL, '2022-01-25 17:10:47', '2022-01-25 17:10:47', 'NO', 'CONSUMIDOR FINAL', 'CF', 'CIUDAD'), (2, NULL, NULL, 135.00, NULL, '2022-01-28 19:17:59', '2022-01-28 19:17:59', 'NO', 'CONSUMIDOR FINAL', 'CF', 'CIUDAD'), (3, NULL, NULL, 375.00, NULL, '2022-02-01 00:21:50', '2022-02-01 00:21:50', 'NO', 'CONSUMIDOR FINAL', 'CF', 'CIUDAD'), (4, NULL, NULL, 10.00, NULL, '2022-02-01 00:46:29', '2022-02-01 00:46:29', 'SI', 'aril', '101', 'hola'), (5, NULL, NULL, 10.00, NULL, '2022-02-01 00:47:56', '2022-02-01 00:47:56', 'NO', 'CONSUMIDOR FINAL', 'CF', 'CIUDAD'), (6, NULL, NULL, 255.00, NULL, '2022-07-04 23:26:55', '2022-07-04 23:26:55', 'NO', 'CONSUMIDOR FINAL', 'CF', 'CIUDAD'), (7, NULL, NULL, 1655.00, NULL, '2022-07-04 23:32:32', '2022-07-04 23:32:32', 'NO', 'CONSUMIDOR FINAL', 'CF', 'CIUDAD'), (8, NULL, NULL, 245.00, NULL, '2022-07-05 12:55:42', '2022-07-05 12:55:42', 'NO', 'CONSUMIDOR FINAL', 'CF', 'CIUDAD'), (9, NULL, NULL, 1100.00, NULL, '2022-07-05 14:02:11', '2022-07-05 14:02:11', 'NO', 'CONSUMIDOR FINAL', 'CF', 'CIUDAD'), (10, NULL, NULL, 278.00, NULL, '2022-07-05 16:01:58', '2022-07-05 16:01:58', 'NO', 'CONSUMIDOR FINAL', 'CF', 'CIUDAD'), (11, NULL, NULL, 1323.00, NULL, '2022-07-05 16:37:03', '2022-07-05 16:37:03', 'NO', 'CONSUMIDOR FINAL', 'CF', 'CIUDAD'), (12, NULL, NULL, 55.00, NULL, '2022-07-05 18:25:35', '2022-07-05 18:25:35', 'NO', 'CONSUMIDOR FINAL', 'CF', 'CIUDAD'), (13, NULL, NULL, 28.00, NULL, '2022-07-05 18:52:59', '2022-07-05 18:52:59', 'NO', 'CONSUMIDOR FINAL', 'CF', 'CIUDAD'), (14, NULL, NULL, 720.00, NULL, '2022-07-05 19:24:16', '2022-07-05 19:24:16', 'NO', 'CONSUMIDOR FINAL', 'CF', 'CIUDAD'), (15, NULL, NULL, 250.00, NULL, '2022-07-05 19:25:12', '2022-07-05 19:25:12', 'NO', 'CONSUMIDOR FINAL', 'CF', 'CIUDAD'), (16, NULL, NULL, 875.00, NULL, '2022-07-05 20:28:11', '2022-07-05 20:28:11', 'NO', 'CONSUMIDOR FINAL', 'CF', 'CIUDAD'), (17, NULL, NULL, 1570.00, NULL, '2022-07-05 21:45:25', '2022-07-05 21:45:25', 'NO', 'CONSUMIDOR FINAL', 'CF', 'CIUDAD'), (18, NULL, NULL, 510.00, NULL, '2022-07-06 12:47:59', '2022-07-06 12:47:59', 'NO', 'CONSUMIDOR FINAL', 'CF', 'CIUDAD'), (19, NULL, NULL, 355.00, NULL, '2022-07-06 12:55:02', '2022-07-06 12:55:02', 'NO', 'CONSUMIDOR FINAL', 'CF', 'CIUDAD'), (20, NULL, NULL, 15.00, NULL, '2022-07-06 13:00:40', '2022-07-06 13:00:40', 'NO', 'CONSUMIDOR FINAL', 'CF', 'CIUDAD'), (21, NULL, NULL, 250.00, NULL, '2022-07-06 13:23:46', '2022-07-06 13:23:46', 'NO', 'CONSUMIDOR FINAL', 'CF', 'CIUDAD'), (22, NULL, NULL, 55.00, NULL, '2022-07-06 14:17:23', '2022-07-06 14:17:23', 'NO', 'CONSUMIDOR FINAL', 'CF', 'CIUDAD'), (23, NULL, NULL, 45.00, NULL, '2022-07-06 14:37:34', '2022-07-06 14:37:34', 'NO', 'CONSUMIDOR FINAL', 'CF', 'CIUDAD'), (24, NULL, NULL, 45.00, NULL, '2022-07-06 14:52:00', '2022-07-06 14:52:00', 'NO', 'CONSUMIDOR FINAL', 'CF', 'CIUDAD'), (25, NULL, NULL, 240.00, NULL, '2022-07-06 15:48:21', '2022-07-06 15:48:21', 'NO', 'CONSUMIDOR FINAL', 'CF', 'CIUDAD'), (26, NULL, NULL, 30.00, NULL, '2022-07-06 18:25:52', '2022-07-06 18:25:52', 'NO', 'CONSUMIDOR FINAL', 'CF', 'CIUDAD'), (27, NULL, NULL, 1970.00, NULL, '2022-07-06 18:50:30', '2022-07-06 18:50:30', 'SI', 'NEFTALY', 'C-F', 'CHINACA'), (28, NULL, NULL, 279.00, NULL, '2022-07-06 18:53:36', '2022-07-06 18:53:36', 'SI', 'MISAEL', 'C-F', 'CHINACA LLANO GRANDE'), (29, NULL, NULL, 240.00, NULL, '2022-07-06 19:28:26', '2022-07-06 19:28:26', 'NO', 'CONSUMIDOR FINAL', 'CF', 'CIUDAD'), (30, NULL, NULL, 480.00, NULL, '2022-07-06 19:56:37', '2022-07-06 19:56:37', 'NO', 'CONSUMIDOR FINAL', 'CF', 'CIUDAD'), (31, NULL, NULL, 245.00, NULL, '2022-07-06 21:38:30', '2022-07-06 21:38:30', 'NO', 'CONSUMIDOR FINAL', 'CF', 'CIUDAD'), (32, NULL, NULL, 195.00, NULL, '2022-07-06 21:53:00', '2022-07-06 21:53:00', 'NO', 'CONSUMIDOR FINAL', 'CF', 'CIUDAD'), (33, NULL, NULL, 15.00, NULL, '2022-07-06 22:01:49', '2022-07-06 22:01:49', 'NO', 'CONSUMIDOR FINAL', 'CF', 'CIUDAD'), (34, NULL, NULL, 185.00, NULL, '2022-07-07 12:41:05', '2022-07-07 12:41:05', 'NO', 'CONSUMIDOR FINAL', 'CF', 'CIUDAD'), (35, NULL, NULL, 37.00, NULL, '2022-07-07 13:11:18', '2022-07-07 13:11:18', 'NO', 'CONSUMIDOR FINAL', 'CF', 'CIUDAD'), (36, NULL, NULL, 285.00, NULL, '2022-07-07 13:44:43', '2022-07-07 13:44:43', 'NO', 'CONSUMIDOR FINAL', 'CF', 'CIUDAD'), (37, NULL, NULL, 30.00, NULL, '2022-07-07 13:56:48', '2022-07-07 13:56:48', 'NO', 'CONSUMIDOR FINAL', 'CF', 'CIUDAD'), (38, NULL, NULL, 30.00, NULL, '2022-07-07 13:58:46', '2022-07-07 13:58:46', 'NO', 'CONSUMIDOR FINAL', 'CF', 'CIUDAD'), (39, NULL, NULL, 90.00, NULL, '2022-07-07 14:33:13', '2022-07-07 14:33:13', 'NO', 'CONSUMIDOR FINAL', 'CF', 'CIUDAD'), (40, NULL, NULL, 35.00, NULL, '2022-07-07 15:18:25', '2022-07-07 15:18:25', 'NO', 'CONSUMIDOR FINAL', 'CF', 'CIUDAD'), (41, NULL, NULL, 245.00, NULL, '2022-07-07 16:27:46', '2022-07-07 16:27:46', 'NO', 'CONSUMIDOR FINAL', 'CF', 'CIUDAD'), (42, NULL, NULL, 447.00, NULL, '2022-07-07 18:28:23', '2022-07-07 18:28:23', 'NO', 'CONSUMIDOR FINAL', 'CF', 'CIUDAD'), (43, NULL, NULL, 278.00, NULL, '2022-07-07 18:51:40', '2022-07-07 18:51:40', 'NO', 'CONSUMIDOR FINAL', 'CF', 'CIUDAD'), (44, NULL, NULL, 200.00, NULL, '2022-07-07 19:02:13', '2022-07-07 19:02:13', 'NO', 'CONSUMIDOR FINAL', 'CF', 'CIUDAD'), (45, NULL, NULL, 35.00, NULL, '2022-07-07 19:08:03', '2022-07-07 19:08:03', 'NO', 'CONSUMIDOR FINAL', 'CF', 'CIUDAD'), (46, NULL, NULL, 610.00, NULL, '2022-07-07 19:28:32', '2022-07-07 19:28:32', 'NO', 'CONSUMIDOR FINAL', 'CF', 'CIUDAD'), (47, NULL, NULL, 180.00, NULL, '2022-07-07 20:06:00', '2022-07-07 20:06:00', 'NO', 'CONSUMIDOR FINAL', 'CF', 'CIUDAD'), (48, NULL, NULL, 240.00, NULL, '2022-07-07 20:14:22', '2022-07-07 20:14:22', 'NO', 'CONSUMIDOR FINAL', 'CF', 'CIUDAD'), (49, NULL, NULL, 570.00, NULL, '2022-07-07 20:35:01', '2022-07-07 20:35:01', 'NO', 'CONSUMIDOR FINAL', 'CF', 'CIUDAD'), (50, NULL, NULL, 140.00, NULL, '2022-07-07 21:22:02', '2022-07-07 21:22:02', 'SI', 'carlos valdez', 'cf', 'chinaca'), (51, NULL, NULL, 250.00, NULL, '2022-07-07 21:25:15', '2022-07-07 21:25:15', 'NO', 'CONSUMIDOR FINAL', 'CF', 'CIUDAD'), (52, NULL, NULL, 40.00, NULL, '2022-07-08 12:52:30', '2022-07-08 12:52:30', 'NO', 'CONSUMIDOR FINAL', 'CF', 'CIUDAD'), (53, NULL, NULL, 475.00, NULL, '2022-07-08 13:40:33', '2022-07-08 13:40:33', 'NO', 'CONSUMIDOR FINAL', 'CF', 'CIUDAD'), (54, NULL, NULL, 15.00, NULL, '2022-07-08 14:27:44', '2022-07-08 14:27:44', 'NO', 'CONSUMIDOR FINAL', 'CF', 'CIUDAD'), (55, NULL, NULL, 15.00, NULL, '2022-07-08 14:31:35', '2022-07-08 14:31:35', 'NO', 'CONSUMIDOR FINAL', 'CF', 'CIUDAD'), (56, NULL, NULL, 60.00, NULL, '2022-07-08 14:39:42', '2022-07-08 14:39:42', 'NO', 'CONSUMIDOR FINAL', 'CF', 'CIUDAD'), (57, NULL, NULL, 55.00, NULL, '2022-07-08 14:42:42', '2022-07-08 14:42:42', 'NO', 'CONSUMIDOR FINAL', 'CF', 'CIUDAD'), (58, NULL, NULL, 789.00, NULL, '2022-07-08 15:43:54', '2022-07-08 15:43:54', 'NO', 'CONSUMIDOR FINAL', 'CF', 'CIUDAD'), (59, NULL, NULL, 645.00, NULL, '2022-07-08 17:29:40', '2022-07-08 17:29:40', 'NO', 'CONSUMIDOR FINAL', 'CF', 'CIUDAD'), (60, NULL, NULL, 223.00, NULL, '2022-07-08 18:45:07', '2022-07-08 18:45:07', 'NO', 'CONSUMIDOR FINAL', 'CF', 'CIUDAD'), (61, NULL, NULL, 245.00, NULL, '2022-07-08 19:18:39', '2022-07-08 19:18:39', 'NO', 'CONSUMIDOR FINAL', 'CF', 'CIUDAD'), (62, NULL, NULL, 177.00, NULL, '2022-07-08 19:20:16', '2022-07-08 19:20:16', 'NO', 'CONSUMIDOR FINAL', 'CF', 'CIUDAD'), (63, NULL, NULL, 279.00, NULL, '2022-07-08 20:00:37', '2022-07-08 20:00:37', 'NO', 'CONSUMIDOR FINAL', 'CF', 'CIUDAD'), (64, NULL, NULL, 2850.00, NULL, '2022-07-08 20:18:41', '2022-07-08 20:18:41', 'NO', 'CONSUMIDOR FINAL', 'CF', 'CIUDAD'), (65, NULL, NULL, 554.00, NULL, '2022-07-08 20:19:49', '2022-07-08 20:19:49', 'NO', 'CONSUMIDOR FINAL', 'CF', 'CIUDAD'), (66, NULL, NULL, 390.00, NULL, '2022-07-08 21:10:24', '2022-07-08 21:10:24', 'NO', 'CONSUMIDOR FINAL', 'CF', 'CIUDAD'), (67, NULL, NULL, 590.00, NULL, '2022-07-08 21:12:05', '2022-07-08 21:12:05', 'NO', 'CONSUMIDOR FINAL', 'CF', 'CIUDAD'), (68, NULL, NULL, 55.00, NULL, '2022-07-09 13:18:28', '2022-07-09 13:18:28', 'NO', 'CONSUMIDOR FINAL', 'CF', 'CIUDAD'), (69, NULL, NULL, 55.00, NULL, '2022-07-09 13:19:46', '2022-07-09 13:19:46', 'NO', 'CONSUMIDOR FINAL', 'CF', 'CIUDAD'), (70, NULL, NULL, 150.00, NULL, '2022-07-09 13:26:51', '2022-07-09 13:26:51', 'NO', 'CONSUMIDOR FINAL', 'CF', 'CIUDAD'), (71, NULL, NULL, 245.00, NULL, '2022-07-09 13:47:25', '2022-07-09 13:47:25', 'NO', 'CONSUMIDOR FINAL', 'CF', 'CIUDAD'), (72, NULL, NULL, 30.00, NULL, '2022-07-09 14:25:12', '2022-07-09 14:25:12', 'NO', 'CONSUMIDOR FINAL', 'CF', 'CIUDAD'), (73, NULL, NULL, 278.00, NULL, '2022-07-09 14:51:12', '2022-07-09 14:51:12', 'NO', 'CONSUMIDOR FINAL', 'CF', 'CIUDAD'), (74, NULL, NULL, 500.00, NULL, '2022-07-09 15:17:14', '2022-07-09 15:17:14', 'NO', 'CONSUMIDOR FINAL', 'CF', 'CIUDAD'), (75, NULL, NULL, 55.00, NULL, '2022-07-09 15:28:16', '2022-07-09 15:28:16', 'NO', 'CONSUMIDOR FINAL', 'CF', 'CIUDAD'), (76, NULL, NULL, 200.00, NULL, '2022-07-09 15:38:16', '2022-07-09 15:38:16', 'NO', 'CONSUMIDOR FINAL', 'CF', 'CIUDAD'), (77, NULL, NULL, 100.00, NULL, '2022-07-09 15:38:28', '2022-07-09 15:38:28', 'NO', 'CONSUMIDOR FINAL', 'CF', 'CIUDAD'), (78, NULL, NULL, 100.00, NULL, '2022-07-09 15:38:44', '2022-07-09 15:38:44', 'NO', 'CONSUMIDOR FINAL', 'CF', 'CIUDAD'), (79, NULL, NULL, 1930.00, NULL, '2022-07-09 15:38:51', '2022-07-09 15:38:51', 'NO', 'CONSUMIDOR FINAL', 'CF', 'CIUDAD'), (80, NULL, NULL, 100.00, NULL, '2022-07-09 15:43:49', '2022-07-09 15:43:49', 'NO', 'CONSUMIDOR FINAL', 'CF', 'CIUDAD'), (81, NULL, NULL, 245.00, NULL, '2022-07-09 16:11:24', '2022-07-09 16:11:24', 'NO', 'CONSUMIDOR FINAL', 'CF', 'CIUDAD'), (82, NULL, NULL, 10270.00, NULL, '2022-07-09 16:50:03', '2022-07-09 16:50:03', 'NO', 'CONSUMIDOR FINAL', 'CF', 'CIUDAD'); -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `facturas_proveedor` -- CREATE TABLE `facturas_proveedor` ( `id` bigint(20) UNSIGNED NOT NULL, `proveedor_id` bigint(20) UNSIGNED NOT NULL, `factura` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `valor` double NOT NULL, `fecha_de_pago` date DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `fecha_compra` date DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Volcado de datos para la tabla `facturas_proveedor` -- INSERT INTO `facturas_proveedor` (`id`, `proveedor_id`, `factura`, `valor`, `fecha_de_pago`, `created_at`, `updated_at`, `fecha_compra`) VALUES (1, 7, '7060', 1810.15, '2022-02-15', '2022-01-28 19:28:17', '2022-01-28 19:28:17', '2022-01-04'), (3, 7, 'Jdj', 100, '2022-01-29', '2022-01-28 19:33:53', '2022-01-28 19:33:53', '2022-01-20'), (4, 4, '6347', 6000, '2022-02-10', '2022-01-28 20:12:15', '2022-01-28 20:12:15', '2022-01-27'), (5, 6, '3016', 1200, '2022-02-21', '2022-01-28 20:15:00', '2022-01-28 20:15:00', '2022-01-21'), (6, 5, '2319271670', 3738.65, '2022-02-13', '2022-01-28 20:16:22', '2022-01-28 20:16:22', '2022-01-13'), (7, 5, '4050404681', 1598.2, '2022-02-13', '2022-01-28 20:17:50', '2022-01-28 20:17:50', '2022-01-13'), (8, 8, '1213', 1753, '2022-01-30', '2022-01-28 21:22:53', '2022-01-28 21:22:53', '2022-01-27'); -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `migrations` -- CREATE TABLE `migrations` ( `id` int(10) UNSIGNED NOT NULL, `migration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `batch` int(11) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Volcado de datos para la tabla `migrations` -- INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (1, '2014_10_12_000000_create_users_table', 1), (2, '2014_10_12_100000_create_password_resets_table', 1), (3, '2020_12_17_055226_create_roles_table', 1), (4, '2020_12_17_055308_create_permissions_table', 1), (5, '2020_12_17_060416_create_role_permissions_pivot_table', 1), (6, '2020_12_17_061340_add_relationship_fields_to_users_table', 1), (7, '2021_01_26_213743_create_trakings_table', 1), (8, '2021_07_15_120544_create_proveedores_table', 1), (9, '2021_07_15_120655_create_categoria_table', 1), (10, '2021_07_15_120739_create_caja_table', 1), (11, '2021_07_15_120836_create_clientes_table', 1), (12, '2021_07_15_121820_create_cuadre_table', 1), (13, '2021_07_15_122110_create_facturas_table', 1), (14, '2021_07_15_122210_create_articulos_table', 1), (15, '2021_07_15_123708_create_ventasarticulos_table', 1), (16, '2021_07_15_123852_create_articulos_catalogo__table', 1), (17, '2021_07_15_124008_create_compra_articulos_table', 1), (18, '2021_07_15_124139_add_proveedor_to_articulos', 1), (19, '2021_07_15_230108_add_fone_to_users', 1), (20, '2021_07_16_193613_add_pdescuento_to_articulos', 1), (21, '2021_07_28_142109_add_horario_to_user', 1), (22, '2021_07_29_133256_create_cotizacion_table', 1), (23, '2021_07_30_122849_create_facturas_proveedor_table', 1), (24, '2021_07_30_132734_create_abonos_proveedores_table', 1), (25, '2021_07_30_174834_add_data_to_cotizacion', 1), (26, '2021_07_31_170857_create_compra_proveedores_table', 1), (27, '2021_09_11_200955_add_nombre_empresa_to_proveedores', 1), (28, '2021_09_11_221341_add_fecha_compra_to_facturas_proveedor', 1), (29, '2021_09_21_221727_add_description_to_permissions', 1), (30, '2021_12_06_222715_add_url_to_articulos', 1), (31, '2022_01_12_221337_add_check_to_facturas', 1), (32, '2022_01_12_224703_add_cliente_to_facturas', 1), (33, '2022_01_19_125336_create_deuda_cliente', 1), (34, '2022_01_24_170949_create_abono_clientes_table', 1); -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `password_resets` -- CREATE TABLE `password_resets` ( `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `permissions` -- CREATE TABLE `permissions` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `description` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Volcado de datos para la tabla `permissions` -- INSERT INTO `permissions` (`id`, `name`, `created_at`, `updated_at`, `description`) VALUES (1, 'admin_panel_access', '2022-01-24 23:35:32', '2022-01-24 23:35:32', 'PERMITE EL ACCESO AL SISTEMA'), (2, 'users_access', '2022-01-24 23:35:32', '2022-01-24 23:35:32', 'PERMITE LISTAR LOS USUARIOS'), (3, 'user_edit', '2022-01-24 23:35:32', '2022-01-24 23:35:32', 'PERMITE EDITAR LOS USUARIOS'), (4, 'user_delete', '2022-01-24 23:35:32', '2022-01-24 23:35:32', 'PERMITE ELIMINAR A UN USUARIO'), (5, 'user_create', '2022-01-24 23:35:32', '2022-01-24 23:35:32', 'PERMITE REGISTRAR A UN USUARIO'), (6, 'user_show', '2022-01-24 23:35:32', '2022-01-24 23:35:32', 'VER PERFIL DE USUARIO'), (7, 'roles_access', '2022-01-24 23:35:32', '2022-01-24 23:35:32', 'PERMITE LISTAR LOS ROLES'), (8, 'role_edit', '2022-01-24 23:35:32', '2022-01-24 23:35:32', 'PERMITE EDITAR LOS ROLES'), (9, 'role_delete', '2022-01-24 23:35:32', '2022-01-24 23:35:32', 'PERMITE ELIMINAR UN ROL'), (10, 'role_create', '2022-01-24 23:35:32', '2022-01-24 23:35:32', 'PERMITE CREAR UN ROL'), (11, 'role_show', '2022-01-24 23:35:32', '2022-01-24 23:35:32', 'PERMITE VISUALIZAR UN ROL'), (12, 'permissions_access', '2022-01-24 23:35:32', '2022-01-24 23:35:32', NULL), (13, 'permission_edit', '2022-01-24 23:35:32', '2022-01-24 23:35:32', NULL), (14, 'permission_delete', '2022-01-24 23:35:32', '2022-01-24 23:35:32', NULL), (15, 'permission_create', '2022-01-24 23:35:32', '2022-01-24 23:35:32', NULL), (16, 'articulos_listado', '2022-01-24 23:35:32', '2022-01-24 23:35:32', 'PERMITE LISTAR TODOS LOS ARTICULOS'), (17, 'articulos_show', '2022-01-24 23:35:32', '2022-01-24 23:35:32', 'PERMITE VER Y ACTUALIZR EL PERFIL DE LOS ARTICULOS'), (18, 'articulos_store', '2022-01-24 23:35:32', '2022-01-24 23:35:32', 'PERMITE REGISTAR UN NUEVO ARTICULO'), (19, 'articulos_delete', '2022-01-24 23:35:32', '2022-01-24 23:35:32', 'PERMITE ELIMINAR UN ARTICULO'), (20, 'articulos_min_stock', '2022-01-24 23:35:32', '2022-01-24 23:35:32', 'PERMITE VISUALIZAR LOS ARTICULOS CON MINIMO DE STOCK'), (21, 'articulos_compra_store', '2022-01-24 23:35:32', '2022-01-24 23:35:32', 'PERMITE GURARDAR UNA COMPRA DE UN ARTICULO YA EXISTENTE'), (22, 'articulos_historial', '2022-01-24 23:35:32', '2022-01-24 23:35:32', 'PERMITE VER EL HISTORIAL DE COMPRAS DE LOS ARTICULOS'), (23, 'articulos_hitorial_delete', '2022-01-24 23:35:32', '2022-01-24 23:35:32', 'PERMITE ELIMINAR UN ARTICULO DEL HISTORIAL DE COMPRAS'), (24, 'articulos_report_all', '2022-01-24 23:35:32', '2022-01-24 23:35:32', 'PERMITE VER TODOS LOS REPORTES DE LOS ARTICULOS'), (25, 'articulos_catalogo_add', '2022-01-24 23:35:32', '2022-01-24 23:35:32', 'PERMITE AÑADIR UN ARTICULO PARA EL CATALOGO'), (26, 'articulos_catalogo_update', '2022-01-24 23:35:32', '2022-01-24 23:35:32', 'PERMITE ACTUALIZAR UN ARTICULO EN CATALOGO'), (27, 'articulos_catalog_delete', '2022-01-24 23:35:32', '2022-01-24 23:35:32', 'PERMITE ELIMINAR UN ARTICULO EN CATLOGO'), (28, 'articulos_catalogo_report', '2022-01-24 23:35:32', '2022-01-24 23:35:32', 'PERMITE GENERAR EL REPORTE DE ARTICULOS EN CATALOGO'), (29, 'clientes_all', '2022-01-24 23:35:32', '2022-01-24 23:35:32', 'PERMITE USO DE MODULO DE CLIENTES'), (30, 'categoria_list', '2022-01-24 23:35:32', '2022-01-24 23:35:32', 'PERMITE LISTAR TODAS LAS CATEGORIAS'), (31, 'categoria_show', '2022-01-24 23:35:32', '2022-01-24 23:35:32', 'PERMITE VER EL PERFIL DE CATEGORIAS / ACTUALIZAR'), (32, 'categoria_delete', '2022-01-24 23:35:32', '2022-01-24 23:35:32', 'PERMITE ELIMINAR UNA CATEGORIA'), (33, 'categoria_create', '2022-01-24 23:35:32', '2022-01-24 23:35:32', 'PERMITE CREAR UNA NUEVA CATEGORIA'), (34, 'categoria_report', '2022-01-24 23:35:32', '2022-01-24 23:35:32', 'PERMITE GENERAR EL REPORTE DE CATEGORIAS'), (35, 'venta_inicio', '2022-01-24 23:35:32', '2022-01-24 23:35:32', 'PERMITE REALIZAR VENTAS E IMPRIMIR RECIBOS'), (36, 'venta_historial', '2022-01-24 23:35:32', '2022-01-24 23:35:32', 'PERMITE VER EL HITORIAL DE VENTAS'), (37, 'venta_recibo', '2022-01-24 23:35:32', '2022-01-24 23:35:32', 'PERMITE LA REIMPRESION DE RECIBOS DE VETAS'), (38, 'venta_anulacion', '2022-01-24 23:35:32', '2022-01-24 23:35:32', 'PERMITE LA ANULACION DE UNA VENTA'), (39, 'venta_reports', '2022-01-24 23:35:32', '2022-01-24 23:35:32', 'PERMITE GENERAR TODOS LOS REPORTES DE VENTAS'), (40, 'caja_registro_cajachica', '2022-01-24 23:35:32', '2022-01-24 23:35:32', 'PERMITE REGISTRAR DATOS EN CAJA CHICA'), (41, 'caja_registro_gastos', '2022-01-24 23:35:32', '2022-01-24 23:35:32', 'PERMITE REGISTRAR GASTOS'), (42, 'caja_cuadre', '2022-01-24 23:35:32', '2022-01-24 23:35:32', 'PERMITE REALIZAR UN CUADRE'), (43, 'caja_cuadre_delete', '2022-01-24 23:35:32', '2022-01-24 23:35:32', 'PERMITE ELIMINAR REPORTE DE CUADRES DE CAJA'), (44, 'caja_delete_cajachica', '2022-01-24 23:35:32', '2022-01-24 23:35:32', 'PERMITE ELIMINAR UN DATO DE CAJA CHICA'), (45, 'caja_delete_gasto', '2022-01-24 23:35:32', '2022-01-24 23:35:32', 'PERMITE ELIMINAR UN DATO DE GASTOS'), (46, 'caja_filtrado_cajachica', '2022-01-24 23:35:32', '2022-01-24 23:35:32', 'PERMITE VER MOVIMIENTOS DE CAJA CHICA FILTRADOS'), (47, 'caja_filtrado_gastos', '2022-01-24 23:35:32', '2022-01-24 23:35:32', 'PERMITE VER MOVIMIENTOS DE GASTOS FILTRADOS'), (48, 'caja_movimientos_filtrados', '2022-01-24 23:35:32', '2022-01-24 23:35:32', 'PERMITE VER LOS MOVIMIENTOS DEL MES / FILTRADOS'), (49, 'caja_movimientos_dia', '2022-01-24 23:35:32', '2022-01-24 23:35:32', 'PERMITE VER LOS MOVIMIENTOS DEL DIA'), (50, 'tracking_all', '2022-01-24 23:35:32', '2022-01-24 23:35:32', 'PERMITE USO DE MODULO DE TRACKINGS'), (51, 'proveedor_list', '2022-01-24 23:35:32', '2022-01-24 23:35:32', 'PERMITE LISTAR A TODOS LOS PROVEEDORES'), (52, 'proveedor_all', '2022-01-24 23:35:32', '2022-01-24 23:35:32', 'PERMITE VISUALIZAR EL PERFIL DE CADA PROVEEDOR PARA ACTUALIZAR DATOS Y ASIGNAR FACTURAS DE PAGO'); -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `proveedores` -- CREATE TABLE `proveedores` ( `id` bigint(20) UNSIGNED NOT NULL, `nombre` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `telefono1` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `telefono2` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT 'Not a Number', `articulos` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `dias` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `empresa` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `direccion` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Volcado de datos para la tabla `proveedores` -- INSERT INTO `proveedores` (`id`, `nombre`, `telefono1`, `telefono2`, `articulos`, `dias`, `deleted_at`, `created_at`, `updated_at`, `empresa`, `direccion`) VALUES (1, 'Proveedor Ejemplo', '456123', '456456', 'Hierro, Cemento, Tubos, Clavos, Pegamix', 'jueves, sabado', '2022-01-25 14:37:50', '2022-01-24 23:35:32', '2022-01-25 14:37:50', NULL, NULL), (2, 'ALIANSA', '000000001', '0000000002', 'VITAENGORDE FIN\r\nVITAENGORDE INCIO\r\nALIENGORDE 1\r\nALIENGORDE 2\r\nARINA DE MAIZ\r\nVITAPOSTURA F1\r\nALIPONEDOTA 1\r\nVITALECHERO 16\r\nVITALECHERO 18\r\nECONOGANADO\r\nTORO GRAN CAMPEON\r\nALICERDO 1\r\nALICERDO 2', 'LUN- DON', NULL, '2022-01-25 14:42:02', '2022-01-25 14:42:02', 'ALIANSA', 'HUEHUETENANGO'), (3, 'CINTA AZUL', '00000001', '00000001', 'INICIADOR CINTA AZUL\r\nFINALIZADOR CINTA AZUL\r\nDESARROLLADOR CINTA AZUL\r\nPREINICIO CINTA AZUL\r\nDESAROLLADOR PONEDORA CINTA AZUL', 'LUN - DOM', NULL, '2022-01-25 15:00:10', '2022-01-25 15:00:10', 'CINTA AZUL', 'GUATEMALA'), (4, 'ADOLFO MARIN RIVAS', '30255816', NULL, 'MOLSA \r\nSALVADILLO\r\nPONEDORA NUTRA MIX FASE1', NULL, NULL, '2022-01-28 18:16:22', '2022-01-28 18:16:22', 'NUTRA MIX', 'CHINACA'), (5, 'RICARDO LABET', '30773652', NULL, 'vacuna \r\ninsumos veterinarios / labimectin, labibol, labivit hierro, labivitasan', NULL, NULL, '2022-01-28 18:20:05', '2022-01-28 18:20:05', 'LABIPHARM', 'Aguilar batres 48-2 zona 11 Guatemala-Guatemala'), (6, 'Edgar Josue Gomez', '40559043', '57587110', 'sales mineral', NULL, NULL, '2022-01-28 18:22:13', '2022-01-28 18:22:13', 'incovet', 'guatemala'), (7, 'DISPOAGRO', '49598574', NULL, 'BRONCO PLUS \r\nSOCO STOP\r\nNEOMIN PET \r\nOXIBIOL \r\nSHARPEY \r\nDR, PET', NULL, NULL, '2022-01-28 18:24:23', '2022-01-28 18:24:23', 'DISPOAGRO', NULL), (8, 'EDYN SOSA', '49591326', NULL, 'PACAS DE HENO', NULL, NULL, '2022-01-28 20:57:47', '2022-01-28 20:57:47', 'PACAS DE HENO', NULL), (9, 'INTER CHEMBIO', '111111111', NULL, NULL, NULL, '2022-07-05 17:19:48', '2022-03-05 16:02:15', '2022-07-05 17:19:48', 'INTERCHEMBIO', 'GUATEMALA'), (10, 'LABI PHARM', '111111', NULL, NULL, NULL, '2022-07-05 17:20:09', '2022-03-05 16:03:06', '2022-07-05 17:20:09', 'LABIPHARM', 'GUATEMALA'), (11, 'VETPHARM', '11111', NULL, NULL, NULL, NULL, '2022-03-05 16:03:39', '2022-03-05 16:03:39', 'VETPHARM', 'GUATEMALA'), (12, 'PRO VET', '111111111', NULL, NULL, NULL, NULL, '2022-03-21 15:50:03', '2022-03-21 15:50:03', 'PROVET', 'GUATEMALA'), (13, 'KAREN ROMERO', '23084042', NULL, 'VITEL,AVIZINA, TRIMSULFA,AVINTIL, VITEL MLT, ELECTRODITOS', NULL, NULL, '2022-07-04 23:12:48', '2022-07-04 23:12:48', 'AVEINDUSTRIAS S.A.', NULL), (14, 'Ermelindo incovet', '41546669', NULL, 'sales minerales', NULL, NULL, '2022-07-05 17:15:05', '2022-07-05 17:15:05', 'Incovet', NULL), (15, 'Guillermo Agrovet', '31988796', NULL, 'tidosin \r\npanacur', NULL, NULL, '2022-07-05 17:18:00', '2022-07-05 17:18:00', 'Agrovet', NULL), (16, 'Mario Tello', '41055038', NULL, 'comederos y bederos', NULL, NULL, '2022-07-05 17:43:34', '2022-07-05 17:43:34', 'Agrosafari', 'z9. avenida 6-45 zona 9'), (17, 'Fernando Catalan', '42184717', NULL, 'comederos cubeta \r\nbebederos tapa amarilla de galon y medio \r\nbebederos amarillos con negro y naranja', NULL, NULL, '2022-07-06 15:20:40', '2022-07-06 15:20:40', 'Sistemas Agropecuarios S.a', NULL), (18, 'stalyn bernardo merida', '55534084', '50173007', 'creciengordina \r\nbio nova 2\r\nbio nova 3\r\npeet master \r\ndogui', NULL, NULL, '2022-07-07 16:24:10', '2022-07-07 16:24:10', 'Distribuidora molina', 'malacatancito'); -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `roles` -- CREATE TABLE `roles` ( `id` bigint(20) UNSIGNED NOT NULL, `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `short_code` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Volcado de datos para la tabla `roles` -- INSERT INTO `roles` (`id`, `title`, `short_code`, `created_at`, `updated_at`) VALUES (1, 'Administrator', 'Admin', '2022-01-24 23:35:32', '2022-01-24 23:35:32'), (2, 'User', NULL, '2022-01-24 23:35:32', '2022-01-24 23:35:32'), (3, 'VENDEDOR', 'VENDEDOR', '2022-02-01 00:31:53', '2022-02-01 00:31:53'); -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `role_permissions` -- CREATE TABLE `role_permissions` ( `role_id` bigint(20) UNSIGNED NOT NULL, `permission_id` bigint(20) UNSIGNED NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Volcado de datos para la tabla `role_permissions` -- INSERT INTO `role_permissions` (`role_id`, `permission_id`) VALUES (1, 1), (1, 2), (1, 3), (1, 4), (1, 5), (1, 6), (1, 7), (1, 8), (1, 9), (1, 10), (1, 11), (1, 12), (1, 13), (1, 14), (1, 15), (1, 16), (1, 17), (1, 18), (1, 19), (1, 20), (1, 21), (1, 22), (1, 23), (1, 24), (1, 25), (1, 26), (1, 27), (1, 28), (1, 29), (1, 30), (1, 31), (1, 32), (1, 33), (1, 34), (1, 35), (1, 36), (1, 37), (1, 38), (1, 39), (1, 40), (1, 41), (1, 42), (1, 43), (1, 44), (1, 45), (1, 46), (1, 47), (1, 48), (1, 49), (1, 50), (1, 51), (1, 52), (2, 1), (2, 2), (3, 1), (3, 16), (3, 18), (3, 20), (3, 22), (3, 25), (3, 26), (3, 28), (3, 29), (3, 30), (3, 31), (3, 33), (3, 34), (3, 35), (3, 36), (3, 37), (3, 40), (3, 41), (3, 42); -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `trakings` -- CREATE TABLE `trakings` ( `id` bigint(20) UNSIGNED NOT NULL, `descripcion` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `traking` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `precio` double(8,2) NOT NULL, `estado` tinyint(1) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `users` -- CREATE TABLE `users` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `telefono` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `horario` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `email_verified_at` timestamp NULL DEFAULT NULL, `password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `role_id` bigint(20) UNSIGNED DEFAULT NULL, `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Volcado de datos para la tabla `users` -- INSERT INTO `users` (`id`, `name`, `email`, `telefono`, `horario`, `email_verified_at`, `password`, `role_id`, `remember_token`, `deleted_at`, `created_at`, `updated_at`) VALUES (1, 'Ariel Jonatan Ramirez Lopez', 'ariel12jona@gmail.com', NULL, NULL, NULL, '$2y$10$CO6de3uTidyfUaMN7DhS9uFrxKhX.1aI.JMNNaPcyzZLWJrjnYK2S', 1, NULL, NULL, '2022-01-24 23:35:32', '2022-01-24 23:35:32'), (2, 'Ariel Ramirez', 'ariel20jona@gmail.com', NULL, NULL, NULL, '$2y$10$VxzyR6CYSukJ9fV3WbajhefK/HEm32NpqBmGMSLLTqEd9NiWZfEBm', 2, NULL, NULL, '2022-01-24 23:35:33', '2022-01-24 23:35:33'), (3, 'Guillermo', 'guillermo@gmail.com', NULL, NULL, NULL, '$2y$10$DSuFiuSSm.ri/ZnQPBMXf.zu0kBQKGa5Pz27i.4t4zcDoqi8kO/5i', 1, NULL, NULL, '2022-01-24 23:38:12', '2022-01-24 23:38:12'), (4, 'LUIS VILLATORO', 'chencho22@hotmail.com', NULL, NULL, NULL, '$2y$10$UgnOxyBCxai1rly0JMp4X.dBOLB/D3PZVc0sgSHbMEQenljB9ISaK', 3, NULL, NULL, '2022-02-01 00:31:23', '2022-02-01 00:42:56'); -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `venta_articulos` -- CREATE TABLE `venta_articulos` ( `id` bigint(20) UNSIGNED NOT NULL, `articulo_id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) UNSIGNED NOT NULL, `cliente_id` bigint(20) UNSIGNED NOT NULL, `factura_id` bigint(20) UNSIGNED NOT NULL, `credito` char(10) COLLATE utf8mb4_unicode_ci NOT NULL, `cantidad` double NOT NULL, `total` double NOT NULL, `descuento` double NOT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Volcado de datos para la tabla `venta_articulos` -- INSERT INTO `venta_articulos` (`id`, `articulo_id`, `user_id`, `cliente_id`, `factura_id`, `credito`, `cantidad`, `total`, `descuento`, `deleted_at`, `created_at`, `updated_at`) VALUES (1, 19, 1, 14, 1, '0', 5, 1100, 25, NULL, '2022-01-25 17:10:47', '2022-01-25 17:10:47'), (2, 11, 1, 14, 2, '0', 1, 135, 0, NULL, '2022-01-28 19:17:59', '2022-01-28 19:17:59'), (3, 30, 3, 14, 3, '0', 15, 375, 0, NULL, '2022-02-01 00:21:50', '2022-02-01 00:21:50'), (6, 13, 3, 14, 6, '0', 1, 255, 0, NULL, '2022-07-04 23:26:55', '2022-07-04 23:26:55'), (7, 1, 3, 14, 7, '0', 1, 285, 0, NULL, '2022-07-04 23:32:32', '2022-07-04 23:32:32'), (8, 18, 3, 14, 7, '0', 1, 275, 0, NULL, '2022-07-04 23:32:32', '2022-07-04 23:32:32'), (9, 11, 3, 14, 7, '0', 1, 155, 0, NULL, '2022-07-04 23:32:32', '2022-07-04 23:32:32'), (10, 14, 3, 14, 7, '0', 1, 250, 0, NULL, '2022-07-04 23:32:32', '2022-07-04 23:32:32'), (11, 8, 3, 14, 7, '0', 1, 230, 0, NULL, '2022-07-04 23:32:32', '2022-07-04 23:32:32'), (12, 8, 3, 14, 7, '0', 1, 230, 0, NULL, '2022-07-04 23:32:32', '2022-07-04 23:32:32'), (13, 8, 3, 14, 7, '0', 1, 230, 0, NULL, '2022-07-04 23:32:32', '2022-07-04 23:32:32'), (14, 13, 3, 14, 8, '0', 1, 245, 10, NULL, '2022-07-05 12:55:42', '2022-07-05 12:55:42'), (15, 1, 3, 14, 9, '0', 1, 275, 10, NULL, '2022-07-05 14:02:11', '2022-07-05 14:02:11'), (16, 1, 3, 14, 9, '0', 1, 275, 10, NULL, '2022-07-05 14:02:11', '2022-07-05 14:02:11'), (17, 1, 3, 14, 9, '0', 1, 275, 10, NULL, '2022-07-05 14:02:11', '2022-07-05 14:02:11'), (18, 1, 3, 14, 9, '0', 1, 275, 10, NULL, '2022-07-05 14:02:11', '2022-07-05 14:02:11'), (19, 1, 3, 14, 10, '0', 1, 278, 7, NULL, '2022-07-05 16:01:58', '2022-07-05 16:01:58'), (20, 11, 3, 14, 11, '0', 1, 147, 8, NULL, '2022-07-05 16:37:03', '2022-07-05 16:37:03'), (21, 11, 3, 14, 11, '0', 1, 147, 8, NULL, '2022-07-05 16:37:03', '2022-07-05 16:37:03'), (22, 11, 3, 14, 11, '0', 1, 147, 8, NULL, '2022-07-05 16:37:03', '2022-07-05 16:37:03'), (23, 11, 3, 14, 11, '0', 1, 147, 8, NULL, '2022-07-05 16:37:03', '2022-07-05 16:37:03'), (24, 11, 3, 14, 11, '0', 1, 147, 8, NULL, '2022-07-05 16:37:03', '2022-07-05 16:37:03'), (25, 11, 3, 14, 11, '0', 1, 147, 8, NULL, '2022-07-05 16:37:03', '2022-07-05 16:37:03'), (26, 11, 3, 14, 11, '0', 1, 147, 8, NULL, '2022-07-05 16:37:03', '2022-07-05 16:37:03'), (27, 11, 3, 14, 11, '0', 1, 147, 8, NULL, '2022-07-05 16:37:03', '2022-07-05 16:37:03'), (28, 11, 3, 14, 11, '0', 1, 147, 8, NULL, '2022-07-05 16:37:03', '2022-07-05 16:37:03'), (29, 123, 3, 14, 12, '0', 1, 55, 30, NULL, '2022-07-05 18:25:35', '2022-07-05 18:25:35'), (30, 165, 3, 14, 13, '0', 1, 2, 0, NULL, '2022-07-05 18:52:59', '2022-07-05 18:52:59'), (31, 165, 3, 14, 13, '0', 1, 2, 0, NULL, '2022-07-05 18:52:59', '2022-07-05 18:52:59'), (32, 165, 3, 14, 13, '0', 1, 2, 0, NULL, '2022-07-05 18:52:59', '2022-07-05 18:52:59'), (33, 165, 3, 14, 13, '0', 1, 2, 0, NULL, '2022-07-05 18:52:59', '2022-07-05 18:52:59'), (34, 147, 3, 14, 13, '0', 1, 20, 0, NULL, '2022-07-05 18:52:59', '2022-07-05 18:52:59'), (35, 7, 3, 14, 14, '0', 1, 240, 5, NULL, '2022-07-05 19:24:16', '2022-07-05 19:24:16'), (36, 7, 3, 14, 14, '0', 1, 240, 5, NULL, '2022-07-05 19:24:16', '2022-07-05 19:24:16'), (37, 7, 3, 14, 14, '0', 1, 240, 5, NULL, '2022-07-05 19:24:16', '2022-07-05 19:24:16'), (38, 13, 3, 14, 15, '0', 1, 250, 5, NULL, '2022-07-05 19:25:12', '2022-07-05 19:25:12'), (39, 128, 3, 14, 16, '0', 1, 80, 0, NULL, '2022-07-05 20:28:11', '2022-07-05 20:28:11'), (40, 1, 3, 14, 16, '0', 1, 285, 0, NULL, '2022-07-05 20:28:11', '2022-07-05 20:28:11'), (41, 12, 3, 14, 16, '0', 1, 180, 0, NULL, '2022-07-05 20:28:11', '2022-07-05 20:28:11'), (42, 14, 3, 14, 16, '0', 1, 245, 5, NULL, '2022-07-05 20:28:11', '2022-07-05 20:28:11'), (43, 123, 3, 14, 16, '0', 1, 85, 0, NULL, '2022-07-05 20:28:11', '2022-07-05 20:28:11'), (44, 22, 3, 14, 17, '0', 1, 195, 0, NULL, '2022-07-05 21:45:25', '2022-07-05 21:45:25'), (45, 13, 3, 14, 17, '0', 1, 255, 0, NULL, '2022-07-05 21:45:25', '2022-07-05 21:45:25'), (46, 1, 3, 14, 17, '0', 1, 280, 5, NULL, '2022-07-05 21:45:25', '2022-07-05 21:45:25'), (47, 1, 3, 14, 17, '0', 1, 280, 5, NULL, '2022-07-05 21:45:25', '2022-07-05 21:45:25'), (48, 1, 3, 14, 17, '0', 1, 280, 5, NULL, '2022-07-05 21:45:25', '2022-07-05 21:45:25'), (49, 1, 3, 14, 17, '0', 1, 280, 5, NULL, '2022-07-05 21:45:25', '2022-07-05 21:45:25'), (50, 13, 3, 14, 18, '0', 1, 255, 0, NULL, '2022-07-06 12:47:59', '2022-07-06 12:47:59'), (51, 13, 3, 14, 18, '0', 1, 255, 0, NULL, '2022-07-06 12:47:59', '2022-07-06 12:47:59'), (52, 161, 3, 14, 19, '0', 1, 15, 0, NULL, '2022-07-06 12:55:02', '2022-07-06 12:55:02'), (53, 161, 3, 14, 19, '0', 1, 15, 0, NULL, '2022-07-06 12:55:02', '2022-07-06 12:55:02'), (54, 20, 3, 14, 19, '0', 1, 325, 5, NULL, '2022-07-06 12:55:02', '2022-07-06 12:55:02'), (55, 139, 3, 14, 20, '0', 1, 15, 0, NULL, '2022-07-06 13:00:40', '2022-07-06 13:00:40'), (56, 14, 3, 14, 21, '0', 1, 250, 0, NULL, '2022-07-06 13:23:46', '2022-07-06 13:23:46'), (57, 41, 3, 14, 22, '0', 1, 55, 0, NULL, '2022-07-06 14:17:23', '2022-07-06 14:17:23'), (58, 100, 3, 14, 23, '0', 1, 45, 0, NULL, '2022-07-06 14:37:34', '2022-07-06 14:37:34'), (59, 100, 3, 14, 24, '0', 1, 45, 0, NULL, '2022-07-06 14:52:00', '2022-07-06 14:52:00'), (60, 14, 3, 14, 25, '0', 1, 240, 10, NULL, '2022-07-06 15:48:21', '2022-07-06 15:48:21'), (61, 36, 3, 14, 26, '0', 1, 15, 0, NULL, '2022-07-06 18:25:52', '2022-07-06 18:25:52'), (62, 36, 3, 14, 26, '0', 1, 15, 0, NULL, '2022-07-06 18:25:52', '2022-07-06 18:25:52'), (63, 13, 3, 14, 27, '0', 1, 245, 10, NULL, '2022-07-06 18:50:30', '2022-07-06 18:50:30'), (64, 13, 3, 14, 27, '0', 1, 245, 10, NULL, '2022-07-06 18:50:30', '2022-07-06 18:50:30'), (65, 11, 3, 14, 27, '0', 1, 148, 7, NULL, '2022-07-06 18:50:30', '2022-07-06 18:50:30'), (66, 11, 3, 14, 27, '0', 1, 148, 7, NULL, '2022-07-06 18:50:30', '2022-07-06 18:50:30'), (67, 11, 3, 14, 27, '0', 1, 148, 7, NULL, '2022-07-06 18:50:30', '2022-07-06 18:50:30'), (68, 11, 3, 14, 27, '0', 1, 148, 7, NULL, '2022-07-06 18:50:30', '2022-07-06 18:50:30'), (69, 11, 3, 14, 27, '0', 1, 148, 7, NULL, '2022-07-06 18:50:30', '2022-07-06 18:50:30'), (70, 11, 3, 14, 27, '0', 1, 148, 7, NULL, '2022-07-06 18:50:30', '2022-07-06 18:50:30'), (71, 11, 3, 14, 27, '0', 1, 148, 7, NULL, '2022-07-06 18:50:30', '2022-07-06 18:50:30'), (72, 11, 3, 14, 27, '0', 1, 148, 7, NULL, '2022-07-06 18:50:30', '2022-07-06 18:50:30'), (73, 11, 3, 14, 27, '0', 1, 148, 7, NULL, '2022-07-06 18:50:30', '2022-07-06 18:50:30'), (74, 11, 3, 14, 27, '0', 1, 148, 7, NULL, '2022-07-06 18:50:30', '2022-07-06 18:50:30'), (75, 1, 3, 14, 28, '0', 1, 279, 6, NULL, '2022-07-06 18:53:36', '2022-07-06 18:53:36'), (76, 14, 3, 14, 29, '0', 1, 240, 10, NULL, '2022-07-06 19:28:26', '2022-07-06 19:28:26'), (77, 14, 3, 14, 30, '0', 1, 240, 10, NULL, '2022-07-06 19:56:37', '2022-07-06 19:56:37'), (78, 14, 3, 14, 30, '0', 1, 240, 10, NULL, '2022-07-06 19:56:37', '2022-07-06 19:56:37'), (79, 14, 3, 14, 31, '0', 1, 245, 5, NULL, '2022-07-06 21:38:30', '2022-07-06 21:38:30'), (80, 6, 3, 14, 32, '0', 1, 195, 0, NULL, '2022-07-06 21:53:00', '2022-07-06 21:53:00'), (81, 32, 3, 14, 33, '0', 1, 15, 0, NULL, '2022-07-06 22:01:49', '2022-07-06 22:01:49'), (82, 9, 3, 40, 34, '0', 1, 185, 5, NULL, '2022-07-07 12:41:05', '2022-07-07 12:41:05'), (83, 112, 3, 42, 35, '0', 1, 37, 0, NULL, '2022-07-07 13:11:18', '2022-07-07 13:11:18'), (84, 42, 3, 16, 36, '0', 1, 40, 0, NULL, '2022-07-07 13:44:43', '2022-07-07 13:44:43'), (85, 13, 3, 16, 36, '0', 1, 245, 10, NULL, '2022-07-07 13:44:43', '2022-07-07 13:44:43'), (86, 145, 3, 14, 38, '0', 1, 30, 0, NULL, '2022-07-07 13:58:46', '2022-07-07 13:58:46'), (87, 157, 3, 43, 39, '0', 1, 45, 0, NULL, '2022-07-07 14:33:13', '2022-07-07 14:33:13'), (88, 157, 3, 43, 39, '0', 1, 45, 0, NULL, '2022-07-07 14:33:13', '2022-07-07 14:33:13'), (89, 98, 3, 14, 40, '0', 1, 35, 0, NULL, '2022-07-07 15:18:25', '2022-07-07 15:18:25'), (90, 14, 3, 45, 41, '0', 1, 245, 5, NULL, '2022-07-07 16:27:46', '2022-07-07 16:27:46'), (91, 13, 3, 24, 42, '0', 1, 250, 5, NULL, '2022-07-07 18:28:23', '2022-07-07 18:28:23'), (92, 10, 3, 24, 42, '0', 1, 197, 8, NULL, '2022-07-07 18:28:23', '2022-07-07 18:28:23'), (93, 1, 3, 34, 43, '0', 1, 278, 7, NULL, '2022-07-07 18:51:40', '2022-07-07 18:51:40'), (94, 10, 3, 14, 44, '0', 1, 200, 5, NULL, '2022-07-07 19:02:13', '2022-07-07 19:02:13'), (95, 56, 3, 14, 45, '0', 1, 35, 0, NULL, '2022-07-07 19:08:03', '2022-07-07 19:08:03'), (96, 149, 3, 14, 46, '0', 1, 25, 0, NULL, '2022-07-07 19:28:32', '2022-07-07 19:28:32'), (97, 143, 3, 14, 46, '0', 1, 90, 0, NULL, '2022-07-07 19:28:32', '2022-07-07 19:28:32'), (98, 14, 3, 14, 46, '0', 1, 240, 10, NULL, '2022-07-07 19:28:32', '2022-07-07 19:28:32'), (99, 13, 3, 14, 46, '0', 1, 255, 0, NULL, '2022-07-07 19:28:32', '2022-07-07 19:28:32'), (100, 12, 3, 14, 47, '0', 1, 180, 0, NULL, '2022-07-07 20:06:00', '2022-07-07 20:06:00'), (101, 14, 3, 16, 48, '0', 1, 240, 10, NULL, '2022-07-07 20:14:22', '2022-07-07 20:14:22'), (102, 2, 3, 47, 49, '0', 1, 285, 0, NULL, '2022-07-07 20:35:01', '2022-07-07 20:35:01'), (103, 1, 3, 47, 49, '0', 1, 285, 0, NULL, '2022-07-07 20:35:01', '2022-07-07 20:35:01'), (104, 116, 3, 48, 50, '0', 1, 70, 3, NULL, '2022-07-07 21:22:02', '2022-07-07 21:22:02'), (105, 47, 3, 48, 50, '0', 1, 70, 0, NULL, '2022-07-07 21:22:02', '2022-07-07 21:22:02'), (106, 14, 3, 14, 51, '0', 1, 250, 0, NULL, '2022-07-07 21:25:15', '2022-07-07 21:25:15'), (107, 156, 3, 14, 52, '0', 1, 40, 0, NULL, '2022-07-08 12:52:30', '2022-07-08 12:52:30'), (108, 145, 3, 14, 53, '0', 1, 30, 0, NULL, '2022-07-08 13:40:33', '2022-07-08 13:40:33'), (109, 22, 3, 14, 53, '0', 1, 195, 0, NULL, '2022-07-08 13:40:33', '2022-07-08 13:40:33'), (110, 12, 3, 14, 53, '0', 1, 180, 0, NULL, '2022-07-08 13:40:33', '2022-07-08 13:40:33'), (111, 57, 3, 14, 53, '0', 1, 20, 0, NULL, '2022-07-08 13:40:33', '2022-07-08 13:40:33'), (112, 57, 3, 14, 53, '0', 1, 20, 0, NULL, '2022-07-08 13:40:33', '2022-07-08 13:40:33'), (113, 145, 3, 14, 53, '0', 1, 30, 0, NULL, '2022-07-08 13:40:33', '2022-07-08 13:40:33'), (114, 134, 3, 14, 56, '0', 1, 2, 0, NULL, '2022-07-08 14:39:42', '2022-07-08 14:39:42'), (115, 134, 3, 14, 56, '0', 1, 2, 0, NULL, '2022-07-08 14:39:42', '2022-07-08 14:39:42'), (116, 134, 3, 14, 56, '0', 1, 2, 0, NULL, '2022-07-08 14:39:42', '2022-07-08 14:39:42'), (117, 134, 3, 14, 56, '0', 1, 2, 0, NULL, '2022-07-08 14:39:42', '2022-07-08 14:39:42'), (118, 134, 3, 14, 56, '0', 1, 2, 0, NULL, '2022-07-08 14:39:42', '2022-07-08 14:39:42'), (119, 134, 3, 14, 56, '0', 1, 2, 0, NULL, '2022-07-08 14:39:42', '2022-07-08 14:39:42'), (120, 134, 3, 14, 56, '0', 1, 2, 0, NULL, '2022-07-08 14:39:42', '2022-07-08 14:39:42'), (121, 134, 3, 14, 56, '0', 1, 2, 0, NULL, '2022-07-08 14:39:42', '2022-07-08 14:39:42'), (122, 134, 3, 14, 56, '0', 1, 2, 0, NULL, '2022-07-08 14:39:42', '2022-07-08 14:39:42'), (123, 134, 3, 14, 56, '0', 1, 2, 0, NULL, '2022-07-08 14:39:42', '2022-07-08 14:39:42'), (124, 70, 3, 14, 56, '0', 1, 2.5, 0, NULL, '2022-07-08 14:39:42', '2022-07-08 14:39:42'), (125, 70, 3, 14, 56, '0', 1, 2.5, 0, NULL, '2022-07-08 14:39:42', '2022-07-08 14:39:42'), (126, 70, 3, 14, 56, '0', 1, 2.5, 0, NULL, '2022-07-08 14:39:42', '2022-07-08 14:39:42'), (127, 70, 3, 14, 56, '0', 1, 2.5, 0, NULL, '2022-07-08 14:39:42', '2022-07-08 14:39:42'), (128, 70, 3, 14, 56, '0', 1, 2.5, 0, NULL, '2022-07-08 14:39:42', '2022-07-08 14:39:42'), (129, 70, 3, 14, 56, '0', 1, 2.5, 0, NULL, '2022-07-08 14:39:42', '2022-07-08 14:39:42'), (130, 70, 3, 14, 56, '0', 1, 2.5, 0, NULL, '2022-07-08 14:39:42', '2022-07-08 14:39:42'), (131, 70, 3, 14, 56, '0', 1, 2.5, 0, NULL, '2022-07-08 14:39:42', '2022-07-08 14:39:42'), (132, 70, 3, 14, 56, '0', 1, 2.5, 0, NULL, '2022-07-08 14:39:42', '2022-07-08 14:39:42'), (133, 70, 3, 14, 56, '0', 1, 2.5, 0, NULL, '2022-07-08 14:39:42', '2022-07-08 14:39:42'), (134, 133, 3, 14, 56, '0', 1, 1.5, 0.5, NULL, '2022-07-08 14:39:42', '2022-07-08 14:39:42'), (135, 133, 3, 14, 56, '0', 1, 1.5, 0.5, NULL, '2022-07-08 14:39:42', '2022-07-08 14:39:42'), (136, 133, 3, 14, 56, '0', 1, 1.5, 0.5, NULL, '2022-07-08 14:39:42', '2022-07-08 14:39:42'), (137, 133, 3, 14, 56, '0', 1, 1.5, 0.5, NULL, '2022-07-08 14:39:42', '2022-07-08 14:39:42'), (138, 133, 3, 14, 56, '0', 1, 1.5, 0.5, NULL, '2022-07-08 14:39:42', '2022-07-08 14:39:42'), (139, 133, 3, 14, 56, '0', 1, 1.5, 0.5, NULL, '2022-07-08 14:39:42', '2022-07-08 14:39:42'), (140, 133, 3, 14, 56, '0', 1, 1.5, 0.5, NULL, '2022-07-08 14:39:42', '2022-07-08 14:39:42'), (141, 133, 3, 14, 56, '0', 1, 1.5, 0.5, NULL, '2022-07-08 14:39:42', '2022-07-08 14:39:42'), (142, 133, 3, 14, 56, '0', 1, 1.5, 0.5, NULL, '2022-07-08 14:39:42', '2022-07-08 14:39:42'), (143, 133, 3, 14, 56, '0', 1, 1.5, 0.5, NULL, '2022-07-08 14:39:42', '2022-07-08 14:39:42'), (144, 165, 3, 18, 57, '0', 1, 1.5, 0.5, NULL, '2022-07-08 14:42:42', '2022-07-08 14:42:42'), (145, 165, 3, 18, 57, '0', 1, 1.5, 0.5, NULL, '2022-07-08 14:42:42', '2022-07-08 14:42:42'), (146, 165, 3, 18, 57, '0', 1, 1.5, 0.5, NULL, '2022-07-08 14:42:42', '2022-07-08 14:42:42'), (147, 165, 3, 18, 57, '0', 1, 1.5, 0.5, NULL, '2022-07-08 14:42:42', '2022-07-08 14:42:42'), (148, 165, 3, 18, 57, '0', 1, 1.5, 0.5, NULL, '2022-07-08 14:42:42', '2022-07-08 14:42:42'), (149, 165, 3, 18, 57, '0', 1, 1.5, 0.5, NULL, '2022-07-08 14:42:42', '2022-07-08 14:42:42'), (150, 165, 3, 18, 57, '0', 1, 1.5, 0.5, NULL, '2022-07-08 14:42:42', '2022-07-08 14:42:42'), (151, 165, 3, 18, 57, '0', 1, 1.5, 0.5, NULL, '2022-07-08 14:42:42', '2022-07-08 14:42:42'), (152, 165, 3, 18, 57, '0', 1, 1.5, 0.5, NULL, '2022-07-08 14:42:42', '2022-07-08 14:42:42'), (153, 165, 3, 18, 57, '0', 1, 1.5, 0.5, NULL, '2022-07-08 14:42:42', '2022-07-08 14:42:42'), (154, 156, 3, 18, 57, '0', 1, 40, 0, NULL, '2022-07-08 14:42:42', '2022-07-08 14:42:42'), (155, 22, 3, 17, 58, '0', 1, 195, 0, NULL, '2022-07-08 15:43:54', '2022-07-08 15:43:54'), (156, 10, 3, 17, 58, '0', 1, 198, 7, NULL, '2022-07-08 15:43:54', '2022-07-08 15:43:54'), (157, 10, 3, 17, 58, '0', 1, 198, 7, NULL, '2022-07-08 15:43:54', '2022-07-08 15:43:54'), (158, 10, 3, 17, 58, '0', 1, 198, 7, NULL, '2022-07-08 15:43:54', '2022-07-08 15:43:54'), (159, 13, 3, 14, 59, '0', 1, 255, 0, NULL, '2022-07-08 17:29:40', '2022-07-08 17:29:40'), (160, 22, 3, 14, 59, '0', 1, 195, 0, NULL, '2022-07-08 17:29:40', '2022-07-08 17:29:40'), (161, 22, 3, 14, 59, '0', 1, 195, 0, NULL, '2022-07-08 17:29:40', '2022-07-08 17:29:40'), (162, 8, 3, 16, 60, '0', 1, 223, 7, NULL, '2022-07-08 18:45:07', '2022-07-08 18:45:07'), (163, 7, 3, 14, 61, '0', 1, 245, 0, NULL, '2022-07-08 19:18:39', '2022-07-08 19:18:39'), (164, 12, 3, 16, 62, '0', 1, 177, 3, NULL, '2022-07-08 19:20:16', '2022-07-08 19:20:16'), (165, 1, 3, 30, 63, '0', 1, 279, 6, NULL, '2022-07-08 20:00:37', '2022-07-08 20:00:37'), (166, 1, 3, 38, 64, '0', 1, 285, 0, NULL, '2022-07-08 20:18:41', '2022-07-08 20:18:41'), (167, 1, 3, 38, 64, '0', 1, 285, 0, NULL, '2022-07-08 20:18:41', '2022-07-08 20:18:41'), (168, 1, 3, 38, 64, '0', 1, 285, 0, NULL, '2022-07-08 20:18:41', '2022-07-08 20:18:41'), (169, 1, 3, 38, 64, '0', 1, 285, 0, NULL, '2022-07-08 20:18:41', '2022-07-08 20:18:41'), (170, 1, 3, 38, 64, '0', 1, 285, 0, NULL, '2022-07-08 20:18:41', '2022-07-08 20:18:41'), (171, 1, 3, 38, 64, '0', 1, 285, 0, NULL, '2022-07-08 20:18:41', '2022-07-08 20:18:41'), (172, 1, 3, 38, 64, '0', 1, 285, 0, NULL, '2022-07-08 20:18:41', '2022-07-08 20:18:41'), (173, 1, 3, 38, 64, '0', 1, 285, 0, NULL, '2022-07-08 20:18:41', '2022-07-08 20:18:41'), (174, 1, 3, 38, 64, '0', 1, 285, 0, NULL, '2022-07-08 20:18:41', '2022-07-08 20:18:41'), (175, 1, 3, 38, 64, '0', 1, 285, 0, NULL, '2022-07-08 20:18:41', '2022-07-08 20:18:41'), (176, 16, 3, 14, 65, '0', 1, 277, 0, NULL, '2022-07-08 20:19:49', '2022-07-08 20:19:49'), (177, 16, 3, 14, 65, '0', 1, 277, 0, NULL, '2022-07-08 20:19:49', '2022-07-08 20:19:49'), (178, 6, 3, 20, 66, '0', 1, 195, 0, NULL, '2022-07-08 21:10:24', '2022-07-08 21:10:24'), (179, 6, 3, 20, 66, '0', 1, 195, 0, NULL, '2022-07-08 21:10:24', '2022-07-08 21:10:24'), (180, 4, 3, 14, 67, '0', 1, 295, 0, NULL, '2022-07-08 21:12:05', '2022-07-08 21:12:05'), (181, 4, 3, 14, 67, '0', 1, 295, 0, NULL, '2022-07-08 21:12:05', '2022-07-08 21:12:05'), (182, 98, 3, 14, 69, '0', 1, 35, 0, NULL, '2022-07-09 13:19:46', '2022-07-09 13:19:46'), (183, 57, 3, 14, 69, '0', 1, 20, 0, NULL, '2022-07-09 13:19:46', '2022-07-09 13:19:46'), (184, 11, 3, 14, 70, '0', 1, 150, 5, NULL, '2022-07-09 13:26:51', '2022-07-09 13:26:51'), (185, 13, 3, 14, 71, '0', 1, 245, 10, NULL, '2022-07-09 13:47:25', '2022-07-09 13:47:25'), (186, 61, 3, 14, 72, '0', 1, 10, 0, NULL, '2022-07-09 14:25:12', '2022-07-09 14:25:12'), (187, 61, 3, 14, 72, '0', 1, 10, 0, NULL, '2022-07-09 14:25:12', '2022-07-09 14:25:12'), (188, 61, 3, 14, 72, '0', 1, 10, 0, NULL, '2022-07-09 14:25:12', '2022-07-09 14:25:12'), (189, 1, 3, 34, 73, '0', 1, 278, 7, NULL, '2022-07-09 14:51:12', '2022-07-09 14:51:12'), (190, 184, 1, 49, 74, '0', 5, 500, 0, NULL, '2022-07-09 15:17:14', '2022-07-09 15:17:14'), (191, 70, 3, 18, 75, '0', 10, 25, 0, NULL, '2022-07-09 15:28:16', '2022-07-09 15:28:16'), (192, 115, 3, 18, 75, '0', 1, 30, 0, NULL, '2022-07-09 15:28:16', '2022-07-09 15:28:16'), (193, 184, 1, 49, 76, '0', 1, 100, 0, NULL, '2022-07-09 15:38:16', '2022-07-09 15:38:16'), (194, 184, 1, 49, 76, '0', 1, 100, 0, NULL, '2022-07-09 15:38:16', '2022-07-09 15:38:16'), (195, 184, 1, 49, 78, '0', 1, 100, 0, NULL, '2022-07-09 15:38:44', '2022-07-09 15:38:44'), (196, 10, 3, 22, 79, '0', 1, 205, 0, NULL, '2022-07-09 15:38:51', '2022-07-09 15:38:51'), (197, 22, 3, 22, 79, '0', 1, 195, 0, NULL, '2022-07-09 15:38:51', '2022-07-09 15:38:51'), (198, 14, 3, 22, 79, '0', 1, 240, 10, NULL, '2022-07-09 15:38:51', '2022-07-09 15:38:51'), (199, 7, 3, 22, 79, '0', 6, 1290, 180, NULL, '2022-07-09 15:38:51', '2022-07-09 15:38:51'), (200, 184, 1, 49, 80, '0', 1, 100, 0, NULL, '2022-07-09 15:43:49', '2022-07-09 15:43:49'), (201, 14, 3, 37, 81, '0', 1, 245, 5, NULL, '2022-07-09 16:11:24', '2022-07-09 16:11:24'), (202, 3, 3, 14, 82, '0', 1, 295, 0, NULL, '2022-07-09 16:50:03', '2022-07-09 16:50:03'), (203, 1, 3, 14, 82, '0', 35, 9975, 0, NULL, '2022-07-09 16:50:03', '2022-07-09 16:50:03'); -- -- Disparadores `venta_articulos` -- DELIMITER $$ CREATE TRIGGER `venta_articulos_after_insert` AFTER INSERT ON `venta_articulos` FOR EACH ROW BEGIN UPDATE articulos SET stock = stock - NEW.cantidad WHERE articulos.id =NEW.articulo_id; END $$ DELIMITER ; -- -- Índices para tablas volcadas -- -- -- Indices de la tabla `abonos_proveedores` -- ALTER TABLE `abonos_proveedores` ADD PRIMARY KEY (`id`), ADD KEY `abonos_proveedores_proveedor_id_foreign` (`proveedor_id`); -- -- Indices de la tabla `abono_clientes` -- ALTER TABLE `abono_clientes` ADD PRIMARY KEY (`id`), ADD KEY `abono_clientes_cliente_id_foreign` (`cliente_id`); -- -- Indices de la tabla `articulos` -- ALTER TABLE `articulos` ADD PRIMARY KEY (`id`), ADD KEY `articulos_categoria_id_foreign` (`categoria_id`), ADD KEY `articulos_proveedor_id_foreign` (`proveedor_id`); -- -- Indices de la tabla `articulos_catalogo` -- ALTER TABLE `articulos_catalogo` ADD PRIMARY KEY (`id`); -- -- Indices de la tabla `caja` -- ALTER TABLE `caja` ADD PRIMARY KEY (`id`); -- -- Indices de la tabla `categoria` -- ALTER TABLE `categoria` ADD PRIMARY KEY (`id`); -- -- Indices de la tabla `clientes` -- ALTER TABLE `clientes` ADD PRIMARY KEY (`id`); -- -- Indices de la tabla `compra_articulos` -- ALTER TABLE `compra_articulos` ADD PRIMARY KEY (`id`), ADD KEY `compra_articulos_articulo_id_foreign` (`articulo_id`), ADD KEY `compra_articulos_user_id_foreign` (`user_id`); -- -- Indices de la tabla `compra_proveedores` -- ALTER TABLE `compra_proveedores` ADD PRIMARY KEY (`id`), ADD KEY `compra_proveedores_proveedor_id_foreign` (`proveedor_id`), ADD KEY `compra_proveedores_articulo_id_foreign` (`articulo_id`); -- -- Indices de la tabla `cotizacion` -- ALTER TABLE `cotizacion` ADD PRIMARY KEY (`id`), ADD KEY `cotizacion_articulo_id_foreign` (`articulo_id`); -- -- Indices de la tabla `cuadre` -- ALTER TABLE `cuadre` ADD PRIMARY KEY (`id`), ADD KEY `cuadre_user_id_foreign` (`user_id`); -- -- Indices de la tabla `deuda_cliente` -- ALTER TABLE `deuda_cliente` ADD PRIMARY KEY (`id`), ADD KEY `deuda_cliente_cliente_id_foreign` (`cliente_id`); -- -- Indices de la tabla `facturas` -- ALTER TABLE `facturas` ADD PRIMARY KEY (`id`); -- -- Indices de la tabla `facturas_proveedor` -- ALTER TABLE `facturas_proveedor` ADD PRIMARY KEY (`id`), ADD KEY `facturas_proveedor_proveedor_id_foreign` (`proveedor_id`); -- -- Indices de la tabla `migrations` -- ALTER TABLE `migrations` ADD PRIMARY KEY (`id`); -- -- Indices de la tabla `password_resets` -- ALTER TABLE `password_resets` ADD KEY `password_resets_email_index` (`email`); -- -- Indices de la tabla `permissions` -- ALTER TABLE `permissions` ADD PRIMARY KEY (`id`); -- -- Indices de la tabla `proveedores` -- ALTER TABLE `proveedores` ADD PRIMARY KEY (`id`); -- -- Indices de la tabla `roles` -- ALTER TABLE `roles` ADD PRIMARY KEY (`id`); -- -- Indices de la tabla `role_permissions` -- ALTER TABLE `role_permissions` ADD KEY `role_permissions_role_id_foreign` (`role_id`), ADD KEY `role_permissions_permission_id_foreign` (`permission_id`); -- -- Indices de la tabla `trakings` -- ALTER TABLE `trakings` ADD PRIMARY KEY (`id`); -- -- Indices de la tabla `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `users_email_unique` (`email`), ADD KEY `users_role_id_foreign` (`role_id`); -- -- Indices de la tabla `venta_articulos` -- ALTER TABLE `venta_articulos` ADD PRIMARY KEY (`id`), ADD KEY `venta_articulos_articulo_id_foreign` (`articulo_id`), ADD KEY `venta_articulos_user_id_foreign` (`user_id`), ADD KEY `venta_articulos_cliente_id_foreign` (`cliente_id`), ADD KEY `venta_articulos_factura_id_foreign` (`factura_id`); -- -- AUTO_INCREMENT de las tablas volcadas -- -- -- AUTO_INCREMENT de la tabla `abonos_proveedores` -- ALTER TABLE `abonos_proveedores` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT de la tabla `abono_clientes` -- ALTER TABLE `abono_clientes` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10; -- -- AUTO_INCREMENT de la tabla `articulos` -- ALTER TABLE `articulos` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=187; -- -- AUTO_INCREMENT de la tabla `articulos_catalogo` -- ALTER TABLE `articulos_catalogo` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT de la tabla `caja` -- ALTER TABLE `caja` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=37; -- -- AUTO_INCREMENT de la tabla `categoria` -- ALTER TABLE `categoria` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT de la tabla `clientes` -- ALTER TABLE `clientes` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=50; -- -- AUTO_INCREMENT de la tabla `compra_articulos` -- ALTER TABLE `compra_articulos` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17; -- -- AUTO_INCREMENT de la tabla `compra_proveedores` -- ALTER TABLE `compra_proveedores` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17; -- -- AUTO_INCREMENT de la tabla `cotizacion` -- ALTER TABLE `cotizacion` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT de la tabla `cuadre` -- ALTER TABLE `cuadre` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT de la tabla `deuda_cliente` -- ALTER TABLE `deuda_cliente` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26; -- -- AUTO_INCREMENT de la tabla `facturas` -- ALTER TABLE `facturas` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=83; -- -- AUTO_INCREMENT de la tabla `facturas_proveedor` -- ALTER TABLE `facturas_proveedor` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9; -- -- AUTO_INCREMENT de la tabla `migrations` -- ALTER TABLE `migrations` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=35; -- -- AUTO_INCREMENT de la tabla `permissions` -- ALTER TABLE `permissions` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=53; -- -- AUTO_INCREMENT de la tabla `proveedores` -- ALTER TABLE `proveedores` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19; -- -- AUTO_INCREMENT de la tabla `roles` -- ALTER TABLE `roles` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT de la tabla `trakings` -- ALTER TABLE `trakings` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT de la tabla `users` -- ALTER TABLE `users` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT de la tabla `venta_articulos` -- ALTER TABLE `venta_articulos` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=204; COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;