-- Table structure for table `puntos_clics`
--

CREATE TABLE `puntos_clics` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_punto` int(11) NOT NULL,
  `ip_address` varchar(50) NOT NULL,
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `id_punto` (`id_punto`),
  CONSTRAINT `puntos_clics_ibfk_1` FOREIGN KEY (`id_punto`) REFERENCES `puntos` (`id`) ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=686 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `puntos_clics`
--

INSERT INTO `puntos_clics` VALUES (1,1654,'::1','2019-12-17 00:17:45'),(2,1661,'::1','2019-12-17 00:18:05'),(3,1835,'::1','2019-12-17 00:18:08'),(4,1805,'::1','2019-12-17 00:18:23'),(5,3219,'::1','2019-12-17 00:19:10'),(6,3220,'::1','2019-12-17 00:19:16'),(7,3217,'::1','2019-12-17 00:19:20'),(8,8636,'::1','2019-12-17 00:19:29'),(9,2285,'::1','2019-12-17 00:20:02'),(10,5762,'::1','2019-12-17 00:21:53'),(11,6312,'::1','2019-12-17 00:22:09'),(12,1997,'186.102.30.68','2019-12-20 20:09:26'),(13,1112,'191.156.30.185','2019-12-27 21:29:33'),(14,989,'186.31.148.106','2020-01-03 17:05:38'),(15,8569,'186.31.148.106','2020-01-03 17:05:46'),(16,8341,'186.31.148.106','2020-01-03 17:06:32'),(17,8341,'186.31.148.106','2020-01-03 17:06:43'),(18,8341,'186.31.148.106','2020-01-03 17:06:50'),(19,8341,'186.31.148.106','2020-01-03 17:06:51'),(20,1206,'186.154.98.234','2020-01-14 21:07:31'),(21,2007,'186.154.98.234','2020-01-14 21:09:12'),(22,268,'186.154.98.234','2020-01-14 21:09:23'),(23,7220,'181.132.36.95','2020-03-02 15:24:35'),(24,7220,'181.132.36.95','2020-03-02 15:24:45'),(25,7220,'181.132.36.95','2020-03-02 15:24:46'),(26,8360,'181.132.36.95','2020-03-02 15:24:51'),(27,8360,'181.132.36.95','2020-03-02 15:24:51'),(28,8360,'181.132.36.95','2020-03-02 15:25:01'),(29,8360,'181.132.36.95','2020-03-02 15:25:02'),(30,7164,'181.132.36.95','2020-03-02 15:25:02'),(31,7223,'181.132.36.95','2020-03-02 15:25:10'),(32,7223,'181.132.36.95','2020-03-02 15:25:16'),(33,7223,'181.132.36.95','2020-03-02 15:25:17'),(34,7140,'181.132.36.95','2020-03-02 15:25:22'),(35,7140,'181.132.36.95','2020-03-02 15:25:33'),(36,7140,'181.132.36.95','2020-03-02 15:25:34'),(37,8451,'181.132.36.95','2020-03-02 15:25:39'),(38,7205,'181.132.36.95','2020-03-02 15:25:47'),(39,7205,'181.132.36.95','2020-03-02 15:25:48'),(40,6113,'181.132.36.95','2020-03-02 16:01:34'),(41,1014,'181.132.36.95','2020-03-02 16:48:25'),(42,1014,'181.132.36.95','2020-03-02 16:48:37'),(43,1014,'181.132.36.95','2020-03-02 16:48:37'),(44,2007,'181.132.36.95','2020-03-02 16:51:56'),(45,2007,'181.132.36.95','2020-03-02 16:53:11'),(46,6113,'186.102.24.106','2020-03-02 16:54:26'),(47,2004,'186.102.24.106','2020-03-02 16:54:36'),(48,2004,'186.102.24.106','2020-03-02 16:54:39'),(49,2004,'186.102.24.106','2020-03-02 16:54:41'),(50,6125,'186.102.24.106','2020-03-02 16:54:52'),(51,1120,'186.102.24.106','2020-03-02 16:54:54'),(52,1120,'186.102.24.106','2020-03-02 16:54:58'),(53,1120,'186.102.24.106','2020-03-02 16:54:58'),(54,2007,'181.132.36.95','2020-03-02 17:00:47'),(55,2007,'181.132.36.95','2020-03-02 17:00:47'),(56,1624,'186.30.133.207','2020-03-02 17:09:54'),(57,220,'181.132.36.95','2020-03-02 17:09:55'),(58,1808,'186.30.133.207','2020-03-02 17:09:56'),(59,1744,'186.30.133.207','2020-03-02 17:10:02'),(60,982,'186.30.133.207','2020-03-02 17:10:24'),(61,982,'186.30.133.207','2020-03-02 17:10:25'),(62,6312,'186.30.133.207','2020-03-02 17:10:30'),(63,6312,'186.30.133.207','2020-03-02 17:10:32'),(64,3220,'186.30.133.207','2020-03-02 21:04:36'),(65,3220,'186.30.133.207','2020-03-02 21:04:36'),(66,3220,'186.30.133.207','2020-03-02 21:04:37'),(67,3220,'186.30.133.207','2020-03-02 21:05:56'),(68,3220,'186.30.133.207','2020-03-02 21:06:58'),(69,3220,'186.102.10.106','2020-03-02 21:07:44'),(70,3220,'186.102.10.106','2020-03-02 21:07:52'),(71,3220,'186.30.133.207','2020-03-02 21:07:57'),(72,3217,'186.30.133.207','2020-03-02 21:08:09'),(73,3219,'45.7.134.178','2020-03-02 21:08:16'),(74,7141,'181.132.36.95','2020-03-02 21:08:18'),(75,3219,'45.7.134.178','2020-03-02 21:08:25'),(76,3219,'45.7.134.178','2020-03-02 21:08:37'),(77,3219,'45.7.134.178','2020-03-02 21:08:38'),(78,3219,'45.7.134.178','2020-03-02 21:08:38'),(79,2897,'179.18.26.198','2020-03-03 00:11:02'),(80,918,'179.18.26.198','2020-03-03 00:11:06'),(81,882,'179.18.26.198','2020-03-03 00:11:25'),(82,2896,'179.18.26.198','2020-03-03 00:11:29'),(83,2989,'179.18.26.198','2020-03-03 00:11:37'),(84,1916,'181.132.36.95','2020-03-03 14:31:31'),(85,1916,'181.132.36.95','2020-03-03 14:32:02'),(86,1623,'181.132.36.95','2020-03-03 14:32:40'),(87,4049,'186.28.205.133','2020-03-03 19:50:07'),(88,1755,'186.28.205.133','2020-03-03 19:50:39'),(89,1749,'186.28.205.133','2020-03-03 19:50:42'),(90,1749,'186.28.205.133','2020-03-03 19:50:48'),(91,514,'186.28.205.133','2020-03-03 19:50:50'),(92,1736,'186.28.205.133','2020-03-03 19:50:54'),(93,1890,'186.28.205.133','2020-03-03 19:50:57'),(94,282,'186.28.205.133','2020-03-03 19:50:59'),(95,6826,'186.28.205.133','2020-03-03 19:57:44'),(96,1872,'186.28.205.133','2020-03-03 19:57:46'),(97,285,'186.28.205.133','2020-03-03 19:57:48'),(98,1916,'186.28.205.133','2020-03-03 19:57:51'),(99,1916,'186.28.205.133','2020-03-03 19:58:02'),(100,1623,'186.28.205.133','2020-03-03 19:58:08'),(101,1610,'186.28.205.133','2020-03-03 19:58:15'),(102,1881,'186.28.205.133','2020-03-03 19:58:38'),(103,4599,'186.28.205.133','2020-03-03 19:58:40'),(104,4599,'186.28.205.133','2020-03-03 19:58:45'),(105,8579,'186.28.205.133','2020-03-03 20:02:52'),(106,6404,'186.28.205.133','2020-03-03 20:02:54'),(107,8579,'186.28.205.133','2020-03-03 20:02:58'),(108,970,'186.28.205.133','2020-03-03 20:03:02'),(109,944,'186.28.205.133','2020-03-03 20:03:07'),(110,5925,'186.28.205.133','2020-03-03 20:03:09'),(111,6902,'186.28.205.133','2020-03-03 21:21:42'),(112,6902,'186.28.205.133','2020-03-03 21:21:46'),(113,1684,'186.28.205.133','2020-03-03 21:21:48'),(114,7166,'186.28.205.133','2020-03-03 22:02:47'),(115,7151,'186.28.205.133','2020-03-03 22:02:53'),(116,7193,'186.28.205.133','2020-03-03 22:03:17'),(117,8636,'186.28.205.133','2020-03-03 22:06:54'),(118,8636,'186.28.205.133','2020-03-03 22:07:41'),(119,2321,'186.28.205.133','2020-03-03 22:08:08'),(120,5834,'186.28.205.133','2020-03-03 22:12:26'),(121,5834,'186.28.205.133','2020-03-03 22:12:29'),(122,4049,'186.102.54.17','2020-03-03 22:25:09'),(123,4049,'186.102.54.17','2020-03-03 22:25:10'),(124,4049,'186.102.54.17','2020-03-03 22:25:25'),(125,4049,'186.102.54.17','2020-03-03 22:25:26'),(126,4049,'186.102.54.17','2020-03-03 22:25:40'),(127,4049,'186.102.54.17','2020-03-03 22:25:41'),(128,2004,'186.102.54.17','2020-03-03 22:40:23'),(129,2004,'186.102.54.17','2020-03-03 22:40:47'),(130,2004,'186.102.54.17','2020-03-03 22:40:49'),(131,2004,'186.102.54.17','2020-03-03 22:41:33'),(132,2004,'186.102.54.17','2020-03-03 22:42:18'),(133,1831,'186.28.205.133','2020-03-03 23:07:34'),(134,517,'186.28.205.133','2020-03-03 23:07:36'),(135,1724,'186.28.205.133','2020-03-03 23:10:00'),(136,1774,'186.28.205.133','2020-03-03 23:10:04'),(137,2004,'186.102.54.17','2020-03-03 23:33:39'),(138,2004,'186.102.54.17','2020-03-03 23:33:50'),(139,2004,'186.102.54.17','2020-03-03 23:35:43'),(140,2004,'186.102.54.17','2020-03-03 23:36:00'),(141,2004,'186.102.54.17','2020-03-03 23:36:12'),(142,2004,'186.102.54.17','2020-03-03 23:36:21'),(143,1801,'186.28.205.133','2020-03-04 00:06:27'),(144,3064,'186.28.205.133','2020-03-04 00:06:33'),(145,6801,'186.28.205.133','2020-03-04 00:06:45'),(146,4604,'186.28.205.133','2020-03-04 00:07:04'),(147,6756,'186.28.205.133','2020-03-04 00:08:13'),(148,1926,'186.28.205.133','2020-03-04 00:08:17'),(149,1684,'186.28.205.133','2020-03-04 00:08:21'),(150,6822,'186.28.205.133','2020-03-04 00:29:59'),(151,3064,'186.28.205.133','2020-03-04 00:30:01'),(152,6801,'186.28.205.133','2020-03-04 00:30:04'),(153,6756,'186.28.205.133','2020-03-04 00:30:08'),(154,8338,'186.28.205.133','2020-03-04 00:30:20'),(155,8353,'186.28.205.133','2020-03-04 00:30:23'),(156,7226,'186.28.205.133','2020-03-04 00:30:26'),(157,7214,'186.28.205.133','2020-03-04 00:30:28'),(158,3109,'186.28.205.133','2020-03-04 00:40:24'),(159,6312,'186.28.205.133','2020-03-04 00:59:17'),(160,4596,'186.154.71.154','2020-03-04 14:16:46'),(161,4596,'186.154.71.154','2020-03-04 14:16:49'),(162,1801,'186.29.17.110','2020-03-04 16:45:54'),(163,1801,'186.29.17.110','2020-03-04 16:46:10'),(164,876,'186.29.17.110','2020-03-04 16:46:35'),(165,1118,'186.29.17.110','2020-03-04 16:46:55'),(166,1118,'186.29.17.110','2020-03-04 16:47:12'),(167,1118,'186.29.17.110','2020-03-04 16:47:15'),(168,1113,'186.29.17.110','2020-03-04 16:47:20'),(169,1209,'186.29.17.110','2020-03-04 16:47:28'),(170,1997,'186.29.17.110','2020-03-04 16:47:47'),(171,1997,'186.29.17.110','2020-03-04 16:47:48'),(172,5834,'186.29.17.110','2020-03-04 16:47:56'),(173,3109,'186.29.17.110','2020-03-04 16:59:07'),(174,3109,'186.29.17.110','2020-03-04 16:59:09'),(175,3109,'186.29.17.110','2020-03-04 16:59:09'),(176,3109,'186.29.17.110','2020-03-04 16:59:19'),(177,3109,'186.29.17.110','2020-03-04 16:59:19'),(178,884,'186.29.17.110','2020-03-04 16:59:45'),(179,3109,'186.29.17.110','2020-03-04 17:05:04'),(180,8687,'181.132.36.95','2020-03-04 17:48:04'),(181,8687,'181.132.36.95','2020-03-04 17:48:34'),(182,6373,'181.132.36.95','2020-03-04 17:50:57'),(183,6257,'181.132.36.95','2020-03-04 17:53:46'),(184,2321,'181.132.36.95','2020-03-04 20:47:25'),(185,7159,'181.132.36.95','2020-03-04 20:50:36'),(186,5830,'181.132.36.95','2020-03-04 20:51:16'),(187,3220,'191.64.158.253','2020-03-04 23:07:21'),(188,3220,'191.64.158.253','2020-03-04 23:07:23'),(189,7230,'186.102.27.239','2020-03-05 16:18:50'),(190,3727,'186.102.27.239','2020-03-05 16:19:07'),(191,7171,'186.102.27.239','2020-03-05 16:19:25'),(192,1977,'186.102.27.239','2020-03-05 16:22:02'),(193,5763,'186.102.27.239','2020-03-05 16:22:05'),(194,5762,'186.102.27.239','2020-03-05 16:22:06'),(195,1977,'186.102.27.239','2020-03-05 16:22:14'),(196,1977,'186.102.27.239','2020-03-05 16:22:17'),(197,6842,'186.30.48.75','2020-03-05 16:40:01'),(198,6842,'186.30.48.75','2020-03-05 16:40:10'),(199,1763,'186.30.48.75','2020-03-05 16:44:09'),(200,1854,'186.30.48.75','2020-03-05 16:44:24'),(201,1834,'186.30.48.75','2020-03-05 16:44:30'),(202,1854,'186.30.48.75','2020-03-05 16:44:35'),(203,1855,'191.95.160.147','2020-03-09 15:59:42'),(204,6806,'191.95.160.147','2020-03-09 15:59:48'),(205,876,'191.95.160.147','2020-03-09 16:00:38'),(206,2915,'191.95.160.147','2020-03-09 16:00:41'),(207,874,'191.95.160.147','2020-03-09 16:00:55'),(208,6113,'191.95.160.147','2020-03-09 16:01:11'),(209,230,'191.95.160.147','2020-03-09 16:01:37'),(210,645,'191.95.160.147','2020-03-09 16:01:44'),(211,230,'191.95.160.147','2020-03-09 16:01:51'),(212,982,'191.95.160.147','2020-03-09 16:02:18'),(213,5974,'191.95.160.147','2020-03-09 16:02:25'),(214,982,'191.95.160.147','2020-03-09 16:02:28'),(215,6312,'191.95.160.147','2020-03-09 16:02:34'),(216,5928,'191.95.160.147','2020-03-09 16:02:44'),(217,5928,'191.95.160.147','2020-03-09 16:02:46'),(218,1003,'191.95.160.147','2020-03-09 16:02:50'),(219,8338,'191.95.160.147','2020-03-09 16:03:20'),(220,8460,'191.95.160.147','2020-03-09 16:03:24'),(221,5830,'191.95.160.147','2020-03-09 16:05:00'),(222,2883,'191.95.160.147','2020-03-09 16:05:06'),(223,5757,'191.95.160.147','2020-03-09 16:05:29'),(224,1976,'191.95.160.147','2020-03-09 16:05:44'),(225,1980,'191.95.160.147','2020-03-09 16:05:48'),(226,1974,'191.95.160.147','2020-03-09 16:05:54'),(227,1976,'191.95.160.147','2020-03-09 16:05:58'),(228,1977,'191.95.160.147','2020-03-09 16:06:03'),(229,5756,'191.95.160.147','2020-03-09 16:06:19'),(230,1980,'191.95.160.147','2020-03-09 16:17:04'),(231,3220,'191.95.160.147','2020-03-09 16:18:48'),(232,3217,'191.95.160.147','2020-03-09 16:18:54'),(233,3221,'191.95.160.147','2020-03-09 16:18:58'),(234,3218,'191.95.160.147','2020-03-09 16:19:03'),(235,2456,'191.95.160.147','2020-03-09 16:28:55'),(236,2428,'191.95.160.147','2020-03-09 16:28:58'),(237,2292,'191.95.160.147','2020-03-09 16:29:02'),(238,2854,'191.95.160.147','2020-03-09 16:29:27'),(239,2858,'191.95.160.147','2020-03-09 16:29:38'),(240,2856,'191.95.160.147','2020-03-09 16:29:43'),(241,8636,'186.30.135.197','2020-03-09 16:43:04'),(242,1933,'191.95.160.147','2020-03-09 17:39:11'),(243,1834,'191.95.160.147','2020-03-09 17:39:14'),(244,1830,'191.95.160.147','2020-03-09 17:39:43'),(245,1830,'191.95.160.147','2020-03-09 17:39:57'),(246,6969,'191.95.160.147','2020-03-09 17:40:17'),(247,3247,'191.95.160.147','2020-03-09 17:40:24'),(248,247,'191.95.160.147','2020-03-09 17:40:27'),(249,1839,'191.95.160.147','2020-03-09 17:41:47'),(250,4487,'191.95.160.147','2020-03-09 17:41:58'),(251,1661,'191.95.160.147','2020-03-09 17:42:04'),(252,1871,'191.95.160.147','2020-03-09 17:42:09'),(253,1653,'191.95.160.147','2020-03-09 17:42:12'),(254,4487,'191.95.160.147','2020-03-09 17:42:15'),(255,7180,'161.18.147.113','2020-03-10 02:57:00'),(256,7147,'161.18.147.113','2020-03-10 02:57:12'),(257,7147,'161.18.147.113','2020-03-10 02:57:22'),(258,6312,'191.95.160.223','2020-03-10 15:26:44'),(259,1671,'181.61.208.106','2020-03-11 00:25:10'),(260,1671,'181.61.208.106','2020-03-11 00:26:44'),(261,1981,'191.95.160.7','2020-03-11 16:32:10'),(262,5925,'201.244.43.119','2020-03-11 20:31:25'),(263,1831,'201.244.43.119','2020-03-11 22:51:10'),(264,1831,'186.154.13.39','2020-03-16 16:02:01'),(265,7166,'186.154.13.39','2020-03-16 16:08:48'),(266,7166,'186.154.13.39','2020-03-16 16:09:08'),(267,7166,'186.154.13.39','2020-03-16 16:09:09'),(268,7151,'186.154.13.39','2020-03-16 16:09:38'),(269,7151,'186.154.13.39','2020-03-16 16:10:36'),(270,7149,'186.154.13.39','2020-03-16 16:11:01'),(271,5757,'191.95.167.98','2020-03-16 16:43:24'),(272,1959,'191.95.167.98','2020-03-16 16:43:36'),(273,8346,'186.154.13.39','2020-03-16 19:15:16'),(274,2879,'191.95.167.98','2020-03-16 19:29:26'),(275,1831,'191.95.167.98','2020-03-16 19:46:26'),(276,1825,'191.95.167.98','2020-03-16 19:46:29'),(277,1653,'191.95.167.98','2020-03-16 19:46:31'),(278,6960,'191.95.167.98','2020-03-16 19:46:33'),(279,3040,'191.95.167.98','2020-03-16 19:47:26'),(280,3040,'191.95.167.98','2020-03-16 19:47:28'),(281,1980,'191.95.167.98','2020-03-16 20:22:59'),(282,1959,'191.95.167.98','2020-03-16 20:23:06'),(283,1959,'191.95.167.98','2020-03-16 20:23:09'),(284,1984,'191.95.167.98','2020-03-16 20:23:12'),(285,1984,'191.95.167.98','2020-03-16 20:23:15'),(286,1959,'191.95.167.98','2020-03-16 20:23:16'),(287,1984,'191.95.167.98','2020-03-16 20:23:20'),(288,6402,'191.95.167.98','2020-03-16 20:23:43'),(289,6064,'191.95.167.98','2020-03-16 20:23:51'),(290,8336,'191.95.167.98','2020-03-16 20:24:08'),(291,7141,'191.95.167.98','2020-03-16 20:24:12'),(292,7167,'181.234.214.21','2020-03-17 17:30:28'),(293,8352,'181.234.214.21','2020-03-17 17:30:42'),(294,920,'190.66.211.104','2020-03-18 20:50:09'),(295,920,'190.66.211.104','2020-03-18 20:50:13'),(296,3043,'190.66.211.104','2020-03-18 20:50:16'),(297,3220,'190.66.211.104','2020-03-18 20:51:05'),(298,3218,'190.66.211.104','2020-03-18 20:51:11'),(299,1203,'181.62.15.228','2020-03-18 22:37:33'),(300,2002,'181.62.15.228','2020-03-18 22:37:46'),(301,2000,'181.62.15.228','2020-03-18 22:37:53'),(302,2009,'181.62.15.228','2020-03-18 22:38:01'),(303,1995,'181.62.15.228','2020-03-18 22:38:11'),(304,2000,'181.62.15.228','2020-03-18 22:38:37'),(305,2000,'181.62.15.228','2020-03-18 22:38:52'),(306,1995,'181.62.15.228','2020-03-18 22:39:08'),(307,1995,'181.62.15.228','2020-03-18 22:39:36'),(308,2000,'181.62.15.228','2020-03-18 22:39:50'),(309,6123,'181.62.15.228','2020-03-18 22:50:32'),(310,1117,'181.62.15.228','2020-03-18 22:53:08'),(311,6123,'181.62.15.228','2020-03-18 22:53:17'),(312,1117,'181.62.15.228','2020-03-18 22:53:43'),(313,3027,'181.62.15.228','2020-03-18 22:56:14'),(314,2004,'181.62.15.228','2020-03-18 23:22:07'),(315,6113,'181.62.15.228','2020-03-18 23:22:28'),(316,6113,'181.62.15.228','2020-03-18 23:22:54'),(317,1206,'181.62.15.228','2020-03-18 23:23:00'),(318,2004,'181.62.15.228','2020-03-19 09:53:10'),(319,1203,'181.62.15.228','2020-03-19 09:59:30'),(320,1991,'181.62.15.228','2020-03-19 10:00:33'),(321,1991,'181.62.15.228','2020-03-19 10:00:40'),(322,6121,'181.62.15.228','2020-03-19 10:00:49'),(323,1993,'181.62.15.228','2020-03-19 10:17:15'),(324,1996,'181.62.15.228','2020-03-19 10:17:24'),(325,2004,'181.62.15.228','2020-03-19 10:17:28'),(326,6113,'181.62.15.228','2020-03-19 10:17:34'),(327,1119,'181.62.15.228','2020-03-19 10:17:37'),(328,1112,'181.62.15.228','2020-03-19 10:17:48'),(329,1112,'181.62.15.228','2020-03-19 10:18:11'),(330,1112,'181.62.15.228','2020-03-19 10:22:54'),(331,1112,'181.62.15.228','2020-03-19 10:23:17'),(332,1203,'181.62.15.228','2020-03-19 10:37:49'),(333,6121,'181.62.15.228','2020-03-19 10:38:01'),(334,1108,'181.62.15.228','2020-03-19 11:00:55'),(335,6060,'181.62.15.228','2020-03-19 11:01:23'),(336,888,'181.62.15.228','2020-03-19 11:09:58'),(337,2984,'181.62.15.228','2020-03-19 11:10:01'),(338,3043,'181.62.15.228','2020-03-19 11:10:07'),(339,2943,'181.62.15.228','2020-03-19 11:12:56'),(340,888,'181.62.15.228','2020-03-19 11:20:00'),(341,2984,'181.62.15.228','2020-03-19 11:20:03'),(342,5757,'191.95.160.71','2020-03-19 21:07:31'),(343,5757,'191.95.160.71','2020-03-19 21:08:15'),(344,5757,'191.95.160.71','2020-03-19 21:08:15'),(345,1960,'191.95.160.71','2020-03-19 21:08:15'),(346,5757,'191.95.160.71','2020-03-19 21:08:17'),(347,957,'191.95.160.71','2020-03-19 21:24:52'),(348,5978,'191.95.160.71','2020-03-19 21:25:02'),(349,5989,'191.95.160.71','2020-03-19 21:25:33'),(350,1012,'191.95.160.71','2020-03-19 21:25:43'),(351,5994,'191.95.160.71','2020-03-19 21:25:46'),(352,5943,'191.95.160.71','2020-03-19 21:25:54'),(353,983,'191.95.160.71','2020-03-19 21:25:58'),(354,8687,'191.95.160.71','2020-03-19 21:28:52'),(355,5830,'191.95.160.71','2020-03-19 21:45:36'),(356,2004,'181.62.15.228','2020-03-24 09:22:27'),(357,2004,'181.62.15.228','2020-03-24 10:27:22'),(358,1108,'181.62.15.228','2020-03-24 10:54:55'),(359,2007,'181.62.15.228','2020-03-24 10:55:15'),(360,268,'181.62.15.228','2020-03-24 15:19:06'),(361,1203,'181.62.15.228','2020-03-24 15:35:37'),(362,5754,'190.67.225.96','2020-03-24 22:21:14'),(363,900,'190.67.225.96','2020-03-24 22:52:43'),(364,3036,'190.67.225.96','2020-03-24 23:02:43'),(365,3029,'190.67.225.96','2020-03-24 23:03:13'),(366,3037,'190.67.225.96','2020-03-24 23:03:54'),(367,7180,'190.67.225.96','2020-03-25 14:28:24'),(368,7180,'190.67.225.96','2020-03-25 14:40:04'),(369,7180,'190.67.225.96','2020-03-25 14:40:18'),(370,33,'186.113.163.48','2020-03-26 00:00:36'),(371,2005,'186.113.163.48','2020-03-26 00:01:09'),(372,504,'186.113.163.48','2020-03-26 01:10:30'),(373,1,'181.62.15.228','2020-03-26 15:55:00'),(374,2847,'186.113.163.48','2020-03-26 16:47:59'),(375,1210,'186.113.163.48','2020-03-26 17:31:36'),(376,1202,'186.113.163.48','2020-03-26 17:41:35'),(377,2007,'186.113.163.48','2020-03-26 17:41:44'),(378,1202,'186.113.163.48','2020-03-26 17:41:51'),(379,1220,'186.113.163.48','2020-03-26 17:42:17'),(380,1208,'186.113.163.48','2020-03-26 17:42:20'),(381,1112,'186.113.163.48','2020-03-26 17:42:25'),(382,1,'186.113.163.48','2020-03-26 17:42:56'),(383,888,'181.62.15.228','2020-03-27 01:07:39'),(384,5465,'181.62.15.228','2020-03-27 01:15:23'),(385,8477,'181.62.15.228','2020-03-27 01:24:25'),(386,22,'181.62.15.228','2020-03-27 01:34:14'),(387,5674,'181.62.15.228','2020-03-27 01:34:21'),(388,4049,'190.24.69.250','2020-03-27 19:06:31'),(389,1673,'190.24.69.250','2020-03-27 20:56:05'),(390,513,'190.24.69.250','2020-03-27 21:00:20'),(391,513,'190.24.69.250','2020-03-27 21:00:45'),(392,1917,'190.24.69.250','2020-03-27 21:05:31'),(393,1917,'190.24.69.250','2020-03-27 21:07:08'),(394,2005,'179.32.132.63','2020-03-27 22:22:19'),(395,1210,'179.32.132.63','2020-03-27 22:22:25'),(396,5762,'186.155.19.71','2020-03-27 22:32:49'),(397,5762,'186.155.19.71','2020-03-27 22:33:12'),(398,5762,'186.155.19.71','2020-03-27 22:36:34'),(399,5762,'186.155.19.71','2020-03-27 22:37:00'),(400,5762,'186.155.19.71','2020-03-27 22:46:04'),(401,2891,'186.155.19.71','2020-03-27 22:46:06'),(402,5762,'186.155.19.71','2020-03-27 22:46:09'),(403,504,'179.32.132.63','2020-03-27 22:47:08'),(404,6923,'179.32.132.63','2020-03-27 22:48:19'),(405,5762,'186.155.19.71','2020-03-27 22:51:36'),(406,5762,'186.155.19.71','2020-03-27 22:51:58'),(407,5762,'186.155.19.71','2020-03-27 22:52:45'),(408,8579,'186.155.19.71','2020-03-27 22:56:12'),(409,8579,'186.155.19.71','2020-03-27 23:05:33'),(410,2005,'179.32.132.63','2020-03-30 03:08:20'),(411,2139,'179.32.132.63','2020-03-30 15:21:03'),(412,7163,'179.32.132.63','2020-03-30 15:21:30'),(413,936,'45.7.134.178','2020-03-30 20:28:52'),(414,8710,'45.7.134.178','2020-03-30 20:48:33'),(415,1917,'181.62.15.228','2020-03-31 13:31:37'),(416,2141,'190.254.133.122','2020-04-01 22:54:06'),(417,8356,'190.254.133.122','2020-04-02 14:13:05'),(418,6252,'190.254.133.122','2020-04-02 16:37:54'),(419,5832,'190.254.133.122','2020-04-02 16:38:22'),(420,5832,'190.254.133.122','2020-04-02 16:41:45'),(421,5832,'190.254.133.122','2020-04-02 16:41:52'),(422,5625,'190.254.133.122','2020-04-02 16:42:28'),(423,2127,'190.254.133.122','2020-04-02 16:43:12'),(424,2005,'190.254.133.122','2020-04-02 20:03:18'),(425,2847,'190.254.133.122','2020-04-02 20:51:50'),(426,1,'190.254.133.122','2020-04-02 21:06:56'),(427,1776,'186.28.60.57','2020-04-03 13:31:23'),(428,5625,'190.254.133.122','2020-04-03 14:21:49'),(429,8519,'190.254.133.122','2020-04-03 14:58:32'),(430,2079,'190.254.133.122','2020-04-03 16:28:57'),(431,917,'190.254.133.122','2020-04-03 16:53:46'),(432,6345,'190.254.133.122','2020-04-03 16:54:11'),(433,6252,'190.254.133.122','2020-04-03 17:54:48'),(434,1,'190.254.133.122','2020-04-03 17:56:18'),(435,2139,'190.254.133.122','2020-04-03 22:22:34'),(436,1586,'190.254.133.122','2020-04-03 22:25:59'),(437,1,'190.254.133.122','2020-04-03 22:38:39'),(438,1,'179.32.138.241','2020-04-06 13:23:40'),(439,2005,'161.18.42.26','2020-04-06 20:33:58'),(440,4485,'161.18.42.26','2020-04-06 20:42:16'),(441,1,'181.234.206.148','2020-04-13 15:25:12'),(442,6351,'191.95.149.243','2020-04-13 15:38:28'),(443,20,'191.95.149.243','2020-04-13 16:01:08'),(444,20,'191.95.149.243','2020-04-13 16:05:48'),(445,806,'191.95.149.243','2020-04-13 16:10:25'),(446,816,'191.95.149.243','2020-04-13 16:10:29'),(447,5669,'191.95.149.243','2020-04-13 16:13:54'),(448,2091,'191.95.149.243','2020-04-13 16:14:05'),(449,2092,'191.95.149.243','2020-04-13 16:14:15'),(450,2112,'181.234.206.148','2020-04-13 21:04:30'),(451,936,'45.7.134.178','2020-04-15 00:51:13'),(452,1983,'45.7.134.178','2020-04-15 12:30:47'),(453,8710,'45.7.134.178','2020-04-15 12:32:29'),(454,970,'45.7.134.178','2020-04-15 16:28:52'),(455,8353,'190.24.64.58','2020-04-17 13:17:44'),(456,7219,'190.24.64.58','2020-04-17 13:18:25'),(457,7147,'190.24.64.58','2020-04-17 13:30:33'),(458,4019,'191.106.141.131','2020-04-17 16:43:53'),(459,3487,'191.106.141.131','2020-04-17 16:44:10'),(460,6700,'190.24.64.58','2020-04-17 19:55:32'),(461,4489,'190.24.64.58','2020-04-17 20:05:54'),(462,4489,'190.24.64.58','2020-04-17 20:06:40'),(463,2021,'190.24.64.58','2020-04-17 20:07:54'),(464,7800,'45.7.134.178','2020-04-18 12:49:46'),(465,8713,'45.7.134.178','2020-04-18 15:42:30'),(466,5669,'191.95.149.243','2020-04-19 16:00:58'),(467,5669,'191.95.149.243','2020-04-19 16:01:07'),(468,7341,'191.95.149.243','2020-04-19 16:09:46'),(469,8292,'191.95.149.243','2020-04-19 16:09:51'),(470,6351,'191.95.149.243','2020-04-19 16:17:05'),(471,5669,'191.95.149.243','2020-04-19 16:27:31'),(472,2091,'191.95.149.243','2020-04-19 16:27:41'),(473,2092,'191.95.149.243','2020-04-19 16:31:22'),(474,5669,'191.95.149.243','2020-04-19 16:31:31'),(475,2092,'191.95.149.243','2020-04-19 16:40:16'),(476,5669,'191.95.149.243','2020-04-19 16:52:15'),(477,2091,'191.95.149.243','2020-04-19 16:52:41'),(478,2092,'191.95.149.243','2020-04-19 16:55:32'),(479,5669,'191.95.149.243','2020-04-22 01:29:38'),(480,2091,'191.95.149.243','2020-04-22 01:29:44'),(481,2092,'191.95.149.243','2020-04-22 01:29:47'),(482,5538,'191.95.149.243','2020-04-22 01:31:04'),(483,5513,'191.95.149.243','2020-04-22 01:31:13'),(484,1915,'201.244.136.191','2020-04-22 19:13:11'),(485,1917,'201.244.136.191','2020-04-22 19:26:05'),(486,20,'191.95.149.243','2020-04-23 20:02:13'),(487,1205,'181.62.15.228','2020-04-27 20:29:10'),(488,6115,'181.62.15.228','2020-04-27 20:29:25'),(489,1208,'161.18.151.131','2020-04-27 20:29:27'),(490,2011,'181.62.15.228','2020-04-27 20:29:28'),(491,1208,'181.62.15.228','2020-04-27 20:30:33'),(492,1220,'161.18.151.131','2020-04-27 20:31:03'),(493,1220,'161.18.151.131','2020-04-27 20:31:38'),(494,1776,'181.62.15.228','2020-04-27 20:39:26'),(495,2467,'161.18.151.131','2020-04-27 21:11:58'),(496,2467,'161.18.151.131','2020-04-27 21:17:04'),(497,2874,'161.18.151.131','2020-04-27 21:28:50'),(498,2905,'201.244.136.191','2020-04-28 14:11:03'),(499,8340,'190.252.157.148','2020-04-28 14:37:22'),(500,8340,'190.252.157.148','2020-04-28 15:04:35'),(501,3044,'201.244.136.191','2020-04-28 18:24:17'),(502,6320,'201.244.136.191','2020-04-28 18:24:48'),(503,6826,'181.62.15.228','2020-04-28 21:49:15'),(504,6404,'190.252.157.148','2020-04-28 23:00:34'),(505,1602,'181.234.202.227','2020-04-29 16:22:33'),(506,3032,'181.234.202.227','2020-04-29 16:23:21'),(507,2004,'181.234.202.227','2020-04-29 16:32:50'),(508,1661,'181.234.202.227','2020-04-29 18:13:21'),(509,1871,'181.234.202.227','2020-04-29 18:13:27'),(510,1922,'181.234.202.227','2020-04-29 18:13:33'),(511,517,'181.234.202.227','2020-04-29 18:13:49'),(512,1774,'181.234.202.227','2020-04-29 18:14:02'),(513,1661,'181.234.202.227','2020-04-29 18:14:40'),(514,1653,'181.234.202.227','2020-04-29 18:14:49'),(515,1770,'181.234.202.227','2020-04-29 18:14:57'),(516,1871,'181.234.202.227','2020-04-29 18:15:09'),(517,1661,'181.234.202.227','2020-04-29 18:15:45'),(518,2004,'181.62.15.228','2020-04-29 20:17:10'),(519,1214,'181.234.202.227','2020-04-29 21:12:19'),(520,1585,'181.234.202.227','2020-04-29 21:19:41'),(521,6216,'201.244.136.191','2020-04-30 15:21:57'),(522,5472,'201.244.136.191','2020-04-30 15:22:53'),(523,6219,'201.244.136.191','2020-04-30 16:08:01'),(524,2054,'181.62.15.228','2020-05-03 15:44:22'),(525,2004,'181.62.15.228','2020-05-03 17:30:19'),(526,2004,'181.62.15.228','2020-05-03 17:30:24'),(527,24,'181.62.15.228','2020-05-03 17:31:17'),(528,18,'181.62.15.228','2020-05-03 17:31:52'),(529,16,'181.62.15.228','2020-05-03 17:32:10'),(530,18,'181.62.15.228','2020-05-03 17:32:17'),(531,8222,'181.62.15.228','2020-05-03 17:42:57'),(532,3028,'190.26.139.27','2020-05-03 19:46:03'),(533,5464,'181.62.15.228','2020-05-03 20:40:33'),(534,6227,'181.62.15.228','2020-05-03 20:47:29'),(535,7805,'181.62.15.228','2020-05-03 20:56:36'),(536,7147,'181.62.15.228','2020-05-03 21:07:51'),(537,2761,'181.62.15.228','2020-05-03 21:08:35'),(538,2508,'181.62.15.228','2020-05-03 21:08:42'),(539,24,'181.234.252.237','2020-05-04 13:47:38'),(540,2401,'181.234.252.237','2020-05-04 13:56:03'),(541,1589,'181.234.252.237','2020-05-04 16:05:57'),(542,512,'181.234.252.237','2020-05-04 22:46:03'),(543,5829,'181.234.252.237','2020-05-04 22:48:35'),(544,5840,'181.234.252.237','2020-05-04 22:48:47'),(545,2874,'181.234.252.237','2020-05-04 22:49:13'),(546,1118,'181.62.15.228','2020-05-05 06:34:09'),(547,2369,'181.62.15.228','2020-05-05 06:36:01'),(548,2369,'181.62.15.228','2020-05-05 06:36:05'),(549,2848,'181.62.15.228','2020-05-05 06:36:25'),(550,2004,'181.62.15.228','2020-05-05 06:41:00'),(551,2004,'181.62.15.228','2020-05-05 06:47:51'),(552,2004,'181.62.15.228','2020-05-05 06:48:25'),(553,2004,'181.62.15.228','2020-05-05 06:49:00'),(554,2004,'181.62.15.228','2020-05-05 06:54:23'),(555,2004,'181.62.15.228','2020-05-05 06:54:58'),(556,2004,'181.62.15.228','2020-05-05 06:55:23'),(557,2131,'181.62.15.228','2020-05-05 06:55:46'),(558,2943,'161.18.135.67','2020-05-05 14:18:31'),(559,2884,'161.18.135.67','2020-05-05 14:38:04'),(560,8364,'161.18.135.67','2020-05-05 14:41:52'),(561,970,'161.18.135.67','2020-05-05 14:57:53'),(562,2884,'161.18.135.67','2020-05-05 15:03:00'),(563,2442,'161.18.135.67','2020-05-05 15:14:22'),(564,1587,'161.18.135.67','2020-05-05 16:29:59'),(565,7180,'186.154.39.167','2020-05-05 16:31:08'),(566,7147,'186.154.39.167','2020-05-05 16:38:10'),(567,1743,'161.18.135.67','2020-05-05 16:38:42'),(568,5451,'161.18.135.67','2020-05-05 16:39:43'),(569,8606,'161.18.135.67','2020-05-05 16:40:07'),(570,8665,'161.18.135.67','2020-05-05 17:13:23'),(571,8710,'161.18.135.67','2020-05-05 17:13:36'),(572,8710,'161.18.135.67','2020-05-05 17:13:52'),(573,24,'181.62.15.228','2020-05-05 17:42:43'),(574,2004,'181.62.15.228','2020-05-05 18:08:34'),(575,2004,'181.62.15.228','2020-05-05 18:11:27'),(576,7219,'181.62.15.228','2020-05-05 18:13:57'),(577,6205,'190.24.64.126','2020-05-05 20:31:25'),(578,6219,'190.24.64.126','2020-05-05 20:37:45'),(579,1604,'186.102.8.62','2020-05-05 23:17:16'),(580,7075,'186.102.8.62','2020-05-05 23:17:20'),(581,2004,'190.66.223.16','2020-05-06 01:31:28'),(582,1752,'190.66.223.16','2020-05-06 01:31:59'),(583,7180,'190.66.223.16','2020-05-06 13:48:21'),(584,5834,'190.66.223.16','2020-05-06 14:01:08'),(585,3030,'190.66.223.16','2020-05-06 14:08:05'),(586,3029,'190.66.223.16','2020-05-06 14:08:19'),(587,3029,'190.66.223.16','2020-05-06 14:09:14'),(588,3029,'190.66.223.16','2020-05-06 14:12:26'),(589,4601,'190.66.223.16','2020-05-06 14:54:13'),(590,2138,'190.66.223.16','2020-05-06 14:58:22'),(591,2875,'177.252.190.204','2020-05-06 14:58:27'),(592,23,'177.252.190.204','2020-05-06 14:59:20'),(593,6380,'181.62.15.228','2020-05-06 15:07:14'),(594,266,'177.252.190.204','2020-05-06 15:09:36'),(595,2851,'177.252.190.204','2020-05-06 15:09:52'),(596,2860,'177.252.190.204','2020-05-06 15:09:55'),(597,8710,'181.51.34.227','2020-05-06 21:04:47'),(598,8710,'190.24.64.126','2020-05-06 21:05:42'),(599,8710,'190.24.64.126','2020-05-06 21:06:17'),(600,8710,'190.24.64.126','2020-05-06 21:10:04'),(601,1977,'181.53.12.44','2020-05-06 23:30:55'),(602,6119,'181.53.12.44','2020-05-06 23:35:01'),(603,6119,'181.53.12.44','2020-05-06 23:35:09'),(604,1298,'181.53.12.44','2020-05-06 23:35:11'),(605,4489,'190.66.223.16','2020-05-08 01:07:51'),(606,7163,'190.252.53.161','2020-05-08 18:22:20'),(607,8710,'181.118.158.186','2020-05-08 22:23:01'),(608,584,'186.86.52.234','2020-05-11 11:38:37'),(609,585,'186.86.52.234','2020-05-11 11:44:25'),(610,585,'186.86.52.234','2020-05-11 11:46:45'),(611,2884,'181.234.238.156','2020-05-11 14:43:37'),(612,5829,'181.234.238.156','2020-05-11 14:47:38'),(613,6344,'181.234.238.156','2020-05-11 14:50:10'),(614,7147,'181.234.238.156','2020-05-11 15:20:47'),(615,6394,'181.234.238.156','2020-05-11 15:31:09'),(616,5463,'181.234.238.156','2020-05-11 16:02:37'),(617,6382,'181.62.15.228','2020-05-11 16:14:06'),(618,5463,'181.62.15.228','2020-05-11 16:14:17'),(619,6208,'181.62.15.228','2020-05-11 16:14:25'),(620,3030,'181.234.238.156','2020-05-11 17:04:40'),(621,5622,'186.144.10.131','2020-05-11 20:42:21'),(622,877,'45.177.109.154','2020-05-11 21:12:17'),(623,864,'45.177.109.154','2020-05-11 21:12:19'),(624,1763,'45.177.109.154','2020-05-11 21:18:58'),(625,6374,'186.84.104.25','2020-05-11 22:55:00'),(626,6373,'186.84.104.25','2020-05-11 22:56:30'),(627,2004,'181.234.238.156','2020-05-12 02:19:06'),(628,5461,'191.95.132.21','2020-05-12 13:08:52'),(629,2015,'81.40.231.201','2020-05-12 13:40:10'),(630,1529,'81.40.231.201','2020-05-12 13:40:18'),(631,921,'81.40.231.201','2020-05-12 13:40:47'),(632,2942,'81.40.231.201','2020-05-12 13:40:53'),(633,919,'81.40.231.201','2020-05-12 13:40:56'),(634,4494,'181.234.238.156','2020-05-12 18:56:53'),(635,4494,'181.234.238.156','2020-05-12 19:04:29'),(636,4494,'181.234.238.156','2020-05-12 20:08:38'),(637,4494,'186.31.158.215','2020-05-12 21:08:11'),(638,18,'186.154.37.95','2020-05-13 00:38:38'),(639,8579,'45.177.109.154','2020-05-13 22:00:52'),(640,1656,'45.177.109.154','2020-05-13 22:02:50'),(641,4595,'186.84.22.58','2020-05-13 22:10:41'),(642,5451,'45.177.109.154','2020-05-13 22:12:16'),(643,5755,'190.24.64.126','2020-05-14 15:13:12'),(644,263,'190.24.64.126','2020-05-14 15:13:15'),(645,263,'190.24.64.126','2020-05-14 15:13:36'),(646,1173,'186.86.52.177','2020-05-14 16:41:14'),(647,5860,'191.89.53.96','2020-05-15 01:39:19'),(648,1037,'191.89.53.96','2020-05-15 01:40:23'),(649,5855,'191.89.53.96','2020-05-15 01:40:34'),(650,1587,'200.118.46.237','2020-05-15 03:14:55'),(651,5590,'200.118.46.237','2020-05-15 03:15:12'),(652,5587,'200.118.46.237','2020-05-15 03:15:20'),(653,5621,'200.118.46.237','2020-05-15 03:15:30'),(654,5583,'200.118.46.237','2020-05-15 03:15:34'),(655,1814,'45.177.109.154','2020-05-15 12:28:54'),(656,1987,'45.177.109.154','2020-05-15 12:32:17'),(657,6203,'190.24.64.126','2020-05-15 16:50:40'),(658,6203,'190.24.64.126','2020-05-15 16:50:44'),(659,7219,'167.0.161.231','2020-05-15 20:01:05'),(660,13,'191.95.149.243','2020-05-15 20:02:55'),(661,6110,'191.95.149.243','2020-05-15 20:02:58'),(662,2093,'191.95.149.243','2020-05-15 20:03:02'),(663,5759,'191.95.149.243','2020-05-15 20:03:09'),(664,248,'181.62.15.228','2020-05-15 20:52:45'),(665,6063,'181.62.15.228','2020-05-15 20:53:42'),(666,2877,'181.62.15.228','2020-05-15 20:54:06'),(667,5829,'186.82.84.79','2020-05-16 00:57:25'),(668,1776,'179.15.107.1','2020-05-17 03:10:55'),(669,6351,'179.15.107.1','2020-05-17 03:14:33'),(670,20,'179.15.107.1','2020-05-17 03:15:08'),(671,2985,'181.58.39.160','2020-05-18 01:43:45'),(672,1387,'186.84.21.217','2020-05-19 15:47:45'),(673,1387,'186.84.21.217','2020-05-19 15:47:45'),(674,1387,'186.84.21.217','2020-05-19 15:48:25'),(675,7216,'186.84.21.217','2020-05-19 16:02:24'),(676,7216,'186.84.21.217','2020-05-19 16:23:51'),(677,2842,'186.84.21.217','2020-05-19 16:25:07'),(678,1387,'186.84.21.217','2020-05-19 16:27:00'),(679,916,'181.118.158.186','2020-05-19 20:13:58'),(680,3044,'181.118.158.186','2020-05-19 20:44:24'),(681,2004,'181.62.15.228','2020-05-20 00:51:28'),(682,2004,'181.62.15.228','2020-05-20 01:05:26'),(683,1776,'181.62.15.228','2020-05-20 01:06:12'),(684,914,'190.68.51.17','2020-05-20 14:21:17'),(685,3044,'181.118.158.186','2020-05-20 19:35:33');

--
-- Table structure for table `puntos_incidencias`
--

CREATE TABLE `puntos_incidencias` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_incidencia` int(11) NOT NULL,
  `id_punto` int(11) NOT NULL,
  `id_user` int(11) DEFAULT NULL,
  `detalle` text,
  `fecha_creacion` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `puntos_incidencias`
