-- 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', '/21753324030,23301953168/com.socialquizpop.app_Banner', '/21775744923/example/rewarded', '/21775744923/example/app-open', '2025-06-22 18:59:24', '2025-07-10 15:09:02');

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

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

CREATE TABLE `ad_controls` (
  `id` int(11) NOT NULL,
  `screen_name` enum('quiz','correct_spelling','image_puzzle','find_faster','math_check','app_open') 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
(1, 'quiz', 1, 0, 1, 1, 0, '2025-06-23 11:09:02'),
(2, 'correct_spelling', 1, 0, 1, 1, 0, '2025-06-23 11:09:02'),
(3, 'image_puzzle', 1, 0, 1, 1, 0, '2025-06-23 11:09:02'),
(4, 'find_faster', 1, 0, 1, 1, 0, '2025-06-23 11:09:02'),
(5, 'math_check', 1, 0, 1, 1, 0, '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
) 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`) 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\">\n  <h3 style=\"color: #2a52be; margin-top: 0\">Quiz 2025 Update</h3>\n  <p>We\'ve made improvements to enhance your experience:</p>\n  \n  <h4 style=\"color: #2a52be; margin-bottom: 5px;\">New Features</h4>\n  <ul style=\"margin-top: 0\">\n    <li></li>\n    <li></li>\n  </ul>\n\n  <h4 style=\"color: #2a52be; margin-bottom: 5px;\">Bug Fixes</h4>\n  <ul style=\"margin-top: 0\">\n    <li>Fixed login issues on some devices</li>\n    <li>Improved ad loading stability</li>\n  </ul>\n\n  <p>Thanks for using <strong>QuizPop</strong>! Keep playing and earning.</p>\n</div>', 0, 1, 'https://www.youtube.com/', 'https://t.me/earnbitofficial', 'https://t.me/earnbitofficial', 1, 2, 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');

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

--
-- 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
(107, 137, 18, '2025-07-11 06:21:22'),
(108, 139, 19, '2025-07-11 09:10:08'),
(109, 140, 19, '2025-07-11 09:37:03'),
(110, 141, 18, '2025-07-11 09:37:16'),
(111, 142, 18, '2025-07-11 10:39:03'),
(112, 143, 16, '2025-07-11 11:14:40'),
(113, 144, 17, '2025-07-11 12:22:09'),
(114, 145, 18, '2025-07-11 12:54:48'),
(115, 153, 19, '2025-07-12 02:27:02'),
(116, 142, 15, '2025-07-12 02:36:30');

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

--
-- Table structure for table `image_puzzle_images`
--

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

--
-- Dumping data for table `image_puzzle_images`
--

INSERT INTO `image_puzzle_images` (`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 `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-08-31 18:29:59', '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');

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

--
-- 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
(7876, 0, 1752287201),
(7899, 0, 1752288064),
(7924, 0, 1752289080),
(7936, 0, 1752290272),
(7925, 135, 1752289080),
(7927, 135, 1752289090),
(7895, 139, 1752288040),
(7896, 139, 1752288042),
(7897, 139, 1752288044),
(7898, 139, 1752288045),
(7900, 139, 1752288064),
(7901, 139, 1752288071),
(7902, 139, 1752288073),
(7903, 139, 1752288077),
(7904, 139, 1752288082),
(7905, 139, 1752288088),
(7906, 139, 1752288091),
(7907, 139, 1752288096),
(7908, 139, 1752288099),
(7909, 139, 1752288101),
(7910, 139, 1752288190),
(7911, 139, 1752288192),
(7890, 142, 1752287776),
(7891, 142, 1752287783),
(7892, 142, 1752287790),
(7893, 142, 1752287794),
(7894, 142, 1752287899),
(7912, 142, 1752288984),
(7913, 142, 1752289006),
(7914, 142, 1752289013),
(7915, 142, 1752289023),
(7916, 142, 1752289026),
(7917, 142, 1752289034),
(7918, 142, 1752289042),
(7919, 142, 1752289059),
(7920, 142, 1752289065),
(7921, 142, 1752289071),
(7922, 142, 1752289073),
(7923, 142, 1752289077),
(7926, 142, 1752289083),
(7928, 142, 1752289095),
(7929, 142, 1752289097),
(7930, 142, 1752289109),
(7931, 142, 1752289113),
(7932, 142, 1752289119),
(7933, 142, 1752289121),
(7934, 142, 1752289133),
(7935, 152, 1752289822),
(7877, 153, 1752287201),
(7878, 153, 1752287216),
(7879, 153, 1752287222),
(7880, 153, 1752287227),
(7881, 153, 1752287230),
(7882, 153, 1752287234),
(7883, 153, 1752287482),
(7884, 153, 1752287485),
(7885, 153, 1752287500),
(7886, 153, 1752287522),
(7887, 153, 1752287524),
(7888, 153, 1752287533),
(7889, 153, 1752287544),
(7940, 153, 1752290301),
(7942, 153, 1752290309),
(7944, 153, 1752290311),
(7946, 153, 1752290313),
(7947, 153, 1752290317),
(7948, 153, 1752290318),
(7951, 153, 1752290324),
(7952, 153, 1752290329),
(7953, 153, 1752290342),
(7954, 153, 1752290347),
(7955, 153, 1752290349),
(7956, 153, 1752290359),
(7957, 153, 1752290370),
(7958, 153, 1752290379),
(7959, 153, 1752290382),
(7960, 153, 1752290385),
(7961, 153, 1752290391),
(7962, 153, 1752290407),
(7963, 153, 1752290411),
(7964, 153, 1752290413),
(7965, 153, 1752290418),
(7966, 153, 1752290427),
(7967, 153, 1752290430),
(7968, 153, 1752290432),
(7937, 154, 1752290272),
(7938, 154, 1752290279),
(7939, 154, 1752290286),
(7941, 154, 1752290308),
(7943, 154, 1752290311),
(7945, 154, 1752290312),
(7949, 154, 1752290318),
(7950, 154, 1752290322);

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

--
-- 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://snaplimit.com/Assets/google_play_card.png', '2025-06-01 04:30:00'),
(2, 'Flipkart Voucher', 'https://snaplimit.com/Assets/flipkart_card.png', '2025-06-01 04:30:00'),
(3, 'Amazon Pay Gift', 'https://snaplimit.com/Assets/amazon_card.png', '2025-06-01 04:30:00'),
(4, 'Upi Transfer', 'https://snaplimit.com/Assets/upi_card.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('word_puzzle','alphabet_puzzle','count_images','big_vs_small') NOT NULL DEFAULT 'word_puzzle',
  `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, 'word_puzzle', '10', 1, NOW(), NOW()),
(2, 'alphabet_puzzle', '10', 1, NOW(), NOW()),
(3, 'count_images', '10', 1, NOW(), NOW()),
(4, 'big_vs_small', '10', 1, NOW(), NOW());

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

