· 8 years ago · Jul 31, 2018, 12:16 AM
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
16CREATE DATABASE IF NOT EXISTS `lsc` /*!40100 DEFAULT CHARACTER SET latin1 */;
17USE `lsc`;
18
19-- Volcando estructura para tabla lsc.albaranes
20CREATE 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)
56DELETE 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
61CREATE 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)
81DELETE 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
86CREATE 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)
127DELETE FROM `articles`;
128/*!40000 ALTER TABLE `articles` DISABLE KEYS */;
129INSERT 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
135CREATE 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)
156DELETE FROM `clients`;
157/*!40000 ALTER TABLE `clients` DISABLE KEYS */;
158INSERT 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
210CREATE 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)
227DELETE FROM `companies`;
228/*!40000 ALTER TABLE `companies` DISABLE KEYS */;
229INSERT 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
235CREATE 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)
246DELETE FROM `deposits`;
247/*!40000 ALTER TABLE `deposits` DISABLE KEYS */;
248/*!40000 ALTER TABLE `deposits` ENABLE KEYS */;
249
250-- Volcando estructura para tabla lsc.families
251CREATE 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)
264DELETE FROM `families`;
265/*!40000 ALTER TABLE `families` DISABLE KEYS */;
266INSERT 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
272CREATE 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)
280DELETE FROM `migrations`;
281/*!40000 ALTER TABLE `migrations` DISABLE KEYS */;
282INSERT 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
299CREATE 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)
311DELETE 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
316CREATE 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)
324DELETE 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
329CREATE 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)
340DELETE FROM `providers`;
341/*!40000 ALTER TABLE `providers` DISABLE KEYS */;
342/*!40000 ALTER TABLE `providers` ENABLE KEYS */;
343
344-- Volcando estructura para tabla lsc.users
345CREATE 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)
368DELETE FROM `users`;
369/*!40000 ALTER TABLE `users` DISABLE KEYS */;
370INSERT 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
423CREATE 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)
433DELETE FROM `users_types`;
434/*!40000 ALTER TABLE `users_types` DISABLE KEYS */;
435INSERT 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
443CREATE 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)
473DELETE FROM `vehicles`;
474/*!40000 ALTER TABLE `vehicles` DISABLE KEYS */;
475INSERT 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 */;