--

INSERT INTO `puntos_incidencias` VALUES (1,3,1,NULL,'Esto es una prueba','2020-03-24 16:12:41'),(2,1,1,NULL,'Esto es una prueba','2020-03-24 16:21:12'),(3,1,2001,NULL,'jghgjgh','2020-03-24 16:24:57'),(4,1,7180,NULL,'En la ubicación no se encuentra un contenedor','2020-03-25 14:29:54'),(5,1,1,1,'esto es una ptueba, de envíos de correos.','2020-03-26 15:55:17'),(6,1,1,1,'esto es una prueba, de envíos de correos.','2020-03-26 15:55:26'),(7,1,1,1,'esto es una prueba, de envíos de correos.','2020-03-26 15:55:28'),(8,1,1,1,'esto es una prueba, de envíos de correos.','2020-03-26 15:55:35'),(9,1,1,1,'esto es una prueba, de envíos de correos.','2020-03-26 15:55:54'),(10,1,1,1,'esto es una prueba, de envíos de correos.','2020-03-26 15:55:57'),(11,1,1,1,'esto es una prueba, de envíos de correos.','2020-03-26 15:58:13'),(12,2,1,1,'Esta dañado. ','2020-03-26 17:43:37'),(13,4,1917,NULL,'El señor fue grosero','2020-03-27 21:06:25'),(14,4,1917,NULL,'El señor fue grosero','2020-03-27 21:06:34'),(15,2,7163,1,'No le sirve la tapa al contenedor','2020-03-30 15:22:04'),(16,2,7163,1,'No le sirve la tapa al contenedor','2020-03-30 15:22:08'),(17,2,7163,1,'No le sirve la tapa al contenedor','2020-03-30 15:22:11'),(18,3,1,3470,'El contenedor está lleno. ','2020-04-02 21:07:31'),(19,2,1,3441,'Se daño el contenedor','2020-04-03 17:56:44'),(20,2,1,3441,'Se daño el contenedor','2020-04-03 17:56:46'),(21,3,1,3470,'El contenedor es muy pequeño y se llena rápido.','2020-04-03 22:39:33'),(22,3,1,3471,'El contenedor es muy pequeño y se llena rápido','2020-04-13 15:25:48'),(23,1,1915,1,'Hola no lo encontré','2020-04-22 19:14:19'),(24,2,2467,3494,'los contenedores están rotos ','2020-04-27 21:15:12'),(25,3,8340,3495,'El contenedor es muy pequeño y se llena muy rápido.','2020-04-28 15:15:49'),(26,6,3032,3470,'Prueba Natura Software','2020-04-29 16:23:47'),(27,2,7147,NULL,'czxczxczxczxc','2020-05-03 21:08:11'),(28,6,2401,3503,'Prueba Natura','2020-05-04 13:58:11'),(29,2,8710,3510,'El contenedor esta dañado','2020-05-05 17:14:10'),(30,6,3029,NULL,'Incidencia de prueba','2020-05-06 14:10:25'),(31,6,5829,3522,'prueba','2020-05-11 14:47:53'),(32,2,2004,3526,'El contenedor está rito en la parte superior. ','2020-05-12 02:20:08'),(33,2,4494,3441,'Es una prueba','2020-05-12 20:08:59'),(34,1,5451,3488,'na','2020-05-13 22:12:42');

