API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Aug 2nd, 2017
512
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 110.70 KB | None | 0 0
raw download clone embed print report
  1. -- MySQL dump 10.13 Distrib 5.6.16, for Win64 (x86_64)
  2. --
  3. -- Host: localhost Database: boutique
  4. -- ------------------------------------------------------
  5. -- Server version 5.6.16-log
  6.  
  7. use boutique; -- Ya debe estar la BD creada
  8.  
  9. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  10. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  11. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  12. /*!40101 SET NAMES utf8 */;
  13. /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
  14. /*!40103 SET TIME_ZONE='+00:00' */;
  15. /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
  16. /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  17. /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  18. /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
  19.  
  20. --
  21. -- Table structure for table `clasificacion`
  22. --
  23.  
  24. DROP TABLE IF EXISTS `clasificacion`;
  25. /*!40101 SET @saved_cs_client = @@character_set_client */;
  26. /*!40101 SET character_set_client = utf8 */;
  27. CREATE TABLE `clasificacion` (
  28. `codigo` varchar(10) NOT NULL,
  29. `departamento` int(11) NOT NULL,
  30. PRIMARY KEY (`codigo`,`departamento`),
  31. KEY `departamento` (`departamento`),
  32. CONSTRAINT `clasificacion_ibfk_1` FOREIGN KEY (`codigo`) REFERENCES `productos` (`codigo`),
  33. CONSTRAINT `clasificacion_ibfk_2` FOREIGN KEY (`departamento`) REFERENCES `departamentos` (`departamento`)
  34. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  35. /*!40101 SET character_set_client = @saved_cs_client */;
  36.  
  37. --
  38. -- Dumping data for table `clasificacion`
  39. --
  40.  
  41. LOCK TABLES `clasificacion` WRITE;
  42. /*!40000 ALTER TABLE `clasificacion` DISABLE KEYS */;
  43. INSERT INTO `clasificacion` VALUES ('100100',1),('100102',1),('100104',1),('100106',1),('100108',1),('100110',1),('100112',1),('100114',1),('100116',1),('100118',1),('100120',1),('200100',2),('200102',2),('200104',2),('200106',2),('200108',2),('200110',2),('200112',2),('200114',2),('200116',2),('200118',2),('200220',2),('300100',3),('300102',3),('300104',3),('300106',3),('300108',3),('300110',3),('300112',3),('300114',3),('300116',3),('300118',3),('300120',3),('300122',3);
  44. /*!40000 ALTER TABLE `clasificacion` ENABLE KEYS */;
  45. UNLOCK TABLES;
  46.  
  47. --
  48. -- Table structure for table `clientes`
  49. --
  50.  
  51. DROP TABLE IF EXISTS `clientes`;
  52. /*!40101 SET @saved_cs_client = @@character_set_client */;
  53. /*!40101 SET character_set_client = utf8 */;
  54. CREATE TABLE `clientes` (
  55. `cliente` int(11) NOT NULL,
  56. `paterno` varchar(30) NOT NULL,
  57. `materno` varchar(30) NOT NULL,
  58. `nombre` varchar(30) NOT NULL,
  59. `rfc` varchar(13) NOT NULL,
  60. `calleno` varchar(60) NOT NULL,
  61. `colonia` int(11) DEFAULT NULL,
  62. `telefono` varchar(10) DEFAULT NULL,
  63. PRIMARY KEY (`cliente`),
  64. UNIQUE KEY `rfc` (`rfc`),
  65. KEY `colonia` (`colonia`),
  66. CONSTRAINT `clientes_ibfk_1` FOREIGN KEY (`colonia`) REFERENCES `colonias` (`colonia`)
  67. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  68. /*!40101 SET character_set_client = @saved_cs_client */;
  69.  
  70. --
  71. -- Dumping data for table `clientes`
  72. --
  73.  
  74. LOCK TABLES `clientes` WRITE;
  75. /*!40000 ALTER TABLE `clientes` DISABLE KEYS */;
  76. INSERT INTO `clientes` VALUES (2000,'LOPEZ','NUÑEZ','ANDRES','LOPE','DEL AMANECER',2,'103040'),(2010,'JUAREZ','GODINEZ','FABIOLA','FABI','CALLE DEL OLVIDO',3,'112345'),(2030,'ORTEGA ','GALINDO','RAUL','ORTE','NEGRETRE',1,'123457'),(2040,'JUAREZ','LOPEZ','ALFREDO','JUAR','PRIV. FORTIN',2,'346765'),(2050,'DOMINGUEZ','FLORES ','ISELA','domi','priv',2,'102032'),(9131,'ALONSO ','HERNANDEZ ',' DAGOBERTO','ALHD010512A20','pendiente',5,'618842715'),(12639,'ALMEIDA ','MARO ',' WENDY','ALMW600319M54','pendiente',5,'618175258'),(15502,'ALAMEDA ','SAUCEDO ',' ANGEL','ALSA660509A21','pendiente',4,'618843245'),(15553,'ALMADA ','SUAREZ ',' ANGELICA','ALSA870522A38','pendiente',4,'618839776'),(20365,'ARIAS ','JIMENEZ ',' LEONEL','ARJL630606J47','pendiente',4,'618144778'),(24115,'BARROSO ','SANCHEZ ',' JOAQUIN','BASJ600822BAS','pendiente',4,'61885893'),(24688,'BAÑALES ','VILLABA ',' ISAIAS','BAVI450321V1','pendiente',3,'618151381'),(27433,'BLANCO ','VELASCO ',' GERARDO','BLVG860303B16','pendiente',3,'61882886'),(31759,'CALVO ','CASTILLA ',' AITANA','CACA870223C51','pendiente',3,'6188809'),(32997,'CAMACHO ','ARRATIA ',' AINHOA','CAAA760728C1','pendiente',2,'618888467'),(33183,'BRETADO ','GOMEZ ',' VICTORIA','BRGV750702B36','pendiente',2,'618812088'),(43085,'CAMPOS ','MORAN ',' NORBERTO','CAMN981028C20','pendiente',3,'618897066'),(45091,'CALVO ','URIARTE ',' GABRIEL','CAUG660619U8','pendiente',3,'618127256'),(55959,'CONTRERAS ','DIEZ ',' RAFAEL','CODR631004D45','pendiente',2,'618117282'),(59714,'CRESPO ','GOMEZ ',' NADIA','CRGN760118C28','pendiente',2,'618834828'),(65543,'DE ','OCA ',' ESPINOSA MANUEL','DEEM881018DEE','pendiente',1,'61884995'),(67043,'DE ','OCA ',' NAVARRO AITOR','DENA680814D46','pendiente',1,'618854576'),(71021,'DIEZ ','LLAMAZARES ',' EKAIN','DILE000901D18','pendiente',1,'618869111'),(77565,'DIEZ ','MELGAR ',' JOKIN','DIMJ800803D52','pendiente',3,'618884410'),(80835,'DURAN ','RUIZ ',' ERNESTINA','DURE630911R31','pendiente',4,'618191558'),(86842,'FERNANDEZ ','IGLESIAS ',' IBON','FEII980305F10','pendiente',5,'61889831'),(89760,'FERNANDEZ ','SANTANA ',' OLIVIA','FESO800607FES','pendiente',4,'61882083'),(100948,'GALINDO ','CONTRERAS ',' JOSE','GACJ440211C54','pendiente',3,'618148153'),(107115,'GOMEZ ','ALDRETE ',' ELAIA','GOAE650214G39','pendiente',2,'618823085'),(111627,'GONZALEZ ','GONZALEZ ',' AROA','GOGA601210G9','pendiente',3,'618127923'),(114646,'GUTIERREZ ','DEL ',' TORO HEGOI','GUDH701119D53','pendiente',4,'618147474'),(115666,'GUIJARDO ','CARRILLO ',' ANDRES','GUCA901123G17','pendiente',5,'618830068'),(121205,'GONZALEZ ','SAUCEDA ',' EDUARDO','GOSE540723S34','pendiente',4,'618165808'),(122481,'GUERRERO ','PARRA ',' TOMAS','GUPT720117G12','pendiente',3,'618893427'),(123106,'GUERRERO ','URIARTE ',' LUCIO','GUUL840925G38','pendiente',2,'618812709'),(128764,'HIGUERA ','BOLAÑOS ',' NAIA','HIBN660403H7','pendiente',3,'618836320'),(130842,'HERNANDEZ ','QUINTERO ',' EDUARDO','HEQE670203H14','pendiente',4,'618867290'),(133529,'IGLESIAS ','ALDAMA ',' IAN','IGAI680816I16','pendiente',5,'618812617'),(140210,'JUAREZ ','DIAZ ',' ELISEO','JUDE090523J26','pendiente',4,'61886804'),(142311,'LECHUGA ','DIAZ ',' GUILLERMINA','LEDG000416L40','pendiente',3,'618840508'),(144909,'LEYVA ','SOLIS ',' HUGO','LESH961027L6','pendiente',2,'61887685'),(156164,'MARQUEZ ','BARROSO ',' IMELDA','MABI600709B14','pendiente',3,'618130247'),(162263,'MARISCAL ','JIMENEZ ',' FRANCISCO','MAJF460616J34','pendiente',4,'618192742'),(163261,'MARTIN ','PALACIOS ',' ARHANE','MAPA681212M31','pendiente',5,'618819520'),(164133,'MARIN ','PIÑERA ',' EKAITZ','MAPE660711M28','pendiente',4,'618834997'),(170894,'MARISCAL ','PELUFO ',' OSVALDO','MAPO020910MAP','pendiente',3,'61887020'),(171385,'MARTIN ','VIZCARRA ',' ALEJANDRA','MAVA010818M57','pendiente',2,'618886483'),(172144,'MIGUELEZ ','CAMACHO ',' DANIEL','MICD981120M22','pendiente',1,'618815489'),(184135,'MORALES ','NEGRETE ',' CANDELARIA','MONC640702N8','pendiente',1,'618154365'),(184817,'MOYA ','GALINDO ',' LUR','MOGL670529M0','pendiente',1,'618832888'),(187194,'MORA ','ROJAS ',' IRIA','MORI660831R17','pendiente',1,'618131467'),(216292,'PASCUAL ','VALDERRAMA ',' PAULA','PAVP610302V8','pendiente',1,'6181560'),(223140,'PONCE ','SOLIS ',' MARTINA','POSM420713S49','pendiente',1,'618199930'),(224555,'PIZARRO ','DOMINGUEZ ',' CELIA','PIDC880513P54','pendiente',2,'618885463'),(227774,'RAMIREZ ','BERUMEN ',' IVAN','RABI950226R50','pendiente',3,'6188180'),(228452,'PRIETO ','GURROLA ',' RUBI','PRGR640630G8','pendiente',4,'6181713'),(228695,'PRIETO ','GALLEGO ',' URTZI','PRGU410521G42','pendiente',5,'618169492'),(232664,'RAMOS ','GURROLA ',' TOMAS','RAGT940410R51','pendiente',4,'618828773'),(235574,'ROBLES ','ESTEBAN ',' JESUS','ROEJ910701R18','pendiente',3,'618869204'),(252179,'SANTOS ','ARRATIA ',' LAZARO','SAAL640726A17','pendiente',4,'618184955'),(260186,'SANTIAGO ','PEREZ ',' JOEL','SAPJ900205S2','pendiente',5,'618889082'),(264514,'SORIANAO ','MONTES ',' CLAUDIA','SOMC621026SOM','pendiente',3,'61881602'),(270900,'ULLOA ','PRIETO ',' ARACELI','ULPA710329U6','pendiente',2,'61887723'),(282589,'VALVERDE ','MARIN ',' BERTHA','VAMB790413V10','pendiente',1,'61889682'),(287451,'VELAZQUEZ ','FIDALGO ',' HAIZEA','VEFH100602V3','pendiente',3,'618862468'),(289102,'VILLEGAS ','COLLINS ',' SILVESTRE','VICS640517V3','pendiente',4,'618834254'),(292865,'YESCAS ','NEGRETE ',' LUCIANO','YENL930427Y49','pendiente',2,'618855804'),(301796,'FERNANDEZ ','MARQUEZ ',' IGNACIO','FEMI730203M31','pendiente',5,'6781298577'),(304127,'CALVO ','CONTRERAS ',' MARITZA','CACM760208C33','pendiente',4,'6781300908'),(319417,'PEREZ ','SOLIS ',' GUILLERMO','PESG650302S0','pendiente',3,'6781316198'),(319848,'IGLESIAS ','ALDRETE ',' MARIA DE LA LUZ','IGAM720414A7','pendiente',2,'6781316629'),(325595,'VARGAS ','DEL ',' TORO BEÑAT','VADB610915D14','pendiente',4,'6781322376'),(332465,'FRANCO ','SIFUENTES ',' IRAITZ','FRSI610317S39','pendiente',3,'6781329246'),(334729,'LUNA ','BENITEZ ',' ALEJANDRO','LUBA850824B41','pendiente',4,'6781331510'),(338211,'ALVARADO ','ASTORGA ',' REBECA','ALAR870909A44','pendiente',2,'6781334992'),(342608,'PRIETO ','SIFUENTES ',' ANNE','PRSA861121S53','pendiente',3,'6781339389'),(347725,'MARTIN ','FERNANDEZ ',' JUAN DE DIOS','MAFJ650728F58','pendiente',3,'6781344506'),(349283,'SORIA ','RAMIREZ ',' RAYAN','SORR811106R59','pendiente',3,'6781346064'),(356753,'CASTRO ','LOAIZA ',' ALVARO','CALA730629L10','pendiente',3,'6781353534'),(357452,'MORAL ','PASTOR ',' MIREN','MOPM871220P11','pendiente',2,'6781354233'),(364391,'FUENTES ','GONZALEZ ',' PASCUAL','FUGP850707G20','pendiente',2,'6781361172'),(367092,'FERNANDEZ ','PIZARRO ',' ROBERTO','FEPR790213P22','pendiente',2,'6781363873'),(374471,'CONTRERAS ','PRIETO ',' MARCO','COPM690910P34','pendiente',5,'6781371252'),(375921,'ESTUDILLO ','FERNANDEZ ',' ROSENDO','ESFR860422F36','pendiente',5,'6781372702'),(375954,'MORA ','BRETADO ',' MARINA','MOBM740731B36','pendiente',4,'6781372735');
  77. /*!40000 ALTER TABLE `clientes` ENABLE KEYS */;
  78. UNLOCK TABLES;
  79.  
  80. --
  81. -- Table structure for table `colonias`
  82. --
  83.  
  84. DROP TABLE IF EXISTS `colonias`;
  85. /*!40101 SET @saved_cs_client = @@character_set_client */;
  86. /*!40101 SET character_set_client = utf8 */;
  87. CREATE TABLE `colonias` (
  88. `colonia` int(11) NOT NULL,
  89. `nombre` varchar(60) NOT NULL,
  90. `cpostal` varchar(5) NOT NULL,
  91. PRIMARY KEY (`colonia`)
  92. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  93. /*!40101 SET character_set_client = @saved_cs_client */;
  94.  
  95. --
  96. -- Dumping data for table `colonias`
  97. --
  98.  
  99. LOCK TABLES `colonias` WRITE;
  100. /*!40000 ALTER TABLE `colonias` DISABLE KEYS */;
  101. INSERT INTO `colonias` VALUES (1,'CENTRO','34000'),(2,'COLINAS','34105'),(3,'ESTADOS','34500'),(4,'PRESIDENTES','35900'),(5,'REVOLUCION','34567');
  102. /*!40000 ALTER TABLE `colonias` ENABLE KEYS */;
  103. UNLOCK TABLES;
  104.  
  105. --
  106. -- Table structure for table `departamentos`
  107. --
  108.  
  109. DROP TABLE IF EXISTS `departamentos`;
  110. /*!40101 SET @saved_cs_client = @@character_set_client */;
  111. /*!40101 SET character_set_client = utf8 */;
  112. CREATE TABLE `departamentos` (
  113. `departamento` int(11) NOT NULL,
  114. `nombre` varchar(35) NOT NULL,
  115. PRIMARY KEY (`departamento`)
  116. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  117. /*!40101 SET character_set_client = @saved_cs_client */;
  118.  
  119. --
  120. -- Dumping data for table `departamentos`
  121. --
  122.  
  123. LOCK TABLES `departamentos` WRITE;
  124. /*!40000 ALTER TABLE `departamentos` DISABLE KEYS */;
  125. INSERT INTO `departamentos` VALUES (1,'ACCESORIOS'),(2,'ROPA'),(3,'ZAPATOS');
  126. /*!40000 ALTER TABLE `departamentos` ENABLE KEYS */;
  127. UNLOCK TABLES;
  128.  
  129. --
  130. -- Table structure for table `detalleventaspresenciales`
  131. --
  132.  
  133. DROP TABLE IF EXISTS `detalleventaspresenciales`;
  134. /*!40101 SET @saved_cs_client = @@character_set_client */;
  135. /*!40101 SET character_set_client = utf8 */;
  136. CREATE TABLE `detalleventaspresenciales` (
  137. `noventa` int(11) NOT NULL,
  138. `codigo` varchar(10) NOT NULL,
  139. `cantidad` int(11) NOT NULL,
  140. `precio` int(11) NOT NULL,
  141. `importe` float NOT NULL,
  142. KEY `noventa` (`noventa`),
  143. KEY `codigo` (`codigo`),
  144. CONSTRAINT `detalleventaspresenciales_ibfk_1` FOREIGN KEY (`noventa`) REFERENCES `ventaspresenciales` (`noventa`),
  145. CONSTRAINT `detalleventaspresenciales_ibfk_2` FOREIGN KEY (`codigo`) REFERENCES `productos` (`codigo`)
  146. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  147. /*!40101 SET character_set_client = @saved_cs_client */;
  148.  
  149. --
  150. -- Dumping data for table `detalleventaspresenciales`
  151. --
  152.  
  153. LOCK TABLES `detalleventaspresenciales` WRITE;
  154. /*!40000 ALTER TABLE `detalleventaspresenciales` DISABLE KEYS */;
  155. INSERT INTO `detalleventaspresenciales` VALUES (1,'100102',1,484,484),(1,'200104',1,767,767),(2,'200112',1,330,330),(2,'100100',2,413,826),(3,'300118',1,401,401),(3,'200104',1,767,767),(4,'300102',1,1864,1864),(4,'100104',1,448,448),(5,'100104',2,448,897),(5,'200116',1,342,342),(6,'100102',1,484,484),(6,'300100',1,1829,1829),(7,'200118',1,354,354),(7,'100120',1,270,270),(8,'100102',2,484,968),(8,'200114',1,330,330),(9,'300100',1,1829,1829),(9,'100112',1,531,531),(10,'100100',2,413,826),(10,'200104',2,767,1534),(11,'200108',2,283,566),(11,'100112',1,531,531),(12,'300120',2,1443,2886),(12,'200110',1,289,289),(13,'200114',2,330,661),(13,'300116',2,378,755),(14,'100110',1,401,401),(14,'200102',2,684,1369),(15,'100110',1,401,401),(15,'100116',2,142,283),(16,'300108',2,1640,3280),(16,'200100',2,649,1298),(17,'100116',2,142,283),(17,'300100',1,1829,1829),(18,'200110',1,289,289),(18,'200108',2,283,566),(19,'200102',2,684,1369),(19,'100114',2,588,1175),(20,'100102',1,484,484),(20,'100114',2,588,1175),(21,'200112',1,330,330),(21,'300104',2,1947,3894),(22,'100110',1,401,401),(22,'300110',1,1416,1416),(23,'300118',1,401,401),(23,'300110',1,1416,1416),(24,'100108',1,142,142),(24,'300120',2,1443,2886),(25,'300104',2,1947,3894),(25,'100110',2,401,802),(26,'100108',2,142,283),(26,'300116',2,378,755),(27,'100108',2,142,283),(27,'100102',2,484,968),(28,'100104',2,448,897),(28,'200118',2,354,708),(29,'200118',2,354,708),(29,'200118',1,354,354),(30,'200220',2,342,684),(30,'300118',1,401,401),(31,'300108',1,1640,1640),(31,'100108',1,142,142),(32,'200118',1,354,354),(32,'100104',2,448,897),(33,'300116',2,378,755),(33,'300120',1,1443,1443),(34,'100116',2,142,283),(34,'200114',1,330,330),(35,'100108',1,142,142),(35,'200114',2,330,661),(36,'100110',1,401,401),(36,'300106',2,1416,2832),(37,'100102',2,484,968),(37,'300110',2,1416,2832),(38,'200108',1,283,283),(38,'100104',2,448,897),(39,'200220',1,342,342),(39,'100104',1,448,448),(40,'100120',2,270,540),(40,'300120',2,1443,2886),(41,'300104',2,1947,3894),(41,'200112',2,330,661),(42,'200108',1,283,283),(42,'100110',1,401,401),(43,'300108',2,1640,3280),(43,'300118',2,401,802),(44,'300100',2,1829,3658),(44,'300100',2,1829,3658),(45,'300108',2,1640,3280),(45,'100108',2,142,283),(46,'100114',2,588,1175),(46,'200118',2,354,708),(47,'300122',1,1723,1723),(47,'300102',1,1864,1864),(48,'200114',1,330,330),(48,'100100',1,413,413),(49,'100104',1,448,448),(49,'300118',2,401,802),(50,'100112',2,531,1062),(50,'200116',1,342,342),(51,'200116',2,342,684),(51,'200116',2,342,684),(52,'100118',1,283,283),(52,'300100',1,1829,1829),(53,'100114',1,588,588),(53,'100108',2,142,283),(54,'300100',2,1829,3658),(54,'200116',1,342,342),(55,'100120',2,270,540),(55,'300112',2,661,1322),(56,'200114',1,330,330),(56,'200118',2,354,708),(57,'300108',1,1640,1640),(57,'200102',2,684,1369),(58,'300116',2,378,755),(58,'300104',2,1947,3894),(59,'300112',2,661,1322),(59,'100104',2,448,897),(60,'200118',1,354,354),(60,'200118',2,354,708),(61,'100116',1,142,142),(61,'300120',2,1443,2886),(62,'200102',2,684,1369),(62,'300122',2,1723,3446),(63,'100120',2,270,540),(63,'200118',1,354,354),(64,'300118',2,401,802),(64,'300110',1,1416,1416),(65,'100100',2,413,826),(65,'100102',1,484,484),(66,'200220',2,342,684),(66,'100112',1,531,531),(67,'100114',1,588,588),(67,'300112',2,661,1322),(68,'200112',2,330,661),(68,'200102',1,684,684),(69,'100106',2,413,826),(69,'100114',1,588,588),(70,'100116',1,142,142),(70,'200114',2,330,661),(71,'100106',1,413,413),(71,'300106',1,1416,1416),(72,'100102',2,484,968),(72,'300112',2,661,1322),(73,'300104',1,1947,1947),(73,'300108',1,1640,1640),(74,'200102',2,684,1369),(74,'100118',1,283,283),(75,'300118',1,401,401),(75,'200112',2,330,661),(76,'300114',2,944,1888),(76,'200106',1,378,378),(77,'200118',2,354,708),(77,'300120',2,1443,2886),(78,'100112',2,531,1062),(78,'200100',1,649,649),(79,'200110',1,289,289),(79,'100120',1,270,270),(80,'100112',2,531,1062),(80,'300122',2,1723,3446),(81,'100114',1,588,588),(81,'100108',1,142,142),(82,'100108',1,142,142),(82,'200100',1,649,649),(83,'300108',2,1640,3280),(83,'200110',1,289,289),(84,'200220',2,342,684),(84,'200100',1,649,649),(85,'300108',2,1640,3280),(85,'300114',1,944,944),(86,'200110',1,289,289),(86,'200118',1,354,354),(87,'300116',2,378,755),(87,'300122',2,1723,3446),(88,'300120',1,1443,1443),(88,'300116',2,378,755),(89,'300112',1,661,661),(89,'300104',1,1947,1947),(90,'100116',2,142,283),(90,'300120',1,1443,1443),(91,'100120',1,270,270),(91,'300114',2,944,1888),(92,'300112',2,661,1322),(92,'100106',1,413,413),(93,'200102',1,684,684),(93,'100120',1,270,270),(94,'300106',1,1416,1416),(94,'100114',1,588,588),(95,'300104',1,1947,1947),(95,'100120',1,270,270),(96,'200112',1,330,330),(96,'200104',2,767,1534),(97,'200116',2,342,684),(97,'100106',2,413,826),(98,'300120',2,1443,2886),(98,'200110',2,289,578),(99,'100114',2,588,1175),(99,'200106',2,378,755),(100,'300114',1,944,944),(100,'300118',2,401,802),(101,'200108',2,283,566),(101,'300118',2,401,802),(102,'100104',2,448,897),(102,'300116',1,378,378),(103,'100110',2,401,802),(103,'300110',2,1416,2832),(104,'200220',2,342,684),(104,'300100',2,1829,3658),(105,'300120',1,1443,1443),(105,'200108',1,283,283),(106,'300122',2,1723,3446),(106,'100116',1,142,142),(107,'100104',1,448,448),(107,'200114',2,330,661),(108,'100110',1,401,401),(108,'300108',2,1640,3280),(109,'200100',1,649,649),(109,'100120',1,270,270),(110,'300106',2,1416,2832),(110,'200102',2,684,1369),(111,'300106',1,1416,1416),(111,'300104',2,1947,3894),(112,'100108',1,142,142),(112,'300100',1,1829,1829),(113,'300108',1,1640,1640),(113,'200112',1,330,330),(114,'100120',2,270,540),(114,'300122',1,1723,1723),(115,'300108',1,1640,1640),(115,'300100',1,1829,1829),(116,'200220',1,342,342),(116,'300100',1,1829,1829),(117,'300100',2,1829,3658),(117,'300108',2,1640,3280),(118,'100114',1,588,588),(118,'100108',2,142,283),(119,'300122',2,1723,3446),(119,'300108',2,1640,3280),(120,'300104',1,1947,1947),(120,'100118',1,283,283),(121,'300116',1,378,378),(121,'200104',2,767,1534),(122,'100112',2,531,1062),(122,'300100',1,1829,1829),(123,'300112',1,661,661),(123,'100108',2,142,283),(124,'100104',2,448,897),(124,'100102',1,484,484),(125,'300100',2,1829,3658),(125,'200102',1,684,684),(126,'300102',1,1864,1864),(126,'100116',1,142,142),(127,'200108',2,283,566),(127,'200102',2,684,1369),(128,'300100',2,1829,3658),(128,'300116',2,378,755),(129,'200118',2,354,708),(129,'300100',2,1829,3658),(130,'300106',1,1416,1416),(130,'100112',2,531,1062),(131,'200104',2,767,1534),(131,'300118',1,401,401),(132,'100110',1,401,401),(132,'200116',1,342,342),(133,'100120',2,270,540),(133,'200114',1,330,330),(134,'200114',1,330,330),(134,'300104',1,1947,1947),(135,'300118',1,401,401),(135,'100112',1,531,531),(136,'300108',1,1640,1640),(136,'300106',2,1416,2832),(137,'300108',1,1640,1640),(137,'100100',2,413,826),(138,'300122',1,1723,1723),(138,'100114',1,588,588),(139,'300114',1,944,944),(139,'100102',1,484,484),(140,'200118',1,354,354),(140,'200112',1,330,330),(141,'200102',2,684,1369),(141,'100108',1,142,142),(142,'100102',1,484,484),(142,'300102',2,1864,3729),(143,'200112',2,330,661),(143,'200114',2,330,661),(144,'300104',2,1947,3894),(144,'300102',1,1864,1864),(145,'100118',1,283,283),(145,'100116',2,142,283),(146,'300108',2,1640,3280),(146,'200118',1,354,354),(147,'200106',2,378,755),(147,'100114',2,588,1175),(148,'300102',2,1864,3729),(148,'200112',1,330,330),(149,'200116',1,342,342),(149,'300106',1,1416,1416),(150,'100102',2,484,968),(150,'300100',2,1829,3658),(151,'200110',2,289,578),(151,'200104',2,767,1534),(152,'300114',1,944,944),(152,'300118',2,401,802),(153,'100108',1,142,142),(153,'200106',1,378,378),(154,'300106',2,1416,2832),(154,'300114',2,944,1888),(155,'300114',2,944,1888),(155,'200102',2,684,1369),(156,'300118',1,401,401),(156,'300104',2,1947,3894),(157,'200100',2,649,1298),(157,'200102',2,684,1369),(158,'100110',1,401,401),(158,'100104',1,448,448),(159,'300100',2,1829,3658),(159,'200102',2,684,1369),(160,'100118',1,283,283),(160,'100110',1,401,401),(161,'200110',2,289,578),(161,'300104',1,1947,1947),(162,'300112',2,661,1322),(162,'100104',1,448,448),(163,'300110',2,1416,2832),(163,'300108',2,1640,3280),(164,'200102',2,684,1369),(164,'200116',2,342,684),(165,'200114',2,330,661),(165,'200108',2,283,566),(166,'100108',2,142,283),(166,'200100',2,649,1298),(167,'300108',1,1640,1640),(167,'200102',2,684,1369),(168,'300104',1,1947,1947),(168,'200102',2,684,1369),(169,'100106',2,413,826),(169,'100108',1,142,142),(170,'200108',2,283,566),(170,'200102',2,684,1369),(171,'100104',1,448,448),(171,'100120',1,270,270),(172,'100106',1,413,413),(172,'200100',2,649,1298),(173,'300106',2,1416,2832),(173,'200118',2,354,708),(174,'300106',2,1416,2832),(174,'100116',2,142,283),(175,'100106',2,413,826),(175,'300104',1,1947,1947),(176,'300106',1,1416,1416),(176,'300100',2,1829,3658),(177,'100106',2,413,826),(177,'300106',1,1416,1416),(178,'300114',1,944,944),(178,'300122',1,1723,1723),(179,'300102',2,1864,3729),(179,'300110',2,1416,2832),(180,'200116',1,342,342),(180,'300112',2,661,1322),(181,'200220',2,342,684),(181,'200114',2,330,661),(182,'200220',2,342,684),(182,'300110',2,1416,2832),(183,'300100',1,1829,1829),(183,'200108',2,283,566),(184,'100118',1,283,283),(184,'100118',2,283,566),(185,'300118',2,401,802),(185,'100114',1,588,588),(186,'100106',2,413,826),(186,'100116',1,142,142),(187,'300112',1,661,661),(187,'300102',2,1864,3729),(188,'300122',1,1723,1723),(188,'200108',2,283,566),(189,'200106',2,378,755),(189,'200108',1,283,283),(190,'300106',2,1416,2832),(190,'300102',2,1864,3729),(191,'300120',1,1443,1443),(191,'100108',1,142,142),(192,'300122',2,1723,3446),(192,'300108',2,1640,3280),(193,'100100',1,413,413),(193,'100106',2,413,826),(194,'200110',2,289,578),(194,'300116',2,378,755),(195,'300104',2,1947,3894),(195,'100118',1,283,283),(196,'300116',2,378,755),(196,'200108',2,283,566),(197,'300100',2,1829,3658),(197,'200108',2,283,566),(198,'100102',1,484,484),(198,'300110',1,1416,1416),(199,'200102',2,684,1369),(199,'100118',2,283,566),(200,'100116',1,142,142),(200,'300120',1,1443,1443),(201,'100116',2,142,283),(201,'200106',1,378,378),(202,'200102',1,684,684),(202,'100110',1,401,401),(203,'300122',2,1723,3446),(203,'100120',1,270,270),(204,'200100',1,649,649),(204,'300108',2,1640,3280),(205,'300106',2,1416,2832),(205,'100102',1,484,484),(206,'300110',2,1416,2832),(206,'300100',1,1829,1829),(207,'300118',2,401,802),(207,'100116',1,142,142),(208,'100106',2,413,826),(208,'100116',1,142,142),(209,'100110',1,401,401),(209,'200114',1,330,330),(210,'100114',1,588,588),(210,'300106',1,1416,1416),(211,'300122',1,1723,1723),(211,'300110',2,1416,2832),(212,'300114',1,944,944),(212,'200118',2,354,708),(213,'300102',2,1864,3729),(213,'300110',1,1416,1416),(214,'300114',2,944,1888),(214,'300110',1,1416,1416),(215,'300108',2,1640,3280),(215,'200100',1,649,649),(216,'200102',2,684,1369),(216,'200100',2,649,1298),(217,'100114',2,588,1175),(217,'300104',1,1947,1947),(218,'200220',1,342,342),(218,'300108',2,1640,3280),(219,'100116',2,142,283),(219,'300120',1,1443,1443),(220,'300120',2,1443,2886),(220,'100106',1,413,413),(221,'100116',1,142,142),(221,'300104',1,1947,1947),(222,'300112',1,661,661),(222,'200116',1,342,342),(223,'200110',1,289,289),(223,'300100',1,1829,1829),(224,'200116',1,342,342),(224,'300102',1,1864,1864),(225,'100110',1,401,401),(225,'300122',2,1723,3446),(226,'200100',1,649,649),(226,'100100',2,413,826),(227,'300122',2,1723,3446),(227,'300118',2,401,802),(228,'300118',1,401,401),(228,'100106',1,413,413),(229,'100100',2,413,826),(229,'100112',2,531,1062),(230,'100120',1,270,270),(230,'300120',1,1443,1443),(231,'100112',1,531,531),(231,'100118',2,283,566),(232,'200100',2,649,1298),(232,'200102',2,684,1369),(233,'300114',2,944,1888),(233,'100106',2,413,826),(234,'100114',1,588,588),(234,'300108',2,1640,3280),(235,'100106',1,413,413),(235,'100120',1,270,270),(236,'300122',1,1723,1723),(236,'100102',2,484,968),(237,'200104',1,767,767),(237,'100106',1,413,413),(238,'200106',1,378,378),(238,'200220',2,342,684),(239,'200100',2,649,1298),(239,'300110',2,1416,2832),(240,'200104',1,767,767),(240,'100100',2,413,826),(241,'300102',1,1864,1864),(241,'100106',2,413,826),(242,'200104',1,767,767),(242,'200116',1,342,342),(243,'100106',2,413,826),(243,'100114',2,588,1175),(244,'100106',1,413,413),(244,'100110',2,401,802),(245,'300108',2,1640,3280),(245,'300116',2,378,755),(246,'200118',1,354,354),(246,'300118',1,401,401),(247,'200100',2,649,1298),(247,'300120',2,1443,2886),(248,'300120',1,1443,1443),(248,'100110',2,401,802),(249,'300110',2,1416,2832),(249,'100116',1,142,142),(250,'200112',2,330,661),(250,'300118',2,401,802),(251,'300112',2,661,1322),(251,'200116',2,342,684),(252,'200104',1,767,767),(252,'300114',1,944,944),(253,'100108',2,142,283),(253,'300120',1,1443,1443),(254,'100100',1,413,413),(254,'300100',2,1829,3658),(255,'200104',2,767,1534),(255,'200106',2,378,755),(256,'200104',2,767,1534),(256,'200114',2,330,661),(257,'100120',2,270,540),(257,'100118',2,283,566),(258,'200110',2,289,578),(258,'200114',1,330,330),(259,'300122',2,1723,3446),(259,'100110',1,401,401),(260,'200220',2,342,684),(260,'100104',2,448,897),(261,'100108',2,142,283),(261,'100108',2,142,283),(262,'200110',1,289,289),(262,'200110',1,289,289),(263,'300120',2,1443,2886),(263,'300120',2,1443,2886),(264,'300120',1,1443,1443),(264,'200118',1,354,354),(265,'300118',2,401,802),(265,'100112',2,531,1062),(266,'300120',2,1443,2886),(266,'100120',1,270,270),(267,'100104',1,448,448),(267,'300102',1,1864,1864),(268,'300112',1,661,661),(268,'300122',1,1723,1723),(269,'200112',2,330,661),(269,'300120',1,1443,1443),(270,'100102',2,484,968),(270,'100108',1,142,142),(271,'200100',1,649,649),(271,'100118',1,283,283),(272,'300102',1,1864,1864),(272,'100108',2,142,283),(273,'300110',1,1416,1416),(273,'200100',1,649,649),(274,'100108',2,142,283),(274,'300100',1,1829,1829),(275,'100108',1,142,142),(275,'300110',1,1416,1416),(276,'200112',2,330,661),(276,'200102',1,684,684),(277,'200102',1,684,684),(277,'200220',1,342,342),(278,'200116',2,342,684),(278,'200110',1,289,289),(279,'300108',1,1640,1640),(279,'200108',2,283,566),(280,'200116',1,342,342),(280,'300114',1,944,944),(281,'200110',1,289,289),(281,'100118',2,283,566),(282,'300104',1,1947,1947),(282,'300118',2,401,802),(283,'200108',1,283,283),(283,'300104',1,1947,1947),(284,'200102',1,684,684),(284,'200102',1,684,684),(285,'200116',2,342,684),(285,'200102',2,684,1369),(286,'200118',2,354,708),(286,'100108',2,142,283),(287,'300100',2,1829,3658),(287,'300100',1,1829,1829),(288,'100106',1,413,413),(288,'200118',2,354,708),(289,'100116',1,142,142),(289,'300120',1,1443,1443),(290,'100116',1,142,142),(290,'200104',2,767,1534),(291,'100108',2,142,283),(291,'200100',2,649,1298),(292,'300122',1,1723,1723),(292,'100102',1,484,484),(293,'100108',2,142,283),(293,'300110',1,1416,1416),(294,'300104',2,1947,3894),(294,'300104',2,1947,3894),(295,'100118',2,283,566),(295,'200118',1,354,354),(296,'100102',2,484,968),(296,'200112',1,330,330),(297,'200114',2,330,661),(297,'100118',2,283,566),(298,'300106',2,1416,2832),(298,'200116',2,342,684),(299,'200104',2,767,1534),(299,'200116',1,342,342),(300,'300122',2,1723,3446),(300,'200110',1,289,289),(301,'300120',1,1443,1443),(301,'300116',2,378,755),(302,'200112',2,330,661),(302,'100118',2,283,566),(303,'300112',2,661,1322),(303,'100118',1,283,283),(304,'100100',2,413,826),(304,'300110',1,1416,1416),(305,'100104',1,448,448),(305,'300112',1,661,661),(306,'200220',1,342,342),(306,'300120',2,1443,2886),(307,'200104',2,767,1534),(307,'300110',1,1416,1416),(308,'200110',2,289,578),(308,'100100',1,413,413),(309,'100110',2,401,802),(309,'100104',2,448,897),(310,'200110',2,289,578),(310,'300120',2,1443,2886),(311,'300110',2,1416,2832),(311,'200220',1,342,342),(312,'100120',2,270,540),(312,'300118',2,401,802),(313,'200116',2,342,684),(313,'100102',1,484,484),(314,'200102',1,684,684),(314,'100106',1,413,413),(315,'200100',1,649,649),(315,'200116',2,342,684),(316,'300120',2,1443,2886),(316,'200110',1,289,289),(317,'200108',1,283,283),(317,'300112',2,661,1322),(318,'300102',1,1864,1864),(318,'100100',2,413,826),(319,'300110',2,1416,2832),(319,'200116',2,342,684),(320,'200112',2,330,661),(320,'300114',2,944,1888),(321,'300114',2,944,1888),(321,'100104',1,448,448),(322,'300102',1,1864,1864),(322,'200106',2,378,755),(323,'100104',1,448,448),(323,'300114',1,944,944),(324,'100100',1,413,413),(324,'200112',2,330,661),(325,'300100',2,1829,3658),(325,'300120',1,1443,1443),(326,'200114',2,330,661),(326,'300122',1,1723,1723),(327,'300100',1,1829,1829),(327,'300122',2,1723,3446),(328,'300112',2,661,1322),(328,'200110',2,289,578),(329,'100118',2,283,566),(329,'300118',2,401,802),(330,'100100',1,413,413),(330,'200118',2,354,708),(331,'100104',1,448,448),(331,'300110',2,1416,2832),(332,'200104',1,767,767),(332,'300120',2,1443,2886),(333,'200108',1,283,283),(333,'200220',1,342,342),(334,'200118',1,354,354),(334,'100116',2,142,283),(335,'300102',1,1864,1864),(335,'100100',1,413,413),(336,'200110',2,289,578),(336,'100108',2,142,283),(337,'100106',1,413,413),(337,'200118',2,354,708),(338,'200114',1,330,330),(338,'100112',2,531,1062),(339,'300120',2,1443,2886),(339,'100108',2,142,283),(340,'300118',1,401,401),(340,'300114',1,944,944),(341,'300112',2,661,1322),(341,'300120',2,1443,2886),(342,'100100',1,413,413),(342,'200220',2,342,684),(343,'300116',1,378,378),(343,'100118',1,283,283),(344,'300100',2,1829,3658),(344,'200118',1,354,354),(345,'200108',1,283,283),(345,'100108',2,142,283),(346,'200114',2,330,661),(346,'100102',1,484,484),(347,'200220',2,342,684),(347,'300120',2,1443,2886),(348,'100114',1,588,588),(348,'300114',1,944,944),(349,'100106',2,413,826),(349,'300110',2,1416,2832),(350,'300106',2,1416,2832),(350,'200106',2,378,755),(351,'300118',1,401,401),(351,'300106',2,1416,2832),(352,'200108',1,283,283),(352,'300122',2,1723,3446),(353,'200102',2,684,1369),(353,'100116',1,142,142),(354,'200102',2,684,1369),(354,'200100',1,649,649),(355,'100100',2,413,826),(355,'100114',1,588,588),(356,'100110',1,401,401),(356,'100106',1,413,413),(357,'100106',2,413,826),(357,'300120',1,1443,1443),(358,'200118',1,354,354),(358,'200112',1,330,330),(359,'200220',2,342,684),(359,'200118',2,354,708),(360,'300116',1,378,378),(360,'300116',2,378,755),(361,'300104',1,1947,1947),(361,'200102',1,684,684),(362,'300100',2,1829,3658),(362,'200108',1,283,283),(363,'200104',2,767,1534),(363,'200116',1,342,342),(364,'300120',2,1443,2886),(364,'300108',1,1640,1640),(365,'100114',1,588,588),(365,'300114',2,944,1888),(366,'300118',2,401,802),(366,'200118',2,354,708),(367,'300108',1,1640,1640),(367,'300120',2,1443,2886),(368,'300104',1,1947,1947),(368,'300116',2,378,755),(369,'300122',1,1723,1723),(369,'200220',1,342,342),(370,'100116',1,142,142),(370,'100116',1,142,142),(371,'100100',1,413,413),(371,'300100',2,1829,3658),(372,'100114',2,588,1175),(372,'300112',2,661,1322),(373,'300108',1,1640,1640),(373,'200110',1,289,289),(374,'300106',1,1416,1416),(374,'200114',2,330,661),(375,'300120',1,1443,1443),(375,'200220',1,342,342),(376,'200100',1,649,649),(376,'200112',2,330,661),(377,'100106',2,413,826),(377,'100110',2,401,802),(378,'200108',2,283,566),(379,'200220',2,342,684),(380,'200106',1,378,378),(381,'100102',1,484,484),(382,'100110',2,401,802),(383,'200108',2,283,566),(384,'300120',1,1443,1443),(385,'100120',1,270,270),(386,'100100',2,413,826),(387,'100114',1,588,588),(388,'300100',2,1829,3658),(389,'200100',2,649,1298),(390,'200114',1,330,330),(391,'300116',2,378,755),(392,'300106',1,1416,1416),(393,'200104',1,767,767),(394,'200220',2,342,684),(395,'200100',2,649,1298),(396,'200220',1,342,342),(397,'300106',1,1416,1416),(398,'300118',2,401,802),(399,'100100',1,413,413),(400,'300114',1,944,944),(401,'100114',1,588,588),(402,'100108',2,142,283),(403,'300112',2,661,1322),(404,'100116',2,142,283),(405,'200114',2,330,661),(406,'300114',1,944,944),(407,'100102',1,484,484),(408,'100118',1,283,283),(409,'100100',1,413,413),(410,'100118',2,283,566),(411,'300108',1,1640,1640),(412,'200220',2,342,684),(413,'200114',1,330,330),(414,'300112',2,661,1322),(415,'300122',1,1723,1723),(416,'100118',1,283,283),(417,'300112',2,661,1322),(418,'100110',2,401,802),(419,'200114',2,330,661),(420,'200118',1,354,354),(421,'100118',1,283,283),(422,'300114',2,944,1888),(423,'100116',2,142,283),(424,'100118',2,283,566),(425,'200118',2,354,708),(426,'100112',2,531,1062),(427,'200114',2,330,661),(428,'100106',1,413,413),(429,'300122',2,1723,3446),(430,'300104',2,1947,3894),(431,'200106',1,378,378),(432,'300110',1,1416,1416),(433,'100112',1,531,531),(434,'200102',1,684,684),(435,'300116',2,378,755),(436,'200220',2,342,684),(437,'300102',2,1864,3729);
  156. /*!40000 ALTER TABLE `detalleventaspresenciales` ENABLE KEYS */;
  157. UNLOCK TABLES;
  158.  
  159. --
  160. -- Table structure for table `detalleventasvirtuales`
  161. --
  162.  
  163. DROP TABLE IF EXISTS `detalleventasvirtuales`;
  164. /*!40101 SET @saved_cs_client = @@character_set_client */;
  165. /*!40101 SET character_set_client = utf8 */;
  166. CREATE TABLE `detalleventasvirtuales` (
  167. `noventa` int(11) NOT NULL,
  168. `codigo` varchar(10) NOT NULL,
  169. `cantidad` int(11) NOT NULL,
  170. `precio` int(11) NOT NULL,
  171. `importe` float NOT NULL,
  172. KEY `noventa` (`noventa`),
  173. KEY `codigo` (`codigo`),
  174. CONSTRAINT `detalleventasvirtuales_ibfk_1` FOREIGN KEY (`noventa`) REFERENCES `ventasvirtuales` (`noventa`),
  175. CONSTRAINT `detalleventasvirtuales_ibfk_2` FOREIGN KEY (`codigo`) REFERENCES `productos` (`codigo`)
  176. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  177. /*!40101 SET character_set_client = @saved_cs_client */;
  178.  
  179. --
  180. -- Dumping data for table `detalleventasvirtuales`
  181. --
  182.  
  183. LOCK TABLES `detalleventasvirtuales` WRITE;
  184. /*!40000 ALTER TABLE `detalleventasvirtuales` DISABLE KEYS */;
  185. INSERT INTO `detalleventasvirtuales` VALUES (100,'100102',1,780,780),(100,'200102',2,678,1356),(101,'100104',2,890,1780),(101,'200104',3,980,2940),(102,'100104',1,900,900),(103,'100100',1,920,920),(104,'100104',1,900,900),(104,'200104',3,980,2940),(105,'100100',3,920,2760),(106,'300102',1,780,780),(106,'300104',3,875,2625),(107,'300100',1,890,890),(108,'300102',1,870,870),(109,'300102',2,1864,3729),(109,'200112',2,330,661),(110,'200102',1,684,684),(110,'200112',2,330,661),(111,'200102',2,684,1369),(111,'300106',1,1416,1416),(112,'100102',2,484,968),(112,'300114',2,944,1888),(113,'200102',1,684,684),(113,'100118',1,283,283),(114,'200106',2,378,755),(114,'300120',1,1443,1443),(115,'300106',1,1416,1416),(115,'200104',2,767,1534),(116,'200110',2,289,578),(116,'100118',2,283,566),(117,'200110',2,289,578),(117,'200100',1,649,649),(118,'100106',1,413,413),(118,'100102',1,484,484),(119,'300120',2,1443,2886),(119,'100108',2,142,283),(120,'300122',2,1723,3446),(120,'100116',2,142,283),(121,'300100',2,1829,3658),(121,'200108',2,283,566),(122,'300102',1,1864,1864),(122,'200116',1,342,342),(123,'300114',1,944,944),(123,'200104',1,767,767),(124,'300118',2,401,802),(124,'200112',1,330,330),(125,'200100',1,649,649),(125,'300110',2,1416,2832),(126,'100110',1,401,401),(126,'200116',1,342,342),(127,'100116',1,142,142),(127,'200118',2,354,708),(128,'300110',1,1416,1416),(128,'200100',1,649,649),(129,'100106',1,413,413),(129,'300120',2,1443,2886),(130,'300108',2,1640,3280),(130,'100116',2,142,283),(131,'100100',1,413,413),(131,'200104',1,767,767),(132,'100112',1,531,531),(132,'300122',1,1723,1723),(133,'200102',1,684,684),(133,'200114',2,330,661),(134,'100108',2,142,283),(134,'200106',1,378,378),(135,'200100',2,649,1298),(135,'200220',2,342,684),(136,'300120',2,1443,2886),(136,'100112',1,531,531),(137,'200104',1,767,767),(137,'100104',1,448,448),(138,'300104',1,1947,1947),(138,'300110',2,1416,2832),(139,'300118',1,401,401),(139,'200108',1,283,283),(140,'100104',1,448,448),(140,'300108',2,1640,3280),(141,'100100',2,413,826),(141,'300112',2,661,1322),(142,'100102',1,484,484),(142,'200112',1,330,330),(143,'100100',2,413,826),(143,'100110',1,401,401),(144,'300102',2,1864,3729),(144,'300102',1,1864,1864),(145,'300100',2,1829,3658),(145,'100106',1,413,413),(146,'100120',1,270,270),(146,'300110',2,1416,2832),(147,'200114',2,330,661),(147,'300108',2,1640,3280),(148,'200108',1,283,283),(148,'100100',2,413,826),(149,'100108',2,142,283),(149,'300100',2,1829,3658),(150,'300122',2,1723,3446),(150,'100110',2,401,802),(151,'100110',2,401,802),(151,'100110',2,401,802),(152,'200106',1,378,378),(152,'300110',2,1416,2832),(153,'300106',2,1416,2832),(153,'200118',1,354,354),(154,'200116',1,342,342),(154,'100106',1,413,413),(155,'100120',2,270,540),(155,'300106',1,1416,1416),(156,'100100',1,413,413),(156,'200110',2,289,578),(157,'200114',1,330,330),(157,'200118',2,354,708),(158,'100106',1,413,413),(158,'200114',1,330,330),(159,'300106',2,1416,2832),(159,'200106',2,378,755),(160,'300120',2,1443,2886),(160,'100102',1,484,484),(161,'300120',2,1443,2886),(161,'200114',2,330,661),(162,'300118',1,401,401),(162,'100102',2,484,968),(163,'200112',1,330,330),(163,'100118',2,283,566),(164,'200112',2,330,661),(164,'100104',1,448,448),(165,'300104',2,1947,3894),(165,'200116',2,342,684),(166,'100102',1,484,484),(166,'300118',1,401,401),(167,'200108',1,283,283),(167,'300106',2,1416,2832),(168,'100112',1,531,531),(168,'100116',2,142,283),(169,'200100',2,649,1298),(169,'100102',1,484,484),(170,'200108',1,283,283),(170,'300110',1,1416,1416),(171,'100100',1,413,413),(171,'200110',2,289,578),(172,'100108',1,142,142),(172,'300120',1,1443,1443),(173,'100108',1,142,142),(173,'200116',2,342,684),(174,'300106',2,1416,2832),(174,'300100',1,1829,1829),(175,'200220',2,342,684),(175,'300104',2,1947,3894),(176,'300112',1,661,661),(176,'300104',1,1947,1947),(177,'300114',2,944,1888),(177,'200102',1,684,684),(178,'300110',2,1416,2832),(178,'300100',1,1829,1829),(179,'200114',1,330,330),(179,'200102',1,684,684),(180,'300100',2,1829,3658),(180,'100110',2,401,802),(181,'100106',2,413,826),(181,'100116',1,142,142),(182,'200106',2,378,755),(182,'200104',1,767,767),(183,'200118',1,354,354),(183,'200104',2,767,1534),(184,'200112',1,330,330),(184,'100104',2,448,897),(185,'300120',2,1443,2886),(185,'300116',1,378,378),(186,'300116',1,378,378),(186,'100114',2,588,1175),(187,'100116',2,142,283),(187,'300120',1,1443,1443),(188,'100118',1,283,283),(188,'100102',1,484,484),(189,'300100',1,1829,1829),(189,'200102',2,684,1369),(190,'300100',1,1829,1829),(190,'200114',1,330,330),(191,'200118',2,354,708),(191,'300100',2,1829,3658),(192,'200102',1,684,684),(192,'300108',1,1640,1640),(193,'100114',1,588,588),(193,'300102',1,1864,1864),(194,'300100',2,1829,3658),(194,'300116',2,378,755),(195,'300106',2,1416,2832),(195,'300110',2,1416,2832),(196,'300104',2,1947,3894),(196,'300114',2,944,1888),(197,'300110',1,1416,1416),(197,'200112',1,330,330),(198,'200102',1,684,684),(198,'100120',2,270,540),(199,'100114',1,588,588),(199,'200118',1,354,354),(200,'100114',1,588,588),(200,'300102',1,1864,1864),(201,'200220',1,342,342),(201,'100112',1,531,531),(202,'300114',2,944,1888),(202,'200100',2,649,1298),(203,'200118',1,354,354),(203,'100120',1,270,270),(204,'100104',2,448,897),(204,'100110',2,401,802),(205,'300118',2,401,802),(205,'300106',1,1416,1416),(206,'300108',2,1640,3280),(206,'200112',1,330,330),(207,'300120',1,1443,1443),(207,'200100',1,649,649),(208,'200104',1,767,767),(208,'200220',1,342,342),(209,'200116',2,342,684),(209,'300122',1,1723,1723),(210,'100118',2,283,566),(210,'200110',2,289,578),(211,'100114',1,588,588),(211,'300112',2,661,1322),(212,'200220',2,342,684),(212,'300122',2,1723,3446),(213,'300122',2,1723,3446),(213,'200116',2,342,684),(214,'200220',1,342,342),(214,'200220',1,342,342),(215,'100110',1,401,401),(215,'200118',2,354,708),(216,'100112',1,531,531),(216,'300114',2,944,1888),(217,'200104',1,767,767),(217,'100104',1,448,448),(218,'300114',2,944,1888),(218,'200118',1,354,354),(219,'200118',2,354,708),(219,'200220',2,342,684),(220,'200104',2,767,1534),(220,'100120',2,270,540),(221,'300102',1,1864,1864),(221,'100102',2,484,968),(222,'200108',1,283,283),(222,'200102',1,684,684),(223,'200104',2,767,1534),(223,'200118',2,354,708),(224,'100110',2,401,802),(224,'200110',1,289,289),(225,'200110',1,289,289),(225,'300120',1,1443,1443),(226,'300116',1,378,378),(226,'100108',2,142,283),(227,'100108',1,142,142),(227,'300110',1,1416,1416),(228,'200116',2,342,684),(228,'100100',2,413,826),(229,'300100',1,1829,1829),(229,'100100',2,413,826),(230,'100110',2,401,802),(230,'300122',1,1723,1723),(231,'200100',1,649,649),(231,'100108',2,142,283),(232,'300120',1,1443,1443),(232,'200220',2,342,684),(233,'300118',2,401,802),(233,'100110',2,401,802),(234,'300108',1,1640,1640),(234,'300110',2,1416,2832),(235,'200110',1,289,289),(235,'300118',2,401,802),(236,'100100',2,413,826),(236,'200110',1,289,289),(237,'100100',2,413,826),(237,'300118',1,401,401),(238,'300104',2,1947,3894),(238,'100106',1,413,413),(239,'300104',2,1947,3894),(239,'100120',2,270,540),(240,'100120',2,270,540),(240,'300106',1,1416,1416),(241,'200106',2,378,755),(241,'300106',2,1416,2832),(242,'100102',2,484,968),(242,'100104',1,448,448),(243,'300122',2,1723,3446),(243,'100112',2,531,1062),(244,'100120',1,270,270),(244,'200110',2,289,578),(245,'300122',1,1723,1723),(245,'300102',1,1864,1864),(246,'300120',2,1443,2886),(246,'300120',2,1443,2886),(247,'300118',1,401,401),(247,'300110',1,1416,1416),(248,'100102',2,484,968),(248,'200220',1,342,342),(249,'200118',2,354,708),(249,'100106',2,413,826),(250,'200108',2,283,566),(250,'300106',1,1416,1416),(251,'100106',1,413,413),(251,'100112',2,531,1062),(252,'100110',1,401,401),(252,'300106',1,1416,1416),(253,'300102',1,1864,1864),(253,'100114',1,588,588),(254,'300110',1,1416,1416),(254,'100106',1,413,413),(255,'100100',1,413,413),(255,'100116',1,142,142),(256,'300116',1,378,378),(256,'100118',2,283,566),(257,'100102',1,484,484),(257,'300122',1,1723,1723),(258,'100114',1,588,588),(258,'200100',1,649,649),(259,'300120',1,1443,1443),(259,'200114',2,330,661),(260,'200112',1,330,330),(260,'200112',2,330,661),(261,'100116',2,142,283),(261,'100110',2,401,802),(262,'200118',2,354,708),(262,'200106',1,378,378),(263,'200104',2,767,1534),(263,'200110',2,289,578),(264,'300118',2,401,802),(264,'100100',2,413,826),(265,'300118',2,401,802),(265,'100102',2,484,968),(266,'100118',2,283,566),(266,'300106',1,1416,1416),(267,'200106',1,378,378),(267,'300110',1,1416,1416),(268,'200220',2,342,684),(268,'200118',2,354,708),(269,'200116',2,342,684),(269,'100112',2,531,1062),(270,'300120',1,1443,1443),(270,'300122',1,1723,1723),(271,'100118',2,283,566),(271,'200114',2,330,661),(272,'300110',2,1416,2832),(272,'300120',2,1443,2886),(273,'100112',1,531,531),(273,'100104',2,448,897),(274,'100106',2,413,826),(274,'200104',1,767,767),(275,'300104',1,1947,1947),(275,'300108',1,1640,1640),(276,'300108',1,1640,1640),(276,'300108',2,1640,3280),(277,'200114',2,330,661),(277,'300100',2,1829,3658),(278,'100100',1,413,413),(278,'100112',2,531,1062),(279,'300112',2,661,1322),(279,'100116',2,142,283),(280,'300118',1,401,401),(280,'200102',1,684,684),(281,'200102',2,684,1369),(281,'300112',1,661,661),(282,'200108',2,283,566),(282,'200106',2,378,755),(283,'200108',1,283,283),(283,'100110',1,401,401),(284,'100112',1,531,531),(284,'300120',2,1443,2886),(285,'200220',1,342,342),(285,'100106',1,413,413),(285,'100118',1,283,283),(286,'200112',1,330,330),(286,'300118',1,401,401),(286,'200102',1,684,684),(287,'200110',1,289,289),(287,'200112',2,330,661),(287,'100104',2,448,897),(288,'100112',2,531,1062),(288,'100102',2,484,968),(288,'300108',2,1640,3280),(289,'100116',1,142,142),(289,'300110',2,1416,2832),(289,'300118',2,401,802),(290,'100110',2,401,802),(290,'200116',2,342,684),(290,'100104',1,448,448),(291,'300120',2,1443,2886),(291,'300114',1,944,944),(291,'100100',2,413,826),(292,'200114',2,330,661),(292,'200118',2,354,708),(292,'100104',1,448,448),(293,'300110',1,1416,1416),(293,'100102',1,484,484),(293,'200104',2,767,1534),(294,'300122',2,1723,3446),(294,'200116',2,342,684),(294,'100114',1,588,588),(295,'100102',1,484,484),(295,'300114',1,944,944),(295,'300122',2,1723,3446),(296,'300108',2,1640,3280),(296,'200110',2,289,578),(296,'200112',2,330,661),(297,'100110',2,401,802),(297,'200110',2,289,578),(297,'200116',2,342,684),(298,'200104',2,767,1534),(298,'200102',1,684,684),(298,'200106',2,378,755),(299,'200110',1,289,289),(299,'100114',2,588,1175),(299,'300106',2,1416,2832),(300,'200102',2,684,1369),(300,'100106',2,413,826),(300,'100110',1,401,401),(301,'200110',1,289,289),(301,'100106',2,413,826),(301,'200102',1,684,684),(302,'200112',2,330,661),(302,'100120',1,270,270),(302,'200104',1,767,767),(303,'100114',2,588,1175),(303,'300110',1,1416,1416),(303,'200102',1,684,684),(304,'300112',1,661,661),(304,'100120',2,270,540),(304,'300104',2,1947,3894),(305,'200114',1,330,330),(305,'100114',2,588,1175),(305,'300120',2,1443,2886),(306,'200116',2,342,684),(306,'200112',2,330,661),(306,'200106',1,378,378),(307,'300120',2,1443,2886),(307,'300120',2,1443,2886),(307,'100118',2,283,566),(308,'100102',2,484,968),(308,'300108',1,1640,1640),(308,'200112',2,330,661),(309,'300100',2,1829,3658),(309,'300116',1,378,378),(309,'100114',2,588,1175),(310,'100116',2,142,283),(310,'100102',1,484,484),(310,'200106',2,378,755),(311,'100102',2,484,968),(311,'200114',2,330,661),(311,'300110',2,1416,2832),(312,'300104',2,1947,3894),(312,'100114',1,588,588),(312,'300120',1,1443,1443),(313,'100108',1,142,142),(313,'100100',2,413,826),(313,'300102',2,1864,3729),(314,'300106',2,1416,2832),(314,'300108',2,1640,3280),(314,'200114',1,330,330),(315,'300104',2,1947,3894),(315,'100108',1,142,142),(315,'100110',2,401,802),(316,'200220',1,342,342),(316,'100108',2,142,283),(316,'300108',2,1640,3280),(317,'200110',1,289,289),(317,'200100',2,649,1298),(317,'300106',1,1416,1416),(318,'200108',1,283,283),(318,'100110',2,401,802),(318,'300122',1,1723,1723),(319,'300120',2,1443,2886),(319,'100104',2,448,897),(319,'200106',2,378,755),(320,'200100',1,649,649),(320,'200114',1,330,330),(320,'100100',2,413,826),(321,'200104',2,767,1534),(321,'200100',1,649,649),(321,'300114',1,944,944),(322,'200220',2,342,684),(322,'100106',2,413,826),(322,'300118',1,401,401),(323,'100110',2,401,802),(323,'100120',1,270,270),(323,'300100',1,1829,1829),(324,'200108',2,283,566),(324,'100114',2,588,1175),(324,'300100',1,1829,1829),(325,'100102',2,484,968),(325,'200114',1,330,330),(326,'100104',2,448,897),(326,'200102',2,684,1369),(327,'300110',1,1416,1416),(327,'200100',1,649,649),(328,'300104',1,1947,1947),(328,'300112',2,661,1322),(329,'300104',2,1947,3894),(329,'100104',1,448,448),(330,'300104',2,1947,3894),(330,'300122',1,1723,1723),(331,'300106',2,1416,2832),(331,'100104',1,448,448),(332,'100100',1,413,413),(332,'200112',1,330,330),(333,'300110',1,1416,1416),(333,'100110',1,401,401),(334,'200220',1,342,342),(334,'200112',2,330,661),(335,'100104',2,448,897),(335,'200106',1,378,378),(336,'200116',1,342,342),(336,'100112',1,531,531),(337,'100104',1,448,448),(337,'200110',1,289,289),(338,'200112',1,330,330),(338,'100100',2,413,826),(339,'200118',2,354,708),(339,'100120',2,270,540),(340,'300106',2,1416,2832),(340,'300102',1,1864,1864),(341,'100114',1,588,588),(341,'200118',2,354,708),(342,'300108',1,1640,1640),(342,'100100',1,413,413),(343,'100100',2,413,826),(343,'100108',1,142,142),(344,'200220',1,342,342),(344,'200118',1,354,354),(345,'300104',2,1947,3894),(345,'300106',1,1416,1416),(346,'100100',2,413,826),(346,'100116',1,142,142),(347,'200106',1,378,378),(347,'300122',2,1723,3446),(348,'200104',2,767,1534),(348,'200118',1,354,354),(349,'300100',2,1829,3658),(349,'300112',2,661,1322),(350,'200108',1,283,283),(350,'100110',1,401,401),(351,'300118',2,401,802),(351,'100104',1,448,448),(352,'200100',2,649,1298),(352,'100102',1,484,484),(353,'200106',2,378,755),(353,'200104',2,767,1534),(354,'300110',1,1416,1416),(354,'100110',1,401,401),(355,'300100',1,1829,1829),(355,'200108',2,283,566),(356,'300100',1,1829,1829),(356,'200108',1,283,283),(357,'100118',2,283,566),(357,'100116',2,142,283),(358,'300106',1,1416,1416),(358,'300108',2,1640,3280),(359,'200100',1,649,649),(359,'300108',1,1640,1640),(360,'100114',2,588,1175),(360,'100106',2,413,826),(361,'100104',1,448,448),(361,'100116',1,142,142),(362,'300104',2,1947,3894),(362,'200118',2,354,708),(363,'300122',2,1723,3446),(363,'300110',2,1416,2832),(364,'200110',2,289,578),(364,'100100',1,413,413),(365,'200100',2,649,1298),(365,'200114',1,330,330),(366,'200104',1,767,767),(366,'200102',2,684,1369),(367,'100112',2,531,1062),(367,'200104',2,767,1534),(368,'200118',2,354,708),(368,'300122',2,1723,3446),(369,'300120',2,1443,2886),(369,'300102',2,1864,3729),(370,'300106',1,1416,1416),(370,'200116',1,342,342),(371,'300118',2,401,802),(371,'200112',1,330,330),(372,'300110',2,1416,2832),(372,'300110',2,1416,2832),(373,'200100',2,649,1298),(373,'100116',2,142,283),(374,'100108',2,142,283),(374,'200110',1,289,289),(375,'100112',1,531,531),(375,'300102',2,1864,3729),(376,'200116',1,342,342),(376,'300114',2,944,1888),(377,'300104',1,1947,1947),(377,'200106',2,378,755),(378,'200118',1,354,354),(378,'100120',2,270,540),(379,'300114',1,944,944),(379,'200108',2,283,566),(380,'300114',1,944,944),(380,'100100',1,413,413),(381,'100114',2,588,1175),(381,'300100',1,1829,1829),(382,'200116',1,342,342),(382,'300104',2,1947,3894),(383,'300110',1,1416,1416),(383,'100100',2,413,826),(384,'200110',2,289,578),(384,'200118',2,354,708),(385,'200112',2,330,661),(385,'300104',2,1947,3894),(386,'300110',1,1416,1416),(386,'300104',2,1947,3894),(387,'300106',2,1416,2832),(387,'100110',1,401,401),(388,'100100',2,413,826),(388,'200116',1,342,342),(389,'200114',2,330,661),(389,'100108',2,142,283),(390,'200112',1,330,330),(390,'200112',1,330,330),(391,'100116',1,142,142),(391,'300108',2,1640,3280),(392,'300100',2,1829,3658),(392,'100104',2,448,897),(393,'300110',1,1416,1416),(393,'200116',1,342,342),(394,'300108',2,1640,3280),(394,'100114',1,588,588),(395,'200220',1,342,342),(395,'300102',1,1864,1864),(396,'100102',2,484,968),(396,'300106',2,1416,2832),(397,'100114',1,588,588),(397,'100114',2,588,1175),(398,'100100',1,413,413),(398,'100100',2,413,826),(399,'200114',2,330,661),(399,'200112',1,330,330),(400,'200220',2,342,684),(400,'200114',2,330,661),(401,'200112',1,330,330),(401,'200106',1,378,378),(402,'200110',2,289,578),(402,'300104',2,1947,3894),(403,'100106',2,413,826),(403,'300104',1,1947,1947),(404,'200106',2,378,755),(404,'200110',1,289,289),(405,'300120',1,1443,1443),(405,'300110',2,1416,2832),(406,'200114',1,330,330),(406,'100104',1,448,448),(407,'200112',1,330,330),(407,'300116',2,378,755),(408,'300122',2,1723,3446),(408,'200220',2,342,684),(409,'300106',1,1416,1416),(409,'100100',1,413,413),(410,'300116',2,378,755),(410,'100100',1,413,413),(411,'300100',1,1829,1829),(411,'100106',1,413,413),(412,'100100',1,413,413),(412,'100116',2,142,283),(413,'300102',1,1864,1864),(413,'100118',1,283,283),(414,'200108',2,283,566),(414,'200114',1,330,330),(415,'100118',1,283,283),(415,'200102',2,684,1369),(416,'200106',1,378,378),(416,'300108',2,1640,3280),(417,'200100',2,649,1298),(417,'300118',2,401,802),(418,'200102',2,684,1369),(418,'200110',2,289,578),(419,'300104',2,1947,3894),(419,'300108',1,1640,1640),(420,'300114',1,944,944),(420,'200106',2,378,755),(421,'100118',2,283,566),(421,'200106',1,378,378),(422,'100106',1,413,413),(422,'100102',2,484,968),(423,'300118',2,401,802),(423,'100100',2,413,826),(424,'100114',1,588,588),(424,'300116',1,378,378),(425,'200100',2,649,1298),(425,'300104',1,1947,1947),(426,'100108',1,142,142),(426,'200108',1,283,283),(427,'100104',2,448,897),(427,'300122',1,1723,1723),(428,'100108',1,142,142),(428,'100114',1,588,588),(429,'200112',1,330,330),(429,'100112',2,531,1062),(430,'300110',1,1416,1416),(430,'300114',1,944,944),(431,'100106',1,413,413),(431,'300106',1,1416,1416),(432,'200118',1,354,354),(432,'100120',2,270,540),(433,'100110',1,401,401),(433,'200118',1,354,354),(434,'200104',1,767,767),(434,'100118',1,283,283),(435,'300118',1,401,401),(435,'100102',2,484,968),(436,'100100',2,413,826),(436,'100110',2,401,802),(437,'200112',1,330,330),(437,'200110',1,289,289),(438,'300114',2,944,1888),(438,'300118',1,401,401),(439,'200118',2,354,708),(439,'100110',1,401,401),(440,'300104',1,1947,1947),(440,'200102',1,684,684),(441,'200108',1,283,283),(441,'300104',1,1947,1947),(442,'100100',1,413,413),(442,'100102',2,484,968),(443,'300102',1,1864,1864),(443,'300114',1,944,944),(444,'100102',2,484,968),(444,'200114',2,330,661),(445,'300100',1,1829,1829),(445,'100106',2,413,826),(446,'100112',1,531,531),(446,'200102',2,684,1369),(447,'300122',2,1723,3446),(447,'300112',2,661,1322),(448,'300112',2,661,1322),(448,'300116',2,378,755),(449,'200114',1,330,330),(449,'100102',1,484,484),(450,'300120',2,1443,2886),(450,'100112',2,531,1062),(451,'300106',2,1416,2832),(451,'200106',1,378,378),(452,'100106',2,413,826),(452,'300118',2,401,802),(453,'200108',2,283,566),(453,'300106',2,1416,2832),(454,'100120',2,270,540),(454,'200112',2,330,661),(455,'300102',1,1864,1864),(455,'300120',1,1443,1443),(456,'300122',2,1723,3446),(456,'100112',1,531,531),(457,'200110',2,289,578),(457,'200100',2,649,1298),(458,'100110',2,401,802),(458,'200220',2,342,684),(459,'100116',2,142,283),(459,'100120',2,270,540),(460,'300110',2,1416,2832),(460,'100108',1,142,142),(461,'200108',2,283,566),(461,'300112',1,661,661),(462,'200100',2,649,1298),(462,'100110',1,401,401),(463,'100114',2,588,1175),(463,'300110',2,1416,2832),(464,'300116',1,378,378),(464,'200114',1,330,330),(465,'100102',1,484,484),(465,'300106',2,1416,2832),(466,'300118',2,401,802),(466,'100112',1,531,531),(467,'100102',1,484,484),(467,'200108',1,283,283),(468,'200118',2,354,708),(468,'300122',2,1723,3446),(469,'200112',2,330,661),(469,'100116',2,142,283),(470,'300116',1,378,378),(470,'100100',1,413,413),(471,'300102',1,1864,1864),(471,'100104',2,448,897),(472,'100108',1,142,142),(472,'300102',2,1864,3729),(473,'100106',1,413,413),(473,'200220',1,342,342),(474,'100110',1,401,401),(474,'200102',1,684,684),(475,'300114',2,944,1888),(475,'200104',1,767,767),(476,'200102',1,684,684),(476,'200118',1,354,354),(477,'300118',1,401,401),(477,'200110',1,289,289),(478,'200108',2,283,566),(478,'200112',2,330,661),(479,'300112',1,661,661),(479,'100100',2,413,826),(480,'300110',1,1416,1416),(480,'300104',1,1947,1947),(481,'200116',2,342,684),(481,'300114',1,944,944),(482,'300120',1,1443,1443),(482,'300116',1,378,378),(483,'100112',1,531,531),(483,'300104',2,1947,3894),(484,'300108',1,1640,1640),(484,'300120',1,1443,1443),(485,'200220',2,342,684),(485,'300116',1,378,378),(486,'100116',1,142,142),(486,'200118',2,354,708),(487,'200110',2,289,578),(487,'100114',1,588,588),(488,'200108',1,283,283),(488,'100112',1,531,531),(489,'300104',1,1947,1947),(489,'200114',1,330,330),(490,'300108',1,1640,1640),(490,'300100',1,1829,1829),(491,'100106',1,413,413),(491,'200110',1,289,289),(492,'300106',2,1416,2832),(492,'100114',1,588,588),(493,'300114',1,944,944),(493,'100108',1,142,142),(494,'300118',2,401,802),(494,'100112',2,531,1062),(495,'100100',2,413,826),(495,'300116',2,378,755),(496,'300114',1,944,944),(496,'300114',2,944,1888),(497,'200100',1,649,649),(497,'200220',1,342,342),(498,'200220',1,342,342),(498,'200110',2,289,578),(499,'100120',2,270,540),(499,'100112',1,531,531),(500,'200102',2,684,1369),(500,'200112',1,330,330),(501,'300116',1,378,378),(501,'100104',2,448,897),(502,'300108',1,1640,1640),(502,'200102',2,684,1369),(503,'100110',1,401,401),(503,'100120',1,270,270),(504,'200110',2,289,578),(504,'200220',1,342,342);
  186. /*!40000 ALTER TABLE `detalleventasvirtuales` ENABLE KEYS */;
  187. UNLOCK TABLES;
  188.  
  189. --
  190. -- Table structure for table `empleados`
  191. --
  192.  
  193. DROP TABLE IF EXISTS `empleados`;
  194. /*!40101 SET @saved_cs_client = @@character_set_client */;
  195. /*!40101 SET character_set_client = utf8 */;
  196. CREATE TABLE `empleados` (
  197. `noempleado` int(11) NOT NULL,
  198. `nombre` varchar(80) NOT NULL,
  199. `fechaingreso` date DEFAULT NULL,
  200. `sueldo` float DEFAULT NULL,
  201. PRIMARY KEY (`noempleado`)
  202. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  203. /*!40101 SET character_set_client = @saved_cs_client */;
  204.  
  205. --
  206. -- Dumping data for table `empleados`
  207. --
  208.  
  209. LOCK TABLES `empleados` WRITE;
  210. /*!40000 ALTER TABLE `empleados` DISABLE KEYS */;
  211. INSERT INTO `empleados` VALUES (1,'RAUL GOMEZ','2010-10-10',2600),(2,'ERNESTO PEREZ','2012-12-12',3200),(3,'FLABIO GAMKEZ','2014-10-09',3200),(4,'LOURDES PEREZ','2016-07-09',3200),(5,'MARIA ARREOLA','2017-04-07',2600),(6,'SANDRA RUIZ','2017-01-08',2600),(7,'OLGA MARGARITA LOPEZ','2017-04-09',3200),(8,'LETICIA VALLES','2017-04-04',3200),(9,'MARIA DE LA LUZ ORTIZ','2017-08-09',3200);
  212. /*!40000 ALTER TABLE `empleados` ENABLE KEYS */;
  213. UNLOCK TABLES;
  214.  
  215. --
  216. -- Table structure for table `inventarios`
  217. --
  218.  
  219. DROP TABLE IF EXISTS `inventarios`;
  220. /*!40101 SET @saved_cs_client = @@character_set_client */;
  221. /*!40101 SET character_set_client = utf8 */;
  222. CREATE TABLE `inventarios` (
  223. `codigo` varchar(10) NOT NULL,
  224. `existencia` int(11) NOT NULL,
  225. `unidadmedida` varchar(20) NOT NULL,
  226. PRIMARY KEY (`codigo`),
  227. CONSTRAINT `inventarios_ibfk_1` FOREIGN KEY (`codigo`) REFERENCES `productos` (`codigo`)
  228. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  229. /*!40101 SET character_set_client = @saved_cs_client */;
  230.  
  231. --
  232. -- Dumping data for table `inventarios`
  233. --
  234.  
  235. LOCK TABLES `inventarios` WRITE;
  236. /*!40000 ALTER TABLE `inventarios` DISABLE KEYS */;
  237. INSERT INTO `inventarios` VALUES ('100100',100,'PIEZA'),('100102',150,'PIEZA'),('100104',120,'PIEZA'),('100106',99,'PIEZA'),('100108',12,'PIEZA'),('100110',65,'PIEZA'),('100112',90,'PIEZA'),('100114',55,'PIEZA'),('100116',6,'PIEZA'),('100118',65,'PIEZA'),('100120',5,'PIEZA'),('200100',20,'PIEZA'),('200102',28,'PIEZA'),('200104',50,'PIEZA'),('200106',31,'PIEZA'),('200108',41,'PIEZA'),('200110',11,'PIEZA'),('200112',34,'PIEZA'),('200114',34,'PIEZA'),('200116',71,'PIEZA'),('200118',52,'PIEZA'),('200220',48,'PIEZA'),('300100',20,'PAR'),('300102',40,'PAR'),('300104',60,'PAR'),('300106',85,'PAR'),('300108',80,'PAR'),('300110',46,'PAR'),('300112',89,'PAR'),('300114',6,'PAR'),('300116',63,'PAR'),('300118',98,'PAR'),('300120',99,'PAR'),('300122',2,'PAR');
  238. /*!40000 ALTER TABLE `inventarios` ENABLE KEYS */;
  239. UNLOCK TABLES;
  240.  
  241. --
  242. -- Table structure for table `productos`
  243. --
  244.  
  245. DROP TABLE IF EXISTS `productos`;
  246. /*!40101 SET @saved_cs_client = @@character_set_client */;
  247. /*!40101 SET character_set_client = utf8 */;
  248. CREATE TABLE `productos` (
  249. `codigo` varchar(10) NOT NULL,
  250. `descripcion` varchar(40) NOT NULL,
  251. `precio` float NOT NULL,
  252. `marca` varchar(20) NOT NULL,
  253. PRIMARY KEY (`codigo`)
  254. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  255. /*!40101 SET character_set_client = @saved_cs_client */;
  256.  
  257. --
  258. -- Dumping data for table `productos`
  259. --
  260.  
  261. LOCK TABLES `productos` WRITE;
  262. /*!40000 ALTER TABLE `productos` DISABLE KEYS */;
  263. INSERT INTO `productos` VALUES ('100100','CINTO PIEL CABALLERO',350,'CK'),('100102','CINTO PIEL DAMA',410,'PE'),('100104','CINTO PIEL JUVENIL',380,'LEVIS'),('100106','BUFANDA NAVIDEÑA',350,'PIPO'),('100108','PAÑUELOS X',120,'X'),('100110','GORRO NAVIDEÑO',340,'PIPO'),('100112','BOLSA DAMA',450,'X'),('100114','BOLSA JUVENIL ',498,'PIPO'),('100116','PAÑOLETA GIVEN',120,'GIVEN'),('100118','GAFAS DE SOL ',240,'NIKE'),('100120','LENTES ',229,'JORDAN'),('200100','PANTALON MEZCLILLA CABALLERO',550,'LEVIS'),('200102','PANTALON MEZCLILLA DAMA',580,'JORDAN'),('200104','PANTALON MEZCLILLA JUVENIL',650,'GIVEN'),('200106','BLUSA PARA DAMA',320,'NIKE'),('200108','BLUSA ALGODON NIÑO',240,'GIVEN'),('200110','MAMELUCO BEBE NIÑA',245,'JORDAN'),('200112','MAMELUCO BEBE NIÑO',280,'JORDAN'),('200114','PANTALON BEBE AZUL',280,'GIVEN'),('200116','PANFALON BEB ROSA',290,'GIVEN'),('200118','PLAYERA JUVENIL',300,'NIKE'),('200220','PLAYEDA JOVENCITA',290,'NIKE'),('300100','TENIS PARA CABALLERO',1550,'NIKE'),('300102','TENIS PARA DAMA',1580,'NIKE'),('300104','TENIS JUVENIL',1650,'NIKE'),('300106','ZAPATO JUVENIL ',1200,'NIKE'),('300108','ZAPATO CABALLERO',1390,'GIVEN'),('300110','ZAPATO DAMA',1200,'JORDAN'),('300112','ZAPATO BEBE',560,'PIPO'),('300114','ZAPATO NIÑA',800,'PIPO'),('300116','ZANDALIA PLAYA JUVENIL',320,'JORDAN'),('300118','ZANDALIAS PLAYA CABALLERO',340,'JORDAN'),('300120','BOTAS DAMA',1223,'GIVEN'),('300122','BOTAS CABALLERO',1460,'GIVEN');
  264. /*!40000 ALTER TABLE `productos` ENABLE KEYS */;
  265. UNLOCK TABLES;
  266.  
  267. --
  268. -- Table structure for table `usuarios`
  269. --
  270.  
  271. DROP TABLE IF EXISTS `usuarios`;
  272. /*!40101 SET @saved_cs_client = @@character_set_client */;
  273. /*!40101 SET character_set_client = utf8 */;
  274. CREATE TABLE `usuarios` (
  275. `cuenta` varchar(15) NOT NULL,
  276. `nombre` varchar(80) NOT NULL,
  277. `password` varchar(10) NOT NULL,
  278. `email` varchar(60) NOT NULL,
  279. `calleno` varchar(60) NOT NULL,
  280. `colonia` int(11) NOT NULL,
  281. `telefono` varchar(10) NOT NULL,
  282. PRIMARY KEY (`cuenta`),
  283. KEY `FKCOLONIASUSUARIOS_idx` (`colonia`),
  284. CONSTRAINT `FKCOLONIASUSUARIOS` FOREIGN KEY (`colonia`) REFERENCES `colonias` (`colonia`) ON DELETE NO ACTION ON UPDATE NO ACTION
  285. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  286. /*!40101 SET character_set_client = @saved_cs_client */;
  287.  
  288. --
  289. -- Dumping data for table `usuarios`
  290. --
  291.  
  292. LOCK TABLES `usuarios` WRITE;
  293. /*!40000 ALTER TABLE `usuarios` DISABLE KEYS */;
  294. INSERT INTO `usuarios` VALUES ('avillarrea','VILLARREAL CAMPOS AXEL ABIRAM','prueba','avillarreal@hotmail.com','GUADALUPE VICTORIA',4,'8102070'),('bbermudez','BASILIO BERMUDEZ','love','bbermudez@yahoo.com.mx','DEL REFUGIO 120',5,'8131516'),('cperez','CARLLOS PEREZ ORRANTE','cperez','cperez@yahoo.com','constitucion 130 sur',1,'8161756'),('jcabral','CABRAL TAMAYO JUAN CARLOS','prueba','jcabral@yahoo.com.mx','EMILIANO ZAPATA NO 765',5,'8134070'),('jgomez','JEORGINA GOMEZ','testing','jgomez@hotmail.com','MEXICO',3,'1115687'),('jgonzalez','JORGUE GONZALEZ','sexo','jgonzalez@gmail.com','GUADALUIPE VICTORIA',4,'1234564'),('jhernandez','JOAQUIN HERNANDEZ RIVERA','amor','jhernandez@hotmail.com','DEL AMANECER',5,'8890989'),('mlopez','MEZA LOPEZ CITLALY MARIA','prueba','mlopez@hotmail.com','PRIV. DEL AMANECER 120',2,'8102030'),('mmartos','MAECELO MARTOS','prueba','mmartos@gmail.com','ZACATECAS',3,'11234567'),('mmunios','MARCELA MUÑOZ','prueba','mmunioz@hotmail.com','VERACRUZ',3,'8761112'),('omartinez','MARTINEZ VILCHIS OMAR','testing','omartinez@gmail.com','MORELOS NO 120',5,'1134070'),('palvarado','ALVARADO ROCHA PERLA SUSANA','testing','palvarado@yahoo.com.mx','FRANCISVO VILLA N0 1000',5,'8113070'),('portiz','PATRICIA ORTIZ','love','portiz@hotmail.com','DURANGO',3,'8765645'),('rpizarro','RUBEN PIZARRO GURROLA','rpizarro','rpizarro@yahoo.com','JUAREZ 320 NTE',1,'8102045'),('sreyes','REYES VALDES SHARON ALEJANDRA','prueba','sreyes@hotmail.com','BENITO JUAREZ NO. 420',4,'8102050');
  295. /*!40000 ALTER TABLE `usuarios` ENABLE KEYS */;
  296. UNLOCK TABLES;
  297.  
  298. --
  299. -- Table structure for table `usuariostarjetas`
  300. --
  301.  
  302. DROP TABLE IF EXISTS `usuariostarjetas`;
  303. /*!40101 SET @saved_cs_client = @@character_set_client */;
  304. /*!40101 SET character_set_client = utf8 */;
  305. CREATE TABLE `usuariostarjetas` (
  306. `notarjeta` varchar(16) NOT NULL,
  307. `cuenta` varchar(15) NOT NULL,
  308. PRIMARY KEY (`notarjeta`,`cuenta`),
  309. KEY `cuenta` (`cuenta`),
  310. CONSTRAINT `usuariostarjetas_ibfk_1` FOREIGN KEY (`cuenta`) REFERENCES `usuarios` (`cuenta`)
  311. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  312. /*!40101 SET character_set_client = @saved_cs_client */;
  313.  
  314. --
  315. -- Dumping data for table `usuariostarjetas`
  316. --
  317.  
  318. LOCK TABLES `usuariostarjetas` WRITE;
  319. /*!40000 ALTER TABLE `usuariostarjetas` DISABLE KEYS */;
  320. INSERT INTO `usuariostarjetas` VALUES ('1020304056901021','avillarrea'),('1456223420202786','bbermudez'),('1456223420208086','cperez'),('1420102030405060','jcabral'),('1456223420202069','jgomez'),('1456223420206090','jgonzalez'),('1456223420204242','jhernandez'),('1010122013201450','mlopez'),('1111121213131414','mlopez'),('1456223420202940','mmartos'),('1456223420201973','mmunios'),('1617181920212223','omartinez'),('1234567890123456','palvarado'),('1456223420201047','portiz'),('1456223420209314','rpizarro'),('1213141510090807','sreyes'),('2020304010102020','sreyes');
  321. /*!40000 ALTER TABLE `usuariostarjetas` ENABLE KEYS */;
  322. UNLOCK TABLES;
  323.  
  324. --
  325. -- Table structure for table `ventaspresenciales`
  326. --
  327.  
  328. DROP TABLE IF EXISTS `ventaspresenciales`;
  329. /*!40101 SET @saved_cs_client = @@character_set_client */;
  330. /*!40101 SET character_set_client = utf8 */;
  331. CREATE TABLE `ventaspresenciales` (
  332. `noventa` int(11) NOT NULL,
  333. `fecha` date NOT NULL,
  334. `hora` datetime NOT NULL,
  335. `noempleado` int(11) NOT NULL,
  336. `cliente` int(11) NOT NULL,
  337. `total` float NOT NULL,
  338. PRIMARY KEY (`noventa`),
  339. KEY `noempleado` (`noempleado`),
  340. KEY `cliente` (`cliente`),
  341. CONSTRAINT `ventaspresenciales_ibfk_1` FOREIGN KEY (`noempleado`) REFERENCES `empleados` (`noempleado`),
  342. CONSTRAINT `ventaspresenciales_ibfk_2` FOREIGN KEY (`cliente`) REFERENCES `clientes` (`cliente`)
  343. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  344. /*!40101 SET character_set_client = @saved_cs_client */;
  345.  
  346. --
  347. -- Dumping data for table `ventaspresenciales`
  348. --
  349.  
  350. LOCK TABLES `ventaspresenciales` WRITE;
  351. /*!40000 ALTER TABLE `ventaspresenciales` DISABLE KEYS */;
  352. INSERT INTO `ventaspresenciales` VALUES (1,'2017-07-29','2017-07-29 16:15:33',7,115666,1251),(2,'2017-07-09','2017-07-09 22:25:51',4,24115,1156),(3,'2017-07-19','2017-07-19 06:35:44',5,338211,1168),(4,'2017-07-18','2017-07-18 09:43:04',9,80835,2312),(5,'2017-07-19','2017-07-19 06:53:16',8,15502,1239),(6,'2017-07-19','2017-07-19 12:12:47',2,252179,2313),(7,'2017-07-15','2017-07-15 19:46:28',4,121205,624),(8,'2017-07-20','2017-07-20 15:35:22',4,252179,1298),(9,'2017-07-18','2017-07-18 12:21:29',5,114646,2360),(10,'2017-07-26','2017-07-26 16:28:38',3,67043,2360),(11,'2017-07-09','2017-07-09 03:44:13',1,2000,1097),(12,'2017-07-14','2017-07-14 11:32:52',6,9131,3175),(13,'2017-07-23','2017-07-23 23:00:43',4,356753,1416),(14,'2017-07-22','2017-07-22 02:22:13',4,89760,1770),(15,'2017-07-17','2017-07-17 18:49:56',7,364391,684),(16,'2017-07-02','2017-07-02 12:52:39',3,375954,4578),(17,'2017-07-04','2017-07-04 05:33:59',6,115666,2112),(18,'2017-07-05','2017-07-05 05:04:17',7,55959,855),(19,'2017-07-18','2017-07-18 01:32:50',6,2030,2544),(20,'2017-07-14','2017-07-14 11:57:14',6,89760,1659),(21,'2017-07-15','2017-07-15 15:48:16',9,216292,4224),(22,'2017-07-16','2017-07-16 15:00:05',4,304127,1817),(23,'2017-07-16','2017-07-16 21:44:46',7,375954,1817),(24,'2017-07-24','2017-07-24 02:10:47',1,24115,3028),(25,'2017-07-27','2017-07-27 04:58:11',8,162263,4696),(26,'2017-07-13','2017-07-13 01:54:06',6,65543,1038),(27,'2017-07-01','2017-07-01 06:39:00',3,128764,1251),(28,'2017-07-15','2017-07-15 01:18:13',7,332465,1605),(29,'2017-07-16','2017-07-16 05:46:17',9,287451,1062),(30,'2017-07-03','2017-07-03 14:00:17',1,128764,1085),(31,'2017-07-06','2017-07-06 04:41:31',2,171385,1782),(32,'2017-07-24','2017-07-24 21:28:12',8,264514,1251),(33,'2017-07-16','2017-07-16 21:39:37',8,15553,2198),(34,'2017-07-22','2017-07-22 06:08:23',2,170894,613),(35,'2017-07-09','2017-07-09 18:08:09',1,133529,803),(36,'2017-07-20','2017-07-20 17:12:20',8,232664,3233),(37,'2017-07-20','2017-07-20 08:35:25',6,375954,3800),(38,'2017-07-08','2017-07-08 02:43:00',7,107115,1180),(39,'2017-07-05','2017-07-05 11:44:08',1,223140,790),(40,'2017-07-14','2017-07-14 00:56:41',4,338211,3426),(41,'2017-07-26','2017-07-26 15:47:00',6,122481,4555),(42,'2017-07-09','2017-07-09 10:05:45',8,172144,684),(43,'2017-07-23','2017-07-23 00:33:14',8,128764,4082),(44,'2017-07-01','2017-07-01 09:23:13',1,128764,7316),(45,'2017-07-03','2017-07-03 09:57:44',6,252179,3563),(46,'2017-07-19','2017-07-19 19:56:40',6,270900,1883),(47,'2017-07-27','2017-07-27 19:10:43',1,301796,3587),(48,'2017-07-07','2017-07-07 14:28:19',3,122481,743),(49,'2017-07-13','2017-07-13 15:41:33',2,2030,1250),(50,'2017-07-20','2017-07-20 17:11:31',6,24688,1404),(51,'2017-07-02','2017-07-02 15:04:54',2,89760,1368),(52,'2017-07-30','2017-07-30 03:09:36',1,187194,2112),(53,'2017-07-14','2017-07-14 04:55:34',7,301796,871),(54,'2017-07-04','2017-07-04 21:53:05',2,24115,4000),(55,'2017-07-14','2017-07-14 11:31:51',6,71021,1862),(56,'2017-07-17','2017-07-17 15:26:37',8,20365,1038),(57,'2017-07-11','2017-07-11 09:05:20',5,367092,3009),(58,'2017-07-14','2017-07-14 04:53:15',6,163261,4649),(59,'2017-07-01','2017-07-01 21:31:29',7,31759,2219),(60,'2017-07-19','2017-07-19 19:29:01',2,163261,1062),(61,'2017-07-28','2017-07-28 07:29:37',3,227774,3028),(62,'2017-07-14','2017-07-14 19:34:37',4,144909,4815),(63,'2017-07-23','2017-07-23 23:20:28',2,59714,894),(64,'2017-07-10','2017-07-10 14:58:29',3,31759,2218),(65,'2017-07-13','2017-07-13 06:50:57',2,15553,1310),(66,'2017-07-30','2017-07-30 10:49:44',2,24688,1215),(67,'2017-07-29','2017-07-29 23:25:47',5,319417,1910),(68,'2017-07-25','2017-07-25 13:55:30',5,27433,1345),(69,'2017-07-13','2017-07-13 00:15:09',4,144909,1414),(70,'2017-07-30','2017-07-30 20:40:10',9,140210,803),(71,'2017-07-01','2017-07-01 17:05:10',3,163261,1829),(72,'2017-07-06','2017-07-06 22:40:04',7,228695,2290),(73,'2017-07-14','2017-07-14 02:30:37',6,114646,3587),(74,'2017-07-28','2017-07-28 16:27:39',8,228452,1652),(75,'2017-07-30','2017-07-30 20:09:56',8,319417,1062),(76,'2017-07-18','2017-07-18 10:45:27',2,374471,2266),(77,'2017-07-15','2017-07-15 02:02:28',5,140210,3594),(78,'2017-07-22','2017-07-22 02:05:54',5,9131,1711),(79,'2017-07-04','2017-07-04 05:55:52',2,107115,559),(80,'2017-07-05','2017-07-05 16:58:24',2,347725,4508),(81,'2017-07-21','2017-07-21 17:08:11',7,33183,730),(82,'2017-07-17','2017-07-17 12:42:02',7,71021,791),(83,'2017-07-27','2017-07-27 22:34:56',3,89760,3569),(84,'2017-07-01','2017-07-01 07:19:30',4,140210,1333),(85,'2017-07-28','2017-07-28 18:53:35',4,80835,4224),(86,'2017-07-03','2017-07-03 07:20:29',1,2010,643),(87,'2017-07-08','2017-07-08 00:34:40',5,142311,4201),(88,'2017-07-14','2017-07-14 10:39:52',7,171385,2198),(89,'2017-07-20','2017-07-20 11:56:54',8,216292,2608),(90,'2017-07-09','2017-07-09 04:02:51',7,270900,1726),(91,'2017-07-14','2017-07-14 22:33:40',5,67043,2158),(92,'2017-07-24','2017-07-24 10:07:12',8,325595,1735),(93,'2017-07-24','2017-07-24 18:39:39',1,123106,954),(94,'2017-07-21','2017-07-21 14:57:00',9,187194,2004),(95,'2017-07-10','2017-07-10 21:55:57',4,347725,2217),(96,'2017-07-17','2017-07-17 23:34:40',7,121205,1864),(97,'2017-07-22','2017-07-22 05:27:25',7,24115,1510),(98,'2017-07-10','2017-07-10 21:12:45',5,59714,3464),(99,'2017-07-22','2017-07-22 04:03:23',7,65543,1930),(100,'2017-07-29','2017-07-29 01:40:06',8,164133,1746),(101,'2017-07-27','2017-07-27 23:03:25',1,2000,1368),(102,'2017-07-21','2017-07-21 16:21:01',4,356753,1275),(103,'2017-07-17','2017-07-17 14:53:39',9,2010,3634),(104,'2017-07-23','2017-07-23 04:14:42',4,2000,4342),(105,'2017-07-08','2017-07-08 20:31:50',9,2010,1726),(106,'2017-07-20','2017-07-20 15:37:48',9,338211,3588),(107,'2017-07-22','2017-07-22 20:00:20',8,375954,1109),(108,'2017-07-22','2017-07-22 09:16:00',3,111627,3681),(109,'2017-07-05','2017-07-05 04:28:53',5,228695,919),(110,'2017-07-23','2017-07-23 05:30:54',2,338211,4201),(111,'2017-07-28','2017-07-28 10:34:31',7,20365,5310),(112,'2017-07-10','2017-07-10 19:25:14',6,2030,1971),(113,'2017-07-17','2017-07-17 12:10:12',8,107115,1970),(114,'2017-07-13','2017-07-13 15:14:26',5,292865,2263),(115,'2017-07-22','2017-07-22 00:09:48',5,184135,3469),(116,'2017-07-10','2017-07-10 21:23:39',7,133529,2171),(117,'2017-07-21','2017-07-21 07:58:42',7,123106,6938),(118,'2017-07-22','2017-07-22 09:18:00',3,15553,871),(119,'2017-07-11','2017-07-11 02:40:09',7,67043,6726),(120,'2017-07-10','2017-07-10 21:26:37',1,144909,2230),(121,'2017-07-10','2017-07-10 08:49:45',4,140210,1912),(122,'2017-07-15','2017-07-15 22:23:42',6,2040,2891),(123,'2017-07-29','2017-07-29 19:33:51',2,156164,944),(124,'2017-07-08','2017-07-08 23:53:56',8,59714,1381),(125,'2017-07-04','2017-07-04 00:08:48',8,304127,4342),(126,'2017-07-08','2017-07-08 11:49:28',5,2050,2006),(127,'2017-07-14','2017-07-14 18:04:02',3,223140,1935),(128,'2017-07-05','2017-07-05 17:50:07',4,114646,4413),(129,'2017-07-02','2017-07-02 00:54:30',6,114646,4366),(130,'2017-07-23','2017-07-23 19:27:46',9,59714,2478),(131,'2017-07-07','2017-07-07 02:45:24',7,43085,1935),(132,'2017-07-11','2017-07-11 18:10:46',7,2050,743),(133,'2017-07-16','2017-07-16 09:24:45',1,184135,870),(134,'2017-07-12','2017-07-12 17:39:33',4,364391,2277),(135,'2017-07-11','2017-07-11 23:28:57',2,171385,932),(136,'2017-07-15','2017-07-15 17:10:29',9,130842,4472),(137,'2017-07-02','2017-07-02 06:17:44',7,338211,2466),(138,'2017-07-09','2017-07-09 01:34:45',8,264514,2311),(139,'2017-07-06','2017-07-06 16:57:04',9,71021,1428),(140,'2017-07-19','2017-07-19 10:53:39',3,80835,684),(141,'2017-07-02','2017-07-02 04:50:44',4,264514,1511),(142,'2017-07-09','2017-07-09 01:44:11',1,163261,4213),(143,'2017-07-11','2017-07-11 07:11:05',1,111627,1322),(144,'2017-07-21','2017-07-21 06:52:12',9,171385,5758),(145,'2017-07-02','2017-07-02 15:37:41',6,184817,566),(146,'2017-07-05','2017-07-05 23:13:47',8,45091,3634),(147,'2017-07-30','2017-07-30 05:53:32',9,31759,1930),(148,'2017-07-12','2017-07-12 02:40:57',1,114646,4059),(149,'2017-07-28','2017-07-28 21:24:30',7,55959,1758),(150,'2017-07-01','2017-07-01 14:00:10',5,292865,4626),(151,'2017-07-22','2017-07-22 13:02:28',2,319417,2112),(152,'2017-07-12','2017-07-12 09:12:00',5,375921,1746),(153,'2017-07-07','2017-07-07 03:33:46',4,2050,520),(154,'2017-07-12','2017-07-12 09:57:44',4,374471,4720),(155,'2017-07-24','2017-07-24 10:28:13',4,260186,3257),(156,'2017-07-16','2017-07-16 07:27:48',5,65543,4295),(157,'2017-07-08','2017-07-08 06:00:48',9,130842,2667),(158,'2017-07-02','2017-07-02 05:49:32',3,228695,849),(159,'2017-07-28','2017-07-28 23:07:21',1,264514,5027),(160,'2017-07-24','2017-07-24 02:38:22',3,374471,684),(161,'2017-07-04','2017-07-04 05:09:38',3,24688,2525),(162,'2017-07-06','2017-07-06 02:15:46',1,24115,1770),(163,'2017-07-23','2017-07-23 21:02:23',5,71021,6112),(164,'2017-07-05','2017-07-05 19:41:36',3,367092,2053),(165,'2017-07-08','2017-07-08 08:45:18',7,184135,1227),(166,'2017-07-04','2017-07-04 11:00:25',6,31759,1581),(167,'2017-07-09','2017-07-09 17:17:46',7,32997,3009),(168,'2017-07-30','2017-07-30 22:54:42',1,172144,3316),(169,'2017-07-04','2017-07-04 20:53:22',5,107115,968),(170,'2017-07-10','2017-07-10 15:08:03',5,128764,1935),(171,'2017-07-05','2017-07-05 03:53:49',7,71021,718),(172,'2017-07-07','2017-07-07 17:30:32',3,2000,1711),(173,'2017-07-13','2017-07-13 01:05:31',8,270900,3540),(174,'2017-07-20','2017-07-20 14:19:31',7,252179,3115),(175,'2017-07-20','2017-07-20 06:00:12',8,282589,2773),(176,'2017-07-23','2017-07-23 03:27:34',6,349283,5074),(177,'2017-07-26','2017-07-26 06:40:53',8,59714,2242),(178,'2017-07-27','2017-07-27 03:21:49',5,100948,2667),(179,'2017-07-26','2017-07-26 16:45:36',3,184817,6561),(180,'2017-07-01','2017-07-01 08:55:57',8,111627,1664),(181,'2017-07-27','2017-07-27 16:45:56',9,216292,1345),(182,'2017-07-17','2017-07-17 06:44:58',5,100948,3516),(183,'2017-07-01','2017-07-01 01:15:20',2,2000,2395),(184,'2017-07-24','2017-07-24 04:45:20',2,2050,849),(185,'2017-07-09','2017-07-09 17:06:17',1,115666,1390),(186,'2017-07-04','2017-07-04 04:55:25',8,100948,968),(187,'2017-07-19','2017-07-19 21:31:40',9,184135,4390),(188,'2017-07-08','2017-07-08 16:12:22',3,144909,2289),(189,'2017-07-23','2017-07-23 16:52:57',7,77565,1038),(190,'2017-07-07','2017-07-07 08:31:03',2,187194,6561),(191,'2017-07-20','2017-07-20 07:19:00',8,32997,1585),(192,'2017-07-26','2017-07-26 16:51:06',9,227774,6726),(193,'2017-07-11','2017-07-11 03:12:53',8,338211,1239),(194,'2017-07-30','2017-07-30 19:43:48',4,282589,1333),(195,'2017-07-10','2017-07-10 04:57:40',9,2010,4177),(196,'2017-07-14','2017-07-14 12:08:06',2,325595,1321),(197,'2017-07-24','2017-07-24 10:57:31',7,77565,4224),(198,'2017-07-03','2017-07-03 04:44:13',1,187194,1900),(199,'2017-07-18','2017-07-18 04:51:26',9,142311,1935),(200,'2017-07-30','2017-07-30 10:08:10',7,235574,1585),(201,'2017-07-14','2017-07-14 03:14:02',1,270900,661),(202,'2017-07-16','2017-07-16 03:10:47',6,347725,1085),(203,'2017-07-01','2017-07-01 17:33:53',4,342608,3716),(204,'2017-07-17','2017-07-17 09:46:08',9,100948,3929),(205,'2017-07-20','2017-07-20 17:56:57',2,71021,3316),(206,'2017-07-04','2017-07-04 09:07:57',7,71021,4661),(207,'2017-07-30','2017-07-30 20:16:35',3,282589,944),(208,'2017-07-26','2017-07-26 09:38:02',1,107115,968),(209,'2017-07-07','2017-07-07 11:29:21',5,319417,731),(210,'2017-07-30','2017-07-30 02:39:19',3,9131,2004),(211,'2017-07-21','2017-07-21 09:56:56',4,80835,4555),(212,'2017-07-18','2017-07-18 07:12:03',5,77565,1652),(213,'2017-07-21','2017-07-21 19:28:48',2,142311,5145),(214,'2017-07-19','2017-07-19 11:43:09',3,223140,3304),(215,'2017-07-18','2017-07-18 02:26:15',2,347725,3929),(216,'2017-07-05','2017-07-05 23:05:15',8,228695,2667),(217,'2017-07-21','2017-07-21 16:50:05',3,2010,3122),(218,'2017-07-25','2017-07-25 21:16:16',2,80835,3622),(219,'2017-07-23','2017-07-23 02:55:23',6,304127,1726),(220,'2017-07-19','2017-07-19 13:55:30',4,187194,3299),(221,'2017-07-18','2017-07-18 01:40:34',9,122481,2089),(222,'2017-07-11','2017-07-11 04:12:13',7,184135,1003),(223,'2017-07-18','2017-07-18 13:09:07',5,24688,2118),(224,'2017-07-27','2017-07-27 02:43:24',7,2010,2206),(225,'2017-07-10','2017-07-10 05:58:48',2,9131,3847),(226,'2017-07-19','2017-07-19 15:18:45',3,133529,1475),(227,'2017-07-09','2017-07-09 18:23:36',3,347725,4248),(228,'2017-07-26','2017-07-26 03:23:30',2,2040,814),(229,'2017-07-16','2017-07-16 05:26:30',5,55959,1888),(230,'2017-07-29','2017-07-29 21:05:20',3,334729,1713),(231,'2017-07-08','2017-07-08 11:13:48',8,140210,1097),(232,'2017-07-22','2017-07-22 13:08:35',5,228695,2667),(233,'2017-07-02','2017-07-02 03:56:26',6,357452,2714),(234,'2017-07-27','2017-07-27 17:01:41',7,111627,3868),(235,'2017-07-26','2017-07-26 10:26:58',1,156164,683),(236,'2017-07-12','2017-07-12 20:29:03',4,24115,2691),(237,'2017-07-10','2017-07-10 17:56:45',1,77565,1180),(238,'2017-07-21','2017-07-21 11:44:36',3,115666,1062),(239,'2017-07-10','2017-07-10 13:24:16',8,216292,4130),(240,'2017-07-18','2017-07-18 02:51:34',4,342608,1593),(241,'2017-07-09','2017-07-09 15:22:20',3,375954,2690),(242,'2017-07-01','2017-07-01 18:24:31',9,59714,1109),(243,'2017-07-03','2017-07-03 00:08:09',3,123106,2001),(244,'2017-07-21','2017-07-21 17:11:05',6,107115,1215),(245,'2017-07-04','2017-07-04 05:04:40',8,86842,4035),(246,'2017-07-19','2017-07-19 19:17:43',5,24688,755),(247,'2017-07-30','2017-07-30 18:19:38',4,342608,4184),(248,'2017-07-03','2017-07-03 23:16:45',7,2000,2245),(249,'2017-07-21','2017-07-21 15:34:02',5,100948,2974),(250,'2017-07-28','2017-07-28 16:50:46',3,33183,1463),(251,'2017-07-11','2017-07-11 20:46:01',2,114646,2006),(252,'2017-07-29','2017-07-29 01:27:54',3,122481,1711),(253,'2017-07-07','2017-07-07 00:09:41',9,144909,1726),(254,'2017-07-30','2017-07-30 17:55:25',2,338211,4071),(255,'2017-07-23','2017-07-23 11:57:47',4,292865,2289),(256,'2017-07-14','2017-07-14 15:14:08',1,375954,2195),(257,'2017-07-22','2017-07-22 06:52:07',4,20365,1106),(258,'2017-07-11','2017-07-11 05:15:56',1,170894,908),(259,'2017-07-26','2017-07-26 02:00:54',4,32997,3847),(260,'2017-07-13','2017-07-13 00:46:12',3,304127,1581),(261,'2017-07-26','2017-07-26 08:11:34',5,140210,566),(262,'2017-07-29','2017-07-29 06:23:38',8,227774,578),(263,'2017-07-17','2017-07-17 10:51:27',7,89760,5772),(264,'2017-07-26','2017-07-26 04:20:15',9,71021,1797),(265,'2017-07-08','2017-07-08 16:17:27',4,374471,1864),(266,'2017-07-29','2017-07-29 07:01:21',5,235574,3156),(267,'2017-07-04','2017-07-04 21:33:52',3,260186,2312),(268,'2017-07-02','2017-07-02 20:11:40',4,123106,2384),(269,'2017-07-27','2017-07-27 07:08:57',4,232664,2104),(270,'2017-07-04','2017-07-04 23:45:22',8,59714,1110),(271,'2017-07-06','2017-07-06 09:50:53',1,227774,932),(272,'2017-07-24','2017-07-24 21:41:16',2,2030,2147),(273,'2017-07-07','2017-07-07 20:06:52',3,184135,2065),(274,'2017-07-06','2017-07-06 10:38:40',6,232664,2112),(275,'2017-07-18','2017-07-18 22:26:43',3,107115,1558),(276,'2017-07-22','2017-07-22 16:25:06',4,55959,1345),(277,'2017-07-25','2017-07-25 17:15:51',7,356753,1026),(278,'2017-07-19','2017-07-19 06:54:13',5,2050,973),(279,'2017-07-26','2017-07-26 06:32:16',3,111627,2206),(280,'2017-07-09','2017-07-09 19:48:23',9,12639,1286),(281,'2017-07-25','2017-07-25 04:52:42',1,59714,855),(282,'2017-07-29','2017-07-29 21:02:16',5,184135,2749),(283,'2017-07-01','2017-07-01 02:42:58',1,115666,2230),(284,'2017-07-13','2017-07-13 17:32:23',6,282589,1368),(285,'2017-07-09','2017-07-09 08:37:19',5,260186,2053),(286,'2017-07-26','2017-07-26 20:26:14',7,31759,991),(287,'2017-07-09','2017-07-09 20:12:30',1,24115,5487),(288,'2017-07-17','2017-07-17 12:15:06',7,163261,1121),(289,'2017-07-30','2017-07-30 08:08:08',6,349283,1585),(290,'2017-07-29','2017-07-29 21:34:37',3,287451,1676),(291,'2017-07-23','2017-07-23 06:10:56',8,235574,1581),(292,'2017-07-05','2017-07-05 16:04:56',7,338211,2207),(293,'2017-07-01','2017-07-01 15:09:05',9,235574,1699),(294,'2017-07-06','2017-07-06 17:51:52',1,301796,7788),(295,'2017-07-28','2017-07-28 09:08:55',7,338211,920),(296,'2017-07-30','2017-07-30 07:08:47',2,367092,1298),(297,'2017-07-08','2017-07-08 05:27:11',8,349283,1227),(298,'2017-07-24','2017-07-24 11:04:04',5,364391,3516),(299,'2017-07-17','2017-07-17 10:06:13',1,111627,1876),(300,'2017-07-11','2017-07-11 03:34:46',4,289102,3735),(301,'2017-07-18','2017-07-18 17:18:57',1,114646,2198),(302,'2017-07-21','2017-07-21 22:22:11',2,356753,1227),(303,'2017-07-13','2017-07-13 19:07:52',9,375921,1605),(304,'2017-07-05','2017-07-05 12:53:55',1,9131,2242),(305,'2017-07-07','2017-07-07 21:46:14',2,227774,1109),(306,'2017-07-03','2017-07-03 23:32:32',2,375921,3228),(307,'2017-07-25','2017-07-25 01:55:45',5,304127,2950),(308,'2017-07-12','2017-07-12 09:02:53',8,15553,991),(309,'2017-07-26','2017-07-26 09:09:44',4,349283,1699),(310,'2017-07-01','2017-07-01 11:37:28',1,164133,3464),(311,'2017-07-03','2017-07-03 05:58:35',7,223140,3174),(312,'2017-07-29','2017-07-29 10:59:16',5,162263,1342),(313,'2017-07-21','2017-07-21 20:30:39',5,319848,1168),(314,'2017-07-13','2017-07-13 15:58:23',3,15553,1097),(315,'2017-07-29','2017-07-29 07:18:03',8,86842,1333),(316,'2017-07-15','2017-07-15 01:14:05',8,2000,3175),(317,'2017-07-21','2017-07-21 20:27:57',8,65543,1605),(318,'2017-07-29','2017-07-29 16:42:48',1,2040,2690),(319,'2017-07-18','2017-07-18 16:49:36',2,114646,3516),(320,'2017-07-08','2017-07-08 13:01:40',7,216292,2549),(321,'2017-07-09','2017-07-09 23:46:31',6,375954,2336),(322,'2017-07-18','2017-07-18 06:30:43',7,282589,2619),(323,'2017-07-02','2017-07-02 09:19:10',9,334729,1392),(324,'2017-07-03','2017-07-03 00:26:29',1,304127,1074),(325,'2017-07-26','2017-07-26 22:53:14',6,334729,5101),(326,'2017-07-28','2017-07-28 00:11:51',5,2000,2384),(327,'2017-07-04','2017-07-04 01:30:27',8,235574,5275),(328,'2017-07-15','2017-07-15 08:46:33',6,55959,1900),(329,'2017-07-12','2017-07-12 16:57:31',5,121205,1368),(330,'2017-07-05','2017-07-05 08:11:16',4,100948,1121),(331,'2017-07-11','2017-07-11 01:34:34',2,142311,3280),(332,'2017-07-25','2017-07-25 15:02:52',6,115666,3653),(333,'2017-07-03','2017-07-03 23:25:07',6,375954,625),(334,'2017-07-09','2017-07-09 07:11:24',3,332465,637),(335,'2017-07-20','2017-07-20 07:45:41',9,144909,2277),(336,'2017-07-09','2017-07-09 00:45:41',4,89760,861),(337,'2017-07-14','2017-07-14 23:57:08',6,45091,1121),(338,'2017-07-18','2017-07-18 03:44:37',9,2030,1392),(339,'2017-07-28','2017-07-28 17:18:49',2,338211,3169),(340,'2017-07-23','2017-07-23 06:07:34',9,367092,1345),(341,'2017-07-29','2017-07-29 04:49:26',7,162263,4208),(342,'2017-07-29','2017-07-29 19:22:03',9,252179,1097),(343,'2017-07-10','2017-07-10 17:22:25',2,367092,661),(344,'2017-07-18','2017-07-18 16:15:57',6,184135,4012),(345,'2017-07-06','2017-07-06 09:00:56',2,144909,566),(346,'2017-07-09','2017-07-09 16:22:24',4,55959,1145),(347,'2017-07-18','2017-07-18 01:13:47',6,356753,3570),(348,'2017-07-17','2017-07-17 00:52:08',1,140210,1532),(349,'2017-07-12','2017-07-12 17:29:30',6,334729,3658),(350,'2017-07-16','2017-07-16 20:23:09',7,235574,3587),(351,'2017-07-26','2017-07-26 07:24:35',1,375954,3233),(352,'2017-07-09','2017-07-09 13:53:39',4,133529,3729),(353,'2017-07-26','2017-07-26 01:05:09',5,43085,1511),(354,'2017-07-02','2017-07-02 16:25:03',9,15502,2018),(355,'2017-07-25','2017-07-25 06:52:59',1,59714,1414),(356,'2017-07-20','2017-07-20 01:12:40',4,334729,814),(357,'2017-07-04','2017-07-04 15:13:11',9,252179,2269),(358,'2017-07-01','2017-07-01 03:52:57',5,228452,684),(359,'2017-07-17','2017-07-17 10:39:11',8,357452,1392),(360,'2017-07-01','2017-07-01 12:24:32',7,338211,1133),(361,'2017-07-25','2017-07-25 07:25:49',8,2050,2631),(362,'2017-07-17','2017-07-17 08:30:01',4,375954,3941),(363,'2017-07-01','2017-07-01 09:37:09',1,224555,1876),(364,'2017-07-11','2017-07-11 08:04:24',9,332465,4526),(365,'2017-07-15','2017-07-15 20:50:03',1,121205,2476),(366,'2017-07-26','2017-07-26 08:44:18',4,338211,1510),(367,'2017-07-23','2017-07-23 16:17:10',3,133529,4526),(368,'2017-07-30','2017-07-30 07:58:02',3,356753,2702),(369,'2017-07-20','2017-07-20 14:04:19',1,31759,2065),(370,'2017-07-28','2017-07-28 18:37:18',9,2000,284),(371,'2017-07-03','2017-07-03 17:55:48',5,128764,4071),(372,'2017-07-08','2017-07-08 17:10:53',7,260186,2497),(373,'2017-07-04','2017-07-04 11:38:23',9,2010,1929),(374,'2017-07-12','2017-07-12 18:29:38',7,223140,2077),(375,'2017-07-06','2017-07-06 11:03:19',5,270900,1785),(376,'2017-07-05','2017-07-05 09:20:43',9,15502,1310),(377,'2017-07-06','2017-07-06 01:04:33',1,24688,1628),(378,'2017-07-25','2017-07-25 12:05:24',7,24688,566),(379,'2017-07-02','2017-07-02 09:12:41',9,55959,684),(380,'2017-07-13','2017-07-13 03:16:10',7,27433,378),(381,'2017-07-07','2017-07-07 20:56:29',5,80835,484),(382,'2017-07-25','2017-07-25 15:11:10',4,65543,802),(383,'2017-07-29','2017-07-29 04:43:54',5,332465,566),(384,'2017-07-07','2017-07-07 06:40:38',3,216292,1443),(385,'2017-07-27','2017-07-27 09:32:29',5,144909,270),(386,'2017-07-03','2017-07-03 09:26:52',5,270900,826),(387,'2017-07-14','2017-07-14 19:01:11',1,184135,588),(388,'2017-07-23','2017-07-23 17:35:42',4,15553,3658),(389,'2017-07-05','2017-07-05 20:16:07',2,325595,1298),(390,'2017-07-13','2017-07-13 15:00:45',8,144909,330),(391,'2017-07-14','2017-07-14 20:07:18',9,252179,755),(392,'2017-07-28','2017-07-28 02:56:41',8,20365,1416),(393,'2017-07-21','2017-07-21 20:26:27',3,235574,767),(394,'2017-07-28','2017-07-28 02:04:30',2,12639,684),(395,'2017-07-06','2017-07-06 13:21:15',6,171385,1298),(396,'2017-07-14','2017-07-14 22:47:31',3,223140,342),(397,'2017-07-06','2017-07-06 18:30:39',2,12639,1416),(398,'2017-07-08','2017-07-08 01:20:49',3,184135,802),(399,'2017-07-30','2017-07-30 03:31:21',1,67043,413),(400,'2017-07-24','2017-07-24 18:08:17',3,301796,944),(401,'2017-07-23','2017-07-23 21:10:56',6,287451,588),(402,'2017-07-20','2017-07-20 19:07:01',7,349283,283),(403,'2017-07-04','2017-07-04 01:25:09',6,2030,1322),(404,'2017-07-03','2017-07-03 04:36:02',6,71021,283),(405,'2017-07-11','2017-07-11 19:06:27',1,375954,661),(406,'2017-07-28','2017-07-28 03:57:32',4,128764,944),(407,'2017-07-02','2017-07-02 21:45:52',5,357452,484),(408,'2017-07-05','2017-07-05 00:50:33',1,107115,283),(409,'2017-07-17','2017-07-17 22:46:34',6,77565,413),(410,'2017-07-04','2017-07-04 16:04:55',1,100948,566),(411,'2017-07-20','2017-07-20 17:08:20',5,292865,1640),(412,'2017-07-21','2017-07-21 15:58:18',2,356753,684),(413,'2017-07-12','2017-07-12 08:20:50',3,156164,330),(414,'2017-07-19','2017-07-19 16:59:38',1,164133,1322),(415,'2017-07-29','2017-07-29 13:25:13',2,86842,1723),(416,'2017-07-13','2017-07-13 20:24:59',7,162263,283),(417,'2017-07-26','2017-07-26 07:50:42',9,270900,1322),(418,'2017-07-30','2017-07-30 23:05:47',3,123106,802),(419,'2017-07-12','2017-07-12 10:25:47',3,287451,661),(420,'2017-07-17','2017-07-17 04:52:14',5,216292,354),(421,'2017-07-17','2017-07-17 14:30:38',7,140210,283),(422,'2017-07-30','2017-07-30 14:05:53',7,114646,1888),(423,'2017-07-22','2017-07-22 08:05:46',9,304127,283),(424,'2017-07-09','2017-07-09 02:47:05',3,292865,566),(425,'2017-07-16','2017-07-16 12:40:54',9,319848,708),(426,'2017-07-29','2017-07-29 21:05:40',2,15553,1062),(427,'2017-07-08','2017-07-08 13:12:08',6,45091,661),(428,'2017-07-27','2017-07-27 07:01:42',2,32997,413),(429,'2017-07-12','2017-07-12 15:12:30',6,133529,3446),(430,'2017-07-17','2017-07-17 13:15:22',1,338211,3894),(431,'2017-07-11','2017-07-11 17:15:40',2,2050,378),(432,'2017-07-03','2017-07-03 12:34:18',5,59714,1416),(433,'2017-07-06','2017-07-06 11:02:07',8,374471,531),(434,'2017-07-14','2017-07-14 12:42:57',8,319848,684),(435,'2017-07-02','2017-07-02 11:31:38',6,216292,755),(436,'2017-07-15','2017-07-15 12:27:00',6,12639,684),(437,'2017-07-20','2017-07-20 19:59:05',6,67043,3729);
  353. /*!40000 ALTER TABLE `ventaspresenciales` ENABLE KEYS */;
  354. UNLOCK TABLES;
  355.  
  356. --
  357. -- Table structure for table `ventasvirtuales`
  358. --
  359.  
  360. DROP TABLE IF EXISTS `ventasvirtuales`;
  361. /*!40101 SET @saved_cs_client = @@character_set_client */;
  362. /*!40101 SET character_set_client = utf8 */;
  363. CREATE TABLE `ventasvirtuales` (
  364. `noventa` int(11) NOT NULL,
  365. `fecha` date NOT NULL,
  366. `hora` datetime NOT NULL,
  367. `cuenta` varchar(15) NOT NULL,
  368. `total` float DEFAULT NULL,
  369. PRIMARY KEY (`noventa`),
  370. KEY `cuenta` (`cuenta`),
  371. CONSTRAINT `ventasvirtuales_ibfk_1` FOREIGN KEY (`cuenta`) REFERENCES `usuarios` (`cuenta`)
  372. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  373. /*!40101 SET character_set_client = @saved_cs_client */;
  374.  
  375. --
  376. -- Dumping data for table `ventasvirtuales`
  377. --
  378.  
  379. LOCK TABLES `ventasvirtuales` WRITE;
  380. /*!40000 ALTER TABLE `ventasvirtuales` DISABLE KEYS */;
  381. INSERT INTO `ventasvirtuales` VALUES (100,'2017-07-03','2017-07-03 10:00:00','jcabral',2136),(101,'2017-07-03','2017-07-03 10:20:00','omartinez',4720),(102,'2017-07-04','2017-07-04 09:02:00','palvarado',900),(103,'2017-07-04','2017-07-04 12:20:00','sreyes',920),(104,'2017-07-05','2017-07-05 09:45:00','avillarrea',3840),(105,'2017-07-05','2017-07-05 10:21:00','mlopez',2760),(106,'2017-07-06','2017-07-06 09:20:00','sreyes',3405),(107,'2017-07-06','2017-07-06 09:45:00','avillarrea',890),(108,'2017-07-06','2017-07-06 11:21:00','mlopez',870),(109,'2017-07-14','2017-07-14 14:22:31','jgonzalez',4390),(110,'2017-07-11','2017-07-11 11:34:32','jhernandez',1345),(111,'2017-07-24','2017-07-24 00:42:44','jcabral',2785),(112,'2017-07-28','2017-07-28 02:51:22','mmunios',2856),(113,'2017-07-07','2017-07-07 11:05:37','jhernandez',967),(114,'2017-07-26','2017-07-26 18:38:09','jcabral',2198),(115,'2017-07-06','2017-07-06 11:41:07','portiz',2950),(116,'2017-07-04','2017-07-04 14:24:22','palvarado',1144),(117,'2017-07-15','2017-07-15 10:01:29','omartinez',1227),(118,'2017-07-19','2017-07-19 10:00:41','palvarado',897),(119,'2017-07-23','2017-07-23 10:33:50','cperez',3169),(120,'2017-07-08','2017-07-08 01:43:23','portiz',3729),(121,'2017-07-17','2017-07-17 18:29:37','sreyes',4224),(122,'2017-07-05','2017-07-05 00:42:46','mmartos',2206),(123,'2017-07-25','2017-07-25 06:43:15','portiz',1711),(124,'2017-07-18','2017-07-18 11:15:22','jcabral',1132),(125,'2017-07-17','2017-07-17 14:50:26','mmartos',3481),(126,'2017-07-18','2017-07-18 17:29:00','portiz',743),(127,'2017-07-11','2017-07-11 22:40:32','jgomez',850),(128,'2017-07-13','2017-07-13 02:50:19','jgomez',2065),(129,'2017-07-06','2017-07-06 23:53:43','jgonzalez',3299),(130,'2017-07-23','2017-07-23 11:35:21','jgonzalez',3563),(131,'2017-07-02','2017-07-02 08:24:03','mmartos',1180),(132,'2017-07-14','2017-07-14 23:13:12','rpizarro',2254),(133,'2017-07-29','2017-07-29 09:57:52','jgomez',1345),(134,'2017-07-08','2017-07-08 10:53:31','mmunios',661),(135,'2017-07-05','2017-07-05 03:52:49','omartinez',1982),(136,'2017-07-24','2017-07-24 05:05:21','palvarado',3417),(137,'2017-07-12','2017-07-12 04:17:40','jgomez',1215),(138,'2017-07-05','2017-07-05 08:58:51','portiz',4779),(139,'2017-07-13','2017-07-13 17:35:47','palvarado',684),(140,'2017-07-06','2017-07-06 17:29:29','cperez',3728),(141,'2017-07-09','2017-07-09 02:20:12','palvarado',2148),(142,'2017-07-16','2017-07-16 04:32:02','jgonzalez',814),(143,'2017-07-11','2017-07-11 13:19:59','sreyes',1227),(144,'2017-07-04','2017-07-04 01:30:52','jgomez',5593),(145,'2017-07-09','2017-07-09 21:29:42','jhernandez',4071),(146,'2017-07-04','2017-07-04 16:22:15','portiz',3102),(147,'2017-07-13','2017-07-13 22:48:38','avillarrea',3941),(148,'2017-07-30','2017-07-30 22:05:11','palvarado',1109),(149,'2017-07-11','2017-07-11 11:37:09','mlopez',3941),(150,'2017-07-19','2017-07-19 09:43:23','jhernandez',4248),(151,'2017-07-20','2017-07-20 05:31:22','jgomez',1604),(152,'2017-07-30','2017-07-30 11:37:45','bbermudez',3210),(153,'2017-07-17','2017-07-17 21:23:01','jcabral',3186),(154,'2017-07-20','2017-07-20 07:12:12','portiz',755),(155,'2017-07-21','2017-07-21 03:35:33','jhernandez',1956),(156,'2017-07-05','2017-07-05 06:19:57','avillarrea',991),(157,'2017-07-14','2017-07-14 05:11:03','rpizarro',1038),(158,'2017-07-15','2017-07-15 18:21:23','avillarrea',743),(159,'2017-07-06','2017-07-06 16:57:54','omartinez',3587),(160,'2017-07-28','2017-07-28 11:22:32','mmunios',3370),(161,'2017-07-22','2017-07-22 05:58:28','portiz',3547),(162,'2017-07-25','2017-07-25 16:27:43','jgomez',1369),(163,'2017-07-27','2017-07-27 02:42:36','sreyes',896),(164,'2017-07-29','2017-07-29 04:20:38','mlopez',1109),(165,'2017-07-28','2017-07-28 03:11:53','rpizarro',4578),(166,'2017-07-21','2017-07-21 04:37:10','jcabral',885),(167,'2017-07-02','2017-07-02 23:18:44','avillarrea',3115),(168,'2017-07-26','2017-07-26 18:52:39','omartinez',814),(169,'2017-07-25','2017-07-25 21:19:15','palvarado',1782),(170,'2017-07-30','2017-07-30 05:34:31','sreyes',1699),(171,'2017-07-16','2017-07-16 17:55:06','mmartos',991),(172,'2017-07-05','2017-07-05 16:21:26','jcabral',1585),(173,'2017-07-09','2017-07-09 00:54:05','jgomez',826),(174,'2017-07-09','2017-07-09 00:09:34','jgonzalez',4661),(175,'2017-07-02','2017-07-02 22:18:26','mmunios',4578),(176,'2017-07-16','2017-07-16 01:51:02','jcabral',2608),(177,'2017-07-27','2017-07-27 10:14:02','mmartos',2572),(178,'2017-07-01','2017-07-01 03:44:29','avillarrea',4661),(179,'2017-07-17','2017-07-17 01:31:43','avillarrea',1014),(180,'2017-07-22','2017-07-22 02:51:20','bbermudez',4460),(181,'2017-07-05','2017-07-05 00:23:29','avillarrea',968),(182,'2017-07-18','2017-07-18 17:39:47','mlopez',1522),(183,'2017-07-24','2017-07-24 15:15:35','mmunios',1888),(184,'2017-07-19','2017-07-19 20:31:39','mmunios',1227),(185,'2017-07-25','2017-07-25 02:11:41','mlopez',3264),(186,'2017-07-20','2017-07-20 21:30:33','rpizarro',1553),(187,'2017-07-27','2017-07-27 23:02:26','mmunios',1726),(188,'2017-07-10','2017-07-10 18:03:31','cperez',767),(189,'2017-07-27','2017-07-27 11:30:26','portiz',3198),(190,'2017-07-03','2017-07-03 15:12:00','bbermudez',2159),(191,'2017-07-22','2017-07-22 11:19:28','portiz',4366),(192,'2017-07-27','2017-07-27 17:27:30','portiz',2324),(193,'2017-07-21','2017-07-21 11:15:11','portiz',2452),(194,'2017-07-18','2017-07-18 20:25:58','palvarado',4413),(195,'2017-07-02','2017-07-02 13:41:03','mmartos',5664),(196,'2017-07-08','2017-07-08 23:31:18','palvarado',5782),(197,'2017-07-30','2017-07-30 03:51:35','mmunios',1746),(198,'2017-07-11','2017-07-11 07:42:54','jgonzalez',1224),(199,'2017-07-08','2017-07-08 16:40:11','cperez',942),(200,'2017-07-26','2017-07-26 10:39:06','palvarado',2452),(201,'2017-07-13','2017-07-13 05:55:50','sreyes',873),(202,'2017-07-21','2017-07-21 00:22:56','mmunios',3186),(203,'2017-07-11','2017-07-11 13:21:24','sreyes',624),(204,'2017-07-05','2017-07-05 10:54:58','jgonzalez',1699),(205,'2017-07-07','2017-07-07 04:22:10','rpizarro',2218),(206,'2017-07-08','2017-07-08 08:17:47','jgonzalez',3610),(207,'2017-07-06','2017-07-06 12:29:00','jgomez',2092),(208,'2017-07-09','2017-07-09 15:40:45','palvarado',1109),(209,'2017-07-25','2017-07-25 06:10:35','omartinez',2407),(210,'2017-07-22','2017-07-22 19:55:58','mmartos',1144),(211,'2017-07-20','2017-07-20 19:56:01','omartinez',1910),(212,'2017-07-07','2017-07-07 19:43:13','sreyes',4130),(213,'2017-07-28','2017-07-28 09:51:59','palvarado',4130),(214,'2017-07-06','2017-07-06 02:08:34','mlopez',684),(215,'2017-07-03','2017-07-03 04:15:36','jgonzalez',1109),(216,'2017-07-14','2017-07-14 09:36:16','mmartos',2419),(217,'2017-07-18','2017-07-18 12:10:12','jgomez',1215),(218,'2017-07-01','2017-07-01 04:07:30','bbermudez',2242),(219,'2017-07-06','2017-07-06 04:09:58','mmartos',1392),(220,'2017-07-26','2017-07-26 10:00:32','jhernandez',2074),(221,'2017-07-20','2017-07-20 22:11:45','bbermudez',2832),(222,'2017-07-04','2017-07-04 04:35:01','sreyes',967),(223,'2017-07-14','2017-07-14 01:47:51','avillarrea',2242),(224,'2017-07-14','2017-07-14 14:25:18','avillarrea',1091),(225,'2017-07-13','2017-07-13 21:17:12','jhernandez',1732),(226,'2017-07-28','2017-07-28 17:15:34','mmartos',661),(227,'2017-07-23','2017-07-23 06:06:17','portiz',1558),(228,'2017-07-01','2017-07-01 19:18:27','rpizarro',1510),(229,'2017-07-11','2017-07-11 20:44:54','jcabral',2655),(230,'2017-07-30','2017-07-30 00:35:33','omartinez',2525),(231,'2017-07-19','2017-07-19 13:43:08','jcabral',932),(232,'2017-07-29','2017-07-29 03:07:00','cperez',2127),(233,'2017-07-30','2017-07-30 07:35:12','omartinez',1604),(234,'2017-07-12','2017-07-12 07:25:02','palvarado',4472),(235,'2017-07-11','2017-07-11 19:46:04','sreyes',1091),(236,'2017-07-25','2017-07-25 16:50:56','palvarado',1115),(237,'2017-07-11','2017-07-11 22:36:01','omartinez',1227),(238,'2017-07-08','2017-07-08 21:40:09','portiz',4307),(239,'2017-07-09','2017-07-09 07:20:24','jhernandez',4434),(240,'2017-07-01','2017-07-01 22:54:33','omartinez',1956),(241,'2017-07-15','2017-07-15 11:03:02','mmunios',3587),(242,'2017-07-03','2017-07-03 04:43:24','avillarrea',1416),(243,'2017-07-20','2017-07-20 10:18:31','mmartos',4508),(244,'2017-07-14','2017-07-14 19:10:05','mmartos',848),(245,'2017-07-17','2017-07-17 11:39:04','rpizarro',3587),(246,'2017-07-28','2017-07-28 22:02:46','bbermudez',5772),(247,'2017-07-13','2017-07-13 11:10:52','rpizarro',1817),(248,'2017-07-20','2017-07-20 02:45:23','jgomez',1310),(249,'2017-07-06','2017-07-06 22:27:45','jcabral',1534),(250,'2017-07-29','2017-07-29 22:49:20','mmartos',1982),(251,'2017-07-22','2017-07-22 01:01:44','jcabral',1475),(252,'2017-07-11','2017-07-11 00:40:00','jgomez',1817),(253,'2017-07-10','2017-07-10 21:14:25','omartinez',2452),(254,'2017-07-28','2017-07-28 07:55:51','mmunios',1829),(255,'2017-07-05','2017-07-05 13:44:04','jcabral',555),(256,'2017-07-13','2017-07-13 04:35:34','jhernandez',944),(257,'2017-07-25','2017-07-25 01:47:19','sreyes',2207),(258,'2017-07-05','2017-07-05 13:11:47','rpizarro',1237),(259,'2017-07-23','2017-07-23 03:42:15','mmartos',2104),(260,'2017-07-23','2017-07-23 05:52:21','bbermudez',991),(261,'2017-07-16','2017-07-16 00:23:37','bbermudez',1085),(262,'2017-07-22','2017-07-22 12:44:09','mlopez',1086),(263,'2017-07-05','2017-07-05 20:30:20','mlopez',2112),(264,'2017-07-02','2017-07-02 19:01:10','jcabral',1628),(265,'2017-07-07','2017-07-07 17:50:11','cperez',1770),(266,'2017-07-19','2017-07-19 13:00:20','sreyes',1982),(267,'2017-07-23','2017-07-23 03:54:20','cperez',1794),(268,'2017-07-30','2017-07-30 06:12:58','jcabral',1392),(269,'2017-07-09','2017-07-09 16:33:54','portiz',1746),(270,'2017-07-02','2017-07-02 02:24:02','jcabral',3166),(271,'2017-07-09','2017-07-09 02:55:39','jgomez',1227),(272,'2017-07-22','2017-07-22 16:00:40','mlopez',5718),(273,'2017-07-09','2017-07-09 12:08:52','omartinez',1428),(274,'2017-07-10','2017-07-10 16:15:37','cperez',1593),(275,'2017-07-09','2017-07-09 09:40:30','jgomez',3587),(276,'2017-07-01','2017-07-01 05:53:30','jcabral',4920),(277,'2017-07-04','2017-07-04 13:12:00','bbermudez',4319),(278,'2017-07-24','2017-07-24 08:29:18','jgomez',1475),(279,'2017-07-05','2017-07-05 02:09:45','mlopez',1605),(280,'2017-07-04','2017-07-04 18:36:28','bbermudez',1085),(281,'2017-07-02','2017-07-02 19:17:46','jhernandez',2030),(282,'2017-07-24','2017-07-24 23:57:57','cperez',1321),(283,'2017-07-26','2017-07-26 14:28:38','jgomez',684),(284,'2017-07-22','2017-07-22 07:05:54','jgonzalez',3417),(285,'2017-07-19','2017-07-19 11:41:33','avillarrea',1038),(286,'2017-07-15','2017-07-15 10:33:42','mlopez',1415),(287,'2017-07-12','2017-07-12 14:16:15','cperez',1847),(288,'2017-07-01','2017-07-01 00:20:46','mmartos',5310),(289,'2017-07-16','2017-07-16 07:24:57','mlopez',3776),(290,'2017-07-25','2017-07-25 18:07:45','jgomez',1934),(291,'2017-07-09','2017-07-09 12:41:59','portiz',4656),(292,'2017-07-03','2017-07-03 12:36:31','mmartos',1817),(293,'2017-07-24','2017-07-24 14:34:10','rpizarro',3434),(294,'2017-07-05','2017-07-05 22:46:44','omartinez',4718),(295,'2017-07-25','2017-07-25 14:09:26','jhernandez',4874),(296,'2017-07-20','2017-07-20 12:13:19','jcabral',4519),(297,'2017-07-08','2017-07-08 15:23:44','mmartos',2064),(298,'2017-07-10','2017-07-10 08:53:07','sreyes',2973),(299,'2017-07-21','2017-07-21 03:40:54','omartinez',4296),(300,'2017-07-25','2017-07-25 10:00:16','jcabral',2596),(301,'2017-07-09','2017-07-09 22:13:46','jgomez',1799),(302,'2017-07-09','2017-07-09 11:38:11','cperez',1698),(303,'2017-07-24','2017-07-24 05:28:01','avillarrea',3275),(304,'2017-07-25','2017-07-25 18:05:10','jgomez',5095),(305,'2017-07-24','2017-07-24 20:16:02','omartinez',4391),(306,'2017-07-17','2017-07-17 00:33:07','mmartos',1723),(307,'2017-07-04','2017-07-04 23:21:44','portiz',6338),(308,'2017-07-01','2017-07-01 23:25:27','omartinez',3269),(309,'2017-07-09','2017-07-09 14:25:42','mmunios',5211),(310,'2017-07-22','2017-07-22 14:45:31','avillarrea',1522),(311,'2017-07-07','2017-07-07 13:41:17','sreyes',4461),(312,'2017-07-22','2017-07-22 20:19:27','mlopez',5925),(313,'2017-07-13','2017-07-13 04:32:50','palvarado',4697),(314,'2017-07-08','2017-07-08 13:01:59','jcabral',6442),(315,'2017-07-30','2017-07-30 00:21:46','omartinez',4838),(316,'2017-07-19','2017-07-19 09:21:54','rpizarro',3905),(317,'2017-07-05','2017-07-05 11:31:43','mmunios',3003),(318,'2017-07-22','2017-07-22 04:13:44','jhernandez',2808),(319,'2017-07-29','2017-07-29 15:25:33','omartinez',4538),(320,'2017-07-21','2017-07-21 23:18:26','jcabral',1805),(321,'2017-07-11','2017-07-11 19:01:46','rpizarro',3127),(322,'2017-07-03','2017-07-03 22:26:29','jhernandez',1911),(323,'2017-07-24','2017-07-24 19:13:09','portiz',2901),(324,'2017-07-21','2017-07-21 21:45:52','omartinez',3570),(325,'2017-07-02','2017-07-02 19:38:58','jgonzalez',1298),(326,'2017-07-26','2017-07-26 03:21:26','sreyes',2266),(327,'2017-07-11','2017-07-11 02:14:58','portiz',2065),(328,'2017-07-29','2017-07-29 08:44:07','mmartos',3269),(329,'2017-07-11','2017-07-11 13:23:36','cperez',4342),(330,'2017-07-03','2017-07-03 10:11:01','bbermudez',5617),(331,'2017-07-30','2017-07-30 02:19:08','sreyes',3280),(332,'2017-07-22','2017-07-22 16:15:18','cperez',743),(333,'2017-07-06','2017-07-06 05:24:13','bbermudez',1817),(334,'2017-07-02','2017-07-02 04:27:01','palvarado',1003),(335,'2017-07-29','2017-07-29 14:40:01','palvarado',1275),(336,'2017-07-08','2017-07-08 22:04:10','bbermudez',873),(337,'2017-07-13','2017-07-13 21:51:12','avillarrea',737),(338,'2017-07-10','2017-07-10 00:02:40','rpizarro',1156),(339,'2017-07-13','2017-07-13 11:23:00','mmunios',1248),(340,'2017-07-02','2017-07-02 05:08:12','portiz',4696),(341,'2017-07-04','2017-07-04 17:14:30','portiz',1296),(342,'2017-07-16','2017-07-16 14:04:46','palvarado',2053),(343,'2017-07-20','2017-07-20 20:38:37','mmartos',968),(344,'2017-07-01','2017-07-01 20:13:02','omartinez',696),(345,'2017-07-08','2017-07-08 21:21:35','jcabral',5310),(346,'2017-07-10','2017-07-10 03:09:45','portiz',968),(347,'2017-07-21','2017-07-21 23:37:40','palvarado',3824),(348,'2017-07-25','2017-07-25 21:51:18','bbermudez',1888),(349,'2017-07-03','2017-07-03 18:11:45','cperez',4980),(350,'2017-07-23','2017-07-23 21:03:40','jgomez',684),(351,'2017-07-28','2017-07-28 20:23:58','omartinez',1250),(352,'2017-07-03','2017-07-03 18:23:07','avillarrea',1782),(353,'2017-07-25','2017-07-25 12:18:09','mlopez',2289),(354,'2017-07-16','2017-07-16 00:38:22','mmartos',1817),(355,'2017-07-27','2017-07-27 03:31:33','cperez',2395),(356,'2017-07-04','2017-07-04 16:15:26','palvarado',2112),(357,'2017-07-15','2017-07-15 12:38:46','portiz',849),(358,'2017-07-17','2017-07-17 03:34:21','cperez',4696),(359,'2017-07-09','2017-07-09 16:53:18','bbermudez',2289),(360,'2017-07-05','2017-07-05 08:50:59','mmunios',2001),(361,'2017-07-24','2017-07-24 13:16:45','avillarrea',590),(362,'2017-07-06','2017-07-06 04:19:52','rpizarro',4602),(363,'2017-07-19','2017-07-19 23:24:49','jgomez',6278),(364,'2017-07-25','2017-07-25 14:33:53','portiz',991),(365,'2017-07-03','2017-07-03 19:03:34','jgonzalez',1628),(366,'2017-07-21','2017-07-21 16:43:41','cperez',2136),(367,'2017-07-04','2017-07-04 08:11:51','jcabral',2596),(368,'2017-07-06','2017-07-06 20:18:08','jhernandez',4154),(369,'2017-07-28','2017-07-28 11:32:36','avillarrea',6615),(370,'2017-07-29','2017-07-29 20:49:10','omartinez',1758),(371,'2017-07-02','2017-07-02 19:18:16','jgonzalez',1132),(372,'2017-07-30','2017-07-30 20:58:34','cperez',5664),(373,'2017-07-22','2017-07-22 09:19:30','avillarrea',1581),(374,'2017-07-25','2017-07-25 01:32:37','jhernandez',572),(375,'2017-07-07','2017-07-07 13:55:53','mlopez',4260),(376,'2017-07-11','2017-07-11 02:13:55','cperez',2230),(377,'2017-07-09','2017-07-09 20:26:58','portiz',2702),(378,'2017-07-19','2017-07-19 00:59:00','jhernandez',894),(379,'2017-07-11','2017-07-11 18:44:21','avillarrea',1510),(380,'2017-07-30','2017-07-30 00:49:32','jgonzalez',1357),(381,'2017-07-15','2017-07-15 17:06:48','mlopez',3004),(382,'2017-07-29','2017-07-29 23:11:41','mlopez',4236),(383,'2017-07-27','2017-07-27 14:29:40','jhernandez',2242),(384,'2017-07-07','2017-07-07 01:29:52','rpizarro',1286),(385,'2017-07-26','2017-07-26 23:23:30','mlopez',4555),(386,'2017-07-27','2017-07-27 02:21:56','jcabral',5310),(387,'2017-07-02','2017-07-02 12:07:43','mmartos',3233),(388,'2017-07-18','2017-07-18 03:47:28','portiz',1168),(389,'2017-07-06','2017-07-06 14:02:16','portiz',944),(390,'2017-07-06','2017-07-06 20:31:48','jhernandez',660),(391,'2017-07-10','2017-07-10 12:30:16','mlopez',3422),(392,'2017-07-30','2017-07-30 09:00:32','jgonzalez',4555),(393,'2017-07-18','2017-07-18 10:20:42','portiz',1758),(394,'2017-07-24','2017-07-24 16:41:30','mlopez',3868),(395,'2017-07-18','2017-07-18 16:45:23','portiz',2206),(396,'2017-07-09','2017-07-09 19:11:57','jgomez',3800),(397,'2017-07-24','2017-07-24 23:54:17','jgonzalez',1763),(398,'2017-07-05','2017-07-05 11:18:10','jgomez',1239),(399,'2017-07-06','2017-07-06 02:17:08','jcabral',991),(400,'2017-07-07','2017-07-07 14:29:13','rpizarro',1345),(401,'2017-07-18','2017-07-18 00:47:52','jhernandez',708),(402,'2017-07-23','2017-07-23 09:30:20','portiz',4472),(403,'2017-07-29','2017-07-29 02:53:54','cperez',2773),(404,'2017-07-22','2017-07-22 07:23:33','cperez',1044),(405,'2017-07-02','2017-07-02 21:58:44','portiz',4275),(406,'2017-07-03','2017-07-03 01:36:04','jgonzalez',778),(407,'2017-07-03','2017-07-03 20:03:32','avillarrea',1085),(408,'2017-07-20','2017-07-20 21:27:24','mlopez',4130),(409,'2017-07-17','2017-07-17 14:16:44','palvarado',1829),(410,'2017-07-08','2017-07-08 09:13:39','omartinez',1168),(411,'2017-07-07','2017-07-07 16:22:03','mlopez',2242),(412,'2017-07-02','2017-07-02 14:10:14','bbermudez',696),(413,'2017-07-04','2017-07-04 19:58:43','palvarado',2147),(414,'2017-07-24','2017-07-24 23:31:02','jgonzalez',896),(415,'2017-07-01','2017-07-01 22:25:53','rpizarro',1652),(416,'2017-07-06','2017-07-06 14:57:23','jcabral',3658),(417,'2017-07-25','2017-07-25 13:59:00','bbermudez',2100),(418,'2017-07-17','2017-07-17 10:08:37','cperez',1947),(419,'2017-07-09','2017-07-09 23:35:17','avillarrea',5534),(420,'2017-07-16','2017-07-16 05:39:10','mlopez',1699),(421,'2017-07-07','2017-07-07 09:10:12','jhernandez',944),(422,'2017-07-19','2017-07-19 20:16:19','mmartos',1381),(423,'2017-07-26','2017-07-26 13:21:49','jgomez',1628),(424,'2017-07-16','2017-07-16 18:53:51','bbermudez',966),(425,'2017-07-21','2017-07-21 16:40:24','bbermudez',3245),(426,'2017-07-08','2017-07-08 08:37:09','rpizarro',425),(427,'2017-07-07','2017-07-07 00:41:24','mmartos',2620),(428,'2017-07-29','2017-07-29 01:34:46','mlopez',730),(429,'2017-07-08','2017-07-08 00:47:59','mlopez',1392),(430,'2017-07-07','2017-07-07 04:36:46','palvarado',2360),(431,'2017-07-07','2017-07-07 00:12:47','mmartos',1829),(432,'2017-07-24','2017-07-24 02:22:29','palvarado',894),(433,'2017-07-04','2017-07-04 03:34:44','mlopez',755),(434,'2017-07-21','2017-07-21 23:39:29','mmartos',1050),(435,'2017-07-05','2017-07-05 04:27:29','omartinez',1369),(436,'2017-07-28','2017-07-28 05:57:34','jgomez',1628),(437,'2017-07-06','2017-07-06 17:57:00','mmunios',619),(438,'2017-07-07','2017-07-07 21:09:01','jcabral',2289),(439,'2017-07-03','2017-07-03 04:21:13','jgomez',1109),(440,'2017-07-06','2017-07-06 10:45:19','jgonzalez',2631),(441,'2017-07-16','2017-07-16 08:22:45','avillarrea',2230),(442,'2017-07-01','2017-07-01 21:21:39','cperez',1381),(443,'2017-07-27','2017-07-27 01:32:46','cperez',2808),(444,'2017-07-27','2017-07-27 07:41:38','cperez',1629),(445,'2017-07-21','2017-07-21 20:28:26','jgomez',2655),(446,'2017-07-25','2017-07-25 23:13:32','avillarrea',1900),(447,'2017-07-07','2017-07-07 06:22:26','jgomez',4768),(448,'2017-07-19','2017-07-19 00:18:12','jgonzalez',2077),(449,'2017-07-28','2017-07-28 09:23:30','avillarrea',814),(450,'2017-07-13','2017-07-13 00:35:47','jhernandez',3948),(451,'2017-07-22','2017-07-22 19:43:25','sreyes',3210),(452,'2017-07-24','2017-07-24 00:53:49','omartinez',1628),(453,'2017-07-21','2017-07-21 04:27:20','palvarado',3398),(454,'2017-07-16','2017-07-16 08:38:34','mmartos',1201),(455,'2017-07-03','2017-07-03 21:20:16','rpizarro',3307),(456,'2017-07-03','2017-07-03 08:01:09','jhernandez',3977),(457,'2017-07-03','2017-07-03 01:27:37','jcabral',1876),(458,'2017-07-03','2017-07-03 11:26:01','bbermudez',1486),(459,'2017-07-23','2017-07-23 05:36:52','portiz',823),(460,'2017-07-11','2017-07-11 15:37:09','jcabral',2974),(461,'2017-07-11','2017-07-11 04:57:58','bbermudez',1227),(462,'2017-07-29','2017-07-29 12:46:04','avillarrea',1699),(463,'2017-07-29','2017-07-29 01:27:53','jgomez',4007),(464,'2017-07-17','2017-07-17 13:19:53','rpizarro',708),(465,'2017-07-03','2017-07-03 03:00:15','mmartos',3316),(466,'2017-07-23','2017-07-23 18:27:50','palvarado',1333),(467,'2017-07-21','2017-07-21 17:57:27','rpizarro',767),(468,'2017-07-15','2017-07-15 23:39:44','jgomez',4154),(469,'2017-07-20','2017-07-20 17:06:14','palvarado',944),(470,'2017-07-07','2017-07-07 02:28:14','mmartos',791),(471,'2017-07-29','2017-07-29 04:52:23','jhernandez',2761),(472,'2017-07-11','2017-07-11 09:37:01','cperez',3871),(473,'2017-07-08','2017-07-08 00:38:48','portiz',755),(474,'2017-07-04','2017-07-04 14:12:21','mlopez',1085),(475,'2017-07-08','2017-07-08 08:53:41','cperez',2655),(476,'2017-07-06','2017-07-06 16:06:37','mlopez',1038),(477,'2017-07-07','2017-07-07 14:35:58','jcabral',690),(478,'2017-07-19','2017-07-19 21:58:45','palvarado',1227),(479,'2017-07-14','2017-07-14 00:38:43','omartinez',1487),(480,'2017-07-17','2017-07-17 00:51:28','sreyes',3363),(481,'2017-07-12','2017-07-12 06:18:44','palvarado',1628),(482,'2017-07-12','2017-07-12 06:12:19','jgonzalez',1821),(483,'2017-07-28','2017-07-28 10:41:34','jgomez',4425),(484,'2017-07-21','2017-07-21 02:06:20','sreyes',3083),(485,'2017-07-11','2017-07-11 19:05:42','avillarrea',1062),(486,'2017-07-08','2017-07-08 12:00:49','rpizarro',850),(487,'2017-07-28','2017-07-28 06:12:42','omartinez',1166),(488,'2017-07-10','2017-07-10 15:56:37','portiz',814),(489,'2017-07-09','2017-07-09 03:33:09','jhernandez',2277),(490,'2017-07-22','2017-07-22 03:34:59','palvarado',3469),(491,'2017-07-15','2017-07-15 06:01:44','omartinez',702),(492,'2017-07-13','2017-07-13 14:53:21','portiz',3420),(493,'2017-07-08','2017-07-08 19:03:14','jgonzalez',1086),(494,'2017-07-24','2017-07-24 10:04:57','mlopez',1864),(495,'2017-07-30','2017-07-30 08:38:47','rpizarro',1581),(496,'2017-07-30','2017-07-30 20:37:23','portiz',2832),(497,'2017-07-06','2017-07-06 13:56:29','jcabral',991),(498,'2017-07-22','2017-07-22 16:17:18','jhernandez',920),(499,'2017-07-12','2017-07-12 12:00:16','jgonzalez',1071),(500,'2017-07-24','2017-07-24 00:18:11','jhernandez',1699),(501,'2017-07-29','2017-07-29 23:34:05','mmartos',1275),(502,'2017-07-09','2017-07-09 01:42:35','omartinez',3009),(503,'2017-07-23','2017-07-23 02:35:52','cperez',671),(504,'2017-07-04','2017-07-04 13:40:38','mmartos',920);
  382. /*!40000 ALTER TABLE `ventasvirtuales` ENABLE KEYS */;
  383. UNLOCK TABLES;
  384. /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
  385.  
  386. /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
  387. /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
  388. /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
  389. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  390. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  391. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
  392. /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
  393.  
  394. -- Dump completed on 2017-08-01 23:04:48
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!