🗄️What WP Table Is This?
Home / EKC Tournament Manager / wp_ekc_tournament

wp_ekc_tournament

Static

Stores ekc tournament data created by this plugin.

CREATE TABLE Statement

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

Safe to delete?

If you have uninstalled EKC Tournament Manager, this table is generally safe to remove. However, always back up your database first.

Note: Some plugins share tables or are dependencies of other plugins. Verify nothing else depends on this table before dropping it.

How to remove this table

DROP TABLE IF EXISTS `wp_ekc_tournament`;

Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.

Other tables from EKC Tournament Manager