# Generated by Django 4.2.21 on 2025-05-13 08:55

from django.db import migrations, models


class Migration(migrations.Migration):

    initial = True

    dependencies = [
    ]

    operations = [
        migrations.CreateModel(
            name='UexistFiles',
            fields=[
                ('file_id', models.AutoField(primary_key=True, serialize=False)),
                ('file', models.CharField(max_length=150)),
                ('date', models.DateTimeField()),
                ('ready', models.IntegerField(default=0)),
                ('loaded', models.IntegerField(blank=True, null=True)),
                ('cleaned', models.IntegerField(default=0)),
                ('total', models.IntegerField(default=0)),
                ('processed', models.IntegerField(default=0)),
                ('failed', models.IntegerField(blank=True, null=True)),
                ('priority', models.IntegerField(default=0)),
                ('user_id', models.IntegerField(blank=True, null=True)),
            ],
            options={
                'db_table': 'uexist_files',
            },
        ),
        migrations.CreateModel(
            name='UexistTargets',
            fields=[
                ('target_id', models.AutoField(primary_key=True, serialize=False)),
                ('name', models.CharField(max_length=65)),
                ('target_attribute', models.CharField(max_length=25)),
                ('alias', models.CharField(max_length=65)),
                ('active', models.IntegerField(default=1)),
                ('downloadable', models.IntegerField(default=1)),
                ('url', models.CharField(max_length=255)),
            ],
            options={
                'db_table': 'uexist_targets',
            },
        ),
        migrations.CreateModel(
            name='Users',
            fields=[
                ('user_id', models.AutoField(primary_key=True, serialize=False)),
                ('user', models.CharField(max_length=25)),
                ('password', models.CharField(max_length=350)),
                ('private_only', models.IntegerField(blank=True, null=True)),
            ],
            options={
                'db_table': 'users',
            },
        ),
        migrations.CreateModel(
            name='UexistEntry',
            fields=[
                ('entry_id', models.BigAutoField(primary_key=True, serialize=False)),
                ('file_id', models.IntegerField()),
                ('firstname', models.CharField(blank=True, max_length=150, null=True)),
                ('lastname', models.CharField(max_length=65)),
                ('email', models.CharField(blank=True, max_length=120, null=True)),
                ('phone', models.CharField(max_length=25)),
                ('street', models.CharField(blank=True, max_length=175, null=True)),
                ('city', models.CharField(blank=True, max_length=35, null=True)),
                ('state', models.CharField(blank=True, max_length=35, null=True)),
                ('country', models.CharField(blank=True, max_length=50, null=True)),
                ('ip', models.CharField(blank=True, max_length=25, null=True)),
                ('website', models.CharField(blank=True, max_length=150, null=True)),
                ('date', models.CharField(blank=True, max_length=50, null=True)),
                ('notes', models.CharField(blank=True, max_length=500, null=True)),
                ('description', models.CharField(blank=True, max_length=500, null=True)),
                ('info', models.CharField(blank=True, max_length=500, null=True)),
                ('lead_id', models.CharField(blank=True, max_length=50, null=True)),
                ('status', models.CharField(blank=True, max_length=65, null=True)),
                ('old_notes', models.TextField(blank=True, null=True)),
                ('recycle', models.IntegerField(default=0)),
                ('import_field', models.IntegerField(db_column='import', default=0)),
                ('imported', models.IntegerField(default=0)),
                ('matched_target', models.IntegerField(blank=True, null=True)),
                ('updated_date', models.DateTimeField(blank=True, null=True)),
            ],
            options={
                'db_table': 'uexist_entries',
                'indexes': [models.Index(fields=['file_id', 'import_field', 'recycle', 'imported'], name='index_master_1'), models.Index(fields=['import_field', 'imported'], name='index_master_2'), models.Index(fields=['email'], name='index_master_3'), models.Index(fields=['matched_target', 'import_field', 'imported'], name='index_master_4'), models.Index(fields=['matched_target', 'import_field', 'imported', 'updated_date'], name='index_master_5')],
            },
        ),
        migrations.CreateModel(
            name='UexistEntriesTargets',
            fields=[
                ('record_id', models.BigAutoField(primary_key=True, serialize=False)),
                ('file_id', models.IntegerField()),
                ('entry_id', models.BigIntegerField()),
                ('target_id', models.IntegerField()),
                ('worker', models.IntegerField()),
                ('processed', models.IntegerField(default=0)),
                ('matched', models.IntegerField(default=0)),
                ('failed', models.IntegerField(default=0)),
                ('priority', models.IntegerField(default=0)),
            ],
            options={
                'db_table': 'uexist_entries_targets',
                'indexes': [models.Index(fields=['target_id', 'worker', 'priority', 'processed', 'failed'], name='idx_first_index'), models.Index(fields=['file_id', 'target_id', 'processed', 'failed'], name='idx_second_index'), models.Index(fields=['target_id'], name='idx_third_index'), models.Index(fields=['processed'], name='idx_forth_index'), models.Index(fields=['processed', 'target_id'], name='idx_fifth_index')],
            },
        ),
    ]