-- 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 `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_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 `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=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 `transactions`
--
ALTER TABLE `transactions`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=210;

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

