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

START TRANSACTION;



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

--
-- Table structure for table `ads_settings`
--

CREATE TABLE `ads_settings` (
  `id` int(11) NOT NULL,
  `app_id` varchar(255) DEFAULT NULL,
  `interstitial_ad_unit` varchar(255) DEFAULT NULL,
  `native_ad_unit` varchar(255) DEFAULT NULL,
  `banner_ad_unit` varchar(255) DEFAULT NULL,
  `reward_ad_unit` varchar(255) DEFAULT NULL,
  `appopen_ad_unit` varchar(255) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `ads_settings`
--

INSERT INTO `ads_settings` (`id`, `app_id`, `interstitial_ad_unit`, `native_ad_unit`, `banner_ad_unit`, `reward_ad_unit`, `appopen_ad_unit`, `created_at`, `updated_at`) VALUES
(1, 'ca-app-pub-7664893030317051~8013728480', '/21775744923/example/interstitial', '/21775744923/example/native-video', '/21775744923/example/adaptive-banner', '/21775744923/example/rewarded', '/21775744923/example/app-open', '2025-06-22 18:59:24', '2025-09-27 11:37:53');

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

--
-- Table structure for table `ad_controls`
--

CREATE TABLE `ad_controls` (
  `id` int(11) NOT NULL,
  `screen_name` enum('quiz','reward_screen','correct_spelling','image_puzzle','find_faster','math_check','app_open','color_finder','meaning_match','emoji_maths') NOT NULL,
  `interstitial_ad` tinyint(1) DEFAULT 1,
  `banner_ad` tinyint(1) DEFAULT 1,
  `native_ad` tinyint(1) DEFAULT 1,
  `reward_ad` tinyint(1) DEFAULT 1,
  `appopen_ad` tinyint(1) DEFAULT 1,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `ad_controls`
--

INSERT INTO `ad_controls` (`id`, `screen_name`, `interstitial_ad`, `banner_ad`, `native_ad`, `reward_ad`, `appopen_ad`, `created_at`) VALUES
(2, 'color_finder', 1, 0, 1, 1, 0, '2025-06-23 11:09:02'),
(3, 'meaning_match', 1, 0, 1, 1, 0, '2025-06-23 11:09:02'),
(4, 'emoji_maths', 1, 0, 0, 1, 0, '2025-06-23 11:09:02'),
(5, 'reward_screen', 0, 0, 1, 0, 1, '2025-06-23 11:09:02'),
(6, 'app_open', 0, 0, 0, 0, 1, '2025-06-23 11:09:02');

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

--
-- Table structure for table `app_settings`
--

CREATE TABLE `app_settings` (
  `id` int(11) NOT NULL DEFAULT 1,
  `claim_timer` int(11) DEFAULT 30,
  `website_task_enabled` tinyint(1) DEFAULT 0,
  `task_limits_enabled` tinyint(1) DEFAULT 1,
  `referrer_coins` int(11) DEFAULT 50,
  `referred_coins` int(11) DEFAULT 50,
  `referral_coin_threshold` int(11) DEFAULT 500,
  `daily_checkin_coins` int(11) DEFAULT 50,
  `app_link` varchar(255) DEFAULT '',
  `version` varchar(10) DEFAULT '1.0.0',
  `version_code` int(11) DEFAULT 1,
  `changelogs` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `maintenance_mode` tinyint(1) DEFAULT 0,
  `vpn_allowed` tinyint(1) DEFAULT 1,
  `how_to_link` varchar(255) DEFAULT '',
  `telegram_link` varchar(255) DEFAULT '',
  `support_link` varchar(255) DEFAULT '',
  `guest_mode` int(11) DEFAULT 0,
  `earning_mode` int(11) DEFAULT 1 COMMENT '(0 - OFF  1 - ON  2 - Check)',
  `gamezop_timer` int(11) DEFAULT 10,
  `app_base_url` varchar(255) DEFAULT NULL,
  `ad_app_size` int(11) DEFAULT NULL,
  `update_mode` varchar(10) DEFAULT 'off',
  `native_ad_load_refresh_count` int(11) DEFAULT 0,
  `gamezop_card_status` int(11) DEFAULT 1,
  `daily_withdraw_limit` int(11) DEFAULT 1,
  `rate_limit_count` int(11) DEFAULT 100,
  `upi_transfer_enable` int(11) DEFAULT 1,
  `delete_url` varchar(255) DEFAULT NULL,
  `packages` varchar(255) DEFAULT NULL,
  `privacy_policy_url` varchar(255) DEFAULT NULL,
  `gamezop_link` varchar(255) DEFAULT NULL,
  `close_APP` int(255) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `app_settings`
--

INSERT INTO `app_settings` (`id`, `claim_timer`, `website_task_enabled`, `task_limits_enabled`, `referrer_coins`, `referred_coins`, `referral_coin_threshold`, `daily_checkin_coins`, `app_link`, `version`, `version_code`, `changelogs`, `maintenance_mode`, `vpn_allowed`, `how_to_link`, `telegram_link`, `support_link`, `guest_mode`, `earning_mode`, `gamezop_timer`, `app_base_url`, `ad_app_size`, `update_mode`, `native_ad_load_refresh_count`, `gamezop_card_status`, `daily_withdraw_limit`, `rate_limit_count`, `upi_transfer_enable`, `delete_url`, `packages`, `privacy_policy_url`, `gamezop_link`, `close_APP`) VALUES
(1, 1, 0, 1, 200, 0, 200, 15, 'https://play.google.com/store/apps/details?id=com.socialquizpop.app', '3.0', 2, '<div style=\"font-family: Arial, sans-serif; max-width: 600px; margin: 0 auto; padding: 15px; background: #f9f9f9; border-radius: 8px; border: 1px solid #e0e0e0\">\r\n  <h3 style=\"color: #2a52be; margin-top: 0\">Quiz 2025 Update</h3>\r\n  <p>We\'ve made improvements to enhance your experience:</p>\r\n  \r\n  <h4 style=\"color: #2a52be; margin-bottom: 5px;\">New Features</h4>\r\n  <ul style=\"margin-top: 0\">\r\n    <li></li>\r\n    <li></li>\r\n  </ul>\r\n\r\n  <h4 style=\"color: #2a52be; margin-bottom: 5px;\">Bug Fixes</h4>\r\n  <ul style=\"margin-top: 0\">\r\n    <li>Fixed login issues on some devices</li>\r\n    <li>Improved ad loading stability</li>\r\n  </ul>\r\n\r\n  <p>Thanks for using <strong>QuizPop</strong>! Keep playing and earning.</p>\r\n</div>', 0, 1, 'https://www.youtube.com/', 'https://t.me/e', 'https://t.me/e', 1, 1, 5, 'https://quizpop.playexplore.in/beta_api/user/', 30, 'off', 5, 1, 2, 500, 0, 'https://docs.google.com/forms/d/e/1FAIpQLSdXyYnQIrcjL7c7t3UOz83WB-7yl7QRBoFfjQTf3_Bt_8Nmpg/viewform', 'com.phonepe.app,net.one97.paytm,konasl.nagad,com.dbbl.mbs.apps.main,com.bKash.customerapp,com.pubg.imobile,com.dts.freefiremax,com.dts.freefireth', 'https://quizpopapp.blogspot.com/p/quizpop-privacy-policy.html?m=1', 'https://www.gamezop.com/', 0);

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

--
-- Table structure for table `colour_guess_image_list`
--

CREATE TABLE `colour_guess_image_list` (
  `id` int(11) NOT NULL,
  `image_url` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `colour_guess_image_list`
--

INSERT INTO `colour_guess_image_list` (`id`, `image_url`) VALUES
(1, 'https://snaplimit.com/Assets/happy.png'),
(2, 'https://snaplimit.com/Assets/student.png'),
(3, 'https://snaplimit.com/Assets/gamer.png'),
(4, 'https://snaplimit.com/Assets/boy.png'),
(5, 'https://snaplimit.com/Assets/dog.png'),
(6, 'https://snaplimit.com/Assets/car.png'),
(7, 'https://snaplimit.com/Assets/tiger.png'),
(8, 'https://snaplimit.com/Assets/train.png'),
(9, 'https://snaplimit.com/Assets/bicycle.png'),
(10, 'https://snaplimit.com/Assets/monkey.png');

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

--
-- Table structure for table `daily_checkins`
--

CREATE TABLE `daily_checkins` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `coins_earned` int(11) NOT NULL,
  `claimed_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `claimed_date` date GENERATED ALWAYS AS (cast(`claimed_at` as date)) STORED
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `daily_checkins`
--

INSERT INTO `daily_checkins` (`id`, `user_id`, `coins_earned`, `claimed_at`) VALUES
(149, 2, 15, '2025-10-05 03:58:00'),
(150, 3, 15, '2025-10-05 04:56:42'),
(151, 4, 15, '2025-10-05 09:50:35'),
(152, 4, 15, '2025-10-09 16:14:51'),
(153, 9, 15, '2025-10-14 08:24:16'),
(154, 10, 15, '2025-11-05 09:57:45'),
(155, 11, 15, '2025-11-05 17:17:11'),
(156, 12, 15, '2025-11-10 11:29:12'),
(157, 11, 15, '2025-11-11 03:16:22'),
(158, 12, 15, '2025-11-11 11:11:59'),
(159, 13, 15, '2025-11-11 16:15:45'),
(160, 13, 15, '2025-11-12 04:55:26'),
(161, 12, 15, '2025-11-13 05:39:00'),
(162, 11, 15, '2025-11-13 07:30:44'),
(163, 13, 15, '2025-11-14 04:45:29'),
(164, 11, 15, '2025-11-14 16:37:05'),
(165, 13, 15, '2025-11-15 03:57:06'),
(166, 14, 15, '2025-11-16 06:46:45'),
(167, 15, 15, '2025-11-16 16:33:02'),
(168, 16, 15, '2025-11-17 15:45:13'),
(169, 12, 15, '2025-11-17 18:14:49'),
(170, 12, 15, '2025-11-18 07:28:18'),
(171, 16, 15, '2025-11-18 16:52:43');

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

--
-- Table structure for table `promo_codes`
--

CREATE TABLE `promo_codes` (
  `id` int(11) NOT NULL,
  `code` varchar(20) NOT NULL,
  `coins` int(11) NOT NULL,
  `usage_limit` int(11) NOT NULL,
  `expiry_date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `promo_codes`
--

INSERT INTO `promo_codes` (`id`, `code`, `coins`, `usage_limit`, `expiry_date`, `created_at`) VALUES
(12, 'WELCOME', 50, 10000, '2025-12-09 18:30:00', '2025-07-03 08:30:00');

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

--
-- Table structure for table `promo_code_usage`
--

CREATE TABLE `promo_code_usage` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `promo_code_id` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `promo_code_usage`
--

INSERT INTO `promo_code_usage` (`id`, `user_id`, `promo_code_id`, `created_at`) VALUES
(13, 144, 12, '2025-07-11 12:48:52'),
(14, 3, 12, '2025-10-05 09:53:37'),
(16, 11, 12, '2025-11-11 11:31:26'),
(18, 12, 12, '2025-11-17 18:11:41');

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

--
-- Table structure for table `rate_limit`
--

CREATE TABLE `rate_limit` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `timestamp` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `rate_limit`
--

INSERT INTO `rate_limit` (`id`, `user_id`, `timestamp`) VALUES
(2196, 12, 1763483177),
(2197, 12, 1763483190),
(2198, 16, 1763483661),
(2199, 16, 1763483664),
(2200, 16, 1763483671),
(2201, 16, 1763483677),
(2202, 16, 1763484697),
(2203, 16, 1763484699),
(2204, 16, 1763484763),
(2205, 16, 1763484783);

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

--
-- Table structure for table `redeem_options_categories`
--

CREATE TABLE `redeem_options_categories` (
  `id` int(11) NOT NULL,
  `category_name` varchar(100) NOT NULL,
  `category_image_url` varchar(255) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `redeem_options_categories`
--

INSERT INTO `redeem_options_categories` (`id`, `category_name`, `category_image_url`, `created_at`) VALUES
(1, 'Google Gift Card', 'https://quiz4.snaplimit.com/Assets/google%20play.png', '2025-06-01 04:30:00'),
(2, 'Flipkart Voucher', 'https://quiz4.snaplimit.com/Assets/flipkartt.png', '2025-06-01 04:30:00'),
(3, 'Amazon Pay Gift', 'https://quiz4.snaplimit.com/Assets/amazon%20pay.png', '2025-06-01 04:30:00'),
(4, 'Upi Transfer', 'https://quiz4.snaplimit.com/Assets/Upi%20.png', '2025-06-13 07:47:50');

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

--
-- Table structure for table `redeem_options_subcategories`
--

CREATE TABLE `redeem_options_subcategories` (
  `id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  `sub_category_name` varchar(100) NOT NULL,
  `sub_category_image_url` varchar(255) NOT NULL,
  `coins` int(11) NOT NULL,
  `cash` decimal(10,2) NOT NULL,
  `is_enabled` tinyint(4) DEFAULT 1,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `redeem_options_subcategories`
--

INSERT INTO `redeem_options_subcategories` (`id`, `category_id`, `sub_category_name`, `sub_category_image_url`, `coins`, `cash`, `is_enabled`, `created_at`) VALUES
(34, 2, 'flipkart voucher', 'https://snaplimit.com/Assets/flipkart.png', 700, 30.00, 1, '2025-06-01 04:30:00'),
(35, 2, 'flipkart voucher', 'https://snaplimit.com/Assets/flipkart.png', 5600, 50.00, 1, '2025-06-01 04:30:00'),
(36, 2, 'flipkart voucher', 'https://snaplimit.com/Assets/flipkart.png', 10200, 100.00, 1, '2025-06-01 04:30:00'),
(40, 1, 'google play gift', 'https://snaplimit.com/Assets/playstore.png', 800, 10.00, 1, '2025-06-01 04:30:00'),
(41, 3, 'amazon pay gift', 'https://snaplimit.com/Assets/amazon.png', 5600, 50.00, 1, '2025-06-01 04:30:00'),
(43, 3, 'amazon pay gift', 'https://snaplimit.com/Assets/amazon.png', 10200, 100.00, 1, '2025-06-01 04:30:00'),
(45, 1, 'google play gift', 'https://snaplimit.com/Assets/playstore.png', 2350, 20.00, 1, '2025-06-01 04:30:00'),
(46, 1, 'google play gift', 'https://snaplimit.com/Assets/playstore.png', 3400, 30.00, 1, '2025-06-01 04:30:00'),
(47, 1, 'google play gift', 'https://snaplimit.com/Assets/playstore.png', 5600, 50.00, 1, '2025-06-01 04:30:00');

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

--
-- Table structure for table `referral_rewards`
--

CREATE TABLE `referral_rewards` (
  `id` int(11) NOT NULL,
  `referrer_id` int(11) NOT NULL,
  `referred_id` int(11) NOT NULL,
  `referrer_coins` int(11) NOT NULL,
  `referred_coins` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `referral_rewards`
--

INSERT INTO `referral_rewards` (`id`, `referrer_id`, `referred_id`, `referrer_coins`, `referred_coins`, `created_at`) VALUES
(5, 135, 148, 200, 0, '2025-07-11 17:31:49');

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

--
-- Table structure for table `tasks`
--

CREATE TABLE `tasks` (
  `id` int(11) NOT NULL,
  `task_type` enum('emoji_maths','meaning_match','color_finder') NOT NULL DEFAULT 'emoji_maths',
  `reward_coins` varchar(255) NOT NULL,
  `is_enabled` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `tasks`
--

INSERT INTO `tasks` (`id`, `task_type`, `reward_coins`, `is_enabled`, `created_at`, `updated_at`) VALUES
(1, 'emoji_maths', '10-20', 1, '2025-07-19 13:29:13', '2025-09-23 18:53:13'),
(2, 'meaning_match', '10-15', 1, '2025-07-19 13:29:13', '2025-09-23 18:53:19'),
(3, 'color_finder', '5-10', 1, '2025-07-19 13:29:13', '2025-09-23 18:53:25');

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

--
-- Table structure for table `task_completions`
--

CREATE TABLE `task_completions` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `task_id` int(11) NOT NULL,
  `earned_coins` int(11) NOT NULL,
  `by_task` varchar(50) NOT NULL,
  `completed_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `task_completions`
--

INSERT INTO `task_completions` (`id`, `user_id`, `task_id`, `earned_coins`, `by_task`, `completed_at`) VALUES
(15, 3, 3, 5, 'color_finder', '2025-09-24 03:31:40'),
(16, 3, 1, 14, 'emoji_maths', '2025-09-24 06:49:01'),
(17, 3, 2, 15, 'meaning_match', '2025-09-24 06:50:18'),
(18, 3, 3, 7, 'color_finder', '2025-09-24 07:29:16'),
(19, 4, 1, 10, 'emoji_maths', '2025-09-24 07:38:10'),
(20, 3, 1, 14, 'emoji_maths', '2025-09-24 10:28:04'),
(21, 3, 2, 15, 'meaning_match', '2025-09-24 10:28:53'),
(23, 2, 2, 10, 'meaning_match', '2025-09-24 10:38:42'),
(24, 2, 2, 10, 'meaning_match', '2025-09-24 11:01:54'),
(25, 2, 2, 10, 'meaning_match', '2025-09-24 11:19:47'),
(28, 2, 1, 12, 'emoji_maths', '2025-09-24 12:12:50'),
(29, 2, 1, 13, 'emoji_maths', '2025-09-24 12:14:33'),
(30, 2, 1, 13, 'emoji_maths', '2025-09-24 12:18:29'),
(31, 3, 1, 18, 'emoji_maths', '2025-09-24 12:59:38'),
(32, 3, 1, 15, 'emoji_maths', '2025-09-24 12:59:49'),
(33, 3, 2, 13, 'meaning_match', '2025-09-24 13:00:42'),
(34, 3, 3, 7, 'color_finder', '2025-09-24 13:03:50'),
(35, 3, 3, 6, 'color_finder', '2025-09-24 13:04:15'),
(36, 5, 2, 15, 'meaning_match', '2025-09-24 17:22:06'),
(37, 3, 1, 16, 'emoji_maths', '2025-09-25 07:26:45'),
(40, 3, 3, 7, 'color_finder', '2025-09-25 07:28:29'),
(41, 3, 3, 7, 'color_finder', '2025-09-25 07:28:50'),
(42, 3, 3, 10, 'color_finder', '2025-09-25 07:29:12'),
(43, 3, 1, 19, 'emoji_maths', '2025-09-25 07:32:11'),
(44, 3, 1, 13, 'emoji_maths', '2025-09-25 07:32:30'),
(45, 3, 2, 11, 'meaning_match', '2025-09-27 09:13:44'),
(46, 3, 2, 15, 'meaning_match', '2025-09-27 11:43:07'),
(47, 4, 2, 13, 'meaning_match', '2025-09-28 13:00:29'),
(48, 4, 1, 18, 'emoji_maths', '2025-09-28 13:01:36'),
(49, 4, 3, 6, 'color_finder', '2025-09-28 13:02:43'),
(51, 8, 2, 11, 'meaning_match', '2025-09-28 18:16:04'),
(52, 3, 3, 10, 'color_finder', '2025-09-29 18:04:06'),
(53, 4, 2, 14, 'meaning_match', '2025-09-30 01:31:24'),
(54, 4, 1, 19, 'emoji_maths', '2025-09-30 01:31:45'),
(55, 4, 3, 5, 'color_finder', '2025-09-30 01:32:13'),
(56, 3, 2, 15, 'meaning_match', '2025-09-30 03:37:41'),
(57, 3, 2, 12, 'meaning_match', '2025-09-30 03:37:51'),
(58, 3, 2, 14, 'meaning_match', '2025-09-30 03:38:02'),
(59, 3, 1, 19, 'emoji_maths', '2025-09-30 03:38:52'),
(60, 3, 1, 15, 'emoji_maths', '2025-09-30 03:39:01'),
(61, 3, 1, 15, 'emoji_maths', '2025-09-30 03:39:11'),
(62, 2, 2, 0, 'meaning_match', '2025-09-30 17:53:49'),
(63, 4, 3, 10, 'color_finder', '2025-10-05 09:51:34'),
(65, 11, 3, 9, 'color_finder', '2025-11-11 05:42:03'),
(66, 11, 3, 10, 'color_finder', '2025-11-11 05:53:41'),
(69, 12, 2, 15, 'meaning_match', '2025-11-13 06:25:07'),
(70, 12, 2, 15, 'meaning_match', '2025-11-13 06:35:10'),
(71, 11, 3, 8, 'color_finder', '2025-11-13 06:53:53'),
(72, 11, 3, 9, 'color_finder', '2025-11-13 06:54:34'),
(74, 11, 3, 8, 'color_finder', '2025-11-14 18:06:07'),
(75, 11, 3, 6, 'color_finder', '2025-11-14 18:15:54');

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

--
-- Table structure for table `task_limits`
--

CREATE TABLE `task_limits` (
  `id` int(11) NOT NULL,
  `task_type` enum('emoji_maths','meaning_match','color_finder') NOT NULL,
  `daily_limit` varchar(255) NOT NULL DEFAULT '10',
  `ad_index` int(11) NOT NULL,
  `important_ad_type` varchar(50) DEFAULT NULL COMMENT 'inter/native',
  `is_enabled` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `task_limits`
--

INSERT INTO `task_limits` (`id`, `task_type`, `daily_limit`, `ad_index`, `important_ad_type`, `is_enabled`, `created_at`, `updated_at`) VALUES
(1, 'emoji_maths', '5-10', 2, 'inter', 1, '2025-06-17 10:45:34', '2025-09-24 11:30:55'),
(2, 'meaning_match', '5-8', 2, 'native', 1, '2025-06-17 10:45:34', '2025-09-24 11:31:01'),
(3, 'color_finder', '10-15', 3, 'native', 1, '2025-06-17 10:45:34', '2025-09-24 11:31:11');

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

--
-- Table structure for table `task_questions`
--

CREATE TABLE `task_questions` (
  `id` int(11) NOT NULL,
  `task_id` int(11) NOT NULL,
  `question` varchar(255) DEFAULT NULL,
  `option_1` varchar(255) DEFAULT NULL,
  `option_2` varchar(255) DEFAULT NULL,
  `option_3` varchar(255) DEFAULT NULL,
  `option_4` varchar(255) DEFAULT NULL,
  `correct_option` varchar(255) DEFAULT NULL,
  `correctness_answer` enum('Yes','No') DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `task_questions`
--

INSERT INTO `task_questions` (`id`, `task_id`, `question`, `option_1`, `option_2`, `option_3`, `option_4`, `correct_option`, `correctness_answer`, `created_at`, `updated_at`) VALUES
(761, 1, 'Answer is 4', '2+2', '3-1', '5+2', '3-5', '2+2', NULL, '2025-10-31 20:58:36', '2025-10-31 20:58:36'),
(762, 1, 'What is 5 + 3?', '7', '8', '6', '9', '8', NULL, '2025-10-31 20:58:36', '2025-10-31 20:58:36'),
(763, 1, 'What is 10 - 2?', '8', '7', '9', '6', '8', NULL, '2025-10-31 20:58:36', '2025-10-31 20:58:36'),
(764, 1, 'Answer is 10', '5+5', '12-1', '8+1', '7+2', '5+5', NULL, '2025-10-31 20:58:36', '2025-10-31 20:58:36'),
(765, 1, 'What is 2 + 3?', '4', '6', '5', '3', '5', NULL, '2025-10-31 20:58:36', '2025-10-31 20:58:36'),
(766, 1, 'What is 7 - 4?', '2', '3', '1', '5', '3', NULL, '2025-10-31 20:58:36', '2025-10-31 20:58:36'),
(767, 1, 'Answer is 6', '3+3', '4+1', '10-5', '8-1', '3+3', NULL, '2025-10-31 20:58:36', '2025-10-31 20:58:36'),
(768, 1, 'What is 9 + 1?', '10', '11', '8', '9', '10', NULL, '2025-10-31 20:58:36', '2025-10-31 20:58:36'),
(769, 1, 'What is 6 - 5?', '1', '10', '4', '5', '1', NULL, '2025-10-31 20:58:36', '2025-11-10 10:59:45'),
(770, 1, 'Answer is 9', '4+4', '10-2', '6+3', '7+1', '6+3', NULL, '2025-10-31 20:58:36', '2025-10-31 20:58:36'),
(771, 2, 'Find the letter \'A\'', 'b', 'B', 'a', 'D', 'a', NULL, '2025-10-31 20:58:36', '2025-10-31 20:58:36'),
(772, 2, 'Find the letter \'b\'', 'b', 'd', 'p', 'q', 'b', NULL, '2025-10-31 20:58:36', '2025-10-31 20:58:36'),
(773, 2, 'What comes after C?', 'D', 'E', 'B', 'A', 'D', NULL, '2025-10-31 20:58:36', '2025-10-31 20:58:36'),
(774, 2, 'Find the letter \'G\'', 'g', 'j', 'y', 'p', 'g', NULL, '2025-10-31 20:58:36', '2025-10-31 20:58:36'),
(775, 2, 'What is the lowercase of H?', 'h', 'H', 'j', 'J', 'h', NULL, '2025-10-31 20:58:36', '2025-10-31 20:58:36'),
(776, 2, 'Find the letter \'M\'', 'n', 'm', 'w', 'v', 'm', NULL, '2025-10-31 20:58:36', '2025-10-31 20:58:36'),
(777, 2, 'What comes before Z?', 'X', 'A', 'Y', 'W', 'Y', NULL, '2025-10-31 20:58:36', '2025-10-31 20:58:36'),
(778, 2, 'What is the uppercase of f?', 'F', 'f', 'T', 't', 'F', NULL, '2025-10-31 20:58:36', '2025-10-31 20:58:36'),
(779, 2, 'Find the letter \'R\'', 'P', 'R', 'K', 'S', 'R', NULL, '2025-10-31 20:58:36', '2025-10-31 20:58:36'),
(780, 2, 'Find the letter \'e\'', 'e', 'c', 'f', 'a', 'e', NULL, '2025-10-31 20:58:36', '2025-10-31 20:58:36'),
(781, 3, 'Which animal says \'Moo\'?', 'Cat', 'Dog', 'Cow', 'Sheep', 'Cow', NULL, '2025-10-31 20:58:36', '2025-10-31 20:58:36'),
(782, 3, 'Which animal says \'Woof\'?', 'Dog', 'Pig', 'Horse', 'Cat', 'Dog', NULL, '2025-10-31 20:58:36', '2025-10-31 20:58:36'),
(783, 3, 'Which animal says \'Meow\'?', 'Chicken', 'Cow', 'Cat', 'Duck', 'Cat', NULL, '2025-10-31 20:58:36', '2025-10-31 20:58:36'),
(784, 3, 'Which animal says \'Oink\'?', 'Sheep', 'Pig', 'Goat', 'Lion', 'Pig', NULL, '2025-10-31 20:58:36', '2025-10-31 20:58:36'),
(785, 3, 'Which animal says \'Baa\'?', 'Rooster', 'Frog', 'Sheep', 'Dog', 'Sheep', NULL, '2025-10-31 20:58:36', '2025-10-31 20:58:36'),
(786, 3, 'Which animal says \'Quack\'?', 'Duck', 'Horse', 'Cat', 'Cow', 'Duck', NULL, '2025-10-31 20:58:36', '2025-10-31 20:58:36'),
(787, 3, 'Which animal says \'Hiss\'?', 'Bird', 'Snake', 'Pig', 'Elephant', 'Snake', NULL, '2025-10-31 20:58:36', '2025-10-31 20:58:36'),
(788, 3, 'Which animal says \'Ribbit\'?', 'Fish', 'Mouse', 'Frog', 'Chicken', 'Frog', NULL, '2025-10-31 20:58:36', '2025-10-31 20:58:36'),
(789, 3, 'Which animal says \'Neigh\'?', 'Horse', 'Lion', 'Tiger', 'Bear', 'Horse', NULL, '2025-10-31 20:58:36', '2025-10-31 20:58:36'),
(790, 3, 'Which animal says \'Chirp\'?', 'Dog', 'Pig', 'Bird', 'Snake', 'Bird', NULL, '2025-10-31 20:58:36', '2025-10-31 20:58:36'),
(791, 4, 'Find a number bigger than 5', '4', '6', '3', '2', '6', NULL, '2025-10-31 20:58:36', '2025-11-11 03:21:35'),
(792, 4, 'Which number is bigger?', '7', '9', '2', '5', '9', NULL, '2025-10-31 20:58:36', '2025-10-31 20:58:36'),
(793, 4, 'Which number is smaller?', '3', '5', '1', '8', '1', NULL, '2025-10-31 20:58:36', '2025-10-31 20:58:36'),
(794, 4, 'Find a number smaller than 10', '12', '15', '9', '11', '9', NULL, '2025-10-31 20:58:36', '2025-10-31 20:58:36'),
(795, 4, 'Which number is biggest?', '15', '25', '10', '20', '25', NULL, '2025-10-31 20:58:36', '2025-10-31 20:58:36'),
(796, 4, 'Which number is smallest?', '100', '50', '75', '60', '50', NULL, '2025-10-31 20:58:36', '2025-10-31 20:58:36'),
(797, 4, 'Which number is bigger than 50?', '45', '30', '55', '20', '55', NULL, '2025-10-31 20:58:36', '2025-10-31 20:58:36'),
(798, 4, 'Which number is smaller than 20?', '21', '30', '19', '25', '19', NULL, '2025-10-31 20:58:36', '2025-10-31 20:58:36'),
(799, 4, 'Which number is biggest?', '8', '2', '10', '5', '10', NULL, '2025-10-31 20:58:36', '2025-10-31 20:58:36'),
(800, 4, 'Which number is smallest?', '7', '4', '6', '9', '4', NULL, '2025-10-31 20:58:36', '2025-10-31 20:58:36');

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

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` int(11) NOT NULL,
  `email` varchar(255) NOT NULL,
  `device_id` varchar(255) NOT NULL,
  `coins` int(11) DEFAULT 0,
  `refercode` varchar(8) NOT NULL,
  `referred_by` int(11) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `is_blocked` tinyint(1) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `email`, `device_id`, `coins`, `refercode`, `referred_by`, `created_at`, `is_blocked`) VALUES
(10, 'wostudyofficial@gmail.com', 'f8ec2b77ad9e2546', 555, 'wostkxGt', NULL, '2025-11-01 06:47:13', 0),
(11, 'sachinjangirrwr@gmail.com', 'c988b2276a45d589', 12344, 'sachCg79', NULL, '2025-11-05 17:01:17', 0),
(12, 'developer.yavansh@gmail.com', '9466797c4541cb25', 130, 'deven5Li', NULL, '2025-11-07 05:20:10', 0),
(13, 'droidskillspro@gmail.com', '7f3f6e468a9ad8ce', 121, 'droi1heP', NULL, '2025-11-11 16:15:39', 0),
(14, 'monikatestingstdev@gmail.com', 'cdaaafda07a6b14c', 15, 'moniXVnu', NULL, '2025-11-16 06:45:58', 0),
(15, 'kushagra.electron.me@gmail.com', 'daa957b9f80434c6', 15, 'kush4a8R', NULL, '2025-11-16 16:32:53', 0),
(16, 'princekumarkeshri.22@gmail.com', '23c7e6ebca0bb604', 30, 'prin2ToW', NULL, '2025-11-17 06:15:29', 0);

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

--
-- Table structure for table `user_task_usage`
--

CREATE TABLE `user_task_usage` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `task_type` enum('emoji_maths','meaning_match','color_finder') NOT NULL,
  `usage_date` date NOT NULL,
  `ad_index` int(11) DEFAULT NULL,
  `used_count` int(11) NOT NULL DEFAULT 0,
  `user_daily_limit` int(11) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `user_task_usage`
--

INSERT INTO `user_task_usage` (`id`, `user_id`, `task_type`, `usage_date`, `ad_index`, `used_count`, `user_daily_limit`, `created_at`, `updated_at`) VALUES
(72, 2, 'meaning_match', '2025-10-05', 2, 6, 6, '2025-10-05 03:59:18', '2025-10-05 04:01:29'),
(73, 2, 'color_finder', '2025-10-05', 3, 14, 14, '2025-10-05 04:00:07', '2025-10-05 04:01:34'),
(75, 2, 'emoji_maths', '2025-10-05', 2, 7, 7, '2025-10-05 04:19:21', '2025-10-05 04:19:31'),
(76, 4, 'color_finder', '2025-10-05', 3, 1, 14, '2025-10-05 09:51:24', '2025-10-05 09:51:34'),
(83, 11, 'meaning_match', '2025-11-05', 2, 0, 8, '2025-11-05 17:18:11', '2025-11-05 17:18:11'),
(86, 11, 'emoji_maths', '2025-11-11', 2, 0, 8, '2025-11-11 03:23:48', '2025-11-11 03:23:48'),
(87, 11, 'meaning_match', '2025-11-11', 2, 0, 5, '2025-11-11 05:40:02', '2025-11-11 05:40:02'),
(88, 11, 'color_finder', '2025-11-11', 3, 2, 12, '2025-11-11 05:41:29', '2025-11-11 05:53:41'),
(89, 12, 'meaning_match', '2025-11-11', 2, 0, 6, '2025-11-11 10:55:07', '2025-11-11 10:55:07'),
(91, 13, 'color_finder', '2025-11-11', 3, 0, 10, '2025-11-11 16:18:02', '2025-11-11 16:18:02'),
(93, 13, 'meaning_match', '2025-11-12', 2, 0, 5, '2025-11-12 05:09:17', '2025-11-12 05:09:17'),
(94, 12, 'color_finder', '2025-11-13', 3, 0, 13, '2025-11-13 04:52:25', '2025-11-13 04:52:25'),
(95, 12, 'emoji_maths', '2025-11-13', 2, 0, 10, '2025-11-13 05:11:31', '2025-11-13 05:11:31'),
(96, 12, 'meaning_match', '2025-11-13', 2, 2, 5, '2025-11-13 06:24:45', '2025-11-13 06:35:10'),
(97, 11, 'color_finder', '2025-11-13', 3, 15, 15, '2025-11-13 06:53:34', '2025-11-13 07:29:36'),
(98, 11, 'emoji_maths', '2025-11-13', 2, 10, 10, '2025-11-13 07:29:36', '2025-11-13 07:29:36'),
(99, 11, 'meaning_match', '2025-11-13', 2, 8, 8, '2025-11-13 07:29:36', '2025-11-13 07:29:36'),
(103, 13, 'meaning_match', '2025-11-14', 2, 0, 8, '2025-11-14 04:52:32', '2025-11-14 04:52:32'),
(104, 13, 'color_finder', '2025-11-14', 3, 0, 15, '2025-11-14 04:53:03', '2025-11-14 04:53:03'),
(105, 11, 'meaning_match', '2025-11-14', 2, 0, 6, '2025-11-14 16:37:08', '2025-11-14 16:37:08'),
(106, 11, 'color_finder', '2025-11-14', 3, 2, 11, '2025-11-14 18:01:57', '2025-11-14 18:15:54'),
(108, 13, 'color_finder', '2025-11-15', 3, 0, 13, '2025-11-15 03:57:50', '2025-11-15 03:57:50'),
(109, 13, 'emoji_maths', '2025-11-15', 2, 0, 6, '2025-11-15 03:57:52', '2025-11-15 03:57:52'),
(110, 13, 'meaning_match', '2025-11-15', 2, 0, 8, '2025-11-15 03:57:55', '2025-11-15 03:57:55'),
(111, 14, 'color_finder', '2025-11-16', 3, 0, 11, '2025-11-16 06:47:02', '2025-11-16 06:47:02'),
(113, 13, 'emoji_maths', '2025-11-16', 2, 10, 10, '2025-11-16 08:25:57', '2025-11-16 08:25:57'),
(114, 13, 'meaning_match', '2025-11-16', 2, 8, 8, '2025-11-16 08:25:57', '2025-11-16 08:25:57'),
(115, 13, 'color_finder', '2025-11-16', 3, 15, 15, '2025-11-16 08:25:57', '2025-11-16 08:25:57'),
(117, 16, 'color_finder', '2025-11-17', 3, 0, 15, '2025-11-17 06:17:59', '2025-11-17 06:17:59'),
(118, 16, 'color_finder', '2025-11-18', 3, 0, 14, '2025-11-18 15:37:58', '2025-11-18 15:37:58');

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

--
-- Table structure for table `website_visit_tasks`
--

CREATE TABLE `website_visit_tasks` (
  `id` int(11) NOT NULL,
  `web_url` varchar(255) NOT NULL,
  `timer` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `website_visit_tasks`
--

INSERT INTO `website_visit_tasks` (`id`, `web_url`, `timer`, `created_at`) VALUES
(1, 'https://www.google.com', 10, '2025-06-14 06:36:13'),
(2, 'https://www.flaticon.com/search?word=plus-circle', 10, '2025-06-14 17:39:22');

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

--
-- Indexes for table `ad_controls`
--
ALTER TABLE `ad_controls`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `screen_name` (`screen_name`);

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

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

--
-- Indexes for table `daily_checkins`
--
ALTER TABLE `daily_checkins`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `unique_user_date` (`user_id`,`claimed_date`),
  ADD KEY `idx_user_date` (`user_id`,`claimed_at`),
  ADD KEY `idx_claimed_at` (`claimed_at`);

--
-- Indexes for table `promo_codes`
--
ALTER TABLE `promo_codes`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `code` (`code`),
  ADD KEY `idx_promo_code` (`code`);

--
-- Indexes for table `promo_code_usage`
--
ALTER TABLE `promo_code_usage`
  ADD PRIMARY KEY (`id`),
  ADD KEY `promo_code_id` (`promo_code_id`),
  ADD KEY `idx_promo_usage` (`user_id`,`promo_code_id`);

--
-- Indexes for table `rate_limit`
--
ALTER TABLE `rate_limit`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_rate_limit_user` (`user_id`,`timestamp`);

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

--
-- Indexes for table `redeem_options_subcategories`
--
ALTER TABLE `redeem_options_subcategories`
  ADD PRIMARY KEY (`id`),
  ADD KEY `category_id` (`category_id`);

--
-- Indexes for table `referral_rewards`
--
ALTER TABLE `referral_rewards`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `referrer_id` (`referrer_id`,`referred_id`),
  ADD KEY `referred_id` (`referred_id`);

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

--
-- Indexes for table `task_completions`
--
ALTER TABLE `task_completions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id` (`user_id`),
  ADD KEY `task_id` (`task_id`),
  ADD KEY `completed_at` (`completed_at`);

--
-- Indexes for table `task_limits`
--
ALTER TABLE `task_limits`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `task_type` (`task_type`);

--
-- Indexes for table `task_questions`
--
ALTER TABLE `task_questions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `task_id` (`task_id`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `email` (`email`),
  ADD UNIQUE KEY `device_id` (`device_id`),
  ADD UNIQUE KEY `refercode` (`refercode`),
  ADD KEY `referred_by` (`referred_by`),
  ADD KEY `idx_refercode` (`refercode`);

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

