-- phpMyAdmin SQL Dump -- version 5.2.2 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Apr 08, 2026 at 12:35 PM -- Server version: 8.0.41-cll-lve -- PHP Version: 8.4.19 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: `wffohlin_qwar` -- -- -------------------------------------------------------- -- -- Table structure for table `aboutus` -- CREATE TABLE `aboutus` ( `id` int NOT NULL, `title` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -------------------------------------------------------- -- -- Table structure for table `add_request` -- CREATE TABLE `add_request` ( `id` int NOT NULL, `username` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `coins` decimal(10,2) DEFAULT NULL, `utr` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `order_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `payment_url` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, `screenshot` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `status` tinyint DEFAULT '0', `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -------------------------------------------------------- -- -- Table structure for table `admin` -- CREATE TABLE `admin` ( `id` int NOT NULL, `email` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `status` tinyint DEFAULT '1', `role` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `last_login_at` datetime DEFAULT NULL, `pages` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `admin` -- INSERT INTO `admin` (`id`, `email`, `password`, `status`, `role`, `last_login_at`, `pages`, `created_at`) VALUES (1, 'admin@mail.com', 'admin123', 1, 'admin', '2026-04-04 21:44:00', NULL, '2026-04-03 20:28:04'); -- -------------------------------------------------------- -- -- Table structure for table `app_screenshots` -- CREATE TABLE `app_screenshots` ( `id` int NOT NULL, `image` varchar(255) DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -------------------------------------------------------- -- -- Table structure for table `bonus` -- CREATE TABLE `bonus` ( `id` int NOT NULL, `amount` decimal(10,2) DEFAULT NULL, `extra` decimal(10,2) DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `bonus` -- INSERT INTO `bonus` (`id`, `amount`, `extra`, `created_at`) VALUES (1, 50.00, 5.00, '2026-04-04 16:12:55'), (2, 100.00, 15.00, '2026-04-04 16:13:01'), (3, 500.00, 60.00, '2026-04-04 16:13:12'), (4, 1000.00, 150.00, '2026-04-04 16:13:22'); -- -------------------------------------------------------- -- -- Table structure for table `customer_support` -- CREATE TABLE `customer_support` ( `id` int NOT NULL AUTO_INCREMENT, `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `url` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -------------------------------------------------------- -- -- Table structure for table `developer_info` -- CREATE TABLE `developer_info` ( `id` int NOT NULL, `name` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `mobile` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `website` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -------------------------------------------------------- -- -- Table structure for table `earn` -- CREATE TABLE `earn` ( `id` int NOT NULL, `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -------------------------------------------------------- -- -- Table structure for table `games` -- CREATE TABLE `games` ( `id` int NOT NULL, `image` varchar(255) NOT NULL, `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -------------------------------------------------------- -- -- Table structure for table `info` -- CREATE TABLE `info` ( `id` int NOT NULL, `logo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `name` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `app_version` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '1.0.0', `banner` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `splash` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `apk` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `referral_amount` decimal(10,2) DEFAULT '5.00', `signup_bonus` decimal(10,2) DEFAULT '0.00', `min_deposit_for_referral` decimal(10,2) DEFAULT '10.00', `hero_title` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, `hero_subtitle` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, `stats_tournaments` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '50,000+', `stats_gamers` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '100,000+', `stats_winnings` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '₹1.2L+', `feature1_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT 'FAIR PLAY SYSTEM', `feature1_desc` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, `feature2_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT 'INSTANT PAYOUTS', `feature2_desc` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, `announcement` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, `bottom_image` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -------------------------------------------------------- -- -- Table structure for table `logbefore` -- CREATE TABLE `logbefore` ( `id` int NOT NULL, `image` varchar(255) NOT NULL, `title` varchar(255) NOT NULL, `des` text, `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -------------------------------------------------------- -- -- Table structure for table `modes` -- CREATE TABLE `modes` ( `id` int NOT NULL, `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `title` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `gameid` int DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -------------------------------------------------------- -- -- Table structure for table `notification_settings` -- CREATE TABLE `notification_settings` ( `id` int NOT NULL, `fcm_server_key` text, `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -- Dumping data for table `notification_settings` -- INSERT INTO `notification_settings` (`id`, `fcm_server_key`, `updated_at`) VALUES (1, '', '2026-04-04 02:30:52'); -- -------------------------------------------------------- -- -- Table structure for table `purchased` -- CREATE TABLE `purchased` ( `id` int NOT NULL, `username` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `amount` decimal(10,2) DEFAULT NULL, `order_id` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -------------------------------------------------------- -- -- Table structure for table `referrals` -- CREATE TABLE `referrals` ( `id` int NOT NULL, `referred_by` varchar(100) DEFAULT NULL, `referred_to` varchar(100) DEFAULT NULL, `amount` decimal(10,2) DEFAULT '0.00', `status` tinyint DEFAULT '0', `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -------------------------------------------------------- -- -- Table structure for table `results` -- CREATE TABLE `results` ( `id` int NOT NULL, `tournament_id` int DEFAULT NULL, `username` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `amount` decimal(10,2) DEFAULT NULL, `kills` int DEFAULT NULL, `position` int DEFAULT NULL, `total` decimal(10,2) DEFAULT NULL, `slot` int DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `staff_done` int DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -------------------------------------------------------- -- -- Table structure for table `slider` -- CREATE TABLE `slider` ( `id` int NOT NULL, `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `slider` -- INSERT INTO `slider` (`id`, `image`, `url`, `created_at`) VALUES (1, '1775318879_1775025658_17745253401000061789.jpg', '..', '2026-04-04 16:07:59'); -- -------------------------------------------------------- -- -- Table structure for table `social` -- CREATE TABLE `social` ( `id` int NOT NULL, `youtube_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `facebook_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `instagram_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `x_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `snapchat_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -------------------------------------------------------- -- -- Table structure for table `tnc` -- CREATE TABLE `tnc` ( `id` int NOT NULL, `title` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -------------------------------------------------------- -- -- Table structure for table `tournament` -- CREATE TABLE `tournament` ( `id` int NOT NULL, `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `title` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `mode_id` int DEFAULT NULL, `staff` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `team` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `slots` int DEFAULT '0', `restslots` int DEFAULT '0', `entry_fee` decimal(10,2) DEFAULT NULL, `match_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `map` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `match_schedule` datetime DEFAULT NULL, `winning_prize` decimal(10,2) DEFAULT NULL, `per_kill` decimal(10,2) DEFAULT NULL, `about` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, `usernames` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, `game_ids` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, `slot_booked` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, `status` tinyint DEFAULT '1', `stream_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `room_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `room_password` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -------------------------------------------------------- -- -- Table structure for table `transactions` -- CREATE TABLE `transactions` ( `id` int NOT NULL, `username` varchar(100) DEFAULT NULL, `amount` decimal(10,2) DEFAULT '0.00', `type` varchar(50) DEFAULT NULL, `remark` text, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` int NOT NULL, `first_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `last_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `username` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `email` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `mobile` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `fcm_token` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, `push_enabled` int DEFAULT '1', `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `status` tinyint DEFAULT '1', `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `users` -- INSERT INTO `users` (`id`, `first_name`, `last_name`, `username`, `email`, `mobile`, `fcm_token`, `push_enabled`, `password`, `status`, `created_at`) VALUES (1, 'test', '123', 'test123', 'test@mail.com', '7014141314', 'f69Ec4lCQOCtXV8XMIGSVi:APA91bGRiu7lHTsws7L8EcsHVmAro2sLCG_ZSl1lURnXmTjs8GUSpp30mr8aa6vNMMYqVqyjCdOGRTOzxRYlGL-xtl5YmOtdmGWosjOXzmUW8Mxb5JS1PNc', 1, 'test123', 1, '2026-04-03 20:22:21'); -- -------------------------------------------------------- -- -- Table structure for table `wallet` -- CREATE TABLE `wallet` ( `id` int NOT NULL, `username` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `total_balance` decimal(10,2) DEFAULT '0.00', `deposited` decimal(10,2) DEFAULT '0.00', `winning` decimal(10,2) DEFAULT '0.00', `payouts` decimal(10,2) DEFAULT '0.00', `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `wallet` -- INSERT INTO `wallet` (`id`, `username`, `total_balance`, `deposited`, `winning`, `payouts`, `updated_at`) VALUES (1, 'test123', 0.00, 0.00, 0.00, 0.00, '2026-04-03 20:22:21'); -- -------------------------------------------------------- -- -- Table structure for table `withdraw` -- CREATE TABLE `withdraw` ( `id` int NOT NULL, `username` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `amount` decimal(10,2) DEFAULT NULL, `mobile` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `upi` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `method` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `redeem_code` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `status` tinyint DEFAULT '0', `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Indexes for dumped tables -- -- -- Indexes for table `aboutus` -- ALTER TABLE `aboutus` ADD PRIMARY KEY (`id`); -- -- Indexes for table `add_request` -- ALTER TABLE `add_request` ADD PRIMARY KEY (`id`); -- -- Indexes for table `admin` -- ALTER TABLE `admin` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `email` (`email`); -- -- Indexes for table `app_screenshots` -- ALTER TABLE `app_screenshots` ADD PRIMARY KEY (`id`); -- -- Indexes for table `bonus` -- ALTER TABLE `bonus` ADD PRIMARY KEY (`id`); -- -- Indexes for table `customer_support` -- ALTER TABLE `customer_support` ADD PRIMARY KEY (`id`); -- -- Indexes for table `developer_info` -- ALTER TABLE `developer_info` ADD PRIMARY KEY (`id`); -- -- Indexes for table `earn` -- ALTER TABLE `earn` ADD PRIMARY KEY (`id`); -- -- Indexes for table `games` -- ALTER TABLE `games` ADD PRIMARY KEY (`id`); -- -- Indexes for table `info` -- ALTER TABLE `info` ADD PRIMARY KEY (`id`); -- -- Indexes for table `logbefore` -- ALTER TABLE `logbefore` ADD PRIMARY KEY (`id`); -- -- Indexes for table `modes` -- ALTER TABLE `modes` ADD PRIMARY KEY (`id`); -- -- Indexes for table `notification_settings` -- ALTER TABLE `notification_settings` ADD PRIMARY KEY (`id`); -- -- Indexes for table `purchased` -- ALTER TABLE `purchased` ADD PRIMARY KEY (`id`); -- -- Indexes for table `referrals` -- ALTER TABLE `referrals` ADD PRIMARY KEY (`id`); -- -- Indexes for table `results` -- ALTER TABLE `results` ADD PRIMARY KEY (`id`); -- -- Indexes for table `slider` -- ALTER TABLE `slider` ADD PRIMARY KEY (`id`); -- -- Indexes for table `social` -- ALTER TABLE `social` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tnc` -- ALTER TABLE `tnc` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tournament` -- ALTER TABLE `tournament` ADD PRIMARY KEY (`id`); -- -- Indexes for table `transactions` -- ALTER TABLE `transactions` ADD PRIMARY KEY (`id`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `username` (`username`), ADD UNIQUE KEY `email` (`email`); -- -- Indexes for table `wallet` -- ALTER TABLE `wallet` ADD PRIMARY KEY (`id`); -- -- Indexes for table `withdraw` -- ALTER TABLE `withdraw` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `aboutus` -- ALTER TABLE `aboutus` MODIFY `id` int NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `add_request` -- ALTER TABLE `add_request` MODIFY `id` int NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `admin` -- ALTER TABLE `admin` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `app_screenshots` -- ALTER TABLE `app_screenshots` MODIFY `id` int NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `bonus` -- ALTER TABLE `bonus` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `customer_support` -- ALTER TABLE `customer_support` MODIFY `id` int NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `developer_info` -- ALTER TABLE `developer_info` MODIFY `id` int NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `earn` -- ALTER TABLE `earn` MODIFY `id` int NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `games` -- ALTER TABLE `games` MODIFY `id` int NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `info` -- ALTER TABLE `info` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `logbefore` -- ALTER TABLE `logbefore` MODIFY `id` int NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `modes` -- ALTER TABLE `modes` MODIFY `id` int NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `notification_settings` -- ALTER TABLE `notification_settings` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `purchased` -- ALTER TABLE `purchased` MODIFY `id` int NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `referrals` -- ALTER TABLE `referrals` MODIFY `id` int NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `results` -- ALTER TABLE `results` MODIFY `id` int NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `slider` -- ALTER TABLE `slider` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `social` -- ALTER TABLE `social` MODIFY `id` int NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `tnc` -- ALTER TABLE `tnc` MODIFY `id` int NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `tournament` -- ALTER TABLE `tournament` MODIFY `id` int NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `transactions` -- ALTER TABLE `transactions` MODIFY `id` int NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `wallet` -- ALTER TABLE `wallet` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `withdraw` -- ALTER TABLE `withdraw` MODIFY `id` int NOT NULL AUTO_INCREMENT; COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;