class InceptionWorkOrderInfo(models.Model):
id = models.AutoField(primary_key=True)
work_order_id = models.BigIntegerField(unique=True)
work_user = models.CharField(max_length=50)
db_host = models.CharField(max_length=45)
db_name = models.CharField(max_length=50, default='test_db')
end_time = models.DateTimeField(default='1980-01-01 01:01:01')
review_user = models.CharField(max_length=50)
review_time = models.DateTimeField(default='1980-01-01 01:01:01')
review_status = models.TinyIntegerField(
default=10) # 10表示未审核， 0 表示通过， 1表示驳回
work_status = models.TinyIntegerField(
default=10) # 10表示未执行， 0 表示执行成功， 1表示执行失败, 2.进行执行队列， 3, 正在执行
r_time = models.DateTimeField(auto_now_add=True)
class Meta:
db_table = 'dbms_ince_work_order_info'
class UserHostRelationship(models.Model):
user_group = models.ForeignKey('UserGroup', db_constraint=False)
host_group = models.ForeignKey('HostGroup', db_constraint=False)
lifetime = models.SmallIntegerField()
expired = models.TinyIntegerField()
class Meta:
db_table = 'cmdb_user_host_relationship'
unique_together = ('user_group', 'host_group')
class AuthPermissions(models.Model):
select_host = models.TinyIntegerField()
update_host = models.TinyIntegerField()
insert_host = models.TinyIntegerField()
delete_host = models.TinyIntegerField()
select_user = models.TinyIntegerField()
update_user = models.TinyIntegerField()
delete_user = models.TinyIntegerField()
insert_user = models.TinyIntegerField()
class Meta:
db_table = 'cmdb_auth_permissions'
class BackupedInfo(models.Model):
id = models.AutoField(primary_key=True)
machine_id = models.ForeignKey('MysqlBackupSourceInfo',
on_delete=models.CASCADE,
db_constraint=False)
backup_name = models.CharField(max_length=100)
backup_file_path = models.CharField(max_length=100)
backup_druation = models.UnsignedSmallIntegerField()
backup_status = models.TinyIntegerField()
binlog_file_path = models.CharField(max_length=100)
binlog_index = models.CharField(max_length=100)
binlog_start = models.CharField(max_length=50)
binlog_end = models.CharField(max_length=50)
binlog_backup_status = models.TinyIntegerField(default=0)
binlog_backup_piece = models.CharField(max_length=50)
r_time = models.DateTimeField(auto_now_add=True)
class Meta:
db_table = 'dbms_mysql_backuped_info'
index_together = ('machine_id', 'r_time', 'backup_status')
class MysqlBackupSourceInfo(models.Model):
id = models.AutoField(primary_key=True)
generator_room_name = models.CharField(max_length=30)
ipaddr = models.UnsignedIntegerField()
port = models.UnsignedSmallIntegerField()
service_level = models.TinyIntegerField()
defaults_file = models.CharField(max_length=100)
back_time = models.TimeField()
transport_time = models.TimeField(default='1980-01-01 01:01:01')
is_transport = models.SmallIntegerField(default=0)
back_pool_id = models.ForeignKey('BackupPoolInfo',
on_delete=models.CASCADE,
db_constraint=False)
r_time = models.DateTimeField(auto_now_add=True)
class Meta:
db_table = 'dbms_mysql_backup_source_info'
unique_together = ('generator_room_name', 'ipaddr', 'port')
class Migration(migrations.Migration):
initial = True
dependencies = []
operations = [
migrations.CreateModel(
name='AppType',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('app_name', models.CharField(max_length=30, unique=True)),
],
options={
'db_table': 'cmdb_app_type',
},
),
migrations.CreateModel(
name='AuthGroupPermissions',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
],
options={
'db_table': 'cmdb_auth_group_permissions',
},
),
migrations.CreateModel(
name='AuthPermissions',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('select_host', models.TinyIntegerField()),
('update_host', models.TinyIntegerField()),
('insert_host', models.TinyIntegerField()),
('delete_host', models.TinyIntegerField()),
('select_user', models.TinyIntegerField()),
('update_user', models.TinyIntegerField()),
('delete_user', models.TinyIntegerField()),
('insert_user', models.TinyIntegerField()),
],
options={
'db_table': 'cmdb_auth_permissions',
},
),
migrations.CreateModel(
name='HostGroup',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('host_group_name', models.CharField(max_length=50,
unique=True)),
('host_group_jd', models.CharField(max_length=50)),
],
options={
'db_table': 'cmdb_host_group',
},
),
migrations.CreateModel(
name='HostInfo',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('host_ip', models.UnsignedIntegerField(unique=True)),
('host_user', models.CharField(max_length=20)),
('host_pass', models.CharField(max_length=30)),
('host_port', models.SmallIntegerField()),
('app_type',
models.ForeignKey(db_constraint=False,
on_delete=django.db.models.deletion.CASCADE,
to='cmdb.AppType')),
('host_group',
models.ForeignKey(db_constraint=False,
on_delete=django.db.models.deletion.CASCADE,
to='cmdb.HostGroup')),
],
options={
'db_table': 'cmdb_host_info',
},
),
migrations.CreateModel(
name='HostInfoAuth',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('app_user', models.CharField(max_length=20)),
('app_pass', models.CharField(max_length=30)),
('app_port', models.SmallIntegerField()),
('host',
models.ForeignKey(db_constraint=False,
on_delete=django.db.models.deletion.CASCADE,
to='cmdb.HostInfo')),
],
options={
'db_table': 'cmdb_host_auth',
},
),
migrations.CreateModel(
name='UserGroup',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('user_group_name', models.CharField(max_length=50,
unique=True)),
('user_group_jd', models.CharField(max_length=50)),
],
options={
'db_table': 'cmdb_user_group',
},
),
migrations.CreateModel(
name='UserHostRelationship',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('lifetime', models.SmallIntegerField()),
('expired', models.TinyIntegerField()),
('host_group',
models.ForeignKey(db_constraint=False,
on_delete=django.db.models.deletion.CASCADE,
to='cmdb.HostGroup')),
('user_group',
models.ForeignKey(db_constraint=False,
on_delete=django.db.models.deletion.CASCADE,
to='cmdb.UserGroup')),
],
options={
'db_table': 'cmdb_user_host_relationship',
},
),
migrations.CreateModel(
name='UserInfo',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('user_name', models.CharField(max_length=40, unique=True)),
('user_pass', models.CharField(max_length=96)),
('user_emails', models.CharField(max_length=100)),
('permission',
models.ForeignKey(db_constraint=False,
on_delete=django.db.models.deletion.CASCADE,
to='cmdb.AuthPermissions')),
],
options={
'db_table': 'cmdb_user_info',
},
),
migrations.CreateModel(
name='UserRole',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('user_role_name', models.CharField(max_length=50,
unique=True)),
('user_role_jd', models.CharField(max_length=50)),
],
options={
'db_table': 'cmdb_user_role',
},
),
migrations.AddField(
model_name='userinfo',
name='role',
field=models.ForeignKey(
db_constraint=False,
on_delete=django.db.models.deletion.CASCADE,
to='cmdb.UserRole'),
),
migrations.AddField(
model_name='userinfo',
name='user_group',
field=models.ForeignKey(
db_constraint=False,
on_delete=django.db.models.deletion.CASCADE,
to='cmdb.UserGroup'),
),
migrations.AddField(
model_name='authgrouppermissions',
name='permission',
field=models.ForeignKey(
db_constraint=False,
on_delete=django.db.models.deletion.CASCADE,
to='cmdb.AuthPermissions'),
),
migrations.AddField(
model_name='authgrouppermissions',
name='user_group',
field=models.ForeignKey(
db_constraint=False,
on_delete=django.db.models.deletion.CASCADE,
to='cmdb.UserGroup'),
),
migrations.AlterUniqueTogether(
name='userhostrelationship',
unique_together=set([('user_group', 'host_group')]),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = []
operations = [
migrations.CreateModel(
name='BackupedBinlogInfo',
fields=[
('id', models.AutoField(primary_key=True, serialize=False)),
('binlog_name', models.CharField(max_length=50)),
('binlog_create_time', models.DateTimeField()),
('binlog_size', models.UnsignedSmallIntegerField()),
('r_time', models.DateTimeField(auto_now_add=True)),
],
options={
'db_table': 'dbms_mysql_backuped_binlog_info',
},
),
migrations.CreateModel(
name='BackupedInfo',
fields=[
('id', models.AutoField(primary_key=True, serialize=False)),
('backup_name', models.CharField(max_length=100)),
('backup_file_path', models.CharField(max_length=100)),
('backup_druation', models.UnsignedSmallIntegerField()),
('backup_status', models.TinyIntegerField()),
('binlog_file_path', models.CharField(max_length=100)),
('binlog_index', models.CharField(max_length=100)),
('binlog_start', models.CharField(max_length=50)),
('binlog_end', models.CharField(max_length=50)),
('binlog_backup_status', models.TinyIntegerField(default=0)),
('binlog_backup_piece', models.CharField(max_length=50)),
('r_time', models.DateTimeField(auto_now_add=True)),
],
options={
'db_table': 'dbms_mysql_backuped_info',
},
),
migrations.CreateModel(
name='BackupPoolInfo',
fields=[
('id', models.AutoField(primary_key=True, serialize=False)),
('pool_name', models.CharField(max_length=50)),
('ipaddr', models.IntegerField()),
('port', models.UnsignedSmallIntegerField()),
('passwd', models.CharField(max_length=50)),
('username', models.CharField(max_length=50)),
],
options={
'db_table': 'dbms_mysql_backup_pool_source_info',
},
),
migrations.CreateModel(
name='InceptionAuditDetail',
fields=[
('id', models.AutoField(primary_key=True, serialize=False)),
('sql_sid', models.UnsignedSmallIntegerField()),
('status', models.UnsignedSmallIntegerField()),
('err_id', models.UnsignedSmallIntegerField()),
('stage_status', models.UnsignedSmallIntegerField()),
('error_msg', models.CharField(max_length=1000)),
('sql_content', models.CharField(max_length=1000)),
('aff_row', models.UnsignedSmallIntegerField()),
('rollback_id', models.CharField(max_length=50)),
('backup_dbname', models.CharField(max_length=100)),
('execute_time', models.IntegerField()),
('sql_hash', models.CharField(max_length=50)),
('r_time', models.DateTimeField(auto_now_add=True)),
],
options={
'db_table': 'dbms_ince_audit_detail',
},
),
migrations.CreateModel(
name='InceptionWorkOrderInfo',
fields=[
('id', models.AutoField(primary_key=True, serialize=False)),
('work_order_id', models.BigIntegerField(unique=True)),
('work_user', models.CharField(max_length=50)),
('db_host', models.UnsignedIntegerField(default='1000000')),
('db_name', models.CharField(default='test_db',
max_length=50)),
('end_time',
models.DateTimeField(default='1980-01-01 01:01:01')),
('review_user', models.CharField(max_length=50)),
('review_time',
models.DateTimeField(default='1980-01-01 01:01:01')),
('review_status', models.TinyIntegerField(default=10)),
('work_status', models.TinyIntegerField(default=10)),
('r_time', models.DateTimeField(auto_now_add=True)),
],
options={
'db_table': 'dbms_ince_work_order_info',
},
),
migrations.CreateModel(
name='InceptionWorkSQL',
fields=[
('id', models.AutoField(primary_key=True, serialize=False)),
('sql_content', models.TextField()),
('work_order',
models.ForeignKey(db_constraint=False,
on_delete=django.db.models.deletion.CASCADE,
to='dbms.InceptionWorkOrderInfo',
to_field='work_order_id')),
],
options={
'db_table': 'dbms_ince_work_sql_content',
},
),
migrations.CreateModel(
name='MysqlBackupSourceInfo',
fields=[
('id', models.AutoField(primary_key=True, serialize=False)),
('generator_room_name', models.CharField(max_length=30)),
('ipaddr', models.UnsignedIntegerField()),
('port', models.UnsignedSmallIntegerField()),
('service_level', models.TinyIntegerField()),
('defaults_file', models.CharField(max_length=100)),
('back_time', models.TimeField()),
('transport_time',
models.TimeField(default='1980-01-01 01:01:01')),
('is_transport', models.SmallIntegerField(default=0)),
('r_time', models.DateTimeField(auto_now_add=True)),
('back_pool_id',
models.ForeignKey(db_constraint=False,
on_delete=django.db.models.deletion.CASCADE,
to='dbms.BackupPoolInfo')),
],
options={
'db_table': 'dbms_mysql_backup_source_info',
},
),
migrations.AddField(
model_name='inceptionauditdetail',
name='work_order',
field=models.ForeignKey(
db_constraint=False,
on_delete=django.db.models.deletion.CASCADE,
to='dbms.InceptionWorkOrderInfo',
to_field='work_order_id'),
),
migrations.AddField(
model_name='backupedinfo',
name='machine_id',
field=models.ForeignKey(
db_constraint=False,
on_delete=django.db.models.deletion.CASCADE,
to='dbms.MysqlBackupSourceInfo'),
),
migrations.AddField(
model_name='backupedbinloginfo',
name='machine_id',
field=models.ForeignKey(
db_constraint=False,
on_delete=django.db.models.deletion.CASCADE,
to='dbms.MysqlBackupSourceInfo'),
),
migrations.AlterUniqueTogether(
name='mysqlbackupsourceinfo',
unique_together=set([('generator_room_name', 'ipaddr', 'port')]),
),
migrations.AlterIndexTogether(
name='backupedinfo',
index_together=set([('machine_id', 'r_time', 'backup_status')]),
),
migrations.AlterIndexTogether(
name='backupedbinloginfo',
index_together=set([('machine_id', 'r_time')]),
),
]