-- Adminer 4.8.1 MySQL 5.5.5-10.4.22-MariaDB dump

SET NAMES utf8;
SET time_zone = '+00:00';
SET foreign_key_checks = 0;
SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';

DROP TABLE IF EXISTS `activities`;
CREATE TABLE `activities` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `url` text NOT NULL,
  `data` text DEFAULT NULL,
  `client` int(11) DEFAULT NULL,
  `admin` int(11) DEFAULT NULL,
  `ip` varchar(100) DEFAULT NULL,
  `device` varchar(255) DEFAULT NULL,
  `browser` varchar(255) DEFAULT NULL,
  `created` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `admin` (`admin`),
  KEY `client` (`client`),
  CONSTRAINT `activities_ibfk_1` FOREIGN KEY (`admin`) REFERENCES `admins` (`id`) ON DELETE CASCADE,
  CONSTRAINT `activities_ibfk_2` FOREIGN KEY (`client`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `admins`;
CREATE TABLE `admins` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `first_name` varchar(255) NOT NULL,
  `last_name` varchar(255) DEFAULT NULL,
  `email` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `phonenumber` varchar(255) DEFAULT NULL,
  `last_login` datetime DEFAULT NULL,
  `is_admin` tinyint(1) NOT NULL DEFAULT 0,
  `otp` varchar(50) DEFAULT NULL,
  `otp_sent_on` datetime DEFAULT NULL,
  `token` varchar(255) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `status` tinyint(1) DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  `created` datetime NOT NULL,
  `address` tinytext DEFAULT NULL,
  `modified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `admin_permissions`;
CREATE TABLE `admin_permissions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `permission_id` int(11) NOT NULL,
  `admin_id` int(11) NOT NULL,
  `mode` enum('listing','create','update','delete') COLLATE utf8_bin NOT NULL,
  `created_by` int(11) NOT NULL,
  `created` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `permission_id` (`permission_id`),
  KEY `admin_id` (`admin_id`),
  KEY `created_by` (`created_by`),
  CONSTRAINT `admin_permissions_ibfk_1` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  CONSTRAINT `admin_permissions_ibfk_2` FOREIGN KEY (`admin_id`) REFERENCES `admins` (`id`) ON DELETE CASCADE,
  CONSTRAINT `admin_permissions_ibfk_3` FOREIGN KEY (`created_by`) REFERENCES `admins` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


DROP TABLE IF EXISTS `blogs`;
CREATE TABLE `blogs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `image` text DEFAULT NULL,
  `type` enum('latest-news','our-products','latest-articles','our-services','our-process','about-us-feature') DEFAULT NULL,
  `meta_title` varchar(255) DEFAULT NULL,
  `meta_keywords` varchar(255) DEFAULT NULL,
  `meta_description` varchar(255) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_by` int(11) DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  `created` datetime NOT NULL,
  `modified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `slug` (`slug`),
  KEY `created_by` (`created_by`),
  CONSTRAINT `blogs_ibfk_2` FOREIGN KEY (`created_by`) REFERENCES `admins` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `blog_categories`;
CREATE TABLE `blog_categories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) DEFAULT NULL,
  `title` varchar(255) NOT NULL,
  `image` text DEFAULT NULL,
  `type` enum('news-categories') DEFAULT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  `created` datetime NOT NULL,
  `modified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `slug` (`slug`),
  KEY `parent_id` (`parent_id`),
  KEY `created_by` (`created_by`),
  CONSTRAINT `blog_categories_ibfk_1` FOREIGN KEY (`parent_id`) REFERENCES `blog_categories` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `blog_categories_ibfk_2` FOREIGN KEY (`created_by`) REFERENCES `admins` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `blog_category_relation`;
CREATE TABLE `blog_category_relation` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `blog_id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `blog_id` (`blog_id`),
  KEY `category_id` (`category_id`),
  CONSTRAINT `blog_category_relation_ibfk_1` FOREIGN KEY (`blog_id`) REFERENCES `blogs` (`id`) ON DELETE CASCADE,
  CONSTRAINT `blog_category_relation_ibfk_2` FOREIGN KEY (`category_id`) REFERENCES `blog_categories` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


SET NAMES utf8mb4;

