class Migration(migrations.Migration):
initial = True
dependencies = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
]
operations = [
migrations.CreateModel(
name='Category',
fields=[
('cid', models.IntegerField(primary_key=True,
serialize=False)),
('name', models.CharField(max_length=2048)),
('is_parent', models.IntegerField(default=0)),
('parent_id', models.IntegerField(default=0)),
('level', models.IntegerField(default=0)),
('pathid', models.CharField(max_length=2048, null=True)),
('path', models.CharField(max_length=2048, null=True)),
],
options={
'db_table': 'wp_ex_source_goods_tb_cat_copy',
},
),
migrations.CreateModel(
name='Good',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('created_at',
models.DateTimeField(auto_now_add=True, verbose_name='建立时间')),
('updated_at',
models.DateTimeField(auto_now=True, verbose_name='更新时间')),
('deleted_at',
models.DateTimeField(null=True, verbose_name='删除时间')),
('hcode', models.CharField(default='', max_length=16)),
('code', models.IntegerField(default=0)),
('name', models.CharField(max_length=1024)),
('shiling',
models.IntegerField(choices=[(0, '夏季'), (1, '冬季'), (2,
'常规')])),
('jibie',
models.IntegerField(choices=[(0, '普通'), (1, '重点'), (2, '核心')],
default=0)),
('pifa',
models.IntegerField(choices=[(0, '不可批发'), (1, '可批发')],
default=0)),
('state_caigou',
models.IntegerField(choices=[
(0, '待评审'), (1, '通过评审'),
(2, '终止'), (3, '待采购'), (4, '待入库'), (5, '待拍摄'), (6, '待制作'),
(7, '待上架'), (8, '已上架'), (9, '待淘汰'), (10, '退市'),
(11, '待封存'), (12, '待启封')
],
default=0)),
('state_paishe',
models.IntegerField(choices=[
(0, '待评审'), (1, '通过评审'),
(2, '终止'), (3, '待采购'), (4, '待入库'), (5, '待拍摄'), (6, '待制作'),
(7, '待上架'), (8, '已上架'), (9, '待淘汰'), (10, '退市'),
(11, '待封存'), (12, '待启封')
],
default=0)),
('desc', models.TextField()),
],
options={
'abstract': False,
},
),
migrations.CreateModel(
name='GoodsBrand',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('created_at',
models.DateTimeField(auto_now_add=True, verbose_name='建立时间')),
('updated_at',
models.DateTimeField(auto_now=True, verbose_name='更新时间')),
('deleted_at',
models.DateTimeField(null=True, verbose_name='删除时间')),
('code', models.CharField(max_length=32, null=True)),
('name', models.CharField(max_length=64, null=True)),
],
options={
'abstract': False,
},
),
migrations.CreateModel(
name='Supplier',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('created_at',
models.DateTimeField(auto_now_add=True, verbose_name='建立时间')),
('updated_at',
models.DateTimeField(auto_now=True, verbose_name='更新时间')),
('deleted_at',
models.DateTimeField(null=True, verbose_name='删除时间')),
('code', models.CharField(max_length=64)),
('name', models.CharField(max_length=64)),
('concat', models.CharField(max_length=64)),
('address', models.CharField(max_length=1024)),
('phone', models.CharField(max_length=32)),
('telephone', models.CharField(max_length=32)),
('email', models.CharField(max_length=64)),
('note', models.CharField(max_length=1024)),
],
options={
'abstract': False,
},
),
migrations.CreateModel(
name='TagChangjing',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('created_at',
models.DateTimeField(auto_now_add=True, verbose_name='建立时间')),
('updated_at',
models.DateTimeField(auto_now=True, verbose_name='更新时间')),
('deleted_at',
models.DateTimeField(null=True, verbose_name='删除时间')),
('name', models.CharField(max_length=32)),
],
options={
'abstract': False,
},
),
migrations.CreateModel(
name='TagDingwei',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('created_at',
models.DateTimeField(auto_now_add=True, verbose_name='建立时间')),
('updated_at',
models.DateTimeField(auto_now=True, verbose_name='更新时间')),
('deleted_at',
models.DateTimeField(null=True, verbose_name='删除时间')),
('name', models.CharField(max_length=32)),
],
options={
'abstract': False,
},
),
migrations.CreateModel(
name='SupplierChange',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('created_at',
models.DateTimeField(auto_now_add=True, verbose_name='建立时间')),
('updated_at',
models.DateTimeField(auto_now=True, verbose_name='更新时间')),
('deleted_at',
models.DateTimeField(null=True, verbose_name='删除时间')),
('good',
models.ForeignKey(null=True,
on_delete=django.db.models.deletion.CASCADE,
related_name='goods_supplier_change',
to='cpm.Good')),
('now_supplier',
models.ForeignKey(
null=True,
on_delete=django.db.models.deletion.SET_NULL,
related_name='goods_supplier_now_supplier',
to='cpm.Supplier')),
('raw_supplier',
models.ForeignKey(
null=True,
on_delete=django.db.models.deletion.SET_NULL,
related_name='goods_supplier_raw_supplier',
to='cpm.Supplier')),
],
options={
'abstract': False,
},
),
migrations.CreateModel(
name='GoodsSku',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('created_at',
models.DateTimeField(auto_now_add=True, verbose_name='建立时间')),
('updated_at',
models.DateTimeField(auto_now=True, verbose_name='更新时间')),
('deleted_at',
models.DateTimeField(null=True, verbose_name='删除时间')),
('sku_code', models.CharField(max_length=32)),
('sku_name', models.CharField(max_length=32)),
('sku_image', models.CharField(max_length=128)),
('length', models.CharField(max_length=32, null=True)),
('width', models.CharField(max_length=32, null=True)),
('height', models.CharField(max_length=32, null=True)),
('weight', models.CharField(max_length=32, null=True)),
('desc', models.CharField(max_length=1024, null=True)),
('price_jin', models.IntegerField(default=0)),
('price_pifa', models.IntegerField(default=0)),
('price_sale', models.IntegerField(default=0)),
('date_market', models.DateTimeField(null=True)),
('sku_good',
models.ForeignKey(
null=True,
on_delete=django.db.models.deletion.SET_NULL,
to='cpm.Good')),
],
options={
'abstract': False,
},
),
migrations.CreateModel(
name='GoodsSelectPhase',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('created_at',
models.DateTimeField(auto_now_add=True, verbose_name='建立时间')),
('updated_at',
models.DateTimeField(auto_now=True, verbose_name='更新时间')),
('deleted_at',
models.DateTimeField(null=True, verbose_name='删除时间')),
('is_change_charger', models.BooleanField(default=False)),
('charger',
models.ForeignKey(
null=True,
on_delete=django.db.models.deletion.SET_NULL,
related_name='goods_select_charger',
to=settings.AUTH_USER_MODEL)),
('good',
models.ForeignKey(
null=True,
on_delete=django.db.models.deletion.SET_NULL,
to='cpm.Good')),
],
options={
'abstract': False,
},
),
migrations.AddField(
model_name='good',
name='brand',
field=models.ForeignKey(
null=True,
on_delete=django.db.models.deletion.SET_NULL,
related_name='goods_brand',
to='cpm.GoodsBrand'),
),
migrations.AddField(
model_name='good',
name='cate',
field=models.ForeignKey(
null=True,
on_delete=django.db.models.deletion.SET_NULL,
related_name='goods_cate',
to='cpm.Category'),
),
migrations.AddField(
model_name='good',
name='changjing',
field=models.ManyToManyField(related_name='changjings',
to='cpm.TagChangjing'),
),
migrations.AddField(
model_name='good',
name='charger',
field=models.ManyToManyField(related_name='goods_charger',
to=settings.AUTH_USER_MODEL),
),
migrations.AddField(
model_name='good',
name='creater',
field=models.ForeignKey(
null=True,
on_delete=django.db.models.deletion.SET_NULL,
related_name='goods_creater',
to=settings.AUTH_USER_MODEL),
),
migrations.AddField(
model_name='good',
name='dingwei',
field=models.ManyToManyField(related_name='dingweis',
to='cpm.TagDingwei'),
),
migrations.AddField(
model_name='good',
name='suppiler',
field=models.ManyToManyField(related_name='goods_suppiler',
to='cpm.Supplier'),
),
migrations.CreateModel(
name='ChargerChange',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('created_at',
models.DateTimeField(auto_now_add=True, verbose_name='建立时间')),
('updated_at',
models.DateTimeField(auto_now=True, verbose_name='更新时间')),
('deleted_at',
models.DateTimeField(null=True, verbose_name='删除时间')),
('good',
models.ForeignKey(null=True,
on_delete=django.db.models.deletion.CASCADE,
related_name='good_charger_change',
to='cpm.Good')),
('now_charger',
models.ForeignKey(
null=True,
on_delete=django.db.models.deletion.SET_NULL,
related_name='goods_now_charger',
to=settings.AUTH_USER_MODEL)),
('raw_charger',
models.ForeignKey(
null=True,
on_delete=django.db.models.deletion.SET_NULL,
related_name='goods_raw_charger',
to=settings.AUTH_USER_MODEL)),
],
options={
'abstract': False,
},
),
migrations.AddIndex(
model_name='category',
index=models.Index(fields=['parent_id'],
name='wp_ex_sourc_parent__56ee5f_idx'),
),
migrations.AddIndex(
model_name='category',
index=models.Index(fields=['level'],
name='wp_ex_sourc_level_e745bb_idx'),
),
migrations.AlterUniqueTogether(
name='category',
unique_together={('cid', )},
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
]
operations = [
migrations.CreateModel(
name='Card',
fields=[
('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)),
('currency', models.CharField(choices=[('EUR', 'Euros'), ('USD', 'US Dollars'), ('GBP', 'British Pound')], max_length=3)),
('current_balance', models.DecimalField(decimal_places=2, default=0, max_digits=15)),
('created_at', models.DateTimeField(auto_now_add=True)),
('modified_at', models.DateTimeField(auto_now=True)),
('card_number', models.CharField(default=spendesk.wallets.models.Card.random_card_number, max_length=16, unique=True)),
('ccv', models.CharField(default=spendesk.wallets.models.Card.random_ccv, max_length=3)),
('is_blocked', models.BooleanField(default=False)),
('user_id', models.UUIDField(db_index=True)),
('expires_on', models.DateField(default=spendesk.wallets.models.Card.get_expiry_date)),
],
options={
'abstract': False,
},
),
migrations.CreateModel(
name='Transfer',
fields=[
('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)),
('origin_amount', models.DecimalField(decimal_places=2, default=0, max_digits=15)),
('origin_currency', models.CharField(choices=[('EUR', 'Euros'), ('USD', 'US Dollars'), ('GBP', 'British Pound')], max_length=3)),
('target_amount', models.DecimalField(decimal_places=2, default=0, max_digits=15)),
('target_currency', models.CharField(choices=[('EUR', 'Euros'), ('USD', 'US Dollars'), ('GBP', 'British Pound')], max_length=3)),
('fx_rate', models.DecimalField(decimal_places=6, default=1, max_digits=15)),
('conversion_fee', models.DecimalField(decimal_places=2, default=0, max_digits=15)),
('origin_entity_id', models.UUIDField(blank=True, db_index=True, null=True)),
('origin_entity_type', models.CharField(choices=[('C', 'card'), ('W', 'wallet'), ('E', 'external')], max_length=1)),
('target_entity_id', models.UUIDField(blank=True, db_index=True, null=True)),
('target_entity_type', models.CharField(choices=[('C', 'card'), ('W', 'wallet'), ('E', 'external')], max_length=1)),
('created_at', models.DateTimeField(auto_now_add=True)),
('executed_by', models.UUIDField(blank=True, db_index=True, null=True)),
],
),
migrations.CreateModel(
name='Wallet',
fields=[
('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)),
('currency', models.CharField(choices=[('EUR', 'Euros'), ('USD', 'US Dollars'), ('GBP', 'British Pound')], max_length=3)),
('current_balance', models.DecimalField(decimal_places=2, default=0, max_digits=15)),
('created_at', models.DateTimeField(auto_now_add=True)),
('modified_at', models.DateTimeField(auto_now=True)),
('company_id', models.UUIDField(db_index=True)),
('is_master', models.BooleanField(default=False)),
],
),
migrations.AddIndex(
model_name='wallet',
index=models.Index(fields=['currency', 'is_master'], name='wallets_wal_currenc_ee9b4b_idx'),
),
migrations.AddField(
model_name='card',
name='wallet',
field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='cards', to='wallets.Wallet'),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = []
operations = [
migrations.CreateModel(
name='Item',
fields=[
('item_id',
models.BigAutoField(editable=False,
primary_key=True,
serialize=False)),
('item_uuid',
models.UUIDField(default=uuid.uuid4,
editable=False,
unique=True)),
('active_ind',
models.BooleanField(default=True, verbose_name='Active')),
('active_status_cd',
models.CharField(choices=[
('01', 'Active'), ('02', 'Combined'),
('03', 'Historical value - combined'), ('04', 'Deleted'),
('05', 'Draft'), ('06', 'Inactive'), ('07', 'Recall'),
('08', 'Review'), ('09', 'Suspended'), ('10', 'Unknown')
],
default='01',
max_length=2)),
('active_status_dt_tm',
models.DateTimeField(default=django.utils.timezone.now)),
('active_status_prsnl_id', models.BigIntegerField(default=0)),
('approved_ind', models.BooleanField(default=False)),
('item_type_cd',
models.CharField(choices=[('12', 'General'),
('13', 'Produce'), ('14', 'Dairy'),
('03', 'Equipment Master'),
('04', 'Equipment Group'),
('05', 'Manufacturer Item'),
('06', 'Item Master'),
('07', 'Vendor Item'),
('08', 'Lot Info'),
('09', 'Medication'),
('10', 'Purchase Order'),
('11', 'Requisition'),
('01', 'Instance'),
('02', 'Equipment Instance')],
default='12',
max_length=2,
verbose_name='Item Type')),
('reusable_ind',
models.BooleanField(default=False, verbose_name='Reusable')),
('batch_quantity', models.BigIntegerField(default=0)),
('chargeable_ind', models.BooleanField(default=True)),
('component_ind', models.BooleanField(default=True)),
('component_usage_ind', models.BooleanField(default=False)),
('create_applabel', models.CharField(default='0',
max_length=20)),
('create_dt_tm',
models.DateTimeField(default=django.utils.timezone.now)),
('create_id', models.BigIntegerField(default=0)),
('create_task', models.BigIntegerField(default=0)),
('description', models.CharField(max_length=40)),
('inst_id', models.BigIntegerField(default=0)),
('item_level_flag', models.IntegerField(blank=True,
null=True)),
('latex_ind', models.BooleanField(default=False)),
('temp_store_max', models.IntegerField(blank=True, null=True)),
('temp_store_min', models.IntegerField(blank=True, null=True)),
('temp_uom_cd',
models.CharField(choices=[('C', 'degree Celsius'),
('F', 'degree Fahrenheit')],
default='C',
max_length=1)),
('shelf_life', models.IntegerField(blank=True, null=True)),
('shelf_life_uom_cd',
models.CharField(choices=[('H', 'hours'), ('D', 'days'),
('Y', 'years')],
default='H',
max_length=1,
verbose_name='Shelf Life UOM')),
('updt_cnt', models.IntegerField(default=0)),
('updt_dt_tm', models.DateTimeField(auto_now=True)),
('updt_id', models.BigIntegerField(default=0)),
('updt_task', models.BigIntegerField(default=0)),
('updt_applabel', models.CharField(default='0',
max_length=20)),
],
),
migrations.CreateModel(
name='ItemBarcode',
fields=[
('item_barcode_id',
models.BigAutoField(editable=False,
primary_key=True,
serialize=False)),
('active_ind',
models.BooleanField(default=True, verbose_name='Active')),
('parent_entity_id', models.IntegerField(default=0)),
('parent_entity_name',
models.CharField(blank=True, max_length=100)),
('item_barcode_type_cd',
models.CharField(choices=[
('20', 'Barcode'), ('21', 'Charge Number'),
('22', 'System Assigned Item Number'),
('23', 'Lot Number'), ('24', 'Manufacturer Item Number'),
('25', 'Serial Number'), ('26', 'Service Request Number'),
('27', 'UB92 Interface Identifier'),
('28', 'Universal Product Code'),
('29', 'Universal Product Number'),
('30', 'Vendor Item Number')
],
default='20',
max_length=2,
verbose_name='Item Barcode Type')),
('item_type_flag', models.IntegerField(default=0)),
('primary_ind',
models.BooleanField(default=True,
verbose_name='Primary Code')),
('sequence', models.IntegerField(default=0)),
('updt_cnt', models.IntegerField(default=0)),
('updt_dt_tm', models.DateTimeField(auto_now=True)),
('updt_id', models.BigIntegerField(default=0)),
('updt_task', models.BigIntegerField(default=0)),
('updt_applabel', models.CharField(default='0',
max_length=20)),
('value', models.CharField(max_length=200)),
],
options={
'db_table': 'core_item_barcode',
},
),
migrations.CreateModel(
name='ItemIdentifier',
fields=[
('item_identifier_id',
models.BigAutoField(editable=False,
primary_key=True,
serialize=False)),
('active_ind',
models.BooleanField(default=True, verbose_name='Active')),
('parent_entity_id', models.IntegerField(default=0)),
('parent_entity_name',
models.CharField(blank=True, max_length=100)),
('item_identifier_type_cd',
models.CharField(choices=[('01', 'Brand Name'),
('02', 'Description'),
('03', 'Clinical Description'),
('04', 'Short Description'),
('05', 'Foreign System Item Alias'),
('06', 'Generic Name'),
('07', 'Trade Name')],
default='02',
max_length=2,
verbose_name='Item Identifier Type')),
('item_type_flag', models.IntegerField(blank=True, default=0)),
('primary_ind', models.BooleanField(default=False)),
('sequence', models.IntegerField(default=0)),
('updt_cnt', models.IntegerField(default=0)),
('updt_dt_tm', models.DateTimeField(auto_now=True)),
('updt_id', models.BigIntegerField(default=0)),
('updt_task', models.BigIntegerField(default=0)),
('updt_applabel', models.CharField(default='0',
max_length=20)),
('value', models.CharField(max_length=200)),
('value_key', models.CharField(max_length=200)),
],
options={
'db_table': 'core_item_identifier',
},
),
migrations.CreateModel(
name='ItemPrice',
fields=[
('item_price_id',
models.BigAutoField(editable=False,
primary_key=True,
serialize=False)),
('active_ind',
models.BooleanField(default=True, verbose_name='Active')),
('active_status_cd',
models.CharField(choices=[
('01', 'Active'), ('02', 'Combined'),
('03', 'Historical value - combined'), ('04', 'Deleted'),
('05', 'Draft'), ('06', 'Inactive'), ('07', 'Recall'),
('08', 'Review'), ('09', 'Suspended'), ('10', 'Unknown')
],
default='01',
max_length=2)),
('active_status_dt_tm',
models.DateTimeField(default=django.utils.timezone.now)),
('active_status_prsnl_id', models.BigIntegerField(default=0)),
('contract_description',
models.CharField(default='none', max_length=100)),
('contract_id', models.BigIntegerField(default=0)),
('contract_line_id', models.BigIntegerField(default=0)),
('contract_nbr', models.CharField(default='none',
max_length=40)),
('contract_type',
models.CharField(default='none', max_length=100)),
('contributor_system_cd', models.BigIntegerField(default=0)),
('create_applabel', models.CharField(default='0',
max_length=20)),
('create_dt_tm', models.DateTimeField(auto_now_add=True)),
('create_id', models.BigIntegerField(default=0)),
('create_task', models.BigIntegerField(default=0)),
('effective_dt_tm',
models.DateTimeField(default=django.utils.timezone.now)),
('expiration_dt_tm', models.DateTimeField(blank=True,
null=True)),
('fixed_price_ind',
models.BooleanField(default=True,
verbose_name='Price Fixed')),
('min_order_quantity', models.BigIntegerField(default=0)),
('order_qty_multiple', models.IntegerField(default=0)),
('organization_id', models.BigIntegerField(default=0)),
('package_type_id', models.BigIntegerField(default=0)),
('price', models.DecimalField(decimal_places=2,
max_digits=10)),
('price_quote_source',
models.CharField(default='none', max_length=100)),
('price_type_cd',
models.CharField(choices=[('01', 'Contract'), ('02', 'List'),
('03', 'Quote')],
default='03',
max_length=2)),
('updt_cnt', models.IntegerField(default=0)),
('updt_dt_tm', models.DateTimeField(auto_now=True)),
('updt_id', models.BigIntegerField(default=0)),
('updt_task', models.BigIntegerField(default=0)),
('updt_applabel', models.CharField(default='0',
max_length=20)),
('vendor_price_schedule_id',
models.BigIntegerField(default=0)),
],
options={
'db_table': 'core_item_price',
},
),
migrations.CreateModel(
name='ItemPriceHist',
fields=[
('item_price_hist_id',
models.BigAutoField(editable=False,
primary_key=True,
serialize=False)),
('active_ind',
models.BooleanField(default=True, verbose_name='Active')),
('active_status_cd',
models.CharField(choices=[
('01', 'Active'), ('02', 'Combined'),
('03', 'Historical value - combined'), ('04', 'Deleted'),
('05', 'Draft'), ('06', 'Inactive'), ('07', 'Recall'),
('08', 'Review'), ('09', 'Suspended'), ('10', 'Unknown')
],
default='01',
max_length=2)),
('active_status_dt_tm',
models.DateTimeField(blank=True, null=True)),
('active_status_prsnl_id',
models.BigIntegerField(blank=True, default=0)),
('contract_description', models.CharField(max_length=100)),
('contract_id', models.BigIntegerField(default=0)),
('contract_line_id', models.BigIntegerField(default=0)),
('contract_nbr', models.CharField(blank=True, max_length=40)),
('contract_type', models.CharField(blank=True,
max_length=100)),
('contributor_system_cd', models.BigIntegerField(default=0)),
('create_applabel', models.CharField(blank=True,
max_length=20)),
('create_dt_tm',
models.DateTimeField(default=django.utils.timezone.now)),
('create_id', models.BigIntegerField(default=0)),
('create_task', models.BigIntegerField(default=0)),
('effective_dt_tm', models.DateTimeField(auto_now_add=True)),
('expiration_dt_tm', models.DateTimeField(blank=True,
null=True)),
('fixed_price_ind',
models.BooleanField(default=True,
verbose_name='Price Fixed')),
('min_order_quantity', models.BigIntegerField(default=0)),
('order_qty_multiple', models.IntegerField(default=0)),
('organization_id', models.BigIntegerField(default=0)),
('package_type_id', models.BigIntegerField(default=0)),
('price', models.DecimalField(decimal_places=2,
max_digits=10)),
('price_quote_source',
models.CharField(blank=True, max_length=100)),
('price_type_cd',
models.CharField(choices=[('01', 'Contract'), ('02', 'List'),
('03', 'Quote')],
default='03',
max_length=2)),
('updt_cnt', models.IntegerField(default=0)),
('updt_dt_tm', models.DateTimeField(auto_now=True)),
('updt_id', models.BigIntegerField(default=0)),
('updt_task', models.BigIntegerField(default=0)),
('updt_applabel', models.CharField(blank=True, max_length=20)),
('vendor_price_schedule_id',
models.BigIntegerField(default=0)),
],
options={
'db_table': 'core_item_price_hist',
},
),
migrations.CreateModel(
name='Trans_Action',
fields=[
('trans_action_id',
models.BigAutoField(editable=False,
primary_key=True,
serialize=False)),
('action_dt_tm', models.DateTimeField(auto_now=True)),
('action_prsnl_id', models.BigIntegerField(default=0)),
('action_type_cd',
models.CharField(choices=[('01', 'Assist'), ('02', 'Author'),
('03', 'Cancel'), ('04', 'Collect'),
('05', 'Confirm'),
('06', 'Consumer Review'),
('07', 'Convey'), ('08', 'Copy'),
('09', 'Correct'), ('10', 'Cosign'),
('11', 'Endorse'),
('12', 'Endorse Save'),
('13', 'Flag For Significance'),
('14', 'Follow-up'),
('15', 'In Lab'), ('16', 'Insert'),
('17', 'Modify'), ('18', 'Order'),
('19', 'Perform'), ('20', 'Remove'),
('21', 'Review'), ('22', 'Sign'),
('23', 'Start_Admin'),
('24', 'Stop_Admin'),
('25', 'Transcribe'),
('26', 'Unconfirm'),
('27', 'Unflag For Significance'),
('28', 'Undefined Code'),
('29', 'Verify'), ('30', 'Witness'),
('31', 'Printed')],
max_length=2,
verbose_name='Action Type')),
('client_id', models.BigIntegerField(default=0)),
('person_id', models.BigIntegerField(default=0)),
('comment', models.TextField(blank=True)),
('event_id', models.BigIntegerField(default=0)),
('event_cd', models.IntegerField(default=0)),
('event_class_cd', models.IntegerField(default=0)),
('event_tag', models.CharField(blank=True, max_length=255)),
('event_title', models.CharField(blank=True, max_length=255)),
('result_status_cd',
models.CharField(choices=[('01', 'Active'),
('02', 'Modified'),
('03', 'Anticipated'),
('04', 'Auth (Verified)'),
('05', 'Canceled'),
('06', 'Dictated'),
('07', 'In Progress'),
('08', 'In Error'),
('09', 'Modified'),
('10', 'Not Done'),
('11', 'Rejected'),
('12', 'Started'),
('13', 'Superseded'),
('14', 'Transcribed'),
('15', 'Unauth'),
('16', 'Unknown')],
default='01',
max_length=2,
verbose_name='Result Status')),
('trans_type_cd',
models.CharField(choices=[('01', 'Purchase'),
('02', 'Refund'),
('03', 'Exchange')],
default='01',
max_length=2,
verbose_name='Transaction Type')),
('updt_cnt', models.IntegerField(default=0)),
('updt_dt_tm', models.DateTimeField(auto_now=True)),
('updt_id', models.BigIntegerField(default=0)),
('updt_task', models.BigIntegerField(default=0)),
('updt_applabel', models.CharField(default='0',
max_length=20)),
],
options={
'db_table': 'core_trans_action',
},
),
migrations.CreateModel(
name='TransComment',
fields=[
('trans_comment_id',
models.BigAutoField(editable=False,
primary_key=True,
serialize=False)),
('action_sequence', models.IntegerField(default=0)),
('comment_dt_tm', models.DateTimeField(auto_now=True)),
('comment_prsnl_id', models.BigIntegerField(default=0)),
('comment_type_cd',
models.CharField(choices=[('01', 'Staff Comment'),
('02', 'Client Comment'),
('03', 'Audit Comment'),
('04', 'System Comment'),
('05', 'Void Reason')],
max_length=2,
verbose_name='Comment Type')),
('comment', models.TextField(blank=True)),
('display_mask', models.IntegerField(default=0)),
('updt_cnt', models.IntegerField(default=0)),
('updt_dt_tm', models.DateTimeField(auto_now=True)),
('updt_id', models.BigIntegerField(default=0)),
('updt_task', models.BigIntegerField(default=0)),
('updt_applabel', models.CharField(default='0',
max_length=20)),
],
options={
'db_table': 'core_trans_comment',
},
),
migrations.CreateModel(
name='TransEvent',
fields=[
('trans_event_id',
models.BigAutoField(editable=False,
primary_key=True,
serialize=False)),
('trans_uuid',
models.UUIDField(default=uuid.uuid4,
editable=False,
unique=True)),
('authentic_flag', models.IntegerField(default=1)),
('client_id', models.BigIntegerField(default=0)),
('person_id', models.BigIntegerField(default=0)),
('coupon_used_ind',
models.BooleanField(default=False,
verbose_name='Coupon Used')),
('coupon_amount',
models.DecimalField(decimal_places=2, max_digits=10)),
('entry_mode_cd',
models.CharField(choices=[('01', 'Scan-N-Pay'), ('02', 'ESI'),
('03', 'Direct Entry'),
('04', 'Cashier')],
default='01',
max_length=2,
verbose_name='Entry Mode')),
('parent_entity_id', models.BigIntegerField(default=0)),
('parent_entity_name',
models.CharField(blank=True, max_length=100)),
('performed_dt_tm', models.DateTimeField(blank=True)),
('performed_prsnl_id', models.BigIntegerField(default=0)),
('sequence', models.IntegerField(default=0)),
('trans_comment_ind',
models.BooleanField(default=False, verbose_name='Active')),
('trans_end_dt_tm', models.DateTimeField(auto_now=True)),
('trans_start_dt_tm', models.DateTimeField(blank=True)),
('event_cd', models.IntegerField(default=0)),
('event_class_cd', models.IntegerField(default=0)),
('event_id', models.BigIntegerField(default=0)),
('event_tag',
models.CharField(blank=True, max_length=255, null=True)),
('event_title',
models.CharField(blank=True, max_length=255, null=True)),
('result_status_cd',
models.CharField(choices=[('01', 'Active'),
('02', 'Modified'),
('03', 'Anticipated'),
('04', 'Auth (Verified)'),
('05', 'Canceled'),
('06', 'Dictated'),
('07', 'In Progress'),
('08', 'In Error'),
('09', 'Modified'),
('10', 'Not Done'),
('11', 'Rejected'),
('12', 'Started'),
('13', 'Superseded'),
('14', 'Transcribed'),
('15', 'Unauth'),
('16', 'Unknown')],
default='01',
max_length=2,
verbose_name='Result Status')),
('trans_type_cd',
models.CharField(choices=[('01', 'Purchase'),
('02', 'Refund'),
('03', 'Exchange')],
default='01',
max_length=2,
verbose_name='Transaction Type')),
('total_quantity', models.IntegerField(default=0)),
('total_orig_price',
models.DecimalField(decimal_places=2, max_digits=10)),
('total_discount',
models.DecimalField(decimal_places=2,
default=0,
max_digits=10)),
('total_price',
models.DecimalField(decimal_places=2, max_digits=10)),
('updt_cnt', models.IntegerField(default=0)),
('updt_dt_tm', models.DateTimeField(auto_now=True)),
('updt_id', models.BigIntegerField(default=0)),
('updt_task', models.BigIntegerField(default=0)),
('updt_applabel', models.CharField(default='0',
max_length=20)),
('valid_from_dt_tm', models.DateTimeField(auto_now_add=True)),
('valid_until_dt_tm',
models.DateTimeField(
default=datetime.datetime(2150, 12, 31, 0, 0, tzinfo=utc))
),
('verified_dt_tm', models.DateTimeField(blank=True,
null=True)),
('verified_prsnl_id', models.BigIntegerField(default=0)),
('workstation_id', models.BigIntegerField(default=0)),
],
options={
'db_table': 'core_trans_event',
},
),
migrations.CreateModel(
name='TransItem',
fields=[
('trans_item_id',
models.BigAutoField(editable=False,
primary_key=True,
serialize=False)),
('event_id', models.BigIntegerField(default=0)),
('item_id', models.BigIntegerField(default=0)),
('item_identifier_id', models.BigIntegerField(default=0)),
('item_price_id', models.BigIntegerField(default=0)),
('item_discount_id', models.BigIntegerField(default=0)),
('description', models.CharField(max_length=200)),
('quantity', models.IntegerField(default=0)),
('price', models.DecimalField(decimal_places=2,
max_digits=10)),
('discountAmount',
models.DecimalField(decimal_places=2, max_digits=10)),
('price_final',
models.DecimalField(decimal_places=2, max_digits=10)),
('comment', models.CharField(blank=True, max_length=255)),
('updt_cnt', models.IntegerField(default=0)),
('updt_dt_tm', models.DateTimeField(auto_now=True)),
('updt_id', models.BigIntegerField(default=0)),
('updt_task', models.BigIntegerField(default=0)),
('updt_applabel', models.CharField(default='0',
max_length=20)),
],
options={
'db_table': 'core_trans_item',
},
),
migrations.AddIndex(
model_name='transitem',
index=models.Index(fields=['event_id'],
name='core_trans__event_i_687bd3_idx'),
),
migrations.AddIndex(
model_name='transitem',
index=models.Index(fields=['item_id'],
name='core_trans__item_id_af7ec2_idx'),
),
migrations.AddIndex(
model_name='transevent',
index=models.Index(fields=['performed_dt_tm'],
name='core_trans__perform_a4b064_idx'),
),
migrations.AddIndex(
model_name='transevent',
index=models.Index(fields=['person_id'],
name='core_trans__person__fa7a74_idx'),
),
migrations.AddIndex(
model_name='transevent',
index=models.Index(fields=['event_id'],
name='core_trans__event_i_af394e_idx'),
),
migrations.AddIndex(
model_name='transevent',
index=models.Index(fields=['performed_prsnl_id'],
name='core_trans__perform_5b4e54_idx'),
),
migrations.AddIndex(
model_name='transevent',
index=models.Index(fields=['trans_end_dt_tm'],
name='core_trans__trans_e_407cdb_idx'),
),
migrations.AddField(
model_name='transcomment',
name='trans_event',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
related_name='Comments',
to='core.TransEvent'),
),
migrations.AddField(
model_name='trans_action',
name='trans_event',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
related_name='Actions',
to='core.TransEvent'),
),
migrations.AddField(
model_name='itempricehist',
name='item',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
related_name='+',
to='core.Item'),
),
migrations.AddField(
model_name='itempricehist',
name='item_price',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
related_name='+',
to='core.ItemPrice'),
),
migrations.AddField(
model_name='itemprice',
name='item',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
related_name='Prices',
to='core.Item'),
),
migrations.AddField(
model_name='itemidentifier',
name='item',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
related_name='Identifiers',
to='core.Item'),
),
migrations.AddField(
model_name='itembarcode',
name='item',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
related_name='Barcodes',
to='core.Item'),
),
migrations.AddIndex(
model_name='item',
index=models.Index(fields=['item_type_cd'],
name='core_item_item_ty_dcfb86_idx'),
),
migrations.AddIndex(
model_name='item',
index=models.Index(fields=['updt_dt_tm'],
name='core_item_updt_dt_396218_idx'),
),
migrations.AddIndex(
model_name='transcomment',
index=models.Index(fields=['trans_event_id'],
name='core_trans__trans_e_9526c8_idx'),
),
migrations.AddIndex(
model_name='trans_action',
index=models.Index(fields=['event_id'],
name='core_trans__event_i_9fa67d_idx'),
),
migrations.AddIndex(
model_name='itempricehist',
index=models.Index(fields=['item'],
name='core_item_p_item_id_ffb9fa_idx'),
),
migrations.AddIndex(
model_name='itempricehist',
index=models.Index(fields=['item_price'],
name='core_item_p_item_pr_327362_idx'),
),
migrations.AddIndex(
model_name='itempricehist',
index=models.Index(fields=['contract_line_id'],
name='core_item_p_contrac_8fff96_idx'),
),
migrations.AddIndex(
model_name='itempricehist',
index=models.Index(fields=['organization_id'],
name='core_item_p_organiz_b133a3_idx'),
),
migrations.AddIndex(
model_name='itempricehist',
index=models.Index(fields=['package_type_id'],
name='core_item_p_package_24d846_idx'),
),
migrations.AddIndex(
model_name='itemprice',
index=models.Index(fields=['item'],
name='core_item_p_item_id_8f2dc1_idx'),
),
migrations.AddIndex(
model_name='itemprice',
index=models.Index(fields=['contract_line_id'],
name='core_item_p_contrac_d1f638_idx'),
),
migrations.AddIndex(
model_name='itemidentifier',
index=models.Index(fields=['item'],
name='core_item_i_item_id_dbec6f_idx'),
),
migrations.AddIndex(
model_name='itembarcode',
index=models.Index(fields=['item'],
name='core_item_b_item_id_ad1058_idx'),
),
migrations.AddIndex(
model_name='itembarcode',
index=models.Index(fields=['value'],
name='core_item_b_value_c1777c_idx'),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = []
operations = [
migrations.CreateModel(
name='AudioCreateWorkerManageLog',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('user',
models.PositiveIntegerField(default=0,
verbose_name='Пользователь')),
('manager',
models.PositiveIntegerField(default=0,
verbose_name='Менеджер')),
('created',
models.DateTimeField(auto_now_add=True,
verbose_name='Создан')),
('action_type',
models.CharField(choices=[
('CA', 'Добавлен создатель админов аудиозаписей'),
('DA', 'Удален создатель админов аудиозаписей'),
('CE', 'Добавлен создатель редакторов аудиозаписей'),
('DE', 'Удален создатель редакторов аудиозаписей'),
('CM', 'Добавлен создатель модераторов аудиозаписей'),
('DM', 'Удален создатель модераторов аудиозаписей')
],
editable=False,
max_length=5)),
],
options={
'verbose_name': 'Лог создателя суперменеджера аудиозаписей',
'verbose_name_plural':
'Логи создателей суперменеджеров аудиозаписей',
'ordering': ['-created'],
},
),
migrations.CreateModel(
name='AudioManageLog',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('item',
models.PositiveIntegerField(default=0,
verbose_name='Запись')),
('manager',
models.PositiveIntegerField(default=0,
verbose_name='Менеджер')),
('created',
models.DateTimeField(auto_now_add=True,
verbose_name='Создан')),
('action_type',
models.CharField(choices=[
('LCLO', 'Список закрыт'), ('ICLO', 'Элемент закрыт'),
('CCLO', 'Комментарий закрыт'),
('LRES', 'Список восстановлен'),
('IRES', 'Элемент восстановлен'),
('CRES', 'Комментарий восстановлен'),
('LREJ', 'Жалоба на список отклонена'),
('IREJ', 'Жалоба на элемент отклонена'),
('CREJ', 'Жалоба на комментарий отклонена'),
('LUNV', 'Проверка на список убрана'),
('IUNV', 'Проверка на элемент убрана'),
('CUNV', 'Проверка на комментарий убрана')
],
editable=False,
max_length=5)),
],
options={
'verbose_name': 'Лог менеджера аудиозаписей',
'verbose_name_plural': 'Логи менеджеров аудиозаписей',
'ordering': ['-created'],
},
),
migrations.CreateModel(
name='AudioWorkerManageLog',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('user',
models.PositiveIntegerField(default=0,
verbose_name='Пользователь')),
('manager',
models.PositiveIntegerField(default=0,
verbose_name='Менеджер')),
('created',
models.DateTimeField(auto_now_add=True,
verbose_name='Создан')),
('action_type',
models.CharField(choices=[
('CA', 'Добавлен админ аудиозаписей'),
('DA', 'Удален админ аудиозаписей'),
('CE', 'Добавлен редактор аудиозаписей'),
('DE', 'Удален редактор аудиозаписей'),
('CM', 'Добавлен модератор аудиозаписей'),
('DM', 'Удален модератор аудиозаписей')
],
editable=False,
max_length=5)),
],
options={
'verbose_name': 'Лог суперменеджера аудиозаписей',
'verbose_name_plural': 'Логи супеменеджеров аудиозаписей',
'ordering': ['-created'],
},
),
migrations.CreateModel(
name='CommunityCreateWorkerManageLog',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('user',
models.PositiveIntegerField(default=0,
verbose_name='Сообщество')),
('manager',
models.PositiveIntegerField(default=0,
verbose_name='Менеджер')),
('created',
models.DateTimeField(auto_now_add=True,
verbose_name='Создан')),
('action_type',
models.CharField(choices=[
('CA', 'Добавлен создатель админов сообществ'),
('DA', 'Удален создатель админов сообществ'),
('CE', 'Добавлен создатель редакторов сообществ'),
('DE', 'Удален создатель редакторов сообществ'),
('CM', 'Добавлен создатель модераторов сообществ'),
('DM', 'Удален создатель модераторов сообществ'),
('CR',
'Добавлен создатель менеджеров рекламодателей сообществ'
),
('DR',
'Удален создатель менеджеров рекламодателей сообществ')
],
editable=False,
max_length=5)),
],
options={
'verbose_name': 'Лог создателя суперменеджера сообществ',
'verbose_name_plural':
'Логи создателей суперменеджеров сообществ',
'ordering': ['-created'],
},
),
migrations.CreateModel(
name='CommunityManageLog',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('community',
models.PositiveIntegerField(default=0,
verbose_name='Сообщество')),
('manager',
models.PositiveIntegerField(default=0,
verbose_name='Менеджер')),
('created',
models.DateTimeField(auto_now_add=True,
verbose_name='Создан')),
('action_type',
models.CharField(choices=[
('CLO', 'Закрыт'), ('CLOH', 'Восстановлен'),
('SC', 'Вечная заморозка'), ('SH', 'Долгая заморозка'),
('SM', 'Средняя заморозка'), ('SL', 'Краткая заморозка'),
('USH', 'Разморожен'),
('WB', 'Выставлен предупреждающий баннер'),
('NWBH', 'Убран предупреждающий баннер'),
('REJ', 'Жалоба отклонена'), ('UNV', 'Проверка убрана')
],
editable=False,
max_length=5)),
],
options={
'verbose_name': 'Лог менеджера сообществ',
'verbose_name_plural': 'Логи менеджеров сообществ',
'ordering': ['-created'],
},
),
migrations.CreateModel(
name='CommunityWorkerManageLog',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('user',
models.PositiveIntegerField(default=0,
verbose_name='Сообщество')),
('manager',
models.PositiveIntegerField(default=0,
verbose_name='Менеджер')),
('created',
models.DateTimeField(auto_now_add=True,
verbose_name='Создан')),
('action_type',
models.CharField(choices=[
('CA', 'Добавлен админ сообществ'),
('DA', 'Удален админ сообществ'),
('CE', 'Добавлен редактор сообществ'),
('DE', 'Удален редактор сообществ'),
('CM', 'Добавлен модератор сообществ'),
('DM', 'Удален модератор сообществ'),
('CR', 'Добавлен менеджер рекламодателей сообществ'),
('DR', 'Удален менеджер рекламодателей сообществ')
],
editable=False,
max_length=5)),
],
options={
'verbose_name': 'Лог суперменеджера сообществ',
'verbose_name_plural': 'Логи суперменеджеров сообществ',
'ordering': ['-created'],
},
),
migrations.CreateModel(
name='ElectNewCreateWorkerManageLog',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('user',
models.PositiveIntegerField(default=0,
verbose_name='Пользователь')),
('manager',
models.PositiveIntegerField(default=0,
verbose_name='Менеджер')),
('created',
models.DateTimeField(auto_now_add=True,
verbose_name='Создан')),
('action_type',
models.CharField(choices=[
('CA',
'Добавлен создатель админов активностей депутатов'),
('DA', 'Удален создатель админов активностей депутатов'),
('CE',
'Добавлен создатель редакторов активностей депутатов'),
('DE',
'Удален создатель редакторов запактивностей депутатовисей'
),
('CM',
'Добавлен создатель модераторов активностей депутатов'),
('DM',
'Удален создатель модераторов активностей депутатов')
],
editable=False,
max_length=5)),
],
options={
'verbose_name':
'Лог создателя суперменеджера активностей депутатов',
'verbose_name_plural':
'Логи создателей суперменеджеров активностей депутатов',
'ordering': ['-created'],
},
),
migrations.CreateModel(
name='ElectNewManageLog',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('item',
models.PositiveIntegerField(
default=0, verbose_name='Список, элемент или коммент')),
('manager',
models.PositiveIntegerField(default=0,
verbose_name='Менеджер')),
('created',
models.DateTimeField(auto_now_add=True,
verbose_name='Создан')),
('action_type',
models.CharField(choices=[
('LCLO', 'Список закрыт'), ('ICLO', 'Элемент закрыт'),
('CCLO', 'Комментарий закрыт'),
('LRES', 'Список восстановлен'),
('IRES', 'Элемент восстановлен'),
('CRES', 'Комментарий восстановлен'),
('LREJ', 'Жалоба на список отклонена'),
('IREJ', 'Жалоба на элемент отклонена'),
('CREJ', 'Жалоба на комментарий отклонена'),
('LUNV', 'Проверка на список убрана'),
('IUNV', 'Проверка на элемент убрана'),
('CUNV', 'Проверка на комментарий убрана')
],
editable=False,
max_length=5)),
],
options={
'verbose_name': 'Лог менеджера активностей депутатов',
'verbose_name_plural': 'Логи менеджеров активностей депутатов',
'ordering': ['-created'],
},
),
migrations.CreateModel(
name='ElectNewWorkerManageLog',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('user',
models.PositiveIntegerField(default=0,
verbose_name='Пользователь')),
('manager',
models.PositiveIntegerField(default=0,
verbose_name='Менеджер')),
('created',
models.DateTimeField(auto_now_add=True,
verbose_name='Создан')),
('action_type',
models.CharField(choices=[
('CA', 'Добавлен админ активностей депутатов'),
('DA', 'Удален админ активностей депутатов'),
('CE', 'Добавлен редактор активностей депутатов'),
('DE', 'Удален редактор активностей депутатов'),
('CM', 'Добавлен модератор активностей депутатов'),
('DM', 'Удален модератор активностей депутатов')
],
editable=False,
max_length=5)),
],
options={
'verbose_name': 'Лог суперменеджера активностей депутатов',
'verbose_name_plural':
'Логи суперменеджеров активностей депутатов',
'ordering': ['-created'],
},
),
migrations.CreateModel(
name='PhotoCreateWorkerManageLog',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('user',
models.PositiveIntegerField(default=0,
verbose_name='Пользователь')),
('manager',
models.PositiveIntegerField(default=0,
verbose_name='Менеджер')),
('created',
models.DateTimeField(auto_now_add=True,
verbose_name='Создан')),
('action_type',
models.CharField(choices=[
('CA', 'Добавлен создатель админов фотографий'),
('DA', 'Удален создатель админов фотографий'),
('CE', 'Добавлен создатель редакторов фотографий'),
('DE', 'Удален создатель редакторов фотографий'),
('CM', 'Добавлен создатель модераторов фотографий'),
('DM', 'Удален создатель модераторов фотографий')
],
editable=False,
max_length=5)),
],
options={
'verbose_name': 'Лог создателя суперменеджера фотографий',
'verbose_name_plural':
'Логи создателей суперменеджеров фотографий',
'ordering': ['-created'],
},
),
migrations.CreateModel(
name='PhotoManageLog',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('item',
models.PositiveIntegerField(
default=0, verbose_name='Список, элемент или коммент')),
('manager',
models.PositiveIntegerField(default=0,
verbose_name='Менеджер')),
('created',
models.DateTimeField(auto_now_add=True,
verbose_name='Создан')),
('action_type',
models.CharField(choices=[
('LCLO', 'Список закрыт'), ('ICLO', 'Элемент закрыт'),
('CCLO', 'Комментарий закрыт'),
('LRES', 'Список восстановлен'),
('IRES', 'Элемент восстановлен'),
('CRES', 'Комментарий восстановлен'),
('LREJ', 'Жалоба на список отклонена'),
('IREJ', 'Жалоба на элемент отклонена'),
('CREJ', 'Жалоба на комментарий отклонена'),
('LUNV', 'Проверка на список убрана'),
('IUNV', 'Проверка на элемент убрана'),
('CUNV', 'Проверка на комментарий убрана')
],
editable=False,
max_length=5)),
],
options={
'verbose_name': 'Лог менеджера фотографий',
'verbose_name_plural': 'Логи менеджеров фотографий',
'ordering': ['-created'],
},
),
migrations.CreateModel(
name='PhotoWorkerManageLog',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('user',
models.PositiveIntegerField(default=0,
verbose_name='Пользователь')),
('manager',
models.PositiveIntegerField(default=0,
verbose_name='Менеджер')),
('created',
models.DateTimeField(auto_now_add=True,
verbose_name='Создан')),
('action_type',
models.CharField(choices=[
('CA', 'Добавлен админ фотографий'),
('DA', 'Удален админ фотографий'),
('CE', 'Добавлен редактор фотографий'),
('DE', 'Удален редактор фотографий'),
('CM', 'Добавлен модератор фотографий'),
('DM', 'Удален модератор фотографий')
],
editable=False,
max_length=5)),
],
options={
'verbose_name': 'Лог суперменеджера фотографий',
'verbose_name_plural': 'Логи суперменеджеров фотографий',
'ordering': ['-created'],
},
),
migrations.CreateModel(
name='SurveyCreateWorkerManageLog',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('user',
models.PositiveIntegerField(default=0,
verbose_name='Пользователь')),
('manager',
models.PositiveIntegerField(default=0,
verbose_name='Менеджер')),
('created',
models.DateTimeField(auto_now_add=True,
verbose_name='Создан')),
('action_type',
models.CharField(choices=[
('CA', 'Добавлен создатель админов опросов'),
('DA', 'Удален создатель админов опросов'),
('CE', 'Добавлен создатель редакторов опросов'),
('DE', 'Удален создатель редакторов опросов'),
('CM', 'Добавлен создатель модераторов опросов'),
('DM', 'Удален создатель модераторов опросов')
],
editable=False,
max_length=5)),
],
options={
'verbose_name': 'Лог создателя суперменеджера опросов',
'verbose_name_plural':
'Логи создателей суперменеджеров опросов',
'ordering': ['-created'],
},
),
migrations.CreateModel(
name='SurveyManageLog',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('item',
models.PositiveIntegerField(default=0, verbose_name='Опрос')),
('manager',
models.PositiveIntegerField(default=0,
verbose_name='Менеджер')),
('created',
models.DateTimeField(auto_now_add=True,
verbose_name='Создан')),
('action_type',
models.CharField(choices=[
('LCLO', 'Список закрыт'), ('ICLO', 'Элемент закрыт'),
('CCLO', 'Комментарий закрыт'),
('LRES', 'Список восстановлен'),
('IRES', 'Элемент восстановлен'),
('CRES', 'Комментарий восстановлен'),
('LREJ', 'Жалоба на список отклонена'),
('IREJ', 'Жалоба на элемент отклонена'),
('CREJ', 'Жалоба на комментарий отклонена'),
('LUNV', 'Проверка на список убрана'),
('IUNV', 'Проверка на элемент убрана'),
('CUNV', 'Проверка на комментарий убрана')
],
editable=False,
max_length=5)),
],
options={
'verbose_name': 'Лог менеджера опросов',
'verbose_name_plural': 'Логи менеджеров опросов',
'ordering': ['-created'],
},
),
migrations.CreateModel(
name='SurveyWorkerManageLog',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('user',
models.PositiveIntegerField(default=0,
verbose_name='Пользователь')),
('manager',
models.PositiveIntegerField(default=0,
verbose_name='Менеджер')),
('created',
models.DateTimeField(auto_now_add=True,
verbose_name='Создан')),
('action_type',
models.CharField(choices=[('CA', 'Добавлен админ опросов'),
('DA', 'Удален админ опросов'),
('CE', 'Добавлен редактор опросов'),
('DE', 'Удален редактор опросов'),
('CM',
'Добавлен модератор опросов'),
('DM', 'Удален модератор опросов')],
editable=False,
max_length=5)),
],
options={
'verbose_name': 'Лог суперменеджера опросов',
'verbose_name_plural': 'Логи суперменеджеров опросов',
'ordering': ['-created'],
},
),
migrations.CreateModel(
name='UserCreateWorkerManageLog',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('user',
models.PositiveIntegerField(default=0,
verbose_name='Пользователь')),
('manager',
models.PositiveIntegerField(default=0,
verbose_name='Менеджер')),
('created',
models.DateTimeField(auto_now_add=True,
verbose_name='Создан')),
('action_type',
models.CharField(choices=[
('CA', 'Добавлен создатель админов пользователей'),
('DA', 'Удален создатель админов пользователей'),
('CE', 'Добавлен создатель редакторов пользователей'),
('DE', 'Удален создатель редакторов пользователей'),
('CM', 'Добавлен создатель модераторов пользователей'),
('DM', 'Удален создатель модераторов пользователей'),
('CR',
'Добавлен создатель менеджеров рекламодателей пользователей'
),
('DR',
'Удален создатель менеджеров рекламодателей пользователей'
)
],
editable=False,
max_length=5)),
],
options={
'verbose_name': 'Лог создателя суперменеджера пользоватетей',
'verbose_name_plural':
'Логи создателей суперменеджеров пользоватетей',
'ordering': ['-created'],
},
),
migrations.CreateModel(
name='UserManageLog',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('user',
models.PositiveIntegerField(default=0,
verbose_name='Пользователь')),
('manager',
models.PositiveIntegerField(default=0,
verbose_name='Менеджер')),
('created',
models.DateTimeField(auto_now_add=True,
verbose_name='Создан')),
('action_type',
models.CharField(choices=[
('CLO', 'Закрыт'), ('CLOH', 'Восстановлен'),
('SC', 'Вечная заморозка'), ('SH', 'Долгая заморозка'),
('SM', 'Средняя заморозка'), ('SL', 'Краткая заморозка'),
('USH', 'Разморожен'),
('WB', 'Выставлен предупреждающий баннер'),
('NWBH', 'Убран предупреждающий баннер'),
('REJ', 'Жалоба отклонена'), ('UNV', 'Проверка убрана')
],
editable=False,
max_length=5)),
],
options={
'verbose_name': 'Лог менеджера пользоватетей',
'verbose_name_plural': 'Логи менеджеров пользоватетей',
'ordering': ['-created'],
},
),
migrations.CreateModel(
name='UserWorkerManageLog',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('user',
models.PositiveIntegerField(default=0,
verbose_name='Пользователь')),
('manager',
models.PositiveIntegerField(default=0,
verbose_name='Менеджер')),
('created',
models.DateTimeField(auto_now_add=True,
verbose_name='Создан')),
('action_type',
models.CharField(choices=[
('CA', 'Добавлен админ пользователей'),
('DA', 'Удален админ пользователей'),
('CE', 'Добавлен редактор пользователей'),
('DE', 'Удален редактор пользователей'),
('CM', 'Добавлен модератор пользователей'),
('DM', 'Удален модератор пользователей'),
('CR', 'Добавлен менеджер рекламодателей пользователей'),
('DR', 'Удален менеджер рекламодателей пользователей')
],
editable=False,
max_length=5)),
],
options={
'verbose_name': 'Лог суперменеджера пользоватетей',
'verbose_name_plural': 'Логи суперменеджеров пользоватетей',
'ordering': ['-created'],
},
),
migrations.CreateModel(
name='VideoCommentManageLog',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('comment',
models.PositiveIntegerField(
default=0, verbose_name='Комментарий к видеоролику')),
('manager',
models.PositiveIntegerField(default=0,
verbose_name='Менеджер')),
('created',
models.DateTimeField(auto_now_add=True,
verbose_name='Создан')),
('action_type',
models.CharField(choices=[('D', 'Удален'),
('UD', 'Восстановлен'),
('R', 'Жалоба отклонена'),
('UV', 'Проверка убрана')],
editable=False,
max_length=5)),
],
),
migrations.CreateModel(
name='VideoCreateWorkerManageLog',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('user',
models.PositiveIntegerField(default=0,
verbose_name='Пользователь')),
('manager',
models.PositiveIntegerField(default=0,
verbose_name='Менеджер')),
('created',
models.DateTimeField(auto_now_add=True,
verbose_name='Создан')),
('action_type',
models.CharField(choices=[
('CA', 'Добавлен создатель админов видеороликов'),
('DA', 'Удален создатель админов видеороликов'),
('CE', 'Добавлен создатель редакторов видеороликов'),
('DE', 'Удален создатель редакторов видеороликов'),
('CM', 'Добавлен создатель модераторов видеороликов'),
('DM', 'Удален создатель модераторов видеороликов')
],
editable=False,
max_length=5)),
],
options={
'verbose_name': 'Лог создателя суперменеджера видеороликов',
'verbose_name_plural':
'Логи создателей суперменеджеров видеороликов',
'ordering': ['-created'],
},
),
migrations.CreateModel(
name='VideoManageLog',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('item',
models.PositiveIntegerField(default=0,
verbose_name='Запись')),
('manager',
models.PositiveIntegerField(default=0,
verbose_name='Менеджер')),
('created',
models.DateTimeField(auto_now_add=True,
verbose_name='Создан')),
('action_type',
models.CharField(choices=[
('LCLO', 'Список закрыт'), ('ICLO', 'Элемент закрыт'),
('CCLO', 'Комментарий закрыт'),
('LRES', 'Список восстановлен'),
('IRES', 'Элемент восстановлен'),
('CRES', 'Комментарий восстановлен'),
('LREJ', 'Жалоба на список отклонена'),
('IREJ', 'Жалоба на элемент отклонена'),
('CREJ', 'Жалоба на комментарий отклонена'),
('LUNV', 'Проверка на список убрана'),
('IUNV', 'Проверка на элемент убрана'),
('CUNV', 'Проверка на комментарий убрана')
],
editable=False,
max_length=5)),
],
options={
'verbose_name': 'Лог менеджера видеороликов',
'verbose_name_plural': 'Логи менеджеров видеороликов',
'ordering': ['-created'],
},
),
migrations.CreateModel(
name='VideoWorkerManageLog',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('user',
models.PositiveIntegerField(default=0,
verbose_name='Пользователь')),
('manager',
models.PositiveIntegerField(default=0,
verbose_name='Менеджер')),
('created',
models.DateTimeField(auto_now_add=True,
verbose_name='Создан')),
('action_type',
models.CharField(choices=[
('CA', 'Добавлен админ видеороликов'),
('DA', 'Удален админ видеороликов'),
('CE', 'Добавлен редактор видеороликов'),
('DE', 'Удален редактор видеороликов'),
('CM', 'Добавлен модератор видеороликов'),
('DM', 'Удален модератор видеороликов')
],
editable=False,
max_length=5)),
],
options={
'verbose_name': 'Лог суперменеджера видеороликов',
'verbose_name_plural': 'Логи суперменеджеров видеороликов',
'ordering': ['-created'],
},
),
migrations.AddIndex(
model_name='videoworkermanagelog',
index=django.contrib.postgres.indexes.BrinIndex(
fields=['created'], name='logs_videow_created_1e3689_brin'),
),
migrations.AddIndex(
model_name='videomanagelog',
index=django.contrib.postgres.indexes.BrinIndex(
fields=['created'], name='logs_videom_created_42dd0b_brin'),
),
migrations.AddIndex(
model_name='videocreateworkermanagelog',
index=django.contrib.postgres.indexes.BrinIndex(
fields=['created'], name='logs_videoc_created_824c0d_brin'),
),
migrations.AddIndex(
model_name='userworkermanagelog',
index=django.contrib.postgres.indexes.BrinIndex(
fields=['created'], name='logs_userwo_created_884608_brin'),
),
migrations.AddIndex(
model_name='usermanagelog',
index=django.contrib.postgres.indexes.BrinIndex(
fields=['created'], name='logs_userma_created_b4d1bc_brin'),
),
migrations.AddIndex(
model_name='usercreateworkermanagelog',
index=django.contrib.postgres.indexes.BrinIndex(
fields=['created'], name='logs_usercr_created_8cde54_brin'),
),
migrations.AddIndex(
model_name='surveyworkermanagelog',
index=django.contrib.postgres.indexes.BrinIndex(
fields=['created'], name='logs_survey_created_84b66c_brin'),
),
migrations.AddIndex(
model_name='surveymanagelog',
index=django.contrib.postgres.indexes.BrinIndex(
fields=['created'], name='logs_survey_created_b32d06_brin'),
),
migrations.AddIndex(
model_name='surveycreateworkermanagelog',
index=django.contrib.postgres.indexes.BrinIndex(
fields=['created'], name='logs_survey_created_84c458_brin'),
),
migrations.AddIndex(
model_name='photoworkermanagelog',
index=django.contrib.postgres.indexes.BrinIndex(
fields=['created'], name='logs_photow_created_872f85_brin'),
),
migrations.AddIndex(
model_name='photomanagelog',
index=django.contrib.postgres.indexes.BrinIndex(
fields=['created'], name='logs_photom_created_fd3694_brin'),
),
migrations.AddIndex(
model_name='photocreateworkermanagelog',
index=django.contrib.postgres.indexes.BrinIndex(
fields=['created'], name='logs_photoc_created_f47f50_brin'),
),
migrations.AddIndex(
model_name='electnewworkermanagelog',
index=django.contrib.postgres.indexes.BrinIndex(
fields=['created'], name='logs_electn_created_8e4f89_brin'),
),
migrations.AddIndex(
model_name='electnewmanagelog',
index=django.contrib.postgres.indexes.BrinIndex(
fields=['created'], name='logs_electn_created_bbce86_brin'),
),
migrations.AddIndex(
model_name='electnewcreateworkermanagelog',
index=django.contrib.postgres.indexes.BrinIndex(
fields=['created'], name='logs_electn_created_e0d7a1_brin'),
),
migrations.AddIndex(
model_name='communityworkermanagelog',
index=django.contrib.postgres.indexes.BrinIndex(
fields=['created'], name='logs_commun_created_ac05c9_brin'),
),
migrations.AddIndex(
model_name='communitymanagelog',
index=django.contrib.postgres.indexes.BrinIndex(
fields=['created'], name='logs_commun_created_8461e1_brin'),
),
migrations.AddIndex(
model_name='communitycreateworkermanagelog',
index=django.contrib.postgres.indexes.BrinIndex(
fields=['created'], name='logs_commun_created_94be02_brin'),
),
migrations.AddIndex(
model_name='audioworkermanagelog',
index=django.contrib.postgres.indexes.BrinIndex(
fields=['created'], name='logs_audiow_created_741078_brin'),
),
migrations.AddIndex(
model_name='audiomanagelog',
index=django.contrib.postgres.indexes.BrinIndex(
fields=['created'], name='logs_audiom_created_2ca5ad_brin'),
),
migrations.AddIndex(
model_name='audiocreateworkermanagelog',
index=django.contrib.postgres.indexes.BrinIndex(
fields=['created'], name='logs_audioc_created_a53a52_brin'),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
]
operations = [
migrations.CreateModel(
name='DBLog',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('logger_name',
models.CharField(max_length=100, verbose_name='Logger')),
('level',
models.PositiveSmallIntegerField(choices=[(0, 'NotSet'),
(20, 'Info'),
(30, 'Warning'),
(10, 'Debug'),
(40, 'Error'),
(50, 'Fatal')],
db_index=True,
default=40,
verbose_name='Log Level')),
('message', models.TextField(verbose_name='Message')),
('trace',
models.TextField(blank=True,
null=True,
verbose_name='Stack Trace')),
('request_info',
models.TextField(blank=True,
null=True,
verbose_name='Request Info')),
('created_at',
models.DateTimeField(auto_now_add=True,
verbose_name='Created at')),
('processed',
models.BooleanField(default=False,
verbose_name='Processing complete')),
('user',
django_userforeignkey.models.fields.UserForeignKey(
blank=True,
editable=False,
null=True,
on_delete=django.db.models.deletion.SET_NULL,
related_name='db_logs',
to=settings.AUTH_USER_MODEL,
verbose_name='User')),
],
options={
'verbose_name': 'Log',
'verbose_name_plural': 'Logs',
'ordering': ('-created_at', ),
},
),
migrations.AddIndex(
model_name='dblog',
index=models.Index(fields=['message', 'trace'],
name='db_logging__message_18933f_idx'),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = []
operations = [
migrations.CreateModel(
name='AWSAccountAlias',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('account_id', models.CharField(max_length=50, unique=True)),
('account_alias', models.CharField(max_length=63, null=True)),
],
),
migrations.CreateModel(
name='AWSCostEntry',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('interval_start', models.DateTimeField()),
('interval_end', models.DateTimeField()),
],
),
migrations.CreateModel(
name='AWSCostEntryBill',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('billing_resource',
models.CharField(default='aws', max_length=50)),
('bill_type', models.CharField(max_length=50)),
('payer_account_id', models.CharField(max_length=50)),
('billing_period_start', models.DateTimeField()),
('billing_period_end', models.DateTimeField()),
],
),
migrations.CreateModel(
name='AWSCostEntryLineItem',
fields=[
('id', models.BigAutoField(primary_key=True, serialize=False)),
('hash', models.TextField(null=True)),
('tags',
django.contrib.postgres.fields.jsonb.JSONField(null=True)),
('invoice_id', models.CharField(max_length=63, null=True)),
('line_item_type', models.CharField(max_length=50)),
('usage_account_id', models.CharField(max_length=50)),
('usage_start', models.DateTimeField()),
('usage_end', models.DateTimeField()),
('product_code', models.CharField(max_length=50)),
('usage_type', models.CharField(max_length=50, null=True)),
('operation', models.CharField(max_length=50, null=True)),
('availability_zone', models.CharField(max_length=50,
null=True)),
('resource_id', models.CharField(max_length=256, null=True)),
('usage_amount',
models.DecimalField(decimal_places=9,
max_digits=17,
null=True)),
('normalization_factor', models.FloatField(null=True)),
('normalized_usage_amount',
models.DecimalField(decimal_places=9,
max_digits=17,
null=True)),
('currency_code', models.CharField(max_length=10)),
('unblended_rate',
models.DecimalField(decimal_places=9,
max_digits=17,
null=True)),
('unblended_cost',
models.DecimalField(decimal_places=9,
max_digits=17,
null=True)),
('blended_rate',
models.DecimalField(decimal_places=9,
max_digits=17,
null=True)),
('blended_cost',
models.DecimalField(decimal_places=9,
max_digits=17,
null=True)),
('public_on_demand_cost',
models.DecimalField(decimal_places=9,
max_digits=17,
null=True)),
('public_on_demand_rate',
models.DecimalField(decimal_places=9,
max_digits=17,
null=True)),
('reservation_amortized_upfront_fee',
models.DecimalField(decimal_places=9,
max_digits=17,
null=True)),
('reservation_amortized_upfront_cost_for_usage',
models.DecimalField(decimal_places=9,
max_digits=17,
null=True)),
('reservation_recurring_fee_for_usage',
models.DecimalField(decimal_places=9,
max_digits=17,
null=True)),
('reservation_unused_quantity',
models.DecimalField(decimal_places=9,
max_digits=17,
null=True)),
('reservation_unused_recurring_fee',
models.DecimalField(decimal_places=9,
max_digits=17,
null=True)),
('tax_type', models.TextField(null=True)),
],
),
migrations.CreateModel(
name='AWSCostEntryLineItemAggregates',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('time_scope_value', models.IntegerField()),
('report_type', models.CharField(max_length=50)),
('usage_account_id', models.CharField(max_length=50,
null=True)),
('product_code', models.CharField(max_length=50)),
('region', models.CharField(max_length=50, null=True)),
('availability_zone', models.CharField(max_length=50,
null=True)),
('usage_amount',
models.DecimalField(decimal_places=9,
max_digits=17,
null=True)),
('unblended_cost',
models.DecimalField(decimal_places=9,
max_digits=17,
null=True)),
('resource_count', models.IntegerField(null=True)),
],
options={
'db_table': 'reporting_awscostentrylineitem_aggregates',
},
),
migrations.CreateModel(
name='AWSCostEntryLineItemDaily',
fields=[
('id', models.BigAutoField(primary_key=True, serialize=False)),
('line_item_type', models.CharField(max_length=50)),
('usage_account_id', models.CharField(max_length=50)),
('usage_start', models.DateTimeField()),
('usage_end', models.DateTimeField(null=True)),
('product_code', models.CharField(max_length=50)),
('usage_type', models.CharField(max_length=50, null=True)),
('operation', models.CharField(max_length=50, null=True)),
('availability_zone', models.CharField(max_length=50,
null=True)),
('resource_id', models.CharField(max_length=256, null=True)),
('usage_amount', models.FloatField(null=True)),
('normalization_factor', models.FloatField(null=True)),
('normalized_usage_amount', models.FloatField(null=True)),
('currency_code', models.CharField(max_length=10)),
('unblended_rate',
models.DecimalField(decimal_places=9,
max_digits=17,
null=True)),
('unblended_cost',
models.DecimalField(decimal_places=9,
max_digits=17,
null=True)),
('blended_rate',
models.DecimalField(decimal_places=9,
max_digits=17,
null=True)),
('blended_cost',
models.DecimalField(decimal_places=9,
max_digits=17,
null=True)),
('public_on_demand_cost',
models.DecimalField(decimal_places=9,
max_digits=17,
null=True)),
('public_on_demand_rate',
models.DecimalField(decimal_places=9,
max_digits=17,
null=True)),
('tax_type', models.TextField(null=True)),
('tags',
django.contrib.postgres.fields.jsonb.JSONField(null=True)),
],
options={
'db_table': 'reporting_awscostentrylineitem_daily',
},
),
migrations.CreateModel(
name='AWSCostEntryLineItemDailySummary',
fields=[
('id', models.BigAutoField(primary_key=True, serialize=False)),
('usage_start', models.DateTimeField()),
('usage_end', models.DateTimeField(null=True)),
('usage_account_id', models.CharField(max_length=50)),
('product_code', models.CharField(max_length=50)),
('product_family', models.CharField(max_length=150,
null=True)),
('availability_zone', models.CharField(max_length=50,
null=True)),
('region', models.CharField(max_length=50, null=True)),
('instance_type', models.CharField(max_length=50, null=True)),
('unit', models.CharField(max_length=63, null=True)),
('resource_count', models.IntegerField(null=True)),
('usage_amount', models.FloatField(null=True)),
('normalization_factor', models.FloatField(null=True)),
('normalized_usage_amount', models.FloatField(null=True)),
('currency_code', models.CharField(max_length=10)),
('unblended_rate',
models.DecimalField(decimal_places=9,
max_digits=17,
null=True)),
('unblended_cost',
models.DecimalField(decimal_places=9,
max_digits=17,
null=True)),
('blended_rate',
models.DecimalField(decimal_places=9,
max_digits=17,
null=True)),
('blended_cost',
models.DecimalField(decimal_places=9,
max_digits=17,
null=True)),
('public_on_demand_cost',
models.DecimalField(decimal_places=9,
max_digits=17,
null=True)),
('public_on_demand_rate',
models.DecimalField(decimal_places=9,
max_digits=17,
null=True)),
('tax_type', models.TextField(null=True)),
],
options={
'db_table': 'reporting_awscostentrylineitem_daily_summary',
},
),
migrations.CreateModel(
name='AWSCostEntryPricing',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('term', models.CharField(max_length=63, null=True)),
('unit', models.CharField(max_length=63, null=True)),
],
),
migrations.CreateModel(
name='AWSCostEntryProduct',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('sku', models.CharField(max_length=128, null=True)),
('product_name', models.CharField(max_length=63, null=True)),
('product_family', models.CharField(max_length=150,
null=True)),
('service_code', models.CharField(max_length=50, null=True)),
('region', models.CharField(max_length=50, null=True)),
('instance_type', models.CharField(max_length=50, null=True)),
('memory', models.FloatField(null=True)),
('memory_unit', models.CharField(max_length=24, null=True)),
('vcpu', models.PositiveIntegerField(null=True)),
],
),
migrations.CreateModel(
name='AWSCostEntryReservation',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('reservation_arn', models.TextField(unique=True)),
('number_of_reservations',
models.PositiveIntegerField(null=True)),
('units_per_reservation',
models.DecimalField(decimal_places=9,
max_digits=17,
null=True)),
('start_time', models.DateTimeField(null=True)),
('end_time', models.DateTimeField(null=True)),
],
),
migrations.AddIndex(
model_name='awscostentryproduct',
index=models.Index(fields=['region'], name='region_idx'),
),
migrations.AlterUniqueTogether(
name='awscostentryproduct',
unique_together={('sku', 'product_name', 'region')},
),
migrations.AlterUniqueTogether(
name='awscostentrypricing',
unique_together={('term', 'unit')},
),
migrations.AddField(
model_name='awscostentrylineitemdailysummary',
name='account_alias',
field=models.ForeignKey(
null=True,
on_delete=django.db.models.deletion.PROTECT,
to='reporting.AWSAccountAlias'),
),
migrations.AddField(
model_name='awscostentrylineitemdaily',
name='cost_entry_pricing',
field=models.ForeignKey(
null=True,
on_delete=django.db.models.deletion.PROTECT,
to='reporting.AWSCostEntryPricing'),
),
migrations.AddField(
model_name='awscostentrylineitemdaily',
name='cost_entry_product',
field=models.ForeignKey(
null=True,
on_delete=django.db.models.deletion.PROTECT,
to='reporting.AWSCostEntryProduct'),
),
migrations.AddField(
model_name='awscostentrylineitemdaily',
name='cost_entry_reservation',
field=models.ForeignKey(
null=True,
on_delete=django.db.models.deletion.PROTECT,
to='reporting.AWSCostEntryReservation'),
),
migrations.AddField(
model_name='awscostentrylineitem',
name='cost_entry',
field=models.ForeignKey(
on_delete=django.db.models.deletion.PROTECT,
to='reporting.AWSCostEntry'),
),
migrations.AddField(
model_name='awscostentrylineitem',
name='cost_entry_bill',
field=models.ForeignKey(
on_delete=django.db.models.deletion.PROTECT,
to='reporting.AWSCostEntryBill'),
),
migrations.AddField(
model_name='awscostentrylineitem',
name='cost_entry_pricing',
field=models.ForeignKey(
null=True,
on_delete=django.db.models.deletion.PROTECT,
to='reporting.AWSCostEntryPricing'),
),
migrations.AddField(
model_name='awscostentrylineitem',
name='cost_entry_product',
field=models.ForeignKey(
null=True,
on_delete=django.db.models.deletion.PROTECT,
to='reporting.AWSCostEntryProduct'),
),
migrations.AddField(
model_name='awscostentrylineitem',
name='cost_entry_reservation',
field=models.ForeignKey(
null=True,
on_delete=django.db.models.deletion.PROTECT,
to='reporting.AWSCostEntryReservation'),
),
migrations.AddField(
model_name='awscostentry',
name='bill',
field=models.ForeignKey(
on_delete=django.db.models.deletion.PROTECT,
to='reporting.AWSCostEntryBill'),
),
migrations.AddIndex(
model_name='awscostentrylineitemdailysummary',
index=models.Index(fields=['usage_start'],
name='summary_usage_start_idx'),
),
migrations.AddIndex(
model_name='awscostentrylineitemdailysummary',
index=models.Index(fields=['product_code'],
name='summary_product_code_idx'),
),
migrations.AddIndex(
model_name='awscostentrylineitemdailysummary',
index=models.Index(fields=['usage_account_id'],
name='summary_usage_account_id_idx'),
),
migrations.AddIndex(
model_name='awscostentrylineitemdaily',
index=models.Index(fields=['usage_start'], name='usage_start_idx'),
),
migrations.AddIndex(
model_name='awscostentrylineitemdaily',
index=models.Index(fields=['product_code'],
name='product_code_idx'),
),
migrations.AddIndex(
model_name='awscostentrylineitemdaily',
index=models.Index(fields=['usage_account_id'],
name='usage_account_id_idx'),
),
migrations.AlterUniqueTogether(
name='awscostentrylineitem',
unique_together={('hash', 'cost_entry')},
),
migrations.AddIndex(
model_name='awscostentry',
index=models.Index(fields=['interval_start'],
name='interval_start_idx'),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = []
operations = [
migrations.CreateModel(
name='Post',
fields=[
('post_id',
models.IntegerField(primary_key=True, serialize=False)),
('title', models.TextField(blank=True, null=True)),
('description', models.TextField(blank=True, null=True)),
('like_count', models.IntegerField()),
('dislike_count', models.IntegerField()),
('created_on', models.DateTimeField(auto_now_add=True)),
('updated_on', models.DateTimeField(auto_now=True)),
('is_deleted', models.BooleanField(default=False)),
],
),
migrations.CreateModel(
name='User',
fields=[
('user_id',
models.CharField(editable=False,
max_length=200,
primary_key=True,
serialize=False)),
('first_name', models.CharField(max_length=100)),
('last_name', models.CharField(max_length=100)),
('full_name', models.CharField(max_length=200)),
('password_hash', models.CharField(max_length=1000)),
('email',
models.EmailField(blank=True,
db_index=True,
max_length=70,
null=True,
unique=True)),
('phone_number',
models.CharField(blank=True, max_length=20, null=True)),
('user_image',
models.ImageField(blank=True, null=True,
upload_to='images/')),
('is_deleted', models.BooleanField(default=False)),
('is_verified', models.BooleanField(default=False)),
('created_on', models.DateTimeField(auto_now_add=True)),
('updated_on', models.DateTimeField(auto_now=True)),
],
),
migrations.CreateModel(
name='Token',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('refresh_token', models.TextField(blank=True, null=True)),
('access_token', models.TextField(blank=True, null=True)),
('created_on', models.DateTimeField(auto_now_add=True)),
('updated_on', models.DateTimeField(auto_now=True)),
('is_expired', models.BooleanField(default=False)),
('user_id',
models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.DO_NOTHING,
to='api_v0.User')),
],
),
migrations.CreateModel(
name='PostTag',
fields=[
('post_tag_id',
models.IntegerField(primary_key=True, serialize=False)),
('tag', models.TextField(blank=True, null=True)),
('weight', models.IntegerField()),
('created_on', models.DateTimeField(auto_now_add=True)),
('updated_on', models.DateTimeField(auto_now=True)),
('post',
models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.DO_NOTHING,
related_name='post_tags',
to='api_v0.Post')),
],
),
migrations.CreateModel(
name='PostLike',
fields=[
('post_like_id',
models.CharField(editable=False,
max_length=200,
primary_key=True,
serialize=False)),
('is_like', models.BooleanField(default=False)),
('created_on', models.DateTimeField(auto_now_add=True)),
('updated_on', models.DateTimeField(auto_now=True)),
('post_id',
models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.DO_NOTHING,
related_name='post_data',
to='api_v0.Post')),
('user_id',
models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.DO_NOTHING,
to='api_v0.User')),
],
),
migrations.CreateModel(
name='PostImage',
fields=[
('post_image_id',
models.IntegerField(primary_key=True, serialize=False)),
('image_url',
models.ImageField(blank=True, null=True,
upload_to='images/')),
('created_on', models.DateTimeField(auto_now_add=True)),
('updated_on', models.DateTimeField(auto_now=True)),
('post_id',
models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.DO_NOTHING,
related_name='post_images',
to='api_v0.Post')),
],
),
migrations.AddIndex(
model_name='postlike',
index=models.Index(fields=['user_id', 'post_id'],
name='api_v0_post_user_id_bead9d_idx'),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = []
operations = [
migrations.CreateModel(
name='OneWayDevice',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('device_name', models.CharField(max_length=255)),
('port', models.CharField(max_length=40)),
('port_status', models.CharField(max_length=10)),
('port_phy_status', models.CharField(max_length=10)),
('port_des', models.CharField(max_length=255)),
('record_time', models.DateTimeField()),
],
options={
'ordering': ['-record_time'],
},
),
migrations.CreateModel(
name='OpticalMoudleDiff',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('device_name', models.CharField(max_length=255)),
('port', models.CharField(max_length=40)),
('now_moudle', models.CharField(max_length=60)),
('ever_moudle', models.CharField(max_length=60)),
('status',
models.CharField(choices=[('NEW', 'plugin'),
('MISS', 'missing'),
('CH', 'changed')],
max_length=20)),
('record_time', models.DateTimeField(auto_now_add=True)),
],
options={
'ordering': ['-record_time'],
},
),
migrations.CreateModel(
name='PortErrorDiff',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('device_name', models.CharField(max_length=255)),
('port', models.CharField(max_length=40)),
('nowCRC', models.IntegerField()),
('nowIpv4HeaderError', models.IntegerField()),
('everCRC', models.IntegerField()),
('everIpv4HeaderError', models.IntegerField()),
('stateCRC', models.FloatField()),
('stateIpv4HeadError', models.FloatField()),
('record_time', models.DateTimeField(auto_now_add=True)),
],
options={
'ordering': ['-id'],
},
),
migrations.CreateModel(
name='PortErrorFixRecord',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('device_name', models.CharField(max_length=255)),
('port', models.CharField(max_length=40)),
('problem_type', models.CharField(max_length=40)),
('problem_detail', models.TextField(null=True)),
('begin_time', models.DateTimeField(auto_now_add=True)),
('end_time', models.DateTimeField(null=True)),
('worker', models.CharField(max_length=100)),
('status', models.BooleanField(default=False)),
],
),
migrations.CreateModel(
name='PortPerf',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('device_name', models.CharField(max_length=255)),
('port', models.CharField(max_length=40)),
('tx_now_power', models.FloatField()),
('tx_high_warm', models.FloatField()),
('tx_low_warm', models.FloatField()),
('tx_state', models.IntegerField()),
('rx_now_power', models.FloatField()),
('rx_high_warm', models.FloatField()),
('rx_low_warm', models.FloatField()),
('rx_state', models.IntegerField()),
('utility_in', models.FloatField()),
('utility_out', models.FloatField()),
('record_time', models.DateTimeField()),
],
options={
'ordering': ['-record_time'],
},
),
migrations.AddIndex(
model_name='portperf',
index=models.Index(fields=['device_name'],
name='inspection__device__1efd93_idx'),
),
migrations.AddIndex(
model_name='portperf',
index=models.Index(fields=['port'],
name='inspection__port_a20512_idx'),
),
migrations.AddIndex(
model_name='porterrordiff',
index=models.Index(fields=['device_name'],
name='inspection__device__84792d_idx'),
),
migrations.AddIndex(
model_name='porterrordiff',
index=models.Index(fields=['port'],
name='inspection__port_885f82_idx'),
),
migrations.AddIndex(
model_name='onewaydevice',
index=models.Index(fields=['device_name'],
name='inspection__device__8dba78_idx'),
),
migrations.AddIndex(
model_name='onewaydevice',
index=models.Index(fields=['port'],
name='inspection__port_f434c1_idx'),
),
]
class Migration(migrations.Migration):
dependencies = [
('dojo', '0091_npm_audit_path_censoring'),
]
operations = [
migrations.RemoveIndex(
model_name='finding',
name='dojo_findin_is_Miti_aaa533_idx',
),
migrations.RemoveIndex(
model_name='finding',
name='dojo_findin_test_id_afee7e_idx',
),
migrations.RenameField(
model_name='finding',
old_name='is_Mitigated',
new_name='is_mitigated',
),
migrations.AlterField(
model_name='child_rule',
name='match_field',
field=models.CharField(choices=[
('id', 'id'), ('title', 'title'), ('date', 'date'),
('sla_start_date', 'sla_start_date'), ('cwe', 'cwe'),
('cve', 'cve'), ('cvssv3', 'cvssv3'),
('cvssv3_score', 'cvssv3_score'), ('url', 'url'),
('severity', 'severity'), ('description', 'description'),
('mitigation', 'mitigation'), ('impact', 'impact'),
('steps_to_reproduce', 'steps_to_reproduce'),
('severity_justification', 'severity_justification'),
('references', 'references'), ('test', 'test'),
('is_template', 'is_template'), ('active', 'active'),
('verified', 'verified'), ('false_p', 'false_p'),
('duplicate', 'duplicate'),
('duplicate_finding', 'duplicate_finding'),
('out_of_scope', 'out_of_scope'),
('risk_accepted', 'risk_accepted'),
('under_review', 'under_review'),
('review_requested_by', 'review_requested_by'),
('under_defect_review', 'under_defect_review'),
('defect_review_requested_by', 'defect_review_requested_by'),
('is_mitigated', 'is_mitigated'), ('thread_id', 'thread_id'),
('mitigated', 'mitigated'), ('mitigated_by', 'mitigated_by'),
('reporter', 'reporter'),
('numerical_severity', 'numerical_severity'),
('last_reviewed', 'last_reviewed'),
('last_reviewed_by', 'last_reviewed_by'),
('line_number', 'line_number'),
('sourcefilepath', 'sourcefilepath'),
('sourcefile', 'sourcefile'), ('param', 'param'),
('payload', 'payload'), ('hash_code', 'hash_code'),
('line', 'line'), ('file_path', 'file_path'),
('component_name', 'component_name'),
('component_version', 'component_version'),
('static_finding', 'static_finding'),
('dynamic_finding', 'dynamic_finding'), ('created', 'created'),
('scanner_confidence', 'scanner_confidence'),
('sonarqube_issue', 'sonarqube_issue'),
('unique_id_from_tool', 'unique_id_from_tool'),
('vuln_id_from_tool', 'vuln_id_from_tool'),
('sast_source_object', 'sast_source_object'),
('sast_sink_object', 'sast_sink_object'),
('sast_source_line', 'sast_source_line'),
('sast_source_file_path', 'sast_source_file_path'),
('nb_occurences', 'nb_occurences'),
('publish_date', 'publish_date')
],
max_length=200),
),
migrations.AlterField(
model_name='rule',
name='applied_field',
field=models.CharField(choices=[
('id', 'id'), ('title', 'title'), ('date', 'date'),
('sla_start_date', 'sla_start_date'), ('cwe', 'cwe'),
('cve', 'cve'), ('cvssv3', 'cvssv3'),
('cvssv3_score', 'cvssv3_score'), ('url', 'url'),
('severity', 'severity'), ('description', 'description'),
('mitigation', 'mitigation'), ('impact', 'impact'),
('steps_to_reproduce', 'steps_to_reproduce'),
('severity_justification', 'severity_justification'),
('references', 'references'), ('test', 'test'),
('is_template', 'is_template'), ('active', 'active'),
('verified', 'verified'), ('false_p', 'false_p'),
('duplicate', 'duplicate'),
('duplicate_finding', 'duplicate_finding'),
('out_of_scope', 'out_of_scope'),
('risk_accepted', 'risk_accepted'),
('under_review', 'under_review'),
('review_requested_by', 'review_requested_by'),
('under_defect_review', 'under_defect_review'),
('defect_review_requested_by', 'defect_review_requested_by'),
('is_mitigated', 'is_mitigated'), ('thread_id', 'thread_id'),
('mitigated', 'mitigated'), ('mitigated_by', 'mitigated_by'),
('reporter', 'reporter'),
('numerical_severity', 'numerical_severity'),
('last_reviewed', 'last_reviewed'),
('last_reviewed_by', 'last_reviewed_by'),
('line_number', 'line_number'),
('sourcefilepath', 'sourcefilepath'),
('sourcefile', 'sourcefile'), ('param', 'param'),
('payload', 'payload'), ('hash_code', 'hash_code'),
('line', 'line'), ('file_path', 'file_path'),
('component_name', 'component_name'),
('component_version', 'component_version'),
('static_finding', 'static_finding'),
('dynamic_finding', 'dynamic_finding'), ('created', 'created'),
('scanner_confidence', 'scanner_confidence'),
('sonarqube_issue', 'sonarqube_issue'),
('unique_id_from_tool', 'unique_id_from_tool'),
('vuln_id_from_tool', 'vuln_id_from_tool'),
('sast_source_object', 'sast_source_object'),
('sast_sink_object', 'sast_sink_object'),
('sast_source_line', 'sast_source_line'),
('sast_source_file_path', 'sast_source_file_path'),
('nb_occurences', 'nb_occurences'),
('publish_date', 'publish_date')
],
max_length=200),
),
migrations.AlterField(
model_name='rule',
name='match_field',
field=models.CharField(choices=[
('id', 'id'), ('title', 'title'), ('date', 'date'),
('sla_start_date', 'sla_start_date'), ('cwe', 'cwe'),
('cve', 'cve'), ('cvssv3', 'cvssv3'),
('cvssv3_score', 'cvssv3_score'), ('url', 'url'),
('severity', 'severity'), ('description', 'description'),
('mitigation', 'mitigation'), ('impact', 'impact'),
('steps_to_reproduce', 'steps_to_reproduce'),
('severity_justification', 'severity_justification'),
('references', 'references'), ('test', 'test'),
('is_template', 'is_template'), ('active', 'active'),
('verified', 'verified'), ('false_p', 'false_p'),
('duplicate', 'duplicate'),
('duplicate_finding', 'duplicate_finding'),
('out_of_scope', 'out_of_scope'),
('risk_accepted', 'risk_accepted'),
('under_review', 'under_review'),
('review_requested_by', 'review_requested_by'),
('under_defect_review', 'under_defect_review'),
('defect_review_requested_by', 'defect_review_requested_by'),
('is_mitigated', 'is_mitigated'), ('thread_id', 'thread_id'),
('mitigated', 'mitigated'), ('mitigated_by', 'mitigated_by'),
('reporter', 'reporter'),
('numerical_severity', 'numerical_severity'),
('last_reviewed', 'last_reviewed'),
('last_reviewed_by', 'last_reviewed_by'),
('line_number', 'line_number'),
('sourcefilepath', 'sourcefilepath'),
('sourcefile', 'sourcefile'), ('param', 'param'),
('payload', 'payload'), ('hash_code', 'hash_code'),
('line', 'line'), ('file_path', 'file_path'),
('component_name', 'component_name'),
('component_version', 'component_version'),
('static_finding', 'static_finding'),
('dynamic_finding', 'dynamic_finding'), ('created', 'created'),
('scanner_confidence', 'scanner_confidence'),
('sonarqube_issue', 'sonarqube_issue'),
('unique_id_from_tool', 'unique_id_from_tool'),
('vuln_id_from_tool', 'vuln_id_from_tool'),
('sast_source_object', 'sast_source_object'),
('sast_sink_object', 'sast_sink_object'),
('sast_source_line', 'sast_source_line'),
('sast_source_file_path', 'sast_source_file_path'),
('nb_occurences', 'nb_occurences'),
('publish_date', 'publish_date')
],
max_length=200),
),
migrations.AddIndex(
model_name='finding',
index=models.Index(fields=['test', 'is_mitigated'],
name='dojo_findin_test_id_cc0f9b_idx'),
),
migrations.AddIndex(
model_name='finding',
index=models.Index(fields=['is_mitigated'],
name='dojo_findin_is_miti_c0f5c1_idx'),
),
]
class Migration(migrations.Migration):
dependencies = [
('source_optics', '0010_auto_20190724_1958'),
]
operations = [
migrations.AlterModelOptions(
name='repository',
options={},
),
migrations.RemoveField(
model_name='author',
name='repos',
),
migrations.AddField(
model_name='filechange',
name='file',
field=models.ForeignKey(default=0, on_delete=django.db.models.deletion.CASCADE, related_name='+', to='source_optics.File'),
preserve_default=False,
),
migrations.AlterField(
model_name='credential',
name='name',
field=models.TextField(db_index=True, max_length=64),
),
migrations.AlterField(
model_name='organization',
name='name',
field=models.TextField(db_index=True, max_length=32, unique=True),
),
migrations.AlterField(
model_name='repository',
name='url',
field=models.TextField(db_index=True, help_text='use a git ssh url for private repos, else http/s are ok', max_length=255),
),
migrations.AlterUniqueTogether(
name='commit',
unique_together={('repo', 'sha')},
),
migrations.AlterUniqueTogether(
name='file',
unique_together={('repo', 'name', 'path', 'ext')},
),
migrations.AlterUniqueTogether(
name='filechange',
unique_together={('file', 'commit')},
),
migrations.AddIndex(
model_name='author',
index=models.Index(fields=['email'], name='source_opti_email_d3e229_idx'),
),
migrations.AddIndex(
model_name='commit',
index=models.Index(fields=['author_date', 'author', 'repo'], name='source_opti_author__cbf24f_idx'),
),
migrations.AddIndex(
model_name='repository',
index=models.Index(fields=['name', 'organization'], name='source_opti_name_5846e6_idx'),
),
migrations.RemoveField(
model_name='commit',
name='files',
),
migrations.RemoveField(
model_name='commit',
name='lines_added',
),
migrations.RemoveField(
model_name='commit',
name='lines_removed',
),
migrations.RemoveField(
model_name='file',
name='changes',
),
migrations.RemoveField(
model_name='file',
name='lines_added',
),
migrations.RemoveField(
model_name='file',
name='lines_removed',
),
migrations.RemoveField(
model_name='filechange',
name='binary',
),
migrations.RemoveField(
model_name='filechange',
name='ext',
),
migrations.RemoveField(
model_name='filechange',
name='name',
),
migrations.RemoveField(
model_name='filechange',
name='path',
),
migrations.RemoveField(
model_name='filechange',
name='repo',
),
]
class Migration(migrations.Migration):
initial = True
dependencies = []
operations = [
migrations.CreateModel(
name='CacheParameters',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('num_ways', models.IntegerField(default=2)),
('num_sets', models.IntegerField(default=4)),
('block_size', models.IntegerField(default=8)),
('address_bits', models.IntegerField(default=8)),
],
),
migrations.CreateModel(
name='CachePattern',
fields=[
('pattern_id',
models.UUIDField(default=uuid.uuid4,
editable=False,
primary_key=True,
serialize=False)),
('access_size', models.IntegerField(default=2)),
('accesses_raw', models.TextField()),
('parameters',
models.ForeignKey(on_delete=django.db.models.deletion.PROTECT,
to='cachelab.CacheParameters')),
],
),
migrations.CreateModel(
name='PatternQuestion',
fields=[
('question_id',
models.UUIDField(default=uuid.uuid4,
editable=False,
primary_key=True,
serialize=False)),
('for_user', models.TextField()),
('ask_evict', models.BooleanField(default=True)),
('index', models.IntegerField()),
('give_first', models.IntegerField(default=5)),
('pattern',
models.ForeignKey(on_delete=django.db.models.deletion.PROTECT,
to='cachelab.CachePattern')),
],
),
migrations.CreateModel(
name='PatternAnswer',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('access_results_raw', models.TextField()),
('final_state_raw', models.TextField()),
('score', models.IntegerField()),
('max_score', models.IntegerField()),
('was_complete', models.BooleanField(default=False)),
('was_save', models.BooleanField(default=False)),
('submit_time', models.DateTimeField(auto_now=True)),
('for_user', models.TextField()),
('question',
models.ForeignKey(on_delete=django.db.models.deletion.PROTECT,
to='cachelab.PatternQuestion')),
],
),
migrations.CreateModel(
name='ParameterQuestion',
fields=[
('question_id',
models.UUIDField(default=uuid.uuid4,
editable=False,
primary_key=True,
serialize=False)),
('for_user', models.TextField()),
('missing_parts_raw', models.TextField()),
('given_parts_raw', models.TextField()),
('index', models.IntegerField()),
('parameters',
models.ForeignKey(on_delete=django.db.models.deletion.PROTECT,
to='cachelab.CacheParameters')),
],
),
migrations.CreateModel(
name='ParameterAnswer',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('for_user', models.TextField()),
('submit_time', models.DateTimeField(auto_now=True)),
('answer_raw', models.TextField()),
('was_complete', models.BooleanField()),
('was_save', models.BooleanField()),
('score', models.IntegerField()),
('score_ratio', models.FloatField()),
('question',
models.ForeignKey(on_delete=django.db.models.deletion.PROTECT,
to='cachelab.ParameterQuestion')),
],
),
migrations.AddIndex(
model_name='patternquestion',
index=models.Index(fields=['for_user', 'index'],
name='cachelab_pa_for_use_86fea4_idx'),
),
migrations.AddIndex(
model_name='patternanswer',
index=models.Index(fields=['for_user', 'submit_time'],
name='cachelab_pa_for_use_f33aa1_idx'),
),
migrations.AddIndex(
model_name='patternanswer',
index=models.Index(fields=['for_user', 'was_complete', 'score'],
name='cachelab_pa_for_use_d67940_idx'),
),
migrations.AddIndex(
model_name='parameteranswer',
index=models.Index(fields=['for_user', 'submit_time'],
name='cachelab_pa_for_use_df9beb_idx'),
),
migrations.AddIndex(
model_name='parameteranswer',
index=models.Index(
fields=['for_user', 'was_complete', 'score_ratio'],
name='cachelab_pa_for_use_58b78a_idx'),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
('readersRecord', '0001_initial'),
]
operations = [
migrations.CreateModel(
name='Author',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('second_name',
models.CharField(help_text='Фамилия кириллицей',
max_length=25,
verbose_name='фамилия')),
('first_name',
models.CharField(help_text='Имя кириллицей',
max_length=25,
verbose_name='имя')),
('middle_name',
models.CharField(
blank=True,
help_text='Отчество кириллицей, необязательно',
max_length=25,
verbose_name='отчество')),
],
options={
'verbose_name': 'автор',
'verbose_name_plural': 'авторы',
'ordering': ['second_name', 'first_name', 'middle_name'],
'abstract': False,
},
),
migrations.CreateModel(
name='Book',
fields=[
('isbn',
models.BigIntegerField(
help_text=
'ISBN код книги, указанный на штрих-коде сзади, уникален для каждого издания',
primary_key=True,
serialize=False,
unique=True,
validators=[booksRecord.validators.ean13_validator],
verbose_name='ISBN код')),
('name',
models.CharField(help_text='Официальное название книги',
max_length=65,
verbose_name='название')),
('year_of_publication',
models.SmallIntegerField(verbose_name='год издания')),
('edition',
models.SmallIntegerField(verbose_name='номер издания')),
('publication_city',
models.CharField(help_text='город издания книги, без "г. "',
max_length=30,
verbose_name='город издания')),
('grade',
models.CharField(
blank=True,
help_text=
'Для учебных книг. Может быть диапазоном, к примеру: «Физика. Задачник. 7-9 класс»',
max_length=5,
validators=[booksRecord.validators.grade_validator],
verbose_name='класс')),
('inventory_number',
models.PositiveSmallIntegerField(
help_text='инвентарный номер из Книги Учёта',
verbose_name='инвентарный номер')),
],
options={
'verbose_name': 'книга',
'verbose_name_plural': 'книги',
'ordering': ['name'],
},
),
migrations.CreateModel(
name='BookInstance',
fields=[
('id',
models.PositiveIntegerField(
help_text=
'идентификатор книги, уникальный для каждого экземпляра; совпадает с номером штрихкода на наклейке',
primary_key=True,
serialize=False,
unique=True,
verbose_name='индивидуальный идентификатор')),
],
options={
'verbose_name': 'экземпляр книги',
'verbose_name_plural': 'экземпляры книг',
'ordering': ['book'],
},
),
migrations.CreateModel(
name='Publisher',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name',
models.CharField(
db_index=True,
help_text=
'Официальное наименование \nиздательства, без слов "Издательство", "ООО", "ПАО" и т. п.',
max_length=65,
unique=True,
verbose_name='наименование')),
],
options={
'verbose_name': 'издательство',
'verbose_name_plural': 'издательства',
'ordering': ['name'],
},
),
migrations.CreateModel(
name='Subject',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name',
models.CharField(max_length=25, verbose_name='название')),
],
options={
'verbose_name': 'предмет',
'verbose_name_plural': 'предметы',
},
),
migrations.CreateModel(
name='TakenBook',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('date_time',
models.DateTimeField(auto_now_add=True,
verbose_name='Дата и время взятия')),
('book',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='booksRecord.Book',
verbose_name='книга')),
('student',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='readersRecord.Student',
verbose_name='ученик')),
],
),
migrations.AddIndex(
model_name='subject',
index=models.Index(fields=['name'],
name='booksRecord_name_6577b9_idx'),
),
migrations.AddIndex(
model_name='publisher',
index=models.Index(fields=['name'],
name='booksRecord_name_84ea29_idx'),
),
migrations.AddField(
model_name='bookinstance',
name='book',
field=models.ForeignKey(
help_text='ссылка на модель Книга :Model:`booksRecord.Book`',
on_delete=django.db.models.deletion.CASCADE,
to='booksRecord.Book',
verbose_name='книга'),
),
migrations.AddField(
model_name='book',
name='authors',
field=models.ManyToManyField(
help_text=
'Автор или авторы книги, ссылается на :Model:`booksRecord.Author`',
to='booksRecord.Author',
verbose_name='автор(-ы)'),
),
migrations.AddField(
model_name='book',
name='publisher',
field=models.ForeignKey(
db_index=False,
on_delete=django.db.models.deletion.PROTECT,
to='booksRecord.Publisher',
verbose_name='издательство'),
),
migrations.AddField(
model_name='book',
name='subject',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to='booksRecord.Subject',
verbose_name='предмет'),
),
migrations.AddIndex(
model_name='author',
index=models.Index(fields=['second_name', 'first_name'],
name='booksRecord_second__450692_idx'),
),
migrations.AddIndex(
model_name='book',
index=models.Index(fields=['name'],
name='booksRecord_name_437698_idx'),
),
migrations.AddIndex(
model_name='book',
index=models.Index(fields=['inventory_number'],
name='booksRecord_invento_8394ea_idx'),
),
migrations.AddIndex(
model_name='book',
index=models.Index(fields=['grade', 'subject'],
name='booksRecord_grade_5f3938_idx'),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
('auth', '0012_alter_user_first_name_max_length'),
]
operations = [
migrations.CreateModel(
name='User',
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')),
('email',
models.EmailField(blank=True,
max_length=127,
null=True,
unique=True)),
('username', models.CharField(max_length=100, unique=True)),
('first_name',
models.CharField(blank=True, max_length=50, null=True)),
('last_name',
models.CharField(blank=True, max_length=50, null=True)),
('date_joined', models.DateTimeField(auto_now_add=True)),
('is_staff', models.BooleanField(default=False)),
('is_private', models.BooleanField(default=False)),
('is_active', models.BooleanField(default=True)),
('is_verified', models.BooleanField(default=False)),
('verification_uuid', models.UUIDField(default=uuid.uuid4)),
('groups',
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')),
('user_permissions',
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')),
],
options={
'ordering': ('username', ),
},
),
migrations.CreateModel(
name='Profile',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('gender',
models.CharField(blank=True,
choices=[('MALE', 'MALE'),
('FEMALE', 'FEMALE')],
max_length=30,
null=True)),
('dob', models.DateField(blank=True, null=True)),
('locale',
models.CharField(blank=True, default='', max_length=100)),
('user',
models.OneToOneField(
on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
],
),
migrations.AddIndex(
model_name='user',
index=models.Index(fields=['username'],
name='users_user_usernam_65d164_idx'),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
]
operations = [
migrations.CreateModel(
name='Article',
fields=[
('id', models.AutoField(primary_key=True, serialize=False, verbose_name='ID')),
('lang', models.SmallIntegerField(choices=[(1, '中文'), (2, '英文')], default=1, verbose_name='语言')),
('title', models.CharField(max_length=255, verbose_name='标题')),
('summary', models.CharField(blank=True, default='', help_text='可以为空，可用于亮点案例的简介', max_length=255, verbose_name='概述')),
('author', models.CharField(default='', max_length=255, verbose_name='编辑')),
('content', tinymce.models.HTMLField(default='', verbose_name='正文内容')),
('create_time', models.DateTimeField(auto_now_add=True, verbose_name='创建时间')),
('modify_time', models.DateTimeField(auto_now=True, verbose_name='修改时间')),
('enable', models.BooleanField(default=False, help_text='是否发布可见，默认不发布可见，一般在文章编辑完成后再发布可见', verbose_name='发布状态')),
],
options={
'verbose_name': '1_文章',
'verbose_name_plural': '1_文章',
'ordering': ['-id'],
},
),
migrations.CreateModel(
name='Publication',
fields=[
('id', models.AutoField(primary_key=True, serialize=False, verbose_name='ID')),
('topic', models.SmallIntegerField(choices=[(1, '指标案例'), (2, '最新动态'), (3, '数据共享'), (4, '前沿扫描'), (5, '亮点案例')], default=2, verbose_name='主题')),
('cover_image', filebrowser.fields.FileBrowseField(blank=True, default='', help_text='可以不配置，但主题为亮点案例时, 需要配置封面图轮播展示', max_length=1024, verbose_name='封面图片')),
('title', models.CharField(help_text='可以用要发布的文章的标题，每个发布内容对应着不同语言版本的文章，各种语言版本的文章需要关联到同一个发布内容，以便各种语言版本文章之间的切换', max_length=255, verbose_name='内容标题')),
('enable', models.BooleanField(default=False, help_text='是否发布可见，默认不发布可见，一般在文章编辑完成后再发布可见', verbose_name='发布状态')),
('remarks', models.CharField(blank=True, default='', max_length=255, verbose_name='备注')),
],
options={
'verbose_name': '0_发布内容',
'verbose_name_plural': '0_发布内容',
'ordering': ['-id'],
},
),
migrations.AddIndex(
model_name='publication',
index=models.Index(fields=['topic'], name='idx_topic'),
),
migrations.AddField(
model_name='article',
name='publication',
field=models.ForeignKey(help_text='不同语言版本的文章所属发布内容，例如要发布新的内容a，需要先创建发布内容a，中文版a文章和英文版a文章必须关联对应的发布内容a', null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='article_set', to='article.Publication', verbose_name='文章所属发布内容'),
),
migrations.AddIndex(
model_name='article',
index=models.Index(fields=['title'], name='idx_article_title'),
),
migrations.AddIndex(
model_name='article',
index=models.Index(fields=['create_time'], name='idx_article_create_time'),
),
migrations.AlterUniqueTogether(
name='article',
unique_together={('lang', 'publication')},
),
]
class Migration(migrations.Migration):
dependencies = [
('ad', '0001_initial'),
]
operations = [
migrations.CreateModel(
name='ChannelShieldConfig',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('channel', models.CharField(default='', max_length=100, verbose_name='\u6e20\u9053\u5c4f\u853d')),
('start_time', models.DateTimeField(verbose_name='\u5f00\u59cb\u5c4f\u853d\u65f6\u95f4')),
('end_time', models.DateTimeField(verbose_name='\u7ed3\u675f\u5c4f\u853d\u65f6\u95f4')),
('first_created', models.DateTimeField(auto_now_add=True, verbose_name='\u521b\u5efa\u65f6\u95f4')),
('last_modify', models.DateTimeField(auto_now=True, verbose_name='\u4fee\u6539\u65f6\u95f4')),
],
options={
'verbose_name': '\u6e20\u9053\u5c4f\u853d\u8bbe\u7f6e',
'verbose_name_plural': '\u6e20\u9053\u5c4f\u853d\u8bbe\u7f6e',
},
),
migrations.CreateModel(
name='ExchangeRate',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('gold_count', models.IntegerField(verbose_name='\u91d1\u5e01')),
('money', models.IntegerField(verbose_name='\u5bf9\u5e94\u4eba\u6c11\u5e01')),
('first_created', models.DateTimeField(auto_now_add=True, verbose_name='\u65e5\u671f')),
('last_modify', models.DateTimeField(auto_now=True, verbose_name='\u4fee\u6539\u65f6\u95f4')),
],
options={
'verbose_name': '\u91d1\u5e01\u6c47\u7387\u8bbe\u7f6e',
'verbose_name_plural': '\u91d1\u5e01\u6c47\u7387\u8bbe\u7f6e',
},
),
migrations.CreateModel(
name='GlobalShieldConfig',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('shield_type', models.CharField(default='', max_length=100, verbose_name='\u5c4f\u853d\u7b56\u7565')),
('shield_area', models.TextField(default='', verbose_name='\u5c4f\u853d\u5730\u57df')),
('first_created', models.DateTimeField(auto_now_add=True, verbose_name='\u521b\u5efa\u65f6\u95f4')),
('last_modify', models.DateTimeField(auto_now=True, verbose_name='\u4fee\u6539\u65f6\u95f4')),
],
options={
'verbose_name': '\u5168\u5c40\u5c4f\u853d\u8bbe\u7f6e',
'verbose_name_plural': '\u5168\u5c40\u5c4f\u853d\u8bbe\u7f6e',
},
),
migrations.CreateModel(
name='GoldConfig',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('ad_source', models.CharField(default='', max_length=200, verbose_name='\u5e7f\u544a\u6e90')),
('ad_type', models.CharField(default='', max_length=50, verbose_name='\u5e7f\u544a\u7c7b\u578b')),
('gold_count', models.IntegerField(default=0, verbose_name='\u91d1\u5e01')),
('first_created', models.DateTimeField(auto_now_add=True, verbose_name='\u521b\u5efa\u65f6\u95f4')),
('last_modify', models.DateTimeField(auto_now=True, verbose_name='\u4fee\u6539\u65f6\u95f4')),
],
options={
'verbose_name': '\u91d1\u5e01\u8bbe\u7f6e',
'verbose_name_plural': '\u91d1\u5e01\u8bbe\u7f6e',
},
),
migrations.CreateModel(
name='RewardCondition',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('typ', models.CharField(choices=[('\u9605\u8bfb\u65f6\u957f', 'read_last'), (
'\u4e0b\u8f7d\u5e94\u7528\u4f53\u9a8c\u65f6\u957f', 'experience_last')], max_length=50,
verbose_name='\u7c7b\u578b')),
('last', models.IntegerField(default=10, verbose_name='\u65f6\u957f')),
('first_created', models.DateTimeField(auto_now_add=True, verbose_name='\u65e5\u671f')),
('last_modify', models.DateTimeField(auto_now=True, verbose_name='\u4fee\u6539\u65f6\u95f4')),
],
options={
'verbose_name': '\u7ea2\u5305\u9886\u53d6\u6761\u4ef6\u8bbe\u7f6e',
'verbose_name_plural': '\u7ea2\u5305\u9886\u53d6\u6761\u4ef6\u8bbe\u7f6e',
},
),
migrations.CreateModel(
name='RewardCycle',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('cycle', models.IntegerField(default=0, verbose_name='\u5468\u671f')),
('first_created', models.DateTimeField(auto_now_add=True, verbose_name='\u65e5\u671f')),
('last_modify', models.DateTimeField(auto_now=True, verbose_name='\u4fee\u6539\u65f6\u95f4')),
],
options={
'verbose_name': '\u7ea2\u5305\u5468\u671f\u8bbe\u7f6e',
'verbose_name_plural': '\u7ea2\u5305\u5468\u671f\u8bbe\u7f6e',
},
),
migrations.CreateModel(
name='RewardCycleCount',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('count', models.IntegerField(default=0, verbose_name='\u4e2a\u6570')),
('first_created', models.DateTimeField(auto_now_add=True, verbose_name='\u65e5\u671f')),
('last_modify', models.DateTimeField(auto_now=True, verbose_name='\u4fee\u6539\u65f6\u95f4')),
],
options={
'verbose_name': '\u7ea2\u5305\u4e2a\u6570\u8bbe\u7f6e',
'verbose_name_plural': '\u7ea2\u5305\u4e2a\u6570\u8bbe\u7f6e',
},
),
migrations.AlterModelOptions(
name='adpolicy',
options={'verbose_name': '\u5e7f\u544a\u7b56\u7565\u8bbe\u7f6e',
'verbose_name_plural': '\u5e7f\u544a\u7b56\u7565\u8bbe\u7f6e'},
),
migrations.AddIndex(
model_name='rewardcyclecount',
index=models.Index(fields=['first_created'], name='ad_rewardcy_first_c_22093c_idx'),
),
migrations.AddIndex(
model_name='rewardcycle',
index=models.Index(fields=['first_created'], name='ad_rewardcy_first_c_dec0ab_idx'),
),
migrations.AddIndex(
model_name='goldconfig',
index=models.Index(fields=['ad_source', 'ad_type'], name='ad_goldconf_ad_sour_a885e6_idx'),
),
migrations.AddIndex(
model_name='exchangerate',
index=models.Index(fields=['first_created'], name='ad_exchange_first_c_090be5_idx'),
),
migrations.RunPython(forwards_func)
]
class Migration(migrations.Migration):
dependencies = [
('laws', '0001_initial'),
]
operations = [
migrations.CreateModel(
name='Chapter',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=256)),
('number', models.IntegerField(default=1)),
],
),
migrations.CreateModel(
name='Division',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=256)),
('number', models.IntegerField(default=1)),
],
),
migrations.CreateModel(
name='Law',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=128)),
('number', models.IntegerField()),
('active', models.BooleanField(default=True)),
('header', ckeditor.fields.RichTextField()),
('content', ckeditor.fields.RichTextField()),
('footer', ckeditor.fields.RichTextField()),
],
),
migrations.CreateModel(
name='LawAgency',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=64)),
],
),
migrations.CreateModel(
name='LawType',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=64)),
],
),
migrations.CreateModel(
name='Matter',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=256)),
('number', models.IntegerField()),
('chapter',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='chapters',
to='laws.Chapter')),
],
),
migrations.AddIndex(
model_name='lawtype',
index=models.Index(fields=['name'],
name='laws_lawtyp_name_1fec6e_idx'),
),
migrations.AddIndex(
model_name='lawagency',
index=models.Index(fields=['name'],
name='laws_lawage_name_af4c58_idx'),
),
migrations.AddField(
model_name='division',
name='law',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
related_name='divisions',
to='laws.Law'),
),
migrations.AddField(
model_name='chapter',
name='division',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
related_name='chapters',
to='laws.Division'),
),
migrations.AddIndex(
model_name='matter',
index=models.Index(fields=['chapter', 'name'],
name='laws_matter_chapter_5439e8_idx'),
),
migrations.AddIndex(
model_name='division',
index=models.Index(fields=['law', 'name'],
name='laws_divisi_law_id_c8d835_idx'),
),
migrations.AddIndex(
model_name='division',
index=models.Index(fields=['law', 'number'],
name='laws_divisi_law_id_e8326c_idx'),
),
migrations.AddIndex(
model_name='chapter',
index=models.Index(fields=['division', 'name'],
name='laws_chapte_divisio_860853_idx'),
),
]
class Migration(migrations.Migration):
dependencies = [
('booksRecord', '0011_auto_20190710_1523'),
]
operations = [
migrations.AlterModelOptions(
name='takenbook',
options={
'get_latest_by': 'when_taken',
'ordering': ['is_returned', 'when_taken'],
'verbose_name': 'акт взятия книги',
'verbose_name_plural': 'акты взятия книг'
},
),
migrations.RemoveIndex(
model_name='book',
name='booksRecord_grade_5f3938_idx',
),
migrations.RemoveField(
model_name='book',
name='authors',
),
migrations.AddField(
model_name='book',
name='authors',
field=models.CharField(default='DEF_VAL',
max_length=200,
verbose_name='автор(-ы)'),
preserve_default=False,
),
migrations.AlterField(
model_name='book',
name='publisher',
field=models.CharField(max_length=20, verbose_name='издательство'),
),
migrations.AlterField(
model_name='book',
name='subject',
field=models.CharField(blank=True,
max_length=20,
null=True,
verbose_name='предмет'),
),
migrations.AlterField(
model_name='takenbook',
name='when_returned',
field=models.DateTimeField(default=datetime.datetime(2020,
9,
9,
7,
0,
45,
779700,
tzinfo=utc),
verbose_name='Дата и время возврата'),
),
migrations.AddIndex(
model_name='book',
index=models.Index(fields=['grade', 'subject'],
name='booksRecord_grade_1a6f75_idx'),
),
migrations.DeleteModel(name='Author', ),
migrations.DeleteModel(name='Publisher', ),
migrations.DeleteModel(name='Subject', ),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
("variants", "0035_auto_20190403_0911"),
]
operations = [
migrations.CreateModel(
name="StructuralVariant",
fields=[
(
"id",
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name="ID"),
),
("release", models.CharField(max_length=32)),
("chromosome", models.CharField(max_length=32)),
("start", models.IntegerField()),
("end", models.IntegerField()),
("bin", models.IntegerField()),
(
"containing_bins",
django.contrib.postgres.fields.ArrayField(
base_field=models.IntegerField(), size=None),
),
("start_ci_left", models.IntegerField()),
("start_ci_right", models.IntegerField()),
("end_ci_left", models.IntegerField()),
("end_ci_right", models.IntegerField()),
("case_id", models.IntegerField()),
(
"sv_uuid",
models.UUIDField(default=uuid.uuid4,
help_text="Structural variant UUID",
unique=True),
),
("caller", models.CharField(max_length=128)),
(
"sv_type",
models.CharField(
choices=[
("DEL", "deletion"),
("DUP", "duplication"),
("INS", "insertion"),
("INV", "inversion"),
("BND", "breakend"),
("CNV", "copy number variation"),
],
max_length=32,
),
),
(
"sv_sub_type",
models.CharField(
choices=[
("DEL", "deletion"),
("DEL:ME", "mobile element deletion"),
("DEL:ME:SVA", "mobile element deletion (SVA)"),
("DEL:ME:L1", "mobile element deletion (LINE1)"),
("DEL:ME:ALU", "mobile element deletion (ALU)"),
("DUP", "duplication"),
("DUP:TANDEM", "tandem duplication"),
("INV", "inversion"),
("INS", "insertion"),
("INS:ME", "mobile_element insertion"),
("INS:ME:SVA", "mobile element deletion (SVA)"),
("INS:ME:L1", "mobile element deletion (LINE1)"),
("INS:ME:ALU", "mobile element deletion (ALU)"),
("INV", "inversion"),
("BND", "breakend"),
("CNV", "copy number variation"),
],
max_length=32,
),
),
(
"info",
django.contrib.postgres.fields.jsonb.JSONField(
default={},
help_text=
"Further information of the structural variant"),
),
("genotype", django.contrib.postgres.fields.jsonb.JSONField()),
],
),
migrations.CreateModel(
name="StructuralVariantComment",
fields=[
(
"id",
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name="ID"),
),
(
"sodar_uuid",
models.UUIDField(default=uuid.uuid4,
help_text="Annotation UUID",
unique=True),
),
(
"date_created",
models.DateTimeField(auto_now_add=True,
help_text="DateTime of creation"),
),
(
"date_modified",
models.DateTimeField(
auto_now=True,
help_text="DateTime of last modification"),
),
("bin", models.IntegerField()),
(
"containing_bins",
django.contrib.postgres.fields.ArrayField(
base_field=models.IntegerField(), size=None),
),
("release", models.CharField(max_length=32)),
("chromosome", models.CharField(max_length=32)),
("start", models.IntegerField()),
("end", models.IntegerField()),
("sv_type", models.CharField(max_length=32)),
("sv_sub_type", models.CharField(max_length=32)),
("text", models.TextField(help_text="The comment text")),
],
options={"abstract": False},
),
migrations.CreateModel(
name="StructuralVariantFlags",
fields=[
(
"id",
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name="ID"),
),
(
"sodar_uuid",
models.UUIDField(default=uuid.uuid4,
help_text="Annotation UUID",
unique=True),
),
(
"date_created",
models.DateTimeField(auto_now_add=True,
help_text="DateTime of creation"),
),
(
"date_modified",
models.DateTimeField(
auto_now=True,
help_text="DateTime of last modification"),
),
("bin", models.IntegerField()),
(
"containing_bins",
django.contrib.postgres.fields.ArrayField(
base_field=models.IntegerField(), size=None),
),
("release", models.CharField(max_length=32)),
("chromosome", models.CharField(max_length=32)),
("start", models.IntegerField()),
("end", models.IntegerField()),
("sv_type", models.CharField(max_length=32)),
("sv_sub_type", models.CharField(max_length=32)),
("flag_bookmarked", models.BooleanField(default=False)),
("flag_candidate", models.BooleanField(default=False)),
("flag_final_causative", models.BooleanField(default=False)),
("flag_for_validation", models.BooleanField(default=False)),
(
"flag_visual",
models.CharField(
choices=[
("positive", "positive"),
("uncertain", "uncertain"),
("negative", "negative"),
("empty", "empty"),
],
default="empty",
max_length=32,
),
),
(
"flag_validation",
models.CharField(
choices=[
("positive", "positive"),
("uncertain", "uncertain"),
("negative", "negative"),
("empty", "empty"),
],
default="empty",
max_length=32,
),
),
(
"flag_phenotype_match",
models.CharField(
choices=[
("positive", "positive"),
("uncertain", "uncertain"),
("negative", "negative"),
("empty", "empty"),
],
default="empty",
max_length=32,
),
),
(
"flag_summary",
models.CharField(
choices=[
("positive", "positive"),
("uncertain", "uncertain"),
("negative", "negative"),
("empty", "empty"),
],
default="empty",
max_length=32,
),
),
],
options={"abstract": False},
),
migrations.CreateModel(
name="StructuralVariantGeneAnnotation",
fields=[
(
"id",
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name="ID"),
),
(
"sv_uuid",
models.UUIDField(
default=uuid.uuid4,
help_text="Structural variant UUID foreign key"),
),
("refseq_gene_id", models.CharField(max_length=16, null=True)),
("refseq_transcript_id",
models.CharField(max_length=16, null=True)),
("refseq_transcript_coding", models.NullBooleanField()),
(
"refseq_effect",
django.contrib.postgres.fields.ArrayField(
base_field=models.CharField(max_length=64),
null=True,
size=None),
),
("ensembl_gene_id", models.CharField(max_length=16,
null=True)),
("ensembl_transcript_id",
models.CharField(max_length=32, null=True)),
("ensembl_transcript_coding", models.NullBooleanField()),
(
"ensembl_effect",
django.contrib.postgres.fields.ArrayField(
base_field=models.CharField(max_length=64, null=True),
size=None),
),
],
),
migrations.AddIndex(
model_name="structuralvariantgeneannotation",
index=models.Index(fields=["sv_uuid"],
name="svs_structu_sv_uuid_09c0c4_idx"),
),
migrations.AddField(
model_name="structuralvariantflags",
name="case",
field=models.ForeignKey(
help_text="Case that this SV is flagged in",
on_delete=django.db.models.deletion.CASCADE,
related_name="structural_variant_flags",
to="variants.Case",
),
),
migrations.AddField(
model_name="structuralvariantcomment",
name="case",
field=models.ForeignKey(
help_text="Case that this SV is commented on",
on_delete=django.db.models.deletion.CASCADE,
related_name="structural_variant_comments",
to="variants.Case",
),
),
migrations.AddField(
model_name="structuralvariantcomment",
name="user",
field=models.ForeignKey(
blank=True,
help_text="User who created the comment",
null=True,
on_delete=django.db.models.deletion.SET_NULL,
related_name="structural_variant_comments",
to=settings.AUTH_USER_MODEL,
),
),
migrations.AddIndex(
model_name="structuralvariant",
index=models.Index(fields=["case_id"],
name="svs_structu_case_id_988c93_idx"),
),
migrations.AddIndex(
model_name="structuralvariant",
index=models.Index(
fields=["case_id", "release", "chromosome", "bin"],
name="svs_structu_case_id_cd8553_idx",
),
),
migrations.AddIndex(
model_name="structuralvariant",
index=models.Index(
fields=[
"case_id", "release", "chromosome", "bin", "sv_type",
"sv_sub_type"
],
name="svs_structu_case_id_aa8632_idx",
),
),
migrations.AddIndex(
model_name="structuralvariantflags",
index=models.Index(fields=["case", "release", "bin"],
name="svs_structu_case_id_94fcb3_idx"),
),
migrations.AddIndex(
model_name="structuralvariantcomment",
index=models.Index(fields=["case", "release", "bin"],
name="svs_structu_case_id_7fdf69_idx"),
),
]
class Migration(migrations.Migration):
dependencies = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
('cdfapp', '0002_auto_20190306_1631'),
]
operations = [
migrations.CreateModel(
name='Age',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('name', models.CharField(max_length=100)),
('start_years', models.IntegerField()),
('end_years', models.IntegerField()),
],
),
migrations.CreateModel(
name='ClubSocial',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('href', models.CharField(max_length=100)),
('text', models.CharField(max_length=100)),
],
),
migrations.CreateModel(
name='ContactMessage',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('phone', models.CharField(max_length=20)),
('email', models.CharField(max_length=100)),
('message', models.TextField()),
('request_date', models.DateTimeField(default=django.utils.timezone.now)),
('response_date', models.DateTimeField(blank=True, null=True)),
],
),
migrations.CreateModel(
name='Cover',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('image', models.CharField(max_length=100)),
('active', models.BooleanField(default=True)),
('href', models.CharField(blank=True, max_length=100, null=True)),
],
),
migrations.CreateModel(
name='Facility',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('name', models.CharField(max_length=100)),
],
),
migrations.CreateModel(
name='Gallery',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('title', models.CharField(max_length=200)),
('date', models.DateTimeField(blank=True, null=True)),
('gallery_type', models.CharField(choices=[('PH', 'Foto'), ('VD', 'Vídeo')], default='PH', max_length=2)),
('active', models.BooleanField(default=True)),
('image', models.CharField(blank=True, max_length=100, null=True)),
('href', models.CharField(blank=True, max_length=100, null=True)),
],
),
migrations.CreateModel(
name='GalleryObject',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('title', models.CharField(blank=True, max_length=250, null=True)),
('image', models.CharField(max_length=100)),
('href', models.CharField(blank=True, max_length=100, null=True)),
],
),
migrations.CreateModel(
name='Installation',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('title', models.CharField(max_length=100)),
],
),
migrations.CreateModel(
name='InstallationImage',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('title', models.CharField(blank=True, max_length=250, null=True)),
],
),
migrations.CreateModel(
name='News',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('title', models.CharField(max_length=100)),
('summary', models.CharField(max_length=200)),
('text', models.TextField()),
('image', models.CharField(blank=True, max_length=100, null=True)),
('featured', models.BooleanField(default=False)),
('date_creation', models.DateTimeField(default=django.utils.timezone.now)),
('date_publication', models.DateTimeField(blank=True, null=True)),
],
),
migrations.CreateModel(
name='People',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('name', models.CharField(max_length=50)),
('surname', models.CharField(max_length=50)),
('birth_date', models.DateTimeField(blank=True, null=True)),
],
),
migrations.CreateModel(
name='PeoplePhoto',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
],
),
migrations.CreateModel(
name='PeopleSocial',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('href', models.CharField(max_length=100)),
],
),
migrations.CreateModel(
name='Rol',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('name', models.CharField(max_length=100)),
('rol_type', models.CharField(choices=[('ST', 'Técnico'), ('PL', 'Plantilla')], default='PL', max_length=2)),
],
),
migrations.CreateModel(
name='Season',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('name', models.CharField(max_length=100)),
('start_date', models.DateTimeField()),
('end_date', models.DateTimeField()),
],
),
migrations.CreateModel(
name='Social',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('name', models.CharField(max_length=100)),
('href', models.URLField(blank=True, null=True)),
('icon', models.CharField(max_length=100)),
],
),
migrations.CreateModel(
name='Sponsor',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('start_date', models.DateTimeField()),
('end_date', models.DateTimeField()),
('title', models.CharField(max_length=250)),
('href', models.URLField()),
('index', models.IntegerField(blank=True, null=True)),
],
),
migrations.CreateModel(
name='Team',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('name', models.CharField(max_length=100)),
('url_calendar', models.URLField(blank=True, null=True)),
('url_results', models.URLField(blank=True, null=True)),
('url_classification', models.URLField(blank=True, null=True)),
('url_crossedtable', models.URLField(blank=True, null=True)),
],
),
migrations.CreateModel(
name='TeamInstallation',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('tittle', models.CharField(max_length=100)),
],
),
migrations.CreateModel(
name='TeamMember',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('nick', models.CharField(max_length=20)),
('number', models.IntegerField(blank=True, null=True)),
],
),
migrations.RemoveField(
model_name='club',
name='facebook_href',
),
migrations.RemoveField(
model_name='club',
name='facebook_text',
),
migrations.RemoveField(
model_name='club',
name='google_href',
),
migrations.RemoveField(
model_name='club',
name='google_text',
),
migrations.RemoveField(
model_name='club',
name='image',
),
migrations.RemoveField(
model_name='club',
name='instagram_href',
),
migrations.RemoveField(
model_name='club',
name='instagram_text',
),
migrations.RemoveField(
model_name='club',
name='sendmail_href',
),
migrations.RemoveField(
model_name='club',
name='sendmail_text',
),
migrations.RemoveField(
model_name='club',
name='twitter_href',
),
migrations.RemoveField(
model_name='club',
name='twitter_text',
),
migrations.RemoveField(
model_name='club',
name='youtube_href',
),
migrations.RemoveField(
model_name='club',
name='youtube_text',
),
migrations.AddField(
model_name='club',
name='host',
field=models.CharField(blank=True, max_length=100, null=True),
),
migrations.AddIndex(
model_name='club',
index=models.Index(fields=['host'], name='cdfapp_club_host_a97658_idx'),
),
migrations.AddField(
model_name='teammember',
name='people',
field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='cdfapp.People'),
),
migrations.AddField(
model_name='teammember',
name='photo',
field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='photo', to='cdfapp.GalleryObject'),
),
migrations.AddField(
model_name='teammember',
name='photo_alt',
field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='photo_alt', to='cdfapp.GalleryObject'),
),
migrations.AddField(
model_name='teammember',
name='rol',
field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='cdfapp.Rol'),
),
migrations.AddField(
model_name='teammember',
name='team',
field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='cdfapp.Team'),
),
migrations.AddField(
model_name='teaminstallation',
name='installation',
field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='cdfapp.Installation'),
),
migrations.AddField(
model_name='teaminstallation',
name='team',
field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='cdfapp.Team'),
),
migrations.AddField(
model_name='team',
name='age',
field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='cdfapp.Age'),
),
migrations.AddField(
model_name='team',
name='club',
field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='cdfapp.Club'),
),
migrations.AddField(
model_name='team',
name='photo',
field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='cdfapp.GalleryObject'),
),
migrations.AddField(
model_name='team',
name='season',
field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='cdfapp.Season'),
),
migrations.AddField(
model_name='sponsor',
name='club',
field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='cdfapp.Club'),
),
migrations.AddField(
model_name='sponsor',
name='image',
field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='cdfapp.GalleryObject'),
),
migrations.AddField(
model_name='peoplesocial',
name='people',
field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='cdfapp.People'),
),
migrations.AddField(
model_name='peoplesocial',
name='social',
field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='cdfapp.Social'),
),
migrations.AddField(
model_name='peoplephoto',
name='people',
field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='cdfapp.People'),
),
migrations.AddField(
model_name='peoplephoto',
name='photo',
field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='cdfapp.GalleryObject'),
),
migrations.AddField(
model_name='news',
name='author',
field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to=settings.AUTH_USER_MODEL),
),
migrations.AddField(
model_name='news',
name='club',
field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='cdfapp.Club'),
),
migrations.AddField(
model_name='installationimage',
name='image',
field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='cdfapp.GalleryObject'),
),
migrations.AddField(
model_name='installationimage',
name='installation',
field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='cdfapp.Installation'),
),
migrations.AddField(
model_name='installation',
name='club',
field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='cdfapp.Club'),
),
migrations.AddField(
model_name='installation',
name='image',
field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='cdfapp.GalleryObject'),
),
migrations.AddField(
model_name='galleryobject',
name='gallery',
field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='cdfapp.Gallery'),
),
migrations.AddField(
model_name='gallery',
name='club',
field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='cdfapp.Club'),
),
migrations.AddField(
model_name='facility',
name='club',
field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='cdfapp.Club'),
),
migrations.AddField(
model_name='cover',
name='club',
field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='cdfapp.Club'),
),
migrations.AddField(
model_name='cover',
name='news',
field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.PROTECT, to='cdfapp.News'),
),
migrations.AddField(
model_name='contactmessage',
name='club',
field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='cdfapp.Club'),
),
migrations.AddField(
model_name='clubsocial',
name='club',
field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='cdfapp.Club'),
),
migrations.AddField(
model_name='clubsocial',
name='social',
field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='cdfapp.Social'),
),
migrations.AddField(
model_name='club',
name='photo',
field=models.ForeignKey(default=1, on_delete=django.db.models.deletion.PROTECT, to='cdfapp.GalleryObject'),
preserve_default=False,
),
migrations.AddIndex(
model_name='teammember',
index=models.Index(fields=['team', 'number'], name='cdfapp_team_team_id_c5f9e4_idx'),
),
migrations.AddIndex(
model_name='news',
index=models.Index(fields=['club', '-date_publication'], name='cdfapp_news_club_id_d274f4_idx'),
),
migrations.AddIndex(
model_name='gallery',
index=models.Index(fields=['club', 'gallery_type', '-date'], name='cdfapp_gall_club_id_4d6f29_idx'),
),
migrations.AddIndex(
model_name='cover',
index=models.Index(fields=['club', 'active'], name='cdfapp_cove_club_id_0e6421_idx'),
),
]
class Migration(migrations.Migration):
dependencies = [
('study', '0003_studymember_is_withdraw'),
]
operations = [
migrations.AddField(
model_name='schedule',
name='subject',
field=models.CharField(blank=True,
max_length=50,
verbose_name='주제'),
),
migrations.AlterField(
model_name='attendance',
name='vote',
field=models.CharField(blank=True,
choices=[('attend', '참석'), ('late', '지각'),
('absent', '결석')],
max_length=10,
verbose_name='사전 참석 투표'),
),
migrations.AlterField(
model_name='study',
name='author',
field=models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.CASCADE,
related_name='study_set',
to=settings.AUTH_USER_MODEL,
verbose_name='생성자'),
),
migrations.CreateModel(
name='StudyInviteLink',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('created',
django_extensions.db.fields.CreationDateTimeField(
auto_now_add=True, verbose_name='created')),
('modified',
django_extensions.db.fields.ModificationDateTimeField(
auto_now=True, verbose_name='modified')),
('code',
models.CharField(blank=True,
max_length=30,
verbose_name='초대코드')),
('duration',
models.PositiveSmallIntegerField(default=24,
verbose_name='유효시간')),
('study',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='study.Study',
verbose_name='스터디')),
],
options={
'verbose_name': '스터디 초대 링크',
'verbose_name_plural': '스터디 초대 링크 목록',
'ordering': ('-created', ),
},
),
migrations.AddIndex(
model_name='studyinvitelink',
index=models.Index(fields=['created'],
name='study_study_created_73d952_idx'),
),
migrations.AddIndex(
model_name='studyinvitelink',
index=models.Index(fields=['modified'],
name='study_study_modifie_81a258_idx'),
),
]
class Migration(migrations.Migration):
dependencies = [("reporting", "0098_auto_20200221_2034")]
operations = [
migrations.RunSQL("""
drop materialized view if exists reporting_ocpallcostlineitem_daily_summary;
drop materialized view if exists reporting_ocpallcostlineitem_project_daily_summary;
"""),
migrations.RemoveIndex(model_name="ocpawscostlineitemdailysummary",
name="cost_summary_node_idx"),
migrations.RemoveIndex(
model_name="ocpawscostlineitemprojectdailysummary",
name="cost__proj_sum_namespace_idx"),
migrations.RemoveIndex(
model_name="ocpawscostlineitemprojectdailysummary",
name="cost_proj_sum_node_idx"),
migrations.RemoveIndex(model_name="ocpazurecostlineitemdailysummary",
name="ocpazure_node_idx"),
migrations.RemoveIndex(
model_name="ocpazurecostlineitemprojectdailysummary",
name="ocpazure_proj_namespace_idx"),
migrations.RemoveIndex(
model_name="ocpazurecostlineitemprojectdailysummary",
name="ocpazure_proj_node_idx"),
migrations.RemoveIndex(model_name="ocpusagelineitemdaily",
name="namespace_idx"),
migrations.RemoveIndex(model_name="ocpusagelineitemdaily",
name="node_idx"),
migrations.RemoveIndex(model_name="ocpusagelineitemdailysummary",
name="summary_namespace_idx"),
migrations.RemoveIndex(model_name="ocpusagelineitemdailysummary",
name="summary_node_idx"),
migrations.AlterField(
model_name="ocpawscostlineitemprojectdailysummary",
name="usage_end",
field=models.DateField()),
migrations.AlterField(
model_name="ocpawscostlineitemprojectdailysummary",
name="usage_start",
field=models.DateField()),
migrations.AlterField(model_name="ocpazurecostlineitemdailysummary",
name="usage_end",
field=models.DateField()),
migrations.AlterField(model_name="ocpazurecostlineitemdailysummary",
name="usage_start",
field=models.DateField()),
migrations.AlterField(
model_name="ocpazurecostlineitemprojectdailysummary",
name="usage_end",
field=models.DateField()),
migrations.AlterField(
model_name="ocpazurecostlineitemprojectdailysummary",
name="usage_start",
field=models.DateField()),
migrations.AlterField(model_name="ocpstoragelineitemdaily",
name="usage_end",
field=models.DateField()),
migrations.AlterField(model_name="ocpstoragelineitemdaily",
name="usage_start",
field=models.DateField()),
migrations.AlterField(model_name="ocpusagelineitemdaily",
name="total_seconds",
field=models.IntegerField()),
migrations.AlterField(model_name="ocpusagelineitemdaily",
name="usage_end",
field=models.DateField()),
migrations.AlterField(model_name="ocpusagelineitemdaily",
name="usage_start",
field=models.DateField()),
migrations.AlterField(model_name="ocpusagelineitemdailysummary",
name="usage_end",
field=models.DateField()),
migrations.AlterField(model_name="ocpusagelineitemdailysummary",
name="usage_start",
field=models.DateField()),
migrations.AddIndex(
model_name="ocpawscostlineitemdailysummary",
index=models.Index(fields=["node"],
name="cost_summary_node_idx",
opclasses=["varchar_pattern_ops"]),
),
migrations.AddIndex(
model_name="ocpawscostlineitemprojectdailysummary",
index=models.Index(fields=["namespace"],
name="cost__proj_sum_namespace_idx",
opclasses=["varchar_pattern_ops"]),
),
migrations.AddIndex(
model_name="ocpawscostlineitemprojectdailysummary",
index=models.Index(fields=["node"],
name="cost_proj_sum_node_idx",
opclasses=["varchar_pattern_ops"]),
),
migrations.AddIndex(
model_name="ocpazurecostlineitemdailysummary",
index=models.Index(fields=["node"],
name="ocpazure_node_idx",
opclasses=["varchar_pattern_ops"]),
),
migrations.AddIndex(
model_name="ocpazurecostlineitemprojectdailysummary",
index=models.Index(fields=["namespace"],
name="ocpazure_proj_namespace_idx",
opclasses=["varchar_pattern_ops"]),
),
migrations.AddIndex(
model_name="ocpazurecostlineitemprojectdailysummary",
index=models.Index(fields=["node"],
name="ocpazure_proj_node_idx",
opclasses=["varchar_pattern_ops"]),
),
migrations.AddIndex(
model_name="ocpstoragelineitemdaily",
index=models.Index(fields=["namespace"],
name="ocp_storage_li_namespace_idx",
opclasses=["varchar_pattern_ops"]),
),
migrations.AddIndex(
model_name="ocpstoragelineitemdaily",
index=models.Index(fields=["node"],
name="ocp_storage_li_node_idx",
opclasses=["varchar_pattern_ops"]),
),
migrations.AddIndex(
model_name="ocpusagelineitemdaily",
index=models.Index(fields=["namespace"],
name="namespace_idx",
opclasses=["varchar_pattern_ops"]),
),
migrations.AddIndex(
model_name="ocpusagelineitemdaily",
index=models.Index(fields=["node"],
name="node_idx",
opclasses=["varchar_pattern_ops"]),
),
migrations.AddIndex(
model_name="ocpusagelineitemdailysummary",
index=models.Index(fields=["namespace"],
name="summary_namespace_idx",
opclasses=["varchar_pattern_ops"]),
),
migrations.AddIndex(
model_name="ocpusagelineitemdailysummary",
index=models.Index(fields=["node"],
name="summary_node_idx",
opclasses=["varchar_pattern_ops"]),
),
migrations.AlterField(model_name="costsummary",
name="usage_end",
field=models.DateField()),
migrations.AlterField(model_name="costsummary",
name="usage_start",
field=models.DateField()),
migrations.AddIndex(model_name="costsummary",
index=models.Index(
fields=["usage_start"],
name="ocpcostsum_usage_start_idx")),
migrations.AddIndex(
model_name="costsummary",
index=models.Index(fields=["namespace"],
name="ocpcostsum_namespace_idx",
opclasses=["varchar_pattern_ops"]),
),
migrations.AddIndex(
model_name="costsummary",
index=models.Index(fields=["node"],
name="ocpcostsum_node_idx",
opclasses=["varchar_pattern_ops"]),
),
migrations.AddIndex(
model_name="costsummary",
index=django.contrib.postgres.indexes.GinIndex(
fields=["pod_labels"], name="ocpcostsum_pod_labels_idx"),
),
# This extension will help specifically with "col LIKE %val%"
# operations. (As long as val is at least 3 characters)
migrations.RunSQL("""
create extension if not exists pg_trgm schema public;
"""),
# Create indexes to aid with text searching.
# These cases will specifically help with case-insensitive
# and contains (vs startswith) searches
# ocp usage line item daily
migrations.RunSQL("""
/* add namespace index for like trigram ops */
create index if not exists ocp_namespace_idx
on reporting_ocpusagelineitem_daily using gin (UPPER(namespace) gin_trgm_ops);
/* add node index for like trigram ops */
create index if not exists ocp_node_idx
on reporting_ocpusagelineitem_daily using gin (UPPER(node) gin_trgm_ops);
"""),
# ocp usage line item daily summary
migrations.RunSQL("""
/* add namespace index for like trigram ops */
create index if not exists ocp_summary_namespace_like_idx
on reporting_ocpusagelineitem_daily_summary using gin (UPPER(namespace) gin_trgm_ops);
/* add node index for like trigram ops */
create index if not exists ocp_summary_node_like_idx
on reporting_ocpusagelineitem_daily_summary using gin (UPPER(node) gin_trgm_ops);
"""),
# reporting_ocpstoragelineitem_daily
migrations.RunSQL("""
/* add namespace index for like trigram ops */
create index if not exists ocp_storage_li_namespace_like_idx
on reporting_ocpstoragelineitem_daily using gin (UPPER(namespace) gin_trgm_ops);
/* add node index for like trigram ops */
create index if not exists ocp_storage_li_node_like_idx
on reporting_ocpstoragelineitem_daily using gin (UPPER(node) gin_trgm_ops);
"""),
# ocp azure cost
migrations.RunSQL("""
/* add node index for like trigram ops */
create index if not exists ocpazure_node_like_idx
on reporting_ocpazurecostlineitem_daily_summary using gin (UPPER(node) gin_trgm_ops);
"""),
# ocp azure project cost
migrations.RunSQL("""
/* add namespace index for like trigram ops */
create index if not exists ocpazure_proj_namespace_like_idx
on reporting_ocpazurecostlineitem_project_daily_summary using gin (UPPER(namespace) gin_trgm_ops);
/* add node index for like trigram ops */
create index if not exists ocpazure_proj_node_like_idx
on reporting_ocpazurecostlineitem_project_daily_summary using gin (UPPER(node) gin_trgm_ops);
"""),
# reporting_ocpawscostlineitem_daily_summary
migrations.RunSQL("""
/* add node index for like trigram ops */
create index if not exists cost_summary_node_like_idx
on reporting_ocpawscostlineitem_daily_summary using gin (UPPER(node) gin_trgm_ops);
"""),
# reporting_ocpawscostlineitem_project_daily_summary
migrations.RunSQL("""
/* add namespace index for like trigram ops */
create index if not exists cost__proj_sum_namespace_like_idx
on reporting_ocpawscostlineitem_project_daily_summary using gin (UPPER(namespace) gin_trgm_ops);
/* add node index for like trigram ops */
create index if not exists cost__proj_sum_node_like_idx
on reporting_ocpawscostlineitem_project_daily_summary using gin (UPPER(node) gin_trgm_ops);
"""),
# reporting_ocpcosts_summary
migrations.RunSQL("""
/* add namespace index for like trigram ops */
create index if not exists ocpcostsum_namespace_like_idx
on reporting_ocpcosts_summary using gin (UPPER(namespace) gin_trgm_ops);
/* add node index for like trigram ops */
create index if not exists ocpcostsum_node_like_idx
on reporting_ocpcosts_summary using gin (UPPER(node) gin_trgm_ops);
"""),
migrations.RunSQL("""
drop materialized view if exists reporting_ocpallcostlineitem_daily_summary;
create materialized view if not exists reporting_ocpallcostlineitem_daily_summary as
SELECT row_number() OVER () AS id,
lids.source_type,
lids.cluster_id,
lids.cluster_alias,
lids.namespace,
lids.node,
lids.resource_id,
lids.usage_start,
lids.usage_end,
lids.usage_account_id,
lids.account_alias_id,
lids.product_code,
lids.product_family,
lids.instance_type,
lids.region,
lids.availability_zone,
lids.tags,
lids.usage_amount,
lids.unit,
lids.unblended_cost,
lids.markup_cost,
lids.currency_code,
lids.shared_projects,
lids.project_costs
FROM ( SELECT 'AWS'::text AS source_type,
reporting_ocpawscostlineitem_daily_summary.cluster_id,
reporting_ocpawscostlineitem_daily_summary.cluster_alias,
reporting_ocpawscostlineitem_daily_summary.namespace,
reporting_ocpawscostlineitem_daily_summary.node,
reporting_ocpawscostlineitem_daily_summary.resource_id,
reporting_ocpawscostlineitem_daily_summary.usage_start::date,
reporting_ocpawscostlineitem_daily_summary.usage_end::date,
reporting_ocpawscostlineitem_daily_summary.usage_account_id,
reporting_ocpawscostlineitem_daily_summary.account_alias_id,
reporting_ocpawscostlineitem_daily_summary.product_code,
reporting_ocpawscostlineitem_daily_summary.product_family,
reporting_ocpawscostlineitem_daily_summary.instance_type,
reporting_ocpawscostlineitem_daily_summary.region,
reporting_ocpawscostlineitem_daily_summary.availability_zone,
reporting_ocpawscostlineitem_daily_summary.tags,
reporting_ocpawscostlineitem_daily_summary.usage_amount,
reporting_ocpawscostlineitem_daily_summary.unit,
reporting_ocpawscostlineitem_daily_summary.unblended_cost,
reporting_ocpawscostlineitem_daily_summary.markup_cost,
reporting_ocpawscostlineitem_daily_summary.currency_code,
reporting_ocpawscostlineitem_daily_summary.shared_projects,
reporting_ocpawscostlineitem_daily_summary.project_costs
FROM reporting_ocpawscostlineitem_daily_summary
WHERE reporting_ocpawscostlineitem_daily_summary.usage_start >= date_trunc('month'::text, date_trunc('month'::text, now()) - '1 day'::interval day)
UNION
SELECT 'Azure'::text AS source_type,
reporting_ocpazurecostlineitem_daily_summary.cluster_id,
reporting_ocpazurecostlineitem_daily_summary.cluster_alias,
reporting_ocpazurecostlineitem_daily_summary.namespace,
reporting_ocpazurecostlineitem_daily_summary.node,
reporting_ocpazurecostlineitem_daily_summary.resource_id,
reporting_ocpazurecostlineitem_daily_summary.usage_start::date,
reporting_ocpazurecostlineitem_daily_summary.usage_end::date,
reporting_ocpazurecostlineitem_daily_summary.subscription_guid AS usage_account_id,
NULL::integer AS account_alias_id,
reporting_ocpazurecostlineitem_daily_summary.service_name AS product_code,
NULL::character varying AS product_family,
reporting_ocpazurecostlineitem_daily_summary.instance_type,
reporting_ocpazurecostlineitem_daily_summary.resource_location AS region,
NULL::character varying AS availability_zone,
reporting_ocpazurecostlineitem_daily_summary.tags,
reporting_ocpazurecostlineitem_daily_summary.usage_quantity AS usage_amount,
reporting_ocpazurecostlineitem_daily_summary.unit_of_measure AS unit,
reporting_ocpazurecostlineitem_daily_summary.pretax_cost AS unblended_cost,
reporting_ocpazurecostlineitem_daily_summary.markup_cost,
reporting_ocpazurecostlineitem_daily_summary.currency AS currency_code,
reporting_ocpazurecostlineitem_daily_summary.shared_projects,
reporting_ocpazurecostlineitem_daily_summary.project_costs
FROM reporting_ocpazurecostlineitem_daily_summary
WHERE reporting_ocpazurecostlineitem_daily_summary.usage_start >= date_trunc('month'::text, date_trunc('month'::text, now()) - '1 day'::interval day)) lids
with no data;
create index mv_reporting_ocpallcostlineitem_daily_summary_namespace_ix
on reporting_ocpallcostlineitem_daily_summary using gin (namespace);
create index mv_reporting_ocpallcostlineitem_daily_summary_node_ix
on reporting_ocpallcostlineitem_daily_summary (node varchar_pattern_ops);
create index mv_reporting_ocpallcostlineitem_daily_summary_usage_ix
on reporting_ocpallcostlineitem_daily_summary (usage_start);
drop materialized view if exists reporting_ocpallcostlineitem_project_daily_summary;
create materialized view if not exists reporting_ocpallcostlineitem_project_daily_summary as
SELECT row_number() OVER () AS id,
lids.source_type,
lids.cluster_id,
lids.cluster_alias,
lids.data_source,
lids.namespace,
lids.node,
lids.pod_labels,
lids.resource_id,
lids.usage_start,
lids.usage_end,
lids.usage_account_id,
lids.account_alias_id,
lids.product_code,
lids.product_family,
lids.instance_type,
lids.region,
lids.availability_zone,
lids.usage_amount,
lids.unit,
lids.unblended_cost,
lids.project_markup_cost,
lids.pod_cost,
lids.currency_code
FROM ( SELECT 'AWS'::text AS source_type,
reporting_ocpawscostlineitem_project_daily_summary.cluster_id,
reporting_ocpawscostlineitem_project_daily_summary.cluster_alias,
reporting_ocpawscostlineitem_project_daily_summary.data_source,
reporting_ocpawscostlineitem_project_daily_summary.namespace,
reporting_ocpawscostlineitem_project_daily_summary.node,
reporting_ocpawscostlineitem_project_daily_summary.pod_labels,
reporting_ocpawscostlineitem_project_daily_summary.resource_id,
reporting_ocpawscostlineitem_project_daily_summary.usage_start::date,
reporting_ocpawscostlineitem_project_daily_summary.usage_end::date,
reporting_ocpawscostlineitem_project_daily_summary.usage_account_id,
reporting_ocpawscostlineitem_project_daily_summary.account_alias_id,
reporting_ocpawscostlineitem_project_daily_summary.product_code,
reporting_ocpawscostlineitem_project_daily_summary.product_family,
reporting_ocpawscostlineitem_project_daily_summary.instance_type,
reporting_ocpawscostlineitem_project_daily_summary.region,
reporting_ocpawscostlineitem_project_daily_summary.availability_zone,
reporting_ocpawscostlineitem_project_daily_summary.usage_amount,
reporting_ocpawscostlineitem_project_daily_summary.unit,
reporting_ocpawscostlineitem_project_daily_summary.unblended_cost,
reporting_ocpawscostlineitem_project_daily_summary.project_markup_cost,
reporting_ocpawscostlineitem_project_daily_summary.pod_cost,
reporting_ocpawscostlineitem_project_daily_summary.currency_code
FROM reporting_ocpawscostlineitem_project_daily_summary
WHERE reporting_ocpawscostlineitem_project_daily_summary.usage_start >= date_trunc('month'::text, date_trunc('month'::text, now()) - '1 day'::interval day)
UNION
SELECT 'Azure'::text AS source_type,
reporting_ocpazurecostlineitem_project_daily_summary.cluster_id,
reporting_ocpazurecostlineitem_project_daily_summary.cluster_alias,
reporting_ocpazurecostlineitem_project_daily_summary.data_source,
reporting_ocpazurecostlineitem_project_daily_summary.namespace,
reporting_ocpazurecostlineitem_project_daily_summary.node,
reporting_ocpazurecostlineitem_project_daily_summary.pod_labels,
reporting_ocpazurecostlineitem_project_daily_summary.resource_id,
reporting_ocpazurecostlineitem_project_daily_summary.usage_start::date,
reporting_ocpazurecostlineitem_project_daily_summary.usage_end::date,
reporting_ocpazurecostlineitem_project_daily_summary.subscription_guid AS usage_account_id,
NULL::integer AS account_alias_id,
reporting_ocpazurecostlineitem_project_daily_summary.service_name AS product_code,
NULL::character varying AS product_family,
reporting_ocpazurecostlineitem_project_daily_summary.instance_type,
reporting_ocpazurecostlineitem_project_daily_summary.resource_location AS region,
NULL::character varying AS availability_zone,
reporting_ocpazurecostlineitem_project_daily_summary.usage_quantity AS usage_amount,
reporting_ocpazurecostlineitem_project_daily_summary.unit_of_measure AS unit,
reporting_ocpazurecostlineitem_project_daily_summary.pretax_cost AS unblended_cost,
reporting_ocpazurecostlineitem_project_daily_summary.project_markup_cost,
reporting_ocpazurecostlineitem_project_daily_summary.pod_cost,
reporting_ocpazurecostlineitem_project_daily_summary.currency AS currency_code
FROM reporting_ocpazurecostlineitem_project_daily_summary
WHERE reporting_ocpazurecostlineitem_project_daily_summary.usage_start >= date_trunc('month'::text, date_trunc('month'::text, now()) - '1 day'::interval day)) lids
with no data;
create index mv_reporting_ocpallcostlineitem_prj_daily_summary_namespace_ix
on reporting_ocpallcostlineitem_project_daily_summary (namespace varchar_pattern_ops);
create index mv_reporting_ocpallcostlineitem_prj_daily_summary_node_ix
on reporting_ocpallcostlineitem_project_daily_summary (node varchar_pattern_ops);
create index mv_reporting_ocpallcostlineitem_prj_daily_summary_namespace_like_ix
on reporting_ocpallcostlineitem_project_daily_summary using gin (namespace gin_trgm_ops);
create index mv_reporting_ocpallcostlineitem_prj_daily_summary_node_like_ix
on reporting_ocpallcostlineitem_project_daily_summary using gin (node gin_trgm_ops);
create index mv_reporting_ocpallcostlineitem_prj_daily_summary_usage_ix
on reporting_ocpallcostlineitem_project_daily_summary (usage_start);
"""),
migrations.RunSQL("""
refresh materialized view reporting_ocpallcostlineitem_daily_summary;
refresh materialized view reporting_ocpallcostlineitem_project_daily_summary;
"""),
]
class Migration(migrations.Migration):
initial = True
dependencies = []
operations = [
migrations.CreateModel(
name='GitHubUser',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('uuid', models.UUIDField(default=uuid.uuid4, unique=True)),
('is_del',
models.BooleanField(default=False, verbose_name='是否删除')),
('is_active',
models.BooleanField(default=True, verbose_name='是否可用')),
('created',
models.DateTimeField(auto_now_add=True,
null=True,
verbose_name='创建时间')),
('updated',
models.DateTimeField(auto_now=True,
null=True,
verbose_name='更新时间')),
('github_user_id',
models.CharField(blank=True,
max_length=255,
verbose_name='Github ID')),
],
options={
'abstract': False,
},
),
migrations.CreateModel(
name='Group',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('uuid', models.UUIDField(default=uuid.uuid4, unique=True)),
('is_del',
models.BooleanField(default=False, verbose_name='是否删除')),
('is_active',
models.BooleanField(default=True, verbose_name='是否可用')),
('created',
models.DateTimeField(auto_now_add=True,
null=True,
verbose_name='创建时间')),
('updated',
models.DateTimeField(auto_now=True,
null=True,
verbose_name='更新时间')),
('name', models.CharField(max_length=255,
verbose_name='用户组名')),
],
options={
'abstract': False,
},
),
migrations.CreateModel(
name='User',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('uuid', models.UUIDField(default=uuid.uuid4, unique=True)),
('is_del',
models.BooleanField(default=False, verbose_name='是否删除')),
('is_active',
models.BooleanField(default=True, verbose_name='是否可用')),
('created',
models.DateTimeField(auto_now_add=True,
null=True,
verbose_name='创建时间')),
('updated',
models.DateTimeField(auto_now=True,
null=True,
verbose_name='更新时间')),
('username',
models.CharField(max_length=255, verbose_name='用户名')),
('password',
models.CharField(max_length=1024, verbose_name='账号密码')),
('nickname',
models.CharField(blank=True,
default='',
max_length=255,
verbose_name='昵称')),
('gender',
models.IntegerField(choices=[(0, '未知'), (1, '男'), (2, '女')],
default=0,
verbose_name='性别')),
('email',
models.CharField(blank=True,
default='',
max_length=255,
verbose_name='电子邮箱')),
('mobile',
models.CharField(blank=True,
default='',
max_length=64,
verbose_name='手机号')),
('origin',
models.IntegerField(choices=[(0, '脚本添加'), (1, '管理员添加'),
(2, '用户名+密码注册'), (3, '手机号注册'),
(4, '电子邮箱注册')],
default=0,
verbose_name='账号来源')),
('remark',
models.CharField(blank=True,
default='',
max_length=512,
verbose_name='账号备注')),
('last_active_time',
models.DateTimeField(null=True, verbose_name='最近活跃时间')),
],
),
migrations.CreateModel(
name='WechatUser',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('uuid', models.UUIDField(default=uuid.uuid4, unique=True)),
('is_del',
models.BooleanField(default=False, verbose_name='是否删除')),
('is_active',
models.BooleanField(default=True, verbose_name='是否可用')),
('created',
models.DateTimeField(auto_now_add=True,
null=True,
verbose_name='创建时间')),
('updated',
models.DateTimeField(auto_now=True,
null=True,
verbose_name='更新时间')),
('wechat_user_id',
models.CharField(blank=True,
max_length=255,
verbose_name='Github ID')),
('github_user',
models.OneToOneField(
on_delete=django.db.models.deletion.PROTECT,
related_name='github_user',
to='account.githubuser',
verbose_name='github用户')),
],
options={
'abstract': False,
},
),
migrations.AddIndex(
model_name='user',
index=models.Index(fields=['username'], name='username_index'),
),
migrations.AddField(
model_name='githubuser',
name='user',
field=models.OneToOneField(
on_delete=django.db.models.deletion.PROTECT,
related_name='github_user',
to='account.user',
verbose_name='用户'),
),
]
class Migration(migrations.Migration):
dependencies = [
('msgs', '0004_auto_20171211_0647'),
]
operations = [
migrations.CreateModel(
name='备份主机',
fields=[
('主机ID', models.AutoField(primary_key=True, serialize=False)),
('主机IP', models.CharField(max_length=20, verbose_name='IP地址')),
('备份日期', models.DateField(verbose_name='日期')),
('备份等级', models.IntegerField(verbose_name='数字等级')),
],
options={
'db_table': '备份主机2',
'get_latest_by': '备份日期',
},
),
migrations.CreateModel(
name='学生',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('姓名', models.CharField(max_length=100)),
],
),
migrations.CreateModel(
name='成绩',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('成绩', models.IntegerField(verbose_name='成绩')),
],
),
migrations.CreateModel(
name='课程',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('科目', models.CharField(max_length=100)),
],
),
migrations.AlterModelOptions(
name='消息',
options={'ordering': ['-时间', '状态']},
),
migrations.AlterField(
model_name='消息',
name='时间',
field=models.CharField(blank=True,
max_length=50,
verbose_name='备注： 消息时间'),
),
migrations.AddIndex(
model_name='消息',
index=models.Index(fields=['时间', '来源'],
name='msgs_消息_时间_9f6243_idx'),
),
migrations.AddIndex(
model_name='消息',
index=models.Index(fields=['状态'], name='状态_idx'),
),
migrations.AddField(
model_name='成绩',
name='姓名',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE, to='msgs.学生'),
),
migrations.AddField(
model_name='成绩',
name='科目',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE, to='msgs.课程'),
),
]
class Migration(migrations.Migration):
dependencies = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
swapper.dependency('openwisp_users', 'Organization'),
('openwisp_notifications', '0003_notification_notification_type'),
]
operations = [
migrations.CreateModel(
name='NotificationSetting',
fields=[
(
'id',
models.UUIDField(
default=uuid.uuid4,
editable=False,
primary_key=True,
serialize=False,
),
),
(
'type',
models.CharField(
choices=NOTIFICATION_CHOICES,
max_length=30,
null=True,
verbose_name='Notification Type',
),
),
(
'web',
models.BooleanField(
null=True,
blank=True,
help_text=
('Note: Non-superadmin users receive notifications only '
'for organizations of which they are member of.'),
verbose_name='web notifications',
),
),
(
'email',
models.BooleanField(
null=True,
blank=True,
help_text=
('Note: Non-superadmin users receive notifications only '
'for organizations of which they are member of.'),
verbose_name='email notifications',
),
),
(
'organization',
models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to=swapper.get_model_name('openwisp_users',
'Organization'),
),
),
(
'user',
models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL,
),
),
],
options={
'verbose_name': 'user notification settings',
'verbose_name_plural': 'user notification settings',
'ordering': ['organization', 'type'],
'abstract': False,
'swappable':
'OPENWISP_NOTIFICATIONS_NOTIFICATIONSETTING_MODEL',
},
),
migrations.AddConstraint(
model_name='notificationsetting',
constraint=models.UniqueConstraint(
fields=('organization', 'type', 'user'),
name='unique_notification_setting',
),
),
migrations.AddIndex(
model_name='notificationsetting',
index=models.Index(fields=['type', 'organization'],
name='openwisp_no_type_5a6a77_idx'),
),
migrations.RunPython(
create_notification_setting_groups_permissions,
reverse_code=reverse_notification_setting_groups_permissions,
),
]
class Migration(migrations.Migration):
initial = True
dependencies = []
operations = [
migrations.CreateModel(
name="Job",
fields=[
("id",
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name="ID")),
("title", models.CharField(max_length=50)),
("created_date",
models.DateTimeField(default=django.utils.timezone.now)),
],
options={
"ordering": ["title"],
},
),
migrations.CreateModel(
name="Search",
fields=[
("id",
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name="ID")),
("query", models.CharField(max_length=200)),
("created_date",
models.DateTimeField(default=django.utils.timezone.now)),
],
options={
"verbose_name_plural": "Searches",
},
),
migrations.CreateModel(
name="Skill",
fields=[
("id",
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name="ID")),
("clean_name", models.CharField(max_length=50)),
("unclean_names", models.TextField()),
("created_date",
models.DateTimeField(default=django.utils.timezone.now)),
],
options={
"ordering": ["clean_name"],
},
),
migrations.CreateModel(
name="Vacancy",
fields=[
("id",
models.UUIDField(default=uuid.uuid4,
editable=False,
primary_key=True,
serialize=False)),
("url", models.URLField(unique=True)),
("title", models.CharField(max_length=200)),
("content", models.TextField()),
("rated_skills", models.TextField()),
("created_date",
models.DateTimeField(default=django.utils.timezone.now)),
("search_vector",
django.contrib.postgres.search.SearchVectorField(null=True)),
],
options={
"verbose_name_plural": "Vacancies",
},
),
migrations.AddIndex(
model_name="vacancy",
index=django.contrib.postgres.indexes.GinIndex(
fields=["search_vector"], name="search_vector_idx"),
),
migrations.RunSQL(
sql="""CREATE TRIGGER search_vector_update BEFORE INSERT OR UPDATE
ON scrapers_vacancy FOR EACH ROW EXECUTE PROCEDURE
tsvector_update_trigger(search_vector, 'pg_catalog.english', title, content);""",
),
migrations.AlterModelOptions(
name="search",
options={
"ordering": ["-created_date"],
"verbose_name_plural": "Searches"
},
),
migrations.RemoveIndex(
model_name="vacancy",
name="search_vector_idx",
),
migrations.RemoveField(
model_name="vacancy",
name="search_vector",
),
migrations.AddField(
model_name="vacancy",
name="search_vector",
field=django.contrib.postgres.search.SearchVectorField(null=True),
),
migrations.AddIndex(
model_name="vacancy",
index=django.contrib.postgres.indexes.GinIndex(
fields=["search_vector"], name="search_vector_idx"),
),
migrations.AlterModelOptions(
name="search",
options={"verbose_name_plural": "Searches"},
),
migrations.RemoveIndex(
model_name="vacancy",
name="search_vector_idx",
),
migrations.RemoveField(
model_name="vacancy",
name="search_vector",
),
migrations.RunSQL(
sql="DROP TRIGGER search_vector_update ON scrapers_vacancy;", ),
migrations.AddField(
model_name="vacancy",
name="search_vector",
field=django.contrib.postgres.search.SearchVectorField(null=True),
),
migrations.AddIndex(
model_name="vacancy",
index=django.contrib.postgres.indexes.GinIndex(
fields=["search_vector"], name="search_vector_idx"),
),
migrations.RunSQL(
sql="""CREATE TRIGGER search_vector_update BEFORE INSERT OR UPDATE
ON scrapers_vacancy FOR EACH ROW EXECUTE PROCEDURE
tsvector_update_trigger(search_vector, 'pg_catalog.english', title);""",
),
migrations.AlterField(
model_name="vacancy",
name="created_date",
field=models.DateTimeField(default=datetime.datetime(
2020, 6, 19, 15, 7, 55, 76814, tzinfo=utc)),
),
migrations.AlterField(
model_name="vacancy",
name="created_date",
field=models.DateTimeField(default=django.utils.timezone.now),
),
migrations.AlterField(
model_name="search",
name="query",
field=models.CharField(max_length=255),
),
migrations.AddField(
model_name="search",
name="user_agent",
field=models.CharField(blank=True, max_length=255),
),
migrations.AlterField(
model_name="vacancy",
name="title",
field=models.CharField(max_length=255),
),
migrations.AlterField(
model_name="vacancy",
name="url",
field=models.URLField(max_length=255, unique=True),
),
migrations.AddField(
model_name="search",
name="ip_address",
field=models.GenericIPAddressField(default="1.1.1.1"),
),
migrations.AlterField(
model_name="job",
name="id",
field=models.BigAutoField(primary_key=True, serialize=False),
),
migrations.AlterField(
model_name="search",
name="id",
field=models.BigAutoField(primary_key=True, serialize=False),
),
migrations.AlterField(
model_name="skill",
name="id",
field=models.BigAutoField(primary_key=True, serialize=False),
),
migrations.AlterModelOptions(
name="search",
options={
"ordering": ["-created_date"],
"verbose_name_plural": "Searches"
},
),
migrations.AlterField(
model_name="job",
name="title",
field=models.CharField(max_length=50, unique=True),
),
migrations.AlterField(
model_name="skill",
name="clean_name",
field=models.CharField(max_length=50, unique=True),
),
]
class Migration(migrations.Migration):
dependencies = [
("sites", "0002_alter_domain_unique"),
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
("meta_subject", "0011_auto_20200118_1854"),
]
operations = [
migrations.CreateModel(
name="HistoricalMalariaTest",
fields=[
(
"revision",
django_revision.revision_field.RevisionField(
blank=True,
editable=False,
help_text=
"System field. Git repository tag:branch:commit.",
max_length=75,
null=True,
verbose_name="Revision",
),
),
(
"created",
models.DateTimeField(
blank=True,
default=django_audit_fields.models.audit_model_mixin.
utcnow,
),
),
(
"modified",
models.DateTimeField(
blank=True,
default=django_audit_fields.models.audit_model_mixin.
utcnow,
),
),
(
"user_created",
django_audit_fields.fields.userfield.UserField(
blank=True,
help_text="Updated by admin.save_model",
max_length=50,
verbose_name="user created",
),
),
(
"user_modified",
django_audit_fields.fields.userfield.UserField(
blank=True,
help_text="Updated by admin.save_model",
max_length=50,
verbose_name="user modified",
),
),
(
"hostname_created",
models.CharField(
blank=True,
default=_socket.gethostname,
help_text="System field. (modified on create only)",
max_length=60,
),
),
(
"hostname_modified",
django_audit_fields.fields.hostname_modification_field.
HostnameModificationField(
blank=True,
help_text="System field. (modified on every save)",
max_length=50,
),
),
("device_created", models.CharField(blank=True,
max_length=10)),
("device_modified", models.CharField(blank=True,
max_length=10)),
(
"id",
django_audit_fields.fields.uuid_auto_field.UUIDAutoField(
blank=True,
db_index=True,
editable=False,
help_text="System auto field. UUID primary key.",
),
),
(
"consent_model",
models.CharField(editable=False, max_length=50, null=True),
),
(
"consent_version",
models.CharField(editable=False, max_length=10, null=True),
),
(
"report_datetime",
models.DateTimeField(
default=edc_utils.date.get_utcnow,
help_text=
"If reporting today, use today's date/time, otherwise use the date/time this information was reported.",
validators=[
edc_protocol.validators.
datetime_not_before_study_start,
edc_model.validators.date.datetime_not_future,
],
verbose_name="Report Date",
),
),
(
"history_id",
models.UUIDField(
default=uuid.uuid4,
editable=False,
primary_key=True,
serialize=False,
),
),
(
"performed",
models.CharField(
choices=[("Yes", "Yes"), ("No", "No")],
max_length=15,
verbose_name="Was the malaria rapid test performed?",
),
),
(
"not_performed_reason",
models.CharField(
blank=True,
max_length=150,
null=True,
verbose_name="If NO, provide reason",
),
),
(
"diagnostic_type",
models.CharField(
choices=[
("rapid_test", "Rapid test"),
("microscopy", "Microscopy"),
],
max_length=15,
verbose_name="Diagnostic performed by ...",
),
),
(
"result",
models.CharField(
choices=[
("present", "Present"),
("absent", "Absent"),
("N/A", "Not Applicable"),
],
default="N/A",
max_length=25,
verbose_name="Result",
),
),
("history_date", models.DateTimeField()),
("history_change_reason",
models.CharField(max_length=100, null=True)),
(
"history_type",
models.CharField(
choices=[("+", "Created"), ("~", "Changed"),
("-", "Deleted")],
max_length=1,
),
),
(
"history_user",
models.ForeignKey(
null=True,
on_delete=django.db.models.deletion.SET_NULL,
related_name="+",
to=settings.AUTH_USER_MODEL,
),
),
(
"site",
models.ForeignKey(
blank=True,
db_constraint=False,
editable=False,
null=True,
on_delete=django.db.models.deletion.DO_NOTHING,
related_name="+",
to="sites.Site",
),
),
(
"subject_visit",
models.ForeignKey(
blank=True,
db_constraint=False,
null=True,
on_delete=django.db.models.deletion.DO_NOTHING,
related_name="+",
to="meta_subject.SubjectVisit",
),
),
],
options={
"verbose_name": "historical Malaria Test",
"ordering": ("-history_date", "-history_id"),
"get_latest_by": "history_date",
},
bases=(simple_history.models.HistoricalChanges, models.Model),
),
migrations.CreateModel(
name="MalariaTest",
fields=[
(
"revision",
django_revision.revision_field.RevisionField(
blank=True,
editable=False,
help_text=
"System field. Git repository tag:branch:commit.",
max_length=75,
null=True,
verbose_name="Revision",
),
),
(
"created",
models.DateTimeField(
blank=True,
default=django_audit_fields.models.audit_model_mixin.
utcnow,
),
),
(
"modified",
models.DateTimeField(
blank=True,
default=django_audit_fields.models.audit_model_mixin.
utcnow,
),
),
(
"user_created",
django_audit_fields.fields.userfield.UserField(
blank=True,
help_text="Updated by admin.save_model",
max_length=50,
verbose_name="user created",
),
),
(
"user_modified",
django_audit_fields.fields.userfield.UserField(
blank=True,
help_text="Updated by admin.save_model",
max_length=50,
verbose_name="user modified",
),
),
(
"hostname_created",
models.CharField(
blank=True,
default=_socket.gethostname,
help_text="System field. (modified on create only)",
max_length=60,
),
),
(
"hostname_modified",
django_audit_fields.fields.hostname_modification_field.
HostnameModificationField(
blank=True,
help_text="System field. (modified on every save)",
max_length=50,
),
),
("device_created", models.CharField(blank=True,
max_length=10)),
("device_modified", models.CharField(blank=True,
max_length=10)),
(
"id",
django_audit_fields.fields.uuid_auto_field.UUIDAutoField(
blank=True,
editable=False,
help_text="System auto field. UUID primary key.",
primary_key=True,
serialize=False,
),
),
(
"consent_model",
models.CharField(editable=False, max_length=50, null=True),
),
(
"consent_version",
models.CharField(editable=False, max_length=10, null=True),
),
(
"report_datetime",
models.DateTimeField(
default=edc_utils.date.get_utcnow,
help_text=
"If reporting today, use today's date/time, otherwise use the date/time this information was reported.",
validators=[
edc_protocol.validators.
datetime_not_before_study_start,
edc_model.validators.date.datetime_not_future,
],
verbose_name="Report Date",
),
),
(
"performed",
models.CharField(
choices=[("Yes", "Yes"), ("No", "No")],
max_length=15,
verbose_name="Was the malaria rapid test performed?",
),
),
(
"not_performed_reason",
models.CharField(
blank=True,
max_length=150,
null=True,
verbose_name="If NO, provide reason",
),
),
(
"diagnostic_type",
models.CharField(
choices=[
("rapid_test", "Rapid test"),
("microscopy", "Microscopy"),
],
max_length=15,
verbose_name="Diagnostic performed by ...",
),
),
(
"result",
models.CharField(
choices=[
("present", "Present"),
("absent", "Absent"),
("N/A", "Not Applicable"),
],
default="N/A",
max_length=25,
verbose_name="Result",
),
),
(
"site",
models.ForeignKey(
editable=False,
null=True,
on_delete=django.db.models.deletion.PROTECT,
related_name="+",
to="sites.Site",
),
),
(
"subject_visit",
models.OneToOneField(
on_delete=django.db.models.deletion.PROTECT,
to="meta_subject.SubjectVisit",
),
),
],
options={
"verbose_name": "Malaria Test",
"abstract": False,
},
managers=[
("on_site",
django.contrib.sites.managers.CurrentSiteManager()),
("objects", edc_visit_tracking.managers.CrfModelManager()),
],
),
migrations.RemoveField(
model_name="malariarapidtest",
name="site",
),
migrations.RemoveField(
model_name="malariarapidtest",
name="subject_visit",
),
migrations.DeleteModel(name="HistoricalMalariaRapidTest", ),
migrations.DeleteModel(name="MalariaRapidTest", ),
migrations.AddIndex(
model_name="malariatest",
index=models.Index(
fields=["subject_visit", "site", "id"],
name="meta_subjec_subject_038dbe_idx",
),
),
]
class Migration(migrations.Migration):
dependencies = [
('mocca_lists', '0002_delete_healthservices'),
]
operations = [
migrations.CreateModel(
name='CholTreatments',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name',
models.CharField(
db_index=True,
help_text='This is the stored value, required',
max_length=250,
unique=True,
verbose_name='Stored value')),
('display_name',
models.CharField(db_index=True,
help_text='(suggest 40 characters max.)',
max_length=250,
unique=True,
verbose_name='Name')),
('display_index',
models.IntegerField(
db_index=True,
default=0,
help_text=
'Index to control display order if not alphabetical, not required',
verbose_name='display index')),
('field_name',
models.CharField(blank=True,
editable=False,
help_text='Not required',
max_length=25,
null=True)),
('version',
models.CharField(default='1.0', editable=False,
max_length=35)),
],
options={
'verbose_name':
'Cholesterol Treatments',
'verbose_name_plural':
'Cholesterol Treatments',
'ordering': ['display_index', 'display_name'],
'abstract':
False,
'default_permissions':
('add', 'change', 'delete', 'view', 'export', 'import'),
},
),
migrations.AddIndex(
model_name='choltreatments',
index=models.Index(fields=['id', 'display_name', 'display_index'],
name='mocca_lists_id_832fa9_idx'),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
('translations', '__first__'),
('addons', '0001_initial'),
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
]
operations = [
migrations.CreateModel(
name='Collection',
fields=[
('created',
models.DateTimeField(blank=True,
default=django.utils.timezone.now,
editable=False)),
('modified', models.DateTimeField(auto_now=True)),
('id',
olympia.amo.fields.PositiveAutoField(primary_key=True,
serialize=False)),
('uuid', models.UUIDField(blank=True, null=True, unique=True)),
('nickname',
models.CharField(blank=True,
max_length=30,
null=True,
unique=True)),
('slug', models.CharField(blank=True, max_length=30,
null=True)),
('default_locale',
models.CharField(db_column='defaultlocale',
default='en-US',
max_length=10)),
('type',
models.PositiveIntegerField(choices=[
(0, 'Normal'), (1, 'Synchronized'), (2, 'Featured'),
(3, 'Generated Recommendations'), (4, 'Favorites'),
(5, 'Mobile'), (6, 'Anonymous')
],
db_column='collection_type',
default=0)),
('listed',
models.BooleanField(
default=True,
help_text='Collections are either listed or private.')),
('application',
models.PositiveIntegerField(blank=True,
choices=[(1, 'Firefox'),
(61,
'Firefox for Android')],
db_column='application_id',
null=True)),
('addon_count',
models.PositiveIntegerField(db_column='addonCount',
default=0)),
],
options={
'db_table': 'collections',
'get_latest_by': 'created',
'abstract': False,
'base_manager_name': 'objects',
},
bases=(olympia.amo.models.SaveUpdateMixin, models.Model),
),
migrations.CreateModel(
name='FeaturedCollection',
fields=[
('created',
models.DateTimeField(blank=True,
default=django.utils.timezone.now,
editable=False)),
('modified', models.DateTimeField(auto_now=True)),
('id',
olympia.amo.fields.PositiveAutoField(primary_key=True,
serialize=False)),
('application',
models.PositiveIntegerField(choices=[(1, 'Firefox'),
(61,
'Firefox for Android')],
db_column='application_id')),
('locale', models.CharField(max_length=10, null=True)),
('collection',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='bandwagon.Collection')),
],
options={
'db_table': 'featured_collections',
},
bases=(olympia.amo.models.SaveUpdateMixin, models.Model),
),
migrations.CreateModel(
name='CollectionAddon',
fields=[
('created',
models.DateTimeField(blank=True,
default=django.utils.timezone.now,
editable=False)),
('modified', models.DateTimeField(auto_now=True)),
('id',
olympia.amo.fields.PositiveAutoField(primary_key=True,
serialize=False)),
('ordering',
models.PositiveIntegerField(
default=0,
help_text=
'Add-ons are displayed in ascending order based on this field.'
)),
('addon',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='addons.Addon')),
('collection',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='bandwagon.Collection')),
('comments',
olympia.translations.fields.LinkifiedField(
blank=True,
db_column='comments',
null=True,
on_delete=django.db.models.deletion.SET_NULL,
related_name='CollectionAddon_comments_set+',
require_locale=True,
short=True,
to='translations.LinkifiedTranslation',
to_field='id',
unique=True)),
('user',
models.ForeignKey(null=True,
on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
],
options={
'db_table': 'addons_collections',
'get_latest_by': 'created',
'abstract': False,
'base_manager_name': 'objects',
},
bases=(olympia.amo.models.SaveUpdateMixin, models.Model),
),
migrations.AddField(
model_name='collection',
name='addons',
field=models.ManyToManyField(related_name='collections',
through='bandwagon.CollectionAddon',
to='addons.Addon'),
),
migrations.AddField(
model_name='collection',
name='author',
field=models.ForeignKey(
null=True,
on_delete=django.db.models.deletion.CASCADE,
related_name='collections',
to=settings.AUTH_USER_MODEL),
),
migrations.AddField(
model_name='collection',
name='description',
field=olympia.translations.fields.NoURLsField(
blank=True,
db_column='description',
null=True,
on_delete=django.db.models.deletion.SET_NULL,
related_name='Collection_description_set+',
require_locale=False,
short=True,
to='translations.NoURLsTranslation',
to_field='id',
unique=True),
),
migrations.AddField(
model_name='collection',
name='name',
field=olympia.translations.fields.TranslatedField(
blank=True,
db_column='name',
null=True,
on_delete=django.db.models.deletion.SET_NULL,
related_name='Collection_name_set+',
require_locale=False,
short=True,
to='translations.Translation',
to_field='id',
unique=True),
),
migrations.AddIndex(
model_name='featuredcollection',
index=models.Index(fields=['application'],
name='application_id_idx'),
),
migrations.AddIndex(
model_name='collectionaddon',
index=models.Index(fields=['collection', 'created'],
name='created_idx'),
),
migrations.AddIndex(
model_name='collectionaddon',
index=models.Index(fields=['addon'], name='addon_id'),
),
migrations.AddIndex(
model_name='collectionaddon',
index=models.Index(fields=['collection'], name='collection_id'),
),
migrations.AddIndex(
model_name='collectionaddon',
index=models.Index(fields=['user'], name='user_id'),
),
migrations.AddConstraint(
model_name='collectionaddon',
constraint=models.UniqueConstraint(fields=('addon', 'collection'),
name='addon_id_2'),
),
migrations.AddIndex(
model_name='collection',
index=models.Index(fields=['application'], name='application_id'),
),
migrations.AddIndex(
model_name='collection',
index=models.Index(fields=['created'], name='created_idx'),
),
migrations.AddIndex(
model_name='collection',
index=models.Index(fields=['listed'], name='listed'),
),
migrations.AddIndex(
model_name='collection',
index=models.Index(fields=['slug'], name='slug_idx'),
),
migrations.AddIndex(
model_name='collection',
index=models.Index(fields=['type'], name='type_idx'),
),
migrations.AddConstraint(
model_name='collection',
constraint=models.UniqueConstraint(fields=('author', 'slug'),
name='author_id'),
),
]
class Migration(migrations.Migration):
dependencies = [
('share', '0034_auto_20170512_2052'),
]
operations = [
migrations.CreateModel(
name='CeleryTaskResult',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('correlation_id', models.TextField(blank=True)),
('status',
models.CharField(choices=[('FAILURE', 'FAILURE'),
('PENDING', 'PENDING'),
('RECEIVED', 'RECEIVED'),
('RETRY', 'RETRY'),
('REVOKED', 'REVOKED'),
('STARTED', 'STARTED'),
('SUCCESS', 'SUCCESS')],
db_index=True,
default='PENDING',
max_length=50)),
('task_id', models.UUIDField(db_index=True, unique=True)),
('meta',
share.models.fields.DateTimeAwareJSONField(editable=False,
null=True)),
('result',
share.models.fields.DateTimeAwareJSONField(editable=False,
null=True)),
('task_name',
models.TextField(blank=True,
db_index=True,
editable=False,
null=True)),
('traceback',
models.TextField(blank=True, editable=False, null=True)),
('date_created', models.DateTimeField(auto_now_add=True)),
('date_modified',
models.DateTimeField(auto_now=True, db_index=True)),
('share_version',
models.TextField(default=share.models.logs.get_share_version,
editable=False)),
],
options={
'verbose_name': 'Celery Task Result',
'verbose_name_plural': 'Celery Task Results',
},
),
migrations.DeleteModel(name='CeleryProviderTask', ),
migrations.AddField(
model_name='sourceconfig',
name='full_harvest',
field=models.BooleanField(
default=False,
help_text=
'Whether or not this SourceConfig should be fully harvested. Requires earliest_date to be set. The schedule harvests task will create all logs necessary if this flag is set. This should never be set to True by default. '
),
),
migrations.AddField(
model_name='sourceconfig',
name='harvest_after',
field=models.TimeField(default='02:00'),
),
migrations.AddField(
model_name='sourceconfig',
name='harvest_interval',
field=models.DurationField(default='1 day'),
),
migrations.AlterField(
model_name='harvestlog',
name='status',
field=models.IntegerField(choices=[
(0, 'Enqueued'), (1, 'In Progress'), (2, 'Failed'),
(3, 'Succeeded'), (4, 'Rescheduled'), (6, 'Forced'),
(7, 'Skipped'), (8, 'Retrying'), (9, 'Cancelled')
],
db_index=True,
default=0),
),
migrations.RemoveField(
model_name='normalizeddata',
name='tasks',
),
migrations.AddField(
model_name='normalizeddata',
name='tasks',
field=models.ManyToManyField(to='share.CeleryTaskResult'),
),
migrations.AddIndex(
model_name='celerytaskresult',
index=models.Index(fields=['-date_modified', '-id'],
name='share_celer_date_mo_686d4d_idx'),
),
migrations.RenameModel(
old_name='CeleryTask',
new_name='UnusedCeleryTask',
),
migrations.CreateModel(
name='UnusedCeleryProviderTask',
fields=[],
options={
'indexes': [],
'proxy': True,
},
bases=('share.unusedcelerytask', ),
),
migrations.AlterField(
model_name='unusedcelerytask',
name='type',
field=models.CharField(choices=[('share.unusedceleryprovidertask',
'unused celery provider task')],
db_index=True,
max_length=255),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = []
operations = [
migrations.CreateModel(
name="Hgnc",
fields=[
(
"id",
models.AutoField(
auto_created=True, primary_key=True, serialize=False, verbose_name="ID"
),
),
("hgnc_id", models.CharField(max_length=16)),
("symbol", models.CharField(max_length=32)),
("name", models.CharField(max_length=128)),
("locus_group", models.CharField(max_length=32, null=True)),
("locus_type", models.CharField(max_length=32, null=True)),
("status", models.CharField(max_length=32, null=True)),
("location", models.CharField(max_length=64, null=True)),
("location_sortable", models.CharField(max_length=64, null=True)),
("alias_symbol", models.CharField(max_length=128, null=True)),
("alias_name", models.CharField(max_length=512, null=True)),
("prev_symbol", models.CharField(max_length=128, null=True)),
("prev_name", models.CharField(max_length=1024, null=True)),
("gene_family", models.CharField(max_length=256, null=True)),
("gene_family_id", models.CharField(max_length=32, null=True)),
("date_approved_reserved", models.CharField(max_length=32, null=True)),
("date_symbol_changed", models.CharField(max_length=32, null=True)),
("date_name_changed", models.CharField(max_length=32, null=True)),
("date_modified", models.CharField(max_length=16, null=True)),
("entrez_id", models.CharField(max_length=16, null=True)),
("ensembl_gene_id", models.CharField(max_length=32, null=True)),
("vega_id", models.CharField(max_length=32, null=True)),
("ucsc_id", models.CharField(max_length=16, null=True)),
("ena", models.CharField(max_length=64, null=True)),
("refseq_accession", models.CharField(max_length=128, null=True)),
("ccds_id", models.CharField(max_length=256, null=True)),
("uniprot_ids", models.CharField(max_length=256, null=True)),
("pubmed_id", models.CharField(max_length=64, null=True)),
("mgd_id", models.CharField(max_length=256, null=True)),
("rgd_id", models.CharField(max_length=32, null=True)),
("lsdb", models.CharField(max_length=1024, null=True)),
("cosmic", models.CharField(max_length=32, null=True)),
("omim_id", models.CharField(max_length=32, null=True)),
("mirbase", models.CharField(max_length=16, null=True)),
("homeodb", models.CharField(max_length=16, null=True)),
("snornabase", models.CharField(max_length=16, null=True)),
("bioparadigms_slc", models.CharField(max_length=32, null=True)),
("orphanet", models.CharField(max_length=16, null=True)),
("pseudogene_org", models.CharField(max_length=32, null=True)),
("horde_id", models.CharField(max_length=16, null=True)),
("merops", models.CharField(max_length=16, null=True)),
("imgt", models.CharField(max_length=32, null=True)),
("iuphar", models.CharField(max_length=32, null=True)),
("kznf_gene_catalog", models.CharField(max_length=32, null=True)),
("namit_trnadb", models.CharField(max_length=16, null=True)),
("cd", models.CharField(max_length=16, null=True)),
("lncrnadb", models.CharField(max_length=32, null=True)),
("enzyme_id", models.CharField(max_length=64, null=True)),
("intermediate_filament_db", models.CharField(max_length=32, null=True)),
("rna_central_ids", models.CharField(max_length=32, null=True)),
],
),
migrations.CreateModel(
name="Hpo",
fields=[
(
"id",
models.AutoField(
auto_created=True, primary_key=True, serialize=False, verbose_name="ID"
),
),
("database_id", models.CharField(max_length=16)),
("name", models.CharField(max_length=1024, null=True)),
("qualifier", models.CharField(max_length=4, null=True)),
("hpo_id", models.CharField(max_length=16, null=True)),
("reference", models.CharField(max_length=128, null=True)),
("evidence", models.CharField(max_length=4, null=True)),
("onset", models.CharField(max_length=16, null=True)),
("frequency", models.CharField(max_length=16, null=True)),
("sex", models.CharField(max_length=8, null=True)),
("modifier", models.CharField(max_length=16, null=True)),
("aspect", models.CharField(max_length=1, null=True)),
("biocuration", models.CharField(max_length=32, null=True)),
],
),
migrations.CreateModel(
name="Mim2geneMedgen",
fields=[
(
"id",
models.AutoField(
auto_created=True, primary_key=True, serialize=False, verbose_name="ID"
),
),
("omim_id", models.IntegerField()),
("entrez_id", models.CharField(max_length=16, null=True)),
("omim_type", models.CharField(max_length=32, null=True)),
("source", models.CharField(max_length=32, null=True)),
("medgen_cui", models.CharField(max_length=8, null=True)),
("comment", models.CharField(max_length=64, null=True)),
],
),
migrations.AddIndex(
model_name="mim2genemedgen",
index=models.Index(fields=["entrez_id"], name="geneinfo_mi_entrez__df3c2a_idx"),
),
migrations.AddIndex(
model_name="hpo",
index=models.Index(fields=["database_id"], name="geneinfo_hp_databas_ab9ccc_idx"),
),
migrations.AddIndex(
model_name="hgnc",
index=models.Index(fields=["ensembl_gene_id"], name="geneinfo_hg_ensembl_d4d39c_idx"),
),
]
