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

START TRANSACTION;



--
-- Database: `accufy_db_fresh`
--

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

--
-- Table structure for table `attendence`
--

CREATE TABLE `attendence` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `business_id` int(11) NOT NULL,
  `employee_id` int(11) NOT NULL,
  `date` varchar(255) NOT NULL,
  `check_in` varchar(255) NOT NULL,
  `check_out` varchar(255) NOT NULL,
  `note` text NOT NULL,
  `status` int(11) NOT NULL,
  `created_at` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

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

CREATE TABLE `blog_category` (
  `id` int(11) 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,
  `title` varchar(255) DEFAULT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `details` text,
  `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_home` int(11) NOT NULL DEFAULT '0',
  `is_featured` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT 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,
  `type` int(11) NOT NULL DEFAULT '1',
  `title` varchar(255) DEFAULT NULL,
  `biz_number` varchar(255) DEFAULT NULL,
  `vat_code` varchar(255) DEFAULT NULL,
  `country` int(11) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `address` mediumtext,
  `category` varchar(255) DEFAULT NULL,
  `business_type` int(11) DEFAULT NULL,
  `logo` varchar(255) DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT '0',
  `is_primary` int(11) DEFAULT NULL,
  `is_autoload_amount` int(11) NOT NULL,
  `enable_stock` int(11) DEFAULT '0',
  `enable_qrcode` varchar(155) DEFAULT '0',
  `template_style` int(11) NOT NULL DEFAULT '1',
  `color` varchar(255) NOT NULL DEFAULT '#546af1',
  `footer_note` text,
  `footer_note_align` varchar(155) DEFAULT 'left',
  `estimate_footer_note` mediumtext,
  `invoice_title` varchar(255) DEFAULT NULL,
  `invoice_summary` text,
  `estimate_title` varchar(255) DEFAULT NULL,
  `estimate_summary` text,
  `symbol_direction` varchar(155) DEFAULT 'left',
  `space_price_symbol` varchar(155) DEFAULT '0',
  `num_format` varchar(155) DEFAULT '2',
  `price_separator` varchar(155) DEFAULT '1',
  `default_check_in` varchar(155) DEFAULT NULL,
  `default_check_out` varchar(155) DEFAULT NULL,
  `enable_unit` varchar(155) DEFAULT '0',
  `units` longtext,
  `created_at` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `business_category`
--

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

--
-- Dumping data for table `business_category`
--

INSERT INTO `business_category` (`id`, `name`) VALUES
(1, 'Arts, crafts, and collectible'),
(2, 'Baby'),
(3, 'Beauty and fragrances'),
(4, 'Books and magazines'),
(5, 'Business to business'),
(6, 'Clothing, accessories, and shoes'),
(7, 'Web, Computers, accessories, and services'),
(8, 'Education'),
(9, 'Electronics and telecom'),
(10, 'Entertainment and media'),
(11, 'Financial services and products'),
(12, 'Food retail and service'),
(13, 'Gifts and flowers'),
(14, 'Government'),
(15, 'Health and personal care'),
(16, 'Home and garden'),
(17, 'Nonprofit'),
(18, 'Pets and animals'),
(19, 'Religion and spirituality (for profit)'),
(20, 'Retail (not elsewhere classified)'),
(21, 'Services - other'),
(22, 'Sports and outdoors'),
(23, 'Toys and hobbies'),
(24, 'Travel'),
(25, 'Vehicle sales'),
(26, 'Vehicle service and accessories');

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

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

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

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

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

CREATE TABLE `comments` (
  `id` int(11) NOT NULL,
  `post_id` int(11) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `message` text,
  `created_at` varchar(255) DEFAULT 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,
  `name` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `message` text,
  `created_at` varchar(255) DEFAULT 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,
  `user_id` int(11) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

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

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

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

CREATE TABLE `customers` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `business_id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `thumb` varchar(255) DEFAULT NULL,
  `address` mediumtext,
  `country` int(11) DEFAULT NULL,
  `currency` varchar(255) DEFAULT NULL,
  `cus_number` varchar(255) DEFAULT NULL,
  `vat_code` varchar(255) DEFAULT NULL,
  `city` varchar(11) DEFAULT NULL,
  `postal_code` varchar(11) DEFAULT NULL,
  `address1` mediumtext,
  `address2` mediumtext,
  `status` int(11) NOT NULL,
  `created_at` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `departments`
--

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

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

--
-- Table structure for table `employees`
--

CREATE TABLE `employees` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `business_id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `department_id` int(11) NOT NULL,
  `email` varchar(255) NOT NULL,
  `phone` varchar(255) NOT NULL,
  `address` varchar(255) NOT NULL,
  `city` varchar(255) NOT NULL,
  `country` varchar(255) NOT NULL,
  `image` varchar(255) DEFAULT NULL,
  `thumb` varchar(255) DEFAULT NULL,
  `status` int(11) NOT NULL,
  `created_at` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `expenses`
--

CREATE TABLE `expenses` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `business_id` int(11) NOT NULL,
  `category` int(11) DEFAULT NULL,
  `vendor` int(11) DEFAULT NULL,
  `amount` decimal(10,2) DEFAULT NULL,
  `net_amount` decimal(10,2) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `notes` mediumtext,
  `tax` int(11) DEFAULT NULL,
  `file` varchar(255) DEFAULT NULL,
  `created_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

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

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

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

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

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

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

--
-- Table structure for table `google_fonts`
--

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

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

--
-- Table structure for table `invoice`
--

CREATE TABLE `invoice` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `business_id` int(11) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `type` int(11) DEFAULT '1' COMMENT 'invoice = 1 & estimates = 2',
  `recurring` int(11) DEFAULT '0',
  `parent_id` int(11) DEFAULT NULL,
  `summary` varchar(255) DEFAULT NULL,
  `number` varchar(255) DEFAULT NULL,
  `poso_number` varchar(255) DEFAULT NULL,
  `customer` int(11) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `discount` int(11) DEFAULT NULL,
  `payment_due` date DEFAULT NULL,
  `expire_on` date DEFAULT NULL,
  `due_limit` int(11) DEFAULT NULL,
  `footer_note` mediumtext,
  `sub_total` decimal(10,2) DEFAULT NULL,
  `grand_total` decimal(10,2) DEFAULT NULL,
  `convert_total` decimal(10,2) DEFAULT NULL,
  `status` int(11) DEFAULT '0',
  `qr_code` text,
  `reject_reason` text,
  `client_action_date` date DEFAULT NULL,
  `is_sent` int(11) DEFAULT '0',
  `is_completed` int(11) NOT NULL DEFAULT '0',
  `sent_date` datetime DEFAULT NULL,
  `recurring_start` date DEFAULT NULL,
  `recurring_end` date DEFAULT NULL,
  `frequency` varchar(255) DEFAULT NULL,
  `next_payment` date DEFAULT NULL,
  `frequency_count` int(11) NOT NULL DEFAULT '0',
  `is_view` int(11) DEFAULT NULL,
  `view_date` datetime DEFAULT NULL,
  `auto_send` int(11) DEFAULT '0',
  `send_myself` int(11) DEFAULT NULL,
  `created_at` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `invoice_items`
--

CREATE TABLE `invoice_items` (
  `id` int(11) NOT NULL,
  `invoice_id` int(11) NOT NULL,
  `item` int(11) DEFAULT NULL,
  `details` text,
  `qty` varchar(155) DEFAULT NULL,
  `price` decimal(10,2) DEFAULT NULL,
  `total` decimal(10,2) DEFAULT NULL,
  `type` varchar(155) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `invoice_payment_record`
--

CREATE TABLE `invoice_payment_record` (
  `id` int(11) NOT NULL,
  `invoice_id` int(11) NOT NULL,
  `amount` decimal(10,2) DEFAULT NULL,
  `payment_date` date DEFAULT NULL,
  `payment_method` varchar(255) DEFAULT NULL,
  `notes` text,
  `created_at` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `invoice_taxes`
--

CREATE TABLE `invoice_taxes` (
  `id` int(11) NOT NULL,
  `invoice_id` int(11) NOT NULL,
  `tax_id` int(11) NOT NULL
) 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;




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

--
-- 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,
  `bill_type` varchar(255) DEFAULT NULL,
  `dis_month` int(11) NOT NULL DEFAULT '0',
  `dis_year` int(11) NOT NULL DEFAULT '0',
  `is_special` int(11) NOT NULL DEFAULT '0',
  `is_active` int(11) DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

INSERT INTO `package` (`id`, `name`, `slug`, `price`, `monthly_price`, `bill_type`, `dis_month`, `dis_year`, `is_special`, `is_active`) VALUES
(1, 'Basic', 'basic', '20.00', '0.00', 'year', 10, 5, 0, 1),
(2, 'Standard', 'standared', '35.00', '15.00', 'year', 20, 10, 1, 1),
(3, 'Premium', 'premium', '1000.00', '30.00', 'year', 50, 30, 0, 1);

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

--
-- Table structure for table `package_features`
--

CREATE TABLE `package_features` (
  `id` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `slug` varchar(255) NOT NULL,
  `basic` varchar(255) DEFAULT NULL,
  `standared` varchar(255) DEFAULT NULL,
  `premium` varchar(255) DEFAULT NULL,
  `year_basic` int(11) DEFAULT NULL,
  `year_standared` int(11) DEFAULT NULL,
  `year_premium` int(11) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `text` text
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `package_features`
--

INSERT INTO `package_features` (`id`, `name`, `slug`, `basic`, `standared`, `premium`, `year_basic`, `year_standared`, `year_premium`, `type`, `text`) VALUES
(1, 'Invoices', 'invoice', '-2', '-2', '-2', -2, -2, -2, '', NULL),
(2, 'Estimates', 'estimate', '2', '40', '100', 100, 200, 2, '', NULL),
(3, 'Customers', 'customer', '2', '20', '50', 20, 70, 2, '', NULL),
(4, 'Business', 'business', '1', '5', '10', 10, 25, 50, '', ''),
(5, 'Invoice templates', 'invoice_template', '-2', '8', '8', 8, 8, 8, '', 'Set value 1-8'),
(6, 'Get Invoice Payment Online', 'invoice-payments', '-1', '-1', '-1', 0, -1, -1, '', 'Set -1 for Yes & 0 for No'),
(7, 'Multi User Roles', 'user-roles', '4', '4', '12', 10, 20, 30, '', NULL),
(8, 'HRM', 'hrm', '-1', '-1', '-1', -1, -1, -1, '', NULL);

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

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

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

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

--
-- 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` varchar(255) DEFAULT NULL,
  `billing_type` varchar(255) DEFAULT NULL,
  `payment_type` varchar(255) DEFAULT NULL,
  `txn_id` 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
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `payment_advance`
--

CREATE TABLE `payment_advance` (
  `id` int(11) NOT NULL,
  `business_id` int(11) NOT NULL,
  `customer_id` int(11) NOT NULL,
  `amount` decimal(10,0) NOT NULL,
  `created_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `payment_records`
--

CREATE TABLE `payment_records` (
  `id` int(11) NOT NULL,
  `invoice_id` int(11) NOT NULL,
  `business_id` varchar(255) NOT NULL,
  `customer_id` int(11) NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `convert_amount` decimal(10,2) DEFAULT NULL,
  `payment_date` date NOT NULL,
  `payment_method` int(11) DEFAULT NULL,
  `note` mediumtext,
  `type` varchar(255) DEFAULT 'income',
  `created_at` varchar(255) DEFAULT 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,
  `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 `products`
--

CREATE TABLE `products` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `business_id` int(11) NOT NULL,
  `quantity` int(11) NOT NULL,
  `unit` varchar(155) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `price` decimal(10,2) NOT NULL,
  `details` text,
  `is_sell` int(11) DEFAULT NULL,
  `is_buy` int(11) DEFAULT NULL,
  `income_category` int(11) DEFAULT NULL,
  `expense_category` int(11) DEFAULT 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,
  `name` varchar(255) DEFAULT NULL,
  `details` text,
  `image` varchar(255) DEFAULT NULL,
  `thumb` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `product_tax`
--

CREATE TABLE `product_tax` (
  `id` int(11) NOT NULL,
  `product_id` int(11) DEFAULT NULL,
  `tax_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `rates`
--

CREATE TABLE `rates` (
  `id` int(11) NOT NULL,
  `code` varchar(255) DEFAULT NULL,
  `rate` varchar(255) DEFAULT NULL,
  `date` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `rates`
--

INSERT INTO `rates` (`id`, `code`, `rate`, `date`) VALUES
(1, 'AED', '3.6732', '2020-06-14'),
(2, 'AFN', '77.59138', '2020-06-14'),
(3, 'ALL', '110.8155', '2020-06-14'),
(4, 'AMD', '481.814', '2020-06-14'),
(5, 'AOA', '600.099', '2020-06-14'),
(6, 'ARS', '69.38714', '2020-06-14'),
(7, 'AUD', '1.45934', '2020-06-14'),
(8, 'AWG', '1.8', '2020-06-14'),
(9, 'AZN', '1.7', '2020-06-14'),
(10, 'BBD', '2.01949', '2020-06-14'),
(11, 'BDT', '84.95716', '2020-06-14'),
(12, 'BGN', '1.73798', '2020-06-14'),
(13, 'BHD', '0.37708', '2020-06-14'),
(14, 'BIF', '1910.1', '2020-06-14'),
(15, 'BMD', '1', '2020-06-14'),
(16, 'BND', '1.39063', '2020-06-14'),
(17, 'BRL', '5.04955', '2020-06-14'),
(18, 'BTN', '', '2020-06-14'),
(19, 'BWP', '11.6776', '2020-06-14'),
(20, 'BYR', '', '2020-06-14'),
(21, 'BZD', '2.01612', '2020-06-14'),
(22, 'CAD', '1.3587', '2020-06-14'),
(23, 'CHF', '0.95193', '2020-06-14'),
(24, 'CLP', '791.83', '2020-06-14'),
(25, 'CNY', '7.0733', '2020-06-14'),
(26, 'COP', '3776.69', '2020-06-14'),
(27, 'CRC', '579.11026', '2020-06-14'),
(28, 'CUC', '1', '2020-06-14'),
(29, 'CVE', '98.405', '2020-06-14'),
(30, 'CZK', '23.75794', '2020-06-14'),
(31, 'DJF', '177.729', '2020-06-14'),
(32, 'DKK', '6.6203', '2020-06-14'),
(33, 'DOP', '58.405', '2020-06-14'),
(34, 'DZD', '128.51363', '2020-06-14'),
(35, 'EGP', '16.18149', '2020-06-14'),
(36, 'ERN', '', '2020-06-14'),
(37, 'ETB', '34.4', '2020-06-14'),
(38, 'EUR', '0.88851', '2020-06-14'),
(39, 'FJD', '2.1951', '2020-06-14'),
(40, 'GBP', '0.7972', '2020-06-14'),
(41, 'GEL', '3.05', '2020-06-14'),
(42, 'GHS', '5.7805', '2020-06-14'),
(43, 'GIP', '0.7972', '2020-06-14'),
(44, 'GNF', '9460.45', '2020-06-14'),
(45, 'GTQ', '7.69408', '2020-06-14'),
(46, 'GYD', '209.43027', '2020-06-14'),
(47, 'HKD', '7.7498', '2020-06-14'),
(48, 'HNL', '24.941', '2020-06-14'),
(49, 'HRK', '6.72254', '2020-06-14'),
(50, 'HTG', '107.76859', '2020-06-14'),
(51, 'HUF', '307.54', '2020-06-14'),
(52, 'IDR', '14217.361', '2020-06-14'),
(53, 'ILS', '3.4619', '2020-06-14'),
(54, 'INR', '75.9608', '2020-06-14'),
(55, 'IQD', '1190.05', '2020-06-14'),
(56, 'ISK', '135.127', '2020-06-14'),
(57, 'JMD', '140.52593', '2020-06-14'),
(58, 'JOD', '0.70905', '2020-06-14'),
(59, 'JPY', '107.349', '2020-06-14'),
(60, 'KES', '106.46093', '2020-06-14'),
(61, 'KGS', '74.78584', '2020-06-14'),
(62, 'KHR', '4091.2', '2020-06-14'),
(63, 'KMF', '437.872', '2020-06-14'),
(64, 'KWD', '0.30797', '2020-06-14'),
(65, 'KYD', '0.83348', '2020-06-14'),
(66, 'KZT', '404.31862', '2020-06-14'),
(67, 'LAK', '9010.45', '2020-06-14'),
(68, 'LBP', '1511.43755', '2020-06-14'),
(69, 'LKR', '185.37567', '2020-06-14'),
(70, 'LRD', '199.26', '2020-06-14'),
(71, 'LSL', '17.1', '2020-06-14'),
(72, 'MAD', '9.6755', '2020-06-14'),
(73, 'MDL', '17.17804', '2020-06-14'),
(74, 'MGA', '', '2020-06-14'),
(75, 'MMK', '1400.194', '2020-06-14'),
(76, 'MNT', '', '2020-06-14'),
(77, 'MRO', '', '2020-06-14'),
(78, 'MUR', '39.70737', '2020-06-14'),
(79, 'MVR', '15.5', '2020-06-14'),
(80, 'MWK', '740.05', '2020-06-14'),
(81, 'MXN', '22.2003', '2020-06-14'),
(82, 'MYR', '4.27072', '2020-06-14'),
(83, 'MZN', '69.6835', '2020-06-14'),
(84, 'NAD', '17.121', '2020-06-14'),
(85, 'NGN', '387.52', '2020-06-14'),
(86, 'NIO', '34.3', '2020-06-14'),
(87, 'NOK', '9.6223', '2020-06-14'),
(88, 'NPR', '121.40247', '2020-06-14'),
(89, 'NZD', '1.55107', '2020-06-14'),
(90, 'OMR', '0.38503', '2020-06-14'),
(91, 'PAB', '1.00019', '2020-06-14'),
(92, 'PEN', '3.46515', '2020-06-14'),
(93, 'PGK', '3.45', '2020-06-14'),
(94, 'PHP', '50.2806', '2020-06-14'),
(95, 'PKR', '164.51', '2020-06-14'),
(96, 'PLN', '3.9426', '2020-06-14'),
(97, 'PYG', '6691.42155', '2020-06-14'),
(98, 'QAR', '3.64143', '2020-06-14'),
(99, 'RON', '4.29532', '2020-06-14'),
(100, 'RSD', '104.4402', '2020-06-14'),
(101, 'RUB', '69.8931', '2020-06-14'),
(102, 'RWF', '950.05', '2020-06-14'),
(103, 'SAR', '3.75399', '2020-06-14'),
(104, 'SBD', '8.32912', '2020-06-14'),
(105, 'SCR', '17.59155', '2020-06-14'),
(106, 'SDG', '55.305', '2020-06-14'),
(107, 'SEK', '9.3155', '2020-06-14'),
(108, 'SLL', '9755.5', '2020-06-14'),
(109, 'SOS', '583.05', '2020-06-14'),
(110, 'SRD', '7.45835', '2020-06-14'),
(111, 'SZL', '17.121', '2020-06-14'),
(112, 'THB', '30.9815', '2020-06-14'),
(113, 'TJS', '10.28185', '2020-06-14'),
(114, 'TMT', '3.5', '2020-06-14'),
(115, 'TND', '2.85065', '2020-06-14'),
(116, 'TOP', '2.2711', '2020-06-14'),
(117, 'TRY', '6.8106', '2020-06-14'),
(118, 'TTD', '6.75027', '2020-06-14'),
(119, 'TWD', '29.64478', '2020-06-14'),
(120, 'UAH', '26.73694', '2020-06-14'),
(121, 'UGX', '3720.74805', '2020-06-14'),
(122, 'USD', '1', '2020-06-14'),
(123, 'UYU', '42.84096', '2020-06-14'),
(124, 'UZS', '10160.5', '2020-06-14'),
(125, 'VND', '23266.665', '2020-06-14'),
(126, 'VUV', '', '2020-06-14'),
(127, 'WST', '', '2020-06-14'),
(128, 'XAF', '580.42432', '2020-06-14'),
(129, 'XCD', '2.70269', '2020-06-14'),
(130, 'XOF', '580.53', '2020-06-14'),
(131, 'XPF', '', '2020-06-14'),
(132, 'YER', '250.3625', '2020-06-14'),
(133, 'ZAR', '17.0361', '2020-06-14'),
(134, 'ZMW', '18.33854', '2020-06-14');

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

--
-- 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_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, '1', '2', '10', '50', 'Paypal', '<p>Referral guideline</p>');

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

--
-- Table structure for table `salary`
--

CREATE TABLE `salary` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `business_id` int(11) NOT NULL,
  `department_id` int(11) NOT NULL,
  `employee_id` int(11) NOT NULL,
  `amount` varchar(255) NOT NULL,
  `acount` varchar(255) NOT NULL,
  `method` varchar(255) NOT NULL,
  `note` varchar(255) DEFAULT NULL,
  `status` int(11) NOT NULL,
  `created_at` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

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

CREATE TABLE `services` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `name` varchar(500) DEFAULT NULL,
  `details` text,
  `image` varchar(255) DEFAULT NULL,
  `thumb` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- 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 `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` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `tax`
--

CREATE TABLE `tax` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `business_id` int(11) NOT NULL,
  `type` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `rate` decimal(10,2) DEFAULT '0.00',
  `number` varchar(255) DEFAULT NULL,
  `details` mediumtext,
  `is_invoices` int(11) DEFAULT NULL,
  `is_recoverable` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `tax_type`
--

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

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

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

CREATE TABLE `testimonials` (
  `id` int(11) 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_role`
--

CREATE TABLE `users_role` (
  `id` int(11) NOT NULL,
  `parent_id` int(11) NOT NULL,
  `business_id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `country` int(11) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `thumb` varchar(255) DEFAULT NULL,
  `email` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `position` varchar(255) NOT NULL,
  `role` varchar(255) NOT NULL,
  `is_send_invoice` varchar(255) DEFAULT NULL,
  `approve` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  `created_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `users_role_feature`
--

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

--
-- Dumping data for table `users_role_feature`
--

INSERT INTO `users_role_feature` (`id`, `name`, `slug`) VALUES
(1, 'Customers', 'customers'),
(2, 'Products', 'products'),
(3, 'Estimates', 'estimates'),
(4, 'Invoices', 'invoices'),
(5, 'Expenses', 'expenses'),
(6, 'Bills', 'bills'),
(7, 'Reports', 'reports');

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

--
-- Table structure for table `users_role_feature_assign`
--

CREATE TABLE `users_role_feature_assign` (
  `id` int(11) NOT NULL,
  `role` varchar(255) NOT NULL,
  `business_id` int(11) NOT NULL,
  `feature_id` int(11) NOT NULL,
  `feature_slug` varchar(255) DEFAULT NULL,
  `view_only` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `vendors`
--

CREATE TABLE `vendors` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `business_id` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `address` mediumtext,
  `created_at` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `attendence`
--
ALTER TABLE `attendence`
  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 `business`
--
ALTER TABLE `business`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `business_category`
--
ALTER TABLE `business_category`
  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 `customers`
--
ALTER TABLE `customers`
  ADD PRIMARY KEY (`id`);

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

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

--
-- Indexes for table `expenses`
--
ALTER TABLE `expenses`
  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 `google_fonts`
--
ALTER TABLE `google_fonts`
  ADD PRIMARY KEY (`id`);

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

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

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

--
-- Indexes for table `invoice_taxes`
--
ALTER TABLE `invoice_taxes`
  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 `package`
--
ALTER TABLE `package`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `package_features`
--
ALTER TABLE `package_features`
  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_advance`
--
ALTER TABLE `payment_advance`
  ADD PRIMARY KEY (`id`);

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `tax_type`
--
ALTER TABLE `tax_type`
  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_role`
--
ALTER TABLE `users_role`
  ADD PRIMARY KEY (`id`);

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `attendence`
--
ALTER TABLE `attendence`
  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 `business`
--
ALTER TABLE `business`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

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

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

--
-- 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=190;

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

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

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

--
-- AUTO_INCREMENT for table `expenses`
--
ALTER TABLE `expenses`
  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 for table `features`
--
ALTER TABLE `features`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

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

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

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

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

--
-- AUTO_INCREMENT for table `invoice_taxes`
--
ALTER TABLE `invoice_taxes`
  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=2;

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `payment_records`
--
ALTER TABLE `payment_records`
  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 `products`
--
ALTER TABLE `products`
  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 for table `product_tax`
--
ALTER TABLE `product_tax`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `referrals`
--
ALTER TABLE `referrals`
  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 `salary`
--
ALTER TABLE `salary`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

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

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

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

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

--
-- AUTO_INCREMENT for table `tax_type`
--
ALTER TABLE `tax_type`
  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_role`
--
ALTER TABLE `users_role`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

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

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

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

