# Generated by Django 2.1.5 on 2019-04-07 02:50

import datasets.utils.BaseDatasetModel
from django.db import migrations, models
import django.db.models.deletion


class Migration(migrations.Migration):

    dependencies = [
        ('datasets', '0020_dobnowfiledpermit'),
    ]

    operations = [
        migrations.CreateModel(
            name='DOBFiledPermit',
            fields=[
                ('key', models.TextField(primary_key=True, serialize=False)),
                ('jobfilingnumber', models.TextField(blank=True, null=True)),
                ('housenumber', models.TextField(blank=True, null=True)),
                ('streetname', models.TextField(blank=True, null=True)),
                ('borough', models.TextField(blank=True, null=True)),
                ('jobstatus', models.TextField(blank=True, null=True)),
                ('jobtype', models.TextField(blank=True, null=True)),
                ('jobdescription', models.TextField(blank=True, null=True)),
                ('datefiled', models.DateTimeField(blank=True, db_index=True, null=True)),
                ('applicantsfirstname', models.TextField(blank=True, null=True)),
                ('applicantslastname', models.TextField(blank=True, null=True)),
                ('applicantprofessionaltitle', models.TextField(blank=True, null=True)),
                ('applicantlicense', models.TextField(blank=True, null=True)),
                ('ownerbusinessname', models.TextField(blank=True, null=True)),
                ('initialcost', models.IntegerField(blank=True, null=True)),
                ('foreign_key', models.TextField(blank=True, null=True)),
                ('type', models.TextField(blank=True, null=True)),
                ('bbl', models.ForeignKey(blank=True, db_column='bbl', db_constraint=False, null=True, on_delete=django.db.models.deletion.SET_NULL, to='datasets.Property')),
                ('bin', models.ForeignKey(blank=True, db_column='bin', db_constraint=False, null=True, on_delete=django.db.models.deletion.SET_NULL, to='datasets.Building')),
            ],
            bases=(datasets.utils.BaseDatasetModel.BaseDatasetModel, models.Model),
        ),
        migrations.AlterField(
            model_name='conhrecord',
            name='bin',
            field=models.ForeignKey(blank=True, db_column='bin', db_constraint=False, null=True, on_delete=django.db.models.deletion.SET_NULL, to='datasets.Building'),
        ),
        migrations.AddIndex(
            model_name='dobfiledpermit',
            index=models.Index(fields=['bbl', 'datefiled'], name='datasets_do_bbl_fd8d20_idx'),
        ),
        migrations.AddIndex(
            model_name='dobfiledpermit',
            index=models.Index(fields=['datefiled', 'bbl'], name='datasets_do_datefil_2b554d_idx'),
        ),
    ]
