-- ================================================================
--
-- @version $Id: structure.sql 2017-010-01 12:12:05 gewa $
-- @package Digital Downloads Pro
-- @copyright 2017. wojoscripts.com
--
-- ================================================================
-- Database Content
-- ================================================================
--
-- Table structure for table `activity`
--

DROP TABLE IF EXISTS `activity`;
CREATE TABLE IF NOT EXISTS `activity` (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`id`),
  KEY `idx_user` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

DROP TABLE IF EXISTS `cart`;
CREATE TABLE IF NOT EXISTS `cart` (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `user_id` varchar(48) 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,
  PRIMARY KEY (`id`),
  KEY `idx_membership` (`membership_id`),
  KEY `idx_product` (`product_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

DROP TABLE IF EXISTS `categories`;
CREATE TABLE IF NOT EXISTS `categories` (
  `id` int(6) UNSIGNED NOT NULL AUTO_INCREMENT,
  `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',
  PRIMARY KEY (`id`),
  KEY `idx_parent` (`parent_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

INSERT INTO `categories` VALUES(1, 'Software', 0, 'software', 'Looking for licensed software for your computer or network? ', '', '', 2, 1);
INSERT INTO `categories` VALUES(2, 'E-Books', 0, 'ebooks', NULL, NULL, NULL, 6, 1);
INSERT INTO `categories` VALUES(3, 'Music and Video', 0, 'music-and-video', NULL, NULL, NULL, 7, 1);
INSERT INTO `categories` VALUES(4, 'Office and Productivity', 0, 'office-and-productivity', NULL, NULL, NULL, 8, 1);
INSERT INTO `categories` VALUES(5, 'Antivirus and Security', 1, 'antivirus-and-security', NULL, '', '', 3, 1);
INSERT INTO `categories` VALUES(6, 'Bussines and Accounting', 1, 'bussines-and-accounting', NULL, '', '', 4, 1);
INSERT INTO `categories` VALUES(7, 'Customer Support', 1, 'customer-support', NULL, NULL, NULL, 5, 1);
INSERT INTO `categories` VALUES(8, 'PC Games', 0, 'pc-games', '', '', '', 1, 1);
INSERT INTO `categories` VALUES(9, 'VIP Access', 0, 'vip-access', '', '', '', 9, 1);

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

DROP TABLE IF EXISTS `categories_related`;
CREATE TABLE IF NOT EXISTS `categories_related` (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `product_id` int(11) UNSIGNED NOT NULL DEFAULT '0',
  `category_id` int(11) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `idx_product` (`product_id`),
  KEY `idx_category` (`category_id`)
) ENGINE=MyISAM AUTO_INCREMENT=81 DEFAULT CHARSET=utf8;

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

INSERT INTO `categories_related` VALUES(38, 1, 4);
INSERT INTO `categories_related` VALUES(37, 1, 1);
INSERT INTO `categories_related` VALUES(40, 2, 1);
INSERT INTO `categories_related` VALUES(46, 3, 5);
INSERT INTO `categories_related` VALUES(45, 3, 1);
INSERT INTO `categories_related` VALUES(47, 4, 1);
INSERT INTO `categories_related` VALUES(48, 4, 6);
INSERT INTO `categories_related` VALUES(49, 5, 1);
INSERT INTO `categories_related` VALUES(50, 6, 1);
INSERT INTO `categories_related` VALUES(51, 7, 1);
INSERT INTO `categories_related` VALUES(52, 7, 3);
INSERT INTO `categories_related` VALUES(80, 8, 5);
INSERT INTO `categories_related` VALUES(79, 8, 1);
INSERT INTO `categories_related` VALUES(55, 9, 1);
INSERT INTO `categories_related` VALUES(56, 9, 4);
INSERT INTO `categories_related` VALUES(57, 10, 1);
INSERT INTO `categories_related` VALUES(58, 10, 3);
INSERT INTO `categories_related` VALUES(74, 11, 8);
INSERT INTO `categories_related` VALUES(71, 12, 8);
INSERT INTO `categories_related` VALUES(76, 13, 8);
INSERT INTO `categories_related` VALUES(67, 14, 2);
INSERT INTO `categories_related` VALUES(66, 15, 2);
INSERT INTO `categories_related` VALUES(65, 16, 2);
INSERT INTO `categories_related` VALUES(68, 17, 9);

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

DROP TABLE IF EXISTS `cdkeys`;
CREATE TABLE IF NOT EXISTS `cdkeys` (
  `product_id` int(11) UNSIGNED NOT NULL DEFAULT '0',
  `cdkey` varchar(60) NOT NULL DEFAULT '0',
  PRIMARY KEY (`cdkey`),
  KEY `idx_product` (`product_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

DROP TABLE IF EXISTS `comments`;
CREATE TABLE IF NOT EXISTS `comments` (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) UNSIGNED NOT NULL DEFAULT '0',
  `product_id` int(11) UNSIGNED NOT NULL DEFAULT '0',
  `username` varchar(24) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `user_id` int(11) UNSIGNED NOT NULL DEFAULT '0',
  `email` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `body` text CHARACTER SET utf8 COLLATE utf8_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',
  PRIMARY KEY (`id`),
  KEY `parent` (`parent_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

DROP TABLE IF EXISTS `countries`;
CREATE TABLE IF NOT EXISTS `countries` (
  `id` smallint(6) UNSIGNED NOT NULL AUTO_INCREMENT,
  `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',
  PRIMARY KEY (`id`),
  UNIQUE KEY `abbrv` (`abbr`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

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

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

DROP TABLE IF EXISTS `coupons`;
CREATE TABLE IF NOT EXISTS `coupons` (
  `id` int(1) UNSIGNED NOT NULL AUTO_INCREMENT,
  `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',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

DROP TABLE IF EXISTS `cronjobs`;
CREATE TABLE `cronjobs` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`id`),
  KEY `idx_user_id` (`user_id`),
  KEY `idx_membership_id` (`membership_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

DROP TABLE IF EXISTS `custom_fields`;
CREATE TABLE IF NOT EXISTS `custom_fields` (
  `id` int(6) UNSIGNED NOT NULL AUTO_INCREMENT,
  `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',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

DROP TABLE IF EXISTS `custom_fields_data`;
CREATE TABLE IF NOT EXISTS `custom_fields_data` (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`id`),
  KEY `idx_user` (`user_id`),
  KEY `idx_field` (`field_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

DROP TABLE IF EXISTS `email_templates`;
CREATE TABLE IF NOT EXISTS `email_templates` (
  `id` int(5) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `subject` varchar(150) NOT NULL,
  `help` tinytext,
  `body` text NOT NULL,
  `type` enum('news','mailer') DEFAULT 'mailer',
  `typeid` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
-- Dumping data for table `email_templates`
--

INSERT INTO `email_templates` VALUES(1, 'Registration Email', 'Please verify your email', 'This template is used to send Registration Verification Email, when Configuration->Registration Verification is set to YES', '<div style="background-color:#F2F2F2;margin:0 auto;padding:60px;font-family: Helvetica, Arial, sans-serif; font-size: 16px; color: #404040"> [LOGO]\r\n  <div style="border-radius: 6px 6px 6px 6px;box-shadow: 0 1px 2px 0 #DFDFDF;">\r\n    <div style="background-color:#35B8E8;text-align:center;margin-top:32px;border-radius: 6px 6px 0 0;"><img src="[SITEURL]/assets/images/header.png" alt="header"></div>\r\n    <div style="background-color:#ffffff;padding:48px;text-align:center;border-radius: 0 0 6px 6px;">\r\n      <h1 style="font-weight:100;margin-bottom:32px">You have been registered!</h1>\r\n      <p style="margin:0;padding:3px;color:#7B7B7B"> Hey [NAME], You''re now a member of [COMPANY].</p>\r\n      <p style="margin:0;padding:3px;color:#7B7B7B">To activate your account, please visit the link below.</p>\r\n      <p style="margin:0;padding:5px;color:#7B7B7B"> Here are your login credentials. Please keep them in a safe place.</p>\r\n      <p style="margin:0;padding:3px;color:#7B7B7B"><strong>Username</strong>: [USERNAME] or [EMAIL]</p>\r\n      <p style="margin:0;padding:3px;color:#7B7B7B"><strong>Password</strong>: [PASSWORD]</p>\r\n      <div style="padding:30px 0px 0px 0px">\r\n        <a target="_blank" href="[LINK]" style="text-decoration: none;border-radius: 6px 6px 6px 6px;display:inline-block;background-color:#4CAF50;padding:14px 30px 14px 30px;color:#ffffff;font-weight:500;font-size:18px">Activate your account </a>\r\n      </div>\r\n    </div>\r\n  </div>\r\n  <div style="padding:48px;text-align:center">\r\n    <p style="margin-bottom:32px;font-size:20px;color:##272822"><em>Stay in touch</em></p>\r\n    <a target="_blank" href="http://facebook.com/[FB]" style="display:inline-block;margin: 0px 5px 0px 5px;"><img src="[SITEURL]/assets/images/twitter.png" alt=""></a>\r\n    <a target="_blank" href="http://facebook.com/[TW]" style="display:inline-block;margin: 0px 5px 0px 5px;"><img src="[SITEURL]/assets/images/facebook.png" alt=""></a>\r\n    <a href="mailto:[CEMAIL]" style="display:inline-block;margin: 0px 5px 0px 5px;"><img src="[SITEURL]/assets/images/email.png" alt=""></a>\r\n    <div style="font-size:12px;color:#6E6E6E;margin-top:24px">\r\n      <p style="margin:0;padding:4px"> This email is sent to you directly from [COMPANY]</p>\r\n      <p style="margin:0"> The information above is gathered from the user input. ©[DATE] <a href="[SITEURL]">[COMPANY]</a>\r\n        . All rights reserved.</p>\r\n    </div>\r\n  </div>\r\n</div>', 'mailer', 'regMail');
INSERT INTO `email_templates` VALUES(2, 'Welcome Mail From Admin', 'You have been registered', 'This template is used to send welcome email, when user is added by administrator', '<div style="background-color:#F2F2F2;margin:0 auto;padding:60px;font-family: Helvetica, Arial, sans-serif; font-size: 16px; color: #404040"> [LOGO]\r\n  <div style="border-radius: 6px 6px 6px 6px;box-shadow: 0 1px 2px 0 #DFDFDF;">\r\n    <div style="background-color:#35B8E8;text-align:center;margin-top:32px;border-radius: 6px 6px 0 0;"><img src="[SITEURL]/assets/images/header.png" alt="header"></div>\r\n    <div style="background-color:#ffffff;padding:48px;text-align:center;border-radius: 0 0 6px 6px;">\r\n      <h1 style="font-weight:100;margin-bottom:32px">You have been registered!</h1>\r\n      <p style="margin:0;padding:3px;color:#7B7B7B"> Hey [NAME], You''re now a member of [COMPANY].</p>\r\n      <p style="margin:0;padding:5px;color:#7B7B7B"> Here are your login credentials. Please keep them in a safe place.</p>\r\n      <p style="margin:0;padding:3px;color:#7B7B7B"><strong>Username</strong>: [USERNAME] or [EMAIL]</p>\r\n      <p style="margin:0;padding:3px;color:#7B7B7B"><strong>Password</strong>: [PASSWORD]</p>\r\n      <div style="padding:30px 0px 0px 0px">\r\n        <a target="_blank" href="[LINK]" style="text-decoration: none;border-radius: 6px 6px 6px 6px;display:inline-block;background-color:#4CAF50;padding:14px 30px 14px 30px;color:#ffffff;font-weight:500;font-size:18px">Go to login page</a>\r\n      </div>\r\n    </div>\r\n  </div>\r\n  <div style="padding:48px;text-align:center">\r\n    <p style="margin-bottom:32px;font-size:20px;color:##272822"><em>Stay in touch</em></p>\r\n    <a target="_blank" href="http://facebook.com/[FB]" style="display:inline-block;margin: 0px 5px 0px 5px;"><img src="[SITEURL]/assets/images/twitter.png" alt=""></a>\r\n    <a target="_blank" href="http://facebook.com/[TW]" style="display:inline-block;margin: 0px 5px 0px 5px;"><img src="[SITEURL]/assets/images/facebook.png" alt=""></a>\r\n    <a href="mailto:[CEMAIL]" style="display:inline-block;margin: 0px 5px 0px 5px;"><img src="[SITEURL]/assets/images/email.png" alt=""></a>\r\n    <div style="font-size:12px;color:#6E6E6E;margin-top:24px">\r\n      <p style="margin:0;padding:4px"> This email is sent to you directly from [COMPANY]</p>\r\n      <p style="margin:0"> The information above is gathered from the user input. ©[DATE] <a href="[SITEURL]">[COMPANY]</a>\r\n        . All rights reserved.</p>\r\n    </div>\r\n  </div>\r\n</div>', 'mailer', 'regMailAdmin');
INSERT INTO `email_templates` VALUES(3, 'Default Newsletter', 'Newsletter', 'This is a default newsletter template', '<div style="background-color:#F2F2F2;margin:0 auto;padding:60px;font-family: Helvetica, Arial, sans-serif; font-size: 16px; color: #404040"> [LOGO]\r\n  <div style="border-radius: 6px 6px 6px 6px;box-shadow: 0 1px 2px 0 #DFDFDF;">\r\n    <div style="background-color:#35B8E8;text-align:center;margin-top:32px;border-radius: 6px 6px 0 0;"><img src="[SITEURL]/assets/images/header.png" alt="header"></div>\r\n    <div style="background-color:#ffffff;padding:48px;text-align:center;border-radius: 0 0 6px 6px;">\r\n      <h1 style="font-weight:100;margin-bottom:32px">[COMPANY] Newsletter!</h1>\r\n      <p style="margin:0;padding:5px;color:#7B7B7B"> Hello [NAME].</p>\r\n      <p style="margin:0;padding:3px;color:#7B7B7B">[ATTACHMENT]</p>\r\n      <div style="padding:30px 0px 0px 0px">\r\n         Newsletter content goes here...\r\n      </div>\r\n    </div>\r\n  </div>\r\n  <div style="padding:48px;text-align:center">\r\n    <p style="margin-bottom:32px;font-size:20px;color:##272822"><em>Stay in touch</em></p>\r\n    <a target="_blank" href="http://facebook.com/[FB]" style="display:inline-block;margin: 0px 5px 0px 5px;"><img src="[SITEURL]/assets/images/twitter.png" alt=""></a>\r\n    <a target="_blank" href="http://facebook.com/[TW]" style="display:inline-block;margin: 0px 5px 0px 5px;"><img src="[SITEURL]/assets/images/facebook.png" alt=""></a>\r\n    <a href="mailto:[CEMAIL]" style="display:inline-block;margin: 0px 5px 0px 5px;"><img src="[SITEURL]/assets/images/email.png" alt=""></a>\r\n    <div style="font-size:12px;color:#6E6E6E;margin-top:24px">\r\n      <p style="margin:0;padding:4px"> This email is sent to you directly from [COMPANY]</p>\r\n      <p style="margin:0"> The information above is gathered from the user input. ©[DATE] <a href="[SITEURL]">[COMPANY]</a>\r\n        . All rights reserved.</p>\r\n    </div>\r\n  </div>\r\n</div>', 'mailer', 'newsletter');
INSERT INTO `email_templates` VALUES(4, 'Single Email', 'Single User Email', 'This template is used to email single user', '<div style="background-color:#F2F2F2;margin:0 auto;padding:60px;font-family: Helvetica, Arial, sans-serif; font-size: 16px; color: #404040"> [LOGO]\r\n  <div style="border-radius: 6px 6px 6px 6px;box-shadow: 0 1px 2px 0 #DFDFDF;">\r\n    <div style="background-color:#35B8E8;text-align:center;margin-top:32px;border-radius: 6px 6px 0 0;"><img src="[SITEURL]/assets/images/header.png" alt="header"></div>\r\n    <div style="background-color:#ffffff;padding:48px;text-align:center;border-radius: 0 0 6px 6px;">\r\n      <h1 style="font-weight:100;margin-bottom:32px">Hello [NAME]</h1>\r\n      <p style="margin:0;padding:3px;color:#7B7B7B">[ATTACHMENT]</p>\r\n      <div style="padding:30px 0px 0px 0px">\r\n         Message content goes here...\r\n      </div>\r\n    </div>\r\n  </div>\r\n  <div style="padding:48px;text-align:center">\r\n    <p style="margin-bottom:32px;font-size:20px;color:##272822"><em>Stay in touch</em></p>\r\n    <a target="_blank" href="http://facebook.com/[FB]" style="display:inline-block;margin: 0px 5px 0px 5px;"><img src="[SITEURL]/assets/images/twitter.png" alt=""></a>\r\n    <a target="_blank" href="http://facebook.com/[TW]" style="display:inline-block;margin: 0px 5px 0px 5px;"><img src="[SITEURL]/assets/images/facebook.png" alt=""></a>\r\n    <a href="mailto:[CEMAIL]" style="display:inline-block;margin: 0px 5px 0px 5px;"><img src="[SITEURL]/assets/images/email.png" alt=""></a>\r\n    <div style="font-size:12px;color:#6E6E6E;margin-top:24px">\r\n      <p style="margin:0;padding:4px"> This email is sent to you directly from [COMPANY]</p>\r\n      <p style="margin:0"> The information above is gathered from the user input. ©[DATE] <a href="[SITEURL]">[COMPANY]</a>\r\n        . All rights reserved.</p>\r\n    </div>\r\n  </div>\r\n</div>', 'mailer', 'singleMail');
INSERT INTO `email_templates` VALUES(5, 'Forgot Password Admin', 'Password Reset', 'This template is used for retrieving lost admin password', '<div style="background-color:#F2F2F2;margin:0 auto;padding:60px;font-family: Helvetica, Arial, sans-serif; font-size: 16px; color: #404040"> [LOGO]\r\n  <div style="border-radius: 6px 6px 6px 6px;box-shadow: 0 1px 2px 0 #DFDFDF;">\r\n    <div style="background-color:#35B8E8;text-align:center;margin-top:32px;border-radius: 6px 6px 0 0;"><img src="[SITEURL]/assets/images/header.png" alt="header"></div>\r\n    <div style="background-color:#ffffff;padding:48px;text-align:center;border-radius: 0 0 6px 6px;">\r\n      <h1 style="font-weight:100;margin-bottom:32px">New Password Request!</h1>\r\n      <p style="margin:0;padding:3px;color:#7B7B7B"> Hey [NAME], it seems that you or someone requested a new password for you.</p>\r\n      <p style="margin:0;padding:5px;color:#7B7B7B"> We have generated a new password, as requested.</p>\r\n      <p style="margin:0;padding:3px;color:#7B7B7B"><strong>New Password</strong>: [PASSWORD]</p>\r\n      <div style="padding:30px 0px 0px 0px">\r\n        <a target="_blank" href="[LINK]" style="text-decoration: none;border-radius: 6px 6px 6px 6px;display:inline-block;background-color:#4CAF50;padding:14px 30px 14px 30px;color:#ffffff;font-weight:500;font-size:18px">Go to login </a>\r\n      </div>\r\n    </div>\r\n  </div>\r\n  <div style="padding:48px;text-align:center">\r\n    <p style="margin-bottom:32px;font-size:20px;color:##272822"><em>Stay in touch</em></p>\r\n    <a target="_blank" href="http://facebook.com/[FB]" style="display:inline-block;margin: 0px 5px 0px 5px;"><img src="[SITEURL]/assets/images/twitter.png" alt=""></a>\r\n    <a target="_blank" href="http://facebook.com/[TW]" style="display:inline-block;margin: 0px 5px 0px 5px;"><img src="[SITEURL]/assets/images/facebook.png" alt=""></a>\r\n    <a href="mailto:[CEMAIL]" style="display:inline-block;margin: 0px 5px 0px 5px;"><img src="[SITEURL]/assets/images/email.png" alt=""></a>\r\n    <div style="font-size:12px;color:#6E6E6E;margin-top:24px">\r\n      <p style="margin:0;padding:4px"> This email is sent to you directly from [COMPANY]</p>\r\n      <p style="margin:0"> The information above is gathered from the user input. ©[DATE] <a href="[SITEURL]">[COMPANY]</a>\r\n        . All rights reserved.</p>\r\n    </div>\r\n  </div>\r\n</div>', 'mailer', 'adminPassReset');
INSERT INTO `email_templates` VALUES(6, 'Forgot Password User', 'Password Reset', 'This template is used for retrieving lost user password', '<div style="background-color:#F2F2F2;margin:0 auto;padding:60px;font-family: Helvetica, Arial, sans-serif; font-size: 16px; color: #404040"> [LOGO]\r\n  <div style="border-radius: 6px 6px 6px 6px;box-shadow: 0 1px 2px 0 #DFDFDF;">\r\n    <div style="background-color:#35B8E8;text-align:center;margin-top:32px;border-radius: 6px 6px 0 0;"><img src="[SITEURL]/assets/images/header.png" alt="header"></div>\r\n    <div style="background-color:#ffffff;padding:48px;text-align:center;border-radius: 0 0 6px 6px;">\r\n      <h1 style="font-weight:100;margin-bottom:32px">New Password Request!</h1>\r\n      <p style="margin:0;padding:3px;color:#7B7B7B"> Hey [NAME], it seems that you or someone requested a new password for you.</p>\r\n      <p style="margin:0;padding:5px;color:#7B7B7B"> We have generated a new password, as requested.</p>\r\n      <p style="margin:0;padding:3px;color:#7B7B7B"><strong>New Password</strong>: [PASSWORD]</p>\r\n      <div style="padding:30px 0px 0px 0px">\r\n        <a target="_blank" href="[LINK]" style="text-decoration: none;border-radius: 6px 6px 6px 6px;display:inline-block;background-color:#4CAF50;padding:14px 30px 14px 30px;color:#ffffff;font-weight:500;font-size:18px">Go to login </a>\r\n      </div>\r\n    </div>\r\n  </div>\r\n  <div style="padding:48px;text-align:center">\r\n    <p style="margin-bottom:32px;font-size:20px;color:##272822"><em>Stay in touch</em></p>\r\n    <a target="_blank" href="http://facebook.com/[FB]" style="display:inline-block;margin: 0px 5px 0px 5px;"><img src="[SITEURL]/assets/images/twitter.png" alt=""></a>\r\n    <a target="_blank" href="http://facebook.com/[TW]" style="display:inline-block;margin: 0px 5px 0px 5px;"><img src="[SITEURL]/assets/images/facebook.png" alt=""></a>\r\n    <a href="mailto:[CEMAIL]" style="display:inline-block;margin: 0px 5px 0px 5px;"><img src="[SITEURL]/assets/images/email.png" alt=""></a>\r\n    <div style="font-size:12px;color:#6E6E6E;margin-top:24px">\r\n      <p style="margin:0;padding:4px"> This email is sent to you directly from [COMPANY]</p>\r\n      <p style="margin:0"> The information above is gathered from the user input. ©[DATE] <a href="[SITEURL]">[COMPANY]</a>\r\n        . All rights reserved.</p>\r\n    </div>\r\n  </div>\r\n</div>', 'mailer', 'userPassReset');
INSERT INTO `email_templates` VALUES(7, 'Welcome Email', 'Welcome', 'This template is used to welcome newly registered user when Configuration->Registration Verification and Configuration->Auto Registration are both set to YES', '<div style="background-color:#F2F2F2;margin:0 auto;padding:60px;font-family: Helvetica, Arial, sans-serif; font-size: 16px; color: #404040"> [LOGO]\r\n  <div style="border-radius: 6px 6px 6px 6px;box-shadow: 0 1px 2px 0 #DFDFDF;">\r\n    <div style="background-color:#35B8E8;text-align:center;margin-top:32px;border-radius: 6px 6px 0 0;"><img src="[SITEURL]/assets/images/header.png" alt="header"></div>\r\n    <div style="background-color:#ffffff;padding:48px;text-align:center;border-radius: 0 0 6px 6px;">\r\n      <h1 style="font-weight:100;margin-bottom:32px">You have been registered!</h1>\r\n      <p style="margin:0;padding:3px;color:#7B7B7B"> Hey [NAME], You''re now a member of [COMPANY].</p>\r\n      <p style="margin:0;padding:5px;color:#7B7B7B"> Here are your login credentials. Please keep them in a safe place.</p>\r\n      <p style="margin:0;padding:3px;color:#7B7B7B"><strong>Username</strong>: [USERNAME] or [EMAIL]</p>\r\n      <p style="margin:0;padding:3px;color:#7B7B7B"><strong>Password</strong>: [PASSWORD]</p>\r\n      <div style="padding:30px 0px 0px 0px">\r\n        <a target="_blank" href="[LINK]" style="text-decoration: none;border-radius: 6px 6px 6px 6px;display:inline-block;background-color:#4CAF50;padding:14px 30px 14px 30px;color:#ffffff;font-weight:500;font-size:18px">Go to login page </a>\r\n      </div>\r\n    </div>\r\n  </div>\r\n  <div style="padding:48px;text-align:center">\r\n    <p style="margin-bottom:32px;font-size:20px;color:##272822"><em>Stay in touch</em></p>\r\n    <a target="_blank" href="http://facebook.com/[FB]" style="display:inline-block;margin: 0px 5px 0px 5px;"><img src="[SITEURL]/assets/images/twitter.png" alt=""></a>\r\n    <a target="_blank" href="http://facebook.com/[TW]" style="display:inline-block;margin: 0px 5px 0px 5px;"><img src="[SITEURL]/assets/images/facebook.png" alt=""></a>\r\n    <a href="mailto:[CEMAIL]" style="display:inline-block;margin: 0px 5px 0px 5px;"><img src="[SITEURL]/assets/images/email.png" alt=""></a>\r\n    <div style="font-size:12px;color:#6E6E6E;margin-top:24px">\r\n      <p style="margin:0;padding:4px"> This email is sent to you directly from [COMPANY]</p>\r\n      <p style="margin:0"> The information above is gathered from the user input. ©[DATE] <a href="[SITEURL]">[COMPANY]</a>\r\n        . All rights reserved.</p>\r\n    </div>\r\n  </div>\r\n</div>', 'mailer', 'welcomeEmail');
INSERT INTO `email_templates` VALUES(8, 'Registration Pending', 'Registration Verification Pending', 'This template is used to send Registration Verification Email, when Configuration->Auto Registration is set to NO', '<div style="background-color:#F2F2F2;margin:0 auto;padding:60px;font-family: Helvetica, Arial, sans-serif; font-size: 16px; color: #404040"> [LOGO]\r\n  <div style="border-radius: 6px 6px 6px 6px;box-shadow: 0 1px 2px 0 #DFDFDF;">\r\n    <div style="background-color:#35B8E8;text-align:center;margin-top:32px;border-radius: 6px 6px 0 0;"><img src="[SITEURL]/assets/images/header.png" alt="header"></div>\r\n    <div style="background-color:#ffffff;padding:48px;text-align:center;border-radius: 0 0 6px 6px;">\r\n      <h1 style="font-weight:100;margin-bottom:32px">You have been registered!</h1>\r\n      <p style="margin:0;padding:3px;color:#7B7B7B"> Hey [NAME], You''re now a member of [COMPANY].</p>\r\n      <p style="margin:0;padding:3px;color:#7B7B7B">Your account is currently pending verification process, and you will be notified once your account is acivated.</p>\r\n      <p style="margin:0;padding:5px;color:#7B7B7B"> Here are your login credentials. Please keep them in a safe place.</p>\r\n      <p style="margin:0;padding:3px;color:#7B7B7B"><strong>Username</strong>: [USERNAME] or [EMAIL]</p>\r\n      <p style="margin:0;padding:3px;color:#7B7B7B"><strong>Password</strong>: [PASSWORD]</p>\r\n    </div>\r\n  </div>\r\n  <div style="padding:48px;text-align:center">\r\n    <p style="margin-bottom:32px;font-size:20px;color:##272822"><em>Stay in touch</em></p>\r\n    <a target="_blank" href="http://facebook.com/[FB]" style="display:inline-block;margin: 0px 5px 0px 5px;"><img src="[SITEURL]/assets/images/twitter.png" alt=""></a>\r\n    <a target="_blank" href="http://facebook.com/[TW]" style="display:inline-block;margin: 0px 5px 0px 5px;"><img src="[SITEURL]/assets/images/facebook.png" alt=""></a>\r\n    <a href="mailto:[CEMAIL]" style="display:inline-block;margin: 0px 5px 0px 5px;"><img src="[SITEURL]/assets/images/email.png" alt=""></a>\r\n    <div style="font-size:12px;color:#6E6E6E;margin-top:24px">\r\n      <p style="margin:0;padding:4px"> This email is sent to you directly from [COMPANY]</p>\r\n      <p style="margin:0"> The information above is gathered from the user input. ©[DATE] <a href="[SITEURL]">[COMPANY]</a>\r\n        . All rights reserved.</p>\r\n    </div>\r\n  </div>\r\n</div>', 'mailer', 'regMailPending');
INSERT INTO `email_templates` VALUES(9, 'Notify Admin', 'New User Registration', 'This template is used to notify admin of new registration when Configuration->Registration Notification is set to YES', '<div style="background-color:#F2F2F2;margin:0 auto;padding:60px;font-family: Helvetica, Arial, sans-serif; font-size: 16px; color: #404040"> [LOGO]\r\n  <div style="border-radius: 6px 6px 6px 6px;box-shadow: 0 1px 2px 0 #DFDFDF;">\r\n    <div style="background-color:#35B8E8;text-align:center;margin-top:32px;border-radius: 6px 6px 0 0;"><img src="[SITEURL]/assets/images/header.png" alt="header"></div>\r\n    <div style="background-color:#ffffff;padding:48px;text-align:center;border-radius: 0 0 6px 6px;">\r\n      <h1 style="font-weight:100;margin-bottom:32px">Hello Admin!</h1>\r\n      <p style="margin:0;padding:3px;color:#7B7B7B"> You have a new user registration.</p>\r\n      <p style="margin:0;padding:5px;color:#7B7B7B"> You can login into your admin panel to view details.</p>\r\n      <p style="margin:0;padding:3px;color:#7B7B7B"><strong>Email</strong>: [EMAIL]</p>\r\n      <p style="margin:0;padding:3px;color:#7B7B7B"><strong>Name</strong>: [NAME]</p>\r\n      <p style="margin:0;padding:3px;color:#7B7B7B"><strong>IP</strong>: [IP]</p>\r\n    </div>\r\n  </div>\r\n  <div style="padding:48px;text-align:center">\r\n    <p style="margin-bottom:32px;font-size:20px;color:##272822"><em>Stay in touch</em></p>\r\n    <a target="_blank" href="http://facebook.com/[FB]" style="display:inline-block;margin: 0px 5px 0px 5px;"><img src="[SITEURL]/assets/images/twitter.png" alt=""></a>\r\n    <a target="_blank" href="http://facebook.com/[TW]" style="display:inline-block;margin: 0px 5px 0px 5px;"><img src="[SITEURL]/assets/images/facebook.png" alt=""></a>\r\n    <a href="mailto:[CEMAIL]" style="display:inline-block;margin: 0px 5px 0px 5px;"><img src="[SITEURL]/assets/images/email.png" alt=""></a>\r\n    <div style="font-size:12px;color:#6E6E6E;margin-top:24px">\r\n      <p style="margin:0;padding:4px"> This email is sent to you directly from [COMPANY]</p>\r\n      <p style="margin:0"> The information above is gathered from the user input. ©[DATE] <a href="[SITEURL]">[COMPANY]</a>\r\n        . All rights reserved.</p>\r\n    </div>\r\n  </div>\r\n</div>', 'mailer', 'notifyAdmin');
INSERT INTO `email_templates` VALUES(10, 'Contact Request', 'Contact Inquiry', 'This template is used to send default Contact Request Form', '<div style="background-color:#F2F2F2;margin:0 auto;padding:60px;font-family: Helvetica, Arial, sans-serif; font-size: 16px; color: #404040"> [LOGO]\r\n  <div style="border-radius: 6px 6px 6px 6px;box-shadow: 0 1px 2px 0 #DFDFDF;">\r\n    <div style="background-color:#35B8E8;text-align:center;margin-top:32px;border-radius: 6px 6px 0 0;"><img src="[SITEURL]/assets/images/header.png" alt="header"></div>\r\n    <div style="background-color:#ffffff;padding:48px;text-align:center;border-radius: 0 0 6px 6px;">\r\n      <h1 style="font-weight:100;margin-bottom:32px">Hello Admin!</h1>\r\n      <p style="margin:0;padding:5px;color:#7B7B7B"> You have a new contact request.</p>\r\n      <p style="margin:0;padding:3px;color:#7B7B7B"><strong>From</strong>: [NAME]</p>\r\n      <p style="margin:0;padding:3px;color:#7B7B7B"><strong>IP</strong>: [IP]</p>\r\n      <div style="padding:30px 0px 0px 0px">\r\n         [MESSAGE]\r\n      </div>\r\n    </div>\r\n  </div>\r\n  <div style="padding:48px;text-align:center">\r\n    <p style="margin-bottom:32px;font-size:20px;color:##272822"><em>Stay in touch</em></p>\r\n    <a target="_blank" href="http://facebook.com/[FB]" style="display:inline-block;margin: 0px 5px 0px 5px;"><img src="[SITEURL]/assets/images/twitter.png" alt=""></a>\r\n    <a target="_blank" href="http://facebook.com/[TW]" style="display:inline-block;margin: 0px 5px 0px 5px;"><img src="[SITEURL]/assets/images/facebook.png" alt=""></a>\r\n    <a href="mailto:[CEMAIL]" style="display:inline-block;margin: 0px 5px 0px 5px;"><img src="[SITEURL]/assets/images/email.png" alt=""></a>\r\n    <div style="font-size:12px;color:#6E6E6E;margin-top:24px">\r\n      <p style="margin:0;padding:4px"> This email is sent to you directly from [COMPANY]</p>\r\n      <p style="margin:0"> The information above is gathered from the user input. ©[DATE] <a href="[SITEURL]">[COMPANY]</a>\r\n        . All rights reserved.</p>\r\n    </div>\r\n  </div>\r\n</div>', 'mailer', 'contact');
INSERT INTO `email_templates` VALUES(11, 'Transaction Completed Admin', 'Payment Completed', 'This template is used to notify administrator on successful payment transaction', '<div style="background-color:#F2F2F2;margin:0 auto;padding:60px;font-family: Helvetica, Arial, sans-serif; font-size: 16px; color: #404040"> [LOGO]\r\n  <div style="border-radius: 6px 6px 6px 6px;box-shadow: 0 1px 2px 0 #DFDFDF;">\r\n    <div style="background-color:#35B8E8;text-align:center;margin-top:32px;border-radius: 6px 6px 0 0;"><img src="[SITEURL]/assets/images/header.png" alt="header"></div>\r\n    <div style="background-color:#ffffff;padding:48px;text-align:center;border-radius: 0 0 6px 6px;">\r\n      <h1 style="font-weight:100;margin-bottom:32px">Hello Admin!</h1>\r\n      <p style="margin:0;padding:3px;color:#7B7B7B"> You have received new payment.</p>\r\n      <p style="margin:0;padding:5px;color:#7B7B7B"> Here are the details:</p>\r\n      <p style="margin:0;padding:3px;color:#7B7B7B"><strong>[TYPE]</strong>: [ITEMNAME]</p>\r\n      <p style="margin:0;padding:3px;color:#7B7B7B"><strong>Price</strong>: [PRICE]</p>\r\n      <p style="margin:0;padding:3px;color:#7B7B7B"><strong>Status</strong>: [STATUS]</p>\r\n      <p style="margin:0;padding:3px;color:#7B7B7B"><strong>Processor</strong>: [PP]</p>\r\n      <p style="margin:0;padding:3px;color:#7B7B7B"><strong>IP</strong>: [IP]</p>\r\n    </div>\r\n  </div>\r\n  <div style="padding:48px;text-align:center">\r\n    <p style="margin-bottom:32px;font-size:20px;color:##272822"><em>Stay in touch</em></p>\r\n    <a target="_blank" href="http://facebook.com/[FB]" style="display:inline-block;margin: 0px 5px 0px 5px;"><img src="[SITEURL]/assets/images/twitter.png" alt=""></a>\r\n    <a target="_blank" href="http://facebook.com/[TW]" style="display:inline-block;margin: 0px 5px 0px 5px;"><img src="[SITEURL]/assets/images/facebook.png" alt=""></a>\r\n    <a href="mailto:[CEMAIL]" style="display:inline-block;margin: 0px 5px 0px 5px;"><img src="[SITEURL]/assets/images/email.png" alt=""></a>\r\n    <div style="font-size:12px;color:#6E6E6E;margin-top:24px">\r\n      <p style="margin:0;padding:4px"> This email is sent to you directly from [COMPANY]</p>\r\n      <p style="margin:0"> The information above is gathered from the user input. ©[DATE] <a href="[SITEURL]">[COMPANY]</a>\r\n        . All rights reserved.</p>\r\n    </div>\r\n  </div>\r\n</div>', 'mailer', 'payComplete');
INSERT INTO `email_templates` VALUES(12, 'Transaction Completed User', 'Payment Completed', 'This template is used to notify user on successful payment transaction', '<div style="background-color:#F2F2F2;margin:0 auto;padding:60px;font-family: Helvetica, Arial, sans-serif; font-size: 16px; color: #404040"> [LOGO]\r\n  <div style="border-radius: 6px 6px 6px 6px;box-shadow: 0 1px 2px 0 #DFDFDF;">\r\n    <div style="background-color:#35B8E8;text-align:center;margin-top:32px;border-radius: 6px 6px 0 0;"><img src="[SITEURL]/assets/images/header.png" alt="header"></div>\r\n    <div style="background-color:#ffffff;padding:48px;text-align:center;border-radius: 0 0 6px 6px;">\r\n      <h1 style="font-weight:100;margin-bottom:32px">Hello [NAME]!</h1>\r\n      <p style="margin:0;padding:3px;color:#7B7B7B"> Your payment has been completed successfuly.</p>\r\n      <p style="margin:0;padding:5px;color:#7B7B7B"> Here are the details:</p>\r\n      <p style="margin:0;padding:3px;color:#7B7B7B"><strong>Membership</strong>: [ITEMNAME]</p>\r\n      <p style="margin:0;padding:3px;color:#7B7B7B"><strong>Vat/Tax</strong>: [TAX]</p>\r\n      <p style="margin:0;padding:3px;color:#7B7B7B"><strong>Price</strong>: [PRICE]</p>\r\n      <p style="margin:0;padding:3px;color:#7B7B7B"><strong>Processor</strong>: [PP]</p>\r\n    </div>\r\n  </div>\r\n  <div style="padding:48px;text-align:center">\r\n    <p style="margin-bottom:32px;font-size:20px;color:##272822"><em>Stay in touch</em></p>\r\n    <a target="_blank" href="http://facebook.com/[FB]" style="display:inline-block;margin: 0px 5px 0px 5px;"><img src="[SITEURL]/assets/images/twitter.png" alt=""></a>\r\n    <a target="_blank" href="http://facebook.com/[TW]" style="display:inline-block;margin: 0px 5px 0px 5px;"><img src="[SITEURL]/assets/images/facebook.png" alt=""></a>\r\n    <a href="mailto:[CEMAIL]" style="display:inline-block;margin: 0px 5px 0px 5px;"><img src="[SITEURL]/assets/images/email.png" alt=""></a>\r\n    <div style="font-size:12px;color:#6E6E6E;margin-top:24px">\r\n      <p style="margin:0;padding:4px"> This email is sent to you directly from [COMPANY]</p>\r\n      <p style="margin:0"> The information above is gathered from the user input. ©[DATE] <a href="[SITEURL]">[COMPANY]</a>\r\n        . All rights reserved.</p>\r\n    </div>\r\n  </div>\r\n</div>', 'mailer', 'payCompleteUser');
INSERT INTO `email_templates` VALUES(13, 'Membership Expired', 'Membership Has Expired', 'This template is used to notify user when membership is about to expire a day before. ', '<div style="background-color:#F2F2F2;margin:0 auto;padding:60px;font-family: Helvetica, Arial, sans-serif; font-size: 16px; color: #404040"> [LOGO]\r\n  <div style="border-radius: 6px 6px 6px 6px;box-shadow: 0 1px 2px 0 #DFDFDF;">\r\n    <div style="background-color:#35B8E8;text-align:center;margin-top:32px;border-radius: 6px 6px 0 0;"><img src="[SITEURL]/assets/images/header.png" alt="header"></div>\r\n    <div style="background-color:#ffffff;padding:48px;text-align:center;border-radius: 0 0 6px 6px;">\r\n      <h1 style="font-weight:100;margin-bottom:32px">Hello [NAME]!</h1>\r\n      <p style="margin:0;padding:3px;color:#7B7B7B"> Your membership access will soon expiere .</p>\r\n      <p style="margin:0;padding:5px;color:#7B7B7B"> Here are the details:</p>\r\n      <p style="margin:0;padding:3px;color:#7B7B7B"><strong>Membership</strong>: [ITEMNAME]</p>\r\n      <p style="margin:0;padding:3px;color:#7B7B7B"><strong>Expiry Date</strong>: [EXPIRE]</p>\r\n    </div>\r\n  </div>\r\n  <div style="padding:48px;text-align:center">\r\n    <p style="margin-bottom:32px;font-size:20px;color:##272822"><em>Stay in touch</em></p>\r\n    <a target="_blank" href="http://facebook.com/[FB]" style="display:inline-block;margin: 0px 5px 0px 5px;"><img src="[SITEURL]/assets/images/twitter.png" alt=""></a>\r\n    <a target="_blank" href="http://facebook.com/[TW]" style="display:inline-block;margin: 0px 5px 0px 5px;"><img src="[SITEURL]/assets/images/facebook.png" alt=""></a>\r\n    <a href="mailto:[CEMAIL]" style="display:inline-block;margin: 0px 5px 0px 5px;"><img src="[SITEURL]/assets/images/email.png" alt=""></a>\r\n    <div style="font-size:12px;color:#6E6E6E;margin-top:24px">\r\n      <p style="margin:0;padding:4px"> This email is sent to you directly from [COMPANY]</p>\r\n      <p style="margin:0"> The information above is gathered from the user input. ©[DATE] <a href="[SITEURL]">[COMPANY]</a>\r\n        . All rights reserved.</p>\r\n    </div>\r\n  </div>\r\n</div>', 'mailer', 'memExpired');
INSERT INTO `email_templates` VALUES(14, 'New Comment', 'New Comment Added', 'This template is used to notify admin when comment has been submitted.', '<div style="background-color:#F2F2F2;margin:0 auto;padding:60px;font-family: Helvetica, Arial, sans-serif; font-size: 16px; color: #404040"> [LOGO]\n  <div style="border-radius: 6px 6px 6px 6px;box-shadow: 0 1px 2px 0 #DFDFDF;">\n    <div style="background-color:#35B8E8;text-align:center;margin-top:32px;border-radius: 6px 6px 0 0;"><img src="[SITEURL]/assets/images/header.png" alt="header"></div>\n    <div style="background-color:#ffffff;padding:48px;text-align:center;border-radius: 0 0 6px 6px;">\n      <h1 style="font-weight:100;margin-bottom:32px">Hello Admin!</h1>\n      <p style="margin:0;padding:3px;color:#7B7B7B"> You have a new comment post.</p>\n      <p style="margin:0;padding:5px;color:#7B7B7B"> If comments are not auto approved, you will need to manually approve them from admin panel.</p>\n      <p style="margin:0;padding:3px;color:#7B7B7B"><strong>From</strong>: [NAME]</p>\n      <p style="margin:0;padding:3px;color:#7B7B7B"><strong>Page</strong>: [PAGEURL]</p>\n      <p style="margin:0;padding:3px;color:#7B7B7B"><strong>IP</strong>: [IP]</p>\n      <div style="padding:30px 0px 0px 0px">\n        [MESSAGE]\n      </div>\n    </div>\n  </div>\n  <div style="padding:48px;text-align:center">\n    <p style="margin-bottom:32px;font-size:20px;color:##272822"><em>Stay in touch</em></p>\n    <a target="_blank" href="http://facebook.com/[FB]" style="display:inline-block;margin: 0px 5px 0px 5px;"><img src="[SITEURL]/assets/images/twitter.png" alt=""></a>\n    <a target="_blank" href="http://facebook.com/[TW]" style="display:inline-block;margin: 0px 5px 0px 5px;"><img src="[SITEURL]/assets/images/facebook.png" alt=""></a>\n    <a href="mailto:[CEMAIL]" style="display:inline-block;margin: 0px 5px 0px 5px;"><img src="[SITEURL]/assets/images/email.png" alt=""></a>\n    <div style="font-size:12px;color:#6E6E6E;margin-top:24px">\n      <p style="margin:0;padding:4px"> This email is sent to you directly from [COMPANY]</p>\n      <p style="margin:0"> The information above is gathered from the user input. ©[DATE] <a href="[SITEURL]">[COMPANY]</a>\n        . All rights reserved.</p>\n    </div>\n  </div>\n</div>', 'mailer', 'newComment');

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

DROP TABLE IF EXISTS `faq`;
CREATE TABLE IF NOT EXISTS `faq` (
  `id` tinyint(3) UNSIGNED NOT NULL AUTO_INCREMENT,
  `question` varchar(150) DEFAULT NULL,
  `answer` text,
  `sorting` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Table structure for table `files`
--

DROP TABLE IF EXISTS `files`;
CREATE TABLE IF NOT EXISTS `files` (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(80) NOT NULL,
  `alias` varchar(80) DEFAULT NULL,
  `filesize` int(11) UNSIGNED NOT NULL DEFAULT '0',
  `extension` varchar(4) DEFAULT NULL,
  `type` varchar(20) DEFAULT NULL,
  `token` varchar(32) DEFAULT NULL,
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `active` tinyint(1) UNSIGNED NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

DROP TABLE IF EXISTS `gateways`;
CREATE TABLE IF NOT EXISTS `gateways` (
  `id` int(4) UNSIGNED NOT NULL AUTO_INCREMENT,
  `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(120) DEFAULT NULL,
  `is_recurring` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
  `active` tinyint(1) UNSIGNED NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

INSERT INTO `gateways` VALUES(1, 'paypal', 'PayPal', 'paypal', 1, 'Paypal Email Address', 'Currency Code', 'Not in Use', 'webmaster@domain.com', 'CAD', '', 1, 1);
INSERT INTO `gateways` VALUES(2, 'skrill', 'Skrill', 'skrill', 1, 'Skrill Email Address', 'Currency Code', 'Secret Passphrase', 'moneybookers@address.com', 'EUR', 'mypassphrase', 1, 1);
INSERT INTO `gateways` VALUES(3, 'stripe', 'Stripe', 'stripe', 1, 'Stripe Secret Key', 'Currency Code', '', 'sk_test_6sDE6weiugEuHbrjZKyG5MlQ', 'CAD', 'pk_test_vRoskAcmL59P2r7H9hziwrg', 1, 1);
INSERT INTO `gateways` VALUES(4, 'payfast', 'PayFast', 'payfast', 1, 'Merchant ID', 'Merchant Key', 'PassPhrase', '', '', '', 1, 1);
INSERT INTO `gateways` VALUES(6, 'ideal', 'iDeal', 'ideal', 1, 'API Key', 'Currency Code', 'Not in Use', 'test_uFQUaDAjAygbtypMN95DJdsVkDDKrJ', 'EUR', NULL, 0, 1);
INSERT INTO `gateways` VALUES(7, 'anet', 'Authorize.net', 'anet', 1, 'API Login Id', 'MD5 Hash Key', 'Transaction Key', '9KDgrm2mw46V', 'Simon', '5wek3X3DX5e39YAQ', 0, 1);
INSERT INTO `gateways` VALUES(9, '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);

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

DROP TABLE IF EXISTS `images`;
CREATE TABLE IF NOT EXISTS `images` (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) NOT NULL DEFAULT '0',
  `name` varchar(60) DEFAULT NULL,
  `sorting` int(11) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `idx_parent_id` (`parent_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

DROP TABLE IF EXISTS `invoices`;
CREATE TABLE IF NOT EXISTS `invoices` (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `invoice_id` int(11) UNSIGNED NOT NULL DEFAULT '0',
  `transaction_id` varchar(32) NOT NULL DEFAULT '0',
  `items` blob,
  `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,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

DROP TABLE IF EXISTS `memberships`;
CREATE TABLE IF NOT EXISTS `memberships` (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(50) NOT NULL,
  `description` text,
  `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',
  `recurring` tinyint(1) 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',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

INSERT INTO `memberships` VALUES(1, 'Bronze', 'This is 30 days basic membership', '2.99', 1, 'M', 1, 'bronze.svg', 0, 1);
INSERT INTO `memberships` VALUES(2, 'Gold', 'This is 90 days basic membership', '6.99', 90, 'D', 0, 'gold.svg', 0, 1);
INSERT INTO `memberships` VALUES(3, 'Platinum', 'Platinum Yearly Subscription', '149.99', 1, 'Y', 1, 'platinum.svg', 0, 1);
INSERT INTO `memberships` VALUES(4, 'Silver', 'This is 7 days basic membership.', '1.99', 1, 'W', 0, 'silver.svg', 0, 1);

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

DROP TABLE IF EXISTS `membership_history`;
CREATE TABLE IF NOT EXISTS `membership_history` (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `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',
  PRIMARY KEY (`id`),
  KEY `idx_transaction` (`transaction_id`),
  KEY `idx_user` (`user_id`),
  KEY `idx_membership` (`membership_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

DROP TABLE IF EXISTS `menus`;
CREATE TABLE IF NOT EXISTS `menus` (
  `id` int(4) UNSIGNED NOT NULL AUTO_INCREMENT,
  `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',
  PRIMARY KEY (`id`),
  KEY `content_id` (`active`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

INSERT INTO `menus` VALUES(1, 4, 'Contact Us', 'page', '', '', 4, 1);
INSERT INTO `menus` VALUES(2, 1, 'Home', 'page', NULL, '', 1, 0);
INSERT INTO `menus` VALUES(3, 2, 'About Us', 'page', NULL, '', 3, 1);
INSERT INTO `menus` VALUES(4, 3, 'F.A.Q.', 'page', NULL, '', 2, 1);
INSERT INTO `menus` VALUES(5, 2, 'Ext Link', 'web', 'http://www.google.com', '_blank', 5, 0);
INSERT INTO `menus` VALUES(6, 5, 'Privacy Policy', 'page', NULL, '_self', 6, 1);
INSERT INTO `menus` VALUES(7, 6, 'VIP Access', 'page', NULL, '_sefl', 7, 1);
INSERT INTO `menus` VALUES(8, 0, 'News', 'web', '[SITEURL]/news/', '_self', 8, 1);

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

DROP TABLE IF EXISTS `news`;
CREATE TABLE IF NOT EXISTS `news` (
  `id` int(6) UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(80) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `body` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `author` varchar(55) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `active` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

DROP TABLE IF EXISTS `pages`;
CREATE TABLE IF NOT EXISTS `pages` (
  `id` int(6) UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(200) NOT NULL,
  `slug` varchar(200) NOT NULL,
  `body` longtext,
  `page_type` enum('membership','faq','contact','home','normal') DEFAULT 'normal',
  `address` tinytext,
  `keywords` varchar(250) DEFAULT NULL,
  `description` varchar(250) DEFAULT NULL,
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `active` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

INSERT INTO `pages` 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 screen-25 mobile-50 phone-100">\r\n      <div class="wojo card content-center">\r\n        <div class="content">\r\n          <i class="icon big circular primary inverted download"></i>\r\n          <div class="wojo big space divider"></div>\r\n          <h3> Free Downloads </h3>\r\n          <div class="wojo space divider"></div>\r\n          <p class="wojo small soft dimmed text">Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed eiusmod tempor incididunt labore et dolore magna aliqua.</p>\r\n        </div>\r\n      </div>\r\n    </div>\r\n    <div class="columns screen-25 mobile-50 phone-100">\r\n      <div class="wojo card content-center">\r\n        <div class="content">\r\n          <i class="icon big circular secondary inverted credit card"></i>\r\n          <div class="wojo big space divider"></div>\r\n          <h3> Easy Payment</h3>\r\n          <div class="wojo space divider"></div>\r\n          <p class="wojo small soft dimmed text">Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed eiusmod tempor incididunt labore et dolore magna aliqua.</p>\r\n        </div>\r\n      </div>\r\n    </div>\r\n    <div class="columns screen-25 mobile-50 phone-100">\r\n      <div class="wojo card content-center">\r\n        <div class="content">\r\n          <i class="icon big circular positive inverted users"></i>\r\n          <div class="wojo big space divider"></div>\r\n          <h3> VIP Access</h3>\r\n          <div class="wojo space divider"></div>\r\n          <p class="wojo small soft dimmed text">Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed eiusmod tempor incididunt labore et dolore magna aliqua.</p>\r\n        </div>\r\n      </div>\r\n    </div>\r\n    <div class="columns screen-25 mobile-50 phone-100">\r\n      <div class="wojo card content-center">\r\n        <div class="content">\r\n          <i class="icon big circular negative inverted files"></i>\r\n          <div class="wojo big space divider"></div>\r\n          <h3> Over 5000 Choices </h3>\r\n          <div class="wojo space divider"></div>\r\n          <p class="wojo small soft dimmed text">Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed eiusmod tempor incididunt labore et dolore magna aliqua.</p>\r\n        </div>\r\n      </div>\r\n    </div>\r\n  </div>\r\n</div>\r\n<div class="wojo attached card">\r\n  <div class="secondary header content-center">\r\n    <div class="wojo-grid">\r\n      <div class="padding">\r\n        <p class="wojo white big thin text">If you have any questions, comments or concerns, please call the Sales or Advertising department\r\n          at (+000) 555-5555</p>\r\n        <div class="wojo space divider"></div>\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>\r\n</div>', 'home', NULL, NULL, NULL, '2017-05-31 01:02:47', 1);
INSERT INTO `pages` VALUES(2, 'About Us', 'about-us', '<div class="row gutters align-middle">\r\n  <div class="columns screen-70 tablet-60 mobile-100 phone-100">\r\n    <h3>Digital Downloads Pro</h3>\r\n    <p>Sed ut perspiciatis unde omnis iste natus error sit voluptatem accusantium doloremque laudantium, totam rem aperiam, eaque ipsa quae ab illo inventore veritatis et quasi architecto beatae vitae dicta sunt explicabo. Nemo enim ipsam voluptatem quia voluptas sit aspernatur aut odit aut fugit, sed quia consequuntur magni dolores eos qui ratione voluptatem sequi nesciunt.</p>\r\n  </div>\r\n  <div class="columns screen-30 tablet-40 mobile-100 phone-100">\r\n    <img alt="" src="[SITEURL]/uploads/images/coming-soon-bg.jpg" class="wojo boxed shadow image">\r\n  </div>\r\n</div>\r\n<div class="row gutters align-middle">\r\n  <div class="columns screen-40 tablet-50 mobile-100 phone-100">\r\n    <div class="flex-video vimeo wojo shadow">\r\n      <iframe src="https://player.vimeo.com/video/169599296?color=949494&title=0&byline=0&portrait=0" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>\r\n    </div>\r\n  </div>\r\n  <div class="columns screen-60 tablet-50 mobile-100 phone-100">\r\n    <h3>Our Mission</h3>\r\n    <p>Sed ut perspiciatis unde omnis iste natus error sit voluptatem accusantium doloremque laudantium, totam rem aperiam, eaque ipsa quae ab illo inventore veritatis et quasi architecto beatae vitae dicta sunt explicabo.</p>\r\n    <div class="wojo space divider"></div>\r\n    <div class="wojo list">\r\n      <div class="item"><i class="icon umbrella"></i> Lorem Ipsum simply typesetting industry.</div>\r\n      <div class="item"><i class="icon car"></i> Cras aliquet venenatis sapien fringilla.</div>\r\n      <div class="item"><i class="icon user"></i> Another list item with animated icon.</div>\r\n      <div class="item"><i class="icon heart"></i> Duis luctus erat vel pharetra aliquet.</div>\r\n      <div class="item"><i class="icon bag"></i> Estnon commodo luctus lacinia odio elit.</div>\r\n      <div class="item"><i class="icon bell"></i> Quisque tristique ipsum accumsan convallis.</div>\r\n      <div class="item"><i class="icon check"></i> Ovel dolorem fugiat nulla pariatur.</div>\r\n    </div>\r\n  </div>\r\n</div>\r\n<div class="wojo huge space divider"></div>\r\n<h3 class="content-center">Meet Our Team</h3>\r\n<div class="wojo huge space divider"></div>\r\n<div class="row phone-block-1 mobile-block-2 tablet-block-4 screen-block-4 gutters">\r\n  <div class="column content-center">\r\n    <div class="wojo photo attached card">\r\n      <img alt="" src="[SITEURL]/uploads/images/team_01.jpg">\r\n      <div class="vertical-margin">\r\n        <h4>Alex Delfonso</h4>\r\n        <p class="wojo dimmed text">Co-Founder, CEO</p>\r\n      </div>\r\n      <p class="wojo small text margin-bottom">Lorem Ipsum is simply dummy text of the printing and typesetting industry.</p>\r\n      <div class="content-center">\r\n        <a class="inverted"><i class="small facebook circular icon link"></i></a>\r\n        <a class="inverted"><i class="small twitter circular icon"></i></a>\r\n        <a class="inverted"><i class="small instagram circular icon"></i></a>\r\n        <a class="inverted"><i class="small google plus circular icon"></i></a>\r\n      </div>\r\n    </div>\r\n  </div>\r\n  <div class="column content-center">\r\n    <div class="wojo photo attached card">\r\n      <img alt="" src="[SITEURL]/uploads/images/team_02.jpg">\r\n      <div class="vertical-margin">\r\n        <h4> Tim Morrison </h4>\r\n        <p class="wojo dimmed text">Marketing Director</p>\r\n      </div>\r\n      <p class="wojo small text margin-bottom">Lorem Ipsum is simply dummy text of the printing and typesetting industry.</p>\r\n      <div class="content-center">\r\n        <a class="inverted"><i class="small facebook circular icon link"></i></a>\r\n        <a class="inverted"><i class="small twitter circular icon"></i></a>\r\n        <a class="inverted"><i class="small instagram circular icon"></i></a>\r\n        <a class="inverted"><i class="small google plus circular icon"></i></a>\r\n      </div>\r\n    </div>\r\n  </div>\r\n  <div class="column content-center">\r\n    <div class="wojo photo attached card">\r\n      <img alt="" src="[SITEURL]/uploads/images/team_03.jpg">\r\n      <div class="vertical-margin">\r\n        <h4>Jane Falcone</h4>\r\n        <p class="wojo dimmed text">Sales Director</p>\r\n      </div>\r\n      <p class="wojo small text margin-bottom">Lorem Ipsum is simply dummy text of the printing and typesetting industry.</p>\r\n      <div class="content-center">\r\n        <a class="inverted"><i class="small facebook circular icon link"></i></a>\r\n        <a class="inverted"><i class="small twitter circular icon"></i></a>\r\n        <a class="inverted"><i class="small instagram circular icon"></i></a>\r\n        <a class="inverted"><i class="small google plus circular icon"></i></a>\r\n      </div>\r\n    </div>\r\n  </div>\r\n  <div class="column content-center">\r\n    <div class="wojo photo attached card">\r\n      <img alt="" src="[SITEURL]/uploads/images/team_04.jpg">\r\n      <div class="vertical-margin">\r\n        <h4>John Peterson</h4>\r\n        <p class="wojo dimmed text">Brand Director</p>\r\n      </div>\r\n      <p class="wojo small text margin-bottom">Lorem Ipsum is simply dummy text of the printing and typesetting industry.</p>\r\n      <div class="content-center">\r\n        <a class="inverted"><i class="small facebook circular icon link"></i></a>\r\n        <a class="inverted"><i class="small twitter circular icon"></i></a>\r\n        <a class="inverted"><i class="small instagram circular icon"></i></a>\r\n        <a class="inverted"><i class="small google plus circular icon"></i></a>\r\n      </div>\r\n    </div>\r\n  </div>\r\n</div>', 'normal', NULL, NULL, NULL, '2017-05-02 01:02:50', 1);
INSERT INTO `pages` VALUES(3, 'Frequently Asked Questions', 'faq', 'Here you can find most common questions regarding DDP', 'faq', NULL, NULL, NULL, '2017-05-11 01:02:54', 1);
INSERT INTO `pages` VALUES(4, 'Contact Us', 'contact-us', '<p class="content-center">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="wojo big space divider"></div>\r\n<div class="row phone-block-1 mobile-block-2 tablet-block-2 screen-block-2 double-gutters content-center">\r\n  <div class="column">\r\n    <i class="icon secondary 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="column">\r\n    <i class="icon secondary 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="column">\r\n    <i class="icon secondary large email"></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="column">\r\n    <i class="icon secondary 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', '1 Adelaide St W, Toronto, ON M5H 1L6, Canada', NULL, NULL, '2017-05-20 01:02:58', 1);
INSERT INTO `pages` VALUES(5, 'Privacy Policy', 'privacy-policy', '<p>Last updated: October 20. 2017</p>\n<p>My Company ("us", "we", or "our") operates http://www.mysite.com  (the\n  "Site"). This page informs you of our policies regarding the\n  collection, use and disclosure of Personal Information we receive from users of\n  the Site.</p>\n<p>We use your Personal Information only for providing and\n  improving the Site. By using the Site, you agree to the collection and use of\n  information in accordance with this policy.<br><br></p>\n<p><b>Information\n  Collection And Use</b></p>\n<p>While using our Site, we may ask you to provide us with\n  certain personally identifiable information that can be used to contact or\n  identify you. Personally identifiable information may include, but is not\n  limited to your name ("Personal Information").<br><br><br></p>\n<p><b>Log Data</b></p>\n<p>Like many site operators, we collect information that your\n  browser sends whenever you visit our Site ("Log Data").</p>\n<p>This Log Data may include information such as your\n  computer''s Internet Protocol ("IP") address, browser type, browser\n  version, the pages of our Site that you visit, the time and date of your visit,\n  the time spent on those pages and other statistics.</p>\n<p>In addition, we may use third party services such as Google\n  Analytics that collect, monitor and analyze this …<br><br><br></p>\n<p><b>Communications</b></p>\n<p>We may use your Personal Information to contact you with\n  newsletters, marketing or promotional materials and other information that ...<br><br><br></p>\n<p><b>Cookies</b></p>\n<p>Cookies are files with small amount of data, which may\n  include an anonymous unique identifier. Cookies are sent to your browser from a\n  web site and stored on your computer''s hard drive.</p>\n<p>Like many sites, we use "cookies" to collect\n  information. You can instruct your browser to refuse all cookies or to indicate\n  when a cookie is being sent. However, if you do not accept cookies, you may not\n  be able to use some portions of our Site.<br><br><br></p>\n<p><b>Security</b></p>\n<p>The security of your Personal Information is important to\n  us, but remember that no method of transmission over the Internet, or method of\n  electronic storage, is 100% secure. While we strive to use commercially\n  acceptable means to protect your Personal Information, we cannot guarantee its\n  absolute security.<br><br><br></p>\n<p><b>Changes To This\n  Privacy Policy</b></p>\n<p>This Privacy Policy is effective as of (October 20. 2017) and will remain in effect except\n  with respect to any changes in its provisions in the future, which will be in\n  effect immediately after being posted on this page.</p>\n<p>We reserve the right to update or change our Privacy Policy\n  at any time and you should check this Privacy Policy periodically. Your\n  continued use of the Service after we post any modifications to the Privacy\n  Policy on this page will constitute your acknowledgment of the modifications\n  and your consent to abide and be bound by the modified Privacy Policy.</p>\n<p>If we make any material changes to this Privacy Policy, we\n  will notify you either through the email address you have provided us, or by\n  placing a prominent notice on our website.<br><br><br></p>\n<p><b>Contact Us</b></p>\n<p>If you have any questions about this Privacy Policy, please\n  <a href="[SITEURL]/page/contact-us">contact us.</a></p>\n', 'normal', NULL, '', '', '2017-05-29 01:03:02', 1);
INSERT INTO `pages` VALUES(6, 'VIP Access', 'vip', 'Take a look at our vip access packages, and choose the one that best fits your needs...', 'membership', NULL, '', '', '2017-11-12 21:24:44', 1);

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

DROP TABLE IF EXISTS `payments`;
CREATE TABLE IF NOT EXISTS `payments` (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`id`),
  KEY `idx_prouct` (`product_id`),
  KEY `idx_user` (`user_id`),
  KEY `idx_membership` (`membership_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

DROP TABLE IF EXISTS `privileges`;
CREATE TABLE IF NOT EXISTS `privileges` (
  `id` smallint(6) UNSIGNED NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

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


--
-- Table structure for table `products`
--

DROP TABLE IF EXISTS `products`;
CREATE TABLE IF NOT EXISTS `products` (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `category_id` int(11) UNSIGNED NOT NULL DEFAULT '0',
  `title` varchar(150) NOT NULL,
  `slug` varchar(150) NOT NULL,
  `price` decimal(12,2) UNSIGNED NOT NULL DEFAULT '0.00',
  `sprice` decimal(12,2) UNSIGNED NOT NULL DEFAULT '0.00',
  `is_sale` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
  `categories` varchar(60) NOT NULL DEFAULT '0',
  `membership_id` varchar(20) NOT NULL DEFAULT '0',
  `files` varchar(60) NOT NULL DEFAULT '0',
  `body` text,
  `pbody` text,
  `thumb` varchar(50) DEFAULT NULL,
  `tags` varchar(150) DEFAULT NULL,
  `audio` varchar(50) DEFAULT NULL,
  `images` blob,
  `youtube` varchar(200) DEFAULT NULL,
  `affiliate` varchar(150) DEFAULT NULL,
  `type` varchar(10) NOT NULL DEFAULT 'normal',
  `expiry` varchar(6) NOT NULL DEFAULT '0',
  `hits` mediumint(6) NOT NULL DEFAULT '0',
  `likes` int(11) UNSIGNED NOT NULL DEFAULT '0',
  `ratings` int(6) UNSIGNED NOT NULL DEFAULT '0',
  `token` varchar(32) NOT NULL DEFAULT '0',
  `keywords` text,
  `description` text,
  `active` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `idx_category` (`category_id`),
  KEY `idx_file` (`files`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

DROP TABLE IF EXISTS `roles`;
CREATE TABLE IF NOT EXISTS `roles` (
  `id` smallint(4) UNSIGNED NOT NULL AUTO_INCREMENT,
  `code` varchar(10) NOT NULL,
  `icon` varchar(20) DEFAULT NULL,
  `name` varchar(30) NOT NULL,
  `description` varchar(200) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

INSERT INTO `roles` VALUES(1, 'owner', 'badge', 'Site Owner', 'Site Owner is the owner of the site, has all privileges and could not be removed.');
INSERT INTO `roles` VALUES(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.');
INSERT INTO `roles` VALUES(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`
--

DROP TABLE IF EXISTS `role_privileges`;
CREATE TABLE IF NOT EXISTS `role_privileges` (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `rid` int(6) UNSIGNED NOT NULL DEFAULT '0',
  `pid` int(6) UNSIGNED NOT NULL DEFAULT '0',
  `active` tinyint(1) UNSIGNED NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `idx` (`rid`,`pid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

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

--
-- Table structure for table `settings`
--

DROP TABLE IF EXISTS `settings`;
CREATE TABLE IF NOT EXISTS `settings` (
  `id` tinyint(1) UNSIGNED NOT NULL AUTO_INCREMENT,
  `site_name` varchar(100) NOT NULL,
  `company` varchar(100) NOT NULL,
  `site_dir` varchar(50) DEFAULT NULL,
  `site_email` varchar(50) NOT NULL,
  `color` varchar(16) DEFAULT NULL,
  `theme` varchar(32) NOT NULL,
  `perpage` tinyint(2) UNSIGNED NOT NULL,
  `featured` tinyint(1) UNSIGNED NOT NULL DEFAULT '16',
  `cperpage` tinyint(1) UNSIGNED NOT NULL DEFAULT '16',
  `home_layout` tinyint(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT '0 = grid, 1 = list',
  `backup` varchar(64) NOT NULL,
  `thumb_w` smallint(3) UNSIGNED NOT NULL,
  `thumb_h` smallint(3) UNSIGNED NOT NULL,
  `avatar_w` smallint(2) UNSIGNED NOT NULL,
  `avatar_h` smallint(2) UNSIGNED NOT NULL,
  `short_date` varchar(20) NOT NULL,
  `long_date` varchar(30) NOT NULL,
  `time_format` varchar(10) DEFAULT NULL,
  `dtz` varchar(120) DEFAULT NULL,
  `locale` varchar(200) DEFAULT NULL,
  `weekstart` tinyint(1) UNSIGNED NOT NULL DEFAULT '1',
  `lang` varchar(2) NOT NULL DEFAULT 'en',
  `lang_list` blob NOT NULL,
  `allow_free` varchar(3) NOT NULL DEFAULT 'yes',
  `enable_comments` tinyint(1) UNSIGNED NOT NULL DEFAULT '1',
  `ploader` tinyint(1) UNSIGNED NOT NULL DEFAULT '1',
  `eucookie` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
  `offline` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
  `offline_msg` text,
  `offline_d` date DEFAULT NULL,
  `offline_t` time DEFAULT NULL,
  `logo` varchar(50) DEFAULT NULL,
  `plogo` varchar(50) DEFAULT NULL,
  `currency` varchar(4) DEFAULT NULL,
  `enable_tax` tinyint(1) UNSIGNED NOT NULL DEFAULT '1',
  `file_dir` varchar(150) DEFAULT NULL,
  `reg_verify` tinyint(1) UNSIGNED NOT NULL DEFAULT '1',
  `auto_verify` tinyint(1) UNSIGNED NOT NULL DEFAULT '1',
  `notify_admin` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
  `flood` int(3) UNSIGNED NOT NULL DEFAULT '3600',
  `attempt` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
  `logging` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
  `analytics` text,
  `mailer` enum('PHP','SMTP','SMAIL') DEFAULT NULL,
  `sendmail` varchar(60) DEFAULT NULL,
  `smtp_host` varchar(150) DEFAULT NULL,
  `smtp_user` varchar(50) DEFAULT NULL,
  `smtp_pass` varchar(50) DEFAULT NULL,
  `smtp_port` varchar(3) DEFAULT NULL,
  `is_ssl` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
  `inv_info` text,
  `inv_note` text,
  `social_media` blob,
  `mapapi` varchar(120) DEFAULT NULL,
  `wojon` decimal(4,2) UNSIGNED NOT NULL DEFAULT '0.00',
  `wojov` decimal(4,2) UNSIGNED NOT NULL DEFAULT '0.00',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` VALUES(1, 'Your Website', '', '', 'info@domain.com', '_default.css', 'master', 12, 14, 16, 0, '11-Oct-2017_23-52-35.sql', 300, 300, 250, 250, 'dd MMM yyyy', 'MMMM dd, yyyy hh:mm a', 'HH:mm', 'America/Toronto', 'en_CA', 1, 'en', 0x5b7b226964223a312c226e616d65223a22456e676c697368222c2261626272223a22656e222c226c616e67646972223a226c7472222c22636f6c6f72223a2223374143423935222c22617574686f72223a22687474703a5c2f5c2f7777772e776f6a6f736372697074732e636f6d222c22686f6d65223a317d2c7b226964223a342c226e616d65223a224672656e6368222c2261626272223a226672222c226c616e67646972223a226c7472222c22636f6c6f72223a2223303062636434222c22617574686f72223a22687474703a5c2f5c2f7777772e776f6a6f736372697074732e636f6d222c22686f6d65223a307d5d, 'no', 1, 0, 0, 0, '<p>Our website is under construction, we are working very hard to give you the best experience on our new web site.</p>', '2018-06-30', '17:19:00', 'logo.svg', 'print_logo.png', 'CAD', 1, '/replace_with_your_own/', 1, 1, 1, 1800, 3, 1, '', 'PHP', '/usr/sbin/sendmail -t -i', 'mail.hostname.com', 'yourusername', 'yourpass', '25', 0, '<p><b>ABC Company Pty Ltd</b><br>123 Burke Street, Toronto ON, CANADA<br>Tel : (416) 1234-5678, Fax : (416) 1234-5679<br>Email : sales@abc-company.com</p>', '<p>TERMS &amp; CONDITIONS<br>1. Interest may be levied on overdue accounts. <br>2. Goods sold are not returnable or refundable</p>', 0x7b2266616365626f6f6b223a2266616365626f6f6b5f70616765222c2274776974746572223a22747769747465725f70616765227d, '', '1.00', '4.10');

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

DROP TABLE IF EXISTS `trash`;
CREATE TABLE IF NOT EXISTS `trash` (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `parent` varchar(15) DEFAULT NULL,
  `parent_id` int(11) UNSIGNED NOT NULL DEFAULT '0',
  `type` varchar(15) DEFAULT NULL,
  `dataset` blob,
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

DROP TABLE IF EXISTS `users`;
CREATE TABLE IF NOT EXISTS `users` (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `username` varchar(20) NOT NULL,
  `fname` varchar(64) NOT NULL,
  `lname` varchar(64) NOT NULL,
  `membership_id` smallint(3) UNSIGNED NOT NULL DEFAULT '0',
  `mem_expire` datetime DEFAULT '1970-01-01 00:00:00',
  `email` varchar(60) NOT NULL,
  `salt` varchar(25) NOT NULL,
  `hash` varchar(70) NOT NULL,
  `token` varchar(40) NOT NULL DEFAULT '0',
  `userlevel` tinyint(1) UNSIGNED NOT NULL DEFAULT '1',
  `type` varchar(10) NOT NULL DEFAULT 'member',
  `lastlogin` datetime DEFAULT NULL,
  `lastip` varbinary(16) DEFAULT '000.000.000.000',
  `avatar` varchar(50) DEFAULT NULL,
  `address` varchar(100) DEFAULT NULL,
  `city` varchar(50) DEFAULT NULL,
  `state` varchar(50) DEFAULT NULL,
  `zip` varchar(10) DEFAULT NULL,
  `country` varchar(4) DEFAULT NULL,
  `notify` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
  `access` text,
  `notes` tinytext,
  `info` tinytext,
  `newsletter` tinyint(1) UNSIGNED NOT NULL DEFAULT '1',
  `stripe_cus` varchar(80) DEFAULT NULL,
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `active` enum('y','n','t','b') NOT NULL DEFAULT 'n',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

DROP TABLE IF EXISTS `wishlist`;
CREATE TABLE IF NOT EXISTS `wishlist` (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`id`),
  KEY `idx_user` (`user_id`),
  KEY `idx_product` (`product_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;