--
-- Table structure for table `recolectores`
--

CREATE TABLE `recolectores` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(200) NOT NULL,
  `password` varchar(255) NOT NULL,
  `nombres` varchar(150) NOT NULL,
  `apellidos` varchar(150) DEFAULT NULL,
  `tipo_documento` int(11) NOT NULL,
  `documento` varchar(50) NOT NULL,
  `correo` varchar(200) NOT NULL,
  `playerId` varchar(255) NOT NULL,
  `telefono_fijo` varchar(150) DEFAULT NULL,
  `telefono_celular` varchar(150) DEFAULT NULL,
  `direccion` varchar(255) NOT NULL,
  `dir_dato_adicional` varchar(255) DEFAULT NULL,
  `fotografia` varchar(255) DEFAULT NULL,
  `asociacion_pertenece` varchar(255) DEFAULT NULL,
  `rutas` varchar(255) DEFAULT NULL,
  `ecas` varchar(255) DEFAULT NULL,
  `capacidad` varchar(255) DEFAULT NULL,
  `licencia_categoria` varchar(255) DEFAULT NULL,
  `licencia_vigencia` varchar(255) DEFAULT NULL,
  `licencia_foto` varchar(255) DEFAULT NULL,
  `estado` int(11) NOT NULL DEFAULT '1',
  `mu_id` int(11) DEFAULT NULL,
  `creacion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `terms` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `tipo_documento` (`tipo_documento`),
  KEY `mu_id` (`mu_id`),
  CONSTRAINT `recolectores_ibfk_1` FOREIGN KEY (`mu_id`) REFERENCES `municipios` (`id`) ON UPDATE CASCADE,
  CONSTRAINT `recolectores_ibfk_2` FOREIGN KEY (`tipo_documento`) REFERENCES `tipos_documentos` (`id`) ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `recolectores`
--

INSERT INTO `recolectores` VALUES (1,'admin@recolector.com','$2y$10$517Bn0mVxcAkfxSW.nw1FuiZnOm6OttRDShjBxDewJ.2rMBWvMGra','Juan','Recolector',1,'111110','admin@recolector.com','',NULL,NULL,'Diagonal 100 ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,107,'2020-02-27 15:27:53',2),(2,'admin@recolector2.com','$2y$10$517Bn0mVxcAkfxSW.nw1FuiZnOm6OttRDShjBxDewJ.2rMBWvMGra','Juan 2','Recolector',1,'1111102','admin2@recolector2.com','',NULL,NULL,'Diagonal 100 ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,107,'2020-02-27 15:27:53',1);

--
-- Table structure for table `residuos`
--

CREATE TABLE `residuos` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nombre` text NOT NULL,
  `detalle` text,
  `tre_id` int(11) DEFAULT NULL,
  `estado` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `tre_id` (`tre_id`),
  CONSTRAINT `residuos_ibfk_1` FOREIGN KEY (`tre_id`) REFERENCES `tipos_residuos` (`id`) ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=150 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `residuos`
