# Generated by Django 5.2.6 on 2025-11-30 20:02

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


class Migration(migrations.Migration):

    dependencies = [
        ('habitats_and_biotopes', '0001_biotopecode'),
    ]

    operations = [
        migrations.CreateModel(
            name='GwyneddNrwPh1IntertidalBiotope',
            fields=[
                ('gid', models.AutoField(primary_key=True, serialize=False)),
                ('geom', django.contrib.gis.db.models.fields.MultiPolygonField(blank=True, null=True, srid=27700)),
                ('objectid', models.IntegerField(blank=True, null=True)),
                ('polygonid', models.FloatField(blank=True, null=True)),
                ('siteid', models.FloatField(blank=True, null=True)),
                ('siteno', models.CharField(blank=True, null=True)),
                ('biotopeid', models.FloatField(blank=True, null=True)),
                ('biotope', models.CharField(blank=True, null=True)),
                ('maptext', models.CharField(blank=True, null=True)),
                ('lifeform', models.CharField(blank=True, null=True)),
                ('areaha', models.FloatField(blank=True, null=True)),
                ('notes', models.CharField(blank=True, null=True)),
                ('artificial', models.CharField(blank=True, null=True)),
                ('type', models.CharField(blank=True, null=True)),
                ('important', models.IntegerField(blank=True, null=True)),
                ('specialise', models.IntegerField(blank=True, null=True)),
                ('habitat', models.CharField(blank=True, null=True)),
                ('visit', models.DateField(blank=True, null=True)),
                ('last_visit', models.DateField(blank=True, null=True)),
                ('classifica', models.CharField(blank=True, null=True)),
                ('owner', models.CharField(blank=True, null=True)),
                ('data_type', models.CharField(blank=True, null=True)),
                ('f04', models.FloatField(blank=True, null=True)),
                ('f2004_code', models.CharField(blank=True, null=True)),
                ('maptext_04', models.CharField(blank=True, null=True)),
                ('f040', models.CharField(blank=True, null=True)),
                ('substrata', models.CharField(blank=True, null=True)),
                ('globalid', models.CharField(blank=True, null=True)),
                ('shape_star', models.FloatField(blank=True, null=True)),
                ('shape_stle', models.FloatField(blank=True, null=True)),
            ],
            options={
                'db_table': 'gwynedd_nrw_ph1_intertidal_biotope',
                'managed': False,
            },
        ),
        migrations.CreateModel(
            name='GwyneddNrwPh1IntertidalBiotopeNotes',
            fields=[
                ('gid', models.AutoField(primary_key=True, serialize=False)),
                ('geom', django.contrib.gis.db.models.fields.PointField(blank=True, null=True, srid=27700)),
                ('id', models.CharField(blank=True, null=True)),
                ('objectid', models.IntegerField(blank=True, null=True)),
                ('siteid', models.FloatField(blank=True, null=True)),
                ('siteno', models.CharField(blank=True, null=True)),
                ('targetnote', models.IntegerField(blank=True, null=True)),
                ('xcoordinat', models.FloatField(blank=True, null=True)),
                ('ycoordinat', models.FloatField(blank=True, null=True)),
                ('osgridref', models.CharField(blank=True, null=True)),
                ('targetno0', models.CharField(blank=True, null=True)),
                ('targetno1', models.CharField(blank=True, null=True)),
                ('accesslink', models.CharField(blank=True, null=True)),
                ('globalid', models.CharField(blank=True, null=True)),
            ],
            options={
                'db_table': 'gwynedd_nrw_ph1_intertidal_biotope_notes',
                'managed': False,
            },
        ),
        migrations.CreateModel(
            name='GwyneddNrwPh1IntertidalBiotopeSites',
            fields=[
                ('siteid', models.FloatField(primary_key=True, serialize=False)),
                ('siteno', models.CharField(blank=True, null=True)),
                ('geom', django.contrib.gis.db.models.fields.GeometryField(blank=True, null=True, srid=0)),
            ],
            options={
                'db_table': 'gwynedd_nrw_ph1_intertidal_biotope_sites',
                'managed': False,
            },
        ),
        migrations.CreateModel(
            name='IndicatorSpecies',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('f2004_code', models.CharField(db_index=True, help_text='Biotope Code (f2004_code)', max_length=200)),
                ('species_name', models.CharField(db_index=True, max_length=500)),
            ],
            options={
                'db_table': 'indicator_species_v2',
                'ordering': ['f2004_code', 'species_name'],
            },
        ),
        migrations.RenameIndex(
            model_name='biotopecode',
            new_name='biotope_cod_code_550b9f_idx',
            old_name='biotope_code_code_idx',
        ),
        migrations.RenameIndex(
            model_name='biotopecode',
            new_name='biotope_cod_parent__e1c08a_idx',
            old_name='biotope_code_parent_code_idx',
        ),
       
    ]