2015-04-08 14:41:09 +00:00
# -*- coding: utf-8 -*-
2024-07-12 09:41:44 +00:00
# Generated by Django 1.10.5 on 2021-04-22 11:27
2015-04-08 14:41:09 +00:00
from __future__ import unicode_literals
2024-07-12 09:41:44 +00:00
import datetime
from django . conf import settings
from django . db import migrations , models
2021-04-22 12:18:01 +00:00
import django . db . models . deletion
2024-07-12 09:41:44 +00:00
from django . utils . timezone import utc
2015-04-08 14:41:09 +00:00
import orchestra . models . fields
class Migration ( migrations . Migration ) :
dependencies = [
migrations . swappable_dependency ( settings . AUTH_USER_MODEL ) ,
]
operations = [
migrations . CreateModel (
name = ' Message ' ,
fields = [
2024-07-12 09:41:44 +00:00
( ' id ' , models . AutoField ( auto_created = True , primary_key = True , serialize = False , verbose_name = ' ID ' ) ) ,
2015-04-29 14:32:38 +00:00
( ' author_name ' , models . CharField ( blank = True , max_length = 256 , verbose_name = ' author name ' ) ) ,
2015-04-08 14:41:09 +00:00
( ' content ' , models . TextField ( verbose_name = ' content ' ) ) ,
2015-04-29 14:32:38 +00:00
( ' created_on ' , models . DateTimeField ( auto_now_add = True , verbose_name = ' created on ' ) ) ,
2021-04-22 12:18:01 +00:00
( ' author ' , models . ForeignKey ( on_delete = django . db . models . deletion . CASCADE , related_name = ' ticket_messages ' , to = settings . AUTH_USER_MODEL , verbose_name = ' author ' ) ) ,
2015-04-08 14:41:09 +00:00
] ,
options = {
' get_latest_by ' : ' id ' ,
} ,
) ,
migrations . CreateModel (
name = ' Queue ' ,
fields = [
2024-07-12 09:41:44 +00:00
( ' id ' , models . AutoField ( auto_created = True , primary_key = True , serialize = False , verbose_name = ' ID ' ) ) ,
( ' name ' , models . CharField ( max_length = 128 , unique = True , verbose_name = ' name ' ) ) ,
2015-04-29 14:32:38 +00:00
( ' verbose_name ' , models . CharField ( blank = True , max_length = 128 , verbose_name = ' verbose_name ' ) ) ,
2024-07-12 09:41:44 +00:00
( ' default ' , models . BooleanField ( default = False , verbose_name = ' default ' ) ) ,
( ' notify ' , orchestra . models . fields . MultiSelectField ( blank = True , choices = [ ( ' SUPPORT ' , ' Support tickets ' ) , ( ' ADMIN ' , ' Administrative ' ) , ( ' BILLING ' , ' Billing ' ) , ( ' TECH ' , ' Technical ' ) , ( ' ADDS ' , ' Announcements ' ) , ( ' EMERGENCY ' , ' Emergency contact ' ) ] , default = ( ' SUPPORT ' , ' ADMIN ' , ' BILLING ' , ' TECH ' , ' ADDS ' , ' EMERGENCY ' ) , help_text = ' Contacts to notify by email ' , max_length = 256 , verbose_name = ' notify ' ) ) ,
2015-04-08 14:41:09 +00:00
] ,
) ,
migrations . CreateModel (
name = ' Ticket ' ,
fields = [
2024-07-12 09:41:44 +00:00
( ' id ' , models . AutoField ( auto_created = True , primary_key = True , serialize = False , verbose_name = ' ID ' ) ) ,
2015-04-29 14:32:38 +00:00
( ' creator_name ' , models . CharField ( blank = True , max_length = 256 , verbose_name = ' creator name ' ) ) ,
( ' subject ' , models . CharField ( max_length = 256 , verbose_name = ' subject ' ) ) ,
2015-04-08 14:41:09 +00:00
( ' description ' , models . TextField ( verbose_name = ' description ' ) ) ,
2024-07-12 09:41:44 +00:00
( ' priority ' , models . CharField ( choices = [ ( ' HIGH ' , ' High ' ) , ( ' MEDIUM ' , ' Medium ' ) , ( ' LOW ' , ' Low ' ) ] , default = ' MEDIUM ' , max_length = 32 , verbose_name = ' priority ' ) ) ,
( ' state ' , models . CharField ( choices = [ ( ' NEW ' , ' New ' ) , ( ' IN_PROGRESS ' , ' In Progress ' ) , ( ' RESOLVED ' , ' Resolved ' ) , ( ' FEEDBACK ' , ' Feedback ' ) , ( ' REJECTED ' , ' Rejected ' ) , ( ' CLOSED ' , ' Closed ' ) ] , default = ' NEW ' , max_length = 32 , verbose_name = ' state ' ) ) ,
2015-04-29 14:32:38 +00:00
( ' created_at ' , models . DateTimeField ( auto_now_add = True , verbose_name = ' created ' ) ) ,
( ' updated_at ' , models . DateTimeField ( auto_now = True , verbose_name = ' modified ' ) ) ,
( ' cc ' , models . TextField ( blank = True , help_text = ' emails to send a carbon copy to ' , verbose_name = ' CC ' ) ) ,
2024-07-12 09:41:44 +00:00
( ' creator ' , models . ForeignKey ( null = True , on_delete = django . db . models . deletion . CASCADE , related_name = ' tickets_created ' , to = settings . AUTH_USER_MODEL , verbose_name = ' created by ' ) ) ,
( ' owner ' , models . ForeignKey ( blank = True , null = True , on_delete = django . db . models . deletion . CASCADE , related_name = ' tickets_owned ' , to = settings . AUTH_USER_MODEL , verbose_name = ' assigned to ' ) ) ,
( ' queue ' , models . ForeignKey ( blank = True , null = True , on_delete = django . db . models . deletion . CASCADE , related_name = ' tickets ' , to = ' issues.Queue ' ) ) ,
2015-04-08 14:41:09 +00:00
] ,
options = {
' ordering ' : [ ' -updated_at ' ] ,
} ,
) ,
migrations . CreateModel (
name = ' TicketTracker ' ,
fields = [
2024-07-12 09:41:44 +00:00
( ' id ' , models . AutoField ( auto_created = True , primary_key = True , serialize = False , verbose_name = ' ID ' ) ) ,
2021-04-22 12:18:01 +00:00
( ' ticket ' , models . ForeignKey ( on_delete = django . db . models . deletion . CASCADE , related_name = ' trackers ' , to = ' issues.Ticket ' , verbose_name = ' ticket ' ) ) ,
( ' user ' , models . ForeignKey ( on_delete = django . db . models . deletion . CASCADE , related_name = ' ticket_trackers ' , to = settings . AUTH_USER_MODEL , verbose_name = ' user ' ) ) ,
2015-04-08 14:41:09 +00:00
] ,
) ,
migrations . AddField (
model_name = ' message ' ,
name = ' ticket ' ,
2021-04-22 12:18:01 +00:00
field = models . ForeignKey ( on_delete = django . db . models . deletion . CASCADE , related_name = ' messages ' , to = ' issues.Ticket ' , verbose_name = ' ticket ' ) ,
2015-04-08 14:41:09 +00:00
) ,
migrations . AlterUniqueTogether (
name = ' tickettracker ' ,
unique_together = set ( [ ( ' ticket ' , ' user ' ) ] ) ,
) ,
2024-07-12 09:41:44 +00:00
migrations . AlterField (
model_name = ' ticket ' ,
name = ' created_at ' ,
field = models . DateTimeField ( auto_now_add = True , db_index = True , verbose_name = ' created ' ) ,
) ,
migrations . RemoveField (
model_name = ' message ' ,
name = ' created_on ' ,
) ,
migrations . AddField (
model_name = ' message ' ,
name = ' created_at ' ,
field = models . DateTimeField ( auto_now_add = True , default = datetime . datetime ( 2016 , 3 , 20 , 10 , 27 , 45 , 766388 , tzinfo = utc ) , verbose_name = ' created at ' ) ,
preserve_default = False ,
) ,
migrations . AlterField (
model_name = ' ticket ' ,
name = ' creator ' ,
field = models . ForeignKey ( null = True , on_delete = django . db . models . deletion . SET_NULL , related_name = ' tickets_created ' , to = settings . AUTH_USER_MODEL , verbose_name = ' created by ' ) ,
) ,
migrations . AlterField (
model_name = ' ticket ' ,
name = ' owner ' ,
field = models . ForeignKey ( blank = True , null = True , on_delete = django . db . models . deletion . SET_NULL , related_name = ' tickets_owned ' , to = settings . AUTH_USER_MODEL , verbose_name = ' assigned to ' ) ,
) ,
migrations . AlterField (
model_name = ' ticket ' ,
name = ' queue ' ,
field = models . ForeignKey ( blank = True , null = True , on_delete = django . db . models . deletion . SET_NULL , related_name = ' tickets ' , to = ' issues.Queue ' ) ,
) ,
2015-04-08 14:41:09 +00:00
]