# Generated by Django 2.0.5 on 2018-09-14 20:30

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


class Migration(migrations.Migration):

    initial = True

    dependencies = [
    ]

    operations = [
        migrations.CreateModel(
            name='dedupTime',
            fields=[
                ('id', models.BigAutoField(primary_key=True, serialize=False)),
                ('num_threads', models.IntegerField(blank=True, null=True)),
                ('num_SF', models.IntegerField(blank=True, null=True)),
                ('num_dup', models.IntegerField(blank=True, null=True)),
                ('num_new', models.IntegerField(blank=True, null=True)),
                ('num_undie', models.IntegerField(blank=True, null=True)),
                ('seconds', models.FloatField(blank=True, null=True)),
                ('avg', models.FloatField(blank=True, null=True)),
                ('current_key', models.CharField(blank=True, max_length=256, null=True)),
                ('created_on', models.DateTimeField(auto_now_add=True, null=True)),
            ],
        ),
        migrations.CreateModel(
            name='duplifyTime',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('num_threads', models.IntegerField(blank=True, null=True)),
                ('num_SF', models.IntegerField(blank=True, null=True)),
                ('num_rep', models.IntegerField(blank=True, null=True)),
                ('seconds', models.FloatField(blank=True, null=True)),
                ('created_on', models.DateTimeField(auto_now_add=True)),
            ],
        ),
        migrations.CreateModel(
            name='progress',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('label', models.CharField(blank=True, max_length=256)),
                ('total', models.IntegerField(blank=True, null=True)),
                ('total_keys', models.IntegerField(blank=True, null=True)),
                ('completed', models.IntegerField(blank=True, default=0, null=True)),
                ('created_on', models.DateTimeField(auto_now_add=True)),
            ],
            options={
                'get_latest_by': 'created_on',
            },
        ),
        migrations.CreateModel(
            name='repContact',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('CRD', models.CharField(db_column='CRD', max_length=256)),
                ('firstName', models.CharField(blank=True, max_length=256)),
                ('middleName', models.CharField(blank=True, max_length=256)),
                ('lastName', models.CharField(blank=True, max_length=256)),
                ('suffix', models.CharField(blank=True, max_length=256)),
                ('mailingStreet', models.CharField(blank=True, max_length=256)),
                ('mailingCity', models.CharField(blank=True, max_length=256)),
                ('mailingStateProvince', models.CharField(blank=True, max_length=256)),
                ('mailingZipPostalCode', models.CharField(blank=True, max_length=256)),
                ('Phone', models.CharField(blank=True, max_length=256)),
                ('homePhone', models.CharField(blank=True, max_length=256)),
                ('mobilePhone', models.CharField(blank=True, max_length=256)),
                ('otherPhone', models.CharField(blank=True, max_length=256)),
                ('workEmail', models.CharField(blank=True, max_length=256)),
                ('personalEmail', models.CharField(blank=True, max_length=256)),
                ('otherEmail', models.CharField(blank=True, max_length=256)),
                ('average', models.IntegerField(blank=True, null=True)),
                ('type', models.CharField(choices=[('Undecided', 'Undecided'), ('Duplicate', 'Duplicate'), ('Manual Check', 'Manual Check'), ('New Record', 'New Record')], default='Undecided', max_length=256)),
                ('closest1_contactID', models.CharField(blank=True, max_length=256)),
                ('closest2_contactID', models.CharField(blank=True, max_length=256)),
                ('closest3_contactID', models.CharField(blank=True, max_length=256)),
                ('dupFlag', models.BooleanField(default=False)),
                ('keySortedBy', models.CharField(blank=True, max_length=256)),
                ('misc', models.CharField(blank=True, max_length=500)),
            ],
        ),
        migrations.CreateModel(
            name='sfcontact',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('CRD', models.CharField(db_column='CRD', max_length=256)),
                ('ContactID', models.CharField(blank=True, max_length=256)),
                ('firstName', models.CharField(blank=True, max_length=256)),
                ('middleName', models.CharField(blank=True, max_length=256)),
                ('lastName', models.CharField(blank=True, max_length=256)),
                ('suffix', models.CharField(blank=True, max_length=256)),
                ('mailingStreet', models.CharField(blank=True, max_length=256)),
                ('mailingCity', models.CharField(blank=True, max_length=256)),
                ('mailingStateProvince', models.CharField(blank=True, max_length=256)),
                ('mailingZipPostalCode', models.CharField(blank=True, max_length=256)),
                ('Phone', models.CharField(blank=True, max_length=256)),
                ('homePhone', models.CharField(blank=True, max_length=256)),
                ('mobilePhone', models.CharField(blank=True, max_length=256)),
                ('otherPhone', models.CharField(blank=True, max_length=256)),
                ('workEmail', models.CharField(blank=True, max_length=256)),
                ('personalEmail', models.CharField(blank=True, max_length=256)),
                ('otherEmail', models.CharField(blank=True, max_length=256)),
                ('dupFlag', models.BooleanField(default=False)),
                ('closest_rep', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='dedupper_sfcontact_related', related_query_name='sfcontact', to='dedupper.repContact')),
            ],
        ),
        migrations.CreateModel(
            name='simple',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('title', models.CharField(max_length=256)),
                ('author', models.CharField(max_length=256)),
                ('category', models.CharField(max_length=256)),
                ('average', models.IntegerField(blank=True, null=True)),
                ('type', models.CharField(choices=[('Undecided', 'Undecided'), ('Duplicate', 'Duplicate'), ('New Record', 'New Record')], default='Undecided', max_length=256)),
                ('closest1', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='the_closest', to='dedupper.simple')),
                ('closest2', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='second_closest', to='dedupper.simple')),
                ('closest3', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='third_closest', to='dedupper.simple')),
            ],
        ),
        migrations.CreateModel(
            name='uploadTime',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('num_threads', models.IntegerField(blank=True, default=1, null=True)),
                ('num_records', models.IntegerField(blank=True, null=True)),
                ('batch_size', models.IntegerField(blank=True, null=True)),
                ('seconds', models.FloatField(blank=True, null=True)),
                ('created_on', models.DateTimeField(auto_now_add=True)),
            ],
        ),
        migrations.AddField(
            model_name='repcontact',
            name='closest1',
            field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='first_dedupper_repcontact_related', related_query_name='dedupper_repcontact', to='dedupper.sfcontact'),
        ),
        migrations.AddField(
            model_name='repcontact',
            name='closest2',
            field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='second_dedupper_repcontact_related', related_query_name='dedupper_repcontacts', to='dedupper.sfcontact'),
        ),
        migrations.AddField(
            model_name='repcontact',
            name='closest3',
            field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='third_dedupper_repcontact_related', related_query_name='dedupper_repcontactss', to='dedupper.sfcontact'),
        ),
    ]