--

INSERT INTO `residuos` VALUES (1,'Desechos clínicos resultantes de la atención médica prestada en hospitales,\r\ncentros médicos y clínicas',NULL,1,1),(2,'Desechos resultantes de la producción y preparación de productos\r\nfarmacéuticos',NULL,1,1),(3,'Desechos de medicamentos y productos farmacéuticos',NULL,1,1),(4,'Desechos resultantes de ¡a producción, la preparación y la utilización de\r\nbiocidas y productos fitofarmacéuticos',NULL,1,1),(5,'Desechos resultantes de la fabricación, preparación y utilización de productos\r\nquímicos para la preservación de la madera',NULL,1,1),(6,'Desechos resultantes de la producción, la preparación y la utilización de\r\ndisolventes orgánicos',NULL,1,1),(7,'Desechos, que contengan cianuros, resultantes del tratamiento térmico y\r\nlas operaciones de temple',NULL,1,1),(8,'Desechos de aceites minerales no aptos para el uso a que estaban destinados',NULL,1,1),(9,'Mezclas y emulsiones de desechos de aceite y agua o de hidrocarburos y\r\nagua',NULL,1,1),(10,'Sustancias y artículos de desecho que contengan, o estén contaminados por,\r\nbifeniíos policlorados (PCB), terfeniios policlorados (PCT) o bifeniíos polibromados\r\n(PBB)',NULL,1,1),(11,'Residuos alquitranados resultantes de la refinación, destilación o cualquier\r\notro tratamiento pirolítico',NULL,1,1),(12,'Desechos resultantes de la producción, preparación y utilización de tintas,\r\ncolorantes, pigmentos, pinturas, lacas o barnices ',NULL,1,1),(13,'Desechos resultantes de la producción, preparación y utilización de resinas, látex, plastificantes o colas y adhesivos',NULL,1,1),(14,'Sustancias químicas de desecho, no identificadas o nuevas, resultantes de la\r\ninvestigación y el desarrollo o de las actividades de enseñanza y cuyos efectos en\r\nel ser humano o el medio ambiente no se conozcan',NULL,1,1),(15,'Desechos de carácter explosivo que no estén sometidos a una legislación\r\ndiferente',NULL,1,1),(16,'Desechos resultantes de la producción; preparación y utilización de productos químicos y materiales para fines fotográficos',NULL,1,1),(17,'Desechos resultantes del tratamiento de superficie de metales y plásticos',NULL,1,1),(18,'Residuos resultantes de las operaciones de eliminación de desechos industriales',NULL,1,1),(19,'Metales carbonilos',NULL,1,1),(20,'Berilio, compuestos de berilio',NULL,1,1),(21,'Compuestos de cromo hexavalente',NULL,1,1),(22,'Compuestos de cobre',NULL,1,1),(23,'Compuestos de zinc',NULL,1,1),(24,'Arsénico, compuestos de arsénico',NULL,1,1),(25,'Selenio, compuestos de selenio',NULL,1,1),(26,'Cadmio, compuestos de cadmio',NULL,1,1),(27,'Antimonio, compuestos de antimonio',NULL,1,1),(28,'Telurio, compuestos de telurio',NULL,1,1),(29,'Mercurio, compuestos de mercurio',NULL,1,1),(30,'Talio, compuestos de talío',NULL,1,1),(31,'Plomo, compuestos de plomo',NULL,1,1),(32,'Compuestos inorgánicos de flúor, con exclusión del fluoruro calcico',NULL,1,1),(33,'Cianuros inorgánicos',NULL,1,1),(34,'Soluciones ácidas o ácidos en forma sólida',NULL,1,1),(35,'Soluciones básicas o bases en forma sólida',NULL,1,1),(36,'Asbesto (polvo y fibras)',NULL,1,1),(37,'Compuestos orgánicos de fósforo',NULL,1,1),(38,'Cianuros orgánicos',NULL,1,1),(39,'Fenoles, compuestos fenólicos, con inclusión de clorofenoles',NULL,1,1),(40,'Éteres',NULL,1,1),(41,'Solventes orgánicos halogenados',NULL,1,1),(42,'Disolventes orgánicos, con exclusión de disolventes halogenados',NULL,1,1),(43,'Cualquier sustancia del grupo de los dibenzofuranos policlorados',NULL,1,1),(44,'Cualquier sustancia del grupo de las dibenzoparadioxinas policloradas',NULL,1,1),(45,'Compuestos organohalogenados, que no sean las sustancias mencionadas en el presente anexo (por ejemplo, Y39, Y41, Y42, Y43, Y44).',NULL,1,1),(46,'Desechos metálicos y desechos que contengan aleaciones de cualquiera de las sustancias siguientes:\r\nAntimonio\r\nArsénico\r\nBerilio\r\nCadmio\r\nPlomo\r\n- Mercurio\r\nSelenio\r\nTelurio\r\n- Talio ',NULL,1,1),(47,'Desechos que tengan como constituyentes o contaminantes, excluidos los\r\ndesechos de metal en forma masiva, cualquiera de las sustancias siguientes:\r\nAntimonio; compuestos de antimonio Berilio; compuestos de berilio\r\nCadmio; compuestos de cadmio\r\nPlomo; compuestos de plomo\r\nSelenio; compuestos de selenio\r\nTelurio; compuestos de telurio',NULL,1,1),(48,'Desechos que tengan como constituyentes o contaminantes cualquiera de\r\nlas sustancias siguientes:\r\nArsénico; compuestos de arsénico Mercurio;\r\ncompuestos de mercurio Talio; compuestos de talio',NULL,1,1),(49,'Desechos que tengan como constituyentes:\r\n- Carbonilos de metal\r\nCompuestos de cromo hexavalente ',NULL,1,1),(50,'Lodos galvánicos ',NULL,1,1),(51,'Líquidos de desecho del decapaje de metales',NULL,1,1),(52,'Líquidos de desecho del decapaje de metales',NULL,1,1),(53,'Residuos de lixiviación del tratamiento del zinc, polvos y lodos como jarosita,\r\nhematites, etc. ',NULL,1,1),(54,'Residuos de desechos de zinc no incluidos en la lista B, que contengan plomo y\r\ncadmio en concentraciones tales que presenten características del anexo III',NULL,1,1),(55,'Cenizas de la incineración de cables de cobre recubiertos ',NULL,1,1),(56,'Polvos y residuos de los sistemas de depuración de gases de las\r\nfundiciones de cobre',NULL,1,1),(57,'Soluciones electrolíticas usadas de las operaciones de refinación y\r\nextracción electrolítica dei cobre',NULL,1,1),(58,'Lodos residuales, excluidos los fangos anódicos, de los sistemas de\r\ndepuración electrolítica de las operaciones de refinación y extracción\r\nelectrolítica del cobre',NULL,1,1),(59,'Soluciones de ácidos para grabar usadas que contengan cobre disuelto',NULL,1,1),(60,'Desechos de catalizadores de cloruro cúprico y cianuro de cobre',NULL,1,1),(61,'Cenizas de metales preciosos procedentes de la incineración de circuitos\r\nimpresos no incluidos en la lista B3',NULL,1,1),(62,'Acumuladores de plomo de desecho, enteros o triturados ',NULL,1,1),(63,'Acumuladores de desecho sin seleccionar excluidas mezclas de\r\nacumuladores sólo de la lista B. Los acumuladores de desecho no incluidos\r\nen la lista B que contengan constituyentes del anexo I en tal grado que los\r\nconviertan en peligrosos',NULL,1,1),(64,'Montajes eléctricos y electrónicos de desecho o restos de éstos4\r\n que\r\ncontengan componentes como acumuladores y otras baterías incluidos en la\r\nlista A, interruptores de mercurio, vidrios de tubos de rayos catódicos y otros\r\nvidrios activados y capacitadores de PCB, o contaminados con constituyentes\r\ndel anexo I (por ejemplo, cadmio, mercurio, plomo, bifenilo policlorado) en tal\r\ngrado que posean alguna de las características del anexo III (véase la entrada\r\ncorrespondiente en la lista BB1110)5',NULL,1,1),(65,'Desechos de vidrio de tubos de rayos catódicos y otros vidrios activados',NULL,1,1),(66,'Desechos de compuestos inorgánicos de flúor en forma de líquidos o lodos,\r\npero excluidos los desechos de ese tipo especificados en la lista B',NULL,1,1),(67,'Desechos de catalizadores, pero excluidos los desechos de este tipo\r\nespecificados en la lista B',NULL,1,1),(68,'Yeso de desecho procedente de procesos de la industria química, si contiene\r\nconstituyentes del anexo I en tal grado que presenten una característica\r\npeligrosa del anexo III (véase la entrada correspondiente en la lista B B2080) ',NULL,1,1),(69,'Desechos de amianto (polvo y fibras) ',NULL,1,1),(70,'Cenizas volantes de centrales eléctricas de carbón que contengan sustancias\r\ndel anexo I en concentraciones tales que presenten características del anexo III (véase\r\nia entrada correspondiente en la lista B B2050) ',NULL,1,1),(71,'Desechos resultantes de la producción o el tratamiento de coque de petróleo y\r\nasfalto',NULL,1,1),(72,'Aceites minerales de desecho no aptos para el uso al que estaban destinados',NULL,1,1),(73,' Desechos que contengan, estén integrados o estén contaminados por lodos\r\nde compuestos antidetonantes con plomo ',NULL,1,1),(74,'Desechos de líquidos térmicos (transferencia de calor)',NULL,1,1),(75,'Desechos resultantes de la producción, preparación y utilización de resinas,\r\nlátex, plastificantes o colas/adhesivos excepto los desechos especificados\r\nen la lista B (véase el apartado correspondiente en la lista B B4020) ',NULL,1,1),(76,'Nitrocelulosa de desecho',NULL,1,1),(77,'Desechos de fenoles, compuestos fenólicos, incluido el clorofenol en forma de\r\nlíquido o de lodo ',NULL,1,1),(78,'Desechos de éteres excepto los especificados en la lista B',NULL,1,1),(79,'Desechos de cuero en forma de polvo, cenizas, Iodos y harinas que contengan\r\ncompuestos de plomo hexavalente o biocidas (véase el apartado\r\ncorrespondiente en la lista B B3100)',NULL,1,1),(80,'Raeduras y otros desechos del cuero o de cuero regenerado que no sirvan para\r\nla fabricación de artículos de cuero, que contengan compuestos de cromo\r\nhexavalente o biocidas (véase el apartado correspondiente en la lista B B3090)',NULL,1,1),(81,'Desechos del curtido de pieles que contengan compuestos de cromo\r\nhexavalente o biocidas o sustancias infecciosas (véase el apartado\r\ncorrespondiente en la lista B B3110)',NULL,1,1),(82,'Pelusas - fragmentos ligeros resultantes del desmenuzamiento',NULL,1,1),(83,'Desechos de compuestos de fósforo orgánicos',NULL,1,1),(84,'Desechos de disolventes orgánicos no halogenados pero con exclusión de\r\nlos desechos especificados en la lista B',NULL,1,1),(85,'Desechos de disolventes orgánicos halogenados',NULL,1,1),(86,'Desechos resultantes de residuos no acuosos de destilación halogenados o no\r\nhalogenados derivados de operaciones de recuperación de disolventes\r\norgánicos',NULL,1,1),(87,'Desechos resultantes de la producción de hidrocarburos halogenados alifáticos\r\n(tales como clorometano, dicloroetano, cloruro de vinilo, cloruro de alilo y\r\nepicloridrina)',NULL,1,1),(88,'Desechos, sustancias y artículos que contienen, consisten o están contaminados\r\ncon bifenilo policlorado (PCB), terfenilo policlorado (PCT), naftaleno policlorado\r\n(PCN) o bifenilo polibromado (PBB), o cualquier otro compuesto polibromado\r\nanálogo, con una concentración de igual o superior a 50 mg/kg6',NULL,1,1),(89,'Desechos de residuos alquitranados (con exclusión de los cementos\r\nasfálticos) resultantes de la refinación, destilación o cualquier otro\r\ntratamiento pirolítico de materiales orgánicos',NULL,1,1),(90,'Material bituminoso (desechos de asfalto) con contenido de alquitrán resultantes\r\nde la construcción y e! mantenimiento de carreteras (obsérvese el artículo\r\ncorrespondiente B2130de la lista B)',NULL,1,1),(91,'Desechos resultantes de la producción, preparación y utilización de\r\nproductos farmacéuticos, pero con exclusión de los desechos especificados\r\nen la lista B',NULL,1,1),(92,'Desechos clínicos y afines; es decir desechos resultantes de prácticas médicas,\r\nde enfermería, dentales, veterinarias o actividades similares, y desechos\r\ngenerados en hospitales u otras instalaciones durante actividades de\r\ninvestigación o el tratamiento de pacientes, o de proyectos de investigación',NULL,1,1),(93,'Desechos resultantes de la producción, ¡a preparación y la utilización de\r\nbiocidas y productos fitofarmacéuticos, con inclusión de desechos de\r\nplaguicidas y herbicidas que no respondan a las especificaciones, caducados\r\nen desuso o no aptos para el uso previsto originalmente.',NULL,1,1),(94,'Desechos resultantes de la fabricación, preparación y utilización de\r\nproductos químicos para la preservación de la madera.',NULL,1,1),(95,'Desechos que contienen, consisten o están contaminados con algunos de\r\nlos productos siguientes:\r\nCianuros inorgánicos, con excepción de residuos que contienen metales\r\npreciosos, en forma sólida, con trazas de cianuros inorgánicos\r\nCianuros orgánicos',NULL,1,1),(96,'Desechos de mezclas y emulsiones de aceite y\r\nagua o de hidrocarburos y agua',NULL,1,1),(97,'Desechos resultantes de la producción, preparación y utilización de tintas,\r\ncolorantes, pigmentos, pinturas, lacas o barnices, con exclusión de los desechos\r\nespecificados en la lista B (véase el apartado correspondiente de la lista B\r\nB4010)',NULL,1,1),(98,'Desechos de carácter explosivo (pero con exclusión de los desechos\r\nespecificados en la lista B)',NULL,1,1),(99,'Desechos de soluciones ácidas o básicas, distintas de las especificadas en el\r\napartado correspondiente de la lista B (véase el apartado correspondiente de la\r\nlista B B2120)',NULL,1,1),(100,'Desechos resultantes de la utilización de dispositivos de control de ía\r\ncontaminación industrial para la depuración de los gases industriales, pero con\r\nexclusión de los desechos especificados en la lista B',NULL,1,1),(101,'Desechos que contienen, consisten o, están contaminados con algunos de\r\nlos productos siguientes:\r\n- Cualquier sustancia de! grupo de los dibenzofuranos policlorados\r\n- Cualquier sustancia del grupo de las dibenzodioxinas policloradas',NULL,1,1),(102,'Desechos que contienen, consisten o están contaminados con peróxidos',NULL,1,1),(103,'Envases y contenedores de desechos que contienen sustancias incluidas en el\r\nanexo I, en concentraciones suficientes como para mostrar las características\r\npeligrosas del anexo III',NULL,1,1),(104,'Desechos consistentes o que contienen productos químicos que no responden\r\na las especificaciones o caducados10 correspondientes a las categorías del\r\nanexo I, y que muestran las características peligrosas del anexo III',NULL,1,1),(105,'Sustancias químicas de desecho, no identificadas o nuevas, resultantes de ia\r\ninvestigación y el desarrollo o de las actividades de enseñanza y cuyos efectos\r\nen el ser humano o el medio ambiente no se conozcan',NULL,1,1),(106,'Carbono activado consumido no incluido en la lista B (véase el\r\ncorrespondiente apartado de la lista B B2060).',NULL,1,1),(107,'Tapas',NULL,2,1),(108,'Aluminio',NULL,2,1),(109,'Chatarra',NULL,2,1),(110,'Cobre',NULL,2,1),(111,'Bronce',NULL,2,1),(112,'Antimonio',NULL,2,1),(113,'Acero',NULL,2,1),(114,'Otros metales',NULL,2,1),(115,'Archivo',NULL,2,1),(116,'Cartón',NULL,2,1),(117,'Cubetas o paneles',NULL,2,1),(118,'Periodico',NULL,2,1),(119,'Plegadiza',NULL,2,1),(120,'Tetra pack',NULL,2,1),(121,'Plastificado',NULL,2,1),(122,'Kraf',NULL,2,1),(123,'Otros papel y cartón',NULL,2,1),(124,'Acrílico',NULL,2,1),(125,'Pasta',NULL,2,1),(126,'PET',NULL,2,1),(127,'PVC',NULL,2,1),(128,'Plástico Blanco',NULL,2,1),(129,'Polietileno',NULL,2,1),(130,'Soplado',NULL,2,1),(131,'Polipropileno',NULL,2,1),(132,'Otros Plásticos',NULL,2,1),(133,'Vidrios',NULL,2,1),(134,'Otros Textiles',NULL,2,1),(135,'Madera Otros maderables',NULL,2,1),(136,'Luminarias',NULL,3,1),(137,'Ordinarios',NULL,4,1),(138,'Líquidos',NULL,5,1),(139,'Lodos',NULL,5,1),(140,'Orgánicos',NULL,6,1),(141,'RCD',NULL,7,1),(142,'Escombros',NULL,7,1),(143,'Construcción',NULL,7,1),(144,'Baterias de plomo',NULL,3,1),(145,'Medicamentos',NULL,3,1),(146,'Residuos RAEE',NULL,3,1),(147,'Plaguicidas',NULL,3,1),(148,'Pilas Usadas',NULL,3,1),(149,'Llantas Usadas',NULL,3,1);

