# Generated by Django 5.2.6 on 2026-05-30 11:36 import django.core.validators import django.db.models.deletion import uuid from django.conf import settings from django.db import migrations, models class Migration(migrations.Migration): dependencies = [ ("crm", "0001_initial"), ("organizations", "0002_workspace_template_user_context_pref"), ("tenants", "0001_initial"), migrations.swappable_dependency(settings.AUTH_USER_MODEL), ] operations = [ migrations.CreateModel( name="Lead", fields=[ ( "id", models.BigAutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID" ), ), ( "is_deleted", models.BooleanField(db_index=True, default=False, verbose_name="deleted"), ), ( "deleted_at", models.DateTimeField(blank=True, null=True, verbose_name="deleted at"), ), ( "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", ), ), ("title", models.CharField(max_length=200, verbose_name="title")), ( "source", models.CharField( choices=[ ("website", "Website"), ("referral", "Referral"), ("cold_call", "Cold Call"), ("social", "Social"), ("event", "Event"), ("trade_show", "Trade Show"), ("manual", "Manual"), ], default="manual", max_length=20, verbose_name="source", ), ), ( "score", models.PositiveSmallIntegerField( default=0, validators=[django.core.validators.MaxValueValidator(100)], verbose_name="score", ), ), ( "status", models.CharField( choices=[ ("new", "New"), ("contacted", "Contacted"), ("qualified", "Qualified"), ("converted", "Converted"), ("lost", "Lost"), ], default="new", max_length=20, verbose_name="status", ), ), ("notes", models.TextField(blank=True, default="", verbose_name="notes")), ( "custom_fields", models.JSONField(blank=True, default=dict, verbose_name="custom fields"), ), ( "contact", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="leads", to="crm.contact", verbose_name="contact", ), ), ( "deleted_by", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="+", to=settings.AUTH_USER_MODEL, verbose_name="deleted by", ), ), ( "organization_node", models.ForeignKey( on_delete=django.db.models.deletion.PROTECT, related_name="+", to="organizations.organizationnode", verbose_name="organization node", ), ), ( "owner", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="owned_leads", to=settings.AUTH_USER_MODEL, verbose_name="owner", ), ), ( "tenant", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="+", to="tenants.tenant", verbose_name="tenant", ), ), ], options={ "verbose_name": "lead", "verbose_name_plural": "leads", "ordering": ["-created_at"], }, ), migrations.CreateModel( name="Opportunity", fields=[ ( "id", models.BigAutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID" ), ), ( "is_deleted", models.BooleanField(db_index=True, default=False, verbose_name="deleted"), ), ( "deleted_at", models.DateTimeField(blank=True, null=True, verbose_name="deleted at"), ), ( "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", ), ), ("title", models.CharField(max_length=200, verbose_name="title")), ( "amount", models.DecimalField( decimal_places=2, default=0, max_digits=14, verbose_name="amount" ), ), ( "currency", models.CharField(default="USD", max_length=3, verbose_name="currency"), ), ( "expected_close", models.DateField(blank=True, null=True, verbose_name="expected close"), ), ( "probability", models.PositiveSmallIntegerField( blank=True, null=True, validators=[django.core.validators.MaxValueValidator(100)], verbose_name="probability (%)", ), ), ( "status", models.CharField( choices=[("open", "Open"), ("won", "Won"), ("lost", "Lost")], default="open", max_length=10, verbose_name="status", ), ), ( "closed_at", models.DateTimeField(blank=True, null=True, verbose_name="closed at"), ), ( "lost_reason", models.TextField(blank=True, default="", verbose_name="lost reason"), ), ( "contact", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="opportunities", to="crm.contact", verbose_name="contact", ), ), ( "deleted_by", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="+", to=settings.AUTH_USER_MODEL, verbose_name="deleted by", ), ), ( "lead", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="opportunities", to="crm.lead", verbose_name="lead", ), ), ( "organization_node", models.ForeignKey( on_delete=django.db.models.deletion.PROTECT, related_name="+", to="organizations.organizationnode", verbose_name="organization node", ), ), ( "owner", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="owned_opportunities", to=settings.AUTH_USER_MODEL, verbose_name="owner", ), ), ( "tenant", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="+", to="tenants.tenant", verbose_name="tenant", ), ), ], options={ "verbose_name": "opportunity", "verbose_name_plural": "opportunities", "ordering": ["-created_at"], }, ), migrations.CreateModel( name="CRMActivity", 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", ), ), ( "type", models.CharField( choices=[ ("call", "Call"), ("meeting", "Meeting"), ("email", "Email"), ("task", "Task"), ("note", "Note"), ], default="task", max_length=20, verbose_name="type", ), ), ("title", models.CharField(max_length=200, verbose_name="title")), ("notes", models.TextField(blank=True, default="", verbose_name="notes")), ("due_at", models.DateTimeField(blank=True, null=True, verbose_name="due at")), ( "completed_at", models.DateTimeField(blank=True, null=True, verbose_name="completed at"), ), ("is_done", models.BooleanField(default=False, verbose_name="done")), ( "contact", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="activities", to="crm.contact", verbose_name="contact", ), ), ( "owner", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="crm_activities", to=settings.AUTH_USER_MODEL, verbose_name="owner", ), ), ( "tenant", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="crm_activities", to="tenants.tenant", verbose_name="tenant", ), ), ( "lead", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="activities", to="crm.lead", verbose_name="lead", ), ), ( "opportunity", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="activities", to="crm.opportunity", verbose_name="opportunity", ), ), ], options={ "verbose_name": "CRM activity", "verbose_name_plural": "CRM activities", "ordering": ["-created_at"], }, ), migrations.CreateModel( name="Pipeline", 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=100, verbose_name="name")), ("is_default", models.BooleanField(default=False, verbose_name="default")), ( "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": "pipeline", "verbose_name_plural": "pipelines", "ordering": ["name"], }, ), migrations.CreateModel( name="PipelineStage", 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=100, verbose_name="name")), ("order", models.PositiveSmallIntegerField(default=0, verbose_name="order")), ( "probability_pct", models.PositiveSmallIntegerField( default=0, validators=[django.core.validators.MaxValueValidator(100)], verbose_name="probability (%)", ), ), ( "color", models.CharField( blank=True, default="#6366f1", max_length=20, verbose_name="color" ), ), ("is_won", models.BooleanField(default=False, verbose_name="is won")), ("is_lost", models.BooleanField(default=False, verbose_name="is lost")), ( "pipeline", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="stages", to="crm.pipeline", verbose_name="pipeline", ), ), ], options={ "verbose_name": "pipeline stage", "verbose_name_plural": "pipeline stages", "ordering": ["pipeline", "order"], }, ), migrations.AddField( model_name="opportunity", name="pipeline_stage", field=models.ForeignKey( on_delete=django.db.models.deletion.PROTECT, related_name="opportunities", to="crm.pipelinestage", verbose_name="pipeline stage", ), ), migrations.AddIndex( model_name="lead", index=models.Index(fields=["tenant", "status"], name="crm_lead_tenant__3e1c47_idx"), ), migrations.AddIndex( model_name="lead", index=models.Index(fields=["tenant", "owner"], name="crm_lead_tenant__92c804_idx"), ), migrations.AddIndex( model_name="crmactivity", index=models.Index( fields=["tenant", "owner", "is_done"], name="crm_crmacti_tenant__0ab764_idx" ), ), migrations.AddIndex( model_name="crmactivity", index=models.Index(fields=["tenant", "due_at"], name="crm_crmacti_tenant__e99fdd_idx"), ), migrations.AddConstraint( model_name="pipeline", constraint=models.UniqueConstraint( fields=("tenant", "name"), name="crm_pipeline_unique_per_tenant" ), ), migrations.AddIndex( model_name="opportunity", index=models.Index( fields=["tenant", "pipeline_stage"], name="crm_opportu_tenant__c39fdf_idx" ), ), migrations.AddIndex( model_name="opportunity", index=models.Index( fields=["tenant", "owner", "status"], name="crm_opportu_tenant__908c84_idx" ), ), ]