-- phpMyAdmin SQL Dump
-- version 5.2.3
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Sep 09, 2026 at 10:44 AM
-- Server version: 5.7.44-48
-- PHP Version: 8.4.24
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
--
-- Database: `thundfd8_jacky`
--
-- --------------------------------------------------------
--
-- Table structure for table `banlist`
--
CREATE TABLE `banlist` (
`id` int(11) NOT NULL,
`item` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
`type` enum('IP','Email') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'IP',
`comment` varchar(150) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `cart`
--
CREATE TABLE `cart` (
`uid` int(11) UNSIGNED NOT NULL DEFAULT '0',
`mid` int(11) UNSIGNED NOT NULL DEFAULT '0',
`cid` int(11) UNSIGNED NOT NULL DEFAULT '0',
`tax` decimal(13,2) UNSIGNED NOT NULL DEFAULT '0.00',
`totaltax` decimal(13,2) UNSIGNED NOT NULL DEFAULT '0.00',
`coupon` decimal(13,2) UNSIGNED NOT NULL DEFAULT '0.00',
`total` decimal(13,2) UNSIGNED NOT NULL DEFAULT '0.00',
`originalprice` decimal(13,2) UNSIGNED NOT NULL DEFAULT '0.00',
`totalprice` decimal(13,2) UNSIGNED NOT NULL DEFAULT '0.00',
`cart_id` varchar(100) DEFAULT NULL,
`order_id` varchar(100) DEFAULT NULL,
`created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `cart`
--
INSERT INTO `cart` (`uid`, `mid`, `cid`, `tax`, `totaltax`, `coupon`, `total`, `originalprice`, `totalprice`, `cart_id`, `order_id`, `created`) VALUES
(2, 2, 0, 0.00, 0.00, 0.00, 50.00, 50.00, 50.00, NULL, NULL, '2022-12-01 09:57:12');
-- --------------------------------------------------------
--
-- Table structure for table `countries`
--
CREATE TABLE `countries` (
`id` smallint(6) UNSIGNED NOT NULL,
`abbr` varchar(2) NOT NULL,
`name` varchar(70) NOT NULL,
`active` tinyint(1) UNSIGNED NOT NULL DEFAULT '1',
`home` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
`vat` decimal(13,2) UNSIGNED NOT NULL DEFAULT '0.00',
`sorting` smallint(6) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `countries`
--
INSERT INTO `countries` (`id`, `abbr`, `name`, `active`, `home`, `vat`, `sorting`) VALUES
(1, 'AF', 'Afghanistan', 1, 0, 0.00, 0),
(2, 'AL', 'Albania', 1, 0, 0.00, 0),
(3, 'DZ', 'Algeria', 1, 0, 0.00, 0),
(4, 'AS', 'American Samoa', 1, 0, 0.00, 0),
(5, 'AD', 'Andorra', 1, 0, 0.00, 0),
(6, 'AO', 'Angola', 1, 0, 0.00, 0),
(7, 'AI', 'Anguilla', 1, 0, 0.00, 0),
(8, 'AQ', 'Antarctica', 1, 0, 0.00, 0),
(9, 'AG', 'Antigua and Barbuda', 1, 0, 0.00, 0),
(10, 'AR', 'Argentina', 1, 0, 0.00, 0),
(11, 'AM', 'Armenia', 1, 0, 0.00, 0),
(12, 'AW', 'Aruba', 1, 0, 0.00, 0),
(13, 'AU', 'Australia', 1, 0, 0.00, 0),
(14, 'AT', 'Austria', 1, 0, 0.00, 0),
(15, 'AZ', 'Azerbaijan', 1, 0, 0.00, 0),
(16, 'BS', 'Bahamas', 1, 0, 0.00, 0),
(17, 'BH', 'Bahrain', 1, 0, 0.00, 0),
(18, 'BD', 'Bangladesh', 1, 0, 0.00, 0),
(19, 'BB', 'Barbados', 1, 0, 0.00, 0),
(20, 'BY', 'Belarus', 1, 0, 0.00, 0),
(21, 'BE', 'Belgium', 1, 0, 0.00, 0),
(22, 'BZ', 'Belize', 1, 0, 0.00, 0),
(23, 'BJ', 'Benin', 1, 0, 0.00, 0),
(24, 'BM', 'Bermuda', 1, 0, 0.00, 0),
(25, 'BT', 'Bhutan', 1, 0, 0.00, 0),
(26, 'BO', 'Bolivia', 1, 0, 0.00, 0),
(27, 'BA', 'Bosnia and Herzegowina', 1, 0, 0.00, 0),
(28, 'BW', 'Botswana', 1, 0, 0.00, 0),
(29, 'BV', 'Bouvet Island', 1, 0, 0.00, 0),
(30, 'BR', 'Brazil', 1, 0, 0.00, 0),
(31, 'IO', 'British Indian Ocean Territory', 1, 0, 0.00, 0),
(32, 'VG', 'British Virgin Islands', 1, 0, 0.00, 0),
(33, 'BN', 'Brunei Darussalam', 1, 0, 0.00, 0),
(34, 'BG', 'Bulgaria', 1, 0, 0.00, 0),
(35, 'BF', 'Burkina Faso', 1, 0, 0.00, 0),
(36, 'BI', 'Burundi', 1, 0, 0.00, 0),
(37, 'KH', 'Cambodia', 1, 0, 0.00, 0),
(38, 'CM', 'Cameroon', 1, 0, 0.00, 0),
(39, 'CA', 'Canada', 1, 1, 13.00, 1000),
(40, 'CV', 'Cape Verde', 1, 0, 0.00, 0),
(41, 'KY', 'Cayman Islands', 1, 0, 0.00, 0),
(42, 'CF', 'Central African Republic', 1, 0, 0.00, 0),
(43, 'TD', 'Chad', 1, 0, 0.00, 0),
(44, 'CL', 'Chile', 1, 0, 0.00, 0),
(45, 'CN', 'China', 1, 0, 0.00, 0),
(46, 'CX', 'Christmas Island', 1, 0, 0.00, 0),
(47, 'CC', 'Cocos (Keeling) Islands', 1, 0, 0.00, 0),
(48, 'CO', 'Colombia', 1, 0, 0.00, 0),
(49, 'KM', 'Comoros', 1, 0, 0.00, 0),
(50, 'CG', 'Congo', 1, 0, 0.00, 0),
(51, 'CK', 'Cook Islands', 1, 0, 0.00, 0),
(52, 'CR', 'Costa Rica', 1, 0, 0.00, 0),
(53, 'CI', 'Cote D\'ivoire', 1, 0, 0.00, 0),
(54, 'HR', 'Croatia', 1, 0, 0.00, 0),
(55, 'CU', 'Cuba', 1, 0, 0.00, 0),
(56, 'CY', 'Cyprus', 1, 0, 0.00, 0),
(57, 'CZ', 'Czech Republic', 1, 0, 0.00, 0),
(58, 'DK', 'Denmark', 1, 0, 0.00, 0),
(59, 'DJ', 'Djibouti', 1, 0, 0.00, 0),
(60, 'DM', 'Dominica', 1, 0, 0.00, 0),
(61, 'DO', 'Dominican Republic', 1, 0, 0.00, 0),
(62, 'TP', 'East Timor', 1, 0, 0.00, 0),
(63, 'EC', 'Ecuador', 1, 0, 0.00, 0),
(64, 'EG', 'Egypt', 1, 0, 0.00, 0),
(65, 'SV', 'El Salvador', 1, 0, 0.00, 0),
(66, 'GQ', 'Equatorial Guinea', 1, 0, 0.00, 0),
(67, 'ER', 'Eritrea', 1, 0, 0.00, 0),
(68, 'EE', 'Estonia', 1, 0, 0.00, 0),
(69, 'ET', 'Ethiopia', 1, 0, 0.00, 0),
(70, 'FK', 'Falkland Islands (Malvinas)', 1, 0, 0.00, 0),
(71, 'FO', 'Faroe Islands', 1, 0, 0.00, 0),
(72, 'FJ', 'Fiji', 1, 0, 0.00, 0),
(73, 'FI', 'Finland', 1, 0, 0.00, 0),
(74, 'FR', 'France', 1, 0, 0.00, 0),
(75, 'GF', 'French Guiana', 1, 0, 0.00, 0),
(76, 'PF', 'French Polynesia', 1, 0, 0.00, 0),
(77, 'TF', 'French Southern Territories', 1, 0, 0.00, 0),
(78, 'GA', 'Gabon', 1, 0, 0.00, 0),
(79, 'GM', 'Gambia', 1, 0, 0.00, 0),
(80, 'GE', 'Georgia', 1, 0, 0.00, 0),
(81, 'DE', 'Germany', 1, 0, 0.00, 0),
(82, 'GH', 'Ghana', 1, 0, 0.00, 0),
(83, 'GI', 'Gibraltar', 1, 0, 0.00, 0),
(84, 'GR', 'Greece', 1, 0, 0.00, 0),
(85, 'GL', 'Greenland', 1, 0, 0.00, 0),
(86, 'GD', 'Grenada', 1, 0, 0.00, 0),
(87, 'GP', 'Guadeloupe', 1, 0, 0.00, 0),
(88, 'GU', 'Guam', 1, 0, 0.00, 0),
(89, 'GT', 'Guatemala', 1, 0, 0.00, 0),
(90, 'GN', 'Guinea', 1, 0, 0.00, 0),
(91, 'GW', 'Guinea-Bissau', 1, 0, 0.00, 0),
(92, 'GY', 'Guyana', 1, 0, 0.00, 0),
(93, 'HT', 'Haiti', 1, 0, 0.00, 0),
(94, 'HM', 'Heard and McDonald Islands', 1, 0, 0.00, 0),
(95, 'HN', 'Honduras', 1, 0, 0.00, 0),
(96, 'HK', 'Hong Kong', 1, 0, 0.00, 0),
(97, 'HU', 'Hungary', 1, 0, 0.00, 0),
(98, 'IS', 'Iceland', 1, 0, 0.00, 0),
(99, 'IN', 'India', 1, 0, 0.00, 0),
(100, 'ID', 'Indonesia', 1, 0, 0.00, 0),
(101, 'IQ', 'Iraq', 1, 0, 0.00, 0),
(102, 'IE', 'Ireland', 1, 0, 0.00, 0),
(103, 'IR', 'Islamic Republic of Iran', 1, 0, 0.00, 0),
(104, 'IL', 'Israel', 1, 0, 0.00, 0),
(105, 'IT', 'Italy', 1, 0, 0.00, 0),
(106, 'JM', 'Jamaica', 1, 0, 0.00, 0),
(107, 'JP', 'Japan', 1, 0, 0.00, 0),
(108, 'JO', 'Jordan', 1, 0, 0.00, 0),
(109, 'KZ', 'Kazakhstan', 1, 0, 0.00, 0),
(110, 'KE', 'Kenya', 1, 0, 0.00, 0),
(111, 'KI', 'Kiribati', 1, 0, 0.00, 0),
(112, 'KP', 'Korea, Dem. Peoples Rep of', 1, 0, 0.00, 0),
(113, 'KR', 'Korea, Republic of', 1, 0, 0.00, 0),
(114, 'KW', 'Kuwait', 1, 0, 0.00, 0),
(115, 'KG', 'Kyrgyzstan', 1, 0, 0.00, 0),
(116, 'LA', 'Laos', 1, 0, 0.00, 0),
(117, 'LV', 'Latvia', 1, 0, 0.00, 0),
(118, 'LB', 'Lebanon', 1, 0, 0.00, 0),
(119, 'LS', 'Lesotho', 1, 0, 0.00, 0),
(120, 'LR', 'Liberia', 1, 0, 0.00, 0),
(121, 'LY', 'Libyan Arab Jamahiriya', 1, 0, 0.00, 0),
(122, 'LI', 'Liechtenstein', 1, 0, 0.00, 0),
(123, 'LT', 'Lithuania', 1, 0, 0.00, 0),
(124, 'LU', 'Luxembourg', 1, 0, 0.00, 0),
(125, 'MO', 'Macau', 1, 0, 0.00, 0),
(126, 'MK', 'Macedonia', 1, 0, 0.00, 0),
(127, 'MG', 'Madagascar', 1, 0, 0.00, 0),
(128, 'MW', 'Malawi', 1, 0, 0.00, 0),
(129, 'MY', 'Malaysia', 1, 0, 0.00, 0),
(130, 'MV', 'Maldives', 1, 0, 0.00, 0),
(131, 'ML', 'Mali', 1, 0, 0.00, 0),
(132, 'MT', 'Malta', 1, 0, 0.00, 0),
(133, 'MH', 'Marshall Islands', 1, 0, 0.00, 0),
(134, 'MQ', 'Martinique', 1, 0, 0.00, 0),
(135, 'MR', 'Mauritania', 1, 0, 0.00, 0),
(136, 'MU', 'Mauritius', 1, 0, 0.00, 0),
(137, 'YT', 'Mayotte', 1, 0, 0.00, 0),
(138, 'MX', 'Mexico', 1, 0, 0.00, 0),
(139, 'FM', 'Micronesia', 1, 0, 0.00, 0),
(140, 'MD', 'Moldova, Republic of', 1, 0, 0.00, 0),
(141, 'MC', 'Monaco', 1, 0, 0.00, 0),
(142, 'MN', 'Mongolia', 1, 0, 0.00, 0),
(143, 'MS', 'Montserrat', 1, 0, 0.00, 0),
(144, 'MA', 'Morocco', 1, 0, 0.00, 0),
(145, 'MZ', 'Mozambique', 1, 0, 0.00, 0),
(146, 'MM', 'Myanmar', 1, 0, 0.00, 0),
(147, 'NA', 'Namibia', 1, 0, 0.00, 0),
(148, 'NR', 'Nauru', 1, 0, 0.00, 0),
(149, 'NP', 'Nepal', 1, 0, 0.00, 0),
(150, 'NL', 'Netherlands', 1, 0, 0.00, 0),
(151, 'AN', 'Netherlands Antilles', 1, 0, 0.00, 0),
(152, 'NC', 'New Caledonia', 1, 0, 0.00, 0),
(153, 'NZ', 'New Zealand', 1, 0, 0.00, 0),
(154, 'NI', 'Nicaragua', 1, 0, 0.00, 0),
(155, 'NE', 'Niger', 1, 0, 0.00, 0),
(156, 'NG', 'Nigeria', 1, 0, 0.00, 0),
(157, 'NU', 'Niue', 1, 0, 0.00, 0),
(158, 'NF', 'Norfolk Island', 1, 0, 0.00, 0),
(159, 'MP', 'Northern Mariana Islands', 1, 0, 0.00, 0),
(160, 'NO', 'Norway', 1, 0, 0.00, 0),
(161, 'OM', 'Oman', 1, 0, 0.00, 0),
(162, 'PK', 'Pakistan', 1, 0, 0.00, 0),
(163, 'PW', 'Palau', 1, 0, 0.00, 0),
(164, 'PA', 'Panama', 1, 0, 0.00, 0),
(165, 'PG', 'Papua New Guinea', 1, 0, 0.00, 0),
(166, 'PY', 'Paraguay', 1, 0, 0.00, 0),
(167, 'PE', 'Peru', 1, 0, 0.00, 0),
(168, 'PH', 'Philippines', 1, 0, 0.00, 0),
(169, 'PN', 'Pitcairn', 1, 0, 0.00, 0),
(170, 'PL', 'Poland', 1, 0, 0.00, 0),
(171, 'PT', 'Portugal', 1, 0, 0.00, 0),
(172, 'PR', 'Puerto Rico', 1, 0, 0.00, 0),
(173, 'QA', 'Qatar', 1, 0, 0.00, 0),
(174, 'RE', 'Reunion', 1, 0, 0.00, 0),
(175, 'RO', 'Romania', 1, 0, 0.00, 0),
(176, 'RU', 'Russian Federation', 1, 0, 0.00, 0),
(177, 'RW', 'Rwanda', 1, 0, 0.00, 0),
(178, 'LC', 'Saint Lucia', 1, 0, 0.00, 0),
(179, 'WS', 'Samoa', 1, 0, 0.00, 0),
(180, 'SM', 'San Marino', 1, 0, 0.00, 0),
(181, 'ST', 'Sao Tome and Principe', 1, 0, 0.00, 0),
(182, 'SA', 'Saudi Arabia', 1, 0, 0.00, 0),
(183, 'SN', 'Senegal', 1, 0, 0.00, 0),
(184, 'RS', 'Serbia', 1, 0, 0.00, 0),
(185, 'SC', 'Seychelles', 1, 0, 0.00, 0),
(186, 'SL', 'Sierra Leone', 1, 0, 0.00, 0),
(187, 'SG', 'Singapore', 1, 0, 0.00, 0),
(188, 'SK', 'Slovakia', 1, 0, 0.00, 0),
(189, 'SI', 'Slovenia', 1, 0, 0.00, 0),
(190, 'SB', 'Solomon Islands', 1, 0, 0.00, 0),
(191, 'SO', 'Somalia', 1, 0, 0.00, 0),
(192, 'ZA', 'South Africa', 1, 0, 0.00, 0),
(193, 'ES', 'Spain', 1, 0, 0.00, 0),
(194, 'LK', 'Sri Lanka', 1, 0, 0.00, 0),
(195, 'SH', 'St. Helena', 1, 0, 0.00, 0),
(196, 'KN', 'St. Kitts and Nevis', 1, 0, 0.00, 0),
(197, 'PM', 'St. Pierre and Miquelon', 1, 0, 0.00, 0),
(198, 'VC', 'St. Vincent and the Grenadines', 1, 0, 0.00, 0),
(199, 'SD', 'Sudan', 1, 0, 0.00, 0),
(200, 'SR', 'Suriname', 1, 0, 0.00, 0),
(201, 'SJ', 'Svalbard and Jan Mayen Islands', 1, 0, 0.00, 0),
(202, 'SZ', 'Swaziland', 1, 0, 0.00, 0),
(203, 'SE', 'Sweden', 1, 0, 0.00, 0),
(204, 'CH', 'Switzerland', 1, 0, 0.00, 0),
(205, 'SY', 'Syrian Arab Republic', 1, 0, 0.00, 0),
(206, 'TW', 'Taiwan', 1, 0, 0.00, 0),
(207, 'TJ', 'Tajikistan', 1, 0, 0.00, 0),
(208, 'TZ', 'Tanzania, United Republic of', 1, 0, 0.00, 0),
(209, 'TH', 'Thailand', 1, 0, 0.00, 0),
(210, 'TG', 'Togo', 1, 0, 0.00, 0),
(211, 'TK', 'Tokelau', 1, 0, 0.00, 0),
(212, 'TO', 'Tonga', 1, 0, 0.00, 0),
(213, 'TT', 'Trinidad and Tobago', 1, 0, 0.00, 0),
(214, 'TN', 'Tunisia', 1, 0, 0.00, 0),
(215, 'TR', 'Turkey', 1, 0, 0.00, 0),
(216, 'TM', 'Turkmenistan', 1, 0, 0.00, 0),
(217, 'TC', 'Turks and Caicos Islands', 1, 0, 0.00, 0),
(218, 'TV', 'Tuvalu', 1, 0, 0.00, 0),
(219, 'UG', 'Uganda', 1, 0, 0.00, 0),
(220, 'UA', 'Ukraine', 1, 0, 0.00, 0),
(221, 'AE', 'United Arab Emirates', 1, 0, 0.00, 0),
(222, 'GB', 'United Kingdom (GB)', 1, 0, 23.00, 999),
(224, 'US', 'United States', 1, 0, 7.50, 998),
(225, 'VI', 'United States Virgin Islands', 1, 0, 0.00, 0),
(226, 'UY', 'Uruguay', 1, 0, 0.00, 0),
(227, 'UZ', 'Uzbekistan', 1, 0, 0.00, 0),
(228, 'VU', 'Vanuatu', 1, 0, 0.00, 0),
(229, 'VA', 'Vatican City State', 1, 0, 0.00, 0),
(230, 'VE', 'Venezuela', 1, 0, 0.00, 0),
(231, 'VN', 'Vietnam', 1, 0, 0.00, 0),
(232, 'WF', 'Wallis And Futuna Islands', 1, 0, 0.00, 0),
(233, 'EH', 'Western Sahara', 1, 0, 0.00, 0),
(234, 'YE', 'Yemen', 1, 0, 0.00, 0),
(235, 'ZR', 'Zaire', 1, 0, 0.00, 0),
(236, 'ZM', 'Zambia', 1, 0, 0.00, 0),
(237, 'ZW', 'Zimbabwe', 1, 0, 0.00, 0);
-- --------------------------------------------------------
--
-- Table structure for table `coupons`
--
CREATE TABLE `coupons` (
`id` int(1) UNSIGNED NOT NULL,
`title` varchar(100) NOT NULL,
`code` varchar(30) NOT NULL,
`discount` smallint(2) UNSIGNED NOT NULL DEFAULT '0',
`type` enum('p','a') NOT NULL DEFAULT 'p',
`membership_id` varchar(50) NOT NULL DEFAULT '0',
`created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`active` tinyint(1) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `coupons`
--
INSERT INTO `coupons` (`id`, `title`, `code`, `discount`, `type`, `membership_id`, `created`, `active`) VALUES
(1, 'RM5 discount for RM50 payment', 'JUST5', 5, 'a', '2', '2022-11-24 09:53:57', 1);
-- --------------------------------------------------------
--
-- Table structure for table `cronjobs`
--
CREATE TABLE `cronjobs` (
`id` int(11) UNSIGNED NOT NULL,
`user_id` int(11) UNSIGNED NOT NULL DEFAULT '0',
`membership_id` int(11) UNSIGNED NOT NULL DEFAULT '0',
`stripe_customer` varchar(60) NOT NULL,
`stripe_pm` varchar(80) NOT NULL,
`amount` decimal(10,2) UNSIGNED NOT NULL DEFAULT '0.00',
`created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`renewal` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `custom_fields`
--
CREATE TABLE `custom_fields` (
`id` int(6) UNSIGNED NOT NULL,
`title` varchar(60) NOT NULL,
`name` varchar(20) NOT NULL,
`tooltip` varchar(100) DEFAULT NULL,
`required` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
`section` varchar(30) DEFAULT NULL,
`sorting` int(4) UNSIGNED NOT NULL DEFAULT '0',
`active` tinyint(1) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `downloads`
--
CREATE TABLE `downloads` (
`id` int(11) UNSIGNED NOT NULL,
`alias` varchar(60) NOT NULL,
`name` varchar(80) NOT NULL,
`filesize` int(11) UNSIGNED NOT NULL,
`extension` varchar(4) DEFAULT NULL,
`type` varchar(20) DEFAULT NULL,
`token` varchar(32) NOT NULL,
`fileaccess` varchar(24) NOT NULL DEFAULT '0' COMMENT '0 = all',
`created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `email_templates`
--
CREATE TABLE `email_templates` (
`id` int(5) UNSIGNED NOT NULL,
`name` varchar(100) NOT NULL,
`subject` varchar(150) NOT NULL,
`help` tinytext,
`body` text NOT NULL,
`type` enum('news','mailer') DEFAULT 'mailer',
`typeid` varchar(30) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `email_templates`
--
INSERT INTO `email_templates` (`id`, `name`, `subject`, `help`, `body`, `type`, `typeid`) 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', '\n\n\n
\n\n\n\n| | \n \n\n| [LOGO] | \n \n\n| | \n \n\n| \n Welcome to [COMPANY] \n | \n \n\n![\"line\"](\"[SITEURL]/assets/images/line.png\") | \n \n\n| | \n \n\n
\nCongratulations! \n
\nYou are now registered member
The administrator of this site has requested all new accounts to be activated by the users who created them thus your account is currently inactive. To activate your account, please visit the link below. \n | \n \n\n| \n Here are your login details. Please keep them in a safe place:
Username: [USERNAME]
Password: [PASSWORD] \n | \n \n\n| | \n \n\n| \n\n | \n \n\n| | \n \n\n| | \n \n\n| | \n \n\n\n\n\n\n| \n This email is sent to you directly from [COMPANY] The information above is gathered from the user input.
©[DATE] [COMPANY]. All rights reserved. \n | \n | \n![\"facebook](\"[SITEURL]/assets/images/facebook.png\") | \n | \n![\"twitter](\"[SITEURL]/assets/images/twitter.png\") | \n \n\n \n | \n \n\n \n | \n
\n\n
\n
', 'mailer', 'regMail'),
(2, 'Welcome Mail From Admin', 'You have been registered', 'This template is used to send welcome email, when user is added by administrator', '\n\n\n
\n\n\n\n| | \n \n\n| [LOGO] | \n \n\n| | \n \n\n| \n Welcome to [COMPANY] \n | \n \n\n | \n \n\n| | \n \n\n
\nHello, [NAME] \nYou\'re now a member of [COMPANY].
Here are your login details. Please keep them in a safe place: \n | \n \n\n| \n Here are your login details. Please keep them in a safe place:
Username: [USERNAME] or [EMAIL]
Password: [PASSWORD] \n | \n \n\n| | \n \n\n| \n\n | \n \n\n| | \n \n\n| | \n \n\n| | \n \n\n\n\n\n\n| \n This email is sent to you directly from [COMPANY] The information above is gathered from the user input.
©[DATE] [COMPANY]. All rights reserved. \n | \n | \n | \n | \n | \n \n\n \n | \n \n\n \n | \n
\n\n
', 'mailer', 'regMailAdmin'),
(3, 'Default Newsletter', 'Newsletter', 'This is a default newsletter template', '\n\n\n
\n\n\n\n| | \n \n\n| [LOGO] | \n \n\n| | \n \n\n| \n [COMPANY] Newsletter \n | \n \n\n | \n \n\n| | \n \n\n
\nHello, [NAME]\n
\n[ATTACHMENT]\n
\nNewsletter content goes here...:
\n | \n \n\n| | \n \n\n| | \n \n\n| | \n \n\n\n\n\n\n| \n\n This email is sent to you directly from [COMPANY] The information above is gathered from the user input.
©[DATE] [COMPANY]. All rights reserved. \n\n | \n | \n | \n | \n | \n \n\n \n | \n \n\n \n | \n
\n\n
\n
', 'mailer', 'newsletter'),
(4, 'Single Email', 'Single User Email', 'This template is used to email single user', '\n\n\n
\n\n\n\n| | \n \n\n| [LOGO] | \n \n\n| | \n \n\n| \n Hello [NAME] \n | \n \n\n | \n \n\n| | \n \n\n| Your message goes here... | \n \n\n| [ATTACHMENT] | \n \n\n| | \n \n\n| | \n \n\n| | \n \n\n\n\n\n\n| \n This email is sent to you directly from [COMPANY] The information above is gathered from the user input.
©[DATE] [COMPANY]. All rights reserved. \n | \n | \n | \n | \n | \n \n\n \n | \n \n\n \n | \n
\n\n
\n
', 'mailer', 'singleMail'),
(5, 'Forgot Password Admin', 'Password Reset', 'This template is used for retrieving lost admin password', '\n\n\n
\n\n\n\n| | \n \n\n| [LOGO] | \n \n\n| | \n \n\n| \n New password reset from [COMPANY] \n | \n \n\n | \n \n\n| | \n \n\n
\nHello, [NAME]\n
\nIt seems that you or someone requested a new password for you.
We have generated a new password, as requested:
\n | \n \n\n| \nNew Password: [PASSWORD]\n | \n \n\n| | \n \n\n| \n\n | \n \n\n| | \n \n\n| | \n \n\n\n\n\n\n| \n\n This email is sent to you directly from [COMPANY] The information above is gathered from the user input.
©[DATE] [COMPANY]. All rights reserved. \n\n | \n | \n | \n | \n | \n \n\n \n | \n \n\n \n | \n
\n\n
\n
', 'mailer', 'adminPassReset'),
(6, 'Forgot Password User', 'Password Reset', 'This template is used for retrieving lost user password', '\n\n\n
\n\n\n\n| | \n \n\n| [LOGO] | \n \n\n| | \n \n\n| \n New password reset from [COMPANY] \n | \n \n\n | \n \n\n| | \n \n\n
\nHello, [NAME]\n
\nIt seems that you or someone requested a new password for you.
We have generated a new password, as requested:
\n | \n \n\n| \nNew Password: [PASSWORD]\n | \n \n\n| | \n \n\n| \n\n | \n \n\n| | \n \n\n| | \n \n\n\n\n\n\n| \n\n This email is sent to you directly from [COMPANY] The information above is gathered from the user input.
©[DATE] [COMPANY]. All rights reserved. \n\n | \n | \n | \n | \n | \n \n\n \n | \n \n\n \n | \n
\n\n
\n
', 'mailer', 'userPassReset'),
(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', '\n\n\n
\n\n\n\n| | \n \n\n| [LOGO] | \n \n\n| | \n \n\n| \n Welcome to [COMPANY] \n | \n \n\n | \n \n\n| | \n \n\n
\nCongratulations! \n
\nYou are now registered member. \n | \n \n\n| \n Here are your login details. Please keep them in a safe place:
Username: [USERNAME]
Password: [PASSWORD] \n | \n \n\n| | \n \n\n| \n\n | \n \n\n| | \n \n\n| | \n \n\n| | \n \n\n\n\n\n\n| \n This email is sent to you directly from [COMPANY] The information above is gathered from the user input.
©[DATE] [COMPANY]. All rights reserved. \n | \n | \n | \n | \n | \n \n\n \n | \n \n\n \n | \n
\n\n
\n
', 'mailer', 'welcomeEmail'),
(8, 'Registration Pending', 'Registration Verification Pending', 'This template is used to send Registration Verification Email, when Configuration->Auto Registration is set to NO', '\n\n\n
\n\n\n\n| | \n \n\n| [LOGO] | \n \n\n| | \n \n\n| \n Welcome to [COMPANY] \n | \n \n\n | \n \n\n| | \n \n\n
\nCongratulations! \n
\nYou are now registered member
The administrator of this site has requested all new accounts to be activated by the users who created them thus your account is currently pending verification process. \n | \n \n\n| \n Here are your login details. Please keep them in a safe place:
Username: [USERNAME]
Password: [PASSWORD] \n | \n \n\n| | \n \n\n| | \n \n\n| | \n \n\n\n\n\n\n| \n This email is sent to you directly from [COMPANY] The information above is gathered from the user input.
©[DATE] [COMPANY]. All rights reserved. \n | \n | \n | \n | \n | \n \n\n \n | \n \n\n \n | \n
\n\n
', 'mailer', 'regMailPending'),
(9, 'Notify Admin', 'New User Registration', 'This template is used to notify admin of new registration when Configuration->Registration Notification is set to YES', '\n\n\n
\n\n\n\n| | \n \n\n| [LOGO] | \n \n\n| | \n \n\n| \n Hello Admin \n | \n \n\n | \n \n\n| | \n \n\n\nYou have a new user registration. You can login into your admin panel to view details:\n
\n\n\n\n\n| Username: | \n[USERNAME] | \n \n\n| Name: | \n[NAME] | \n \n\n| IP: | \n[IP] | \n \n\n \n\n | \n \n\n| | \n \n\n| | \n \n\n| | \n \n\n\n\n\n\n| \n\n This email is sent to you directly from [COMPANY] The information above is gathered from the user input.
©[DATE] [COMPANY]. All rights reserved. \n\n | \n | \n | \n | \n | \n \n\n \n | \n \n\n \n | \n
\n\n
', 'mailer', 'notifyAdmin'),
(10, 'Contact Request', 'Contact Inquiry', 'This template is used to send default Contact Request Form', '\n\n\n
\n\n\n\n| | \n \n\n| [LOGO] | \n \n\n| | \n \n\n| \n Hello Admin \n | \n \n\n | \n \n\n| | \n \n\n\nYou have a new contact request:\n
\n\n\n\n\n| From: | \n[NAME] | \n \n\n| Subject: | \n[MAILSUBJECT] | \n \n\n| IP: | \n[IP] | \n \n\n \n\n
\n[MESSAGE]\n | \n \n\n| | \n \n\n| | \n \n\n| | \n \n\n\n\n\n\n| \n\n This email is sent to you directly from [COMPANY] The information above is gathered from the user input.
©[DATE] [COMPANY]. All rights reserved. \n\n | \n | \n | \n | \n | \n \n\n \n | \n \n\n \n | \n
\n\n
', 'mailer', 'contact'),
(11, 'Transaction Completed Admin', 'Payment Completed', 'This template is used to notify administrator on successful payment transaction', '\n\n\n
\n\n\n\n| | \n \n\n| [LOGO] | \n \n\n| | \n \n\n| \n Hello Admin \n | \n \n\n | \n \n\n| | \n \n\n\nYou have received new payment following:\n
\n\n\n\n\n| Name: | \n[NAME] | \n \n\n| Membership: | \n[ITEMNAME] | \n \n\n| Price: | \n[PRICE] | \n \n\n| Status: | \n[STATUS] | \n \n\n| Processor: | \n[PP] | \n \n\n| IP: | \n[IP] | \n \n\n \n\n | \n \n\n| | \n \n\n| | \n \n\n| | \n \n\n\n\n\n\n| \n\n This email is sent to you directly from [COMPANY] The information above is gathered from the user input.
©[DATE] [COMPANY]. All rights reserved. \n\n | \n | \n | \n | \n | \n \n\n \n | \n \n\n \n | \n
\n\n
\n
', 'mailer', 'payComplete'),
(12, 'Transaction Completed User', 'Payment Completed', 'This template is used to notify user on successful payment transaction', '\n\n\n
\n\n\n\n| | \n \n\n| [LOGO] | \n \n\n| | \n \n\n| \n Hello [NAME] \n | \n \n\n | \n \n\n| | \n \n\n\nYour payment has been completed successfuly.\n
\n\n\n\n\n| Membership: | \n[ITEMNAME] | \n \n\n| Discount: | \n[COUPON] | \n \n\n| Vat/Tax: | \n[TAX] | \n \n\n| Price: | \n[PRICE] | \n \n\n| Processor: | \n[PP] | \n \n\n \n\n | \n \n\n| | \n \n\n| | \n \n\n| | \n \n\n\n\n\n\n| \n\n This email is sent to you directly from [COMPANY] The information above is gathered from the user input.
©[DATE] [COMPANY]. All rights reserved. \n\n | \n | \n | \n | \n | \n \n\n \n | \n \n\n \n | \n
\n\n
\n
', 'mailer', 'payCompleteUser'),
(13, 'Membership Expired', 'Membership Has Expired', 'This template is used to notify user when membership is about to expire a day before. ', '\n\n\n
\n\n\n\n| | \n \n\n| [LOGO] | \n \n\n| | \n \n\n| \n Hello [NAME] \n | \n \n\n | \n \n\n| | \n \n\n\nYour membership access will soon expiere\n
\n\n\n\n\n| Membership: | \n[ITEMNAME] | \n \n\n| Expire: | \n[EXPIRE] | \n \n\n \n\n | \n \n\n| | \n \n\n| | \n \n\n| | \n \n\n\n\n\n\n| \n\n This email is sent to you directly from [COMPANY] The information above is gathered from the user input.
©[DATE] [COMPANY]. All rights reserved. \n\n | \n | \n | \n | \n | \n \n\n \n | \n \n\n \n | \n
\n\n
', 'mailer', 'memExpired');
-- --------------------------------------------------------
--
-- Table structure for table `gateways`
--
CREATE TABLE `gateways` (
`id` int(4) UNSIGNED NOT NULL,
`name` varchar(30) NOT NULL,
`displayname` varchar(50) NOT NULL,
`dir` varchar(30) NOT NULL,
`live` tinyint(1) UNSIGNED NOT NULL DEFAULT '1',
`extra_txt` varchar(120) DEFAULT NULL,
`extra_txt2` varchar(120) DEFAULT NULL,
`extra_txt3` varchar(120) DEFAULT NULL,
`extra` varchar(120) NOT NULL,
`extra2` varchar(120) DEFAULT NULL,
`extra3` varchar(120) DEFAULT NULL,
`is_recurring` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
`active` tinyint(1) UNSIGNED NOT NULL DEFAULT '1'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `gateways`
--
INSERT INTO `gateways` (`id`, `name`, `displayname`, `dir`, `live`, `extra_txt`, `extra_txt2`, `extra_txt3`, `extra`, `extra2`, `extra3`, `is_recurring`, `active`) VALUES
(1, 'paypal', 'PayPal', 'paypal', 1, 'Paypal Email Address', 'Currency Code', 'Not in Use', 'webmaster@wojoscripts.com', 'CAD', '', 1, 1),
(2, 'skrill', 'Skrill', 'skrill', 1, 'Skrill Email Address', 'Currency Code', 'Secret Passphrase', 'moneybookers@address.com', 'EUR', 'mypassphrase', 1, 1),
(3, 'stripe', 'Stripe', 'stripe', 1, 'Stripe Secret Key', 'Currency Code', '', 'sk_test_6sDE6weBXgEuHbrjZKyG5MlQ', 'CAD', 'pk_test_vRosykAcmL59P2r7H9hziwrg', 1, 1),
(4, 'payfast', 'PayFast', 'payfast', 1, 'Merchant ID', 'Merchant Key', 'PassPhrase', '', '', '', 0, 1),
(6, 'ideal', 'iDeal', 'ideal', 1, 'API Key', 'Currency Code', 'Not in Use', 'test_uFQUaDAjAygbhcpMN95DJdsVkDDKrJ', 'EUR', NULL, 0, 1),
(7, 'anet', 'Authorize.net', 'anet', 1, 'API Login Id', 'MD5 Hash Key', 'Transaction Key', '9KDgMm2mw46V', 'Simon', '5wek3X3DX5e39YAQ', 0, 1),
(9, 'offline', 'Offline', 'offline', 1, 'Currency Code', 'Not in Use', 'Not in Use', 'CAD', '', '', 0, 1);
-- --------------------------------------------------------
--
-- Table structure for table `memberships`
--
CREATE TABLE `memberships` (
`id` int(11) UNSIGNED NOT NULL,
`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'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `memberships`
--
INSERT INTO `memberships` (`id`, `title`, `description`, `price`, `days`, `period`, `recurring`, `thumb`, `private`, `active`) VALUES
(1, 'FREE', 'I am not sure. I will make payments manually later, and I understand that I will not get any discounts if I chose this plan.', 0.00, 5, 'Y', 0, NULL, 0, 1),
(2, 'Bronze', 'Pay MYR50, you will get MYR50.', 50.00, 5, 'Y', 0, NULL, 0, 1);
-- --------------------------------------------------------
--
-- Table structure for table `news`
--
CREATE TABLE `news` (
`id` int(6) UNSIGNED NOT NULL,
`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'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `pages`
--
CREATE TABLE `pages` (
`id` int(6) UNSIGNED NOT NULL,
`title` varchar(200) NOT NULL,
`slug` varchar(200) NOT NULL,
`body` longtext,
`page_type` enum('membership','normal') DEFAULT 'normal',
`membership_id` varchar(20) NOT NULL DEFAULT '0',
`keywords` varchar(250) DEFAULT NULL,
`description` varchar(250) DEFAULT NULL,
`created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`active` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `payments`
--
CREATE TABLE `payments` (
`id` int(11) UNSIGNED NOT NULL,
`txn_id` varchar(50) DEFAULT NULL,
`membership_id` int(11) UNSIGNED NOT NULL DEFAULT '0',
`user_id` int(11) UNSIGNED NOT NULL DEFAULT '0',
`rate_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,
`pp` varchar(20) NOT NULL DEFAULT 'Stripe',
`ip` varbinary(16) DEFAULT '000.000.000.000',
`created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`status` tinyint(1) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `privileges`
--
CREATE TABLE `privileges` (
`id` smallint(6) UNSIGNED NOT NULL,
`code` varchar(20) NOT NULL,
`name` varchar(30) NOT NULL,
`description` varchar(60) DEFAULT NULL,
`mode` varchar(8) NOT NULL,
`type` varchar(40) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `privileges`
--
INSERT INTO `privileges` (`id`, `code`, `name`, `description`, `mode`, `type`) VALUES
(1, 'manage_users', 'Manage Users', 'Permission to add/edit/delete users', 'manage', 'Users'),
(2, 'manage_files', 'Manage Files', 'Permission to access File Manager', 'manage', 'Files'),
(3, 'manage_pages', 'Manage Pages', 'Permission to Add/edit/delete pages', 'manage', 'Pages'),
(4, 'manage_menus', 'Manage Menus', 'Permission to Add/edit and delete menus', 'manage', 'Menus'),
(5, 'manage_email', 'Manage Email Templates', 'Permission to modify email templates', 'manage', 'Emails'),
(6, 'manage_languages', 'Manage Language Phrases', 'Permission to modify language phrases', 'manage', 'Languages'),
(7, 'manage_backup', 'Manage Database Backups', 'Permission to create backups and restore', 'manage', 'Backups'),
(8, 'manage_memberships', 'Manage Memberships', 'Permission to manage memberships', 'manage', 'Memberships'),
(9, 'edit_user', 'Edit Users', 'Permission to edit user', 'edit', 'Users'),
(10, 'add_user', 'Add User', 'Permission to add users', 'add', 'Users'),
(11, 'delete_user', 'Delete Users', 'Permission to delete users', 'delete', 'Users'),
(12, 'manage_coupons', 'Manage Coupons', 'Permission to Add/Edit and delete coupons', 'manage', 'Coupons'),
(13, 'manage_fields', 'Mange Fileds', 'Permission to Add/edit and delete custom fields', 'manage', 'Fields'),
(14, 'manage_news', 'Manage News', 'Permission to Add/edit and delete news', 'manage', 'News'),
(15, 'manage_newsletter', 'Manage Newsletter', 'Permission to send newsletter and emails', 'manage', 'Newsletter');
-- --------------------------------------------------------
--
-- Table structure for table `roles`
--
CREATE TABLE `roles` (
`id` smallint(4) UNSIGNED NOT NULL,
`code` varchar(10) NOT NULL,
`icon` varchar(20) DEFAULT NULL,
`name` varchar(30) NOT NULL,
`description` varchar(200) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `roles`
--
INSERT INTO `roles` (`id`, `code`, `icon`, `name`, `description`) VALUES
(1, 'owner', 'badge', 'Site Owner', 'Site Owner is the owner of the site, has all privileges and could not be removed.'),
(2, 'staff', 'trophy', 'Staff Member', 'The \"Staff\" members is required to assist the Owner, has different privileges and may be created by Site Owner.'),
(3, 'editor', 'note', 'Editor', 'The "Editor" is required to assist the Staff Members, has different privileges and may be created by Site Owner.');
-- --------------------------------------------------------
--
-- Table structure for table `role_privileges`
--
CREATE TABLE `role_privileges` (
`id` int(11) UNSIGNED NOT NULL,
`rid` int(6) UNSIGNED NOT NULL DEFAULT '0',
`pid` int(6) UNSIGNED NOT NULL DEFAULT '0',
`active` tinyint(1) UNSIGNED NOT NULL DEFAULT '1'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `role_privileges`
--
INSERT INTO `role_privileges` (`id`, `rid`, `pid`, `active`) VALUES
(1, 1, 1, 1),
(2, 2, 1, 1),
(3, 3, 1, 0),
(4, 1, 2, 1),
(5, 2, 2, 1),
(6, 3, 2, 1),
(7, 1, 3, 1),
(8, 2, 3, 1),
(9, 3, 3, 1),
(10, 1, 4, 1),
(11, 2, 4, 1),
(12, 3, 4, 1),
(13, 1, 5, 1),
(14, 2, 5, 1),
(15, 3, 5, 0),
(16, 1, 6, 1),
(17, 2, 6, 1),
(18, 3, 6, 1),
(19, 1, 7, 1),
(20, 2, 7, 1),
(21, 3, 7, 0),
(22, 1, 8, 1),
(23, 2, 8, 1),
(24, 3, 8, 0),
(25, 1, 9, 1),
(26, 2, 9, 1),
(27, 3, 9, 0),
(28, 1, 10, 1),
(29, 2, 10, 1),
(30, 3, 10, 0),
(31, 1, 11, 1),
(32, 2, 11, 1),
(33, 3, 11, 0),
(34, 1, 12, 1),
(35, 2, 12, 1),
(36, 3, 12, 1),
(37, 1, 13, 1),
(38, 2, 13, 1),
(39, 3, 13, 0),
(40, 1, 14, 1),
(41, 2, 14, 1),
(42, 3, 14, 1),
(43, 1, 15, 1),
(44, 2, 15, 1),
(45, 3, 15, 0);
-- --------------------------------------------------------
--
-- Table structure for table `settings`
--
CREATE TABLE `settings` (
`id` tinyint(1) NOT NULL,
`company` varchar(50) NOT NULL,
`site_email` varchar(80) NOT NULL,
`psite_email` varchar(80) DEFAULT NULL,
`site_dir` varchar(100) DEFAULT NULL,
`reg_allowed` tinyint(1) UNSIGNED NOT NULL DEFAULT '1',
`reg_verify` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
`notify_admin` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
`auto_verify` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
`perpage` tinyint(1) UNSIGNED NOT NULL DEFAULT '12',
`backup` varchar(60) DEFAULT NULL,
`logo` varchar(40) DEFAULT NULL,
`plogo` varchar(40) DEFAULT NULL,
`currency` varchar(4) DEFAULT NULL,
`enable_tax` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
`long_date` varchar(50) DEFAULT NULL,
`short_date` varchar(50) DEFAULT NULL,
`time_format` varchar(20) DEFAULT NULL,
`calendar_date` varchar(30) DEFAULT NULL,
`dtz` varchar(80) DEFAULT NULL,
`locale` varchar(20) DEFAULT NULL,
`lang` varchar(20) DEFAULT NULL,
`one_login` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
`weekstart` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
`inv_info` text,
`inv_note` text,
`offline_info` text,
`social_media` blob,
`enable_dmembership` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
`dmembership` smallint(3) UNSIGNED NOT NULL DEFAULT '0',
`file_dir` varchar(100) DEFAULT NULL,
`mailer` enum('SMTP','SMAIL') NOT NULL DEFAULT 'SMTP',
`smtp_host` varchar(100) DEFAULT NULL,
`smtp_user` varchar(50) DEFAULT NULL,
`smtp_pass` varchar(50) DEFAULT NULL,
`smtp_port` varchar(6) DEFAULT NULL,
`is_ssl` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
`sendmail` varchar(150) DEFAULT NULL,
`wojon` decimal(4,2) UNSIGNED NOT NULL DEFAULT '1.00',
`wojov` decimal(4,2) UNSIGNED NOT NULL DEFAULT '1.00'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `settings`
--
INSERT INTO `settings` (`id`, `company`, `site_email`, `psite_email`, `site_dir`, `reg_allowed`, `reg_verify`, `notify_admin`, `auto_verify`, `perpage`, `backup`, `logo`, `plogo`, `currency`, `enable_tax`, `long_date`, `short_date`, `time_format`, `calendar_date`, `dtz`, `locale`, `lang`, `one_login`, `weekstart`, `inv_info`, `inv_note`, `offline_info`, `social_media`, `enable_dmembership`, `dmembership`, `file_dir`, `mailer`, `smtp_host`, `smtp_user`, `smtp_pass`, `smtp_port`, `is_ssl`, `sendmail`, `wojon`, `wojov`) VALUES
(1, 'Jacky\'s Social Badminton Club', 'jacky@jacky.com.my', '', 'member', 1, 1, 0, 0, 12, '', 'print_logo.png', 'print_logo.png', 'MYR', 0, 'MMMM dd, yyyy hh:mm a', 'dd MMM yyyy', 'hh:mm a', 'dd-mm-yyyy', 'America/Toronto', 'en_US', 'en', 0, 1, 'Jacky\'s Social Badminton Club
Puchong Young Sport Center
Tel : (012) 213 2066, Email : jacky@jacky.com.my
Web Site : jacky.com.my
', 'TERMS & CONDITIONS
1. Please make payments earlier so that I don\'t have to chase after you in the courts while you are playing
2. Payments made are not returnable or refundable
', 'Please pay using Touch & Go to 12 2132066 (Kong Pang Yew), and WhatsApp your receipt to 012 213 2066 for confirmation. We will update promptly in the system.
', 0x7b2266616365626f6f6b223a2266616365626f6f6b5f70616765222c2274776974746572223a22747769747465725f70616765227d, 0, 0, '/home/username/downloads/', 'SMTP', 'localhost', 'test', 'test', '465', 1, 'sendmail path', 1.00, 4.61);
-- --------------------------------------------------------
--
-- Table structure for table `trash`
--
CREATE TABLE `trash` (
`id` int(11) UNSIGNED NOT NULL,
`parent` varchar(15) DEFAULT NULL,
`parent_id` int(11) UNSIGNED NOT NULL DEFAULT '0',
`type` varchar(15) DEFAULT NULL,
`dataset` blob,
`created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `users`
--
CREATE TABLE `users` (
`id` int(11) UNSIGNED NOT NULL,
`username` varchar(50) NOT NULL,
`fname` varchar(60) DEFAULT NULL,
`lname` varchar(60) DEFAULT NULL,
`membership_id` int(2) UNSIGNED NOT NULL DEFAULT '0',
`mem_expire` varchar(20) DEFAULT 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',
`sesid` varchar(80) NOT NULL DEFAULT '0',
`type` varchar(10) NOT NULL DEFAULT 'member',
`trial_used` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
`email` varchar(60) NOT NULL,
`lastlogin` datetime DEFAULT NULL,
`lastip` varbinary(16) DEFAULT '000.000.000.000',
`login_info` varchar(150) DEFAULT NULL,
`login_status` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
`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,
`user_files` varchar(150) NOT NULL DEFAULT '0',
`notes` tinytext,
`newsletter` tinyint(1) UNSIGNED NOT NULL DEFAULT '1',
`stripe_cus` varchar(100) DEFAULT NULL,
`stripe_pm` varchar(80) DEFAULT NULL,
`custom_fields` varchar(200) DEFAULT NULL,
`active` enum('y','n','t','b') NOT NULL DEFAULT 'n',
`created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `users`
--
INSERT INTO `users` (`id`, `username`, `fname`, `lname`, `membership_id`, `mem_expire`, `salt`, `hash`, `token`, `userlevel`, `sesid`, `type`, `trial_used`, `email`, `lastlogin`, `lastip`, `login_info`, `login_status`, `avatar`, `address`, `city`, `state`, `zip`, `country`, `user_files`, `notes`, `newsletter`, `stripe_cus`, `stripe_pm`, `custom_fields`, `active`, `created`) VALUES
(1, 'jacky', 'Web', 'Master', 0, NULL, 'x.XHp7AfRyiOeIBW.i0Zs', '$2a$10$x.XHp7AfRyiOeIBW.i0Zs.DneKyIoq13FNVLCNy/82wYAhY1RAJxa', '0', 9, 'b9679b78408070ba704d807a14bdccb537970e78', 'owner', 0, 'jacky@jacky.com.my', '2022-11-29 10:14:46', 0x3138302e37352e3233332e323039, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, 1, NULL, NULL, NULL, 'y', '2022-11-29 15:04:50'),
(2, 'junkai', 'Jun Kai', 'Tan', 0, NULL, 'q0LiZ0m9WmIdZhXVxyFcF', '$2a$10$q0LiZ0m9WmIdZhXVxyFcF.kK8/AN97H4yqyfi2/OtA7fCMfcbpOgm', '8232311', 1, '576f7f8ea673be4b699e8fcfc5f8956a2e331f36', 'member', 0, 'tanjunkai8989@yahoo.com', '2022-12-01 04:57:09', 0x3138302e37352e3233332e323039, NULL, 0, NULL, '', '', '', '', 'CA', '0', '', 1, NULL, NULL, NULL, 'y', '2022-11-29 15:14:21');
-- --------------------------------------------------------
--
-- Table structure for table `user_custom_fields`
--
CREATE TABLE `user_custom_fields` (
`id` int(11) UNSIGNED NOT NULL,
`user_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
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `user_memberships`
--
CREATE TABLE `user_memberships` (
`id` int(11) UNSIGNED NOT NULL,
`tid` int(11) UNSIGNED NOT NULL DEFAULT '0',
`uid` int(11) UNSIGNED NOT NULL DEFAULT '0',
`mid` int(11) UNSIGNED NOT NULL DEFAULT '0',
`activated` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`expire` timestamp NULL DEFAULT NULL,
`recurring` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
`active` tinyint(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT '0 = expired, 1 = active'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `vouchers`
--
CREATE TABLE `vouchers` (
`voucher_id` int(11) NOT NULL,
`website` varchar(30) DEFAULT NULL,
`name` varchar(100) NOT NULL,
`phone` varchar(20) NOT NULL,
`voucher_code` varchar(10) NOT NULL,
`voucher_amount` decimal(15,0) NOT NULL,
`date_created` datetime NOT NULL,
`date_sent` datetime DEFAULT NULL,
`date_used` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `vouchers`
--
INSERT INTO `vouchers` (`voucher_id`, `website`, `name`, `phone`, `voucher_code`, `voucher_amount`, `date_created`, `date_sent`, `date_used`) VALUES
(2, 'jacky', 'Robert', '6012356464', 'BKTV1Y', 5, '2022-11-16 16:51:21', '2022-11-17 06:42:24', NULL),
(3, 'jacky', 'AAA', '0122132066', 'OMQWPG', 2, '2022-11-16 13:58:24', '2022-11-17 06:35:50', '2022-11-22 05:42:42'),
(4, 'jacky', 'AAA', '0122132066', '822MLX', 1, '2022-11-16 16:58:39', NULL, NULL),
(6, 'jacky', 'Andy', '6012235689', '8IHLNF', 4, '2022-11-21 03:31:32', '2022-11-21 03:59:15', NULL),
(7, 'jacky', 'Alex', '60123456789', 'EYMKLW', 8, '2022-11-21 03:53:26', NULL, NULL),
(8, 'jacky', 'Nancy ong', '60122885366', 'VWNPNW', 8, '2022-11-21 05:13:01', NULL, NULL);
--
-- Indexes for dumped tables
--
--
-- Indexes for table `banlist`
--
ALTER TABLE `banlist`
ADD PRIMARY KEY (`id`),
ADD KEY `ban_ip` (`item`);
--
-- Indexes for table `cart`
--
ALTER TABLE `cart`
ADD PRIMARY KEY (`uid`),
ADD KEY `idx_user` (`uid`),
ADD KEY `idx_membership` (`mid`);
--
-- Indexes for table `countries`
--
ALTER TABLE `countries`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `abbrv` (`abbr`);
--
-- Indexes for table `coupons`
--
ALTER TABLE `coupons`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `cronjobs`
--
ALTER TABLE `cronjobs`
ADD PRIMARY KEY (`id`),
ADD KEY `idx_user_id` (`user_id`),
ADD KEY `idx_membership_id` (`membership_id`);
--
-- Indexes for table `custom_fields`
--
ALTER TABLE `custom_fields`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `downloads`
--
ALTER TABLE `downloads`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `email_templates`
--
ALTER TABLE `email_templates`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `gateways`
--
ALTER TABLE `gateways`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `memberships`
--
ALTER TABLE `memberships`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `news`
--
ALTER TABLE `news`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `pages`
--
ALTER TABLE `pages`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `payments`
--
ALTER TABLE `payments`
ADD PRIMARY KEY (`id`),
ADD KEY `idx_membership` (`membership_id`),
ADD KEY `idx_user` (`user_id`);
--
-- Indexes for table `privileges`
--
ALTER TABLE `privileges`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `name` (`name`);
--
-- Indexes for table `roles`
--
ALTER TABLE `roles`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `name` (`name`);
--
-- Indexes for table `role_privileges`
--
ALTER TABLE `role_privileges`
ADD PRIMARY KEY (`id`),
ADD KEY `idx` (`rid`,`pid`);
--
-- Indexes for table `settings`
--
ALTER TABLE `settings`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `trash`
--
ALTER TABLE `trash`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `users`
--
ALTER TABLE `users`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `user_custom_fields`
--
ALTER TABLE `user_custom_fields`
ADD PRIMARY KEY (`id`),
ADD KEY `idx_user` (`user_id`),
ADD KEY `idx_field` (`field_id`);
--
-- Indexes for table `user_memberships`
--
ALTER TABLE `user_memberships`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `vouchers`
--
ALTER TABLE `vouchers`
ADD PRIMARY KEY (`voucher_id`);
--
-- AUTO_INCREMENT for dumped tables
--
--
-- AUTO_INCREMENT for table `banlist`
--
ALTER TABLE `banlist`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `countries`
--
ALTER TABLE `countries`
MODIFY `id` smallint(6) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=238;
--
-- AUTO_INCREMENT for table `coupons`
--
ALTER TABLE `coupons`
MODIFY `id` int(1) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `cronjobs`
--
ALTER TABLE `cronjobs`
MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `custom_fields`
--
ALTER TABLE `custom_fields`
MODIFY `id` int(6) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `downloads`
--
ALTER TABLE `downloads`
MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `email_templates`
--
ALTER TABLE `email_templates`
MODIFY `id` int(5) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;
--
-- AUTO_INCREMENT for table `gateways`
--
ALTER TABLE `gateways`
MODIFY `id` int(4) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;
--
-- AUTO_INCREMENT for table `memberships`
--
ALTER TABLE `memberships`
MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `news`
--
ALTER TABLE `news`
MODIFY `id` int(6) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `pages`
--
ALTER TABLE `pages`
MODIFY `id` int(6) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `payments`
--
ALTER TABLE `payments`
MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `privileges`
--
ALTER TABLE `privileges`
MODIFY `id` smallint(6) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;
--
-- AUTO_INCREMENT for table `roles`
--
ALTER TABLE `roles`
MODIFY `id` smallint(4) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `role_privileges`
--
ALTER TABLE `role_privileges`
MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=46;
--
-- AUTO_INCREMENT for table `settings`
--
ALTER TABLE `settings`
MODIFY `id` tinyint(1) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `trash`
--
ALTER TABLE `trash`
MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `user_custom_fields`
--
ALTER TABLE `user_custom_fields`
MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `user_memberships`
--
ALTER TABLE `user_memberships`
MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `vouchers`
--
ALTER TABLE `vouchers`
MODIFY `voucher_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
COMMIT;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;