{"slug":"ekc-tournament-manager","name":"EKC Tournament Manager","description":"Manage Swiss system style tournaments, handle registration of teams and players. Developed for and used at the EKC European Kubb Championships.","author":"lukashuser","active_installs":10,"version":"2.5.1","wp_org_url":"https://wordpress.org/plugins/ekc-tournament-manager/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"ekc_email_status","full_table_name":"wp_ekc_email_status","description":"Stores analytics or statistics data.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"ekc_player","full_table_name":"wp_ekc_player","description":"Stores ekc player data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_ekc_player` (\\n  `player_id` int NOT NULL AUTO_INCREMENT,\\n  `team_id` int NOT NULL,\\n  `last_name` varchar(500) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `first_name` varchar(500) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `country` varchar(20) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `is_active` bit(1) DEFAULT NULL,\\n  `is_captain` bit(1) DEFAULT NULL,\\n  PRIMARY KEY (`player_id`),\\n  KEY `i_team_id` (`team_id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"ekc_result","full_table_name":"wp_ekc_result","description":"Stores ekc result data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"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"},{"table_name":"ekc_result_log","full_table_name":"wp_ekc_result_log","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_ekc_result_log` (\\n  `result_log_id` int NOT NULL AUTO_INCREMENT,\\n  `result_id` int NOT NULL,\\n  `log_time` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),\\n  `log_team_id` int DEFAULT NULL,\\n  `team1_score` double DEFAULT NULL,\\n  `team2_score` double DEFAULT NULL,\\n  PRIMARY KEY (`result_log_id`),\\n  KEY `i_result_id` (`result_id`),\\n  KEY `i_log_team_id` (`log_team_id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"ekc_team","full_table_name":"wp_ekc_team","description":"Stores ekc team data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_ekc_team` (\\n  `team_id` int NOT NULL AUTO_INCREMENT,\\n  `tournament_id` int NOT NULL,\\n  `name` varchar(500) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `country` varchar(20) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `club` varchar(500) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `is_active` bit(1) DEFAULT NULL,\\n  `email` varchar(500) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `phone` varchar(50) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `registration_date` datetime DEFAULT NULL,\\n  `camping_count` int DEFAULT NULL,\\n  `breakfast_count` int DEFAULT NULL,\\n  `is_registration_fee_paid` bit(1) DEFAULT NULL,\\n  `is_on_wait_list` bit(1) DEFAULT NULL,\\n  `registration_order` double DEFAULT NULL,\\n  `is_checked_in` bit(1) DEFAULT NULL,\\n  `seeding_score` double DEFAULT NULL,\\n  `initial_score` double DEFAULT NULL,\\n  `virtual_rank` int DEFAULT NULL,\\n  `shareable_link_id` varchar(50) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  PRIMARY KEY (`team_id`),\\n  KEY `i_tournament_id` (`tournament_id`),\\n  KEY `i_shareable_link_id` (`shareable_link_id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"ekc_tournament","full_table_name":"wp_ekc_tournament","description":"Stores ekc tournament data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_ekc_tournament` (\\n  `tournament_id` int NOT NULL AUTO_INCREMENT,\\n  `code_name` varchar(50) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `name` varchar(500) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `owner_user_id` int DEFAULT NULL,\\n  `tournament_date` date DEFAULT NULL,\\n  `max_teams` int DEFAULT NULL,\\n  `team_size` varchar(20) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `is_wait_list_enabled` bit(1) DEFAULT NULL,\\n  `is_player_names_required` bit(1) DEFAULT NULL,\\n  `is_auto_backup_enabled` bit(1) DEFAULT NULL,\\n  `is_check_in_enabled` bit(1) DEFAULT NULL,\\n  `is_check_in_active` bit(1) DEFAULT NULL,\\n  `tournament_system` varchar(20) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `elimination_rounds` varchar(20) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `elimination_silver_rounds` varchar(20) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `elimination_max_points_per_round` int DEFAULT NULL,\\n  `swiss_system_rounds` int DEFAULT NULL,\\n  `swiss_system_max_points_per_round` int DEFAULT NULL,\\n  `swiss_system_bye_points` int DEFAULT NULL,\\n  `swiss_system_virtual_result_points` int DEFAULT NULL,\\n  `swiss_system_additional_rounds` int DEFAULT NULL,\\n  `swiss_system_slide_match_rounds` int DEFAULT NULL,\\n  `swiss_system_round_time` int DEFAULT NULL,\\n  `swiss_system_tiebreak_time` int DEFAULT NULL,\\n  `swiss_system_start_pitch` int DEFAULT NULL,\\n  `swiss_system_pitch_limit` int DEFAULT NULL,\\n  `shareable_link_url_prefix` varchar(500) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `shareable_link_email_text` mediumtext COLLATE utf8mb4_unicode_520_ci,\\n  `shareable_link_sender_email` varchar(500) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  PRIMARY KEY (`tournament_id`),\\n  UNIQUE KEY `uc_code_name` (`code_name`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"ekc_tournament_round","full_table_name":"wp_ekc_tournament_round","description":"Stores ekc tournament round data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_ekc_tournament_round` (\\n  `tournament_id` int NOT NULL,\\n  `tournament_round` int NOT NULL,\\n  `round_start_time` timestamp NULL DEFAULT NULL,\\n  PRIMARY KEY (`tournament_id`,`tournament_round`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"}],"table_count":7}