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

START TRANSACTION;



--
-- Database: `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 `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 `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;

--
-- Dumping data for table `my_cart`
--

INSERT INTO `my_cart` (`id`, `order_ref_code`, `user_id`, `prod_id`, `prod_name`, `prod_price`, `prod_qty`, `product_total_price`, `status`, `created_date`) VALUES
(2, 'AZEIG74J', 3, 6, 'Item 2', 43, 4, 172, 1, '2021-02-07 22:14:06'),
(3, 'AZEIG74J', 3, 5, 'Item 1', 43, 2, 344, 1, '2021-02-07 22:15:02'),
(4, 'AZEIG74J', 3, 7, 'Item3', 43, 5, 215, 1, '2021-02-07 22:22:53'),
(5, 'JmelhhCc', 10, 5, 'Item 1', 50, 2, 100, 1, '2021-02-08 21:20:23'),
(6, 'JmelhhCc', 10, 6, 'Item 2', 50, 3, 150, 1, '2021-02-08 21:20:34');

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

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

--
-- Dumping data for table `order_info`
--

INSERT INTO `order_info` (`id`, `order_ref_code`, `agent_id`, `name`, `last_name`, `phone_number`, `email`, `country`, `postcode`, `address`, `status`, `created_date`) VALUES
(5, 'AZEIG74J', 3, 'zaki', 'anas', '0181312232231', 'zaki@gmail.com', 'Malaysia', '47130', 'KL', 0, '2021-02-08 20:27:47'),
(7, 'JmelhhCc', 10, 'fitri', 'alias', '0312323123', 'fitri@gmail.com', 'Malaysia', '47100', 'KL', 1, '2021-02-08 21:21:03');

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

--
-- 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 `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,
  `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`, `status`, `created_date`) VALUES
(1, 4, 1, 1, 'Master Stokis', 40, 1, '2021-01-28 08:37:17'),
(2, 4, 2, 2, 'Stokis', 43, 1, '2021-01-28 08:37:17'),
(3, 4, 3, 3, 'Agent', 45, 1, '2021-01-28 08:37:17'),
(4, 4, 4, 4, 'Dropship', 50, 1, '2021-01-28 08:37:17'),
(5, 5, 1, 1, 'Master Stokis', 40, 1, '2021-02-07 15:28:56'),
(6, 5, 2, 2, 'Stokis', 43, 1, '2021-02-07 15:28:56'),
(7, 5, 3, 3, 'Agent', 45, 1, '2021-02-07 15:28:56'),
(8, 5, 4, 4, 'Dropship', 50, 1, '2021-02-07 15:28:56'),
(9, 6, 1, 1, 'Master Stokis', 40, 1, '2021-02-07 15:30:53'),
(10, 6, 2, 2, 'Stokis', 43, 1, '2021-02-07 15:30:53'),
(11, 6, 3, 3, 'Agent', 45, 1, '2021-02-07 15:30:53'),
(12, 6, 4, 4, 'Dropship', 50, 1, '2021-02-07 15:30:53'),
(13, 7, 1, 1, 'Master Stokis', 40, 1, '2021-02-07 15:31:04'),
(14, 7, 2, 2, 'Stokis', 43, 1, '2021-02-07 15:31:04'),
(15, 7, 3, 3, 'Agent', 45, 1, '2021-02-07 15:31:04'),
(16, 7, 4, 4, 'Dropship', 50, 1, '2021-02-07 15:31:04'),
(17, 8, 1, 1, 'Master Stokis', 40, 1, '2021-02-07 15:31:18'),
(18, 8, 2, 2, 'Stokis', 43, 1, '2021-02-07 15:31:18'),
(19, 8, 3, 3, 'Agent', 45, 1, '2021-02-07 15:31:18'),
(20, 8, 4, 4, 'Dropship', 50, 1, '2021-02-07 15:31:18');

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

--
-- 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,
  `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`, `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>', 1, '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>', 1, '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>', 1, '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>', 1, '2021-02-07 15:31:18');

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

--
-- 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, 'Sasku@#', '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,
  `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,
  `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
(1255, 'Sasku@#', NULL, 'CW', 0, 0, 52, 'Penaja Commission RM 0 For New Purchase ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-02-08 00:00:00', NULL, NULL, NULL),
(1256, 'Sasku@#', NULL, 'CW', 109.65, 0, 161.65, 'Penaja Commission RM 109.65 For New Purchase ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-02-08 00:00:00', NULL, NULL, NULL),
(1257, 'rafi@g1350', NULL, 'CW', 12.5, 0, 12.5, 'Penaja Commission RM 12.5 For New Purchase ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-02-08 00:00:00', NULL, NULL, NULL),
(1258, 'eqw@gm4048', NULL, 'CW', 25, 0, 25, 'Penaja Commission RM 25 For New Purchase ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-02-08 00:00:00', NULL, NULL, NULL),
(1259, 'Sasku@#', NULL, 'CW', 37.5, 0, 37.5, 'Penaja Commission RM 37.5 For New Purchase ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-02-08 00:00:00', 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;

--
-- 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_commission` 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_commission`, `status`, `created_date`) VALUES
(1, 1, 'Master Stokis', 20, 1, '2021-01-27 23:14:24'),
(2, 2, 'Stokis', 15, 1, '2021-01-27 23:24:23'),
(3, 3, 'Agent', 10, 1, '2021-01-27 23:24:31'),
(4, 4, 'Dropship', 5, 1, '2021-01-27 23:24:45'),
(5, 5, '5', 5, 9, '2021-02-02 23:33:27');

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

--
-- 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, 'Sasku@#', 37.5, 0, '2020-08-08 00:00:00', NULL, '0000-00-00 00:00:00', NULL, NULL, NULL),
(673, 'eqw@gm4048', 25, 0, '2020-11-20 23:27:02', NULL, '0000-00-00 00:00:00', NULL, NULL, NULL),
(674, 'rafi@g1350', 12.5, 0, '2020-11-21 00:59:00', NULL, '0000-00-00 00:00:00', NULL, NULL, NULL),
(786, 'liza@g1350', 0, 0, '2021-02-09 00:00:00', 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 `my_cart`
--
ALTER TABLE `my_cart`
  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 `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_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 `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 `memos`
--
ALTER TABLE `memos`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

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

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

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

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

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

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

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

