QeSWnvMZ

1-- Adminer 4.7.0 MySQL dump
2
3SET NAMES utf8;
4SET time_zone = '+00:00';
5SET foreign_key_checks = 0;
6SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
7
8CREATE DATABASE `cm_airpaz` /*!40100 DEFAULT CHARACTER SET latin1 */;
9USE `cm_airpaz`;
10
11SET NAMES utf8mb4;
12
13DROP TABLE IF EXISTS `action_events`;
14CREATE TABLE `action_events` (
15  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
16  `batch_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
17  `user_id` int(10) unsigned NOT NULL,
18  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
19  `actionable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
20  `actionable_id` int(10) unsigned NOT NULL,
21  `target_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
22  `target_id` int(10) unsigned NOT NULL,
23  `model_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
24  `model_id` int(10) unsigned DEFAULT NULL,
25  `fields` text COLLATE utf8mb4_unicode_ci NOT NULL,
26  `status` varchar(25) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'running',
27  `exception` text COLLATE utf8mb4_unicode_ci NOT NULL,
28  `created_at` timestamp NULL DEFAULT NULL,
29  `updated_at` timestamp NULL DEFAULT NULL,
30  PRIMARY KEY (`id`),
31  KEY `action_events_actionable_type_actionable_id_index` (`actionable_type`,`actionable_id`),
32  KEY `action_events_batch_id_model_type_model_id_index` (`batch_id`,`model_type`,`model_id`),
33  KEY `action_events_user_id_index` (`user_id`)
34) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
35
36
37DROP TABLE IF EXISTS `amenities`;
38CREATE TABLE `amenities` (
39  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
40  `created_at` timestamp NULL DEFAULT NULL,
41  `updated_at` timestamp NULL DEFAULT NULL,
42  PRIMARY KEY (`id`)
43) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
44
45
46DROP TABLE IF EXISTS `amenity_translations`;
47CREATE TABLE `amenity_translations` (
48  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
49  `amenity_id` int(10) unsigned NOT NULL,
50  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
51  `locale` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
52  `created_at` timestamp NULL DEFAULT NULL,
53  `updated_at` timestamp NULL DEFAULT NULL,
54  PRIMARY KEY (`id`),
55  UNIQUE KEY `amenity_translations_amenity_id_locale_unique` (`amenity_id`,`locale`),
56  KEY `amenity_translations_locale_index` (`locale`),
57  CONSTRAINT `amenity_translations_amenity_id_foreign` FOREIGN KEY (`amenity_id`) REFERENCES `amenities` (`id`) ON DELETE CASCADE
58) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
59
60
61DROP TABLE IF EXISTS `benefits`;
62CREATE TABLE `benefits` (
63  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
64  `created_at` timestamp NULL DEFAULT NULL,
65  `updated_at` timestamp NULL DEFAULT NULL,
66  PRIMARY KEY (`id`)
67) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
68
69INSERT INTO `benefits` (`id`, `created_at`, `updated_at`) VALUES
70(9,	'2019-03-21 10:21:50',	'2019-03-21 10:21:50'),
71(10,	'2019-03-21 10:22:13',	'2019-03-21 10:22:13'),
72(11,	'2019-03-21 10:35:37',	'2019-03-21 10:35:37'),
73(12,	'2019-03-21 10:40:40',	'2019-03-21 10:40:40');
74
75DROP TABLE IF EXISTS `benefit_translations`;
76CREATE TABLE `benefit_translations` (
77  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
78  `benefit_id` int(10) unsigned NOT NULL,
79  `language_id` int(11) DEFAULT NULL,
80  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
81  `locale` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
82  PRIMARY KEY (`id`),
83  KEY `benefit_translations_benefit_id_index` (`benefit_id`),
84  KEY `benefit_translations_locale_index` (`locale`),
85  CONSTRAINT `benefit_translations_benefit_id_foreign` FOREIGN KEY (`benefit_id`) REFERENCES `benefits` (`id`) ON DELETE CASCADE
86) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
87
88INSERT INTO `benefit_translations` (`id`, `benefit_id`, `language_id`, `name`, `locale`) VALUES
89(1,	9,	1,	'Breakfast without drink',	'en'),
90(2,	10,	1,	'Breakfast with exclusive orange juice',	'en'),
91(3,	10,	2,	'Sarapan dengan jus jeruk',	'id'),
92(4,	11,	1,	'Candle light dinner',	'en'),
93(5,	12,	1,	'Lunch',	'en'),
94(6,	12,	2,	'Zi Fan',	'id');
95
96DROP TABLE IF EXISTS `cancellation_policy`;
97CREATE TABLE `cancellation_policy` (
98  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
99  PRIMARY KEY (`id`)
100) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
101
102INSERT INTO `cancellation_policy` (`id`) VALUES
103(1),
104(2),
105(3),
106(4),
107(5),
108(6),
109(7),
110(8),
111(9),
112(10),
113(11),
114(12),
115(13),
116(14),
117(15),
118(16),
119(17),
120(18),
121(19),
122(20),
123(21),
124(22),
125(23),
126(24),
127(25),
128(26),
129(27),
130(28),
131(29),
132(30),
133(31),
134(32),
135(33),
136(34),
137(35),
138(36),
139(37),
140(38),
141(39),
142(40),
143(41),
144(42),
145(43),
146(44),
147(45),
148(46),
149(47),
150(48),
151(49),
152(50),
153(51),
154(52),
155(53),
156(54),
157(55),
158(56),
159(57),
160(58),
161(59),
162(60),
163(61),
164(62),
165(63),
166(64),
167(65),
168(66),
169(67),
170(68),
171(69),
172(70),
173(71),
174(72),
175(73),
176(74),
177(75),
178(76),
179(77),
180(78),
181(79),
182(80),
183(81),
184(82),
185(83),
186(84),
187(85),
188(86),
189(87),
190(88),
191(89),
192(90),
193(91),
194(92),
195(93),
196(94),
197(95),
198(96),
199(97),
200(98),
201(99),
202(100),
203(101),
204(102),
205(103),
206(104),
207(105),
208(106),
209(107),
210(108),
211(109),
212(110),
213(111),
214(112);
215
216DROP TABLE IF EXISTS `cancellation_policy_translations`;
217CREATE TABLE `cancellation_policy_translations` (
218  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
219  `cancellation_policy_id` int(10) unsigned NOT NULL,
220  `language_id` int(11) DEFAULT NULL,
221  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
222  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
223  `locale` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
224  PRIMARY KEY (`id`),
225  KEY `cancellation_policy_translations_cancellation_policy_id_index` (`cancellation_policy_id`),
226  KEY `cancellation_policy_translations_locale_index` (`locale`),
227  CONSTRAINT `cancellation_policy_translations_cancellation_policy_id_foreign` FOREIGN KEY (`cancellation_policy_id`) REFERENCES `cancellation_policy` (`id`) ON DELETE CASCADE
228) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
229
230INSERT INTO `cancellation_policy_translations` (`id`, `cancellation_policy_id`, `language_id`, `name`, `description`, `locale`) VALUES
231(1,	5,	1,	'Book before 3 days',	NULL,	'en'),
232(2,	6,	1,	'Book before 3 days',	NULL,	'en'),
233(3,	7,	1,	'Do not book on monday',	NULL,	'en'),
234(4,	8,	1,	'Do not book on monday',	NULL,	'en'),
235(5,	9,	1,	'Do not book on monday',	NULL,	'en'),
236(6,	10,	1,	'Do not book on monday',	NULL,	'en'),
237(7,	11,	1,	'Do not book pls',	NULL,	'en'),
238(8,	13,	1,	'Do not book pls',	NULL,	'en'),
239(9,	15,	1,	'DO NOT Book',	NULL,	'en'),
240(10,	16,	1,	'DO NOT Book',	NULL,	'en'),
241(11,	18,	1,	'DO NOT Book',	NULL,	'en'),
242(12,	20,	1,	'DO NOT Book',	NULL,	'en'),
243(13,	22,	1,	'DO NOT Book',	NULL,	'en'),
244(14,	23,	1,	'DO NOT Book',	NULL,	'en'),
245(15,	24,	1,	'DO NOT BOOK',	NULL,	'en'),
246(16,	37,	1,	'DO NOT BOOK',	NULL,	'en'),
247(17,	38,	1,	'DO NOT BOOK',	NULL,	'en'),
248(18,	40,	1,	'asdsa',	NULL,	'en'),
249(19,	41,	1,	'asdsa',	NULL,	'en'),
250(20,	42,	1,	'irvin',	NULL,	'en'),
251(21,	43,	1,	'PLS WORKING',	NULL,	'en'),
252(22,	48,	1,	'aaa',	NULL,	'en'),
253(23,	50,	1,	'aaa',	NULL,	'en'),
254(24,	51,	1,	'aaa',	NULL,	'en'),
255(25,	52,	1,	'aaa',	NULL,	'en'),
256(26,	55,	1,	'aaa',	NULL,	'en'),
257(27,	58,	1,	'aaa',	NULL,	'en'),
258(28,	59,	1,	'aaa',	NULL,	'en'),
259(29,	60,	1,	'aaa',	NULL,	'en'),
260(30,	61,	1,	'aaa',	NULL,	'en'),
261(32,	63,	1,	'aaa',	NULL,	'en'),
262(33,	64,	1,	'aaa',	NULL,	'en'),
263(34,	65,	1,	'aaa',	NULL,	'en'),
264(35,	66,	1,	'aaa',	NULL,	'en'),
265(36,	71,	1,	'testing',	NULL,	'en'),
266(37,	73,	1,	'testing',	NULL,	'en'),
267(38,	76,	1,	'testing',	NULL,	'en'),
268(39,	77,	1,	'testing',	NULL,	'en'),
269(40,	78,	1,	'testing',	NULL,	'en'),
270(41,	79,	1,	'testing',	NULL,	'en'),
271(42,	81,	1,	'sadsad',	NULL,	'en'),
272(43,	83,	1,	'sadsad',	NULL,	'en'),
273(44,	84,	1,	'sadsad',	NULL,	'en'),
274(45,	87,	1,	'sadasd',	NULL,	'en'),
275(46,	88,	1,	'sadasd',	NULL,	'en'),
276(47,	89,	1,	'sadasd',	NULL,	'en'),
277(48,	90,	1,	'irvin jefferson',	NULL,	'en'),
278(49,	91,	1,	'jefferson irvin',	NULL,	'en'),
279(50,	92,	1,	'tetsing 123',	NULL,	'en'),
280(51,	93,	1,	'abc',	NULL,	'en'),
281(65,	107,	1,	'adsa',	NULL,	'en'),
282(66,	108,	1,	'Irvin',	NULL,	'en'),
283(67,	108,	NULL,	'Jefferson',	NULL,	'ms'),
284(68,	109,	1,	'Do not throw trash',	NULL,	'en'),
285(69,	109,	NULL,	'Jangan buang sampah sembarangan',	NULL,	'id'),
286(70,	111,	1,	'Do not turn on light at night.',	NULL,	'en'),
287(71,	112,	1,	'Do not fight',	NULL,	'en');
288
289DROP TABLE IF EXISTS `chain_type`;
290CREATE TABLE `chain_type` (
291  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
292  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
293  `created_at` timestamp NULL DEFAULT NULL,
294  `updated_at` timestamp NULL DEFAULT NULL,
295  PRIMARY KEY (`id`)
296) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
297
298
299DROP TABLE IF EXISTS `destinations`;
300CREATE TABLE `destinations` (
301  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
302  `country_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
303  `state_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
304  `city_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
305  `area_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
306  `supplier_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
307  `DestinationCode` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
308  `created_at` timestamp NULL DEFAULT NULL,
309  `updated_at` timestamp NULL DEFAULT NULL,
310  PRIMARY KEY (`id`)
311) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
312
313
314DROP TABLE IF EXISTS `discount_apply_type`;
315CREATE TABLE `discount_apply_type` (
316  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
317  `name` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL,
318  PRIMARY KEY (`id`)
319) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
320
321INSERT INTO `discount_apply_type` (`id`, `name`) VALUES
322(1,	'Every Night'),
323(2,	'First Night'),
324(3,	'Spesific Day of Week');
325
326DROP TABLE IF EXISTS `discount_type`;
327CREATE TABLE `discount_type` (
328  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
329  `name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
330  PRIMARY KEY (`id`)
331) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
332
333INSERT INTO `discount_type` (`id`, `name`) VALUES
334(1,	'% Discount'),
335(2,	'USD Amount Discount ( Per Booking )'),
336(3,	'USD Amount Discount ( Per Night )'),
337(4,	'Free Night(s)');
338
339DROP TABLE IF EXISTS `facilities`;
340CREATE TABLE `facilities` (
341  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
342  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
343  `created_at` timestamp NULL DEFAULT NULL,
344  `updated_at` timestamp NULL DEFAULT NULL,
345  PRIMARY KEY (`id`)
346) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
347
348
349DROP TABLE IF EXISTS `features`;
350CREATE TABLE `features` (
351  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
352  `created_at` timestamp NULL DEFAULT NULL,
353  `updated_at` timestamp NULL DEFAULT NULL,
354  PRIMARY KEY (`id`)
355) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
356
357
358DROP TABLE IF EXISTS `feature_translations`;
359CREATE TABLE `feature_translations` (
360  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
361  `feature_id` int(10) unsigned NOT NULL,
362  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
363  `locale` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
364  `created_at` timestamp NULL DEFAULT NULL,
365  `updated_at` timestamp NULL DEFAULT NULL,
366  PRIMARY KEY (`id`),
367  UNIQUE KEY `feature_translations_feature_id_locale_unique` (`feature_id`,`locale`),
368  KEY `feature_translations_locale_index` (`locale`),
369  CONSTRAINT `feature_translations_feature_id_foreign` FOREIGN KEY (`feature_id`) REFERENCES `features` (`id`) ON DELETE CASCADE
370) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
371
372
373DROP TABLE IF EXISTS `hotels`;
374CREATE TABLE `hotels` (
375  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
376  `chain_id` int(10) unsigned DEFAULT NULL,
377  `country_id` int(10) unsigned DEFAULT NULL,
378  `city_id` int(10) unsigned DEFAULT NULL,
379  `district_id` int(10) unsigned DEFAULT NULL,
380  `hotel_type_id` int(10) unsigned DEFAULT NULL,
381  `zipcode` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
382  `infant_age` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
383  `children_age_from` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
384  `children_age_to` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
385  `children_stay_free` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
386  `min_guest_age` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
387  `extra_bed_required_from_age` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
388  `extra_bed_price` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
389  `sms_booking_notification_enabled` tinyint(4) DEFAULT NULL,
390  `unacknowledged_booking_email_enabled` tinyint(4) DEFAULT NULL,
391  `acknowledged_booking_email_enabled` tinyint(4) DEFAULT NULL,
392  `checkin_tomorrow` tinyint(4) DEFAULT NULL,
393  `is_hotel_data_verified` tinyint(4) NOT NULL DEFAULT '0',
394  `star_rating` double DEFAULT NULL,
395  `number_of_reviews` int(11) DEFAULT NULL,
396  `longitude` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
397  `latitude` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
398  `rating_average` double DEFAULT NULL,
399  `checkin_from` time DEFAULT NULL,
400  `checkin_to` time DEFAULT NULL,
401  `checkout_from` time DEFAULT NULL,
402  `checkout_to` time DEFAULT NULL,
403  `number_of_rooms` int(11) DEFAULT NULL,
404  `number_of_floors` int(11) DEFAULT NULL,
405  `state` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
406  `yearopened` int(11) DEFAULT NULL,
407  `yearrenovated` int(11) DEFAULT NULL,
408  `hotel_formerly_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
409  `max_persons_in_reservation` int(11) DEFAULT NULL,
410  `ranking` int(11) DEFAULT NULL,
411  `license_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
412  `is_closed` tinyint(1) DEFAULT NULL,
413  `creditcard_required` tinyint(1) DEFAULT NULL,
414  `class_is_estimated` tinyint(1) DEFAULT NULL,
415  `default_language` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
416  `deep_link_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
417  `preferred` int(11) DEFAULT NULL,
418  `currency` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
419  `class` int(11) DEFAULT NULL,
420  `exact_class` double DEFAULT NULL,
421  `book_domestic_without_cc_details` tinyint(1) DEFAULT NULL,
422  `max_rooms_in_reservation` int(11) DEFAULT NULL,
423  `review_score` double DEFAULT NULL,
424  `active` tinyint(4) NOT NULL DEFAULT '1',
425  `created_at` timestamp NULL DEFAULT NULL,
426  `updated_at` timestamp NULL DEFAULT NULL,
427  PRIMARY KEY (`id`),
428  KEY `hotels_chain_id_foreign` (`chain_id`),
429  KEY `hotels_country_id_foreign` (`country_id`),
430  KEY `hotels_city_id_foreign` (`city_id`),
431  KEY `hotels_district_id_foreign` (`district_id`),
432  KEY `hotels_hotel_type_id_foreign` (`hotel_type_id`),
433  CONSTRAINT `hotels_chain_id_foreign` FOREIGN KEY (`chain_id`) REFERENCES `hotel_chains` (`id`) ON DELETE CASCADE,
434  CONSTRAINT `hotels_city_id_foreign` FOREIGN KEY (`city_id`) REFERENCES `cm_master`.`cities` (`id`) ON DELETE CASCADE,
435  CONSTRAINT `hotels_country_id_foreign` FOREIGN KEY (`country_id`) REFERENCES `cm_master`.`countries` (`id`) ON DELETE CASCADE,
436  CONSTRAINT `hotels_district_id_foreign` FOREIGN KEY (`district_id`) REFERENCES `cm_master`.`districts` (`id`) ON DELETE CASCADE,
437  CONSTRAINT `hotels_hotel_type_id_foreign` FOREIGN KEY (`hotel_type_id`) REFERENCES `hotel_types` (`id`) ON DELETE CASCADE
438) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
439
440INSERT INTO `hotels` (`id`, `chain_id`, `country_id`, `city_id`, `district_id`, `hotel_type_id`, `zipcode`, `infant_age`, `children_age_from`, `children_age_to`, `children_stay_free`, `min_guest_age`, `extra_bed_required_from_age`, `extra_bed_price`, `sms_booking_notification_enabled`, `unacknowledged_booking_email_enabled`, `acknowledged_booking_email_enabled`, `checkin_tomorrow`, `is_hotel_data_verified`, `star_rating`, `number_of_reviews`, `longitude`, `latitude`, `rating_average`, `checkin_from`, `checkin_to`, `checkout_from`, `checkout_to`, `number_of_rooms`, `number_of_floors`, `state`, `yearopened`, `yearrenovated`, `hotel_formerly_name`, `max_persons_in_reservation`, `ranking`, `license_number`, `is_closed`, `creditcard_required`, `class_is_estimated`, `default_language`, `deep_link_url`, `preferred`, `currency`, `class`, `exact_class`, `book_domestic_without_cc_details`, `max_rooms_in_reservation`, `review_score`, `active`, `created_at`, `updated_at`) VALUES
441(1,	3,	100,	13978,	43,	NULL,	'14440',	'1',	'2',	'4',	'2',	'20',	'20',	'19000',	1,	1,	1,	NULL,	0,	4,	3,	'106.83139708984368',	'-6.221446059193316',	3,	'17:00:00',	'18:00:00',	'08:00:00',	'09:00:00',	7,	2,	'ID',	2013,	2015,	'Ibis',	8,	3,	'4345345345',	1,	1,	1,	'en',	NULL,	8,	'8',	6,	7,	1,	99,	NULL,	1,	'2019-03-01 09:48:57',	'2019-03-20 07:54:54'),
442(2,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	0,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	1,	'2019-03-19 16:10:34',	'2019-03-19 16:10:34');
443
444DROP TABLE IF EXISTS `hotel_address`;
445CREATE TABLE `hotel_address` (
446  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
447  `hotel_id` int(11) NOT NULL,
448  `language_id` int(11) NOT NULL,
449  `address` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
450  `created_at` timestamp NULL DEFAULT NULL,
451  `updated_at` timestamp NULL DEFAULT NULL,
452  PRIMARY KEY (`id`)
453) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
454
455INSERT INTO `hotel_address` (`id`, `hotel_id`, `language_id`, `address`, `created_at`, `updated_at`) VALUES
456(1,	1,	9,	'Ibis Hoteru 5555',	'2019-03-20 05:54:18',	'2019-03-20 07:54:54'),
457(2,	1,	1,	'Ibis',	'2019-03-20 05:54:18',	'2019-03-20 07:54:54');
458
459DROP TABLE IF EXISTS `hotel_chains`;
460CREATE TABLE `hotel_chains` (
461  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
462  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
463  `created_at` timestamp NULL DEFAULT NULL,
464  `updated_at` timestamp NULL DEFAULT NULL,
465  PRIMARY KEY (`id`)
466) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
467
468INSERT INTO `hotel_chains` (`id`, `name`, `created_at`, `updated_at`) VALUES
469(1,	'No chain',	'2019-03-05 06:28:16',	'2019-04-05 09:38:45'),
470(2,	'Accor Hotels',	'2019-03-05 06:28:21',	'2019-03-05 06:28:21'),
471(3,	'Ascott International',	'2019-03-05 06:28:29',	'2019-03-05 06:28:29'),
472(4,	'Banyan Tree Hotels & Resorts',	'2019-03-05 06:28:35',	'2019-03-05 06:28:35');
473
474DROP TABLE IF EXISTS `hotel_facilities`;
475CREATE TABLE `hotel_facilities` (
476  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
477  `hotel_facility_group_id` int(11) NOT NULL,
478  `created_at` timestamp NULL DEFAULT NULL,
479  `updated_at` timestamp NULL DEFAULT NULL,
480  PRIMARY KEY (`id`)
481) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
482
483INSERT INTO `hotel_facilities` (`id`, `hotel_facility_group_id`, `created_at`, `updated_at`) VALUES
484(1,	8,	'2019-03-27 06:52:51',	'2019-03-27 06:52:51'),
485(2,	9,	'2019-03-27 06:52:51',	'2019-03-27 06:52:51'),
486(3,	9,	'2019-03-27 06:52:51',	'2019-03-27 06:52:51'),
487(4,	15,	'2019-03-27 06:52:52',	'2019-03-27 06:52:52'),
488(5,	17,	'2019-03-27 06:52:52',	'2019-03-27 06:52:52'),
489(6,	11,	'2019-03-27 06:52:52',	'2019-03-27 06:52:52'),
490(7,	15,	'2019-03-27 06:52:52',	'2019-03-27 06:52:52'),
491(8,	16,	'2019-03-27 06:52:52',	'2019-03-27 06:52:52'),
492(9,	16,	'2019-03-27 06:52:52',	'2019-03-27 06:52:52'),
493(10,	2,	'2019-03-27 06:52:53',	'2019-03-27 06:52:53'),
494(11,	6,	'2019-03-27 06:52:53',	'2019-03-27 06:52:53'),
495(12,	22,	'2019-03-27 06:52:53',	'2019-03-27 06:52:53'),
496(13,	16,	'2019-03-27 06:52:53',	'2019-03-27 06:52:53'),
497(14,	2,	'2019-03-27 06:52:53',	'2019-03-27 06:52:53'),
498(15,	5,	'2019-03-27 06:52:53',	'2019-03-27 06:52:53'),
499(16,	17,	'2019-03-27 06:52:53',	'2019-03-27 06:52:53'),
500(17,	6,	'2019-03-27 06:52:54',	'2019-03-27 06:52:54'),
501(18,	9,	'2019-03-27 06:52:54',	'2019-03-27 06:52:54'),
502(19,	17,	'2019-03-27 06:52:54',	'2019-03-27 06:52:54'),
503(20,	6,	'2019-03-27 06:52:54',	'2019-03-27 06:52:54'),
504(21,	2,	'2019-03-27 06:52:54',	'2019-03-27 06:52:54'),
505(22,	2,	'2019-03-27 06:52:55',	'2019-03-27 06:52:55'),
506(23,	16,	'2019-03-27 06:52:55',	'2019-03-27 06:52:55'),
507(24,	2,	'2019-03-27 06:52:55',	'2019-03-27 06:52:55'),
508(25,	8,	'2019-03-27 06:52:55',	'2019-03-27 06:52:55'),
509(26,	2,	'2019-03-27 06:52:55',	'2019-03-27 06:52:55'),
510(27,	13,	'2019-03-27 06:52:55',	'2019-03-27 06:52:55'),
511(28,	5,	'2019-03-27 06:52:56',	'2019-03-27 06:52:56'),
512(29,	15,	'2019-03-27 06:52:56',	'2019-03-27 06:52:56'),
513(30,	15,	'2019-03-27 06:52:56',	'2019-03-27 06:52:56'),
514(31,	2,	'2019-03-27 06:52:56',	'2019-03-27 06:52:56'),
515(32,	2,	'2019-03-27 06:52:57',	'2019-03-27 06:52:57'),
516(33,	2,	'2019-03-27 06:52:57',	'2019-03-27 06:52:57'),
517(34,	11,	'2019-03-27 06:52:57',	'2019-03-27 06:52:57'),
518(35,	9,	'2019-03-27 06:52:57',	'2019-03-27 06:52:57'),
519(36,	4,	'2019-03-27 06:52:57',	'2019-03-27 06:52:57'),
520(37,	17,	'2019-03-27 06:52:57',	'2019-03-27 06:52:57'),
521(38,	16,	'2019-03-27 06:52:57',	'2019-03-27 06:52:57'),
522(39,	17,	'2019-03-27 06:52:58',	'2019-03-27 06:52:58'),
523(40,	6,	'2019-03-27 06:52:58',	'2019-03-27 06:52:58'),
524(41,	15,	'2019-03-27 06:52:58',	'2019-03-27 06:52:58'),
525(42,	22,	'2019-03-27 06:52:58',	'2019-03-27 06:52:58'),
526(43,	4,	'2019-03-27 06:52:59',	'2019-03-27 06:52:59'),
527(44,	8,	'2019-03-27 06:52:59',	'2019-03-27 06:52:59'),
528(45,	5,	'2019-03-27 06:53:00',	'2019-03-27 06:53:00'),
529(46,	11,	'2019-03-27 06:53:00',	'2019-03-27 06:53:00'),
530(47,	20,	'2019-03-27 06:53:00',	'2019-03-27 06:53:00'),
531(48,	15,	'2019-03-27 06:53:00',	'2019-03-27 06:53:00'),
532(49,	6,	'2019-03-27 06:53:00',	'2019-03-27 06:53:00'),
533(50,	15,	'2019-03-27 06:53:01',	'2019-03-27 06:53:01'),
534(51,	9,	'2019-03-27 06:53:01',	'2019-03-27 06:53:01'),
535(52,	5,	'2019-03-27 06:53:01',	'2019-03-27 06:53:01'),
536(53,	15,	'2019-03-27 06:53:01',	'2019-03-27 06:53:01'),
537(54,	11,	'2019-03-27 06:53:01',	'2019-03-27 06:53:01'),
538(55,	18,	'2019-03-27 06:53:01',	'2019-03-27 06:53:01'),
539(56,	15,	'2019-03-27 06:53:01',	'2019-03-27 06:53:01'),
540(57,	17,	'2019-03-27 06:53:02',	'2019-03-27 06:53:02'),
541(58,	17,	'2019-03-27 06:53:02',	'2019-03-27 06:53:02'),
542(59,	16,	'2019-03-27 06:53:02',	'2019-03-27 06:53:02'),
543(60,	8,	'2019-03-27 06:53:02',	'2019-03-27 06:53:02'),
544(61,	2,	'2019-03-27 06:53:02',	'2019-03-27 06:53:02'),
545(62,	20,	'2019-03-27 06:53:02',	'2019-03-27 06:53:02'),
546(63,	2,	'2019-03-27 06:53:03',	'2019-03-27 06:53:03'),
547(64,	2,	'2019-03-27 06:53:03',	'2019-03-27 06:53:03'),
548(65,	16,	'2019-03-27 06:53:03',	'2019-03-27 06:53:03'),
549(66,	15,	'2019-03-27 06:53:03',	'2019-03-27 06:53:03'),
550(67,	22,	'2019-03-27 06:53:03',	'2019-03-27 06:53:03'),
551(68,	5,	'2019-03-27 06:53:04',	'2019-03-27 06:53:04'),
552(69,	6,	'2019-03-27 06:53:04',	'2019-03-27 06:53:04'),
553(70,	9,	'2019-03-27 06:53:04',	'2019-03-27 06:53:04'),
554(71,	22,	'2019-03-27 06:53:04',	'2019-03-27 06:53:04'),
555(72,	2,	'2019-03-27 06:53:04',	'2019-03-27 06:53:04'),
556(73,	2,	'2019-03-27 06:53:04',	'2019-03-27 06:53:04'),
557(74,	17,	'2019-03-27 06:53:04',	'2019-03-27 06:53:04'),
558(75,	16,	'2019-03-27 06:53:05',	'2019-03-27 06:53:05'),
559(76,	4,	'2019-03-27 06:53:05',	'2019-03-27 06:53:05'),
560(77,	2,	'2019-03-27 06:53:05',	'2019-03-27 06:53:05'),
561(78,	2,	'2019-03-27 06:53:05',	'2019-03-27 06:53:05'),
562(79,	17,	'2019-03-27 06:53:05',	'2019-03-27 06:53:05'),
563(80,	2,	'2019-03-27 06:53:06',	'2019-03-27 06:53:06'),
564(81,	20,	'2019-03-27 06:53:06',	'2019-03-27 06:53:06'),
565(82,	18,	'2019-03-27 06:53:06',	'2019-03-27 06:53:06'),
566(83,	2,	'2019-03-27 06:53:06',	'2019-03-27 06:53:06'),
567(84,	2,	'2019-03-27 06:53:07',	'2019-03-27 06:53:07'),
568(85,	2,	'2019-03-27 06:53:07',	'2019-03-27 06:53:07'),
569(86,	15,	'2019-03-27 06:53:08',	'2019-03-27 06:53:08'),
570(87,	16,	'2019-03-27 06:53:08',	'2019-03-27 06:53:08'),
571(88,	16,	'2019-03-27 06:53:08',	'2019-03-27 06:53:08'),
572(89,	18,	'2019-03-27 06:53:08',	'2019-03-27 06:53:08'),
573(90,	15,	'2019-03-27 06:53:08',	'2019-03-27 06:53:08'),
574(91,	15,	'2019-03-27 06:53:08',	'2019-03-27 06:53:08'),
575(92,	17,	'2019-03-27 06:53:09',	'2019-03-27 06:53:09'),
576(93,	16,	'2019-03-27 06:53:09',	'2019-03-27 06:53:09'),
577(94,	9,	'2019-03-27 06:53:09',	'2019-03-27 06:53:09'),
578(95,	9,	'2019-03-27 06:53:09',	'2019-03-27 06:53:09'),
579(96,	9,	'2019-03-27 06:53:09',	'2019-03-27 06:53:09'),
580(97,	6,	'2019-03-27 06:53:09',	'2019-03-27 06:53:09'),
581(98,	16,	'2019-03-27 06:53:10',	'2019-03-27 06:53:10'),
582(99,	16,	'2019-03-27 06:53:10',	'2019-03-27 06:53:10'),
583(100,	16,	'2019-03-27 06:53:10',	'2019-03-27 06:53:10'),
584(101,	16,	'2019-03-27 06:53:10',	'2019-03-27 06:53:10'),
585(102,	22,	'2019-03-27 06:53:10',	'2019-03-27 06:53:10'),
586(103,	17,	'2019-03-27 06:53:10',	'2019-03-27 06:53:10'),
587(104,	8,	'2019-03-27 06:53:11',	'2019-03-27 06:53:11'),
588(105,	8,	'2019-03-27 06:53:11',	'2019-03-27 06:53:11'),
589(106,	17,	'2019-03-27 06:53:11',	'2019-03-27 06:53:11'),
590(107,	22,	'2019-03-27 06:53:11',	'2019-03-27 06:53:11'),
591(108,	22,	'2019-03-27 06:53:11',	'2019-03-27 06:53:11'),
592(109,	2,	'2019-03-27 06:53:12',	'2019-03-27 06:53:12'),
593(110,	2,	'2019-03-27 06:53:12',	'2019-03-27 06:53:12'),
594(111,	2,	'2019-03-27 06:53:12',	'2019-03-27 06:53:12'),
595(112,	9,	'2019-03-27 06:53:12',	'2019-03-27 06:53:12'),
596(113,	9,	'2019-03-27 06:53:12',	'2019-03-27 06:53:12'),
597(114,	9,	'2019-03-27 06:53:12',	'2019-03-27 06:53:12'),
598(115,	2,	'2019-03-27 06:53:12',	'2019-03-27 06:53:12'),
599(116,	22,	'2019-03-27 06:53:13',	'2019-03-27 06:53:13'),
600(117,	22,	'2019-03-27 06:53:13',	'2019-03-27 06:53:13'),
601(118,	17,	'2019-03-27 06:53:13',	'2019-03-27 06:53:13'),
602(119,	6,	'2019-03-27 06:53:13',	'2019-03-27 06:53:13'),
603(120,	8,	'2019-03-27 06:53:13',	'2019-03-27 06:53:13'),
604(121,	20,	'2019-03-27 06:53:13',	'2019-03-27 06:53:13'),
605(122,	16,	'2019-03-27 06:53:14',	'2019-03-27 06:53:14'),
606(123,	8,	'2019-03-27 06:53:14',	'2019-03-27 06:53:14'),
607(124,	15,	'2019-03-27 06:53:14',	'2019-03-27 06:53:14'),
608(125,	5,	'2019-03-27 06:53:14',	'2019-03-27 06:53:14'),
609(126,	9,	'2019-03-27 06:53:14',	'2019-03-27 06:53:14'),
610(127,	11,	'2019-03-27 06:53:15',	'2019-03-27 06:53:15'),
611(128,	11,	'2019-03-27 06:53:15',	'2019-03-27 06:53:15'),
612(129,	11,	'2019-03-27 06:53:15',	'2019-03-27 06:53:15'),
613(130,	11,	'2019-03-27 06:53:15',	'2019-03-27 06:53:15'),
614(131,	11,	'2019-03-27 06:53:15',	'2019-03-27 06:53:15'),
615(132,	16,	'2019-03-27 06:53:15',	'2019-03-27 06:53:15'),
616(133,	16,	'2019-03-27 06:53:15',	'2019-03-27 06:53:15'),
617(134,	16,	'2019-03-27 06:53:16',	'2019-03-27 06:53:16'),
618(135,	16,	'2019-03-27 06:53:16',	'2019-03-27 06:53:16'),
619(136,	8,	'2019-03-27 06:53:16',	'2019-03-27 06:53:16'),
620(137,	8,	'2019-03-27 06:53:16',	'2019-03-27 06:53:16'),
621(138,	8,	'2019-03-27 06:53:16',	'2019-03-27 06:53:16'),
622(139,	8,	'2019-03-27 06:53:16',	'2019-03-27 06:53:16'),
623(140,	8,	'2019-03-27 06:53:16',	'2019-03-27 06:53:16'),
624(141,	8,	'2019-03-27 06:53:17',	'2019-03-27 06:53:17'),
625(142,	9,	'2019-03-27 06:53:17',	'2019-03-27 06:53:17'),
626(143,	9,	'2019-03-27 06:53:17',	'2019-03-27 06:53:17'),
627(144,	22,	'2019-03-27 06:53:17',	'2019-03-27 06:53:17'),
628(145,	22,	'2019-03-27 06:53:17',	'2019-03-27 06:53:17'),
629(146,	22,	'2019-03-27 06:53:17',	'2019-03-27 06:53:17'),
630(147,	22,	'2019-03-27 06:53:18',	'2019-03-27 06:53:18'),
631(148,	22,	'2019-03-27 06:53:18',	'2019-03-27 06:53:18'),
632(149,	22,	'2019-03-27 06:53:18',	'2019-03-27 06:53:18'),
633(150,	15,	'2019-03-27 06:53:18',	'2019-03-27 06:53:18'),
634(151,	15,	'2019-03-27 06:53:18',	'2019-03-27 06:53:18'),
635(152,	15,	'2019-03-27 06:53:18',	'2019-03-27 06:53:18'),
636(153,	15,	'2019-03-27 06:53:19',	'2019-03-27 06:53:19'),
637(154,	16,	'2019-03-27 06:53:19',	'2019-03-27 06:53:19'),
638(155,	16,	'2019-03-27 06:53:19',	'2019-03-27 06:53:19'),
639(156,	16,	'2019-03-27 06:53:19',	'2019-03-27 06:53:19'),
640(157,	16,	'2019-03-27 06:53:19',	'2019-03-27 06:53:19'),
641(158,	16,	'2019-03-27 06:53:19',	'2019-03-27 06:53:19'),
642(159,	16,	'2019-03-27 06:53:19',	'2019-03-27 06:53:19'),
643(160,	16,	'2019-03-27 06:53:20',	'2019-03-27 06:53:20'),
644(161,	16,	'2019-03-27 06:53:20',	'2019-03-27 06:53:20'),
645(162,	16,	'2019-03-27 06:53:20',	'2019-03-27 06:53:20'),
646(163,	16,	'2019-03-27 06:53:20',	'2019-03-27 06:53:20'),
647(164,	9,	'2019-03-27 06:53:20',	'2019-03-27 06:53:20'),
648(165,	9,	'2019-03-27 06:53:20',	'2019-03-27 06:53:20'),
649(166,	9,	'2019-03-27 06:53:20',	'2019-03-27 06:53:20'),
650(167,	9,	'2019-03-27 06:53:21',	'2019-03-27 06:53:21'),
651(168,	17,	'2019-03-27 06:53:21',	'2019-03-27 06:53:21'),
652(169,	22,	'2019-03-27 06:53:21',	'2019-03-27 06:53:21'),
653(170,	22,	'2019-03-27 06:53:21',	'2019-03-27 06:53:21'),
654(171,	15,	'2019-03-27 06:53:21',	'2019-03-27 06:53:21'),
655(172,	15,	'2019-03-27 06:53:21',	'2019-03-27 06:53:21'),
656(173,	15,	'2019-03-27 06:53:21',	'2019-03-27 06:53:21'),
657(174,	8,	'2019-03-27 06:53:22',	'2019-03-27 06:53:22'),
658(175,	2,	'2019-03-27 06:53:22',	'2019-03-27 06:53:22'),
659(176,	2,	'2019-03-27 06:53:22',	'2019-03-27 06:53:22'),
660(177,	15,	'2019-03-27 06:53:22',	'2019-03-27 06:53:22'),
661(178,	15,	'2019-03-27 06:53:23',	'2019-03-27 06:53:23'),
662(179,	9,	'2019-03-27 06:53:23',	'2019-03-27 06:53:23'),
663(180,	16,	'2019-03-27 06:53:23',	'2019-03-27 06:53:23'),
664(181,	16,	'2019-03-27 06:53:24',	'2019-03-27 06:53:24'),
665(182,	6,	'2019-03-27 06:53:24',	'2019-03-27 06:53:24'),
666(183,	16,	'2019-03-27 06:53:24',	'2019-03-27 06:53:24'),
667(184,	6,	'2019-03-27 06:53:25',	'2019-03-27 06:53:25'),
668(185,	6,	'2019-03-27 06:53:25',	'2019-03-27 06:53:25'),
669(186,	16,	'2019-03-27 06:53:25',	'2019-03-27 06:53:25'),
670(187,	16,	'2019-03-27 06:53:25',	'2019-03-27 06:53:25'),
671(188,	16,	'2019-03-27 06:53:26',	'2019-03-27 06:53:26'),
672(189,	16,	'2019-03-27 06:53:26',	'2019-03-27 06:53:26'),
673(190,	16,	'2019-03-27 06:53:26',	'2019-03-27 06:53:26'),
674(191,	16,	'2019-03-27 06:53:26',	'2019-03-27 06:53:26'),
675(192,	16,	'2019-03-27 06:53:26',	'2019-03-27 06:53:26'),
676(193,	16,	'2019-03-27 06:53:26',	'2019-03-27 06:53:26'),
677(194,	16,	'2019-03-27 06:53:27',	'2019-03-27 06:53:27'),
678(195,	16,	'2019-03-27 06:53:27',	'2019-03-27 06:53:27'),
679(196,	16,	'2019-03-27 06:53:27',	'2019-03-27 06:53:27'),
680(197,	16,	'2019-03-27 06:53:27',	'2019-03-27 06:53:27'),
681(198,	16,	'2019-03-27 06:53:28',	'2019-03-27 06:53:28'),
682(199,	16,	'2019-03-27 06:53:28',	'2019-03-27 06:53:28'),
683(200,	16,	'2019-03-27 06:53:28',	'2019-03-27 06:53:28'),
684(201,	16,	'2019-03-27 06:53:28',	'2019-03-27 06:53:28'),
685(202,	16,	'2019-03-27 06:53:28',	'2019-03-27 06:53:28'),
686(203,	16,	'2019-03-27 06:53:28',	'2019-03-27 06:53:28'),
687(204,	16,	'2019-03-27 06:53:29',	'2019-03-27 06:53:29'),
688(205,	16,	'2019-03-27 06:53:29',	'2019-03-27 06:53:29'),
689(206,	16,	'2019-03-27 06:53:29',	'2019-03-27 06:53:29'),
690(207,	16,	'2019-03-27 06:53:29',	'2019-03-27 06:53:29'),
691(208,	16,	'2019-03-27 06:53:29',	'2019-03-27 06:53:29'),
692(209,	16,	'2019-03-27 06:53:29',	'2019-03-27 06:53:29'),
693(210,	16,	'2019-03-27 06:53:30',	'2019-03-27 06:53:30'),
694(211,	16,	'2019-03-27 06:53:30',	'2019-03-27 06:53:30'),
695(212,	16,	'2019-03-27 06:53:30',	'2019-03-27 06:53:30'),
696(213,	16,	'2019-03-27 06:53:30',	'2019-03-27 06:53:30'),
697(214,	16,	'2019-03-27 06:53:30',	'2019-03-27 06:53:30'),
698(215,	16,	'2019-03-27 06:53:30',	'2019-03-27 06:53:30'),
699(216,	16,	'2019-03-27 06:53:31',	'2019-03-27 06:53:31'),
700(217,	16,	'2019-03-27 06:53:31',	'2019-03-27 06:53:31'),
701(218,	16,	'2019-03-27 06:53:31',	'2019-03-27 06:53:31'),
702(219,	16,	'2019-03-27 06:53:31',	'2019-03-27 06:53:31'),
703(220,	2,	'2019-03-27 06:53:31',	'2019-03-27 06:53:31'),
704(221,	22,	'2019-03-27 06:53:31',	'2019-03-27 06:53:31'),
705(222,	9,	'2019-03-27 06:53:32',	'2019-03-27 06:53:32'),
706(223,	2,	'2019-03-27 06:53:32',	'2019-03-27 06:53:32'),
707(224,	2,	'2019-03-27 06:53:32',	'2019-03-27 06:53:32'),
708(225,	2,	'2019-03-27 06:53:32',	'2019-03-27 06:53:32'),
709(226,	2,	'2019-03-27 06:53:32',	'2019-03-27 06:53:32'),
710(227,	2,	'2019-03-27 06:53:33',	'2019-03-27 06:53:33'),
711(228,	2,	'2019-03-27 06:53:33',	'2019-03-27 06:53:33'),
712(229,	2,	'2019-03-27 06:53:33',	'2019-03-27 06:53:33'),
713(230,	2,	'2019-03-27 06:53:33',	'2019-03-27 06:53:33'),
714(231,	2,	'2019-03-27 06:53:33',	'2019-03-27 06:53:33'),
715(232,	2,	'2019-03-27 06:53:33',	'2019-03-27 06:53:33'),
716(233,	2,	'2019-03-27 06:53:34',	'2019-03-27 06:53:34'),
717(234,	2,	'2019-03-27 06:53:34',	'2019-03-27 06:53:34'),
718(235,	2,	'2019-03-27 06:53:34',	'2019-03-27 06:53:34'),
719(236,	2,	'2019-03-27 06:53:34',	'2019-03-27 06:53:34'),
720(237,	2,	'2019-03-27 06:53:34',	'2019-03-27 06:53:34'),
721(238,	15,	'2019-03-27 06:53:34',	'2019-03-27 06:53:34'),
722(239,	15,	'2019-03-27 06:53:34',	'2019-03-27 06:53:34'),
723(240,	15,	'2019-03-27 06:53:35',	'2019-03-27 06:53:35'),
724(241,	15,	'2019-03-27 06:53:35',	'2019-03-27 06:53:35'),
725(242,	15,	'2019-03-27 06:53:35',	'2019-03-27 06:53:35'),
726(243,	15,	'2019-03-27 06:53:35',	'2019-03-27 06:53:35'),
727(244,	15,	'2019-03-27 06:53:35',	'2019-03-27 06:53:35'),
728(245,	15,	'2019-03-27 06:53:35',	'2019-03-27 06:53:35'),
729(246,	13,	'2019-03-27 06:53:36',	'2019-03-27 06:53:36'),
730(247,	13,	'2019-03-27 06:53:36',	'2019-03-27 06:53:36'),
731(248,	13,	'2019-03-27 06:53:36',	'2019-03-27 06:53:36'),
732(249,	22,	'2019-03-27 06:53:36',	'2019-03-27 06:53:36'),
733(250,	7,	'2019-03-27 06:53:36',	'2019-03-27 06:53:36'),
734(251,	19,	'2019-03-27 06:53:36',	'2019-03-27 06:53:36'),
735(252,	3,	'2019-03-27 06:53:36',	'2019-03-27 06:53:36'),
736(253,	3,	'2019-03-27 06:53:37',	'2019-03-27 06:53:37'),
737(254,	3,	'2019-03-27 06:53:37',	'2019-03-27 06:53:37'),
738(255,	3,	'2019-03-27 06:53:37',	'2019-03-27 06:53:37'),
739(256,	3,	'2019-03-27 06:53:37',	'2019-03-27 06:53:37'),
740(257,	3,	'2019-03-27 06:53:37',	'2019-03-27 06:53:37'),
741(258,	3,	'2019-03-27 06:53:37',	'2019-03-27 06:53:37'),
742(259,	3,	'2019-03-27 06:53:38',	'2019-03-27 06:53:38'),
743(260,	3,	'2019-03-27 06:53:38',	'2019-03-27 06:53:38'),
744(261,	3,	'2019-03-27 06:53:38',	'2019-03-27 06:53:38'),
745(262,	3,	'2019-03-27 06:53:38',	'2019-03-27 06:53:38'),
746(263,	3,	'2019-03-27 06:53:38',	'2019-03-27 06:53:38'),
747(264,	3,	'2019-03-27 06:53:38',	'2019-03-27 06:53:38'),
748(265,	3,	'2019-03-27 06:53:38',	'2019-03-27 06:53:38'),
749(266,	3,	'2019-03-27 06:53:39',	'2019-03-27 06:53:39'),
750(267,	3,	'2019-03-27 06:53:39',	'2019-03-27 06:53:39'),
751(268,	3,	'2019-03-27 06:53:39',	'2019-03-27 06:53:39'),
752(269,	3,	'2019-03-27 06:53:39',	'2019-03-27 06:53:39'),
753(270,	3,	'2019-03-27 06:53:40',	'2019-03-27 06:53:40'),
754(271,	21,	'2019-03-27 06:53:40',	'2019-03-27 06:53:40'),
755(272,	3,	'2019-03-27 06:53:40',	'2019-03-27 06:53:40'),
756(273,	3,	'2019-03-27 06:53:40',	'2019-03-27 06:53:40'),
757(274,	3,	'2019-03-27 06:53:40',	'2019-03-27 06:53:40'),
758(275,	3,	'2019-03-27 06:53:40',	'2019-03-27 06:53:40'),
759(276,	3,	'2019-03-27 06:53:41',	'2019-03-27 06:53:41'),
760(277,	3,	'2019-03-27 06:53:41',	'2019-03-27 06:53:41'),
761(278,	3,	'2019-03-27 06:53:41',	'2019-03-27 06:53:41'),
762(279,	3,	'2019-03-27 06:53:41',	'2019-03-27 06:53:41'),
763(280,	3,	'2019-03-27 06:53:41',	'2019-03-27 06:53:41'),
764(281,	3,	'2019-03-27 06:53:41',	'2019-03-27 06:53:41'),
765(282,	14,	'2019-03-27 06:53:42',	'2019-03-27 06:53:42'),
766(283,	19,	'2019-03-27 06:53:42',	'2019-03-27 06:53:42'),
767(284,	3,	'2019-03-27 06:53:42',	'2019-03-27 06:53:42'),
768(285,	3,	'2019-03-27 06:53:42',	'2019-03-27 06:53:42'),
769(286,	3,	'2019-03-27 06:53:44',	'2019-03-27 06:53:44'),
770(287,	3,	'2019-03-27 06:53:44',	'2019-03-27 06:53:44'),
771(288,	3,	'2019-03-27 06:53:44',	'2019-03-27 06:53:44'),
772(289,	3,	'2019-03-27 06:53:44',	'2019-03-27 06:53:44'),
773(290,	3,	'2019-03-27 06:53:44',	'2019-03-27 06:53:44'),
774(291,	3,	'2019-03-27 06:53:45',	'2019-03-27 06:53:45'),
775(292,	3,	'2019-03-27 06:53:45',	'2019-03-27 06:53:45'),
776(293,	3,	'2019-03-27 06:53:45',	'2019-03-27 06:53:45'),
777(294,	3,	'2019-03-27 06:53:45',	'2019-03-27 06:53:45'),
778(295,	3,	'2019-03-27 06:53:45',	'2019-03-27 06:53:45'),
779(296,	3,	'2019-03-27 06:53:45',	'2019-03-27 06:53:45'),
780(297,	3,	'2019-03-27 06:53:45',	'2019-03-27 06:53:45'),
781(298,	3,	'2019-03-27 06:53:46',	'2019-03-27 06:53:46'),
782(299,	3,	'2019-03-27 06:53:46',	'2019-03-27 06:53:46'),
783(300,	3,	'2019-03-27 06:53:46',	'2019-03-27 06:53:46'),
784(301,	3,	'2019-03-27 06:53:46',	'2019-03-27 06:53:46'),
785(302,	3,	'2019-03-27 06:53:46',	'2019-03-27 06:53:46'),
786(304,	3,	'2019-03-27 06:53:47',	'2019-03-27 06:53:47'),
787(305,	3,	'2019-03-27 06:53:47',	'2019-03-27 06:53:47'),
788(306,	3,	'2019-03-27 06:53:47',	'2019-03-27 06:53:47'),
789(307,	3,	'2019-03-27 06:53:47',	'2019-03-27 06:53:47'),
790(308,	3,	'2019-03-27 06:53:47',	'2019-03-27 06:53:47'),
791(309,	3,	'2019-03-27 06:53:47',	'2019-03-27 06:53:47'),
792(310,	3,	'2019-03-27 06:53:48',	'2019-03-27 06:53:48'),
793(311,	3,	'2019-03-27 06:53:48',	'2019-03-27 06:53:48'),
794(312,	3,	'2019-03-27 06:53:48',	'2019-03-27 06:53:48'),
795(313,	3,	'2019-03-27 06:53:48',	'2019-03-27 06:53:48'),
796(314,	3,	'2019-03-27 06:53:48',	'2019-03-27 06:53:48'),
797(315,	3,	'2019-03-27 06:53:48',	'2019-03-27 06:53:48'),
798(316,	3,	'2019-03-27 06:53:49',	'2019-03-27 06:53:49'),
799(317,	3,	'2019-03-27 06:53:49',	'2019-03-27 06:53:49'),
800(318,	3,	'2019-03-27 06:53:47',	'2019-03-27 06:53:47'),
801(319,	19,	'2019-03-27 06:53:49',	'2019-03-27 06:53:49'),
802(320,	19,	'2019-03-27 06:53:49',	'2019-03-27 06:53:49'),
803(321,	14,	'2019-03-27 06:53:49',	'2019-03-27 06:53:49'),
804(322,	12,	'2019-03-27 06:53:49',	'2019-03-27 06:53:49'),
805(323,	21,	'2019-03-27 06:53:50',	'2019-03-27 06:53:50'),
806(324,	21,	'2019-03-27 06:53:50',	'2019-03-27 06:53:50'),
807(325,	10,	'2019-03-27 06:53:50',	'2019-03-27 06:53:50'),
808(326,	21,	'2019-03-27 06:53:50',	'2019-03-27 06:53:50'),
809(327,	21,	'2019-03-27 06:53:50',	'2019-03-27 06:53:50'),
810(328,	21,	'2019-03-27 06:53:50',	'2019-03-27 06:53:50'),
811(329,	1,	'2019-03-27 06:53:50',	'2019-03-27 06:53:50'),
812(330,	1,	'2019-03-27 06:53:51',	'2019-03-27 06:53:51'),
813(331,	19,	'2019-03-27 06:53:51',	'2019-03-27 06:53:51'),
814(332,	3,	'2019-03-27 06:53:51',	'2019-03-27 06:53:51'),
815(333,	3,	'2019-03-27 06:53:51',	'2019-03-27 06:53:51'),
816(334,	3,	'2019-03-27 06:53:51',	'2019-03-27 06:53:51'),
817(335,	3,	'2019-03-27 06:53:51',	'2019-03-27 06:53:51'),
818(336,	3,	'2019-03-27 06:53:52',	'2019-03-27 06:53:52'),
819(337,	7,	'2019-03-27 06:53:52',	'2019-03-27 06:53:52'),
820(338,	3,	'2019-03-27 06:53:52',	'2019-03-27 06:53:52'),
821(339,	3,	'2019-03-27 06:53:52',	'2019-03-27 06:53:52'),
822(340,	3,	'2019-03-27 06:53:52',	'2019-03-27 06:53:52');
823
824DROP TABLE IF EXISTS `hotel_facility_group`;
825CREATE TABLE `hotel_facility_group` (
826  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
827  `created_at` timestamp NULL DEFAULT NULL,
828  `updated_at` timestamp NULL DEFAULT NULL,
829  PRIMARY KEY (`id`)
830) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
831
832INSERT INTO `hotel_facility_group` (`id`, `created_at`, `updated_at`) VALUES
833(1,	'2019-03-27 07:26:20',	'2019-03-27 07:26:20'),
834(2,	'2019-03-27 07:26:20',	'2019-03-27 07:26:20'),
835(3,	'2019-03-27 07:26:21',	'2019-03-27 07:26:21'),
836(4,	'2019-03-27 07:26:21',	'2019-03-27 07:26:21'),
837(5,	'2019-03-27 07:26:21',	'2019-03-27 07:26:21'),
838(6,	'2019-03-27 07:26:21',	'2019-03-27 07:26:21'),
839(7,	'2019-03-27 07:26:21',	'2019-03-27 07:26:21'),
840(8,	'2019-03-27 07:26:22',	'2019-03-27 07:26:22'),
841(9,	'2019-03-27 07:26:22',	'2019-03-27 07:26:22'),
842(10,	'2019-03-27 07:26:22',	'2019-03-27 07:26:22'),
843(11,	'2019-03-27 07:26:23',	'2019-03-27 07:26:23'),
844(12,	'2019-03-27 07:26:23',	'2019-03-27 07:26:23'),
845(13,	'2019-03-27 07:26:23',	'2019-03-27 07:26:23'),
846(14,	'2019-03-27 07:26:23',	'2019-03-27 07:26:23'),
847(15,	'2019-03-27 07:26:24',	'2019-03-27 07:26:24'),
848(16,	'2019-03-27 07:26:24',	'2019-03-27 07:26:24'),
849(17,	'2019-03-27 07:26:24',	'2019-03-27 07:26:24'),
850(18,	'2019-03-27 07:26:24',	'2019-03-27 07:26:24'),
851(19,	'2019-03-27 07:26:24',	'2019-03-27 07:26:24'),
852(20,	'2019-03-27 07:26:24',	'2019-03-27 07:26:24'),
853(21,	'2019-03-27 07:26:25',	'2019-03-27 07:26:25'),
854(22,	'2019-03-27 07:26:25',	'2019-03-27 07:26:25');
855
856DROP TABLE IF EXISTS `hotel_facility_group_translations`;
857CREATE TABLE `hotel_facility_group_translations` (
858  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
859  `hotel_facility_group_id` int(10) unsigned NOT NULL,
860  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
861  `locale` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
862  `language_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
863  `created_at` timestamp NULL DEFAULT NULL,
864  `updated_at` timestamp NULL DEFAULT NULL,
865  PRIMARY KEY (`id`)
866) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
867
868INSERT INTO `hotel_facility_group_translations` (`id`, `hotel_facility_group_id`, `name`, `locale`, `language_id`, `created_at`, `updated_at`) VALUES
869(1,	1,	'Access',	'en',	'1',	'2019-03-27 07:26:20',	'2019-03-27 07:26:20'),
870(2,	2,	'Activities',	'en',	'1',	'2019-03-27 07:26:21',	'2019-03-27 07:26:21'),
871(3,	3,	'Available in all rooms',	'en',	'1',	'2019-03-27 07:26:21',	'2019-03-27 07:26:21'),
872(4,	4,	'Business facilities',	'en',	'1',	'2019-03-27 07:26:21',	'2019-03-27 07:26:21'),
873(5,	5,	'Cleaning services',	'en',	'1',	'2019-03-27 07:26:21',	'2019-03-27 07:26:21'),
874(6,	6,	'Common areas',	'en',	'1',	'2019-03-27 07:26:21',	'2019-03-27 07:26:21'),
875(7,	7,	'Dining, drinking, and snacking',	'en',	'1',	'2019-03-27 07:26:21',	'2019-03-27 07:26:21'),
876(8,	8,	'Entertainment and family services',	'en',	'1',	'2019-03-27 07:26:22',	'2019-03-27 07:26:22'),
877(9,	9,	'Food & Drink',	'en',	'1',	'2019-03-27 07:26:22',	'2019-03-27 07:26:22'),
878(10,	10,	'For the kids',	'en',	'1',	'2019-03-27 07:26:22',	'2019-03-27 07:26:22'),
879(11,	11,	'General',	'en',	'1',	'2019-03-27 07:26:23',	'2019-03-27 07:26:23'),
880(12,	12,	'Getting around',	'en',	'1',	'2019-03-27 07:26:23',	'2019-03-27 07:26:23'),
881(13,	13,	'Hostel facilities ',	'en',	'1',	'2019-03-27 07:26:23',	'2019-03-27 07:26:23'),
882(14,	14,	'Internet access',	'en',	'1',	'2019-03-27 07:26:24',	'2019-03-27 07:26:24'),
883(15,	15,	'Miscellaneous',	'en',	'1',	'2019-03-27 07:26:24',	'2019-03-27 07:26:24'),
884(16,	16,	'Pool and wellness',	'en',	'1',	'2019-03-27 07:26:24',	'2019-03-27 07:26:24'),
885(17,	17,	'Reception services',	'en',	'1',	'2019-03-27 07:26:24',	'2019-03-27 07:26:24'),
886(18,	18,	'Services',	'en',	'1',	'2019-03-27 07:26:24',	'2019-03-27 07:26:24'),
887(19,	19,	'Services and conveniences',	'en',	'1',	'2019-03-27 07:26:24',	'2019-03-27 07:26:24'),
888(20,	20,	'Shops',	'en',	'1',	'2019-03-27 07:26:24',	'2019-03-27 07:26:24'),
889(21,	21,	'Things to do, ways to relax',	'en',	'1',	'2019-03-27 07:26:25',	'2019-03-27 07:26:25'),
890(22,	22,	'Transport',	'en',	'1',	'2019-03-27 07:26:25',	'2019-03-27 07:26:25');
891
892DROP TABLE IF EXISTS `hotel_facility_relation`;
893CREATE TABLE `hotel_facility_relation` (
894  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
895  `hotel_id` int(11) NOT NULL,
896  `facility_id` int(11) NOT NULL,
897  PRIMARY KEY (`id`)
898) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
899
900
901DROP TABLE IF EXISTS `hotel_facility_translations`;
902CREATE TABLE `hotel_facility_translations` (
903  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
904  `hotel_facility_id` int(10) unsigned NOT NULL,
905  `language_id` int(10) unsigned NOT NULL,
906  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
907  `locale` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
908  `created_at` timestamp NULL DEFAULT NULL,
909  `updated_at` timestamp NULL DEFAULT NULL,
910  PRIMARY KEY (`id`),
911  KEY `hotel_facillity_translations_language_id_foreign` (`language_id`),
912  CONSTRAINT `hotel_facillity_translations_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `cm_master`.`languages` (`id`) ON DELETE CASCADE
913) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
914
915INSERT INTO `hotel_facility_translations` (`id`, `hotel_facility_id`, `language_id`, `name`, `locale`, `created_at`, `updated_at`) VALUES
916(1,	1,	1,	'Casino',	'en',	NULL,	NULL),
917(2,	2,	1,	'Bar',	'en',	NULL,	NULL),
918(3,	3,	1,	'Room service',	'en',	NULL,	NULL),
919(4,	4,	1,	'Facilities for disabled guests',	'en',	NULL,	NULL),
920(5,	5,	1,	'Valet parking',	'en',	NULL,	NULL),
921(6,	6,	1,	'Pets allowed',	'en',	NULL,	NULL),
922(7,	7,	1,	'Air conditioning',	'en',	NULL,	NULL),
923(8,	8,	1,	'Massage',	'en',	NULL,	NULL),
924(9,	9,	1,	'Sauna',	'en',	NULL,	NULL),
925(10,	10,	1,	'Tennis court',	'en',	NULL,	NULL),
926(11,	11,	1,	'Garden',	'en',	NULL,	NULL),
927(12,	12,	1,	'Shuttle service',	'en',	NULL,	NULL),
928(13,	13,	1,	'Hot spring bath',	'en',	NULL,	NULL),
929(14,	14,	1,	'Golf course (within 3 km)',	'en',	NULL,	NULL),
930(15,	15,	1,	'Dry cleaning',	'en',	NULL,	NULL),
931(16,	16,	1,	'Currency exchange',	'en',	NULL,	NULL),
932(17,	17,	1,	'Library',	'en',	NULL,	NULL),
933(18,	18,	1,	'BBQ facilities',	'en',	NULL,	NULL),
934(19,	19,	1,	'Luggage storage',	'en',	NULL,	NULL),
935(20,	20,	1,	'Shared kitchen',	'en',	NULL,	NULL),
936(21,	21,	1,	'Fishing',	'en',	NULL,	NULL),
937(22,	22,	1,	'Skiing',	'en',	NULL,	NULL),
938(23,	23,	1,	'Solarium',	'en',	NULL,	NULL),
939(24,	24,	1,	'Table tennis',	'en',	NULL,	NULL),
940(25,	25,	1,	'Karaoke',	'en',	NULL,	NULL),
941(26,	26,	1,	'Diving',	'en',	NULL,	NULL),
942(27,	27,	1,	'Telephone',	'en',	NULL,	NULL),
943(28,	28,	1,	'Trouser press',	'en',	NULL,	NULL),
944(29,	29,	1,	'Heating',	'en',	NULL,	NULL),
945(30,	30,	1,	'Wheelchair accessible',	'en',	NULL,	NULL),
946(31,	31,	1,	'Canoeing',	'en',	NULL,	NULL),
947(32,	32,	1,	'Hiking',	'en',	NULL,	NULL),
948(33,	33,	1,	'Water park',	'en',	NULL,	NULL),
949(34,	34,	1,	'Parking',	'en',	NULL,	NULL),
950(35,	35,	1,	'Restaurant',	'en',	NULL,	NULL),
951(36,	36,	1,	'Meeting/banquet facilities',	'en',	NULL,	NULL),
952(37,	37,	1,	'24-hour front desk',	'en',	NULL,	NULL),
953(38,	38,	1,	'Fitness centre',	'en',	NULL,	NULL),
954(39,	39,	1,	'Newspapers',	'en',	NULL,	NULL),
955(40,	40,	1,	'Terrace',	'en',	NULL,	NULL),
956(41,	41,	1,	'Non-smoking rooms',	'en',	NULL,	NULL),
957(42,	42,	1,	'Airport shuttle',	'en',	NULL,	NULL),
958(43,	43,	1,	'Business centre',	'en',	NULL,	NULL),
959(44,	44,	1,	'Babysitting/child services',	'en',	NULL,	NULL),
960(45,	45,	1,	'Laundry',	'en',	NULL,	NULL),
961(46,	46,	1,	'Continental breakfast',	'en',	NULL,	NULL),
962(47,	47,	1,	'Barber/beauty shop',	'en',	NULL,	NULL),
963(48,	48,	1,	'Family rooms',	'en',	NULL,	NULL),
964(49,	49,	1,	'Games room',	'en',	NULL,	NULL),
965(50,	50,	1,	'VIP room facilities',	'en',	NULL,	NULL),
966(51,	51,	1,	'Breakfast in the room',	'en',	NULL,	NULL),
967(52,	52,	1,	'Ironing service',	'en',	NULL,	NULL),
968(53,	53,	1,	'Bridal suite',	'en',	NULL,	NULL),
969(54,	54,	1,	'Free parking',	'en',	NULL,	NULL),
970(55,	55,	1,	'Internet services',	'en',	NULL,	NULL),
971(56,	56,	1,	'Lift',	'en',	NULL,	NULL),
972(57,	57,	1,	'Express check-in/check-out',	'en',	NULL,	NULL),
973(58,	58,	1,	'Safety deposit box',	'en',	NULL,	NULL),
974(59,	59,	1,	'Spa and wellness centre',	'en',	NULL,	NULL),
975(60,	60,	1,	'Children\'s playground',	'en',	NULL,	NULL),
976(61,	61,	1,	'Billiards',	'en',	NULL,	NULL),
977(62,	62,	1,	'Gift shop',	'en',	NULL,	NULL),
978(63,	63,	1,	'Windsurfing',	'en',	NULL,	NULL),
979(64,	64,	1,	'Darts',	'en',	NULL,	NULL),
980(65,	65,	1,	'Hot tub/jacuzzi',	'en',	NULL,	NULL),
981(66,	66,	1,	'Soundproof rooms',	'en',	NULL,	NULL),
982(67,	67,	1,	'Bicycle rental (additional charge)',	'en',	NULL,	NULL),
983(68,	68,	1,	'Shoeshine',	'en',	NULL,	NULL),
984(69,	69,	1,	'Chapel/shrine',	'en',	NULL,	NULL),
985(70,	70,	1,	'Packed lunches',	'en',	NULL,	NULL),
986(71,	71,	1,	'Car hire',	'en',	NULL,	NULL),
987(72,	72,	1,	'Cycling',	'en',	NULL,	NULL),
988(73,	73,	1,	'Bowling',	'en',	NULL,	NULL),
989(74,	74,	1,	'Tour desk',	'en',	NULL,	NULL),
990(75,	75,	1,	'Hammam',	'en',	NULL,	NULL),
991(76,	76,	1,	'Fax/photocopying',	'en',	NULL,	NULL),
992(77,	77,	1,	'Horse riding',	'en',	NULL,	NULL),
993(78,	78,	1,	'Squash',	'en',	NULL,	NULL),
994(79,	79,	1,	'Ticket service',	'en',	NULL,	NULL),
995(80,	80,	1,	'Snorkelling',	'en',	NULL,	NULL),
996(81,	81,	1,	'Shops (on site)',	'en',	NULL,	NULL),
997(82,	82,	1,	'WiFi',	'en',	NULL,	NULL),
998(83,	83,	1,	'Mini golf',	'en',	NULL,	NULL),
999(84,	84,	1,	'Ski storage',	'en',	NULL,	NULL),
1000(85,	85,	1,	'Ski school',	'en',	NULL,	NULL),
1001(86,	86,	1,	'Allergy-free room',	'en',	NULL,	NULL),
1002(87,	87,	1,	'Indoor pool',	'en',	NULL,	NULL),
1003(88,	88,	1,	'Outdoor pool',	'en',	NULL,	NULL),
1004(89,	89,	1,	'Free WiFi',	'en',	NULL,	NULL),
1005(90,	90,	1,	'Non-smoking throughout',	'en',	NULL,	NULL),
1006(91,	91,	1,	'Designated smoking area',	'en',	NULL,	NULL),
1007(92,	92,	1,	'ATM/cash machine on site',	'en',	NULL,	NULL),
1008(93,	93,	1,	'Private beach area',	'en',	NULL,	NULL),
1009(94,	94,	1,	'Restaurant (à la carte)',	'en',	NULL,	NULL),
1010(95,	95,	1,	'Restaurant (buffet)',	'en',	NULL,	NULL),
1011(96,	96,	1,	'Snack bar',	'en',	NULL,	NULL),
1012(97,	97,	1,	'Sun terrace',	'en',	NULL,	NULL),
1013(98,	98,	1,	'Outdoor pool (all year)',	'en',	NULL,	NULL),
1014(99,	99,	1,	'Outdoor pool (seasonal)',	'en',	NULL,	NULL),
1015(100,	100,	1,	'Indoor pool (all year)',	'en',	NULL,	NULL),
1016(101,	101,	1,	'Indoor pool (seasonal)',	'en',	NULL,	NULL),
1017(102,	102,	1,	'Bikes available (free)',	'en',	NULL,	NULL),
1018(103,	103,	1,	'Concierge service',	'en',	NULL,	NULL),
1019(104,	104,	1,	'Entertainment staff',	'en',	NULL,	NULL),
1020(105,	105,	1,	'Nightclub/DJ',	'en',	NULL,	NULL),
1021(106,	106,	1,	'Private check-in/check-out',	'en',	NULL,	NULL),
1022(107,	107,	1,	'Shuttle service (free)',	'en',	NULL,	NULL),
1023(108,	108,	1,	'Shuttle service (additional charge)',	'en',	NULL,	NULL),
1024(109,	109,	1,	'Ski equipment hire (on site)',	'en',	NULL,	NULL),
1025(110,	110,	1,	'Ski pass vendor',	'en',	NULL,	NULL),
1026(111,	111,	1,	'Ski-to-door access',	'en',	NULL,	NULL),
1027(112,	112,	1,	'Special diet menus (on request)',	'en',	NULL,	NULL),
1028(113,	113,	1,	'Vending machine (drinks)',	'en',	NULL,	NULL),
1029(114,	114,	1,	'Vending machine (snacks)',	'en',	NULL,	NULL),
1030(115,	115,	1,	'Water sport facilities (on site)',	'en',	NULL,	NULL),
1031(116,	116,	1,	'Airport shuttle (free)',	'en',	NULL,	NULL),
1032(117,	117,	1,	'Airport shuttle (additional charge)',	'en',	NULL,	NULL),
1033(118,	118,	1,	'Lockers',	'en',	NULL,	NULL),
1034(119,	119,	1,	'Shared lounge/TV area',	'en',	NULL,	NULL),
1035(120,	120,	1,	'Kids\' club',	'en',	NULL,	NULL),
1036(121,	121,	1,	'Mini-market on site',	'en',	NULL,	NULL),
1037(122,	122,	1,	'Beachfront',	'en',	NULL,	NULL),
1038(123,	123,	1,	'Evening entertainment',	'en',	NULL,	NULL),
1039(124,	124,	1,	'Adult only',	'en',	NULL,	NULL),
1040(125,	125,	1,	'Daily maid service',	'en',	NULL,	NULL),
1041(126,	126,	1,	'Grocery deliveries',	'en',	NULL,	NULL),
1042(127,	127,	1,	'On-site parking',	'en',	NULL,	NULL),
1043(128,	128,	1,	'Private parking',	'en',	NULL,	NULL),
1044(129,	129,	1,	'Misc parking',	'en',	NULL,	NULL),
1045(130,	130,	1,	'WiFi available in all areas',	'en',	NULL,	NULL),
1046(131,	131,	1,	'Paid WiFi',	'en',	NULL,	NULL),
1047(132,	132,	1,	'Open-air bath',	'en',	NULL,	NULL),
1048(133,	133,	1,	'Public Bath',	'en',	NULL,	NULL),
1049(134,	134,	1,	'Water slide',	'en',	NULL,	NULL),
1050(135,	135,	1,	'Swimming pool toys',	'en',	NULL,	NULL),
1051(136,	136,	1,	'Board games/puzzles',	'en',	NULL,	NULL),
1052(137,	137,	1,	'Books, DVDs, music for children',	'en',	NULL,	NULL),
1053(138,	138,	1,	'Indoor play area',	'en',	NULL,	NULL),
1054(139,	139,	1,	'Kids\' outdoor play equipment',	'en',	NULL,	NULL),
1055(140,	140,	1,	'Baby safety gates',	'en',	NULL,	NULL),
1056(141,	141,	1,	'Children television networks',	'en',	NULL,	NULL),
1057(142,	142,	1,	'Kid meals',	'en',	NULL,	NULL),
1058(143,	143,	1,	'Kid-friendly buffet',	'en',	NULL,	NULL),
1059(144,	144,	1,	'Secured parking',	'en',	NULL,	NULL),
1060(145,	145,	1,	'Street parking',	'en',	NULL,	NULL),
1061(146,	146,	1,	'Parking garage',	'en',	NULL,	NULL),
1062(147,	147,	1,	'Electric vehicle charging station',	'en',	NULL,	NULL),
1063(148,	148,	1,	'Public transport tickets',	'en',	NULL,	NULL),
1064(149,	149,	1,	'Accessible parking',	'en',	NULL,	NULL),
1065(150,	150,	1,	'Toilet with grab rails',	'en',	NULL,	NULL),
1066(151,	151,	1,	'Higher level toilet',	'en',	NULL,	NULL),
1067(152,	152,	1,	'Lower bathroom sink',	'en',	NULL,	NULL),
1068(153,	153,	1,	'Emergency cord in bathroom',	'en',	NULL,	NULL),
1069(154,	154,	1,	'Rooftop pool',	'en',	NULL,	NULL),
1070(155,	155,	1,	'Infinity pool',	'en',	NULL,	NULL),
1071(156,	156,	1,	'Pool with view',	'en',	NULL,	NULL),
1072(157,	157,	1,	'Heated pool',	'en',	NULL,	NULL),
1073(158,	158,	1,	'Salt-water pool',	'en',	NULL,	NULL),
1074(159,	159,	1,	'Plunge pool',	'en',	NULL,	NULL),
1075(160,	160,	1,	'Pool/beach towels',	'en',	NULL,	NULL),
1076(161,	161,	1,	'Pool bar',	'en',	NULL,	NULL),
1077(162,	162,	1,	'Shallow end',	'en',	NULL,	NULL),
1078(163,	163,	1,	'Pool cover',	'en',	NULL,	NULL),
1079(164,	164,	1,	'Wine/champagne',	'en',	NULL,	NULL),
1080(165,	165,	1,	'Bottle of water',	'en',	NULL,	NULL),
1081(166,	166,	1,	'Fruits',	'en',	NULL,	NULL),
1082(167,	167,	1,	'Chocolate or cookies',	'en',	NULL,	NULL),
1083(168,	168,	1,	'Tickets to attractions or shows',	'en',	NULL,	NULL),
1084(169,	169,	1,	'Airport pick up',	'en',	NULL,	NULL),
1085(170,	170,	1,	'Airport drop off',	'en',	NULL,	NULL),
1086(171,	171,	1,	'Visual aids: Braille',	'en',	NULL,	NULL),
1087(172,	172,	1,	'Visual aids: Tactile signs',	'en',	NULL,	NULL),
1088(173,	173,	1,	'Auditory guidance',	'en',	NULL,	NULL),
1089(174,	174,	1,	'Strollers',	'en',	NULL,	NULL),
1090(175,	175,	1,	'Tennis equipment',	'en',	NULL,	NULL),
1091(176,	176,	1,	'Badminton equipment',	'en',	NULL,	NULL),
1092(177,	177,	1,	'Pet basket',	'en',	NULL,	NULL),
1093(178,	178,	1,	'Pet bowls',	'en',	NULL,	NULL),
1094(179,	179,	1,	'On-site coffee house',	'en',	NULL,	NULL),
1095(180,	180,	1,	'Sun loungers or beach chairs',	'en',	NULL,	NULL),
1096(181,	181,	1,	'Sun umbrellas',	'en',	NULL,	NULL),
1097(182,	182,	1,	'Outdoor furniture',	'en',	NULL,	NULL),
1098(183,	183,	1,	'Fence around pool',	'en',	NULL,	NULL),
1099(184,	184,	1,	'Picnic area',	'en',	NULL,	NULL),
1100(185,	185,	1,	'Outdoor fireplace',	'en',	NULL,	NULL),
1101(186,	186,	1,	'Beauty Services',	'en',	NULL,	NULL),
1102(187,	187,	1,	'Facial treatments',	'en',	NULL,	NULL),
1103(188,	188,	1,	'Waxing services',	'en',	NULL,	NULL),
1104(189,	189,	1,	'Make up services',	'en',	NULL,	NULL),
1105(190,	190,	1,	'Hair treatments',	'en',	NULL,	NULL),
1106(191,	191,	1,	'Manicure',	'en',	NULL,	NULL),
1107(192,	192,	1,	'Pedicure',	'en',	NULL,	NULL),
1108(193,	193,	1,	'Hair cut',	'en',	NULL,	NULL),
1109(194,	194,	1,	'Hair colouring',	'en',	NULL,	NULL),
1110(195,	195,	1,	'Hair styling',	'en',	NULL,	NULL),
1111(196,	196,	1,	'Body Treatments',	'en',	NULL,	NULL),
1112(197,	197,	1,	'Body scrub',	'en',	NULL,	NULL),
1113(198,	198,	1,	'Body wrap',	'en',	NULL,	NULL),
1114(199,	199,	1,	'Light therapy',	'en',	NULL,	NULL),
1115(200,	200,	1,	'Spa Facilities',	'en',	NULL,	NULL),
1116(201,	201,	1,	'Steam room',	'en',	NULL,	NULL),
1117(202,	202,	1,	'Spa lounge/relaxation area',	'en',	NULL,	NULL),
1118(203,	203,	1,	'Foot bath',	'en',	NULL,	NULL),
1119(204,	204,	1,	'Spa/wellness packages',	'en',	NULL,	NULL),
1120(205,	205,	1,	'Back massage',	'en',	NULL,	NULL),
1121(206,	206,	1,	'Neck massage',	'en',	NULL,	NULL),
1122(207,	207,	1,	'Foot massage',	'en',	NULL,	NULL),
1123(208,	208,	1,	'Couples massage',	'en',	NULL,	NULL),
1124(209,	209,	1,	'Head massage',	'en',	NULL,	NULL),
1125(210,	210,	1,	'Hand massage',	'en',	NULL,	NULL),
1126(211,	211,	1,	'Full body massage',	'en',	NULL,	NULL),
1127(212,	212,	1,	'Massage chair',	'en',	NULL,	NULL),
1128(213,	213,	1,	'Fitness',	'en',	NULL,	NULL),
1129(214,	214,	1,	'Yoga classes',	'en',	NULL,	NULL),
1130(215,	215,	1,	'Fitness classes',	'en',	NULL,	NULL),
1131(216,	216,	1,	'Personal trainer',	'en',	NULL,	NULL),
1132(217,	217,	1,	'Fitness/spa locker rooms',	'en',	NULL,	NULL),
1133(218,	218,	1,	'Kids\' pool',	'en',	NULL,	NULL),
1134(219,	219,	1,	'Swimming pool',	'en',	NULL,	NULL),
1135(220,	220,	1,	'Beach',	'en',	NULL,	NULL),
1136(221,	221,	1,	'Breakfast options',	'en',	NULL,	NULL),
1137(222,	222,	1,	'Game drives',	'en',	NULL,	NULL),
1138(223,	223,	1,	'Temporary art galleries',	'en',	NULL,	NULL),
1139(224,	224,	1,	'Pub crawls',	'en',	NULL,	NULL),
1140(225,	225,	1,	'Stand-up comedy',	'en',	NULL,	NULL),
1141(226,	226,	1,	'Movie nights',	'en',	NULL,	NULL),
1142(227,	227,	1,	'Walking tours',	'en',	NULL,	NULL),
1143(228,	228,	1,	'Bike tours',	'en',	NULL,	NULL),
1144(229,	229,	1,	'Themed dinner nights',	'en',	NULL,	NULL),
1145(230,	230,	1,	'Happy hour',	'en',	NULL,	NULL),
1146(231,	231,	1,	'Tour or class about local culture',	'en',	NULL,	NULL),
1147(232,	232,	1,	'Cooking class',	'en',	NULL,	NULL),
1148(233,	233,	1,	'Live music/performance',	'en',	NULL,	NULL),
1149(234,	234,	1,	'Live sport events (broadcast)',	'en',	NULL,	NULL),
1150(235,	235,	1,	'Archery',	'en',	NULL,	NULL),
1151(236,	236,	1,	'Aerobics',	'en',	NULL,	NULL),
1152(237,	237,	1,	'Bingo',	'en',	NULL,	NULL),
1153(238,	238,	1,	'24-hour security',	'en',	NULL,	NULL),
1154(239,	239,	1,	'Key access',	'en',	NULL,	NULL),
1155(240,	240,	1,	'Key card access',	'en',	NULL,	NULL),
1156(241,	241,	1,	'Security alarm',	'en',	NULL,	NULL),
1157(242,	242,	1,	'Smoke alarms',	'en',	NULL,	NULL),
1158(243,	243,	1,	'CCTV in common areas',	'en',	NULL,	NULL),
1159(244,	244,	1,	'CCTV outside property',	'en',	NULL,	NULL),
1160(245,	245,	1,	'Fire extinguishers',	'en',	NULL,	NULL),
1161(246,	246,	1,	'Bicycle parking',	'en',	NULL,	NULL),
1162(247,	247,	1,	'Postal service',	'en',	NULL,	NULL),
1163(248,	248,	1,	'Laundry room',	'en',	NULL,	NULL),
1164(249,	249,	1,	'Ski Shuttle',	'en',	NULL,	NULL),
1165(250,	250,	1,	'Room service [24-hour]',	'en',	NULL,	NULL),
1166(251,	251,	1,	'Salon',	'en',	NULL,	NULL),
1167(252,	252,	1,	'Bathrobes',	'en',	NULL,	NULL),
1168(253,	253,	1,	'On-demand movies',	'en',	NULL,	NULL),
1169(254,	254,	1,	'Desk',	'en',	NULL,	NULL),
1170(255,	255,	1,	'Hair dryer',	'en',	NULL,	NULL),
1171(256,	256,	1,	'In-room safe box',	'en',	NULL,	NULL),
1172(257,	257,	1,	'TV',	'en',	NULL,	NULL),
1173(258,	258,	1,	'TV [flat screen]',	'en',	NULL,	NULL),
1174(259,	259,	1,	'Bathtub',	'en',	NULL,	NULL),
1175(260,	260,	1,	'Shower',	'en',	NULL,	NULL),
1176(261,	261,	1,	'Separate shower/bathtub',	'en',	NULL,	NULL),
1177(262,	262,	1,	'Mini bar',	'en',	NULL,	NULL),
1178(263,	263,	1,	'Microwave',	'en',	NULL,	NULL),
1179(264,	264,	1,	'Kitchenette',	'en',	NULL,	NULL),
1180(265,	265,	1,	'Satellite/cable channels',	'en',	NULL,	NULL),
1181(266,	266,	1,	'Whirlpool bathtub',	'en',	NULL,	NULL),
1182(267,	267,	1,	'DVD/CD player',	'en',	NULL,	NULL),
1183(268,	268,	1,	'Coffee/tea maker',	'en',	NULL,	NULL),
1184(269,	269,	1,	'Video game console',	'en',	NULL,	NULL),
1185(270,	270,	1,	'Private pool',	'en',	NULL,	NULL),
1186(271,	271,	1,	'Golf course [on-site]',	'en',	NULL,	NULL),
1187(272,	272,	1,	'Shared bathroom',	'en',	NULL,	NULL),
1188(273,	273,	1,	'Fan',	'en',	NULL,	NULL),
1189(274,	274,	1,	'Refrigerator',	'en',	NULL,	NULL),
1190(275,	275,	1,	'Washing machine',	'en',	NULL,	NULL),
1191(276,	276,	1,	'Separate dining area',	'en',	NULL,	NULL),
1192(277,	277,	1,	'Seating area',	'en',	NULL,	NULL),
1193(278,	278,	1,	'Executive lounge access',	'en',	NULL,	NULL),
1194(279,	279,	1,	'Laptop safe box',	'en',	NULL,	NULL),
1195(280,	280,	1,	'Extra long bed',	'en',	NULL,	NULL),
1196(281,	281,	1,	'Interconnecting room(s) available',	'en',	NULL,	NULL),
1197(282,	282,	1,	'Free Wi-Fi in all rooms',	'en',	NULL,	NULL),
1198(283,	283,	1,	'Cash withdrawal',	'en',	NULL,	NULL),
1199(284,	284,	1,	'Toiletries',	'en',	NULL,	NULL),
1200(285,	285,	1,	'Dishwasher',	'en',	NULL,	NULL),
1201(286,	286,	1,	'Alarm clock',	'en',	NULL,	NULL),
1202(287,	287,	1,	'iPod docking station',	'en',	NULL,	NULL),
1203(288,	288,	1,	'Kitchenware',	'en',	NULL,	NULL),
1204(289,	289,	1,	'Mosquito net',	'en',	NULL,	NULL),
1205(290,	290,	1,	'Clothes dryer',	'en',	NULL,	NULL),
1206(291,	291,	1,	'Blackout curtains',	'en',	NULL,	NULL),
1207(292,	292,	1,	'Wake-up service',	'en',	NULL,	NULL),
1208(293,	293,	1,	'Additional bathroom',	'en',	NULL,	NULL),
1209(294,	294,	1,	'Additional toilet',	'en',	NULL,	NULL),
1210(295,	295,	1,	'Bathroom phone',	'en',	NULL,	NULL),
1211(296,	296,	1,	'Carpeting',	'en',	NULL,	NULL),
1212(297,	297,	1,	'High chair',	'en',	NULL,	NULL),
1213(298,	298,	1,	'Cleaning products',	'en',	NULL,	NULL),
1214(299,	299,	1,	'Clothes rack',	'en',	NULL,	NULL),
1215(300,	300,	1,	'Free instant coffee',	'en',	NULL,	NULL),
1216(301,	301,	1,	'Complimentary tea',	'en',	NULL,	NULL),
1217(302,	302,	1,	'Dressing room',	'en',	NULL,	NULL),
1218(303,	318,	1,	'Fireplace',	'en',	NULL,	NULL),
1219(304,	304,	1,	'Free welcome drink',	'en',	NULL,	NULL),
1220(305,	305,	1,	'In-room tablet',	'en',	NULL,	NULL),
1221(306,	306,	1,	'Linens',	'en',	NULL,	NULL),
1222(307,	307,	1,	'Mirror',	'en',	NULL,	NULL),
1223(308,	308,	1,	'Private entrance',	'en',	NULL,	NULL),
1224(309,	309,	1,	'Scale',	'en',	NULL,	NULL),
1225(310,	310,	1,	'Sewing kit',	'en',	NULL,	NULL),
1226(311,	311,	1,	'Slippers',	'en',	NULL,	NULL),
1227(312,	312,	1,	'Sofa',	'en',	NULL,	NULL),
1228(313,	313,	1,	'Towels',	'en',	NULL,	NULL),
1229(314,	314,	1,	'Umbrella',	'en',	NULL,	NULL),
1230(315,	315,	1,	'Closet',	'en',	NULL,	NULL),
1231(316,	316,	1,	'Wooden/parqueted flooring',	'en',	NULL,	NULL),
1232(317,	317,	1,	'Separate living room',	'en',	NULL,	NULL),
1233(318,	319,	1,	'Infirmary',	'en',	NULL,	NULL),
1234(319,	320,	1,	'Laundromat',	'en',	NULL,	NULL),
1235(320,	321,	1,	'Wi-Fi [portable rental]',	'en',	NULL,	NULL),
1236(321,	322,	1,	'Taxi service',	'en',	NULL,	NULL),
1237(322,	323,	1,	'Badminton court',	'en',	NULL,	NULL),
1238(323,	324,	1,	'Boating',	'en',	NULL,	NULL),
1239(324,	325,	1,	'Theme park',	'en',	NULL,	NULL),
1240(325,	326,	1,	'Watersport equipment rentals',	'en',	NULL,	NULL),
1241(326,	327,	1,	'Yoga room',	'en',	NULL,	NULL),
1242(327,	328,	1,	'Surfing lessons',	'en',	NULL,	NULL),
1243(328,	329,	1,	'Check-in [24-hour]',	'en',	NULL,	NULL),
1244(329,	330,	1,	'Buzzer/wireless intercom',	'en',	NULL,	NULL),
1245(330,	331,	1,	'Doorman',	'en',	NULL,	NULL),
1246(331,	332,	1,	'Full kitchen',	'en',	NULL,	NULL),
1247(332,	333,	1,	'Laptop workspace',	'en',	NULL,	NULL),
1248(333,	334,	1,	'Carbon monoxide detector',	'en',	NULL,	NULL),
1249(334,	335,	1,	'First aid kit',	'en',	NULL,	NULL),
1250(335,	336,	1,	'Smoking allowed',	'en',	NULL,	NULL),
1251(336,	337,	1,	'kitchen',	'en',	NULL,	NULL),
1252(337,	338,	1,	'High floor',	'en',	NULL,	NULL),
1253(338,	339,	1,	'Air purifier',	'en',	NULL,	NULL),
1254(339,	340,	1,	'Electric blanket',	'en',	NULL,	NULL);
1255
1256DROP TABLE IF EXISTS `hotel_photo`;
1257CREATE TABLE `hotel_photo` (
1258  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
1259  `hotel_id` int(11) NOT NULL,
1260  `tags` text COLLATE utf8mb4_unicode_ci NOT NULL,
1261  `auto_tags` text COLLATE utf8mb4_unicode_ci NOT NULL,
1262  `main_photo` tinyint(11) NOT NULL DEFAULT '0',
1263  `is_logo` tinyint(11) NOT NULL DEFAULT '0',
1264  `url_max300` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
1265  `url_original` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
1266  `url_square60` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
1267  `created_at` timestamp NULL DEFAULT NULL,
1268  `updated_at` timestamp NULL DEFAULT NULL,
1269  PRIMARY KEY (`id`)
1270) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1271
1272
1273DROP TABLE IF EXISTS `hotel_properties`;
1274CREATE TABLE `hotel_properties` (
1275  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
1276  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
1277  `created_at` timestamp NULL DEFAULT NULL,
1278  `updated_at` timestamp NULL DEFAULT NULL,
1279  PRIMARY KEY (`id`)
1280) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1281
1282
1283DROP TABLE IF EXISTS `hotel_relations`;
1284CREATE TABLE `hotel_relations` (
1285  `hotel_id` int(10) unsigned NOT NULL,
1286  `hotel_relations_id` int(11) NOT NULL,
1287  `hotel_relations_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
1288  KEY `hotel_relations_hotel_id_foreign` (`hotel_id`),
1289  CONSTRAINT `hotel_relations_hotel_id_foreign` FOREIGN KEY (`hotel_id`) REFERENCES `hotels` (`id`) ON DELETE CASCADE
1290) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1291
1292
1293DROP TABLE IF EXISTS `hotel_rules`;
1294CREATE TABLE `hotel_rules` (
1295  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
1296  `hotel_id` int(10) unsigned NOT NULL,
1297  `rule_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
1298  `rule_content` text COLLATE utf8mb4_unicode_ci NOT NULL,
1299  `lang` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
1300  `created_at` timestamp NULL DEFAULT NULL,
1301  `updated_at` timestamp NULL DEFAULT NULL,
1302  PRIMARY KEY (`id`),
1303  KEY `hotel_rules_hotel_id_foreign` (`hotel_id`),
1304  CONSTRAINT `hotel_rules_hotel_id_foreign` FOREIGN KEY (`hotel_id`) REFERENCES `hotels` (`id`)
1305) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1306
1307
1308DROP TABLE IF EXISTS `hotel_translations`;
1309CREATE TABLE `hotel_translations` (
1310  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
1311  `hotel_id` int(10) unsigned NOT NULL,
1312  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
1313  `overview` longtext COLLATE utf8mb4_unicode_ci,
1314  `snippet` longtext COLLATE utf8mb4_unicode_ci,
1315  `remark` longtext COLLATE utf8mb4_unicode_ci,
1316  `locale` varchar(2) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
1317  `created_at` timestamp NULL DEFAULT NULL,
1318  `updated_at` timestamp NULL DEFAULT NULL,
1319  PRIMARY KEY (`id`),
1320  KEY `hotel_translations_hotel_id_foreign` (`hotel_id`),
1321  CONSTRAINT `hotel_translations_hotel_id_foreign` FOREIGN KEY (`hotel_id`) REFERENCES `hotels` (`id`)
1322) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1323
1324INSERT INTO `hotel_translations` (`id`, `hotel_id`, `name`, `overview`, `snippet`, `remark`, `locale`, `created_at`, `updated_at`) VALUES
1325(1,	1,	'Ibis Old',	NULL,	NULL,	NULL,	'en',	NULL,	NULL),
1326(2,	2,	'Goku\'s Hotel',	NULL,	NULL,	NULL,	'en',	NULL,	NULL),
1327(3,	1,	'Ibis Hoteruu',	NULL,	NULL,	NULL,	'ja',	NULL,	NULL);
1328
1329DROP TABLE IF EXISTS `hotel_types`;
1330CREATE TABLE `hotel_types` (
1331  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
1332  `created_at` timestamp NULL DEFAULT NULL,
1333  `updated_at` timestamp NULL DEFAULT NULL,
1334  PRIMARY KEY (`id`)
1335) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1336
1337INSERT INTO `hotel_types` (`id`, `created_at`, `updated_at`) VALUES
1338(1,	'2019-03-27 07:34:50',	'2019-03-27 07:34:50'),
1339(2,	'2019-03-27 07:34:50',	'2019-03-27 07:34:50'),
1340(3,	'2019-03-27 07:34:50',	'2019-03-27 07:34:50'),
1341(4,	'2019-03-27 07:34:51',	'2019-03-27 07:34:51'),
1342(5,	'2019-03-27 07:34:51',	'2019-03-27 07:34:51'),
1343(6,	'2019-03-27 07:34:52',	'2019-03-27 07:34:52'),
1344(7,	'2019-03-27 07:34:53',	'2019-03-27 07:34:53'),
1345(8,	'2019-03-27 07:34:53',	'2019-03-27 07:34:53'),
1346(9,	'2019-03-27 07:34:53',	'2019-03-27 07:34:53'),
1347(10,	'2019-03-27 07:34:53',	'2019-03-27 07:34:53'),
1348(11,	'2019-03-27 07:34:53',	'2019-03-27 07:34:53'),
1349(12,	'2019-03-27 07:34:53',	'2019-03-27 07:34:53'),
1350(13,	'2019-03-27 07:34:54',	'2019-03-27 07:34:54'),
1351(14,	'2019-03-27 07:34:54',	'2019-03-27 07:34:54'),
1352(15,	'2019-03-27 07:34:54',	'2019-03-27 07:34:54'),
1353(16,	'2019-03-27 07:34:54',	'2019-03-27 07:34:54'),
1354(17,	'2019-03-27 07:34:54',	'2019-03-27 07:34:54'),
1355(18,	'2019-03-27 07:34:54',	'2019-03-27 07:34:54'),
1356(19,	'2019-03-27 07:34:55',	'2019-03-27 07:34:55'),
1357(20,	'2019-03-27 07:34:55',	'2019-03-27 07:34:55'),
1358(21,	'2019-03-27 07:34:55',	'2019-03-27 07:34:55'),
1359(22,	'2019-03-27 07:34:56',	'2019-03-27 07:34:56'),
1360(23,	'2019-03-27 07:34:56',	'2019-03-27 07:34:56'),
1361(24,	'2019-03-27 07:34:56',	'2019-03-27 07:34:56'),
1362(25,	'2019-03-27 07:34:56',	'2019-03-27 07:34:56'),
1363(26,	'2019-03-27 07:34:57',	'2019-03-27 07:34:57'),
1364(27,	'2019-03-27 07:34:57',	'2019-03-27 07:34:57'),
1365(28,	'2019-03-27 07:34:57',	'2019-03-27 07:34:57'),
1366(29,	'2019-03-27 07:34:58',	'2019-03-27 07:34:58'),
1367(30,	'2019-03-27 07:34:58',	'2019-03-27 07:34:58'),
1368(31,	'2019-03-27 07:34:58',	'2019-03-27 07:34:58'),
1369(32,	'2019-03-27 07:34:58',	'2019-03-27 07:34:58'),
1370(33,	'2019-03-27 07:34:59',	'2019-03-27 07:34:59'),
1371(34,	'2019-03-27 07:34:59',	'2019-03-27 07:34:59'),
1372(35,	'2019-03-27 07:34:59',	'2019-03-27 07:34:59');
1373
1374DROP TABLE IF EXISTS `hotel_type_translations`;
1375CREATE TABLE `hotel_type_translations` (
1376  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
1377  `hotel_type_id` int(10) unsigned NOT NULL,
1378  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
1379  `locale` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
1380  `language_id` int(11) NOT NULL,
1381  PRIMARY KEY (`id`),
1382  KEY `hotel_type_translations_hotel_type_id_foreign` (`hotel_type_id`),
1383  KEY `hotel_type_translations_locale_index` (`locale`),
1384  CONSTRAINT `hotel_type_translations_hotel_type_id_foreign` FOREIGN KEY (`hotel_type_id`) REFERENCES `hotel_types` (`id`) ON DELETE CASCADE
1385) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1386
1387INSERT INTO `hotel_type_translations` (`id`, `hotel_type_id`, `name`, `locale`, `language_id`) VALUES
1388(1,	1,	'Apartments',	'en',	1),
1389(2,	2,	'Hostels',	'en',	1),
1390(3,	3,	'Hotels',	'en',	1),
1391(4,	4,	'Motels',	'en',	1),
1392(5,	5,	'Resorts',	'en',	1),
1393(6,	6,	'Residences',	'en',	1),
1394(7,	7,	'Ryokans',	'en',	1),
1395(8,	8,	'Farm stays',	'en',	1),
1396(9,	9,	'Holiday parks',	'en',	1),
1397(10,	10,	'Villas',	'en',	1),
1398(11,	11,	'Campsites',	'en',	1),
1399(12,	12,	'Boats',	'en',	1),
1400(13,	13,	'Guest accommodation',	'en',	1),
1401(14,	14,	'Uncertain',	'en',	1),
1402(15,	15,	'Inns',	'en',	1),
1403(16,	16,	'Holiday homes',	'en',	1),
1404(17,	17,	'Lodges',	'en',	1),
1405(18,	18,	'Homestays',	'en',	1),
1406(19,	19,	'Country houses',	'en',	1),
1407(20,	20,	'Luxury tents',	'en',	1),
1408(21,	21,	'Capsule hotels',	'en',	1),
1409(22,	22,	'Love hotels',	'en',	1),
1410(23,	23,	'Riads',	'en',	1),
1411(24,	24,	'Chalets',	'en',	1),
1412(25,	25,	'Condos',	'en',	1),
1413(26,	26,	'Cottages',	'en',	1),
1414(27,	27,	'Economy hotels',	'en',	1),
1415(28,	28,	'Gites',	'en',	1),
1416(29,	29,	'Health resorts',	'en',	1),
1417(30,	30,	'Cruises',	'en',	1),
1418(31,	31,	'Student accommodation',	'en',	1),
1419(32,	32,	'Guesthouse/bed and breakfast',	'en',	1),
1420(33,	33,	'Serviced apartment',	'en',	1),
1421(34,	34,	'Entire house',	'en',	1),
1422(35,	35,	'Tent',	'en',	1);
1423
1424DROP TABLE IF EXISTS `media`;
1425CREATE TABLE `media` (
1426  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
1427  `model_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
1428  `model_id` bigint(20) unsigned NOT NULL,
1429  `collection_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
1430  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
1431  `file_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
1432  `mime_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
1433  `disk` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
1434  `size` int(10) unsigned NOT NULL,
1435  `manipulations` json NOT NULL,
1436  `custom_properties` json NOT NULL,
1437  `responsive_images` json NOT NULL,
1438  `order_column` int(10) unsigned DEFAULT NULL,
1439  `created_at` timestamp NULL DEFAULT NULL,
1440  `updated_at` timestamp NULL DEFAULT NULL,
1441  PRIMARY KEY (`id`),
1442  KEY `media_model_type_model_id_index` (`model_type`,`model_id`)
1443) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1444
1445INSERT INTO `media` (`id`, `model_type`, `model_id`, `collection_name`, `name`, `file_name`, `mime_type`, `disk`, `size`, `manipulations`, `custom_properties`, `responsive_images`, `order_column`, `created_at`, `updated_at`) VALUES
1446(3,	'Apzback\\Eloquent\\CmAirpaz\\Room',	7,	'room_photo',	'love',	'love.png',	'image/png',	'public',	51195,	'[]',	'{\"generated_conversions\": {\"thumb\": true}}',	'[]',	1,	'2019-03-04 09:45:16',	'2019-03-04 09:45:16'),
1447(4,	'Apzback\\Eloquent\\CmAirpaz\\Room',	7,	'room_photo',	'clipart2577350',	'clipart2577350.png',	'image/png',	'public',	3136,	'[]',	'{\"generated_conversions\": {\"thumb\": true}}',	'[]',	2,	'2019-03-04 09:45:16',	'2019-03-04 09:45:16'),
1448(5,	'Apzback\\Eloquent\\CmAirpaz\\Room',	8,	'room_photo',	'Screenshot from 2019-02-14 18-59-49',	'Screenshot-from-2019-02-14-18-59-49.png',	'image/png',	'public',	230865,	'[]',	'{\"generated_conversions\": {\"thumb\": true}}',	'[]',	1,	'2019-03-04 09:48:47',	'2019-03-04 09:48:47'),
1449(6,	'Apzback\\Eloquent\\CmAirpaz\\Room',	8,	'room_photo',	'Screenshot from 2019-02-14 18-59-42',	'Screenshot-from-2019-02-14-18-59-42.png',	'image/png',	'public',	229095,	'[]',	'{\"generated_conversions\": {\"thumb\": true}}',	'[]',	2,	'2019-03-04 09:48:47',	'2019-03-04 09:48:47'),
1450(7,	'Apzback\\Eloquent\\CmAirpaz\\Room',	9,	'room_photo',	'clipart2577350',	'clipart2577350.png',	'image/png',	'public',	3136,	'[]',	'{\"generated_conversions\": {\"thumb\": true}}',	'[]',	1,	'2019-03-04 09:54:29',	'2019-03-04 09:54:29'),
1451(8,	'Apzback\\Eloquent\\CmAirpaz\\Room',	9,	'room_photo',	'Screenshot from 2019-02-14 18-59-38',	'Screenshot-from-2019-02-14-18-59-38.png',	'image/png',	'public',	229095,	'[]',	'{\"generated_conversions\": {\"thumb\": true}}',	'[]',	2,	'2019-03-04 09:54:29',	'2019-03-04 09:54:29'),
1452(9,	'Apzback\\Eloquent\\CmAirpaz\\Room',	10,	'room_photo',	'love',	'love.png',	'image/png',	'public',	51195,	'[]',	'{\"generated_conversions\": {\"thumb\": true}}',	'[]',	1,	'2019-03-04 10:26:12',	'2019-03-04 10:26:13'),
1453(10,	'Apzback\\Eloquent\\CmAirpaz\\Room',	10,	'room_photo',	'clipart2577350',	'clipart2577350.png',	'image/png',	'public',	3136,	'[]',	'{\"generated_conversions\": {\"thumb\": true}}',	'[]',	2,	'2019-03-04 10:26:12',	'2019-03-04 10:26:13'),
1454(11,	'Apzback\\Eloquent\\CmAirpaz\\Room',	26,	'room_photo',	'WhatsApp Image 2019-03-01 at 1.19.27 PM',	'WhatsApp-Image-2019-03-01-at-1.19.27-PM.jpeg',	'image/jpeg',	'public',	46110,	'[]',	'{\"generated_conversions\": {\"thumb\": true}}',	'[]',	1,	'2019-03-16 15:09:11',	'2019-03-16 15:09:11'),
1455(12,	'Apzback\\Eloquent\\CmAirpaz\\Room',	27,	'room_photo',	'love',	'love.png',	'image/png',	'public',	51195,	'[]',	'{\"generated_conversions\": {\"thumb\": true}}',	'[]',	1,	'2019-03-18 15:29:48',	'2019-03-18 15:29:48'),
1456(13,	'Apzback\\Eloquent\\CmAirpaz\\Hotel',	1,	'hotel_photo',	'Screenshot from 2019-03-09 19-35-31',	'Screenshot-from-2019-03-09-19-35-31.png',	'image/png',	'public',	203579,	'[]',	'{\"generated_conversions\": {\"thumb\": true}}',	'[]',	1,	'2019-03-20 07:54:55',	'2019-03-20 07:54:57'),
1457(14,	'Apzback\\Eloquent\\CmAirpaz\\Hotel',	1,	'hotel_photo',	'love',	'love.png',	'image/png',	'public',	51195,	'[]',	'{\"generated_conversions\": {\"thumb\": true}}',	'[]',	2,	'2019-03-20 07:54:55',	'2019-03-20 07:54:57'),
1458(15,	'Apzback\\Eloquent\\CmAirpaz\\Hotel',	1,	'hotel_photo',	'clipart2577350',	'clipart2577350.png',	'image/png',	'public',	3136,	'[]',	'{\"generated_conversions\": {\"thumb\": true}}',	'[]',	3,	'2019-03-20 07:54:56',	'2019-03-20 07:54:57');
1459
1460DROP TABLE IF EXISTS `migrations`;
1461CREATE TABLE `migrations` (
1462  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
1463  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
1464  `batch` int(11) NOT NULL,
1465  PRIMARY KEY (`id`)
1466) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1467
1468
1469DROP TABLE IF EXISTS `promotions`;
1470CREATE TABLE `promotions` (
1471  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
1472  `promotion_type_id` int(11) NOT NULL,
1473  `discount_type_id` int(11) NOT NULL,
1474  `cancellation_policy_id` int(11) NOT NULL,
1475  `hotel_id` int(11) NOT NULL,
1476  `external_code_id` int(11) NOT NULL,
1477  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
1478  `minimum_days_advance` int(11) NOT NULL,
1479  `maximum_days_advance` int(11) NOT NULL,
1480  `minimum_stay` int(11) NOT NULL,
1481  `maximum_stay` int(11) NOT NULL,
1482  `stay_date_from` date NOT NULL,
1483  `stay_date_to` date NOT NULL,
1484  `sale_date_from` date NOT NULL,
1485  `sale_date_to` date NOT NULL,
1486  `book_day` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL,
1487  `stay_day` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL,
1488  `created_at` timestamp NULL DEFAULT NULL,
1489  `updated_at` timestamp NULL DEFAULT NULL,
1490  PRIMARY KEY (`id`)
1491) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1492
1493INSERT INTO `promotions` (`id`, `promotion_type_id`, `discount_type_id`, `cancellation_policy_id`, `hotel_id`, `external_code_id`, `description`, `minimum_days_advance`, `maximum_days_advance`, `minimum_stay`, `maximum_stay`, `stay_date_from`, `stay_date_to`, `sale_date_from`, `sale_date_to`, `book_day`, `stay_day`, `created_at`, `updated_at`) VALUES
1494(1,	1,	3,	4,	2,	1234,	'Desc',	1,	2,	3,	4,	'2019-04-12',	'2019-04-12',	'2019-04-03',	'2019-04-12',	'1101001',	'1111100',	'2019-04-12 10:52:56',	'2019-04-12 10:52:56'),
1495(2,	1,	3,	4,	2,	1234,	'Desc',	1,	2,	3,	4,	'2019-04-12',	'2019-04-12',	'2019-04-03',	'2019-04-12',	'1101001',	'1111100',	'2019-04-12 10:53:39',	'2019-04-12 10:53:39'),
1496(3,	1,	3,	4,	2,	1234,	'Desc',	1,	2,	3,	4,	'2019-04-12',	'2019-04-12',	'2019-04-03',	'2019-04-12',	'1101001',	'1111100',	NULL,	NULL),
1497(4,	1,	3,	4,	2,	1234,	'Desc',	1,	2,	3,	4,	'2019-04-12',	'2019-03-12',	'2019-04-03',	'2019-04-12',	'1101001',	'1111100',	NULL,	NULL),
1498(5,	1,	3,	4,	2,	1234,	'Desc',	1,	2,	3,	4,	'2019-04-12',	'2019-04-12',	'2019-04-03',	'2019-04-12',	'1101001',	'1111100',	'2019-04-12 10:55:08',	'2019-04-12 10:55:08'),
1499(6,	1,	1,	4,	2,	1234,	'Desc',	1,	2,	3,	4,	'2019-04-12',	'2019-05-12',	'2019-04-03',	'2019-04-12',	'1101001',	'1111100',	'2019-04-12 10:55:42',	'2019-04-15 07:31:20');
1500
1501DROP TABLE IF EXISTS `promotion_details`;
1502CREATE TABLE `promotion_details` (
1503  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
1504  `promotion_id` int(11) NOT NULL,
1505  `parameter` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
1506  `discount_amount` int(11) NOT NULL,
1507  PRIMARY KEY (`id`)
1508) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1509
1510INSERT INTO `promotion_details` (`id`, `promotion_id`, `parameter`, `discount_amount`) VALUES
1511(1,	6,	'First Night',	10);
1512
1513DROP TABLE IF EXISTS `promotion_rate_restrictions`;
1514CREATE TABLE `promotion_rate_restrictions` (
1515  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
1516  `promotion_id` int(11) NOT NULL,
1517  `rate_id` int(11) NOT NULL,
1518  PRIMARY KEY (`id`)
1519) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1520
1521
1522DROP TABLE IF EXISTS `promotion_room_restrictions`;
1523CREATE TABLE `promotion_room_restrictions` (
1524  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
1525  `promotion_id` int(11) NOT NULL,
1526  `room_id` int(11) NOT NULL,
1527  PRIMARY KEY (`id`)
1528) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1529
1530
1531DROP TABLE IF EXISTS `promotion_types`;
1532CREATE TABLE `promotion_types` (
1533  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
1534  `name` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
1535  PRIMARY KEY (`id`)
1536) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1537
1538INSERT INTO `promotion_types` (`id`, `name`) VALUES
1539(1,	'Last Minute'),
1540(2,	'Early Bird');
1541
1542DROP TABLE IF EXISTS `rates`;
1543CREATE TABLE `rates` (
1544  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
1545  `master_rate` int(11) DEFAULT NULL,
1546  `cancellation_policy_id` int(11) DEFAULT NULL,
1547  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
1548  `external_code_id` int(11) DEFAULT NULL,
1549  `booking_start_date` datetime DEFAULT NULL,
1550  `booking_end_date` datetime DEFAULT NULL,
1551  `stay_start_date` date DEFAULT NULL,
1552  `stay_end_date` date DEFAULT NULL,
1553  `limit_per_day` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
1554  `min_length_of_stay` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
1555  `max_length_of_stay` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
1556  `min_day_before_check_in` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
1557  `max_day_before_check_in` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
1558  `added_rate` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
1559  `is_enabled` tinyint(1) DEFAULT NULL,
1560  `is_percentage` tinyint(1) DEFAULT NULL,
1561  `created_at` timestamp NULL DEFAULT NULL,
1562  `updated_at` timestamp NULL DEFAULT NULL,
1563  PRIMARY KEY (`id`)
1564) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1565
1566INSERT INTO `rates` (`id`, `master_rate`, `cancellation_policy_id`, `name`, `external_code_id`, `booking_start_date`, `booking_end_date`, `stay_start_date`, `stay_end_date`, `limit_per_day`, `min_length_of_stay`, `max_length_of_stay`, `min_day_before_check_in`, `max_day_before_check_in`, `added_rate`, `is_enabled`, `is_percentage`, `created_at`, `updated_at`) VALUES
1567(2,	NULL,	5,	'ZeroTwo',	202,	'2019-03-14 00:00:00',	'2019-03-22 00:00:00',	'2019-03-27',	'2019-03-29',	'1',	'3',	NULL,	'4',	NULL,	NULL,	1,	NULL,	'2019-03-22 09:14:57',	'2019-03-22 09:14:57'),
1568(3,	NULL,	5,	'ZeroTwo',	202,	'2019-03-14 00:00:00',	'2019-03-22 00:00:00',	'2019-03-27',	'2019-03-29',	'1',	'3',	NULL,	'4',	NULL,	NULL,	1,	NULL,	'2019-03-22 09:15:52',	'2019-03-22 09:15:52'),
1569(4,	NULL,	5,	'ZeroTwo',	202,	'2019-03-13 00:00:00',	'2019-03-22 00:00:00',	'2019-04-03',	'2019-04-05',	'1',	'3',	NULL,	'4',	NULL,	NULL,	1,	NULL,	'2019-03-22 10:07:14',	'2019-03-22 10:07:14'),
1570(5,	NULL,	5,	'ZeroTwo',	202,	'2019-03-13 00:00:00',	'2019-03-22 00:00:00',	'2019-04-03',	'2019-04-05',	'1',	'3',	NULL,	'4',	NULL,	NULL,	1,	NULL,	'2019-03-22 10:18:36',	'2019-03-22 10:18:36'),
1571(6,	NULL,	5,	'qqq',	111,	'2019-03-01 05:00:00',	'2019-03-02 05:00:00',	'2019-03-03',	'2019-03-04',	'1',	'3',	NULL,	'4',	NULL,	NULL,	1,	NULL,	'2019-03-22 10:39:12',	'2019-03-22 10:39:12'),
1572(7,	NULL,	5,	'qqqueeennn',	111,	'2019-03-01 05:00:00',	'2019-03-02 05:00:00',	'2019-03-03',	'2019-03-04',	'1',	'3',	NULL,	'4',	NULL,	NULL,	1,	NULL,	'2019-03-22 10:41:24',	'2019-04-16 04:25:28');
1573
1574DROP TABLE IF EXISTS `rates_benefit`;
1575CREATE TABLE `rates_benefit` (
1576  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
1577  `rate_id` int(11) NOT NULL,
1578  `benefit_id` int(11) NOT NULL,
1579  `created_at` timestamp NULL DEFAULT NULL,
1580  `updated_at` timestamp NULL DEFAULT NULL,
1581  PRIMARY KEY (`id`)
1582) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1583
1584INSERT INTO `rates_benefit` (`id`, `rate_id`, `benefit_id`, `created_at`, `updated_at`) VALUES
1585(1,	5,	10,	'2019-03-22 10:18:36',	'2019-03-22 10:18:36'),
1586(2,	6,	12,	'2019-03-22 10:39:12',	'2019-03-22 10:39:12'),
1587(3,	7,	9,	'2019-03-22 10:41:24',	'2019-03-22 10:41:24'),
1588(4,	7,	12,	'2019-03-22 10:41:24',	'2019-03-22 10:41:24'),
1589(5,	7,	11,	'2019-03-22 10:41:24',	'2019-03-22 10:41:24');
1590
1591DROP TABLE IF EXISTS `rates_modifier`;
1592CREATE TABLE `rates_modifier` (
1593  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
1594  `room_rate_id` int(11) NOT NULL,
1595  `date` date NOT NULL,
1596  `rate` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
1597  `is_enabled` tinyint(1) NOT NULL,
1598  `created_at` timestamp NULL DEFAULT NULL,
1599  `updated_at` timestamp NULL DEFAULT NULL,
1600  PRIMARY KEY (`id`)
1601) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1602
1603
1604DROP TABLE IF EXISTS `rooms`;
1605CREATE TABLE `rooms` (
1606  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
1607  `hotel_id` int(10) NOT NULL,
1608  `external_code_id` int(11) DEFAULT NULL,
1609  `internal_room_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
1610  `no_of_rooms` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
1611  `standard_rate` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
1612  `mininum_rate` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
1613  `order_priority` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
1614  `max_persons` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
1615  `max_extra_beds` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
1616  `no_of_baby_cots` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
1617  `auto_top_up` tinyint(1) DEFAULT NULL,
1618  `allotment_alert` tinyint(1) DEFAULT NULL,
1619  `allow_children` tinyint(1) DEFAULT NULL,
1620  `rack_rate` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
1621  `room_size` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
1622  `bathroom_count` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
1623  `created_at` timestamp NULL DEFAULT NULL,
1624  `updated_at` timestamp NULL DEFAULT NULL,
1625  PRIMARY KEY (`id`)
1626) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1627
1628INSERT INTO `rooms` (`id`, `hotel_id`, `external_code_id`, `internal_room_name`, `no_of_rooms`, `standard_rate`, `mininum_rate`, `order_priority`, `max_persons`, `max_extra_beds`, `no_of_baby_cots`, `auto_top_up`, `allotment_alert`, `allow_children`, `rack_rate`, `room_size`, `bathroom_count`, `created_at`, `updated_at`) VALUES
1629(1,	1,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	0,	0,	0,	NULL,	NULL,	NULL,	'2019-03-04 09:20:31',	'2019-03-04 09:20:31'),
1630(2,	1,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	0,	0,	0,	NULL,	NULL,	NULL,	'2019-03-04 09:25:41',	'2019-03-04 09:25:41'),
1631(3,	1,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	0,	0,	0,	NULL,	NULL,	NULL,	'2019-03-04 09:26:18',	'2019-03-04 09:26:18'),
1632(4,	1,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	0,	0,	0,	NULL,	NULL,	NULL,	'2019-03-04 09:38:57',	'2019-03-04 09:38:57'),
1633(5,	1,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	0,	0,	0,	NULL,	NULL,	NULL,	'2019-03-04 09:39:33',	'2019-03-04 09:39:33'),
1634(6,	1,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	0,	0,	0,	NULL,	NULL,	NULL,	'2019-03-04 09:43:38',	'2019-03-04 09:43:38'),
1635(7,	1,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	0,	0,	0,	NULL,	NULL,	NULL,	'2019-03-04 09:45:16',	'2019-03-04 09:45:16'),
1636(8,	1,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	0,	0,	0,	NULL,	NULL,	NULL,	'2019-03-04 09:48:46',	'2019-03-04 09:48:46'),
1637(9,	1,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	0,	0,	0,	NULL,	NULL,	NULL,	'2019-03-04 09:54:28',	'2019-03-04 09:54:28'),
1638(10,	1,	1,	'Inferno',	'123',	'455',	NULL,	'1',	NULL,	NULL,	NULL,	0,	0,	0,	NULL,	NULL,	NULL,	'2019-03-04 10:26:12',	'2019-03-05 07:20:03'),
1639(11,	1,	NULL,	'Ibis',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	0,	0,	0,	NULL,	NULL,	NULL,	'2019-03-14 06:01:27',	'2019-03-14 06:01:27'),
1640(12,	1,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	0,	0,	0,	NULL,	NULL,	NULL,	'2019-03-14 06:03:36',	'2019-03-14 06:03:36'),
1641(13,	1,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	0,	0,	0,	NULL,	NULL,	NULL,	'2019-03-14 06:04:34',	'2019-03-14 06:04:34'),
1642(14,	1,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	0,	0,	0,	NULL,	NULL,	NULL,	'2019-03-14 06:16:44',	'2019-03-14 06:16:44'),
1643(15,	1,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	0,	0,	0,	NULL,	NULL,	NULL,	'2019-03-14 06:17:44',	'2019-03-14 06:17:44'),
1644(16,	1,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	0,	0,	0,	NULL,	NULL,	NULL,	'2019-03-14 06:18:06',	'2019-03-14 06:18:06'),
1645(17,	1,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	0,	0,	0,	NULL,	NULL,	NULL,	'2019-03-14 06:22:30',	'2019-03-14 06:22:30'),
1646(18,	1,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	0,	0,	0,	NULL,	NULL,	NULL,	'2019-03-14 06:22:52',	'2019-03-14 06:22:52'),
1647(19,	1,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	0,	0,	0,	NULL,	NULL,	NULL,	'2019-03-14 06:24:13',	'2019-03-14 06:24:13'),
1648(20,	1,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	0,	0,	0,	NULL,	NULL,	NULL,	'2019-03-14 06:27:10',	'2019-03-14 06:27:10'),
1649(21,	1,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	0,	0,	0,	NULL,	NULL,	NULL,	'2019-03-14 06:32:13',	'2019-03-14 06:32:13'),
1650(22,	1,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	0,	0,	0,	NULL,	NULL,	NULL,	'2019-03-14 06:34:52',	'2019-03-14 06:34:52'),
1651(23,	1,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	0,	0,	0,	NULL,	NULL,	NULL,	'2019-03-14 06:41:00',	'2019-03-14 06:41:00'),
1652(24,	1,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	0,	0,	0,	NULL,	NULL,	NULL,	'2019-03-14 06:42:21',	'2019-03-14 06:42:21'),
1653(25,	1,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	0,	0,	0,	NULL,	NULL,	NULL,	'2019-03-14 06:44:51',	'2019-03-14 06:44:51'),
1654(26,	1,	2,	'ZeroTwo',	'2',	'2.00',	NULL,	'2',	'2',	'2',	'2',	1,	1,	0,	'2',	'2',	'2',	'2019-03-16 15:09:10',	'2019-03-18 15:17:12'),
1655(27,	1,	1,	'ZerOne',	'01',	'0.1',	NULL,	'1',	'1',	'1',	'1',	0,	0,	1,	'0.1',	'1',	'1',	'2019-03-18 15:29:48',	'2019-03-18 18:57:54'),
1656(28,	1,	3,	'ZeroThree',	'03',	'03',	NULL,	'03',	'03',	'03',	'03',	1,	1,	0,	'03',	'03',	'03',	'2019-03-18 19:00:01',	'2019-03-18 19:00:01'),
1657(29,	1,	3,	'ZeroThree :)',	'03',	'03',	NULL,	'03',	'03',	'03',	'03',	1,	1,	0,	'03',	'03',	'03',	'2019-03-18 19:01:02',	'2019-03-19 04:23:14'),
1658(30,	1,	0,	'Zero',	'0',	'0',	NULL,	'0',	'0',	'0',	'0',	1,	1,	0,	'0',	'0',	'00',	'2019-03-19 04:25:25',	'2019-03-19 04:25:25'),
1659(31,	1,	0,	'0',	'0',	'0',	NULL,	NULL,	'0',	'0',	'00',	0,	0,	0,	NULL,	NULL,	NULL,	'2019-03-19 04:28:02',	'2019-03-19 04:51:56'),
1660(32,	1,	123,	'Jefferson room',	'1',	'2',	NULL,	NULL,	'1',	'2',	'3',	0,	0,	0,	'4',	'5',	'1',	NULL,	NULL);
1661
1662DROP TABLE IF EXISTS `room_bed`;
1663CREATE TABLE `room_bed` (
1664  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
1665  PRIMARY KEY (`id`)
1666) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1667
1668INSERT INTO `room_bed` (`id`) VALUES
1669(19),
1670(20),
1671(21),
1672(22),
1673(23),
1674(24),
1675(25),
1676(26),
1677(27);
1678
1679DROP TABLE IF EXISTS `room_bed_configurations`;
1680CREATE TABLE `room_bed_configurations` (
1681  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
1682  `room_bed_id` int(10) unsigned NOT NULL,
1683  `configuration_id` int(11) NOT NULL,
1684  `room_id` int(11) NOT NULL,
1685  `count` int(11) NOT NULL,
1686  `created_at` timestamp NULL DEFAULT NULL,
1687  `updated_at` timestamp NULL DEFAULT NULL,
1688  PRIMARY KEY (`id`),
1689  KEY `room_bed_id` (`room_bed_id`)
1690) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1691
1692INSERT INTO `room_bed_configurations` (`id`, `room_bed_id`, `configuration_id`, `room_id`, `count`, `created_at`, `updated_at`) VALUES
1693(7,	3,	1,	25,	1,	'2019-03-14 06:44:51',	'2019-03-14 06:44:51'),
1694(8,	4,	1,	25,	1,	'2019-03-14 06:44:51',	'2019-03-14 06:44:51'),
1695(9,	5,	2,	25,	5,	'2019-03-14 06:44:51',	'2019-03-14 06:44:51'),
1696(69,	19,	1,	27,	1,	'2019-03-18 18:57:54',	'2019-03-18 18:57:54'),
1697(70,	22,	1,	27,	5,	'2019-03-18 18:57:54',	'2019-03-18 18:57:54'),
1698(71,	20,	2,	27,	1,	'2019-03-18 18:57:54',	'2019-03-18 18:57:54'),
1699(72,	20,	2,	27,	3,	'2019-03-18 18:57:54',	'2019-03-18 18:57:54'),
1700(73,	22,	2,	27,	6,	'2019-03-18 18:57:55',	'2019-03-18 18:57:55'),
1701(164,	19,	1,	29,	1,	'2019-03-19 04:23:14',	'2019-03-19 04:23:14'),
1702(165,	22,	1,	29,	1,	'2019-03-19 04:23:14',	'2019-03-19 04:23:14'),
1703(166,	22,	1,	29,	7,	'2019-03-19 04:23:14',	'2019-03-19 04:23:14'),
1704(167,	19,	1,	29,	3,	'2019-03-19 04:23:14',	'2019-03-19 04:23:14'),
1705(168,	21,	2,	29,	4,	'2019-03-19 04:23:14',	'2019-03-19 04:23:14'),
1706(169,	25,	2,	29,	7,	'2019-03-19 04:23:14',	'2019-03-19 04:23:14'),
1707(170,	24,	2,	29,	5,	'2019-03-19 04:23:14',	'2019-03-19 04:23:14'),
1708(171,	19,	3,	29,	7,	'2019-03-19 04:23:14',	'2019-03-19 04:23:14'),
1709(172,	23,	3,	29,	4,	'2019-03-19 04:23:14',	'2019-03-19 04:23:14'),
1710(173,	21,	1,	30,	2,	'2019-03-19 04:25:25',	'2019-03-19 04:25:25'),
1711(174,	23,	2,	30,	4,	'2019-03-19 04:25:25',	'2019-03-19 04:25:25'),
1712(175,	24,	2,	30,	7,	'2019-03-19 04:25:25',	'2019-03-19 04:25:25'),
1713(176,	25,	2,	30,	3,	'2019-03-19 04:25:25',	'2019-03-19 04:25:25'),
1714(177,	19,	3,	30,	1,	'2019-03-19 04:25:25',	'2019-03-19 04:25:25'),
1715(178,	20,	3,	30,	1,	'2019-03-19 04:25:25',	'2019-03-19 04:25:25'),
1716(179,	21,	4,	30,	1,	'2019-03-19 04:25:25',	'2019-03-19 04:25:25'),
1717(180,	22,	4,	30,	2,	'2019-03-19 04:25:25',	'2019-03-19 04:25:25'),
1718(310,	21,	1,	31,	1,	'2019-03-19 04:51:56',	'2019-03-19 04:51:56'),
1719(311,	22,	1,	31,	3,	'2019-03-19 04:51:56',	'2019-03-19 04:51:56'),
1720(312,	24,	1,	31,	5,	'2019-03-19 04:51:56',	'2019-03-19 04:51:56'),
1721(313,	19,	1,	31,	1,	'2019-03-19 04:51:56',	'2019-03-19 04:51:56'),
1722(314,	25,	1,	31,	4,	'2019-03-19 04:51:56',	'2019-03-19 04:51:56'),
1723(315,	23,	2,	31,	1,	'2019-03-19 04:51:56',	'2019-03-19 04:51:56'),
1724(316,	20,	2,	31,	7,	'2019-03-19 04:51:56',	'2019-03-19 04:51:56'),
1725(317,	21,	2,	31,	1,	'2019-03-19 04:51:56',	'2019-03-19 04:51:56'),
1726(318,	21,	3,	31,	1,	'2019-03-19 04:51:56',	'2019-03-19 04:51:56'),
1727(319,	23,	3,	31,	1,	'2019-03-19 04:51:56',	'2019-03-19 04:51:56'),
1728(320,	24,	3,	31,	6,	'2019-03-19 04:51:57',	'2019-03-19 04:51:57'),
1729(321,	20,	1,	32,	4,	'2019-04-01 10:05:10',	'2019-04-01 10:05:10'),
1730(322,	19,	1,	32,	2,	'2019-04-01 10:05:10',	'2019-04-01 10:05:10'),
1731(323,	21,	2,	32,	1,	'2019-04-01 10:05:10',	'2019-04-01 10:05:10'),
1732(324,	22,	2,	32,	2,	'2019-04-01 10:05:10',	'2019-04-01 10:05:10');
1733
1734DROP TABLE IF EXISTS `room_bed_translations`;
1735CREATE TABLE `room_bed_translations` (
1736  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
1737  `room_bed_id` int(10) unsigned DEFAULT NULL,
1738  `language_id` int(11) DEFAULT NULL,
1739  `locale` char(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
1740  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
1741  `description_imperial` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
1742  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
1743  `created_at` timestamp NULL DEFAULT NULL,
1744  `updated_at` timestamp NULL DEFAULT NULL,
1745  PRIMARY KEY (`id`),
1746  KEY `room_bed_id` (`room_bed_id`)
1747) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1748
1749INSERT INTO `room_bed_translations` (`id`, `room_bed_id`, `language_id`, `locale`, `name`, `description_imperial`, `description`, `created_at`, `updated_at`) VALUES
1750(3,	3,	1,	'en',	'King',	'King Imperial',	'King',	'2019-03-14 06:25:12',	'2019-03-14 06:25:12'),
1751(4,	4,	1,	'en',	'Queen',	'Queen Imperial',	'Queen',	'2019-03-14 06:25:25',	'2019-03-14 06:25:25'),
1752(5,	5,	1,	'en',	'Double',	'Double Imperial',	'Double',	'2019-03-14 06:25:36',	'2019-03-14 06:25:36'),
1753(6,	6,	1,	'en',	'Single',	'Single Imperial',	'Single',	'2019-03-14 06:25:48',	'2019-03-14 06:25:48'),
1754(7,	8,	1,	'en',	'Triple',	'Triple Imperial',	'Triple',	'2019-03-14 07:46:57',	'2019-03-14 07:46:57'),
1755(8,	9,	1,	'en',	'Triple',	'Triple Imperial',	'Triple',	'2019-03-14 07:48:46',	'2019-03-14 07:48:46'),
1756(9,	10,	1,	'en',	'Triple',	'Triple Imperial',	'Triple',	'2019-03-14 07:49:05',	'2019-03-14 07:49:05'),
1757(10,	11,	1,	'en',	'Triple',	'Triple Imperial',	'Triple',	'2019-03-14 07:49:20',	'2019-03-14 07:49:20'),
1758(11,	12,	1,	'en',	'Triple',	'Triple Imperial',	'Triple',	'2019-03-14 07:49:26',	'2019-03-14 07:49:26'),
1759(12,	13,	1,	'en',	'Triple',	'Triple Imperial',	'Triple',	'2019-03-14 07:49:49',	'2019-03-14 07:49:49'),
1760(13,	14,	1,	'en',	'Triple',	'Triple Imperial',	'Triple',	'2019-03-14 07:50:36',	'2019-03-14 07:50:36'),
1761(14,	15,	1,	'en',	'Triple',	'Triple Imperial',	'Triple',	'2019-03-14 07:51:09',	'2019-03-14 07:51:09'),
1762(15,	16,	1,	'en',	'Ultra',	'Ultra Imperial',	'Ultra',	'2019-03-14 07:51:59',	'2019-03-14 07:51:59'),
1763(16,	18,	1,	'en',	'Ultra',	'Ultra Imperial',	'Ultra',	'2019-03-14 07:57:21',	'2019-03-14 07:57:21'),
1764(17,	18,	NULL,	'en',	'Ultra',	'Ultra Imperial',	'Ultra',	'2019-03-14 07:57:21',	'2019-03-14 07:57:21'),
1765(18,	18,	NULL,	NULL,	'Test',	'Test',	'Test',	'2019-03-14 08:24:18',	'2019-03-14 08:24:18'),
1766(19,	19,	1,	'en',	'King',	'10x10',	'none',	'2019-03-18 15:22:36',	'2019-03-18 15:22:36'),
1767(20,	19,	NULL,	'en',	'King',	'10x10',	'none',	'2019-03-18 15:22:39',	'2019-03-18 15:22:39'),
1768(21,	20,	1,	'en',	'King',	'12x12',	'none',	'2019-03-18 15:22:53',	'2019-03-18 15:22:53'),
1769(22,	20,	NULL,	'en',	'King',	'12x12',	'none',	'2019-03-18 15:22:53',	'2019-03-18 15:22:53'),
1770(23,	21,	1,	'en',	'Queen',	'7x7',	'none',	'2019-03-18 15:23:09',	'2019-03-18 15:23:09'),
1771(24,	21,	NULL,	'en',	'Queen',	'7x7',	'none',	'2019-03-18 15:23:09',	'2019-03-18 15:23:09'),
1772(25,	22,	1,	'en',	'Queen',	'5x5',	'none',	'2019-03-18 15:23:38',	'2019-03-18 15:23:38'),
1773(26,	22,	NULL,	'en',	'Queen',	'5x5',	'none',	'2019-03-18 15:23:38',	'2019-03-18 15:23:38'),
1774(27,	23,	1,	'en',	'Double',	'3x3',	NULL,	'2019-03-18 15:24:13',	'2019-03-18 15:24:13'),
1775(28,	23,	NULL,	'en',	'Double',	'3x3',	NULL,	'2019-03-18 15:24:13',	'2019-03-18 15:24:13'),
1776(29,	24,	1,	'en',	'Single',	'2x2',	NULL,	'2019-03-18 15:24:35',	'2019-03-18 15:24:35'),
1777(30,	24,	NULL,	'en',	'Single',	'2x2',	NULL,	'2019-03-18 15:24:35',	'2019-03-18 15:24:35'),
1778(31,	25,	1,	'en',	'Solo',	'1x1',	NULL,	'2019-03-18 15:24:41',	'2019-03-18 15:24:41'),
1779(32,	25,	NULL,	'en',	'Solo',	'1x1',	NULL,	'2019-03-18 15:24:41',	'2019-03-18 15:24:41'),
1780(33,	26,	1,	'en',	'Solo',	'1 x 2',	'Testing',	'2019-03-20 11:36:44',	'2019-03-20 11:36:44'),
1781(34,	26,	NULL,	'en',	'Solo',	'1 x 2',	'Testing',	'2019-03-20 11:36:44',	'2019-03-20 11:36:44'),
1782(35,	27,	1,	'en',	'SoloDouble',	'SoloDuo',	'DuoSolo',	'2019-03-21 06:33:47',	'2019-03-21 06:33:47'),
1783(36,	27,	6,	NULL,	'IchiNi',	'Nicihi',	'Ichini',	'2019-03-21 06:35:26',	'2019-03-21 06:35:26');
1784
1785DROP TABLE IF EXISTS `room_facilities`;
1786CREATE TABLE `room_facilities` (
1787  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
1788  `room_facility_group_id` int(11) NOT NULL,
1789  `created_at` timestamp NULL DEFAULT NULL,
1790  `updated_at` timestamp NULL DEFAULT NULL,
1791  PRIMARY KEY (`id`)
1792) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1793
1794INSERT INTO `room_facilities` (`id`, `room_facility_group_id`, `created_at`, `updated_at`) VALUES
1795(1,	9,	'2019-03-27 07:57:47',	'2019-03-27 07:57:47'),
1796(2,	9,	'2019-03-27 07:57:47',	'2019-03-27 07:57:47'),
1797(3,	9,	'2019-03-27 07:57:48',	'2019-03-27 07:57:48'),
1798(4,	7,	'2019-03-27 07:57:48',	'2019-03-27 07:57:48'),
1799(5,	5,	'2019-03-27 07:57:49',	'2019-03-27 07:57:49'),
1800(6,	9,	'2019-03-27 07:57:49',	'2019-03-27 07:57:49'),
1801(7,	5,	'2019-03-27 07:57:49',	'2019-03-27 07:57:49'),
1802(8,	9,	'2019-03-27 07:57:49',	'2019-03-27 07:57:49'),
1803(9,	9,	'2019-03-27 07:57:49',	'2019-03-27 07:57:49'),
1804(10,	7,	'2019-03-27 07:57:50',	'2019-03-27 07:57:50'),
1805(11,	9,	'2019-03-27 07:57:50',	'2019-03-27 07:57:50'),
1806(12,	5,	'2019-03-27 07:57:50',	'2019-03-27 07:57:50'),
1807(13,	9,	'2019-03-27 07:57:50',	'2019-03-27 07:57:50'),
1808(14,	9,	'2019-03-27 07:57:51',	'2019-03-27 07:57:51'),
1809(15,	11,	'2019-03-27 07:57:51',	'2019-03-27 07:57:51'),
1810(16,	5,	'2019-03-27 07:57:52',	'2019-03-27 07:57:52'),
1811(17,	9,	'2019-03-27 07:57:52',	'2019-03-27 07:57:52'),
1812(18,	11,	'2019-03-27 07:57:52',	'2019-03-27 07:57:52'),
1813(19,	2,	'2019-03-27 07:57:52',	'2019-03-27 07:57:52'),
1814(20,	2,	'2019-03-27 07:57:53',	'2019-03-27 07:57:53'),
1815(21,	9,	'2019-03-27 07:57:53',	'2019-03-27 07:57:53'),
1816(22,	9,	'2019-03-27 07:57:54',	'2019-03-27 07:57:54'),
1817(23,	9,	'2019-03-27 07:57:54',	'2019-03-27 07:57:54'),
1818(24,	9,	'2019-03-27 07:57:55',	'2019-03-27 07:57:55'),
1819(25,	9,	'2019-03-27 07:57:56',	'2019-03-27 07:57:56'),
1820(26,	2,	'2019-03-27 07:57:56',	'2019-03-27 07:57:56'),
1821(27,	9,	'2019-03-27 07:57:56',	'2019-03-27 07:57:56'),
1822(28,	11,	'2019-03-27 07:57:56',	'2019-03-27 07:57:56'),
1823(29,	11,	'2019-03-27 07:57:57',	'2019-03-27 07:57:57'),
1824(30,	5,	'2019-03-27 07:57:57',	'2019-03-27 07:57:57'),
1825(31,	10,	'2019-03-27 07:57:57',	'2019-03-27 07:57:57'),
1826(32,	5,	'2019-03-27 07:57:57',	'2019-03-27 07:57:57'),
1827(33,	2,	'2019-03-27 07:57:57',	'2019-03-27 07:57:57'),
1828(34,	2,	'2019-03-27 07:57:58',	'2019-03-27 07:57:58'),
1829(35,	9,	'2019-03-27 07:57:58',	'2019-03-27 07:57:58'),
1830(36,	7,	'2019-03-27 07:57:58',	'2019-03-27 07:57:58'),
1831(37,	7,	'2019-03-27 07:57:58',	'2019-03-27 07:57:58'),
1832(38,	2,	'2019-03-27 07:57:58',	'2019-03-27 07:57:58'),
1833(39,	11,	'2019-03-27 07:57:59',	'2019-03-27 07:57:59'),
1834(40,	9,	'2019-03-27 07:57:59',	'2019-03-27 07:57:59'),
1835(41,	9,	'2019-03-27 07:57:59',	'2019-03-27 07:57:59'),
1836(42,	5,	'2019-03-27 07:57:59',	'2019-03-27 07:57:59'),
1837(43,	8,	'2019-03-27 07:58:00',	'2019-03-27 07:58:00'),
1838(44,	2,	'2019-03-27 07:58:00',	'2019-03-27 07:58:00'),
1839(45,	2,	'2019-03-27 07:58:01',	'2019-03-27 07:58:01'),
1840(46,	7,	'2019-03-27 07:58:01',	'2019-03-27 07:58:01'),
1841(47,	2,	'2019-03-27 07:58:01',	'2019-03-27 07:58:01'),
1842(48,	2,	'2019-03-27 07:58:02',	'2019-03-27 07:58:02'),
1843(49,	2,	'2019-03-27 07:58:02',	'2019-03-27 07:58:02'),
1844(50,	7,	'2019-03-27 07:58:02',	'2019-03-27 07:58:02'),
1845(51,	7,	'2019-03-27 07:58:03',	'2019-03-27 07:58:03'),
1846(52,	8,	'2019-03-27 07:58:03',	'2019-03-27 07:58:03'),
1847(53,	2,	'2019-03-27 07:58:03',	'2019-03-27 07:58:03'),
1848(54,	9,	'2019-03-27 07:58:03',	'2019-03-27 07:58:03'),
1849(55,	2,	'2019-03-27 07:58:03',	'2019-03-27 07:58:03'),
1850(56,	5,	'2019-03-27 07:58:04',	'2019-03-27 07:58:04'),
1851(57,	10,	'2019-03-27 07:58:04',	'2019-03-27 07:58:04'),
1852(58,	2,	'2019-03-27 07:58:04',	'2019-03-27 07:58:04'),
1853(59,	9,	'2019-03-27 07:58:04',	'2019-03-27 07:58:04'),
1854(60,	9,	'2019-03-27 07:58:05',	'2019-03-27 07:58:05'),
1855(61,	7,	'2019-03-27 07:58:05',	'2019-03-27 07:58:05'),
1856(62,	7,	'2019-03-27 07:58:05',	'2019-03-27 07:58:05'),
1857(63,	9,	'2019-03-27 07:58:06',	'2019-03-27 07:58:06'),
1858(64,	8,	'2019-03-27 07:58:06',	'2019-03-27 07:58:06'),
1859(65,	9,	'2019-03-27 07:58:07',	'2019-03-27 07:58:07'),
1860(66,	5,	'2019-03-27 07:58:07',	'2019-03-27 07:58:07'),
1861(67,	5,	'2019-03-27 07:58:07',	'2019-03-27 07:58:07'),
1862(68,	11,	'2019-03-27 07:58:08',	'2019-03-27 07:58:08'),
1863(69,	7,	'2019-03-27 07:58:08',	'2019-03-27 07:58:08'),
1864(70,	11,	'2019-03-27 07:58:08',	'2019-03-27 07:58:08'),
1865(71,	2,	'2019-03-27 07:58:09',	'2019-03-27 07:58:09'),
1866(72,	9,	'2019-03-27 07:58:09',	'2019-03-27 07:58:09'),
1867(73,	9,	'2019-03-27 07:58:09',	'2019-03-27 07:58:09'),
1868(74,	9,	'2019-03-27 07:58:10',	'2019-03-27 07:58:10'),
1869(75,	5,	'2019-03-27 07:58:10',	'2019-03-27 07:58:10'),
1870(76,	5,	'2019-03-27 07:58:11',	'2019-03-27 07:58:11'),
1871(77,	5,	'2019-03-27 07:58:11',	'2019-03-27 07:58:11'),
1872(78,	5,	'2019-03-27 07:58:12',	'2019-03-27 07:58:12'),
1873(79,	2,	'2019-03-27 07:58:12',	'2019-03-27 07:58:12'),
1874(80,	7,	'2019-03-27 07:58:13',	'2019-03-27 07:58:13'),
1875(81,	7,	'2019-03-27 07:58:13',	'2019-03-27 07:58:13'),
1876(82,	7,	'2019-03-27 07:58:13',	'2019-03-27 07:58:13'),
1877(83,	7,	'2019-03-27 07:58:14',	'2019-03-27 07:58:14'),
1878(84,	7,	'2019-03-27 07:58:14',	'2019-03-27 07:58:14'),
1879(85,	7,	'2019-03-27 07:58:14',	'2019-03-27 07:58:14'),
1880(86,	7,	'2019-03-27 07:58:14',	'2019-03-27 07:58:14'),
1881(87,	8,	'2019-03-27 07:58:15',	'2019-03-27 07:58:15'),
1882(88,	8,	'2019-03-27 07:58:15',	'2019-03-27 07:58:15'),
1883(89,	8,	'2019-03-27 07:58:15',	'2019-03-27 07:58:15'),
1884(90,	8,	'2019-03-27 07:58:15',	'2019-03-27 07:58:15'),
1885(91,	8,	'2019-03-27 07:58:16',	'2019-03-27 07:58:16'),
1886(92,	8,	'2019-03-27 07:58:16',	'2019-03-27 07:58:16'),
1887(93,	7,	'2019-03-27 07:58:16',	'2019-03-27 07:58:16'),
1888(94,	9,	'2019-03-27 07:58:16',	'2019-03-27 07:58:16'),
1889(95,	9,	'2019-03-27 07:58:17',	'2019-03-27 07:58:17'),
1890(96,	7,	'2019-03-27 07:58:17',	'2019-03-27 07:58:17'),
1891(97,	5,	'2019-03-27 07:58:18',	'2019-03-27 07:58:18'),
1892(98,	8,	'2019-03-27 07:58:18',	'2019-03-27 07:58:18'),
1893(99,	8,	'2019-03-27 07:58:18',	'2019-03-27 07:58:18'),
1894(100,	8,	'2019-03-27 07:58:19',	'2019-03-27 07:58:19'),
1895(101,	11,	'2019-03-27 07:58:19',	'2019-03-27 07:58:19'),
1896(102,	5,	'2019-03-27 07:58:19',	'2019-03-27 07:58:19'),
1897(103,	5,	'2019-03-27 07:58:19',	'2019-03-27 07:58:19'),
1898(104,	5,	'2019-03-27 07:58:20',	'2019-03-27 07:58:20'),
1899(105,	5,	'2019-03-27 07:58:21',	'2019-03-27 07:58:21'),
1900(106,	1,	'2019-03-27 07:58:21',	'2019-03-27 07:58:21'),
1901(107,	1,	'2019-03-27 07:58:21',	'2019-03-27 07:58:21'),
1902(108,	1,	'2019-03-27 07:58:21',	'2019-03-27 07:58:21'),
1903(109,	1,	'2019-03-27 07:58:22',	'2019-03-27 07:58:22'),
1904(110,	3,	'2019-03-27 07:58:22',	'2019-03-27 07:58:22'),
1905(111,	3,	'2019-03-27 07:58:22',	'2019-03-27 07:58:22'),
1906(112,	3,	'2019-03-27 07:58:23',	'2019-03-27 07:58:23'),
1907(113,	9,	'2019-03-27 07:58:23',	'2019-03-27 07:58:23'),
1908(114,	9,	'2019-03-27 07:58:24',	'2019-03-27 07:58:24'),
1909(115,	2,	'2019-03-27 07:58:25',	'2019-03-27 07:58:25'),
1910(116,	4,	'2019-03-27 07:58:25',	'2019-03-27 07:58:25'),
1911(117,	4,	'2019-03-27 07:58:26',	'2019-03-27 07:58:26'),
1912(118,	4,	'2019-03-27 07:58:26',	'2019-03-27 07:58:26'),
1913(119,	4,	'2019-03-27 07:58:26',	'2019-03-27 07:58:26'),
1914(120,	9,	'2019-03-27 07:58:27',	'2019-03-27 07:58:27'),
1915(121,	1,	'2019-03-27 07:58:27',	'2019-03-27 07:58:27'),
1916(122,	1,	'2019-03-27 07:58:27',	'2019-03-27 07:58:27'),
1917(123,	1,	'2019-03-27 07:58:28',	'2019-03-27 07:58:28'),
1918(124,	1,	'2019-03-27 07:58:29',	'2019-03-27 07:58:29'),
1919(125,	1,	'2019-03-27 07:58:30',	'2019-03-27 07:58:30'),
1920(126,	1,	'2019-03-27 07:58:30',	'2019-03-27 07:58:30'),
1921(127,	1,	'2019-03-27 07:58:30',	'2019-03-27 07:58:30'),
1922(128,	1,	'2019-03-27 07:58:30',	'2019-03-27 07:58:30'),
1923(129,	9,	'2019-03-27 07:58:30',	'2019-03-27 07:58:30'),
1924(130,	9,	'2019-03-27 07:58:31',	'2019-03-27 07:58:31'),
1925(131,	9,	'2019-03-27 07:58:31',	'2019-03-27 07:58:31'),
1926(132,	9,	'2019-03-27 07:58:31',	'2019-03-27 07:58:31'),
1927(133,	9,	'2019-03-27 07:58:31',	'2019-03-27 07:58:31'),
1928(134,	9,	'2019-03-27 07:58:31',	'2019-03-27 07:58:31'),
1929(135,	9,	'2019-03-27 07:58:32',	'2019-03-27 07:58:32'),
1930(136,	9,	'2019-03-27 07:58:33',	'2019-03-27 07:58:33'),
1931(137,	9,	'2019-03-27 07:58:33',	'2019-03-27 07:58:33'),
1932(138,	5,	'2019-03-27 07:58:33',	'2019-03-27 07:58:33'),
1933(139,	5,	'2019-03-27 07:58:34',	'2019-03-27 07:58:34'),
1934(140,	5,	'2019-03-27 07:58:34',	'2019-03-27 07:58:34'),
1935(141,	5,	'2019-03-27 07:58:34',	'2019-03-27 07:58:34'),
1936(142,	9,	'2019-03-27 07:58:34',	'2019-03-27 07:58:34'),
1937(143,	5,	'2019-03-27 07:58:34',	'2019-03-27 07:58:34'),
1938(144,	7,	'2019-03-27 07:58:35',	'2019-03-27 07:58:35'),
1939(145,	7,	'2019-03-27 07:58:35',	'2019-03-27 07:58:35'),
1940(146,	7,	'2019-03-27 07:58:35',	'2019-03-27 07:58:35'),
1941(147,	9,	'2019-03-27 07:58:35',	'2019-03-27 07:58:35'),
1942(148,	2,	'2019-03-27 07:58:36',	'2019-03-27 07:58:36'),
1943(149,	2,	'2019-03-27 07:58:36',	'2019-03-27 07:58:36'),
1944(150,	2,	'2019-03-27 07:58:37',	'2019-03-27 07:58:37'),
1945(151,	2,	'2019-03-27 07:58:37',	'2019-03-27 07:58:37'),
1946(152,	2,	'2019-03-27 07:58:37',	'2019-03-27 07:58:37'),
1947(153,	9,	'2019-03-27 07:58:37',	'2019-03-27 07:58:37'),
1948(154,	9,	'2019-03-27 07:58:38',	'2019-03-27 07:58:38'),
1949(155,	9,	'2019-03-27 07:58:38',	'2019-03-27 07:58:38'),
1950(156,	9,	'2019-03-27 07:58:38',	'2019-03-27 07:58:38'),
1951(157,	9,	'2019-03-27 07:58:38',	'2019-03-27 07:58:38'),
1952(158,	9,	'2019-03-27 07:58:38',	'2019-03-27 07:58:38'),
1953(159,	9,	'2019-03-27 07:58:39',	'2019-03-27 07:58:39'),
1954(160,	1,	'2019-03-27 07:58:39',	'2019-03-27 07:58:39'),
1955(161,	8,	'2019-03-27 07:58:39',	'2019-03-27 07:58:39'),
1956(162,	8,	'2019-03-27 07:58:39',	'2019-03-27 07:58:39'),
1957(163,	7,	'2019-03-27 07:58:39',	'2019-03-27 07:58:39'),
1958(164,	7,	'2019-03-27 07:58:39',	'2019-03-27 07:58:39'),
1959(165,	7,	'2019-03-27 07:58:40',	'2019-03-27 07:58:40'),
1960(166,	11,	'2019-03-27 07:58:40',	'2019-03-27 07:58:40'),
1961(167,	11,	'2019-03-27 07:58:40',	'2019-03-27 07:58:40'),
1962(168,	11,	'2019-03-27 07:58:40',	'2019-03-27 07:58:40'),
1963(169,	11,	'2019-03-27 07:58:40',	'2019-03-27 07:58:40'),
1964(170,	6,	'2019-03-27 07:58:40',	'2019-03-27 07:58:40'),
1965(171,	6,	'2019-03-27 07:58:41',	'2019-03-27 07:58:41'),
1966(172,	6,	'2019-03-27 07:58:41',	'2019-03-27 07:58:41'),
1967(173,	7,	'2019-03-27 07:58:41',	'2019-03-27 07:58:41'),
1968(174,	7,	'2019-03-27 07:58:41',	'2019-03-27 07:58:41'),
1969(175,	11,	'2019-03-27 07:58:41',	'2019-03-27 07:58:41'),
1970(176,	7,	'2019-03-27 07:58:42',	'2019-03-27 07:58:42'),
1971(177,	10,	'2019-03-27 07:58:42',	'2019-03-27 07:58:42'),
1972(178,	2,	'2019-03-27 07:58:42',	'2019-03-27 07:58:42'),
1973(179,	10,	'2019-03-27 07:58:42',	'2019-03-27 07:58:42'),
1974(180,	10,	'2019-03-27 07:58:42',	'2019-03-27 07:58:42'),
1975(181,	10,	'2019-03-27 07:58:42',	'2019-03-27 07:58:42'),
1976(182,	10,	'2019-03-27 07:58:43',	'2019-03-27 07:58:43'),
1977(183,	7,	'2019-03-27 07:58:43',	'2019-03-27 07:58:43'),
1978(184,	5,	'2019-03-27 07:58:43',	'2019-03-27 07:58:43'),
1979(185,	5,	'2019-03-27 07:58:43',	'2019-03-27 07:58:43'),
1980(186,	5,	'2019-03-27 07:58:43',	'2019-03-27 07:58:43'),
1981(187,	7,	'2019-03-27 07:58:44',	'2019-03-27 07:58:44'),
1982(188,	9,	'2019-03-27 07:58:44',	'2019-03-27 07:58:44'),
1983(189,	9,	'2019-03-27 07:58:44',	'2019-03-27 07:58:44'),
1984(190,	9,	'2019-03-27 07:58:44',	'2019-03-27 07:58:44'),
1985(191,	9,	'2019-03-27 07:58:45',	'2019-03-27 07:58:45'),
1986(192,	7,	'2019-03-27 07:58:45',	'2019-03-27 07:58:45'),
1987(193,	9,	'2019-03-27 07:58:46',	'2019-03-27 07:58:46'),
1988(194,	9,	'2019-03-27 07:58:46',	'2019-03-27 07:58:46'),
1989(195,	9,	'2019-03-27 07:58:46',	'2019-03-27 07:58:46'),
1990(196,	11,	'2019-03-27 07:58:46',	'2019-03-27 07:58:46'),
1991(197,	11,	'2019-03-27 07:58:46',	'2019-03-27 07:58:46'),
1992(198,	3,	'2019-03-27 07:58:47',	'2019-03-27 07:58:47'),
1993(199,	2,	'2019-03-27 07:58:47',	'2019-03-27 07:58:47');
1994
1995DROP TABLE IF EXISTS `room_facility_group`;
1996CREATE TABLE `room_facility_group` (
1997  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
1998  `created_at` timestamp NULL DEFAULT NULL,
1999  `updated_at` timestamp NULL DEFAULT NULL,
2000  PRIMARY KEY (`id`)
2001) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2002
2003INSERT INTO `room_facility_group` (`id`, `created_at`, `updated_at`) VALUES
2004(1,	'2019-03-27 07:44:31',	'2019-03-27 07:44:31'),
2005(2,	'2019-03-27 07:44:32',	'2019-03-27 07:44:32'),
2006(3,	'2019-03-27 07:44:32',	'2019-03-27 07:44:32'),
2007(4,	'2019-03-27 07:44:32',	'2019-03-27 07:44:32'),
2008(5,	'2019-03-27 07:44:32',	'2019-03-27 07:44:32'),
2009(6,	'2019-03-27 07:44:32',	'2019-03-27 07:44:32'),
2010(7,	'2019-03-27 07:44:33',	'2019-03-27 07:44:33'),
2011(8,	'2019-03-27 07:44:33',	'2019-03-27 07:44:33'),
2012(9,	'2019-03-27 07:44:33',	'2019-03-27 07:44:33'),
2013(10,	'2019-03-27 07:44:33',	'2019-03-27 07:44:33'),
2014(11,	'2019-03-27 07:44:33',	'2019-03-27 07:44:33');
2015
2016DROP TABLE IF EXISTS `room_facility_group_translations`;
2017CREATE TABLE `room_facility_group_translations` (
2018  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
2019  `room_facility_group_id` int(10) unsigned NOT NULL,
2020  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
2021  `locale` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
2022  `created_at` timestamp NULL DEFAULT NULL,
2023  `updated_at` timestamp NULL DEFAULT NULL,
2024  PRIMARY KEY (`id`)
2025) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2026
2027INSERT INTO `room_facility_group_translations` (`id`, `room_facility_group_id`, `name`, `locale`, `created_at`, `updated_at`) VALUES
2028(1,	1,	'Accessibility',	'en',	'2019-03-25 11:20:12',	'2019-03-27 07:44:32'),
2029(2,	1,	'Ruangan Keluarga',	'id',	'2019-03-25 11:36:45',	'2019-03-25 11:36:45'),
2030(3,	2,	'Bathroom',	'en',	'2019-03-27 07:44:32',	'2019-03-27 07:44:32'),
2031(4,	3,	'Building characteristics',	'en',	'2019-03-27 07:44:32',	'2019-03-27 07:44:32'),
2032(5,	4,	'Entertainment and family services',	'en',	'2019-03-27 07:44:32',	'2019-03-27 07:44:32'),
2033(6,	5,	'Food & Drink',	'en',	'2019-03-27 07:44:32',	'2019-03-27 07:44:32'),
2034(7,	6,	'Hostel facilities',	'en',	'2019-03-27 07:44:32',	'2019-03-27 07:44:32'),
2035(8,	7,	'Media & Technology',	'en',	'2019-03-27 07:44:33',	'2019-03-27 07:44:33'),
2036(9,	8,	'Outdoor & View',	'en',	'2019-03-27 07:44:33',	'2019-03-27 07:44:33'),
2037(10,	9,	'Room Amenities',	'en',	'2019-03-27 07:44:33',	'2019-03-27 07:44:33'),
2038(11,	10,	'Services',	'en',	'2019-03-27 07:44:33',	'2019-03-27 07:44:33'),
2039(12,	11,	'Services & Extras',	'en',	'2019-03-27 07:44:33',	'2019-03-27 07:44:33');
2040
2041DROP TABLE IF EXISTS `room_facility_relation`;
2042CREATE TABLE `room_facility_relation` (
2043  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
2044  `room_id` int(11) NOT NULL,
2045  `room_facility_id` int(11) NOT NULL,
2046  PRIMARY KEY (`id`)
2047) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2048
2049
2050DROP TABLE IF EXISTS `room_facility_translations`;
2051CREATE TABLE `room_facility_translations` (
2052  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
2053  `room_facility_id` int(11) NOT NULL,
2054  `language_id` int(10) unsigned NOT NULL,
2055  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
2056  `locale` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
2057  `created_at` timestamp NULL DEFAULT NULL,
2058  `updated_at` timestamp NULL DEFAULT NULL,
2059  PRIMARY KEY (`id`),
2060  KEY `room_facillity_translations_language_id_foreign` (`language_id`),
2061  CONSTRAINT `room_facillity_translations_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `cm_master`.`languages` (`id`) ON DELETE CASCADE
2062) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2063
2064INSERT INTO `room_facility_translations` (`id`, `room_facility_id`, `language_id`, `name`, `locale`, `created_at`, `updated_at`) VALUES
2065(1,	1,	1,	'Air conditioning',	'en',	NULL,	NULL),
2066(2,	2,	1,	'Desk',	'en',	NULL,	NULL),
2067(3,	3,	1,	'Ironing Facilities',	'en',	NULL,	NULL),
2068(4,	4,	1,	'TV',	'en',	NULL,	NULL),
2069(5,	5,	1,	'Microwave',	'en',	NULL,	NULL),
2070(6,	6,	1,	'Fan',	'en',	NULL,	NULL),
2071(7,	7,	1,	'Refrigerator',	'en',	NULL,	NULL),
2072(8,	8,	1,	'Washing Machine',	'en',	NULL,	NULL),
2073(9,	9,	1,	'Seating Area',	'en',	NULL,	NULL),
2074(10,	10,	1,	'Telephone',	'en',	NULL,	NULL),
2075(11,	11,	1,	'Trouser Press',	'en',	NULL,	NULL),
2076(12,	12,	1,	'Dishwasher',	'en',	NULL,	NULL),
2077(13,	13,	1,	'Heating',	'en',	NULL,	NULL),
2078(14,	14,	1,	'Soundproofing',	'en',	NULL,	NULL),
2079(15,	15,	1,	'Alarm clock',	'en',	NULL,	NULL),
2080(16,	16,	1,	'Kitchenware',	'en',	NULL,	NULL),
2081(17,	17,	1,	'Mosquito net',	'en',	NULL,	NULL),
2082(18,	18,	1,	'Wake-up service',	'en',	NULL,	NULL),
2083(19,	19,	1,	'Additional bathroom',	'en',	NULL,	NULL),
2084(20,	20,	1,	'Additional Toilet',	'en',	NULL,	NULL),
2085(21,	21,	1,	'Cleaning products',	'en',	NULL,	NULL),
2086(22,	22,	1,	'Clothes rack',	'en',	NULL,	NULL),
2087(23,	23,	1,	'Dressing Room',	'en',	NULL,	NULL),
2088(24,	24,	1,	'Fireplace',	'en',	NULL,	NULL),
2089(25,	25,	1,	'Private entrance',	'en',	NULL,	NULL),
2090(26,	26,	1,	'Slippers',	'en',	NULL,	NULL),
2091(27,	27,	1,	'Sofa',	'en',	NULL,	NULL),
2092(28,	28,	1,	'Towels',	'en',	NULL,	NULL),
2093(29,	29,	1,	'Fire extinguisher',	'en',	NULL,	NULL),
2094(30,	30,	1,	'Tea/Coffee Maker',	'en',	NULL,	NULL),
2095(31,	31,	1,	'Internet Facilities',	'en',	NULL,	NULL),
2096(32,	32,	1,	'Minibar',	'en',	NULL,	NULL),
2097(33,	33,	1,	'Shower',	'en',	NULL,	NULL),
2098(34,	34,	1,	'Bath',	'en',	NULL,	NULL),
2099(35,	35,	1,	'Safety Deposit Box',	'en',	NULL,	NULL),
2100(36,	36,	1,	'Pay-per-view Channels',	'en',	NULL,	NULL),
2101(37,	37,	1,	'Fax',	'en',	NULL,	NULL),
2102(38,	38,	1,	'Hairdryer',	'en',	NULL,	NULL),
2103(39,	39,	1,	'Wake Up Service/Alarm Clock',	'en',	NULL,	NULL),
2104(40,	40,	1,	'Hot Tub',	'en',	NULL,	NULL),
2105(41,	41,	1,	'Iron',	'en',	NULL,	NULL),
2106(42,	42,	1,	'Kitchenette',	'en',	NULL,	NULL),
2107(43,	43,	1,	'Balcony',	'en',	NULL,	NULL),
2108(44,	44,	1,	'Bathrobe',	'en',	NULL,	NULL),
2109(45,	45,	1,	'Spa Bath',	'en',	NULL,	NULL),
2110(46,	46,	1,	'Radio',	'en',	NULL,	NULL),
2111(47,	47,	1,	'Shared Bathroom',	'en',	NULL,	NULL),
2112(48,	48,	1,	'Free toiletries',	'en',	NULL,	NULL),
2113(49,	49,	1,	'Toilet',	'en',	NULL,	NULL),
2114(50,	50,	1,	'Video',	'en',	NULL,	NULL),
2115(51,	51,	1,	'Video Games',	'en',	NULL,	NULL),
2116(52,	52,	1,	'Patio',	'en',	NULL,	NULL),
2117(53,	53,	1,	'Private bathroom',	'en',	NULL,	NULL),
2118(54,	54,	1,	'Extra Long Beds (> 2 metres)',	'en',	NULL,	NULL),
2119(55,	55,	1,	'Shared Toilet',	'en',	NULL,	NULL),
2120(56,	56,	1,	'Kitchen',	'en',	NULL,	NULL),
2121(57,	57,	1,	'Wireless Internet',	'en',	NULL,	NULL),
2122(58,	58,	1,	'Bath or Shower',	'en',	NULL,	NULL),
2123(59,	59,	1,	'Carpeted',	'en',	NULL,	NULL),
2124(60,	60,	1,	'Interconnected room(s) available',	'en',	NULL,	NULL),
2125(61,	61,	1,	'Laptop safe',	'en',	NULL,	NULL),
2126(62,	62,	1,	'Flat-screen TV',	'en',	NULL,	NULL),
2127(63,	63,	1,	'Tile/Marble floor',	'en',	NULL,	NULL),
2128(64,	64,	1,	'View',	'en',	NULL,	NULL),
2129(65,	65,	1,	'Hardwood or parquet floors',	'en',	NULL,	NULL),
2130(66,	66,	1,	'Dining area',	'en',	NULL,	NULL),
2131(67,	67,	1,	'Electric kettle',	'en',	NULL,	NULL),
2132(68,	68,	1,	'Executive Lounge Access',	'en',	NULL,	NULL),
2133(69,	69,	1,	'iPod dock',	'en',	NULL,	NULL),
2134(70,	70,	1,	'Towels/Sheets (extra fee)',	'en',	NULL,	NULL),
2135(71,	71,	1,	'Sauna',	'en',	NULL,	NULL),
2136(72,	72,	1,	'Private pool',	'en',	NULL,	NULL),
2137(73,	73,	1,	'Tumble dryer',	'en',	NULL,	NULL),
2138(74,	74,	1,	'Wardrobe or closet',	'en',	NULL,	NULL),
2139(75,	75,	1,	'Oven',	'en',	NULL,	NULL),
2140(76,	76,	1,	'Stovetop',	'en',	NULL,	NULL),
2141(77,	77,	1,	'Toaster',	'en',	NULL,	NULL),
2142(78,	78,	1,	'Barbecue',	'en',	NULL,	NULL),
2143(79,	79,	1,	'Bidet',	'en',	NULL,	NULL),
2144(80,	80,	1,	'Computer',	'en',	NULL,	NULL),
2145(81,	81,	1,	'iPad',	'en',	NULL,	NULL),
2146(82,	82,	1,	'Game console',	'en',	NULL,	NULL),
2147(83,	83,	1,	'Game console - Xbox 360',	'en',	NULL,	NULL),
2148(84,	84,	1,	'Game console - PS2',	'en',	NULL,	NULL),
2149(85,	85,	1,	'Game console - PS3',	'en',	NULL,	NULL),
2150(86,	86,	1,	'Game console - Nintendo Wii',	'en',	NULL,	NULL),
2151(87,	87,	1,	'Sea view',	'en',	NULL,	NULL),
2152(88,	88,	1,	'Lake view',	'en',	NULL,	NULL),
2153(89,	89,	1,	'Garden view',	'en',	NULL,	NULL),
2154(90,	90,	1,	'Pool view',	'en',	NULL,	NULL),
2155(91,	91,	1,	'Mountain view',	'en',	NULL,	NULL),
2156(92,	92,	1,	'Landmark view',	'en',	NULL,	NULL),
2157(93,	93,	1,	'Laptop',	'en',	NULL,	NULL),
2158(94,	94,	1,	'Hypoallergenic',	'en',	NULL,	NULL),
2159(95,	95,	1,	'Electric blankets',	'en',	NULL,	NULL),
2160(96,	96,	1,	'Blu-ray player',	'en',	NULL,	NULL),
2161(97,	97,	1,	'Coffee machine',	'en',	NULL,	NULL),
2162(98,	98,	1,	'City view',	'en',	NULL,	NULL),
2163(99,	99,	1,	'River view',	'en',	NULL,	NULL),
2164(100,	100,	1,	'Terrace',	'en',	NULL,	NULL),
2165(101,	101,	1,	'Linen',	'en',	NULL,	NULL),
2166(102,	102,	1,	'Dining table',	'en',	NULL,	NULL),
2167(103,	103,	1,	'Children\'s high chair',	'en',	NULL,	NULL),
2168(104,	104,	1,	'Outdoor furniture',	'en',	NULL,	NULL),
2169(105,	105,	1,	'Outdoor dining area',	'en',	NULL,	NULL),
2170(106,	106,	1,	'Entire unit located on ground floor',	'en',	NULL,	NULL),
2171(107,	107,	1,	'Upper floors accessible by lift',	'en',	NULL,	NULL),
2172(108,	108,	1,	'Upper floors accessible by stairs only',	'en',	NULL,	NULL),
2173(109,	109,	1,	'Entire unit wheelchair accessible',	'en',	NULL,	NULL),
2174(110,	110,	1,	'Detached',	'en',	NULL,	NULL),
2175(111,	111,	1,	'Semi-detached',	'en',	NULL,	NULL),
2176(112,	112,	1,	'Private flat in building',	'en',	NULL,	NULL),
2177(113,	113,	1,	'Fold-up bed',	'en',	NULL,	NULL),
2178(114,	114,	1,	'Drying rack for clothing',	'en',	NULL,	NULL),
2179(115,	115,	1,	'Toilet paper',	'en',	NULL,	NULL),
2180(116,	116,	1,	'Child safety socket covers',	'en',	NULL,	NULL),
2181(117,	117,	1,	'Board games/puzzles',	'en',	NULL,	NULL),
2182(118,	118,	1,	'Book, DVDs or music for children',	'en',	NULL,	NULL),
2183(119,	119,	1,	'Baby safety gates',	'en',	NULL,	NULL),
2184(120,	120,	1,	'Sofa bed',	'en',	NULL,	NULL),
2185(121,	121,	1,	'Toilet with grab rails',	'en',	NULL,	NULL),
2186(122,	122,	1,	'Adapted bath',	'en',	NULL,	NULL),
2187(123,	123,	1,	'Roll in shower',	'en',	NULL,	NULL),
2188(124,	124,	1,	'Walk in shower',	'en',	NULL,	NULL),
2189(125,	125,	1,	'Raised toilet',	'en',	NULL,	NULL),
2190(126,	126,	1,	'Lowered sink',	'en',	NULL,	NULL),
2191(127,	127,	1,	'Emergency cord in bathroom',	'en',	NULL,	NULL),
2192(128,	128,	1,	'Shower chair',	'en',	NULL,	NULL),
2193(129,	129,	1,	'Rooftop pool',	'en',	NULL,	NULL),
2194(130,	130,	1,	'Infinity pool',	'en',	NULL,	NULL),
2195(131,	131,	1,	'Pool with a view',	'en',	NULL,	NULL),
2196(132,	132,	1,	'Heated pool',	'en',	NULL,	NULL),
2197(133,	133,	1,	'Salt-water pool',	'en',	NULL,	NULL),
2198(134,	134,	1,	'Plunge pool',	'en',	NULL,	NULL),
2199(135,	135,	1,	'Pool towels',	'en',	NULL,	NULL),
2200(136,	136,	1,	'Shallow end',	'en',	NULL,	NULL),
2201(137,	137,	1,	'Pool cover',	'en',	NULL,	NULL),
2202(138,	138,	1,	'Wine or champagne',	'en',	NULL,	NULL),
2203(139,	139,	1,	'Bottle of water',	'en',	NULL,	NULL),
2204(140,	140,	1,	'Fruits',	'en',	NULL,	NULL),
2205(141,	141,	1,	'Chocolate or cookies',	'en',	NULL,	NULL),
2206(142,	142,	1,	'Trash cans',	'en',	NULL,	NULL),
2207(143,	143,	1,	'Wine glasses',	'en',	NULL,	NULL),
2208(144,	144,	1,	'Game console - Xbox One',	'en',	NULL,	NULL),
2209(145,	145,	1,	'Game console - Wii U',	'en',	NULL,	NULL),
2210(146,	146,	1,	'Game console - PS4',	'en',	NULL,	NULL),
2211(147,	147,	1,	'Children\'s cots/cribs',	'en',	NULL,	NULL),
2212(148,	148,	1,	'Toothbrush',	'en',	NULL,	NULL),
2213(149,	149,	1,	'Shampoo',	'en',	NULL,	NULL),
2214(150,	150,	1,	'Conditioner',	'en',	NULL,	NULL),
2215(151,	151,	1,	'Body soap',	'en',	NULL,	NULL),
2216(152,	152,	1,	'Shower cap',	'en',	NULL,	NULL),
2217(153,	153,	1,	'Pajamas',	'en',	NULL,	NULL),
2218(154,	154,	1,	'Yukata',	'en',	NULL,	NULL),
2219(155,	155,	1,	'Socket near the bed',	'en',	NULL,	NULL),
2220(156,	156,	1,	'Adapter',	'en',	NULL,	NULL),
2221(157,	157,	1,	'Feather pillow',	'en',	NULL,	NULL),
2222(158,	158,	1,	'Non-feather pillow',	'en',	NULL,	NULL),
2223(159,	159,	1,	'Hypoallergenic pillow',	'en',	NULL,	NULL),
2224(160,	160,	1,	'Accessible by lift',	'en',	NULL,	NULL),
2225(161,	161,	1,	'Inner courtyard view',	'en',	NULL,	NULL),
2226(162,	162,	1,	'Quiet street view',	'en',	NULL,	NULL),
2227(163,	163,	1,	'Portable Wifi',	'en',	NULL,	NULL),
2228(164,	164,	1,	'Smartphone',	'en',	NULL,	NULL),
2229(165,	165,	1,	'Streaming service (such as Netflix)',	'en',	NULL,	NULL),
2230(166,	166,	1,	'Lockers',	'en',	NULL,	NULL),
2231(167,	167,	1,	'Smoke alarm',	'en',	NULL,	NULL),
2232(168,	168,	1,	'Key access',	'en',	NULL,	NULL),
2233(169,	169,	1,	'Key card access',	'en',	NULL,	NULL),
2234(170,	170,	1,	'Reading light',	'en',	NULL,	NULL),
2235(171,	171,	1,	'Earplugs',	'en',	NULL,	NULL),
2236(172,	172,	1,	'Privacy curtain',	'en',	NULL,	NULL),
2237(173,	173,	1,	'DVD/CD player',	'en',	NULL,	NULL),
2238(174,	174,	1,	'Satellite/cable channels',	'en',	NULL,	NULL),
2239(175,	175,	1,	'Daily newspaper',	'en',	NULL,	NULL),
2240(176,	176,	1,	'On-demand movies',	'en',	NULL,	NULL),
2241(177,	177,	1,	'Internet access – LAN',	'en',	NULL,	NULL),
2242(178,	178,	1,	'Whirlpool bathtub',	'en',	NULL,	NULL),
2243(179,	179,	1,	'Wi-Fi [free]',	'en',	NULL,	NULL),
2244(180,	180,	1,	'Wi-Fi [charges apply]',	'en',	NULL,	NULL),
2245(181,	181,	1,	'LAN Internet in room [free]',	'en',	NULL,	NULL),
2246(182,	182,	1,	'Free Wi-Fi in all rooms!',	'en',	NULL,	NULL),
2247(183,	183,	1,	'Bathroom phone',	'en',	NULL,	NULL),
2248(184,	184,	1,	'Free instant coffee',	'en',	NULL,	NULL),
2249(185,	185,	1,	'Complimentary tea',	'en',	NULL,	NULL),
2250(186,	186,	1,	'Free welcome drink',	'en',	NULL,	NULL),
2251(187,	187,	1,	'In-room tablet',	'en',	NULL,	NULL),
2252(188,	188,	1,	'Mirror',	'en',	NULL,	NULL),
2253(189,	189,	1,	'Scale',	'en',	NULL,	NULL),
2254(190,	190,	1,	'Sewing kit',	'en',	NULL,	NULL),
2255(191,	191,	1,	'Shoeshine kit',	'en',	NULL,	NULL),
2256(192,	192,	1,	'TV [in bathroom]',	'en',	NULL,	NULL),
2257(193,	193,	1,	'Umbrella',	'en',	NULL,	NULL),
2258(194,	194,	1,	'Separate living room',	'en',	NULL,	NULL),
2259(195,	195,	1,	'Laptop workspace',	'en',	NULL,	NULL),
2260(196,	196,	1,	'Carbon monoxide detector',	'en',	NULL,	NULL),
2261(197,	197,	1,	'Pets allowed in room',	'en',	NULL,	NULL),
2262(198,	198,	1,	'High floor',	'en',	NULL,	NULL),
2263(199,	199,	1,	'Open air bath privileges',	'en',	NULL,	NULL);
2264
2265DROP TABLE IF EXISTS `room_photos`;
2266CREATE TABLE `room_photos` (
2267  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
2268  `room_id` int(11) NOT NULL,
2269  `url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
2270  `created_at` timestamp NULL DEFAULT NULL,
2271  `updated_at` timestamp NULL DEFAULT NULL,
2272  PRIMARY KEY (`id`)
2273) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2274
2275
2276DROP TABLE IF EXISTS `room_rates`;
2277CREATE TABLE `room_rates` (
2278  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
2279  `room_id` int(11) NOT NULL,
2280  `rate_id` int(11) NOT NULL,
2281  `created_at` timestamp NULL DEFAULT NULL,
2282  `updated_at` timestamp NULL DEFAULT NULL,
2283  PRIMARY KEY (`id`)
2284) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2285
2286INSERT INTO `room_rates` (`id`, `room_id`, `rate_id`, `created_at`, `updated_at`) VALUES
2287(1,	10,	5,	'2019-03-22 10:18:36',	'2019-03-22 10:18:36'),
2288(2,	19,	7,	'2019-03-22 10:41:24',	'2019-03-22 10:41:24'),
2289(3,	20,	7,	'2019-03-22 10:41:24',	'2019-03-22 10:41:24'),
2290(4,	22,	7,	'2019-03-22 10:41:24',	'2019-03-22 10:41:24');
2291
2292DROP TABLE IF EXISTS `room_translations`;
2293CREATE TABLE `room_translations` (
2294  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
2295  `room_id` int(10) unsigned NOT NULL,
2296  `language_id` int(10) unsigned NOT NULL,
2297  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
2298  `locale` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
2299  `created_at` timestamp NULL DEFAULT NULL,
2300  `updated_at` timestamp NULL DEFAULT NULL,
2301  PRIMARY KEY (`id`),
2302  KEY `room_translations_room_id_index` (`room_id`),
2303  KEY `room_translations_language_id_index` (`language_id`),
2304  CONSTRAINT `room_translations_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `cm_master`.`languages` (`id`) ON DELETE CASCADE,
2305  CONSTRAINT `room_translations_room_id_foreign` FOREIGN KEY (`room_id`) REFERENCES `rooms` (`id`) ON DELETE CASCADE
2306) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2307
2308INSERT INTO `room_translations` (`id`, `room_id`, `language_id`, `name`, `locale`, `created_at`, `updated_at`) VALUES
2309(1,	10,	2,	'Kamar',	'id',	NULL,	NULL),
2310(2,	32,	1,	'Jefferson',	'en',	NULL,	NULL);
2311
2312DROP TABLE IF EXISTS `suppliers`;
2313CREATE TABLE `suppliers` (
2314  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
2315  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
2316  `created_at` timestamp NULL DEFAULT NULL,
2317  `updated_at` timestamp NULL DEFAULT NULL,
2318  PRIMARY KEY (`id`)
2319) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2320
2321
2322-- 2019-04-24 11:42:55