# -*- coding: utf-8 -*-
# Generated by Django 1.10.6 on 2019-04-24 20:01
from __future__ import unicode_literals

import django.contrib.gis.db.models.fields
from django.db import migrations, models


class Migration(migrations.Migration):

    dependencies = [
        ('bmic', '0001_initial'),
    ]

    operations = [
        migrations.CreateModel(
            name='drainfields',
            fields=[
                ('objectid', models.BigIntegerField()),
                ('lot_id', models.IntegerField()),
                ('address', models.CharField(max_length=50)),
                ('name', models.CharField(max_length=50)),
                ('date_const', models.DateField()),
                ('contractor', models.CharField(max_length=50)),
                ('repaired', models.DateField()),
                ('inspected', models.DateField()),
                ('lyr_pass', models.IntegerField()),
                ('sq_ft', models.IntegerField()),
                ('flow', models.IntegerField()),
                ('ihs_funded', models.IntegerField()),
                ('lyr_type', models.CharField(max_length=50)),
                ('notes', models.CharField(max_length=50)),
                ('shape_leng', models.FloatField()),
                ('shape_area', models.FloatField()),
                ('geom', django.contrib.gis.db.models.fields.MultiPolygonField(srid=4326)),
                ('id', models.AutoField(primary_key=True, serialize=False)),
            ],
        ),
        migrations.CreateModel(
            name='onsitewaste',
            fields=[
                ('objectid', models.BigIntegerField()),
                ('lot_id', models.CharField(max_length=50)),
                ('address', models.CharField(max_length=50)),
                ('name', models.CharField(max_length=50)),
                ('tank_size', models.IntegerField()),
                ('last_pumpe', models.DateField()),
                ('pass_fail', models.FloatField()),
                ('inspection', models.DateField()),
                ('notes', models.CharField(max_length=254)),
                ('ft_from_wa', models.IntegerField()),
                ('rstre', models.IntegerField()),
                ('drainfield', models.IntegerField()),
                ('drainfi8el', models.CharField(max_length=50)),
                ('lyr_type', models.CharField(max_length=254)),
                ('city', models.CharField(max_length=50)),
                ('state', models.CharField(max_length=50)),
                ('powts', models.IntegerField()),
                ('yr_cnstrtd', models.IntegerField()),
                ('qstnre_cmp', models.CharField(max_length=15)),
                ('occupnts_c', models.IntegerField()),
                ('occupnts_a', models.IntegerField()),
                ('vacant_mon', models.IntegerField()),
                ('nmbr_bedro', models.IntegerField()),
                ('water_mete', models.CharField(max_length=15)),
                ('backup', models.CharField(max_length=15)),
                ('system_rep', models.CharField(max_length=50)),
                ('inspcted_o', models.CharField(max_length=15)),
                ('inspcted_w', models.CharField(max_length=30)),
                ('inspcted_f', models.CharField(max_length=10)),
                ('service_co', models.CharField(max_length=15)),
                ('srvc_cntrc', models.CharField(max_length=35)),
                ('tnk_last_p', models.DateField()),
                ('pump_frequ', models.CharField(max_length=15)),
                ('pump_compa', models.CharField(max_length=35)),
                ('size_gal_g', models.IntegerField()),
                ('pump_gpm_t', models.IntegerField()),
                ('pretreat_g', models.IntegerField()),
                ('pump2_gpm_field', models.IntegerField()),
                ('soil_trt_u', models.CharField(max_length=15)),
                ('graywtr_sy', models.CharField(max_length=35)),
                ('observatio', models.CharField(max_length=35)),
                ('tank_mater', models.CharField(max_length=20)),
                ('inletbaffl', models.CharField(max_length=15)),
                ('warning_la', models.CharField(max_length=15)),
                ('locate_cov', models.CharField(max_length=10)),
                ('cover_secu', models.CharField(max_length=10)),
                ('srfc_wtr_i', models.CharField(max_length=10)),
                ('fail_indic', models.CharField(max_length=10)),
                ('inspect_li', models.CharField(max_length=10)),
                ('effluent_f', models.CharField(max_length=10)),
                ('run_op_tes', models.CharField(max_length=10)),
                ('gall_added', models.IntegerField()),
                ('pump_out_p', models.CharField(max_length=10)),
                ('backflow_c', models.CharField(max_length=50)),
                ('inspect_pr', models.CharField(max_length=10)),
                ('inspect_ba', models.CharField(max_length=10)),
                ('dosing_pum', models.CharField(max_length=10)),
                ('integrity_field', models.CharField(max_length=10)),
                ('pump_eleva', models.CharField(max_length=10)),
                ('pump_work', models.CharField(max_length=10)),
                ('checkvalve', models.CharField(max_length=10)),
                ('high_water', models.CharField(max_length=10)),
                ('alarm_work', models.CharField(max_length=10)),
                ('electrical', models.CharField(max_length=10)),
                ('clean_pump', models.CharField(max_length=10)),
                ('probe_soil', models.CharField(max_length=10)),
                ('gravity_pr', models.CharField(max_length=15)),
                ('previous_f', models.CharField(max_length=10)),
                ('seepage', models.CharField(max_length=10)),
                ('lush_veget', models.CharField(max_length=10)),
                ('ponding', models.CharField(max_length=10)),
                ('even_distr', models.CharField(max_length=10)),
                ('feet_to_we', models.IntegerField()),
                ('groundwate', models.CharField(max_length=10)),
                ('depth_to_s', models.IntegerField()),
                ('pretreatme', models.CharField(max_length=25)),
                ('pretreat_1', models.CharField(max_length=25)),
                ('pretreat_2', models.CharField(max_length=35)),
                ('soil_treat', models.CharField(max_length=25)),
                ('soil_area_field', models.CharField(max_length=35)),
                ('pump_tank', models.CharField(max_length=25)),
                ('pump_tank_field', models.CharField(max_length=35)),
                ('inspector', models.CharField(max_length=35)),
                ('inspecti_1', models.DateField()),
                ('data_entry', models.CharField(max_length=35)),
                ('data_ent_1', models.DateField()),
                ('latitude', models.CharField(max_length=25)),
                ('longitude', models.CharField(max_length=25)),
                ('geom', django.contrib.gis.db.models.fields.MultiPointField(srid=4326)),
                ('id', models.AutoField(primary_key=True, serialize=False)),
            ],
        ),
        migrations.CreateModel(
            name='onsitewastewater',
            fields=[
                ('objectid', models.BigIntegerField()),
                ('lot_id', models.IntegerField()),
                ('address', models.CharField(max_length=50)),
                ('name', models.CharField(max_length=50)),
                ('volume', models.IntegerField()),
                ('tank_manuf', models.CharField(max_length=50)),
                ('tank_type', models.CharField(max_length=50)),
                ('inspected', models.DateField()),
                ('last_inspe', models.DateField()),
                ('pumped', models.DateField()),
                ('lastpumped', models.DateField()),
                ('flow', models.IntegerField()),
                ('lyr_filter', models.IntegerField()),
                ('last_filte', models.DateField()),
                ('pass_failu', models.CharField(max_length=50)),
                ('cover_secu', models.IntegerField()),
                ('inspection', models.CharField(max_length=50)),
                ('geom', django.contrib.gis.db.models.fields.MultiPointField(srid=4326)),
                ('id', models.AutoField(primary_key=True, serialize=False)),
            ],
        ),
        migrations.CreateModel(
            name='septic_tanks',
            fields=[
                ('objectid', models.BigIntegerField()),
                ('lot_id', models.IntegerField()),
                ('address', models.CharField(max_length=50)),
                ('name', models.CharField(max_length=50)),
                ('volume', models.IntegerField()),
                ('tank_manuf', models.CharField(max_length=50)),
                ('tank_type', models.CharField(max_length=50)),
                ('inspected', models.DateField()),
                ('last_inspe', models.DateField()),
                ('pumped', models.DateField()),
                ('lastpumped', models.DateField()),
                ('flow', models.IntegerField()),
                ('lyr_filter', models.IntegerField()),
                ('last_filte', models.DateField()),
                ('pass_failu', models.CharField(max_length=50)),
                ('cover_secu', models.IntegerField()),
                ('inspection', models.CharField(max_length=50)),
                ('shape_leng', models.FloatField()),
                ('shape_area', models.FloatField()),
                ('geom', django.contrib.gis.db.models.fields.MultiPolygonField(srid=4326)),
                ('id', models.AutoField(primary_key=True, serialize=False)),
            ],
        ),
        migrations.CreateModel(
            name='trails',
            fields=[
                ('begin', models.CharField(max_length=254)),
                ('end', models.CharField(max_length=254)),
                ('path', models.CharField(max_length=200)),
                ('geom', django.contrib.gis.db.models.fields.MultiLineStringField(srid=4326)),
                ('id', models.AutoField(primary_key=True, serialize=False)),
            ],
        ),
    ]
