# Generated by Django 2.2 on 2021-03-13 04:30

from django.conf import settings
from django.db import migrations, models
import django.db.models.deletion


class Migration(migrations.Migration):

    initial = True

    dependencies = [
        migrations.swappable_dependency(settings.AUTH_USER_MODEL),
    ]

    operations = [
        migrations.CreateModel(
            name='City_info',
            fields=[
                ('id', models.BigAutoField(primary_key=True, serialize=False, verbose_name='编号')),
                ('channel', models.CharField(default='未知', max_length=50, verbose_name='渠道')),
                ('cityId', models.CharField(max_length=50, verbose_name='城市编号')),
                ('cityCn', models.CharField(default='未知', max_length=200, verbose_name='城市中文名')),
                ('cityEn', models.CharField(default='未知', max_length=1000, verbose_name='城市英文名')),
                ('countryId', models.IntegerField(default=0, verbose_name='国家编号')),
                ('countryCn', models.CharField(default='未知', max_length=20, verbose_name='国家中文名')),
                ('countryEn', models.CharField(default='未知', max_length=200, verbose_name='国家英文名')),
                ('stateId', models.IntegerField(default=0, verbose_name='省份编号')),
                ('stateCn', models.CharField(default='未知', max_length=200, verbose_name='省份中文名')),
                ('stateEn', models.CharField(default='未知', max_length=1000, verbose_name='省份英文名')),
                ('is_effective', models.IntegerField(choices=[(1, '启用'), (0, '不启用')], default=0, verbose_name='是否启用')),
                ('sys_create_time', models.DateTimeField(auto_now_add=True, verbose_name='创建时间')),
                ('sys_update_time', models.DateTimeField(auto_now=True, verbose_name='更新时间')),
                ('sys_create_user', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, to=settings.AUTH_USER_MODEL, verbose_name='创建人')),
            ],
            options={
                'verbose_name': '城市信息表',
                'verbose_name_plural': '城市信息表',
                'db_table': 'city_info',
                'managed': True,
            },
        ),
        migrations.CreateModel(
            name='Hotel_info',
            fields=[
                ('id', models.BigAutoField(primary_key=True, serialize=False, verbose_name='编号')),
                ('channel', models.CharField(default='未知', max_length=50, verbose_name='渠道')),
                ('hotelId', models.IntegerField(verbose_name='酒店编号')),
                ('countryId', models.IntegerField(verbose_name='国家编号')),
                ('stateId', models.IntegerField(verbose_name='省份编号')),
                ('cityId', models.IntegerField(verbose_name='城市编号')),
                ('star', models.CharField(default=0, max_length=20, verbose_name='酒店星级')),
                ('hotelNameCn', models.CharField(default='无', max_length=500, verbose_name='酒店中文名')),
                ('hotelNameEn', models.CharField(default='无', max_length=1000, verbose_name='酒店英文名')),
                ('addressCn', models.CharField(default='无', max_length=500, verbose_name='中文地址')),
                ('addressEn', models.CharField(default='无', max_length=1000, verbose_name='英文地址')),
                ('phone', models.CharField(default='无', max_length=100, verbose_name='酒店总机')),
                ('longitude', models.CharField(default='无', max_length=20, verbose_name='经度')),
                ('latitude', models.CharField(default='无', max_length=20, verbose_name='纬度')),
                ('instantConfirmation', models.IntegerField(default=0, verbose_name='是否即时确认')),
                ('sellType', models.IntegerField(default=0, verbose_name='是否热销酒店')),
                ('updateTime', models.CharField(default='无', max_length=100, verbose_name='酒店方的修改时间')),
                ('is_effective', models.IntegerField(choices=[(1, '启用'), (0, '不启用')], default=0, verbose_name='是否启用')),
                ('detail', models.TextField(verbose_name='备注')),
                ('themeType', models.CharField(default='无', max_length=500, verbose_name='酒店主题')),
                ('area', models.IntegerField(default=-1, verbose_name='行政区')),
                ('businessCircle', models.IntegerField(default=-1, verbose_name='商业区')),
                ('fax', models.CharField(default='无', max_length=100, verbose_name='传真')),
                ('email', models.CharField(default='无', max_length=500, verbose_name='邮箱')),
                ('postCode', models.CharField(default='无', max_length=100, verbose_name='邮编号')),
                ('checkPolicy', models.CharField(default='无', max_length=500, verbose_name='酒店入离政策')),
                ('childrenPolicy', models.CharField(default='无', max_length=100, verbose_name='儿童政策')),
                ('petPolicy', models.CharField(default='无', max_length=100, verbose_name='宠物政策')),
                ('establishmentDate', models.CharField(default='无', max_length=200, verbose_name='开业时间')),
                ('renovationDate', models.CharField(default='无', max_length=200, verbose_name='装修时间')),
                ('hotelGroup', models.CharField(default='无', max_length=500, verbose_name='集团')),
                ('hotelBrand', models.CharField(default='无', max_length=500, verbose_name='品牌')),
                ('facilities', models.CharField(default='无', max_length=500, verbose_name='酒店设施')),
                ('cardType', models.CharField(default='无', max_length=500, verbose_name='信用卡')),
                ('minPrice', models.DecimalField(decimal_places=2, default=0.0, max_digits=5, verbose_name='酒店最低价')),
                ('introduceCn', models.CharField(default='无', max_length=500, verbose_name='酒店中文介绍')),
                ('introduceEn', models.CharField(default='无', max_length=500, verbose_name='酒店英文介绍')),
                ('sys_create_time', models.DateTimeField(auto_now_add=True, verbose_name='创建时间')),
                ('sys_update_time', models.DateTimeField(auto_now=True, verbose_name='更新时间')),
                ('ciyt_info', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, to='hotel_admin.City_info')),
                ('sys_create_user', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, to=settings.AUTH_USER_MODEL, verbose_name='创建人')),
            ],
            options={
                'verbose_name': '酒店信息表',
                'verbose_name_plural': '酒店信息表',
                'db_table': 'hotel_info',
                'managed': True,
            },
        ),
        migrations.CreateModel(
            name='Room_info',
            fields=[
                ('id', models.BigAutoField(primary_key=True, serialize=False, verbose_name='编号')),
                ('channel', models.CharField(default='未知', max_length=50, verbose_name='渠道')),
                ('roomTypeId', models.CharField(max_length=50, verbose_name='房型编号')),
                ('roomTypeCn', models.CharField(default='无', max_length=50, verbose_name='客房中文名称')),
                ('roomTypeEn', models.CharField(default='无', max_length=100, verbose_name='客房英文名称')),
                ('basisroomId', models.IntegerField(default=-1, verbose_name='基础房型ID')),
                ('basisroomCn', models.CharField(default='无', max_length=50, verbose_name='基础房型中文名')),
                ('maximize', models.IntegerField(default=-1, verbose_name='最大入住人数')),
                ('acreage', models.CharField(default='无', max_length=50, verbose_name='房间面积')),
                ('bedWidth', models.CharField(default='无', max_length=50, verbose_name='床大小')),
                ('floorDistribute', models.CharField(default='无', max_length=50, verbose_name='楼层')),
                ('facilities', models.CharField(default='无', max_length=50, verbose_name='房型设施')),
                ('extraBedtState', models.CharField(default='无', max_length=50, verbose_name='是否允许加床')),
                ('bedCount', models.IntegerField(default=-1, verbose_name='加床数量')),
                ('bedType', models.CharField(default='', max_length=50, verbose_name='类型')),
                ('bedName', models.CharField(default='', max_length=100, verbose_name='名称')),
                ('sys_create_time', models.DateTimeField(auto_now_add=True, verbose_name='创建时间')),
                ('sys_update_time', models.DateTimeField(auto_now=True, verbose_name='更新时间')),
                ('hotel', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='rooms', to='hotel_admin.Hotel_info', verbose_name='酒店')),
                ('sys_create_user', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, to=settings.AUTH_USER_MODEL, verbose_name='创建人')),
            ],
            options={
                'verbose_name': '房间信息表',
                'verbose_name_plural': '房间信息表',
                'db_table': 'room_info',
                'managed': True,
            },
        ),
        migrations.CreateModel(
            name='Room_image_info',
            fields=[
                ('id', models.BigAutoField(primary_key=True, serialize=False, verbose_name='编号')),
                ('channel', models.CharField(default='未知', max_length=50, verbose_name='渠道')),
                ('imageId', models.CharField(max_length=50, verbose_name='图片编号')),
                ('imagetype', models.CharField(default='无', max_length=50, verbose_name='图片类型')),
                ('roomTypeIds', models.CharField(default='无', max_length=100, verbose_name='图片关联房型')),
                ('thumbUrl', models.CharField(default='无', max_length=1000, verbose_name='缩略图地址')),
                ('imageUrl', models.CharField(default='无', max_length=1000, verbose_name='图片地址')),
                ('imageLogo', models.IntegerField(choices=[(0, '有水印logo'), (1, '无水印logo'), (-1, '未知')], default=-1, verbose_name='是否带水印')),
                ('imageSize', models.IntegerField(choices=[(3, '640 * 960'), (2, '550 * 412'), (0, '未分类'), (1, '350 * 350')], default=0, verbose_name='图片规格')),
                ('sys_create_time', models.DateTimeField(auto_now_add=True, verbose_name='创建时间')),
                ('sys_update_time', models.DateTimeField(auto_now=True, verbose_name='更新时间')),
                ('hotel', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='images', to='hotel_admin.Hotel_info', verbose_name='酒店')),
                ('sys_create_user', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, to=settings.AUTH_USER_MODEL, verbose_name='创建人')),
            ],
            options={
                'verbose_name': '房间图片信息表',
                'verbose_name_plural': '房间图片信息表',
                'db_table': 'room_image_info',
                'managed': True,
            },
        ),
        migrations.CreateModel(
            name='Rate_info',
            fields=[
                ('id', models.BigAutoField(primary_key=True, serialize=False, verbose_name='编号')),
                ('channel', models.CharField(default='未知', max_length=50, verbose_name='渠道')),
                ('rateTypeId', models.CharField(max_length=100, verbose_name='价格类型编号')),
                ('rateTypeCn', models.CharField(max_length=100, verbose_name='价格类型中文名')),
                ('rateTypeEn', models.CharField(max_length=500, verbose_name='价格类型英文名')),
                ('sys_create_time', models.DateTimeField(auto_now_add=True, verbose_name='创建时间')),
                ('sys_update_time', models.DateTimeField(auto_now=True, verbose_name='更新时间')),
                ('hotel', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='rates', to='hotel_admin.Hotel_info', verbose_name='酒店')),
                ('sys_create_user', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, to=settings.AUTH_USER_MODEL, verbose_name='创建人')),
            ],
            options={
                'verbose_name': '价格类型表',
                'verbose_name_plural': '价格类型表',
                'db_table': 'rate_info',
                'managed': True,
            },
        ),
        migrations.CreateModel(
            name='Price_model_info',
            fields=[
                ('price_model_id', models.BigAutoField(primary_key=True, serialize=False)),
                ('name', models.CharField(default='无', max_length=100, verbose_name='名称')),
                ('proportion', models.DecimalField(decimal_places=2, default=1.0, max_digits=5, verbose_name='加价比列')),
                ('level', models.IntegerField(choices=[(2, '自定义'), (1, '节假日'), (0, '默认'), (9, '最高级')], default=0, verbose_name='优先级')),
                ('sys_create_time', models.DateTimeField(auto_now_add=True, verbose_name='创建时间')),
                ('sys_update_time', models.DateTimeField(auto_now=True, verbose_name='更新时间')),
                ('sys_create_user', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, to=settings.AUTH_USER_MODEL, verbose_name='创建人')),
            ],
            options={
                'verbose_name': '加价类型表',
                'verbose_name_plural': '加价类型表',
                'db_table': 'price_model_info',
                'managed': True,
            },
        ),
        migrations.CreateModel(
            name='Order_info',
            fields=[
                ('order_id', models.BigAutoField(primary_key=True, serialize=False)),
                ('room_type', models.CharField(default='无', max_length=100, verbose_name='房型')),
                ('channel', models.CharField(max_length=100, verbose_name='渠道')),
                ('price', models.DecimalField(decimal_places=2, default=0.0, max_digits=5, verbose_name='报价')),
                ('custom_proce', models.DecimalField(decimal_places=2, default=0.0, max_digits=5, verbose_name='强制自定义售价')),
                ('sys_create_time', models.DateTimeField(auto_now_add=True, verbose_name='创建时间')),
                ('sys_update_time', models.DateTimeField(auto_now=True, verbose_name='更新时间')),
                ('hotel', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, to='hotel_admin.Hotel_info', verbose_name='酒店')),
                ('price_model', models.ManyToManyField(to='hotel_admin.Price_model_info', verbose_name='加价类型')),
                ('sys_create_user', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, to=settings.AUTH_USER_MODEL, verbose_name='创建人')),
            ],
            options={
                'verbose_name': '订单信息',
                'verbose_name_plural': '订单信息',
                'db_table': 'order_info',
                'managed': True,
            },
        ),
    ]