--
-- 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
(595, 135, 2, 10, 'correct_spelling', '2025-07-11 06:03:24'),
(596, 135, 2, 10, 'correct_spelling', '2025-07-11 06:04:26'),
(597, 135, 4, 10, 'find_faster', '2025-07-11 06:04:57'),
(598, 135, 4, 10, 'find_faster', '2025-07-11 06:05:24'),
(599, 135, 4, 10, 'find_faster', '2025-07-11 06:05:52'),
(600, 135, 4, 10, 'find_faster', '2025-07-11 06:07:18'),
(601, 135, 3, 10, 'image_puzzle', '2025-07-11 06:08:04'),
(602, 135, 3, 10, 'image_puzzle', '2025-07-11 06:08:25'),
(603, 135, 3, 10, 'image_puzzle', '2025-07-11 06:09:37'),
(604, 135, 5, 10, 'math_check', '2025-07-11 06:10:51'),
(605, 135, 5, 10, 'math_check', '2025-07-11 06:11:00'),
(606, 135, 5, 10, 'math_check', '2025-07-11 06:11:09'),
(607, 135, 5, 10, 'math_check', '2025-07-11 06:11:15'),
(608, 135, 5, 10, 'math_check', '2025-07-11 06:11:55'),
(611, 137, 2, 10, 'correct_spelling', '2025-07-11 06:22:11'),
(612, 137, 2, 10, 'correct_spelling', '2025-07-11 06:22:36'),
(613, 137, 2, 10, 'correct_spelling', '2025-07-11 06:22:58'),
(614, 137, 2, 10, 'correct_spelling', '2025-07-11 06:23:18'),
(615, 137, 2, 10, 'correct_spelling', '2025-07-11 06:23:40'),
(616, 137, 2, 10, 'correct_spelling', '2025-07-11 06:24:07'),
(617, 137, 4, 10, 'find_faster', '2025-07-11 06:25:37'),
(618, 137, 4, 10, 'find_faster', '2025-07-11 06:25:54'),
(619, 137, 4, 10, 'find_faster', '2025-07-11 06:26:07'),
(620, 137, 4, 10, 'find_faster', '2025-07-11 06:26:25'),
(621, 137, 4, 10, 'find_faster', '2025-07-11 06:26:39'),
(622, 137, 4, 10, 'find_faster', '2025-07-11 06:26:53'),
(623, 137, 3, 10, 'image_puzzle', '2025-07-11 06:27:28'),
(624, 137, 3, 10, 'image_puzzle', '2025-07-11 06:27:44'),
(625, 137, 3, 10, 'image_puzzle', '2025-07-11 06:28:00'),
(626, 137, 3, 10, 'image_puzzle', '2025-07-11 06:28:27'),
(627, 137, 3, 10, 'image_puzzle', '2025-07-11 06:28:40'),
(628, 137, 5, 10, 'math_check', '2025-07-11 06:29:10'),
(629, 137, 5, 10, 'math_check', '2025-07-11 06:29:27'),
(630, 137, 5, 10, 'math_check', '2025-07-11 06:29:59'),
(631, 137, 5, 10, 'math_check', '2025-07-11 06:30:20'),
(632, 137, 5, 10, 'math_check', '2025-07-11 06:30:34'),
(633, 137, 5, 10, 'math_check', '2025-07-11 06:30:52'),
(634, 137, 5, 10, 'math_check', '2025-07-11 06:31:21'),
(635, 137, 5, 10, 'math_check', '2025-07-11 06:31:34'),
(636, 139, 5, 10, 'math_check', '2025-07-11 09:10:40'),
(637, 139, 5, 10, 'math_check', '2025-07-11 09:10:50'),
(638, 139, 5, 10, 'math_check', '2025-07-11 09:10:59'),
(639, 139, 5, 10, 'math_check', '2025-07-11 09:11:09'),
(640, 139, 5, 10, 'math_check', '2025-07-11 09:11:18'),
(641, 139, 5, 10, 'math_check', '2025-07-11 09:11:28'),
(642, 139, 5, 10, 'math_check', '2025-07-11 09:11:46'),
(643, 139, 5, 10, 'math_check', '2025-07-11 09:11:56'),
(644, 139, 5, 10, 'math_check', '2025-07-11 09:12:07'),
(645, 139, 5, 10, 'math_check', '2025-07-11 09:12:16'),
(646, 139, 5, 10, 'math_check', '2025-07-11 09:12:29'),
(647, 139, 5, 10, 'math_check', '2025-07-11 09:12:43'),
(648, 139, 4, 10, 'find_faster', '2025-07-11 09:13:01'),
(649, 139, 4, 10, 'find_faster', '2025-07-11 09:13:12'),
(650, 139, 4, 10, 'find_faster', '2025-07-11 09:13:23'),
(651, 139, 4, 10, 'find_faster', '2025-07-11 09:13:33'),
(652, 139, 4, 10, 'find_faster', '2025-07-11 09:13:45'),
(653, 139, 4, 10, 'find_faster', '2025-07-11 09:14:05'),
(654, 139, 3, 10, 'image_puzzle', '2025-07-11 09:14:40'),
(655, 139, 3, 10, 'image_puzzle', '2025-07-11 09:14:49'),
(656, 139, 3, 10, 'image_puzzle', '2025-07-11 09:15:00'),
(657, 139, 3, 10, 'image_puzzle', '2025-07-11 09:15:08'),
(658, 139, 3, 10, 'image_puzzle', '2025-07-11 09:15:16'),
(659, 139, 3, 10, 'image_puzzle', '2025-07-11 09:15:25'),
(660, 139, 3, 10, 'image_puzzle', '2025-07-11 09:15:44'),
(661, 139, 3, 10, 'image_puzzle', '2025-07-11 09:15:56'),
(662, 139, 3, 10, 'image_puzzle', '2025-07-11 09:16:05'),
(663, 139, 3, 10, 'image_puzzle', '2025-07-11 09:16:16'),
(664, 139, 2, 10, 'correct_spelling', '2025-07-11 09:17:18'),
(665, 139, 2, 10, 'correct_spelling', '2025-07-11 09:17:32'),
(666, 139, 2, 10, 'correct_spelling', '2025-07-11 09:17:39'),
(667, 139, 2, 10, 'correct_spelling', '2025-07-11 09:17:54'),
(668, 139, 2, 10, 'correct_spelling', '2025-07-11 09:18:19'),
(669, 139, 2, 10, 'correct_spelling', '2025-07-11 09:18:37'),
(670, 139, 2, 10, 'correct_spelling', '2025-07-11 09:18:50'),
(671, 139, 2, 10, 'correct_spelling', '2025-07-11 09:19:05'),
(672, 139, 2, 10, 'correct_spelling', '2025-07-11 09:19:23'),
(673, 139, 2, 10, 'correct_spelling', '2025-07-11 09:19:35'),
(674, 140, 2, 10, 'correct_spelling', '2025-07-11 09:37:24'),
(675, 140, 2, 10, 'correct_spelling', '2025-07-11 09:37:41'),
(676, 140, 2, 10, 'correct_spelling', '2025-07-11 09:37:52'),
(677, 140, 2, 10, 'correct_spelling', '2025-07-11 09:38:03'),
(678, 140, 2, 10, 'correct_spelling', '2025-07-11 09:38:14'),
(679, 140, 2, 10, 'correct_spelling', '2025-07-11 09:38:31'),
(680, 140, 2, 10, 'correct_spelling', '2025-07-11 09:38:44'),
(681, 140, 2, 10, 'correct_spelling', '2025-07-11 09:38:52'),
(682, 140, 2, 10, 'correct_spelling', '2025-07-11 09:39:03'),
(683, 140, 4, 10, 'find_faster', '2025-07-11 09:39:23'),
(684, 140, 4, 10, 'find_faster', '2025-07-11 09:39:41'),
(685, 140, 4, 10, 'find_faster', '2025-07-11 09:39:51'),
(686, 140, 4, 10, 'find_faster', '2025-07-11 09:40:14'),
(687, 140, 4, 10, 'find_faster', '2025-07-11 09:40:22'),
(688, 140, 4, 10, 'find_faster', '2025-07-11 09:40:31'),
(689, 140, 3, 10, 'image_puzzle', '2025-07-11 09:41:26'),
(690, 140, 3, 10, 'image_puzzle', '2025-07-11 09:41:35'),
(691, 140, 3, 10, 'image_puzzle', '2025-07-11 09:41:43'),
(692, 140, 3, 10, 'image_puzzle', '2025-07-11 09:41:52'),
(693, 140, 3, 10, 'image_puzzle', '2025-07-11 09:42:01'),
(694, 140, 3, 10, 'image_puzzle', '2025-07-11 09:42:09'),
(695, 140, 3, 10, 'image_puzzle', '2025-07-11 09:42:28'),
(696, 140, 3, 10, 'image_puzzle', '2025-07-11 09:42:41'),
(697, 140, 3, 10, 'image_puzzle', '2025-07-11 09:42:50'),
(698, 140, 5, 10, 'math_check', '2025-07-11 09:43:03'),
(699, 140, 5, 10, 'math_check', '2025-07-11 09:43:10'),
(700, 140, 5, 10, 'math_check', '2025-07-11 09:43:17'),
(701, 140, 5, 10, 'math_check', '2025-07-11 09:43:24'),
(702, 140, 5, 10, 'math_check', '2025-07-11 09:43:32'),
(703, 140, 5, 10, 'math_check', '2025-07-11 09:43:39'),
(704, 140, 5, 10, 'math_check', '2025-07-11 09:43:48'),
(705, 140, 5, 10, 'math_check', '2025-07-11 09:43:59'),
(706, 140, 5, 10, 'math_check', '2025-07-11 09:44:10'),
(707, 140, 5, 10, 'math_check', '2025-07-11 09:44:19'),
(708, 140, 5, 10, 'math_check', '2025-07-11 09:44:27'),
(709, 140, 5, 10, 'math_check', '2025-07-11 09:44:40'),
(710, 142, 2, 10, 'correct_spelling', '2025-07-11 10:43:51'),
(711, 142, 2, 10, 'correct_spelling', '2025-07-11 10:44:20'),
(712, 143, 2, 10, 'correct_spelling', '2025-07-11 11:15:40'),
(713, 144, 2, 10, 'correct_spelling', '2025-07-11 12:22:56'),
(714, 144, 2, 10, 'correct_spelling', '2025-07-11 12:24:38'),
(715, 144, 2, 10, 'correct_spelling', '2025-07-11 12:24:45'),
(716, 144, 2, 10, 'correct_spelling', '2025-07-11 12:24:51'),
(717, 144, 2, 10, 'correct_spelling', '2025-07-11 12:25:00'),
(718, 144, 2, 10, 'correct_spelling', '2025-07-11 12:25:14'),
(719, 144, 2, 10, 'correct_spelling', '2025-07-11 12:25:20'),
(720, 144, 2, 10, 'correct_spelling', '2025-07-11 12:25:27'),
(721, 144, 2, 10, 'correct_spelling', '2025-07-11 12:25:37'),
(722, 144, 2, 10, 'correct_spelling', '2025-07-11 12:25:45'),
(723, 144, 4, 10, 'find_faster', '2025-07-11 12:26:13'),
(724, 144, 4, 10, 'find_faster', '2025-07-11 12:26:30'),
(725, 144, 4, 10, 'find_faster', '2025-07-11 12:26:37'),
(726, 144, 4, 10, 'find_faster', '2025-07-11 12:26:44'),
(727, 144, 4, 10, 'find_faster', '2025-07-11 12:26:55'),
(728, 144, 4, 10, 'find_faster', '2025-07-11 12:27:39'),
(729, 144, 3, 10, 'image_puzzle', '2025-07-11 12:29:17'),
(730, 144, 3, 10, 'image_puzzle', '2025-07-11 12:29:23'),
(731, 144, 3, 10, 'image_puzzle', '2025-07-11 12:29:32'),
(732, 144, 3, 10, 'image_puzzle', '2025-07-11 12:29:39'),
(733, 144, 3, 10, 'image_puzzle', '2025-07-11 12:29:47'),
(734, 144, 5, 10, 'math_check', '2025-07-11 12:30:06'),
(735, 144, 5, 10, 'math_check', '2025-07-11 12:30:12'),
(736, 144, 5, 10, 'math_check', '2025-07-11 12:30:19'),
(737, 144, 5, 10, 'math_check', '2025-07-11 12:30:25'),
(738, 144, 5, 10, 'math_check', '2025-07-11 12:30:31'),
(739, 144, 5, 10, 'math_check', '2025-07-11 12:30:37'),
(740, 144, 5, 10, 'math_check', '2025-07-11 12:30:45'),
(741, 144, 5, 10, 'math_check', '2025-07-11 12:30:51'),
(742, 144, 5, 10, 'math_check', '2025-07-11 12:31:00'),
(743, 142, 5, 10, 'math_check', '2025-07-11 12:52:10'),
(744, 142, 5, 10, 'math_check', '2025-07-11 12:52:20'),
(745, 142, 5, 10, 'math_check', '2025-07-11 12:52:32'),
(746, 142, 5, 10, 'math_check', '2025-07-11 12:52:43'),
(747, 142, 5, 10, 'math_check', '2025-07-11 12:52:52'),
(748, 142, 5, 10, 'math_check', '2025-07-11 12:53:04'),
(749, 142, 5, 10, 'math_check', '2025-07-11 12:53:19'),
(750, 142, 5, 10, 'math_check', '2025-07-11 12:53:27'),
(751, 142, 5, 10, 'math_check', '2025-07-11 12:53:41'),
(752, 142, 5, 10, 'math_check', '2025-07-11 12:53:52'),
(753, 145, 2, 10, 'correct_spelling', '2025-07-11 12:54:32'),
(754, 147, 2, 10, 'correct_spelling', '2025-07-11 15:22:37'),
(755, 147, 2, 10, 'correct_spelling', '2025-07-11 15:22:55'),
(756, 147, 2, 10, 'correct_spelling', '2025-07-11 15:23:18'),
(757, 147, 2, 10, 'correct_spelling', '2025-07-11 15:23:32'),
(758, 147, 2, 10, 'correct_spelling', '2025-07-11 15:23:44'),
(759, 147, 2, 10, 'correct_spelling', '2025-07-11 15:23:57'),
(760, 147, 2, 10, 'correct_spelling', '2025-07-11 15:24:07'),
(761, 147, 2, 10, 'correct_spelling', '2025-07-11 15:24:15'),
(762, 147, 2, 10, 'correct_spelling', '2025-07-11 15:24:26'),
(763, 147, 2, 10, 'correct_spelling', '2025-07-11 15:24:36'),
(764, 147, 4, 10, 'find_faster', '2025-07-11 15:26:23'),
(765, 147, 4, 10, 'find_faster', '2025-07-11 15:26:35'),
(766, 147, 4, 10, 'find_faster', '2025-07-11 15:26:47'),
(767, 147, 4, 10, 'find_faster', '2025-07-11 15:26:59'),
(768, 147, 4, 10, 'find_faster', '2025-07-11 15:27:09'),
(769, 147, 4, 10, 'find_faster', '2025-07-11 15:27:22'),
(770, 147, 3, 10, 'image_puzzle', '2025-07-11 15:28:03'),
(771, 147, 3, 10, 'image_puzzle', '2025-07-11 15:28:13'),
(772, 147, 3, 10, 'image_puzzle', '2025-07-11 15:28:27'),
(773, 147, 3, 10, 'image_puzzle', '2025-07-11 15:28:40'),
(774, 147, 3, 10, 'image_puzzle', '2025-07-11 15:28:50'),
(775, 147, 3, 10, 'image_puzzle', '2025-07-11 15:29:00'),
(776, 147, 3, 10, 'image_puzzle', '2025-07-11 15:29:10'),
(777, 147, 3, 10, 'image_puzzle', '2025-07-11 15:29:21'),
(778, 147, 3, 10, 'image_puzzle', '2025-07-11 15:29:35'),
(779, 147, 5, 10, 'math_check', '2025-07-11 15:30:20'),
(780, 147, 5, 10, 'math_check', '2025-07-11 15:30:37'),
(781, 147, 5, 10, 'math_check', '2025-07-11 15:30:48'),
(782, 147, 5, 10, 'math_check', '2025-07-11 15:30:59'),
(783, 147, 5, 10, 'math_check', '2025-07-11 15:31:14'),
(784, 147, 5, 10, 'math_check', '2025-07-11 15:31:24'),
(785, 147, 5, 10, 'math_check', '2025-07-11 15:31:49'),
(786, 147, 5, 10, 'math_check', '2025-07-11 15:32:02'),
(788, 142, 2, 10, 'correct_spelling', '2025-07-11 17:07:38'),
(789, 142, 2, 10, 'correct_spelling', '2025-07-11 17:07:49'),
(790, 142, 2, 10, 'correct_spelling', '2025-07-11 17:08:03'),
(791, 142, 4, 10, 'find_faster', '2025-07-11 17:08:28'),
(792, 142, 4, 10, 'find_faster', '2025-07-11 17:08:40'),
(793, 142, 4, 10, 'find_faster', '2025-07-11 17:08:50'),
(794, 142, 4, 10, 'find_faster', '2025-07-11 17:08:59'),
(795, 142, 4, 10, 'find_faster', '2025-07-11 17:09:06'),
(796, 142, 4, 10, 'find_faster', '2025-07-11 17:09:14'),
(797, 142, 3, 10, 'image_puzzle', '2025-07-11 17:09:36'),
(798, 142, 3, 10, 'image_puzzle', '2025-07-11 17:09:43'),
(799, 142, 3, 10, 'image_puzzle', '2025-07-11 17:09:51'),
(800, 142, 3, 10, 'image_puzzle', '2025-07-11 17:10:02'),
(801, 142, 3, 10, 'image_puzzle', '2025-07-11 17:10:13'),
(802, 142, 3, 10, 'image_puzzle', '2025-07-11 17:10:23'),
(803, 142, 5, 10, 'math_check', '2025-07-11 17:10:42'),
(804, 148, 2, 10, 'correct_spelling', '2025-07-11 17:14:01'),
(805, 145, 2, 10, 'correct_spelling', '2025-07-11 17:16:21'),
(806, 148, 4, 10, 'find_faster', '2025-07-11 17:17:30'),
(807, 148, 3, 10, 'image_puzzle', '2025-07-11 17:20:57'),
(808, 148, 5, 10, 'math_check', '2025-07-11 17:25:59'),
(809, 152, 2, 10, 'correct_spelling', '2025-07-11 18:53:11'),
(810, 152, 3, 10, 'image_puzzle', '2025-07-11 18:53:51'),
(811, 152, 5, 10, 'math_check', '2025-07-11 18:55:05'),
(812, 152, 4, 10, 'find_faster', '2025-07-11 18:55:21'),
(813, 140, 4, 10, 'find_faster', '2025-07-11 21:20:40'),
(814, 140, 2, 10, 'correct_spelling', '2025-07-11 21:20:54'),
(815, 140, 3, 10, 'image_puzzle', '2025-07-11 21:21:09'),
(816, 140, 5, 10, 'math_check', '2025-07-11 21:21:23'),
(817, 142, 2, 10, 'correct_spelling', '2025-07-12 02:57:03'),
(818, 142, 4, 10, 'find_faster', '2025-07-12 02:57:51'),
(819, 142, 3, 10, 'image_puzzle', '2025-07-12 02:58:17'),
(820, 142, 5, 10, 'math_check', '2025-07-12 02:58:41'),
(821, 154, 4, 10, 'find_faster', '2025-07-12 03:18:31'),
(822, 153, 2, 10, 'correct_spelling', '2025-07-12 03:19:07'),
(823, 153, 4, 10, 'find_faster', '2025-07-12 03:19:42'),
(824, 153, 3, 10, 'image_puzzle', '2025-07-12 03:20:11'),
(825, 153, 5, 10, 'math_check', '2025-07-12 03:20:30');

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

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

