# Generated by Django 2.2.12 on 2021-11-23 19:34 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_group', to='otree.Session')), ], options={ 'db_table': 'cost_reporting_task_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_subsession', to='otree.Session')), ], options={ 'db_table': 'cost_reporting_task_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)), ('worker_id', otree.db.models.StringField(default='e', 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_1A', otree.db.models.IntegerField(null=True)), ('actual_1B', otree.db.models.IntegerField(null=True)), ('report_1A', 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_1B', 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_1A_partner', otree.db.models.IntegerField(null=True)), ('report_1B_partner', otree.db.models.IntegerField(null=True)), ('slack_1A', otree.db.models.IntegerField(null=True)), ('slack_1B', otree.db.models.IntegerField(null=True)), ('slack_dol_1A', otree.db.models.DecimalField(decimal_places=2, max_digits=3, null=True)), ('slack_dol_1B', otree.db.models.DecimalField(decimal_places=2, max_digits=3, null=True)), ('audit_flag_1A', otree.db.models.IntegerField(null=True)), ('audit_flag_1B', otree.db.models.IntegerField(null=True)), ('bust_1A', otree.db.models.IntegerField(null=True)), ('bust_1A_partner', otree.db.models.IntegerField(null=True)), ('bust_1B', otree.db.models.IntegerField(null=True)), ('bust_1B_partner', otree.db.models.IntegerField(null=True)), ('actual_2A', otree.db.models.IntegerField(null=True)), ('actual_2B', otree.db.models.IntegerField(null=True)), ('report_2A', 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_2B', 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_2A_partner', otree.db.models.IntegerField(null=True)), ('report_2B_partner', otree.db.models.IntegerField(null=True)), ('slack_2A', otree.db.models.IntegerField(null=True)), ('slack_2B', otree.db.models.IntegerField(null=True)), ('slack_dol_2A', otree.db.models.DecimalField(decimal_places=2, max_digits=3, null=True)), ('slack_dol_2B', otree.db.models.DecimalField(decimal_places=2, max_digits=3, null=True)), ('audit_flag_2A', otree.db.models.IntegerField(null=True)), ('audit_flag_2B', otree.db.models.IntegerField(null=True)), ('bust_2A', otree.db.models.IntegerField(null=True)), ('bust_2A_partner', otree.db.models.IntegerField(null=True)), ('bust_2B', otree.db.models.IntegerField(null=True)), ('bust_2B_partner', otree.db.models.IntegerField(null=True)), ('actual_3A', otree.db.models.IntegerField(null=True)), ('actual_3B', otree.db.models.IntegerField(null=True)), ('report_3A', 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_3B', 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_3A_partner', otree.db.models.IntegerField(null=True)), ('report_3B_partner', otree.db.models.IntegerField(null=True)), ('slack_3A', otree.db.models.IntegerField(null=True)), ('slack_3B', otree.db.models.IntegerField(null=True)), ('slack_dol_3A', otree.db.models.DecimalField(decimal_places=2, max_digits=3, null=True)), ('slack_dol_3B', otree.db.models.DecimalField(decimal_places=2, max_digits=3, null=True)), ('audit_flag_3A', otree.db.models.IntegerField(null=True)), ('audit_flag_3B', otree.db.models.IntegerField(null=True)), ('bust_3A', otree.db.models.IntegerField(null=True)), ('bust_3A_partner', otree.db.models.IntegerField(null=True)), ('bust_3B', otree.db.models.IntegerField(null=True)), ('bust_3B_partner', otree.db.models.IntegerField(null=True)), ('actual_4A', otree.db.models.IntegerField(null=True)), ('actual_4B', otree.db.models.IntegerField(null=True)), ('report_4A', 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_4B', 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_4A_partner', otree.db.models.IntegerField(null=True)), ('report_4B_partner', otree.db.models.IntegerField(null=True)), ('slack_4A', otree.db.models.IntegerField(null=True)), ('slack_4B', otree.db.models.IntegerField(null=True)), ('slack_dol_4A', otree.db.models.DecimalField(decimal_places=2, max_digits=3, null=True)), ('slack_dol_4B', otree.db.models.DecimalField(decimal_places=2, max_digits=3, null=True)), ('audit_flag_4A', otree.db.models.IntegerField(null=True)), ('audit_flag_4B', otree.db.models.IntegerField(null=True)), ('bust_4A', otree.db.models.IntegerField(null=True)), ('bust_4A_partner', otree.db.models.IntegerField(null=True)), ('bust_4B', otree.db.models.IntegerField(null=True)), ('bust_4B_partner', otree.db.models.IntegerField(null=True)), ('actual_5A', otree.db.models.IntegerField(null=True)), ('actual_5B', otree.db.models.IntegerField(null=True)), ('report_5A', 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_5B', 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_5A_partner', otree.db.models.IntegerField(null=True)), ('report_5B_partner', otree.db.models.IntegerField(null=True)), ('slack_5A', otree.db.models.IntegerField(null=True)), ('slack_5B', otree.db.models.IntegerField(null=True)), ('slack_dol_5A', otree.db.models.DecimalField(decimal_places=2, max_digits=3, null=True)), ('slack_dol_5B', otree.db.models.DecimalField(decimal_places=2, max_digits=3, null=True)), ('audit_flag_5A', otree.db.models.IntegerField(null=True)), ('audit_flag_5B', otree.db.models.IntegerField(null=True)), ('bust_5A', otree.db.models.IntegerField(null=True)), ('bust_5A_partner', otree.db.models.IntegerField(null=True)), ('bust_5B', otree.db.models.IntegerField(null=True)), ('bust_5B_partner', otree.db.models.IntegerField(null=True)), ('chat_time_1', otree.db.models.StringField(max_length=10000, null=True)), ('chat_time_2', otree.db.models.StringField(max_length=10000, null=True)), ('chat_time_3', otree.db.models.StringField(max_length=10000, null=True)), ('chat_time_4', otree.db.models.StringField(max_length=10000, null=True)), ('chat_time_5', otree.db.models.StringField(max_length=10000, null=True)), ('lira_1', otree.db.models.IntegerField(null=True)), ('lira_2', otree.db.models.IntegerField(null=True)), ('lira_3', otree.db.models.IntegerField(null=True)), ('lira_4', otree.db.models.IntegerField(null=True)), ('lira_5', otree.db.models.IntegerField(null=True)), ('potential_comp_1', otree.db.models.DecimalField(decimal_places=2, max_digits=4, null=True)), ('potential_comp_2', otree.db.models.DecimalField(decimal_places=2, max_digits=4, null=True)), ('potential_comp_3', otree.db.models.DecimalField(decimal_places=2, max_digits=4, null=True)), ('potential_comp_4', otree.db.models.DecimalField(decimal_places=2, max_digits=4, null=True)), ('potential_comp_5', otree.db.models.DecimalField(decimal_places=2, max_digits=4, null=True)), ('lira_1_partner', otree.db.models.IntegerField(null=True)), ('lira_2_partner', otree.db.models.IntegerField(null=True)), ('lira_3_partner', otree.db.models.IntegerField(null=True)), ('lira_4_partner', otree.db.models.IntegerField(null=True)), ('lira_5_partner', otree.db.models.IntegerField(null=True)), ('potential_comp_1_partner', otree.db.models.DecimalField(decimal_places=2, max_digits=4, null=True)), ('potential_comp_2_partner', otree.db.models.DecimalField(decimal_places=2, max_digits=4, null=True)), ('potential_comp_3_partner', otree.db.models.DecimalField(decimal_places=2, max_digits=4, null=True)), ('potential_comp_4_partner', otree.db.models.DecimalField(decimal_places=2, max_digits=4, null=True)), ('potential_comp_5_partner', otree.db.models.DecimalField(decimal_places=2, max_digits=4, null=True)), ('pay_period', otree.db.models.IntegerField(null=True)), ('pay_period_lira', otree.db.models.IntegerField(null=True)), ('comp_1', otree.db.models.StringField(max_length=10000, null=True)), ('group', models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, to='cost_reporting_task.Group')), ('participant', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='cost_reporting_task_player', to='otree.Participant')), ('session', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='cost_reporting_task_player', to='otree.Session')), ('subsession', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='cost_reporting_task.Subsession')), ], options={ 'db_table': 'cost_reporting_task_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.Subsession'), ), ]