API tools faq
paste
Advertisement
Guest User

LSC Database

a guest
Jul 30th, 2018
564
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 56.57 KB | None | 0 0
raw download clone embed print report
  1. -- --------------------------------------------------------
  2. -- Host:                         localhost
  3. -- Versión del servidor:         5.7.19 - MySQL Community Server (GPL)
  4. -- SO del servidor:              Win64
  5. -- HeidiSQL Versión:             9.4.0.5125
  6. -- --------------------------------------------------------
  7.  
  8. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  9. /*!40101 SET NAMES utf8 */;
  10. /*!50503 SET NAMES utf8mb4 */;
  11. /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  12. /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  13.  
  14.  
  15. -- Volcando estructura de base de datos para lsc
  16. CREATE DATABASE IF NOT EXISTS `lsc` /*!40100 DEFAULT CHARACTER SET latin1 */;
  17. USE `lsc`;
  18.  
  19. -- Volcando estructura para tabla lsc.albaranes
  20. CREATE TABLE IF NOT EXISTS `albaranes` (
  21.   `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  22.   `nro_albaran` INT(11) NOT NULL,
  23.   `idempresa` INT(10) UNSIGNED NOT NULL,
  24.   `idcliente` INT(10) UNSIGNED NOT NULL,
  25.   `idvehiculo` INT(10) UNSIGNED NOT NULL,
  26.   `fecha` DATE NOT NULL,
  27.   `fecha_entrada` DATE DEFAULT NULL,
  28.   `fecha_salida` DATE DEFAULT NULL,
  29.   `formas_pago` enum('Efectivo','RedCompra','Credito','Cheque','Otros') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  30.   `credito` enum('No','7 Dias','10 Dias','15 Dias','30 dias') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  31.   `empleado` text COLLATE utf8mb4_unicode_ci,
  32.   `retencion` text COLLATE utf8mb4_unicode_ci,
  33.   `observaciones` text COLLATE utf8mb4_unicode_ci,
  34.   `kilometros` text COLLATE utf8mb4_unicode_ci,
  35.   `pagado` tinyint(1) DEFAULT NULL,
  36.   `factura` enum('Sin Factura','Por Facturar','Facturado','Facturado Cancelado','Factuado Por Cancelar','Cancelado Por Facturar') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  37.   `nrocomprobante` text COLLATE utf8mb4_unicode_ci,
  38.   `nrocheque` text COLLATE utf8mb4_unicode_ci,
  39.   `tipo_iva` INT(11) DEFAULT NULL,
  40.   `iva` DOUBLE(8,2) DEFAULT NULL,
  41.   `subtotal` DOUBLE(8,2) DEFAULT NULL,
  42.   `descuento` DOUBLE(8,2) DEFAULT NULL,
  43.   `total` DOUBLE(8,2) DEFAULT NULL,
  44.   `created_at` TIMESTAMP NULL DEFAULT NULL,
  45.   `updated_at` TIMESTAMP NULL DEFAULT NULL,
  46.   PRIMARY KEY (`id`),
  47.   KEY `albaranes_idempresa_foreign` (`idempresa`),
  48.   KEY `albaranes_idcliente_foreign` (`idcliente`),
  49.   KEY `albaranes_idvehiculo_foreign` (`idvehiculo`),
  50.   CONSTRAINT `albaranes_idcliente_foreign` FOREIGN KEY (`idcliente`) REFERENCES `clients` (`id`),
  51.   CONSTRAINT `albaranes_idempresa_foreign` FOREIGN KEY (`idempresa`) REFERENCES `companies` (`id`),
  52.   CONSTRAINT `albaranes_idvehiculo_foreign` FOREIGN KEY (`idvehiculo`) REFERENCES `vehicles` (`id`)
  53. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  54.  
  55. -- Volcando datos para la tabla lsc.albaranes: ~0 rows (aproximadamente)
  56. DELETE FROM `albaranes`;
  57. /*!40000 ALTER TABLE `albaranes` DISABLE KEYS */;
  58. /*!40000 ALTER TABLE `albaranes` ENABLE KEYS */;
  59.  
  60. -- Volcando estructura para tabla lsc.albaranes_items
  61. CREATE TABLE IF NOT EXISTS `albaranes_items` (
  62.   `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  63.   `idalbaran` INT(11) NOT NULL,
  64.   `linea` INT(11) DEFAULT NULL,
  65.   `idarticulo` INT(10) UNSIGNED NOT NULL,
  66.   `descripcion` text COLLATE utf8mb4_unicode_ci,
  67.   `cantidad` DOUBLE(8,2) DEFAULT NULL,
  68.   `precio` DOUBLE(8,2) DEFAULT NULL,
  69.   `descuento` DOUBLE(8,2) DEFAULT NULL,
  70.   `idvehiculo` INT(10) UNSIGNED NOT NULL,
  71.   `created_at` TIMESTAMP NULL DEFAULT NULL,
  72.   `updated_at` TIMESTAMP NULL DEFAULT NULL,
  73.   PRIMARY KEY (`id`),
  74.   KEY `albaranes_items_idarticulo_foreign` (`idarticulo`),
  75.   KEY `albaranes_items_idvehiculo_foreign` (`idvehiculo`),
  76.   CONSTRAINT `albaranes_items_idarticulo_foreign` FOREIGN KEY (`idarticulo`) REFERENCES `articles` (`id`),
  77.   CONSTRAINT `albaranes_items_idvehiculo_foreign` FOREIGN KEY (`idvehiculo`) REFERENCES `vehicles` (`id`)
  78. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  79.  
  80. -- Volcando datos para la tabla lsc.albaranes_items: ~0 rows (aproximadamente)
  81. DELETE FROM `albaranes_items`;
  82. /*!40000 ALTER TABLE `albaranes_items` DISABLE KEYS */;
  83. /*!40000 ALTER TABLE `albaranes_items` ENABLE KEYS */;
  84.  
  85. -- Volcando estructura para tabla lsc.articles
  86. CREATE TABLE IF NOT EXISTS `articles` (
  87.   `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  88.   `idfamilia` INT(10) UNSIGNED NOT NULL,
  89.   `idempresa` INT(10) UNSIGNED NOT NULL,
  90.   `codigo` VARCHAR(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  91.   `descripcion` VARCHAR(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  92.   `proveedor` INT(11) DEFAULT NULL,
  93.   `proveedor2` INT(11) DEFAULT NULL,
  94.   `proveedor3` INT(11) DEFAULT NULL,
  95.   `tipo_articulo` enum('Articulo','Mano de Obra') COLLATE utf8mb4_unicode_ci NOT NULL,
  96.   `no_actualizar` tinyint(1) DEFAULT NULL,
  97.   `ubicacion` VARCHAR(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  98.   `stock_inicial` DOUBLE(8,2) DEFAULT NULL,
  99.   `stock` DOUBLE(8,2) DEFAULT NULL,
  100.   `stock_minimo` DOUBLE(8,2) DEFAULT NULL,
  101.   `stock_maximo` DOUBLE(8,2) DEFAULT NULL,
  102.   `stock_optimo` DOUBLE(8,2) DEFAULT NULL,
  103.   `min_vender` DOUBLE(8,2) DEFAULT NULL,
  104.   `min_comprar` DOUBLE(8,2) DEFAULT NULL,
  105.   `pvp` DOUBLE(8,2) DEFAULT NULL,
  106.   `pvp2` DOUBLE(8,2) DEFAULT NULL,
  107.   `pvp3` DOUBLE(8,2) DEFAULT NULL,
  108.   `pvp4` DOUBLE(8,2) DEFAULT NULL,
  109.   `beneficio` DOUBLE(8,2) DEFAULT NULL,
  110.   `beneficio2` DOUBLE(8,2) DEFAULT NULL,
  111.   `beneficio3` DOUBLE(8,2) DEFAULT NULL,
  112.   `beneficio4` DOUBLE(8,2) DEFAULT NULL,
  113.   `no_avisar` tinyint(1) DEFAULT NULL,
  114.   `observaciones` text COLLATE utf8mb4_unicode_ci,
  115.   `imagen` VARCHAR(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  116.   `created_at` TIMESTAMP NULL DEFAULT NULL,
  117.   `updated_at` TIMESTAMP NULL DEFAULT NULL,
  118.   PRIMARY KEY (`id`),
  119.   UNIQUE KEY `articles_codigo_unique` (`codigo`),
  120.   KEY `articles_idfamilia_foreign` (`idfamilia`),
  121.   KEY `articles_idempresa_foreign` (`idempresa`),
  122.   CONSTRAINT `articles_idempresa_foreign` FOREIGN KEY (`idempresa`) REFERENCES `companies` (`id`),
  123.   CONSTRAINT `articles_idfamilia_foreign` FOREIGN KEY (`idfamilia`) REFERENCES `families` (`id`)
  124. ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  125.  
  126. -- Volcando datos para la tabla lsc.articles: ~1 rows (aproximadamente)
  127. DELETE FROM `articles`;
  128. /*!40000 ALTER TABLE `articles` DISABLE KEYS */;
  129. INSERT INTO `articles` (`id`, `idfamilia`, `idempresa`, `codigo`, `descripcion`, `proveedor`, `proveedor2`, `proveedor3`, `tipo_articulo`, `no_actualizar`, `ubicacion`, `stock_inicial`, `stock`, `stock_minimo`, `stock_maximo`, `stock_optimo`, `min_vender`, `min_comprar`, `pvp`, `pvp2`, `pvp3`, `pvp4`, `beneficio`, `beneficio2`, `beneficio3`, `beneficio4`, `no_avisar`, `observaciones`, `imagen`, `created_at`, `updated_at`) VALUES
  130.     (1, 2, 1, '2018', 'prueba', NULL, NULL, NULL, 'Articulo', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2500.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
  131.     (4, 2, 1, '2019', 'prueba', NULL, NULL, NULL, 'Articulo', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2500.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
  132. /*!40000 ALTER TABLE `articles` ENABLE KEYS */;
  133.  
  134. -- Volcando estructura para tabla lsc.clients
  135. CREATE TABLE IF NOT EXISTS `clients` (
  136.   `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  137.   `rut` VARCHAR(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  138.   `titulo` VARCHAR(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  139.   `nombre` VARCHAR(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  140.   `apellido` VARCHAR(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  141.   `domicilio` VARCHAR(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  142.   `provincia` VARCHAR(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  143.   `poblacion` VARCHAR(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  144.   `pais` VARCHAR(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  145.   `email` VARCHAR(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  146.   `phone` VARCHAR(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  147.   `phone2` VARCHAR(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  148.   `created_at` TIMESTAMP NULL DEFAULT NULL,
  149.   `updated_at` TIMESTAMP NULL DEFAULT NULL,
  150.   PRIMARY KEY (`id`),
  151.   UNIQUE KEY `clients_rut_unique` (`rut`),
  152.   UNIQUE KEY `clients_email_unique` (`email`)
  153. ) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  154.  
  155. -- Volcando datos para la tabla lsc.clients: ~48 rows (aproximadamente)
  156. DELETE FROM `clients`;
  157. /*!40000 ALTER TABLE `clients` DISABLE KEYS */;
  158. INSERT INTO `clients` (`id`, `rut`, `titulo`, `nombre`, `apellido`, `domicilio`, `provincia`, `poblacion`, `pais`, `email`, `phone`, `phone2`, `created_at`, `updated_at`) VALUES
  159.     (1, 'Hell 759', 'Sr.', 'Astrid Dietrich DVM', 'Mrs. Pattie Blick V', '1602 Gorczany Corner\nLizziestad, ND 09175-1011', 'South', 'West', 'Niger', 'augusta02@example.net', '800.288.5300', '+8541004638674', '2018-07-12 17:32:13', '2018-07-12 17:32:13'),
  160.     (2, 'Hell 944', 'Sr.', 'Prof. Helga Langworth', 'Prof. Kayleigh Rowe', '6077 Steuber Mission Apt. 638\nStiedemannfort, MS 20686', 'Lake', 'North', 'Saudi Arabia', 'stanton.alda@example.net', '844.617.5347', '+5004667362561', '2018-07-12 17:32:13', '2018-07-12 17:32:13'),
  161.     (3, 'Hell 122', 'Sr.', 'Mrs. Sandra Green', 'Hal Jerde', '30435 Armstrong Neck Suite 392\nEleazarmouth, AZ 80347-8672', 'Lake', 'Lake', 'Montserrat', 'carroll.bessie@example.net', '888.522.9314', '+1186207197548', '2018-07-12 17:32:13', '2018-07-12 17:32:13'),
  162.     (4, 'Hell 012', 'Sr.', 'Joana Mertz', 'Pasquale Kuhic', '341 Angeline Village Suite 672\nRaynorberg, TN 37484', 'North', 'South', 'Jordan', 'caitlyn25@example.org', '1-877-559-5243', '+3810824519970', '2018-07-12 17:32:13', '2018-07-12 17:32:13'),
  163.     (5, 'Hell 721', 'Sr.', 'Jazmyne Gleason', 'Loy Barrows', '5329 Arielle Run Suite 089\nPort Carlottafort, MD 83194-8388', 'North', 'New', 'Zimbabwe', 'obosco@example.org', '877.360.2533', '+9330161728751', '2018-07-12 17:32:13', '2018-07-12 17:32:13'),
  164.     (6, 'Hell 922', 'Sr.', 'Patricia Bergnaum', 'Mr. Timothy Kihn Sr.', '483 Collin Springs Apt. 958\nNorth Cooperfort, NJ 38265-1742', 'Lake', 'Lake', 'Guinea-Bissau', 'saige47@example.com', '(877) 839-7364', '+2088200186029', '2018-07-12 17:32:13', '2018-07-12 17:32:13'),
  165.     (7, 'Hell 492', 'Sr.', 'Robin Eichmann', 'Dannie Prohaska', '2997 Gulgowski Ramp Apt. 938\nDooleyside, WA 87239', 'East', 'North', 'Finland', 'spencer41@example.net', '(888) 392-5645', '+3008662159516', '2018-07-12 17:32:13', '2018-07-12 17:32:13'),
  166.     (8, 'Hell 900', 'Sr.', 'Dr. Henry Graham Jr.', 'Nelle McCullough DVM', '904 Koss Manors\nMyrtiefurt, SC 66356', 'East', 'South', 'Nauru', 'ole17@example.org', '(800) 774-9685', '+1836082849748', '2018-07-12 17:32:13', '2018-07-12 17:32:13'),
  167.     (9, 'Hell 342', 'Sr.', 'Dr. Jayson Steuber PhD', 'Miss Betty Ortiz DVM', '9265 Minerva Green\nSouth Elisabethfurt, AL 68907-8953', 'Port', 'West', 'Bosnia and Herzegovina', 'mswift@example.com', '888.932.3410', '+1388989481549', '2018-07-12 17:32:13', '2018-07-12 17:32:13'),
  168.     (10, 'Hell 933', 'Sr.', 'Lilliana Schimmel', 'Mr. Toney Bednar IV', '386 Leon Run Suite 989\nLake Kaydenburgh, CA 66509', 'East', 'New', 'Hungary', 'makayla77@example.org', '(800) 477-7125', '+3007469256365', '2018-07-12 17:32:13', '2018-07-12 17:32:13'),
  169.     (11, 'Hell 710', 'Sr.', 'Patience Hayes', 'Santina Gorczany II', '530 Adelia Terrace Apt. 881\nNedchester, KS 55614-5927', 'East', 'Lake', 'Turkey', 'lebsack.angelina@example.net', '(800) 498-2893', '+9260506301757', '2018-07-12 17:32:13', '2018-07-12 17:32:13'),
  170.     (12, 'Hell 309', 'Sr.', 'Alba Grimes', 'Isaac Legros', '91266 Pollich Passage Apt. 128\nMaeside, VA 49817-8343', 'East', 'New', 'Uzbekistan', 'moen.demarcus@example.com', '800-534-4437', '+7912831966198', '2018-07-12 17:32:13', '2018-07-12 17:32:13'),
  171.     (13, 'Hell 471', 'Sr.', 'Jayson Satterfield Jr.', 'Tanner Sipes III', '46579 Genoveva Rest\nWest Florine, NY 89170-4918', 'West', 'Port', 'Saint Kitts and Nevis', 'homenick.stan@example.org', '866.994.6674', '+2351429883409', '2018-07-12 17:32:13', '2018-07-12 17:32:13'),
  172.     (14, 'Hell 415', 'Sr.', 'Chance Doyle', 'Shyanne Ziemann', '536 Gaylord Tunnel Apt. 414\nKelliland, TN 07661-7527', 'New', 'Port', 'American Samoa', 'dessie81@example.org', '1-888-425-8852', '+9165067602731', '2018-07-12 17:32:13', '2018-07-12 17:32:13'),
  173.     (15, 'Hell 018', 'Sr.', 'Jasmin Hintz MD', 'Miss Norma Ondricka MD', '32860 Klein Crescent\nSouth Vickie, SC 06162-6258', 'West', 'Port', 'Slovakia (Slovak Republic)', 'kshlerin.alaina@example.net', '800.872.6639', '+8494648361961', '2018-07-12 17:32:13', '2018-07-12 17:32:13'),
  174.     (16, 'Hell 485', 'Sr.', 'Gayle Hyatt', 'Ms. Abbigail Tillman I', '317 Smith Spurs Apt. 229\nPort Aricshire, NY 46185-1045', 'East', 'Port', 'Norfolk Island', 'hailie95@example.org', '1-800-567-3755', '+1104144863043', '2018-07-12 17:32:14', '2018-07-12 17:32:14'),
  175.     (17, 'Hell 702', 'Sr.', 'Duncan Feest', 'Evalyn Donnelly', '86354 Stanton Land\nWest Antwan, VT 93441-7740', 'New', 'South', 'Bhutan', 'ward.emmitt@example.net', '1-888-788-1829', '+2119232698540', '2018-07-12 17:32:14', '2018-07-12 17:32:14'),
  176.     (18, 'Hell 192', 'Sr.', 'Miss Gretchen Murray', 'Prof. Tomas Ebert V', '876 Zulauf Creek\nMackenzieville, NE 39059-8157', 'Lake', 'South', 'El Salvador', 'magnus.kuhn@example.org', '1-877-555-9502', '+9297703383489', '2018-07-12 17:32:14', '2018-07-12 17:32:14'),
  177.     (19, 'Hell 278', 'Sr.', 'Reed Mertz DVM', 'Rickie Walsh', '5760 Cloyd Way\nWilhelmineland, AR 23291', 'East', 'East', 'Saint Barthelemy', 'cbatz@example.com', '844-787-3846', '+4468130585474', '2018-07-12 17:32:14', '2018-07-12 17:32:14'),
  178.     (20, 'Hell 207', 'Sr.', 'Ms. Raegan Kemmer V', 'Felicita Batz', '294 Shania Mount Suite 219\nNew Feliciaville, VA 45120', 'Lake', 'North', 'Saint Lucia', 'jackeline.hagenes@example.org', '855.603.6803', '+3453598701689', '2018-07-12 17:32:14', '2018-07-12 17:32:14'),
  179.     (21, 'Hell 951', 'Sr.', 'Dr. Dejah Baumbach I', 'Destin Williamson', '735 Emory Extensions\nLake Bartside, DC 01339', 'Lake', 'East', 'Mozambique', 'bertha.waelchi@example.org', '800.213.5131', '+9481718799089', '2018-07-12 17:32:14', '2018-07-12 17:32:14'),
  180.     (22, 'Hell 715', 'Sr.', 'Judah Dach II', 'Prof. Luther Jakubowski PhD', '3432 Blick Springs\nIlaside, MO 72381-5629', 'New', 'New', 'Hong Kong', 'durgan.okey@example.net', '888-737-4074', '+1572642159914', '2018-07-12 17:32:14', '2018-07-12 17:32:14'),
  181.     (23, 'Hell 733', 'Sr.', 'Kaci Wyman', 'Audreanne Breitenberg', '204 Jaydon Fords Suite 946\nJohnpaulhaven, ID 45893', 'Port', 'Port', 'Guernsey', 'kamren30@example.org', '844-647-8598', '+4605080686975', '2018-07-12 17:32:14', '2018-07-12 17:32:14'),
  182.     (24, 'Hell 516', 'Sr.', 'Prof. Bruce Flatley', 'Carrie Eichmann', '629 Hackett Islands Apt. 214\nCameronchester, CT 09410', 'West', 'Port', 'Lao People\'s Democratic Republic', 'jordy36@example.org', '844-817-8657', '+9242619094777', '2018-07-12 17:32:14', '2018-07-12 17:32:14'),
  183.     (25, 'Hell 203', 'Sr.', 'Dr. Ansel Rodriguez IV', 'Kari Goldner', '1810 Langosh Orchard\nPort Arvillaport, DE 60827-7167', 'Port', 'South', 'Malawi', 'bahringer.angela@example.net', '1-800-219-6665', '+3470264540479', '2018-07-12 17:32:14', '2018-07-12 17:32:14'),
  184.     (26, 'Hell 699', 'Sr.', 'Lila Jones', 'Dr. Giuseppe Cassin', '8418 Davis Inlet\nWestville, TN 86883-7295', 'North', 'New', 'Slovakia (Slovak Republic)', 'upton.elmo@example.net', '(855) 274-3671', '+3606135736038', '2018-07-12 17:32:14', '2018-07-12 17:32:14'),
  185.     (27, 'Hell 946', 'Sr.', 'Edythe Schultz', 'Tianna Johnson', '990 D\'Amore Garden Suite 996\nHaleyside, ID 80958-0221', 'Port', 'New', 'Benin', 'hkoelpin@example.net', '(866) 874-8153', '+9533954928434', '2018-07-12 17:32:14', '2018-07-12 17:32:14'),
  186.     (28, 'Hell 188', 'Sr.', 'Mr. Waldo Parisian PhD', 'Carleton Muller', '20059 Jaron Forge\nTillmanfurt, AL 36622', 'New', 'North', 'Burkina Faso', 'doyle.willie@example.org', '1-877-331-5282', '+7442911304236', '2018-07-12 17:32:14', '2018-07-12 17:32:14'),
  187.     (29, 'Hell 230', 'Sr.', 'Merritt Wiegand', 'Amie Von', '9034 McGlynn Causeway Apt. 489\nKearahaven, LA 15714-8947', 'South', 'West', 'Antigua and Barbuda', 'cassin.stuart@example.net', '800-660-8670', '+5592056542455', '2018-07-12 17:32:14', '2018-07-12 17:32:14'),
  188.     (30, 'Hell 226', 'Sr.', 'Dr. Ariel Blick DDS', 'Miss Joelle Parisian', '6873 Trent Canyon\nPort Bernadette, WV 36323-4621', 'East', 'Lake', 'Andorra', 'neal.lueilwitz@example.net', '1-855-633-7530', '+9255110126812', '2018-07-12 17:32:14', '2018-07-12 17:32:14'),
  189.     (31, 'Hell 630', 'Sr.', 'Neva VonRueden', 'Miss Winnifred Hilll V', '429 McDermott Rapid Apt. 005\nNew Milliestad, ID 11816-4045', 'New', 'New', 'Mozambique', 'fpfeffer@example.com', '888.481.0380', '+7420323349270', '2018-07-12 17:32:14', '2018-07-12 17:32:14'),
  190.     (32, 'Hell 084', 'Sr.', 'Alexander Jaskolski', 'Marquise Buckridge', '815 Wiegand Court Suite 883\nSouth Carolyn, MO 48308-5463', 'Port', 'Lake', 'Tajikistan', 'greenholt.itzel@example.org', '1-866-810-0697', '+3507451347298', '2018-07-12 17:32:14', '2018-07-12 17:32:14'),
  191.     (33, 'Hell 771', 'Sr.', 'Korbin DuBuque III', 'Zaria Kirlin', '9150 Ashly Wells Apt. 327\nBoyerborough, AK 82807', 'New', 'North', 'Cyprus', 'herbert.pouros@example.org', '800.926.3215', '+7083570725914', '2018-07-12 17:32:14', '2018-07-12 17:32:14'),
  192.     (34, 'Hell 952', 'Sr.', 'Reyes Schuster', 'Loyce Hyatt', '27646 Koepp Cliffs Suite 298\nPort Chasefurt, CT 12002-5248', 'Port', 'West', 'Belgium', 'shermiston@example.org', '1-855-871-6386', '+5791411515844', '2018-07-12 17:32:14', '2018-07-12 17:32:14'),
  193.     (35, 'Hell 212', 'Sr.', 'Valentin Collins', 'Mrs. Sandrine Gusikowski V', '58203 Greenholt Spurs Apt. 706\nHowestad, HI 46904', 'East', 'Port', 'Chad', 'aondricka@example.org', '800.640.8385', '+1337016939083', '2018-07-12 17:32:14', '2018-07-12 17:32:14'),
  194.     (36, 'Hell 787', 'Sr.', 'Travon Hermann', 'Devan O\'Connell', '95747 Alessandro Walks Suite 286\nSkilesport, OH 80729', 'New', 'South', 'Japan', 'kip47@example.org', '800-452-3301', '+9231797342166', '2018-07-12 17:32:14', '2018-07-12 17:32:14'),
  195.     (37, 'Hell 668', 'Sr.', 'Kris Reichel III', 'Makenna Moen II', '23618 Mayert Bridge Suite 095\nTorpfort, PA 48014', 'North', 'North', 'Guernsey', 'morgan.gulgowski@example.org', '1-866-382-6569', '+2854781279069', '2018-07-12 17:32:14', '2018-07-12 17:32:14'),
  196.     (38, 'Hell 707', 'Sr.', 'Miss Adelle Brown V', 'Duane Walter', '870 Dibbert Springs\nNorth Herman, MO 05063', 'Port', 'North', 'Niger', 'sibyl21@example.com', '800.416.1784', '+6063493558574', '2018-07-12 17:32:14', '2018-07-12 17:32:14'),
  197.     (39, 'Hell 843', 'Sr.', 'Sophia Considine', 'Mr. Keanu Collins', '941 Monahan Fork Apt. 009\nMillerstad, SC 24950', 'Port', 'Port', 'Syrian Arab Republic', 'estefania.stroman@example.net', '(844) 747-9884', '+9571613666810', '2018-07-12 17:32:14', '2018-07-12 17:32:14'),
  198.     (40, 'Hell 521', 'Sr.', 'Colten Wisoky', 'Emmie Goyette', '5075 Karl Mountains\nNorth Marcview, PA 26888', 'West', 'Lake', 'Taiwan', 'emmerich.gwendolyn@example.com', '(844) 518-1453', '+2422475163370', '2018-07-12 17:32:14', '2018-07-12 17:32:14'),
  199.     (41, 'Hell 060', 'Sr.', 'Madonna Green', 'Omari Little', '59506 Dominic Neck Apt. 964\nWest Demarcoville, TX 02001-0609', 'New', 'North', 'Armenia', 'little.aletha@example.net', '1-855-629-4584', '+8815252406519', '2018-07-12 17:32:14', '2018-07-12 17:32:14'),
  200.     (42, 'Hell 746', 'Sr.', 'Dr. Claude Moore V', 'Alejandra Quitzon', '6457 Zena Club\nHermanville, ID 40310', 'South', 'Lake', 'United Kingdom', 'garrison.lindgren@example.org', '1-866-546-9625', '+6854748241631', '2018-07-12 17:32:14', '2018-07-12 17:32:14'),
  201.     (43, 'Hell 026', 'Sr.', 'Orrin Cummerata', 'Rafael Schumm', '877 Mann Orchard\nNew Edahaven, AR 27547-2313', 'South', 'Port', 'Pakistan', 'xcartwright@example.com', '844.945.2993', '+8392075191683', '2018-07-12 17:32:14', '2018-07-12 17:32:14'),
  202.     (44, 'Hell 992', 'Sr.', 'Orland Quigley', 'Miss Adeline Bashirian DDS', '503 Terry Corner Suite 101\nGoodwinville, OK 54929', 'West', 'West', 'Madagascar', 'bradley.metz@example.com', '1-855-436-2746', '+3433555168805', '2018-07-12 17:32:14', '2018-07-12 17:32:14'),
  203.     (45, 'Hell 416', 'Sr.', 'Heath Goyette', 'Brian Mitchell IV', '41900 Guadalupe Oval Suite 215\nNorth Aubreeport, WY 47560-0425', 'West', 'West', 'Burundi', 'jfriesen@example.org', '844-367-7079', '+2784443052864', '2018-07-12 17:32:14', '2018-07-12 17:32:14'),
  204.     (46, 'Hell 609', 'Sr.', 'Stevie Predovic', 'Burdette Cummerata', '202 Simonis Forges Suite 575\nO\'Connertown, OK 79783', 'South', 'New', 'Seychelles', 'stokes.queenie@example.org', '1-866-451-6460', '+2257255416642', '2018-07-12 17:32:15', '2018-07-12 17:32:15'),
  205.     (47, 'Hell 514', 'Sr.', 'Janick Labadie', 'Orie Bergnaum V', '6678 Jones Drive\nLednerfurt, OR 35556', 'West', 'South', 'Togo', 'cara.bartell@example.com', '1-866-815-3831', '+3669268123070', '2018-07-12 17:32:15', '2018-07-12 17:32:15'),
  206.     (48, 'Hell 898', 'Sr.', 'Corene Weissnat', 'Madeline Hamill', '301 Breitenberg Terrace\nGoodwintown, VA 63454', 'East', 'North', 'Algeria', 'keaton10@example.org', '1-866-993-0013', '+9609121770365', '2018-07-12 17:32:15', '2018-07-12 17:32:15');
  207. /*!40000 ALTER TABLE `clients` ENABLE KEYS */;
  208.  
  209. -- Volcando estructura para tabla lsc.companies
  210. CREATE TABLE IF NOT EXISTS `companies` (
  211.   `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  212.   `name_company` VARCHAR(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  213.   `email_company` VARCHAR(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  214.   `nif_company` VARCHAR(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  215.   `web_company` VARCHAR(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  216.   `boss_company` VARCHAR(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  217.   `phone_company` VARCHAR(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  218.   `phone2_company` VARCHAR(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  219.   `phone3_company` VARCHAR(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  220.   `adrees_company` VARCHAR(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  221.   `created_at` TIMESTAMP NULL DEFAULT NULL,
  222.   `updated_at` TIMESTAMP NULL DEFAULT NULL,
  223.   PRIMARY KEY (`id`)
  224. ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  225.  
  226. -- Volcando datos para la tabla lsc.companies: ~2 rows (aproximadamente)
  227. DELETE FROM `companies`;
  228. /*!40000 ALTER TABLE `companies` DISABLE KEYS */;
  229. INSERT INTO `companies` (`id`, `name_company`, `email_company`, `nif_company`, `web_company`, `boss_company`, `phone_company`, `phone2_company`, `phone3_company`, `adrees_company`, `created_at`, `updated_at`) VALUES
  230.     (1, 'LubrySystemCar', 'ophendesigner@gmail.com', '25799206-3', NULL, 'Jose Arrieta', '000000', NULL, NULL, NULL, '2018-07-12 17:32:10', '2018-07-12 17:32:10'),
  231.     (2, 'demo', 'osad@gmail.com', '2521-3', NULL, 'Jose 2', '000000', NULL, NULL, NULL, '2018-07-12 17:32:10', '2018-07-12 17:32:10');
  232. /*!40000 ALTER TABLE `companies` ENABLE KEYS */;
  233.  
  234. -- Volcando estructura para tabla lsc.deposits
  235. CREATE TABLE IF NOT EXISTS `deposits` (
  236.   `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  237.   `idempresa` INT(10) UNSIGNED NOT NULL,
  238.   `created_at` TIMESTAMP NULL DEFAULT NULL,
  239.   `updated_at` TIMESTAMP NULL DEFAULT NULL,
  240.   PRIMARY KEY (`id`),
  241.   KEY `deposits_idempresa_foreign` (`idempresa`),
  242.   CONSTRAINT `deposits_idempresa_foreign` FOREIGN KEY (`idempresa`) REFERENCES `companies` (`id`)
  243. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  244.  
  245. -- Volcando datos para la tabla lsc.deposits: ~0 rows (aproximadamente)
  246. DELETE FROM `deposits`;
  247. /*!40000 ALTER TABLE `deposits` DISABLE KEYS */;
  248. /*!40000 ALTER TABLE `deposits` ENABLE KEYS */;
  249.  
  250. -- Volcando estructura para tabla lsc.families
  251. CREATE TABLE IF NOT EXISTS `families` (
  252.   `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  253.   `idempresa` INT(10) UNSIGNED NOT NULL,
  254.   `nombre` VARCHAR(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  255.   `descripcion` text COLLATE utf8mb4_unicode_ci,
  256.   `created_at` TIMESTAMP NULL DEFAULT NULL,
  257.   `updated_at` TIMESTAMP NULL DEFAULT NULL,
  258.   PRIMARY KEY (`id`),
  259.   KEY `families_idempresa_foreign` (`idempresa`),
  260.   CONSTRAINT `families_idempresa_foreign` FOREIGN KEY (`idempresa`) REFERENCES `companies` (`id`)
  261. ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  262.  
  263. -- Volcando datos para la tabla lsc.families: ~2 rows (aproximadamente)
  264. DELETE FROM `families`;
  265. /*!40000 ALTER TABLE `families` DISABLE KEYS */;
  266. INSERT INTO `families` (`id`, `idempresa`, `nombre`, `descripcion`, `created_at`, `updated_at`) VALUES
  267.     (1, 1, 'Cambios de aceite', 'Servicios de Cambio de aceite', '2018-07-12 17:32:16', '2018-07-12 17:32:16'),
  268.     (2, 1, 'Lavados', 'Servicios de Lavado', '2018-07-12 17:32:16', '2018-07-12 17:32:16');
  269. /*!40000 ALTER TABLE `families` ENABLE KEYS */;
  270.  
  271. -- Volcando estructura para tabla lsc.migrations
  272. CREATE TABLE IF NOT EXISTS `migrations` (
  273.   `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  274.   `migration` VARCHAR(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  275.   `batch` INT(11) NOT NULL,
  276.   PRIMARY KEY (`id`)
  277. ) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  278.  
  279. -- Volcando datos para la tabla lsc.migrations: ~13 rows (aproximadamente)
  280. DELETE FROM `migrations`;
  281. /*!40000 ALTER TABLE `migrations` DISABLE KEYS */;
  282. INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
  283.     (1, '2014_10_11_094829_create_companies_table', 1),
  284.     (2, '2014_10_11_100322_create_users_types_table', 1),
  285.     (3, '2014_10_12_000000_create_users_table', 1),
  286.     (4, '2014_10_12_100000_create_password_resets_table', 1),
  287.     (5, '2018_03_16_094250_create_notes_table', 1),
  288.     (6, '2018_03_16_094510_create_providers_table', 1),
  289.     (7, '2018_03_16_094707_create_deposits_table', 1),
  290.     (8, '2018_03_27_181444_create_clients_table', 1),
  291.     (9, '2018_03_28_213322_create_vehicles_table', 1),
  292.     (10, '2018_04_02_000000_create_families_table', 1),
  293.     (11, '2018_04_02_135809_create_articles_table', 1),
  294.     (12, '2018_04_04_084643_create_albaranes_table', 1),
  295.     (13, '2018_04_04_084722_create_albaranes_items_table', 1);
  296. /*!40000 ALTER TABLE `migrations` ENABLE KEYS */;
  297.  
  298. -- Volcando estructura para tabla lsc.notes
  299. CREATE TABLE IF NOT EXISTS `notes` (
  300.   `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  301.   `Descripcion` VARCHAR(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  302.   `idempresa` INT(10) UNSIGNED NOT NULL,
  303.   `created_at` TIMESTAMP NULL DEFAULT NULL,
  304.   `updated_at` TIMESTAMP NULL DEFAULT NULL,
  305.   PRIMARY KEY (`id`),
  306.   KEY `notes_idempresa_foreign` (`idempresa`),
  307.   CONSTRAINT `notes_idempresa_foreign` FOREIGN KEY (`idempresa`) REFERENCES `companies` (`id`)
  308. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  309.  
  310. -- Volcando datos para la tabla lsc.notes: ~0 rows (aproximadamente)
  311. DELETE FROM `notes`;
  312. /*!40000 ALTER TABLE `notes` DISABLE KEYS */;
  313. /*!40000 ALTER TABLE `notes` ENABLE KEYS */;
  314.  
  315. -- Volcando estructura para tabla lsc.password_resets
  316. CREATE TABLE IF NOT EXISTS `password_resets` (
  317.   `email` VARCHAR(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  318.   `token` VARCHAR(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  319.   `created_at` TIMESTAMP NULL DEFAULT NULL,
  320.   KEY `password_resets_email_index` (`email`)
  321. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  322.  
  323. -- Volcando datos para la tabla lsc.password_resets: ~0 rows (aproximadamente)
  324. DELETE FROM `password_resets`;
  325. /*!40000 ALTER TABLE `password_resets` DISABLE KEYS */;
  326. /*!40000 ALTER TABLE `password_resets` ENABLE KEYS */;
  327.  
  328. -- Volcando estructura para tabla lsc.providers
  329. CREATE TABLE IF NOT EXISTS `providers` (
  330.   `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  331.   `idempresa` INT(10) UNSIGNED NOT NULL,
  332.   `created_at` TIMESTAMP NULL DEFAULT NULL,
  333.   `updated_at` TIMESTAMP NULL DEFAULT NULL,
  334.   PRIMARY KEY (`id`),
  335.   KEY `providers_idempresa_foreign` (`idempresa`),
  336.   CONSTRAINT `providers_idempresa_foreign` FOREIGN KEY (`idempresa`) REFERENCES `companies` (`id`)
  337. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  338.  
  339. -- Volcando datos para la tabla lsc.providers: ~0 rows (aproximadamente)
  340. DELETE FROM `providers`;
  341. /*!40000 ALTER TABLE `providers` DISABLE KEYS */;
  342. /*!40000 ALTER TABLE `providers` ENABLE KEYS */;
  343.  
  344. -- Volcando estructura para tabla lsc.users
  345. CREATE TABLE IF NOT EXISTS `users` (
  346.   `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  347.   `apodo` VARCHAR(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  348.   `nombre` VARCHAR(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  349.   `apellido` VARCHAR(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  350.   `cargo` VARCHAR(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  351.   `idempresa` INT(10) UNSIGNED NOT NULL,
  352.   `idusertype` INT(10) UNSIGNED NOT NULL,
  353.   `email` VARCHAR(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  354.   `password` VARCHAR(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  355.   `is_admin` tinyint(1) DEFAULT NULL,
  356.   `remember_token` VARCHAR(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  357.   `created_at` TIMESTAMP NULL DEFAULT NULL,
  358.   `updated_at` TIMESTAMP NULL DEFAULT NULL,
  359.   PRIMARY KEY (`id`),
  360.   UNIQUE KEY `users_email_unique` (`email`),
  361.   KEY `users_idempresa_foreign` (`idempresa`),
  362.   KEY `users_idusertype_foreign` (`idusertype`),
  363.   CONSTRAINT `users_idempresa_foreign` FOREIGN KEY (`idempresa`) REFERENCES `companies` (`id`),
  364.   CONSTRAINT `users_idusertype_foreign` FOREIGN KEY (`idusertype`) REFERENCES `users_types` (`id`)
  365. ) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  366.  
  367. -- Volcando datos para la tabla lsc.users: ~49 rows (aproximadamente)
  368. DELETE FROM `users`;
  369. /*!40000 ALTER TABLE `users` DISABLE KEYS */;
  370. INSERT INTO `users` (`id`, `apodo`, `nombre`, `apellido`, `cargo`, `idempresa`, `idusertype`, `email`, `password`, `is_admin`, `remember_token`, `created_at`, `updated_at`) VALUES
  371.     (1, 'Sr.', 'Jose', 'Arrieta', 'Jefe de Sistemas', 1, 4, 'ophendesigner@gmail.com', '$2y$10$EmtI.G9S5Oo2QA1M4hQVdeRXdp55z57HC9BSlXiMONET2svxK1w7S', 1, NULL, '2018-07-12 17:32:11', '2018-07-12 17:32:11'),
  372.     (2, 'Sr.', 'Karley Zieme', 'Kamille Christiansen DDS', NULL, 2, 1, 'nitzsche.adriana@example.com', '$2y$10$TKh8H1.PfQx37YgCzwiKb.KjNyWgaHb9cbcoQgdIVFlYg7B77UdFm', NULL, 't77vC8e1EP', '2018-07-12 17:32:11', '2018-07-12 17:32:11'),
  373.     (3, 'Sr.', 'Eugenia Mohr', 'Frederick Emmerich V', NULL, 2, 1, 'sschimmel@example.com', '$2y$10$TKh8H1.PfQx37YgCzwiKb.KjNyWgaHb9cbcoQgdIVFlYg7B77UdFm', NULL, 'vw6QYPOwGU', '2018-07-12 17:32:11', '2018-07-12 17:32:11'),
  374.     (4, 'Sr.', 'Antonio Mills', 'Chadd Boyle', NULL, 2, 1, 'kwilliamson@example.com', '$2y$10$TKh8H1.PfQx37YgCzwiKb.KjNyWgaHb9cbcoQgdIVFlYg7B77UdFm', NULL, '8mtvDkKlBH', '2018-07-12 17:32:12', '2018-07-12 17:32:12'),
  375.     (5, 'Sr.', 'Dion Willms MD', 'Vicenta Reichel', NULL, 2, 1, 'torn@example.org', '$2y$10$TKh8H1.PfQx37YgCzwiKb.KjNyWgaHb9cbcoQgdIVFlYg7B77UdFm', NULL, 'KsHQbq7mxL', '2018-07-12 17:32:12', '2018-07-12 17:32:12'),
  376.     (6, 'Sr.', 'Timothy Gibson', 'Prof. Javon Altenwerth Jr.', NULL, 2, 1, 'duncan58@example.com', '$2y$10$TKh8H1.PfQx37YgCzwiKb.KjNyWgaHb9cbcoQgdIVFlYg7B77UdFm', NULL, 'zxxXLmMTkC', '2018-07-12 17:32:12', '2018-07-12 17:32:12'),
  377.     (7, 'Sr.', 'Enoch Corwin', 'Yoshiko Marquardt', NULL, 2, 1, 'amina.denesik@example.net', '$2y$10$TKh8H1.PfQx37YgCzwiKb.KjNyWgaHb9cbcoQgdIVFlYg7B77UdFm', NULL, 'h7ZeSXDJi6', '2018-07-12 17:32:12', '2018-07-12 17:32:12'),
  378.     (8, 'Sr.', 'Elisha McLaughlin', 'Shirley Wiza', NULL, 2, 1, 'reinger.damion@example.org', '$2y$10$TKh8H1.PfQx37YgCzwiKb.KjNyWgaHb9cbcoQgdIVFlYg7B77UdFm', NULL, 's8hmDIIgob', '2018-07-12 17:32:12', '2018-07-12 17:32:12'),
  379.     (9, 'Sr.', 'Aurelie Lesch', 'Carolanne Erdman', NULL, 2, 1, 'uhuel@example.net', '$2y$10$TKh8H1.PfQx37YgCzwiKb.KjNyWgaHb9cbcoQgdIVFlYg7B77UdFm', NULL, 'RWvjhoOoud', '2018-07-12 17:32:12', '2018-07-12 17:32:12'),
  380.     (10, 'Sr.', 'Hilma Mitchell III', 'Beaulah O\'Reilly', NULL, 2, 1, 'monty.oreilly@example.com', '$2y$10$TKh8H1.PfQx37YgCzwiKb.KjNyWgaHb9cbcoQgdIVFlYg7B77UdFm', NULL, 'rsl0iCLBL9', '2018-07-12 17:32:12', '2018-07-12 17:32:12'),
  381.     (11, 'Sr.', 'Minerva Williamson', 'Thalia Runolfsson', NULL, 2, 1, 'rocky.nicolas@example.org', '$2y$10$TKh8H1.PfQx37YgCzwiKb.KjNyWgaHb9cbcoQgdIVFlYg7B77UdFm', NULL, '7r3Y5dmHCQ', '2018-07-12 17:32:12', '2018-07-12 17:32:12'),
  382.     (12, 'Sr.', 'Kailey Zulauf', 'Hunter Champlin', NULL, 2, 1, 'ykling@example.com', '$2y$10$TKh8H1.PfQx37YgCzwiKb.KjNyWgaHb9cbcoQgdIVFlYg7B77UdFm', NULL, 'CqHYWbXYr9', '2018-07-12 17:32:12', '2018-07-12 17:32:12'),
  383.     (13, 'Sr.', 'Ryann Champlin II', 'Yasmeen Von', NULL, 2, 1, 'madelyn43@example.net', '$2y$10$TKh8H1.PfQx37YgCzwiKb.KjNyWgaHb9cbcoQgdIVFlYg7B77UdFm', NULL, 'ShHQEy5ajO', '2018-07-12 17:32:12', '2018-07-12 17:32:12'),
  384.     (14, 'Sr.', 'Dr. Tess Bednar', 'Dr. Elvera Crist III', NULL, 2, 1, 'rodriguez.bobby@example.com', '$2y$10$TKh8H1.PfQx37YgCzwiKb.KjNyWgaHb9cbcoQgdIVFlYg7B77UdFm', NULL, 'sPVmIZHfoa', '2018-07-12 17:32:12', '2018-07-12 17:32:12'),
  385.     (15, 'Sr.', 'Ernest Cummings III', 'Athena Lind', NULL, 2, 1, 'vernie30@example.net', '$2y$10$TKh8H1.PfQx37YgCzwiKb.KjNyWgaHb9cbcoQgdIVFlYg7B77UdFm', NULL, '4eXpF6KSYZ', '2018-07-12 17:32:12', '2018-07-12 17:32:12'),
  386.     (16, 'Sr.', 'Gavin Frami', 'Marianna Daugherty', NULL, 2, 1, 'oswald.morar@example.org', '$2y$10$TKh8H1.PfQx37YgCzwiKb.KjNyWgaHb9cbcoQgdIVFlYg7B77UdFm', NULL, 'odbUsugMCJ', '2018-07-12 17:32:12', '2018-07-12 17:32:12'),
  387.     (17, 'Sr.', 'Winston Romaguera', 'Vivianne Predovic', NULL, 2, 1, 'michaela.frami@example.org', '$2y$10$TKh8H1.PfQx37YgCzwiKb.KjNyWgaHb9cbcoQgdIVFlYg7B77UdFm', NULL, 'AUe7UxGgML', '2018-07-12 17:32:12', '2018-07-12 17:32:12'),
  388.     (18, 'Sr.', 'Caitlyn Krajcik', 'Tevin Goyette', NULL, 2, 1, 'jaycee.treutel@example.org', '$2y$10$TKh8H1.PfQx37YgCzwiKb.KjNyWgaHb9cbcoQgdIVFlYg7B77UdFm', NULL, 'gseQoTwuTv', '2018-07-12 17:32:12', '2018-07-12 17:32:12'),
  389.     (19, 'Sr.', 'Mr. Emmet Sawayn V', 'Sherman Wiegand I', NULL, 2, 1, 'travon07@example.net', '$2y$10$TKh8H1.PfQx37YgCzwiKb.KjNyWgaHb9cbcoQgdIVFlYg7B77UdFm', NULL, 'Yo590ifFnj', '2018-07-12 17:32:12', '2018-07-12 17:32:12'),
  390.     (20, 'Sr.', 'Kacey Rowe', 'Heloise Muller', NULL, 2, 1, 'elnora51@example.com', '$2y$10$TKh8H1.PfQx37YgCzwiKb.KjNyWgaHb9cbcoQgdIVFlYg7B77UdFm', NULL, 'EIkF4xh9jC', '2018-07-12 17:32:12', '2018-07-12 17:32:12'),
  391.     (21, 'Sr.', 'Marc Feil', 'Leonor Crist', NULL, 2, 1, 'scot.ortiz@example.net', '$2y$10$TKh8H1.PfQx37YgCzwiKb.KjNyWgaHb9cbcoQgdIVFlYg7B77UdFm', NULL, 'N6G0IZCXsO', '2018-07-12 17:32:12', '2018-07-12 17:32:12'),
  392.     (22, 'Sr.', 'Kattie Glover PhD', 'Mr. Christ Howe', NULL, 2, 1, 'lchamplin@example.org', '$2y$10$TKh8H1.PfQx37YgCzwiKb.KjNyWgaHb9cbcoQgdIVFlYg7B77UdFm', NULL, 'xYAkFr2VJ4', '2018-07-12 17:32:12', '2018-07-12 17:32:12'),
  393.     (23, 'Sr.', 'Frederik McLaughlin PhD', 'Mr. Terrance Bauch Jr.', NULL, 2, 1, 'cayla64@example.net', '$2y$10$TKh8H1.PfQx37YgCzwiKb.KjNyWgaHb9cbcoQgdIVFlYg7B77UdFm', NULL, 'S0vOrE6i0z', '2018-07-12 17:32:12', '2018-07-12 17:32:12'),
  394.     (24, 'Sr.', 'Jaylon O\'Kon', 'Madonna Kerluke MD', NULL, 2, 1, 'ukerluke@example.net', '$2y$10$TKh8H1.PfQx37YgCzwiKb.KjNyWgaHb9cbcoQgdIVFlYg7B77UdFm', NULL, 'zgpmTwcFuw', '2018-07-12 17:32:12', '2018-07-12 17:32:12'),
  395.     (25, 'Sr.', 'Dustin McKenzie', 'Prof. Fabiola Rice IV', NULL, 2, 1, 'lucius.mcglynn@example.com', '$2y$10$TKh8H1.PfQx37YgCzwiKb.KjNyWgaHb9cbcoQgdIVFlYg7B77UdFm', NULL, 'qcPOHEoZCO', '2018-07-12 17:32:12', '2018-07-12 17:32:12'),
  396.     (26, 'Sr.', 'Prof. Eryn Jacobson', 'Cristobal Cremin', NULL, 2, 1, 'hickle.guy@example.net', '$2y$10$TKh8H1.PfQx37YgCzwiKb.KjNyWgaHb9cbcoQgdIVFlYg7B77UdFm', NULL, 'Tl2SwvECjt', '2018-07-12 17:32:12', '2018-07-12 17:32:12'),
  397.     (27, 'Sr.', 'Ms. Jayne Leuschke', 'Dr. Eldora Bashirian', NULL, 2, 1, 'ellen.cruickshank@example.com', '$2y$10$TKh8H1.PfQx37YgCzwiKb.KjNyWgaHb9cbcoQgdIVFlYg7B77UdFm', NULL, '6xtRlu6oHP', '2018-07-12 17:32:12', '2018-07-12 17:32:12'),
  398.     (28, 'Sr.', 'Shaniya Lueilwitz IV', 'Magdalena Kuhic', NULL, 2, 1, 'pmitchell@example.net', '$2y$10$TKh8H1.PfQx37YgCzwiKb.KjNyWgaHb9cbcoQgdIVFlYg7B77UdFm', NULL, 'R2v1JDNdOX', '2018-07-12 17:32:12', '2018-07-12 17:32:12'),
  399.     (29, 'Sr.', 'Carmine Nader', 'Miss Bulah Wolf DDS', NULL, 2, 1, 'jerald.hodkiewicz@example.com', '$2y$10$TKh8H1.PfQx37YgCzwiKb.KjNyWgaHb9cbcoQgdIVFlYg7B77UdFm', NULL, '7HqF9MyDXY', '2018-07-12 17:32:12', '2018-07-12 17:32:12'),
  400.     (30, 'Sr.', 'Orville Harvey', 'Dimitri Mann III', NULL, 2, 1, 'qnienow@example.org', '$2y$10$TKh8H1.PfQx37YgCzwiKb.KjNyWgaHb9cbcoQgdIVFlYg7B77UdFm', NULL, '6QS4KBtEMS', '2018-07-12 17:32:12', '2018-07-12 17:32:12'),
  401.     (31, 'Sr.', 'Jean McDermott', 'Lonzo Beahan', NULL, 2, 1, 'michael.bernhard@example.net', '$2y$10$TKh8H1.PfQx37YgCzwiKb.KjNyWgaHb9cbcoQgdIVFlYg7B77UdFm', NULL, 'aft3gZNy71', '2018-07-12 17:32:12', '2018-07-12 17:32:12'),
  402.     (32, 'Sr.', 'Vesta Fahey', 'Mrs. Estelle O\'Conner DDS', NULL, 2, 1, 'alena56@example.org', '$2y$10$TKh8H1.PfQx37YgCzwiKb.KjNyWgaHb9cbcoQgdIVFlYg7B77UdFm', NULL, 'sXk8FCPklB', '2018-07-12 17:32:12', '2018-07-12 17:32:12'),
  403.     (33, 'Sr.', 'Dr. Iva Hills DDS', 'Prof. Douglas Ziemann Sr.', NULL, 2, 1, 'hilpert.albin@example.org', '$2y$10$TKh8H1.PfQx37YgCzwiKb.KjNyWgaHb9cbcoQgdIVFlYg7B77UdFm', NULL, 'suuk4r4lj9', '2018-07-12 17:32:12', '2018-07-12 17:32:12'),
  404.     (34, 'Sr.', 'Royal Mraz', 'Corbin Gutmann', NULL, 2, 1, 'malika.eichmann@example.org', '$2y$10$TKh8H1.PfQx37YgCzwiKb.KjNyWgaHb9cbcoQgdIVFlYg7B77UdFm', NULL, 'cs7m7KKC9P', '2018-07-12 17:32:12', '2018-07-12 17:32:12'),
  405.     (35, 'Sr.', 'Prof. Juwan Stark Sr.', 'Karianne Dickinson', NULL, 2, 1, 'skoss@example.com', '$2y$10$TKh8H1.PfQx37YgCzwiKb.KjNyWgaHb9cbcoQgdIVFlYg7B77UdFm', NULL, 'wm3MLat1o5', '2018-07-12 17:32:12', '2018-07-12 17:32:12'),
  406.     (36, 'Sr.', 'Miss Mariah Mueller II', 'Kay Runolfsson I', NULL, 2, 1, 'cortez37@example.net', '$2y$10$TKh8H1.PfQx37YgCzwiKb.KjNyWgaHb9cbcoQgdIVFlYg7B77UdFm', NULL, 'HULlOFG9NU', '2018-07-12 17:32:12', '2018-07-12 17:32:12'),
  407.     (37, 'Sr.', 'Dr. Kailey Heller V', 'Giovanni Harber', NULL, 2, 1, 'alison64@example.org', '$2y$10$TKh8H1.PfQx37YgCzwiKb.KjNyWgaHb9cbcoQgdIVFlYg7B77UdFm', NULL, 'tCeTDbwJJw', '2018-07-12 17:32:13', '2018-07-12 17:32:13'),
  408.     (38, 'Sr.', 'Lilyan Padberg V', 'Issac Kirlin MD', NULL, 2, 1, 'arvilla.farrell@example.org', '$2y$10$TKh8H1.PfQx37YgCzwiKb.KjNyWgaHb9cbcoQgdIVFlYg7B77UdFm', NULL, 'rkCUJghetF', '2018-07-12 17:32:13', '2018-07-12 17:32:13'),
  409.     (39, 'Sr.', 'Jacques Runolfsdottir V', 'Tiffany Gulgowski', NULL, 2, 1, 'chad.schulist@example.org', '$2y$10$TKh8H1.PfQx37YgCzwiKb.KjNyWgaHb9cbcoQgdIVFlYg7B77UdFm', NULL, 'MPD4jqDfZF', '2018-07-12 17:32:13', '2018-07-12 17:32:13'),
  410.     (40, 'Sr.', 'Mr. Pierce Hudson I', 'Lamar Olson', NULL, 2, 1, 'breana.langworth@example.org', '$2y$10$TKh8H1.PfQx37YgCzwiKb.KjNyWgaHb9cbcoQgdIVFlYg7B77UdFm', NULL, 'nCb6QUuaim', '2018-07-12 17:32:13', '2018-07-12 17:32:13'),
  411.     (41, 'Sr.', 'Stanford DuBuque', 'Miss Cara Olson', NULL, 2, 1, 'eerdman@example.net', '$2y$10$TKh8H1.PfQx37YgCzwiKb.KjNyWgaHb9cbcoQgdIVFlYg7B77UdFm', NULL, 'WLylyZop0T', '2018-07-12 17:32:13', '2018-07-12 17:32:13'),
  412.     (42, 'Sr.', 'Dr. Giovanna Kuhlman II', 'Mr. Eriberto Volkman PhD', NULL, 2, 1, 'pkuphal@example.net', '$2y$10$TKh8H1.PfQx37YgCzwiKb.KjNyWgaHb9cbcoQgdIVFlYg7B77UdFm', NULL, 'cKkd37qbyH', '2018-07-12 17:32:13', '2018-07-12 17:32:13'),
  413.     (43, 'Sr.', 'Andy Romaguera DVM', 'Prof. Tomas Hoppe', NULL, 2, 1, 'era23@example.net', '$2y$10$TKh8H1.PfQx37YgCzwiKb.KjNyWgaHb9cbcoQgdIVFlYg7B77UdFm', NULL, 'G5oSmLTBq2', '2018-07-12 17:32:13', '2018-07-12 17:32:13'),
  414.     (44, 'Sr.', 'Ms. Keely Bartell V', 'Cora Adams III', NULL, 2, 1, 'mmarks@example.org', '$2y$10$TKh8H1.PfQx37YgCzwiKb.KjNyWgaHb9cbcoQgdIVFlYg7B77UdFm', NULL, 'Lbj27K2aZF', '2018-07-12 17:32:13', '2018-07-12 17:32:13'),
  415.     (45, 'Sr.', 'Polly Mitchell', 'Dr. Jaime Lakin', NULL, 2, 1, 'jaycee07@example.org', '$2y$10$TKh8H1.PfQx37YgCzwiKb.KjNyWgaHb9cbcoQgdIVFlYg7B77UdFm', NULL, 'npGLLm1O1T', '2018-07-12 17:32:13', '2018-07-12 17:32:13'),
  416.     (46, 'Sr.', 'Keely Paucek', 'Salma O\'Hara', NULL, 2, 1, 'kdietrich@example.com', '$2y$10$TKh8H1.PfQx37YgCzwiKb.KjNyWgaHb9cbcoQgdIVFlYg7B77UdFm', NULL, 'dc8IzQehMZ', '2018-07-12 17:32:13', '2018-07-12 17:32:13'),
  417.     (47, 'Sr.', 'Prof. Andy Friesen', 'Alayna Adams', NULL, 2, 1, 'cullen38@example.net', '$2y$10$TKh8H1.PfQx37YgCzwiKb.KjNyWgaHb9cbcoQgdIVFlYg7B77UdFm', NULL, 'wtNVcjrCjY', '2018-07-12 17:32:13', '2018-07-12 17:32:13'),
  418.     (48, 'Sr.', 'Ludwig Schneider', 'Giovanna Schiller', NULL, 2, 1, 'lewis.toy@example.com', '$2y$10$TKh8H1.PfQx37YgCzwiKb.KjNyWgaHb9cbcoQgdIVFlYg7B77UdFm', NULL, 'Sd8NjMvOPO', '2018-07-12 17:32:13', '2018-07-12 17:32:13'),
  419.     (49, 'Sr.', 'Dereck Pouros V', 'Rosalee Schoen', NULL, 2, 1, 'xleffler@example.org', '$2y$10$TKh8H1.PfQx37YgCzwiKb.KjNyWgaHb9cbcoQgdIVFlYg7B77UdFm', NULL, '1vu1234de7', '2018-07-12 17:32:13', '2018-07-12 17:32:13');
  420. /*!40000 ALTER TABLE `users` ENABLE KEYS */;
  421.  
  422. -- Volcando estructura para tabla lsc.users_types
  423. CREATE TABLE IF NOT EXISTS `users_types` (
  424.   `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  425.   `tipo` VARCHAR(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  426.   `created_at` TIMESTAMP NULL DEFAULT NULL,
  427.   `updated_at` TIMESTAMP NULL DEFAULT NULL,
  428.   PRIMARY KEY (`id`),
  429.   UNIQUE KEY `users_types_tipo_unique` (`tipo`)
  430. ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  431.  
  432. -- Volcando datos para la tabla lsc.users_types: ~4 rows (aproximadamente)
  433. DELETE FROM `users_types`;
  434. /*!40000 ALTER TABLE `users_types` DISABLE KEYS */;
  435. INSERT INTO `users_types` (`id`, `tipo`, `created_at`, `updated_at`) VALUES
  436.     (1, 'Demo', '2018-07-12 17:32:10', '2018-07-12 17:32:10'),
  437.     (2, 'Normal', '2018-07-12 17:32:10', '2018-07-12 17:32:10'),
  438.     (3, 'Admin', '2018-07-12 17:32:11', '2018-07-12 17:32:11'),
  439.     (4, 'SuperAdmin', '2018-07-12 17:32:11', '2018-07-12 17:32:11');
  440. /*!40000 ALTER TABLE `users_types` ENABLE KEYS */;
  441.  
  442. -- Volcando estructura para tabla lsc.vehicles
  443. CREATE TABLE IF NOT EXISTS `vehicles` (
  444.   `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  445.   `matricula` VARCHAR(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  446.   `idcliente` INT(10) UNSIGNED NOT NULL,
  447.   `tipo_vehiculo` VARCHAR(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  448.   `marca` VARCHAR(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  449.   `modelo` VARCHAR(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  450.   `tapon` tinyint(1) DEFAULT NULL,
  451.   `tapon_text` VARCHAR(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  452.   `color` VARCHAR(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  453.   `tipo_combustible` VARCHAR(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  454.   `modelo_motor` VARCHAR(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  455.   `aceite_motor` VARCHAR(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  456.   `filtro_aire` VARCHAR(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  457.   `filtro_aceite` VARCHAR(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  458.   `filtro_cabina` VARCHAR(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  459.   `filtro_combustible` VARCHAR(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  460.   `filtro_combustible2` VARCHAR(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  461.   `filtro_combustible3` VARCHAR(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  462.   `archivoimagen` VARCHAR(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  463.   `observaciones` text COLLATE utf8mb4_unicode_ci,
  464.   `created_at` TIMESTAMP NULL DEFAULT NULL,
  465.   `updated_at` TIMESTAMP NULL DEFAULT NULL,
  466.   PRIMARY KEY (`id`),
  467.   UNIQUE KEY `vehicles_matricula_unique` (`matricula`),
  468.   KEY `vehicles_idcliente_foreign` (`idcliente`),
  469.   CONSTRAINT `vehicles_idcliente_foreign` FOREIGN KEY (`idcliente`) REFERENCES `clients` (`id`)
  470. ) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  471.  
  472. -- Volcando datos para la tabla lsc.vehicles: ~48 rows (aproximadamente)
  473. DELETE FROM `vehicles`;
  474. /*!40000 ALTER TABLE `vehicles` DISABLE KEYS */;
  475. INSERT INTO `vehicles` (`id`, `matricula`, `idcliente`, `tipo_vehiculo`, `marca`, `modelo`, `tapon`, `tapon_text`, `color`, `tipo_combustible`, `modelo_motor`, `aceite_motor`, `filtro_aire`, `filtro_aceite`, `filtro_cabina`, `filtro_combustible`, `filtro_combustible2`, `filtro_combustible3`, `archivoimagen`, `observaciones`, `created_at`, `updated_at`) VALUES
  476.     (1, 'Hello 331', 1, 'Eleonore Raynor', 'Daren', 'Rowan', NULL, NULL, NULL, 'Marlen Reichert', '1.6', 'Total 20w50', 'C 26036', 'W 920/48', 'Scarlett Ryan', 'Fausto VonRueden', 'Jennings Lueilwitz', 'Dallin Waelchi', NULL, NULL, '2018-07-12 17:32:15', '2018-07-12 17:32:15'),
  477.     (2, 'Hello 570', 3, 'Meaghan Borer', 'Trenton', 'Jon', NULL, NULL, NULL, 'John Eichmann', '1.6', 'Total 20w50', 'C 26036', 'W 920/48', 'Veda Casper', 'Jamar Franecki', 'Ken Toy', 'Okey Goyette', NULL, NULL, '2018-07-12 17:32:15', '2018-07-12 17:32:15'),
  478.     (3, 'Hello 395', 1, 'Gwendolyn Hegmann', 'Chester', 'Deion', NULL, NULL, NULL, 'Roma Dibbert', '1.6', 'Total 20w50', 'C 26036', 'W 920/48', 'Dr. Audreanne Hudson Sr.', 'Prof. Carissa Trantow', 'Lorna Cartwright', 'Laurel Schneider', NULL, NULL, '2018-07-12 17:32:15', '2018-07-12 17:32:15'),
  479.     (4, 'Hello 856', 1, 'Kellie Walker', 'Roscoe', 'Mark', NULL, NULL, NULL, 'Dr. Demarcus Bartoletti II', '1.6', 'Total 20w50', 'C 26036', 'W 920/48', 'Linnea White DDS', 'Trystan Harber', 'Ms. Rebeka Nienow Sr.', 'Gaylord Treutel V', NULL, NULL, '2018-07-12 17:32:15', '2018-07-12 17:32:15'),
  480.     (5, 'Hello 111', 1, 'Sedrick Roob', 'Orion', 'Alejandrin', NULL, NULL, NULL, 'Julius Bogan', '1.6', 'Total 20w50', 'C 26036', 'W 920/48', 'Rasheed O\'Hara', 'Ken West', 'Chester Rath', 'Alejandra Rowe', NULL, NULL, '2018-07-12 17:32:15', '2018-07-12 17:32:15'),
  481.     (6, 'Hello 612', 1, 'Alex Doyle', 'Linwood', 'Laron', NULL, NULL, NULL, 'Sterling Anderson', '1.6', 'Total 20w50', 'C 26036', 'W 920/48', 'Newell Hodkiewicz', 'Makenna Ondricka', 'Mckenzie Lemke', 'Fanny Balistreri MD', NULL, NULL, '2018-07-12 17:32:15', '2018-07-12 17:32:15'),
  482.     (7, 'Hello 631', 1, 'Skylar Kirlin', 'Jaren', 'Humberto', NULL, NULL, NULL, 'Neil Larkin III', '1.6', 'Total 20w50', 'C 26036', 'W 920/48', 'Susan Schowalter', 'Mr. Everardo O\'Keefe', 'Hortense Quigley', 'Sienna Stark', NULL, NULL, '2018-07-12 17:32:15', '2018-07-12 17:32:15'),
  483.     (8, 'Hello 914', 1, 'Ludwig McClure', 'Domingo', 'Tad', NULL, NULL, NULL, 'Michelle Howell', '1.6', 'Total 20w50', 'C 26036', 'W 920/48', 'Marcia Kling', 'Keely Hessel', 'Mrs. Linnie Kirlin', 'Mr. Virgil Terry', NULL, NULL, '2018-07-12 17:32:15', '2018-07-12 17:32:15'),
  484.     (9, 'Hello 498', 1, 'Ms. Gregoria Bradtke', 'Bryon', 'Kody', NULL, NULL, NULL, 'Mrs. Carmen Bednar Jr.', '1.6', 'Total 20w50', 'C 26036', 'W 920/48', 'Jude Lockman Jr.', 'Ms. Rosalyn Mertz MD', 'Olen Hahn', 'Toney Connelly', NULL, NULL, '2018-07-12 17:32:15', '2018-07-12 17:32:15'),
  485.     (10, 'Hello 844', 1, 'Augustine Oberbrunner', 'Demarco', 'Brennon', NULL, NULL, NULL, 'Savion Fadel', '1.6', 'Total 20w50', 'C 26036', 'W 920/48', 'Prof. Doris Paucek MD', 'Margret Doyle IV', 'Jovani Thompson', 'Remington Torphy', NULL, NULL, '2018-07-12 17:32:15', '2018-07-12 17:32:15'),
  486.     (11, 'Hello 821', 1, 'Jaida Witting', 'Chad', 'Conor', NULL, NULL, NULL, 'Floyd Ziemann IV', '1.6', 'Total 20w50', 'C 26036', 'W 920/48', 'Mr. Colby Tremblay', 'Kallie Beatty', 'Precious Tremblay', 'Waylon Sanford Jr.', NULL, NULL, '2018-07-12 17:32:15', '2018-07-12 17:32:15'),
  487.     (12, 'Hello 610', 1, 'Duane Kshlerin', 'Otho', 'Devin', NULL, NULL, NULL, 'Vivien Yost', '1.6', 'Total 20w50', 'C 26036', 'W 920/48', 'Leda Wiegand Sr.', 'Monty Schmidt', 'Dr. Freddie Kuhic', 'Coby Collier', NULL, NULL, '2018-07-12 17:32:15', '2018-07-12 17:32:15'),
  488.     (13, 'Hello 715', 1, 'Estelle Dibbert', 'Eduardo', 'Rick', NULL, NULL, NULL, 'Ofelia Prohaska', '1.6', 'Total 20w50', 'C 26036', 'W 920/48', 'Prof. Orland Erdman', 'Dr. Al Quigley PhD', 'Dr. Mustafa Bergstrom Jr.', 'Daniela Lindgren', NULL, NULL, '2018-07-12 17:32:15', '2018-07-12 17:32:15'),
  489.     (14, 'Hello 876', 1, 'August Krajcik', 'Burley', 'Johnny', NULL, NULL, NULL, 'Domenica Cronin', '1.6', 'Total 20w50', 'C 26036', 'W 920/48', 'Jeanne Pollich', 'Aurelia Kuvalis', 'Osborne Predovic', 'Blanca Schmeler', NULL, NULL, '2018-07-12 17:32:15', '2018-07-12 17:32:15'),
  490.     (15, 'Hello 845', 1, 'Dr. Ahmad Eichmann DVM', 'Christop', 'Joaquin', NULL, NULL, NULL, 'Dayne Ratke', '1.6', 'Total 20w50', 'C 26036', 'W 920/48', 'Mr. Raven Conroy Jr.', 'Dr. Will Macejkovic DDS', 'Laurine Bergstrom', 'Dr. Ted Ryan', NULL, NULL, '2018-07-12 17:32:15', '2018-07-12 17:32:15'),
  491.     (16, 'Hello 439', 1, 'Laurel DuBuque', 'Johnpaul', 'Cordelia', NULL, NULL, NULL, 'Phoebe Kessler', '1.6', 'Total 20w50', 'C 26036', 'W 920/48', 'Jennings Smith', 'Prof. Bonita Kilback MD', 'Dr. Joesph Grady', 'Abelardo Auer', NULL, NULL, '2018-07-12 17:32:15', '2018-07-12 17:32:15'),
  492.     (17, 'Hello 992', 1, 'Britney Sawayn', 'Adolphus', 'Mose', NULL, NULL, NULL, 'Miss Aaliyah Nienow MD', '1.6', 'Total 20w50', 'C 26036', 'W 920/48', 'Mr. Keeley Johns', 'Nick Homenick', 'Hilda Pollich', 'Mrs. Aryanna Fahey Sr.', NULL, NULL, '2018-07-12 17:32:15', '2018-07-12 17:32:15'),
  493.     (18, 'Hello 816', 1, 'Bart Monahan', 'Llewellyn', 'Dee', NULL, NULL, NULL, 'Ottis Jakubowski', '1.6', 'Total 20w50', 'C 26036', 'W 920/48', 'Maudie Rosenbaum', 'Monserrate Ziemann', 'Martina Doyle', 'Lorenza Murray IV', NULL, NULL, '2018-07-12 17:32:15', '2018-07-12 17:32:15'),
  494.     (19, 'Hello 560', 1, 'Norris Labadie', 'Domenic', 'Rylan', NULL, NULL, NULL, 'Sammy Ankunding', '1.6', 'Total 20w50', 'C 26036', 'W 920/48', 'Mr. Jason Cronin', 'Prof. Ignacio Casper', 'Alexandro Johns II', 'Bernadette Schowalter', NULL, NULL, '2018-07-12 17:32:16', '2018-07-12 17:32:16'),
  495.     (20, 'Hello 303', 1, 'Dr. Tressie Mante III', 'Rogelio', 'Herman', NULL, NULL, NULL, 'Jimmy Crist', '1.6', 'Total 20w50', 'C 26036', 'W 920/48', 'Prof. Tracey Schaefer', 'Glenna Thiel', 'Miracle Erdman', 'Daren Friesen', NULL, NULL, '2018-07-12 17:32:16', '2018-07-12 17:32:16'),
  496.     (21, 'Hello 769', 1, 'Uriah Ruecker', 'Cleo', 'Kendrick', NULL, NULL, NULL, 'Dr. Kim Cremin', '1.6', 'Total 20w50', 'C 26036', 'W 920/48', 'Orrin Goldner', 'Brody Waelchi', 'Graciela Dibbert II', 'Nicholas Bergstrom', NULL, NULL, '2018-07-12 17:32:16', '2018-07-12 17:32:16'),
  497.     (22, 'Hello 088', 1, 'Monica Price', 'Matt', 'Toby', NULL, NULL, NULL, 'Holden O\'Kon', '1.6', 'Total 20w50', 'C 26036', 'W 920/48', 'Maryjane Jacobson', 'Grant Mitchell', 'Maxine Leffler', 'Minerva Trantow', NULL, NULL, '2018-07-12 17:32:16', '2018-07-12 17:32:16'),
  498.     (23, 'Hello 658', 1, 'Prof. Oral Wyman', 'Nestor', 'Ahmed', NULL, NULL, NULL, 'Noe Nicolas', '1.6', 'Total 20w50', 'C 26036', 'W 920/48', 'Dr. Vaughn Padberg Sr.', 'Dr. Skyla Lockman', 'Emely Schmeler', 'Adam Ebert', NULL, NULL, '2018-07-12 17:32:16', '2018-07-12 17:32:16'),
  499.     (24, 'Hello 246', 1, 'Norval Leannon III', 'Dallin', 'Garnett', NULL, NULL, NULL, 'Mrs. Aisha Kuphal V', '1.6', 'Total 20w50', 'C 26036', 'W 920/48', 'Alden Jakubowski PhD', 'Marcella Kozey I', 'Dr. Murray Beier', 'Miss Jacky Schiller', NULL, NULL, '2018-07-12 17:32:16', '2018-07-12 17:32:16'),
  500.     (25, 'Hello 693', 1, 'Bertram Jerde', 'Chesley', 'Gregorio', NULL, NULL, NULL, 'Marcelino Erdman IV', '1.6', 'Total 20w50', 'C 26036', 'W 920/48', 'Corbin Littel', 'Veronica McLaughlin', 'Torey Morissette', 'Aditya Kling', NULL, NULL, '2018-07-12 17:32:16', '2018-07-12 17:32:16'),
  501.     (26, 'Hello 797', 1, 'Georgianna Metz', 'Dominic', 'Buster', NULL, NULL, NULL, 'Ms. Valentina Satterfield', '1.6', 'Total 20w50', 'C 26036', 'W 920/48', 'Prof. Jaylin Dooley', 'Dr. Monte Hammes PhD', 'Cathryn Bergstrom', 'Prof. Angus Baumbach', NULL, NULL, '2018-07-12 17:32:16', '2018-07-12 17:32:16'),
  502.     (27, 'Hello 079', 1, 'Ms. Duane Gleason MD', 'Ari', 'Zackery', NULL, NULL, NULL, 'June Runolfsdottir', '1.6', 'Total 20w50', 'C 26036', 'W 920/48', 'Hazle Kozey', 'Nathanael Casper', 'Vivianne McLaughlin', 'Mekhi Swaniawski', NULL, NULL, '2018-07-12 17:32:16', '2018-07-12 17:32:16'),
  503.     (28, 'Hello 908', 1, 'John Kassulke DVM', 'Raymundo', 'Joshuah', NULL, NULL, NULL, 'Miss Bernice Denesik', '1.6', 'Total 20w50', 'C 26036', 'W 920/48', 'Jean Windler', 'Alexandrine Turcotte', 'Pearl Beahan', 'Prof. Isabella Grimes', NULL, NULL, '2018-07-12 17:32:16', '2018-07-12 17:32:16'),
  504.     (29, 'Hello 065', 1, 'Liam Stanton', 'London', 'Walton', NULL, NULL, NULL, 'Merl Boyle', '1.6', 'Total 20w50', 'C 26036', 'W 920/48', 'Carey Gerhold', 'Vallie Luettgen', 'Marjolaine Abernathy', 'Jocelyn Daniel', NULL, NULL, '2018-07-12 17:32:16', '2018-07-12 17:32:16'),
  505.     (30, 'Hello 267', 1, 'Prof. Domenic Rohan V', 'Adam', 'Estevan', NULL, NULL, NULL, 'Ms. Andreane Heaney', '1.6', 'Total 20w50', 'C 26036', 'W 920/48', 'Weston Lakin', 'Harmony Abernathy', 'Miss Lottie Schuppe', 'Christop Cremin', NULL, NULL, '2018-07-12 17:32:16', '2018-07-12 17:32:16'),
  506.     (31, 'Hello 733', 1, 'Katelin Smith', 'Reynold', 'Branson', NULL, NULL, NULL, 'Edwina Tillman', '1.6', 'Total 20w50', 'C 26036', 'W 920/48', 'Dr. Mallie Quigley', 'Emanuel Hoppe', 'Shanon Watsica', 'Mr. Alexys Murphy', NULL, NULL, '2018-07-12 17:32:16', '2018-07-12 17:32:16'),
  507.     (32, 'Hello 803', 1, 'Dr. Kendall Gusikowski II', 'Demario', 'Michel', NULL, NULL, NULL, 'Mrs. Melyna Carroll', '1.6', 'Total 20w50', 'C 26036', 'W 920/48', 'Dr. Guillermo Wolf', 'Alanis Schinner', 'Corene Crist III', 'Bernadette Zemlak', NULL, NULL, '2018-07-12 17:32:16', '2018-07-12 17:32:16'),
  508.     (33, 'Hello 837', 1, 'Miss Bettie Hammes', 'Jaeden', 'Dennis', NULL, NULL, NULL, 'Estefania Schaden', '1.6', 'Total 20w50', 'C 26036', 'W 920/48', 'Luz Jenkins', 'Floyd Von', 'Aleen Batz', 'Prof. Genevieve Collier', NULL, NULL, '2018-07-12 17:32:16', '2018-07-12 17:32:16'),
  509.     (34, 'Hello 359', 1, 'Prof. Ed Becker PhD', 'Roel', 'Dayton', NULL, NULL, NULL, 'Isaiah Parisian', '1.6', 'Total 20w50', 'C 26036', 'W 920/48', 'Mr. Reilly Jacobi', 'Mikayla Lebsack', 'Jevon Hirthe', 'Talon Schumm DVM', NULL, NULL, '2018-07-12 17:32:16', '2018-07-12 17:32:16'),
  510.     (35, 'Hello 135', 1, 'Weston Borer', 'Deonte', 'Bell', NULL, NULL, NULL, 'Kali Heidenreich', '1.6', 'Total 20w50', 'C 26036', 'W 920/48', 'Noelia Armstrong', 'Raul Rath', 'Emely Hilll', 'Antonina Schuppe', NULL, NULL, '2018-07-12 17:32:16', '2018-07-12 17:32:16'),
  511.     (36, 'Hello 100', 1, 'Dr. Angie Carter II', 'Don', 'Garland', NULL, NULL, NULL, 'Hiram Nicolas', '1.6', 'Total 20w50', 'C 26036', 'W 920/48', 'Courtney Prosacco', 'Yasmine Lemke', 'Catherine Bartell V', 'Fredy Kuphal', NULL, NULL, '2018-07-12 17:32:16', '2018-07-12 17:32:16'),
  512.     (37, 'Hello 962', 1, 'Adonis Abbott', 'Giovanny', 'Lucious', NULL, NULL, NULL, 'Blake Bogan', '1.6', 'Total 20w50', 'C 26036', 'W 920/48', 'Josie Jaskolski DVM', 'Norberto Mertz MD', 'Mrs. Rahsaan Johnson', 'Noe Fay', NULL, NULL, '2018-07-12 17:32:16', '2018-07-12 17:32:16'),
  513.     (38, 'Hello 681', 1, 'Jaylin Rosenbaum', 'Lowell', 'Emiliano', NULL, NULL, NULL, 'Brielle Hirthe', '1.6', 'Total 20w50', 'C 26036', 'W 920/48', 'Jacky Kemmer', 'Kellie Greenholt Jr.', 'Emanuel Hoppe', 'Colleen Carroll', NULL, NULL, '2018-07-12 17:32:16', '2018-07-12 17:32:16'),
  514.     (39, 'Hello 882', 1, 'Gideon Bins Jr.', 'Bartholome', 'Carroll', NULL, NULL, NULL, 'Bradford Champlin', '1.6', 'Total 20w50', 'C 26036', 'W 920/48', 'Tate Abbott', 'Felicia Beier', 'Stevie Prosacco DDS', 'Bailey Morissette', NULL, NULL, '2018-07-12 17:32:16', '2018-07-12 17:32:16'),
  515.     (40, 'Hello 671', 1, 'Mckenzie Mohr', 'Valentin', 'Tristian', NULL, NULL, NULL, 'Jensen Macejkovic', '1.6', 'Total 20w50', 'C 26036', 'W 920/48', 'Rasheed Goldner DDS', 'Christop Hegmann', 'Jefferey Watsica', 'Hulda Goyette', NULL, NULL, '2018-07-12 17:32:16', '2018-07-12 17:32:16'),
  516.     (41, 'Hello 493', 1, 'William Shanahan MD', 'Domenico', 'Roosevelt', NULL, NULL, NULL, 'Bella Streich', '1.6', 'Total 20w50', 'C 26036', 'W 920/48', 'Emanuel Heathcote', 'Addie Funk', 'Mr. Hoyt Hagenes', 'Dr. Dorothea Cremin PhD', NULL, NULL, '2018-07-12 17:32:16', '2018-07-12 17:32:16'),
  517.     (42, 'Hello 286', 1, 'Dr. Emmalee Bogisich Jr.', 'Coy', 'Izaiah', NULL, NULL, NULL, 'Chris Douglas DDS', '1.6', 'Total 20w50', 'C 26036', 'W 920/48', 'Caleigh Thompson', 'Myra Fisher', 'Dudley Veum', 'Kaitlin Feil', NULL, NULL, '2018-07-12 17:32:16', '2018-07-12 17:32:16'),
  518.     (43, 'Hello 760', 1, 'Mr. Orval Runolfsdottir', 'Isaiah', 'Arnulfo', NULL, NULL, NULL, 'Joana Bruen', '1.6', 'Total 20w50', 'C 26036', 'W 920/48', 'Sterling D\'Amore', 'Charity Mraz', 'Marcia Walsh Sr.', 'Mayra Gulgowski', NULL, NULL, '2018-07-12 17:32:16', '2018-07-12 17:32:16'),
  519.     (44, 'Hello 482', 1, 'Lula Franecki', 'Chadrick', 'Ashton', NULL, NULL, NULL, 'Miss Courtney Padberg', '1.6', 'Total 20w50', 'C 26036', 'W 920/48', 'Ms. Shirley Franecki', 'Dusty Glover', 'Prof. Odell Huels PhD', 'Mrs. Haylie Jacobs V', NULL, NULL, '2018-07-12 17:32:16', '2018-07-12 17:32:16'),
  520.     (45, 'Hello 168', 1, 'Susanna Lehner', 'Trevion', 'Christophe', NULL, NULL, NULL, 'Raven Kshlerin PhD', '1.6', 'Total 20w50', 'C 26036', 'W 920/48', 'Lina Bartoletti', 'Eliza Funk', 'Garth Lemke', 'Robert Harber', NULL, NULL, '2018-07-12 17:32:16', '2018-07-12 17:32:16'),
  521.     (46, 'Hello 993', 1, 'Prof. Oral Cremin II', 'Spencer', 'Bernie', NULL, NULL, NULL, 'Mrs. Karli Daugherty III', '1.6', 'Total 20w50', 'C 26036', 'W 920/48', 'Amy Keeling', 'Dr. Aracely Hickle', 'Joanny Schroeder', 'Linnea Dietrich', NULL, NULL, '2018-07-12 17:32:16', '2018-07-12 17:32:16'),
  522.     (47, 'Hello 836', 1, 'Miss Dovie Howell PhD', 'Emmet', 'Cortez', NULL, NULL, NULL, 'Lenna Macejkovic', '1.6', 'Total 20w50', 'C 26036', 'W 920/48', 'Prof. Haven Miller Sr.', 'Vilma Roberts', 'Janick Ledner', 'Dominique Schoen', NULL, NULL, '2018-07-12 17:32:16', '2018-07-12 17:32:16'),
  523.     (48, 'Hello 705', 1, 'Kari Corkery', 'Destin', 'Stefan', NULL, NULL, NULL, 'Stephanie Hansen', '1.6', 'Total 20w50', 'C 26036', 'W 920/48', 'Dr. Brenna Cartwright IV', 'Sage Witting DDS', 'Muriel Conn', 'Dr. Allan Lemke', NULL, NULL, '2018-07-12 17:32:16', '2018-07-12 17:32:16');
  524. /*!40000 ALTER TABLE `vehicles` ENABLE KEYS */;
  525.  
  526. /*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
  527. /*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
  528. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!