
---- 20-06-2022

ALTER TABLE `blogs`
ADD `type` enum('news','our-products','latest-articles','our-services') COLLATE 'utf8_general_ci' NULL AFTER `image`,
CHANGE `modified` `modified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE CURRENT_TIMESTAMP AFTER `created`;

ALTER TABLE `blogs`
CHANGE `type` `type` enum('latest-news','our-products','latest-articles','our-services') COLLATE 'utf8_general_ci' NULL AFTER `image`,
CHANGE `modified` `modified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE CURRENT_TIMESTAMP AFTER `created`;

ALTER TABLE `blog_categories`
ADD `type` enum('news-categories') COLLATE 'utf8_general_ci' NULL AFTER `image`,
CHANGE `modified` `modified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE CURRENT_TIMESTAMP AFTER `created`;


---- 21-06-2022

CREATE TABLE `web_settings` (
  `id` int NOT NULL AUTO_INCREMENT PRIMARY KEY,
  `slider_title` varchar(255) NULL,
  `slider` text NULL,
  `about_us_title` varchar(255) NULL,
  `about_us_sub_title` varchar(255) NULL,
  `about_us_description` text NULL,
  `about_us_categories` longtext NULL,
  `about_us_button_text` varchar(255) NULL,
  `is_about_us_button` tinyint(4) NULL,
  `our_services_title` varchar(255) NULL,
  `our_services` text NULL,
  `our_process_title` varchar(255) NULL,
  `our_process` text NULL,
  `articles_title` varchar(255) NULL,
  `articles` text NULL,
  `articles_button_text` varchar(255) NULL,
  `is_articles_button` tinyint(4) NULL,
  `our_products_title` varchar(255) NULL,
  `our_products` text NULL,
  `our_products_button_text` varchar(255) NULL,
  `is_our_products_button` tinyint(4) NULL,
  `technology_partners_title` varchar(255) NULL,
  `technology_partners_images` longtext NULL,
  `news_title` varchar(255) NULL,
  `news` text NULL,
  `testimonials_title` varchar(255) NULL,
  `testimonials` text NULL,
  `our_accolades_title` varchar(255) NULL,
  `our_accolades_images` longtext NULL,
  `footer_menu` longtext NULL,
  `created` datetime NULL,
  `modified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE CURRENT_TIMESTAMP
) ENGINE='InnoDB' COLLATE 'utf8_general_ci';

INSERT INTO `web_settings` (`id`, `slider_title`, `slider`, `about_us_title`, `about_us_sub_title`, `about_us_description`, `about_us_categories`, `about_us_button_text`, `is_about_us_button`, `our_services_title`, `our_services`, `our_process_title`, `our_process`, `articles_title`, `articles`, `articles_button_text`, `is_articles_button`, `our_products_title`, `our_products`, `our_products_button_text`, `is_our_products_button`, `technology_partners_title`, `technology_partners_images`, `news_title`, `news`, `testimonials_title`, `testimonials`, `our_accolades_title`, `our_accolades_images`, `footer_menu`, `created`, `modified`)
VALUES ('1', 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, now());


ALTER TABLE `blogs`
CHANGE `type` `type` enum('latest-news','our-products','latest-articles','our-services','our-process') COLLATE 'utf8_general_ci' NULL AFTER `image`,
CHANGE `modified` `modified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE CURRENT_TIMESTAMP AFTER `created`;

--- 22-06-2022

ALTER TABLE `blogs`
CHANGE `type` `type` enum('latest-news','our-products','latest-articles','our-services','our-process','about-us-feature') COLLATE 'utf8_general_ci' NULL AFTER `image`,
CHANGE `modified` `modified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE CURRENT_TIMESTAMP AFTER `created`;

ALTER TABLE `web_settings`
CHANGE `about_us_button_text` `about_us_button_text` varchar(255) COLLATE 'utf8_general_ci' NULL AFTER `about_us_description`,
CHANGE `about_us_categories` `about_us_link` varchar(255) COLLATE 'utf8_general_ci' NULL AFTER `about_us_button_text`,
ADD `articles_link` varchar(255) COLLATE 'utf8_general_ci' NULL AFTER `articles_button_text`,
ADD `our_products_link` varchar(255) COLLATE 'utf8_general_ci' NULL AFTER `our_products_button_text`,
CHANGE `modified` `modified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE CURRENT_TIMESTAMP AFTER `created`;


ALTER TABLE `web_settings`
ADD `about_us_feature` text COLLATE 'utf8_general_ci' NULL AFTER `about_us_description`,
CHANGE `modified` `modified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE CURRENT_TIMESTAMP AFTER `created`;


