# Generated by Django 5.0.4 on 2024-05-13 19:17

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


class Migration(migrations.Migration):

    initial = True

    dependencies = [
    ]

    operations = [
        migrations.CreateModel(
            name='CatalogMachinery',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('code', models.IntegerField(unique=True)),
                ('name', models.CharField(max_length=200)),
                ('last_updated', models.DateTimeField(auto_now=True)),
            ],
        ),
        migrations.CreateModel(
            name='Category',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('tripoli_category_id', models.IntegerField()),
                ('slug', models.CharField(max_length=200, null=True)),
                ('name', models.CharField(max_length=200, null=True)),
                ('last_updated', models.DateTimeField(auto_now=True)),
            ],
        ),
        migrations.CreateModel(
            name='CultureableName',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('cultureable_name', models.CharField(max_length=200, unique=True)),
                ('last_updated', models.DateTimeField(auto_now=True)),
            ],
        ),
        migrations.CreateModel(
            name='District',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('tripoli_district_id', models.IntegerField()),
                ('name', models.CharField(max_length=200, null=True)),
                ('slug', models.CharField(max_length=200, null=True)),
                ('last_updated', models.DateTimeField(auto_now=True)),
            ],
        ),
        migrations.CreateModel(
            name='Region',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('tripoli_region_id', models.IntegerField()),
                ('name', models.CharField(max_length=200, null=True)),
                ('slug', models.CharField(max_length=200, null=True)),
                ('last_updated', models.DateTimeField(auto_now=True)),
            ],
        ),
        migrations.CreateModel(
            name='Culture',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('slug', models.CharField(max_length=200, null=True)),
                ('title', models.CharField(max_length=200, null=True)),
                ('last_updated', models.DateTimeField(auto_now=True)),
                ('category', models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, to='farmerapp.category')),
            ],
        ),
        migrations.CreateModel(
            name='CatalogLandingFields',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('cultureable_units', models.CharField(max_length=100, null=True)),
                ('culture_area', models.FloatField(null=True)),
                ('collected', models.FloatField(null=True)),
                ('year', models.IntegerField(null=True)),
                ('last_updated', models.DateTimeField(auto_now=True)),
                ('cultureable_name', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='farmerapp.cultureablename')),
            ],
        ),
        migrations.CreateModel(
            name='CulturesAvailability',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('availability', models.FloatField()),
                ('collected', models.FloatField()),
                ('year', models.IntegerField()),
                ('last_updated', models.DateTimeField(auto_now=True)),
                ('culture', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='farmerapp.culture')),
            ],
        ),
        migrations.CreateModel(
            name='Farmer',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('tripoli_farmer_id', models.IntegerField(null=True)),
                ('erdpou', models.IntegerField(null=True)),
                ('kod_pdv', models.BigIntegerField(null=True)),
                ('registration_at', models.DateField(null=True)),
                ('address', models.CharField(max_length=500, null=True)),
                ('email', models.CharField(max_length=200, null=True)),
                ('website', models.CharField(max_length=200, null=True)),
                ('director', models.CharField(max_length=200, null=True)),
                ('description', models.TextField(blank=True, null=True)),
                ('name', models.CharField(max_length=200, null=True)),
                ('short_name', models.CharField(max_length=200, null=True)),
                ('atu_code', models.CharField(max_length=200, null=True)),
                ('record_number', models.CharField(max_length=200, null=True)),
                ('record_date', models.DateField(null=True)),
                ('phone_1', models.CharField(max_length=50, null=True)),
                ('phone_2', models.CharField(max_length=50, null=True)),
                ('phone_3', models.CharField(max_length=50, null=True)),
                ('phone_4', models.CharField(max_length=50, null=True)),
                ('phone_5', models.CharField(max_length=50, null=True)),
                ('phone_6', models.CharField(max_length=50, null=True)),
                ('phone_7', models.CharField(max_length=50, null=True)),
                ('phone_mobile_1', models.CharField(max_length=50, null=True)),
                ('phone_mobile_2', models.CharField(max_length=50, null=True)),
                ('phone_mobile_3', models.CharField(max_length=50, null=True)),
                ('phone_mobile_4', models.CharField(max_length=50, null=True)),
                ('phone_mobile_5', models.CharField(max_length=50, null=True)),
                ('org_s_status', models.CharField(max_length=200, null=True)),
                ('landing_area', models.FloatField(null=True)),
                ('statut_kapital', models.BigIntegerField(null=True)),
                ('phone_mobile_1_viber', models.BooleanField(default=False)),
                ('phone_mobile_1_telegram', models.BooleanField(default=False)),
                ('phone_mobile_2_viber', models.BooleanField(default=False)),
                ('phone_mobile_2_telegram', models.BooleanField(default=False)),
                ('phone_mobile_3_viber', models.BooleanField(default=False)),
                ('phone_mobile_3_telegram', models.BooleanField(default=False)),
                ('last_updated', models.DateTimeField(auto_now=True)),
                ('catalog_landing_fields', models.ManyToManyField(to='farmerapp.cataloglandingfields')),
                ('catalog_machineries', models.ManyToManyField(related_name='farmers', to='farmerapp.catalogmachinery')),
                ('categories', models.ManyToManyField(to='farmerapp.category')),
                ('district', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='farmers', to='farmerapp.district')),
                ('region', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, to='farmerapp.region')),
            ],
        ),
        migrations.CreateModel(
            name='Machinery',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('availability', models.IntegerField()),
                ('received', models.IntegerField()),
                ('eliminated', models.IntegerField()),
                ('last_updated', models.DateTimeField(auto_now=True)),
                ('catalog_machinery', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='farmerapp.catalogmachinery')),
                ('farmer', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='farmerapp.farmer')),
            ],
        ),
        migrations.AddField(
            model_name='district',
            name='region',
            field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, to='farmerapp.region'),
        ),
    ]
