wp_anwpfl_matches

Column Definitions

CREATE TABLE Statement

CREATE TABLE wp_anwpfl_matches ( `match_id` bigint(20) UNSIGNED NOT NULL, `competition_id` bigint(20) UNSIGNED NOT NULL, `main_stage_id` bigint(20) UNSIGNED NOT NULL, `group_id` bigint(20) UNSIGNED NOT NULL, `season_id` bigint(20) UNSIGNED NOT NULL, `league_id` bigint(20) UNSIGNED NOT NULL, `home_club` bigint(20) UNSIGNED NOT NULL, `away_club` bigint(20) UNSIGNED NOT NULL, `kickoff` datetime NOT NULL default '0000-00-00 00:00:00', `kickoff_gmt` datetime NOT NULL default '0000-00-00 00:00:00', `finished` tinyint(1) NOT NULL DEFAULT '0', `extra` tinyint(1) NOT NULL DEFAULT '0', `attendance` int(10) NOT NULL DEFAULT '0', `aggtext` varchar(250) NOT NULL DEFAULT '', `stadium_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0', `match_week` tinyint(3) UNSIGNED NOT NULL DEFAULT '0', `priority` tinyint(1) UNSIGNED NOT NULL DEFAULT '0', `home_goals` tinyint(3) UNSIGNED NOT NULL DEFAULT '0', `away_goals` tinyint(3) UNSIGNED NOT NULL DEFAULT '0', `home_goals_half` tinyint(3) UNSIGNED NULL DEFAULT NULL, `away_goals_half` tinyint(3) UNSIGNED NULL DEFAULT NULL, `home_goals_ft` tinyint(3) UNSIGNED NULL DEFAULT NULL, `away_goals_ft` tinyint(3) UNSIGNED NULL DEFAULT NULL, `home_goals_e` tinyint(3) UNSIGNED NULL DEFAULT NULL, `away_goals_e` tinyint(3) UNSIGNED NULL DEFAULT NULL, `home_goals_p` tinyint(3) UNSIGNED NULL DEFAULT NULL, `away_goals_p` tinyint(3) UNSIGNED NULL DEFAULT NULL, `home_cards_y` tinyint(3) UNSIGNED NULL DEFAULT NULL, `away_cards_y` tinyint(3) UNSIGNED NULL DEFAULT NULL, `home_cards_yr` tinyint(3) UNSIGNED NULL DEFAULT NULL, `away_cards_yr` tinyint(3) UNSIGNED NULL DEFAULT NULL, `home_cards_r` tinyint(3) UNSIGNED NULL DEFAULT NULL, `away_cards_r` tinyint(3) UNSIGNED NULL DEFAULT NULL, `home_corners` tinyint(3) UNSIGNED NULL DEFAULT NULL, `away_corners` tinyint(3) UNSIGNED NULL DEFAULT NULL, `home_fouls` tinyint(3) UNSIGNED NULL DEFAULT NULL, `away_fouls` tinyint(3) UNSIGNED NULL DEFAULT NULL, `home_offsides` tinyint(3) UNSIGNED NULL DEFAULT NULL, `away_offsides` tinyint(3) UNSIGNED NULL DEFAULT NULL, `home_possession` tinyint(3) UNSIGNED NULL DEFAULT NULL, `away_possession` tinyint(3) UNSIGNED NULL DEFAULT NULL, `home_shots` tinyint(3) UNSIGNED NULL DEFAULT NULL, `away_shots` tinyint(3) UNSIGNED NULL DEFAULT NULL, `home_shots_on_goal` tinyint(3) UNSIGNED NULL DEFAULT NULL, `away_shots_on_goal` tinyint(3) UNSIGNED NULL DEFAULT NULL, `special_status` varchar(20) NOT NULL DEFAULT '', `game_status` tinyint(1) UNSIGNED NOT NULL DEFAULT '1', `coach_home` varchar(100) NOT NULL DEFAULT '', `coach_away` varchar(100) NOT NULL DEFAULT '', `referee` varchar(100) NOT NULL DEFAULT '', `match_events` longtext NOT NULL, `stats_home_club` text NOT NULL, `stats_away_club` text NOT NULL, `extra_info` longtext NOT NULL, PRIMARY KEY (match_id), KEY `competition_id` (`competition_id`), KEY `main_stage_id` (`main_stage_id`), KEY `finished` (`finished`), KEY `game_status` (`game_status`), KEY `home_club` (`home_club`), KEY `away_club` (`away_club`), KEY `kickoff` (`kickoff`), KEY `stadium_id` (`stadium_id`), KEY `coach_home` (`coach_home`), KEY `coach_away` (`coach_away`), KEY `referee` (`referee`), KEY `group_id` (`group_id`) ) $charset_collate; CREATE TABLE wp_anwpfl_players ( `match_id` bigint(20) UNSIGNED NOT NULL, `player_id` bigint(20) UNSIGNED NOT NULL, `club_id` bigint(20) UNSIGNED NOT NULL, `time_in` tinyint(3) UNSIGNED NOT NULL DEFAULT '0', `time_out` tinyint(3) UNSIGNED NOT NULL DEFAULT '0', `appearance` tinyint(1) UNSIGNED NOT NULL DEFAULT '0', `goals` tinyint(2) UNSIGNED NOT NULL DEFAULT '0', `goals_penalty` tinyint(2) UNSIGNED NOT NULL DEFAULT '0', `goals_own` tinyint(2) UNSIGNED NOT NULL DEFAULT '0', `goals_conceded` tinyint(2) UNSIGNED NOT NULL DEFAULT '0', `assist` tinyint(2) UNSIGNED NOT NULL DEFAULT '0', `card_y` tinyint(2) UNSIGNED NOT NULL DEFAULT '0', `card_yr` tinyint(2) UNSIGNED NOT NULL DEFAULT '0', `card_r` tinyint(2) UNSIGNED NOT NULL DEFAULT '0', PRIMARY KEY (`match_id`,`player_id`), KEY `player_id` (`player_id`), KEY `match_id` (`match_id`), KEY `club_id` (`club_id`) ) $charset_collate; CREATE TABLE wp_anwpfl_player_data ( `player_id` bigint(20) UNSIGNED NOT NULL, `name` varchar(250) NOT NULL DEFAULT '', `short_name` varchar(250) NOT NULL DEFAULT '', `full_name` varchar(250) NOT NULL DEFAULT '', `weight` varchar(50) NOT NULL DEFAULT '', `height` varchar(50) NOT NULL DEFAULT '', `position` varchar(10) NOT NULL DEFAULT '', `team_id` bigint(20) UNSIGNED NOT NULL, `national_team` bigint(20) UNSIGNED NOT NULL, `nationality` varchar(50) NOT NULL DEFAULT '', `nationality_extra` varchar(50) NOT NULL DEFAULT '', `place_of_birth` varchar(100) NOT NULL DEFAULT '', `country_of_birth` varchar(100) NOT NULL DEFAULT '', `date_of_birth` date NOT NULL default '0000-00-00', `date_of_death` date NOT NULL default '0000-00-00', `player_external_id` varchar(50) NOT NULL DEFAULT '', `photo` varchar(250) NOT NULL DEFAULT '', `photo_sm` varchar(200) NOT NULL DEFAULT '', PRIMARY KEY (player_id), KEY `position` (`position`), KEY `team_id` (`team_id`), KEY `national_team` (`national_team`), KEY `nationality` (`nationality`) ) $charset_collate; CREATE TABLE wp_anwpfl_missing_players ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `match_id` bigint(20) UNSIGNED NOT NULL, `player_id` bigint(20) UNSIGNED NOT NULL, `club_id` bigint(20) UNSIGNED NOT NULL, `reason` varchar(20) NOT NULL DEFAULT '', `comment` text NOT NULL, PRIMARY KEY (`id`), KEY `match_id` (`match_id`), KEY `player_id` (`player_id`), KEY `club_id` (`club_id`) ) $charset_collate; CREATE TABLE wp_anwpfl_players_manual_stats ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `player_id` bigint(20) UNSIGNED NOT NULL, `season_id` bigint(20) UNSIGNED NOT NULL, `competition_id` bigint(20) UNSIGNED NOT NULL, `competition_text` varchar(200) NOT NULL DEFAULT '', `competition_type` varchar(10) NOT NULL DEFAULT '', `played` smallint(8) UNSIGNED NOT NULL DEFAULT '0', `started` smallint(8) UNSIGNED NOT NULL DEFAULT '0', `sub_in` smallint(8) UNSIGNED NOT NULL DEFAULT '0', `minutes` smallint(8) UNSIGNED NOT NULL DEFAULT '0', `card_y` smallint(8) UNSIGNED NOT NULL DEFAULT '0', `card_yr` smallint(8) UNSIGNED NOT NULL DEFAULT '0', `card_r` smallint(8) UNSIGNED NOT NULL DEFAULT '0', `goals` smallint(8) UNSIGNED NOT NULL DEFAULT '0', `goals_penalty` smallint(8) UNSIGNED NOT NULL DEFAULT '0', `assists` smallint(8) UNSIGNED NOT NULL DEFAULT '0', `own_goals` smallint(8) UNSIGNED NOT NULL DEFAULT '0', `goals_conceded` smallint(8) UNSIGNED NOT NULL DEFAULT '0', `clean_sheets` smallint(8) UNSIGNED NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `player_id` (`player_id`), KEY `season_id` (`season_id`) ) $charset_collate; CREATE TABLE wp_anwpfl_lineups ( `match_id` bigint(20) UNSIGNED NOT NULL, `home_line_up` varchar(1500) DEFAULT '' NOT NULL, `away_line_up` varchar(1500) DEFAULT '' NOT NULL, `home_subs` varchar(1000) DEFAULT '' NOT NULL, `away_subs` varchar(1000) DEFAULT '' NOT NULL, `custom_numbers` text NOT NULL, `captain_home` varchar(100) NOT NULL DEFAULT '', `captain_away` varchar(100) NOT NULL DEFAULT '', PRIMARY KEY (`match_id`) ) $charset_collate; CREATE TABLE wp_anwpfl_clubs ( club_id bigint(20) UNSIGNED NOT NULL, title varchar(200) NOT NULL DEFAULT '', post_name varchar(200) NOT NULL DEFAULT '', abbr varchar(50) NOT NULL DEFAULT '', city varchar(200) NOT NULL DEFAULT '', nationality varchar(50) NOT NULL DEFAULT '', stadium_id bigint(20) UNSIGNED NOT NULL DEFAULT '0', is_national_team tinyint(1) UNSIGNED NOT NULL DEFAULT '0', club_duplicates tinyint(1) UNSIGNED NOT NULL DEFAULT '0', club_external_id varchar(50) NOT NULL DEFAULT '', subteams varchar(20) NOT NULL DEFAULT '', root_team bigint(20) UNSIGNED NOT NULL DEFAULT '0', root_type varchar(20) NOT NULL DEFAULT '', logo varchar(500) NOT NULL DEFAULT '', logo_id bigint(20) UNSIGNED NOT NULL DEFAULT '0', logo_big varchar(500) NOT NULL DEFAULT '', logo_big_id bigint(20) UNSIGNED NOT NULL DEFAULT '0', main_color varchar(20) NOT NULL DEFAULT '', club_details longtext NOT NULL, club_social longtext NOT NULL, club_custom longtext NOT NULL, description longtext NOT NULL, custom_content_below longtext NOT NULL, squad text NOT NULL, squad_staff text NOT NULL, squad_seasons longtext NOT NULL, squad_staff_seasons longtext NOT NULL, squad_group tinyint(1) UNSIGNED NOT NULL DEFAULT '1', PRIMARY KEY (club_id), KEY nationality (nationality), KEY stadium_id (stadium_id), KEY is_national_team (is_national_team), KEY club_external_id (club_external_id), KEY root_team (root_team) ) $charset_collate; CREATE TABLE wp_anwpfl_competitions ( `competition_id` bigint(20) UNSIGNED NOT NULL, `title` varchar(200) NOT NULL DEFAULT '', `post_name` varchar(200) NOT NULL DEFAULT '', `league_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0', `league_text` varchar(200) NOT NULL DEFAULT '', `season_ids` varchar(200) NOT NULL DEFAULT '', `season_text` varchar(500) NOT NULL DEFAULT '', `type` varchar(20) NOT NULL DEFAULT '', `format_robin` varchar(20) NOT NULL DEFAULT '', `format_knockout` varchar(20) NOT NULL DEFAULT '', `is_friendly` tinyint(1) UNSIGNED NOT NULL DEFAULT '0', `multistage` varchar(20) NOT NULL DEFAULT '', `multistage_main` bigint(20) UNSIGNED NOT NULL DEFAULT '0', `stage_title` varchar(200) NOT NULL DEFAULT '', `stage_order` tinyint(3) UNSIGNED NOT NULL DEFAULT '0', `competition_order` smallint(5) UNSIGNED NOT NULL DEFAULT '0', `logo` varchar(500) NOT NULL DEFAULT '', `logo_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0', `logo_big` varchar(500) NOT NULL DEFAULT '', `logo_big_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0', `tmpl_layout` varchar(20) NOT NULL DEFAULT '', `group_next_id` smallint(5) UNSIGNED NOT NULL DEFAULT '0', `round_next_id` smallint(5) UNSIGNED NOT NULL DEFAULT '0', `stage_groups` text NOT NULL, `stage_rounds` text NOT NULL, `custom_content_below` longtext NOT NULL, PRIMARY KEY (`competition_id`), KEY `multistage_main` (`multistage_main`), KEY `competition_order` (`competition_order`), KEY `league_id` (`league_id`) ) $charset_collate; CREATE TABLE wp_anwpfl_standings ( `standing_id` bigint(20) UNSIGNED NOT NULL, `competition_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0', `group_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0', `points_win` tinyint(3) NOT NULL DEFAULT '3', `points_draw` tinyint(3) NOT NULL DEFAULT '1', `points_loss` tinyint(3) NOT NULL DEFAULT '0', `ranking_rules` varchar(500) NOT NULL DEFAULT '', `h2h_apply_after_all_games` tinyint(1) UNSIGNED NOT NULL DEFAULT '0', `manual_ordering` tinyint(1) UNSIGNED NOT NULL DEFAULT '0', `is_initial_data_active` tinyint(1) UNSIGNED NOT NULL DEFAULT '0', `last_recalc` datetime DEFAULT NULL, `last_round` smallint(5) UNSIGNED NOT NULL DEFAULT '0', `table_notes` text NOT NULL, `table_colors` text NOT NULL, `points_initial` text NOT NULL, `table_initial` longtext NOT NULL, `table_main` longtext NOT NULL, PRIMARY KEY (`standing_id`), KEY `competition_group` (`competition_id`, `group_id`) ) $charset_collate; "; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; // Skip dbDelta when every expected column + named index is already in // the live schema. Avoids cosmetic "Duplicate column/key name" warnings // on re-upgrade over an already-migrated database (e.g. clone from // production). Silent-failure catalog #29. Phase 4 of beta-5 cleanup. if ( ! self::dbdelta_schema_is_present( $sql ) ) { dbDelta( $sql );

Safe to delete?

How to remove this table

DROP TABLE IF EXISTS `wp_anwpfl_matches`;

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

Other tables from AnWP Football Leagues