--
-- Table structure for table `solicitudes`
--

CREATE TABLE `solicitudes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `detalle` text,
  `fecha_creacion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `fecha_recoleccion` datetime NOT NULL,
  `peso` varchar(100) DEFAULT NULL,
  `volumen` varchar(100) DEFAULT NULL,
  `direccion` varchar(255) DEFAULT NULL,
  `foto` varchar(255) DEFAULT NULL,
  `valor` varchar(100) DEFAULT NULL,
  `tipo` int(11) NOT NULL DEFAULT '1',
  `estado` int(11) NOT NULL DEFAULT '1',
  `re_id` int(11) DEFAULT NULL,
  `cl_id` int(11) NOT NULL,
  `pt_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `re_id` (`re_id`),
  KEY `cl_id` (`cl_id`),
  KEY `pt_id` (`pt_id`),
  CONSTRAINT `solicitudes_ibfk_1` FOREIGN KEY (`cl_id`) REFERENCES `clientes` (`id`) ON UPDATE CASCADE,
  CONSTRAINT `solicitudes_ibfk_2` FOREIGN KEY (`pt_id`) REFERENCES `puntos` (`id`) ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=144 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `solicitudes`
--

INSERT INTO `solicitudes` VALUES (1,'Detalle ','2019-11-01 03:36:16','2019-11-11 06:00:00',NULL,NULL,NULL,NULL,NULL,1,2,2,4,6092),(2,'Detalle ','2019-11-04 03:36:16','2019-11-11 06:00:00',NULL,NULL,NULL,NULL,NULL,1,2,2,4,6092),(3,'Detalle ','2019-11-05 03:36:16','2019-11-11 06:00:00',NULL,NULL,NULL,NULL,NULL,1,2,2,4,6092),(4,'','2019-11-12 16:23:52','2019-11-13 00:00:00','12','189',NULL,NULL,'0',1,2,1,1,1),(5,'','2019-11-12 16:25:59','2019-11-15 00:00:00','','',NULL,NULL,'0',1,2,1,1,1),(6,'','2019-11-12 17:32:03','2019-11-12 00:00:00','1425','1254',NULL,NULL,'0',1,2,1,1,1),(7,'','2019-11-12 19:54:18','2019-11-13 00:00:00','','',NULL,NULL,'0',1,2,1,1,1),(13,'Qawsedrftg yhujikolpñ','2019-12-05 15:14:06','2020-05-01 00:00:00','1234567890','1234567890',NULL,'../uploads/solicitudes/13_sol_cli_2019_12_05.jpeg','0',1,2,1,1,1),(20,'','2019-12-19 17:39:53','2019-12-20 00:00:00',NULL,NULL,'Carrera 111 #33-33',NULL,'0',1,2,NULL,3433,NULL),(21,'','2019-12-19 17:42:58','2019-12-20 00:00:00',NULL,NULL,'Carrera 111 #33-33',NULL,'0',1,1,NULL,3433,NULL),(22,'','2019-12-27 16:33:21','2019-12-31 00:00:00',NULL,NULL,'Carrera 111 #33-33',NULL,'0',1,1,NULL,3433,NULL),(23,'','2019-12-27 16:42:39','2019-12-31 00:00:00',NULL,NULL,'Carrera 111 #33-33',NULL,'0',1,1,NULL,3433,NULL),(27,'','2020-01-10 10:13:09','2020-01-12 00:00:00',NULL,NULL,'En algun lugar de Bogotá',NULL,'0',2,2,NULL,1,NULL),(28,'','2020-01-10 10:23:59','2020-01-15 00:00:00',NULL,NULL,'Cra 13 a # 34- 57',NULL,'0',2,1,NULL,3441,NULL),(29,'','2020-01-10 11:04:28','2020-01-24 00:00:00',NULL,NULL,'Cll 44# 8 50',NULL,'0',2,1,NULL,3443,NULL),(30,'','2020-01-10 11:15:48','2020-01-15 00:00:00',NULL,NULL,'calle 67# 84a 21',NULL,'0',2,1,NULL,3445,NULL),(32,'','2020-01-14 16:19:16','2020-01-18 00:00:00',NULL,NULL,'calle 67# 84a 21',NULL,'0',2,1,NULL,3445,NULL),(34,'','2020-01-14 17:52:51','2020-01-20 00:00:00',NULL,NULL,'Calle 44 #8-50',NULL,'0',2,1,NULL,3460,NULL),(35,'','2020-01-14 18:00:06','2020-01-18 00:00:00',NULL,NULL,'Diagonal 85 #32 - 56',NULL,'0',2,1,NULL,3461,NULL),(36,'','2020-01-14 18:04:52','2020-02-01 00:00:00',NULL,NULL,'Cl 45# 13-25',NULL,'0',2,2,NULL,3464,NULL),(37,'','2020-01-17 14:24:53','2020-01-20 00:00:00',NULL,NULL,'Dg 45 sur # 22-45',NULL,'0',2,1,NULL,3462,NULL),(38,NULL,'2020-01-24 09:20:02','2020-01-28 00:00:00',NULL,NULL,'xhjsnns',NULL,'0',2,1,NULL,3465,NULL),(40,NULL,'2020-01-24 11:23:40','2020-01-27 00:00:00',NULL,NULL,'Calle 45 # 13-26',NULL,'0',2,1,NULL,3466,NULL),(42,NULL,'2020-01-24 12:08:46','2020-01-25 00:00:00',NULL,NULL,'Calle 45 # 13-26',NULL,'0',2,1,NULL,3466,NULL),(43,NULL,'2020-01-24 12:35:18','2020-01-27 00:00:00',NULL,NULL,'Cra 13 a # 34- 57',NULL,'0',2,1,NULL,3441,NULL),(44,NULL,'2020-01-24 12:43:05','2020-01-27 00:00:00',NULL,NULL,'Cra 16 # 42-17',NULL,'0',2,1,NULL,3467,NULL),(46,NULL,'2020-01-30 16:59:28','2020-02-28 00:00:00',NULL,NULL,'xhjsnns',NULL,'0',2,1,NULL,3465,NULL),(50,NULL,'2020-02-23 20:29:46','2020-02-26 00:00:00',NULL,NULL,'Cr 31 Sur # 16-18',NULL,'0',2,1,NULL,1,NULL),(52,NULL,'2020-03-04 10:14:21','2020-03-07 00:00:00',NULL,NULL,'Cra 13 a # 34- 57',NULL,'0',2,1,NULL,3441,NULL),(53,NULL,'2020-03-04 18:12:32','2020-03-09 00:00:00',NULL,NULL,'Cr 31 Sur # 16-18',NULL,'0',2,1,NULL,1,NULL),(54,'Esta lleno el contenedor','2020-03-05 11:21:27','2020-03-08 00:00:00','2000','Unidad',NULL,'../uploads/solicitudes/54_sol_cli_2020_03_05.jpeg','0',1,2,1,1,8709),(55,NULL,'2020-03-06 14:07:41','2020-05-07 00:00:00',NULL,NULL,'Cll 44# 8 50',NULL,'0',2,1,NULL,3443,NULL),(56,NULL,'2020-03-09 12:15:57','2020-03-11 00:00:00',NULL,NULL,'Calle 35 sur # 93-64',NULL,'0',2,1,NULL,3470,NULL),(57,'El contenedor está lleno de pilas','2020-03-09 12:26:48','2020-03-14 00:00:00','1500','Kilogramos',NULL,'../uploads/solicitudes/57_sol_cli_2020_03_09.jpeg','0',1,2,7,1,8710),(58,NULL,'2020-03-09 22:15:33','2020-03-12 00:00:00',NULL,NULL,'Calle 35 sur # 93 64',NULL,'0',2,1,NULL,3471,NULL),(59,NULL,'2020-03-10 18:02:48','2020-03-13 00:00:00',NULL,NULL,'Calle 35 sur # 93-64',NULL,'0',2,1,NULL,3470,NULL),(60,NULL,'2020-03-10 20:00:23','2020-03-14 00:00:00',NULL,NULL,'calle 12 Cr 23-45',NULL,'0',2,1,NULL,3473,NULL),(61,NULL,'2020-03-10 20:00:30','2020-03-14 00:00:00',NULL,NULL,'calle 12 Cr 23-45',NULL,'0',2,1,NULL,3473,NULL),(62,NULL,'2020-03-11 08:34:43','2020-03-14 00:00:00',NULL,NULL,'calle 12 Cr 23-45',NULL,'0',2,1,NULL,3473,NULL),(63,NULL,'2020-03-11 10:52:48','2020-03-14 00:00:00',NULL,NULL,'Cr 31 Sur # 16-18',NULL,'0',2,1,NULL,1,NULL),(64,NULL,'2020-03-11 14:51:57','2020-03-18 00:00:00',NULL,NULL,'calle 12 Cr 23-45',NULL,'0',2,1,NULL,3474,NULL),(65,NULL,'2020-03-16 14:33:25','2020-03-19 00:00:00',NULL,NULL,'Calle 35 sur # 93 - 64',NULL,'0',2,1,NULL,3476,NULL),(66,NULL,'2020-03-16 14:40:02','2020-03-19 00:00:00',NULL,NULL,'Cra 13 a # 34- 57',NULL,'0',2,1,NULL,3477,NULL),(67,'El material se encuentra en bolsas y cajas ','2020-03-16 14:59:27','2020-03-20 00:00:00','100','Toneladas',NULL,'../uploads/solicitudes/67_sol_cli_2020_03_16.jpeg','0',1,2,1,1,8709),(68,NULL,'2020-03-16 15:18:21','2020-03-20 00:00:00',NULL,NULL,'Calle 35 sur # 93-64',NULL,'0',2,1,NULL,3470,NULL),(69,'Contenedor de pilas nuevos ','2020-03-16 15:20:44','2020-03-25 00:00:00','1000','Unidad',NULL,'../uploads/solicitudes/69_sol_cli_2020_03_16.jpeg','0',1,2,1,1,8709),(70,NULL,'2020-03-16 15:26:53','2020-03-21 00:00:00',NULL,NULL,'Cra 13 a # 34- 57',NULL,'0',2,1,NULL,3441,NULL),(71,NULL,'2020-03-18 15:57:01','2020-03-30 00:00:00',NULL,NULL,'Cra 13 a # 34- 57',NULL,'0',2,1,NULL,3441,NULL),(72,NULL,'2020-03-18 16:00:33','2020-04-05 00:00:00',NULL,NULL,'Cra 13 a # 34- 57',NULL,'0',2,1,NULL,3441,NULL),(73,NULL,'2020-03-18 16:02:23','2020-03-21 00:00:00',NULL,NULL,'Calle 35 sur # 93-64',NULL,'0',2,1,NULL,3470,NULL),(74,NULL,'2020-03-30 15:37:35','2020-04-11 00:00:00',NULL,NULL,'calle 12 Cr 23-45',NULL,'0',2,1,NULL,3473,NULL),(75,NULL,'2020-04-03 17:35:27','2020-04-08 00:00:00',NULL,NULL,'Calle 35 sur # 93-64',NULL,'0',2,1,NULL,3470,NULL),(76,'Icopor','2020-04-03 17:48:15','2020-04-07 00:00:00','1500','Kilogramos',NULL,'../uploads/solicitudes/76_sol_cli_2020_04_03.jpeg','0',1,2,3,1,1),(77,NULL,'2020-04-13 10:23:02','2020-04-15 00:00:00',NULL,NULL,'Calle 35 sur # 93 64',NULL,'0',2,1,NULL,3471,NULL),(78,NULL,'2020-04-13 15:42:10','2020-05-13 00:00:00',NULL,NULL,'Cra 13 a # 34- 57',NULL,'0',2,1,NULL,3477,NULL),(79,'Pilas','2020-04-13 18:02:58','2020-04-15 00:00:00','430','Unidad',NULL,'../uploads/solicitudes/79_sol_cli_2020_04_13.jpeg','0',1,2,3,1,8692),(80,'Pilas','2020-04-17 08:29:06','2020-04-19 00:00:00','2500','Unidad',NULL,'../uploads/solicitudes/80_sol_cli_2020_04_17.jpeg','0',1,2,3,1,1),(81,NULL,'2020-04-18 10:58:56','2020-04-21 00:00:00',NULL,NULL,'Calle 2 # 5 -09',NULL,'0',2,1,NULL,3489,NULL),(82,NULL,'2020-04-18 11:30:29','2020-04-22 00:00:00',NULL,NULL,'Calle 2 # 5 -09',NULL,'0',2,1,NULL,3489,NULL),(83,NULL,'2020-04-22 15:22:08','2020-04-26 00:00:00',NULL,NULL,'Cra 13 a # 34- 57',NULL,'0',2,1,NULL,3441,NULL),(84,'','2020-04-24 09:06:20','2020-04-25 00:00:00','200','Libras',NULL,'../uploads/solicitudes/84_sol_cli_2020_04_24.jpeg','0',1,2,3,1,1),(85,NULL,'2020-04-27 15:12:56','2020-04-30 00:00:00',NULL,NULL,'calle 65 H 09-04',NULL,'0',2,1,NULL,3492,NULL),(86,NULL,'2020-04-27 16:11:12','2020-04-30 00:00:00',NULL,NULL,'calle 45 n 48-65',NULL,'0',2,1,NULL,3494,NULL),(87,NULL,'2020-04-28 09:33:04','2020-05-03 00:00:00',NULL,NULL,'Calle 35 Sur # 93 - 64',NULL,'0',2,1,NULL,3495,NULL),(88,NULL,'2020-04-28 12:22:54','2020-05-03 00:00:00',NULL,NULL,'Calle 34 # 17 -06',NULL,'0',2,1,NULL,3496,NULL),(89,NULL,'2020-04-28 14:46:11','2020-05-05 00:00:00',NULL,NULL,'Cra 10 # 5 -13',NULL,'0',2,1,NULL,3497,NULL),(90,'ninguno','2020-04-29 11:05:59','2020-05-29 00:00:00','30','Kilogramos',NULL,'../uploads/solicitudes/90_sol_cli_2020_04_29.jpeg','0',1,2,1,1,8709),(91,NULL,'2020-04-29 11:21:53','2020-05-10 00:00:00',NULL,NULL,'Calle 35 sur # 93-64',NULL,'0',2,1,NULL,3470,NULL),(92,NULL,'2020-04-29 12:02:54','2020-05-05 00:00:00',NULL,NULL,'Cra 18 j # 69 f 15 sur',NULL,'0',2,1,NULL,3499,NULL),(93,NULL,'2020-04-29 12:17:05','2020-05-07 00:00:00',NULL,NULL,'Diagonal 16 a -15 ',NULL,'0',2,1,NULL,3500,NULL),(94,'Contenedor con pilas.','2020-04-29 13:10:05','2020-05-02 00:00:00','500','Libras',NULL,'../uploads/solicitudes/94_sol_cli_2020_04_29.jpeg','0',1,2,1,3502,8715),(95,NULL,'2020-04-30 11:52:51','2020-05-31 00:00:00',NULL,NULL,'Calle 35 sur # 93-64',NULL,'0',2,1,NULL,3470,NULL),(96,NULL,'2020-05-04 08:40:39','2020-05-06 00:00:00',NULL,NULL,'Calle 35 Sur # 93 - 64',NULL,'0',2,1,NULL,3503,NULL),(97,NULL,'2020-05-04 10:15:40','2020-05-07 00:00:00',NULL,NULL,'Calle 4 # 23 - 07',NULL,'0',2,1,NULL,3504,NULL),(98,'Contenedor de Pilas','2020-05-04 10:57:25','2020-05-06 00:00:00','38','Libras',NULL,'../uploads/solicitudes/98_sol_cli_2020_05_04.jpeg','0',1,1,5,1,8712),(99,'Contenedor de Medicamentos','2020-05-04 11:04:40','2020-05-10 00:00:00','50','Libras',NULL,'../uploads/solicitudes/99_sol_cli_2020_05_04.jpeg','0',1,1,3,1,8692),(100,NULL,'2020-05-05 09:17:16','2020-05-06 00:00:00',NULL,NULL,'Calle 35 Sur # 93 -60',NULL,'0',2,1,NULL,3508,NULL),(101,'Medicamentos','2020-05-05 10:13:31','2020-05-07 00:00:00','50','Libras',NULL,'../uploads/solicitudes/101_sol_cli_2020_05_05.jpeg','0',1,1,3,1,8692),(102,'Contenedor Pilas','2020-05-05 11:28:54','2020-05-07 00:00:00','2500','Unidad',NULL,'../uploads/solicitudes/102_sol_cli_2020_05_05.jpeg','0',1,2,3,1,1),(103,NULL,'2020-05-05 12:09:37','2020-05-08 00:00:00',NULL,NULL,'Calle 100 # 7 -36',NULL,'0',2,1,NULL,3510,NULL),(104,NULL,'2020-05-05 16:18:22','2020-05-08 00:00:00',NULL,NULL,'Carrera 18 m 65 d 36',NULL,'0',2,1,NULL,3512,NULL),(105,NULL,'2020-05-05 16:47:17','2020-05-11 00:00:00',NULL,NULL,'Carrera 33asdasd',NULL,'0',2,1,NULL,3506,NULL),(106,NULL,'2020-05-06 09:00:36','2020-05-09 00:00:00',NULL,NULL,'Calle 35 Sur # 93 - 64',NULL,'0',2,1,NULL,3503,NULL),(107,NULL,'2020-05-06 09:50:56','2020-05-09 00:00:00',NULL,NULL,'Calle 35 sur # 93 - 76',NULL,'0',2,1,NULL,3516,NULL),(108,'Prueba','2020-05-10 13:47:34','2020-05-12 00:00:00','12','Kilogramos',NULL,'../uploads/solicitudes/108_sol_cli_2020_05_10.jpeg','0',1,1,3,1,1),(109,'Gosdfsdfsdf','2020-05-10 13:49:49','2020-06-10 00:00:00','12','Kilogramos',NULL,'../uploads/solicitudes/109_sol_cli_2020_05_10.jpeg','0',1,1,1,1,8709),(110,'','2020-05-10 13:57:33','1969-12-31 00:00:00','12','Kilogramos',NULL,'../uploads/solicitudes/110_sol_cli_2020_05_10.jpeg','0',1,1,3,1,1),(111,'','2020-05-10 14:00:31','2020-05-22 00:00:00','12','Toneladas',NULL,'../uploads/solicitudes/111_sol_cli_2020_05_10.jpeg','0',1,1,1,1,8711),(112,NULL,'2020-05-10 14:23:09','2020-05-22 00:00:00',NULL,NULL,'Carrera 33asdasd',NULL,'0',2,1,NULL,3506,NULL),(113,'','2020-05-10 15:47:34','2020-05-28 00:00:00','12','Libras',NULL,'../uploads/solicitudes/113_sol_cli_2020_05_10.jpeg','0',1,1,3,1,1),(114,NULL,'2020-05-11 09:42:03','2020-05-14 00:00:00',NULL,NULL,'Calle 35 # 93 -64',NULL,'0',2,1,NULL,3522,NULL),(115,NULL,'2020-05-11 10:56:24','2020-05-11 00:00:00',NULL,NULL,'are sdfsdf',NULL,'0',2,1,NULL,3507,NULL),(116,NULL,'2020-05-11 11:02:16','2020-05-15 00:00:00',NULL,NULL,'Calle 35 # 93 -64',NULL,'0',2,1,NULL,3522,NULL),(117,'Contenedor Pilas','2020-05-11 12:03:34','2020-05-18 00:00:00','20','Libras',NULL,'../uploads/solicitudes/117_sol_cli_2020_05_11.jpeg','0',1,1,11,3524,8716),(118,'Pilas','2020-05-11 12:43:18','2020-05-12 00:00:00','700','Unidad',NULL,'../uploads/solicitudes/118_sol_cli_2020_05_11.jpeg','0',1,1,11,3524,8716),(119,'Pilas','2020-05-11 21:29:29','2020-05-13 00:00:00','30','Libras',NULL,'../uploads/solicitudes/119_sol_cli_2020_05_11.jpeg','0',1,1,1,1,8709),(120,NULL,'2020-05-13 17:11:31','2020-05-15 00:00:00',NULL,NULL,'Calle 2 # 5-09',NULL,'0',2,1,NULL,3488,NULL),(121,NULL,'2020-05-13 17:11:39','2020-05-15 00:00:00',NULL,NULL,'Calle 2 # 5-09',NULL,'0',2,1,NULL,3488,NULL),(122,NULL,'2020-05-13 17:22:03','2020-05-22 00:00:00',NULL,NULL,'Calle 2 # 5-09',NULL,'0',2,1,NULL,3488,NULL),(123,NULL,'2020-05-13 17:25:18','2020-05-21 00:00:00',NULL,NULL,'Calle 2 # 5-09',NULL,'0',2,1,NULL,3488,NULL),(124,NULL,'2020-05-13 17:34:55','2020-05-21 00:00:00',NULL,NULL,'Calle 34 # 17 -06',NULL,'0',2,1,NULL,3496,NULL),(125,'Nada ','2020-05-13 17:47:54','2020-05-21 00:00:00','1','Unidad',NULL,'../uploads/solicitudes/125_sol_cli_2020_05_13.','0',1,1,2,1,8692),(126,'Pilas ','2020-05-14 09:55:17','2020-05-14 00:00:00','250','Unidad',NULL,'../uploads/solicitudes/126_sol_cli_2020_05_14.jpeg','0',1,1,2,1,8692),(127,NULL,'2020-05-14 15:27:37','2020-05-20 00:00:00',NULL,NULL,'Calle 35 Sur # 93 - 64',NULL,'0',2,1,NULL,3503,NULL),(128,NULL,'2020-05-14 17:54:59','2020-05-19 00:00:00',NULL,NULL,'Cl 35 93 64',NULL,'0',2,1,NULL,3434,NULL),(129,'Pilas','2020-05-15 11:13:52','2020-05-18 00:00:00','40','Libras',NULL,'../uploads/solicitudes/129_sol_cli_2020_05_15.jpeg','0',1,1,7,1,8710),(130,NULL,'2020-05-15 12:57:19','2020-05-20 00:00:00',NULL,NULL,'Cl 35 93 64',NULL,'0',2,1,NULL,3434,NULL),(131,NULL,'2020-05-15 15:57:37','2020-05-20 00:00:00',NULL,NULL,'TV 78 H Bis # 41 C 48',NULL,'0',2,1,NULL,3527,NULL),(132,NULL,'2020-05-15 15:59:54','2020-05-27 00:00:00',NULL,NULL,'carrera',NULL,'0',2,1,NULL,3528,NULL),(133,NULL,'2020-05-18 10:04:02','2020-05-20 00:00:00',NULL,NULL,'Cra 13 a # 34- 57',NULL,'0',2,1,NULL,3441,NULL),(134,NULL,'2020-05-19 11:17:02','2020-05-22 00:00:00',NULL,NULL,'Calle 2 # 5-09',NULL,'0',2,1,NULL,3488,NULL),(135,NULL,'2020-05-19 11:19:21','2020-05-22 00:00:00',NULL,NULL,'Calle 67 # 84A 21',NULL,'0',2,1,NULL,3489,NULL),(136,NULL,'2020-05-19 11:44:53','2020-05-20 00:00:00',NULL,NULL,'Carrera 33asdasd',NULL,'0',2,1,NULL,3506,NULL),(137,NULL,'2020-05-19 15:12:52','2020-06-19 00:00:00',NULL,NULL,'Calle 35 Sur # 93 - 64',NULL,'0',2,1,NULL,3503,NULL),(138,NULL,'2020-05-19 15:18:23','2020-05-22 00:00:00',NULL,NULL,'Cra 13 a # 34- 57',NULL,'0',2,1,NULL,3441,NULL),(139,NULL,'2020-05-19 15:22:38','2020-05-25 00:00:00',NULL,NULL,'Cra 13 # 34-16',NULL,'0',2,1,NULL,3478,NULL),(140,NULL,'2020-05-20 09:38:01','2020-07-20 00:00:00',NULL,NULL,'Cra 13 a # 34- 57',NULL,'0',2,1,NULL,3477,NULL),(141,NULL,'2020-05-20 09:40:52','2020-07-20 00:00:00',NULL,NULL,'Cra 13 a # 34- 57',NULL,'0',2,1,NULL,3477,NULL),(142,NULL,'2020-05-20 09:50:14','2020-06-18 00:00:00',NULL,NULL,'Cl 35 93 64',NULL,'0',2,1,NULL,3434,NULL),(143,'Pilas','2020-05-20 09:51:44','2020-07-20 00:00:00','65','Libras',NULL,'../uploads/solicitudes/143_sol_cli_2020_05_20.jpeg','0',1,1,7,1,8710);

--
-- Table structure for table `subsolicitudes`
--

CREATE TABLE `subsolicitudes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `codigo` varchar(50) DEFAULT NULL,
  `cantidad` varchar(100) DEFAULT NULL,
  `medida` varchar(50) DEFAULT NULL,
  `tipo_embalaje` varchar(255) DEFAULT NULL,
  `detalle` text,
  `foto` varchar(255) DEFAULT NULL,
  `valor` varchar(100) DEFAULT NULL,
  `tipo` int(11) DEFAULT NULL,
  `estado` int(11) NOT NULL DEFAULT '1',
  `mensaje` text,
  `so_id` int(11) NOT NULL,
  `tre_id` int(11) DEFAULT NULL,
  `re_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `re_id` (`re_id`),
  KEY `so_id` (`so_id`),
  KEY `tre_id` (`tre_id`),
  CONSTRAINT `subsolicitudes_ibfk_1` FOREIGN KEY (`so_id`) REFERENCES `solicitudes` (`id`) ON UPDATE CASCADE,
  CONSTRAINT `subsolicitudes_ibfk_2` FOREIGN KEY (`tre_id`) REFERENCES `tipos_residuos` (`id`) ON UPDATE CASCADE,
  CONSTRAINT `subsolicitudes_ibfk_3` FOREIGN KEY (`re_id`) REFERENCES `residuos` (`id`) ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=114 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `subsolicitudes`
--

INSERT INTO `subsolicitudes` VALUES (1,'21-1','10 uni',NULL,'Bolsa','pilas para mañana','../uploads/solicitudes/1_subsol_cli_2019_12_19.jpeg',NULL,NULL,2,'',21,1,1),(2,'23-1','10','Libras','Caja','Esto es una prueba.','../uploads/solicitudes/2_subsol_cli_2019_12_27.jpeg',NULL,NULL,1,NULL,23,NULL,1),(5,'27-1','12','Libras','Caneca','swdfasedasd','../uploads/solicitudes/5_subsol_cli_2020_01_10.jpeg',NULL,NULL,3,'',27,1,4),(6,'28-1','100','Unidad','Caja','','../uploads/solicitudes/6_subsol_cli_2020_01_10.jpeg',NULL,NULL,3,'',28,NULL,2),(7,'28-2','200','Unidad','Caneca','','../uploads/solicitudes/7_subsol_cli_2020_01_10.jpeg',NULL,NULL,2,NULL,28,1,3),(8,'29-1','56','Kilogramos','Caja','Ninguna\n','../uploads/solicitudes/8_subsol_cli_2020_01_10.jpeg',NULL,NULL,1,NULL,29,NULL,4),(9,'29-2','4','Libras','Caja','N\n','../uploads/solicitudes/9_subsol_cli_2020_01_10.jpeg',NULL,NULL,1,NULL,29,NULL,4),(10,'30-1','2','Unidad','Otro','333','../uploads/solicitudes/10_subsol_cli_2020_01_10.jpeg',NULL,NULL,2,NULL,30,NULL,9),(12,'32-1','7','Unidad','Caja','jjjj','../uploads/solicitudes/12_subsol_cli_2020_01_14.jpeg',NULL,NULL,1,NULL,32,NULL,4),(13,'34-1','23','Kilogramos','Caja','Ninguna','../uploads/solicitudes/13_subsol_cli_2020_01_14.jpeg',NULL,NULL,1,NULL,34,NULL,6),(14,'34-2','1','Libras','Bolsa','Es especial ','../uploads/solicitudes/14_subsol_cli_2020_01_14.jpeg',NULL,NULL,1,NULL,34,NULL,3),(15,'34-3','345','Libras','Caja','Pocillo ','../uploads/solicitudes/15_subsol_cli_2020_01_14.jpeg',NULL,NULL,1,NULL,34,NULL,2),(16,'35-1','1000','Unidad','Bolsa','Ninguna ','../uploads/solicitudes/16_subsol_cli_2020_01_14.jpeg',NULL,NULL,3,'Poca Cantidad, vaya al punto mas cercano. ',35,NULL,6),(17,'36-1','2','Toneladas','Otro','','../uploads/solicitudes/17_subsol_cli_2020_01_14.jpeg',NULL,NULL,1,NULL,36,NULL,12),(18,'37-1','12','Kilogramos','Caja','Gxga','../uploads/solicitudes/18_subsol_cli_2020_01_17.jpeg',NULL,NULL,1,NULL,37,NULL,1),(19,'37-2','1','Kilogramos','Caneca','','../uploads/solicitudes/19_subsol_cli_2020_01_17.jpeg',NULL,NULL,2,NULL,37,1,9),(20,'38-1','12','Libras','Bolsa','Tiene doble bolsa','../uploads/solicitudes/20_subsol_cli_2020_01_24.jpeg',NULL,NULL,1,NULL,38,NULL,1),(21,'38-2','2','Toneladas','Bolsa','djdjdjdj','../uploads/solicitudes/21_subsol_cli_2020_01_24.jpeg',NULL,NULL,1,NULL,38,NULL,5),(24,'40-1','100','Kilogramos','Caja','','../uploads/solicitudes/24_subsol_cli_2020_01_24.jpeg',NULL,NULL,1,NULL,40,NULL,12),(26,'42-1','1500','Unidad','Otro','','../uploads/solicitudes/26_subsol_cli_2020_01_24.jpeg',NULL,NULL,2,NULL,42,NULL,12),(27,'43-1','10','Unidad','Bolsa','','../uploads/solicitudes/27_subsol_cli_2020_01_24.jpeg',NULL,NULL,1,NULL,43,NULL,9),(28,'43-2','20','Unidad','Otro','','../uploads/solicitudes/28_subsol_cli_2020_01_24.jpeg',NULL,NULL,1,NULL,43,NULL,7),(29,'44-1','1000','Unidad','Caneca','','../uploads/solicitudes/29_subsol_cli_2020_01_24.jpeg',NULL,NULL,4,NULL,44,NULL,8),(31,'46-1','12','Libras','Bolsa','bueno es una prueba ','../uploads/solicitudes/31_subsol_cli_2020_01_30.jpeg',NULL,NULL,4,NULL,46,NULL,4),(32,'50-1','12','Kilogramos','Caja','Esto es una prueba','../uploads/solicitudes/32_subsol_cli_2020_02_23.jpeg',NULL,NULL,3,'Esto es una prueba.',50,NULL,2),(33,'50-2','10','Kilogramos','Caneca','Esta es una segunda prueba.','../uploads/solicitudes/33_subsol_cli_2020_02_23.jpeg',NULL,NULL,5,NULL,50,NULL,12),(36,'52-1','15000','Unidad','Caja','Ninguna ','../uploads/solicitudes/36_subsol_cli_2020_03_04.jpeg',NULL,NULL,5,NULL,52,NULL,2),(37,'53-1','1','Unidad','Bolsa','Q\n','../uploads/solicitudes/37_subsol_cli_2020_03_04.jpeg',NULL,NULL,1,NULL,53,NULL,7),(38,'55-1','5','Kilogramos','Caneca','tapas plasticas','../uploads/solicitudes/38_subsol_cli_2020_03_06.jpeg',NULL,NULL,2,NULL,55,NULL,6),(39,'55-2','1','Unidad','Caja','portatil','../uploads/solicitudes/39_subsol_cli_2020_03_06.jpeg',NULL,NULL,2,NULL,55,NULL,7),(40,'56-1','250','Libras','Caneca','Son los residuos de la casa... ','../uploads/solicitudes/40_subsol_cli_2020_03_09.jpeg',NULL,NULL,5,NULL,56,NULL,77),(41,'58-1','100','Unidad','Bolsa','Ninguna ','../uploads/solicitudes/41_subsol_cli_2020_03_09.jpeg',NULL,NULL,2,NULL,58,1,3),(42,'59-1','100','Unidad','Bolsa','Bolsa que contiene medicamentos vencidos. ','../uploads/solicitudes/42_subsol_cli_2020_03_10.jpeg',NULL,NULL,3,'',59,1,3),(43,'63-1','12','Libras','Caneca','','../uploads/solicitudes/43_subsol_cli_2020_03_11.jpeg',NULL,NULL,4,NULL,63,2,108),(44,'63-2','10','Kilogramos','Caneca','','../uploads/solicitudes/44_subsol_cli_2020_03_11.jpeg',NULL,NULL,2,NULL,63,3,136),(45,'64-1','1','Kilogramos','Caja','Ninguns','../uploads/solicitudes/45_subsol_cli_2020_03_11.jpeg',NULL,NULL,1,NULL,64,1,NULL),(46,'64-2','2','Kilogramos','Caneca','Ninguna','../uploads/solicitudes/46_subsol_cli_2020_03_11.jpeg',NULL,NULL,1,NULL,64,2,NULL),(47,'65-1','3500','Libras','Bolsa','Son varias bolsas','../uploads/solicitudes/47_subsol_cli_2020_03_16.jpeg',NULL,NULL,1,NULL,65,4,NULL),(48,'66-1','50','Unidad','Caja','Cada unidad se encuentra en una caja. ','../uploads/solicitudes/48_subsol_cli_2020_03_16.jpeg',NULL,NULL,1,NULL,66,2,NULL),(49,'66-2','2000','Unidad','Bolsa','Ninguna','../uploads/solicitudes/49_subsol_cli_2020_03_16.jpeg',NULL,NULL,1,NULL,66,1,NULL),(50,'68-1','200','Unidad','Caja','Residuo ordinario','../uploads/solicitudes/50_subsol_cli_2020_03_16.jpeg',NULL,NULL,3,'No se ve con exactitud el residuo, por lo tanto no se puede clasificar, necesita tomar una fotografía del residuo y no de la envoltura.',68,4,137),(51,'70-1','350','Kilogramos','Caneca','','../uploads/solicitudes/51_subsol_cli_2020_03_16.jpeg',NULL,NULL,5,NULL,70,5,138),(52,'70-2','1000','Kilogramos','Otro','','../uploads/solicitudes/52_subsol_cli_2020_03_16.jpeg',NULL,NULL,3,'No se ve nada',70,6,NULL),(53,'71-1','380','Unidad','Caja','380 unidades','../uploads/solicitudes/53_subsol_cli_2020_03_18.jpeg',NULL,NULL,1,NULL,71,3,NULL),(54,'72-1','600','Unidad','Bolsa','','../uploads/solicitudes/54_subsol_cli_2020_03_18.jpeg',NULL,NULL,1,NULL,72,1,NULL),(55,'72-2','1300','Libras','Caja','','../uploads/solicitudes/55_subsol_cli_2020_03_18.jpeg',NULL,NULL,3,'No se visualiza el residuo, solo el empaque, por favor abrir la caja y  tomar fotografía del residuo.',72,2,NULL),(56,'72-3','2780','Kilogramos','Caneca','','../uploads/solicitudes/56_subsol_cli_2020_03_18.jpeg',NULL,NULL,1,NULL,72,3,NULL),(57,'73-1','360','Kilogramos','Otro','','../uploads/solicitudes/57_subsol_cli_2020_03_18.jpeg',NULL,NULL,2,NULL,73,7,NULL),(58,'74-1','50','Kilogramos','Otro','ffff','../uploads/solicitudes/58_subsol_cli_2020_03_30.jpeg',NULL,NULL,1,NULL,74,7,NULL),(59,'75-1','390','Unidad','Caneca','El residuo se encuentra separado por bolsas. ','../uploads/solicitudes/59_subsol_cli_2020_04_03.jpeg',NULL,NULL,5,NULL,75,3,NULL),(60,'77-1','1000','Kilogramos','Caneca','Papel periódico','../uploads/solicitudes/60_subsol_cli_2020_04_13.jpeg',NULL,NULL,2,NULL,77,2,NULL),(61,'78-1','5400','Libras','Otro','','../uploads/solicitudes/61_subsol_cli_2020_04_13.jpeg',NULL,NULL,2,NULL,78,6,NULL),(62,'81-1','5','Kilogramos','Caneca','Ninguna','../uploads/solicitudes/62_subsol_cli_2020_04_18.jpeg',NULL,NULL,3,'Cantidad',81,6,NULL),(63,'81-2','8','Kilogramos','Caja','Residuos de botellas','../uploads/solicitudes/63_subsol_cli_2020_04_18.jpeg',NULL,NULL,3,'',81,2,NULL),(64,'82-1','1','Unidad','Caja','1 caja de 50 x 50 x 50 cm','../uploads/solicitudes/64_subsol_cli_2020_04_18.jpeg',NULL,NULL,3,'',82,2,NULL),(65,'83-1','600','Unidad','Caja','','../uploads/solicitudes/65_subsol_cli_2020_04_22.jpeg',NULL,NULL,5,NULL,83,3,NULL),(66,'85-1','1500','Kilogramos','Caneca','','../uploads/solicitudes/66_subsol_cli_2020_04_27.jpeg',NULL,NULL,1,NULL,85,3,NULL),(67,'86-1','12500','Kilogramos','Caneca','','../uploads/solicitudes/67_subsol_cli_2020_04_27.jpeg',NULL,NULL,1,NULL,86,1,NULL),(68,'87-1','520','Unidad','Caneca','','../uploads/solicitudes/68_subsol_cli_2020_04_28.jpeg',NULL,NULL,1,NULL,87,4,NULL),(69,'88-1','500','Kilogramos','Caneca','Residuos Orgánicos','../uploads/solicitudes/69_subsol_cli_2020_04_28.jpeg',NULL,NULL,1,NULL,88,4,NULL),(70,'89-1','250','Unidad','Bolsa','bolsa con jeringas','../uploads/solicitudes/70_subsol_cli_2020_04_28.jpeg',NULL,NULL,1,NULL,89,1,NULL),(71,'91-1','1000','Libras','Otro','Escombros de construcción.','../uploads/solicitudes/71_subsol_cli_2020_04_29.jpeg',NULL,NULL,1,NULL,91,7,NULL),(72,'92-1','25','Libras','Otro','Aluminio','../uploads/solicitudes/72_subsol_cli_2020_04_29.jpeg',NULL,NULL,1,NULL,92,2,NULL),(73,'93-1','1500','Libras','Caneca','','../uploads/solicitudes/73_subsol_cli_2020_04_29.jpeg',NULL,NULL,1,NULL,93,3,NULL),(74,'93-2','150','Unidad','Bolsa','Medicamentos','../uploads/solicitudes/74_subsol_cli_2020_04_29.jpeg',NULL,NULL,1,NULL,93,3,NULL),(75,'95-1','200','Unidad','Otro','','../uploads/solicitudes/75_subsol_cli_2020_04_30.jpeg',NULL,NULL,1,NULL,95,3,NULL),(76,'96-1','2500','Libras','Otro','Escombros demolición','../uploads/solicitudes/76_subsol_cli_2020_05_04.jpeg',NULL,NULL,1,NULL,96,7,NULL),(77,'96-2','210','Unidad','Caneca','','../uploads/solicitudes/77_subsol_cli_2020_05_04.jpeg',NULL,NULL,1,NULL,96,3,NULL),(78,'97-1','500','Unidad','Caneca','','../uploads/solicitudes/78_subsol_cli_2020_05_04.jpeg',NULL,NULL,1,NULL,97,2,NULL),(79,'100-1','200','Kilogramos','Otro','Aluminio','../uploads/solicitudes/79_subsol_cli_2020_05_05.jpeg',NULL,NULL,1,NULL,100,6,NULL),(80,'103-1','300','Unidad','Bolsa','bolsa con medicamentos.','../uploads/solicitudes/80_subsol_cli_2020_05_05.jpeg',NULL,NULL,1,NULL,103,1,NULL),(81,'104-1','43','Unidad','Bolsa','Jeringas','../uploads/solicitudes/81_subsol_cli_2020_05_05.jpeg',NULL,NULL,1,NULL,104,1,NULL),(82,'105-1','12','Unidad','Bolsa','Esto es una prueba','../uploads/solicitudes/82_subsol_cli_2020_05_05.jpeg',NULL,NULL,1,NULL,105,1,NULL),(83,'106-1','56','Unidad','Bolsa','Jeringas','../uploads/solicitudes/83_subsol_cli_2020_05_06.jpeg',NULL,NULL,3,'',106,1,NULL),(84,'107-1','200','Libras','Caja','Envases Tetrapack','../uploads/solicitudes/84_subsol_cli_2020_05_06.jpeg',NULL,NULL,1,NULL,107,2,NULL),(85,'112-1','12','Unidad','Caja','','../uploads/solicitudes/85_subsol_cli_2020_05_10.jpeg',NULL,NULL,1,NULL,112,1,NULL),(86,'112-2','12','Kilogramos','Caneca','','../uploads/solicitudes/86_subsol_cli_2020_05_10.jpeg',NULL,NULL,1,NULL,112,2,NULL),(87,'114-1','2500','Libras','Caneca','','../uploads/solicitudes/87_subsol_cli_2020_05_11.jpeg',NULL,NULL,1,NULL,114,6,NULL),(88,'115-1','12','Kilogramos','Bolsa','esto es una prueba','../uploads/solicitudes/88_subsol_cli_2020_05_11.jpeg',NULL,NULL,1,NULL,115,1,NULL),(89,'116-1','568','Unidad','Bolsa','Guantes ','../uploads/solicitudes/89_subsol_cli_2020_05_11.jpeg',NULL,NULL,3,'',116,3,NULL),(90,'116-2','600','Unidad','Caja','Jeringas','../uploads/solicitudes/90_subsol_cli_2020_05_11.jpeg',NULL,NULL,1,NULL,116,4,NULL),(91,'120-1','1','Kilogramos','Caja','','../uploads/solicitudes/91_subsol_cli_2020_05_13.',NULL,NULL,1,NULL,120,2,NULL),(92,'121-1','1','Kilogramos','Caja','','../uploads/solicitudes/92_subsol_cli_2020_05_13.',NULL,NULL,1,NULL,121,2,NULL),(93,'122-1','1','Kilogramos','Caja','ff','../uploads/solicitudes/93_subsol_cli_2020_05_13.',NULL,NULL,1,NULL,122,2,NULL),(94,'123-1','1','Unidad','Caja','bb','../uploads/solicitudes/94_subsol_cli_2020_05_13.',NULL,NULL,1,NULL,123,2,NULL),(95,'124-1','120','Unidad','Caja','Prueba 1 Andrés ','../uploads/solicitudes/95_subsol_cli_2020_05_13.',NULL,NULL,1,NULL,124,2,NULL),(96,'124-2','4','Kilogramos','Caneca','Prueba 1,1 Andrés ','../uploads/solicitudes/96_subsol_cli_2020_05_13.',NULL,NULL,1,NULL,124,1,NULL),(97,'127-1','80','Unidad','Caneca','','../uploads/solicitudes/97_subsol_cli_2020_05_14.jpeg',NULL,NULL,1,NULL,127,3,NULL),(98,'128-1','230','Unidad','Caneca','Escombros','../uploads/solicitudes/98_subsol_cli_2020_05_14.jpeg',NULL,NULL,1,NULL,128,7,NULL),(99,'130-1','46','Unidad','Bolsa','Medicamentos','../uploads/solicitudes/99_subsol_cli_2020_05_15.jpeg',NULL,NULL,1,NULL,130,3,NULL),(100,'131-1','50','Unidad','Bolsa','Jeringas','../uploads/solicitudes/100_subsol_cli_2020_05_15.jpeg',NULL,NULL,1,NULL,131,1,NULL),(101,'132-1','12','Libras','Bolsa','prueba imagen ','../uploads/solicitudes/101_subsol_cli_2020_05_15.jpeg',NULL,NULL,1,NULL,132,2,NULL),(102,'132-2','12','Kilogramos','Bolsa','','../uploads/solicitudes/102_subsol_cli_2020_05_15.pdf',NULL,NULL,3,'Se rechaza por que si',132,3,136),(103,'133-1','30','Libras','Otro','Residuo especial ','../uploads/solicitudes/103_subsol_cli_2020_05_18.pdf',NULL,NULL,1,NULL,133,3,NULL),(104,'134-1','2','Kilogramos','Bolsa','ninguna','../uploads/solicitudes/104_subsol_cli_2020_05_19.jpeg',NULL,NULL,3,'',134,3,NULL),(105,'135-1','3','Unidad','Otro','pipetas de gas 60 lits','../uploads/solicitudes/105_subsol_cli_2020_05_19.',NULL,NULL,3,'',135,1,NULL),(106,'136-1','12','Libras','Bolsa','','../uploads/solicitudes/106_subsol_cli_2020_05_19.pdf',NULL,NULL,2,NULL,136,3,147),(107,'137-1','48','Unidad','Bolsa','Medicamentos','../uploads/solicitudes/107_subsol_cli_2020_05_19.jpeg',NULL,NULL,2,NULL,137,1,3),(108,'137-2','130','Unidad','Bolsa','Tapabocas','../uploads/solicitudes/108_subsol_cli_2020_05_19.jpeg',NULL,NULL,1,NULL,137,1,NULL),(109,'138-1','50','Unidad','Caja','Partes de computadores ','../uploads/solicitudes/109_subsol_cli_2020_05_19.jpeg',NULL,NULL,4,NULL,138,3,146),(110,'139-1','60','Kilogramos','Caneca','Empaques tetra pack','../uploads/solicitudes/110_subsol_cli_2020_05_19.jpeg',NULL,NULL,3,'No se visualiza el contenido de la caneca, por favor hacer una nueva solicitud. ',139,2,120),(111,'140-1','500','Unidad','Caneca','','../uploads/solicitudes/111_subsol_cli_2020_05_20.jpeg',NULL,NULL,1,NULL,140,3,NULL),(112,'141-1','32','Toneladas','Otro','','../uploads/solicitudes/112_subsol_cli_2020_05_20.jpeg',NULL,NULL,1,NULL,141,4,NULL),(113,'142-1','56','Kilogramos','Caja','','../uploads/solicitudes/113_subsol_cli_2020_05_20.jpeg',NULL,NULL,1,NULL,142,2,NULL);

--
-- Table structure for table `tipos_clientes`
--

CREATE TABLE `tipos_clientes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nombre` varchar(150) NOT NULL,
  `detalle` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tipos_clientes`
