# Generated by Django 5.1.3 on 2026-05-30 15:47 import django.db.models.deletion import uuid from django.conf import settings from django.db import migrations, models class Migration(migrations.Migration): initial = True dependencies = [ ("organizations", "0002_workspace_template_user_context_pref"), ("projects", "0001_initial"), ("tenants", "0001_initial"), migrations.swappable_dependency(settings.AUTH_USER_MODEL), ] operations = [ migrations.CreateModel( name="Task", 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", ), ), ("title", models.CharField(max_length=500, verbose_name="title")), ( "description", models.TextField(blank=True, default="", verbose_name="description"), ), ( "status", models.CharField( choices=[ ("todo", "To Do"), ("in_progress", "In Progress"), ("in_review", "In Review"), ("done", "Done"), ("cancelled", "Cancelled"), ], db_index=True, default="todo", max_length=20, verbose_name="status", ), ), ( "priority", models.CharField( choices=[ ("none", "None"), ("low", "Low"), ("medium", "Medium"), ("high", "High"), ("urgent", "Urgent"), ], db_index=True, default="none", max_length=10, verbose_name="priority", ), ), ("due_date", models.DateField(blank=True, null=True, verbose_name="due date")), ( "estimated_hours", models.DecimalField( blank=True, decimal_places=2, max_digits=7, null=True, verbose_name="estimated hours", ), ), ("order", models.FloatField(db_index=True, default=0.0, verbose_name="order")), ( "assignee", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="assigned_tasks", to=settings.AUTH_USER_MODEL, verbose_name="assignee", ), ), ( "organization_node", models.ForeignKey( on_delete=django.db.models.deletion.PROTECT, related_name="+", to="organizations.organizationnode", verbose_name="organization node", ), ), ( "parent", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="subtasks", to="tasks.task", verbose_name="parent task", ), ), ( "phase", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="tasks", to="projects.projectphase", verbose_name="phase", ), ), ( "project", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="tasks", to="projects.project", verbose_name="project", ), ), ( "reporter", models.ForeignKey( on_delete=django.db.models.deletion.PROTECT, related_name="reported_tasks", to=settings.AUTH_USER_MODEL, verbose_name="reporter", ), ), ( "tenant", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="+", to="tenants.tenant", verbose_name="tenant", ), ), ], options={ "verbose_name": "task", "verbose_name_plural": "tasks", "ordering": ["order", "created_at"], "abstract": False, }, ), migrations.CreateModel( name="TaskAttachment", 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")), ("dms_file_id", models.UUIDField(db_index=True, verbose_name="DMS file ID")), ( "filename", models.CharField( blank=True, default="", max_length=255, verbose_name="filename" ), ), ( "task", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="attachments", to="tasks.task", ), ), ( "uploaded_by", models.ForeignKey( null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="task_attachments", to=settings.AUTH_USER_MODEL, ), ), ], options={ "verbose_name": "task attachment", "verbose_name_plural": "task attachments", "ordering": ["created_at"], }, ), migrations.CreateModel( name="TaskComment", 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")), ("body", models.TextField(verbose_name="body")), ("is_edited", models.BooleanField(default=False, verbose_name="is edited")), ( "author", models.ForeignKey( null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="task_comments", to=settings.AUTH_USER_MODEL, ), ), ( "task", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="comments", to="tasks.task", ), ), ], options={ "verbose_name": "task comment", "verbose_name_plural": "task comments", "ordering": ["created_at"], }, ), migrations.CreateModel( name="TaskStatusChange", fields=[ ( "id", models.BigAutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID" ), ), ("from_status", models.CharField(max_length=20, verbose_name="from status")), ("to_status", models.CharField(max_length=20, verbose_name="to status")), ("changed_at", models.DateTimeField(auto_now_add=True, verbose_name="changed at")), ( "changed_by", models.ForeignKey( null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="task_status_changes", to=settings.AUTH_USER_MODEL, ), ), ( "task", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="status_changes", to="tasks.task", ), ), ], options={ "verbose_name": "task status change", "verbose_name_plural": "task status changes", "ordering": ["changed_at"], }, ), migrations.CreateModel( name="TaskTag", 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")), ( "color", models.CharField(blank=True, default="", max_length=20, verbose_name="color"), ), ( "tenant", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="task_tags", to="tenants.tenant", ), ), ], options={ "verbose_name": "task tag", "verbose_name_plural": "task tags", }, ), migrations.AddField( model_name="task", name="tags", field=models.ManyToManyField( blank=True, related_name="tasks", to="tasks.tasktag", verbose_name="tags" ), ), migrations.CreateModel( name="TaskWatcher", fields=[ ( "id", models.BigAutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID" ), ), ( "task", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="watchers", to="tasks.task", ), ), ( "user", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="watched_tasks", to=settings.AUTH_USER_MODEL, ), ), ], options={ "verbose_name": "task watcher", "verbose_name_plural": "task watchers", }, ), migrations.AddConstraint( model_name="tasktag", constraint=models.UniqueConstraint( fields=("tenant", "name"), name="tasks_tag_unique_tenant_name" ), ), migrations.AddIndex( model_name="task", index=models.Index( fields=["tenant", "organization_node"], name="tasks_task_tenant__849360_idx" ), ), migrations.AddIndex( model_name="task", index=models.Index( fields=["tenant", "project", "status"], name="tasks_task_tenant_proj_status" ), ), migrations.AddIndex( model_name="task", index=models.Index( fields=["tenant", "assignee", "status"], name="tasks_task_tenant_asgn_status" ), ), migrations.AddIndex( model_name="task", index=models.Index(fields=["tenant", "due_date"], name="tasks_task_tenant_due_date"), ), migrations.AddConstraint( model_name="taskwatcher", constraint=models.UniqueConstraint( fields=("task", "user"), name="tasks_watcher_unique_task_user" ), ), ]