# Generated by Django 3.2.16 on 2023-02-04 22:19

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


class Migration(migrations.Migration):

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

    operations = [
        migrations.CreateModel(
            name='LineNonAlcModel',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('hour', models.CharField(choices=[('00', '00'), ('01', '01'), ('02', '02'), ('03', '03'), ('04', '04'), ('05', '05'), ('06', '06'), ('07', '07'), ('08', '08'), ('09', '09'), ('10', '10'), ('11', '11'), ('12', '12'), ('13', '13'), ('14', '14'), ('15', '15'), ('16', '16'), ('17', '17'), ('18', '18'), ('19', '19'), ('20', '20'), ('21', '21'), ('22', '22'), ('23', '23')], max_length=6)),
                ('has_bottling', models.BooleanField(default=False)),
                ('taste', models.CharField(choices=[('OKAY', 'OKAY'), ('NOT OKAY', 'NOT OKAY'), ('OTHER', 'OTHER')], max_length=9)),
                ('color', models.FloatField(blank=True, null=True)),
                ('conductivity', models.FloatField()),
                ('ph', models.FloatField()),
                ('co2_level_before_past', models.FloatField()),
                ('co2_level_after_past', models.FloatField()),
                ('volume', models.FloatField()),
                ('clarity', models.IntegerField(default=0)),
                ('bottle_defect', models.IntegerField(default=0)),
                ('corking_caping_defect', models.IntegerField(default=0)),
                ('label_defect', models.IntegerField(default=0)),
                ('manufacturing_date', models.CharField(max_length=12)),
                ('batch_number', models.CharField(max_length=12)),
                ('best_before_date', models.CharField(max_length=12)),
                ('environment', models.CharField(choices=[('OKAY', 'OKAY'), ('NOT OKAY', 'NOT OKAY'), ('OTHER', 'OTHER')], max_length=9)),
                ('comment', models.TextField()),
                ('line_id', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='hourly1', to='line_analysis.lineanalysismodel')),
            ],
        ),
        migrations.CreateModel(
            name='LineAlcModel',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('hour', models.CharField(choices=[('00', '00'), ('01', '01'), ('02', '02'), ('03', '03'), ('04', '04'), ('05', '05'), ('06', '06'), ('07', '07'), ('08', '08'), ('09', '09'), ('10', '10'), ('11', '11'), ('12', '12'), ('13', '13'), ('14', '14'), ('15', '15'), ('16', '16'), ('17', '17'), ('18', '18'), ('19', '19'), ('20', '20'), ('21', '21'), ('22', '22'), ('23', '23')], max_length=6)),
                ('has_bottling', models.BooleanField(default=False)),
                ('taste', models.CharField(choices=[('OKAY', 'OKAY'), ('NOT OKAY', 'NOT OKAY'), ('OTHER', 'OTHER')], max_length=9)),
                ('color', models.FloatField(blank=True, null=True)),
                ('conductivity', models.FloatField()),
                ('ph', models.FloatField()),
                ('alcoholic_strength', models.FloatField()),
                ('volume', models.FloatField()),
                ('clarity', models.IntegerField(default=0)),
                ('bottle_defect', models.IntegerField(default=0)),
                ('cap_defect', models.IntegerField(default=0)),
                ('label_defect', models.IntegerField(default=0)),
                ('manufacturing_date', models.CharField(max_length=12)),
                ('batch_number', models.CharField(max_length=12)),
                ('case_code', models.CharField(max_length=12)),
                ('comment', models.TextField()),
                ('line_id', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='hourly', to='line_analysis.lineanalysismodel')),
            ],
        ),
    ]
