-- phpMyAdmin SQL Dump
-- version 5.2.2
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Oct 15, 2025 at 10:51 PM
-- Server version: 10.11.14-MariaDB
-- PHP Version: 8.4.11

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: `whocares_bot`
--

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

--
-- Table structure for table `admins`
--

CREATE TABLE `admins` (
  `id` int(11) NOT NULL,
  `telegram_id` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `advanced_lobbies`
--

CREATE TABLE `advanced_lobbies` (
  `id` int(11) NOT NULL,
  `type` enum('public','private') NOT NULL DEFAULT 'public',
  `map_key` varchar(50) DEFAULT NULL,
  `status` enum('waiting','redirecting') DEFAULT 'waiting',
  `players` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT '[]' CHECK (json_valid(`players`)),
  `uc_cost` int(11) DEFAULT 0,
  `created_at` datetime DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `advanced_lobbies`
--

INSERT INTO `advanced_lobbies` (`id`, `type`, `map_key`, `status`, `players`, `uc_cost`, `created_at`) VALUES
(1, 'public', 'livik', 'waiting', '[]', 0, '2025-10-09 21:33:22'),
(2, 'private', 'miramar', 'waiting', '[]', 20, '2025-10-09 21:33:22');

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

--
-- Table structure for table `bot_groups`
--

CREATE TABLE `bot_groups` (
  `id` int(11) NOT NULL,
  `chat_id` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `active` tinyint(4) DEFAULT 1,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bot_groups`
--

INSERT INTO `bot_groups` (`id`, `chat_id`, `title`, `active`, `created_at`, `updated_at`) VALUES
(1, '-1003074039318', 'Lobby Test', 1, '2025-10-13 16:08:50', '2025-10-15 14:00:50'),
(3, '-1002595723563', 'TERMO FAMILY 🦅', 1, '2025-10-13 19:30:01', '2025-10-13 19:30:01'),
(4, '-1002789039624', 'TERMO SHOP | GP', 1, '2025-10-13 19:31:51', '2025-10-13 19:31:51'),
(5, '-1002920624820', 'تست ربات', 1, '2025-10-13 19:39:05', '2025-10-13 19:39:05'),
(7, '-1001839843460', 'پابجی | SOLTAN PUBLIC', 1, '2025-10-15 17:36:52', '2025-10-15 17:36:52');

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

--
-- Table structure for table `duels`
--

CREATE TABLE `duels` (
  `id` int(11) NOT NULL,
  `type` varchar(10) NOT NULL,
  `map` varchar(50) DEFAULT '',
  `players` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT '[]' CHECK (json_valid(`players`)),
  `join_limit` int(11) NOT NULL,
  `active` tinyint(1) DEFAULT 1,
  `created_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `duel_lobbies`
--

CREATE TABLE `duel_lobbies` (
  `id` int(11) NOT NULL,
  `player1_id` int(11) NOT NULL,
  `player2_id` int(11) DEFAULT NULL,
  `type` enum('public','private') DEFAULT 'public',
  `code` varchar(10) DEFAULT NULL,
  `status` enum('waiting','ready','active','finished') DEFAULT 'waiting',
  `turn` int(11) DEFAULT 1,
  `current_player_id` int(11) DEFAULT NULL,
  `selected_gun_id` int(11) DEFAULT NULL,
  `state` enum('select_gun','select_shots','attacking') DEFAULT 'select_gun',
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `force_join_channels`
--

CREATE TABLE `force_join_channels` (
  `id` int(11) NOT NULL,
  `channel_username` varchar(255) NOT NULL,
  `channel_title` varchar(255) NOT NULL,
  `active` tinyint(4) DEFAULT 1,
  `created_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `force_join_channels`
--

INSERT INTO `force_join_channels` (`id`, `channel_username`, `channel_title`, `active`, `created_at`) VALUES
(2, 'CCr_2015', 'چنل یک', 0, '2025-10-06 08:58:59'),
(3, 'Tx_2015', 'چنل دو', 0, '2025-10-06 11:14:58'),
(5, 'Tx_2015', 'چنل یک', 0, '2025-10-06 14:13:51'),
(6, 'termo_gp', 'ترمو', 0, '2025-10-11 16:28:43');

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

--
-- Table structure for table `game_lobbies`
--

CREATE TABLE `game_lobbies` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `type` enum('public','private') NOT NULL,
  `max_players` int(11) DEFAULT 100,
  `players` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`players`)),
  `status` enum('scheduled','started','finished','cancelled') DEFAULT 'scheduled',
  `active` tinyint(4) DEFAULT 1,
  `entry_fee` int(11) DEFAULT 0,
  `prize_pool` int(11) DEFAULT 0,
  `winner_id` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `started_at` datetime DEFAULT NULL,
  `finished_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `game_lobbies`
--

INSERT INTO `game_lobbies` (`id`, `name`, `type`, `max_players`, `players`, `status`, `active`, `entry_fee`, `prize_pool`, `winner_id`, `created_at`, `started_at`, `finished_at`) VALUES
(1, 'لابی عمومی', 'public', 100, NULL, 'started', 1, 0, 1000, NULL, '2025-10-08 09:24:37', NULL, NULL),
(2, 'لابی خصوصی', 'private', 100, NULL, 'cancelled', 1, 20, 2000, NULL, '2025-10-08 09:24:37', NULL, NULL);

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

--
-- Table structure for table `game_maps_pir`
--

CREATE TABLE `game_maps_pir` (
  `id` int(11) NOT NULL,
  `map_key` varchar(50) NOT NULL,
  `map_name` varchar(100) NOT NULL,
  `max_players` int(11) DEFAULT 10,
  `min_players` int(11) DEFAULT 2,
  `status` enum('waiting','started','finished') DEFAULT 'waiting',
  `players` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT '[]' CHECK (json_valid(`players`)),
  `current_round` int(11) DEFAULT 1,
  `attacked_players` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT '[]' CHECK (json_valid(`attacked_players`)),
  `created_at` datetime DEFAULT current_timestamp(),
  `started_at` datetime DEFAULT NULL,
  `finished_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `game_maps_pir`
--

INSERT INTO `game_maps_pir` (`id`, `map_key`, `map_name`, `max_players`, `min_players`, `status`, `players`, `current_round`, `attacked_players`, `created_at`, `started_at`, `finished_at`) VALUES
(1, 'erangel', 'ارانگل', 10, 4, 'started', '[]', 1, '[]', '2025-10-09 22:04:33', '2025-10-11 18:01:32', NULL),
(2, 'miramar', 'میرامار', 8, 3, 'waiting', '[\"10\",\"35\"]', 1, '[]', '2025-10-09 22:04:33', NULL, NULL),
(3, 'sanhok', 'سانهوک', 6, 2, 'waiting', '[]', 1, '[]', '2025-10-09 22:04:33', NULL, NULL),
(4, 'vikendi', 'ویکندی', 8, 3, 'waiting', '[]', 1, '[]', '2025-10-09 22:04:33', NULL, NULL),
(5, 'livik', 'لیویک', 4, 2, 'waiting', '[\"10\"]', 1, '[]', '2025-10-09 22:04:33', NULL, NULL);

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

--
-- Table structure for table `game_maps_pup`
--

CREATE TABLE `game_maps_pup` (
  `id` int(11) NOT NULL,
  `map_key` varchar(50) NOT NULL,
  `map_name` varchar(100) NOT NULL,
  `max_players` int(11) DEFAULT 10,
  `min_players` int(11) DEFAULT 2,
  `status` enum('waiting','started','finished') DEFAULT 'waiting',
  `players` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT '[]' CHECK (json_valid(`players`)),
  `current_round` int(11) DEFAULT 1,
  `attacked_players` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT '[]' CHECK (json_valid(`attacked_players`)),
  `created_at` datetime DEFAULT current_timestamp(),
  `started_at` datetime DEFAULT NULL,
  `finished_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `game_maps_pup`
--

INSERT INTO `game_maps_pup` (`id`, `map_key`, `map_name`, `max_players`, `min_players`, `status`, `players`, `current_round`, `attacked_players`, `created_at`, `started_at`, `finished_at`) VALUES
(1, 'erangel', 'ارانگل', 10, 2, 'finished', '[]', 1, '[]', '2025-10-09 22:04:33', NULL, NULL),
(2, 'miramar', 'میرامار', 8, 3, 'finished', '[]', 1, '[]', '2025-10-09 22:04:33', NULL, NULL),
(3, 'sanhok', 'سانهوک', 6, 2, 'finished', '[]', 1, '[]', '2025-10-09 22:04:33', NULL, NULL),
(4, 'vikendi', 'ویکندی', 8, 3, 'finished', '[]', 1, '[]', '2025-10-09 22:04:33', NULL, NULL),
(5, 'livik', 'لیویک', 4, 2, 'finished', '[]', 1, '[]', '2025-10-09 22:04:33', NULL, NULL);

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

--
-- Table structure for table `group_lobbies`
--

CREATE TABLE `group_lobbies` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `max_players` int(11) DEFAULT 50,
  `players` text DEFAULT NULL,
  `active` tinyint(1) DEFAULT 1,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `chat_id` varchar(255) NOT NULL DEFAULT '-1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `group_lobbies`
--

INSERT INTO `group_lobbies` (`id`, `name`, `max_players`, `players`, `active`, `created_at`, `chat_id`) VALUES
(5, 'لابی Lobby Test ', 999, '[\"1\",\"9\"]', 1, '2025-10-13 22:08:40', '-1003074039318'),
(6, 'لابی تست ربات ', 999, '{\"1\":\"10\"}', 1, '2025-10-14 06:33:58', '-1002920624820'),
(7, 'لابی TERMO SHOP | GP ', 999, '{\"3\":\"97\",\"5\":\"99\",\"6\":\"100\",\"8\":\"148\",\"11\":\"58\",\"12\":\"94\",\"13\":\"112\",\"15\":\"10\",\"16\":\"35\",\"19\":\"14\",\"20\":\"166\",\"22\":\"167\",\"23\":\"165\"}', 1, '2025-10-14 06:35:05', '-1002789039624'),
(8, 'لابی TERMO FAMILY 🦅 ', 999, '[\"9\"]', 1, '2025-10-14 09:03:37', '-1002595723563'),
(9, 'لابی پابجی | SOLTAN PUBLIC ', 999, '[]', 1, '2025-10-15 18:55:50', '-1001839843460');

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

--
-- Table structure for table `guns`
--

CREATE TABLE `guns` (
  `id` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `category` enum('SMG','Rifle','Pistol','Sniper','Melee') DEFAULT NULL,
  `damage` int(11) DEFAULT NULL,
  `price_uc` int(11) DEFAULT NULL,
  `level_req` int(11) DEFAULT NULL,
  `ammo_capacity` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `guns`
--

INSERT INTO `guns` (`id`, `name`, `category`, `damage`, `price_uc`, `level_req`, `ammo_capacity`) VALUES
(1, 'AKM', 'Rifle', 4, 300, 6, 30),
(22, 'M416', 'Rifle', 55, 400, 7, 30),
(23, 'P92', 'Pistol', 20, 50, 1, 20),
(24, 'PAN', 'Melee', 50, 100, 1, 1),
(25, 'KNIFE', 'Melee', 50, 100, 1, 1),
(26, 'M24', 'Sniper', 70, 800, 5, 5),
(27, 'awm', 'Sniper', 80, 900, 9, 5),
(28, 'فیست', 'Melee', 50, 100, 2, 5);

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

--
-- Table structure for table `inventories`
--

CREATE TABLE `inventories` (
  `id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `gun_id` int(11) DEFAULT NULL,
  `ammo` int(11) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `inventories`
--

INSERT INTO `inventories` (`id`, `user_id`, `gun_id`, `ammo`) VALUES
(11, 9, 1, 27),
(35, 9, 24, 33),
(36, 9, 25, 39),
(37, 147, 23, 7),
(38, 147, 24, 6),
(39, 147, 25, 9),
(40, 10, 22, 40),
(41, 10, 25, 10),
(42, 9, 28, 68),
(43, 165, 23, 9);

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

--
-- Table structure for table `leaderboards`
--

CREATE TABLE `leaderboards` (
  `id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `xp_week` int(11) DEFAULT 0,
  `xp_month` int(11) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `lobbies`
--

CREATE TABLE `lobbies` (
  `id` int(11) NOT NULL,
  `type` enum('public','private') DEFAULT NULL,
  `server` int(11) DEFAULT 1,
  `map` enum('Erangel','Livik','Miramar','Sanhok') DEFAULT NULL,
  `players` text DEFAULT NULL,
  `active` tinyint(4) DEFAULT 1,
  `join_limit` int(11) DEFAULT 100,
  `reward_bp` int(11) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `lobbies`
--

INSERT INTO `lobbies` (`id`, `type`, `server`, `map`, `players`, `active`, `join_limit`, `reward_bp`) VALUES
(8, 'public', 1, 'Erangel', '[\"2\"]', 1, 100, 0),
(9, 'private', 7, NULL, '[]', 1, 10, 0),
(10, 'private', 8, NULL, '[]', 1, 10, 0),
(11, 'private', 3, NULL, '[]', 1, 10, 0),
(12, 'private', 4, NULL, '[]', 0, 10, 0);

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

--
-- Table structure for table `lobbies_new`
--

CREATE TABLE `lobbies_new` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `type` enum('public','private') NOT NULL,
  `creator_id` int(11) NOT NULL,
  `map` varchar(100) DEFAULT NULL,
  `entry_fee` int(11) DEFAULT 0,
  `status` enum('waiting','started','finished') DEFAULT 'waiting',
  `players` text DEFAULT NULL,
  `current_round` int(11) DEFAULT 1,
  `created_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `lobbies_new`
--

INSERT INTO `lobbies_new` (`id`, `name`, `type`, `creator_id`, `map`, `entry_fee`, `status`, `players`, `current_round`, `created_at`) VALUES
(1, 'Erangel - 17:48', 'private', 1, '4', 2, 'waiting', '[{\"user_id\":\"2\",\"hp\":100,\"map\":null,\"attacked\":false,\"alive\":true},{\"user_id\":\"1\",\"hp\":100,\"map\":null,\"attacked\":false,\"alive\":true}]', 1, '2025-10-09 14:18:50');

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

--
-- Table structure for table `lobby_players`
--

CREATE TABLE `lobby_players` (
  `id` int(11) NOT NULL,
  `user_id` bigint(20) NOT NULL,
  `lobby_type` enum('public','private') NOT NULL,
  `alive` tinyint(1) DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `lobby_settings`
--

CREATE TABLE `lobby_settings` (
  `id` int(11) NOT NULL DEFAULT 1,
  `lobby_creation_enabled` tinyint(4) DEFAULT 1,
  `lobby_start_enabled` tinyint(4) DEFAULT 1,
  `auto_start_players` int(11) DEFAULT 4,
  `max_players_per_lobby` int(11) DEFAULT 10,
  `round_duration` int(11) DEFAULT 60,
  `prize_uc` int(11) DEFAULT 10,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `lobby_settings`
--

INSERT INTO `lobby_settings` (`id`, `lobby_creation_enabled`, `lobby_start_enabled`, `auto_start_players`, `max_players_per_lobby`, `round_duration`, `prize_uc`, `created_at`, `updated_at`) VALUES
(1, 0, 0, 2, 10, 60, 10, '2025-10-09 16:11:51', '2025-10-09 16:36:22');

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

--
-- Table structure for table `maps`
--

CREATE TABLE `maps` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `description` text DEFAULT NULL,
  `image_url` varchar(255) DEFAULT NULL,
  `active` tinyint(1) DEFAULT 1,
  `created_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `maps`
--

INSERT INTO `maps` (`id`, `name`, `description`, `image_url`, `active`, `created_at`) VALUES
(1, 'Erangel', 'جزیره اصلی با زمین‌های باز و جنگل‌های متراکم', NULL, 1, '2025-10-08 18:34:49'),
(2, 'Miramar', 'بیابان وسیع با شهرهای متروکه', NULL, 1, '2025-10-08 18:34:49'),
(3, 'Sanhok', 'جنگل بارانی متراکم با آب و هوای مرطوب', NULL, 1, '2025-10-08 18:34:49'),
(4, 'Vikendi', 'سرزمین برفی با روستاهای کوهستانی', NULL, 1, '2025-10-08 18:34:49'),
(5, 'Livik', 'نقشه کوچک با اکشن سریع', NULL, 1, '2025-10-08 18:34:49'),
(6, 'Karakin', 'جزیره خشک با تونل‌های زیرزمینی', NULL, 1, '2025-10-08 18:34:49'),
(7, 'Deston', 'نقشه مدرن با آسمان‌خراش‌ها', NULL, 1, '2025-10-08 18:34:49');

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

--
-- Table structure for table `medical_items`
--

CREATE TABLE `medical_items` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `hp_restore` int(11) NOT NULL,
  `price_bp` int(11) NOT NULL,
  `level_required` int(11) DEFAULT 1,
  `active` tinyint(1) DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `medical_items`
--

INSERT INTO `medical_items` (`id`, `name`, `hp_restore`, `price_bp`, `level_required`, `active`) VALUES
(1, 'مدیکال کوچک', 25, 100, 1, 0),
(2, 'مدیکال متوسط', 50, 200, 3, 0),
(3, 'مدیکال بزرگ', 100, 350, 5, 0),
(4, '🍾', 25, 100, 1, 0),
(5, 'انرژی درینک', 25, 100, 1, 1),
(6, 'آدرنالین', 100, 200, 1, 0),
(7, 'مد کیت', 100, 400, 4, 1),
(8, 'فرست‌کیت', 75, 150, 3, 1),
(9, 'آدرنالین', 10, 50, 2, 0),
(10, 'بانداژ', 10, 50, 2, 1);

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

--
-- Table structure for table `one_vs_one_lobbies`
--

CREATE TABLE `one_vs_one_lobbies` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `creator_id` int(11) DEFAULT NULL,
  `max_players` int(11) DEFAULT 2,
  `players` text DEFAULT NULL,
  `active` tinyint(4) DEFAULT 1,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `last_attacker` int(11) DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `payment_wallets`
--

CREATE TABLE `payment_wallets` (
  `id` int(11) NOT NULL,
  `currency` enum('USDT','TRX','TON') NOT NULL,
  `network` varchar(50) NOT NULL,
  `wallet_address` varchar(255) NOT NULL,
  `active` tinyint(4) DEFAULT 1,
  `created_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `private_lobbies`
--

CREATE TABLE `private_lobbies` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `max_players` int(11) DEFAULT 50,
  `map_id` int(11) DEFAULT NULL,
  `players` text DEFAULT NULL,
  `active` tinyint(4) DEFAULT 1,
  `status` enum('waiting','started','finished') DEFAULT 'waiting',
  `winner_id` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `started_at` datetime DEFAULT NULL,
  `finished_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `private_lobbies`
--

INSERT INTO `private_lobbies` (`id`, `name`, `max_players`, `map_id`, `players`, `active`, `status`, `winner_id`, `created_at`, `started_at`, `finished_at`) VALUES
(1, 'Private', 999, 5, '{\"0\":\"2\",\"2\":\"6\",\"3\":\"1\"}', 1, 'started', NULL, NULL, '2025-10-08 22:15:10', NULL);

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

--
-- Table structure for table `public_lobbies`
--

CREATE TABLE `public_lobbies` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `max_players` int(11) DEFAULT 50,
  `map_id` int(11) DEFAULT NULL,
  `players` text DEFAULT NULL,
  `active` tinyint(4) DEFAULT 1,
  `status` enum('waiting','started','finished') DEFAULT 'waiting',
  `winner_id` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `started_at` datetime DEFAULT NULL,
  `finished_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `public_lobbies`
--

INSERT INTO `public_lobbies` (`id`, `name`, `max_players`, `map_id`, `players`, `active`, `status`, `winner_id`, `created_at`, `started_at`, `finished_at`) VALUES
(1, 'Public ', 999, 7, '{\"1\":\"2\",\"2\":\"1\"}', 1, 'waiting', NULL, NULL, NULL, NULL);

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

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` int(11) NOT NULL,
  `setting_key` varchar(255) NOT NULL,
  `setting_value` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` (`id`, `setting_key`, `setting_value`, `created_at`, `updated_at`) VALUES
(1, 'group_lobby_chat_id', '-1002595723563', '2025-10-03 16:44:39', '2025-10-13 10:13:28'),
(4, 'advanced_lobby_prize', '10', '2025-10-09 15:01:06', '2025-10-09 15:01:06');

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

--
-- Table structure for table `shields`
--

CREATE TABLE `shields` (
  `level` int(11) NOT NULL,
  `protection` int(11) DEFAULT NULL,
  `price_bp` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `shields`
--

INSERT INTO `shields` (`level`, `protection`, `price_bp`) VALUES
(1, 20, 506),
(2, 40, 200),
(3, 60, 300);

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

--
-- Table structure for table `shop_products`
--

CREATE TABLE `shop_products` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `type` enum('uc','bp','package') NOT NULL,
  `amount` int(11) NOT NULL,
  `price_usd` decimal(10,2) NOT NULL,
  `active` tinyint(4) DEFAULT 1,
  `created_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `shop_products`
--

INSERT INTO `shop_products` (`id`, `name`, `description`, `type`, `amount`, `price_usd`, `active`, `created_at`) VALUES
(1, '100 UC', 'خرید 100 یونیت کوین', 'uc', 100, 1.00, 1, '2025-10-13 22:24:29'),
(2, '500 UC', 'خرید 500 یونیت کوین', 'uc', 500, 4.50, 1, '2025-10-13 22:24:29'),
(3, '1000 UC', 'خرید 1000 یونیت کوین', 'uc', 1000, 8.00, 1, '2025-10-13 22:24:29'),
(4, '5000 BP', 'خرید 5000 امتیاز بازی', 'bp', 5000, 1.00, 1, '2025-10-13 22:24:29'),
(5, '25000 BP', 'خرید 25000 امتیاز بازی', 'bp', 25000, 4.50, 1, '2025-10-13 22:24:29'),
(6, '50000 BP', 'خرید 50000 امتیاز بازی', 'bp', 50000, 8.00, 1, '2025-10-13 22:24:29'),
(7, 'پکیج طلایی', '1000 UC + 10000 BP', 'package', 1, 15.00, 1, '2025-10-13 22:24:29');

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

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

CREATE TABLE `transactions` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `currency` enum('USDT','TRX','TON') NOT NULL,
  `wallet_address` varchar(255) NOT NULL,
  `tx_hash` varchar(255) DEFAULT NULL,
  `status` enum('pending','completed','failed','cancelled') DEFAULT 'pending',
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `completed_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `transactions`
--

INSERT INTO `transactions` (`id`, `user_id`, `product_id`, `amount`, `currency`, `wallet_address`, `tx_hash`, `status`, `created_at`, `completed_at`) VALUES
(1, 1, 1, 1.00, 'USDT', 'UQDJp0hxMhQm33XoHKcIT0JaM3wxBM-bcsJPjx0u5ZaAD_sX', NULL, 'pending', '2025-10-13 22:43:59', NULL);

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

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

CREATE TABLE `users` (
  `id` int(11) NOT NULL,
  `telegram_id` bigint(20) DEFAULT NULL,
  `username` varchar(255) DEFAULT NULL,
  `hp` int(11) DEFAULT 50,
  `bp` int(11) DEFAULT 0,
  `uc` int(11) DEFAULT 0,
  `level` int(11) DEFAULT 1,
  `xp` int(11) DEFAULT 0,
  `shield_level` int(11) DEFAULT 0,
  `vest_level` int(11) DEFAULT 0,
  `mine_level` int(11) DEFAULT 1,
  `last_mine` timestamp NULL DEFAULT current_timestamp(),
  `banned` tinyint(4) DEFAULT 0,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `state` varchar(255) DEFAULT '',
  `last_wheel` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `users` (`id`, `telegram_id`, `username`, `hp`, `bp`, `uc`, `level`, `xp`, `shield_level`, `vest_level`, `mine_level`, `last_mine`, `banned`, `created_at`, `state`, `last_wheel`) VALUES
(1, 1987582138, 'i_it4', 25, 9228994, 99500, 5, 998331, 0, 0, 4, '2025-10-04 14:38:20', 0, '2025-10-02 16:48:32', '', '2025-10-13 16:02:30'),
(2, 5311183468, 'i_it5', 0, 643114, 9999899, 11, 9997301, 0, 0, 6, '2025-10-09 16:29:54', 0, '2025-10-02 17:02:36', '', '2025-10-05 06:19:25'),
(5, 5518631706, 'ErFaNo786o', 100, 9650, 10000, 10, 0, 0, 0, 1, '2025-10-06 14:16:23', 0, '2025-10-06 14:16:23', '', '1999-12-31 20:30:00'),
(6, 7306927315, 'TSSupport404', 0, 1418193, 999830, 1, 150, 0, 0, 1, '2025-10-07 09:42:01', 0, '2025-10-07 09:42:01', '', '1999-12-31 20:30:00'),
(7, 797068506, 'roghayesab', 100, 999950, 999890, 1, 0, 0, 0, 1, '2025-10-08 08:18:49', 0, '2025-10-08 08:18:49', '', '1999-12-31 20:30:00'),
(8, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-08 13:32:18', 0, '2025-10-08 13:32:18', '', '1999-12-31 20:30:00'),
(9, 6392367939, 'SOLTANIG', 0, 905145, 990029, 11, 8452, 0, 0, 8, '2025-10-13 11:30:53', 0, '2025-10-11 15:44:59', '', '2025-10-13 11:31:39'),
(10, 744780738, 'Termo_yt', 100, 10000, 10000, 10, 2900, 3, 3, 44, '2025-10-15 14:20:20', 0, '2025-10-11 15:52:18', '', '2025-10-14 19:53:48'),
(11, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-11 15:58:37', 0, '2025-10-11 15:58:37', '', '1999-12-31 20:30:00'),
(12, 7803508899, 'termo_rent', 0, 6000, 500, 4, 0, 0, 0, 1, '2025-10-13 10:22:46', 0, '2025-10-11 15:58:46', '', '2025-10-13 10:21:55'),
(13, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-11 15:59:48', 0, '2025-10-11 15:59:48', '', '1999-12-31 20:30:00'),
(14, 7063335885, 'TERMO_ADMIN1', 0, 10000, 8500, 10, 10000, 0, 0, 6, '2025-10-15 14:42:28', 0, '2025-10-11 16:00:19', '', '2025-10-15 14:42:51'),
(15, 7388491563, 'Amir0reza000', 100, 200, 0, 1, 0, 0, 0, 1, '2025-10-11 16:00:24', 0, '2025-10-11 16:00:24', '', '2025-10-11 16:00:39'),
(16, 7342586037, 'UserTyrant', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-11 16:00:24', 0, '2025-10-11 16:00:24', '', '1999-12-31 20:30:00'),
(17, 6261209888, 'Mehrab6678', 0, 0, 0, 1, 0, 0, 0, 1, '2025-10-11 16:00:53', 0, '2025-10-11 16:00:53', '', '1999-12-31 20:30:00'),
(18, 7100693182, 'real17tsunami', 100, 10, 10, 1, 0, 0, 0, 1, '2025-10-13 11:51:56', 0, '2025-10-11 16:01:29', '', '2025-10-13 11:52:26'),
(19, 1478675498, 'Moein_135', 0, 1453, 300, 1, 0, 0, 0, 4, '2025-10-14 20:28:37', 0, '2025-10-11 16:01:40', '', '2025-10-14 20:31:15'),
(20, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-11 16:02:28', 0, '2025-10-11 16:02:28', '', '1999-12-31 20:30:00'),
(21, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-11 16:02:35', 0, '2025-10-11 16:02:35', '', '1999-12-31 20:30:00'),
(22, 8157023950, 'Amir85mi', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-11 16:02:36', 0, '2025-10-11 16:02:36', '', '1999-12-31 20:30:00'),
(23, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-11 16:04:47', 0, '2025-10-11 16:04:47', '', '1999-12-31 20:30:00'),
(24, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-11 16:05:15', 0, '2025-10-11 16:05:15', '', '1999-12-31 20:30:00'),
(25, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-11 16:05:53', 0, '2025-10-11 16:05:53', '', '1999-12-31 20:30:00'),
(26, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-11 16:05:56', 0, '2025-10-11 16:05:56', '', '1999-12-31 20:30:00'),
(27, 1745872659, 'Npo_186', 100, 175, 0, 1, 0, 0, 0, 1, '2025-10-15 14:17:40', 0, '2025-10-11 16:08:25', '', '2025-10-15 14:17:32'),
(28, 7157976553, 'PK_NINJA', 0, 0, 0, 1, 0, 0, 0, 1, '2025-10-11 16:11:04', 0, '2025-10-11 16:11:04', '', '1999-12-31 20:30:00'),
(29, 7316646541, 'NotEdalate', 100, 210, 0, 1, 0, 0, 0, 1, '2025-10-14 13:15:07', 0, '2025-10-11 16:11:13', '', '2025-10-11 16:11:31'),
(30, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-11 16:12:27', 0, '2025-10-11 16:12:27', '', '1999-12-31 20:30:00'),
(31, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-11 16:16:02', 0, '2025-10-11 16:16:02', '', '1999-12-31 20:30:00'),
(32, 6662954966, 'Xo_vpn3', 0, 10000, 10000, 1, 0, 0, 0, 1, '2025-10-11 16:16:06', 0, '2025-10-11 16:16:06', '', '2025-10-11 16:16:51'),
(33, 6517666051, 'Moslem_Taheri65', 0, 4782, 5000, 1, 0, 0, 0, 1, '2025-10-11 16:17:11', 0, '2025-10-11 16:17:11', '', '1999-12-31 20:30:00'),
(34, 6856651915, 'Kian_Black', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-11 16:18:00', 0, '2025-10-11 16:18:00', '', '1999-12-31 20:30:00'),
(35, 7903361502, 'Khodampq', 0, 1000, 0, 1, 0, 0, 0, 1, '2025-10-11 16:19:09', 0, '2025-10-11 16:19:09', '', '2025-10-11 16:20:21'),
(36, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-11 16:22:32', 0, '2025-10-11 16:22:32', '', '1999-12-31 20:30:00'),
(37, 7596593049, 'ARTinNpq', 100, 1000, 1000, 1, 0, 0, 0, 1, '2025-10-11 16:23:51', 0, '2025-10-11 16:23:51', '', '1999-12-31 20:30:00'),
(38, 7181142453, 'matin_sh_k', 100, 260, 0, 1, 0, 0, 0, 1, '2025-10-13 10:16:38', 0, '2025-10-11 16:30:03', '', '2025-10-13 10:16:42'),
(39, 8327136938, 'jafary_9', 0, 1000, 1000, 1, 0, 0, 0, 1, '2025-10-14 20:27:57', 0, '2025-10-11 16:32:09', '', '1999-12-31 20:30:00'),
(40, 6870820939, 'Unknown', 100, 0, 10, 1, 0, 0, 0, 1, '2025-10-11 16:36:44', 0, '2025-10-11 16:36:44', '', '2025-10-11 16:37:15'),
(41, 6589185227, 'PK_KARBON', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-11 16:37:23', 0, '2025-10-11 16:37:23', '', '1999-12-31 20:30:00'),
(42, 6965884349, 'Mani8914', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-11 16:38:15', 0, '2025-10-11 16:38:15', '', '1999-12-31 20:30:00'),
(43, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-11 16:40:28', 0, '2025-10-11 16:40:28', '', '1999-12-31 20:30:00'),
(44, 7965434105, 'sayeh69tv', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-11 16:42:56', 0, '2025-10-11 16:42:56', '', '1999-12-31 20:30:00'),
(45, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-11 16:44:27', 0, '2025-10-11 16:44:27', '', '1999-12-31 20:30:00'),
(46, 5134216040, 'WoundedSoldier', 0, 0, 0, 1, 0, 0, 0, 1, '2025-10-11 16:45:31', 0, '2025-10-11 16:45:31', '', '2025-10-11 16:47:54'),
(47, 7765649182, 'SIKHLENG', 100, 50, 0, 1, 0, 0, 0, 1, '2025-10-11 17:07:33', 0, '2025-10-11 17:07:33', '', '2025-10-11 17:08:01'),
(48, 8038940597, 'Eblisorg', 100, 10350, 900, 5, 0, 0, 0, 14, '2025-10-12 13:31:32', 0, '2025-10-11 17:16:27', '', '2025-10-11 17:53:46'),
(49, 950604032, 'Ilia_fat_hunt', 0, 0, 20, 1, 0, 0, 0, 1, '2025-10-11 18:01:28', 0, '2025-10-11 18:01:28', '', '2025-10-13 11:48:20'),
(50, 6899926883, 'DANIYALM11', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-11 18:29:00', 0, '2025-10-11 18:29:00', '', '1999-12-31 20:30:00'),
(51, 5892282526, 'Machro_gaming', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-11 18:38:06', 0, '2025-10-11 18:38:06', '', '1999-12-31 20:30:00'),
(52, 6588770846, 'vwSHAHINwv', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-11 18:39:06', 0, '2025-10-11 18:39:06', '', '1999-12-31 20:30:00'),
(53, 7123606909, 'Zx07cvo', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-11 18:42:46', 0, '2025-10-11 18:42:46', '', '1999-12-31 20:30:00'),
(54, 7877635509, 'EGO_diyako', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-11 18:58:21', 0, '2025-10-11 18:58:21', '', '2025-10-11 19:07:19'),
(55, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-11 19:15:34', 0, '2025-10-11 19:15:34', '', '1999-12-31 20:30:00'),
(56, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-11 19:15:40', 0, '2025-10-11 19:15:40', '', '1999-12-31 20:30:00'),
(57, 6992626245, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-11 19:16:06', 0, '2025-10-11 19:16:06', '', '1999-12-31 20:30:00'),
(58, 554378438, 'amir_ghoreyshi02', 0, 44, 0, 1, 0, 0, 0, 1, '2025-10-11 19:16:35', 0, '2025-10-11 19:16:35', '', '2025-10-11 19:17:08'),
(59, 6613330861, 'Dutch_am', 100, 200, 0, 1, 0, 0, 0, 1, '2025-10-11 20:15:25', 0, '2025-10-11 20:15:25', '', '2025-10-11 20:20:09'),
(60, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-11 21:17:28', 0, '2025-10-11 21:17:28', '', '1999-12-31 20:30:00'),
(61, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-13 10:04:11', 0, '2025-10-13 10:04:11', '', '1999-12-31 20:30:00'),
(62, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-13 10:14:19', 0, '2025-10-13 10:14:19', '', '1999-12-31 20:30:00'),
(63, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-13 10:16:49', 0, '2025-10-13 10:16:49', '', '1999-12-31 20:30:00'),
(64, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-13 10:19:24', 0, '2025-10-13 10:19:24', '', '1999-12-31 20:30:00'),
(65, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-13 10:28:09', 0, '2025-10-13 10:28:09', '', '1999-12-31 20:30:00'),
(66, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-13 11:13:04', 0, '2025-10-13 11:13:04', '', '1999-12-31 20:30:00'),
(67, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-13 11:26:27', 0, '2025-10-13 11:26:27', '', '1999-12-31 20:30:00'),
(68, 5902022442, 'TAA_Amirkhah_NG', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-13 12:51:50', 0, '2025-10-13 12:51:50', '', '1999-12-31 20:30:00'),
(69, 2090953725, 'Amir17ali0', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-13 12:57:24', 0, '2025-10-13 12:57:24', '', '1999-12-31 20:30:00'),
(70, 630506339, 'Aliii1080', 20, 0, 10, 1, 0, 0, 0, 1, '2025-10-13 14:10:07', 0, '2025-10-13 14:10:07', '', '2025-10-13 14:10:52'),
(71, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-13 14:12:18', 0, '2025-10-13 14:12:18', '', '1999-12-31 20:30:00'),
(72, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-13 14:19:45', 0, '2025-10-13 14:19:45', '', '1999-12-31 20:30:00'),
(73, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-13 14:58:17', 0, '2025-10-13 14:58:17', '', '1999-12-31 20:30:00'),
(74, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-13 15:04:24', 0, '2025-10-13 15:04:24', '', '1999-12-31 20:30:00'),
(75, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-13 16:57:16', 0, '2025-10-13 16:57:16', '', '1999-12-31 20:30:00'),
(76, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-13 17:01:21', 0, '2025-10-13 17:01:21', '', '1999-12-31 20:30:00'),
(77, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-13 17:01:49', 0, '2025-10-13 17:01:49', '', '1999-12-31 20:30:00'),
(78, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-13 17:02:41', 0, '2025-10-13 17:02:41', '', '1999-12-31 20:30:00'),
(79, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-13 17:06:31', 0, '2025-10-13 17:06:31', '', '1999-12-31 20:30:00'),
(80, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-13 17:08:13', 0, '2025-10-13 17:08:13', '', '1999-12-31 20:30:00'),
(81, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-13 17:28:09', 0, '2025-10-13 17:28:09', '', '1999-12-31 20:30:00'),
(82, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-13 18:14:46', 0, '2025-10-13 18:14:46', '', '1999-12-31 20:30:00'),
(83, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-13 18:41:19', 0, '2025-10-13 18:41:19', '', '1999-12-31 20:30:00'),
(84, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-13 19:03:35', 0, '2025-10-13 19:03:35', '', '1999-12-31 20:30:00'),
(85, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-13 19:27:54', 0, '2025-10-13 19:27:54', '', '1999-12-31 20:30:00'),
(86, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-13 19:31:43', 0, '2025-10-13 19:31:43', '', '1999-12-31 20:30:00'),
(87, 5046869970, 'beziyam', 0, 110, 0, 1, 0, 0, 0, 1, '2025-10-14 10:01:42', 0, '2025-10-13 19:43:05', '', '2025-10-14 10:01:47'),
(88, 6977942794, 'Soperpolice', 100, 50, 0, 1, 0, 0, 0, 1, '2025-10-13 20:41:40', 0, '2025-10-13 20:41:40', '', '2025-10-13 20:48:19'),
(89, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-13 21:05:58', 0, '2025-10-13 21:05:58', '', '1999-12-31 20:30:00'),
(90, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-13 21:13:28', 0, '2025-10-13 21:13:28', '', '1999-12-31 20:30:00'),
(91, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-13 23:01:38', 0, '2025-10-13 23:01:38', '', '1999-12-31 20:30:00'),
(92, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-14 03:27:25', 0, '2025-10-14 03:27:25', '', '1999-12-31 20:30:00'),
(93, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-14 03:45:51', 0, '2025-10-14 03:45:51', '', '1999-12-31 20:30:00'),
(94, 7402371518, 'Tx61_TERMO', 0, 0, 0, 1, 0, 0, 0, 1, '2025-10-14 06:35:22', 0, '2025-10-14 06:35:22', '', '1999-12-31 20:30:00'),
(95, 8416866278, 'Unknown', 0, 93, 0, 1, 0, 0, 0, 1, '2025-10-14 06:44:13', 0, '2025-10-14 06:44:13', '', '2025-10-14 09:24:38'),
(96, 7044623526, 'Big_mos2', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-14 07:23:46', 0, '2025-10-14 07:23:46', '', '1999-12-31 20:30:00'),
(97, 8009505436, 'Ali_user17', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-14 07:58:39', 0, '2025-10-14 07:58:39', '', '1999-12-31 20:30:00'),
(98, 7594702732, 'Rqibb', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-14 08:07:58', 0, '2025-10-14 08:07:58', '', '1999-12-31 20:30:00'),
(99, 1763628315, 'mrmahdi1385', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-14 08:58:02', 0, '2025-10-14 08:58:02', '', '1999-12-31 20:30:00'),
(100, 6615407439, 'EXOPARSA', 100, 71, 0, 1, 0, 0, 0, 1, '2025-10-15 14:17:45', 0, '2025-10-14 08:58:40', '', '2025-10-15 14:18:45'),
(101, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-14 09:37:09', 0, '2025-10-14 09:37:09', '', '1999-12-31 20:30:00'),
(102, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-14 09:52:18', 0, '2025-10-14 09:52:18', '', '1999-12-31 20:30:00'),
(103, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-14 09:57:41', 0, '2025-10-14 09:57:41', '', '1999-12-31 20:30:00'),
(104, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-14 10:21:23', 0, '2025-10-14 10:21:23', '', '1999-12-31 20:30:00'),
(105, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-14 10:28:56', 0, '2025-10-14 10:28:56', '', '1999-12-31 20:30:00'),
(106, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-14 10:40:08', 0, '2025-10-14 10:40:08', '', '1999-12-31 20:30:00'),
(107, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-14 10:43:37', 0, '2025-10-14 10:43:37', '', '1999-12-31 20:30:00'),
(108, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-14 10:43:47', 0, '2025-10-14 10:43:47', '', '1999-12-31 20:30:00'),
(109, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-14 12:48:47', 0, '2025-10-14 12:48:47', '', '1999-12-31 20:30:00'),
(110, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-14 13:02:47', 0, '2025-10-14 13:02:47', '', '1999-12-31 20:30:00'),
(111, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-14 13:40:52', 0, '2025-10-14 13:40:52', '', '1999-12-31 20:30:00'),
(112, 6476251463, 'Ms_close18', 100, 200, 0, 1, 0, 0, 0, 1, '2025-10-14 13:46:11', 0, '2025-10-14 13:46:11', '', '2025-10-15 13:05:43'),
(113, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-14 14:03:08', 0, '2025-10-14 14:03:08', '', '1999-12-31 20:30:00'),
(114, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-14 14:37:33', 0, '2025-10-14 14:37:33', '', '1999-12-31 20:30:00'),
(115, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-14 15:03:21', 0, '2025-10-14 15:03:21', '', '1999-12-31 20:30:00'),
(116, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-14 15:03:30', 0, '2025-10-14 15:03:30', '', '1999-12-31 20:30:00'),
(117, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-14 16:20:52', 0, '2025-10-14 16:20:52', '', '1999-12-31 20:30:00'),
(118, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-14 16:25:38', 0, '2025-10-14 16:25:38', '', '1999-12-31 20:30:00'),
(119, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-14 16:27:22', 0, '2025-10-14 16:27:22', '', '1999-12-31 20:30:00'),
(120, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-14 16:30:39', 0, '2025-10-14 16:30:39', '', '1999-12-31 20:30:00'),
(121, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-14 16:31:01', 0, '2025-10-14 16:31:01', '', '1999-12-31 20:30:00'),
(122, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-14 16:32:21', 0, '2025-10-14 16:32:21', '', '1999-12-31 20:30:00'),
(123, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-14 16:33:54', 0, '2025-10-14 16:33:54', '', '1999-12-31 20:30:00'),
(124, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-14 17:04:21', 0, '2025-10-14 17:04:21', '', '1999-12-31 20:30:00'),
(125, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-14 17:04:28', 0, '2025-10-14 17:04:28', '', '1999-12-31 20:30:00'),
(126, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-14 17:05:06', 0, '2025-10-14 17:05:06', '', '1999-12-31 20:30:00'),
(127, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-14 17:05:17', 0, '2025-10-14 17:05:17', '', '1999-12-31 20:30:00'),
(128, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-14 17:31:34', 0, '2025-10-14 17:31:34', '', '1999-12-31 20:30:00'),
(129, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-14 18:07:00', 0, '2025-10-14 18:07:00', '', '1999-12-31 20:30:00'),
(130, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-14 18:21:29', 0, '2025-10-14 18:21:29', '', '1999-12-31 20:30:00'),
(131, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-14 18:27:35', 0, '2025-10-14 18:27:35', '', '1999-12-31 20:30:00'),
(132, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-14 18:52:16', 0, '2025-10-14 18:52:16', '', '1999-12-31 20:30:00'),
(133, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-14 19:12:16', 0, '2025-10-14 19:12:16', '', '1999-12-31 20:30:00'),
(134, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-14 20:38:08', 0, '2025-10-14 20:38:08', '', '1999-12-31 20:30:00'),
(135, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-15 03:12:22', 0, '2025-10-15 03:12:22', '', '1999-12-31 20:30:00'),
(136, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-15 06:41:30', 0, '2025-10-15 06:41:30', '', '1999-12-31 20:30:00'),
(137, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-15 07:57:22', 0, '2025-10-15 07:57:22', '', '1999-12-31 20:30:00'),
(138, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-15 08:08:54', 0, '2025-10-15 08:08:54', '', '1999-12-31 20:30:00'),
(139, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-15 08:17:30', 0, '2025-10-15 08:17:30', '', '1999-12-31 20:30:00'),
(140, 5946730137, 'Opnvbn', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-15 08:35:38', 0, '2025-10-15 08:35:38', '', '1999-12-31 20:30:00'),
(141, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-15 08:58:27', 0, '2025-10-15 08:58:27', '', '1999-12-31 20:30:00'),
(142, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-15 09:11:59', 0, '2025-10-15 09:11:59', '', '1999-12-31 20:30:00'),
(143, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-15 11:52:37', 0, '2025-10-15 11:52:37', '', '1999-12-31 20:30:00'),
(144, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-15 11:52:50', 0, '2025-10-15 11:52:50', '', '1999-12-31 20:30:00'),
(145, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-15 12:29:49', 0, '2025-10-15 12:29:49', '', '1999-12-31 20:30:00'),
(146, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-15 12:31:39', 0, '2025-10-15 12:31:39', '', '1999-12-31 20:30:00'),
(147, 7051633417, 'ROX_yt_18', 0, 548, 750, 1, 0, 0, 0, 1, '2025-10-15 12:50:56', 0, '2025-10-15 12:50:56', '', '2025-10-15 13:09:55'),
(148, 5384048992, 'Unknown', 16, 0, 0, 1, 0, 0, 0, 1, '2025-10-15 12:51:31', 0, '2025-10-15 12:51:31', '', '1999-12-31 20:30:00'),
(149, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-15 12:55:33', 0, '2025-10-15 12:55:33', '', '1999-12-31 20:30:00'),
(150, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-15 13:02:15', 0, '2025-10-15 13:02:15', '', '1999-12-31 20:30:00'),
(151, 1390495287, 'BoOowl', 100, 100, 0, 1, 0, 0, 0, 1, '2025-10-15 13:06:11', 0, '2025-10-15 13:06:11', '', '2025-10-15 13:06:22'),
(152, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-15 13:06:37', 0, '2025-10-15 13:06:37', '', '1999-12-31 20:30:00'),
(153, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-15 13:08:58', 0, '2025-10-15 13:08:58', '', '1999-12-31 20:30:00'),
(154, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-15 13:49:58', 0, '2025-10-15 13:49:58', '', '1999-12-31 20:30:00'),
(155, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-15 13:52:48', 0, '2025-10-15 13:52:48', '', '1999-12-31 20:30:00'),
(156, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-15 13:53:20', 0, '2025-10-15 13:53:20', '', '1999-12-31 20:30:00'),
(157, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-15 14:05:33', 0, '2025-10-15 14:05:33', '', '1999-12-31 20:30:00'),
(158, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-15 14:12:42', 0, '2025-10-15 14:12:42', '', '1999-12-31 20:30:00'),
(159, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-15 15:28:46', 0, '2025-10-15 15:28:46', '', '1999-12-31 20:30:00'),
(160, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-15 15:38:20', 0, '2025-10-15 15:38:20', '', '1999-12-31 20:30:00'),
(161, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-15 15:42:41', 0, '2025-10-15 15:42:41', '', '1999-12-31 20:30:00'),
(162, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-15 15:43:04', 0, '2025-10-15 15:43:04', '', '1999-12-31 20:30:00'),
(163, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-15 15:43:40', 0, '2025-10-15 15:43:40', '', '1999-12-31 20:30:00'),
(164, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-15 16:05:40', 0, '2025-10-15 16:05:40', '', '1999-12-31 20:30:00'),
(165, 5934775321, 'Jooooooonnn1', 0, 86261, 4850, 1, 100, 0, 0, 2, '2025-10-15 16:30:50', 0, '2025-10-15 16:30:50', '', '2025-10-15 16:35:20'),
(166, 6282857935, 'nima_1854', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-15 16:39:01', 0, '2025-10-15 16:39:01', '', '1999-12-31 20:30:00'),
(167, 6508759852, 'KRONE12345', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-15 16:46:11', 0, '2025-10-15 16:46:11', '', '1999-12-31 20:30:00'),
(168, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-15 16:51:07', 0, '2025-10-15 16:51:07', '', '1999-12-31 20:30:00'),
(169, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-15 17:36:25', 0, '2025-10-15 17:36:25', '', '1999-12-31 20:30:00'),
(170, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-15 17:36:35', 0, '2025-10-15 17:36:35', '', '1999-12-31 20:30:00'),
(171, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-15 17:36:38', 0, '2025-10-15 17:36:38', '', '1999-12-31 20:30:00'),
(172, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-15 17:44:20', 0, '2025-10-15 17:44:20', '', '1999-12-31 20:30:00'),
(173, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-15 17:49:08', 0, '2025-10-15 17:49:08', '', '1999-12-31 20:30:00'),
(174, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-15 17:59:03', 0, '2025-10-15 17:59:03', '', '1999-12-31 20:30:00'),
(175, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-15 18:33:21', 0, '2025-10-15 18:33:21', '', '1999-12-31 20:30:00'),
(176, NULL, 'Unknown', 100, 0, 0, 1, 0, 0, 0, 1, '2025-10-15 18:33:26', 0, '2025-10-15 18:33:26', '', '1999-12-31 20:30:00');

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

--
-- Table structure for table `vests`
--

CREATE TABLE `vests` (
  `level` int(11) NOT NULL,
  `protection` int(11) DEFAULT NULL,
  `price_bp` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `vests`
--

INSERT INTO `vests` (`level`, `protection`, `price_bp`) VALUES
(1, 15, 400),
(2, 50, 250),
(3, 70, 350);

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

--
-- Table structure for table `wheel_prizes`
--

CREATE TABLE `wheel_prizes` (
  `id` int(11) NOT NULL,
  `prize` varchar(255) DEFAULT NULL,
  `chance` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wheel_prizes`
--

INSERT INTO `wheel_prizes` (`id`, `prize`, `chance`) VALUES
(4, '200 BP', 15),
(7, '50 BP', 10),
(9, '10 UC', 8),
(10, '20 UC', 5),
(11, '10 Ammo', 8),
(12, '20 Ammo', 3),
(14, '100 BP', 15);

--
-- Indexes for dumped tables
--

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

--
-- Indexes for table `advanced_lobbies`
--
ALTER TABLE `advanced_lobbies`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_map_key` (`map_key`),
  ADD KEY `idx_status` (`status`);

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

--
-- Indexes for table `duels`
--
ALTER TABLE `duels`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_duels_active` (`active`);

--
-- Indexes for table `duel_lobbies`
--
ALTER TABLE `duel_lobbies`
  ADD PRIMARY KEY (`id`),
  ADD KEY `player1_id` (`player1_id`),
  ADD KEY `player2_id` (`player2_id`),
  ADD KEY `selected_gun_id` (`selected_gun_id`),
  ADD KEY `idx_duel_lobbies_status` (`status`);

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

--
-- Indexes for table `game_lobbies`
--
ALTER TABLE `game_lobbies`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_type_active` (`type`,`active`);

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

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

--
-- Indexes for table `group_lobbies`
--
ALTER TABLE `group_lobbies`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_group_lobbies_active` (`active`),
  ADD KEY `idx_chat_id_active` (`chat_id`,`active`);

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

--
-- Indexes for table `inventories`
--
ALTER TABLE `inventories`
  ADD PRIMARY KEY (`id`),
  ADD KEY `gun_id` (`gun_id`),
  ADD KEY `idx_inventory_user` (`user_id`);

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

--
-- Indexes for table `lobbies`
--
ALTER TABLE `lobbies`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_lobbies_active` (`active`);

--
-- Indexes for table `lobbies_new`
--
ALTER TABLE `lobbies_new`
  ADD PRIMARY KEY (`id`),
  ADD KEY `creator_id` (`creator_id`);

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `shields`
--
ALTER TABLE `shields`
  ADD PRIMARY KEY (`level`);

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

--
-- Indexes for table `transactions`
--
ALTER TABLE `transactions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id` (`user_id`),
  ADD KEY `product_id` (`product_id`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `telegram_id` (`telegram_id`),
  ADD KEY `idx_users_telegram` (`telegram_id`),
  ADD KEY `idx_users_username` (`username`);

--
-- Indexes for table `vests`
--
ALTER TABLE `vests`
  ADD PRIMARY KEY (`level`);

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `duel_lobbies`
--
ALTER TABLE `duel_lobbies`
  ADD CONSTRAINT `duel_lobbies_ibfk_1` FOREIGN KEY (`player1_id`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `duel_lobbies_ibfk_2` FOREIGN KEY (`player2_id`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `duel_lobbies_ibfk_3` FOREIGN KEY (`selected_gun_id`) REFERENCES `guns` (`id`);

--
-- Constraints for table `inventories`
--
ALTER TABLE `inventories`
  ADD CONSTRAINT `inventories_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `inventories_ibfk_2` FOREIGN KEY (`gun_id`) REFERENCES `guns` (`id`);

--
-- Constraints for table `leaderboards`
--
ALTER TABLE `leaderboards`
  ADD CONSTRAINT `leaderboards_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);

--
-- Constraints for table `lobbies_new`
--
ALTER TABLE `lobbies_new`
  ADD CONSTRAINT `lobbies_new_ibfk_1` FOREIGN KEY (`creator_id`) REFERENCES `users` (`id`);

--
-- Constraints for table `transactions`
--
ALTER TABLE `transactions`
  ADD CONSTRAINT `transactions_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `transactions_ibfk_2` FOREIGN KEY (`product_id`) REFERENCES `shop_products` (`id`);
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 */;