ALTER TABLE `web_settings`
ADD `created_by` int(11) NULL AFTER `footer_menu`,
ADD `deleted_at` datetime NULL AFTER `created_by`,
CHANGE `modified` `modified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE CURRENT_TIMESTAMP AFTER `created`,
ADD FOREIGN KEY (`created_by`) REFERENCES `admins` (`id`) ON DELETE CASCADE;


--- 23-06-2022

ALTER TABLE `web_settings`
ADD `quick_links_title` varchar(255) COLLATE 'utf8_general_ci' NULL AFTER `our_accolades_images`,
ADD `contact_info_title` varchar(255) COLLATE 'utf8_general_ci' NULL AFTER `footer_menu`,
ADD `address` text COLLATE 'utf8_general_ci' NULL AFTER `contact_info_title`,
ADD `phone_number_1` int(11) NULL AFTER `address`,
ADD `phone_number_2` int(11) NULL AFTER `phone_number_1`,
ADD `email` varchar(255) COLLATE 'utf8_general_ci' NULL AFTER `phone_number_2`,
ADD `follow_us_title` varchar(255) COLLATE 'utf8_general_ci' NULL AFTER `email`,
ADD `facebook` varchar(255) COLLATE 'utf8_general_ci' NULL AFTER `follow_us_title`,
ADD `twitter` varchar(255) COLLATE 'utf8_general_ci' NULL AFTER `facebook`,
ADD `linkedin` varchar(255) COLLATE 'utf8_general_ci' NULL AFTER `twitter`,
ADD `youtube` varchar(255) COLLATE 'utf8_general_ci' NULL AFTER `linkedin`,
ADD `blogger` varchar(255) COLLATE 'utf8_general_ci' NULL AFTER `youtube`,
ADD `google` varchar(255) COLLATE 'utf8_general_ci' NULL AFTER `blogger`,
ADD `telegram` varchar(255) COLLATE 'utf8_general_ci' NULL AFTER `google`,
ADD `skype` varchar(255) COLLATE 'utf8_general_ci' NULL AFTER `telegram`,
ADD `wifi` varchar(255) COLLATE 'utf8_general_ci' NULL AFTER `skype`,
ADD `whatsapp` varchar(255) COLLATE 'utf8_general_ci' NULL AFTER `wifi`,
ADD `powered_by` varchar(255) COLLATE 'utf8_general_ci' NULL AFTER `whatsapp`,
ADD `powered_by_link` varchar(255) COLLATE 'utf8_general_ci' NULL AFTER `powered_by`,
CHANGE `modified` `modified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE CURRENT_TIMESTAMP AFTER `created`;

ALTER TABLE `web_settings`
CHANGE `phone_number_1` `phone_number_1` varchar(255) NULL AFTER `address`,
CHANGE `phone_number_2` `phone_number_2` varchar(255) NULL AFTER `phone_number_1`,
CHANGE `modified` `modified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE CURRENT_TIMESTAMP AFTER `created`;


---24-06-2022

INSERT INTO `settings` (`name`, `value`)
VALUES ('bread_crumbs_setting ', NULL);

UPDATE `settings` SET `value` = '[{\"main_title\":\"About Us\",\"title\":\"About\",\"slug\":\"about-us\",\"image\":\"\"},{\"main_title\":\"Services\",\"title\":\"Services\",\"slug\":\"services\",\"image\":\"\"},{\"main_title\":\"Products\",\"title\":\"Products\",\"slug\":\"products\",\"image\":\"\"},{\"main_title\":\"Technologies\",\"title\":\"Technologies\",\"slug\":\"technologies\",\"image\":\"\"},{\"main_title\":\"Verticals\",\"title\":\"Verticals\",\"slug\":\"verticals\",\"image\":\"\"},{\"main_title\":\"News & Events\",\"title\":\"News\",\"slug\":\"news\",\"image\":\"\"},{\"main_title\":\"Hire Resources\",\"title\":\"Hire Resources\",\"slug\":\"hire-resources\",\"image\":\"\"},{\"main_title\":\"Careers\",\"title\":\"Careers\",\"slug\":\"careers\",\"image\":\"\"},{\"main_title\":\"FAQs\",\"title\":\"FAQs\",\"slug\":\"faqs\",\"image\":\"\"},{\"main_title\":\"Contact Us\",\"title\":\"Contact Us\",\"slug\":\"contact-us\",\"image\":\"\"},{\"main_title\":\"Sitemap\",\"title\":\"Sitemap\",\"slug\":\"sitemap\",\"image\":\"\"},{\"main_title\":\"Feedback\",\"title\":\"Feedback\",\"slug\":\"feedback\",\"image\":\"\"},{\"main_title\":\"Partner with us\",\"title\":\"Partner with us\",\"slug\":\"partner-with-us\",\"image\":\"\"},{\"main_title\":\"Packages\",\"title\":\"Packages\",\"slug\":\"packages\",\"image\":\"\"}]' WHERE `id` = '136';