-- 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_bom` -- DROP TABLE IF EXISTS `r_bom`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `r_bom` ( `R_BomID` varchar(50) NOT NULL, `ArticuloPadreID` varchar(50) DEFAULT NULL, `ArticuloHijoID` varchar(50) DEFAULT NULL, `Cantidad` int(11) DEFAULT '0', `Unidad` varchar(30) DEFAULT NULL, `Activo` tinyint(4) DEFAULT '0', `Memo1` varchar(30) DEFAULT NULL, `Memo2` varchar(30) DEFAULT NULL, `Memo3` varchar(30) DEFAULT NULL, `InternalVersion` int(11) DEFAULT '0', PRIMARY KEY (`R_BomID`), KEY `WDIDX_R_Bom_ArticuloPadreID` (`ArticuloPadreID`), KEY `WDIDX_R_Bom_ArticuloHijoID` (`ArticuloHijoID`), KEY `WDIDX_R_Bom_Unidad` (`Unidad`), KEY `WDIDX_R_Bom_Activo` (`Activo`), KEY `WDIDX_R_Bom_ArticuloPadreIDArticuloHijoID` (`ArticuloPadreID`,`ArticuloHijoID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `r_bom` -- LOCK TABLES `r_bom` WRITE; /*!40000 ALTER TABLE `r_bom` DISABLE KEYS */; INSERT INTO `r_bom` VALUES ('0-1','399-19','399-240',1,'',1,'','','',3),('0-10','399-29','0-56',500,'',1,'','','',9),('0-11','399-14','0-56',600,'',1,'','','',7),('0-12','399-18','399-242',1,'',1,'','','',2),('0-13','0-26','399-87',1,'',0,'','','',5),('0-14','0-26','399-245',2,'',0,'','','',5),('0-15','0-26','399-231',1,'',0,'','','',5),('0-16','0-26','399-37',5,'',0,'','','',5),('0-17','0-26','399-218',1,'',1,'','','',3),('0-18','0-82','0-81',30,'',1,'','','',2),('0-19','0-84','0-81',60,'',1,'','','',1),('0-2','399-451','399-199',170,'',1,'','','',11),('0-20','0-84','399-378',1,'',1,'','','',1),('0-21','0-84','399-377',1,'',1,'','','',1),('0-22','0-82','399-396',1,'',1,'','','',1),('0-23','0-82','399-395',1,'',1,'','','',1),('0-24','439-492','0-50',15,'',1,'','','',7),('0-25','399-27','399-34',8,'',1,'','','',5),('0-26','0-125','0-121',1000,'',1,'','','',6),('0-27','0-125','0-119',600,'',1,'','','',6),('0-28','0-125','0-83',20,'',0,'','','',6),('0-29','0-125','399-400',3,'',1,'','','',6),('0-3','399-451','399-206',15,'',1,'','','',10),('0-30','0-126','0-122',1000,'',1,'','','',5),('0-31','0-126','399-206',30,'',1,'','','',5),('0-32','0-126','399-216',5,'',1,'','','',5),('0-33','0-126','399-200',5,'',0,'','','',5),('0-34','0-126','399-214',5,'',1,'','','',5),('0-35','0-126','399-215',250,'',1,'','','',5),('0-36','0-126','399-199',250,'',1,'','','',5),('0-37','0-126','399-212',250,'',1,'','','',5),('0-38','0-126','399-223',10,'',1,'','','',5),('0-39','0-126','0-120',100,'',1,'','','',5),('0-4','399-11','0-49',50,'',1,'','','',6),('0-40','0-126','0-83',20,'',1,'','','',5),('0-41','0-127','0-123',400,'',1,'','','',16),('0-42','0-127','439-1',216,'',1,'','','',16),('0-43','0-127','399-201',400,'',1,'','','',16),('0-44','0-127','399-206',30,'',1,'','','',16),('0-45','0-127','399-224',10,'',0,'','','',16),('0-46','0-127','399-212',100,'',1,'','','',16),('0-47','0-127','399-217',100,'',1,'','','',16),('0-48','0-127','399-215',100,'',1,'','','',16),('0-49','0-127','399-199',100,'',1,'','','',16),('0-5','399-13','0-50',50,'',1,'','','',7),('0-50','0-127','399-221',50,'',1,'','','',16),('0-51','0-127','399-222',50,'',1,'','','',16),('0-52','0-127','0-112',50,'',1,'','','',16),('0-53','0-127','399-225',15,'',1,'','','',16),('0-54','0-127','0-124',1,'',1,'','','',16),('0-55','0-127','399-227',30,'',1,'','','',16),('0-56','0-127','399-226',5,'',1,'','','',16),('0-57','0-127','0-83',10,'',1,'','','',16),('0-58','0-127','399-223',10,'',1,'','','',16),('0-59','0-127','0-128',255,'',1,'','','',15),('0-6','399-2','0-52',1000,'',1,'','','',7),('0-60','0-126','366-1',5,'',1,'','','',4),('0-61','0-140','0-192',1,'',0,'','','',2),('0-62','0-141','0-193',1,'',0,'','','',2),('0-63','439-489','399-121',1,'',1,'','','',1),('0-64','0-127','399-198',10,'',1,'','','',12),('0-65','399-11','399-223',5,'',1,'','','',3),('0-66','439-492','399-206',45,'',1,'','','',4),('0-67','439-492','399-34',15,'',1,'','','',4),('0-68','439-492','399-223',15,'',1,'','','',4),('0-69','0-125','0-173',100,'',1,'','','',4),('0-7','399-12','0-53',400,'',1,'','','',6),('0-70','399-16','0-67',5,'',1,'','','',5),('0-71','399-8','399-198',5,'',1,'','','',3),('0-8','399-16','0-51',60,'',1,'','','',8),('0-9','399-451','0-54',250,'',1,'','','',9),('399-1','399-3','399-256',1000,'',1,'','','',11),('399-10','399-8','399-212',170,'',1,'','','',12),('399-11','399-8','399-215',100,'',1,'','','',12),('399-12','399-8','399-214',7,'',1,'','','',12),('399-13','399-8','399-244',1,'',1,'','','',12),('399-14','399-8','399-232',650,'',1,'','','',12),('399-15','399-8','399-239',350,'',1,'','','',12),('399-16','399-8','399-226',15,'',1,'','','',12),('399-17','399-8','399-227',45,'',1,'','','',12),('399-18','399-8','399-114',20,'',0,'','','',12),('399-19','399-27','399-223',15,'',1,'','','',13),('399-2','399-7','399-256',1000,'',1,'','','',11),('399-20','399-27','399-200',4,'',0,'','','',13),('399-21','399-27','399-212',85,'',1,'','','',13),('399-22','399-27','399-215',50,'',1,'','','',13),('399-23','399-27','399-214',4,'',1,'','','',13),('399-24','399-27','399-244',1,'',1,'','','',13),('399-25','399-27','399-232',325,'',1,'','','',13),('399-26','399-27','399-239',175,'',1,'','','',13),('399-27','399-27','399-226',12,'',1,'','','',13),('399-28','399-27','399-227',15,'',1,'','','',13),('399-29','399-27','399-114',8,'',0,'','','',13),('399-3','399-7','399-204',120,'',1,'','','',11),('399-30','399-27','399-256',500,'',1,'','','',13),('399-31','399-27','399-204',60,'',1,'','','',13),('399-32','399-27','399-203',40,'',1,'','','',13),('399-33','399-27','399-243',1,'',1,'','','',13),('399-34','399-27','399-217',75,'',1,'','','',13),('399-35','399-11','399-211',4,'',0,'','','',18),('399-36','399-11','399-212',40,'',1,'','','',18),('399-37','399-11','399-215',65,'',1,'','','',18),('399-38','399-11','399-203',30,'',1,'','','',18),('399-39','399-11','399-225',2,'',1,'','','',18),('399-4','399-7','399-203',80,'',1,'','','',11),('399-40','399-11','399-216',4,'',1,'','','',18),('399-41','399-11','399-199',50,'',1,'','','',18),('399-42','399-11','399-214',3,'',1,'','','',18),('399-43','399-11','399-362',25,'',1,'','','',18),('399-44','399-11','399-234',1000,'',1,'','','',18),('399-45','399-11','399-244',50,'',0,'','','',18),('399-46','399-12','399-237',2200,'',1,'','','',19),('399-47','399-12','399-251',120,'',0,'','','',19),('399-48','399-29','399-409',20,'',1,'','','',19),('399-49','399-29','399-406',1500,'',1,'','','',19),('399-5','399-7','399-243',1,'',1,'','','',11),('399-50','399-29','399-254',250,'',0,'','','',19),('399-51','399-13','399-223',5,'',1,'','','',18),('399-52','399-13','399-200',3,'',0,'','','',18),('399-53','399-13','399-212',40,'',1,'','','',18),('399-54','399-13','399-220',50,'',1,'','','',18),('399-55','399-13','399-215',50,'',1,'','','',18),('399-56','399-13','399-225',2,'',1,'','','',18),('399-57','399-13','399-216',3,'',1,'','','',18),('399-58','399-13','399-199',45,'',1,'','','',18),('399-59','399-13','399-221',70,'',1,'','','',18),('399-6','399-7','399-226',10,'',1,'','','',11),('399-60','399-13','399-214',3,'',1,'','','',18),('399-61','399-13','399-362',15,'',1,'','','',18),('399-62','399-13','399-222',70,'',1,'','','',18),('399-63','399-13','399-235',1000,'',1,'','','',18),('399-64','399-13','399-248',50,'',0,'','','',18),('399-65','399-13','399-217',25,'',1,'','','',18),('399-66','399-14','399-400',10,'',1,'','','',19),('399-67','399-14','399-408',1,'',1,'','','',19),('399-68','399-14','399-407',1400,'',1,'','','',19),('399-69','399-14','399-254',400,'',0,'','','',19),('399-7','399-7','399-217',150,'',1,'','','',11),('399-70','399-14','399-211',4,'',0,'','','',19),('399-71','399-14','399-223',10,'',0,'','','',19),('399-72','399-15','399-212',200,'',1,'','','',11),('399-73','399-15','399-215',125,'',1,'','','',11),('399-74','399-15','399-236',1150,'',1,'','','',11),('399-75','399-15','399-226',15,'',1,'','','',11),('399-76','399-2','399-246',1,'',1,'','','',17),('399-77','399-2','399-113',1,'',1,'','','',17),('399-78','399-2','399-362',35,'',1,'','','',17),('399-79','399-2','399-202',360,'',1,'','','',17),('399-8','399-8','399-223',30,'',1,'','','',12),('399-80','399-2','399-233',1400,'',1,'','','',17),('399-81','399-2','399-250',750,'',0,'','','',17),('399-82','399-2','399-217',60,'',1,'','','',17),('399-83','399-16','399-211',4,'',0,'','','',21),('399-84','399-16','399-223',15,'',1,'','','',21),('399-85','399-16','399-212',70,'',1,'','','',21),('399-86','399-16','399-238',500,'',1,'','','',21),('399-87','399-16','399-215',70,'',1,'','','',21),('399-88','399-16','399-113',1,'',1,'','','',21),('399-89','399-16','399-362',10,'',1,'','','',21),('399-9','399-8','399-200',7,'',0,'','','',12),('399-90','399-16','399-249',60,'',0,'','','',21),('399-92','399-13','399-252',70,'',0,'','','',17),('399-93','399-16','399-201',550,'',1,'','','',20),('399-94','399-13','399-257',70,'',1,'','','',16),('399-95','399-8','399-34',15,'',1,'','','',11),('438-1','439-489','399-118',95,'',1,'','','',3),('438-2','439-489','399-376',1,'',1,'','','',3),('438-3','439-489','399-390',1,'',1,'','','',3),('438-4','439-489','399-364',1,'',0,'','','',3),('439-100','399-8','399-206',40,'',1,'','','',8),('439-101','399-451','439-1',504,'',1,'','','',15),('439-102','399-451','439-2',250,'',0,'','','',14),('439-103','399-451','439-3',10,'',1,'','','',14),('439-104','399-451','399-215',70,'',1,'','','',14),('439-105','399-451','399-203',50,'',1,'','','',14),('439-106','399-451','399-217',200,'',1,'','','',14),('439-107','399-451','399-400',5,'',0,'','','',14),('439-108','399-451','366-6',170,'',0,'','','',14),('439-109','399-27','366-1',4,'',1,'','','',9),('439-110','399-27','399-206',50,'',1,'','','',9),('439-111','399-27','399-264',3,'',1,'','','',9),('439-112','399-27','399-196',3,'',1,'','','',9),('439-113','399-11','366-1',4,'',1,'','','',12),('439-114','399-11','399-206',20,'',1,'','','',12),('439-115','399-11','399-34',15,'',1,'','','',12),('439-116','399-11','399-247',50,'',0,'','','',12),('439-117','399-13','366-1',3,'',1,'','','',12),('439-118','399-13','399-206',15,'',1,'','','',12),('439-119','399-13','399-34',15,'',1,'','','',12),('439-120','399-15','399-223',15,'',1,'','','',7),('439-121','399-15','399-206',60,'',1,'','','',7),('439-122','399-15','399-214',5,'',1,'','','',7),('439-123','399-15','366-1',5,'',1,'','','',7),('439-124','399-15','399-34',15,'',1,'','','',7),('439-125','399-2','399-206',60,'',1,'','','',13),('439-126','399-16','366-1',4,'',1,'','','',14),('439-127','399-16','399-214',5,'',1,'','','',14),('439-128','399-16','399-206',30,'',1,'','','',14),('439-129','399-21','399-118',40,'',1,'','','',3),('439-130','399-21','399-390',1,'',1,'','','',3),('439-131','399-21','399-121',1,'',1,'','','',3),('439-132','399-21','399-376',1,'',1,'','','',3),('439-133','439-484','399-116',95,'',1,'','','',2),('439-134','439-484','399-390',1,'',1,'','','',2),('439-135','439-484','399-121',1,'',1,'','','',2),('439-136','439-484','399-376',1,'',1,'','','',2),('439-137','439-485','399-117',95,'',1,'','','',3),('439-138','439-485','399-390',1,'',1,'','','',3),('439-139','439-485','399-121',1,'',1,'','','',3),('439-140','439-485','399-376',1,'',1,'','','',3),('439-141','439-486','399-118',153,'',1,'','','',3),('439-142','439-486','399-391',1,'',1,'','','',3),('439-143','439-486','399-121',1,'',1,'','','',3),('439-144','439-486','399-124',1,'',1,'','','',3),('439-145','439-487','399-405',151,'',1,'','','',2),('439-146','439-487','399-391',1,'',1,'','','',2),('439-147','439-487','399-121',1,'',1,'','','',2),('439-148','439-487','399-124',1,'',1,'','','',2),('439-149','439-488','399-117',153,'',1,'','','',3),('439-150','439-488','399-391',1,'',1,'','','',3),('439-151','439-488','399-121',1,'',1,'','','',3),('439-152','439-488','399-124',1,'',1,'','','',3),('439-153','399-12','399-206',30,'',1,'','','',14),('439-154','399-29','399-203',30,'',1,'','','',14),('439-155','439-492','399-199',120,'',1,'','','',16),('439-156','439-492','399-215',100,'',1,'','','',16),('439-157','439-492','366-1',7,'',1,'','','',16),('439-158','439-492','399-214',5,'',1,'','','',16),('439-159','439-492','399-204',200,'',1,'','','',16),('439-160','439-492','399-217',200,'',1,'','','',16),('439-161','439-492','399-227',125,'',1,'','','',16),('439-162','439-492','399-248',15,'',0,'','','',16),('439-163','439-492','439-491',500,'',1,'','','',15),('439-96','399-7','399-206',60,'',1,'','','',8),('439-97','399-8','366-1',7,'',1,'','','',8),('439-98','399-8','399-264',5,'',1,'','','',8),('439-99','399-8','399-196',5,'',0,'','','',8); /*!40000 ALTER TABLE `r_bom` 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:23:18