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


-- UPDATE `modules` SET `deleted_at` = '2022-12-06 00:00:00' WHERE `modules`.`id` = 10;


-- ALTER TABLE `doctors` ADD `show_in_chairman` BOOLEAN NOT NULL DEFAULT TRUE AFTER `id`;
-- ALTER TABLE `doctors` ADD `show_in_home` BOOLEAN NOT NULL DEFAULT TRUE AFTER `show_in_chairman`;


-- 5/1/2023

-- UPDATE `pages` SET `images` = '[\"assets\\/web\\/images\\/ab_1.jpg\",\"assets\\/web\\/images\\/ab_2.jpg\",\"assets\\/web\\/images\\/ab_3.jpg\"]' WHERE `pages`.`id` = 1;
-- UPDATE `page_descriptions` SET `description_2` = '<p>It Goes Without Saying That The Procare Riaya Hospital Is Committed To Delivering The Highest Quality Healthcare Possible To All Patients Within Our Facilities.</p>' WHERE `page_descriptions`.`id` = 79;
-- UPDATE `page_descriptions` SET `description_2` = '<p>It Goes Without Saying That The Procare Riaya Hospital Is Committed To Delivering The Highest Quality Healthcare Possible To All Patients Within Our Facilities.</p>' WHERE `page_descriptions`.`id` = 80;
-- UPDATE `pages` SET `meta` = '{\"video\":\"assets/web/images/procare.mp4\"}' WHERE `pages`.`id` = 1;

-- 12/1/2023

-- INSERT INTO `settings` (`id`, `key`, `value`, `created_at`, `updated_at`) VALUES (NULL, 'whatsapp', '0580683983', '2022-11-15 14:36:18', '2023-01-05 15:28:28');
-- ALTER TABLE `doctors` ADD `okadoc_url` VARCHAR(300) NULL AFTER `linkedin`;
-- ALTER TABLE `services` CHANGE `doctor_ids` `doctor_ids` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL;
--

-- 24/1/2023

-- ALTER TABLE `doctors` ADD `show_in_offers` BOOLEAN NULL DEFAULT TRUE AFTER `show_in_home`, ADD `category_id` BIGINT UNSIGNED NULL AFTER `show_in_offers`, ADD `discount_percentage` FLOAT NULL AFTER `category_id`, ADD INDEX (`show_in_offers`), ADD INDEX (`category_id`);



