# Generated by Django 2.0.2 on 2018-02-09 17:19

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


class Migration(migrations.Migration):

    initial = True

    dependencies = [
        ('leagues', '0007_auto_20180208_1911'),
        migrations.swappable_dependency(settings.AUTH_USER_MODEL),
    ]

    operations = [
        migrations.CreateModel(
            name='BatterProjection',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name', models.CharField(max_length=200)),
                ('normalized_first_name', models.CharField(max_length=200)),
                ('last_name', models.CharField(max_length=200)),
                ('team', models.CharField(max_length=200)),
                ('pos', models.CharField(max_length=200)),
                ('status', models.CharField(max_length=200)),
                ('last_modified', models.DateTimeField(auto_now=True)),
                ('category', models.CharField(max_length=200)),
                ('ab', models.FloatField()),
                ('r', models.FloatField()),
                ('hr', models.FloatField()),
                ('rbi', models.FloatField()),
                ('sb', models.FloatField()),
                ('avg', models.FloatField()),
                ('ops', models.FloatField()),
                ('zScoreR', models.FloatField()),
                ('zScoreHr', models.FloatField()),
                ('zScoreRbi', models.FloatField()),
                ('zScoreSb', models.FloatField()),
                ('zScoreAvg', models.FloatField()),
                ('zScoreOps', models.FloatField()),
                ('weightedR', models.FloatField()),
                ('weightedHr', models.FloatField()),
                ('weightedRbi', models.FloatField()),
                ('weightedSb', models.FloatField()),
                ('weightedAvg', models.FloatField()),
                ('weightedOps', models.FloatField()),
                ('weightedZscoreR', models.FloatField()),
                ('weightedZscoreHr', models.FloatField()),
                ('weightedZscoreRbi', models.FloatField()),
                ('weightedZscoreSb', models.FloatField()),
                ('weightedZscoreAvg', models.FloatField()),
                ('weightedZscoreOps', models.FloatField()),
                ('fvaaz', models.FloatField()),
                ('dollarValue', models.FloatField()),
                ('keeper', models.FloatField(default=0.0)),
                ('isFA', models.BooleanField(default=False)),
            ],
        ),
        migrations.CreateModel(
            name='BatterValue',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name', models.CharField(max_length=200)),
                ('normalized_first_name', models.CharField(max_length=200)),
                ('last_name', models.CharField(max_length=200)),
                ('team', models.CharField(max_length=200)),
                ('pos', models.CharField(max_length=200)),
                ('last_modified', models.DateTimeField(auto_now=True)),
                ('category', models.CharField(max_length=200)),
                ('league_key', models.CharField(max_length=200)),
                ('yahoo_guid', models.CharField(max_length=200)),
                ('zScoreR', models.FloatField()),
                ('zScoreHr', models.FloatField()),
                ('zScoreRbi', models.FloatField()),
                ('zScoreSb', models.FloatField()),
                ('zScoreAvg', models.FloatField()),
                ('zScoreOps', models.FloatField()),
                ('weightedR', models.FloatField()),
                ('weightedHr', models.FloatField()),
                ('weightedRbi', models.FloatField()),
                ('weightedSb', models.FloatField()),
                ('weightedAvg', models.FloatField()),
                ('weightedOps', models.FloatField()),
                ('weightedZscoreR', models.FloatField()),
                ('weightedZscoreHr', models.FloatField()),
                ('weightedZscoreRbi', models.FloatField()),
                ('weightedZscoreSb', models.FloatField()),
                ('weightedZscoreAvg', models.FloatField()),
                ('weightedZscoreOps', models.FloatField()),
                ('fvaaz', models.FloatField()),
                ('dollarValue', models.FloatField()),
                ('keeper', models.FloatField(default=0.0)),
                ('isFA', models.BooleanField(default=False)),
                ('batter', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='projections.BatterProjection')),
                ('league', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='leagues.League')),
                ('user', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)),
            ],
        ),
        migrations.CreateModel(
            name='PitcherProjection',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name', models.CharField(max_length=200)),
                ('normalized_first_name', models.CharField(max_length=200)),
                ('last_name', models.CharField(max_length=200)),
                ('team', models.CharField(max_length=200)),
                ('pos', models.CharField(max_length=200)),
                ('is_sp', models.BooleanField()),
                ('status', models.CharField(max_length=200)),
                ('last_modified', models.DateTimeField(auto_now=True)),
                ('category', models.CharField(max_length=200)),
                ('ip', models.FloatField()),
                ('win', models.FloatField()),
                ('sv', models.FloatField()),
                ('k', models.FloatField()),
                ('era', models.FloatField()),
                ('whip', models.FloatField()),
                ('kip', models.FloatField()),
                ('winsip', models.FloatField()),
                ('zScoreW', models.FloatField()),
                ('zScoreSv', models.FloatField()),
                ('zScoreK', models.FloatField()),
                ('zScoreEra', models.FloatField()),
                ('zScoreWhip', models.FloatField()),
                ('weightedW', models.FloatField()),
                ('weightedSv', models.FloatField()),
                ('weightedK', models.FloatField()),
                ('weightedEra', models.FloatField()),
                ('weightedWhip', models.FloatField()),
                ('weightedZscoreW', models.FloatField()),
                ('weightedZscoreSv', models.FloatField()),
                ('weightedZscoreK', models.FloatField()),
                ('weightedZscoreEra', models.FloatField()),
                ('weightedZscoreWhip', models.FloatField()),
                ('fvaaz', models.FloatField()),
                ('dollarValue', models.FloatField()),
                ('keeper', models.FloatField(default=0.0)),
                ('isFA', models.BooleanField(default=False)),
            ],
        ),
        migrations.CreateModel(
            name='PitcherValue',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name', models.CharField(max_length=200)),
                ('normalized_first_name', models.CharField(max_length=200)),
                ('last_name', models.CharField(max_length=200)),
                ('team', models.CharField(max_length=200)),
                ('pos', models.CharField(max_length=200)),
                ('last_modified', models.DateTimeField(auto_now=True)),
                ('category', models.CharField(max_length=200)),
                ('league_key', models.CharField(max_length=200)),
                ('yahoo_guid', models.CharField(max_length=200)),
                ('zScoreW', models.FloatField()),
                ('zScoreSv', models.FloatField()),
                ('zScoreK', models.FloatField()),
                ('zScoreEra', models.FloatField()),
                ('zScoreWhip', models.FloatField()),
                ('weightedW', models.FloatField()),
                ('weightedSv', models.FloatField()),
                ('weightedK', models.FloatField()),
                ('weightedEra', models.FloatField()),
                ('weightedWhip', models.FloatField()),
                ('weightedZscoreW', models.FloatField()),
                ('weightedZscoreSv', models.FloatField()),
                ('weightedZscoreK', models.FloatField()),
                ('weightedZscoreEra', models.FloatField()),
                ('weightedZscoreWhip', models.FloatField()),
                ('fvaaz', models.FloatField()),
                ('dollarValue', models.FloatField()),
                ('keeper', models.FloatField(default=0.0)),
                ('isFA', models.BooleanField(default=False)),
                ('league', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='leagues.League')),
                ('pitcher', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='projections.PitcherProjection')),
                ('user', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)),
            ],
        ),
    ]
