Files
along_django/shangpin/migrations/0001_initial.py

467 lines
16 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
class Migration(migrations.Migration):
initial = True
dependencies = []
operations = [
migrations.CreateModel(
name="Huiyuan",
fields=[
(
"id",
models.BigAutoField(
auto_created=True,
primary_key=True,
serialize=False,
verbose_name="ID",
),
),
(
"huiyuan_id",
models.CharField(max_length=6, unique=True, verbose_name="会员ID"),
),
("jieshao", models.CharField(max_length=30, verbose_name="会员介绍")),
(
"jtjieshao",
models.TextField(
blank=True, null=True, verbose_name="会员规则介绍"
),
),
(
"jiage",
models.DecimalField(
decimal_places=2,
default=0.0,
max_digits=10,
verbose_name="会员价格",
),
),
(
"guanshifc",
models.DecimalField(
decimal_places=2,
default=0.0,
max_digits=10,
verbose_name="管事分成",
),
),
(
"goumai_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": "会员",
"verbose_name_plural": "会员",
"db_table": "huiyuan",
},
),
migrations.CreateModel(
name="Shangpin",
fields=[
(
"id",
models.AutoField(
primary_key=True, serialize=False, verbose_name="商品ID"
),
),
(
"biaoqian",
models.CharField(
blank=True, max_length=45, null=True, verbose_name="商品标题"
),
),
(
"jiage",
models.DecimalField(
decimal_places=2,
default=0.0,
max_digits=10,
verbose_name="商品价格",
),
),
(
"kucun",
models.PositiveIntegerField(default=0, verbose_name="商品库存"),
),
(
"leixing_id",
models.PositiveIntegerField(
blank=True, null=True, verbose_name="商品类型ID"
),
),
(
"zhuanqu_id",
models.PositiveIntegerField(
blank=True, null=True, verbose_name="商品专区ID"
),
),
(
"zhenshi_xiaoliang",
models.PositiveIntegerField(default=0, verbose_name="商品真实销量"),
),
(
"duiwai_xiaoliang",
models.PositiveIntegerField(default=0, verbose_name="商品对外销量"),
),
(
"jieshao",
models.TextField(blank=True, null=True, verbose_name="商品介绍"),
),
(
"xiadan_xuzhi",
models.TextField(blank=True, null=True, verbose_name="下单须知"),
),
(
"guize_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="佣金要求",
),
),
(
"tupian_url",
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={
"verbose_name": "商品",
"verbose_name_plural": "商品",
"db_table": "shangpin",
},
),
migrations.CreateModel(
name="ShangpinLeixing",
fields=[
(
"id",
models.AutoField(
primary_key=True, serialize=False, verbose_name="类型ID"
),
),
(
"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.CharField(
blank=True, max_length=45, null=True, verbose_name="类型介绍"
),
),
(
"tupian_url",
models.CharField(
blank=True,
max_length=500,
null=True,
verbose_name="类型图片URL",
),
),
],
options={
"verbose_name": "商品类型",
"verbose_name_plural": "商品类型",
"db_table": "shangpin_leixing",
},
),
migrations.CreateModel(
name="ShangpinZhuanqu",
fields=[
(
"id",
models.AutoField(
primary_key=True, serialize=False, verbose_name="专区ID"
),
),
(
"mingzi",
models.CharField(
blank=True, max_length=45, null=True, verbose_name="专区名称"
),
),
("leixing_id", models.PositiveIntegerField(verbose_name="类型ID")),
],
options={
"verbose_name": "商品专区",
"verbose_name_plural": "商品专区",
"db_table": "shangpin_zhuanqu",
},
),
migrations.CreateModel(
name="Huiyuangoumai",
fields=[
(
"id",
models.AutoField(
primary_key=True, serialize=False, verbose_name="购买记录ID"
),
),
(
"huiyuan_id",
models.CharField(
db_index=True, max_length=6, verbose_name="会员ID"
),
),
(
"yonghu_id",
models.CharField(
db_index=True, max_length=32, verbose_name="用户ID"
),
),
(
"huiyuan_zhuangtai",
models.PositiveIntegerField(default=1, verbose_name="会员状态"),
),
(
"jieshao",
models.CharField(max_length=30, null=True, verbose_name="会员介绍"),
),
("daoqi_time", models.DateTimeField(verbose_name="会员到期时间")),
(
"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": "huiyuangoumai",
"indexes": [
models.Index(
fields=["yonghu_id"], name="huiyuangoum_yonghu__ba2138_idx"
),
models.Index(
fields=["huiyuan_id"], name="huiyuangoum_huiyuan_35fe1d_idx"
),
models.Index(
fields=["yonghu_id", "huiyuan_id"],
name="huiyuangoum_yonghu__21e6e1_idx",
),
],
"unique_together": {("yonghu_id", "huiyuan_id")},
},
),
migrations.CreateModel(
name="Gsfenhong",
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"),
),
(
"guanshi",
models.CharField(
db_index=True, max_length=7, verbose_name="管事ID"
),
),
(
"dashouid",
models.CharField(
db_index=True, max_length=7, unique=True, verbose_name="打手ID"
),
),
(
"shuoming",
models.CharField(
blank=True, max_length=100, null=True, verbose_name="订单说明"
),
),
(
"fenhong",
models.DecimalField(
decimal_places=2, max_digits=10, verbose_name="订单分红金额"
),
),
(
"avatar",
models.CharField(
blank=True, max_length=500, null=True, verbose_name="打手头像"
),
),
(
"nicheng",
models.CharField(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={
"verbose_name": "管事分红记录",
"verbose_name_plural": "管事分红记录",
"db_table": "gsfenhong",
"indexes": [
models.Index(
fields=["guanshi"], name="gsfenhong_guanshi_dc440f_idx"
),
models.Index(
fields=["dashouid"], name="gsfenhong_dashoui_5473ca_idx"
),
],
},
),
migrations.CreateModel(
name="Czjilu",
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"
),
),
(
"huiyuan_id",
models.CharField(
blank=True, max_length=6, null=True, verbose_name="会员ID"
),
),
(
"zhuangtai",
models.IntegerField(blank=True, null=True, verbose_name="订单状态"),
),
(
"yonghuid",
models.CharField(
db_index=True, max_length=7, verbose_name="用户ID"
),
),
(
"jine",
models.DecimalField(
decimal_places=2, max_digits=10, verbose_name="订单金额"
),
),
(
"leixing",
models.IntegerField(
blank=True,
null=True,
verbose_name="充值类型1:会员2:押金,3:积分,4:商家",
),
),
(
"shuoming",
models.CharField(
blank=True, max_length=100, null=True, verbose_name="订单说明"
),
),
(
"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": "czjilu",
"indexes": [
models.Index(
fields=["dingdan_id"], name="czjilu_dingdan_39bbd0_idx"
),
models.Index(fields=["yonghuid"], name="czjilu_yonghui_a0555f_idx"),
],
},
),
]