# -*- coding: utf-8 -*-
# Generated by Django 1.10.2 on 2016-10-27 00:33
from __future__ import unicode_literals

from django.db import migrations, models
import django.db.models.deletion


class Migration(migrations.Migration):

    initial = True

    dependencies = [
    ]

    operations = [
        migrations.CreateModel(
            name='Batting',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('year_code', models.CharField(blank=True, max_length=50, null=True)),
                ('stint', models.CharField(blank=True, max_length=50, null=True)),
                ('team_code', models.CharField(blank=True, max_length=50, null=True)),
                ('league_code', models.CharField(blank=True, max_length=50, null=True)),
                ('games', models.CharField(blank=True, max_length=50, null=True)),
                ('at_bats', models.CharField(blank=True, max_length=50, null=True)),
                ('runs', models.CharField(blank=True, max_length=50, null=True)),
                ('hits', models.CharField(blank=True, max_length=50, null=True)),
                ('doubles', models.CharField(blank=True, max_length=50, null=True)),
                ('triples', models.CharField(blank=True, max_length=50, null=True)),
                ('homeruns', models.CharField(blank=True, max_length=50, null=True)),
                ('runs_batted_in', models.CharField(blank=True, max_length=50, null=True)),
                ('stolen_bases', models.CharField(blank=True, max_length=50, null=True)),
                ('caught_stealing', models.CharField(blank=True, max_length=50, null=True)),
                ('walks', models.CharField(blank=True, max_length=50, null=True)),
                ('strikeouts', models.CharField(blank=True, max_length=50, null=True)),
                ('intentional_walks', models.CharField(blank=True, max_length=50, null=True)),
                ('hit_by_pitch', models.CharField(blank=True, max_length=50, null=True)),
                ('sacrifice_hits', models.CharField(blank=True, max_length=50, null=True)),
                ('sacrifice_flies', models.CharField(blank=True, max_length=50, null=True)),
                ('grounded_into_double_plays', models.CharField(blank=True, max_length=50, null=True)),
            ],
        ),
        migrations.CreateModel(
            name='Fielding',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('year_code', models.CharField(blank=True, max_length=50, null=True)),
                ('stint', models.CharField(blank=True, max_length=50, null=True)),
                ('team_code', models.CharField(blank=True, max_length=50, null=True)),
                ('league_code', models.CharField(blank=True, max_length=50, null=True)),
                ('position', models.CharField(blank=True, max_length=50, null=True)),
                ('games', models.CharField(blank=True, max_length=50, null=True)),
                ('games_started', models.CharField(blank=True, max_length=50, null=True)),
                ('inn_outs', models.CharField(blank=True, max_length=50, null=True)),
                ('putouts', models.CharField(blank=True, max_length=50, null=True)),
                ('assists', models.CharField(blank=True, max_length=50, null=True)),
                ('errors', models.CharField(blank=True, max_length=50, null=True)),
                ('double_plays', models.CharField(blank=True, max_length=50, null=True)),
                ('passed_balls', models.CharField(blank=True, max_length=50, null=True)),
                ('wild_pitches', models.CharField(blank=True, max_length=50, null=True)),
                ('opp_stolen_bases', models.CharField(blank=True, max_length=50, null=True)),
                ('opp_caught_stealing', models.CharField(blank=True, max_length=50, null=True)),
                ('zone_rating', models.CharField(blank=True, max_length=50, null=True)),
            ],
        ),
        migrations.CreateModel(
            name='Master',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('player_code', models.CharField(blank=True, max_length=50, null=True)),
                ('birth_year', models.CharField(blank=True, max_length=50, null=True)),
                ('birth_month', models.CharField(blank=True, max_length=50, null=True)),
                ('birth_day', models.CharField(blank=True, max_length=50, null=True)),
                ('birth_country', models.CharField(blank=True, max_length=50, null=True)),
                ('birth_state', models.CharField(blank=True, max_length=50, null=True)),
                ('birth_city', models.CharField(blank=True, max_length=50, null=True)),
                ('death_year', models.CharField(blank=True, max_length=50, null=True)),
                ('death_month', models.CharField(blank=True, max_length=50, null=True)),
                ('death_day', models.CharField(blank=True, max_length=50, null=True)),
                ('death_country', models.CharField(blank=True, max_length=50, null=True)),
                ('death_state', models.CharField(blank=True, max_length=50, null=True)),
                ('death_city', models.CharField(blank=True, max_length=50, null=True)),
                ('name_first', models.CharField(blank=True, max_length=50, null=True)),
                ('name_last', models.CharField(blank=True, max_length=50, null=True)),
                ('name_given', models.CharField(blank=True, max_length=50, null=True)),
                ('weight', models.CharField(blank=True, max_length=50, null=True)),
                ('height', models.CharField(blank=True, max_length=50, null=True)),
                ('bats', models.CharField(blank=True, max_length=50, null=True)),
                ('throws', models.CharField(blank=True, max_length=50, null=True)),
                ('debut', models.CharField(blank=True, max_length=50, null=True)),
                ('final_game', models.CharField(blank=True, max_length=50, null=True)),
                ('retro_code', models.CharField(blank=True, max_length=50, null=True)),
                ('bbref_code', models.CharField(blank=True, max_length=50, null=True)),
            ],
        ),
        migrations.CreateModel(
            name='Pitching',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('year_code', models.CharField(blank=True, max_length=50, null=True)),
                ('stint', models.CharField(blank=True, max_length=50, null=True)),
                ('team_code', models.CharField(blank=True, max_length=50, null=True)),
                ('league_code', models.CharField(blank=True, max_length=50, null=True)),
                ('wins', models.CharField(blank=True, max_length=50, null=True)),
                ('losses', models.CharField(blank=True, max_length=50, null=True)),
                ('games', models.CharField(blank=True, max_length=50, null=True)),
                ('games_started', models.CharField(blank=True, max_length=50, null=True)),
                ('completed_games', models.CharField(blank=True, max_length=50, null=True)),
                ('shutouts', models.CharField(blank=True, max_length=50, null=True)),
                ('saves', models.CharField(blank=True, max_length=50, null=True)),
                ('outs_pitched', models.CharField(blank=True, max_length=50, null=True)),
                ('hits', models.CharField(blank=True, max_length=50, null=True)),
                ('earned_runs', models.CharField(blank=True, max_length=50, null=True)),
                ('homeruns', models.CharField(blank=True, max_length=50, null=True)),
                ('walks', models.CharField(blank=True, max_length=50, null=True)),
                ('strikeouts', models.CharField(blank=True, max_length=50, null=True)),
                ('opponent_batting_average', models.CharField(blank=True, max_length=50, null=True)),
                ('earned_run_average', models.CharField(blank=True, max_length=50, null=True)),
                ('intentional_walks', models.CharField(blank=True, max_length=50, null=True)),
                ('wild_pitches', models.CharField(blank=True, max_length=50, null=True)),
                ('batters_hit_by_pitch', models.CharField(blank=True, max_length=50, null=True)),
                ('balks', models.CharField(blank=True, max_length=50, null=True)),
                ('batters_faced_by_pitcher', models.CharField(blank=True, max_length=50, null=True)),
                ('games_finished', models.CharField(blank=True, max_length=50, null=True)),
                ('runs_allowed', models.CharField(blank=True, max_length=50, null=True)),
                ('sacrifices_by_opp_batters', models.CharField(blank=True, max_length=50, null=True)),
                ('sacrifice_flies_by_opp_batters', models.CharField(blank=True, max_length=50, null=True)),
                ('grounded_into_double_plays_by_opp_batters', models.CharField(blank=True, max_length=50, null=True)),
                ('player_code', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='baseball_api_app.Master')),
            ],
        ),
        migrations.AddField(
            model_name='fielding',
            name='player_code',
            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='baseball_api_app.Master'),
        ),
        migrations.AddField(
            model_name='batting',
            name='player_code',
            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='baseball_api_app.Master'),
        ),
    ]