--

INSERT INTO `tipos_clientes` VALUES (1,'Posconsumo',''),(2,'Hogar',''),(3,'Empresas',''),(8,'Sucursal','');

--
-- Table structure for table `tipos_documentos`
--

CREATE TABLE `tipos_documentos` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nombre` varchar(150) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tipos_documentos`
--

INSERT INTO `tipos_documentos` VALUES (1,'Cédula de Ciudadanía'),(2,'Cédula de Extranjería'),(3,'Pasaporte'),(4,'NIT'),(5,'Cámara de Comercio'),(6,'Licencia'),(7,'RUT');

--
-- Table structure for table `tipos_gestores`
--

CREATE TABLE `tipos_gestores` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nombre` varchar(150) NOT NULL,
  `detalle` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tipos_gestores`
--

INSERT INTO `tipos_gestores` VALUES (1,'Posconsumo',''),(2,'Respel',''),(3,'Eca',''),(5,'Gestor P','Gestor P'),(7,'Prueba','Prueba');

--
-- Table structure for table `tipos_puntos`
--

CREATE TABLE `tipos_puntos` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nombre` varchar(150) NOT NULL,
  `url` varchar(150) DEFAULT NULL,
  `clase` varchar(150) DEFAULT NULL,
  `estado` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `tipos_puntos`
--

INSERT INTO `tipos_puntos` VALUES (1,'Pilas','pilas','pilas3',1),(2,'Bombillos','bombillos','bombillos3',1),(3,'Celulares','celulares','celulares3',1),(4,'Plaguicidas','plaguicidas','plaguicidas3',1),(5,'Neumáticos','llantas','llantas3',1),(6,'Tapas','tapas','tapas3',1),(7,'Computadores','computadores','computadores3',1),(8,'Aceite de Cocina','aceite','aceitesco3',1),(9,'Eléctricos','electricos','electricos3',1),(10,'Reciclables','recyclable','reciclables3',1),(11,'Icopor','icopor','icopor3',1),(12,'Peligrosos','peligrosos','peligrosos3',1),(13,'Escombros','escombros','escombros3',1),(14,'Medicinas','medicinas','medicamentos3',1),(15,'Orgánicos','organicos','organicos3',1);

--
-- Table structure for table `tipos_residuos`
--

CREATE TABLE `tipos_residuos` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nombre` varchar(200) NOT NULL,
  `detalle` text,
  `estado` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tipos_residuos`
--

INSERT INTO `tipos_residuos` VALUES (1,'Peligrosos',NULL,1),(2,'Aprovechables',NULL,1),(3,'Especiales',NULL,1),(4,'Ordinarios',NULL,1),(5,'Liquidos',NULL,1),(6,'Orgánicos',NULL,1),(7,'Construcción - RCD',NULL,1);

--
-- Table structure for table `tipos_usuarios`
--

CREATE TABLE `tipos_usuarios` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nombre` varchar(150) NOT NULL,
  `detalle` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tipos_usuarios`
--

INSERT INTO `tipos_usuarios` VALUES (1,'Super Admin','Todo el acceso completo.'),(3,'Administrador','Permisos de Administración.'),(8,'Administrador RecyPuntos ','Todos los permisos');

--
-- Table structure for table `transportes`
--

CREATE TABLE `transportes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tipo` varchar(255) NOT NULL,
  `marca` varchar(255) NOT NULL,
  `capacidad` int(11) NOT NULL,
  `placa` varchar(15) NOT NULL,
  `detalles` text,
  `tecnomecanica_vigencia` int(11) NOT NULL,
  `tecnomecanica_foto` varchar(255) DEFAULT NULL,
  `soat_vigencia` int(11) NOT NULL,
  `soat_foto` varchar(255) NOT NULL,
  `tarjeta_propiedad_foto` varchar(255) DEFAULT NULL,
  `poliza_extracontractual` varchar(255) NOT NULL,
  `propietario` varchar(255) NOT NULL,
  `estado` int(11) NOT NULL DEFAULT '1',
  `re_id` int(11) NOT NULL,
  `creacion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `re_id` (`re_id`),
  CONSTRAINT `transportes_ibfk_1` FOREIGN KEY (`re_id`) REFERENCES `recolectores` (`id`) ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `transportes`
