# Generated by Django 4.2.5 on 2026-01-23 06:31 from django.conf import settings from django.db import migrations, models import django.db.models.deletion class Migration(migrations.Migration): initial = True dependencies = [ ("quotation", "0001_initial"), migrations.swappable_dependency(settings.AUTH_USER_MODEL), ("product", "0001_initial"), ] operations = [ migrations.CreateModel( name="Chat", fields=[ ( "id", models.BigAutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID", ), ), ("created_at", models.DateTimeField(auto_now_add=True, null=True)), ("updated_at", models.DateTimeField(auto_now=True, null=True)), ("deleted_at", models.DateTimeField(auto_now=True, null=True)), ("content", models.TextField()), ("is_read", models.IntegerField(default=0)), ("timestamp", models.DateTimeField(auto_now_add=True)), ("is_visible", models.BooleanField(default=True)), ( "created_by", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name="%(class)s_created", to=settings.AUTH_USER_MODEL, ), ), ( "deleted_by", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name="%(class)s_deleted", to=settings.AUTH_USER_MODEL, ), ), ( "job", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="chat_set", to="quotation.technician_assigned_order_item", ), ), ( "recipient", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="recipient", to=settings.AUTH_USER_MODEL, ), ), ( "sender", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="sender", to=settings.AUTH_USER_MODEL, ), ), ( "updated_by", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name="%(class)s_updated", to=settings.AUTH_USER_MODEL, ), ), ], options={ "abstract": False, }, ), migrations.CreateModel( name="Checklist", fields=[ ( "id", models.BigAutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID", ), ), ("created_at", models.DateTimeField(auto_now_add=True, null=True)), ("updated_at", models.DateTimeField(auto_now=True, null=True)), ("deleted_at", models.DateTimeField(auto_now=True, null=True)), ("checklist_name", models.CharField(max_length=255)), ( "type", models.PositiveSmallIntegerField( choices=[(1, "Installation"), (2, "Service"), (3, "Signature")] ), ), ("is_part", models.BooleanField(default=False)), ( "created_by", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name="%(class)s_created", to=settings.AUTH_USER_MODEL, ), ), ( "deleted_by", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name="%(class)s_deleted", to=settings.AUTH_USER_MODEL, ), ), ( "updated_by", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name="%(class)s_updated", to=settings.AUTH_USER_MODEL, ), ), ], options={ "abstract": False, }, ), migrations.CreateModel( name="Heading", fields=[ ( "id", models.BigAutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID", ), ), ("created_at", models.DateTimeField(auto_now_add=True, null=True)), ("updated_at", models.DateTimeField(auto_now=True, null=True)), ("deleted_at", models.DateTimeField(auto_now=True, null=True)), ("heading", models.CharField(max_length=255)), ( "created_by", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name="%(class)s_created", to=settings.AUTH_USER_MODEL, ), ), ( "deleted_by", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name="%(class)s_deleted", to=settings.AUTH_USER_MODEL, ), ), ( "updated_by", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name="%(class)s_updated", to=settings.AUTH_USER_MODEL, ), ), ], options={ "abstract": False, }, ), migrations.CreateModel( name="Service", fields=[ ( "id", models.BigAutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID", ), ), ("created_at", models.DateTimeField(auto_now_add=True, null=True)), ("updated_at", models.DateTimeField(auto_now=True, null=True)), ("deleted_at", models.DateTimeField(auto_now=True, null=True)), ("comment", models.CharField(max_length=50, null=True)), ("title", models.CharField(max_length=255, null=True)), ("is_selected_warranty", models.IntegerField(default=0)), ("description", models.TextField(null=True)), ("service_completed", models.BooleanField(default=False)), ( "created_by", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name="%(class)s_created", to=settings.AUTH_USER_MODEL, ), ), ( "deleted_by", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name="%(class)s_deleted", to=settings.AUTH_USER_MODEL, ), ), ( "order_item", models.ForeignKey( null=True, on_delete=django.db.models.deletion.CASCADE, related_name="orders_items", to="quotation.order_item", ), ), ( "updated_by", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name="%(class)s_updated", to=settings.AUTH_USER_MODEL, ), ), ], options={ "abstract": False, }, ), migrations.CreateModel( name="SubHeading", fields=[ ( "id", models.BigAutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID", ), ), ("created_at", models.DateTimeField(auto_now_add=True, null=True)), ("updated_at", models.DateTimeField(auto_now=True, null=True)), ("deleted_at", models.DateTimeField(auto_now=True, null=True)), ("subheading", models.CharField(max_length=255)), ( "created_by", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name="%(class)s_created", to=settings.AUTH_USER_MODEL, ), ), ( "deleted_by", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name="%(class)s_deleted", to=settings.AUTH_USER_MODEL, ), ), ( "heading", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to="service.heading", ), ), ( "updated_by", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name="%(class)s_updated", to=settings.AUTH_USER_MODEL, ), ), ], options={ "abstract": False, }, ), migrations.CreateModel( name="Service_Signature", fields=[ ( "id", models.BigAutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID", ), ), ( "signature", models.ImageField(upload_to="service/signature_customer/"), ), ( "signature_technician", models.ImageField(upload_to="service/signature_technician/"), ), ("signature_text", models.TextField(blank=True, null=True)), ("signature_text_technician", models.TextField(blank=True, null=True)), ("accepted_by", models.CharField(max_length=255)), ( "job", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="service_signature", to="quotation.technician_assigned_order_item", ), ), ], ), migrations.CreateModel( name="Service_Request_image", fields=[ ( "id", models.BigAutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID", ), ), ("created_at", models.DateTimeField(auto_now_add=True, null=True)), ("updated_at", models.DateTimeField(auto_now=True, null=True)), ("deleted_at", models.DateTimeField(auto_now=True, null=True)), ( "service_request_image", models.ImageField(upload_to="service/service_request_images/"), ), ( "service_request_video", models.FileField( null=True, upload_to="service/service_request_videos/" ), ), ( "created_by", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name="%(class)s_created", to=settings.AUTH_USER_MODEL, ), ), ( "deleted_by", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name="%(class)s_deleted", to=settings.AUTH_USER_MODEL, ), ), ( "service", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="service_request", to="service.service", ), ), ( "updated_by", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name="%(class)s_updated", to=settings.AUTH_USER_MODEL, ), ), ], options={ "abstract": False, }, ), migrations.CreateModel( name="Question", fields=[ ( "id", models.BigAutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID", ), ), ("created_at", models.DateTimeField(auto_now_add=True, null=True)), ("updated_at", models.DateTimeField(auto_now=True, null=True)), ("deleted_at", models.DateTimeField(auto_now=True, null=True)), ("question", models.TextField(blank=True, null=True)), ( "checklist", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to="service.checklist", ), ), ( "created_by", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name="%(class)s_created", to=settings.AUTH_USER_MODEL, ), ), ( "deleted_by", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name="%(class)s_deleted", to=settings.AUTH_USER_MODEL, ), ), ( "heading", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to="service.heading", ), ), ("product", models.ManyToManyField(to="product.product")), ( "subheading", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to="service.subheading", ), ), ( "updated_by", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name="%(class)s_updated", to=settings.AUTH_USER_MODEL, ), ), ], options={ "abstract": False, }, ), migrations.CreateModel( name="Parts_Request", fields=[ ( "id", models.BigAutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID", ), ), ("created_at", models.DateTimeField(auto_now_add=True, null=True)), ("updated_at", models.DateTimeField(auto_now=True, null=True)), ("deleted_at", models.DateTimeField(auto_now=True, null=True)), ("parts_name", models.CharField(max_length=255)), ("qty", models.PositiveIntegerField()), ("status", models.IntegerField(default=4)), ( "created_by", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name="%(class)s_created", to=settings.AUTH_USER_MODEL, ), ), ( "deleted_by", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name="%(class)s_deleted", to=settings.AUTH_USER_MODEL, ), ), ( "question", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="parts_questions", to="service.question", ), ), ( "technician_assigned_job", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, to="quotation.technician_assigned_order_item", ), ), ( "updated_by", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name="%(class)s_updated", to=settings.AUTH_USER_MODEL, ), ), ], options={ "abstract": False, }, ), migrations.CreateModel( name="ChatImage", fields=[ ( "id", models.BigAutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID", ), ), ("created_at", models.DateTimeField(auto_now_add=True, null=True)), ("updated_at", models.DateTimeField(auto_now=True, null=True)), ("deleted_at", models.DateTimeField(auto_now=True, null=True)), ("chat_image", models.ImageField(upload_to="chat_images/")), ( "chat", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="chat_images", to="service.chat", ), ), ( "created_by", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name="%(class)s_created", to=settings.AUTH_USER_MODEL, ), ), ( "deleted_by", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name="%(class)s_deleted", to=settings.AUTH_USER_MODEL, ), ), ( "updated_by", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name="%(class)s_updated", to=settings.AUTH_USER_MODEL, ), ), ], options={ "abstract": False, }, ), migrations.CreateModel( name="Answer", fields=[ ( "id", models.BigAutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID", ), ), ( "answer", models.PositiveSmallIntegerField( blank=True, choices=[(0, "false"), (1, "true")], null=True ), ), ("comment", models.CharField(blank=True, max_length=255, null=True)), ("is_active", models.BooleanField(default=True)), ("is_parts", models.BooleanField(default=False)), ("is_warrenty", models.BooleanField(default=False)), ("is_signature", models.BooleanField(default=False)), ("is_installation", models.BooleanField(default=False)), ( "pdf_file", models.FileField( blank=True, null=True, upload_to="service/quote_pdfs/" ), ), ( "question", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="questions", to="service.question", ), ), ( "technician_assigned_job", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="question_answer", to="quotation.technician_assigned_order_item", ), ), ], ), migrations.CreateModel( name="Accepted_Image", fields=[ ( "id", models.BigAutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID", ), ), ("created_at", models.DateTimeField(auto_now_add=True, null=True)), ("updated_at", models.DateTimeField(auto_now=True, null=True)), ("deleted_at", models.DateTimeField(auto_now=True, null=True)), ( "accepted_image", models.ImageField(null=True, upload_to="service/accepted_images/"), ), ( "created_by", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name="%(class)s_created", to=settings.AUTH_USER_MODEL, ), ), ( "deleted_by", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name="%(class)s_deleted", to=settings.AUTH_USER_MODEL, ), ), ( "service_signature", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="signature_after_image", to="service.service_signature", ), ), ( "updated_by", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name="%(class)s_updated", to=settings.AUTH_USER_MODEL, ), ), ], options={ "abstract": False, }, ), migrations.CreateModel( name="ChatRead", fields=[ ( "id", models.BigAutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID", ), ), ("read_at", models.DateTimeField(auto_now_add=True)), ( "chat", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="reads", to="service.chat", ), ), ( "user", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL, ), ), ], options={ "unique_together": {("chat", "user")}, }, ), ]