# Generated by Django 5.1.4 on 2025-02-10 01:10 import django.core.validators 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="Review", fields=[ ("id", models.BigAutoField(primary_key=True, serialize=False)), ("object_id", models.PositiveIntegerField()), ( "rating", models.PositiveSmallIntegerField( validators=[ django.core.validators.MinValueValidator(1), django.core.validators.MaxValueValidator(10), ] ), ), ("title", models.CharField(max_length=200)), ("content", models.TextField()), ("visit_date", models.DateField()), ("created_at", models.DateTimeField(auto_now_add=True)), ("updated_at", models.DateTimeField(auto_now=True)), ("is_published", models.BooleanField(default=True)), ("moderation_notes", models.TextField(blank=True)), ("moderated_at", models.DateTimeField(blank=True, null=True)), ( "content_type", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, to="contenttypes.contenttype", ), ), ( "moderated_by", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="moderated_reviews", to=settings.AUTH_USER_MODEL, ), ), ( "user", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="reviews", to=settings.AUTH_USER_MODEL, ), ), ], options={ "ordering": ["-created_at"], }, ), migrations.CreateModel( name="ReviewEvent", 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()), ( "rating", models.PositiveSmallIntegerField( validators=[ django.core.validators.MinValueValidator(1), django.core.validators.MaxValueValidator(10), ] ), ), ("title", models.CharField(max_length=200)), ("content", models.TextField()), ("visit_date", models.DateField()), ("created_at", models.DateTimeField(auto_now_add=True)), ("updated_at", models.DateTimeField(auto_now=True)), ("is_published", models.BooleanField(default=True)), ("moderation_notes", models.TextField(blank=True)), ("moderated_at", models.DateTimeField(blank=True, null=True)), ( "content_type", models.ForeignKey( db_constraint=False, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", related_query_name="+", to="contenttypes.contenttype", ), ), ( "moderated_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="reviews.review", ), ), ( "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="ReviewImage", fields=[ ( "id", models.BigAutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID", ), ), ("image", models.ImageField(upload_to="review_images/")), ("caption", models.CharField(blank=True, max_length=200)), ("order", models.PositiveIntegerField(default=0)), ( "review", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="images", to="reviews.review", ), ), ], options={ "ordering": ["order"], }, ), migrations.CreateModel( name="ReviewLike", fields=[ ( "id", models.BigAutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID", ), ), ("created_at", models.DateTimeField(auto_now_add=True)), ( "review", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="likes", to="reviews.review", ), ), ( "user", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="review_likes", to=settings.AUTH_USER_MODEL, ), ), ], ), migrations.CreateModel( name="ReviewReport", fields=[ ( "id", models.BigAutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID", ), ), ("reason", models.TextField()), ("created_at", models.DateTimeField(auto_now_add=True)), ("resolved", models.BooleanField(default=False)), ("resolution_notes", models.TextField(blank=True)), ("resolved_at", models.DateTimeField(blank=True, null=True)), ( "resolved_by", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="resolved_review_reports", to=settings.AUTH_USER_MODEL, ), ), ( "review", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="reports", to="reviews.review", ), ), ( "user", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="review_reports", to=settings.AUTH_USER_MODEL, ), ), ], options={ "ordering": ["-created_at"], }, ), migrations.AddIndex( model_name="review", index=models.Index( fields=["content_type", "object_id"], name="reviews_rev_content_627d80_idx", ), ), pgtrigger.migrations.AddTrigger( model_name="review", trigger=pgtrigger.compiler.Trigger( name="insert_insert", sql=pgtrigger.compiler.UpsertTriggerSql( func='INSERT INTO "reviews_reviewevent" ("content", "content_type_id", "created_at", "id", "is_published", "moderated_at", "moderated_by_id", "moderation_notes", "object_id", "pgh_context_id", "pgh_created_at", "pgh_label", "pgh_obj_id", "rating", "title", "updated_at", "user_id", "visit_date") VALUES (NEW."content", NEW."content_type_id", NEW."created_at", NEW."id", NEW."is_published", NEW."moderated_at", NEW."moderated_by_id", NEW."moderation_notes", NEW."object_id", _pgh_attach_context(), NOW(), \'insert\', NEW."id", NEW."rating", NEW."title", NEW."updated_at", NEW."user_id", NEW."visit_date"); RETURN NULL;', hash="[AWS-SECRET-REMOVED]", operation="INSERT", pgid="pgtrigger_insert_insert_7a7c1", table="reviews_review", when="AFTER", ), ), ), pgtrigger.migrations.AddTrigger( model_name="review", trigger=pgtrigger.compiler.Trigger( name="update_update", sql=pgtrigger.compiler.UpsertTriggerSql( condition="WHEN (OLD.* IS DISTINCT FROM NEW.*)", func='INSERT INTO "reviews_reviewevent" ("content", "content_type_id", "created_at", "id", "is_published", "moderated_at", "moderated_by_id", "moderation_notes", "object_id", "pgh_context_id", "pgh_created_at", "pgh_label", "pgh_obj_id", "rating", "title", "updated_at", "user_id", "visit_date") VALUES (NEW."content", NEW."content_type_id", NEW."created_at", NEW."id", NEW."is_published", NEW."moderated_at", NEW."moderated_by_id", NEW."moderation_notes", NEW."object_id", _pgh_attach_context(), NOW(), \'update\', NEW."id", NEW."rating", NEW."title", NEW."updated_at", NEW."user_id", NEW."visit_date"); RETURN NULL;', hash="[AWS-SECRET-REMOVED]", operation="UPDATE", pgid="pgtrigger_update_update_b34c8", table="reviews_review", when="AFTER", ), ), ), migrations.AlterUniqueTogether( name="reviewlike", unique_together={("review", "user")}, ), ]