-- ALTER TABLE `consulting_requests` CHANGE `consulting_type` `consulting_type` ENUM('urgent','appointment') CHARACTER SET utf8 COLLATE utf8_general_ci NULL;
-- ALTER TABLE `consultings` CHANGE `type` `type` ENUM('urgent','appointment') CHARACTER SET utf8 COLLATE utf8_general_ci NULL;
-- ALTER TABLE `consulting_requests` ADD `consulting_topic_id` BIGINT UNSIGNED NOT NULL AFTER `coupon_id`, ADD INDEX (`consulting_topic_id`);
-- ALTER TABLE `consulting_requests` CHANGE `consulting_subject` `consulting_subject` VARCHAR(400) CHARACTER SET utf8 COLLATE utf8_general_ci NULL;
-- ALTER TABLE `case_requests` CHANGE `subject` `subject` VARCHAR(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL;
-- ALTER TABLE `case_requests` ADD `case_topic_id` BIGINT UNSIGNED NOT NULL AFTER `user_id`, ADD INDEX (`case_topic_id`);
-- ALTER TABLE `case_requests` ADD `case_no` VARCHAR(50) NULL AFTER `user_id`;


-- ALTER TABLE `sliders` ADD `image` VARCHAR(200) NULL AFTER `id`;

-- ALTER TABLE `case_requests` CHANGE `files` `request_files` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
-- ALTER TABLE `case_requests` ADD `updates_files` LONGTEXT NULL AFTER `request_files`;
-- ALTER TABLE `case_updates` ADD `case_request_id` BIGINT(20) UNSIGNED NULL AFTER `user_id`, ADD INDEX (`case_request_id`);

-- ALTER TABLE `case_update_descriptions` CHANGE `file_name` `file_name` VARBINARY(100) NOT NULL;
-- UPDATE `modules` SET `deleted_at` = '2022-09-05 00:00:00' WHERE `modules`.`id` = 10;
-- UPDATE `modules` SET `deleted_at` = '2022-09-06 00:00:00' WHERE `modules`.`id` = 11;
-- UPDATE `modules` SET `deleted_at` = '2022-09-06 00:00:00' WHERE `modules`.`id` = 12;


-- RENAME TABLE `legal`.`company_request_types` TO `legal`.`company_request_topics`;
-- RENAME TABLE `legal`.`company_request_type_descriptions` TO `legal`.`company_request_topic_descriptions`;
-- ALTER TABLE `company_request_topic_descriptions` CHANGE `company_request_type_id` `company_request_topic_id` BIGINT(20) UNSIGNED NOT NULL;
-- ALTER TABLE `company_requests` CHANGE `company_request_type_id` `company_request_topic_id` BIGINT(20) UNSIGNED NOT NULL, CHANGE `subject` `request_type` VARCHAR(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
--
--
--
-- RENAME TABLE `legal`.`other_request_types` TO `legal`.`other_request_topics`;
-- RENAME TABLE `legal`.`other_request_type_descriptions` TO `legal`.`other_request_topic_descriptions`;
-- ALTER TABLE `other_request_topic_descriptions` CHANGE `other_request_type_id` `other_request_topic_id` BIGINT(20) UNSIGNED NOT NULL;
-- ALTER TABLE `other_requests` CHANGE `other_request_type_id` `other_request_topic_id` BIGINT(20) UNSIGNED NOT NULL, CHANGE `subject` `request_type` VARCHAR(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;


-- UPDATE `settings` SET `key` = 'consulting_requests_hint_1_ar' WHERE `settings`.`id` = 30;
-- UPDATE `settings` SET `key` = 'consulting_requests_hint_1_en' WHERE `settings`.`id` = 31;
-- INSERT INTO `settings` (`id`, `key`, `value`, `created_at`, `updated_at`) VALUES (NULL, 'consulting_requests_hint_2_ar', 'سوف يكون هناك رسوم إضافية عند ألحجز بعد العاشرة مساءا وحتي لثامنة صباحا سواء كن إستشارة مرئية أو اتفية أو بالحضور للمكتب', '2022-05-18 16:20:51', '2022-09-13 13:19:53'), (NULL, 'consulting_requests_hint_2_en', 'There will be an additional fee when booking after ten in the evening until eight in the morning, whether it is a video or telephone consultation or by coming to the office', '2022-05-18 16:20:51', '2022-09-13 13:19:53');


-- ALTER TABLE `slider_descriptions` CHANGE `second_title` `second_title` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL;

-- ALTER TABLE `case_requests` CHANGE `request_files` `request_files` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL;
-- ALTER TABLE `company_requests` CHANGE `files` `files` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL;
-- ALTER TABLE `other_requests` CHANGE `files` `files` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL;