72 lines
3.5 KiB
Python
72 lines
3.5 KiB
Python
# -*- coding: utf-8 -*-
|
||
"""
|
||
新增复聊配置表的数据库迁移
|
||
"""
|
||
from django.db import migrations, models
|
||
|
||
|
||
class Migration(migrations.Migration):
|
||
|
||
dependencies = [
|
||
('server', '0003_add_boss_id'),
|
||
]
|
||
|
||
operations = [
|
||
migrations.CreateModel(
|
||
name='FollowUpConfig',
|
||
fields=[
|
||
('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
|
||
('name', models.CharField(max_length=128, verbose_name='配置名称')),
|
||
('position', models.CharField(max_length=64, verbose_name='岗位类型')),
|
||
('is_active', models.BooleanField(default=True, verbose_name='是否启用')),
|
||
('created_at', models.DateTimeField(auto_now_add=True, verbose_name='创建时间')),
|
||
('updated_at', models.DateTimeField(auto_now=True, verbose_name='更新时间')),
|
||
],
|
||
options={
|
||
'verbose_name': '复聊配置',
|
||
'verbose_name_plural': '复聊配置',
|
||
'db_table': 'follow_up_config',
|
||
},
|
||
),
|
||
migrations.CreateModel(
|
||
name='FollowUpScript',
|
||
fields=[
|
||
('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
|
||
('config_id', models.IntegerField(verbose_name='关联的复聊配置ID')),
|
||
('day_number', models.IntegerField(verbose_name='第几天（1=第一天，2=第二天，0=往后一直）')),
|
||
('content', models.TextField(verbose_name='话术内容')),
|
||
('interval_hours', models.IntegerField(default=24, verbose_name='间隔小时数')),
|
||
('order', models.IntegerField(default=0, verbose_name='排序')),
|
||
('is_active', models.BooleanField(default=True, verbose_name='是否启用')),
|
||
('created_at', models.DateTimeField(auto_now_add=True, verbose_name='创建时间')),
|
||
],
|
||
options={
|
||
'verbose_name': '复聊话术',
|
||
'verbose_name_plural': '复聊话术',
|
||
'db_table': 'follow_up_script',
|
||
'ordering': ['config_id', 'day_number', 'order'],
|
||
},
|
||
),
|
||
migrations.CreateModel(
|
||
name='FollowUpRecord',
|
||
fields=[
|
||
('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
|
||
('contact_id', models.IntegerField(verbose_name='关联的联系人ID')),
|
||
('config_id', models.IntegerField(verbose_name='使用的复聊配置ID')),
|
||
('script_id', models.IntegerField(verbose_name='使用的话术ID')),
|
||
('day_number', models.IntegerField(verbose_name='第几天')),
|
||
('content', models.TextField(verbose_name='发送的内容')),
|
||
('sent_at', models.DateTimeField(auto_now_add=True, verbose_name='发送时间')),
|
||
('got_reply', models.BooleanField(default=False, verbose_name='是否得到回复')),
|
||
('reply_content', models.TextField(default='', blank=True, verbose_name='回复内容')),
|
||
('replied_at', models.DateTimeField(null=True, blank=True, verbose_name='回复时间')),
|
||
],
|
||
options={
|
||
'verbose_name': '复聊记录',
|
||
'verbose_name_plural': '复聊记录',
|
||
'db_table': 'follow_up_record',
|
||
'ordering': ['-sent_at'],
|
||
},
|
||
),
|
||
]
|