-- Table structure for table `bankcard`
--

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

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

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

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

--
-- Dumping data for table `banned_users`
--

INSERT INTO `banned_users` (`id`, `user_id`, `reason`, `created_at`) VALUES
(1, '2', 'Placed bets on multiple types in the same period (Period: 20250223100010631)', '2025-04-19 10:49:51');

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

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

CREATE TABLE `banners` (
  `id` int(11) NOT NULL,
  `url` varchar(255) NOT NULL,
  `banner_url` varchar(255) 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://ossimg.goa999.vip/GoaGame/banner/Banner_20240725181344o975.jpg', 1, '2025-04-06 06:22:17', '2025-09-11 09:02:25'),
(2, '/#/activity/ActivityDetail?id=69', 'https://ossimg.goa999.vip/GoaGame/banner/Banner_20231112215017xjfe.png', 1, '2025-04-06 06:22:17', '2025-09-11 09:02:37'),
(3, '/#/activity/FirstRecharge', 'https://ossimg.goa999.vip/GoaGame/banner/Banner_20240826114914chtf.png', 1, '2025-04-06 06:22:17', '2025-09-11 09:02:50'),
(4, '/#/main/InvitationBonus', 'https://ossimg.goa999.vip/GoaGame/banner/Banner_20241024192118oi7l.png', 1, '2025-04-06 06:22:17', '2025-09-11 09:03:13');

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

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

CREATE TABLE `betrec` (
  `id` int(11) NOT NULL,
  `period` bigint(20) NOT NULL,
  `ans` varchar(11) NOT NULL,
  `num` varchar(20) NOT NULL,
  `clo` tinytext NOT NULL,
  `res1` varchar(211) 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, '', '', '', '', '0000-00-00 00:00:00');

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

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

CREATE TABLE `betting_requirements` (
  `id` int(11) 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 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `bet_transactions`
--

CREATE TABLE `bet_transactions` (
  `id` int(11) NOT NULL,
  `user_id` varchar(255) NOT NULL,
  `vendor_code` varchar(50) NOT NULL,
  `amount` double NOT NULL,
  `transaction_id` varchar(100) NOT NULL,
  `remark` text DEFAULT NULL,
  `created_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

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

CREATE TABLE `bonus_recharge_table` (
  `kani` int(11) NOT NULL,
  `userkani` int(11) NOT NULL,
  `serial` varchar(200) NOT NULL DEFAULT 'Imitator',
  `price` varchar(200) NOT NULL,
  `shonu` varchar(200) NOT NULL,
  `remark` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `bonus_recharge_table`
--

INSERT INTO `bonus_recharge_table` (`kani`, `userkani`, `serial`, `price`, `shonu`, `remark`) VALUES
(1, 2, 'Imitator', '100', '2025-02-23 19:14:37', 'Bonus recharge'),
(2, 17, 'Imitator', '500', '2025-04-19 23:16:42', 'Ok'),
(3, 113100, 'Imitator', '6800', '2025-09-14 14:44:12', ''),
(4, 113226, 'Imitator', '200', '2025-09-16 08:17:45', 'Deposit complete ✅✅'),
(5, 113240, 'Imitator', '200', '2025-09-16 08:19:42', 'Deposit complete ✅✅'),
(6, 113279, 'Imitator', '800', '2025-09-16 09:27:35', 'Deposit complete ✅✅'),
(7, 113284, 'Imitator', '200', '2025-09-16 18:48:26', 'Deposit complete ✅✅'),
(8, 113226, 'Imitator', '1000', '2025-09-16 19:53:48', 'Deposit complete ✅✅'),
(9, 113268, 'Imitator', '1000', '2025-09-17 02:04:30', 'Deposit complete ✅✅'),
(10, 113186, 'Imitator', '200', '2025-09-19 11:09:08', 'Deposit complete ✅✅'),
(11, 113134, 'Imitator', '200', '2025-09-19 22:07:44', 'Deposit complete ✅✅'),
(12, 113371, 'Imitator', '200', '2025-09-20 12:52:18', 'Deposit complete ✅✅'),
(13, 113371, 'Imitator', '300', '2025-09-20 13:43:52', 'Deposit complete ✅✅'),
(14, 113381, 'Imitator', '500', '2025-09-21 12:39:28', 'Deposit complete ✅✅'),
(15, 113387, 'Imitator', '200', '2025-09-21 14:55:29', 'Deposit complete ✅✅'),
(16, 113132, 'Imitator', '200', '2025-09-25 15:23:05', 'Deposit complete ✅✅'),
(17, 113103, 'Imitator', '500', '2025-09-28 18:55:08', 'Deposit complete ✅✅'),
(18, 113316, 'Imitator', '200', '2025-09-29 13:52:52', 'Deposit complete ✅✅'),
(19, 113494, 'Imitator', '200', '2025-10-16 12:08:03', 'Deposit complete ✅✅'),
(20, 113494, 'Imitator', '3000', '2025-10-16 14:08:15', 'Deposit complete ✅✅'),
(21, 113605, 'Imitator', '200', '2026-06-02 19:41:39', ''),
(22, 113670, 'Imitator', '150', '2026-06-11 21:53:39', ''),
(23, 113673, 'Imitator', '100', '2026-06-13 17:08:30', ''),
(24, 113566, 'Imitator', '100', '2026-06-13 20:18:58', ''),
(25, 113675, 'Imitator', '100', '2026-06-16 16:27:32', '');

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

--
-- Table structure for table `bot_prediction_history`
--

CREATE TABLE `bot_prediction_history` (
  `id` int(11) NOT NULL,
  `period_id` varchar(50) DEFAULT NULL,
  `prediction_number` int(11) DEFAULT NULL,
  `prediction_color` varchar(20) DEFAULT NULL,
  `amount` decimal(10,2) DEFAULT NULL,
  `step` int(11) DEFAULT NULL,
  `status` varchar(20) DEFAULT 'pending',
  `type` varchar(10) DEFAULT NULL,
  `created_at` datetime DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `bot_prediction_history`
--

INSERT INTO `bot_prediction_history` (`id`, `period_id`, `prediction_number`, `prediction_color`, `amount`, `step`, `status`, `type`, `created_at`) VALUES
(1, '20250325100011247', 4, 'red', 10.00, 1, 'pending', 'Small', '2025-03-25 08:22:02'),
(2, '20250325100011248', 0, 'red', 10.00, 1, 'pending', 'Small', '2025-03-25 08:23:02'),
(3, '20250325100011249', 6, 'red', 10.00, 1, 'pending', 'Big', '2025-03-25 08:24:02'),
(4, '20250325100011250', 2, 'red', 10.00, 1, 'pending', 'Small', '2025-03-25 08:25:02'),
(5, '20250325100011251', 0, 'red', 10.00, 1, 'pending', 'Small', '2025-03-25 08:26:02'),
(6, '20250325100011252', 5, 'green,violet', 10.00, 1, 'pending', 'Big', '2025-03-25 08:27:02'),
(7, '20250325100011253', 4, 'red', 10.00, 1, 'pending', 'Small', '2025-03-25 08:28:02'),
(8, '20250325100011254', 8, 'red', 10.00, 1, 'pending', 'Big', '2025-03-25 08:29:03'),
(9, '20250325100011255', 7, 'green', 10.00, 1, 'pending', 'Big', '2025-03-25 08:30:02'),
(10, '20250325100011256', 1, 'green', 10.00, 1, 'pending', 'Small', '2025-03-25 08:31:02'),
(11, '20250325100011257', 3, 'green', 10.00, 1, 'pending', 'Small', '2025-03-25 08:32:02'),
(12, '20250325100011258', 5, 'green,violet', 10.00, 1, 'pending', 'Big', '2025-03-25 08:33:02'),
(13, '20250325100011259', 9, 'green', 10.00, 1, 'pending', 'Big', '2025-03-25 08:34:02'),
(14, '20250325100011260', 1, 'green', 10.00, 1, 'pending', 'Small', '2025-03-25 08:35:01');

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

--
-- Table structure for table `bot_settings`
--

CREATE TABLE `bot_settings` (
  `id` int(11) NOT NULL,
  `bot_status` enum('ON','OFF') NOT NULL DEFAULT 'OFF',
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `bot_settings`
--

INSERT INTO `bot_settings` (`id`, `bot_status`, `updated_at`) VALUES
(1, 'OFF', '2025-03-25 10:04:38');

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

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

CREATE TABLE `Cancel_withdrawal` (
  `id` int(11) NOT NULL,
  `userkani` int(11) 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 DEFAULT NULL,
  `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(11) NOT NULL,
  `captchaId` varchar(255) NOT NULL,
  `backgroundImage` longtext NOT NULL,
  `sliderImage` text NOT NULL,
  `correctPositionx` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- 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, 376042 characters]