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

START TRANSACTION;



--
-- Database: `mhflegac_herbalistlab`
--

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

--
-- 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.4, 0.4, 0.4, 0.4, 0.4, 0.2, 0.2, 0.2, 0.2, 0.2, 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'),
(12, 'Item Commission', 'FECceo7u', 'PAKEJ RM 10', 'CAR / HOME PERFUME', 10, 1, 0.5, 0, 2, 0, 0.4, 0.4, 0.4, 0.4, 0.4, 0.2, 0.2, 0.2, 0.2, 0.2, 1, '2020-12-10 22:32:06'),
(13, 'Item Commission', 'BNyobcKC', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, '2021-01-27 23:13:16');

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

--
-- Table structure for table `coupon_used`
--

CREATE TABLE `coupon_used` (
  `id` int(11) NOT NULL,
  `coupon_code` varchar(100) NOT NULL,
  `user_id` int(11) NOT NULL,
  `order_ref_code` varchar(100) NOT NULL,
  `coupon_amount` double NOT NULL,
  `status` int(11) NOT NULL,
  `created_date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `coupon_used`
--

INSERT INTO `coupon_used` (`id`, `coupon_code`, `user_id`, `order_ref_code`, `coupon_amount`, `status`, `created_date`) VALUES
(7, 'R0gdTLxu', 3, 'WFl0PHX4', 20, 1, '2021-02-23 20:44:07');

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

--
-- Table structure for table `coupun_setting`
--

CREATE TABLE `coupun_setting` (
  `id` int(11) NOT NULL,
  `coupon_ref_code` varchar(100) NOT NULL,
  `amount` double NOT NULL,
  `minimum_purchase` double NOT NULL,
  `maximum_purchase` double NOT NULL,
  `active_status` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  `created_date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `coupun_setting`
--

INSERT INTO `coupun_setting` (`id`, `coupon_ref_code`, `amount`, `minimum_purchase`, `maximum_purchase`, `active_status`, `status`, `created_date`) VALUES
(1, 'Ly73P323', 10, 10, 100, 1, 1, '2021-02-22 21:56:00'),
(2, 'TJCmqqMR', 15, 15, 115, 1, 1, '2021-02-22 22:29:32'),
(3, 'R0gdTLxu', 20, 20, 200, 1, 1, '2021-02-22 22:29:47');

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

--
-- Table structure for table `course`
--

CREATE TABLE `course` (
  `id` int(11) NOT NULL,
  `User_ID` varchar(100) NOT NULL,
  `Course_ID` varchar(100) NOT NULL,
  `Course_Name` varchar(100) NOT NULL,
  `Course_Price` varchar(100) NOT NULL,
  `Course_Completion_Percent` int(11) NOT NULL,
  `Course_Expired_Date` date NOT NULL,
  `Status` int(11) NOT NULL,
  `Created_Date` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `course_category`
--

CREATE TABLE `course_category` (
  `id` int(11) NOT NULL,
  `Course_ID` varchar(100) NOT NULL,
  `Course_Name` varchar(100) NOT NULL,
  `Course_Price` varchar(100) NOT NULL,
  `Course_Validity_Day` int(11) NOT NULL,
  `Course_Trainer_Logo` varchar(100) NOT NULL,
  `Status` int(11) NOT NULL,
  `Created_Date` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `course_completed`
--

CREATE TABLE `course_completed` (
  `id` int(11) NOT NULL,
  `User_ID` varchar(100) NOT NULL,
  `Course_ID` varchar(100) NOT NULL,
  `Status` int(11) NOT NULL,
  `Created_Date` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `course_payment`
--

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

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

--
-- Table structure for table `course_process`
--

CREATE TABLE `course_process` (
  `id` int(11) NOT NULL,
  `User_ID` varchar(100) NOT NULL,
  `Course_ID` varchar(100) NOT NULL,
  `Pre_Quiz` int(11) NOT NULL,
  `Video_1` int(11) NOT NULL,
  `Quiz_1` int(11) NOT NULL,
  `Video_2` int(11) NOT NULL,
  `Quiz_2` int(11) NOT NULL,
  `Video_3` int(11) NOT NULL,
  `Quiz_3` int(11) NOT NULL,
  `Video_4` int(11) NOT NULL,
  `Quiz_4` int(11) NOT NULL,
  `Video_5` int(11) NOT NULL,
  `Quiz_5` int(11) NOT NULL,
  `Video_6` int(11) NOT NULL,
  `Quiz_6` int(11) NOT NULL,
  `Video_7` int(11) NOT NULL,
  `Quiz_7` int(11) NOT NULL,
  `Video_8` int(11) NOT NULL,
  `Quiz_8` int(11) NOT NULL,
  `Video_9` int(11) NOT NULL,
  `Quiz_9` int(11) NOT NULL,
  `Video_10` int(11) NOT NULL,
  `Quiz_11` int(11) NOT NULL,
  `Post_Quiz` int(11) NOT NULL,
  `Status` int(11) NOT NULL,
  `Created_Date` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- 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\n[menjadi budak agama, bukan membudak agama]\r\n\r\n~untuk mengesakan Allah dan mencintai RasulUllah~\r\n\r\n(ODOS)                                                ', 1, '2020-10-01 00:00:00');

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

--
-- Table structure for table `menu`
--

CREATE TABLE `menu` (
  `menu_id` int(11) NOT NULL,
  `menu_name` varchar(255) NOT NULL,
  `parent_id` int(11) NOT NULL DEFAULT '0' COMMENT '0 if menu is root level or menuid if this is child on any menu',
  `link` varchar(255) NOT NULL,
  `status` enum('0','1') NOT NULL DEFAULT '1' COMMENT '0 for disabled menu or 1 for enabled menu'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `menu`
--

INSERT INTO `menu` (`menu_id`, `menu_name`, `parent_id`, `link`, `status`) VALUES
(1, 'Home', 0, '#home', '1'),
(2, 'Web development', 0, '#web-dev', '1'),
(3, 'WordPress Development', 0, '#wp-dev', '1'),
(4, 'About w3school.info', 0, '#w3school-info', '1'),
(5, 'AWS ADMIN', 2, '#', '1'),
(6, 'PHP', 2, '#', '1'),
(7, 'Javascript', 2, '#', '1'),
(8, 'Elastic Ip', 5, '#electic-ip', '1'),
(9, 'Load balacing', 5, '#load-balancing', '1'),
(10, 'Cluster Indexes', 5, '#cluster-indexes', '1'),
(11, 'Rds Db setup', 5, '#rds-db', '1'),
(12, 'Framework Development', 6, '#', '1'),
(13, 'Ecommerce Development', 6, '#', '1'),
(14, 'Cms Development', 6, '#', '1'),
(21, 'News & Media', 6, '#', '1'),
(22, 'Codeigniter', 12, '#codeigniter', '1'),
(23, 'Cake', 12, '#cake-dev', '1'),
(24, 'Opencart', 13, '#opencart', '1'),
(25, 'Magento', 13, '#magento', '1'),
(26, 'Wordpress', 14, '#wordpress-dev', '1'),
(27, 'Joomla', 14, '#joomla-dev', '1'),
(28, 'Drupal', 14, '#drupal-dev', '1'),
(29, 'Ajax', 7, '#ajax-dev', '1'),
(30, 'Jquery', 7, '#jquery-dev', '1'),
(31, 'Themes', 3, '#theme-dev', '1'),
(32, 'Plugins', 3, '#plugin-dev', '1'),
(33, 'Custom Post Types', 3, '#', '1'),
(34, 'Options', 3, '#wp-options', '1'),
(35, 'Testimonials', 33, '#testimonial-dev', '1'),
(36, 'Portfolios', 33, '#portfolio-dev', '1');

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

--
-- Table structure for table `modul`
--

CREATE TABLE `modul` (
  `id` int(11) NOT NULL,
  `Modul_ID` varchar(100) NOT NULL,
  `Course_ID` varchar(100) NOT NULL,
  `Modul_Number` int(11) NOT NULL,
  `Modul_Name` varchar(100) NOT NULL,
  `Modul_Trainer_Name` varchar(100) NOT NULL,
  `Modul_Trainer_Whatsapp_Number` varchar(100) NOT NULL,
  `Status` int(11) NOT NULL,
  `Created_Date` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `my_cart`
--

CREATE TABLE `my_cart` (
  `id` int(11) NOT NULL,
  `order_ref_code` varchar(100) NOT NULL,
  `user_id` int(11) NOT NULL,
  `prod_id` int(11) NOT NULL,
  `prod_name` varchar(100) NOT NULL,
  `prod_price` double NOT NULL,
  `prod_qty` int(11) NOT NULL,
  `product_total_price` double NOT NULL,
  `status` int(11) NOT NULL,
  `created_date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `online_quiz`
--

CREATE TABLE `online_quiz` (
  `id` int(11) NOT NULL,
  `Online_Quiz_ID` varchar(100) NOT NULL,
  `Online_Quiz_Title_ID` varchar(100) NOT NULL,
  `Online_Quiz_Question_Number` int(11) NOT NULL,
  `Online_Quiz_Question` varchar(1000) NOT NULL,
  `Online_Quiz_Question_Picture` varchar(1000) NOT NULL,
  `Online_Quiz_Question_Answer_A` varchar(1000) NOT NULL,
  `Online_Quiz_Question_Answer_B` varchar(1000) NOT NULL,
  `Online_Quiz_Question_Answer_C` varchar(1000) NOT NULL,
  `Online_Quiz_Question_Answer_D` varchar(1000) NOT NULL,
  `Online_Quiz_Question_Answer` varchar(1000) NOT NULL,
  `Status` int(11) NOT NULL,
  `Created_Date` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `online_quiz_answer`
--

CREATE TABLE `online_quiz_answer` (
  `id` int(11) NOT NULL,
  `User_ID` varchar(100) NOT NULL,
  `Online_Quiz_Title_ID` varchar(100) NOT NULL,
  `Online_Quiz_Question_Number` int(11) NOT NULL,
  `Marks` int(11) NOT NULL,
  `Status` int(11) NOT NULL,
  `Created_Date` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `online_quiz_submit`
--

CREATE TABLE `online_quiz_submit` (
  `id` int(11) NOT NULL,
  `Online_Quiz_Title_ID` varchar(100) NOT NULL,
  `User_ID` varchar(100) NOT NULL,
  `Status` int(11) NOT NULL,
  `Created_Date` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `online_quiz_title`
--

CREATE TABLE `online_quiz_title` (
  `id` int(11) NOT NULL,
  `Online_Quiz_Title_ID` varchar(100) NOT NULL,
  `Modul_ID` varchar(11) NOT NULL,
  `Quiz_Title_Number` int(11) NOT NULL,
  `Quiz_Title_Name` varchar(1000) NOT NULL,
  `Quiz_Title_Instruction` varchar(1000) NOT NULL,
  `Quiz_Title_Duration` varchar(100) NOT NULL,
  `Quiz_Title_Repeat` varchar(100) NOT NULL,
  `Status` int(11) NOT NULL,
  `Created_Date` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `order_info`
--

CREATE TABLE `order_info` (
  `id` int(11) NOT NULL,
  `order_ref_code` varchar(100) NOT NULL,
  `agent_id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `last_name` varchar(100) NOT NULL,
  `phone_number` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `country` varchar(100) NOT NULL,
  `postcode` varchar(100) NOT NULL,
  `address` varchar(100) NOT NULL,
  `status` int(11) NOT NULL,
  `created_date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

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

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

INSERT INTO `package_sale` (`id`, `package_code`, `ref_code`, `sponsor_code`, `package_name`, `package_item_name`, `package_price`, `payment_reciept`, `quantity`, `remark`, `transfer_from_stokist`, `status`, `created_date`) VALUES
(1, 'FECceo7u', 'ajiba28006', 'MYDAYANAS', 'PAKEJ RM 10', 'CAR / HOME PERFUME', 10, 'ajiba280061610631153.png', 1, 'Test                            ', 0, 0, '2021-01-14 21:32:33'),
(2, '55Rl3fLA', 'MYDAYANAS', '', 'PAKEJ RM 10', 'PERFUME 5ml', 100, 'MYDAYANAS1606110926.jpeg', 10, '        Belian stok                                            ', 0, 1, '2020-11-23 13:55:26'),
(3, '55Rl3fLA', 'Mydayanas', 'MYDAYANAS', 'PAKEJ RM 10', 'PERFUME 5ml', 10, 'Transfer Stock By Stokist', 1, 'MYDAYANAS', 1, 1, '2020-11-23 14:06:46'),
(4, '55Rl3fLA', 'mail641796', 'MYDAYANAS', 'PAKEJ RM 10', 'PERFUME 5ml', 10, 'mail6417961606112202.jpeg', 1, '       Belian peribadi                     ', 0, 1, '2020-11-23 14:16:42'),
(5, '55Rl3fLA', 'mail641796', '', 'PAKEJ RM 10', 'PERFUME 5ml', 100, 'mail6417961606113189.jpeg', 10, '                Belian stok                                    ', 0, 1, '2020-11-23 14:33:09'),
(6, '55Rl3fLA', 'Zarina8983', 'mail641796', 'PAKEJ RM 10', 'PERFUME 5ml', 10, 'Transfer Stock By Stokist', 1, 'mail641796', 1, 1, '2020-11-23 16:38:33'),
(7, 'KXMPYNMp', 'mail641796', '', 'PAKEJ RM 20', 'IRONING AID', 100, 'mail6417961606123670.jpeg', 5, '           Belian stok                                         ', 0, 1, '2020-11-23 17:27:50'),
(8, 'KXMPYNMp', 'nasuha7727', 'mail641796', 'PAKEJ RM 20', 'IRONING AID', 20, 'nasuha77271606124554.jpg', 1, '       Belian peribadi                     ', 0, 1, '2020-11-23 17:42:34'),
(9, '55234fLC', 'mail641796', '', 'PAKEJ RM 50', 'KOPI ZURIAT', 100, 'mail6417961606126039.jpg', 2, '   Belian Stok                                                ', 0, 1, '2020-11-23 18:07:19'),
(10, '55234fLC', 'Nani@g3700', 'mail641796', 'PAKEJ RM 50', 'KOPI ZURIAT', 50, 'Transfer Stock By Stokist', 1, 'mail641796', 1, 1, '2020-11-23 18:13:21'),
(11, '55Rl3fLA', 'Akmal.3824', 'mail641796', 'PAKEJ RM 10', 'PERFUME 5ml', 10, 'Transfer Stock By Stokist', 1, 'mail641796', 1, 1, '2020-11-24 01:20:33'),
(12, '55Rl3fLA', 'edda19548', 'mail641796', 'PAKEJ RM 10', 'PERFUME 5ml', 10, 'Transfer Stock By Stokist', 1, 'mail641796', 1, 1, '2020-11-24 14:37:13'),
(13, '55Rl3fLA', 'Mrkay@2803', 'mail641796', 'PAKEJ RM 10', 'PERFUME 5ml', 10, 'Transfer Stock By Stokist', 1, 'mail641796', 1, 1, '2020-11-24 15:24:40'),
(14, '55Rl3fLA', 'abmi196011', 'mail641796', 'PAKEJ RM 10', 'PERFUME 5ml', 10, 'Transfer Stock By Stokist', 1, 'mail641796', 1, 1, '2020-11-24 15:51:10'),
(15, '55234fLD', 'mail641796', '', 'PAKEJ RM 120', 'PERFUME 4mlx24 BOTOL', 240, 'mail6417961606231395.jpeg', 2, '        Belian stok                                            ', 0, 1, '2020-11-24 23:23:15'),
(16, '55Rl3fLA', 'Hafid@5573', 'MYDAYANAS', 'PAKEJ RM 10', 'PERFUME 5ml', 10, 'Transfer Stock By Stokist', 1, 'MYDAYANAS', 1, 1, '2020-11-24 23:41:17'),
(17, '55Rl3fLA', 'Mawies5558', 'MYDAYANAS', 'PAKEJ RM 10', 'PERFUME 5ml', 10, 'Transfer Stock By Stokist', 1, 'MYDAYANAS', 1, 1, '2020-11-25 00:01:39'),
(18, '55Rl3fLA', 'Migric1776', 'MYDAYANAS', 'PAKEJ RM 10', 'PERFUME 5ml', 10, 'Transfer Stock By Stokist', 1, 'MYDAYANAS', 1, 1, '2020-11-25 00:05:00'),
(19, '55234fLD', 'Syukri7591', 'mail641796', 'PAKEJ RM 120', 'PERFUME 4mlx24 BOTOL', 120, 'Transfer Stock By Stokist', 1, 'mail641796', 1, 1, '2020-11-25 01:46:20'),
(20, '55Rl3fLA', 'mazlan3134', 'mail641796', 'PAKEJ RM 10', 'PERFUME 5ml', 10, 'mazlan31341606241095.jpeg', 1, '         Belian peribadi                   ', 0, 1, '2020-11-25 02:04:55'),
(21, '55Rl3fLA', 'HAFID@5573', '', 'PAKEJ RM 10', 'PERFUME 5ml', 100, 'HAFID@55731606243089.jpeg', 10, '        Belian stok                                            ', 0, 1, '2020-11-25 02:38:09'),
(22, '55Rl3fLA', 'Iwan@g1268', 'mail641796', 'PAKEJ RM 10', 'PERFUME 5ml', 10, 'Transfer Stock By Stokist', 1, 'mail641796', 1, 1, '2020-11-25 18:28:54'),
(23, '55Rl3fLA', 'Dinbah760', 'mail641796', 'PAKEJ RM 10', 'PERFUME 5ml', 10, 'Transfer Stock By Stokist', 1, 'mail641796', 1, 1, '2020-11-25 18:38:06'),
(24, '55Rl3fLA', 'Zakiru2307', 'mail641796', 'PAKEJ RM 10', 'PERFUME 5ml', 10, 'Transfer Stock By Stokist', 1, 'mail641796', 1, 1, '2020-11-26 01:17:41'),
(25, '55Rl3fLA', 'Subari1004', 'mail641796', 'PAKEJ RM 10', 'PERFUME 5ml', 10, 'Transfer Stock By Stokist', 1, 'mail641796', 1, 1, '2020-11-26 01:31:01'),
(26, '55Rl3fLA', 'mail641796', '', 'PAKEJ RM 10', 'PERFUME 5ml', 100, 'mail6417961606326838.jpeg', 10, '        Belian stok                                            ', 0, 1, '2020-11-26 01:53:58'),
(27, '55Rl3fLA', 'Hussin6993', 'mail641796', 'PAKEJ RM 10', 'PERFUME 5ml', 10, 'Transfer Stock By Stokist', 1, 'mail641796', 1, 1, '2020-11-26 02:08:28'),
(28, '55Rl3fLA', 'Zali@g2679', 'mail641796', 'PAKEJ RM 10', 'PERFUME 5ml', 10, 'Transfer Stock By Stokist', 1, 'mail641796', 1, 1, '2020-11-26 11:09:04'),
(29, '55Rl3fLA', 'Petani2039', 'mail641796', 'PAKEJ RM 10', 'PERFUME 5ml', 10, 'Transfer Stock By Stokist', 1, 'mail641796', 1, 1, '2020-11-26 13:06:50'),
(30, '55Rl3fLA', 'Viossi4939', 'mail641796', 'PAKEJ RM 10', 'PERFUME 5ml', 10, 'Transfer Stock By Stokist', 1, 'mail641796', 1, 1, '2020-11-26 13:23:44'),
(31, '55Rl3fLA', 'Lanang5960', 'mail641796', 'PAKEJ RM 10', 'PERFUME 5ml', 10, 'Transfer Stock By Stokist', 1, 'mail641796', 1, 1, '2020-11-26 15:08:35'),
(32, '55Rl3fLA', 'Yusuf@911', 'mail641796', 'PAKEJ RM 10', 'PERFUME 5ml', 10, 'Transfer Stock By Stokist', 1, 'mail641796', 1, 1, '2020-11-26 18:04:04'),
(33, '55Rl3fLA', 'Idah837701', 'mail641796', 'PAKEJ RM 10', 'PERFUME 5ml', 10, 'Transfer Stock By Stokist', 1, 'mail641796', 1, 1, '2020-11-26 18:16:33'),
(34, '55Rl3fLA', 'Mazlan3134', 'mail641796', 'PAKEJ RM 10', 'PERFUME 5ml', 10, 'Transfer Stock By Stokist', 1, 'mail641796', 1, 1, '2020-11-27 12:37:34'),
(35, '55Rl3fLA', 'Mrkay@2803', 'mail641796', 'PAKEJ RM 10', 'PERFUME 5ml', 10, 'Transfer Stock By Stokist', 1, 'mail641796', 1, 1, '2020-11-27 12:52:10'),
(36, '55Rl3fLA', 'Assimk2840', 'mail641796', 'PAKEJ RM 10', 'PERFUME 5ml', 10, 'Transfer Stock By Stokist', 1, 'mail641796', 1, 1, '2020-11-27 22:23:03'),
(37, '55234fLC', 'Alifra6329', 'mail641796', 'PAKEJ RM 50', 'KOPI ZURIAT', 50, 'Transfer Stock By Stokist', 1, 'mail641796', 1, 1, '2020-11-28 09:51:40'),
(38, '55Rl3fLA', 'mail641796', '', 'PAKEJ RM 10', 'PERFUME 5ml', 100, 'mail6417961606549078.jpg', 10, '        Belian stok                                            ', 0, 1, '2020-11-28 15:37:58'),
(39, '55Rl3fLA', 'Smbg819488', 'mail641796', 'PAKEJ RM 10', 'PERFUME 5ml', 10, 'Transfer Stock By Stokist', 1, 'mail641796', 1, 1, '2020-11-28 15:58:41'),
(40, '55Rl3fLA', 'MAWIES5558', '', 'PAKEJ RM 10', 'PERFUME 5ml', 300, 'MAWIES55581606630261.jpg', 30, '                                                    free stok', 0, 1, '2020-11-29 14:11:01'),
(41, '55Rl3fLA', 'mawies4089', 'MAWIES5558', 'PAKEJ RM 10', 'PERFUME 5ml', 10, 'Transfer Stock By Stokist', 1, 'MAWIES5558', 1, 1, '2020-11-29 14:16:42'),
(42, '55Rl3fLA', 'FAMILY8413', 'MAWIES5558', 'PAKEJ RM 10', 'PERFUME 5ml', 10, 'Transfer Stock By Stokist', 1, 'MAWIES5558', 1, 1, '2020-11-29 14:19:54'),
(43, '55Rl3fLA', 'HJJABA6109', 'MAWIES5558', 'PAKEJ RM 10', 'PERFUME 5ml', 10, 'Transfer Stock By Stokist', 1, 'MAWIES5558', 1, 1, '2020-11-29 14:20:27'),
(44, '55Rl3fLA', 'XSMKTJ5205', 'MAWIES5558', 'PAKEJ RM 10', 'PERFUME 5ml', 10, 'Transfer Stock By Stokist', 1, 'MAWIES5558', 1, 1, '2020-11-29 14:21:30'),
(45, '55Rl3fLA', 'HJSULA8517', 'MAWIES5558', 'PAKEJ RM 10', 'PERFUME 5ml', 10, 'Transfer Stock By Stokist', 1, 'MAWIES5558', 1, 1, '2020-11-29 14:21:54'),
(46, '55Rl3fLA', 'FAMILY4514', 'MAWIES5558', 'PAKEJ RM 10', 'PERFUME 5ml', 10, 'Transfer Stock By Stokist', 1, 'MAWIES5558', 1, 1, '2020-11-29 18:52:15'),
(47, '55Rl3fLA', 'SYARAZ1222', 'MAWIES5558', 'PAKEJ RM 10', 'PERFUME 5ml', 10, 'Transfer Stock By Stokist', 1, 'MAWIES5558', 1, 1, '2020-11-29 18:52:44'),
(48, '55Rl3fLA', 'AYUZZA9419', 'MAWIES5558', 'PAKEJ RM 10', 'PERFUME 5ml', 10, 'Transfer Stock By Stokist', 1, 'MAWIES5558', 1, 1, '2020-11-29 18:53:07'),
(49, '55Rl3fLA', 'YAYIN@5542', 'MAWIES5558', 'PAKEJ RM 10', 'PERFUME 5ml', 10, 'Transfer Stock By Stokist', 1, 'MAWIES5558', 1, 1, '2020-11-29 19:22:22'),
(50, '55Rl3fLA', 'MAWIES7008', 'MAWIES5558', 'PAKEJ RM 10', 'PERFUME 5ml', 10, 'Transfer Stock By Stokist', 1, 'MAWIES5558', 1, 1, '2020-11-29 19:22:43'),
(51, '55Rl3fLA', 'IJULSA3301', 'MAWIES5558', 'PAKEJ RM 10', 'PERFUME 5ml', 10, 'Transfer Stock By Stokist', 1, 'MAWIES5558', 1, 1, '2020-11-29 19:26:15'),
(52, '55Rl3fLA', 'NASALB3560', 'MAWIES5558', 'PAKEJ RM 10', 'PERFUME 5ml', 10, 'Transfer Stock By Stokist', 1, 'MAWIES5558', 1, 1, '2020-11-29 19:26:38'),
(53, '55Rl3fLA', 'YUKINI4381', 'MAWIES5558', 'PAKEJ RM 10', 'PERFUME 5ml', 10, 'Transfer Stock By Stokist', 1, 'MAWIES5558', 1, 1, '2020-11-29 19:26:59'),
(54, '55Rl3fLA', 'BOYROY3148', 'MAWIES5558', 'PAKEJ RM 10', 'PERFUME 5ml', 10, 'Transfer Stock By Stokist', 1, 'MAWIES5558', 1, 1, '2020-11-29 19:27:28'),
(55, '55Rl3fLA', 'SUBAGI8144', 'MAWIES5558', 'PAKEJ RM 10', 'PERFUME 5ml', 10, 'Transfer Stock By Stokist', 1, 'MAWIES5558', 1, 1, '2020-11-29 19:27:48'),
(56, '55Rl3fLA', 'FADZLI7433', 'MAWIES5558', 'PAKEJ RM 10', 'PERFUME 5ml', 10, 'Transfer Stock By Stokist', 1, 'MAWIES5558', 1, 1, '2020-11-29 19:35:10'),
(57, '55Rl3fLA', 'ALI61@6837', 'MAWIES5558', 'PAKEJ RM 10', 'PERFUME 5ml', 10, 'Transfer Stock By Stokist', 1, 'MAWIES5558', 1, 1, '2020-11-29 19:35:31'),
(58, '55Rl3fLA', 'BASHID7631', 'MAWIES5558', 'PAKEJ RM 10', 'PERFUME 5ml', 10, 'Transfer Stock By Stokist', 1, 'MAWIES5558', 1, 1, '2020-11-29 19:37:59'),
(59, '55Rl3fLA', 'SURYA96845', 'MAWIES5558', 'PAKEJ RM 10', 'PERFUME 5ml', 10, 'Transfer Stock By Stokist', 1, 'MAWIES5558', 1, 1, '2020-11-29 19:38:19'),
(60, '55Rl3fLA', 'NORAIN8261', 'MAWIES5558', 'PAKEJ RM 10', 'PERFUME 5ml', 10, 'Transfer Stock By Stokist', 1, 'MAWIES5558', 1, 1, '2020-11-29 19:38:40'),
(61, '55Rl3fLA', 'EZZY014040', 'MAWIES5558', 'PAKEJ RM 10', 'PERFUME 5ml', 10, 'Transfer Stock By Stokist', 1, 'MAWIES5558', 1, 1, '2020-11-29 19:38:59'),
(62, '55Rl3fLA', 'YUKINI824', 'MAWIES5558', 'PAKEJ RM 10', 'PERFUME 5ml', 10, 'Transfer Stock By Stokist', 1, 'MAWIES5558', 1, 1, '2020-11-29 19:39:46'),
(63, '55Rl3fLA', 'LEHO766157', 'MAWIES5558', 'PAKEJ RM 10', 'PERFUME 5ml', 10, 'Transfer Stock By Stokist', 1, 'MAWIES5558', 1, 1, '2020-11-29 19:40:22'),
(64, '55Rl3fLA', 'MIGRIC1776', '', 'PAKEJ RM 10', 'PERFUME 5ml', 100, 'MIGRIC17761606652124.jpg', 10, '                                                    free stok', 0, 1, '2020-11-29 20:15:24'),
(65, '55Rl3fLA', 'LAILAR3373', 'MIGRIC1776', 'PAKEJ RM 10', 'PERFUME 5ml', 10, 'LAILAR33731606652452.jpg', 1, '                            ', 0, 1, '2020-11-29 20:20:52'),
(66, '55Rl3fLA', 'MAN58@7741', 'MIGRIC1776', 'PAKEJ RM 10', 'PERFUME 5ml', 10, 'MAN58@77411606652509.jpg', 1, '                            ', 0, 1, '2020-11-29 20:21:49'),
(67, '55Rl3fLA', 'RCIEKD2837', 'HAFID@5573', 'PAKEJ RM 10', 'PERFUME 5ml', 10, 'Transfer Stock By Stokist', 1, 'HAFID@5573', 1, 1, '2020-11-29 20:45:17'),
(68, '55Rl3fLA', 'ZAINUR5204', 'HAFID@5573', 'PAKEJ RM 10', 'PERFUME 5ml', 10, 'Transfer Stock By Stokist', 1, 'HAFID@5573', 1, 1, '2020-11-29 20:45:40'),
(69, '55Rl3fLA', 'AHMADZ2061', 'HAFID@5573', 'PAKEJ RM 10', 'PERFUME 5ml', 10, 'Transfer Stock By Stokist', 1, 'HAFID@5573', 1, 1, '2020-11-29 20:46:05'),
(70, '55Rl3fLA', 'MU7MET1213', 'HAFID@5573', 'PAKEJ RM 10', 'PERFUME 5ml', 10, 'Transfer Stock By Stokist', 1, 'HAFID@5573', 1, 1, '2020-11-29 20:46:34'),
(71, '55Rl3fLA', 'AMBOFA8373', 'HAFID@5573', 'PAKEJ RM 10', 'PERFUME 5ml', 10, 'Transfer Stock By Stokist', 1, 'HAFID@5573', 1, 1, '2020-11-29 20:47:02'),
(72, '55Rl3fLA', 'Naim@g724', 'mail641796', 'PAKEJ RM 10', 'PERFUME 5ml', 10, 'Transfer Stock By Stokist', 1, 'mail641796', 1, 1, '2020-11-30 02:35:10'),
(73, '55Rl3fLA', 'petani2039', '', 'PAKEJ RM 10', 'PERFUME 5ml', 50, 'petani20391606727626.jpg', 5, '            Belian stok                                        ', 0, 1, '2020-11-30 17:13:46'),
(74, 'FECceo7u', 'MYDAYANAS', '', 'PAKEJ RM 10', 'CAR / HOME PERFUME', 50, 'MYDAYANAS1607621242.png', 5, '                                                    ', 0, 1, '2020-12-11 01:27:22'),
(75, 'FECceo7u', 'zanmaa9537', '', 'PAKEJ RM 10', 'CAR / HOME PERFUME', 50, 'zanmaa95371607622085.jpeg', 5, '          Belian stok                                        ', 0, 1, '2020-12-11 01:41:25'),
(76, '55Rl3fLA', 'zanmaa9537', '', 'PAKEJ RM 10', 'PERFUME 5ml', 50, 'zanmaa95371607622168.jpeg', 5, '         Belian stok                                           ', 0, 1, '2020-12-11 01:42:48'),
(77, '55Rl3fLA', 'Khidir4032', 'mail641796', 'PAKEJ RM 10', 'PERFUME 5ml', 10, 'Transfer Stock By Stokist', 1, 'mail641796', 1, 1, '2020-12-18 12:46:29'),
(78, 'FECceo7u', 'mail641796', '', 'PAKEJ RM 10', 'CAR / HOME PERFUME', 100, 'mail6417961608267646.jpeg', 10, '        Belian stok                                            ', 0, 1, '2020-12-18 13:00:46'),
(79, 'FECceo7u', 'Manan@5986', 'mail641796', 'PAKEJ RM 10', 'CAR / HOME PERFUME', 10, 'Transfer Stock By Stokist', 1, 'mail641796', 1, 1, '2020-12-18 13:34:51'),
(80, 'FECceo7u', 'Syafiq2805', 'mail641796', 'PAKEJ RM 10', 'CAR / HOME PERFUME', 10, 'Transfer Stock By Stokist', 1, 'mail641796', 1, 1, '2020-12-18 13:46:22'),
(81, '55Rl3fLA', 'Zanmaa9537', 'zanmaa9537', 'PAKEJ RM 10', 'PERFUME 5ml', 10, 'Transfer Stock By Stokist', 1, 'zanmaa9537', 1, 1, '2020-12-19 14:59:00'),
(82, 'FECceo7u', 'Sani@g2876', 'mail641796', 'PAKEJ RM 10', 'CAR / HOME PERFUME', 10, 'Transfer Stock By Stokist', 1, 'mail641796', 1, 1, '2020-12-21 10:40:54'),
(83, 'FECceo7u', 'Hussin3073', 'mail641796', 'PAKEJ RM 10', 'CAR / HOME PERFUME', 10, 'Transfer Stock By Stokist', 1, 'mail641796', 1, 1, '2020-12-23 16:36:47'),
(84, 'FECceo7u', 'Mydayanas', 'MYDAYANAS', 'PAKEJ RM 10', 'CAR / HOME PERFUME', 10, 'Transfer Stock By Stokist', 1, 'MYDAYANAS', 1, 1, '2020-12-24 01:13:18'),
(85, 'FECceo7u', 'Mail641796', 'mail641796', 'PAKEJ RM 10', 'CAR / HOME PERFUME', 10, 'Transfer Stock By Stokist', 1, 'mail641796', 1, 1, '2020-12-24 01:42:51'),
(86, 'FECceo7u', 'Akmal.3824', 'mail641796', 'PAKEJ RM 10', 'CAR / HOME PERFUME', 10, 'Transfer Stock By Stokist', 1, 'mail641796', 1, 1, '2020-12-25 15:04:19'),
(87, 'FECceo7u', 'Hamzah9548', 'mail641796', 'PAKEJ RM 10', 'CAR / HOME PERFUME', 10, 'Transfer Stock By Stokist', 1, 'mail641796', 1, 1, '2020-12-25 15:07:05'),
(88, 'FECceo7u', 'HAFID@5573', '', 'PAKEJ RM 10', 'CAR / HOME PERFUME', 50, 'HAFID@55731608969854.jpg', 5, '                                             Canopy       ', 0, 1, '2020-12-26 16:04:14'),
(89, 'FECceo7u', 'Zarina8983', 'mail641796', 'PAKEJ RM 10', 'CAR / HOME PERFUME', 10, 'Transfer Stock By Stokist', 1, 'mail641796', 1, 1, '2020-12-31 10:16:27'),
(90, 'FECceo7u', 'Sobiri1301', 'mail641796', 'PAKEJ RM 10', 'CAR / HOME PERFUME', 10, 'Transfer Stock By Stokist', 1, 'mail641796', 1, 1, '2020-12-31 10:19:13'),
(91, 'FECceo7u', 'Jalila2080', 'mail641796', 'PAKEJ RM 10', 'CAR / HOME PERFUME', 10, 'Transfer Stock By Stokist', 1, 'mail641796', 1, 1, '2021-01-01 22:32:44'),
(92, 'FECceo7u', 'mail641796', '', 'PAKEJ RM 10', 'CAR / HOME PERFUME', 100, 'mail6417961609523733.jpeg', 10, '        Belian stok                                            ', 0, 1, '2021-01-02 01:55:33'),
(93, '55Rl3fLA', 'Ajiba27667', 'mail641796', 'PAKEJ RM 10', 'PERFUME 5ml', 10, 'Transfer Stock By Stokist', 1, 'mail641796', 1, 1, '2021-01-02 02:08:01'),
(94, 'FECceo7u', 'ajiba27667', '', 'PAKEJ RM 10', 'CAR / HOME PERFUME', 50, 'ajiba276671609526241.jpeg', 5, '        Belian stok                                            ', 0, 1, '2021-01-02 02:37:21'),
(95, '55Rl3fLA', 'ajiba27667', '', 'PAKEJ RM 10', 'PERFUME 5ml', 50, 'ajiba276671609526299.jpeg', 5, '            Belian stok                                        ', 0, 1, '2021-01-02 02:38:19'),
(96, '55Rl3fLA', 'Ajiba2895', 'ajiba27667', 'PAKEJ RM 10', 'PERFUME 5ml', 10, 'Transfer Stock By Stokist', 1, 'ajiba27667', 1, 1, '2021-01-02 02:56:51'),
(97, 'FECceo7u', 'Ajiba28006', 'ajiba27667', 'PAKEJ RM 10', 'CAR / HOME PERFUME', 10, 'Transfer Stock By Stokist', 1, 'ajiba27667', 1, 1, '2021-01-02 03:03:38'),
(98, '55Rl3fLA', 'Ajiba23605', 'ajiba27667', 'PAKEJ RM 10', 'PERFUME 5ml', 10, 'Transfer Stock By Stokist', 1, 'ajiba27667', 1, 1, '2021-01-02 03:12:31'),
(99, '55Rl3fLA', 'Ajiba29179', 'ajiba27667', 'PAKEJ RM 10', 'PERFUME 5ml', 10, 'Transfer Stock By Stokist', 1, 'ajiba27667', 1, 1, '2021-01-02 09:30:24'),
(100, 'FECceo7u', 'Ajiba29255', 'ajiba27667', 'PAKEJ RM 10', 'CAR / HOME PERFUME', 10, 'Transfer Stock By Stokist', 1, 'ajiba27667', 1, 1, '2021-01-03 00:29:44'),
(101, 'FECceo7u', 'Ajiba25654', 'ajiba27667', 'PAKEJ RM 10', 'CAR / HOME PERFUME', 10, 'Transfer Stock By Stokist', 1, 'ajiba27667', 1, 1, '2021-01-03 01:52:39'),
(102, 'FECceo7u', 'Zali@g2679', 'mail641796', 'PAKEJ RM 10', 'CAR / HOME PERFUME', 10, 'Transfer Stock By Stokist', 1, 'mail641796', 1, 1, '2021-01-03 16:10:47'),
(103, 'FECceo7u', 'Acid@g315', 'mail641796', 'PAKEJ RM 10', 'CAR / HOME PERFUME', 10, 'Transfer Stock By Stokist', 1, 'mail641796', 1, 1, '2021-01-04 14:16:56'),
(104, '55Rl3fLA', 'Ngisa89871', 'ajiba27667', 'PAKEJ RM 10', 'PERFUME 5ml', 10, 'Transfer Stock By Stokist', 1, 'ajiba27667', 1, 1, '2021-01-04 15:20:49'),
(105, 'FECceo7u', 'Samsct8418', 'ajiba27667', 'PAKEJ RM 10', 'CAR / HOME PERFUME', 10, 'Transfer Stock By Stokist', 1, 'ajiba27667', 1, 1, '2021-01-05 02:13:13'),
(106, 'FECceo7u', 'ajiba27667', '', 'PAKEJ RM 10', 'CAR / HOME PERFUME', 10, 'ajiba276671609787306.jpg', 1, '          Belian stok                                          ', 0, 0, '2021-01-05 03:08:26'),
(107, '55Rl3fLA', 'ajiba27667', '', 'PAKEJ RM 10', 'PERFUME 5ml', 10, 'ajiba276671609787373.jpg', 1, '         Belian stok                                           ', 0, 0, '2021-01-05 03:09:33'),
(108, 'FECceo7u', 'ajiba27667', '', 'PAKEJ RM 10', 'CAR / HOME PERFUME', 10, 'ajiba276671609788117.jpg', 1, '          Belian stok                                          ', 0, 0, '2021-01-05 03:21:57'),
(109, 'FECceo7u', 'Kopera5300', 'zanmaa9537', 'PAKEJ RM 10', 'CAR / HOME PERFUME', 10, 'Transfer Stock By Stokist', 1, 'zanmaa9537', 1, 1, '2021-01-06 00:47:18'),
(110, 'FECceo7u', 'Izan@g445', 'zanmaa9537', 'PAKEJ RM 10', 'CAR / HOME PERFUME', 10, 'Transfer Stock By Stokist', 1, 'zanmaa9537', 1, 1, '2021-01-06 01:11:14'),
(111, 'FECceo7u', 'zanmaa9537', '', 'PAKEJ RM 10', 'CAR / HOME PERFUME', 120, 'zanmaa95371609868713.jpeg', 12, '         Belian stok                                           ', 0, 1, '2021-01-06 01:45:13'),
(112, 'FECceo7u', 'Nisa@g9604', 'zanmaa9537', 'PAKEJ RM 10', 'CAR / HOME PERFUME', 10, 'Transfer Stock By Stokist', 1, 'zanmaa9537', 1, 1, '2021-01-06 02:25:51'),
(113, 'FECceo7u', 'Zarina5280', 'zanmaa9537', 'PAKEJ RM 10', 'CAR / HOME PERFUME', 10, 'Transfer Stock By Stokist', 1, 'zanmaa9537', 1, 1, '2021-01-06 02:55:57'),
(114, 'FECceo7u', 'Rudhit7663', 'zanmaa9537', 'PAKEJ RM 10', 'CAR / HOME PERFUME', 10, 'Transfer Stock By Stokist', 1, 'zanmaa9537', 1, 1, '2021-01-06 16:23:13'),
(115, 'FECceo7u', 'Janiah6881', 'zanmaa9537', 'PAKEJ RM 10', 'CAR / HOME PERFUME', 10, 'Transfer Stock By Stokist', 1, 'zanmaa9537', 1, 1, '2021-01-06 16:29:06'),
(116, 'FECceo7u', 'Norain1080', 'zanmaa9537', 'PAKEJ RM 10', 'CAR / HOME PERFUME', 10, 'Transfer Stock By Stokist', 1, 'zanmaa9537', 1, 1, '2021-01-06 16:40:56'),
(117, 'FECceo7u', 'Haron@1209', 'zanmaa9537', 'PAKEJ RM 10', 'CAR / HOME PERFUME', 10, 'Transfer Stock By Stokist', 1, 'zanmaa9537', 1, 1, '2021-01-06 16:47:07'),
(118, 'FECceo7u', 'Saidah8785', 'zanmaa9537', 'PAKEJ RM 10', 'CAR / HOME PERFUME', 10, 'Transfer Stock By Stokist', 1, 'zanmaa9537', 1, 1, '2021-01-06 16:54:09'),
(119, 'FECceo7u', 'Azmidi6650', 'zanmaa9537', 'PAKEJ RM 10', 'CAR / HOME PERFUME', 10, 'Transfer Stock By Stokist', 1, 'zanmaa9537', 1, 1, '2021-01-06 17:00:23'),
(120, 'FECceo7u', 'Firdau1504', 'zanmaa9537', 'PAKEJ RM 10', 'CAR / HOME PERFUME', 10, 'Transfer Stock By Stokist', 1, 'zanmaa9537', 1, 1, '2021-01-06 17:06:59'),
(121, 'FECceo7u', 'ajiba28006', 'MYDAYANAS', 'PAKEJ RM 10', 'CAR / HOME PERFUME', 10, 'ajiba280061610631459.png', 1, '  11                          ', 0, 1, '2021-01-14 21:37:39'),
(122, 'FECceo7u', 'ajiba23605', 'MYDAYANAS', 'PAKEJ RM 10', 'CAR / HOME PERFUME', 10, 'ajiba236051610631653.png', 1, '111                            ', 0, 1, '2021-01-14 21:40:53'),
(123, 'FECceo7u', 'ajiba25654', 'MYDAYANAS', 'PAKEJ RM 10', 'CAR / HOME PERFUME', 10, 'ajiba256541610631841.png', 1, ' 11                           ', 0, 1, '2021-01-14 21:44:01'),
(124, 'FECceo7u', 'ajiba29255', 'MYDAYANAS', 'PAKEJ RM 10', 'CAR / HOME PERFUME', 10, 'ajiba292551610631944.png', 1, ' 11                           ', 0, 1, '2021-01-14 21:45:44'),
(125, '55Rl3fLA', 'ajiba25654', 'MYDAYANAS', 'PAKEJ RM 10', 'PERFUME 5ml', 10, 'ajiba256541610632221.png', 1, '  1111                          ', 0, 1, '2021-01-14 21:50:21'),
(126, 'FECceo7u', 'ajiba28006', 'ajiba27667', 'PAKEJ RM 10', 'CAR / HOME PERFUME', 10, 'ajiba280061610632919.png', 1, '  1111                          ', 0, 1, '2021-01-14 22:01:59');

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

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

--
-- Dumping data for table `package_stock`
--

INSERT INTO `package_stock` (`id`, `package_code`, `ref_code`, `package_name`, `package_item_name`, `package_price`, `quantity`, `status`, `created_date`) VALUES
(40, '55Rl3fLA', 'MYDAYANAS', 'PAKEJ RM 10', 'PERFUME 5ml', 10, 3, 1, '2020-11-23 13:59:15'),
(41, '55Rl3fLA', 'mail641796', 'PAKEJ RM 10', 'PERFUME 5ml', 10, 6, 1, '2020-11-23 14:35:57'),
(42, 'KXMPYNMp', 'mail641796', 'PAKEJ RM 20', 'IRONING AID', 20, 4, 1, '2020-11-23 17:30:33'),
(43, '55234fLC', 'mail641796', 'PAKEJ RM 50', 'KOPI ZURIAT', 50, 0, 1, '2020-11-23 18:09:15'),
(44, '55234fLD', 'mail641796', 'PAKEJ RM 120', 'PERFUME 4mlx24 BOTOL', 120, 1, 1, '2020-11-24 23:27:21'),
(45, '55Rl3fLA', 'HAFID@5573', 'PAKEJ RM 10', 'PERFUME 5ml', 10, 5, 1, '2020-11-25 02:39:35'),
(46, '55Rl3fLA', 'MAWIES5558', 'PAKEJ RM 10', 'PERFUME 5ml', 10, 7, 1, '2020-11-29 14:11:38'),
(47, '55Rl3fLA', 'MIGRIC1776', 'PAKEJ RM 10', 'PERFUME 5ml', 10, 8, 1, '2020-11-29 20:16:16'),
(48, '55Rl3fLA', 'petani2039', 'PAKEJ RM 10', 'PERFUME 5ml', 10, 5, 1, '2020-11-30 17:15:44'),
(49, 'FECceo7u', 'MYDAYANAS', 'PAKEJ RM 10', 'CAR / HOME PERFUME', 10, 0, 1, '2020-12-11 01:29:05'),
(50, 'FECceo7u', 'zanmaa9537', 'PAKEJ RM 10', 'CAR / HOME PERFUME', 10, 6, 1, '2020-12-11 01:45:25'),
(51, '55Rl3fLA', 'zanmaa9537', 'PAKEJ RM 10', 'PERFUME 5ml', 10, 4, 1, '2020-12-11 01:45:49'),
(52, 'FECceo7u', 'mail641796', 'PAKEJ RM 10', 'CAR / HOME PERFUME', 10, 8, 1, '2020-12-18 13:29:35'),
(53, 'FECceo7u', 'HAFID@5573', 'PAKEJ RM 10', 'CAR / HOME PERFUME', 10, 5, 1, '2020-12-26 23:22:07'),
(54, 'FECceo7u', 'ajiba27667', 'PAKEJ RM 10', 'CAR / HOME PERFUME', 10, 0, 1, '2021-01-02 02:40:34'),
(55, '55Rl3fLA', 'ajiba27667', 'PAKEJ RM 10', 'PERFUME 5ml', 10, 1, 1, '2021-01-02 02:40:46');

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

--
-- 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 `product_price_setting`
--

CREATE TABLE `product_price_setting` (
  `id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `level_id` int(11) NOT NULL,
  `level_number` int(11) NOT NULL,
  `level_name` varchar(100) NOT NULL,
  `price` double NOT NULL,
  `commission` double NOT NULL,
  `status` int(11) NOT NULL,
  `created_date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `product_price_setting`
--

INSERT INTO `product_price_setting` (`id`, `product_id`, `level_id`, `level_number`, `level_name`, `price`, `commission`, `status`, `created_date`) VALUES
(25, 10, 1, 1, 'Master Stokis', 0, 50, 1, '2021-02-16 13:49:39'),
(26, 10, 2, 2, 'Stokis', 0, 40, 1, '2021-02-16 13:49:39'),
(27, 10, 3, 3, 'Agent', 0, 30, 1, '2021-02-16 13:49:39'),
(28, 10, 4, 4, 'Dropship', 0, 20, 1, '2021-02-16 13:49:39'),
(30, 9, 3, 3, 'Agent', 0, 30, 1, '2021-02-25 22:14:44'),
(31, 9, 2, 2, 'Stokis', 0, 40, 1, '2021-02-25 22:14:55'),
(32, 9, 1, 1, 'Master Stokis', 0, 50, 1, '2021-02-25 22:15:05'),
(33, 9, 4, 4, 'Dropship', 0, 20, 1, '2021-03-03 01:00:22');

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

--
-- Table structure for table `product_setting`
--

CREATE TABLE `product_setting` (
  `id` int(11) NOT NULL,
  `prod_name` varchar(100) NOT NULL,
  `prod_image` varchar(100) NOT NULL,
  `prod_price` double NOT NULL,
  `prod_stock` int(11) NOT NULL,
  `prod_desc` varchar(10000) NOT NULL,
  `starter` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  `created_date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `product_setting`
--

INSERT INTO `product_setting` (`id`, `prod_name`, `prod_image`, `prod_price`, `prod_stock`, `prod_desc`, `starter`, `status`, `created_date`) VALUES
(5, 'Item 1', 'mPPC6N0w1612682936.png', 100, 500, '<p><font color=\"#555555\" face=\"Quicksand, sans-serif\"><span style=\"font-size: 16px;\"><b>Item 1</b></span></font><br style=\"color: rgb(85, 85, 85); font-family: Quicksand, sans-serif; font-size: 16px;\"><br style=\"color: rgb(85, 85, 85); font-family: Quicksand, sans-serif; font-size: 16px;\"><span style=\"color: rgb(85, 85, 85); font-family: Quicksand, sans-serif; font-size: 16px;\">The <b>ONE &amp; O</b>NLY enhanced supplement for woman that can definitely change your LIFE</span><span style=\"color: rgb(85, 85, 85); font-family: Quicksand, sans-serif; font-size: 16px;\">!<br><br>Fountain of youth supplement<br>Breast enhancement and firmness<br>Larger breasts and rounder butt<br>Vaginal tightening and rejuvenation<br>Vaginal health and libido<br>Maintain collagen and elastin levels<br>More youthful-looking complexion and firmer skin<br>Less brittle, gray hair and reduce hair fall<br>Effective for weight loss<br>Age-defying, anti-aging<br>Helps to protect against wrinkles<br>Improve blood flow<br>Prevent risks of osteoporosis<br>Against symptoms of menopause</span><br></p>', 0, 9, '2021-02-07 15:28:56'),
(6, 'Item 2', 'NZ0SpLsS1612683053.jpg', 100, 500, '<p><span style=\"color: rgb(85, 85, 85); font-family: Quicksand, sans-serif; font-size: 16px;\">Help support a healthy im</span><span style=\"color: rgb(85, 85, 85); font-family: Quicksand, sans-serif; font-size: 16px;\">mune system<br><br>Helps digestion<br><br>Increase energy and metabolism<br><br>Rich in fiber, vitamins and biotin compunds.<br><br>Maintain healthy skin &amp; nails<br><br>Powerful antioxidant<br><br>Promotes healthy hair growth<br><br>Strong Nails. It makes your nails grow faster and stronger.<br><br>1 bottle = 60 chewable candies<br>Strawberry flavour</span><br></p>', 0, 9, '2021-02-07 15:30:53'),
(7, 'Item3', 'GHrHI2Nl1612683064.png', 100, 500, '<p><span style=\"color: rgb(85, 85, 85); font-family: Quicksand, sans-serif; font-size: 16px;\">Help support a healthy im</span><span style=\"color: rgb(85, 85, 85); font-family: Quicksand, sans-serif; font-size: 16px;\">mune system<br><br>Helps digestion<br><br>Increase energy and metabolism<br><br>Rich in fiber, vitamins and biotin compunds.<br><br>Maintain healthy skin &amp; nails<br><br>Powerful antioxidant<br><br>Promotes healthy hair growth<br><br>Strong Nails. It makes your nails grow faster and stronger.<br><br>1 bottle = 60 chewable candies<br>Strawberry flavour</span><br></p>', 0, 9, '2021-02-07 15:31:04'),
(8, 'Item4', '6tQgUfsq1612683078.jpg', 100, 500, '<p><span style=\"color: rgb(85, 85, 85); font-family: Quicksand, sans-serif; font-size: 16px;\">Help support a healthy im</span><span style=\"color: rgb(85, 85, 85); font-family: Quicksand, sans-serif; font-size: 16px;\">mune system<br><br>Helps digestion<br><br>Increase energy and metabolism<br><br>Rich in fiber, vitamins and biotin compunds.<br><br>Maintain healthy skin &amp; nails<br><br>Powerful antioxidant<br><br>Promotes healthy hair growth<br><br>Strong Nails. It makes your nails grow faster and stronger.<br><br>1 bottle = 60 chewable candies<br>Strawberry flavour</span><br></p>', 0, 9, '2021-02-07 15:31:18'),
(9, 'HerbalistLab Oil', 'Q5IbAb6B1613034185.jpeg', 90, 9991, '<p>minyak herbalistlab terbaik</p>', 1, 1, '2021-02-11 17:03:05'),
(10, 'HerbalistLab Oil 3 package', 'ns6Junx81613454579.jpeg', 200, 9991, '<p>full recovery</p>', 0, 1, '2021-02-16 13:49:39');

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

--
-- Table structure for table `support_ticket`
--

CREATE TABLE `support_ticket` (
  `id` int(11) NOT NULL,
  `ref_code` varchar(100) NOT NULL,
  `subject` varchar(100) NOT NULL,
  `priority` varchar(100) NOT NULL,
  `category` varchar(100) NOT NULL,
  `comment` varchar(10000) NOT NULL,
  `status` int(11) NOT NULL,
  `created_date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `support_ticket`
--

INSERT INTO `support_ticket` (`id`, `ref_code`, `subject`, `priority`, `category`, `comment`, `status`, `created_date`) VALUES
(1, 'Ash@gm404', 'subject', 'Medium', 'Pay In', '&lt;ul&gt;&lt;li&gt;Test&lt;/li&gt;&lt;li&gt;2&lt;/li&gt;&lt;li&gt;2&lt;/li&gt;&lt;li&gt;2&lt;/li&gt;&lt;li&gt;2&lt;/li&gt;&lt;li&gt;&lt;br&gt;&lt;/li&gt;&lt;/ul&gt;', 1, '2021-02-01 23:32:49');

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

--
-- Table structure for table `support_ticket_conversation`
--

CREATE TABLE `support_ticket_conversation` (
  `id` int(11) NOT NULL,
  `support_ticket_id` int(11) NOT NULL,
  `user_level` int(11) NOT NULL,
  `ref_code` varchar(100) NOT NULL,
  `comment` varchar(10000) 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,
  `commission_type` varchar(100) NOT 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;

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

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

CREATE TABLE `user` (
  `id` int(11) NOT NULL,
  `email` varchar(100) DEFAULT NULL,
  `password` varchar(100) DEFAULT NULL,
  `sponsor_id` int(11) NOT NULL,
  `sponsor_code` varchar(100) DEFAULT NULL,
  `sponsor_last_name` varchar(100) NOT NULL,
  `ref_code` varchar(100) DEFAULT NULL,
  `level` int(11) DEFAULT NULL,
  `rank` int(11) NOT NULL,
  `rank_change_request` varchar(10) NOT NULL,
  `type_of_user` varchar(100) NOT NULL,
  `name` varchar(100) DEFAULT NULL,
  `last_name` varchar(100) NOT NULL,
  `paid` int(11) DEFAULT NULL,
  `nick_name` varchar(100) DEFAULT NULL,
  `phone_number` varchar(100) DEFAULT NULL,
  `phone_number_2` varchar(100) NOT NULL,
  `profile_image` varchar(100) DEFAULT NULL,
  `no_ic` varchar(100) DEFAULT NULL,
  `ic_front` varchar(100) NOT NULL,
  `ic_back` varchar(100) NOT NULL,
  `address` varchar(200) DEFAULT NULL,
  `address_2` varchar(100) NOT 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,
  `herbalist_news` int(11) NOT NULL,
  `facebook_link` varchar(100) NOT NULL,
  `whatsapp_link` varchar(100) NOT NULL,
  `instagram_link` varchar(100) NOT NULL,
  `linkedin_link` varchar(100) NOT NULL,
  `twitter_link` varchar(100) NOT NULL,
  `youtube_link` varchar(100) NOT NULL,
  `tiktok_link` varchar(100) NOT NULL,
  `purchase_status` varchar(10) NOT NULL,
  `spouse_status` varchar(10) NOT NULL,
  `wallet_status` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `created_date` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

INSERT INTO `user` (`id`, `email`, `password`, `sponsor_id`, `sponsor_code`, `sponsor_last_name`, `ref_code`, `level`, `rank`, `rank_change_request`, `type_of_user`, `name`, `last_name`, `paid`, `nick_name`, `phone_number`, `phone_number_2`, `profile_image`, `no_ic`, `ic_front`, `ic_back`, `address`, `address_2`, `state`, `area`, `postcode`, `country`, `birth_date`, `bank_type`, `acc_no`, `acc_holder`, `remark`, `herbalist_news`, `facebook_link`, `whatsapp_link`, `instagram_link`, `linkedin_link`, `twitter_link`, `youtube_link`, `tiktok_link`, `purchase_status`, `spouse_status`, `wallet_status`, `status`, `created_date`) VALUES
(2, 'admin@roxel-shop.com', 'Adm#$1in', 0, '', '', 'RA0001000', 1, 0, '', 'Admin', 'AdminHerbaList', 'Adm', 0, 'admin@roxel-shop.com', '0178707204', '', 'AdminMyDayanas1601631538.jpg', '10101010101010', '', '', ' No 200, jalan kasturi                                                                                                                                                           ', '', '', '', '', '', '', 'DEUTSCHE BANK (MSIA) BERHAD', '12020123231', 'HQ', '', 0, '', '', '', '', '', '', '', '', '', 0, 1, '0000-00-00 00:00:00'),
(32, 'argusbip@gmail.com', '5YOGBKCX', 2, 'RA0001000', '', 'RA0001001', 2, 4, '', 'Dropship', 'Muhammad', 'Mustaffa', NULL, 'Supreme Leader', '01111464679', '', NULL, NULL, '', '', NULL, '', NULL, NULL, NULL, 'Malaysia', NULL, NULL, NULL, NULL, NULL, 0, '', '', '', '', '', '', '', '', '', NULL, 9, '2021-05-20 22:59:40'),
(33, 'argusbip@gmail.com', 'irqumaffatsum944', 0, NULL, '', 'argusb4251', 2, 4, '', 'Dropship', NULL, '', NULL, NULL, NULL, '', NULL, NULL, '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '', '', '', '', '', '', '', '', '', NULL, 0, '2021-05-20 23:00:34');

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

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

--
-- 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
(0, '', '', NULL, NULL, NULL, '', '', NULL, NULL, '', 0, '0000-00-00 00:00:00');

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

--
-- Table structure for table `user_level`
--

CREATE TABLE `user_level` (
  `id` int(11) NOT NULL,
  `level_number` int(11) NOT NULL,
  `level_name` varchar(100) NOT NULL,
  `level_percent_product_discount` double NOT NULL,
  `level_percent_commission` double NOT NULL,
  `level_personal_minimum_sale` double NOT NULL,
  `level_team_minimum_sale` double NOT NULL,
  `status` int(11) NOT NULL,
  `created_date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `user_level`
--

INSERT INTO `user_level` (`id`, `level_number`, `level_name`, `level_percent_product_discount`, `level_percent_commission`, `level_personal_minimum_sale`, `level_team_minimum_sale`, `status`, `created_date`) VALUES
(1, 1, 'Master Stokis', 0, 0, 100000, 0, 1, '2021-01-27 23:14:24'),
(2, 2, 'Stokis', 0, 0, 25000, 0, 1, '2021-01-27 23:24:23'),
(3, 3, 'Agent', 0, 0, 2000, 0, 1, '2021-01-27 23:24:31'),
(4, 4, 'Dropship', 0, 0, 0, 0, 1, '2021-01-27 23:24:45');

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

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

CREATE TABLE `video_list` (
  `id` int(11) NOT NULL,
  `Video_ID` varchar(100) NOT NULL,
  `Modul_ID` varchar(100) NOT NULL,
  `Video_Number` int(11) NOT NULL,
  `Video_Name` varchar(100) NOT NULL,
  `Video_Description` varchar(10000) NOT NULL,
  `Video_Duration` varchar(100) NOT NULL,
  `Video_Link` varchar(1000) NOT NULL,
  `Status` int(11) NOT NULL,
  `Created_Date` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

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

CREATE TABLE `video_view` (
  `id` int(11) NOT NULL,
  `User_ID` varchar(100) NOT NULL,
  `Video_ID` varchar(100) NOT NULL,
  `Status` int(11) NOT NULL,
  `Created_Date` date NOT 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, 'RA0001000', 0, 0, '2020-02-12 00:00:00', 0, '2020-08-06 00:00:00', 0, '0000-00-00 00:00:00', 0),
(795, 'RA0001001', 0, 0, '2021-05-20 22:59:40', 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;

--
-- 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
(1, 'Op1TIu8M', 'Ash@gm404', 'BA', 'CW', 7, NULL, 'mYDAYANAS', '12345', 'DEUTSCHE BANK (MSIA) BERHAD', NULL, 1, 1, '2021-02-09 20:23:11', NULL, NULL, NULL, NULL, NULL),
(2, 'IQohWErK', 'eqw@gm4048', 'BA', 'CW', 10, NULL, '', '', '', NULL, 0, 0, '2021-02-11 16:40:04', NULL, NULL, NULL, NULL, NULL),
(3, 'y2QY7HIc', 'RA0001005', 'BA', 'CW', 8, NULL, '', '', '', NULL, 0, 0, '2021-02-27 17:15:36', NULL, NULL, NULL, NULL, NULL),
(4, 'gxGcrhOI', 'RA0001005', 'BA', 'CW', 1, NULL, '', '', '', NULL, 0, 0, '2021-02-27 17:16:02', NULL, NULL, NULL, NULL, NULL),
(5, 'F2sQeg95', 'RA0001005', 'BA', 'CW', 2, NULL, '', '', '', NULL, 0, 0, '2021-02-27 17:16:07', NULL, NULL, NULL, NULL, NULL),
(6, '3nM5OcTp', 'RA0001005', 'BA', 'CW', 3, NULL, '', '', '', NULL, 0, 0, '2021-02-27 17:16:12', 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 `coupon_used`
--
ALTER TABLE `coupon_used`
  ADD PRIMARY KEY (`id`);

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

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

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

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

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

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

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

--
-- Indexes for table `menu`
--
ALTER TABLE `menu`
  ADD PRIMARY KEY (`menu_id`);

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

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

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

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

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

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

--
-- Indexes for table `order_info`
--
ALTER TABLE `order_info`
  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 `product_price_setting`
--
ALTER TABLE `product_price_setting`
  ADD PRIMARY KEY (`id`);

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

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

--
-- Indexes for table `support_ticket_conversation`
--
ALTER TABLE `support_ticket_conversation`
  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 `user_level`
--
ALTER TABLE `user_level`
  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=14;

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `menu`
--
ALTER TABLE `menu`
  MODIFY `menu_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=37;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

