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

START TRANSACTION;



--
-- Database: `roxelshop`
--

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

--
-- Table structure for table `announcement`
--

CREATE TABLE `announcement` (
  `id` int(11) NOT NULL,
  `announcement_ref_code` varchar(100) DEFAULT NULL,
  `announcement_title` varchar(100) DEFAULT NULL,
  `announcement_image` varchar(300) DEFAULT NULL,
  `announcement_content` varchar(10000) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `created_date` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `announcement`
--

INSERT INTO `announcement` (`id`, `announcement_ref_code`, `announcement_title`, `announcement_image`, `announcement_content`, `status`, `created_date`) VALUES
(1, NULL, 'Test', NULL, '1233&lt;p&gt;&lt;/p&gt;', 1, '2021-06-08'),
(2, '1DSYyR8W', 'Test Image', '1DSYyR8W16231554421.PNG', '&lt;p&gt;&lt;span style=&quot;background-color: rgb(255, 255, 0);&quot;&gt;Test Image&lt;/span&gt;&lt;/p&gt;', 1, '2021-06-08'),
(3, 'szquOfOO', 'Test123', 'szquOfOO16240756591.png', '&lt;p&gt;1111&lt;/p&gt;', 1, '2021-06-19');

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

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

CREATE TABLE `reward_setting` (
  `id` int(11) NOT NULL,
  `rank_level` int(11) DEFAULT NULL,
  `target_KPI` varchar(100) DEFAULT NULL,
  `rewards` varchar(100) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `created_date` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

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

CREATE TABLE `support_ticket` (
  `id` int(11) NOT NULL,
  `ref_code` varchar(100) DEFAULT NULL,
  `subject` varchar(100) DEFAULT NULL,
  `priority` varchar(100) DEFAULT NULL,
  `category` varchar(100) DEFAULT NULL,
  `comment` varchar(10000) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `created_date` datetime DEFAULT 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) DEFAULT NULL,
  `user_level` int(11) DEFAULT NULL,
  `ref_code` varchar(100) DEFAULT NULL,
  `comment` varchar(10000) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `created_date` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `support_ticket_conversation`
--

INSERT INTO `support_ticket_conversation` (`id`, `support_ticket_id`, `user_level`, `ref_code`, `comment`, `status`, `created_date`) VALUES
(1, 1, 1, 'LKK10000', '', 1, '2021-06-19 12:07:12'),
(2, 1, 1, 'LKK10000', '111', 1, '2021-06-19 12:07:16');

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

--
-- Table structure for table `team_override_setting`
--

CREATE TABLE `team_override_setting` (
  `id` int(11) NOT NULL,
  `team_override_percent` varchar(10) DEFAULT NULL,
  `rank_level_depth` varchar(10) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `created_date` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `team_override_setting`
--

INSERT INTO `team_override_setting` (`id`, `team_override_percent`, `rank_level_depth`, `status`, `created_date`) VALUES
(1, '10', '1', 1, '2021-05-27'),
(2, '5', '2', 1, '2021-05-27');

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

--
-- Table structure for table `transactions`
--

CREATE TABLE `transactions` (
  `id` int(11) NOT NULL,
  `user_ref_code` varchar(100) DEFAULT NULL,
  `user_ref_code_lvl1` varchar(100) DEFAULT NULL,
  `trans_code` varchar(100) DEFAULT NULL,
  `type_of_transaction` varchar(10) DEFAULT NULL,
  `commission_type` varchar(100) DEFAULT NULL,
  `sale_amount` float 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`, `user_ref_code_lvl1`, `trans_code`, `type_of_transaction`, `commission_type`, `sale_amount`, `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
(1, 'RA0001001', NULL, 'MAOn6Lnk', 'CW', NULL, NULL, 0, 53.5, 499, 'Withdraw RM 54.5 ', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, 1, '2021-10-10 22:40:14', NULL, NULL, NULL);

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

--
-- Table structure for table `user_commission`
--

CREATE TABLE `user_commission` (
  `id` int(11) NOT NULL,
  `type_of_commission` varchar(100) DEFAULT NULL,
  `ref_code` varchar(100) DEFAULT NULL,
  `order_id` varchar(100) DEFAULT NULL,
  `billing_email` varchar(100) DEFAULT NULL,
  `order_total` varchar(100) DEFAULT NULL,
  `percent_commission` varchar(100) DEFAULT NULL,
  `order_commission` varchar(100) DEFAULT NULL,
  `paid_date` datetime DEFAULT NULL,
  `order_items` varchar(500) DEFAULT NULL,
  `order_item_quantity` int(11) DEFAULT NULL,
  `descriptions` varchar(300) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `created_date` date 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`, `order_item_quantity`, `descriptions`, `status`, `created_date`) VALUES
(563, 'item_referral', 'RA0001001', '335', NULL, '45', '21', '10', '2021-08-24 15:16:37', 'Men Perfume - Mr Million', 1, 'RM 10 Purchase Commission of Men Perfume - Mr Million', 1, '2021-09-25'),
(564, 'item_referral_level_1', '', '335', NULL, '45', '10', '4.5', '2021-08-24 15:16:37', 'Men Perfume - Mr Million', 1, '10% Purchase Commission of Men Perfume - Mr Million', 1, '2021-09-25'),
(565, 'item_referral_level_2', 'RA0001000', '335', NULL, '45', '5', '2.25', '2021-08-24 15:16:37', 'Men Perfume - Mr Million', 1, '5% Purchase Commission of Men Perfume - Mr Million', 1, '2021-09-25'),
(566, 'item_referral_owner', 'RA0001001', '335', NULL, '45', '5', '2.25', '2021-08-24 15:16:37', 'Men Perfume - Mr Million', 1, '5% Purchase Commission of Men Perfume - Mr Million', 1, '2021-09-25'),
(570, 'item_referral', 'RA0001001', '336', NULL, '75', '21', '20', '2021-08-24 15:17:16', 'Combo Buy Any 2 Men Perfume', 1, 'RM 20 Purchase Commission of Combo Buy Any 2 Men Perfume', 1, '2021-09-25'),
(571, 'item_referral_level_1', '', '336', NULL, '75', '10', '7.5', '2021-08-24 15:17:16', 'Combo Buy Any 2 Men Perfume', 1, '10% Purchase Commission of Combo Buy Any 2 Men Perfume', 1, '2021-09-25'),
(572, 'item_referral_level_2', 'RA0001000', '336', NULL, '75', '5', '3.75', '2021-08-24 15:17:16', 'Combo Buy Any 2 Men Perfume', 1, '5% Purchase Commission of Combo Buy Any 2 Men Perfume', 1, '2021-09-25'),
(573, 'item_referral_owner', 'RA0001001', '336', NULL, '75', '5', '3.75', '2021-08-24 15:17:16', 'Combo Buy Any 2 Men Perfume', 1, '5% Purchase Commission of Combo Buy Any 2 Men Perfume', 1, '2021-09-25'),
(577, 'item_referral', 'RA0001001', '337', NULL, '75', '21', '20', '2021-08-25 15:36:54', 'Combo Buy Any 2 Women Perfume', 1, 'RM 20 Purchase Commission of Combo Buy Any 2 Women Perfume', 1, '2021-09-25'),
(578, 'item_referral_level_1', 'RA0001000', '337', NULL, '75', '10', '7.5', '2021-08-25 15:36:54', 'Combo Buy Any 2 Women Perfume', 1, '10% Purchase Commission of Combo Buy Any 2 Women Perfume', 1, '2021-09-25'),
(579, 'item_referral_level_2', 'ROXEL0001', '337', NULL, '75', '5', '3.75', '2021-08-25 15:36:54', 'Combo Buy Any 2 Women Perfume', 1, '5% Purchase Commission of Combo Buy Any 2 Women Perfume', 1, '2021-09-25'),
(580, 'item_referral_owner', 'RA0001001', '337', NULL, '75', '5', '3.75', '2021-08-25 15:36:54', 'Combo Buy Any 2 Women Perfume', 1, '5% Purchase Commission of Combo Buy Any 2 Women Perfume', 1, '2021-09-25'),
(584, 'item_referral', 'RA0001001', '615', NULL, '95', '21', '20', '2021-09-14 11:23:50', 'Combo Buy Any 2 Hair Serum', 1, 'RM 20 Purchase Commission of Combo Buy Any 2 Hair Serum', 1, '2021-09-25'),
(585, 'item_referral_level_1', 'RA0001000', '615', NULL, '95', '10', '9.5', '2021-09-14 11:23:50', 'Combo Buy Any 2 Hair Serum', 1, '10% Purchase Commission of Combo Buy Any 2 Hair Serum', 1, '2021-09-25'),
(586, 'item_referral_level_2', 'RA0001000', '615', NULL, '95', '5', '4.75', '2021-09-14 11:23:50', 'Combo Buy Any 2 Hair Serum', 1, '5% Purchase Commission of Combo Buy Any 2 Hair Serum', 1, '2021-09-25'),
(587, 'item_referral_owner', 'RA0001001', '615', NULL, '95', '5', '4.75', '2021-09-14 11:23:50', 'Combo Buy Any 2 Hair Serum', 1, '5% Purchase Commission of Combo Buy Any 2 Hair Serum', 1, '2021-09-25'),
(591, 'item_referral', 'RA0001003', '661', NULL, '75', '21', '20', '2021-09-14 13:15:14', 'Combo Buy Any 1 Men Perfume & 1 Women Perfume', 1, 'RM 20 Purchase Commission of Combo Buy Any 1 Men Perfume & 1 Women Perfume', 1, '2021-09-25'),
(592, 'item_referral_level_1', 'RA0001000', '661', NULL, '75', '10', '7.5', '2021-09-14 13:15:14', 'Combo Buy Any 1 Men Perfume & 1 Women Perfume', 1, '10% Purchase Commission of Combo Buy Any 1 Men Perfume & 1 Women Perfume', 1, '2021-09-25'),
(593, 'item_referral_level_2', 'RA0001001', '661', NULL, '75', '5', '3.75', '2021-09-14 13:15:14', 'Combo Buy Any 1 Men Perfume & 1 Women Perfume', 1, '5% Purchase Commission of Combo Buy Any 1 Men Perfume & 1 Women Perfume', 1, '2021-09-25'),
(594, 'item_referral_owner', 'RA0001001', '661', NULL, '75', '5', '3.75', '2021-09-14 13:15:14', 'Combo Buy Any 1 Men Perfume & 1 Women Perfume', 1, '5% Purchase Commission of Combo Buy Any 1 Men Perfume & 1 Women Perfume', 1, '2021-09-25'),
(598, 'item_referral', 'RA0001001', '662', NULL, '75', '21', '20', '2021-09-14 17:50:19', 'Combo Buy Any 2 Women Perfume', 1, 'RM 20 Purchase Commission of Combo Buy Any 2 Women Perfume', 1, '2021-09-25'),
(599, 'item_referral_level_1', 'RA0001000', '662', NULL, '75', '10', '7.5', '2021-09-14 17:50:19', 'Combo Buy Any 2 Women Perfume', 1, '10% Purchase Commission of Combo Buy Any 2 Women Perfume', 1, '2021-09-25'),
(600, 'item_referral_level_2', 'RA0001000', '662', NULL, '75', '5', '3.75', '2021-09-14 17:50:19', 'Combo Buy Any 2 Women Perfume', 1, '5% Purchase Commission of Combo Buy Any 2 Women Perfume', 1, '2021-09-25'),
(601, 'item_referral_owner', 'RA0001001', '662', NULL, '75', '5', '3.75', '2021-09-14 17:50:19', 'Combo Buy Any 2 Women Perfume', 1, '5% Purchase Commission of Combo Buy Any 2 Women Perfume', 1, '2021-09-25'),
(605, 'item_referral', 'RA0001001', '667', NULL, '75', '21', '20', '2021-09-15 21:43:09', 'Combo Buy Any 2 Men Perfume', 1, 'RM 20 Purchase Commission of Combo Buy Any 2 Men Perfume', 1, '2021-09-25'),
(606, 'item_referral_level_1', 'RA0001000', '667', NULL, '75', '10', '7.5', '2021-09-15 21:43:09', 'Combo Buy Any 2 Men Perfume', 1, '10% Purchase Commission of Combo Buy Any 2 Men Perfume', 1, '2021-09-25'),
(607, 'item_referral_level_2', 'RA0001000', '667', NULL, '75', '5', '3.75', '2021-09-15 21:43:09', 'Combo Buy Any 2 Men Perfume', 1, '5% Purchase Commission of Combo Buy Any 2 Men Perfume', 1, '2021-09-25'),
(608, 'item_referral_owner', 'RA0001001', '667', NULL, '75', '5', '3.75', '2021-09-15 21:43:09', 'Combo Buy Any 2 Men Perfume', 1, '5% Purchase Commission of Combo Buy Any 2 Men Perfume', 1, '2021-09-25'),
(612, 'item_referral', 'RA0001001', '669', NULL, '95', '21', '20', '2021-09-17 14:38:25', 'Combo Buy Any 2 Magic Lotion', 1, 'RM 20 Purchase Commission of Combo Buy Any 2 Magic Lotion', 1, '2021-09-25'),
(613, 'item_referral_level_1', 'RA0001000', '669', NULL, '95', '10', '9.5', '2021-09-17 14:38:25', 'Combo Buy Any 2 Magic Lotion', 1, '10% Purchase Commission of Combo Buy Any 2 Magic Lotion', 1, '2021-09-25'),
(614, 'item_referral_level_2', 'RA0001000', '669', NULL, '95', '5', '4.75', '2021-09-17 14:38:25', 'Combo Buy Any 2 Magic Lotion', 1, '5% Purchase Commission of Combo Buy Any 2 Magic Lotion', 1, '2021-09-25'),
(615, 'item_referral_owner', 'RA0001001', '669', NULL, '95', '5', '4.75', '2021-09-17 14:38:25', 'Combo Buy Any 2 Magic Lotion', 1, '5% Purchase Commission of Combo Buy Any 2 Magic Lotion', 1, '2021-09-25'),
(619, 'item_referral', 'RA0001004', '682', NULL, '95', '21', '20', '2021-09-20 14:31:51', 'Combo Buy Any 1 Hair Serum & 1 Magic Lotion', 1, 'RM 20 Purchase Commission of Combo Buy Any 1 Hair Serum & 1 Magic Lotion', 1, '2021-09-25'),
(620, 'item_referral_level_1', 'RA0001000', '682', NULL, '95', '10', '9.5', '2021-09-20 14:31:51', 'Combo Buy Any 1 Hair Serum & 1 Magic Lotion', 1, '10% Purchase Commission of Combo Buy Any 1 Hair Serum & 1 Magic Lotion', 1, '2021-09-25'),
(621, 'item_referral_level_2', 'RA0001003', '682', NULL, '95', '5', '4.75', '2021-09-20 14:31:51', 'Combo Buy Any 1 Hair Serum & 1 Magic Lotion', 1, '5% Purchase Commission of Combo Buy Any 1 Hair Serum & 1 Magic Lotion', 1, '2021-09-25'),
(622, 'item_referral_owner', 'RA0001001', '682', NULL, '95', '5', '4.75', '2021-09-20 14:31:51', 'Combo Buy Any 1 Hair Serum & 1 Magic Lotion', 1, '5% Purchase Commission of Combo Buy Any 1 Hair Serum & 1 Magic Lotion', 1, '2021-09-25'),
(626, 'item_referral', 'RA0001005', '683', NULL, '85', '21', '20', '2021-09-20 15:02:50', 'Combo Buy Any 1 Women Perfume & 1 Hair Serum', 1, 'RM 20 Purchase Commission of Combo Buy Any 1 Women Perfume & 1 Hair Serum', 1, '2021-09-25'),
(627, 'item_referral_level_1', 'RA0001000', '683', NULL, '85', '10', '8.5', '2021-09-20 15:02:50', 'Combo Buy Any 1 Women Perfume & 1 Hair Serum', 1, '10% Purchase Commission of Combo Buy Any 1 Women Perfume & 1 Hair Serum', 1, '2021-09-25'),
(628, 'item_referral_level_2', 'RA0001001', '683', NULL, '85', '5', '4.25', '2021-09-20 15:02:50', 'Combo Buy Any 1 Women Perfume & 1 Hair Serum', 1, '5% Purchase Commission of Combo Buy Any 1 Women Perfume & 1 Hair Serum', 1, '2021-09-25'),
(629, 'item_referral_owner', 'RA0001001', '683', NULL, '85', '5', '4.25', '2021-09-20 15:02:50', 'Combo Buy Any 1 Women Perfume & 1 Hair Serum', 1, '5% Purchase Commission of Combo Buy Any 1 Women Perfume & 1 Hair Serum', 1, '2021-09-25'),
(633, 'item_referral', 'RA0001001', '684', NULL, '85', '21', '20', '2021-09-20 15:44:55', 'Combo Buy Any 1 Women Perfume & 1 Magic Lotion', 1, 'RM 20 Purchase Commission of Combo Buy Any 1 Women Perfume & 1 Magic Lotion', 1, '2021-09-25'),
(634, 'item_referral_level_1', 'RA0001000', '684', NULL, '85', '10', '8.5', '2021-09-20 15:44:55', 'Combo Buy Any 1 Women Perfume & 1 Magic Lotion', 1, '10% Purchase Commission of Combo Buy Any 1 Women Perfume & 1 Magic Lotion', 1, '2021-09-25'),
(635, 'item_referral_level_2', 'RA0001000', '684', NULL, '85', '5', '4.25', '2021-09-20 15:44:55', 'Combo Buy Any 1 Women Perfume & 1 Magic Lotion', 1, '5% Purchase Commission of Combo Buy Any 1 Women Perfume & 1 Magic Lotion', 1, '2021-09-25'),
(636, 'item_referral_owner', 'RA0001001', '684', NULL, '85', '5', '4.25', '2021-09-20 15:44:55', 'Combo Buy Any 1 Women Perfume & 1 Magic Lotion', 1, '5% Purchase Commission of Combo Buy Any 1 Women Perfume & 1 Magic Lotion', 1, '2021-09-25'),
(645, 'item_referral', 'RA0001001', '779', NULL, '75', '21', '20', '2021-09-23 21:03:26', 'Combo Buy Any 2 Men Perfume', 1, 'RM 20 Purchase Commission of Combo Buy Any 2 Men Perfume', 1, '2021-09-25'),
(646, 'item_referral_level_1', 'RA0001000', '779', NULL, '75', '10', '7.5', '2021-09-23 21:03:26', 'Combo Buy Any 2 Men Perfume', 1, '10% Purchase Commission of Combo Buy Any 2 Men Perfume', 1, '2021-09-25'),
(647, 'item_referral_level_2', 'RA0001000', '779', NULL, '75', '5', '3.75', '2021-09-23 21:03:26', 'Combo Buy Any 2 Men Perfume', 1, '5% Purchase Commission of Combo Buy Any 2 Men Perfume', 1, '2021-09-25'),
(648, 'item_referral_owner', 'RA0001001', '779', NULL, '75', '5', '3.75', '2021-09-23 21:03:26', 'Combo Buy Any 2 Men Perfume', 1, '5% Purchase Commission of Combo Buy Any 2 Men Perfume', 1, '2021-09-25'),
(652, 'item_referral', 'RA0001001', '785', NULL, '75', '21', '20', '2021-09-25 21:33:31', 'Combo Buy Any 1 Men Perfume & 1 Women Perfume', 1, 'RM 20 Purchase Commission of Combo Buy Any 1 Men Perfume & 1 Women Perfume', 1, '2021-09-25'),
(653, 'item_referral_level_1', 'RA0001000', '785', NULL, '75', '10', '7.5', '2021-09-25 21:33:31', 'Combo Buy Any 1 Men Perfume & 1 Women Perfume', 1, '10% Purchase Commission of Combo Buy Any 1 Men Perfume & 1 Women Perfume', 1, '2021-09-25'),
(654, 'item_referral_level_2', 'RA0001000', '785', NULL, '75', '5', '3.75', '2021-09-25 21:33:31', 'Combo Buy Any 1 Men Perfume & 1 Women Perfume', 1, '5% Purchase Commission of Combo Buy Any 1 Men Perfume & 1 Women Perfume', 1, '2021-09-25'),
(655, 'item_referral_owner', 'RA0001001', '785', NULL, '75', '5', '3.75', '2021-09-25 21:33:31', 'Combo Buy Any 1 Men Perfume & 1 Women Perfume', 1, '5% Purchase Commission of Combo Buy Any 1 Men Perfume & 1 Women Perfume', 1, '2021-09-25'),
(659, 'item_referral', 'RA0001001', '800', NULL, '75', '21', '20', '2021-09-24 18:36:42', 'Combo Buy Any 2 Women Perfume', 1, 'RM 20 Purchase Commission of Combo Buy Any 2 Women Perfume', 1, '2021-09-25'),
(660, 'item_referral_level_1', 'RA0001000', '800', NULL, '75', '10', '7.5', '2021-09-24 18:36:42', 'Combo Buy Any 2 Women Perfume', 1, '10% Purchase Commission of Combo Buy Any 2 Women Perfume', 1, '2021-09-25'),
(661, 'item_referral_level_2', 'RA0001000', '800', NULL, '75', '5', '3.75', '2021-09-24 18:36:42', 'Combo Buy Any 2 Women Perfume', 1, '5% Purchase Commission of Combo Buy Any 2 Women Perfume', 1, '2021-09-25'),
(662, 'item_referral_owner', 'RA0001001', '800', NULL, '75', '5', '3.75', '2021-09-24 18:36:42', 'Combo Buy Any 2 Women Perfume', 1, '5% Purchase Commission of Combo Buy Any 2 Women Perfume', 1, '2021-09-25'),
(666, 'item_referral', 'RA0001001', '806', NULL, '95', '21', '20', '2021-09-25 15:39:59', 'Combo Buy Any 1 Hair Serum & 1 Magic Lotion', 1, 'RM 20 Purchase Commission of Combo Buy Any 1 Hair Serum & 1 Magic Lotion', 1, '2021-09-25'),
(667, 'item_referral_level_1', 'RA0001000', '806', NULL, '95', '10', '9.5', '2021-09-25 15:39:59', 'Combo Buy Any 1 Hair Serum & 1 Magic Lotion', 1, '10% Purchase Commission of Combo Buy Any 1 Hair Serum & 1 Magic Lotion', 1, '2021-09-25'),
(668, 'item_referral_level_2', 'RA0001000', '806', NULL, '95', '5', '4.75', '2021-09-25 15:39:59', 'Combo Buy Any 1 Hair Serum & 1 Magic Lotion', 1, '5% Purchase Commission of Combo Buy Any 1 Hair Serum & 1 Magic Lotion', 1, '2021-09-25'),
(669, 'item_referral_owner', 'RA0001001', '806', NULL, '95', '5', '4.75', '2021-09-25 15:39:59', 'Combo Buy Any 1 Hair Serum & 1 Magic Lotion', 1, '5% Purchase Commission of Combo Buy Any 1 Hair Serum & 1 Magic Lotion', 1, '2021-09-25'),
(673, 'item_referral', 'RA0001001', '807', NULL, '75', '21', '20', '2021-09-25 21:32:56', 'Combo Buy Any 2 Men Perfume', 1, 'RM 20 Purchase Commission of Combo Buy Any 2 Men Perfume', 1, '2021-09-25'),
(674, 'item_referral_level_1', 'RA0001000', '807', NULL, '75', '10', '7.5', '2021-09-25 21:32:56', 'Combo Buy Any 2 Men Perfume', 1, '10% Purchase Commission of Combo Buy Any 2 Men Perfume', 1, '2021-09-25'),
(675, 'item_referral_level_2', 'RA0001000', '807', NULL, '75', '5', '3.75', '2021-09-25 21:32:56', 'Combo Buy Any 2 Men Perfume', 1, '5% Purchase Commission of Combo Buy Any 2 Men Perfume', 1, '2021-09-25'),
(676, 'item_referral_owner', 'RA0001001', '807', NULL, '75', '5', '3.75', '2021-09-25 21:32:56', 'Combo Buy Any 2 Men Perfume', 1, '5% Purchase Commission of Combo Buy Any 2 Men Perfume', 1, '2021-09-25'),
(680, 'item_referral', 'RA0001001', '808', NULL, '75', '21', '20', '2021-09-26 16:02:11', 'Combo Buy Any 2 Men Perfume', 1, 'RM 20 Purchase Commission of Combo Buy Any 2 Men Perfume', 1, '2021-09-26'),
(681, 'item_referral_level_1', 'RA0001000', '808', NULL, '75', '10', '7.5', '2021-09-26 16:02:11', 'Combo Buy Any 2 Men Perfume', 1, '10% Purchase Commission of Combo Buy Any 2 Men Perfume', 1, '2021-09-26'),
(682, 'item_referral_level_2', 'ROXEL0001', '808', NULL, '75', '5', '3.75', '2021-09-26 16:02:11', 'Combo Buy Any 2 Men Perfume', 1, '5% Purchase Commission of Combo Buy Any 2 Men Perfume', 1, '2021-09-26'),
(683, 'item_referral_owner', 'RA0001001', '808', NULL, '75', '5', '3.75', '2021-09-26 16:02:11', 'Combo Buy Any 2 Men Perfume', 1, '5% Purchase Commission of Combo Buy Any 2 Men Perfume', 1, '2021-09-26'),
(684, 'item_referral', 'RA0001003', '811', NULL, '75', '21', '20', '2021-09-27 14:18:51', 'Combo Buy Any 1 Men Perfume & 1 Women Perfume', 1, 'RM 20 Purchase Commission of Combo Buy Any 1 Men Perfume & 1 Women Perfume', 1, '2021-09-27'),
(685, 'item_referral_level_1', 'RA0001001', '811', NULL, '75', '10', '7.5', '2021-09-27 14:18:51', 'Combo Buy Any 1 Men Perfume & 1 Women Perfume', 1, '10% Purchase Commission of Combo Buy Any 1 Men Perfume & 1 Women Perfume', 1, '2021-09-27'),
(686, 'item_referral_level_2', 'RA0001000', '811', NULL, '75', '5', '3.75', '2021-09-27 14:18:51', 'Combo Buy Any 1 Men Perfume & 1 Women Perfume', 1, '5% Purchase Commission of Combo Buy Any 1 Men Perfume & 1 Women Perfume', 1, '2021-09-27'),
(687, 'item_referral_owner', 'RA0001001', '811', NULL, '75', '5', '3.75', '2021-09-27 14:18:51', 'Combo Buy Any 1 Men Perfume & 1 Women Perfume', 1, '5% Purchase Commission of Combo Buy Any 1 Men Perfume & 1 Women Perfume', 1, '2021-09-27'),
(691, 'item_referral', 'RA0001003', '812', NULL, '75', '21', '20', '2021-09-27 14:47:32', 'Combo Buy Any 2 Men Perfume', 1, 'RM 20 Purchase Commission of Combo Buy Any 2 Men Perfume', 1, '2021-09-27'),
(692, 'item_referral_level_1', 'RA0001001', '812', NULL, '75', '10', '7.5', '2021-09-27 14:47:32', 'Combo Buy Any 2 Men Perfume', 1, '10% Purchase Commission of Combo Buy Any 2 Men Perfume', 1, '2021-09-27'),
(693, 'item_referral_level_2', 'RA0001000', '812', NULL, '75', '5', '3.75', '2021-09-27 14:47:32', 'Combo Buy Any 2 Men Perfume', 1, '5% Purchase Commission of Combo Buy Any 2 Men Perfume', 1, '2021-09-27'),
(694, 'item_referral_owner', 'RA0001001', '812', NULL, '75', '5', '3.75', '2021-09-27 14:47:32', 'Combo Buy Any 2 Men Perfume', 1, '5% Purchase Commission of Combo Buy Any 2 Men Perfume', 1, '2021-09-27'),
(698, 'item_referral', 'RA00010012', '813', NULL, '75', '21', '20', '2021-09-27 16:29:24', 'Combo Buy Any 1 Men Perfume & 1 Women Perfume', 1, 'RM 20 Purchase Commission of Combo Buy Any 1 Men Perfume & 1 Women Perfume', 1, '2021-09-27'),
(699, 'item_referral_level_1', 'RA0001001', '813', NULL, '75', '10', '7.5', '2021-09-27 16:29:24', 'Combo Buy Any 1 Men Perfume & 1 Women Perfume', 1, '10% Purchase Commission of Combo Buy Any 1 Men Perfume & 1 Women Perfume', 1, '2021-09-27'),
(700, 'item_referral_level_2', 'RA0001000', '813', NULL, '75', '5', '3.75', '2021-09-27 16:29:24', 'Combo Buy Any 1 Men Perfume & 1 Women Perfume', 1, '5% Purchase Commission of Combo Buy Any 1 Men Perfume & 1 Women Perfume', 1, '2021-09-27'),
(701, 'item_referral_owner', 'RA0001001', '813', NULL, '75', '5', '3.75', '2021-09-27 16:29:24', 'Combo Buy Any 1 Men Perfume & 1 Women Perfume', 1, '5% Purchase Commission of Combo Buy Any 1 Men Perfume & 1 Women Perfume', 1, '2021-09-27'),
(705, 'item_referral', 'RA0001004', '814', NULL, '75', '21', '20', '2021-09-27 16:34:35', 'Combo Buy Any 1 Men Perfume & 1 Women Perfume', 1, 'RM 20 Purchase Commission of Combo Buy Any 1 Men Perfume & 1 Women Perfume', 1, '2021-09-27'),
(706, 'item_referral_level_1', 'RA0001003', '814', NULL, '75', '10', '7.5', '2021-09-27 16:34:35', 'Combo Buy Any 1 Men Perfume & 1 Women Perfume', 1, '10% Purchase Commission of Combo Buy Any 1 Men Perfume & 1 Women Perfume', 1, '2021-09-27'),
(707, 'item_referral_level_2', 'RA0001001', '814', NULL, '75', '5', '3.75', '2021-09-27 16:34:35', 'Combo Buy Any 1 Men Perfume & 1 Women Perfume', 1, '5% Purchase Commission of Combo Buy Any 1 Men Perfume & 1 Women Perfume', 1, '2021-09-27'),
(708, 'item_referral_owner', 'RA0001001', '814', NULL, '75', '5', '3.75', '2021-09-27 16:34:35', 'Combo Buy Any 1 Men Perfume & 1 Women Perfume', 1, '5% Purchase Commission of Combo Buy Any 1 Men Perfume & 1 Women Perfume', 1, '2021-09-27'),
(709, 'item_referral', 'RA0001005', '815', NULL, '75', '21', '20', '2021-09-29 16:22:39', 'Combo Buy Any 2 Women Perfume', 1, 'RM 20 Purchase Commission of Combo Buy Any 2 Women Perfume', 1, '2021-09-29'),
(710, 'item_referral_level_1', 'RA0001001', '815', NULL, '75', '10', '7.5', '2021-09-29 16:22:39', 'Combo Buy Any 2 Women Perfume', 1, '10% Purchase Commission of Combo Buy Any 2 Women Perfume', 1, '2021-09-29'),
(711, 'item_referral_level_2', 'RA0001000', '815', NULL, '75', '5', '3.75', '2021-09-29 16:22:39', 'Combo Buy Any 2 Women Perfume', 1, '5% Purchase Commission of Combo Buy Any 2 Women Perfume', 1, '2021-09-29'),
(712, 'item_referral_owner', 'RA0001001', '815', NULL, '75', '5', '3.75', '2021-09-29 16:22:39', 'Combo Buy Any 2 Women Perfume', 1, '5% Purchase Commission of Combo Buy Any 2 Women Perfume', 1, '2021-09-29'),
(716, 'item_referral', 'RA00010010', '816', NULL, '75', '21', '20', '2021-09-29 16:22:21', 'Combo Buy Any 2 Men Perfume', 1, 'RM 20 Purchase Commission of Combo Buy Any 2 Men Perfume', 1, '2021-09-29'),
(717, 'item_referral_level_1', 'RA0001001', '816', NULL, '75', '10', '7.5', '2021-09-29 16:22:21', 'Combo Buy Any 2 Men Perfume', 1, '10% Purchase Commission of Combo Buy Any 2 Men Perfume', 1, '2021-09-29'),
(718, 'item_referral_level_2', 'RA0001005', '816', NULL, '75', '5', '3.75', '2021-09-29 16:22:21', 'Combo Buy Any 2 Men Perfume', 1, '5% Purchase Commission of Combo Buy Any 2 Men Perfume', 1, '2021-09-29'),
(719, 'item_referral_owner', 'RA0001001', '816', NULL, '75', '5', '3.75', '2021-09-29 16:22:21', 'Combo Buy Any 2 Men Perfume', 1, '5% Purchase Commission of Combo Buy Any 2 Men Perfume', 1, '2021-09-29'),
(723, 'item_referral', 'RA00010010', '818', NULL, '75', '21', '20', '2021-09-30 15:08:41', 'Combo Buy Any 2 Women Perfume', 1, 'RM 20 Purchase Commission of Combo Buy Any 2 Women Perfume', 1, '2021-09-30'),
(724, 'item_referral_level_1', 'RA0001005', '818', NULL, '75', '10', '7.5', '2021-09-30 15:08:41', 'Combo Buy Any 2 Women Perfume', 1, '10% Purchase Commission of Combo Buy Any 2 Women Perfume', 1, '2021-09-30'),
(725, 'item_referral_level_2', 'RA0001001', '818', NULL, '75', '5', '3.75', '2021-09-30 15:08:41', 'Combo Buy Any 2 Women Perfume', 1, '5% Purchase Commission of Combo Buy Any 2 Women Perfume', 1, '2021-09-30'),
(726, 'item_referral_owner', 'RA0001001', '818', NULL, '75', '5', '3.75', '2021-09-30 15:08:41', 'Combo Buy Any 2 Women Perfume', 1, '5% Purchase Commission of Combo Buy Any 2 Women Perfume', 1, '2021-09-30'),
(736, 'item_referral', 'RA0001005', '819', NULL, '75', '21', '20', '2021-09-30 15:32:54', 'Combo Buy Any 2 Men Perfume', 1, 'RM 20 Purchase Commission of Combo Buy Any 2 Men Perfume', 1, '2021-09-30'),
(737, 'item_referral_level_1', 'RA0001001', '819', NULL, '75', '10', '7.5', '2021-09-30 15:32:54', 'Combo Buy Any 2 Men Perfume', 1, '10% Purchase Commission of Combo Buy Any 2 Men Perfume', 1, '2021-09-30'),
(738, 'item_referral_level_2', 'RA0001000', '819', NULL, '75', '5', '3.75', '2021-09-30 15:32:54', 'Combo Buy Any 2 Men Perfume', 1, '5% Purchase Commission of Combo Buy Any 2 Men Perfume', 1, '2021-09-30'),
(739, 'item_referral_owner', 'RA0001001', '819', NULL, '75', '5', '3.75', '2021-09-30 15:32:54', 'Combo Buy Any 2 Men Perfume', 1, '5% Purchase Commission of Combo Buy Any 2 Men Perfume', 1, '2021-09-30'),
(743, 'item_referral', 'RA0001001', '822', NULL, '75', '21', '20', '2021-09-30 23:21:04', 'Combo Buy Any 2 Men Perfume', 1, 'RM 20 Purchase Commission of Combo Buy Any 2 Men Perfume', 1, '2021-09-30'),
(744, 'item_referral_level_1', 'RA0001000', '822', NULL, '75', '10', '7.5', '2021-09-30 23:21:04', 'Combo Buy Any 2 Men Perfume', 1, '10% Purchase Commission of Combo Buy Any 2 Men Perfume', 1, '2021-09-30'),
(745, 'item_referral_level_2', 'ROXEL0001', '822', NULL, '75', '5', '3.75', '2021-09-30 23:21:04', 'Combo Buy Any 2 Men Perfume', 1, '5% Purchase Commission of Combo Buy Any 2 Men Perfume', 1, '2021-09-30'),
(746, 'item_referral_owner', 'RA0001001', '822', NULL, '75', '5', '3.75', '2021-09-30 23:21:04', 'Combo Buy Any 2 Men Perfume', 1, '5% Purchase Commission of Combo Buy Any 2 Men Perfume', 1, '2021-09-30'),
(753, 'item_referral', 'RA0001001', '823', NULL, '75', '21', '20', '2021-10-01 22:34:30', 'Combo Buy Any 2 Men Perfume', 1, 'RM 20 Purchase Commission of Combo Buy Any 2 Men Perfume', 1, '2021-10-01'),
(754, 'item_referral_level_1', 'RA0001000', '823', NULL, '75', '10', '7.5', '2021-10-01 22:34:30', 'Combo Buy Any 2 Men Perfume', 1, '10% Purchase Commission of Combo Buy Any 2 Men Perfume', 1, '2021-10-01'),
(755, 'item_referral_level_2', 'ROXEL0001', '823', NULL, '75', '5', '3.75', '2021-10-01 22:34:30', 'Combo Buy Any 2 Men Perfume', 1, '5% Purchase Commission of Combo Buy Any 2 Men Perfume', 1, '2021-10-01'),
(756, 'item_referral_owner', 'RA0001001', '823', NULL, '75', '5', '3.75', '2021-10-01 22:34:30', 'Combo Buy Any 2 Men Perfume', 1, '5% Purchase Commission of Combo Buy Any 2 Men Perfume', 1, '2021-10-01'),
(766, 'item_referral', 'RA00010028', '824', NULL, '75', '21', '20', '2021-10-01 23:15:06', 'Combo Buy Any 2 Men Perfume', 1, 'RM 20 Purchase Commission of Combo Buy Any 2 Men Perfume', 1, '2021-10-01'),
(767, 'item_referral_level_1', 'RA0001001', '824', NULL, '75', '10', '7.5', '2021-10-01 23:15:06', 'Combo Buy Any 2 Men Perfume', 1, '10% Purchase Commission of Combo Buy Any 2 Men Perfume', 1, '2021-10-01'),
(768, 'item_referral_level_2', 'RA0001000', '824', NULL, '75', '5', '3.75', '2021-10-01 23:15:06', 'Combo Buy Any 2 Men Perfume', 1, '5% Purchase Commission of Combo Buy Any 2 Men Perfume', 1, '2021-10-01'),
(769, 'item_referral_owner', 'RA0001001', '824', NULL, '75', '5', '3.75', '2021-10-01 23:15:06', 'Combo Buy Any 2 Men Perfume', 1, '5% Purchase Commission of Combo Buy Any 2 Men Perfume', 1, '2021-10-01'),
(776, 'item_referral', 'RA0001006', '825', NULL, '75', '21', '20', '2021-10-02 11:32:55', 'Combo Buy Any 2 Men Perfume', 1, 'RM 20 Purchase Commission of Combo Buy Any 2 Men Perfume', 1, '2021-10-02'),
(777, 'item_referral_level_1', 'RA0001001', '825', NULL, '75', '10', '7.5', '2021-10-02 11:32:55', 'Combo Buy Any 2 Men Perfume', 1, '10% Purchase Commission of Combo Buy Any 2 Men Perfume', 1, '2021-10-02'),
(778, 'item_referral_level_2', 'RA0001000', '825', NULL, '75', '5', '3.75', '2021-10-02 11:32:55', 'Combo Buy Any 2 Men Perfume', 1, '5% Purchase Commission of Combo Buy Any 2 Men Perfume', 1, '2021-10-02'),
(779, 'item_referral_owner', 'RA0001001', '825', NULL, '75', '5', '3.75', '2021-10-02 11:32:55', 'Combo Buy Any 2 Men Perfume', 1, '5% Purchase Commission of Combo Buy Any 2 Men Perfume', 1, '2021-10-02'),
(783, 'item_referral', 'RA0001006', '826', NULL, '75', '21', '20', '2021-10-02 12:27:15', 'Combo Buy Any 2 Women Perfume', 1, 'RM 20 Purchase Commission of Combo Buy Any 2 Women Perfume', 1, '2021-10-02'),
(784, 'item_referral_level_1', 'RA0001001', '826', NULL, '75', '10', '7.5', '2021-10-02 12:27:15', 'Combo Buy Any 2 Women Perfume', 1, '10% Purchase Commission of Combo Buy Any 2 Women Perfume', 1, '2021-10-02'),
(785, 'item_referral_level_2', 'RA0001000', '826', NULL, '75', '5', '3.75', '2021-10-02 12:27:15', 'Combo Buy Any 2 Women Perfume', 1, '5% Purchase Commission of Combo Buy Any 2 Women Perfume', 1, '2021-10-02'),
(786, 'item_referral_owner', 'RA0001001', '826', NULL, '75', '5', '3.75', '2021-10-02 12:27:15', 'Combo Buy Any 2 Women Perfume', 1, '5% Purchase Commission of Combo Buy Any 2 Women Perfume', 1, '2021-10-02'),
(826, 'item_referral', 'RA0001006', '827', NULL, '75', '21', '20', '2021-10-02 12:49:59', 'Combo Buy Any 2 Women Perfume', 1, 'RM 20 Purchase Commission of Combo Buy Any 2 Women Perfume', 1, '2021-10-02'),
(827, 'item_referral_level_1', 'RA0001001', '827', NULL, '75', '10', '7.5', '2021-10-02 12:49:59', 'Combo Buy Any 2 Women Perfume', 1, '10% Purchase Commission of Combo Buy Any 2 Women Perfume', 1, '2021-10-02'),
(828, 'item_referral_level_2', 'RA0001000', '827', NULL, '75', '5', '3.75', '2021-10-02 12:49:59', 'Combo Buy Any 2 Women Perfume', 1, '5% Purchase Commission of Combo Buy Any 2 Women Perfume', 1, '2021-10-02'),
(829, 'item_referral_owner', 'RA0001001', '827', NULL, '75', '5', '3.75', '2021-10-02 12:49:59', 'Combo Buy Any 2 Women Perfume', 1, '5% Purchase Commission of Combo Buy Any 2 Women Perfume', 1, '2021-10-02'),
(845, 'item_referral', 'RA0001001', '828', NULL, '75', '21', '20', '2021-10-02 13:52:40', 'Combo Buy Any 2 Men Perfume', 1, 'RM 20 Purchase Commission of Combo Buy Any 2 Men Perfume', 1, '2021-10-02'),
(846, 'item_referral_level_1', 'RA0001000', '828', NULL, '75', '10', '7.5', '2021-10-02 13:52:40', 'Combo Buy Any 2 Men Perfume', 1, '10% Purchase Commission of Combo Buy Any 2 Men Perfume', 1, '2021-10-02'),
(847, 'item_referral_level_2', 'ROXEL0001', '828', NULL, '75', '5', '3.75', '2021-10-02 13:52:40', 'Combo Buy Any 2 Men Perfume', 1, '5% Purchase Commission of Combo Buy Any 2 Men Perfume', 1, '2021-10-02'),
(848, 'item_referral_owner', 'RA0001001', '828', NULL, '75', '5', '3.75', '2021-10-02 13:52:40', 'Combo Buy Any 2 Men Perfume', 1, '5% Purchase Commission of Combo Buy Any 2 Men Perfume', 1, '2021-10-02'),
(852, 'item_referral', 'RA00010032', '829', NULL, '95', '21', '20', '2021-10-02 13:58:20', 'Combo Buy Any 1 Hair Serum & 1 Magic Lotion', 1, 'RM 20 Purchase Commission of Combo Buy Any 1 Hair Serum & 1 Magic Lotion', 1, '2021-10-02'),
(853, 'item_referral_level_1', 'RA0001006', '829', NULL, '95', '10', '9.5', '2021-10-02 13:58:20', 'Combo Buy Any 1 Hair Serum & 1 Magic Lotion', 1, '10% Purchase Commission of Combo Buy Any 1 Hair Serum & 1 Magic Lotion', 1, '2021-10-02'),
(854, 'item_referral_level_2', 'RA0001001', '829', NULL, '95', '5', '4.75', '2021-10-02 13:58:20', 'Combo Buy Any 1 Hair Serum & 1 Magic Lotion', 1, '5% Purchase Commission of Combo Buy Any 1 Hair Serum & 1 Magic Lotion', 1, '2021-10-02'),
(855, 'item_referral_owner', 'RA0001001', '829', NULL, '95', '5', '4.75', '2021-10-02 13:58:20', 'Combo Buy Any 1 Hair Serum & 1 Magic Lotion', 1, '5% Purchase Commission of Combo Buy Any 1 Hair Serum & 1 Magic Lotion', 1, '2021-10-02');

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

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

CREATE TABLE `user_level` (
  `id` int(11) NOT NULL,
  `level_number` int(11) DEFAULT NULL,
  `level_name` varchar(100) DEFAULT NULL,
  `level_percent_product_discount` double DEFAULT NULL,
  `level_percent_commission` double DEFAULT NULL,
  `level_personal_minimum_sale` double DEFAULT NULL,
  `level_team_minimum_sale` double DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `created_date` datetime DEFAULT 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
(4, 1, 'Executive Member', 0, 0, 0, 0, 1, '2021-01-27 23:24:45'),
(5, 2, 'Member', 0, 0, 0, 0, 1, '2021-08-14 10:51:00');

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

--
-- Table structure for table `user_rewards`
--

CREATE TABLE `user_rewards` (
  `id` int(11) NOT NULL,
  `user_id` varchar(100) DEFAULT NULL,
  `user_level` int(11) DEFAULT NULL,
  `type_of_reward` varchar(100) DEFAULT NULL,
  `reward_month` int(11) DEFAULT NULL,
  `reward_year` int(11) DEFAULT NULL,
  `target_achieved` varchar(100) DEFAULT NULL,
  `rewards` varchar(100) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `created_date` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- 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, 'ROXEL0001', 18.75, 0, '2020-02-12 00:00:00', 0, '2020-08-06 00:00:00', 0, '0000-00-00 00:00:00', 0),
(796, 'RA0001000', 225.75, 0, '2021-05-20 00:00:00', NULL, '0000-00-00 00:00:00', NULL, NULL, NULL),
(798, 'RA0001001', 499, 0, '2021-08-15 14:37:16', NULL, '0000-00-00 00:00:00', NULL, NULL, NULL),
(799, 'RA0001002', 0, 0, '2021-09-09 15:05:48', NULL, NULL, NULL, NULL, NULL),
(800, 'RA0001002', 0, 0, '2021-09-09 15:10:22', NULL, NULL, NULL, NULL, NULL),
(801, 'RA0001003', 72.25, 0, '2021-09-14 11:13:48', NULL, NULL, NULL, NULL, NULL),
(802, 'RA0001004', 40, 0, '2021-09-14 13:11:00', NULL, NULL, NULL, NULL, NULL),
(803, 'RA0001005', 71.25, 0, '2021-09-14 17:39:43', NULL, NULL, NULL, NULL, NULL),
(804, 'RA0001006', 69.5, 0, '2021-09-15 21:27:50', NULL, NULL, NULL, NULL, NULL),
(806, 'RA0001008', 0, 0, '2021-09-17 11:43:43', NULL, NULL, NULL, NULL, NULL),
(808, 'RA0001009', 0, 0, '2021-09-20 14:16:59', NULL, NULL, NULL, NULL, NULL),
(809, 'RA00010010', 40, 0, '2021-09-20 14:53:42', NULL, NULL, NULL, NULL, NULL),
(810, 'RA00010011', 0, 0, '2021-09-20 15:16:40', NULL, NULL, NULL, NULL, NULL),
(813, 'RA00010012', 20, 0, '2021-09-23 09:49:02', NULL, NULL, NULL, NULL, NULL),
(814, 'RA00010013', 0, 0, '2021-09-23 12:37:32', NULL, NULL, NULL, NULL, NULL),
(815, 'RA00010014', 0, 0, '2021-09-23 15:11:16', NULL, NULL, NULL, NULL, NULL),
(824, 'RA00010015', 0, 0, '2021-09-24 22:26:19', NULL, NULL, NULL, NULL, NULL),
(833, 'RA00010016', 0, 0, '2021-09-26 15:58:31', NULL, NULL, NULL, NULL, NULL),
(834, 'RA00010017', 0, 0, '2021-09-27 13:22:02', NULL, NULL, NULL, NULL, NULL),
(835, 'RA00010018', 0, 0, '2021-09-27 14:13:00', NULL, NULL, NULL, NULL, NULL),
(836, 'RA00010019', 0, 0, '2021-09-27 14:37:56', NULL, NULL, NULL, NULL, NULL),
(837, 'RA00010020', 0, 0, '2021-09-27 15:18:19', NULL, NULL, NULL, NULL, NULL),
(838, 'RA00010021', 0, 0, '2021-09-27 16:23:40', NULL, NULL, NULL, NULL, NULL),
(839, 'RA00010022', 0, 0, '2021-09-27 16:24:24', NULL, NULL, NULL, NULL, NULL),
(840, 'RA00010023', 0, 0, '2021-09-29 16:24:01', NULL, NULL, NULL, NULL, NULL),
(841, 'RA00010024', 0, 0, '2021-09-29 16:24:01', NULL, NULL, NULL, NULL, NULL),
(842, 'RA00010025', 0, 0, '2021-09-30 15:10:01', NULL, NULL, NULL, NULL, NULL),
(843, 'RA00010026', 0, 0, '2021-09-30 15:35:02', NULL, NULL, NULL, NULL, NULL),
(844, 'RA00010027', 0, 0, '2021-09-30 23:23:10', NULL, NULL, NULL, NULL, NULL),
(845, 'RA00010028', 20, 0, '2021-10-01 22:37:01', NULL, NULL, NULL, NULL, NULL),
(846, 'RA00010029', 0, 0, '2021-10-01 23:18:01', NULL, NULL, NULL, NULL, NULL),
(847, 'RA00010030', 0, 0, '2021-10-01 23:18:01', NULL, NULL, NULL, NULL, NULL),
(848, 'RA00010029', 0, 0, '2021-10-02 06:50:02', NULL, NULL, NULL, NULL, NULL),
(849, 'RA00010029', 0, 0, '2021-10-02 06:53:01', NULL, NULL, NULL, NULL, NULL),
(850, 'RA00010030', 0, 0, '2021-10-02 11:35:01', NULL, NULL, NULL, NULL, NULL),
(851, 'RA00010031', 0, 0, '2021-10-02 12:29:02', NULL, NULL, NULL, NULL, NULL),
(852, 'RA00010032', 20, 0, '2021-10-02 12:57:01', NULL, NULL, NULL, NULL, NULL),
(853, 'RA00010033', 0, 0, '2021-10-02 13:56:01', NULL, NULL, NULL, NULL, NULL),
(854, 'RA00010034', 0, 0, '2021-10-02 14:00:04', 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, 'MAOn6Lnk', 'RA0001001', 'BA', 'CW', 54.5, NULL, 'MOHAMED KHARIL BIN BUJANG', '10101010001', 'CIMB BANK', NULL, 0, 0, '2021-10-10 22:40:14', NULL, NULL, NULL, NULL, NULL);

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

--
-- Table structure for table `woocommerce_order_info_item`
--

CREATE TABLE `woocommerce_order_info_item` (
  `id` int(11) NOT NULL,
  `order_id` varchar(100) DEFAULT NULL,
  `ref_code` varchar(100) DEFAULT NULL,
  `from_user_id` varchar(100) DEFAULT NULL,
  `to_user_id` varchar(100) DEFAULT NULL,
  `from_user_id_level` int(11) DEFAULT NULL,
  `item_id` varchar(100) DEFAULT NULL,
  `item_name` varchar(100) DEFAULT NULL,
  `item_quantity` int(11) DEFAULT NULL,
  `item_total_price` varchar(100) DEFAULT NULL,
  `item_total_price_member` varchar(100) DEFAULT NULL,
  `item_nilai_mata` varchar(200) DEFAULT NULL,
  `type_of_transaction` varchar(10) DEFAULT NULL,
  `type_of_delivery` varchar(100) DEFAULT NULL,
  `delivery_address` varchar(100) DEFAULT NULL,
  `payment_slip` varchar(100) DEFAULT NULL,
  `order_remark` varchar(100) DEFAULT NULL,
  `sale_to_customer` int(11) DEFAULT NULL,
  `customer_purchase_date` date DEFAULT NULL,
  `customer_name` varchar(100) DEFAULT NULL,
  `customer_phone` varchar(100) DEFAULT NULL,
  `customer_email` varchar(100) DEFAULT NULL,
  `customer_address` varchar(100) DEFAULT NULL,
  `customer_state` varchar(100) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `created_date` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `woocommerce_order_info_item`
--

INSERT INTO `woocommerce_order_info_item` (`id`, `order_id`, `ref_code`, `from_user_id`, `to_user_id`, `from_user_id_level`, `item_id`, `item_name`, `item_quantity`, `item_total_price`, `item_total_price_member`, `item_nilai_mata`, `type_of_transaction`, `type_of_delivery`, `delivery_address`, `payment_slip`, `order_remark`, `sale_to_customer`, `customer_purchase_date`, `customer_name`, `customer_phone`, `customer_email`, `customer_address`, `customer_state`, `status`, `created_date`) VALUES
(129, '335', 'RA0001001', NULL, NULL, NULL, '47', 'Men Perfume - Mr Million', 1, '55', '45', 'promotion_Men_Perfume#45.00', 'In', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-09-25'),
(130, '336', 'RA0001001', NULL, NULL, NULL, '240', 'Combo Buy Any 2 Men Perfume', 1, '95', '75', 'combo_Combo-Buy-Any-2-Men-Perfume#75.00', 'In', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-09-25'),
(131, '337', 'RA0001001', NULL, NULL, NULL, '245', 'Combo Buy Any 2 Women Perfume', 1, '95', '75', 'combo_Combo-Buy-Any-2-Women-Perfume#75.00', 'In', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-09-25'),
(132, '615', 'RA0001001', NULL, NULL, NULL, '280', 'Combo Buy Any 2 Hair Serum', 1, '115', '95', 'combo_Combo-Buy-Any-2-Hair-Serum#95.00', 'In', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-09-25'),
(133, '661', 'RA0001003', NULL, NULL, NULL, '250', 'Combo Buy Any 1 Men Perfume & 1 Women Perfume', 1, '95', '75', 'combo_Combo-Buy-Any-1-Men-Perfume-&-1-Women-Perfume#75.00', 'In', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-09-25'),
(134, '662', 'RA0001001', NULL, NULL, NULL, '245', 'Combo Buy Any 2 Women Perfume', 1, '95', '75', 'combo_Combo-Buy-Any-2-Women-Perfume#75.00', 'In', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-09-25'),
(135, '667', 'RA0001001', NULL, NULL, NULL, '240', 'Combo Buy Any 2 Men Perfume', 1, '95', '75', 'combo_Combo-Buy-Any-2-Men-Perfume#75.00', 'In', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-09-25'),
(136, '669', 'RA0001001', NULL, NULL, NULL, '285', 'Combo Buy Any 2 Magic Lotion', 1, '115', '95', 'combo_Combo-Buy-Any-2-Magic-Lotion#95.00', 'In', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-09-25'),
(137, '682', 'RA0001004', NULL, NULL, NULL, '288', 'Combo Buy Any 1 Hair Serum & 1 Magic Lotion', 1, '115', '95', 'combo_Combo-Buy-Any-1-Hair-Serum-&-1-Magic-Lotion#95.00', 'In', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-09-25'),
(138, '683', 'RA0001005', NULL, NULL, NULL, '264', 'Combo Buy Any 1 Women Perfume & 1 Hair Serum', 1, '105', '85', 'combo_Combo-1-Buy-Any-1-Women-Perfume-&-1-Hair-Serum#85.00', 'In', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-09-25'),
(139, '684', 'RA0001001', NULL, NULL, NULL, '274', 'Combo Buy Any 1 Women Perfume & 1 Magic Lotion', 1, '105', '85', 'combo_Combo-Buy-Any-1-Women-Perfume-&-1-Magic-Lotion#85.00', 'In', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-09-25'),
(140, '775', '', NULL, NULL, NULL, '250', 'Combo Buy Any 1 Men Perfume & 1 Women Perfume', 1, '95', '75', 'combo_Combo-Buy-Any-1-Men-Perfume-&-1-Women-Perfume#75.00', 'In', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-09-25'),
(141, '779', 'RA0001001', NULL, NULL, NULL, '240', 'Combo Buy Any 2 Men Perfume', 1, '95', '75', 'combo_Combo-Buy-Any-2-Men-Perfume#75.00', 'In', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-09-25'),
(142, '785', 'RA0001001', NULL, NULL, NULL, '250', 'Combo Buy Any 1 Men Perfume & 1 Women Perfume', 1, '95', '75', 'combo_Combo-Buy-Any-1-Men-Perfume-&-1-Women-Perfume#75.00', 'In', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-09-25'),
(143, '800', 'RA0001001', NULL, NULL, NULL, '245', 'Combo Buy Any 2 Women Perfume', 1, '95', '75', 'combo_Combo-Buy-Any-2-Women-Perfume#75.00', 'In', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-09-25'),
(144, '806', 'RA0001001', NULL, NULL, NULL, '288', 'Combo Buy Any 1 Hair Serum & 1 Magic Lotion', 1, '115', '95', 'combo_Combo-Buy-Any-1-Hair-Serum-&-1-Magic-Lotion#95.00', 'In', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-09-25'),
(145, '807', 'RA0001001', NULL, NULL, NULL, '240', 'Combo Buy Any 2 Men Perfume', 1, '95', '75', 'combo_Combo-Buy-Any-2-Men-Perfume#75.00', 'In', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-09-25'),
(146, '808', 'RA0001001', NULL, NULL, NULL, '240', 'Combo Buy Any 2 Men Perfume', 1, '95', '75', 'combo_Combo-Buy-Any-2-Men-Perfume#75.00', 'In', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-09-26'),
(147, '811', 'RA0001003', NULL, NULL, NULL, '250', 'Combo Buy Any 1 Men Perfume & 1 Women Perfume', 1, '95', '75', 'combo_Combo-Buy-Any-1-Men-Perfume-&-1-Women-Perfume#75.00', 'In', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-09-27'),
(148, '812', 'RA0001003', NULL, NULL, NULL, '240', 'Combo Buy Any 2 Men Perfume', 1, '95', '75', 'combo_Combo-Buy-Any-2-Men-Perfume#75.00', 'In', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-09-27'),
(149, '813', 'RA00010012', NULL, NULL, NULL, '250', 'Combo Buy Any 1 Men Perfume & 1 Women Perfume', 1, '95', '75', 'combo_Combo-Buy-Any-1-Men-Perfume-&-1-Women-Perfume#75.00', 'In', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-09-27'),
(150, '814', 'RA0001004', NULL, NULL, NULL, '250', 'Combo Buy Any 1 Men Perfume & 1 Women Perfume', 1, '95', '75', 'combo_Combo-Buy-Any-1-Men-Perfume-&-1-Women-Perfume#75.00', 'In', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-09-27'),
(151, '815', 'RA0001005', NULL, NULL, NULL, '245', 'Combo Buy Any 2 Women Perfume', 1, '95', '75', 'combo_Combo-Buy-Any-2-Women-Perfume#75.00', 'In', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-09-29'),
(152, '816', 'RA00010010', NULL, NULL, NULL, '240', 'Combo Buy Any 2 Men Perfume', 1, '95', '75', 'combo_Combo-Buy-Any-2-Men-Perfume#75.00', 'In', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-09-29'),
(153, '818', 'RA00010010', NULL, NULL, NULL, '245', 'Combo Buy Any 2 Women Perfume', 1, '95', '75', 'combo_Combo-Buy-Any-2-Women-Perfume#75.00', 'In', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-09-30'),
(154, '819', 'RA0001005', NULL, NULL, NULL, '240', 'Combo Buy Any 2 Men Perfume', 1, '95', '75', 'combo_Combo-Buy-Any-2-Men-Perfume#75.00', 'In', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-09-30'),
(155, '822', 'RA0001001', NULL, NULL, NULL, '240', 'Combo Buy Any 2 Men Perfume', 1, '95', '75', 'combo_Combo-Buy-Any-2-Men-Perfume#75.00', 'In', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-09-30'),
(156, '823', 'RA0001001', NULL, NULL, NULL, '240', 'Combo Buy Any 2 Men Perfume', 1, '95', '75', 'combo_Combo-Buy-Any-2-Men-Perfume#75.00', 'In', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-10-01'),
(157, '824', 'RA00010028', NULL, NULL, NULL, '240', 'Combo Buy Any 2 Men Perfume', 1, '95', '75', 'combo_Combo-Buy-Any-2-Men-Perfume#75.00', 'In', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-10-01'),
(158, '825', 'RA0001006', NULL, NULL, NULL, '240', 'Combo Buy Any 2 Men Perfume', 1, '95', '75', 'combo_Combo-Buy-Any-2-Men-Perfume#75.00', 'In', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-10-02'),
(159, '826', 'RA0001006', NULL, NULL, NULL, '245', 'Combo Buy Any 2 Women Perfume', 1, '95', '75', 'combo_Combo-Buy-Any-2-Women-Perfume#75.00', 'In', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-10-02'),
(160, '827', 'RA0001006', NULL, NULL, NULL, '245', 'Combo Buy Any 2 Women Perfume', 1, '95', '75', 'combo_Combo-Buy-Any-2-Women-Perfume#75.00', 'In', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-10-02'),
(161, '828', 'RA0001001', NULL, NULL, NULL, '240', 'Combo Buy Any 2 Men Perfume', 1, '95', '75', 'combo_Combo-Buy-Any-2-Men-Perfume#75.00', 'In', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-10-02'),
(162, '829', 'RA00010032', NULL, NULL, NULL, '288', 'Combo Buy Any 1 Hair Serum & 1 Magic Lotion', 1, '115', '95', 'combo_Combo-Buy-Any-1-Hair-Serum-&-1-Magic-Lotion#95.00', 'In', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2021-10-02');

--
-- Indexes for dumped tables
--

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

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

--
-- Indexes for table `reward_setting`
--
ALTER TABLE `reward_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 `team_override_setting`
--
ALTER TABLE `team_override_setting`
  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 `user_rewards`
--
ALTER TABLE `user_rewards`
  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`);

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

--
-- 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 `user_rewards`
--
ALTER TABLE `user_rewards`
  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=855;

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

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

