151 lines
8.2 KiB
Python
151 lines
8.2 KiB
Python
# Generated by Django 3.2.13 on 2023-01-02 10:55
|
|
|
|
from django.conf import settings
|
|
from django.db import migrations, models
|
|
import django.db.models.deletion
|
|
import uuid
|
|
|
|
|
|
class Migration(migrations.Migration):
|
|
|
|
initial = True
|
|
|
|
dependencies = [
|
|
('auth', '0012_alter_user_first_name_max_length'),
|
|
('authentication', '0001_initial'),
|
|
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
|
|
]
|
|
|
|
operations = [
|
|
migrations.CreateModel(
|
|
name='Answer',
|
|
fields=[
|
|
('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
|
|
('key', models.UUIDField(default=uuid.uuid4, editable=False, null=True, unique=True)),
|
|
('create_date', models.DateTimeField(auto_now_add=True)),
|
|
('modify_date', models.DateTimeField(auto_now=True)),
|
|
('trash', models.BooleanField(default=False)),
|
|
('state', models.CharField(max_length=100, null=True)),
|
|
],
|
|
options={
|
|
'abstract': False,
|
|
},
|
|
),
|
|
migrations.CreateModel(
|
|
name='Question',
|
|
fields=[
|
|
('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
|
|
('key', models.UUIDField(default=uuid.uuid4, editable=False, null=True, unique=True)),
|
|
('create_date', models.DateTimeField(auto_now_add=True)),
|
|
('modify_date', models.DateTimeField(auto_now=True)),
|
|
('trash', models.BooleanField(default=False)),
|
|
('state', models.CharField(max_length=100, null=True)),
|
|
],
|
|
options={
|
|
'abstract': False,
|
|
},
|
|
),
|
|
migrations.CreateModel(
|
|
name='SupportUnit',
|
|
fields=[
|
|
('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
|
|
('key', models.UUIDField(default=uuid.uuid4, editable=False, null=True, unique=True)),
|
|
('create_date', models.DateTimeField(auto_now_add=True)),
|
|
('modify_date', models.DateTimeField(auto_now=True)),
|
|
('trash', models.BooleanField(default=False)),
|
|
('name', models.CharField(max_length=100, null=True)),
|
|
('created_by', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='supportunit_createdby', to=settings.AUTH_USER_MODEL)),
|
|
('modified_by', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='supportunit_modifiedby', to=settings.AUTH_USER_MODEL)),
|
|
('unit', models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, related_name='support_unit', to='auth.group')),
|
|
],
|
|
options={
|
|
'abstract': False,
|
|
},
|
|
),
|
|
migrations.CreateModel(
|
|
name='TicketContent',
|
|
fields=[
|
|
('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
|
|
('key', models.UUIDField(default=uuid.uuid4, editable=False, null=True, unique=True)),
|
|
('create_date', models.DateTimeField(auto_now_add=True)),
|
|
('modify_date', models.DateTimeField(auto_now=True)),
|
|
('trash', models.BooleanField(default=False)),
|
|
('title', models.CharField(max_length=200, null=True)),
|
|
('content', models.TextField(max_length=2000, null=True)),
|
|
('image', models.JSONField(default=dict)),
|
|
('created_by', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='ticketcontent_createdby', to=settings.AUTH_USER_MODEL)),
|
|
('modified_by', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='ticketcontent_modifiedby', to=settings.AUTH_USER_MODEL)),
|
|
],
|
|
options={
|
|
'abstract': False,
|
|
},
|
|
),
|
|
migrations.CreateModel(
|
|
name='Ticket',
|
|
fields=[
|
|
('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
|
|
('key', models.UUIDField(default=uuid.uuid4, editable=False, null=True, unique=True)),
|
|
('create_date', models.DateTimeField(auto_now_add=True)),
|
|
('modify_date', models.DateTimeField(auto_now=True)),
|
|
('trash', models.BooleanField(default=False)),
|
|
('ticket_id', models.BigIntegerField(default=0)),
|
|
('state', models.CharField(max_length=100, null=True)),
|
|
('created_by', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='ticket_createdby', to=settings.AUTH_USER_MODEL)),
|
|
('customer', models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, related_name='ticket_customer', to='authentication.systemuserprofile')),
|
|
('modified_by', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='ticket_modifiedby', to=settings.AUTH_USER_MODEL)),
|
|
('operator', models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, related_name='ticket_operator', to='authentication.systemuserprofile')),
|
|
('question', models.ManyToManyField(related_name='ticket_question', to='ticket.Question')),
|
|
('respond', models.ManyToManyField(related_name='ticket_respond', to='ticket.Answer')),
|
|
('support_unit', models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, related_name='ticket_unit', to='ticket.supportunit')),
|
|
],
|
|
options={
|
|
'abstract': False,
|
|
},
|
|
),
|
|
migrations.AddField(
|
|
model_name='question',
|
|
name='content',
|
|
field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='questioner_content', to='ticket.ticketcontent'),
|
|
),
|
|
migrations.AddField(
|
|
model_name='question',
|
|
name='created_by',
|
|
field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='question_createdby', to=settings.AUTH_USER_MODEL),
|
|
),
|
|
migrations.AddField(
|
|
model_name='question',
|
|
name='modified_by',
|
|
field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='question_modifiedby', to=settings.AUTH_USER_MODEL),
|
|
),
|
|
migrations.AddField(
|
|
model_name='question',
|
|
name='questioner',
|
|
field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, related_name='questioner', to='authentication.systemuserprofile'),
|
|
),
|
|
migrations.AddField(
|
|
model_name='answer',
|
|
name='content',
|
|
field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, related_name='answer_content', to='ticket.ticketcontent'),
|
|
),
|
|
migrations.AddField(
|
|
model_name='answer',
|
|
name='created_by',
|
|
field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='answer_createdby', to=settings.AUTH_USER_MODEL),
|
|
),
|
|
migrations.AddField(
|
|
model_name='answer',
|
|
name='modified_by',
|
|
field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='answer_modifiedby', to=settings.AUTH_USER_MODEL),
|
|
),
|
|
migrations.AddField(
|
|
model_name='answer',
|
|
name='question',
|
|
field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, related_name='answer_question', to='ticket.question'),
|
|
),
|
|
migrations.AddField(
|
|
model_name='answer',
|
|
name='responder',
|
|
field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, related_name='answer', to='authentication.systemuserprofile'),
|
|
),
|
|
]
|