-- 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) DEFAULT NULL,
  `Package_Name` varchar(100) DEFAULT NULL,
  `Item_Name` varchar(100) DEFAULT NULL,
  `Price` float NOT NULL,
  `Valid_Month` int(11) DEFAULT NULL,
  `Bonus_Peribadi` float DEFAULT 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` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- Error reading data for table mydayanas.comission_setting: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'FROM `mydayanas`.`comission_setting`' at line 1

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

--
-- 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` datetime 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,
  `quantity` int(11) NOT NULL,
  `remark` varchar(100) NOT NULL,
  `transfer_from_stokist` int(11) DEFAULT NULL,
  `status` int(11) NOT NULL,
  `created_date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `package_stock`
--

CREATE TABLE `package_stock` (
  `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,
  `quantity` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  `created_date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `payment`
--

CREATE TABLE `payment` (
  `id` int(11) NOT NULL,
  `payment_code` varchar(100) DEFAULT NULL,
  `transaction_id` varchar(100) DEFAULT NULL,
  `ref_code` varchar(100) DEFAULT NULL,
  `name` varchar(100) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `phone_number` varchar(100) DEFAULT NULL,
  `attachment_image` varchar(100) DEFAULT NULL,
  `BC_transaction_image` varchar(100) DEFAULT NULL,
  `payment_type` varchar(10) DEFAULT NULL,
  `amount` float DEFAULT NULL,
  `msg` varchar(100) DEFAULT NULL,
  `hash` varchar(1000) DEFAULT NULL,
  `reference` varchar(100) DEFAULT NULL,
  `order_remark` varchar(500) DEFAULT NULL,
  `status` text,
  `payment_status` int(11) DEFAULT NULL,
  `created_date` datetime DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- 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` datetime DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_date` datetime 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
(196, 'MYDAYANAS', '7BBrhiJq', 'CW', 0, 0, 0, 'Penaja Commission RM 0 For New Agent Left1 | 11111111 ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2020-11-17 23:52:24', NULL, NULL, NULL),
(197, 'Left1@1974', 'btMeWZpu', 'CW', 0, 0, 0, 'Penaja Commission RM 0 For New Agent Left | 22222222 ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2020-11-18 00:12:22', NULL, NULL, NULL),
(198, 'Left1@1974', 'KkP9nfQC', 'CW', 0, 0, 0, 'Penaja Commission RM 0 For New Agent Middle | 3333333 ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2020-11-18 00:12:55', NULL, NULL, NULL),
(199, 'Left1@1974', '58Ztxcpe', 'CW', 0, 0, 0, 'Penaja Commission RM 0 For New Agent Right | 4444444 ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2020-11-18 00:13:26', NULL, NULL, NULL),
(200, 'Left1@1974', 'UUNDxNNd', 'CW', 0, 0, 0, 'Penaja Commission RM 0 For New Agent Right1 | 5555555 ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2020-11-18 00:13:44', NULL, NULL, NULL),
(201, 'MYDAYANAS', 'APM54X6z', 'CW', 0, 0, 0, 'Penaja Commission RM 0 For New Agent Level2 | 31231232 ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2020-11-18 00:19:13', NULL, NULL, NULL),
(202, 'MYDAYANAS', 'm5gEwGlZ', 'CW', 0, 0, 0, 'Penaja Commission RM 0 For New Agent Level3 | 31231233 ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2020-11-18 00:19:43', NULL, NULL, NULL),
(203, 'MYDAYANAS', 'NNO11aXP', 'CW', 0, 0, 0, 'Penaja Commission RM 0 For New Agent Level4 | 31231234 ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2020-11-18 00:20:22', NULL, NULL, NULL),
(204, 'MYDAYANAS', 'HrCzPTEt', 'CW', 0, 0, 0, 'Penaja Commission RM 0 For New Agent Level5 | 31231235 ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2020-11-18 00:20:55', NULL, NULL, NULL),
(205, 'MYDAYANAS', 'zjkkN3JU', 'CW', 0, 0, 0, 'Penaja Commission RM 0 For New Agent Level6 | 31231236 ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2020-11-18 00:21:24', NULL, NULL, NULL),
(206, 'MYDAYANAS', '6kFG3Ios', 'CW', 0, 0, 0, 'Penaja Commission RM 0 For New Agent Level7 | 31231237 ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2020-11-18 00:21:53', NULL, NULL, NULL),
(207, 'MYDAYANAS', 'yRxDqf0H', 'CW', 0, 0, 0, 'Penaja Commission RM 0 For New Agent Level8 | 31231238 ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2020-11-18 00:22:21', NULL, NULL, NULL),
(208, 'MYDAYANAS', 'TlOQq0tw', 'CW', 0, 0, 0, 'Penaja Commission RM 0 For New Agent Level9 | 31231239 ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2020-11-18 00:22:47', NULL, NULL, NULL),
(209, 'MYDAYANAS', '8BZXsl29', 'CW', 0, 0, 0, 'Penaja Commission RM 0 For New Agent Level10 | 312312310 ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2020-11-18 00:23:10', NULL, NULL, NULL);

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

--
-- Table structure for table `user`
--

CREATE TABLE `user` (
  `id` int(11) NOT NULL,
  `level` int(11) DEFAULT NULL,
  `type_of_user` varchar(100) NOT NULL,
  `paid` int(11) DEFAULT NULL,
  `sponsor_code` varchar(100) DEFAULT NULL,
  `tree_sponsor_code` varchar(100) NOT NULL,
  `ref_code` varchar(100) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `phone_number` varchar(100) DEFAULT NULL,
  `nick_name` varchar(100) DEFAULT NULL,
  `password` varchar(100) DEFAULT NULL,
  `no_of_downline` int(11) DEFAULT NULL,
  `pairing_position` varchar(10) DEFAULT NULL,
  `left_1_pairing_status` int(11) NOT NULL,
  `left_1_pairing_ref_code` varchar(100) NOT NULL,
  `left_2_pairing_status` int(11) NOT NULL,
  `left_2_pairing_ref_code` varchar(100) NOT NULL,
  `middle_pairing_status` int(11) NOT NULL,
  `middle_pairing_ref_code` varchar(100) NOT NULL,
  `right_1_pairing_status` int(11) NOT NULL,
  `right_1_pairing_ref_code` varchar(100) NOT NULL,
  `right_2_pairing_status` int(11) NOT NULL,
  `right_2_pairing_ref_code` varchar(100) NOT NULL,
  `profile_image` varchar(100) DEFAULT NULL,
  `name` varchar(100) DEFAULT NULL,
  `no_ic` varchar(100) DEFAULT NULL,
  `address` varchar(200) DEFAULT NULL,
  `state` varchar(100) DEFAULT NULL,
  `area` varchar(100) DEFAULT NULL,
  `postcode` varchar(100) DEFAULT NULL,
  `country` varchar(100) DEFAULT NULL,
  `birth_date` varchar(100) DEFAULT NULL,
  `bank_type` varchar(100) DEFAULT NULL,
  `acc_no` varchar(100) DEFAULT NULL,
  `acc_holder` varchar(100) DEFAULT NULL,
  `remark` varchar(100) DEFAULT NULL,
  `wallet_status` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `created_date` datetime DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_date` datetime DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `blocked_date` datetime DEFAULT NULL,
  `blocked_by` int(11) DEFAULT NULL,
  `deleted_date` datetime DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `user`
