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

START TRANSACTION;



--
-- Database: `royalgames_sagar`
--

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

--
-- Table structure for table `accumulated_data`
--

CREATE TABLE `accumulated_data` (
  `id` int NOT NULL,
  `date` date NOT NULL,
  `children_Lv_1_Count` int DEFAULT '0',
  `children_Lv_Count_X` int DEFAULT '0',
  `children_Lv_1_RechargesSumCount` int DEFAULT '0',
  `children_Lv_RechargesSumCount` int DEFAULT '0',
  `children_Lv_1_RechargesSumAmount` float DEFAULT '0',
  `children_Lv_RebateAmount_Yesterday` float DEFAULT '0',
  `children_Lv_1_RebateAmount_Yesterday` float DEFAULT '0',
  `children_Lv_RebateAmount_Week` float DEFAULT '0',
  `children_Lv_1_RebateAmount_X_Yesterday` float DEFAULT '0',
  `children_Lv_RebateAmount` float DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `activity_game_list`
--

CREATE TABLE `activity_game_list` (
  `id` int NOT NULL,
  `banner_title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `banner_id` int NOT NULL,
  `banner_url` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `jump_type` int NOT NULL,
  `contents` text COLLATE utf8mb4_unicode_ci NOT 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 `activity_game_list`
--

INSERT INTO `activity_game_list` (`id`, `banner_title`, `banner_id`, `banner_url`, `jump_type`, `contents`, `created_at`, `updated_at`) VALUES
(1, 'First Deposit Bonus', 71, 'https://vgclub.fun/banners/8.png', 2, '/activity/FirstRecharge', '2025-04-06 06:19:56', '2025-04-06 06:19:56'),
(2, 'Invitation Bonus', 62, 'https://vgclub.fun/banners/7.png', 2, '/main/InvitationBonus', '2025-04-06 06:19:56', '2025-04-06 06:19:56'),
(3, 'Win Streak 2X Price Happy Hour', 53, 'https://vgclub.fun/banners/1.png', 1, '', '2025-04-06 06:19:56', '2025-04-06 06:19:56'),
(4, 'Lucky Spin To Win Iphone 16 Pro Max', 59, 'https://vgclub.fun/banners/4.png', 2, '/activity/Turntable', '2025-04-06 06:19:56', '2025-04-06 06:19:56'),
(5, 'Daily Bonus Until 1 CRORE', 69, 'https://vgclub.fun/banners/3.png', 1, '', '2025-04-06 06:19:56', '2025-04-06 06:19:56'),
(6, 'Monthly VIP Bonus', 46, 'https://vgclub.fun/banners/2.png', 2, '/vip', '2025-04-06 06:19:56', '2025-04-06 06:19:56'),
(7, 'VG CLUB Support Funds', 47, 'https://vgclub.fun/banners/5.png', 1, '', '2025-04-06 06:19:56', '2025-04-06 06:19:56');

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

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

CREATE TABLE `admins` (
  `id` int NOT NULL,
  `username` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `permissions` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL
) ;

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

--
-- Table structure for table `agent_bonus_table`
--

CREATE TABLE `agent_bonus_table` (
  `id` int NOT NULL,
  `userkani` int NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `serial` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT 'Imitator',
  `shonu` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `remark` text CHARACTER SET latin1 COLLATE latin1_swedish_ci,
  `processed` tinyint(1) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `agent_red_envelope_recharge_table`
--

CREATE TABLE `agent_red_envelope_recharge_table` (
  `id` int NOT NULL,
  `userkani` int NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `serial` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT 'Imitator',
  `shonu` datetime NOT NULL,
  `remark` text CHARACTER SET latin1 COLLATE latin1_swedish_ci,
  `processed` tinyint(1) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `allowed_domains`
--

CREATE TABLE `allowed_domains` (
  `id` int NOT NULL,
  `domain` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

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

--
-- Table structure for table `amanatugolisu`
--

CREATE TABLE `amanatugolisu` (
  `kramasankhye` int NOT NULL,
  `byabaharkarta` int NOT NULL,
  `kebetiari` varchar(200) NOT NULL,
  `sthiti` int NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `apitrend`
--

CREATE TABLE `apitrend` (
  `id` int NOT NULL,
  `username` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `api_urls`
--

CREATE TABLE `api_urls` (
  `id` int NOT NULL,
  `api_url` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `secret_key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` enum('Active','Inactive') COLLATE utf8mb4_unicode_ci DEFAULT 'Active',
  `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 `auth_settings`
--

CREATE TABLE `auth_settings` (
  `id` int NOT NULL,
  `setting_key` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `setting_value` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `setting_type` enum('boolean','string','number','json') COLLATE utf8mb4_unicode_ci NOT 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 `auth_settings`
--

INSERT INTO `auth_settings` (`id`, `setting_key`, `setting_value`, `setting_type`, `created_at`, `updated_at`) VALUES
(1, 'isOpenRegisterSMS', '0', 'string', '2025-04-06 06:21:02', '2025-04-06 06:21:02'),
(2, 'isOpenRegisterEmail', '1', 'string', '2025-04-06 06:21:02', '2025-04-06 06:21:02'),
(3, 'registerEmailState', '0', 'string', '2025-04-06 06:21:02', '2025-04-06 06:21:02'),
(4, 'registerMobileState', '1', 'string', '2025-04-06 06:21:02', '2025-04-06 06:21:02'),
(5, 'registerStateMsg', '', 'string', '2025-04-06 06:21:02', '2025-04-06 06:21:02'),
(6, 'isOpenForgetPasswordSMS', '1', 'string', '2025-04-06 06:21:02', '2025-04-06 06:21:02'),
(7, 'isOpenForgetPasswordEmail', '1', 'string', '2025-04-06 06:21:02', '2025-04-06 06:21:02'),
(8, 'isOpenAddWithdrawSMS', '0', 'string', '2025-04-06 06:21:02', '2025-04-06 06:21:02'),
(9, 'isOpenAddWithdrawEmail', '1', 'string', '2025-04-06 06:21:02', '2025-04-06 06:21:02'),
(10, 'isOpenCaptcha', '1', 'string', '2025-04-06 06:21:02', '2025-04-06 06:21:02'),
(11, 'isOpenRegisterCaptcha', '1', 'string', '2025-04-06 06:21:02', '2025-04-06 06:21:02'),
(12, 'isOpenGoogleVerifySms', '1', 'string', '2025-04-06 06:21:02', '2025-04-07 08:23:22'),
(13, 'isOpenGoogleVerifyEmail', '0', 'string', '2025-04-06 06:21:02', '2025-04-06 06:21:02'),
(14, 'addBankCardOpenEmail', '1', 'string', '2025-04-06 06:21:02', '2025-04-06 06:21:02'),
(15, 'isOpenExternalAccount', '0', 'string', '2025-04-06 06:21:02', '2025-04-06 06:21:02'),
(16, 'isInvitecode', '1', 'string', '2025-04-06 06:21:02', '2025-04-06 06:21:02');

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

--
-- Table structure for table `aviset`
--

CREATE TABLE `aviset` (
  `id` int NOT NULL,
  `nxt` float NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `award_records`
--

CREATE TABLE `award_records` (
  `order_id` int NOT NULL,
  `user_id` int DEFAULT NULL,
  `user_photo` varchar(10) DEFAULT NULL,
  `user_name` varchar(20) DEFAULT NULL,
  `game_name` varchar(100) DEFAULT NULL,
  `img_url` varchar(255) DEFAULT NULL,
  `img_url2` varchar(255) DEFAULT NULL,
  `multiple` decimal(5,2) DEFAULT NULL,
  `bonus_amount` decimal(10,2) DEFAULT NULL,
  `multiple_name` varchar(20) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `award_records`
--

INSERT INTO `award_records` (`order_id`, `user_id`, `user_photo`, `user_name`, `game_name`, `img_url`, `img_url2`, `multiple`, `bonus_amount`, `multiple_name`, `create_time`, `created_at`) VALUES
(44116, 1860921, '2', '918010413577', 'Mines', 'https://ossimg.dmwinimage.com/DmWin/gamelogo/TB_Chess/100.png', '', 18.59, 50.00, '10-19', '2025-04-01 11:24:00', '2025-04-06 06:49:09'),
(44117, 890237, '1', '919328088396', 'Money Coming', 'https://ossimg.dmwinimage.com/DmWin/gamelogo/JILI/51.png', '', 11.00, 50.00, '10-19', '2025-04-01 11:27:00', '2025-04-06 06:49:09'),
(44118, 890237, '1', '919328088396', 'Money Coming', 'https://ossimg.dmwinimage.com/DmWin/gamelogo/JILI/51.png', '', 20.00, 100.00, '20-29', '2025-04-01 11:27:00', '2025-04-06 06:49:09'),
(44119, 1860921, '2', '918010413577', 'Mines', 'https://ossimg.dmwinimage.com/DmWin/gamelogo/TB_Chess/100.png', '', 10.14, 50.00, '10-19', '2025-04-01 11:27:00', '2025-04-06 06:49:09'),
(44120, 201705, '6', '918767923866', 'Boom Legend', 'https://ossimg.dmwinimage.com/DmWin/gamelogo/JILI/71.png', '', 12.00, 50.00, '10-19', '2025-04-01 11:27:00', '2025-04-06 06:49:09'),
(44121, 201705, '6', '918767923866', 'Boom Legend', 'https://ossimg.dmwinimage.com/DmWin/gamelogo/JILI/71.png', '', 10.00, 50.00, '10-19', '2025-04-01 11:27:00', '2025-04-06 06:49:09'),
(44122, 1860921, '2', '918010413577', 'Mines', 'https://ossimg.dmwinimage.com/DmWin/gamelogo/TB_Chess/100.png', '', 10.14, 50.00, '10-19', '2025-04-01 11:27:00', '2025-04-06 06:49:09'),
(44123, 1344863, '1', '919351577430', 'Aviator', 'https://ossimg.dmwinimage.com/DmWin/gamelogo/TB_Chess/800_20241031144503660.png', '', 12.11, 50.00, '10-19', '2025-04-01 11:30:00', '2025-04-06 06:49:09'),
(44124, 1860921, '2', '918010413577', 'Mines', 'https://ossimg.dmwinimage.com/DmWin/gamelogo/TB_Chess/100.png', '', 10.14, 50.00, '10-19', '2025-04-01 11:33:00', '2025-04-06 06:49:09'),
(44125, 1344863, '1', '919351577430', 'Aviator', 'https://ossimg.dmwinimage.com/DmWin/gamelogo/TB_Chess/800_20241031144503660.png', '', 10.10, 50.00, '10-19', '2025-04-01 11:45:00', '2025-04-06 06:49:09');

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

--
-- Table structure for table `bajikattuttate`
--

CREATE TABLE `bajikattuttate` (
  `parichaya` int NOT NULL,
  `byabaharkarta` int NOT NULL,
  `kalaparichaya` varchar(255) NOT NULL,
  `prakar` varchar(100) NOT NULL,
  `ojana` varchar(100) NOT NULL,
  `menge` varchar(100) DEFAULT NULL,
  `wettanzahl` varchar(100) DEFAULT NULL,
  `ketebida` float NOT NULL,
  `phalaphala` varchar(255) NOT NULL DEFAULT 'perte',
  `sesabida` float NOT NULL,
  `ergebnis` int DEFAULT NULL,
  `zufallig` int DEFAULT NULL,
  `tiarikala` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `bajikattuttate_aidudi`
--

CREATE TABLE `bajikattuttate_aidudi` (
  `parichaya` int NOT NULL,
  `byabaharkarta` int NOT NULL,
  `kalaparichaya` varchar(255) NOT NULL,
  `prakar` varchar(100) NOT NULL,
  `ojana` varchar(100) NOT NULL,
  `menge` varchar(100) DEFAULT NULL,
  `wettanzahl` varchar(100) DEFAULT NULL,
  `ketebida` float NOT NULL,
  `phalaphala` varchar(255) NOT NULL DEFAULT 'perte',
  `sesabida` float NOT NULL,
  `ergebnis` int DEFAULT NULL,
  `zufallig` varchar(255) DEFAULT NULL,
  `tiarikala` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `bajikattuttate_aidudi_drei`
--

CREATE TABLE `bajikattuttate_aidudi_drei` (
  `parichaya` int NOT NULL,
  `byabaharkarta` int NOT NULL,
  `kalaparichaya` varchar(255) NOT NULL,
  `prakar` varchar(100) NOT NULL,
  `ojana` varchar(100) NOT NULL,
  `menge` varchar(100) DEFAULT NULL,
  `wettanzahl` varchar(100) DEFAULT NULL,
  `ketebida` float NOT NULL,
  `phalaphala` varchar(255) NOT NULL DEFAULT 'perte',
  `sesabida` float NOT NULL,
  `ergebnis` int DEFAULT NULL,
  `zufallig` varchar(255) DEFAULT NULL,
  `tiarikala` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `bajikattuttate_aidudi_funf`
--

CREATE TABLE `bajikattuttate_aidudi_funf` (
  `parichaya` int NOT NULL,
  `byabaharkarta` int NOT NULL,
  `kalaparichaya` varchar(255) NOT NULL,
  `prakar` varchar(100) NOT NULL,
  `ojana` varchar(100) NOT NULL,
  `menge` varchar(100) DEFAULT NULL,
  `wettanzahl` varchar(100) DEFAULT NULL,
  `ketebida` float NOT NULL,
  `phalaphala` varchar(255) NOT NULL DEFAULT 'perte',
  `sesabida` float NOT NULL,
  `ergebnis` int DEFAULT NULL,
  `zufallig` varchar(255) DEFAULT NULL,
  `tiarikala` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `bajikattuttate_aidudi_zehn`
--

CREATE TABLE `bajikattuttate_aidudi_zehn` (
  `parichaya` int NOT NULL,
  `byabaharkarta` int NOT NULL,
  `kalaparichaya` varchar(255) NOT NULL,
  `prakar` varchar(100) NOT NULL,
  `ojana` varchar(100) NOT NULL,
  `menge` varchar(100) DEFAULT NULL,
  `wettanzahl` varchar(100) DEFAULT NULL,
  `ketebida` float NOT NULL,
  `phalaphala` varchar(255) NOT NULL DEFAULT 'perte',
  `sesabida` float NOT NULL,
  `ergebnis` int DEFAULT NULL,
  `zufallig` varchar(255) DEFAULT NULL,
  `tiarikala` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `bajikattuttate_drei`
--

CREATE TABLE `bajikattuttate_drei` (
  `parichaya` int NOT NULL,
  `byabaharkarta` int NOT NULL,
  `kalaparichaya` varchar(255) NOT NULL,
  `prakar` varchar(100) NOT NULL,
  `ojana` varchar(100) NOT NULL,
  `menge` varchar(100) DEFAULT NULL,
  `wettanzahl` varchar(100) DEFAULT NULL,
  `ketebida` float NOT NULL,
  `phalaphala` varchar(255) NOT NULL DEFAULT 'perte',
  `sesabida` float NOT NULL,
  `ergebnis` int DEFAULT NULL,
  `zufallig` int DEFAULT NULL,
  `tiarikala` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `bajikattuttate_funf`
--

CREATE TABLE `bajikattuttate_funf` (
  `parichaya` int NOT NULL,
  `byabaharkarta` int NOT NULL,
  `kalaparichaya` varchar(255) NOT NULL,
  `prakar` varchar(100) NOT NULL,
  `ojana` varchar(100) NOT NULL,
  `menge` varchar(100) DEFAULT NULL,
  `wettanzahl` varchar(100) DEFAULT NULL,
  `ketebida` float NOT NULL,
  `phalaphala` varchar(255) NOT NULL DEFAULT 'perte',
  `sesabida` float NOT NULL,
  `ergebnis` int DEFAULT NULL,
  `zufallig` int DEFAULT NULL,
  `tiarikala` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `bajikattuttate_kemuru`
--

CREATE TABLE `bajikattuttate_kemuru` (
  `parichaya` int NOT NULL,
  `byabaharkarta` int NOT NULL,
  `kalaparichaya` varchar(255) NOT NULL,
  `prakar` varchar(100) NOT NULL,
  `ojana` varchar(100) NOT NULL,
  `menge` varchar(100) DEFAULT NULL,
  `wettanzahl` varchar(100) DEFAULT NULL,
  `ketebida` float NOT NULL,
  `phalaphala` varchar(255) NOT NULL DEFAULT 'perte',
  `sesabida` float NOT NULL,
  `ergebnis` int DEFAULT NULL,
  `zufallig` int DEFAULT NULL,
  `tiarikala` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `bajikattuttate_kemuru_drei`
--

CREATE TABLE `bajikattuttate_kemuru_drei` (
  `parichaya` int NOT NULL,
  `byabaharkarta` int NOT NULL,
  `kalaparichaya` varchar(255) NOT NULL,
  `prakar` varchar(100) NOT NULL,
  `ojana` varchar(100) NOT NULL,
  `menge` varchar(100) DEFAULT NULL,
  `wettanzahl` varchar(100) DEFAULT NULL,
  `ketebida` float NOT NULL,
  `phalaphala` varchar(255) NOT NULL DEFAULT 'perte',
  `sesabida` float NOT NULL,
  `ergebnis` int DEFAULT NULL,
  `zufallig` int DEFAULT NULL,
  `tiarikala` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `bajikattuttate_kemuru_funf`
--

CREATE TABLE `bajikattuttate_kemuru_funf` (
  `parichaya` int NOT NULL,
  `byabaharkarta` int NOT NULL,
  `kalaparichaya` varchar(255) NOT NULL,
  `prakar` varchar(100) NOT NULL,
  `ojana` varchar(100) NOT NULL,
  `menge` varchar(100) DEFAULT NULL,
  `wettanzahl` varchar(100) DEFAULT NULL,
  `ketebida` float NOT NULL,
  `phalaphala` varchar(255) NOT NULL DEFAULT 'perte',
  `sesabida` float NOT NULL,
  `ergebnis` int DEFAULT NULL,
  `zufallig` int DEFAULT NULL,
  `tiarikala` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `bajikattuttate_kemuru_zehn`
--

CREATE TABLE `bajikattuttate_kemuru_zehn` (
  `parichaya` int NOT NULL,
  `byabaharkarta` int NOT NULL,
  `kalaparichaya` varchar(255) NOT NULL,
  `prakar` varchar(100) NOT NULL,
  `ojana` varchar(100) NOT NULL,
  `menge` varchar(100) DEFAULT NULL,
  `wettanzahl` varchar(100) DEFAULT NULL,
  `ketebida` float NOT NULL,
  `phalaphala` varchar(255) NOT NULL DEFAULT 'perte',
  `sesabida` float NOT NULL,
  `ergebnis` int DEFAULT NULL,
  `zufallig` int DEFAULT NULL,
  `tiarikala` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `bajikattuttate_trx`
--

CREATE TABLE `bajikattuttate_trx` (
  `parichaya` int NOT NULL,
  `byabaharkarta` int NOT NULL,
  `kalaparichaya` varchar(255) NOT NULL,
  `prakar` varchar(100) NOT NULL,
  `ojana` varchar(100) NOT NULL,
  `menge` varchar(100) DEFAULT NULL,
  `wettanzahl` varchar(100) DEFAULT NULL,
  `ketebida` float NOT NULL,
  `phalaphala` varchar(255) NOT NULL DEFAULT 'perte',
  `sesabida` float NOT NULL,
  `ergebnis` int DEFAULT NULL,
  `zufallig` int DEFAULT NULL,
  `tiarikala` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `bajikattuttate_trx3`
--

CREATE TABLE `bajikattuttate_trx3` (
  `parichaya` int NOT NULL,
  `byabaharkarta` int NOT NULL,
  `kalaparichaya` varchar(255) NOT NULL,
  `prakar` varchar(100) NOT NULL,
  `ojana` varchar(100) NOT NULL,
  `menge` varchar(100) DEFAULT NULL,
  `wettanzahl` varchar(100) DEFAULT NULL,
  `ketebida` float NOT NULL,
  `phalaphala` varchar(255) NOT NULL DEFAULT 'perte',
  `sesabida` float NOT NULL,
  `ergebnis` int DEFAULT NULL,
  `zufallig` int DEFAULT NULL,
  `tiarikala` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `bajikattuttate_trx5`
--

CREATE TABLE `bajikattuttate_trx5` (
  `parichaya` int NOT NULL,
  `byabaharkarta` int NOT NULL,
  `kalaparichaya` varchar(255) NOT NULL,
  `prakar` varchar(100) NOT NULL,
  `ojana` varchar(100) NOT NULL,
  `menge` varchar(100) DEFAULT NULL,
  `wettanzahl` varchar(100) DEFAULT NULL,
  `ketebida` float NOT NULL,
  `phalaphala` varchar(255) NOT NULL DEFAULT 'perte',
  `sesabida` float NOT NULL,
  `ergebnis` int DEFAULT NULL,
  `zufallig` int DEFAULT NULL,
  `tiarikala` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `bajikattuttate_trx10`
--

CREATE TABLE `bajikattuttate_trx10` (
  `parichaya` int NOT NULL,
  `byabaharkarta` int NOT NULL,
  `kalaparichaya` varchar(255) NOT NULL,
  `prakar` varchar(100) NOT NULL,
  `ojana` varchar(100) NOT NULL,
  `menge` varchar(100) DEFAULT NULL,
  `wettanzahl` varchar(100) DEFAULT NULL,
  `ketebida` float NOT NULL,
  `phalaphala` varchar(255) NOT NULL DEFAULT 'perte',
  `sesabida` float NOT NULL,
  `ergebnis` int DEFAULT NULL,
  `zufallig` int DEFAULT NULL,
  `tiarikala` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `bajikattuttate_zehn`
--

CREATE TABLE `bajikattuttate_zehn` (
  `parichaya` int NOT NULL,
  `byabaharkarta` int NOT NULL,
  `kalaparichaya` varchar(255) NOT NULL,
  `prakar` varchar(100) NOT NULL,
  `ojana` varchar(100) NOT NULL,
  `menge` varchar(100) DEFAULT NULL,
  `wettanzahl` varchar(100) DEFAULT NULL,
  `ketebida` float NOT NULL,
  `phalaphala` varchar(255) NOT NULL DEFAULT 'perte',
  `sesabida` float NOT NULL,
  `ergebnis` int DEFAULT NULL,
  `zufallig` int DEFAULT NULL,
  `tiarikala` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `bajikattuttate_zehn`
--

INSERT INTO `bajikattuttate_zehn` (`parichaya`, `byabaharkarta`, `kalaparichaya`, `prakar`, `ojana`, `menge`, `wettanzahl`, `ketebida`, `phalaphala`, `sesabida`, `ergebnis`, `zufallig`, `tiarikala`) VALUES
(0, 100000, '20250418100051232', '2', '14', '1', '1', 1, 'gagner', 1.96, 3, 76433, '2025-04-18 13:46:00');

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

--
-- Table structure for table `balance_detuct_table`
--

CREATE TABLE `balance_detuct_table` (
  `id` int NOT NULL,
  `userkani` int NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `serial` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT 'Imitator',
  `shonu` datetime NOT NULL,
  `remark` text CHARACTER SET latin1 COLLATE latin1_swedish_ci,
  `processed` tinyint(1) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `bankcard`
--

CREATE TABLE `bankcard` (
  `id` int NOT NULL,
  `userid` int NOT NULL,
  `account` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `type` int NOT NULL,
  `createdat` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `banned_users`
--

CREATE TABLE `banned_users` (
  `id` int NOT NULL,
  `user_id` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `reason` text COLLATE utf8mb4_general_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `banners`
--

CREATE TABLE `banners` (
  `id` int NOT NULL,
  `url` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `banner_url` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_active` tinyint(1) 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 `banners`
--

INSERT INTO `banners` (`id`, `url`, `banner_url`, `is_active`, `created_at`, `updated_at`) VALUES
(1, '/#/activity/Turntable', 'https://vgclub.fun/banners/4.png', 1, '2025-04-06 06:22:17', '2025-04-06 06:22:17'),
(2, '/#/activity/ActivityDetail?id=69', 'https://vgclub.fun/banners/3.png', 1, '2025-04-06 06:22:17', '2025-04-06 06:22:17'),
(3, '/#/activity/FirstRecharge', 'https://vgclub.fun/banners/8.png', 1, '2025-04-06 06:22:17', '2025-04-06 06:22:17'),
(4, '/#/main/InvitationBonus', 'https://vgclub.fun/banners/7.png', 1, '2025-04-06 06:22:17', '2025-04-06 06:22:17'),
(5, '/#/activity/ActivityDetail?id=66', 'https://vgclub.fun/banners/6.png', 1, '2025-04-06 06:22:17', '2025-04-06 06:22:17'),
(6, '/#/vip', 'https://vgclub.fun/banners/2.png', 1, '2025-04-06 06:22:17', '2025-04-06 06:22:17'),
(7, '/#/activity/ActivityDetail?id=47', 'https://vgclub.fun/banners/5.png', 1, '2025-04-06 06:22:17', '2025-04-06 06:22:17'),
(8, '/#/activity/ActivityDetail?id=53', 'https://vgclub.fun/banners/1.png', 1, '2025-04-06 06:22:17', '2025-04-06 06:22:17');

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

--
-- Table structure for table `betrec`
--

CREATE TABLE `betrec` (
  `id` int NOT NULL,
  `period` bigint NOT NULL,
  `ans` varchar(11) COLLATE utf8mb4_general_ci NOT NULL,
  `num` varchar(20) COLLATE utf8mb4_general_ci NOT NULL,
  `clo` tinytext COLLATE utf8mb4_general_ci NOT NULL,
  `res1` varchar(211) COLLATE utf8mb4_general_ci NOT NULL,
  `time` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `betrec`
--

INSERT INTO `betrec` (`id`, `period`, `ans`, `num`, `clo`, `res1`, `time`) VALUES
(1, 0, '0', '31970', 'red', 'violet', '2024-03-16 11:09:18');

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

--
-- Table structure for table `betting_requirements`
--

CREATE TABLE `betting_requirements` (
  `id` int NOT NULL,
  `user_id` varchar(255) NOT NULL,
  `required_amount` decimal(10,2) DEFAULT '3000.00',
  `current_amount` decimal(10,2) DEFAULT '0.00',
  `date` date NOT NULL,
  `status` enum('pending','completed') DEFAULT 'pending',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

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

--
-- Table structure for table `bonus_recharge_table`
--

CREATE TABLE `bonus_recharge_table` (
  `id` int NOT NULL,
  `userkani` int NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `serial` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT 'Imitator',
  `shonu` datetime NOT NULL,
  `remark` text CHARACTER SET latin1 COLLATE latin1_swedish_ci,
  `processed` tinyint(1) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `bot_otp`
--

CREATE TABLE `bot_otp` (
  `id` int NOT NULL,
  `mobile` varchar(20) NOT NULL,
  `otp` int NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `Cancel_withdrawal`
--

CREATE TABLE `Cancel_withdrawal` (
  `id` int NOT NULL,
  `userkani` int NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `serial` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT 'Imitator',
  `shonu` datetime NOT NULL,
  `remark` text CHARACTER SET latin1 COLLATE latin1_swedish_ci,
  `processed` tinyint(1) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `captcha_data`
--

CREATE TABLE `captcha_data` (
  `id` int NOT NULL,
  `captchaId` varchar(255) NOT NULL,
  `backgroundImage` longtext NOT NULL,
  `sliderImage` text NOT NULL,
  `correctPositionx` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `captcha_data`
--

INSERT INTO `captcha_data` (`id`, `captchaId`, `backgroundImage`, `sliderImage`, `correctPositionx`) VALUES
(1, '3b2600c5-bf8c-468d-aa00-b2a98edc83a0', 'data:image/png;base64,[encoded data, 119080 characters]', 'data:image/png;base64,[encoded data, 18988 characters]', 258);
INSERT INTO `captcha_data` (`id`, `captchaId`, `backgroundImage`, `sliderImage`, `correctPositionx`) VALUES
(2, '2f1e14e2-a1b5-4539-8b7d-33131c88cef9', 'data:image/png;base64,[encoded data, 356764 characters]