# Generated by Django 4.2.30 on 2026-06-27 14:51 from django.conf import settings from django.db import migrations, models import django.db.models.deletion import django.utils.timezone class Migration(migrations.Migration): initial = True dependencies = [ migrations.swappable_dependency(settings.AUTH_USER_MODEL), ] operations = [ migrations.CreateModel( name='Activity', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('activity_type', models.CharField(choices=[('planted', 'Planted'), ('watered', 'Watered'), ('observed', 'Observed'), ('transplanted', 'Transplanted'), ('pruned', 'Pruned'), ('photo', 'Photo Uploaded'), ('verified', 'Verified'), ('dead', 'Reported Dead')], max_length=20)), ('note', models.CharField(blank=True, max_length=300)), ('height_cm', models.FloatField(blank=True, null=True)), ('health_status', models.CharField(blank=True, choices=[('alive', 'Alive - Healthy'), ('stressed', 'Alive - Stressed'), ('dead', 'Dead'), ('unknown', 'Unknown')], max_length=20)), ('death_reason', models.CharField(blank=True, choices=[('drought', 'Drought'), ('pests', 'Pests'), ('human', 'Human Activity'), ('unknown', 'Unknown')], max_length=20)), ('latitude', models.FloatField(blank=True, null=True)), ('longitude', models.FloatField(blank=True, null=True)), ('photo', models.ImageField(blank=True, null=True, upload_to='activity_photos/')), ('created_at', models.DateTimeField(default=django.utils.timezone.now)), ], options={ 'verbose_name_plural': 'activities', 'ordering': ['-created_at'], }, ), migrations.CreateModel( name='Asset', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('asset_type', models.CharField(choices=[('tree', 'Tree'), ('nursery', 'Nursery'), ('orchard', 'Orchard Block'), ('forest_block', 'Forest Block'), ('restoration_site', 'Restoration Site'), ('school_garden', 'School Garden'), ('water_source', 'Water Source'), ('seedling', 'Seedling')], default='tree', max_length=20)), ('tag_code', models.CharField(help_text='Auto-generated asset ID / QR code', max_length=50, unique=True)), ('name', models.CharField(blank=True, help_text='Name for nurseries, gardens, sites', max_length=200)), ('latitude', models.FloatField()), ('longitude', models.FloatField()), ('county', models.CharField(blank=True, max_length=100)), ('planted_date', models.DateField(default=django.utils.timezone.localdate, help_text='Planted / established date')), ('photo', models.ImageField(blank=True, null=True, upload_to='asset_photos/')), ('health_status', models.CharField(choices=[('alive', 'Alive - Healthy'), ('stressed', 'Alive - Stressed'), ('dead', 'Dead'), ('unknown', 'Unknown')], default='alive', max_length=20)), ('verification_status', models.CharField(choices=[('verified', 'Verified'), ('pending', 'Pending'), ('suspicious', 'Suspicious')], default='pending', max_length=20)), ('verification_notes', models.CharField(blank=True, max_length=300)), ('photo_hash', models.CharField(blank=True, db_index=True, max_length=64)), ('device_info', models.CharField(blank=True, max_length=200)), ('owner_name', models.CharField(blank=True, max_length=150)), ('owner_contact', models.CharField(blank=True, max_length=50)), ('seedling_capacity', models.PositiveIntegerField(default=0)), ('created_at', models.DateTimeField(auto_now_add=True)), ], options={ 'ordering': ['-created_at'], }, ), migrations.CreateModel( name='Organization', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(max_length=200, unique=True)), ('org_type', models.CharField(choices=[('school', 'School'), ('ngo', 'NGO'), ('county', 'County Government'), ('corporate', 'Corporate'), ('church', 'Church'), ('government', 'Government Agency'), ('community', 'Community Group')], default='ngo', max_length=20)), ('contact_email', models.EmailField(blank=True, max_length=254)), ('county', models.CharField(blank=True, max_length=100)), ('created_at', models.DateTimeField(auto_now_add=True)), ], ), migrations.CreateModel( name='Species', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('common_name', models.CharField(max_length=150)), ('scientific_name', models.CharField(blank=True, max_length=150)), ('is_indigenous', models.BooleanField(default=True)), ('carbon_factor_kg_per_year', models.FloatField(default=10.0, help_text='Estimated kg CO2 sequestered per tree per year, used for carbon reporting.')), ], options={ 'verbose_name_plural': 'species', 'ordering': ['common_name'], }, ), migrations.CreateModel( name='Task', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('task_type', models.CharField(choices=[('check_tree', 'Check tree'), ('review_photo', 'Review photo'), ('water_nursery', 'Water nursery')], max_length=20)), ('title', models.CharField(max_length=200)), ('status', models.CharField(choices=[('pending', 'Pending'), ('done', 'Done')], default='pending', max_length=10)), ('created_at', models.DateTimeField(default=django.utils.timezone.now)), ('completed_at', models.DateTimeField(blank=True, null=True)), ('asset', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='tasks', to='trees.asset')), ('assigned_to', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='tasks', to=settings.AUTH_USER_MODEL)), ('organization', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='tasks', to='trees.organization')), ], options={ 'ordering': ['-created_at'], }, ), migrations.CreateModel( name='Profile', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('role', models.CharField(choices=[('student', 'Student'), ('teacher', 'Teacher'), ('farmer', 'Farmer'), ('nursery_manager', 'Nursery Manager'), ('org_admin', 'Organization Admin'), ('community', 'Community Group'), ('jm3_admin', 'JM3 Admin')], default='student', max_length=20)), ('manages', models.CharField(blank=True, choices=[('trees', 'Trees'), ('nursery', 'Nursery'), ('both', 'Trees & Nursery')], default='trees', max_length=10)), ('phone', models.CharField(blank=True, max_length=30)), ('county', models.CharField(blank=True, max_length=100)), ('organization', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='members', to='trees.organization')), ('user', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, related_name='profile', to=settings.AUTH_USER_MODEL)), ], ), migrations.CreateModel( name='Media', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('image', models.ImageField(upload_to='media/')), ('latitude', models.FloatField(blank=True, null=True)), ('longitude', models.FloatField(blank=True, null=True)), ('device', models.CharField(blank=True, max_length=200)), ('sha256', models.CharField(blank=True, db_index=True, max_length=64)), ('created_at', models.DateTimeField(default=django.utils.timezone.now)), ('activity', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='media', to='trees.activity')), ('asset', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='media', to='trees.asset')), ('user', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, to=settings.AUTH_USER_MODEL)), ], options={ 'verbose_name_plural': 'media', 'ordering': ['-created_at'], }, ), migrations.AddField( model_name='asset', name='organization', field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='assets', to='trees.organization'), ), migrations.AddField( model_name='asset', name='registered_by', field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='registered_assets', to=settings.AUTH_USER_MODEL), ), migrations.AddField( model_name='asset', name='source_nursery', field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='sourced_assets', to='trees.asset'), ), migrations.AddField( model_name='asset', name='species', field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.PROTECT, related_name='assets', to='trees.species'), ), migrations.AddField( model_name='asset', name='species_available', field=models.ManyToManyField(blank=True, related_name='available_in', to='trees.species'), ), migrations.AddField( model_name='activity', name='asset', field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='activities', to='trees.asset'), ), migrations.AddField( model_name='activity', name='user', field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='activities', to=settings.AUTH_USER_MODEL), ), ]