--

INSERT INTO `transportes` VALUES (1,'Furgon','Chevrolet',200,'RSR666','Camion con gran capcidad.. etc.',1,NULL,1,'dasasd','asdasd','asdasd','Juan Perez',1,1,'2020-02-27 16:26:26');

--
-- Table structure for table `usuarios`
--

CREATE TABLE `usuarios` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(200) NOT NULL,
  `password` varchar(255) NOT NULL,
  `nombres` varchar(150) NOT NULL,
  `apellidos` varchar(150) NOT NULL,
  `tipo_documento` int(11) NOT NULL,
  `documento` varchar(50) NOT NULL,
  `correo` varchar(200) NOT NULL,
  `telefono_fijo` varchar(150) DEFAULT NULL,
  `telefono_celular` varchar(150) DEFAULT NULL,
  `tu_id` int(11) NOT NULL,
  `mu_id` int(11) NOT NULL,
  `estado` int(11) NOT NULL DEFAULT '1',
  `creacion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `tu_id` (`tu_id`),
  KEY `tipo_documento` (`tipo_documento`),
  KEY `mu_id` (`mu_id`),
  CONSTRAINT `usuarios_ibfk_1` FOREIGN KEY (`tu_id`) REFERENCES `tipos_usuarios` (`id`) ON UPDATE CASCADE,
  CONSTRAINT `usuarios_ibfk_2` FOREIGN KEY (`tipo_documento`) REFERENCES `tipos_documentos` (`id`) ON UPDATE CASCADE,
  CONSTRAINT `usuarios_ibfk_3` FOREIGN KEY (`mu_id`) REFERENCES `municipios` (`id`) ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `usuarios`
--

INSERT INTO `usuarios` VALUES (1,'info@recypuntos.org','$2y$10$HmY0v9QpQtjYnCW9ceV0.O0eUQ1zlyLFebVCe9CWdQ9O83lHGUly.','Administrador','RecyPuntos',1,'1110524931','info@recypuntos.org','','12312312',1,91,1,'2019-10-15 14:23:17'),(3,'admin2@prueba.com','$2y$10$lOMOPl0SHd6cLPGeAJAG3.klUPcuLs3Bo0Hge/r5.NDcoz9ZrTbTO','Administrador ','Prueba',4,'800160543-2','admin@prueba.com','5421030','3204156180',1,107,1,'2019-11-28 15:06:49'),(4,'admin@administrador.com','$2y$10$FoRZRwJAi8mjkvu/jy62..uPzjJpfyXxQZfeRGbn5eFEkOpxLmhEq','Admin','Administrador',1,'1020456321','admin@administrador.com','4563210','3042105632',3,107,1,'2020-03-16 11:13:50');


