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

START TRANSACTION;



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

--
-- Table structure for table `ads_category`
--

CREATE TABLE `ads_category` (
  `id` int(255) NOT NULL,
  `cat_name` varchar(255) NOT NULL,
  `image` varchar(255) NOT NULL,
  `created_date` timestamp NOT NULL DEFAULT current_timestamp(),
  `status` varchar(255) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `ads_category`
--

INSERT INTO `ads_category` (`id`, `cat_name`, `image`, `created_date`, `status`) VALUES
(1, 'ফà§যামিলি বাসা', 'family.png', '2023-07-13 17:45:29', '0'),
(2, 'বà§যাচেলর বাসা', 'boy.png', '2023-07-13 17:45:49', '0'),
(3, 'শà§ধà§মাতà§র ছাতà§রী', 'girl.png', '2023-07-13 17:51:19', '0'),
(4, 'ফà§লà§যাট বাসা', 'apartment.png', '2023-07-21 00:54:16', '0'),
(5, 'হাফ বিলà§ডিং বাসা', 'house (2).png', '2023-07-21 00:55:35', '0'),
(6, 'টিন সেড বাসা', '3d-house.png', '2023-07-21 00:56:48', '0'),
(7, 'সাবলেট বাসা', 'house (3).png', '2023-07-21 00:57:46', '0');

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

--
-- Table structure for table `ads_city`
--

CREATE TABLE `ads_city` (
  `id` int(255) NOT NULL,
  `city_name` text NOT NULL,
  `created_date` timestamp NOT NULL DEFAULT current_timestamp(),
  `status` varchar(255) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `ads_city`
--

INSERT INTO `ads_city` (`id`, `city_name`, `created_date`, `status`) VALUES
(1, 'Sylhet', '2023-06-24 14:35:48', '0');

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

--
-- Table structure for table `ads_location`
--

CREATE TABLE `ads_location` (
  `id` int(255) NOT NULL,
  `location_name` varchar(255) NOT NULL,
  `created_date` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `ads_location`
--

INSERT INTO `ads_location` (`id`, `location_name`, `created_date`) VALUES
(19, 'Gazipur', '2023-07-21 00:42:33'),
(21, 'Narayanganj', '2023-07-21 00:44:11'),
(22, 'Konabari', '2023-07-21 00:44:48'),
(23, 'Savar', '2023-07-21 00:45:14'),
(24, 'Mymensingh', '2023-07-21 00:45:36');

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

--
-- Table structure for table `ads_location2`
--

CREATE TABLE `ads_location2` (
  `id` int(255) NOT NULL,
  `location_name` varchar(255) NOT NULL,
  `created_date` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `ads_location2`
--

INSERT INTO `ads_location2` (`id`, `location_name`, `created_date`) VALUES
(1, 'Sylhet', '2023-06-24 14:18:28'),
(20, 'Gazipur Sadar - গাজীপà§র সদর', '2023-07-24 16:59:15'),
(22, 'Kaliakair - কালিয়াকৈর', '2023-07-24 17:03:48'),
(23, 'Mymensingh Sadar- ময়মনসিংহ সদর', '2023-07-24 17:07:41'),
(24, 'Sreepur - শà§রীপà§র', '2023-07-24 17:13:57'),
(25, 'Kapasia - কাপাসিয়া', '2023-07-24 17:14:48'),
(26, 'Tongi -টঙà§গী', '2023-07-24 17:15:35');

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

--
-- Table structure for table `ads_location_tree`
--

CREATE TABLE `ads_location_tree` (
  `id` int(255) NOT NULL,
  `location_name` varchar(255) NOT NULL,
  `created_date` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `ads_location_tree`
--

INSERT INTO `ads_location_tree` (`id`, `location_name`, `created_date`) VALUES
(7, 'Saqure Masterbari - সà§কয়ার মাসà§টারবাড়ী', '2023-07-21 01:38:08'),
(9, 'Mawna - মাওনা', '2023-07-24 17:01:32'),
(10, 'Gor Goriya Masterbari - গড় গড়িয়া মাসà§টার বাড়ী', '2023-07-24 17:01:51'),
(11, 'Vhabanipur - ভবানীপà§র', '2023-07-24 17:07:18'),
(12, 'Member Bari - মেমà§বার বাড়ী', '2023-07-24 17:08:31'),
(13, 'Bagher Bazar - বাঘের বাজার', '2023-07-24 17:09:56'),
(14, 'Sreepur Chowrasta- শà§রীপà§র চৌরাসà§তা', '2023-07-24 17:17:34'),
(15, 'Proshikha Mor - পà§রশিকা মোড়', '2023-07-24 17:23:20'),
(16, 'Mawna Bazar - মাওনা বাজার', '2023-07-24 17:24:07'),
(17, 'Natun Bazar - নতà§ন বাজার', '2023-07-24 17:25:34'),
(18, 'Lichu Bagan - লিচà§বাগান', '2023-07-24 17:26:27'),
(19, 'Beraiderchala - বেড়াইদের চালা', '2023-07-24 17:27:17'),
(20, 'MC Bazar - à¦ম সি বাজার', '2023-07-24 17:28:37');

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

--
-- Table structure for table `ads_report`
--

CREATE TABLE `ads_report` (
  `id` int(255) NOT NULL,
  `report_user_id` varchar(255) NOT NULL,
  `product_id` varchar(255) NOT NULL,
  `date` timestamp NOT NULL DEFAULT current_timestamp(),
  `report_details` varchar(255) NOT NULL,
  `report_ads_title` varchar(255) NOT NULL,
  `report_ads_image` varchar(255) NOT NULL,
  `auth_id` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `ads_table`
--

CREATE TABLE `ads_table` (
  `id` int(255) NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `uploader_id` varchar(255) NOT NULL DEFAULT '0',
  `staus` varchar(255) NOT NULL,
  `details_ad` varchar(255) NOT NULL,
  `category_id` varchar(255) NOT NULL,
  `category_name` varchar(255) NOT NULL,
  `address_one` varchar(255) NOT NULL,
  `address_two` mediumtext NOT NULL,
  `address_tree` varchar(50) NOT NULL,
  `keywords_ads` varchar(255) NOT NULL,
  `created_date` timestamp NOT NULL DEFAULT current_timestamp(),
  `seller_email` varchar(255) NOT NULL,
  `seller_number` varchar(255) NOT NULL,
  `sell_status` varchar(50) NOT NULL,
  `description` varchar(255) NOT NULL,
  `uploader_name` varchar(255) NOT NULL,
  `user_image` varchar(255) NOT NULL,
  `taka` varchar(255) NOT NULL DEFAULT '0',
  `view_ads` varchar(50) NOT NULL,
  `currency` varchar(50) NOT NULL,
  `uploder_name` varchar(50) NOT NULL,
  `city_ads` varchar(50) NOT NULL,
  `condition_ads` varchar(50) NOT NULL,
  `warranty_ads` varchar(50) NOT NULL,
  `post_code` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `ads_table`
--

INSERT INTO `ads_table` (`id`, `title`, `image`, `uploader_id`, `staus`, `details_ad`, `category_id`, `category_name`, `address_one`, `address_two`, `address_tree`, `keywords_ads`, `created_date`, `seller_email`, `seller_number`, `sell_status`, `description`, `uploader_name`, `user_image`, `taka`, `view_ads`, `currency`, `uploder_name`, `city_ads`, `condition_ads`, `warranty_ads`, `post_code`) VALUES
(1, 'Hi', '', 'more_data', 'more_data', 'more_data', 'more_data', 'more_data', 'more_data', 'more_data', '', 'more_data', '2023-10-11 17:49:52', '', '', 'panding', '', '', '', '', '', '', '', '', 'Used', '', 0),
(2, 'some_data', 'more_data', '0', '', '', '', '', '', '', '', '', '2023-10-11 17:49:52', '', '', '', '', '', '', '0', '', '', '', '', '', '', 0),
(3, 'some_data', 'more_data', '0', '', '', '', '', '', '', '', '', '2023-10-11 17:49:52', '', '', '', '', '', '', '0', '', '', '', '', '', '', 0),
(4, 'some_data', 'more_data', '0', '', '', '', '', '', '', '', '', '2023-10-11 17:49:52', '', '', '', '', '', '', '0', '', '', '', '', '', '', 0),
(5, 'some_data', 'more_data', '0', '', '', '', '', '', '', '', '', '2023-10-11 17:49:52', '', '', '', '', '', '', '0', '', '', '', '', '', '', 0),
(6, 'some_data', 'more_data', '0', '', '', '', '', '', '', '', '', '2023-10-11 17:49:52', '', '', '', '', '', '', '0', '', '', '', '', '', '', 0),
(7, 'some_data', 'more_data', '0', '', '', '', '', '', '', '', '', '2023-10-11 17:49:52', '', '', '', '', '', '', '0', '', '', '', '', '', '', 0);

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

--
-- Table structure for table `app_setting`
--

CREATE TABLE `app_setting` (
  `id` int(255) NOT NULL,
  `app_currency` varchar(255) NOT NULL,
  `date` timestamp NOT NULL DEFAULT current_timestamp(),
  `refer_bonus` varchar(255) NOT NULL,
  `sign_up_bonus` varchar(255) NOT NULL,
  `admob_Interstitial_id` varchar(255) NOT NULL,
  `app_privacy` varchar(255) NOT NULL,
  `spin_ava_ch_basic` varchar(255) NOT NULL,
  `spin_ava_ch_standard` varchar(255) NOT NULL,
  `spin_ava_ch_silver` varchar(255) NOT NULL,
  `spin_ava_ch_gold` varchar(255) NOT NULL,
  `scratch_ava_ch_basic` varchar(255) NOT NULL,
  `scratch_spin_ava_ch_standard` varchar(255) NOT NULL,
  `scratch_spin_ava_ch_silver` varchar(255) NOT NULL,
  `scratch_spin_ava_ch_gold` varchar(255) NOT NULL,
  `scratch_reward` varchar(255) NOT NULL,
  `collect_reward_count` varchar(255) NOT NULL,
  `open_reward_count` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL DEFAULT '0',
  `admob_banner_id` varchar(255) NOT NULL,
  `admob_reward_id` varchar(255) NOT NULL,
  `pollfish_key_app` varchar(255) NOT NULL,
  `refer_page_text` varchar(255) NOT NULL,
  `int_ads_count` varchar(255) NOT NULL,
  `daily_reward` varchar(255) NOT NULL,
  `product_add_reward` varchar(255) NOT NULL,
  `collect_reward` varchar(255) NOT NULL,
  `collect_ava_ch_basic` varchar(255) NOT NULL,
  `collect_ava_ch_standard` varchar(255) NOT NULL,
  `collect_ava_ch_silver` varchar(255) NOT NULL,
  `collect_ava_ch_gold` varchar(255) NOT NULL,
  `copen_reward` varchar(255) NOT NULL,
  `open_ava_ch_basic` varchar(255) NOT NULL,
  `open_ava_ch_standard` varchar(255) NOT NULL,
  `open_ava_ch_silver` varchar(255) NOT NULL,
  `open_ava_ch_gold` varchar(255) NOT NULL,
  `bump_up_ads_cost` varchar(255) NOT NULL,
  `home_topbanner` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `app_setting`
--

INSERT INTO `app_setting` (`id`, `app_currency`, `date`, `refer_bonus`, `sign_up_bonus`, `admob_Interstitial_id`, `app_privacy`, `spin_ava_ch_basic`, `spin_ava_ch_standard`, `spin_ava_ch_silver`, `spin_ava_ch_gold`, `scratch_ava_ch_basic`, `scratch_spin_ava_ch_standard`, `scratch_spin_ava_ch_silver`, `scratch_spin_ava_ch_gold`, `scratch_reward`, `collect_reward_count`, `open_reward_count`, `status`, `admob_banner_id`, `admob_reward_id`, `pollfish_key_app`, `refer_page_text`, `int_ads_count`, `daily_reward`, `product_add_reward`, `collect_reward`, `collect_ava_ch_basic`, `collect_ava_ch_standard`, `collect_ava_ch_silver`, `collect_ava_ch_gold`, `copen_reward`, `open_ava_ch_basic`, `open_ava_ch_standard`, `open_ava_ch_silver`, `open_ava_ch_gold`, `bump_up_ads_cost`, `home_topbanner`) VALUES
(1, 'a', '2023-07-05 20:26:18', '500', '200', 'ca-app-pub-3940256099942544/1033173712', 'a', '10', '16', '20', '25', '20', '5', '10', '', '10', '5', '10', '0', 'ca-app-pub-3940256099942544/6300978111', 'ca-app-pub-3940256099942544/5354046379', 'testssssssssssssssssssssssssssssssssss', 'Earn Money Using Your Refer Code.', '2', '5', '5', '5', '5', '10', '15', '20', '5', '5', '10', '16', '22', '200', 'https://basabd.xyz:2083/admin/headerimage.png');

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

--
-- Table structure for table `bump_ads`
--

CREATE TABLE `bump_ads` (
  `id` int(255) NOT NULL,
  `ads_id` varchar(255) NOT NULL,
  `user_id` varchar(255) NOT NULL,
  `created_date` timestamp NOT NULL DEFAULT current_timestamp(),
  `status` varchar(255) NOT NULL DEFAULT 'pending',
  `title_bump` varchar(255) NOT NULL,
  `cost_coin` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `bump_ads`
--

INSERT INTO `bump_ads` (`id`, `ads_id`, `user_id`, `created_date`, `status`, `title_bump`, `cost_coin`) VALUES
(1, '9', '2222222', '2023-07-14 13:23:16', 'active', 'hhhhh', '200'),
(2, '18', '30577615', '2023-07-24 16:54:20', 'pending', 'I want to Bump Ad', '200');

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

--
-- Table structure for table `home_banner`
--

CREATE TABLE `home_banner` (
  `id` int(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `image` varchar(255) NOT NULL,
  `created_date` timestamp NOT NULL DEFAULT current_timestamp(),
  `status` varchar(255) NOT NULL DEFAULT '0',
  `category` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `home_banner`
--

INSERT INTO `home_banner` (`id`, `title`, `image`, `created_date`, `status`, `category`) VALUES
(1, 'à¦ামেলাহীন বাসা খà§জà§à¦ন, আমাদের সাথে', '5.png', '2023-07-13 17:48:52', '0', 'হাফ বিলà§ডিং বাসা'),
(2, 'আপনার পছেনà§দের বাসা', 'Slider.png', '2023-07-13 17:49:10', '0', 'ফà§যামিলি বাসা'),
(3, '', 'WhatsApp Image 2023-07-23 at 7.39.59 PM.jpeg', '2023-07-14 16:41:11', '0', 'ফà§যামিলি বাসা');

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

--
-- Table structure for table `notification`
--

CREATE TABLE `notification` (
  `id` int(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `full_text` varchar(255) NOT NULL,
  `created_date` timestamp NOT NULL DEFAULT current_timestamp(),
  `status` varchar(255) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `notification`
--

INSERT INTO `notification` (`id`, `title`, `full_text`, `created_date`, `status`) VALUES
(4, 'সà§বাগতম, বাসা বিডি', 'â€বাসা বিডিâ€ ভাড়া দেওয়া à¦বং বাসা ভাড়া খোà¦জার à¦কটি ডিজিটাল পà§লাটফরà§ম। â€বাসা বিডিâ€ ওয়েবসাইট à¦à', '2023-07-21 01:59:46', '0');

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

--
-- Table structure for table `package_item`
--

CREATE TABLE `package_item` (
  `id` int(255) NOT NULL,
  `package_name` varchar(255) NOT NULL,
  `package_title1` varchar(255) NOT NULL,
  `package_title2` varchar(255) NOT NULL,
  `package_title3` varchar(255) NOT NULL,
  `package_title4` varchar(255) NOT NULL,
  `package_title5` varchar(255) NOT NULL,
  `package_title6` varchar(255) NOT NULL,
  `package_title7` varchar(255) NOT NULL,
  `package_title8` varchar(255) NOT NULL,
  `date` timestamp NOT NULL DEFAULT current_timestamp(),
  `status` varchar(255) NOT NULL DEFAULT 'true',
  `package_amount` varchar(255) NOT NULL,
  `package_image` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `package_item`
--

INSERT INTO `package_item` (`id`, `package_name`, `package_title1`, `package_title2`, `package_title3`, `package_title4`, `package_title5`, `package_title6`, `package_title7`, `package_title8`, `date`, `status`, `package_amount`, `package_image`) VALUES
(7, 'Standard', 'dsa', 'dsadsa', 'dsad', 'asdsad', 'dasdas', 'dsad', 'sadsa', 'dsadas', '2023-07-07 17:41:51', 'true', 'dsadsa', 'find-your-path-vector-e997dd4d07a6859d9a9f9c40f6140b57.jpg'),
(9, 'Basic', 'Basic Package', 'Refer Bonus : 200 Coin', 'Daily Income : 1000 Coin', 'Minimum Payout Amount : 1000 Coin', 'Get Free House Address Monthly : 0', 'Show every House Address Cost : 200 Coin', 'Play Quiz (daily) : 05 Times', 'Play Games (daily) : 03 Times', '2023-07-21 01:32:41', 'true', '500', 'medal.png');

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

--
-- Table structure for table `package_payment`
--

CREATE TABLE `package_payment` (
  `id` int(255) NOT NULL,
  `payment_name` varchar(255) NOT NULL,
  `created_date` timestamp NOT NULL DEFAULT current_timestamp(),
  `type_details` varchar(255) NOT NULL,
  `type_details2` varchar(255) NOT NULL,
  `type_details3` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `package_payment`
--

INSERT INTO `package_payment` (`id`, `payment_name`, `created_date`, `type_details`, `type_details2`, `type_details3`) VALUES
(5, 'নগদ', '2023-07-21 01:49:59', 'আপনার নগদ à¦কাউনà§ট নমà§বর', 'আপনি সরà§বনিমà§ন ৫০০০ কয়েন উইথডà§র দিতে পারবেন।', '২৪ ঘনà§টার মধà§যে আপনার পেমেনà§ট না পেলে হেলà§পলাইন à¦ যোগাযোগ করà§ন'),
(6, 'বিকাশ', '2023-07-21 01:50:32', 'আপনার বিকাশ à¦কাউনà§ট নমà§বর', 'আপনি সরà§বনিমà§ন ৫০০০ কয়েন উইথডà§র দিতে পারবেন।', '২৪ ঘনà§টার মধà§যে আপনার পেমেনà§ট না পেলে হেলà§পলাইন à¦ যোগাযোগ করà§ন'),
(7, 'রকেট', '2023-07-21 01:50:54', 'আপনার রকেট à¦কাউনà§ট নমà§বর', 'আপনি সরà§বনিমà§ন ৫০০০ কয়েন উইথডà§র দিতে পারবেন।', '২৪ ঘনà§টার মধà§যে আপনার পেমেনà§ট না পেলে হেলà§পলাইন à¦ যোগাযোগ করà§ন');

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

--
-- Table structure for table `package_payment_request`
--

CREATE TABLE `package_payment_request` (
  `id` int(255) NOT NULL,
  `user_id` varchar(255) NOT NULL,
  `details1` varchar(255) NOT NULL,
  `details2` varchar(255) NOT NULL,
  `details3` varchar(255) NOT NULL,
  `created_date` timestamp NOT NULL DEFAULT current_timestamp(),
  `payment_name` varchar(255) NOT NULL,
  `payment_amount` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL DEFAULT 'pending',
  `package_name` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `payment_method`
--

CREATE TABLE `payment_method` (
  `id` int(255) NOT NULL,
  `payment_name` varchar(255) NOT NULL,
  `payment_icon` varchar(255) NOT NULL,
  `payment_amount` varchar(255) NOT NULL,
  `payment_coin` varchar(255) NOT NULL,
  `created_date` timestamp NOT NULL DEFAULT current_timestamp(),
  `type_hint` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `payment_method`
--

INSERT INTO `payment_method` (`id`, `payment_name`, `payment_icon`, `payment_amount`, `payment_coin`, `created_date`, `type_hint`, `status`) VALUES
(2, '   নগদ', 'Slider.png', '  50', '   5000', '2023-07-08 18:21:38', '   Minimum Coin Withdraw 5000', '0'),
(3, 'বিকাশ', 'Bkash.png', '50', '5000', '2023-07-08 18:22:36', 'Minimum Coin Withdraw 5000', '0'),
(4, 'রকেট', 'dutch-bangla-rocket-logo-B4D1CC458D-seeklogo.com.png', '50', '5000', '2023-07-21 01:03:08', 'Minimum Coin Withdraw 5000', '0');

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

--
-- Table structure for table `price_range_high`
--

CREATE TABLE `price_range_high` (
  `id` int(255) NOT NULL,
  `price` varchar(255) NOT NULL,
  `created_date` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `price_range_high`
--

INSERT INTO `price_range_high` (`id`, `price`, `created_date`) VALUES
(4, '৫০০০০', '2023-06-30 10:50:55'),
(8, '২০০০০', '2023-06-30 11:02:31'),
(13, '১৫০০০', '2023-06-30 11:33:08'),
(14, '১২০০০', '2023-07-21 01:22:51'),
(15, '১০০০০', '2023-07-21 01:23:04'),
(16, '৭০০০', '2023-07-21 01:23:16'),
(17, '৫০০০', '2023-07-21 01:23:25');

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

--
-- Table structure for table `price_range_low`
--

CREATE TABLE `price_range_low` (
  `id` int(255) NOT NULL,
  `price` varchar(255) NOT NULL,
  `created_date` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `price_range_low`
--

INSERT INTO `price_range_low` (`id`, `price`, `created_date`) VALUES
(2, '১৫০০', '2023-06-30 11:38:56'),
(3, '২০০০', '2023-06-30 11:41:58'),
(4, '৩০০০', '2023-06-30 11:49:28'),
(5, '৩৫০০', '2023-06-30 11:49:35'),
(6, '৪০০০', '2023-07-21 01:24:32'),
(7, '৪৫০০', '2023-07-21 01:24:47'),
(8, '৫০০০', '2023-07-21 01:24:56');

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

--
-- Table structure for table `product_rating`
--

CREATE TABLE `product_rating` (
  `id` int(255) NOT NULL,
  `uploader_id` varchar(255) NOT NULL,
  `product_id` varchar(255) NOT NULL,
  `rating_value` varchar(255) NOT NULL,
  `timestamp` varchar(255) NOT NULL,
  `comment` varchar(255) NOT NULL,
  `user_id` varchar(255) NOT NULL,
  `user_name` varchar(255) NOT NULL,
  `user_image` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `product_rating`
--

INSERT INTO `product_rating` (`id`, `uploader_id`, `product_id`, `rating_value`, `timestamp`, `comment`, `user_id`, `user_name`, `user_image`) VALUES
(1, '55338355', '4', '5.0', '2023-07-13 18:14:55', 'nice', '55338355', 'xjxd dndndx', 'ic_avatar_default_1.png'),
(2, '48413779', '12', '5.0', '2023-07-20 19:35:44', 'Nice', '48413779', 'App Test', 'ic_avatar_default_1.png');

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

--
-- Table structure for table `product_viwer_store`
--

CREATE TABLE `product_viwer_store` (
  `id` int(255) NOT NULL,
  `product_id` varchar(255) NOT NULL,
  `user_id` varchar(255) NOT NULL,
  `created_date` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `product_viwer_store`
--

INSERT INTO `product_viwer_store` (`id`, `product_id`, `user_id`, `created_date`) VALUES
(1, '7', '55338355', '2023-07-13 18:10:37'),
(2, '4', '55338355', '2023-07-13 18:12:55'),
(3, '4', '55338355', '2023-07-13 18:14:27'),
(4, '4', '55338355', '2023-07-13 18:15:05'),
(5, '2', '55338355', '2023-07-13 18:15:17'),
(6, '4', '55338355', '2023-07-13 18:17:03'),
(7, '7', '55338355', '2023-07-13 18:17:21'),
(8, '4', '55338355', '2023-07-13 18:17:34'),
(9, '4', '55338355', '2023-07-13 18:17:39'),
(10, '4', '55338355', '2023-07-13 18:19:00'),
(11, '1', '17743349', '2023-07-13 18:33:24'),
(12, '1', '17743349', '2023-07-13 18:33:41'),
(13, '1', '17743349', '2023-07-13 18:33:51'),
(14, '2', '17743349', '2023-07-13 18:33:54'),
(15, '4', '31134743', '2023-07-13 19:17:34'),
(16, '1', '31134743', '2023-07-13 19:18:01'),
(17, '9', '2222222', '2023-07-14 13:23:09'),
(18, '4', '2222222', '2023-07-14 13:45:56'),
(19, '4', '2222222', '2023-07-14 13:46:16'),
(20, '7', '2222222', '2023-07-14 13:48:46'),
(21, '2', '88125850', '2023-07-14 14:11:51'),
(22, '1', '88125850', '2023-07-14 14:13:07'),
(23, '4', '88125850', '2023-07-14 14:31:35'),
(24, '4', '88125850', '2023-07-14 14:38:29'),
(25, '2', '88125850', '2023-07-14 14:41:40'),
(26, '11', '88125850', '2023-07-14 14:43:24'),
(27, '11', '88125850', '2023-07-14 14:43:47'),
(28, '4', '88125850', '2023-07-14 15:08:00'),
(29, '4', '88125850', '2023-07-14 15:50:02'),
(30, '11', '88125850', '2023-07-14 15:54:04'),
(31, '1', '88125850', '2023-07-15 09:06:55'),
(32, '9', '88125850', '2023-07-15 15:12:49'),
(33, '4', '2222222', '2023-07-15 15:17:20'),
(34, '11', '88125850', '2023-07-15 15:28:09'),
(35, '11', '88125850', '2023-07-15 15:40:03'),
(36, '2', '56975995', '2023-07-15 15:41:33'),
(37, '4', '2222222', '2023-07-16 01:54:53'),
(38, '1', '2222222', '2023-07-16 01:59:24'),
(39, '2', '88125850', '2023-07-16 14:51:22'),
(40, '12', '48413779', '2023-07-20 13:34:28'),
(41, '12', '48413779', '2023-07-20 13:35:37'),
(42, '13', '48413779', '2023-07-20 13:45:25'),
(43, '13', '48413779', '2023-07-20 13:46:00'),
(44, '13', '48413779', '2023-07-20 13:46:08'),
(45, '13', '48413779', '2023-07-20 15:07:13'),
(46, '4', '67047827', '2023-07-20 16:35:29'),
(47, '2', '67047827', '2023-07-21 03:30:56'),
(48, '12', '62790463', '2023-07-21 14:05:53'),
(49, '13', '62790463', '2023-07-21 14:06:09'),
(50, '12', '67047827', '2023-07-22 02:12:51'),
(51, '12', '67047827', '2023-07-22 05:54:30'),
(52, '16', '67047827', '2023-07-22 06:00:37'),
(53, '12', '30577615', '2023-07-22 13:18:50'),
(54, '16', '67047827', '2023-07-23 02:42:49'),
(55, '10', '67047827', '2023-07-23 06:24:46'),
(56, '7', '67047827', '2023-07-24 11:02:33'),
(57, '15', '67047827', '2023-07-24 11:10:15'),
(58, '9', '67047827', '2023-07-24 13:26:07'),
(59, '18', '30577615', '2023-07-24 16:40:04'),
(60, '18', '30577615', '2023-07-24 16:41:05'),
(61, '18', '30577615', '2023-07-24 16:42:01'),
(62, '20', '67047827', '2023-07-24 16:56:20'),
(63, '20', '67047827', '2023-07-24 16:57:16'),
(64, '20', '67047827', '2023-07-24 16:58:48'),
(65, '19', '67047827', '2023-07-24 16:59:28'),
(66, '20', '67047827', '2023-07-24 17:00:07'),
(67, '20', '67047827', '2023-07-24 17:00:22'),
(68, '18', '67047827', '2023-07-24 17:00:41'),
(69, '18', '62790463', '2023-07-25 01:31:51'),
(70, '20', '62790463', '2023-07-25 01:38:19'),
(71, '19', '30577615', '2023-07-25 03:08:07'),
(72, '18', '30577615', '2023-07-25 03:10:11'),
(73, '19', '30577615', '2023-07-25 03:10:22'),
(74, '18', '67047827', '2023-07-25 18:02:49'),
(75, '20', '30577615', '2023-07-26 00:33:04'),
(76, '18', '62790463', '2023-07-26 02:17:59'),
(77, '19', '62790463', '2023-07-26 02:18:27'),
(78, '18', '62790463', '2023-07-26 02:18:44'),
(79, '19', '67047827', '2023-07-27 20:26:21'),
(80, '15', '62790463', '2023-07-30 14:28:47'),
(81, '15', '62790463', '2023-07-30 14:28:57'),
(82, '15', '62790463', '2023-07-31 15:32:58'),
(83, '18', '62790463', '2023-08-03 09:52:22'),
(84, '19', '62790463', '2023-08-03 09:52:58'),
(85, '18', '30577615', '2023-08-03 15:17:30'),
(86, '18', '30577615', '2023-08-03 15:17:40'),
(87, '18', '30577615', '2023-08-03 15:17:49'),
(88, '19', '95450535', '2023-08-04 03:09:07'),
(89, '19', '95450535', '2023-08-04 03:09:46'),
(90, '18', '95450535', '2023-08-04 03:09:49'),
(91, '24', '95450535', '2023-08-07 13:44:00'),
(92, '19', '62790463', '2023-08-10 10:56:09'),
(93, '19', '62790463', '2023-08-10 10:56:14'),
(94, '19', '95450535', '2023-09-02 14:49:54'),
(95, '25', '30577615', '2023-09-03 14:07:39'),
(96, '18', '95450535', '2023-09-04 10:38:21'),
(97, '19', '62790463', '2023-09-13 13:02:39'),
(98, '19', '64204251', '2023-10-06 12:41:11'),
(99, '18', '64204251', '2023-10-06 12:53:02'),
(100, '20', '64204251', '2023-10-06 13:04:41'),
(101, '28', '64204251', '2023-10-11 14:49:22'),
(102, '19', '64204251', '2023-10-11 14:57:33'),
(103, '20', '64204251', '2023-10-11 14:58:00'),
(104, '25', '64204251', '2023-10-11 15:18:49');

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

--
-- Table structure for table `quiz_app`
--

CREATE TABLE `quiz_app` (
  `id` int(255) NOT NULL,
  `option1` varchar(255) NOT NULL,
  `option2` varchar(255) NOT NULL,
  `option3` varchar(255) NOT NULL,
  `option4` varchar(255) NOT NULL,
  `category_name` varchar(255) NOT NULL,
  `reward` varchar(255) NOT NULL,
  `date` timestamp NOT NULL DEFAULT current_timestamp(),
  `question` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `quiz_app`
--

INSERT INTO `quiz_app` (`id`, `option1`, `option2`, `option3`, `option4`, `category_name`, `reward`, `date`, `question`, `status`) VALUES
(5, 'শà§রীলঙà§কার কà§মার সাঙà§গাকারা।', 'সাকিব আল হাসান', 'সচিন টেনà§ডà§লকার', 'মারà§টিন গাপটিল', 'SPORTS - খেলাধà§লা', 'আপনি ৫ কয়েন জিতেছেন', '2023-07-21 05:57:37', 'বিশà§বকাপ কà§রিকেট ২০১৫ তে কোন কà§রিকেটার সব থেকে বেশি রান করার রেকরà§ড অরà§জন করলেন ?', '0'),
(6, '১৮৯৭ সালের ১৫ ই মে।', '১৮৬৭ সালের ১৫ ই মে।', '১৮৭৮৭ সালের ১৫ ই মারà§চ।', '১৮৭৭ সালের ১৫ ই মারà§চ।', 'SPORTS - খেলাধà§লা', 'আপনি ৫ কয়েন জিতেছেন', '2023-07-21 05:59:51', 'বিশà§বে পà§রথম টেসà§ট মà§যাচটি কত সালে অনà§ষà§ঠিত হয় ?', '0'),
(7, 'aa', 'a', 'a', 'aaaaaaaa', 'Math', '20', '2023-10-06 12:42:31', 'aaa', '0'),
(8, 'aads', 'aaaa', 'aaa', 'aaaaaaaaaaaa', 'Math', '30', '2023-10-06 12:42:51', 'dasdsa', '0');

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

--
-- Table structure for table `quiz_cat`
--

CREATE TABLE `quiz_cat` (
  `id` int(255) NOT NULL,
  `cat_title` varchar(255) NOT NULL,
  `cat_image` varchar(255) NOT NULL,
  `date` timestamp NOT NULL DEFAULT current_timestamp(),
  `status` varchar(255) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `quiz_cat`
--

INSERT INTO `quiz_cat` (`id`, `cat_title`, `cat_image`, `date`, `status`) VALUES
(3, 'SPORTS - খেলাধà§লা', '2.Sports icons.png', '2023-07-08 10:36:33', '0'),
(4, 'জà§ঞান- বিজà§ঞান', 'medal.png', '2023-07-08 10:36:47', '0'),
(5, 'Math', 'accounting.png', '2023-07-08 15:19:21', '0');

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

--
-- Table structure for table `seller_ac_report`
--

CREATE TABLE `seller_ac_report` (
  `id` int(255) NOT NULL,
  `user_id` varchar(255) NOT NULL,
  `seller_id` varchar(255) NOT NULL,
  `date` timestamp NOT NULL DEFAULT current_timestamp(),
  `report_details` varchar(255) NOT NULL,
  `seller_image` varchar(255) NOT NULL,
  `seller_name` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `user_tracking`
--

CREATE TABLE `user_tracking` (
  `id` int(255) NOT NULL,
  `user_id` varchar(255) NOT NULL,
  `created_date` timestamp NOT NULL DEFAULT current_timestamp(),
  `points` varchar(255) NOT NULL,
  `type_earn` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `user_tracking`
--

INSERT INTO `user_tracking` (`id`, `user_id`, `created_date`, `points`, `type_earn`) VALUES
(1, '48413779', '2023-07-20 13:32:16', '20', 'Sign up Bonus'),
(2, '48413779', '2023-07-20 13:33:37', '5', 'Product Add Reward'),
(3, '48413779', '2023-07-20 13:44:02', '5', 'Product Add Reward'),
(4, '58710202', '2023-07-20 14:09:31', '20', 'Sign up Bonus'),
(5, '25980479', '2023-07-20 14:10:48', '20', 'Sign up Bonus'),
(6, '25980479', '2023-07-20 14:10:58', '', 'Pending Refer'),
(7, '48413779', '2023-07-20 14:11:39', '33', 'Refer claim completed'),
(8, '99112165', '2023-07-20 14:15:38', '20', 'Sign up Bonus'),
(9, '99112165', '2023-07-20 14:16:45', '5', 'Product Add Reward'),
(10, '67047827', '2023-07-20 16:25:07', '20', 'Sign up Bonus'),
(11, '30577615', '2023-07-20 16:29:39', '200', 'Sign up Bonus'),
(12, '67047827', '2023-07-20 16:33:12', '11', 'Spin Win Reward'),
(13, '67047827', '2023-07-20 16:33:30', '1', 'Spin Win Reward'),
(14, '67047827', '2023-07-20 16:34:01', '10', 'Scratch Win Reward'),
(15, '67047827', '2023-07-20 16:34:18', '5', 'Collect Reward'),
(16, '67047827', '2023-07-20 16:35:15', '20', 'Quiz Earn'),
(17, '67047827', '2023-07-20 16:36:51', '10', 'Scratch Win Reward'),
(18, '67047827', '2023-07-20 16:43:25', '5', 'Collect Reward'),
(19, '79660853', '2023-07-20 16:51:49', '200', 'Sign up Bonus'),
(20, '67047827', '2023-07-20 17:00:33', '5', 'Collect Reward'),
(21, '67047827', '2023-07-20 18:53:40', '8', 'Spin Win Reward'),
(22, '67047827', '2023-07-20 18:53:59', '5', 'Spin Win Reward'),
(23, '67047827', '2023-07-20 18:54:10', '15', 'Spin Win Reward'),
(24, '67047827', '2023-07-20 18:54:24', '95', 'Spin Win Reward'),
(25, '67047827', '2023-07-20 18:54:33', '11', 'Spin Win Reward'),
(26, '67047827', '2023-07-20 18:54:43', '65', 'Spin Win Reward'),
(27, '67047827', '2023-07-20 18:55:05', '95', 'Spin Win Reward'),
(28, '67047827', '2023-07-20 18:55:17', '19', 'Spin Win Reward'),
(29, '67047827', '2023-07-20 18:55:30', '10', 'Scratch Win Reward'),
(30, '67047827', '2023-07-20 18:55:36', '10', 'Scratch Win Reward'),
(31, '67047827', '2023-07-20 18:55:43', '10', 'Scratch Win Reward'),
(32, '67047827', '2023-07-20 18:55:49', '10', 'Scratch Win Reward'),
(33, '67047827', '2023-07-20 18:55:59', '10', 'Scratch Win Reward'),
(34, '67047827', '2023-07-20 18:56:06', '10', 'Scratch Win Reward'),
(35, '67047827', '2023-07-20 18:56:15', '10', 'Scratch Win Reward'),
(36, '67047827', '2023-07-20 18:56:22', '10', 'Scratch Win Reward'),
(37, '67047827', '2023-07-20 18:56:30', '10', 'Scratch Win Reward'),
(38, '67047827', '2023-07-20 18:56:36', '10', 'Scratch Win Reward'),
(39, '67047827', '2023-07-20 18:56:42', '10', 'Scratch Win Reward'),
(40, '67047827', '2023-07-20 18:56:49', '10', 'Scratch Win Reward'),
(41, '67047827', '2023-07-20 18:56:55', '10', 'Scratch Win Reward'),
(42, '67047827', '2023-07-20 18:57:01', '5', 'Daily Reward'),
(43, '67047827', '2023-07-20 18:57:25', '5', 'Collect Reward'),
(44, '67047827', '2023-07-20 18:57:55', '5', 'Collect Reward'),
(45, '30577615', '2023-07-21 01:55:00', '1', 'Spin Win Reward'),
(46, '30577615', '2023-07-21 01:55:26', '10', 'Scratch Win Reward'),
(47, '30577615', '2023-07-21 01:55:37', '5', 'Daily Reward'),
(48, '30577615', '2023-07-21 01:55:51', '5', 'Collect Reward'),
(49, '30577615', '2023-07-21 01:56:26', '5', 'Collect Reward'),
(50, '67047827', '2023-07-21 03:31:06', '10', 'Scratch Win Reward'),
(51, '30577615', '2023-07-21 06:01:28', '0', 'Quiz Earn'),
(52, '67047827', '2023-07-21 08:54:11', '5', 'Collect Reward'),
(53, '67047827', '2023-07-21 08:54:18', '5', 'Collect Reward'),
(54, '62790463', '2023-07-21 10:31:38', '200', 'Sign up Bonus'),
(55, '67047827', '2023-07-21 12:42:40', '10', 'Scratch Win Reward'),
(56, '67047827', '2023-07-21 12:42:47', '10', 'Scratch Win Reward'),
(57, '67047827', '2023-07-21 12:42:54', '10', 'Scratch Win Reward'),
(58, '67047827', '2023-07-21 12:43:01', '10', 'Scratch Win Reward'),
(59, '67047827', '2023-07-21 12:43:39', '0', 'Quiz Earn'),
(60, '67047827', '2023-07-22 02:12:11', '5', 'Daily Reward'),
(61, '67047827', '2023-07-22 06:00:18', '5', 'Product Add Reward'),
(62, '62790463', '2023-07-22 09:14:54', '15', 'Spin Win Reward'),
(63, '62790463', '2023-07-22 09:15:10', '65', 'Spin Win Reward'),
(64, '62790463', '2023-07-22 09:15:33', '65', 'Spin Win Reward'),
(65, '62790463', '2023-07-22 09:15:47', '11', 'Spin Win Reward'),
(66, '62790463', '2023-07-22 09:15:55', '7', 'Spin Win Reward'),
(67, '62790463', '2023-07-22 09:16:08', '5', 'Spin Win Reward'),
(68, '62790463', '2023-07-22 09:16:23', '1', 'Spin Win Reward'),
(69, '67047827', '2023-07-22 17:14:51', '10', 'Scratch Win Reward'),
(70, '67047827', '2023-07-22 17:15:02', '5', 'Collect Reward'),
(71, '67047827', '2023-07-23 02:03:31', '5', 'Daily Reward'),
(72, '67047827', '2023-07-23 02:03:56', '10', 'Scratch Win Reward'),
(73, '67047827', '2023-07-23 02:04:03', '10', 'Scratch Win Reward'),
(74, '67047827', '2023-07-23 02:04:10', '10', 'Scratch Win Reward'),
(75, '67047827', '2023-07-23 02:04:17', '10', 'Scratch Win Reward'),
(76, '67047827', '2023-07-23 02:04:23', '10', 'Scratch Win Reward'),
(77, '67047827', '2023-07-23 02:04:30', '10', 'Scratch Win Reward'),
(78, '67047827', '2023-07-23 02:04:37', '10', 'Scratch Win Reward'),
(79, '67047827', '2023-07-23 02:04:43', '10', 'Scratch Win Reward'),
(80, '67047827', '2023-07-23 02:04:50', '10', 'Scratch Win Reward'),
(81, '67047827', '2023-07-23 02:04:57', '10', 'Scratch Win Reward'),
(82, '67047827', '2023-07-23 02:05:06', '10', 'Scratch Win Reward'),
(83, '67047827', '2023-07-23 02:05:11', '10', 'Scratch Win Reward'),
(84, '67047827', '2023-07-23 02:05:18', '10', 'Scratch Win Reward'),
(85, '67047827', '2023-07-23 02:05:25', '10', 'Scratch Win Reward'),
(86, '67047827', '2023-07-23 02:05:34', '10', 'Scratch Win Reward'),
(87, '67047827', '2023-07-23 02:05:42', '10', 'Scratch Win Reward'),
(88, '67047827', '2023-07-23 02:05:52', '10', 'Scratch Win Reward'),
(89, '67047827', '2023-07-23 02:05:58', '10', 'Scratch Win Reward'),
(90, '67047827', '2023-07-23 02:06:06', '10', 'Scratch Win Reward'),
(91, '67047827', '2023-07-23 02:06:35', '5', 'Collect Reward'),
(92, '67047827', '2023-07-23 02:06:43', '5', 'Collect Reward'),
(93, '67047827', '2023-07-23 02:06:58', '5', 'Collect Reward'),
(94, '67047827', '2023-07-23 02:07:02', '5', 'Collect Reward'),
(95, '67047827', '2023-07-23 02:07:25', '5', 'Collect Reward'),
(96, '67047827', '2023-07-23 02:07:30', '5', 'Collect Reward'),
(97, '67047827', '2023-07-23 02:07:45', '5', 'Collect Reward'),
(98, '67047827', '2023-07-23 02:07:50', '5', 'Collect Reward'),
(99, '67047827', '2023-07-23 02:07:53', '5', 'Collect Reward'),
(100, '67047827', '2023-07-23 02:07:58', '5', 'Collect Reward'),
(101, '67047827', '2023-07-23 02:08:04', '5', 'Collect Reward'),
(102, '67047827', '2023-07-23 02:08:08', '5', 'Collect Reward'),
(103, '67047827', '2023-07-23 02:08:31', '0', 'Quiz Earn'),
(104, '67047827', '2023-07-23 02:08:42', '0', 'Quiz Earn'),
(105, '67047827', '2023-07-23 02:09:47', '0', 'Quiz Earn'),
(106, '67047827', '2023-07-23 02:10:06', '0', 'Quiz Earn'),
(107, '67047827', '2023-07-23 02:10:19', '0', 'Quiz Earn'),
(108, '67047827', '2023-07-23 02:28:00', '0', 'Quiz Earn'),
(109, '67047827', '2023-07-23 02:30:24', '0', 'Quiz Earn'),
(110, '67047827', '2023-07-23 02:30:33', '0', 'Quiz Earn'),
(111, '67047827', '2023-07-23 02:44:15', '5', 'Product Add Reward'),
(112, '67047827', '2023-07-24 02:50:42', '5', 'Daily Reward'),
(113, '67047827', '2023-07-24 02:50:59', '5', 'Collect Reward'),
(114, '67047827', '2023-07-24 02:51:05', '5', 'Collect Reward'),
(115, '67047827', '2023-07-24 02:51:18', '5', 'Collect Reward'),
(116, '67047827', '2023-07-24 02:51:23', '5', 'Collect Reward'),
(117, '67047827', '2023-07-24 02:51:28', '5', 'Collect Reward'),
(118, '67047827', '2023-07-24 02:52:19', '0', 'Quiz Earn'),
(119, '67047827', '2023-07-24 02:53:23', '0', 'Quiz Earn'),
(120, '67047827', '2023-07-24 13:27:09', '0', 'Quiz Earn'),
(121, '30577615', '2023-07-24 16:39:37', '5', 'Product Add Reward'),
(122, '30577615', '2023-07-24 16:48:53', '5', 'Product Add Reward'),
(123, '67047827', '2023-07-24 16:55:34', '5', 'Product Add Reward'),
(124, '67047827', '2023-07-24 17:08:36', '5', 'Product Add Reward'),
(125, '67047827', '2023-07-24 23:28:06', '5', 'Daily Reward'),
(126, '30577615', '2023-07-25 13:43:33', '19', 'Spin Win Reward'),
(127, '30577615', '2023-07-25 13:43:51', '11', 'Spin Win Reward'),
(128, '30577615', '2023-07-25 13:44:16', '5', 'Spin Win Reward'),
(129, '30577615', '2023-07-25 13:44:28', '6', 'Spin Win Reward'),
(130, '30577615', '2023-07-25 13:44:41', '95', 'Spin Win Reward'),
(131, '30577615', '2023-07-25 13:44:59', '7', 'Spin Win Reward'),
(132, '30577615', '2023-07-25 13:45:12', '95', 'Spin Win Reward'),
(133, '30577615', '2023-07-25 13:45:28', '1', 'Spin Win Reward'),
(134, '30577615', '2023-07-25 13:45:39', '6', 'Spin Win Reward'),
(135, '30577615', '2023-07-25 13:46:24', '10', 'Scratch Win Reward'),
(136, '67047827', '2023-07-25 18:03:54', '5', 'Daily Reward'),
(137, '67047827', '2023-07-26 04:27:42', '10', 'Scratch Win Reward'),
(138, '67047827', '2023-07-26 04:27:49', '10', 'Scratch Win Reward'),
(139, '67047827', '2023-07-26 04:27:55', '10', 'Scratch Win Reward'),
(140, '67047827', '2023-07-26 04:28:01', '10', 'Scratch Win Reward'),
(141, '67047827', '2023-07-26 04:28:05', '10', 'Scratch Win Reward'),
(142, '67047827', '2023-07-26 04:28:11', '10', 'Scratch Win Reward'),
(143, '67047827', '2023-07-27 03:36:02', '10', 'Scratch Win Reward'),
(144, '67047827', '2023-07-27 03:36:11', '10', 'Scratch Win Reward'),
(145, '67047827', '2023-07-27 03:36:22', '5', 'Daily Reward'),
(146, '67047827', '2023-07-27 20:27:01', '10', 'Scratch Win Reward'),
(147, '67047827', '2023-07-27 20:27:09', '10', 'Scratch Win Reward'),
(148, '67047827', '2023-07-28 07:47:46', '5', 'Daily Reward'),
(149, '58340519', '2023-07-28 09:11:25', '200', 'Sign up Bonus'),
(150, '58340519', '2023-07-28 09:12:29', '', 'Pending Refer'),
(151, '95450535', '2023-08-01 16:16:16', '200', 'Sign up Bonus'),
(152, '95450535', '2023-08-02 07:49:51', '10', 'Scratch Win Reward'),
(153, '95450535', '2023-08-02 07:49:51', '5', 'Daily Reward'),
(154, '95450535', '2023-08-02 07:49:55', '5', 'Collect Reward'),
(155, '95450535', '2023-08-02 07:50:15', '10', 'Scratch Win Reward'),
(156, '62790463', '2023-08-03 09:57:55', '5', 'Product Add Reward'),
(157, '70787950', '2023-08-03 11:33:01', '200', 'Sign up Bonus'),
(158, '95450535', '2023-08-07 13:38:10', '5', 'Product Add Reward'),
(159, '95450535', '2023-09-02 07:26:45', '8', 'Spin Win Reward'),
(160, '95450535', '2023-09-03 03:02:43', '0', 'Quiz Earn'),
(161, '95450535', '2023-09-03 03:03:29', '0', 'Quiz Earn'),
(162, '95450535', '2023-09-03 03:04:19', '19', 'Spin Win Reward'),
(163, '30577615', '2023-09-03 04:06:58', '5', 'Product Add Reward'),
(164, '95450535', '2023-09-05 10:30:40', '5', 'Daily Reward'),
(165, '95450535', '2023-09-05 10:31:02', '5', 'Collect Reward'),
(166, '95450535', '2023-09-05 10:31:07', '5', 'Collect Reward'),
(167, '64204251', '2023-10-06 12:41:00', '200', 'Sign up Bonus'),
(168, '64204251', '2023-10-06 12:41:55', '0', 'Quiz Earn'),
(169, '64204251', '2023-10-06 12:52:07', '50', 'Quiz Earn'),
(170, '30577615', '2023-10-07 02:08:24', '30', 'Quiz Earn'),
(171, '30577615', '2023-10-07 02:18:43', '0', 'Quiz Earn'),
(172, '30577615', '2023-10-10 16:06:27', '0', 'Quiz Earn'),
(173, '30577615', '2023-10-11 10:58:26', '10', 'Scratch Win Reward'),
(174, '30577615', '2023-10-11 10:58:33', '5', 'Daily Reward');

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

--
-- Table structure for table `withdrawal`
--

CREATE TABLE `withdrawal` (
  `id` int(255) NOT NULL,
  `user_id` varchar(255) NOT NULL,
  `package_amount` varchar(255) NOT NULL,
  `payment_coin` varchar(255) NOT NULL,
  `date` timestamp NOT NULL DEFAULT current_timestamp(),
  `payment_id` varchar(255) NOT NULL,
  `payment_info` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL DEFAULT 'pending',
  `payment_method` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `withdrawal`
--

INSERT INTO `withdrawal` (`id`, `user_id`, `package_amount`, `payment_coin`, `date`, `payment_id`, `payment_info`, `status`, `payment_method`) VALUES
(1, '48413779', '200 taka', '2000', '2023-07-20 14:05:01', 'bb', 'bb', 'approved', 'Bkash'),
(3, '48413779', '200 taka', '2000', '2023-07-20 14:08:12', 'bbb', 'bvg', 'rejected', 'Bkash');

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

--
-- Table structure for table `your_table`
--

CREATE TABLE `your_table` (
  `id` int(11) NOT NULL,
  `name` varchar(50) NOT NULL,
  `email` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `ads_location`
--
ALTER TABLE `ads_location`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26;

--
-- AUTO_INCREMENT for table `ads_location2`
--
ALTER TABLE `ads_location2`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27;

--
-- AUTO_INCREMENT for table `ads_location_tree`
--
ALTER TABLE `ads_location_tree`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `package_item`
--
ALTER TABLE `package_item`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

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

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

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

--
-- AUTO_INCREMENT for table `price_range_high`
--
ALTER TABLE `price_range_high`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

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

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

--
-- AUTO_INCREMENT for table `product_viwer_store`
--
ALTER TABLE `product_viwer_store`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=105;

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

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

--
-- AUTO_INCREMENT for table `seller_ac_report`
--
ALTER TABLE `seller_ac_report`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `user_tracking`
--
ALTER TABLE `user_tracking`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=175;

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

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

