class Migration(migrations.Migration):
dependencies = [
('myauth', '0001_initial'),
]
operations = [
migrations.CreateModel(
name='Ownerinfo',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('phone_number', models.CharField(max_length=50, unique=True, verbose_name='电话')),
('identity_number', models.CharField(max_length=50, unique=True, verbose_name='身份证号码')),
('owner_name', models.CharField(default='www', max_length=50, verbose_name='船主姓名')),
],
options={
'verbose_name': '船主信息',
'verbose_name_plural': '船主信息',
},
),
migrations.CreateModel(
name='Shipinfo',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('jindu', models.FloatField(max_length=50, verbose_name='经度')),
('weidu', models.FloatField(max_length=50, verbose_name='纬度')),
('speed', models.FloatField(default=60, max_length=50, verbose_name='速度')),
('Freight_type', models.CharField(default='危险品', max_length=50, verbose_name='货运类型')),
('ship_status', models.CharField(default='航行中', max_length=50, verbose_name='船舶状态')),
('task_status', models.CharField(default='已完成', max_length=50, verbose_name='任务状态')),
('tonnage', models.FloatField(default=35, max_length=50, verbose_name='船舶吨位')),
('shipname', models.CharField(default='abc', max_length=50, null=True, verbose_name='船名')),
('ownerinfo', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.DO_NOTHING, to='myauth.Ownerinfo', verbose_name='船主')),
],
options={
'verbose_name': '船舶信息',
'verbose_name_plural': '船舶信息',
},
),
migrations.CreateModel(
name='TestPicture',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('img', models.ImageField(upload_to='img')),
('name', models.CharField(max_length=20)),
],
options={
'verbose_name': '船舶信息',
'verbose_name_plural': '船舶信息',
},
),
migrations.AlterField(
model_name='article',
name='body',
field=DjangoUeditor.models.UEditorField(blank=True, verbose_name='内容'),
),
]
class Migration(migrations.Migration):
dependencies = [
('blog', '0017_auto_20181007_2241'),
]
operations = [
migrations.AddField(
model_name='shops',
name='endtime',
field=models.DateTimeField(null=True, verbose_name='抢购结束时间'),
),
migrations.AddField(
model_name='shops',
name='oldprice',
field=models.FloatField(null=True, verbose_name='原价'),
),
migrations.AddField(
model_name='shops',
name='sales',
field=models.IntegerField(null=True, verbose_name='销量'),
),
migrations.AddField(
model_name='shops',
name='starttime',
field=models.DateTimeField(null=True, verbose_name='抢购开始时间'),
),
migrations.AlterField(
model_name='shop_users',
name='headerimg',
field=models.ImageField(null=True,
upload_to='img',
verbose_name='头像'),
),
migrations.AlterField(
model_name='shops',
name='pic',
field=models.ImageField(null=True,
upload_to='img',
verbose_name='形象图'),
),
migrations.AlterField(
model_name='shops',
name='price',
field=models.FloatField(null=True, verbose_name='价格'),
),
migrations.AlterField(
model_name='shops',
name='text',
field=DjangoUeditor.models.UEditorField(blank=True,
null=True,
verbose_name='详情'),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
]
operations = [
migrations.CreateModel(
name='GetIp',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('ip', models.CharField(default='', max_length=80, verbose_name='ip地址')),
('add_time', models.DateTimeField(default=datetime.datetime.now, verbose_name='添加时间')),
],
),
migrations.CreateModel(
name='Goods',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('category_id', models.IntegerField(default=0, verbose_name='三级分类')),
('second_id', models.IntegerField(default=0, verbose_name='二级分类')),
('first_id', models.IntegerField(default=0, verbose_name='一级分类')),
('goods_sn', models.CharField(blank=True, default='', max_length=50, null=True, verbose_name='商品唯一的货号')),
('title', models.CharField(blank=True, default='', max_length=100, null=True, verbose_name='商品名')),
('url', models.CharField(blank=True, default='', max_length=500, null=True, verbose_name='商品连接')),
('brand', models.CharField(blank=True, default='', max_length=100, null=True, verbose_name='商品品牌')),
('click_num', models.IntegerField(blank=True, default=0, verbose_name='点击数')),
('sold_num', models.IntegerField(blank=True, default=0, verbose_name='商品的销售量')),
('fav_num', models.IntegerField(blank=True, default=0, null=True, verbose_name='收藏数')),
('goods_num', models.IntegerField(blank=True, default=0, null=True, verbose_name='库存数')),
('price', models.FloatField(blank=True, default=0, null=True, verbose_name='本店价格')),
('goods_brief', models.TextField(blank=True, max_length=500, null=True, verbose_name='商品简短描述')),
('goods_desc', DjangoUeditor.models.UEditorField(default='', verbose_name='内容')),
('pic', models.ImageField(blank=True, null=True, upload_to='goods/images/', verbose_name='封面图')),
('add_time', models.DateTimeField(blank=True, default=datetime.datetime.now, null=True, verbose_name='添加时间')),
],
options={
'verbose_name': '商品',
'verbose_name_plural': '商品',
},
),
migrations.CreateModel(
name='HotSearchWords',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('keywords', models.CharField(default='', max_length=20, verbose_name='热搜词')),
('index', models.IntegerField(default=0, verbose_name='排序')),
('add_time', models.DateTimeField(default=datetime.datetime.now, verbose_name='添加时间')),
],
options={
'verbose_name': '热搜词',
'verbose_name_plural': '热搜词',
},
),
]
class Migration(migrations.Migration):
initial = True
dependencies = []
operations = [
migrations.CreateModel(
name='Product',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=30, verbose_name='商品名称')),
('price', models.FloatField(verbose_name='单价')),
('num', models.IntegerField(verbose_name='数量')),
('freight', models.IntegerField(default=0, verbose_name='运费')),
('origin', models.CharField(max_length=20, verbose_name='产地')),
('pro_type',
models.CharField(choices=[('ncp', '农产品'), ('sg', '水果'),
('gyp', '工艺品'), ('fsp', '副食品')],
default='ncp',
max_length=3,
verbose_name='分类')),
('buyers', models.IntegerField(default=0,
verbose_name='购买人数')),
('comments', models.IntegerField(default=0,
verbose_name='评论人数')),
('details',
DjangoUeditor.models.UEditorField(default='',
verbose_name='商品详情')),
('mainimg',
models.ImageField(default='',
upload_to='product/mainimg/%Y/%m',
verbose_name='商品主图')),
('remind',
models.CharField(blank=True,
max_length=20,
null=True,
verbose_name='提醒')),
('add_time',
models.DateTimeField(default=datetime.datetime.now,
verbose_name='添加时间')),
],
options={
'verbose_name': '商品信息',
'verbose_name_plural': '商品信息',
},
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
]
operations = [
migrations.CreateModel(
name='XGoods',
fields=[
('gid', models.AutoField(primary_key=True, serialize=False, verbose_name='Goods Id')),
('prize', models.FloatField(blank=True, verbose_name='价格')),
('name', models.CharField(max_length=20, verbose_name='名称')),
('slug', models.CharField(db_index=True, max_length=256, verbose_name='网址')),
('intro', DjangoUeditor.models.UEditorField(blank=True, default='', verbose_name='说明')),
('add_date', models.DateTimeField(auto_now_add=True, verbose_name='添加日期')),
],
options={
'verbose_name_plural': '商品管理',
'verbose_name': '商品',
},
),
migrations.CreateModel(
name='XStore',
fields=[
('sid', models.AutoField(primary_key=True, serialize=False, verbose_name='id')),
('name', models.CharField(max_length=20, verbose_name='名称')),
('slug', models.CharField(db_index=True, max_length=256, verbose_name='网址')),
('intro', models.TextField(default='', verbose_name='Introduce')),
('create_date', models.DateTimeField(auto_now_add=True, verbose_name='创建时间')),
('author', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL, verbose_name='所有者')),
],
options={
'ordering': ['name'],
'verbose_name_plural': '商家管理',
'verbose_name': '商家',
},
),
migrations.AddField(
model_name='xgoods',
name='xstores',
field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='xstores.XStore', verbose_name='商家'),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
]
operations = [
migrations.CreateModel(
name='Goods',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('goodsname', models.CharField(max_length=64)),
('goodsprice', models.FloatField(default=0)),
('goodsnum', models.IntegerField(default=1)),
('goodsdesc', DjangoUeditor.models.UEditorField(default='商品描述')),
('add_time', models.DateField(default=datetime.datetime.now)),
],
options={
'verbose_name': '商品信息',
'verbose_name_plural': '商品信息',
},
),
migrations.CreateModel(
name='GoodsCategory',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('name', models.CharField(max_length=62)),
('goodscategory_type', models.CharField(choices=[('1', '一级目录'), ('2', '二级目录'), ('3', '三级目录')], max_length=32)),
('add_time', models.DateTimeField(default=datetime.datetime.now)),
],
options={
'verbose_name': '商品类别',
'verbose_name_plural': '商品类别',
},
),
migrations.AddField(
model_name='goods',
name='goodstype',
field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='goods.GoodsCategory'),
),
]
class Migration(migrations.Migration):
dependencies = [
('foods', '0001_initial'),
]
operations = [
migrations.CreateModel(
name='Foods',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=100,
verbose_name='食物名称')),
('price', models.FloatField(default=1.0, verbose_name='价格')),
('step_minute', models.IntegerField(verbose_name='所需时间(分钟)')),
('image',
models.ImageField(upload_to=foods.models.get_image_name,
verbose_name='图片')),
('info',
DjangoUeditor.models.UEditorField(blank=True,
null=True,
verbose_name='详情')),
('category',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='foods.Category',
verbose_name='分类')),
],
options={
'verbose_name': '菜谱',
'verbose_name_plural': '菜谱',
'db_table': 't_foods',
},
),
]
class Migration(migrations.Migration):
initial = True
dependencies = []
operations = [
migrations.CreateModel(
name='Active',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('title', models.CharField(max_length=30, verbose_name='标题')),
('introduce',
DjangoUeditor.models.UEditorField(default='',
verbose_name='活动介绍')),
('image',
models.ImageField(upload_to='active/%Y/%m',
verbose_name='缩略图')),
('classification',
models.CharField(choices=[('natural', '景区'),
('leisure', '休闲')],
default='natural',
max_length=10,
verbose_name='分类')),
('phone', models.CharField(max_length=15,
verbose_name='咨询电话')),
('go_time', models.DateTimeField(verbose_name='出发时间')),
('address', models.CharField(max_length=50,
verbose_name='集合地点')),
('price', models.FloatField(verbose_name='价格')),
('now_num',
models.IntegerField(default=0, verbose_name='当前报名人数')),
('all_num', models.IntegerField(default=0,
verbose_name='总人数')),
('add_time',
models.DateTimeField(default=datetime.datetime.now,
verbose_name='添加时间')),
],
options={
'verbose_name': '旅游活动',
'verbose_name_plural': '旅游活动',
},
),
migrations.CreateModel(
name='Spots',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=30, verbose_name='名称')),
('content',
DjangoUeditor.models.UEditorField(default='',
verbose_name='内容')),
('image',
models.ImageField(upload_to='spots/thumbnail/%Y/%m',
verbose_name='缩略图')),
('picture',
models.ImageField(upload_to='spots/mainfigure/%Y/%m',
verbose_name='主图')),
('classification',
models.CharField(choices=[('natural', '景区'),
('leisure', '休闲')],
default='natural',
max_length=10,
verbose_name='分类')),
('phone', models.CharField(max_length=15,
verbose_name='联系电话')),
('businessHours',
models.CharField(default='全年',
max_length=10,
verbose_name='开放时间')),
('address', models.CharField(max_length=50,
verbose_name='地址')),
('price', models.FloatField(verbose_name='价格')),
('x',
models.DecimalField(decimal_places=6,
default=112.460033,
max_digits=9,
verbose_name='经度')),
('y',
models.DecimalField(decimal_places=6,
default=34.624376,
max_digits=9,
verbose_name='纬度')),
('add_times',
models.DateTimeField(default=datetime.datetime.now,
verbose_name='添加时间')),
],
options={
'verbose_name': '旅游景区',
'verbose_name_plural': '旅游景区',
},
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
]
operations = [
migrations.CreateModel(
name='goods',
fields=[
('goods_id', models.AutoField(primary_key=True,
serialize=False)),
('goods_name',
models.CharField(max_length=30, verbose_name='商品名')),
('goods_price',
models.FloatField(default=0, verbose_name='商品价格')),
('goods_pickTime',
models.DateTimeField(default=datetime.datetime.now,
verbose_name='采摘日期')),
('goods_shelflife', models.IntegerField(verbose_name='商品保质期')),
('goods_desc',
DjangoUeditor.models.UEditorField(default='',
verbose_name='商品详情')),
('goods_front_image',
models.ImageField(blank=True,
null=True,
upload_to='goods/images/',
verbose_name='外面封面图')),
('goods_weight',
models.CharField(max_length=10, verbose_name='商品重量')),
('goods_updateTime',
models.DateTimeField(auto_now=True, verbose_name='商品上次更新时间')),
('goods_extra', models.TextField(verbose_name='商品备注')),
('goods_title',
models.CharField(max_length=100, verbose_name='商品标题')),
('goods_productarea',
models.CharField(max_length=20, verbose_name='产地')),
('goods_dateadded',
models.DateTimeField(auto_now_add=True, verbose_name='上架日期')),
('goods_post', models.BooleanField(verbose_name='是否承担运费')),
('goods_stock',
models.IntegerField(default=0, verbose_name='总库存')),
],
options={
'verbose_name': '商品',
'verbose_name_plural': '商品',
'db_table': 'fb_goods',
},
),
migrations.CreateModel(
name='goodsimage',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('image',
models.ImageField(blank=True,
null=True,
upload_to='',
verbose_name='图片')),
('add_time',
models.DateTimeField(default=datetime.datetime.now,
verbose_name='添加时间')),
('goods',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='images',
to='goods.goods',
verbose_name='商品')),
],
options={
'verbose_name': '商品图片',
'verbose_name_plural': '商品图片',
'db_table': 'fb_goodsimage',
},
),
migrations.CreateModel(
name='shop',
fields=[
('shop_id', models.AutoField(primary_key=True,
serialize=False)),
('shop_name',
models.CharField(max_length=20, verbose_name='店铺名')),
('shop_address',
models.CharField(max_length=50, verbose_name='店铺地址')),
('shop_phone',
models.CharField(max_length=11, verbose_name='联系方式')),
('shop_extra', models.TextField(verbose_name='店铺信息')),
('shop_updateTime',
models.DateTimeField(auto_now=True, verbose_name='更新时间')),
('shop_user',
models.OneToOneField(
blank=True,
null=True,
on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL,
verbose_name='所属用户')),
],
options={
'verbose_name': '店铺',
'verbose_name_plural': '店铺',
'db_table': 'fb_shop',
},
),
migrations.AddField(
model_name='goods',
name='goods_shop',
field=models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.CASCADE,
to='goods.shop',
verbose_name='所属店铺'),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = []
operations = [
migrations.CreateModel(
name='Banner',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('image',
models.ImageField(upload_to='banner/', verbose_name='轮播图片')),
('index',
models.SmallIntegerField(default=0, verbose_name='轮播顺序')),
('add_time',
models.DateField(default=datetime.datetime.now,
help_text='添加时间',
verbose_name='添加时间')),
('status',
models.NullBooleanField(default=True,
help_text='数据状态',
verbose_name='数据状态')),
],
options={
'verbose_name': '轮播的商品',
'verbose_name_plural': '轮播的商品',
},
),
migrations.CreateModel(
name='Goods',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('goods_sn',
models.CharField(default='',
max_length=50,
verbose_name='商品唯一货号')),
('name', models.CharField(max_length=240, verbose_name='商品名')),
('click_num', models.IntegerField(default=0,
verbose_name='点击数')),
('sold_num', models.IntegerField(default=0,
verbose_name='销售量')),
('fav_num', models.IntegerField(default=0,
verbose_name='收藏数')),
('goods_num', models.IntegerField(default=0,
verbose_name='库存数')),
('market_price',
models.FloatField(default=0, verbose_name='市场价格')),
('shop_price', models.FloatField(default=0,
verbose_name='本店价格')),
('goods_brief',
models.TextField(max_length=300, verbose_name='商品简短描述')),
('goods_desc',
DjangoUeditor.models.UEditorField(default='',
verbose_name='内容')),
('ship_free',
models.BooleanField(default=True, verbose_name='是否免邮')),
('goods_front_image',
models.ImageField(blank=True,
null=True,
upload_to='goods/front',
verbose_name='代表性图片')),
('is_new',
models.BooleanField(default=False, verbose_name='是否新品')),
('is_hot',
models.BooleanField(default=False, verbose_name='是否热销')),
('add_time',
models.DateField(default=datetime.datetime.now,
help_text='添加时间',
verbose_name='添加时间')),
('status',
models.NullBooleanField(default=True,
help_text='数据状态',
verbose_name='数据状态')),
],
options={
'verbose_name': '商品',
'verbose_name_plural': '商品',
},
),
migrations.CreateModel(
name='GoodsCategory',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name',
models.CharField(default='',
help_text='类别名',
max_length=30,
verbose_name='类别名')),
('code',
models.CharField(default='',
help_text='类别code',
max_length=30,
verbose_name='类别code')),
('desc',
models.CharField(default='',
help_text='类别描述',
max_length=120,
verbose_name='类别描述')),
('category_type',
models.IntegerField(choices=[(1, '一级类目'), (2, '二级类目'),
(3, '三级类目')],
help_text='类别描述')),
('is_tab',
models.BooleanField(default=False,
help_text='是否热门',
verbose_name='是否热门')),
('add_time',
models.DateField(default=datetime.datetime.now,
help_text='添加时间',
verbose_name='添加时间')),
('status',
models.NullBooleanField(default=True,
help_text='数据状态',
verbose_name='数据状态')),
('parent_category',
models.ForeignKey(blank=True,
help_text='父类别',
null=True,
on_delete=django.db.models.deletion.CASCADE,
related_name='sub_cat',
to='goods.GoodsCategory',
verbose_name='父类别')),
],
options={
'verbose_name': '商品类别',
'verbose_name_plural': '商品类别',
},
),
migrations.CreateModel(
name='GoodsCategoryBrand',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name',
models.CharField(default='',
help_text='类别名',
max_length=30,
verbose_name='类别名')),
('desc',
models.TextField(default='',
help_text='类别描述',
verbose_name='类别描述')),
('image',
models.ImageField(max_length=200,
upload_to='brand/images/',
verbose_name='图片')),
('add_time',
models.DateField(default=datetime.datetime.now,
help_text='添加时间',
verbose_name='添加时间')),
('status',
models.NullBooleanField(default=True,
help_text='数据状态',
verbose_name='数据状态')),
],
options={
'verbose_name': '品牌',
'verbose_name_plural': '品牌',
},
),
migrations.CreateModel(
name='GoodsImage',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('image',
models.ImageField(blank=True,
null=True,
upload_to='goods/images/',
verbose_name='图片')),
('image_url',
models.CharField(blank=True,
max_length=300,
null=True,
verbose_name='图片url')),
('add_time',
models.DateField(default=datetime.datetime.now,
help_text='添加时间',
verbose_name='添加时间')),
('status',
models.NullBooleanField(default=True,
help_text='数据状态',
verbose_name='数据状态')),
('goods',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='images',
to='goods.Goods',
verbose_name='商品')),
],
options={
'verbose_name': '商品的图片',
'verbose_name_plural': '商品的图片',
},
),
migrations.AddField(
model_name='goods',
name='category',
field=models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.CASCADE,
to='goods.GoodsCategory',
verbose_name='商品类目'),
),
migrations.AddField(
model_name='banner',
name='goods',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to='goods.Goods',
verbose_name='商品'),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
]
operations = [
migrations.CreateModel(
name='CurrentSignalPack',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('time',
models.DateTimeField(auto_now_add=True,
verbose_name='Collected Time')),
('sampling_rate', models.IntegerField(blank=True, null=True)),
('rpm',
models.SmallIntegerField(default=3000, verbose_name='RPM')),
],
),
migrations.CreateModel(
name='Manufacturer',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name',
models.CharField(max_length=64,
unique=True,
verbose_name='Manufacturer name')),
('telephone',
models.CharField(blank=True,
max_length=30,
null=True,
verbose_name='Telephone')),
('memo',
models.CharField(blank=True,
max_length=128,
null=True,
verbose_name='Memory')),
],
),
migrations.CreateModel(
name='MonthlyRecord',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('c_day',
models.DateField(auto_now_add=True,
verbose_name='Created time')),
('description',
DjangoUeditor.models.UEditorField(default='',
verbose_name='Content')),
],
),
migrations.CreateModel(
name='Motor',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name',
models.CharField(max_length=64,
unique=True,
verbose_name='Name of asset')),
('sn',
models.CharField(max_length=128,
unique=True,
verbose_name='Serial number')),
('statu',
models.SmallIntegerField(choices=[
(0, 'Excellent'), (1, 'Good'), (2, 'Moderate'),
(3, 'Poor'), (4, 'Offline')
],
default=2,
verbose_name='Asset statu')),
('health_indicator',
models.FloatField(default=85,
verbose_name='Value of Health Indicator')),
('lr_time',
models.DateTimeField(blank=True,
null=True,
verbose_name='Last repair/check date')),
('pr_time',
models.DateTimeField(blank=True,
null=True,
verbose_name='Purchase date')),
('md_time',
models.DateTimeField(auto_now=True,
verbose_name='Modified date')),
('cr_time',
models.DateTimeField(auto_now_add=True,
verbose_name='Created date')),
('sr_time',
models.DateTimeField(blank=True,
null=True,
verbose_name='Start running date')),
('phase_number',
models.SmallIntegerField(blank=True,
null=True,
verbose_name='Number of phases ')),
('pole_pairs_number',
models.SmallIntegerField(
blank=True,
null=True,
verbose_name='Number of pole_pairs ')),
('turn_number',
models.SmallIntegerField(blank=True,
null=True,
verbose_name='Number of turns ')),
('rated_voltage',
models.FloatField(blank=True,
null=True,
verbose_name='Rated voltage /V')),
('rated_speed',
models.FloatField(blank=True,
null=True,
verbose_name='Rated speed /rpm')),
('memo',
DjangoUeditor.models.UEditorField(default='',
verbose_name='Memory')),
('equip_type',
models.SmallIntegerField(choices=[
(0, 'Motor'), (1, 'Bearing'), (2, 'Rotor'), (3, 'Stator')
],
default=0,
verbose_name='Equipment type')),
('admin',
models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.SET_NULL,
to=settings.AUTH_USER_MODEL,
verbose_name='Administrator')),
('manufacturer',
models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.SET_NULL,
to='motors.Manufacturer',
verbose_name='Manufacturer')),
],
options={
'abstract': False,
},
),
migrations.CreateModel(
name='Tag',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name',
models.CharField(max_length=32,
unique=True,
verbose_name='Tag name')),
('c_day',
models.DateField(auto_now_add=True,
verbose_name='Created time')),
],
),
migrations.CreateModel(
name='WeeklyRecord',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('c_day',
models.DateField(auto_now_add=True,
verbose_name='Created time')),
('description',
DjangoUeditor.models.UEditorField(default='',
verbose_name='Content')),
],
),
migrations.CreateModel(
name='Wphase',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('signal',
models.BinaryField(verbose_name='Collected Signal vector')),
('frequency', models.FloatField(default=0,
verbose_name='PSF')),
('amplitude', models.FloatField(default=0,
verbose_name='AMP')),
('initial_phase',
models.FloatField(default=0, verbose_name='IPA')),
('signal_pack',
models.OneToOneField(
on_delete=django.db.models.deletion.CASCADE,
related_name='wphase',
to='motors.CurrentSignalPack',
verbose_name='Parent pack')),
],
options={
'abstract': False,
},
),
migrations.CreateModel(
name='Wfeature',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('rms',
models.FloatField(default=0,
verbose_name='U phase root-mean-square')),
('thd',
models.FloatField(
default=0, verbose_name='Total harmonic distortion %')),
('harmonics',
models.BinaryField(verbose_name='1st-20th harmonic energy')),
('max_current',
models.FloatField(default=0,
verbose_name='Maximum current value')),
('min_current',
models.FloatField(default=0,
verbose_name='Minimum current value')),
('fbrb',
models.BinaryField(
null=True,
verbose_name='Frequencies of Broken rotor bar')),
('signal_pack',
models.OneToOneField(
on_delete=django.db.models.deletion.CASCADE,
related_name='wfeature',
to='motors.CurrentSignalPack',
verbose_name='Parent pack')),
],
options={
'abstract': False,
},
),
migrations.CreateModel(
name='WarningLog',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('c_day',
models.DateTimeField(auto_now_add=True,
verbose_name='Created time')),
('description',
models.TextField(verbose_name='Warning description')),
('severity',
models.SmallIntegerField(blank=True,
choices=[(0, 'Attention'),
(1, 'Serious')],
null=True,
verbose_name='Warning severity')),
('motor',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='motors.Motor',
verbose_name='Related motor')),
],
),
migrations.CreateModel(
name='Vphase',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('signal',
models.BinaryField(verbose_name='Collected Signal vector')),
('frequency', models.FloatField(default=0,
verbose_name='PSF')),
('amplitude', models.FloatField(default=0,
verbose_name='AMP')),
('initial_phase',
models.FloatField(default=0, verbose_name='IPA')),
('signal_pack',
models.OneToOneField(
on_delete=django.db.models.deletion.CASCADE,
related_name='vphase',
to='motors.CurrentSignalPack',
verbose_name='Parent pack')),
],
options={
'abstract': False,
},
),
migrations.CreateModel(
name='Vfeature',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('rms',
models.FloatField(default=0,
verbose_name='U phase root-mean-square')),
('thd',
models.FloatField(
default=0, verbose_name='Total harmonic distortion %')),
('harmonics',
models.BinaryField(verbose_name='1st-20th harmonic energy')),
('max_current',
models.FloatField(default=0,
verbose_name='Maximum current value')),
('min_current',
models.FloatField(default=0,
verbose_name='Minimum current value')),
('fbrb',
models.BinaryField(
null=True,
verbose_name='Frequencies of Broken rotor bar')),
('signal_pack',
models.OneToOneField(
on_delete=django.db.models.deletion.CASCADE,
related_name='vfeature',
to='motors.CurrentSignalPack',
verbose_name='Parent pack')),
],
options={
'abstract': False,
},
),
migrations.CreateModel(
name='Uphase',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('signal',
models.BinaryField(verbose_name='Collected Signal vector')),
('frequency', models.FloatField(default=0,
verbose_name='PSF')),
('amplitude', models.FloatField(default=0,
verbose_name='AMP')),
('initial_phase',
models.FloatField(default=0, verbose_name='IPA')),
('signal_pack',
models.OneToOneField(
on_delete=django.db.models.deletion.CASCADE,
related_name='uphase',
to='motors.CurrentSignalPack',
verbose_name='Parent pack')),
],
options={
'abstract': False,
},
),
migrations.CreateModel(
name='Ufeature',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('rms',
models.FloatField(default=0,
verbose_name='U phase root-mean-square')),
('thd',
models.FloatField(
default=0, verbose_name='Total harmonic distortion %')),
('harmonics',
models.BinaryField(verbose_name='1st-20th harmonic energy')),
('max_current',
models.FloatField(default=0,
verbose_name='Maximum current value')),
('min_current',
models.FloatField(default=0,
verbose_name='Minimum current value')),
('fbrb',
models.BinaryField(
null=True,
verbose_name='Frequencies of Broken rotor bar')),
('signal_pack',
models.OneToOneField(
on_delete=django.db.models.deletion.CASCADE,
related_name='ufeature',
to='motors.CurrentSignalPack',
verbose_name='Parent pack')),
],
options={
'abstract': False,
},
),
migrations.CreateModel(
name='SymComponent',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('n_sequence_rms',
models.FloatField(
default=0,
verbose_name='Negative sequence root-mean-square')),
('p_sequence_rms',
models.FloatField(
default=0,
verbose_name='Positive sequence root-mean-square')),
('z_sequence_rms',
models.FloatField(
default=0,
verbose_name='Zero sequence root-mean-square')),
('imbalance',
models.FloatField(default=0,
verbose_name='Current imbanlance %')),
('signal_pack',
models.OneToOneField(
on_delete=django.db.models.deletion.CASCADE,
related_name='symcomp',
to='motors.CurrentSignalPack',
verbose_name='Parent pack')),
],
),
migrations.CreateModel(
name='Stator',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name',
models.CharField(max_length=64,
unique=True,
verbose_name='Name of asset')),
('sn',
models.CharField(max_length=128,
unique=True,
verbose_name='Serial number')),
('statu',
models.SmallIntegerField(choices=[
(0, 'Excellent'), (1, 'Good'), (2, 'Moderate'),
(3, 'Poor'), (4, 'Offline')
],
default=2,
verbose_name='Asset statu')),
('health_indicator',
models.FloatField(default=85,
verbose_name='Value of Health Indicator')),
('lr_time',
models.DateTimeField(blank=True,
null=True,
verbose_name='Last repair/check date')),
('pr_time',
models.DateTimeField(blank=True,
null=True,
verbose_name='Purchase date')),
('md_time',
models.DateTimeField(auto_now=True,
verbose_name='Modified date')),
('cr_time',
models.DateTimeField(auto_now_add=True,
verbose_name='Created date')),
('sr_time',
models.DateTimeField(blank=True,
null=True,
verbose_name='Start running date')),
('length',
models.FloatField(blank=True,
null=True,
verbose_name='Length /mm')),
('outer_diameter',
models.FloatField(blank=True,
null=True,
verbose_name='Outer diameter /mm')),
('inner_diameter',
models.FloatField(blank=True,
null=True,
verbose_name='Inner diameter /mm')),
('slot_number',
models.SmallIntegerField(blank=True,
null=True,
verbose_name='Number of slots')),
('memo',
DjangoUeditor.models.UEditorField(default='',
verbose_name='Memory')),
('equip_type',
models.SmallIntegerField(choices=[
(0, 'Motor'), (1, 'Bearing'), (2, 'Rotor'), (3, 'Stator')
],
default=3,
verbose_name='Equipment type')),
('manufacturer',
models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.SET_NULL,
to='motors.Manufacturer',
verbose_name='Manufacturer')),
('motor',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='stators',
to='motors.Motor')),
('tags',
models.ManyToManyField(blank=True,
to='motors.Tag',
verbose_name='Tags')),
],
options={
'abstract': False,
},
),
migrations.CreateModel(
name='Rotor',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name',
models.CharField(max_length=64,
unique=True,
verbose_name='Name of asset')),
('sn',
models.CharField(max_length=128,
unique=True,
verbose_name='Serial number')),
('statu',
models.SmallIntegerField(choices=[
(0, 'Excellent'), (1, 'Good'), (2, 'Moderate'),
(3, 'Poor'), (4, 'Offline')
],
default=2,
verbose_name='Asset statu')),
('health_indicator',
models.FloatField(default=85,
verbose_name='Value of Health Indicator')),
('lr_time',
models.DateTimeField(blank=True,
null=True,
verbose_name='Last repair/check date')),
('pr_time',
models.DateTimeField(blank=True,
null=True,
verbose_name='Purchase date')),
('md_time',
models.DateTimeField(auto_now=True,
verbose_name='Modified date')),
('cr_time',
models.DateTimeField(auto_now_add=True,
verbose_name='Created date')),
('sr_time',
models.DateTimeField(blank=True,
null=True,
verbose_name='Start running date')),
('length',
models.FloatField(blank=True,
null=True,
verbose_name='Length /mm')),
('outer_diameter',
models.FloatField(blank=True,
null=True,
verbose_name='Outer diameter /mm')),
('inner_diameter',
models.FloatField(blank=True,
null=True,
verbose_name='Inner diameter /mm')),
('slot_number',
models.SmallIntegerField(blank=True,
null=True,
verbose_name='Number of slots')),
('memo',
DjangoUeditor.models.UEditorField(default='',
verbose_name='Memory')),
('equip_type',
models.SmallIntegerField(choices=[
(0, 'Motor'), (1, 'Bearing'), (2, 'Rotor'), (3, 'Stator')
],
default=2,
verbose_name='Equipment type')),
('manufacturer',
models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.SET_NULL,
to='motors.Manufacturer',
verbose_name='Manufacturer')),
('motor',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='rotors',
to='motors.Motor')),
('tags',
models.ManyToManyField(blank=True,
to='motors.Tag',
verbose_name='Tags')),
],
options={
'abstract': False,
},
),
migrations.AddField(
model_name='motor',
name='tags',
field=models.ManyToManyField(blank=True,
to='motors.Tag',
verbose_name='Tags'),
),
migrations.AddField(
model_name='currentsignalpack',
name='motor',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
related_name='packs',
to='motors.Motor'),
),
migrations.CreateModel(
name='Bearing',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name',
models.CharField(max_length=64,
unique=True,
verbose_name='Name of asset')),
('sn',
models.CharField(max_length=128,
unique=True,
verbose_name='Serial number')),
('statu',
models.SmallIntegerField(choices=[
(0, 'Excellent'), (1, 'Good'), (2, 'Moderate'),
(3, 'Poor'), (4, 'Offline')
],
default=2,
verbose_name='Asset statu')),
('health_indicator',
models.FloatField(default=85,
verbose_name='Value of Health Indicator')),
('lr_time',
models.DateTimeField(blank=True,
null=True,
verbose_name='Last repair/check date')),
('pr_time',
models.DateTimeField(blank=True,
null=True,
verbose_name='Purchase date')),
('md_time',
models.DateTimeField(auto_now=True,
verbose_name='Modified date')),
('cr_time',
models.DateTimeField(auto_now_add=True,
verbose_name='Created date')),
('sr_time',
models.DateTimeField(blank=True,
null=True,
verbose_name='Start running date')),
('inner_race_diameter',
models.FloatField(blank=True,
null=True,
verbose_name='Inner race diameter /mm')),
('inner_race_width',
models.FloatField(blank=True,
null=True,
verbose_name='Inner race width /mm')),
('outter_race_diameter',
models.FloatField(blank=True,
null=True,
verbose_name='Outter race diameter /mm')),
('outter_race_width',
models.FloatField(blank=True,
null=True,
verbose_name='Outter race width /mm')),
('equip_type',
models.SmallIntegerField(choices=[
(0, 'Motor'), (1, 'Bearing'), (2, 'Rotor'), (3, 'Stator')
],
default=1,
verbose_name='Equipment type')),
('roller_diameter',
models.FloatField(blank=True,
null=True,
verbose_name='Roller diameter /mm')),
('roller_number',
models.SmallIntegerField(blank=True,
null=True,
verbose_name='Number of rollers')),
('contact_angle',
models.FloatField(blank=True,
null=True,
verbose_name='Contact angle ')),
('memo',
DjangoUeditor.models.UEditorField(default='',
verbose_name='Memory')),
('manufacturer',
models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.SET_NULL,
to='motors.Manufacturer',
verbose_name='Manufacturer')),
('motor',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='bearings',
to='motors.Motor')),
('tags',
models.ManyToManyField(blank=True,
to='motors.Tag',
verbose_name='Tags')),
],
options={
'abstract': False,
},
),
]
class Migration(migrations.Migration):
initial = True
dependencies = []
operations = [
migrations.CreateModel(
name='Banner',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('image',
models.ImageField(upload_to='banner',
verbose_name='Roller Image')),
('index',
models.IntegerField(default=0,
verbose_name='Rolling Sequence')),
('add_time',
models.DateTimeField(default=datetime.datetime.now,
verbose_name='Add Time')),
],
options={
'verbose_name_plural': 'Slider Image',
'verbose_name': 'Slider Image',
},
),
migrations.CreateModel(
name='Goods',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('goods_sn',
models.CharField(default='',
max_length=50,
verbose_name='Product SKU')),
('name',
models.CharField(default='',
max_length=300,
verbose_name='Product Name')),
('goods_size',
models.CharField(blank=True,
choices=[('OneSize', 'OneSize'),
('29x32', '29x32'),
('30x32', '30x32'),
('31x32', '31x32'),
('32x32', '32x32'),
('33x32', '33x32'),
('34x32', '34x32'),
('36x32', '36x32'),
('38x32', '38x32'),
('xsmall', 'xsmall'),
('small', 'small'),
('medium', 'medium'),
('large', 'large'),
('xlarge', 'xlarge'), ('5', '5'),
('6', '6'), ('7', '7'), ('8', '8'),
('9', '9'), ('10', '10'),
('other', 'other')],
max_length=10,
null=True,
verbose_name='Product Size')),
('goods_color',
models.CharField(blank=True,
choices=[
('OneColor', 'OneColor'), ('red', 'Red'),
('blue', 'Blue'), ('pink', 'pink'),
('black', 'black'), ('white', 'white'),
('green', 'green'), ('grey', 'grey'),
('other', 'other')
],
max_length=10,
null=True,
verbose_name='Available Color')),
('click_num',
models.IntegerField(default=0, verbose_name='Click Times')),
('sold_num',
models.IntegerField(default=0, verbose_name='Sold Quantity')),
('fav_num',
models.IntegerField(default=0,
verbose_name='Total Favorite')),
('goods_num',
models.IntegerField(blank=True,
default=0,
null=True,
verbose_name='Inventory')),
('market_price',
models.FloatField(default=0.0, verbose_name='Market Price')),
('shop_price',
models.FloatField(default=0.0,
verbose_name='Price in Store')),
('goods_brief',
models.TextField(max_length=100,
verbose_name='Product Brief Intro')),
('goods_desc',
DjangoUeditor.models.UEditorField(
default='', verbose_name='Product Detail')),
('ship_free',
models.BooleanField(default=False,
verbose_name='Free delivery')),
('goods_front_image',
models.ImageField(blank=True,
null=True,
upload_to='',
verbose_name='Home Page Product Image')),
('is_new',
models.BooleanField(default=False,
verbose_name='New Arrival')),
('is_hot',
models.BooleanField(default=False,
verbose_name='Popular Product')),
('add_time',
models.DateTimeField(default=datetime.datetime.now,
verbose_name='Add Time')),
],
options={
'verbose_name_plural': 'Product Detail',
'verbose_name': 'Product Detail',
},
),
migrations.CreateModel(
name='GoodsCategory',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name',
models.CharField(default='',
help_text='Category Name',
max_length=30,
verbose_name='Category Name')),
('code',
models.CharField(default='',
help_text='Category Code',
max_length=30,
verbose_name='Category Code')),
('desc',
models.TextField(default='Some Category Description...',
help_text='Category Description',
verbose_name='Category Description')),
('category_type',
models.IntegerField(choices=[(1, 'First Category'),
(2, 'Second Category'),
(3, 'Third Category'),
(4, 'Fourth Category')],
help_text='Category Type',
verbose_name='Category Type')),
('is_tab',
models.BooleanField(default=False,
help_text='On Navigation Bar',
verbose_name='On NaviBar')),
('add_time',
models.DateTimeField(default=datetime.datetime.now,
verbose_name='Add Time')),
('parent_category',
models.ForeignKey(blank=True,
null=True,
on_delete=django.db.models.deletion.CASCADE,
related_name='sub_cat',
to='goods.GoodsCategory',
verbose_name='Parent Category')),
],
options={
'verbose_name_plural': 'Goods Category',
'verbose_name': 'Goods Category',
},
),
migrations.CreateModel(
name='GoodsCategoryBrand',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name',
models.CharField(default='',
help_text='Brand Name',
max_length=30,
verbose_name='Brand Name')),
('desc',
models.TextField(default='',
help_text='Brand Description',
max_length=500,
verbose_name='Brand Description')),
('image',
models.ImageField(max_length=200, upload_to='brand/image/')),
('add_time',
models.DateTimeField(default=datetime.datetime.now,
verbose_name='Add Time')),
('category',
models.ForeignKey(blank=True,
null=True,
on_delete=django.db.models.deletion.CASCADE,
related_name='brands',
to='goods.GoodsCategory',
verbose_name='Brand Category')),
],
options={
'verbose_name_plural': 'Product Brand',
'verbose_name': 'Product Brand',
},
),
migrations.CreateModel(
name='GoodsImage',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('image',
models.ImageField(blank=True,
null=True,
upload_to='',
verbose_name='Product Image')),
('image_url',
models.CharField(blank=True,
max_length=300,
null=True,
verbose_name='image url')),
('add_time',
models.DateTimeField(default=datetime.datetime.now,
verbose_name='Add Time')),
('goods',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='images',
to='goods.Goods',
verbose_name='Product Name')),
],
options={
'verbose_name_plural': 'Item Image Roller',
'verbose_name': 'Item Image Roller',
},
),
migrations.AddField(
model_name='goods',
name='brand',
field=models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.CASCADE,
to='goods.GoodsCategoryBrand',
verbose_name='Product Brand'),
),
migrations.AddField(
model_name='goods',
name='category',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to='goods.GoodsCategory',
verbose_name='Product Category'),
),
migrations.AddField(
model_name='banner',
name='goods',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to='goods.Goods',
verbose_name='Product Name'),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = []
operations = [
migrations.CreateModel(
name='Banner',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('image',
models.ImageField(upload_to='banner', verbose_name='轮播图片')),
('index', models.IntegerField(default=0, verbose_name='轮播顺序')),
('add_time',
models.DateTimeField(default=datetime.datetime.now,
verbose_name='添加时间')),
],
options={
'verbose_name': '轮播图',
'verbose_name_plural': '轮播图',
},
),
migrations.CreateModel(
name='GoodCS',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('goods_size',
models.CharField(choices=[('35', '35'), ('36', '36'),
('37', '37'), ('38', '38'),
('39', '39'), ('40', '40'),
('41', '41'), ('42', '42'),
('43', '43'), ('44', '44'),
('45', '45'),
('S', 'S'), ('M', 'M'), ('L', 'L'),
('XL', 'XL'), ('均码', '均码')],
max_length=5,
verbose_name='尺码')),
('goods_color',
models.CharField(blank=True,
max_length=10,
null=True,
verbose_name='颜色')),
('goods_num', models.IntegerField(default=0,
verbose_name='库存数')),
('add_time',
models.DateTimeField(default=datetime.datetime.now,
verbose_name='添加时间')),
],
options={
'verbose_name': '商品色码',
'verbose_name_plural': '商品色码',
},
),
migrations.CreateModel(
name='GoodImage',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('image',
models.ImageField(blank=True,
null=True,
upload_to='goods/images/',
verbose_name='图片')),
('add_time',
models.DateTimeField(default=datetime.datetime.now,
verbose_name='添加时间')),
('cs',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='img',
to='goods.GoodCS',
verbose_name='商品色码')),
],
options={
'verbose_name': '商品图片',
'verbose_name_plural': '商品图片',
},
),
migrations.CreateModel(
name='Goods',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('category',
models.CharField(choices=[('踩的', '踩的'), ('穿的', '穿的'),
('戴的', '戴的')],
default='踩的',
help_text='类别',
max_length=30,
verbose_name='类别')),
('goods_sn',
models.CharField(default='',
max_length=50,
verbose_name='商品货号')),
('name', models.CharField(max_length=100, verbose_name='商品名')),
('sold_num',
models.IntegerField(default=0, verbose_name='商品销售量')),
('fav_num', models.IntegerField(default=0,
verbose_name='收藏数')),
('price', models.FloatField(default=0, verbose_name='价格')),
('gender',
models.CharField(choices=[('male', '男的'), ('female', '女的'),
('neutral', '男女同款')],
default='female',
max_length=6,
verbose_name='性别')),
('goods_desc',
DjangoUeditor.models.UEditorField(default='',
verbose_name='内容')),
('goods_front_image',
models.ImageField(blank=True,
null=True,
upload_to='goods/images/',
verbose_name='封面图')),
('is_new',
models.BooleanField(default=False, verbose_name='是否新品')),
('is_hot',
models.BooleanField(default=False, verbose_name='是否热销')),
('is_sale',
models.BooleanField(default=False, verbose_name='是否优惠')),
('add_time',
models.DateTimeField(default=datetime.datetime.now,
verbose_name='添加时间')),
],
options={
'verbose_name': '商品',
'verbose_name_plural': '商品',
},
),
migrations.AddField(
model_name='goodcs',
name='goods',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
related_name='cs',
to='goods.Goods',
verbose_name='商品'),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
('auth', '0008_alter_user_username_max_length'),
]
operations = [
migrations.CreateModel(
name='Profile',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('password', models.CharField(max_length=128, verbose_name='password')),
('last_login', models.DateTimeField(blank=True, null=True, verbose_name='last login')),
('is_superuser', models.BooleanField(default=False, help_text='Designates that this user has all permissions without explicitly assigning them.', verbose_name='superuser status')),
('username', models.CharField(error_messages={'unique': 'A user with that username already exists.'}, help_text='Required. 150 characters or fewer. Letters, digits and @/./+/-/_ only.', max_length=150, unique=True, validators=[django.contrib.auth.validators.UnicodeUsernameValidator()], verbose_name='username')),
('first_name', models.CharField(blank=True, max_length=30, verbose_name='first name')),
('last_name', models.CharField(blank=True, max_length=30, verbose_name='last name')),
('email', models.EmailField(blank=True, max_length=254, verbose_name='email address')),
('is_staff', models.BooleanField(default=False, help_text='Designates whether the user can log into this admin site.', verbose_name='staff status')),
('is_active', models.BooleanField(default=True, help_text='Designates whether this user should be treated as active. Unselect this instead of deleting accounts.', verbose_name='active')),
('date_joined', models.DateTimeField(default=django.utils.timezone.now, verbose_name='date joined')),
('sex', models.CharField(choices=[('未知', '未知'), ('男', '男'), ('女', '女')], default='未知', max_length=50, null=True, verbose_name='性别')),
('birthDate', models.DateField(blank=True, default='1970-01-01', null=True, verbose_name='出生日期')),
('nickName', models.CharField(default='', max_length=50, null=True, verbose_name='昵称')),
('mobile', models.CharField(error_messages={'unique': '该手机号已被注册.'}, help_text='手机账号', max_length=255, verbose_name='手机账号')),
('avatar', models.ImageField(blank=True, null=True, upload_to=ic_shop.models.Profile.get_avatar_path)),
],
options={
'verbose_name': '用户',
'verbose_name_plural': '用户',
},
managers=[
('objects', django.contrib.auth.models.UserManager()),
],
),
migrations.CreateModel(
name='AreasInfo',
fields=[
('id', models.CharField(default='0', max_length=50, primary_key=True, serialize=False, verbose_name='区域编号')),
('name', models.CharField(default='', max_length=50, null=True, verbose_name='区域名称')),
('areaLevel', models.CharField(default='', max_length=50, null=True, verbose_name='区域层级')),
('parent_id', models.CharField(default='', max_length=50, null=True, verbose_name='区域母编号')),
],
),
migrations.CreateModel(
name='Brand',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('title', models.CharField(default='默认', error_messages={'unique': '该品牌已经存在'}, help_text='Required. 150 characters or fewer. Letters, digits and @/./+/-/_ only.', max_length=255, unique=True, verbose_name='标签名称')),
('status', models.IntegerField(default=1, validators=[django.core.validators.MaxValueValidator(2), django.core.validators.MinValueValidator(0)], verbose_name='0- 未激活, 1 - 激活, 2- 过期')),
('description', models.TextField(blank=True, max_length=1024, verbose_name='描述')),
('entry_date', models.DateTimeField(auto_now_add=True, verbose_name='入库时间')),
('update_time', models.DateTimeField(auto_now=True, null=True, verbose_name='更新时间')),
],
options={
'verbose_name': '商品品牌',
'verbose_name_plural': '商品品牌',
},
),
migrations.CreateModel(
name='Comment',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('title', models.CharField(default='', max_length=1024, null=True, verbose_name='标题')),
('description', models.CharField(blank=True, max_length=1024, verbose_name='描述')),
('pub_date', models.DateTimeField(auto_now_add=True, verbose_name='发表时间')),
('update_time', models.DateTimeField(auto_now=True, null=True, verbose_name='更新时间')),
],
options={
'verbose_name': '商品评论',
'verbose_name_plural': '商品评论',
},
),
migrations.CreateModel(
name='Company',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('name', models.CharField(default='', max_length=100, unique=True, verbose_name='公司名称')),
('address', models.CharField(default='', max_length=100, null=True, verbose_name='公司地址')),
('mobile', models.CharField(default='', max_length=100, null=True, verbose_name='公司电话')),
('logo', models.ImageField(blank=True, null=True, upload_to=ic_shop.models.Company.get_logo_path)),
('describe', models.CharField(default='', max_length=500, null=True, verbose_name='公司简介')),
('pub_date', models.DateTimeField(auto_now_add=True, null=True, verbose_name='发表时间')),
('update_time', models.DateTimeField(auto_now=True, null=True, verbose_name='更新时间')),
('offic_acc_url', models.CharField(default='', max_length=100, null=True, verbose_name='公众号URL')),
('offic_acc_content', DjangoUeditor.models.UEditorField(blank=True, default='', verbose_name='公众号描述')),
('ali_appId', models.CharField(blank=True, default='', max_length=255, null=True, verbose_name='支付宝-公司支付APPID')),
('ali_publicKey', models.TextField(blank=True, null=True, verbose_name='支付宝-支付宝公钥')),
('ali_privateKey', models.TextField(blank=True, null=True, verbose_name='支付宝-应用私钥')),
('ali_notifyUrl', models.CharField(blank=True, max_length=255, null=True, verbose_name='支付宝-支付通知url')),
('leader', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='leader', to=settings.AUTH_USER_MODEL, verbose_name='公司负责人')),
],
options={
'verbose_name': '公司',
'verbose_name_plural': '公司',
},
),
migrations.CreateModel(
name='CompanyDeviceUpdatePackage',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('version', models.FloatField(blank=True, default='1.0', null=True, verbose_name='版本号')),
('file', models.FileField(blank=True, null=True, upload_to=ic_shop.models.CompanyDeviceUpdatePackage.get_package_path, verbose_name='更新包')),
('description', models.CharField(blank=True, default='', max_length=500, null=True, verbose_name='介绍')),
('entry_date', models.DateTimeField(auto_now_add=True, verbose_name='入库时间')),
('update_time', models.DateTimeField(auto_now=True, null=True, verbose_name='更新时间')),
('company', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, to='ic_shop.Company', verbose_name='所属公司')),
],
options={
'verbose_name': '公司设备升级包',
'verbose_name_plural': '公司设备升级包',
},
),
migrations.CreateModel(
name='CompanyType',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('type', models.IntegerField(default=0, validators=[django.core.validators.MaxValueValidator(3), django.core.validators.MinValueValidator(0)], verbose_name=' 0：未知，1：厂家，2：经销商, 3: 总公司 ')),
('name', models.CharField(default='', max_length=20, null=True, verbose_name='类型名称')),
('describe', models.CharField(default='', max_length=200, null=True, verbose_name='类型描述')),
],
options={
'verbose_name': '公司类型',
'verbose_name_plural': '公司类型',
},
),
migrations.CreateModel(
name='Device',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('name', models.CharField(default='小卧智能冰糕机2型', max_length=1024, null=True, verbose_name='设备名称')),
('img', models.FileField(blank=True, null=True, upload_to=ic_shop.models.Device.get_device_path)),
('description', models.TextField(blank=True, default='', max_length=1024, verbose_name='描述')),
('deviceSn', models.CharField(error_messages={'unique': '设备SN已经存在'}, help_text='设备sn', max_length=50, unique=True, verbose_name='设备SN')),
('appVersion', models.CharField(default='', max_length=50, null=True, verbose_name='app版本')),
('androidVersion', models.CharField(default='', max_length=50, null=True, verbose_name='安卓系统版本')),
('deviceVersion', models.CharField(default='', max_length=50, null=True, verbose_name='下位机固件版本')),
('settingTemperature', models.CharField(default='-18', max_length=50, null=True, verbose_name='设定温度')),
('temperature', models.CharField(default='-18', max_length=50, null=True, verbose_name='实时温度')),
('temperatureThreshold', models.CharField(blank=True, default='10', help_text='最高报警温度阈值', max_length=50, null=True, verbose_name='最高报警温度阈值')),
('entry_date', models.DateTimeField(auto_now_add=True, verbose_name='入库时间')),
('update_time', models.DateTimeField(auto_now=True, null=True, verbose_name='更新时间')),
],
options={
'verbose_name': '设备',
'verbose_name_plural': '设备',
'permissions': (('view_device', 'View device'),),
},
),
migrations.CreateModel(
name='DeviceAds',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('title', models.CharField(default='', max_length=1024, null=True, verbose_name='标题')),
('type', models.IntegerField(default=0, validators=[django.core.validators.MaxValueValidator(2), django.core.validators.MinValueValidator(0)], verbose_name='类型,0-最新动态,1-产品攻略,2-专业技能')),
('description', models.TextField(blank=True, default='', max_length=1024, verbose_name='描述')),
('content', DjangoUeditor.models.UEditorField(blank=True, default='', verbose_name='内容')),
('upload_time', models.DateTimeField(default=django.utils.timezone.now, null=True, verbose_name='上传时间')),
('refresh_time', models.DateTimeField(auto_now=True, null=True, verbose_name='更新时间')),
('read_count', models.CharField(default='0', max_length=30, verbose_name='阅读数')),
('like_count', models.CharField(default='0', max_length=30, verbose_name='点赞数')),
],
options={
'verbose_name': '资讯广告',
'verbose_name_plural': '资讯广告',
},
),
migrations.CreateModel(
name='DeviceLocationHistory',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('longitude', models.CharField(blank=True, default='', max_length=50, null=True, verbose_name='经度')),
('latitude', models.CharField(blank=True, default='', max_length=50, null=True, verbose_name='纬度')),
('provinceKey', models.CharField(default='', max_length=50, null=True, verbose_name='省份编码')),
('provinceName', models.CharField(default='', max_length=50, null=True, verbose_name='省份')),
('cityKey', models.CharField(default='', max_length=50, null=True, verbose_name='县市编码')),
('cityName', models.CharField(default='', max_length=50, null=True, verbose_name='县市')),
('regionKey', models.CharField(default='', max_length=50, null=True, verbose_name='区编码')),
('regionName', models.CharField(default='', max_length=50, null=True, verbose_name='区')),
('addressDetail', models.CharField(blank=True, default='', max_length=200, null=True, verbose_name='地址详情')),
('pub_date', models.DateTimeField(auto_now_add=True, verbose_name='发表时间')),
('update_time', models.DateTimeField(auto_now=True, null=True, verbose_name='更新时间')),
],
options={
'verbose_name': '设备历史地址',
'verbose_name_plural': '设备历史地址',
},
),
migrations.CreateModel(
name='DeviceOperationCode',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('deviceSn', models.CharField(max_length=255, verbose_name='所属设备')),
('deviceVerifyCode', models.CharField(default='', max_length=200, null=True, verbose_name='设备操作校验码')),
('codeUpdateTime', models.CharField(default='', max_length=200, null=True, verbose_name='验证码更新时间戳')),
('timeExpired', models.CharField(default='2', max_length=1024, null=True, verbose_name='检验码过期时间间隔')),
('upload_time', models.DateTimeField(auto_now=True, null=True, verbose_name='上传时间')),
],
options={
'verbose_name': '设备操作校验',
'verbose_name_plural': '商品种类',
},
),
migrations.CreateModel(
name='DeviceSlot',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('slotNum', models.IntegerField(null=True, validators=[django.core.validators.MaxValueValidator(30), django.core.validators.MinValueValidator(1)], verbose_name='设备通道序号(1-30)')),
('status', models.IntegerField(default=1, help_text='-0- 未激活, 1 - 激活, 2 - 过期, 3 - 已被使用', validators=[django.core.validators.MaxValueValidator(10), django.core.validators.MinValueValidator(0)], verbose_name='机器状态')),
('faultCode', models.CharField(blank=True, default=-1, help_text='1:正常 , 2：送料电机故障，3：顶出的电机故障，4、电动门电磁阀故障', max_length=50, null=True, verbose_name='故障状态')),
('max_capacity', models.IntegerField(null=True, validators=[django.core.validators.MaxValueValidator(30), django.core.validators.MinValueValidator(1)], verbose_name='设备通道容量(1-30)')),
],
options={
'verbose_name': '设备通道',
'verbose_name_plural': '设备通道',
'default_related_name': 'deviceSlot',
},
),
migrations.CreateModel(
name='DeviceType',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('name', models.CharField(default='', max_length=1024, null=True, verbose_name='设备型号名称')),
('description', models.TextField(blank=True, default='', verbose_name='描述')),
('pub_date', models.DateTimeField(auto_now_add=True, verbose_name='发表时间')),
('update_time', models.DateTimeField(auto_now=True, null=True, verbose_name='更新时间')),
],
options={
'verbose_name': '设备类型',
'verbose_name_plural': '设备类型',
},
),
migrations.CreateModel(
name='ImageUploader',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('img', models.FileField(upload_to='upload')),
('upload_time', models.DateTimeField(auto_now=True, null=True, verbose_name='上传时间')),
],
options={
'verbose_name': '商品图片',
'verbose_name_plural': '商品图片',
},
),
migrations.CreateModel(
name='ItemOrder',
fields=[
('orderNum', models.BigIntegerField(error_messages={'unique': '订单号重复'}, primary_key=True, serialize=False, verbose_name='订单号')),
('orderTitle', models.CharField(error_messages={'null': '需要提供商品名称或者相关标题'}, max_length=255, verbose_name='订单标题')),
('totalCount', models.IntegerField(error_messages={'null': '购买商品总数'}, verbose_name='购买商品总数')),
('actualTotalCount', models.IntegerField(default=0, error_messages={'null': '实际出货商品总数'}, verbose_name='实际出货数量')),
('totalPrize', models.FloatField(error_messages={'null': '需要提供商品总价'}, verbose_name='总价')),
('deviceSlot_id', models.CharField(error_messages={'null': '需要提供所属通道ID'}, help_text='deviceSlot_id', max_length=255, null=True)),
('pub_date', models.DateTimeField(auto_now_add=True, verbose_name='发表时间')),
('update_time', models.DateTimeField(auto_now=True, null=True, verbose_name='更新时间')),
('update_timestamp', models.BigIntegerField(verbose_name='操作时间戳')),
],
options={
'verbose_name': '商品订单',
'verbose_name_plural': '商品订单',
},
),
migrations.CreateModel(
name='ProfileAvatar',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('img', models.FileField(upload_to='upload/avatar')),
('upload_time', models.DateTimeField(auto_now=True, null=True, verbose_name='上传时间')),
('user', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)),
],
options={
'verbose_name': '头像',
'verbose_name_plural': '头像',
},
),
migrations.CreateModel(
name='ProfileType',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('name', models.CharField(default='', max_length=20, verbose_name='用户类型')),
('description', models.CharField(default='', max_length=1024, verbose_name='描述')),
],
options={
'verbose_name': '用户类型',
'verbose_name_plural': '用户类型',
},
),
migrations.CreateModel(
name='ShopItem',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('title', models.CharField(default='默认', error_messages={'unique': '该商品名称已经存在'}, help_text='Required. 150 characters or fewer. Letters, digits and @/./+/-/_ only.', max_length=255, unique=True, verbose_name='商品名称')),
('description', models.CharField(blank=True, max_length=1024, verbose_name='描述')),
('content', DjangoUeditor.models.UEditorField(blank=True, default='', verbose_name='内容')),
('prize', models.FloatField(error_messages={'unique': '价格不能低于0'}, validators=[django.core.validators.MaxValueValidator(999999), django.core.validators.MinValueValidator(0)], verbose_name='价格')),
('originalPrize', models.FloatField(help_text='出厂价格', null=True, validators=[django.core.validators.MaxValueValidator(999999), django.core.validators.MinValueValidator(0)], verbose_name='出厂价格')),
('status', models.IntegerField(default=1, validators=[django.core.validators.MaxValueValidator(2), django.core.validators.MinValueValidator(0)], verbose_name='-0- 未激活, 1 - 激活, 2 - 过期')),
('pub_date', models.DateTimeField(auto_now_add=True, verbose_name='上架时间')),
('update_time', models.DateTimeField(auto_now=True, null=True, verbose_name='更新时间')),
('img', models.FileField(blank=True, null=True, upload_to=ic_shop.models.ShopItem.get_shopItem_path)),
('brand', models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, to='ic_shop.Brand', verbose_name='所属品牌')),
],
options={
'verbose_name': '商品',
'verbose_name_plural': '商品',
},
),
migrations.CreateModel(
name='ShopItemCategory',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('name', models.CharField(default='', max_length=1024, null=True, verbose_name='商品种类名称')),
('upload_time', models.DateTimeField(auto_now=True, null=True, verbose_name='上传时间')),
],
options={
'verbose_name': '商品种类',
'verbose_name_plural': '商品种类',
},
),
migrations.CreateModel(
name='ShopItemStorage',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('currentStorage', models.CharField(max_length=50, null=True, verbose_name='当前存货量')),
('pub_date', models.DateTimeField(auto_now_add=True, verbose_name='发表时间')),
('update_time', models.DateTimeField(auto_now=True, null=True, verbose_name='更新时间')),
('deviceSlot', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='deviceSlots', to='ic_shop.DeviceSlot', verbose_name='所属通道')),
('shopItem', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='shopItems', to='ic_shop.ShopItem', verbose_name='冰糕')),
],
options={
'verbose_name': '设备商品存货',
'verbose_name_plural': '设备商品存货',
},
),
migrations.CreateModel(
name='ShopItemStorageHistory',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('device_id', models.CharField(max_length=50, null=True, verbose_name='所属设备id')),
('pre_shopItem_id', models.CharField(max_length=50, null=True, verbose_name='之前商品ID')),
('user_id', models.CharField(max_length=50, null=True, verbose_name='操作员ID')),
('pre_currentStorage', models.CharField(max_length=50, null=True, verbose_name='更新之前存货量')),
('currentStorage', models.CharField(max_length=50, null=True, verbose_name='当前存货量')),
('update_timestamp', models.BigIntegerField(default=0, verbose_name='操作时间戳')),
('pub_date', models.DateTimeField(auto_now_add=True, verbose_name='发表时间')),
('update_time', models.DateTimeField(auto_now=True, null=True, verbose_name='更新时间')),
('deviceSlot', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='ic_shop.DeviceSlot', verbose_name='所属通道')),
('shopItem', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='ic_shop.ShopItem', verbose_name='冰糕')),
],
options={
'verbose_name': '设备商品存货历史记录',
'verbose_name_plural': '设备商品存货历史记录',
},
),
migrations.CreateModel(
name='Tag',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('title', models.CharField(error_messages={'unique': 'A title with that tag already exists.'}, help_text='Required. 150 characters or fewer. Letters, digits and @/./+/-/_ only.', max_length=150, unique=True, verbose_name='标签名称')),
('description', models.TextField(blank=True, default='', verbose_name='描述')),
],
options={
'verbose_name': '标签',
'verbose_name_plural': '标签',
},
),
migrations.CreateModel(
name='UserDevice',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
],
),
migrations.CreateModel(
name='DeviceLocation',
fields=[
('longitude', models.CharField(blank=True, default='', max_length=50, null=True, verbose_name='经度')),
('latitude', models.CharField(blank=True, default='', max_length=50, null=True, verbose_name='纬度')),
('provinceKey', models.CharField(blank=True, default='', max_length=50, null=True, verbose_name='省份编码')),
('provinceName', models.CharField(blank=True, default='', max_length=50, null=True, verbose_name='省份')),
('cityKey', models.CharField(blank=True, default='', max_length=50, null=True, verbose_name='县市编码')),
('cityName', models.CharField(blank=True, default='', max_length=50, null=True, verbose_name='县市')),
('regionKey', models.CharField(blank=True, default='', max_length=50, null=True, verbose_name='区编码')),
('regionName', models.CharField(blank=True, default='', max_length=50, null=True, verbose_name='区')),
('addressDetail', models.CharField(blank=True, default='', max_length=200, null=True, verbose_name='地址详情')),
('pub_date', models.DateTimeField(auto_now_add=True, verbose_name='发表时间')),
('update_time', models.DateTimeField(auto_now=True, null=True, verbose_name='更新时间')),
('device', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, primary_key=True, serialize=False, to='ic_shop.Device', verbose_name='所属设备')),
],
options={
'verbose_name': '设备地址',
'verbose_name_plural': '设备地址',
},
),
migrations.CreateModel(
name='DeviceMacStatus',
fields=[
('status', models.IntegerField(default=1, help_text='0：未激活状态，1：正常运作，2、用户购买中，3、补货中，4：离线状态，5：报废，', validators=[django.core.validators.MaxValueValidator(5), django.core.validators.MinValueValidator(0)], verbose_name='0：未激活状态，1：正常运作，2、用户购买中，3、补货中，4：离线状态，5：报废，')),
('faultStatus', models.IntegerField(default='1', help_text='1-:正常, 2：通道电机故障, 3：横送系统故障, 4：升降系统故障', validators=[django.core.validators.MaxValueValidator(4), django.core.validators.MinValueValidator(1)], verbose_name='1-:正常, 2：通道电机故障, 3：横送系统故障, 4：升降系统故障')),
('temperatureStatus', models.IntegerField(default='1', help_text='(高温状态) 0-异常 1-:正常', validators=[django.core.validators.MaxValueValidator(1), django.core.validators.MinValueValidator(0)], verbose_name='(高温状态) 0-异常 1-:正常')),
('republishStatus', models.IntegerField(default='1', help_text='设备补货状态码，0：无需补货，1：待补货，2：亟待补货', validators=[django.core.validators.MaxValueValidator(2), django.core.validators.MinValueValidator(0)], verbose_name='设备补货状态码，0：无需补货，1：待补货，2：亟待补货')),
('device', models.OneToOneField(help_text='device_id', on_delete=django.db.models.deletion.CASCADE, primary_key=True, serialize=False, to='ic_shop.Device', verbose_name='所属设备')),
],
options={
'verbose_name': '设备状态',
'verbose_name_plural': '设备状态',
},
),
migrations.CreateModel(
name='ItemOrderStatus',
fields=[
('orderStatus', models.IntegerField(default=0, help_text='0- 等待支付中, 1 - 已支付, 2 - 已取消, 3 - 未付款交易超时关闭，或支付完成后全额退款, 4 - 退款中 5- 该订单未被扫描 6- 交易结束，不可退款 ', null=True, validators=[django.core.validators.MaxValueValidator(6), django.core.validators.MinValueValidator(0)], verbose_name='0- 等待支付中, 1 - 已支付, 2 - 已取消, 3 - 未付款交易超时关闭，或支付完成后全额退款, 4 - 退款中 5- 该订单未被扫描 6- 交易结束，不可退款 ')),
('pub_date', models.DateTimeField(auto_now_add=True, null=True, verbose_name='发表时间')),
('update_time', models.DateTimeField(auto_now=True, null=True, verbose_name='更新时间')),
('update_timestamp', models.BigIntegerField(null=True, verbose_name='操作时间戳')),
('buyer_user_id', models.CharField(blank=True, help_text='支付宝用户ID, 默认生成, 无需填写', max_length=255, null=True)),
('buyer_logon_id', models.CharField(blank=True, help_text='支付宝用户登录ID, 默认生成, 无需填写', max_length=255, null=True)),
('company_id', models.IntegerField(blank=True, help_text='公司ID', null=True)),
('orderNum', models.OneToOneField(default=1, error_messages={'null': '需要提供该订单的商品ID'}, help_text='itemOrder_id', on_delete=django.db.models.deletion.CASCADE, primary_key=True, serialize=False, to='ic_shop.ItemOrder', verbose_name='所属订单')),
('orderCompleteStatus', models.IntegerField(default=0, help_text='0 - 未出货, 1 -已出货 2-部分出货', null=True, validators=[django.core.validators.MaxValueValidator(2), django.core.validators.MinValueValidator(0)], verbose_name='0 - 未出货 1 - 已出货 2-部分出货')),
],
options={
'verbose_name': '订单状态',
'verbose_name_plural': '订单状态',
},
),
migrations.AddField(
model_name='userdevice',
name='device',
field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='devices', to='ic_shop.Device', verbose_name='设备'),
),
migrations.AddField(
model_name='userdevice',
name='user',
field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='profiles', to=settings.AUTH_USER_MODEL, verbose_name='用户'),
),
migrations.AddField(
model_name='shopitem',
name='category',
field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, to='ic_shop.ShopItemCategory', verbose_name='商品种类'),
),
migrations.AddField(
model_name='itemorder',
name='company',
field=models.ForeignKey(error_messages={'null': '需要提供公司ID'}, help_text='company_id', null=True, on_delete=django.db.models.deletion.CASCADE, to='ic_shop.Company', verbose_name='所属公司'),
),
migrations.AddField(
model_name='itemorder',
name='device',
field=models.ForeignKey(error_messages={'null': '需要提供所属设备ID'}, help_text='device_id', null=True, on_delete=django.db.models.deletion.CASCADE, to='ic_shop.Device'),
),
migrations.AddField(
model_name='itemorder',
name='shopItem',
field=models.ForeignKey(error_messages={'null': '需要提供该订单的商品ID'}, help_text='shopItem_id', null=True, on_delete=django.db.models.deletion.CASCADE, to='ic_shop.ShopItem', verbose_name='所属商品'),
),
migrations.AddField(
model_name='imageuploader',
name='shopItem',
field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='ic_shop.ShopItem'),
),
migrations.AddField(
model_name='deviceslot',
name='device',
field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='deviceSlot', to='ic_shop.Device', verbose_name='设备'),
),
migrations.AddField(
model_name='deviceslot',
name='shopItem',
field=models.ManyToManyField(related_name='deviceSlot', through='ic_shop.ShopItemStorage', to='ic_shop.ShopItem', verbose_name='冰糕'),
),
migrations.AlterUniqueTogether(
name='deviceoperationcode',
unique_together=set([('deviceSn', 'deviceVerifyCode')]),
),
migrations.AddField(
model_name='devicelocationhistory',
name='device',
field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='ic_shop.Device', verbose_name='所属设备'),
),
migrations.AddField(
model_name='device',
name='company',
field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to='ic_shop.Company', verbose_name='所属公司'),
),
migrations.AddField(
model_name='device',
name='deviceType',
field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to='ic_shop.DeviceType', verbose_name='所属设备类型'),
),
migrations.AddField(
model_name='device',
name='operator',
field=models.ManyToManyField(blank=True, through='ic_shop.UserDevice', to=settings.AUTH_USER_MODEL, verbose_name='设备'),
),
migrations.AddField(
model_name='company',
name='type',
field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='ic_shop.CompanyType', verbose_name='公司类型'),
),
migrations.AddField(
model_name='comment',
name='shopItem',
field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='ic_shop.ShopItem', verbose_name='所属商品'),
),
migrations.AddField(
model_name='comment',
name='user',
field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL, verbose_name='所属用户'),
),
migrations.AddField(
model_name='profile',
name='company',
field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, to='ic_shop.Company', verbose_name='所属公司'),
),
migrations.AddField(
model_name='profile',
name='groups',
field=models.ManyToManyField(blank=True, help_text='The groups this user belongs to. A user will get all permissions granted to each of their groups.', related_name='user_set', related_query_name='user', to='auth.Group', verbose_name='groups'),
),
migrations.AddField(
model_name='profile',
name='supervisor',
field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL, verbose_name='上级用户'),
),
migrations.AddField(
model_name='profile',
name='userType',
field=models.ForeignKey(blank=True, default='', null=True, on_delete=django.db.models.deletion.CASCADE, to='ic_shop.ProfileType', verbose_name='用户类型'),
),
migrations.AddField(
model_name='profile',
name='user_permissions',
field=models.ManyToManyField(blank=True, help_text='Specific permissions for this user.', related_name='user_set', related_query_name='user', to='auth.Permission', verbose_name='user permissions'),
),
migrations.AlterUniqueTogether(
name='userdevice',
unique_together=set([('device', 'user')]),
),
migrations.AlterUniqueTogether(
name='deviceslot',
unique_together=set([('device', 'slotNum')]),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = []
operations = [
migrations.CreateModel(
name='GoodCategoryBrand',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name',
models.CharField(default='',
help_text='品牌名',
max_length=50,
verbose_name='品牌名')),
('desc',
models.TextField(default='',
help_text='品牌描述',
max_length=300,
verbose_name='品牌描述')),
('image',
models.DateField(default=datetime.datetime.now,
verbose_name='添加時間')),
('is_delete',
models.BooleanField(default=False, verbose_name='使否刪除')),
],
options={
'verbose_name': '品牌',
'verbose_name_plural': '品牌',
},
),
migrations.CreateModel(
name='Goods',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('goods_sh',
models.CharField(default='',
max_length=50,
verbose_name='商品唯一編號')),
('name', models.CharField(max_length=300, verbose_name='商品名')),
('click_num', models.IntegerField(default=0,
verbose_name='點擊量')),
('sold_num', models.IntegerField(default=0,
verbose_name='銷售量')),
('fav_num', models.IntegerField(default=0,
verbose_name='收藏量')),
('goods_num', models.IntegerField(default=0,
verbose_name='庫存量')),
('shop_price', models.FloatField(default=0,
verbose_name='本店價格')),
('goods_brief',
models.TextField(max_length=500, verbose_name='商品簡介')),
('goods_desc',
DjangoUeditor.models.UEditorField(default='',
verbose_name='內容')),
('ship_free',
models.BooleanField(default=True, verbose_name='是否承擔運費')),
('goods_front_image',
models.ImageField(blank=True,
null=True,
upload_to='goods/images/',
verbose_name='封面圖')),
('is_new',
models.BooleanField(default=False, verbose_name='是否新品')),
('is_home',
models.BooleanField(default=False, verbose_name='是否熱銷')),
('add_time',
models.DateField(default=datetime.datetime.now,
verbose_name='添加時間')),
('is_delete',
models.BooleanField(default=False, verbose_name='是否刪除')),
],
),
migrations.CreateModel(
name='GoodsImage',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('image',
models.ImageField(blank=True,
null=True,
upload_to='',
verbose_name='圖片')),
('image_url',
models.CharField(blank=True,
max_length=300,
null=True,
verbose_name='圖片連接')),
('add_time',
models.DateField(default=datetime.datetime.now,
verbose_name='添加時間')),
('is_delete',
models.BooleanField(default=False, verbose_name='是否刪除')),
('goods',
models.ForeignKey(
null=True,
on_delete=django.db.models.deletion.SET_NULL,
related_name='商品',
to='goods.goods',
verbose_name='')),
],
options={
'verbose_name': '商品輪播圖',
'verbose_name_plural': '商品輪播圖',
},
),
migrations.CreateModel(
name='GoodsCategory',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name',
models.CharField(default='',
help_text='類別名',
max_length=30,
verbose_name='類別名')),
('code',
models.CharField(default='',
help_text='類別code',
max_length=30,
verbose_name='類別code')),
('desc',
models.TextField(default='',
help_text='類別描述',
verbose_name='類別描述')),
('category_type',
models.IntegerField(choices=[(1, '一級類目 '), (2, '二級類目 '),
(3, '三級類目 ')],
help_text='類目級別',
verbose_name='類目級別')),
('is_tab',
models.BooleanField(default=False,
help_text='是否導航',
verbose_name='是否導航')),
('is_delete',
models.BooleanField(default=False, verbose_name='是否刪除')),
('parent_category',
models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.SET_NULL,
related_name='sub_cat',
to='goods.goodscategory',
verbose_name='父類別')),
],
options={
'verbose_name': '商品類別',
'verbose_name_plural': '商品類別',
},
),
migrations.AddField(
model_name='goods',
name='category',
field=models.ForeignKey(
null=True,
on_delete=django.db.models.deletion.SET_NULL,
to='goods.goodscategory',
verbose_name='商品類目'),
),
migrations.CreateModel(
name='Banner',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('image',
models.ImageField(upload_to='banner', verbose_name='輪播圖片')),
('index', models.IntegerField(default=0, verbose_name='輪播順序')),
('add_time',
models.DateField(default=datetime.datetime.now,
verbose_name='添加時間')),
('is_delete',
models.BooleanField(default=False, verbose_name='是否刪除')),
('goods',
models.ForeignKey(
null=True,
on_delete=django.db.models.deletion.SET_NULL,
to='goods.goods',
verbose_name='商品')),
],
options={
'verbose_name': '輪播商品',
'verbose_name_plural': '輪播商品',
},
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
]
operations = [
migrations.CreateModel(
name='Store2User',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('create_time', models.DateTimeField(auto_now_add=True, verbose_name='创建时间')),
('update_time', models.DateTimeField(auto_now=True, verbose_name='更新时间')),
('store_water_num', models.IntegerField(blank=True, null=True, verbose_name='流水编号')),
('store_source', models.IntegerField(blank=True, choices=[(0, '洗车'), (1, '活动'), (2, '提现'), (3, '核销')], null=True, verbose_name='来源')),
('store_money', models.PositiveIntegerField(blank=True, null=True, verbose_name='交易金额(单位分)')),
('user_water_num', models.IntegerField(blank=True, null=True, verbose_name='流水编号')),
('user_source', models.IntegerField(blank=True, choices=[(0, '洗车'), (1, '活动'), (2, '充值')], null=True, verbose_name='来源')),
('user_money', models.PositiveIntegerField(blank=True, null=True, verbose_name='交易金额(单位分)')),
],
options={
'verbose_name': '商家/用户钱包流水',
'verbose_name_plural': '商家/用户钱包流水',
'db_table': 'StoreWallet',
},
),
migrations.CreateModel(
name='StoreManage',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('create_time', models.DateTimeField(auto_now_add=True, verbose_name='创建时间')),
('update_time', models.DateTimeField(auto_now=True, verbose_name='更新时间')),
('linkman', models.CharField(blank=True, max_length=20, null=True, verbose_name='联系人姓名')),
('store_name', models.CharField(blank=True, max_length=20, null=True, verbose_name='店名')),
('store_add', models.CharField(max_length=100, verbose_name='店铺地址')),
('up_five_price', models.DecimalField(decimal_places=2, max_digits=10, verbose_name='5座以上价格')),
('low_five_price', models.DecimalField(decimal_places=2, max_digits=10, verbose_name='5座以下价格')),
('service', models.CharField(choices=[('标准洗车', 0), ('精致洗车', 1)], max_length=4, verbose_name='服务内容选择')),
('graded', models.CharField(blank=True, max_length=5, null=True, verbose_name='评分')),
('area', models.CharField(blank=True, max_length=20, null=True, verbose_name='区域')),
('location', models.CharField(blank=True, max_length=100, null=True, verbose_name='定位')),
('office_hours', models.TimeField(blank=True, null=True, verbose_name='上班时间')),
('closing_time', models.TimeField(blank=True, null=True, verbose_name='下班时间')),
('commission_rate', models.DecimalField(decimal_places=4, max_digits=5, verbose_name='佣金比例')),
('account', models.CharField(max_length=50, verbose_name='账号')),
('password', models.CharField(blank=True, max_length=20, null=True, verbose_name='密码')),
('bank_num', models.IntegerField(blank=True, null=True, verbose_name='银行卡号')),
('cardholder', models.CharField(blank=True, max_length=20, null=True, verbose_name='持卡人')),
('belong_bank', models.CharField(blank=True, max_length=100, null=True, verbose_name='所属银行')),
('service_content', models.TextField(blank=True, null=True, verbose_name='服务内容')),
('phone', models.CharField(blank=True, max_length=11, null=True, verbose_name='联系电话')),
('logo', models.ImageField(blank=True, null=True, upload_to='media/store/logo', verbose_name='店铺的logo')),
('store_img', models.ImageField(blank=True, null=True, upload_to='media/store', verbose_name='店铺图片')),
('detail', DjangoUeditor.models.UEditorField(default='', verbose_name='门店详情')),
('audit_status', models.IntegerField(choices=[(0, '通过审核'), (1, '未通过审核')], default='未通过审核', verbose_name='审核状态')),
('status', models.SmallIntegerField(choices=[(1, '空闲'), (2, '忙碌'), (3, '休息')], default=1, verbose_name='商家状态')),
('shop_lon', models.FloatField(blank=True, null=True, verbose_name='店铺经度')),
('shop_lat', models.FloatField(blank=True, null=True, verbose_name='店铺维度')),
('all_service_charge', models.PositiveIntegerField(blank=True, null=True, verbose_name='总手续费(单位分)')),
('balance', models.PositiveIntegerField(blank=True, null=True, verbose_name='余额(单位分)')),
('sub_store_manager', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to='store.StoreManage', verbose_name='子账户')),
],
options={
'verbose_name': '门店',
'verbose_name_plural': '门店',
'db_table': 'store',
},
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
]
operations = [
migrations.CreateModel(
name='task',
fields=[
('task_id', models.AutoField(primary_key=True,
serialize=False)),
('task_title',
models.CharField(max_length=30, verbose_name='任务标题')),
('task_desc',
DjangoUeditor.models.UEditorField(default='',
verbose_name='任务详情')),
('task_price',
models.FloatField(default=0.0, verbose_name='任务价格')),
('task_status',
models.CharField(choices=[('0', '任务已取消'), ('1', '任务等待接受'),
('2', '任务已接受'), ('3', '已完成任务'),
('4', '任务超出截止日期'), ('5', '待审核任务')],
max_length=10,
verbose_name='任务状态')),
('task_type',
models.BooleanField(default=False,
verbose_name='接受任务或者发布任务')),
('task_deposit', models.IntegerField(verbose_name='任务押金金额')),
('task_deposit_status',
models.IntegerField(verbose_name='任务押金状态')),
('task_updateTime',
models.DateTimeField(auto_now=True, verbose_name='任务最近更新时间')),
('task_releaseTime',
models.DateTimeField(auto_now_add=True,
verbose_name='任务发布时间')),
('task_receiveTime',
models.DateTimeField(default=django.utils.timezone.now,
verbose_name='任务领取时间')),
('task_deadline',
models.DateTimeField(default=django.utils.timezone.now,
verbose_name='任务截止时间')),
('task_extra', models.TextField(verbose_name='任务备注')),
('task_user',
models.ManyToManyField(blank=True,
to=settings.AUTH_USER_MODEL,
verbose_name='任务用户')),
],
options={
'verbose_name': '任务',
'verbose_name_plural': '任务',
'db_table': 'fb_task',
},
),
migrations.CreateModel(
name='task_media',
fields=[
('task_mediaId',
models.AutoField(primary_key=True, serialize=False)),
('task_mediaurl',
models.ImageField(blank=True,
default='task_media/default.jpg',
null=True,
upload_to='task_media/',
verbose_name='任务媒体资源')),
('task_index', models.IntegerField(verbose_name='任务媒体索引')),
('task_id',
models.ForeignKey(blank=True,
null=True,
on_delete=django.db.models.deletion.CASCADE,
related_name='task_media',
to='task.task',
verbose_name='所属任务id')),
],
options={
'verbose_name': '任务媒体',
'verbose_name_plural': '任务媒体',
'db_table': 'fb_task_media',
},
),
]
class Migration(migrations.Migration):
initial = True
dependencies = []
operations = [
migrations.CreateModel(
name='Goods',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('goods_sn',
models.CharField(max_length=50,
unique=True,
verbose_name='商品唯一货号')),
('name', models.CharField(max_length=300, verbose_name='商品名')),
('click_num', models.IntegerField(default=0,
verbose_name='点击数')),
('sold_num', models.IntegerField(default=0,
verbose_name='销量')),
('goods_num', models.IntegerField(default=0,
verbose_name='库存')),
('market_price',
models.FloatField(default=99999, verbose_name='市场价')),
('shop_price',
models.FloatField(default=99999, verbose_name='售价')),
('goods_brief',
models.TextField(max_length=500, verbose_name='商品简述')),
('goods_desc',
DjangoUeditor.models.UEditorField(default='',
verbose_name='商品描述')),
('ship_free',
models.IntegerField(default=99999, verbose_name='邮费')),
('good_front_image',
models.ImageField(blank=True,
null=True,
upload_to='front_image',
verbose_name='封面图')),
('is_hot',
models.BooleanField(default=False, verbose_name='是否热销')),
('is_new',
models.BooleanField(default=False, verbose_name='是否新品')),
('create_at',
models.DateTimeField(auto_now_add=True, verbose_name='创建时间')),
('update_at',
models.DateTimeField(auto_now=True, verbose_name='更新时间')),
],
options={
'verbose_name': '商品',
'verbose_name_plural': '商品',
},
),
migrations.CreateModel(
name='GoodsCategoryBrand',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=20, verbose_name='品牌名')),
('desc', models.TextField(default='', verbose_name='品牌描述')),
('image', models.ImageField(upload_to='brand/')),
('create_at',
models.DateTimeField(auto_now_add=True, verbose_name='创建时间')),
('update_at',
models.DateTimeField(auto_now=True, verbose_name='更新时间')),
],
options={
'verbose_name': '品牌',
'verbose_name_plural': '品牌',
},
),
migrations.CreateModel(
name='GoodsImage',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('image', models.ImageField(upload_to='goodsImage/')),
('create_at',
models.DateTimeField(auto_now_add=True, verbose_name='创建时间')),
('update_at',
models.DateTimeField(auto_now=True, verbose_name='更新时间')),
('good',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='goods.Goods')),
],
options={
'verbose_name': '商品图片',
'verbose_name_plural': '商品图片',
},
),
migrations.CreateModel(
name='GoodsCategory',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name',
models.CharField(help_text='类别名',
max_length=30,
verbose_name='类别名')),
('code',
models.CharField(default='',
max_length=30,
verbose_name='类别代码')),
('desc',
models.TextField(default='',
help_text='类别描述',
verbose_name='类别描述')),
('category_type',
models.IntegerField(choices=[(1, '一级类目'), (2, '二级类目'),
(3, '三级类目')],
help_text='类目级别',
verbose_name='类目级别')),
('is_tab',
models.BooleanField(default=False, verbose_name='是否导航')),
('create_at',
models.DateTimeField(auto_now_add=True, verbose_name='创建时间')),
('update_at',
models.DateTimeField(auto_now=True, verbose_name='更新时间')),
('parent_category',
models.ForeignKey(blank=True,
null=True,
on_delete=django.db.models.deletion.CASCADE,
related_name='sub_cat',
to='goods.GoodsCategory',
verbose_name='父类别')),
],
options={
'verbose_name': '商品类别',
'verbose_name_plural': '商品类别',
},
),
migrations.AddField(
model_name='goods',
name='category',
field=models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.SET_NULL,
to='goods.GoodsCategory',
verbose_name='商品类别'),
),
migrations.CreateModel(
name='Banner',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('image',
models.ImageField(upload_to='banner/', verbose_name='轮播图')),
('index', models.IntegerField(default=0, verbose_name='轮播顺序')),
('create_at',
models.DateTimeField(auto_now_add=True, verbose_name='创建时间')),
('update_at',
models.DateTimeField(auto_now=True, verbose_name='更新时间')),
('goods',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='goods.Goods',
verbose_name='商品')),
],
options={
'verbose_name': '轮播图',
'verbose_name_plural': '轮播图',
},
),
]
class Migration(migrations.Migration):
initial = True
dependencies = []
operations = [
migrations.CreateModel(
name='Banner',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('image',
models.ImageField(upload_to='banner', verbose_name='轮播图')),
('index', models.IntegerField(default=0, verbose_name='轮播顺序')),
('add_time',
models.DateTimeField(auto_now_add=True, verbose_name='添加时间')),
],
options={
'verbose_name': '轮播商品',
'verbose_name_plural': '轮播商品',
},
),
migrations.CreateModel(
name='Goods',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('good_sn',
models.CharField(default='',
help_text='商品编号',
max_length=30,
verbose_name='商品编号')),
('name', models.CharField(max_length=300,
verbose_name='商品名称')),
('click_num',
models.IntegerField(default=0, verbose_name='商品点击量')),
('sold_num',
models.IntegerField(default=0, verbose_name='商品销售量')),
('fav_num', models.IntegerField(default=0,
verbose_name='商品收藏量')),
('goods_num', models.IntegerField(default=0,
verbose_name='库存量')),
('market_price',
models.FloatField(default=0, verbose_name='市场价格')),
('shop_price', models.FloatField(default=0,
verbose_name='本店价格')),
('goods_brief',
models.TextField(max_length=500, verbose_name='商品简介')),
('goods_desc',
DjangoUeditor.models.UEditorField(default='',
verbose_name='内容')),
('ship_free',
models.BooleanField(default=True, verbose_name='是否承担运费')),
('goods_front_image',
models.ImageField(blank=True,
null=True,
upload_to='',
verbose_name='封面图')),
('is_new',
models.BooleanField(default=False, verbose_name='是否新品')),
('is_hot',
models.BooleanField(default=False, verbose_name='是否新品')),
('add_time',
models.DateTimeField(auto_now_add=True, verbose_name='添加时间')),
],
options={
'verbose_name': '商品信息',
'verbose_name_plural': '商品信息',
},
),
migrations.CreateModel(
name='GoodsCategory',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name',
models.CharField(default='',
help_text='类别名',
max_length=30,
verbose_name='类别名')),
('code',
models.CharField(default='',
help_text='类别编号',
max_length=30,
verbose_name='类别编号')),
('desc',
models.TextField(default='',
help_text='类别描述',
verbose_name='类别描述')),
('category_type',
models.IntegerField(choices=[(2, '二级目录'), (1, '一级目录'),
(3, '三级目录')],
default=1,
help_text='类型级别',
verbose_name='类型级别')),
('is_tab',
models.BooleanField(default=False,
help_text='是否导航',
verbose_name='是否导航')),
('add_time',
models.DateTimeField(auto_now_add=True, verbose_name='添加时间')),
('parent_categorry',
models.ForeignKey(blank=True,
help_text='父类类型',
null=True,
on_delete=django.db.models.deletion.CASCADE,
to='goods.GoodsCategory',
verbose_name='父类类型')),
],
options={
'verbose_name': '商品类型',
'verbose_name_plural': '商品类型',
},
),
migrations.CreateModel(
name='GoodsCategoryBrand',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name',
models.CharField(default='',
help_text='品牌名',
max_length=30,
verbose_name='品牌名')),
('desc',
models.TextField(default='',
help_text='品牌描述',
max_length=200,
verbose_name='品牌描述')),
('image',
models.ImageField(max_length=200, upload_to='brand/imgaes')),
('add_time',
models.DateTimeField(auto_now_add=True, verbose_name='添加时间')),
],
options={
'verbose_name': '品牌',
'verbose_name_plural': '品牌',
},
),
migrations.CreateModel(
name='GoodsImage',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('image',
models.ImageField(blank=True,
null=True,
upload_to='',
verbose_name='图片')),
('image_url',
models.CharField(blank=True,
max_length=300,
null=True,
verbose_name='图片Url')),
('add_time',
models.DateTimeField(auto_now_add=True, verbose_name='添加时间')),
('goods',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='images',
to='goods.Goods',
verbose_name='商品')),
],
options={
'verbose_name': '商品图片',
'verbose_name_plural': '商品图片',
},
),
migrations.AddField(
model_name='goods',
name='category',
field=models.ForeignKey(
blank=True,
help_text='商品类型',
null=True,
on_delete=django.db.models.deletion.CASCADE,
to='goods.GoodsCategory',
verbose_name='商品类型'),
),
migrations.AddField(
model_name='banner',
name='goods',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to='goods.Goods',
verbose_name='轮播的商品'),
),
]
class Migration(migrations.Migration):
dependencies = [
('smartpipe', '0001_initial'),
]
operations = [
migrations.AddField(
model_name='smartpipe',
name='accident_date',
field=models.DateTimeField(blank=True,
default=datetime.datetime.now,
null=True,
verbose_name='处理完成时间'),
),
migrations.AddField(
model_name='smartpipe',
name='accident_hand',
field=models.CharField(blank=True,
max_length=500,
null=True,
verbose_name='工单处理情况描述'),
),
migrations.AddField(
model_name='smartpipe',
name='accident_pic',
field=models.CharField(blank=True,
max_length=200,
null=True,
verbose_name='工单处理图片上传'),
),
migrations.AddField(
model_name='smartpipe',
name='accident_result',
field=models.CharField(blank=True,
max_length=50,
null=True,
verbose_name='处理结果（已完成、取消、未完成）'),
),
migrations.AddField(
model_name='smartpipe',
name='accident_star',
field=models.CharField(blank=True,
max_length=50,
null=True,
verbose_name='处理评级（1星—5星）'),
),
migrations.AddField(
model_name='smartpipe',
name='address',
field=models.CharField(blank=True,
max_length=300,
null=True,
verbose_name='地址'),
),
migrations.AddField(
model_name='smartpipe',
name='alert_date',
field=models.DateTimeField(blank=True,
default=datetime.datetime.now,
null=True,
verbose_name='告警时间'),
),
migrations.AddField(
model_name='smartpipe',
name='alert_hand',
field=DjangoUeditor.models.UEditorField(blank=True,
default='',
null=True,
verbose_name='详细描述'),
),
migrations.AddField(
model_name='smartpipe',
name='alert_id',
field=models.CharField(
blank=True,
max_length=40,
null=True,
verbose_name='关联告警事务 '),
),
migrations.AddField(
model_name='smartpipe',
name='alert_result',
field=models.CharField(blank=True,
max_length=50,
null=True,
verbose_name='告警解决情况（已完成、取消、未完成）'),
),
migrations.AddField(
model_name='smartpipe',
name='alert_type',
field=models.CharField(blank=True,
max_length=50,
null=True,
verbose_name='告警类型'),
),
migrations.AddField(
model_name='smartpipe',
name='collection_time',
field=models.DateTimeField(blank=True,
default=datetime.datetime.now,
null=True,
verbose_name='采集时间'),
),
migrations.AddField(
model_name='smartpipe',
name='concact',
field=models.CharField(blank=True,
max_length=100,
null=True,
verbose_name='联系人'),
),
migrations.AddField(
model_name='smartpipe',
name='contract',
field=models.CharField(blank=True,
max_length=100,
null=True,
verbose_name='联系人'),
),
migrations.AddField(
model_name='smartpipe',
name='design_id',
field=models.CharField(blank=True,
max_length=40,
null=True,
verbose_name='编号'),
),
migrations.AddField(
model_name='smartpipe',
name='email',
field=models.CharField(blank=True,
max_length=100,
null=True,
verbose_name='email'),
),
migrations.AddField(
model_name='smartpipe',
name='info',
field=DjangoUeditor.models.UEditorField(blank=True,
default='',
null=True,
verbose_name='设计院信息'),
),
migrations.AddField(
model_name='smartpipe',
name='ins_flow',
field=models.FloatField(blank=True, null=True,
verbose_name='瞬间流量'),
),
migrations.AddField(
model_name='smartpipe',
name='msg_info',
field=models.CharField(blank=True,
max_length=500,
null=True,
verbose_name='消息内容'),
),
migrations.AddField(
model_name='smartpipe',
name='msg_time',
field=models.DateTimeField(blank=True,
default=datetime.datetime.now,
null=True,
verbose_name='消息时间'),
),
migrations.AddField(
model_name='smartpipe',
name='name',
field=models.CharField(blank=True,
max_length=100,
null=True,
verbose_name='名称'),
),
migrations.AddField(
model_name='smartpipe',
name='order_p',
field=models.CharField(blank=True,
max_length=40,
null=True,
verbose_name='安排人员'),
),
migrations.AddField(
model_name='smartpipe',
name='phone_no',
field=models.CharField(blank=True,
max_length=50,
null=True,
verbose_name='手机'),
),
migrations.AddField(
model_name='smartpipe',
name='pipe_id',
field=models.CharField(blank=True,
max_length=40,
null=True,
verbose_name='关联管件'),
),
migrations.AddField(
model_name='smartpipe',
name='po_info',
field=models.CharField(blank=True,
max_length=500,
null=True,
verbose_name='订单描述'),
),
migrations.AddField(
model_name='smartpipe',
name='power',
field=models.FloatField(blank=True, null=True,
verbose_name='电力情况'),
),
migrations.AddField(
model_name='smartpipe',
name='pressure',
field=models.FloatField(blank=True, null=True, verbose_name='压力'),
),
migrations.AddField(
model_name='smartpipe',
name='reason',
field=models.CharField(blank=True,
max_length=500,
null=True,
verbose_name='告警依据'),
),
migrations.AddField(
model_name='smartpipe',
name='reg_date',
field=models.DateTimeField(blank=True,
default=datetime.datetime.now,
null=True,
verbose_name='注册时间'),
),
migrations.AddField(
model_name='smartpipe',
name='tot_flow',
field=models.FloatField(blank=True, null=True,
verbose_name='累计流量'),
),
migrations.AddField(
model_name='smartpipe',
name='turnup_date',
field=models.DateTimeField(blank=True,
default=datetime.datetime.now,
null=True,
verbose_name='到场时间'),
),
migrations.AddField(
model_name='smartpipe',
name='turnup_lat',
field=models.CharField(blank=True,
max_length=40,
null=True,
verbose_name='到场打卡纬度'),
),
migrations.AddField(
model_name='smartpipe',
name='turnup_lon',
field=models.CharField(blank=True,
max_length=40,
null=True,
verbose_name='到场打卡经度'),
),
migrations.AddField(
model_name='smartpipe',
name='wx',
field=models.CharField(blank=True,
max_length=100,
null=True,
verbose_name='微信名'),
),
migrations.AlterField(
model_name='smartpipe',
name='latitude',
field=models.CharField(blank=True,
max_length=40,
null=True,
verbose_name='维度'),
),
migrations.AlterField(
model_name='smartpipe',
name='longitude',
field=models.CharField(blank=True,
max_length=40,
null=True,
verbose_name='经度'),
),
migrations.AlterField(
model_name='smartpipe',
name='owner_id',
field=models.CharField(blank=True,
max_length=40,
null=True,
verbose_name='业主编号'),
),
migrations.AlterField(
model_name='smartpipe',
name='project_id',
field=models.CharField(blank=True,
max_length=40,
null=True,
verbose_name='编号'),
),
migrations.AlterField(
model_name='smartpipe',
name='vendor_id',
field=models.CharField(blank=True,
max_length=40,
null=True,
verbose_name='编号'),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = []
operations = [
migrations.CreateModel(
name='Course',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name',
models.CharField(help_text='课程名',
max_length=50,
verbose_name='课程名')),
('desc',
models.CharField(help_text='课程简短描述',
max_length=300,
verbose_name='课程简短描述')),
('detail',
DjangoUeditor.models.UEditorField(default='',
help_text='课程详情',
verbose_name='课程详情')),
('url',
models.CharField(default='',
help_text='课程介绍视频地址',
max_length=200,
verbose_name='课程介绍视频地址')),
('degree',
models.IntegerField(choices=[
(1, '1年级'), (2, '2年级'), (3, '3年级'),
(4, '4年级'), (5, '5年级'), (6, '6年级'), (7, '初一'), (8, '初二'),
(9, '初三'), (10, '高一'), (11, '高二'), (12, '高三'), (13, '大一'),
(14, '大二'), (15, '大三'), (16, '大四'), (17, '成人')
],
default=3,
help_text='难度',
verbose_name='难度')),
('learn_times',
models.IntegerField(default=0,
help_text='学习时长(分钟)',
verbose_name='学习时长(分钟)')),
('students',
models.IntegerField(default=0,
help_text='学习人数',
verbose_name='学习人数')),
('fav_nums',
models.IntegerField(default=0,
help_text='收藏人数',
verbose_name='收藏人数')),
('image',
models.ImageField(help_text='封面图',
upload_to='courses/%Y/%m',
verbose_name='封面图')),
('click_nums',
models.IntegerField(default=0,
help_text='点击数',
verbose_name='点击数')),
('category',
models.CharField(default='数字艺术',
help_text='课程类别',
max_length=20,
verbose_name='课程类别')),
('tag',
models.CharField(default='',
help_text='课程标签',
max_length=10,
verbose_name='课程标签')),
('youneed_know',
models.CharField(default='',
help_text='课程须知',
max_length=300,
verbose_name='课程须知')),
('teacher_tell',
models.CharField(default='',
help_text='能学到什么',
max_length=300,
verbose_name='能学到什么')),
('sold_num',
models.IntegerField(default=0,
help_text='已付款人数',
verbose_name='课程销量')),
('goods_sn',
models.CharField(default='',
help_text='商品唯一货号',
max_length=50,
verbose_name='课程商品唯一货号')),
('market_price',
models.FloatField(default=0,
help_text='原价',
verbose_name='市场价格')),
('shop_price',
models.FloatField(default=0,
help_text='促销价',
verbose_name='促销价')),
('is_new',
models.BooleanField(default=False,
help_text='是否新品',
verbose_name='是否新品')),
('is_hot',
models.BooleanField(default=False,
help_text='是否热销',
verbose_name='是否热销')),
('add_time',
models.DateTimeField(default=datetime.datetime.now,
help_text='添加时间',
verbose_name='添加时间')),
],
options={
'ordering': ['-id'],
'verbose_name': '课程',
'verbose_name_plural': '课程',
},
),
migrations.CreateModel(
name='CourseResource',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name',
models.CharField(help_text='资源名称',
max_length=100,
verbose_name='资源名称')),
('download',
models.FileField(help_text='资源文件',
upload_to='courses/resource/%Y/%m',
verbose_name='资源文件')),
('add_time',
models.DateTimeField(default=datetime.datetime.now,
help_text='添加时间',
verbose_name='添加时间')),
('course',
models.ForeignKey(help_text='课程',
on_delete=django.db.models.deletion.CASCADE,
to='courses.Course',
verbose_name='课程')),
],
options={
'ordering': ['-id'],
'verbose_name': '课程资源',
'verbose_name_plural': '课程资源',
},
),
migrations.CreateModel(
name='Lesson',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name',
models.CharField(help_text='章节名',
max_length=100,
verbose_name='章节名')),
('add_time',
models.DateTimeField(default=datetime.datetime.now,
help_text='添加时间',
verbose_name='添加时间')),
('course',
models.ForeignKey(help_text='课程',
on_delete=django.db.models.deletion.CASCADE,
related_name='course',
to='courses.Course',
verbose_name='课程')),
],
options={
'verbose_name': '章节',
'verbose_name_plural': '章节',
},
),
migrations.CreateModel(
name='LessonContent',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name',
models.CharField(help_text='章节内容名称',
max_length=100,
verbose_name='章节内容名称')),
('url',
models.CharField(default='',
help_text='章节内容访问地址',
max_length=200,
verbose_name='章节内容访问地址')),
('learn_times',
models.IntegerField(default=0,
help_text='学习时长(分钟)',
verbose_name='学习时长(分钟)')),
('add_time',
models.DateTimeField(default=datetime.datetime.now,
help_text='添加时间',
verbose_name='添加时间')),
('lesson',
models.ForeignKey(help_text='章节',
on_delete=django.db.models.deletion.CASCADE,
to='courses.Lesson',
verbose_name='章节')),
],
options={
'verbose_name': '章节内容',
'verbose_name_plural': '章节内容',
},
),
migrations.CreateModel(
name='Video',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name',
models.CharField(help_text='视频名',
max_length=100,
verbose_name='视频名')),
('url',
models.CharField(default='',
help_text='章节视频访问地址',
max_length=200,
verbose_name='章节视频访问地址')),
('learn_times',
models.IntegerField(default=0,
help_text='学习时长(分钟)',
verbose_name='学习时长(分钟)')),
('add_time',
models.DateTimeField(default=datetime.datetime.now,
help_text='添加时间',
verbose_name='添加时间')),
('lesson',
models.ForeignKey(help_text='章节',
on_delete=django.db.models.deletion.CASCADE,
to='courses.Lesson',
verbose_name='章节')),
],
options={
'verbose_name': '章节视频',
'verbose_name_plural': '章节视频',
},
),
]
class Migration(migrations.Migration):
initial = True
dependencies = []
operations = [
migrations.CreateModel(
name='Banner',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('image',
models.ImageField(upload_to='banner',
verbose_name='ホームページswiper用画像')),
('index',
models.IntegerField(default=0, verbose_name='swiper順番')),
('add_time',
models.DateTimeField(default=datetime.datetime.now,
verbose_name='挿入時間')),
],
options={
'verbose_name': 'swiper用の商品image',
'verbose_name_plural': 'swiper用の商品image',
},
),
migrations.CreateModel(
name='Goods',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('goods_sn',
models.CharField(default='',
max_length=50,
verbose_name='商品識別番号')),
('name', models.CharField(max_length=100, verbose_name='商品名')),
('click_num',
models.IntegerField(default=0, verbose_name='クリック数')),
('sold_num', models.IntegerField(default=0,
verbose_name='販売数')),
('fav_num',
models.IntegerField(default=0, verbose_name='お気に入り登録数')),
('goods_num', models.IntegerField(default=0,
verbose_name='在庫数')),
('market_price', models.FloatField(default=0,
verbose_name='原価')),
('shop_price', models.FloatField(default=0,
verbose_name='販売値段')),
('goods_brief',
models.TextField(max_length=500, verbose_name='商品説明')),
('goods_desc',
DjangoUeditor.models.UEditorField(default='',
verbose_name='内容')),
('ship_free',
models.BooleanField(default=True, verbose_name='送料負担')),
('goods_front_image',
models.ImageField(blank=True,
max_length=200,
null=True,
upload_to='goods/images/',
verbose_name='表紙')),
('is_new',
models.BooleanField(default=False, verbose_name='新品なのか')),
('is_hot',
models.BooleanField(default=False, verbose_name='売れているのか')),
('add_time',
models.DateTimeField(default=datetime.datetime.now,
verbose_name='挿入時間')),
],
options={
'verbose_name': '商品',
'verbose_name_plural': '商品',
},
),
migrations.CreateModel(
name='GoodsCategory',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name',
models.CharField(default='',
help_text='カテゴリー名',
max_length=50,
verbose_name='カテゴリー名')),
('code',
models.CharField(default='',
help_text='カテゴリーコード',
max_length=30,
verbose_name='カテゴリーコード')),
('desc',
models.TextField(default='',
help_text='カテゴリー説明',
verbose_name='カテゴリー説明')),
('category_type',
models.IntegerField(choices=[(1, '一級カテゴリー'), (2, '二級カテゴリー'),
(3, '三級カテゴリー')],
help_text='カテゴリーレベル',
verbose_name='カテゴリーレベル')),
('is_tab',
models.BooleanField(default=False,
help_text='ナビなのか',
verbose_name='ナビなのか')),
('add_time',
models.DateTimeField(default=datetime.datetime.now,
verbose_name='挿入時間')),
('parent_category',
models.ForeignKey(blank=True,
help_text='親カテゴリー',
null=True,
on_delete=django.db.models.deletion.CASCADE,
related_name='sub_cat',
to='goods.GoodsCategory',
verbose_name='親カテゴリー')),
],
options={
'verbose_name': '商品カテゴリー',
'verbose_name_plural': '商品カテゴリー',
},
),
migrations.CreateModel(
name='GoodsCategoryBrand',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name',
models.CharField(default='',
help_text='ブランド名',
max_length=30,
verbose_name='ブランド名')),
('desc',
models.CharField(default='',
help_text='ブランド説明',
max_length=200,
verbose_name='ブランド説明')),
('image', models.ImageField(max_length=200,
upload_to='brands/')),
('add_time',
models.DateTimeField(default=datetime.datetime.now,
verbose_name='挿入時間')),
('category',
models.ForeignKey(blank=True,
null=True,
on_delete=django.db.models.deletion.CASCADE,
related_name='brands',
to='goods.GoodsCategory',
verbose_name='商品カテゴリー名')),
],
options={
'verbose_name': 'ブランド',
'verbose_name_plural': 'ブランド',
'db_table': 'goods_goodsbrand',
},
),
migrations.CreateModel(
name='GoodsImage',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('image',
models.ImageField(blank=True,
null=True,
upload_to='',
verbose_name='画像')),
('add_time',
models.DateTimeField(default=datetime.datetime.now,
verbose_name='挿入時間')),
('goods',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='images',
to='goods.Goods',
verbose_name='商品')),
],
options={
'verbose_name': '商品swiperImages',
'verbose_name_plural': '商品swiperImages',
},
),
migrations.CreateModel(
name='HotSearchWords',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('keywords',
models.CharField(default='',
max_length=20,
verbose_name='人気キーワード')),
('index', models.IntegerField(default=0, verbose_name='並び順')),
('add_time',
models.DateTimeField(default=datetime.datetime.now,
verbose_name='挿入時間')),
],
options={
'verbose_name': '人気キーワード',
'verbose_name_plural': '人気キーワード',
},
),
migrations.CreateModel(
name='IndexAd',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('category',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='category',
to='goods.GoodsCategory',
verbose_name='商品カテゴリー')),
('goods',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='goods',
to='goods.Goods')),
],
options={
'verbose_name': 'ホームページ商品カテゴリー広告',
'verbose_name_plural': 'ホームページ商品カテゴリー広告',
},
),
migrations.AddField(
model_name='goods',
name='category',
field=models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.CASCADE,
to='goods.GoodsCategory',
verbose_name='商品カテゴリー'),
),
migrations.AddField(
model_name='banner',
name='goods',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to='goods.Goods',
verbose_name='商品'),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
('organization', '0005_auto_20200618_1426'),
]
operations = [
migrations.CreateModel(
name='Course',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('name', models.CharField(max_length=50, verbose_name='课程名')),
('desc', models.CharField(max_length=300, verbose_name='课程描述')),
('detail', DjangoUeditor.models.UEditorField(default='', verbose_name='课程详情')),
('degree', models.CharField(choices=[('cj', '初级'), ('zj', '中级'), ('gj', '高级')], max_length=2, verbose_name='难度')),
('learn_times', models.IntegerField(default=0, verbose_name='学习时长(分钟数)')),
('students', models.IntegerField(default=0, verbose_name='学习人数')),
('fav_nums', models.IntegerField(default=0, verbose_name='收藏人数')),
('image', models.ImageField(upload_to='courses/%Y/%m', verbose_name='封面图')),
('click_nums', models.IntegerField(default=0, verbose_name='点击数')),
('tag', models.CharField(default='', max_length=10, verbose_name='课程标签')),
('is_banner', models.BooleanField(default=False, verbose_name='是否轮播')),
('add_time', models.DateTimeField(default=datetime.datetime.now, verbose_name='添加时间')),
('youneed_know', models.CharField(default='', max_length=300, verbose_name='课程须知')),
('teacher_tell', models.CharField(default='', max_length=300, verbose_name='老师告诉你')),
('course_org', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to='organization.CourseOrg', verbose_name='所属机构')),
('teacher', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to='organization.Teacher', verbose_name='讲师')),
],
options={
'verbose_name': '课程',
'verbose_name_plural': '课程',
},
),
migrations.CreateModel(
name='Lesson',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('name', models.CharField(max_length=100, verbose_name='章节名')),
('add_time', models.DateTimeField(default=datetime.datetime.now, verbose_name='添加时间')),
('course', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='course.Course', verbose_name='课程')),
],
options={
'verbose_name': '章节',
'verbose_name_plural': '章节',
},
),
migrations.CreateModel(
name='Video',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('name', models.CharField(max_length=100, verbose_name='视频名')),
('url', models.CharField(default='', max_length=200, verbose_name='访问地址')),
('video_times', models.FloatField(default=0.0, verbose_name='视频时长(min)')),
('add_time', models.DateTimeField(default=datetime.datetime.now, verbose_name='添加时间')),
('lesson', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='course.Lesson', verbose_name='章节')),
],
options={
'verbose_name': '视频',
'verbose_name_plural': '视频',
},
),
migrations.CreateModel(
name='CourseResource',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('name', models.CharField(max_length=100, verbose_name='名称')),
('download', models.FileField(upload_to='course/resource/%Y/%m', verbose_name='资源文件')),
('add_time', models.DateTimeField(default=datetime.datetime.now, verbose_name='添加时间')),
('course', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='course.Course', verbose_name='课程')),
],
options={
'verbose_name': '课程资源',
'verbose_name_plural': '课程资源',
},
),
]
class Migration(migrations.Migration):
initial = True
dependencies = []
operations = [
migrations.CreateModel(
name='Donation_log',
fields=[
('Donation_log_id',
models.AutoField(primary_key=True,
serialize=False,
verbose_name='流水id')),
('donate_money', models.FloatField(verbose_name='捐助金额')),
('donate_at',
models.DateTimeField(auto_now_add=True, verbose_name='捐助时间')),
('created_at',
models.DateTimeField(auto_now_add=True, verbose_name='创建时间')),
('update_at',
models.DateTimeField(auto_now=True, verbose_name='最后修改时间')),
],
options={
'verbose_name': '捐助流水',
},
),
migrations.CreateModel(
name='prj_development',
fields=[
('prj_development_id',
models.AutoField(primary_key=True, serialize=False)),
('title', models.CharField(max_length=40,
verbose_name='进程题目')),
('introduce', models.TextField(verbose_name='进程简介')),
('image',
models.ImageField(max_length=1024,
upload_to='img',
verbose_name='图片')),
('year', models.CharField(max_length=10,
verbose_name='进程发生年份')),
('date', models.CharField(max_length=30,
verbose_name='进程发生月日')),
('created_at',
models.DateTimeField(auto_now_add=True, verbose_name='创建时间')),
('update_at',
models.DateTimeField(auto_now=True, verbose_name='最后修改时间')),
],
options={
'verbose_name': '众筹项目进程',
},
),
migrations.CreateModel(
name='project',
fields=[
('proj_class',
models.CharField(max_length=50, verbose_name='项目类别')),
('project_id',
models.AutoField(primary_key=True,
serialize=False,
verbose_name='项目id')),
('name', models.CharField(max_length=30, verbose_name='项目名称')),
('introduce',
DjangoUeditor.models.UEditorField(verbose_name='项目简介')),
('action', models.TextField(verbose_name='具体行动')),
('befor_image',
models.ImageField(upload_to='img', verbose_name='首页项目图片')),
('later_image',
models.ImageField(upload_to='img', verbose_name='进入后项目图片')),
('target_money', models.FloatField(verbose_name='目标金额')),
('now_money', models.FloatField(verbose_name='已筹金额')),
('people_num', models.IntegerField(verbose_name='帮助人数')),
('see_num', models.IntegerField(verbose_name='浏览人数')),
('time_begin', models.DateField(verbose_name='开始时间')),
('time_out', models.DateField(verbose_name='结束时间')),
('state',
models.IntegerField(choices=[(0, '审核中'), (1, '通过'),
(2, '未通过')],
verbose_name='状态')),
('created_at',
models.DateTimeField(auto_now_add=True, verbose_name='创建时间')),
('update_at',
models.DateTimeField(auto_now=True, verbose_name='最后修改时间')),
('is_display',
models.IntegerField(choices=[(0, '展示在首页'), (1, '不展示')],
default=1,
verbose_name='是否展示')),
('is_delete',
models.IntegerField(choices=[(0, '已删除'), (1, '未删除')],
default=1)),
],
options={
'verbose_name': '众筹项目',
},
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
]
operations = [
migrations.CreateModel(
name='Banner',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('image', models.ImageField(upload_to='banner', verbose_name='\u8f6e\u64ad\u56fe\u7247')),
('index', models.IntegerField(default=0, verbose_name='\u8f6e\u64ad\u987a\u5e8f')),
('add_time', models.DateTimeField(default=datetime.datetime.now, verbose_name='\u6dfb\u52a0\u65f6\u95f4')),
],
options={
'verbose_name': '\u8f6e\u64ad\u5546\u54c1',
'verbose_name_plural': '\u8f6e\u64ad\u5546\u54c1',
},
),
migrations.CreateModel(
name='Goods',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('goods_sn', models.CharField(default='', max_length=50, verbose_name='\u5546\u54c1\u552f\u4e00\u8d27\u53f7')),
('name', models.CharField(max_length=100, verbose_name='\u5546\u54c1\u540d')),
('click_num', models.IntegerField(default=0, verbose_name='\u70b9\u51fb\u6570')),
('sold_num', models.IntegerField(default=0, verbose_name='\u5546\u54c1\u9500\u552e\u91cf')),
('fav_num', models.IntegerField(default=0, verbose_name='\u6536\u85cf\u6570')),
('goods_num', models.IntegerField(default=0, verbose_name='\u5e93\u5b58\u6570')),
('market_price', models.FloatField(default=0, verbose_name='\u5e02\u573a\u4ef7\u683c')),
('shop_price', models.FloatField(default=0, verbose_name='\u672c\u5e97\u4ef7\u683c')),
('goods_brief', models.TextField(max_length=500, verbose_name='\u5546\u54c1\u7b80\u77ed\u63cf\u8ff0')),
('goods_desc', DjangoUeditor.models.UEditorField(default='', verbose_name='\u5185\u5bb9')),
('ship_free', models.BooleanField(default=True, verbose_name='\u662f\u5426\u627f\u62c5\u8fd0\u8d39')),
('goods_front_image', models.ImageField(blank=True, null=True, upload_to='goods/images/', verbose_name='\u5c01\u9762\u56fe')),
('is_new', models.BooleanField(default=False, verbose_name='\u662f\u5426\u65b0\u54c1')),
('is_hot', models.BooleanField(default=False, verbose_name='\u662f\u5426\u70ed\u9500')),
('add_time', models.DateTimeField(default=datetime.datetime.now, verbose_name='\u6dfb\u52a0\u65f6\u95f4')),
],
options={
'verbose_name': '\u5546\u54c1',
'verbose_name_plural': '\u5546\u54c1',
},
),
migrations.CreateModel(
name='GoodsCategory',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('name', models.CharField(default='', help_text='\u7c7b\u522b\u540d', max_length=30, verbose_name='\u7c7b\u522b\u540d')),
('code', models.CharField(default='', help_text='\u7c7b\u522bcode', max_length=30, verbose_name='\u7c7b\u522bcode')),
('desc', models.TextField(default='', help_text='\u7c7b\u522b\u63cf\u8ff0', verbose_name='\u7c7b\u522b\u63cf\u8ff0')),
('category_type', models.IntegerField(choices=[(1, '\u4e00\u7ea7\u7c7b\u76ee'), (2, '\u4e8c\u7ea7\u7c7b\u76ee'), (3, '\u4e09\u7ea7\u7c7b\u76ee')], verbose_name='\u7c7b\u76ee\u7ea7\u522b')),
('is_tab', models.BooleanField(default=False, help_text='\u662f\u5426\u5bfc\u822a', verbose_name='\u662f\u5426\u5bfc\u822a')),
('add_time', models.DateTimeField(default=datetime.datetime.now, verbose_name='\u6dfb\u52a0\u65f6\u95f4')),
('parent_category', models.ForeignKey(blank=True, help_text='\u7236\u76ee\u5f55', null=True, on_delete=django.db.models.deletion.CASCADE, related_name='sub_cat', to='goods.GoodsCategory', verbose_name='\u7236\u7c7b\u76ee\u7ea7\u522b')),
],
options={
'verbose_name': '\u5546\u54c1\u7c7b\u522b',
'verbose_name_plural': '\u5546\u54c1\u7c7b\u522b',
},
),
migrations.CreateModel(
name='GoodsCategoryBrand',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('name', models.CharField(default='', help_text='\u54c1\u724c\u540d', max_length=30, verbose_name='\u54c1\u724c\u540d')),
('desc', models.TextField(default='', help_text='\u54c1\u724c\u63cf\u8ff0', max_length=200, verbose_name='\u54c1\u724c\u63cf\u8ff0')),
('image', models.ImageField(max_length=200, upload_to='brands/')),
('add_time', models.DateTimeField(default=datetime.datetime.now, verbose_name='\u6dfb\u52a0\u65f6\u95f4')),
('category', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='brands', to='goods.GoodsCategory', verbose_name='\u5546\u54c1\u7c7b\u76ee')),
],
options={
'db_table': 'goods_goodsbrand',
'verbose_name': '\u54c1\u724c',
'verbose_name_plural': '\u54c1\u724c',
},
),
migrations.CreateModel(
name='GoodsImage',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('image', models.ImageField(blank=True, null=True, upload_to='', verbose_name='\u56fe\u7247')),
('add_time', models.DateTimeField(default=datetime.datetime.now, verbose_name='\u6dfb\u52a0\u65f6\u95f4')),
('goods', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='images', to='goods.Goods', verbose_name='\u5546\u54c1')),
],
options={
'verbose_name': '\u5546\u54c1\u56fe\u7247',
'verbose_name_plural': '\u5546\u54c1\u56fe\u7247',
},
),
migrations.CreateModel(
name='HotSearchWords',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('keywords', models.CharField(default='', max_length=20, verbose_name='\u70ed\u641c\u8bcd')),
('index', models.IntegerField(default=0, verbose_name='\u6392\u5e8f')),
('add_time', models.DateTimeField(default=datetime.datetime.now, verbose_name='\u6dfb\u52a0\u65f6\u95f4')),
],
options={
'verbose_name': '\u70ed\u641c\u8bcd',
'verbose_name_plural': '\u70ed\u641c\u8bcd',
},
),
migrations.CreateModel(
name='IndexAd',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('category', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='category', to='goods.GoodsCategory', verbose_name='\u5546\u54c1\u7c7b\u76ee')),
('goods', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='goods', to='goods.Goods')),
],
options={
'verbose_name': '\u9996\u9875\u5546\u54c1\u7c7b\u522b\u5e7f\u544a',
'verbose_name_plural': '\u9996\u9875\u5546\u54c1\u7c7b\u522b\u5e7f\u544a',
},
),
migrations.AddField(
model_name='goods',
name='category',
field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='goods.GoodsCategory', verbose_name='\u5546\u54c1\u7c7b\u76ee'),
),
migrations.AddField(
model_name='banner',
name='goods',
field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='goods.Goods', verbose_name='\u5546\u54c1'),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
]
operations = [
migrations.CreateModel(
name='Banner',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('image', models.ImageField(upload_to='banner', verbose_name='轮播图片')),
('index', models.IntegerField(default=0, verbose_name='轮播顺序')),
('add_time', models.DateTimeField(default=datetime.datetime.now, verbose_name='添加时间')),
],
options={
'verbose_name': '轮播商品',
'verbose_name_plural': '轮播商品',
},
),
migrations.CreateModel(
name='Goods',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('good_lot_no', models.CharField(default='', max_length=50, verbose_name='商品货号')),
('name', models.CharField(max_length=100, verbose_name='商品名')),
('click_num', models.IntegerField(default=0, verbose_name='点击数')),
('sold_num', models.IntegerField(default=0, verbose_name='销量')),
('col_num', models.IntegerField(default=0, verbose_name='收藏数')),
('stock_num', models.IntegerField(default=0, verbose_name='库存数')),
('market_price', models.FloatField(default=0, verbose_name='市场价格')),
('sale_price', models.FloatField(default=0, verbose_name='销售价格')),
('goods_brief', models.TextField(max_length=500, verbose_name='商品简短描述')),
('goods_desc', DjangoUeditor.models.UEditorField(default='', verbose_name='内容')),
('ship_free', models.BooleanField(default=True, verbose_name='是否承担运费')),
('goods_front_image', models.ImageField(blank=True, null=True, upload_to='goods/images/', verbose_name='封面图')),
('is_new', models.BooleanField(default=False, verbose_name='是否新品')),
('is_hot', models.BooleanField(default=False, verbose_name='是否热销')),
('add_time', models.DateTimeField(default=datetime.datetime.now, verbose_name='添加时间')),
],
options={
'verbose_name': '商品',
'verbose_name_plural': '商品',
},
),
migrations.CreateModel(
name='GoodsCategory',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('name', models.CharField(default='', help_text='类别名称', max_length=30, verbose_name='类别名称')),
('name_en', models.CharField(default='', help_text='类别英文名称', max_length=30, verbose_name='类别英文名称')),
('description', models.TextField(default='', help_text='描述', verbose_name='描述')),
('category_level', models.IntegerField(choices=[(1, '一级'), (2, '二级'), (3, '三级')], help_text='等级', verbose_name='等级')),
('is_tab', models.BooleanField(default=False, help_text='是否导航', verbose_name='是否导航')),
('add_time', models.DateTimeField(default=datetime.datetime.now, verbose_name='添加时间')),
('parent_category', models.ForeignKey(blank=True, help_text='父目录', null=True, on_delete=django.db.models.deletion.CASCADE, related_name='sub_cat', to='goods.GoodsCategory', verbose_name='父类目级别')),
],
options={
'verbose_name': '商品类别',
'verbose_name_plural': '商品类别',
},
),
migrations.CreateModel(
name='GoodsCategoryBrand',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('name', models.CharField(default='', help_text='品牌名', max_length=30, verbose_name='品牌名')),
('description', models.TextField(default='', help_text='品牌描述', max_length=200, verbose_name='品牌描述')),
('image', models.ImageField(max_length=200, upload_to='brands/images/')),
('add_time', models.DateTimeField(default=datetime.datetime.now, verbose_name='添加时间')),
],
options={
'verbose_name': '品牌',
'verbose_name_plural': '品牌',
},
),
migrations.CreateModel(
name='GoodsImage',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('image', models.ImageField(blank=True, null=True, upload_to='', verbose_name='图片')),
('add_time', models.DateTimeField(default=datetime.datetime.now, verbose_name='添加时间')),
('goods', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='images', to='goods.Goods', verbose_name='商品')),
],
options={
'verbose_name': '商品图片',
'verbose_name_plural': '商品图片',
},
),
migrations.AddField(
model_name='goods',
name='category',
field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='goods.GoodsCategory', verbose_name='商品分类'),
),
migrations.AddField(
model_name='banner',
name='goods',
field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='goods.Goods', verbose_name='商品'),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
]
operations = [
migrations.CreateModel(
name='CommInfo',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('c_name', models.CharField(max_length=20, verbose_name='商品名称')),
('c_price', models.FloatField(verbose_name='商品价格')),
('c_comfrom', models.CharField(max_length=100, verbose_name='商品产地')),
('c_images', models.ImageField(default='df_goods/fruit.jpg', upload_to='df_goods/', verbose_name='商品图片')),
('c_unit', models.CharField(max_length=50, verbose_name='单位/斤')),
('c_desc', models.CharField(max_length=255, verbose_name='诱惑')),
('c_content', DjangoUeditor.models.UEditorField(default='', verbose_name='商品描述')),
('c_stock', models.IntegerField(verbose_name='商品库存')),
('c_click', models.IntegerField(verbose_name='商品点击率')),
],
options={
'verbose_name': '商品',
'verbose_name_plural': '商品',
'db_table': 'commodity',
},
),
migrations.CreateModel(
name='CommOrders',
fields=[
('o_id', models.CharField(max_length=10, primary_key=True, serialize=False, verbose_name='订单号')),
('o_date', models.DateTimeField(auto_now_add=True, verbose_name='订单时间')),
('o_money', models.CharField(max_length=200, verbose_name='订单价格')),
('o_type', models.BooleanField(choices=[(True, '已支付'), (False, '未支付')])),
],
options={
'verbose_name': '订单详情',
'verbose_name_plural': '订单详情',
'db_table': 'orders',
},
),
migrations.CreateModel(
name='CommTags',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('tags', models.CharField(max_length=20, verbose_name='商品标签')),
],
options={
'verbose_name': '商品标签',
'verbose_name_plural': '商品标签',
'db_table': 'tags',
},
),
migrations.CreateModel(
name='CommType',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('class_name', models.CharField(max_length=50, verbose_name='商品分类')),
('type_img', models.ImageField(upload_to='df_type/', verbose_name='商品分类图片')),
],
options={
'verbose_name': '商品分类',
'verbose_name_plural': '商品分类',
'db_table': 'type',
},
),
migrations.CreateModel(
name='OrderInfo',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('content', models.CharField(max_length=255, verbose_name='订单商品数量')),
],
options={
'verbose_name': '订单详情表',
'verbose_name_plural': '订单详情表',
'db_table': 'orderinfo',
},
),
migrations.CreateModel(
name='ShopCat',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('s_num', models.IntegerField(verbose_name='购买的数量')),
('s_money', models.FloatField(verbose_name='商品总价')),
('comm', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='fruits.CommInfo', verbose_name='商品种类')),
],
options={
'verbose_name': '购物车',
'verbose_name_plural': '购物车',
'db_table': 'cart',
},
),
]
class Migration(migrations.Migration):
initial = True
dependencies = []
operations = [
migrations.CreateModel(
name='Goods',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('goods_sn',
models.CharField(default='',
max_length=50,
verbose_name='goods Id')),
('name',
models.CharField(max_length=100, verbose_name='goods name')),
('click_num',
models.IntegerField(default=0, verbose_name='click number')),
('sold_num',
models.IntegerField(default=0, verbose_name='sold number')),
('fav_num',
models.IntegerField(default=0,
verbose_name='favorite number')),
('stock',
models.IntegerField(default=0, verbose_name='stock number')),
('market_price',
models.FloatField(default=0, verbose_name='market price')),
('shop_price',
models.FloatField(default=0, verbose_name='shop price')),
('goods_brief',
models.TextField(max_length=500,
verbose_name='good description')),
('goods_desc',
DjangoUeditor.models.UEditorField(default='',
verbose_name='内容')),
('ship_free',
models.BooleanField(default=True,
verbose_name='need shipping fee or not')),
('goods_front_image',
models.ImageField(blank=True,
null=True,
upload_to='goods/images/',
verbose_name='front page image')),
('is_new',
models.BooleanField(default=True, verbose_name='is new')),
('is_hot',
models.BooleanField(default=True, verbose_name='is hot')),
('add_time',
models.DateTimeField(default=datetime.datetime.now,
verbose_name='add time')),
],
options={
'verbose_name': 'goods',
'verbose_name_plural': 'goods',
},
),
migrations.CreateModel(
name='GoodsCategory',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name',
models.CharField(default='',
help_text='catagory name',
max_length=30,
verbose_name='name')),
('code',
models.CharField(default='',
help_text='catarogy code',
max_length=30,
verbose_name='code')),
('desc',
models.TextField(default='',
help_text='catagory description',
verbose_name='')),
('category_type',
models.IntegerField(choices=[(1, 'CLASS 1'), (2, 'CLASS 2'),
(3, 'CLASS 3')],
help_text='category level',
verbose_name='category level')),
('is_tab',
models.BooleanField(default=False,
help_text='is navigator',
verbose_name='is navigator')),
('add_time',
models.DateTimeField(default=datetime.datetime.now,
verbose_name='add time')),
('parent_category',
models.ForeignKey(blank=True,
help_text='parent level',
null=True,
on_delete=django.db.models.deletion.CASCADE,
related_name='sub_cat',
to='goods.GoodsCategory',
verbose_name='parent level')),
],
options={
'verbose_name': 'good catagory',
'verbose_name_plural': 'good catagory',
},
),
migrations.CreateModel(
name='GoodsCategoryBrand',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name',
models.CharField(default='',
help_text='brand text',
max_length=30,
verbose_name='brand name')),
('desc',
models.TextField(default='',
help_text='brand desc',
max_length=200,
verbose_name='brand desc')),
('image', models.ImageField(max_length=200,
upload_to='brands/')),
('add_time',
models.DateTimeField(default=datetime.datetime.now,
verbose_name='add time')),
('category',
models.ForeignKey(blank=True,
null=True,
on_delete=django.db.models.deletion.CASCADE,
related_name='brands',
to='goods.GoodsCategory',
verbose_name='category')),
],
options={
'verbose_name': 'brands',
'verbose_name_plural': 'brands',
},
),
migrations.AddField(
model_name='goods',
name='category',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to='goods.GoodsCategory',
verbose_name='category'),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = []
operations = [
migrations.CreateModel(
name='Banner',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('image',
models.ImageField(upload_to='banner', verbose_name='轮播图片')),
('index', models.IntegerField(default=0, verbose_name='轮播顺序')),
('add_time',
models.DateTimeField(default=datetime.datetime.now,
verbose_name='添加时间')),
],
options={
'verbose_name': '首页轮播',
'verbose_name_plural': '首页轮播',
},
),
migrations.CreateModel(
name='Goods',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('goods_sn',
models.CharField(default='',
max_length=50,
verbose_name='商品唯一货号')),
('name', models.CharField(max_length=100, verbose_name='商品名')),
('click_num', models.IntegerField(default=0,
verbose_name='点击数')),
('sold_num',
models.IntegerField(default=0, verbose_name='商品销售量')),
('fav_num', models.IntegerField(default=0,
verbose_name='收藏数')),
('goods_num', models.IntegerField(default=0,
verbose_name='库存数')),
('market_price',
models.FloatField(default=0, verbose_name='市场价格')),
('shop_price', models.FloatField(default=0,
verbose_name='本店价格')),
('goods_brief',
models.TextField(max_length=500, verbose_name='商品简短描述')),
('goods_desc',
DjangoUeditor.models.UEditorField(default='',
verbose_name='内容')),
('ship_free',
models.BooleanField(default=True, verbose_name='是否承担运费')),
('goods_front_image',
models.ImageField(blank=True,
null=True,
upload_to='goods/images/',
verbose_name='封面图')),
('is_new',
models.BooleanField(default=False, verbose_name='是否新品')),
('is_hot',
models.BooleanField(default=False, verbose_name='是否热销')),
('add_time',
models.DateTimeField(default=datetime.datetime.now,
verbose_name='添加时间')),
],
options={
'verbose_name': '商品信息',
'verbose_name_plural': '商品信息',
},
),
migrations.CreateModel(
name='GoodsCategory',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name',
models.CharField(default='',
help_text='类别名',
max_length=30,
verbose_name='类别名')),
('code',
models.CharField(default='',
help_text='类别code',
max_length=30,
verbose_name='类别code')),
('desc',
models.TextField(default='',
help_text='类别描述',
verbose_name='类别描述')),
('category_type',
models.IntegerField(choices=[(1, '一级类目'), (2, '二级类目'),
(3, '三级类目')],
help_text='类目级别',
verbose_name='类目级别')),
('is_tab',
models.BooleanField(default=False,
help_text='是否导航',
verbose_name='是否导航')),
('add_time',
models.DateTimeField(default=datetime.datetime.now,
verbose_name='添加时间')),
('parent_category',
models.ForeignKey(blank=True,
help_text='父目录',
null=True,
on_delete=django.db.models.deletion.CASCADE,
related_name='sub_cat',
to='goods.GoodsCategory',
verbose_name='父类目级别')),
],
options={
'verbose_name': '商品类别',
'verbose_name_plural': '商品类别',
},
),
migrations.CreateModel(
name='GoodsCategoryBrand',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name',
models.CharField(default='',
help_text='品牌名',
max_length=30,
verbose_name='品牌名')),
('desc',
models.TextField(default='',
help_text='品牌描述',
max_length=200,
verbose_name='品牌描述')),
('image', models.ImageField(max_length=200,
upload_to='brands/')),
('add_time',
models.DateTimeField(default=datetime.datetime.now,
verbose_name='添加时间')),
('category',
models.ForeignKey(blank=True,
null=True,
on_delete=django.db.models.deletion.CASCADE,
related_name='brands',
to='goods.GoodsCategory',
verbose_name='商品类目')),
],
options={
'verbose_name': '宣传品牌',
'verbose_name_plural': '宣传品牌',
'db_table': 'goods_goodsbrand',
},
),
migrations.CreateModel(
name='GoodsImage',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('image',
models.ImageField(blank=True,
null=True,
upload_to='',
verbose_name='图片')),
('add_time',
models.DateTimeField(default=datetime.datetime.now,
verbose_name='添加时间')),
('goods',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='images',
to='goods.Goods',
verbose_name='商品')),
],
options={
'verbose_name': '商品轮播',
'verbose_name_plural': '商品轮播',
},
),
migrations.CreateModel(
name='HotSearchWords',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('keywords',
models.CharField(default='',
max_length=20,
verbose_name='热搜词')),
('index', models.IntegerField(default=0, verbose_name='排序')),
('add_time',
models.DateTimeField(default=datetime.datetime.now,
verbose_name='添加时间')),
],
options={
'verbose_name': '热搜排行',
'verbose_name_plural': '热搜排行',
},
),
migrations.CreateModel(
name='IndexAd',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('category',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='category',
to='goods.GoodsCategory',
verbose_name='商品类目')),
('goods',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='goods',
to='goods.Goods')),
],
options={
'verbose_name': '首页广告',
'verbose_name_plural': '首页广告',
},
),
migrations.AddField(
model_name='goods',
name='category',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to='goods.GoodsCategory',
verbose_name='商品类目'),
),
migrations.AddField(
model_name='banner',
name='goods',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to='goods.Goods',
verbose_name='商品'),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = []
operations = [
migrations.CreateModel(
name='Goods',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('goods_sn',
models.CharField(default='',
max_length=50,
verbose_name='商品唯一货号')),
('name', models.CharField(max_length=100, verbose_name='商品名')),
('sold_num',
models.IntegerField(default=0, verbose_name='商品销售量')),
('goods_num', models.IntegerField(default=0,
verbose_name='库存数')),
('market_price',
models.FloatField(default=0, verbose_name='市场价格')),
('goods_brief',
models.TextField(max_length=500, verbose_name='商品简短描述')),
('goods_desc',
DjangoUeditor.models.UEditorField(default='',
verbose_name='内容')),
('goods_front_image',
models.ImageField(blank=True,
null=True,
upload_to='goods/images/',
verbose_name='封面图')),
('is_new',
models.BooleanField(default=False, verbose_name='是否新品')),
('add_time',
models.DateTimeField(default=datetime.datetime.now,
verbose_name='添加时间')),
],
options={
'verbose_name': '商品',
'verbose_name_plural': '商品',
},
),
migrations.CreateModel(
name='GoodsCategory',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name',
models.CharField(default='',
help_text='类别名',
max_length=30,
verbose_name='类别名')),
('code',
models.CharField(default='',
help_text='类别code',
max_length=30,
verbose_name='类别code')),
('desc',
models.TextField(default='',
help_text='类别描述',
verbose_name='类别描述')),
('category_type',
models.IntegerField(choices=[(1, '台式机'), (2, '笔记本电脑'),
(3, '其他')],
help_text='类目级别',
verbose_name='类目级别')),
('is_tab',
models.BooleanField(default=False,
help_text='是否导航',
verbose_name='是否导航')),
('add_time',
models.DateTimeField(default=datetime.datetime.now,
verbose_name='添加时间')),
],
options={
'verbose_name': '商品类别',
'verbose_name_plural': '商品类别',
},
),
migrations.CreateModel(
name='GoodsCategoryBrand',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name',
models.CharField(default='',
help_text='品牌名',
max_length=30,
verbose_name='品牌名')),
('desc',
models.TextField(default='',
help_text='品牌描述',
max_length=200,
verbose_name='品牌描述')),
('image', models.ImageField(max_length=200,
upload_to='brands/')),
('add_time',
models.DateTimeField(default=datetime.datetime.now,
verbose_name='添加时间')),
('category',
models.ForeignKey(blank=True,
null=True,
on_delete=django.db.models.deletion.CASCADE,
related_name='brands',
to='goods.GoodsCategory',
verbose_name='商品类目')),
],
options={
'verbose_name': '品牌',
'verbose_name_plural': '品牌',
'db_table': 'goods_goodsbrand',
},
),
migrations.CreateModel(
name='GoodsImage',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('image',
models.ImageField(blank=True,
null=True,
upload_to='',
verbose_name='图片')),
('add_time',
models.DateTimeField(default=datetime.datetime.now,
verbose_name='添加时间')),
('goods',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='images',
to='goods.Goods',
verbose_name='商品')),
],
options={
'verbose_name': '商品图片',
'verbose_name_plural': '商品图片',
},
),
migrations.AddField(
model_name='goods',
name='category',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to='goods.GoodsCategory',
verbose_name='商品类目'),
),
]
