# Generated by Django 5.1.1 on 2024-09-04 13:33

from django.db import migrations, models


class Migration(migrations.Migration):

    initial = True

    dependencies = [
    ]

    operations = [
        migrations.CreateModel(
            name='AuthUser',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('password', models.CharField(max_length=128)),
                ('last_login', models.DateTimeField(blank=True, null=True)),
                ('is_superuser', models.IntegerField()),
                ('username', models.CharField(max_length=150, unique=True)),
                ('first_name', models.CharField(max_length=150)),
                ('last_name', models.CharField(max_length=150)),
                ('email', models.CharField(max_length=254)),
                ('is_staff', models.IntegerField()),
                ('is_active', models.IntegerField()),
                ('date_joined', models.DateTimeField()),
            ],
            options={
                'db_table': 'auth_user',
                'managed': False,
            },
        ),
        migrations.CreateModel(
            name='Bsu',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('codeplant', models.TextField(db_column='codePlant')),
                ('code', models.TextField()),
                ('name', models.TextField()),
                ('vmixer', models.FloatField(db_column='vMixer')),
            ],
            options={
                'db_table': 'BSU',
                'managed': False,
            },
        ),
        migrations.CreateModel(
            name='Car',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name', models.TextField()),
                ('coderfid', models.IntegerField(db_column='codeRFID')),
                ('maxv', models.FloatField(db_column='maxV')),
            ],
            options={
                'db_table': 'car',
                'managed': False,
            },
        ),
        migrations.CreateModel(
            name='Classrecipe',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('code', models.IntegerField(blank=True, null=True)),
                ('name', models.TextField(blank=True, null=True)),
            ],
            options={
                'db_table': 'classRecipe',
                'managed': False,
            },
        ),
        migrations.CreateModel(
            name='Comp',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name', models.TextField()),
                ('code', models.TextField()),
            ],
            options={
                'db_table': 'comp',
                'managed': False,
            },
        ),
        migrations.CreateModel(
            name='Customer',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name', models.TextField()),
                ('address', models.TextField()),
                ('comment', models.TextField(blank=True, null=True)),
            ],
            options={
                'db_table': 'customer',
                'managed': False,
            },
        ),
        migrations.CreateModel(
            name='Dispatcher',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name', models.TextField()),
                ('code', models.TextField()),
            ],
            options={
                'db_table': 'dispatcher',
                'managed': False,
            },
        ),
        migrations.CreateModel(
            name='DjangoMigrations',
            fields=[
                ('id', models.BigAutoField(primary_key=True, serialize=False)),
                ('app', models.CharField(max_length=255)),
                ('name', models.CharField(max_length=255)),
                ('applied', models.DateTimeField()),
            ],
            options={
                'db_table': 'django_migrations',
                'managed': False,
            },
        ),
        migrations.CreateModel(
            name='Driver',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name', models.TextField()),
                ('coderfid', models.IntegerField(db_column='codeRFID')),
                ('comment', models.TextField(blank=True, null=True)),
            ],
            options={
                'db_table': 'driver',
                'managed': False,
            },
        ),
        migrations.CreateModel(
            name='Mainstate',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name', models.TextField()),
                ('code', models.IntegerField()),
                ('options', models.TextField()),
                ('entityname', models.TextField(db_column='entityName')),
                ('ispause', models.IntegerField(blank=True, db_column='isPause', null=True)),
            ],
            options={
                'db_table': 'mainState',
                'managed': False,
            },
        ),
        migrations.CreateModel(
            name='Mixture',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('fullname', models.TextField(db_column='fullName')),
                ('code', models.TextField()),
                ('shortname', models.TextField(db_column='shortName')),
            ],
            options={
                'db_table': 'mixture',
                'managed': False,
            },
        ),
        migrations.CreateModel(
            name='MqttProcessorProduct',
            fields=[
                ('id', models.BigAutoField(primary_key=True, serialize=False)),
                ('datestart', models.DateTimeField(blank=True, db_column='dateStart', null=True)),
                ('timeend', models.DateTimeField(blank=True, db_column='timeEnd', null=True)),
                ('vproduct', models.FloatField(blank=True, db_column='vProduct', null=True)),
                ('loopnumber', models.IntegerField(blank=True, db_column='loopNumber', null=True)),
                ('vloop', models.FloatField(blank=True, db_column='vLoop', null=True)),
                ('driver', models.CharField(blank=True, max_length=255, null=True)),
                ('car', models.IntegerField(blank=True, null=True)),
                ('classrecipe', models.CharField(blank=True, db_column='classRecipe', max_length=255, null=True)),
                ('namerecipe', models.CharField(blank=True, db_column='nameRecipe', max_length=255, null=True)),
                ('recipe', models.TextField(blank=True, null=True)),
                ('idttn', models.CharField(blank=True, db_column='idTtn', max_length=255, null=True)),
                ('timestart', models.DateTimeField(blank=True, db_column='timeStart', null=True)),
                ('num_loop', models.IntegerField(blank=True, null=True)),
                ('idplant', models.IntegerField(blank=True, db_column='idPlant', null=True)),
                ('indproduct', models.IntegerField(blank=True, db_column='indProduct', null=True)),
            ],
            options={
                'db_table': 'mqtt_processor_product',
                'managed': False,
            },
        ),
        migrations.CreateModel(
            name='MqttProcessorReport',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('json', models.TextField()),
                ('date', models.DateTimeField()),
            ],
            options={
                'db_table': 'mqtt_processor_report',
                'managed': False,
            },
        ),
        migrations.CreateModel(
            name='MqttProcessorReportcurrentloop',
            fields=[
                ('id', models.BigAutoField(primary_key=True, serialize=False)),
                ('vloop', models.FloatField(blank=True, db_column='vLoop', null=True)),
                ('loopnumber', models.IntegerField(blank=True, db_column='loopNumber', null=True)),
                ('code', models.IntegerField(blank=True, null=True)),
                ('dispencer', models.IntegerField(blank=True, null=True)),
                ('doisingerror', models.FloatField(blank=True, db_column='doisingError', null=True)),
                ('doisingerrorpersent', models.FloatField(blank=True, db_column='doisingErrorPersent', null=True)),
                ('doisingkorr', models.FloatField(blank=True, db_column='doisingKorr', null=True)),
                ('humiditykorr', models.FloatField(blank=True, db_column='humidityKorr', null=True)),
                ('weightfactloop', models.FloatField(blank=True, db_column='weightFactLoop', null=True)),
                ('weightfactm3', models.FloatField(blank=True, db_column='weightFactM3', null=True)),
                ('weightrecipeloop', models.FloatField(blank=True, db_column='weightRecipeLoop', null=True)),
                ('weightrecipem3', models.FloatField(blank=True, db_column='weightRecipeM3', null=True)),
            ],
            options={
                'db_table': 'mqtt_processor_reportcurrentloop',
                'managed': False,
            },
        ),
        migrations.CreateModel(
            name='MqttProcessorTtnstate',
            fields=[
                ('id', models.BigAutoField(primary_key=True, serialize=False)),
                ('idttn', models.IntegerField(db_column='idTtn')),
                ('state', models.CharField(max_length=255)),
                ('date', models.DateTimeField()),
                ('json', models.TextField()),
            ],
            options={
                'db_table': 'mqtt_processor_ttnstate',
                'managed': False,
            },
        ),
        migrations.CreateModel(
            name='Order',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('idcustomer', models.IntegerField(blank=True, db_column='idCustomer', null=True)),
                ('number', models.TextField(blank=True, null=True)),
                ('dispatcher', models.TextField(blank=True, null=True)),
                ('datecreate', models.TextField(blank=True, db_column='dateCreate', null=True)),
                ('classrecipe', models.TextField(blank=True, db_column='classRecipe', null=True)),
                ('namerecipe', models.TextField(blank=True, db_column='nameRecipe', null=True)),
                ('vorder', models.FloatField(blank=True, db_column='vOrder', null=True)),
                ('state', models.IntegerField(blank=True, null=True)),
                ('adress', models.TextField(blank=True, null=True)),
                ('datefinish', models.TextField(blank=True, db_column='dateFinish', null=True)),
                ('datestart', models.TextField(blank=True, db_column='dateStart', null=True)),
                ('interval', models.IntegerField(blank=True, null=True)),
                ('fromobject', models.IntegerField(blank=True, db_column='fromObject', null=True)),
                ('toobject', models.IntegerField(blank=True, db_column='toObject', null=True)),
                ('idplant', models.IntegerField(blank=True, db_column='idPlant', null=True)),
            ],
            options={
                'db_table': 'order',
                'managed': False,
            },
        ),
        migrations.CreateModel(
            name='Orderstate',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('date', models.DateTimeField()),
                ('state', models.TextField()),
                ('idorder', models.IntegerField(db_column='idOrder')),
            ],
            options={
                'db_table': 'orderState',
                'managed': False,
            },
        ),
        migrations.CreateModel(
            name='Plants',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('codeplant', models.TextField(db_column='codePlant')),
                ('name', models.TextField()),
                ('comment', models.TextField(blank=True, null=True)),
            ],
            options={
                'db_table': 'plants',
                'managed': False,
            },
        ),
        migrations.CreateModel(
            name='Product',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('datestart', models.DateTimeField(db_column='dateStart')),
                ('timeend', models.DateTimeField(db_column='timeEnd')),
                ('vproduct', models.FloatField(db_column='vProduct')),
                ('loopnumber', models.IntegerField(db_column='loopNumber')),
                ('vloop', models.FloatField(db_column='vLoop')),
                ('driver', models.TextField()),
                ('car', models.TextField()),
                ('classrecipe', models.TextField(db_column='classRecipe')),
                ('namerecipe', models.TextField(db_column='nameRecipe')),
                ('recipe', models.TextField()),
                ('idttn', models.IntegerField(db_column='idTtn')),
                ('timestart', models.DateTimeField(db_column='timeStart')),
                ('num_loop', models.IntegerField()),
                ('idplant', models.TextField(db_column='idPlant')),
                ('indproduct', models.IntegerField(db_column='indProduct')),
            ],
            options={
                'db_table': 'product',
                'managed': False,
            },
        ),
        migrations.CreateModel(
            name='Reccomment',
            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': 'RecComment',
                'managed': False,
            },
        ),
        migrations.CreateModel(
            name='Reccomp',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('idcoderecipe', models.IntegerField(db_column='idCodeRecipe')),
                ('idcodecomp', models.IntegerField(db_column='idCodeComp')),
                ('weightcomps', models.FloatField(db_column='weightCompS')),
                ('weightcompw', models.FloatField(db_column='weightCompW')),
            ],
            options={
                'db_table': 'recComp',
                'managed': False,
            },
        ),
        migrations.CreateModel(
            name='Recfrost',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name', models.TextField()),
                ('code', models.TextField()),
            ],
            options={
                'db_table': 'recFrost',
                'managed': False,
            },
        ),
        migrations.CreateModel(
            name='Recipe',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('code', models.TextField(blank=True, null=True)),
                ('name', models.TextField(blank=True, null=True)),
                ('mixt', models.IntegerField(blank=True, null=True)),
                ('strength', models.IntegerField(blank=True, null=True)),
                ('mobil', models.IntegerField(blank=True, null=True)),
                ('frost', models.IntegerField(blank=True, null=True)),
                ('water', models.IntegerField(blank=True, null=True)),
                ('marka', models.IntegerField(blank=True, null=True)),
                ('condition', models.TextField(blank=True, null=True)),
                ('json', models.TextField(blank=True, null=True)),
                ('date', models.TextField(blank=True, null=True)),
            ],
            options={
                'db_table': 'recipe',
                'managed': False,
            },
        ),
        migrations.CreateModel(
            name='Recmarka',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name', models.TextField()),
                ('code', models.TextField()),
            ],
            options={
                'db_table': 'recMarka',
                'managed': False,
            },
        ),
        migrations.CreateModel(
            name='Recmobility',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name', models.TextField()),
                ('code', models.TextField()),
            ],
            options={
                'db_table': 'recMobility',
                'managed': False,
            },
        ),
        migrations.CreateModel(
            name='Recstrength',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name', models.TextField()),
                ('code', models.TextField()),
            ],
            options={
                'db_table': 'recStrength',
                'managed': False,
            },
        ),
        migrations.CreateModel(
            name='Recwat',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name', models.TextField()),
                ('code', models.TextField()),
            ],
            options={
                'db_table': 'recWat',
                'managed': False,
            },
        ),
        migrations.CreateModel(
            name='Report',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('json', models.TextField(blank=True, null=True)),
                ('date', models.DateTimeField(blank=True, null=True)),
            ],
            options={
                'db_table': 'report',
                'managed': False,
            },
        ),
        migrations.CreateModel(
            name='Reportcurrentloop',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('vloop', models.FloatField(blank=True, db_column='vLoop', null=True)),
                ('loopnumber', models.IntegerField(blank=True, db_column='loopNumber', null=True)),
                ('code', models.IntegerField(blank=True, null=True)),
                ('dispencer', models.TextField(blank=True, null=True)),
                ('doisingerror', models.FloatField(blank=True, db_column='doisingError', null=True)),
                ('doisingerrorpersent', models.FloatField(blank=True, db_column='doisingErrorPersent', null=True)),
                ('doisingkorr', models.FloatField(blank=True, db_column='doisingKorr', null=True)),
                ('humiditykorr', models.FloatField(blank=True, db_column='humidityKorr', null=True)),
                ('weightfactloop', models.FloatField(blank=True, db_column='weightFactLoop', null=True)),
                ('weightfactm3', models.FloatField(blank=True, db_column='weightFactM3', null=True)),
                ('weightrecipeloop', models.FloatField(blank=True, db_column='weightRecipeLoop', null=True)),
                ('weightrecipem3', models.FloatField(blank=True, db_column='weightRecipeM3', null=True)),
                ('idproduct', models.IntegerField(blank=True, db_column='idProduct', null=True)),
                ('indproduct', models.IntegerField(blank=True, db_column='indProduct', null=True)),
            ],
            options={
                'db_table': 'reportCurrentLoop',
                'managed': False,
            },
        ),
        migrations.CreateModel(
            name='Reportweightmanual',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('loopnumber', models.IntegerField(db_column='loopNumber')),
                ('code', models.TextField()),
                ('dispenser', models.TextField()),
                ('weight', models.FloatField()),
            ],
            options={
                'db_table': 'ReportWeightManual',
                'managed': False,
            },
        ),
        migrations.CreateModel(
            name='Silcem',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('codebsu', models.TextField(db_column='codeBSU')),
                ('code', models.TextField()),
                ('batcher', models.TextField()),
            ],
            options={
                'db_table': 'silCem',
                'managed': False,
            },
        ),
        migrations.CreateModel(
            name='Ttn',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('date', models.DateTimeField(blank=True, null=True)),
                ('idplant', models.IntegerField(blank=True, db_column='idPlant', null=True)),
                ('idorder', models.IntegerField(blank=True, db_column='idOrder', null=True)),
                ('dispatcher', models.TextField(blank=True, null=True)),
                ('vproduct', models.IntegerField(blank=True, db_column='vProduct', null=True)),
                ('driver', models.TextField(blank=True, null=True)),
                ('car', models.TextField(blank=True, null=True)),
                ('finishadress', models.TextField(blank=True, db_column='finishAdress', null=True)),
                ('finishdate', models.DateTimeField(blank=True, db_column='finishDate', null=True)),
                ('state', models.IntegerField(blank=True, null=True)),
                ('ispause', models.IntegerField(blank=True, db_column='isPause', null=True)),
                ('idproduct', models.IntegerField(blank=True, db_column='idProduct', null=True)),
                ('idbsu', models.IntegerField(blank=True, db_column='idBsu', null=True)),
            ],
            options={
                'db_table': 'ttn',
                'managed': False,
            },
        ),
        migrations.CreateModel(
            name='Ttnstate',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('date', models.TextField(blank=True, null=True)),
                ('state', models.TextField(blank=True, null=True)),
                ('idttn', models.IntegerField(blank=True, db_column='idTtn', null=True)),
                ('json', models.TextField(blank=True, null=True)),
                ('ispause', models.IntegerField(blank=True, db_column='isPause', null=True)),
            ],
            options={
                'db_table': 'ttnState',
                'managed': False,
            },
        ),
    ]