-- MySQL dump 10.13  Distrib 5.7.12, for Win32 (AMD64)
--
-- 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 `r_proveedores`
--

DROP TABLE IF EXISTS `r_proveedores`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `r_proveedores` (
  `R_ProveedoresID` varchar(50) NOT NULL DEFAULT '0',
  `TipoPersona` varchar(50) DEFAULT NULL,
  `CiudadesID` varchar(50) DEFAULT NULL,
  `Nombre` varchar(100) DEFAULT NULL,
  `Activo` tinyint(4) DEFAULT '0',
  `Codigo` varchar(50) DEFAULT NULL,
  `Calle` varchar(100) DEFAULT NULL,
  `NoExterior` varchar(10) DEFAULT NULL,
  `Colonia` varchar(100) DEFAULT NULL,
  `CodigoPostal` varchar(10) DEFAULT NULL,
  `Telefono` varchar(50) DEFAULT NULL,
  `TelefonoCelular` varchar(50) DEFAULT NULL,
  `Fax` varchar(50) DEFAULT NULL,
  `RFC` varchar(15) DEFAULT NULL,
  `NoCuenta` varchar(20) DEFAULT NULL,
  `CorreoElectronico` varchar(100) DEFAULT NULL,
  `Saldo` decimal(24,6) DEFAULT '0.000000',
  `DiasCredito` int(11) DEFAULT '0',
  `Extranjero` tinyint(4) DEFAULT '0',
  `Memo1` varchar(50) DEFAULT NULL,
  `Memo2` varchar(50) DEFAULT NULL,
  `Memo3` varchar(50) DEFAULT NULL,
  `Memo4` varchar(50) DEFAULT NULL,
  `Memo5` tinyint(4) DEFAULT '0',
  `Memo6` tinyint(4) DEFAULT '0',
  `InternalVersion` int(11) DEFAULT '0',
  PRIMARY KEY (`R_ProveedoresID`),
  KEY `WDIDX_R_Proveedores_CiudadesID` (`CiudadesID`),
  KEY `WDIDX_R_Proveedores_Nombre` (`Nombre`),
  KEY `WDIDX_R_Proveedores_Activo` (`Activo`),
  KEY `WDIDX_R_Proveedores_Codigo` (`Codigo`),
  KEY `WDIDX_R_Proveedores_RFC` (`RFC`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `r_proveedores`
--

LOCK TABLES `r_proveedores` WRITE;
/*!40000 ALTER TABLE `r_proveedores` DISABLE KEYS */;
INSERT INTO `r_proveedores` VALUES ('0-1','Fisica','104-46','GUADALUPE SANCHEZ QUIROS',1,'6',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SAQG770221DZ0',NULL,NULL,0.000000,0,0,NULL,NULL,NULL,NULL,0,0,1),('0-318','Moral','104-89','OPERADORA RIO COLORADO S DE RL DE CV',1,'20','AV.KINO Y 2DA','103 ALTO','CUAUHTEMOC','83400','','','','ORC960227EP3','','',0.000000,0,0,'','','','',0,0,1),('0-319','Moral','104-200','PINANOS DISTRIBUIDORA, S.A. DE C.V.',1,'21','AV. FERROCARRIL NTE ENTRE CALLE COLEGIO MILITAR Y GRAL ANAYA','507','LA TERRACITA','84600','6413243430','6413215136','','PDI19103184A','','',0.000000,0,0,'','','','',0,0,2),('0-320','Fisica','104-78','IVAN ARMENTA ALAPIZCO',1,'2053','BLVD LOS ALAMOS ','284','PUEBLO NUEVO','84080','','','','AEAI811112JVA','','',0.000000,0,0,'','','','',0,0,1),('0-321','Fisica','104-156','ANA MARIA VASQUEZ MOLINA',1,'2100','OBREGON','7','CENTRO','83570','','','','VAMA390925NB3','','',0.000000,0,0,'','','','',0,0,1),('0-322','Fisica','104-156','ISRAEL ACOSTA CASTILLO',1,'22','Benemérito de las Américas','93','centro','','','','','AOCI7904133K1','','',0.000000,0,0,'','','','',0,0,1),('0-323','Fisica','104-78','MONROY RAMOS THELMA CLAUDIA',1,'2200','BLVD Sonora esquina con AV Francisco gonzalez bocanegra','251','centro sur','83553','','','','MORT740502CJ7','','',0.000000,0,0,'','','','',0,0,2),('0-324','Moral','104-106','DISTRIBUIDORES SELECTOS DE FRUTAS Y VERDURAS FINAS',1,'23','ESTADO 29 ENTRE CJON ESTADO 29 Y CALLE LAJA ','M-211','LOS SANTOS','22104','6646217446','','','DSF110412EP0','','',0.000000,0,0,'','','','',0,0,1),('0-325','Moral','104-30','CASA LEY SAPI DE CV',1,'2300','CARRETERA INTERNACIONAL KM 1434','S/N','HUMAYA INFONAVIT ','80020','','','','CLE810525EA1','','',0.000000,0,0,'','','','',0,0,1),('0-326','Fisica','104-89','BOJORQUEZ VALENCIA JOSE ANGEL',1,'24','CJON. TAMAULIPAS  34 Y 35','3400','CAMPESTRE','83499','6531410869','6536906013','','BOVA710430JF8','','',0.000000,0,0,'','','','',0,0,1),('0-327','Moral','104-125','NUEVA WAL MART DE MEXICO',1,'2400','NEXTENGO','78 STA','CRUZ ACAYUCAN','02770','','','','NWM9709244W4','','',0.000000,0,0,'','','','',0,0,1),('0-328','Moral','104-46','COMERCIALIZADORA  MARTINS PRODUCE',1,'25','FRANCISCO I. MADERO S/N','63 B','LIBERTAD','83130','6622183119','','','CMP2212218Z8','','',0.000000,0,0,'','','','',0,0,1),('0-329','Fisica','104-46','PROVEEDORA DE PRODUCTOS ALIMENTICIOS FS',1,'2500','AVENIDA CAMELIA','73','LUIS ENCINAS','83138','','','','PPA1108119T2','','',0.000000,0,0,'','','','',0,0,1),('0-330','Moral','104-106','MERCADOS LA CAMPIÑA  S. DE R.L. DE C.V.',1,'26',' ESTADO 29 ENTRE AVENIDA PROLONGACION PASEO DE LOS HEROES Y CALLE LIBERTAD ','MANZANA ','LOS SANTOS','22104','','','','MCA161012GP1','','',0.000000,0,0,'','','','',0,0,1),('0-331','Fisica','104-156','CARNICERIA VANIA',1,'3000','BLVD DE LAS AMERICAS','S/N/','HOMBRES BLANCOS','83570','','','','JIFC8902101E6','','',0.000000,0,0,'','','','',0,0,1),('366-1','Fisica','104-100','RODOLFO ELIZARRARAZ MORA ',1,'1','AVE.3RA','260','BENITO JUAREZ ','21480','','','','EIMR7609146C7','','',0.000000,0,0,'','','','',0,0,2),('366-2','Fisica','104-100','FRANCISCO BELASCO CUEVAS',1,'2','CALLE MEXICALI','111','EL REFUGIO','','','','','BECF5510108K5','','',0.000000,0,0,'','','','',0,0,2),('366-3','Fisica','104-100','DEUDIEL ORTIZ VELAZQUEZ',1,'3','','','','','','','','OIVD891030727','','',0.000000,0,0,'','','','',0,0,2),('399-1','Fisica','104-89','ALMACEN CEDIS',0,'7','','','','','','','','','','',0.000000,0,0,'104-9','','','',0,0,5),('399-2','Fisica','104-89','IMPULSORA RIOCO S DE RL DE CV',1,'8','','','','','','','','IRI1509288Y6','','',0.000000,0,0,'','','','',0,0,4),('399-3','Moral','104-60','GALLEGO HORTO FRUT SA DE CV',1,'9','CARRETERA SAN LUIS KM 20.5','1','EJIDO CUERNAVACA','21624','','','','GHF9403295Z2','','',0.000000,0,0,'','','','',0,0,5),('399-4','Moral','104-65','DISTRIBUIDORA ARCA CONTINENTAL S DE RL DE CV',1,'4','SAN JERONIMO','813','SAN JERONIMO','','','','','DJB850527F30','','',0.000000,0,0,'','','','',0,0,2),('399-5','Moral','104-89','ADMINISTRADORA DEL COLORADO S DE RL DE CV',1,'5','AV KINO Y 2DA ','103 ','CUAUHTEMOC','83400','','','','ACO030325PHA','','',0.000000,0,0,'','','','',0,0,2),('409-1','Fisica','104-37','ADONEHI CAZARES CANO',1,'10','','','','','','','','CACX881223RW3','','',0.000000,0,0,'','','','',0,0,5),('443-1','Fisica','104-200','FRUTERIA DIPAC',0,'11','','','','','','','','','','',0.000000,0,0,'104-9','','','',0,0,6);
/*!40000 ALTER TABLE `r_proveedores` 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 2026-05-30  9:22:55