-- https://www.phpmyadmin.net/
--
-- Servidor: 127.0.0.1:3306
-- Tiempo de generación: 12-12-2023 a las 03:16:41
-- Versión del servidor: 10.6.12-MariaDB-cll-lve
-- Versión de PHP: 7.2.34

START TRANSACTION;



--
-- Base de datos: `u512100539_jonte`
--

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

--
-- Estructura de tabla para la tabla `categorias`
--

CREATE TABLE `categorias` (
  `id` int(11) NOT NULL,
  `categoria` text NOT NULL,
  `fecha` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_spanish_ci;

--
-- Volcado de datos para la tabla `categorias`
--

INSERT INTO `categorias` (`id`, `categoria`, `fecha`) VALUES
(1, 'Colgantes > Cadenas, Colgantes', '2023-12-11 03:14:25'),
(2, 'Colgantes, Colgantes > Cordones infantiles', '2023-12-11 03:14:25'),
(3, 'Fornitura, Fornitura > Plaquetas', '2023-12-11 03:14:25'),
(4, 'Colgantes, Sin categorizar, Colgantes > Sujetador elástico', '2023-12-11 03:14:25'),
(5, 'Colgantes, Colgantes > Sujetador elástico', '2023-12-11 03:14:25'),
(6, 'Colgantes, Colgantes > Sujetadores envolventes', '2023-12-11 03:14:25'),
(7, 'Colgantes, Colgantes > Sujetadores regulables', '2023-12-11 03:14:25'),
(8, 'Colgantes, Colgantes > Cordones comunes', '2023-12-11 03:14:25'),
(9, 'Colgantes, Colgantes > Cordones especiales', '2023-12-11 03:14:25'),
(10, 'Estuches, Estuches > Estuches lentes de contacto, Limpia cristales / paños arlyt, Limpia cristales / paños arlyt > Líquidos ARLYT contactologia', '2023-12-11 03:14:25'),
(11, 'Estuches, Estuches > Porta lentes', '2023-12-11 03:14:25'),
(12, 'Estuches, Estuches > Estuches para anteojos', '2023-12-11 03:14:25'),
(13, 'Taller / Accesorios', '2023-12-11 03:14:25'),
(14, 'Equipos y Herramientas, Taller / Accesorios', '2023-12-11 03:14:25'),
(15, 'Fornitura > Bisagras, Fornitura', '2023-12-11 03:14:25'),
(16, 'Fornitura, Fornitura > Tornillos', '2023-12-11 03:14:25'),
(17, 'Fornitura, Fornitura > Terminales', '2023-12-11 03:14:25'),
(18, 'Limpia cristales / paños arlyt, Limpia cristales / paños arlyt > Paños', '2023-12-11 03:14:25'),
(19, 'Limpia cristales / paños arlyt, Limpia cristales / paños arlyt > Limpiadores', '2023-12-11 03:14:25'),
(20, 'Equipos y Herramientas', '2023-12-11 03:14:25'),
(21, 'Cristales', '2023-12-11 03:14:25'),
(22, 'Fornitura, Fornitura > Patillas', '2023-12-11 03:14:25'),
(23, 'Fornitura, Fornitura > Vainas', '2023-12-11 03:14:25'),
(24, 'Fornitura, Fornitura > Puentes', '2023-12-11 03:14:25');

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

--
-- Estructura de tabla para la tabla `clientes`
--

CREATE TABLE `clientes` (
  `id` int(11) NOT NULL,
  `nombre` text NOT NULL,
  `documento` int(11) NOT NULL,
  `email` text NOT NULL,
  `telefono` text NOT NULL,
  `direccion` text NOT NULL,
  `fecha_nacimiento` date NOT NULL,
  `compras` int(11) NOT NULL,
  `ultima_compra` datetime NOT NULL,
  `fecha` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `condiva` varchar(2) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_spanish_ci;

--
-- Volcado de datos para la tabla `clientes`
--

INSERT INTO `clientes` (`id`, `nombre`, `documento`, `email`, `telefono`, `direccion`, `fecha_nacimiento`, `compras`, `ultima_compra`, `fecha`, `condiva`) VALUES
(1, 'Viviana Monica Bugdahl', 1, 'optica@bugdahl.com.ar', '0', '', '2023-12-11', 1, '0000-00-00 00:00:00', '2023-12-11 03:46:16', 'RI'),
(2, 'Rocio Fredes', 1, 'rofredes0@gmail.com', '0', '', '2023-12-11', 1, '0000-00-00 00:00:00', '2023-12-11 03:46:16', 'RI'),
(3, 'Roberto Paez', 1, 'opticasantarita_mdq@hotmail.com', '0', '', '2023-12-11', 1, '0000-00-00 00:00:00', '2023-12-11 03:46:16', 'RI'),
(4, 'JUAN PABLO DAGOSTINO', 1, 'opticadagostino@hotmail.com', '0', '', '2023-12-11', 1, '0000-00-00 00:00:00', '2023-12-11 03:46:16', 'RI'),
(5, 'José maria Williams', 1, 'josemawilliams@gmail.com', '0', '', '2023-12-11', 2, '0000-00-00 00:00:00', '2023-12-11 03:46:16', 'RI'),
(6, 'Carolina Dalmasso', 1, 'carod_301@hotmail.com', '0', '', '2023-12-11', 1, '0000-00-00 00:00:00', '2023-12-11 03:46:16', 'RI'),
(7, 'Guido Tomaselli', 1, 'opticacristalvillegas@gmail.com', '0', '', '2023-12-11', 1, '0000-00-00 00:00:00', '2023-12-11 03:46:16', 'RI'),
(8, 'bernardo hubner', 1, 'hubner@arnet.com.ar', '0', '', '2023-12-11', 1, '0000-00-00 00:00:00', '2023-12-11 03:46:16', 'RI'),
(9, 'MARIA EUFGENIA GALVAN', 1, 'mariaeuge2004@hotmail.com', '0', '', '2023-12-11', 1, '0000-00-00 00:00:00', '2023-12-11 03:46:17', 'RI'),
(10, 'Luciano Agostinelli', 1, 'opticagalv@gmail.com', '0', '', '2023-12-11', 1, '0000-00-00 00:00:00', '2023-12-11 03:46:17', 'RI'),
(11, 'maria alejandra suberbie', 1, 'loa_areco@hotmail.com', '0', '', '2023-12-11', 1, '0000-00-00 00:00:00', '2023-12-11 03:46:17', 'RI'),
(12, 'javier arceo', 1, 'silvanadominguez5@gmail.com', '0', '', '2023-12-11', 1, '0000-00-00 00:00:00', '2023-12-11 03:46:17', 'RI'),
(13, 'marcelamanzotti manzotti', 1, 'manzottimonica@hotmail.com', '0', '', '2023-12-11', 1, '0000-00-00 00:00:00', '2023-12-11 03:46:17', 'RI'),
(14, 'Marina Sanchez Tuculet', 1, 'marinasancheztuculet@hotmail.com', '0', '', '2023-12-11', 1, '0000-00-00 00:00:00', '2023-12-11 03:46:17', 'RI'),
(15, 'Mariano Portillo', 1, 'opticaoriens@outlook.com', '0', '', '2023-12-11', 1, '0000-00-00 00:00:00', '2023-12-11 03:46:17', 'RI'),
(16, 'CONCEPT VISION SRL', 1, 'opticasocialgarin@gmail.com', '0', '', '2023-12-11', 1, '0000-00-00 00:00:00', '2023-12-11 03:46:17', 'RI'),
(17, 'Marcos Casado', 1, 'mo_casado@yahoo.com.ar', '0', '', '2023-12-11', 1, '0000-00-00 00:00:00', '2023-12-11 03:46:17', 'RI'),
(18, 'Valentyna Tkachenko', 1, 'nuevavista.optica@gmail.com', '0', '', '2023-12-11', 2, '0000-00-00 00:00:00', '2023-12-11 03:46:17', 'RI'),
(19, 'Julia Torregiani', 1, 'opticamurillo@hotmail.com', '0', '', '2023-12-11', 1, '0000-00-00 00:00:00', '2023-12-11 03:46:17', 'RI'),
(20, 'Patricia Vielma', 1, 'patricia.vielmasalas@gmail.com', '0', '', '2023-12-11', 1, '0000-00-00 00:00:00', '2023-12-11 03:46:17', 'RI'),
(21, 'VERONICA ROSTAGNO', 1, 'veronicarostagno@hotmail.com', '0', '', '2023-12-11', 1, '0000-00-00 00:00:00', '2023-12-11 03:46:17', 'RI'),
(22, 'Fiorela Lopumo', 1, 'opticalopumo@outlook.es', '0', '', '2023-12-11', 1, '0000-00-00 00:00:00', '2023-12-11 03:46:17', 'RI'),
(23, 'Maria Gabriela Bugari', 1, 'opticasantaluciacapilla@hotmail.com.ar', '0', '', '2023-12-11', 1, '0000-00-00 00:00:00', '2023-12-11 03:46:17', 'RI'),
(24, 'Gabriel BAHL', 1, 'charmelunettes@outlook.es', '0', '', '2023-12-11', 1, '0000-00-00 00:00:00', '2023-12-11 03:46:17', 'RI'),
(25, 'cynthia luquez', 1, 'optilab.er@gmail.com', '0', '', '2023-12-11', 1, '0000-00-00 00:00:00', '2023-12-11 03:46:17', 'RI'),
(26, 'Cecilia Masa', 1, 'visionopticachaco@gmail.com', '0', '', '2023-12-11', 2, '0000-00-00 00:00:00', '2023-12-11 03:46:17', 'RI'),
(27, 'irene sofia sola', 1, 'optica-centro@hotmail.com', '0', '', '2023-12-11', 1, '0000-00-00 00:00:00', '2023-12-11 03:46:17', 'RI'),
(28, 'Leandro Yulan', 1, 'opticanahuel2@hotmail.com', '0', '', '2023-12-11', 1, '0000-00-00 00:00:00', '2023-12-11 03:46:17', 'RI'),
(29, 'Leonardo Maccione', 1, 'leomaccione@gmail.com', '0', '', '2023-12-11', 1, '0000-00-00 00:00:00', '2023-12-11 03:46:17', 'RI'),
(30, 'Mariano Gallo', 1, 'marianogallo@gmail.com', '0', '', '2023-12-11', 3, '0000-00-00 00:00:00', '2023-12-11 03:46:17', 'RI'),
(31, 'Adrian Peñalva', 1, 'opticapenalva@gmail.com', '0', '', '2023-12-11', 1, '0000-00-00 00:00:00', '2023-12-11 03:46:17', 'RI'),
(32, 'Damian Bravo', 1, 'guillebaezz16@gmail.com', '0', '', '2023-12-11', 1, '0000-00-00 00:00:00', '2023-12-11 03:46:17', 'RI'),
(33, 'Alejandra Soto', 1, 'info@maybecomputacion.com.ar', '0', '', '2023-12-11', 0, '0000-00-00 00:00:00', '2023-12-11 03:46:17', 'RI');

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

--
-- Estructura de tabla para la tabla `productos`
--

CREATE TABLE `productos` (
  `id` int(11) NOT NULL,
  `id_categoria` int(11) NOT NULL,
  `codigo` text CHARACTER SET utf8mb4 COLLATE utf8mb4_spanish2_ci NOT NULL,
  `descripcion` text CHARACTER SET utf8mb4 COLLATE utf8mb4_spanish2_ci NOT NULL,
  `imagen` text CHARACTER SET utf8mb4 COLLATE utf8mb4_spanish2_ci NOT NULL,
  `stock` int(11) NOT NULL,
  `precio_compra` float NOT NULL,
  `precio_venta` float NOT NULL,
  `ventas` int(11) NOT NULL,
  `fecha` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_spanish_ci;

--
-- Volcado de datos para la tabla `productos`
--

INSERT INTO `productos` (`id`, `id_categoria`, `codigo`, `descripcion`, `imagen`, `stock`, `precio_compra`, `precio_venta`, `ventas`, `fecha`) VALUES
(1, 1, '3573', 'ACCESORIO M ROMBO', '', 10000, 0, 8.6, 0, '2023-12-11 02:53:51'),
(2, 1, '3773', 'CADENA PLASTICA A', '', 10000, 0, 14.3, 0, '2023-12-11 02:54:04'),
(3, 1, '3804', 'CADENA PLASTICA C', '', 10000, 0, 14.3, 0, '2023-12-11 02:54:08'),
(4, 1, '3809', 'COLGANTE PAÑUELO AZUL', '', 10000, 0, 1300, 0, '2023-12-11 02:52:40'),
(5, 1, '3815', 'COLGANTE PAÑUELO BLANCO', '', 10000, 0, 1300, 0, '2023-12-11 02:52:40'),
(6, 1, '3819', 'COLGANTE PAÑUELO BYN', '', 10000, 0, 1300, 0, '2023-12-11 02:52:40'),
(7, 1, '3823', 'COLGANTE PAÑUELO COLORES', '', 10000, 0, 1300, 0, '2023-12-11 02:52:40'),
(8, 1, '3827', 'COLGANTE PAÑUELO LUNARES', '', 10000, 0, 1300, 0, '2023-12-11 02:52:40'),
(9, 1, '3831', 'COLGANTE PAÑUELO NEGRO', '', 10000, 0, 1300, 0, '2023-12-11 02:52:40'),
(10, 1, '3836', 'COLGANTE PAÑUELO ROJO', '', 10000, 0, 1300, 0, '2023-12-11 02:52:40'),
(11, 2, '3841', 'CORDON E ELASTICO LAZO MULTICOLOR', '', 10000, 0, 2640, 0, '2023-12-11 02:52:40'),
(12, 2, '3845', 'I CORDON ELASTICO INFANTIL', '', 10000, 0, 2004, 0, '2023-12-11 02:52:40'),
(13, 2, '3851', 'I CORDON ELASTICO INFANTIL CON PUNTERA', '', 10000, 0, 2004, 0, '2023-12-11 02:52:40'),
(14, 2, '3855', 'I CORDON INFANTIL CLASICO', '', 10000, 0, 3350, 0, '2023-12-11 02:52:40'),
(15, 2, '3860', 'I CORDON INFANTIL MULTICOLOR', '', 10000, 0, 3350, 0, '2023-12-11 02:52:40'),
(16, 2, '3865', 'I CORDON RUSTICO INFANTIL', '', 10000, 0, 3350, 0, '2023-12-11 02:52:40'),
(17, 2, '3870', 'I CORDON RUSTICO INFANTIL II', '', 10000, 0, 3350, 0, '2023-12-11 02:52:40'),
(18, 2, '3875', 'I ELASTICO FUTBOL', '', 10000, 0, 2650, 0, '2023-12-11 02:52:40'),
(19, 2, '3880', 'I ELASTICO MUL', '', 10000, 0, 2100, 0, '2023-12-11 02:52:40'),
(20, 2, '3885', 'I ELASTICO NE', '', 10000, 0, 2100, 0, '2023-12-11 02:52:40'),
(21, 2, '3890', 'I ELASTICO REGULABLE AZUL', '', 10000, 0, 627, 0, '2023-12-11 02:52:40'),
(22, 2, '3894', 'I ELASTICO REGULABLE BEIGE', '', 10000, 0, 627, 0, '2023-12-11 02:52:40'),
(23, 2, '3898', 'I ELASTICO REGULABLE CELESTE', '', 10000, 0, 627, 0, '2023-12-11 02:52:40'),
(24, 2, '3902', 'I ELASTICO REGULABLE LILA', '', 10000, 0, 627, 0, '2023-12-11 02:52:40'),
(25, 2, '3906', 'I ELASTICO REGULABLE ROJO', '', 10000, 0, 627, 0, '2023-12-11 02:52:40'),
(26, 2, '3910', 'I ELASTICO REGULABLE ROSA', '', 10000, 0, 627, 0, '2023-12-11 02:52:40'),
(27, 2, '3914', 'I SUJETADOR DE GOMA C X 6', '', 10000, 0, 2640, 0, '2023-12-11 02:52:40'),
(28, 2, '3919', 'I SUJETADOR DE GOMA M X 6', '', 10000, 0, 2640, 0, '2023-12-11 02:52:40'),
(29, 5, '3924', 'I ELASTICO MUL', '', 10000, 0, 2100, 0, '2023-12-11 02:52:40'),
(30, 4, '3929', 'I ELASTICO NE', '', 10000, 0, 2100, 0, '2023-12-11 02:52:40'),
(31, 5, '3934', 'S ELASTICO COLORES CON PUNTERA', '', 10000, 0, 2520, 0, '2023-12-11 02:52:40'),
(32, 5, '3939', 'S ELASTICO NEGRO CON PUNTERA', '', 10000, 0, 2520, 0, '2023-12-11 02:52:40'),
(33, 5, '3942', 'S ELASTICO REGULABLE N', '', 10000, 0, 2100, 0, '2023-12-11 02:52:40'),
(34, 5, '3947', 'S ELASTICO SILICONA COLOR', '', 10000, 0, 2940, 0, '2023-12-11 02:52:40'),
(35, 6, '3954', 'S FUNDA ESTAMPADA AM', '', 10000, 0, 900, 0, '2023-12-11 02:52:40'),
(36, 6, '3959', 'S FUNDA ESTAMPADA C', '', 10000, 0, 900, 0, '2023-12-11 02:52:40'),
(37, 6, '3964', 'S FUNDA ESTAMPADA F', '', 10000, 0, 900, 0, '2023-12-11 02:52:40'),
(38, 6, '3968', 'S FUNDA ESTAMPADA P', '', 10000, 0, 900, 0, '2023-12-11 02:52:40'),
(39, 6, '3973', 'S FUNDA FLUOR', '', 10000, 0, 900, 0, '2023-12-11 02:52:40'),
(40, 6, '3975', 'S FUNDA LISA AMARILLA', '', 10000, 0, 900, 0, '2023-12-11 02:52:40'),
(41, 6, '3980', 'S FUNDA LISA AZUL FRANCIA', '', 10000, 0, 900, 0, '2023-12-11 02:52:40'),
(42, 6, '3985', 'S FUNDA LISA AZUL MARINO', '', 10000, 0, 900, 0, '2023-12-11 02:52:40'),
(43, 6, '3990', 'S FUNDA LISA GRIS OSC', '', 10000, 0, 900, 0, '2023-12-11 02:52:40'),
(44, 6, '3997', 'S FUNDA LISA GRIS PLATA', '', 10000, 0, 900, 0, '2023-12-11 02:52:40'),
(45, 6, '4002', 'S FUNDA LISA NEGRA', '', 10000, 0, 900, 0, '2023-12-11 02:52:41'),
(46, 6, '4007', 'S FUNDA LISA ROJA', '', 10000, 0, 900, 0, '2023-12-11 02:52:41'),
(47, 6, '4012', 'S FUNDA LISA ROSA', '', 10000, 0, 900, 0, '2023-12-11 02:52:41'),
(48, 6, '4017', 'S FUNDA LISA VERDE MILITAR', '', 10000, 0, 900, 0, '2023-12-11 02:52:41'),
(49, 7, '4023', 'S FLOTA AZUL', '', 10000, 0, 950, 0, '2023-12-11 02:52:41'),
(50, 7, '4026', 'S FLOTA NEGRO', '', 10000, 0, 950, 0, '2023-12-11 02:52:41'),
(51, 7, '4028', 'S FLOTA ROJO', '', 10000, 0, 950, 0, '2023-12-11 02:52:41'),
(52, 7, '4031', 'S TUBO AZUL FRANCIA', '', 10000, 0, 810, 0, '2023-12-11 02:52:41'),
(53, 7, '4037', 'S TUBO AZUL MARINO', '', 10000, 0, 810, 0, '2023-12-11 02:52:41'),
(54, 7, '4042', 'S TUBO GRIS', '', 10000, 0, 810, 0, '2023-12-11 02:52:41'),
(55, 7, '4047', 'S TUBO GRIS PLATA', '', 10000, 0, 810, 0, '2023-12-11 02:52:41'),
(56, 7, '4052', 'S TUBO NARANJA FLUOR', '', 10000, 0, 810, 0, '2023-12-11 02:52:41'),
(57, 7, '4057', 'S TUBO NEGRO', '', 10000, 0, 810, 0, '2023-12-11 02:52:41'),
(58, 7, '4063', 'S TUBO ROJO', '', 10000, 0, 810, 0, '2023-12-11 02:52:41'),
(59, 7, '4068', 'S TUBO VERDE MILITAR', '', 10000, 0, 810, 0, '2023-12-11 02:52:41'),
(60, 8, '4073', 'CORDON COMUN AZUL MARINO', '', 10000, 0, 8200, 0, '2023-12-11 02:52:41'),
(61, 8, '4076', 'CORDON COMUN GRIS', '', 10000, 0, 8200, 0, '2023-12-11 02:52:41'),
(62, 8, '4079', 'CORDON COMUN MARRON', '', 10000, 0, 8200, 0, '2023-12-11 02:52:41'),
(63, 8, '4082', 'CORDON COMUN MULTICOLOR', '', 10000, 0, 8200, 0, '2023-12-11 02:52:41'),
(64, 8, '4085', 'CORDON COMUN NEGRO', '', 10000, 0, 8200, 0, '2023-12-11 02:52:41'),
(65, 9, '4088', 'CORDON E ELASTICO LAZO MULTICOLOR', '', 10000, 0, 2640, 0, '2023-12-11 02:52:41'),
(66, 9, '4092', 'CORDON E ELASTICO LAZO NEGRO', '', 10000, 0, 2640, 0, '2023-12-11 02:52:41'),
(67, 9, '4097', 'CORDON E ELASTICOS LAZO CLASICO', '', 10000, 0, 2640, 0, '2023-12-11 02:52:41'),
(68, 9, '4105', 'CORDON E NOBUCK CLASICO', '', 10000, 0, 3370, 0, '2023-12-11 02:52:41'),
(69, 9, '4110', 'CORDON E NOBUCK MULTICOLOR', '', 10000, 0, 3370, 0, '2023-12-11 02:52:41'),
(70, 9, '4114', 'CORDON E SEDA CLASICO', '', 10000, 0, 2400, 0, '2023-12-11 02:52:41'),
(71, 9, '4119', 'CORDON E SEDA MULTICOLOR', '', 10000, 0, 6900, 0, '2023-12-11 02:52:41'),
(72, 9, '4124', 'CORDON E SEDA PASTEL', '', 10000, 0, 6900, 0, '2023-12-11 02:52:41'),
(73, 9, '4129', 'CORDON E SILICONA BI', '', 10000, 0, 4900, 0, '2023-12-11 02:52:41'),
(74, 9, '4136', 'CORDON E SILICONA NEGRA', '', 10000, 0, 4900, 0, '2023-12-11 02:52:41'),
(75, 9, '4141', 'CORDON E SILICONA TRANSPARENTE', '', 10000, 0, 4900, 0, '2023-12-11 02:52:41'),
(76, 9, '4146', 'CORDON E TRENZADO CLASICO', '', 10000, 0, 3800, 0, '2023-12-11 02:52:41'),
(77, 9, '4152', 'CORDON E TRENZADO MULTICOLOR', '', 10000, 0, 3800, 0, '2023-12-11 02:52:41'),
(78, 9, '4159', 'CORDON E TRENZADO PASTEL', '', 10000, 0, 3800, 0, '2023-12-11 02:52:41'),
(79, 9, '4165', 'I CORDON ELASTICO INFANTIL', '', 10000, 0, 3800, 0, '2023-12-11 02:52:41'),
(80, 9, '4171', 'I CORDON INFANTIL CLASICO', '', 10000, 0, 3350, 0, '2023-12-11 02:52:41'),
(81, 9, '4177', 'I CORDON INFANTIL MULTICOLOR', '', 10000, 0, 3350, 0, '2023-12-11 02:52:41'),
(82, 9, '4183', 'I CORDON RUSTICO INFANTIL', '', 10000, 0, 3350, 0, '2023-12-11 02:52:41'),
(83, 9, '4189', 'I CORDON RUSTICO INFANTIL II', '', 10000, 0, 3350, 0, '2023-12-11 02:52:41'),
(84, 10, '4195', 'ESTUCHES LENTES DE CONTACTO X 20 U', '', 10000, 0, 89.7, 0, '2023-12-11 02:54:49'),
(85, 11, '4198', 'PORTA LENTE A', '', 10000, 0, 750, 0, '2023-12-11 02:52:41'),
(86, 11, '4202', 'PORTA LENTE N', '', 10000, 0, 750, 0, '2023-12-11 02:52:41'),
(87, 11, '4207', 'PORTA LENTE R', '', 10000, 0, 750, 0, '2023-12-11 02:52:41'),
(88, 11, '4211', 'PORTA LENTES G', '', 10000, 0, 750, 0, '2023-12-11 02:52:41'),
(89, 12, '4216', 'EST 06 A X 12', '', 10000, 0, 17550, 0, '2023-12-11 02:52:41'),
(90, 12, '4221', 'EST 08 X 10', '', 10000, 0, 14625, 0, '2023-12-11 02:52:41'),
(91, 12, '4224', 'EST 09 X 10', '', 10000, 0, 14625, 0, '2023-12-11 02:52:41'),
(92, 12, '4229', 'EST 10 X 10', '', 10000, 0, 14625, 0, '2023-12-11 02:52:41'),
(93, 12, '4231', 'EST 11 X 10', '', 10000, 0, 14625, 0, '2023-12-11 02:52:41'),
(94, 12, '4239', 'EST 12 X 10', '', 10000, 0, 14625, 0, '2023-12-11 02:52:41'),
(95, 12, '4246', 'EST 15 NEGRO', '', 10000, 0, 400, 0, '2023-12-11 02:52:41'),
(96, 13, '4251', 'CINTAS BISCELAR 1069', '', 10000, 0, 7800, 0, '2023-12-11 02:52:41'),
(97, 13, '4253', 'CINTAS BISCELAR 1070', '', 10000, 0, 7800, 0, '2023-12-11 02:52:41'),
(98, 13, '4255', 'CINTAS BISCELAR 1071', '', 10000, 0, 7800, 0, '2023-12-11 02:52:41'),
(99, 13, '4257', 'ESPEJO', '', 10000, 0, 29900, 0, '2023-12-11 02:52:41'),
(100, 13, '4262', 'HILO DE PLATA X MTO', '', 10000, 0, 1700, 0, '2023-12-11 02:52:41'),
(101, 13, '4265', 'MACHO 1 MM', '', 10000, 0, 4395, 0, '2023-12-11 02:52:41'),
(102, 14, '4267', 'MACHO 1,4MM', '', 10000, 0, 4395, 0, '2023-12-11 02:52:41'),
(103, 14, '4268', 'MACHO 1,5MM', '', 10000, 0, 4395, 0, '2023-12-11 02:52:41'),
(104, 14, '4269', 'MACHO 1,7MM', '', 10000, 0, 4395, 0, '2023-12-11 02:52:42'),
(105, 14, '4270', 'MECHA 1 MM', '', 10000, 0, 4056, 0, '2023-12-11 02:52:42'),
(106, 14, '4272', 'MECHA 1,2MM', '', 10000, 0, 4056, 0, '2023-12-11 02:52:42'),
(107, 14, '4273', 'MECHA 1,4MM', '', 10000, 0, 4056, 0, '2023-12-11 02:52:42'),
(108, 14, '4274', 'MECHA 1,5MM', '', 10000, 0, 4056, 0, '2023-12-11 02:52:42'),
(109, 14, '4276', 'MECHA 1,7MM', '', 10000, 0, 4056, 0, '2023-12-11 02:52:42'),
(110, 13, '4278', 'PINK SILOUETTE', '', 10000, 0, 2535, 0, '2023-12-11 02:52:42'),
(111, 14, '4280', 'PROBADOR DE GRADUACIONES', '', 10000, 0, 20280, 0, '2023-12-11 02:52:42'),
(112, 14, '4286', 'PROBADOR DE GRADUACIONES 56MM R', '', 10000, 0, 20280, 0, '2023-12-11 02:52:42'),
(113, 13, '4291', 'RESORTE FLEX 2,6MM', '', 10000, 0, 3550, 0, '2023-12-11 02:52:42'),
(114, 13, '4294', 'RESORTE FLEX 2MM', '', 10000, 0, 3550, 0, '2023-12-11 02:52:42'),
(115, 13, '4296', 'RUEDAS DE CORTE', '', 10000, 0, 3146, 0, '2023-12-11 02:52:42'),
(116, 13, '4299', 'SUPLEMENTO', '', 10000, 0, 15000, 0, '2023-12-11 02:52:42'),
(117, 13, '4302', 'TUERCA E 1,2MM', '', 10000, 0, 2704, 0, '2023-12-11 02:52:42'),
(118, 13, '4305', 'TUERCA E 1,4MM', '', 10000, 0, 1500, 0, '2023-12-11 02:52:42'),
(119, 13, '4306', 'TUERCA H 1,2MM', '', 10000, 0, 2704, 0, '2023-12-11 02:52:42'),
(120, 13, '4309', 'TUERCA TUBULAR METALICA', '', 10000, 0, 1530, 0, '2023-12-11 02:52:42'),
(121, 13, '4311', 'VENTOSA PARA AUTOMATICA 24MM', '', 10000, 0, 3380, 0, '2023-12-11 02:52:42'),
(122, 18, '4318', 'PAÑOS NO FOG', '', 10000, 0, 3300, 0, '2023-12-11 02:52:42'),
(123, 19, '4322', 'LIMPIA CRISTAL 100ML', '', 10000, 0, 5.25, 0, '2023-12-11 02:55:12'),
(124, 19, '4326', 'LIMPIA CRISTAL 35ML X 15U', '', 10000, 0, 48.95, 0, '2023-12-11 02:55:21'),
(125, 19, '4332', 'LIMPIA CRISTAL 60ML X 9U', '', 10000, 0, 38.25, 0, '2023-12-11 02:55:33'),
(126, 20, '4339', 'CALENTADOR', '', 10000, 0, 648.7, 0, '2023-12-11 02:55:49'),
(127, 20, '4342', 'DESTORNILLADOR PLANO', '', 10000, 0, 4485, 0, '2023-12-11 02:52:42'),
(128, 20, '4345', 'DESTORNILLADOR PUNTA INTERCAMBIABLE', '', 10000, 0, 8450, 0, '2023-12-11 02:52:42'),
(129, 20, '4348', 'GANCHO PARA TANZAS DE RANURADOS', '', 10000, 0, 4875, 0, '2023-12-11 02:52:42'),
(130, 20, '4351', 'PINZA BRUSELAS INVERTIDA', '', 10000, 0, 5460, 0, '2023-12-11 02:52:42'),
(131, 20, '4354', 'PINZA DE PUNTA', '', 10000, 0, 14300, 0, '2023-12-11 02:52:42'),
(132, 20, '4357', 'PINZA DEVASTAR', '', 10000, 0, 14300, 0, '2023-12-11 02:52:42'),
(133, 20, '4361', 'PINZA M 3 PUNTAS', '', 10000, 0, 14300, 0, '2023-12-11 02:52:42'),
(134, 20, '4367', 'PINZA M ALICATE', '', 10000, 0, 14300, 0, '2023-12-11 02:52:42'),
(135, 20, '4372', 'PINZA M CURVAR ARO', '', 10000, 0, 14300, 0, '2023-12-11 02:52:42'),
(136, 20, '4376', 'PINZA M DEVASTAR', '', 10000, 0, 14300, 0, '2023-12-11 02:52:42'),
(137, 20, '4380', 'PINZA M DOBLE TEFLON', '', 10000, 0, 14300, 0, '2023-12-11 02:52:42'),
(138, 20, '4385', 'PINZA M PUNTA CONICA Y TEFLON', '', 10000, 0, 14300, 0, '2023-12-11 02:52:42'),
(139, 20, '4390', 'PINZA M PUNTA FINA', '', 10000, 0, 14300, 0, '2023-12-11 02:52:42'),
(140, 20, '4394', 'PINZA M PUNTA PLANA Y TEFLON', '', 10000, 0, 14300, 0, '2023-12-11 02:52:42'),
(141, 20, '4397', 'PINZA PARA TALON', '', 10000, 0, 14300, 0, '2023-12-11 02:52:42'),
(142, 20, '4399', 'PINZA PARA WASHER', '', 10000, 0, 14300, 0, '2023-12-11 02:52:42'),
(143, 20, '4404', 'PINZA PUNTA CURVA', '', 10000, 0, 14300, 0, '2023-12-11 02:52:42'),
(144, 20, '4407', 'SET DE LIMAS', '', 10000, 0, 6630, 0, '2023-12-11 02:52:42'),
(145, 20, '4409', 'SET DE PINZAS', '', 10000, 0, 141700, 0, '2023-12-11 02:52:42'),
(146, 20, '4416', 'SET DESTORNILLADORES', '', 10000, 0, 10270, 0, '2023-12-11 02:52:42'),
(147, 20, '4421', 'SET PARA PINK SILOUETTE', '', 10000, 0, 28470, 0, '2023-12-11 02:52:42'),
(148, 20, '4425', 'TESTER FOTOCROMATICO', '', 10000, 0, 102960, 0, '2023-12-11 02:52:42'),
(149, 20, '4429', 'TESTER UV', '', 10000, 0, 81380, 0, '2023-12-11 02:52:42'),
(150, 20, '4434', 'ULTRASONICO PARA LENTES DE CONTACTO', '', 10000, 0, 119600, 0, '2023-12-11 02:52:42'),
(151, 21, '4440', 'CR POLARIZADO G', '', 10000, 0, 4310, 0, '2023-12-11 02:52:42'),
(152, 21, '4447', 'CR POLARIZADO G8', '', 10000, 0, 4095, 0, '2023-12-11 02:52:42'),
(153, 21, '4448', 'CR POLARIZADO S', '', 10000, 0, 4095, 0, '2023-12-11 02:52:42'),
(154, 21, '4453', 'CR POLARIZADO S8', '', 10000, 0, 4095, 0, '2023-12-11 02:52:42'),
(155, 21, '4455', 'CR-39 ESPEJADO AMARILLO B6', '', 10000, 0, 0, 0, '2023-12-11 02:52:42'),
(156, 21, '4457', 'CR-39 ESPEJADO ANARANJADO B6', '', 10000, 0, 3200, 0, '2023-12-11 02:52:42'),
(157, 21, '4462', 'CR-39 ESPEJADO AZUL B6', '', 10000, 0, 3200, 0, '2023-12-11 02:52:42'),
(158, 21, '4472', 'CR-39 ESPEJADO AZUL B8', '', 10000, 0, 3200, 0, '2023-12-11 02:52:42'),
(159, 21, '4478', 'CR-39 ESPEJADO CEREZA B6', '', 10000, 0, 3200, 0, '2023-12-11 02:52:42'),
(160, 21, '4483', 'CR-39 ESPEJADO PLATA B6', '', 10000, 0, 3200, 0, '2023-12-11 02:52:42'),
(161, 21, '4487', 'CR BLUE FILTERS -', '', 10000, 0, 5070, 0, '2023-12-11 02:52:42'),
(162, 21, '4492', 'CR-39 ESPEJADO ROJO B6', '', 10000, 0, 3200, 0, '2023-12-11 02:52:42'),
(163, 21, '4494', 'CR-39 ESPEJADO ROJO B8', '', 10000, 0, 3200, 0, '2023-12-11 02:52:42'),
(164, 21, '4496', 'CR-39 ESPEJADO VERDE B6', '', 10000, 0, 3200, 0, '2023-12-11 02:52:42'),
(165, 21, '4500', 'CR-39 ESPEJADO VIOLETA B6', '', 10000, 0, 3200, 0, '2023-12-11 02:52:42'),
(166, 21, '4505', 'CR-39 G-15 B6', '', 10000, 0, 3200, 0, '2023-12-11 02:52:42'),
(167, 21, '4510', 'CR-39 G-15 B8', '', 10000, 0, 3200, 0, '2023-12-11 02:52:42'),
(168, 21, '4514', 'CR-39 GRIS B6', '', 10000, 0, 3200, 0, '2023-12-11 02:52:43'),
(169, 21, '4518', 'CR-39 GRIS B8', '', 10000, 0, 3200, 0, '2023-12-11 02:52:43'),
(170, 21, '4524', 'CR-39 GRIS DEGRADE B6', '', 10000, 0, 3200, 0, '2023-12-11 02:52:43'),
(171, 21, '4529', 'CR-39 GRIS DEGRADE B8', '', 10000, 0, 3200, 0, '2023-12-11 02:52:43'),
(172, 21, '4530', 'CR-39 SEPIA B6', '', 10000, 0, 3200, 0, '2023-12-11 02:52:43'),
(173, 21, '4534', 'CR-39 SEPIA B8', '', 10000, 0, 3200, 0, '2023-12-11 02:52:43'),
(174, 21, '4535', 'CR-39 SEPIA DEGRADE B6', '', 10000, 0, 3200, 0, '2023-12-11 02:52:43'),
(175, 21, '4540', 'CR-39 SEPIA DEGRADE B8', '', 10000, 0, 3200, 0, '2023-12-11 02:52:43'),
(176, 21, '4541', 'TAC ESPEJADO AMARILLO B6', '', 10000, 0, 3900, 0, '2023-12-11 02:52:43'),
(177, 21, '4546', 'TAC ESPEJADO ANARANJADO B2', '', 10000, 0, 3900, 0, '2023-12-11 02:52:43'),
(178, 21, '4549', 'TAC ESPEJADO ANARANJADO B6', '', 10000, 0, 3900, 0, '2023-12-11 02:52:43'),
(179, 21, '4552', 'TAC ESPEJADO ANARANJADO B8', '', 10000, 0, 3900, 0, '2023-12-11 02:52:43'),
(180, 21, '4553', 'TAC ESPEJADO AZUL B6', '', 10000, 0, 3900, 0, '2023-12-11 02:52:43'),
(181, 21, '4556', 'TAC ESPEJADO AZUL B8', '', 10000, 0, 3900, 0, '2023-12-11 02:52:43'),
(182, 21, '4557', 'TAC ESPEJADO PLATEADO B6', '', 10000, 0, 3900, 0, '2023-12-11 02:52:43'),
(183, 21, '4559', 'TAC ESPEJADO ROSA B6', '', 10000, 0, 3900, 0, '2023-12-11 02:52:43'),
(184, 21, '4563', 'TAC ESPEJADO ROSA B8', '', 10000, 0, 3900, 0, '2023-12-11 02:52:43'),
(185, 21, '4565', 'TAC ESPEJADO VERDE B6', '', 10000, 0, 3900, 0, '2023-12-11 02:52:43'),
(186, 21, '4567', 'TAC ESPEJADO VIOLETA B6', '', 10000, 0, 3900, 0, '2023-12-11 02:52:43'),
(187, 21, '4569', 'TAC G15 B6', '', 10000, 0, 3840, 0, '2023-12-11 02:52:43'),
(188, 21, '4573', 'TAC G15 B8', '', 10000, 0, 3500, 0, '2023-12-11 02:52:43'),
(189, 21, '4576', 'TAC GRIS B2', '', 10000, 0, 3500, 0, '2023-12-11 02:52:43'),
(190, 21, '4579', 'TAC GRIS B8', '', 10000, 0, 3500, 0, '2023-12-11 02:52:43'),
(191, 21, '4583', 'TAC SEPIA B2', '', 10000, 0, 3500, 0, '2023-12-11 02:52:43'),
(192, 21, '4586', 'TAC SEPIA B6', '', 10000, 0, 3500, 0, '2023-12-11 02:52:43'),
(193, 21, '4589', 'TAC SEPIA B8', '', 10000, 0, 3500, 0, '2023-12-11 02:52:43'),
(194, 21, '4590', 'TAC SEPIA DEGRADE BASE 6', '', 10000, 0, 3500, 0, '2023-12-11 02:52:43'),
(195, 21, '4596', 'CR-39 ESPEJADO AMARILLO B6', '', 10000, 0, 3200, 0, '2023-12-11 02:52:43'),
(196, 22, '4643', 'PATILLA ACETATO 10M MARRON', '', 10000, 0, 30, 0, '2023-12-11 02:52:43'),
(197, 22, '4646', 'PATILLA ACETATO 6MM N', '', 10000, 0, 30, 0, '2023-12-11 02:52:43'),
(198, 22, '4651', 'PATILLA ACETATO 8M CAREY', '', 10000, 0, 30, 0, '2023-12-11 02:52:43'),
(199, 22, '4655', 'PATILLA CLIPER NEGRA', '', 10000, 0, 27.5, 0, '2023-12-11 02:56:46'),
(200, 22, '4659', 'PATILLA CLIPER PELTRE', '', 10000, 0, 27.5, 0, '2023-12-11 02:56:50'),
(201, 22, '4664', 'PATILLA MONOBLOCK G PLATA', '', 10000, 0, 3000, 0, '2023-12-11 02:52:43'),
(202, 22, '4670', 'PATILLA MONOBLOCK M PLATA', '', 10000, 0, 3000, 0, '2023-12-11 02:52:43'),
(203, 23, '4676', 'VAINA CAREY G x 10u', '', 10000, 0, 36, 0, '2023-12-11 02:52:43'),
(204, 23, '4679', 'VAINAS CRISTAL F x 10u', '', 10000, 0, 36, 0, '2023-12-11 02:52:43'),
(205, 23, '4681', 'VAINAS CRISTAL G x 10u', '', 10000, 0, 36, 0, '2023-12-11 02:52:43'),
(206, 23, '4682', 'VAINAS NEGRAS F x 10u', '', 10000, 0, 36, 0, '2023-12-11 02:52:43'),
(207, 23, '4684', 'VAINAS NEGRAS G x 10U', '', 10000, 0, 36, 0, '2023-12-11 02:52:43'),
(208, 24, '4686', 'PUENTE 01 X 5U', '', 10000, 0, 4500, 0, '2023-12-11 02:52:43'),
(209, 24, '4690', 'PUENTE 02 X 5U', '', 10000, 0, 4500, 0, '2023-12-11 02:52:43'),
(210, 24, '4695', 'PUENTE 03 N', '', 10000, 0, 975, 0, '2023-12-11 02:52:43'),
(211, 24, '4698', 'PUENTE 04 O', '', 10000, 0, 975, 0, '2023-12-11 02:52:43'),
(212, 24, '4701', 'PUENTE 05 N', '', 10000, 0, 975, 0, '2023-12-11 02:52:43'),
(213, 24, '4704', 'PUENTE 06 O', '', 10000, 0, 975, 0, '2023-12-11 02:52:43'),
(214, 24, '4707', 'PUENTE 08 X 5U', '', 10000, 0, 4500, 0, '2023-12-11 02:52:43'),
(215, 24, '4710', 'PUENTE 09 X 5U', '', 10000, 0, 4500, 0, '2023-12-11 02:52:43'),
(216, 24, '4714', 'PUENTE 10 X 5U', '', 10000, 0, 4500, 0, '2023-12-11 02:52:43'),
(217, 17, '4717', 'TERMINAL 01', '', 10000, 0, 3055, 0, '2023-12-11 02:52:43'),
(218, 17, '4720', 'TERMINAL 02', '', 10000, 0, 3055, 0, '2023-12-11 02:52:43'),
(219, 17, '4723', 'TERMINAL 05', '', 10000, 0, 3055, 0, '2023-12-11 02:52:43'),
(220, 17, '4726', 'TERMINAL 08', '', 10000, 0, 3055, 0, '2023-12-11 02:52:43'),
(221, 17, '4729', 'TERMINAL 09', '', 10000, 0, 3055, 0, '2023-12-11 02:52:43'),
(222, 17, '4732', 'TERMINAL 10', '', 10000, 0, 3055, 0, '2023-12-11 02:52:44'),
(223, 17, '4735', 'TERMINAL 11', '', 10000, 0, 3055, 0, '2023-12-11 02:52:44'),
(224, 17, '4739', 'TERMINAL 27', '', 10000, 0, 3055, 0, '2023-12-11 02:52:44'),
(225, 17, '4742', 'TERMINAL 28', '', 10000, 0, 3055, 0, '2023-12-11 02:52:44'),
(226, 17, '4744', 'TERMINAL 29', '', 10000, 0, 3055, 0, '2023-12-11 02:52:44'),
(227, 17, '4745', 'TERMINAL 30', '', 10000, 0, 3055, 0, '2023-12-11 02:52:44'),
(228, 17, '4747', 'TERMINAL 31', '', 10000, 0, 3055, 0, '2023-12-11 02:52:44'),
(229, 16, '4782', 'TORNILLO 01 x 50u', '', 10000, 0, 22, 0, '2023-12-11 02:52:44'),
(230, 16, '4789', 'TORNILLO 03 x 50u', '', 10000, 0, 22, 0, '2023-12-11 02:52:44'),
(231, 16, '4793', 'TORNILLO 04 x 50u', '', 10000, 0, 22, 0, '2023-12-11 02:52:44'),
(232, 16, '4796', 'TORNILLO 05 x 50u', '', 10000, 0, 22, 0, '2023-12-11 02:52:44'),
(233, 16, '4801', 'TORNILLO 06 x 50u', '', 10000, 0, 22, 0, '2023-12-11 02:52:44'),
(234, 16, '4805', 'TORNILLO 07 x 50u', '', 10000, 0, 22, 0, '2023-12-11 02:52:44'),
(235, 16, '4809', 'TORNILLO 08 x 100u', '', 10000, 0, 2200, 0, '2023-12-11 02:52:44'),
(236, 16, '4813', 'TORNILLO 09 x 100u', '', 10000, 0, 2200, 0, '2023-12-11 02:52:44'),
(237, 16, '4818', 'TORNILLO 10 x 100u', '', 10000, 0, 4300, 0, '2023-12-11 02:52:44'),
(238, 16, '4819', 'TORNILLO 12 x 100u', '', 10000, 0, 2200, 0, '2023-12-11 02:52:44'),
(239, 16, '4822', 'TORNILLO 13 x 100u', '', 10000, 0, 4300, 0, '2023-12-11 02:52:44'),
(240, 16, '4825', 'TORNILLO 15 x 50u', '', 10000, 0, 2200, 0, '2023-12-11 02:52:44'),
(241, 16, '4830', 'TORNILLO 16 x 50u', '', 10000, 0, 2200, 0, '2023-12-11 02:52:44'),
(242, 16, '4835', 'TORNILLO 19 x 50u', '', 10000, 0, 2200, 0, '2023-12-11 02:52:44'),
(243, 16, '4840', 'TORNILLO 20 x 50u', '', 10000, 0, 2200, 0, '2023-12-11 02:52:44'),
(244, 16, '4847', 'TORNILLO 21 x 50u', '', 10000, 0, 2200, 0, '2023-12-11 02:52:44'),
(245, 16, '4848', 'TUERCA E 1,2MM x 50u', '', 10000, 0, 27, 0, '2023-12-11 02:52:44'),
(246, 16, '4852', 'TUERCA E 1,4MM x 50u', '', 10000, 0, 1500, 0, '2023-12-11 02:52:44'),
(247, 16, '4855', 'TUERCA H 1,2MM x 50u', '', 10000, 0, 27, 0, '2023-12-11 02:52:44'),
(248, 16, '4858', 'TUERCA H 1,4MM x 50u', '', 10000, 0, 1500, 0, '2023-12-11 02:52:44'),
(249, 15, '4963', 'BISAGRA 01', '', 10000, 0, 19.9, 0, '2023-12-11 02:57:22'),
(250, 15, '4970', 'BISAGRA 06', '', 10000, 0, 1820, 0, '2023-12-11 02:52:44'),
(251, 15, '4974', 'BISAGRA 07', '', 10000, 0, 1820, 0, '2023-12-11 02:52:44'),
(252, 15, '4978', 'BISAGRA 11', '', 10000, 0, 1820, 0, '2023-12-11 02:52:44'),
(253, 15, '4983', 'BISAGRA 12', '', 10000, 0, 1820, 0, '2023-12-11 02:52:44'),
(254, 15, '4987', 'BISAGRA 13', '', 10000, 0, 1820, 0, '2023-12-11 02:52:44'),
(255, 15, '4989', 'BISAGRA 16', '', 10000, 0, 1820, 0, '2023-12-11 02:52:44'),
(256, 15, '4993', 'BISAGRA 17', '', 10000, 0, 1820, 0, '2023-12-11 02:52:44'),
(257, 15, '4998', 'BISAGRA 19', '', 10000, 0, 1820, 0, '2023-12-11 02:52:44'),
(258, 15, '5001', 'BISAGRA 20', '', 10000, 0, 1820, 0, '2023-12-11 02:52:44'),
(259, 15, '5003', 'BISAGRA 21', '', 10000, 0, 1820, 0, '2023-12-11 02:52:44'),
(260, 15, '5005', 'BISAGRA 22', '', 10000, 0, 1820, 0, '2023-12-11 02:52:44'),
(261, 15, '5010', 'BISAGRA 23', '', 10000, 0, 1820, 0, '2023-12-11 02:52:44'),
(262, 15, '5014', 'BISAGRA 24', '', 10000, 0, 1820, 0, '2023-12-11 02:52:44'),
(263, 15, '5017', 'RESORTE FLEX 1,4MM CLICK', '', 10000, 0, 3060, 0, '2023-12-11 02:52:44'),
(264, 15, '5022', 'RESORTE FLEX 1MM CLICK', '', 10000, 0, 3060, 0, '2023-12-11 02:52:44'),
(265, 15, '5027', 'RESORTE FLEX 2,6MM', '', 10000, 0, 3550, 0, '2023-12-11 02:52:44'),
(266, 15, '5030', 'RESORTE FLEX 2MM', '', 10000, 0, 3550, 0, '2023-12-11 02:52:44'),
(267, 15, '5034', 'RESORTE FLEX 3,2MMP', '', 10000, 0, 3060, 0, '2023-12-11 02:52:44'),
(268, 15, '5038', 'RESORTE FLEX FINO', '', 10000, 0, 3060, 0, '2023-12-11 02:52:44'),
(269, 12, '5044', 'EST 04 X 10', '', 10000, 0, 14625, 0, '2023-12-11 02:52:44'),
(270, 3, '5063', 'PLAQUETA 01', '', 10000, 0, 1260, 0, '2023-12-11 02:52:44'),
(271, 3, '5067', 'PLAQUETA 03', '', 10000, 0, 1260, 0, '2023-12-11 02:52:44'),
(272, 3, '5071', 'PLAQUETA 04', '', 10000, 0, 1260, 0, '2023-12-11 02:52:44'),
(273, 3, '5073', 'PLAQUETA 05', '', 10000, 0, 1260, 0, '2023-12-11 02:52:44'),
(274, 3, '5075', 'PLAQUETA 08', '', 10000, 0, 1260, 0, '2023-12-11 02:52:44'),
(275, 3, '5079', 'PLAQUETA 09', '', 10000, 0, 1260, 0, '2023-12-11 02:52:44'),
(276, 3, '5080', 'PLAQUETA 11', '', 10000, 0, 1260, 0, '2023-12-11 02:52:44'),
(277, 3, '5085', 'PLAQUETA 12', '', 10000, 0, 1260, 0, '2023-12-11 02:52:45'),
(278, 3, '5090', 'PLAQUETA 13', '', 10000, 0, 1260, 0, '2023-12-11 02:52:45'),
(279, 3, '5094', 'PLAQUETA 14', '', 10000, 0, 1260, 0, '2023-12-11 02:52:45'),
(280, 3, '5097', 'PLAQUETA 15', '', 10000, 0, 1260, 0, '2023-12-11 02:52:45'),
(281, 3, '5100', 'PLAQUETA 16', '', 10000, 0, 1260, 0, '2023-12-11 02:52:45'),
(282, 3, '5101', 'PLAQUETA 17', '', 10000, 0, 1260, 0, '2023-12-11 02:52:45'),
(283, 3, '5102', 'PLAQUETA 22', '', 10000, 0, 1260, 0, '2023-12-11 02:52:45'),
(284, 3, '5104', 'PLAQUETA 23', '', 10000, 0, 1560, 0, '2023-12-11 02:52:45'),
(285, 3, '5109', 'PLAQUETA 24', '', 10000, 0, 1560, 0, '2023-12-11 02:52:45'),
(286, 3, '5114', 'PLAQUETA 25', '', 10000, 0, 2300, 0, '2023-12-11 02:52:45'),
(287, 3, '5117', 'PLAQUETA 26', '', 10000, 0, 2300, 0, '2023-12-11 02:52:45'),
(288, 3, '5119', 'PLAQUETA 27', '', 10000, 0, 2300, 0, '2023-12-11 02:52:45'),
(289, 3, '5121', 'PLAQUETA 28', '', 10000, 0, 2300, 0, '2023-12-11 02:52:45'),
(290, 3, '5123', 'PLAQUETA 29', '', 10000, 0, 23, 0, '2023-12-11 02:52:45'),
(291, 3, '5126', 'PLAQUETA 30', '', 10000, 0, 2300, 0, '2023-12-11 02:52:45'),
(292, 3, '5128', 'PLAQUETA 31', '', 10000, 0, 2300, 0, '2023-12-11 02:52:45'),
(293, 3, '5130', 'PLAQUETA 32', '', 10000, 0, 2300, 0, '2023-12-11 02:52:45'),
(294, 3, '5132', 'PLAQUETA 33', '', 10000, 0, 2300, 0, '2023-12-11 02:52:45'),
(295, 3, '5134', 'PLAQUETA 34', '', 10000, 0, 2300, 0, '2023-12-11 02:52:45'),
(296, 3, '5136', 'PLAQUETA 35', '', 10000, 0, 2300, 0, '2023-12-11 02:52:45'),
(297, 3, '5138', 'PLAQUETA 36', '', 10000, 0, 2300, 0, '2023-12-11 02:52:45'),
(298, 3, '5140', 'PLAQUETA 38', '', 10000, 0, 2300, 0, '2023-12-11 02:52:45'),
(299, 3, '5142', 'PLAQUETA 39', '', 10000, 0, 2300, 0, '2023-12-11 02:52:45'),
(300, 3, '5144', 'PLAQUETA 40', '', 10000, 0, 2300, 0, '2023-12-11 02:52:45'),
(301, 3, '5146', 'PLAQUETA 41', '', 10000, 0, 2300, 0, '2023-12-11 02:52:45'),
(302, 3, '5148', 'PLAQUETA 42', '', 10000, 0, 2300, 0, '2023-12-11 02:52:45'),
(303, 3, '5150', 'PLAQUETA 43', '', 10000, 0, 2300, 0, '2023-12-11 02:52:45'),
(304, 3, '5152', 'PLAQUETA 44', '', 10000, 0, 2300, 0, '2023-12-11 02:52:45'),
(305, 3, '5154', 'PLAQUETA 45', '', 10000, 0, 2300, 0, '2023-12-11 02:52:45'),
(306, 3, '5156', 'PLAQUETA 46', '', 10000, 0, 2300, 0, '2023-12-11 02:52:45'),
(307, 3, '5158', 'PLAQUETA 47', '', 10000, 0, 2300, 0, '2023-12-11 02:52:45'),
(308, 3, '5159', 'PLAQUETA 48', '', 10000, 0, 2300, 0, '2023-12-11 02:52:45'),
(309, 3, '5161', 'PLAQUETA 49', '', 10000, 0, 1560, 0, '2023-12-11 02:52:45'),
(310, 3, '5163', 'PLAQUETA 51', '', 10000, 0, 8, 0, '2023-12-11 02:52:45');

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

--
-- Estructura de tabla para la tabla `ventas`
--

CREATE TABLE `ventas` (
  `id` int(11) NOT NULL,
  `codigo` int(11) NOT NULL,
  `id_cliente` int(11) NOT NULL,
  `id_vendedor` int(11) NOT NULL,
  `productos` text NOT NULL,
  `impuesto` float NOT NULL,
  `neto` float NOT NULL,
  `total` float NOT NULL,
  `metodo_pago` text NOT NULL,
  `fecha` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `estado` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_spanish_ci;

--
-- Índices para tablas volcadas
--

--
-- Indices de la tabla `categorias`
--
ALTER TABLE `categorias`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `clientes`
--
ALTER TABLE `clientes`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `productos`
--
ALTER TABLE `productos`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `ventas`
--
ALTER TABLE `ventas`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT de las tablas volcadas
--

--
-- AUTO_INCREMENT de la tabla `categorias`
--
ALTER TABLE `categorias`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25;

--
-- AUTO_INCREMENT de la tabla `clientes`
--
ALTER TABLE `clientes`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=34;

--
-- AUTO_INCREMENT de la tabla `productos`
--
ALTER TABLE `productos`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=311;

--
-- AUTO_INCREMENT de la tabla `ventas`
--
ALTER TABLE `ventas`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
COMMIT;

