dqqvwsj2

· 7 years ago · Dec 03, 2018, 03:56 PM
1-- MySQL dump 10.13  Distrib 5.7.24, for Linux (x86_64)
2--
3-- Host: localhost    Database: cosapi_inmobiliaria_prod
4-- ------------------------------------------------------
5-- Server version	5.7.24-0ubuntu0.16.04.1
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!40101 SET NAMES utf8 */;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18--
19-- Table structure for table `area`
20--
21
22DROP TABLE IF EXISTS `area`;
23/*!40101 SET @saved_cs_client     = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `area` (
26  `id` int(11) NOT NULL AUTO_INCREMENT,
27  `name` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
28  `icon` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
29  `updated_at` datetime NOT NULL,
30  `created_at` datetime NOT NULL,
31  PRIMARY KEY (`id`)
32) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
33/*!40101 SET character_set_client = @saved_cs_client */;
34
35--
36-- Dumping data for table `area`
37--
38
39LOCK TABLES `area` WRITE;
40/*!40000 ALTER TABLE `area` DISABLE KEYS */;
41INSERT INTO `area` VALUES (1,'Coworking','/resources/projects/prana/areas-comunes/coworking.svg','2018-09-23 18:26:34','2018-09-23 18:26:34'),(2,'Lobby','/resources/projects/prana/areas-comunes/lobby.svg','2018-09-23 18:26:34','2018-09-23 18:26:34'),(3,'Sushi bar','/resources/projects/prana/areas-comunes/sushi-bar.svg','2018-09-23 18:26:34','2018-09-23 18:26:34'),(4,'Sala de niÃ±os','/resources/projects/prana/areas-comunes/sala-ninos.svg','2018-09-23 18:26:34','2018-09-23 18:26:34'),(5,'Zona de bicicletas','/resources/projects/prana/areas-comunes/zona-bicicletas.svg','2018-09-23 18:26:34','2018-09-23 18:26:34'),(6,'Gimnasio zen','/resources/projects/prana/areas-comunes/gimnasio-zen.svg','2018-09-23 18:26:34','2018-09-23 18:26:34'),(7,'Lobby','/resources/projects/duplo/areas-comunes/lobby.svg','2018-09-23 18:26:34','2018-09-23 18:26:34'),(8,'Salon de juegos','/resources/projects/duplo/areas-comunes/sala-juegos.svg','2018-09-23 18:26:34','2018-09-23 18:26:34'),(9,'Sala de coworking','/resources/projects/duplo/areas-comunes/coworking.svg','2018-09-23 18:26:34','2018-09-23 18:26:34'),(10,'Piscina panorÃ¡mica','/resources/projects/duplo/areas-comunes/piscina.svg','2018-09-23 18:26:34','2018-09-23 18:26:34'),(11,'Gimnasio','/resources/projects/duplo/areas-comunes/gimnasio.svg','2018-09-23 18:26:34','2018-09-23 18:26:34'),(12,'Zona de parrillas','/resources/projects/duplo/areas-comunes/zona-parrillas.svg','2018-09-23 18:26:34','2018-09-23 18:26:34'),(13,'Sala de coworking','/resources/projects/nesta/areas-comunes/coworking.svg','2018-09-23 18:26:34','2018-09-23 18:26:34'),(14,'Gimnasio','/resources/projects/nesta/areas-comunes/gimnasio.svg','2018-09-23 18:26:34','2018-09-23 18:26:34'),(15,'Lobby','/resources/projects/nesta/areas-comunes/lobby.svg','2018-09-23 18:26:34','2018-09-23 18:26:34'),(16,'Piscina','/resources/projects/nesta/areas-comunes/piscina.svg','2018-09-23 18:26:34','2018-09-23 18:26:34'),(17,'Terraza','/resources/projects/nesta/areas-comunes/terraza.svg','2018-09-23 18:26:34','2018-09-23 18:26:34'),(18,'Zona de parrillas','/resources/projects/nesta/areas-comunes/zona-parrillas.svg','2018-09-23 18:26:34','2018-09-23 18:26:34'),(19,'Gimnasio','/resources/projects/velia/areas-comunes/gimnasio.svg','2018-09-23 18:26:34','2018-09-23 18:26:34'),(20,'2 patios interiores','/resources/projects/velia/areas-comunes/patio-interior.svg','2018-09-23 18:26:34','2018-09-23 18:26:34'),(21,'Salas de reuniones','/resources/projects/velia/areas-comunes/sala-reunion.svg','2018-09-23 18:26:34','2018-09-23 18:26:34'),(22,'Sala para niÃ±os','/resources/projects/velia/areas-comunes/sala-ninos.svg','2018-09-23 18:26:34','2018-09-23 18:26:34'),(23,'Un lobby con seguridad','/resources/projects/velia/areas-comunes/lobby.svg','2018-09-23 18:26:34','2018-09-23 18:26:34'),(24,'AtenciÃ³n las 24 horas','/resources/projects/velia/areas-comunes/atencion-24h.svg','2018-09-23 18:26:34','2018-09-23 18:26:34'),(25,'Beauty room','/resources/projects/Ã©piqe/areas-comunes/1-beauty-room.svg','2018-09-23 18:26:34','2018-09-23 18:26:34'),(26,'Hollywood room','/resources/projects/Ã©piqe/areas-comunes/2-hollywood-room.svg','2018-09-23 18:26:34','2018-09-23 18:26:34'),(27,'Lounge','/resources/projects/Ã©piqe/areas-comunes/3-lounge.svg','2018-09-23 18:26:34','2018-09-23 18:26:34'),(28,'Terraza lounge','/resources/projects/Ã©piqe/areas-comunes/4-terraza-lounge.svg','2018-09-23 18:26:34','2018-09-23 18:26:34'),(29,'Wine room','/resources/projects/Ã©piqe/areas-comunes/5-wine-room.svg','2018-09-23 18:26:34','2018-09-23 18:26:34'),(30,'Crossfit','/resources/projects/Ã©piqe/areas-comunes/6-crossfit.svg','2018-09-23 18:26:34','2018-09-23 18:26:34');
42/*!40000 ALTER TABLE `area` ENABLE KEYS */;
43UNLOCK TABLES;
44
45--
46-- Table structure for table `attachment`
47--
48
49DROP TABLE IF EXISTS `attachment`;
50/*!40101 SET @saved_cs_client     = @@character_set_client */;
51/*!40101 SET character_set_client = utf8 */;
52CREATE TABLE `attachment` (
53  `id` int(11) NOT NULL AUTO_INCREMENT,
54  `post_sale_request_id` int(11) DEFAULT NULL,
55  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
56  `updated_at` datetime NOT NULL,
57  `created_at` datetime NOT NULL,
58  PRIMARY KEY (`id`),
59  KEY `IDX_795FD9BBF21C9C89` (`post_sale_request_id`),
60  CONSTRAINT `FK_795FD9BBF21C9C89` FOREIGN KEY (`post_sale_request_id`) REFERENCES `post_sale_request` (`id`)
61) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
62/*!40101 SET character_set_client = @saved_cs_client */;
63
64--
65-- Dumping data for table `attachment`
66--
67
68LOCK TABLES `attachment` WRITE;
69/*!40000 ALTER TABLE `attachment` DISABLE KEYS */;
70/*!40000 ALTER TABLE `attachment` ENABLE KEYS */;
71UNLOCK TABLES;
72
73--
74-- Table structure for table `attribute`
75--
76
77DROP TABLE IF EXISTS `attribute`;
78/*!40101 SET @saved_cs_client     = @@character_set_client */;
79/*!40101 SET character_set_client = utf8 */;
80CREATE TABLE `attribute` (
81  `id` int(11) NOT NULL AUTO_INCREMENT,
82  `name` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
83  `icon` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
84  `updated_at` datetime NOT NULL,
85  `created_at` datetime NOT NULL,
86  PRIMARY KEY (`id`)
87) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
88/*!40101 SET character_set_client = @saved_cs_client */;
89
90--
91-- Dumping data for table `attribute`
92--
93
94LOCK TABLES `attribute` WRITE;
95/*!40000 ALTER TABLE `attribute` DISABLE KEYS */;
96INSERT INTO `attribute` VALUES (1,'Vista privilegiada','/resources/projects/prana/caracteristicas/vista-privilegiada.svg','2018-09-23 18:26:34','2018-09-23 18:26:34'),(2,'Acabados de primera','/resources/projects/prana/caracteristicas/calidad-acabados.svg','2018-09-23 18:26:34','2018-09-23 18:26:34'),(3,'Ãreas verdes','/resources/projects/prana/caracteristicas/areas-verdes.svg','2018-09-23 18:26:34','2018-09-23 18:26:34'),(4,'UbicaciÃ³n estratÃ©gica','/resources/projects/prana/caracteristicas/ubicacion-ideal.svg','2018-09-23 18:26:34','2018-09-23 18:26:34'),(5,'Depas de 2 y 3 dorms','/resources/projects/prana/caracteristicas/dormitorios.svg','2018-09-23 18:26:34','2018-09-23 18:26:34'),(6,'De 50m<sup>2</sup> hasta 185m<sup>2</sup>','/resources/projects/prana/caracteristicas/metraje.svg','2018-09-23 18:26:34','2018-09-23 18:26:34'),(7,'Vista espectacular','/resources/projects/duplo/caracteristicas/vista-espectacular.svg','2018-09-23 18:26:34','2018-09-23 18:26:34'),(8,'UbicaciÃ³n centrica','/resources/projects/duplo/caracteristicas/ubicacion-ideal.svg','2018-09-23 18:26:34','2018-09-23 18:26:34'),(9,'Calidad en acabados','/resources/projects/duplo/caracteristicas/calidad-acabados.svg','2018-09-23 18:26:34','2018-09-23 18:26:34'),(10,'Precios mi vivienda','/resources/projects/duplo/caracteristicas/precios-mi-vivienda.svg','2018-09-23 18:26:34','2018-09-23 18:26:34'),(11,'Gas natural','/resources/projects/duplo/caracteristicas/gas-natural.svg','2018-09-23 18:26:34','2018-09-23 18:26:34'),(12,'Ãreas comunes de lujo','/resources/projects/duplo/caracteristicas/areas-comunes-lujo.svg','2018-09-23 18:26:34','2018-09-23 18:26:34'),(13,'Precios Mi Vivienda','/resources/projects/nesta/caracteristicas/precios-mi-vivienda.svg','2018-09-23 18:26:34','2018-09-23 18:26:34'),(14,'Doble acceso','/resources/projects/nesta/caracteristicas/doble-acceso.svg','2018-09-23 18:26:34','2018-09-23 18:26:34'),(15,'UbicaciÃ³n ideal','/resources/projects/nesta/caracteristicas/ubicacion-ideal.svg','2018-09-23 18:26:34','2018-09-23 18:26:34'),(16,'Calidad en acabados','/resources/projects/nesta/caracteristicas/calidad-acabados.svg','2018-09-23 18:26:34','2018-09-23 18:26:34'),(17,'Gas natural','/resources/projects/nesta/caracteristicas/gas-natural.svg','2018-09-23 18:26:34','2018-09-23 18:26:34'),(18,'Ãreas comunes','/resources/projects/nesta/caracteristicas/areas-comunes.svg','2018-09-23 18:26:34','2018-09-23 18:26:34'),(19,'Vista privilegiada','/resources/projects/velia/caracteristicas/vista-privilegiada.svg','2018-09-23 18:26:34','2018-09-23 18:26:34'),(20,'Acabados de primera','/resources/projects/velia/caracteristicas/calidad-acabados.svg','2018-09-23 18:26:34','2018-09-23 18:26:34'),(21,'Ãreas verdes','/resources/projects/velia/caracteristicas/areas-verdes.svg','2018-09-23 18:26:34','2018-09-23 18:26:34'),(22,'UbicaciÃ³n estratÃ©gica','/resources/projects/velia/caracteristicas/ubicacion-ideal.svg','2018-09-23 18:26:34','2018-09-23 18:26:34'),(23,'Moderna fachada','/resources/projects/velia/caracteristicas/fachada-moderna.svg','2018-09-23 18:26:34','2018-09-23 18:26:34'),(24,'Edificio de 15 pisos','/resources/projects/velia/caracteristicas/edificio-15pisos.svg','2018-09-23 18:26:34','2018-09-23 18:26:34'),(25,'UbicaciÃ³n cÃ©ntrica','/resources/projects/Ã©piqe/atributos/1-ubicacion-centrica.svg','2018-09-23 18:26:34','2018-09-23 18:26:34'),(26,'Vista panorÃ¡mica','/resources/projects/Ã©piqe/atributos/2-vista-panoramica.svg','2018-09-23 18:26:34','2018-09-23 18:26:34'),(27,'De 40m<sup>2</sup> hasta 78m<sup>2</sup>','/resources/projects/Ã©piqe/atributos/3-40m2-hasta-78m2.svg','2018-09-23 18:26:34','2018-09-23 18:26:34'),(28,'Proyecto sostenible','/resources/projects/Ã©piqe/atributos/4-proyecto-sostenible.svg','2018-09-23 18:26:34','2018-09-23 18:26:34'),(29,'Acabados de primera','/resources/projects/Ã©piqe/atributos/5-acabados-de-primera.svg','2018-09-23 18:26:34','2018-09-23 18:26:34'),(30,'Ãreas comunes exclusivas','/resources/projects/Ã©piqe/atributos/6-areas-comunes-exclusivas.svg','2018-09-23 18:26:34','2018-09-23 18:26:34');
97/*!40000 ALTER TABLE `attribute` ENABLE KEYS */;
98UNLOCK TABLES;
99
100--
101-- Table structure for table `contact_request`
102--
103
104DROP TABLE IF EXISTS `contact_request`;
105/*!40101 SET @saved_cs_client     = @@character_set_client */;
106/*!40101 SET character_set_client = utf8 */;
107CREATE TABLE `contact_request` (
108  `id` int(11) NOT NULL AUTO_INCREMENT,
109  `subscription_id` int(11) DEFAULT NULL,
110  `updated_at` datetime NOT NULL,
111  `created_at` datetime NOT NULL,
112  PRIMARY KEY (`id`),
113  UNIQUE KEY `UNIQ_A1B8AE1E9A1887DC` (`subscription_id`),
114  CONSTRAINT `FK_A1B8AE1E9A1887DC` FOREIGN KEY (`subscription_id`) REFERENCES `subscription` (`id`)
115) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
116/*!40101 SET character_set_client = @saved_cs_client */;
117
118--
119-- Dumping data for table `contact_request`
120--
121
122LOCK TABLES `contact_request` WRITE;
123/*!40000 ALTER TABLE `contact_request` DISABLE KEYS */;
124INSERT INTO `contact_request` VALUES (1,49,'2018-09-29 23:10:49','2018-09-29 23:10:49'),(2,57,'2018-09-30 15:39:06','2018-09-30 15:39:06'),(3,63,'2018-10-01 00:50:57','2018-10-01 00:50:57'),(4,92,'2018-10-03 00:04:10','2018-10-03 00:04:10'),(5,99,'2018-10-03 20:10:47','2018-10-03 20:10:47'),(6,102,'2018-10-03 21:02:38','2018-10-03 21:02:38'),(7,136,'2018-10-07 21:00:26','2018-10-07 21:00:26'),(8,144,'2018-10-08 22:02:27','2018-10-08 22:02:27'),(9,153,'2018-10-09 19:23:20','2018-10-09 19:23:20'),(10,183,'2018-10-12 15:52:57','2018-10-12 15:52:57'),(11,274,'2018-10-19 16:04:02','2018-10-19 16:04:02'),(12,306,'2018-10-22 21:46:01','2018-10-22 21:46:01'),(13,309,'2018-10-23 16:41:53','2018-10-23 16:41:53'),(14,318,'2018-10-24 22:30:17','2018-10-24 22:30:17'),(15,320,'2018-10-25 01:17:50','2018-10-25 01:17:50'),(16,334,'2018-10-25 22:59:48','2018-10-25 22:59:48'),(17,368,'2018-10-31 03:38:06','2018-10-31 03:38:06'),(18,369,'2018-10-31 03:42:47','2018-10-31 03:42:47');
125/*!40000 ALTER TABLE `contact_request` ENABLE KEYS */;
126UNLOCK TABLES;
127
128--
129-- Table structure for table `district`
130--
131
132DROP TABLE IF EXISTS `district`;
133/*!40101 SET @saved_cs_client     = @@character_set_client */;
134/*!40101 SET character_set_client = utf8 */;
135CREATE TABLE `district` (
136  `id` int(11) NOT NULL AUTO_INCREMENT,
137  `name` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL,
138  `updated_at` datetime NOT NULL,
139  `created_at` datetime NOT NULL,
140  PRIMARY KEY (`id`)
141) ENGINE=InnoDB AUTO_INCREMENT=52 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
142/*!40101 SET character_set_client = @saved_cs_client */;
143
144--
145-- Dumping data for table `district`
146--
147
148LOCK TABLES `district` WRITE;
149/*!40000 ALTER TABLE `district` DISABLE KEYS */;
150INSERT INTO `district` VALUES (1,'AncÃ³n','2018-09-23 18:26:34','2018-09-23 18:26:34'),(2,'Ate','2018-09-23 18:26:34','2018-09-23 18:26:34'),(3,'Barranco','2018-09-23 18:26:34','2018-09-23 18:26:34'),(4,'BreÃ±a','2018-09-23 18:26:34','2018-09-23 18:26:34'),(5,'Carabayllo','2018-09-23 18:26:34','2018-09-23 18:26:34'),(6,'Chaclacayo','2018-09-23 18:26:34','2018-09-23 18:26:34'),(7,'Chorrillos','2018-09-23 18:26:34','2018-09-23 18:26:34'),(8,'Cieneguilla','2018-09-23 18:26:34','2018-09-23 18:26:34'),(9,'Comas','2018-09-23 18:26:34','2018-09-23 18:26:34'),(10,'El Agustino','2018-09-23 18:26:34','2018-09-23 18:26:34'),(11,'HuaycÃ¡n','2018-09-23 18:26:34','2018-09-23 18:26:34'),(12,'Independencia','2018-09-23 18:26:34','2018-09-23 18:26:34'),(13,'JesÃºs MarÃa','2018-09-23 18:26:34','2018-09-23 18:26:34'),(14,'La Molina','2018-09-23 18:26:34','2018-09-23 18:26:34'),(15,'La Victoria','2018-09-23 18:26:34','2018-09-23 18:26:34'),(16,'Lima','2018-09-23 18:26:34','2018-09-23 18:26:34'),(17,'Lince','2018-09-23 18:26:34','2018-09-23 18:26:34'),(18,'Los Olivos','2018-09-23 18:26:34','2018-09-23 18:26:34'),(19,'Lurigancho','2018-09-23 18:26:34','2018-09-23 18:26:34'),(20,'LurÃn','2018-09-23 18:26:34','2018-09-23 18:26:34'),(21,'Magdalena del Mar','2018-09-23 18:26:34','2018-09-23 18:26:34'),(22,'Miraflores','2018-09-23 18:26:34','2018-09-23 18:26:34'),(23,'Pachacamac','2018-09-23 18:26:34','2018-09-23 18:26:34'),(24,'Pucusana','2018-09-23 18:26:34','2018-09-23 18:26:34'),(25,'Pueblo Libre','2018-09-23 18:26:34','2018-09-23 18:26:34'),(26,'Puente Piedra','2018-09-23 18:26:34','2018-09-23 18:26:34'),(27,'Punta Hermosa','2018-09-23 18:26:34','2018-09-23 18:26:34'),(28,'Punta Negra','2018-09-23 18:26:34','2018-09-23 18:26:34'),(29,'RÃmac','2018-09-23 18:26:34','2018-09-23 18:26:34'),(30,'San Bartolo','2018-09-23 18:26:34','2018-09-23 18:26:34'),(31,'San Borja','2018-09-23 18:26:34','2018-09-23 18:26:34'),(32,'San Isidro','2018-09-23 18:26:34','2018-09-23 18:26:34'),(33,'San Juan de Lurigancho','2018-09-23 18:26:34','2018-09-23 18:26:34'),(34,'San Juan de Miraflores','2018-09-23 18:26:34','2018-09-23 18:26:34'),(35,'San Luis','2018-09-23 18:26:34','2018-09-23 18:26:34'),(36,'San MartÃn de Porres','2018-09-23 18:26:34','2018-09-23 18:26:34'),(37,'San Miguel','2018-09-23 18:26:34','2018-09-23 18:26:34'),(38,'Santa Anita','2018-09-23 18:26:34','2018-09-23 18:26:34'),(39,'Santa MarÃa del Mar','2018-09-23 18:26:34','2018-09-23 18:26:34'),(40,'Santa Rosa','2018-09-23 18:26:34','2018-09-23 18:26:34'),(41,'Santiago de Surco','2018-09-23 18:26:34','2018-09-23 18:26:34'),(42,'Surquillo','2018-09-23 18:26:34','2018-09-23 18:26:34'),(43,'Villa El Salvador','2018-09-23 18:26:34','2018-09-23 18:26:34'),(44,'Villa MarÃa del Triunfo','2018-09-23 18:26:34','2018-09-23 18:26:34'),(45,'Bellavista	','2018-09-23 18:26:34','2018-09-23 18:26:34'),(46,'Callao','2018-09-23 18:26:34','2018-09-23 18:26:34'),(47,'Carmen de La Lengua - Reynoso','2018-09-23 18:26:34','2018-09-23 18:26:34'),(48,'La Perla','2018-09-23 18:26:34','2018-09-23 18:26:34'),(49,'La Punta','2018-09-23 18:26:34','2018-09-23 18:26:34'),(50,'Ventanilla','2018-09-23 18:26:34','2018-09-23 18:26:34'),(51,'Mi PerÃº','2018-09-23 18:26:34','2018-09-23 18:26:34');
151/*!40000 ALTER TABLE `district` ENABLE KEYS */;
152UNLOCK TABLES;
153
154--
155-- Table structure for table `investor_request`
156--
157
158DROP TABLE IF EXISTS `investor_request`;
159/*!40101 SET @saved_cs_client     = @@character_set_client */;
160/*!40101 SET character_set_client = utf8 */;
161CREATE TABLE `investor_request` (
162  `id` int(11) NOT NULL AUTO_INCREMENT,
163  `subscription_id` int(11) DEFAULT NULL,
164  `updated_at` datetime NOT NULL,
165  `created_at` datetime NOT NULL,
166  PRIMARY KEY (`id`),
167  UNIQUE KEY `UNIQ_6FD673749A1887DC` (`subscription_id`),
168  CONSTRAINT `FK_6FD673749A1887DC` FOREIGN KEY (`subscription_id`) REFERENCES `subscription` (`id`)
169) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
170/*!40101 SET character_set_client = @saved_cs_client */;
171
172--
173-- Dumping data for table `investor_request`
174--
175
176LOCK TABLES `investor_request` WRITE;
177/*!40000 ALTER TABLE `investor_request` DISABLE KEYS */;
178/*!40000 ALTER TABLE `investor_request` ENABLE KEYS */;
179UNLOCK TABLES;
180
181--
182-- Table structure for table `migration_versions`
183--
184
185DROP TABLE IF EXISTS `migration_versions`;
186/*!40101 SET @saved_cs_client     = @@character_set_client */;
187/*!40101 SET character_set_client = utf8 */;
188CREATE TABLE `migration_versions` (
189  `version` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
190  PRIMARY KEY (`version`)
191) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
192/*!40101 SET character_set_client = @saved_cs_client */;
193
194--
195-- Dumping data for table `migration_versions`
196--
197
198LOCK TABLES `migration_versions` WRITE;
199/*!40000 ALTER TABLE `migration_versions` DISABLE KEYS */;
200INSERT INTO `migration_versions` VALUES ('20180422204800'),('20180422212403'),('20180422215700'),('20180423004521'),('20180503141037'),('20180503150728'),('20180503165410'),('20180503171840'),('20180503173545'),('20180503173547'),('20180503173549'),('20180503175554'),('20180503190552'),('20180503190836'),('20180503191047'),('20180511145829'),('20180511151035'),('20180716150822'),('20180716151313'),('20180716151800'),('20180716225433'),('20180716225948'),('20180716230159'),('20180717172255'),('20180725170859'),('20181021042734');
201/*!40000 ALTER TABLE `migration_versions` ENABLE KEYS */;
202UNLOCK TABLES;
203
204--
205-- Table structure for table `partnership_request`
206--
207
208DROP TABLE IF EXISTS `partnership_request`;
209/*!40101 SET @saved_cs_client     = @@character_set_client */;
210/*!40101 SET character_set_client = utf8 */;
211CREATE TABLE `partnership_request` (
212  `id` int(11) NOT NULL AUTO_INCREMENT,
213  `subscription_id` int(11) DEFAULT NULL,
214  `phone_number2` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
215  `updated_at` datetime NOT NULL,
216  `created_at` datetime NOT NULL,
217  PRIMARY KEY (`id`),
218  UNIQUE KEY `UNIQ_2274BB429A1887DC` (`subscription_id`),
219  CONSTRAINT `FK_2274BB429A1887DC` FOREIGN KEY (`subscription_id`) REFERENCES `subscription` (`id`)
220) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
221/*!40101 SET character_set_client = @saved_cs_client */;
222
223--
224-- Dumping data for table `partnership_request`
225--
226
227LOCK TABLES `partnership_request` WRITE;
228/*!40000 ALTER TABLE `partnership_request` DISABLE KEYS */;
229/*!40000 ALTER TABLE `partnership_request` ENABLE KEYS */;
230UNLOCK TABLES;
231
232--
233-- Table structure for table `post_sale_request`
234--
235
236DROP TABLE IF EXISTS `post_sale_request`;
237/*!40101 SET @saved_cs_client     = @@character_set_client */;
238/*!40101 SET character_set_client = utf8 */;
239CREATE TABLE `post_sale_request` (
240  `id` int(11) NOT NULL AUTO_INCREMENT,
241  `subscription_id` int(11) DEFAULT NULL,
242  `project_id` int(11) DEFAULT NULL,
243  `flat_id` int(11) NOT NULL,
244  `updated_at` datetime NOT NULL,
245  `created_at` datetime NOT NULL,
246  PRIMARY KEY (`id`),
247  UNIQUE KEY `UNIQ_E5B430DE9A1887DC` (`subscription_id`),
248  KEY `IDX_E5B430DE166D1F9C` (`project_id`),
249  CONSTRAINT `FK_E5B430DE166D1F9C` FOREIGN KEY (`project_id`) REFERENCES `project` (`id`),
250  CONSTRAINT `FK_E5B430DE9A1887DC` FOREIGN KEY (`subscription_id`) REFERENCES `subscription` (`id`)
251) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
252/*!40101 SET character_set_client = @saved_cs_client */;
253
254--
255-- Dumping data for table `post_sale_request`
256--
257
258LOCK TABLES `post_sale_request` WRITE;
259/*!40000 ALTER TABLE `post_sale_request` DISABLE KEYS */;
260INSERT INTO `post_sale_request` VALUES (1,151,2,100,'2018-10-09 06:17:00','2018-10-09 06:17:00');
261/*!40000 ALTER TABLE `post_sale_request` ENABLE KEYS */;
262UNLOCK TABLES;
263
264--
265-- Table structure for table `project`
266--
267
268DROP TABLE IF EXISTS `project`;
269/*!40101 SET @saved_cs_client     = @@character_set_client */;
270/*!40101 SET character_set_client = utf8 */;
271CREATE TABLE `project` (
272  `id` int(11) NOT NULL AUTO_INCREMENT,
273  `district_id` int(11) DEFAULT NULL,
274  `name` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL,
275  `logo` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
276  `icon` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
277  `description` varchar(512) COLLATE utf8mb4_unicode_ci NOT NULL,
278  `website` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
279  `address` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL,
280  `colour` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL,
281  `image` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
282  `night_image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
283  `map` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
284  `disabled_leads` tinyint(1) NOT NULL,
285  `updated_at` datetime NOT NULL,
286  `created_at` datetime NOT NULL,
287  PRIMARY KEY (`id`),
288  KEY `IDX_2FB3D0EEB08FA272` (`district_id`),
289  CONSTRAINT `FK_2FB3D0EEB08FA272` FOREIGN KEY (`district_id`) REFERENCES `district` (`id`)
290) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
291/*!40101 SET character_set_client = @saved_cs_client */;
292
293--
294-- Dumping data for table `project`
295--
296
297LOCK TABLES `project` WRITE;
298/*!40000 ALTER TABLE `project` DISABLE KEYS */;
299INSERT INTO `project` VALUES (1,25,'Prana','prana_logo.svg','prana_isotipo.svg','PRANA es un proyecto con modernos departamentos, vista privilegiada y acabados de primera. AdemÃ¡s cuenta con una ubicaciÃ³n estratÃ©gica en el distrito de Pueblo Libre cerca de las principales avenidas del distrito: Av. Sucre y Av. BolÃvar. Con PRANA Â¡vive cerca a todo!','http://www.prana132.pe','Av. Sucre 132','#AA00EF','prana_building_elevation.png','prana_night_building_elevation.png','prana_map.png',0,'2018-09-23 18:26:34','2018-09-23 18:26:34'),(2,4,'Duplo','duplo_logo.svg','duplo_isotipo.svg','DUPLO estÃ¡ ubicado en el distrito de BreÃ±a, el corazÃ³n de la ciudad y tiene alrededor zonas comerciales y servicios. AquÃ puedes disfrutar de Ã¡reas comunes para tÃ y tu familia. El proyecto cuenta con departamentos de 2 y 3 dormitorios. Un proyecto de: Cosapi Inmobiliaria y Grupo Lar.','http://www.duplo.com.pe','Av. Brasil 840','#0082C3','duplo_building_elevation.png','duplo_night_building_elevation.png','duplo_map.png',0,'2018-09-23 18:26:34','2018-09-23 18:26:34'),(3,13,'Nesta','nesta_logo.svg','nesta_isotipo.svg','NESTA estÃ¡ ubicado en una de las zonas con mayor plusvalÃa del distrito de JesÃºs MarÃa, alrededor del Campo de Marte. Adicionalmente, tiene a su alcance centros comerciales, educativos, clubes sociales, parques, entre otros.  Un proyecto de: Cosapi Inmobiliaria y Grupo Lar.','http://www.nesta.com.pe','Av. Salaverry 475','#EC0044','nesta_building_elevation.png','nesta_night_building_elevation.png','nesta_map.png',0,'2018-09-23 18:26:34','2018-09-23 18:26:34'),(4,17,'Velia','velia_logo.svg','velia_isotipo.svg','VELIA es un proyecto moderno con vista privilegiada y acabados de primera. Cuenta con departamentos de 1, 2 y 3 dormitorios. En VELIA cuentas con Ã¡reas sociales para que tÃº y tu familia disfruten de las comodidades de tu hogar.','http://www.velia.com.pe/','Av. Belisario 1035','#C4D600','velia_building_elevation.png','velia_night_building_elevation.png','velia_map.png',1,'2018-09-23 18:26:34','2018-09-23 18:26:34'),(5,41,'Ã‰piqe','epiqe_logo.svg','epiqe_isotipo.svg','Ã‰piqe estÃ¡ ubicado en la mejor zona de Surco, frente al Jockey Club y a pocas cuadras del Jockey Plaza que cuenta con una amplia variedad de opciones de restaurantes, tiendas exclusivas y entretenimiento. Con Ã¡reas sociales que complementarÃ¡n tu estilo de vida. Vive a tu ritmo, vive Ã‰piqe. Un proyecto de: Cosapi Inmobiliaria y Gerpal.','https://epiqe.pe','Av. OlguÃn 600','#942C67','epiqe_building_elevation.jpg','epiqe_night_building_elevation.png','epiqe_map.png',0,'2018-09-23 18:26:34','2018-09-23 18:26:34');
300/*!40000 ALTER TABLE `project` ENABLE KEYS */;
301UNLOCK TABLES;
302
303--
304-- Table structure for table `project_area`
305--
306
307DROP TABLE IF EXISTS `project_area`;
308/*!40101 SET @saved_cs_client     = @@character_set_client */;
309/*!40101 SET character_set_client = utf8 */;
310CREATE TABLE `project_area` (
311  `id` int(11) NOT NULL AUTO_INCREMENT,
312  `project_id` int(11) DEFAULT NULL,
313  `area_id` int(11) DEFAULT NULL,
314  `updated_at` datetime NOT NULL,
315  `created_at` datetime NOT NULL,
316  PRIMARY KEY (`id`),
317  KEY `IDX_EE05F570166D1F9C` (`project_id`),
318  KEY `IDX_EE05F570BD0F409C` (`area_id`),
319  CONSTRAINT `FK_EE05F570166D1F9C` FOREIGN KEY (`project_id`) REFERENCES `project` (`id`),
320  CONSTRAINT `FK_EE05F570BD0F409C` FOREIGN KEY (`area_id`) REFERENCES `area` (`id`)
321) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
322/*!40101 SET character_set_client = @saved_cs_client */;
323
324--
325-- Dumping data for table `project_area`
326--
327
328LOCK TABLES `project_area` WRITE;
329/*!40000 ALTER TABLE `project_area` DISABLE KEYS */;
330INSERT INTO `project_area` VALUES (1,1,1,'2018-09-23 18:26:34','2018-09-23 18:26:34'),(2,1,2,'2018-09-23 18:26:34','2018-09-23 18:26:34'),(3,1,3,'2018-09-23 18:26:34','2018-09-23 18:26:34'),(4,1,4,'2018-09-23 18:26:34','2018-09-23 18:26:34'),(5,1,5,'2018-09-23 18:26:34','2018-09-23 18:26:34'),(6,1,6,'2018-09-23 18:26:34','2018-09-23 18:26:34'),(7,2,7,'2018-09-23 18:26:34','2018-09-23 18:26:34'),(8,2,8,'2018-09-23 18:26:34','2018-09-23 18:26:34'),(9,2,9,'2018-09-23 18:26:34','2018-09-23 18:26:34'),(10,2,10,'2018-09-23 18:26:34','2018-09-23 18:26:34'),(11,2,11,'2018-09-23 18:26:34','2018-09-23 18:26:34'),(12,2,12,'2018-09-23 18:26:34','2018-09-23 18:26:34'),(13,3,13,'2018-09-23 18:26:34','2018-09-23 18:26:34'),(14,3,14,'2018-09-23 18:26:34','2018-09-23 18:26:34'),(15,3,15,'2018-09-23 18:26:34','2018-09-23 18:26:34'),(16,3,16,'2018-09-23 18:26:34','2018-09-23 18:26:34'),(17,3,17,'2018-09-23 18:26:34','2018-09-23 18:26:34'),(18,3,18,'2018-09-23 18:26:34','2018-09-23 18:26:34'),(19,4,19,'2018-09-23 18:26:34','2018-09-23 18:26:34'),(20,4,20,'2018-09-23 18:26:34','2018-09-23 18:26:34'),(21,4,21,'2018-09-23 18:26:34','2018-09-23 18:26:34'),(22,4,22,'2018-09-23 18:26:34','2018-09-23 18:26:34'),(23,4,23,'2018-09-23 18:26:34','2018-09-23 18:26:34'),(24,4,24,'2018-09-23 18:26:34','2018-09-23 18:26:34'),(25,5,25,'2018-09-23 18:26:34','2018-09-23 18:26:34'),(26,5,26,'2018-09-23 18:26:34','2018-09-23 18:26:34'),(27,5,27,'2018-09-23 18:26:34','2018-09-23 18:26:34'),(28,5,28,'2018-09-23 18:26:34','2018-09-23 18:26:34'),(29,5,29,'2018-09-23 18:26:34','2018-09-23 18:26:34'),(30,5,30,'2018-09-23 18:26:34','2018-09-23 18:26:34');
331/*!40000 ALTER TABLE `project_area` ENABLE KEYS */;
332UNLOCK TABLES;
333
334--
335-- Table structure for table `project_attribute`
336--
337
338DROP TABLE IF EXISTS `project_attribute`;
339/*!40101 SET @saved_cs_client     = @@character_set_client */;
340/*!40101 SET character_set_client = utf8 */;
341CREATE TABLE `project_attribute` (
342  `id` int(11) NOT NULL AUTO_INCREMENT,
343  `project_id` int(11) DEFAULT NULL,
344  `attribute_id` int(11) DEFAULT NULL,
345  `updated_at` datetime NOT NULL,
346  `created_at` datetime NOT NULL,
347  PRIMARY KEY (`id`),
348  KEY `IDX_EB46AA2C166D1F9C` (`project_id`),
349  KEY `IDX_EB46AA2CB6E62EFA` (`attribute_id`),
350  CONSTRAINT `FK_EB46AA2C166D1F9C` FOREIGN KEY (`project_id`) REFERENCES `project` (`id`),
351  CONSTRAINT `FK_EB46AA2CB6E62EFA` FOREIGN KEY (`attribute_id`) REFERENCES `attribute` (`id`)
352) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
353/*!40101 SET character_set_client = @saved_cs_client */;
354
355--
356-- Dumping data for table `project_attribute`
357--
358
359LOCK TABLES `project_attribute` WRITE;
360/*!40000 ALTER TABLE `project_attribute` DISABLE KEYS */;
361INSERT INTO `project_attribute` VALUES (1,1,1,'2018-09-23 18:26:34','2018-09-23 18:26:34'),(2,1,2,'2018-09-23 18:26:34','2018-09-23 18:26:34'),(3,1,3,'2018-09-23 18:26:34','2018-09-23 18:26:34'),(4,1,4,'2018-09-23 18:26:34','2018-09-23 18:26:34'),(5,1,5,'2018-09-23 18:26:34','2018-09-23 18:26:34'),(6,1,6,'2018-09-23 18:26:34','2018-09-23 18:26:34'),(7,2,7,'2018-09-23 18:26:34','2018-09-23 18:26:34'),(8,2,8,'2018-09-23 18:26:34','2018-09-23 18:26:34'),(9,2,9,'2018-09-23 18:26:34','2018-09-23 18:26:34'),(10,2,10,'2018-09-23 18:26:34','2018-09-23 18:26:34'),(11,2,11,'2018-09-23 18:26:34','2018-09-23 18:26:34'),(12,2,12,'2018-09-23 18:26:34','2018-09-23 18:26:34'),(13,3,13,'2018-09-23 18:26:34','2018-09-23 18:26:34'),(14,3,14,'2018-09-23 18:26:34','2018-09-23 18:26:34'),(15,3,15,'2018-09-23 18:26:34','2018-09-23 18:26:34'),(16,3,16,'2018-09-23 18:26:34','2018-09-23 18:26:34'),(17,3,17,'2018-09-23 18:26:34','2018-09-23 18:26:34'),(18,3,18,'2018-09-23 18:26:34','2018-09-23 18:26:34'),(19,4,19,'2018-09-23 18:26:34','2018-09-23 18:26:34'),(20,4,20,'2018-09-23 18:26:34','2018-09-23 18:26:34'),(21,4,21,'2018-09-23 18:26:34','2018-09-23 18:26:34'),(22,4,22,'2018-09-23 18:26:34','2018-09-23 18:26:34'),(23,4,23,'2018-09-23 18:26:34','2018-09-23 18:26:34'),(24,4,24,'2018-09-23 18:26:34','2018-09-23 18:26:34'),(25,5,25,'2018-09-23 18:26:34','2018-09-23 18:26:34'),(26,5,26,'2018-09-23 18:26:34','2018-09-23 18:26:34'),(27,5,27,'2018-09-23 18:26:34','2018-09-23 18:26:34'),(28,5,28,'2018-09-23 18:26:34','2018-09-23 18:26:34'),(29,5,29,'2018-09-23 18:26:34','2018-09-23 18:26:34'),(30,5,30,'2018-09-23 18:26:34','2018-09-23 18:26:34');
362/*!40000 ALTER TABLE `project_attribute` ENABLE KEYS */;
363UNLOCK TABLES;
364
365--
366-- Table structure for table `project_model`
367--
368
369DROP TABLE IF EXISTS `project_model`;
370/*!40101 SET @saved_cs_client     = @@character_set_client */;
371/*!40101 SET character_set_client = utf8 */;
372CREATE TABLE `project_model` (
373  `id` int(11) NOT NULL AUTO_INCREMENT,
374  `project_id` int(11) DEFAULT NULL,
375  `name` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL,
376  `image` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
377  `updated_at` datetime NOT NULL,
378  `created_at` datetime NOT NULL,
379  PRIMARY KEY (`id`),
380  KEY `IDX_C4C07B47166D1F9C` (`project_id`),
381  CONSTRAINT `FK_C4C07B47166D1F9C` FOREIGN KEY (`project_id`) REFERENCES `project` (`id`)
382) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
383/*!40101 SET character_set_client = @saved_cs_client */;
384
385--
386-- Dumping data for table `project_model`
387--
388
389LOCK TABLES `project_model` WRITE;
390/*!40000 ALTER TABLE `project_model` DISABLE KEYS */;
391INSERT INTO `project_model` VALUES (1,1,'','/resources/projects/prana/models/tipo-1.png','2018-09-23 18:26:34','2018-09-23 18:26:34'),(2,1,'','/resources/projects/prana/models/tipo-2-v2.png','2018-09-23 18:26:34','2018-09-23 18:26:34'),(3,1,'','/resources/projects/prana/models/tipo-2-v3.png','2018-09-23 18:26:34','2018-09-23 18:26:34'),(4,1,'','/resources/projects/prana/models/tipo-2001.png','2018-09-23 18:26:34','2018-09-23 18:26:34'),(5,1,'','/resources/projects/prana/models/tipo-2002.png','2018-09-23 18:26:34','2018-09-23 18:26:34'),(6,1,'','/resources/projects/prana/models/tipo-2003.png','2018-09-23 18:26:34','2018-09-23 18:26:34'),(7,1,'','/resources/projects/prana/models/tipo-2004.png','2018-09-23 18:26:34','2018-09-23 18:26:34'),(8,2,'','/resources/projects/duplo/models/Modelo-1.png','2018-09-23 18:26:34','2018-09-23 18:26:34'),(9,2,'','/resources/projects/duplo/models/Modelo-2.png','2018-09-23 18:26:34','2018-09-23 18:26:34'),(10,2,'','/resources/projects/duplo/models/Modelo-3.png','2018-09-23 18:26:34','2018-09-23 18:26:34'),(11,2,'','/resources/projects/duplo/models/Modelo-4.png','2018-09-23 18:26:34','2018-09-23 18:26:34'),(12,2,'','/resources/projects/duplo/models/Modelo-5.png','2018-09-23 18:26:34','2018-09-23 18:26:34'),(13,2,'','/resources/projects/duplo/models/Modelo-6.png','2018-09-23 18:26:34','2018-09-23 18:26:34'),(14,2,'','/resources/projects/duplo/models/Modelo-7.png','2018-09-23 18:26:34','2018-09-23 18:26:34'),(15,2,'','/resources/projects/duplo/models/Modelo-12.png','2018-09-23 18:26:34','2018-09-23 18:26:34'),(16,3,'','/resources/projects/nesta/models/X-05.png','2018-09-23 18:26:34','2018-09-23 18:26:34'),(17,3,'','/resources/projects/nesta/models/X-06.png','2018-09-23 18:26:34','2018-09-23 18:26:34'),(18,3,'','/resources/projects/nesta/models/X-07.png','2018-09-23 18:26:34','2018-09-23 18:26:34'),(19,3,'','/resources/projects/nesta/models/X-08.png','2018-09-23 18:26:34','2018-09-23 18:26:34'),(20,3,'','/resources/projects/nesta/models/X-09.png','2018-09-23 18:26:34','2018-09-23 18:26:34'),(21,3,'','/resources/projects/nesta/models/X-10.png','2018-09-23 18:26:34','2018-09-23 18:26:34'),(22,4,'','/resources/projects/velia/models/Modelo-1501.png','2018-09-23 18:26:34','2018-09-23 18:26:34'),(23,4,'','/resources/projects/velia/models/Modelo-1502.png','2018-09-23 18:26:34','2018-09-23 18:26:34'),(24,4,'','/resources/projects/velia/models/Modelo-1503.png','2018-09-23 18:26:34','2018-09-23 18:26:34'),(25,4,'','/resources/projects/velia/models/Modelo-1504.png','2018-09-23 18:26:34','2018-09-23 18:26:34'),(26,4,'','/resources/projects/velia/models/Modelo-X01.png','2018-09-23 18:26:34','2018-09-23 18:26:34'),(27,4,'','/resources/projects/velia/models/Modelo-X02.png','2018-09-23 18:26:34','2018-09-23 18:26:34'),(28,4,'','/resources/projects/velia/models/Modelo-X03.png','2018-09-23 18:26:34','2018-09-23 18:26:34'),(29,4,'','/resources/projects/velia/models/Modelo-X04.png','2018-09-23 18:26:34','2018-09-23 18:26:34'),(30,5,'','/resources/projects/Ã©piqe/models/tipo-epiqe-1.jpg','2018-09-23 18:26:34','2018-09-23 18:26:34'),(31,5,'','/resources/projects/Ã©piqe/models/tipo-epiqe-2.jpg','2018-09-23 18:26:34','2018-09-23 18:26:34'),(32,5,'','/resources/projects/Ã©piqe/models/tipo-epiqe-3.jpg','2018-09-23 18:26:34','2018-09-23 18:26:34'),(33,5,'','/resources/projects/Ã©piqe/models/tipo-epiqe-4.jpg','2018-09-23 18:26:34','2018-09-23 18:26:34');
392/*!40000 ALTER TABLE `project_model` ENABLE KEYS */;
393UNLOCK TABLES;
394
395--
396-- Table structure for table `project_photo`
397--
398
399DROP TABLE IF EXISTS `project_photo`;
400/*!40101 SET @saved_cs_client     = @@character_set_client */;
401/*!40101 SET character_set_client = utf8 */;
402CREATE TABLE `project_photo` (
403  `id` int(11) NOT NULL AUTO_INCREMENT,
404  `project_id` int(11) DEFAULT NULL,
405  `name` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
406  `image` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
407  `updated_at` datetime NOT NULL,
408  `created_at` datetime NOT NULL,
409  PRIMARY KEY (`id`),
410  KEY `IDX_7E28D86166D1F9C` (`project_id`),
411  CONSTRAINT `FK_7E28D86166D1F9C` FOREIGN KEY (`project_id`) REFERENCES `project` (`id`)
412) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
413/*!40101 SET character_set_client = @saved_cs_client */;
414
415--
416-- Dumping data for table `project_photo`
417--
418
419LOCK TABLES `project_photo` WRITE;
420/*!40000 ALTER TABLE `project_photo` DISABLE KEYS */;
421INSERT INTO `project_photo` VALUES (1,1,'Sala de coworking','/resources/projects/prana/photos/coworking.png','2018-09-23 18:26:34','2018-09-23 18:26:34'),(2,1,'Lobby','/resources/projects/prana/photos/lobby.png','2018-09-23 18:26:34','2018-09-23 18:26:34'),(3,1,'Ãrea gourmet','/resources/projects/prana/photos/Area-gourmet.png','2018-09-23 18:26:34','2018-09-23 18:26:34'),(4,1,'Sushi bar','/resources/projects/prana/photos/Sushi-bar.png','2018-09-23 18:26:34','2018-09-23 18:26:34'),(5,1,'Sala de usos multiples','/resources/projects/prana/photos/SUM-Adultos.png','2018-09-23 18:26:34','2018-09-23 18:26:34'),(6,1,'Gimnasio zen','/resources/projects/prana/photos/Gym.png','2018-09-23 18:26:34','2018-09-23 18:26:34'),(7,1,'Zona de bicicletas','/resources/projects/prana/photos/Zona-de-bicicletas.png','2018-09-23 18:26:34','2018-09-23 18:26:34'),(8,2,'Sala de coworking','/resources/projects/duplo/photos/Coworking.png','2018-09-23 18:26:34','2018-09-23 18:26:34'),(9,2,'Gimnasio','/resources/projects/duplo/photos/Gym-al-aire-libre.png','2018-09-23 18:26:34','2018-09-23 18:26:34'),(10,2,'Lobby','/resources/projects/duplo/photos/Lobby.png','2018-09-23 18:26:34','2018-09-23 18:26:34'),(11,2,'Piscina panorÃ¡mica','/resources/projects/duplo/photos/Piscina-panoramica.png','2018-09-23 18:26:34','2018-09-23 18:26:34'),(12,2,'Lobby','/resources/projects/duplo/photos/Lobby-2.png','2018-09-23 18:26:34','2018-09-23 18:26:34'),(13,2,'Sala de juegos','/resources/projects/duplo/photos/Sala-de-juegos.png','2018-09-23 18:26:34','2018-09-23 18:26:34'),(14,2,'Zona de parrilla','/resources/projects/duplo/photos/Zona-de-parrilla.png','2018-09-23 18:26:34','2018-09-23 18:26:34'),(15,3,'Lobby','/resources/projects/nesta/photos/Lobby-1.png','2018-09-23 18:26:34','2018-09-23 18:26:34'),(16,3,'Lobby','/resources/projects/nesta/photos/Lobby-3.png','2018-09-23 18:26:34','2018-09-23 18:26:34'),(17,3,'Zona de parrilla','/resources/projects/nesta/photos/Parrilla-1.png','2018-09-23 18:26:34','2018-09-23 18:26:34'),(18,3,'Zona de parrilla','/resources/projects/nesta/photos/Parrilla-2.png','2018-09-23 18:26:34','2018-09-23 18:26:34'),(19,3,'Terraza','/resources/projects/nesta/photos/Terraza-1.png','2018-09-23 18:26:34','2018-09-23 18:26:34'),(20,3,'Terraza','/resources/projects/nesta/photos/Terraza-3.png','2018-09-23 18:26:34','2018-09-23 18:26:34'),(21,3,'Terraza','/resources/projects/nesta/photos/Terraza-4.png','2018-09-23 18:26:34','2018-09-23 18:26:34'),(22,4,'Gimnasio','/resources/projects/velia/photos/Gym.png','2018-09-23 18:26:34','2018-09-23 18:26:34'),(23,4,'Lobby','/resources/projects/velia/photos/Lobby-2.png','2018-09-23 18:26:34','2018-09-23 18:26:34'),(24,4,'Patio','/resources/projects/velia/photos/Patio-1.png','2018-09-23 18:26:34','2018-09-23 18:26:34'),(25,4,'Patio','/resources/projects/velia/photos/Patio-1-v2.png','2018-09-23 18:26:34','2018-09-23 18:26:34'),(26,4,'Sala de usos mÃºltiples','/resources/projects/velia/photos/SUM-1.png','2018-09-23 18:26:34','2018-09-23 18:26:34'),(27,4,'Sala de usos mÃºltiples para niÃ±os','/resources/projects/velia/photos/SUM-kids.png','2018-09-23 18:26:34','2018-09-23 18:26:34'),(28,4,'Patio','/resources/projects/velia/photos/Patio-2.png','2018-09-23 18:26:34','2018-09-23 18:26:34');
422/*!40000 ALTER TABLE `project_photo` ENABLE KEYS */;
423UNLOCK TABLES;
424
425--
426-- Table structure for table `project_stage`
427--
428
429DROP TABLE IF EXISTS `project_stage`;
430/*!40101 SET @saved_cs_client     = @@character_set_client */;
431/*!40101 SET character_set_client = utf8 */;
432CREATE TABLE `project_stage` (
433  `id` int(11) NOT NULL AUTO_INCREMENT,
434  `project_id` int(11) DEFAULT NULL,
435  `stage_id` int(11) DEFAULT NULL,
436  `colour` varchar(6) COLLATE utf8mb4_unicode_ci NOT NULL,
437  `updated_at` datetime NOT NULL,
438  `created_at` datetime NOT NULL,
439  PRIMARY KEY (`id`),
440  KEY `IDX_D1299AF7166D1F9C` (`project_id`),
441  KEY `IDX_D1299AF72298D193` (`stage_id`),
442  CONSTRAINT `FK_D1299AF7166D1F9C` FOREIGN KEY (`project_id`) REFERENCES `project` (`id`),
443  CONSTRAINT `FK_D1299AF72298D193` FOREIGN KEY (`stage_id`) REFERENCES `stage` (`id`)
444) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
445/*!40101 SET character_set_client = @saved_cs_client */;
446
447--
448-- Dumping data for table `project_stage`
449--
450
451LOCK TABLES `project_stage` WRITE;
452/*!40000 ALTER TABLE `project_stage` DISABLE KEYS */;
453INSERT INTO `project_stage` VALUES (1,1,1,'AA00EF','2018-09-23 18:26:34','2018-09-23 18:26:34'),(2,2,1,'0082C3','2018-09-23 18:26:34','2018-09-23 18:26:34'),(3,2,2,'DF540D','2018-09-23 18:26:34','2018-09-23 18:26:34'),(4,3,1,'717271','2018-09-23 18:26:34','2018-09-23 18:26:34'),(5,3,3,'EC0044','2018-09-23 18:26:34','2018-09-23 18:26:34'),(6,4,4,'C4D600','2018-09-23 18:26:34','2018-09-23 18:26:34'),(7,5,8,'932C68','2018-09-23 18:26:34','2018-09-23 18:26:34');
454/*!40000 ALTER TABLE `project_stage` ENABLE KEYS */;
455UNLOCK TABLES;
456
457--
458-- Table structure for table `project_subscription`
459--
460
461DROP TABLE IF EXISTS `project_subscription`;
462/*!40101 SET @saved_cs_client     = @@character_set_client */;
463/*!40101 SET character_set_client = utf8 */;
464CREATE TABLE `project_subscription` (
465  `id` int(11) NOT NULL AUTO_INCREMENT,
466  `subscription_id` int(11) DEFAULT NULL,
467  `project_id` int(11) DEFAULT NULL,
468  `updated_at` datetime NOT NULL,
469  `created_at` datetime NOT NULL,
470  PRIMARY KEY (`id`),
471  UNIQUE KEY `UNIQ_896180B09A1887DC` (`subscription_id`),
472  KEY `IDX_896180B0166D1F9C` (`project_id`),
473  CONSTRAINT `FK_896180B0166D1F9C` FOREIGN KEY (`project_id`) REFERENCES `project` (`id`),
474  CONSTRAINT `FK_896180B09A1887DC` FOREIGN KEY (`subscription_id`) REFERENCES `subscription` (`id`)
475) ENGINE=InnoDB AUTO_INCREMENT=355 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
476/*!40101 SET character_set_client = @saved_cs_client */;
477
478--
479-- Dumping data for table `project_subscription`
480--
481
482LOCK TABLES `project_subscription` WRITE;
483/*!40000 ALTER TABLE `project_subscription` DISABLE KEYS */;
484INSERT INTO `project_subscription` VALUES (1,1,3,'2018-09-23 19:57:17','2018-09-23 19:57:17'),(2,2,5,'2018-09-23 20:21:59','2018-09-23 20:21:59'),(3,3,1,'2018-09-23 20:26:02','2018-09-23 20:26:02'),(4,4,1,'2018-09-23 20:27:27','2018-09-23 20:27:27'),(5,5,2,'2018-09-23 20:29:21','2018-09-23 20:29:21'),(6,6,5,'2018-09-24 03:59:52','2018-09-24 03:59:52'),(7,7,2,'2018-09-24 09:29:18','2018-09-24 09:29:18'),(8,8,3,'2018-09-24 10:53:00','2018-09-24 10:53:00'),(9,9,3,'2018-09-24 10:53:09','2018-09-24 10:53:09'),(10,10,5,'2018-09-24 14:20:24','2018-09-24 14:20:24'),(11,11,3,'2018-09-25 00:05:42','2018-09-25 00:05:42'),(12,12,5,'2018-09-25 06:54:50','2018-09-25 06:54:50'),(13,13,5,'2018-09-25 13:35:59','2018-09-25 13:35:59'),(14,14,5,'2018-09-25 13:36:11','2018-09-25 13:36:11'),(15,15,5,'2018-09-25 13:52:41','2018-09-25 13:52:41'),(16,16,1,'2018-09-25 16:21:35','2018-09-25 16:21:35'),(17,17,1,'2018-09-25 17:59:39','2018-09-25 17:59:39'),(18,18,5,'2018-09-25 19:56:23','2018-09-25 19:56:23'),(19,19,3,'2018-09-25 22:12:09','2018-09-25 22:12:09'),(20,20,5,'2018-09-25 22:15:38','2018-09-25 22:15:38'),(21,21,1,'2018-09-25 23:04:20','2018-09-25 23:04:20'),(22,22,1,'2018-09-25 23:13:38','2018-09-25 23:13:38'),(23,23,2,'2018-09-25 23:29:23','2018-09-25 23:29:23'),(24,24,2,'2018-09-26 04:35:52','2018-09-26 04:35:52'),(25,25,5,'2018-09-26 05:26:19','2018-09-26 05:26:19'),(26,26,2,'2018-09-26 14:53:52','2018-09-26 14:53:52'),(27,27,2,'2018-09-26 14:59:52','2018-09-26 14:59:52'),(28,28,2,'2018-09-26 15:03:22','2018-09-26 15:03:22'),(29,29,3,'2018-09-26 15:08:25','2018-09-26 15:08:25'),(30,30,3,'2018-09-26 15:14:09','2018-09-26 15:14:09'),(31,31,2,'2018-09-26 18:42:55','2018-09-26 18:42:55'),(32,32,2,'2018-09-26 19:09:32','2018-09-26 19:09:32'),(33,33,2,'2018-09-26 23:12:58','2018-09-26 23:12:58'),(34,34,1,'2018-09-27 14:29:37','2018-09-27 14:29:37'),(35,35,3,'2018-09-27 18:56:00','2018-09-27 18:56:00'),(36,36,2,'2018-09-27 20:19:15','2018-09-27 20:19:15'),(37,37,2,'2018-09-27 23:56:34','2018-09-27 23:56:34'),(38,38,3,'2018-09-28 01:31:24','2018-09-28 01:31:24'),(39,39,5,'2018-09-28 02:09:37','2018-09-28 02:09:37'),(40,40,3,'2018-09-28 04:08:54','2018-09-28 04:08:54'),(41,41,5,'2018-09-28 19:57:41','2018-09-28 19:57:41'),(42,42,2,'2018-09-29 01:22:21','2018-09-29 01:22:21'),(43,43,5,'2018-09-29 02:58:27','2018-09-29 02:58:27'),(44,44,5,'2018-09-29 12:06:11','2018-09-29 12:06:11'),(45,45,5,'2018-09-29 12:57:39','2018-09-29 12:57:39'),(46,46,5,'2018-09-29 12:59:02','2018-09-29 12:59:02'),(47,47,3,'2018-09-29 18:56:10','2018-09-29 18:56:10'),(48,48,3,'2018-09-29 22:10:20','2018-09-29 22:10:20'),(49,50,3,'2018-09-29 23:29:44','2018-09-29 23:29:44'),(50,51,2,'2018-09-30 01:16:16','2018-09-30 01:16:16'),(51,52,5,'2018-09-30 02:59:46','2018-09-30 02:59:46'),(52,53,1,'2018-09-30 11:54:23','2018-09-30 11:54:23'),(53,54,2,'2018-09-30 11:54:25','2018-09-30 11:54:25'),(54,55,5,'2018-09-30 13:27:06','2018-09-30 13:27:06'),(55,56,1,'2018-09-30 13:52:55','2018-09-30 13:52:55'),(56,58,5,'2018-09-30 15:47:14','2018-09-30 15:47:14'),(57,59,5,'2018-09-30 18:24:11','2018-09-30 18:24:11'),(58,60,2,'2018-09-30 22:25:03','2018-09-30 22:25:03'),(59,61,3,'2018-09-30 22:28:13','2018-09-30 22:28:13'),(60,62,5,'2018-09-30 23:39:06','2018-09-30 23:39:06'),(61,64,5,'2018-10-01 03:59:51','2018-10-01 03:59:51'),(62,65,5,'2018-10-01 13:30:46','2018-10-01 13:30:46'),(63,66,5,'2018-10-01 13:31:01','2018-10-01 13:31:01'),(64,67,2,'2018-10-01 13:31:39','2018-10-01 13:31:39'),(65,68,5,'2018-10-01 13:58:24','2018-10-01 13:58:24'),(66,69,5,'2018-10-01 16:40:24','2018-10-01 16:40:24'),(67,70,1,'2018-10-01 19:04:07','2018-10-01 19:04:07'),(68,71,1,'2018-10-01 19:15:06','2018-10-01 19:15:06'),(69,72,1,'2018-10-01 19:15:21','2018-10-01 19:15:21'),(70,73,3,'2018-10-01 20:40:58','2018-10-01 20:40:58'),(71,74,3,'2018-10-01 20:41:34','2018-10-01 20:41:34'),(72,75,2,'2018-10-01 22:30:23','2018-10-01 22:30:23'),(73,76,5,'2018-10-01 22:37:48','2018-10-01 22:37:48'),(74,77,5,'2018-10-01 22:41:07','2018-10-01 22:41:07'),(75,78,5,'2018-10-01 23:46:53','2018-10-01 23:46:53'),(76,79,5,'2018-10-01 23:47:21','2018-10-01 23:47:21'),(77,80,1,'2018-10-02 02:40:04','2018-10-02 02:40:04'),(78,81,3,'2018-10-02 04:04:57','2018-10-02 04:04:57'),(79,82,3,'2018-10-02 12:54:19','2018-10-02 12:54:19'),(80,83,2,'2018-10-02 14:59:49','2018-10-02 14:59:49'),(81,84,5,'2018-10-02 17:31:20','2018-10-02 17:31:20'),(82,85,5,'2018-10-02 17:31:39','2018-10-02 17:31:39'),(83,86,5,'2018-10-02 17:34:47','2018-10-02 17:34:47'),(84,87,5,'2018-10-02 18:51:23','2018-10-02 18:51:23'),(85,88,3,'2018-10-02 19:41:12','2018-10-02 19:41:12'),(86,89,5,'2018-10-02 19:43:32','2018-10-02 19:43:32'),(87,90,2,'2018-10-02 22:15:41','2018-10-02 22:15:41'),(88,91,5,'2018-10-02 23:20:45','2018-10-02 23:20:45'),(89,93,5,'2018-10-03 00:55:49','2018-10-03 00:55:49'),(90,94,5,'2018-10-03 15:38:18','2018-10-03 15:38:18'),(91,95,5,'2018-10-03 15:38:30','2018-10-03 15:38:30'),(92,96,2,'2018-10-03 15:58:33','2018-10-03 15:58:33'),(93,97,2,'2018-10-03 15:58:53','2018-10-03 15:58:53'),(94,98,3,'2018-10-03 18:40:09','2018-10-03 18:40:09'),(95,100,1,'2018-10-03 20:20:40','2018-10-03 20:20:40'),(96,101,1,'2018-10-03 20:56:37','2018-10-03 20:56:37'),(97,103,5,'2018-10-03 21:47:30','2018-10-03 21:47:30'),(98,104,3,'2018-10-03 23:16:36','2018-10-03 23:16:36'),(99,105,2,'2018-10-03 23:31:54','2018-10-03 23:31:54'),(100,106,2,'2018-10-04 01:40:03','2018-10-04 01:40:03'),(101,107,5,'2018-10-04 16:05:09','2018-10-04 16:05:09'),(102,108,3,'2018-10-04 19:35:04','2018-10-04 19:35:04'),(103,109,5,'2018-10-04 20:17:38','2018-10-04 20:17:38'),(104,110,5,'2018-10-05 02:07:47','2018-10-05 02:07:47'),(105,111,5,'2018-10-05 02:57:47','2018-10-05 02:57:47'),(106,112,5,'2018-10-05 16:34:21','2018-10-05 16:34:21'),(107,113,2,'2018-10-05 19:31:32','2018-10-05 19:31:32'),(108,114,2,'2018-10-05 19:31:48','2018-10-05 19:31:48'),(109,115,2,'2018-10-05 19:33:05','2018-10-05 19:33:05'),(110,116,2,'2018-10-05 19:35:06','2018-10-05 19:35:06'),(111,117,1,'2018-10-05 21:03:45','2018-10-05 21:03:45'),(112,118,1,'2018-10-05 22:24:53','2018-10-05 22:24:53'),(113,119,5,'2018-10-06 02:26:16','2018-10-06 02:26:16'),(114,120,3,'2018-10-06 07:30:17','2018-10-06 07:30:17'),(115,121,5,'2018-10-06 18:27:20','2018-10-06 18:27:20'),(116,122,5,'2018-10-06 19:07:57','2018-10-06 19:07:57'),(117,123,2,'2018-10-06 20:01:23','2018-10-06 20:01:23'),(118,124,2,'2018-10-06 20:01:47','2018-10-06 20:01:47'),(119,125,3,'2018-10-06 22:08:34','2018-10-06 22:08:34'),(120,126,1,'2018-10-06 22:39:40','2018-10-06 22:39:40'),(121,127,2,'2018-10-07 02:07:24','2018-10-07 02:07:24'),(122,128,1,'2018-10-07 03:01:56','2018-10-07 03:01:56'),(123,129,5,'2018-10-07 03:06:40','2018-10-07 03:06:40'),(124,130,5,'2018-10-07 03:07:55','2018-10-07 03:07:55'),(125,131,5,'2018-10-07 05:49:40','2018-10-07 05:49:40'),(126,132,5,'2018-10-07 05:49:54','2018-10-07 05:49:54'),(127,133,3,'2018-10-07 14:07:45','2018-10-07 14:07:45'),(128,134,5,'2018-10-07 15:30:43','2018-10-07 15:30:43'),(129,135,5,'2018-10-07 15:50:16','2018-10-07 15:50:16'),(130,137,2,'2018-10-08 02:34:52','2018-10-08 02:34:52'),(131,138,2,'2018-10-08 02:35:22','2018-10-08 02:35:22'),(132,139,5,'2018-10-08 04:18:30','2018-10-08 04:18:30'),(133,140,5,'2018-10-08 05:14:50','2018-10-08 05:14:50'),(134,141,3,'2018-10-08 12:25:53','2018-10-08 12:25:53'),(135,142,3,'2018-10-08 12:26:12','2018-10-08 12:26:12'),(136,143,1,'2018-10-08 12:44:21','2018-10-08 12:44:21'),(137,145,5,'2018-10-08 23:54:44','2018-10-08 23:54:44'),(138,146,5,'2018-10-09 00:05:16','2018-10-09 00:05:16'),(139,147,3,'2018-10-09 00:43:48','2018-10-09 00:43:48'),(140,148,3,'2018-10-09 02:58:02','2018-10-09 02:58:02'),(141,149,5,'2018-10-09 03:29:28','2018-10-09 03:29:28'),(142,150,3,'2018-10-09 03:57:53','2018-10-09 03:57:53'),(143,152,3,'2018-10-09 17:45:53','2018-10-09 17:45:53'),(144,154,2,'2018-10-09 20:00:27','2018-10-09 20:00:27'),(145,155,5,'2018-10-09 20:46:23','2018-10-09 20:46:23'),(146,156,1,'2018-10-10 00:32:52','2018-10-10 00:32:52'),(147,157,5,'2018-10-10 03:07:34','2018-10-10 03:07:34'),(148,158,1,'2018-10-10 04:23:26','2018-10-10 04:23:26'),(149,159,3,'2018-10-10 10:51:02','2018-10-10 10:51:02'),(150,160,5,'2018-10-10 11:11:26','2018-10-10 11:11:26'),(151,161,1,'2018-10-10 14:36:06','2018-10-10 14:36:06'),(152,162,2,'2018-10-10 14:40:14','2018-10-10 14:40:14'),(153,163,2,'2018-10-11 01:00:24','2018-10-11 01:00:24'),(154,164,2,'2018-10-11 01:00:59','2018-10-11 01:00:59'),(155,165,3,'2018-10-11 04:16:15','2018-10-11 04:16:15'),(156,166,1,'2018-10-11 11:01:02','2018-10-11 11:01:02'),(157,167,1,'2018-10-11 11:10:27','2018-10-11 11:10:27'),(158,168,1,'2018-10-11 11:10:40','2018-10-11 11:10:40'),(159,169,3,'2018-10-11 15:52:07','2018-10-11 15:52:07'),(160,170,3,'2018-10-11 16:52:25','2018-10-11 16:52:25'),(161,171,5,'2018-10-11 23:22:19','2018-10-11 23:22:19'),(162,172,5,'2018-10-11 23:22:32','2018-10-11 23:22:32'),(163,173,5,'2018-10-11 23:22:40','2018-10-11 23:22:40'),(164,174,3,'2018-10-11 23:28:36','2018-10-11 23:28:36'),(165,175,3,'2018-10-11 23:28:43','2018-10-11 23:28:43'),(166,176,1,'2018-10-12 01:21:50','2018-10-12 01:21:50'),(167,177,3,'2018-10-12 04:10:18','2018-10-12 04:10:18'),(168,178,3,'2018-10-12 04:32:10','2018-10-12 04:32:10'),(169,179,2,'2018-10-12 04:42:08','2018-10-12 04:42:08'),(170,180,1,'2018-10-12 05:00:32','2018-10-12 05:00:32'),(171,181,1,'2018-10-12 13:57:33','2018-10-12 13:57:33'),(172,182,1,'2018-10-12 15:43:47','2018-10-12 15:43:47'),(173,184,1,'2018-10-12 16:11:32','2018-10-12 16:11:32'),(174,185,3,'2018-10-12 17:23:39','2018-10-12 17:23:39'),(175,186,3,'2018-10-12 17:26:53','2018-10-12 17:26:53'),(176,187,3,'2018-10-12 17:43:50','2018-10-12 17:43:50'),(177,188,2,'2018-10-12 18:57:47','2018-10-12 18:57:47'),(178,189,1,'2018-10-12 19:02:58','2018-10-12 19:02:58'),(179,190,1,'2018-10-12 20:05:50','2018-10-12 20:05:50'),(180,191,2,'2018-10-12 20:06:31','2018-10-12 20:06:31'),(181,192,1,'2018-10-12 20:06:39','2018-10-12 20:06:39'),(182,193,3,'2018-10-12 20:07:17','2018-10-12 20:07:17'),(183,194,5,'2018-10-12 20:07:47','2018-10-12 20:07:47'),(184,195,5,'2018-10-12 20:16:38','2018-10-12 20:16:38'),(185,196,5,'2018-10-12 20:16:53','2018-10-12 20:16:53'),(186,197,3,'2018-10-13 03:10:43','2018-10-13 03:10:43'),(187,198,5,'2018-10-13 11:12:28','2018-10-13 11:12:28'),(188,199,1,'2018-10-13 11:53:48','2018-10-13 11:53:48'),(189,200,3,'2018-10-13 11:54:37','2018-10-13 11:54:37'),(190,201,2,'2018-10-13 14:22:34','2018-10-13 14:22:34'),(191,202,5,'2018-10-13 14:40:59','2018-10-13 14:40:59'),(192,203,1,'2018-10-13 15:57:15','2018-10-13 15:57:15'),(193,204,1,'2018-10-13 18:43:52','2018-10-13 18:43:52'),(194,205,2,'2018-10-14 00:06:53','2018-10-14 00:06:53'),(195,206,3,'2018-10-14 01:20:15','2018-10-14 01:20:15'),(196,207,5,'2018-10-14 02:26:35','2018-10-14 02:26:35'),(197,208,3,'2018-10-14 11:36:11','2018-10-14 11:36:11'),(198,209,1,'2018-10-14 13:58:57','2018-10-14 13:58:57'),(199,210,3,'2018-10-14 14:01:15','2018-10-14 14:01:15'),(200,211,2,'2018-10-14 19:54:52','2018-10-14 19:54:52'),(201,212,1,'2018-10-14 22:53:09','2018-10-14 22:53:09'),(202,213,2,'2018-10-15 00:03:53','2018-10-15 00:03:53'),(203,214,2,'2018-10-15 00:04:17','2018-10-15 00:04:17'),(204,215,3,'2018-10-15 00:08:09','2018-10-15 00:08:09'),(205,216,3,'2018-10-15 00:08:18','2018-10-15 00:08:18'),(206,217,3,'2018-10-15 00:08:38','2018-10-15 00:08:38'),(207,218,1,'2018-10-15 01:16:33','2018-10-15 01:16:33'),(208,219,2,'2018-10-15 02:06:57','2018-10-15 02:06:57'),(209,220,2,'2018-10-15 02:30:38','2018-10-15 02:30:38'),(210,221,3,'2018-10-15 02:31:30','2018-10-15 02:31:30'),(211,222,1,'2018-10-15 02:32:15','2018-10-15 02:32:15'),(212,223,5,'2018-10-15 03:27:39','2018-10-15 03:27:39'),(213,224,1,'2018-10-15 04:56:49','2018-10-15 04:56:49'),(214,225,1,'2018-10-15 09:43:29','2018-10-15 09:43:29'),(215,226,3,'2018-10-15 12:34:59','2018-10-15 12:34:59'),(216,227,5,'2018-10-15 18:01:01','2018-10-15 18:01:01'),(217,228,5,'2018-10-15 18:01:13','2018-10-15 18:01:13'),(218,229,3,'2018-10-15 18:25:36','2018-10-15 18:25:36'),(219,230,3,'2018-10-15 19:56:50','2018-10-15 19:56:50'),(220,231,5,'2018-10-15 20:50:32','2018-10-15 20:50:32'),(221,232,3,'2018-10-15 23:35:29','2018-10-15 23:35:29'),(222,233,1,'2018-10-16 01:23:32','2018-10-16 01:23:32'),(223,234,1,'2018-10-16 04:27:36','2018-10-16 04:27:36'),(224,235,1,'2018-10-16 06:19:54','2018-10-16 06:19:54'),(225,236,1,'2018-10-16 20:35:15','2018-10-16 20:35:15'),(226,237,1,'2018-10-16 20:35:31','2018-10-16 20:35:31'),(227,238,5,'2018-10-17 00:58:53','2018-10-17 00:58:53'),(228,239,1,'2018-10-17 02:26:20','2018-10-17 02:26:20'),(229,240,3,'2018-10-17 05:50:44','2018-10-17 05:50:44'),(230,241,5,'2018-10-17 12:09:58','2018-10-17 12:09:58'),(231,242,3,'2018-10-17 12:31:41','2018-10-17 12:31:41'),(232,243,3,'2018-10-17 12:59:29','2018-10-17 12:59:29'),(233,244,1,'2018-10-17 15:36:22','2018-10-17 15:36:22'),(234,245,2,'2018-10-17 20:30:28','2018-10-17 20:30:28'),(235,246,5,'2018-10-17 21:14:46','2018-10-17 21:14:46'),(236,247,2,'2018-10-17 21:32:44','2018-10-17 21:32:44'),(237,248,2,'2018-10-17 21:36:04','2018-10-17 21:36:04'),(238,249,3,'2018-10-17 23:04:13','2018-10-17 23:04:13'),(239,250,3,'2018-10-17 23:19:50','2018-10-17 23:19:50'),(240,251,3,'2018-10-17 23:23:16','2018-10-17 23:23:16'),(241,252,5,'2018-10-17 23:23:56','2018-10-17 23:23:56'),(242,253,2,'2018-10-17 23:24:30','2018-10-17 23:24:30'),(243,254,1,'2018-10-17 23:44:56','2018-10-17 23:44:56'),(244,255,1,'2018-10-18 02:59:41','2018-10-18 02:59:41'),(245,256,3,'2018-10-18 04:22:35','2018-10-18 04:22:35'),(246,257,2,'2018-10-18 05:59:04','2018-10-18 05:59:04'),(247,258,3,'2018-10-18 13:32:08','2018-10-18 13:32:08'),(248,259,2,'2018-10-18 16:08:15','2018-10-18 16:08:15'),(249,260,2,'2018-10-18 16:08:55','2018-10-18 16:08:55'),(250,261,2,'2018-10-18 16:09:25','2018-10-18 16:09:25'),(251,262,3,'2018-10-18 17:29:43','2018-10-18 17:29:43'),(252,263,5,'2018-10-18 17:32:43','2018-10-18 17:32:43'),(253,264,3,'2018-10-18 19:00:25','2018-10-18 19:00:25'),(254,265,1,'2018-10-18 20:39:59','2018-10-18 20:39:59'),(255,266,1,'2018-10-19 00:07:10','2018-10-19 00:07:10'),(256,267,1,'2018-10-19 00:51:10','2018-10-19 00:51:10'),(257,268,1,'2018-10-19 00:51:24','2018-10-19 00:51:24'),(258,269,1,'2018-10-19 01:26:46','2018-10-19 01:26:46'),(259,270,5,'2018-10-19 03:46:57','2018-10-19 03:46:57'),(260,271,1,'2018-10-19 06:09:29','2018-10-19 06:09:29'),(261,272,1,'2018-10-19 08:42:59','2018-10-19 08:42:59'),(262,273,1,'2018-10-19 08:43:26','2018-10-19 08:43:26'),(263,275,1,'2018-10-19 16:40:59','2018-10-19 16:40:59'),(264,276,1,'2018-10-19 22:01:56','2018-10-19 22:01:56'),(265,277,1,'2018-10-19 22:02:18','2018-10-19 22:02:18'),(266,278,1,'2018-10-20 01:28:35','2018-10-20 01:28:35'),(267,279,1,'2018-10-20 01:28:59','2018-10-20 01:28:59'),(268,280,3,'2018-10-20 18:22:24','2018-10-20 18:22:24'),(269,281,3,'2018-10-20 18:22:40','2018-10-20 18:22:40'),(270,282,3,'2018-10-20 19:39:36','2018-10-20 19:39:36'),(271,283,5,'2018-10-20 19:42:34','2018-10-20 19:42:34'),(272,284,5,'2018-10-20 23:30:00','2018-10-20 23:30:00'),(273,285,5,'2018-10-20 23:30:16','2018-10-20 23:30:16'),(274,286,3,'2018-10-21 00:41:38','2018-10-21 00:41:38'),(275,287,5,'2018-10-21 01:01:27','2018-10-21 01:01:27'),(276,288,1,'2018-10-21 04:07:52','2018-10-21 04:07:52'),(277,289,3,'2018-10-21 04:09:15','2018-10-21 04:09:15'),(278,290,5,'2018-10-21 05:15:54','2018-10-21 05:15:54'),(279,291,5,'2018-10-21 13:21:59','2018-10-21 13:21:59'),(280,292,5,'2018-10-21 13:34:55','2018-10-21 13:34:55'),(281,293,2,'2018-10-21 19:13:17','2018-10-21 19:13:17'),(282,294,2,'2018-10-21 20:22:55','2018-10-21 20:22:55'),(283,295,2,'2018-10-21 20:23:25','2018-10-21 20:23:25'),(284,296,3,'2018-10-21 20:29:57','2018-10-21 20:29:57'),(285,297,5,'2018-10-22 01:49:54','2018-10-22 01:49:54'),(286,298,5,'2018-10-22 01:50:16','2018-10-22 01:50:16'),(287,299,3,'2018-10-22 02:44:06','2018-10-22 02:44:06'),(288,300,5,'2018-10-22 03:46:49','2018-10-22 03:46:49'),(289,301,5,'2018-10-22 04:51:49','2018-10-22 04:51:49'),(290,302,1,'2018-10-22 16:57:35','2018-10-22 16:57:35'),(291,303,1,'2018-10-22 16:57:47','2018-10-22 16:57:47'),(292,304,3,'2018-10-22 17:28:55','2018-10-22 17:28:55'),(293,305,3,'2018-10-22 18:14:23','2018-10-22 18:14:23'),(294,307,1,'2018-10-22 22:41:42','2018-10-22 22:41:42'),(295,308,3,'2018-10-23 01:46:07','2018-10-23 01:46:07'),(296,310,2,'2018-10-23 16:50:29','2018-10-23 16:50:29'),(297,311,5,'2018-10-23 17:35:03','2018-10-23 17:35:03'),(298,312,3,'2018-10-24 01:39:15','2018-10-24 01:39:15'),(299,313,3,'2018-10-24 02:14:49','2018-10-24 02:14:49'),(300,314,3,'2018-10-24 05:30:17','2018-10-24 05:30:17'),(301,315,5,'2018-10-24 13:31:29','2018-10-24 13:31:29'),(302,316,5,'2018-10-24 22:03:33','2018-10-24 22:03:33'),(303,317,5,'2018-10-24 22:04:00','2018-10-24 22:04:00'),(304,319,5,'2018-10-25 00:26:15','2018-10-25 00:26:15'),(305,321,5,'2018-10-25 02:01:30','2018-10-25 02:01:30'),(306,322,3,'2018-10-25 05:28:20','2018-10-25 05:28:20'),(307,323,5,'2018-10-25 13:14:30','2018-10-25 13:14:30'),(308,324,3,'2018-10-25 13:37:22','2018-10-25 13:37:22'),(309,325,5,'2018-10-25 15:42:52','2018-10-25 15:42:52'),(310,326,1,'2018-10-25 15:45:09','2018-10-25 15:45:09'),(311,327,1,'2018-10-25 19:46:27','2018-10-25 19:46:27'),(312,328,1,'2018-10-25 19:46:37','2018-10-25 19:46:37'),(313,329,3,'2018-10-25 20:52:02','2018-10-25 20:52:02'),(314,330,3,'2018-10-25 21:01:26','2018-10-25 21:01:26'),(315,331,3,'2018-10-25 22:00:04','2018-10-25 22:00:04'),(316,332,3,'2018-10-25 22:00:14','2018-10-25 22:00:14'),(317,333,3,'2018-10-25 22:12:45','2018-10-25 22:12:45'),(318,335,5,'2018-10-26 09:24:56','2018-10-26 09:24:56'),(319,336,1,'2018-10-26 11:33:19','2018-10-26 11:33:19'),(320,337,1,'2018-10-26 15:16:21','2018-10-26 15:16:21'),(321,338,3,'2018-10-26 19:56:27','2018-10-26 19:56:27'),(322,339,3,'2018-10-26 19:57:30','2018-10-26 19:57:30'),(323,340,1,'2018-10-26 19:58:17','2018-10-26 19:58:17'),(324,341,3,'2018-10-27 05:18:16','2018-10-27 05:18:16'),(325,342,3,'2018-10-28 13:51:46','2018-10-28 13:51:46'),(326,343,3,'2018-10-28 13:52:05','2018-10-28 13:52:05'),(327,344,1,'2018-10-28 17:24:52','2018-10-28 17:24:52'),(328,345,1,'2018-10-28 17:33:07','2018-10-28 17:33:07'),(329,346,3,'2018-10-28 17:42:49','2018-10-28 17:42:49'),(330,347,5,'2018-10-28 18:25:25','2018-10-28 18:25:25'),(331,348,5,'2018-10-28 21:42:12','2018-10-28 21:42:12'),(332,349,3,'2018-10-28 21:51:24','2018-10-28 21:51:24'),(333,350,5,'2018-10-29 00:44:12','2018-10-29 00:44:12'),(334,351,5,'2018-10-29 00:44:26','2018-10-29 00:44:26'),(335,352,3,'2018-10-29 00:46:48','2018-10-29 00:46:48'),(336,353,2,'2018-10-29 01:41:52','2018-10-29 01:41:52'),(337,354,2,'2018-10-29 01:42:12','2018-10-29 01:42:12'),(338,355,1,'2018-10-29 15:14:30','2018-10-29 15:14:30'),(339,356,1,'2018-10-29 16:52:27','2018-10-29 16:52:27'),(340,357,5,'2018-10-29 20:29:32','2018-10-29 20:29:32'),(341,358,5,'2018-10-29 21:01:01','2018-10-29 21:01:01'),(342,359,3,'2018-10-29 21:02:43','2018-10-29 21:02:43'),(343,360,5,'2018-10-30 13:53:30','2018-10-30 13:53:30'),(344,361,1,'2018-10-30 15:09:08','2018-10-30 15:09:08'),(345,362,1,'2018-10-30 16:25:51','2018-10-30 16:25:51'),(346,363,1,'2018-10-30 17:08:52','2018-10-30 17:08:52'),(347,364,1,'2018-10-30 18:04:42','2018-10-30 18:04:42'),(348,365,5,'2018-10-30 19:22:09','2018-10-30 19:22:09'),(349,366,5,'2018-10-30 20:23:10','2018-10-30 20:23:10'),(350,367,2,'2018-10-31 01:18:13','2018-10-31 01:18:13'),(351,370,5,'2018-10-31 04:03:27','2018-10-31 04:03:27'),(352,371,2,'2018-10-31 14:04:02','2018-10-31 14:04:02'),(353,372,5,'2018-10-31 16:08:53','2018-10-31 16:08:53'),(354,373,3,'2018-10-31 17:44:18','2018-10-31 17:44:18');
485/*!40000 ALTER TABLE `project_subscription` ENABLE KEYS */;
486UNLOCK TABLES;
487
488--
489-- Table structure for table `stage`
490--
491
492DROP TABLE IF EXISTS `stage`;
493/*!40101 SET @saved_cs_client     = @@character_set_client */;
494/*!40101 SET character_set_client = utf8 */;
495CREATE TABLE `stage` (
496  `id` int(11) NOT NULL AUTO_INCREMENT,
497  `name` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL,
498  `updated_at` datetime NOT NULL,
499  `created_at` datetime NOT NULL,
500  PRIMARY KEY (`id`)
501) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
502/*!40101 SET character_set_client = @saved_cs_client */;
503
504--
505-- Dumping data for table `stage`
506--
507
508LOCK TABLES `stage` WRITE;
509/*!40000 ALTER TABLE `stage` DISABLE KEYS */;
510INSERT INTO `stage` VALUES (1,'En construcciÃ³n','2018-09-23 18:26:34','2018-09-23 18:26:34'),(2,'Pronta entrega','2018-09-23 18:26:34','2018-09-23 18:26:34'),(3,'Entrega inmediata','2018-09-23 18:26:34','2018-09-23 18:26:34'),(4,'Entregado','2018-09-23 18:26:34','2018-09-23 18:26:34'),(5,'DemoliciÃ³n','2018-09-23 18:26:34','2018-09-23 18:26:34'),(6,'Vendido','2018-09-23 18:26:34','2018-09-23 18:26:34'),(7,'ExcavaciÃ³n','2018-09-23 18:26:34','2018-09-23 18:26:34'),(8,'Lanzamiento','2018-09-23 18:26:34','2018-09-23 18:26:34');
511/*!40000 ALTER TABLE `stage` ENABLE KEYS */;
512UNLOCK TABLES;
513
514--
515-- Table structure for table `state_request`
516--
517
518DROP TABLE IF EXISTS `state_request`;
519/*!40101 SET @saved_cs_client     = @@character_set_client */;
520/*!40101 SET character_set_client = utf8 */;
521CREATE TABLE `state_request` (
522  `id` int(11) NOT NULL AUTO_INCREMENT,
523  `subscription_id` int(11) DEFAULT NULL,
524  `district_id` int(11) DEFAULT NULL,
525  `address` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL,
526  `zone` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL,
527  `updated_at` datetime NOT NULL,
528  `created_at` datetime NOT NULL,
529  PRIMARY KEY (`id`),
530  UNIQUE KEY `UNIQ_7DF7F5399A1887DC` (`subscription_id`),
531  KEY `IDX_7DF7F539B08FA272` (`district_id`),
532  CONSTRAINT `FK_7DF7F5399A1887DC` FOREIGN KEY (`subscription_id`) REFERENCES `subscription` (`id`),
533  CONSTRAINT `FK_7DF7F539B08FA272` FOREIGN KEY (`district_id`) REFERENCES `district` (`id`)
534) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
535/*!40101 SET character_set_client = @saved_cs_client */;
536
537--
538-- Dumping data for table `state_request`
539--
540
541LOCK TABLES `state_request` WRITE;
542/*!40000 ALTER TABLE `state_request` DISABLE KEYS */;
543/*!40000 ALTER TABLE `state_request` ENABLE KEYS */;
544UNLOCK TABLES;
545
546--
547-- Table structure for table `subscription`
548--
549
550DROP TABLE IF EXISTS `subscription`;
551/*!40101 SET @saved_cs_client     = @@character_set_client */;
552/*!40101 SET character_set_client = utf8 */;
553CREATE TABLE `subscription` (
554  `id` int(11) NOT NULL AUTO_INCREMENT,
555  `first_name` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
556  `last_name` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
557  `phone_number` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
558  `email` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
559  `message` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
560  `updated_at` datetime NOT NULL,
561  `created_at` datetime NOT NULL,
562  PRIMARY KEY (`id`)
563) ENGINE=InnoDB AUTO_INCREMENT=374 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
564/*!40101 SET character_set_client = @saved_cs_client */;
565
566--
567-- Dumping data for table `subscription`
568--
569
570LOCK TABLES `subscription` WRITE;
571/*!40000 ALTER TABLE `subscription` DISABLE KEYS */;
572INSERT INTO `subscription` VALUES (1,'Monica','Ferreyros','999504131','monaferv@gmail.com','CotizaciÃ³n Dpti Salaverry 3 dormitorios','2018-09-23 19:57:17','2018-09-23 19:57:17'),(2,'Diana','Leiva urco','942013159','sdiana_mlu_235@hotmail.comb','Estoy interesada para cuando se termina la construccion cual es el precio d los departamentos tienen cocheras incluidas y cuota inicial minima','2018-09-23 20:21:59','2018-09-23 20:21:59'),(3,'Diana','Leiva urco','942013159','sdiana_mlu_235@hotmail.com','Cuando se entregan precios','2018-09-23 20:26:02','2018-09-23 20:26:02'),(4,'Diana','Leiva urco','942013159','sdiana_mlu_235@hotmail.com','Cuando entregan precio','2018-09-23 20:27:27','2018-09-23 20:27:27'),(5,'Diana','Leiva urco','942013159','sdiana_mlu_235@hotmail.com','Precio cuando entregan','2018-09-23 20:29:21','2018-09-23 20:29:21'),(6,'Miguel','Alvites','997079901','mgerardo_3011@hotmail.com','.','2018-09-24 03:59:52','2018-09-24 03:59:52'),(7,'Melina','Cancho','998251195','melina-cancho@hotmail.com','Informacion completa del costo.gracias','2018-09-24 09:29:18','2018-09-24 09:29:18'),(8,'Liliam','Mamani','987249899','klis30@hotmail.com','Precio por departamento de 2 habitaciones','2018-09-24 10:53:00','2018-09-24 10:53:00'),(9,'Liliam','Mamani','987249899','klis30@hotmail.com','Precio por departamento de 2 habitaciones','2018-09-24 10:53:09','2018-09-24 10:53:09'),(10,'Milagros','Castellano','976770420','mcastellanof@icloud.com','Deseo saber el precio de los departamentos ','2018-09-24 14:20:24','2018-09-24 14:20:24'),(11,'Liana','Villa','956847742','dona8623@gmail.com','InformaciÃ³n a mi correo por favor','2018-09-25 00:05:42','2018-09-25 00:05:42'),(12,'Maria','Gutierrez ','999668531','mgmguty@gmail.com','Me gustarÃa visitsrlos','2018-09-25 06:54:50','2018-09-25 06:54:50'),(13,'Marleny','Garcia','956725255','Marleschultz@yahoo.es','Me intetesa departamento 2 dormitorios','2018-09-25 13:35:59','2018-09-25 13:35:59'),(14,'Marleny','Garcia','956725255','Marleschultz@yahoo.es','Me intetesa departamento 2 dormitorios','2018-09-25 13:36:11','2018-09-25 13:36:11'),(15,'Aracely','Mosquera','982369848','vaitiare.mm@gmail.com','Buenos dÃas, me gustarÃa detalle sobre los precios de los departamentos','2018-09-25 13:52:41','2018-09-25 13:52:41'),(16,'prueba','prueba','558985665','prueba@mail.com','test','2018-09-25 16:21:35','2018-09-25 16:21:35'),(17,'porfirio','villar','990995560','villarporfirio@yahoo.com','el costo, Ã¡rea, cuota inicial y la mensualidad,gracias','2018-09-25 17:59:39','2018-09-25 17:59:39'),(18,'GONZALO','MENDIOLA POZO','931349129','g_mendiola_pozo@hotmail.com','Buenas tardes,\r\n\r\nMe gustarÃa informaciÃ³n de precios, plazos de entrega y financiamiento del proyecto epique en el formato de 78 m2. Y saber si es que van a contar con formatos de mayor metrado, gracias.\r\n\r\nslds,\r\n\r\nGonzalo Mendiola','2018-09-25 19:56:23','2018-09-25 19:56:23'),(19,'Maritza','Arias','993816631','maritzaasuncionariasramos@gmail.com','Enviarme costo del duplex 3 dormitorios el piso de ubicaciÃ³n y el Ã¡rea .\r\nEnviar costo de flats de 3 dormitorios','2018-09-25 22:12:09','2018-09-25 22:12:09'),(20,'prueba','prueba','998554552','prueba@mail.com','prueba','2018-09-25 22:15:38','2018-09-25 22:15:38'),(21,'juan','hidalgo','9984751126','jhidal23@hotmail.com','-','2018-09-25 23:04:20','2018-09-25 23:04:20'),(22,'juan','hidalgo','9984751126','jhidal23@hotmail.com','-','2018-09-25 23:13:38','2018-09-25 23:13:38'),(23,'Grace','Diaz','954165899','grace.diaz1@hotmail.com','InformaciÃ³n por favor. Departamentos de 2 dormitorios\r\n','2018-09-25 23:29:23','2018-09-25 23:29:23'),(24,'JosÃ©','Castillejo','959949180','jacastillejot@hotmail.com','Info sobre departamentos en breÃ±a','2018-09-26 04:35:52','2018-09-26 04:35:52'),(25,'Susan','Xu','942457831','susan.xu1110@gmail.com','Hola por favor enviarme informaciÃ³n del proyecto. Saludos ','2018-09-26 05:26:19','2018-09-26 05:26:19'),(26,'julio','cesar','55338859','jul19984@gmail.com','-','2018-09-26 14:53:52','2018-09-26 14:53:52'),(27,'julio','cesar','55338859','jul19984@gmail.com','-','2018-09-26 14:59:52','2018-09-26 14:59:52'),(28,'julio','cesar','55338859','jul19984@gmail.com','-','2018-09-26 15:03:22','2018-09-26 15:03:22'),(29,'david','acosta','998745445','dvac_2015@gmail.com','+info','2018-09-26 15:08:25','2018-09-26 15:08:25'),(30,'david','acosta','998745445','dvac_2015@gmail.com','+info','2018-09-26 15:14:09','2018-09-26 15:14:09'),(31,'GISELLA NATALY','VALENTIN ZARATE','947929691','guise_vz@hotmail.com','INFORMACION DE PRECIOS','2018-09-26 18:42:55','2018-09-26 18:42:55'),(32,'Raquel','Caruajulca Idrogo','969542742','raquel_ci7i@hotmail.com','Precios del departamento de e habitaciones','2018-09-26 19:09:32','2018-09-26 19:09:32'),(33,'MARIA YAMINA','DE LA CRUZ HERNANDEZ','961566921','yami.dlc.her@gmail.com','InformaciÃ³n, cotizacion de departamento 3 dormitorios','2018-09-26 23:12:58','2018-09-26 23:12:58'),(34,'adolfo','aranguren','916391466','danieladolfo.aranguren@gmail.com','Buen dÃa favor de remitirme a mi bandeja los costos de los departamentos de PRANA y DUPLO. Muchas gracias','2018-09-27 14:29:37','2018-09-27 14:29:37'),(35,'Denis','Valdivia Flores','945277636','valdilibra@hotmail.com','precios ','2018-09-27 18:56:00','2018-09-27 18:56:00'),(36,'ROCIO','BELITO','940294583','rocio_hb406@hotmail.com','PRECIO','2018-09-27 20:19:15','2018-09-27 20:19:15'),(37,'HUGO RAUL','HERRERA TORRES','976459726','magalytf20@hotmail.com','deseo adquirir un departamento en primer piso por santiago de surco, cerca a la molina','2018-09-27 23:56:34','2018-09-27 23:56:34'),(38,'Kathy','Laura cuadrado','971199200','Katy75215@hotmail.com','InformaciÃ³n de precio de departamento con 2 y 3 dormitorios','2018-09-28 01:31:24','2018-09-28 01:31:24'),(39,'Leinny','Garcia Moran','959886986','leinnymelody@outlook.es','me estoy mudando a Lima por motivos laborales y deseo informacion del proyecto con suma urgencia ','2018-09-28 02:09:37','2018-09-28 02:09:37'),(40,'Betzy Zaida','Yanqui Quispe','951007886','yanquib@hotmail.com','departamento 3 dormitorios','2018-09-28 04:08:54','2018-09-28 04:08:54'),(41,'julio','guillen','941592329','julio.guillen@hotmail.com','precio de 78 m2','2018-09-28 19:57:41','2018-09-28 19:57:41'),(42,'Sheyla','Wong','961877111','swong2021@gmail.com','Por favor brindarme precios de los duplos y departamentos con 3 dormitorios. Muchas Gracias','2018-09-29 01:22:21','2018-09-29 01:22:21'),(43,'Zoila','Figueroa','959782225','zoilf.mt@gmail.com','Deseo informaciÃ³n departamento en Manuel OlguÃn surco departamento de 2 dormitorios','2018-09-29 02:58:27','2018-09-29 02:58:27'),(44,'Marina','Minaya','965747311','Marinaminaya@yahoo.es','Precios de 1 dormitorio y el banco que financia','2018-09-29 12:06:11','2018-09-29 12:06:11'),(45,'Rosario','De Tovar','920474610','ross01dmrsac@yahoo.com','Buenos dÃas por favor necesito informaciÃ³n detallada del Departamento ubicado en la Av. Manuel OlguÃn. ','2018-09-29 12:57:39','2018-09-29 12:57:39'),(46,'Miguel','Tovar','978010806','ross01dmrsac@yahoo.com','Que otros departamento tienen en el distrito de Surco. ','2018-09-29 12:59:02','2018-09-29 12:59:02'),(47,'Maria','Gonzales','974129793','santosaabath1975@hotmail.com','Ne','2018-09-29 18:56:10','2018-09-29 18:56:10'),(48,'Erika','Rospigliosi ','963915555','ecaso92@gmail.com','Informacion ','2018-09-29 22:10:20','2018-09-29 22:10:20'),(49,'Bettsy','Ku Navarro','992815398','bettsyku@gmail.com','estoy interesada en un departamento de 3 habitaciones en edificio Nesta ','2018-09-29 23:10:49','2018-09-29 23:10:49'),(50,'bettsy','ku navarro','992815398','bettsyku@gmail.com','estoy interesada en un departamento de 3 habitaciones','2018-09-29 23:29:44','2018-09-29 23:29:44'),(51,'Dorio','Lara','980057535','doriolara16@hotmail.com','Hola informacion de 1 solo dormitorio y de 2 dormitorios','2018-09-30 01:16:16','2018-09-30 01:16:16'),(52,'richard','suarez','997942477','rsuarez489@gmail.com','Buenas noches, hace unos meses estuve en el FIP y pude ver de cerca los proyectos inmobiliarios. Estoy interesado en ver que proyectos en plano tienen, para entrega desde Julio 2019 aprox. estarÃ© completando una inicial de S/ 80k aprox para abril y quisiera estar ya viendo proyectos para aplicar. Los distritos que me interesan son Jesus Maria, San Borja, Surco, San Isidro, Lince, Surquillo y Miraflores.\r\n\r\nquedo atento gracias.','2018-09-30 02:59:46','2018-09-30 02:59:46'),(53,'Rolando','Ramitez','999267663','rryrc@hotmail.com','Por favor enviarme precios de los duplex mas estacionamiento y financiacion y mas informacion','2018-09-30 11:54:23','2018-09-30 11:54:23'),(54,'Gabina Asunta','Giraldo AragÃ³n','958342392','gabygira3@hotmail.com','Proyectos en Arequipa','2018-09-30 11:54:25','2018-09-30 11:54:25'),(55,'JesÃºs','Quispe Taboada','981017751','jaqt24@gmail.com','Departamentos de 1 Dormitorio','2018-09-30 13:27:06','2018-09-30 13:27:06'),(56,'RaÃºl Ernesto','Quispe Mitma','998843336','raul.eqm@gmail.com','Cotizar modelÃ³ tipo 1 y 2002','2018-09-30 13:52:55','2018-09-30 13:52:55'),(57,'tania','curi','658316156','tays_agosto@hotmail.com','hola buenas tardes quisierÃ¡ vender una casa pero no se como va ustedes cobran por porcentaje  me gustarÃa saber cÃ³mo funciona esta inmobiliaria  gracias ','2018-09-30 15:39:06','2018-09-30 15:39:06'),(58,'Saki','Saito','947134149','Saki0328@hotmail.com','MÃ¡s informaciÃ³n de sep de 2 cuartos. Gracias!','2018-09-30 15:47:14','2018-09-30 15:47:14'),(59,'Bertha ','Toledo Estrada','996293614','Betoes100@hotmail.com','Precio, Ã¡rea de 3 dormitorios','2018-09-30 18:24:11','2018-09-30 18:24:11'),(60,'Adalberto','flores ','980303587','betofz94@hotmail.com','favor precios y financiamiento','2018-09-30 22:25:03','2018-09-30 22:25:03'),(61,'adalberto','flores','980303587','betofz94@hotmail.com','favor precio y fanaciamiento','2018-09-30 22:28:13','2018-09-30 22:28:13'),(62,'Maria','Mendoza','958091622','maritzamb5252@gmail.com','Departamento con tres dormitorios y cochera','2018-09-30 23:39:06','2018-09-30 23:39:06'),(63,'angelica','cossio','947260632','angelicacv2011@hotmail.com','quiero alquilar mi departamento quiero informes','2018-10-01 00:50:57','2018-10-01 00:50:57'),(64,'Manuel ','Rueda ','994503980','manrue_md@hotmail.com','Informacion','2018-10-01 03:59:51','2018-10-01 03:59:51'),(65,'Carmela','Trujillo','990869960','jrct1946@yahoo.com','InformaciÃ³n por favor','2018-10-01 13:30:46','2018-10-01 13:30:46'),(66,'Carmela','Trujillo','990869960','jrct1946@yahoo.com','InformaciÃ³n por favor','2018-10-01 13:31:01','2018-10-01 13:31:01'),(67,'Araceli','Barrera','973077115','araceli_f7@hotmail.com','Favor costo departamento 3 habitaciones, en que piso tiene disponible y precio r','2018-10-01 13:31:39','2018-10-01 13:31:39'),(68,'Lincoln','Rodriguez','992772650','lincolnrc20@yahoo.com','Ampliar informaciÃ³n de este proyecto o similar','2018-10-01 13:58:24','2018-10-01 13:58:24'),(69,'Yolanda Mercedes','Vega Lopez','966427100','yvega2783@gmail.com','Buenos dias, por favor informaciÃ³n de  departamentos de 2 y 3 habitaciones. ','2018-10-01 16:40:24','2018-10-01 16:40:24'),(70,'Roberto Carlos','Vega Hidalgo','954952331','vegahidalgorc@gmail.com','Vivo en hyo, ','2018-10-01 19:04:07','2018-10-01 19:04:07'),(71,'Esther','Arenas','956212058','Rosario_26_94@hotmail.com','InformaciÃ³n de los precios','2018-10-01 19:15:06','2018-10-01 19:15:06'),(72,'Esther','Arenas','956212058','Rosario_26_94@hotmail.com','InformaciÃ³n de los precios','2018-10-01 19:15:21','2018-10-01 19:15:21'),(73,'jonny','rojas','558445665','johnyr456@hotmail.com','-','2018-10-01 20:40:58','2018-10-01 20:40:58'),(74,'jonny','rojas','558995665','johnyr456@hotmail.com','-','2018-10-01 20:41:34','2018-10-01 20:41:34'),(75,'pruebas','duplo','558445775','duplomail@test.com','j','2018-10-01 22:30:23','2018-10-01 22:30:23'),(76,'jacqueline','FLORES DÃAZ','992719368','jacquita04@hotmail.com','agradecere informacion del proyecto','2018-10-01 22:37:48','2018-10-01 22:37:48'),(77,'luis','calderon','50077554','alcarraz.luis@gmail.com','.','2018-10-01 22:41:07','2018-10-01 22:41:07'),(78,'Milton','Corrales','987549700','Fcorralesm@hotmail.com','Favor necesito contactarme con ustedes para mayor  informaciÃ³n ','2018-10-01 23:46:53','2018-10-01 23:46:53'),(79,'Milton','Corrales','987549700','Fcorralesm@hotmail.com','Favor necesito contactarme con ustedes para mayor  informaciÃ³n ','2018-10-01 23:47:21','2018-10-01 23:47:21'),(80,'orlando gabriel','Castro perlayo','948071519','Funkadelic@outlook.com.pe','Quisiera saber  aprox de los precios ','2018-10-02 02:40:04','2018-10-02 02:40:04'),(81,'Mabel','Quispialaya Hinostroza','947000182','ritzi_mqh@hotmail.com','Deseo saber cotizaciÃ³n y venta inmediata.\r\n\r\n','2018-10-02 04:04:57','2018-10-02 04:04:57'),(82,'Gustavo','La Rosa','993486234','gusma20@hotmail.com','InformaciÂ´Ã³n ','2018-10-02 12:54:19','2018-10-02 12:54:19'),(83,'victor','huamani','999969155','victorhugo_hj@hotmail.com','necesita mas informacion sobre el proyecto','2018-10-02 14:59:49','2018-10-02 14:59:49'),(84,'pruebaSper','test','558555665','spertest@mail.com','-','2018-10-02 17:31:20','2018-10-02 17:31:20'),(85,'pruebaSper','test','998554552','spertest@mail.com','-','2018-10-02 17:31:39','2018-10-02 17:31:39'),(86,'pruebaSper','test','998554552','spertest@mail.com','-','2018-10-02 17:34:47','2018-10-02 17:34:47'),(87,'luz','soto espino','961270275','lsoto@ositran.gob.pe','departamento de 3 dormitorios','2018-10-02 18:51:23','2018-10-02 18:51:23'),(88,'Cecilia','Angulo','974775642','Cecilianutricion.ag@gmail.com','Precio, area\r\n','2018-10-02 19:41:12','2018-10-02 19:41:12'),(89,'Cecilua','Angulo','974775642','Cecilianutricion.ag@gmail.com','Precio, visita piloto','2018-10-02 19:43:32','2018-10-02 19:43:32'),(90,'Prisca','Milla','959305635','nmillareyes@gmail.com','Buenas tardes: me podrÃan brindar por favor los costos. Gracias','2018-10-02 22:15:41','2018-10-02 22:15:41'),(91,'Carmela','Trujillo vannini','9908-69960','jrct1946@yahoo.com','Deseo mÃ¡s informaciÃ³n sobre departamento en Surco.','2018-10-02 23:20:45','2018-10-02 23:20:45'),(92,'Sara','Torres','914115003','smtorres.2696@gmail.com','Departamentos 3 dormitorios','2018-10-03 00:04:10','2018-10-03 00:04:10'),(93,'Steffany','ChacÂ´Â´on Perez','959103230','steffanych@outlook.com','Quisiera saber cuanto esta el modelo tipologia x3.','2018-10-03 00:55:49','2018-10-03 00:55:49'),(94,'mariapia','moyano','989040959','calidad.indufrut@gmail.com','Por favor, quiero saber se puede ir a ver.','2018-10-03 15:38:18','2018-10-03 15:38:18'),(95,'mariapia','moyano','989040959','calidad.indufrut@gmail.com','Por favor, quiero saber se puede ir a ver.','2018-10-03 15:38:30','2018-10-03 15:38:30'),(96,'dina dora','robles ayala','998070397','ddroblesa_79@hotmail.com','quisiera un immueble o mini departamento en alquiler venta p con cÃ³modas cotas para pagar','2018-10-03 15:58:33','2018-10-03 15:58:33'),(97,'dina dora','robles ayala','998070397','ddroblesa_79@hotmail.com','quisiera un immueble o mini departamento en alquiler venta p con cÃ³modas cotas para pagar','2018-10-03 15:58:53','2018-10-03 15:58:53'),(98,'Noe','Guerra','949141098','noe_guerra1@hotmail.com','precio','2018-10-03 18:40:09','2018-10-03 18:40:09'),(99,'Henry','Rengifo SaldaÃ±a','992268021','andrea_2012uap@hotmail.es','Buenas tardes soy operario Fierrero con aÃ±os de experiencia. Quisiera saber si estÃ¡n necesitando trabajadores . Muchas gracias','2018-10-03 20:10:47','2018-10-03 20:10:47'),(100,'Arturo','Medina Romero','963803219','arturo.medina2024@outlook.com','Favor brindenme la informaciÃ³n del proyecto, del tipo 2','2018-10-03 20:20:40','2018-10-03 20:20:40'),(101,'Karla ','RODRÃGUEZ ','984707785 ','karla0924@outlook.com','3 dormitorios ','2018-10-03 20:56:37','2018-10-03 20:56:37'),(102,'Julio ','Hoyos Villalobos ','974216208 ','Cmarlenyvanessa@yahoo.com','Soy Capataz andamiero ','2018-10-03 21:02:38','2018-10-03 21:02:38'),(103,'Cinthya','Gutierrez rivero','969839050','Cinthyariver2015@gmail.com','Info dpto 3D + cochera y financiamiento','2018-10-03 21:47:30','2018-10-03 21:47:30'),(104,'Yaquelyn ','Gamboa ','965684355 ','Y.gamboa.tinco@gmail.com','Precio','2018-10-03 23:16:36','2018-10-03 23:16:36'),(105,'pruebaSperant','test','55855556','sperant@mail.com','-','2018-10-03 23:31:54','2018-10-03 23:31:54'),(106,'ricardo','mendez','3424068289','ricardo.mendez50@hotmail.com','necesito alquilar para febrero','2018-10-04 01:40:03','2018-10-04 01:40:03'),(107,'Oswaldo','Paitan limas ','997780058','Oswaldopaitan05@gmail.com','Precio de 3 dormitorio y medidas ','2018-10-04 16:05:09','2018-10-04 16:05:09'),(108,'Joselyn ','Cuadros','945143704','Pierina106@gmail.com','InformaciÃ³n ','2018-10-04 19:35:04','2018-10-04 19:35:04'),(109,'Beatriz Cristina','Ruiz Rojas ','994885761','bearuizrojas@gmail.com','Deseo saber precios de los departamentos de cerca de 80 mts de Ã¡rea y principalmente en primer piso','2018-10-04 20:17:38','2018-10-04 20:17:38'),(110,'Ayaze','Castillo ','993505715','ayaze@hotmail.com','El precio del dpto , y en w piso estÃ¡. Espero su rpta','2018-10-05 02:07:47','2018-10-05 02:07:47'),(111,'Sarita','GÃ¡lvez Garcia','955862466','sgalvez@transportenazca.com','Buenas noches, quisiera tener mÃ¡s informaciÃ³n. Gracias.','2018-10-05 02:57:47','2018-10-05 02:57:47'),(112,'Jacqueline','Colome','998468650','Jcolome0615@hotmail.com','Quiziera se me envie si tienen departamentos de 3 dormitorios y los costos respectivos','2018-10-05 16:34:21','2018-10-05 16:34:21'),(113,'pruebaUTM','urm','558555445','pruebautm@mail.com','c','2018-10-05 19:31:32','2018-10-05 19:31:32'),(114,'pruebaUTM','urm','558555445','pruebautm@mail.com','c','2018-10-05 19:31:48','2018-10-05 19:31:48'),(115,'pruebaUTMII','test','558555445','utm@mail.com','d','2018-10-05 19:33:05','2018-10-05 19:33:05'),(116,'utmprueba','sperant','6454564','tstutm@maill.cm','dd','2018-10-05 19:35:06','2018-10-05 19:35:06'),(117,'Karen','Espinoza','918507690','espinozaperezk@gmail.com','Quiero saber los precios y los tipos','2018-10-05 21:03:45','2018-10-05 21:03:45'),(118,'nataly flora','quispe rosas','992417881','nataly.flora.quispe@gmail.com','dormitorio 3 a 4  precios y departamentos disponibles','2018-10-05 22:24:53','2018-10-05 22:24:53'),(119,'Sue','Wong','971263184','suewg21@gmail.com','Alquiler','2018-10-06 02:26:16','2018-10-06 02:26:16'),(120,'Fressia ','Raez','936858070','Fressiaraez@gmail.com','Por\r\nFavor mÃ¡ndenme informaciÃ³n al correo','2018-10-06 07:30:17','2018-10-06 07:30:17'),(121,'DANIELA BRIGITTE','ZAMORA CAMPOS','996436514','daniela.conta.17@gmail.com','deseo saber informacion hacerca de la venta de alguno de estos departamentos','2018-10-06 18:27:20','2018-10-06 18:27:20'),(122,'Rosario ','Revilla ','959903918','charorevilla@hotmail.com','Por favor envÃenme informaciÃ³n de este proyecto. Gracias','2018-10-06 19:07:57','2018-10-06 19:07:57'),(123,'Rut MarilÃº','Tongo delgado ','99536621','ruthmarilu20@gmail.com','Quiero informaciÃ³n ','2018-10-06 20:01:23','2018-10-06 20:01:23'),(124,'Rut MarilÃº','Tongo delgado ','99536621','ruthmarilu20@gmail.com','Quiero informaciÃ³n ','2018-10-06 20:01:47','2018-10-06 20:01:47'),(125,'Isaac','Guerrero Aguilera','954715570','isaacjga@gmail.com','CotizaciÃ³n de 1 departamento con 2 dormitorios','2018-10-06 22:08:34','2018-10-06 22:08:34'),(126,'Leonel','Mamani Cornejo','+51959505537','leo_dece_2412@hotmail.com','Hola busco empleo','2018-10-06 22:39:40','2018-10-06 22:39:40'),(127,'Isaac','Guerrero aguiilera','954715570','isaacjga@gmail.com','Buenas noches, me pueden enviar una cotizaciÃ³n por un departamento con 2 cuArtos.','2018-10-07 02:07:24','2018-10-07 02:07:24'),(128,'Gustavo','JuÃ¡rez Paredes','952351965','gustavojuarez@outlook.com.pe','Precio y modalidades de pago en los departamentos de los aires, 2 y 3 Dormitorios gracias.','2018-10-07 03:01:56','2018-10-07 03:01:56'),(129,'Gustavo','JuÃ¡rez','952351965','gustavojuarez@outlook.com.pe','Precio','2018-10-07 03:06:40','2018-10-07 03:06:40'),(130,'Gustavo','JuÃ¡rez','952351965','gustavojuarez@outlook.com.pe','Precio de 40 y 56 m2','2018-10-07 03:07:55','2018-10-07 03:07:55'),(131,'Neyfi ','Serna ','991637470','Neyfii.sh27@gmail.com','Quisiera saber el precio y si aÃºn les queda flats o duplex ','2018-10-07 05:49:40','2018-10-07 05:49:40'),(132,'Neyfi ','Serna ','991637470','Neyfii.sh27@gmail.com','Quisiera saber el precio y si aÃºn les queda flats o duplex ','2018-10-07 05:49:54','2018-10-07 05:49:54'),(133,'Guisselli ','Alania machafo','975522270','galaniamachado@gmail.com','Informacion  de 3 dormitorios ','2018-10-07 14:07:45','2018-10-07 14:07:45'),(134,'Rocio','Lozada','949370490','Farmaciaisis@hotmail.com','Estoy interesada en el tipo 4','2018-10-07 15:30:43','2018-10-07 15:30:43'),(135,'Marlene ','Montoya ','997974790','mmontoya@mbac.com.pe','Solicitado informaciÃ³n ','2018-10-07 15:50:16','2018-10-07 15:50:16'),(136,'Marcia karina','Valqui nalvarte','963872749','karinanalvarte7@gmail.com','Buen dia me gustaria que me brindara la informacion en general de los departamentos','2018-10-07 21:00:26','2018-10-07 21:00:26'),(137,'Mirella azucena',' Chauca tapia','944665384','mirellact8@gmail.com','Quisiera informaciÃ³n del precio del departamento ','2018-10-08 02:34:52','2018-10-08 02:34:52'),(138,'Mirella azucena',' Chauca tapia','944665384','mirellact8@gmail.com','Quisiera informaciÃ³n del precio del departamento ','2018-10-08 02:35:22','2018-10-08 02:35:22'),(139,'Guisella','Mas','934411859','guise_mas@hotmail.com','enviar precios para el departamento tipo 3 y metodologÃa de credito','2018-10-08 04:18:30','2018-10-08 04:18:30'),(140,'Angela Milagrito','Santa cruz ','985816962','angelasantacruz_71@hotmail.com','InformaciÃ³n','2018-10-08 05:14:50','2018-10-08 05:14:50'),(141,'CÃ‰SAR AUGUSTO ','HERNÃNDEZ GUTIÃ‰RREZ ','999112089','cachorritosexto@hotmal.com','Hola, disculpe estoy interesado en los departamentos B1 X 10, por favor si pudieran darme un poco mÃ¡s de informaciÃ³n acerca de estos departamentos, muchas gracias ','2018-10-08 12:25:53','2018-10-08 12:25:53'),(142,'CÃ‰SAR AUGUSTO ','HERNÃNDEZ GUTIÃ‰RREZ ','999112089','cachorritosexto@hotmal.com','Hola, disculpe estoy interesado en los departamentos B1 X 10, por favor si pudieran darme un poco mÃ¡s de informaciÃ³n acerca de estos departamentos, muchas gracias ','2018-10-08 12:26:12','2018-10-08 12:26:12'),(143,'CÃ‰SAR AUGUSTO ','HERNÃNDEZ GUTIÃ‰RREZ ','999112089','cachorritosexto@hotmail.com','Hola, disculpe estoy interesado en los departamentos TIPO 1, les agradecerÃ© si me pudieran brindar mÃ¡s informaciÃ³n, gracias ','2018-10-08 12:44:21','2018-10-08 12:44:21'),(144,'ARTURO ENRIQUE','CARRASCO CONTRERAS','922391933','aecarras_c@yahoo.com','Hola , soy arquitecto , con experiencia en proyectos inmobiliarios ; quisiera ver la posibilidad de apoyarlos ......de que forma les puedo hacer llegar mi CV.','2018-10-08 22:02:27','2018-10-08 22:02:27'),(145,'Marisol Edme ','YaringaÃ±o Aquino ','998081717 ','ivalize@hotmail.com','InformaciÃ³n sobre departamento con dos habitaciones ','2018-10-08 23:54:44','2018-10-08 23:54:44'),(146,'Carlos','Medina Astete','941855576','carlos.medina@pucp.pe','Estoy interesado en un departamento el mÃ¡s pequeÃ±o posible','2018-10-09 00:05:16','2018-10-09 00:05:16'),(147,'Gisela','Gonzales Vasquez','966365985','gissella8_13@hotmail.com','Buenas tardes, estoy interrsada en el deparyamento B1 X10. Podrian enviar informacion al respecto. Graciaa','2018-10-09 00:43:48','2018-10-09 00:43:48'),(148,'Kattia','Bardalez Tuanama','989280862','Aittak90@hotmail.com','Estoy interesada en saber el precio del departamento ','2018-10-09 02:58:02','2018-10-09 02:58:02'),(149,'Gina','Higashi ','987756364','ghigashi@britishschool.edu.pe','DÃ³nde puedo acercarme para obtener mayor informaciÃ³n. ','2018-10-09 03:29:28','2018-10-09 03:29:28'),(150,'Carol','Cornejo','981678602','carolcelene@gmail.com','Dpto de 81 y 86 m2','2018-10-09 03:57:53','2018-10-09 03:57:53'),(151,'Sonia ','Delgadillo ','989791242','soniaydb@hotmail.com','Deceo saber si estÃ¡ propiedad estÃ¡ en venta. Dentro del centro comercial arenales  tienda 12cd.','2018-10-09 06:17:00','2018-10-09 06:17:00'),(152,'Almendra','del carpio ','956114635','almee.9@hotmail.com','estoy interesada en alquiler de un depa de 3 habitaciones ','2018-10-09 17:45:53','2018-10-09 17:45:53'),(153,'LUIS ANGEL','LOPEZ ORBEGOZO','989103950','angel_lopez_7@hotmail.com','Buen dÃa,\r\nEstoy buscando una casa por el Cono Norte..\r\nEspero su pronta respuesta.','2018-10-09 19:23:20','2018-10-09 19:23:20'),(154,'DELIA','VELASQUEZ','951833939','delia_vt1@hotmail.com','buenas tardes,\r\ndeseo por favor tener mayor informacion sobre venta de casas y terrenos  en Lima.\r\n\r\ngracias,\r\n\r\nDelia Velasquez','2018-10-09 20:00:27','2018-10-09 20:00:27'),(155,'Victor','Toledo','943597323','victorhugoth@gmail.com','Costos por favor.','2018-10-09 20:46:23','2018-10-09 20:46:23'),(156,'Milagros','Franco','941407252','milagros.franco.c@gmail.com','Buenas noches,\r\n\r\nPor favor, quisiera que me brinde informaciÃ³n de sus diferentes proyectos. No tengo preferencia por ninguno, quisiera invertir en un inmueble.\r\n\r\nQuedo atenta a su pronta respuesta.\r\nGracias.','2018-10-10 00:32:52','2018-10-10 00:32:52'),(157,'Carolina ','Garay Godoy','969002940','carolinagaray43@gmail.com','Precio TipologÃa 3','2018-10-10 03:07:34','2018-10-10 03:07:34'),(158,'Irina','Arevalo','968491567','aairina913@gmail.com','CotizaciÃ³n 4 dormitorios','2018-10-10 04:23:26','2018-10-10 04:23:26'),(159,'Nilton','Siccha','978378083','niltonsiccha@hotmail.com','Estoy interesado en tener mayor informaciÃ³n sobre los departamentos','2018-10-10 10:51:02','2018-10-10 10:51:02'),(160,'Juan','Sanchez Ccance','973822501','juansanchezcc@hotmail.com','Informes sobre los depratmento','2018-10-10 11:11:26','2018-10-10 11:11:26'),(161,'Hector Giuseppe','Perez Mundo','940158873','hectorgpm15@gmail.com','Buenas tardes, solicito mÃ¡s informaciÃ³n sobre el tipo 2002 y tipo 2004 por favor.','2018-10-10 14:36:06','2018-10-10 14:36:06'),(162,'Freddy','Gutierrez','966995206','fgutierrezbellido@gmail.com','DEPERTAMENTO DUPLEX','2018-10-10 14:40:14','2018-10-10 14:40:14'),(163,'alex','CAMPIAN','941624715','campian@alcenergy.com.pe','por favor cotizacion de  un departamento de 2 dormitorios y 2baÃ±os entre el 5 al  7piso','2018-10-11 01:00:24','2018-10-11 01:00:24'),(164,'alex','CAMPIAN','941624715','campian@alcenergy.com.pe','por favor cotizacion de  un departamento de 2 dormitorios y 2baÃ±os entre el 5 al  7piso','2018-10-11 01:00:59','2018-10-11 01:00:59'),(165,'Adriana','Leon','973248120','Ady.leonp@gmail.com','Fecha de entrega?','2018-10-11 04:16:15','2018-10-11 04:16:15'),(166,'Nilton ','Siccha','978378083','niltonsiccha@hotmail.com','Gracias por la informaciÃ³n ','2018-10-11 11:01:02','2018-10-11 11:01:02'),(167,'Maria ','Aranda ','998468224 ','vhtorresq@hotmail.com','Hola estamos en busca de dpto con 3 dormitorios, que el precio incluya cochera y que acepten mascotas. Gracias','2018-10-11 11:10:27','2018-10-11 11:10:27'),(168,'Maria ','Aranda ','998468224 ','vhtorresq@hotmail.com','Hola estamos en busca de dpto con 3 dormitorios, que el precio incluya cochera y que acepten mascotas. Gracias','2018-10-11 11:10:40','2018-10-11 11:10:40'),(169,'Rosa','Arce','013252415','bendezuarce1960@gmail.com','Quisiera saber si hay tambiÃ©n de 01 dormitorio, en quÃ© piso y cuÃ¡l serÃa el precio. Gracias','2018-10-11 15:52:07','2018-10-11 15:52:07'),(170,'David','Pacuri','981516299','dfiee02@gmail.com','Agradecere me brinden informacion detallada de los precios de cada tipoo de departamento.\r\nSaludos.','2018-10-11 16:52:25','2018-10-11 16:52:25'),(171,'Luis ','Arauco','993046178','luis.arauco.la@gmail.com','Precios de dos y tres dormitorios con vista externa','2018-10-11 23:22:19','2018-10-11 23:22:19'),(172,'Luis ','Arauco','993046178','luis.arauco.la@gmail.com','Precios de dos y tres dormitorios con vista externa','2018-10-11 23:22:32','2018-10-11 23:22:32'),(173,'Luis ','Arauco','993046178','luis.arauco.la@gmail.com','Precios de dos y tres dormitorios con vista externa','2018-10-11 23:22:40','2018-10-11 23:22:40'),(174,'Luis','Arauco AlarcÃ³n','993046178','luis.arauco.la@gmail.com','Quiero departamentos con 2 y 3 dormitorios con vista extrerna','2018-10-11 23:28:36','2018-10-11 23:28:36'),(175,'Luis','Arauco AlarcÃ³n','993046178','luis.arauco.la@gmail.com','Quiero departamentos con 2 y 3 dormitorios con vista extrerna','2018-10-11 23:28:43','2018-10-11 23:28:43'),(176,'eva','noboa garvia','992844978','evanovoa_28@hotmail.com','departamentos 3 dormitorios y cochera','2018-10-12 01:21:50','2018-10-12 01:21:50'),(177,'Edgar','PeÃ±a','942691192','williampp1968@outlook.com','Informacion completa x favor.\r\nGracias.','2018-10-12 04:10:18','2018-10-12 04:10:18'),(178,'AndrÃ©s','Aliaga OtÃ¡rola','968282066','aaliagao2412@gmail.com','Favor de enviar informaciÃ³n de los departamentos de 81 y 86 m2 inicial si es con mi vivienda y/o financiamiento','2018-10-12 04:32:10','2018-10-12 04:32:10'),(179,'AndrÃ©s','Aliaga OtÃ¡rola','968282066','aaliagao2412@gmail.com','Favor de enviar informaciÃ³n del modelo 12 de 77 m2 inicial si es mi vivienda','2018-10-12 04:42:08','2018-10-12 04:42:08'),(180,'cecilia','angulo','974775642','cecilianutricion.ag@gmail.com','informacion, comprare con mis 2 hermanos ','2018-10-12 05:00:32','2018-10-12 05:00:32'),(181,'Maria isabel','Machaca Benegas','988439400','marisanel280672@gmail.com','Precio','2018-10-12 13:57:33','2018-10-12 13:57:33'),(182,'Nila','Abanto vasquez','989171717','lita211003@hotmail.com','Estoy interasada en los departamentos y duplex me pueden mandar informacion a mi correo. Precios areas de departamentos y fecha de entrega','2018-10-12 15:43:47','2018-10-12 15:43:47'),(183,'KATHERINE','ARIMAYA','965374608','karimaya@retroexcavadora.com.pe','Estimados Sres.:\r\nBuenos dÃas, es un gusto saludarlos y de esta manera dar a conocer nuestra empresa, somos TRANSPORTE SM SAC, dedicados a brindar el servicio de alquiler de RETROEXCAVADORAS, ideales para trabajos en almacÃ©n, minerÃa y construcciÃ³n. Cualquier consulta o requerimiento. ComunÃquese con nosotros.\r\n\r\nSin otro asunto en particular.\r\n\r\nSaludos cordiales.\r\nKATHERINE ARIMAYA\r\nTRANSPORTE SM SAC\r\nCel:965374608\r\nTEL: 5937023\r\n','2018-10-12 15:52:57','2018-10-12 15:52:57'),(184,'Cinthya','Gutierrez','969839040','Cinthyariver2015@gmail.com','Precio y finaciamiento ','2018-10-12 16:11:32','2018-10-12 16:11:32'),(185,'asdsad','asdsadd','654564456','asdasd@asdsad.com','sdsd','2018-10-12 17:23:39','2018-10-12 17:23:39'),(186,'dsf','sdf','654654','sadsad@dsadsa.com','fdgfd','2018-10-12 17:26:53','2018-10-12 17:26:53'),(187,'pruebaobservacion','prueba','564654564654','pruebaobs@mail.com','asdsadsadsa','2018-10-12 17:43:50','2018-10-12 17:43:50'),(188,'jessica','leguia leguia','989258026','leguia.jessica@gmail.com','deseo informaciÃ³n.  crÃ©dito fondo mi vivienda','2018-10-12 18:57:47','2018-10-12 18:57:47'),(189,'Nelly','Llsnos','977123456','Angie29@hotmail.coxm',' Osto','2018-10-12 19:02:58','2018-10-12 19:02:58'),(190,'Nilton VÃctor','Picon','5501667','nvpiconp@gmail.com','Envienme la informacion a mi correo. ','2018-10-12 20:05:50','2018-10-12 20:05:50'),(191,'Nilton VÃctor','Picon','5501667','nvpiconp@gmail.com','Envienme la informacion a mi correo. ','2018-10-12 20:06:31','2018-10-12 20:06:31'),(192,'Nilton VÃctor','Picon','5501667','nvpiconp@gmail.com','Envienme la informacion a mi correo. ','2018-10-12 20:06:39','2018-10-12 20:06:39'),(193,'Nilton VÃctor','Picon','5501667','nvpiconp@gmail.com','Envienme la informacion a mi correo. ','2018-10-12 20:07:17','2018-10-12 20:07:17'),(194,'Nilton VÃctor','Picon','5501667','nvpiconp@gmail.com','Envienme la informacion a mi correo. ','2018-10-12 20:07:47','2018-10-12 20:07:47'),(195,'Carla','Carignano','940123276','carignanocarla@hotmail.com','Quisiera saber el precio del dpto de 56.30 m2 y el de 40.80 m2. gracias','2018-10-12 20:16:38','2018-10-12 20:16:38'),(196,'Carla','Carignano','940123276','carignanocarla@hotmail.com','Quisiera saber el precio del dpto de 56.30 m2 y el de 40.80 m2. gracias','2018-10-12 20:16:53','2018-10-12 20:16:53'),(197,'Bdtzabeth','Salinas','966429270','betzabethsv@gmail.com','3dormitorios','2018-10-13 03:10:43','2018-10-13 03:10:43'),(198,'Rosana','Espinoza','968172954','Despinoza.rosana@gmail.com','Info por depa 1 y 2 hab.','2018-10-13 11:12:28','2018-10-13 11:12:28'),(199,'Gisel','VeÃ±oz','957333000','gisel1701@gmail.com','Precio de departamentos','2018-10-13 11:53:48','2018-10-13 11:53:48'),(200,'Gisel','Veliz','957333000','gisel1701@gmail.com','Precio de departamentos','2018-10-13 11:54:37','2018-10-13 11:54:37'),(201,'ana maria','chavez acuÃ±a','936293374','annmary_73@hotmail.com','quiero saber como es la compra...','2018-10-13 14:22:34','2018-10-13 14:22:34'),(202,'pamela','rivera','994927090','pameriverag59@gmail.com','por favor enviar informaciÃ³n al correo ','2018-10-13 14:40:59','2018-10-13 14:40:59'),(203,'Jesabel','Riega Abarca','987307281','j.riega.abarca@gmail.com','Buenas tardes; Solicito informacion sobre la compra de inmueble. Gracias','2018-10-13 15:57:15','2018-10-13 15:57:15'),(204,'Paul','Huayhua','991897175','Pcesarhm@gmail.com','Informes','2018-10-13 18:43:52','2018-10-13 18:43:52'),(205,'Pedro','Uribe Arce','981229978','pedrouribearce@hotmail.com','cotizacion departamento con 2 dormitorios...gracias','2018-10-14 00:06:53','2018-10-14 00:06:53'),(206,'Maria Lheny','Campos','984849045','lhenyc@hotmail.com','Por favor quisiera saber los costos de los departamentos de 3 dormitorios y los pisos','2018-10-14 01:20:15','2018-10-14 01:20:15'),(207,'Mario RaÃºl NuÃ±ez','NuÃ±ez Pari','998162797','marioraul56@hotmail.com','Necesito mÃ¡s informaciÃ³n gracias Bendiciones','2018-10-14 02:26:35','2018-10-14 02:26:35'),(208,'Edgar Francisco','Vargas Cespedes','29255038','pachoedgar@hotmail.com','Interesado en un depto de 2 o 3 dormitorios\r\n','2018-10-14 11:36:11','2018-10-14 11:36:11'),(209,'Yeni ','Sotelo','980180817','Shantalle29@hotmail.com','InformaciÃ³n acerca de departamento de 4 dormitorios. Gracias','2018-10-14 13:58:57','2018-10-14 13:58:57'),(210,'Ana','Camacho','990384595','ana_camacho_t@yahoo.com','Cotizar departamento de dos dormitorios de 59 m2.','2018-10-14 14:01:15','2018-10-14 14:01:15'),(211,'Felipe','Enco','997581348','enco5x@outlook.com','InformaciÃ³n','2018-10-14 19:54:52','2018-10-14 19:54:52'),(212,'Betzabeth','Salinas','966429270','betzabethsv@gmail.com','3dormitorios','2018-10-14 22:53:09','2018-10-14 22:53:09'),(213,'Ana Maria','Pachas Alvarado','949379441','anamaria_pa13@hotmail.com','InformaciÃ³n de departamento en BreÃ±a','2018-10-15 00:03:53','2018-10-15 00:03:53'),(214,'Ana Maria','Pachas Alvarado','949379441','anamaria_pa13@hotmail.com','InformaciÃ³n de departamento en BreÃ±a','2018-10-15 00:04:17','2018-10-15 00:04:17'),(215,'JosÃ© Carlos ','Mendoza LeÃ³n ','977665593','jc_mendoza8@hotmail.com','InformaciÃ³n Departamento en avenida Salaverry JesÃºs Maria','2018-10-15 00:08:09','2018-10-15 00:08:09'),(216,'JosÃ© Carlos ','Mendoza LeÃ³n ','977665593','jc_mendoza8@hotmail.com','InformaciÃ³n Departamento en avenida Salaverry JesÃºs Maria','2018-10-15 00:08:18','2018-10-15 00:08:18'),(217,'JosÃ© Carlos ','Mendoza LeÃ³n ','977665593','jc_mendoza8@hotmail.com','InformaciÃ³n Departamento en avenida Salaverry JesÃºs Maria','2018-10-15 00:08:38','2018-10-15 00:08:38'),(218,'jessy','suarez','986958952','jessy_asp@hotmail.com','Buenas noches deseo informacion de departamentos de 1 dormitorio para parejas. ','2018-10-15 01:16:33','2018-10-15 01:16:33'),(219,'HILDA','Cabana','952367278','hynesi@hotmail.es','Mas informaciÃ³n de sus proyectos de vivienda','2018-10-15 02:06:57','2018-10-15 02:06:57'),(220,'Marco','Reyna Barquero','998080771','mreynab@hotmail.com','Cotizar con cochera','2018-10-15 02:30:38','2018-10-15 02:30:38'),(221,'Marco','Reyna Barquero','998089772','mreynab@hotmail.com','Cotizar con cochera','2018-10-15 02:31:30','2018-10-15 02:31:30'),(222,'Marco','Reyna Barquero','998089771','mreynab@hotmail.com','Cotizar con cochera','2018-10-15 02:32:15','2018-10-15 02:32:15'),(223,'Juan antonio','Chang medina','991667774','Joanch3@gmail.com','InformaciÃ³n y contacto para depa de 3 dormitorios y 2 cocheras','2018-10-15 03:27:39','2018-10-15 03:27:39'),(224,'BERTHA ','TOLEDO ESTRADA','996293614','betoes100@hotmail.com','areas precio fecha de entrega','2018-10-15 04:56:49','2018-10-15 04:56:49'),(225,'Zulema Maritza ','MÃ©ndez Rojas','943200898','zulitakam@hotmail.com','Como son las cuotas o es al contado el departamento','2018-10-15 09:43:29','2018-10-15 09:43:29'),(226,'Natalia ','Sutta tintaya','991408768','natty626@hotmail.com','Informacion','2018-10-15 12:34:59','2018-10-15 12:34:59'),(227,'CARLOS JESUS','DURAND MATOS','994180801','carlosdurand33@hotmail.com','VENDO CASA COMO TERRENO EXCELENTE UBICACION AT 451.5 M2 FRENTE 12.9 M X FONDO 35 MTS PARAMETROS 8 PISOS https://www.adondevivir.com/propiedades/pentagonito-san-borja-vendo-casa-como-terreno-para-8-pisos-54986420.html','2018-10-15 18:01:01','2018-10-15 18:01:01'),(228,'CARLOS JESUS','DURAND MATOS','994180801','carlosdurand33@hotmail.com','VENDO CASA COMO TERRENO EXCELENTE UBICACION AT 451.5 M2 FRENTE 12.9 M X FONDO 35 MTS PARAMETROS 8 PISOS https://www.adondevivir.com/propiedades/pentagonito-san-borja-vendo-casa-como-terreno-para-8-pisos-54986420.html','2018-10-15 18:01:13','2018-10-15 18:01:13'),(229,'lourdes','RincÃ³n','941484545','lourdesrc_lu@hotmail.com','InformaciÃ³n de precios paar un dpto.. de 3 dormitorios','2018-10-15 18:25:36','2018-10-15 18:25:36'),(230,'Valeria','CÃ¡rcamo','943449111','Valeriacarcamov@gmail.com','Info dos habitaciones a 3 ','2018-10-15 19:56:50','2018-10-15 19:56:50'),(231,'Carolina','Palacios','91538271','gianellaxp@gmail.com','Interesado en departamentos de 3 dormitorios.','2018-10-15 20:50:32','2018-10-15 20:50:32'),(232,'Liseth','Machaca','976314054','liseth_87@hotmail.com','Deseo mayor informacion del precio de 86 y 81 m2, disponibilidad y en quÃ© piso, vista a la calle?','2018-10-15 23:35:29','2018-10-15 23:35:29'),(233,'Angela','PÃ©rez ','995977738','angelajpp@hotmail.com','Estoy interesada en este proyecto, deseo mÃ¡s informaciÃ³n como precio y disponibilidad ','2018-10-16 01:23:31','2018-10-16 01:23:31'),(234,'Oskar','Coronel','990345303','Oskarc24@outlook.com','InformaciÃ³n de departamentos ','2018-10-16 04:27:36','2018-10-16 04:27:36'),(235,'Carmen ','PÃ©rez rodriguez','941768487','Perezrodriguezcarmen77@gmail.com','Informe sobre los datos de 3 habitaciones precio','2018-10-16 06:19:54','2018-10-16 06:19:54'),(236,'JosÃ© Ãngel ','Esquivel Meza','988790308','amgelito372692@gmail.com','Por favor necesito una cotizaciÃ³n e informaciÃ³n sobre los departamentos, gracias ','2018-10-16 20:35:15','2018-10-16 20:35:15'),(237,'JosÃ© Ãngel ','Esquivel Meza','988790308','angelito372692@gmail.com','Por favor necesito una cotizaciÃ³n e informaciÃ³n sobre los departamentos, gracias ','2018-10-16 20:35:31','2018-10-16 20:35:31'),(238,'Leonardo ','Alvarez','956720952','lalvarezly@gmail.com','InformaciÃ³n  del proyecto ','2018-10-17 00:58:53','2018-10-17 00:58:53'),(239,'Lesly','Uchuya FalcÃ³n','994639272','lesly-2301@hotmail.com','Precios de departamentos de tres dormitorios','2018-10-17 02:26:20','2018-10-17 02:26:20'),(240,'oscar','soto cutire','980645944','oscar.26.01.12@hotmail.com','fecha de entrega y cotizacion de dptos','2018-10-17 05:50:44','2018-10-17 05:50:44'),(241,'Victor Eduardo','Soto Cueto','999964258','titopisco1964@gmail.com','InformaciÃ³n','2018-10-17 12:09:58','2018-10-17 12:09:58'),(242,'Gaby Serafina','Caballero Mendoza','999018012','topacio_1235@hotmail.com','Departamento de 3 dormitorios vista exterior.4to o 5to piso','2018-10-17 12:31:41','2018-10-17 12:31:41'),(243,'Carlos','Montesinos','993506665','Cnmontesinos@yahoo.es','Informes','2018-10-17 12:59:29','2018-10-17 12:59:29'),(244,'Martin','Huaman paucar','964192959','martinhpaucar62@gmail.com','Necesito mas informacion de costos de los departamentos.','2018-10-17 15:36:22','2018-10-17 15:36:22'),(245,'LUIS','TINIPUCLLA QUISPE ','943652667','tiniluis7@gmail.com','Buenas tardes, estoy interesado en adquirir un departamento y  quisiera saber el costo de los tipos de departamento.','2018-10-17 20:30:28','2018-10-17 20:30:28'),(246,'Carlios','Poblete','984532953','ekonorep@hotmail.com','Costo y tienpo de entrega','2018-10-17 21:14:46','2018-10-17 21:14:46'),(247,'carlos ','cabrera','976560037','len.cabrera2109@gmail.com','buenas tardes\r\n\r\nme darin informacion estoy interesado en  un departamento con uno o dos dormitorios.','2018-10-17 21:32:44','2018-10-17 21:32:44'),(248,'JOSE ANGEL','ESQUIVEL MEZA','966167284','angelito372692@gmail.com','buenas tardes, quisiera saber mas informacion sobre el proyecto por favor.','2018-10-17 21:36:04','2018-10-17 21:36:04'),(249,'prueba','prueba','654654654','prueba@test.com','prueba','2018-10-17 23:04:13','2018-10-17 23:04:13'),(250,'marlene','cabrera','+51918379623','mozacabrera66@gmail.com','quisiera saber un poco mas sobre este proyecto','2018-10-17 23:19:50','2018-10-17 23:19:50'),(251,'prueba','prueba','558445552','prueba@test.com','prueba','2018-10-17 23:23:16','2018-10-17 23:23:16'),(252,'prueba','prueba','5645554','prueba@mail.com','prueba analytics','2018-10-17 23:23:56','2018-10-17 23:23:56'),(253,'prueba','prueba','54654564654','prueba@mail.com','mensaje prueba analytics','2018-10-17 23:24:30','2018-10-17 23:24:30'),(254,'Ines','Antialon maximiliano','944644761','inesrurh20@hotmail.com','El precio del departamento de 85m2 y con q banco trabajan','2018-10-17 23:44:56','2018-10-17 23:44:56'),(255,'Freddy','Carhuancho Rosado','988558245','fcarhuancho_r@hotmail.com','Necesito saber la ubicacion de los proyectos','2018-10-18 02:59:41','2018-10-18 02:59:41'),(256,'Charo','Collado','943928240','Prematura70@hotmail.com','Cuanto es el costo\r\n','2018-10-18 04:22:35','2018-10-18 04:22:35'),(257,'HECTOR ','Marcelo ','982060392','hectormarcelo007@gmail.com','InformaciÃ³n','2018-10-18 05:59:04','2018-10-18 05:59:04'),(258,'Roger','Noriega','965853384/984535167','r-nope@hotmail.com','informaciÃ³n completa por favor','2018-10-18 13:32:08','2018-10-18 13:32:08'),(259,'prueba','prueba','123123123','qweqwe@asdasd.com','qweqweqwe','2018-10-18 16:08:15','2018-10-18 16:08:15'),(260,'prueba','prueba','123123','prueba@asd.com','qweqweqwe','2018-10-18 16:08:55','2018-10-18 16:08:55'),(261,'qweqwe','qweqwe','123123','qweqwe@asdasd.com','qweqwe','2018-10-18 16:09:25','2018-10-18 16:09:25'),(262,'Erica','GonzÃ¡lez ','988882400','ericagponcedeleon@hotmail.com','Precio','2018-10-18 17:29:43','2018-10-18 17:29:43'),(263,'Milton','Zamora','943771782','miltomza@yahoo.es','....','2018-10-18 17:32:43','2018-10-18 17:32:43'),(264,'Celso Ricardo Jesus','Guerrero Requena','946040601','piping.guerrero@gmail.com','Financiamiento, se puede usar 25 de afp','2018-10-18 19:00:25','2018-10-18 19:00:25'),(265,'Carlos Alfredo','Aldave Paredes','991644055','carlos23ap@gmail.com','informaciÃ³n.','2018-10-18 20:39:59','2018-10-18 20:39:59'),(266,'Antonio RubÃ©n monzÃ³n jara','MonzÃ³n','982273144','antoniorubenmonzonjara@gmail.com','Soy operario de construcciÃ³n civil ','2018-10-19 00:07:10','2018-10-19 00:07:10'),(267,'Raul','Javier Cayetano','961623397','Javierimpor@gmail.com','Precio de los departamentos de 3 dormitorios','2018-10-19 00:51:10','2018-10-19 00:51:10'),(268,'Raul','Javier Cayetano','961623397','Javierimpor@gmail.com','Precio de los departamentos de 3 dormitorios','2018-10-19 00:51:24','2018-10-19 00:51:24'),(269,'Mari','Mor','90000000','maritza.moreno.c@gmail.com','Hola','2018-10-19 01:26:46','2018-10-19 01:26:46'),(270,'SuSANA','LadrÃ³n de Guevara','972704048','Shushulgm@hotmail.com','Costo de los departamentos tos y fecha de entrega','2018-10-19 03:46:57','2018-10-19 03:46:57'),(271,'David','Zamora','952324512','jdazaro@hotmail.com','Informacion del dÃºplex 4 dormitorios por favor vÃa correo electrÃ³nico. Gracias ','2018-10-19 06:09:29','2018-10-19 06:09:29'),(272,'Betsabe ','Orihuela ','929042886','Betsabeorihuela@gmail.com','InformaciÃ³n ','2018-10-19 08:42:59','2018-10-19 08:42:59'),(273,'Betsabe ','Orihuela ','929042886','Betsabeorihuela@gmail.com','InformaciÃ³n ','2018-10-19 08:43:26','2018-10-19 08:43:26'),(274,'MartÃn','VÃ©liz','994658600','marveles246@gmail.com','Buenos dias, requiero me puedan brindar informacion acerca de los dptos de 3 dormitorios del Edifico Prana, y cuando entregan el proyecto.','2018-10-19 16:04:02','2018-10-19 16:04:02'),(275,'Itzu','Vega','949536793','secovi_27@hotmail.com','Deseo ver el piloto','2018-10-19 16:40:59','2018-10-19 16:40:59'),(276,'Job','Zamora','952324512','jdazaro@hotmail.com','Por favor informaciÃ³n de dÃºplex 4 habitaciones ','2018-10-19 22:01:56','2018-10-19 22:01:56'),(277,'Job','Zamora','952324512','jdazaro@hotmail.com','Por favor informaciÃ³n de dÃºplex 4 habitaciones ','2018-10-19 22:02:18','2018-10-19 22:02:18'),(278,'Natali','Labajos','986934897','natali.labajosacosta@gmail.com','Me gustaria saber los precios','2018-10-20 01:28:35','2018-10-20 01:28:35'),(279,'Natali','Labajos acosta','986934897','natali.labajosacosta@gmail.com','Me gustaria saber los precios','2018-10-20 01:28:59','2018-10-20 01:28:59'),(280,'Genaro ','Salas Zegarra ','969385738','sazege1954@hotmail.com','Enviar informaciÃ³n ','2018-10-20 18:22:24','2018-10-20 18:22:24'),(281,'Genaro ','Salas Zegarra ','969385738','sazege1954@hotmail.com','Enviar informaciÃ³n ','2018-10-20 18:22:40','2018-10-20 18:22:40'),(282,'Erick Elvis','DÃaz','994314063','e.diaz@outlook.com.pe','InformaciÃ³n','2018-10-20 19:39:36','2018-10-20 19:39:36'),(283,'Erick','DÃaz','994314063','e.diaz@outlook.com.pe','Por favor mÃ¡s informaciÃ³n','2018-10-20 19:42:34','2018-10-20 19:42:34'),(284,'Susan','Tarazona','984379829','Starazonav@gmail.com','Consulta de precios, tamaÃ±o y habitaciones.','2018-10-20 23:30:00','2018-10-20 23:30:00'),(285,'Susan','Tarazona','984379829','Starazonav@gmail.com','Consulta de precios, tamaÃ±o y habitaciones.','2018-10-20 23:30:16','2018-10-20 23:30:16'),(286,'Segundo','Garcia flores','979112264','Sgflores2010@hotmail.com','Espero respuesta','2018-10-21 00:41:38','2018-10-21 00:41:38'),(287,'Victor','Zaferson','950396084','vwzafersonq@gmail.com','Buen dÃa estoy interesado en departamentos econÃ³micos, quisiera cotizaciones de los mÃ¡s econÃ³micos que tengan por favor ','2018-10-21 01:01:27','2018-10-21 01:01:27'),(288,'Monica','Albitres','976781438','malbitres28@gmail.com','Quisiera precio de los departamentos de 3 y 4 dormitorios. ','2018-10-21 04:07:52','2018-10-21 04:07:52'),(289,'Cynthia','Espinoza Alania','992423245','milagrosealania@gmail.com','Informe sobre todas las sedes , precios plazos, tiempo de entrega','2018-10-21 04:09:15','2018-10-21 04:09:15'),(290,'zandalee','santivaÃ±ez','970776875','zsantivanez@gmail.com','modelo 1','2018-10-21 05:15:54','2018-10-21 05:15:54'),(291,'Jenny ','Cubas','992620786','Jennygraciela1@hotmail.com','Interesada','2018-10-21 13:21:59','2018-10-21 13:21:59'),(292,'Beatriz Cristina','RuÃz Rojas','994885761','bearuizrojas@gmail.com','De tres dormitorios en primer o segundonpuso','2018-10-21 13:34:55','2018-10-21 13:34:55'),(293,'Yoss','Ch','949820822','yoselina15_6@hotmail.com','Precios duplo','2018-10-21 19:13:17','2018-10-21 19:13:17'),(294,'MARÃA ','CARDENAS','992036306','cardenaslmar@gmail.com','Buenas tardes estoy interesada en un departamento de 3D/2B con buena ventilaciÃ³n, que permita el ingreso de luz solar a los dormitorios','2018-10-21 20:22:55','2018-10-21 20:22:55'),(295,'MARÃA ','CARDENAS','992036306','cardenaslmar@gmail.com','Buenas tardes estoy interesada en un departamento de 3D/2B con buena ventilaciÃ³n, que permita el ingreso de luz solar a los dormitorios','2018-10-21 20:23:25','2018-10-21 20:23:25'),(296,'MARIA ','CARDENAS','992036306','cardenaslmar@gmail.com','Buenas tardes estoy rnteresada en departamento de 3D/2B que entre luz solar a los dormitorios\r\n','2018-10-21 20:29:57','2018-10-21 20:29:57'),(297,'Aurea','Meza garcia','958571537','aureamezag1@gmail.com','Precio depa de 2 dormitorios','2018-10-22 01:49:54','2018-10-22 01:49:54'),(298,'Aurea','Meza garcia','958571537','aureamezag1@gmail.com','Precio depa de 2 dormitorios','2018-10-22 01:50:16','2018-10-22 01:50:16'),(299,'MARIO ','Amancio ','978299634','lupitadominguezodar@gmail.com.pe','Precios y ubicaciÃ³n','2018-10-22 02:44:06','2018-10-22 02:44:06'),(300,'Nancy','Apcho','940428816','napcho76@hotmail.com','Informes','2018-10-22 03:46:49','2018-10-22 03:46:49'),(301,'Rocio','Lozada','949370490','Rociolorenalg@gmail.com','Cotizar tipo 4\r\nFecha de entrega','2018-10-22 04:51:49','2018-10-22 04:51:49'),(302,'amelia ','atauje','947503519','ing_ataujev@hotmail.com','costo de departamento de 03 dormitorios','2018-10-22 16:57:35','2018-10-22 16:57:35'),(303,'amelia ','atauje','947503519','ing_ataujev@hotmail.com','costo de departamento de 03 dormitorios','2018-10-22 16:57:47','2018-10-22 16:57:47'),(304,'Ana Vivian','Herrera Tiza','941360370','anavivianht@gmail.com','consulta por precios','2018-10-22 17:28:55','2018-10-22 17:28:55'),(305,'Anilsa Gissela','Diaz Ramirez','991534336','anilsadiaz@gmail.com','Buenos dias, agradecere me den informacion de los departamentos que tienen para entrega inmediata, gracias','2018-10-22 18:14:23','2018-10-22 18:14:23'),(306,'paulo','taboada moretti','55 13 991671331','paulo@brasilperutrading.com','Soy representante de pisos laminados KASTAMONU, querÃa pedir una reuniÃ³n con el  gerente de compras.\r\n\r\nwww.keas.com.br','2018-10-22 21:46:01','2018-10-22 21:46:01'),(307,'Melissa','De la Cruz ','936230281 ','melissaglenndelacruzquispe@gmail.com','Me podrÃa brindar precios porfavor ','2018-10-22 22:41:42','2018-10-22 22:41:42'),(308,'Margot','Ore','934717540','margotore@hotmail.com','Deseo mayor informaciÃ³n sobre compra alquiler de un departamento con tres dormitorios','2018-10-23 01:46:07','2018-10-23 01:46:07'),(309,'Fanny ','Barzola romero','970 304 647','Fanny.barzola@gmail.com','Buenos dias, quisera obtener informacion, quisieta saber si cuenta con el plan de alquiler venta y que requisitos se debe de tener.','2018-10-23 16:41:53','2018-10-23 16:41:53'),(310,'OSCAR','CRIBILLERO','980098600','oscarcribillero@hotmail.com','Enviar informaciÃ³n por correo, me interesa el modelo 3','2018-10-23 16:50:29','2018-10-23 16:50:29'),(311,'Ricardo','Ramirez','966112091','rdrr12487@hotmail.com','cotizacion - 3 dormitorios','2018-10-23 17:35:03','2018-10-23 17:35:03'),(312,'Adina','Quispe','971065413','adyqcc@gmail.com','estoy interesada en adquirir un departamento a la brevedad, debe incluir cochera.','2018-10-24 01:39:15','2018-10-24 01:39:15'),(313,'Maria','Benito curo','966005141','marisbc22@hotmail.com','Quiero saber el costo del departamento y el piso  y el Ã¡rea del departamento','2018-10-24 02:14:49','2018-10-24 02:14:49'),(314,'Junior Manuel','Zapata Chiroque','920241586','jmzapatach@gmail.com',':)','2018-10-24 05:30:17','2018-10-24 05:30:17'),(315,'Edson','Acero Jara','933830193','edson28acero@hotmail.com','CotizaciÃ³n para departamento de aprox 65m2 con 2 dormitorios','2018-10-24 13:31:29','2018-10-24 13:31:29'),(316,'Gladys','Giraldo','998301972','Raiginmobiliariaperu@gmail.com','Dpto 3 dormitorio ','2018-10-24 22:03:33','2018-10-24 22:03:33'),(317,'Gladys','Giraldo','998301972','Raiginmobiliariaperu@gmail.com','Dpto 3 dormitorio ','2018-10-24 22:04:00','2018-10-24 22:04:00'),(318,'Norma','Anglas','990039782','usaproyectosperu@gmail.com','Contamos con terreno, frente y fondo con vista a Parque!\r\nDistrito: Pueblo Libre RDM (06)\r\nÃ‚rea Total: 255.30 m2\r\nFrente: 10.50 ml con frente a Parque \r\nFondo:13.75 ml con frente a Parque (calle cerrada)\r\n','2018-10-24 22:30:17','2018-10-24 22:30:17'),(319,'DUnie','Cavero ','956146141','dcavero1@icloud.com','InformaciÃ³n yen','2018-10-25 00:26:15','2018-10-25 00:26:15'),(320,'Alexander','Chavez','980838921','achavezm@tzinmobiliaria.com','Estimados, el motivo de la presente es para ver la vialidad de trabajar en sinergia, debido que contamos con cartera de clientes interesados en la compra de unidades inmobiliarias, por lo cual nos ponemos en contacto con su empresa para trabajar sus proyectos por medio del corretaje inmobiliario , quedo a su gentil atenciÃ³n ','2018-10-25 01:17:50','2018-10-25 01:17:50'),(321,'Livia','Machaca','947556021','liviamachaca@gmail.com','InformaciÃ³n por favor','2018-10-25 02:01:30','2018-10-25 02:01:30'),(322,'Javier','Macha','983581227','machatorpocoj@gmail.com','Quisiera saber precios de todos sus distritos disponibles porfavor.','2018-10-25 05:28:20','2018-10-25 05:28:20'),(323,'Abel','Romero','989191931','abel783@hotmail.com','CotizaciÃ³n y mayores especificaciones es las habitaciones','2018-10-25 13:14:30','2018-10-25 13:14:30'),(324,'Gustavo','Silva','992083260','Gsilvagalvan@gmail.com','Departamento de 2 o 3 dormitorios. Enviar cotizaciÃ³n.\r\nSaludos','2018-10-25 13:37:22','2018-10-25 13:37:22'),(325,'Guido Enrique','Molina Cayo','988566501','gmolina_cayo@hotmail.com','AgradecerÃ©, puedan brindarme informacion\r\n\r\nGracias','2018-10-25 15:42:52','2018-10-25 15:42:52'),(326,'Erika','Zelada','990223050','erica_4472@hotmail.com','Deseo informacion ','2018-10-25 15:45:09','2018-10-25 15:45:09'),(327,'Gretel','Olsen','998122637','gretel.olsen@gmail.com','XXX','2018-10-25 19:46:27','2018-10-25 19:46:27'),(328,'Gretel','Olsen','998122637','gretel.olsen@gmail.com','..','2018-10-25 19:46:37','2018-10-25 19:46:37'),(329,'Lourdes','Chimoy','966817187','lulu_1503@hotmail.com','Costo de departamentos con estacionamiento de 2 y 3 dormitorios','2018-10-25 20:52:02','2018-10-25 20:52:02'),(330,'Lourdes ','Chimoy ','966817187','lulu_1503@hotmail.com','Quisiera saber el costo del departamento B1-X-07 de 81 mts con estacionamiento','2018-10-25 21:01:26','2018-10-25 21:01:26'),(331,'Manuel','Davila','945241747','manueldavilamiguel@gmail.com','Mayor informaciÃ³n de precios','2018-10-25 22:00:04','2018-10-25 22:00:04'),(332,'Manuel','Davila','945241747','manueldavilamiguel@gmail.com','Mayor informaciÃ³n de precios','2018-10-25 22:00:14','2018-10-25 22:00:14'),(333,'EVELYN','BODERO','995506108','e_boyama@yahoo.es','ENVIAR PRECIOS DE DEPARTAMENTOS DE 1 DORMITORIO ','2018-10-25 22:12:45','2018-10-25 22:12:45'),(334,'Rosa lus ','Tintaya gaspar','953306049','Ros1584@hotmail.com','Busco trabajo de limpesa gruesa o fina tengo esperiencia','2018-10-25 22:59:48','2018-10-25 22:59:48'),(335,'Livia','Machaca','947556021','liviamachaca@gmail.com','InformaciÃ³n por favor','2018-10-26 09:24:56','2018-10-26 09:24:56'),(336,'Gina','Tello','999101207','paolatv18@gmail.com','Me gustarÃa recibir mÃ¡s informaciÃ³n. Gracias','2018-10-26 11:33:19','2018-10-26 11:33:19'),(337,'LENIN ','ESTRADA','991409681','LEVIETSRADA008@GMAIL.COM','INFORMES SOBRE LOS DEPARTAMENTOS, GRACIAS.','2018-10-26 15:16:21','2018-10-26 15:16:21'),(338,'Oscar','Carbajal','979376075','oscarbajal1987@gmail.com','Me gustarÃa informaciÃ³n sobre los departamento de tres habitaciones; asimismo, el precio de ser adquirido con estacionamiento y depÃ³sito. Gracias!','2018-10-26 19:56:27','2018-10-26 19:56:27'),(339,'Oscar','Carbajal','979376075','oscarbajal1987@gmail.com','Me gustarÃa informaciÃ³n sobre los departamento de tres habitaciones; asimismo, el precio de ser adquirido con estacionamiento y depÃ³sito. Gracias!','2018-10-26 19:57:30','2018-10-26 19:57:30'),(340,'Claudia','Ramirez','987192312','claudia.m.ramirez87@gmail.com','Quisiera saber el costo de los dÃºplex y sus caracterÃsticas, gracias','2018-10-26 19:58:17','2018-10-26 19:58:17'),(341,'ceci','Moya','934933558','moyaceci@gmail.com','Costos de departamentos mas econÃ³mico','2018-10-27 05:18:16','2018-10-27 05:18:16'),(342,'ARmÃ¡ndo','De la Rosa','875145023','abrc70@hotmail.com','InformaciÃ³n del departamento de 86 M2, en que puso de encuentra','2018-10-28 13:51:46','2018-10-28 13:51:46'),(343,'ARmando','De la Rosa','875145023','abrc70@hotmail.com','InformaciÃ³n del departamento de 86 M2, en que puso de encuentra','2018-10-28 13:52:05','2018-10-28 13:52:05'),(344,'Jorge Adrian','Flores Rojas','946551881','Jorge.Adrian.jf@gmail.com','Dpto.03 dormitorios','2018-10-28 17:24:52','2018-10-28 17:24:52'),(345,'Solange','Manrique Oviedo ','959383180','smanriqueoviedo@gmail.com','Hola! Deseo mÃ¡s informaciÃ³n, gracias ','2018-10-28 17:33:07','2018-10-28 17:33:07'),(346,'LUIS IVAN','LAPA HUILLCA','980504714','luis_ivan_l_h@hotmail.com','Rango de precios de departamentos con 3 dormitorios y2 baÃ±os','2018-10-28 17:42:49','2018-10-28 17:42:49'),(347,'luis','Gonzales Linares','989408332','l_gonzales_l@hotmail.com','Buenos dias, por favor quisiera mas informaciÃ³n sobre los precios de los departamentos del proyecto epiqe. gracias. saludos.','2018-10-28 18:25:25','2018-10-28 18:25:25'),(348,'Sabrina','Montalvo Vidaurre','987144994','sabrimontalvo@hotmail.com','Hola! Quiero informaciÃ³n. \r\nGracias','2018-10-28 21:42:12','2018-10-28 21:42:12'),(349,'Elizabeth','Paredes','953755382','maciel_10_24@hotmail.com','Deseo informaciÃ³n sobre departamentos de 2 habitaciones +2baÃ±os','2018-10-28 21:51:24','2018-10-28 21:51:24'),(350,'Denisse','NuÃ±ez Aguilar','982569441','denisse.nunez.aguilar@gmail.com','Buenas noches estimados,\r\nSolicito informaciÃ³n sobre este departamento ya que necesito urgentemente donde vivir con mi menor hija, gracias\r\n\r\nA espera de su pronta respuesta.\r\nSaludos.','2018-10-29 00:44:12','2018-10-29 00:44:12'),(351,'Denisse','NuÃ±ez Aguilar','982569441','denisse.nunez.aguilar@gmail.com','Buenas noches estimados,\r\nSolicito informaciÃ³n sobre este departamento ya que necesito urgentemente donde vivir con mi menor hija, gracias\r\n\r\nA espera de su pronta respuesta.\r\nSaludos.','2018-10-29 00:44:26','2018-10-29 00:44:26'),(352,'Denisse','NuÃ±ez Aguilar','98569441','denisse.nunez.aguilar@gmail.com','Buenas noches estimados,\r\n\r\nSolicito informacion sobre la venta de este departamento ya que necesito de manera ugente un lugar donde vivir con mi menor hija.\r\n\r\nGracias de antemano, a espera de su pronta respuesta.\r\n\r\nSaludos.','2018-10-29 00:46:48','2018-10-29 00:46:48'),(353,'Jenny','Guerrero','975999999','jennyguerrero91@hotmail.com','Quisiera conocer costos de su proyecto de la avenida Brasil de 3 dormitorios y costos de cocheras. TambiÃ©n el de la avenida Salaverry. Mil gracias','2018-10-29 01:41:52','2018-10-29 01:41:52'),(354,'Jenny','Guerrero','975499999','jennyguerrero91@hotmail.com','Quisiera conocer costos de su proyecto de la avenida Brasil de 3 dormitorios y costos de cocheras. TambiÃ©n el de la avenida Salaverry. Mil gracias','2018-10-29 01:42:12','2018-10-29 01:42:12'),(355,'Luz','Gamonal','943913910','Luz_28_gamora@hotmail.com','InformaciÃ³n sobre precios','2018-10-29 15:14:30','2018-10-29 15:14:30'),(356,'Luz','Gamonal','943913910','Luz_28_gamora@hotmail.com','Solicito informaciÃ³n ','2018-10-29 16:52:27','2018-10-29 16:52:27'),(357,'Mayra','Cueva blas','980645710 ','mayrac0512@hotmail.com','Cotizar','2018-10-29 20:29:32','2018-10-29 20:29:32'),(358,'Johanna','Rojas','916476672','johanna325@hotmail.com','InformaciÃ³n sobre olguin','2018-10-29 21:01:01','2018-10-29 21:01:01'),(359,'KARINA','Barrientos','959248038','KARDANG@HOTMAIL.COM','INFORMACION DE DOS O TRES DORMITORIOS DEL PROYECT ONESTA SALAVERRY 475','2018-10-29 21:02:43','2018-10-29 21:02:43'),(360,'Karina Liz ','Dextre Pajuelo','944798460','karinaliz.dextrepajuelo@hotmail.com','InformaciÃ³n','2018-10-30 13:53:30','2018-10-30 13:53:30'),(361,'Carla','Morales ','967915674 ','camimori@hotmail.com','Deseo saber sobre departamento de 3 dormitorios','2018-10-30 15:09:08','2018-10-30 15:09:08'),(362,'mariciel','jaime quispe','934215219','katerine_estrella123@hotmail.com','buenos dias mas informacion de departamentos\r\n','2018-10-30 16:25:51','2018-10-30 16:25:51'),(363,'Fiorella','Coz','998885364','fiorellatc728@gmail.com','Precios para 2 dormitorios, s por favor','2018-10-30 17:08:52','2018-10-30 17:08:52'),(364,'Jenny ','NuÃ±ez Salas ','920044184','Inversoones_10defebrero@hotmail.com','2 dormitorios ','2018-10-30 18:04:42','2018-10-30 18:04:42'),(365,'Ciro','Basto','988893662','eymijc@hotmail.com','Me interesa ,un dpto de 3 dormitorios','2018-10-30 19:22:09','2018-10-30 19:22:09'),(366,'Cristina','Torres','989116842','cristinat.torres15@gmail.com','Porfavor cotizar los dptos de 3 cuartos. Indicar si incluye estacionamiento y la lista de acabados (si se pueden cambiar o son predeterminados)','2018-10-30 20:23:10','2018-10-30 20:23:10'),(367,'Melissa ','De la cruz','936230281 ','Melissaglenndelacruzquispe@gmail.com','InformaciÃ³n de 2 y 3 departamentos y precios, y tipo de financiamiento. ','2018-10-31 01:18:13','2018-10-31 01:18:13'),(368,'Giuliana','Zapata','992848045','giulianazapatasa@hotmail.com','Necesito cotizaciÃ³n de un departamentos de 1 dormitorio 1 un baÃ±o\r\nSaludos,\r\nGiuliana  ','2018-10-31 03:38:06','2018-10-31 03:38:06'),(369,'Giuliana','Zapata','992748045','giulianazapatasa@hotmail.com','Necesito cotizaciÃ³n del proyecto Velia en Av. Belisario 1035 Lince .\r\nSi tuvieran proyectos  en JesÃºs Maria, agradecerÃ© informaciÃ³n 1 dpto con 1 dormitorio + 1 baÃ±o.\r\nSaludos,\r\nGiuliana\r\n992724045','2018-10-31 03:42:47','2018-10-31 03:42:47'),(370,'Cinthia','Roncal','959742874','cinthiarm24@hotmail.com','Solicito informaciÃ³n de departamento con 3 dormitorios','2018-10-31 04:03:27','2018-10-31 04:03:27'),(371,'Carmen','Cabanillas','956176913','habby86186@gmail.com','Info porfavor','2018-10-31 14:04:02','2018-10-31 14:04:02'),(372,'Estephany','Espino','951894762','gloria_19espi@hotmail.com','Estoy intersada en departamentos en surco','2018-10-31 16:08:53','2018-10-31 16:08:53'),(373,'Elizabeth','Paredes','953755382','maciel_10_24@hotmail.com','Deseo informaciÃ³n sobre departamentos de 2 habitaciones','2018-10-31 17:44:18','2018-10-31 17:44:18');
573/*!40000 ALTER TABLE `subscription` ENABLE KEYS */;
574UNLOCK TABLES;
575
576--
577-- Table structure for table `user`
578--
579
580DROP TABLE IF EXISTS `user`;
581/*!40101 SET @saved_cs_client     = @@character_set_client */;
582/*!40101 SET character_set_client = utf8 */;
583CREATE TABLE `user` (
584  `id` int(11) NOT NULL AUTO_INCREMENT,
585  `username` varchar(180) COLLATE utf8mb4_unicode_ci NOT NULL,
586  `username_canonical` varchar(180) COLLATE utf8mb4_unicode_ci NOT NULL,
587  `email` varchar(180) COLLATE utf8mb4_unicode_ci NOT NULL,
588  `email_canonical` varchar(180) COLLATE utf8mb4_unicode_ci NOT NULL,
589  `enabled` tinyint(1) NOT NULL,
590  `salt` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
591  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
592  `last_login` datetime DEFAULT NULL,
593  `confirmation_token` varchar(180) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
594  `password_requested_at` datetime DEFAULT NULL,
595  `roles` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '(DC2Type:array)',
596  PRIMARY KEY (`id`),
597  UNIQUE KEY `UNIQ_8D93D64992FC23A8` (`username_canonical`),
598  UNIQUE KEY `UNIQ_8D93D649A0D96FBF` (`email_canonical`),
599  UNIQUE KEY `UNIQ_8D93D649C05FB297` (`confirmation_token`)
600) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
601/*!40101 SET character_set_client = @saved_cs_client */;
602
603--
604-- Dumping data for table `user`
605--
606
607LOCK TABLES `user` WRITE;
608/*!40000 ALTER TABLE `user` DISABLE KEYS */;
609INSERT INTO `user` VALUES (1,'admin','admin','sistemas@formulaperu.com','sistemas@formulaperu.com',1,NULL,'$2y$13$pO4/UnDPcrfX.jKqbXv.BOtZdrNY.fSawasiXeu5PKdruTIPrAx/6','2018-10-30 19:36:04',NULL,NULL,'a:1:{i:0;s:10:\"ROLE_ADMIN\";}'),(3,'cosapi','cosapi','ecabrera@cosapi.com.pe','ecabrera@cosapi.com.pe',1,NULL,'$2y$13$TZxK0ukh12inSGD5A7emX.sKvU3G5fjA7b7r6eB6Cp5lrmVt/Y6rG','2018-10-04 15:55:19',NULL,NULL,'a:0:{}');
610/*!40000 ALTER TABLE `user` ENABLE KEYS */;
611UNLOCK TABLES;
612/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
613
614/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
615/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
616/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
617/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
618/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
619/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
620/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
621
622-- Dump completed on 2018-10-31 20:43:02