-- 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',1,1),('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','ESPONOSA ','ALVARADO','FRANCISCO JAVIER ESPONOSA  ESPONOSA ','410040113',1,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-3','0-50420','ANIBAL','JIMENEZ','','ANIBAL JIMENEZ JIMENEZ','0',0,1),('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),('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 2023-03-30  4:02:52
