-- MySQL dump 10.13  Distrib 5.6.24, for Win64 (x86_64)
--
-- Host: localhost    Database: circle_k
-- ------------------------------------------------------
-- Server version	5.7.10-log

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `conductores`
--

DROP TABLE IF EXISTS `conductores`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `conductores` (
  `ConductoresID` varchar(50) NOT NULL,
  `ClientesID` varchar(50) DEFAULT NULL,
  `Nombres` varchar(50) DEFAULT NULL,
  `ApellidoPaterno` varchar(50) DEFAULT NULL,
  `ApellidoMaterno` varchar(50) DEFAULT NULL,
  `NombreCompleto` varchar(200) DEFAULT NULL,
  `NoLicencia` varchar(50) DEFAULT '0',
  `InternalVersion` int(11) DEFAULT '0',
  `Activo` tinyint(4) DEFAULT '0',
  PRIMARY KEY (`ConductoresID`),
  KEY `WDIDX_Conductores_ClientesID` (`ClientesID`),
  KEY `WDIDX_Conductores_NombreCompleto` (`NombreCompleto`),
  KEY `WDIDX_Conductores_Activo` (`Activo`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `conductores`
--

LOCK TABLES `conductores` WRITE;
/*!40000 ALTER TABLE `conductores` DISABLE KEYS */;
INSERT INTO `conductores` VALUES ('0-1','0-50253','NAHUM FERNANDO','BANDERAS','LOERA','NAHUM FERNANDO BANDERAS BANDERAS','0',0,1),('0-10','0-50723','CELINA ARACELI','RODRIGUEZ','GUZMAN','CELINA ARACELI RODRIGUEZ RODRIGUEZ','410044584',2,0),('0-11','0-50723','JUAN','HERNANDEZ','MORA','JUAN HERNANDEZ HERNANDEZ','410016393',1,1),('0-12','0-50723','FRANCISCO JAVIER','HERNANDEZ','GONZALEZ','FRANCISCO JAVIER HERNANDEZ HERNANDEZ','410049568',1,1),('0-13','0-50723','ROSENDO','CUEVAS','SILVA','ROSENDO CUEVAS CUEVAS','410000204',1,1),('0-14','0-50723','MARIO ALBERTO','MACIAS','LARIOS','MARIO ALBERTO MACIAS MACIAS','410060680',1,1),('0-15','0-50723','FRANCISCO JAVIER','ESPINOSA ','ALVARADO','FRANCISCO JAVIER ESPINOSA  ESPINOSA ','410040113',2,1),('0-16','0-50723','ÀLFREDO','ESQUIVEL','VALDEZ','ÀLFREDO ESQUIVEL ESQUIVEL','410025487',1,1),('0-17','0-50723','JOSE LUIS','BARBA ','REYES','JOSE LUIS BARBA  BARBA ','410001356',1,1),('0-18','0-50723','FERNANDO','ALFONSO','AGUILAR','FERNANDO ALFONSO ALFONSO','410050916',1,1),('0-19','0-50723','MARCOS','GUZMAN','ORTIZ','MARCOS GUZMAN GUZMAN','410003188',1,1),('0-2','0-50392','PABLO DOMINGO','NIEBLAS','MORALES','PABLO DOMINGO NIEBLAS NIEBLAS','0',0,1),('0-20','0-50723','RUBEN ARMANDO','SERRATOS','AGUILAR','RUBEN ARMANDO SERRATOS SERRATOS','410025575',1,1),('0-21','0-50723','ANTONIO','VAZQUEZ','DURAN','ANTONIO VAZQUEZ VAZQUEZ','410061695',1,1),('0-22','0-50723','OSBALDO','GONZALEZ','AGUILAR','OSBALDO GONZALEZ GONZALEZ','410012300',1,1),('0-23','0-50780','HUHU','OKOKOK','IIHIHJ','HUHU OKOKOK OKOKOK','1234',2,0),('0-24','0-50791','JUAN','PEREZ','LOPEZ','JUAN PEREZ PEREZ','12345',2,0),('0-25','0-50694','RIGOBERTO ','VERGARA','RODRIGUEZ','RIGOBERTO  VERGARA VERGARA','0',3,0),('0-26','0-50694','SANTOS','MEZA','HERAS','SANTOS MEZA MEZA','110308961',1,1),('0-27','0-50694','JESUS ANTONIO','QUINTERO ','YANES','JESUS ANTONIO QUINTERO  QUINTERO ','10226374',1,1),('0-28','0-50694','HERIBERTO','MEZA','ENRIQUEZ','HERIBERTO MEZA MEZA','110203165',1,1),('0-29','0-50694','RICARDO','MEZA ','HERAS','RICARDO MEZA  MEZA ','110275968',1,1),('0-3','0-50420','ANIBAL','JIMENEZ','','ANIBAL JIMENEZ JIMENEZ','0',0,1),('0-30','0-50694','GERARDO','SALAZAR','JUAREZ','GERARDO SALAZAR SALAZAR','110202892',1,1),('0-31','0-50509','SAUL','CORONA','AGUILAR','SAUL CORONA CORONA','0',1,1),('0-32','0-50509','ISAI ','JIMENEZ ','NEVAREZ','ISAI  JIMENEZ  JIMENEZ ','6266',1,1),('0-33','0-50509','JULIO','CARDONA ','MONTENEGRO','JULIO CARDONA  CARDONA ','61131',2,0),('0-34','0-50509','ABRAHAM','MALO','MORENO','ABRAHAM MALO MALO','1451',1,1),('0-35','0-50509','GERARDO','SANCHEZ','ENRIQUEZ','GERARDO SANCHEZ SANCHEZ','1447',1,1),('0-36','0-50509','SALVADOR','VEYNA','RODRIGUEZ','SALVADOR VEYNA VEYNA','1455',2,0),('0-4','1-391','JOSE ','LOPEZ','','JOSE  LOPEZ LOPEZ','5562',1,1),('0-5','1-391','MONICA','GARCIA','P','MONICA GARCIA GARCIA','1254',1,1),('0-6','0-50723','RICARDO ','MEDINA','GARCIA','RICARDO  MEDINA MEDINA','0',1,1),('0-7','0-50723','VICENTE','PALMA','SANTIN','VICENTE PALMA PALMA','410050232',1,1),('0-8','0-50723','DANIEL','LOZANO','SALAZAR','DANIEL LOZANO LOZANO','410015300',1,1),('0-9','0-50723','AURELIO','PADILLA','ZAMUDIO','AURELIO PADILLA PADILLA','410044826',1,1),('1-1','1-391','ANTONIO','CARBAJAL','AGUIRRE','ANTONIO CARBAJAL AGUIRRE','105',1,1),('175-1','1-391','BEATRIZ','AGUILAR','GARCIA','BEATRIZ AGUILAR GARCIA','12345',1,1),('175-2','1-391','DIANA LIZETH','ROJAS','HERNANDEZ','DIANA LIZETH ROJAS HERNANDEZ','567',1,1),('175-3','175-1','JUAN','LOPEZ','LOPEZ','JUAN LOPEZ LOPEZ','55556',1,1),('187-1','1-298','GILBERTO','REYES','','GILBERTO REYES ','1',1,1),('187-100','0-50702','JESUS ENRIQUE','BARBUZON ','DELGADO','JESUS ENRIQUE BARBUZON  BARBUZON ','0',1,1),('187-101','0-50702','JORGE','SANDOVAL','SARABIA','JORGE SANDOVAL SANDOVAL','1',1,1),('187-102','0-50702','ARMANDO ','MONTIEL ','','ARMANDO  MONTIEL  MONTIEL ','2',1,1),('187-103','0-50702','RAMIRO ','GALVAN','','RAMIRO  GALVAN GALVAN','4',1,1),('187-104','0-50702','ALONSO ','MASCAREÑO','','ALONSO  MASCAREÑO MASCAREÑO','5',1,1),('187-105','0-50702','GONZALO GABRIEL','GUERRO','','GONZALO GABRIEL GUERRO GUERRO','6',1,1),('187-106','0-50702','FEDERICO','MONTENEGRO','','FEDERICO MONTENEGRO MONTENEGRO','7',1,1),('187-107','0-61005','PEDRO','SOTELO','ALVARADO','PEDRO SOTELO SOTELO','202680',1,1),('187-108','0-62412','MILTON RENE','VALDEZ','SALAS','MILTON RENE VALDEZ VALDEZ','0',1,1),('187-109','0-61508','JOAQUIN','BONILLA','BECERRA','JOAQUIN BONILLA BONILLA','1',1,1),('187-110','0-60349','RAMIRO','OLIVAS','CERVANTES','RAMIRO OLIVAS OLIVAS','0',2,1),('187-111','0-60349','EVERARDO','ELORZA','ORTIZ','EVERARDO ELORZA ELORZA','2',1,1),('187-112','0-59013','LIZETTE','DENISSE ','CAMACHO','LIZETTE DENISSE  DENISSE ','0',2,0),('187-113','0-52832','OKCAR ALFREDO ','MACHORRO ','CUETO','OKCAR ALFREDO  MACHORRO  MACHORRO ','17',2,0),('187-114','0-65935','EFRA','K','','EFRA K K','0',2,0),('187-115','0-66666','ARGELIA','IBARRA','GAXIOLA ','ARGELIA IBARRA IBARRA','294493',1,1),('187-116','0-66666','MARIA FERNANDA','RAMOS ','CORRALES ','MARIA FERNANDA RAMOS  RAMOS ','0',1,1),('187-117','0-66510','EDUARDO','BELTRAN','','EDUARDO BELTRAN BELTRAN','0',1,1),('187-118','0-66510','FRANCISCO','DIAZ','','FRANCISCO DIAZ DIAZ','1',1,1),('187-37','0-50870','ADRIAN','CONTRERAS ','MORALES','ADRIAN CONTRERAS  CONTRERAS ','0',1,1),('187-38','0-52223','EDUARDO','ARBALLO','TOPETE','EDUARDO ARBALLO ARBALLO','0',1,1),('187-39','0-52223','JESUS HIPOLITO','DIAZ','SAINZ','JESUS HIPOLITO DIAZ DIAZ','1',1,1),('187-40','0-52223','MANUEL','GARCIA','SILVA','MANUEL GARCIA GARCIA','3',1,1),('187-41','0-52223','RAMON','MENENDEZ','PEREZ','RAMON MENENDEZ MENENDEZ','4',1,1),('187-42','0-52366','MARCELINO ','CASTAÑO ','LOPEZ','MARCELINO  CASTAÑO  CASTAÑO ','0',2,1),('187-43','0-52366','ZEFERINO','BERMUDEZ','ROJAS','ZEFERINO BERMUDEZ BERMUDEZ','1',1,1),('187-44','1-391','ALEJANDRA','GARCIA','P','ALEJANDRA GARCIA GARCIA','234',1,1),('187-45','0-52226','JOSE AURELIO','PANTOJA','SANTOYO','JOSE AURELIO PANTOJA PANTOJA','0',1,1),('187-46','0-52226','CARLOS ENRIQUE','SILVA','ROBLES','CARLOS ENRIQUE SILVA SILVA','1',1,1),('187-47','0-52226','CARLOS ALFREDO ','ROJO','BRAMBILA','CARLOS ALFREDO  ROJO ROJO','2',1,1),('187-48','0-52226','GILBERTO','RAYA','GONZALEZ','GILBERTO RAYA RAYA','3',1,1),('187-49','0-52226','JORGE','CORONADO','','JORGE CORONADO CORONADO','4',1,1),('187-50','0-52226','RUBEN','ROMERO','APODACA','RUBEN ROMERO ROMERO','5',1,1),('187-51','0-52226','JOSE ANGEL','VALDEZ','MARTINEZ','JOSE ANGEL VALDEZ VALDEZ','6',1,1),('187-52','0-52226','ROSA MARINA','PAZ','PAEZ','ROSA MARINA PAZ PAZ','7',1,1),('187-53','0-52226','CLAUDIA ESTHELA','GOMEZ','ANGULO','CLAUDIA ESTHELA GOMEZ GOMEZ','8',1,1),('187-54','0-52226','ADOLFO','MENA','LOPEZ','ADOLFO MENA MENA','9',1,1),('187-55','175-1','RAMIRO','LUIS','RF','RAMIRO LUIS RF','1',1,1),('187-56','0-52756','JUAN DIEGO','BENSOR','MATRTINEZ','JUAN DIEGO BENSOR BENSOR','1',1,1),('187-57','0-52756','MARIO A','HERRERA','CALDERON','MARIO A HERRERA HERRERA','2',1,1),('187-58','0-52756','JESUS','GONZALEZ','','JESUS GONZALEZ GONZALEZ','3',1,1),('187-59','0-52756','EFREN','ROJITA','','EFREN ROJITA ROJITA','4',1,1),('187-60','0-52756','RENE ','DE LEON','','RENE  DE LEON DE LEON','5',1,1),('187-61','0-52756','DAVID','GUERRERO','','DAVID GUERRERO GUERRERO','6',1,1),('187-62','0-54669','LETICIA ','GOMEZ','ANDRADE','LETICIA  GOMEZ GOMEZ','0',2,0),('187-63','0-53972','EUSEBIO ','VALLE','VALENZUELA','EUSEBIO  VALLE VALLE','0',2,1),('187-64','0-52242','DANIEL ANTONIO ','GARCIA ','MURILLO','DANIEL ANTONIO  GARCIA  GARCIA ','3006643',1,1),('187-65','0-52242','EDUARDO','FRAUSTO','JIMENEZ','EDUARDO FRAUSTO FRAUSTO','12519',3,1),('187-66','0-52242','RAMON ','SUAREZ','CEJA','RAMON  SUAREZ SUAREZ','216171',1,1),('187-67','0-52242','ISRAEL','SIDA','LUCERO','ISRAEL SIDA SIDA','209385',1,1),('187-68','0-54993','ERNESTO','LOMELI','GUILLEN','ERNESTO LOMELI LOMELI','107843',1,1),('187-69','0-54993','HUMBERTO','RODRIGUEZ','LOPEZ','HUMBERTO RODRIGUEZ RODRIGUEZ','108446',1,1),('187-70','0-52109','JOSE ABRAHAM','MARTINEZ','JACOBO','JOSE ABRAHAM MARTINEZ MARTINEZ','13',3,0),('187-71','0-52109','PRO','ROBERTO','LUCERO','PRO ROBERTO ROBERTO','6',2,0),('187-72','0-52109','EDGAR ARTURO','ROSETTE','QUIENTERO','EDGAR ARTURO ROSETTE ROSETTE','1',1,1),('187-73','0-52109','LUIS GERARDO','OCHOA','SANDOVAL','LUIS GERARDO OCHOA OCHOA','2',1,1),('187-74','0-52109','ALEXIS','AUSPURO','LEYVA','ALEXIS AUSPURO AUSPURO','9',1,1),('187-75','0-52109','DAVID OMAR','SANCHEZ','HERNANDEZ','DAVID OMAR SANCHEZ SANCHEZ','5',1,1),('187-76','0-52109','LUIS {CHORE}','BALCAZAR','WANCHO','LUIS {CHORE} BALCAZAR BALCAZAR','11',3,0),('187-77','0-52109','LUIS','RAMOS ','RAMIREZ','LUIS RAMOS  RAMOS ','7',1,1),('187-78','0-52109','NINGUNO','NO','NO','NINGUNO NO NO','3',1,1),('187-79','0-52109','NO EXISTE','NO ','NO','NO EXISTE NO  NO ','4',1,1),('187-80','0-52109','ENSERVICIO','NO REPARTIDOR','NO REPARTIDOR','ENSERVICIO NO REPARTIDOR NO REPARTIDOR','8',1,1),('187-81','0-52109','LUIS ENRIQUE','LEYVA','AISPURO','LUIS ENRIQUE LEYVA LEYVA','10',1,1),('187-82','0-52109','AARON','SAAVEDRA','ARELLANO','AARON SAAVEDRA SAAVEDRA','12',1,1),('187-83','0-52109','JOSE EDUARDO','TERRAZAS','HERNANDEZ','JOSE EDUARDO TERRAZAS TERRAZAS','14',1,1),('187-84','0-54993','JESUS ENRIQUE','AGUILAR','GONZALEZ','JESUS ENRIQUE AGUILAR AGUILAR','109216',1,1),('187-85','0-54417','JUAN FRANCISCO','RODRIGUEZ ','IBARRA','JUAN FRANCISCO RODRIGUEZ  RODRIGUEZ ','0',1,1),('187-86','0-56965','ANA','ARELLANO','PINEDA','ANA ARELLANO ARELLANO','0',4,0),('187-87','0-52539','RAMON FIDENCIO ','RODRIGUEZ','FELIX','RAMON FIDENCIO  RODRIGUEZ RODRIGUEZ','29443589',3,1),('187-88','0-52539','HERIBERTO','ZAVALA','GARCIA','HERIBERTO ZAVALA ZAVALA','110313123',2,1),('187-89','0-52539','MARTIN RICARDO','MARTINEZ','ROMERO','MARTIN RICARDO MARTINEZ MARTINEZ','26348061',1,1),('187-90','0-52539','MIGUEL ALEJANDRO','CRUZ','AVILA','MIGUEL ALEJANDRO CRUZ CRUZ','110205787',1,1),('187-91','0-57793','JOSE ','PLATAS','AGUIRRE','JOSE  PLATAS PLATAS','0',2,1),('187-92','0-57793','ALEJANDRO','PLATAS ','GALLARDO','ALEJANDRO PLATAS  PLATAS ','1',1,1),('187-93','0-57793','ALONSO','HERNANDEZ','','ALONSO HERNANDEZ HERNANDEZ','2',1,1),('187-94','0-57304','JOSE LUIS','GODOY','ALVAREZ','JOSE LUIS GODOY GODOY','2',4,0),('187-95','0-57304','ALAN ANTONIO','MONTOYA','RUBIO','ALAN ANTONIO MONTOYA MONTOYA','40',4,0),('187-96','0-57304','RAUDEL','HINOJOSA','CARDONA','RAUDEL HINOJOSA HINOJOSA','110006695',3,1),('187-97','0-58700','ANDREE','SESTEAGA','','ANDREE SESTEAGA SESTEAGA','0',1,1),('187-98','0-61005','OMAR ELISEO','DAVILA','RIVAS','OMAR ELISEO DAVILA DAVILA','401293',2,0),('187-99','0-57304','RUBEN BRAULIO','GIRON','MENDOZA','RUBEN BRAULIO GIRON GIRON','110413825',2,1),('188-1','188-1','MARIO','YANEZ','ORTEGA','MARIO YANEZ ORTEGA','69',-1,1),('63-1','175-1','JUAN','LOPEZ','PEREZ','JUAN LOPEZ PEREZ','1234',1,1);
/*!40000 ALTER TABLE `conductores` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2020-01-28 11:24:21
