-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `aoxio_db_fresh_23`
--

-- --------------------------------------------------------

--
-- Table structure for table `appointments`
--

CREATE TABLE `appointments` (
  `id` int(11) NOT NULL,
  `number` varchar(255) DEFAULT NULL,
  `user_id` int(11) NOT NULL,
  `business_id` varchar(255) DEFAULT '0',
  `customer_id` int(11) NOT NULL,
  `staff_id` int(11) NOT NULL,
  `service_id` int(11) NOT NULL,
  `service_extra` varchar(255) DEFAULT NULL,
  `location_id` int(11) DEFAULT '0',
  `sub_location_id` varchar(155) DEFAULT '0',
  `date` date NOT NULL,
  `time` varchar(255) DEFAULT NULL,
  `note` text,
  `group_booking` varchar(155) DEFAULT '0',
  `total_person` varchar(155) DEFAULT '0',
  `status` int(11) DEFAULT NULL,
  `pay_info` int(11) DEFAULT '2',
  `sync_calendar` varchar(155) DEFAULT '0',
  `sync_calendar_staff` varchar(155) DEFAULT '0',
  `sync_calendar_user` varchar(155) DEFAULT '0',
  `is_recurring` int(11) NOT NULL DEFAULT '0',
  `recurring_count` int(11) NOT NULL DEFAULT '0',
  `next_recur_date` varchar(255) DEFAULT NULL,
  `is_completed` int(11) NOT NULL DEFAULT '0',
  `created_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `blog_category`
--

CREATE TABLE `blog_category` (
  `id` int(11) NOT NULL,
  `lang_id` int(11) DEFAULT '1',
  `user_id` int(11) NOT NULL,
  `business_id` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `status` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `blog_posts`
--

CREATE TABLE `blog_posts` (
  `id` int(11) NOT NULL,
  `lang_id` int(11) DEFAULT '1',
  `business_id` varchar(255) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `details` text,
  `user_id` int(11) DEFAULT NULL,
  `category_id` int(11) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `thumb` varchar(255) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `hit` int(11) DEFAULT NULL,
  `is_featured` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `booking_val`
--

CREATE TABLE `booking_val` (
  `id` int(11) NOT NULL,
  `business_id` varchar(155) COLLATE utf8_unicode_ci DEFAULT '0',
  `staff_id` varchar(155) COLLATE utf8_unicode_ci DEFAULT '0',
  `service_id` varchar(155) COLLATE utf8_unicode_ci DEFAULT '0',
  `location_id` varchar(155) COLLATE utf8_unicode_ci DEFAULT '0',
  `sub_location_id` varchar(155) COLLATE utf8_unicode_ci DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `brands`
--

CREATE TABLE `brands` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `business_id` varchar(255) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `logo` varchar(255) NOT NULL,
  `link` varchar(255) NOT NULL,
  `status` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `business`
--

CREATE TABLE `business` (
  `id` int(11) NOT NULL,
  `uid` varchar(255) NOT NULL,
  `user_id` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `details` text,
  `keywords` text,
  `description` text,
  `type` int(11) NOT NULL DEFAULT '1',
  `title` varchar(255) DEFAULT NULL,
  `country` int(11) DEFAULT NULL,
  `address` mediumtext,
  `email` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `category` varchar(255) DEFAULT NULL,
  `business_type` int(11) DEFAULT NULL,
  `logo` varchar(255) DEFAULT NULL,
  `size` varchar(55) DEFAULT '120px',
  `image` text,
  `thumb` text,
  `status` int(11) NOT NULL DEFAULT '0',
  `enable_gallery` varchar(255) DEFAULT '1',
  `enable_portfolio` varchar(255) DEFAULT '1',
  `enable_brand` varchar(255) DEFAULT '1',
  `enable_slider` varchar(255) DEFAULT '1',
  `enable_blog` varchar(255) DEFAULT '1',
  `enable_testimonial` varchar(255) DEFAULT '1',
  `enable_staff` varchar(255) NOT NULL DEFAULT '1',
  `is_primary` int(11) DEFAULT NULL,
  `template_style` int(11) NOT NULL DEFAULT '1',
  `curr_locate` varchar(155) DEFAULT '0',
  `num_format` varchar(155) DEFAULT '0',
  `color` varchar(255) NOT NULL DEFAULT '#546af1',
  `font` varchar(255) DEFAULT NULL,
  `facebook` varchar(255) DEFAULT NULL,
  `twitter` varchar(255) DEFAULT NULL,
  `instagram` varchar(255) DEFAULT NULL,
  `whatsapp` varchar(255) DEFAULT NULL,
  `qr_code` varchar(255) DEFAULT NULL,
  `time_zone` int(11) DEFAULT '1',
  `default_timezone` varchar(11) DEFAULT '1',
  `date_format` varchar(255) DEFAULT 'd M Y',
  `time_format` varchar(255) DEFAULT 'hh',
  `time_interval` varchar(255) DEFAULT '30',
  `cancelation_time` varchar(255) NOT NULL DEFAULT '0',
  `interval_type` varchar(255) DEFAULT 'minute',
  `interval_settings` varchar(155) DEFAULT '2',
  `enable_category` varchar(155) DEFAULT '0',
  `enable_rating` varchar(155) DEFAULT '0',
  `enable_location` varchar(155) DEFAULT '0',
  `enable_group` varchar(155) DEFAULT '0',
  `enable_guest` varchar(155) DEFAULT '0',
  `total_person` varchar(155) DEFAULT '5',
  `enable_payment` varchar(155) DEFAULT '1',
  `enable_onsite` varchar(155) DEFAULT '1',
  `enable_event` int(2) DEFAULT '0',
  `enable_whatsapp_msg` int(11) DEFAULT '0',
  `whatsapp_type` varchar(20) DEFAULT 'ultramsg',
  `wazfy_instance_id` varchar(50) DEFAULT NULL,
  `wazfy_token` varchar(50) DEFAULT NULL,
  `ultramsg_instance_id` varchar(155) DEFAULT NULL,
  `ultramsg_token` varchar(155) DEFAULT NULL,
  `holidays` longtext,
  `about_title` varchar(255) DEFAULT NULL,
  `about_details` text,
  `company_established` varchar(155) DEFAULT NULL,
  `about_image` varchar(255) DEFAULT NULL,
  `about_vedio_url` varchar(255) DEFAULT NULL,
  `terms` longtext,
  `privacy` longtext,
  `tax_type` varchar(255) DEFAULT NULL,
  `tax_amount` varchar(11) DEFAULT NULL,
  `created_at` varchar(255) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `id` int(11) NOT NULL,
  `business_id` varchar(255) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `details` text,
  `status` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `categories`
--

INSERT INTO `categories` (`id`, `business_id`, `name`, `slug`, `details`, `status`) VALUES
(1, '2343', 'Sport & Gym', 'sport-gym', '', 1),
(2, '4355', 'Beauty and wellness', 'beauty-and-wellness', '', 1),
(3, '5645', 'Medical', 'medical', '', 1),
(4, '8990', 'Educations', 'educations', '', 1),
(5, '2345', 'Events and entertainment', 'events-and-entertainment', '', 1),
(6, NULL, 'Law & Consultancy', 'law-consultancy', '', 1),
(7, NULL, 'Personal meetings and services', 'personal-meetings-and-services', '', 1),
(8, NULL, 'Other', 'other', '', 1);

-- --------------------------------------------------------

--
-- Table structure for table `comments`
--

CREATE TABLE `comments` (
  `id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `post_id` int(11) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `message` text,
  `created_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `contacts`
--

CREATE TABLE `contacts` (
  `id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `business_id` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `website` varchar(255) DEFAULT NULL,
  `message` text,
  `created_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `country`
--

CREATE TABLE `country` (
  `id` int(11) NOT NULL,
  `name` varchar(20) NOT NULL,
  `code` varchar(2) NOT NULL,
  `dial_code` varchar(5) NOT NULL,
  `currency_name` varchar(20) NOT NULL,
  `currency_symbol` varchar(20) NOT NULL,
  `currency_code` varchar(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `country`
--

INSERT INTO `country` (`id`, `name`, `code`, `dial_code`, `currency_name`, `currency_symbol`, `currency_code`) VALUES
(1, 'Andorra', 'AD', '+376', 'Euro', '€', 'EUR'),
(2, 'United Arab Emirates', 'AE', '+971', 'United Arab Emirates', 'د.إ', 'AED'),
(3, 'Afghanistan', 'AF', '+93', 'Afghan afghani', '؋', 'AFN'),
(4, 'Antigua and Barbuda', 'AG', '+1268', 'East Caribbean dolla', '$', 'XCD'),
(5, 'Anguilla', 'AI', '+1264', 'East Caribbean dolla', '$', 'XCD'),
(6, 'Albania', 'AL', '+355', 'Albanian lek', 'L', 'ALL'),
(7, 'Armenia', 'AM', '+374', 'Armenian dram', '', 'AMD'),
(8, 'Angola', 'AO', '+244', 'Angolan kwanza', 'Kz', 'AOA'),
(9, 'Argentina', 'AR', '+54', 'Argentine peso', '$', 'ARS'),
(10, 'Austria', 'AT', '+43', 'Euro', '€', 'EUR'),
(11, 'Australia', 'AU', '+61', 'Australian dollar', '$', 'AUD'),
(12, 'Aruba', 'AW', '+297', 'Aruban florin', 'ƒ', 'AWG'),
(13, 'Azerbaijan', 'AZ', '+994', 'Azerbaijani manat', '', 'AZN'),
(14, 'Barbados', 'BB', '+1246', 'Barbadian dollar', '$', 'BBD'),
(15, 'Bangladesh', 'BD', '+880', 'Bangladeshi taka', '৳', 'BDT'),
(16, 'Belgium', 'BE', '+32', 'Euro', '€', 'EUR'),
(17, 'Burkina Faso', 'BF', '+226', 'West African CFA fra', 'Fr', 'XOF'),
(18, 'Bulgaria', 'BG', '+359', 'Bulgarian lev', 'лв', 'BGN'),
(19, 'Bahrain', 'BH', '+973', 'Bahraini dinar', '.د.ب', 'BHD'),
(20, 'Burundi', 'BI', '+257', 'Burundian franc', 'Fr', 'BIF'),
(21, 'Benin', 'BJ', '+229', 'West African CFA fra', 'Fr', 'XOF'),
(22, 'Bermuda', 'BM', '+1441', 'Bermudian dollar', '$', 'BMD'),
(23, 'Brazil', 'BR', '+55', 'Brazilian real', 'R$', 'BRL'),
(24, 'Bhutan', 'BT', '+975', 'Bhutanese ngultrum', 'Nu.', 'BTN'),
(25, 'Botswana', 'BW', '+267', 'Botswana pula', 'P', 'BWP'),
(26, 'Belarus', 'BY', '+375', 'Belarusian ruble', 'Br', 'BYR'),
(27, 'Belize', 'BZ', '+501', 'Belize dollar', '$', 'BZD'),
(28, 'Canada', 'CA', '+1', 'Canadian dollar', '$', 'CAD'),
(29, 'Switzerland', 'CH', '+41', 'Swiss franc', 'Fr', 'CHF'),
(30, 'Cote d\'Ivoire', 'CI', '+225', 'West African CFA fra', 'Fr', 'XOF'),
(31, 'Cook Islands', 'CK', '+682', 'New Zealand dollar', '$', 'NZD'),
(32, 'Chile', 'CL', '+56', 'Chilean peso', '$', 'CLP'),
(33, 'Cameroon', 'CM', '+237', 'Central African CFA ', 'Fr', 'XAF'),
(34, 'China', 'CN', '+86', 'Chinese yuan', '¥ or 元', 'CNY'),
(35, 'Colombia', 'CO', '+57', 'Colombian peso', '$', 'COP'),
(36, 'Costa Rica', 'CR', '+506', 'Costa Rican colón', '₡', 'CRC'),
(37, 'Cuba', 'CU', '+53', 'Cuban convertible pe', '$', 'CUC'),
(38, 'Cape Verde', 'CV', '+238', 'Cape Verdean escudo', 'Esc or $', 'CVE'),
(39, 'Cyprus', 'CY', '+357', 'Euro', '€', 'EUR'),
(40, 'Czech Republic', 'CZ', '+420', 'Czech koruna', 'Kč', 'CZK'),
(41, 'Germany', 'DE', '+49', 'Euro', '€', 'EUR'),
(42, 'Djibouti', 'DJ', '+253', 'Djiboutian franc', 'Fr', 'DJF'),
(43, 'Denmark', 'DK', '+45', 'Danish krone', 'kr', 'DKK'),
(44, 'Dominica', 'DM', '+1767', 'East Caribbean dolla', '$', 'XCD'),
(45, 'Dominican Republic', 'DO', '+1849', 'Dominican peso', '$', 'DOP'),
(46, 'Algeria', 'DZ', '+213', 'Algerian dinar', 'د.ج', 'DZD'),
(47, 'Ecuador', 'EC', '+593', 'United States dollar', '$', 'USD'),
(48, 'Estonia', 'EE', '+372', 'Euro', '€', 'EUR'),
(49, 'Egypt', 'EG', '+20', 'Egyptian pound', '£ or ج.م', 'EGP'),
(50, 'Eritrea', 'ER', '+291', 'Eritrean nakfa', 'Nfk', 'ERN'),
(51, 'Spain', 'ES', '+34', 'Euro', '€', 'EUR'),
(52, 'Ethiopia', 'ET', '+251', 'Ethiopian birr', 'Br', 'ETB'),
(53, 'Finland', 'FI', '+358', 'Euro', '€', 'EUR'),
(54, 'Fiji', 'FJ', '+679', 'Fijian dollar', '$', 'FJD'),
(55, 'Faroe Islands', 'FO', '+298', 'Danish krone', 'kr', 'DKK'),
(56, 'France', 'FR', '+33', 'Euro', '€', 'EUR'),
(57, 'Gabon', 'GA', '+241', 'Central African CFA ', 'Fr', 'XAF'),
(58, 'United Kingdom', 'GB', '+44', 'British pound', '£', 'GBP'),
(59, 'Grenada', 'GD', '+1473', 'East Caribbean dolla', '$', 'XCD'),
(60, 'Georgia', 'GE', '+995', 'Georgian lari', 'ლ', 'GEL'),
(61, 'Guernsey', 'GG', '+44', 'British pound', '£', 'GBP'),
(62, 'Ghana', 'GH', '+233', 'Ghana cedi', '₵', 'GHS'),
(63, 'Gibraltar', 'GI', '+350', 'Gibraltar pound', '£', 'GIP'),
(64, 'Guinea', 'GN', '+224', 'Guinean franc', 'Fr', 'GNF'),
(65, 'Equatorial Guinea', 'GQ', '+240', 'Central African CFA ', 'Fr', 'XAF'),
(66, 'Greece', 'GR', '+30', 'Euro', '€', 'EUR'),
(67, 'Guatemala', 'GT', '+502', 'Guatemalan quetzal', 'Q', 'GTQ'),
(68, 'Guinea-Bissau', 'GW', '+245', 'West African CFA fra', 'Fr', 'XOF'),
(69, 'Guyana', 'GY', '+595', 'Guyanese dollar', '$', 'GYD'),
(70, 'Hong Kong', 'HK', '+852', 'Hong Kong dollar', '$', 'HKD'),
(71, 'Honduras', 'HN', '+504', 'Honduran lempira', 'L', 'HNL'),
(72, 'Croatia', 'HR', '+385', 'Croatian kuna', 'kn', 'HRK'),
(73, 'Haiti', 'HT', '+509', 'Haitian gourde', 'G', 'HTG'),
(74, 'Hungary', 'HU', '+36', 'Hungarian forint', 'Ft', 'HUF'),
(75, 'Indonesia', 'ID', '+62', 'Indonesian rupiah', 'Rp', 'IDR'),
(76, 'Ireland', 'IE', '+353', 'Euro', '€', 'EUR'),
(77, 'Israel', 'IL', '+972', 'Israeli new shekel', '₪', 'ILS'),
(78, 'Isle of Man', 'IM', '+44', 'British pound', '£', 'GBP'),
(79, 'India', 'IN', '+91', 'Indian rupee', '₹', 'INR'),
(80, 'Iraq', 'IQ', '+964', 'Iraqi dinar', 'ع.د', 'IQD'),
(81, 'Iceland', 'IS', '+354', 'Icelandic króna', 'kr', 'ISK'),
(82, 'Italy', 'IT', '+39', 'Euro', '€', 'EUR'),
(83, 'Jersey', 'JE', '+44', 'British pound', '£', 'GBP'),
(84, 'Jamaica', 'JM', '+1876', 'Jamaican dollar', '$', 'JMD'),
(85, 'Jordan', 'JO', '+962', 'Jordanian dinar', 'د.ا', 'JOD'),
(86, 'Japan', 'JP', '+81', 'Japanese yen', '¥', 'JPY'),
(87, 'Kenya', 'KE', '+254', 'Kenyan shilling', 'Sh', 'KES'),
(88, 'Kyrgyzstan', 'KG', '+996', 'Kyrgyzstani som', 'лв', 'KGS'),
(89, 'Cambodia', 'KH', '+855', 'Cambodian riel', '៛', 'KHR'),
(90, 'Kiribati', 'KI', '+686', 'Australian dollar', '$', 'AUD'),
(91, 'Comoros', 'KM', '+269', 'Comorian franc', 'Fr', 'KMF'),
(92, 'Kuwait', 'KW', '+965', 'Kuwaiti dinar', 'د.ك', 'KWD'),
(93, 'Cayman Islands', 'KY', '+ 345', 'Cayman Islands dolla', '$', 'KYD'),
(94, 'Kazakhstan', 'KZ', '+7 7', 'Kazakhstani tenge', '', 'KZT'),
(95, 'Laos', 'LA', '+856', 'Lao kip', '₭', 'LAK'),
(96, 'Lebanon', 'LB', '+961', 'Lebanese pound', 'ل.ل', 'LBP'),
(97, 'Saint Lucia', 'LC', '+1758', 'East Caribbean dolla', '$', 'XCD'),
(98, 'Liechtenstein', 'LI', '+423', 'Swiss franc', 'Fr', 'CHF'),
(99, 'Sri Lanka', 'LK', '+94', 'Sri Lankan rupee', 'Rs or රු', 'LKR'),
(100, 'Liberia', 'LR', '+231', 'Liberian dollar', '$', 'LRD'),
(101, 'Lesotho', 'LS', '+266', 'Lesotho loti', 'L', 'LSL'),
(102, 'Lithuania', 'LT', '+370', 'Euro', '€', 'EUR'),
(103, 'Luxembourg', 'LU', '+352', 'Euro', '€', 'EUR'),
(104, 'Latvia', 'LV', '+371', 'Euro', '€', 'EUR'),
(105, 'Morocco', 'MA', '+212', 'Moroccan dirham', 'د.م.', 'MAD'),
(106, 'Monaco', 'MC', '+377', 'Euro', '€', 'EUR'),
(107, 'Moldova', 'MD', '+373', 'Moldovan leu', 'L', 'MDL'),
(108, 'Montenegro', 'ME', '+382', 'Euro', '€', 'EUR'),
(109, 'Madagascar', 'MG', '+261', 'Malagasy ariary', 'Ar', 'MGA'),
(110, 'Marshall Islands', 'MH', '+692', 'United States dollar', '$', 'USD'),
(111, 'Mali', 'ML', '+223', 'West African CFA fra', 'Fr', 'XOF'),
(112, 'Myanmar', 'MM', '+95', 'Burmese kyat', 'Ks', 'MMK'),
(113, 'Mongolia', 'MN', '+976', 'Mongolian tögrög', '₮', 'MNT'),
(114, 'Mauritania', 'MR', '+222', 'Mauritanian ouguiya', 'UM', 'MRO'),
(115, 'Montserrat', 'MS', '+1664', 'East Caribbean dolla', '$', 'XCD'),
(116, 'Malta', 'MT', '+356', 'Euro', '€', 'EUR'),
(117, 'Mauritius', 'MU', '+230', 'Mauritian rupee', '₨', 'MUR'),
(118, 'Maldives', 'MV', '+960', 'Maldivian rufiyaa', '.ރ', 'MVR'),
(119, 'Malawi', 'MW', '+265', 'Malawian kwacha', 'MK', 'MWK'),
(120, 'Mexico', 'MX', '+52', 'Mexican peso', '$', 'MXN'),
(121, 'Malaysia', 'MY', '+60', 'Malaysian ringgit', 'RM', 'MYR'),
(122, 'Mozambique', 'MZ', '+258', 'Mozambican metical', 'MT', 'MZN'),
(123, 'Namibia', 'NA', '+264', 'Namibian dollar', '$', 'NAD'),
(124, 'New Caledonia', 'NC', '+687', 'CFP franc', 'Fr', 'XPF'),
(125, 'Niger', 'NE', '+227', 'West African CFA fra', 'Fr', 'XOF'),
(126, 'Nigeria', 'NG', '+234', 'Nigerian naira', '₦', 'NGN'),
(127, 'Nicaragua', 'NI', '+505', 'Nicaraguan córdoba', 'C$', 'NIO'),
(128, 'Netherlands', 'NL', '+31', 'Euro', '€', 'EUR'),
(129, 'Norway', 'NO', '+47', 'Norwegian krone', 'kr', 'NOK'),
(130, 'Nepal', 'NP', '+977', 'Nepalese rupee', '₨', 'NPR'),
(131, 'Nauru', 'NR', '+674', 'Australian dollar', '$', 'AUD'),
(132, 'Niue', 'NU', '+683', 'New Zealand dollar', '$', 'NZD'),
(133, 'New Zealand', 'NZ', '+64', 'New Zealand dollar', '$', 'NZD'),
(134, 'Oman', 'OM', '+968', 'Omani rial', 'ر.ع.', 'OMR'),
(135, 'Panama', 'PA', '+507', 'Panamanian balboa', 'B/.', 'PAB'),
(136, 'Peru', 'PE', '+51', 'Peruvian nuevo sol', 'S/.', 'PEN'),
(137, 'French Polynesia', 'PF', '+689', 'CFP franc', 'Fr', 'XPF'),
(138, 'Papua New Guinea', 'PG', '+675', 'Papua New Guinean ki', 'K', 'PGK'),
(139, 'Philippines', 'PH', '+63', 'Philippine peso', '₱', 'PHP'),
(140, 'Pakistan', 'PK', '+92', 'Pakistani rupee', '₨', 'PKR'),
(141, 'Poland', 'PL', '+48', 'Polish z?oty', 'zł', 'PLN'),
(142, 'Portugal', 'PT', '+351', 'Euro', '€', 'EUR'),
(143, 'Palau', 'PW', '+680', 'Palauan dollar', '$', ''),
(144, 'Paraguay', 'PY', '+595', 'Paraguayan guaraní', '₲', 'PYG'),
(145, 'Qatar', 'QA', '+974', 'Qatari riyal', 'ر.ق', 'QAR'),
(146, 'Romania', 'RO', '+40', 'Romanian leu', 'lei', 'RON'),
(147, 'Serbia', 'RS', '+381', 'Serbian dinar', 'дин. or din.', 'RSD'),
(148, 'Russia', 'RU', '+7', 'Russian ruble', '', 'RUB'),
(149, 'Rwanda', 'RW', '+250', 'Rwandan franc', 'Fr', 'RWF'),
(150, 'Saudi Arabia', 'SA', '+966', 'Saudi riyal', 'ر.س', 'SAR'),
(151, 'Solomon Islands', 'SB', '+677', 'Solomon Islands doll', '$', 'SBD'),
(152, 'Seychelles', 'SC', '+248', 'Seychellois rupee', '₨', 'SCR'),
(153, 'Sudan', 'SD', '+249', 'Sudanese pound', 'ج.س.', 'SDG'),
(154, 'Sweden', 'SE', '+46', 'Swedish krona', 'kr', 'SEK'),
(155, 'Singapore', 'SG', '+65', 'Singapore dollar', '$', 'SGD'),
(156, 'Slovenia', 'SI', '+386', 'Euro', '€', 'EUR'),
(157, 'Slovakia', 'SK', '+421', 'Euro', '€', 'EUR'),
(158, 'Sierra Leone', 'SL', '+232', 'Sierra Leonean leone', 'Le', 'SLL'),
(159, 'San Marino', 'SM', '+378', 'Euro', '€', 'EUR'),
(160, 'Senegal', 'SN', '+221', 'West African CFA fra', 'Fr', 'XOF'),
(161, 'Somalia', 'SO', '+252', 'Somali shilling', 'Sh', 'SOS'),
(162, 'Suriname', 'SR', '+597', 'Surinamese dollar', '$', 'SRD'),
(163, 'El Salvador', 'SV', '+503', 'United States dollar', '$', 'USD'),
(164, 'Swaziland', 'SZ', '+268', 'Swazi lilangeni', 'L', 'SZL'),
(165, 'Chad', 'TD', '+235', 'Central African CFA ', 'Fr', 'XAF'),
(166, 'Togo', 'TG', '+228', 'West African CFA fra', 'Fr', 'XOF'),
(167, 'Thailand', 'TH', '+66', 'Thai baht', '฿', 'THB'),
(168, 'Tajikistan', 'TJ', '+992', 'Tajikistani somoni', 'ЅМ', 'TJS'),
(169, 'Turkmenistan', 'TM', '+993', 'Turkmenistan manat', 'm', 'TMT'),
(170, 'Tunisia', 'TN', '+216', 'Tunisian dinar', 'د.ت', 'TND'),
(171, 'Tonga', 'TO', '+676', 'Tongan pa?anga', 'T$', 'TOP'),
(172, 'Turkey', 'TR', '+90', 'Turkish lira', '', 'TRY'),
(173, 'Trinidad and Tobago', 'TT', '+1868', 'Trinidad and Tobago ', '$', 'TTD'),
(174, 'Tuvalu', 'TV', '+688', 'Australian dollar', '$', 'AUD'),
(175, 'Taiwan', 'TW', '+886', 'New Taiwan dollar', '$', 'TWD'),
(176, 'Ukraine', 'UA', '+380', 'Ukrainian hryvnia', '₴', 'UAH'),
(177, 'Uganda', 'UG', '+256', 'Ugandan shilling', 'Sh', 'UGX'),
(178, 'United States', 'US', '+1', 'United States dollar', '$', 'USD'),
(179, 'Uruguay', 'UY', '+598', 'Uruguayan peso', '$', 'UYU'),
(180, 'Uzbekistan', 'UZ', '+998', 'Uzbekistani som', '', 'UZS'),
(181, 'Vietnam', 'VN', '+84', 'Vietnamese ??ng', '₫', 'VND'),
(182, 'Vanuatu', 'VU', '+678', 'Vanuatu vatu', 'Vt', 'VUV'),
(183, 'Wallis and Futuna', 'WF', '+681', 'CFP franc', 'Fr', 'XPF'),
(184, 'Samoa', 'WS', '+685', 'Samoan t?l?', 'T', 'WST'),
(185, 'Yemen', 'YE', '+967', 'Yemeni rial', '﷼', 'YER'),
(186, 'South Africa', 'ZA', '+27', 'South African rand', 'R', 'ZAR'),
(187, 'Zambia', 'ZM', '+260', 'Zambian kwacha', 'ZK', 'ZMW'),
(188, 'Zimbabwe', 'ZW', '+263', 'Botswana pula', 'P', 'BWP');

-- --------------------------------------------------------

--
-- Table structure for table `coupons`
--

CREATE TABLE `coupons` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `business_id` varchar(25) DEFAULT '0',
  `service_id` int(11) NOT NULL,
  `code` varchar(255) NOT NULL,
  `discount` varchar(255) NOT NULL,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `once_per_customer` int(11) DEFAULT '0',
  `usages_limit` varchar(255) DEFAULT NULL,
  `used` int(11) DEFAULT '0',
  `status` int(11) DEFAULT '1',
  `created_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `coupons_apply`
--

CREATE TABLE `coupons_apply` (
  `id` int(11) NOT NULL,
  `business_id` varchar(25) DEFAULT '0',
  `code` varchar(255) NOT NULL,
  `discount` int(11) NOT NULL,
  `customer_id` int(11) NOT NULL,
  `service_id` int(11) NOT NULL,
  `appointment_id` int(11) NOT NULL,
  `created_at` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `customers`
--

CREATE TABLE `customers` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `business_id` varchar(25) DEFAULT '0',
  `name` varchar(255) NOT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `email` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `role` varchar(255) DEFAULT 'customer',
  `gender` varchar(255) DEFAULT NULL,
  `time_zone` varchar(155) DEFAULT NULL,
  `last_appointment` date DEFAULT NULL,
  `status` int(11) DEFAULT '1',
  `image` text,
  `thumb` text,
  `created_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `custom_form`
--

CREATE TABLE `custom_form` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `business_id` varchar(255) DEFAULT '0',
  `service_id` varchar(255) NOT NULL,
  `input_type` varchar(255) NOT NULL,
  `input_title` varchar(255) NOT NULL,
  `is_required` varchar(255) NOT NULL,
  `input_name` varchar(255) NOT NULL,
  `status` int(11) DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--
-- Table structure for table `custom_form_answer`
--

CREATE TABLE `custom_form_answer` (
  `id` int(11) NOT NULL,
  `user_id` varchar(255) NOT NULL,
  `business_id` varchar(255) DEFAULT '1',
  `booking_id` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `answer` varchar(255) DEFAULT NULL,
  `created_at` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--
-- Table structure for table `dialing_codes`
--

CREATE TABLE `dialing_codes` (
  `id` int(11) NOT NULL,
  `name` varchar(64) NOT NULL DEFAULT '',
  `iso_code` varchar(2) NOT NULL,
  `isd_code` varchar(7) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `dialing_codes`
--

INSERT INTO `dialing_codes` (`id`, `name`, `iso_code`, `isd_code`) VALUES
(1, 'Afghanistan', 'AF', '93'),
(2, 'Albania', 'AL', '355'),
(3, 'Algeria', 'DZ', '213'),
(4, 'American Samoa', 'AS', '1-684'),
(5, 'Andorra', 'AD', '376'),
(6, 'Angola', 'AO', '244'),
(7, 'Anguilla', 'AI', '1-264'),
(8, 'Antarctica', 'AQ', '672'),
(9, 'Antigua and Barbuda', 'AG', '1-268'),
(10, 'Argentina', 'AR', '54'),
(11, 'Armenia', 'AM', '374'),
(12, 'Aruba', 'AW', '297'),
(13, 'Australia', 'AU', '61'),
(14, 'Austria', 'AT', '43'),
(15, 'Azerbaijan', 'AZ', '994'),
(16, 'Bahamas', 'BS', '1-242'),
(17, 'Bahrain', 'BH', '973'),
(18, 'Bangladesh', 'BD', '880'),
(19, 'Barbados', 'BB', '1-246'),
(20, 'Belarus', 'BY', '375'),
(21, 'Belgium', 'BE', '32'),
(22, 'Belize', 'BZ', '501'),
(23, 'Benin', 'BJ', '229'),
(24, 'Bermuda', 'BM', '1-441'),
(25, 'Bhutan', 'BT', '975'),
(26, 'Bolivia', 'BO', '591'),
(27, 'Bosnia and Herzegowina', 'BA', '387'),
(28, 'Botswana', 'BW', '267'),
(29, 'Bouvet Island', 'BV', '47'),
(30, 'Brazil', 'BR', '55'),
(31, 'British Indian Ocean Territory', 'IO', '246'),
(32, 'Brunei Darussalam', 'BN', '673'),
(33, 'Bulgaria', 'BG', '359'),
(34, 'Burkina Faso', 'BF', '226'),
(35, 'Burundi', 'BI', '257'),
(36, 'Cambodia', 'KH', '855'),
(37, 'Cameroon', 'CM', '237'),
(38, 'Canada', 'CA', '1'),
(39, 'Cape Verde', 'CV', '238'),
(40, 'Cayman Islands', 'KY', '1-345'),
(41, 'Central African Republic', 'CF', '236'),
(42, 'Chad', 'TD', '235'),
(43, 'Chile', 'CL', '56'),
(44, 'China', 'CN', '86'),
(45, 'Christmas Island', 'CX', '61'),
(46, 'Cocos (Keeling) Islands', 'CC', '61'),
(47, 'Colombia', 'CO', '57'),
(48, 'Comoros', 'KM', '269'),
(49, 'Congo Democratic Republic of', 'CG', '242'),
(50, 'Cook Islands', 'CK', '682'),
(51, 'Costa Rica', 'CR', '506'),
(52, 'Cote D\'Ivoire', 'CI', '225'),
(53, 'Croatia', 'HR', '385'),
(54, 'Cuba', 'CU', '53'),
(55, 'Cyprus', 'CY', '357'),
(56, 'Czech Republic', 'CZ', '420'),
(57, 'Denmark', 'DK', '45'),
(58, 'Djibouti', 'DJ', '253'),
(59, 'Dominica', 'DM', '1-767'),
(60, 'Dominican Republic', 'DO', '1-809'),
(61, 'Timor-Leste', 'TL', '670'),
(62, 'Ecuador', 'EC', '593'),
(63, 'Egypt', 'EG', '20'),
(64, 'El Salvador', 'SV', '503'),
(65, 'Equatorial Guinea', 'GQ', '240'),
(66, 'Eritrea', 'ER', '291'),
(67, 'Estonia', 'EE', '372'),
(68, 'Ethiopia', 'ET', '251'),
(69, 'Falkland Islands (Malvinas)', 'FK', '500'),
(70, 'Faroe Islands', 'FO', '298'),
(71, 'Fiji', 'FJ', '679'),
(72, 'Finland', 'FI', '358'),
(73, 'France', 'FR', '33'),
(75, 'French Guiana', 'GF', '594'),
(76, 'French Polynesia', 'PF', '689'),
(77, 'French Southern Territories', 'TF', NULL),
(78, 'Gabon', 'GA', '241'),
(79, 'Gambia', 'GM', '220'),
(80, 'Georgia', 'GE', '995'),
(81, 'Germany', 'DE', '49'),
(82, 'Ghana', 'GH', '233'),
(83, 'Gibraltar', 'GI', '350'),
(84, 'Greece', 'GR', '30'),
(85, 'Greenland', 'GL', '299'),
(86, 'Grenada', 'GD', '1-473'),
(87, 'Guadeloupe', 'GP', '590'),
(88, 'Guam', 'GU', '1-671'),
(89, 'Guatemala', 'GT', '502'),
(90, 'Guinea', 'GN', '224'),
(91, 'Guinea-bissau', 'GW', '245'),
(92, 'Guyana', 'GY', '592'),
(93, 'Haiti', 'HT', '509'),
(94, 'Heard Island and McDonald Islands', 'HM', '011'),
(95, 'Honduras', 'HN', '504'),
(96, 'Hong Kong', 'HK', '852'),
(97, 'Hungary', 'HU', '36'),
(98, 'Iceland', 'IS', '354'),
(99, 'India', 'IN', '91'),
(100, 'Indonesia', 'ID', '62'),
(101, 'Iran (Islamic Republic of)', 'IR', '98'),
(102, 'Iraq', 'IQ', '964'),
(103, 'Ireland', 'IE', '353'),
(104, 'Israel', 'IL', '972'),
(105, 'Italy', 'IT', '39'),
(106, 'Jamaica', 'JM', '1-876'),
(107, 'Japan', 'JP', '81'),
(108, 'Jordan', 'JO', '962'),
(109, 'Kazakhstan', 'KZ', '7'),
(110, 'Kenya', 'KE', '254'),
(111, 'Kiribati', 'KI', '686'),
(112, 'Korea, Democratic People\'s Republic of', 'KP', '850'),
(113, 'South Korea', 'KR', '82'),
(114, 'Kuwait', 'KW', '965'),
(115, 'Kyrgyzstan', 'KG', '996'),
(116, 'Lao People\'s Democratic Republic', 'LA', '856'),
(117, 'Latvia', 'LV', '371'),
(118, 'Lebanon', 'LB', '961'),
(119, 'Lesotho', 'LS', '266'),
(120, 'Liberia', 'LR', '231'),
(121, 'Libya', 'LY', '218'),
(122, 'Liechtenstein', 'LI', '423'),
(123, 'Lithuania', 'LT', '370'),
(124, 'Luxembourg', 'LU', '352'),
(125, 'Macao', 'MO', '853'),
(126, 'Macedonia, The Former Yugoslav Republic of', 'MK', '389'),
(127, 'Madagascar', 'MG', '261'),
(128, 'Malawi', 'MW', '265'),
(129, 'Malaysia', 'MY', '60'),
(130, 'Maldives', 'MV', '960'),
(131, 'Mali', 'ML', '223'),
(132, 'Malta', 'MT', '356'),
(133, 'Marshall Islands', 'MH', '692'),
(134, 'Martinique', 'MQ', '596'),
(135, 'Mauritania', 'MR', '222'),
(136, 'Mauritius', 'MU', '230'),
(137, 'Mayotte', 'YT', '262'),
(138, 'Mexico', 'MX', '52'),
(139, 'Micronesia, Federated States of', 'FM', '691'),
(140, 'Moldova', 'MD', '373'),
(141, 'Monaco', 'MC', '377'),
(142, 'Mongolia', 'MN', '976'),
(143, 'Montserrat', 'MS', '1-664'),
(144, 'Morocco', 'MA', '212'),
(145, 'Mozambique', 'MZ', '258'),
(146, 'Myanmar', 'MM', '95'),
(147, 'Namibia', 'NA', '264'),
(148, 'Nauru', 'NR', '674'),
(149, 'Nepal', 'NP', '977'),
(150, 'Netherlands', 'NL', '31'),
(151, 'Netherlands Antilles', 'AN', '599'),
(152, 'New Caledonia', 'NC', '687	'),
(153, 'New Zealand', 'NZ', '64'),
(154, 'Nicaragua', 'NI', '505'),
(155, 'Niger', 'NE', '227'),
(156, 'Nigeria', 'NG', '234'),
(157, 'Niue', 'NU', '683'),
(158, 'Norfolk Island', 'NF', '672'),
(159, 'Northern Mariana Islands', 'MP', '1-670'),
(160, 'Norway', 'NO', '47'),
(161, 'Oman', 'OM', '968'),
(162, 'Pakistan', 'PK', '92'),
(163, 'Palau', 'PW', '680'),
(164, 'Panama', 'PA', '507'),
(165, 'Papua New Guinea', 'PG', '675'),
(166, 'Paraguay', 'PY', '595'),
(167, 'Peru', 'PE', '51'),
(168, 'Philippines', 'PH', '63'),
(169, 'Pitcairn', 'PN', '64'),
(170, 'Poland', 'PL', '48'),
(171, 'Portugal', 'PT', '351'),
(172, 'Puerto Rico', 'PR', '1-787'),
(173, 'Qatar', 'QA', '974'),
(174, 'Reunion', 'RE', '262'),
(175, 'Romania', 'RO', '40'),
(176, 'Russian Federation', 'RU', '7'),
(177, 'Rwanda', 'RW', '250'),
(178, 'Saint Kitts and Nevis', 'KN', '1-869'),
(179, 'Saint Lucia', 'LC', '1-758'),
(180, 'Saint Vincent and the Grenadines', 'VC', '1-784'),
(181, 'Samoa', 'WS', '685'),
(182, 'San Marino', 'SM', '378'),
(183, 'Sao Tome and Principe', 'ST', '239'),
(184, 'Saudi Arabia', 'SA', '966'),
(185, 'Senegal', 'SN', '221'),
(186, 'Seychelles', 'SC', '248'),
(187, 'Sierra Leone', 'SL', '232'),
(188, 'Singapore', 'SG', '65'),
(189, 'Slovakia (Slovak Republic)', 'SK', '421'),
(190, 'Slovenia', 'SI', '386'),
(191, 'Solomon Islands', 'SB', '677'),
(192, 'Somalia', 'SO', '252'),
(193, 'South Africa', 'ZA', '27'),
(194, 'South Georgia and the South Sandwich Islands', 'GS', '500'),
(195, 'Spain', 'ES', '34'),
(196, 'Sri Lanka', 'LK', '94'),
(197, 'Saint Helena, Ascension and Tristan da Cunha', 'SH', '290'),
(198, 'St. Pierre and Miquelon', 'PM', '508'),
(199, 'Sudan', 'SD', '249'),
(200, 'Suriname', 'SR', '597'),
(201, 'Svalbard and Jan Mayen Islands', 'SJ', '47'),
(202, 'Swaziland', 'SZ', '268'),
(203, 'Sweden', 'SE', '46'),
(204, 'Switzerland', 'CH', '41'),
(205, 'Syrian Arab Republic', 'SY', '963'),
(206, 'Taiwan', 'TW', '886'),
(207, 'Tajikistan', 'TJ', '992'),
(208, 'Tanzania, United Republic of', 'TZ', '255'),
(209, 'Thailand', 'TH', '66'),
(210, 'Togo', 'TG', '228'),
(211, 'Tokelau', 'TK', '690'),
(212, 'Tonga', 'TO', '676'),
(213, 'Trinidad and Tobago', 'TT', '1-868'),
(214, 'Tunisia', 'TN', '216'),
(215, 'Turkey', 'TR', '90'),
(216, 'Turkmenistan', 'TM', '993'),
(217, 'Turks and Caicos Islands', 'TC', '1-649'),
(218, 'Tuvalu', 'TV', '688'),
(219, 'Uganda', 'UG', '256'),
(220, 'Ukraine', 'UA', '380'),
(221, 'United Arab Emirates', 'AE', '971'),
(222, 'United Kingdom', 'GB', '44'),
(223, 'United States', 'US', '1'),
(224, 'United States Minor Outlying Islands', 'UM', '246'),
(225, 'Uruguay', 'UY', '598'),
(226, 'Uzbekistan', 'UZ', '998'),
(227, 'Vanuatu', 'VU', '678'),
(228, 'Vatican City State (Holy See)', 'VA', '379'),
(229, 'Venezuela', 'VE', '58'),
(230, 'Vietnam', 'VN', '84'),
(231, 'Virgin Islands (British)', 'VG', '1-284'),
(232, 'Virgin Islands (U.S.)', 'VI', '1-340'),
(233, 'Wallis and Futuna Islands', 'WF', '681'),
(234, 'Western Sahara', 'EH', '212'),
(235, 'Yemen', 'YE', '967'),
(236, 'Serbia', 'RS', '381'),
(238, 'Zambia', 'ZM', '260'),
(239, 'Zimbabwe', 'ZW', '263'),
(240, 'Aaland Islands', 'AX', '358'),
(241, 'Palestine', 'PS', '970'),
(242, 'Montenegro', 'ME', '382'),
(243, 'Guernsey', 'GG', '44-1481'),
(244, 'Isle of Man', 'IM', '44-1624'),
(245, 'Jersey', 'JE', '44-1534'),
(247, 'CuraÃ§ao', 'CW', '599'),
(248, 'Ivory Coast', 'CI', '225'),
(249, 'Kosovo', 'XK', '383');

-- --------------------------------------------------------

--
-- Table structure for table `domains`
--

CREATE TABLE `domains` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `current_domain` varchar(255) DEFAULT NULL,
  `custom_domain` varchar(255) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `date` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `domain_settings`
--

CREATE TABLE `domain_settings` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `short_details` text NOT NULL,
  `details` text NOT NULL,
  `ip` varchar(255) NOT NULL,
  `type1` varchar(255) NOT NULL,
  `host1` varchar(255) NOT NULL,
  `value1` varchar(255) NOT NULL,
  `ttl1` varchar(255) NOT NULL,
  `type2` varchar(255) NOT NULL,
  `host2` varchar(255) NOT NULL,
  `value2` varchar(255) NOT NULL,
  `ttl2` varchar(255) NOT NULL,
  `image` varchar(255) DEFAULT NULL,
  `thumb` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `domain_settings`
--

INSERT INTO `domain_settings` (`id`, `user_id`, `title`, `short_details`, `details`, `ip`, `type1`, `host1`, `value1`, `ttl1`, `type2`, `host2`, `value2`, `ttl2`, `image`, `thumb`) VALUES
(1, 1, 'Custom Domain Integration Guideline', 'Custom Domain Integration Guideline short details', '<div>Integrating a custom domain with DNS settings typically involves the following steps:</div><div><br></div><ol><li><b>Purchase a domain name:</b> You\'ll need to purchase a domain name from a domain registrar such as GoDaddy, Namecheap, or Google Domains.</li><li><b>Obtain your DNS records: </b>Once you have a domain provider, they will provide you with <b>DNS records</b> that you\'ll need to configure for your domain. These records will typically include an <b>A record & CNAME record</b>.</li><li><b>Configure DNS settings:</b> Log in to your domain registrar\'s account and navigate to the DNS management section.You need to add 2 new DNS record, choose the record type (<b>A & CNAME</b>) & follow the settings below <b>(<span xss=\"removed\">DNS Settings One </span><span xss=\"removed\">& </span><span xss=\"removed\">DNS Settings Two</span>)</b>, and enter the corresponding value.</li><li><b>Wait for propagation:</b> Once you\'ve made the changes to your DNS settings, it can take up to 48 hours for the changes to propagate throughout the internet. During this time, your website or application may be temporarily unavailable.</li></ol><div>That\'s it! Once your DNS records have propagated, your custom domain should be fully integrated with our application.</div>', '200.201.200.122', 'CNAME Record', 'www', 'localhost', 'Automatic', 'A Record', '@', '200.201.200.122', 'Automatic', 'uploads/medium/ffacb0959f18f3f8043243c937559a6c_medium-1200x1200.jpg', 'uploads/thumbnail/ffacb0959f18f3f8043243c937559a6c_thumb-150x150.jpg');

-- --------------------------------------------------------

--
-- Table structure for table `events`
--

CREATE TABLE `events` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `business_id` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `category` varchar(255) NOT NULL,
  `venue` int(11) NOT NULL,
  `details` text,
  `tags` varchar(255) DEFAULT NULL,
  `date` varchar(255) NOT NULL,
  `time` varchar(255) NOT NULL,
  `audience_type` varchar(255) DEFAULT NULL,
  `youtube_vedio_url` varchar(255) DEFAULT NULL,
  `external_link` varchar(255) DEFAULT NULL,
  `contact_number` varchar(255) DEFAULT NULL,
  `artist` varchar(255) DEFAULT NULL,
  `total_ticket` int(11) NOT NULL,
  `sales_start` varchar(255) NOT NULL,
  `sales_end` varchar(255) NOT NULL,
  `total_sales` int(11) NOT NULL,
  `is_organizer` varchar(255) DEFAULT '0',
  `organizer_name` varchar(255) DEFAULT NULL,
  `organizer_email` varchar(255) DEFAULT NULL,
  `organizer_phone` varchar(255) DEFAULT NULL,
  `organizer_website` varchar(255) DEFAULT NULL,
  `meta_tags` varchar(255) DEFAULT NULL,
  `meta_description` varchar(255) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `thumb` varchar(255) DEFAULT NULL,
  `created_at` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--
-- Table structure for table `event_booking`
--

CREATE TABLE `event_booking` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `business_id` varchar(255) NOT NULL,
  `booking_number` varchar(255) NOT NULL,
  `event_id` int(11) NOT NULL,
  `customer_id` int(11) NOT NULL,
  `venue_id` int(11) NOT NULL,
  `total_slot` varchar(255) NOT NULL,
  `total_price` varchar(255) NOT NULL,
  `ticket_id` varchar(255) NOT NULL,
  `date` varchar(255) NOT NULL,
  `time` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL,
  `payment_status` varchar(255) NOT NULL DEFAULT '0',
  `created_at` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--
-- Table structure for table `event_category`
--

CREATE TABLE `event_category` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `business_id` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `details` text,
  `status` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--
-- Table structure for table `event_ticket`
--

CREATE TABLE `event_ticket` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `event_id` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `details` text,
  `price` varchar(255) NOT NULL,
  `limit` varchar(255) NOT NULL,
  `enable_sales` int(11) DEFAULT '0',
  `sales_start` varchar(255) DEFAULT NULL,
  `sales_end` varchar(255) DEFAULT NULL,
  `tickets_per_attendee` int(11) DEFAULT NULL,
  `status` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--
-- Table structure for table `event_venue`
--

CREATE TABLE `event_venue` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `business_id` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `details` text,
  `vedio_url` varchar(255) DEFAULT NULL,
  `address` varchar(255) NOT NULL,
  `phone` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `website` varchar(255) DEFAULT NULL,
  `is_seatable` varchar(255) DEFAULT NULL,
  `total_seat` varchar(255) NOT NULL,
  `total_attendee` varchar(255) NOT NULL,
  `image` varchar(255) DEFAULT NULL,
  `thumb` varchar(255) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--
-- Table structure for table `faqs`
--

CREATE TABLE `faqs` (
  `id` int(11) NOT NULL,
  `lang_id` int(11) DEFAULT '1',
  `title` varchar(255) DEFAULT NULL,
  `details` mediumtext
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `faqs`
--

INSERT INTO `faqs` (`id`, `lang_id`, `title`, `details`) VALUES
(1, 1, 'How does the free trial work?', 'Our 14 day trial is 100% free and does not require any credit card information to start. If at the end of your trial you would like to upgrade, great. If not, your plan will automatically be downgraded to the free plan.'),
(2, 1, 'Do I need to choose a plan now?', 'No. You get the full featured, unlimited version of our service completely free for 14 days. Once you\'re ready to upgrade, you may choose a plan which suits your needs.'),
(3, 1, 'What is an online booking system?', 'What is an online booking system? In short, an online booking system is an online interface which enables customers to book the services that you offer in the form an appointment.\r\nWith an online booking system, businesses and professionals alike are in control of the services and available slots that are bookable by clients. Setting buffer time and configuring recurring appointments is also possible with many systems.\r\nAdvanced booking systems such as the Aoxio online booking system will also allow for booking pages to be customised and branded.'),
(4, 1, 'What is an online appointment?', 'An online appointment typically refers to exactly that, a booking for a service made via an online booking system. An online appointment could be for a service, such as a dental appointment, for example, a meeting, or any number of reasons. While the booking for the appointment is made online, the actual appointment may take place over the phone, or in person at a later time and date as agreed at the point of booking.'),
(5, 1, 'How do I set up an online booking?', 'If you want to set up and offer an online booking service for your clients, then you can do that with the help of a free online scheduling tool. You’ll benefit from an online booking page which you can customize with your own branding. Furthermore, with a good online booking system, you will be able to seamlessly integrate and offer an online booking facility via your own website.');

-- --------------------------------------------------------

--
-- Table structure for table `features`
--

CREATE TABLE `features` (
  `id` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `slug` varchar(255) NOT NULL,
  `is_limit` int(11) NOT NULL,
  `basic` int(11) DEFAULT NULL,
  `standared` int(11) DEFAULT NULL,
  `premium` int(11) DEFAULT NULL,
  `plus` varchar(155) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `features`
--

INSERT INTO `features` (`id`, `name`, `slug`, `is_limit`, `basic`, `standared`, `premium`, `plus`) VALUES
(1, 'Customers', 'customers', 1, 1, 200, -1, NULL),
(2, 'Staffs', 'staffs', 1, 10, 20, -1, NULL),
(3, 'Services', 'services', 1, 10, 20, 200, NULL),
(4, 'Appointments', 'appointments', 1, 100, 20, -1, NULL),
(5, 'Gallery', 'gallery', 0, NULL, NULL, NULL, NULL),
(6, 'Get Online Payments', 'get-online-payments', 0, NULL, NULL, NULL, NULL),
(7, 'Virtual Meeting(Zoom, Google Meet)', 'zoom-meeting', 0, NULL, NULL, NULL, NULL),
(8, 'Google Calendar Sync', 'google-calendar-sync', 0, NULL, NULL, NULL, NULL),
(9, 'Custom Domain', 'custom-domain', 0, NULL, NULL, NULL, NULL),
(10, 'Events', 'events', 1, 5, 10, 50, '5000');

-- --------------------------------------------------------

--
-- Table structure for table `feature_assaign`
--

CREATE TABLE `feature_assaign` (
  `id` int(11) NOT NULL,
  `package_id` int(11) NOT NULL,
  `feature_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `feature_assaign`
--

INSERT INTO `feature_assaign` (`id`, `package_id`, `feature_id`) VALUES
(212, 2, 8),
(213, 2, 7),
(214, 2, 6),
(215, 2, 5),
(216, 2, 4),
(217, 2, 3),
(218, 2, 2),
(219, 2, 1),
(233, 3, 8),
(234, 3, 7),
(235, 3, 6),
(236, 3, 5),
(237, 3, 4),
(238, 3, 3),
(239, 3, 2),
(240, 3, 1),
(241, 1, 8),
(242, 1, 6),
(243, 1, 5),
(244, 1, 4),
(245, 1, 3),
(246, 1, 2),
(247, 1, 1);

-- --------------------------------------------------------

--
-- Table structure for table `fonts`
--

CREATE TABLE `fonts` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `business_id` varchar(255) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `fonts`
--

INSERT INTO `fonts` (`id`, `user_id`, `business_id`, `name`, `slug`) VALUES
(2, 0, '0', 'Lato', 'lato'),
(3, 0, '0', 'Smith', 'smith'),
(4, 0, '0', 'Bree Serif', 'bree-serif'),
(5, 0, '0', 'Cabin', 'cabin'),
(6, 0, '0', 'Cookie', 'cookie'),
(7, 0, '0', 'Montserrat', 'montserrat'),
(9, 0, '0', 'Raleway', 'raleway'),
(10, 0, '0', 'Roboto', 'roboto'),
(11, 0, '0', 'Nunito', 'nunito'),
(12, 0, '0', 'Molengo', 'molengo'),
(13, 0, '0', 'Sarabun', 'sarabun'),
(14, 0, '0', 'Open Sans', 'open-sans'),
(15, 0, '0', 'Source Sans Pro', 'source-sans-pro'),
(16, 0, '0', 'PT Sans', 'pt-sans'),
(17, 0, '0', 'Noto Sans', 'noto-sans'),
(18, 0, '0', 'Roboto Mono', 'roboto-mono'),
(19, 0, '0', 'Muli', 'muli'),
(20, 0, '0', 'Arimo', 'arimo'),
(21, 0, '0', 'Fira Sans', 'fira-sans'),
(22, 0, '0', 'Noto Serif', 'noto-serif'),
(23, 0, '0', 'Work Sans', 'work-sans'),
(24, 0, '0', 'Quicksand', 'quicksand'),
(25, 0, '0', 'Dosis', 'dosis'),
(26, 0, '0', 'Rubik', 'rubik'),
(27, 0, '0', 'Oxygen', 'oxygen'),
(28, 0, '0', 'Hind', 'hind'),
(29, 0, '0', 'Josefin Sans', 'josefin-sans'),
(36, 0, '0', 'Merriweather Sans', 'merriweather-sans'),
(37, 0, '0', 'Kanit', 'kanit'),
(39, 0, '0', 'Comfortaa', 'comfortaa'),
(52, 0, '0', 'Bebas Neue', 'bebas-neue'),
(53, 0, '0', 'Short', 'short'),
(54, 0, '0', 'Iransans', 'iransans'),
(55, 0, '0', 'Noto Sans KR', 'noto-sans-kr'),
(56, 0, '0', 'Arial', 'arial'),
(57, 0, '0', 'Alata', 'alata'),
(58, 0, '0', 'Sriracha', 'sriracha'),
(59, 0, '0', 'Tajawal', 'tajawal'),
(60, 2, '26341103027', 'Ubuntu', 'ubuntu');

-- --------------------------------------------------------

--
-- Table structure for table `gallery`
--

CREATE TABLE `gallery` (
  `id` int(11) NOT NULL,
  `business_id` varchar(25) DEFAULT '0',
  `user_id` int(11) NOT NULL,
  `title` text,
  `image` varchar(255) DEFAULT NULL,
  `thumb` varchar(255) DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `language`
--

CREATE TABLE `language` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `short_name` varchar(255) NOT NULL,
  `code` varchar(255) DEFAULT NULL,
  `text_direction` varchar(255) NOT NULL,
  `status` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `language`
--

INSERT INTO `language` (`id`, `name`, `slug`, `short_name`, `code`, `text_direction`, `status`) VALUES
(1, 'English', 'english', 'en', '', 'ltr', 1);

-- --------------------------------------------------------

--
-- Table structure for table `lang_values`
--

CREATE TABLE `lang_values` (
  `id` int(11) NOT NULL,
  `type` varchar(255) DEFAULT NULL,
  `label` varchar(255) NOT NULL,
  `keyword` varchar(255) NOT NULL,
  `english` text
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


INSERT INTO `lang_values` (`id`, `type`, `label`, `keyword`, `english`) VALUES
(809, 'user', 'Sub locations', 'sub-locations', 'Sub locations'),
(810, 'user', 'Currency location', 'currency-location', 'Currency location'),
(811, 'user', 'Number format', 'number-format', 'Number format'),
(812, 'user', 'Currency Position', 'currency-position', 'Currency Position'),
(813, 'user', 'Paid', 'paid', 'Paid'),
(814, 'user', 'Minute', 'minute', 'Minute'),
(815, 'user', 'Hour', 'hour', 'Hour'),
(816, 'user', 'Send SMS Reminder', 'send-sms-reminder', 'Send SMS Reminder'),
(817, 'user', 'Review', 'review', 'Review'),
(818, 'user', 'Reviews', 'reviews', 'Reviews'),
(819, 'user', 'Customer Feedback', 'customer-feedback', 'Customer Feedback'),
(820, 'user', 'Average Rating', 'average-rating', 'Average Rating'),
(821, 'user', 'Ratings Summary', 'ratings-summary', 'Ratings Summary'),
(822, 'user', 'Ratings', 'ratings', 'Ratings'),
(823, 'user', 'Service Ratings', 'service-ratings', 'Service Ratings'),
(824, 'user', 'Enable Ratings', 'enable-ratings', 'Enable Ratings'),
(825, 'user', 'Enable to publicly visible service ratings, Until complete 3 ratings it will be hidden', 'enable-ratings-title', 'Enable to publicly visible service ratings, Until complete 3 ratings it will be hidden'),
(826, 'user', 'Learn more', 'learn-more', 'Learn more'),
(827, 'user', 'Write your review', 'write-review', 'Write your review'),
(828, 'user', 'January', 'january', 'January'),
(829, 'user', 'February', 'february', 'February'),
(830, 'user', 'March', 'march', 'March'),
(831, 'user', 'April', 'april', 'April'),
(832, 'user', 'May', 'may', 'May'),
(833, 'user', 'June', 'june', 'June'),
(834, 'user', 'July', 'july', 'July'),
(835, 'user', 'August', 'august', 'August'),
(836, 'user', 'September', 'september', 'September'),
(837, 'user', 'October', 'october', 'October'),
(838, 'user', 'November', 'november', 'November'),
(839, 'user', 'December', 'december', 'December'),
(840, 'user', 'Su', 'su', 'Su'),
(841, 'user', 'Mo', 'mo', 'Mo'),
(842, 'user', 'Tu', 'tu', 'Tu'),
(843, 'user', 'We', 'we', 'We'),
(844, 'user', 'Th', 'th', 'Th'),
(845, 'user', 'Fr', 'fr', 'Fr'),
(846, 'user', 'Sa', 'sa', 'Sa'),
(847, 'user', 'Days', 'days', 'Days'),
(848, 'user', 'Day', 'day', 'Day'),
(849, 'user', 'Kay Id', 'kay-id', 'Key Id'),
(850, 'user', 'Key Secret', 'key-secret', 'Key Secret'),
(851, 'user', 'Setup your Razorpay account to accept payments', 'razorpay-title', 'Setup your Razorpay account to accept payments'),
(852, 'user', 'Razorpay ', 'razorpay', 'Razorpay '),
(853, 'user', 'Opening Hour', 'opening-hour', 'Opening Hour'),
(854, 'user', 'End Hour', 'end-hour', 'End Hour'),
(855, 'user', 'Branches', 'branches', 'Branches'),
(856, 'user', 'Enable Locations', 'enable-locations', 'Enable Locations'),
(857, 'user', 'Disable Locations', 'disable-locations', 'Disable Locations'),
(858, 'user', 'Enable to allow locations in booking page', 'enable-location-title', 'Enable to allow locations in booking page'),
(859, 'user', 'Disable to hide locations in booking page', 'disable-location-title', 'Disable to hide locations in booking page'),
(860, 'user', 'Any special notes?', 'any-special-notes', 'Any special notes?'),
(861, 'user', 'Write your notes here', 'write-your-notes-here', 'Write your notes here'),
(862, 'user', 'Enable Frontend', 'enable-frontend', 'Enable Frontend'),
(863, 'user', 'Enable to show frontend site', 'enable-to-show-frontend-site', 'Enable to show frontend site'),
(864, 'user', 'View Details', 'view-details', 'View Details'),
(865, 'user', 'Total Appointments', 'total-appointments', 'Total Appointments'),
(866, 'user', 'Total Services', 'total-services', 'Total Services'),
(867, 'user', 'Last Appointment', 'last-appointment', 'Last Appointment'),
(868, 'user', 'Add Breaks', 'add-breaks', 'Add Breaks'),
(869, 'user', 'This phone number will used for as username', 'phone-as-username', 'This phone number will used for as username'),
(870, 'user', 'Search', 'search', 'Search'),
(871, 'user', 'Search Value', 'search-value', 'Search Value'),
(872, 'user', ' Twillo SMS Settings', 'twillo-sms-settings', ' Twillo SMS Settings'),
(873, 'user', 'Cancel', 'cancel', 'Cancel'),
(874, 'user', 'Phone already exist', 'phone-exist', 'Phone already exist'),
(875, 'user', 'Persons', 'persons', 'Persons'),
(876, 'user', 'Bringing anyone with you?', 'bringing-anyone-with-you', 'Bringing anyone with you?'),
(877, 'user', 'Additional Persons:', 'additional-persons', 'Additional Persons:'),
(878, 'user', 'General Settings', 'general-settings', 'General Settings'),
(879, 'user', 'Enable Group Booking', 'enable-group-booking', 'Enable Group Booking'),
(880, 'user', 'Enable to allow group booking for your customers', 'enable-group-title', 'Enable to allow group booking for your customers'),
(881, 'user', 'Maximum allowed additional persons', 'max-allowed-persons', 'Maximum allowed additional persons'),
(882, 'user', 'Group Booking', 'group-booking', 'Group Booking'),
(883, 'user', 'Payments', 'payments', 'Payments'),
(884, 'user', 'just now', 'just-now', 'just now'),
(885, 'user', 'one minute ago', 'one-minute-ago', 'one minute ago'),
(886, 'user', 'minutes ago', 'minutes-ago', 'minutes ago'),
(887, 'user', 'an hour ago', 'an-hour-ago', 'an hour ago'),
(888, 'user', 'hours ago', 'hours-ago', 'hours ago'),
(889, 'user', 'yesterday', 'yesterday', 'yesterday'),
(890, 'user', 'days ago', 'days-ago', 'days ago'),
(891, 'user', 'weeks ago', 'weeks-ago', 'weeks ago'),
(892, 'user', 'a month ago', 'a-month-ago', 'a month ago'),
(893, 'user', 'months ago', 'months-ago', 'months ago'),
(894, 'user', 'one year ago', 'one-year-ago', 'one year ago'),
(895, 'user', 'years ago', 'years-ago', 'years ago'),
(896, 'user', 'Jan', 'jan', 'Jan'),
(897, 'user', 'Feb', 'feb', 'Feb'),
(898, 'user', 'Mar', 'mar', 'Mar'),
(899, 'user', 'Apr', 'apr', 'Apr'),
(900, 'user', 'Jun', 'jun', 'Jun'),
(901, 'user', 'Jul', 'jul', 'Jul'),
(902, 'user', 'Aug', 'aug', 'Aug'),
(903, 'user', 'Sep', 'sep', 'Sep'),
(904, 'user', 'Oct', 'oct', 'Oct'),
(905, 'user', 'Nov', 'nov', 'Nov'),
(906, 'user', 'Dec', 'dec', 'Dec'),
(907, 'user', 'Facebook', 'facebook', 'Facebook'),
(908, 'user', 'Twitter', 'twitter', 'Twitter'),
(909, 'user', 'Instagram', 'instagram', 'Instagram'),
(910, 'user', 'WhatsApp', 'whatsapp', 'WhatsApp'),
(911, 'user', 'LinkedIn', 'linkedin', 'LinkedIn'),
(912, 'user', 'Google Analytics', 'google-analytics', 'Google Analytics'),
(913, 'user', 'reCaptcha', 'recaptcha', 'reCaptcha'),
(914, 'user', 'Total Persons', 'total-persons', 'Total Persons'),
(915, 'user', 'Apply service duration to generate booking time slots', 'generate-booking-time-slots', 'Apply service duration to generate booking time slots'),
(916, 'user', 'Apply fixed duration to generate booking time slots', 'fixed-booking-time-slots', 'Apply fixed duration to generate booking time slots'),
(917, 'user', 'Enable Online Payments', 'enable-online-payment', 'Enable Online Payments'),
(918, 'user', 'Enable to active only payment methods to receive booking payments', 'enable-online-title', 'Enable to active online payment methods to receive booking payments'),
(919, 'user', 'Enable offline payment', 'enable-offline-payment', 'Enable offline payment'),
(920, 'user', 'Enable to active onsite payment option', 'enable-offline-title', 'Enable to active onsite payment option'),
(921, 'admin', 'Not Assigned', 'not-assigned', 'Not Assigned'),
(922, 'admin', 'Notes', 'notes', 'Notes'),
(923, 'admin', 'Appearance', 'appearance', 'Appearance'),
(924, 'admin', 'Frontend Color', 'frontend-color', 'Frontend Color'),
(925, 'admin', 'Set layout', 'set-layout', 'Set layout'),
(926, 'admin', 'Light', 'light', 'Light'),
(927, 'admin', 'Dark', 'dark', 'Dark'),
(928, 'admin', 'Used', 'used', 'Used'),
(929, 'admin', 'Select payment method', 'select-payment-method', 'Select payment method'),
(930, 'admin', 'Designation', 'designation', 'Designation'),
(931, 'admin', 'Feedback', 'feedback', 'Feedback'),
(932, 'admin', 'Testimonials', 'testimonials', 'Testimonials'),
(933, 'admin', 'What our customer says about ', 'testimonial-title', 'What our customer says about '),
(934, 'admin', 'SEO Settings', 'seo-settings', 'SEO Settings'),
(935, 'admin', 'Reports', 'reports', 'Reports'),
(936, 'admin', 'Most booked customers', 'most-booked-customers', 'Most booked customers'),
(937, 'admin', 'Most serviced staffs', 'most-serviced-staffs', 'Most serviced staffs'),
(938, 'admin', 'Most booked services', 'most-booked-services', 'Most booked services'),
(939, 'admin', 'Time Zone', 'time-zone', 'Time Zone'),
(940, 'admin', 'Enable to allow locations in booking page and your staffs will be available by locations', 'location-title-2', 'Enable to allow locations in booking page and your staffs will be available by location'),
(941, 'admin', 'left', 'left', 'left'),
(942, 'admin', 'Calendar Settings', 'calendar-settings', 'Calendar Settings'),
(943, 'admin', 'Client Id', 'client-id', 'Client Id'),
(944, 'admin', 'Client Secret', 'client-secret', 'Client Secret'),
(945, 'admin', 'Google Calendar', 'google-calendar', 'Google Calendar'),
(946, 'admin', 'Authorized redirect URIs', 'authorized-redirect-uris', 'Authorized redirect URIs'),
(947, 'admin', 'Google Callback URL', 'google-callback-url', 'Google Callback URL'),
(948, 'admin', 'Google Calendar Sync', 'google-calendar-sync', 'Google Calendar Sync'),
(949, 'admin', 'Sync Google Calendar', 'sync-google-calendar', 'Sync Google Calendar'),
(950, 'admin', 'Google Calendar Integration Doc', 'google-calendar-integration', 'Google Calendar Integration Doc'),
(951, 'admin', 'Lifetime Price', 'lifetime-price', 'Lifetime Price'),
(952, 'admin', 'Lifetime', 'lifetime', 'Lifetime'),
(953, 'admin', 'Enable Lifetime Plan', 'enable-lifetime', 'Enable Lifetime Plan'),
(954, 'admin', 'Enable to active lifetime plan for subscribed users.', 'enable-lifetime-title', 'Enable to active lifetime plan for subscribed users.'),
(955, 'admin', 'For better view use', 'for-better-view-use', 'For better view use'),
(956, 'admin', 'Header Script Codes', 'header-script-codes', 'Header Script Codes'),
(957, 'admin', 'Paste google analytics, Facebook Pixel or any other script codes here', 'header-script-codes-title', 'Paste google analytics, Facebook Pixel or any other script codes here'),
(958, 'admin', 'Welcome to', 'welcome-to', 'Welcome to'),
(959, 'admin', 'Your verification code is', 'your-verification-code-is', 'Your verification code is'),
(960, 'admin', 'Appointment', 'appointment', 'Appointment'),
(961, 'admin', 'booking is confirmed at', 'booking-is-confirmed-at', 'booking is confirmed at'),
(962, 'admin', 'Appointment Confirmation', 'appointment-confirmation', 'Appointment Confirmation'),
(963, 'admin', 'Your appointment is booked successfully at', 'appointment-successfully-at', 'Your appointment is booked successfully at'),
(964, 'admin', 'Please login to your account for more details', 'login-more-details', 'Please login to your account for more details'),
(965, 'user', 'Apply your coupon code here', 'apply-your-coupon-code-here', 'Apply your coupon code here'),
(966, 'user', 'Coupons limit', 'coupons-limit', 'Coupons limit'),
(967, 'user', 'How many days will be active this coupon', 'how-many-days-will-be-active-this-coupon', 'How many days will be active this coupon'),
(968, 'user', 'Discount must be between 1% - 99%', 'discount-must-be-between', 'Discount must be between 1% - 99%'),
(969, 'user', 'Export as CSV', 'export-as-csv', 'Export as CSV'),
(970, 'user', 'Codes', 'codes', 'Codes'),
(971, 'user', 'See all codes', 'see-all-codes', 'See all codes'),
(972, 'user', 'Your name string contains illegal characters.', 'illegal-characters-title', 'Your name string contains illegal characters.'),
(973, 'user', 'Please Complete these steps', 'please-complete-these-steps', 'Please Complete these steps'),
(974, 'user', 'Set Business Hours', 'set-business-hours', 'Set Business Hours'),
(975, 'user', 'Add Staff', 'add-staff', 'Add Staff'),
(976, 'user', 'Add Customer', 'add-customer', 'Add Customer'),
(977, 'user', 'Add Service', 'add-service', 'Add Service'),
(978, 'user', 'Enter phone number with dial code', 'enter-phone-number-with-dial-code', 'Enter phone number with dial code'),
(979, 'user', 'Cities', 'cities', 'Cities'),
(980, 'user', 'Location is required', 'location-required', 'Location is required'),
(981, 'admin', 'Paystack', 'paystack', 'Paystack'),
(982, 'admin', 'Setup Your Paystack Account to Accept Payments', 'paystack-title', 'Setup Your Paystack Account to Accept Payments'),
(983, 'user', 'Recently booked an appointment at', 'recently-booked-an-appointment', 'Recently booked an appointment at'),
(984, 'user', 'New appointment is booked', 'new-appointment-is-booked', 'Booked new appointment'),
(985, 'user', 'Quantity', 'quantity', 'Quantity'),
(986, 'user', 'Coupon code already applied', 'coupon-code-already-applied', 'Coupon code already applied'),
(987, 'user', 'Have any coupon code?', 'have-any-coupon-code', 'Have any coupon code?'),
(988, 'user', 'Enable to active coupon code feature', 'enable-coupon-title', 'Enable to active coupon code feature'),
(989, 'user', 'Allow Google Meet', 'allow-google-meet', 'Allow Google Meet'),
(990, 'user', 'Google meet link', 'google-meet-link', 'Google meet invitation link'),
(991, 'user', 'Google Meet', 'google-meet', 'Google Meet'),
(992, 'user', 'Virtual Meeting', 'virtual-meeting', 'Virtual Meeting'),
(993, 'user', 'Zoom', 'zoom', 'Zoom'),
(994, 'user', 'Enable Coupon from', 'enable-coupon-from', 'Enable Coupon from'),
(995, 'user', 'Holidays', 'holidays', 'Holidays'),
(996, 'user', 'Interval Settings', 'interval-settings', 'Interval Settings'),
(997, 'user', 'Enable Appointment Reminder', 'enable-appointment-reminder', 'Enable Appointment Reminder'),
(998, 'user', 'Send reminder email', 'send-reminder-email', 'Send reminder email'),
(999, 'user', 'Same day', 'same-day', 'Same day'),
(1000, 'user', 'Before', 'before', 'Before'),
(1001, 'user', 'Login', 'login', 'Login'),
(1002, 'user', 'Trial', 'trial', 'Trial'),
(1003, 'user', 'Plan Coupons', 'plan-coupons', 'Plan Coupons'),
(1004, 'user', 'System Settings', 'system-settings', 'System Settings'),
(1005, 'user', 'Guest Booking', 'guest-booking', 'Guest Booking'),
(1006, 'user', 'Enable Guest Booking', 'enable-guest-booking', 'Enable Guest Booking'),
(1007, 'user', 'Enable to allow guest booking', 'enable-guest-booking-title', 'Enable to allow guest booking'),
(1008, 'user', 'Wallet Settings', 'wallet-settings', 'Wallet Settings'),
(1009, 'user', 'Commission Rate', 'commission-rate', 'Commission Rate'),
(1010, 'user', 'Minimum Payout Amount', 'minimum-payout-amount', 'Minimum Payout Amount'),
(1011, 'user', 'Enable Payouts', 'enable-payouts', 'Enable Payouts'),
(1012, 'user', 'Enable to active payouts module and receive users appointment payment to admin account.', 'enable-payout-title', 'Enable to active payouts module and receive users appointment payment to admin account.'),
(1013, 'user', 'Payouts', 'payouts', 'Payouts'),
(1014, 'user', 'Setup Payout Accounts', 'setup-payout-accounts', 'Setup Payout Accounts'),
(1015, 'user', 'Set Payout Account', 'set-payout-account', 'Set Payout Account'),
(1016, 'user', 'Full Name', 'full-name', 'Full Name'),
(1017, 'user', 'IBAN', 'iban', 'IBAN'),
(1018, 'user', 'Bank Name', 'bank-name', 'Bank Name'),
(1019, 'user', 'International Bank Account Number(IBAN) ', 'iban-number', 'International Bank Account Number(IBAN) '),
(1020, 'user', 'State', 'state', 'State'),
(1021, 'user', 'City', 'city', 'City'),
(1022, 'user', 'Postcode', 'post-code', 'Postcode'),
(1023, 'user', 'Bank Account Holder\'s Name', 'bank-account-holders-name', 'Bank Account Holder\'s Name'),
(1024, 'user', 'Bank Branch Country', 'bank-branch-country', 'Bank Branch Country'),
(1025, 'user', 'Bank Branch City', 'bank-branch-city', 'Bank Branch City'),
(1026, 'user', 'Bank Account Number', 'bank-account-number', 'Bank Account Number'),
(1027, 'user', 'Swift Code', 'swift-code', 'Swift Code'),
(1028, 'user', 'Swift', 'swift', 'Swift'),
(1029, 'user', 'Invalid withdrawal amount!', 'invalid-withdrawal-amount', 'Invalid withdrawal amount!'),
(1030, 'user', 'Payout request sent successfully !', 'payout-request-sent-successfully', 'Payout request sent successfully !'),
(1031, 'user', 'Minimum Payout Amounts', 'minimum-payout-amounts', 'Minimum Payout Amounts'),
(1032, 'user', 'Empty Paypal email', 'empty-paypal-email', 'Empty Paypal email'),
(1033, 'user', 'Empty IBAN info', 'empty-iban-info', 'Empty IBAN info'),
(1034, 'user', 'Empty Swift info', 'empty-swift-info', 'Empty Swift info'),
(1035, 'user', 'Transaction ID', 'transaction-id', 'Transaction ID'),
(1036, 'user', 'Withdrawal Method', 'withdrawal-method', 'Withdrawal Method'),
(1037, 'user', 'Amount', 'amount', 'Amount'),
(1038, 'user', 'Send Payout Request', 'send-payout-request', 'Send Payout Request'),
(1039, 'user', 'Total Earnings', 'total-earnings', 'Total Earnings'),
(1040, 'user', 'Total Withdraw', 'total-withdraw', 'Total Withdraw'),
(1041, 'user', 'Balance', 'balance', 'Balance'),
(1042, 'user', 'after commission of', 'after-commission-of', 'after commission of'),
(1043, 'user', 'Payout Settings', 'payout-settings', 'Payout Settings'),
(1044, 'user', 'Payout Requests', 'payout-requests', 'Payout Requests'),
(1045, 'user', 'Payout Completed', 'payout-completed', 'Payout Completed'),
(1046, 'user', 'Request Sent', 'request-sent', 'Request Sent'),
(1047, 'user', 'Enable / Disable Payout Methods', 'enabledisable-payout-methods', 'Enable / Disable Payout Methods'),
(1048, 'user', 'must be between 1% - 99%', 'must-be-between-1-99', 'must be between 1% - 99%'),
(1049, 'user', 'Payout History', 'payout-history', 'Payout History'),
(1050, 'user', 'Payout Method', 'payout-method', 'Payout Method'),
(1051, 'user', 'Add Payout', 'add-payout', 'Add Payout'),
(1052, 'user', 'Wallet', 'wallet', 'Wallet'),
(1053, 'user', 'User Dashboard', 'user-dashboard', 'User Dashboard'),
(1054, 'user', 'has been', 'has-been', 'has been'),
(1055, 'user', 'Appointment Reminder', 'appointment-reminder', 'Appointment Reminder'),
(1056, 'user', 'Tomorrow you have an appointment', 'tomorrow-you-have-an-appointment', 'Tomorrow you have an appointment'),
(1057, 'admin', 'Dear', 'dear', 'Dear'),
(1058, 'admin', 'thank you for your booking at our', 'thank-you-for-your-booking-at-our', 'thank you for your booking at our'),
(1059, 'admin', 'at', 'at', 'at'),
(1060, 'admin', 'is', 'is', 'is'),
(1061, 'admin', 'Confirmed', 'confirmed', 'Confirmed'),
(1062, 'admin', 'Rate this service', 'rate-this-service', 'Rate this service'),
(1063, 'admin', 'Your feedback', 'your-feedback', 'Your feedback'),
(1064, 'admin', 'Your account has been created successfully, now you can login to your account using below access', 'new-user-account-login', 'Your account has been created successfully, now you can login to your account using below access'),
(1065, 'admin', 'Site Animation', 'site-animation', 'Site Animation'),
(1066, 'admin', 'Enable to activate website animation', 'site-animation-title', 'Enable to activate website animation'),
(1067, 'admin', 'Enable', 'enable', 'Enable'),
(1068, 'admin', 'Amount Withdraw', 'amount-withdraw', 'Amount Withdraw'),
(1069, 'admin', 'Flutterwave', 'flutterwave', 'Flutterwave'),
(1070, 'admin', 'Copy', 'copy', 'Copy'),
(1071, 'admin', 'Copied', 'copied', 'Copied'),
(1072, 'admin', 'Sender Email', 'sender-email', 'Sender Email'),
(1073, 'admin', 'Access Token', 'access-token', 'Access Token'),
(1074, 'admin', 'Password Recovery', 'password-recovery', 'Password Recovery'),
(1075, 'admin', 'Hello', 'hello', 'Hello'),
(1076, 'admin', 'We have reset your password, Please use this', 'we-reset-pass', 'We have reset your password, Please use below'),
(1077, 'admin', 'code to login your account', 'code-to-login-your-account', 'code to login your account'),
(1078, 'admin', 'Custom Domain', 'custom-domain', 'Custom Domain'),
(1079, 'admin', 'Domains', 'domain', 'Domains'),
(1080, 'admin', 'Requests', 'request', 'Requests'),
(1081, 'admin', 'Current domain', 'current-domain', 'Current domain'),
(1082, 'admin', 'Custom domain', 'custom-domain', 'Custom domain'),
(1083, 'admin', 'Approve', 'approve', 'Approve'),
(1084, 'admin', 'Short details', 'short-details', 'Short details'),
(1085, 'admin', 'Host', 'host', 'Host'),
(1086, 'admin', 'ttl', 'ttl', 'TTL'),
(1087, 'admin', 'two', 'two', 'two'),
(1088, 'admin', 'One', 'one', 'one'),
(1089, 'admin', 'IP', 'ip', 'IP'),
(1090, 'admin', 'Write details here', 'write-details-here', 'Write details here'),
(1091, 'admin', 'Domain Requests', 'domain-requests', 'Domain Requests'),
(1092, 'admin', 'Current Url', 'current-url', 'Current Url'),
(1093, 'admin', 'Domain Settings', 'domain-settings', 'Domain Settings'),
(1094, 'admin', 'Custom Domains', 'custom-domains', 'Custom Domains'),
(1095, 'admin', 'Your Server IP Address', 'server-ip-address', 'Your Server IP Address'),
(1096, 'admin', 'This ip address will be used to setup users custom domain > DNS settings', 'ip-help-info', 'This ip address will be used to setup users custom domain > DNS settings'),
(1097, 'admin', 'DNS Settings', 'dns-settings', 'DNS Settings'),
(1098, 'admin', 'Upload an Example Screenshot', 'upload-an-example-screenshot', 'Upload an Example Screenshot'),
(1099, 'admin', 'This part will be shown for your users to setup custom domain > DNS settings', 'user-dns-settings-types', 'This part will be shown for your users to setup custom domain > DNS settings'),
(1100, 'admin', 'Before going to submit your custom domain request make sure you have purchased this domain and its ready to use', 'custom-domain-user-warning-info', 'Before going to submit your custom domain request make sure you have purchased this domain and its ready to use'),
(1101, 'admin', 'Default Url', 'default-url', 'Default Url'),
(1102, 'admin', 'Openai API', 'openai-api', 'Openai API'),
(1103, 'admin', 'Openai API Key', 'openai-api-key', 'Openai API Key'),
(1104, 'admin', 'Openai Model', 'openai-model', 'Openai Model'),
(1105, 'admin', 'Enable to allow openai in this system', 'enable-openai', 'Enable to allow openai in this system'),
(1106, 'admin', 'Ai Response', 'ai-response', 'Ai Response'),
(1107, 'admin', 'Generate', 'generate', 'Generate'),
(1108, 'admin', 'Advanced settings', 'advanced-settings', 'Advanced settings'),
(1109, 'admin', 'Content creativity level', 'content-creativity-level', 'Content creativity level'),
(1110, 'admin', 'Output Variations', 'output-variations', 'Output Variations'),
(1111, 'admin', 'Max words', 'max-wrods', 'Max words'),
(1112, 'admin', 'No content yet', 'no-content-yet', 'No content yet'),
(1113, 'admin', 'Output', 'output', 'Output'),
(1114, 'admin', 'Documents', 'documents', 'Documents'),
(1115, 'admin', 'Low', 'low', 'Low'),
(1116, 'admin', 'Medium', 'medium', 'Medium'),
(1117, 'admin', 'High', 'high', 'High'),
(1118, 'admin', 'Generate AI Response', 'generate-ai-response', 'Generate AI Response'),
(1119, 'admin', 'Give some directions about your topic', 'give-some-directions-about-your-topic', 'Give some directions about your topic'),
(1120, 'admin', 'Enable to allow custom domain feature for users', 'enable-cdomain', 'Enable to allow custom domain feature for users'),
(1121, 'user', 'Withdrawal Amount', 'withdrawal-amount', 'Withdrawal Amount'),
(1122, 'user', 'Request Sent', 'request-sent', 'Request Sent'),
(1123, 'user', 'Total Referrals', 'total-referrals', 'Total Referrals'),
(1124, 'user', 'Total Earnings', 'total-earnings', 'Total Earnings'),
(1125, 'user', 'Total Withdraw', 'total-withdraw', 'Total Withdraw'),
(1126, 'user', 'Minimum Payout Amounts', 'minimum-payout-amounts', 'Minimum Payout Amounts'),
(1127, 'user', 'My Referral URL', 'my-referral-url', 'My Referral URL'),
(1128, 'user', 'Referral policy', 'referral-policy', 'Referral policy'),
(1129, 'user', 'First Successful Payment by Referred Person', 'first-successful-payment-by-referred-person', 'First Successful Payment by Referred Person'),
(1130, 'user', 'Every Successful Payment by Referred Person', 'every-successful-payment-by-referred-person', 'Every Successful Payment by Referred Person'),
(1131, 'user', 'Referral guidelines', 'referral-guidelines', 'Referral guidelines'),
(1132, 'user', 'How It works', 'how-it-works', 'How It works'),
(1133, 'user', 'Send Invitation', 'send-invitation', 'Send Invitation'),
(1134, 'user', 'Send your referral link to your friends and tell them how cool is this', 'send-your-referral-link-to-your-friends-and-tell-them-how-cool-is-this', 'Send your referral link to your friends and tell them how cool is this'),
(1135, 'user', 'Registration', 'registration', 'Registration'),
(1136, 'user', 'Let them register using your referral link', 'let-them-register-using-your-referral-link', 'Let them register using your referral link'),
(1137, 'user', 'Get Commissions', 'get-commissions', 'Get Commissions'),
(1138, 'user', 'Earn commission for their first subscription plan payments!', 'earn-commission-for-their-first-subscription-plan-payments', 'Earn commission for their first subscription plan payments!'),
(1139, 'user', 'Paypal Email', 'paypal-email', 'Paypal Email'),
(1140, 'user', 'Bank Details', 'bank-details', 'Bank Details'),
(1141, 'user', 'Referrals', 'referrals', 'Referrals'),
(1142, 'user', 'Referrar Id', 'referrar-id', 'Referral Id '),
(1143, 'user', 'Order Id', 'order-id', 'Order Id'),
(1144, 'user', 'Commision', 'commision', 'Commission '),
(1145, 'user', 'Commision Amount', 'commision-amount', 'Commission Amount'),
(1146, 'user', 'Select your payment method', 'select-your-payment-method', 'Select your payment method'),
(1147, 'user', 'Paypal', 'paypal', 'Paypal'),
(1148, 'user', 'Bank', 'bank', 'Bank'),
(1149, 'user', 'Method Details', 'method-details', 'Method Details'),
(1150, 'user', 'Enable Referral', 'enable-referral', 'Enable Referral'),
(1151, 'user', 'Choose Referral policy', 'choose-referral-policy', 'Choose Referral policy'),
(1152, 'user', 'Commission only on first purchase', 'commission-only-on-first-purchase', 'Commission only on first purchase'),
(1153, 'user', 'Commission on every purchase', 'commission-on-every-purchase', 'Commission on every purchase'),
(1154, 'user', 'Commision Rate(%)', 'commision-rate', 'Commission Rate'),
(1155, 'user', 'Minimum Payout', 'minimum-payout', 'Minimum Payout'),
(1156, 'user', 'Refferal Guidelines', 'refferal-guidelines', 'Refferal Guidelines'),
(1157, 'user', 'Payout Request', 'payout-request', 'Payout Request'),
(1158, 'user', 'Completed Payout', 'completed-payout', 'Completed Payout'),
(1159, 'user', 'Affiliate', 'affiliate', 'Affiliate'),
(1160, 'user', 'Referral Settings', 'referral-settings', 'Referral Settings'),
(1161, 'user', 'Upload About Image', 'upload-about-image', 'Upload About Image'),
(1162, 'user', 'About Company', 'about-company', 'About Company'),
(1163, 'user', 'About Title', 'about-title', 'About Title'),
(1164, 'user', 'Established In', 'established-in', 'Established In'),
(1165, 'user', 'About Video Url', 'about-video-url', 'About Video Url'),
(1166, 'user', 'About Details', 'about-details', 'About Details'),
(1167, 'user', 'Brand', 'brand', 'Brand'),
(1168, 'user', 'Slider', 'slider', 'Slider'),
(1169, 'user', 'Icon', 'icon', 'Icon'),
(1170, 'user', 'Icon Image', 'icon-image', 'Icon Image'),
(1171, 'user', 'Category Image', 'category-image', 'Category Image'),
(1172, 'user', 'Select Icon/Image', 'select-iconimage', 'Select Icon/Image'),
(1173, 'user', 'Link', 'link', 'Link'),
(1174, 'user', 'Brands', 'brands', 'Brands'),
(1175, 'user', 'Sliders', 'sliders', 'Sliders'),
(1176, 'user', 'Send message', 'send-message', 'Send message'),
(1177, 'user', 'Logo', 'logo', 'Logo'),
(1178, 'user', 'Portfolios', 'portfolios', 'Portfolios'),
(1179, 'user', 'View', 'view', 'View'),
(1180, 'user', 'Portfolio Category', 'portfolio-category', 'Portfolio Category'),
(1181, 'user', 'Enable Portfolio', 'enable-portfolio', 'Enable Portfolio'),
(1182, 'user', 'Enable to show portfolio option in home page', 'enable-portfolio-title', 'Enable to show portfolio option in home page'),
(1183, 'user', 'Enable to show brand option in home page', 'enable-brand-title', 'Enable to show brand option in home page'),
(1184, 'user', 'Enable Brand', 'enable-brand', 'Enable Brand'),
(1185, 'user', 'Enable Slider', 'enable-slider', 'Enable Slider'),
(1186, 'user', 'Enable to show slider option in home page', 'enable-slider-title', 'Enable to show slider option in home page'),
(1187, 'user', 'Enable to show blog option in home page', 'enable-blog-title', 'Enable to show blog option in home page'),
(1188, 'user', 'Enable Blog', 'enable-blog', 'Enable Blog'),
(1189, 'user', 'Enable Testimonial', 'enable-testimonial', 'Enable Testimonial'),
(1190, 'user', 'Enable to show testimonial option in home page', 'enable-testimonial-title', 'Enable to show testimonial option in home page'),
(1191, 'user', 'Sort by Categories', 'sort-by-categories', 'Sort by Categories'),
(1192, 'user', 'Fonts', 'fonts', 'Fonts'),
(1193, 'user', 'Font Name', 'font-name', 'Font Name'),
(1194, 'user', 'Color', 'color', 'Color'),
(1195, 'user', 'Theme Color & Font', 'theme-color', 'Theme, Color & Font'),
(1196, 'user', 'Themes', 'themes', 'Themes'),
(1197, 'user', 'Manage Fonts', 'manage-fonts', 'Manage Fonts'),
(1198, 'user', 'Overview', 'overview', 'Overview'),
(1199, 'user', 'Rating & Review', 'rating-review', 'Rating & Review'),
(1200, 'user', 'Google Fonts', 'google-fonts', 'Google Fonts'),
(1201, 'user', 'Get New Font', 'get-new-font', 'Get New Font'),
(1202, 'user', 'Custom Font', 'custom-font', 'Custom Font'),
(1203, 'user', 'Default', 'default', 'Default'),
(1204, 'user', 'About us', 'about-us', 'About us'),
(1205, 'user', 'Happy Clients', 'happy-clients', 'Happy Clients'),
(1206, 'user', 'Schedule', 'schedule', 'Schedule'),
(1207, 'user', 'Closed', 'closed', 'Closed'),
(1208, 'user', 'What We Offer', 'what-we-offer', 'What We Offer'),
(1209, 'user', 'What we do', 'what-we-do', 'What we do'),
(1210, 'user', 'Our Services', 'our-services', 'Our Services'),
(1211, 'user', 'Meet Our Specialists', 'meet-our-specialists', 'Meet Our Specialists'),
(1212, 'user', 'What our client says about ', 'what-our-client-says-about', 'What our client says about '),
(1213, 'user', 'Ready to book our Service?', 'ready-to-book-our-service', 'Ready to book our Service?'),
(1214, 'user', 'Our Best Services', 'our-best-services', 'Our Best Services'),
(1215, 'user', 'Projects', 'projects', 'Projects'),
(1216, 'user', 'Our Latest Portfolios', 'our-latest-portfolios', 'Our Latest Portfolios'),
(1217, 'user', 'Our Team Members', 'our-team-members', 'Our Team Members'),
(1218, 'user', 'Latest from our blog', 'latest-from-our-blog', 'Latest from our blog'),
(1219, 'user', 'More blogs', 'more-blogs', 'More blogs'),
(1220, 'user', 'Lets Talk', 'lets-talk', 'Lets Talk'),
(1221, 'user', 'Request a Free Quote', 'request-a-free-quote', 'Request a Free Quote'),
(1222, 'user', 'See Here', 'see-here', 'See Here'),
(1223, 'user', 'E-mail', 'e-mail', 'E-mail'),
(1224, 'user', 'Your Website', 'your-website', 'Your Website'),
(1225, 'user', 'Your message here', 'your-message-here', 'Your message here'),
(1226, 'user', 'We are available when you want', 'we-are-available-when-you-want', 'We are available when you want'),
(1227, 'user', 'Find design inspiration. Share your work. Join the #1 creative community online.', 'find-design-inspiration.-share-your-work.-join-the-1-creative-community-online', 'Find design inspiration. Share your work. Join the #1 creative community online.'),
(1228, 'user', 'What We Provide', 'what-we-provide', 'What We Provide'),
(1229, 'user', 'Teams', 'teams', 'Teams'),
(1230, 'user', 'Our Specialists', 'our-specialists', 'Our Specialists'),
(1231, 'user', 'What peoples says about Us', 'what-peoples-says-about-us', 'What peoples says about Us'),
(1232, 'user', 'Scince', 'scince', 'Scince'),
(1233, 'user', 'What Customers say about us', 'what-customers-say-about-us', 'What Customers say about us'),
(1234, 'user', 'What peoples say about our company', 'what-peoples-say-about-our-company', 'What peoples say about our company'),
(1235, 'user', 'Want to book our Service?', 'want-to-book-our-service', 'Want to book our Service?'),
(1236, 'user', 'Manage your bookings to click this', 'manage-your-bookings-to-click-this', 'Manage your bookings to click this'),
(1237, 'user', 'Contact Info', 'contact-info', 'Contact Info'),
(1238, 'user', 'Useful Links', 'useful-links', 'Useful Links'),
(1239, 'user', 'Want to get a online consultation?', 'want-to-get-a-online-consultation', 'Want to get a online consultation?'),
(1240, 'user', 'Themes', 'themes', 'Themes'),
(1241, 'user', 'Theme Settings', 'theme-settings', 'Theme Settings'),
(1242, 'user', 'Multipurpose One', 'multipurpose-one', 'Multipurpose One'),
(1243, 'user', 'Multipurpose Two', 'multipurpose-two', 'Multipurpose Two'),
(1244, 'user', 'Barbar / Stylists', 'barbar-stylists', 'Barbar / Stylists'),
(1245, 'user', 'Agency / Law Consultancy', 'law-consultancy', 'Agency / Law Consultancy'),
(1246, 'user', 'Medical / Health', 'medical-health', 'Medical / Health'),
(1247, 'user', 'Beauty / Wellness', 'beauty-wellness', 'Beauty / Wellness'),
(1248, 'user', 'Terms & Privacy', 'terms-privacy', 'Terms & Privacy'),
(1249, 'user', 'Enable Default Time Zone', 'enable-default-time-zone', 'Default Time Zone'),
(1250, 'user', 'Enable to activate default admin time zone for all users', 'default-time-zone-tiltle', 'Enable to activate default admin time zone for all users'),
(1251, 'user', 'Enable Embded Powered By Badge', 'enable-embded-badge', 'Enable Embded Powered By Badge'),
(1252, 'user', 'Enable to activate powered by badge on embedded booking page', 'embded-badge-tiltle', 'Enable to activate powered by badge on embedded booking page'),
(1253, 'user', 'Tax Settings', 'tax-settings', 'Tax Settings'),
(1254, 'user', 'Fixed Tax', 'fixed-tax', 'Fixed Tax'),
(1255, 'user', 'Service based tax', 'service-based-tax', 'Service Based Tax'),
(1256, 'user', 'Tax', 'tax', 'Tax'),
(1257, 'user', 'Service Tax', 'service-tax', 'Service Tax'),
(1258, 'user', 'Enable Globally', 'enable-globally', 'Enable Globally'),
(1259, 'user', 'Enable to activate WhatsApp sms for admin and user side.', 'enable-globally-whatsapp', 'Enable to activate WhatsApp sms for admin and user side.'),
(1260, 'user', 'Enable to activate Twilio sms for admin and user side.', 'enable-globally-twilio', 'Enable to activate Twilio sms for admin and user side.'),
(1261, 'user', 'Instance Id', 'instance-id', 'Instance Id'),
(1262, 'user', 'Ultramsg', 'ultramsg', 'Ultramsg'),
(1263, 'user', 'Token', 'token', 'Token'),
(1264, 'user', 'Sorry, Appointment is not available on that time', 'appointment-is-not-available-on-that-time', 'Sorry, Appointment is not available on that time'),
(1265, 'user', 'Small Logo', 'small-logo', 'Small Logo'),
(1266, 'user', 'Medium Logo', 'medium-logo', 'Medium Logo'),
(1267, 'user', 'Large Logo', 'large-logo', 'Large Logo'),
(1268, 'user', 'Custom Form', 'custom-form', 'Custom Form'),
(1269, 'user', 'Input Title', 'input-title', 'Input Title'),
(1270, 'user', 'Input Name', 'input-name', 'Input Name'),
(1271, 'user', 'Input Type', 'input-type', 'Input Type'),
(1272, 'user', 'Input required or not', 'input-required-or-not', 'Input required or not'),
(1273, 'user', 'New Input', 'new-input', 'New Input'),
(1274, 'user', 'Custom Forms', 'custom-forms', 'Custom Forms'),
(1275, 'user', 'Add new input', 'add-new-input', 'Add new input'),
(1276, 'user', 'Select input type', 'select-input-type', 'Select input type'),
(1277, 'user', 'text', 'text', 'Text'),
(1278, 'user', 'Textarea', 'textarea', 'Textarea'),
(1279, 'user', 'Is this required ?', 'is-required', 'Is this required ?'),
(1280, 'user', 'Additional Info', 'additional-info', 'Additional Info'),
(1281, 'user', 'Service Extra', 'service-extra', 'Service Extra'),
(1282, 'user', 'Wazfy', 'wazfy', 'Wazfy'),
(1283, 'user', 'Extra Service', 'extra-service', 'Extra Service'),
(1284, 'user', 'Service Type', 'service-type', 'Service Type'),
(1285, 'user', 'Recurring Service', 'recurring-sevice', 'Recurring Service'),
(1286, 'user', 'One of Service', 'one-of-service', 'One of Service'),
(1287, 'user', 'Number of Service', 'number-of-service', 'Number of Services'),
(1288, 'user', 'Repeats In', 'repeats-in', 'Repeats In'),
(1289, 'user', 'Repeats Weekly', 'repeats-weekly', 'Repeats Weekly'),
(1290, 'user', 'Repeats Monthly', 'repeats-monthly', 'Repeats Monthly'),
(1291, 'user', 'Recurring Service', 'recurring-service', 'Recurring Service'),
(1292, 'user', 'Recurring', 'recurring', 'Recurring'),
(1293, 'user', 'One Time Service', 'one-time-service', 'One Time Service'),
(1294, 'user', 'Service repeats weekly', 'service-repeats-weekly', 'Service repeats weekly'),
(1295, 'user', 'Service repeats monthly', 'service-repeats-monthly', 'Service repeats monthly'),
(1296, 'user', 'Recurring-info', 'recurring-info', 'Recurring-info'),
(1297, 'user', 'Repeated in ', 'repeated-in', 'Repeated in '),
(1298, 'user', 'Next', 'next', 'Next'),
(1299, 'user', 'Recurring Count', 'recurring-count', 'Recurring Count'),
(1300, 'user', 'Booked service extra', 'booked-service-extra', 'Booked service extra'),
(1301, 'user', 'Disable service extra', 'disable-service-extra', 'Disable service extra'),
(1302, 'user', 'Enable service extra', 'enable-service-extra', 'Enable service extra'),
(1303, 'user', 'PWA Settings', 'pwa-settings', 'PWA Settings'),
(1304, 'user', 'Enable PWA (Progressive Web Apps)', 'enable-pwa', 'Enable PWA (Progressive Web Apps)'),
(1305, 'user', 'Enable to allow your users to install PWA on their phone', 'pwa-enable-title', 'Enable to allow your users to install PWA on their phone'),
(1306, 'user', 'mage dimensions should not exceed 512 x 512 pixels.', 'pwa-logo-size-alert', 'mage dimensions should not exceed 512 x 512 pixels.'),
(1307, 'user', 'Install PWA', 'install-pwa', 'Install PWA'),
(1308, 'user', 'Custom CSS', 'custom-css', 'Custom CSS'),
(1309, 'user', 'Add your custom css code here', 'add-your-own-css-code-here', 'Add your custom css code here'),
(1310, 'user', 'Required', 'required', 'Required'),
(1311, 'user', 'Custom Inputs', 'custom-inputs', 'Custom Inputs'),
(1312, 'user', 'Setup Business', 'setup-business', 'Setup Business'),
(1313, 'user', 'Redirect URL', 'redirect-url', 'Redirect URL'),
(1314, 'user', 'Google', 'google', 'Google'),
(1315, 'user', 'Facebook App ID', 'facebook-app-id', 'Facebook App ID'),
(1316, 'user', 'Facebook App Secret', 'facebook-app-secret', 'Facebook App Secret'),
(1317, 'user', 'Graph Version', 'graph-version', 'Graph Version'),
(1318, 'user', 'Social Login', 'social-login', 'Social Login'),
(1319, 'user', 'Continue With Google', 'continue-with-google', 'Continue With Google'),
(1320, 'user', 'Continue With Facebook', 'continue-with-facebook', 'Continue With Facebook'),
(1321, 'user', 'Remember me', 'remember-me', 'Remember Me'),
(1322, 'user', 'Integration docs', 'integration-docs', 'Integration docs'),
(1323, 'user', 'Enable Default Timezone', 'enable-default-timezone', 'Enable Default Timezone'),
(1324, 'user', 'Enable to use company timezone for your all booking customers', 'enable-default-timezone-title', 'Enable to use company timezone for your all booking customers'),
(1325, 'user', 'Contact Message from', 'contact-message-from', 'Contact Message from'),
(1326, 'user', 'Events', 'events', 'Events'),
(1327, 'user', 'Tickets', 'tickets', 'Tickets'),
(1328, 'user', 'Venues', 'venues', 'Venues'),
(1329, 'user', 'Website', 'website', 'Website'),
(1330, 'user', 'Vedio URL', 'vedio-url', 'Vedio URL'),
(1331, 'user', 'Is seatable ?', 'is-seatable-', 'Is seatable ?'),
(1332, 'user', 'Is seatable ?', 'is-seatable', 'Is seatable ?'),
(1333, 'user', 'Total attendee', 'total-attendee', 'Total attendee (Maximum )'),
(1334, 'user', 'Venue Image', 'venue-image', 'Venue Image'),
(1335, 'user', 'Total Seat', 'total-seat', 'Total Seat'),
(1336, 'user', 'Seating info', 'seating-info', 'Seating info'),
(1337, 'user', 'Event Image', 'event-image', 'Event Image'),
(1338, 'user', 'Audience Type', 'audience-type', 'Audience Type'),
(1339, 'user', 'Youtube Vedio URL', 'youtube-vedio-url', 'Youtube Vedio URL'),
(1340, 'user', 'External Link', 'external-link', 'External Link'),
(1341, 'user', 'Contact Number', 'contact-number', 'Contact Number'),
(1342, 'user', 'Artists', 'artists', 'Artists (if  any artist of this event)'),
(1343, 'user', 'Is this organized by other ?', 'is-other-organizer', 'Is this organized by other ?'),
(1344, 'user', 'Organizer Name', 'organizer-name', 'Organizer Name'),
(1345, 'user', 'Organizer Phone', 'organizer-phone', 'Organizer Phone'),
(1346, 'user', 'Organizer Email', 'organizer-email', 'Organizer Email'),
(1347, 'user', 'Organizer Website', 'organizer-website', 'Organizer Website'),
(1348, 'user', 'Meta Tags', 'meta-tags', 'Meta Tags'),
(1349, 'user', 'Meta Description', 'meta-description', 'Meta Description'),
(1350, 'user', 'Ticket Name', 'ticket-name', 'Ticket Name'),
(1351, 'user', 'Ticket Details', 'ticket-details', 'Ticket Details'),
(1352, 'user', 'Ticket Price', 'ticket-price', 'Ticket Price'),
(1353, 'user', 'Sales Start', 'sales-start', 'Sales Start'),
(1354, 'user', 'ticket Description', 'ticket-description', 'ticket Description'),
(1355, 'user', 'Ticket Per Attendee', 'ticket-per-attendee', 'Ticket Per Attendee'),
(1356, 'user', 'Sales End', 'sales-end', 'Sales End'),
(1357, 'user', 'Venue', 'venue', 'Venue'),
(1358, 'user', 'Event', 'event', 'Event'),
(1359, 'user', 'Venue Info', 'venue-info', 'Venue Info'),
(1360, 'user', 'Ticket Info', 'ticket-info', 'Ticket Info'),
(1361, 'user', 'Countdown', 'countdown', 'Countdown'),
(1362, 'user', 'Organizer Info', 'organizer-info', 'Organizer Info'),
(1363, 'user', 'Book a ticket', 'book-a-ticket', 'Book a ticket'),
(1364, 'user', 'Event Info', 'event-info', 'Event Info'),
(1365, 'user', 'Maximum', 'maximum', 'Maximum'),
(1366, 'user', 'Ticket', 'ticket', 'Ticket'),
(1367, 'user', 'Total Ticket', 'total-ticket', 'Total Ticket'),
(1368, 'user', 'Total Price', 'total-price', 'Total Price'),
(1369, 'user', 'Event booked successfully', 'event-booked-successfully', 'Event booked successfully'),
(1370, 'user', 'Event booking number', 'event-booking-number', 'Event booking number'),
(1371, 'user', 'You can not buy more than', 'ticket-limit-msg', 'You can not buy more than'),
(1372, 'user', 'Booked new event', 'booked-new-event', 'Booked new event'),
(1373, 'user', 'We are thrilled to inform you that your ticket booking for the upcoming', 'event-booking-confirmation', 'We are thrilled to inform you that your ticket booking for the upcoming event'),
(1374, 'user', 'has been successfully confirmed', 'has-been-successfully-confirmed', 'has been successfully confirmed at'),
(1375, 'user', 'Recently bookrd an event', 'recently-bookrd-an-event', 'Recently booked an event'),
(1376, 'user', 'Recently booked an event', 'recently-booked-an-event', 'Recently booked an event'),
(1377, 'user', 'Bookings', 'bookings', 'Bookings'),
(1378, 'user', 'New Booking', 'new-booking', 'New Booking'),
(1379, 'user', 'Booking', 'booking', 'Booking'),
(1380, 'user', 'Sorry we have only ', 'sorry-we-have-only', 'Sorry !! we have only '),
(1381, 'user', 'More tickets available.', 'more-tickets-available', 'More tickets available.'),
(1382, 'user', 'This event is organized by', 'this-event-is-organized-by', 'This event is organized by'),
(1383, 'user', 'Availlable tickets for', 'availlable-tickets-for', 'Availlable tickets for'),
(1384, 'user', 'Add new ticket', 'add-new-ticket', 'Add new ticket'),
(1385, 'user', 'Appointment Date', 'appointment-date', 'Appointment Date'),
(1386, 'user', 'Appointment Time', 'appointment-time', 'Appointment Time'),
(1387, 'user', 'Appointment Cancelation before', 'cancelation-time', 'Appointment Cancelation before'),
(1388, 'user', 'Appointment Reminder before', 'reminder-before', 'Appointment Reminder before'),
(1389, 'user', 'Set 0 to disable this feature', 'set-0-to-disable-this-feature', 'Set 0 to disable this feature'),
(1390, 'user', 'You have an appointment', 'you-have-an-appointment', 'You have an appointment'),
(1391, 'user', 'The wallet system is now enabled. All appointment payments will be credited to the admin account, with the remaining amount added to your wallet balance.', 'wallet-enable-alert', 'The wallet system is now enabled. All appointment payments will be credited to the admin account, with the remaining amount added to your wallet balance.'),
(1392, 'user', 'Upcoming', 'upcoming', 'Upcoming');

-- --------------------------------------------------------

--
-- Table structure for table `locations`
--

CREATE TABLE `locations` (
  `id` int(11) NOT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `service_id` varchar(155) DEFAULT NULL,
  `user_id` int(11) NOT NULL,
  `business_id` varchar(25) DEFAULT '0',
  `phone` varchar(255) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `address` text,
  `status` int(11) DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `package`
--

CREATE TABLE `package` (
  `id` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `price` decimal(10,2) DEFAULT '0.00',
  `monthly_price` decimal(10,2) DEFAULT NULL,
  `lifetime_price` decimal(10,2) NOT NULL DEFAULT '1000.00',
  `bill_type` varchar(255) DEFAULT NULL,
  `is_special` int(11) NOT NULL DEFAULT '0',
  `status` int(11) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `package`
--

INSERT INTO `package` (`id`, `name`, `slug`, `price`, `monthly_price`, `lifetime_price`, `bill_type`, `is_special`, `status`) VALUES
(1, 'Free', 'basic', '0.00', '0.00', '0.00', 'year', 0, 1),
(2, 'Standard', 'standared', '10.00', '5.50', '15.00', 'year', 1, 1),
(3, 'Premium', 'premium', '15.00', '10.00', '20.00', 'year', 0, 1),
(5, 'Plus', 'Plus', '200.00', '10.00', '20.00', 'year', 0, 0);

-- --------------------------------------------------------

--
-- Table structure for table `pages`
--

CREATE TABLE `pages` (
  `id` int(11) NOT NULL,
  `lang_id` int(11) DEFAULT '1',
  `business_id` varchar(255) NOT NULL DEFAULT '0',
  `title` varchar(255) DEFAULT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `details` longtext,
  `status` int(11) DEFAULT NULL,
  `created_at` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `pages`
--

INSERT INTO `pages` (`id`, `lang_id`, `business_id`, `title`, `slug`, `details`, `status`, `created_at`) VALUES
(1, 1, '0', 'Terms and Conditions', 'terms-of-service', 'Terms and Conditions', NULL, '0000-00-00 00:00:00'),
(2, 1, '0', 'Privacy Policy', 'privacy-policy', 'Privacy Policy', 1, '2021-07-06 22:17:52');

-- --------------------------------------------------------

--
-- Table structure for table `payment`
--

CREATE TABLE `payment` (
  `id` int(11) NOT NULL,
  `puid` varchar(255) NOT NULL,
  `user_id` int(11) NOT NULL,
  `package_id` varchar(255) DEFAULT NULL,
  `billing_type` varchar(255) DEFAULT NULL,
  `amount` decimal(10,2) DEFAULT NULL,
  `status` varchar(255) NOT NULL,
  `created_at` date NOT NULL,
  `expire_on` date DEFAULT NULL,
  `payment_method` varchar(255) DEFAULT NULL,
  `proof` text,
  `tax` varchar(255) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `payment_user`
--

CREATE TABLE `payment_user` (
  `id` int(11) NOT NULL,
  `puid` varchar(255) NOT NULL,
  `user_id` int(11) NOT NULL,
  `customer_id` int(11) NOT NULL,
  `appointment_id` int(11) NOT NULL,
  `amount` decimal(10,2) DEFAULT NULL,
  `total_amount` decimal(10,2) DEFAULT '0.00',
  `commission_amount` decimal(10,2) DEFAULT '0.00',
  `commission_rate` int(11) DEFAULT '0',
  `status` varchar(255) NOT NULL,
  `created_at` date NOT NULL,
  `payment_method` varchar(255) DEFAULT NULL,
  `proof` varchar(255) DEFAULT NULL,
  `type` varchar(155) NOT NULL DEFAULT 'user'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `payment_user_event`
--

CREATE TABLE `payment_user_event` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `customer_id` int(11) NOT NULL,
  `event_id` int(11) NOT NULL,
  `puid` int(11) NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `status` varchar(155) NOT NULL,
  `payment_method` varchar(155) NOT NULL,
  `created_at` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `payouts`
--

CREATE TABLE `payouts` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `payout_method` varchar(255) NOT NULL,
  `amount` bigint(20) NOT NULL,
  `transaction_id` varchar(255) DEFAULT NULL,
  `message` text,
  `currency` varchar(255) DEFAULT NULL,
  `status` int(11) NOT NULL,
  `created_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `plan_coupons`
--

CREATE TABLE `plan_coupons` (
  `id` int(11) NOT NULL,
  `uid` varchar(255) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `user_id` varchar(155) DEFAULT '0',
  `plan` varchar(255) NOT NULL,
  `plan_type` varchar(255) DEFAULT NULL,
  `code` varchar(255) NOT NULL,
  `days` varchar(155) DEFAULT NULL,
  `discount` int(11) NOT NULL,
  `discount_type` varchar(155) DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `quantity` int(11) DEFAULT '0',
  `used` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  `apply_date` varchar(255) DEFAULT NULL,
  `created_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `plan_coupons_apply`
--

CREATE TABLE `plan_coupons_apply` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `coupon_id` int(11) NOT NULL,
  `created_at` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `portfolios`
--

CREATE TABLE `portfolios` (
  `id` int(11) NOT NULL,
  `lang_id` varchar(155) DEFAULT NULL,
  `business_id` varchar(155) DEFAULT NULL,
  `user_id` int(11) NOT NULL,
  `category` varchar(255) DEFAULT NULL,
  `title` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `link` varchar(255) DEFAULT NULL,
  `details` longtext,
  `image` varchar(255) NOT NULL,
  `thumb` varchar(255) NOT NULL,
  `status` int(11) NOT NULL,
  `created_at` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `product_services`
--

CREATE TABLE `product_services` (
  `id` int(11) NOT NULL,
  `lang_id` int(11) DEFAULT '1',
  `name` varchar(255) DEFAULT NULL,
  `details` text,
  `image` varchar(255) DEFAULT NULL,
  `thumb` varchar(255) DEFAULT NULL,
  `orders` int(11) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `product_services`
--

INSERT INTO `product_services` (`id`, `lang_id`, `name`, `details`, `image`, `thumb`, `orders`) VALUES
(1, 1, 'Create your own booking page that is branding your business', 'Customise and branding your business to share your booking page with a smart URL which will help you to run your business a smart way.', 'uploads/medium/copywriting-social-media-post-content-marketing-internet-commercial-cartoon-character-writing-text-advertising-promotional-strategy-concept-illustration_335657-2066_medium-600x600.jpg', 'uploads/thumbnail/copywriting-social-media-post-content-marketing-internet-commercial-cartoon-character-writing-text-advertising-promotional-strategy-concept-illustration_335657-2066_thumb-150x150.jpg', 1),
(2, 1, 'Accept bookings from anywhere anytime', 'There are no boundary for your business, Share your booking page URL using any social platform email or others to  booking your services from anywhere in the world.', 'uploads/medium/scheduling-forming-filling-timetable-digital-calendar-time-management-arranging-controlling-optimizing-effective-plans-organization-vector-isolated-concept-metaphor-illustration_335657-2748_medium-600x600.jpg', 'uploads/thumbnail/scheduling-forming-filling-timetable-digital-calendar-time-management-arranging-controlling-optimizing-effective-plans-organization-vector-isolated-concept-metaphor-illustration_335657-2748_thumb-150x150.jpg', 2),
(3, 1, 'Accept Online / Offline Payments from your Customers', 'Easily process your payments online in a secure manner, Select from Payment Processors like PayPal, Stripe and offline. ', 'uploads/medium/finances-management-budget-assessment-financial-literacy-accounting-idea-financier-with-cash-economist-holding-golden-coin-cartoon-character_335657-3538_medium-600x600.jpg', 'uploads/thumbnail/finances-management-budget-assessment-financial-literacy-accounting-idea-financier-with-cash-economist-holding-golden-coin-cartoon-character_335657-3538_thumb-150x150.jpg', 4),
(4, 1, 'Connect with your customers all around the world using zoom meeting', 'Integrate with Zoom, So you can easily manage your Virtual Meetings and Classes right from Aoxio. ', 'uploads/medium/online-meetup-abstract-concept-vector-illustration-conference-call-join-meetup-group-video-call-online-service-distance-communication-informal-meeting-members-networking-abstract-metaphor_335657-2920_medium-600x600.jpg', 'uploads/thumbnail/online-meetup-abstract-concept-vector-illustration-conference-call-join-meetup-group-video-call-online-service-distance-communication-informal-meeting-members-networking-abstract-metaphor_335657-2920_thumb-150x150.jpg', 3);

-- --------------------------------------------------------

--
-- Table structure for table `ratings`
--

CREATE TABLE `ratings` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `business_id` varchar(25) DEFAULT '0',
  `service_id` int(11) DEFAULT NULL,
  `appointment_id` int(11) DEFAULT NULL,
  `customer_id` int(11) NOT NULL,
  `rating` int(11) NOT NULL,
  `feedback` text,
  `created_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `referrals`
--

CREATE TABLE `referrals` (
  `id` int(11) NOT NULL,
  `referrar_id` varchar(255) DEFAULT NULL,
  `order_id` varchar(255) DEFAULT NULL,
  `user_id` int(11) DEFAULT '0',
  `status` int(11) DEFAULT '0',
  `amount` varchar(255) DEFAULT NULL,
  `commision` varchar(255) DEFAULT NULL,
  `commision_amount` varchar(255) DEFAULT NULL,
  `created_at` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `referral_payouts`
--

CREATE TABLE `referral_payouts` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `payout_method` varchar(255) NOT NULL,
  `method_details` varchar(255) NOT NULL,
  `amount` bigint(20) NOT NULL,
  `transaction_id` varchar(255) DEFAULT NULL,
  `status` int(11) NOT NULL,
  `created_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `referral_settings`
--

CREATE TABLE `referral_settings` (
  `id` int(11) NOT NULL,
  `is_enable` varchar(255) DEFAULT NULL,
  `referral_policy` text,
  `commision_rate` varchar(255) DEFAULT NULL,
  `minimum_payout` varchar(255) DEFAULT '0',
  `payment_method` varchar(255) DEFAULT NULL,
  `referral_guideline` text
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `referral_settings`
--

INSERT INTO `referral_settings` (`id`, `is_enable`, `referral_policy`, `commision_rate`, `minimum_payout`, `payment_method`, `referral_guideline`) VALUES
(1, '0', '2', '50', '10', 'Paypal', '<p>Referral guideline</p>');

-- --------------------------------------------------------

--
-- Table structure for table `services`
--

CREATE TABLE `services` (
  `id` int(11) NOT NULL,
  `business_id` varchar(25) DEFAULT '0',
  `category_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `details` longtext,
  `service_type` int(11) NOT NULL DEFAULT '1',
  `number_of_service` varchar(255) DEFAULT NULL,
  `service_repeat` varchar(255) DEFAULT NULL,
  `capacity` int(11) DEFAULT NULL,
  `capacity_left` varchar(255) DEFAULT NULL,
  `duration` varchar(255) DEFAULT NULL,
  `duration_type` varchar(255) DEFAULT 'minute',
  `price` decimal(10,2) DEFAULT NULL,
  `tax` decimal(10,2) DEFAULT NULL,
  `staffs` text,
  `status` int(11) NOT NULL,
  `orders` int(11) DEFAULT '0',
  `zoom_link` text,
  `google_meet` text,
  `service_extra` varchar(255) DEFAULT NULL,
  `enable_service_extra` int(11) DEFAULT '0',
  `image` varchar(255) DEFAULT NULL,
  `thumb` varchar(255) DEFAULT NULL,
  `created_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `service_category`
--

CREATE TABLE `service_category` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `business_id` varchar(25) DEFAULT '0',
  `name` varchar(255) NOT NULL,
  `icon` varchar(255) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `is_active` int(11) NOT NULL DEFAULT '1',
  `status` int(11) NOT NULL,
  `orders` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `service_extra`
--

CREATE TABLE `service_extra` (
  `id` int(11) NOT NULL,
  `user_id` varchar(255) NOT NULL,
  `business_id` varchar(255) DEFAULT '0',
  `name` varchar(255) NOT NULL,
  `price` varchar(255) NOT NULL,
  `duration_type` varchar(255) NOT NULL,
  `duration` varchar(255) NOT NULL,
  `status` int(11) NOT NULL,
  `created_at` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--
-- Table structure for table `settings_extra`
--

CREATE TABLE `settings_extra` (
  `id` int(11) NOT NULL,
  `lang_id` varchar(155) DEFAULT NULL,
  `site_name` varchar(255) DEFAULT NULL,
  `site_title` varchar(255) DEFAULT NULL,
  `keywords` varchar(255) DEFAULT NULL,
  `description` text,
  `footer_about` varchar(255) DEFAULT NULL,
  `copyright` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `settings_extra`
--

INSERT INTO `settings_extra` (`id`, `lang_id`, `site_name`, `site_title`, `keywords`, `description`, `footer_about`, `copyright`) VALUES
(1, '1', 'Aoxio', 'SaaS Multi-Business Service Booking Software', 'booking,english', 'Simplifies appointment booking, helping you to manage business  in a smart way.', 'Aoxio is a complete SaaS based multi business service booking software, that gives your users the ability to create and manage bookings, staffs, services, customers, etc.', '© 2021 All rights reserved.');

-- --------------------------------------------------------

--
-- Table structure for table `site_contacts`
--

CREATE TABLE `site_contacts` (
  `id` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `message` text,
  `created_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `sliders`
--

CREATE TABLE `sliders` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `business_id` varchar(155) NOT NULL,
  `title` varchar(255) NOT NULL,
  `details` text,
  `image` varchar(255) NOT NULL,
  `status` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `staffs`
--

CREATE TABLE `staffs` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `business_id` varchar(25) DEFAULT '0',
  `service_id` varchar(255) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `designation` varchar(255) NOT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `role` varchar(255) NOT NULL DEFAULT 'staff',
  `email` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `holidays` text,
  `facebook` varchar(255) DEFAULT NULL,
  `twitter` varchar(255) DEFAULT NULL,
  `linkedin` varchar(255) DEFAULT NULL,
  `whatsapp` varchar(255) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `thumb` varchar(255) DEFAULT NULL,
  `status` int(11) DEFAULT '1',
  `created_at` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `staff_locations`
--

CREATE TABLE `staff_locations` (
  `id` int(11) NOT NULL,
  `business_id` varchar(25) DEFAULT '0',
  `staff_id` int(11) NOT NULL,
  `location_id` int(11) NOT NULL,
  `sub_location_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `system_settings`
--

CREATE TABLE `system_settings` (
  `id` int(11) NOT NULL,
  `key` varchar(150) DEFAULT NULL,
  `value` text
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `system_settings`
--

INSERT INTO `system_settings` (`id`, `key`, `value`) VALUES
(1, 'google_client_id', '_559968879930-t6nbt41noogdbf59a4t1mhp1aq0c8p4e.apps.googleusercontent.com'),
(2, 'google_secret_key', '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'),
(3, 'google_redirect', 'http://localhost:8888/aoxio/login'),
(4, 'firebase_keypair', 'BAiWdJui0vBIybQCem-5z8i_Iy0t2zl324NMmdGJ0SL0tYPOi1jE09N6nfeV39wj6p_wI29jjDYuDdPov63wvGQ'),
(5, 'firebase_apiKey', 'AIzaSyCrTVhHHyLS7qqunsO-NbUhewMQp6akp-o'),
(6, 'firebase_authDomain', 'aoxio-pus-notification.firebaseapp.com'),
(7, 'firebase_projectId', 'aoxio-pus-notification'),
(8, 'firebase_storageBucket', 'aoxio-pus-notification.appspot.com'),
(9, 'firebase_messagingSenderId', '26280305547'),
(10, 'firebase_appId', '1:26280305547:web:6f93e48c0da11435d7458e'),
(11, 'firebase_server_key', 'AAAABh5to4s:APA91bHd3azwrWtOI3Yo1V6J4dJUyq_mxNkRH6IhFMjz4GQeOYLuPrEe5Ne0CZWoJEVlGtQYYRQ2SF2TT9mhIHp3sUSt481yhuDBlZlVrRZc0znaYM6hOWSA6C0h_Yj2Uc9EHXVDNN20'),
(12, 'facebook_app_id', '1059094885171130'),
(13, 'facebook_app_secret', '_53d21df8623ba691cd700f1ef34df9d0'),
(14, 'facebook_graph_version', 'v3.2'),
(15, 'enable_facebook', '0'),
(16, 'enable_google', '0');

-- --------------------------------------------------------

--
-- Table structure for table `tags`
--

CREATE TABLE `tags` (
  `id` int(11) NOT NULL,
  `post_id` int(11) DEFAULT NULL,
  `tag` varchar(255) DEFAULT NULL,
  `tag_slug` varchar(255) DEFAULT NULL,
  `created_at` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `testimonials`
--

CREATE TABLE `testimonials` (
  `id` int(11) NOT NULL,
  `lang_id` int(11) DEFAULT '1',
  `user_id` int(11) NOT NULL,
  `business_id` varchar(255) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `designation` varchar(255) DEFAULT NULL,
  `feedback` text,
  `image` varchar(255) DEFAULT NULL,
  `thumb` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `time_zone`
--

CREATE TABLE `time_zone` (
  `id` int(10) NOT NULL,
  `name` varchar(35) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `time_zone`
--

INSERT INTO `time_zone` (`id`, `name`) VALUES
(1, 'Europe/Andorra'),
(2, 'Asia/Dubai'),
(3, 'Asia/Kabul'),
(4, 'America/Antigua'),
(5, 'America/Anguilla'),
(6, 'Europe/Tirane'),
(7, 'Asia/Yerevan'),
(8, 'Africa/Luanda'),
(9, 'Antarctica/McMurdo'),
(10, 'Antarctica/Casey'),
(11, 'Antarctica/Davis'),
(12, 'Antarctica/DumontDUrville'),
(13, 'Antarctica/Mawson'),
(14, 'Antarctica/Palmer'),
(15, 'Antarctica/Rothera'),
(16, 'Antarctica/Syowa'),
(17, 'Antarctica/Troll'),
(18, 'Antarctica/Vostok'),
(19, 'America/Argentina/Buenos_Aires'),
(20, 'America/Argentina/Cordoba'),
(21, 'America/Argentina/Salta'),
(22, 'America/Argentina/Jujuy'),
(23, 'America/Argentina/Tucuman'),
(24, 'America/Argentina/Catamarca'),
(25, 'America/Argentina/La_Rioja'),
(26, 'America/Argentina/San_Juan'),
(27, 'America/Argentina/Mendoza'),
(28, 'America/Argentina/San_Luis'),
(29, 'America/Argentina/Rio_Gallegos'),
(30, 'America/Argentina/Ushuaia'),
(31, 'Pacific/Pago_Pago'),
(32, 'Europe/Vienna'),
(33, 'Australia/Lord_Howe'),
(34, 'Antarctica/Macquarie'),
(35, 'Australia/Hobart'),
(36, 'Australia/Currie'),
(37, 'Australia/Melbourne'),
(38, 'Australia/Sydney'),
(39, 'Australia/Broken_Hill'),
(40, 'Australia/Brisbane'),
(41, 'Australia/Lindeman'),
(42, 'Australia/Adelaide'),
(43, 'Australia/Darwin'),
(44, 'Australia/Perth'),
(45, 'Australia/Eucla'),
(46, 'America/Aruba'),
(47, 'Europe/Mariehamn'),
(48, 'Asia/Baku'),
(49, 'Europe/Sarajevo'),
(50, 'America/Barbados'),
(51, 'Asia/Dhaka'),
(52, 'Europe/Brussels'),
(53, 'Africa/Ouagadougou'),
(54, 'Europe/Sofia'),
(55, 'Asia/Bahrain'),
(56, 'Africa/Bujumbura'),
(57, 'Africa/Porto-Novo'),
(58, 'America/St_Barthelemy'),
(59, 'Atlantic/Bermuda'),
(60, 'Asia/Brunei'),
(61, 'America/La_Paz'),
(62, 'America/Kralendijk'),
(63, 'America/Noronha'),
(64, 'America/Belem'),
(65, 'America/Fortaleza'),
(66, 'America/Recife'),
(67, 'America/Araguaina'),
(68, 'America/Maceio'),
(69, 'America/Bahia'),
(70, 'America/Sao_Paulo'),
(71, 'America/Campo_Grande'),
(72, 'America/Cuiaba'),
(73, 'America/Santarem'),
(74, 'America/Porto_Velho'),
(75, 'America/Boa_Vista'),
(76, 'America/Manaus'),
(77, 'America/Eirunepe'),
(78, 'America/Rio_Branco'),
(79, 'America/Nassau'),
(80, 'Asia/Thimphu'),
(81, 'Africa/Gaborone'),
(82, 'Europe/Minsk'),
(83, 'America/Belize'),
(84, 'America/St_Johns'),
(85, 'America/Halifax'),
(86, 'America/Glace_Bay'),
(87, 'America/Moncton'),
(88, 'America/Goose_Bay'),
(89, 'America/Blanc-Sablon'),
(90, 'America/Toronto'),
(91, 'America/Nipigon'),
(92, 'America/Thunder_Bay'),
(93, 'America/Iqaluit'),
(94, 'America/Pangnirtung'),
(95, 'America/Atikokan'),
(96, 'America/Winnipeg'),
(97, 'America/Rainy_River'),
(98, 'America/Resolute'),
(99, 'America/Rankin_Inlet'),
(100, 'America/Regina'),
(101, 'America/Swift_Current'),
(102, 'America/Edmonton'),
(103, 'America/Cambridge_Bay'),
(104, 'America/Yellowknife'),
(105, 'America/Inuvik'),
(106, 'America/Creston'),
(107, 'America/Dawson_Creek'),
(108, 'America/Fort_Nelson'),
(109, 'America/Vancouver'),
(110, 'America/Whitehorse'),
(111, 'America/Dawson'),
(112, 'Indian/Cocos'),
(113, 'Africa/Kinshasa'),
(114, 'Africa/Lubumbashi'),
(115, 'Africa/Bangui'),
(116, 'Africa/Brazzaville'),
(117, 'Europe/Zurich'),
(118, 'Africa/Abidjan'),
(119, 'Pacific/Rarotonga'),
(120, 'America/Santiago'),
(121, 'America/Punta_Arenas'),
(122, 'Pacific/Easter'),
(123, 'Africa/Douala'),
(124, 'Asia/Shanghai'),
(125, 'Asia/Urumqi'),
(126, 'America/Bogota'),
(127, 'America/Costa_Rica'),
(128, 'America/Havana'),
(129, 'Atlantic/Cape_Verde'),
(130, 'America/Curacao'),
(131, 'Indian/Christmas'),
(132, 'Asia/Nicosia'),
(133, 'Asia/Famagusta'),
(134, 'Europe/Prague'),
(135, 'Europe/Berlin'),
(136, 'Europe/Busingen'),
(137, 'Africa/Djibouti'),
(138, 'Europe/Copenhagen'),
(139, 'America/Dominica'),
(140, 'America/Santo_Domingo'),
(141, 'Africa/Algiers'),
(142, 'America/Guayaquil'),
(143, 'Pacific/Galapagos'),
(144, 'Europe/Tallinn'),
(145, 'Africa/Cairo'),
(146, 'Africa/El_Aaiun'),
(147, 'Africa/Asmara'),
(148, 'Europe/Madrid'),
(149, 'Africa/Ceuta'),
(150, 'Atlantic/Canary'),
(151, 'Africa/Addis_Ababa'),
(152, 'Europe/Helsinki'),
(153, 'Pacific/Fiji'),
(154, 'Atlantic/Stanley'),
(155, 'Pacific/Chuuk'),
(156, 'Pacific/Pohnpei'),
(157, 'Pacific/Kosrae'),
(158, 'Atlantic/Faroe'),
(159, 'Europe/Paris'),
(160, 'Africa/Libreville'),
(161, 'Europe/London'),
(162, 'America/Grenada'),
(163, 'Asia/Tbilisi'),
(164, 'America/Cayenne'),
(165, 'Europe/Guernsey'),
(166, 'Africa/Accra'),
(167, 'Europe/Gibraltar'),
(168, 'America/Nuuk'),
(169, 'America/Danmarkshavn'),
(170, 'America/Scoresbysund'),
(171, 'America/Thule'),
(172, 'Africa/Banjul'),
(173, 'Africa/Conakry'),
(174, 'America/Guadeloupe'),
(175, 'Africa/Malabo'),
(176, 'Europe/Athens'),
(177, 'Atlantic/South_Georgia'),
(178, 'America/Guatemala'),
(179, 'Pacific/Guam'),
(180, 'Africa/Bissau'),
(181, 'America/Guyana'),
(182, 'Asia/Hong_Kong'),
(183, 'America/Tegucigalpa'),
(184, 'Europe/Zagreb'),
(185, 'America/Port-au-Prince'),
(186, 'Europe/Budapest'),
(187, 'Asia/Jakarta'),
(188, 'Asia/Pontianak'),
(189, 'Asia/Makassar'),
(190, 'Asia/Jayapura'),
(191, 'Europe/Dublin'),
(192, 'Asia/Jerusalem'),
(193, 'Europe/Isle_of_Man'),
(194, 'Asia/Kolkata'),
(195, 'Indian/Chagos'),
(196, 'Asia/Baghdad'),
(197, 'Asia/Tehran'),
(198, 'Atlantic/Reykjavik'),
(199, 'Europe/Rome'),
(200, 'Europe/Jersey'),
(201, 'America/Jamaica'),
(202, 'Asia/Amman'),
(203, 'Asia/Tokyo'),
(204, 'Africa/Nairobi'),
(205, 'Asia/Bishkek'),
(206, 'Asia/Phnom_Penh'),
(207, 'Pacific/Tarawa'),
(208, 'Pacific/Enderbury'),
(209, 'Pacific/Kiritimati'),
(210, 'Indian/Comoro'),
(211, 'America/St_Kitts'),
(212, 'Asia/Pyongyang'),
(213, 'Asia/Seoul'),
(214, 'Asia/Kuwait'),
(215, 'America/Cayman'),
(216, 'Asia/Almaty'),
(217, 'Asia/Qyzylorda'),
(218, 'Asia/Qostanay'),
(219, 'Asia/Aqtobe'),
(220, 'Asia/Aqtau'),
(221, 'Asia/Atyrau'),
(222, 'Asia/Oral'),
(223, 'Asia/Vientiane'),
(224, 'Asia/Beirut'),
(225, 'America/St_Lucia'),
(226, 'Europe/Vaduz'),
(227, 'Asia/Colombo'),
(228, 'Africa/Monrovia'),
(229, 'Africa/Maseru'),
(230, 'Europe/Vilnius'),
(231, 'Europe/Luxembourg'),
(232, 'Europe/Riga'),
(233, 'Africa/Tripoli'),
(234, 'Africa/Casablanca'),
(235, 'Europe/Monaco'),
(236, 'Europe/Chisinau'),
(237, 'Europe/Podgorica'),
(238, 'America/Marigot'),
(239, 'Indian/Antananarivo'),
(240, 'Pacific/Majuro'),
(241, 'Pacific/Kwajalein'),
(242, 'Europe/Skopje'),
(243, 'Africa/Bamako'),
(244, 'Asia/Yangon'),
(245, 'Asia/Ulaanbaatar'),
(246, 'Asia/Hovd'),
(247, 'Asia/Choibalsan'),
(248, 'Asia/Macau'),
(249, 'Pacific/Saipan'),
(250, 'America/Martinique'),
(251, 'Africa/Nouakchott'),
(252, 'America/Montserrat'),
(253, 'Europe/Malta'),
(254, 'Indian/Mauritius'),
(255, 'Indian/Maldives'),
(256, 'Africa/Blantyre'),
(257, 'America/Mexico_City'),
(258, 'America/Cancun'),
(259, 'America/Merida'),
(260, 'America/Monterrey'),
(261, 'America/Matamoros'),
(262, 'America/Mazatlan'),
(263, 'America/Chihuahua'),
(264, 'America/Ojinaga'),
(265, 'America/Hermosillo'),
(266, 'America/Tijuana'),
(267, 'America/Bahia_Banderas'),
(268, 'Asia/Kuala_Lumpur'),
(269, 'Asia/Kuching'),
(270, 'Africa/Maputo'),
(271, 'Africa/Windhoek'),
(272, 'Pacific/Noumea'),
(273, 'Africa/Niamey'),
(274, 'Pacific/Norfolk'),
(275, 'Africa/Lagos'),
(276, 'America/Managua'),
(277, 'Europe/Amsterdam'),
(278, 'Europe/Oslo'),
(279, 'Asia/Kathmandu'),
(280, 'Pacific/Nauru'),
(281, 'Pacific/Niue'),
(282, 'Pacific/Auckland'),
(283, 'Pacific/Chatham'),
(284, 'Asia/Muscat'),
(285, 'America/Panama'),
(286, 'America/Lima'),
(287, 'Pacific/Tahiti'),
(288, 'Pacific/Marquesas'),
(289, 'Pacific/Gambier'),
(290, 'Pacific/Port_Moresby'),
(291, 'Pacific/Bougainville'),
(292, 'Asia/Manila'),
(293, 'Asia/Karachi'),
(294, 'Europe/Warsaw'),
(295, 'America/Miquelon'),
(296, 'Pacific/Pitcairn'),
(297, 'America/Puerto_Rico'),
(298, 'Asia/Gaza'),
(299, 'Asia/Hebron'),
(300, 'Europe/Lisbon'),
(301, 'Atlantic/Madeira'),
(302, 'Atlantic/Azores'),
(303, 'Pacific/Palau'),
(304, 'America/Asuncion'),
(305, 'Asia/Qatar'),
(306, 'Indian/Reunion'),
(307, 'Europe/Bucharest'),
(308, 'Europe/Belgrade'),
(309, 'Europe/Kaliningrad'),
(310, 'Europe/Moscow'),
(311, 'Europe/Simferopol'),
(312, 'Europe/Kirov'),
(313, 'Europe/Astrakhan'),
(314, 'Europe/Volgograd'),
(315, 'Europe/Saratov'),
(316, 'Europe/Ulyanovsk'),
(317, 'Europe/Samara'),
(318, 'Asia/Yekaterinburg'),
(319, 'Asia/Omsk'),
(320, 'Asia/Novosibirsk'),
(321, 'Asia/Barnaul'),
(322, 'Asia/Tomsk'),
(323, 'Asia/Novokuznetsk'),
(324, 'Asia/Krasnoyarsk'),
(325, 'Asia/Irkutsk'),
(326, 'Asia/Chita'),
(327, 'Asia/Yakutsk'),
(328, 'Asia/Khandyga'),
(329, 'Asia/Vladivostok'),
(330, 'Asia/Ust-Nera'),
(331, 'Asia/Magadan'),
(332, 'Asia/Sakhalin'),
(333, 'Asia/Srednekolymsk'),
(334, 'Asia/Kamchatka'),
(335, 'Asia/Anadyr'),
(336, 'Africa/Kigali'),
(337, 'Asia/Riyadh'),
(338, 'Pacific/Guadalcanal'),
(339, 'Indian/Mahe'),
(340, 'Africa/Khartoum'),
(341, 'Europe/Stockholm'),
(342, 'Asia/Singapore'),
(343, 'Atlantic/St_Helena'),
(344, 'Europe/Ljubljana'),
(345, 'Arctic/Longyearbyen'),
(346, 'Europe/Bratislava'),
(347, 'Africa/Freetown'),
(348, 'Europe/San_Marino'),
(349, 'Africa/Dakar'),
(350, 'Africa/Mogadishu'),
(351, 'America/Paramaribo'),
(352, 'Africa/Juba'),
(353, 'Africa/Sao_Tome'),
(354, 'America/El_Salvador'),
(355, 'America/Lower_Princes'),
(356, 'Asia/Damascus'),
(357, 'Africa/Mbabane'),
(358, 'America/Grand_Turk'),
(359, 'Africa/Ndjamena'),
(360, 'Indian/Kerguelen'),
(361, 'Africa/Lome'),
(362, 'Asia/Bangkok'),
(363, 'Asia/Dushanbe'),
(364, 'Pacific/Fakaofo'),
(365, 'Asia/Dili'),
(366, 'Asia/Ashgabat'),
(367, 'Africa/Tunis'),
(368, 'Pacific/Tongatapu'),
(369, 'Europe/Istanbul'),
(370, 'America/Port_of_Spain'),
(371, 'Pacific/Funafuti'),
(372, 'Asia/Taipei'),
(373, 'Africa/Dar_es_Salaam'),
(374, 'Europe/Kiev'),
(375, 'Europe/Uzhgorod'),
(376, 'Europe/Zaporozhye'),
(377, 'Africa/Kampala'),
(378, 'Pacific/Midway'),
(379, 'Pacific/Wake'),
(380, 'America/New_York'),
(381, 'America/Detroit'),
(382, 'America/Kentucky/Louisville'),
(383, 'America/Kentucky/Monticello'),
(384, 'America/Indiana/Indianapolis'),
(385, 'America/Indiana/Vincennes'),
(386, 'America/Indiana/Winamac'),
(387, 'America/Indiana/Marengo'),
(388, 'America/Indiana/Petersburg'),
(389, 'America/Indiana/Vevay'),
(390, 'America/Chicago'),
(391, 'America/Indiana/Tell_City'),
(392, 'America/Indiana/Knox'),
(393, 'America/Menominee'),
(394, 'America/North_Dakota/Center'),
(395, 'America/North_Dakota/New_Salem'),
(396, 'America/North_Dakota/Beulah'),
(397, 'America/Denver'),
(398, 'America/Boise'),
(399, 'America/Phoenix'),
(400, 'America/Los_Angeles'),
(401, 'America/Anchorage'),
(402, 'America/Juneau'),
(403, 'America/Sitka'),
(404, 'America/Metlakatla'),
(405, 'America/Yakutat'),
(406, 'America/Nome'),
(407, 'America/Adak'),
(408, 'Pacific/Honolulu'),
(409, 'America/Montevideo'),
(410, 'Asia/Samarkand'),
(411, 'Asia/Tashkent'),
(412, 'Europe/Vatican'),
(413, 'America/St_Vincent'),
(414, 'America/Caracas'),
(415, 'America/Tortola'),
(416, 'America/St_Thomas'),
(417, 'Asia/Ho_Chi_Minh'),
(418, 'Pacific/Efate'),
(419, 'Pacific/Wallis'),
(420, 'Pacific/Apia'),
(421, 'Asia/Aden'),
(422, 'Indian/Mayotte'),
(423, 'Africa/Johannesburg'),
(424, 'Africa/Lusaka'),
(425, 'Africa/Harare');

-- --------------------------------------------------------

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` int(11) NOT NULL,
  `parent_id` int(11) NOT NULL,
  `auth_type` varchar(20) DEFAULT NULL,
  `auth_id` varchar(30) DEFAULT NULL,
  `device_1` text,
  `device_2` text,
  `name` varchar(255) DEFAULT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `balance` bigint(20) DEFAULT '0',
  `total_sales` bigint(20) DEFAULT '0',
  `email` varchar(255) DEFAULT NULL,
  `user_name` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `role` varchar(100) DEFAULT 'user',
  `referral_id` varchar(155) DEFAULT NULL,
  `referral_earn` varchar(155) DEFAULT '0',
  `account_type` varchar(255) DEFAULT NULL,
  `user_type` varchar(100) DEFAULT 'registered',
  `trial_expire` date DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `address` text,
  `email_verified` int(11) DEFAULT '0',
  `verify_code` varchar(255) DEFAULT NULL,
  `phone_verified` varchar(255) NOT NULL DEFAULT '0',
  `sms_count` varchar(255) NOT NULL DEFAULT '0',
  `image` varchar(255) DEFAULT NULL,
  `thumb` varchar(255) DEFAULT NULL,
  `paypal_payment` int(11) DEFAULT '1',
  `stripe_payment` int(11) DEFAULT '1',
  `paypal_email` varchar(255) DEFAULT NULL,
  `publish_key` varchar(255) DEFAULT NULL,
  `secret_key` varchar(255) DEFAULT NULL,
  `paystack_payment` varchar(155) DEFAULT '0',
  `paystack_secret_key` varchar(255) DEFAULT NULL,
  `paystack_public_key` varchar(255) DEFAULT NULL,
  `razorpay_payment` varchar(155) DEFAULT '0',
  `razorpay_key_id` varchar(255) DEFAULT NULL,
  `razorpay_key_secret` varchar(255) DEFAULT NULL,
  `mercado_payment` int(11) DEFAULT '0',
  `mercado_currency` varchar(155) DEFAULT NULL,
  `mercado_api_key` varchar(255) DEFAULT NULL,
  `mercado_token` varchar(255) DEFAULT NULL,
  `flutterwave_payment` int(11) DEFAULT '0',
  `flutterwave_public_key` varchar(255) DEFAULT NULL,
  `flutterwave_secret_key` varchar(255) DEFAULT NULL,
  `offline_details` text,
  `enable_offline_payment` int(11) DEFAULT '0',
  `status` int(11) DEFAULT '0',
  `country` int(11) DEFAULT NULL,
  `currency` varchar(255) DEFAULT 'USD',
  `paypal_mode` varchar(255) DEFAULT 'live',
  `about_me` varchar(5000) DEFAULT NULL,
  `available_days` varchar(255) DEFAULT NULL,
  `google_analytics` text,
  `enable_appointment` int(11) DEFAULT '1',
  `enable_rating` int(11) DEFAULT '1',
  `twillo_account_sid` varchar(255) DEFAULT NULL,
  `twillo_auth_token` varchar(255) DEFAULT NULL,
  `twillo_number` varchar(255) DEFAULT NULL,
  `enable_sms_notify` varchar(255) DEFAULT '0',
  `enable_sms_alert` varchar(255) DEFAULT '0',
  `remember_me_token` varchar(155) DEFAULT NULL,
  `date_format` varchar(255) DEFAULT 'd M Y',
  `created_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `users_payout_accounts`
--

CREATE TABLE `users_payout_accounts` (
  `id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `payout_paypal_email` varchar(255) DEFAULT NULL,
  `payout_bank_info` mediumtext,
  `iban_full_name` varchar(255) DEFAULT NULL,
  `iban_country_id` varchar(20) DEFAULT NULL,
  `iban_bank_name` varchar(255) DEFAULT NULL,
  `iban_number` varchar(500) DEFAULT NULL,
  `swift_full_name` varchar(255) DEFAULT NULL,
  `swift_address` varchar(500) DEFAULT NULL,
  `swift_state` varchar(255) DEFAULT NULL,
  `swift_city` varchar(255) DEFAULT NULL,
  `swift_postcode` varchar(100) DEFAULT NULL,
  `swift_country_id` varchar(20) DEFAULT NULL,
  `swift_bank_account_holder_name` varchar(255) DEFAULT NULL,
  `swift_iban` varchar(255) DEFAULT NULL,
  `swift_code` varchar(255) DEFAULT NULL,
  `swift_bank_name` varchar(255) DEFAULT NULL,
  `swift_bank_branch_city` varchar(255) DEFAULT NULL,
  `swift_bank_branch_country_id` varchar(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `working_days`
--

CREATE TABLE `working_days` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `staff_id` varchar(155) DEFAULT '0',
  `business_id` varchar(25) DEFAULT '0',
  `day` int(11) DEFAULT NULL,
  `start` varchar(255) DEFAULT NULL,
  `end` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `working_time`
--

CREATE TABLE `working_time` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `business_id` varchar(25) DEFAULT '0',
  `day_id` int(11) NOT NULL,
  `time` varchar(255) DEFAULT NULL,
  `start` varchar(255) DEFAULT NULL,
  `end` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `appointments`
--
ALTER TABLE `appointments`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `blog_category`
--
ALTER TABLE `blog_category`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `blog_posts`
--
ALTER TABLE `blog_posts`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `booking_val`
--
ALTER TABLE `booking_val`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `brands`
--
ALTER TABLE `brands`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `business`
--
ALTER TABLE `business`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `categories`
--
ALTER TABLE `categories`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `comments`
--
ALTER TABLE `comments`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `contacts`
--
ALTER TABLE `contacts`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `country`
--
ALTER TABLE `country`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `code` (`code`);

--
-- Indexes for table `coupons`
--
ALTER TABLE `coupons`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `coupons_apply`
--
ALTER TABLE `coupons_apply`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `customers`
--
ALTER TABLE `customers`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `custom_form`
--
ALTER TABLE `custom_form`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `custom_form_answer`
--
ALTER TABLE `custom_form_answer`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `dialing_codes`
--
ALTER TABLE `dialing_codes`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `domains`
--
ALTER TABLE `domains`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `domain_settings`
--
ALTER TABLE `domain_settings`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `events`
--
ALTER TABLE `events`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `event_booking`
--
ALTER TABLE `event_booking`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `event_category`
--
ALTER TABLE `event_category`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `event_ticket`
--
ALTER TABLE `event_ticket`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `event_venue`
--
ALTER TABLE `event_venue`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `faqs`
--
ALTER TABLE `faqs`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `features`
--
ALTER TABLE `features`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `feature_assaign`
--
ALTER TABLE `feature_assaign`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `fonts`
--
ALTER TABLE `fonts`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `gallery`
--
ALTER TABLE `gallery`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `language`
--
ALTER TABLE `language`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `lang_values`
--
ALTER TABLE `lang_values`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `locations`
--
ALTER TABLE `locations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `package`
--
ALTER TABLE `package`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `pages`
--
ALTER TABLE `pages`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `payment`
--
ALTER TABLE `payment`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `payment_user`
--
ALTER TABLE `payment_user`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `payment_user_event`
--
ALTER TABLE `payment_user_event`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `payouts`
--
ALTER TABLE `payouts`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `plan_coupons`
--
ALTER TABLE `plan_coupons`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `plan_coupons_apply`
--
ALTER TABLE `plan_coupons_apply`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `portfolios`
--
ALTER TABLE `portfolios`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `product_services`
--
ALTER TABLE `product_services`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `ratings`
--
ALTER TABLE `ratings`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `referrals`
--
ALTER TABLE `referrals`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `referral_payouts`
--
ALTER TABLE `referral_payouts`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `referral_settings`
--
ALTER TABLE `referral_settings`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `services`
--
ALTER TABLE `services`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `service_category`
--
ALTER TABLE `service_category`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `service_extra`
--
ALTER TABLE `service_extra`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `settings_extra`
--
ALTER TABLE `settings_extra`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `site_contacts`
--
ALTER TABLE `site_contacts`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `sliders`
--
ALTER TABLE `sliders`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `staffs`
--
ALTER TABLE `staffs`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `staff_locations`
--
ALTER TABLE `staff_locations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `system_settings`
--
ALTER TABLE `system_settings`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tags`
--
ALTER TABLE `tags`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `testimonials`
--
ALTER TABLE `testimonials`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `time_zone`
--
ALTER TABLE `time_zone`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_zone_name` (`name`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `users_payout_accounts`
--
ALTER TABLE `users_payout_accounts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_user_id` (`user_id`);

--
-- Indexes for table `working_days`
--
ALTER TABLE `working_days`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `working_time`
--
ALTER TABLE `working_time`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `appointments`
--
ALTER TABLE `appointments`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `blog_category`
--
ALTER TABLE `blog_category`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `blog_posts`
--
ALTER TABLE `blog_posts`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `booking_val`
--
ALTER TABLE `booking_val`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `brands`
--
ALTER TABLE `brands`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `business`
--
ALTER TABLE `business`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `categories`
--
ALTER TABLE `categories`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `comments`
--
ALTER TABLE `comments`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `contacts`
--
ALTER TABLE `contacts`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `country`
--
ALTER TABLE `country`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=189;

--
-- AUTO_INCREMENT for table `coupons`
--
ALTER TABLE `coupons`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `coupons_apply`
--
ALTER TABLE `coupons_apply`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `customers`
--
ALTER TABLE `customers`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `custom_form`
--
ALTER TABLE `custom_form`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `custom_form_answer`
--
ALTER TABLE `custom_form_answer`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `dialing_codes`
--
ALTER TABLE `dialing_codes`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=250;

--
-- AUTO_INCREMENT for table `domains`
--
ALTER TABLE `domains`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `domain_settings`
--
ALTER TABLE `domain_settings`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `events`
--
ALTER TABLE `events`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `event_booking`
--
ALTER TABLE `event_booking`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `event_category`
--
ALTER TABLE `event_category`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `event_ticket`
--
ALTER TABLE `event_ticket`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `event_venue`
--
ALTER TABLE `event_venue`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `faqs`
--
ALTER TABLE `faqs`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `features`
--
ALTER TABLE `features`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `feature_assaign`
--
ALTER TABLE `feature_assaign`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=248;

--
-- AUTO_INCREMENT for table `fonts`
--
ALTER TABLE `fonts`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=61;

--
-- AUTO_INCREMENT for table `gallery`
--
ALTER TABLE `gallery`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `language`
--
ALTER TABLE `language`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `lang_values`
--
ALTER TABLE `lang_values`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1393;

--
-- AUTO_INCREMENT for table `locations`
--
ALTER TABLE `locations`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `package`
--
ALTER TABLE `package`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `pages`
--
ALTER TABLE `pages`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `payment`
--
ALTER TABLE `payment`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `payment_user`
--
ALTER TABLE `payment_user`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `payment_user_event`
--
ALTER TABLE `payment_user_event`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `payouts`
--
ALTER TABLE `payouts`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `plan_coupons`
--
ALTER TABLE `plan_coupons`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `plan_coupons_apply`
--
ALTER TABLE `plan_coupons_apply`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `portfolios`
--
ALTER TABLE `portfolios`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `product_services`
--
ALTER TABLE `product_services`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `ratings`
--
ALTER TABLE `ratings`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `referrals`
--
ALTER TABLE `referrals`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `referral_payouts`
--
ALTER TABLE `referral_payouts`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `referral_settings`
--
ALTER TABLE `referral_settings`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `services`
--
ALTER TABLE `services`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `service_category`
--
ALTER TABLE `service_category`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `service_extra`
--
ALTER TABLE `service_extra`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `settings_extra`
--
ALTER TABLE `settings_extra`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `site_contacts`
--
ALTER TABLE `site_contacts`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `sliders`
--
ALTER TABLE `sliders`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `staffs`
--
ALTER TABLE `staffs`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `staff_locations`
--
ALTER TABLE `staff_locations`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `system_settings`
--
ALTER TABLE `system_settings`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT for table `tags`
--
ALTER TABLE `tags`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `testimonials`
--
ALTER TABLE `testimonials`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `time_zone`
--
ALTER TABLE `time_zone`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=426;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `users_payout_accounts`
--
ALTER TABLE `users_payout_accounts`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `working_days`
--
ALTER TABLE `working_days`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `working_time`
--
ALTER TABLE `working_time`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
COMMIT;

