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

DROP TABLE IF EXISTS `usuariospinpat`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `usuariospinpat` (
  `UsuariosPinPatID` varchar(50) NOT NULL,
  `TiendasID` varchar(50) DEFAULT NULL,
  `BancoID` varchar(50) DEFAULT NULL,
  `ClienteID` varchar(50) DEFAULT NULL,
  `Usuario` varchar(50) DEFAULT NULL,
  `Passsword` varchar(50) DEFAULT NULL,
  `Activo` tinyint(4) DEFAULT '0',
  `InternalVersion` int(11) DEFAULT '0',
  `Memo1` varchar(50) DEFAULT NULL,
  `Memo2` varchar(50) DEFAULT NULL,
  `Memo3` varchar(50) DEFAULT NULL,
  `Memo4` varchar(20) DEFAULT NULL,
  `Memo5` varchar(20) DEFAULT NULL,
  `Memo6` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`UsuariosPinPatID`),
  UNIQUE KEY `TiendasID` (`TiendasID`),
  KEY `WDIDX_UsuariosPinPat_BancoID` (`BancoID`),
  KEY `WDIDX_UsuariosPinPat_Activo` (`Activo`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `usuariospinpat`
--

LOCK TABLES `usuariospinpat` WRITE;
/*!40000 ALTER TABLE `usuariospinpat` DISABLE KEYS */;
INSERT INTO `usuariospinpat` VALUES ('0-1','20','2','YS3ZAOrF/w','fcbIHk44nSQ','ui2g6E8tYOk',1,12,'VIP MARKET CETYS','018002472535','','0i9ZDAg8gzsqTg','',''),('0-10','192-6','2','cjG2yNuy7g','hMeZmhr9gAs','9ptNmoCn7ps',1,5,'VIP MARKET PUEBLA','018002472535','','aABtCS5NfSE7uw','',''),('0-11','188-2','2','Luo7A4+DNw','jvLsdA1BYRI','Eb18moS0xnk',1,6,'VIP MARKET KM 43 2','018002472535','','Qp1rSdSCDv6P+w','',''),('0-12','18','2','pG1r8RH+vg','5jtEtLOrHKs','cB/cNPEVahs',1,5,'VIP LAZARO CARDENAS','018002472535','','JLbxtPahPLJymg','',''),('0-13','29','2','vHhi/hn5rQ','wCxdurCjM9Q','A59/lIe28JM',1,6,'VIP MARKET MORUA','018002472535','','wALQ+X5VRXYWfg','',''),('0-14','28','2','PPg63Yx0KA','erz9dA8unik','8JR3lIGs8J0',1,9,'VIP JOSEFA ORTIZ','018002472535','','lumPISJLYwXmCg','',''),('0-15','27','2','eCDyA9a+5g','mtD1dA0ohAs','OqJJlIWg4Gk',1,5,'VIP BENITO JUAREZ','018002472535','','aBqE2fqnByg0uA','',''),('0-16','31','2','ZBim1s2dAQ','YLyZmhj/hzA','+HZWeqqfG6Y',1,5,'VIP EL DESCANSO','018002472535','','jtELIaaJIVPIMA','',''),('0-17','192-50','2','YjreAOi9/Q','2SBSubGjOMU','YuvaD/4Yny4',1,10,'VIP MARKET GOLFO I','018002472535','','cBhQCQg8gDM5tQ','',''),('0-18','192-48','2','NMs23Y1pLQ','n+se70pkcAE','AZdmj5i29ok',1,11,'VIP CONSTITUCION','018002472535','','itEIIaaJIVLHMw','',''),('0-19','192-51','2','Fsg22o5pUQ','ZcbK6Us5nCk','CKV0b4qk5ZQ',1,7,'VIP MARKET DALIAS','018002472535','','7v2nISY5cffAOA','',''),('0-2','24','2','xnl+8iH4oA','zDspurSbItE','efDaFPsckSI',1,5,'VIP PLAZA MANDARIN','018002472535','','yCRDCS5NfT8hXQ','',''),('0-20','30','2','fDPyAtax5Q','lxIDHU9vSPk','Pr1pY56+zWA',1,7,'VIP EL ENCINO','018002472535','','mOqDISxOYgLqCg','',''),('0-21','192-31','2','SAmtxtCpFQ','YN/C7lQ2hzA','MNGS7kz+s14',1,10,'VIP VALLE LAS PALMAS','018002472535','','cBhRCQg8gDI4tA','',''),('0-22','192-53','2','snZq8hPvqw','VNDPCEI3hzg','hw6dOlECbhQ',1,4,'VIP SAN DIEGO I','018002472535','','Sr/7OaT6psaZ2Q','',''),('0-23','8','2','lUhp9BHq0A','MKnfC0cqsV4','KcKVaZTLxHM',1,15,'VIP MARKET SONORA','018002472535','','PDZJyP4VtEoSag','',''),('0-24','178-1','2','lnFi/hjz1w','L25RuxHD2Hk','KrWAabbW2Xw',1,7,'VIP LOS PINOS','018002472535','','NjM78TZBmVsSbg','',''),('0-25','192-60','2','kxu9g+Q','hSfwBdS74Q','AtIphAMD5A',1,1,'','','','','',''),('0-26','192-64','2','qmh59R8FtQ','erjOCEM1myg','gQ/MHvYkfAs',1,8,'VIP  MONTECARLO','018002472535','','65oaZcwahae0Ng','',''),('0-27','192-68','2','YQag1s2jAQ','S41jiAbpuVw','7HpxmoOmELU',1,8,'VIP PEDRO LOYOLA I','018002472535','','+tHJHDg0e+PULA','',''),('0-28','4','2','LwCn1PSGOw','oxA07lJySPE','3VMwno5+NsE',1,6,'VIP CUAUHTEMOC','018002472535','','8mVO4eKrA2Y/Sw','',''),('0-29','2','2','bS3ZAOrH/A','a8POHk44mTw','CZJ+no6485g',1,6,'VIP MARKET KINO Y 2','018002472535','','6HI+4eyuAncvVw','',''),('0-3','22','2','VDa2ydyyEg','nsaZlBv+gAc','+mz29M1yIKk',1,5,'VIP MARKET 1810','018002472535','','1gs57O6tAHYhaQ','',''),('0-30','9','2','OR2l1fN8KQ','YbeKaDMRkjM','nA3dPuYWgwY',1,7,'VIP OBREGON Y 16 I','018002472535','','aBxvCS5NfSM1uQ','',''),('0-31','6','2','Qwam3/iEIg','Z517jgPgqi8','Oal5bom64Gc',1,8,'VIP MARKET SONORA','018002472535','','ZhtX8TZBmS82ug','',''),('0-32','13','2','k0oPbjrO6w','3ypcjryoMME','UvjUCOUFiTw',1,7,'VIP MARKET FEDERAL','018002472535','','aABiCS5NfSA6ug','',''),('0-33','15','2','VCzprKeuEQ','1ytdCV2SF74','ffLFCf0imSI',1,6,'VIP MARKE CAMPESTRE','018002472535','','NjUz6Qo/n1USbg','',''),('0-34','1','2','UzfOANewEQ','a8H1Hk49ljs','vi/B6GtKX+Y',1,8,'VIP RUIZ CORTINEZ I','018002472535','','kvmLISBIZAjREQ','',''),('0-35','10','2','Y0U2ZzLB/g','3S9diL2oN8I','CKV9boqp6JU',1,6,'VIP MARKET JALISCO','018002472535','','6HI/4eyuAnYuVg','',''),('0-36','5','2','gkb1qrvG4g','KWh3bynY13o','b9iSD/nukTY',1,6,'VIP NUEVO LEON Y 9','018002472535','','qjcn+WRaRirtFQ','',''),('0-37','192-2','2','snNm8BTzrw','5TwjtbWVIqs','ixzYNfUbbBc',1,5,'VIP MARKET MEXICO','018002472535','','SJJDGbqHJw2J9Q','',''),('0-38','7','2','lXxn8hT01g','acPKHE48mjs','kw+iPOQGgAM',1,6,'VIP MARKET MEZQUITE','018002472535','','TrfmOaT6psuO0g','',''),('0-39','11','2','WRmuxs+cBg','NZaTnBL3sls','/3JKvIKhGKM',1,6,'VIP NUEVO LEON Y 22','018002472535','','6IZ7ISJLYxnBPQ','',''),('0-4','35','2','pHh+8iH5vQ','yDwpurSbI9Q','MticOvTlqVw',1,10,'VIP MARKET ANAHUAC','018002472535','','1jkx6Qo/n1MYUA','',''),('0-40','32','2','07H0umsOqw','f8/L7kg5kCE','jjjdiAd0XRA',1,6,'CR COMERCIAL','018002472535','','SJZGGbqHJwqO9g','',''),('0-41','3','2','Xx0c3aWOCA','bt3B6UwwgTI','0Hkr+UqCB7o',1,5,'VIP  INDUSTRIAL I','018002472535','','cBRTCQg8gDQysg','',''),('0-42','16','2','XjwP3oybDw','UINbiB7Ow0Q','R6IheqmVzE8',1,6,'VIP MARKET PROGRESO','018002472535','','cBRSCQg8gDUzsw','',''),('0-43','12','2','lXd++R7x0w','H0QzvgWm/4Y','8JFjnI7D9p8',1,6,'VIP RESIDENCIAS','018002472535','','0jk26Qo/n1IXUw','',''),('0-44','14','2','WDh7Ye6VIA','6VNTj76lArM','PNGfiZvSq14',1,6,'VIP BUROCRATA','018002472535','','Yh9q8TZBmSw7vw','',''),('0-45','17','2','AcYnAYNfXQ','L38suhG3yXQ','Da98moO145A',1,9,'VIP MARKET SONOYTA','018002472535','','TrvkOaT6psmU1A','',''),('0-46','192-71','2','Pvo034t2Kg','xRxe6XaQP8o','QMNla4+/wE0',1,9,'VIP EL SAUZAL','018002472535','','agVlIFRSZR0+ug','',''),('0-47','192-70','2','3yOBTpY','xmV68SL8pA','TwJkdJBmlA',0,2,'','','','','',''),('0-48','192-73','2','jExp9xDn1w','PWpFiR7N1GE','9qdza4+u65o',1,5,'VIP CALZ AMERICAS','018002472535','','ZABhJCBIZx85vQ','',''),('0-49','192-74','2','xmV68SL8pA','jugCFkVocBc','3Egl5kF2OsM',1,5,'VIP MARKET JOKER I','018002472535','','Zh9V8TZBmS08vA','',''),('0-5','188-1','2','Zhmm1s2cBA','hLuZmhj/hg0','mgvdOvIVgAk',1,7,'VIP TERAN TERAN','018002472535','','ZPa1BCRKkemt2Q','',''),('0-50','192-72','2','upmt2PH/qw','R5Gdmxv6sFE','Mohr6U794WQ',1,6,'VIP MARKET NAPA','018002472535','','ZABt/Ao/kig+vg','',''),('0-56','34','2','r4P4v2gB1w','2ypblLmqMcQ','mBnJOvInbAE',1,5,'VIP GOMEZ MORIN 2','018002472535','','aBqH2fqnByk1uQ','',''),('0-57','26','2','NRQRprKONA','LXdYlBrK0HU','8ZVktJa2+J8',1,6,'VIP GPE VICTORIA','018002472535','','','',''),('0-58','192-111','2','LgGl0veFPQ','R31VuxXAyk8','okTjGWBTS/I',1,6,'VIP BENITO JUAREZ','018002472535','','kv2JISBIZAbXEw','',''),('0-59','192-123','2','LRY8BZCENg','zR9RBmmIPs8','52sj9k+CFKc',1,5,'VIP ISLAS AGRARIAS','018002472535','','SrvlOaT6psiT1w','',''),('0-6','25','2','4KYerJclgQ','fJp5ai7hpyg','jx3xFGVEdBc',1,5,'VIP MARKET CALLE 11','018002472535','','mOaNISxOYgTkCA','',''),('0-60','192-122','2','Xhkc36WRCQ','7VFam7ioBLE','0HAl9U1zDbw',1,6,'VIP GRAL LAZARO C','018002472535','','SJZBGbqHJwuP9w','',''),('0-61','192-129','2','okJp/xLnww','XXhFgxDFxkc','tw+nA24nduw',1,5,'VIP OBREGON Y 5','018002472535','','lv2IISBIZAfYEA','',''),('0-62','178-6','2','YEb7qrrH/g','epxzbijepyw','vCLFDlxCV/E',1,3,'VIP LOS PORTALES','018002472535','','','',''),('0-64','178-7','2','07H6vWsNqw','ZMLK6Uw4lCc','V7D2G2NHu0M',1,2,'VIP MARKET COSTERO','018002472535','','','',''),('0-65','178-12','2','STXMA9asFg','OWNYmhvI3mc','Tbwtegm0wF4',1,3,'VIP MARKET VIVEROS','018002472535','','','',''),('0-66','192-152','2','CMo034poVA','4Dxb6neWJK8','j/6NCGIRfx8',1,3,'VIP MADERO Y 4','018002472535','','nOmwXcQWiPngBA','',''),('0-67','192-156','2','lnRo/xPs1A','XYJmjQLkvUQ','ZtqTD0X5njo',1,9,'VIP MARKET VISTA HERMOSA','018002472535','','5iyIJYLnxTQoQA','',''),('0-68','192-155','2','2IZJ8i8YhA','a8jdD0EkjTg','M41rD1n862s',1,6,'VIP MARKET CANTAMAR','018002472535','','dujwHZpzKVjAyA','',''),('0-69','192-157','2','Ev8534hwUA','3SdF6XaVPcQ','L3ZtCfzfBYE',0,6,'VIP MARKET SAN JUDAS','018002472535','','gd4oE41qPTvSPA','',''),('0-7','23','2','Tiin0PSiNg','6FBYurKmALM','dCawCmYaYBU',1,6,'VIP RIO NUEVO','018002472535','','slkFFJTiqXF28g','',''),('0-8','21','2','vnpr+xf7rw','ziIstLWZOdo','A596moK28JM',1,5,'VIP GOMEZ MORIN','018002472535','','wALT+X5VRXcXfw','',''),('0-81','192-214','2','dT/r2Lqs7g','dfftdAxAZhc','Y1rw4/TEiGbr64zE',1,2,'Vip Valle Dorado','018002472535','','','',''),('0-82','192-219','2','dT7p2bis7g','ivbiewo9ZRY','qgLzglyzXwNhRg',1,3,'VIP LA CUESTA','018002472535','','','',''),('0-83','192-215','2','vX188iD3rQ','VK+DlScJnD8','rqHpm6bbhA4',1,2,'VIP PLAYAS','018002472535','','','',''),('0-84','192-190','2','SQi6zNisFg','RyTAymbp1qkJEw','XsF/yXdUzq17',1,5,'VIP SAN ANTONIO','018002472535','','','',''),('0-85','178-29','2','RySq3fWaPw','zjA8o6aIIdI','PfP58mdKpVU',1,1,'VIP MARKET DEL MAL','6535172100','','','',''),('0-87','178-34','2','CMw53IxmUQ','2iMqhLCcOMc','aYkcpnYkPT8c',1,1,'VIP MARKET SAN QUINTIN SUR','6535172100','','','',''),('0-88','178-38','2','CMw53IxmUQ','2iMqhLCcOMc','aYkcpnYkPT8c',1,1,'VIP MARKET MANEADERO','6535172100','','','',''),('0-9','19','2','omF+9SD/uw','wicptLeaPc4','AZZtapa59ok',1,6,'VIP  KENWORTH','018002472535','','4AwnycicIIAuRg','',''),('0-90','178-36','2','lGqm0/H00w','ofHgeQo+T/I','zfwQ3e7j0Z0',1,1,'VIP MARKET SAN QUINTIN NORTE','6535172100','','','','');
/*!40000 ALTER TABLE `usuariospinpat` 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:39:15
