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

START TRANSACTION;



--
-- Database: `u848155021_mydayanassys`
--

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

--
-- 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,
  `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 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`, `Valid_Month`, `Bonus_Peribadi`, `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, 1, 0.5, 0, 2, 0, 0.2, 0.2, 0.2, 0.2, 0.2, 0.1, 0.1, 0.1, 0.1, 0.1, 1, '2020-09-24 00:00:00'),
(6, 'Item Commission', '55234fLB', 'PAKEJ RM 20', 'SERAI WANGI', 20, 2, 1, 0, 3, 0, 1, 1, 1, 1, 1, 0.5, 0.5, 0.5, 0.5, 0.5, 1, '2020-09-24 00:00:00'),
(7, 'Item Commission', '55234fLC', 'PAKEJ RM 50', 'KOPI ZURIAT', 50, 3, 2, 5, 5, 0, 1.5, 1.5, 1.5, 1.5, 1.5, 1, 1, 1, 1, 1, 1, '2020-09-24 00:00:00'),
(8, 'Item Commission', '55234fLD', 'PAKEJ RM 120', 'PERFUME 4mlx24 BOTOL', 120, 6, 6, 10, 14, 0, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 1, '2020-09-24 00:00:00'),
(9, 'Item Commission', 'BifjBnih', 'PAKEJ SETOKIS', 'PAKEJ SETOKIS', 200, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 9, '2020-10-15 00:00:00'),
(10, 'Item Commission', 'KXMPYNMp', 'PAKEJ RM 20', 'IRONING AID', 20, 2, 1, 0, 3, 0, 1, 1, 1, 1, 1, 0.5, 0.5, 0.5, 0.5, 0.5, 1, '2020-10-30 00:00:00'),
(11, 'Item Commission', 'Kayfcc0a', 'PAKEJ RM 50', 'PERFUME 5ml x5 BOTOL', 50, 3, 2, 5, 5, 0, 1.5, 1.5, 1.5, 1.5, 1.5, 1, 1, 1, 1, 1, 1, '2020-10-30 00:00:00');

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

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

--
-- Dumping data for table `memos`
--

INSERT INTO `memos` (`id`, `memo_title`, `memo_input`, `status`, `created_date`) VALUES
(1, 'MYDAYANAS', 'M ~ Menjadi\r\nY ~ Yang\r\nDA ~ ber DAkwah\r\nYA ~ YAqin (dan jujur)\r\nN ~ &amp; (dan)\r\nAS ~ Aplikasikan Sunnah\r\n\r\nmenjadi budak agama, bukan membudak agama\r\n\r\nuntuk mengesakan Allah dan mencintai RasulUllah\r\n\r\nODOS', 1, '2020-10-01 00:00:00');

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

--
-- 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,
  `sponsor_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 DEFAULT NULL,
  `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;

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

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

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

INSERT INTO `video_list` (`id`, `video_category`, `video_subcategory`, `title`, `info`, `video_upload`, `status`, `created_date`) VALUES
(22, 'Muqaddimah', '01', 'Ikhlas', 'Tuan Guru', 'https://www.youtube.com/watch?v=6KKdiB61gzM&amp;feature=share', 1, '2020-10-01 00:00:00');

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

--
-- 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, 'MYDAYANAS', 0, 0, '2020-08-08 00:00:00', NULL, '0000-00-00 00:00:00', 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=12;

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

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

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

--
-- AUTO_INCREMENT for table `transactions`
--
ALTER TABLE `transactions`
  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=23;

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

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