DROP TABLE IF EXISTS `brand`;
CREATE TABLE `brand` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `image` text NOT NULL,
  `created_by` int(11) DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  `created` datetime NOT NULL,
  `modified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `created_by` (`created_by`),
  CONSTRAINT `brand_ibfk_2` FOREIGN KEY (`created_by`) REFERENCES `admins` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;


DROP TABLE IF EXISTS `cities`;
CREATE TABLE `cities` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `city` varchar(255) NOT NULL,
  `city_image` varchar(255) NOT NULL,
  `city_icon` varchar(255) NOT NULL,
  `state_id` char(255) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`),
  KEY `state_id` (`state_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `contact_us`;
CREATE TABLE `contact_us` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `first_name` varchar(255) NOT NULL,
  `last_name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `phonenumber` varchar(255) NOT NULL,
  `message` text NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_by` int(11) DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  `created` datetime NOT NULL,
  `modified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;


DROP TABLE IF EXISTS `countries`;
CREATE TABLE `countries` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `iso2` char(2) DEFAULT NULL,
  `short_name` varchar(80) NOT NULL DEFAULT '',
  `long_name` varchar(80) NOT NULL DEFAULT '',
  `iso3` char(3) DEFAULT NULL,
  `numcode` varchar(6) DEFAULT NULL,
  `un_member` varchar(12) DEFAULT NULL,
  `calling_code` varchar(8) DEFAULT NULL,
  `cctld` varchar(5) DEFAULT NULL,
  `status` tinyint(1) DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `email_logs`;
CREATE TABLE `email_logs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `slug` varchar(100) DEFAULT NULL,
  `subject` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `from` varchar(100) NOT NULL,
  `to` text NOT NULL,
  `cc` text DEFAULT NULL,
  `bcc` text DEFAULT NULL,
  `sent` tinyint(1) NOT NULL DEFAULT 0,
  `open` tinyint(1) NOT NULL DEFAULT 0,
  `created` datetime NOT NULL,
  `modified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `email_templates`;
CREATE TABLE `email_templates` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `type` enum('admin','client') DEFAULT NULL,
  `subject` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `short_codes` tinytext DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `modified` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `faqs`;
CREATE TABLE `faqs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_by` int(11) DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  `created` datetime NOT NULL,
  `modified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `created_by` (`created_by`),
  CONSTRAINT `faqs_ibfk_1` FOREIGN KEY (`created_by`) REFERENCES `admins` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `feedback`;
CREATE TABLE `feedback` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `rating` tinyint(3) NOT NULL,
  `category` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_by` int(11) DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  `created` datetime NOT NULL,
  `modified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;


DROP TABLE IF EXISTS `help_supports`;
CREATE TABLE `help_supports` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `first_name` varchar(255) DEFAULT NULL,
  `last_name` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `phonenumber` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_by` int(11) DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  `created` datetime NOT NULL,
  `modified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `created_by` (`created_by`),
  CONSTRAINT `help_supports_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  CONSTRAINT `help_supports_ibfk_2` FOREIGN KEY (`created_by`) REFERENCES `admins` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `home_settings`;
CREATE TABLE `home_settings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `page_id` int(11) DEFAULT NULL,
  `section1_title` varchar(255) DEFAULT NULL,
  `section1_menu` text DEFAULT NULL,
  `section1_image` text DEFAULT NULL,
  `section2_title` varchar(255) DEFAULT NULL,
  `section2_menu` text DEFAULT NULL,
  `section2_image` text DEFAULT NULL,
  `section3_title` varchar(255) DEFAULT NULL,
  `section3_menu` text DEFAULT NULL,
  `section3_image` text DEFAULT NULL,
  `about_main_title` varchar(255) DEFAULT NULL,
  `about_main_sub_title` varchar(255) DEFAULT NULL,
  `about1_title` varchar(255) DEFAULT NULL,
  `about1_description` varchar(255) DEFAULT NULL,
  `about1_link_title` varchar(255) DEFAULT NULL,
  `about1_link` varchar(255) DEFAULT NULL,
  `about1_image` text DEFAULT NULL,
  `about2_title` varchar(255) DEFAULT NULL,
  `about2_description` varchar(255) DEFAULT NULL,
  `about2_link_title` varchar(255) DEFAULT NULL,
  `about2_link` varchar(255) DEFAULT NULL,
  `about2_image` text DEFAULT NULL,
  `about3_title` varchar(255) DEFAULT NULL,
  `about3_description` varchar(255) DEFAULT NULL,
  `about3_link_title` varchar(255) DEFAULT NULL,
  `about3_link` varchar(255) DEFAULT NULL,
  `about3_image` text DEFAULT NULL,
  `certification_main_title` varchar(255) DEFAULT NULL,
  `certification_sub_title` varchar(255) DEFAULT NULL,
  `certification_image` text DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  `created` datetime NOT NULL,
  `modified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `created_by` (`created_by`),
  KEY `page_id` (`page_id`),
  CONSTRAINT `home_settings_ibfk_1` FOREIGN KEY (`created_by`) REFERENCES `admins` (`id`) ON DELETE CASCADE,
  CONSTRAINT `home_settings_ibfk_2` FOREIGN KEY (`page_id`) REFERENCES `pages` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `migrations`;
CREATE TABLE `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


DROP TABLE IF EXISTS `newsletter`;
CREATE TABLE `newsletter` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `email` varchar(255) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_by` int(11) DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  `created` datetime NOT NULL,
  `modified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;


DROP TABLE IF EXISTS `notifications`;
CREATE TABLE `notifications` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `rel_id` int(11) DEFAULT NULL,
  `from_id` int(11) DEFAULT NULL,
  `to_id` int(11) DEFAULT NULL,
  `message` varchar(255) CHARACTER SET utf8 NOT NULL,
  `type` enum('audio_uploaded','video_uploaded','meeting_created','meeting_updated','made_announcement','schedule_uploaded','poll_created','poll_submitted','subscribe_creator','renew_creator','changes_in_plan','review_received','review_updated','questions_received','video_likes') CHARACTER SET utf8 DEFAULT NULL,
  `read` tinyint(1) NOT NULL DEFAULT 0,
  `created` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `modified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `cc_user_id` (`rel_id`),
  KEY `from_id` (`from_id`),
  KEY `to_id` (`to_id`),
  CONSTRAINT `notifications_ibfk_1` FOREIGN KEY (`from_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  CONSTRAINT `notifications_ibfk_2` FOREIGN KEY (`to_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


DROP TABLE IF EXISTS `pages`;
CREATE TABLE `pages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `image` text DEFAULT NULL,
  `meta_title` varchar(255) DEFAULT NULL,
  `meta_description` varchar(255) DEFAULT NULL,
  `meta_keywords` varchar(255) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_by` int(11) DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  `created` datetime NOT NULL,
  `modified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `created_by` (`created_by`),
  CONSTRAINT `pages_ibfk_1` FOREIGN KEY (`created_by`) REFERENCES `admins` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `permissions`;
CREATE TABLE `permissions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  `permissions` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `products`;
CREATE TABLE `products` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sample_no` varchar(50) NOT NULL,
  `title` varchar(255) NOT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `description` text NOT NULL,
  `small_description` text DEFAULT NULL,
  `image` text DEFAULT NULL,
  `meta_title` varchar(255) DEFAULT NULL,
  `meta_keywords` varchar(255) DEFAULT NULL,
  `meta_description` varchar(255) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_by` int(11) DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  `created` datetime NOT NULL,
  `modified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `created_by` (`created_by`),
  KEY `sample_no` (`sample_no`),
  KEY `slug` (`slug`),
  CONSTRAINT `products_ibfk_2` FOREIGN KEY (`created_by`) REFERENCES `admins` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `product_categories`;
CREATE TABLE `product_categories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) DEFAULT NULL,
  `title` varchar(255) NOT NULL,
  `image` text DEFAULT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  `created` datetime NOT NULL,
  `modified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `slug` (`slug`),
  KEY `created_by` (`created_by`),
  KEY `parent_id` (`parent_id`),
  CONSTRAINT `product_categories_ibfk_2` FOREIGN KEY (`created_by`) REFERENCES `admins` (`id`),
  CONSTRAINT `product_categories_ibfk_3` FOREIGN KEY (`parent_id`) REFERENCES `product_categories` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `product_category_relation`;
CREATE TABLE `product_category_relation` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `product_id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `blog_id` (`product_id`),
  KEY `category_id` (`category_id`),
  CONSTRAINT `product_category_relation_ibfk_1` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE,
  CONSTRAINT `product_category_relation_ibfk_2` FOREIGN KEY (`category_id`) REFERENCES `product_categories` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `product_forms`;
CREATE TABLE `product_forms` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `product_id` int(11) NOT NULL,
  `sample_no` varchar(50) NOT NULL,
  `first_name` varchar(255) NOT NULL,
  `last_name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `address` text NOT NULL,
  `cell_number` varchar(255) NOT NULL,
  `city` varchar(255) NOT NULL,
  `zipcode` int(11) NOT NULL,
  `message` text NOT NULL,
  `form_type` enum('order','query') DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `modified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `product_id` (`product_id`),
  CONSTRAINT `product_forms_ibfk_1` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;


DROP TABLE IF EXISTS `settings`;
CREATE TABLE `settings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `value` text DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `settings` (`id`, `name`, `value`) VALUES
(1,	'company_name',	'Tech Cruizer'),
(2,	'website_url',	'https://globizcloudserver.com/sgp/public'),
(3,	'measurement_unit',	'pc'),
(4,	'currency_symbol',	'₹'),
(5,	'company_address',	'B-X-349, Kucha Kaka Ram, Rehmatulla Road, Opp. M.K. Finishers, Ludhiana - 141008. (Pb.) INDIA'),
(6,	'company_gst_number',	'1888998520'),
(7,	'currency_code',	'INR'),
(8,	'admin_recaptcha',	''),
(9,	'admin_second_auth_factor',	''),
(10,	'recaptcha_secret',	'6LdhM1oaAAAAACK2IkHNxnjEMh5Jkoa5hl2aZb0i'),
(11,	'recaptcha_key',	'6LdhM1oaAAAAADJXL3qLn2sxBpbMTdnaHZwV8hL1'),
(12,	'sendgrid_api_key',	'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'),
(13,	'sendgrid_email',	'vermani.ritish@gmail.com'),
(14,	'pagination_method',	'scroll'),
(15,	'globiz_logo',	'data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAZAAAABwCAYAAAAwjCb6AABHDklEQVR42uydB1hU19qFtwiIXezG3hUboKgRsGCJvScmxkRjib3caNRYYjQajSZq1Fy9RnOtsVeINSrRJPaOig0slBk60uv3rz0/XIkC4ewZZs6M+32e9aDADNPOXrt8hRERk5KSkpKSUipVPAgpKSkpKfOTKh6ElJSUlJT5SRUPQsryFR4ezh4/fmx0PXjwgN25c4ddv36dXbt2jd28eZPdv3+fBQUFsbCwMDsiKgmVgypA5aFS/Pv8576+vuzWrVv8drrb+/j48PszyfPw8/NTxfsoJaXYQHBBsW+++YYtWrTIKFqwYAGbM2cOmz59uk5fffUVW758Odu0aVOpo0eP1jx79qwjBgFXyAPqCLXDBd4SP2u4f//+SuvWrbPj9/PFF1+wzz//nM2cOZPNmzePLVy4kN+/6rVs2bICMTExA4loDDT6HzQmPT39059//rms0r/DB0UiYlqtNt+fU7NmzZitra1RVKBAAZZJkSJFmKOjY+VPPvmk0/fffz/50KFDa2EIR4ODg6/B1PyISAOFQ5EZXzX4vj9+fv3q1avHf/311/989913nw0bNuyd5s2bVytRogTLio2NjVGek52dHfvXv/6Vp9cahtOOiMZCo42sMdCnCQkJH+KafAfXacOffvqpGK5ffh3rrsHIyEhGROyvv/4y6jX16NGjtgpekzHHjx93MNC1bI1reXDmtWxGGgMNgQrqbSB85mVsqlatWq1fv3698SbM9/Ly2n/jxo2bz58/17x48SIhLi6OUlNT/6akpCTCz1JhdtG4gPx+//33sxs2bFg/ceLE0a6uri1wARZhZgIGJVsMYkGkAGdn53ZMIT/++KPu/cVAySyJMmXKFHn33Xc98P5/e/v27fOJiYnRZABSUlJiMTBe2bJly4ohQ4Z0feutt0owFeLt7X2YTAy/JnGdpmLl9BzXr+fkyZMnNGjQoBYGckZEbP78+cyYnDp1aj8pYMqUKXMMdC3b41qOJ/PkBian1nobyN27d5mVlRXLTwoVKsTat2/vtHLlyrnYOvgjLS0thgxIRESEH2YVWyZMmDCwdu3apZmKKVu2rC0e7wNSQNu2bd2YQjA71L2/MGdm7vCVQLdu3Vrs3LlzeWho6CMyAtHR0c8OHDiwDmbVtnDhwkwt/PHHH7tIncTCWPhjc+e7DMYEE8pfSAHYvZhuoGvZHteylsyQHTt29IuPj2eqNpC6deuWxRJ3DGZ2fxJRGhkBzIwCsdW1rlevXm9bW1sztSENJHdssEVVs5ANq4l/1ytfzmrUqFF9cbZxgojSyUTg8/vXtGnTPnaoVtWOP65attasVmE7qJDeyrwfPG9zN5D/gZXhHkwYHRhHGojqwCT+BsaUgliBqNNAsJ9cFWcVi/hgTiYEA8/JESNG9OJ7zGpBGkjulIP83Z1Z9Iol/ZODg86TikiNjPCJ2rh2eFAXV5vAlg4s0N2JBbZ11kvB7ZqzZ7if2kXsLMZAMohZsWLFZzinkgaiMsaMGTMEOzWMiNRlIFhxlIFxLMBSNoxUBGZEpz/66CMP9k9IAzE5g/v0aZX86MFxUjOaoMsvZk7uFtapNQtt05SFtW8hrIgOLkwLE6ljeQaiAwfqe6pVq1ZSGog6wJnN/ZIlS9oh8EU9BsL3iGfPnj00KirKn1QMzkk2OTk5VWE5IQ3EZGCQKb5r165lRJRMKifx7GkKG9CNIiaM2BI2oGtlTcuGTNvWmRuBYoXCRILaOlusgXCePn16vlGjRhWkgZier7/+eiwDLi4u6jAQREHVQaSPJ5kJ2FYLmjFjxmCWLdJATMGAAQNcEVp7k8yA9LhYChvUizSOtSj8w76U+tQ/IHrxvPc0Lg2Y1q2ZNJAcQJTllfr165eWBmI68FiflS9fvphqDIQPxAijDCUzxNPT8z8I1SzK/oY0EGOCIAeeAzSZiBLJBKQ8fkiJp45T4u+nKT3mBeWFtLAQCunYmoIbVaOoqeMokwSvg6tCurSx07ZpKg0kB5C4ecLe3t5GGohpQGj/dAZMbiDYQyu4e/fu78nMefLkyfnWrVvXYhlIAzEe5cqVs0Ui33oyIunxcZR05SLFbfuZIsYOJW17F9K4NMRqojZFzZxM6YkJuZtHeNj/trAiRn9M2Lai8KEDKeHEEUp94kcJngfOhPZoX0vr5igNJAewTblUGojxQchuCE9xMLmB1KxZs+SVK1cOk4WALa1nPXv2bM10SAMxBlWqVCmJx3WUjEhaZARFjBlK2GoiTQuoVSPSujsRBnGdEWhdm1HYB70pZvV3lPr8abYrD5x3UIrv3Qw3SqfUZ08o4tMh3IB09xHaswOFdGsbjH93lgaSMx9++GEHaSDGhQc3MWBSA6lVq1YF1AtSVWilgbKQoxDa1okxaSD5TdOmTcsig/lPyl8S02NjAtNCND7YpjqXfPvG/YiRg2Ec9blh5Ky3m5DGuS5hK4qSzp0hwM84dKuVyM8n6MwnYsRgihg/nMKHDaLIz8ZSKEwFKw7SmZC77iu/rwRosBoMZO/evZs//fTT/tAAPfTel19+OWbbtm0rcP1f0DenKzAw8CYqCtiau4FgFW2PpOg4UjmIio1CEEMlkxpIw4YNK2LL5zoZnhR8oO6iHMEe7NEtQG2rEQi57d2/f/9OkAfUbdKkSYNQr+tfWP6uQUiuN1YNIWR4YrmJSAPJP6pXr26P9/p8PswAIrAyOBa/55cvoud/0Tli1JDaoX07lwjp6sYH6VoY2G9yc8C/8yRN60YU2r0tJZw8SnGbf6LgZrV039O2b8FNRrd60bzdmH/l5pHT/aRDw01tICj3M8HQVSU6d+7c/MiRI5tID5BgPNLcDQSvhTWqX7yPMetTaFR+CvXGhl+4cGEfCYBJxAoGTGYg2LayRzbuJUNe8hjYfkPJg3GI4mqIInbWLI/wYno1atQoA5Pp8ssvv6xGyYknZDiikcHeWhqI4alQoYIdCjz+ZuBD8FOx61cPCx/S7y1sRzFN8/oM21MMgz3DlhTD4F4LK4IHUG6DPL0mGAVuC9NoTNoOLvx7okqHPjClgaDg6FSWT4wcObIHiisGkQAoSeOLVUghczYQY4M6gOcFVh9xSF2oaTIDKVWqlC1m/ccNtFUUjcP31Z06dWpWsGBBQ+UPlIA7D/X3979koMOmoDZt2tSRBmLYWStWmFvJQCT73NwX/eV0NwzAMI16DKuB7PIwKkH3IMpGEdBPUApE2Smkiytx43lpPsJKgDws0UA47dq1a4jPs9AkbvTo0b2lgeQNvFb9SYATJ05sYMAkBsK/j3DXdaQ/qSi1vQ5OWJvlEzC6gjCSj5Fp+Yj0JCAg4DoqBheXBmIY1q5dO5MMQGpQwF/RC2Z58CgnnGcwrDpymtnbQGcgykF3oSsQGUlaqJ4lGggHQShOmOm+IIWcPn16tzSQfwblYApg9SFybpjcsWNHB5MZCLaYRhkgVPYiTxRjRgLbbaX37du3ivTk3Llz21AFVhqInvASMgYopJkYf3DPzJCu7tZYceRmHFx20E8QZSO/zFWJCXQZKmKJBsJBP5YJAqt9LY/IkwaSO4MHD+5IAmDVv5MBkxgInKsxqjXGkh4gamMZ9r4LMROAJV9fHLZr9Ez7HyUNRJw6deqURpMhf9KD9OioB1Gzp7ry8w2ta56S9AZDlIN2QvsgMpHWWKqBICLJBqv/u6QQ9AVylwaSe7ItKn2IhLyn9ejRo4VJDIQfaj98+PA8CcJD2xA58CEzMTjLqI+on+t6PI8X7u7udaWBKIcHO/D9V9KD1IBn3uFD+lfUONdTkt09Og+DeIgJTaSLJRoIBjreGXCqwCRtojSQnEFQj4vICh6dOb34e2ISA/nhhx+m6hFzHIEllyoq33IQ/1wWQQC/61F+4TgOgaWBKARd/TxID5JvXfcM7d2xKDLFldaXegeiHBQLlYRmm9BAfKGilmYg/BpBfk8TPgSQAhBUs0YaSM7wbSgSYODAgW0ZMLqB4KC7Gk+sEzSPaJiHG1MZFStWLIkV1R8kCJoJfSANRFGpGxsUz7tGgqQ+enAMUVB2mlYODCG1Sg2kLHQUep5NNFRPqD60CyIT6ksLNZCiRBSgcJ9+vzSQ7PHw8GhAREmkkDt37njz1YdJDATbDj+TGMnDhw/vxlRKkyZNyoeEhNwTbZnLq1hKA8kbyFoeQYJEBwZcDRzYraT2pXmIajdEGYqH1kFloJMQmVjRUFULNBBGRNcVDnYnsd0pDSQbeOSqYMOo7gwY3UBwcM6XoCkkwJIlS8YzldO1a9cmONeIJgHWrFkzTRrIP4MKx0WQ3PmYBIiJjw/9wKN97fvNarOwDi55NYoK0H5oFWQNMaghFA4RlAJthvwyvhcLkQq0ykIN5DwpAOPPGWkgr+Ps7FwVO0ExpBCE+15C2K+VUQ0k8w08c+bMdhLA29t7K08MNAcwOx4q2keEF5KUBvKPr+9IEmTMpEn9+DIvAC1tw/K++miZJbejDLQAinolGzxJJaaRVS+gKhZoIDdJAYgwOiYN5HW2bt26hAQYP378ewwY1UA4LVu2rCfSl+HFixdP0MrWnpkJ+LDyi3APCYDggtnSQHJN5rRG1NttEgCl3TcyUNXWhj1XZiCFoXaQB3ReJeaQV82zMAMpRUQhCvvybJdnIK8VrS2LCWsYKUSr1fqULl3axiQGgrpS35EAkydP7s/MDL48RK/mQyhOdhQ6kkcd3bx58xJpIDmDM7Cugqs7DSYh5RiobldIqYFweUBalZiCEvnBQIpYkIG4CTQ5WiANxDCVG+bMmTOcAaMaCB9geNmOmJiYIFIIiuMd56f9EmkgnD///FNoZbdw4cLxDAgaSEsoTSWGoFgwkJ6WYCB8Cxv77ysF6mH1lQbyEh6sExUV9YwUggChxyhOWcToBnL+/Hk2bty4AaScNJQoacUk0kAA+l1XFKmHhKqs9/Ga2OlhIGWh/WoxBAED2WwJBtK4cePyKE0SpjBRN8bBwaGiNJCXILFyNAmAUjKTGTC6gSBjkaHu004CCg+/vMzl4FxNWKqBoJDlMMG+EGMYEDcQnaapxRAEDCQQBlLc3A3k4MGDa0khly9f5mOILKb4Mn/KViTVgO8eoSp5SZMYCA7BS2DmoBFoS9mZSaSBZHD27Nm9pJDY2NjgypUrlxAwkM7QVmgXNALyhigXBUOpufw8AFoJEXQO0hjRQAgG0sGcDeSzzz57lwQYO3bsAFmN9yU4Tx5EAqxatWo2AyYxEMhDoCXlHdTLkocf0kAycz+KwQyCSCHoMLmSAYUGUihrlnk2xhAB/fJKvscTyA+iHLQBsoGWQtWg4tBoKNBIBjLPXA0EJtCdiOJIIcHBwb729vayoVQGxYoVs3r27NklUkhycnIYusWWM6WBzBOInJjHJNJAMuBdHEmAvn37thIwEK4dEGWj+1B9qCqUDFGWwolp/5CT4QsFQPegUVAL6IGRDOSouRlI8eLFC2Lf/V8ipTY4vNiqube0NSQff/xxVxJg+/btSxgwpYEcIWWkI6O7OZNIA8kA5xgTBWLW7yNvxEbAQN6GjuVQHqQBxCBniKCLUNcsiYVxr6xcnqvgDIQC2zo/qVXErnB+GAh6do83cL8d+ylTpryvT7VuHx+fM0WLFrWSBvIyBBqvySmB1UcMgheqmNJACkF+CqNmHuuWnhJpIBkcPnz4Z1IIbrOeAQED6QFRNroHLYbWQv+GbkEdoLsQQbehQRBl6GdothoMBM812blE0Tr5YSCoEuG1dOnSz6HpemjWli1bvsPf9nq5VSlcrTvGzc2tAQPSQADo06dPGxIASZg/MmBKA6kBJSj8QO5mEmkgWfpA+Pr6/iVQ4XiIoIFwfQyFQ5SL4qFr0FboEfQ+xDJMYz5UGJplagMJgeI8WlL/8qU98mwgZgyS3YYyIA3kb5Ux9pNyEmDEdU1tIG4C5Ty+YEbAzs6OFS5c2EqtwrJTGghAx0lePPEZKSOtffv2TYUNBFJwPjEkl/uoCa2CFkNfQbtNYSKJHVvSuKoVPrZ0A+H79XzAlAbyki5duggVsD169OgWBkxtIO8JZI72Y/kM+iRXwh7rZUQl3FapfHbu3LlaGghjiACpQkSxCkuXhCB8t5QeBjJFwQAdDK2B6r6yDbYX+gPqDQ2CpkIupjCQBBjIN3WqTrdkA0Hfj58ycj6kgWQBNeBE2mekdOrUqakaDGQiKQQl311YPlMHkMp58ODBBRsbmzfeQDp06NCUFIKaSTexgisgaCDVoTCIFCoAmgj9+sr307P8+6apDGRJ3WrfWKKBINs8BUmGPyBJjr/f0kCy0Lp165q8/Tcp5OLFi/u5GavBQOaSMpJQtbc2y2dq165dCxEGSaRinjx5cgOD4BtvID179nQXqKGmayIkYCAFoeMQmUhxUGp+GMjiutVWWqKBJCUlRY8YMaITA9JA/g4K2C4n5aTzsHncXBUGsoQUkJiY+KJevXqVpIHoZtG+MBDrN91A8GHuSgo5cuTIHgYUGogdtAEiEyoYWg3FGdxA6lRdbYkGkkH6vn37VuK8zE4aCAANGjSogPE0UmDydYI3AFSLgXxPCsBhaQQ+BOWkgegM5BEMxPZNN5CJEyf2FjCQLQoNpALkrZL6VSegc1n+H5ZhLM+g+1CIkIHUq77Kgg0kc9vXG0U3K0kDYWzjxo1zSYBPPvmkI26uGgNZprB5VGSlSpXKSwPRGchDGIjNm24gCMftK2AgmxUYSAFon0rMI1Mvsvz7EtQCKg7Z6MyurfMVxQbiUPs7SzeQjK3fWzCRym+ygSCApCQm40GkEITL/8nPDtVkIIsUJgHFOjo6VpEGojOQu3gzrd50A3n//fd7kEK8vLx+UWAgVaFEIxuEBopR8PtrIaYTHjcMZI2mpQPha+63a9OUNK0aUUKHFrSspeO8N8FAOP7+/lfQda/km2ogy5Ytm0gCjBw5sg8DajKQmaSM1FatWjWUBqK7CC7LQ3TGunXr1pEUgkHQU8EhuitERtZjaKOC3x8GMZ1aN2YxyxcviZ43g7RujjCRbH7ftRlpmtej0N4dKf7gHkr7bAzNcmo86U0xEA46gu61tbV94wwE5XvsULL9oUAB2+uIZCuoNgMZJVAAr600ECI04jqOQfCNN5Du3bu7CCzF/8JBYF4NpD9EJtC3eeyxvgFimdK0bMiSLp3fSCBq7jTC/18zj9Ae7Sl60VxK0wSTDv9HNKZj+6H5YSDbtm1bP2jQoM5QF32E9g29586dOxr5T2ueP39+gwzAkiVLxr1pBjJjxoyPSAAUxfyQAbUZSC+BJ/KxzAMhQgLQf2UiIWPY0uTvVTIpICwszA/N/wvl0UA+NpGBXIamQunZ/CwE2gWNg2wgphM6C2rdnVjK/XsnCCRd+IO0rRv9bysLP6MQ1L5K9rlFr/LRsGHd8sNAJk2aNJEZGLRysBo4cKA7kgP1Wg2lpKREOTk5VXtTDIRXMA4KCrouUngUr3khNRqIMykERdWWGiMT/dGjR1cCAgLuGEE+GND8BUq6zJUGwliNGjXsEY4YojC5LL5JkybV82ggw0xkIOnQAyjtlQq+R6E6EHtNbo4stHtbm7SI8AcE8FW32tC6NeO31a1GIj8bS9nRwcPDyZzKuWcydOjQLtiS8SVBEFDx85tiIDjD6E0CfPvtt2MYUKOBlIeiSAE3b948zbdu8hvUmyqAks8FjSCrBQsWfEpA4czufWkgjBUpUsQKWxq3SCGDBw/unEcD6QmRCZUOBUKXoXPQcIhlJw3OPyJGfFCT0tMTKYPIiSNwUO6A+8Eq5O3GlHjiSHbBKdENGtSvaI4GwqlXr165e/ew6hIgPT09qU2bNg0s3UAwnjGEMZ8lhURGRj5F5GsxtRqIFXSTFJCQkBCOCIoyzIJAYbKtAiVdnKWBAICe+gdEVnB5NJCi0AkTGkgi9Bv0MMNMIqAS2RpI8/rsxbcL+lEW4jatJ41THdJtX3VsRal+j+hVksNC79YtW6aguRoIB2NC4fDw8FMkwO7du5dbuoHgHKkdCYCIrWkMqNVAuBQPnsOHD+/JLIRy5coViYqKeqawGKAWbVxLSgMBAB0qvyKF3Lp16zTq+eQ1kbAEdEAlOSDXIOtsDcSlAUs8fWI1ZSEtOIhHW/GoK50ip03gSw7KSuLNa/tq21ibVUfC7MqSY9u5PBE9IYXExMQ8wyy7iKUaCP+cX7p0yZMUgq1hLY6D7dVuIGMFDpA3MQsB0SWdBMoJnEIUkSzn/rIdZw+BInuxTZs2raKglIk1tFMFBjI+O/NAdBUL7dXBJj066j69Qurzp5TgeYBwPkKhfToRJcRTVl7s3DqjFmNmbSA8pB25UUKBOZz33nuvg6UaCELdnYgolRSCbPX5DKjdQJpAaQqdMRyhthaxjXX8+PFNAj3hv5INpV7i4OBQiXeaI4UsXLhwjMJiisWgK7mcU0QbYfVhl+3qo0UDFjVvujvlQqr/Y0q+dYNeJeLLz90tyEC4TpJC8Hn92lIN5MSJE9sIKDwqiMTZUkXVGwgOQK01Gs0dgYt/AjNzUNCsIvJNokghaEHpJg3k710J79y5c44U8vjx4wu8NIPCcu6VoP9C16ED0BTICSoB1YY2QluhPw1sHjFQ8xwP0F2Q/3H+3EZSSnxcsLZvl+K1bQpajIEg7LQHDsdJCZcvXz6GbTCLMxBcu3WJKJEUsnfv3uUMqN5ALly4wMsKLyWgMJb/Ps4PzLo3+vr16+eSQjD4+8ME7KSB/J3Vq1fPIgH69evnJtiRsMA//LyPAc0jGuqVc/RVIxYxcvBbSGyIJoWkXr+yIwi3r1O4kMUYCEL9i6Dp2nNSAM/ORpa2raUZyP79+9cIbO/GoW1GDbMwEDQn4Xt0LYgonRQyf/78kcxM4VtwWCZqBGYGq2RP9NdBh7TGIvu8mMAcwswzZwMR1wQDmcdfULPc/hYOx1nCrwcXkgBxPy4fGIjb1yliZzEGgnGBHTp0aC8pgO8EYMumgiUZCM74KuN5RZNC0IDrJwbMwkBu377NkAtRAG/+JYHZ+NOqVauWYGYI+jN/SwL06NGjlTSQ10FdowJoQ3yelJOG8jht8sFA2hnAPI5DRXM1j1YOLHz4+5UwAkaQQtITE7QR73YvGfR2E4sykJkzZ7Kvv/56ASkjGQNuPUsykE2bNn1NyknC9d7QbAzk7t27jDN79uyRJMCuXbuWMTMDjez5bDmBFIIwxQt8oJQGkj1fffXVp4J9Is4iIbGAgQ3EBrqqZ/dBl1z/Rlvn/6999efZdSRA4u+n14S0dGBBbZ0tzkAwnowjhaDFa1NLMRBUaCiN8GQtKQQ5VTt4hKfZGUjFihWLx8bGBpByUlDS25WZCbyOz/3798+RALgwhjAgDSR7qlWrZo/PkJYEQDWAkQY1EP0LMd7O/b5b6Lauor6c7iqydQdSoz6f2DSkZUOLNJA5c+aMJoV07tzZ0VIMBGeCU0VW4++8805z3Ny8DCTT8VatWjWDgMiBOjJRSzEzYMOGDfNIAESqPUABQDtpIP+4NbhYsHd2RNPmLWrxrKmAts0NZSAFoJN6HJxXzvG+327MkNNRNC00xIcESL5z2ws1slhoO2eLNBBU7lU6lqShPpqDJRgIT05GCRJ/UgjOoz2ZDjM1kOrVq5dClnUgAYHD0AP8LIWpmAkTJvQWCRbgzJo1azgD0kByp1mzZpV5bScS4Nbde2ebVChv87ilg6EMhOsDiAQ1MJv7K6F1d2TaNk1Y0sU/N5Ag0XOnuWta1Geh7VtYnIHAPNjWrVs3KKyJFdu4ceMqlmAg2ModQUCgPpw702GmBsL55ptvxhEQPA9ZydP21QjKT7vw8tEkAO9/YG9vbyMNJG/s2LFjCQly7beTa/1aY3bv5mgoA1kNkaA2Qllrcv2kbeu0RuNcl8Xv2jaZBEm56/Orlj+/ts4WaSDYybDy8fG5pTAg5zmfuZu7gaBkuw12K3wESvucsbHJHGLM2EB4LDYGzGskCHJKFqrNRGAezRBOF0RAsJF9FwakgeS5sF5ZXYi0IAmH9s7l0U1a/U2kLhQPkaAeQgxygS5mlGSfGbt+dTciShP1j6iZk51QN4vfr0UaCEr9OOL9TyUF8ERUJKSafSLh+PHjBwiOMVn6wZixgWRUjnTnF4geJrIcUTVMDcA8XGEewSTI6dOnt/E8BWkgyli0aNFo0oP4A7tn6kzEtak+BjLCAGG870CJGebBOwmeIKIXJEjSH7//qMXzwurDYg0EWitQkfcHcy9lwrfw0er6PCnkyZMnF7FyyTIIm7mBcNC6crmePY/3oJJkaWZCpk2bNlhXo0mQ+Pj4oEaNGvHkJmkgyi8mK4TnniM9SPzt2OKQ9i5MZyTthM5EOkEkKB+oJtQBIi6sGvCYjpIo6fFxz8MG9ynD+6bj/izVQOpBcaSQsWPH9jN3A8EZRicSYOLEiQPZ37AAA6lQoUJhbGVdJz0IDg6+i2q37ZiRQTBAMWSMryA9wRvbhwFpIGJ4eHg0zhhMhEm+eW1n2KCepREyy2ftIlFYmxUaRwq0GrKH+N/shq+Er2gI1YSSr1wkUWJWLeurca7HH5fFGQjyoxhqmzEiOi5QODAC12wZczYQ/vzRbE/xcw8MDLxdrFgxG5YVSzCQjAGgUQqv76MfqXw1w7uWsXyGbzWNGjWqO4zrFukJHvMyBqSB6Aca4ownPUmPirwb9eXn7TUtHXjXP6Um4gylKzCQZMhJ26aprsZViEfL1brvuzpSSFc3QtguiYBCi/+GAfGe6RZpIPzae/r06SIS4OTJk9vMvaFUz549WwqWg/qEvYqlGAhn0qRJA8gAREdHP0MF3ykofVIqPxq28LMOhBIfJAOA8i7HEExgLQ3EMJV6dRe4/qQmnjm5Muz93uV55z/N23k2ksrQizwbiGtTwmqnW2i/LnY4h5kV/smgWN6SNrhpTYpeOJdESAvRXA7t5VEEBsIfj8UZCH+PV6xYMRtFAEmEd999183cDcTb23u3QP7cY0SeFWavYFEGkn1WpTjo/vcEyXxfu7u7N9I3bK1mzZr22GZ6D4PkcTIQAQEBt+rWrVuGAbUYSBvAFPKf//wnMyKGmZoqVaoUx0HhFTIA6QkJAfG7t08NG9SrNM+jwKokc1afkwpDT/JiHlh1JGOg947duHYiGkPdJhA5YQT/PkVNn0hpEeEiGZKaiLFDa+uirtq3sDgDwdZTSbSEXk8ZiIavmrOBoL11QyJKJoXMmzdvHDMRTk5ORjOQzNLni8iwJONvn4M5zUU3Mo+GDRtWRiSCdW57jLxwY7t27ZrxpD6+7EXSYwABA5rbY1dX15oMqMlAUMDRg2fBKxFKatsRkR1WU/z/+qgw9mj1Xo3x8tTIzn1KwDBGEv8swevgoshJIxuFdHDR9SPng7Rulu/m+Op5ySGIchNuRzhriU0LC31EWUgLD6PUZ8IPOy563oy2WNFkPg6jG8jUqVM/y6eSQNZTpkwZhDLs90gPUAapPWPMrA0ElYcVGyhK/jzHIF6eX2MmUGGYno1RDYTPErBy+JbyCURLvcCB0j2sJk4dO3ZsN+ro/xfaeODAge1oNuOFiJ7LeNGDFOwzKt1i84M51WdAbQYCYwsKDQ19DPnlVTiY9CMiP7yu/P/6yB8d1XYZ6FDdEY9HS4YlGZ3+zsXv2zk3au7n7cI+6FM+pIsrw6pBF72FVQqXA7a8QrACyNFANE51KW7bzwZ9XDE/Lu+LpENuFCYzEAyWU+3s7Ji+Qli+NVYbpVGryWXp0qUzEK56jfQEz2UH3342ZwNp0aJFNXymY0khSC2I4eWR+DVmCmFMOUlE1kYzkEzWrVs3lywMnjkK86jNgBoNxNRgm+GqAUMdeUUALeUXKSkRadrgG8m3rv+a9If3z+hF/gN6dSyKmjnlPg7FszcPhOdGjBnKy6sbzjzW/vAuVkV8JWRSA8FnLRCD/XXohj5CgyhfhLWHkIFAW2yto6PjW4wxszYQlGxZSubJM8jWUAYiUuslkSwAlFz4Da1tKzAgDSR7rl69ep4ZEF51lZ+FkRFJvnmVUACRMKC/Zh6hPTtQ6vNnZBDS0mJi1nzfOw/mIW4gFgDq0vVlwJwNBGel5WCqYWSePDSkgYjMJNthT/sxmTGHDx9ewwd0lok0EAEDEQNxAbUws71MRiI9Pp5C+79DOHQnFEMkTatGPNqKwj8aQCm+dwzzN2Jjn0XNmeaKbatM85AGkg2IEJzHgLkbCAJVviDzxbQGwkGWdsWzZ8+a3QeaL8VRcvoj9grSQAQNRDyCpwQu/u1kJOJ2bCYcuFNI5zaEHuYUv3sbzw4nQ5D6xM8b91kjS6KgNJBs8PT0/DfPWjd3A+H9k7CKfk7mi6ENRDwDE+Wbh+oioswAlFjZj4igbM87pIGIGIj+JTBwKDuJiGLJCKRpgik1KJAMScpvR5dGdHO3DUVzqHAYQpgCRXZw0RlJ3TfAQGAeP/IDeWD2BrJ48eKxZN6ow0AyQS3/SoiYWkNESaRCtFrtXYQ0vpdLzLk0EGED0R+EKjuhU+TvZEYkhoX6BC+Y3cW/RQPmjwx5f+Sj+Lsp01N0X3zk6shqWbiBYLtnTsbKw+wNBCHMhTCe+JJ5oy4DyZJU44S+vvwNTSEVgMHaDz1OplSqVKko+wekgZjOQDglS5a0wns1gRexJBWD5kcvkBc1v17VqsUqMsYq2VqzSoVsIRvFyryddYECFmkgPFgCJc57MQAswkAwEf2AzB91GkiWmH8nLy+v9Yh3jiATgAPaq+izPRZZ0CWZipAGkqeztUpoCbAMA3UUqYtE5ChtaN26dT1meCzNQFIOHjy4DgnCFRiwFAPhVaZRZPYKmT/qNpAsW1uVMauchFyCcwrS/UWTAYOwz/rfjz76qDNms+rqaiUNRCRSq+amTZuW6ppTmRDkrUQiqXVd165dm7BckAaiIxHlc3Z26dLFhWVgSQYybNiw7mQZGM5ABBCq1onD64aoPjn+zJkz+1ECwV+8aVVmmaGkaJ6hjtnqSnT06lG5cmV7pnJQRoAbiB+ZETCQy8yEIE+nPApxjnv48OFf+lQiEGj0c23lypXT0ee9GlMJ58+fP0DqIw2v1Q0E0iwgIgfkiTFjAlPdSwqYBQQDPgr6+vqeJcvA3yAGcu/ePR5JxStq5qte7eqHM4kiyP5uxKv9oofyLCx3f8JA5QlD+wvmcgO6C/lCPsiCvYKfncbZyq7t27d/x7em0DWxA1/doE7Ta5V58fdUq/Lly9ugCuclIoo2F6GUzDEF722+UbhwYd0Z25o1a+YgAfQctkdfGPhsIw4H+ReQp/B17969W+Ow1IrlH0KfW9RdWppxXdwzgXTXI/p+XLp48aInrsUfUKzxE973BZ9rq0ePHjEi4lF1Rr2msDpcrOA18UUB1qEif6d79+7NiChKLdelnroM2ehtIJjFM8zijSq4OMMAoKsUi8FJp2vXrjH0RWaYZbKgoCAu6wxZwUB0P0NhQHblyhV26dIl3Vdsi+lWULjo+f2ahfjzw8BXhojegiqZgd7CzLJUbs8J5eaZKcCKs0r//v17oufIPJy37UFDn2uopxaMmmnx2PbKqXkR4ecJ+D0NPoM3cbsDGPAWoKBnX/Ryr8FMxJEjR/L0+UHPjQK4JmwgaxPJCueL/PrNvBb5dcwnovxzrRtTsMI2wrUk/prAAIX+Dkoe2ZnRdZub3oLK5KWYopRUvgvbKmzXrl1GE5p9MWxbss2bN+v6niAiitck4rNzhlVqSZh0DZTldyQiV6gT9E7GVzccgDrh5zWRAFsK52UMVYv57XXCeQu/X37/Rn0+6AfOJ3KqeC+lpKSBSElJSUlJA5GSkpKSkgYiJSUlJWUmUsWDkJKSkpIyP6niQUhJSUlJmZ9U8SCkpKSkpMxPefqluMhIq989PW1/93opby9P60MHD7Cte/eyHfv2MVTZfU0HodOeh23472en3zwPF8z6+8cPHyp49ldPG3y14v/PTbhf67NenjZehw4WyPzeGS/PQvx7vx46lOPt8DsFz/3qZYu/Yf23v5vDY/TG/R06ePB/t/c6eNDq1d85heexd/9+tgWvxR58ze51OOPpaY3ftfE8iMeb9fte+D6U3e24jhw6VIA/p8zX6lXt3c/fg33895jviWPVE86dcYn0PuV49egR+1379rNfMt6b/JTX/7V3JdBNVev6pEmTtGmTNh3TJm3aDG2TNnMn2lILCCqgiIB6r/OEelGcr09BuS69XgUvKg5XFEScGEQERRARUCa5gIBQoBNlRgWZp07kfX9J8k43J7S0FHhrdS/+FXrOPmf/87f3v3dWIBOrE/BMOuY+AW9CspGNydbzBWw9xycz9Cph75GvTQHh3ll2+IanW1a/s2FDxn/ENMaMIDLNgV/R/YWM3r9mZGVlnjurpTzTIPun0AHp4iem7zwB2Ykf0hnxjn4tYod8vvPsKBxTRPA9iplQ+v+XAs+RbolX0vVXLX2eiX0m/nnyIMZEFGvB9Dp/NuzQGq/CvIkY3oIS2Y7e+f3sc8XaF9SPq5g/T38KsXZg8Q/21XPnRE1pJdbAv+TcOaZF3xDSN+lVyD8pHy1m/Jol8jnKScgDMeDRAV49yA8p0BebX0KC8bVm8SKpt6FB1GEAOfLFlNtXGzVVa+zG6l/sxtq1IHxWz8tKXfJicsxIPcclc8JNMtOsW7DBaapC/618qnCZa9/RJ77M7/xovGrk9rysyuHxqru4czfRVJN2brU7o8IVGpLlv4j3jd3hyax8SRv7vNBD6RyXtt5h3FjuNG22iDmj//pjCVGjKl1mkq+Gz+N6h2nripz0JZEcJ/P3tUtE3cpJHp8u1tmN21bZDFUzM3TfPhirvBNdxCC2hX2blbp0E8Y1cJw2IATHhcy36Odg7Iq/RikGC/HcP0Jetj03q+KN1IR/ckHafTGRt/9oTVuxzZNZf7DA6t2fb/FCv39MTNdMsklEWVwnt2wxV7DxjE6IaonWOYy10N3aF5NjR4VBfvYZ6OopsvWTCVH3s/fKwkLztnsyKz5I10xh7xlFnAFyTVhtM2wm3fv9cbPTXO2QiAz8vjCEcqFVvwo2X5/EcXH8e9NM2slb4T+PxKseFJIpTyrOofufGZMn8K/rIe5ah7EKY57l0zXujFrY8Rp+fyX+vaKNewm6WEc68euH+t4eHXGt0Ng3qsIHIbYWQL6atb7+5U5z7ZcZuo+5zmuiKcbkOTWQ2R0aYuHfeBO+Vwt7vKqLe0noQR3HJW5wGjd9b9HPJZ/2XQ6fb0n9eYPD1Mw/5Y7VdkMl/l9Df1P8v6tP/IDzNTnHxS62pv0CHZ2l12roaoRG/WBbeGUb7G6C/SsWWtO+kzCxybaBkWG3IdYqx+jiRwXr80Cs8q6fstNWwj8bDvlibYvL/Pv7aZoJVjFnDvbccxr1aMgM2VrmmF+hH8g9X+rXG9ozidEPQd+V8PP3OYEWDnUtQ15aZTeuUpOLCbQCqdiNHPk5xty/DzwSr3vysuo/NSbP4OeoPuHSG4gvsg+r9w229Or6Nf81dhhATk779LH9ngwvfgiH6DjoBKihsVe+13tlgfe3UvdvD2gTBrJChIpEoWvyc3Ye65FHzzXRM3461TOv8Su7+T1+/38Zdf/xXtXN+0+j7u/n9HT8W5GXvZXG7qVWufzX70yKu56u1RQ79sSGShTscy8YtH/39i70Ls21rpCKRAGDvWpKGQ9Z/PLV+3k8VJbbsLu7qyZZJpX7+14Rrex9AvIcQF+fHo4fQN8mny6+d2V+GxcqiWxhcHGIoryb/cDJnnled6QiPZBcJOKQiiJH1fEeufS+I5DFyfJ8V1Lcdd4+3bxf2E1nJY8EaWjYt87MqTQ2EX617sDyXOuatQU5mw6XeYgfeu/hYbqEIRC201pJVGTP43ydgPBDSCdJXuJhvitrtkIcEsp/5h/p2rFk69fMKWeB/aB4dQ+y0zxX5mr+dVtEeDpk3HX6ynzvUejMP9YBEHR4tDQqMoPfP0oiVsMXTh4pyz2dpQhL8l8PAf2cl730JHg+1iO38ebEmN4sD1fFROUT7z/lWhfxrzsiw3PhF96DkJXvz754aHgkJXGQv69KIg5fkWddTO8hXZBO/Dyj74lHUxKHsOM+k5b8ANmyEUR+5Y83xNAJvOubEJGo0wAEvlNNvF6pVnn4N2bA9+rAP9GTqZqzJnc5EeE66NFbWeTYSj5N1yLE4ohN3Ww10P0JnwxeHzXR34j/E7Ps5hmcr8VJQxO3FTvrDkO3uN/I12tDr/zGcRn6pwOMCvIq3GD3HPCAnODcHi2RSM7Vd2hy/OMUa5/nGD84C4hkoYr5rswZ/lhDXti/7EysbfbHGng9MFQbP1DIQu9m6j9voBzD+A3kbQBvG2JCJYEQHZeR+iLZvx76/rc59TmOaYnS0HCM/+c++JM+TBbN3h+RlnwfZK4jnoi3dcgHP3ksa/aWuvbvLHHtQywGJsR/SYy5R4gvon0F1rq6n5dldhhATkz/bPiRvCzvTHvGpExFWBwRDKMdnBDT+3t31tdgAM6V33SrJvZqFkBWItGfgCJuToztgee0IB2RBZQil7YQHsAxztun0PuiUfd4awCyJNe6uR7j9lSrHP7r0aES2ZZu9ipSPni5lkniIb8U5Kw7DaXer024pQVwmVLePo2E9VZm2gt8HonM4XIN5Aj4RGm0stcpyLO6IHuFJSI83qcP7d3J8YO3Fjt2ktEmZxvfFjEAsr7QthdJr8kVqUjjAwiAZSMlXgQgAV+VIVzeYqZ8R1Jcf0qmU22miYxuEdjmyTTeH6Xuo8+lJw8zhctjJbiugKzFUZGOOc4zDg/7NHmUEelcJzWMVUYJEsG00npGJ0SJt2ni+u+BoxMPkGMA/5nn07WjydajzSnPcky7IV59BckF/pfzr3+cbZxI1xEMP2JMm0/38X6Sh4SIGQCJriiyHySAgb9q+ACCScRCSlZE+LW/P3KVChP/2T4xUbnkR4s8lu/41+2R4W4CEPjZFtjS7ycBn0YiCKy2hqdo7iV/qypybB8Qry5DnwQ/rxYQ+JNzvJYql8UhMRykCQV8ciQSs9YvYxYI96M6cwUCvZZTLPMnZdSmwffIPw+WeQi4T/WPiy7m388Gn4fKPI2butk3+wEEQCcywh+Jb5JhritzWgOA/3G95lH6m+RH/Kt4AJKwtdh5Yl+p+whAwcbmCo0sVBlglOG1FQDJpvjCRK2yNQC5Nzl+OMXaJ9nGd/nXpSEibpYjYwp8j3zl0LMAecRpjC/WxN2jlS5Mdr6CnxPI1sFHUjimvZWpn0w5BpPVp9gcg7hNFPMmBq9npI6ieKKkTrnmvuT4QSyAbC9x7tlb6j6oD2vpE8hD15Hf0vPID5O6RUVaAOYhZBToO+YvibFX8wEEk6c7yUe/c2XOZPkalOfW4uecQy8IgBwHgHxkNb7NMU0O1iZnG96gZF5b7NiRKAtVsQBCwuQqI0ycQLuQAEJtjDllBDnBbEfGdP71q2Oj8skYtSXOvTCAkgUQGhdJbXhrPBKA0ExsGWaW7L1r46JLMVNs3I+EBeBJaguAIOg2AQBObitxVtX3yvNCrvm4LmkNQG6GI1AAIXBPIeH2FOJVBsf/LMf4zlP6pHtlISGSzgQQ0i1m9UvYexOthneJ/3ez0sZ0BEAoCMoLbVtI5r6xUcVBmWk7gCw6iJUJktZm4n1joe2XJJk0si0AQqCzodD2a2s/8DTDZv6UZB9l0D7RFn4Hxkf3oDF/LbSVi4O8+hIByIe+Cc5G+tzV3bXTFhmuCwogAm26zTzJ27vAOwQJi3+dBRDEwiGtTBYp1OdSAcjtqALALgSgJyjGhZ4NQx5EjL73WKrmDsSdRAhAyN9xH/ILNz6AkE9WQ9/kawfKmqsTjtYABBWJyOoi5zbi9UOr4c22uBABCMUafPVj9p49N5fBgg4AyDEAyMeMYnlL9VA4Tzkh2SMpmntYACFlIHGmXAwAoQSNGeIpLO+OZfKSxgeW9Dd9iWwshyYEICPTtQ+2FUCW51l/FDMJJBQJG7PwSjIgkmCPtgDIZsxk4QjH/qqJLagucuxAeYaM/0bIOQBEBELpajYMT33f4S5xIwAhnaCs+CN77xtn5kzi/2WT7tmOAAgmKqJ1BbYNpFvSyYUAECRDelfJ6vyctTQeeJ2GcdoKIOtbGx/gPZGS5rhM/Utt4ZeAkXy6CqUgNZU0mHYpAaQJ+nkoJbEfbDKLdLUqP3sZSrXytgIIrZZJF/Dze1oBkIOJUqn0cgEQinGUYOeRzO9lpY/lzrOxAIL8eGtbAIT4eC5deyfi+20auwr8G8LOVCc0QQDknuT4m5p8K954aaiCOw8A+cJmmsTes3o8nQkgbPJPeZaEnukwfyFiAITq45gFPwb0HuKnQQnqIVCI6YIBCD+5us4krSf1SQ/QNSgzAs65B3ycptKHEIA0wbk/zTZO5vM4MF49pCgq8oq2AgiWhiKq+1LiwbNlbQUQCj6tXBrRLza6BEmtgQIDy+ShvtkPCyAINkkk5Pmd+GDLCZA1FmO4KdERoQzisuHTiWtpYbK0zgIQ7AvRLH7T9fHq/tBdf8g/4H1L+usk844S529IMob2AAgTWC/jOtXaax7UJdyMcYpQGiqGDziRcGXnCyCkZ7dSYcDqOAPlgiNNAO83M/SjqM+VrZSwCOyHJMQEfOU6H2EyFQjoWzSxA6isQSVGWt2iX8mA+Ojia7Aa1smlaoEkGgHZtpFdqWQyKCGmF95JMha5lAqj6BICCCX/GxLUPVPkMjVWy9tpogNQ+JB4wkQt6QIByHGUsI6jZHM3G4coYSVfCgDBuNHbi51/UhUFk4o8Zg8yPlisIbHrWQBphPwTLOnv8WW7AbLlqyKKWQDxrVbupsk5cscvNDlf4rHMo/K0WiKR7hAAEEySxxP/WPW/xaG1FUDg5/TuJcRPgGJVQx7rXtTf29gguSgAQsFCQq7Mt65EYuUDSPVBBBwxSQ4UoGuKvY+nakZeaAChhv2PvuCFknxzAkIt/jr6+0fUzqnsIAQgtE+D5N2Sx6uLqN6+IUgJaxHHtL/pEgZitUWHCg4jWcedB4A0YO+gOUAw63iYAgN96+CwHiTk7iyAIJnQKqsBDlSfHibX8Xl4Qq8ZRv0BlgFCX9RS871TbMY5nQUgNAYFKl9/SMg0Pjn0aOrXUQDRyqRROJSxhO4RnfZ9Yv+NQGUj6rtXnQ+AkP+UqZUOujZUmzCEbEcEf+lXoIowBgMQlChJVoxNcrYkJA8PbwUugt3GN/l8389v45kDD3ugg4ewaGXj6CpsgB6l/nwZca2B9hEM2Fe4RAASWPn1jY0uAj+nqC/23h5GElMcvAAAAlA+THolmdk4hE/cfCkABMnddORM2e6ETi7TtDzwkPT42bHmoVhDrjTMZAHkeM/mPoxsxQE/ZwEEm+HNFZFcVYQZey/7yY/GZ6WPwWSJqy127mYB5Ae3ZS75yvCUxIfOB0CIL9ivJV9lbu/pQVd5Tx87qrwoAIKZ8mB/0mYApAbJkGYrE7EEfBU0mggKHg3jl3QGgMBRZDRLPYEVR54qIu2zHNMnZOgHeJvnLIDQu5YjqYC3V/w8TkLiA8gNpT7sJjo25Fdi9prqiFSkepSKDFrt7LvCfZCc+hVTygjqez4Aku0DENLdFJtpApyFNmqr38jQP0y88QEkJyIslU6LYbwGBEgqf6ybEmP6wAazsez201cbsDJAkqV3fN1ZAELgC6feNd4SsPEYlIRmU0DRSRyckLu2owBCDafrwnFSaRj2uKbiAMcsbP7N3gQ9EaiDh5O9YlTO8wQQu/86Vh8vkt53YuP/NXPq/UcBikIAQglpZ4lz3wSLgeRspvE+oiTDbsCitDAYSfgjH7+z/pufvZoSCcULAP82VkYkLes72DP6zpU1E/TVD+6s+bRPRrN+nPz5nvbILgWAIMb7+a/B3++t950Ug64eACAe6SiA1BQ5jgKc61AJGEe5gh+HAGbrpQAQZ2S4Acm1CZPCUzgUkMxOVNlY21ho34JYo3fMYAGkDvyC7+/4OeYjyDZMl3inEIDQZj1vYtGX8hn5DXLCo5QbWADBRv43FDd/1yc9ej4AQnyVYy82wBdRRsroGX2uGOmtOyW7KABCm6SkfNR9JwvugSgVus7fA+FvpqeOpID73pX12TYEO5Z8vzOb5+3eA0FCxJFMt5fKNrRyIYCk/5Nx4exvUL/2Agg1OsmzOj9nBS2bsZdznJLzVICK/74a96tQQqEAQhmlT2s8o5Q0jmyDz7EXew8EhxqeQ6KkDfZV/KPTAJAxPgB5RgBASn0AsqIt48OuEUjMNPuiicononYCCO2zIGHPogRAR25pr2Oh2zIv2B6ICJ7YngZ/ILD6F40P+2+OFIulrT3TG8eK9+KEFq1eBieor7zUAEINvv4WZPAffW8sL7SXX4g9EI1UGnq57IH4y9/18Ak6Sce10qCT9+gdb2em/SvIHojgJLY1AKH2sjHlaR9oN+0D0GJV9AcfQHDU+XUaG/ZiNsTbtweSfbH2QDLC5fEQ5jeavWG2dYPQKSzsJVguJoBQmedAcxLwNJc4/sNsngsByAsG3WNtAZBjSCCYgR5G0loC1F+Kzd3m0xKU6CHvQjpO2x4AYRKVHrO6vbS0ZAGEGs1oyfBfOzK+PGdylUkpAHZR4qHvO3TmKSzIvpQtEUIOEwEsHedF/TwA4P8wNK9AaLU2kmMa6v5lJBtKNsvbysONCTEDqGS2ocC2Pkwc0i4AoZYaJlPjmc00SQARgMwVAhDs92zAyTCuvQ0+osPpmtPgrS6HbN+GhlXXN5QgXjLqnrgcAITq87Rq938HCACy8QIAyCHsjcZcLgAiAs20nznC+6XdPOVcz2NfS4XN7b3E10CsooUAhE5EthdA6Oj+Vw7zZ77vFFFZ7Xc+gGBi0ZvG3lPqOoCjz8nnAyAz7eZP2Xu5zCmsDh/jpaNhAgbSYBm3EAmKyjpr4EBSoRWIE6WetgLIcwbtsI4CiAiEBDSTku9hfFmsBJvnrQHIiDTt387jFNZi/uY5kl4xymZVWPVQUv8U5+DbDSA8h+iFY8ENtLphAQRn5d3H8T44EzmaIN+RErEIm7ETaQWAsslK8Cm52CuQh1MSb6k/s0SuVIrFgZnl0/qkhylYAcLz2GdwVv45JBs6kDH9PE65vATd0z7XIpQBzxdAWBvb8cwRJEYGQJhTWB1odF6fbLerxLUfx4dVrfXHhq2MfIVsiZLH7ZcDgHC+DXQkze3wRQZAOnQKS9YWAKGcU6SKzGgLgGwpcmyhBNyeY7w49FDgqzYEBQAV5MbJyI+by/iYSNF3ktp7CosFEHa1/Ss21ck3WQCh0iYqFytpIk9+C58J79AprNy8Cwcgh3IzvQvcWfNwemoAEb4hfROWaa/CeXaTIfeVevYhGG0CXySsIWFRtx6O527wE2r1g/EFnCIWQOikwhTMrvl98YXFQdhMvhqJWNxWAKF2G+qGXmbzPBiA0Lif55gmCYx7HcaVC53CIpBgvmtSBJBopDouAkvXTgBhN5sfCWyiM21sRuoIko+cezruE4hh815jDpen3KqJuxY6WuD7RvNh8O3k0DrzFBYSyGaU1K6H7q6H7gZCr8/8joRAPLLfqMX+kZG+LUsAj/Lny5A/BcEQj9r6XftxrJn4hv0G8p+h+3D4QXwb3Qg/wvOvYqVWTwDyaIrm7vbsgbANXza9EXzTHsh8FkAO+k5hoS5NPAQIvA2G3U3/l1Qkcly/FhMBPs+D6Hshu1F+wJFLWtWPF7UEr1yKDf57saq/lWxJgLMXKznU4hMvFwCh1g8nxcBbI3y5okN7IGdOYZ14UJtwB6tXjzLCyQIITUwRH0+yeQU2zeMDCM3WUcbec7smbgj7XmtEWIoggDANue4F8gfKZVNyTO/jpFI3irWM8LBU6GUArcSQuKm0fRBf3svh0IROYaHE9S6bYxC3/WQhImkwAGEb9nXNkOkQYusw+0VCyoeIq0Nkx/UFtjXY970JK1w9VkeaPjGqbli9PoWSqZw9hYV4WEL88OmpPOegpv374joMICenfvLkAZfZewx1/yYEPNFpkBcGrEOJZU2udXmxUsEGIgVq6Npc628n0acehOcC5O2N/Qlnxkp+/1cMye+f7on9BN44RDTO8Svcp7RSiR9RRT97LDu9+OJdz6hINxekqUJEsj3Fjr3DkuPOuWwcbdROCDYuyZwcKtEFAlwVcZUXfVfnWlZxTJOANhVkbye+boiNCtSpYa2IzYU5Rxt6eLxORZjBfz1CxIXUdLPtOlnm9lrD5dqgpQubacYcu+lL9noogZ9B++zhUlcD8UR63lnkOLm32NFQ7+O/ptBW01etLOE6scH2vU5h7KOlrP5w+g6fs2ymWcoQURj73Ch90nDynwb0+b3EWb+zyH6M/k/PTM02TID/tEDoOxJi+nn7FPDHCIxD40/LNkxEFIoDAC3i1LVFtkb4jjczTJbE8dpKj2Ul2aksKiJoCeS9jNQ3Yeef+ddsCnneUbyPZG1k+QBvT6UkjAjUkLHp2hwnAvySnHj3slSppEW5c6Er82uKDX7/077PA91dR+/WxAzorFNYK9xZzb7bKyoyl3/jyxzjlOZTWInBx/6f1MRHthfZtytEnDiID0+nd9ySoBZMijHikMQdRfbTFG8NAnr9IFP/OZ/X5e6sWrJ5nUBeWerOCpw2hN1th0pd3qNXuATt9bw+6T5/3/s0sU8SgEyxGj5k+ZOCxhi1o46UuhtPB2LNfvK3Ykdjg8+mVYW2it7RkYWCe8QZKdObKMew/FI5qrvLqxaHBPxgnFn3cvOerF4T9IvNt2KSBn84yPoPtf4xquLKQltVky+W/ihxNm0Hr43IP7uLHEfklDp87S/x0fcRX+TTbFydzMv01i39sU+HAeTQt7P7zkcSm5+f00zf59voc9pEe8bYu1OT+sWFh4k5lBelUmkLCpfJxB85MsctKrBPR/8WtKTQPn2MxfAMv//D6dq7lnVz0P1p/L4/FNimz/ZY39EowqXUTyaViiZg7BVFzundYtV6uiZEklAp90Jm2m3WKGUy/zpLww26u4XGXYBxv8nNnpysUET7++bHROcsR98PHRn/kMtkrLzcZEfmi/8FX/00cXb/daVcLvvcZRn/U6F9ak6UKt5/PTpMLvrCbXl9UYFtSqZKqRaUAZSujFD/22q8R8bcE4eGchCSuyoxzjXVZXm7vLt74/5eBfv29Mzfu6rYuWSs1fiEWRWp9tmm08ijjspeXGCHX8A/fLQAPjLLY530pDHlFsgZEgJe+c+E+j6H6pP7ryxyzgXPe4j3NcWuZSPM+ntVcjknYcbpp4m3+ewUIIwzHTocj/dcr4D+YfNAf3WYXPGlx/LhwnzbJ9BDwIZyEPznefKfgtjoVP91lr/Y8DDZm9mm+yPl8hD/dUuUMh1jTlvA+AoR+cVfdZq+/r4ZKmU0dPLRAobfr+FTkHFooiI8TMToBXZ+CH4S6I9Yw6dt6ns28z+L49QWCNhZdhR9YDP/+2fopChWnca/94rF8CD8afp1SfHuYM+HQfevW41DdRGKCKH7iPVh9A7YsKfQ/XhFuOorj/WjH6BbVq9k86eMqfdSP3/8v28zv7ZYIK+Q7l6zGh/294XddbhO9hJ87y06TXd/30HJCdesKnZNfykzHWMJx1pfTZxnmsvyn03d3eV/9io8E2tFzh/HWIyPGZURUcFi7WlT6rClQXLbTI/1A+TQgN4QM4NXlbim36tP7h1M3xRPL2el32mPVmnYe5xYwoGXaOj8ceSin3b3yN9LvFaUen59w2p6AXES8GfIUybEF9FS6KKhfIO1wwBS19DAbamubkGbq6q59ZWV3LqKSq4Cf9fU1AiRv6/g8+xzlUxftn81r2+F71oVMx5L27Zu5T3HEjuuMPGfx//9fc8pb1U1c52RobXrbJ+dtVu5rQL36LkNlVXNtLu2NqRx9y7V8Z07Imq31nDrYJ9NVT4+O4lYnfBpY1XVOf2jCkQ+RHKBZ0X97p1KshddqxR4BjoVHIdkXyf8DM+G7PXW/Yf43gF+wJOIJyueDe6jxENrfcuhl7XQC9+HWL9m30t63Ag5qzvNjsFjqiKIT7O2Idtt9+uqHe9ok15ZPbF96VPQBq3noCrmmpCf/+qLtT2+WDtGsYbr8D96tr05hunLyizMC+IGeUFY3/Q88US8EY/EK/KDiGKyOkhMsbRt166uH5Tqoi7qoi7qoq5fJOyiLuqiLuqiy4guCya6qIu6qIu66P8f/S8Sa5bVZWFWJAAAAABJRU5ErkJggg=='),
(16,	'favicon',	'/uploads/logos/16558157527539-logo.png'),
(17,	'from_email',	'info@example.com'),
(18,	'smtp_host',	'smtp.gmail.com'),
(19,	'smtp_encryption',	'ssl'),
(20,	'smtp_username',	'globiznotifications@gmail.com'),
(21,	'smtp_email',	'globiznotifications@gmail.com'),
(22,	'smtp_password',	'eyJpdiI6Ik5HSmpiY0piejdnaXZpS0VpbGFpalE9PSIsInZhbHVlIjoiVkhjOXNNcno2azNiM1M2alJGMG96dz09IiwibWFjIjoiMGI2NjA3MWQyMmZmYTFiMDk0ODZiOTA5YTg4YTA3OTQzNzMxOTI4ZWI1NjEwNjc2NmE2MGRkMzk2MDI2MDVmZiIsInRhZyI6IiJ9'),
(23,	'smtp_port',	'465'),
(24,	'email_method',	'smtp'),
(25,	'logo',	''),
(26,	'admin_notification_email',	'info@example.com'),
(27,	'date_format',	'm-d-Y'),
(28,	'time_format',	'H:i'),
(29,	'direct_login_after_registration',	'1'),
(30,	'session_expires_in_minutes',	'1440'),
(31,	'client_recaptcha',	'0'),
(32,	'client_second_auth_factor',	''),
(33,	'client_multi_device_logins',	'1'),
(48,	'powered_by',	'Globiz Technology Inc.'),
(49,	'powered_by_link',	'https://globiztechnology.com/'),
(50,	'company_email',	'info@uniform-inc.com,info@capnhats.com'),
(51,	'company_phonenumber',	'+91-0161-4501269'),
(52,	'facebook',	'https://www.facebook.com/'),
(53,	'twitter',	'https://twitter.com/'),
(54,	'instagram',	'https://www.instagram.com/'),
(55,	'youtube',	'https://www.youtube.com/'),
(71,	'company_mobile',	'+91-98720-00269,+91-97795-40228'),
(135,	'_token',	'Wtz4PM1Syy0QRrTzrP7oWRW79LC1a7uV0DvdT5yb'),
(136,	'bread_crumbs_setting ',	'[{\"main_title\":\"About Us\",\"title\":\"About us\",\"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\":\"\"}]');

DROP TABLE IF EXISTS `slider`;
CREATE TABLE `slider` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `url` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `button_title` varchar(50) DEFAULT NULL,
  `button_url` tinytext DEFAULT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `image` text DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_by` int(11) DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  `created` datetime NOT NULL,
  `modified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `created_by` (`created_by`),
  CONSTRAINT `slider_ibfk_1` FOREIGN KEY (`created_by`) REFERENCES `admins` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `states`;
CREATE TABLE `states` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `state_code` varchar(50) NOT NULL,
  `country_id` int(11) NOT NULL,
  `status` tinyint(4) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `testimonials`;
CREATE TABLE `testimonials` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `designation` varchar(255) DEFAULT NULL,
  `location` varchar(255) NOT NULL,
  `image` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `rating` int(11) NOT NULL,
  `created_by` int(11) DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `deleted_at` datetime DEFAULT NULL,
  `created` datetime NOT NULL,
  `modified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `created_by` (`created_by`),
  CONSTRAINT `testimonials_ibfk_2` FOREIGN KEY (`created_by`) REFERENCES `admins` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `page_name` varchar(255) NOT NULL,
  `first_name` varchar(255) NOT NULL,
  `last_name` varchar(255) DEFAULT NULL,
  `phonenumber` varchar(255) DEFAULT NULL,
  `session_id` varchar(255) DEFAULT NULL,
  `dob` date DEFAULT NULL,
  `address` text DEFAULT NULL,
  `image` text DEFAULT NULL,
  `bio` longtext DEFAULT NULL,
  `last_login` datetime DEFAULT NULL,
  `token` varchar(255) DEFAULT NULL,
  `gender` enum('male','female') DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `status` tinyint(1) DEFAULT NULL,
  `verified_at` datetime DEFAULT NULL,
  `facebook_id` varchar(200) DEFAULT NULL,
  `google_id` varchar(200) DEFAULT NULL,
  `google_email` varchar(200) DEFAULT NULL,
  `otp` varchar(10) DEFAULT NULL,
  `zipcode` varchar(10) DEFAULT NULL,
  `sounds` enum('is','are') DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `modified` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `created_by` (`created_by`),
  CONSTRAINT `users_ibfk_1` FOREIGN KEY (`created_by`) REFERENCES `admins` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `users_tokens`;
CREATE TABLE `users_tokens` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `token` varchar(200) NOT NULL,
  `device_id` varchar(255) DEFAULT NULL,
  `device_type` enum('android','ios','web') DEFAULT NULL,
  `device_name` varchar(255) DEFAULT NULL,
  `fcm_token` text DEFAULT NULL,
  `expire_on` datetime NOT NULL,
  `created` datetime NOT NULL,
  `modified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  CONSTRAINT `users_tokens_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `web_settings`;
CREATE TABLE `web_settings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `slider_title` varchar(255) DEFAULT NULL,
  `slider` text DEFAULT NULL,
  `about_us_title` varchar(255) DEFAULT NULL,
  `about_us_sub_title` varchar(255) DEFAULT NULL,
  `about_us_description` text DEFAULT NULL,
  `about_us_feature` text DEFAULT NULL,
  `about_us_button_text` varchar(255) DEFAULT NULL,
  `about_us_link` varchar(255) DEFAULT NULL,
  `is_about_us_button` tinyint(4) DEFAULT NULL,
  `our_services_title` varchar(255) DEFAULT NULL,
  `our_services` text DEFAULT NULL,
  `our_process_title` varchar(255) DEFAULT NULL,
  `our_process` text DEFAULT NULL,
  `articles_title` varchar(255) DEFAULT NULL,
  `articles` text DEFAULT NULL,
  `articles_button_text` varchar(255) DEFAULT NULL,
  `articles_link` varchar(255) DEFAULT NULL,
  `is_articles_button` tinyint(4) DEFAULT NULL,
  `our_products_title` varchar(255) DEFAULT NULL,
  `our_products` text DEFAULT NULL,
  `our_products_button_text` varchar(255) DEFAULT NULL,
  `our_products_link` varchar(255) DEFAULT NULL,
  `is_our_products_button` tinyint(4) DEFAULT NULL,
  `technology_partners_title` varchar(255) DEFAULT NULL,
  `technology_partners_images` longtext DEFAULT NULL,
  `news_title` varchar(255) DEFAULT NULL,
  `news` text DEFAULT NULL,
  `testimonials_title` varchar(255) DEFAULT NULL,
  `testimonials` text DEFAULT NULL,
  `our_accolades_title` varchar(255) DEFAULT NULL,
  `our_accolades_images` longtext DEFAULT NULL,
  `quick_links_title` varchar(255) DEFAULT NULL,
  `footer_menu` longtext DEFAULT NULL,
  `contact_info_title` varchar(255) DEFAULT NULL,
  `address` text DEFAULT NULL,
  `phone_number_1` varchar(255) DEFAULT NULL,
  `phone_number_2` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `follow_us_title` varchar(255) DEFAULT NULL,
  `facebook` varchar(255) DEFAULT NULL,
  `twitter` varchar(255) DEFAULT NULL,
  `linkedin` varchar(255) DEFAULT NULL,
  `youtube` varchar(255) DEFAULT NULL,
  `blogger` varchar(255) DEFAULT NULL,
  `google` varchar(255) DEFAULT NULL,
  `telegram` varchar(255) DEFAULT NULL,
  `skype` varchar(255) DEFAULT NULL,
  `wifi` varchar(255) DEFAULT NULL,
  `whatsapp` varchar(255) DEFAULT NULL,
  `powered_by` varchar(255) DEFAULT NULL,
  `powered_by_link` varchar(255) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `modified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `created_by` (`created_by`),
  CONSTRAINT `web_settings_ibfk_1` FOREIGN KEY (`created_by`) REFERENCES `admins` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


-- 2022-06-25 12:55:00
