-- phpMyAdmin SQL Dump
-- version 5.2.1deb3
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Oct 14, 2025 at 06:02 AM
-- Server version: 8.0.43-0ubuntu0.24.04.1
-- PHP Version: 8.3.6

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `clean_dt_quiz`
--

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

--
-- Table structure for table `tbl_admin`
--

CREATE TABLE `tbl_admin` (
  `id` int UNSIGNED NOT NULL,
  `user_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` int 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=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tbl_admin`
--

INSERT INTO `tbl_admin` (`id`, `user_name`, `email`, `password`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Admin', 'admin@admin.com', '$2y$10$wjjiTMuClK4o351eZSITquRjPX/85/GHW4mq7Qt5Exf7lL5krLjk6', 1, '2023-05-08 05:12:06', '2025-07-07 06:56:01');

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

--
-- Table structure for table `tbl_audio_quiz_leaderboard`
--

CREATE TABLE `tbl_audio_quiz_leaderboard` (
  `id` int UNSIGNED NOT NULL,
  `user_id` int NOT NULL,
  `category_id` int NOT NULL,
  `skill_id` int NOT NULL,
  `classification_id` int NOT NULL,
  `level_id` int NOT NULL,
  `total_questions` int NOT NULL,
  `questions_attended` int NOT NULL,
  `correct_answers` int NOT NULL,
  `percentage` int NOT NULL,
  `winning_coin` int NOT NULL,
  `status` int NOT NULL COMMENT '0- Fail, 1- Pass',
  `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;

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

--
-- Table structure for table `tbl_audio_quiz_question`
--

CREATE TABLE `tbl_audio_quiz_question` (
  `id` int UNSIGNED NOT NULL,
  `category_id` int NOT NULL,
  `skill_id` int NOT NULL,
  `classification_id` int NOT NULL,
  `level_id` int NOT NULL,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `audio_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'server_audio, external_url	',
  `audio` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `question` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `option_a` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `option_b` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `option_c` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `option_d` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `correct_answer` int NOT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` int NOT NULL DEFAULT '1' COMMENT '0- Hide, 1- Show',
  `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;

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

--
-- Table structure for table `tbl_avatar`
--

CREATE TABLE `tbl_avatar` (
  `id` int UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `sort_order` int NOT NULL DEFAULT '0',
  `status` int NOT NULL DEFAULT '1' COMMENT '0- Hide, 1- Show',
  `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;

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

--
-- Table structure for table `tbl_badge`
--

CREATE TABLE `tbl_badge` (
  `id` int UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `label` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `earning_coin` int NOT NULL,
  `min_pass_quiz` int NOT NULL DEFAULT '0',
  `min_win_contest` int NOT NULL DEFAULT '0',
  `min_day_play` int NOT NULL DEFAULT '0',
  `min_coin_sharing` int NOT NULL DEFAULT '0',
  `min_referrals` int NOT NULL DEFAULT '0',
  `status` int NOT NULL DEFAULT '1' COMMENT '0- Hide, 1- Show',
  `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 `tbl_badge`
--

INSERT INTO `tbl_badge` (`id`, `name`, `label`, `description`, `image`, `earning_coin`, `min_pass_quiz`, `min_win_contest`, `min_day_play`, `min_coin_sharing`, `min_referrals`, `status`, `created_at`, `updated_at`) VALUES
(1, 'practice_quiz_badge', 'Practice Quiz Badge', 'Practice Quiz Badge', 'badge_2025_07_21_687dd44b1f0fd.png', 0, 0, 0, 0, 0, 0, 0, '2024-11-06 11:32:01', '2025-10-14 05:46:49'),
(2, 'normal_quiz_badge', 'Normal Quiz Badge', 'Normal Quiz Badge', 'badge_2025_07_21_687dd44b1fcd0.png', 0, 0, 0, 0, 0, 0, 0, '2024-11-06 11:32:47', '2025-10-14 05:46:49'),
(3, 'audio_quiz_badge', 'Audio Quiz Badge', 'Audio Quiz Badge', 'badge_2025_07_21_687dd2bce4ca2.png', 0, 0, 0, 0, 0, 0, 0, '2024-11-06 11:33:22', '2025-10-14 05:46:49'),
(4, 'video_quiz_badge', 'Video Quiz', 'Video Quiz Badge', 'badge_25_11_2024_2754.png', 0, 0, 0, 0, 0, 0, 0, '2024-11-06 11:34:14', '2025-10-14 05:46:49'),
(5, 'true_false_quiz_badge', 'True-False Quiz', 'True-False Quiz Badge', 'badge_25_11_2024_8382.png', 0, 0, 0, 0, 0, 0, 0, '2024-11-06 11:35:20', '2025-10-14 05:46:49'),
(6, 'fear_factor_quiz_badge', 'Fear Factor Quiz', 'Fear Factor Quiz Badge', 'badge_25_11_2024_9087.png', 0, 0, 0, 0, 0, 0, 0, '2024-11-06 11:38:24', '2025-10-14 05:46:49'),
(7, 'one_vs_one_battles_badge', 'One vs One Battles', 'One vs One Battles Badge', 'badge_25_11_2024_5793.png', 0, 0, 0, 0, 0, 0, 0, '2024-11-06 11:39:16', '2025-10-14 05:46:49'),
(8, 'ultimate_challenge_badge', 'Ultimate Challenge', 'Ultimate Challenge Badge', 'badge_25_11_2024_1485.png', 0, 0, 0, 0, 0, 0, 0, '2024-11-06 11:40:17', '2025-10-14 05:46:49'),
(9, 'contest_badge', 'Contest', 'Contest Badge', 'badge_25_11_2024_2531.png', 0, 0, 0, 0, 0, 0, 0, '2024-11-06 11:40:59', '2025-10-14 05:46:49'),
(10, 'daily_quiz_badge', 'Daily Quiz', 'Daily Quiz Badge', 'badge_25_11_2024_2447.png', 0, 0, 0, 0, 0, 0, 0, '2024-11-06 11:42:36', '2025-10-14 05:46:49'),
(11, 'coin_sharing_badge', 'Coin Sharing', 'Coin Sharing Badge', 'badge_2025_07_08_686cc8a103fca.png', 0, 0, 0, 0, 0, 0, 0, '2024-11-06 11:45:39', '2025-10-14 05:46:49'),
(12, 'subscription_badge', 'Subscription', 'Subscription Badge', 'badge_25_11_2024_5524.png', 0, 0, 0, 0, 0, 0, 0, '2024-11-06 11:46:26', '2025-10-14 05:46:49'),
(13, 'refer_earn_badge', 'Refer Earn', 'Refer Earn Badge', 'badge_2025_07_08_686cc88ed6604.png', 0, 0, 0, 0, 0, 0, 0, '2024-11-06 11:47:13', '2025-10-14 05:46:49'),
(14, 'group_battles_badge', 'Group Battles', 'Group Battles Badge', 'badge_2025_07_08_686cc8b405307.png', 0, 0, 0, 0, 0, 0, 0, '2024-11-06 11:39:16', '2025-10-14 05:46:49'),
(15, 'exam_battles_badge', 'Exam Quiz', 'Exam Quiz Badge', 'badge_2025_07_08_686cc8b408a9d.png', 0, 0, 0, 0, 0, 0, 0, '2025-07-08 04:59:18', '2025-10-14 05:46:49');

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

--
-- Table structure for table `tbl_battles_question`
--

CREATE TABLE `tbl_battles_question` (
  `id` int UNSIGNED NOT NULL,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `question` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `option_a` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `option_b` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `option_c` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `option_d` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `correct_answer` int NOT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` int NOT NULL DEFAULT '1' COMMENT '0- Hide, 1- Show',
  `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;

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

--
-- Table structure for table `tbl_category`
--

CREATE TABLE `tbl_category` (
  `id` int UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `sort_order` int NOT NULL DEFAULT '0',
  `status` int NOT NULL DEFAULT '1' COMMENT '0- Hide, 1- Show',
  `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;

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

--
-- Table structure for table `tbl_classification`
--

CREATE TABLE `tbl_classification` (
  `id` int UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `sort_order` int NOT NULL DEFAULT '0',
  `status` int NOT NULL DEFAULT '1' COMMENT '0- Hide, 1- Show',
  `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;

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

--
-- Table structure for table `tbl_coin_share_list`
--

CREATE TABLE `tbl_coin_share_list` (
  `id` int UNSIGNED NOT NULL,
  `user_id` int NOT NULL,
  `to_user_id` int NOT NULL,
  `coin` int NOT NULL,
  `status` int 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=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_contest`
--

CREATE TABLE `tbl_contest` (
  `id` int UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `start_date` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `end_date` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `total_questions` int NOT NULL,
  `duration` int NOT NULL,
  `entry_fee` int NOT NULL,
  `max_participants` int NOT NULL COMMENT 'Maximum number of users allowed to join the contest.',
  `total_prize_users` int NOT NULL COMMENT 'Number of users that will receive a prize',
  `total_ranks` int NOT NULL COMMENT 'Number of ranks',
  `total_prize_coins` int NOT NULL COMMENT 'Total number of coins to be distributed as prizes.',
  `prize_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` int 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=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tbl_contest_leaderboard`
--

CREATE TABLE `tbl_contest_leaderboard` (
  `id` int UNSIGNED NOT NULL,
  `contest_id` int NOT NULL,
  `user_id` int NOT NULL,
  `total_questions` int NOT NULL,
  `questions_attended` int NOT NULL,
  `correct_answers` int NOT NULL,
  `percentage` int NOT NULL,
  `question_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `rank` int NOT NULL DEFAULT '0',
  `winning_coin` int NOT NULL DEFAULT '0',
  `status` int 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=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tbl_contest_question`
--

CREATE TABLE `tbl_contest_question` (
  `id` int UNSIGNED NOT NULL,
  `contest_id` int NOT NULL,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `question` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `option_a` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `option_b` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `option_c` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `option_d` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `correct_answer` int NOT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` int NOT NULL DEFAULT '1' COMMENT '0- Hide, 1- Show',
  `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;

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

--
-- Table structure for table `tbl_contest_transaction`
--

CREATE TABLE `tbl_contest_transaction` (
  `id` int UNSIGNED NOT NULL,
  `user_id` int NOT NULL,
  `contest_id` int NOT NULL,
  `coin` int NOT NULL COMMENT 'Entry Fee',
  `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;

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

--
-- Table structure for table `tbl_daily_quiz_leaderboard`
--

CREATE TABLE `tbl_daily_quiz_leaderboard` (
  `id` int UNSIGNED NOT NULL,
  `user_id` int NOT NULL,
  `total_questions` int NOT NULL,
  `questions_attended` int NOT NULL,
  `correct_answers` int NOT NULL,
  `percentage` int NOT NULL,
  `winning_coin` int NOT NULL,
  `status` int NOT NULL COMMENT '0- Fail, 1- Pass',
  `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;

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

--
-- Table structure for table `tbl_daily_quiz_question`
--

CREATE TABLE `tbl_daily_quiz_question` (
  `id` int UNSIGNED NOT NULL,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `question` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `option_a` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `option_b` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `option_c` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `option_d` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `correct_answer` int NOT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` int NOT NULL DEFAULT '1' COMMENT '0- Hide, 1- Show',
  `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;

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

--
-- Table structure for table `tbl_exam`
--

CREATE TABLE `tbl_exam` (
  `id` int UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `total_questions` int NOT NULL,
  `quiz_duration` int NOT NULL,
  `entry_fee` int NOT NULL,
  `min_winning_percentage` int NOT NULL DEFAULT '0',
  `winning_coin` int NOT NULL DEFAULT '0',
  `status` int NOT NULL DEFAULT '1' COMMENT '0- Hide, 1- Show',
  `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;

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

--
-- Table structure for table `tbl_exam_leaderboard`
--

CREATE TABLE `tbl_exam_leaderboard` (
  `id` int UNSIGNED NOT NULL,
  `user_id` int NOT NULL,
  `exam_id` int NOT NULL,
  `total_questions` int NOT NULL,
  `questions_attended` int NOT NULL,
  `correct_answers` int NOT NULL,
  `percentage` int NOT NULL,
  `winning_coin` int NOT NULL,
  `status` int NOT NULL COMMENT '0- Fail, 1- Pass',
  `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;

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

--
-- Table structure for table `tbl_exam_question`
--

CREATE TABLE `tbl_exam_question` (
  `id` int UNSIGNED NOT NULL,
  `exam_id` int NOT NULL,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `question` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `option_a` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `option_b` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `option_c` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `option_d` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `correct_answer` int NOT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` int NOT NULL DEFAULT '1' COMMENT '0- Hide, 1- Show',
  `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;

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

--
-- Table structure for table `tbl_fear_factor_quiz_leaderboard`
--

CREATE TABLE `tbl_fear_factor_quiz_leaderboard` (
  `id` int UNSIGNED NOT NULL,
  `user_id` int NOT NULL,
  `category_id` int NOT NULL,
  `skill_id` int NOT NULL,
  `classification_id` int NOT NULL,
  `level_id` int NOT NULL,
  `total_questions` int NOT NULL,
  `questions_attended` int NOT NULL,
  `correct_answers` int NOT NULL,
  `percentage` int NOT NULL,
  `winning_coin` int NOT NULL,
  `status` int NOT NULL COMMENT '0- Fail 1- Pass',
  `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;

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

--
-- Table structure for table `tbl_fear_factor_quiz_question`
--

CREATE TABLE `tbl_fear_factor_quiz_question` (
  `id` int UNSIGNED NOT NULL,
  `category_id` int NOT NULL,
  `skill_id` int NOT NULL,
  `classification_id` int NOT NULL,
  `level_id` int NOT NULL,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `question` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `option_a` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `option_b` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `option_c` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `option_d` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `correct_answer` int NOT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` int NOT NULL DEFAULT '1' COMMENT '0- Hide, 1- Show',
  `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;

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

--
-- Table structure for table `tbl_general_setting`
--

CREATE TABLE `tbl_general_setting` (
  `id` int UNSIGNED NOT NULL,
  `key` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT 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 `tbl_general_setting`
--

INSERT INTO `tbl_general_setting` (`id`, `key`, `value`, `created_at`, `updated_at`) VALUES
(1, 'app_name', 'DTQuiz', '2023-04-21 05:09:12', '2025-07-03 09:33:52'),
(2, 'app_version', '1.3', '2023-04-21 05:09:12', '2025-10-14 05:50:21'),
(3, 'app_logo', '', '2023-04-21 05:09:12', '2025-10-14 05:50:24'),
(4, 'app_description', 'DivineTechs, a top web & mobile app development company offering innovative solutions for diverse industry verticals. \r\nWe have creative and dedicated group of developers who are mastered in Apps Developments and Web Development with a nice in delivering quality solutions to customers across the globe.', '2023-04-21 05:09:12', '2025-07-03 09:33:52'),
(5, 'author', 'DivineTechs', '2023-04-21 05:09:12', '2025-10-14 05:50:36'),
(6, 'email', 'support@divinetechs.com', '2023-04-21 05:09:12', '2025-10-14 05:51:08'),
(7, 'contact', '+91 7984798190', '2023-04-21 05:09:12', '2025-10-14 05:51:02'),
(8, 'website', 'https://www.divinetechs.com', '2023-04-21 05:09:12', '2025-10-14 05:51:14'),
(9, 'currency', 'USD', '2023-04-21 05:09:12', '2025-07-03 09:39:22'),
(10, 'currency_code', '$', '2023-04-21 05:09:12', '2025-07-03 09:39:22'),
(11, 'admob_status', '0', '2023-04-21 05:09:12', '2025-10-14 05:47:14'),
(12, 'banner_ad', '0', '2023-04-21 05:09:12', '2025-10-14 05:47:29'),
(13, 'banner_adid', '', '2023-04-21 05:09:12', '2025-10-14 05:47:29'),
(14, 'interstital_ad', '0', '2023-04-21 05:09:12', '2025-10-14 05:47:29'),
(15, 'interstital_adid', '', '2023-04-21 05:09:12', '2025-10-14 05:47:29'),
(16, 'interstital_adclick', '0', '2023-04-21 05:09:12', '2025-10-14 05:47:29'),
(17, 'reward_ad', '0', '2023-04-21 05:09:12', '2025-10-14 05:47:29'),
(18, 'reward_adid', '', '2023-04-21 05:09:12', '2025-10-14 05:47:29'),
(19, 'reward_adclick', '0', '2023-04-21 05:09:12', '2025-07-24 12:30:55'),
(20, 'ios_banner_ad', '0', '2023-04-21 05:09:12', '2025-10-14 05:47:45'),
(21, 'ios_banner_adid', '', '2023-04-21 05:09:12', '2025-10-14 05:47:45'),
(22, 'ios_interstital_ad', '0', '2023-04-21 05:09:12', '2025-10-14 05:47:45'),
(23, 'ios_interstital_adid', '', '2023-04-21 05:09:12', '2025-10-14 05:47:45'),
(24, 'ios_interstital_adclick', '0', '2023-04-21 05:09:12', '2025-10-14 05:47:45'),
(25, 'ios_reward_ad', '0', '2023-04-21 05:09:12', '2025-10-14 05:47:45'),
(26, 'ios_reward_adid', '', '2023-04-21 05:09:12', '2025-10-14 05:47:45'),
(27, 'ios_reward_adclick', '0', '2023-04-21 05:09:12', '2025-07-24 12:31:00'),
(28, 'facebook_ads_status', '0', '2023-04-21 05:09:12', '2025-07-03 10:23:50'),
(29, 'fb_native_status', '0', '2023-04-21 05:09:12', '2025-07-03 10:25:56'),
(30, 'fb_native_id', '', '2023-04-21 05:09:12', '2025-07-03 10:25:57'),
(31, 'fb_banner_status', '0', '2023-04-21 05:09:12', '2025-07-03 10:25:57'),
(32, 'fb_banner_id', '', '2023-04-21 05:09:12', '2025-07-03 10:25:57'),
(33, 'fb_interstiatial_status', '0', '2023-04-21 05:09:12', '2025-07-03 10:25:57'),
(34, 'fb_interstiatial_id', '', '2023-04-21 05:09:12', '2025-07-03 10:25:57'),
(35, 'fb_rewardvideo_status', '0', '2023-04-21 05:09:12', '2025-07-03 10:25:57'),
(36, 'fb_rewardvideo_id', '', '2023-04-21 05:09:12', '2025-07-03 10:25:57'),
(37, 'fb_native_full_status', '0', '2023-04-21 05:09:12', '2025-07-03 10:25:57'),
(38, 'fb_native_full_id', '', '2023-04-21 05:09:12', '2025-07-03 10:25:57'),
(39, 'fb_ios_native_status', '0', '2023-04-21 05:09:12', '2025-07-03 10:26:55'),
(40, 'fb_ios_native_id', '', '2023-04-21 05:09:12', '2025-07-03 10:26:55'),
(41, 'fb_ios_banner_status', '0', '2023-04-21 05:09:12', '2025-07-03 10:26:55'),
(42, 'fb_ios_banner_id', '', '2023-04-21 05:09:12', '2025-07-03 10:26:55'),
(43, 'fb_ios_interstiatial_status', '0', '2023-04-21 05:09:12', '2025-07-03 10:26:55'),
(44, 'fb_ios_interstiatial_id', '', '2023-04-21 05:09:12', '2025-07-03 10:26:55'),
(45, 'fb_ios_rewardvideo_status', '0', '2023-04-21 05:09:12', '2025-07-03 10:26:55'),
(46, 'fb_ios_rewardvideo_id', '', '2023-04-21 05:09:12', '2025-07-03 10:26:55'),
(47, 'fb_ios_native_full_status', '0', '2023-04-21 05:09:12', '2025-07-03 10:26:55'),
(48, 'fb_ios_native_full_id', '', '2023-04-21 05:09:12', '2025-07-03 10:26:55'),
(49, 'onesignal_app_id', '', '2023-04-21 05:09:12', '2025-10-14 05:51:21'),
(50, 'onesignal_rest_key', '', '2023-04-21 05:09:12', '2025-10-14 05:51:22'),
(51, 'page_background_color', '#ffffff', '2024-10-28 11:30:11', '2025-07-21 15:51:54'),
(52, 'page_title_color', '#000000', '2024-10-28 11:30:11', '2025-07-21 15:51:54'),
(53, 'panel_login_page_view', '0', '2025-03-04 10:01:53', '2025-10-14 05:52:58'),
(54, 'panel_login_page_bg_image', '', '2025-03-04 10:02:37', '2025-10-14 05:52:57'),
(55, 'panel_login_page_bg_color', '#000000', '2025-03-04 10:02:37', '2025-07-03 10:36:23'),
(56, 'panel_login_page_image', '', '2025-03-04 10:02:55', '2025-07-03 10:36:23'),
(57, 'refer_and_earn_status', '0', '2025-05-21 09:29:04', '2025-10-14 05:47:56'),
(58, 'parent_user_earn', '0', '2025-05-21 09:29:04', '2025-10-14 05:47:56'),
(59, 'child_user_earn', '0', '2025-05-21 09:29:18', '2025-10-14 05:47:56'),
(60, 'min_coin_share', '100', '2024-09-18 06:44:45', '2025-10-14 05:52:07'),
(61, 'min_withdrawal_coin', '100', '2024-09-18 13:38:21', '2025-07-22 15:22:25'),
(62, 'earning_per_coin', '100', '2024-09-18 13:39:32', '2025-10-14 05:52:02'),
(63, 'coin_per_amount', '1', '2024-09-18 13:39:32', '2025-07-03 11:23:43'),
(64, 'badge_status', '0', '2025-07-08 05:26:59', '2025-10-14 05:46:14'),
(65, 'playstore_id', '', '2025-07-17 13:05:25', '2025-07-17 13:05:25'),
(66, 'appstore_id', '', '2025-07-17 13:05:25', '2025-07-17 13:05:25'),
(67, 'withdrawal_coin_status', '0', '2025-08-21 11:56:33', '2025-08-21 11:56:33'),
(68, 'company_name', 'DivineTechs', '2025-08-21 11:56:33', '2025-08-21 11:56:33'),
(69, 'company_logo', '', '2025-08-21 11:56:33', '2025-08-21 11:56:33');

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

--
-- Table structure for table `tbl_group_battles`
--

CREATE TABLE `tbl_group_battles` (
  `id` int UNSIGNED NOT NULL,
  `room_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '6 Digit Code',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `created_user_id` int NOT NULL,
  `question_ids` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `total_questions` int NOT NULL,
  `joining_coin` int NOT NULL,
  `winning_coin` int NOT NULL DEFAULT '0',
  `status` int NOT NULL DEFAULT '0' COMMENT '0- Pending, 1- Started, 2- Completed',
  `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;

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

--
-- Table structure for table `tbl_group_battles_leaderboard`
--

CREATE TABLE `tbl_group_battles_leaderboard` (
  `id` int NOT NULL,
  `group_battles_id` int NOT NULL,
  `user_id` int NOT NULL,
  `is_creator` int NOT NULL DEFAULT '0' COMMENT '0- No, 1- Yes',
  `questions_attended` int NOT NULL DEFAULT '0',
  `correct_answers` int NOT NULL DEFAULT '0',
  `percentage` int NOT NULL DEFAULT '0',
  `is_winner` int NOT NULL DEFAULT '0',
  `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;

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

--
-- Table structure for table `tbl_level`
--

CREATE TABLE `tbl_level` (
  `id` int UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `joining_coin` int NOT NULL DEFAULT '0',
  `sort_order` int NOT NULL DEFAULT '0',
  `status` int NOT NULL DEFAULT '1' COMMENT '0- Hide, 1- Show',
  `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;

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

--
-- Table structure for table `tbl_normal_quiz_leaderboard`
--

CREATE TABLE `tbl_normal_quiz_leaderboard` (
  `id` int UNSIGNED NOT NULL,
  `user_id` int NOT NULL,
  `category_id` int NOT NULL,
  `skill_id` int NOT NULL,
  `classification_id` int NOT NULL,
  `level_id` int NOT NULL,
  `total_questions` int NOT NULL,
  `questions_attended` int NOT NULL,
  `correct_answers` int NOT NULL,
  `percentage` int NOT NULL,
  `winning_coin` int NOT NULL,
  `status` int NOT NULL COMMENT '0- Fail, 1- Pass',
  `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;

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

--
-- Table structure for table `tbl_normal_quiz_question`
--

CREATE TABLE `tbl_normal_quiz_question` (
  `id` int UNSIGNED NOT NULL,
  `category_id` int NOT NULL,
  `skill_id` int NOT NULL,
  `classification_id` int NOT NULL,
  `level_id` int NOT NULL,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `question` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `option_a` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `option_b` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `option_c` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `option_d` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `correct_answer` int NOT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` int NOT NULL DEFAULT '1' COMMENT '0- Hide, 1- Show',
  `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;

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

--
-- Table structure for table `tbl_notification`
--

CREATE TABLE `tbl_notification` (
  `id` int UNSIGNED NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` int 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=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tbl_onboarding_screen`
--

CREATE TABLE `tbl_onboarding_screen` (
  `id` int UNSIGNED NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `status` int 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=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_one_vs_one_battles`
--

CREATE TABLE `tbl_one_vs_one_battles` (
  `id` int UNSIGNED NOT NULL,
  `room_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '6 Digit Code',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `question_ids` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `total_questions` int NOT NULL DEFAULT '0',
  `joining_coin` int NOT NULL,
  `winning_coin` int NOT NULL DEFAULT '0',
  `is_full` int NOT NULL DEFAULT '0' COMMENT '0- No, 1- Yes',
  `c_user_id` int NOT NULL,
  `c_questions_attended` int NOT NULL DEFAULT '0',
  `c_correct_answers` int NOT NULL DEFAULT '0',
  `c_percentage` int NOT NULL DEFAULT '0',
  `j_user_id` int NOT NULL DEFAULT '0',
  `j_questions_attended` int NOT NULL DEFAULT '0',
  `j_correct_answers` int NOT NULL DEFAULT '0',
  `j_percentage` int NOT NULL DEFAULT '0',
  `w_user_id` int NOT NULL DEFAULT '0',
  `l_user_id` int NOT NULL DEFAULT '0',
  `status` int NOT NULL DEFAULT '0' COMMENT '0- Draw, 1- Completed, 2- Not Completed',
  `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;

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

--
-- Table structure for table `tbl_package`
--

CREATE TABLE `tbl_package` (
  `id` int UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `price` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `coin` int NOT NULL,
  `android_product_package` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `ios_product_package` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `web_product_package` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` int NOT NULL DEFAULT '1' COMMENT '0- Hide, 1- Show',
  `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;

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

--
-- Table structure for table `tbl_page`
--

CREATE TABLE `tbl_page` (
  `id` int UNSIGNED NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` int NOT NULL DEFAULT '1' COMMENT '0- Hide, 1- Show',
  `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 `tbl_page`
--

INSERT INTO `tbl_page` (`id`, `title`, `description`, `icon`, `status`, `created_at`, `updated_at`) VALUES
(1, 'About Us', '', '', 1, '2023-01-27 10:19:52', '2025-10-14 05:53:18'),
(2, 'Privacy Policy', '', '', 1, '2023-01-27 10:19:52', '2025-10-14 05:53:17'),
(3, 'Terms & Conditions', '', '', 1, '2023-01-27 10:19:52', '2025-10-14 05:53:16'),
(4, 'Refund Policy', '', '', 1, '2023-01-27 13:14:32', '2025-10-14 05:53:15');

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

--
-- Table structure for table `tbl_payment_option`
--

CREATE TABLE `tbl_payment_option` (
  `id` int UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `visibility` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_live` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `key_1` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `key_2` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `key_3` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `key_4` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT 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 `tbl_payment_option`
--

INSERT INTO `tbl_payment_option` (`id`, `name`, `visibility`, `is_live`, `key_1`, `key_2`, `key_3`, `key_4`, `created_at`, `updated_at`) VALUES
(1, 'inapppurchage', '0', '0', '', '', '', '', '2023-01-27 10:19:52', '2025-10-14 05:54:59'),
(2, 'paypal', '0', '0', '', '', '', '', '2023-01-27 10:19:52', '2025-10-14 05:55:00'),
(3, 'razorpay', '0', '0', '', '', '', '', '2023-01-27 10:19:52', '2025-10-14 05:54:57'),
(4, 'flutterwave', '0', '0', '', '', '', '', '2023-01-27 10:19:52', '2025-10-14 05:54:57'),
(5, 'payumoney', '0', '0', '', '', '', '', '2023-01-27 10:19:52', '2025-10-14 05:54:56'),
(6, 'paytm', '0', '0', '', '', '', '', '2023-01-27 10:19:52', '2025-10-14 05:54:56'),
(7, 'stripe', '0', '0', '', '', '', '', '2023-08-23 10:40:50', '2025-10-14 05:54:55');

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

--
-- Table structure for table `tbl_pratice_quiz_leaderboard`
--

CREATE TABLE `tbl_pratice_quiz_leaderboard` (
  `id` int UNSIGNED NOT NULL,
  `user_id` int NOT NULL,
  `category_id` int NOT NULL,
  `skill_id` int NOT NULL,
  `classification_id` int NOT NULL,
  `level_id` int NOT NULL,
  `total_questions` int NOT NULL,
  `questions_attended` int NOT NULL,
  `correct_answers` int NOT NULL,
  `percentage` int NOT NULL,
  `status` int NOT NULL COMMENT '0- Fail, 1- Pass',
  `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;

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

--
-- Table structure for table `tbl_pratice_quiz_question`
--

CREATE TABLE `tbl_pratice_quiz_question` (
  `id` int UNSIGNED NOT NULL,
  `category_id` int NOT NULL,
  `skill_id` int NOT NULL,
  `classification_id` int NOT NULL,
  `level_id` int NOT NULL,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `question` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `option_a` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `option_b` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `option_c` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `option_d` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `correct_answer` int NOT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` int NOT NULL DEFAULT '1' COMMENT '0- Hide, 1- Show',
  `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;

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

--
-- Table structure for table `tbl_product`
--

CREATE TABLE `tbl_product` (
  `id` int UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `coin` int NOT NULL,
  `status` int NOT NULL DEFAULT '1' COMMENT '0- Hide, 1- Show',
  `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;

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

--
-- Table structure for table `tbl_product_transaction`
--

CREATE TABLE `tbl_product_transaction` (
  `id` int UNSIGNED NOT NULL,
  `user_id` int NOT NULL,
  `product_id` int NOT NULL,
  `coin` int NOT NULL,
  `address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` int NOT NULL DEFAULT '0' COMMENT '	0- Pending , 1- Completed	',
  `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;

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

--
-- Table structure for table `tbl_quiz_configuration`
--

CREATE TABLE `tbl_quiz_configuration` (
  `id` int UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `quiz_status` int NOT NULL DEFAULT '1' COMMENT '0- Hide, 1- Show',
  `category_status` int NOT NULL DEFAULT '0' COMMENT '0- Hide, 1- Show',
  `skill_status` int NOT NULL DEFAULT '0' COMMENT '0- Hide, 1- Show',
  `classification_status` int NOT NULL DEFAULT '0' COMMENT '0- Hide, 1- Show',
  `level_status` int NOT NULL DEFAULT '0' COMMENT '0- Hide, 1- Show',
  `quiz_sort_order` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '1- Category, 2- Skill, 3- Classification, 4- Level',
  `total_questions` int NOT NULL DEFAULT '0',
  `quiz_duration` int NOT NULL DEFAULT '0' COMMENT 'In Second',
  `joining_type` int NOT NULL DEFAULT '1' COMMENT '1- Level Wise, 2- Quiz Wise',
  `joining_coin` int NOT NULL DEFAULT '0',
  `min_winning_percentage` int NOT NULL DEFAULT '0',
  `winning_coin_type` int NOT NULL DEFAULT '1' COMMENT '1- One Time, 2- Every Time',
  `winning_coin` int NOT NULL DEFAULT '0',
  `battles_commission` int NOT NULL DEFAULT '0' COMMENT 'In Percentage',
  `min_user_join` int NOT NULL DEFAULT '0',
  `max_user_join` int NOT NULL DEFAULT '0',
  `status` int 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=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_quiz_configuration`
--

INSERT INTO `tbl_quiz_configuration` (`id`, `name`, `icon`, `description`, `quiz_status`, `category_status`, `skill_status`, `classification_status`, `level_status`, `quiz_sort_order`, `total_questions`, `quiz_duration`, `joining_type`, `joining_coin`, `min_winning_percentage`, `winning_coin_type`, `winning_coin`, `battles_commission`, `min_user_join`, `max_user_join`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Practice Quiz', 'fa-pencil-alt', 'Sharpen your skills with unlimited practice quizzes.', 1, 1, 1, 1, 1, '2,1,3,4', 10, 24, 1, 0, 30, 1, 0, 0, 0, 0, 1, '2025-06-20 08:40:04', '2025-07-15 15:12:36'),
(2, 'Normal Quiz', 'fa-brain', 'Standard quizzes for general knowledge testing.', 1, 0, 0, 1, 1, '3,2,1,4', 10, 45, 1, 5, 50, 2, 50, 0, 0, 0, 1, '2025-06-20 08:40:04', '2025-07-15 17:12:12'),
(3, 'Audio Quiz', 'fa-headphones', 'Answer questions based on audio clips.', 1, 1, 1, 1, 1, '1,2,3,4', 10, 60, 2, 20, 50, 2, 50, 0, 0, 0, 1, '2025-06-20 08:40:04', '2025-07-15 17:25:41'),
(4, 'Video Quiz', 'fa-video', 'Interactive quizzes with embedded video questions.', 1, 1, 1, 1, 1, '1,2,3,4', 10, 60, 2, 0, 50, 1, 100, 0, 0, 0, 1, '2025-06-20 08:40:04', '2025-07-15 16:41:46'),
(5, 'True/False Quiz', 'fa-check-double', 'Simple binary questions to test your accuracy.', 1, 0, 0, 1, 1, '1,2,3,4', 10, 30, 1, 0, 50, 1, 50, 0, 0, 0, 1, '2025-06-20 08:40:04', '2025-07-17 18:18:20'),
(6, 'Fear-Factor Quiz', 'fa-bolt', 'High-risk quizzes with negative marking.', 1, 1, 1, 1, 1, '4,3,2,1', 10, 35, 2, 0, 40, 2, 50, 0, 0, 0, 1, '2025-06-20 08:40:04', '2025-07-16 10:02:05'),
(7, 'Ultimate Challenge Quiz', 'fa-bullseye', 'A tough set of questions to push your limits.', 1, 0, 0, 0, 0, '', 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 1, '2025-06-20 08:40:04', '2025-07-16 11:44:10'),
(8, 'Contest Quiz', 'fa-award', 'Join scheduled contests and win rewards.', 1, 0, 0, 0, 0, '', 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 1, '2025-06-20 08:40:04', '2025-07-16 18:10:12'),
(9, 'Daily Quiz', 'fa-calendar-day', 'A fresh quiz every day to keep your mind active.', 1, 0, 0, 0, 0, '', 10, 45, 1, 50, 50, 1, 50, 0, 0, 0, 1, '2025-06-20 08:40:04', '2025-07-15 17:35:52'),
(10, '1 vs 1 Battles Quiz', 'fa-user-friends', 'Compete live against a single opponent.', 0, 0, 0, 0, 0, '', 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, '2025-06-20 08:40:04', '2025-10-14 06:00:03'),
(11, 'Group Battles Quiz', 'fa-users', 'Battle multiple users in real time.', 0, 0, 0, 0, 0, '', 0, 0, 1, 0, 0, 1, 0, 0, 3, 3, 0, '2025-06-20 08:40:04', '2025-10-14 05:57:08'),
(12, 'Exam Quiz', 'fa-file-alt', 'Formal test format to simulate real exams.', 1, 0, 0, 0, 0, '', 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 1, '2025-06-20 08:40:04', '2025-07-16 10:04:08');

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

--
-- Table structure for table `tbl_read_notification`
--

CREATE TABLE `tbl_read_notification` (
  `id` int UNSIGNED NOT NULL,
  `user_id` int NOT NULL,
  `notification_id` int NOT 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;

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

--
-- Table structure for table `tbl_refer_earn`
--

CREATE TABLE `tbl_refer_earn` (
  `id` int UNSIGNED NOT NULL,
  `parent_user_id` int NOT NULL,
  `child_user_id` int NOT NULL,
  `reference_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `parent_user_coin` int NOT NULL,
  `child_user_coin` int NOT NULL,
  `status` int 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=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tbl_reward_setting`
--

CREATE TABLE `tbl_reward_setting` (
  `id` int UNSIGNED NOT NULL,
  `reward_type` int NOT NULL COMMENT '1- Spin Wheel, 2- Daily Reward, 3- Ads Free Reward	',
  `key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` int NOT 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 `tbl_reward_setting`
--

INSERT INTO `tbl_reward_setting` (`id`, `reward_type`, `key`, `value`, `created_at`, `updated_at`) VALUES
(1, 1, '1', 10, '2024-09-07 08:49:58', '2025-07-03 11:36:57'),
(2, 1, '2', 20, '2024-09-07 08:49:58', '2025-07-03 11:36:57'),
(3, 1, '3', 30, '2024-09-07 08:49:58', '2025-07-03 11:36:57'),
(4, 1, '4', 40, '2024-09-07 08:49:58', '2025-07-03 11:36:57'),
(5, 1, '5', 50, '2024-09-07 08:49:58', '2025-07-03 11:36:57'),
(6, 1, '6', 60, '2024-09-07 08:49:58', '2025-07-03 11:36:57'),
(7, 1, '7', 70, '2024-09-07 08:49:58', '2025-07-03 11:36:57'),
(8, 1, '8', 80, '2024-09-07 08:49:58', '2025-07-03 11:36:57'),
(9, 2, 'day-1', 10, '2024-09-07 08:49:58', '2025-07-23 15:30:56'),
(10, 2, 'day-2', 20, '2024-09-07 08:49:58', '2025-07-23 15:30:56'),
(11, 2, 'day-3', 30, '2024-09-07 08:49:58', '2025-10-14 05:31:47'),
(12, 2, 'day-4', 40, '2024-09-07 08:49:58', '2025-10-14 05:31:49'),
(13, 2, 'day-5', 50, '2024-09-07 08:49:58', '2025-10-14 05:31:51'),
(14, 2, 'day-6', 60, '2024-09-07 08:49:58', '2025-10-14 05:31:52'),
(15, 2, 'day-7', 70, '2024-09-07 08:49:58', '2025-10-14 05:31:54'),
(16, 3, 'ads_free_coin', 50, '2024-09-07 08:49:58', '2025-10-14 05:32:01');

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

--
-- Table structure for table `tbl_reward_transaction`
--

CREATE TABLE `tbl_reward_transaction` (
  `id` int UNSIGNED NOT NULL,
  `user_id` int NOT NULL,
  `reward_type` int NOT NULL COMMENT '	1- Spin Wheel	',
  `coin` int NOT 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;

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

--
-- Table structure for table `tbl_skill`
--

CREATE TABLE `tbl_skill` (
  `id` int UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `sort_order` int NOT NULL DEFAULT '0',
  `status` int NOT NULL DEFAULT '1' COMMENT '0- Hide, 1- Show',
  `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;

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

--
-- Table structure for table `tbl_smtp_setting`
--

CREATE TABLE `tbl_smtp_setting` (
  `id` int UNSIGNED NOT NULL,
  `protocol` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `host` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `port` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `user` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `pass` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `from_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `from_email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` int NOT NULL DEFAULT '0' COMMENT '0- No, 1- Yes',
  `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 `tbl_smtp_setting`
--

INSERT INTO `tbl_smtp_setting` (`id`, `protocol`, `host`, `port`, `user`, `pass`, `from_name`, `from_email`, `status`, `created_at`, `updated_at`) VALUES
(1, 'smtp123', 'smtp.gmail.com', '587', 'admin@admin.com', 'admin', 'DTQuiz-DivineTechs', 'admin@admin.com', 0, '2023-08-23 11:25:08', '2025-10-14 05:48:19');

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

--
-- Table structure for table `tbl_social_link`
--

CREATE TABLE `tbl_social_link` (
  `id` int UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `url` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `status` int 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=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_transaction`
--

CREATE TABLE `tbl_transaction` (
  `id` int UNSIGNED NOT NULL,
  `user_id` int NOT NULL,
  `package_id` int NOT NULL,
  `transaction_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `price` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `coin` int NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` int 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=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tbl_true_false_quiz_leaderboard`
--

CREATE TABLE `tbl_true_false_quiz_leaderboard` (
  `id` int UNSIGNED NOT NULL,
  `user_id` int NOT NULL,
  `category_id` int NOT NULL,
  `skill_id` int NOT NULL,
  `classification_id` int NOT NULL,
  `level_id` int NOT NULL,
  `total_questions` int NOT NULL,
  `questions_attended` int NOT NULL,
  `correct_answers` int NOT NULL,
  `percentage` int NOT NULL,
  `winning_coin` int NOT NULL,
  `status` int NOT NULL COMMENT '0- Fail, 1- Pass',
  `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;

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

--
-- Table structure for table `tbl_true_false_quiz_question`
--

CREATE TABLE `tbl_true_false_quiz_question` (
  `id` int UNSIGNED NOT NULL,
  `category_id` int NOT NULL,
  `skill_id` int NOT NULL,
  `classification_id` int NOT NULL,
  `level_id` int NOT NULL,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `question` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `option_a` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `option_b` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `correct_answer` int NOT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` int NOT NULL DEFAULT '1' COMMENT '0- Hide, 1- Show',
  `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;

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

--
-- Table structure for table `tbl_ultimate_challenge`
--

CREATE TABLE `tbl_ultimate_challenge` (
  `id` int UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `start_date` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `end_date` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `total_questions` int NOT NULL,
  `quiz_duration` int NOT NULL COMMENT 'In Second',
  `is_paid` int NOT NULL DEFAULT '0' COMMENT '0- No, 1- Yes',
  `joining_coin` int NOT NULL DEFAULT '0',
  `min_winning_percentage` int NOT NULL DEFAULT '0',
  `winning_coin` int NOT NULL DEFAULT '0',
  `status` int NOT NULL COMMENT '0- Inactive, 1- Active',
  `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;

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

--
-- Table structure for table `tbl_ultimate_challenge_leaderboard`
--

CREATE TABLE `tbl_ultimate_challenge_leaderboard` (
  `id` int UNSIGNED NOT NULL,
  `user_id` int NOT NULL,
  `ultimate_challenge_id` int NOT NULL,
  `total_questions` int NOT NULL,
  `questions_attended` int NOT NULL,
  `correct_answers` int NOT NULL,
  `percentage` int NOT NULL,
  `winning_coin` int NOT NULL,
  `status` int NOT NULL COMMENT '0- Fail, 1- Pass',
  `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;

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

--
-- Table structure for table `tbl_ultimate_challenge_question`
--

CREATE TABLE `tbl_ultimate_challenge_question` (
  `id` int UNSIGNED NOT NULL,
  `ultimate_challenge_id` int NOT NULL,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `question` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `option_a` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `option_b` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `option_c` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `option_d` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `correct_answer` int NOT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` int NOT NULL DEFAULT '1' COMMENT '0- Hide, 1- Show',
  `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;

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

--
-- Table structure for table `tbl_user`
--

CREATE TABLE `tbl_user` (
  `id` int UNSIGNED NOT NULL,
  `user_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `full_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `country_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `mobile_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `country_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` int NOT NULL COMMENT '1- OTP, 2- Google, 3- Apple, 4- Normal	',
  `image_type` int NOT NULL COMMENT '1- File Upload, 2- Avatar',
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `bio` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `reference_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `wallet_coin` int NOT NULL DEFAULT '0',
  `device_type` int NOT NULL DEFAULT '0' COMMENT '1- Android, 2- iOS, 3- Web',
  `device_token` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `qr_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_account_verify` int NOT NULL DEFAULT '0' COMMENT '	0- No, 1- Yes',
  `status` int 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=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tbl_user_badge_list`
--

CREATE TABLE `tbl_user_badge_list` (
  `id` int UNSIGNED NOT NULL,
  `user_id` int NOT NULL,
  `badge_id` int NOT NULL,
  `coin` int NOT NULL,
  `status` int NOT 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;

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

--
-- Table structure for table `tbl_video_quiz_leaderboard`
--

CREATE TABLE `tbl_video_quiz_leaderboard` (
  `id` int UNSIGNED NOT NULL,
  `user_id` int NOT NULL,
  `category_id` int NOT NULL,
  `skill_id` int NOT NULL,
  `classification_id` int NOT NULL,
  `level_id` int NOT NULL,
  `total_questions` int NOT NULL,
  `questions_attended` int NOT NULL,
  `correct_answers` int NOT NULL,
  `percentage` int NOT NULL,
  `winning_coin` int NOT NULL,
  `status` int NOT NULL COMMENT '0- Fail, 1- Pass',
  `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;

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

--
-- Table structure for table `tbl_video_quiz_question`
--

CREATE TABLE `tbl_video_quiz_question` (
  `id` int UNSIGNED NOT NULL,
  `category_id` int NOT NULL,
  `skill_id` int NOT NULL,
  `classification_id` int NOT NULL,
  `level_id` int NOT NULL,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `video_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'server_video, external_url	',
  `video` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `question` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `option_a` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `option_b` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `option_c` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `option_d` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `correct_answer` int NOT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` int NOT NULL DEFAULT '1' COMMENT '0- Hide, 1- Show',
  `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;

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

--
-- Table structure for table `tbl_withdrawal_request`
--

CREATE TABLE `tbl_withdrawal_request` (
  `id` int UNSIGNED NOT NULL,
  `user_id` int NOT NULL,
  `coin` int NOT NULL,
  `total_amount` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `payment_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `payment_detail` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` int NOT NULL DEFAULT '0' COMMENT '0- Pending , 1- Completed',
  `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;

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `tbl_admin`
--
ALTER TABLE `tbl_admin`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `tbl_audio_quiz_leaderboard`
--
ALTER TABLE `tbl_audio_quiz_leaderboard`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_audio_quiz_question`
--
ALTER TABLE `tbl_audio_quiz_question`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_avatar`
--
ALTER TABLE `tbl_avatar`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_badge`
--
ALTER TABLE `tbl_badge`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `tbl_battles_question`
--
ALTER TABLE `tbl_battles_question`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_category`
--
ALTER TABLE `tbl_category`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_classification`
--
ALTER TABLE `tbl_classification`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_coin_share_list`
--
ALTER TABLE `tbl_coin_share_list`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_contest`
--
ALTER TABLE `tbl_contest`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_contest_leaderboard`
--
ALTER TABLE `tbl_contest_leaderboard`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_contest_question`
--
ALTER TABLE `tbl_contest_question`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_contest_transaction`
--
ALTER TABLE `tbl_contest_transaction`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_daily_quiz_leaderboard`
--
ALTER TABLE `tbl_daily_quiz_leaderboard`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_daily_quiz_question`
--
ALTER TABLE `tbl_daily_quiz_question`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_exam`
--
ALTER TABLE `tbl_exam`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_exam_leaderboard`
--
ALTER TABLE `tbl_exam_leaderboard`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_exam_question`
--
ALTER TABLE `tbl_exam_question`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_fear_factor_quiz_leaderboard`
--
ALTER TABLE `tbl_fear_factor_quiz_leaderboard`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_fear_factor_quiz_question`
--
ALTER TABLE `tbl_fear_factor_quiz_question`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_general_setting`
--
ALTER TABLE `tbl_general_setting`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=68;

--
-- AUTO_INCREMENT for table `tbl_group_battles`
--
ALTER TABLE `tbl_group_battles`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_group_battles_leaderboard`
--
ALTER TABLE `tbl_group_battles_leaderboard`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_level`
--
ALTER TABLE `tbl_level`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_normal_quiz_leaderboard`
--
ALTER TABLE `tbl_normal_quiz_leaderboard`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_normal_quiz_question`
--
ALTER TABLE `tbl_normal_quiz_question`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_notification`
--
ALTER TABLE `tbl_notification`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_onboarding_screen`
--
ALTER TABLE `tbl_onboarding_screen`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_one_vs_one_battles`
--
ALTER TABLE `tbl_one_vs_one_battles`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_package`
--
ALTER TABLE `tbl_package`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_page`
--
ALTER TABLE `tbl_page`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `tbl_payment_option`
--
ALTER TABLE `tbl_payment_option`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `tbl_pratice_quiz_leaderboard`
--
ALTER TABLE `tbl_pratice_quiz_leaderboard`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_pratice_quiz_question`
--
ALTER TABLE `tbl_pratice_quiz_question`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_product`
--
ALTER TABLE `tbl_product`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_product_transaction`
--
ALTER TABLE `tbl_product_transaction`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_quiz_configuration`
--
ALTER TABLE `tbl_quiz_configuration`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `tbl_read_notification`
--
ALTER TABLE `tbl_read_notification`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_refer_earn`
--
ALTER TABLE `tbl_refer_earn`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_reward_setting`
--
ALTER TABLE `tbl_reward_setting`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT for table `tbl_reward_transaction`
--
ALTER TABLE `tbl_reward_transaction`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_skill`
--
ALTER TABLE `tbl_skill`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_smtp_setting`
--
ALTER TABLE `tbl_smtp_setting`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `tbl_social_link`
--
ALTER TABLE `tbl_social_link`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_transaction`
--
ALTER TABLE `tbl_transaction`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_true_false_quiz_leaderboard`
--
ALTER TABLE `tbl_true_false_quiz_leaderboard`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_true_false_quiz_question`
--
ALTER TABLE `tbl_true_false_quiz_question`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_ultimate_challenge`
--
ALTER TABLE `tbl_ultimate_challenge`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_ultimate_challenge_leaderboard`
--
ALTER TABLE `tbl_ultimate_challenge_leaderboard`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_ultimate_challenge_question`
--
ALTER TABLE `tbl_ultimate_challenge_question`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_user`
--
ALTER TABLE `tbl_user`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_user_badge_list`
--
ALTER TABLE `tbl_user_badge_list`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_video_quiz_leaderboard`
--
ALTER TABLE `tbl_video_quiz_leaderboard`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_video_quiz_question`
--
ALTER TABLE `tbl_video_quiz_question`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_withdrawal_request`
--
ALTER TABLE `tbl_withdrawal_request`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
