ASJServer/Model/migrations/0001_initial.py

# Generated by Django 2.1.1 on 2018-09-12 03:11

import Model.models
from django.conf import settings
from django.db import migrations, models
import django.db.models.deletion
import imagekit.models.fields


class Migration(migrations.Migration):

    initial = True

    dependencies = [
    ]

    operations = [
        migrations.CreateModel(
            name='Access_Log',
            fields=[
                ('id', models.AutoField(primary_key=True, serialize=False, verbose_name='自增标记ID')),
                ('user', models.CharField(blank=True, max_length=100, null=True, verbose_name='用户')),
                ('operation', models.CharField(blank=True, db_index=True, max_length=100, null=True, verbose_name='操作')),
                ('ip', models.CharField(blank=True, max_length=100, null=True, verbose_name='访问ip地址')),
                ('url', models.CharField(blank=True, max_length=150, null=True, verbose_name='访问路径')),
                ('status', models.IntegerField(blank=True, null=True, verbose_name='状态')),
                ('time', models.DateTimeField(blank=True, db_index=True, null=True, verbose_name='访问时间')),
                ('content', models.TextField(blank=True, null=True, verbose_name='参数内容')),
            ],
            options={
                'verbose_name': '访问日志表',
                'verbose_name_plural': '访问日志表',
                'db_table': 'access_log',
            },
        ),
        migrations.CreateModel(
            name='App_Info',
            fields=[
                ('id', models.AutoField(primary_key=True, serialize=False, verbose_name='自增标记ID')),
                ('appBundleId', models.CharField(blank=True, max_length=32, verbose_name='appID')),
                ('appName', models.CharField(blank=True, max_length=32, verbose_name='app名称')),
                ('systemLanguage', models.CharField(blank=True, max_length=32, verbose_name='系统语言')),
                ('newAppversion', models.CharField(blank=True, max_length=12, verbose_name='系统版本')),
                ('bundleVersion', models.CharField(blank=True, max_length=12, verbose_name='项目版本')),
                ('content', models.TextField(blank=True, null=True, verbose_name='更新内容')),
                ('app_type', models.IntegerField(blank=True, null=True, verbose_name='app类型')),
                ('add_time', models.DateTimeField(auto_now_add=True, null=True, verbose_name='加入时间')),
                ('update_time', models.DateTimeField(auto_now=True, verbose_name='更新时间')),
                ('downloadLink', models.TextField(blank=True, null=True, verbose_name='升级')),
            ],
            options={
                'verbose_name': 'app信息表',
                'verbose_name_plural': 'app信息表',
                'db_table': 'app_info',
                'ordering': ('id',),
            },
        ),
        migrations.CreateModel(
            name='Auth_Captcha',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('username', models.CharField(help_text='用户名(邮箱或电话号码)', max_length=50)),
                ('authcaptca', models.CharField(help_text='验证码', max_length=6)),
                ('sendtype', models.CharField(choices=[('register', '注册'), ('forget', '找回密码')], max_length=15)),
                ('sendtime', models.DateTimeField(auto_now_add=True)),
            ],
            options={
                'verbose_name': '邮箱验证码',
                'verbose_name_plural': '邮箱验证码',
                'db_table': 'auth_captcha',
                'ordering': ('-sendtime',),
            },
        ),
        migrations.CreateModel(
            name='Device_Info',
            fields=[
                ('id', models.CharField(blank=True, max_length=32, primary_key=True, serialize=False)),
                ('NickName', models.CharField(blank=True, max_length=32, verbose_name='设备名称')),
                ('UID', models.CharField(blank=True, max_length=32, verbose_name='设备UID')),
                ('SID', models.CharField(blank=True, max_length=32, verbose_name='服务器ID')),
                ('View_Account', models.CharField(blank=True, max_length=32, verbose_name='设备用户名称')),
                ('View_Password', models.CharField(blank=True, max_length=32, verbose_name='设备密码')),
                ('AudioFormat', models.IntegerField(blank=True, default=1, verbose_name='初始化影像')),
                ('EventNotification', models.IntegerField(blank=True, verbose_name='报警类型')),
                ('ChannelIndex', models.IntegerField(blank=True, verbose_name='通道号')),
                ('Online', models.BooleanField(blank=True, default=False, verbose_name='设备是否在线')),
                ('mMonitorIndex', models.IntegerField(blank=True, default=-1)),
                ('Type', models.IntegerField(blank=True)),
                ('DebugMode', models.IntegerField(blank=True, verbose_name='调试模式')),
                ('NotificationMode', models.IntegerField(blank=True, verbose_name='是否报警')),
                ('qvgaLevel', models.BooleanField(blank=True, default=0, help_text='0代表：SD、1代表：HD', verbose_name='SD与HD画面')),
                ('isShare', models.BooleanField(blank=True, default=False, help_text='是否为共享获取的设备', verbose_name='共享设备')),
                ('primaryUserID', models.CharField(blank=True, default='', help_text='该设备的主用户', max_length=32, verbose_name='主用户')),
                ('data_joined', models.DateTimeField(auto_now_add=True, verbose_name='设备添加时间')),
                ('update_time', models.DateTimeField(auto_now=True, null=True, verbose_name='更新时间')),
                ('ip', models.CharField(blank=True, max_length=100, null=True, verbose_name='设备区域ip')),
                ('area', models.CharField(blank=True, max_length=100, null=True, verbose_name='设备区域area')),
            ],
            options={
                'verbose_name': '用户设备信息表',
                'verbose_name_plural': '用户设备信息表',
                'db_table': 'device_info',
                'ordering': ('-data_joined',),
            },
        ),
        migrations.CreateModel(
            name='Device_Meal',
            fields=[
                ('id', models.AutoField(primary_key=True, serialize=False, verbose_name='自增标记ID')),
                ('status', models.IntegerField(blank=True, null=True, verbose_name='状态')),
                ('uid', models.CharField(blank=True, max_length=32, null=True, verbose_name='设备ID')),
                ('channel', models.IntegerField(blank=True, null=True, verbose_name='设备通道')),
                ('add_time', models.DateTimeField(auto_now_add=True, null=True, verbose_name='加入时间')),
                ('update_time', models.DateTimeField(auto_now=True, verbose_name='更新时间')),
                ('end_time', models.DateTimeField(blank=True, verbose_name='最后时间')),
            ],
            options={
                'verbose_name': '设备关联套餐表',
                'verbose_name_plural': '设备关联套餐表',
                'db_table': 'device_meal',
                'ordering': ('id',),
            },
        ),
        migrations.CreateModel(
            name='Email_Captcha',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('userCaptcha', models.CharField(max_length=10, verbose_name='验证码')),
                ('userEmail', models.EmailField(max_length=50, verbose_name='邮箱')),
                ('sendType', models.CharField(choices=[('register', '注册'), ('forget', '找回密码')], max_length=15)),
                ('sendTime', models.DateField(auto_now_add=True)),
            ],
            options={
                'verbose_name': '邮箱验证码',
                'verbose_name_plural': '邮箱验证码',
                'db_table': 'email_captcha',
                'ordering': ('-sendTime',),
            },
        ),
        migrations.CreateModel(
            name='Equipment_Info',
            fields=[
                ('id', models.AutoField(primary_key=True, serialize=False, verbose_name='自增标记ID')),
                ('devUid', models.CharField(blank=True, max_length=32, null=True, verbose_name='设备ID')),
                ('devNickName', models.CharField(blank=True, default='', max_length=32, verbose_name='设备昵称')),
                ('Channel', models.IntegerField(blank=True, null=True, verbose_name='设备通道')),
                ('eventType', models.IntegerField(blank=True, null=True, verbose_name='事件类型')),
                ('viewAccont', models.CharField(blank=True, max_length=32, null=True, verbose_name='设备账户')),
                ('viewPwd', models.CharField(blank=True, max_length=32, null=True, verbose_name='设备密码')),
                ('status', models.BooleanField(blank=True, default=False, verbose_name='事件状态')),
                ('alarm', models.CharField(blank=True, max_length=256, verbose_name='报警信息')),
                ('eventTime', models.CharField(blank=True, max_length=16, null=True, verbose_name='设备报警时间')),
                ('receiveTime', models.CharField(blank=True, max_length=16, null=True, verbose_name='接收到报警时间')),
            ],
            options={
                'verbose_name': '设备信息推送表',
                'verbose_name_plural': '设备信息推送表',
                'db_table': 'equipment_info',
                'ordering': ('-id',),
            },
        ),
        migrations.CreateModel(
            name='Equipment_Sensor',
            fields=[
                ('id', models.AutoField(primary_key=True, serialize=False, verbose_name='自增标记ID')),
                ('status', models.IntegerField(blank=True, null=True, verbose_name='状态')),
                ('type', models.IntegerField(blank=True, null=True, verbose_name='类型')),
                ('name', models.CharField(blank=True, max_length=128, null=True, verbose_name='传感器名称')),
                ('add_time', models.DateTimeField(auto_now_add=True, null=True, verbose_name='加入时间')),
                ('update_time', models.DateTimeField(auto_now=True, verbose_name='更新时间')),
                ('uid', models.CharField(blank=True, max_length=32, null=True, verbose_name='设备ID')),
            ],
            options={
                'verbose_name': '设备传感器表',
                'verbose_name_plural': '设备传感器表',
                'db_table': 'equipment_sensor',
                'ordering': ('id',),
            },
        ),
        migrations.CreateModel(
            name='Equipment_Stream',
            fields=[
                ('id', models.AutoField(primary_key=True, serialize=False, verbose_name='自增标记ID')),
                ('userID', models.CharField(blank=True, max_length=32, verbose_name='用户ID')),
                ('status', models.IntegerField(blank=True, null=True, verbose_name='状态')),
                ('uid', models.CharField(blank=True, max_length=32, null=True, verbose_name='设备ID')),
                ('channel', models.IntegerField(blank=True, null=True, verbose_name='设备通道')),
                ('access_token', models.CharField(blank=True, max_length=128, verbose_name='设备推流验证令牌')),
                ('total_flow', models.FloatField(blank=True, null=True, verbose_name='传输总容量')),
                ('add_time', models.DateTimeField(auto_now_add=True, null=True, verbose_name='加入时间')),
                ('update_time', models.DateTimeField(auto_now=True, verbose_name='更新时间')),
                ('rank', models.IntegerField(blank=True, null=True, verbose_name='推流套餐类型')),
            ],
            options={
                'verbose_name': '用户设备推流表',
                'verbose_name_plural': '用户设备推流表',
                'db_table': 'equipment_stream',
            },
        ),
        migrations.CreateModel(
            name='Equipment_Version',
            fields=[
                ('eid', models.CharField(blank=True, max_length=32, primary_key=True, serialize=False)),
                ('ESN', models.CharField(blank=True, max_length=32, verbose_name='设备规格名称')),
                ('code', models.CharField(blank=True, max_length=32, verbose_name='设备规格代码')),
                ('version', models.CharField(blank=True, max_length=32, verbose_name='设备版本')),
                ('softwareVersion', models.CharField(blank=True, max_length=32, verbose_name='软件本版本')),
                ('chipModelList2Code', models.CharField(blank=True, max_length=32, verbose_name='主芯片码')),
                ('channel', models.IntegerField(blank=True, verbose_name='通道数')),
                ('resolutionRatio', models.IntegerField(blank=True, verbose_name='分辨率')),
                ('type', models.CharField(blank=True, max_length=16, verbose_name='设备机型')),
                ('companyCode', models.CharField(blank=True, max_length=128, verbose_name='用户公司名称')),
                ('data_joined', models.DateTimeField(auto_now_add=True, verbose_name='加入时间')),
                ('fileSize', models.IntegerField(blank=True, verbose_name='文件总大小')),
                ('filePath', models.CharField(blank=True, max_length=256, verbose_name='升级文件路径')),
                ('Description', models.TextField(blank=True, default='', verbose_name='描述信息')),
                ('fileMd5', models.CharField(blank=True, max_length=32, null=True, verbose_name='上传文件MD5加密')),
                ('status', models.BooleanField(blank=True, default=True, verbose_name='是否开启更新状态')),
                ('update_time', models.DateTimeField(auto_now=True, verbose_name='更新时间')),
            ],
            options={
                'verbose_name': '设备版本信息',
                'db_table': 'equipment_version',
                'ordering': ('-data_joined',),
            },
        ),
        migrations.CreateModel(
            name='Feedback_Info',
            fields=[
                ('id', models.AutoField(primary_key=True, serialize=False, verbose_name='自增标记ID')),
                ('userID', models.CharField(blank=True, max_length=32, verbose_name='用户ID')),
                ('status', models.BooleanField(blank=True, default=False, verbose_name='状态:0未解决/解决')),
                ('content', models.TextField(blank=True, null=True, verbose_name='反馈描述')),
                ('add_time', models.DateTimeField(auto_now_add=True, null=True, verbose_name='加入时间/反馈时间')),
                ('update_time', models.DateTimeField(auto_now=True, verbose_name='更新时间')),
            ],
            options={
                'verbose_name': '用户反馈信息表',
                'verbose_name_plural': '用户反馈信息表',
                'db_table': 'feedback_info',
                'ordering': ('id',),
            },
        ),
        migrations.CreateModel(
            name='oauth_user',
            fields=[
                ('id', models.AutoField(primary_key=True, serialize=False, verbose_name='自增标记ID')),
                ('oid', models.CharField(blank=True, max_length=36, null=True, unique=True)),
                ('add_time', models.DateTimeField(auto_now_add=True, null=True, verbose_name='加入时间')),
                ('update_time', models.DateTimeField(auto_now=True, verbose_name='更新时间')),
            ],
            options={
                'verbose_name': '认证用户关联表',
                'verbose_name_plural': '认证用户关联表',
                'db_table': 'oauth_user',
                'ordering': ('id',),
            },
        ),
        migrations.CreateModel(
            name='Permissions',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('permName', models.CharField(blank=True, max_length=32, null=True, unique=True, verbose_name='权限名称')),
                ('description', models.CharField(blank=True, default='', max_length=128, null=True, verbose_name='描述信息')),
            ],
            options={
                'verbose_name': 'role permission',
                'verbose_name_plural': 'role permission',
                'db_table': 'permissions',
                'ordering': ['permName'],
            },
            managers=[
                ('objects', Model.models.PermissionsManager()),
            ],
        ),
        migrations.CreateModel(
            name='Role',
            fields=[
                ('rid', models.SmallIntegerField(primary_key=True, serialize=False, unique=True, verbose_name='用户角色组ID')),
                ('roleName', models.CharField(choices=[('Guests', 'Guests'), ('Users', 'Users'), ('Admins', 'Admins'), ('SysAdmins', 'SysAdmins'), ('LOGAdmins', 'LOGAdmins'), ('OTAAdmins', 'OTAAdmins'), ('DBAAdmins', 'DBAAdmins'), ('SuperAdmins', 'SuperAdmins')], default='User', max_length=32, unique=True, verbose_name='角色名称')),
                ('Description', models.TextField(blank=True, default='', verbose_name='描述信息')),
                ('permission', models.ManyToManyField(blank=True, db_table='role_permissions', to='Model.Permissions', verbose_name='权限')),
            ],
            options={
                'verbose_name': '用户角色',
                'verbose_name_plural': '用户角色',
                'db_table': 'role',
                'ordering': ['roleName'],
            },
            managers=[
                ('objects', Model.models.RoleManager()),
            ],
        ),
        migrations.CreateModel(
            name='Store_Meal',
            fields=[
                ('id', models.AutoField(primary_key=True, serialize=False, verbose_name='自增ID')),
                ('title', models.CharField(blank=True, max_length=32, verbose_name='标题')),
                ('price', models.CharField(blank=True, max_length=32, verbose_name='价格')),
                ('day', models.IntegerField(blank=True, null=True, verbose_name='存储时间')),
                ('content', models.TextField(blank=True, null=True, verbose_name='描述')),
                ('add_time', models.DateTimeField(auto_now_add=True, null=True, verbose_name='加入时间')),
                ('update_time', models.DateTimeField(auto_now=True, verbose_name='更新时间')),
            ],
            options={
                'verbose_name': '存储套餐',
                'verbose_name_plural': '存储套餐',
                'db_table': 'store_meal',
                'ordering': ('id',),
            },
        ),
        migrations.CreateModel(
            name='Device_User',
            fields=[
                ('userID', models.CharField(blank=True, default='153672190513592013800138000', max_length=32, primary_key=True, serialize=False, unique=True, verbose_name='用户ID')),
                ('username', models.CharField(max_length=40, unique=True, verbose_name='用户名')),
                ('password', models.CharField(max_length=128, verbose_name='密码')),
                ('userEmail', models.EmailField(blank=True, max_length=64, null=True, unique=True, verbose_name='邮箱')),
                ('userIconPath', imagekit.models.fields.ProcessedImageField(blank=True, default='static/User/default.png', upload_to='User/Images/', verbose_name='头像')),
                ('userIconUrl', models.URLField(blank=True, default='http://192.168.136.45:8077/account/getAvatar/User/defaultUser.png', max_length=128)),
                ('NickName', models.CharField(blank=True, default='', max_length=32, verbose_name='用户昵称')),
                ('is_superuser', models.IntegerField(blank=True, default=0, verbose_name='用户类型')),
                ('is_active', models.BooleanField(blank=True, default=False, verbose_name='用户活动状态')),
                ('data_joined', models.DateTimeField(auto_now_add=True, verbose_name='加入时间')),
                ('last_login', models.DateTimeField(auto_now=True, verbose_name='u最后登录时间')),
                ('user_isValid', models.BooleanField(blank=True, default=False, help_text='是否是认证通过的用户', verbose_name='用户有效性')),
                ('online', models.BooleanField(blank=True, default=False, verbose_name='用户登录状态')),
                ('machine_code', models.CharField(blank=True, default='', max_length=128, verbose_name='机械码')),
                ('language', models.CharField(blank=True, default='', max_length=16, null=True, verbose_name='语言地区')),
            ],
            options={
                'verbose_name': '用户信息',
                'db_table': 'device_user',
                'ordering': ('-data_joined',),
                'get_latest_by': 'last_login',
            },
        ),
        migrations.CreateModel(
            name='AuthToken_JWT',
            fields=[
                ('jwtID', models.OneToOneField(blank=True, on_delete=django.db.models.deletion.CASCADE, primary_key=True, serialize=False, to=settings.AUTH_USER_MODEL, verbose_name='token userID')),
                ('access_token', models.CharField(blank=True, max_length=384, verbose_name='Access Token')),
                ('refresh_token', models.CharField(blank=True, max_length=384, verbose_name='Refresh Token')),
                ('secret', models.CharField(blank=True, max_length=32, verbose_name='Secret')),
                ('last_update', models.DateTimeField(auto_now=True, verbose_name='Last Update')),
            ],
            options={
                'verbose_name': '用户JWT',
                'verbose_name_plural': '用户JWT',
                'db_table': 'authtoken_jwt',
                'ordering': ('-last_update',),
            },
        ),
        migrations.CreateModel(
            name='AuthToken_Token',
            fields=[
                ('tokenID', models.OneToOneField(blank=True, on_delete=django.db.models.deletion.CASCADE, primary_key=True, serialize=False, to=settings.AUTH_USER_MODEL)),
                ('access_token', models.CharField(blank=True, max_length=256)),
                ('refresh_token', models.CharField(blank=True, max_length=256)),
                ('last_update', models.DateTimeField(auto_now=True)),
                ('iCode', models.CharField(blank=True, max_length=12, verbose_name='干扰码')),
                ('mCode', models.CharField(blank=True, max_length=64, verbose_name='设备码')),
            ],
            options={
                'verbose_name': '用户Token',
                'db_table': 'authtoken_token',
                'ordering': ('-last_update',),
            },
        ),
        migrations.AddField(
            model_name='device_user',
            name='role',
            field=models.ManyToManyField(blank=True, db_table='user_role', to='Model.Role', verbose_name='用户角色'),
        ),
        migrations.AlterUniqueTogether(
            name='permissions',
            unique_together={('permName',)},
        ),
        migrations.AddField(
            model_name='oauth_user',
            name='userID',
            field=models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL, verbose_name='用户表userID'),
        ),
        migrations.AddField(
            model_name='equipment_info',
            name='userID',
            field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL),
        ),
        migrations.AddField(
            model_name='device_meal',
            name='rank',
            field=models.ForeignKey(blank=True, on_delete=django.db.models.deletion.CASCADE, to='Model.Store_Meal', verbose_name='套餐类型'),
        ),
        migrations.AddField(
            model_name='device_info',
            name='userID',
            field=models.ForeignKey(blank=True, on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL),
        ),
    ]