-- 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 `empresas` -- DROP TABLE IF EXISTS `empresas`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `empresas` ( `EmpresasID` varchar(50) NOT NULL, `InternalVersion` int(11) DEFAULT '0', `Activo` tinyint(4) DEFAULT '0', `Nombre` varchar(100) DEFAULT NULL, `NoHorasSemanalesEsperadas` int(11) DEFAULT '0', `NoHorasMaximoJornada` int(11) DEFAULT '0', `NoHorasJornada` int(11) DEFAULT '0', `Abreviacion` varchar(10) DEFAULT NULL, `RegistroPatronal` varchar(50) DEFAULT NULL, `RFC` varchar(15) DEFAULT NULL, `Actividad` varchar(50) DEFAULT NULL, `Direccion` varchar(200) DEFAULT NULL, `Delegacion` varchar(50) DEFAULT NULL, `CodigoPostal` varchar(50) DEFAULT NULL, `CiudadesID` varchar(50) DEFAULT NULL, `RazonSocial` varchar(50) DEFAULT NULL, `NoExterior` varchar(10) DEFAULT NULL, `Calle` varchar(100) DEFAULT NULL, `Colonia` varchar(100) DEFAULT NULL, `LlaveEmisor` longtext, `ClaveEmisor` varchar(50) DEFAULT NULL, `FacturaSinRelacionArt` tinyint(4) DEFAULT '0', `Cedula` longblob, PRIMARY KEY (`EmpresasID`), KEY `WDIDX_Empresas_Activo` (`Activo`), KEY `WDIDX_Empresas_RFC` (`RFC`), KEY `WDIDX_Empresas_CiudadesID` (`CiudadesID`), KEY `WDIDX_Empresas_RazonSocial` (`RazonSocial`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `empresas` -- LOCK TABLES `empresas` WRITE; /*!40000 ALTER TABLE `empresas` DISABLE KEYS */; INSERT INTO `empresas` VALUES ('0-1',7,1,'ADMCC',48,14,8,'ADMCC','','','','','','','','','','','',NULL,'',0,NULL),('0-10',7,1,'COCC',48,14,8,'COCC','','','','','','','','','','','',NULL,'',0,NULL),('0-11',7,1,'CRC',48,14,8,'CRCCCC','','','','','','','','','','','',NULL,'',0,NULL),('0-12',16,1,'ORCcc',48,16,8,'ORC','','','','','','','','','','','',NULL,'',0,NULL),('0-13',8,1,'GDC',48,14,8,'GDC','','','','','','','','','','','',NULL,'',0,NULL),('0-14',5,1,'JHFG',48,14,8,'JHFG','','','','','','','','','','','',NULL,'',0,NULL),('0-15',8,1,'OP.CK-KM43',48,14,8,'OPKM43','','','','','','','','','','','',NULL,'',0,NULL),('0-16',19,1,'LCVR',48,16,8,'LCVRR','','lvrd010101lvr','','','','11111','104-89','LCVR','','PENDIENTE','',NULL,'',0,NULL),('0-17',7,1,'LCVRS',48,14,8,'LCVRS','','','','','','','','','','','',NULL,'',0,NULL),('0-18',7,1,'ORCPP',48,14,8,'ORCPP','','','','','','','','','','','',NULL,'',0,NULL),('0-19',7,1,'ORCSL',48,14,8,'ORCSL','','','','','','','','','','','',NULL,'',0,NULL),('0-2',7,1,'ADMMX',48,14,8,'ADMMX','','','','','','','','','','','',NULL,'',0,NULL),('0-20',8,1,'ORCK',48,16,8,'ORCK','','','','','','','','','','','',NULL,'',0,NULL),('0-21',12,1,'ORCTKT',48,14,8,'ORCTKT','','','','','','','','','','','',NULL,'',0,NULL),('0-22',11,1,'ORC',48,16,8,'CENTRA','','CRR030325MQ9','','','','11111','104-89','ELIMANR','','ELIMANR','',NULL,'',0,NULL),('0-23',7,1,'ORC2',48,14,8,'ORCCCC','','','','','','','','','','','',NULL,'',0,NULL),('0-24',1,1,'VR STORAGE INC',48,14,8,'VR','','','','','','','','','','','',NULL,'',0,NULL),('0-25',1,1,'VR WHOLESALE INC',48,16,8,'VRW','','','','','','','','VR WHOLESALE INC','','','',NULL,'',0,NULL),('0-26',1,1,'KLM MANAGEMENT COMPANY AMCOM FOOD SERVICE',48,16,8,'MCAFS','','','','','','','','KLM MANAGEMENT COMPANY AMCOM FOOD SERVICE','','','',NULL,'',0,NULL),('0-27',1,1,'KPS GLOBAL LLC',48,16,8,'KGL','','','','','','','','KPS GLOBAL LLC','','','',NULL,'',0,NULL),('0-28',1,1,'TROPICALE FOODS, INC',48,16,8,'TFI','','','','','','','','TROPICALE FOODS, INC','','','',NULL,'',0,NULL),('0-29',1,1,'BUNGER STEEL INC',48,16,8,'BSI','','','','','','','','BUNGER STEEL INC','','','',NULL,'',0,NULL),('0-3',7,1,'ADMTKT',48,14,8,'ADMTKT','','','','','','','','','','','',NULL,'',0,NULL),('0-31',7,1,'SERVICIO CIRCULO GL SA DE CV',48,16,8,'SCGL','','SCG8308022R7','','','CIUDAD JUAREZ','83500','104-157','SERVICIO CIRCULO GL SA DE CV','1050','NAINARI','CENTRO','SCG8308022R7_20180104_120508.key','8puFy9XNmihg',0,NULL),('0-4',11,1,'ARRENDADORA RIO COLORADO S DE RL DE CV',48,16,8,'ARC','','ARC960227KVA','','','','83448','104-89','ARRENDADORA RIO COLORADO S DE RL DE CV','1601','CALLE 16','COL RESIDENCIAS',NULL,'',0,NULL),('0-5',8,0,'ARCC',48,14,8,'ARCC','','','','','','','','','','','',NULL,'',0,NULL),('0-6',8,1,'CEGM-KM43',48,14,8,'CE-KM43','','','','','','','','','','','',NULL,'',0,NULL),('0-7',5,1,'CC',48,14,8,'CC','','','','','','','','','','','',NULL,'',0,NULL),('0-8',5,1,'CEGM',48,14,8,'CEGM','','','','','','','','','','','',NULL,'',0,NULL),('0-9',13,1,'CORRALES OPERADORA COMERCIAL S DE RL DE CV',48,14,8,'COC','','COC9605242S7','COMERCIAL','','','83400','104-89','CORRALES OPERADORA COMERCIAL','','AV KINO Y CALLE 2','CUAUHTEMOC',NULL,'',0,NULL),('104-1',21,1,'JESUS HUMBERTO FLORES GUERRA',48,14,14,'FOGJ','','FOGJ541227BE0','','','1','83448','104-89','JESUS HUMBERTO FLORES GUERRA','1600','AV. OBREGON Y 16','RESIDENCIAS','FOGJ541227BE0_20161105_111612.key','O6K9ivtJwdZerB2XbQ',0,NULL),('104-2',22,1,'ADMINISTRADORA DEL COLORADO S DE RL DE CV',48,14,8,'ACO','','ACO030325PHA','','','1','83400','104-89','ADMINISTRADORA DEL COLORADO S DE RL DE CV','103 ALTOS','AV. KINO Y 2DA','CUAUHTEMOC','ACO030325PHA_20161108_134916.key','Vh5SeDz3eJW0Wg',0,NULL),('104-3',22,1,'OPERADORA RIO COLORADO S DE RL DE CV',48,16,8,'ORC','','ORC960227EP3','','','1','83400','104-89','OPERADORA RIO COLORADO S DE RL DE CV','103 ALTOS','AV.KINO Y 2DA','CUAUHTEMOC','ORC960227EP3_20161112_102204.key','tEUk9X4ineYi',0,NULL),('104-4',21,1,'LUIS CARLOS VALENCIA ROSAS',48,16,8,'VARL','','VARL6410151IA','','','1','83489','104-89','LUIS CARLOS VALENCIA ROSAS','2201','AV. NUEVO LEON Y CALLE 22','FEDERAL','VARL6410151IA_20161105_112818.key','wzIHtdqbmCuUlhrcpA',0,NULL),('104-5',4,1,'GASOLINERA DEL COLORADO SA DE CV',48,16,8,'GD C','','GCO050316746','','','','83489','104-89','GASOLINERA DEL COLORADO SA DE CV','2511','AV. QUINTANAROO Y 26','FEDERAL','GCO050316746_1204161334S.key','5ZUrB/g58UU',0,NULL),('104-6',21,1,'CENTRAL RIO COLORADO S. DE R.L. DE C.V.',48,16,8,'CRC','','CRC030325MQ9','','','1','83448','104-89','CENTRAL RIO COLORADO S. DE R.L. DE C.V.','1601','CALLE 16 ENTRE CALLEJON CARLOS G. CALLES Y AV. OBREGON','RESIDENCIAS','CRC030325MQ9_20161105_111824.key','Vd/C8Xwi+Ij2',0,NULL),('104-7',22,1,'CARLOS ENRIQUE GARIBALDI MUNGUIA',48,16,8,'GAMC','','GAMC660521JP1','','','','83430','104-89','CARLOS ENRIQUE GARIBALDI MUNGUIA','601','AV. AVILA CAMACHO Y VERACRUZ ','INDUSTRIAL','GAMC660521JP1_20161112_104143_1.key','0O/VjO948x8/3w',0,NULL),('178-1',7,1,'SUPER SERVICIO 18 DE MARZO SA DE CV',48,16,8,'SSD','','SSD9612178P5','','','MEXICALI','21000','104-60','SUPER SERVICIO 18 DE MARZO SA DE CV','884','CALZADA INDEPENDENCIA','CENTRO CIVICO','SSD9612178P5_20160401_153548.key','x76KCkS/ihh2',0,NULL),('178-2',8,1,'COMBUSTIBLES Y LUBRICANTES GARVA S DE RL DE CV',48,16,8,'CLG','','CLG180428213','','','','83499','104-89','COMBUSTIBLES Y LUBRICANTES GARVA S DE RL DE CV','2308','AV TLAXCALA','CAMPESTRE','CSD_CLG180428213_20190207_083609.key','8n7veRrYlw',0,NULL),('178-3',1,1,'MA DOLORES LEON DURAN',48,16,8,'LED','','LEDM760328853','','','','83449','104-89','MA DOLORES LEON DURAN','201','CALLEJON KINO','COMERCIAL',NULL,'',0,NULL),('178-4',1,1,'ARRENDADORA PUNTA DEL SOL S DE RL DE CV',48,16,8,'APS','','APS181011U80','','','','83550','104-78','ARRENDADORA PUNTA DEL SOL S DE RL DE CV','SN','BLVD JOSEFA ORTIZ DE DOMINGUEZ','CENTRO SUR',NULL,'',0,NULL),('192-1',9,1,'JOSE ALONSO CARLOS CASTAÑEDA',48,16,8,'CAC','','CACX7103169E3','','','','21840','104-60','JOSE ALONSO CARLOS CASTAÑEDA','SN','CARRETERA MEXICALI SAN LUIS KM 60','EJIDO HERMOSILLO','CSD_CACX7103169E3.key','/G4fBntD930',0,NULL),('192-10',3,1,'ESTACION DE SERVICIO 3210 SA DE CV',48,16,8,'ES3210','','GIB770620UZ9','','','','83250','104-46','ESTACION DE SERVICIO 3210 SA DE CV','','BLVD LUIS DONALDO COLOSIO Y MADRID ','',NULL,'',0,NULL),('192-11',8,1,'SERVICIOS VISTA ALAMAR SA DE CV',48,16,8,'SVA','','SVA080326LJ9','','','','22450','104-106','SERVICIOS VISTA ALAMAR SA DE CV','18001','AV AZTECAS','VISTA ALAMAR','CSD_SERVICIOS_VISTA_ALAMAR_SA_DE_CV_SVA080326LJ9_20171002_113959.key','9IRrMn5iWiZm',0,NULL),('192-13',11,1,'ESTACIONES DE AUTOSERVICIO Y COMBUSTIBLES TICO SA DE CV',48,8,8,'TICO','','EAC121101D59','','','','83179','104-46','ESTACIONES DE AUTOSERVICIO Y COMBUSTIBLES TICO SA ','910','BOULEVARD LAZARO CARDENAS','UNION DE LADRILLEROS','EAC121101D59_20190116_155201.key','jls81WxVrfEf',0,NULL),('192-14',6,1,'SERVICIOS VAL-KAR S.A. DE C.V.',48,12,12,'SVK','','SVK960605DP4','','','','85000','104-157','SERVICIOS VAL-KAR S.A. DE C.V.','SUR 870','TABASCO','CENTRO','SVK960605DP4_20180507_154252.key','vlLG6h8MAR1LUvw',0,NULL),('192-15',3,1,'PEDRO PANTOJA ZEPEDA',48,8,8,'PPZ','','PAZP570103AJ8','','','','21230','104-60','PEDRO PANTOJA ZEPEDA','500','AV CUAUHTEMOC','LAS FUENTES','CSD_PAZP570103AJ8_20180828_152902.key','hlbRb6xMIS3vtg',0,NULL),('192-16',5,1,'SUPER MEXOLINA GRUPO GASOLINERO S DE RL DE CV',48,16,8,'SMG','','SMG150924AA9','','','','21180','104-60','SUPER MEXOLINA GRUPO GASOLINERO S DE RL DE CV','1399','LAZARO CARDENAS','VILLA FONTANA','CSD_SMG150924AA9_20181026_101344.key','cKycMVH3suqtYK+z',0,NULL),('192-17',1,1,'SERVICIO RAVELLO SA DE CV',8,16,48,'RAVELLO','','SRA0910024E0','','','','1','104-106','SERVICIO RAVELLO SA DE CV','','PENDIENTE','',NULL,'',0,NULL),('192-18',3,1,'COMBUSTIBLES ADITIVOS Y SERVICIOS MAGICOS S DE RL DE CV',48,16,8,'CASM','','CAS000831GQ5','','','','21216','104-60','COMBUSTIBLES ADITIVOS Y SERVICIOS MAGICOS S DE RL ','1699','MANUEL GOMEZ MORIN','LAS HADAS','CSD_CAS000831GQ5_20190306_105938.key','m0Ga+tjIn+Io',0,NULL),('192-19',4,1,'AUTOSERVICIOS DE BAJA CALIFORNIA SA DE CV',48,16,8,'ABC','','ABC970814LM0','','','','21290','104-60','AUTOSERVICIOS DE BAJA CALIFORNIA SA DE CV','861',' LAZARO CARDENAS','INDEPENDENCIA','CSD_ABC970814LM0_20190301_101614.key','9ItuLXpkWyhS',0,NULL),('192-2',6,1,'IMPULSORA RIOCO S DE RL DE CV',48,8,8,'IRI','','IRI1509288Y6','','','','83400','104-89','IMPULSORA RIOCO S DE RL DE CV','103 ALTOS','AV KINO Y 2DA','CUAUHTEMOC','IRI1509288Y6_20161205_112301.key','GG5/I8T60NDS',0,NULL),('192-20',3,1,'ARRENDADORA GARVAL S DE RL DE CV',48,16,16,'ARRG','','AGA1603306H4','','','','83499','104-89','ARRENDADORA GARVAL S DE RL DE CV','3308','TLAXCALA','CAMPESTRE','CSD_AGA1603306H4_20180416_140755.key','zdqAvCMkFA',0,NULL),('192-21',9,1,'LOPEZ CHAIRA SA DE CV',48,16,8,'LCH','','LCA1007019S6','','','','83448','104-89','LOPEZ CHAIRA SA DE CV','1413','ALVARO OBREGON','RESIDENCIAS','CSD_LCA1007019S6_20190506_094926.key','rzl8fwCX1Q',0,NULL),('192-22',6,1,'ESTACION DE SERVICIO VILLAFONTANA',48,16,8,'ESV','','ESV981204JR3','','','MEXICALI','21230','104-60','ESTACION DE SERVICIO VILLAFONTANA','1399','LAZARO CARDENAS','VILLA FONTANA','CSD_ESV981204JR3_20190910_132235.key','miu0JQ9MI6ht3g',0,NULL),('192-3',1,1,'EMMA DANITZA VALENCIA ROSAS',44,16,8,'VARE','','VARE620330UT3','','','','11111','104-89','EMMA DANITZA VALENCIA ROSAS','','CALLE','',NULL,'',0,NULL),('192-4',1,1,'DELTA DEL NOROESTE S DE RL DE CV',44,16,8,'DDN','','DDN120320KZ4','','','','11111','104-89','DELTA DEL NOROESTE S DE RL DE CV','','CALLE','',NULL,'',0,NULL),('192-5',2,1,'CONSTRUCTORA INOVA S DE RL DE CV',44,18,8,'CIN','','CIN091125PB8','','','','11111','104-89','CONSTRUCTORA INOVA S DE RL DE CV','','CALLE','',NULL,'',0,NULL),('192-6',2,1,'GASERVICIO CENTENARIO SA DE CV',48,16,8,'GC','','GCE940411JC5','','','','83260','104-46','GASERVICIO CENTENARIO SA DE CV','','REFORMA Y MANUEL Z CUBILLAS','',NULL,'',0,NULL),('192-7',2,1,'PERINORTE SA DE CV',48,16,8,'PNORTE','','PER990622VBA','','','','83140','104-46','PERINORTE SA DE CV','','PERIFERICO NORTE ENTRE CALLES TRES Y DOS','',NULL,'',0,NULL),('192-8',7,1,'ESTACION DE SERVICIO 1641 SA DE CV',48,16,8,'ES1641','','ESM981001CI3','','','','83000','104-46','ESTACION DE SERVICIO 1641 SA DE CV','SN','BLVD LUIS ENCINAS','HERMOSILLO CENTRO','CSD_ESTACION_DE_SERVICIO_1641_20170927_091859.key','8OPKZzr0Jb8U4zPByHg',0,NULL),('192-9',9,1,'ESTACION DE SERVICIO 1642 SA DE CV',48,16,8,'ES1642','','IOL710823DN0','','','','83180','104-46','ESTACION DE SERVICIO 1642 SA DE CV','SN','BLVD LUIS ENCINAS','OLIVARES','CSD_ESTACION_DE_SERVICIO_1642_SA_DE_CV_IOL710823DN0_20170927_090252.key','lnF8+fwQJ9wZtsZSXRE',0,NULL),('78-1',16,1,'PROVEEDORA DE SERVICIOS DEL SOL, CENTRO CAMBIARIO S.A DE C.V',48,16,8,'PSS','','PSS101111FY3','','','','21210','104-89','PROVEEDORA DE SERVICIOS DEL SOL S.A DE C.V','437','LAS ROSAS','ALAMITOS','pss101111fy3_1211151103s.key','DJoEX5Kqzfbz4G2B04Y',0,NULL),('81-1',8,1,'ORCSONOYTA',48,14,14,'ORCS','','','','','','','','','','','',NULL,'',0,NULL),('81-2',6,1,'CENTRAL RIO COL. ',48,16,8,'CENTRAL','','','','','','','','','','','',NULL,'',0,NULL),('81-3',5,1,'CENTRAL RIO COL. (SONOYTA)',48,16,8,'CENT-SONOY','','','','','','','','','','','',NULL,'',0,NULL),('81-4',3,1,'CE-MXLI',48,16,8,'CE-MXLI','','','','','','','','','','','',NULL,'',0,NULL),('81-5',13,1,'IMPORTACIONES DEL COLORADO S. DE R.L. DE C.V.',48,18,8,'ICO','E7123993106','ICO110126QI1','COMERCIO AL POR MENOR EN TIENDAS','','1','83448','104-89','IMPORTACIONES DEL COLORADO S. DE R.L. DE C.V.','1601',' CALLE 16 ENTRE OBREGON Y CARLOS G CALLES','RESIDENCIAS','ICO110126QI1_20170530_174100.key','9SOlODqi4/63Cpw',0,NULL),('999-1',1,1,'SUPER SERVICIO VITAL SA DE CV',48,16,8,'SSV','','SSV020618EE1','','','','21090','104-60','SUPER SERVICIO VITAL SA DE CV','1599','BLVD. ADOLFO LOPEZ MATEOS','ZACATECAS','ssv020618ee1_1312201318s.key','wcti7LHy0CaiZLNbpVc',0,NULL),('999-2',5,1,'GASEXPRESS GASOLINERAS SA DE CV',48,16,8,'GEX','','GGA040910HY5','','','','83190','104-46','GASEXPRESS GASOLINERAS SA DE CV','71','GUADALUPE VICTORIA Y NAYARIT','SAN BENITO','CSD_GasE2017_GGA040910HY5_20170920_143959.key','8W5eD7/tBnU',0,NULL),('999-3',10,1,'COMERCIALIZADORA SONORA CACTUS S DE RL DE CV',48,14,8,'CSC','','CSC13111486A','','','','83440','104-89','COMERCIALIZADORA SONORA CACTUS S DE RL DE CV','SN','AV. TLAXCALA','SONORA','CSD_CSC13111486A_20171028_084453.key','2qZIfcgyBUYH6w',0,NULL),('999-4',1,1,'RICARDO JACQUEZ PEREZ',48,16,8,'JAPR','','JAPR8201165C5','','','','21200','104-60','RICARDO JACQUEZ PEREZ','299','CALZADA DE LAS AMERICAS','CUAHUTEMOC NORTE','CSD_JAPR8201165C5_20190228_155359.key','WQikOBnNYLaTbg',0,NULL),('999-5',6,1,'SERVICENTRO CUAUHTEMOC S DE RL DE CV',48,16,8,'SVC','','SCU981017GL5','','','','21200','104-60','SERVICENTRO CUAUHTEMOC S DE RL DE CV','299','CALZ. JUSTO SIERRA','CUAHUTEMOC NORTE','CSD_SCU981017GL5_20190228_140645.key','6sbbs9qHcE9P',0,NULL); /*!40000 ALTER TABLE `empresas` 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:36:56