| mchris41 |
03-01-2017 01:07 PM |
This also happens when exporting SQL.
Code:
CREATE TABLE IF NOT EXISTS `coaches` (`coach_id` INT, `first_name` VARCHAR(50), `last_name` VARCHAR(50), `nick_name` VARCHAR(50), `age` SMALLINT, `date_of_birth` DATE, `city_of_birth_id` INT, `nation_id` INT, `weight` SMALLINT, `height` SMALLINT, `position` SMALLINT, `experience` SMALLINT, `occupation` SMALLINT, `team_id` INT, `former_player_id` INT, `quick_left` SMALLINT, `contract_salary` INT, `contract_years` SMALLINT, `contract_extension_salary` INT, `contract_extension_years` SMALLINT, `scout_major` SMALLINT, `scout_minor` SMALLINT, `scout_international` SMALLINT, `scout_amateur` SMALLINT, `scout_amateur_preference` SMALLINT, `teach_hitting` SMALLINT, `teach_pitching` SMALLINT, `teach_fielding` SMALLINT, `handle_veterans` SMALLINT, `handle_rookies` SMALLINT, `handle_players` SMALLINT, `strategy_knowledge` SMALLINT, `heal_legs` SMALLINT, `heal_arms` SMALLINT, `heal_back` SMALLINT, `heal_other` SMALLINT, `heal_rest` SMALLINT, `management_style` SMALLINT, `personality` SMALLINT, `hitting_focus` SMALLINT, `pitching_focus` SMALLINT, `training_focus` SMALLINT, `teach_running` SMALLINT, `prevent_legs` SMALLINT, `prevent_arms` SMALLINT, `prevent_back` SMALLINT, `prevent_other` SMALLINT, `stealing` INT, `running` INT, `pinchrun` INT, `pinchhit_pos` INT, `pinchhit_pitch` INT, `hook_start` INT, `hook_relief` INT, `closer` INT, `lr_matchup` INT, `bunt_hit` INT, `bunt` INT, `hit_run` INT, `run_hit` INT, `squeeze` INT, `pitch_around` INT, `intentional_walk` INT, `hold_runner` INT, `guard_lines` INT, `infield_in` INT, `outfield_in` INT, `corners_in` INT, `shift_if` INT, `shift_of` INT, `num_pitchers` SMALLINT, `num_hitters` SMALLINT, `favor_speed_to_power` INT, `favor_avg_to_obp` INT, `favor_defense_to_offense` INT, `favor_pitching_to_hitting` INT, `favor_veterans_to_prospects` INT, `trade_aggressiveness` INT, `player_loyalty` INT, `trade_frequency` INT, `trade_preference` INT, `value_stats` INT, `value_this_year` INT, `value_last_year` INT, `value_two_years` INT, `draft_value` INT, `intl_fa_value` INT, `develop_value` INT, `scout_value` INT, `manager_value` SMALLINT, `pitching_coach_value` SMALLINT, `hitting_coach_value` SMALLINT, `scout_value` SMALLINT, `doctor_value` SMALLINT, `busy` TINYINT, `type` INT, `data` INT, `days_left` INT, PRIMARY KEY (`coach_id`));
|
