# Generated by Django 5.1.3 on 2026-05-29 07:15 import django.db.models.deletion import django.utils.timezone import uuid from django.db import migrations, models class Migration(migrations.Migration): initial = True dependencies = [ ("organizations", "0001_initial"), ("tenants", "0001_initial"), ] operations = [ migrations.CreateModel( name="AutomationRule", fields=[ ( "id", models.BigAutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID" ), ), ( "created_at", models.DateTimeField( auto_now_add=True, db_index=True, verbose_name="created at" ), ), ("updated_at", models.DateTimeField(auto_now=True, verbose_name="updated at")), ( "public_id", models.UUIDField( db_index=True, default=uuid.uuid4, editable=False, unique=True, verbose_name="public id", ), ), ("name", models.CharField(max_length=255, verbose_name="name")), ( "description", models.TextField(blank=True, default="", verbose_name="description"), ), ( "is_active", models.BooleanField(db_index=True, default=True, verbose_name="is active"), ), ( "trigger_type", models.CharField( choices=[ ("event", "Event"), ("schedule", "Schedule"), ("manual", "Manual"), ], db_index=True, default="event", max_length=16, verbose_name="trigger type", ), ), ( "trigger_event", models.CharField( blank=True, db_index=True, default="", help_text="Event Bus event name, e.g. 'crm.lead.created'. Required when trigger_type='event'.", max_length=128, verbose_name="trigger event", ), ), ( "trigger_schedule", models.CharField( blank=True, default="", help_text="Standard cron expression, e.g. '0 9 * * 1' (Monday 09:00). Required when trigger_type='schedule'.", max_length=128, verbose_name="trigger schedule", ), ), ( "conditions", models.JSONField( blank=True, default=list, help_text="List of condition objects (see module docstring). Empty list = unconditional match.", verbose_name="conditions", ), ), ( "actions", models.JSONField( blank=True, default=list, help_text="Ordered list of {action, params} objects. Each action key must be registered in the ActionRegistry.", verbose_name="actions", ), ), ("run_count", models.PositiveBigIntegerField(default=0, verbose_name="run count")), ( "last_run_at", models.DateTimeField(blank=True, null=True, verbose_name="last run at"), ), ( "last_status", models.CharField( blank=True, choices=[ ("success", "Success"), ("failed", "Failed"), ("skipped", "Skipped"), ], db_index=True, default="", max_length=10, verbose_name="last status", ), ), ("version", models.PositiveIntegerField(default=1, verbose_name="version")), ( "organization_node", models.ForeignKey( on_delete=django.db.models.deletion.PROTECT, related_name="+", to="organizations.organizationnode", verbose_name="organization node", ), ), ( "tenant", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="+", to="tenants.tenant", verbose_name="tenant", ), ), ], options={ "verbose_name": "automation rule", "verbose_name_plural": "automation rules", "ordering": ("-created_at",), }, ), migrations.CreateModel( name="AutomationExecution", fields=[ ( "id", models.BigAutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID" ), ), ( "created_at", models.DateTimeField( auto_now_add=True, db_index=True, verbose_name="created at" ), ), ("updated_at", models.DateTimeField(auto_now=True, verbose_name="updated at")), ( "public_id", models.UUIDField( db_index=True, default=uuid.uuid4, editable=False, unique=True, verbose_name="public id", ), ), ( "rule_version", models.PositiveIntegerField( default=0, help_text="Snapshot of AutomationRule.version at execution time.", verbose_name="rule version", ), ), ( "trigger_event", models.CharField( blank=True, db_index=True, default="", max_length=128, verbose_name="trigger event", ), ), ("trigger_payload", models.JSONField(default=dict, verbose_name="trigger payload")), ( "idempotency_key", models.CharField( db_index=True, help_text="Unique delivery ID — prevents duplicate execution on retry.", max_length=128, verbose_name="idempotency key", ), ), ( "started_at", models.DateTimeField( db_index=True, default=django.utils.timezone.now, verbose_name="started at" ), ), ( "finished_at", models.DateTimeField(blank=True, null=True, verbose_name="finished at"), ), ( "status", models.CharField( choices=[ ("running", "Running"), ("success", "Success"), ("failed", "Failed"), ("skipped", "Skipped"), ], db_index=True, default="running", max_length=10, verbose_name="status", ), ), ( "actions_executed", models.JSONField( default=list, help_text="Per-action result list. See module docstring for schema.", verbose_name="actions executed", ), ), ( "error_message", models.TextField(blank=True, default="", verbose_name="error message"), ), ( "organization_node", models.ForeignKey( on_delete=django.db.models.deletion.PROTECT, related_name="+", to="organizations.organizationnode", verbose_name="organization node", ), ), ( "tenant", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="+", to="tenants.tenant", verbose_name="tenant", ), ), ( "rule", models.ForeignKey( blank=True, help_text="Null if the rule was deleted after this execution.", null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="executions", to="automation.automationrule", verbose_name="rule", ), ), ], options={ "verbose_name": "automation execution", "verbose_name_plural": "automation executions", "ordering": ("-started_at",), }, ), migrations.CreateModel( name="AutomationTemplate", fields=[ ( "id", models.BigAutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID" ), ), ( "created_at", models.DateTimeField( auto_now_add=True, db_index=True, verbose_name="created at" ), ), ("updated_at", models.DateTimeField(auto_now=True, verbose_name="updated at")), ( "public_id", models.UUIDField( db_index=True, default=uuid.uuid4, editable=False, unique=True, verbose_name="public id", ), ), ("name", models.CharField(max_length=255, verbose_name="name")), ( "description", models.TextField(blank=True, default="", verbose_name="description"), ), ( "category", models.CharField( blank=True, db_index=True, default="", help_text="Module slug, e.g. 'crm', 'helpdesk', 'workflow'.", max_length=64, verbose_name="category", ), ), ( "trigger_type", models.CharField( choices=[ ("event", "Event"), ("schedule", "Schedule"), ("manual", "Manual"), ], default="event", max_length=16, verbose_name="trigger type", ), ), ( "trigger_event", models.CharField( blank=True, default="", max_length=128, verbose_name="trigger event" ), ), ( "default_conditions", models.JSONField(blank=True, default=list, verbose_name="default conditions"), ), ( "default_actions", models.JSONField(blank=True, default=list, verbose_name="default actions"), ), ( "is_system", models.BooleanField( db_index=True, default=False, help_text="System templates are seeded by migrations and are read-only.", verbose_name="is system", ), ), ], options={ "verbose_name": "automation template", "verbose_name_plural": "automation templates", "ordering": ("category", "name"), "indexes": [ models.Index( fields=["category", "is_system"], name="automation__categor_580604_idx" ) ], }, ), migrations.AddIndex( model_name="automationrule", index=models.Index( fields=["tenant", "trigger_event", "is_active"], name="automation__tenant__49d043_idx", ), ), migrations.AddIndex( model_name="automationrule", index=models.Index( fields=["tenant", "trigger_type", "is_active"], name="automation__tenant__56b71e_idx", ), ), migrations.AddIndex( model_name="automationexecution", index=models.Index( fields=["tenant", "status", "started_at"], name="automation__tenant__76d0e1_idx" ), ), migrations.AddIndex( model_name="automationexecution", index=models.Index( fields=["rule", "started_at"], name="automation__rule_id_85da07_idx" ), ), migrations.AddConstraint( model_name="automationexecution", constraint=models.UniqueConstraint( condition=models.Q(("rule__isnull", False)), fields=("rule", "idempotency_key"), name="automation_exec_unique_rule_idem_key", ), ), ]