# Generated by Django 2.2.12 on 2021-11-23 19:35

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


class Migration(migrations.Migration):

    initial = True

    dependencies = [
        ('otree', '0001_initial'),
    ]

    operations = [
        migrations.CreateModel(
            name='Group',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('id_in_subsession', otree.db.models.PositiveIntegerField(db_index=True, null=True)),
                ('round_number', otree.db.models.PositiveIntegerField(db_index=True, null=True)),
                ('session', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='cost_reporting_task_ss_group', to='otree.Session')),
            ],
            options={
                'db_table': 'cost_reporting_task_ss_group',
            },
            bases=(models.Model, otree.db.idmap.GroupIDMapMixin),
        ),
        migrations.CreateModel(
            name='Subsession',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('round_number', otree.db.models.PositiveIntegerField(db_index=True, null=True)),
                ('session', models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, related_name='cost_reporting_task_ss_subsession', to='otree.Session')),
            ],
            options={
                'db_table': 'cost_reporting_task_ss_subsession',
            },
            bases=(models.Model, otree.db.idmap.SubsessionIDMapMixin),
        ),
        migrations.CreateModel(
            name='Player',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('id_in_group', otree.db.models.PositiveIntegerField(db_index=True, null=True)),
                ('_payoff', otree.db.models.CurrencyField(default=0, null=True)),
                ('round_number', otree.db.models.PositiveIntegerField(db_index=True, null=True)),
                ('_role', otree.db.models.StringField(max_length=10000, null=True)),
                ('firm_id', otree.db.models.IntegerField(null=True)),
                ('condition', otree.db.models.IntegerField(null=True)),
                ('type', otree.db.models.IntegerField(null=True)),
                ('partner_id', otree.db.models.IntegerField(null=True)),
                ('actual_A', otree.db.models.IntegerField(null=True)),
                ('actual_B', otree.db.models.IntegerField(null=True)),
                ('report_A', otree.db.models.IntegerField(choices=[(20000, '20,000'), (25000, '25,000'), (30000, '30,000'), (35000, '35,000'), (40000, '40,000'), (45000, '45,000'), (50000, '50,000'), (55000, '55,000'), (60000, '60,000'), (65000, '65,000'), (70000, '70,000'), (75000, '75,000'), (80000, '80,000'), (85000, '85,000'), (90000, '90,000'), (95000, '95,000'), (100000, '100,000')], null=True, verbose_name='')),
                ('report_B', otree.db.models.IntegerField(choices=[(20000, '20,000'), (25000, '25,000'), (30000, '30,000'), (35000, '35,000'), (40000, '40,000'), (45000, '45,000'), (50000, '50,000'), (55000, '55,000'), (60000, '60,000'), (65000, '65,000'), (70000, '70,000'), (75000, '75,000'), (80000, '80,000'), (85000, '85,000'), (90000, '90,000'), (95000, '95,000'), (100000, '100,000')], null=True, verbose_name='')),
                ('report_A_partner', otree.db.models.IntegerField(null=True)),
                ('report_B_partner', otree.db.models.IntegerField(null=True)),
                ('slack_A', otree.db.models.IntegerField(null=True)),
                ('slack_B', otree.db.models.IntegerField(null=True)),
                ('slack_dol_A', otree.db.models.DecimalField(decimal_places=2, max_digits=3, null=True)),
                ('slack_dol_B', otree.db.models.DecimalField(decimal_places=2, max_digits=3, null=True)),
                ('audit_flag_A', otree.db.models.IntegerField(null=True)),
                ('audit_flag_B', otree.db.models.IntegerField(null=True)),
                ('bust_A', otree.db.models.IntegerField(null=True)),
                ('bust_A_partner', otree.db.models.IntegerField(null=True)),
                ('bust_B', otree.db.models.IntegerField(null=True)),
                ('bust_B_partner', otree.db.models.IntegerField(null=True)),
                ('chat_time', otree.db.models.StringField(max_length=10000, null=True)),
                ('lira', otree.db.models.IntegerField(null=True)),
                ('potential_comp', otree.db.models.DecimalField(decimal_places=2, max_digits=4, null=True)),
                ('lira_partner', otree.db.models.IntegerField(null=True)),
                ('potential_comp_partner', otree.db.models.DecimalField(decimal_places=2, max_digits=4, null=True)),
                ('worker_id', otree.db.models.StringField(default='e', max_length=10000, null=True)),
                ('group', models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, to='cost_reporting_task_ss.Group')),
                ('participant', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='cost_reporting_task_ss_player', to='otree.Participant')),
                ('session', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='cost_reporting_task_ss_player', to='otree.Session')),
                ('subsession', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='cost_reporting_task_ss.Subsession')),
            ],
            options={
                'db_table': 'cost_reporting_task_ss_player',
            },
            bases=(models.Model, otree.db.idmap.PlayerIDMapMixin),
        ),
        migrations.AddField(
            model_name='group',
            name='subsession',
            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='cost_reporting_task_ss.Subsession'),
        ),
    ]