CREATE TABLE `task_limits` (
  `id` int(11) NOT NULL,
  `task_type` enum('word_puzzle','alphabet_puzzle','count_images','big_vs_small') 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, 'word_puzzle', '1', 2, 'inter', 1, '2025-06-17 10:45:34', '2025-07-11 17:12:42'),
(2, 'alphabet_puzzle', '1', 2, 'native', 1, '2025-06-17 10:45:34', '2025-07-11 17:12:06'),
(3, 'count_images', '1', 3, 'native', 1, '2025-06-17 10:45:34', '2025-07-11 17:12:08'),
(4, 'big_vs_small', '1', 4, 'native', 1, '2025-06-17 10:45:34', '2025-07-11 17:12:10');

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

--
-- 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=latin1 COLLATE=latin1_swedish_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
(10, 2, 'Choose the correct word.', 'Reccommend', 'Recommend', 'Recomend', 'Reccomend', 'Recommend', NULL, '2025-06-09 19:48:18', '2025-06-09 19:48:18'),
(11, 3, 'Identify the correctly oriented image:', 'https://snaplimit.com/Assets/boy.png', 'https://snaplimit.com/Assets/gamer.png', 'https://snaplimit.com/Assets/happy.png', 'https://snaplimit.com/Assets/student.png', 'https://snaplimit.com/Assets/happy.png', NULL, '2025-06-09 19:48:18', '2025-06-12 18:37:34'),
(12, 3, 'Which image is displayed correctly?', 'https://snaplimit.com/Assets/gamer.png', 'https://snaplimit.com/Assets/happy.png', 'https://snaplimit.com/Assets/student.png', 'https://snaplimit.com/Assets/boy.png', 'https://snaplimit.com/Assets/gamer.png', NULL, '2025-06-09 19:48:18', '2025-06-12 18:36:08'),
(14, 4, 'Select the faster mode of transport:', 'https://snaplimit.com/Assets/train.png', 'https://snaplimit.com/Assets/travelling.png', 'NULL', 'NULL', 'https://snaplimit.com/Assets/travelling.png', NULL, '2025-06-09 19:48:18', '2025-06-19 06:08:56'),
(15, 4, 'Which animal is typically faster over short distances?', 'https://snaplimit.com/Assets/dog.png', 'https://snaplimit.com/Assets/tiger.png', 'NULL', 'NULL', 'https://snaplimit.com/Assets/tiger.png', NULL, '2025-06-09 19:48:18', '2025-06-19 06:09:47'),
(16, 5, '7 + 5 = 12?', NULL, NULL, NULL, NULL, NULL, 'Yes', '2025-06-09 19:48:18', '2025-06-12 19:07:48'),
(17, 5, '15 - 8 = 6?', NULL, NULL, NULL, NULL, NULL, 'No', '2025-06-09 19:48:18', '2025-06-12 19:08:57'),
(19, 5, '20 / 4 = 6?', NULL, NULL, NULL, NULL, NULL, 'No', '2025-06-09 19:48:18', '2025-06-12 19:09:30'),
(20, 2, 'which spelling is correct ?', 'Red', 'Rad', 'Raed', 'Reed', 'Red', NULL, '2025-06-12 18:26:21', '2025-06-12 18:26:21'),
(21, 5, '2+2 = 5?', NULL, NULL, NULL, NULL, NULL, 'No', '2025-06-12 18:39:07', '2025-06-12 18:39:07'),
(22, 4, 'Which run faster ?', 'https://snaplimit.com/Assets/car.png', 'https://snaplimit.com/Assets/bicycle.png', 'NULL', 'NULL', 'https://snaplimit.com/Assets/car.png', NULL, '2025-06-12 18:55:41', '2025-06-19 05:41:37'),
(23, 4, 'Who is Faster', 'https://snaplimit.com/Assets/travelling.png', 'https://snaplimit.com/Assets/helicopter.png', 'NULL', 'NULL', 'https://snaplimit.com/Assets/travelling.png', NULL, '2025-06-12 18:59:17', '2025-06-19 05:41:24'),
(24, 4, 'who is faster', 'https://snaplimit.com/Assets/tiger.png', 'https://snaplimit.com/Assets/dog.png', 'NULL', 'NULL', 'https://snaplimit.com/Assets/tiger.png', NULL, '2025-06-12 19:01:11', '2025-06-19 05:41:16'),
(25, 5, '6+6 = 13?', NULL, NULL, NULL, NULL, NULL, 'No', '2025-06-12 19:10:19', '2025-06-12 19:10:19'),
(26, 2, 'which one is correct Name ?', 'Ram', 'Raam', 'Rem', 'Rom', 'Ram', NULL, '2025-06-25 15:31:31', '2025-06-25 15:31:31'),
(27, 2, 'Which one is Correct ?', 'Smartphone', 'Smartphonee', 'Smartphoone', 'Smaartphone', 'Smartphone', NULL, '2025-06-25 15:32:27', '2025-06-25 15:32:27'),
(28, 2, 'Which one is correct ?', 'Crocodile', 'Cracodile', 'Crowdile', 'Crowkodile', 'Crocodile', NULL, '2025-06-25 15:34:01', '2025-06-25 15:34:01'),
(29, 2, 'Which one is Correct ?', 'Bike', 'Biike', 'Byke', 'Biek', 'Bike', NULL, '2025-06-25 15:34:54', '2025-06-25 15:34:54'),
(30, 2, 'which one is correct ?', 'Brown', 'Browwn', 'Brownn', 'Brrown', 'Brown', NULL, '2025-06-25 15:35:49', '2025-06-25 15:35:49'),
(31, 2, 'which one is correct ?', 'Tiger', 'Tigerrr', 'Tieger', 'Tiiger', 'Tiger', NULL, '2025-06-25 15:36:57', '2025-06-25 15:36:57'),
(32, 2, 'Which one is correct ?', 'Bull', 'Buul', 'Buel', 'Buull', 'Bull', NULL, '2025-06-25 15:37:41', '2025-06-25 15:37:41'),
(33, 2, 'which one is correct ?', 'Cat', 'Cet', 'Catt', 'Caat', 'Cat', NULL, '2025-06-25 15:39:58', '2025-06-25 15:39:58'),
(34, 4, 'Which one is Faster ?', 'https://snaplimit.com/Assets/tiger.png', 'https://snaplimit.com/Assets/horse.png', NULL, NULL, 'https://snaplimit.com/Assets/tiger.png', NULL, '2025-06-25 15:58:21', '2025-06-25 15:58:21');

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

