· 10 years ago · Sep 23, 2016, 02:14 PM
1# ************************************************************
2# Sequel Pro SQL dump
3# Version 4541
4#
5# http://www.sequelpro.com/
6# https://github.com/sequelpro/sequelpro
7#
8# Host: localhost (MySQL 5.6.28)
9# Database: diego_allure_cms
10# Generation Time: 2016-09-23 14:12:40 +0000
11# ************************************************************
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
19/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
20/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
21
22
23# Dump of table accommodation_types
24# ------------------------------------------------------------
25
26DROP TABLE IF EXISTS `accommodation_types`;
27
28CREATE TABLE `accommodation_types` (
29 `id` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
30 `type` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
31 `created` datetime NOT NULL,
32 `modified` datetime NOT NULL,
33 PRIMARY KEY (`id`)
34) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
35
36
37
38# Dump of table accommodations
39# ------------------------------------------------------------
40
41DROP TABLE IF EXISTS `accommodations`;
42
43CREATE TABLE `accommodations` (
44 `id` char(36) COLLATE utf8_unicode_ci NOT NULL,
45 `logo_id` int(11) DEFAULT NULL,
46 `accommodation_type_id` char(36) COLLATE utf8_unicode_ci DEFAULT NULL,
47 `category_id` char(36) COLLATE utf8_unicode_ci DEFAULT NULL,
48 `place` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
49 `room` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
50 `price` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
51 `datasheet` longtext COLLATE utf8_unicode_ci,
52 `active` tinyint(1) NOT NULL DEFAULT '1',
53 `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
54 `target_audience` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
55 `email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
56 `display_order` int(11) DEFAULT NULL,
57 `created` datetime NOT NULL,
58 `modified` datetime NOT NULL,
59 PRIMARY KEY (`id`),
60 UNIQUE KEY `UNIQ_BDD7A47FF98F144A` (`logo_id`),
61 KEY `IDX_BDD7A47FA9276E6C` (`accommodation_type_id`),
62 KEY `IDX_BDD7A47F3397707A` (`category_id`),
63 CONSTRAINT `accommodations_ibfk_1` FOREIGN KEY (`accommodation_type_id`) REFERENCES `accommodation_types` (`id`),
64 CONSTRAINT `accommodations_ibfk_2` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`)
65) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
66
67
68
69# Dump of table accommodations_turism_agencies
70# ------------------------------------------------------------
71
72DROP TABLE IF EXISTS `accommodations_turism_agencies`;
73
74CREATE TABLE `accommodations_turism_agencies` (
75 `id` char(36) COLLATE utf8_unicode_ci NOT NULL,
76 `accommodation_id` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
77 `turism_angency_id` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
78 `created` datetime NOT NULL,
79 `modified` datetime NOT NULL,
80 PRIMARY KEY (`id`),
81 KEY `accommodation_id` (`accommodation_id`),
82 KEY `turism_angency_id` (`turism_angency_id`),
83 CONSTRAINT `accommodations_turism_agencies_ibfk_2` FOREIGN KEY (`turism_angency_id`) REFERENCES `turism_agencies` (`id`),
84 CONSTRAINT `accommodations_turism_agencies_ibfk_3` FOREIGN KEY (`accommodation_id`) REFERENCES `accommodations` (`id`)
85) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
86
87
88
89# Dump of table artigo
90# ------------------------------------------------------------
91
92DROP TABLE IF EXISTS `artigo`;
93
94CREATE TABLE `artigo` (
95 `id` int(11) NOT NULL AUTO_INCREMENT,
96 `dataDeCriacao` datetime NOT NULL,
97 `titulo` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
98 `texto` longtext COLLATE utf8_unicode_ci,
99 `ativo` tinyint(1) NOT NULL DEFAULT '1',
100 `eventoInicio` datetime DEFAULT NULL,
101 `eventoFim` datetime DEFAULT NULL,
102 `subtitulo` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
103 `imagemDestaque_id` int(11) DEFAULT NULL,
104 `urlDestinoAlternativa` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
105 `ordem` int(11) DEFAULT NULL,
106 PRIMARY KEY (`id`),
107 UNIQUE KEY `UNIQ_A592883EA55D7A43` (`imagemDestaque_id`)
108) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
109
110
111
112# Dump of table artigo_categoria
113# ------------------------------------------------------------
114
115DROP TABLE IF EXISTS `artigo_categoria`;
116
117CREATE TABLE `artigo_categoria` (
118 `artigo_id` int(11) NOT NULL,
119 `categoria_id` int(11) NOT NULL,
120 PRIMARY KEY (`artigo_id`,`categoria_id`),
121 KEY `IDX_D00DECA9A5EFED24` (`artigo_id`),
122 KEY `IDX_D00DECA93397707A` (`categoria_id`)
123) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
124
125
126
127# Dump of table informations_blocks
128# ------------------------------------------------------------
129
130DROP TABLE IF EXISTS `informations_blocks`;
131
132CREATE TABLE `informations_blocks` (
133 `id` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
134 `imagem_id` int(11) DEFAULT NULL,
135 `accommodation_id` char(36) COLLATE utf8_unicode_ci DEFAULT NULL,
136 `title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
137 `display_order` int(11) NOT NULL DEFAULT '1',
138 `informations` longtext COLLATE utf8_unicode_ci,
139 PRIMARY KEY (`id`),
140 KEY `accommodation_id` (`accommodation_id`),
141 CONSTRAINT `informations_blocks_ibfk_1` FOREIGN KEY (`accommodation_id`) REFERENCES `accommodations` (`id`)
142) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
143
144
145
146# Dump of table cardapio
147# ------------------------------------------------------------
148
149DROP TABLE IF EXISTS `cardapio`;
150
151CREATE TABLE `cardapio` (
152 `id` int(11) NOT NULL AUTO_INCREMENT,
153 `cafe` longtext COLLATE utf8_unicode_ci,
154 `almoco` longtext COLLATE utf8_unicode_ci,
155 `drink` longtext COLLATE utf8_unicode_ci,
156 `janta` longtext COLLATE utf8_unicode_ci,
157 `fimDeNoite` longtext COLLATE utf8_unicode_ci,
158 PRIMARY KEY (`id`)
159) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
160
161
162
163# Dump of table categories
164# ------------------------------------------------------------
165
166DROP TABLE IF EXISTS `categories`;
167
168CREATE TABLE `categories` (
169 `id` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
170 `logo_id` int(11) DEFAULT NULL,
171 `category_type_id` char(36) COLLATE utf8_unicode_ci DEFAULT NULL,
172 `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
173 `content` longtext COLLATE utf8_unicode_ci,
174 `active` tinyint(1) NOT NULL DEFAULT '1',
175 `created` datetime NOT NULL,
176 `modified` datetime NOT NULL,
177 PRIMARY KEY (`id`),
178 UNIQUE KEY `UNIQ_CCE1908EF98F144A` (`logo_id`),
179 KEY `IDX_CCE1908E403F3784` (`category_type_id`)
180) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
181
182
183
184# Dump of table category_types
185# ------------------------------------------------------------
186
187DROP TABLE IF EXISTS `category_types`;
188
189CREATE TABLE `category_types` (
190 `id` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
191 `type` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
192 `created` datetime NOT NULL,
193 `modified` datetime DEFAULT NULL,
194 PRIMARY KEY (`id`)
195) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
196
197
198
199# Dump of table imagem
200# ------------------------------------------------------------
201
202DROP TABLE IF EXISTS `imagem`;
203
204CREATE TABLE `imagem` (
205 `id` int(11) NOT NULL AUTO_INCREMENT,
206 `categoria_id` int(11) DEFAULT NULL,
207 `hospedagem_id` int(11) DEFAULT NULL,
208 `artigo_id` int(11) DEFAULT NULL,
209 `caminho` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
210 `ordem` int(11) NOT NULL DEFAULT '0',
211 `imagem` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
212 `ativo` tinyint(1) NOT NULL DEFAULT '1',
213 `tipoImagem_id` int(11) DEFAULT NULL,
214 `titulo` varchar(255) COLLATE utf8_unicode_ci DEFAULT 'St. Barth',
215 PRIMARY KEY (`id`),
216 KEY `IDX_1A1083091E7DB843` (`tipoImagem_id`),
217 KEY `IDX_1A1083093397707A` (`categoria_id`),
218 KEY `IDX_1A108309EB30D47A` (`hospedagem_id`),
219 KEY `IDX_1A108309A5EFED24` (`artigo_id`)
220) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
221
222
223
224# Dump of table imagem_tipo
225# ------------------------------------------------------------
226
227DROP TABLE IF EXISTS `imagem_tipo`;
228
229CREATE TABLE `imagem_tipo` (
230 `id` int(11) NOT NULL AUTO_INCREMENT,
231 `tipo` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
232 PRIMARY KEY (`id`)
233) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
234
235
236
237# Dump of table newsletter
238# ------------------------------------------------------------
239
240DROP TABLE IF EXISTS `newsletter`;
241
242CREATE TABLE `newsletter` (
243 `id` int(11) NOT NULL AUTO_INCREMENT,
244 `email` varchar(80) NOT NULL,
245 PRIMARY KEY (`id`)
246) ENGINE=InnoDB DEFAULT CHARSET=utf8;
247
248
249
250# Dump of table roles
251# ------------------------------------------------------------
252
253DROP TABLE IF EXISTS `roles`;
254
255CREATE TABLE `roles` (
256 `id` char(36) COLLATE utf8_unicode_ci NOT NULL,
257 `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
258 `created` datetime NOT NULL,
259 `modified` datetime NOT NULL,
260 PRIMARY KEY (`id`),
261 UNIQUE KEY `name` (`name`)
262) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
263
264LOCK TABLES `roles` WRITE;
265/*!40000 ALTER TABLE `roles` DISABLE KEYS */;
266
267INSERT INTO `roles` (`id`, `name`, `created`, `modified`)
268VALUES
269 ('05aa863c-55ac-4c20-8d6e-a0c05ed3ccb1','Users','2016-09-22 13:27:24','2016-09-23 12:54:16'),
270 ('95d07fd0-f405-41bf-939f-70c5316ccd9c','Admin','2016-09-21 17:54:29','2016-09-23 12:43:59');
271
272/*!40000 ALTER TABLE `roles` ENABLE KEYS */;
273UNLOCK TABLES;
274
275
276# Dump of table seo
277# ------------------------------------------------------------
278
279DROP TABLE IF EXISTS `seo`;
280
281CREATE TABLE `seo` (
282 `id` int(11) NOT NULL AUTO_INCREMENT,
283 `title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
284 `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
285 `artigo_id` int(11) DEFAULT NULL,
286 `hospedagem_id` int(11) DEFAULT NULL,
287 `categoria_id` int(11) DEFAULT NULL,
288 PRIMARY KEY (`id`),
289 UNIQUE KEY `UNIQ_6C71EC30A5EFED24` (`artigo_id`),
290 UNIQUE KEY `UNIQ_6C71EC30EB30D47A` (`hospedagem_id`),
291 UNIQUE KEY `UNIQ_6C71EC303397707A` (`categoria_id`)
292) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
293
294
295
296# Dump of table turism_agencies
297# ------------------------------------------------------------
298
299DROP TABLE IF EXISTS `turism_agencies`;
300
301CREATE TABLE `turism_agencies` (
302 `id` char(36) COLLATE utf8_unicode_ci NOT NULL,
303 `logo_id` int(11) DEFAULT NULL,
304 `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
305 `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
306 `active` tinyint(1) NOT NULL DEFAULT '1',
307 PRIMARY KEY (`id`),
308 UNIQUE KEY `UNIQ_EB6C2B99F98F144A` (`logo_id`)
309) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
310
311
312
313# Dump of table users
314# ------------------------------------------------------------
315
316DROP TABLE IF EXISTS `users`;
317
318CREATE TABLE `users` (
319 `id` char(36) COLLATE utf8_unicode_ci NOT NULL,
320 `role_id` char(36) COLLATE utf8_unicode_ci NOT NULL,
321 `active` tinyint(1) NOT NULL DEFAULT '1',
322 `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
323 `username` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
324 `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
325 `password` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
326 `created` datetime NOT NULL,
327 `modified` datetime NOT NULL,
328 PRIMARY KEY (`id`),
329 UNIQUE KEY `username` (`username`),
330 UNIQUE KEY `email` (`email`),
331 KEY `role_id` (`role_id`),
332 CONSTRAINT `users_ibfk_1` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`)
333) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
334
335LOCK TABLES `users` WRITE;
336/*!40000 ALTER TABLE `users` DISABLE KEYS */;
337
338INSERT INTO `users` (`id`, `role_id`, `active`, `name`, `username`, `email`, `password`, `created`, `modified`)
339VALUES
340 ('7ea04019-90ae-4cd3-9631-18b56935ad80','95d07fd0-f405-41bf-939f-70c5316ccd9c',1,'Diego Andrade de Mendonça','diego182','diego182@gmail.com','$2y$10$XGGxzUCiDhEjmj0004sQYup6xAIHDNQKLfDthptd32PrUnpwiqkne','2016-09-23 12:07:04','2016-09-23 12:07:04');
341
342/*!40000 ALTER TABLE `users` ENABLE KEYS */;
343UNLOCK TABLES;
344
345
346# Dump of table video
347# ------------------------------------------------------------
348
349DROP TABLE IF EXISTS `video`;
350
351CREATE TABLE `video` (
352 `id` int(11) NOT NULL AUTO_INCREMENT,
353 `artigo_id` int(11) DEFAULT NULL,
354 `link` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
355 `ordem` int(11) NOT NULL DEFAULT '0',
356 `ativo` tinyint(1) NOT NULL DEFAULT '1',
357 PRIMARY KEY (`id`),
358 KEY `IDX_7CC7DA2CA5EFED24` (`artigo_id`)
359) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
360
361
362
363
364/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
365/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
366/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
367/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
368/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
369/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;