# Generated by Django 2.2.1 on 2019-09-11 09:58

from django.db import migrations, models


class Migration(migrations.Migration):

    initial = True

    dependencies = [
    ]

    operations = [
        migrations.CreateModel(
            name='SmBrand',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('bramd_id', models.IntegerField(blank=True, null=True, verbose_name='品牌ID')),
                ('bramd_name', models.CharField(blank=True, max_length=64, null=True, verbose_name='品牌')),
                ('brand_order', models.IntegerField(blank=True, null=True, verbose_name='排序')),
                ('is_status', models.BooleanField(blank=True, default=True, null=True, verbose_name='是否启用')),
                ('hide_value', models.IntegerField(blank=True, default=0, null=True, verbose_name='隐藏的字数')),
            ],
        ),
        migrations.CreateModel(
            name='SmCatGoods',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('cat_id', models.IntegerField(blank=True, null=True, verbose_name='目录ID（goods_category表）')),
                ('goods_id', models.IntegerField(blank=True, null=True, verbose_name='商品ID')),
                ('goods_price', models.FloatField(blank=True, null=True, verbose_name='商品价格')),
                ('expand_name', models.CharField(blank=True, max_length=64, null=True, verbose_name='商品扩展名')),
                ('is_status', models.BooleanField(blank=True, default=True, null=True, verbose_name='是否启用')),
                ('add_time', models.DateTimeField(blank=True, null=True, verbose_name='添加时间')),
                ('note', models.CharField(blank=True, max_length=1024, null=True, verbose_name='备注')),
            ],
        ),
        migrations.CreateModel(
            name='SmCatGoodsBackup',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('cat_id', models.IntegerField(blank=True, null=True, verbose_name='目录ID（goods_category表）')),
                ('goods_id', models.IntegerField(blank=True, null=True, verbose_name='商品ID')),
                ('goods_price', models.FloatField(blank=True, null=True, verbose_name='商品价格')),
                ('expand_name', models.CharField(blank=True, max_length=64, null=True, verbose_name='商品扩展名')),
                ('is_status', models.BooleanField(blank=True, default=True, null=True, verbose_name='是否启用')),
                ('add_time', models.DateTimeField(blank=True, null=True, verbose_name='添加时间')),
                ('note', models.CharField(blank=True, max_length=1024, null=True, verbose_name='备注')),
            ],
        ),
        migrations.CreateModel(
            name='SmCoupon',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('coupon_id_type', models.IntegerField(blank=True, null=True, verbose_name='分类ID')),
                ('coupon_sn', models.CharField(blank=True, max_length=256, null=True, verbose_name='优惠券号')),
                ('user_id', models.IntegerField(blank=True, null=True, verbose_name='使用会员ID')),
                ('used_time', models.DateTimeField(blank=True, null=True, verbose_name='使用时间')),
                ('order_sn', models.CharField(blank=True, max_length=256, null=True, verbose_name='使用订单号')),
                ('soruce_order_sn', models.CharField(blank=True, max_length=256, null=True, verbose_name='由该订单产生的优惠券')),
                ('emailed', models.CharField(blank=True, max_length=64, null=True, verbose_name='邮箱地址')),
                ('send_type', models.BooleanField(blank=True, default=False, null=True, verbose_name='是否启用')),
                ('send_phone', models.CharField(blank=True, max_length=64, null=True, verbose_name='发送的手机号码')),
                ('send_time', models.DateTimeField(blank=True, null=True, verbose_name='发送时间')),
            ],
        ),
        migrations.CreateModel(
            name='SmCouponType',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('type_money', models.IntegerField(blank=True, null=True, verbose_name='类别金额')),
                ('type_name', models.CharField(blank=True, max_length=256, null=True, verbose_name='类别名称')),
                ('send_type', models.IntegerField(blank=True, null=True, verbose_name='发送类型')),
                ('min_amount', models.IntegerField(blank=True, null=True, verbose_name='最小使用金额')),
                ('max_amount', models.IntegerField(blank=True, null=True, verbose_name='最大使用金额')),
                ('send_start_date', models.DateTimeField(blank=True, null=True, verbose_name='发送开始时间')),
                ('send_end_date', models.DateTimeField(blank=True, null=True, verbose_name='发送最后时间')),
                ('use_start_date', models.DateTimeField(blank=True, null=True, verbose_name='使用开始时间')),
                ('use_end_date', models.DateTimeField(blank=True, null=True, verbose_name='最后使用时间')),
                ('min_goods_amount', models.IntegerField(blank=True, null=True, verbose_name='最小使用商品金额')),
                ('add_time', models.DateTimeField(blank=True, null=True, verbose_name='添加时间')),
            ],
        ),
        migrations.CreateModel(
            name='SmGoods',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('cat_id', models.IntegerField(blank=True, null=True, verbose_name='')),
                ('goods_sn', models.CharField(blank=True, max_length=64, null=True, verbose_name='商品货号')),
                ('goods_name', models.CharField(blank=True, max_length=256, null=True, verbose_name='商品名字')),
                ('goods_name_style', models.CharField(blank=True, max_length=256, null=True, verbose_name='商品类型')),
                ('click_count', models.IntegerField(blank=True, default=0, null=True, verbose_name='点击数量')),
                ('brand_id', models.IntegerField(blank=True, null=True, verbose_name='品牌ID')),
                ('provider_name', models.CharField(blank=True, max_length=64, null=True, verbose_name='')),
                ('goods_number', models.IntegerField(blank=True, null=True, verbose_name='品牌ID')),
                ('goods_weight', models.FloatField(blank=True, null=True, verbose_name='')),
                ('market_price', models.FloatField(blank=True, null=True, verbose_name='市场价')),
                ('shop_price', models.FloatField(blank=True, null=True, verbose_name='销售价')),
                ('promote_price', models.FloatField(blank=True, null=True, verbose_name='促销价')),
                ('promote_start_date', models.DateField(blank=True, null=True, verbose_name='促销开始日期')),
                ('promote_end_date', models.DateField(blank=True, null=True, verbose_name='促销开始日期')),
                ('warn_number', models.IntegerField(blank=True, null=True, verbose_name='')),
                ('keywords', models.CharField(blank=True, max_length=256, null=True, verbose_name='关键词')),
                ('goods_brief', models.CharField(blank=True, max_length=1024, null=True, verbose_name='货物简介')),
                ('goods_desc', models.TextField(blank=True, null=True, verbose_name='货物详细')),
                ('goods_thumb', models.CharField(blank=True, max_length=64, null=True, verbose_name='')),
                ('goods_img', models.CharField(blank=True, max_length=64, null=True, verbose_name='')),
                ('original_img', models.CharField(blank=True, max_length=64, null=True, verbose_name='')),
                ('is_real', models.BooleanField(blank=True, default=True, null=True, verbose_name='是否审核')),
                ('extension_code', models.CharField(blank=True, max_length=64, null=True, verbose_name='')),
                ('integral', models.IntegerField(blank=True, null=True, verbose_name='')),
                ('add_time', models.DateTimeField(blank=True, null=True, verbose_name='添加时间')),
                ('sort_order', models.IntegerField(blank=True, null=True, verbose_name='排序')),
                ('is_delete', models.BooleanField(blank=True, default=False, null=True, verbose_name='是否删除')),
                ('is_best', models.BooleanField(blank=True, default=True, null=True, verbose_name='是否最好')),
                ('is_new', models.BooleanField(blank=True, default=True, null=True, verbose_name='是否最新')),
                ('is_hot', models.BooleanField(blank=True, default=False, null=True, verbose_name='是否最热')),
                ('is_promote', models.BooleanField(blank=True, default=True, null=True, verbose_name='是否公开')),
                ('bonus_type_id', models.IntegerField(blank=True, null=True, verbose_name='利润类型')),
                ('last_update', models.DateTimeField(blank=True, null=True, verbose_name='更新时间')),
                ('goods_type', models.IntegerField(blank=True, null=True, verbose_name='商品类型，促销有用')),
                ('goods_info', models.CharField(blank=True, max_length=10000, null=True, verbose_name='商品属性')),
                ('seller_note', models.CharField(blank=True, max_length=64, null=True, verbose_name='票据信息')),
                ('give_integral', models.IntegerField(blank=True, default=0, null=True, verbose_name='积分')),
                ('comment_status', models.BooleanField(blank=True, default=True, null=True, verbose_name='是否评论')),
                ('warehouse_id', models.IntegerField(blank=True, null=True, verbose_name='仓库ID')),
                ('goods_status', models.IntegerField(blank=True, default=0, null=True, verbose_name='商品上下架，-1是回收站，0是缺货，1是下架')),
                ('is_taozhuang', models.BooleanField(blank=True, default=False, null=True, verbose_name='是否套餐')),
                ('gift_id', models.IntegerField(blank=True, null=True, verbose_name='赠品ID')),
                ('series_id', models.IntegerField(blank=True, null=True, verbose_name='系列ID')),
                ('reserved_field', models.CharField(blank=True, max_length=64, null=True, verbose_name='保留字段')),
            ],
        ),
        migrations.CreateModel(
            name='SmGoodsCategory',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('cat_name', models.CharField(blank=True, max_length=256, null=True, verbose_name='目录名称')),
                ('keywords', models.CharField(blank=True, max_length=256, null=True, verbose_name='关键字')),
                ('cat_desc', models.CharField(blank=True, max_length=256, null=True, verbose_name='目录描述')),
                ('parent_id', models.IntegerField(blank=True, null=True, verbose_name='父ID')),
                ('g_level', models.IntegerField(blank=True, null=True, verbose_name='层级')),
                ('sort_order', models.IntegerField(blank=True, null=True, verbose_name='排序')),
                ('template_file', models.CharField(blank=True, max_length=256, null=True, verbose_name='')),
                ('measure_unit', models.CharField(blank=True, max_length=256, null=True, verbose_name='')),
                ('show_in_nav', models.IntegerField(blank=True, null=True, verbose_name='')),
                ('style', models.CharField(blank=True, max_length=256, null=True, verbose_name='')),
                ('is_show', models.BooleanField(blank=True, default=True, null=True, verbose_name='是否显示')),
                ('grade', models.IntegerField(blank=True, null=True, verbose_name='')),
                ('filter_attr', models.IntegerField(blank=True, null=True, verbose_name='')),
                ('site_id', models.IntegerField(blank=True, default=0, null=True, verbose_name='')),
            ],
        ),
        migrations.CreateModel(
            name='SmOrderGoods',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('order_id', models.IntegerField(blank=True, null=True, verbose_name='订单编号  开发用')),
                ('goods_id', models.IntegerField(blank=True, default=0, null=True, verbose_name='商品编号')),
                ('goods_name', models.CharField(blank=True, max_length=64, null=True, verbose_name='商品')),
                ('goods_sn', models.CharField(blank=True, max_length=64, null=True, verbose_name='货号')),
                ('goods_number', models.IntegerField(blank=True, default=1, null=True, verbose_name='数量')),
                ('market_price', models.FloatField(blank=True, null=True, verbose_name='市价')),
                ('goods_price', models.FloatField(blank=True, null=True, verbose_name='商品价')),
                ('goods_old_price', models.FloatField(blank=True, null=True, verbose_name='临时变量，保存因为折扣用的价格在里面，没怎么用')),
                ('goods_attr', models.CharField(blank=True, max_length=1024, null=True, verbose_name='商品口属性')),
                ('send_number', models.IntegerField(blank=True, default=0, null=True, verbose_name='')),
                ('is_real', models.IntegerField(blank=True, default=1, null=True, verbose_name='')),
                ('parent_id', models.IntegerField(blank=True, null=True, verbose_name='优惠券')),
                ('is_gift', models.BooleanField(blank=True, default=False, null=True, verbose_name='是否赠品')),
                ('add_time', models.DateTimeField(auto_now_add=True)),
                ('is_active', models.BooleanField(blank=True, default=True, null=True, verbose_name='是否显示')),
                ('goods_type', models.IntegerField(blank=True, null=True, verbose_name='商品类型，用于打折')),
                ('admin_id', models.IntegerField(blank=True, null=True, verbose_name='操作人')),
                ('shop_price', models.FloatField(blank=True, null=True, verbose_name='商品实际单价，等于折扣后的价格*数量')),
                ('bramd_id', models.IntegerField(blank=True, null=True, verbose_name='品牌ID')),
                ('bramd_name', models.CharField(blank=True, max_length=64, null=True, verbose_name='品牌')),
                ('comment_status', models.BooleanField(blank=True, default=True, null=True, verbose_name='是否评论')),
            ],
        ),
    ]
