-- 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 `usuariosclientes`
--

DROP TABLE IF EXISTS `usuariosclientes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `usuariosclientes` (
  `UsuariosClientesID` varchar(50) NOT NULL,
  `InternalVersion` int(11) DEFAULT '0',
  `Activo` tinyint(4) DEFAULT '0',
  `NombreUsuario` varchar(50) DEFAULT NULL,
  `Contrasena` varchar(50) DEFAULT NULL,
  `NombreCompleto` varchar(200) DEFAULT NULL,
  `CorreoElectronico` varchar(100) DEFAULT NULL,
  `EnviarACorreo` tinyint(4) DEFAULT '0',
  `TipoUsuariosClientesID` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`UsuariosClientesID`),
  KEY `WDIDX_UsuariosClientes_Activo` (`Activo`),
  KEY `WDIDX_UsuariosClientes_NombreUsuario` (`NombreUsuario`),
  KEY `WDIDX_UsuariosClientes_NombreCompleto` (`NombreCompleto`),
  KEY `WDIDX_UsuariosClientes_TipoUsuariosClientesID` (`TipoUsuariosClientesID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `usuariosclientes`
--

LOCK TABLES `usuariosclientes` WRITE;
/*!40000 ALTER TABLE `usuariosclientes` DISABLE KEYS */;
INSERT INTO `usuariosclientes` VALUES ('0-1',1,1,'VERONICA','VERO','VERONICA LOMELI','',0,''),('0-2',1,1,'HUMBERTO','HUMBERTO','HUMBERYO ZAMORA','',0,''),('0-3',1,1,'DLOPEZ','1234','DIEGO LOPEZ','',0,''),('0-4',1,1,'AMELENDEZ','4321','ANDRES MELENDEZ','',0,''),('0-5',1,1,'BETO','123','HUMBERTO ZAMORA','',0,''),('0-6',1,1,'FERNANDA','LOPEZ','FERNANDA LOPEZ','',0,''),('0-7',1,1,'CLAUROCHA','9612','CLAUDIA ROCHA ZAZUETA','',0,''),('104-1',6,1,'MCASTRO','15985','MICHELLE CASTRO IBARRA','',0,'General'),('104-2',-1,1,'CFE','CFEMXLI','CFE','',0,'General'),('175-1',2,1,'OPERRADORA','OP3R','OPERADORA PRUEBA','',0,'General'),('175-10',5,1,'JRREYNOSO','JRREY','JESUS RODOLFO REYNOSO RAMIREZ','',0,'Reportes'),('175-11',1,1,'1972','45678','VERONICA LOMELI','',0,'General'),('175-12',2,1,'RCOLIO','4886','RENE COLIO','',0,'General'),('175-2',2,1,'1967','45678','VERONICA LOMELI SANDOVAL','',0,'General'),('175-3',3,1,'MONICA','MONICA','MONICA A GARCIA','',0,'General'),('175-4',1,1,'HPEREZ','HP3R3Z','HECTOR MARIO PEREZ RODRIGUEZ','',0,'General'),('175-5',2,1,'MMARTINEZ','5516','MARUBIA MARTÍNEZ CRUZ','',0,'General'),('175-6',1,1,'LGUERRERO','6369','LORENA GUERRERO','',0,'General'),('175-7',1,1,'LLEON','3XP0130N','LORENA LEON RUIZ','',0,'General'),('175-8',1,1,'LCASTELLANOS','9173','LUIS CASTELLANOS','',0,'General'),('175-9',1,1,'JPORTILLO','2667','JAVIER PORTILLO','',0,'General'),('187-1',1,1,'VERO','45678','VERONICA LOMELI','',0,'General'),('187-2',5,1,'ALEJANDRA','1','MONICA A','',0,'Condicional'),('187-3',1,1,'JORGE','MSP','JORGE LARA','',0,'General'),('187-4',4,1,'H','1','HUMBERTO ZAMORA','',0,'General'),('187-5',1,1,'JUAN','1','JUAN PEREZ LOPEZ','',0,'General'),('187-6',1,1,'SAGUILAR','4268','SERGIO AGUILAR DIPP','',0,'General'),('187-7',1,1,'OGAMEZ','9764','OCTAVIO ALONSO GAMEZ AGUAYO','',0,'General'),('187-8',1,1,'ARACELY','9623','ARACELY ROBLEDO','',0,'General'),('187-9',4,1,'BMMXLI','BMXLI','BEBIDAS MUNCIALES MEXICALI','',0,'General'),('188-1',3,1,'CLRO','1234','CLAUDIA ROCHA','',0,'General'),('45-1',8,0,'MANUELC','MANUELC','MANUEL CASTRO','',0,'General'),('45-2',10,1,'COCACOLA','COCA','COCA COLA MXLI','',0,'General'),('45-3',2,1,'IVAN','IVANLARA','IVAN LARA','',0,'General');
/*!40000 ALTER TABLE `usuariosclientes` 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 2019-12-04  6:37:58