# Generated by Django 2.0.5 on 2018-09-14 20:30

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


class Migration(migrations.Migration):

    initial = True

    dependencies = [
    ]

    operations = [
        migrations.CreateModel(
            name='dedupTime',
            fields=[
                ('id', models.BigAutoField(primary_key=True, serialize=False)),
                ('num_threads', models.IntegerField(blank=True, null=True)),
                ('num_SF', models.IntegerField(blank=True, null=True)),
                ('num_dup', models.IntegerField(blank=True, null=True)),
                ('num_new', models.IntegerField(blank=True, null=True)),
                ('num_undie', models.IntegerField(blank=True, null=True)),
                ('seconds', models.FloatField(blank=True, null=True)),
                ('avg', models.FloatField(blank=True, null=True)),
                ('current_key', models.CharField(blank=True, max_length=256, null=True)),
                ('created_on', models.DateTimeField(auto_now_add=True, null=True)),
            ],
        ),
        migrations.CreateModel(
            name='duplifyTime',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('num_threads', models.IntegerField(blank=True, null=True)),
                ('num_SF', models.IntegerField(blank=True, null=True)),
                ('num_rep', models.IntegerField(blank=True, null=True)),
                ('seconds', models.FloatField(blank=True, null=True)),
                ('created_on', models.DateTimeField(auto_now_add=True)),
            ],
        ),
        migrations.CreateModel(
            name='progress',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('label', models.CharField(blank=True, max_length=256)),
                ('total', models.IntegerField(blank=True, null=True)),
                ('total_keys', models.IntegerField(blank=True, null=True)),
                ('completed', models.IntegerField(blank=True, default=0, null=True)),
                ('created_on', models.DateTimeField(auto_now_add=True)),
            ],
            options={
                'get_latest_by': 'created_on',
            },
        ),
        migrations.CreateModel(
            name='repContact',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('CRD', models.CharField(db_column='CRD', max_length=256)),
                ('firstName', models.CharField(blank=True, max_length=256)),
                ('middleName', models.CharField(blank=True, max_length=256)),
                ('lastName', models.CharField(blank=True, max_length=256)),
                ('suffix', models.CharField(blank=True, max_length=256)),
                ('mailingStreet', models.CharField(blank=True, max_length=256)),
                ('mailingCity', models.CharField(blank=True, max_length=256)),
                ('mailingStateProvince', models.CharField(blank=True, max_length=256)),
                ('mailingZipPostalCode', models.CharField(blank=True, max_length=256)),
                ('Phone', models.CharField(blank=True, max_length=256)),
                ('homePhone', models.CharField(blank=True, max_length=256)),
                ('mobilePhone', models.CharField(blank=True, max_length=256)),
                ('otherPhone', models.CharField(blank=True, max_length=256)),
                ('workEmail', models.CharField(blank=True, max_length=256)),
                ('personalEmail', models.CharField(blank=True, max_length=256)),
                ('otherEmail', models.CharField(blank=True, max_length=256)),
                ('average', models.IntegerField(blank=True, null=True)),
                ('type', models.CharField(choices=[('Undecided', 'Undecided'), ('Duplicate', 'Duplicate'), ('Manual Check', 'Manual Check'), ('New Record', 'New Record')], default='Undecided', max_length=256)),
                ('closest1_contactID', models.CharField(blank=True, max_length=256)),
                ('closest2_contactID', models.CharField(blank=True, max_length=256)),
                ('closest3_contactID', models.CharField(blank=True, max_length=256)),
                ('dupFlag', models.BooleanField(default=False)),
                ('keySortedBy', models.CharField(blank=True, max_length=256)),
                ('misc', models.CharField(blank=True, max_length=500)),
            ],
        ),
        migrations.CreateModel(
            name='sfcontact',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('CRD', models.CharField(db_column='CRD', max_length=256)),
                ('ContactID', models.CharField(blank=True, max_length=256)),
                ('firstName', models.CharField(blank=True, max_length=256)),
                ('middleName', models.CharField(blank=True, max_length=256)),
                ('lastName', models.CharField(blank=True, max_length=256)),
                ('suffix', models.CharField(blank=True, max_length=256)),
                ('mailingStreet', models.CharField(blank=True, max_length=256)),
                ('mailingCity', models.CharField(blank=True, max_length=256)),
                ('mailingStateProvince', models.CharField(blank=True, max_length=256)),
                ('mailingZipPostalCode', models.CharField(blank=True, max_length=256)),
                ('Phone', models.CharField(blank=True, max_length=256)),
                ('homePhone', models.CharField(blank=True, max_length=256)),
                ('mobilePhone', models.CharField(blank=True, max_length=256)),
                ('otherPhone', models.CharField(blank=True, max_length=256)),
                ('workEmail', models.CharField(blank=True, max_length=256)),
                ('personalEmail', models.CharField(blank=True, max_length=256)),
                ('otherEmail', models.CharField(blank=True, max_length=256)),
                ('dupFlag', models.BooleanField(default=False)),
                ('closest_rep', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='dedupper_sfcontact_related', related_query_name='sfcontact', to='dedupper.repContact')),
            ],
        ),
        migrations.CreateModel(
            name='simple',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('title', models.CharField(max_length=256)),
                ('author', models.CharField(max_length=256)),
                ('category', models.CharField(max_length=256)),
                ('average', models.IntegerField(blank=True, null=True)),
                ('type', models.CharField(choices=[('Undecided', 'Undecided'), ('Duplicate', 'Duplicate'), ('New Record', 'New Record')], default='Undecided', max_length=256)),
                ('closest1', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='the_closest', to='dedupper.simple')),
                ('closest2', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='second_closest', to='dedupper.simple')),
                ('closest3', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='third_closest', to='dedupper.simple')),
            ],
        ),
        migrations.CreateModel(
            name='uploadTime',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('num_threads', models.IntegerField(blank=True, default=1, null=True)),
                ('num_records', models.IntegerField(blank=True, null=True)),
                ('batch_size', models.IntegerField(blank=True, null=True)),
                ('seconds', models.FloatField(blank=True, null=True)),
                ('created_on', models.DateTimeField(auto_now_add=True)),
            ],
        ),
        migrations.AddField(
            model_name='repcontact',
            name='closest1',
            field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='first_dedupper_repcontact_related', related_query_name='dedupper_repcontact', to='dedupper.sfcontact'),
        ),
        migrations.AddField(
            model_name='repcontact',
            name='closest2',
            field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='second_dedupper_repcontact_related', related_query_name='dedupper_repcontacts', to='dedupper.sfcontact'),
        ),
        migrations.AddField(
            model_name='repcontact',
            name='closest3',
            field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='third_dedupper_repcontact_related', related_query_name='dedupper_repcontactss', to='dedupper.sfcontact'),
        ),
    ]

# Generated by Django 2.0.5 on 2018-09-14 20:30