# Generated by Django 5.1.4 on 2025-02-10 01:10 import django.db.models.deletion import pgtrigger.compiler import pgtrigger.migrations from django.conf import settings from django.db import migrations, models class Migration(migrations.Migration): initial = True dependencies = [ ("contenttypes", "0002_remove_content_type_name"), ("pghistory", "0006_delete_aggregateevent"), migrations.swappable_dependency(settings.AUTH_USER_MODEL), ] operations = [ migrations.CreateModel( name="EditSubmission", fields=[ ("id", models.BigAutoField(primary_key=True, serialize=False)), ("object_id", models.PositiveIntegerField(blank=True, null=True)), ( "submission_type", models.CharField( choices=[("EDIT", "Edit Existing"), ("CREATE", "Create New")], default="EDIT", max_length=10, ), ), ( "changes", models.JSONField( help_text="JSON representation of the changes or new object data" ), ), ( "moderator_changes", models.JSONField( blank=True, help_text="Moderator's edited version of the changes before approval", null=True, ), ), ( "reason", models.TextField(help_text="Why this edit/addition is needed"), ), ( "source", models.TextField( blank=True, help_text="Source of information (if applicable)" ), ), ( "status", models.CharField( choices=[ ("PENDING", "Pending"), ("APPROVED", "Approved"), ("REJECTED", "Rejected"), ("ESCALATED", "Escalated"), ], default="PENDING", max_length=20, ), ), ("created_at", models.DateTimeField(auto_now_add=True)), ("handled_at", models.DateTimeField(blank=True, null=True)), ( "notes", models.TextField( blank=True, help_text="Notes from the moderator about this submission", ), ), ( "content_type", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, to="contenttypes.contenttype", ), ), ( "handled_by", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="handled_submissions", to=settings.AUTH_USER_MODEL, ), ), ( "user", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="edit_submissions", to=settings.AUTH_USER_MODEL, ), ), ], options={ "ordering": ["-created_at"], }, ), migrations.CreateModel( name="EditSubmissionEvent", fields=[ ("pgh_id", models.AutoField(primary_key=True, serialize=False)), ("pgh_created_at", models.DateTimeField(auto_now_add=True)), ("pgh_label", models.TextField(help_text="The event label.")), ("id", models.BigIntegerField()), ("object_id", models.PositiveIntegerField(blank=True, null=True)), ( "submission_type", models.CharField( choices=[("EDIT", "Edit Existing"), ("CREATE", "Create New")], default="EDIT", max_length=10, ), ), ( "changes", models.JSONField( help_text="JSON representation of the changes or new object data" ), ), ( "moderator_changes", models.JSONField( blank=True, help_text="Moderator's edited version of the changes before approval", null=True, ), ), ( "reason", models.TextField(help_text="Why this edit/addition is needed"), ), ( "source", models.TextField( blank=True, help_text="Source of information (if applicable)" ), ), ( "status", models.CharField( choices=[ ("PENDING", "Pending"), ("APPROVED", "Approved"), ("REJECTED", "Rejected"), ("ESCALATED", "Escalated"), ], default="PENDING", max_length=20, ), ), ("created_at", models.DateTimeField(auto_now_add=True)), ("handled_at", models.DateTimeField(blank=True, null=True)), ( "notes", models.TextField( blank=True, help_text="Notes from the moderator about this submission", ), ), ( "content_type", models.ForeignKey( db_constraint=False, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", related_query_name="+", to="contenttypes.contenttype", ), ), ( "handled_by", models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", related_query_name="+", to=settings.AUTH_USER_MODEL, ), ), ( "pgh_context", models.ForeignKey( db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", to="pghistory.context", ), ), ( "pgh_obj", models.ForeignKey( db_constraint=False, on_delete=django.db.models.deletion.DO_NOTHING, related_name="events", to="moderation.editsubmission", ), ), ( "user", models.ForeignKey( db_constraint=False, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", related_query_name="+", to=settings.AUTH_USER_MODEL, ), ), ], options={ "abstract": False, }, ), migrations.CreateModel( name="PhotoSubmission", fields=[ ("id", models.BigAutoField(primary_key=True, serialize=False)), ("object_id", models.PositiveIntegerField()), ("photo", models.ImageField(upload_to="submissions/photos/")), ("caption", models.CharField(blank=True, max_length=255)), ("date_taken", models.DateField(blank=True, null=True)), ( "status", models.CharField( choices=[ ("PENDING", "Pending"), ("APPROVED", "Approved"), ("REJECTED", "Rejected"), ("ESCALATED", "Escalated"), ], default="PENDING", max_length=20, ), ), ("created_at", models.DateTimeField(auto_now_add=True)), ("handled_at", models.DateTimeField(blank=True, null=True)), ( "notes", models.TextField( blank=True, help_text="Notes from the moderator about this photo submission", ), ), ( "content_type", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, to="contenttypes.contenttype", ), ), ( "handled_by", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="handled_photos", to=settings.AUTH_USER_MODEL, ), ), ( "user", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="photo_submissions", to=settings.AUTH_USER_MODEL, ), ), ], options={ "ordering": ["-created_at"], }, ), migrations.CreateModel( name="PhotoSubmissionEvent", fields=[ ("pgh_id", models.AutoField(primary_key=True, serialize=False)), ("pgh_created_at", models.DateTimeField(auto_now_add=True)), ("pgh_label", models.TextField(help_text="The event label.")), ("id", models.BigIntegerField()), ("object_id", models.PositiveIntegerField()), ("photo", models.ImageField(upload_to="submissions/photos/")), ("caption", models.CharField(blank=True, max_length=255)), ("date_taken", models.DateField(blank=True, null=True)), ( "status", models.CharField( choices=[ ("PENDING", "Pending"), ("APPROVED", "Approved"), ("REJECTED", "Rejected"), ("ESCALATED", "Escalated"), ], default="PENDING", max_length=20, ), ), ("created_at", models.DateTimeField(auto_now_add=True)), ("handled_at", models.DateTimeField(blank=True, null=True)), ( "notes", models.TextField( blank=True, help_text="Notes from the moderator about this photo submission", ), ), ( "content_type", models.ForeignKey( db_constraint=False, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", related_query_name="+", to="contenttypes.contenttype", ), ), ( "handled_by", models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", related_query_name="+", to=settings.AUTH_USER_MODEL, ), ), ( "pgh_context", models.ForeignKey( db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", to="pghistory.context", ), ), ( "pgh_obj", models.ForeignKey( db_constraint=False, on_delete=django.db.models.deletion.DO_NOTHING, related_name="events", to="moderation.photosubmission", ), ), ( "user", models.ForeignKey( db_constraint=False, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", related_query_name="+", to=settings.AUTH_USER_MODEL, ), ), ], options={ "abstract": False, }, ), migrations.AddIndex( model_name="editsubmission", index=models.Index( fields=["content_type", "object_id"], name="moderation__content_922d2b_idx", ), ), migrations.AddIndex( model_name="editsubmission", index=models.Index(fields=["status"], name="moderation__status_e4eb2b_idx"), ), pgtrigger.migrations.AddTrigger( model_name="editsubmission", trigger=pgtrigger.compiler.Trigger( name="insert_insert", sql=pgtrigger.compiler.UpsertTriggerSql( func='INSERT INTO "moderation_editsubmissionevent" ("changes", "content_type_id", "created_at", "handled_at", "handled_by_id", "id", "moderator_changes", "notes", "object_id", "pgh_context_id", "pgh_created_at", "pgh_label", "pgh_obj_id", "reason", "source", "status", "submission_type", "user_id") VALUES (NEW."changes", NEW."content_type_id", NEW."created_at", NEW."handled_at", NEW."handled_by_id", NEW."id", NEW."moderator_changes", NEW."notes", NEW."object_id", _pgh_attach_context(), NOW(), \'insert\', NEW."id", NEW."reason", NEW."source", NEW."status", NEW."submission_type", NEW."user_id"); RETURN NULL;', hash="[AWS-SECRET-REMOVED]", operation="INSERT", pgid="pgtrigger_insert_insert_2c796", table="moderation_editsubmission", when="AFTER", ), ), ), pgtrigger.migrations.AddTrigger( model_name="editsubmission", trigger=pgtrigger.compiler.Trigger( name="update_update", sql=pgtrigger.compiler.UpsertTriggerSql( condition="WHEN (OLD.* IS DISTINCT FROM NEW.*)", func='INSERT INTO "moderation_editsubmissionevent" ("changes", "content_type_id", "created_at", "handled_at", "handled_by_id", "id", "moderator_changes", "notes", "object_id", "pgh_context_id", "pgh_created_at", "pgh_label", "pgh_obj_id", "reason", "source", "status", "submission_type", "user_id") VALUES (NEW."changes", NEW."content_type_id", NEW."created_at", NEW."handled_at", NEW."handled_by_id", NEW."id", NEW."moderator_changes", NEW."notes", NEW."object_id", _pgh_attach_context(), NOW(), \'update\', NEW."id", NEW."reason", NEW."source", NEW."status", NEW."submission_type", NEW."user_id"); RETURN NULL;', hash="[AWS-SECRET-REMOVED]", operation="UPDATE", pgid="pgtrigger_update_update_ab38f", table="moderation_editsubmission", when="AFTER", ), ), ), migrations.AddIndex( model_name="photosubmission", index=models.Index( fields=["content_type", "object_id"], name="moderation__content_7a7bc1_idx", ), ), migrations.AddIndex( model_name="photosubmission", index=models.Index(fields=["status"], name="moderation__status_7a1914_idx"), ), pgtrigger.migrations.AddTrigger( model_name="photosubmission", trigger=pgtrigger.compiler.Trigger( name="insert_insert", sql=pgtrigger.compiler.UpsertTriggerSql( func='INSERT INTO "moderation_photosubmissionevent" ("caption", "content_type_id", "created_at", "date_taken", "handled_at", "handled_by_id", "id", "notes", "object_id", "pgh_context_id", "pgh_created_at", "pgh_label", "pgh_obj_id", "photo", "status", "user_id") VALUES (NEW."caption", NEW."content_type_id", NEW."created_at", NEW."date_taken", NEW."handled_at", NEW."handled_by_id", NEW."id", NEW."notes", NEW."object_id", _pgh_attach_context(), NOW(), \'insert\', NEW."id", NEW."photo", NEW."status", NEW."user_id"); RETURN NULL;', hash="[AWS-SECRET-REMOVED]", operation="INSERT", pgid="pgtrigger_insert_insert_62865", table="moderation_photosubmission", when="AFTER", ), ), ), pgtrigger.migrations.AddTrigger( model_name="photosubmission", trigger=pgtrigger.compiler.Trigger( name="update_update", sql=pgtrigger.compiler.UpsertTriggerSql( condition="WHEN (OLD.* IS DISTINCT FROM NEW.*)", func='INSERT INTO "moderation_photosubmissionevent" ("caption", "content_type_id", "created_at", "date_taken", "handled_at", "handled_by_id", "id", "notes", "object_id", "pgh_context_id", "pgh_created_at", "pgh_label", "pgh_obj_id", "photo", "status", "user_id") VALUES (NEW."caption", NEW."content_type_id", NEW."created_at", NEW."date_taken", NEW."handled_at", NEW."handled_by_id", NEW."id", NEW."notes", NEW."object_id", _pgh_attach_context(), NOW(), \'update\', NEW."id", NEW."photo", NEW."status", NEW."user_id"); RETURN NULL;', hash="[AWS-SECRET-REMOVED]", operation="UPDATE", pgid="pgtrigger_update_update_9c311", table="moderation_photosubmission", when="AFTER", ), ), ), ]