# Generated by Django 4.2.19 on 2025-06-02 09:49

from django.db import migrations, models


class Migration(migrations.Migration):

    dependencies = [
        ('hope_faith_harvester', '0003_alter_uexistfiles_loaded'),
    ]

    operations = [
        migrations.CreateModel(
            name='UexistEntriesMatched',
            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(blank=True, max_length=65, null=True)),
                ('email', models.CharField(blank=True, max_length=120, null=True)),
                ('phone', models.CharField(blank=True, max_length=25, null=True)),
                ('import_field', models.IntegerField(db_column='import', default=0)),
                ('matched_target', models.IntegerField(blank=True, null=True)),
                ('updated_date', models.DateTimeField(blank=True, null=True)),
            ],
            options={
                'db_table': 'uexist_entries_matched',
                'indexes': [models.Index(fields=['file_id'], name='idx_file_id'), models.Index(fields=['file_id', 'matched_target'], name='idx_file_matched'), models.Index(fields=['email'], name='idx_email'), models.Index(fields=['phone'], name='idx_phone'), models.Index(fields=['matched_target', 'import_field'], name='idx_target_updated')],
            },
        ),
    ]