# Generated by Django 5.2.6 on 2026-06-13 13:46 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"), ("platform_workflow", "0002_process_definition"), ("platform_workspaces", "0004_workspacerolekgrant"), ("tenants", "0001_initial"), migrations.swappable_dependency(settings.AUTH_USER_MODEL), ] operations = [ migrations.CreateModel( name="ContentCategory", 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", ), ), ( "sort_order", models.PositiveIntegerField( db_index=True, default=0, verbose_name="sort order" ), ), ("name", models.CharField(max_length=200, verbose_name="name")), ("slug", models.SlugField(max_length=200, verbose_name="slug")), ( "description", models.TextField(blank=True, default="", verbose_name="description"), ), ( "icon", models.CharField(blank=True, default="", max_length=50, verbose_name="icon"), ), ( "is_active", models.BooleanField(db_index=True, default=True, verbose_name="active"), ), ( "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="children", to="content.contentcategory", verbose_name="parent category", ), ), ( "tenant", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="+", to="tenants.tenant", verbose_name="tenant", ), ), ], options={ "verbose_name": "content category", "verbose_name_plural": "content categories", }, ), migrations.CreateModel( name="ContentItem", 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"), ), ("version", models.PositiveIntegerField(default=0, verbose_name="version")), ( "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")), ("slug", models.SlugField(max_length=500, verbose_name="slug")), ( "content_type", models.CharField( choices=[ ("dev_doc", "Developer Documentation"), ("user_manual", "User Manual"), ("admin_manual", "Admin Manual"), ("arch_doc", "Architecture Documentation"), ("api_doc", "API Documentation"), ("kb_article", "Knowledge Base Article"), ("faq", "FAQ"), ("procedure", "Procedure"), ("policy", "Policy"), ("article", "Article"), ("news", "News"), ("announcement", "Announcement"), ("release_notes", "Release Notes"), ("changelog", "Changelog"), ], db_index=True, max_length=30, verbose_name="content type", ), ), ("body", models.TextField(blank=True, default="", verbose_name="body")), ( "excerpt", models.TextField( blank=True, default="", max_length=2000, verbose_name="excerpt" ), ), ( "status", models.CharField( choices=[ ("draft", "Draft"), ("review", "In Review"), ("approved", "Approved"), ("published", "Published"), ("archived", "Archived"), ], db_index=True, default="draft", max_length=20, verbose_name="status", ), ), ( "visibility", models.CharField( choices=[ ("public", "Public"), ("internal", "Internal — authenticated users"), ("private", "Private — author only"), ], default="internal", max_length=12, verbose_name="visibility", ), ), ( "published_at", models.DateTimeField( blank=True, db_index=True, null=True, verbose_name="published at" ), ), ( "archived_at", models.DateTimeField(blank=True, null=True, verbose_name="archived at"), ), ( "meta_title", models.CharField( blank=True, default="", max_length=200, verbose_name="meta title" ), ), ( "meta_description", models.TextField( blank=True, default="", max_length=500, verbose_name="meta description" ), ), ( "meta_keywords", models.CharField( blank=True, default="", max_length=500, verbose_name="meta keywords" ), ), ("view_count", models.PositiveIntegerField(default=0, verbose_name="view count")), ( "helpful_count", models.PositiveIntegerField(default=0, verbose_name="helpful count"), ), ( "not_helpful_count", models.PositiveIntegerField(default=0, verbose_name="not helpful count"), ), ( "ai_description", models.TextField(blank=True, default="", verbose_name="AI description"), ), ( "ai_semantic_type", models.CharField( blank=True, default="", max_length=100, verbose_name="AI semantic type" ), ), ("ai_summary", models.TextField(blank=True, default="", verbose_name="AI summary")), ( "related_content", models.JSONField(blank=True, default=list, verbose_name="related content"), ), ( "author", models.ForeignKey( on_delete=django.db.models.deletion.PROTECT, related_name="authored_content", to=settings.AUTH_USER_MODEL, verbose_name="author", ), ), ( "category", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="items", to="content.contentcategory", verbose_name="category", ), ), ( "created_by", models.ForeignKey( blank=True, editable=False, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="+", to=settings.AUTH_USER_MODEL, verbose_name="created by", ), ), ( "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", ), ), ( "tenant", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="+", to="tenants.tenant", verbose_name="tenant", ), ), ( "updated_by", models.ForeignKey( blank=True, editable=False, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="+", to=settings.AUTH_USER_MODEL, verbose_name="updated by", ), ), ( "workflow_instance", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="+", to="platform_workflow.workflowinstance", verbose_name="workflow instance", ), ), ( "workspace", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="content_items", to="platform_workspaces.workspace", verbose_name="workspace", ), ), ], options={ "verbose_name": "content item", "verbose_name_plural": "content items", "ordering": ["-published_at", "-created_at"], }, ), migrations.CreateModel( name="ContentVersion", fields=[ ( "id", models.BigAutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID" ), ), ("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", ), ), ("version", models.PositiveIntegerField(verbose_name="version number")), ("title", models.CharField(max_length=500, verbose_name="title")), ("body", models.TextField(verbose_name="body")), ( "excerpt", models.TextField( blank=True, default="", max_length=2000, verbose_name="excerpt" ), ), ( "status", models.CharField( choices=[ ("draft", "Draft"), ("review", "In Review"), ("approved", "Approved"), ("published", "Published"), ("archived", "Archived"), ], max_length=20, verbose_name="status at snapshot", ), ), ( "change_summary", models.CharField( blank=True, default="", max_length=500, verbose_name="change summary" ), ), ("created_at", models.DateTimeField(auto_now_add=True, verbose_name="created at")), ( "changed_by", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="+", to=settings.AUTH_USER_MODEL, verbose_name="changed by", ), ), ( "content_item", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="versions", to="content.contentitem", verbose_name="content item", ), ), ( "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": "content version", "verbose_name_plural": "content versions", "ordering": ["-version"], }, ), migrations.AddIndex( model_name="contentcategory", index=models.Index(fields=["tenant", "parent"], name="content_con_tenant__7c379e_idx"), ), migrations.AddIndex( model_name="contentcategory", index=models.Index( fields=["tenant", "is_active"], name="content_con_tenant__668e0d_idx" ), ), migrations.AlterUniqueTogether( name="contentcategory", unique_together={("tenant", "slug")}, ), migrations.AddIndex( model_name="contentitem", index=models.Index( fields=["tenant", "content_type"], name="content_con_tenant__657881_idx" ), ), migrations.AddIndex( model_name="contentitem", index=models.Index(fields=["tenant", "status"], name="content_con_tenant__dbb7a9_idx"), ), migrations.AddIndex( model_name="contentitem", index=models.Index( fields=["tenant", "category"], name="content_con_tenant__87bb84_idx" ), ), migrations.AddIndex( model_name="contentitem", index=models.Index(fields=["tenant", "author"], name="content_con_tenant__3304d7_idx"), ), migrations.AddIndex( model_name="contentitem", index=models.Index( fields=["tenant", "published_at"], name="content_con_tenant__2a5edd_idx" ), ), migrations.AddIndex( model_name="contentitem", index=models.Index( fields=["tenant", "content_type", "status"], name="content_con_tenant__633539_idx" ), ), migrations.AddIndex( model_name="contentitem", index=models.Index( fields=["tenant", "visibility"], name="content_con_tenant__3f56db_idx" ), ), migrations.AlterUniqueTogether( name="contentitem", unique_together={("tenant", "slug")}, ), migrations.AlterUniqueTogether( name="contentversion", unique_together={("content_item", "version")}, ), ]