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

START TRANSACTION;



--
-- Database: `starmarketters_digidemo`
--

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

--
-- Table structure for table `activity`
--

CREATE TABLE `activity` (
  `id` int(11) UNSIGNED NOT NULL,
  `user_id` int(11) UNSIGNED NOT NULL DEFAULT 0,
  `username` varchar(80) DEFAULT NULL,
  `ip` varbinary(16) DEFAULT NULL,
  `failed` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
  `failed_last` int(11) UNSIGNED NOT NULL DEFAULT 0,
  `type` varchar(20) DEFAULT NULL,
  `message` varchar(150) DEFAULT NULL,
  `importance` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '1 yes, 0 =no',
  `created` timestamp NULL DEFAULT current_timestamp()
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `activity`
--

INSERT INTO `activity` (`id`, `user_id`, `username`, `ip`, `failed`, `failed_last`, `type`, `message`, `importance`, `created`) VALUES
(1, 1, 'Web Master', 0x323430353a3230313a356330613a3630, 0, 0, 'content', 'User <b>Demo Digi</b> added successfully', 0, '2024-11-07 10:01:49'),
(2, 1, 'Web Master', 0x323430353a3230313a356330613a3630, 0, 0, 'content', 'Custom Field <b>Phone number</b> Updated Successfully.', 0, '2024-11-07 12:01:59'),
(3, 1, 'Web Master', 0x323430353a3230313a356330613a3630, 0, 0, 'content', 'Product <b>Motion Backgrounds</b> added successfully.', 0, '2024-11-08 12:30:05'),
(4, 1, 'Web Master', 0x323430353a3230313a356330613a3630, 0, 0, 'content', 'Product <b>Motion Backgrounds</b> Updated Successfully.', 0, '2024-11-08 12:33:03'),
(5, 1, 'Web Master', 0x323430353a3230313a356330613a3630, 0, 0, 'content', 'Product <b>Motion Backgrounds</b> Updated Successfully.', 0, '2024-11-08 12:41:56'),
(6, 1, 'Web Master', 0x323430353a3230313a356330613a3630, 0, 0, 'content', 'Product <b>Cinematic Video Templates</b> added successfully.', 0, '2024-11-08 12:48:11'),
(7, 1, 'Web Master', 0x323430353a3230313a356330613a3630, 0, 0, 'content', 'Product <b>Instagram Templates</b> added successfully.', 0, '2024-11-08 12:52:22'),
(8, 1, 'Web Master', 0x323430353a3230313a356330613a3630, 0, 0, 'content', 'Product <b>Instagram Banner Templates</b> added successfully.', 0, '2024-11-08 12:56:34'),
(9, 1, 'Web Master', 0x323430353a3230313a356330613a3630, 0, 0, 'content', 'Product <b>Logo Intros Templates</b> added successfully.', 0, '2024-11-08 13:00:31'),
(10, 1, 'Web Master', 0x323430353a3230313a356330613a3630, 0, 0, 'content', 'Product <b>Logo Opener</b> added successfully.', 0, '2024-11-08 13:02:02'),
(11, 1, 'Web Master', 0x323430353a3230313a356330613a3630, 0, 0, 'content', 'Product <b>Logo Outros Templates</b> added successfully.', 0, '2024-11-08 13:04:30'),
(12, 1, 'Web Master', 0x323430353a3230313a356330613a3630, 0, 0, 'content', 'Product <b>Promo Templates</b> added successfully.', 0, '2024-11-08 13:05:54'),
(13, 1, 'Web Master', 0x323430353a3230313a356330613a3630, 0, 0, 'content', 'Product <b>Social Story Banner</b> added successfully.', 0, '2024-11-08 13:07:18'),
(14, 1, 'Web Master', 0x323430353a3230313a356330613a3630, 0, 0, 'content', 'Product <b>Animated Video Templates</b> added successfully.', 0, '2024-11-08 13:08:25'),
(15, 1, 'Web Master', 0x323430353a3230313a356330613a3630, 0, 0, 'content', 'Product <b>Titles Video Templates</b> added successfully.', 0, '2024-11-08 13:10:06'),
(16, 1, 'Web Master', 0x323430353a3230313a356330613a3630, 0, 0, 'content', 'Product <b>Animated Video Templates</b> Updated Successfully.', 0, '2024-11-08 13:10:23'),
(17, 1, 'Web Master', 0x323430353a3230313a356330613a3630, 0, 0, 'content', 'Product <b>VIDEO EXPLAINER ASSETS</b> added successfully.', 0, '2024-11-08 13:12:43'),
(18, 1, 'Web Master', 0x323430353a3230313a356330613a3630, 0, 0, 'content', 'Product <b>HUNDREDS OF MUSIC TRACK COLLECTION</b> added successfully.', 0, '2024-11-08 13:16:24'),
(19, 1, 'Web Master', 0x323430353a3230313a356330613a3630, 0, 0, 'content', 'Product <b>1500 CLIP ARTS BUNDLE</b> added successfully.', 0, '2024-11-08 13:19:15'),
(20, 1, 'Web Master', 0x323430353a3230313a356330613a3630, 0, 0, 'content', 'Product <b>Animate Anything</b> added successfully.', 0, '2024-11-08 13:20:45'),
(21, 1, 'Web Master', 0x323430353a3230313a356330613a3630, 0, 0, 'content', 'Product <b>Camtasia Like VIDEO EDITOR</b> added successfully.', 0, '2024-11-08 13:21:40'),
(22, 1, 'Web Master', 0x323430353a3230313a356330613a3630, 0, 0, 'content', 'Product <b>SOUND FX COLLECTION</b> added successfully.', 0, '2024-11-08 13:25:23'),
(23, 1, 'Web Master', 0x323430353a3230313a356330613a3630, 0, 0, 'content', 'Product <b>1000+ Viral Reels Bundle</b> added successfully.', 0, '2024-11-08 13:26:10'),
(24, 1, 'Web Master', 0x323430353a3230313a356330613a3630, 0, 0, 'content', 'Product <b>1000+ Viral Reels Bundle</b> Updated Successfully.', 0, '2024-11-08 13:40:15'),
(25, 1, 'Web Master', 0x323430353a3230313a356330613a3630, 0, 0, 'content', 'Product <b>Motion Backgrounds</b> Updated Successfully.', 0, '2024-11-08 13:42:41'),
(26, 1, 'Web Master', 0x323430353a3230313a356330613a3630, 0, 0, 'content', 'Product <b>Cinematic Video Templates</b> Updated Successfully.', 0, '2024-11-08 13:44:42'),
(27, 1, 'Web Master', 0x323430353a3230313a356330613a3630, 0, 0, 'content', 'Product <b>Instagram Templates</b> Updated Successfully.', 0, '2024-11-08 13:46:07'),
(28, 1, 'Web Master', 0x323430353a3230313a356330613a3630, 0, 0, 'content', 'Product <b>Instagram Banner Templates</b> Updated Successfully.', 0, '2024-11-08 13:47:03'),
(29, 1, 'Web Master', 0x323430353a3230313a356330613a3630, 0, 0, 'content', 'Product <b>Test</b> added successfully.', 0, '2024-11-09 05:18:59'),
(30, 1, 'Web Master', 0x323430353a3230313a356330613a3630, 0, 0, 'content', 'Product <b>1000+ Viral Reels Bundle</b> Updated Successfully.', 0, '2024-11-09 06:04:43'),
(31, 1, 'Web Master', 0x323430353a3230313a356330613a3630, 0, 0, 'content', 'Product <b>Logo Intros Templates</b> Updated Successfully.', 0, '2024-11-09 06:11:17'),
(32, 1, 'Web Master', 0x323430353a3230313a356330613a3630, 0, 0, 'content', 'Product <b>Logo Intros Templates</b> Updated Successfully.', 0, '2024-11-09 06:11:55'),
(33, 1, 'Web Master', 0x323430353a3230313a356330613a3630, 0, 0, 'content', 'Product <b>Logo Opener</b> Updated Successfully.', 0, '2024-11-09 06:12:59'),
(34, 1, 'Web Master', 0x323430353a3230313a356330613a3630, 0, 0, 'content', 'Product <b>Logo Outros Templates</b> Updated Successfully.', 0, '2024-11-09 06:14:04'),
(35, 1, 'Web Master', 0x323430353a3230313a356330613a3630, 0, 0, 'content', 'Product <b>Promo Templates</b> Updated Successfully.', 0, '2024-11-09 06:15:21'),
(36, 1, 'Web Master', 0x323430353a3230313a356330613a3630, 0, 0, 'content', 'Product <b>Promo Templates</b> Updated Successfully.', 0, '2024-11-09 06:16:09'),
(37, 1, 'Web Master', 0x323430353a3230313a356330613a3630, 0, 0, 'content', 'Product <b>Social Story Banner</b> Updated Successfully.', 0, '2024-11-09 06:18:06'),
(38, 1, 'Web Master', 0x323430353a3230313a356330613a3630, 0, 0, 'content', 'Product <b>Animated Video Templates</b> Updated Successfully.', 0, '2024-11-09 06:19:09'),
(39, 1, 'Web Master', 0x323430353a3230313a356330613a3630, 0, 0, 'content', 'Product <b>Animated Video Templates</b> Updated Successfully.', 0, '2024-11-09 06:20:05'),
(40, 1, 'Web Master', 0x323430353a3230313a356330613a3630, 0, 0, 'content', 'Product <b>Titles Video Templates</b> Updated Successfully.', 0, '2024-11-09 06:21:01'),
(41, 1, 'Web Master', 0x323430353a3230313a356330613a3630, 0, 0, 'content', 'Product <b>VIDEO EXPLAINER ASSETS</b> Updated Successfully.', 0, '2024-11-09 06:22:02'),
(42, 1, 'Web Master', 0x323430353a3230313a356330613a3630, 0, 0, 'content', 'Product <b>SOUND FX COLLECTION</b> Updated Successfully.', 0, '2024-11-09 06:22:58'),
(43, 1, 'Web Master', 0x323430353a3230313a356330613a3630, 0, 0, 'content', 'Product <b>1500 CLIP ARTS BUNDLE</b> Updated Successfully.', 0, '2024-11-09 06:39:46'),
(44, 1, 'Web Master', 0x323430353a3230313a356330613a3630, 0, 0, 'content', 'Product <b>Animate Anything</b> Updated Successfully.', 0, '2024-11-09 06:40:27'),
(45, 1, 'Web Master', 0x323430353a3230313a356330613a3630, 0, 0, 'content', 'Product <b>Camtasia Like VIDEO EDITOR</b> Updated Successfully.', 0, '2024-11-09 06:41:04');

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

--
-- Table structure for table `blog`
--

CREATE TABLE `blog` (
  `id` int(11) UNSIGNED NOT NULL,
  `category_id` int(11) UNSIGNED NOT NULL DEFAULT 0,
  `user_id` int(11) UNSIGNED NOT NULL DEFAULT 0,
  `title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `body` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `thumb` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `hits` int(6) UNSIGNED DEFAULT 0,
  `show_sharing` tinyint(1) UNSIGNED NOT NULL DEFAULT 1,
  `show_created` tinyint(1) UNSIGNED NOT NULL DEFAULT 1,
  `keywords` varchar(200) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `created` timestamp NOT NULL DEFAULT current_timestamp(),
  `active` tinyint(1) UNSIGNED NOT NULL DEFAULT 1
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `blog_categories`
--

CREATE TABLE `blog_categories` (
  `id` int(6) UNSIGNED NOT NULL,
  `parent_id` int(6) UNSIGNED NOT NULL DEFAULT 0,
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(100) NOT NULL,
  `icon` varchar(100) DEFAULT NULL,
  `perpage` tinyint(3) UNSIGNED NOT NULL DEFAULT 10,
  `keywords` varchar(200) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `sorting` int(6) UNSIGNED NOT NULL DEFAULT 0,
  `active` tinyint(1) UNSIGNED NOT NULL DEFAULT 1
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `cart`
--

CREATE TABLE `cart` (
  `id` int(11) UNSIGNED NOT NULL,
  `user_id` varchar(48) NOT NULL DEFAULT '0',
  `user_m_id` int(11) UNSIGNED NOT NULL DEFAULT 0,
  `product_id` int(11) UNSIGNED NOT NULL DEFAULT 0,
  `membership_id` int(11) UNSIGNED NOT NULL DEFAULT 0,
  `tax` decimal(13,2) UNSIGNED NOT NULL DEFAULT 0.00,
  `totaltax` decimal(13,2) UNSIGNED NOT NULL DEFAULT 0.00,
  `coupon` decimal(13,2) UNSIGNED NOT NULL DEFAULT 0.00,
  `total` decimal(13,2) UNSIGNED NOT NULL DEFAULT 0.00,
  `originalprice` decimal(13,2) UNSIGNED NOT NULL DEFAULT 0.00,
  `totalprice` decimal(13,2) UNSIGNED NOT NULL DEFAULT 0.00,
  `cart_id` varchar(100) DEFAULT NULL,
  `order_id` varchar(100) DEFAULT NULL,
  `created` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `cart`
--

INSERT INTO `cart` (`id`, `user_id`, `user_m_id`, `product_id`, `membership_id`, `tax`, `totaltax`, `coupon`, `total`, `originalprice`, `totalprice`, `cart_id`, `order_id`, `created`) VALUES
(1, '82a8ebb276150cdb9106b56a9d2c700453a69e08', 0, 1, 0, 0.00, 0.00, 0.00, 999.00, 999.00, 999.00, NULL, NULL, '2024-11-08 12:35:19'),
(2, '405b8306352c04e9c539b6d129e4e50c2bd5d1e4', 0, 1, 0, 0.00, 0.00, 0.00, 999.00, 999.00, 999.00, NULL, NULL, '2024-11-08 13:43:30'),
(5, 'ffe72e3566b040cedf79966df61df4f79db85662', 0, 18, 0, 0.00, 0.00, 0.00, 799.00, 799.00, 799.00, NULL, NULL, '2024-11-09 05:26:52');

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

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

CREATE TABLE `categories` (
  `id` int(6) UNSIGNED NOT NULL,
  `name` varchar(100) NOT NULL,
  `parent_id` int(6) UNSIGNED NOT NULL DEFAULT 0,
  `slug` varchar(100) NOT NULL,
  `body` varchar(100) DEFAULT NULL,
  `keywords` varchar(250) DEFAULT NULL,
  `description` varchar(250) DEFAULT NULL,
  `sorting` tinyint(11) UNSIGNED NOT NULL DEFAULT 0,
  `active` tinyint(1) UNSIGNED NOT NULL DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `categories` (`id`, `name`, `parent_id`, `slug`, `body`, `keywords`, `description`, `sorting`, `active`) VALUES
(1, 'E-Books', 0, 'e-books', NULL, NULL, NULL, 1, 1),
(7, 'Templates', 0, 'templates', NULL, NULL, NULL, 2, 1),
(3, 'Software', 0, 'software', NULL, NULL, NULL, 4, 1),
(4, 'Social Media', 0, 'social-media', NULL, NULL, NULL, 5, 1),
(6, 'Video', 0, 'video', NULL, NULL, NULL, 3, 1);

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

--
-- Table structure for table `categories_related`
--

CREATE TABLE `categories_related` (
  `id` int(11) UNSIGNED NOT NULL,
  `product_id` int(11) UNSIGNED NOT NULL DEFAULT 0,
  `category_id` int(11) UNSIGNED NOT NULL DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `categories_related`
--

INSERT INTO `categories_related` (`id`, `product_id`, `category_id`) VALUES
(104, 2, 3),
(105, 3, 3),
(107, 19, 1),
(96, 13, 6),
(119, 12, 6),
(76, 13, 8),
(103, 1, 6),
(106, 4, 3),
(110, 5, 3),
(111, 6, 3),
(112, 7, 3),
(114, 8, 3),
(115, 9, 3),
(117, 10, 6),
(118, 11, 6),
(121, 14, 1),
(122, 15, 7),
(123, 16, 6),
(120, 17, 6),
(108, 18, 7);

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

--
-- Table structure for table `cdkeys`
--

CREATE TABLE `cdkeys` (
  `product_id` int(11) UNSIGNED NOT NULL DEFAULT 0,
  `cdkey` varchar(60) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

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

CREATE TABLE `comments` (
  `id` int(11) UNSIGNED NOT NULL,
  `parent_id` int(11) UNSIGNED NOT NULL DEFAULT 0,
  `product_id` int(11) UNSIGNED NOT NULL DEFAULT 0,
  `username` varchar(24) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` int(11) UNSIGNED NOT NULL DEFAULT 0,
  `email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `body` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `www` varchar(220) DEFAULT NULL,
  `vote_up` int(11) UNSIGNED NOT NULL DEFAULT 0,
  `vote_down` int(11) NOT NULL DEFAULT 0,
  `rating` int(11) UNSIGNED NOT NULL DEFAULT 0,
  `ip` varchar(16) DEFAULT NULL,
  `created` timestamp NOT NULL DEFAULT current_timestamp(),
  `active` tinyint(1) UNSIGNED NOT NULL DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

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

CREATE TABLE `countries` (
  `id` smallint(6) UNSIGNED NOT NULL,
  `abbr` varchar(2) NOT NULL,
  `name` varchar(70) NOT NULL,
  `active` tinyint(1) UNSIGNED NOT NULL DEFAULT 1,
  `home` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
  `vat` decimal(13,2) UNSIGNED NOT NULL DEFAULT 0.00,
  `sorting` smallint(6) UNSIGNED NOT NULL DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `countries` (`id`, `abbr`, `name`, `active`, `home`, `vat`, `sorting`) VALUES
(1, 'AF', 'Afghanistan', 1, 0, 0.00, 0),
(2, 'AL', 'Albania', 1, 0, 0.00, 0),
(3, 'DZ', 'Algeria', 1, 0, 0.00, 0),
(4, 'AS', 'American Samoa', 1, 0, 0.00, 0),
(5, 'AD', 'Andorra', 1, 0, 0.00, 0),
(6, 'AO', 'Angola', 1, 0, 0.00, 0),
(7, 'AI', 'Anguilla', 1, 0, 0.00, 0),
(8, 'AQ', 'Antarctica', 1, 0, 0.00, 0),
(9, 'AG', 'Antigua and Barbuda', 1, 0, 0.00, 0),
(10, 'AR', 'Argentina', 1, 0, 0.00, 0),
(11, 'AM', 'Armenia', 1, 0, 0.00, 0),
(12, 'AW', 'Aruba', 1, 0, 0.00, 0),
(13, 'AU', 'Australia', 1, 0, 0.00, 0),
(14, 'AT', 'Austria', 1, 0, 0.00, 0),
(15, 'AZ', 'Azerbaijan', 1, 0, 0.00, 0),
(16, 'BS', 'Bahamas', 1, 0, 0.00, 0),
(17, 'BH', 'Bahrain', 1, 0, 0.00, 0),
(18, 'BD', 'Bangladesh', 1, 0, 0.00, 0),
(19, 'BB', 'Barbados', 1, 0, 0.00, 0),
(20, 'BY', 'Belarus', 1, 0, 0.00, 0),
(21, 'BE', 'Belgium', 1, 0, 0.00, 0),
(22, 'BZ', 'Belize', 1, 0, 0.00, 0),
(23, 'BJ', 'Benin', 1, 0, 0.00, 0),
(24, 'BM', 'Bermuda', 1, 0, 0.00, 0),
(25, 'BT', 'Bhutan', 1, 0, 0.00, 0),
(26, 'BO', 'Bolivia', 1, 0, 0.00, 0),
(27, 'BA', 'Bosnia and Herzegowina', 1, 0, 0.00, 0),
(28, 'BW', 'Botswana', 1, 0, 0.00, 0),
(29, 'BV', 'Bouvet Island', 1, 0, 0.00, 0),
(30, 'BR', 'Brazil', 1, 0, 0.00, 0),
(31, 'IO', 'British Indian Ocean Territory', 1, 0, 0.00, 0),
(32, 'VG', 'British Virgin Islands', 1, 0, 0.00, 0),
(33, 'BN', 'Brunei Darussalam', 1, 0, 0.00, 0),
(34, 'BG', 'Bulgaria', 1, 0, 0.00, 0),
(35, 'BF', 'Burkina Faso', 1, 0, 0.00, 0),
(36, 'BI', 'Burundi', 1, 0, 0.00, 0),
(37, 'KH', 'Cambodia', 1, 0, 0.00, 0),
(38, 'CM', 'Cameroon', 1, 0, 0.00, 0),
(39, 'CA', 'Canada', 1, 1, 13.00, 1000),
(40, 'CV', 'Cape Verde', 1, 0, 0.00, 0),
(41, 'KY', 'Cayman Islands', 1, 0, 0.00, 0),
(42, 'CF', 'Central African Republic', 1, 0, 0.00, 0),
(43, 'TD', 'Chad', 1, 0, 0.00, 0),
(44, 'CL', 'Chile', 1, 0, 0.00, 0),
(45, 'CN', 'China', 1, 0, 0.00, 0),
(46, 'CX', 'Christmas Island', 1, 0, 0.00, 0),
(47, 'CC', 'Cocos (Keeling) Islands', 1, 0, 0.00, 0),
(48, 'CO', 'Colombia', 1, 0, 0.00, 0),
(49, 'KM', 'Comoros', 1, 0, 0.00, 0),
(50, 'CG', 'Congo', 1, 0, 0.00, 0),
(51, 'CK', 'Cook Islands', 1, 0, 0.00, 0),
(52, 'CR', 'Costa Rica', 1, 0, 0.00, 0),
(53, 'CI', 'Cote D\'ivoire', 1, 0, 0.00, 0),
(54, 'HR', 'Croatia', 1, 0, 0.00, 0),
(55, 'CU', 'Cuba', 1, 0, 0.00, 0),
(56, 'CY', 'Cyprus', 1, 0, 0.00, 0),
(57, 'CZ', 'Czech Republic', 1, 0, 0.00, 0),
(58, 'DK', 'Denmark', 1, 0, 0.00, 0),
(59, 'DJ', 'Djibouti', 1, 0, 0.00, 0),
(60, 'DM', 'Dominica', 1, 0, 0.00, 0),
(61, 'DO', 'Dominican Republic', 1, 0, 0.00, 0),
(62, 'TP', 'East Timor', 1, 0, 0.00, 0),
(63, 'EC', 'Ecuador', 1, 0, 0.00, 0),
(64, 'EG', 'Egypt', 1, 0, 0.00, 0),
(65, 'SV', 'El Salvador', 1, 0, 0.00, 0),
(66, 'GQ', 'Equatorial Guinea', 1, 0, 0.00, 0),
(67, 'ER', 'Eritrea', 1, 0, 0.00, 0),
(68, 'EE', 'Estonia', 1, 0, 0.00, 0),
(69, 'ET', 'Ethiopia', 1, 0, 0.00, 0),
(70, 'FK', 'Falkland Islands (Malvinas)', 1, 0, 0.00, 0),
(71, 'FO', 'Faroe Islands', 1, 0, 0.00, 0),
(72, 'FJ', 'Fiji', 1, 0, 0.00, 0),
(73, 'FI', 'Finland', 1, 0, 0.00, 0),
(74, 'FR', 'France', 1, 0, 0.00, 0),
(75, 'GF', 'French Guiana', 1, 0, 0.00, 0),
(76, 'PF', 'French Polynesia', 1, 0, 0.00, 0),
(77, 'TF', 'French Southern Territories', 1, 0, 0.00, 0),
(78, 'GA', 'Gabon', 1, 0, 0.00, 0),
(79, 'GM', 'Gambia', 1, 0, 0.00, 0),
(80, 'GE', 'Georgia', 1, 0, 0.00, 0),
(81, 'DE', 'Germany', 1, 0, 0.00, 0),
(82, 'GH', 'Ghana', 1, 0, 0.00, 0),
(83, 'GI', 'Gibraltar', 1, 0, 0.00, 0),
(84, 'GR', 'Greece', 1, 0, 0.00, 0),
(85, 'GL', 'Greenland', 1, 0, 0.00, 0),
(86, 'GD', 'Grenada', 1, 0, 0.00, 0),
(87, 'GP', 'Guadeloupe', 1, 0, 0.00, 0),
(88, 'GU', 'Guam', 1, 0, 0.00, 0),
(89, 'GT', 'Guatemala', 1, 0, 0.00, 0),
(90, 'GN', 'Guinea', 1, 0, 0.00, 0),
(91, 'GW', 'Guinea-Bissau', 1, 0, 0.00, 0),
(92, 'GY', 'Guyana', 1, 0, 0.00, 0),
(93, 'HT', 'Haiti', 1, 0, 0.00, 0),
(94, 'HM', 'Heard and McDonald Islands', 1, 0, 0.00, 0),
(95, 'HN', 'Honduras', 1, 0, 0.00, 0),
(96, 'HK', 'Hong Kong', 1, 0, 0.00, 0),
(97, 'HU', 'Hungary', 1, 0, 0.00, 0),
(98, 'IS', 'Iceland', 1, 0, 0.00, 0),
(99, 'IN', 'India', 1, 0, 0.00, 0),
(100, 'ID', 'Indonesia', 1, 0, 0.00, 0),
(101, 'IQ', 'Iraq', 1, 0, 0.00, 0),
(102, 'IE', 'Ireland', 1, 0, 0.00, 0),
(103, 'IR', 'Islamic Republic of Iran', 1, 0, 0.00, 0),
(104, 'IL', 'Israel', 1, 0, 0.00, 0),
(105, 'IT', 'Italy', 1, 0, 0.00, 0),
(106, 'JM', 'Jamaica', 1, 0, 0.00, 0),
(107, 'JP', 'Japan', 1, 0, 0.00, 0),
(108, 'JO', 'Jordan', 1, 0, 0.00, 0),
(109, 'KZ', 'Kazakhstan', 1, 0, 0.00, 0),
(110, 'KE', 'Kenya', 1, 0, 0.00, 0),
(111, 'KI', 'Kiribati', 1, 0, 0.00, 0),
(112, 'KP', 'Korea, Dem. Peoples Rep of', 1, 0, 0.00, 0),
(113, 'KR', 'Korea, Republic of', 1, 0, 0.00, 0),
(114, 'KW', 'Kuwait', 1, 0, 0.00, 0),
(115, 'KG', 'Kyrgyzstan', 1, 0, 0.00, 0),
(116, 'LA', 'Laos', 1, 0, 0.00, 0),
(117, 'LV', 'Latvia', 1, 0, 0.00, 0),
(118, 'LB', 'Lebanon', 1, 0, 0.00, 0),
(119, 'LS', 'Lesotho', 1, 0, 0.00, 0),
(120, 'LR', 'Liberia', 1, 0, 0.00, 0),
(121, 'LY', 'Libyan Arab Jamahiriya', 1, 0, 0.00, 0),
(122, 'LI', 'Liechtenstein', 1, 0, 0.00, 0),
(123, 'LT', 'Lithuania', 1, 0, 0.00, 0),
(124, 'LU', 'Luxembourg', 1, 0, 0.00, 0),
(125, 'MO', 'Macau', 1, 0, 0.00, 0),
(126, 'MK', 'Macedonia', 1, 0, 0.00, 0),
(127, 'MG', 'Madagascar', 1, 0, 0.00, 0),
(128, 'MW', 'Malawi', 1, 0, 0.00, 0),
(129, 'MY', 'Malaysia', 1, 0, 0.00, 0),
(130, 'MV', 'Maldives', 1, 0, 0.00, 0),
(131, 'ML', 'Mali', 1, 0, 0.00, 0),
(132, 'MT', 'Malta', 1, 0, 0.00, 0),
(133, 'MH', 'Marshall Islands', 1, 0, 0.00, 0),
(134, 'MQ', 'Martinique', 1, 0, 0.00, 0),
(135, 'MR', 'Mauritania', 1, 0, 0.00, 0),
(136, 'MU', 'Mauritius', 1, 0, 0.00, 0),
(137, 'YT', 'Mayotte', 1, 0, 0.00, 0),
(138, 'MX', 'Mexico', 1, 0, 0.00, 0),
(139, 'FM', 'Micronesia', 1, 0, 0.00, 0),
(140, 'MD', 'Moldova, Republic of', 1, 0, 0.00, 0),
(141, 'MC', 'Monaco', 1, 0, 0.00, 0),
(142, 'MN', 'Mongolia', 1, 0, 0.00, 0),
(143, 'MS', 'Montserrat', 1, 0, 0.00, 0),
(144, 'MA', 'Morocco', 1, 0, 0.00, 0),
(145, 'MZ', 'Mozambique', 1, 0, 0.00, 0),
(146, 'MM', 'Myanmar', 1, 0, 0.00, 0),
(147, 'NA', 'Namibia', 1, 0, 0.00, 0),
(148, 'NR', 'Nauru', 1, 0, 0.00, 0),
(149, 'NP', 'Nepal', 1, 0, 0.00, 0),
(150, 'NL', 'Netherlands', 1, 0, 0.00, 0),
(151, 'AN', 'Netherlands Antilles', 1, 0, 0.00, 0),
(152, 'NC', 'New Caledonia', 1, 0, 0.00, 0),
(153, 'NZ', 'New Zealand', 1, 0, 0.00, 0),
(154, 'NI', 'Nicaragua', 1, 0, 0.00, 0),
(155, 'NE', 'Niger', 1, 0, 0.00, 0),
(156, 'NG', 'Nigeria', 1, 0, 0.00, 0),
(157, 'NU', 'Niue', 1, 0, 0.00, 0),
(158, 'NF', 'Norfolk Island', 1, 0, 0.00, 0),
(159, 'MP', 'Northern Mariana Islands', 1, 0, 0.00, 0),
(160, 'NO', 'Norway', 1, 0, 0.00, 0),
(161, 'OM', 'Oman', 1, 0, 0.00, 0),
(162, 'PK', 'Pakistan', 1, 0, 0.00, 0),
(163, 'PW', 'Palau', 1, 0, 0.00, 0),
(164, 'PA', 'Panama', 1, 0, 0.00, 0),
(165, 'PG', 'Papua New Guinea', 1, 0, 0.00, 0),
(166, 'PY', 'Paraguay', 1, 0, 0.00, 0),
(167, 'PE', 'Peru', 1, 0, 0.00, 0),
(168, 'PH', 'Philippines', 1, 0, 0.00, 0),
(169, 'PN', 'Pitcairn', 1, 0, 0.00, 0),
(170, 'PL', 'Poland', 1, 0, 0.00, 0),
(171, 'PT', 'Portugal', 1, 0, 0.00, 0),
(172, 'PR', 'Puerto Rico', 1, 0, 0.00, 0),
(173, 'QA', 'Qatar', 1, 0, 0.00, 0),
(174, 'RE', 'Reunion', 1, 0, 0.00, 0),
(175, 'RO', 'Romania', 1, 0, 0.00, 0),
(176, 'RU', 'Russian Federation', 1, 0, 0.00, 0),
(177, 'RW', 'Rwanda', 1, 0, 0.00, 0),
(178, 'LC', 'Saint Lucia', 1, 0, 0.00, 0),
(179, 'WS', 'Samoa', 1, 0, 0.00, 0),
(180, 'SM', 'San Marino', 1, 0, 0.00, 0),
(181, 'ST', 'Sao Tome and Principe', 1, 0, 0.00, 0),
(182, 'SA', 'Saudi Arabia', 1, 0, 0.00, 0),
(183, 'SN', 'Senegal', 1, 0, 0.00, 0),
(184, 'RS', 'Serbia', 1, 0, 0.00, 0),
(185, 'SC', 'Seychelles', 1, 0, 0.00, 0),
(186, 'SL', 'Sierra Leone', 1, 0, 0.00, 0),
(187, 'SG', 'Singapore', 1, 0, 0.00, 0),
(188, 'SK', 'Slovakia', 1, 0, 0.00, 0),
(189, 'SI', 'Slovenia', 1, 0, 0.00, 0),
(190, 'SB', 'Solomon Islands', 1, 0, 0.00, 0),
(191, 'SO', 'Somalia', 1, 0, 0.00, 0),
(192, 'ZA', 'South Africa', 1, 0, 0.00, 0),
(193, 'ES', 'Spain', 1, 0, 0.00, 0),
(194, 'LK', 'Sri Lanka', 1, 0, 0.00, 0),
(195, 'SH', 'St. Helena', 1, 0, 0.00, 0),
(196, 'KN', 'St. Kitts and Nevis', 1, 0, 0.00, 0),
(197, 'PM', 'St. Pierre and Miquelon', 1, 0, 0.00, 0),
(198, 'VC', 'St. Vincent and the Grenadines', 1, 0, 0.00, 0),
(199, 'SD', 'Sudan', 1, 0, 0.00, 0),
(200, 'SR', 'Suriname', 1, 0, 0.00, 0),
(201, 'SJ', 'Svalbard and Jan Mayen Islands', 1, 0, 0.00, 0),
(202, 'SZ', 'Swaziland', 1, 0, 0.00, 0),
(203, 'SE', 'Sweden', 1, 0, 0.00, 0),
(204, 'CH', 'Switzerland', 1, 0, 0.00, 0),
(205, 'SY', 'Syrian Arab Republic', 1, 0, 0.00, 0),
(206, 'TW', 'Taiwan', 1, 0, 0.00, 0),
(207, 'TJ', 'Tajikistan', 1, 0, 0.00, 0),
(208, 'TZ', 'Tanzania, United Republic of', 1, 0, 0.00, 0),
(209, 'TH', 'Thailand', 1, 0, 0.00, 0),
(210, 'TG', 'Togo', 1, 0, 0.00, 0),
(211, 'TK', 'Tokelau', 1, 0, 0.00, 0),
(212, 'TO', 'Tonga', 1, 0, 0.00, 0),
(213, 'TT', 'Trinidad and Tobago', 1, 0, 0.00, 0),
(214, 'TN', 'Tunisia', 1, 0, 0.00, 0),
(215, 'TR', 'Turkey', 1, 0, 0.00, 0),
(216, 'TM', 'Turkmenistan', 1, 0, 0.00, 0),
(217, 'TC', 'Turks and Caicos Islands', 1, 0, 0.00, 0),
(218, 'TV', 'Tuvalu', 1, 0, 0.00, 0),
(219, 'UG', 'Uganda', 1, 0, 0.00, 0),
(220, 'UA', 'Ukraine', 1, 0, 0.00, 0),
(221, 'AE', 'United Arab Emirates', 1, 0, 0.00, 0),
(222, 'GB', 'United Kingdom (GB)', 1, 0, 23.50, 999),
(224, 'US', 'United States', 1, 0, 7.50, 998),
(225, 'VI', 'United States Virgin Islands', 1, 0, 0.00, 0),
(226, 'UY', 'Uruguay', 1, 0, 0.00, 0),
(227, 'UZ', 'Uzbekistan', 1, 0, 0.00, 0),
(228, 'VU', 'Vanuatu', 1, 0, 0.00, 0),
(229, 'VA', 'Vatican City State', 1, 0, 0.00, 0),
(230, 'VE', 'Venezuela', 1, 0, 0.00, 0),
(231, 'VN', 'Vietnam', 1, 0, 0.00, 0),
(232, 'WF', 'Wallis And Futuna Islands', 1, 0, 0.00, 0),
(233, 'EH', 'Western Sahara', 1, 0, 0.00, 0),
(234, 'YE', 'Yemen', 1, 0, 0.00, 0),
(235, 'ZR', 'Zaire', 1, 0, 0.00, 0),
(236, 'ZM', 'Zambia', 1, 0, 0.00, 0),
(237, 'ZW', 'Zimbabwe', 1, 0, 0.00, 0);

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

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

CREATE TABLE `coupons` (
  `id` int(1) UNSIGNED NOT NULL,
  `title` varchar(100) NOT NULL,
  `code` varchar(30) NOT NULL,
  `discount` smallint(2) UNSIGNED NOT NULL DEFAULT 0,
  `type` varchar(1) NOT NULL DEFAULT 'p',
  `minval` decimal(12,2) UNSIGNED NOT NULL DEFAULT 0.00,
  `validuntil` date DEFAULT NULL,
  `created` timestamp NOT NULL DEFAULT current_timestamp(),
  `active` tinyint(1) UNSIGNED NOT NULL DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `cronjobs`
--

CREATE TABLE `cronjobs` (
  `id` int(11) UNSIGNED NOT NULL,
  `user_id` int(11) UNSIGNED NOT NULL DEFAULT 0,
  `membership_id` int(11) UNSIGNED NOT NULL DEFAULT 0,
  `stripe_customer` varchar(60) NOT NULL,
  `stripe_pm` varchar(80) NOT NULL,
  `amount` decimal(10,2) UNSIGNED NOT NULL DEFAULT 0.00,
  `created` timestamp NOT NULL DEFAULT current_timestamp(),
  `renewal` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `custom_fields`
--

CREATE TABLE `custom_fields` (
  `id` int(6) UNSIGNED NOT NULL,
  `title` varchar(60) NOT NULL,
  `tooltip` varchar(100) DEFAULT NULL,
  `name` varchar(20) NOT NULL,
  `required` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
  `section` varchar(30) DEFAULT NULL,
  `sorting` int(4) UNSIGNED NOT NULL DEFAULT 0,
  `active` tinyint(1) UNSIGNED NOT NULL DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `custom_fields`
--

INSERT INTO `custom_fields` (`id`, `title`, `tooltip`, `name`, `required`, `section`, `sorting`, `active`) VALUES
(1, 'Phone number', '', '1K1NFZ', 0, 'product', 0, 1);

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

--
-- Table structure for table `custom_fields_data`
--

CREATE TABLE `custom_fields_data` (
  `id` int(11) UNSIGNED NOT NULL,
  `user_id` int(11) UNSIGNED NOT NULL DEFAULT 0,
  `product_id` int(11) UNSIGNED NOT NULL DEFAULT 0,
  `field_id` int(11) UNSIGNED NOT NULL DEFAULT 0,
  `field_name` varchar(40) DEFAULT NULL,
  `field_value` varchar(100) DEFAULT NULL,
  `section` varchar(30) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `custom_fields_data`
--

INSERT INTO `custom_fields_data` (`id`, `user_id`, `product_id`, `field_id`, `field_name`, `field_value`, `section`) VALUES
(1, 0, 1, 1, '1K1NFZ', '', 'product'),
(2, 0, 2, 1, '1K1NFZ', '', 'product'),
(3, 0, 3, 1, '1K1NFZ', '', 'product'),
(4, 0, 4, 1, '1K1NFZ', '', 'product'),
(5, 0, 5, 1, '1K1NFZ', '', 'product'),
(6, 0, 6, 1, '1K1NFZ', '', 'product'),
(7, 0, 7, 1, '1K1NFZ', '', 'product'),
(8, 0, 8, 1, '1K1NFZ', '', 'product'),
(9, 0, 9, 1, '1K1NFZ', '', 'product'),
(10, 0, 10, 1, '1K1NFZ', '', 'product'),
(11, 0, 11, 1, '1K1NFZ', '', 'product'),
(12, 0, 12, 1, '1K1NFZ', '', 'product'),
(13, 0, 13, 1, '1K1NFZ', NULL, 'product'),
(14, 0, 14, 1, '1K1NFZ', '', 'product'),
(15, 0, 15, 1, '1K1NFZ', '', 'product'),
(16, 0, 16, 1, '1K1NFZ', '', 'product'),
(17, 0, 17, 1, '1K1NFZ', '', 'product'),
(18, 0, 18, 1, '1K1NFZ', '', 'product');

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

--
-- Table structure for table `email_templates`
--

CREATE TABLE `email_templates` (
  `id` int(5) UNSIGNED NOT NULL,
  `name` varchar(100) NOT NULL,
  `subject` varchar(150) NOT NULL,
  `help` tinytext DEFAULT NULL,
  `body` text NOT NULL,
  `type` enum('news','mailer') DEFAULT 'mailer',
  `typeid` varchar(30) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;


INSERT INTO `email_templates` (`id`, `name`, `subject`, `help`, `body`, `type`, `typeid`) VALUES
(13, 'Membership Expired', 'Membership Has Expired', 'This template is used to notify user when membership is about to expire a day before. ', '<div id=\"#kt_app_body_content\" style=\"background-color:#D5D9E2; font-family:Arial,Helvetica,sans-serif; line-height: 1.5; min-height: 100%; font-weight: normal; font-size: 15px; color: #2F3044; margin:0; padding:0; width:100%;\">\r\n  <div style=\"background-color:#ffffff; padding: 45px 0 34px 0; border-radius: 24px; margin:40px auto; max-width: 600px;\">\r\n    <table style=\"border-collapse:collapse\" width=\"100%\" height=\"auto\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\" align=\"center\">\r\n      <tbody>\r\n        <tr>\r\n          <td style=\"text-align:center; padding-bottom: 10px\" valign=\"center\" align=\"center\"><div style=\"text-align:center; margin:0 15px 34px 15px\">\r\n              <div style=\"margin-bottom: 10px\">\r\n                <a href=\"[SITEURL]\" rel=\"noopener\" target=\"_blank\">\r\n                <img alt=\"Logo\" src=\"[SITEURL]/uploads/[LOGO]\" style=\"height: 32px\" data-image=\"96wzboz0ihr4\">\r\n                </a>\r\n              </div>\r\n              <div style=\"margin-bottom: 15px\">\r\n                <img alt=\"image\" src=\"[SITEURL]/assets/email/email_membership.svg\" style=\"width:170px\" data-image=\"snecu3fz98bu\">\r\n              </div>\r\n              <div style=\"font-size: 14px; font-weight: 500; margin-bottom: 27px; font-family:Arial,Helvetica,sans-serif;\">\r\n                <p style=\"margin-bottom:9px; color:#181C32; font-size: 22px; font-weight:700\">Hey [NAME]!</p>\r\n                <p style=\"margin-bottom:2px; color:#F44336\">Your current membership has expired! </p>\r\n				  <p style=\"margin-bottom:2px; color:#7E8299\">Please login to your user panel to extend or upgrade your membership.. </p>\r\n              </div>\r\n              <a href=\"[LINK]\" target=\"_blank\" style=\"background-color:#2196F3; border-radius:6px;display:inline-block; padding:11px 19px; color: #FFFFFF; font-size: 14px; font-weight:500;\"> Login</a>\r\n            </div></td>\r\n        </tr>\r\n        <tr>\r\n          <td style=\"font-size: 13px; text-align:center; padding: 0 10px 10px 10px; font-weight: 500; color: #A1A5B7; font-family:Arial,Helvetica,sans-serif\" valign=\"center\" align=\"center\"><p style=\"color:#181C32; font-size: 16px; font-weight: 600; margin-bottom:9px\">Stay in touch</p>\r\n<p style=\"margin-bottom:4px\">You may reach us at\r\n              <a href=\"[SITEURL]\" rel=\"noopener\" target=\"_blank\" style=\"font-weight: 600\"> [SITE_NAME]</a>\r\n            </p>\r\n<p>We serve Mon-Fri, 9AM-18AM</p></td>\r\n        </tr>\r\n        <tr>\r\n          <td style=\"text-align:center; padding-bottom: 20px;\" valign=\"center\" align=\"center\"><a href=\"mailto:[CEMAIL]\" style=\"margin-right:10px\"><img alt=\"Logo\" src=\"[SITEURL]/assets/email/icon-email.svg\" style=\"width:24px\" data-image=\"gj75tx95851x\"></a>\r\n<a href=\"https://facebook.com/[FB]\" style=\"margin-right:10px\"><img alt=\"Logo\" src=\"[SITEURL]/assets/email/icon-facebook.svg\" style=\"width:24px\" data-image=\"0yrtm40v9wm8\"></a>\r\n<a href=\"https://twitter.com/[TW]\"><img alt=\"Logo\" src=\"[SITEURL]/assets/email/icon-twitter.svg\" style=\"width:24px\" data-image=\"lz2511lnq040\"></a></td>\r\n        </tr>\r\n        <tr>\r\n          <td style=\"font-size: 13px; padding:0 15px; text-align:center; font-weight: 500; color: #A1A5B7;font-family:Arial,Helvetica,sans-serif\" valign=\"center\" align=\"center\"><p> The information above is gathered from the user input. © Copyright [DATE] [COMPANY]. All rights reserved.</p></td>\r\n        </tr>\r\n      </tbody>\r\n    </table>\r\n  </div>\r\n</div>', 'mailer', 'memExpired'),
(14, 'New Comment', 'New Comment Added', 'This template is used to notify admin when comment has been submitted.', '<div id=\"#kt_app_body_content\" style=\"background-color:#D5D9E2; font-family:Arial,Helvetica,sans-serif; line-height: 1.5; min-height: 100%; font-weight: normal; font-size: 15px; color: #2F3044; margin:0; padding:0; width:100%;\">\r\n  <div style=\"background-color:#ffffff; padding: 45px 0 34px 0; border-radius: 24px; margin:40px auto; max-width: 600px;\">\r\n    <table style=\"border-collapse:collapse\" width=\"100%\" height=\"auto\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\" align=\"center\">\r\n      <tbody>\r\n        <tr>\r\n          <td style=\"text-align:center; padding-bottom: 10px\" valign=\"center\" align=\"center\"><div style=\"text-align:center; margin:0 15px 34px 15px\">\r\n              <div style=\"margin-bottom: 10px\">\r\n                <a href=\"[SITEURL]\" rel=\"noopener\" target=\"_blank\">\r\n                <img alt=\"Logo\" src=\"[SITEURL]/uploads/[LOGO]\" style=\"height: 32px\" data-image=\"d3mnag0c7bd8\">\r\n                </a>\r\n              </div>\r\n              <div style=\"margin-bottom: 15px\">\r\n                <img alt=\"image\" src=\"[SITEURL]/assets/email/email_comment.svg\" style=\"width:170px\" data-image=\"56yqk8ial4v9\">\r\n              </div>\r\n              <div style=\"font-size: 14px; font-weight: 500; margin-bottom: 27px; font-family:Arial,Helvetica,sans-serif;\">\r\n                <p style=\"margin-bottom:9px; color:#181C32; font-size: 22px; font-weight:700\">Hey Admin!</p>\r\n                <p style=\"margin-bottom:2px; color:#7E8299\">You have a new comment post. </p>\r\n                <p style=\"margin-bottom:2px; color:#7E8299\">If comments are not auto approved, you will need to manually approve from admin panel. Here are the details: </p>\r\n              </div>\r\n              <div style=\"font-size: 14px; font-weight: 500; margin-bottom: 27px; font-family:Arial,Helvetica,sans-serif;text-align:left\">\r\n                <p style=\"margin-bottom:2px; color:#7E8299\">From: [NAME]</p>\r\n                <p style=\"margin-bottom:2px; color:#7E8299\">Page: [PAGEURL]</p>\r\n                <p style=\"margin-bottom:2px; color:#7E8299\">IP: [IP]</p>\r\n              </div>\r\n              <div style=\"font-size: 14px; font-weight: 500; margin-bottom: 27px; font-family:Arial,Helvetica,sans-serif;text-align:left\"> [MESSAGE] </div>\r\n            </div></td>\r\n        </tr>\r\n        <tr>\r\n          <td style=\"font-size: 13px; text-align:center; padding: 0 10px 10px 10px; font-weight: 500; color: #A1A5B7; font-family:Arial,Helvetica,sans-serif\" valign=\"center\" align=\"center\"><p style=\"color:#181C32; font-size: 16px; font-weight: 600; margin-bottom:9px\">Stay in touch</p>\r\n<p style=\"margin-bottom:4px\">You may reach us at\r\n              <a href=\"[SITEURL]\" rel=\"noopener\" target=\"_blank\" style=\"font-weight: 600\"> [SITE_NAME]</a>\r\n            </p>\r\n<p>We serve Mon-Fri, 9AM-18AM</p></td>\r\n        </tr>\r\n        <tr>\r\n          <td style=\"text-align:center; padding-bottom: 20px;\" valign=\"center\" align=\"center\"><a href=\"mailto:[CEMAIL]\" style=\"margin-right:10px\"><img alt=\"Logo\" src=\"[SITEURL]/assets/email/icon-email.svg\" style=\"width:24px\" data-image=\"zvt2fojn5zqc\"></a>\r\n<a href=\"https://facebook.com/[FB]\" style=\"margin-right:10px\"><img alt=\"Logo\" src=\"[SITEURL]/assets/email/icon-facebook.svg\" style=\"width:24px\" data-image=\"zhfauoxc9irn\"></a>\r\n<a href=\"https://twitter.com/[TW]\"><img alt=\"Logo\" src=\"[SITEURL]/assets/email/icon-twitter.svg\" style=\"width:24px\" data-image=\"d3k55hv60sjy\"></a></td>\r\n        </tr>\r\n        <tr>\r\n          <td style=\"font-size: 13px; padding:0 15px; text-align:center; font-weight: 500; color: #A1A5B7;font-family:Arial,Helvetica,sans-serif\" valign=\"center\" align=\"center\"><p> The information above is gathered from the user input. © Copyright [DATE] [COMPANY]. All rights reserved.</p></td>\r\n        </tr>\r\n      </tbody>\r\n    </table>\r\n  </div>\r\n</div>', 'mailer', 'newComment'),
(15, 'Notify User Transaction', 'Your product is ready for download', 'This template is used to notify user when manual transaction has been processed.', '<div id=\"#kt_app_body_content\" style=\"background-color:#D5D9E2; font-family:Arial,Helvetica,sans-serif; line-height: 1.5; min-height: 100%; font-weight: normal; font-size: 15px; color: #2F3044; margin:0; padding:0; width:100%;\">\r\n  <div style=\"background-color:#ffffff; padding: 45px 0 34px 0; border-radius: 24px; margin:40px auto; max-width: 600px;\">\r\n    <table style=\"border-collapse:collapse\" width=\"100%\" height=\"auto\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\" align=\"center\">\r\n      <tbody>\r\n        <tr>\r\n          <td style=\"text-align:center; padding-bottom: 10px\" valign=\"center\" align=\"center\"><div style=\"text-align:center; margin:0 15px 34px 15px\">\r\n              <div style=\"margin-bottom: 10px\">\r\n                <a href=\"[SITEURL]\" rel=\"noopener\" target=\"_blank\">\r\n                <img alt=\"Logo\" src=\"[SITEURL]/uploads/[LOGO]\" style=\"height: 32px\" data-image=\"e0f1san1tw55\">\r\n                </a>\r\n              </div>\r\n              <div style=\"margin-bottom: 15px\">\r\n                <img alt=\"image\" src=\"[SITEURL]/assets/email/email_bag.svg\" style=\"width:170px\" data-image=\"808wpj5ayss4\">\r\n              </div>\r\n              <div style=\"font-size: 14px; font-weight: 500; margin-bottom: 27px; font-family:Arial,Helvetica,sans-serif;\">\r\n                <p style=\"margin-bottom:9px; color:#181C32; font-size: 22px; font-weight:700\">Hey [NAME]!</p>\r\n                <p style=\"margin-bottom:2px; color:#7E8299\">Your product [ITEMNAME] is ready for download </p>\r\n              </div>\r\n		<p style=\"margin-bottom:2px; color:#7E8299;margin-bottom: 16px;\">Login into your dashboard to view this transaction</p>\r\n		<a href=\"[LINK]\" target=\"_blank\" style=\"background-color:#2196F3; border-radius:6px;display:inline-block; padding:11px 19px; color: #FFFFFF; font-size: 14px; font-weight:500;\"> User Dashboard</a>\r\n            </div></td>\r\n        </tr>\r\n        <tr>\r\n          <td style=\"font-size: 13px; text-align:center; padding: 0 10px 10px 10px; font-weight: 500; color: #A1A5B7; font-family:Arial,Helvetica,sans-serif\" valign=\"center\" align=\"center\"><p style=\"color:#181C32; font-size: 16px; font-weight: 600; margin-bottom:9px\">Stay in touch</p>\r\n<p style=\"margin-bottom:4px\">You may reach us at\r\n              <a href=\"[SITEURL]\" rel=\"noopener\" target=\"_blank\" style=\"font-weight: 600\"> [SITE_NAME]</a>\r\n            </p>\r\n<p>We serve Mon-Fri, 9AM-18AM</p></td>\r\n        </tr>\r\n        <tr>\r\n          <td style=\"text-align:center; padding-bottom: 20px;\" valign=\"center\" align=\"center\"><a href=\"mailto:[CEMAIL]\" style=\"margin-right:10px\"><img alt=\"Logo\" src=\"[SITEURL]/assets/email/icon-email.svg\" style=\"width:24px\" data-image=\"uypum0hkj2to\"></a>\r\n<a href=\"https://facebook.com/[FB]\" style=\"margin-right:10px\"><img alt=\"Logo\" src=\"[SITEURL]/assets/email/icon-facebook.svg\" style=\"width:24px\" data-image=\"tej6sqoc1hph\"></a>\r\n<a href=\"https://twitter.com/[TW]\"><img alt=\"Logo\" src=\"[SITEURL]/assets/email/icon-twitter.svg\" style=\"width:24px\" data-image=\"acz5r5lb0g8m\"></a></td>\r\n        </tr>\r\n        <tr>\r\n          <td style=\"font-size: 13px; padding:0 15px; text-align:center; font-weight: 500; color: #A1A5B7;font-family:Arial,Helvetica,sans-serif\" valign=\"center\" align=\"center\"><p> The information above is gathered from the user input. © Copyright [DATE] [COMPANY]. All rights reserved.</p></td>\r\n        </tr>\r\n      </tbody>\r\n    </table>\r\n  </div>\r\n</div>', 'mailer', 'notifyUser'),
(16, 'Membership Updated', 'Membership Has been Updated', 'This template is used to notifu user about membership update', '<div id=\"#kt_app_body_content\" style=\"background-color:#D5D9E2; font-family:Arial,Helvetica,sans-serif; line-height: 1.5; min-height: 100%; font-weight: normal; font-size: 15px; color: #2F3044; margin:0; padding:0; width:100%;\">\r\n  <div style=\"background-color:#ffffff; padding: 45px 0 34px 0; border-radius: 24px; margin:40px auto; max-width: 600px;\">\r\n    <table style=\"border-collapse:collapse\" width=\"100%\" height=\"auto\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\" align=\"center\">\r\n      <tbody>\r\n        <tr>\r\n          <td style=\"text-align:center; padding-bottom: 10px\" valign=\"center\" align=\"center\"><div style=\"text-align:center; margin:0 15px 34px 15px\">\r\n              <div style=\"margin-bottom: 10px\">\r\n                <a href=\"[SITEURL]\" rel=\"noopener\" target=\"_blank\">\r\n                <img alt=\"Logo\" src=\"[SITEURL]/uploads/[LOGO]\" style=\"height: 32px\" data-image=\"96wzboz0ihr4\">\r\n                </a>\r\n              </div>\r\n              <div style=\"margin-bottom: 15px\">\r\n                <img alt=\"image\" src=\"[SITEURL]/assets/email/email_membership.svg\" style=\"width:170px\" data-image=\"snecu3fz98bu\">\r\n              </div>\r\n              <div style=\"font-size: 14px; font-weight: 500; margin-bottom: 27px; font-family:Arial,Helvetica,sans-serif;\">\r\n                <p style=\"margin-bottom:9px; color:#181C32; font-size: 22px; font-weight:700\">Hey [NAME]!</p>\r\n                <p style=\"margin-bottom:2px;\">Your current membership has been updated! </p>\r\n                <p style=\"margin-bottom:2px; color:#7E8299\">Membership: [MEMBERSHIP] </p>\r\n                <p style=\"margin-bottom:2px; color:#7E8299\">Expire: [EXPIRE] </p>\r\n              </div>\r\n              <a href=\"[LINK]\" target=\"_blank\" style=\"background-color:#2196F3; border-radius:6px;display:inline-block; padding:11px 19px; color: #FFFFFF; font-size: 14px; font-weight:500;\"> Login</a>\r\n            </div></td>\r\n        </tr>\r\n        <tr>\r\n          <td style=\"font-size: 13px; text-align:center; padding: 0 10px 10px 10px; font-weight: 500; color: #A1A5B7; font-family:Arial,Helvetica,sans-serif\" valign=\"center\" align=\"center\"><p style=\"color:#181C32; font-size: 16px; font-weight: 600; margin-bottom:9px\">Stay in touch</p>\r\n<p style=\"margin-bottom:4px\">You may reach us at\r\n              <a href=\"[SITEURL]\" rel=\"noopener\" target=\"_blank\" style=\"font-weight: 600\"> [SITE_NAME]</a>\r\n            </p>\r\n<p>We serve Mon-Fri, 9AM-18AM</p></td>\r\n        </tr>\r\n        <tr>\r\n          <td style=\"text-align:center; padding-bottom: 20px;\" valign=\"center\" align=\"center\"><a href=\"mailto:[CEMAIL]\" style=\"margin-right:10px\"><img alt=\"Logo\" src=\"[SITEURL]/assets/email/icon-email.svg\" style=\"width:24px\" data-image=\"gj75tx95851x\"></a>\r\n<a href=\"https://facebook.com/[FB]\" style=\"margin-right:10px\"><img alt=\"Logo\" src=\"[SITEURL]/assets/email/icon-facebook.svg\" style=\"width:24px\" data-image=\"0yrtm40v9wm8\"></a>\r\n<a href=\"https://twitter.com/[TW]\"><img alt=\"Logo\" src=\"[SITEURL]/assets/email/icon-twitter.svg\" style=\"width:24px\" data-image=\"lz2511lnq040\"></a></td>\r\n        </tr>\r\n        <tr>\r\n          <td style=\"font-size: 13px; padding:0 15px; text-align:center; font-weight: 500; color: #A1A5B7;font-family:Arial,Helvetica,sans-serif\" valign=\"center\" align=\"center\"><p> The information above is gathered from the user input. © Copyright [DATE] [COMPANY]. All rights reserved.</p></td>\r\n        </tr>\r\n      </tbody>\r\n    </table>\r\n  </div>\r\n</div>', 'mailer', 'memUpdated');

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

--
-- Table structure for table `faq`
--

CREATE TABLE `faq` (
  `id` tinyint(3) UNSIGNED NOT NULL,
  `question` varchar(150) DEFAULT NULL,
  `answer` text DEFAULT NULL,
  `sorting` tinyint(3) UNSIGNED NOT NULL DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `gateways`
--

CREATE TABLE `gateways` (
  `id` int(4) UNSIGNED NOT NULL,
  `name` varchar(30) NOT NULL,
  `displayname` varchar(50) NOT NULL,
  `dir` varchar(30) NOT NULL,
  `live` tinyint(1) UNSIGNED NOT NULL DEFAULT 1,
  `extra_txt` varchar(120) DEFAULT NULL,
  `extra_txt2` varchar(120) DEFAULT NULL,
  `extra_txt3` varchar(120) DEFAULT NULL,
  `extra` varchar(120) NOT NULL,
  `extra2` varchar(120) DEFAULT NULL,
  `extra3` varchar(250) DEFAULT NULL,
  `is_recurring` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
  `active` tinyint(1) UNSIGNED NOT NULL DEFAULT 1
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `gateways`
--

INSERT INTO `gateways` (`id`, `name`, `displayname`, `dir`, `live`, `extra_txt`, `extra_txt2`, `extra_txt3`, `extra`, `extra2`, `extra3`, `is_recurring`, `active`) VALUES
(1, 'paypal', 'PayPal', 'paypal', 1, 'Paypal Email Address', 'Currency Code', 'Not in Use', 'webmaster@domain.com', 'CAD', '', 1, 1),
(2, 'skrill', 'Skrill', 'skrill', 1, 'Skrill Email Address', 'Currency Code', 'Secret Passphrase', 'skrill@address.com', 'EUR', 'mypassphrase', 1, 1),
(3, 'stripe', 'Stripe', 'stripe', 1, 'Stripe Secret Key', 'Currency Code', 'Publishable Key', '', 'CAD', '', 1, 1),
(4, 'payfast', 'PayFast', 'payfast', 1, 'Merchant ID', 'Merchant Key', 'PassPhrase', '', '', '', 1, 1),
(5, 'ideal', 'iDeal', 'ideal', 1, 'API Key', 'Currency Code', 'Not in Use', '', 'EUR', NULL, 0, 1),
(6, 'paystack', 'Paystack', 'paystack', 1, 'Secret Key', 'Currency Code', 'Public Key', 'sk_test_', 'ZAR', 'pk_test_', 0, 1),
(7, 'offline', 'Offline', 'offline', 1, 'Currency Code', 'Not in Use', 'Not in Use', 'CAD', '', 'Please send a check to Store Name, Store Street, Store Town, Store State / County, Store Postcode.', 0, 1),
(8, 'razorpay', 'RazorPay', 'razorpay', 1, 'Api Key', 'Currency Code', 'Secret Key', '', 'INR', '', 0, 1);

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

--
-- Table structure for table `images`
--

CREATE TABLE `images` (
  `id` int(11) UNSIGNED NOT NULL,
  `parent_id` int(11) NOT NULL DEFAULT 0,
  `name` varchar(60) DEFAULT NULL,
  `sorting` int(11) UNSIGNED NOT NULL DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `images`
--

INSERT INTO `images` (`id`, `parent_id`, `name`, `sorting`) VALUES
(1, 155391, 'IMG_Bi2Zxr6UlD7Q.jpg', 0),
(2, 232570, 'IMG_EBRWQ7tWwdwv.png', 1),
(3, 232570, 'IMG_XO0HjKwi2COl.jpg', 2),
(4, 943263, 'IMG_UQFCUSCypM8E.png', 0),
(5, 733370, 'IMG_QvssTPPxkhem.png', 0);

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

--
-- Table structure for table `invoices`
--

CREATE TABLE `invoices` (
  `id` int(11) UNSIGNED NOT NULL,
  `invoice_id` int(11) UNSIGNED NOT NULL DEFAULT 0,
  `transaction_id` varchar(32) NOT NULL DEFAULT '0',
  `items` blob DEFAULT NULL,
  `user_id` int(11) UNSIGNED NOT NULL DEFAULT 0,
  `tax` decimal(10,2) UNSIGNED NOT NULL DEFAULT 0.00,
  `coupon` decimal(10,2) UNSIGNED NOT NULL DEFAULT 0.00,
  `subtotal` decimal(10,2) UNSIGNED NOT NULL DEFAULT 0.00,
  `grand` decimal(10,2) UNSIGNED NOT NULL DEFAULT 0.00,
  `currency` varchar(6) DEFAULT NULL,
  `created` timestamp NULL DEFAULT current_timestamp()
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `memberships`
--

CREATE TABLE `memberships` (
  `id` int(11) UNSIGNED NOT NULL,
  `title` varchar(50) NOT NULL,
  `description` varchar(150) DEFAULT NULL,
  `body` text DEFAULT NULL,
  `price` decimal(12,2) UNSIGNED NOT NULL DEFAULT 0.00,
  `days` smallint(2) UNSIGNED NOT NULL DEFAULT 0,
  `period` varchar(1) NOT NULL DEFAULT 'D',
  `downloads` smallint(1) NOT NULL DEFAULT -1,
  `recurring` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
  `sorting` smallint(4) UNSIGNED NOT NULL DEFAULT 0,
  `thumb` varchar(40) DEFAULT NULL,
  `private` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
  `active` tinyint(1) UNSIGNED NOT NULL DEFAULT 1
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `memberships`
--

INSERT INTO `memberships` (`id`, `title`, `description`, `body`, `price`, `days`, `period`, `downloads`, `recurring`, `sorting`, `thumb`, `private`, `active`) VALUES
(1, 'Bronze', 'This is 30 days basic membership', NULL, 2.99, 1, 'M', -1, 1, 2, 'bronze.svg', 0, 1),
(2, 'Gold', 'This is 90 days basic membership', '', 6.99, 90, 'D', 5, 0, 3, 'gold.svg', 0, 1),
(3, 'Platinum', 'Platinum Yearly Subscription', NULL, 149.99, 1, 'Y', -1, 1, 4, 'platinum.svg', 0, 1),
(4, 'Silver', 'This is 7 days basic membership.', '<div class=\"row gutters\">\r\n   <div class=\"columns phone-100\">\r\n      <ul class=\"wojo styled check circle list positive\">\r\n         <li class=\"item\">Up to 2 people</li>\r\n         <li class=\"item\">Collect data</li>\r\n         <li class=\"item\">Code extensibility</li>\r\n      </ul>\r\n   </div>\r\n   <div class=\"columns phone-100\">\r\n      <ul class=\"wojo styled x circle list negative\">\r\n         <li class=\"item\">Custom reports</li>\r\n         <li class=\"item\">Product support</li>\r\n         <li class=\"item\">Activity reporting</li>\r\n      </ul>\r\n   </div>\r\n</div>', 1.99, 1, 'W', -1, 0, 1, 'silver.svg', 0, 1);

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

--
-- Table structure for table `membership_history`
--

CREATE TABLE `membership_history` (
  `id` int(11) UNSIGNED NOT NULL,
  `transaction_id` int(11) UNSIGNED NOT NULL DEFAULT 0,
  `user_id` int(11) UNSIGNED NOT NULL DEFAULT 0,
  `membership_id` int(11) UNSIGNED NOT NULL DEFAULT 0,
  `activated` timestamp NULL DEFAULT current_timestamp(),
  `expire` timestamp NULL DEFAULT NULL,
  `recurring` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
  `active` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '0 = expired, 1 = active'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `menus`
--

CREATE TABLE `menus` (
  `id` int(4) UNSIGNED NOT NULL,
  `page_id` int(4) UNSIGNED NOT NULL DEFAULT 0,
  `name` varchar(100) NOT NULL,
  `content_type` varchar(20) NOT NULL,
  `link` varchar(255) DEFAULT NULL,
  `target` varchar(8) DEFAULT '_blank',
  `sorting` int(4) UNSIGNED NOT NULL DEFAULT 0,
  `active` tinyint(1) UNSIGNED NOT NULL DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `menus`
--

INSERT INTO `menus` (`id`, `page_id`, `name`, `content_type`, `link`, `target`, `sorting`, `active`) VALUES
(1, 4, 'Contact Us', 'page', '', '', 5, 1),
(2, 1, 'Home', 'page', NULL, '', 1, 0),
(3, 2, 'About Us', 'page', NULL, '', 4, 1),
(4, 3, 'F.A.Q.', 'page', NULL, '', 2, 1),
(5, 0, 'Ext Link', 'web', 'https://www.google.com', '_blank', 6, 0),
(6, 5, 'Privacy Policy', 'page', NULL, '_self', 7, 1),
(7, 6, 'VIP Access', 'page', NULL, '_sefl', 8, 1),
(8, 0, 'News', 'web', '[SITEURL]/news/', '_self', 9, 1),
(9, 0, 'Blog', 'web', '[SITEURL]/blog/', '_self', 3, 1);

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

--
-- Table structure for table `news`
--

CREATE TABLE `news` (
  `id` int(6) UNSIGNED NOT NULL,
  `title` varchar(80) NOT NULL,
  `body` text NOT NULL,
  `author` varchar(55) NOT NULL,
  `created` timestamp NOT NULL DEFAULT current_timestamp(),
  `active` tinyint(1) UNSIGNED NOT NULL DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

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

CREATE TABLE `pages` (
  `id` int(6) UNSIGNED NOT NULL,
  `title` varchar(200) NOT NULL,
  `slug` varchar(200) NOT NULL,
  `body` longtext DEFAULT NULL,
  `page_type` varchar(25) NOT NULL DEFAULT 'normal',
  `address` tinytext DEFAULT NULL,
  `keywords` varchar(250) DEFAULT NULL,
  `description` varchar(250) DEFAULT NULL,
  `created` timestamp NOT NULL DEFAULT current_timestamp(),
  `active` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `pages` (`id`, `title`, `slug`, `body`, `page_type`, `address`, `keywords`, `description`, `created`, `active`) VALUES
(1, 'Welcome to our site', 'welcome-to-our-site', '<div class=\"wojo-grid\">\r\n  <div class=\"row gutters\">\r\n    <div class=\"columns phone-100\">\r\n      <div class=\"wojo icon message\">\r\n         <img src=\"[SITEURL]/uploads/images/oc-protected-card.svg\" class=\"wojo small image\">\r\n<div class=\"content\">\r\n<h5>Secure Checkout</h5>\r\nGuaranteed safe checkout\r\n        </div>\r\n      </div>\r\n    </div>\r\n    <div class=\"columns phone-100\">\r\n      <div class=\"wojo icon message\">\r\n         <img src=\"[SITEURL]/uploads/images/oc-money-profits.svg\" class=\"wojo small image\">\r\n<div class=\"content\">\r\n<h5>Payments</h5>\r\nMultiple payment options\r\n        </div>\r\n      </div>\r\n    </div>\r\n    <div class=\"columns phone-100\">\r\n      <div class=\"wojo icon message\">\r\n         <img src=\"[SITEURL]/uploads/images/oc-return.svg\" class=\"wojo small image\">\r\n<div class=\"content\">\r\n<h5>VIP Access</h5>\r\nEnjoy membership benefits\r\n        </div>\r\n      </div>\r\n    </div>\r\n  </div>\r\n</div>\r\n<div class=\"wojo card homebanner\">\r\n  <div class=\"center-align\">\r\n    <div class=\"wojo-grid\">\r\n      <p class=\"text-color-white text-weight-300\">If you have any questions, comments or concerns, please call the Sales or Advertising department\r\n        at (+000) 555-5555</p>\r\n      <a href=\"tel:+000000000\" class=\"wojo transparent button\">\r\n      <i class=\"icon smartphone\"></i> Call Now: (+000) 555-5555 </a>\r\n    </div>\r\n  </div>\r\n</div>', 'home', NULL, '', '', '2017-05-31 03:02:47', 1),
(2, 'About Us', 'about-us', '<div class=\"row gutters justify-center\">\r\n    <div class=\"columns screen-70 tablet-80 mobile-100 phone-100\">\r\n        <p class=\"text-size-large\">We cut through complexity, empowering businesses to challenge the status quo, create unlimited opportunities – and change the world.</p>\r\n    </div>\r\n</div>\r\n<div class=\"row gutters justify-center\">\r\n    <div class=\"columns screen-70 tablet-80 mobile-100 phone-100\"> <img src=\"[SITEURL]/uploads/images/about.jpg\" alt=\"\" class=\"wojo image\"> </div>\r\n</div>\r\n<div class=\"row gutters justify-center\">\r\n    <div class=\"columns screen-70 tablet-80 mobile-100 phone-100\">\r\n        <h4>Work environment</h4>\r\n        <p>Only by seeking out diverse talent around the globe and by creating an inclusive workplace can we access the breadth of skills, abilities and creativity that we need to create exceptional and innovative products and services for our customers.</p>\r\n        <p>We strongly believe that an inclusive working environment enables everyone to realise their full potential and to deliver outstanding service to our customers. We continually strive to use all the experiences that our employees bring with them to influence and shape our decision making process.</p>\r\n        <p>We are an equal opportunities employer and we aim to recruit, train and promote based on individual aptitudes and skills.</p>\r\n    </div>\r\n</div>\r\n<div class=\"row gutters justify-center\">\r\n    <div class=\"columns screen-70 tablet-80 mobile-100 phone-100\">\r\n        <h4 class=\"center-align margin-bottom\">Our leadership</h4>\r\n        <div class=\"row big-gutters\">\r\n            <div class=\"columns phone-100 center-align\"><img src=\"[SITEURL]/uploads/images/img4.jpg\" alt=\"\" class=\"wojo small-rounded image\">\r\n                <h6 class=\"margin-top\">David Forren</h6>\r\n                <p>Founder / CEO</p>\r\n            </div>\r\n            <div class=\"columns phone-100 center-align\"><img src=\"[SITEURL]/uploads/images/img5.jpg\" alt=\"\" class=\"wojo small-rounded image\">\r\n                <h6 class=\"margin-top\">Amil Evara</h6>\r\n                <p>UI/UX Designer</p>\r\n            </div>\r\n            <div class=\"columns phone-100 center-align\"><img src=\"[SITEURL]/uploads/images/img9.jpg\" alt=\"\" class=\"wojo small-rounded image\">\r\n                <h6 class=\"margin-top\">Ebele Egbuna</h6>\r\n                <p>Support Consultant</p>\r\n            </div>\r\n        </div>\r\n    </div>\r\n</div>\r\n<div class=\"row gutters justify-center\">\r\n    <div class=\"columns screen-70 tablet-80 mobile-100 phone-100\">\r\n        <div class=\"row big-gutters\">\r\n            <div class=\"columns phone-100 center-align\"><img src=\"[SITEURL]/uploads/images/img7.jpg\" alt=\"\" class=\"wojo small-rounded image\">\r\n                <h6 class=\"margin-top\">Maria Powers</h6>\r\n                <p>Director of sales</p>\r\n            </div>\r\n            <div class=\"columns phone-100 center-align\"><img src=\"[SITEURL]/uploads/images/img8.jpg\" alt=\"\" class=\"wojo small-rounded image\">\r\n                <h6 class=\"margin-top\">Delia Pawelke</h6>\r\n                <p>Front-end Developer</p>\r\n            </div>\r\n            <div class=\"columns phone-100 center-align\"><img src=\"[SITEURL]/uploads/images/img6.jpg\" alt=\"\" class=\"wojo small-rounded image\">\r\n                <h6 class=\"margin-top\">Tom Lowry</h6>\r\n                <p>UI/UX Designer</p>\r\n            </div>\r\n        </div>\r\n    </div>\r\n</div>\r\n<div class=\"row gutters justify-center\">\r\n    <div class=\"columns screen-70 tablet-80 mobile-100 phone-100 center-align\"> <img src=\"[SITEURL]/uploads/images/plane.svg\" alt=\"\" class=\"wojo medium inline image\">\r\n        <div class=\"text-size-big margin-top\">We\'re always looking for talented freelancers to work with. Get in touch if you think you’d be a good fit!</div>\r\n    </div>\r\n</div>', 'normal', NULL, '', '', '2017-05-02 03:02:50', 1),
(3, 'Frequently Asked Questions', 'faq', '<p>Here you can find most common questions regarding DDP</p>', 'faq', NULL, '', '', '2017-05-11 03:02:54', 1),
(4, 'Contact Us', 'contact-us', '<p class=\"center-aligned\">Fill up the form and hit the \"Send\". One of our representatives will get back to you as soon as possible.</p>\r\n<div class=\"row grid phone-1 mobile-2 tablet-2 screen-2 big-gutters\">\r\n  <div class=\"columns\">\r\n    <i class=\"icon primary large map marker\"></i>\r\n    <div class=\"wojo big space divider\"></div>\r\n    <h4>ADDRESS</h4>\r\n    <div class=\"wojo big space divider\"></div>\r\n    <p>123 Burke Street, Toronto ON<br>\r\n      2MK 1Y0 CANADA</p>\r\n  </div>\r\n  <div class=\"columns\">\r\n    <i class=\"icon primary large phone\"></i>\r\n    <div class=\"wojo big space divider\"></div>\r\n    <h4>PHONE</h4>\r\n    <div class=\"wojo big space divider\"></div>\r\n    <p> +(01) 05-682-0355<br>\r\n      +(01) 95-814-8535 </p>\r\n  </div>\r\n  <div class=\"columns\">\r\n    <i class=\"icon primary large envelope\"></i>\r\n    <div class=\"wojo big space divider\"></div>\r\n    <h4>EMAIL</h4>\r\n    <div class=\"wojo big space divider\"></div>\r\n    <p>info@mycompany.com<br>\r\n      info@mycompany.eu</p>\r\n  </div>\r\n  <div class=\"columns\">\r\n    <i class=\"icon primary large clock\"></i>\r\n    <div class=\"wojo big space divider\"></div>\r\n    <h4>BUSINESS HOURS</h4>\r\n    <div class=\"wojo big space divider\"></div>\r\n    <p> Mon - Fri: 09AM to 06PM<br>\r\n      Sat - Sun: 10AM to 04PM</p>\r\n  </div>\r\n</div>', 'contact', NULL, NULL, NULL, '2017-05-20 03:02:58', 1),
(5, 'Privacy Policy', 'privacy-policy', '<p>Last updated: October 20. 2017</p>\r\n<p>My Company (\"us\", \"we\", or \"our\") operates <a href=\"https://www.mysite.com\" class=\"redactor-autoparser-object\">https://www.mysite.com</a>  (the\r\n  \"Site\"). This page informs you of our policies regarding the\r\n  collection, use and disclosure of Personal Information we receive from users of\r\n  the Site.</p>\r\n<p>We use your Personal Information only for providing and\r\n  improving the Site. By using the Site, you agree to the collection and use of\r\n  information in accordance with this policy.<br><br></p>\r\n<p><strong>Information\r\n  Collection And Use</strong></p>\r\n<p>While using our Site, we may ask you to provide us with\r\n  certain personally identifiable information that can be used to contact or\r\n  identify you. Personally identifiable information may include, but is not\r\n  limited to your name (\"Personal Information\").<br><br><br></p>\r\n<p><strong>Log Data</strong></p>\r\n<p>Like many site operators, we collect information that your\r\n  browser sends whenever you visit our Site (\"Log Data\").</p>\r\n<p>This Log Data may include information such as your\r\n  computer\'s Internet Protocol (\"IP\") address, browser type, browser\r\n  version, the pages of our Site that you visit, the time and date of your visit,\r\n  the time spent on those pages and other statistics.</p>\r\n<p>In addition, we may use third party services such as Google\r\n  Analytics that collect, monitor and analyze this …<br><br><br></p>\r\n<p><strong>Communications</strong></p>\r\n<p>We may use your Personal Information to contact you with\r\n  newsletters, marketing or promotional materials and other information that ...<br><br><br></p>\r\n<p><strong>Cookies</strong></p>\r\n<p>Cookies are files with small amount of data, which may\r\n  include an anonymous unique identifier. Cookies are sent to your browser from a\r\n  web site and stored on your computer\'s hard drive.</p>\r\n<p>Like many sites, we use \"cookies\" to collect\r\n  information. You can instruct your browser to refuse all cookies or to indicate\r\n  when a cookie is being sent. However, if you do not accept cookies, you may not\r\n  be able to use some portions of our Site.<br><br><br></p>\r\n<p><strong>Security</strong></p>\r\n<p>The security of your Personal Information is important to\r\n  us, but remember that no method of transmission over the Internet, or method of\r\n  electronic storage, is 100% secure. While we strive to use commercially\r\n  acceptable means to protect your Personal Information, we cannot guarantee its\r\n  absolute security.<br><br><br></p>\r\n<p><strong>Changes To This\r\n  Privacy Policy</strong></p>\r\n<p>This Privacy Policy is effective as of (October 20. 2017) and will remain in effect except\r\n  with respect to any changes in its provisions in the future, which will be in\r\n  effect immediately after being posted on this page.</p>\r\n<p>We reserve the right to update or change our Privacy Policy\r\n  at any time and you should check this Privacy Policy periodically. Your\r\n  continued use of the Service after we post any modifications to the Privacy\r\n  Policy on this page will constitute your acknowledgment of the modifications\r\n  and your consent to abide and be bound by the modified Privacy Policy.</p>\r\n<p>If we make any material changes to this Privacy Policy, we\r\n  will notify you either through the email address you have provided us, or by\r\n  placing a prominent notice on our website.<br><br><br></p>\r\n<p><strong>Contact Us</strong></p>\r\n<p>If you have any questions about this Privacy Policy, please\r\n  <a href=\"[SITEURL]/content/contact-us\">contact us.</a></p>', 'privacy', NULL, '', '', '2017-05-29 03:03:02', 1),
(6, 'VIP Access', 'vip', '<p>Take a look at our vip access packages, and choose the one that best fits your needs...</p>', 'membership', NULL, '', '', '2017-11-13 01:24:44', 1);

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

--
-- Table structure for table `payments`
--

CREATE TABLE `payments` (
  `id` int(11) UNSIGNED NOT NULL,
  `txn_id` varchar(30) DEFAULT NULL,
  `product_id` int(11) UNSIGNED NOT NULL DEFAULT 0,
  `user_id` int(11) UNSIGNED NOT NULL DEFAULT 0,
  `membership_id` int(11) UNSIGNED NOT NULL DEFAULT 0,
  `downloads` smallint(4) UNSIGNED NOT NULL DEFAULT 0,
  `file_date` int(11) UNSIGNED NOT NULL DEFAULT 0,
  `ip` varbinary(16) DEFAULT NULL,
  `qty` tinyint(1) UNSIGNED NOT NULL DEFAULT 1,
  `amount` decimal(12,2) UNSIGNED NOT NULL DEFAULT 0.00,
  `tax` decimal(12,2) UNSIGNED NOT NULL DEFAULT 0.00,
  `coupon` decimal(12,2) UNSIGNED NOT NULL DEFAULT 0.00,
  `total` decimal(12,2) UNSIGNED NOT NULL DEFAULT 0.00,
  `currency` varchar(4) DEFAULT NULL,
  `cdkey` varchar(60) DEFAULT NULL,
  `pp` varchar(16) DEFAULT NULL,
  `memo` varchar(150) DEFAULT NULL,
  `status` tinyint(1) UNSIGNED NOT NULL DEFAULT 1,
  `created` timestamp NULL DEFAULT current_timestamp()
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `privileges`
--

CREATE TABLE `privileges` (
  `id` smallint(6) UNSIGNED NOT NULL,
  `code` varchar(20) NOT NULL,
  `name` varchar(30) NOT NULL,
  `description` varchar(60) DEFAULT NULL,
  `mode` varchar(8) NOT NULL,
  `type` varchar(40) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `privileges`
--

INSERT INTO `privileges` (`id`, `code`, `name`, `description`, `mode`, `type`) VALUES
(1, 'manage_users', 'Manage Users', 'Permission to add/edit/delete users', 'manage', 'Users'),
(2, 'manage_files', 'Manage Files', 'Permission to add/edit files', 'manage', 'Files'),
(3, 'manage_pages', 'Manage Pages', 'Permission to add/edit/delete pages', 'manage', 'Pages'),
(4, 'manage_backup', 'Manage Backups', 'Permission to create and restore backups', 'manage', 'Backup'),
(5, 'manage_language', 'Manage Language', 'Permission to translate languages', 'manage', 'Language'),
(6, 'manage_email', 'Manage Email Templates', 'Permission to manage email tempates', 'manage', 'Emails'),
(7, 'manage_countries', 'Manage Countries', 'Permission to manage countries', 'manage', 'Countries'),
(8, 'manage_coupons', 'Manage Coupons', 'Permission to add/edit/delete coupons', 'manage', 'Coupons'),
(9, 'manage_fields', 'Manage Custom Fields', 'Permission to add/edit/delete custom fields', 'manage', 'Fields'),
(10, 'manage_newsletter', 'Manage Newstellers', 'Permission to manage newsletter', 'manage', 'Newsletter'),
(11, 'manage_news', 'Manage News', 'Permission to add/edit/delete news', 'manage', 'News'),
(12, 'manage_categories', 'Manage Categories', 'Permission to add/edit and delete categories', 'manage', 'Categories'),
(13, 'manage_menus', 'Manage Menus', 'Permission to add/edit and delete menus', 'manage', 'Menus'),
(14, 'manage_products', 'Manage Products', 'Permission to add/edit and delete products', 'manage', 'Products'),
(15, 'manage_faq', 'Manage F.A.Q.', 'Permission to add/edit and delete f.a.q.', 'manage', 'Faq'),
(16, 'manage_memberships', 'Manage Memberships', 'Permission to add/edit and delete memberships', 'manage', 'Membership'),
(17, 'manage_blog', 'Manage Blog', 'Permission to add/edit/delete blog', 'manage', 'Blog');

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

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` smallint(4) UNSIGNED NOT NULL,
  `code` varchar(10) NOT NULL,
  `icon` varchar(20) DEFAULT NULL,
  `name` varchar(30) NOT NULL,
  `description` varchar(200) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` (`id`, `code`, `icon`, `name`, `description`) VALUES
(1, 'owner', 'badge', 'Site Owner', 'Site Owner is the owner of the site, has all privileges and could not be removed.'),
(2, 'staff', 'trophy', 'Staff Member', 'The &#34;Staff&#34; members  is required to assist the Owner, has different privileges and may be created by Site Owner.'),
(3, 'editor', 'note', 'Editor', 'The &#34;Editor&#34; is required to assist the Staff Members, has different privileges and may be created by Site Owner.');

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

--
-- Table structure for table `role_privileges`
--

CREATE TABLE `role_privileges` (
  `id` int(11) UNSIGNED NOT NULL,
  `rid` int(6) UNSIGNED NOT NULL DEFAULT 0,
  `pid` int(6) UNSIGNED NOT NULL DEFAULT 0,
  `active` tinyint(1) UNSIGNED NOT NULL DEFAULT 1
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `role_privileges`
--

INSERT INTO `role_privileges` (`id`, `rid`, `pid`, `active`) VALUES
(1, 1, 1, 1),
(2, 2, 1, 1),
(3, 3, 1, 0),
(4, 1, 2, 1),
(5, 2, 2, 1),
(6, 3, 2, 1),
(7, 1, 3, 1),
(8, 2, 3, 1),
(9, 3, 3, 1),
(10, 1, 4, 1),
(11, 2, 4, 1),
(12, 3, 4, 0),
(13, 1, 5, 1),
(14, 2, 5, 1),
(15, 3, 5, 1),
(16, 1, 6, 1),
(17, 2, 6, 1),
(18, 3, 6, 1),
(19, 1, 7, 1),
(20, 2, 7, 1),
(21, 3, 7, 1),
(22, 1, 8, 1),
(23, 2, 8, 1),
(24, 3, 8, 1),
(25, 1, 9, 1),
(26, 2, 9, 1),
(27, 3, 9, 1),
(28, 1, 10, 1),
(29, 2, 10, 0),
(30, 3, 10, 0),
(31, 1, 11, 1),
(32, 2, 11, 1),
(33, 3, 11, 1),
(34, 1, 12, 1),
(35, 2, 12, 1),
(36, 3, 12, 1),
(37, 1, 13, 1),
(38, 2, 13, 1),
(39, 3, 13, 1),
(40, 1, 14, 1),
(41, 2, 14, 1),
(42, 3, 14, 1),
(43, 1, 15, 1),
(44, 2, 15, 1),
(45, 3, 15, 1),
(46, 1, 16, 1),
(47, 2, 16, 1),
(48, 3, 16, 1),
(49, 1, 17, 1),
(50, 2, 17, 1),
(51, 3, 17, 1);

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

--
-- Table structure for table `trash`
--

CREATE TABLE `trash` (
  `id` int(11) UNSIGNED NOT NULL,
  `parent` varchar(15) DEFAULT NULL,
  `parent_id` int(11) UNSIGNED NOT NULL DEFAULT 0,
  `type` varchar(15) DEFAULT NULL,
  `dataset` blob DEFAULT NULL,
  `created` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `trash`
--

INSERT INTO `trash` (`id`, `parent`, `parent_id`, `type`, `dataset`, `created`) VALUES
(1, 'category', 1, 'subcategory', 0x7b226964223a352c226e616d65223a22416e7469766972757320616e64205365637572697479222c22706172656e745f6964223a312c22736c7567223a22616e746976697275732d616e642d7365637572697479222c22626f6479223a6e756c6c2c226b6579776f726473223a22222c226465736372697074696f6e223a22222c22736f7274696e67223a332c22616374697665223a317d, '2024-11-07 14:51:33'),
(2, 'category', 1, 'subcategory', 0x7b226964223a362c226e616d65223a2242757373696e657320616e64204163636f756e74696e67222c22706172656e745f6964223a312c22736c7567223a2262757373696e65732d616e642d6163636f756e74696e67222c22626f6479223a6e756c6c2c226b6579776f726473223a22222c226465736372697074696f6e223a22222c22736f7274696e67223a342c22616374697665223a317d, '2024-11-07 14:51:33'),
(3, 'category', 1, 'subcategory', 0x7b226964223a372c226e616d65223a22437573746f6d657220537570706f7274222c22706172656e745f6964223a312c22736c7567223a22637573746f6d65722d737570706f7274222c22626f6479223a6e756c6c2c226b6579776f726473223a6e756c6c2c226465736372697074696f6e223a6e756c6c2c22736f7274696e67223a352c22616374697665223a317d, '2024-11-07 14:51:33'),
(4, 'category', 2, 'subcategory', 0x7b226964223a352c226e616d65223a22566964656f222c22706172656e745f6964223a322c22736c7567223a22766964656f222c22626f6479223a6e756c6c2c226b6579776f726473223a6e756c6c2c226465736372697074696f6e223a6e756c6c2c22736f7274696e67223a302c22616374697665223a317d, '2024-11-08 12:37:43');

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

--
-- Table structure for table `wishlist`
--

CREATE TABLE `wishlist` (
  `id` int(11) UNSIGNED NOT NULL,
  `user_id` int(11) UNSIGNED NOT NULL DEFAULT 0,
  `product_id` int(11) UNSIGNED NOT NULL DEFAULT 0,
  `created` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Indexes for dumped tables
--

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

--
-- Indexes for table `blog`
--
ALTER TABLE `blog`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_catid` (`category_id`);

--
-- Indexes for table `blog_categories`
--
ALTER TABLE `blog_categories`
  ADD PRIMARY KEY (`id`),
  ADD KEY `order_num` (`sorting`),
  ADD KEY `parent_id` (`parent_id`);

--
-- Indexes for table `cart`
--
ALTER TABLE `cart`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_membership` (`membership_id`),
  ADD KEY `idx_product` (`product_id`);

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

--
-- Indexes for table `categories_related`
--
ALTER TABLE `categories_related`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_product` (`product_id`),
  ADD KEY `idx_category` (`category_id`);

--
-- Indexes for table `cdkeys`
--
ALTER TABLE `cdkeys`
  ADD PRIMARY KEY (`cdkey`),
  ADD KEY `idx_product` (`product_id`);

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

--
-- Indexes for table `countries`
--
ALTER TABLE `countries`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `abbrv` (`abbr`);

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

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

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

--
-- Indexes for table `custom_fields_data`
--
ALTER TABLE `custom_fields_data`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_user` (`user_id`),
  ADD KEY `idx_field` (`field_id`);

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

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

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

--
-- Indexes for table `images`
--
ALTER TABLE `images`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_parent_id` (`parent_id`);

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

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

--
-- Indexes for table `membership_history`
--
ALTER TABLE `membership_history`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_transaction` (`transaction_id`),
  ADD KEY `idx_user` (`user_id`),
  ADD KEY `idx_membership` (`membership_id`);

--
-- Indexes for table `menus`
--
ALTER TABLE `menus`
  ADD PRIMARY KEY (`id`),
  ADD KEY `content_id` (`active`);

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

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

--
-- Indexes for table `payments`
--
ALTER TABLE `payments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_prouct` (`product_id`),
  ADD KEY `idx_user` (`user_id`),
  ADD KEY `idx_membership` (`membership_id`);

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

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

--
-- Indexes for table `role_privileges`
--
ALTER TABLE `role_privileges`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx` (`rid`,`pid`);

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

--
-- Indexes for table `wishlist`
--
ALTER TABLE `wishlist`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_user` (`user_id`),
  ADD KEY `idx_product` (`product_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `activity`
--
ALTER TABLE `activity`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=46;

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

--
-- AUTO_INCREMENT for table `blog_categories`
--
ALTER TABLE `blog_categories`
  MODIFY `id` int(6) UNSIGNED NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `categories`
--
ALTER TABLE `categories`
  MODIFY `id` int(6) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `categories_related`
--
ALTER TABLE `categories_related`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=124;

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

--
-- AUTO_INCREMENT for table `countries`
--
ALTER TABLE `countries`
  MODIFY `id` smallint(6) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=238;

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

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

--
-- AUTO_INCREMENT for table `custom_fields`
--
ALTER TABLE `custom_fields`
  MODIFY `id` int(6) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `custom_fields_data`
--
ALTER TABLE `custom_fields_data`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;

--
-- AUTO_INCREMENT for table `email_templates`
--
ALTER TABLE `email_templates`
  MODIFY `id` int(5) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT for table `faq`
--
ALTER TABLE `faq`
  MODIFY `id` tinyint(3) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `gateways`
--
ALTER TABLE `gateways`
  MODIFY `id` int(4) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

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

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

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

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

--
-- AUTO_INCREMENT for table `menus`
--
ALTER TABLE `menus`
  MODIFY `id` int(4) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `news`
--
ALTER TABLE `news`
  MODIFY `id` int(6) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `pages`
--
ALTER TABLE `pages`
  MODIFY `id` int(6) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

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

--
-- AUTO_INCREMENT for table `privileges`
--
ALTER TABLE `privileges`
  MODIFY `id` smallint(6) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

--
-- AUTO_INCREMENT for table `roles`
--
ALTER TABLE `roles`
  MODIFY `id` smallint(4) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `role_privileges`
--
ALTER TABLE `role_privileges`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=52;

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

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

