# Generated by Django 5.2.13 on 2026-04-24 07:49 import django.db.models.deletion import simple_history.models from django.conf import settings from django.db import migrations, models class Migration(migrations.Migration): dependencies = [ ("contenttypes", "0002_remove_content_type_name"), ("mel_indicators", "0002_historicalindicatorvariance_indicatorvariance_and_more"), ("mel_tracking", "0001_initial"), 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" ), ), ("name", models.CharField(max_length=255)), ("description", models.TextField(blank=True)), ("scheduled_start", models.DateField()), ("scheduled_end", models.DateField()), ("actual_start", models.DateField(blank=True, null=True)), ("actual_end", models.DateField(blank=True, null=True)), ( "status", models.CharField( choices=[ ("planned", "Planned"), ("in_progress", "In progress"), ("delayed", "Delayed"), ("completed", "Completed"), ("cancelled", "Cancelled"), ], db_index=True, default="planned", max_length=16, ), ), ("deviation_flag", models.BooleanField(db_index=True, default=False)), ("deviation_reason", models.TextField(blank=True)), ("created_at", models.DateTimeField(auto_now_add=True)), ("updated_at", models.DateTimeField(auto_now=True)), ( "logframe_row", models.ForeignKey( help_text="Must reference a row at ACTIVITY level.", on_delete=django.db.models.deletion.PROTECT, related_name="tracked_activities", to="mel_indicators.logframerow", ), ), ( "parent", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.PROTECT, related_name="children", to="mel_tracking.activity", ), ), ( "responsible", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="mel_activities_responsible", to=settings.AUTH_USER_MODEL, ), ), ], options={ "verbose_name_plural": "activities", "ordering": ["scheduled_start", "name"], }, ), migrations.CreateModel( name="ActivityDependency", fields=[ ( "id", models.BigAutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID" ), ), ( "dependency_type", models.CharField( choices=[ ("fs", "Finish-to-start"), ("ss", "Start-to-start"), ("ff", "Finish-to-finish"), ], default="fs", max_length=2, ), ), ("created_at", models.DateTimeField(auto_now_add=True)), ( "from_activity", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="outgoing_dependencies", to="mel_tracking.activity", ), ), ( "to_activity", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="incoming_dependencies", to="mel_tracking.activity", ), ), ], options={ "verbose_name_plural": "activity dependencies", }, ), migrations.CreateModel( name="CorrectiveAction", fields=[ ( "id", models.BigAutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID" ), ), ("subject_id", models.PositiveIntegerField()), ("title", models.CharField(max_length=255)), ("root_cause", models.TextField()), ("action_plan", models.TextField()), ("due_date", models.DateField(blank=True, null=True)), ( "status", models.CharField( choices=[ ("open", "Open"), ("in_progress", "In progress"), ("done", "Done"), ("cancelled", "Cancelled"), ], db_index=True, default="open", max_length=16, ), ), ("outcome_note", models.TextField(blank=True)), ("created_at", models.DateTimeField(auto_now_add=True)), ("updated_at", models.DateTimeField(auto_now=True)), ("closed_at", models.DateTimeField(blank=True, null=True)), ( "created_by", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="mel_corrective_actions_created", to=settings.AUTH_USER_MODEL, ), ), ( "owner", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="mel_corrective_actions_owned", to=settings.AUTH_USER_MODEL, ), ), ( "subject_type", models.ForeignKey( on_delete=django.db.models.deletion.PROTECT, related_name="mel_corrective_actions", to="contenttypes.contenttype", ), ), ], options={ "ordering": ["-created_at"], }, ), migrations.CreateModel( name="HistoricalActivity", fields=[ ( "id", models.BigIntegerField( auto_created=True, blank=True, db_index=True, verbose_name="ID" ), ), ("name", models.CharField(max_length=255)), ("description", models.TextField(blank=True)), ("scheduled_start", models.DateField()), ("scheduled_end", models.DateField()), ("actual_start", models.DateField(blank=True, null=True)), ("actual_end", models.DateField(blank=True, null=True)), ( "status", models.CharField( choices=[ ("planned", "Planned"), ("in_progress", "In progress"), ("delayed", "Delayed"), ("completed", "Completed"), ("cancelled", "Cancelled"), ], db_index=True, default="planned", max_length=16, ), ), ("deviation_flag", models.BooleanField(db_index=True, default=False)), ("deviation_reason", models.TextField(blank=True)), ("created_at", models.DateTimeField(blank=True, editable=False)), ("updated_at", models.DateTimeField(blank=True, editable=False)), ("history_id", models.AutoField(primary_key=True, serialize=False)), ("history_date", models.DateTimeField(db_index=True)), ("history_change_reason", models.CharField(max_length=100, null=True)), ( "history_type", models.CharField( choices=[("+", "Created"), ("~", "Changed"), ("-", "Deleted")], max_length=1 ), ), ( "history_user", models.ForeignKey( null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="+", to=settings.AUTH_USER_MODEL, ), ), ( "logframe_row", models.ForeignKey( blank=True, db_constraint=False, help_text="Must reference a row at ACTIVITY level.", null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", to="mel_indicators.logframerow", ), ), ( "parent", models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", to="mel_tracking.activity", ), ), ( "responsible", models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", to=settings.AUTH_USER_MODEL, ), ), ], options={ "verbose_name": "historical activity", "verbose_name_plural": "historical activities", "ordering": ("-history_date", "-history_id"), "get_latest_by": ("history_date", "history_id"), }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name="HistoricalCorrectiveAction", fields=[ ( "id", models.BigIntegerField( auto_created=True, blank=True, db_index=True, verbose_name="ID" ), ), ("subject_id", models.PositiveIntegerField()), ("title", models.CharField(max_length=255)), ("root_cause", models.TextField()), ("action_plan", models.TextField()), ("due_date", models.DateField(blank=True, null=True)), ( "status", models.CharField( choices=[ ("open", "Open"), ("in_progress", "In progress"), ("done", "Done"), ("cancelled", "Cancelled"), ], db_index=True, default="open", max_length=16, ), ), ("outcome_note", models.TextField(blank=True)), ("created_at", models.DateTimeField(blank=True, editable=False)), ("updated_at", models.DateTimeField(blank=True, editable=False)), ("closed_at", models.DateTimeField(blank=True, null=True)), ("history_id", models.AutoField(primary_key=True, serialize=False)), ("history_date", models.DateTimeField(db_index=True)), ("history_change_reason", models.CharField(max_length=100, null=True)), ( "history_type", models.CharField( choices=[("+", "Created"), ("~", "Changed"), ("-", "Deleted")], max_length=1 ), ), ( "created_by", models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", to=settings.AUTH_USER_MODEL, ), ), ( "history_user", models.ForeignKey( null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="+", to=settings.AUTH_USER_MODEL, ), ), ( "owner", models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", to=settings.AUTH_USER_MODEL, ), ), ( "subject_type", models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", to="contenttypes.contenttype", ), ), ], options={ "verbose_name": "historical corrective action", "verbose_name_plural": "historical corrective actions", "ordering": ("-history_date", "-history_id"), "get_latest_by": ("history_date", "history_id"), }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name="HistoricalOutputDeliverable", fields=[ ( "id", models.BigIntegerField( auto_created=True, blank=True, db_index=True, verbose_name="ID" ), ), ("title", models.CharField(max_length=255)), ("description", models.TextField(blank=True)), ("target_quantity", models.DecimalField(decimal_places=4, max_digits=14)), ( "achieved_quantity", models.DecimalField(decimal_places=4, default=0, max_digits=14), ), ("unit", models.CharField(max_length=60)), ("due_date", models.DateField(blank=True, null=True)), ( "status", models.CharField( choices=[ ("draft", "Draft"), ("in_progress", "In progress"), ("completed", "Completed"), ("overdue", "Overdue"), ], default="draft", max_length=16, ), ), ("evidence_url", models.URLField(blank=True)), ("created_at", models.DateTimeField(blank=True, editable=False)), ("updated_at", models.DateTimeField(blank=True, editable=False)), ("history_id", models.AutoField(primary_key=True, serialize=False)), ("history_date", models.DateTimeField(db_index=True)), ("history_change_reason", models.CharField(max_length=100, null=True)), ( "history_type", models.CharField( choices=[("+", "Created"), ("~", "Changed"), ("-", "Deleted")], max_length=1 ), ), ( "history_user", models.ForeignKey( null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="+", to=settings.AUTH_USER_MODEL, ), ), ( "logframe_row", models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", to="mel_indicators.logframerow", ), ), ], options={ "verbose_name": "historical output deliverable", "verbose_name_plural": "historical output deliverables", "ordering": ("-history_date", "-history_id"), "get_latest_by": ("history_date", "history_id"), }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name="OutputDeliverable", fields=[ ( "id", models.BigAutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID" ), ), ("title", models.CharField(max_length=255)), ("description", models.TextField(blank=True)), ("target_quantity", models.DecimalField(decimal_places=4, max_digits=14)), ( "achieved_quantity", models.DecimalField(decimal_places=4, default=0, max_digits=14), ), ("unit", models.CharField(max_length=60)), ("due_date", models.DateField(blank=True, null=True)), ( "status", models.CharField( choices=[ ("draft", "Draft"), ("in_progress", "In progress"), ("completed", "Completed"), ("overdue", "Overdue"), ], default="draft", max_length=16, ), ), ("evidence_url", models.URLField(blank=True)), ("created_at", models.DateTimeField(auto_now_add=True)), ("updated_at", models.DateTimeField(auto_now=True)), ( "logframe_row", models.ForeignKey( on_delete=django.db.models.deletion.PROTECT, related_name="tracked_outputs", to="mel_indicators.logframerow", ), ), ], options={ "ordering": ["due_date", "title"], }, ), migrations.AddIndex( model_name="activity", index=models.Index( fields=["status", "scheduled_end"], name="mel_trackin_status_4fa04e_idx" ), ), migrations.AddIndex( model_name="activity", index=models.Index(fields=["deviation_flag"], name="mel_trackin_deviati_371e7b_idx"), ), migrations.AddIndex( model_name="activity", index=models.Index(fields=["logframe_row"], name="mel_trackin_logfram_464323_idx"), ), migrations.AddConstraint( model_name="activity", constraint=models.CheckConstraint( condition=models.Q(("scheduled_end__gte", models.F("scheduled_start"))), name="activity_schedule_ordering", ), ), migrations.AddConstraint( model_name="activitydependency", constraint=models.UniqueConstraint( fields=("from_activity", "to_activity"), name="uniq_activity_dependency" ), ), migrations.AddConstraint( model_name="activitydependency", constraint=models.CheckConstraint( condition=models.Q(("from_activity", models.F("to_activity")), _negated=True), name="activity_dependency_not_self", ), ), migrations.AddIndex( model_name="correctiveaction", index=models.Index( fields=["subject_type", "subject_id"], name="mel_trackin_subject_b0d026_idx" ), ), migrations.AddIndex( model_name="correctiveaction", index=models.Index(fields=["status", "due_date"], name="mel_trackin_status_b98367_idx"), ), migrations.AddIndex( model_name="outputdeliverable", index=models.Index(fields=["status", "due_date"], name="mel_trackin_status_f7ffda_idx"), ), migrations.AddIndex( model_name="outputdeliverable", index=models.Index(fields=["logframe_row"], name="mel_trackin_logfram_fa8937_idx"), ), ]