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

START TRANSACTION;



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

--
-- Table structure for table `admin_logs`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `admin_logs` (
  `id` int(100) NOT NULL AUTO_INCREMENT,
  `admin_id` int(100) NOT NULL,
  `work` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `work_id` int(255) NOT NULL,
  `date` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `admin_notifications`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `admin_notifications` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `seller_id` int(10) NOT NULL,
  `content_id` int(10) NOT NULL,
  `proposal_id` int(10) NOT NULL,
  `reason` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `date` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `admin_rights`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `admin_rights` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `admin_id` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `settings` int(11) NOT NULL,
  `plugins` int(10) NOT NULL,
  `pages` int(11) NOT NULL,
  `blog` int(10) NOT NULL,
  `feedback` int(10) NOT NULL,
  `video_schedules` int(10) NOT NULL,
  `proposals` int(11) NOT NULL,
  `accounting` int(10) NOT NULL,
  `payouts` int(10) NOT NULL,
  `reports` int(11) NOT NULL,
  `inbox` int(11) NOT NULL,
  `reviews` int(11) NOT NULL,
  `buyer_requests` int(11) NOT NULL,
  `restricted_words` int(11) NOT NULL,
  `notifications` int(11) NOT NULL,
  `cats` int(11) NOT NULL,
  `delivery_times` int(11) NOT NULL,
  `seller_languages` int(11) NOT NULL,
  `seller_skills` int(11) NOT NULL,
  `seller_levels` int(10) NOT NULL,
  `customer_support` int(11) NOT NULL,
  `coupons` int(11) NOT NULL,
  `slides` int(11) NOT NULL,
  `terms` int(11) NOT NULL,
  `sellers` int(11) NOT NULL,
  `orders` int(11) NOT NULL,
  `referrals` int(11) NOT NULL,
  `files` int(11) NOT NULL,
  `knowledge_bank` int(10) NOT NULL,
  `currencies` int(10) NOT NULL,
  `languages` int(11) NOT NULL,
  `admins` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `admin_rights`
--

INSERT INTO `admin_rights` (`id`, `admin_id`, `settings`, `plugins`, `pages`, `blog`, `feedback`, `video_schedules`, `proposals`, `accounting`, `payouts`, `reports`, `inbox`, `reviews`, `buyer_requests`, `restricted_words`, `notifications`, `cats`, `delivery_times`, `seller_languages`, `seller_skills`, `seller_levels`, `customer_support`, `coupons`, `slides`, `terms`, `sellers`, `orders`, `referrals`, `files`, `knowledge_bank`, `currencies`, `languages`, `admins`) VALUES
(1, '1', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1);

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

--
-- Table structure for table `announcement_bar`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `announcement_bar` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `enable_bar` int(10) NOT NULL,
  `bg_color` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `text_color` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `bar_text` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_updated` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `language_id` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `announcement_bar`
--

INSERT INTO `announcement_bar` (`id`, `enable_bar`, `bg_color`, `text_color`, `bar_text`, `last_updated`, `language_id`) VALUES
(1, 0, '#2ca35b', '#ffffff', '', '', 1);

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

--
-- Table structure for table `app_info`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `app_info` (
  `id` int(100) NOT NULL AUTO_INCREMENT,
  `version` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `r_date` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `app_info`
--

INSERT INTO `app_info` (`id`, `version`, `r_date`) VALUES
(1, '1.5.3', '07 December 2020');

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

--
-- Table structure for table `app_license`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `app_license` (
  `id` int(100) NOT NULL AUTO_INCREMENT,
  `purchase_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `license_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `website` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `app_license`
--

INSERT INTO `app_license` (`id`, `purchase_code`, `license_type`, `website`) VALUES
(1, 'Fuck You', 'Cracked', 'kodi.al');

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

--
-- Table structure for table `archived_messages`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `archived_messages` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `seller_id` int(10) NOT NULL,
  `message_group_id` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `article_cat`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `article_cat` (
  `article_cat_id` int(11) NOT NULL AUTO_INCREMENT,
  `language_id` int(10) NOT NULL,
  `article_cat_title` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `position` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`article_cat_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `buyer_requests`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `buyer_requests` (
  `request_id` int(10) NOT NULL AUTO_INCREMENT,
  `seller_id` int(10) NOT NULL,
  `cat_id` int(10) NOT NULL,
  `child_id` int(10) NOT NULL,
  `request_title` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `request_description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `request_file` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `delivery_time` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `request_budget` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `request_date` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `request_status` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `isS3` int(10) NOT NULL,
  PRIMARY KEY (`request_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `buyer_reviews`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `buyer_reviews` (
  `review_id` int(10) NOT NULL AUTO_INCREMENT,
  `proposal_id` int(10) NOT NULL,
  `order_id` int(10) NOT NULL,
  `review_buyer_id` int(10) NOT NULL,
  `buyer_rating` int(10) NOT NULL,
  `buyer_review` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `review_seller_id` int(10) NOT NULL,
  `review_date` text COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`review_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `cart`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `cart` (
  `cart_id` int(10) NOT NULL AUTO_INCREMENT,
  `seller_id` int(10) NOT NULL,
  `proposal_id` int(10) NOT NULL,
  `proposal_price` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `proposal_qty` int(10) NOT NULL,
  `delivery_id` int(10) NOT NULL,
  `revisions` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `coupon_used` int(100) NOT NULL,
  PRIMARY KEY (`cart_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `cart_extras`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `cart_extras` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `seller_id` int(10) NOT NULL,
  `proposal_id` int(10) NOT NULL,
  `name` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `price` text COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `categories`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `categories` (
  `cat_id` int(10) NOT NULL AUTO_INCREMENT,
  `cat_url` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `cat_image` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `cat_featured` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `enable_watermark` int(10) NOT NULL,
  `isS3` int(10) NOT NULL,
  PRIMARY KEY (`cat_id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `categories` (`cat_id`, `cat_url`, `cat_image`, `cat_featured`, `enable_watermark`, `isS3`) VALUES
(1, 'graphics-design', 'p1.png', 'yes', 0, 0),
(2, 'digital-marketing', 'p2.png', 'yes', 0, 0),
(3, 'writing-translation', 'p3.png', 'yes', 0, 0),
(4, 'video-animation', 'p4.png', 'yes', 0, 0),
(6, 'programming-tech', 'p5.png', 'yes', 0, 0),
(7, 'business', 'p6.png', 'yes', 0, 0),
(8, 'fun-lifestyle', 'p7.png', 'yes', 0, 0),
(9, 'music-audio', 'p8.png', 'yes', 0, 0);

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

--
-- Table structure for table `categories_children`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `categories_children` (
  `child_id` int(10) NOT NULL AUTO_INCREMENT,
  `child_url` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `child_parent_id` int(10) NOT NULL,
  PRIMARY KEY (`child_id`)
) ENGINE=InnoDB AUTO_INCREMENT=104 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `categories_children`
--

INSERT INTO `categories_children` (`child_id`, `child_url`, `child_parent_id`) VALUES
(1, 'logo-design', 1),
(2, 'business-cards-amp-stationery', 1),
(3, 'illustration', 1),
(4, 'cartoons-caricatures', 1),
(5, 'flyers-posters', 1),
(6, 'book-covers-packaging', 1),
(7, 'web-amp-mobile-design', 1),
(8, 'social-media-design', 1),
(9, 'banner-ads', 1),
(10, 'social-media-marketing', 2),
(11, 'wordpress', 6),
(12, 'photoshop-editing', 1),
(13, '3d-2d-models', 1),
(14, 't-shirts', 1),
(15, 'presentation-design', 1),
(16, 'other', 1),
(17, 'seo', 2),
(18, 'web-traffic', 2),
(19, 'content-marketing', 2),
(20, 'video-marketing', 2),
(21, 'email-marketing', 2),
(22, 'search-display-marketing', 2),
(23, 'marketing-strategy', 2),
(24, 'web-analytics', 2),
(25, 'influencer-marketing', 2),
(26, 'local-listings', 2),
(27, 'domain-research', 2),
(28, 'e-commerce-marketing', 2),
(29, 'mobile-advertising', 2),
(30, 'resumes-cover-letters', 3),
(31, 'proofreading-editing', 3),
(32, 'translation', 3),
(33, 'creative-writing', 3),
(34, 'business-copywriting', 3),
(35, 'research-summaries', 3),
(36, 'articles-blog-posts', 3),
(37, 'press-releases', 3),
(38, 'transcription', 3),
(39, 'legal-writing', 3),
(40, 'other', 3),
(41, 'whiteboard-explainer-videos', 4),
(42, 'intros-animated-logos', 4),
(43, 'promotional-brand-videos', 4),
(44, 'editing-post-production', 4),
(45, 'lyric-music-videos', 4),
(46, 'spokespersons-testimonials', 4),
(48, 'other', 4),
(49, 'voice-over', 9),
(50, 'mixing-mastering', 9),
(51, 'producers-composers', 9),
(52, 'singer-songwriters', 9),
(53, 'session-musicians-singers', 9),
(54, 'jingles-drops', 9),
(55, 'sound-effects', 9),
(56, 'web-programming', 6),
(58, 'website-builders-cms', 6),
(60, 'ecommerce', 6),
(61, 'mobile-apps-web', 6),
(62, 'desktop-applications', 6),
(63, 'support-it', 6),
(64, 'chatbots', 6),
(65, 'data-analysis-reports', 6),
(66, 'convert-files', 6),
(67, 'databases', 6),
(68, 'user-testing', 6),
(69, 'other', 6),
(70, 'virtual-assistant', 7),
(71, 'market-research', 7),
(72, 'business-plans', 7),
(73, 'branding-services', 7),
(74, 'legal-consulting', 7),
(75, 'financial-consulting', 7),
(76, 'business-tips', 7),
(77, 'presentations', 7),
(78, 'career-advice', 7),
(79, 'flyer-distribution', 7),
(80, 'other', 7),
(81, 'online-lessons', 8),
(82, 'arts-crafts', 8),
(83, 'relationship-advice', 8),
(84, 'health-nutrition-fitness', 8),
(85, 'astrology-readings', 8),
(86, 'spiritual-healing', 8),
(87, 'family-genealogy', 8),
(88, 'collectibles', 8),
(89, 'greeting-cards-videos', 8),
(91, 'viral-videos', 8),
(92, 'pranks-stunts', 8),
(93, 'celebrity-impersonators', 8),
(94, 'other', 8);

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

--
-- Table structure for table `cats_meta`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `cats_meta` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `cat_id` int(10) NOT NULL,
  `language_id` int(10) NOT NULL,
  `cat_title` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `cat_desc` text COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=808 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cats_meta`
--

INSERT INTO `cats_meta` (`id`, `cat_id`, `language_id`, `cat_title`, `cat_desc`) VALUES
(1, 1, 1, 'Graphics & Design', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.'),
(2, 2, 1, 'Digital Marketing', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. '),
(3, 3, 1, 'Writing & Translation', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. '),
(4, 4, 1, 'Video & Animation\r\n', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. '),
(5, 6, 1, 'Programming & Tech\r\n', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. '),
(6, 7, 1, 'Business\r\n', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. '),
(7, 8, 1, 'Fun & Lifestyle\r\n', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. '),
(8, 9, 1, 'Music & Audio', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. ');

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

--
-- Table structure for table `child_cats_meta`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `child_cats_meta` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `child_id` int(10) NOT NULL,
  `child_parent_id` int(10) NOT NULL,
  `language_id` int(10) NOT NULL,
  `child_title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `child_desc` text COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6825 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `child_cats_meta`
--

INSERT INTO `child_cats_meta` (`id`, `child_id`, `child_parent_id`, `language_id`, `child_title`, `child_desc`) VALUES
(1, 1, 1, 1, 'Logo Design', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.'),
(2, 2, 1, 1, 'Business Cards &amp; Stationery', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.'),
(3, 3, 1, 1, 'Illustration', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.'),
(4, 4, 1, 1, 'Cartoons Caricatures', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.'),
(5, 5, 1, 1, 'Flyers Posters', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.'),
(6, 6, 1, 1, 'Book Covers & Packaging', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.'),
(7, 7, 1, 1, 'Web &amp; Mobile Design', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.'),
(8, 8, 1, 1, 'Social Media Design', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.'),
(9, 9, 1, 1, 'Banner Ads', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.'),
(10, 10, 2, 1, 'Social Media Marketing', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.'),
(11, 11, 6, 1, 'WordPress', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.'),
(12, 12, 1, 1, 'Photoshop Editing', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.'),
(13, 13, 1, 1, '3D & 2D Models', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.'),
(14, 14, 1, 1, 'T-Shirts', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.'),
(15, 15, 1, 1, 'Presentation Design', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.'),
(16, 16, 1, 1, 'Other', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.'),
(17, 17, 2, 1, 'SEO', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.'),
(18, 18, 2, 1, 'Web Traffic', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.'),
(19, 19, 2, 1, 'Content Marketing', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.'),
(20, 20, 2, 1, 'Video Marketing', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.'),
(21, 21, 2, 1, 'Email Marketing', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.'),
(22, 22, 2, 1, 'Search & Display Marketing', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.'),
(23, 23, 2, 1, 'Marketing Strategy', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.'),
(24, 24, 2, 1, 'Web Analytics', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.'),
(25, 25, 2, 1, 'Influencer Marketing', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.'),
(26, 26, 2, 1, 'Local Listings', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.'),
(27, 27, 2, 1, 'Domain Research', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.'),
(28, 28, 2, 1, 'E-Commerce Marketing', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.'),
(29, 29, 2, 1, 'Mobile Advertising', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.'),
(30, 30, 3, 1, 'Resumes & Cover Letters', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.'),
(31, 31, 3, 1, 'Proofreading & Editing', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.'),
(32, 32, 3, 1, 'Translation', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.'),
(33, 33, 3, 1, 'Creative Writing', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.'),
(34, 34, 3, 1, 'Business Copywriting', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.'),
(35, 35, 3, 1, 'Research & Summaries', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.'),
(36, 36, 3, 1, 'Articles & Blog Posts', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.'),
(37, 37, 3, 1, 'Press Releases', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.'),
(38, 38, 3, 1, 'Transcription', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.'),
(39, 39, 3, 1, 'Legal Writing', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.'),
(40, 40, 3, 1, 'Other', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.'),
(41, 41, 4, 1, 'Whiteboard & Explainer Videos', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.'),
(42, 42, 4, 1, 'Intros & Animated Logos', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.'),
(43, 43, 4, 1, 'Promotional & Brand Videos', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.'),
(44, 44, 4, 1, 'Editing & Post Production', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.'),
(45, 45, 4, 1, 'Lyric & Music Videos', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.'),
(46, 46, 4, 1, 'Spokespersons & Testimonials', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.'),
(47, 48, 4, 1, 'Other', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.'),
(48, 49, 9, 1, 'Voice Over', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.'),
(49, 50, 9, 1, 'Mixing & Mastering', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.'),
(50, 51, 9, 1, 'Producers & Composers', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.'),
(51, 52, 9, 1, 'Singer-Songwriters', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.'),
(52, 53, 9, 1, 'Session Musicians & Singers', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.'),
(53, 54, 9, 1, 'Jingles & Drops', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.'),
(54, 55, 9, 1, 'Sound Effects', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.'),
(55, 56, 6, 1, 'Web Programming', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.'),
(56, 58, 6, 1, 'Website Builders & CMS', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.'),
(57, 60, 6, 1, 'Ecommerce', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.'),
(58, 61, 6, 1, 'Mobile Apps & Web', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.'),
(59, 62, 6, 1, 'Desktop applications', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.'),
(60, 63, 6, 1, 'Support & IT', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.'),
(61, 64, 6, 1, 'Chatbots', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.'),
(62, 65, 6, 1, 'Data Analysis & Reports', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.'),
(63, 66, 6, 1, 'Convert Files', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.'),
(64, 67, 6, 1, 'Databases', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.'),
(65, 68, 6, 1, 'User Testing', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.'),
(66, 69, 6, 1, 'Other', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.'),
(67, 70, 7, 1, 'Virtual Assistant', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.'),
(68, 71, 7, 1, 'Market Research', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.'),
(69, 72, 7, 1, 'Business Plans', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.'),
(70, 73, 7, 1, 'Branding Services', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.'),
(71, 74, 7, 1, 'Legal Consulting', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.'),
(72, 75, 7, 1, 'Financial Consulting', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.'),
(73, 76, 7, 1, 'Business Tips', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.'),
(74, 77, 7, 1, 'Presentations', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.'),
(75, 78, 7, 1, 'Career Advice', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.'),
(76, 79, 7, 1, 'Flyer Distribution', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.'),
(77, 80, 7, 1, 'Other', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.'),
(78, 81, 8, 1, 'Online Lessons', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.'),
(79, 82, 8, 1, 'Arts & Crafts', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.'),
(80, 83, 8, 1, 'Relationship Advice', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.'),
(81, 84, 8, 1, 'Health, Nutrition & Fitness', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.'),
(82, 85, 8, 1, 'Astrology & Readings', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.'),
(83, 86, 8, 1, 'Spiritual & Healing', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.'),
(84, 87, 8, 1, 'Family & Genealogy', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.'),
(85, 88, 8, 1, 'Collectibles', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.'),
(86, 89, 8, 1, 'Greeting Cards & Videos', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.'),
(87, 91, 8, 1, 'Viral Videos', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.'),
(88, 92, 8, 1, 'Pranks & Stunts', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.'),
(89, 93, 8, 1, 'Celebrity Impersonators', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.'),
(90, 94, 8, 1, 'Other', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.');

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

--
-- Table structure for table `comments`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `comments` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `idea_id` int(100) NOT NULL,
  `seller_id` int(100) NOT NULL,
  `comment` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `date` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `contact_support`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `contact_support` (
  `contact_id` int(10) NOT NULL AUTO_INCREMENT,
  `contact_email` text COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`contact_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `contact_support`
--

INSERT INTO `contact_support` (`contact_id`, `contact_email`) VALUES
(1, 'admin-demo@pixinal.com');

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

--
-- Table structure for table `contact_support_meta`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `contact_support_meta` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `language_id` int(10) NOT NULL,
  `contact_heading` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `contact_desc` text COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `contact_support_meta`
--

INSERT INTO `contact_support_meta` (`id`, `language_id`, `contact_heading`, `contact_desc`) VALUES
(1, 1, 'Submit A Support Request', 'If you have any questions, please feel free to contact us, Our customer service center is online 24/7.\r\n\r\n');

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

--
-- Table structure for table `countries`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `countries` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=246 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT;

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

INSERT INTO `countries` (`id`, `name`, `code`) VALUES
(1, 'Afghanistan', 93),
(2, 'Aland Islands', 0),
(3, 'Albania', 355),
(4, 'Algeria', 213),
(5, 'American Samoa', 1684),
(6, 'Andorra', 376),
(7, 'Angola', 244),
(8, 'Anguilla', 1264),
(9, 'Antarctica', 0),
(10, 'Antigua And Barbuda', 1268),
(11, 'Argentina', 54),
(12, 'Armenia', 374),
(13, 'Aruba', 297),
(14, 'Australia', 61),
(15, 'Austria', 43),
(16, 'Azerbaijan', 994),
(17, 'Bahamas', 1242),
(18, 'Bahrain', 973),
(19, 'Bangladesh', 880),
(20, 'Barbados', 1246),
(21, 'Belarus', 375),
(22, 'Belgium', 32),
(23, 'Belize', 501),
(24, 'Benin', 229),
(25, 'Bermuda', 1441),
(26, 'Bhutan', 975),
(27, 'Bolivia', 591),
(28, 'Bosnia And Herzegovina', 387),
(29, 'Botswana', 267),
(30, 'Bouvet Island', 0),
(31, 'Brazil', 55),
(32, 'British Indian Ocean Territory', 246),
(33, 'Brunei Darussalam', 673),
(34, 'Bulgaria', 359),
(35, 'Burkina Faso', 226),
(36, 'Burundi', 257),
(37, 'Cambodia', 855),
(38, 'Cameroon', 237),
(39, 'Canada', 1),
(40, 'Cape Verde', 238),
(41, 'Cayman Islands', 1345),
(42, 'Central African Republic', 236),
(43, 'Chad', 235),
(44, 'Chile', 56),
(45, 'China', 86),
(46, 'Christmas Island', 61),
(47, 'Cocos (keeling) Islands', 672),
(48, 'Colombia', 57),
(49, 'Comoros', 269),
(50, 'Congo', 242),
(51, 'Congo, The Democratic Republic Of', 0),
(52, 'Cook Islands', 682),
(53, 'Costa Rica', 506),
(54, 'Cote D\'ivoire', 225),
(55, 'Croatia', 385),
(56, 'Cuba', 53),
(57, 'Cyprus', 357),
(58, 'Czech Republic', 420),
(59, 'Denmark', 45),
(60, 'Djibouti', 253),
(61, 'Dominica', 1767),
(62, 'Dominican Republic', 1809),
(63, 'Ecuador', 593),
(64, 'Egypt', 20),
(65, 'El Salvador', 503),
(66, 'Equatorial Guinea', 240),
(67, 'Eritrea', 291),
(68, 'Estonia', 372),
(69, 'Ethiopia', 251),
(70, 'Falkland Islands (malvinas)', 500),
(71, 'Faroe Islands', 298),
(72, 'Fiji', 679),
(73, 'Finland', 358),
(74, 'France', 33),
(75, 'French Guiana', 594),
(76, 'French Polynesia', 689),
(77, 'French Southern Territories', 0),
(78, 'Gabon', 241),
(79, 'Gambia', 220),
(80, 'Georgia', 995),
(81, 'Germany', 49),
(82, 'Ghana', 233),
(83, 'Gibraltar', 350),
(84, 'Greece', 30),
(85, 'Greenland', 299),
(86, 'Grenada', 1473),
(87, 'Guadeloupe', 590),
(88, 'Guam', 1671),
(89, 'Guatemala', 502),
(90, 'Guernsey', 0),
(91, 'Guinea', 224),
(92, 'Guinea-bissau', 245),
(93, 'Guyana', 592),
(94, 'Haiti', 509),
(95, 'Heard Island And Mcdonald Islands', 0),
(96, 'Holy See (vatican City State)', 39),
(97, 'Honduras', 504),
(98, 'Hong Kong', 852),
(99, 'Hungary', 36),
(100, 'Iceland', 354),
(101, 'India', 91),
(102, 'Indonesia', 62),
(103, 'Iran, Islamic Republic Of', 98),
(104, 'Iraq', 964),
(105, 'Ireland', 353),
(106, 'Isle Of Man', 0),
(107, 'Israel', 972),
(108, 'Italy', 39),
(109, 'Jamaica', 1876),
(110, 'Japan', 81),
(111, 'Jersey', 0),
(112, 'Jordan', 962),
(113, 'Kazakhstan', 7),
(114, 'Kenya', 254),
(115, 'Kiribati', 686),
(116, 'Korea, Democratic People\'s Republic Of', 850),
(117, 'Korea, Republic Of', 82),
(118, 'Kuwait', 965),
(119, 'Kyrgyzstan', 996),
(120, 'Lao People\'s Democratic Republic', 856),
(121, 'Latvia', 371),
(122, 'Lebanon', 961),
(123, 'Lesotho', 266),
(124, 'Liberia', 231),
(125, 'Libyan Arab Jamahiriya', 218),
(126, 'Liechtenstein', 423),
(127, 'Lithuania', 370),
(128, 'Luxembourg', 352),
(129, 'Macao', 853),
(130, 'North Macedonia', 0),
(131, 'Madagascar', 261),
(132, 'Malawi', 265),
(133, 'Malaysia', 60),
(134, 'Maldives', 960),
(135, 'Mali', 223),
(136, 'Malta', 356),
(137, 'Marshall Islands', 692),
(138, 'Martinique', 596),
(139, 'Mauritania', 222),
(140, 'Mauritius', 230),
(141, 'Mayotte', 269),
(142, 'Mexico', 52),
(143, 'Micronesia, Federated States Of', 691),
(144, 'Moldova, Republic Of', 373),
(145, 'Monaco', 377),
(146, 'Mongolia', 976),
(147, 'Montserrat', 1664),
(148, 'Morocco', 212),
(149, 'Mozambique', 258),
(150, 'Myanmar', 95),
(151, 'Namibia', 264),
(152, 'Nauru', 674),
(153, 'Nepal', 977),
(154, 'Netherlands', 31),
(155, 'Netherlands Antilles', 599),
(156, 'New Caledonia', 687),
(157, 'New Zealand', 64),
(158, 'Nicaragua', 505),
(159, 'Niger', 227),
(160, 'Nigeria', 234),
(161, 'Niue', 683),
(162, 'Norfolk Island', 672),
(163, 'Northern Mariana Islands', 1670),
(164, 'Norway', 47),
(165, 'Oman', 968),
(166, 'Pakistan', 92),
(167, 'Palau', 680),
(168, 'Palestinian Territory, Occupied', 970),
(169, 'Panama', 507),
(170, 'Papua New Guinea', 675),
(171, 'Paraguay', 595),
(172, 'Peru', 51),
(173, 'Philippines', 63),
(174, 'Pitcairn', 0),
(175, 'Poland', 48),
(176, 'Portugal', 351),
(177, 'Puerto Rico', 1787),
(178, 'Qatar', 974),
(179, 'Reunion', 262),
(180, 'Romania', 40),
(181, 'Russian Federation', 70),
(182, 'Rwanda', 250),
(183, 'Saint Helena', 290),
(184, 'Saint Kitts And Nevis', 1869),
(185, 'Saint Lucia', 1758),
(186, 'Saint Pierre And Miquelon', 508),
(187, 'Saint Vincent And The Grenadines', 1784),
(188, 'Samoa', 684),
(189, 'San Marino', 378),
(190, 'Sao Tome And Principe', 239),
(191, 'Saudi Arabia', 966),
(192, 'Senegal', 221),
(193, 'Serbia And Montenegro', 381),
(194, 'Seychelles', 248),
(195, 'Sierra Leone', 232),
(196, 'Singapore', 65),
(197, 'Slovakia', 421),
(198, 'Slovenia', 386),
(199, 'Solomon Islands', 677),
(200, 'Somalia', 252),
(201, 'South Africa', 27),
(202, 'South Georgia And The South Sandwich Islands', 0),
(203, 'Spain', 34),
(204, 'Sri Lanka', 94),
(205, 'Sudan', 249),
(206, 'Suriname', 597),
(207, 'Svalbard And Jan Mayen', 47),
(208, 'Swaziland', 268),
(209, 'Sweden', 46),
(210, 'Switzerland', 41),
(211, 'Syrian Arab Republic', 963),
(212, 'Taiwan, Province Of China', 886),
(213, 'Tajikistan', 992),
(214, 'Tanzania, United Republic Of', 255),
(215, 'Thailand', 66),
(216, 'Timor-leste', 670),
(217, 'Togo', 228),
(218, 'Tokelau', 690),
(219, 'Tonga', 676),
(220, 'Trinidad And Tobago', 1868),
(221, 'Tunisia', 216),
(222, 'Turkey', 90),
(223, 'Turkmenistan', 7370),
(224, 'Turks And Caicos Islands', 1649),
(225, 'Tuvalu', 688),
(226, 'Uganda', 256),
(227, 'Ukraine', 380),
(228, 'United Arab Emirates', 971),
(229, 'United Kingdom', 44),
(230, 'United States', 1),
(231, 'United States Minor Outlying Islands', 1),
(232, 'Uruguay', 598),
(233, 'Uzbekistan', 998),
(234, 'Vanuatu', 678),
(235, 'Venezuela', 58),
(236, 'Viet Nam', 84),
(237, 'Virgin Islands, British', 1284),
(238, 'Virgin Islands, U.S.', 1340),
(239, 'Wallis And Futuna', 681),
(240, 'Western Sahara', 212),
(241, 'Yemen', 967),
(242, 'Zambia', 260),
(243, 'Zimbabwe', 263),
(245, 'Myanmar (Burma)', 0);

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

--
-- Table structure for table `coupons`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `coupons` (
  `coupon_id` int(10) NOT NULL AUTO_INCREMENT,
  `proposal_id` int(10) NOT NULL,
  `coupon_title` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `coupon_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `coupon_price` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `coupon_code` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `coupon_limit` int(10) NOT NULL,
  `coupon_used` int(10) NOT NULL,
  PRIMARY KEY (`coupon_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `coupons_used`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `coupons_used` (
  `id` int(100) NOT NULL AUTO_INCREMENT,
  `proposal_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `seller_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `coupon_used` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `coupon_price` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `currencies`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `currencies` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `symbol` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=160 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `currencies`
--

INSERT INTO `currencies` (`id`, `name`, `symbol`) VALUES
(1, 'Afghan afghani', '&#065;&#102;'),
(2, 'Albanian lek', '&#076;&#101;&#107;'),
(3, 'Algerian dinar', '&#1583;&#1580;'),
(4, 'Euro', '&#8364;'),
(5, 'Angolan kwanza', '&#075;&#122;'),
(6, 'East Caribbean dollar', '&#036;'),
(7, 'Argentine peso', '&#036;'),
(8, 'Armenian dram', 'AMD'),
(9, 'Aruban florin', '&#402;'),
(10, 'Australian dollar', '&#036;'),
(11, 'Azerbaijani manat', '&#1084;&#1072;&#1085;'),
(12, 'Bahamian dollar', '&#036;'),
(13, 'Bahraini dinar', '.&#1583;.&#1576;'),
(14, 'Bangladeshi taka', '&#2547;'),
(15, 'Barbadian dollar', '&#036;'),
(16, 'Belarusian ruble', '&#112;&#046;'),
(17, 'Belizean dollar', '&#066;&#090;&#036;'),
(18, 'West African CFA franc', 'CFA'),
(19, 'Bermudian dollar', '&#036;'),
(20, 'Bhutanese ngultrum', '&#078;&#117;&#046;'),
(21, 'Bolivian boliviano', '&#036;&#098;'),
(22, 'US dollar', '&#036;'),
(23, 'Bosnia and Herzegovina convertible mark', '&#075;&#077;'),
(24, 'Botswana pula', '&#080;'),
(25, 'Brazilian real', '&#082;&#036;'),
(26, 'Brunei dollar', '&#036;'),
(27, 'Bulgarian lev', '&#1083;&#1074;'),
(28, 'Burmese kyat', '&#075;'),
(29, 'Burundian franc', '&#070;&#066;&#117;'),
(30, 'Cambodian riel', '&#6107;'),
(31, 'Central African CFA franc', '&#070;&#067;&#070;&#065;'),
(32, 'Canadian dollar', '&#036;'),
(33, 'Cape Verdean escudo', '&#036;'),
(34, 'Cayman Islands dollar', '&#036;'),
(35, 'Chilean peso', '&#036;'),
(36, 'Chinese renminbi', '&#165;'),
(37, 'Colombian peso', '&#036;'),
(38, 'Comorian franc', '&#067;&#070;'),
(39, 'Congolese franc', '&#070;&#067;'),
(40, 'New Zealand dollar', 'NZ&#036;'),
(41, 'Costa Rican colón', '&#8353;'),
(42, 'Croatian kuna', '&#107;&#110;'),
(43, 'Cuban peso', '&#8369;'),
(44, 'Netherlands Antilles guilder', '&#402;'),
(45, 'Czech koruna', '&#075;&#269;'),
(46, 'Danish krone', '&#107;&#114;'),
(47, 'Djiboutian franc', '&#070;&#100;&#106;'),
(48, 'Dominican peso', '&#082;&#068;&#036;'),
(49, 'Egyptian pound', 'EGP'),
(50, 'Salvadoran colón', '&#036;'),
(51, 'Eritrean nakfa', 'Nfk'),
(52, 'Ethiopian birr', '&#066;&#114;'),
(53, 'Falkland Islands pound', '&#163;'),
(54, 'Fijian dollar', '&#036;'),
(55, 'CFP franc', '&#070;'),
(56, 'Gambian dalasi', '&#068;'),
(57, 'Georgian lari', '&#4314;'),
(58, 'Ghanian cedi', '&#162;'),
(59, 'Gibraltar pound', '&#163;'),
(60, 'Guatemalan quetzal', '&#081;'),
(61, 'British pound', '&#163;'),
(62, 'Guinean franc', '&#070;&#071;'),
(63, 'Guyanese dollar', '&#036;'),
(64, 'Haitian gourde', '&#071;'),
(65, 'Honduran lempira', '&#076;'),
(66, 'Hong Kong dollar', '&#036;'),
(67, 'Hungarian forint', '&#070;&#116;'),
(68, 'Icelandic króna', '&#107;&#114;'),
(69, 'Indian rupee', '&#8377;'),
(70, 'Indonesian rupiah', '&#082;&#112;'),
(71, 'Iranian rial', '&#65020;'),
(72, 'Iraqi dinar', '&#1593;.&#1583;'),
(73, 'Israeli new sheqel', '&#8362;'),
(74, 'Jamaican dollar', '&#074;&#036;'),
(75, 'Japanese yen ', '&#165;'),
(76, 'Jordanian dinar', '&#074;&#068;'),
(77, 'Kazakhstani tenge', '&#1083;&#1074;'),
(78, 'Kenyan shilling', '&#075;&#083;&#104;'),
(79, 'North Korean won', '&#8361;'),
(80, 'Kuwaiti dinar', '&#1583;.&#1603;'),
(81, 'Kyrgyzstani som', '&#1083;&#1074;'),
(82, 'South Korean won', '&#8361;'),
(83, 'Lao kip', '&#8365;'),
(84, 'Latvian lats', '&#076;&#115;'),
(85, 'Lebanese pound', '&#163;'),
(86, 'Lesotho loti', '&#076;'),
(87, 'Liberian dollar', '&#036;'),
(88, 'Libyan dinar', '?.?'),
(89, 'Swiss franc', '&#067;&#072;&#070;'),
(90, 'Lithuanian litas', '&#076;&#116;'),
(91, 'Macanese pataca', '&#077;&#079;&#080;&#036;'),
(92, 'Macedonian denar', '&#1076;&#1077;&#1085;'),
(93, 'Malagasy ariary', '&#065;&#114;'),
(94, 'Malawian kwacha', '&#077;&#075;'),
(95, 'Malaysian ringgit', '&#082;&#077;'),
(96, 'Maldivian rufiyaa', '.&#1923;'),
(97, 'Mauritanian ouguiya', '&#085;&#077;'),
(98, 'Mauritian rupee', '&#8360;'),
(99, 'Mexican peso', '&#036;'),
(100, 'Moldovan leu', '&#076;'),
(101, 'Mongolian tugrik', '&#8366;'),
(102, 'Moroccan dirham', '&#1583;.&#1605;.'),
(103, 'Mozambican metical', '&#077;&#084;'),
(104, 'Namibian dollar', '&#036;'),
(105, 'Nepalese rupee', '&#8360;'),
(106, 'Nicaraguan córdoba', '&#067;&#036;'),
(107, 'Nigerian naira', '&#8358;'),
(108, 'Norwegian krone', '&#107;&#114;'),
(109, 'Omani rial', '&#65020;'),
(110, 'Pakistani rupee', '&#8360;'),
(111, 'Panamanian balboa', '&#066;&#047;&#046;'),
(112, 'Papua New Guinea kina', '&#075;'),
(113, 'Paraguayan guarani', '&#071;&#115;'),
(114, 'Peruvian nuevo sol', '&#083;&#047;&#046;'),
(115, 'Philippine peso', '&#8369;'),
(116, 'Polish zloty', '&#122;&#322;'),
(117, 'Qatari riyal', '&#65020;'),
(118, 'Romanian leu', '&#108;&#101;&#105;'),
(119, 'Russian ruble', '&#1088;&#1091;&#1073;'),
(120, 'Rwandan franc', '&#1585;.&#1587;'),
(121, 'Samoan t?l?', '&#087;&#083;&#036;'),
(122, 'São Tomé and Príncipe dobra', '&#068;&#098;'),
(123, 'Saudi riyal', '&#65020;'),
(124, 'Serbian dinar', '&#1044;&#1080;&#1085;&#046;'),
(125, 'Seychellois rupee', '&#8360;'),
(126, 'Sierra Leonean leone', '&#076;&#101;'),
(127, 'Singapore dollar', 'S&#036;'),
(128, 'Solomon Islands dollar', '&#036;'),
(129, 'Somali shilling', '&#083;'),
(130, 'South African rand', '&#082;'),
(131, 'Sri Lankan rupee', '&#8360;'),
(132, 'St. Helena pound', '&#163;'),
(133, 'Sudanese pound', '&#163;'),
(134, 'Surinamese dollar', '&#036;'),
(135, 'Swazi lilangeni', '&#076;'),
(136, 'Swedish krona', '&#107;&#114;'),
(137, 'Syrian pound', '&#163;'),
(138, 'New Taiwan dollar', '&#078;&#084;&#036;'),
(139, 'Tajikistani somoni', '&#084;&#074;&#083;'),
(140, 'Tanzanian shilling', 'Sh'),
(141, 'Thai baht ', '&#3647;'),
(142, 'Tongan pa’anga', '&#084;&#036;'),
(143, 'Trinidad and Tobago dollar', '&#036;'),
(144, 'Tunisian dinar', '&#1583;.&#1578;'),
(145, 'Turkish lira', '&#x20BA;'),
(146, 'Turkmenistani manat', '&#109;'),
(147, 'Ugandan shilling', '&#085;&#083;&#104;'),
(148, 'Ukrainian hryvnia', '&#8372;'),
(149, 'United Arab Emirates dirham', '&#1583;.&#1573;'),
(150, 'Uruguayan peso', '&#036;&#085;'),
(151, 'Uzbekistani som', '&#1083;&#1074;'),
(152, 'Vanuatu vatu', '&#086;&#084;'),
(153, 'Venezuelan bolivar', '&#066;&#115;'),
(154, 'Vietnamese dong', '&#8363;'),
(155, 'Yemeni rial', '&#65020;'),
(156, 'Zambian kwacha', '&#090;&#075;'),
(157, 'Zimbabwean dollar', '&#090;&#036;'),
(158, 'Jersey pound', '&#163;'),
(159, 'Libyan dinar', '&#1604;.&#1583;');

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

--
-- Table structure for table `delivery_times`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `delivery_times` (
  `delivery_id` int(10) NOT NULL AUTO_INCREMENT,
  `delivery_title` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `delivery_proposal_title` text COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`delivery_id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `delivery_times`
--

INSERT INTO `delivery_times` (`delivery_id`, `delivery_title`, `delivery_proposal_title`) VALUES
(1, 'Up to 24 hours', '1 Day'),
(2, 'Up to 2 Days', '2 Days'),
(3, 'Up to 3 Days', '3 Days'),
(4, 'Up to 4 Days', '4 Days'),
(5, 'Up to 5 Days', '5 Days'),
(6, 'Up to 6 Days', '6 Days'),
(7, 'Up to 7 Days', '7 Days');

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

--
-- Table structure for table `dusupay_orders`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `dusupay_orders` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `order_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `reference_no` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `buyer_id` int(10) NOT NULL,
  `content_id` int(10) NOT NULL,
  `qty` int(10) NOT NULL,
  `price` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `total` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `delivery_id` int(10) NOT NULL,
  `revisions` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `minutes` int(10) NOT NULL,
  `extras` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `currency` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `message` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=115 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `enquiry_types`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `enquiry_types` (
  `enquiry_id` int(10) NOT NULL AUTO_INCREMENT,
  `enquiry_title` text COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`enquiry_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `enquiry_types`
--

INSERT INTO `enquiry_types` (`enquiry_id`, `enquiry_title`) VALUES
(1, 'Order Support '),
(2, 'Review Removal '),
(3, 'Account Support'),
(4, 'Report A Bug \r\n');

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

--
-- Table structure for table `expenses`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `expenses` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount` decimal(10,1) NOT NULL,
  `date` text COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `favorites`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `favorites` (
  `favourite_id` int(10) NOT NULL AUTO_INCREMENT,
  `seller_id` int(10) NOT NULL,
  `proposal_id` int(10) NOT NULL,
  PRIMARY KEY (`favourite_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `featured_proposals`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `featured_proposals` (
  `featured_id` int(10) NOT NULL AUTO_INCREMENT,
  `proposal_id` int(10) NOT NULL,
  `end_date` text COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`featured_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `footer_links`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `footer_links` (
  `link_id` int(10) NOT NULL AUTO_INCREMENT,
  `language_id` int(10) NOT NULL,
  `icon_class` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `link_title` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `link_url` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `link_section` text COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`link_id`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `footer_links`
--

INSERT INTO `footer_links` (`link_id`, `language_id`, `icon_class`, `link_title`, `link_url`, `link_section`) VALUES
(1, 1, '', 'Graphics &amp; Design', 'categories/graphics-design', 'categories'),
(2, 1, '', 'Digital Marketing', 'categories/digital-marketing', 'categories'),
(3, 1, '', 'Writing & Translation\r\n', 'categories/writing-translation', 'categories'),
(4, 1, '', 'Video & Animation\r\n', 'categories/video-animation', 'categories'),
(5, 1, '', 'Music & Audio\r\n', 'categories/music-audio', 'categories'),
(6, 1, '', 'Programming & Tech\r\n', 'categories/programming-tech', 'categories'),
(7, 1, '', 'Business\r\n', 'categories/business', 'categories'),
(8, 1, '', 'Fun & Lifestyle\r\n', 'categories/fun-lifestyle', 'categories'),
(9, 1, 'fa-file-text-o', 'Terms & Conditions', 'terms_and_conditions', 'about'),
(10, 1, 'fa-google-plus-official', 'fa-google-plus-official', '#', 'follow'),
(11, 1, 'fa-twitter', '', '#', 'follow'),
(12, 1, 'fa-facebook', '', '#', 'follow'),
(13, 1, 'fa-linkedin', '', '#', 'follow'),
(14, 1, 'fa-pinterest', '', '#', 'follow'),
(15, 1, 'fa fa-life-ring', 'Customer Support', 'customer_support', 'about'),
(16, 1, 'fa-question-circle', 'How It Works', 'how-it-works', 'about'),
(17, 1, 'fa-book', 'Knowledge Bank', 'knowledge_bank/', 'about'),
(18, 1, 'fa-rss', 'Blog', 'blog/', 'about'),
(19, 1, 'fa fa-comments-o', 'Feedback', 'feedback/', 'about');

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

--
-- Table structure for table `hide_seller_messages`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `hide_seller_messages` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `hider_id` int(10) NOT NULL,
  `hide_seller_id` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `home_cards`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `home_cards` (
  `card_id` int(10) NOT NULL AUTO_INCREMENT,
  `language_id` int(10) NOT NULL,
  `card_title` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `card_desc` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `card_link` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `card_image` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `isS3` int(10) NOT NULL,
  PRIMARY KEY (`card_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `home_cards`
--

INSERT INTO `home_cards` (`card_id`, `language_id`, `card_title`, `card_desc`, `card_link`, `card_image`, `isS3`) VALUES
(1, 1, 'Logo Design', 'Build Your Brand', 'https://www.gigtodo.com/categories/graphics-design/logo-design', '1.jpg', 0),
(2, 1, 'Social Media', 'Reach More Customers', 'https://www.gigtodo.com/categories/digital-marketing/social-media-marketing', '2.jpg', 0),
(3, 1, 'Voice Talent', 'The Perfect Voiceover', 'https://www.gigtodo.com/categories/video-animation', '7.jpg', 0),
(4, 1, 'Translation', 'Go Global.', 'https://www.gigtodo.com/categories/writing-translation/translation', '4.jpg', 0),
(5, 1, 'Illustration', 'Color Your Dreams', 'https://www.gigtodo.com/categories/graphics-design/illustration', '5.jpg', 0),
(6, 1, 'Photoshop Expert', 'Hire A Designer', 'https://www.gigtodo.com/categories/graphics-design/photoshop-editing', '6.jpg', 0);

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

--
-- Table structure for table `home_section`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `home_section` (
  `section_id` int(10) NOT NULL AUTO_INCREMENT,
  `language_id` int(10) NOT NULL,
  `section_heading` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `section_short_heading` text COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`section_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `home_section`
--

INSERT INTO `home_section` (`section_id`, `language_id`, `section_heading`, `section_short_heading`) VALUES
(1, 1, 'TRC4 Albania', 'Services On Demand');

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

--
-- Table structure for table `home_section_slider`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `home_section_slider` (
  `slide_id` int(100) NOT NULL AUTO_INCREMENT,
  `slide_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slide_image` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `isS3` int(10) NOT NULL,
  PRIMARY KEY (`slide_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `home_section_slider`
--

INSERT INTO `home_section_slider` (`slide_id`, `slide_name`, `slide_image`, `isS3`) VALUES
(1, 'Slide 1', 'main.png', 0),
(2, 'Slide 2', '1.png', 0),
(3, 'Slide 3', '2.jpg', 0),
(4, 'Slide 4', '3.jpg', 0);

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

--
-- Table structure for table `ideas`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `ideas` (
  `id` int(100) NOT NULL AUTO_INCREMENT,
  `seller_id` int(100) NOT NULL,
  `votes` int(100) NOT NULL,
  `title` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `date` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `inbox_messages`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `inbox_messages` (
  `message_id` int(10) NOT NULL AUTO_INCREMENT,
  `message_group_id` int(10) NOT NULL,
  `message_sender` int(10) NOT NULL,
  `message_receiver` int(10) NOT NULL,
  `message_offer_id` int(10) NOT NULL,
  `message_desc` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `message_file` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `message_date` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `dateAgo` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `bell` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `message_status` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `isS3` int(10) NOT NULL,
  PRIMARY KEY (`message_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `inbox_sellers`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `inbox_sellers` (
  `inbox_seller_id` int(10) NOT NULL AUTO_INCREMENT,
  `message_group_id` int(10) NOT NULL,
  `message_id` int(10) NOT NULL,
  `offer_id` int(10) NOT NULL,
  `sender_id` int(10) NOT NULL,
  `receiver_id` int(10) NOT NULL,
  `popup` int(10) NOT NULL,
  `time` int(11) NOT NULL,
  `message_status` text COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`inbox_seller_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `instant_deliveries`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `instant_deliveries` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `proposal_id` int(10) NOT NULL,
  `enable` int(10) NOT NULL,
  `message` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `watermark` int(10) NOT NULL,
  `watermark_file` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `file` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `isS3` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=164 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `knowledge_bank`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `knowledge_bank` (
  `article_id` int(11) NOT NULL AUTO_INCREMENT,
  `language_id` int(10) NOT NULL,
  `cat_id` int(10) NOT NULL,
  `article_url` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `article_heading` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `article_body` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `right_image` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `top_image` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `bottom_image` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `article_status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `right_image_s3` int(10) NOT NULL,
  `top_image_s3` int(10) NOT NULL,
  `bottom_image_s3` int(10) NOT NULL,
  PRIMARY KEY (`article_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `languages`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `languages` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `default_lang` int(10) NOT NULL,
  `direction` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `template_folder` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `isS3` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `languages`
--

INSERT INTO `languages` (`id`, `title`, `image`, `default_lang`, `direction`, `template_folder`, `isS3`) VALUES
(1, 'English', 'english.png', 1, 'left', 'en', 0);

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

--
-- Table structure for table `languages_relation`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `languages_relation` (
  `relation_id` int(10) NOT NULL AUTO_INCREMENT,
  `seller_id` int(10) NOT NULL,
  `language_id` int(11) NOT NULL,
  `language_level` text COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`relation_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `messages_offers`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `messages_offers` (
  `offer_id` int(10) NOT NULL AUTO_INCREMENT,
  `sender_id` int(10) NOT NULL,
  `proposal_id` int(10) NOT NULL,
  `order_id` int(10) NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `delivery_time` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` text COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`offer_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `my_buyers`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `my_buyers` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `seller_id` int(10) NOT NULL,
  `buyer_id` int(10) NOT NULL,
  `completed_orders` int(10) NOT NULL,
  `amount_spent` int(10) NOT NULL,
  `last_order_date` text COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `my_sellers`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `my_sellers` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `buyer_id` int(10) NOT NULL,
  `seller_id` int(10) NOT NULL,
  `completed_orders` int(10) NOT NULL,
  `amount_spent` int(10) NOT NULL,
  `last_order_date` text COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `notifications`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `notifications` (
  `notification_id` int(10) NOT NULL AUTO_INCREMENT,
  `receiver_id` int(10) NOT NULL,
  `sender_id` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `order_id` int(10) NOT NULL,
  `reason` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `date` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `bell` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active',
  `status` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `fcm_notification_status` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`notification_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `orders`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `orders` (
  `order_id` int(10) NOT NULL AUTO_INCREMENT,
  `order_number` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `order_duration` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `order_time` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `order_date` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `order_revisions` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `order_revisions_used` int(10) NOT NULL,
  `order_description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `seller_id` int(10) NOT NULL,
  `buyer_id` int(10) NOT NULL,
  `proposal_id` int(10) NOT NULL,
  `order_price` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `order_qty` int(10) NOT NULL,
  `order_fee` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `order_active` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `complete_time` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `order_status` text COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`order_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `order_conversations`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `order_conversations` (
  `c_id` int(10) NOT NULL AUTO_INCREMENT,
  `order_id` int(10) NOT NULL,
  `sender_id` int(10) NOT NULL,
  `message` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `file` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `date` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `reason` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `watermark` int(10) NOT NULL,
  `watermark_file` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `isS3` int(10) NOT NULL,
  PRIMARY KEY (`c_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `order_extras`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `order_extras` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `order_id` int(10) NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `price` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `order_tips`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `order_tips` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `order_id` int(10) NOT NULL,
  `amount` int(10) NOT NULL,
  `message` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `date` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `package_attributes`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `package_attributes` (
  `attribute_id` int(100) NOT NULL AUTO_INCREMENT,
  `proposal_id` int(100) NOT NULL,
  `package_id` int(100) NOT NULL,
  `attribute_name` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `attribute_value` text COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`attribute_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `pages`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `pages` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `url` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `date` text COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `pages_meta`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `pages_meta` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `page_id` int(11) NOT NULL,
  `language_id` int(11) NOT NULL,
  `title` text NOT NULL,
  `content` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `payouts`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `payouts` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `seller_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ref` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `method` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `date` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `message` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `plugins`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `plugins` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `folder` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `version` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `author` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `author_url` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `posts`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `posts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cat_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL,
  `date_time` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `isS3` int(10) NOT NULL,
  `language_id` int(10) NOT NULL,
  `status` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `posts_meta`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `posts_meta` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `post_id` int(11) NOT NULL,
  `title` text NOT NULL,
  `author` varchar(255) NOT NULL,
  `content` text NOT NULL,
  `language_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `post_categories`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `post_categories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cat_image` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `date_time` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `isS3` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `post_categories_meta`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `post_categories_meta` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cat_id` int(11) NOT NULL,
  `language_id` int(11) NOT NULL,
  `cat_name` varchar(255) DEFAULT NULL,
  `cat_creator` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `post_comments`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `post_comments` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `post_id` int(100) NOT NULL,
  `seller_id` int(100) NOT NULL,
  `comment` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `date` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `proposals`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `proposals` (
  `proposal_id` int(10) NOT NULL AUTO_INCREMENT,
  `proposal_title` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `proposal_url` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `proposal_cat_id` int(10) NOT NULL,
  `proposal_child_id` int(10) NOT NULL,
  `proposal_price` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `proposal_img1` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `proposal_img2` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `proposal_img3` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `proposal_img4` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `proposal_video` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `proposal_img1_s3` int(10) NOT NULL,
  `proposal_img2_s3` int(10) NOT NULL,
  `proposal_img3_s3` int(10) NOT NULL,
  `proposal_img4_s3` int(10) NOT NULL,
  `proposal_video_s3` int(10) NOT NULL,
  `proposal_desc` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `buyer_instruction` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `proposal_tags` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `proposal_enable_referrals` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `proposal_referral_money` int(10) NOT NULL,
  `proposal_referral_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `proposal_featured` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `proposal_toprated` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `proposal_seller_id` int(10) NOT NULL,
  `delivery_id` int(10) NOT NULL,
  `proposal_revisions` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `level_id` int(10) NOT NULL,
  `language_id` int(10) NOT NULL,
  `proposal_rating` int(11) NOT NULL,
  `proposal_views` int(10) NOT NULL,
  `proposal_status` text COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`proposal_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `proposals_extras`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `proposals_extras` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `proposal_id` int(10) NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `price` int(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `proposals_faq`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `proposals_faq` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `proposal_id` int(11) NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` text COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `proposal_modifications`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `proposal_modifications` (
  `modification_id` int(10) NOT NULL AUTO_INCREMENT,
  `proposal_id` int(10) NOT NULL,
  `modification_message` text COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`modification_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `proposal_packages`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `proposal_packages` (
  `package_id` int(100) NOT NULL AUTO_INCREMENT,
  `proposal_id` int(100) NOT NULL,
  `package_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `revisions` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `delivery_time` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `price` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`package_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `proposal_referrals`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `proposal_referrals` (
  `referral_id` int(10) NOT NULL AUTO_INCREMENT,
  `proposal_id` int(10) NOT NULL,
  `order_id` int(100) NOT NULL,
  `seller_id` int(10) NOT NULL,
  `referrer_id` int(10) NOT NULL,
  `buyer_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `comission` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `date` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `ip` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` text COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`referral_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `purchases`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `purchases` (
  `purchase_id` int(10) NOT NULL AUTO_INCREMENT,
  `seller_id` int(10) NOT NULL,
  `order_id` int(10) NOT NULL,
  `reason` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `processing_fee` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `method` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `date` text COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`purchase_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `recent_proposals`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `recent_proposals` (
  `recent_id` int(10) NOT NULL AUTO_INCREMENT,
  `seller_id` int(10) NOT NULL,
  `proposal_id` int(10) NOT NULL,
  PRIMARY KEY (`recent_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `referrals`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `referrals` (
  `referral_id` int(10) NOT NULL AUTO_INCREMENT,
  `seller_id` int(10) NOT NULL,
  `referred_id` int(10) NOT NULL,
  `comission` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `date` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `ip` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` text COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`referral_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `reports`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `reports` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `reporter_id` int(10) NOT NULL,
  `content_id` int(10) NOT NULL,
  `content_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `reason` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `additional_information` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `date` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `revenues`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `revenues` (
  `revenue_id` int(10) NOT NULL AUTO_INCREMENT,
  `seller_id` int(10) NOT NULL,
  `order_id` int(10) NOT NULL,
  `reason` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `date` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `end_date` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` text COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`revenue_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `sales`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `sales` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `buyer_id` int(10) NOT NULL,
  `work_id` int(10) NOT NULL,
  `payment_method` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `profit` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `processing_fee` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `action` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `date` text COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `section_boxes`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `section_boxes` (
  `box_id` int(10) NOT NULL AUTO_INCREMENT,
  `language_id` int(10) NOT NULL,
  `box_title` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `box_desc` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `box_image` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `isS3` int(10) NOT NULL,
  PRIMARY KEY (`box_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `section_boxes`
--

INSERT INTO `section_boxes` (`box_id`, `language_id`, `box_title`, `box_desc`, `box_image`, `isS3`) VALUES
(4, 1, 'Your Terms', 'Whatever you need to simplify your to do list, no&lt;br&gt; matter your budget.\r\n', 'time.png', 0),
(5, 1, 'Your Timeline', 'Find services based on your goals and deadlines,&lt;br&gt; its that simple.', 'desk.png', 0),
(6, 1, 'Your Safety', 'Your payment is always secure, GigToDo is built to protect your peace of mind.', 'tv.png', 0);

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

--
-- Table structure for table `seller_accounts`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `seller_accounts` (
  `account_id` int(10) NOT NULL AUTO_INCREMENT,
  `seller_id` int(10) NOT NULL,
  `withdrawn` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `current_balance` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `used_purchases` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `pending_clearance` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `month_earnings` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`account_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `seller_languages`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `seller_languages` (
  `language_id` int(10) NOT NULL AUTO_INCREMENT,
  `language_title` text COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`language_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `seller_levels`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `seller_levels` (
  `level_id` int(10) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`level_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `seller_levels`
--

INSERT INTO `seller_levels` (`level_id`) VALUES
(1),
(2),
(3),
(4);

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

--
-- Table structure for table `seller_levels_meta`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `seller_levels_meta` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `language_id` int(10) NOT NULL,
  `level_id` int(10) NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `seller_levels_meta`
--

INSERT INTO `seller_levels_meta` (`id`, `language_id`, `level_id`, `title`) VALUES
(1, 1, 1, 'New Seller'),
(2, 1, 2, 'Level One'),
(3, 1, 3, 'Level Two'),
(4, 1, 4, 'Top Rated A');

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

--
-- Table structure for table `seller_payment_settings`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `seller_payment_settings` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `level_id` int(10) NOT NULL,
  `commission_percentage` int(10) NOT NULL,
  `payout_day` int(100) NOT NULL,
  `payout_time` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payout_anyday` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `seller_payment_settings`
--

INSERT INTO `seller_payment_settings` (`id`, `level_id`, `commission_percentage`, `payout_day`, `payout_time`, `payout_anyday`) VALUES
(1, 1, 20, 26, '15:00', 0),
(2, 2, 15, 20, '01:00', 0),
(3, 3, 10, 15, '01:00', 0),
(4, 4, 5, 1, '03:00', 1);

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

--
-- Table structure for table `seller_reviews`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `seller_reviews` (
  `review_id` int(10) NOT NULL AUTO_INCREMENT,
  `order_id` int(10) NOT NULL,
  `review_seller_id` int(10) NOT NULL,
  `seller_rating` int(10) NOT NULL,
  `seller_review` text COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`review_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `seller_skills`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `seller_skills` (
  `skill_id` int(10) NOT NULL AUTO_INCREMENT,
  `skill_title` text COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`skill_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `seller_type_status`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `seller_type_status` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `seller_id` int(10) NOT NULL,
  `message_group_id` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `time` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` text COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `send_offers`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `send_offers` (
  `offer_id` int(10) NOT NULL AUTO_INCREMENT,
  `request_id` int(10) NOT NULL,
  `sender_id` int(10) NOT NULL,
  `proposal_id` int(10) NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `delivery_time` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` text COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`offer_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `site_currencies`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `site_currencies` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `currency_id` int(10) NOT NULL,
  `code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `position` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `format` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `rate` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `skills_relation`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `skills_relation` (
  `relation_id` int(10) NOT NULL AUTO_INCREMENT,
  `seller_id` int(10) NOT NULL,
  `skill_id` int(10) NOT NULL,
  `skill_level` text COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`relation_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `slider`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `slider` (
  `slide_id` int(10) NOT NULL AUTO_INCREMENT,
  `language_id` int(10) NOT NULL,
  `slide_name` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `slide_desc` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `slide_image` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `slide_url` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `isS3` int(10) NOT NULL,
  PRIMARY KEY (`slide_id`)
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `slider`
--

INSERT INTO `slider` (`slide_id`, `language_id`, `slide_name`, `slide_desc`, `slide_image`, `slide_url`, `isS3`) VALUES
(27, 1, '', '', 'cover-boy.png', 'https://kodi.al/', 0),
(32, 1, '', '', 'art-artist-canvas-374054.jpg', 'http://albdroid.al/', 0),
(33, 1, '', '', 'art-dark-ethnic-1038041.jpg', 'https://demo.kodi.al/', 0);

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

--
-- Table structure for table `spam_words`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `spam_words` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `word` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `spam_words`
--

INSERT INTO `spam_words` (`id`, `word`) VALUES
(1, 'PayPal'),
(2, 'payoneer'),
(3, 'pay'),
(4, 'mobile'),
(5, 'contact'),
(6, 'email'),
(7, 'skype'),
(8, 'number'),
(9, '.com'),
(10, 'direct'),
(12, 'Pay'),
(13, 'Poop'),
(15, 'bad word'),
(16, 'siva'),
(17, 'Machi'),
(18, 'city'),
(19, 'facebook');

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

--
-- Table structure for table `starred_messages`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `starred_messages` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `seller_id` int(10) NOT NULL,
  `message_group_id` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `support_conversations`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `support_conversations` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ticket_id` int(11) NOT NULL,
  `admin_id` int(11) NOT NULL,
  `sender_id` int(11) NOT NULL,
  `message` text NOT NULL,
  `date` text NOT NULL,
  `attachment` text DEFAULT NULL,
  `isS3` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=44 DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `support_tickets`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `support_tickets` (
  `ticket_id` int(10) NOT NULL AUTO_INCREMENT,
  `enquiry_id` int(10) NOT NULL,
  `number` int(11) NOT NULL,
  `sender_id` int(10) NOT NULL,
  `subject` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `message` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `order_number` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `order_rule` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `attachment` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `date` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `isS3` int(10) NOT NULL,
  PRIMARY KEY (`ticket_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `temp_extras`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `temp_extras` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `reference_no` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `buyer_id` int(10) NOT NULL,
  `item_id` int(10) NOT NULL,
  `proposal_id` int(10) NOT NULL,
  `name` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `price` text COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `temp_orders`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `temp_orders` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `reference_no` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `buyer_id` int(10) NOT NULL,
  `content_id` int(10) NOT NULL,
  `qty` int(10) NOT NULL,
  `price` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `total` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `delivery_id` int(10) NOT NULL,
  `revisions` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `minutes` int(10) NOT NULL,
  `video` int(10) NOT NULL,
  `extras` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `currency` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `method` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `message` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=124 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `terms`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `terms` (
  `term_id` int(10) NOT NULL AUTO_INCREMENT,
  `language_id` int(10) NOT NULL,
  `term_title` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `term_link` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `term_description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`term_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `terms`
--

INSERT INTO `terms` (`term_id`, `language_id`, `term_title`, `term_link`, `term_description`) VALUES
(1, 1, 'Terms And Conditions', 'Legal-Notice', '\n<p>It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using \'Content here, content here\', making it look like readable English.</p><p><br></p><p>Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for \'lorem ipsum\' will uncover many web sites still in their infancy. Various versions have evolved over the years, sometimes by accident, sometimes on purpose (injected humour and the like). Why do we use it? It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.</p><p><br></p><p>The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using \'Content here, content here\', making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for \'lorem ipsum\' will uncover many web sites still in their infancy. Various versions have evolved over the years, sometimes by accident, sometimes on purpose (injected humour and the like). Where does it come from? Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \"de Finibus Bonorum et Malorum\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance.</p><p><br></p><p>The first line of Lorem Ipsum, \"Lorem ipsum dolor sit amet..\", comes from a line in section 1.10.32. The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from \"de Finibus Bonorum et Malorum\" by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.</p>\r\n\r\n\r\n\r\n\n'),
(2, 1, 'Refunds Policy', 'refund', '\n<p><span style=\"color: rgb(0, 0, 0);\">It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using \'Content here, content here\', making it look like readable English.</span></p><p><span style=\"color: rgb(0, 0, 0);\">Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for \'lorem ipsum\' will uncover many web sites still in their infancy. Various versions have evolved over the years, sometimes by accident, sometimes on purpose (injected humour and the like).</span></p><p><span style=\"color: rgb(0, 0, 0);\">Why do we use it? It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using \'Content here, content here\', making it look like readable English.</span></p><p><span style=\"color: rgb(0, 0, 0);\">Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for \'lorem ipsum\' will uncover many web sites still in their infancy. Various versions have evolved over the years, sometimes by accident, sometimes on purpose (injected humour and the like).</span></p><p><span style=\"color: rgb(0, 0, 0);\">Where does it come from? Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \"de Finibus Bonorum et Malorum\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \"Lorem ipsum dolor sit amet..\", comes from a line in section 1.10.32. The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from \"de Finibus Bonorum et Malorum\" by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.</span><br></p>\r\n\r\n\r\n\n');

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

--
-- Table structure for table `top_proposals`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `top_proposals` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `proposal_id` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `unread_messages`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `unread_messages` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `seller_id` int(10) NOT NULL,
  `message_group_id` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `withdrawals`
--
-- Creation: Dec 07, 2020 at 06:52 PM
--

CREATE TABLE IF NOT EXISTS `withdrawals` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `seller_id` int(10) NOT NULL,
  `method` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount` int(10) NOT NULL,
  `date` text COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
COMMIT;

