-- ALTER TABLE `work_hours` ADD `status` ENUM('open','closed') NOT NULL AFTER `id`;


-- ALTER TABLE `rooms` ADD `rate` DOUBLE NULL AFTER `id`;
-- ALTER TABLE `room_reservations` CHANGE `pay_way` `pay_way` ENUM('visa_master','mada','sts_pay','apple_pay') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
-- ALTER TABLE `payments` ADD `room_reservation_id` BIGINT(20) NULL AFTER `invoice_id`, ADD INDEX (`room_reservation_id`);


-- ALTER TABLE `special_need_descriptions` ADD `brief` VARCHAR(400) NOT NULL AFTER `title`;
-- UPDATE `pages` SET `meta` = '[\"https:\\/\\/www.youtube.com\\/watch?v=h0pEL8GklCc\"]' WHERE `pages`.`id` = 2;
-- UPDATE `room_evaluates` SET `reception_evaluation` = '0', `safety_evaluation` = 0, `room_evaluation` = 0, `food_evaluation` = 0
-- UPDATE `rooms` SET `rate` = NULL


INSERT INTO `settings` (`id`, `key`, `value`, `created_at`, `updated_at`) VALUES (NULL, 'tax_number', '1234567890', '2022-11-06 17:43:52', '2022-11-26 11:17:57');
INSERT INTO `settings` (`id`, `key`, `value`, `created_at`, `updated_at`) VALUES (NULL, 'added_value', '15', '2022-11-06 17:43:52', '2022-11-26 11:17:57');


