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

START TRANSACTION;



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

--
-- Table structure for table `app_slider`
--

CREATE TABLE `app_slider` (
  `id` int(11) NOT NULL,
  `image` varchar(255) NOT NULL,
  `url` varchar(255) NOT NULL,
  `ecommerce` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `app_slider`
--

INSERT INTO `app_slider` (`id`, `image`, `url`, `ecommerce`) VALUES
(14, 'app/webroot/uploads/images/609986889fa13.png', 'https://qboxus.com', 0),
(15, 'app/webroot/uploads/images/609986a542396.png', 'https://qboxus.com', 0),
(16, 'app/webroot/uploads/images/609986a542396.png', 'https://qboxus.com', 1),
(17, 'app/webroot/uploads/images/609986889fa13.png', 'https://qboxus.com', 1);

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

--
-- Table structure for table `audience`
--

CREATE TABLE `audience` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `country` varchar(255) NOT NULL,
  `min_age` int(11) NOT NULL,
  `max_age` int(11) NOT NULL,
  `gender` varchar(255) NOT NULL,
  `created` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `audience_location`
--

CREATE TABLE `audience_location` (
  `id` int(11) NOT NULL,
  `audience_id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `city_id` int(11) NOT NULL,
  `state_id` int(11) NOT NULL,
  `country_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `block_user`
--

CREATE TABLE `block_user` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `block_user_id` int(11) NOT NULL,
  `created` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `card`
--

CREATE TABLE `card` (
  `id` int(11) NOT NULL,
  `card` varchar(255) NOT NULL,
  `user_id` int(11) NOT NULL,
  `last_4` int(11) NOT NULL,
  `brand` varchar(25) NOT NULL,
  `exp_month` int(11) NOT NULL,
  `exp_year` int(11) NOT NULL,
  `card_id` varchar(255) NOT NULL,
  `payment_method_id` varchar(255) NOT NULL,
  `default` int(11) NOT NULL DEFAULT '1',
  `email` varchar(255) NOT NULL,
  `created` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `cart_slider`
--

CREATE TABLE `cart_slider` (
  `id` int(11) NOT NULL,
  `image` varchar(255) NOT NULL,
  `url` varchar(255) NOT NULL,
  `created` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `category`
--

CREATE TABLE `category` (
  `id` int(11) NOT NULL,
  `title` varchar(80) NOT NULL,
  `image` varchar(255) NOT NULL,
  `created` datetime NOT NULL,
  `parent_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `category`
--

INSERT INTO `category` (`id`, `title`, `image`, `created`, `parent_id`) VALUES
(5, 'Business & Industrial', '', '0000-00-00 00:00:00', 0),
(7, 'Electronics', '', '0000-00-00 00:00:00', 0),
(8, 'Food, Beverages & Tobacco', '', '0000-00-00 00:00:00', 0),
(9, 'Furniture', '', '0000-00-00 00:00:00', 0),
(10, 'Hardware', '', '0000-00-00 00:00:00', 0),
(11, 'Health & Beauty', '', '0000-00-00 00:00:00', 0),
(12, 'Home & Garden', '', '0000-00-00 00:00:00', 0);

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

--
-- Table structure for table `cities`
--

CREATE TABLE `cities` (
  `id` int(11) NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `state_id` mediumint(8) UNSIGNED NOT NULL,
  `state_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `country_id` mediumint(8) UNSIGNED NOT NULL,
  `country_code` char(2) COLLATE utf8mb4_unicode_ci NOT NULL,
  `latitude` decimal(10,8) NOT NULL,
  `longitude` decimal(11,8) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '2014-01-01 01:01:01',
  `updated_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `flag` tinyint(1) NOT NULL DEFAULT '1',
  `wikiDataId` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Rapid API GeoDB Cities',
  `active` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT;

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

--
-- Table structure for table `coin_worth`
--

CREATE TABLE `coin_worth` (
  `id` int(11) NOT NULL,
  `price` float NOT NULL COMMENT 'value will be in dollars'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `countries`
--

CREATE TABLE `countries` (
  `id` mediumint(8) UNSIGNED NOT NULL,
  `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `iso3` char(3) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `short_name` char(2) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phonecode` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `capital` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `currency` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `native` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `region` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `subregion` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `emoji` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `emojiU` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `flag` tinyint(1) NOT NULL DEFAULT '1',
  `wikiDataId` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Rapid API GeoDB Cities',
  `active` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `countries`
--

INSERT INTO `countries` (`id`, `name`, `iso3`, `short_name`, `phonecode`, `capital`, `currency`, `native`, `region`, `subregion`, `emoji`, `emojiU`, `created_at`, `updated_at`, `flag`, `wikiDataId`, `active`) VALUES
(1, 'Afghanistan', 'AFG', 'AF', '93', 'Kabul', 'AFN', 'افغانستان', 'Asia', 'Southern Asia', '🇦🇫', 'U+1F1E6 U+1F1EB', '2018-07-20 20:11:03', '2020-11-09 08:45:17', 1, 'Q889', 1),
(2, 'Aland Islands', 'ALA', 'AX', '+358-18', 'Mariehamn', 'EUR', 'Åland', 'Europe', 'Northern Europe', '🇦🇽', 'U+1F1E6 U+1F1FD', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, NULL, 1),
(3, 'Albania', 'ALB', 'AL', '355', 'Tirana', 'ALL', 'Shqipëria', 'Europe', 'Southern Europe', '🇦🇱', 'U+1F1E6 U+1F1F1', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q222', 1),
(4, 'Algeria', 'DZA', 'DZ', '213', 'Algiers', 'DZD', 'الجزائر', 'Africa', 'Northern Africa', '🇩🇿', 'U+1F1E9 U+1F1FF', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q262', 1),
(5, 'American Samoa', 'ASM', 'AS', '+1-684', 'Pago Pago', 'USD', 'American Samoa', 'Oceania', 'Polynesia', '🇦🇸', 'U+1F1E6 U+1F1F8', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, NULL, 1),
(6, 'Andorra', 'AND', 'AD', '376', 'Andorra la Vella', 'EUR', 'Andorra', 'Europe', 'Southern Europe', '🇦🇩', 'U+1F1E6 U+1F1E9', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q228', 1),
(7, 'Angola', 'AGO', 'AO', '244', 'Luanda', 'AOA', 'Angola', 'Africa', 'Middle Africa', '🇦🇴', 'U+1F1E6 U+1F1F4', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q916', 1),
(8, 'Anguilla', 'AIA', 'AI', '+1-264', 'The Valley', 'XCD', 'Anguilla', 'Americas', 'Caribbean', '🇦🇮', 'U+1F1E6 U+1F1EE', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, NULL, 1),
(9, 'Antarctica', 'ATA', 'AQ', '', '', '', 'Antarctica', 'Polar', '', '🇦🇶', 'U+1F1E6 U+1F1F6', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, NULL, 1),
(10, 'Antigua And Barbuda', 'ATG', 'AG', '+1-268', 'St. John\'s', 'XCD', 'Antigua and Barbuda', 'Americas', 'Caribbean', '🇦🇬', 'U+1F1E6 U+1F1EC', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q781', 1),
(11, 'Argentina', 'ARG', 'AR', '54', 'Buenos Aires', 'ARS', 'Argentina', 'Americas', 'South America', '🇦🇷', 'U+1F1E6 U+1F1F7', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q414', 1),
(12, 'Armenia', 'ARM', 'AM', '374', 'Yerevan', 'AMD', 'Հայաստան', 'Asia', 'Western Asia', '🇦🇲', 'U+1F1E6 U+1F1F2', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q399', 1),
(13, 'Aruba', 'ABW', 'AW', '297', 'Oranjestad', 'AWG', 'Aruba', 'Americas', 'Caribbean', '🇦🇼', 'U+1F1E6 U+1F1FC', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, NULL, 1),
(14, 'Australia', 'AUS', 'AU', '61', 'Canberra', 'AUD', 'Australia', 'Oceania', 'Australia and New Zealand', '🇦🇺', 'U+1F1E6 U+1F1FA', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q408', 1),
(15, 'Austria', 'AUT', 'AT', '43', 'Vienna', 'EUR', 'Österreich', 'Europe', 'Western Europe', '🇦🇹', 'U+1F1E6 U+1F1F9', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q40', 1),
(16, 'Azerbaijan', 'AZE', 'AZ', '994', 'Baku', 'AZN', 'Azərbaycan', 'Asia', 'Western Asia', '🇦🇿', 'U+1F1E6 U+1F1FF', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q227', 1),
(17, 'Bahamas The', 'BHS', 'BS', '+1-242', 'Nassau', 'BSD', 'Bahamas', 'Americas', 'Caribbean', '🇧🇸', 'U+1F1E7 U+1F1F8', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q778', 1),
(18, 'Bahrain', 'BHR', 'BH', '973', 'Manama', 'BHD', '‏البحرين', 'Asia', 'Western Asia', '🇧🇭', 'U+1F1E7 U+1F1ED', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q398', 1),
(19, 'Bangladesh', 'BGD', 'BD', '880', 'Dhaka', 'BDT', 'Bangladesh', 'Asia', 'Southern Asia', '🇧🇩', 'U+1F1E7 U+1F1E9', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q902', 1),
(20, 'Barbados', 'BRB', 'BB', '+1-246', 'Bridgetown', 'BBD', 'Barbados', 'Americas', 'Caribbean', '🇧🇧', 'U+1F1E7 U+1F1E7', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q244', 1),
(21, 'Belarus', 'BLR', 'BY', '375', 'Minsk', 'BYN', 'Белару́сь', 'Europe', 'Eastern Europe', '🇧🇾', 'U+1F1E7 U+1F1FE', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q184', 1),
(22, 'Belgium', 'BEL', 'BE', '32', 'Brussels', 'EUR', 'België', 'Europe', 'Western Europe', '🇧🇪', 'U+1F1E7 U+1F1EA', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q31', 1),
(23, 'Belize', 'BLZ', 'BZ', '501', 'Belmopan', 'BZD', 'Belize', 'Americas', 'Central America', '🇧🇿', 'U+1F1E7 U+1F1FF', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q242', 1),
(24, 'Benin', 'BEN', 'BJ', '229', 'Porto-Novo', 'XOF', 'Bénin', 'Africa', 'Western Africa', '🇧🇯', 'U+1F1E7 U+1F1EF', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q962', 1),
(25, 'Bermuda', 'BMU', 'BM', '+1-441', 'Hamilton', 'BMD', 'Bermuda', 'Americas', 'Northern America', '🇧🇲', 'U+1F1E7 U+1F1F2', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, NULL, 1),
(26, 'Bhutan', 'BTN', 'BT', '975', 'Thimphu', 'BTN', 'ʼbrug-yul', 'Asia', 'Southern Asia', '🇧🇹', 'U+1F1E7 U+1F1F9', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q917', 1),
(27, 'Bolivia', 'BOL', 'BO', '591', 'Sucre', 'BOB', 'Bolivia', 'Americas', 'South America', '🇧🇴', 'U+1F1E7 U+1F1F4', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q750', 1),
(28, 'Bosnia and Herzegovina', 'BIH', 'BA', '387', 'Sarajevo', 'BAM', 'Bosna i Hercegovina', 'Europe', 'Southern Europe', '🇧🇦', 'U+1F1E7 U+1F1E6', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q225', 1),
(29, 'Botswana', 'BWA', 'BW', '267', 'Gaborone', 'BWP', 'Botswana', 'Africa', 'Southern Africa', '🇧🇼', 'U+1F1E7 U+1F1FC', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q963', 1),
(30, 'Bouvet Island', 'BVT', 'BV', '', '', 'NOK', 'Bouvetøya', '', '', '🇧🇻', 'U+1F1E7 U+1F1FB', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, NULL, 1),
(31, 'Brazil', 'BRA', 'BR', '55', 'Brasilia', 'BRL', 'Brasil', 'Americas', 'South America', '🇧🇷', 'U+1F1E7 U+1F1F7', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q155', 1),
(32, 'British Indian Ocean Territory', 'IOT', 'IO', '246', 'Diego Garcia', 'USD', 'British Indian Ocean Territory', 'Africa', 'Eastern Africa', '🇮🇴', 'U+1F1EE U+1F1F4', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, NULL, 1),
(33, 'Brunei', 'BRN', 'BN', '673', 'Bandar Seri Begawan', 'BND', 'Negara Brunei Darussalam', 'Asia', 'South-Eastern Asia', '🇧🇳', 'U+1F1E7 U+1F1F3', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q921', 1),
(34, 'Bulgaria', 'BGR', 'BG', '359', 'Sofia', 'BGN', 'България', 'Europe', 'Eastern Europe', '🇧🇬', 'U+1F1E7 U+1F1EC', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q219', 1),
(35, 'Burkina Faso', 'BFA', 'BF', '226', 'Ouagadougou', 'XOF', 'Burkina Faso', 'Africa', 'Western Africa', '🇧🇫', 'U+1F1E7 U+1F1EB', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q965', 1),
(36, 'Burundi', 'BDI', 'BI', '257', 'Bujumbura', 'BIF', 'Burundi', 'Africa', 'Eastern Africa', '🇧🇮', 'U+1F1E7 U+1F1EE', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q967', 1),
(37, 'Cambodia', 'KHM', 'KH', '855', 'Phnom Penh', 'KHR', 'Kâmpŭchéa', 'Asia', 'South-Eastern Asia', '🇰🇭', 'U+1F1F0 U+1F1ED', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q424', 1),
(38, 'Cameroon', 'CMR', 'CM', '237', 'Yaounde', 'XAF', 'Cameroon', 'Africa', 'Middle Africa', '🇨🇲', 'U+1F1E8 U+1F1F2', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q1009', 1),
(39, 'Canada', 'CAN', 'CA', '1', 'Ottawa', 'CAD', 'Canada', 'Americas', 'Northern America', '🇨🇦', 'U+1F1E8 U+1F1E6', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q16', 1),
(40, 'Cape Verde', 'CPV', 'CV', '238', 'Praia', 'CVE', 'Cabo Verde', 'Africa', 'Western Africa', '🇨🇻', 'U+1F1E8 U+1F1FB', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q1011', 1),
(41, 'Cayman Islands', 'CYM', 'KY', '+1-345', 'George Town', 'KYD', 'Cayman Islands', 'Americas', 'Caribbean', '🇰🇾', 'U+1F1F0 U+1F1FE', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, NULL, 1),
(42, 'Central African Republic', 'CAF', 'CF', '236', 'Bangui', 'XAF', 'Ködörösêse tî Bêafrîka', 'Africa', 'Middle Africa', '🇨🇫', 'U+1F1E8 U+1F1EB', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q929', 1),
(43, 'Chad', 'TCD', 'TD', '235', 'N\'Djamena', 'XAF', 'Tchad', 'Africa', 'Middle Africa', '🇹🇩', 'U+1F1F9 U+1F1E9', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q657', 1),
(44, 'Chile', 'CHL', 'CL', '56', 'Santiago', 'CLP', 'Chile', 'Americas', 'South America', '🇨🇱', 'U+1F1E8 U+1F1F1', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q298', 1),
(45, 'China', 'CHN', 'CN', '86', 'Beijing', 'CNY', '中国', 'Asia', 'Eastern Asia', '🇨🇳', 'U+1F1E8 U+1F1F3', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q148', 1),
(46, 'Christmas Island', 'CXR', 'CX', '61', 'Flying Fish Cove', 'AUD', 'Christmas Island', 'Oceania', 'Australia and New Zealand', '🇨🇽', 'U+1F1E8 U+1F1FD', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, NULL, 1),
(47, 'Cocos (Keeling) Islands', 'CCK', 'CC', '61', 'West Island', 'AUD', 'Cocos (Keeling) Islands', 'Oceania', 'Australia and New Zealand', '🇨🇨', 'U+1F1E8 U+1F1E8', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, NULL, 1),
(48, 'Colombia', 'COL', 'CO', '57', 'Bogota', 'COP', 'Colombia', 'Americas', 'South America', '🇨🇴', 'U+1F1E8 U+1F1F4', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q739', 1),
(49, 'Comoros', 'COM', 'KM', '269', 'Moroni', 'KMF', 'Komori', 'Africa', 'Eastern Africa', '🇰🇲', 'U+1F1F0 U+1F1F2', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q970', 1),
(50, 'Congo', 'COG', 'CG', '242', 'Brazzaville', 'XAF', 'République du Congo', 'Africa', 'Middle Africa', '🇨🇬', 'U+1F1E8 U+1F1EC', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q971', 1),
(51, 'Congo The Democratic Republic Of The', 'COD', 'CD', '243', 'Kinshasa', 'CDF', 'République démocratique du Congo', 'Africa', 'Middle Africa', '🇨🇩', 'U+1F1E8 U+1F1E9', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q974', 1),
(52, 'Cook Islands', 'COK', 'CK', '682', 'Avarua', 'NZD', 'Cook Islands', 'Oceania', 'Polynesia', '🇨🇰', 'U+1F1E8 U+1F1F0', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q26988', 1),
(53, 'Costa Rica', 'CRI', 'CR', '506', 'San Jose', 'CRC', 'Costa Rica', 'Americas', 'Central America', '🇨🇷', 'U+1F1E8 U+1F1F7', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q800', 1),
(54, 'Cote D\'Ivoire (Ivory Coast)', 'CIV', 'CI', '225', 'Yamoussoukro', 'XOF', NULL, 'Africa', 'Western Africa', '🇨🇮', 'U+1F1E8 U+1F1EE', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q1008', 1),
(55, 'Croatia (Hrvatska)', 'HRV', 'HR', '385', 'Zagreb', 'HRK', 'Hrvatska', 'Europe', 'Southern Europe', '🇭🇷', 'U+1F1ED U+1F1F7', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q224', 1),
(56, 'Cuba', 'CUB', 'CU', '53', 'Havana', 'CUP', 'Cuba', 'Americas', 'Caribbean', '🇨🇺', 'U+1F1E8 U+1F1FA', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q241', 1),
(57, 'Cyprus', 'CYP', 'CY', '357', 'Nicosia', 'EUR', 'Κύπρος', 'Europe', 'Southern Europe', '🇨🇾', 'U+1F1E8 U+1F1FE', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q229', 1),
(58, 'Czech Republic', 'CZE', 'CZ', '420', 'Prague', 'CZK', 'Česká republika', 'Europe', 'Eastern Europe', '🇨🇿', 'U+1F1E8 U+1F1FF', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q213', 1),
(59, 'Denmark', 'DNK', 'DK', '45', 'Copenhagen', 'DKK', 'Danmark', 'Europe', 'Northern Europe', '🇩🇰', 'U+1F1E9 U+1F1F0', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q35', 1),
(60, 'Djibouti', 'DJI', 'DJ', '253', 'Djibouti', 'DJF', 'Djibouti', 'Africa', 'Eastern Africa', '🇩🇯', 'U+1F1E9 U+1F1EF', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q977', 1),
(61, 'Dominica', 'DMA', 'DM', '+1-767', 'Roseau', 'XCD', 'Dominica', 'Americas', 'Caribbean', '🇩🇲', 'U+1F1E9 U+1F1F2', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q784', 1),
(62, 'Dominican Republic', 'DOM', 'DO', '+1-809 and 1-829', 'Santo Domingo', 'DOP', 'República Dominicana', 'Americas', 'Caribbean', '🇩🇴', 'U+1F1E9 U+1F1F4', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q786', 1),
(63, 'East Timor', 'TLS', 'TL', '670', 'Dili', 'USD', 'Timor-Leste', 'Asia', 'South-Eastern Asia', '🇹🇱', 'U+1F1F9 U+1F1F1', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q574', 1),
(64, 'Ecuador', 'ECU', 'EC', '593', 'Quito', 'USD', 'Ecuador', 'Americas', 'South America', '🇪🇨', 'U+1F1EA U+1F1E8', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q736', 1),
(65, 'Egypt', 'EGY', 'EG', '20', 'Cairo', 'EGP', 'مصر‎', 'Africa', 'Northern Africa', '🇪🇬', 'U+1F1EA U+1F1EC', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q79', 1),
(66, 'El Salvador', 'SLV', 'SV', '503', 'San Salvador', 'USD', 'El Salvador', 'Americas', 'Central America', '🇸🇻', 'U+1F1F8 U+1F1FB', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q792', 1),
(67, 'Equatorial Guinea', 'GNQ', 'GQ', '240', 'Malabo', 'XAF', 'Guinea Ecuatorial', 'Africa', 'Middle Africa', '🇬🇶', 'U+1F1EC U+1F1F6', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q983', 1),
(68, 'Eritrea', 'ERI', 'ER', '291', 'Asmara', 'ERN', 'ኤርትራ', 'Africa', 'Eastern Africa', '🇪🇷', 'U+1F1EA U+1F1F7', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q986', 1),
(69, 'Estonia', 'EST', 'EE', '372', 'Tallinn', 'EUR', 'Eesti', 'Europe', 'Northern Europe', '🇪🇪', 'U+1F1EA U+1F1EA', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q191', 1),
(70, 'Ethiopia', 'ETH', 'ET', '251', 'Addis Ababa', 'ETB', 'ኢትዮጵያ', 'Africa', 'Eastern Africa', '🇪🇹', 'U+1F1EA U+1F1F9', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q115', 1),
(71, 'Falkland Islands', 'FLK', 'FK', '500', 'Stanley', 'FKP', 'Falkland Islands', 'Americas', 'South America', '🇫🇰', 'U+1F1EB U+1F1F0', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, NULL, 1),
(72, 'Faroe Islands', 'FRO', 'FO', '298', 'Torshavn', 'DKK', 'Føroyar', 'Europe', 'Northern Europe', '🇫🇴', 'U+1F1EB U+1F1F4', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, NULL, 1),
(73, 'Fiji Islands', 'FJI', 'FJ', '679', 'Suva', 'FJD', 'Fiji', 'Oceania', 'Melanesia', '🇫🇯', 'U+1F1EB U+1F1EF', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q712', 1),
(74, 'Finland', 'FIN', 'FI', '358', 'Helsinki', 'EUR', 'Suomi', 'Europe', 'Northern Europe', '🇫🇮', 'U+1F1EB U+1F1EE', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q33', 1),
(75, 'France', 'FRA', 'FR', '33', 'Paris', 'EUR', 'France', 'Europe', 'Western Europe', '🇫🇷', 'U+1F1EB U+1F1F7', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q142', 1),
(76, 'French Guiana', 'GUF', 'GF', '594', 'Cayenne', 'EUR', 'Guyane française', 'Americas', 'South America', '🇬🇫', 'U+1F1EC U+1F1EB', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, NULL, 1),
(77, 'French Polynesia', 'PYF', 'PF', '689', 'Papeete', 'XPF', 'Polynésie française', 'Oceania', 'Polynesia', '🇵🇫', 'U+1F1F5 U+1F1EB', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, NULL, 1),
(78, 'French Southern Territories', 'ATF', 'TF', '', 'Port-aux-Francais', 'EUR', 'Territoire des Terres australes et antarctiques fr', 'Africa', 'Southern Africa', '🇹🇫', 'U+1F1F9 U+1F1EB', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, NULL, 1),
(79, 'Gabon', 'GAB', 'GA', '241', 'Libreville', 'XAF', 'Gabon', 'Africa', 'Middle Africa', '🇬🇦', 'U+1F1EC U+1F1E6', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q1000', 1),
(80, 'Gambia The', 'GMB', 'GM', '220', 'Banjul', 'GMD', 'Gambia', 'Africa', 'Western Africa', '🇬🇲', 'U+1F1EC U+1F1F2', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q1005', 1),
(81, 'Georgia', 'GEO', 'GE', '995', 'Tbilisi', 'GEL', 'საქართველო', 'Asia', 'Western Asia', '🇬🇪', 'U+1F1EC U+1F1EA', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q230', 1),
(82, 'Germany', 'DEU', 'DE', '49', 'Berlin', 'EUR', 'Deutschland', 'Europe', 'Western Europe', '🇩🇪', 'U+1F1E9 U+1F1EA', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q183', 1),
(83, 'Ghana', 'GHA', 'GH', '233', 'Accra', 'GHS', 'Ghana', 'Africa', 'Western Africa', '🇬🇭', 'U+1F1EC U+1F1ED', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q117', 1),
(84, 'Gibraltar', 'GIB', 'GI', '350', 'Gibraltar', 'GIP', 'Gibraltar', 'Europe', 'Southern Europe', '🇬🇮', 'U+1F1EC U+1F1EE', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, NULL, 1),
(85, 'Greece', 'GRC', 'GR', '30', 'Athens', 'EUR', 'Ελλάδα', 'Europe', 'Southern Europe', '🇬🇷', 'U+1F1EC U+1F1F7', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q41', 1),
(86, 'Greenland', 'GRL', 'GL', '299', 'Nuuk', 'DKK', 'Kalaallit Nunaat', 'Americas', 'Northern America', '🇬🇱', 'U+1F1EC U+1F1F1', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, NULL, 1),
(87, 'Grenada', 'GRD', 'GD', '+1-473', 'St. George\'s', 'XCD', 'Grenada', 'Americas', 'Caribbean', '🇬🇩', 'U+1F1EC U+1F1E9', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q769', 1),
(88, 'Guadeloupe', 'GLP', 'GP', '590', 'Basse-Terre', 'EUR', 'Guadeloupe', 'Americas', 'Caribbean', '🇬🇵', 'U+1F1EC U+1F1F5', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, NULL, 1),
(89, 'Guam', 'GUM', 'GU', '+1-671', 'Hagatna', 'USD', 'Guam', 'Oceania', 'Micronesia', '🇬🇺', 'U+1F1EC U+1F1FA', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, NULL, 1),
(90, 'Guatemala', 'GTM', 'GT', '502', 'Guatemala City', 'GTQ', 'Guatemala', 'Americas', 'Central America', '🇬🇹', 'U+1F1EC U+1F1F9', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q774', 1),
(91, 'Guernsey and Alderney', 'GGY', 'GG', '+44-1481', 'St Peter Port', 'GBP', 'Guernsey', 'Europe', 'Northern Europe', '🇬🇬', 'U+1F1EC U+1F1EC', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, NULL, 1),
(92, 'Guinea', 'GIN', 'GN', '224', 'Conakry', 'GNF', 'Guinée', 'Africa', 'Western Africa', '🇬🇳', 'U+1F1EC U+1F1F3', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q1006', 1),
(93, 'Guinea-Bissau', 'GNB', 'GW', '245', 'Bissau', 'XOF', 'Guiné-Bissau', 'Africa', 'Western Africa', '🇬🇼', 'U+1F1EC U+1F1FC', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q1007', 1),
(94, 'Guyana', 'GUY', 'GY', '592', 'Georgetown', 'GYD', 'Guyana', 'Americas', 'South America', '🇬🇾', 'U+1F1EC U+1F1FE', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q734', 1),
(95, 'Haiti', 'HTI', 'HT', '509', 'Port-au-Prince', 'HTG', 'Haïti', 'Americas', 'Caribbean', '🇭🇹', 'U+1F1ED U+1F1F9', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q790', 1),
(96, 'Heard and McDonald Islands', 'HMD', 'HM', ' ', '', 'AUD', 'Heard Island and McDonald Islands', '', '', '🇭🇲', 'U+1F1ED U+1F1F2', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, NULL, 1),
(97, 'Honduras', 'HND', 'HN', '504', 'Tegucigalpa', 'HNL', 'Honduras', 'Americas', 'Central America', '🇭🇳', 'U+1F1ED U+1F1F3', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q783', 1),
(98, 'Hong Kong S.A.R.', 'HKG', 'HK', '852', 'Hong Kong', 'HKD', '香港', 'Asia', 'Eastern Asia', '🇭🇰', 'U+1F1ED U+1F1F0', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, NULL, 1),
(99, 'Hungary', 'HUN', 'HU', '36', 'Budapest', 'HUF', 'Magyarország', 'Europe', 'Eastern Europe', '🇭🇺', 'U+1F1ED U+1F1FA', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q28', 1),
(100, 'Iceland', 'ISL', 'IS', '354', 'Reykjavik', 'ISK', 'Ísland', 'Europe', 'Northern Europe', '🇮🇸', 'U+1F1EE U+1F1F8', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q189', 1),
(101, 'India', 'IND', 'IN', '91', 'New Delhi', 'INR', 'भारत', 'Asia', 'Southern Asia', '🇮🇳', 'U+1F1EE U+1F1F3', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q668', 1),
(102, 'Indonesia', 'IDN', 'ID', '62', 'Jakarta', 'IDR', 'Indonesia', 'Asia', 'South-Eastern Asia', '🇮🇩', 'U+1F1EE U+1F1E9', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q252', 1),
(103, 'Iran', 'IRN', 'IR', '98', 'Tehran', 'IRR', 'ایران', 'Asia', 'Southern Asia', '🇮🇷', 'U+1F1EE U+1F1F7', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q794', 1),
(104, 'Iraq', 'IRQ', 'IQ', '964', 'Baghdad', 'IQD', 'العراق', 'Asia', 'Western Asia', '🇮🇶', 'U+1F1EE U+1F1F6', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q796', 1),
(105, 'Ireland', 'IRL', 'IE', '353', 'Dublin', 'EUR', 'Éire', 'Europe', 'Northern Europe', '🇮🇪', 'U+1F1EE U+1F1EA', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q27', 1),
(106, 'Israel', 'ISR', 'IL', '972', 'Jerusalem', 'ILS', 'יִשְׂרָאֵל', 'Asia', 'Western Asia', '🇮🇱', 'U+1F1EE U+1F1F1', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q801', 1),
(107, 'Italy', 'ITA', 'IT', '39', 'Rome', 'EUR', 'Italia', 'Europe', 'Southern Europe', '🇮🇹', 'U+1F1EE U+1F1F9', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q38', 1),
(108, 'Jamaica', 'JAM', 'JM', '+1-876', 'Kingston', 'JMD', 'Jamaica', 'Americas', 'Caribbean', '🇯🇲', 'U+1F1EF U+1F1F2', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q766', 1),
(109, 'Japan', 'JPN', 'JP', '81', 'Tokyo', 'JPY', '日本', 'Asia', 'Eastern Asia', '🇯🇵', 'U+1F1EF U+1F1F5', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q17', 1),
(110, 'Jersey', 'JEY', 'JE', '+44-1534', 'Saint Helier', 'GBP', 'Jersey', 'Europe', 'Northern Europe', '🇯🇪', 'U+1F1EF U+1F1EA', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q785', 1),
(111, 'Jordan', 'JOR', 'JO', '962', 'Amman', 'JOD', 'الأردن', 'Asia', 'Western Asia', '🇯🇴', 'U+1F1EF U+1F1F4', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q810', 1),
(112, 'Kazakhstan', 'KAZ', 'KZ', '7', 'Astana', 'KZT', 'Қазақстан', 'Asia', 'Central Asia', '🇰🇿', 'U+1F1F0 U+1F1FF', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q232', 1),
(113, 'Kenya', 'KEN', 'KE', '254', 'Nairobi', 'KES', 'Kenya', 'Africa', 'Eastern Africa', '🇰🇪', 'U+1F1F0 U+1F1EA', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q114', 1),
(114, 'Kiribati', 'KIR', 'KI', '686', 'Tarawa', 'AUD', 'Kiribati', 'Oceania', 'Micronesia', '🇰🇮', 'U+1F1F0 U+1F1EE', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q710', 1),
(115, 'Korea North', 'PRK', 'KP', '850', 'Pyongyang', 'KPW', '북한', 'Asia', 'Eastern Asia', '🇰🇵', 'U+1F1F0 U+1F1F5', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q423', 1),
(116, 'Korea South', 'KOR', 'KR', '82', 'Seoul', 'KRW', '대한민국', 'Asia', 'Eastern Asia', '🇰🇷', 'U+1F1F0 U+1F1F7', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q884', 1),
(117, 'Kuwait', 'KWT', 'KW', '965', 'Kuwait City', 'KWD', 'الكويت', 'Asia', 'Western Asia', '🇰🇼', 'U+1F1F0 U+1F1FC', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q817', 1),
(118, 'Kyrgyzstan', 'KGZ', 'KG', '996', 'Bishkek', 'KGS', 'Кыргызстан', 'Asia', 'Central Asia', '🇰🇬', 'U+1F1F0 U+1F1EC', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q813', 1),
(119, 'Laos', 'LAO', 'LA', '856', 'Vientiane', 'LAK', 'ສປປລາວ', 'Asia', 'South-Eastern Asia', '🇱🇦', 'U+1F1F1 U+1F1E6', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q819', 1),
(120, 'Latvia', 'LVA', 'LV', '371', 'Riga', 'EUR', 'Latvija', 'Europe', 'Northern Europe', '🇱🇻', 'U+1F1F1 U+1F1FB', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q211', 1),
(121, 'Lebanon', 'LBN', 'LB', '961', 'Beirut', 'LBP', 'لبنان', 'Asia', 'Western Asia', '🇱🇧', 'U+1F1F1 U+1F1E7', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q822', 1),
(122, 'Lesotho', 'LSO', 'LS', '266', 'Maseru', 'LSL', 'Lesotho', 'Africa', 'Southern Africa', '🇱🇸', 'U+1F1F1 U+1F1F8', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q1013', 1),
(123, 'Liberia', 'LBR', 'LR', '231', 'Monrovia', 'LRD', 'Liberia', 'Africa', 'Western Africa', '🇱🇷', 'U+1F1F1 U+1F1F7', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q1014', 1),
(124, 'Libya', 'LBY', 'LY', '218', 'Tripolis', 'LYD', '‏ليبيا', 'Africa', 'Northern Africa', '🇱🇾', 'U+1F1F1 U+1F1FE', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q1016', 1),
(125, 'Liechtenstein', 'LIE', 'LI', '423', 'Vaduz', 'CHF', 'Liechtenstein', 'Europe', 'Western Europe', '🇱🇮', 'U+1F1F1 U+1F1EE', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q347', 1),
(126, 'Lithuania', 'LTU', 'LT', '370', 'Vilnius', 'EUR', 'Lietuva', 'Europe', 'Northern Europe', '🇱🇹', 'U+1F1F1 U+1F1F9', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q37', 1),
(127, 'Luxembourg', 'LUX', 'LU', '352', 'Luxembourg', 'EUR', 'Luxembourg', 'Europe', 'Western Europe', '🇱🇺', 'U+1F1F1 U+1F1FA', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q32', 1),
(128, 'Macau S.A.R.', 'MAC', 'MO', '853', 'Macao', 'MOP', '澳門', 'Asia', 'Eastern Asia', '🇲🇴', 'U+1F1F2 U+1F1F4', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, NULL, 1),
(129, 'Macedonia', 'MKD', 'MK', '389', 'Skopje', 'MKD', 'Северна Македонија', 'Europe', 'Southern Europe', '🇲🇰', 'U+1F1F2 U+1F1F0', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q221', 1),
(130, 'Madagascar', 'MDG', 'MG', '261', 'Antananarivo', 'MGA', 'Madagasikara', 'Africa', 'Eastern Africa', '🇲🇬', 'U+1F1F2 U+1F1EC', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q1019', 1),
(131, 'Malawi', 'MWI', 'MW', '265', 'Lilongwe', 'MWK', 'Malawi', 'Africa', 'Eastern Africa', '🇲🇼', 'U+1F1F2 U+1F1FC', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q1020', 1),
(132, 'Malaysia', 'MYS', 'MY', '60', 'Kuala Lumpur', 'MYR', 'Malaysia', 'Asia', 'South-Eastern Asia', '🇲🇾', 'U+1F1F2 U+1F1FE', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q833', 1),
(133, 'Maldives', 'MDV', 'MV', '960', 'Male', 'MVR', 'Maldives', 'Asia', 'Southern Asia', '🇲🇻', 'U+1F1F2 U+1F1FB', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q826', 1),
(134, 'Mali', 'MLI', 'ML', '223', 'Bamako', 'XOF', 'Mali', 'Africa', 'Western Africa', '🇲🇱', 'U+1F1F2 U+1F1F1', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q912', 1),
(135, 'Malta', 'MLT', 'MT', '356', 'Valletta', 'EUR', 'Malta', 'Europe', 'Southern Europe', '🇲🇹', 'U+1F1F2 U+1F1F9', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q233', 1),
(136, 'Man (Isle of)', 'IMN', 'IM', '+44-1624', 'Douglas, Isle of Man', 'GBP', 'Isle of Man', 'Europe', 'Northern Europe', '🇮🇲', 'U+1F1EE U+1F1F2', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, NULL, 1),
(137, 'Marshall Islands', 'MHL', 'MH', '692', 'Majuro', 'USD', 'M̧ajeļ', 'Oceania', 'Micronesia', '🇲🇭', 'U+1F1F2 U+1F1ED', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q709', 1),
(138, 'Martinique', 'MTQ', 'MQ', '596', 'Fort-de-France', 'EUR', 'Martinique', 'Americas', 'Caribbean', '🇲🇶', 'U+1F1F2 U+1F1F6', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, NULL, 1),
(139, 'Mauritania', 'MRT', 'MR', '222', 'Nouakchott', 'MRO', 'موريتانيا', 'Africa', 'Western Africa', '🇲🇷', 'U+1F1F2 U+1F1F7', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q1025', 1),
(140, 'Mauritius', 'MUS', 'MU', '230', 'Port Louis', 'MUR', 'Maurice', 'Africa', 'Eastern Africa', '🇲🇺', 'U+1F1F2 U+1F1FA', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q1027', 1),
(141, 'Mayotte', 'MYT', 'YT', '262', 'Mamoudzou', 'EUR', 'Mayotte', 'Africa', 'Eastern Africa', '🇾🇹', 'U+1F1FE U+1F1F9', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, NULL, 1),
(142, 'Mexico', 'MEX', 'MX', '52', 'Mexico City', 'MXN', 'México', 'Americas', 'Central America', '🇲🇽', 'U+1F1F2 U+1F1FD', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q96', 1),
(143, 'Micronesia', 'FSM', 'FM', '691', 'Palikir', 'USD', 'Micronesia', 'Oceania', 'Micronesia', '🇫🇲', 'U+1F1EB U+1F1F2', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q702', 1),
(144, 'Moldova', 'MDA', 'MD', '373', 'Chisinau', 'MDL', 'Moldova', 'Europe', 'Eastern Europe', '🇲🇩', 'U+1F1F2 U+1F1E9', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q217', 1),
(145, 'Monaco', 'MCO', 'MC', '377', 'Monaco', 'EUR', 'Monaco', 'Europe', 'Western Europe', '🇲🇨', 'U+1F1F2 U+1F1E8', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, NULL, 1),
(146, 'Mongolia', 'MNG', 'MN', '976', 'Ulan Bator', 'MNT', 'Монгол улс', 'Asia', 'Eastern Asia', '🇲🇳', 'U+1F1F2 U+1F1F3', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q711', 1),
(147, 'Montenegro', 'MNE', 'ME', '382', 'Podgorica', 'EUR', 'Црна Гора', 'Europe', 'Southern Europe', '🇲🇪', 'U+1F1F2 U+1F1EA', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q236', 1),
(148, 'Montserrat', 'MSR', 'MS', '+1-664', 'Plymouth', 'XCD', 'Montserrat', 'Americas', 'Caribbean', '🇲🇸', 'U+1F1F2 U+1F1F8', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, NULL, 1),
(149, 'Morocco', 'MAR', 'MA', '212', 'Rabat', 'MAD', 'المغرب', 'Africa', 'Northern Africa', '🇲🇦', 'U+1F1F2 U+1F1E6', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q1028', 1),
(150, 'Mozambique', 'MOZ', 'MZ', '258', 'Maputo', 'MZN', 'Moçambique', 'Africa', 'Eastern Africa', '🇲🇿', 'U+1F1F2 U+1F1FF', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q1029', 1),
(151, 'Myanmar', 'MMR', 'MM', '95', 'Nay Pyi Taw', 'MMK', 'မြန်မာ', 'Asia', 'South-Eastern Asia', '🇲🇲', 'U+1F1F2 U+1F1F2', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q836', 1),
(152, 'Namibia', 'NAM', 'NA', '264', 'Windhoek', 'NAD', 'Namibia', 'Africa', 'Southern Africa', '🇳🇦', 'U+1F1F3 U+1F1E6', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q1030', 1),
(153, 'Nauru', 'NRU', 'NR', '674', 'Yaren', 'AUD', 'Nauru', 'Oceania', 'Micronesia', '🇳🇷', 'U+1F1F3 U+1F1F7', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q697', 1),
(154, 'Nepal', 'NPL', 'NP', '977', 'Kathmandu', 'NPR', 'नपल', 'Asia', 'Southern Asia', '🇳🇵', 'U+1F1F3 U+1F1F5', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q837', 1),
(155, 'Netherlands Antilles', 'ANT', 'AN', '', '', '', NULL, NULL, NULL, NULL, NULL, '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, NULL, 1),
(156, 'Netherlands The', 'NLD', 'NL', '31', 'Amsterdam', 'EUR', 'Nederland', 'Europe', 'Western Europe', '🇳🇱', 'U+1F1F3 U+1F1F1', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q55', 1),
(157, 'New Caledonia', 'NCL', 'NC', '687', 'Noumea', 'XPF', 'Nouvelle-Calédonie', 'Oceania', 'Melanesia', '🇳🇨', 'U+1F1F3 U+1F1E8', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, NULL, 1),
(158, 'New Zealand', 'NZL', 'NZ', '64', 'Wellington', 'NZD', 'New Zealand', 'Oceania', 'Australia and New Zealand', '🇳🇿', 'U+1F1F3 U+1F1FF', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q664', 1),
(159, 'Nicaragua', 'NIC', 'NI', '505', 'Managua', 'NIO', 'Nicaragua', 'Americas', 'Central America', '🇳🇮', 'U+1F1F3 U+1F1EE', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q811', 1),
(160, 'Niger', 'NER', 'NE', '227', 'Niamey', 'XOF', 'Niger', 'Africa', 'Western Africa', '🇳🇪', 'U+1F1F3 U+1F1EA', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q1032', 1),
(161, 'Nigeria', 'NGA', 'NG', '234', 'Abuja', 'NGN', 'Nigeria', 'Africa', 'Western Africa', '🇳🇬', 'U+1F1F3 U+1F1EC', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q1033', 1),
(162, 'Niue', 'NIU', 'NU', '683', 'Alofi', 'NZD', 'Niuē', 'Oceania', 'Polynesia', '🇳🇺', 'U+1F1F3 U+1F1FA', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q34020', 1),
(163, 'Norfolk Island', 'NFK', 'NF', '672', 'Kingston', 'AUD', 'Norfolk Island', 'Oceania', 'Australia and New Zealand', '🇳🇫', 'U+1F1F3 U+1F1EB', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, NULL, 1),
(164, 'Northern Mariana Islands', 'MNP', 'MP', '+1-670', 'Saipan', 'USD', 'Northern Mariana Islands', 'Oceania', 'Micronesia', '🇲🇵', 'U+1F1F2 U+1F1F5', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, NULL, 1),
(165, 'Norway', 'NOR', 'NO', '47', 'Oslo', 'NOK', 'Norge', 'Europe', 'Northern Europe', '🇳🇴', 'U+1F1F3 U+1F1F4', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q20', 1),
(166, 'Oman', 'OMN', 'OM', '968', 'Muscat', 'OMR', 'عمان', 'Asia', 'Western Asia', '🇴🇲', 'U+1F1F4 U+1F1F2', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q842', 1),
(167, 'Pakistan', 'PAK', 'PK', '92', 'Islamabad', 'PKR', 'Pakistan', 'Asia', 'Southern Asia', '🇵🇰', 'U+1F1F5 U+1F1F0', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q843', 1),
(168, 'Palau', 'PLW', 'PW', '680', 'Melekeok', 'USD', 'Palau', 'Oceania', 'Micronesia', '🇵🇼', 'U+1F1F5 U+1F1FC', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q695', 1),
(169, 'Palestinian Territory Occupied', 'PSE', 'PS', '970', 'East Jerusalem', 'ILS', 'فلسطين', 'Asia', 'Western Asia', '🇵🇸', 'U+1F1F5 U+1F1F8', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, NULL, 1),
(170, 'Panama', 'PAN', 'PA', '507', 'Panama City', 'PAB', 'Panamá', 'Americas', 'Central America', '🇵🇦', 'U+1F1F5 U+1F1E6', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q804', 1),
(171, 'Papua new Guinea', 'PNG', 'PG', '675', 'Port Moresby', 'PGK', 'Papua Niugini', 'Oceania', 'Melanesia', '🇵🇬', 'U+1F1F5 U+1F1EC', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q691', 1),
(172, 'Paraguay', 'PRY', 'PY', '595', 'Asuncion', 'PYG', 'Paraguay', 'Americas', 'South America', '🇵🇾', 'U+1F1F5 U+1F1FE', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q733', 1),
(173, 'Peru', 'PER', 'PE', '51', 'Lima', 'PEN', 'Perú', 'Americas', 'South America', '🇵🇪', 'U+1F1F5 U+1F1EA', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q419', 1),
(174, 'Philippines', 'PHL', 'PH', '63', 'Manila', 'PHP', 'Pilipinas', 'Asia', 'South-Eastern Asia', '🇵🇭', 'U+1F1F5 U+1F1ED', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q928', 1),
(175, 'Pitcairn Island', 'PCN', 'PN', '870', 'Adamstown', 'NZD', 'Pitcairn Islands', 'Oceania', 'Polynesia', '🇵🇳', 'U+1F1F5 U+1F1F3', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, NULL, 1),
(176, 'Poland', 'POL', 'PL', '48', 'Warsaw', 'PLN', 'Polska', 'Europe', 'Eastern Europe', '🇵🇱', 'U+1F1F5 U+1F1F1', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q36', 1),
(177, 'Portugal', 'PRT', 'PT', '351', 'Lisbon', 'EUR', 'Portugal', 'Europe', 'Southern Europe', '🇵🇹', 'U+1F1F5 U+1F1F9', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q45', 1),
(178, 'Puerto Rico', 'PRI', 'PR', '+1-787 and 1-939', 'San Juan', 'USD', 'Puerto Rico', 'Americas', 'Caribbean', '🇵🇷', 'U+1F1F5 U+1F1F7', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, NULL, 1),
(179, 'Qatar', 'QAT', 'QA', '974', 'Doha', 'QAR', 'قطر', 'Asia', 'Western Asia', '🇶🇦', 'U+1F1F6 U+1F1E6', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q846', 1),
(180, 'Reunion', 'REU', 'RE', '262', 'Saint-Denis', 'EUR', 'La Réunion', 'Africa', 'Eastern Africa', '🇷🇪', 'U+1F1F7 U+1F1EA', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, NULL, 1),
(181, 'Romania', 'ROU', 'RO', '40', 'Bucharest', 'RON', 'România', 'Europe', 'Eastern Europe', '🇷🇴', 'U+1F1F7 U+1F1F4', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q218', 1),
(182, 'Russia', 'RUS', 'RU', '7', 'Moscow', 'RUB', 'Россия', 'Europe', 'Eastern Europe', '🇷🇺', 'U+1F1F7 U+1F1FA', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q159', 1),
(183, 'Rwanda', 'RWA', 'RW', '250', 'Kigali', 'RWF', 'Rwanda', 'Africa', 'Eastern Africa', '🇷🇼', 'U+1F1F7 U+1F1FC', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q1037', 1),
(184, 'Saint Helena', 'SHN', 'SH', '290', 'Jamestown', 'SHP', 'Saint Helena', 'Africa', 'Western Africa', '🇸🇭', 'U+1F1F8 U+1F1ED', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, NULL, 1),
(185, 'Saint Kitts And Nevis', 'KNA', 'KN', '+1-869', 'Basseterre', 'XCD', 'Saint Kitts and Nevis', 'Americas', 'Caribbean', '🇰🇳', 'U+1F1F0 U+1F1F3', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q763', 1),
(186, 'Saint Lucia', 'LCA', 'LC', '+1-758', 'Castries', 'XCD', 'Saint Lucia', 'Americas', 'Caribbean', '🇱🇨', 'U+1F1F1 U+1F1E8', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q760', 1),
(187, 'Saint Pierre and Miquelon', 'SPM', 'PM', '508', 'Saint-Pierre', 'EUR', 'Saint-Pierre-et-Miquelon', 'Americas', 'Northern America', '🇵🇲', 'U+1F1F5 U+1F1F2', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, NULL, 1),
(188, 'Saint Vincent And The Grenadines', 'VCT', 'VC', '+1-784', 'Kingstown', 'XCD', 'Saint Vincent and the Grenadines', 'Americas', 'Caribbean', '🇻🇨', 'U+1F1FB U+1F1E8', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q757', 1),
(189, 'Saint-Barthelemy', 'BLM', 'BL', '590', 'Gustavia', 'EUR', 'Saint-Barthélemy', 'Americas', 'Caribbean', '🇧🇱', 'U+1F1E7 U+1F1F1', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, NULL, 1),
(190, 'Saint-Martin (French part)', 'MAF', 'MF', '590', 'Marigot', 'EUR', 'Saint-Martin', 'Americas', 'Caribbean', '🇲🇫', 'U+1F1F2 U+1F1EB', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, NULL, 1),
(191, 'Samoa', 'WSM', 'WS', '685', 'Apia', 'WST', 'Samoa', 'Oceania', 'Polynesia', '🇼🇸', 'U+1F1FC U+1F1F8', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q683', 1),
(192, 'San Marino', 'SMR', 'SM', '378', 'San Marino', 'EUR', 'San Marino', 'Europe', 'Southern Europe', '🇸🇲', 'U+1F1F8 U+1F1F2', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q238', 1),
(193, 'Sao Tome and Principe', 'STP', 'ST', '239', 'Sao Tome', 'STD', 'São Tomé e Príncipe', 'Africa', 'Middle Africa', '🇸🇹', 'U+1F1F8 U+1F1F9', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q1039', 1),
(194, 'Saudi Arabia', 'SAU', 'SA', '966', 'Riyadh', 'SAR', 'العربية السعودية', 'Asia', 'Western Asia', '🇸🇦', 'U+1F1F8 U+1F1E6', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q851', 1),
(195, 'Senegal', 'SEN', 'SN', '221', 'Dakar', 'XOF', 'Sénégal', 'Africa', 'Western Africa', '🇸🇳', 'U+1F1F8 U+1F1F3', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q1041', 1),
(196, 'Serbia', 'SRB', 'RS', '381', 'Belgrade', 'RSD', 'Србија', 'Europe', 'Southern Europe', '🇷🇸', 'U+1F1F7 U+1F1F8', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q403', 1),
(197, 'Seychelles', 'SYC', 'SC', '248', 'Victoria', 'SCR', 'Seychelles', 'Africa', 'Eastern Africa', '🇸🇨', 'U+1F1F8 U+1F1E8', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q1042', 1),
(198, 'Sierra Leone', 'SLE', 'SL', '232', 'Freetown', 'SLL', 'Sierra Leone', 'Africa', 'Western Africa', '🇸🇱', 'U+1F1F8 U+1F1F1', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q1044', 1),
(199, 'Singapore', 'SGP', 'SG', '65', 'Singapur', 'SGD', 'Singapore', 'Asia', 'South-Eastern Asia', '🇸🇬', 'U+1F1F8 U+1F1EC', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q334', 1),
(200, 'Slovakia', 'SVK', 'SK', '421', 'Bratislava', 'EUR', 'Slovensko', 'Europe', 'Eastern Europe', '🇸🇰', 'U+1F1F8 U+1F1F0', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q214', 1),
(201, 'Slovenia', 'SVN', 'SI', '386', 'Ljubljana', 'EUR', 'Slovenija', 'Europe', 'Southern Europe', '🇸🇮', 'U+1F1F8 U+1F1EE', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q215', 1),
(202, 'Solomon Islands', 'SLB', 'SB', '677', 'Honiara', 'SBD', 'Solomon Islands', 'Oceania', 'Melanesia', '🇸🇧', 'U+1F1F8 U+1F1E7', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q685', 1),
(203, 'Somalia', 'SOM', 'SO', '252', 'Mogadishu', 'SOS', 'Soomaaliya', 'Africa', 'Eastern Africa', '🇸🇴', 'U+1F1F8 U+1F1F4', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q1045', 1),
(204, 'South Africa', 'ZAF', 'ZA', '27', 'Pretoria', 'ZAR', 'South Africa', 'Africa', 'Southern Africa', '🇿🇦', 'U+1F1FF U+1F1E6', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q258', 1),
(205, 'South Georgia', 'SGS', 'GS', '', 'Grytviken', 'GBP', 'South Georgia', 'Americas', 'South America', '🇬🇸', 'U+1F1EC U+1F1F8', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, NULL, 1),
(206, 'South Sudan', 'SSD', 'SS', '211', 'Juba', 'SSP', 'South Sudan', 'Africa', 'Middle Africa', '🇸🇸', 'U+1F1F8 U+1F1F8', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q958', 1),
(207, 'Spain', 'ESP', 'ES', '34', 'Madrid', 'EUR', 'España', 'Europe', 'Southern Europe', '🇪🇸', 'U+1F1EA U+1F1F8', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q29', 1),
(208, 'Sri Lanka', 'LKA', 'LK', '94', 'Colombo', 'LKR', 'śrī laṃkāva', 'Asia', 'Southern Asia', '🇱🇰', 'U+1F1F1 U+1F1F0', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q854', 1),
(209, 'Sudan', 'SDN', 'SD', '249', 'Khartoum', 'SDG', 'السودان', 'Africa', 'Northern Africa', '🇸🇩', 'U+1F1F8 U+1F1E9', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q1049', 1),
(210, 'Suriname', 'SUR', 'SR', '597', 'Paramaribo', 'SRD', 'Suriname', 'Americas', 'South America', '🇸🇷', 'U+1F1F8 U+1F1F7', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q730', 1),
(211, 'Svalbard And Jan Mayen Islands', 'SJM', 'SJ', '47', 'Longyearbyen', 'NOK', 'Svalbard og Jan Mayen', 'Europe', 'Northern Europe', '🇸🇯', 'U+1F1F8 U+1F1EF', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, NULL, 1),
(212, 'Swaziland', 'SWZ', 'SZ', '268', 'Mbabane', 'SZL', 'Swaziland', 'Africa', 'Southern Africa', '🇸🇿', 'U+1F1F8 U+1F1FF', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q1050', 1),
(213, 'Sweden', 'SWE', 'SE', '46', 'Stockholm', 'SEK', 'Sverige', 'Europe', 'Northern Europe', '🇸🇪', 'U+1F1F8 U+1F1EA', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q34', 1),
(214, 'Switzerland', 'CHE', 'CH', '41', 'Berne', 'CHF', 'Schweiz', 'Europe', 'Western Europe', '🇨🇭', 'U+1F1E8 U+1F1ED', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q39', 1),
(215, 'Syria', 'SYR', 'SY', '963', 'Damascus', 'SYP', 'سوريا', 'Asia', 'Western Asia', '🇸🇾', 'U+1F1F8 U+1F1FE', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q858', 1),
(216, 'Taiwan', 'TWN', 'TW', '886', 'Taipei', 'TWD', '臺灣', 'Asia', 'Eastern Asia', '🇹🇼', 'U+1F1F9 U+1F1FC', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q865', 1),
(217, 'Tajikistan', 'TJK', 'TJ', '992', 'Dushanbe', 'TJS', 'Тоҷикистон', 'Asia', 'Central Asia', '🇹🇯', 'U+1F1F9 U+1F1EF', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q863', 1),
(218, 'Tanzania', 'TZA', 'TZ', '255', 'Dodoma', 'TZS', 'Tanzania', 'Africa', 'Eastern Africa', '🇹🇿', 'U+1F1F9 U+1F1FF', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q924', 1),
(219, 'Thailand', 'THA', 'TH', '66', 'Bangkok', 'THB', 'ประเทศไทย', 'Asia', 'South-Eastern Asia', '🇹🇭', 'U+1F1F9 U+1F1ED', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q869', 1),
(220, 'Togo', 'TGO', 'TG', '228', 'Lome', 'XOF', 'Togo', 'Africa', 'Western Africa', '🇹🇬', 'U+1F1F9 U+1F1EC', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q945', 1),
(221, 'Tokelau', 'TKL', 'TK', '690', '', 'NZD', 'Tokelau', 'Oceania', 'Polynesia', '🇹🇰', 'U+1F1F9 U+1F1F0', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, NULL, 1),
(222, 'Tonga', 'TON', 'TO', '676', 'Nuku\'alofa', 'TOP', 'Tonga', 'Oceania', 'Polynesia', '🇹🇴', 'U+1F1F9 U+1F1F4', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q678', 1),
(223, 'Trinidad And Tobago', 'TTO', 'TT', '+1-868', 'Port of Spain', 'TTD', 'Trinidad and Tobago', 'Americas', 'Caribbean', '🇹🇹', 'U+1F1F9 U+1F1F9', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q754', 1),
(224, 'Tunisia', 'TUN', 'TN', '216', 'Tunis', 'TND', 'تونس', 'Africa', 'Northern Africa', '🇹🇳', 'U+1F1F9 U+1F1F3', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q948', 1),
(225, 'Turkey', 'TUR', 'TR', '90', 'Ankara', 'TRY', 'Türkiye', 'Asia', 'Western Asia', '🇹🇷', 'U+1F1F9 U+1F1F7', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q43', 1),
(226, 'Turkmenistan', 'TKM', 'TM', '993', 'Ashgabat', 'TMT', 'Türkmenistan', 'Asia', 'Central Asia', '🇹🇲', 'U+1F1F9 U+1F1F2', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q874', 1),
(227, 'Turks And Caicos Islands', 'TCA', 'TC', '+1-649', 'Cockburn Town', 'USD', 'Turks and Caicos Islands', 'Americas', 'Caribbean', '🇹🇨', 'U+1F1F9 U+1F1E8', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, NULL, 1),
(228, 'Tuvalu', 'TUV', 'TV', '688', 'Funafuti', 'AUD', 'Tuvalu', 'Oceania', 'Polynesia', '🇹🇻', 'U+1F1F9 U+1F1FB', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q672', 1),
(229, 'Uganda', 'UGA', 'UG', '256', 'Kampala', 'UGX', 'Uganda', 'Africa', 'Eastern Africa', '🇺🇬', 'U+1F1FA U+1F1EC', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q1036', 1),
(230, 'Ukraine', 'UKR', 'UA', '380', 'Kiev', 'UAH', 'Україна', 'Europe', 'Eastern Europe', '🇺🇦', 'U+1F1FA U+1F1E6', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q212', 1),
(231, 'United Arab Emirates', 'ARE', 'AE', '971', 'Abu Dhabi', 'AED', 'دولة الإمارات العربية المتحدة', 'Asia', 'Western Asia', '🇦🇪', 'U+1F1E6 U+1F1EA', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q878', 1),
(232, 'United Kingdom', 'GBR', 'GB', '44', 'London', 'GBP', 'United Kingdom', 'Europe', 'Northern Europe', '🇬🇧', 'U+1F1EC U+1F1E7', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q145', 1),
(233, 'United States', 'USA', 'US', '1', 'Washington', 'USD', 'United States', 'Americas', 'Northern America', '🇺🇸', 'U+1F1FA U+1F1F8', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q30', 1),
(234, 'United States Minor Outlying Islands', 'UMI', 'UM', '1', '', 'USD', 'United States Minor Outlying Islands', 'Americas', 'Northern America', '🇺🇲', 'U+1F1FA U+1F1F2', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, NULL, 1),
(235, 'Uruguay', 'URY', 'UY', '598', 'Montevideo', 'UYU', 'Uruguay', 'Americas', 'South America', '🇺🇾', 'U+1F1FA U+1F1FE', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q77', 1),
(236, 'Uzbekistan', 'UZB', 'UZ', '998', 'Tashkent', 'UZS', 'O‘zbekiston', 'Asia', 'Central Asia', '🇺🇿', 'U+1F1FA U+1F1FF', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q265', 1),
(237, 'Vanuatu', 'VUT', 'VU', '678', 'Port Vila', 'VUV', 'Vanuatu', 'Oceania', 'Melanesia', '🇻🇺', 'U+1F1FB U+1F1FA', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q686', 1),
(238, 'Vatican City State (Holy See)', 'VAT', 'VA', '379', 'Vatican City', 'EUR', 'Vaticano', 'Europe', 'Southern Europe', '🇻🇦', 'U+1F1FB U+1F1E6', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q237', 1),
(239, 'Venezuela', 'VEN', 'VE', '58', 'Caracas', 'VEF', 'Venezuela', 'Americas', 'South America', '🇻🇪', 'U+1F1FB U+1F1EA', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q717', 1),
(240, 'Vietnam', 'VNM', 'VN', '84', 'Hanoi', 'VND', 'Việt Nam', 'Asia', 'South-Eastern Asia', '🇻🇳', 'U+1F1FB U+1F1F3', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q881', 1),
(241, 'Virgin Islands (British)', 'VGB', 'VG', '+1-284', 'Road Town', 'USD', 'British Virgin Islands', 'Americas', 'Caribbean', '🇻🇬', 'U+1F1FB U+1F1EC', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, NULL, 1),
(242, 'Virgin Islands (US)', 'VIR', 'VI', '+1-340', 'Charlotte Amalie', 'USD', 'United States Virgin Islands', 'Americas', 'Caribbean', '🇻🇮', 'U+1F1FB U+1F1EE', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, NULL, 1),
(243, 'Wallis And Futuna Islands', 'WLF', 'WF', '681', 'Mata Utu', 'XPF', 'Wallis et Futuna', 'Oceania', 'Polynesia', '🇼🇫', 'U+1F1FC U+1F1EB', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, NULL, 1),
(244, 'Western Sahara', 'ESH', 'EH', '212', 'El-Aaiun', 'MAD', 'الصحراء الغربية', 'Africa', 'Northern Africa', '🇪🇭', 'U+1F1EA U+1F1ED', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, NULL, 1),
(245, 'Yemen', 'YEM', 'YE', '967', 'Sanaa', 'YER', 'اليَمَن', 'Asia', 'Western Asia', '🇾🇪', 'U+1F1FE U+1F1EA', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q805', 1),
(246, 'Zambia', 'ZMB', 'ZM', '260', 'Lusaka', 'ZMW', 'Zambia', 'Africa', 'Eastern Africa', '🇿🇲', 'U+1F1FF U+1F1F2', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q953', 1),
(247, 'Zimbabwe', 'ZWE', 'ZW', '263', 'Harare', 'ZWL', 'Zimbabwe', 'Africa', 'Eastern Africa', '🇿🇼', 'U+1F1FF U+1F1FC', '2018-07-20 20:11:03', '2020-11-09 08:45:25', 1, 'Q954', 1),
(248, 'Kosovo', 'XKX', 'XK', '383', 'Pristina', 'EUR', 'Republika e Kosovës', 'Europe', 'Eastern Europe', '🇽🇰', 'U+1F1FD U+1F1F0', '2020-08-15 15:33:50', '2020-11-09 08:45:25', 1, 'Q1246', 1),
(249, 'Curaçao', 'CUW', 'CW', '599', 'Willemstad', 'ANG', 'Curaçao', 'Americas', 'Caribbean', '🇨🇼', 'U+1F1E8 U+1F1FC', '2020-10-25 14:54:20', '2020-11-09 08:45:25', 1, 'Q25279', 1);

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

--
-- Table structure for table `coupon`
--

CREATE TABLE `coupon` (
  `id` int(11) NOT NULL,
  `coupon_code` varchar(255) NOT NULL,
  `discount` int(11) NOT NULL COMMENT 'value would be in percentage',
  `expiry_date` date NOT NULL,
  `limit_users` int(100) NOT NULL,
  `created` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `coupon_used`
--

CREATE TABLE `coupon_used` (
  `id` int(11) NOT NULL,
  `order_id` int(11) NOT NULL,
  `coupon_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `created` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `daily_checkin`
--

CREATE TABLE `daily_checkin` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `coin` int(11) NOT NULL,
  `created` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `delivery_address`
--

CREATE TABLE `delivery_address` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `lat` varchar(255) NOT NULL,
  `long` varchar(255) NOT NULL,
  `city` varchar(255) NOT NULL,
  `state` varchar(255) NOT NULL,
  `country_id` int(11) NOT NULL,
  `zip` varchar(255) NOT NULL,
  `street` varchar(255) NOT NULL,
  `apartment` varchar(255) NOT NULL,
  `instructions` text NOT NULL,
  `default` int(11) NOT NULL,
  `place_id` varchar(255) NOT NULL,
  `location_string` varchar(255) NOT NULL,
  `label` varchar(255) NOT NULL,
  `created` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `email_verification`
--

CREATE TABLE `email_verification` (
  `id` int(11) NOT NULL,
  `email` varchar(255) NOT NULL,
  `code` int(11) NOT NULL,
  `created` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `follower`
--

CREATE TABLE `follower` (
  `id` int(11) NOT NULL,
  `sender_id` int(11) NOT NULL,
  `receiver_id` int(11) NOT NULL,
  `notification` int(11) NOT NULL DEFAULT '1' COMMENT '1- enabled, 0 - disable',
  `promotion_id` int(11) NOT NULL,
  `created` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `gift`
--

CREATE TABLE `gift` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `image` varchar(255) NOT NULL,
  `coin` int(11) NOT NULL,
  `type` varchar(255) NOT NULL COMMENT 'gif',
  `sound` varchar(255) NOT NULL,
  `icon` varchar(255) NOT NULL,
  `time` int(11) NOT NULL,
  `position` varchar(255) NOT NULL,
  `featured` int(11) NOT NULL,
  `created` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `gift_send`
--

CREATE TABLE `gift_send` (
  `id` int(11) NOT NULL,
  `gift_id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `coin` int(11) NOT NULL,
  `image` varchar(255) NOT NULL,
  `sender_id` int(11) NOT NULL,
  `receiver_id` int(11) NOT NULL,
  `created` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `hashtag`
--

CREATE TABLE `hashtag` (
  `id` int(11) NOT NULL,
  `name` varchar(255) CHARACTER SET utf8 NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `hashtag_favourite`
--

CREATE TABLE `hashtag_favourite` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `hashtag_id` int(11) NOT NULL,
  `created` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `hashtag_video`
--

CREATE TABLE `hashtag_video` (
  `id` int(11) NOT NULL,
  `hashtag_id` int(11) NOT NULL,
  `video_id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `html_page`
--

CREATE TABLE `html_page` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `text` text NOT NULL,
  `created` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `html_page`
--

INSERT INTO `html_page` (`id`, `name`, `text`, `created`) VALUES
(1, 'privacyPolicy', '&lt;p&gt;We want you to understand the types of information we collect as you use our services&lt;/p&gt;\r\n\r\n&lt;p&gt;We collect information to provide better services to all our users &amp;mdash; from figuring out basic stuff like which language you speak, to more complex things like which &lt;a class=&quot;g1mG8c&quot; href=&quot;https://policies.google.com/privacy?hl=en-US#footnote-useful-ads&quot;&gt;ads you&amp;rsquo;ll find most useful&lt;/a&gt;, &lt;a class=&quot;g1mG8c&quot; href=&quot;https://policies.google.com/privacy?hl=en-US#footnote-people-online&quot;&gt;the people who matter most to you online&lt;/a&gt;, or which YouTube videos you might like. The information Google collects, and how that information is used, depends on how you use our services and how you manage your privacy controls.&lt;/p&gt;\r\n\r\n&lt;p&gt;When you&amp;rsquo;re not signed in to a Google Account, we store the information we collect with &lt;a class=&quot;g1mG8c&quot; href=&quot;https://policies.google.com/privacy?hl=en-US#footnote-unique-id&quot;&gt;unique identifiers&lt;/a&gt; tied to the browser, application, or &lt;a class=&quot;g1mG8c&quot; href=&quot;https://policies.google.com/privacy?hl=en-US#footnote-device&quot;&gt;device&lt;/a&gt; you&amp;rsquo;re using. This helps us do things like maintain your language preferences across browsing sessions.&lt;/p&gt;\r\n\r\n&lt;p&gt;When you&amp;rsquo;re signed in, we also collect information that we store with your Google Account, which we treat as &lt;a class=&quot;g1mG8c&quot; href=&quot;https://policies.google.com/privacy?hl=en-US#footnote-personal-info&quot;&gt;personal information&lt;/a&gt;.&lt;/p&gt;\r\n\r\n&lt;h2&gt;Things you create or provide to us&lt;/h2&gt;\r\n\r\n&lt;div class=&quot;pjyxF&quot;&gt;&lt;img alt=&quot;&quot; class=&quot;zZLvvc&quot; src=&quot;https://www.gstatic.com/policies/privacy/d1b68e2cd423aba52d74f02573df2d2d.svg&quot; /&gt;&lt;/div&gt;\r\n\r\n&lt;p&gt;When you create a Google Account, you provide us with &lt;a class=&quot;g1mG8c&quot; href=&quot;https://policies.google.com/privacy?hl=en-US#footnote-personal-info&quot;&gt;personal information&lt;/a&gt; that includes your name and a password. You can also choose to add a &lt;a class=&quot;g1mG8c&quot; href=&quot;https://policies.google.com/privacy?hl=en-US#footnote-phone-number&quot;&gt;phone number&lt;/a&gt; or &lt;a class=&quot;g1mG8c&quot; href=&quot;https://policies.google.com/privacy?hl=en-US#footnote-payment-info&quot;&gt;payment information&lt;/a&gt; to your account. Even if you aren&amp;rsquo;t signed in to a Google Account, you might choose to provide us with information &amp;mdash; like an email address to receive updates about our services.&lt;/p&gt;\r\n\r\n&lt;p&gt;We also collect the content you create, upload, or receive from others when using our services. This includes things like email you write and receive, photos and videos you save, docs and spreadsheets you create, and comments you make on YouTube videos.&lt;/p&gt;\r\n\r\n&lt;h2&gt;Information we collect as you use our services&lt;/h2&gt;\r\n\r\n&lt;h3&gt;Your apps, browsers &amp;amp; devices&lt;/h3&gt;\r\n\r\n&lt;div class=&quot;pjyxF&quot;&gt;&lt;img alt=&quot;&quot; class=&quot;zZLvvc&quot; src=&quot;https://www.gstatic.com/policies/privacy/e79ea0ed464fc8952d5b5582f9f9ae53.svg&quot; /&gt;&lt;/div&gt;\r\n\r\n&lt;p&gt;We collect information about the apps, browsers, and &lt;a class=&quot;g1mG8c&quot; href=&quot;https://policies.google.com/privacy?hl=en-US#footnote-devices&quot;&gt;devices&lt;/a&gt; you use to access Google services, which helps us provide features like automatic product updates and dimming your screen if your battery runs low.&lt;/p&gt;\r\n\r\n&lt;p&gt;The information we collect includes &lt;a class=&quot;g1mG8c&quot; href=&quot;https://policies.google.com/privacy?hl=en-US#footnote-unique-id&quot;&gt;unique identifiers&lt;/a&gt;, browser type and settings, device type and settings, operating system, mobile network information including carrier name and phone number, and application version number. We also collect information about the interaction of your apps, browsers, and devices with our services, including &lt;a class=&quot;g1mG8c&quot; href=&quot;https://policies.google.com/privacy?hl=en-US#footnote-ip&quot;&gt;IP address&lt;/a&gt;, crash reports, system activity, and the date, time, and &lt;a class=&quot;g1mG8c&quot; href=&quot;https://policies.google.com/privacy?hl=en-US#footnote-referrer-url&quot;&gt;referrer URL&lt;/a&gt; of your request.&lt;/p&gt;\r\n\r\n&lt;p&gt;We collect this information when a Google service on your device contacts our servers &amp;mdash; for example, when you install an app from the Play Store or when a service checks for automatic updates. If you&amp;rsquo;re using an &lt;a class=&quot;g1mG8c&quot; href=&quot;https://policies.google.com/privacy?hl=en-US#footnote-android-device&quot;&gt;Android device with Google apps&lt;/a&gt;, your device periodically contacts Google servers to provide information about your device and connection to our services. This information includes things like your device type, carrier name, crash reports, and which apps you&amp;#39;ve installed.&lt;/p&gt;\r\n\r\n&lt;h3&gt;Your activity&lt;/h3&gt;\r\n\r\n&lt;div class=&quot;pjyxF&quot;&gt;&lt;img alt=&quot;&quot; class=&quot;zZLvvc&quot; src=&quot;https://www.gstatic.com/policies/privacy/39b031d352a2e1586cf50ac7f2bbc18b.svg&quot; /&gt;&lt;/div&gt;\r\n\r\n&lt;p&gt;We collect information about your activity in our services, which we use to do things like recommend a YouTube video you might like. The activity information we collect may include:&lt;/p&gt;\r\n\r\n&lt;ul&gt;\r\n	&lt;li&gt;Terms you search for&lt;/li&gt;\r\n	&lt;li&gt;Videos you watch&lt;/li&gt;\r\n	&lt;li&gt;&lt;a class=&quot;g1mG8c&quot; href=&quot;https://policies.google.com/privacy?hl=en-US#footnote-content-views&quot;&gt;Views and interactions with content and ads&lt;/a&gt;&lt;/li&gt;\r\n	&lt;li&gt;Voice and audio information when you use audio features&lt;/li&gt;\r\n	&lt;li&gt;Purchase activity&lt;/li&gt;\r\n	&lt;li&gt;People with whom you communicate or share content&lt;/li&gt;\r\n	&lt;li&gt;Activity on third-party sites and apps that use our services&lt;/li&gt;\r\n	&lt;li&gt;Chrome browsing history you&amp;rsquo;ve &lt;a class=&quot;g1mG8c&quot; href=&quot;https://policies.google.com/privacy?hl=en-US#footnote-chrome-sync&quot;&gt;synced with your Google Account&lt;/a&gt;&lt;/li&gt;\r\n&lt;/ul&gt;\r\n\r\n&lt;p&gt;If you use our &lt;a class=&quot;g1mG8c&quot; href=&quot;https://policies.google.com/privacy?hl=en-US#footnote-calls-messages&quot;&gt;services to make and receive calls or send and receive messages&lt;/a&gt;, we may collect telephony log information like your phone number, calling-party number, receiving-party number, forwarding numbers, time and date of calls and messages, duration of calls, routing information, and types of calls.&lt;/p&gt;\r\n\r\n&lt;p&gt;You can visit your Google Account to find and manage activity information that&amp;rsquo;s saved in your account.&lt;/p&gt;\r\n', '2020-11-25 23:47:05'),
(2, 'termsConditions', '&lt;p&gt;You have choices regarding the information we collect and how it&amp;#39;s used&lt;/p&gt;\r\n\r\n&lt;p&gt;This section describes key controls for managing your privacy across our services. You can also visit the &lt;a class=&quot;XddVQ&quot; href=&quot;https://myaccount.google.com/privacycheckup?utm_source=pp&amp;amp;utm_medium=Promo-in-product&amp;amp;utm_campaign=pp_body&amp;amp;hl=en_US&quot; target=&quot;_blank&quot;&gt;Privacy Checkup&lt;/a&gt;, which provides an opportunity to review and adjust important privacy settings. In addition to these tools, we also offer specific privacy settings in our products &amp;mdash; you can learn more in our &lt;a href=&quot;https://policies.google.com/technologies/product-privacy?hl=en-US&quot;&gt;Product Privacy Guide&lt;/a&gt;.&lt;/p&gt;\r\n\r\n&lt;div class=&quot;h0yEnd&quot;&gt;\r\n&lt;div class=&quot;IN2z4b&quot;&gt;&lt;img alt=&quot;&quot; class=&quot;mZPFM&quot; src=&quot;https://www.gstatic.com/policies/privacy/2951277d4c35389d7d304ed78d4fb6f6.svg&quot; /&gt;&lt;/div&gt;\r\n\r\n&lt;div class=&quot;gwGFXb&quot;&gt;\r\n&lt;p&gt;&lt;a class=&quot;ky8S2&quot; href=&quot;https://myaccount.google.com/privacycheckup?utm_source=pp&amp;amp;utm_medium=Promo-in-product&amp;amp;utm_campaign=pp_body&amp;amp;hl=en_US&quot;&gt;Go to Privacy Checkup&lt;/a&gt;&lt;/p&gt;\r\n&lt;/div&gt;\r\n&lt;/div&gt;\r\n\r\n&lt;h2&gt;Managing, reviewing, and updating your information&lt;/h2&gt;\r\n\r\n&lt;p&gt;When you&amp;rsquo;re signed in, you can always review and update information by visiting the services you use. For example, Photos and Drive are both designed to help you manage specific types of content you&amp;rsquo;ve saved with Google.&lt;/p&gt;\r\n\r\n&lt;p&gt;We also built a place for you to review and control information saved in your Google Account. Your &lt;a class=&quot;XddVQ&quot; href=&quot;https://myaccount.google.com/?hl=en_US&quot; target=&quot;_blank&quot;&gt;Google Account&lt;/a&gt; includes:&lt;/p&gt;\r\n\r\n&lt;h3&gt;Privacy controls&lt;/h3&gt;\r\n\r\n&lt;div class=&quot;WTetv adRtod h0yEnd&quot;&gt;\r\n&lt;div class=&quot;IN2z4b&quot;&gt;&lt;img alt=&quot;&quot; class=&quot;mZPFM uTLSAb&quot; src=&quot;https://www.gstatic.com/policies/privacy/3394102be0315326fd760e503b31c7b6.svg&quot; /&gt;&lt;/div&gt;\r\n\r\n&lt;div class=&quot;gwGFXb&quot;&gt;\r\n&lt;h3&gt;Activity Controls&lt;/h3&gt;\r\n\r\n&lt;p&gt;Decide what types of activity you&amp;rsquo;d like saved in your account. For example, you can turn on Location History if you want traffic predictions for your daily commute, or you can save your YouTube Watch History to get better video suggestions.&lt;/p&gt;\r\n\r\n&lt;p&gt;&lt;a class=&quot;ky8S2&quot; href=&quot;https://myaccount.google.com/activitycontrols?utm_source=pp&amp;amp;hl=en_US&quot;&gt;Go to Activity Controls&lt;/a&gt;&lt;/p&gt;\r\n&lt;/div&gt;\r\n&lt;/div&gt;\r\n\r\n&lt;div class=&quot;h0yEnd&quot;&gt;\r\n&lt;div class=&quot;IN2z4b&quot;&gt;&lt;img alt=&quot;&quot; class=&quot;mZPFM uTLSAb&quot; src=&quot;https://www.gstatic.com/policies/privacy/900a793eae04f4bddd675f8d95c4a794.svg&quot; /&gt;&lt;/div&gt;\r\n\r\n&lt;div class=&quot;gwGFXb&quot;&gt;\r\n&lt;h3&gt;Ad settings&lt;/h3&gt;\r\n\r\n&lt;p&gt;Manage your preferences about the ads shown to you on Google and on sites and apps that &lt;a class=&quot;g1mG8c&quot; href=&quot;https://policies.google.com/privacy?hl=en-US#footnote-partner&quot;&gt;partner with Google&lt;/a&gt; to show ads. You can modify your interests, choose whether your personal information is used to make ads more relevant to you, and turn on or off certain advertising services.&lt;/p&gt;\r\n\r\n&lt;p&gt;&lt;a class=&quot;ky8S2&quot; href=&quot;https://adssettings.google.com/?utm_source=pp&amp;amp;hl=en_US&quot;&gt;Go to Ad Settings&lt;/a&gt;&lt;/p&gt;\r\n&lt;/div&gt;\r\n&lt;/div&gt;\r\n\r\n&lt;div class=&quot;h0yEnd&quot;&gt;\r\n&lt;div class=&quot;IN2z4b&quot;&gt;&lt;img alt=&quot;&quot; class=&quot;mZPFM uTLSAb&quot; src=&quot;https://www.gstatic.com/policies/privacy/c1b97d74dace7e43a9ccb26841a7cae4.svg&quot; /&gt;&lt;/div&gt;\r\n\r\n&lt;div class=&quot;gwGFXb&quot;&gt;\r\n&lt;h3&gt;About you&lt;/h3&gt;\r\n\r\n&lt;p&gt;Control what others see about you across Google services.&lt;/p&gt;\r\n\r\n&lt;p&gt;&lt;a class=&quot;ky8S2&quot; href=&quot;https://myaccount.google.com/profile?utm_source=pp&amp;amp;hl=en_US&quot;&gt;Go to About You&lt;/a&gt;&lt;/p&gt;\r\n&lt;/div&gt;\r\n&lt;/div&gt;\r\n\r\n&lt;div class=&quot;h0yEnd&quot;&gt;\r\n&lt;div class=&quot;IN2z4b&quot;&gt;&lt;img alt=&quot;&quot; class=&quot;mZPFM uTLSAb&quot; src=&quot;https://www.gstatic.com/policies/privacy/e28714c71f217892f72b2698ea5cefef.svg&quot; /&gt;&lt;/div&gt;\r\n\r\n&lt;div class=&quot;gwGFXb&quot;&gt;\r\n&lt;h3&gt;Shared endorsements&lt;/h3&gt;\r\n\r\n&lt;p&gt;Choose whether your name and photo appear next to your activity, like reviews and recommendations, that appear in ads.&lt;/p&gt;\r\n\r\n&lt;p&gt;&lt;a class=&quot;ky8S2&quot; href=&quot;https://myaccount.google.com/shared-endorsements?utm_source=pp&amp;amp;hl=en_US&quot;&gt;Go to Shared Endorsements&lt;/a&gt;&lt;/p&gt;\r\n&lt;/div&gt;\r\n&lt;/div&gt;\r\n\r\n&lt;h3&gt;Ways to review &amp;amp; update your information&lt;/h3&gt;\r\n\r\n&lt;div class=&quot;WTetv adRtod h0yEnd&quot;&gt;\r\n&lt;div class=&quot;IN2z4b&quot;&gt;&lt;img alt=&quot;&quot; class=&quot;mZPFM uTLSAb&quot; src=&quot;https://www.gstatic.com/policies/privacy/5e7cd445f8861a262a3da876f855a4cc.svg&quot; /&gt;&lt;/div&gt;\r\n\r\n&lt;div class=&quot;gwGFXb&quot;&gt;\r\n&lt;h3&gt;My Activity&lt;/h3&gt;\r\n\r\n&lt;p&gt;My Activity allows you to review and control data that&amp;rsquo;s created when you use Google services, like searches you&amp;rsquo;ve done or your visits to Google Play. You can browse by date and by topic, and delete part or all of your activity.&lt;/p&gt;\r\n\r\n&lt;p&gt;&lt;a class=&quot;ky8S2&quot; href=&quot;https://myactivity.google.com/myactivity?utm_source=pp&amp;amp;hl=en_US&quot;&gt;Go to My Activity&lt;/a&gt;&lt;/p&gt;\r\n&lt;/div&gt;\r\n&lt;/div&gt;\r\n\r\n&lt;div class=&quot;h0yEnd&quot;&gt;\r\n&lt;div class=&quot;IN2z4b&quot;&gt;&lt;img alt=&quot;&quot; class=&quot;mZPFM uTLSAb&quot; src=&quot;https://www.gstatic.com/policies/privacy/02698a3383765bd3c250471c53a86c5a.svg&quot; /&gt;&lt;/div&gt;\r\n\r\n&lt;div class=&quot;gwGFXb&quot;&gt;\r\n&lt;h3&gt;Google Dashboard&lt;/h3&gt;\r\n\r\n&lt;p&gt;Google Dashboard allows you to manage information associated with specific products.&lt;/p&gt;\r\n\r\n&lt;p&gt;&lt;a class=&quot;ky8S2&quot; href=&quot;https://myaccount.google.com/dashboard?utm_source=pp&amp;amp;hl=en_US&quot;&gt;Go to Dashboard&lt;/a&gt;&lt;/p&gt;\r\n&lt;/div&gt;\r\n&lt;/div&gt;\r\n\r\n&lt;div class=&quot;h0yEnd&quot;&gt;\r\n&lt;div class=&quot;IN2z4b&quot;&gt;&lt;img alt=&quot;&quot; class=&quot;mZPFM uTLSAb&quot; src=&quot;https://www.gstatic.com/policies/privacy/4f19891c43001db11efc8048f9bc7cdb.svg&quot; /&gt;&lt;/div&gt;\r\n\r\n&lt;div class=&quot;gwGFXb&quot;&gt;\r\n&lt;h3&gt;Your personal information&lt;/h3&gt;\r\n\r\n&lt;p&gt;Manage your contact information, such as your name, email, and phone number.&lt;/p&gt;\r\n\r\n&lt;p&gt;&lt;a class=&quot;ky8S2&quot; href=&quot;https://myaccount.google.com/personal-info?utm_source=pp&amp;amp;hl=en_US&quot;&gt;Go to Personal Info&lt;/a&gt;&lt;/p&gt;\r\n&lt;/div&gt;\r\n&lt;/div&gt;\r\n\r\n&lt;p&gt;When you&amp;rsquo;re signed out, you can manage information associated with your browser or device, including:&lt;/p&gt;\r\n\r\n&lt;ul&gt;\r\n	&lt;li&gt;Signed-out search personalization: &lt;a class=&quot;XddVQ&quot; href=&quot;https://www.google.com/history/optout?utm_source=pp&amp;amp;hl=en_US&quot; target=&quot;_blank&quot;&gt;Choose&lt;/a&gt; whether your search activity is used to offer you more relevant results and recommendations.&lt;/li&gt;\r\n	&lt;li&gt;YouTube settings: Pause and delete your &lt;a class=&quot;XddVQ&quot; href=&quot;https://www.youtube.com/feed/history/search_history?utm_source=pp&amp;amp;hl=en_US&quot; target=&quot;_blank&quot;&gt;YouTube Search History&lt;/a&gt; and your &lt;a class=&quot;XddVQ&quot; href=&quot;https://www.youtube.com/feed/history?utm_source=pp&amp;amp;hl=en_US&quot; target=&quot;_blank&quot;&gt;YouTube Watch History&lt;/a&gt;.&lt;/li&gt;\r\n	&lt;li&gt;Ad Settings: &lt;a class=&quot;XddVQ&quot; href=&quot;https://adssettings.google.com/?utm_source=pp&amp;amp;hl=en_US&quot; target=&quot;_blank&quot;&gt;Manage&lt;/a&gt; your preferences about the ads shown to you on Google and on sites and apps that partner with Google to show ads.&lt;/li&gt;\r\n&lt;/ul&gt;\r\n\r\n&lt;h2&gt;Exporting, removing &amp;amp; deleting your information&lt;/h2&gt;\r\n\r\n&lt;p&gt;You can export a copy of content in your Google Account if you want to back it up or use it with a service outside of Google.&lt;/p&gt;\r\n\r\n&lt;div class=&quot;h0yEnd&quot;&gt;\r\n&lt;div class=&quot;IN2z4b&quot;&gt;&lt;img alt=&quot;&quot; class=&quot;mZPFM&quot; src=&quot;https://www.gstatic.com/policies/privacy/5959e84c2197c8a27da0a717f1cd47d5.svg&quot; /&gt;&lt;/div&gt;\r\n\r\n&lt;div class=&quot;gwGFXb&quot;&gt;\r\n&lt;p&gt;&lt;a class=&quot;ky8S2&quot; href=&quot;https://takeout.google.com/?utm_source=pp&amp;amp;hl=en_US&quot;&gt;Export your data&lt;/a&gt;&lt;/p&gt;\r\n&lt;/div&gt;\r\n&lt;/div&gt;\r\n\r\n&lt;p&gt;You can also &lt;a class=&quot;XddVQ&quot; href=&quot;https://support.google.com/legal?p=privpol_remove&amp;amp;hl=en_US&quot; target=&quot;_blank&quot;&gt;request to remove content&lt;/a&gt; from specific Google services based on applicable law.&lt;/p&gt;\r\n\r\n&lt;p&gt;To delete your information, you can:&lt;/p&gt;\r\n\r\n&lt;ul&gt;\r\n	&lt;li&gt;Delete your content from &lt;a class=&quot;g1mG8c&quot; href=&quot;https://policies.google.com/privacy?hl=en-US#footnote-delete-specific&quot;&gt;specific Google services&lt;/a&gt;&lt;/li&gt;\r\n	&lt;li&gt;Search for and then delete specific items from your account using &lt;a class=&quot;XddVQ&quot; href=&quot;https://myactivity.google.com/?utm_source=pp&amp;amp;hl=en_US&quot; target=&quot;_blank&quot;&gt;My Activity&lt;/a&gt;&lt;/li&gt;\r\n	&lt;li&gt;&lt;a class=&quot;XddVQ&quot; href=&quot;https://myaccount.google.com/deleteservices?utm_source=pp&amp;amp;hl=en_US&quot; target=&quot;_blank&quot;&gt;Delete specific Google products&lt;/a&gt;, including your information associated with those products&lt;/li&gt;\r\n	&lt;li&gt;&lt;a class=&quot;XddVQ&quot; href=&quot;https://myaccount.google.com/deleteaccount?utm_source=pp&amp;amp;hl=en_US&quot; target=&quot;_blank&quot;&gt;Delete your entire Google Account&lt;/a&gt;&lt;/li&gt;\r\n&lt;/ul&gt;\r\n\r\n&lt;div class=&quot;h0yEnd&quot;&gt;\r\n&lt;div class=&quot;IN2z4b&quot;&gt;&lt;img alt=&quot;&quot; class=&quot;mZPFM&quot; src=&quot;https://www.gstatic.com/policies/privacy/1fa3e4ce8ac456f39ed02a6f9eb49b14.svg&quot; /&gt;&lt;/div&gt;\r\n\r\n&lt;div class=&quot;gwGFXb&quot;&gt;\r\n&lt;p&gt;&lt;a class=&quot;ky8S2&quot; href=&quot;https://myaccount.google.com/delete-services-or-account?utm_source=pp&amp;amp;hl=en_US&quot;&gt;Delete your information&lt;/a&gt;&lt;/p&gt;\r\n&lt;/div&gt;\r\n&lt;/div&gt;\r\n\r\n&lt;p&gt;And finally, &lt;a class=&quot;XddVQ&quot; href=&quot;https://myaccount.google.com/inactive?utm_source=pp&amp;amp;hl=en_US&quot; target=&quot;_blank&quot;&gt;Inactive Account Manager&lt;/a&gt; allows you to give someone else access to parts of your Google Account in case you&amp;rsquo;re unexpectedly unable to use your account.&lt;/p&gt;\r\n', '2020-11-25 23:47:33');

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

--
-- Table structure for table `interest`
--

CREATE TABLE `interest` (
  `id` int(11) NOT NULL,
  `interest_section_id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `order` int(11) NOT NULL,
  `created` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `interest`
--

INSERT INTO `interest` (`id`, `interest_section_id`, `title`, `order`, `created`) VALUES
(1, 1, 'Cricket', 0, '2024-10-16 16:14:56'),
(2, 1, 'soccer', 0, '2024-10-16 16:14:56'),
(3, 2, 'hollywood', 0, '2024-10-16 16:14:56'),
(4, 2, 'indian', 0, '2024-10-16 16:14:56');

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

--
-- Table structure for table `interest_section`
--

CREATE TABLE `interest_section` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `order` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `interest_section`
--

INSERT INTO `interest_section` (`id`, `title`, `order`) VALUES
(1, 'Sports', 0),
(2, 'Entertainment', 0);

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

--
-- Table structure for table `live_streaming`
--

CREATE TABLE `live_streaming` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `started_at` datetime NOT NULL,
  `ended_at` datetime NOT NULL,
  `duration` int(11) NOT NULL COMMENT 'in seconds',
  `created` datetime NOT NULL,
  `earn_coin` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `live_streaming_watch`
--

CREATE TABLE `live_streaming_watch` (
  `id` int(11) NOT NULL,
  `live_streaming_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `started_at` datetime NOT NULL,
  `ended_at` datetime NOT NULL,
  `duration` int(11) NOT NULL COMMENT 'in seconds',
  `block` int(11) NOT NULL,
  `coin` int(11) NOT NULL,
  `created` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `location`
--

CREATE TABLE `location` (
  `id` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `string` varchar(255) NOT NULL,
  `lat` varchar(255) NOT NULL,
  `long` varchar(255) NOT NULL,
  `google_place_id` text NOT NULL,
  `image` varchar(255) NOT NULL,
  `created` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `notification`
--

CREATE TABLE `notification` (
  `id` int(11) NOT NULL,
  `sender_id` int(11) NOT NULL,
  `receiver_id` int(11) NOT NULL,
  `string` varchar(255) COLLATE utf8mb4_bin NOT NULL,
  `type` varchar(20) COLLATE utf8mb4_bin NOT NULL,
  `video_id` int(11) NOT NULL,
  `live_streaming_id` int(11) NOT NULL,
  `room_id` int(11) NOT NULL,
  `status` varchar(255) COLLATE utf8mb4_bin NOT NULL,
  `read` int(11) NOT NULL,
  `created` datetime NOT NULL,
  `order_id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

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

--
-- Table structure for table `not_interested_video`
--

CREATE TABLE `not_interested_video` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `video_id` int(11) NOT NULL,
  `created` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `order`
--

CREATE TABLE `order` (
  `id` int(11) NOT NULL,
  `card_id` int(11) NOT NULL,
  `store_id` int(11) NOT NULL,
  `store_user_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `delivery_address_id` int(11) NOT NULL,
  `payment_id` int(11) NOT NULL,
  `delivery` int(11) NOT NULL COMMENT '0-pickup,1 -delivery',
  `transaction_id` varchar(255) NOT NULL,
  `instruction` int(11) NOT NULL,
  `cod` int(11) NOT NULL,
  `tax` float NOT NULL,
  `rider_tip` float NOT NULL,
  `delivery_fee` int(11) NOT NULL,
  `discount` float NOT NULL,
  `note` text NOT NULL,
  `total` float NOT NULL,
  `status` int(11) NOT NULL DEFAULT '0' COMMENT '0= pending ,1 - active,2-completed,3-cancel',
  `delivery_datetime` datetime NOT NULL,
  `signature` varchar(255) NOT NULL,
  `signature_person_name` varchar(255) NOT NULL,
  `device` varchar(255) NOT NULL,
  `version` varchar(255) NOT NULL,
  `cart_random_id` int(11) NOT NULL,
  `video_id` int(11) NOT NULL,
  `completed_datetime` datetime NOT NULL,
  `created` datetime NOT NULL,
  `earned` int(11) NOT NULL,
  `pickup` int(11) NOT NULL,
  `subtotal` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `order_product`
--

CREATE TABLE `order_product` (
  `id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `order_id` int(11) NOT NULL,
  `product_title` varchar(255) NOT NULL,
  `product_price` float NOT NULL,
  `product_quantity` float NOT NULL,
  `product_image` varchar(255) NOT NULL,
  `product_attritube_combination_id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `order_session`
--

CREATE TABLE `order_session` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `string` text NOT NULL,
  `created` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `order_transaction`
--

CREATE TABLE `order_transaction` (
  `id` int(11) NOT NULL,
  `cart_random_id` int(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  `value` varchar(255) NOT NULL,
  `created` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `payment_card`
--

CREATE TABLE `payment_card` (
  `id` int(11) NOT NULL,
  `stripe` varchar(255) NOT NULL,
  `last_4` int(11) NOT NULL,
  `brand` varchar(255) NOT NULL,
  `exp_month` int(11) NOT NULL,
  `exp_year` int(11) NOT NULL,
  `created` datetime NOT NULL,
  `user_id` int(11) NOT NULL,
  `default` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `phone_no_verification`
--

CREATE TABLE `phone_no_verification` (
  `id` int(11) NOT NULL,
  `phone_no` varchar(20) NOT NULL,
  `code` int(4) NOT NULL,
  `created` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `playlist`
--

CREATE TABLE `playlist` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `created` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `playlist_video`
--

CREATE TABLE `playlist_video` (
  `id` int(11) NOT NULL,
  `playlist_id` int(11) NOT NULL,
  `video_id` int(11) NOT NULL,
  `order` int(11) NOT NULL,
  `created` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `privacy_setting`
--

CREATE TABLE `privacy_setting` (
  `id` int(11) NOT NULL,
  `videos_download` int(11) NOT NULL DEFAULT '1',
  `direct_message` varchar(255) NOT NULL,
  `duet` varchar(255) NOT NULL,
  `liked_videos` varchar(255) NOT NULL,
  `video_comment` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `product`
--

CREATE TABLE `product` (
  `id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `size` int(11) NOT NULL COMMENT 'in kg',
  `price` decimal(10,2) NOT NULL,
  `sale_price` decimal(10,2) NOT NULL,
  `promote` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  `view` int(11) NOT NULL,
  `order_no` varchar(255) NOT NULL,
  `condition` varchar(255) NOT NULL,
  `delivery_method` int(11) NOT NULL COMMENT '1 - pickup, 2-meetup',
  `meetup_location_lat` varchar(255) NOT NULL,
  `meetup_location_long` varchar(255) NOT NULL,
  `meetup_location_string` varchar(255) NOT NULL,
  `updated` datetime NOT NULL,
  `created` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `product_attribute`
--

CREATE TABLE `product_attribute` (
  `id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `created` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `product_attribute_combination`
--

CREATE TABLE `product_attribute_combination` (
  `id` int(11) NOT NULL,
  `combination_string` varchar(255) NOT NULL,
  `sku` int(11) NOT NULL,
  `price` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `available_stock` int(11) NOT NULL,
  `created` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `product_attribute_variation`
--

CREATE TABLE `product_attribute_variation` (
  `id` int(11) NOT NULL,
  `product_attribute_id` int(11) NOT NULL,
  `value` varchar(255) NOT NULL,
  `price` int(11) NOT NULL,
  `created` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `product_category`
--

CREATE TABLE `product_category` (
  `id` int(11) NOT NULL,
  `title` varchar(80) NOT NULL,
  `parent_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `product_favourite`
--

CREATE TABLE `product_favourite` (
  `id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `created` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `product_image`
--

CREATE TABLE `product_image` (
  `id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `image` varchar(255) NOT NULL,
  `thum` varchar(255) NOT NULL,
  `created` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `product_rating`
--

CREATE TABLE `product_rating` (
  `id` int(11) NOT NULL,
  `star` int(11) NOT NULL,
  `comment` varchar(255) NOT NULL,
  `created` datetime NOT NULL,
  `user_id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `order_id` int(11) NOT NULL,
  `language_id` int(11) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `profile_visit`
--

CREATE TABLE `profile_visit` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `visitor_id` int(11) NOT NULL,
  `read` int(11) NOT NULL,
  `created` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `promotion`
--

CREATE TABLE `promotion` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `video_id` int(11) NOT NULL,
  `website_url` varchar(255) NOT NULL,
  `start_datetime` datetime NOT NULL,
  `end_datetime` datetime NOT NULL,
  `coin` int(11) NOT NULL,
  `active` int(11) NOT NULL,
  `destination` varchar(255) NOT NULL COMMENT 'website / follower/views',
  `action_button` varchar(255) NOT NULL,
  `destination_tap` int(11) NOT NULL,
  `followers` int(11) NOT NULL,
  `reach` int(11) NOT NULL,
  `total_reach` int(11) NOT NULL COMMENT 'no of users',
  `clicks` int(11) NOT NULL,
  `audience_id` int(11) NOT NULL,
  `payment_card_id` int(11) NOT NULL,
  `created` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `purchase_coin`
--

CREATE TABLE `purchase_coin` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `coin` int(11) NOT NULL,
  `price` float NOT NULL,
  `transaction_id` varchar(255) NOT NULL,
  `device` varchar(255) NOT NULL,
  `created` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `push_notification`
--

CREATE TABLE `push_notification` (
  `id` int(11) NOT NULL,
  `likes` int(11) NOT NULL,
  `comments` int(11) NOT NULL,
  `new_followers` int(11) NOT NULL,
  `mentions` int(11) NOT NULL,
  `direct_messages` int(11) NOT NULL,
  `video_updates` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `referral_used`
--

CREATE TABLE `referral_used` (
  `id` int(11) NOT NULL,
  `referral_owner` int(11) NOT NULL,
  `used_by` int(11) NOT NULL,
  `created` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `report_product`
--

CREATE TABLE `report_product` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `report_reason_title` varchar(255) NOT NULL,
  `product_id` int(11) NOT NULL,
  `report_reason_id` int(11) NOT NULL,
  `description` text NOT NULL,
  `created` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `report_reason`
--

CREATE TABLE `report_reason` (
  `id` int(11) NOT NULL,
  `title` text NOT NULL,
  `created` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `report_reason`
--

INSERT INTO `report_reason` (`id`, `title`, `created`) VALUES
(3, 'Spam', '2020-11-25 14:27:48'),
(4, 'Offensive content', '2020-11-25 14:27:58'),
(5, 'Violent or graphic content', '2020-11-25 14:28:17'),
(6, 'Intellectual property infringement', '2020-11-25 14:28:43'),
(7, 'Fraud or scam', '2020-11-25 14:28:55'),
(8, 'Dangerous goods or services', '2020-11-25 14:29:20'),
(9, 'Others', '2020-11-25 14:29:27');

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

--
-- Table structure for table `report_room`
--

CREATE TABLE `report_room` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `report_reason_title` varchar(255) NOT NULL,
  `room_id` int(11) NOT NULL,
  `report_reason_id` int(11) NOT NULL,
  `description` text NOT NULL,
  `created` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `report_user`
--

CREATE TABLE `report_user` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `report_reason_title` varchar(255) NOT NULL,
  `report_user_id` int(11) NOT NULL,
  `report_reason_id` int(11) NOT NULL,
  `description` text NOT NULL,
  `created` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `report_video`
--

CREATE TABLE `report_video` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `video_id` int(11) NOT NULL,
  `report_reason_title` varchar(255) NOT NULL,
  `report_reason_id` int(11) NOT NULL,
  `description` text NOT NULL,
  `created` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `repost_video`
--

CREATE TABLE `repost_video` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `video_id` int(11) NOT NULL,
  `created` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `room`
--

CREATE TABLE `room` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_bin NOT NULL,
  `privacy` int(11) NOT NULL COMMENT '0-open,1-social,2-closed',
  `room_id` int(11) NOT NULL,
  `topic_id` int(11) NOT NULL,
  `delete` int(11) NOT NULL,
  `created` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

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

--
-- Table structure for table `room_member`
--

CREATE TABLE `room_member` (
  `id` int(11) NOT NULL,
  `room_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `moderator` int(11) NOT NULL COMMENT '2- speaker',
  `created` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `setting`
--

CREATE TABLE `setting` (
  `id` int(11) NOT NULL,
  `type` varchar(255) NOT NULL,
  `value` varchar(255) NOT NULL,
  `created` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `setting`
--

INSERT INTO `setting` (`id`, `type`, `value`, `created`) VALUES
(4, 'referral_coin', '10', '2023-06-08 08:20:03'),
(6, 'show_advert_after', '5', '2023-06-08 08:20:03'),
(14, 'coin_worth', '0.1', '2023-06-21 06:41:46'),
(15, 'add_type', 'admob', '2023-06-21 06:54:20'),
(17, 'video_compression', '2000', '2023-06-21 11:28:28');

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

--
-- Table structure for table `shipping_rate`
--

CREATE TABLE `shipping_rate` (
  `id` int(11) NOT NULL,
  `country_id` int(2) NOT NULL,
  `weight_min` decimal(10,2) NOT NULL,
  `weight_max` decimal(10,2) NOT NULL,
  `quantity_min` int(11) NOT NULL,
  `quantity_max` int(11) NOT NULL,
  `order_price` int(11) NOT NULL,
  `shipping_fee` decimal(10,2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `shop_slider`
--

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

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

--
-- Table structure for table `sound`
--

CREATE TABLE `sound` (
  `id` int(11) NOT NULL,
  `audio` varchar(255) NOT NULL,
  `duration` varchar(20) NOT NULL,
  `name` varchar(250) CHARACTER SET utf8 NOT NULL,
  `description` varchar(150) CHARACTER SET utf8 NOT NULL,
  `thum` varchar(500) NOT NULL,
  `sound_section_id` int(11) NOT NULL,
  `uploaded_by` varchar(150) NOT NULL,
  `publish` int(11) NOT NULL,
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `sound_favourite`
--

CREATE TABLE `sound_favourite` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `sound_id` int(11) NOT NULL,
  `created` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `sound_section`
--

CREATE TABLE `sound_section` (
  `id` int(11) NOT NULL,
  `name` varchar(255) CHARACTER SET utf8 NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `states`
--

CREATE TABLE `states` (
  `id` mediumint(8) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `country_id` mediumint(8) UNSIGNED NOT NULL,
  `country_code` char(2) COLLATE utf8mb4_unicode_ci NOT NULL,
  `fips_code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `short_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `flag` tinyint(1) NOT NULL DEFAULT '1',
  `wikiDataId` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Rapid API GeoDB Cities',
  `active` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT;

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

--
-- Table structure for table `sticker`
--

CREATE TABLE `sticker` (
  `id` int(11) NOT NULL,
  `image` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `type` int(11) NOT NULL COMMENT '0-image, 1 - gif',
  `used_count` int(11) NOT NULL,
  `created` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `sticker_used`
--

CREATE TABLE `sticker_used` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `sticker_id` int(11) NOT NULL,
  `created` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `topic`
--

CREATE TABLE `topic` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `image` varchar(255) NOT NULL,
  `view` int(11) NOT NULL,
  `created` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `topic`
--

INSERT INTO `topic` (`id`, `title`, `image`, `view`, `created`) VALUES
(1, 'Entertainment', '', 0, '0000-00-00 00:00:00'),
(5, 'good', '', 0, '2023-05-11 10:36:00'),
(6, 'good1', '', 0, '2023-05-11 10:38:17'),
(7, 'good12', '', 0, '2023-05-11 10:38:31'),
(8, 'home', '', 0, '2023-05-12 12:06:49');

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

--
-- Table structure for table `user_document`
--

CREATE TABLE `user_document` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `identification` varchar(255) NOT NULL,
  `indentification_approve` int(11) NOT NULL,
  `vehicle_registration` varchar(255) NOT NULL,
  `vehicle_registration_approve` int(11) NOT NULL,
  `driving_license` varchar(255) NOT NULL,
  `driving_license_approve` int(11) NOT NULL,
  `vehicle_insurance` varchar(255) NOT NULL,
  `vehicle_insurance_approve` int(11) NOT NULL,
  `updated` datetime NOT NULL,
  `created` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `user_interest`
--

CREATE TABLE `user_interest` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `interest_id` int(11) NOT NULL,
  `created` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `verification_request`
--

CREATE TABLE `verification_request` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `attachment` varchar(255) NOT NULL,
  `verified` int(11) NOT NULL COMMENT '0-pending,1 - accept.2 -rejected',
  `update_time` datetime NOT NULL,
  `created` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `video_comment_like`
--

CREATE TABLE `video_comment_like` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `comment_id` int(11) NOT NULL,
  `created` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `video_comment_reply`
--

CREATE TABLE `video_comment_reply` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `comment_id` int(11) NOT NULL,
  `comment` longtext COLLATE utf8mb4_bin NOT NULL,
  `video_id` int(11) NOT NULL,
  `created` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

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

--
-- Table structure for table `video_comment_reply_like`
--

CREATE TABLE `video_comment_reply_like` (
  `id` int(11) NOT NULL,
  `comment_reply_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `created` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `video_favourite`
--

CREATE TABLE `video_favourite` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `video_id` int(11) NOT NULL,
  `created` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `video_like`
--

CREATE TABLE `video_like` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `video_id` int(11) NOT NULL,
  `created` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `video_product`
--

CREATE TABLE `video_product` (
  `id` int(11) NOT NULL,
  `video_id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `created` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `video_watch`
--

CREATE TABLE `video_watch` (
  `id` int(11) NOT NULL,
  `device_id` int(11) NOT NULL,
  `video_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `created` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `withdraw_request`
--

CREATE TABLE `withdraw_request` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `amount` float NOT NULL,
  `status` int(11) NOT NULL COMMENT '0-pending, 1 - approve',
  `updated` datetime NOT NULL,
  `coin` int(11) NOT NULL,
  `email` varchar(255) NOT NULL,
  `created` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `follower`
--
ALTER TABLE `follower`
  ADD PRIMARY KEY (`id`),
  ADD KEY `receiver_id` (`receiver_id`,`sender_id`) USING BTREE,
  ADD KEY `sender_id` (`sender_id`,`receiver_id`);

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

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

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

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

--
-- Indexes for table `hashtag_video`
--
ALTER TABLE `hashtag_video`
  ADD PRIMARY KEY (`id`),
  ADD KEY `hashtag_id` (`hashtag_id`,`video_id`);

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

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

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

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

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

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

--
-- Indexes for table `notification`
--
ALTER TABLE `notification`
  ADD PRIMARY KEY (`id`),
  ADD KEY `receiver_id` (`receiver_id`,`sender_id`) USING BTREE,
  ADD KEY `sender_id` (`sender_id`,`receiver_id`);

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

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

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

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

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

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

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

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

--
-- Indexes for table `playlist_video`
--
ALTER TABLE `playlist_video`
  ADD PRIMARY KEY (`id`),
  ADD KEY `playlist_id` (`playlist_id`,`video_id`);

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

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

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

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

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

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

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

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

--
-- Indexes for table `product_rating`
--
ALTER TABLE `product_rating`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_rating_restaurant_user1_idx` (`user_id`),
  ADD KEY `fk_rating_restaurant_restaurant1_idx` (`product_id`);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `sound`
--
ALTER TABLE `sound`
  ADD PRIMARY KEY (`id`),
  ADD KEY `name` (`name`),
  ADD KEY `description` (`description`),
  ADD KEY `sound_section_id` (`sound_section_id`),
  ADD KEY `id` (`id`);

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

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

--
-- Indexes for table `states`
--
ALTER TABLE `states`
  ADD PRIMARY KEY (`id`),
  ADD KEY `country_region` (`country_id`);

--
-- Indexes for table `sticker`
--
ALTER TABLE `sticker`
  ADD PRIMARY KEY (`id`),
  ADD KEY `type` (`type`);

--
-- Indexes for table `sticker_used`
--
ALTER TABLE `sticker_used`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sticker_id` (`sticker_id`);

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

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

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

--
-- Indexes for table `video_comment_like`
--
ALTER TABLE `video_comment_like`
  ADD PRIMARY KEY (`id`),
  ADD KEY `comment_id` (`comment_id`);

--
-- Indexes for table `video_comment_reply`
--
ALTER TABLE `video_comment_reply`
  ADD PRIMARY KEY (`id`),
  ADD KEY `comment_id` (`comment_id`);

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

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

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

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

--
-- Indexes for table `video_watch`
--
ALTER TABLE `video_watch`
  ADD PRIMARY KEY (`id`),
  ADD KEY `device_id` (`device_id`),
  ADD KEY `video_id` (`video_id`),
  ADD KEY `user_id` (`user_id`,`video_id`);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `states`
--
ALTER TABLE `states`
  MODIFY `id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT;

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

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

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

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

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

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

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

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

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

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

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

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

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

