{"table_name":"ekc_result","full_table_name":"wp_ekc_result","description":"Stores ekc result data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE `wp_ekc_result` (\\n  `result_id` int NOT NULL AUTO_INCREMENT,\\n  `tournament_id` int NOT NULL,\\n  `team1_id` int DEFAULT NULL,\\n  `team2_id` int DEFAULT NULL,\\n  `team1_placeholder` varchar(500) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `team2_placeholder` varchar(500) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `team1_score` double DEFAULT NULL,\\n  `team2_score` double DEFAULT NULL,\\n  `pitch` varchar(20) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `stage` varchar(20) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `tournament_round` int DEFAULT NULL,\\n  `result_type` varchar(20) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `is_virtual_result` bit(1) DEFAULT NULL,\\n  PRIMARY KEY (`result_id`),\\n  KEY `i_tournament_id` (`tournament_id`),\\n  KEY `i_team1_id` (`team1_id`),\\n  KEY `i_team2_id` (`team2_id`),\\n  KEY `i_stage` (`stage`),\\n  KEY `i_result_type` (`result_type`),\\n  KEY `i_tournament_round` (`tournament_round`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci","columns":[],"plugin":{"slug":"ekc-tournament-manager","name":"EKC Tournament Manager","active_installs":10,"version":"2.5.1","wp_org_url":"https://wordpress.org/plugins/ekc-tournament-manager/"}}