text: -- phpMyAdmin SQL Dump
  -- version 4.8.5
  -- https://www.phpmyadmin.net/
  --
  -- Servidor: localhost:3306
  -- Tiempo de generación: 29-08-2019 a las 12:44:51
  -- Versión del servidor: 10.2.26-MariaDB
  -- Versión de PHP: 7.2.7
  
  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: `jmcracin_jmc`
  --
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `clientes`
  --
  
  CREATE TABLE `clientes` (
    `id` int(11) NOT NULL,
    `nombres` varchar(90) NOT NULL,
    `apellidoPaterno` varchar(90) NOT NULL,
    `apellidoMaterno` varchar(90) NOT NULL,
    `nombresCompletos` varchar(120) NOT NULL,
    `idTipoDocumentos` int(11) NOT NULL,
    `documento` varchar(30) NOT NULL,
    `direccion` text NOT NULL,
    `correo` varchar(90) NOT NULL,
    `saldo` decimal(10,2) NOT NULL,
    `idEstados` int(11) NOT NULL,
    `fechaRegistro` datetime NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Volcado de datos para la tabla `clientes`
  --
  
  INSERT INTO `clientes` (`id`, `nombres`, `apellidoPaterno`, `apellidoMaterno`, `nombresCompletos`, `idTipoDocumentos`, `documento`, `direccion`, `correo`, `saldo`, `idEstados`, `fechaRegistro`) VALUES
  (1, 'Franz', 'Gualambo', 'Giraldo', 'Gualambo Giraldo Franz', 1, '44556677', 'Pro', 'gualambo@gmail.com', 166040.00, 0, '2019-04-12 17:22:25'),
  (2, 'Elvis', 'Urquisa', '.', 'Urquisa . Elvis', 1, '.', '.', 'dianaterrel@hotmail.com', 2840.00, 0, '2019-04-24 12:27:58'),
  (3, 'renzo', 'adfadf', 'fgsgsg', 'adfadf fgsgsg renzo', 1, '345345', 'fwefwef', 'afadf@adfadf.com', 0.00, 0, '2019-04-26 18:41:10'),
  (4, 'Renzo', 'Gualambo', 'Giraldo', 'Gualambo Giraldo Renzo', 1, '1213131313', 'PRo', 'sdsd@gadgad.com', 0.00, 0, '2019-04-29 11:26:43'),
  (5, 'Renzo', 'Gualambo', 'Giraldo', 'Gualambo Giraldo Renzo', 1, '1213131313', 'PRo', 'sdsd@gadgad.com', 0.00, 0, '2019-04-29 11:33:18'),
  (6, 'Juan', 'Perez', 'Perez', 'Perez Perez Juan', 1, '01234567', 'Calle Huaraz 999', 'sucorreo@gmail.com', 859.00, 0, '2019-05-01 10:46:23'),
  (7, 'David', 'Arroyo', 'Vasquez', 'Arroyo Vasquez David', 2, '12345678', 'Ate', 'jmc@hotmail.com', 3162.00, 1, '2019-05-14 11:16:24'),
  (8, 'Mauricio', 'Miñano', '.', 'Miñano . Mauricio', 1, '74129915', '.', 'mauriciominano@gmail.com', 0.00, 0, '2019-05-15 10:25:46'),
  (9, 'Carlos', 'Navarro', '.', 'Navarro . Carlos', 1, '12345678', '.', 'jmc.racing.sac@hotmail.com', 0.00, 0, '2019-05-15 14:48:13'),
  (10, 'Pepe', 'lopez', '.', 'lopez . Pepe', 1, '123456789', '.', 'jmc.racing.sac@hotmail.com', 0.00, 0, '2019-05-15 15:16:28'),
  (11, 'Jimmy', 'Paso', '.', 'Paso . Jimmy', 1, '12345678', '.', 'jmc.racing.sac@hotmail.com', 0.00, 0, '2019-05-15 15:39:03'),
  (12, 'CLIENTE', 'DE', 'PRUEBA', 'DE PRUEBA CLIENTE', 1, '00000000', 'AV. MAQUINARIAS 777', 'correo@gmail.com', 2662.52, 0, '2019-05-15 18:16:17'),
  (13, 'Lalo', 'Chian', '.', 'Chian . Lalo', 1, '12345678', '.', 'jmc.racing.sac@hotmail.com', 0.00, 0, '2019-05-16 10:11:06'),
  (14, 'Jose', 'luis', 'Rios', 'luis Rios Jose', 1, '12345678', '.', 'jmc.racing.sac@hotmail.com', 0.00, 0, '2019-05-16 10:24:09'),
  (15, 'Jose', 'Rojas', '.', 'Rojas . Jose', 1, '12345678', '.', 'jmc.racing.sac@hotmail.com', 0.00, 0, '2019-05-16 12:04:04'),
  (16, 'Alfredo', 'Talledo', '.', 'Talledo . Alfredo', 1, '12345678', '.', 'jmc.racing.sac@hotmail.com', 0.00, 0, '2019-05-16 12:16:37'),
  (17, 'Carlos', 'Armas', '.', 'Armas . Carlos', 1, '123456789', '.', 'jmc.racing.sac@hotmail.com', 0.00, 0, '2019-05-16 12:24:35'),
  (18, 'Julio', 'Cornejo', '.', 'Cornejo . Julio', 1, '123456789', '.', 'jmc.racing.sac@hotmail.com', 0.00, 0, '2019-05-16 12:25:50'),
  (19, 'Jeremmy', 'Venegas', '.', 'Venegas . Jeremmy', 1, '123456789', '.', 'jmc.racing.sac@hotmail.com', 0.00, 0, '2019-05-16 12:28:01'),
  (20, 'Ernesto', 'Peyon', '.', 'Peyon . Ernesto', 1, '12345678', '.', 'jmc.racing.sac@hotmail.com', 0.00, 0, '2019-05-16 12:29:52'),
  (21, 'Alfredo', 'Talledo', '.', 'Talledo . Alfredo', 1, '123456789', '.', 'jmc.racing.sac@hotmail.com', 0.00, 0, '2019-05-17 10:26:52'),
  (22, 'David', 'Sanchez', '.', 'Sanchez . David', 1, '12345678', '.', 'jmc.racing.sac@hotmail.com', 0.00, 0, '2019-05-17 11:02:29'),
  (23, 'Dai', '.', '.', '. . Dai', 1, '12345678', '.', 'jmc.racing.sac@hotmail.com', 0.00, 0, '2019-05-17 11:25:02'),
  (24, 'Piero', 'Alfaro', '.', 'Alfaro . Piero', 1, '123456789', '.', 'jmc.racing.sac@hotmail.com', 0.00, 0, '2019-05-17 12:36:30'),
  (25, 'Javier', 'Cardenas', '.', 'Cardenas . Javier', 1, '12345678', '.', 'jmc.racing.sac@hotmail.com', 0.00, 0, '2019-05-17 12:44:49'),
  (26, 'Oscar', 'Mamani', 'Coarte', 'Mamani Coarte Oscar', 1, '40685986', 'Jr. Luisa Beausejour 1950-Lima', 'oscartransportesmamani@gmail.com', 0.00, 0, '2019-05-18 12:25:49'),
  (27, 'Rudy', 'Vazquez', '.', 'Vazquez . Rudy', 1, '12345678', '.', 'jmc.racing.sac@hotmail.com', 0.00, 0, '2019-05-20 09:37:45'),
  (28, 'Alex', 'Garayar', '.', 'Garayar . Alex', 1, '123456789', '.', 'jmc.racing.sac@hotmail.com', 0.00, 0, '2019-05-21 09:50:34'),
  (29, 'Willy', 'Chiy', 'Sanchez', 'Chiy Sanchez Willy', 1, '12345678', '.', 'jmc.racing.sac@hotmail.com', 0.00, 0, '2019-05-21 12:47:17'),
  (30, 'zunel', 'Morales', '.', 'Morales . zunel', 1, '12345678', '.', 'jmc.racing.sac@hotmail.com', 0.00, 0, '2019-05-21 13:07:25'),
  (31, 'Juan', 'Rojas', '.', 'Rojas . Juan', 1, '12345678', '.', 'jmc.racing.sac@hotmail.com', 0.00, 0, '2019-05-21 13:15:29'),
  (32, 'Carlos', 'Ceccovilli', 'Guzman', 'Ceccovilli Guzman Carlos', 1, '123456789', '.', 'jmc.racing.sac@hotmail.com', 0.00, 0, '2019-05-24 09:54:06'),
  (33, 'Ivan', 'Robles', 'Alva', 'Robles Alva Ivan', 1, '70896005', 'Mzf lote 7 asociación sta rosa-calla  ', 'yvan.roblesalva@gmail.com', 0.00, 0, '2019-05-24 10:13:45'),
  (34, 'Jimenez', 'Jimenez', '.', 'Jimenez . Jimenez', 1, '12345678', 'Mz.CH Lt-2 AAHH Jasminez de Palao - San Martin de Porres', 'jmc.racing.sac@hotmail.com', 2260.00, 1, '2019-05-27 11:26:12'),
  (35, 'Carlos', 'Ceccovilli', 'Guzman', 'Ceccovilli Guzman Carlos', 1, '12345678', 'Miraflores', 'jmc.racing.sac@hotmail.com', 0.00, 0, '2019-05-27 12:09:50'),
  (36, 'CLIENTE', 'PRUEBA', 'PRUEBA', 'PRUEBA PRUEBA CLIENTE', 1, '99999999', 'AV. INSURGENTES 433', 'xxx@gmail.com', 2500.00, 0, '2019-05-27 18:47:56'),
  (37, 'Carlos', 'Velazco', '.', 'Velazco . Carlos', 1, '12345678', 'San Miguel', 'jmc.racing.sac@hotmail.com', 0.00, 0, '2019-05-28 09:29:31'),
  (38, 'Coly', 'Velazco', '.', 'Velazco . Coly', 1, '12345678', 'San Miguel', 'jmc.racing.sac@hotmail.com', 320.00, 1, '2019-05-28 09:29:31'),
  (39, 'Carlos', 'Navarro', '.', 'Navarro . Carlos', 1, '12345678', 'Av. arequipa 350-Lima', 'navarroteus@hotmail.com', 3680.00, 1, '2019-05-28 09:59:33'),
  (40, 'Jose', 'Rojas', '.', 'Rojas . Jose', 1, '12345678', '.', 'jmc.racing.sac@hotmail.com', 0.00, 0, '2019-05-28 11:50:40'),
  (41, 'cliente', 'PRUEBA', 'PRUEBA', 'PRUEBA PRUEBA cliente', 1, '99999999', 'Lima', 'sss@gmail.com', 0.00, 0, '2019-05-28 13:17:26'),
  (42, 'Richard', 'Marques', '.', 'Marques . Richard', 1, '70346723', 'Mzt lote 53 urb el pinar comas', 'richard_181914@hotmail.com', 1430.00, 1, '2019-05-29 09:50:43'),
  (43, 'Richard', 'Marques', '.', 'Marques . Richard', 1, '70346723', 'Mzt lote 53 urb el pinar comas', 'richard_181914@hotmail.com', 0.00, 0, '2019-05-29 15:16:12'),
  (44, 'Ruth', 'Loreda', '.', 'Loreda . Ruth', 1, '0908908', 'San Miguel', 'jmc.racing.sac@hotmail.com', 0.00, 0, '2019-05-31 15:05:33'),
  (45, 'Luis', 'Miguel', '.', 'Miguel . Luis', 1, '12345678', '.', 'jmc.racing.sac@hotmail.com', 0.00, 0, '2019-06-15 09:59:33'),
  (46, 'Cesar', 'Tirado', '.', 'Tirado . Cesar', 1, '76428879', 'Jr varela 1670', 'cesartirado.99@gmail.com', 0.00, 0, '2019-06-27 12:35:16'),
  (47, 'Eduardo', 'Granado', '.', 'Granado . Eduardo', 1, '06783973', 'Martin oviedo 243 pueblo libre', 'jmc.racing.sac@hotmail.com', 0.00, 0, '2019-06-28 11:08:06'),
  (48, 'Aristedes', 'Cordova', '.', 'Cordova . Aristedes', 1, '12345678', 'ventanilla', 'jmc.racing.sac@hotmail.com', 608.00, 1, '2019-07-01 10:13:22'),
  (49, 'Dai', '.', '.', '. . Dai', 1, '12345678', '.', 'jmc.racing.sac@hotmail.com', 3170.00, 0, '2019-07-01 11:07:36'),
  (50, 'diana', 'torres', 'terrel', 'torres terrel diana', 1, '77777777', 'Breña', 'jmc.racing.sac@hotmail.com', 0.00, 0, '2019-07-04 11:34:15'),
  (51, 'Dai', '.', '.', '. . Dai', 1, '12345678', '.', 'jmc.racing.sac@hotmail.com', 0.00, 1, '2019-07-10 09:11:57'),
  (52, 'Misael', '.', '.', '. . Misael', 1, '12345678', '.', 'jmc.racing.sac@hotmail.com', 0.00, 1, '2019-07-10 09:12:49'),
  (53, 'Diego', 'Cardenas', '.', 'Cardenas . Diego', 1, '12345678', '.', 'jmc.racing.sac@hotmail.com', 1468.00, 1, '2019-07-10 09:13:37'),
  (54, 'Jimmy', 'Gutierrez', '.', 'Gutierrez . Jimmy', 1, '12345678', '.', 'jmc.racing.sac@hotmail.com', 0.00, 0, '2019-07-12 09:35:04'),
  (55, 'Jimmy', 'Gutierrez', '.', 'Gutierrez . Jimmy', 1, '12345678', '.', 'jmc.racing.sac@hotmail.com', 1000.00, 1, '2019-07-12 09:35:04'),
  (56, 'Fidel', 'Garcia', 'Durant', 'Garcia Durant Fidel', 1, '12345678', 'Calle santa ana 363 Pueblo libre', 'jmc.racing.sac@hotmail.com', 750.00, 1, '2019-07-12 09:59:55'),
  (57, 'Jimmy', 'Venegas', '.', 'Venegas . Jimmy', 1, '12345678', '.', 'jmc.racing.sac@hotmail.com', 560.00, 1, '2019-07-15 09:04:25'),
  (58, 'Fernado', 'Barreto', '.', 'Barreto . Fernado', 1, '42218276', '.', 'jmc.racing.sac@hotmail.com', 820.00, 1, '2019-07-15 10:56:59'),
  (59, 'Fernando', 'Neyra', '.', 'Neyra . Fernando', 1, '07255177', 'Av. simon bolivar 416 pueblo libre', 'jmc.racing.sac@hotmail.com', 578.00, 1, '2019-07-16 17:44:16'),
  (60, 'Jose', 'Ortiz', '.', 'Ortiz . Jose', 1, '123456789', '.', 'jmc.racing.sac@hotmail.com', 0.00, 1, '2019-07-19 10:18:58'),
  (61, 'Enrique', 'Murga', '.', 'Murga . Enrique', 1, '123456789', '.', 'jmc.racing.sac@hotmail.com', -3036.00, 0, '2019-07-23 09:51:51'),
  (62, 'Jeremy', 'Venegas', '.', 'Venegas . Jeremy', 1, '123456789', '.', 'jmc.racing.sac@hotmail.com', 0.00, 1, '2019-07-23 10:52:32'),
  (63, 'Enrique', 'Murga', '.', 'Murga . Enrique', 1, '12345678', '.', 'jmc.racing.sac@hotmail.com', 0.00, 1, '2019-08-20 16:23:32'),
  (64, 'Julio', 'Espinoza', '.', 'Espinoza . Julio', 1, '12345678', '.', 'notiene@notiene.com', 582.00, 1, '2019-08-20 16:32:34'),
  (65, 'Yuri', 'Aviles', 'Cordova', 'Aviles Cordova Yuri', 1, '12345678', '.', 'notiene@notiene.com', 1363.00, 1, '2019-08-20 17:27:48'),
  (66, 'Yuri', 'Aviles', 'Cordova', 'Aviles Cordova Yuri', 1, '12345678', '.', 'notiene@notiene.com', 280.00, 1, '2019-08-20 19:29:51'),
  (67, 'Yuri', 'Aviles', 'Cordova', 'Aviles Cordova Yuri', 1, '12345678', '.', 'notiene@notiene.com', 0.00, 0, '2019-08-20 19:29:51'),
  (68, 'Renzo', '.', '.', '. . Renzo', 1, '12345678', '.', 'notiene@notiene.com', 920.00, 1, '2019-08-21 15:33:09'),
  (69, 'Carlos', 'Navarro', '.', 'Navarro . Carlos', 1, '12345678', '.', 'notiene@notiene.com', 0.00, 1, '2019-08-21 15:33:46'),
  (70, 'Ronal', 'Junes', '.', 'Junes . Ronal', 1, '.', 'Ventanilla', 'notiene@notiene.com', 0.00, 1, '2019-08-21 15:34:50'),
  (71, 'Tito', 'Tomey', '.', 'Tomey . Tito', 1, '12345678', '.', 'notiene@notiene.com', 0.00, 1, '2019-08-21 15:35:46'),
  (72, 'Oscar', 'Mamani', 'notiene', 'Mamani notiene Oscar', 1, 'notiene', 'notiene', 'notiene@notiene.com', 0.00, 1, '2019-08-21 15:36:43'),
  (73, 'Jimmy', 'Gutierrez', '.', 'Gutierrez . Jimmy', 1, 'notiene', 'notiene', 'notiene@notiene.com', 0.00, 1, '2019-08-21 15:37:59'),
  (74, 'Coly', 'Velasco', '.', 'Velasco . Coly', 0, '', '', '', 0.00, 1, '2019-08-21 15:38:41'),
  (75, 'Coly', 'Velasco', '.', 'Velasco . Coly', 1, 'notiene', 'notiene', 'notiene@notiene.com', 0.00, 1, '2019-08-21 15:39:16'),
  (76, 'willy', 'Chiri', '.', 'Chiri . willy', 1, 'notiene', 'notiene', 'notiene@notiene.com', 0.00, 1, '2019-08-21 15:40:10'),
  (77, 'Willy', 'Chiri', 'Sanchez', 'Chiri Sanchez Willy', 1, 'notiene', 'notiene', 'notiene@notiene.com', 0.00, 1, '2019-08-21 15:41:06'),
  (78, 'Gerson', 'Sanchez', '.', 'Sanchez . Gerson', 1, 'notiene', 'Breña', 'notiene@notiene.com', 0.00, 1, '2019-08-21 15:42:02'),
  (79, 'Rafael', 'Guerra', 'Montoya', 'Guerra Montoya Rafael', 1, 'notiene', 'notiene', 'notiene@notiene.com', 1100.00, 1, '2019-08-21 15:43:07'),
  (80, 'Yuri', 'Aviles', 'Cordova', 'Aviles Cordova Yuri', 1, 'notiene', 'notiene', 'notiene@notiene.com', 0.00, 1, '2019-08-21 15:44:41'),
  (81, 'Tito', 'Tomey', '.', 'Tomey . Tito', 1, 'notiene', 'notiene', 'notiene@notiene.com', 0.00, 1, '2019-08-21 15:45:49'),
  (82, 'Alfredo', 'Talledo', 'Flores', 'Talledo Flores Alfredo', 1, 'notiene', 'notiene', 'notiene@notiene.com', 608.00, 1, '2019-08-21 15:46:32'),
  (83, 'Luis Miguel', 'Grimaldo', '.', 'Grimaldo . Luis Miguel', 1, '10545359', 'San Miguel', 'luisgrimaldo877@hotmail.com', 1800.00, 1, '2019-08-23 11:11:22'),
  (84, 'Misael', 'Gutierrez', 'Quispe', 'Gutierrez Quispe Misael', 1, 'notiene', 'Mz.C Lte.18 24 de Junio - Ventanilla', 'maestrofut@hotmail.com', 155.00, 1, '2019-08-24 16:13:15');
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `compras`
  --
  
  CREATE TABLE `compras` (
    `id` int(11) NOT NULL,
    `ruc` varchar(90) NOT NULL,
    `razonSocial` varchar(150) NOT NULL,
    `idEstados` int(11) NOT NULL,
    `fechaRegistro` datetime NOT NULL,
    `fechaCompras` datetime NOT NULL,
    `montoTotal` decimal(10,2) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Volcado de datos para la tabla `compras`
  --
  
  INSERT INTO `compras` (`id`, `ruc`, `razonSocial`, `idEstados`, `fechaRegistro`, `fechaCompras`, `montoTotal`) VALUES
  (1, '123123', 'sfgsfg', 0, '2019-04-16 07:57:59', '2019-04-16 07:56:00', 1000.00),
  (2, '123123', 'sgsfg', 0, '2019-04-16 08:07:02', '2019-04-16 08:06:00', 450.00),
  (3, '123123', 'sgsfg', 0, '2019-04-16 08:07:29', '2019-04-16 08:06:00', 450.00),
  (4, '123123', 'sgsfg', 0, '2019-04-16 08:08:47', '2019-04-16 08:08:00', 1000.00),
  (5, '123123', 'sgsfg', 0, '2019-04-16 08:10:37', '2019-04-16 08:10:00', 0.00),
  (6, '123123', 'sgsfg', 0, '2019-04-16 08:11:06', '2019-04-16 08:10:00', 0.00),
  (7, '123123', 'sfgsfg', 0, '2019-04-16 08:19:12', '2019-04-16 08:19:00', 0.00),
  (8, '123123', 'sfgsfg', 0, '2019-04-16 08:19:49', '2019-04-16 08:19:00', 423.00),
  (9, '45881236', 'angel', 0, '2019-07-02 11:34:07', '2019-07-02 11:33:00', 2502.00),
  (10, '20348687191', 'Wurth Peru S.A.C', 0, '2019-07-03 10:45:47', '2019-07-03 10:43:00', 150.00),
  (11, '20348687191', 'Wurth Peru S.A.C', 1, '2019-07-03 12:00:05', '2019-01-29 11:56:00', 758.69),
  (12, '20101681395', 'Automotriz Bavarian S.C.R.L', 1, '2019-07-03 12:09:15', '2019-01-29 12:06:00', 50.04),
  (13, '20167921109', 'Fiamaster S.A', 0, '2019-07-03 12:25:26', '2019-01-29 12:24:00', 0.00),
  (14, '20167921109', 'Fiamaster S.A', 1, '2019-07-03 12:26:02', '2019-01-29 12:24:00', 10.84),
  (15, '20100032881', 'Aba Singer & Cia S.A.C', 1, '2019-07-03 12:34:14', '2019-01-14 12:32:00', 13.07),
  (16, '20517767396', 'Escoh S.A.C', 1, '2019-07-03 12:37:54', '2019-07-03 12:35:00', 1.00),
  (17, '20100032881', 'Aba Singer & Cia S.A.C', 1, '2019-07-03 14:39:18', '2019-07-03 14:38:00', 10.00),
  (18, '20503840121', 'Repsol Comercial S.A.C', 1, '2019-07-03 14:48:13', '2019-07-03 14:47:00', 159.49),
  (19, '20100085578', 'Renusa', 1, '2019-07-03 14:57:37', '2019-01-25 14:55:00', 161.31),
  (20, '20100085578', 'Renusa', 1, '2019-07-04 09:10:50', '2019-01-24 09:08:00', 45.55),
  (21, '20100032881', 'Aba Singer & Cia S.A.C', 1, '2019-07-04 09:18:32', '2019-12-31 09:16:00', 14.65),
  (22, '10430915911', 'Global Parts', 1, '2019-07-04 09:22:26', '2019-01-25 09:21:00', 21.18),
  (23, '20167921109', 'Fiamaster', 1, '2019-07-04 09:36:53', '2019-01-24 09:35:00', 28.85),
  (24, '20503840121', 'Repsol Comercial S.A.C', 1, '2019-07-04 09:48:37', '2019-01-23 09:47:00', 50.00),
  (25, '20101681395', 'Automotriz Bavarian S.C.R.L', 1, '2019-07-04 10:02:19', '2019-01-22 10:00:00', 71.45),
  (26, '20600626290', 'Repuestera y Distribuciones S.A.C', 1, '2019-07-04 10:05:55', '2019-07-04 10:04:00', 110.00),
  (27, '20101681395', 'Automotriz Bavarian S.C.R.L', 0, '2019-07-04 10:25:08', '2019-01-21 10:20:00', 574.82),
  (28, '20101681395', 'Automotriz Bavarian S.C.R.L', 1, '2019-07-04 10:31:43', '2019-01-21 10:28:00', 635.70),
  (29, '10108700896', 'Autopartes Ericka', 1, '2019-07-04 10:37:25', '2019-01-21 10:35:00', 2000.00),
  (30, '20167921109', 'Fiamaster', 1, '2019-07-04 12:06:29', '2019-01-18 12:04:00', 31.18),
  (31, '20101912974', 'Imgesa', 1, '2019-07-04 12:12:59', '2019-01-15 12:11:00', 20.00),
  (32, '10085559902', 'J&M', 1, '2019-07-04 12:50:17', '2019-01-15 12:38:00', 1970.00),
  (33, '20100032881', 'Aba Singer & Cia S.A.C', 1, '2019-07-04 12:54:59', '2019-01-12 12:53:00', 7.78),
  (34, '10108700896', 'Autopartes Ericka', 1, '2019-07-04 14:24:04', '2019-01-12 14:20:00', 2105.00),
  (35, '20524583314', 'Germsa', 1, '2019-07-04 14:32:31', '2019-07-04 14:29:00', 173.86),
  (36, '20520588486', 'Divemotor', 1, '2019-07-04 14:48:08', '2019-07-04 14:46:00', 67.35),
  (37, '10085559902', 'J&M', 1, '2019-07-04 14:59:11', '2019-01-08 14:56:00', 2225.00),
  (38, '20503840121', 'Repsol Comercial S.A.C', 1, '2019-07-04 15:49:46', '2019-01-01 15:48:00', 129.11),
  (39, '20101681395', 'Automotriz Bavarian S.C.R.L', 1, '2019-07-05 09:13:39', '2019-01-04 09:12:00', 56.92),
  (40, '10085559902', 'J&M', 1, '2019-07-05 09:16:46', '2019-01-04 09:14:00', 2750.00),
  (41, '20101681395', 'Automotriz Bavarian S.C.R.L', 1, '2019-07-05 09:19:47', '2019-01-03 09:18:00', 61.43),
  (42, '10430915911', 'Global Parts', 1, '2019-07-05 09:29:42', '2019-01-03 09:28:00', 59.32),
  (43, '20100144922', 'Grupo Pana S.A', 1, '2019-07-05 09:41:37', '2019-01-03 09:38:00', 104.43),
  (44, '10179139842', 'Auto Partes \"Fabiana\"', 1, '2019-07-05 09:49:15', '2019-01-02 09:46:00', 2020.00),
  (45, '20167921109', 'Fiamaster', 1, '2019-07-05 10:04:21', '2019-12-28 10:03:00', 36.88),
  (46, '20100032881', 'Aba Singer & Cia S.A.C', 1, '2019-07-05 10:08:52', '2019-12-25 10:06:00', 16.02),
  (47, '20127765279', 'Coesti S.A', 1, '2019-07-05 10:56:26', '2018-12-26 10:53:00', 16.65),
  (48, '10404554226', 'Nelly Motors', 1, '2019-07-05 11:59:45', '2018-05-28 11:53:00', 1600.00),
  (49, '10098567505', 'Car Repuestos', 1, '2019-07-05 12:22:04', '2019-01-31 12:15:00', 36.44),
  (50, '20600349067', 'Wolf', 1, '2019-07-05 12:59:05', '2019-01-31 12:57:00', 3540.00),
  (51, '20101681395', 'Automotriz Bavarian S.C.R.L', 1, '2019-07-08 09:15:54', '2019-02-01 09:14:00', 151.37),
  (52, '20601919002', 'Comercializadora e Importadora Melo S.A.C', 1, '2019-07-08 09:19:42', '2019-02-01 09:17:00', 70.00),
  (53, '10098567505', 'Car Repuestos', 1, '2019-07-08 09:25:20', '2019-02-06 09:24:00', 15.00),
  (54, '20101681395', 'Automotriz Bavarian S.C.R.L', 1, '2019-07-08 09:35:12', '2019-02-06 09:33:00', 50.38),
  (55, '10727887941', 'Repuestos R&M', 1, '2019-07-08 09:38:00', '2019-02-06 09:36:00', 30.00),
  (56, '10098567505', 'Car Repuestos', 1, '2019-07-08 09:41:33', '2019-02-07 09:40:00', 18.00),
  (57, '10403148658', 'Fundas plásticas automotriz', 1, '2019-07-08 09:46:19', '2019-02-08 09:45:00', 310.00),
  (58, '20517793478', 'Frenos & Importaciones Generales E.I.R.L', 1, '2019-07-08 09:51:29', '2019-02-08 09:50:00', 298.00),
  (59, '20511141754', 'Nippon auto parts S.C.R.L', 1, '2019-07-10 10:13:32', '2019-02-15 10:11:00', 300.00),
  (60, '20517793478', 'Frenos & Importaciones Generales E.I.R.L', 1, '2019-07-10 10:17:42', '2019-02-18 10:16:00', 180.00),
  (61, '10098567505', 'Car Repuestos', 1, '2019-07-10 10:23:05', '2019-02-19 10:21:00', 29.66),
  (62, '10282932275', 'Tigator', 1, '2019-07-10 12:35:23', '2019-02-06 12:34:00', 27.99),
  (63, '20167921109', 'Fiamaster', 1, '2019-07-10 12:44:14', '2019-02-06 12:43:00', 61.46),
  (64, '20100144922', 'Grupo Pana S.A', 1, '2019-07-23 14:29:52', '2019-02-20 14:28:00', 413.71),
  (65, '20100144922', 'Grupo Pana S.A', 1, '2019-07-23 14:34:17', '2019-02-21 14:32:00', 309.40),
  (66, '20101681395', 'Automotriz Bavarian S.C.R.L', 1, '2019-07-23 14:42:05', '2019-02-22 14:40:00', 73.21),
  (67, '10098567505', 'Car Repuestos', 1, '2019-07-23 14:47:21', '2019-02-22 14:46:00', 28.81),
  (68, '20100144922', 'Grupo Pana S.A', 1, '2019-07-23 14:51:49', '2019-02-23 14:50:00', 120.33),
  (69, '20100144922', 'Grupo Pana S.A', 1, '2019-07-23 14:59:52', '2019-03-01 14:56:00', 60.20),
  (70, '10727887941', 'Repuestos R&M', 1, '2019-08-27 16:00:53', '2019-06-11 15:58:00', 72.00),
  (71, '20100085578', 'REPUESTOS NUEVOS S.A.', 1, '2019-08-28 15:56:06', '2019-06-19 16:32:00', 275.76),
  (72, '20511141754', 'NIPPON AUTO PARTS S.C.R.L', 1, '2019-08-28 16:26:51', '2019-06-21 16:14:00', 150.00);
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `comprasRepuestos`
  --
  
  CREATE TABLE `comprasRepuestos` (
    `id` int(11) NOT NULL,
    `idCompras` int(11) NOT NULL,
    `idPiezas` int(11) NOT NULL,
    `cantidad` int(11) NOT NULL,
    `costo` decimal(10,2) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Volcado de datos para la tabla `comprasRepuestos`
  --
  
  INSERT INTO `comprasRepuestos` (`id`, `idCompras`, `idPiezas`, `cantidad`, `costo`) VALUES
  (1, 1, 1, 100, 1000.00),
  (2, 3, 1, 100, 150.00),
  (3, 3, 2, 200, 300.00),
  (4, 4, 1, 1000, 1000.00),
  (5, 8, 1, 122, 123.00),
  (6, 8, 2, 100, 300.00),
  (7, 9, 111, 1, 2502.00),
  (8, 10, 87, 1, 150.00),
  (9, 11, 117, 12, 506.52),
  (10, 11, 118, 6, 49.43),
  (11, 11, 119, 1, 99.00),
  (12, 11, 120, 12, 103.74),
  (13, 12, 121, 12, 50.04),
  (14, 14, 122, 1, 10.84),
  (15, 15, 123, 1, 13.07),
  (16, 16, 124, 65, 1.00),
  (17, 17, 126, 1, 10.00),
  (18, 18, 127, 1, 159.49),
  (19, 19, 128, 1, 161.31),
  (20, 20, 129, 1, 45.55),
  (21, 21, 130, 1, 14.65),
  (22, 22, 132, 1, 8.47),
  (23, 22, 131, 1, 12.71),
  (24, 23, 122, 1, 28.85),
  (25, 24, 134, 1, 50.00),
  (26, 25, 137, 1, 38.15),
  (27, 25, 136, 1, 20.83),
  (28, 25, 135, 4, 12.47),
  (29, 26, 138, 1, 110.00),
  (30, 27, 139, 1, 157.17),
  (31, 27, 140, 1, 71.32),
  (32, 27, 141, 1, 138.61),
  (33, 27, 142, 1, 30.44),
  (34, 27, 143, 2, 6.10),
  (35, 27, 144, 1, 30.88),
  (36, 27, 145, 1, 140.30),
  (37, 28, 139, 1, 157.17),
  (38, 28, 140, 1, 71.32),
  (39, 28, 141, 1, 138.61),
  (40, 28, 142, 3, 91.32),
  (41, 28, 143, 2, 6.10),
  (42, 28, 144, 1, 30.88),
  (43, 28, 145, 1, 140.30),
  (44, 29, 146, 2, 190.00),
  (45, 29, 147, 2, 380.00),
  (46, 29, 148, 1, 1430.00),
  (47, 30, 133, 1, 31.18),
  (48, 31, 150, 1, 20.00),
  (49, 32, 147, 2, 950.00),
  (50, 32, 151, 1, 380.00),
  (51, 32, 152, 1, 350.00),
  (52, 32, 153, 2, 290.00),
  (53, 33, 154, 1, 7.78),
  (54, 34, 156, 1, 2105.00),
  (55, 35, 157, 2, 173.86),
  (56, 36, 158, 1, 67.35),
  (57, 37, 159, 2, 490.00),
  (58, 37, 160, 2, 390.00),
  (59, 37, 147, 1, 490.00),
  (60, 37, 161, 4, 450.00),
  (61, 37, 162, 4, 405.00),
  (62, 38, 163, 1, 129.11),
  (63, 39, 166, 1, 21.80),
  (64, 39, 167, 1, 35.12),
  (65, 40, 168, 1, 2750.00),
  (66, 41, 169, 1, 61.43),
  (67, 42, 170, 4, 50.85),
  (68, 42, 171, 1, 8.47),
  (69, 43, 172, 1, 44.97),
  (70, 43, 173, 2, 59.46),
  (71, 44, 174, 2, 980.00),
  (72, 44, 175, 1, 450.00),
  (73, 44, 176, 1, 590.00),
  (74, 45, 177, 1, 36.88),
  (75, 46, 178, 1, 16.02),
  (76, 47, 179, 1, 16.65),
  (77, 48, 180, 1, 1600.00),
  (78, 49, 171, 1, 23.73),
  (79, 49, 170, 1, 12.71),
  (80, 50, 183, 4, 1500.00),
  (81, 50, 182, 8, 2040.00),
  (82, 51, 184, 1, 151.37),
  (83, 52, 185, 1, 70.00),
  (84, 53, 170, 1, 15.00),
  (85, 54, 186, 1, 50.38),
  (86, 55, 187, 4, 30.00),
  (87, 56, 188, 1, 18.00),
  (88, 57, 189, 1, 310.00),
  (89, 58, 190, 1, 298.00),
  (90, 59, 192, 1, 100.00),
  (91, 59, 193, 2, 200.00),
  (92, 60, 194, 1, 180.00),
  (93, 61, 195, 1, 21.19),
  (94, 61, 196, 1, 8.47),
  (95, 62, 197, 1, 27.99),
  (96, 63, 198, 1, 61.46),
  (97, 64, 219, 20, 413.71),
  (98, 65, 220, 5, 196.68),
  (99, 65, 221, 4, 112.72),
  (100, 66, 222, 1, 31.48),
  (101, 66, 223, 1, 41.73),
  (102, 67, 225, 1, 16.10),
  (103, 67, 224, 1, 12.71),
  (104, 68, 226, 1, 120.33),
  (105, 69, 170, 2, 60.20),
  (106, 70, 241, 1, 25.00),
  (107, 70, 242, 1, 35.00),
  (108, 70, 243, 1, 12.00),
  (109, 71, 244, 1, 141.81),
  (110, 71, 245, 1, 133.95),
  (111, 72, 246, 1, 150.00);
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `datosGenerales`
  --
  
  CREATE TABLE `datosGenerales` (
    `id` int(11) NOT NULL,
    `descripcion` varchar(90) NOT NULL,
    `valor` varchar(90) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Volcado de datos para la tabla `datosGenerales`
  --
  
  INSERT INTO `datosGenerales` (`id`, `descripcion`, `valor`) VALUES
  (1, 'tipoCambio', '3.21');
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `entregaImagen`
  --
  
  CREATE TABLE `entregaImagen` (
    `id` int(11) NOT NULL,
    `idEntregas` int(11) NOT NULL,
    `imagen` varchar(120) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Volcado de datos para la tabla `entregaImagen`
  --
  
  INSERT INTO `entregaImagen` (`id`, `idEntregas`, `imagen`) VALUES
  (1, 3, '5cbe31bb4098c.jpg'),
  (2, 4, '5cbf842bf2957.jpg'),
  (3, 4, '5cbf842fd9eb7.jpg'),
  (4, 4, '5cbf842fdbcee.jpg'),
  (5, 5, '5cbf847ab15df.jpg'),
  (6, 5, '5cbf847c2666c.jpg'),
  (7, 5, '5cbf847c3836d.jpg'),
  (8, 6, '5cbf8b9801c74.jpg'),
  (9, 6, '5cbf8b9c23a2c.jpg'),
  (10, 8, '5cc0a30b42348.jpg'),
  (11, 8, '5cc7d28a15ef3.png'),
  (12, 8, '5cc7d2d5e8804.png'),
  (13, 9, '5cc9c01a518a6.jpg'),
  (14, 10, '5cdaf02d2d7f3.jpeg'),
  (15, 11, '5cdc33e6e3a68.jpeg'),
  (16, 12, '5cdc9eae7312c.jpg'),
  (17, 13, '5ce2ef15c1b5b.png');
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `entregas`
  --
  
  CREATE TABLE `entregas` (
    `id` int(11) NOT NULL,
    `idVehiculos` int(11) NOT NULL,
    `fechaRegistro` datetime NOT NULL,
    `fechaServicio` datetime NOT NULL,
    `idEstados` int(11) NOT NULL,
    `observaciones` text NOT NULL,
    `kilometraje` int(11) NOT NULL,
    `factura` int(11) NOT NULL DEFAULT 0
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Volcado de datos para la tabla `entregas`
  --
  
  INSERT INTO `entregas` (`id`, `idVehiculos`, `fechaRegistro`, `fechaServicio`, `idEstados`, `observaciones`, `kilometraje`, `factura`) VALUES
  (1, 1, '2019-04-16 12:15:50', '2019-04-16 00:00:00', 0, '', 1234, 0),
  (2, 1, '2019-04-16 12:16:48', '2019-04-16 00:00:00', 0, '', 1234, 0),
  (3, 1, '2019-04-22 16:27:23', '2019-04-22 00:00:00', 0, 'fafadf', 1234, 0),
  (4, 1, '2019-04-23 16:31:23', '2019-04-23 00:00:00', 0, 'nnf', 2000, 0),
  (5, 1, '2019-04-23 16:32:42', '2019-04-23 00:00:00', 0, 'nnf', 2000, 0),
  (6, 1, '2019-04-23 17:03:03', '2019-04-23 00:00:00', 0, 'dsdsd', 123, 0),
  (7, 11, '2019-04-24 12:54:53', '2019-04-24 00:00:00', 0, '- Adaptar motor\r\n- Tarque de gasolina\r\n-01 Radiador de agua\r\n-01 Bomba de gasolina\r\n-Linea de escape\r\n-01 Kit de repuestos nuevos\r\n-02 puntas de palier\r\n-Mantenimiento de palier\r\n-01 Volante tapa negra\r\n-01 Kit de embriague \r\n-02 Mangueras de radiador\r\n-01 Bomba de embriague\r\n-01 tapa de distribuidor', 180000, 0),
  (8, 11, '0000-00-00 00:00:00', '2019-04-24 00:00:00', 0, '- Adaptar motor\r\n- Tarque de gasolina\r\n-01 Radiador de agua\r\n-01 Bomba de gasolina\r\n-Linea de escape\r\n-01 Kit de repuestos nuevos\r\n-02 puntas de palier\r\n-Mantenimiento de palier\r\n-01 Volante tapa negra\r\n-01 Kit de embriague \r\n-02 Mangueras de radiador\r\n-01 Bomba de embriague\r\n-01 tapa de distribuidor', 180000, 0),
  (9, 12, '2019-05-01 10:49:46', '2019-05-01 00:00:00', 0, 'NINGUNA', 87000, 0),
  (10, 13, '0000-00-00 00:00:00', '2019-05-13 00:00:00', 1, '', 15, 0),
  (11, 14, '0000-00-00 00:00:00', '2019-05-14 00:00:00', 0, '-01 Kit de empaque\r\n-01 Juego de anillos\r\n-01 Metal de biela\r\n-01 Kit de distribución\r\n-Mano de obra\r\n- 01 Galón de aceite\r\n-01 Filtro de aceite\r\n-01 Galón de refrigerante\r\n01 Juego de bujías\r\n-01 Filtro de aire', 12345678, 0),
  (12, 15, '2019-05-15 18:20:14', '2019-05-15 00:00:00', 0, '', 777, 0),
  (13, 15, '2019-05-20 13:16:53', '2019-05-20 00:00:00', 0, 'fff', 5000, 0),
  (14, 16, '0000-00-00 00:00:00', '2019-05-13 00:00:00', 1, '', 1745, 0),
  (15, 18, '2019-05-27 18:50:08', '2019-05-27 00:00:00', 0, 'NINGUNA PRUEBAS', 5600, 0),
  (16, 19, '0000-00-00 00:00:00', '2019-05-27 00:00:00', 1, '', 111, 0),
  (17, 20, '2019-05-28 10:02:51', '2019-05-23 00:00:00', 1, '', 111, 0),
  (18, 21, '2019-05-28 13:24:13', '2019-05-28 00:00:00', 0, 'adfadf', 234234, 0),
  (19, 21, '2019-05-28 13:31:40', '2019-05-28 00:00:00', 0, 'nose', 3456, 0),
  (20, 21, '2019-05-28 14:34:13', '2019-05-28 00:00:00', 0, 'adad', 4500, 0),
  (21, 22, '0000-00-00 00:00:00', '2019-05-28 00:00:00', 1, '', 111, 0),
  (22, 23, '0000-00-00 00:00:00', '2019-06-28 00:00:00', 0, '', 111, 0),
  (23, 25, '0000-00-00 00:00:00', '2019-07-01 00:00:00', 1, '', 0, 0),
  (24, 26, '2019-07-10 10:02:23', '2019-07-06 00:00:00', 1, '', 0, 0),
  (25, 27, '0000-00-00 00:00:00', '2019-07-10 00:00:00', 1, '', 1111, 0),
  (26, 28, '0000-00-00 00:00:00', '2019-07-10 00:00:00', 1, '', 1111, 0),
  (27, 24, '0000-00-00 00:00:00', '2019-07-10 00:00:00', 1, '', 1111, 0),
  (28, 29, '2019-07-15 09:16:44', '2019-07-13 00:00:00', 1, '', 11111, 0),
  (29, 30, '2019-07-15 11:06:45', '2019-07-11 00:00:00', 1, '', 111111, 0),
  (30, 31, '0000-00-00 00:00:00', '2019-07-15 00:00:00', 1, '', 1111, 0),
  (31, 32, '0000-00-00 00:00:00', '2019-07-15 00:00:00', 1, '', 1111, 0),
  (32, 34, '0000-00-00 00:00:00', '2019-07-22 00:00:00', 1, '', 11111, 0),
  (33, 35, '2019-07-23 11:06:13', '2019-07-22 00:00:00', 1, '', 111111, 0),
  (34, 34, '2019-08-20 13:44:27', '2019-07-22 00:00:00', 0, 'alineamiento ', 111111, 0),
  (35, 34, '2019-08-20 13:58:17', '2019-08-20 00:00:00', 0, '', 111111, 0),
  (36, 36, '0000-00-00 00:00:00', '2019-08-17 00:00:00', 1, '', 11111111, 0),
  (37, 37, '0000-00-00 00:00:00', '2019-07-26 00:00:00', 1, '', 11111, 0),
  (38, 38, '0000-00-00 00:00:00', '2019-08-15 00:00:00', 1, '', 11111, 0),
  (39, 40, '0000-00-00 00:00:00', '2019-08-13 00:00:00', 1, '', 1111111, 0),
  (40, 42, '0000-00-00 00:00:00', '2019-08-21 00:00:00', 1, '', 111111, 0),
  (41, 43, '0000-00-00 00:00:00', '2019-08-16 00:00:00', 1, '', 1111111, 0),
  (42, 44, '0000-00-00 00:00:00', '2019-08-06 00:00:00', 1, '', 2480, 0),
  (43, 45, '0000-00-00 00:00:00', '2019-08-12 00:00:00', 1, '', 1745, 0),
  (44, 46, '0000-00-00 00:00:00', '2019-08-24 00:00:00', 1, '', 7097, 0);
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `entregaServicios`
  --
  
  CREATE TABLE `entregaServicios` (
    `id` int(11) NOT NULL,
    `idPersonas` int(11) NOT NULL,
    `idServicios` int(11) NOT NULL,
    `idEntregas` int(11) NOT NULL,
    `monto` decimal(10,2) NOT NULL,
    `observacionesServicio` text NOT NULL,
    `idEstados` int(11) NOT NULL DEFAULT 1,
    `fechaRegistro` datetime NOT NULL,
    `fechaServicio` datetime NOT NULL,
    `montoTotal` decimal(10,2) NOT NULL,
    `montoRepuestos` decimal(10,2) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Volcado de datos para la tabla `entregaServicios`
  --
  
  INSERT INTO `entregaServicios` (`id`, `idPersonas`, `idServicios`, `idEntregas`, `monto`, `observacionesServicio`, `idEstados`, `fechaRegistro`, `fechaServicio`, `montoTotal`, `montoRepuestos`) VALUES
  (1, 1, 1, 2, 1234.00, 'fefqe', 1, '2019-04-17 13:44:39', '2019-04-17 00:00:00', 154234.00, 153000.00),
  (2, 1, 1, 2, 345.00, '', 1, '2019-04-22 16:17:48', '2019-04-22 00:00:00', 345.00, 0.00),
  (3, 1, 1, 5, 1234.00, 'dasda', 0, '2019-04-23 16:33:24', '2019-04-23 00:00:00', 4834.00, 3600.00),
  (4, 1, 1, 5, 123.00, 'cdf', 0, '2019-04-23 16:46:41', '2019-04-23 00:00:00', 123.00, 0.00),
  (5, 1, 1, 5, 1234.00, 'dwd', 0, '2019-04-23 16:47:09', '2019-04-23 00:00:00', 4834.00, 3600.00),
  (6, 1, 1, 5, 345.00, 'fef', 1, '2019-04-23 16:47:34', '2019-04-23 00:00:00', 945.00, 600.00),
  (7, 1, 5, 8, 2000.00, '.', 1, '2019-04-24 13:03:52', '2019-04-24 00:00:00', 2700.00, 700.00),
  (8, 1, 6, 8, 140.00, '.', 1, '2019-04-24 13:14:20', '2019-04-24 00:00:00', 140.00, 0.00),
  (9, 1, 1, 9, 200.00, 'PASTILLAS DELANTERAS Y FLUIDOS', 1, '2019-05-01 10:52:14', '2019-05-01 00:00:00', 256.00, 56.00),
  (10, 1, 4, 9, 100.00, 'gegetg', 1, '2019-05-01 20:22:49', '2019-05-01 00:00:00', 125.00, 25.00),
  (11, 0, 0, 9, 0.00, '', 1, '2019-05-01 20:22:53', '2019-05-01 00:00:00', 0.00, 0.00),
  (12, 0, 0, 9, 0.00, '', 1, '2019-05-01 20:23:51', '2019-05-01 00:00:00', 0.00, 0.00),
  (13, 0, 5, 10, 200.00, '', 1, '2019-05-14 12:13:49', '2019-05-14 00:00:00', 200.00, 0.00),
  (14, 1, 5, 10, 200.00, '', 0, '2019-05-15 10:57:24', '2019-05-15 00:00:00', 200.00, 0.00),
  (15, 0, 5, 10, 2500.00, '', 1, '2019-05-15 10:58:45', '2019-05-15 00:00:00', 2500.00, 0.00),
  (16, 3, 5, 12, 2500.00, 'NINGUNA', 1, '2019-05-15 18:20:40', '2019-05-15 00:00:00', 2500.00, 0.00),
  (17, 0, 5, 10, 2500.00, '', 1, '2019-05-20 09:53:30', '2019-05-20 00:00:00', 2500.00, 0.00),
  (18, 3, 1, 13, 75.00, 'algo', 1, '2019-05-20 13:17:57', '2019-05-20 00:00:00', 106.26, 31.26),
  (19, 3, 5, 10, 2500.00, '', 1, '2019-05-27 10:24:30', '2019-05-13 00:00:00', 3162.00, 662.00),
  (20, 3, 10, 14, 100.00, '', 0, '2019-05-27 11:55:38', '2019-05-27 00:00:00', 100.00, 0.00),
  (21, 3, 5, 15, 2500.00, '', 0, '2019-05-27 18:50:45', '2019-05-27 00:00:00', 2500.00, 0.00),
  (22, 4, 5, 15, 2500.00, '', 1, '2019-05-27 18:52:00', '2019-05-27 00:00:00', 2500.00, 0.00),
  (23, 3, 11, 16, 180.00, '', 1, '2019-05-28 09:48:50', '2019-05-27 00:00:00', 320.00, 140.00),
  (24, 3, 1, 17, 75.00, '', 0, '2019-05-28 11:36:32', '2019-05-28 00:00:00', 75.00, 0.00),
  (25, 3, 5, 17, 2500.00, '', 0, '2019-05-28 11:36:57', '2019-05-28 00:00:00', 2500.00, 0.00),
  (26, 3, 12, 17, 500.00, '', 1, '2019-05-28 11:39:19', '2019-05-28 00:00:00', 500.00, 0.00),
  (27, 3, 5, 18, 2500.00, '22', 1, '2019-05-28 13:25:27', '2019-05-28 00:00:00', 2500.00, 0.00),
  (28, 3, 4, 19, 100.00, '', 0, '2019-05-28 13:35:55', '2019-05-28 00:00:00', 100.00, 0.00),
  (29, 4, 5, 19, 2500.00, '', 0, '2019-05-28 14:33:36', '2019-05-28 00:00:00', 2500.00, 0.00),
  (30, 3, 9, 20, 2200.00, 'edaed', 0, '2019-05-28 14:34:28', '2019-05-28 00:00:00', 2200.00, 0.00),
  (31, 5, 12, 20, 500.00, '', 0, '2019-05-28 14:34:48', '2019-05-28 00:00:00', 500.00, 0.00),
  (32, 3, 13, 17, 300.00, '', 1, '2019-05-28 15:13:27', '2019-05-28 00:00:00', 300.00, 0.00),
  (33, 3, 14, 17, 150.00, '', 1, '2019-05-28 15:13:49', '2019-05-28 00:00:00', 150.00, 0.00),
  (34, 3, 15, 17, 30.00, '', 1, '2019-05-28 15:14:00', '2019-05-28 00:00:00', 30.00, 0.00),
  (35, 3, 16, 17, 50.00, '', 1, '2019-05-28 15:14:11', '2019-05-28 00:00:00', 50.00, 0.00),
  (36, 3, 17, 17, 280.00, '', 1, '2019-05-28 15:14:23', '2019-05-28 00:00:00', 1130.00, 850.00),
  (37, 3, 18, 17, 180.00, '', 1, '2019-05-28 15:14:33', '2019-05-28 00:00:00', 180.00, 0.00),
  (38, 3, 19, 21, 400.00, '', 1, '2019-05-29 12:29:34', '2019-05-29 00:00:00', 1430.00, 1030.00),
  (39, 3, 21, 23, 700.00, '', 1, '2019-07-10 09:39:03', '2019-07-01 00:00:00', 700.00, 0.00),
  (40, 3, 22, 23, 220.00, '', 1, '2019-07-10 09:39:30', '2019-07-01 00:00:00', 220.00, 0.00),
  (41, 3, 23, 23, 650.00, '', 1, '2019-07-10 09:44:43', '2019-07-01 00:00:00', 650.00, 0.00),
  (42, 3, 24, 23, 250.00, '', 1, '2019-07-10 09:45:34', '2019-07-01 00:00:00', 250.00, 0.00),
  (43, 3, 25, 23, 200.00, '', 1, '2019-07-10 09:46:29', '2019-07-01 00:00:00', 200.00, 0.00),
  (44, 3, 26, 23, 280.00, '', 1, '2019-07-10 09:48:02', '2019-07-01 00:00:00', 280.00, 0.00),
  (45, 3, 27, 23, 0.00, '', 0, '2019-07-10 09:48:21', '2019-07-01 00:00:00', 0.00, 0.00),
  (46, 3, 28, 25, 0.00, '', 1, '2019-07-12 09:55:00', '2019-07-10 00:00:00', 0.00, 0.00),
  (47, 3, 29, 25, 1000.00, '', 1, '2019-07-12 09:55:24', '2019-07-10 00:00:00', 1000.00, 0.00),
  (48, 3, 30, 26, 750.00, '', 1, '2019-07-12 10:31:09', '2019-07-10 00:00:00', 750.00, 0.00),
  (49, 3, 27, 23, 480.00, '', 1, '2019-07-12 10:50:19', '2019-07-01 00:00:00', 480.00, 0.00),
  (50, 3, 31, 28, 120.00, '', 1, '2019-07-15 09:17:12', '2019-07-13 00:00:00', 560.00, 440.00),
  (51, 3, 32, 23, 130.00, '', 1, '2019-07-15 10:53:53', '2019-07-15 00:00:00', 390.00, 260.00),
  (52, 3, 33, 29, 280.00, '', 1, '2019-07-15 11:13:21', '2019-07-11 00:00:00', 820.00, 540.00),
  (53, 3, 34, 30, 320.00, '', 0, '2019-07-15 12:50:59', '2019-07-08 00:00:00', 320.00, 0.00),
  (54, 3, 35, 30, 210.00, '', 0, '2019-07-15 12:51:34', '2019-07-08 00:00:00', 210.00, 0.00),
  (55, 3, 34, 30, 320.00, '', 1, '2019-07-15 14:12:19', '2019-07-08 00:00:00', 886.00, 566.00),
  (56, 3, 35, 30, 210.00, '', 1, '2019-07-15 14:13:18', '2019-07-08 00:00:00', 210.00, 0.00),
  (57, 3, 36, 30, 32.00, '', 1, '2019-07-15 14:16:55', '2019-07-08 00:00:00', 252.00, 220.00),
  (58, 3, 31, 30, 120.00, '', 1, '2019-07-15 15:47:21', '2019-07-08 00:00:00', 120.00, 0.00),
  (59, 3, 37, 27, 180.00, '', 0, '2019-07-16 14:16:25', '2019-07-16 00:00:00', 180.00, 0.00),
  (60, 3, 31, 27, 100.00, '', 1, '2019-07-16 14:17:08', '2019-07-10 00:00:00', 428.00, 328.00),
  (61, 3, 37, 27, 180.00, '', 1, '2019-07-16 14:17:35', '2019-07-10 00:00:00', 180.00, 0.00),
  (62, 3, 38, 31, 80.00, '', 1, '2019-07-16 18:15:32', '2019-07-15 00:00:00', 490.00, 410.00),
  (63, 3, 39, 31, 88.00, '', 1, '2019-07-16 18:15:53', '2019-07-15 00:00:00', 88.00, 0.00),
  (64, 3, 45, 32, 0.00, '', 0, '2019-07-23 10:05:30', '2019-07-22 00:00:00', 0.00, 0.00),
  (65, 3, 31, 32, 0.00, '', 0, '2019-07-23 10:06:00', '2019-07-22 00:00:00', 0.00, 0.00),
  (66, 3, 46, 32, 0.00, '', 0, '2019-07-23 10:06:35', '2019-07-22 00:00:00', 0.00, 0.00),
  (67, 3, 47, 32, 0.00, '', 0, '2019-07-23 10:21:32', '2019-07-22 00:00:00', 0.00, 0.00),
  (68, 3, 48, 32, 0.00, '', 0, '2019-07-23 10:26:14', '2019-07-22 00:00:00', 0.00, 0.00),
  (69, 3, 46, 32, 120.00, '', 1, '2019-08-20 14:02:31', '2019-08-20 00:00:00', 230.00, 110.00),
  (70, 3, 31, 32, 280.00, '', 1, '2019-08-20 14:03:21', '2019-08-20 00:00:00', 280.00, 0.00),
  (71, 3, 47, 32, 250.00, 'sprint 500', 1, '2019-08-20 14:04:20', '2019-08-18 00:00:00', 250.00, 0.00),
  (72, 3, 48, 32, 110.00, '', 1, '2019-08-20 14:05:31', '2019-08-18 00:00:00', 110.00, 0.00),
  (73, 4, 1, 32, 0.00, '', 1, '2019-08-20 14:20:21', '2019-08-20 00:00:00', 336.00, 336.00),
  (74, 3, 58, 32, 300.00, '', 1, '2019-08-20 15:50:44', '2019-08-20 00:00:00', 300.00, 0.00),
  (75, 3, 59, 32, 210.00, '', 1, '2019-08-20 15:55:42', '2019-08-18 00:00:00', 210.00, 0.00),
  (76, 3, 55, 32, 80.00, '', 1, '2019-08-20 15:58:01', '2019-08-20 00:00:00', 80.00, 0.00),
  (77, 3, 57, 32, 200.00, '', 1, '2019-08-20 15:58:34', '2019-08-18 00:00:00', 200.00, 0.00),
  (78, 3, 56, 32, 590.00, '', 1, '2019-08-20 15:59:17', '2019-08-20 00:00:00', 590.00, 0.00),
  (79, 3, 60, 32, 80.00, '', 1, '2019-08-20 16:06:21', '2019-08-18 00:00:00', 80.00, 0.00),
  (80, 3, 61, 32, 250.00, '', 1, '2019-08-20 16:17:32', '2019-08-18 00:00:00', 250.00, 0.00),
  (81, 3, 62, 32, 120.00, '', 1, '2019-08-20 16:19:57', '2019-08-19 00:00:00', 120.00, 0.00),
  (82, 10, 1, 36, 0.00, '', 0, '2019-08-20 16:51:42', '2019-08-20 00:00:00', 232.00, 232.00),
  (83, 10, 31, 36, 150.00, '', 0, '2019-08-20 16:54:27', '2019-08-20 00:00:00', 150.00, 0.00),
  (84, 10, 44, 36, 120.00, '', 0, '2019-08-20 16:55:12', '2019-08-17 00:00:00', 120.00, 0.00),
  (85, 6, 44, 36, 120.00, '', 1, '2019-08-20 17:01:30', '2019-08-17 00:00:00', 120.00, 0.00),
  (86, 6, 1, 36, 0.00, '', 1, '2019-08-20 17:02:09', '2019-08-17 00:00:00', 232.00, 232.00),
  (87, 6, 31, 36, 150.00, '', 1, '2019-08-20 17:02:44', '2019-08-18 00:00:00', 150.00, 0.00),
  (88, 6, 63, 36, 80.00, '', 1, '2019-08-20 17:08:40', '2019-08-18 00:00:00', 80.00, 0.00),
  (89, 8, 31, 37, 180.00, '', 1, '2019-08-20 17:41:17', '2019-07-26 00:00:00', 180.00, 0.00),
  (90, 8, 1, 37, 0.00, '', 1, '2019-08-20 17:43:47', '2019-07-26 00:00:00', 230.00, 230.00),
  (91, 8, 64, 37, 100.00, '', 1, '2019-08-20 17:52:57', '2019-07-26 00:00:00', 100.00, 0.00),
  (92, 8, 65, 37, 35.00, '', 1, '2019-08-20 17:54:42', '2019-07-26 00:00:00', 35.00, 0.00),
  (93, 8, 66, 37, 130.00, '', 1, '2019-08-20 17:57:29', '2019-08-20 00:00:00', 154.00, 24.00),
  (94, 8, 67, 37, 32.00, '', 1, '2019-08-20 18:14:51', '2019-07-26 00:00:00', 32.00, 0.00),
  (95, 8, 68, 37, 150.00, '', 1, '2019-08-20 18:49:42', '2019-07-26 00:00:00', 150.00, 0.00),
  (96, 8, 68, 37, 150.00, '', 0, '2019-08-20 18:49:42', '2019-07-26 00:00:00', 150.00, 0.00),
  (97, 8, 32, 37, 140.00, '', 1, '2019-08-20 18:52:45', '2019-07-26 00:00:00', 140.00, 0.00),
  (98, 8, 69, 37, 90.00, '', 1, '2019-08-20 18:56:47', '2019-07-26 00:00:00', 90.00, 0.00),
  (99, 8, 70, 37, 40.00, '', 1, '2019-08-20 19:01:36', '2019-07-26 00:00:00', 42.00, 2.00),
  (100, 8, 71, 37, 38.00, '', 1, '2019-08-20 19:05:06', '2019-07-26 00:00:00', 38.00, 0.00),
  (101, 8, 61, 37, 172.00, '', 1, '2019-08-20 19:15:57', '2019-07-26 00:00:00', 172.00, 0.00),
  (102, 6, 17, 39, 320.00, '', 1, '2019-08-21 16:32:28', '2019-08-21 00:00:00', 320.00, 0.00),
  (103, 6, 1, 39, 60.00, '', 1, '2019-08-21 16:33:22', '2019-08-21 00:00:00', 250.00, 190.00),
  (104, 6, 72, 39, 50.00, '', 1, '2019-08-21 16:41:22', '2019-08-21 00:00:00', 50.00, 0.00),
  (105, 6, 31, 39, 180.00, '', 1, '2019-08-21 16:42:21', '2019-08-21 00:00:00', 180.00, 0.00),
  (106, 6, 74, 39, 120.00, '', 1, '2019-08-21 16:43:02', '2019-08-21 00:00:00', 120.00, 0.00),
  (107, 6, 74, 39, 120.00, '', 0, '2019-08-21 16:43:02', '2019-08-21 00:00:00', 120.00, 0.00),
  (108, 6, 12, 40, 500.00, '', 1, '2019-08-21 17:45:43', '2019-08-21 00:00:00', 500.00, 0.00),
  (109, 6, 14, 40, 150.00, '', 1, '2019-08-21 17:46:10', '2019-08-21 00:00:00', 150.00, 0.00),
  (110, 6, 16, 40, 80.00, '', 1, '2019-08-21 17:47:11', '2019-08-21 00:00:00', 80.00, 0.00),
  (111, 6, 35, 40, 290.00, '', 1, '2019-08-21 17:48:27', '2019-08-21 00:00:00', 290.00, 0.00),
  (112, 6, 34, 40, 320.00, '', 1, '2019-08-21 17:56:26', '2019-08-21 00:00:00', 320.00, 0.00),
  (113, 7, 31, 41, 180.00, '', 0, '2019-08-22 12:14:32', '2019-08-22 00:00:00', 180.00, 0.00),
  (114, 5, 73, 41, 290.00, '', 1, '2019-08-22 12:22:26', '2019-08-22 00:00:00', 290.00, 0.00),
  (115, 7, 79, 41, 550.00, '', 0, '2019-08-22 13:18:17', '2019-08-16 00:00:00', 700.00, 150.00),
  (116, 8, 61, 41, 30.00, '', 0, '2019-08-22 14:38:45', '2019-08-22 00:00:00', 30.00, 0.00),
  (117, 3, 80, 14, 0.00, '', 1, '2019-08-22 16:41:35', '2019-08-22 00:00:00', 1680.00, 1680.00),
  (118, 3, 61, 14, 250.00, '', 0, '2019-08-22 17:16:37', '2019-08-22 00:00:00', 250.00, 0.00),
  (119, 3, 61, 14, 500.00, '', 1, '2019-08-22 17:18:59', '2019-08-22 00:00:00', 500.00, 0.00),
  (120, 3, 81, 14, 80.00, '', 1, '2019-08-22 17:22:01', '2019-08-22 00:00:00', 80.00, 0.00),
  (121, 9, 31, 42, 80.00, '', 0, '2019-08-22 18:01:56', '2019-08-06 00:00:00', 80.00, 0.00),
  (122, 9, 31, 42, 80.00, '', 1, '2019-08-22 18:01:56', '2019-08-06 00:00:00', 80.00, 0.00),
  (123, 8, 61, 42, 500.00, '', 1, '2019-08-22 18:12:27', '2019-08-07 00:00:00', 528.00, 28.00),
  (124, 7, 83, 41, 200.00, '', 1, '2019-08-23 09:34:11', '2019-08-17 00:00:00', 700.00, 500.00),
  (125, 7, 31, 41, 110.00, '', 0, '2019-08-23 09:48:47', '2019-08-23 00:00:00', 110.00, 0.00),
  (126, 7, 31, 41, 110.00, '', 1, '2019-08-23 09:50:43', '2019-08-17 00:00:00', 110.00, 0.00),
  (127, 4, 9, 43, 1800.00, '', 1, '2019-08-23 11:41:13', '2019-08-12 00:00:00', 1800.00, 0.00),
  (128, 10, 16, 38, 50.00, '', 1, '2019-08-23 18:02:03', '2019-08-15 00:00:00', 280.00, 230.00),
  (129, 7, 1, 44, 70.00, '', 1, '2019-08-24 16:17:50', '2019-08-24 00:00:00', 155.00, 85.00),
  (130, 7, 44, 44, 0.00, '', 1, '2019-08-24 16:18:24', '2019-08-24 00:00:00', 0.00, 0.00);
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `imagenEntregas`
  --
  
  CREATE TABLE `imagenEntregas` (
    `id` int(11) NOT NULL,
    `imagen` varchar(20) NOT NULL,
    `idEntregas` int(11) NOT NULL,
    `idEntregaServicios` int(11) NOT NULL,
    `idEstados` int(11) NOT NULL DEFAULT 1
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Volcado de datos para la tabla `imagenEntregas`
  --
  
  INSERT INTO `imagenEntregas` (`id`, `imagen`, `idEntregas`, `idEntregaServicios`, `idEstados`) VALUES
  (1, '0.PNG', 2, 1, 0),
  (2, '1.PNG', 2, 1, 0),
  (3, '0.PNG', 2, 1, 0),
  (4, '1.PNG', 2, 1, 0),
  (5, '0.PNG', 2, 1, 0),
  (6, '0.PNG', 2, 1, 0),
  (7, '0.PNG', 2, 1, 0),
  (8, '1.PNG', 2, 1, 0),
  (9, '0.PNG', 2, 1, 0),
  (10, '1.PNG', 2, 1, 0),
  (11, '0.PNG', 2, 1, 0),
  (12, '1.PNG', 2, 1, 0),
  (13, '2.PNG', 2, 1, 0),
  (14, '3.PNG', 2, 1, 0),
  (15, '0.PNG', 2, 1, 0),
  (16, '1.PNG', 2, 1, 0),
  (17, '0.PNG', 2, 1, 0),
  (18, '5cbe202814119.PNG', 2, 1, 0),
  (19, '5cbe28431741a.PNG', 2, 1, 0),
  (20, '5cbe2ed681444.PNG', 2, 1, 0),
  (21, '5cbe2ed68c8bd.PNG', 2, 1, 0),
  (22, '5cbe2ed6a4216.PNG', 2, 1, 0),
  (23, '5cbe2ee2e7656.PNG', 2, 1, 0),
  (24, '5cbe2ee30bea3.PNG', 2, 1, 0),
  (25, '5cbe2ee3206c8.PNG', 2, 1, 0),
  (26, '5cbe2ee33106c.PNG', 2, 1, 0),
  (27, '5cbe2f1ab3694.PNG', 2, 1, 1),
  (28, '5cbe2f1ad53fe.PNG', 2, 1, 1),
  (29, '5cbe2f87dba38.jpg', 2, 2, 1),
  (30, '5cbf84b3e8ffb.jpg', 5, 3, 0),
  (31, '5cbf84b3eb7b5.jpg', 5, 3, 0),
  (32, '5cbf84b677502.jpg', 5, 3, 0),
  (33, '5cbf84b679d79.jpg', 5, 3, 0),
  (34, '5cbf88508527b.jpg', 5, 6, 1),
  (35, '5cbf88548cb7e.jpg', 5, 6, 1),
  (36, '5cbf8a2aa1255.jpg', 5, 6, 1),
  (37, '5cbf8a2e2f0ff.jpg', 5, 6, 1),
  (38, '5cc9c1c5606d9.jpg', 9, 9, 1);
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `marcas`
  --
  
  CREATE TABLE `marcas` (
    `id` int(11) NOT NULL,
    `descripcion` varchar(90) NOT NULL,
    `idEstados` int(11) NOT NULL,
    `fechaRegistro` datetime NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Volcado de datos para la tabla `marcas`
  --
  
  INSERT INTO `marcas` (`id`, `descripcion`, `idEstados`, `fechaRegistro`) VALUES
  (1, 'Toyota', 1, '0000-00-00 00:00:00'),
  (2, 'Audi', 1, '0000-00-00 00:00:00'),
  (3, 'Kia', 1, '0000-00-00 00:00:00'),
  (4, 'Nuevo', 0, '2019-04-17 14:55:57'),
  (5, 'Nuevo 2', 0, '2019-04-17 14:57:20'),
  (6, 'Hyundai', 1, '2019-04-23 16:57:17'),
  (7, 'Honda', 1, '2019-05-01 10:58:47'),
  (8, 'Mitsubichi', 1, '2019-05-14 11:25:40'),
  (9, 'MG', 1, '2019-05-15 10:26:50'),
  (10, 'Toyota', 1, '2019-05-15 15:17:20'),
  (11, 'VW', 1, '2019-05-20 10:09:35'),
  (12, 'Toyota', 1, '2019-05-20 10:10:38'),
  (13, 'Honda', 1, '2019-05-20 10:13:20'),
  (14, 'Honda', 1, '2019-05-20 10:20:04'),
  (15, 'Datsun', 1, '2019-05-20 10:21:12'),
  (16, 'Subaru', 1, '2019-05-20 10:35:12'),
  (17, 'Mercedez', 1, '2019-05-20 10:51:59'),
  (18, 'BMW', 1, '2019-05-20 11:56:05'),
  (19, 'nu', 1, '2019-05-28 09:38:34'),
  (20, 'Nissan', 1, '2019-05-28 09:38:52'),
  (21, 'Suzuki', 1, '2019-07-10 09:17:56');
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `modelos`
  --
  
  CREATE TABLE `modelos` (
    `id` int(11) NOT NULL,
    `descripcion` varchar(90) NOT NULL,
    `idMarcas` int(11) NOT NULL,
    `idEstados` int(11) NOT NULL,
    `fechaRegistro` datetime NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Volcado de datos para la tabla `modelos`
  --
  
  INSERT INTO `modelos` (`id`, `descripcion`, `idMarcas`, `idEstados`, `fechaRegistro`) VALUES
  (1, 'Yaris', 1, 1, '0000-00-00 00:00:00'),
  (2, 'Tucson', 6, 1, '0000-00-00 00:00:00'),
  (3, 'AudiModelo2', 2, 0, '2019-04-17 15:06:16'),
  (4, 'Rio', 3, 1, '2019-04-22 16:14:17'),
  (5, 'Santa Fe', 6, 1, '2019-04-23 16:57:41'),
  (6, 'Corolla', 1, 1, '2019-04-24 12:29:40'),
  (7, 'S3', 2, 1, '2019-05-01 10:58:16'),
  (8, 'A3', 2, 1, '2019-05-01 10:58:31'),
  (9, 'Civic', 7, 1, '2019-05-01 10:59:00'),
  (10, 'Integra DC2 Type R', 7, 1, '2019-05-01 10:59:32'),
  (11, 'Integra DC5 Type R', 7, 1, '2019-05-01 10:59:47'),
  (12, 'Dion', 8, 1, '2019-05-14 11:27:17'),
  (13, 'MG3', 9, 1, '2019-05-15 10:27:06'),
  (14, 'Amarok', 11, 1, '2019-05-20 10:10:06'),
  (15, 'levin', 1, 1, '2019-05-20 10:11:57'),
  (16, 'Integra', 14, 1, '2019-05-20 10:20:22'),
  (17, '510', 15, 1, '2019-05-20 10:21:37'),
  (18, 'Transporter', 11, 1, '2019-05-20 10:24:08'),
  (19, 'Starlet', 12, 1, '2019-05-20 10:32:39'),
  (20, 'Impreza', 16, 1, '2019-05-20 10:38:16'),
  (21, 'TT', 2, 1, '2019-05-20 10:39:06'),
  (22, '280', 17, 1, '2019-05-20 10:52:28'),
  (23, 'MR2', 1, 1, '2019-05-20 11:47:09'),
  (24, '316', 18, 1, '2019-05-20 11:56:21'),
  (25, 'Amarok', 11, 1, '2019-05-20 11:57:23'),
  (26, 'Silvia', 20, 1, '2019-05-28 09:39:31'),
  (27, 'sentra', 20, 1, '2019-07-01 10:16:45'),
  (28, 'Elantra', 6, 1, '2019-07-01 11:08:55'),
  (29, '5x4', 21, 1, '2019-07-10 09:18:54'),
  (30, 'Frontier', 20, 1, '2019-07-12 10:14:28'),
  (31, 'MRZ', 1, 1, '2019-07-15 09:06:28'),
  (32, 'bora', 11, 1, '2019-07-16 17:46:57'),
  (33, 'Celica', 1, 1, '2019-08-20 17:30:42'),
  (34, 'Montero', 8, 1, '2019-08-22 14:58:08'),
  (35, '528i', 18, 1, '2019-08-23 11:12:51');
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `pagoClientes`
  --
  
  CREATE TABLE `pagoClientes` (
    `id` int(11) NOT NULL,
    `idClientes` int(11) NOT NULL,
    `monto` decimal(10,2) NOT NULL,
    `tipoCambio` varchar(11) NOT NULL,
    `idTipoPago` int(11) NOT NULL,
    `documento` int(11) NOT NULL,
    `fechaRegistro` datetime NOT NULL,
    `fechaPago` datetime NOT NULL,
    `idTipoMoneda` int(11) NOT NULL,
    `idEstados` int(11) NOT NULL DEFAULT 1
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Volcado de datos para la tabla `pagoClientes`
  --
  
  INSERT INTO `pagoClientes` (`id`, `idClientes`, `monto`, `tipoCambio`, `idTipoPago`, `documento`, `fechaRegistro`, `fechaPago`, `idTipoMoneda`, `idEstados`) VALUES
  (1, 1, 1000.00, '3.21', 1, 0, '2019-04-29 11:44:51', '2019-04-29 00:00:00', 1, 1),
  (2, 61, 3036.00, '3.21', 4, 0, '2019-08-20 13:26:39', '2019-08-18 00:00:00', 1, 0),
  (3, 61, 3036.00, '3.21', 4, 12345678, '2019-08-20 16:21:02', '2019-08-20 00:00:00', 1, 0);
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `personas`
  --
  
  CREATE TABLE `personas` (
    `id` int(11) NOT NULL,
    `nombres` varchar(90) NOT NULL,
    `apellidoPaterno` varchar(90) NOT NULL,
    `apellidoMaterno` varchar(90) NOT NULL,
    `nombresCompletos` varchar(270) NOT NULL,
    `idTipoPersonas` int(11) NOT NULL,
    `idEstados` int(11) NOT NULL,
    `idTipoDocumentos` int(11) NOT NULL,
    `documento` varchar(30) NOT NULL,
    `correo` varchar(90) NOT NULL,
    `direccion` varchar(90) NOT NULL,
    `fechaRegistro` datetime NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Volcado de datos para la tabla `personas`
  --
  
  INSERT INTO `personas` (`id`, `nombres`, `apellidoPaterno`, `apellidoMaterno`, `nombresCompletos`, `idTipoPersonas`, `idEstados`, `idTipoDocumentos`, `documento`, `correo`, `direccion`, `fechaRegistro`) VALUES
  (1, 'Joaquin', 'Moreto', 'Moreto', 'Moreto Moreto Joaquin', 1, 0, 1, '22334455', 'mecanico@gmail.com', 'San diego', '2019-04-12 00:00:00'),
  (2, 'Juan', 'Perez', 'Perez', 'Perez Perez Juan', 1, 0, 1, '1213131313', 'sdsd@gadgad.com', 'San Borja', '2019-04-23 17:00:26'),
  (3, 'Joaquin', 'Moreto', 'Cordova', 'Moreto Cordova Joaquin', 1, 1, 1, '10870326', 'jmc.racing.sac@hotmail.com', 'Liberación San Juan de Lurigancho ', '2019-05-15 11:02:18'),
  (4, 'Rodolfo', 'Toro', 'Quiroz', 'Toro Quiroz Rodolfo', 1, 1, 1, '42824460', 'rodolfotq84@gmail.com', 'Cooperativa Virgen del Cocharcas Mz.R Lte.26 - Villa el Salvador', '2019-05-15 11:05:29'),
  (5, 'Armando', 'Bernedo', 'Machado', 'Bernedo Machado Armando', 1, 1, 1, '71418875', 'armandobernedo@gmail.com', 'Jr.Independencia 349 - Breña ', '2019-05-17 15:24:00'),
  (6, 'Yordano', 'Chuquisuta', 'Caceres', 'Chuquisuta Caceres Yordano', 1, 1, 1, '46921552', 'yordano90911@gmail.com', 'Av. Tacna 745 - San Miguel', '2019-05-17 15:24:32'),
  (7, 'Marco', 'Sanchez', 'Ore', 'Sanchez Ore Marco', 1, 1, 1, '71016157', 'dominic_spilner@gmail.com', 'Av.Mexico cruce Psje.Luya - La Victoria', '2019-05-17 15:26:48'),
  (8, 'Daniel', 'Lara', 'Medina', 'Lara Medina Daniel', 1, 1, 1, '001158319', 'Laramedinadanielvzla@gmail.com', 'Calle Independencia - Breña', '2019-07-01 14:27:11'),
  (9, 'Emanuel', 'Salinas', 'Castromonte', 'Salinas Castromonte Emanuel', 1, 1, 1, '44259703', 'emanuel_746@hotmail.com', 'Condominio los Girasoles 3ra.etapa torre 10 dpto.102 - Comas', '2019-08-20 11:03:01'),
  (10, 'Isaac', 'Cuadros', 'Martinez', 'Cuadros Martinez Isaac', 1, 1, 1, '71637537', 'isaajunior@gmail.com', 'Sector 6 Grupo 6A Mz.B Lte.22 - Villa el Salvador', '2019-08-20 11:09:48');
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `piezas`
  --
  
  CREATE TABLE `piezas` (
    `id` int(11) NOT NULL,
    `codigo` varchar(30) NOT NULL,
    `descripcion` varchar(90) NOT NULL,
    `costo` decimal(10,2) NOT NULL COMMENT 'Este  es el precio de venta',
    `precioCosto` decimal(10,2) NOT NULL,
    `idEstados` int(11) NOT NULL,
    `fechaRegistro` datetime NOT NULL,
    `stock` int(11) NOT NULL,
    `imagen` varchar(10) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Volcado de datos para la tabla `piezas`
  --
  
  INSERT INTO `piezas` (`id`, `codigo`, `descripcion`, `costo`, `precioCosto`, `idEstados`, `fechaRegistro`, `stock`, `imagen`) VALUES
  (1, 'P001', 'Llantas', 300.00, 0.00, 0, '2019-04-12 00:00:00', -279, ''),
  (2, 'P002', 'Motor 001', 1500.00, 0.00, 0, '2019-04-12 00:00:00', 43, ''),
  (3, 'BJ-1', 'Bujias', 5.50, 0.00, 0, '2019-04-26 15:02:49', 8, ''),
  (4, 'PF-1', 'Pastillas de freno', 550.00, 0.00, 0, '2019-04-26 15:04:54', 1, ''),
  (5, 'EP-C', 'Empaque de Culata', 75.00, 0.00, 0, '2019-04-26 15:06:58', 1, ''),
  (6, 'RT-V', 'Reten de valvula', 3.13, 0.00, 0, '2019-04-26 15:08:43', 16, ''),
  (7, 'RT-34-54-9/15', 'Reten radial', 12.00, 0.00, 0, '2019-04-26 15:11:27', 1, ''),
  (8, 'RT-34-63-9/15', 'Reten', 15.00, 0.00, 0, '2019-04-26 15:12:14', 1, ''),
  (9, 'RJ-38-72-33/36', 'Rodaje', 35.00, 0.00, 0, '2019-04-26 15:14:30', 2, ''),
  (10, 'RJ-AU0844', 'Rodaje', 37.50, 0.00, 0, '2019-04-26 15:17:10', 2, ''),
  (11, 'RT-52-66-7/12', 'Reten', 5.00, 0.00, 0, '2019-04-26 15:18:17', 2, ''),
  (12, 'RT-56-73-7/.5/1', 'Reten', 12.00, 0.00, 0, '2019-04-26 15:19:39', 4, ''),
  (13, 'RJ-01', 'Rodaje', 15.00, 0.00, 0, '2019-04-26 15:20:58', 1, ''),
  (14, 'RT-38-65-12/19', 'Reten', 15.00, 0.00, 0, '2019-04-26 15:56:26', 1, ''),
  (15, 'BR-T', 'Bronce 3ra y 4ta', 115.00, 0.00, 0, '2019-04-26 16:00:32', 2, ''),
  (16, 'ET-1', 'Empaque de termostato', 26.00, 0.00, 0, '2019-04-29 10:29:27', 1, ''),
  (17, 'T-1', 'Termosta (82-95 c) 3VZFE 3SGE 4AG', 117.20, 0.00, 0, '2019-04-29 10:38:47', 1, ''),
  (18, 'RJ-01', 'Rodaje', 55.00, 0.00, 0, '2019-04-29 12:04:28', 1, ''),
  (19, 'RJ-01', 'Rodaje tro80702/1D', 50.00, 0.00, 0, '2019-04-29 14:22:34', 1, ''),
  (20, 'O-1', 'Oxigeno', 11.00, 0.00, 0, '2019-04-29 14:51:19', 8, ''),
  (21, 'RJ-01', 'Rodaje', 110.00, 0.00, 0, '2019-04-29 14:53:00', 2, ''),
  (22, 'SL-1', 'Sensor de levas', 100.00, 0.00, 0, '2019-04-29 15:13:04', 1, ''),
  (23, 'CJA-1', 'Caja de cambio 4AG', 700.00, 0.00, 0, '2019-04-29 15:24:35', 1, ''),
  (24, 'Nuevo', 'dff', 300.00, 200.00, 0, '2019-04-29 23:39:29', 10, ''),
  (25, 'BJ-1', 'Bujias', 37.72, 0.00, 0, '2019-04-30 10:19:45', 4, ''),
  (26, 'EP-TC', 'Empaque de tapa de culata', 25.00, 0.00, 0, '2019-04-30 12:46:09', 1, ''),
  (27, 'RJ-01', 'Rodaje', 50.00, 0.00, 0, '2019-04-30 12:51:27', 1, ''),
  (28, 'RJ-38-72-33/36', 'Rodaje', 70.00, 0.00, 0, '2019-04-30 14:27:29', 2, ''),
  (29, 'RT-52-66-7/12', 'Reten', 10.00, 0.00, 0, '2019-04-30 14:31:14', 2, ''),
  (30, 'RT-26-48-10', 'Reten de tapa de balancin', 9.00, 0.00, 0, '2019-04-30 14:43:46', 0, ''),
  (31, 'PRUEBA', 'REPUESTO DE PRUEBA', 10.00, 5.00, 0, '2019-05-01 11:09:07', 7, ''),
  (32, 'RT-1', 'Reten', 2.50, 2.50, 0, '2019-05-02 09:54:03', 20, ''),
  (33, 'GR-P', 'Grasa palier', 33.15, 33.15, 0, '2019-05-02 09:57:11', 2, ''),
  (34, 'RJ-12-37-12', 'Rodaje', 15.00, 15.00, 0, '2019-05-02 09:59:05', 1, ''),
  (35, 'CP-01', 'Chapa perrilla', 13.00, 13.00, 0, '2019-05-02 10:03:28', 2, ''),
  (36, 'BJ-1', 'Bujias', 10.00, 10.00, 0, '2019-05-02 10:50:17', 1, ''),
  (37, 'ZF-01', 'zapato de freno', 152.00, 152.00, 0, '2019-05-02 11:52:29', 1, ''),
  (38, 'PF-1', 'Pastillas de freno posterior', 148.00, 148.00, 0, '2019-05-02 11:54:03', 1, ''),
  (39, 'RJ-01', 'Rodaje', 95.00, 95.00, 0, '2019-05-02 12:37:17', 2, ''),
  (40, 'EP-C', 'Empaque de Culata', 35.00, 35.00, 0, '2019-05-02 12:41:15', 1, ''),
  (41, 'RT-32-46-6', 'Reten', 10.00, 10.00, 0, '2019-05-02 15:16:35', 1, ''),
  (42, 'RT-35-49-6', 'Reten', 12.00, 12.00, 0, '2019-05-02 15:44:02', 1, ''),
  (43, 'RT-40-5*54.5*7', 'Reten', 15.00, 15.00, 0, '2019-05-02 15:45:50', 1, ''),
  (44, 'RS-S', 'Resortes Coilover', 93.22, 93.22, 0, '2019-05-03 09:59:24', 4, ''),
  (45, 'FA', 'Filtro de aceite', 73.43, 73.43, 0, '2019-05-03 10:01:47', 1, ''),
  (46, 'EP-C', 'Empaque de Culata TOYOTA', 1417.18, 1417.18, 0, '2019-05-03 10:22:06', 1, ''),
  (47, 'TF', 'Templador de faja', 565.00, 473.08, 0, '2019-05-03 11:39:53', 1, ''),
  (48, 'TF', 'Templador de faja 4AGE', 292.91, 292.91, 0, '2019-05-03 11:43:57', 1, ''),
  (49, 'ET', 'Empaque de termostato', 25.95, 25.95, 0, '2019-05-04 09:39:57', 1, ''),
  (50, 'MB-01', 'Metales de biela', 570.00, 350.54, 0, '2019-05-04 09:44:49', 1, ''),
  (51, 'CJA-1', 'Caja de cambio EJ20', 800.00, 800.00, 0, '2019-05-04 11:26:41', 1, ''),
  (52, 'GP', 'Guarda polvo de palier (EXT)', 12.00, 12.00, 0, '2019-05-04 12:42:06', 1, ''),
  (53, 'GP', 'Guarda polvo de palier (INT)', 12.00, 12.00, 0, '2019-05-04 14:56:57', 1, ''),
  (54, 'B-01', 'Bocina TZK TOYOTA INF', 40.00, 40.00, 0, '2019-05-06 09:33:18', 1, ''),
  (55, 'B-01', 'Bocina TZK TOYOTA INF', 40.00, 40.00, 0, '2019-05-06 09:33:36', 1, ''),
  (56, 'B-01', 'Bocina TZK TOYOTA INF', 40.00, 40.00, 0, '2019-05-06 09:33:37', 1, ''),
  (57, 'JC-01', 'Juego de cintillo de metal', 8.00, 2.00, 0, '2019-05-06 09:45:00', 8, ''),
  (58, 'GP-TC', 'Guarda polvo de palier TOYOTA COROLLA', 20.00, 10.00, 0, '2019-05-06 09:54:06', 3, ''),
  (59, 'GP-TC (EXT)', 'Guarda polvo de palier TOYOTA COROLLA (EXT)', 20.00, 10.00, 0, '2019-05-06 10:04:36', 4, ''),
  (60, 'GP', 'Guarda polvo de palier Racer (EXT)', 12.00, 12.00, 0, '2019-05-06 10:22:54', 2, ''),
  (61, 'EJ-P', 'Eje de palier', 45.00, 45.00, 0, '2019-05-06 10:33:05', 2, ''),
  (62, 'BJ-1', 'Bujias', 7.50, 7.50, 0, '2019-05-06 11:43:46', 2, ''),
  (63, 'FA', 'Filtro de aceite', 15.00, 15.00, 0, '2019-05-06 11:45:23', 1, ''),
  (64, 'AP', 'Anillos de piston', 95.00, 95.00, 0, '2019-05-06 14:56:21', 4, ''),
  (65, 'BE-01', 'Bobina de encendido', 430.00, 115.00, 0, '2019-05-07 09:41:17', 4, ''),
  (66, 'RT-35-65-9/15', 'Reten', 10.00, 10.00, 0, '2019-05-07 09:53:54', 1, ''),
  (67, 'RT-35-62-9/15', 'Reten', 12.00, 12.00, 0, '2019-05-07 09:55:41', 1, ''),
  (68, 'RT-12-25-7', 'Reten', 10.00, 10.00, 0, '2019-05-07 09:57:00', 4, ''),
  (69, 'RJ-50SC', 'Rodaje de rueda Nissan', 65.00, 65.00, 0, '2019-05-07 10:15:54', 1, ''),
  (70, 'EP-C', 'Empaque de culata', 25.00, 25.00, 0, '2019-05-07 10:32:54', 3, ''),
  (71, 'RT-V -FDM', 'Reten de válvula FDM', 3.13, 3.13, 0, '2019-05-08 09:45:32', 31, ''),
  (72, 'RT-V -AMC', 'Reten de válvula AMC', 3.13, 3.13, 0, '2019-05-08 09:47:29', 31, ''),
  (73, 'EP-C -AMC', 'Empaque de culata AMC', 25.00, 25.00, 0, '2019-05-08 10:07:05', 2, ''),
  (74, 'EP-C -KAN', 'Empaque de culata KAN', 70.00, 70.00, 0, '2019-05-08 10:09:48', 2, ''),
  (75, 'GP-N EXT', 'Guarda polvo de palier Nissan EXT', 12.00, 12.00, 0, '2019-05-08 12:43:53', 1, ''),
  (76, 'GP-C HYUNDAI', 'Guarda polvo de cremallera HYUNDAI', 10.00, 10.00, 0, '2019-05-08 12:51:48', 1, ''),
  (77, 'GP-CPA NISSAN', 'Guarda polvo de copa Nissan', 12.00, 12.00, 0, '2019-05-08 12:56:00', 1, ''),
  (78, 'Prueba99', 'descripcion de algo', 123.00, 12.00, 0, '2019-05-25 15:30:07', 12, ''),
  (79, 'Prueba999', 'descripcion de algo', 123.00, 12.00, 0, '2019-05-25 15:30:52', 12, ''),
  (80, 'APprueba', 'prueba', 123.00, 12.00, 0, '2019-05-25 15:31:41', 12, ''),
  (81, 'Prueba99', 'asd', 123.00, 12.00, 0, '2019-05-25 15:32:54', 12, ''),
  (82, 'PruebaNueva', 'adafd', 123.00, 1234.00, 0, '2019-05-25 15:33:12', 12, ''),
  (83, 'Pruebaaaa', 'algo', 123.00, 12.00, 0, '2019-05-25 15:52:21', 23, ''),
  (84, 'RA-1', 'Radiador de autos', 220.00, 220.00, 0, '2019-05-27 09:19:57', 20, ''),
  (85, 'TA-1', 'Tuerca para aros', 30.00, 30.00, 0, '2019-05-27 09:39:33', 80, ''),
  (86, 'CS-01', 'Cinturón de seguridad', 60.00, 60.00, 0, '2019-05-27 09:46:00', 40, ''),
  (87, 'IP-KIT', 'Intecooler pipa', 90.00, 90.00, 0, '2019-05-27 09:53:37', 9, ''),
  (88, 'T-01', 'Timon', 43.00, 43.00, 0, '2019-05-27 09:54:33', 30, ''),
  (89, 'RPA-01', 'Reloj presion aceite', 40.00, 40.00, 0, '2019-05-27 09:57:01', 50, ''),
  (90, 'RS-01', 'Resortes de suspensión', 90.00, 90.00, 0, '2019-05-27 09:59:11', 25, ''),
  (91, 'PAC-1', 'Pedal de acelerador y cable', 90.00, 90.00, 0, '2019-05-27 10:40:25', 0, ''),
  (92, 'P-1', 'Palieres ( eje y copa)', 290.00, 290.00, 0, '2019-05-27 10:51:07', 1, ''),
  (93, 'MR-1', 'Mangueras de radiador', 132.00, 132.00, 0, '2019-05-27 10:58:25', 1, ''),
  (94, 'LG-1', 'Limpieza de tanque de gasolina', 150.00, 150.00, 0, '2019-05-27 10:59:18', 0, ''),
  (95, 'SLS-1', 'Sensores de eje de elevas y sigueñal', 440.00, 440.00, 0, '2019-05-27 11:49:18', 2, ''),
  (96, 'AM-1', 'Adaptar caja de motor', 600.00, 600.00, 0, '2019-05-27 12:25:14', 1, ''),
  (97, 'CA-1', 'Cable acelerador', 80.00, 80.00, 0, '2019-05-27 12:56:26', 1, ''),
  (98, 'ET-2', 'Empaque de turbo', 180.00, 180.00, 0, '2019-05-28 09:41:18', 1, ''),
  (99, 'ER-1', 'Esparrago de rueda posterior', 100.00, 100.00, 0, '2019-05-28 09:42:33', 0, ''),
  (100, 'ET-2', 'Empaque de turbo', 20.00, 20.00, 0, '2019-05-28 09:45:12', 2, ''),
  (101, 'ET-01', 'Empaque de turbo', 20.00, 20.00, 0, '2019-05-28 09:45:26', 0, ''),
  (102, 'RM-1', 'Ramal de motor', 386.00, 386.00, 0, '2019-05-28 11:42:23', 1, ''),
  (103, 'PC-1', 'Palanca de csmbio', 150.00, 150.00, 0, '2019-05-28 11:43:43', 1, ''),
  (104, 'TB-01', 'Timen y bocamaza', 80.00, 80.00, 0, '2019-05-28 11:44:44', 1, ''),
  (105, 'A-1', 'Amortiguadores', 70.00, 70.00, 0, '2019-05-28 11:46:23', 4, ''),
  (106, 'ADLHONDA-94', 'Amortiguador delantero honda 94-00', 200.00, 210.00, 0, '2019-05-28 15:10:07', 0, ''),
  (107, 'APSHONDA-94', 'Amortiguador posterior honda-94-00', 210.00, 200.00, 0, '2019-05-28 15:11:27', 0, ''),
  (108, 'kE-1', 'Kit de embrague', 530.00, 530.00, 0, '2019-05-29 12:22:29', 0, ''),
  (109, 'VK20', 'Volante k20 tipo r', 500.00, 500.00, 0, '2019-05-29 15:18:01', 0, ''),
  (110, 'SA-01', 'Suspensión de auto', 430.00, 430.00, 0, '2019-06-04 11:47:42', 6, ''),
  (111, 'C-CHASIS', 'Control chasis', 140.00, 140.00, 0, '2019-06-04 11:54:07', 17, ''),
  (112, 'EA-01', 'Espaciadores de aros 25mm', 32.00, 32.00, 0, '2019-06-04 11:55:43', 60, ''),
  (113, 'AM-01', 'Aros de magnecio de 18\"', 160.00, 160.00, 0, '2019-06-04 11:57:26', 12, ''),
  (114, 'BBA-01', 'Bomba de aceite', 390.00, 390.00, 0, '2019-06-24 09:53:24', 1, ''),
  (115, 'BA-01', 'Bomba de agua', 177.69, 177.69, 0, '2019-06-28 09:58:12', 1, ''),
  (116, 'TD-01', 'Terminal de dirección', 180.00, 180.00, 0, '2019-06-28 12:22:55', 2, ''),
  (117, 'RFG-MT', 'Aditivo orgánico 1L', 60.00, 42.20, 1, '2019-07-03 11:43:40', 12, ''),
  (118, 'Limpiador de frenos', 'limpiador de frenos 500 ml', 8.24, 8.24, 1, '2019-07-03 11:51:56', 12, ''),
  (119, 'Almohadilla p/trabajo de campo', 'Almohadilla p/trabajo de campo', 99.00, 99.00, 0, '2019-07-03 11:53:56', 2, ''),
  (120, 'Liquido de frenos DOT4 250ml', 'Liquido de frenos DOT4 250ml', 8.64, 8.64, 1, '2019-07-03 11:56:47', 24, ''),
  (121, 'OBS Reten Valvula', 'OBS Reten Valvula', 4.17, 4.17, 1, '2019-07-03 12:06:22', 24, ''),
  (122, 'Pastillas de freno-2', 'Pastillas de freno', 10.84, 10.84, 1, '2019-07-03 12:23:53', 3, ''),
  (123, 'Gasohol', 'Gasolina', 13.07, 13.07, 0, '2019-07-03 12:29:37', 2, ''),
  (124, 'Gasolina', '90 octavos', 65.02, 65.02, 0, '2019-07-03 12:35:32', 1, ''),
  (125, 'Gasolina Primax', 'Gasolina', 184.95, 156.74, 0, '2019-07-03 12:39:47', 1, ''),
  (126, 'Gasolina 50plus', 'Gasolina 50 plus', 10.00, 10.00, 0, '2019-07-03 14:38:08', 2, ''),
  (127, 'Gasolina Repsol', 'Gasolina 98', 159.49, 159.49, 0, '2019-07-03 14:46:50', 1, ''),
  (128, 'Refrigerante', 'Refrigerante', 161.31, 161.31, 1, '2019-07-03 14:55:07', 2, ''),
  (129, 'Gasolina renusa', 'Filtro de aceite', 45.55, 45.55, 0, '2019-07-04 09:06:41', 2, ''),
  (130, 'Gasohol 90 plus', 'Gasohol 90 plus', 14.65, 14.65, 0, '2019-07-04 09:15:36', 2, ''),
  (131, 'Filtro de aire', 'Filtro de aire', 12.71, 12.71, 1, '2019-07-04 09:20:32', 3, ''),
  (132, 'Filtro de aceite', 'Filtro de aceite', 8.47, 8.47, 1, '2019-07-04 09:21:14', 4, ''),
  (133, 'Pastillas de freno-1', 'Pastillas de freno', 28.85, 23.97, 1, '2019-07-04 09:33:02', 2, ''),
  (134, 'Gasolina Repsol-1', 'galefitec 98', 50.00, 50.00, 0, '2019-07-04 09:47:05', 2, ''),
  (135, 'BJ-ST', 'Bujías encendido', 8.75, 7.00, 1, '2019-07-04 09:56:35', 10, ''),
  (136, 'MMC Filtro de aceite', 'MMC Filtro de aceite', 20.83, 20.83, 1, '2019-07-04 09:58:12', 2, ''),
  (137, 'MMC Filtro de Gasolina', 'MMC Filtro de Gasolina', 38.15, 38.15, 1, '2019-07-04 09:59:28', 2, ''),
  (138, 'Soporte de caja', 'Soporte de caja', 110.00, 110.00, 1, '2019-07-04 10:03:17', 2, ''),
  (139, 'Filtro', 'Filtro', 157.17, 157.17, 1, '2019-07-04 10:12:41', 2, ''),
  (140, 'Manguera Inferior', 'Manguera Inferior', 71.32, 71.32, 1, '2019-07-04 10:13:33', 2, ''),
  (141, 'MMC aceite caja', '5 litros rojo (MB 236.10)', 138.61, 138.61, 1, '2019-07-04 10:15:07', 2, ''),
  (142, 'MMC aceite caja-1', '1 litro rojo (MB 236.10)', 91.32, 91.32, 1, '2019-07-04 10:16:59', 5, ''),
  (143, 'MMC Sensor freno', 'MMC Sensor freno', 3.05, 3.05, 1, '2019-07-04 10:17:55', 4, ''),
  (144, 'ACT-MS', 'Aceite de Motor sintetico (Galon)5W/40', 190.00, 150.00, 1, '2019-07-04 10:19:04', 9, ''),
  (145, 'Pastillas de freno-3', 'Juego de pastillas de freno delantero', 140.30, 140.30, 1, '2019-07-04 10:20:37', 2, ''),
  (146, 'Punta de Palier', 'Punta de Palier', 190.00, 190.00, 1, '2019-07-04 10:33:44', 4, ''),
  (147, 'Trapecios', 'Trapecios', 380.00, 380.00, 1, '2019-07-04 10:34:23', 10, ''),
  (148, 'Cremallera', 'Cremallera de direccion s/m', 1430.00, 1430.00, 1, '2019-07-04 10:35:02', 2, ''),
  (149, 'Pastillas de freno', 'Pastillas de freno', 25.91, 25.91, 1, '2019-07-04 12:03:56', 1, ''),
  (150, 'Reten', 'TB9 Reten', 20.00, 20.00, 1, '2019-07-04 12:10:38', 2, ''),
  (151, 'Rotulas', 'Un juego de rotulas', 380.00, 380.00, 1, '2019-07-04 12:26:52', 2, ''),
  (152, 'Terminales', 'Un juego de terminales', 350.00, 350.00, 1, '2019-07-04 12:27:33', 2, ''),
  (153, 'Pack', 'Pack', 290.00, 290.00, 1, '2019-07-04 12:29:01', 4, ''),
  (154, 'Gasohol-1', '95 plus', 7.78, 7.78, 0, '2019-07-04 12:53:32', 2, ''),
  (155, 'Gasolina-2', 'primax 95', 156.00, 156.00, 0, '2019-07-04 12:57:07', 1, ''),
  (156, 'computadora', 'Computadora de motor original', 2105.00, 2105.00, 1, '2019-07-04 12:59:14', 1, ''),
  (157, 'Rotulas trapecios delanteros', 'Rotulas trapecios delanteros', 173.86, 147.34, 1, '2019-07-04 14:29:38', 4, ''),
  (158, 'Varillaje', 'Varillaje', 67.35, 57.08, 1, '2019-07-04 14:37:06', 2, ''),
  (159, 'AMR-DL', 'Amortiguadores delanteros', 250.00, 245.00, 1, '2019-07-04 14:53:47', 2, ''),
  (160, 'AMR-PT', 'Amortiguadores posteriores', 225.00, 195.00, 1, '2019-07-04 14:54:41', 4, ''),
  (161, 'Resortes Reforzados', 'Resortes Reforzados', 450.00, 450.00, 1, '2019-07-04 14:55:47', 8, ''),
  (162, 'Palieres', 'Palieres', 405.00, 405.00, 1, '2019-07-04 14:56:20', 8, ''),
  (163, 'Gasolina 98', '98', 129.11, 129.11, 0, '2019-07-04 15:45:49', 2, ''),
  (164, 'Gasolina 90', '90 octavos', 50.00, 50.00, 0, '2019-07-04 15:51:04', 1, ''),
  (165, 'BB-EN', 'Bobina de encendio', 150.00, 135.00, 1, '2019-07-04 15:52:18', 8, ''),
  (166, 'Empaque carter', 'empaque carter', 21.80, 21.80, 1, '2019-07-05 09:10:12', 2, ''),
  (167, 'Filtro caja aut sin empaque', 'Filtro caja aut sin empaque', 35.12, 35.12, 1, '2019-07-05 09:11:20', 2, ''),
  (168, 'Cremallera de dirección origin', 'Cremallera de dirección original', 2750.00, 2750.00, 1, '2019-07-05 09:14:36', 2, ''),
  (169, 'Juego de filtro A/C antipolen', 'Juego de filtro A/C antipolen', 61.43, 61.43, 1, '2019-07-05 09:18:45', 2, ''),
  (170, 'Filtro de aceite-2', 'Filtro de aceite', 12.71, 12.71, 1, '2019-07-05 09:27:25', 13, ''),
  (171, 'Filtro de aire-2', 'Filtro de aire', 8.47, 8.47, 1, '2019-07-05 09:28:21', 3, ''),
  (172, 'Empaque balancin 4AGE', 'Empaque balancin 4AGE', 44.97, 59.46, 1, '2019-07-05 09:34:30', 2, ''),
  (173, 'Filtro de aceite 1AZFE 2AZFE', 'Filtro de aceite 1AZFE 2AZFE', 59.46, 59.46, 1, '2019-07-05 09:36:17', 1, ''),
  (174, 'Palieres completos s/m', 'Palieres completos s/m', 980.00, 980.00, 1, '2019-07-05 09:45:29', 4, ''),
  (175, 'Juego de trapecios s/m', 'Juego de trapecios s/m', 450.00, 450.00, 1, '2019-07-05 09:46:16', 2, ''),
  (176, 'Cremallera de volante completa', 'Cremallera de volante completa', 590.00, 590.00, 1, '2019-07-05 09:46:55', 2, ''),
  (177, 'Pastillas de freno-4', 'Pastillas de freno', 36.88, 36.88, 1, '2019-07-05 09:55:57', 2, ''),
  (178, 'Gasolina 90 plus', 'Gasolina 90 plus', 16.02, 16.02, 0, '2019-07-05 10:06:42', 2, ''),
  (179, 'Gasolina-3', 'primax 90', 16.65, 16.65, 0, '2019-07-05 10:52:57', 2, ''),
  (180, 'Motor con caja marca toyota', 'Motor con caja marca toyota', 1600.00, 1600.00, 1, '2019-07-05 11:53:30', 2, ''),
  (181, 'Retenes cigueñal posterior', 'Retenes cigueñal posterior', 55.65, 47.16, 1, '2019-07-05 12:03:17', 2, ''),
  (182, 'caja de aceite Wolf guard tech', 'caja de aceite Wolf', 340.00, 340.00, 1, '2019-07-05 12:52:00', 16, ''),
  (183, 'caja de aceite WOLF VITALTECH', 'caja de aceite WOLF VITALTECH', 500.00, 500.00, 1, '2019-07-05 12:53:46', 8, ''),
  (184, 'Paleta Ventiladora', 'Paleta Ventiladora', 151.37, 151.37, 1, '2019-07-08 09:14:39', 2, ''),
  (185, 'Medidor de fluido', 'Medidor de fluido', 70.00, 70.00, 1, '2019-07-08 09:17:11', 2, ''),
  (186, 'Reten-1', 'reten', 50.38, 50.38, 1, '2019-07-08 09:33:48', 2, ''),
  (187, 'Reten de B', 'Reten de B', 30.00, 30.00, 1, '2019-07-08 09:36:45', 8, ''),
  (188, 'Filtro automotriz', 'Filtro automotriz', 18.00, 18.00, 1, '2019-07-08 09:40:36', 2, ''),
  (189, 'Kit de fundas asiento y timon', 'Kit de fundas asiento y timón', 310.00, 310.00, 1, '2019-07-08 09:44:56', 2, ''),
  (190, 'Pastilla de freno AGNA-5', 'Pastilla de freno AGNA-5', 298.00, 298.00, 1, '2019-07-08 09:49:55', 2, ''),
  (191, 'Filtro de aceite HONDA 15400 P', 'Filtro de aceite HONDA 15400 PL', 152.79, 152.79, 1, '2019-07-08 09:55:50', 1, ''),
  (192, 'Palier Toyota Remanufacturado', 'Palier Toyota Remanufacturado', 100.00, 100.00, 1, '2019-07-10 10:10:34', 2, ''),
  (193, 'Caliper/disco subaru forester', 'Caliper/disco subaru forester', 200.00, 200.00, 1, '2019-07-10 10:11:28', 4, ''),
  (194, 'Pastilla de freno CENTRIC-6', 'Pastilla de freno CENTRIC-6', 180.00, 152.54, 1, '2019-07-10 10:16:11', 2, ''),
  (195, 'Filtro de cabina ca1810', 'Filtro de cabina ca1810', 21.19, 21.19, 1, '2019-07-10 10:20:07', 2, ''),
  (196, 'Filtro de aire 1654673c10lb', 'Filtro de aire 1654673c10lb', 8.47, 8.47, 1, '2019-07-10 10:21:17', 2, ''),
  (197, 'Argón', 'Argón', 27.99, 27.99, 0, '2019-07-10 11:45:27', 11, ''),
  (198, 'Pastillas de freno-7', 'Pastillas de freno-7', 61.46, 61.46, 1, '2019-07-10 12:43:01', 2, ''),
  (199, 'Reten-2', 'Reten-2', 158.24, 158.24, 1, '2019-07-11 14:46:09', 8, ''),
  (200, 'BR-S/P', 'Brazos de suspensión posterior', 220.00, 200.00, 1, '2019-07-15 09:10:09', 2, ''),
  (201, 'Manguera de radiador', 'Manguera de radiador', 145.00, 145.00, 1, '2019-07-15 09:53:27', 1, ''),
  (202, 'Toma de agua de radiador en to', 'Toma de agua de radiador en topa', 130.00, 130.00, 1, '2019-07-15 09:59:41', 1, ''),
  (203, 'ABR-T', 'Abrazaderas de turbo', 15.00, 10.00, 1, '2019-07-15 10:05:17', 4, ''),
  (204, 'BM-E', 'Bomba de embrague (Hiunday)', 280.00, 260.00, 1, '2019-07-15 10:52:05', 0, ''),
  (205, 'Brida con termistato', 'Brida con termostato', 250.00, 250.00, 1, '2019-07-15 11:10:17', 0, ''),
  (206, 'Ventilador', 'Ventilador', 170.00, 170.00, 1, '2019-07-15 11:10:53', 0, ''),
  (207, 'Manguera de recirculacion', 'Manguera de recirculacion', 32.00, 32.00, 1, '2019-07-15 11:12:37', 0, ''),
  (208, 'Brazos de terminales de direcc', 'Brazos de terminales de dirección', 330.00, 330.00, 1, '2019-07-15 12:13:55', 0, ''),
  (209, 'Vidrios de espejos', 'Vidrios de espejos', 160.00, 160.00, 1, '2019-07-15 12:14:35', 0, ''),
  (210, 'Focos de luz principal', 'Focos de luz principal', 76.00, 76.00, 1, '2019-07-15 12:15:18', 0, ''),
  (211, 'Soporte de cremallera', 'Soporte de cremallera', 33.00, 33.00, 1, '2019-07-16 12:57:30', 0, ''),
  (212, 'BR-D', 'Brazos de dirección', 80.00, 70.00, 1, '2019-07-16 12:58:23', 4, ''),
  (213, 'Terminales-1', 'Terminales-1', 135.00, 135.00, 1, '2019-07-16 13:00:26', 0, ''),
  (214, 'Ponchos de cremallera', 'Ponchos de cremallera', 20.00, 20.00, 1, '2019-07-16 14:14:02', 0, ''),
  (215, 'culata', 'culata', 1650.00, 1650.00, 1, '2019-07-16 14:25:53', 1, ''),
  (216, 'kit de empaque', 'kit de empaque', 250.00, 250.00, 1, '2019-07-16 14:27:40', 1, ''),
  (217, 'Turbo de recirculacion', 'Turbo de recirculacion', 190.00, 190.00, 1, '2019-07-16 17:54:11', 0, ''),
  (218, 'brida de distribución', 'brida de distribución', 220.00, 220.00, 1, '2019-07-16 17:54:44', 0, ''),
  (219, 'reten válvulas', 'reten válvulas', 140.24, 140.24, 1, '2019-07-23 14:27:25', 40, ''),
  (220, 'Metal de bancada', 'Metal de bancada', 196.60, 196.60, 1, '2019-07-23 14:31:47', 10, ''),
  (221, 'Metal biela', 'Metal biela', 112.72, 112.72, 1, '2019-07-23 14:32:31', 8, ''),
  (222, 'Filtro de aceite MMC', 'Filtro de aceite MMC', 31.48, 31.48, 1, '2019-07-23 14:39:02', 2, ''),
  (223, 'Filtro aire', 'filtro aire', 41.73, 41.73, 1, '2019-07-23 14:39:53', 0, ''),
  (224, 'Elemento de aceite', 'Elemento de aceite', 12.71, 12.71, 1, '2019-07-23 14:43:11', 2, ''),
  (225, 'Filtro de aceite 92628890CJ', 'Filtro de aceite 92628890CJ', 16.10, 16.10, 1, '2019-07-23 14:45:56', 1, ''),
  (226, 'Faja de distribución', 'Faja de distribución', 141.99, 141.99, 1, '2019-07-23 14:50:28', 2, ''),
  (227, 'BJ-IR', 'bujias de iridion', 37.50, 35.00, 1, '2019-08-20 14:32:40', 8, ''),
  (228, 'SPT-Negro', 'Spray de Pintura Negro', 12.00, 12.00, 1, '2019-08-20 19:12:56', 0, ''),
  (229, 'ORIG-VA', 'Orig de varilla de aceite', 2.00, 2.00, 1, '2019-08-20 19:20:01', 0, ''),
  (230, 'CAÑ-ELTRIC', 'Caña dirección eléctrica', 700.00, 500.00, 1, '2019-08-20 19:46:05', 2, ''),
  (231, 'ACL-DIR', 'Acople direccion cardamico', 110.00, 90.00, 1, '2019-08-20 19:53:28', 0, ''),
  (232, 'ACT-C', 'Aceite de Caja (Corona) 75/90', 85.00, 65.00, 1, '2019-08-22 13:16:46', 15, ''),
  (233, 'SEJ- DLYS', 'Sensores de eje de levas y sigueñal', 440.00, 430.00, 1, '2019-08-22 16:45:57', 1, ''),
  (234, 'GSL', 'Gasolina', 30.00, 30.00, 1, '2019-08-22 16:48:18', 0, ''),
  (235, 'SPCDC', 'Soporte de cola de caja', 80.00, 75.00, 1, '2019-08-22 16:49:14', 0, ''),
  (236, 'PNL-CELEC', 'Panel de computadora (Electronico)', 100.00, 90.00, 1, '2019-08-22 16:50:21', 0, ''),
  (237, 'CDP-NIPPON', 'computadora de caja (Nippon)', 200.00, 195.00, 1, '2019-08-22 16:54:09', 0, ''),
  (238, 'OBT-ELEC', 'Obturador', 480.00, 400.00, 1, '2019-08-22 17:06:08', 0, ''),
  (239, 'CB-Pl', 'Camber plate', 350.00, 280.00, 1, '2019-08-23 09:46:44', 1, ''),
  (240, 'BCZ-T', 'Bocamaza de timon', 230.00, 210.00, 1, '2019-08-23 18:04:13', 2, ''),
  (241, 'EMP-C', 'Empaque de culata', 50.00, 25.00, 1, '2019-08-27 15:43:40', 1, ''),
  (242, 'RTN-V', 'Retenes de Válvulas(juego 8)', 50.00, 35.00, 1, '2019-08-27 15:54:18', 1, ''),
  (243, 'RTN-L', 'Reten de Levas', 24.00, 12.00, 1, '2019-08-27 15:56:34', 1, ''),
  (244, 'RMZ-P', 'Refrigerante Mezcla Precisa Prestone', 180.00, 141.81, 1, '2019-08-28 15:49:17', 2, ''),
  (245, 'LT-ACO', 'Lubricantes Acdelco', 150.00, 133.95, 1, '2019-08-28 15:54:25', 2, ''),
  (246, 'TM-ELEC', 'Timon Completo Toyota Varios C/Eje de Direccion Remanufacturada', 300.00, 150.00, 1, '2019-08-28 16:14:02', 2, '');
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `servicioRepuestos`
  --
  
  CREATE TABLE `servicioRepuestos` (
    `id` int(11) NOT NULL,
    `idEntregaServicios` int(11) NOT NULL,
    `idPiezas` int(11) NOT NULL,
    `cantidad` int(11) NOT NULL,
    `monto` decimal(10,2) NOT NULL,
    `idEstados` int(11) NOT NULL DEFAULT 1,
    `factura` int(11) NOT NULL,
    `fechaFacturacion` date NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Volcado de datos para la tabla `servicioRepuestos`
  --
  
  INSERT INTO `servicioRepuestos` (`id`, `idEntregaServicios`, `idPiezas`, `cantidad`, `monto`, `idEstados`, `factura`, `fechaFacturacion`) VALUES
  (1, 1, 1, 510, 153000.00, 1, 0, '0000-00-00'),
  (2, 3, 1, 2, 600.00, 1, 0, '0000-00-00'),
  (3, 3, 2, 2, 3000.00, 1, 0, '0000-00-00'),
  (4, 5, 1, 12, 3600.00, 1, 0, '0000-00-00'),
  (5, 6, 1, 2, 600.00, 1, 0, '0000-00-00'),
  (6, 7, 1, 2, 700.00, 1, 0, '0000-00-00'),
  (7, 9, 31, 2, 140.00, 0, 0, '0000-00-00'),
  (8, 9, 30, 4, 36.00, 1, 0, '0000-00-00'),
  (9, 9, 31, 1, 10.00, 0, 0, '0000-00-00'),
  (10, 9, 31, 1, 10.00, 0, 0, '0000-00-00'),
  (11, 9, 31, 1, 10.00, 0, 0, '0000-00-00'),
  (12, 10, 31, 1, 10.00, 1, 0, '0000-00-00'),
  (13, 9, 31, 1, 10.00, 0, 0, '0000-00-00'),
  (14, 9, 31, 2, 20.00, 1, 0, '0000-00-00'),
  (15, 10, 62, 2, 15.00, 1, 0, '0000-00-00'),
  (16, 18, 72, 1, 3.13, 1, 0, '0000-00-00'),
  (17, 18, 73, 1, 25.00, 1, 0, '0000-00-00'),
  (18, 18, 73, 1, 25.00, 0, 0, '0000-00-00'),
  (19, 18, 71, 1, 3.13, 1, 1, '0000-00-00'),
  (20, 19, 91, 1, 90.00, 1, 0, '0000-00-00'),
  (21, 19, 92, 1, 290.00, 1, 0, '0000-00-00'),
  (22, 19, 93, 1, 132.00, 1, 0, '0000-00-00'),
  (23, 19, 94, 1, 150.00, 1, 0, '0000-00-00'),
  (24, 20, 95, 1, 440.00, 0, 0, '0000-00-00'),
  (25, 20, 95, 1, 440.00, 0, 0, '0000-00-00'),
  (26, 23, 99, 1, 100.00, 1, 0, '0000-00-00'),
  (27, 23, 101, 2, 40.00, 1, 0, '0000-00-00'),
  (28, 36, 107, 2, 420.00, 1, 1, '0000-00-00'),
  (29, 36, 106, 2, 400.00, 0, 1, '0000-00-00'),
  (30, 36, 106, 2, 430.00, 1, 1, '0000-00-00'),
  (31, 38, 108, 1, 530.00, 1, 0, '0000-00-00'),
  (32, 38, 109, 1, 500.00, 1, 0, '0000-00-00'),
  (33, 50, 200, 2, 440.00, 1, 0, '0000-00-00'),
  (34, 51, 204, 1, 260.00, 1, 0, '0000-00-00'),
  (35, 52, 205, 1, 250.00, 1, 0, '0000-00-00'),
  (36, 52, 206, 1, 170.00, 1, 1, '0000-00-00'),
  (37, 52, 201, 3, 88.00, 1, 0, '0000-00-00'),
  (38, 52, 207, 1, 32.00, 1, 0, '0000-00-00'),
  (39, 54, 208, 1, 330.00, 0, 0, '0000-00-00'),
  (40, 54, 209, 1, 160.00, 0, 0, '0000-00-00'),
  (41, 55, 208, 2, 330.00, 1, 0, '0000-00-00'),
  (42, 55, 209, 2, 160.00, 1, 0, '0000-00-00'),
  (43, 55, 210, 4, 76.00, 1, 0, '0000-00-00'),
  (44, 57, 147, 1, 220.00, 1, 0, '0000-00-00'),
  (45, 60, 211, 1, 33.00, 1, 0, '0000-00-00'),
  (46, 60, 212, 1, 140.00, 1, 1, '0000-00-00'),
  (47, 60, 213, 1, 135.00, 1, 1, '0000-00-00'),
  (48, 60, 214, 1, 20.00, 1, 0, '0000-00-00'),
  (49, 62, 218, 1, 220.00, 1, 0, '0000-00-00'),
  (50, 62, 217, 1, 190.00, 1, 0, '0000-00-00'),
  (51, 69, 203, 1, 110.00, 1, 1, '0000-00-00'),
  (52, 73, 135, 4, 90.00, 1, 1, '0000-00-00'),
  (53, 73, 144, 1, 200.00, 1, 1, '0000-00-00'),
  (54, 73, 173, 1, 46.00, 1, 1, '0000-00-00'),
  (55, 82, 173, 1, 42.00, 1, 0, '0000-00-00'),
  (56, 82, 144, 1, 190.00, 1, 0, '0000-00-00'),
  (57, 86, 144, 1, 190.00, 1, 0, '0000-00-00'),
  (58, 86, 173, 1, 42.00, 1, 1, '0000-00-00'),
  (59, 90, 144, 1, 190.00, 0, 1, '0000-00-00'),
  (60, 90, 170, 1, 40.00, 0, 1, '0000-00-00'),
  (61, 90, 144, 1, 190.00, 1, 1, '0000-00-00'),
  (62, 90, 170, 1, 40.00, 1, 1, '0000-00-00'),
  (63, 93, 228, 2, 24.00, 1, 1, '0000-00-00'),
  (64, 99, 229, 1, 2.00, 1, 1, '0000-00-00'),
  (65, 103, 144, 1, 190.00, 1, 1, '0000-00-00'),
  (66, 115, 232, 2, 150.00, 1, 1, '0000-00-00'),
  (67, 20, 156, 1, 300.00, 0, 1, '0000-00-00'),
  (68, 117, 235, 1, 80.00, 1, 1, '0000-00-00'),
  (69, 117, 233, 1, 440.00, 1, 1, '0000-00-00'),
  (70, 117, 156, 1, 300.00, 1, 1, '0000-00-00'),
  (71, 117, 234, 1, 30.00, 1, 1, '0000-00-00'),
  (72, 117, 237, 1, 200.00, 1, 1, '0000-00-00'),
  (73, 117, 236, 1, 100.00, 1, 1, '0000-00-00'),
  (74, 117, 223, 1, 50.00, 1, 1, '0000-00-00'),
  (75, 117, 238, 1, 480.00, 1, 1, '0000-00-00'),
  (76, 123, 223, 1, 28.00, 1, 1, '0000-00-00'),
  (77, 124, 232, 2, 150.00, 1, 1, '0000-00-00'),
  (78, 124, 239, 1, 350.00, 1, 1, '0000-00-00'),
  (79, 128, 240, 1, 230.00, 1, 1, '0000-00-00'),
  (80, 129, 144, 1, 65.00, 1, 1, '0000-00-00'),
  (81, 129, 225, 1, 20.00, 1, 1, '0000-00-00');
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `servicios`
  --
  
  CREATE TABLE `servicios` (
    `id` int(11) NOT NULL,
    `descripcion` varchar(90) DEFAULT NULL,
    `detalle` text DEFAULT NULL,
    `idEstados` int(11) NOT NULL,
    `fechaRegistro` datetime DEFAULT NULL,
    `costo` decimal(10,2) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Volcado de datos para la tabla `servicios`
  --
  
  INSERT INTO `servicios` (`id`, `descripcion`, `detalle`, `idEstados`, `fechaRegistro`, `costo`) VALUES
  (1, 'Cambio de aceite', 'Consiste en cambio de aceite y accesorios.\r\ncomo filtro de aceite y aire ,revision de niveles en general', 1, '0000-00-00 00:00:00', 70.00),
  (2, 'qer', 'qereqr', 0, '0000-00-00 00:00:00', 0.00),
  (3, 'servicio nuevo', 'Detalle del servicio nuevo2', 0, '0000-00-00 00:00:00', 0.00),
  (4, 'Mantenimiento frenos', 'Limpieza de pastillas y regulación', 1, '0000-00-00 00:00:00', 50.00),
  (5, 'Adaptacion de motor', 'Adaptacion de motor', 1, '0000-00-00 00:00:00', 2500.00),
  (6, 'Mantenimiento de palieres', 'Desarmado , limpieza y armado', 1, '0000-00-00 00:00:00', 180.00),
  (7, 'Nuevo', 'sdfsdf', 0, '2019-04-29 23:29:47', 500.00),
  (8, 'otro', 'dsfsdf', 0, '2019-04-29 23:29:56', 123.00),
  (9, 'Reparación de Motor', 'Reparación de motor', 1, '2019-05-15 11:12:05', 2200.00),
  (10, 'Por Diagnostico de Falla', 'Encontrar e informar la falla detectada', 1, '0000-00-00 00:00:00', 100.00),
  (11, 'Cambiar empaque de turbo', 'Cambiar empaque de turbo', 1, '2019-05-28 09:46:26', 180.00),
  (12, 'Desmontaje y montaje de motor', 'Desmontaje y montaje de motor', 1, '0000-00-00 00:00:00', 500.00),
  (13, 'Cambio de ramal de motor', 'Cambio de ramal de motor', 1, '0000-00-00 00:00:00', 300.00),
  (14, 'Cambiar palanca de cambios M/T', 'Desmontaje y Montaje de palanca de cambios mecánica', 1, '0000-00-00 00:00:00', 150.00),
  (15, 'Cambio de timón', 'Solo cambio de timón (volante)', 1, '0000-00-00 00:00:00', 30.00),
  (16, 'Cambio de bocamaza de timon', 'Cambio de bocamaza de timon', 1, '2019-05-28 15:04:58', 50.00),
  (17, 'Cambio de amortiguadores', 'Cambio de 4 amortiguadores (puede variar precio de acuerdo a modelo de vehículo )', 1, '0000-00-00 00:00:00', 350.00),
  (18, 'Cambio de linea de escape completa', 'Solo linea a partir de brida de motor', 1, '0000-00-00 00:00:00', 180.00),
  (19, 'Cambio de embrague (Auto)', 'Cambio de embrague e Incluye desmontaje y montaje de caja (varia por modelo de carro )', 1, '0000-00-00 00:00:00', 400.00),
  (20, 'cambio de brazos y terminales', 'cambio de brazos y terminales', 1, '2019-06-28 14:41:32', 200.00),
  (21, 'Hacer turbo header', 'Hacer turbo header', 1, '2019-07-10 09:28:15', 700.00),
  (22, 'Poner a pintar motor', 'Poner a pintar motor', 1, '2019-07-10 09:28:38', 220.00),
  (23, 'Reforzar puerta, hacer soporte nuevo', 'Reforzar puerta, hacer soporte nuevo', 1, '2019-07-10 09:29:59', 650.00),
  (24, 'Reforzar soportes originales', 'Reforzar soportes originales', 1, '2019-07-10 09:30:36', 250.00),
  (25, 'Desmontaje y montaje de turbo header', 'Desmontaje y montaje de turbo header', 1, '2019-07-10 09:31:48', 200.00),
  (26, 'Reparar fibra', 'Reparar fibra', 1, '2019-07-10 09:32:23', 280.00),
  (27, 'Modificar pipa de turbo', 'Modificar pipa de turbo', 1, '0000-00-00 00:00:00', 480.00),
  (28, 'Cambio de bomba de gasolina', 'Cambio de bomba de gasolina', 1, '2019-07-12 09:53:00', 0.00),
  (29, 'Asistencia a practica y carrera', 'Asistencia a practica y carrera', 1, '2019-07-12 09:53:57', 1000.00),
  (30, 'Cambiar linea de escape y resonador', 'Cambiar linea de escape y resonador', 1, '2019-07-12 10:24:23', 750.00),
  (31, 'Alineamiento', 'Alineamiento', 1, '2019-07-15 09:09:02', 120.00),
  (32, 'cambio de bomba de embrague', 'cambio de bomba de embrague', 1, '2019-07-15 10:52:44', 130.00),
  (33, 'Instalar radiador y bridas', 'Instalar radiador y bridas', 1, '2019-07-15 11:08:55', 280.00),
  (34, 'Enderezado de chasis', 'Enderezado de chasis', 1, '2019-07-15 12:08:18', 320.00),
  (35, 'Reparar cremallera', 'Reparar cremallera', 1, '2019-07-15 12:12:57', 210.00),
  (36, 'Enllante de 4', 'Enllante de 4', 1, '2019-07-15 12:18:05', 32.00),
  (37, 'Mantenimiento de cremallera', 'Mantenimiento de cremallera', 1, '2019-07-16 13:01:51', 180.00),
  (38, 'Mantenimiento de Inyectores', 'Mantenimiento de Inyectores', 1, '2019-07-16 17:58:25', 80.00),
  (39, 'scaneo', 'scaneo', 1, '2019-07-16 17:59:06', 88.00),
  (40, 'Servicio de grua', 'Servicio de grua', 1, '2019-07-18 14:41:04', 210.00),
  (41, 'Revisar Caja', 'Revisar Caja', 1, '2019-07-19 10:20:44', 0.00),
  (42, 'Revisar suspensión y frenos', 'Revisar suspensión y frenos', 1, '2019-07-19 10:21:10', 0.00),
  (43, 'Revisar palieres', 'Revisar palieres', 1, '2019-07-19 10:21:30', 0.00),
  (44, 'Revisión general', 'Revisión general', 1, '2019-07-19 10:21:53', 0.00),
  (45, 'Modificar turbo header', 'Modificar turbo header', 1, '0000-00-00 00:00:00', 0.00),
  (46, 'Modificar pipa de intercooler', 'Modificar pipa de intercooler', 1, '2019-07-23 09:56:36', 0.00),
  (47, 'Configurar Computadora', 'Configurar Computadora', 1, '2019-07-23 09:57:19', 0.00),
  (48, 'Instalar válvula de mínimo', 'Instalar válvula de mínimo', 1, '2019-07-23 09:58:10', 0.00),
  (49, 'Modificar bases de chapa y radiador', 'Modificar bases de chapa y radiador', 1, '2019-07-23 11:07:34', 320.00),
  (50, 'Adaptar ventiladores', 'Adaptar ventiladores', 1, '2019-07-23 11:09:42', 120.00),
  (51, 'Reparar cable de velocimetro', 'Reparar cable de velocimetro', 1, '2019-07-23 11:13:48', 40.00),
  (52, 'Aumentar presión de gasolina', 'Aumentar presión de gasolina', 1, '2019-07-23 11:14:32', 30.00),
  (53, 'Hacer protector de turbo', 'Hacer protector de turbo', 1, '2019-07-23 11:18:49', 30.00),
  (54, 'Cambio de embrague (Camioneta)', 'Cambio de embrague e Incluye desmontaje y montaje de caja (varia por modelo de camioneta )', 1, '2019-08-20 11:47:12', 600.00),
  (55, 'Revisar cable de cambios (arreglar palanca)', 'arreglar palanca de cambios', 1, '2019-08-20 14:11:57', 80.00),
  (56, 'Reparar turbo', 'reparación del turbo', 1, '2019-08-20 14:12:36', 590.00),
  (57, 'Revisar dirección asistida', 'revisión de la dirección', 1, '2019-08-20 14:13:47', 200.00),
  (58, 'Desmontaje y montaje de turbo', 'desmontaje y montaje de turbo', 1, '2019-08-20 14:17:21', 300.00),
  (59, 'Cepillado de turbo header', 'cepillado de turbo header', 1, '2019-08-20 15:53:02', 210.00),
  (60, 'Forrar turbo header', 'forrar turbo header', 1, '2019-08-20 16:05:53', 80.00),
  (61, 'Miscelaneos', 'trabajo extra', 1, '2019-08-20 16:17:10', 250.00),
  (62, 'Cambio de resortes wasteget', 'cambio de resortes wasteget', 1, '2019-08-20 16:19:28', 120.00),
  (63, 'Enderezado de brazo posterior izquierdo', 'enderezado de brazo posterior izquierdo', 1, '2019-08-20 17:07:59', 80.00),
  (64, 'Cambiar reten de sigueñal', 'Cambiar reten de sigueñal', 1, '0000-00-00 00:00:00', 100.00),
  (65, 'Cambio de Faja Hidraulica', 'Faja hidraulica', 1, '2019-08-20 17:54:10', 35.00),
  (66, 'Cambiar soporte de motor', 'cambiar soporte de motor', 1, '2019-08-20 17:56:56', 130.00),
  (67, 'Revisar fuga de aceite de motor', 'Revisar fuga de aceite de motor', 1, '2019-08-20 18:14:22', 32.00),
  (68, 'Desmontaje y montaje de carter', 'desmontaje y montaje carter', 1, '2019-08-20 18:49:18', 150.00),
  (69, 'Cambio de orig velocimetro', 'cambio de jebe de velocimetro', 1, '2019-08-20 18:56:14', 90.00),
  (70, 'Cambio de seguro de capot', 'Cambio de seguro de capot', 1, '2019-08-20 19:00:51', 40.00),
  (71, 'Asegurar soporte de cremallera', 'Asegurar soporte de cremallera', 1, '2019-08-20 19:04:32', 38.00),
  (72, 'Limpieza de Opturador', 'Limpiar el opturador y brindarle mantenimiento', 1, '2019-08-21 16:07:52', 50.00),
  (73, 'Cambio de amortiguadores', 'Cambiar amortiguadores', 1, '2019-08-21 16:09:12', 320.00),
  (74, 'Poner a punto suspensión', 'Poner a punto la suspensión', 1, '2019-08-21 16:18:52', 120.00),
  (75, 'Limpieza de Filtro de Aire', 'limpieza de filtro de aire', 0, '2019-08-21 16:22:07', 60.00),
  (76, 'Reparar bomba de Embrague', 'Reparar bomba de embrague', 1, '2019-08-21 17:53:39', 50.00),
  (77, 'Reforzar base de amortiguadores', 'Reforzar base de amortiguadores', 1, '2019-08-21 17:55:23', 150.00),
  (78, 'Correguir mangueras de aire acondicionado', 'Alineamiento de mangueras de aire acondicionado', 1, '2019-08-21 17:58:09', 70.00),
  (79, 'Desmontaje y montaje de caja (corona)', 'instalar y cambiar plato (desmontaje y montaje)', 1, '2019-08-22 13:05:33', 550.00),
  (80, 'Reparacion de Falla (Electronico)', 'Reparacion de todo el sistema electrico', 1, '2019-08-22 16:40:56', 0.00),
  (81, 'Soldar Radiador', 'Soldar y reparar radiador', 1, '2019-08-22 17:21:27', 80.00),
  (82, 'Instalar reguladores 300', 'Instalar reguladores 300', 1, '2019-08-22 18:23:29', 100.00),
  (83, 'Instalacion de camber plate', 'Desmontaje y Montaje de camber plate', 1, '2019-08-23 09:21:56', 200.00);
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `tipoDocumentos`
  --
  
  CREATE TABLE `tipoDocumentos` (
    `id` int(11) NOT NULL,
    `descripcion` varchar(90) NOT NULL,
    `idEstados` int(11) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Volcado de datos para la tabla `tipoDocumentos`
  --
  
  INSERT INTO `tipoDocumentos` (`id`, `descripcion`, `idEstados`) VALUES
  (1, 'dni', 1),
  (2, 'ruc', 1);
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `tipoMonedas`
  --
  
  CREATE TABLE `tipoMonedas` (
    `id` int(11) NOT NULL,
    `descripcion` varchar(90) NOT NULL,
    `simbolo` varchar(90) NOT NULL,
    `idEstados` int(11) NOT NULL DEFAULT 1
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Volcado de datos para la tabla `tipoMonedas`
  --
  
  INSERT INTO `tipoMonedas` (`id`, `descripcion`, `simbolo`, `idEstados`) VALUES
  (1, 'Soles', 'S./', 1),
  (2, 'Dolares', '$.', 1);
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `tipoPagos`
  --
  
  CREATE TABLE `tipoPagos` (
    `id` int(11) NOT NULL,
    `descripcion` varchar(90) NOT NULL,
    `idEstados` int(11) NOT NULL DEFAULT 1
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Volcado de datos para la tabla `tipoPagos`
  --
  
  INSERT INTO `tipoPagos` (`id`, `descripcion`, `idEstados`) VALUES
  (1, 'efectivo', 1),
  (2, 'desposito', 1),
  (3, 'cheque', 1),
  (4, 'transferencia', 1);
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `tipoPersonas`
  --
  
  CREATE TABLE `tipoPersonas` (
    `id` int(11) NOT NULL,
    `descripcion` varchar(90) NOT NULL,
    `idEstados` int(11) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Volcado de datos para la tabla `tipoPersonas`
  --
  
  INSERT INTO `tipoPersonas` (`id`, `descripcion`, `idEstados`) VALUES
  (1, 'mecanico', 1);
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `usuario`
  --
  
  CREATE TABLE `usuario` (
    `id` int(11) NOT NULL,
    `usuario` varchar(60) NOT NULL,
    `contrasena` varchar(60) NOT NULL
  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  
  --
  -- Volcado de datos para la tabla `usuario`
  --
  
  INSERT INTO `usuario` (`id`, `usuario`, `contrasena`) VALUES
  (1, 'admin', 'd1f47c3c7abf7d67b34bb2ff67daedbd'),
  (2, 'jmc', 'bc67790863cb164cfcc9f083919afee1');
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `vehiculos`
  --
  
  CREATE TABLE `vehiculos` (
    `id` int(11) NOT NULL,
    `placa` varchar(15) NOT NULL,
    `idMarcas` int(11) NOT NULL,
    `idModelos` int(11) NOT NULL,
    `motor` varchar(60) NOT NULL,
    `anio` int(11) NOT NULL,
    `serie` varchar(60) NOT NULL,
    `imagen` varchar(90) NOT NULL,
    `idClientes` int(11) NOT NULL,
    `idEstados` int(11) NOT NULL,
    `fechaRegistro` datetime NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Volcado de datos para la tabla `vehiculos`
  --
  
  INSERT INTO `vehiculos` (`id`, `placa`, `idMarcas`, `idModelos`, `motor`, `anio`, `serie`, `imagen`, `idClientes`, `idEstados`, `fechaRegistro`) VALUES
  (1, 'AUU112', 1, 1, '12312', 2022, 'daf', '1.jpg', 1, 0, '2019-04-12 17:23:11'),
  (2, 'aaaaa', 1, 1, '', 0, '', '', 0, 1, '2019-04-15 14:00:38'),
  (3, 'aaaaa', 1, 1, 'aefa', 456, 'grfgrg', '', 0, 1, '2019-04-15 14:00:57'),
  (4, 'afaef', 1, 2, '', 0, '', '', 1, 0, '2019-04-15 14:01:37'),
  (5, 'aaaaaaaa', 1, 1, '', 0, '', '', 1, 0, '2019-04-15 14:01:51'),
  (6, 'aaaaa', 2, 1, 'fadafdadf', 12312, '3123', '1.jpg', 1, 0, '2019-04-15 14:02:04'),
  (7, 'bbb', 1, 1, '', 0, '', '', 0, 1, '2019-04-16 08:20:38'),
  (8, 'franz', 1, 1, '', 0, '', '', 1, 0, '2019-04-16 08:32:02'),
  (9, 'kkk', 1, 1, '122', 2013, '', '1.jpg', 1, 0, '2019-04-16 08:40:16'),
  (10, 'hh', 1, 1, '', 0, '', '1.jpg', 1, 0, '2019-04-16 08:50:59'),
  (11, 'EO3691', 1, 6, '4AG', 1993, 'AE111', '1.jpg', 2, 0, '2019-04-24 12:34:26'),
  (12, 'XXX999', 1, 6, '1234567890', 2000, '1234567890', '1.jpg', 6, 0, '2019-05-01 10:49:03'),
  (13, 'D4V411', 8, 12, '.', 2002, '.', '1.jpeg', 7, 1, '2019-05-14 11:40:44'),
  (14, 'F8V640', 9, 13, '15s', 2014, 'lSJZ14EES015187', '1.jpeg', 8, 0, '2019-05-15 10:37:26'),
  (15, 'ZZZ000', 2, 7, 'UWERUUWERU834584538', 1990, 'JHFHFH85858', '1.jpg', 12, 0, '2019-05-15 18:18:57'),
  (16, 'C2Y-783', 11, 18, 'QR25', 2005, '.', '1.jpg', 34, 1, '2019-05-27 11:30:07'),
  (17, '12345678', 18, 24, '4AG', 1989, '.', '1.jpg', 35, 0, '2019-05-27 12:18:09'),
  (18, 'XXY999', 2, 7, 'UTYTYTRYT6565656', 2001, 'JHJHJHJH878787', '1.jpg', 36, 0, '2019-05-27 18:49:16'),
  (19, 'F7R621', 20, 26, 'SR20DET', 1993, '', '1.jpg', 38, 1, '2019-05-28 09:47:55'),
  (20, 'A3W159', 7, 9, 'B186A', 1993, '.', '1.jpg', 39, 1, '2019-05-28 10:02:03'),
  (21, 'LLL111', 1, 6, 'UTYTYTRYT6565656', 2013, 'JHJHJHJH878787', '1.jpg', 41, 0, '2019-05-28 13:18:05'),
  (22, '08D258', 7, 9, '24', 2012, '111', '', 42, 1, '2019-05-29 09:53:23'),
  (23, 'F1R235', 7, 9, 'K20A', 2007, '.', '1.jpg', 47, 0, '2019-06-28 12:20:43'),
  (24, 'B7L535', 20, 27, 'GA16', 1992, 'BEAB13012096', '1.jpeg', 48, 1, '2019-07-01 10:34:28'),
  (25, 'f9R555', 6, 28, 'G4F', 2014, 'KTMHDH41CAEU125414', '1.jpeg', 49, 1, '2019-07-01 11:11:27'),
  (26, '123456', 21, 29, 'M16A', 2007, '1111', '1.jpg', 52, 1, '2019-07-10 10:01:51'),
  (27, '00000', 7, 9, 'D16b', 1996, '1111', '1.jpeg', 55, 1, '2019-07-12 09:44:52'),
  (28, 'A7Z874', 20, 30, 'kA24', 2010, '', '1.jpg', 56, 1, '2019-07-12 10:28:25'),
  (29, '11111', 1, 23, '356tE', 1985, '111111111', '1.jpg', 57, 1, '2019-07-15 09:15:18'),
  (30, 'FQ1812', 15, 17, '4AG', 1980, '.', '1.jpg', 58, 1, '2019-07-15 11:05:54'),
  (31, '1234567', 14, 16, 'B1BC', 1995, '11111', '1.jpg', 53, 1, '2019-07-15 11:39:54'),
  (32, '123456789', 11, 32, '.', 11111, '.', '1.jpg', 59, 1, '2019-07-16 17:50:10'),
  (33, '789456', 1, 6, '4AG', 1996, '1111', '1.jpg', 60, 1, '2019-07-19 10:19:58'),
  (34, '77777', 1, 23, '356TE', 1992, '11111', '1.jpg', 63, 1, '2019-07-23 09:53:15'),
  (35, 'AOD856', 12, 19, '4EFTE', 1996, '11111', '1.jpg', 62, 1, '2019-07-23 11:04:24'),
  (36, 'S1M035', 1, 15, '4AG', 1994, '20V BT', '1.jpg', 64, 1, '2019-08-20 16:46:53'),
  (37, 'AM12245', 1, 33, '4AG', 1986, '11111', '1.jpg', 65, 1, '2019-08-20 17:34:51'),
  (38, 'AM122446', 1, 33, '4AG', 1986, '1111', '1.jpg', 66, 1, '2019-08-20 19:32:05'),
  (39, 'am122447', 1, 33, '4AG', 1986, '1111', '1.jpg', 66, 0, '2019-08-20 19:32:39'),
  (40, 'A8K185', 11, 32, '2.0', 2010, '.', '1.jpg', 68, 1, '2019-08-21 16:26:37'),
  (41, 'ASF4524', 7, 9, 'B16B', 1996, '15647', '', 39, 1, '2019-08-21 17:33:18'),
  (42, 'ASF4525', 7, 9, 'B16B', 1996, '11111', '1.jpg', 39, 1, '2019-08-21 17:38:00'),
  (43, 'LSF874', 12, 19, '4AG 16v', 1983, 'sin serie', '1.jpg', 79, 1, '2019-08-22 11:52:20'),
  (44, 'C0Y195', 8, 34, '4M41CX4649', 1999, 'V78W0000424', '1.jpg', 82, 1, '2019-08-22 15:03:45'),
  (45, 'D2W081', 18, 35, '2.8', 2000, 'WBA', '1.jpg', 83, 1, '2019-08-23 11:24:50'),
  (46, 'A6S210', 21, 29, '1600', 2010, 'no tiene ', '1.jpg', 84, 1, '2019-08-24 16:15:59');
  
  --
  -- Índices para tablas volcadas
  --
  
  --
  -- Indices de la tabla `clientes`
  --
  ALTER TABLE `clientes`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indices de la tabla `compras`
  --
  ALTER TABLE `compras`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indices de la tabla `comprasRepuestos`
  --
  ALTER TABLE `comprasRepuestos`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indices de la tabla `datosGenerales`
  --
  ALTER TABLE `datosGenerales`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indices de la tabla `entregaImagen`
  --
  ALTER TABLE `entregaImagen`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indices de la tabla `entregas`
  --
  ALTER TABLE `entregas`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indices de la tabla `entregaServicios`
  --
  ALTER TABLE `entregaServicios`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indices de la tabla `imagenEntregas`
  --
  ALTER TABLE `imagenEntregas`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indices de la tabla `marcas`
  --
  ALTER TABLE `marcas`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indices de la tabla `modelos`
  --
  ALTER TABLE `modelos`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indices de la tabla `pagoClientes`
  --
  ALTER TABLE `pagoClientes`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indices de la tabla `personas`
  --
  ALTER TABLE `personas`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indices de la tabla `piezas`
  --
  ALTER TABLE `piezas`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indices de la tabla `servicioRepuestos`
  --
  ALTER TABLE `servicioRepuestos`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indices de la tabla `servicios`
  --
  ALTER TABLE `servicios`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indices de la tabla `tipoDocumentos`
  --
  ALTER TABLE `tipoDocumentos`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indices de la tabla `tipoMonedas`
  --
  ALTER TABLE `tipoMonedas`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indices de la tabla `tipoPagos`
  --
  ALTER TABLE `tipoPagos`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indices de la tabla `tipoPersonas`
  --
  ALTER TABLE `tipoPersonas`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indices de la tabla `usuario`
  --
  ALTER TABLE `usuario`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indices de la tabla `vehiculos`
  --
  ALTER TABLE `vehiculos`
    ADD PRIMARY KEY (`id`);
  
  --
  -- AUTO_INCREMENT de las tablas volcadas
  --
  
  --
  -- AUTO_INCREMENT de la tabla `clientes`
  --
  ALTER TABLE `clientes`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=85;
  
  --
  -- AUTO_INCREMENT de la tabla `compras`
  --
  ALTER TABLE `compras`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=73;
  
  --
  -- AUTO_INCREMENT de la tabla `comprasRepuestos`
  --
  ALTER TABLE `comprasRepuestos`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=112;
  
  --
  -- AUTO_INCREMENT de la tabla `datosGenerales`
  --
  ALTER TABLE `datosGenerales`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  
  --
  -- AUTO_INCREMENT de la tabla `entregaImagen`
  --
  ALTER TABLE `entregaImagen`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;
  
  --
  -- AUTO_INCREMENT de la tabla `entregas`
  --
  ALTER TABLE `entregas`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=45;
  
  --
  -- AUTO_INCREMENT de la tabla `entregaServicios`
  --
  ALTER TABLE `entregaServicios`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=131;
  
  --
  -- AUTO_INCREMENT de la tabla `imagenEntregas`
  --
  ALTER TABLE `imagenEntregas`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=39;
  
  --
  -- AUTO_INCREMENT de la tabla `marcas`
  --
  ALTER TABLE `marcas`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;
  
  --
  -- AUTO_INCREMENT de la tabla `modelos`
  --
  ALTER TABLE `modelos`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=36;
  
  --
  -- AUTO_INCREMENT de la tabla `pagoClientes`
  --
  ALTER TABLE `pagoClientes`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
  
  --
  -- AUTO_INCREMENT de la tabla `personas`
  --
  ALTER TABLE `personas`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
  
  --
  -- AUTO_INCREMENT de la tabla `piezas`
  --
  ALTER TABLE `piezas`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=247;
  
  --
  -- AUTO_INCREMENT de la tabla `servicioRepuestos`
  --
  ALTER TABLE `servicioRepuestos`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=82;
  
  --
  -- AUTO_INCREMENT de la tabla `servicios`
  --
  ALTER TABLE `servicios`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=84;
  
  --
  -- AUTO_INCREMENT de la tabla `tipoDocumentos`
  --
  ALTER TABLE `tipoDocumentos`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
  
  --
  -- AUTO_INCREMENT de la tabla `tipoMonedas`
  --
  ALTER TABLE `tipoMonedas`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
  
  --
  -- AUTO_INCREMENT de la tabla `tipoPagos`
  --
  ALTER TABLE `tipoPagos`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
  
  --
  -- AUTO_INCREMENT de la tabla `tipoPersonas`
  --
  ALTER TABLE `tipoPersonas`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  
  --
  -- AUTO_INCREMENT de la tabla `usuario`
  --
  ALTER TABLE `usuario`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
  
  --
  -- AUTO_INCREMENT de la tabla `vehiculos`
  --
  ALTER TABLE `vehiculos`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=47;
  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 */;
  