--
-- 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
(71, 'user@example.com', 'device123', 0, 'userzmDO', NULL, '2025-07-06 05:14:34', 0),
(135, 'crazytechboy0@gmail.com', '7f3f6e468a9ad8ce', 300, 'crazzm02', NULL, '2025-07-11 06:02:41', 0),
(137, 'neyamatali1122@gmail.com', 'afbd0bf9e8963ed7', 268, 'neyaivKn', NULL, '2025-07-11 06:20:43', 0),
(138, 'anandkumar81457@gmail.com', 'ebfb10a9adc81bf0', 0, 'ananFmQm', NULL, '2025-07-11 07:14:42', 0),
(139, 'gaggidullat931@gmail.com', '5494f59c2ab74731', 1206, 'gaggtYGy', NULL, '2025-07-11 09:09:18', 0),
(140, 'ajithraji476@gmail.com', '4818eaf1ee451cde', 419, 'ajitAYBf', NULL, '2025-07-11 09:36:43', 0),
(141, 'sudhersonmass203@gmail.com', '17366c93f5f8439c', 18, 'sudhSQ9Y', NULL, '2025-07-11 09:36:47', 0),
(142, 'sarthaksali123@gmail.com', '33a4c6e1455f394b', 353, 'sart9bNF', NULL, '2025-07-11 10:38:30', 0),
(143, 'dp6377893722@gmail.com', '1ca76e42b60c3919', 26, 'dp637oel', NULL, '2025-07-11 11:13:43', 0),
(144, 'manishavora2211@gmail.com', '51fbfcce8df58711', 367, 'manixFPq', NULL, '2025-07-11 12:21:43', 0),
(145, 'madhu132005@gmail.com', '09fd518860ccad3a', 38, 'madhfR5e', NULL, '2025-07-11 12:53:57', 0),
(146, 'jatinchalotra11@gmail.com', 'a477acdbaadd198e', 0, 'jatiqvNf', NULL, '2025-07-11 14:44:00', 0),
(147, 'roysumon855641@gmail.com', 'f866113c3677815f', 330, 'roysERtK', NULL, '2025-07-11 15:10:42', 0),
(148, 'querry.6gtech@gmail.com', 'e52e06ad5f8a25a0', 2840, 'querP9J3', 135, '2025-07-11 17:05:36', 0),
(149, 'bandanajha01@gmail.com', '29481f543630487a', 0, 'bandmnFM', NULL, '2025-07-11 17:10:02', 0),
(152, 'sachinjangirrwr@gmail.com', '7c993e7ba66f9f73', 40, 'sachWf4k', 135, '2025-07-11 18:19:34', 0),
(153, 'sashdk275@gmail.com', 'd3d8166fb59ce5ab', 59, 'sashxJlt', NULL, '2025-07-12 02:26:41', 0),
(154, 'samimgazi169@gmail.com', '993c008bf85549d9', 10, 'samiUo08', NULL, '2025-07-12 03:17:52', 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('word_puzzle','alphabet_puzzle','count_images','big_vs_small') NOT NULL,
  `usage_date` date NOT 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`, `used_count`, `user_daily_limit`, `created_at`, `updated_at`) VALUES
(183, 30, 'correct_spelling', '2025-06-30', 1, NULL, '2025-06-29 22:49:06', '2025-06-29 22:49:06'),
(184, 45, 'correct_spelling', '2025-07-03', 1, NULL, '2025-07-03 01:45:25', '2025-07-03 01:45:25'),
(185, 46, 'correct_spelling', '2025-07-03', 2, NULL, '2025-07-03 02:13:04', '2025-07-03 02:13:39'),
(186, 47, 'math_check', '2025-07-03', 1, NULL, '2025-07-03 02:24:21', '2025-07-03 02:24:21'),
(187, 47, 'correct_spelling', '2025-07-03', 2, NULL, '2025-07-03 03:12:56', '2025-07-03 03:13:57'),
(188, 48, 'image_puzzle', '2025-07-03', 2, NULL, '2025-07-03 05:13:01', '2025-07-03 05:13:39'),
(189, 48, 'correct_spelling', '2025-07-03', 2, NULL, '2025-07-03 05:14:45', '2025-07-03 05:15:22'),
(190, 48, 'find_faster', '2025-07-03', 2, NULL, '2025-07-03 05:16:33', '2025-07-03 05:17:08'),
(191, 48, 'math_check', '2025-07-03', 2, NULL, '2025-07-03 05:19:05', '2025-07-03 05:19:47'),
(192, 50, 'correct_spelling', '2025-07-03', 2, NULL, '2025-07-03 10:03:21', '2025-07-03 10:04:08'),
(193, 50, 'find_faster', '2025-07-03', 2, NULL, '2025-07-03 10:10:40', '2025-07-03 10:11:15'),
(194, 50, 'image_puzzle', '2025-07-03', 2, NULL, '2025-07-03 10:12:43', '2025-07-03 10:13:28'),
(195, 50, 'math_check', '2025-07-03', 2, NULL, '2025-07-03 10:21:34', '2025-07-03 10:22:08'),
(196, 51, 'correct_spelling', '2025-07-03', 1, NULL, '2025-07-03 10:52:27', '2025-07-03 10:52:27'),
(197, 40, 'correct_spelling', '2025-07-03', 2, NULL, '2025-07-03 11:35:25', '2025-07-03 11:36:08'),
(198, 52, 'image_puzzle', '2025-07-03', 1, NULL, '2025-07-03 11:36:56', '2025-07-03 11:36:56'),
(199, 40, 'find_faster', '2025-07-03', 2, NULL, '2025-07-03 11:36:59', '2025-07-03 11:37:40'),
(200, 40, 'image_puzzle', '2025-07-03', 1, NULL, '2025-07-03 11:38:36', '2025-07-03 11:38:36'),
(201, 40, 'math_check', '2025-07-03', 1, NULL, '2025-07-03 11:39:55', '2025-07-03 11:39:55'),
(202, 52, 'math_check', '2025-07-03', 2, NULL, '2025-07-03 12:06:11', '2025-07-03 12:06:59'),
(203, 46, 'math_check', '2025-07-03', 2, NULL, '2025-07-03 13:13:16', '2025-07-03 17:01:26'),
(204, 53, 'math_check', '2025-07-03', 2, NULL, '2025-07-03 14:15:40', '2025-07-03 14:16:24'),
(205, 53, 'image_puzzle', '2025-07-03', 2, NULL, '2025-07-03 14:17:43', '2025-07-03 14:18:21'),
(206, 53, 'find_faster', '2025-07-03', 2, NULL, '2025-07-03 14:19:27', '2025-07-03 14:19:28'),
(207, 53, 'correct_spelling', '2025-07-03', 2, NULL, '2025-07-03 14:20:52', '2025-07-03 14:21:51'),
(208, 46, 'image_puzzle', '2025-07-03', 10, NULL, '2025-07-03 16:34:24', '2025-07-03 16:58:37'),
(209, 54, 'correct_spelling', '2025-07-03', 5, NULL, '2025-07-03 16:40:21', '2025-07-03 16:44:14'),
(210, 54, 'find_faster', '2025-07-03', 4, NULL, '2025-07-03 16:45:30', '2025-07-03 18:29:29'),
(211, 46, 'find_faster', '2025-07-03', 2, NULL, '2025-07-03 16:59:10', '2025-07-03 16:59:50'),
(212, 55, 'correct_spelling', '2025-07-03', 2, NULL, '2025-07-03 18:03:40', '2025-07-03 18:04:14'),
(213, 55, 'find_faster', '2025-07-03', 1, NULL, '2025-07-03 18:04:59', '2025-07-03 18:04:59'),
(214, 54, 'image_puzzle', '2025-07-03', 10, NULL, '2025-07-03 18:17:51', '2025-07-03 18:24:59'),
(215, 54, 'find_faster', '2025-07-04', 5, NULL, '2025-07-03 18:30:08', '2025-07-03 18:33:36'),
(216, 54, 'math_check', '2025-07-04', 10, NULL, '2025-07-03 18:34:31', '2025-07-03 18:45:02'),
(217, 54, 'image_puzzle', '2025-07-04', 10, NULL, '2025-07-03 18:46:18', '2025-07-03 18:55:47'),
(218, 45, 'correct_spelling', '2025-07-04', 3, NULL, '2025-07-04 01:35:44', '2025-07-04 01:53:19'),
(219, 35, 'correct_spelling', '2025-07-04', 2, NULL, '2025-07-04 01:43:09', '2025-07-04 01:43:47'),
(220, 45, 'find_faster', '2025-07-04', 2, NULL, '2025-07-04 01:54:01', '2025-07-04 01:54:35'),
(221, 75, 'correct_spelling', '2025-07-06', 1, 10, '2025-07-06 06:12:55', '2025-07-06 06:13:43'),
(222, 72, 'correct_spelling', '2025-07-06', 2, 7, '2025-07-06 07:17:16', '2025-07-06 07:29:33'),
(223, 72, 'find_faster', '2025-07-06', 0, 20, '2025-07-06 07:17:39', '2025-07-06 07:17:39'),
(224, 72, 'image_puzzle', '2025-07-06', 0, 11, '2025-07-06 07:17:56', '2025-07-06 07:17:56'),
(225, 72, 'math_check', '2025-07-06', 0, 21, '2025-07-06 07:18:04', '2025-07-06 07:18:04'),
(226, 76, 'correct_spelling', '2025-07-06', 0, 10, '2025-07-06 07:50:50', '2025-07-06 07:50:50'),
(227, 76, 'find_faster', '2025-07-06', 0, 20, '2025-07-06 08:02:39', '2025-07-06 08:02:39'),
(228, 80, 'find_faster', '2025-07-08', 0, 6, '2025-07-08 07:16:10', '2025-07-08 07:16:10'),
(229, 80, 'correct_spelling', '2025-07-08', 0, 9, '2025-07-08 07:33:02', '2025-07-08 07:33:02'),
(230, 80, 'image_puzzle', '2025-07-08', 0, 7, '2025-07-08 07:33:33', '2025-07-08 07:33:33'),
(231, 80, 'math_check', '2025-07-08', 0, 9, '2025-07-08 07:33:38', '2025-07-08 07:33:38'),
(232, 81, 'correct_spelling', '2025-07-08', 0, 9, '2025-07-08 07:33:49', '2025-07-08 07:33:49'),
(233, 81, 'math_check', '2025-07-08', 0, 10, '2025-07-08 07:34:33', '2025-07-08 07:34:33'),
(234, 82, 'find_faster', '2025-07-08', 0, 8, '2025-07-08 07:56:42', '2025-07-08 07:56:42'),
(235, 113, 'correct_spelling', '2025-07-10', 2, 7, '2025-07-10 01:28:02', '2025-07-10 01:32:37'),
(236, 114, 'correct_spelling', '2025-07-10', 10, 10, '2025-07-10 01:30:31', '2025-07-10 01:42:58'),
(237, 114, 'find_faster', '2025-07-10', 2, 7, '2025-07-10 01:43:41', '2025-07-10 01:45:17'),
(238, 115, 'correct_spelling', '2025-07-10', 1, 7, '2025-07-10 01:50:18', '2025-07-10 01:51:59'),
(239, 115, 'image_puzzle', '2025-07-10', 0, 5, '2025-07-10 01:50:34', '2025-07-10 01:50:34'),
(240, 116, 'correct_spelling', '2025-07-10', 0, 6, '2025-07-10 01:58:11', '2025-07-10 01:58:11'),
(241, 117, 'correct_spelling', '2025-07-10', 2, 10, '2025-07-10 02:03:59', '2025-07-10 02:05:18'),
(242, 119, 'correct_spelling', '2025-07-10', 0, 6, '2025-07-10 05:13:33', '2025-07-10 05:13:33'),
(243, 119, 'find_faster', '2025-07-10', 0, 9, '2025-07-10 07:18:45', '2025-07-10 07:18:45'),
(244, 119, 'image_puzzle', '2025-07-10', 0, 10, '2025-07-10 07:32:36', '2025-07-10 07:32:36'),
(245, 120, 'correct_spelling', '2025-07-10', 10, 14, '2025-07-10 07:33:58', '2025-07-10 08:14:21'),
(246, 120, 'find_faster', '2025-07-10', 6, 8, '2025-07-10 08:16:47', '2025-07-10 08:20:28'),
(247, 120, 'image_puzzle', '2025-07-10', 7, 7, '2025-07-10 08:20:46', '2025-07-10 08:25:22'),
(248, 119, 'math_check', '2025-07-10', 0, 8, '2025-07-10 08:20:54', '2025-07-10 08:20:54'),
(249, 120, 'math_check', '2025-07-10', 11, 11, '2025-07-10 08:27:03', '2025-07-10 09:02:58'),
(250, 116, 'math_check', '2025-07-10', 0, 8, '2025-07-10 08:38:38', '2025-07-10 08:38:38'),
(251, 116, 'image_puzzle', '2025-07-10', 0, 10, '2025-07-10 08:39:57', '2025-07-10 08:39:57'),
(252, 116, 'find_faster', '2025-07-10', 2, 7, '2025-07-10 08:41:47', '2025-07-10 18:19:11'),
(253, 121, 'correct_spelling', '2025-07-10', 0, 7, '2025-07-10 11:25:07', '2025-07-10 11:25:07'),
(254, 121, 'math_check', '2025-07-10', 0, 10, '2025-07-10 11:25:52', '2025-07-10 11:25:52'),
(255, 118, 'correct_spelling', '2025-07-10', 0, 6, '2025-07-10 11:46:55', '2025-07-10 11:46:55'),
(256, 118, 'find_faster', '2025-07-10', 0, 10, '2025-07-10 11:47:26', '2025-07-10 11:47:26'),
(257, 122, 'image_puzzle', '2025-07-10', 0, 10, '2025-07-10 12:21:58', '2025-07-10 12:21:58'),
(258, 122, 'correct_spelling', '2025-07-10', 0, 10, '2025-07-10 12:22:47', '2025-07-10 12:22:47'),
(259, 123, 'correct_spelling', '2025-07-10', 0, 13, '2025-07-10 13:23:10', '2025-07-10 13:23:10'),
(260, 123, 'find_faster', '2025-07-10', 0, 6, '2025-07-10 13:24:12', '2025-07-10 13:24:12'),
(261, 113, 'image_puzzle', '2025-07-10', 0, 7, '2025-07-10 13:25:56', '2025-07-10 13:25:56'),
(262, 124, 'correct_spelling', '2025-07-10', 7, 7, '2025-07-10 13:54:25', '2025-07-10 14:04:05'),
(263, 124, 'find_faster', '2025-07-10', 6, 8, '2025-07-10 14:04:17', '2025-07-10 14:09:35'),
(264, 124, 'image_puzzle', '2025-07-10', 5, 5, '2025-07-10 14:11:05', '2025-07-10 14:15:00'),
(265, 124, 'math_check', '2025-07-10', 11, 11, '2025-07-10 14:15:36', '2025-07-10 14:23:04'),
(266, 125, 'correct_spelling', '2025-07-10', 0, 15, '2025-07-10 14:54:40', '2025-07-10 14:54:40'),
(267, 126, 'correct_spelling', '2025-07-10', 0, 5, '2025-07-10 15:37:19', '2025-07-10 15:37:19'),
(268, 130, 'correct_spelling', '2025-07-11', 1, 13, '2025-07-11 01:42:02', '2025-07-11 01:43:19'),
(269, 131, 'math_check', '2025-07-11', 11, 11, '2025-07-11 01:42:24', '2025-07-11 01:48:04'),
(270, 130, 'find_faster', '2025-07-11', 3, 9, '2025-07-11 01:43:23', '2025-07-11 01:49:07'),
(271, 131, 'image_puzzle', '2025-07-11', 7, 7, '2025-07-11 01:44:47', '2025-07-11 02:12:14'),
(272, 131, 'find_faster', '2025-07-11', 6, 6, '2025-07-11 01:48:41', '2025-07-11 01:51:11'),
(273, 130, 'image_puzzle', '2025-07-11', 1, 9, '2025-07-11 01:49:13', '2025-07-11 01:49:35'),
(274, 131, 'correct_spelling', '2025-07-11', 10, 10, '2025-07-11 01:51:27', '2025-07-11 02:16:58'),
(275, 130, 'math_check', '2025-07-11', 3, 10, '2025-07-11 01:51:30', '2025-07-11 01:52:41'),
(276, 132, 'image_puzzle', '2025-07-11', 2, 5, '2025-07-11 02:07:24', '2025-07-11 05:55:59'),
(277, 132, 'find_faster', '2025-07-11', 0, 10, '2025-07-11 02:27:03', '2025-07-11 02:27:03'),
(278, 133, 'find_faster', '2025-07-11', 0, 5, '2025-07-11 03:38:37', '2025-07-11 03:38:37'),
(279, 133, 'correct_spelling', '2025-07-11', 0, 5, '2025-07-11 03:46:29', '2025-07-11 03:46:29'),
(280, 134, 'find_faster', '2025-07-11', 2, 7, '2025-07-11 05:31:37', '2025-07-11 05:32:37'),
(281, 134, 'math_check', '2025-07-11', 0, 11, '2025-07-11 05:32:44', '2025-07-11 05:32:44'),
(282, 134, 'image_puzzle', '2025-07-11', 0, 5, '2025-07-11 05:32:49', '2025-07-11 05:32:49'),
(283, 132, 'correct_spelling', '2025-07-11', 1, 7, '2025-07-11 05:53:45', '2025-07-11 05:54:25'),
(284, 135, 'correct_spelling', '2025-07-11', 2, 12, '2025-07-11 06:02:49', '2025-07-11 06:04:26'),
(285, 135, 'find_faster', '2025-07-11', 4, 7, '2025-07-11 06:04:30', '2025-07-11 06:07:18'),
(286, 135, 'image_puzzle', '2025-07-11', 3, 9, '2025-07-11 06:07:24', '2025-07-11 06:09:37'),
(287, 135, 'math_check', '2025-07-11', 5, 12, '2025-07-11 06:10:37', '2025-07-11 06:11:55'),
(288, 136, 'image_puzzle', '2025-07-11', 2, 7, '2025-07-11 06:17:41', '2025-07-11 06:18:12'),
(289, 137, 'correct_spelling', '2025-07-11', 6, 6, '2025-07-11 06:21:45', '2025-07-11 06:24:07'),
(290, 137, 'find_faster', '2025-07-11', 6, 9, '2025-07-11 06:25:16', '2025-07-11 06:26:53'),
(291, 137, 'image_puzzle', '2025-07-11', 5, 5, '2025-07-11 06:27:18', '2025-07-11 06:28:40'),
(292, 137, 'math_check', '2025-07-11', 8, 8, '2025-07-11 06:28:52', '2025-07-11 06:31:34'),
(293, 139, 'math_check', '2025-07-11', 12, 12, '2025-07-11 09:10:29', '2025-07-11 09:12:43'),
(294, 139, 'find_faster', '2025-07-11', 6, 9, '2025-07-11 09:12:51', '2025-07-11 09:14:05'),
(295, 139, 'image_puzzle', '2025-07-11', 10, 10, '2025-07-11 09:14:22', '2025-07-11 09:16:16'),
(296, 139, 'correct_spelling', '2025-07-11', 10, 12, '2025-07-11 09:17:02', '2025-07-11 09:19:35'),
(297, 140, 'correct_spelling', '2025-07-11', 9, 9, '2025-07-11 09:37:08', '2025-07-11 09:39:03'),
(298, 141, 'correct_spelling', '2025-07-11', 0, 11, '2025-07-11 09:38:11', '2025-07-11 09:38:11'),
(299, 140, 'find_faster', '2025-07-11', 6, 7, '2025-07-11 09:39:08', '2025-07-11 09:40:31'),
(300, 140, 'image_puzzle', '2025-07-11', 9, 9, '2025-07-11 09:41:10', '2025-07-11 09:42:50'),
(301, 140, 'math_check', '2025-07-11', 12, 12, '2025-07-11 09:42:56', '2025-07-11 09:44:40'),
(302, 142, 'correct_spelling', '2025-07-11', 5, 5, '2025-07-11 10:39:09', '2025-07-11 17:08:03'),
(303, 142, 'find_faster', '2025-07-11', 6, 6, '2025-07-11 10:45:24', '2025-07-11 17:09:14'),
(304, 143, 'correct_spelling', '2025-07-11', 1, 12, '2025-07-11 11:15:17', '2025-07-11 11:15:40'),
(305, 143, 'image_puzzle', '2025-07-11', 0, 7, '2025-07-11 11:18:08', '2025-07-11 11:18:08'),
(306, 144, 'correct_spelling', '2025-07-11', 10, 11, '2025-07-11 12:22:43', '2025-07-11 12:25:45'),
(307, 144, 'find_faster', '2025-07-11', 6, 7, '2025-07-11 12:26:02', '2025-07-11 12:27:39'),
(308, 144, 'image_puzzle', '2025-07-11', 5, 5, '2025-07-11 12:29:05', '2025-07-11 12:29:47'),
(309, 144, 'math_check', '2025-07-11', 9, 9, '2025-07-11 12:29:58', '2025-07-11 12:31:00'),
(310, 142, 'image_puzzle', '2025-07-11', 6, 6, '2025-07-11 12:51:28', '2025-07-11 17:10:23'),
(311, 142, 'math_check', '2025-07-11', 11, 11, '2025-07-11 12:51:53', '2025-07-11 17:10:42'),
(312, 145, 'correct_spelling', '2025-07-11', 2, 15, '2025-07-11 12:54:12', '2025-07-11 17:16:21'),
(313, 145, 'math_check', '2025-07-11', 0, 8, '2025-07-11 12:54:53', '2025-07-11 12:54:53'),
(314, 147, 'correct_spelling', '2025-07-11', 10, 12, '2025-07-11 15:22:17', '2025-07-11 15:24:36'),
(315, 147, 'find_faster', '2025-07-11', 6, 10, '2025-07-11 15:26:14', '2025-07-11 15:27:22'),
(316, 147, 'image_puzzle', '2025-07-11', 9, 9, '2025-07-11 15:27:50', '2025-07-11 15:29:35'),
(317, 147, 'math_check', '2025-07-11', 8, 8, '2025-07-11 15:30:10', '2025-07-11 15:32:02'),
(318, 136, 'correct_spelling', '2025-07-11', 1, 9, '2025-07-11 16:59:52', '2025-07-11 17:00:03'),
(319, 148, 'correct_spelling', '2025-07-11', 1, 1, '2025-07-11 17:12:30', '2025-07-11 17:14:01'),
(320, 148, 'find_faster', '2025-07-11', 1, 1, '2025-07-11 17:16:18', '2025-07-11 17:17:30'),
(321, 148, 'image_puzzle', '2025-07-11', 1, 1, '2025-07-11 17:20:01', '2025-07-11 17:20:57'),
(322, 148, 'math_check', '2025-07-11', 1, 1, '2025-07-11 17:25:06', '2025-07-11 17:25:59'),
(323, 152, 'correct_spelling', '2025-07-12', 1, 1, '2025-07-11 18:53:02', '2025-07-11 18:53:11'),
(324, 152, 'image_puzzle', '2025-07-12', 1, 1, '2025-07-11 18:53:43', '2025-07-11 18:53:51'),
(325, 152, 'math_check', '2025-07-12', 1, 1, '2025-07-11 18:54:53', '2025-07-11 18:55:05'),
(326, 152, 'find_faster', '2025-07-12', 1, 1, '2025-07-11 18:55:12', '2025-07-11 18:55:21'),
(327, 140, 'correct_spelling', '2025-07-12', 1, 1, '2025-07-11 21:20:22', '2025-07-11 21:20:54'),
(328, 140, 'find_faster', '2025-07-12', 1, 1, '2025-07-11 21:20:30', '2025-07-11 21:20:40'),
(329, 140, 'image_puzzle', '2025-07-12', 1, 1, '2025-07-11 21:20:59', '2025-07-11 21:21:09'),
(330, 140, 'math_check', '2025-07-12', 1, 1, '2025-07-11 21:21:15', '2025-07-11 21:21:23'),
(331, 142, 'correct_spelling', '2025-07-12', 1, 1, '2025-07-12 02:36:34', '2025-07-12 02:57:03'),
(332, 142, 'find_faster', '2025-07-12', 1, 1, '2025-07-12 02:38:19', '2025-07-12 02:57:51'),
(333, 142, 'image_puzzle', '2025-07-12', 1, 1, '2025-07-12 02:58:03', '2025-07-12 02:58:17'),
(334, 142, 'math_check', '2025-07-12', 1, 1, '2025-07-12 02:58:33', '2025-07-12 02:58:41'),
(335, 154, 'correct_spelling', '2025-07-12', 0, 1, '2025-07-12 03:17:59', '2025-07-12 03:17:59'),
(336, 154, 'find_faster', '2025-07-12', 1, 1, '2025-07-12 03:18:06', '2025-07-12 03:18:31'),
(337, 153, 'correct_spelling', '2025-07-12', 1, 1, '2025-07-12 03:18:44', '2025-07-12 03:19:07'),
(338, 153, 'find_faster', '2025-07-12', 1, 1, '2025-07-12 03:19:30', '2025-07-12 03:19:42'),
(339, 153, 'image_puzzle', '2025-07-12', 1, 1, '2025-07-12 03:19:51', '2025-07-12 03:20:11'),
(340, 153, 'math_check', '2025-07-12', 1, 1, '2025-07-12 03:20:18', '2025-07-12 03:20:30');

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

--
-- 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 `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 `image_puzzle_images`
--
ALTER TABLE `image_puzzle_images`
  ADD PRIMARY KEY (`id`);

--
-- 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`),
  ADD UNIQUE KEY `user_task_date` (`user_id`,`task_type`,`usage_date`),
  ADD KEY `idx_user_date` (`user_id`,`usage_date`),
  ADD KEY `idx_task_type` (`task_type`);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `daily_checkins`
--
ALTER TABLE `daily_checkins`
  ADD CONSTRAINT `daily_checkins_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `promo_code_usage`
--
ALTER TABLE `promo_code_usage`
  ADD CONSTRAINT `promo_code_usage_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `promo_code_usage_ibfk_2` FOREIGN KEY (`promo_code_id`) REFERENCES `promo_codes` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `redeem_options_subcategories`
--
ALTER TABLE `redeem_options_subcategories`
  ADD CONSTRAINT `redeem_options_subcategories_ibfk_1` FOREIGN KEY (`category_id`) REFERENCES `redeem_options_categories` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `referral_rewards`
--
ALTER TABLE `referral_rewards`
  ADD CONSTRAINT `referral_rewards_ibfk_1` FOREIGN KEY (`referrer_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `referral_rewards_ibfk_2` FOREIGN KEY (`referred_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `task_completions`
--
ALTER TABLE `task_completions`
  ADD CONSTRAINT `task_completions_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `task_completions_ibfk_2` FOREIGN KEY (`task_id`) REFERENCES `tasks` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `task_questions`
--
ALTER TABLE `task_questions`
  ADD CONSTRAINT `task_questions_ibfk_1` FOREIGN KEY (`task_id`) REFERENCES `tasks` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `users`
--
ALTER TABLE `users`
  ADD CONSTRAINT `users_ibfk_1` FOREIGN KEY (`referred_by`) REFERENCES `users` (`id`) ON DELETE SET NULL;
COMMIT;

