· 8 years ago · May 05, 2018, 06:46 PM
1-- --------------------------------------------------------
2-- Host: 127.0.0.1
3-- Server version: 10.2.13-MariaDB - mariadb.org binary distribution
4-- Server OS: Win64
5-- HeidiSQL Version: 9.4.0.5125
6-- --------------------------------------------------------
7
8/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
9/*!40101 SET NAMES utf8 */;
10/*!50503 SET NAMES utf8mb4 */;
11/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
12/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
13
14
15-- Dumping database structure for mp5
16CREATE DATABASE IF NOT EXISTS `mp5` /*!40100 DEFAULT CHARACTER SET latin1 */;
17USE `mp5`;
18
19-- Dumping structure for table mp5.aluguer_carro
20CREATE TABLE IF NOT EXISTS `aluguer_carro` (
21 `id` int(11) NOT NULL AUTO_INCREMENT,
22 `id_carro` int(11) NOT NULL DEFAULT 0,
23 PRIMARY KEY (`id`),
24 KEY `id_carro` (`id_carro`),
25 CONSTRAINT `id_carro` FOREIGN KEY (`id_carro`) REFERENCES `carro` (`id`)
26) ENGINE=InnoDB DEFAULT CHARSET=latin1;
27
28-- Dumping data for table mp5.aluguer_carro: ~0 rows (approximately)
29/*!40000 ALTER TABLE `aluguer_carro` DISABLE KEYS */;
30/*!40000 ALTER TABLE `aluguer_carro` ENABLE KEYS */;
31
32-- Dumping structure for table mp5.carro
33CREATE TABLE IF NOT EXISTS `carro` (
34 `id` int(11) NOT NULL AUTO_INCREMENT,
35 `marca` varchar(50) DEFAULT '0',
36 `matricula` varchar(50) DEFAULT '0',
37 PRIMARY KEY (`id`)
38) ENGINE=InnoDB DEFAULT CHARSET=latin1;
39
40-- Dumping data for table mp5.carro: ~0 rows (approximately)
41/*!40000 ALTER TABLE `carro` DISABLE KEYS */;
42/*!40000 ALTER TABLE `carro` ENABLE KEYS */;
43
44-- Dumping structure for table mp5.comentarios
45CREATE TABLE IF NOT EXISTS `comentarios` (
46 `id` int(11) NOT NULL AUTO_INCREMENT,
47 `descricao` varchar(50) NOT NULL DEFAULT '0',
48 `tipo` varchar(50) DEFAULT NULL,
49 `id_tipo_comentario` int(11) DEFAULT NULL,
50 `id_utilizador` int(11) DEFAULT NULL,
51 `classificacao` int(11) DEFAULT NULL,
52 PRIMARY KEY (`id`),
53 KEY `id_utilizador` (`id_utilizador`),
54 CONSTRAINT `id_utilizador` FOREIGN KEY (`id_utilizador`) REFERENCES `utilizador` (`id`)
55) ENGINE=InnoDB DEFAULT CHARSET=latin1;
56
57-- Dumping data for table mp5.comentarios: ~0 rows (approximately)
58/*!40000 ALTER TABLE `comentarios` DISABLE KEYS */;
59/*!40000 ALTER TABLE `comentarios` ENABLE KEYS */;
60
61-- Dumping structure for table mp5.denuncias
62CREATE TABLE IF NOT EXISTS `denuncias` (
63 `id` int(11) NOT NULL AUTO_INCREMENT,
64 `descricao` varchar(50) NOT NULL DEFAULT '0',
65 `id_comentario` int(11) NOT NULL DEFAULT 0,
66 PRIMARY KEY (`id`),
67 KEY `id_comentario` (`id_comentario`),
68 CONSTRAINT `id_comentario` FOREIGN KEY (`id_comentario`) REFERENCES `comentarios` (`id`)
69) ENGINE=InnoDB DEFAULT CHARSET=latin1;
70
71-- Dumping data for table mp5.denuncias: ~0 rows (approximately)
72/*!40000 ALTER TABLE `denuncias` DISABLE KEYS */;
73/*!40000 ALTER TABLE `denuncias` ENABLE KEYS */;
74
75-- Dumping structure for table mp5.escala
76CREATE TABLE IF NOT EXISTS `escala` (
77 `id` int(11) NOT NULL AUTO_INCREMENT,
78 `id_pontoint` int(11) NOT NULL DEFAULT 0,
79 `id_hotel` int(11) NOT NULL DEFAULT 0,
80 `id_aluga_carro` int(11) NOT NULL DEFAULT 0,
81 PRIMARY KEY (`id`),
82 KEY `id_aluga_carro` (`id_aluga_carro`),
83 KEY `id_hotel` (`id_hotel`),
84 CONSTRAINT `id_aluga_carro` FOREIGN KEY (`id_aluga_carro`) REFERENCES `aluguer_carro` (`id`),
85 CONSTRAINT `id_hotel` FOREIGN KEY (`id_hotel`) REFERENCES `hotel` (`id`)
86) ENGINE=InnoDB DEFAULT CHARSET=latin1;
87
88-- Dumping data for table mp5.escala: ~0 rows (approximately)
89/*!40000 ALTER TABLE `escala` DISABLE KEYS */;
90/*!40000 ALTER TABLE `escala` ENABLE KEYS */;
91
92-- Dumping structure for table mp5.hotel
93CREATE TABLE IF NOT EXISTS `hotel` (
94 `id` int(11) NOT NULL AUTO_INCREMENT,
95 `nome` varchar(50) NOT NULL DEFAULT '0',
96 `preco` double NOT NULL DEFAULT 0,
97 PRIMARY KEY (`id`)
98) ENGINE=InnoDB DEFAULT CHARSET=latin1;
99
100-- Dumping data for table mp5.hotel: ~0 rows (approximately)
101/*!40000 ALTER TABLE `hotel` DISABLE KEYS */;
102/*!40000 ALTER TABLE `hotel` ENABLE KEYS */;
103
104-- Dumping structure for table mp5.ponto_de_interesse
105CREATE TABLE IF NOT EXISTS `ponto_de_interesse` (
106 `id` int(11) NOT NULL AUTO_INCREMENT,
107 `nome` varchar(50) NOT NULL DEFAULT '0',
108 `localizacao` varchar(50) NOT NULL DEFAULT '0',
109 PRIMARY KEY (`id`)
110) ENGINE=InnoDB DEFAULT CHARSET=latin1;
111
112-- Dumping data for table mp5.ponto_de_interesse: ~0 rows (approximately)
113/*!40000 ALTER TABLE `ponto_de_interesse` DISABLE KEYS */;
114/*!40000 ALTER TABLE `ponto_de_interesse` ENABLE KEYS */;
115
116-- Dumping structure for table mp5.utilizador
117CREATE TABLE `utilizador` (
118 `ID_utilizador` INT(11) NOT NULL AUTO_INCREMENT,
119 `Nome` VARCHAR(100) NOT NULL,
120 `Email` VARCHAR(100) NOT NULL,
121 PRIMARY KEY (`ID_utilizador`),
122 UNIQUE INDEX `Email` (`Email`)
123)
124COLLATE='latin1_swedish_ci'
125ENGINE=InnoDB
126;
127
128-- Dumping data for table mp5.utilizador: ~0 rows (approximately)
129/*!40000 ALTER TABLE `utilizador` DISABLE KEYS */;
130/*!40000 ALTER TABLE `utilizador` ENABLE KEYS */;
131
132-- Dumping structure for table mp5.viagem
133CREATE TABLE IF NOT EXISTS `viagem` (
134 `id` int(11) NOT NULL AUTO_INCREMENT,
135 `id_hotel` int(11) NOT NULL,
136 `id_percurso` int(11) NOT NULL,
137 `id_utilizador` int(11) NOT NULL,
138 PRIMARY KEY (`id`),
139 KEY `id_utilizador` (`id_utilizador`),
140 CONSTRAINT `viagem_ibfk_1` FOREIGN KEY (`id_utilizador`) REFERENCES `utilizador` (`id`)
141) ENGINE=InnoDB DEFAULT CHARSET=latin1;
142
143-- Dumping data for table mp5.viagem: ~0 rows (approximately)
144/*!40000 ALTER TABLE `viagem` DISABLE KEYS */;
145/*!40000 ALTER TABLE `viagem` ENABLE KEYS */;
146
147/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
148/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
149/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;