# Generated by Django 5.2 on 2026-03-07 17:15

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


class Migration(migrations.Migration):

    initial = True

    dependencies = [
    ]

    operations = [
        migrations.CreateModel(
            name='Goals',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('game_id_id', models.IntegerField(blank=True, null=True)),
                ('minute', models.IntegerField(blank=True, null=True)),
                ('penalty_kick', models.IntegerField(blank=True, null=True)),
                ('player_id', models.TextField(blank=True, null=True)),
                ('team_id', models.IntegerField(blank=True, null=True)),
                ('year', models.TextField(blank=True, null=True)),
            ],
            options={
                'db_table': 'goals',
                'managed': False,
            },
        ),
        migrations.CreateModel(
            name='Keepergames',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('game_id_id', models.IntegerField(blank=True, null=True)),
                ('goals', models.IntegerField(blank=True, null=True)),
                ('minutes', models.IntegerField(blank=True, null=True)),
                ('player_id', models.TextField(blank=True, null=True)),
                ('team_id', models.IntegerField(blank=True, null=True)),
                ('year', models.TextField(blank=True, null=True)),
                ('win', models.IntegerField(blank=True, null=True)),
                ('draw', models.IntegerField(blank=True, null=True)),
                ('loss', models.IntegerField(blank=True, null=True)),
            ],
            options={
                'db_table': 'keepergames',
                'managed': False,
            },
        ),
        migrations.CreateModel(
            name='Penaltyshootout',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('game_id_id', models.IntegerField(blank=True, null=True)),
                ('goal', models.IntegerField(blank=True, null=True)),
                ('keeper_id', models.TextField(blank=True, null=True)),
                ('keeper_team_id', models.IntegerField(blank=True, null=True)),
                ('order', models.IntegerField(blank=True, null=True)),
                ('player_id', models.TextField(blank=True, null=True)),
                ('player_team_id', models.IntegerField(blank=True, null=True)),
                ('year', models.TextField(blank=True, null=True)),
            ],
            options={
                'db_table': 'penaltyshootout',
                'managed': False,
            },
        ),
        migrations.CreateModel(
            name='Playerregister',
            fields=[
                ('cityofbirth', models.TextField(blank=True, db_column='cityOfBirth', null=True)),
                ('countryofbirth', models.TextField(blank=True, db_column='countryOfBirth', null=True)),
                ('dayofbirth', models.IntegerField(blank=True, db_column='dayOfBirth', null=True)),
                ('firstname', models.TextField(blank=True, db_column='firstName', null=True)),
                ('height', models.IntegerField(blank=True, null=True)),
                ('jerseynumber', models.IntegerField(blank=True, db_column='jerseyNumber', null=True)),
                ('lastname', models.TextField(blank=True, db_column='lastName', null=True)),
                ('monthofbirth', models.IntegerField(blank=True, db_column='monthOfBirth', null=True)),
                ('position', models.TextField(blank=True, null=True)),
                ('player_id', models.CharField(max_length=15, primary_key=True, serialize=False)),
                ('weight', models.IntegerField(blank=True, null=True)),
                ('yearofbirth', models.IntegerField(blank=True, db_column='yearOfBirth', null=True)),
                ('stateofbirth', models.TextField(blank=True, db_column='stateOfBirth', null=True)),
                ('nickname', models.TextField(blank=True, db_column='nickName', null=True)),
            ],
            options={
                'db_table': 'playerregister',
                'managed': False,
            },
        ),
        migrations.CreateModel(
            name='Playerteamseason',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('register_id', models.TextField(blank=True, null=True)),
                ('team_id', models.IntegerField(blank=True, null=True)),
                ('year', models.TextField(blank=True, null=True)),
            ],
            options={
                'db_table': 'playerteamseason',
                'managed': False,
            },
        ),
        migrations.CreateModel(
            name='Reallifeconference',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name', models.TextField(blank=True, null=True)),
            ],
            options={
                'db_table': 'reallifeconference',
                'managed': False,
            },
        ),
        migrations.CreateModel(
            name='Reallifekeeper',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name', models.TextField(blank=True, null=True)),
                ('player_id', models.TextField(blank=True, null=True)),
                ('team', models.TextField(blank=True, null=True)),
                ('team_id', models.IntegerField(blank=True, null=True)),
            ],
            options={
                'db_table': 'reallifekeeper',
                'managed': False,
            },
        ),
        migrations.CreateModel(
            name='Reallifeplayer',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name', models.TextField(blank=True, null=True)),
                ('player_id', models.TextField(blank=True, null=True)),
            ],
            options={
                'db_table': 'reallifeplayer',
                'managed': False,
            },
        ),
        migrations.CreateModel(
            name='Reallifeteam',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('abbrev', models.TextField(blank=True, null=True)),
                ('conf_id', models.IntegerField(blank=True, null=True)),
                ('name', models.TextField(blank=True, null=True)),
            ],
            options={
                'db_table': 'reallifeteam',
                'managed': False,
            },
        ),
        migrations.CreateModel(
            name='Redcard',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('game_id_id', models.IntegerField(blank=True, null=True)),
                ('minute', models.IntegerField(blank=True, null=True)),
                ('player_id', models.TextField(blank=True, null=True)),
                ('team_id', models.IntegerField(blank=True, null=True)),
                ('two_yellows', models.IntegerField(blank=True, null=True)),
                ('year', models.TextField(blank=True, null=True)),
            ],
            options={
                'db_table': 'redcard',
                'managed': False,
            },
        ),
        migrations.CreateModel(
            name='Regulationpenalty',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('game_id_id', models.IntegerField(blank=True, null=True)),
                ('goal', models.IntegerField(blank=True, null=True)),
                ('keeper_id', models.TextField(blank=True, null=True)),
                ('keeper_team_id', models.IntegerField(blank=True, null=True)),
                ('minute', models.IntegerField(blank=True, null=True)),
                ('player_id', models.TextField(blank=True, null=True)),
                ('player_team_id', models.IntegerField(blank=True, null=True)),
                ('year', models.TextField(blank=True, null=True)),
            ],
            options={
                'db_table': 'regulationpenalty',
                'managed': False,
            },
        ),
        migrations.CreateModel(
            name='Replayedgame',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('away_id', models.IntegerField(blank=True, null=True)),
                ('away_score', models.IntegerField(blank=True, null=True)),
                ('date', models.TextField(blank=True, null=True)),
                ('home_id', models.IntegerField(blank=True, null=True)),
                ('home_score', models.IntegerField(blank=True, null=True)),
                ('year', models.TextField(blank=True, null=True)),
            ],
            options={
                'db_table': 'replayedgame',
                'managed': False,
            },
        ),
        migrations.CreateModel(
            name='Season',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name', models.TextField(blank=True, null=True)),
                ('year_code', models.TextField(blank=True, null=True)),
            ],
            options={
                'db_table': 'season',
                'managed': False,
            },
        ),
        migrations.CreateModel(
            name='Teamseason',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('abbrev', models.TextField(blank=True, null=True)),
                ('conf_id', models.IntegerField(blank=True, null=True)),
                ('goals', models.IntegerField(blank=True, null=True)),
                ('goals_against', models.IntegerField(blank=True, null=True)),
                ('losses', models.IntegerField(blank=True, null=True)),
                ('name', models.TextField(blank=True, null=True)),
                ('nickname', models.TextField(blank=True, null=True)),
                ('shootout_wins', models.IntegerField(blank=True, null=True)),
                ('stadium', models.TextField(blank=True, null=True)),
                ('team_id', models.IntegerField(blank=True, null=True)),
                ('wins', models.IntegerField(blank=True, null=True)),
                ('year', models.CharField(blank=True, max_length=10, null=True)),
            ],
            options={
                'db_table': 'teamseason',
                'managed': False,
            },
        ),
        migrations.CreateModel(
            name='Yellowcard',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('game_id_id', models.IntegerField(blank=True, null=True)),
                ('minute', models.IntegerField(blank=True, null=True)),
                ('player_id', models.TextField(blank=True, null=True)),
                ('second_yellow', models.IntegerField(blank=True, null=True)),
                ('team_id', models.IntegerField(blank=True, null=True)),
                ('year', models.TextField(blank=True, null=True)),
            ],
            options={
                'db_table': 'yellowcard',
                'managed': False,
            },
        ),
        migrations.CreateModel(
            name='PlayoffBracket',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('year_code', models.CharField(max_length=10, unique=True)),
            ],
            options={
                'db_table': 'playoff_bracket',
            },
        ),
        migrations.CreateModel(
            name='PlayoffSeries',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('round', models.IntegerField(help_text='1 = first round, 2 = semis, 3 = final, etc.')),
                ('label', models.CharField(blank=True, default='', help_text="E.g. 'Eastern Conference Semifinal'", max_length=60)),
                ('home_team_id', models.IntegerField(blank=True, null=True)),
                ('away_team_id', models.IntegerField(blank=True, null=True)),
                ('home_seed', models.IntegerField(blank=True, null=True)),
                ('away_seed', models.IntegerField(blank=True, null=True)),
                ('winner_team_id', models.IntegerField(blank=True, null=True)),
                ('next_series_slot', models.CharField(blank=True, default='', help_text="'home' or 'away' — which slot the winner fills in next_series", max_length=4)),
                ('bracket', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='series', to='stats.playoffbracket')),
                ('next_series', models.ForeignKey(blank=True, help_text='Series the winner advances to', null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='previous_series', to='stats.playoffseries')),
            ],
            options={
                'db_table': 'playoff_series',
                'ordering': ['round', 'id'],
            },
        ),
        migrations.CreateModel(
            name='PlayoffGame',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('game_number', models.IntegerField()),
                ('home_score', models.IntegerField()),
                ('away_score', models.IntegerField()),
                ('series', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='games', to='stats.playoffseries')),
            ],
            options={
                'db_table': 'playoff_game',
                'ordering': ['game_number'],
            },
        ),
    ]