# Generated by Django 3.0.4 on 2020-06-09 10:50

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


class Migration(migrations.Migration):

    initial = True

    dependencies = [
        migrations.swappable_dependency(settings.AUTH_USER_MODEL),
    ]

    operations = [
        migrations.CreateModel(
            name='Lineup',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('group_set', models.CharField(max_length=250)),
                ('group_id', models.CharField(max_length=250, unique=True)),
                ('group_name', models.CharField(max_length=250)),
                ('team_id', models.CharField(max_length=250)),
                ('team_abreviation', models.CharField(max_length=250)),
                ('games_played', models.PositiveSmallIntegerField()),
                ('w', models.PositiveSmallIntegerField()),
                ('l', models.PositiveSmallIntegerField()),
                ('w_pct', models.DecimalField(decimal_places=3, max_digits=6)),
                ('min', models.DecimalField(decimal_places=3, max_digits=6)),
                ('e_off_rating', models.DecimalField(decimal_places=3, max_digits=6)),
                ('off_rating', models.DecimalField(decimal_places=3, max_digits=6)),
                ('e_def_rating', models.DecimalField(decimal_places=3, max_digits=6)),
                ('def_rating', models.DecimalField(decimal_places=3, max_digits=6)),
                ('e_net_rating', models.DecimalField(decimal_places=3, max_digits=6)),
                ('net_rating', models.DecimalField(decimal_places=3, max_digits=6)),
                ('ast_pct', models.DecimalField(decimal_places=3, max_digits=6)),
                ('ast_to', models.DecimalField(decimal_places=3, max_digits=6)),
                ('ast_ratio', models.DecimalField(decimal_places=3, max_digits=6)),
                ('oreb_pct', models.DecimalField(decimal_places=3, max_digits=6)),
                ('dreb_pct', models.DecimalField(decimal_places=3, max_digits=6)),
                ('reb_pct', models.DecimalField(decimal_places=3, max_digits=6)),
                ('tm_tov_pct', models.DecimalField(decimal_places=3, max_digits=6)),
                ('efg_pct', models.DecimalField(decimal_places=3, max_digits=6)),
                ('ts_pct', models.DecimalField(decimal_places=3, max_digits=6)),
                ('e_pace', models.DecimalField(decimal_places=3, max_digits=6)),
                ('pace', models.DecimalField(decimal_places=3, max_digits=6)),
                ('pace_per40', models.DecimalField(decimal_places=3, max_digits=6)),
                ('poss', models.PositiveSmallIntegerField()),
                ('pie', models.DecimalField(decimal_places=3, max_digits=6)),
            ],
            options={
                'verbose_name': 'Lineup',
                'verbose_name_plural': 'Lineups',
                'ordering': ['team_abreviation'],
            },
        ),
        migrations.CreateModel(
            name='Player',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('player_id', models.CharField(max_length=250, unique=True)),
                ('player_name', models.CharField(max_length=250)),
                ('team_id', models.CharField(max_length=250)),
                ('team_abr', models.CharField(max_length=250)),
                ('age', models.PositiveSmallIntegerField()),
                ('games_played', models.PositiveSmallIntegerField()),
                ('w', models.PositiveSmallIntegerField()),
                ('l', models.PositiveSmallIntegerField()),
                ('w_pct', models.DecimalField(decimal_places=3, max_digits=6)),
                ('min', models.DecimalField(decimal_places=3, max_digits=6)),
                ('e_off_rating', models.DecimalField(decimal_places=3, max_digits=6)),
                ('off_rating', models.DecimalField(decimal_places=3, max_digits=6)),
                ('e_def_rating', models.DecimalField(decimal_places=3, max_digits=6)),
                ('def_rating', models.DecimalField(decimal_places=3, max_digits=6)),
                ('e_net_rating', models.DecimalField(decimal_places=3, max_digits=6)),
                ('net_rating', models.DecimalField(decimal_places=3, max_digits=6)),
                ('ast_pct', models.DecimalField(decimal_places=3, max_digits=6)),
                ('ast_to', models.DecimalField(decimal_places=3, max_digits=6)),
                ('ast_ratio', models.DecimalField(decimal_places=3, max_digits=6)),
                ('oreb_pct', models.DecimalField(decimal_places=3, max_digits=6)),
                ('dreb_pct', models.DecimalField(decimal_places=3, max_digits=6)),
                ('reb_pct', models.DecimalField(decimal_places=3, max_digits=6)),
                ('tm_tov_pct', models.DecimalField(decimal_places=3, max_digits=6)),
                ('e_tov_pct', models.DecimalField(decimal_places=3, max_digits=6)),
                ('efg_pct', models.DecimalField(decimal_places=3, max_digits=6)),
                ('ts_pct', models.DecimalField(decimal_places=3, max_digits=6)),
                ('usg_pct', models.DecimalField(decimal_places=3, max_digits=6)),
                ('e_usg_pct', models.DecimalField(decimal_places=3, max_digits=6)),
                ('e_pace', models.DecimalField(decimal_places=3, max_digits=6)),
                ('pace', models.DecimalField(decimal_places=3, max_digits=6)),
                ('pace_per40', models.DecimalField(decimal_places=3, max_digits=6)),
                ('pie', models.DecimalField(decimal_places=3, max_digits=6)),
                ('poss', models.PositiveSmallIntegerField()),
                ('fgm', models.PositiveSmallIntegerField()),
                ('fga', models.PositiveSmallIntegerField()),
                ('fgm_pg', models.DecimalField(decimal_places=1, max_digits=6)),
                ('fga_pg', models.DecimalField(decimal_places=1, max_digits=6)),
                ('fg_pct', models.DecimalField(decimal_places=3, max_digits=6)),
            ],
            options={
                'verbose_name': 'Player',
                'verbose_name_plural': 'Player',
                'ordering': ['player_name'],
            },
        ),
        migrations.CreateModel(
            name='ShotPrediction',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('player', models.CharField(max_length=250)),
                ('home_score', models.PositiveSmallIntegerField()),
                ('away_score', models.PositiveSmallIntegerField()),
                ('time', models.PositiveSmallIntegerField()),
                ('is_home', models.BooleanField()),
                ('time_played', models.PositiveSmallIntegerField()),
                ('points_scored', models.PositiveSmallIntegerField()),
                ('created_at', models.DateTimeField(blank=True, default=django.utils.timezone.now, editable=False, verbose_name='Created at')),
                ('solucion', models.CharField(max_length=250)),
                ('probabilidad', models.CharField(max_length=250)),
                ('created_by', models.ForeignKey(blank=True, editable=False, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='shots_predicted', to=settings.AUTH_USER_MODEL)),
            ],
        ),
        migrations.CreateModel(
            name='Profile',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('user', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, related_name='profile', to=settings.AUTH_USER_MODEL)),
            ],
            options={
                'verbose_name': 'Profile',
                'verbose_name_plural': 'Profiles',
            },
        ),
        migrations.CreateModel(
            name='LineupStatisticsPrediction',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('efg_pct', models.DecimalField(decimal_places=3, max_digits=6)),
                ('ts_pct', models.DecimalField(decimal_places=3, max_digits=6)),
                ('pie', models.DecimalField(decimal_places=3, max_digits=6)),
                ('off_rating', models.DecimalField(decimal_places=3, max_digits=6)),
                ('created_at', models.DateTimeField(blank=True, default=django.utils.timezone.now, editable=False, verbose_name='Created at')),
                ('created_by', models.ForeignKey(blank=True, editable=False, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='lineup_statistics_predicted', to=settings.AUTH_USER_MODEL)),
            ],
        ),
        migrations.CreateModel(
            name='LineupsModelRating',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('max_off_rating', models.DecimalField(decimal_places=3, max_digits=6)),
                ('min_off_rating', models.DecimalField(decimal_places=3, max_digits=6)),
                ('avg_off_rating', models.DecimalField(decimal_places=3, max_digits=6)),
                ('max_def_rating', models.DecimalField(decimal_places=3, max_digits=6)),
                ('min_def_rating', models.DecimalField(decimal_places=3, max_digits=6)),
                ('avg_def_rating', models.DecimalField(decimal_places=3, max_digits=6)),
                ('max_net_rating', models.DecimalField(decimal_places=3, max_digits=6)),
                ('min_net_rating', models.DecimalField(decimal_places=3, max_digits=6)),
                ('avg_net_rating', models.DecimalField(decimal_places=3, max_digits=6)),
                ('created_at', models.DateTimeField(blank=True, default=django.utils.timezone.now, editable=False, verbose_name='Created at')),
                ('created_by', models.ForeignKey(blank=True, editable=False, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='lineups_model_ratings', to=settings.AUTH_USER_MODEL)),
            ],
        ),
        migrations.CreateModel(
            name='LineupPlayersPrediction',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('player1', models.CharField(max_length=250)),
                ('player2', models.CharField(max_length=250)),
                ('player3', models.CharField(max_length=250)),
                ('player4', models.CharField(max_length=250)),
                ('player5', models.CharField(max_length=250)),
                ('off_rating', models.DecimalField(decimal_places=3, max_digits=6)),
                ('created_at', models.DateTimeField(blank=True, default=django.utils.timezone.now, editable=False, verbose_name='Created at')),
                ('created_by', models.ForeignKey(blank=True, editable=False, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='lineup_player_predicted', to=settings.AUTH_USER_MODEL)),
            ],
        ),
    ]
