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

START TRANSACTION;



--
-- Database: `mydayanas`
--

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

--
-- Table structure for table `comission_setting`
--

CREATE TABLE `comission_setting` (
  `id` int(11) NOT NULL,
  `Type_Of_Comm` varchar(100) DEFAULT NULL,
  `Package_Code` varchar(100) NOT NULL,
  `Package_Name` varchar(100) DEFAULT NULL,
  `Item_Name` varchar(100) DEFAULT NULL,
  `Price` float NOT NULL,
  `Penaja` float DEFAULT NULL,
  `Stokist` float DEFAULT NULL,
  `Keyin` float DEFAULT NULL,
  `Level_1` float DEFAULT NULL,
  `Level_2` float DEFAULT NULL,
  `Level_3` float DEFAULT NULL,
  `Level_4` float DEFAULT NULL,
  `Level_5` float DEFAULT NULL,
  `Level_6` float DEFAULT NULL,
  `Level_7` float DEFAULT NULL,
  `Level_8` float DEFAULT NULL,
  `Level_9` float DEFAULT NULL,
  `Level_10` float DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `created_date` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `comission_setting`
--

INSERT INTO `comission_setting` (`id`, `Type_Of_Comm`, `Package_Code`, `Package_Name`, `Item_Name`, `Price`, `Penaja`, `Stokist`, `Keyin`, `Level_1`, `Level_2`, `Level_3`, `Level_4`, `Level_5`, `Level_6`, `Level_7`, `Level_8`, `Level_9`, `Level_10`, `status`, `created_date`) VALUES
(5, 'Item Commission', '55Rl3fLA', 'PAKEJ RM 10', 'PERFUME 5ml', 10, 0, 1, 1, 0.2, 0.2, 0.2, 0.2, 0.2, 0.1, 0.1, 0.1, 0.1, 0.1, 1, '2020-09-24'),
(6, 'Item Commission', '55234fLB', 'PAKEJ RM 20', 'IRON @SERAI WANGI', 20, 0, 2, 1, 1, 1, 1, 1, 1, 0.5, 0.5, 0.5, 0.5, 0.5, 1, '2020-09-24'),
(7, 'Item Commission', '55234fLC', 'PAKEJ RM 50', '(PERFUME 5ml x5 botol) @ KOPI ZURIAT', 50, 5, 4, 1, 1.5, 1.5, 1.5, 1.5, 1.5, 1, 1, 1, 1, 1, 1, '2020-09-24'),
(8, 'Item Commission', '55234fLD', 'PAKEJ RM 120', 'PERFUME 4mlx24 BOTOL', 120, 10, 12, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 1, '2020-09-24');

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

--
-- Table structure for table `memos`
--

CREATE TABLE `memos` (
  `id` int(11) NOT NULL,
  `memo_title` varchar(100) CHARACTER SET utf8mb4 DEFAULT NULL,
  `memo_input` varchar(500) CHARACTER SET utf8 DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `created_date` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `package_sale`
--

CREATE TABLE `package_sale` (
  `id` int(11) NOT NULL,
  `package_code` varchar(100) NOT NULL,
  `ref_code` varchar(100) NOT NULL,
  `package_name` varchar(100) NOT NULL,
  `package_item_name` varchar(100) NOT NULL,
  `package_price` float NOT NULL,
  `payment_reciept` varchar(100) NOT NULL,
  `remark` varchar(100) NOT NULL,
  `status` int(11) NOT NULL,
  `created_date` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `package_sale`
--

INSERT INTO `package_sale` (`id`, `package_code`, `ref_code`, `package_name`, `package_item_name`, `package_price`, `payment_reciept`, `remark`, `status`, `created_date`) VALUES
(7, '55Rl3fLA', 'azhraf9457', 'PAKEJ RM 10', 'PERFUME 5ml', 10, 'azhraf94571600917530.png', '11111111111111                                         ', 1, '2020-09-24'),
(8, '55234fLB', 'azhraf9457', 'PAKEJ RM 20', 'IRON @SERAI WANGI', 20, 'azhraf94571600923844.JPG', '12122                                                    ', 1, '2020-09-24'),
(9, '55234fLD', 'azhraf9457', 'PAKEJ RM 120', 'PERFUME 4mlx24 BOTOL', 120, 'azhraf94571601338361.JPG', ' Test                                                   ', 1, '2020-09-29'),
(10, '55234fLD', 'azhraf9457', 'PAKEJ RM 120', 'PERFUME 4mlx24 BOTOL', 120, 'azhraf94571601338423.JPG', 'Test                                                    ', 1, '2020-09-29'),
(11, '55Rl3fLA', 'sofea@8789', 'PAKEJ RM 10', 'PERFUME 5ml', 10, 'sofea@87891601362266.JPG', '  Purchase                                                  ', 0, '2020-09-29'),
(12, '55Rl3fLA', 'babu@g8308', 'PAKEJ RM 10', 'PERFUME 5ml', 10, 'babu@g83081601378085.JPG', '  Pay                                                  ', 1, '2020-09-29'),
(13, '55234fLB', 'babu@g8308', 'PAKEJ RM 20', 'IRON @SERAI WANGI', 20, 'babu@g83081601378331.JPG', ' 111                                                   ', 1, '2020-09-29'),
(14, '55Rl3fLA', 'babu@g8308', 'PAKEJ RM 10', 'PERFUME 5ml', 10, 'babu@g83081601378634.JPG', '  111                                                  ', 1, '2020-09-29'),
(15, '55Rl3fLA', 'babu@g8308', 'PAKEJ RM 10', 'PERFUME 5ml', 10, 'babu@g83081601393388.JPG', ' 123                                                   ', 1, '2020-09-29'),
(16, '55234fLB', 'Level15188', 'PAKEJ RM 20', 'IRON @SERAI WANGI', 20, 'Level151881601441085.jpeg', ' Iron                                                   ', 1, '2020-09-30'),
(17, '55234fLC', 'Level15188', 'PAKEJ RM 50', '(PERFUME 5ml x5 botol) @ KOPI ZURIAT', 50, 'Level151881601441547.jpeg', '  11111                                                  ', 1, '2020-09-30');

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

--
-- Table structure for table `transactions`
--

CREATE TABLE `transactions` (
  `id` int(11) NOT NULL,
  `user_ref_code` varchar(100) DEFAULT NULL,
  `trans_code` varchar(100) DEFAULT NULL,
  `type_of_transaction` varchar(10) DEFAULT NULL,
  `in_transactions` float DEFAULT NULL,
  `out_transactions` float DEFAULT NULL,
  `balance` float DEFAULT NULL,
  `description` varchar(1000) DEFAULT NULL,
  `withdraw` int(11) DEFAULT NULL,
  `redeem` int(11) DEFAULT NULL,
  `redeem_product` varchar(100) DEFAULT NULL,
  `redeem_product_description` varchar(100) DEFAULT NULL,
  `full_name` varchar(100) DEFAULT NULL,
  `country` varchar(100) DEFAULT NULL,
  `state` varchar(100) DEFAULT NULL,
  `city` varchar(100) DEFAULT NULL,
  `postcode` varchar(100) DEFAULT NULL,
  `shipment_address` varchar(200) DEFAULT NULL,
  `withdraw_status` text,
  `redeem_status` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `created_date` date DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_date` date DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `transactions`
--

INSERT INTO `transactions` (`id`, `user_ref_code`, `trans_code`, `type_of_transaction`, `in_transactions`, `out_transactions`, `balance`, `description`, `withdraw`, `redeem`, `redeem_product`, `redeem_product_description`, `full_name`, `country`, `state`, `city`, `postcode`, `shipment_address`, `withdraw_status`, `redeem_status`, `status`, `created_date`, `created_by`, `updated_date`, `updated_by`) VALUES
(20, 'alias@7839', 'PJXlbWp8', 'CW', 2, 0, 30.31, 'Keyin Commission For New Agent Alias | 01113123323 ', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, 1, '2020-09-29', NULL, NULL, NULL),
(21, 'azhraf9457', 'tpfiEuga', 'CW', 2, 0, 32.31, 'Penaja Commission RM 10 For New Agent tyqa | 1312531231 ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2020-09-29', NULL, NULL, NULL),
(22, 'azhraf9457', '5BjUdPEp', 'CW', 2, 0, 34.31, 'Keyin Commission RM 2 For New Agent tyqa | 1312531231 ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2020-09-29', NULL, NULL, NULL),
(23, 'azhraf9457', 'Mtsa2hSx', 'CW', 10, 0, 44.31, 'Penaja Commission RM 10 For New Agent tyqa1 | 121242541111 ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2020-09-29', NULL, NULL, NULL),
(24, 'azhraf9457', 'jgnbB3Gt', 'CW', 2, 0, 46.31, 'Keyin Commission RM 2 For New Agent tyqa1 | 121242541111 ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2020-09-29', NULL, NULL, NULL),
(25, 'sofea@8789', '6coXYiET', 'CW', 0, 0, 0, 'Penaja Commission RM  For New Agent a | 1312323 ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2020-09-29', NULL, NULL, NULL),
(26, 'azhraf9457', 'zeNp7QO5', 'CW', 2, 0, 48.31, 'Keyin Commission RM 2 For New Agent a | 1312323 ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2020-09-29', NULL, NULL, NULL),
(27, 'sofea@8789', 'suNPDUHG', 'CW', 0, 0, 0, 'Penaja Commission RM 0 For New Agent b | 123331 ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2020-09-29', NULL, NULL, NULL),
(28, 'azhraf9457', '2wO11Lf4', 'CW', 2, 0, 50.31, 'Keyin Commission RM 2 For New Agent b | 123331 ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2020-09-29', NULL, NULL, NULL),
(29, 'azhraf9457', 'U5bdz6Jg', 'CW', 0, 0.31, 50, 'Withdraw RM 0.31 ', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, 1, '2020-09-29', NULL, NULL, NULL),
(30, 'azhraf9457', 'lbCsRnmt', 'CW', 0, 5, 45, 'Transfer RM 5 To sofea@8789', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, 1, '2020-09-29', NULL, NULL, NULL),
(31, 'sofea@8789', 'lbCsRnmt', 'CW', 5, 0, 45, 'Receive RM 5 from azhraf9457', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, 1, '2020-09-29', NULL, NULL, NULL),
(32, 'sofea@8789', 'DRLyIl3z', 'CW', 0, 1, 4, 'Transfer RM 1 To sofea@8760', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, 1, '2020-09-29', NULL, NULL, NULL),
(33, 'sofea@8760', 'DRLyIl3z', 'CW', 1, 0, 4, 'Receive RM 1 from sofea@8789', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, 1, '2020-09-29', NULL, NULL, NULL),
(34, 'sofea@8789', 'tfFJtoq1', 'CW', 0, 1, 3, 'Transfer RM 1 To sofea@8760', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, 1, '2020-09-29', NULL, NULL, NULL),
(35, 'sofea@8760', 'tfFJtoq1', 'CW', 1, 0, 2, 'Receive RM 1 from sofea@8789', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, 1, '2020-09-29', NULL, NULL, NULL),
(36, 'sofea@8789', 'X17qonhf', 'CW', 0, 1, 2, 'Withdraw RM 1 ', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, 1, '2020-09-29', NULL, NULL, NULL),
(37, 'babu@g8308', '', 'CW', 10, 0, 55, 'Commission RM  For Your Downline Purchase  () ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2020-09-29', NULL, NULL, NULL),
(38, 'azhraf9457', 'IUEQEHLs', 'CW', 20, 0, 75, 'Commission RM 20 For Your Downline Purchase PAKEJ RM 20 (IRON @SERAI WANGI) ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2020-09-29', NULL, NULL, NULL),
(39, 'azhraf9457', 'pwknPpHJ', 'CW', 10, 0, 85, 'Commission RM 10 For Your Direct Downline babu | 133312 Purchase PAKEJ RM 10 (PERFUME 5ml) ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2020-09-29', NULL, NULL, NULL),
(40, 'azhraf9457', 'dCes3FAH', 'CW', 10, 0, 95, 'Commission RM 10 For Your Direct Downline babu | 133312 Purchase PAKEJ RM 10 (PERFUME 5ml) ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2020-09-29', NULL, NULL, NULL),
(41, 'azhraf9457', NULL, 'CW', 0.2, 0, 95.2, 'Level 1 Commission RM  For Your Direct Downline babu | 133312 Purchase PAKEJ RM 10 (PERFUME 5ml) ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2020-09-29', NULL, NULL, NULL),
(42, 'babu@g8308', 'wc7TKOYS', 'CW', 0, 0, 0, 'Penaja Commission RM 0 For New Agent Level2 | 131233314 ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2020-09-30', NULL, NULL, NULL),
(43, 'Level29964', 'pFOjF5lN', 'CW', 0, 0, 0, 'Penaja Commission RM 0 For New Agent Level3 | 1312333141 ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2020-09-30', NULL, NULL, NULL),
(44, 'Level3214', 'tyHKmDrK', 'CW', 0, 0, 0, 'Penaja Commission RM 0 For New Agent Level4 | 1312333144 ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2020-09-30', NULL, NULL, NULL),
(45, 'Level41270', 'n0pbhSPF', 'CW', 0, 0, 0, 'Penaja Commission RM 0 For New Agent Level5 | 1312333145 ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2020-09-30', NULL, NULL, NULL),
(46, 'Level51511', '5SrGBcQs', 'CW', 0, 0, 0, 'Penaja Commission RM 0 For New Agent Level6 | 1312333146 ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2020-09-30', NULL, NULL, NULL),
(47, 'Level62633', 'aLl7iKXq', 'CW', 0, 0, 0, 'Penaja Commission RM 0 For New Agent Level7 | 1312333147 ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2020-09-30', NULL, NULL, NULL),
(48, 'Level73688', 'EXBBLez6', 'CW', 0, 0, 0, 'Penaja Commission RM 0 For New Agent Level8 | 1312333148 ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2020-09-30', NULL, NULL, NULL),
(49, 'Level88479', 'filx0NZN', 'CW', 0, 0, 0, 'Penaja Commission RM 0 For New Agent Level9 | 1312333149 ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2020-09-30', NULL, NULL, NULL),
(50, 'Level99842', 'rZfIyEC2', 'CW', 0, 0, 0, 'Penaja Commission RM 0 For New Agent Level10 | 13123331410 ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2020-09-30', NULL, NULL, NULL),
(51, 'Level99842', 'gZAMFYB0', 'CW', 20, 0, 20, 'Commission RM 20 For Your Direct Downline Level10 | 13123331410 Purchase PAKEJ RM 20 (IRON @SERAI WANGI) ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2020-09-30', NULL, NULL, NULL),
(52, 'Level99842', NULL, 'CW', 1, 0, 21, 'Level 1 Commission RM 1 For Your Direct Downline Level10 | 13123331410 Purchase PAKEJ RM 20 (IRON @SERAI WANGI) ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2020-09-30', NULL, NULL, NULL),
(53, 'Level88479', NULL, 'CW', 1, 0, 1, 'Level 1 Commission RM 1 For Your Direct Downline Level10 | 13123331410 Purchase PAKEJ RM 20 (IRON @SERAI WANGI) ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2020-09-30', NULL, NULL, NULL),
(54, 'Level73688', NULL, 'CW', 1, 0, 1, 'Level 1 Commission RM 1 For Your Direct Downline Level10 | 13123331410 Purchase PAKEJ RM 20 (IRON @SERAI WANGI) ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2020-09-30', NULL, NULL, NULL),
(55, 'Level62633', NULL, 'CW', 1, 0, 1, 'Level 1 Commission RM 1 For Your Direct Downline Level10 | 13123331410 Purchase PAKEJ RM 20 (IRON @SERAI WANGI) ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2020-09-30', NULL, NULL, NULL),
(56, 'Level51511', NULL, 'CW', 1, 0, 1, 'Level 1 Commission RM 1 For Your Direct Downline Level10 | 13123331410 Purchase PAKEJ RM 20 (IRON @SERAI WANGI) ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2020-09-30', NULL, NULL, NULL),
(57, 'Level41270', NULL, 'CW', 0.5, 0, 0.5, 'Level 1 Commission RM 0.5 For Your Direct Downline Level10 | 13123331410 Purchase PAKEJ RM 20 (IRON @SERAI WANGI) ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2020-09-30', NULL, NULL, NULL),
(58, 'Level3214', NULL, 'CW', 0.5, 0, 0.5, 'Level 1 Commission RM 0.5 For Your Direct Downline Level10 | 13123331410 Purchase PAKEJ RM 20 (IRON @SERAI WANGI) ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2020-09-30', NULL, NULL, NULL),
(59, 'Level29964', NULL, 'CW', 0.5, 0, 0.5, 'Level 1 Commission RM 0.5 For Your Direct Downline Level10 | 13123331410 Purchase PAKEJ RM 20 (IRON @SERAI WANGI) ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2020-09-30', NULL, NULL, NULL),
(60, 'babu@g8308', NULL, 'CW', 0.5, 0, 0.5, 'Level 1 Commission RM 0.5 For Your Direct Downline Level10 | 13123331410 Purchase PAKEJ RM 20 (IRON @SERAI WANGI) ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2020-09-30', NULL, NULL, NULL),
(61, 'azhraf9457', NULL, 'CW', 0.5, 0, 95.7, 'Level 1 Commission RM 0.5 For Your Direct Downline Level10 | 13123331410 Purchase PAKEJ RM 20 (IRON @SERAI WANGI) ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2020-09-30', NULL, NULL, NULL),
(62, 'Level99842', 'DIGjEbIB', 'CW', 50, 0, 71, 'Commission RM 50 For Your Direct Downline Level10 | 13123331410 Purchase PAKEJ RM 50 ((PERFUME 5ml x5 botol) @ KOPI ZURIAT) ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2020-09-30', NULL, NULL, NULL),
(63, 'Level99842', NULL, 'CW', 1.5, 0, 72.5, 'Level 1 Commission RM 1.5 For Your Direct Downline Level10 | 13123331410 Purchase PAKEJ RM 50 ((PERFUME 5ml x5 botol) @ KOPI ZURIAT) ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2020-09-30', NULL, NULL, NULL),
(64, 'Level88479', NULL, 'CW', 1.5, 0, 2.5, 'Level 2 Commission RM 1.5 For Your Direct Downline Level10 | 13123331410 Purchase PAKEJ RM 50 ((PERFUME 5ml x5 botol) @ KOPI ZURIAT) ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2020-09-30', NULL, NULL, NULL),
(65, 'Level73688', NULL, 'CW', 1.5, 0, 2.5, 'Level 3 Commission RM 1.5 For Your Direct Downline Level10 | 13123331410 Purchase PAKEJ RM 50 ((PERFUME 5ml x5 botol) @ KOPI ZURIAT) ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2020-09-30', NULL, NULL, NULL),
(66, 'Level62633', NULL, 'CW', 1.5, 0, 2.5, 'Level 4 Commission RM 1.5 For Your Direct Downline Level10 | 13123331410 Purchase PAKEJ RM 50 ((PERFUME 5ml x5 botol) @ KOPI ZURIAT) ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2020-09-30', NULL, NULL, NULL),
(67, 'Level51511', NULL, 'CW', 1.5, 0, 2.5, 'Level 5 Commission RM 1.5 For Your Direct Downline Level10 | 13123331410 Purchase PAKEJ RM 50 ((PERFUME 5ml x5 botol) @ KOPI ZURIAT) ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2020-09-30', NULL, NULL, NULL),
(68, 'Level41270', NULL, 'CW', 1, 0, 1.5, 'Level 6 Commission RM 1 For Your Direct Downline Level10 | 13123331410 Purchase PAKEJ RM 50 ((PERFUME 5ml x5 botol) @ KOPI ZURIAT) ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2020-09-30', NULL, NULL, NULL),
(69, 'Level3214', NULL, 'CW', 1, 0, 1.5, 'Level 7 Commission RM 1 For Your Direct Downline Level10 | 13123331410 Purchase PAKEJ RM 50 ((PERFUME 5ml x5 botol) @ KOPI ZURIAT) ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2020-09-30', NULL, NULL, NULL),
(70, 'Level29964', NULL, 'CW', 1, 0, 1.5, 'Level 8 Commission RM 1 For Your Direct Downline Level10 | 13123331410 Purchase PAKEJ RM 50 ((PERFUME 5ml x5 botol) @ KOPI ZURIAT) ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2020-09-30', NULL, NULL, NULL),
(71, 'babu@g8308', NULL, 'CW', 1, 0, 1.5, 'Level 9 Commission RM 1 For Your Direct Downline Level10 | 13123331410 Purchase PAKEJ RM 50 ((PERFUME 5ml x5 botol) @ KOPI ZURIAT) ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2020-09-30', NULL, NULL, NULL),
(72, 'azhraf9457', NULL, 'CW', 1, 0, 96.7, 'Level 10 Commission RM 1 For Your Direct Downline Level10 | 13123331410 Purchase PAKEJ RM 50 ((PERFUME 5ml x5 botol) @ KOPI ZURIAT) ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2020-09-30', NULL, NULL, NULL);

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

--
-- Table structure for table `user_commission`
--

CREATE TABLE `user_commission` (
  `id` int(11) NOT NULL,
  `type_of_commission` varchar(100) NOT NULL,
  `ref_code` varchar(100) NOT NULL,
  `order_id` varchar(100) DEFAULT NULL,
  `billing_email` varchar(100) DEFAULT NULL,
  `order_total` varchar(100) DEFAULT NULL,
  `percent_commission` varchar(100) NOT NULL,
  `order_commission` varchar(100) DEFAULT NULL,
  `paid_date` datetime DEFAULT NULL,
  `order_items` varchar(500) DEFAULT NULL,
  `descriptions` varchar(300) NOT NULL,
  `status` int(11) DEFAULT NULL,
  `created_date` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `user_commission`
--

INSERT INTO `user_commission` (`id`, `type_of_commission`, `ref_code`, `order_id`, `billing_email`, `order_total`, `percent_commission`, `order_commission`, `paid_date`, `order_items`, `descriptions`, `status`, `created_date`) VALUES
(13, '', '', '291', 'azhrafalias55@gmail.com', '1.00', '0.2', '0.2', '0000-00-00 00:00:00', 'Long Sleeve Ice Silk Pyjamas', '', 1, '2020-08-08'),
(14, '', '', '292', 'azhrafalias55@gmail.com', '1.00', '0.2', '0.2', '2020-08-06 23:27:52', 'Long Sleeve Ice Silk Pyjamas', '', 1, '2020-08-08'),
(15, '', '', '302', 'azhrafalias55@gmail.com', '1.00', '0.2', '0.2', '2020-08-07 14:41:11', 'Long Sleeve Ice Silk Pyjamas', '', 1, '2020-08-08'),
(16, 'sponsor', 'liza@g233', NULL, NULL, NULL, '0.2', '167.4', NULL, NULL, 'Commission For Membership Upgrade To Premiun Membership By Your Level 1 Downline rohani@gmail.com | rohani', 0, '2020-08-09'),
(17, 'sponsor', 'akim@g6314', NULL, NULL, NULL, '0.15', '125.55', NULL, NULL, 'Commission For Membership Upgrade To Premiun Membership By Your Level 2 Downline rohani@gmail.com | rohani', 0, '2020-08-09'),
(18, 'sponsor', 'abu@gm4553', NULL, NULL, NULL, '0.1', '83.7', NULL, NULL, 'Commission For Membership Upgrade To Premiun Membership By Your Level 3 Downline rohani@gmail.com | rohani', 0, '2020-08-09'),
(19, 'sponsor', 'ali897#D', NULL, NULL, NULL, '0.05', '41.85', NULL, NULL, 'Commission For Membership Upgrade To Premiun Membership By Your Level 4 Downline rohani@gmail.com | rohani', 0, '2020-08-09'),
(20, 'sponsor', 'liza@g233', NULL, NULL, NULL, '0.2', '167.4', NULL, NULL, 'Commission For Membership Upgrade To Premiun Membership By Your Level 1 Downline rohani@gmail.com | rohani', 0, '2020-08-09'),
(21, 'sponsor', 'akim@g6314', NULL, NULL, NULL, '0.15', '125.55', NULL, NULL, 'Commission For Membership Upgrade To Premiun Membership By Your Level 2 Downline rohani@gmail.com | rohani', 0, '2020-08-09'),
(22, 'sponsor', 'abu@gm4553', NULL, NULL, NULL, '0.1', '83.7', NULL, NULL, 'Commission For Membership Upgrade To Premiun Membership By Your Level 3 Downline rohani@gmail.com | rohani', 0, '2020-08-09'),
(23, 'sponsor', 'ali897#D', NULL, NULL, NULL, '0.05', '41.85', NULL, NULL, 'Commission For Membership Upgrade To Premiun Membership By Your Level 4 Downline rohani@gmail.com | rohani', 0, '2020-08-09'),
(24, 'sponsor', 'liza@g233', NULL, NULL, NULL, '0.2', '167.4', NULL, NULL, 'Commission For Membership Upgrade To Premiun Membership By Your Level 1 Downline rohani@gmail.com | rohani', 0, '2020-08-09'),
(25, 'sponsor', 'akim@g6314', NULL, NULL, NULL, '0.15', '125.55', NULL, NULL, 'Commission For Membership Upgrade To Premiun Membership By Your Level 2 Downline rohani@gmail.com | rohani', 0, '2020-08-09'),
(26, 'sponsor', 'abu@gm4553', NULL, NULL, NULL, '0.1', '83.7', NULL, NULL, 'Commission For Membership Upgrade To Premiun Membership By Your Level 3 Downline rohani@gmail.com | rohani', 0, '2020-08-09'),
(27, 'sponsor', 'ali897#D', NULL, NULL, NULL, '0.05', '41.85', NULL, NULL, 'Commission For Membership Upgrade To Premiun Membership By Your Level 4 Downline rohani@gmail.com | rohani', 0, '2020-08-09'),
(28, 'sponsor', 'liza@g233', NULL, NULL, NULL, '0.2', '167.4', NULL, NULL, 'Commission For Membership Upgrade To Premiun Membership By Your Level 1 Downline rohani@gmail.com | rohani', 0, '2020-08-09'),
(29, 'sponsor', 'akim@g6314', NULL, NULL, NULL, '0.15', '125.55', NULL, NULL, 'Commission For Membership Upgrade To Premiun Membership By Your Level 2 Downline rohani@gmail.com | rohani', 0, '2020-08-09'),
(30, 'sponsor', 'abu@gm4553', NULL, NULL, NULL, '0.1', '83.7', NULL, NULL, 'Commission For Membership Upgrade To Premiun Membership By Your Level 3 Downline rohani@gmail.com | rohani', 0, '2020-08-09'),
(31, 'sponsor', 'azhraf9457', NULL, NULL, NULL, '0.05', '41.85', NULL, NULL, 'Commission For Membership Upgrade To Premiun Membership By Your Level 4 Downline rohani@gmail.com | rohani', 0, '2020-08-09'),
(32, 'sponsor', 'liza@g233', NULL, NULL, NULL, '0.2', '167.4', NULL, NULL, 'Commission For Membership Upgrade To Premiun Membership By Your Level 1 Downline rohani@gmail.com | rohani', 1, '2020-08-09'),
(33, 'sponsor', 'akim@g6314', NULL, NULL, NULL, '0.15', '125.55', NULL, NULL, 'Commission For Membership Upgrade To Premiun Membership By Your Level 2 Downline rohani@gmail.com | rohani', 1, '2020-08-09'),
(34, 'sponsor', 'abu@gm4553', NULL, NULL, NULL, '0.1', '83.7', NULL, NULL, 'Commission For Membership Upgrade To Premiun Membership By Your Level 3 Downline rohani@gmail.com | rohani', 1, '2020-08-09'),
(35, 'sponsor', 'azhraf9457', NULL, NULL, NULL, '0.05', '41.85', NULL, NULL, 'Commission For Membership Upgrade To Premiun Membership By Your Level 4 Downline rohani@gmail.com | rohani', 1, '2020-08-09'),
(36, 'sponsor', '', NULL, NULL, NULL, '0.2', '0.2', NULL, NULL, 'Commission For Membership Upgrade To Premiun Membership By Your Level 1 Downline pakarbinawebsite@gmail.com | Ashraf', 1, '2020-08-12'),
(37, 'sponsor', '', NULL, NULL, NULL, '0.15', '0.15', NULL, NULL, 'Commission For Membership Upgrade To Premiun Membership By Your Level 2 Downline pakarbinawebsite@gmail.com | Ashraf', 1, '2020-08-12'),
(38, 'sponsor', '', NULL, NULL, NULL, '0.1', '0.1', NULL, NULL, 'Commission For Membership Upgrade To Premiun Membership By Your Level 3 Downline pakarbinawebsite@gmail.com | Ashraf', 1, '2020-08-12'),
(39, 'sponsor', '', NULL, NULL, NULL, '0.05', '0.05', NULL, NULL, 'Commission For Membership Upgrade To Premiun Membership By Your Level 4 Downline pakarbinawebsite@gmail.com | Ashraf', 1, '2020-08-12'),
(40, 'sponsor', '', NULL, NULL, NULL, '0.2', '0.2', NULL, NULL, 'Commission For Membership Upgrade To Premiun Membership By Your Level 1 Downline pakarbinawebsite@gmail.com | Ashraf', 1, '2020-08-12'),
(41, 'sponsor', '', NULL, NULL, NULL, '0.15', '0.15', NULL, NULL, 'Commission For Membership Upgrade To Premiun Membership By Your Level 2 Downline pakarbinawebsite@gmail.com | Ashraf', 1, '2020-08-12'),
(42, 'sponsor', '', NULL, NULL, NULL, '0.1', '0.1', NULL, NULL, 'Commission For Membership Upgrade To Premiun Membership By Your Level 3 Downline pakarbinawebsite@gmail.com | Ashraf', 1, '2020-08-12'),
(43, 'sponsor', '', NULL, NULL, NULL, '0.05', '0.05', NULL, NULL, 'Commission For Membership Upgrade To Premiun Membership By Your Level 4 Downline pakarbinawebsite@gmail.com | Ashraf', 1, '2020-08-12'),
(44, 'sponsor', '', NULL, NULL, NULL, '0.2', '0.2', NULL, NULL, 'Commission For Membership Upgrade To Premiun Membership By Your Level 1 Downline pakarbinawebsite@gmail.com | Ashraf', 1, '2020-08-12'),
(45, 'sponsor', '', NULL, NULL, NULL, '0.15', '0.15', NULL, NULL, 'Commission For Membership Upgrade To Premiun Membership By Your Level 2 Downline pakarbinawebsite@gmail.com | Ashraf', 1, '2020-08-12'),
(46, 'sponsor', '', NULL, NULL, NULL, '0.1', '0.1', NULL, NULL, 'Commission For Membership Upgrade To Premiun Membership By Your Level 3 Downline pakarbinawebsite@gmail.com | Ashraf', 1, '2020-08-12'),
(47, 'sponsor', '', NULL, NULL, NULL, '0.05', '0.05', NULL, NULL, 'Commission For Membership Upgrade To Premiun Membership By Your Level 4 Downline pakarbinawebsite@gmail.com | Ashraf', 1, '2020-08-12'),
(48, 'sponsor', 'aype.r8114', NULL, NULL, NULL, '0.2', '440', NULL, NULL, 'Commission For Membership Upgrade To Premiun Membership By Your Level 1 Downline ningkanmanggai2020@gmail.com | Ningkan Anak Manggai', 1, '2020-08-17'),
(49, 'sponsor', 'rzwnrm4322', NULL, NULL, NULL, '0.15', '330', NULL, NULL, 'Commission For Membership Upgrade To Premiun Membership By Your Level 2 Downline ningkanmanggai2020@gmail.com | Ningkan Anak Manggai', 1, '2020-08-17'),
(50, 'sponsor', 'AdminMB2U', NULL, NULL, NULL, '0.1', '220', NULL, NULL, 'Commission For Membership Upgrade To Premiun Membership By Your Level 3 Downline ningkanmanggai2020@gmail.com | Ningkan Anak Manggai', 1, '2020-08-17'),
(51, 'sponsor', '', NULL, NULL, NULL, '0.05', '110', NULL, NULL, 'Commission For Membership Upgrade To Premiun Membership By Your Level 4 Downline ningkanmanggai2020@gmail.com | Ningkan Anak Manggai', 1, '2020-08-17'),
(52, 'sponsor', 'ningka4695', NULL, NULL, NULL, '0.2', '440', NULL, NULL, 'Commission For Membership Upgrade To Premiun Membership By Your Level 1 Downline joanalion1997@gmail.com | Joana Wik Anak Ningkan', 1, '2020-08-19'),
(53, 'sponsor', 'aype.r8114', NULL, NULL, NULL, '0.15', '330', NULL, NULL, 'Commission For Membership Upgrade To Premiun Membership By Your Level 2 Downline joanalion1997@gmail.com | Joana Wik Anak Ningkan', 1, '2020-08-19'),
(54, 'sponsor', 'rzwnrm4322', NULL, NULL, NULL, '0.1', '220', NULL, NULL, 'Commission For Membership Upgrade To Premiun Membership By Your Level 3 Downline joanalion1997@gmail.com | Joana Wik Anak Ningkan', 1, '2020-08-19'),
(55, 'sponsor', 'AdminMB2U', NULL, NULL, NULL, '0.05', '110', NULL, NULL, 'Commission For Membership Upgrade To Premiun Membership By Your Level 4 Downline joanalion1997@gmail.com | Joana Wik Anak Ningkan', 1, '2020-08-19'),
(56, 'sponsor', '', NULL, NULL, NULL, '0.2', '440', NULL, NULL, 'Commission For Membership Upgrade To Premiun Membership By Your Level 1 Downline fizam@gmail.com | fizam', 1, '2020-08-20'),
(57, 'sponsor', '', NULL, NULL, NULL, '0.15', '330', NULL, NULL, 'Commission For Membership Upgrade To Premiun Membership By Your Level 2 Downline fizam@gmail.com | fizam', 1, '2020-08-20'),
(58, 'sponsor', '', NULL, NULL, NULL, '0.1', '220', NULL, NULL, 'Commission For Membership Upgrade To Premiun Membership By Your Level 3 Downline fizam@gmail.com | fizam', 1, '2020-08-20'),
(59, 'sponsor', '', NULL, NULL, NULL, '0.05', '110', NULL, NULL, 'Commission For Membership Upgrade To Premiun Membership By Your Level 4 Downline fizam@gmail.com | fizam', 1, '2020-08-20'),
(60, 'sponsor', 'joanal5670', NULL, NULL, NULL, '0.2', '440', NULL, NULL, 'Commission For Membership Upgrade To Premiun Membership By Your Level 1 Downline fizam@gmail.com | fizam', 1, '2020-08-20'),
(61, 'sponsor', 'ningka4695', NULL, NULL, NULL, '0.15', '330', NULL, NULL, 'Commission For Membership Upgrade To Premiun Membership By Your Level 2 Downline fizam@gmail.com | fizam', 1, '2020-08-20'),
(62, 'sponsor', 'aype.r8114', NULL, NULL, NULL, '0.1', '220', NULL, NULL, 'Commission For Membership Upgrade To Premiun Membership By Your Level 3 Downline fizam@gmail.com | fizam', 1, '2020-08-20'),
(63, 'sponsor', 'rzwnrm4322', NULL, NULL, NULL, '0.05', '110', NULL, NULL, 'Commission For Membership Upgrade To Premiun Membership By Your Level 4 Downline fizam@gmail.com | fizam', 1, '2020-08-20'),
(64, '', 'pakarb8038 ', NULL, NULL, NULL, '0.2', '0', NULL, NULL, 'Commission For Membership Upgrade To Premiun Membership By Your Level 1 Downline  | ', 0, '0000-00-00'),
(65, '', 'AdminMB2U', NULL, NULL, NULL, '0.15', '0', NULL, NULL, 'Commission For Membership Upgrade To Premiun Membership By Your Level 2 Downline  | ', 0, '0000-00-00'),
(66, '', '', NULL, NULL, NULL, '0.1', '0', NULL, NULL, 'Commission For Membership Upgrade To Premiun Membership By Your Level 3 Downline  | ', 0, '0000-00-00'),
(67, '', '', NULL, NULL, NULL, '0.05', '0', NULL, NULL, 'Commission For Membership Upgrade To Premiun Membership By Your Level 4 Downline  | ', 0, '0000-00-00'),
(68, '', 'pakarb8038 ', NULL, NULL, NULL, '0.2', '0', NULL, NULL, 'Commission For Membership Upgrade To Premiun Membership By Your Level 1 Downline  | ', 0, '0000-00-00'),
(69, '', 'AdminMB2U', NULL, NULL, NULL, '0.15', '0', NULL, NULL, 'Commission For Membership Upgrade To Premiun Membership By Your Level 2 Downline  | ', 0, '0000-00-00'),
(70, '', '', NULL, NULL, NULL, '0.1', '0', NULL, NULL, 'Commission For Membership Upgrade To Premiun Membership By Your Level 3 Downline  | ', 0, '0000-00-00'),
(71, '', '', NULL, NULL, NULL, '0.05', '0', NULL, NULL, 'Commission For Membership Upgrade To Premiun Membership By Your Level 4 Downline  | ', 0, '0000-00-00'),
(72, '', 'pakarb8038 ', NULL, NULL, NULL, '0.2', '440', NULL, NULL, 'Commission For Membership Upgrade To Premiun Membership By Your Level 1 Downline  | ', 0, '0000-00-00'),
(73, '', 'AdminMB2U', NULL, NULL, NULL, '0.15', '330', NULL, NULL, 'Commission For Membership Upgrade To Premiun Membership By Your Level 2 Downline  | ', 0, '0000-00-00'),
(74, '', '', NULL, NULL, NULL, '0.1', '220', NULL, NULL, 'Commission For Membership Upgrade To Premiun Membership By Your Level 3 Downline  | ', 0, '0000-00-00'),
(75, '', '', NULL, NULL, NULL, '0.05', '110', NULL, NULL, 'Commission For Membership Upgrade To Premiun Membership By Your Level 4 Downline  | ', 0, '0000-00-00'),
(76, '', 'joanal5670 ', NULL, NULL, NULL, '0.2', '440', NULL, NULL, 'Commission For Membership Upgrade To Premiun Membership By Your Level 1 Downline  | ', 0, '0000-00-00'),
(77, '', 'ningka4695', NULL, NULL, NULL, '0.15', '330', NULL, NULL, 'Commission For Membership Upgrade To Premiun Membership By Your Level 2 Downline  | ', 0, '0000-00-00'),
(78, '', 'aype.r8114', NULL, NULL, NULL, '0.1', '220', NULL, NULL, 'Commission For Membership Upgrade To Premiun Membership By Your Level 3 Downline  | ', 0, '0000-00-00'),
(79, '', 'rzwnrm4322', NULL, NULL, NULL, '0.05', '110', NULL, NULL, 'Commission For Membership Upgrade To Premiun Membership By Your Level 4 Downline  | ', 0, '0000-00-00');

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

--
-- Table structure for table `video_comment`
--

CREATE TABLE `video_comment` (
  `id` int(11) NOT NULL,
  `video_id` int(11) DEFAULT NULL,
  `ref_code` varchar(100) DEFAULT NULL,
  `comment_info` varchar(100) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `created_date` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `video_comment`
--

INSERT INTO `video_comment` (`id`, `video_id`, `ref_code`, `comment_info`, `status`, `created_date`) VALUES
(1, 17, 'azhraf9457', 'Test 123', 1, '2020-08-25'),
(2, 17, 'azhraf9457', 'Test 456', 1, '2020-08-25'),
(3, 17, 'azhraf9457', 'Test 789', 1, '2020-08-25'),
(4, 15, 'azhraf9457', 'Test 123', 1, '2020-08-25'),
(5, 19, 'azhraf9457', 'Test', 1, '2020-08-28'),
(6, 16, 'azhraf9457', '1333', 1, '2020-09-10'),
(7, 20, 'azhraf9457', 'Niceee', 1, '2020-09-10');

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

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

CREATE TABLE `video_like` (
  `id` int(11) NOT NULL,
  `video_id` int(11) DEFAULT NULL,
  `ref_code` varchar(100) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `created_date` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `video_like`
--

INSERT INTO `video_like` (`id`, `video_id`, `ref_code`, `status`, `created_date`) VALUES
(1, 19, 'azhraf9457', 1, '0000-00-00'),
(2, 16, 'azhraf9457', 1, '2020-09-10');

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

--
-- Table structure for table `video_list`
--

CREATE TABLE `video_list` (
  `id` int(11) NOT NULL,
  `video_category` varchar(100) DEFAULT NULL,
  `video_subcategory` varchar(100) DEFAULT NULL,
  `title` varchar(100) DEFAULT NULL,
  `info` varchar(100) DEFAULT NULL,
  `video_upload` varchar(1000) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `created_date` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `video_list`
--

INSERT INTO `video_list` (`id`, `video_category`, `video_subcategory`, `title`, `info`, `video_upload`, `status`, `created_date`) VALUES
(15, 'Knowledge', 'Sub Category 1', 'ZAYN - I Don&#039;t Wanna Live Forever (Acoustic)', 'ZAYN - I Don&#039;t Wanna Live Forever (Acoustic)', 'https://www.youtube.com/embed/rGeJ73yAAhQ', 1, '2020-06-26'),
(16, 'Stock', NULL, 'Harry Styles - Two Ghosts', 'Harry Styles - Two Ghosts', 'https://drive.google.com/file/d/1dq-InNd-RdaDxyDfkAKuGb7nKfWNJ3nK/preview', 1, '2020-08-04'),
(17, 'Knowledge', 'Sub Category 1', 'Taylor Swift - Gorgeous (Lyric Video)', 'Taylor Swift - Gorgeous (Lyric Video)', 'https://www.youtube.com/embed/rGeJ73yAAhQ', 1, '2020-08-05'),
(18, 'Forex', 'Sub Category 123', 'ZAYN, Zhavia Ward - A Whole New World', 'ZAYN, Zhavia Ward - A Whole New World', 'https://www.youtube.com/embed/2GRP1rkE4O0', 1, '2020-08-05'),
(19, 'Stock', NULL, 'Stock TT', 'Stock', 'https://www.youtube.com/embed/rGeJ73yAAhQ', 1, '2020-08-25'),
(20, 'Category', 'Sub Category 123', 'Title', ' Info', 'https://www.youtube.com/embed/2GRP1rkE4O0', 1, '2020-09-08'),
(21, '', '', '', '', '', 1, '2020-09-23');

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

--
-- Table structure for table `video_view`
--

CREATE TABLE `video_view` (
  `id` int(11) NOT NULL,
  `video_id` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `like_status` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `created_date` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `wallet`
--

CREATE TABLE `wallet` (
  `id` int(11) NOT NULL,
  `ref_code` varchar(100) DEFAULT NULL,
  `cash_wallet` float DEFAULT NULL,
  `product_wallet` float DEFAULT NULL,
  `created_date` date DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_date` date DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `deleted_date` date DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `wallet`
--

INSERT INTO `wallet` (`id`, `ref_code`, `cash_wallet`, `product_wallet`, `created_date`, `created_by`, `updated_date`, `updated_by`, `deleted_date`, `deleted_by`) VALUES
(510, 'AdminMB2U', 0, 0, '2020-02-12', 0, '2020-08-06', 0, '0000-00-00', 0),
(511, 'qwew@g958', 0, 0, '2020-08-06', 0, '0000-00-00', 0, '0000-00-00', 0),
(512, 'abu@gm4553', 19.02, 0, '2020-08-08', NULL, NULL, NULL, NULL, NULL),
(513, 'azhraf9457', 96.7, 5, '2020-08-08', NULL, '0000-00-00', NULL, NULL, NULL),
(514, 'sofea@8760', 2, 9.99, '2020-08-08', NULL, '2020-09-29', NULL, NULL, NULL),
(515, 'liza@g233', 38.05, 0, '2020-08-08', NULL, NULL, NULL, NULL, NULL),
(516, 'rohani2945', 0, 0, '2020-08-08', NULL, NULL, NULL, NULL, NULL),
(517, 'rafiq@3390', 0, 0, '2020-08-08', NULL, NULL, NULL, NULL, NULL),
(518, 'fitri@5097', 0, 0, '2020-08-09', NULL, NULL, NULL, NULL, NULL),
(519, 'fitri@3630', 0, 0, '2020-08-09', NULL, NULL, NULL, NULL, NULL),
(521, 'sulha@8043', 0, 0, '2020-08-09', NULL, NULL, NULL, NULL, NULL),
(522, 'test123087', 0, 0, '2020-08-09', NULL, NULL, NULL, NULL, NULL),
(523, 'pakarb7388', 0, 0, '2020-08-10', NULL, NULL, NULL, NULL, NULL),
(524, 'pakarb4183', 0, 0, '2020-08-12', NULL, NULL, NULL, NULL, NULL),
(525, 'pakarb6457', 0, 0, '2020-08-12', NULL, NULL, NULL, NULL, NULL),
(526, 'pakarb8038', 0, 0, '2020-08-12', NULL, NULL, NULL, NULL, NULL),
(527, 'akill@7779', 0, 0, '2020-08-12', NULL, NULL, NULL, NULL, NULL),
(528, 'akill@8005', 0, 0, '2020-08-12', NULL, NULL, NULL, NULL, NULL),
(529, 'adsa@g5946', 0, 0, '2020-08-12', NULL, NULL, NULL, NULL, NULL),
(530, 'zakwan933', 0, 0, '2020-08-14', NULL, NULL, NULL, NULL, NULL),
(531, 'fizam@1968', 0, 0, '2020-08-14', NULL, NULL, NULL, NULL, NULL),
(532, 'rzwnrm4322', 75, 0, '2020-08-14', NULL, NULL, NULL, NULL, NULL),
(533, 'aype.r8114', 275, 0, '2020-08-14', NULL, NULL, NULL, NULL, NULL),
(534, 'zakwan2244', 0, 0, '2020-08-14', NULL, NULL, NULL, NULL, NULL),
(535, 'aype.a3211', 0, 0, '2020-08-14', NULL, NULL, NULL, NULL, NULL),
(536, 'zakwan9610', 0, 0, '2020-08-14', NULL, NULL, NULL, NULL, NULL),
(537, 'abus@h5763', 0, 0, '2020-08-14', NULL, NULL, NULL, NULL, NULL),
(538, 'zakwan6206', 0, 0, '2020-08-14', NULL, NULL, NULL, NULL, NULL),
(539, 'masduq421', 0, 0, '2020-08-14', NULL, NULL, NULL, NULL, NULL),
(540, 'masduq258', 0, 0, '2020-08-14', NULL, NULL, NULL, NULL, NULL),
(541, 'amirul2179', 0, 0, '2020-08-14', NULL, NULL, NULL, NULL, NULL),
(542, 'matale6626', 0, 0, '2020-08-14', NULL, NULL, NULL, NULL, NULL),
(543, 'matale4039', 0, 0, '2020-08-14', NULL, NULL, NULL, NULL, NULL),
(544, 'azry_r2395', 0, 0, '2020-08-15', NULL, NULL, NULL, NULL, NULL),
(545, 'aype.a1156', 0, 0, '2020-08-15', NULL, NULL, NULL, NULL, NULL),
(546, 'matale7764', 0, 0, '2020-08-15', NULL, NULL, NULL, NULL, NULL),
(547, 'annura4600', 0, 0, '2020-08-15', NULL, NULL, NULL, NULL, NULL),
(548, 'matale8408', 0, 0, '2020-08-15', NULL, NULL, NULL, NULL, NULL),
(549, 'khairu7118', 0, 0, '2020-08-15', NULL, NULL, NULL, NULL, NULL),
(550, 'mshafi5821', 0, 0, '2020-08-15', NULL, NULL, NULL, NULL, NULL),
(551, 'aizudd2905', 0, 0, '2020-08-15', NULL, NULL, NULL, NULL, NULL),
(552, 'afshaf6951', 0, 0, '2020-08-15', NULL, NULL, NULL, NULL, NULL),
(553, 'enyryh8038', 0, 0, '2020-08-15', NULL, NULL, NULL, NULL, NULL),
(554, 'ningka3370', 0, 0, '2020-08-17', NULL, NULL, NULL, NULL, NULL),
(555, 'ningka4695', 250, 0, '2020-08-17', NULL, NULL, NULL, NULL, NULL),
(556, 'zaki@g6532', 0, 0, '2020-08-17', NULL, NULL, NULL, NULL, NULL),
(557, 'zaki@g8050', 0, 0, '2020-08-17', NULL, NULL, NULL, NULL, NULL),
(558, 'ariff96010', 0, 0, '2020-08-17', NULL, NULL, NULL, NULL, NULL),
(559, 'lanunt5487', 0, 0, '2020-08-18', NULL, NULL, NULL, NULL, NULL),
(560, 'marwan8871', 0, 0, '2020-08-18', NULL, NULL, NULL, NULL, NULL),
(561, 'syafur7536', 0, 0, '2020-08-18', NULL, NULL, NULL, NULL, NULL),
(562, 'joanal5670', 200, 0, '2020-08-19', NULL, NULL, NULL, NULL, NULL),
(563, 'fizam@530', 0, 0, '2020-08-20', NULL, NULL, NULL, NULL, NULL),
(564, 'sdsds@3080', 0, 0, '2020-08-28', NULL, NULL, NULL, NULL, NULL),
(565, 'sofea@8789', 2, 0, '2020-09-22', NULL, '2020-09-29', NULL, NULL, NULL),
(566, 'ali@gm3837', 0, 0, '2020-09-23', NULL, NULL, NULL, NULL, NULL),
(567, 'abu@gm7634', 0, 0, '2020-09-23', NULL, NULL, NULL, NULL, NULL),
(568, 'Aci@gm9333', 0, 0, '2020-09-23', NULL, NULL, NULL, NULL, NULL),
(569, 'Acu@gm4829', 0, 0, '2020-09-23', NULL, NULL, NULL, NULL, NULL),
(570, 'babu@g8308', 1.5, 0, '2020-09-23', NULL, '0000-00-00', NULL, NULL, NULL),
(571, 'fitri@5454', 0, 0, '2020-09-23', NULL, NULL, NULL, NULL, NULL),
(572, 'sulha@5501', 0, 0, '2020-09-24', NULL, NULL, NULL, NULL, NULL),
(573, 'alias@7839', 0, 0, '2020-09-29', NULL, NULL, NULL, NULL, NULL),
(574, 'tyqa@g134', 0, 0, '2020-09-29', NULL, NULL, NULL, NULL, NULL),
(575, 'tyqa1@8365', 0, 0, '2020-09-29', NULL, NULL, NULL, NULL, NULL),
(576, 'a@gmai9185', 0, 0, '2020-09-29', NULL, NULL, NULL, NULL, NULL),
(577, 'b@gmai3069', 0, 0, '2020-09-29', NULL, NULL, NULL, NULL, NULL),
(578, 'Level29964', 1.5, 0, '2020-09-30', NULL, '0000-00-00', NULL, NULL, NULL),
(579, 'Level3214', 1.5, 0, '2020-09-30', NULL, '0000-00-00', NULL, NULL, NULL),
(580, 'Level41270', 1.5, 0, '2020-09-30', NULL, '0000-00-00', NULL, NULL, NULL),
(581, 'Level51511', 2.5, 0, '2020-09-30', NULL, '0000-00-00', NULL, NULL, NULL),
(582, 'Level62633', 2.5, 0, '2020-09-30', NULL, '0000-00-00', NULL, NULL, NULL),
(583, 'Level73688', 2.5, 0, '2020-09-30', NULL, '0000-00-00', NULL, NULL, NULL),
(584, 'Level88479', 2.5, 0, '2020-09-30', NULL, '0000-00-00', NULL, NULL, NULL),
(585, 'Level99842', 72.5, 0, '2020-09-30', NULL, '0000-00-00', NULL, NULL, NULL),
(586, 'Level15188', 0, 0, '2020-09-30', NULL, NULL, NULL, NULL, NULL);

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

--
-- Table structure for table `withdraw_transaction`
--

CREATE TABLE `withdraw_transaction` (
  `id` int(11) NOT NULL,
  `trans_code` varchar(100) DEFAULT NULL,
  `ref_code` varchar(100) DEFAULT NULL,
  `withdraw_to` varchar(10) DEFAULT NULL,
  `type_of_transaction` varchar(100) DEFAULT NULL,
  `amount` float DEFAULT NULL,
  `amount_MYR` float DEFAULT NULL,
  `acc_holder_name` varchar(100) DEFAULT NULL,
  `acc_no` varchar(100) DEFAULT NULL,
  `bank` varchar(100) DEFAULT NULL,
  `blockchain_address` varchar(100) DEFAULT NULL,
  `payment_status` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `created_date` date DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_date` date DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `deleted_date` date DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `withdraw_transaction`
--

INSERT INTO `withdraw_transaction` (`id`, `trans_code`, `ref_code`, `withdraw_to`, `type_of_transaction`, `amount`, `amount_MYR`, `acc_holder_name`, `acc_no`, `bank`, `blockchain_address`, `payment_status`, `status`, `created_date`, `created_by`, `updated_date`, `updated_by`, `deleted_date`, `deleted_by`) VALUES
(2, '', 'azhraf9457', 'Bank', 'CW', 23.81, 100, 'Mohd Ashraf', '1321323321', 'Maybank', '', 1, 1, '2020-08-04', 0, '0000-00-00', 0, '0000-00-00', 0),
(3, 'BKDgR2Z9', 'azhraf9457', 'BA', 'CW', 2.38, 10, 'Ashraf', '10101001', 'HSBC BANK MALAYSIA BERHAD', '', 0, 0, '2020-08-06', 0, '0000-00-00', 0, '0000-00-00', 0),
(4, 'l1yP7rwd', 'azhraf9457', 'BA', 'CW', 1.19, 5, 'Ashraf', '10101001', 'HSBC BANK MALAYSIA BERHAD', '', 0, 0, '2020-08-06', 0, '0000-00-00', 0, '0000-00-00', 0),
(5, '6NjsHueK', 'azhraf9457', 'BA', 'CW', 1.19, 5, 'Ashraf', '10101001', 'HSBC BANK MALAYSIA BERHAD', '', 1, 0, '2020-08-06', 0, '0000-00-00', 0, '0000-00-00', 0),
(6, '2XqWPf7z', 'azhraf9457', 'BA', 'PW', 1.19, 5, 'Ashraf', '10101001', 'HSBC BANK MALAYSIA BERHAD', '', 1, 0, '2020-08-06', 0, '0000-00-00', 0, '0000-00-00', 0),
(7, 'DeyAAgTr', 'azhraf9457', 'BA', 'PW', 1.19, 5, 'Ashraf', '10101001', 'HSBC BANK MALAYSIA BERHAD', '', 1, 0, '2020-08-06', 0, '0000-00-00', 0, '0000-00-00', 0),
(8, 'UmjAfHr1', 'azhraf9457', 'BA', 'CW', 0.24, 1, 'Ashraf', '10101001', 'HSBC BANK MALAYSIA BERHAD', NULL, NULL, NULL, '2020-08-25', NULL, NULL, NULL, NULL, NULL),
(9, 'U5bdz6Jg', 'azhraf9457', 'BA', 'CW', 0.31, NULL, 'Ashraf', '10101001', 'HSBC BANK MALAYSIA BERHAD', NULL, 0, 0, '2020-09-29', NULL, NULL, NULL, NULL, NULL),
(10, 'X17qonhf', 'sofea@8789', 'BA', 'CW', 1, NULL, 'Sofea', '1234', 'BANK ISLAM MALAYSIA', NULL, 1, 0, '2020-09-29', NULL, NULL, NULL, NULL, NULL);

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

