INSERT INTO `general_settings` (`id`, `name`, `display_name`, `value`, `is_specific`, `is_multilang`, `type`, `page`, `created_at`, `updated_at`) VALUES (NULL, 'google_map_key', 'Google Map Key', 'AIzaSyB9LFi2PVQgj6rue5HuILx-gXtoha9_H-g', '1', '0', 'text', 'configurations', '2024-10-04 18:36:34', '2024-10-04 18:36:34');
ALTER TABLE `general_settings` ADD `is_protected` TINYINT NOT NULL DEFAULT '0' AFTER `value`;
INSERT INTO `general_settings` (`id`, `name`, `display_name`, `value`, `is_protected`, `is_specific`, `is_multilang`, `type`, `page`, `created_at`, `updated_at`) VALUES (NULL, 'favicon', 'FavIcon', '/images/settings/favicon.png', '0', '0', '0', 'image', NULL, '2025-01-15 11:32:15', '2025-01-15 06:32:15');
INSERT INTO `general_settings` (`id`, `name`, `display_name`, `value`, `is_protected`, `is_specific`, `is_multilang`, `type`, `page`, `created_at`, `updated_at`) VALUES (NULL, 'seo_title', 'SEO title', 'land-advisor', '0', '1', '0', 'text', 'seo_settings', '2025-02-14 15:33:14', '2025-02-14 10:33:14');
INSERT INTO `general_settings` (`id`, `name`, `display_name`, `value`, `is_protected`, `is_specific`, `is_multilang`, `type`, `page`, `created_at`, `updated_at`) VALUES (NULL, 'meta_keywords', 'Meta Keywords', '[\"careconnect\",\"medical\",\"health-advisor\",\"dasdfsf\",\"fsdfsdf\"]', '0', '1', '0', 'array', 'seo_settings', '2025-02-14 15:33:14', '2025-02-14 10:33:14');
INSERT INTO `general_settings` (`id`, `name`, `display_name`, `value`, `is_protected`, `is_specific`, `is_multilang`, `type`, `page`, `created_at`, `updated_at`) VALUES (NULL, 'meta_description', 'Meta Description', '<p>Stay informed and inspired with our Hexathemes, delivering the latest news, trends, and insights in lifestyle, technology, health, and more. Explore exclusive articles, in-depth analysis, and expert opinions tailored for curious minds and savvy readers.</p>', '0', '1', '0', 'textarea', 'seo_settings', '2025-02-14 15:33:14', '2025-02-14 10:33:14'), (NULL, 'social_description', 'Social Description', '<p>Stay informed and inspired with our Hexathemes, delivering the latest news, trends, and insights in lifestyle, technology, health, and more. Explore exclusive articles, in-depth analysis, and expert opinions tailored for curious minds and savvy readers.</p>', '0', '1', '0', 'textarea', 'seo_settings', '2025-02-14 15:33:14', '2025-02-14 10:33:14');
UPDATE `general_settings` SET `page` = 'email_settings' WHERE `general_settings`.`id` = 67; UPDATE `general_settings` SET `page` = 'email_settings' WHERE `general_settings`.`id` = 66; UPDATE `general_settings` SET `page` = 'email_settings' WHERE `general_settings`.`id` = 65; UPDATE `general_settings` SET `page` = 'email_settings' WHERE `general_settings`.`id` = 64; UPDATE `general_settings` SET `page` = 'email_settings' WHERE `general_settings`.`id` = 63; UPDATE `general_settings` SET `page` = 'email_settings' WHERE `general_settings`.`id` = 62;
INSERT INTO `general_settings` (`id`, `name`, `display_name`, `value`, `is_protected`, `is_specific`, `is_multilang`, `type`, `page`, `created_at`, `updated_at`) VALUES (NULL, 'application_current_version', 'Application Current Version', '1.0.1', '0', '1', '0', 'text', NULL, '2024-12-19 16:19:30', '2024-05-14 16:59:45');
INSERT INTO `general_settings` (`id`, `name`, `display_name`, `value`, `is_protected`, `is_specific`, `is_multilang`, `type`, `page`, `created_at`, `updated_at`) VALUES (NULL, 'is_ai_chatbot_enable', 'Is AI ChatBot Enable', '1', '0', '0', '0', 'boolean_selection', NULL, '2024-12-19 16:19:30', '2024-05-14 16:59:45');


