CREATE TABLE `matches` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `match_title` varchar(255) NOT NULL DEFAULT 'SPECIAL MATCH',
  `prize` decimal(10,2) NOT NULL,
  `entry_fee` decimal(10,2) NOT NULL,
  `version` varchar(50) DEFAULT 'মোবাইল',
  `board_type` varchar(100) DEFAULT 'LUDO ADVANCE',
  `total_players` int(11) NOT NULL DEFAULT 2,
  `joined_players` int(11) NOT NULL DEFAULT 0,
  `room_id` varchar(100) DEFAULT 'Waiting...',
  `status` enum('open', 'full', 'finished') DEFAULT 'open',
  `created_at` timestamp DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;