-- 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 `usuariosrecargas` -- DROP TABLE IF EXISTS `usuariosrecargas`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `usuariosrecargas` ( `UsuariosRecargasID` varchar(50) NOT NULL, `Usuario` varchar(50) DEFAULT NULL, `TiendasID` varchar(50) DEFAULT NULL, `SucursalID` varchar(50) DEFAULT NULL, `EmpresaID` 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, PRIMARY KEY (`UsuariosRecargasID`), KEY `WDIDX_UsuariosRecargas_TiendasID` (`TiendasID`), KEY `WDIDX_UsuariosRecargas_Activo` (`Activo`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `usuariosrecargas` -- LOCK TABLES `usuariosrecargas` WRITE; /*!40000 ALTER TABLE `usuariosrecargas` DISABLE KEYS */; INSERT INTO `usuariosrecargas` VALUES ('','','','','','',0,2,'','',''),('1089','Karmi_Kino2da','2','01001','0100000001','12345',1,3,'','',''),('1090','Karmi_Kino26','12','01002','0100000001','12345',1,3,'','',''),('1091','Karmi_Tlax12','6','01003','0100000001','12345',0,2,'','',''),('1092','Karmi_Obregon16','9','01004','0100000001','12345',0,2,'','',''),('1093','Karmi_Monterrey','1','01005','0100000001','12345',0,2,'','',''),('1094','Karmi_Rev34','14','01006','0100000001','12345',1,3,'','',''),('1095','KARMI_NL22','11','01007','0100000001','12345',1,4,'','',''),('1096','Karmi_NL9','5','01008','0100000001','12345',0,2,'','',''),('1097','Karmi_Tlax34','15','01009','0100000001','12345',1,3,'','',''),('1098','Karmi_Tam22','10','01010','0100000001','12345',1,3,'','',''),('1099','Karmi_CirculoR','32','01012','0100000001','12345',0,2,'','',''),('1100','Karmi_Cuauhtemoc','4','01013','0100000001','12345',1,3,'','',''),('1101','Karmi_Qroo26','13','01014','0100000001','12345',0,2,'','',''),('1102','Karmi_Lib42','16','01018','0100000001','12345',1,3,'','',''),('1103','Karmi_Const','3','01019','0100000001','12345',1,3,'','',''),('1104','Karmi_Brech17','7','01020','0100000001','12345',1,3,'','',''),('1105','Karmi_Sonora17','8','01031','0100000001','12345',1,3,'','',''),('1106','Karmi_NL42','192-2','01038','0100000001','12345',1,3,'','',''),('1107','Karmi_Sonoyta','17','01011','0100000001','12345',1,3,'','',''),('1108','Karmi_Benito','27','01015','0100000001','12345',1,3,'','',''),('1109','Karmi_Josefa','28','01016','0100000001','12345',1,3,'','',''),('1110','Karmi_Simon','29','01017','0100000001','12345',1,3,'','',''),('1111','Karmi_Puebla','192-6','01040','0200000002','12345',1,3,'','',''),('1112','Karmi_Km43','26','01021','0100000001','12345',1,3,'','',''),('1113','Karmi_RioNvo','23','01023','0200000002','12345',1,3,'','',''),('1114','Karmi_Calle11','25','01024','0200000002','12345',1,3,'','',''),('1115','Karmi_GomezM','21','01025','0200000002','12345',1,3,'','',''),('1116','Karmi_Kenworth','19','01026','0200000002','12345',1,3,'','',''),('1117','Karmi_Mandarin','24','01027','0200000002','12345',1,3,'','',''),('1118','Karmi_LazaroC','18','01028','0200000002','12345',1,3,'','',''),('1119','KARMI_CETYS','20','01029','0200000002','12345',1,3,'','',''),('1120','Karmi_1810','22','01033','0200000002','12345',1,3,'','',''),('1121','KARMI_ANAHUAC','35','01034','0200000002','12345',1,3,'','',''),('1122','Karmi_GomezM2','34','01035','0200000002','12345',1,3,'','',''),('1123','Karmi_Anahuac2','104-24','01036','0200000002','12345',1,3,'','',''),('1124','Karmi_Teran','188-1','01037','0200000002','12345',1,3,'','',''),('1125','Karmi_Km43_2','188-2','01039','0200000002','12345',1,3,'','',''),('1126','Karmi_Encino','30','01022','0200000002','12345',1,3,'','',''),('1127','Karmi_Descanso','31','01030','0200000002','12345',1,3,'','',''),('1192','KARMI_JUSTO_SIERRA','178-1','01041','0200000002','12345',1,2,'','',''),('1193','KARMI_PALMAS','192-31','01042','0200000002','12345',1,2,'','',''),('1199','KARMI_PALMAS','192-31','01042','0200000002','12345',1,3,'','',''),('1206','KARMI_GOLFO','192-50','01043','0100000001','12345',1,2,'','',''),('1211','KARMI_VIPMARKET','192-53','01044','0200000002','12345',1,2,'','',''),('1212','KARMI_DALIAS26','192-51','01046','0100000001','12345',1,2,'','',''),('1213','KARMI_CONSTITUCIONMA','192-48','01045','0100000001','12345',1,4,'','',''),('1241','KARMI_VIP_ALP','192-60','01047','0200000002','12345',1,3,'','',''),('1244','KARMI_MONTECARLO','192-64','01048','0200000002','12345',1,2,'','',''),('1246','KARMI_PEDRO_LOYOLA','192-68','01049','0200000002','12345',1,3,'','',''),('1247','KARMI_JOKER','-1','01050','0200000002','12345',0,1,'','',''),('1251','KARMI_JOKER','192-70','01050','0200000002','12345',0,5,'','',''),('1251999999','KARMI_JOKER','192-70','01050','0200000002','12345',0,6,'','',''),('1252','KARMI_PLAYITAS','192-71','01051','0200000002','12345',1,2,'','',''),('1254','KARMI_AMERICAS','192-73','01052','0200000002','12345',1,2,'','',''),('125499999','KARMI_AMERICAS','-1','01052','0200000002','12345',1,2,'','',''),('1255','KARMI_NAPA','192-72','01053','0200000002','12345',1,2,'','',''),('1270','KARMI_ROSARITO1','192-111','01054','0200000002','12345',1,2,'','',''),('1278','KARMI_TECNOLOGICO','192-122','01055','0200000002','12345',1,2,'','',''),('1279','KARMI_ISLAS','192-123','01056','0200000002','12345',1,2,'','',''),('1280','KARMI_VIP_SANLUIS','192-129','01057','0100000001','12345',1,3,'','',''),('1285','VIP_PORTALES','178-6','01058','0200000002','12345',1,2,'','',''),('1286','KARMI_VIP_COSTERO','178-7','01059','0200000002','12345',1,2,'','',''),('1287','KARMI_VIP_VIVEROS','178-12','01060','0200000002','12345',1,3,'','',''),('1288','KARMI_MADERO_4TA','192-152','01061','0200000002','12345',1,2,'','',''),('1289','KARMI_VIP_CANTAMAR','192-155','01062','0200000002','12345',1,2,'','',''),('1290','KARMI_VISTA_HERMOSA','192-156','01063','0200000002','12345',1,2,'','',''),('1291','KARMI_VIP_SANTA_ANA','192-157','01064','0100000001','12345',1,2,'','',''),('1292','KARMI_VALLE_DORADO','192-214','01065','0200000002','12345',1,2,'','',''),('1293','KARMI_VIP_LA_CUESTA','192-219','01066','0200000002','12345',1,2,'','',''),('1294','KARMI_VIP_PLAYAS_TJ','192-215','01067','0200000002','12345',1,3,'','',''),('1296','KARMI_VIP_SAN_ANT','192-190','01068','0200000002','12345',1,4,'','',''),('12960','KARMI_VIP_SAN_ANT','192-190','01068','0200000002','12345',1,3,'','',''),('1297','KARMI_VIP_DEL_MAR','178-29','01069','0200000002','12345',1,2,'','',''),('1298','OBREGON_15','178-33','01070','0300000003','12345',1,2,'','',''),('1299','SAN QUINTIN SUR','178-34','01071','0200000002','12345',1,2,'','',''),('1300','KARMI_VIP_MANEADERO','178-38','01072','0200000002','12345',1,2,'','',''),('1301','SAN QUINTIN NORTE','178-36','01073','0200000002','12345',1,2,'','',''),('KARMI VIP MARKET LOPEZ MATEOS','KARMI_VIP_ALP','192-60','01047','0200000002','12345',1,2,'','',''); /*!40000 ALTER TABLE `usuariosrecargas` 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:30