CREATE TABLE `home_component_orders` (
  `id` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `display_name` varchar(191) NOT NULL,
  `description` varchar(255) NOT NULL,
  `sort_order` int(11) NOT NULL,
  `is_active` tinyint(4) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `home_component_orders` (`id`, `name`, `display_name`, `description`, `sort_order`, `is_active`, `created_at`, `updated_at`, `deleted_at`) VALUES
(6, 'FindDoctorBar', 'Find Doctor Bar', 'Description of Static Cards', 1, 1, '2025-01-10 06:25:24', '2025-02-10 02:50:04', NULL),
(5, 'HomeStatisticsBar', 'Home Statistics Bar', 'Description of Home Statistics', 2, 1, '2025-01-10 06:25:24', '2025-02-10 02:50:04', NULL),
(7, 'SpotlightDoctorSection', 'Spotlight Doctor Section', 'Description of Spotlight Lawyer', 3, 1, '2025-01-10 06:25:24', '2025-01-13 04:14:46', NULL),
(8, 'HomeStaticCardsSection', 'Home Statistics Section', 'Description of Nearest Tab', 4, 1, '2025-01-10 06:25:24', '2025-01-13 04:20:10', NULL),
(9, 'DoctorsTabsSection', 'Doctors Tabs Section', 'Description of Lawyers Tabs', 5, 1, '2025-01-10 06:25:24', '2025-02-21 05:17:08', NULL),
(10, 'FeaturedClinicSection', 'Featured Clinic Section', 'Description of Featured Law Firm', 6, 1, '2025-01-10 06:25:24', '2025-01-10 07:16:39', NULL),
(11, 'QuickBuyServiceCategoriesSection', 'Quick Buy Service Categories Section', 'Description of Service Categories', 7, 1, '2025-01-10 06:25:24', '2025-01-13 04:20:10', NULL),
(12, 'AppsSection', 'Apps Section', 'Description of Free Consultation', 8, 1, '2025-01-10 06:25:24', '2025-01-10 07:16:39', NULL),
(13, 'FaqsSection', 'Faqs Section', 'Description of Featured Event', 9, 1, '2025-01-10 06:25:24', '2025-01-10 07:16:39', NULL),
(14, 'ReviewSection', 'Reviews Section', 'Description of Featured Testimonials', 10, 1, '2025-01-10 06:25:24', '2025-01-10 07:16:39', NULL),
(16, 'FeaturedEventSection', 'Featured Event Section', 'Description of FAQs Section', 11, 1, '2025-01-10 06:25:24', '2025-01-13 04:20:10', NULL);

ALTER TABLE `home_component_orders`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `home_component_orders`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;



CREATE TABLE `theme_settings` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `color` varchar(255) DEFAULT NULL,
  `display_name` varchar(255) NOT NULL,
  `value` text,
  `theme_code` varchar(255) DEFAULT NULL,
  `is_editable` tinyint(4) DEFAULT NULL,
  `is_protected` tinyint(4) NOT NULL DEFAULT '0',
  `is_specific` int(11) NOT NULL DEFAULT '0',
  `is_multilang` tinyint(4) NOT NULL DEFAULT '0',
  `type` varchar(255) DEFAULT NULL,
  `page` varchar(255) DEFAULT NULL,
  `image` text,
  `is_active` tinyint(4) NOT NULL DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `theme_settings` (`id`, `name`, `color`, `display_name`, `value`, `theme_code`, `is_editable`, `is_protected`, `is_specific`, `is_multilang`, `type`, `page`, `image`, `is_active`, `created_at`, `updated_at`) VALUES
(1, 'custom_primary_color', 'primary_color', 'Custom Primary color', '#0f0f0f', 'custom', 1, 0, 1, 0, 'color', 'theme', NULL, 1, '2025-02-27 08:13:52', '2025-02-27 03:13:52'),
(2, 'custom_secondary_color', 'secondary_color', 'Custom Secondary Color', '#003c40', 'custom', 1, 0, 1, 0, 'color', 'theme', NULL, 1, '2025-02-27 08:13:52', '2025-02-27 03:13:52'),
(3, 'theme_1_primary_color', 'primary_color', 'Theme 1 Primary Color', '#1D5DBC', 'theme_1', 0, 0, 1, 0, 'color', 'theme', '/images/themes/theme_1.jpg', 0, '2025-02-27 08:13:52', '2025-02-27 03:13:52'),
(4, 'theme_1_secondary_color', 'secondary_color', 'theme 1 Secondary color', '#3ECBB5', 'theme_1', 0, 0, 1, 0, 'color', 'theme', '/images/themes/theme_1.jpg', 0, '2025-02-27 08:13:52', '2025-02-27 03:13:52'),
(5, 'theme_2_primary_color', 'primary_color', 'Theme 2 Primary Color', '#3784A6', 'theme_2', 0, 0, 1, 0, 'color', 'theme', '/images/themes/theme_2.jpg', 0, '2025-02-27 08:13:52', '2025-02-27 03:13:52'),
(6, 'theme_2_secondary_color', 'secondary_color', 'theme 2 Secondary color', '#000000', 'theme_2', 0, 0, 1, 0, 'color', 'theme', '/images/themes/theme_2.jpg', 0, '2025-02-27 08:13:52', '2025-02-27 03:13:52'),
(8, 'default_primary_color', 'primary_color', 'Default Primary Color', '#294481', 'default', 0, 0, 1, 0, 'color', 'theme', '/images/themes/default.jpg', 0, '2025-02-27 08:13:52', '2025-02-27 03:13:52'),
(9, 'default_secondary_color', 'secondary_color', 'Default Secondary Color', '#2769FF', 'default', 0, 0, 1, 0, 'color', 'theme', '/images/themes/default.jpg', 0, '2025-02-27 08:13:52', '2025-02-27 03:13:52'),
(10, 'custom_tertiary_color', 'tertiary_color', 'Custom Tertiary Color', '#cee6e7', 'custom', 1, 0, 1, 0, 'color', 'theme', NULL, 1, '2025-02-27 08:13:52', '2025-02-27 03:13:52'),
(11, 'theme_1_tertiary_color', 'tertiary_color', 'theme 1 Tertiary color', '#F6FCFC', 'theme_1', 0, 0, 1, 0, 'color', 'theme', '/images/themes/theme_1.jpg', 0, '2025-02-27 08:13:52', '2025-02-27 03:13:52'),
(12, 'theme_2_tertiary_color', 'tertiary_color', 'theme 2 Tertiary color', '#f6f6f9', 'theme_2', 0, 0, 1, 0, 'color', 'theme', '/images/themes/theme_2.jpg', 0, '2025-02-27 08:13:52', '2025-02-27 03:13:52'),
(13, 'default_tertiary_color', 'tertiary_color', 'Default Tertiary Color', '#f6f6f9', 'default', 0, 0, 1, 0, 'color', 'theme', '/images/themes/default.jpg', 0, '2025-02-27 08:13:52', '2025-02-27 03:13:52');

ALTER TABLE `theme_settings`
  ADD PRIMARY KEY (`id`),
  ADD KEY `name` (`name`) USING BTREE;

  ALTER TABLE `theme_settings`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;
