# -*- coding: utf-8 -*-
# Generated by Django 1.11.7 on 2017-11-13 12:15
from __future__ import unicode_literals

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


class Migration(migrations.Migration):

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

    operations = [
        migrations.CreateModel(
            name='Manhole',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created', models.DateTimeField()),
                ('code', models.CharField(default=None, max_length=50, null=True, verbose_name='code')),
                ('surface_level', models.FloatField(null=True, verbose_name='surface level')),
                ('drainage_area', models.IntegerField(null=True, verbose_name='drainage area')),
                ('material', models.CharField(max_length=4, verbose_name='material')),
                ('width', models.FloatField(null=True, verbose_name='width')),
                ('length', models.FloatField(null=True, verbose_name='length')),
                ('shape', models.CharField(max_length=4, verbose_name='shape')),
                ('bottom_level', models.FloatField(null=True, verbose_name='bottom level')),
                ('image_url', models.CharField(max_length=255)),
                ('end', models.DateTimeField(null=True)),
                ('num_timeseries', models.IntegerField(default=0)),
                ('water_consumption', models.FloatField(null=True, verbose_name='water consumption')),
                ('geometry', django.contrib.gis.db.models.fields.PointField(dim=3, null=True, srid=4326, verbose_name='geometry')),
            ],
        ),
        migrations.CreateModel(
            name='Organisation',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name', models.CharField(max_length=100)),
            ],
        ),
        migrations.AddField(
            model_name='manhole',
            name='organisation',
            field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to='lizard.Organisation'),
        ),
    ]
