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

START TRANSACTION;



--
-- Database: `habibtou_habib1122`
--

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

--
-- Table structure for table `addmoney`
--

CREATE TABLE `addmoney` (
  `id` int(11) NOT NULL,
  `name` varchar(50) NOT NULL,
  `email` varchar(100) NOT NULL,
  `method` varchar(10) NOT NULL,
  `number` varchar(15) NOT NULL,
  `amount` int(11) NOT NULL,
  `trxid` varchar(10) NOT NULL,
  `status` varchar(10) NOT NULL DEFAULT 'Pending',
  `date` varchar(20) NOT NULL,
  `time` varchar(20) NOT NULL,
  `fcm` varchar(500) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `freefire`
--

CREATE TABLE `freefire` (
  `id` int(11) NOT NULL,
  `match_title` varchar(100) NOT NULL,
  `match_time` varchar(50) NOT NULL,
  `total_prize` int(11) NOT NULL,
  `per_kill` int(11) NOT NULL,
  `entry_fee` int(11) NOT NULL,
  `entry_type` varchar(10) NOT NULL,
  `match_type` varchar(20) NOT NULL,
  `version` varchar(10) NOT NULL,
  `play_map` varchar(10) NOT NULL,
  `registration` varchar(10) NOT NULL,
  `prize_details` varchar(200) NOT NULL,
  `total_player` int(11) NOT NULL,
  `total_joiner` int(11) NOT NULL DEFAULT 0,
  `match_result` varchar(10) NOT NULL,
  `room_details` varchar(100) NOT NULL,
  `timer` varchar(100) DEFAULT 'Time: 29/09/2024 At 22:00 AM',
  `join_type` varchar(300) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `freefire`
--

INSERT INTO `freefire` (`id`, `match_title`, `match_time`, `total_prize`, `per_kill`, `entry_fee`, `entry_type`, `match_type`, `version`, `play_map`, `registration`, `prize_details`, `total_player`, `total_joiner`, `match_result`, `room_details`, `timer`, `join_type`) VALUES
(1, 'Solo Time | Mobile | ', 'Time: 18/12/2024 At 05:02 PM', 800, 10, 20, 'Solo', 'Clash Squad', 'TPP', 'Bermuda', 'Open', '👑 Winner - 90 TK\n🥈 2ND Position - 70 TK\n🥉 3RD Position - 40 TK\n🏅 4TH Position - 30 TK\n🏅 5TH Position - 20 TK\n🔥 Per Kill : 10 TK\n🏆 Total Prize Pool: 800 TK', 48, 0, 'NO', 'NO', 'Time: 18/12/2024 At 17:02 AM', ''),
(2, 'Solo Time | Mobile | ', 'Time: 18/12/2024 At 05:05 PM', 800, 10, 20, 'Solo', 'Free Match', 'TPP', 'Bermuda', 'Open', '👑 Winner - 90 TK\n🥈 2ND Position - 70 TK\n🥉 3RD Position - 40 TK\n🏅 4TH Position - 30 TK\n🏅 5TH Position - 20 TK\n🔥 Per Kill : 10 TK\n🏆 Total Prize Pool: 800 TK', 48, 1, 'NO', 'NO', 'Time: 18/12/2024 At 17:05 AM', ''),
(3, 'Solo Time | Mobile | ', 'Time: 18/12/2024 At 05:05 PM', 800, 10, 20, 'Solo', 'Clash Squad Tour', 'TPP', 'Bermuda', 'Open', '👑 Winner - 90 TK\n🥈 2ND Position - 70 TK\n🥉 3RD Position - 40 TK\n🏅 4TH Position - 30 TK\n🏅 5TH Position - 20 TK\n🔥 Per Kill : 10 TK\n🏆 Total Prize Pool: 800 TK', 48, 0, 'NO', 'NO', 'Time: 18/12/2024 At 17:05 AM', ''),
(5, 'CS ( 4 VS 4 ) | Mobile | ', 'Time: 18/12/2024 At 05:06 PM', 380, 0, 60, 'Squad', 'ClassicTour', 'TPP', 'Bermuda', 'Open', '👑 Winner - 380 TK\nNo Grendades Are Allowed', 8, 0, 'NO', 'NO', 'Time: 18/12/2024 At 17:06 AM', ''),
(7, 'Solo Time | Mobile | ', 'Time: 18/12/2024 At 08:12 PM', 800, 10, 20, 'Solo', 'Free Match', 'TPP', 'Bermuda', 'Open', '👑 Winner - 90 TK\n🥈 2ND Position - 70 TK\n🥉 3RD Position - 40 TK\n🏅 4TH Position - 30 TK\n🏅 5TH Position - 20 TK\n🔥 Per Kill : 10 TK\n🏆 Total Prize Pool: 800 TK', 48, 0, 'NO', 'NO', 'Time: 18/12/2024 At 20:11 AM', ''),
(8, 'Solo Time | Mobile | ', 'Time: 18/12/2024 At 08:30 PM', 800, 10, 20, 'Solo', 'Clash Squad', 'TPP', 'Bermuda', 'Open', '👑 Winner - 90 TK\n🥈 2ND Position - 70 TK\n🥉 3RD Position - 40 TK\n🏅 4TH Position - 30 TK\n🏅 5TH Position - 20 TK\n🔥 Per Kill : 10 TK\n🏆 Total Prize Pool: 800 TK', 48, 0, 'NO', 'NO', 'Time: 18/12/2024 At 20:30 AM', ''),
(10, 'Solo Time | Mobile | ', 'Time: 19/12/2024 At 09:47 AM', 800, 10, 20, 'Solo', 'Classic', 'TPP', 'Bermuda', 'Open', '👑 Winner - 90 TK\n🥈 2ND Position - 70 TK\n🥉 3RD Position - 40 TK\n🏅 4TH Position - 30 TK\n🏅 5TH Position - 20 TK\n🔥 Per Kill : 10 TK\n🏆 Total Prize Pool: 800 TK', 48, 0, 'NO', 'NO', 'Time: 19/12/2024 At 09:47 AM', ''),
(11, 'Solo Time | Mobile | ', 'Time: 19/12/2024 At 09:55 AM', 1150, 15, 30, 'Solo', 'Classic', 'TPP', 'Bermuda', 'Open', '👑 Winner - 140 TK\n🥈 2ND Position - 90 TK\n🥉 3RD Position - 70 TK\n🏅 4TH Position - 40 TK\n🏅 5TH Position - 30 TK\n🔥 Per Kill : 15 TK\n🏆 Total Prize Pool: 1150 TK', 48, 0, 'NO', 'NO', 'Time: 19/12/2024 At 09:55 AM', ''),
(12, 'Squad Time | Mobile | ', 'Time: 31/05/2025 At 06:30 PM', 380, 0, 60, 'Squad', 'Classic', 'TPP', 'Bermuda', 'Open', '👑 Winner - 380 TK\nNo Grendades Are Allowed', 8, 1, 'NO', 'NO', 'Time: 31/05/2025 At 18:30 AM', '');

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

--
-- Table structure for table `joiners`
--

CREATE TABLE `joiners` (
  `id` int(11) NOT NULL,
  `name` varchar(50) NOT NULL,
  `type` varchar(10) NOT NULL,
  `email` varchar(100) NOT NULL,
  `match_id` int(11) NOT NULL,
  `total_kill` int(11) NOT NULL DEFAULT 0,
  `winning` int(11) NOT NULL DEFAULT 0,
  `fcm_key` varchar(250) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `joiners`
--

INSERT INTO `joiners` (`id`, `name`, `type`, `email`, `match_id`, `total_kill`, `winning`, `fcm_key`) VALUES
(1, 'Habib', 'freefire', 'taripbha@gmail.com', 12, 0, 0, 'c4LM_oBgw5s:APA91bF5zZyPh4vNU6tL57Nqcb9V58jboRZ3gZmxrXcYDtrzdjJY7vxCEje7wMbOJ2pc3YQqnZ-NqEIGu0jxafLHhQeRnjvvXBaSFudgyDkjqbod1qfSh2g');

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

--
-- Table structure for table `ludoking`
--

CREATE TABLE `ludoking` (
  `id` int(11) NOT NULL,
  `match_title` varchar(100) NOT NULL,
  `match_time` varchar(50) NOT NULL,
  `total_prize` int(11) NOT NULL,
  `entry_fee` int(11) NOT NULL,
  `entry_type` varchar(10) NOT NULL,
  `match_type` varchar(15) NOT NULL,
  `play_map` varchar(15) NOT NULL,
  `registration` varchar(10) NOT NULL,
  `prize_details` varchar(100) NOT NULL,
  `total_player` int(11) NOT NULL,
  `total_joiner` int(11) NOT NULL DEFAULT 0,
  `match_result` varchar(10) NOT NULL,
  `room_details` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `refers`
--

CREATE TABLE `refers` (
  `id` int(11) NOT NULL,
  `date` varchar(50) NOT NULL,
  `name` varchar(100) NOT NULL,
  `status` varchar(20) NOT NULL DEFAULT 'Registered',
  `refer_by` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `statistics`
--

CREATE TABLE `statistics` (
  `id` int(11) NOT NULL,
  `email` varchar(100) NOT NULL,
  `type` varchar(10) NOT NULL,
  `match_id` int(11) NOT NULL,
  `match_title` varchar(100) NOT NULL,
  `played_on` varchar(50) NOT NULL,
  `paid` int(11) NOT NULL,
  `winnings` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `statistics`
--

INSERT INTO `statistics` (`id`, `email`, `type`, `match_id`, `match_title`, `played_on`, `paid`, `winnings`) VALUES
(1, 'taripbha@gmail.com', 'freefire', 12, 'Squad Time | Mobile | ', '25-05-2025', 60, 0);

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

--
-- Table structure for table `transaction`
--

CREATE TABLE `transaction` (
  `id` int(11) NOT NULL,
  `gateway` varchar(10) NOT NULL,
  `method` varchar(10) NOT NULL,
  `amount` int(11) NOT NULL,
  `sender` varchar(11) NOT NULL,
  `trxid` varchar(10) NOT NULL,
  `status` int(1) NOT NULL DEFAULT 0,
  `time` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `upload`
--

CREATE TABLE `upload` (
  `id` int(11) NOT NULL,
  `email` varchar(100) NOT NULL,
  `game_name` varchar(50) NOT NULL,
  `match_title` varchar(100) NOT NULL,
  `total_prize` int(11) NOT NULL,
  `image_url` varchar(200) NOT NULL,
  `match_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `withdraw`
--

CREATE TABLE `withdraw` (
  `id` int(11) NOT NULL,
  `name` varchar(50) NOT NULL,
  `email` varchar(100) NOT NULL,
  `method` varchar(10) NOT NULL,
  `number` varchar(15) NOT NULL,
  `amount` int(11) NOT NULL,
  `trxid` varchar(10) NOT NULL,
  `status` varchar(10) NOT NULL DEFAULT 'Pending',
  `date` varchar(20) NOT NULL,
  `time` varchar(20) NOT NULL,
  `fcm` varchar(500) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

