321 lines
12 KiB
Python
321 lines
12 KiB
Python
# Generated by Django 5.0.2 on 2024-02-29 07:47
|
|
|
|
import django.db.models.deletion
|
|
from django.conf import settings
|
|
from django.db import migrations, models
|
|
|
|
|
|
class Migration(migrations.Migration):
|
|
|
|
initial = True
|
|
|
|
dependencies = [
|
|
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
|
|
]
|
|
|
|
operations = [
|
|
migrations.CreateModel(
|
|
name="ContactUs",
|
|
fields=[
|
|
(
|
|
"id",
|
|
models.BigAutoField(
|
|
auto_created=True,
|
|
primary_key=True,
|
|
serialize=False,
|
|
verbose_name="ID",
|
|
),
|
|
),
|
|
("active", models.BooleanField(default=True)),
|
|
("deleted", models.BooleanField(default=False)),
|
|
("created_on", models.DateTimeField(auto_now_add=True)),
|
|
("modified_on", models.DateTimeField(auto_now=True)),
|
|
("name", models.CharField(max_length=100, null=True)),
|
|
("email_address", models.EmailField(max_length=254)),
|
|
("mobile_number", models.CharField(max_length=15)),
|
|
("subject", models.CharField(max_length=200)),
|
|
("message", models.TextField()),
|
|
("reply", models.TextField(blank=True, null=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,
|
|
),
|
|
),
|
|
(
|
|
"modified_by",
|
|
models.ForeignKey(
|
|
blank=True,
|
|
null=True,
|
|
on_delete=django.db.models.deletion.CASCADE,
|
|
related_name="%(class)s_modified",
|
|
to=settings.AUTH_USER_MODEL,
|
|
),
|
|
),
|
|
],
|
|
options={
|
|
"db_table": "contact_us",
|
|
},
|
|
),
|
|
migrations.CreateModel(
|
|
name="Feedback",
|
|
fields=[
|
|
(
|
|
"id",
|
|
models.BigAutoField(
|
|
auto_created=True,
|
|
primary_key=True,
|
|
serialize=False,
|
|
verbose_name="ID",
|
|
),
|
|
),
|
|
("active", models.BooleanField(default=True)),
|
|
("deleted", models.BooleanField(default=False)),
|
|
("created_on", models.DateTimeField(auto_now_add=True)),
|
|
("modified_on", models.DateTimeField(auto_now=True)),
|
|
(
|
|
"email",
|
|
models.EmailField(
|
|
blank=True,
|
|
help_text="Email address of the feedback provider",
|
|
max_length=254,
|
|
null=True,
|
|
),
|
|
),
|
|
("comment", models.TextField(help_text="Feedback comment")),
|
|
(
|
|
"rating",
|
|
models.PositiveSmallIntegerField(
|
|
choices=[
|
|
(1, "1 Star"),
|
|
(2, "2 Stars"),
|
|
(3, "3 Stars"),
|
|
(4, "4 Stars"),
|
|
(5, "5 Stars"),
|
|
],
|
|
help_text="Rating provided by the user",
|
|
),
|
|
),
|
|
(
|
|
"feedback_reaction",
|
|
models.CharField(
|
|
blank=True,
|
|
choices=[
|
|
("Very Bad", "Very Bad"),
|
|
("Poor", "Poor"),
|
|
("Medium", "Medium"),
|
|
("Good", "Good"),
|
|
("Excellent", "Excellent"),
|
|
],
|
|
help_text="Reaction associated with the feedback",
|
|
max_length=20,
|
|
null=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,
|
|
),
|
|
),
|
|
(
|
|
"modified_by",
|
|
models.ForeignKey(
|
|
blank=True,
|
|
null=True,
|
|
on_delete=django.db.models.deletion.CASCADE,
|
|
related_name="%(class)s_modified",
|
|
to=settings.AUTH_USER_MODEL,
|
|
),
|
|
),
|
|
(
|
|
"principal",
|
|
models.ForeignKey(
|
|
blank=True,
|
|
help_text="User associated with this feedback",
|
|
null=True,
|
|
on_delete=django.db.models.deletion.SET_NULL,
|
|
related_name="feedbacks",
|
|
to=settings.AUTH_USER_MODEL,
|
|
),
|
|
),
|
|
],
|
|
options={
|
|
"db_table": "feedback",
|
|
},
|
|
),
|
|
migrations.CreateModel(
|
|
name="TicketAttachment",
|
|
fields=[
|
|
(
|
|
"id",
|
|
models.BigAutoField(
|
|
auto_created=True,
|
|
primary_key=True,
|
|
serialize=False,
|
|
verbose_name="ID",
|
|
),
|
|
),
|
|
("active", models.BooleanField(default=True)),
|
|
("deleted", models.BooleanField(default=False)),
|
|
("created_on", models.DateTimeField(auto_now_add=True)),
|
|
("modified_on", models.DateTimeField(auto_now=True)),
|
|
("image", models.ImageField(upload_to="ticket_attachment")),
|
|
(
|
|
"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,
|
|
),
|
|
),
|
|
(
|
|
"modified_by",
|
|
models.ForeignKey(
|
|
blank=True,
|
|
null=True,
|
|
on_delete=django.db.models.deletion.CASCADE,
|
|
related_name="%(class)s_modified",
|
|
to=settings.AUTH_USER_MODEL,
|
|
),
|
|
),
|
|
],
|
|
options={
|
|
"db_table": "ticket_attachment",
|
|
},
|
|
),
|
|
migrations.CreateModel(
|
|
name="TicketIssueType",
|
|
fields=[
|
|
(
|
|
"id",
|
|
models.BigAutoField(
|
|
auto_created=True,
|
|
primary_key=True,
|
|
serialize=False,
|
|
verbose_name="ID",
|
|
),
|
|
),
|
|
("active", models.BooleanField(default=True)),
|
|
("deleted", models.BooleanField(default=False)),
|
|
("created_on", models.DateTimeField(auto_now_add=True)),
|
|
("modified_on", models.DateTimeField(auto_now=True)),
|
|
("name", models.CharField(max_length=100)),
|
|
(
|
|
"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,
|
|
),
|
|
),
|
|
(
|
|
"modified_by",
|
|
models.ForeignKey(
|
|
blank=True,
|
|
null=True,
|
|
on_delete=django.db.models.deletion.CASCADE,
|
|
related_name="%(class)s_modified",
|
|
to=settings.AUTH_USER_MODEL,
|
|
),
|
|
),
|
|
],
|
|
options={
|
|
"db_table": "ticket_issue_type",
|
|
},
|
|
),
|
|
migrations.CreateModel(
|
|
name="Tickets",
|
|
fields=[
|
|
(
|
|
"id",
|
|
models.BigAutoField(
|
|
auto_created=True,
|
|
primary_key=True,
|
|
serialize=False,
|
|
verbose_name="ID",
|
|
),
|
|
),
|
|
("active", models.BooleanField(default=True)),
|
|
("deleted", models.BooleanField(default=False)),
|
|
("created_on", models.DateTimeField(auto_now_add=True)),
|
|
("modified_on", models.DateTimeField(auto_now=True)),
|
|
("subject", models.CharField(max_length=100)),
|
|
("description", models.TextField()),
|
|
(
|
|
"ticket_status",
|
|
models.CharField(
|
|
choices=[
|
|
("Requested", "Requested"),
|
|
("Viewed", "Viewed"),
|
|
("In Progress", "In Progress"),
|
|
("Resolved", "Resolved"),
|
|
],
|
|
default="Requested",
|
|
help_text="Ticket status",
|
|
max_length=20,
|
|
),
|
|
),
|
|
("is_stopped", models.BooleanField(default=True)),
|
|
(
|
|
"attachments",
|
|
models.ManyToManyField(
|
|
related_name="tickets_attachments",
|
|
to="manage_communications.ticketattachment",
|
|
),
|
|
),
|
|
(
|
|
"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,
|
|
),
|
|
),
|
|
(
|
|
"issuetype",
|
|
models.ForeignKey(
|
|
on_delete=django.db.models.deletion.DO_NOTHING,
|
|
to="manage_communications.ticketissuetype",
|
|
),
|
|
),
|
|
(
|
|
"modified_by",
|
|
models.ForeignKey(
|
|
blank=True,
|
|
null=True,
|
|
on_delete=django.db.models.deletion.CASCADE,
|
|
related_name="%(class)s_modified",
|
|
to=settings.AUTH_USER_MODEL,
|
|
),
|
|
),
|
|
(
|
|
"principal",
|
|
models.ForeignKey(
|
|
blank=True,
|
|
null=True,
|
|
on_delete=django.db.models.deletion.DO_NOTHING,
|
|
to=settings.AUTH_USER_MODEL,
|
|
),
|
|
),
|
|
],
|
|
options={
|
|
"db_table": "tickets",
|
|
},
|
|
),
|
|
]
|