Files
along_django/dingdan/migrations/0001_initial.py

845 lines
28 KiB
Python
Raw Permalink Blame History

This file contains ambiguous Unicode characters
This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.
# Generated by Django 4.2.27 on 2026-01-23 19:32
from django.db import migrations, models
import django.db.models.deletion
class Migration(migrations.Migration):
initial = True
dependencies = []
operations = [
migrations.CreateModel(
name="Chufajilu",
fields=[
(
"id",
models.BigAutoField(
auto_created=True,
primary_key=True,
serialize=False,
verbose_name="ID",
),
),
(
"dashouid",
models.CharField(
db_index=True,
max_length=7,
null=True,
verbose_name="被罚打手ID",
),
),
(
"qingqiuid",
models.CharField(
db_index=True,
max_length=7,
null=True,
verbose_name="请求处罚ID",
),
),
(
"chuliid",
models.CharField(
db_index=True,
max_length=11,
null=True,
verbose_name="处理处罚ID",
),
),
(
"cfliyou",
models.TextField(blank=True, null=True, verbose_name="处罚理由"),
),
(
"sqzhuangtai",
models.IntegerField(
blank=True,
default=0,
null=True,
verbose_name="处罚申请状态:0待处理,1成功,2驳回",
),
),
(
"bhliyou",
models.TextField(
blank=True, null=True, verbose_name="驳回处罚理由"
),
),
("jifen", models.IntegerField(default=0, verbose_name="扣除打手积分")),
(
"dingdan_id",
models.CharField(
db_index=True, max_length=32, null=True, verbose_name="订单ID"
),
),
(
"create_time",
models.DateTimeField(auto_now_add=True, verbose_name="创建时间"),
),
(
"update_time",
models.DateTimeField(auto_now=True, verbose_name="更新时间"),
),
],
options={
"db_table": "chufajilu",
},
),
migrations.CreateModel(
name="Dashoutupian",
fields=[
(
"id",
models.BigAutoField(
auto_created=True,
primary_key=True,
serialize=False,
verbose_name="ID",
),
),
(
"dingdan_id",
models.CharField(
db_index=True, max_length=32, null=True, verbose_name="订单ID"
),
),
(
"dashou",
models.CharField(
blank=True,
db_index=True,
max_length=32,
null=True,
verbose_name="接单打手ID",
),
),
(
"tupian",
models.CharField(
blank=True,
max_length=500,
null=True,
verbose_name="打手提交图片URL",
),
),
(
"create_time",
models.DateTimeField(auto_now_add=True, verbose_name="创建时间"),
),
(
"update_time",
models.DateTimeField(auto_now=True, verbose_name="更新时间"),
),
],
options={
"db_table": "dashoutupian",
},
),
migrations.CreateModel(
name="Dingdan",
fields=[
(
"id",
models.BigAutoField(
auto_created=True,
primary_key=True,
serialize=False,
verbose_name="ID",
),
),
(
"dingdan_id",
models.CharField(
db_index=True, max_length=32, unique=True, verbose_name="订单ID"
),
),
(
"zhuangtai",
models.IntegerField(
blank=True,
db_index=True,
default=1,
null=True,
verbose_name="订单状态",
),
),
(
"fadan_pingtai",
models.IntegerField(blank=True, null=True, verbose_name="发单平台"),
),
(
"jine",
models.DecimalField(
blank=True,
decimal_places=2,
max_digits=10,
null=True,
verbose_name="订单金额",
),
),
(
"dashou_fencheng",
models.DecimalField(
blank=True,
decimal_places=2,
max_digits=10,
null=True,
verbose_name="打手分成",
),
),
(
"jiedan_dashou_id",
models.CharField(
blank=True,
db_index=True,
max_length=32,
null=True,
verbose_name="接单打手ID",
),
),
(
"dashou_liuyan",
models.TextField(blank=True, null=True, verbose_name="打手留言"),
),
(
"zhiding_id",
models.CharField(
blank=True, max_length=32, null=True, verbose_name="指定ID"
),
),
(
"shangpin_id",
models.IntegerField(blank=True, null=True, verbose_name="商品ID"),
),
(
"leixing_id",
models.PositiveIntegerField(
blank=True, null=True, verbose_name="商品类型ID"
),
),
(
"tupian",
models.CharField(
blank=True,
max_length=500,
null=True,
verbose_name="商品图片URL",
),
),
(
"yaoqiuleixing",
models.PositiveIntegerField(
blank=True, null=True, verbose_name="抢单要求类型"
),
),
(
"huiyuan_id",
models.CharField(
blank=True, max_length=6, null=True, verbose_name="会员ID"
),
),
(
"yongjin",
models.DecimalField(
blank=True,
decimal_places=2,
max_digits=10,
null=True,
verbose_name="佣金要求",
),
),
(
"jieshao",
models.TextField(blank=True, null=True, verbose_name="订单介绍"),
),
(
"beizhu",
models.TextField(blank=True, null=True, verbose_name="订单备注"),
),
(
"nicheng",
models.CharField(
blank=True, max_length=50, null=True, verbose_name="游戏昵称"
),
),
(
"user1_id",
models.CharField(
db_index=True,
max_length=30,
null=True,
verbose_name="用户1标识",
),
),
(
"user2_id",
models.CharField(
db_index=True,
max_length=30,
null=True,
verbose_name="用户2打手标识",
),
),
(
"auto_task_id",
models.CharField(
blank=True,
default="",
max_length=255,
verbose_name="延时任务ID",
),
),
(
"auto_expire_at",
models.DateTimeField(
blank=True, null=True, verbose_name="计划过期时间"
),
),
(
"pending_dispatch",
models.BooleanField(
db_index=True, default=False, verbose_name="待调度标记"
),
),
(
"status_8_time",
models.DateTimeField(
blank=True, null=True, verbose_name="状态变为8的时间"
),
),
(
"create_time",
models.DateTimeField(auto_now_add=True, verbose_name="创建时间"),
),
(
"update_time",
models.DateTimeField(auto_now=True, verbose_name="更新时间"),
),
],
options={
"verbose_name": "订单",
"verbose_name_plural": "订单",
"db_table": "dingdan",
},
),
migrations.CreateModel(
name="Lilubiao",
fields=[
(
"id",
models.BigAutoField(
auto_created=True,
primary_key=True,
serialize=False,
verbose_name="ID",
),
),
(
"lilu",
models.DecimalField(
decimal_places=4,
max_digits=5,
null=True,
verbose_name="平台分成利率1是平台,2是商家",
),
),
(
"fadanpingtai",
models.CharField(
max_length=10,
null=True,
verbose_name="订单所属平台,(商家或平台)",
),
),
(
"create_time",
models.DateTimeField(auto_now_add=True, verbose_name="创建时间"),
),
(
"update_time",
models.DateTimeField(auto_now=True, verbose_name="更新时间"),
),
],
options={
"db_table": "lilubiao",
},
),
migrations.CreateModel(
name="Ptliushui",
fields=[
(
"id",
models.BigAutoField(
auto_created=True,
primary_key=True,
serialize=False,
verbose_name="ID",
),
),
(
"zonge",
models.DecimalField(
blank=True,
decimal_places=2,
max_digits=10,
null=True,
verbose_name="收取总金额",
),
),
(
"zhichuzonge",
models.DecimalField(
blank=True,
decimal_places=2,
max_digits=10,
null=True,
verbose_name="支出总金额",
),
),
(
"zongshouyi",
models.DecimalField(
blank=True,
decimal_places=2,
max_digits=10,
null=True,
verbose_name="总收益",
),
),
(
"rizonge",
models.DecimalField(
blank=True,
decimal_places=2,
max_digits=10,
null=True,
verbose_name="日收取",
),
),
(
"rizhichu",
models.DecimalField(
blank=True,
decimal_places=2,
max_digits=10,
null=True,
verbose_name="日支出",
),
),
(
"rishouyi",
models.DecimalField(
blank=True,
decimal_places=2,
max_digits=10,
null=True,
verbose_name="日收益",
),
),
(
"zongshoucishu",
models.IntegerField(default=0, verbose_name="总收取次数"),
),
(
"rishoucishu",
models.IntegerField(default=0, verbose_name="日收取次数"),
),
(
"zongzhichucishu",
models.IntegerField(default=0, verbose_name="总支出次数"),
),
(
"rizhichucishu",
models.IntegerField(default=0, verbose_name="日支出次数"),
),
],
options={
"db_table": "ptliushui",
},
),
migrations.CreateModel(
name="Tuikuanjilu",
fields=[
(
"id",
models.BigAutoField(
auto_created=True,
primary_key=True,
serialize=False,
verbose_name="ID",
),
),
(
"dingdan_id",
models.CharField(max_length=32, unique=True, verbose_name="订单ID"),
),
(
"dashouid",
models.CharField(
max_length=7, null=True, verbose_name="接单打手ID"
),
),
(
"qingqiuid",
models.CharField(
max_length=7, null=True, verbose_name="请求用户ID"
),
),
(
"chuliid",
models.CharField(
db_index=True, max_length=7, null=True, verbose_name="处理人ID"
),
),
("liyou", models.TextField(blank=True, null=True, verbose_name="理由")),
(
"sqzhuangtai",
models.IntegerField(
blank=True,
db_index=True,
default=0,
null=True,
verbose_name="申请状态:0待处理,1成功,2驳回",
),
),
(
"bhliyou",
models.TextField(blank=True, null=True, verbose_name="驳回理由"),
),
(
"jine",
models.DecimalField(
blank=True,
decimal_places=2,
max_digits=10,
null=True,
verbose_name="订单金额",
),
),
(
"dashou_fencheng",
models.DecimalField(
blank=True,
decimal_places=2,
max_digits=10,
null=True,
verbose_name="打手分成",
),
),
(
"jieshao",
models.TextField(blank=True, null=True, verbose_name="订单介绍"),
),
(
"beizhu",
models.TextField(blank=True, null=True, verbose_name="订单备注"),
),
(
"nicheng",
models.CharField(
blank=True, max_length=50, null=True, verbose_name="游戏昵称"
),
),
(
"create_time",
models.DateTimeField(auto_now_add=True, verbose_name="创建时间"),
),
(
"update_time",
models.DateTimeField(auto_now=True, verbose_name="更新时间"),
),
],
options={
"db_table": "tuikuanjilu",
"indexes": [
models.Index(
fields=["chuliid"], name="tuikuanjilu_chuliid_0b0f16_idx"
),
models.Index(
fields=["sqzhuangtai"], name="tuikuanjilu_sqzhuan_d89dc9_idx"
),
],
},
),
migrations.CreateModel(
name="Pingfen",
fields=[
(
"id",
models.BigAutoField(
auto_created=True,
primary_key=True,
serialize=False,
verbose_name="ID",
),
),
(
"dashou",
models.CharField(
blank=True,
db_index=True,
max_length=32,
null=True,
verbose_name="接单打手ID",
),
),
(
"zongfen",
models.PositiveIntegerField(default=0, verbose_name="总分"),
),
(
"cishu",
models.PositiveIntegerField(default=0, verbose_name="评分次数"),
),
(
"create_time",
models.DateTimeField(auto_now_add=True, verbose_name="创建时间"),
),
(
"update_time",
models.DateTimeField(auto_now=True, verbose_name="更新时间"),
),
],
options={
"verbose_name": "评分表",
"db_table": "pingfenbiao",
"indexes": [
models.Index(
fields=["dashou"], name="pingfenbiao_dashou_f62f10_idx"
)
],
},
),
migrations.CreateModel(
name="Liaotian",
fields=[
(
"id",
models.BigAutoField(
primary_key=True, serialize=False, verbose_name="主键ID"
),
),
(
"user1_id",
models.CharField(
db_index=True, max_length=30, verbose_name="用户1标识"
),
),
(
"user2_id",
models.CharField(
db_index=True, max_length=30, verbose_name="用户2标识"
),
),
(
"dingdan_id",
models.CharField(max_length=32, unique=True, verbose_name="订单ID"),
),
(
"zhuangtai",
models.IntegerField(
choices=[(1, "开启中"), (0, "已关闭")],
db_index=True,
default=1,
verbose_name="聊天状态",
),
),
(
"create_time",
models.DateTimeField(auto_now_add=True, verbose_name="创建时间"),
),
(
"update_time",
models.DateTimeField(auto_now=True, verbose_name="更新时间"),
),
],
options={
"db_table": "liaotian",
"indexes": [
models.Index(
fields=["user1_id"], name="liaotian_user1_i_6be6cd_idx"
),
models.Index(
fields=["user2_id"], name="liaotian_user2_i_9f61a4_idx"
),
models.Index(
fields=["zhuangtai"], name="liaotian_zhuangt_5e8be5_idx"
),
],
},
),
migrations.CreateModel(
name="DingdanShangjia",
fields=[
(
"id",
models.BigAutoField(
auto_created=True,
primary_key=True,
serialize=False,
verbose_name="ID",
),
),
(
"shangjia_id",
models.CharField(
blank=True,
db_index=True,
max_length=32,
null=True,
verbose_name="商家ID",
),
),
(
"shangjia_pingjia",
models.TextField(blank=True, null=True, verbose_name="商家评价"),
),
(
"cfliyou",
models.TextField(
blank=True, null=True, verbose_name="商家处罚理由"
),
),
(
"sqzhuangtai",
models.IntegerField(
blank=True,
default=0,
null=True,
verbose_name="处罚申请状态:0待处理,1成功,2驳回",
),
),
(
"bhliyou",
models.TextField(
blank=True, null=True, verbose_name="驳回商家处罚理由"
),
),
(
"sjnicheng",
models.CharField(max_length=50, null=True, verbose_name="商家昵称"),
),
(
"dingdan",
models.OneToOneField(
on_delete=django.db.models.deletion.CASCADE,
related_name="shangjia_kuozhan",
to="dingdan.dingdan",
verbose_name="订单",
),
),
],
options={
"verbose_name": "商家订单扩展",
"verbose_name_plural": "商家订单扩展",
"db_table": "dingdan_shangjia",
},
),
migrations.CreateModel(
name="DingdanPingtai",
fields=[
(
"id",
models.BigAutoField(
auto_created=True,
primary_key=True,
serialize=False,
verbose_name="ID",
),
),
(
"laoban_id",
models.CharField(
blank=True,
db_index=True,
max_length=32,
null=True,
verbose_name="老板ID",
),
),
(
"laoban_pingjia",
models.TextField(blank=True, null=True, verbose_name="老板评价"),
),
(
"dingdan",
models.OneToOneField(
on_delete=django.db.models.deletion.CASCADE,
related_name="pingtai_kuozhan",
to="dingdan.dingdan",
verbose_name="订单",
),
),
],
options={
"verbose_name": "平台订单扩展",
"verbose_name_plural": "平台订单扩展",
"db_table": "dingdan_pingtai",
},
),
migrations.AddIndex(
model_name="dingdan",
index=models.Index(fields=["zhuangtai"], name="dingdan_zhuangt_2febe8_idx"),
),
migrations.AddIndex(
model_name="dingdan",
index=models.Index(
fields=["dingdan_id"], name="dingdan_dingdan_83dcb6_idx"
),
),
migrations.AddIndex(
model_name="dingdan",
index=models.Index(
fields=["jiedan_dashou_id"], name="dingdan_jiedan__921bfa_idx"
),
),
migrations.AddIndex(
model_name="dashoutupian",
index=models.Index(fields=["dashou"], name="dashoutupia_dashou_7de8bd_idx"),
),
migrations.AddIndex(
model_name="dashoutupian",
index=models.Index(
fields=["dingdan_id"], name="dashoutupia_dingdan_97c685_idx"
),
),
migrations.AddIndex(
model_name="chufajilu",
index=models.Index(
fields=["dashouid"], name="chufajilu_dashoui_07aac0_idx"
),
),
migrations.AddIndex(
model_name="chufajilu",
index=models.Index(
fields=["qingqiuid"], name="chufajilu_qingqiu_ac160e_idx"
),
),
migrations.AddIndex(
model_name="chufajilu",
index=models.Index(fields=["chuliid"], name="chufajilu_chuliid_cd63ac_idx"),
),
migrations.AddIndex(
model_name="chufajilu",
index=models.Index(
fields=["dingdan_id"], name="chufajilu_dingdan_b8f0c2_idx"
),
),
migrations.AddIndex(
model_name="dingdanshangjia",
index=models.Index(
fields=["shangjia_id"], name="dingdan_sha_shangji_64d28b_idx"
),
),
migrations.AddIndex(
model_name="dingdanpingtai",
index=models.Index(
fields=["laoban_id"], name="dingdan_pin_laoban__d55e6f_idx"
),
),
]