--

INSERT INTO `user` (`id`, `level`, `type_of_user`, `paid`, `sponsor_code`, `tree_sponsor_code`, `ref_code`, `email`, `phone_number`, `nick_name`, `password`, `no_of_downline`, `pairing_position`, `left_1_pairing_status`, `left_1_pairing_ref_code`, `left_2_pairing_status`, `left_2_pairing_ref_code`, `middle_pairing_status`, `middle_pairing_ref_code`, `right_1_pairing_status`, `right_1_pairing_ref_code`, `right_2_pairing_status`, `right_2_pairing_ref_code`, `profile_image`, `name`, `no_ic`, `address`, `state`, `area`, `postcode`, `country`, `birth_date`, `bank_type`, `acc_no`, `acc_holder`, `remark`, `wallet_status`, `status`, `created_date`, `created_by`, `updated_date`, `updated_by`, `blocked_date`, `blocked_by`, `deleted_date`, `deleted_by`) VALUES
(4, 1, 'Basic User', 0, '', '', 'AdminMyDayanas', 'admin@mydayanas2u.com', '0162129154', 'admin@mydayanas2u.com', 'admi!@#12', 5, '', 1, 'azhraf9457', 1, 'sofea@8789', 1, 'ali@gm3837', 1, 'abu@gm7634', 1, 'Acu@gm4829', '', 'Ismail', '10101010101010', ' No 200, jalan kasturi                                                   ', '', '', '', '', '', 'DEUTSCHE BANK (MSIA) BERHAD', '12020123231', 'HQ', '', 0, 1, '0000-00-00 00:00:00', 0, '2020-04-22 00:00:00', 4, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0),
(505, 2, 'Stokist', 0, '', '', 'MYDAYANAS', 'mydayanas', '01152409241', 'mydayanas', 'mydayanas', 5, '', 1, 'Left1@1974', 1, 'Left@g6719', 1, 'Middle2601', 1, 'Right@2386', 1, 'Right15503', 'azhraf94571596934310.JPG', 'mydayanas', '', ' No 100, Jalan Kasturi                                                                                                                                                           ', '', 'Puchong', '', '', '', 'HSBC BANK MALAYSIA BERHAD', '10101001', 'Ashraf', '', 0, 1, '2020-02-12 02:03:00', 505, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0),
(536, 2, 'Basic User', 0, 'MYDAYANAS', 'MYDAYANAS', 'Left1@1974', 'Left1@gmail.com', '11111111', 'Left1@gmail.com', 'Left1@gmail.com', 1, 'L1', 1, 'Level25058', 0, '', 0, '', 0, '', 0, '', NULL, 'Left1', NULL, NULL, 'KL', NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, 1, '2020-11-17 23:52:24', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(537, 2, 'Basic User', 0, 'Left1@1974', 'MYDAYANAS', 'Left@g6719', 'Left@gmail.com', '22222222', 'Left@gmail.com', 'Left@gmail.com', NULL, 'L2', 0, '', 0, '', 0, '', 0, '', 0, '', NULL, 'Left', NULL, NULL, 'KL', NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, 1, '2020-11-18 00:12:22', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(538, 2, 'Basic User', 0, 'Left1@1974', 'MYDAYANAS', 'Middle2601', 'Middle@gmail.com', '3333333', 'Middle@gmail.com', 'Middle@gmail.com', NULL, 'M', 0, '', 0, '', 0, '', 0, '', 0, '', NULL, 'Middle', NULL, NULL, 'KL', NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, 1, '2020-11-18 00:12:55', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(539, 2, 'Basic User', 0, 'Left1@1974', 'MYDAYANAS', 'Right@2386', 'Right@gmail.com', '4444444', 'Right@gmail.com', 'Right@gmail.com', NULL, 'R1', 0, '', 0, '', 0, '', 0, '', 0, '', NULL, 'Right', NULL, NULL, 'KL', NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, 1, '2020-11-18 00:13:26', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(540, 2, 'Basic User', 0, 'Left1@1974', 'MYDAYANAS', 'Right15503', 'Right1@gmail.com', '5555555', 'Right1@gmail.com', 'Right1', NULL, 'R2', 0, '', 0, '', 0, '', 0, '', 0, '', NULL, 'Right1', NULL, NULL, 'KL', NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, 1, '2020-11-18 00:13:44', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(541, 2, 'Basic User', 0, 'MYDAYANAS', 'Left1@1974', 'Level25058', 'Level2@gmail.com', '31231232', 'Level2@gmail.com', 'Level2@gmail.com', 1, 'L1', 1, 'Level38182', 0, '', 0, '', 0, '', 0, '', NULL, 'Level2', NULL, NULL, 'KL', NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, 1, '2020-11-18 00:19:13', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(542, 2, 'Basic User', 0, 'MYDAYANAS', 'Level25058', 'Level38182', 'Level3@gmail.com', '31231233', 'Level3@gmail.com', 'Level3@gmail.com', 1, 'L1', 1, 'Level44613', 0, '', 0, '', 0, '', 0, '', NULL, 'Level3', NULL, NULL, 'KL', NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, 1, '2020-11-18 00:19:43', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(543, 2, 'Basic User', 0, 'MYDAYANAS', 'Level38182', 'Level44613', 'Level4@gmail.com', '31231234', 'Level4@gmail.com', 'Level4@gmail.com', 1, 'L1', 1, 'Level57706', 0, '', 0, '', 0, '', 0, '', NULL, 'Level4', NULL, NULL, 'KL', NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, 1, '2020-11-18 00:20:22', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(544, 2, 'Basic User', 0, 'MYDAYANAS', 'Level44613', 'Level57706', 'Level5@gmail.com', '31231235', 'Level5@gmail.com', 'Level5@gmail.com', 1, 'L1', 1, 'Level66051', 0, '', 0, '', 0, '', 0, '', NULL, 'Level5', NULL, NULL, 'KL', NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, 1, '2020-11-18 00:20:55', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(545, 2, 'Basic User', 0, 'MYDAYANAS', 'Level57706', 'Level66051', 'Level6@gmail.com', '31231236', 'Level6@gmail.com', 'Level6@gmail.com', 1, 'L1', 1, 'Level72581', 0, '', 0, '', 0, '', 0, '', NULL, 'Level6', NULL, NULL, 'KL', NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, 1, '2020-11-18 00:21:24', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(546, 2, 'Basic User', 0, 'MYDAYANAS', 'Level66051', 'Level72581', 'Level7@gmail.com', '31231237', 'Level7@gmail.com', 'Level7@gmail.com', 1, 'L1', 1, 'Level88714', 0, '', 0, '', 0, '', 0, '', NULL, 'Level7', NULL, NULL, 'KL', NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, 1, '2020-11-18 00:21:53', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(547, 2, 'Basic User', 0, 'MYDAYANAS', 'Level72581', 'Level88714', 'Level8@gmail.com', '31231238', 'Level8@gmail.com', 'Level8@gmail.com', 1, 'L1', 1, 'Level9729', 0, '', 0, '', 0, '', 0, '', NULL, 'Level8', NULL, NULL, 'KL', NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, 1, '2020-11-18 00:22:21', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(548, 2, 'Basic User', 0, 'MYDAYANAS', 'Level88714', 'Level9729', 'Level9@gmail.com', '31231239', 'Level9@gmail.com', 'Level9@gmail.com', 1, 'L1', 1, 'Level14445', 0, '', 0, '', 0, '', 0, '', NULL, 'Level9', NULL, NULL, 'KL', NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, 1, '2020-11-18 00:22:47', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(549, 2, 'Basic User', 0, 'MYDAYANAS', 'Level9729', 'Level14445', 'Level10@gmail.com', '312312310', 'Level10@gmail.com', 'Level10@gmail.com', NULL, 'L1', 0, '', 0, '', 0, '', 0, '', 0, '', NULL, 'Level10', NULL, NULL, 'KL', NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, 1, '2020-11-18 00:23:10', NULL, NULL, NULL, NULL, 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` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- 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` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- 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` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- 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` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- 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` datetime 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` datetime DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_date` datetime DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `deleted_date` datetime 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 00:00:00', 0, '2020-08-06 00:00:00', 0, '0000-00-00 00:00:00', 0),
(513, 'azhraf9457', 0, 0, '2020-08-08 00:00:00', NULL, '0000-00-00 00:00:00', NULL, NULL, NULL),
(595, 'Left1@1974', 0, 0, '2020-11-17 23:52:24', NULL, NULL, NULL, NULL, NULL),
(596, 'Left@g6719', 0, 0, '2020-11-18 00:12:22', NULL, NULL, NULL, NULL, NULL),
(597, 'Middle2601', 0, 0, '2020-11-18 00:12:55', NULL, NULL, NULL, NULL, NULL),
(598, 'Right@2386', 0, 0, '2020-11-18 00:13:26', NULL, NULL, NULL, NULL, NULL),
(599, 'Right15503', 0, 0, '2020-11-18 00:13:44', NULL, NULL, NULL, NULL, NULL),
(600, 'Level25058', 0, 0, '2020-11-18 00:19:13', NULL, NULL, NULL, NULL, NULL),
(601, 'Level38182', 0, 0, '2020-11-18 00:19:43', NULL, NULL, NULL, NULL, NULL),
(602, 'Level44613', 0, 0, '2020-11-18 00:20:22', NULL, NULL, NULL, NULL, NULL),
(603, 'Level57706', 0, 0, '2020-11-18 00:20:55', NULL, NULL, NULL, NULL, NULL),
(604, 'Level66051', 0, 0, '2020-11-18 00:21:24', NULL, NULL, NULL, NULL, NULL),
(605, 'Level72581', 0, 0, '2020-11-18 00:21:53', NULL, NULL, NULL, NULL, NULL),
(606, 'Level88714', 0, 0, '2020-11-18 00:22:21', NULL, NULL, NULL, NULL, NULL),
(607, 'Level9729', 0, 0, '2020-11-18 00:22:47', NULL, NULL, NULL, NULL, NULL),
(608, 'Level14445', 0, 0, '2020-11-18 00:23:10', 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` datetime DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_date` datetime DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `deleted_date` datetime DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- 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 `package_stock`
--
ALTER TABLE `package_stock`
  ADD PRIMARY KEY (`id`);

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

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

--
-- Indexes for table `user`
--
ALTER TABLE `user`
  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=11;

--
-- 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=34;

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

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

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

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

--
-- 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=609;

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

