· 6 years ago · May 17, 2019, 12:22 AM
1CREATE DATABASE IF NOT EXISTS `imodata` /*!40100 DEFAULT CHARACTER SET latin1 */;
2USE `imodata`;
3-- MySQL dump 10.13 Distrib 5.7.17, for Win64 (x86_64)
4--
5-- Host: 127.0.0.1 Database: imodata
6-- ------------------------------------------------------
7-- Server version 5.5.5-10.1.25-MariaDB
8
9/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
10/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
11/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
12/*!40101 SET NAMES utf8 */;
13/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
14/*!40103 SET TIME_ZONE='+00:00' */;
15/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
16/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
17/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
18/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
19
20--
21-- Table structure for table `anuncio`
22--
23
24DROP TABLE IF EXISTS `anuncio`;
25/*!40101 SET @saved_cs_client = @@character_set_client */;
26/*!40101 SET character_set_client = utf8 */;
27CREATE TABLE `anuncio` (
28 `id` int(4) NOT NULL AUTO_INCREMENT,
29 `valor` decimal(9,2) NOT NULL,
30 `descricao` longtext NOT NULL,
31 `ativo` tinyint(4) NOT NULL DEFAULT '1',
32 `url` varchar(255) NOT NULL,
33 `referencia` varchar(50) DEFAULT NULL,
34 `imovelId` int(4) NOT NULL,
35 `estadoNegociacaoId` tinyint(4) NOT NULL,
36 `imobiliariaId` int(4) NOT NULL,
37 `tipoImovelId` tinyint(4) NOT NULL,
38 PRIMARY KEY (`id`),
39 KEY `anuncio_estadoNegociacao` (`estadoNegociacaoId`),
40 KEY `anuncio_imobiliaria` (`imobiliariaId`),
41 KEY `anuncio_imovel` (`imovelId`),
42 KEY `anuncio_tipoImovel` (`tipoImovelId`),
43 CONSTRAINT `anuncio_estadoNegociacao` FOREIGN KEY (`estadoNegociacaoId`) REFERENCES `estadonegociacao` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
44 CONSTRAINT `anuncio_imobiliaria` FOREIGN KEY (`imobiliariaId`) REFERENCES `imobiliaria` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
45 CONSTRAINT `anuncio_imovel` FOREIGN KEY (`imovelId`) REFERENCES `imovel` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
46 CONSTRAINT `anuncio_tipoImovel` FOREIGN KEY (`tipoImovelId`) REFERENCES `tipoimovel` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
47) ENGINE=InnoDB DEFAULT CHARSET=latin1;
48/*!40101 SET character_set_client = @saved_cs_client */;
49
50--
51-- Dumping data for table `anuncio`
52--
53
54LOCK TABLES `anuncio` WRITE;
55/*!40000 ALTER TABLE `anuncio` DISABLE KEYS */;
56/*!40000 ALTER TABLE `anuncio` ENABLE KEYS */;
57UNLOCK TABLES;
58
59--
60-- Table structure for table `bairro`
61--
62
63DROP TABLE IF EXISTS `bairro`;
64/*!40101 SET @saved_cs_client = @@character_set_client */;
65/*!40101 SET character_set_client = utf8 */;
66CREATE TABLE `bairro` (
67 `id` int(4) NOT NULL AUTO_INCREMENT,
68 `nome` varchar(50) NOT NULL,
69 `cidadeId` int(4) NOT NULL,
70 PRIMARY KEY (`id`),
71 KEY `cidadeId` (`cidadeId`),
72 CONSTRAINT `bairro_ibfk_1` FOREIGN KEY (`cidadeId`) REFERENCES `cidade` (`id`)
73) ENGINE=InnoDB DEFAULT CHARSET=latin1;
74/*!40101 SET character_set_client = @saved_cs_client */;
75
76--
77-- Dumping data for table `bairro`
78--
79
80LOCK TABLES `bairro` WRITE;
81/*!40000 ALTER TABLE `bairro` DISABLE KEYS */;
82/*!40000 ALTER TABLE `bairro` ENABLE KEYS */;
83UNLOCK TABLES;
84
85--
86-- Table structure for table `caracteristica`
87--
88
89DROP TABLE IF EXISTS `caracteristica`;
90/*!40101 SET @saved_cs_client = @@character_set_client */;
91/*!40101 SET character_set_client = utf8 */;
92CREATE TABLE `caracteristica` (
93 `id` tinyint(4) NOT NULL AUTO_INCREMENT,
94 `nome` varchar(20) NOT NULL,
95 `icone` varchar(30) NOT NULL,
96 PRIMARY KEY (`id`),
97 UNIQUE KEY `nome_UNIQUE` (`nome`)
98) ENGINE=InnoDB DEFAULT CHARSET=latin1;
99/*!40101 SET character_set_client = @saved_cs_client */;
100
101--
102-- Dumping data for table `caracteristica`
103--
104
105LOCK TABLES `caracteristica` WRITE;
106/*!40000 ALTER TABLE `caracteristica` DISABLE KEYS */;
107/*!40000 ALTER TABLE `caracteristica` ENABLE KEYS */;
108UNLOCK TABLES;
109
110--
111-- Table structure for table `caracteristicasimovel`
112--
113
114DROP TABLE IF EXISTS `caracteristicasimovel`;
115/*!40101 SET @saved_cs_client = @@character_set_client */;
116/*!40101 SET character_set_client = utf8 */;
117CREATE TABLE `caracteristicasimovel` (
118 `imovelId` int(4) NOT NULL,
119 `caracteristicaId` tinyint(4) NOT NULL,
120 `valor` varchar(45) NOT NULL,
121 PRIMARY KEY (`imovelId`,`caracteristicaId`),
122 KEY `caracteristicasImovel_caracteristica` (`caracteristicaId`),
123 CONSTRAINT `caracteristicasImovel_caracteristica` FOREIGN KEY (`caracteristicaId`) REFERENCES `caracteristica` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
124 CONSTRAINT `caracteristicasImovel_imovel` FOREIGN KEY (`imovelId`) REFERENCES `imovel` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
125) ENGINE=InnoDB DEFAULT CHARSET=latin1;
126/*!40101 SET character_set_client = @saved_cs_client */;
127
128--
129-- Dumping data for table `caracteristicasimovel`
130--
131
132LOCK TABLES `caracteristicasimovel` WRITE;
133/*!40000 ALTER TABLE `caracteristicasimovel` DISABLE KEYS */;
134/*!40000 ALTER TABLE `caracteristicasimovel` ENABLE KEYS */;
135UNLOCK TABLES;
136
137--
138-- Table structure for table `cidade`
139--
140
141DROP TABLE IF EXISTS `cidade`;
142/*!40101 SET @saved_cs_client = @@character_set_client */;
143/*!40101 SET character_set_client = utf8 */;
144CREATE TABLE `cidade` (
145 `id` int(4) NOT NULL AUTO_INCREMENT,
146 `nome` varchar(50) NOT NULL,
147 `estadoId` int(4) NOT NULL,
148 PRIMARY KEY (`id`),
149 KEY `estadoId` (`estadoId`),
150 CONSTRAINT `cidade_ibfk_1` FOREIGN KEY (`estadoId`) REFERENCES `estado` (`id`)
151) ENGINE=InnoDB DEFAULT CHARSET=latin1;
152/*!40101 SET character_set_client = @saved_cs_client */;
153
154--
155-- Dumping data for table `cidade`
156--
157
158LOCK TABLES `cidade` WRITE;
159/*!40000 ALTER TABLE `cidade` DISABLE KEYS */;
160/*!40000 ALTER TABLE `cidade` ENABLE KEYS */;
161UNLOCK TABLES;
162
163--
164-- Table structure for table `estado`
165--
166
167DROP TABLE IF EXISTS `estado`;
168/*!40101 SET @saved_cs_client = @@character_set_client */;
169/*!40101 SET character_set_client = utf8 */;
170CREATE TABLE `estado` (
171 `id` int(4) NOT NULL AUTO_INCREMENT,
172 `nome` varchar(50) NOT NULL,
173 `paisId` tinyint(4) NOT NULL,
174 PRIMARY KEY (`id`),
175 KEY `pais_estado` (`paisId`),
176 CONSTRAINT `pais_estado` FOREIGN KEY (`paisId`) REFERENCES `pais` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
177) ENGINE=InnoDB DEFAULT CHARSET=latin1;
178/*!40101 SET character_set_client = @saved_cs_client */;
179
180--
181-- Dumping data for table `estado`
182--
183
184LOCK TABLES `estado` WRITE;
185/*!40000 ALTER TABLE `estado` DISABLE KEYS */;
186/*!40000 ALTER TABLE `estado` ENABLE KEYS */;
187UNLOCK TABLES;
188
189--
190-- Table structure for table `estadoimovel`
191--
192
193DROP TABLE IF EXISTS `estadoimovel`;
194/*!40101 SET @saved_cs_client = @@character_set_client */;
195/*!40101 SET character_set_client = utf8 */;
196CREATE TABLE `estadoimovel` (
197 `id` tinyint(4) NOT NULL AUTO_INCREMENT,
198 `nome` varchar(20) NOT NULL,
199 PRIMARY KEY (`id`),
200 UNIQUE KEY `nome_UNIQUE` (`nome`)
201) ENGINE=InnoDB DEFAULT CHARSET=latin1;
202/*!40101 SET character_set_client = @saved_cs_client */;
203
204--
205-- Dumping data for table `estadoimovel`
206--
207
208LOCK TABLES `estadoimovel` WRITE;
209/*!40000 ALTER TABLE `estadoimovel` DISABLE KEYS */;
210/*!40000 ALTER TABLE `estadoimovel` ENABLE KEYS */;
211UNLOCK TABLES;
212
213--
214-- Table structure for table `estadonegociacao`
215--
216
217DROP TABLE IF EXISTS `estadonegociacao`;
218/*!40101 SET @saved_cs_client = @@character_set_client */;
219/*!40101 SET character_set_client = utf8 */;
220CREATE TABLE `estadonegociacao` (
221 `id` tinyint(4) NOT NULL AUTO_INCREMENT,
222 `nome` varchar(20) NOT NULL,
223 PRIMARY KEY (`id`),
224 UNIQUE KEY `nome_UNIQUE` (`nome`)
225) ENGINE=InnoDB DEFAULT CHARSET=latin1;
226/*!40101 SET character_set_client = @saved_cs_client */;
227
228--
229-- Dumping data for table `estadonegociacao`
230--
231
232LOCK TABLES `estadonegociacao` WRITE;
233/*!40000 ALTER TABLE `estadonegociacao` DISABLE KEYS */;
234/*!40000 ALTER TABLE `estadonegociacao` ENABLE KEYS */;
235UNLOCK TABLES;
236
237--
238-- Table structure for table `estadonegociacaoanuncio`
239--
240
241DROP TABLE IF EXISTS `estadonegociacaoanuncio`;
242/*!40101 SET @saved_cs_client = @@character_set_client */;
243/*!40101 SET character_set_client = utf8 */;
244CREATE TABLE `estadonegociacaoanuncio` (
245 `anuncioId` int(4) NOT NULL,
246 `estadonegociacaoId` tinyint(4) NOT NULL,
247 `data` datetime NOT NULL,
248 PRIMARY KEY (`anuncioId`,`estadonegociacaoId`),
249 KEY `estadoNegociacaoAnuncio_estadoNegociacao` (`estadonegociacaoId`),
250 CONSTRAINT `estadoNegociacaoAnuncio_anuncio` FOREIGN KEY (`anuncioId`) REFERENCES `anuncio` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
251 CONSTRAINT `estadoNegociacaoAnuncio_estadoNegociacao` FOREIGN KEY (`estadonegociacaoId`) REFERENCES `estadonegociacao` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
252) ENGINE=InnoDB DEFAULT CHARSET=latin1;
253/*!40101 SET character_set_client = @saved_cs_client */;
254
255--
256-- Dumping data for table `estadonegociacaoanuncio`
257--
258
259LOCK TABLES `estadonegociacaoanuncio` WRITE;
260/*!40000 ALTER TABLE `estadonegociacaoanuncio` DISABLE KEYS */;
261/*!40000 ALTER TABLE `estadonegociacaoanuncio` ENABLE KEYS */;
262UNLOCK TABLES;
263
264--
265-- Table structure for table `foto`
266--
267
268DROP TABLE IF EXISTS `foto`;
269/*!40101 SET @saved_cs_client = @@character_set_client */;
270/*!40101 SET character_set_client = utf8 */;
271CREATE TABLE `foto` (
272 `id` int(4) NOT NULL AUTO_INCREMENT,
273 `anuncioId` int(4) NOT NULL,
274 `url` varchar(255) NOT NULL,
275 PRIMARY KEY (`id`),
276 KEY `foto_anuncio` (`anuncioId`),
277 CONSTRAINT `foto_anuncio` FOREIGN KEY (`anuncioId`) REFERENCES `anuncio` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
278) ENGINE=InnoDB DEFAULT CHARSET=latin1;
279/*!40101 SET character_set_client = @saved_cs_client */;
280
281--
282-- Dumping data for table `foto`
283--
284
285LOCK TABLES `foto` WRITE;
286/*!40000 ALTER TABLE `foto` DISABLE KEYS */;
287/*!40000 ALTER TABLE `foto` ENABLE KEYS */;
288UNLOCK TABLES;
289
290--
291-- Table structure for table `historicovaloranuncio`
292--
293
294DROP TABLE IF EXISTS `historicovaloranuncio`;
295/*!40101 SET @saved_cs_client = @@character_set_client */;
296/*!40101 SET character_set_client = utf8 */;
297CREATE TABLE `historicovaloranuncio` (
298 `id` int(4) NOT NULL AUTO_INCREMENT,
299 `anuncioId` int(4) NOT NULL,
300 `data` datetime NOT NULL,
301 `valor` decimal(9,2) NOT NULL,
302 PRIMARY KEY (`id`),
303 KEY `historicoValorAnuncio_anuncio` (`anuncioId`),
304 CONSTRAINT `historicoValorAnuncio_anuncio` FOREIGN KEY (`anuncioId`) REFERENCES `anuncio` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
305) ENGINE=InnoDB DEFAULT CHARSET=latin1;
306/*!40101 SET character_set_client = @saved_cs_client */;
307
308--
309-- Dumping data for table `historicovaloranuncio`
310--
311
312LOCK TABLES `historicovaloranuncio` WRITE;
313/*!40000 ALTER TABLE `historicovaloranuncio` DISABLE KEYS */;
314/*!40000 ALTER TABLE `historicovaloranuncio` ENABLE KEYS */;
315UNLOCK TABLES;
316
317--
318-- Table structure for table `imobiliaria`
319--
320
321DROP TABLE IF EXISTS `imobiliaria`;
322/*!40101 SET @saved_cs_client = @@character_set_client */;
323/*!40101 SET character_set_client = utf8 */;
324CREATE TABLE `imobiliaria` (
325 `id` int(4) NOT NULL AUTO_INCREMENT,
326 `nome` varchar(45) NOT NULL,
327 `site` varchar(45) DEFAULT NULL,
328 `portal` tinyint(4) NOT NULL DEFAULT '0',
329 `codigo` varchar(50) NOT NULL,
330 `ativo` tinyint(4) NOT NULL DEFAULT '1',
331 PRIMARY KEY (`id`),
332 UNIQUE KEY `codigo_UNIQUE` (`codigo`)
333) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
334/*!40101 SET character_set_client = @saved_cs_client */;
335
336--
337-- Dumping data for table `imobiliaria`
338--
339
340LOCK TABLES `imobiliaria` WRITE;
341/*!40000 ALTER TABLE `imobiliaria` DISABLE KEYS */;
342INSERT INTO `imobiliaria` VALUES (1,'Casa Sapo','#',1,'1001',1),(2,'Imo Brasil Web','#',0,'1002',1),(3,'Malca','#',0,'1003',1),(4,'Solucadi','#',0,'1004',1),(5,'Imodata','#',1,'1005',1),(6,'Reatia','#',1,'1006',1),(7,'Praça Imobiliária','#',0,'1007',1),(8,'Tavela','#',0,'1008',1),(9,'Imobiliária Central','#',0,'1009',1),(10,'ARS','#',0,'1010',1);
343/*!40000 ALTER TABLE `imobiliaria` ENABLE KEYS */;
344UNLOCK TABLES;
345
346--
347-- Table structure for table `imovel`
348--
349
350DROP TABLE IF EXISTS `imovel`;
351/*!40101 SET @saved_cs_client = @@character_set_client */;
352/*!40101 SET character_set_client = utf8 */;
353CREATE TABLE `imovel` (
354 `id` int(4) NOT NULL AUTO_INCREMENT,
355 `estadoImovelId` tinyint(4) NOT NULL,
356 `tipoImovelId` tinyint(4) NOT NULL,
357 `bairroId` int(4) NOT NULL,
358 PRIMARY KEY (`id`),
359 KEY `imovel_bairro` (`bairroId`),
360 KEY `imovel_estadoImovel` (`estadoImovelId`),
361 KEY `imovel_tipoImovel` (`tipoImovelId`),
362 CONSTRAINT `imovel_bairro` FOREIGN KEY (`bairroId`) REFERENCES `bairro` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
363 CONSTRAINT `imovel_estadoImovel` FOREIGN KEY (`estadoImovelId`) REFERENCES `estadoimovel` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
364 CONSTRAINT `imovel_tipoImovel` FOREIGN KEY (`tipoImovelId`) REFERENCES `tipoimovel` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
365) ENGINE=InnoDB DEFAULT CHARSET=latin1;
366/*!40101 SET character_set_client = @saved_cs_client */;
367
368--
369-- Dumping data for table `imovel`
370--
371
372LOCK TABLES `imovel` WRITE;
373/*!40000 ALTER TABLE `imovel` DISABLE KEYS */;
374/*!40000 ALTER TABLE `imovel` ENABLE KEYS */;
375UNLOCK TABLES;
376
377--
378-- Table structure for table `pais`
379--
380
381DROP TABLE IF EXISTS `pais`;
382/*!40101 SET @saved_cs_client = @@character_set_client */;
383/*!40101 SET character_set_client = utf8 */;
384CREATE TABLE `pais` (
385 `id` tinyint(4) NOT NULL AUTO_INCREMENT,
386 `nome` varchar(50) NOT NULL,
387 PRIMARY KEY (`id`),
388 UNIQUE KEY `nome_UNIQUE` (`nome`)
389) ENGINE=InnoDB DEFAULT CHARSET=latin1;
390/*!40101 SET character_set_client = @saved_cs_client */;
391
392--
393-- Dumping data for table `pais`
394--
395
396LOCK TABLES `pais` WRITE;
397/*!40000 ALTER TABLE `pais` DISABLE KEYS */;
398/*!40000 ALTER TABLE `pais` ENABLE KEYS */;
399UNLOCK TABLES;
400
401--
402-- Table structure for table `tags`
403--
404
405DROP TABLE IF EXISTS `tags`;
406/*!40101 SET @saved_cs_client = @@character_set_client */;
407/*!40101 SET character_set_client = utf8 */;
408CREATE TABLE `tags` (
409 `id` int(4) NOT NULL AUTO_INCREMENT,
410 `nome` varchar(20) NOT NULL,
411 PRIMARY KEY (`id`),
412 UNIQUE KEY `nome_UNIQUE` (`nome`)
413) ENGINE=InnoDB DEFAULT CHARSET=latin1;
414/*!40101 SET character_set_client = @saved_cs_client */;
415
416--
417-- Dumping data for table `tags`
418--
419
420LOCK TABLES `tags` WRITE;
421/*!40000 ALTER TABLE `tags` DISABLE KEYS */;
422/*!40000 ALTER TABLE `tags` ENABLE KEYS */;
423UNLOCK TABLES;
424
425--
426-- Table structure for table `tagsimovel`
427--
428
429DROP TABLE IF EXISTS `tagsimovel`;
430/*!40101 SET @saved_cs_client = @@character_set_client */;
431/*!40101 SET character_set_client = utf8 */;
432CREATE TABLE `tagsimovel` (
433 `imovelId` int(4) NOT NULL,
434 `tagId` int(4) NOT NULL,
435 PRIMARY KEY (`imovelId`,`tagId`),
436 KEY `tagsImovel_tags` (`tagId`),
437 CONSTRAINT `tagsImovel_imovel` FOREIGN KEY (`imovelId`) REFERENCES `imovel` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
438 CONSTRAINT `tagsImovel_tags` FOREIGN KEY (`tagId`) REFERENCES `tags` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
439) ENGINE=InnoDB DEFAULT CHARSET=latin1;
440/*!40101 SET character_set_client = @saved_cs_client */;
441
442--
443-- Dumping data for table `tagsimovel`
444--
445
446LOCK TABLES `tagsimovel` WRITE;
447/*!40000 ALTER TABLE `tagsimovel` DISABLE KEYS */;
448/*!40000 ALTER TABLE `tagsimovel` ENABLE KEYS */;
449UNLOCK TABLES;
450
451--
452-- Table structure for table `tipoimovel`
453--
454
455DROP TABLE IF EXISTS `tipoimovel`;
456/*!40101 SET @saved_cs_client = @@character_set_client */;
457/*!40101 SET character_set_client = utf8 */;
458CREATE TABLE `tipoimovel` (
459 `id` tinyint(4) NOT NULL AUTO_INCREMENT,
460 `nome` varchar(15) NOT NULL,
461 PRIMARY KEY (`id`),
462 UNIQUE KEY `nome_UNIQUE` (`nome`)
463) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
464/*!40101 SET character_set_client = @saved_cs_client */;
465
466--
467-- Dumping data for table `tipoimovel`
468--
469
470LOCK TABLES `tipoimovel` WRITE;
471/*!40000 ALTER TABLE `tipoimovel` DISABLE KEYS */;
472INSERT INTO `tipoimovel` VALUES (1,'apartamento'),(2,'comercio'),(3,'moradia'),(4,'outros'),(5,'terreno');
473/*!40000 ALTER TABLE `tipoimovel` ENABLE KEYS */;
474UNLOCK TABLES;
475
476--
477-- Table structure for table `utilizador`
478--
479
480DROP TABLE IF EXISTS `utilizador`;
481/*!40101 SET @saved_cs_client = @@character_set_client */;
482/*!40101 SET character_set_client = utf8 */;
483CREATE TABLE `utilizador` (
484 `id` int(4) NOT NULL AUTO_INCREMENT,
485 `email` varchar(100) NOT NULL,
486 `telefone` varchar(16) NOT NULL,
487 `nome` varchar(30) NOT NULL,
488 `sobrenome` varchar(45) NOT NULL,
489 `imobiliariaId` int(4) NOT NULL,
490 PRIMARY KEY (`id`),
491 UNIQUE KEY `email_UNIQUE` (`email`),
492 KEY `utilizador_imobiliaria` (`imobiliariaId`),
493 CONSTRAINT `utilizador_imobiliaria` FOREIGN KEY (`imobiliariaId`) REFERENCES `imobiliaria` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
494) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
495/*!40101 SET character_set_client = @saved_cs_client */;
496
497--
498-- Dumping data for table `utilizador`
499--
500
501LOCK TABLES `utilizador` WRITE;
502/*!40000 ALTER TABLE `utilizador` DISABLE KEYS */;
503INSERT INTO `utilizador` VALUES (1,'rflpsz@gmail.com','19991234567','Rafael','Souza',1),(2,'filipemansano@gmail.com','19991234567','Filipe','Mansano',1),(3,'contato@mal.com.br','19991234567','Fulano','de Tal',3),(4,'contato@remax.com','19991234567','Ciclano','da Silva',4),(5,'contato@bpi.com','19991234567','Beltrano','de mello',5),(6,'contato@algumacoisa.com','19991234567','João','do Grão',6),(7,'contato@teste.com','19991234567','Harry','Potter',6),(8,'contato@oi.com.br','19991234567','Homem','de Ferro',8),(9,'contato@vida.com.br','19991234567','Thor','Trovão',9),(10,'homemdeferro@morrenofilme.com.br','19991234567','Maria','da Graça',10);
504/*!40000 ALTER TABLE `utilizador` ENABLE KEYS */;
505UNLOCK TABLES;
506/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
507
508/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
509/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
510/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
511/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
512/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
513/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
514/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
515
516-- Dump completed on 2019-05-16 21:18:14