class Migration(migrations.Migration): dependencies = [ ('order', '0018_historicalline_historicalorder'), migrations.swappable_dependency(settings.AUTH_USER_MODEL), ('refund', '0005_auto_20180628_2011'), ] operations = [ migrations.CreateModel( name='HistoricalRefund', fields=[ ('id', models.IntegerField(auto_created=True, blank=True, db_index=True, 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')), ('total_credit_excl_tax', models.DecimalField(decimal_places=2, max_digits=12, verbose_name='Total Credit (excl. tax)')), ('currency', models.CharField(default=oscar.core.utils.get_default_currency, max_length=12, verbose_name='Currency')), ('status', models.CharField(choices=[(b'Open', b'Open'), (b'Denied', b'Denied'), (b'Payment Refund Error', b'Payment Refund Error'), (b'Payment Refunded', b'Payment Refunded'), (b'Revocation Error', b'Revocation Error'), (b'Complete', b'Complete')], max_length=255, verbose_name='Status')), ('history_id', models.AutoField(primary_key=True, serialize=False)), ('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)), ('order', models.ForeignKey(blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='order.Order', verbose_name='Order')), ('user', models.ForeignKey(blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to=settings.AUTH_USER_MODEL, verbose_name='User')), ], options={ 'ordering': ('-history_date', '-history_id'), 'get_latest_by': 'history_date', 'verbose_name': 'historical refund', }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name='HistoricalRefundLine', fields=[ ('id', models.IntegerField(auto_created=True, blank=True, db_index=True, 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')), ('line_credit_excl_tax', models.DecimalField(decimal_places=2, max_digits=12, verbose_name='Line Credit (excl. tax)')), ('quantity', models.PositiveIntegerField(default=1, verbose_name='Quantity')), ('status', models.CharField(choices=[(b'Open', b'Open'), (b'Revocation Error', b'Revocation Error'), (b'Denied', b'Denied'), (b'Complete', b'Complete')], max_length=255, verbose_name='Status')), ('history_id', models.AutoField(primary_key=True, serialize=False)), ('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)), ('order_line', models.ForeignKey(blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='order.Line', verbose_name='Order Line')), ('refund', models.ForeignKey(blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='refund.Refund', verbose_name='Refund')), ], options={ 'ordering': ('-history_date', '-history_id'), 'get_latest_by': 'history_date', 'verbose_name': 'historical refund line', }, bases=(simple_history.models.HistoricalChanges, models.Model), ), ]
class Migration(migrations.Migration): dependencies = [ ('catalogue', '0039_historicalproduct_historicalproductattributevalue'), migrations.swappable_dependency(settings.AUTH_USER_MODEL), ('partner', '0013_partner_default_site'), ] operations = [ migrations.CreateModel( name='HistoricalStockRecord', fields=[ ('id', models.IntegerField(auto_created=True, blank=True, db_index=True, verbose_name='ID')), ('partner_sku', models.CharField(max_length=128, verbose_name='Partner SKU')), ('price_currency', models.CharField(default=oscar.core.utils.get_default_currency, max_length=12, verbose_name='Currency')), ('price_excl_tax', models.DecimalField(blank=True, decimal_places=2, max_digits=12, null=True, verbose_name='Price (excl. tax)')), ('price_retail', models.DecimalField(blank=True, decimal_places=2, max_digits=12, null=True, verbose_name='Price (retail)')), ('cost_price', models.DecimalField(blank=True, decimal_places=2, max_digits=12, null=True, verbose_name='Cost Price')), ('num_in_stock', models.PositiveIntegerField(blank=True, null=True, verbose_name='Number in stock')), ('num_allocated', models.IntegerField(blank=True, null=True, verbose_name='Number allocated')), ('low_stock_threshold', models.PositiveIntegerField(blank=True, null=True, verbose_name='Low Stock Threshold')), ('date_created', models.DateTimeField(blank=True, editable=False, verbose_name='Date created')), ('date_updated', models.DateTimeField(blank=True, db_index=True, editable=False, verbose_name='Date updated')), ('history_id', models.AutoField(primary_key=True, serialize=False)), ('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)), ('partner', models.ForeignKey(blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='partner.Partner', verbose_name='Partner')), ('product', models.ForeignKey(blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='catalogue.Product', verbose_name='Product')), ], options={ 'ordering': ('-history_date', '-history_id'), 'get_latest_by': 'history_date', 'verbose_name': 'historical Stock record', }, bases=(simple_history.models.HistoricalChanges, models.Model), ), ]
class Migration(migrations.Migration): dependencies = [ migrations.swappable_dependency(settings.AUTH_USER_MODEL), ("contenttypes", "0002_remove_content_type_name"), ("content", "0013_auto_20210216_0946"), ] operations = [ migrations.CreateModel( name="HistoricalTheme", fields=[ ( "id", models.IntegerField(auto_created=True, blank=True, db_index=True, verbose_name="ID"), ), ("title", models.CharField(max_length=255)), ("slug", models.SlugField(max_length=255)), ("summary", models.CharField(max_length=255)), ("history_id", models.AutoField(primary_key=True, serialize=False)), ("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, ), ), ], options={ "verbose_name": "historical theme", "ordering": ("-history_date", "-history_id"), "get_latest_by": "history_date", }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name="HistoricalSiteAlertBanner", fields=[ ( "id", models.IntegerField(auto_created=True, blank=True, db_index=True, verbose_name="ID"), ), ("banner_text", models.CharField(max_length=255)), ("activated", models.BooleanField(default=False)), ("history_id", models.AutoField(primary_key=True, serialize=False)), ("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, ), ), ], options={ "verbose_name": "historical site alert banner", "ordering": ("-history_date", "-history_id"), "get_latest_by": "history_date", }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name="HistoricalSearchPinPageLookUp", fields=[ ( "id", models.IntegerField(auto_created=True, blank=True, db_index=True, verbose_name="ID"), ), ("object_id", models.PositiveIntegerField()), ("history_id", models.AutoField(primary_key=True, serialize=False)), ("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, ), ), ( "content_type", models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", to="contenttypes.contenttype", ), ), ( "history_user", models.ForeignKey( null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="+", to=settings.AUTH_USER_MODEL, ), ), ( "search_keyword_or_phrase", models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", to="content.searchkeywordorphrase", ), ), ], options={ "verbose_name": "historical search pin page look up", "ordering": ("-history_date", "-history_id"), "get_latest_by": "history_date", }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name="HistoricalSearchKeywordOrPhrase", fields=[ ( "id", models.IntegerField(auto_created=True, blank=True, db_index=True, verbose_name="ID"), ), ("keyword_or_phrase", models.CharField(max_length=1000)), ("history_id", models.AutoField(primary_key=True, serialize=False)), ("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, ), ), ], options={ "verbose_name": "historical search keyword or phrase", "ordering": ("-history_date", "-history_id"), "get_latest_by": "history_date", }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name="HistoricalSearchExclusionPageLookUp", fields=[ ( "id", models.IntegerField(auto_created=True, blank=True, db_index=True, verbose_name="ID"), ), ("object_id", models.PositiveIntegerField()), ("history_id", models.AutoField(primary_key=True, serialize=False)), ("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, ), ), ( "content_type", models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", to="contenttypes.contenttype", ), ), ( "history_user", models.ForeignKey( null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="+", to=settings.AUTH_USER_MODEL, ), ), ( "search_keyword_or_phrase", models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", to="content.searchkeywordorphrase", ), ), ], options={ "verbose_name": "historical search exclusion page look up", "ordering": ("-history_date", "-history_id"), "get_latest_by": "history_date", }, bases=(simple_history.models.HistoricalChanges, models.Model), ), ]
class Migration(migrations.Migration): initial = True dependencies = [ ('project', '0001_initial'), migrations.swappable_dependency(settings.AUTH_USER_MODEL), ] operations = [ migrations.CreateModel( name='HistoricalPublication', fields=[ ('id', models.IntegerField(auto_created=True, blank=True, db_index=True, verbose_name='ID')), ('created', model_utils.fields.AutoCreatedField( default=django.utils.timezone.now, editable=False, verbose_name='created')), ('modified', model_utils.fields.AutoLastModifiedField( default=django.utils.timezone.now, editable=False, verbose_name='modified')), ('title', models.CharField(max_length=1024)), ('author', models.CharField(max_length=1024)), ('year', models.PositiveIntegerField()), ('unique_id', models.CharField(blank=True, max_length=255, null=True)), ('status', models.CharField(choices=[('Active', 'Active'), ('Archived', 'Archived')], default='Active', max_length=16)), ('history_id', models.AutoField(primary_key=True, serialize=False)), ('history_change_reason', models.CharField(max_length=100, null=True)), ('history_date', models.DateTimeField()), ('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)), ('project', models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='project.Project')), ], options={ 'get_latest_by': 'history_date', 'verbose_name': 'historical publication', 'ordering': ('-history_date', '-history_id'), }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name='Publication', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('created', model_utils.fields.AutoCreatedField( default=django.utils.timezone.now, editable=False, verbose_name='created')), ('modified', model_utils.fields.AutoLastModifiedField( default=django.utils.timezone.now, editable=False, verbose_name='modified')), ('title', models.CharField(max_length=1024)), ('author', models.CharField(max_length=1024)), ('year', models.PositiveIntegerField()), ('unique_id', models.CharField(blank=True, max_length=255, null=True)), ('status', models.CharField(choices=[('Active', 'Active'), ('Archived', 'Archived')], default='Active', max_length=16)), ('project', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='project.Project')), ], ), migrations.CreateModel( name='PublicationSource', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('created', model_utils.fields.AutoCreatedField( default=django.utils.timezone.now, editable=False, verbose_name='created')), ('modified', model_utils.fields.AutoLastModifiedField( default=django.utils.timezone.now, editable=False, verbose_name='modified')), ('name', models.CharField(max_length=255)), ('url', models.URLField()), ], options={ 'abstract': False, }, ), migrations.AddField( model_name='publication', name='source', field=models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, to='publication.PublicationSource'), ), migrations.AddField( model_name='historicalpublication', name='source', field=models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='publication.PublicationSource'), ), migrations.AlterUniqueTogether( name='publication', unique_together={('project', 'unique_id')}, ), ]
class Migration(migrations.Migration): dependencies = [ migrations.swappable_dependency(settings.AUTH_USER_MODEL), ("barriers", "0091_auto_20201015_1407"), ("assessment", "0008_auto_20200901_1511"), ] operations = [ migrations.CreateModel( name="StrategicAssessment", fields=[ ( "created_on", models.DateTimeField(auto_now_add=True, db_index=True, null=True), ), ("modified_on", models.DateTimeField(auto_now=True, null=True)), ("archived", models.BooleanField(default=False)), ("archived_on", models.DateTimeField(blank=True, null=True)), ("archived_reason", models.TextField(blank=True, null=True)), ("approved", models.BooleanField(null=True)), ("reviewed_on", models.DateTimeField(null=True)), ( "id", models.UUIDField(default=uuid.uuid4, primary_key=True, serialize=False), ), ("hmg_strategy", models.TextField()), ("government_policy", models.TextField()), ("trading_relations", models.TextField()), ("uk_interest_and_security", models.TextField()), ("uk_grants", models.TextField()), ("competition", models.TextField()), ("additional_information", models.TextField(blank=True)), ( "scale", models.PositiveIntegerField( choices=[ ( 1, "1: 3 or more government wide objectives, or poses medium/high risk to delivery of one of government wide objectives and/or potential for significant PR issues.", ), ( 2, "2: 1 or 2 government wide objectives but does not pose much risk for PR or objective delivery", ), (3, "3: neutral to government wide objectives"), (4, "4: supports 1 or 2 government wide objectives"), ( 5, "5: substantial contribution to 1 strategic objective or supporting 3 or more strategic objectives", ), ], null=True, ), ), ( "archived_by", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="+", to=settings.AUTH_USER_MODEL, ), ), ( "barrier", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="strategic_assessments", to="barriers.barrierinstance", ), ), ( "created_by", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="+", to=settings.AUTH_USER_MODEL, ), ), ( "modified_by", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="+", to=settings.AUTH_USER_MODEL, ), ), ( "reviewed_by", models.ForeignKey( null=True, on_delete=django.db.models.deletion.SET_NULL, to=settings.AUTH_USER_MODEL, ), ), ], options={ "ordering": ("-created_on", ), "permissions": ( ("archive_strategicassessment", "Can archive strategic assessment"), ("approve_strategicassessment", "Can approve strategic assessment"), ), }, bases=(api.barriers.mixins.BarrierRelatedMixin, models.Model), ), migrations.CreateModel( name="ResolvabilityAssessment", fields=[ ( "created_on", models.DateTimeField(auto_now_add=True, db_index=True, null=True), ), ("modified_on", models.DateTimeField(auto_now=True, null=True)), ("archived", models.BooleanField(default=False)), ("archived_on", models.DateTimeField(blank=True, null=True)), ("archived_reason", models.TextField(blank=True, null=True)), ("approved", models.BooleanField(null=True)), ("reviewed_on", models.DateTimeField(null=True)), ( "id", models.UUIDField(default=uuid.uuid4, primary_key=True, serialize=False), ), ( "time_to_resolve", models.PositiveIntegerField( choices=[ (0, "0: not resolvable"), (1, "1: longer than 5 years"), (2, "2: 3 to 5 years"), (3, "3: 1 to 3 years"), (4, "4: within a year"), ], null=True, ), ), ( "effort_to_resolve", models.PositiveIntegerField( choices=[ (0, "0: Not resolvable"), ( 1, "1: Highly resource intensive (significant resources needed)", ), ( 2, "2: substantial resources required (extras or significant reprioritisation of exsiting resources needed)", ), ( 3, "3: moderate resources required (low or moderate prioritisation or resources needed", ), ( 4, "4: low resource requirement (can be delivered within existing resources", ), ], null=True, ), ), ("explanation", models.TextField(blank=True)), ( "archived_by", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="+", to=settings.AUTH_USER_MODEL, ), ), ( "barrier", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="resolvability_assessments", to="barriers.barrierinstance", ), ), ( "created_by", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="+", to=settings.AUTH_USER_MODEL, ), ), ( "modified_by", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="+", to=settings.AUTH_USER_MODEL, ), ), ( "reviewed_by", models.ForeignKey( null=True, on_delete=django.db.models.deletion.SET_NULL, to=settings.AUTH_USER_MODEL, ), ), ], options={ "ordering": ("-created_on", ), "permissions": ( ( "archive_resolvabilityassessment", "Can archive resolvability assessment", ), ( "approve_resolvabilityassessment", "Can approve resolvability assessment", ), ), }, bases=(api.barriers.mixins.BarrierRelatedMixin, models.Model), ), migrations.CreateModel( name="HistoricalStrategicAssessment", fields=[ ( "created_on", models.DateTimeField(blank=True, db_index=True, editable=False, null=True), ), ( "modified_on", models.DateTimeField(blank=True, editable=False, null=True), ), ("archived", models.BooleanField(default=False)), ("archived_on", models.DateTimeField(blank=True, null=True)), ("archived_reason", models.TextField(blank=True, null=True)), ("approved", models.BooleanField(null=True)), ("reviewed_on", models.DateTimeField(null=True)), ("id", models.UUIDField(db_index=True, default=uuid.uuid4)), ("hmg_strategy", models.TextField()), ("government_policy", models.TextField()), ("trading_relations", models.TextField()), ("uk_interest_and_security", models.TextField()), ("uk_grants", models.TextField()), ("competition", models.TextField()), ("additional_information", models.TextField(blank=True)), ( "scale", models.PositiveIntegerField( choices=[ ( 1, "1: 3 or more government wide objectives, or poses medium/high risk to delivery of one of government wide objectives and/or potential for significant PR issues.", ), ( 2, "2: 1 or 2 government wide objectives but does not pose much risk for PR or objective delivery", ), (3, "3: neutral to government wide objectives"), (4, "4: supports 1 or 2 government wide objectives"), ( 5, "5: substantial contribution to 1 strategic objective or supporting 3 or more strategic objectives", ), ], null=True, ), ), ("history_id", models.AutoField(primary_key=True, serialize=False)), ("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, ), ), ( "archived_by", models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", to=settings.AUTH_USER_MODEL, ), ), ( "barrier", models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", to="barriers.barrierinstance", ), ), ( "created_by", models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", to=settings.AUTH_USER_MODEL, ), ), ( "history_user", models.ForeignKey( null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="+", to=settings.AUTH_USER_MODEL, ), ), ( "modified_by", models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", to=settings.AUTH_USER_MODEL, ), ), ( "reviewed_by", models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", to=settings.AUTH_USER_MODEL, ), ), ], options={ "verbose_name": "historical strategic assessment", "ordering": ("-history_date", "-history_id"), "get_latest_by": "history_date", }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name="HistoricalResolvabilityAssessment", fields=[ ( "created_on", models.DateTimeField(blank=True, db_index=True, editable=False, null=True), ), ( "modified_on", models.DateTimeField(blank=True, editable=False, null=True), ), ("archived", models.BooleanField(default=False)), ("archived_on", models.DateTimeField(blank=True, null=True)), ("archived_reason", models.TextField(blank=True, null=True)), ("approved", models.BooleanField(null=True)), ("reviewed_on", models.DateTimeField(null=True)), ("id", models.UUIDField(db_index=True, default=uuid.uuid4)), ( "time_to_resolve", models.PositiveIntegerField( choices=[ (0, "0: not resolvable"), (1, "1: longer than 5 years"), (2, "2: 3 to 5 years"), (3, "3: 1 to 3 years"), (4, "4: within a year"), ], null=True, ), ), ( "effort_to_resolve", models.PositiveIntegerField( choices=[ (0, "0: Not resolvable"), ( 1, "1: Highly resource intensive (significant resources needed)", ), ( 2, "2: substantial resources required (extras or significant reprioritisation of exsiting resources needed)", ), ( 3, "3: moderate resources required (low or moderate prioritisation or resources needed", ), ( 4, "4: low resource requirement (can be delivered within existing resources", ), ], null=True, ), ), ("explanation", models.TextField(blank=True)), ("history_id", models.AutoField(primary_key=True, serialize=False)), ("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, ), ), ( "archived_by", models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", to=settings.AUTH_USER_MODEL, ), ), ( "barrier", models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", to="barriers.barrierinstance", ), ), ( "created_by", models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", to=settings.AUTH_USER_MODEL, ), ), ( "history_user", models.ForeignKey( null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="+", to=settings.AUTH_USER_MODEL, ), ), ( "modified_by", models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", to=settings.AUTH_USER_MODEL, ), ), ( "reviewed_by", models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", to=settings.AUTH_USER_MODEL, ), ), ], options={ "verbose_name": "historical resolvability assessment", "ordering": ("-history_date", "-history_id"), "get_latest_by": "history_date", }, bases=(simple_history.models.HistoricalChanges, models.Model), ), ]
class Migration(migrations.Migration): initial = True dependencies = [ migrations.swappable_dependency(settings.AUTH_USER_MODEL), ("auth", "0011_update_proxy_permissions"), ("workstation_configs", "0001_squashed_0008_auto_20201001_0758"), ] operations = [ migrations.CreateModel( name="Workstation", fields=[ ( "id", models.UUIDField( default=uuid.uuid4, editable=False, primary_key=True, serialize=False, ), ), ("created", models.DateTimeField(auto_now_add=True)), ("modified", models.DateTimeField(auto_now=True)), ( "title", models.CharField(max_length=255, verbose_name="title"), ), ( "description", models.TextField(blank=True, null=True, verbose_name="description"), ), ( "slug", django_extensions.db.fields.AutoSlugField( blank=True, editable=False, populate_from="title", verbose_name="slug", ), ), ( "logo", models.ImageField( storage=grandchallenge.core.storage.PublicS3Storage(), upload_to=grandchallenge.core.storage.get_logo_path, ), ), ( "editors_group", models.OneToOneField( editable=False, on_delete=django.db.models.deletion.CASCADE, related_name="editors_of_workstation", to="auth.group", ), ), ( "users_group", models.OneToOneField( editable=False, on_delete=django.db.models.deletion.CASCADE, related_name="users_of_workstation", to="auth.group", ), ), ( "config", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, to="workstation_configs.workstationconfig", ), ), ( "public", models.BooleanField( default=False, help_text= "If True, all logged in users can use this workstation, otherwise, only the users group can use this workstation.", ), ), ], options={ "abstract": False, "ordering": ("created", "title") }, ), migrations.CreateModel( name="WorkstationImage", fields=[ ( "id", models.UUIDField( default=uuid.uuid4, editable=False, primary_key=True, serialize=False, ), ), ("created", models.DateTimeField(auto_now_add=True)), ("modified", models.DateTimeField(auto_now=True)), ( "staged_image_uuid", models.UUIDField(blank=True, editable=False, null=True), ), ( "image", models.FileField( blank=True, help_text= ".tar.xz archive of the container image produced from the command 'docker save IMAGE | xz -c > IMAGE.tar.xz'. See https://docs.docker.com/engine/reference/commandline/save/", storage=grandchallenge.core.storage.PrivateS3Storage(), upload_to=grandchallenge.components.models. docker_image_path, validators=[ grandchallenge.core.validators.ExtensionValidator( allowed_extensions=( ".tar", ".tar.gz", ".tar.xz", )) ], ), ), ( "image_sha256", models.CharField(editable=False, max_length=71), ), ( "ready", models.BooleanField( default=False, editable=False, help_text="Is this image ready to be used?", ), ), ("status", models.TextField(editable=False)), ("requires_gpu", models.BooleanField(default=False)), ( "requires_gpu_memory_gb", models.PositiveIntegerField(default=4), ), ("requires_memory_gb", models.PositiveIntegerField(default=4)), ( "requires_cpu_cores", models.DecimalField(decimal_places=2, default=Decimal("1.0"), max_digits=4), ), ( "http_port", models.PositiveIntegerField( default=8080, validators=[ django.core.validators.MaxValueValidator(65535) ], ), ), ( "websocket_port", models.PositiveIntegerField( default=4114, validators=[ django.core.validators.MaxValueValidator(65535) ], ), ), ( "initial_path", models.CharField( default="cirrus", max_length=256, validators=[ django.core.validators.RegexValidator( message= "This path is invalid, it must not start with a /", regex="^(?:[^/][^\\s]*)\\Z", ) ], ), ), ( "creator", models.ForeignKey( null=True, on_delete=django.db.models.deletion.SET_NULL, to=settings.AUTH_USER_MODEL, ), ), ( "workstation", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, to="workstations.workstation", ), ), ], options={ "abstract": False, "ordering": ("created", "creator") }, ), migrations.CreateModel( name="HistoricalSession", fields=[ ( "id", models.UUIDField(db_index=True, default=uuid.uuid4, editable=False), ), ("created", models.DateTimeField(blank=True, editable=False)), ("modified", models.DateTimeField(blank=True, editable=False)), ( "status", models.PositiveSmallIntegerField( choices=[ (0, "Queued"), (1, "Started"), (2, "Running"), (3, "Failed"), (4, "Stopped"), ], default=0, ), ), ( "maximum_duration", models.DurationField(default=datetime.timedelta( seconds=600)), ), ("user_finished", models.BooleanField(default=False)), ( "history_id", models.AutoField(primary_key=True, serialize=False), ), ("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, ), ), ( "creator", models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", to=settings.AUTH_USER_MODEL, ), ), ( "history_user", models.ForeignKey( null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="+", to=settings.AUTH_USER_MODEL, ), ), ( "workstation_image", models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", to="workstations.workstationimage", ), ), ( "region", models.CharField( choices=[ ("af-south-1", "Africa (Cape Town)"), ("ap-east-1", "Asia Pacific (Hong Kong)"), ("ap-northeast-1", "Asia Pacific (Tokyo)"), ("ap-northeast-2", "Asia Pacific (Seoul)"), ("ap-northeast-3", "Asia Pacific (Osaka-Local)"), ("ap-south-1", "Asia Pacific (Mumbai)"), ("ap-southeast-1", "Asia Pacific (Singapore)"), ("ap-southeast-2", "Asia Pacific (Sydney)"), ("ca-central-1", "Canada (Central)"), ("eu-central-1", "Europe (Frankfurt)"), ("eu-north-1", "Europe (Stockholm)"), ("eu-south-1", "Europe (Milan)"), ("eu-west-1", "Europe (Ireland)"), ("eu-west-2", "Europe (London)"), ("eu-west-3", "Europe (Paris)"), ("me-south-1", "Middle East (Bahrain)"), ("sa-east-1", "South America (São Paulo)"), ("us-east-1", "US East (N. Virginia)"), ("us-east-2", "US East (Ohio)"), ("us-west-1", "US West (N. California)"), ("us-west-2", "US West (Oregon)"), ("eu-nl-1", "Netherlands (Nijmegen)"), ("eu-nl-2", "Netherlands (Amsterdam)"), ], default="eu-nl-1", help_text="Which region is this session available in?", max_length=14, ), ), ], options={ "verbose_name": "historical session", "ordering": ("-history_date", "-history_id"), "get_latest_by": "history_date", }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name="Session", fields=[ ( "id", models.UUIDField( default=uuid.uuid4, editable=False, primary_key=True, serialize=False, ), ), ("created", models.DateTimeField(auto_now_add=True)), ("modified", models.DateTimeField(auto_now=True)), ( "status", models.PositiveSmallIntegerField( choices=[ (0, "Queued"), (1, "Started"), (2, "Running"), (3, "Failed"), (4, "Stopped"), ], default=0, ), ), ( "maximum_duration", models.DurationField(default=datetime.timedelta( seconds=600)), ), ("user_finished", models.BooleanField(default=False)), ( "creator", models.ForeignKey( null=True, on_delete=django.db.models.deletion.SET_NULL, to=settings.AUTH_USER_MODEL, ), ), ( "workstation_image", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, to="workstations.workstationimage", ), ), ("logs", models.TextField(blank=True, editable=False)), ( "region", models.CharField( choices=[ ("af-south-1", "Africa (Cape Town)"), ("ap-east-1", "Asia Pacific (Hong Kong)"), ("ap-northeast-1", "Asia Pacific (Tokyo)"), ("ap-northeast-2", "Asia Pacific (Seoul)"), ("ap-northeast-3", "Asia Pacific (Osaka-Local)"), ("ap-south-1", "Asia Pacific (Mumbai)"), ("ap-southeast-1", "Asia Pacific (Singapore)"), ("ap-southeast-2", "Asia Pacific (Sydney)"), ("ca-central-1", "Canada (Central)"), ("eu-central-1", "Europe (Frankfurt)"), ("eu-north-1", "Europe (Stockholm)"), ("eu-south-1", "Europe (Milan)"), ("eu-west-1", "Europe (Ireland)"), ("eu-west-2", "Europe (London)"), ("eu-west-3", "Europe (Paris)"), ("me-south-1", "Middle East (Bahrain)"), ("sa-east-1", "South America (São Paulo)"), ("us-east-1", "US East (N. Virginia)"), ("us-east-2", "US East (Ohio)"), ("us-west-1", "US West (N. California)"), ("us-west-2", "US West (Oregon)"), ("eu-nl-1", "Netherlands (Nijmegen)"), ("eu-nl-2", "Netherlands (Amsterdam)"), ], default="eu-nl-1", help_text="Which region is this session available in?", max_length=14, ), ), ("ping_times", models.JSONField(default=None, null=True)), ], options={ "abstract": False, "ordering": ("created", "creator") }, ), ]
class Migration(migrations.Migration): dependencies = [ ( "caluma_form", "0020_historicalanswer_historicalanswerdocument_historicaldocument_historicalfile_historicalform_historica", ), ("caluma_workflow", "0011_auto_20190220_1303"), ] operations = [ migrations.CreateModel( name="HistoricalCase", fields=[ ("created_at", models.DateTimeField(blank=True, editable=False)), ("modified_at", models.DateTimeField(blank=True, editable=False)), ( "created_by_user", models.CharField(blank=True, max_length=150, null=True), ), ( "created_by_group", models.CharField(blank=True, db_index=True, max_length=150, null=True), ), ("history_user_id", models.CharField(max_length=150, null=True)), ( "id", models.UUIDField(db_index=True, default=uuid.uuid4, editable=False), ), ( "closed_at", models.DateTimeField( blank=True, help_text= "Time when case has either been canceled or completed", null=True, ), ), ( "closed_by_user", models.CharField(blank=True, max_length=150, null=True), ), ( "closed_by_group", models.CharField(blank=True, max_length=150, null=True), ), ( "status", models.CharField( choices=[ ( "running", "Case is running and work items need to be completed.", ), ("completed", "Case is done."), ("canceled", "Case is cancelled."), ], db_index=True, max_length=50, ), ), ("meta", models.JSONField(default=dict)), ( "history_id", models.UUIDField( default=uuid.uuid4, editable=False, primary_key=True, serialize=False, ), ), ("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, ), ), ( "document", models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", to="caluma_form.Document", ), ), ( "workflow", models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", to="caluma_workflow.Workflow", ), ), ], options={ "verbose_name": "historical case", "ordering": ("-history_date", "-history_id"), "get_latest_by": "history_date", }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name="HistoricalFlow", fields=[ ("created_at", models.DateTimeField(blank=True, editable=False)), ("modified_at", models.DateTimeField(blank=True, editable=False)), ( "created_by_user", models.CharField(blank=True, max_length=150, null=True), ), ( "created_by_group", models.CharField(blank=True, db_index=True, max_length=150, null=True), ), ("history_user_id", models.CharField(max_length=150, null=True)), ( "id", models.UUIDField(db_index=True, default=uuid.uuid4, editable=False), ), ("next", models.TextField()), ( "history_id", models.UUIDField( default=uuid.uuid4, editable=False, primary_key=True, serialize=False, ), ), ("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, ), ), ], options={ "verbose_name": "historical flow", "ordering": ("-history_date", "-history_id"), "get_latest_by": "history_date", }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name="HistoricalTask", fields=[ ("created_at", models.DateTimeField(blank=True, editable=False)), ("modified_at", models.DateTimeField(blank=True, editable=False)), ( "created_by_user", models.CharField(blank=True, max_length=150, null=True), ), ( "created_by_group", models.CharField(blank=True, db_index=True, max_length=150, null=True), ), ("history_user_id", models.CharField(max_length=150, null=True)), ("slug", models.SlugField()), ("name", localized_fields.fields.field.LocalizedField(required=[])), ( "description", localized_fields.fields.field.LocalizedField(blank=True, null=True, required=[]), ), ( "type", models.CharField( choices=[ ("simple", "Task which can simply be marked as completed."), ( "complete_workflow_form", "Task to complete a defined workflow form.", ), ( "complete_task_form", "Task to complete a defined task form.", ), ], max_length=50, ), ), ("meta", models.JSONField(default=dict)), ( "address_groups", models.TextField( blank=True, help_text= "Group jexl returning what group(s) derived work items will be addressed to.", null=True, ), ), ("is_archived", models.BooleanField(default=False)), ( "lead_time", models.PositiveIntegerField( blank=True, help_text= "Time in seconds task may take to be processed.", null=True, ), ), ( "is_multiple_instance", models.BooleanField( default=False, help_text= "Allows creating multiple work items for this task using the `CreateWorkItem` mutation. If true, one work item will be created for each entry in `address_groups`.", ), ), ( "history_id", models.UUIDField( default=uuid.uuid4, editable=False, primary_key=True, serialize=False, ), ), ("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, ), ), ( "form", models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", to="caluma_form.Form", ), ), ], options={ "verbose_name": "historical task", "ordering": ("-history_date", "-history_id"), "get_latest_by": "history_date", }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name="HistoricalTaskFlow", fields=[ ("created_at", models.DateTimeField(blank=True, editable=False)), ("modified_at", models.DateTimeField(blank=True, editable=False)), ( "created_by_user", models.CharField(blank=True, max_length=150, null=True), ), ( "created_by_group", models.CharField(blank=True, db_index=True, max_length=150, null=True), ), ("history_user_id", models.CharField(max_length=150, null=True)), ( "id", models.UUIDField(db_index=True, default=uuid.uuid4, editable=False), ), ( "history_id", models.UUIDField( default=uuid.uuid4, editable=False, primary_key=True, serialize=False, ), ), ("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, ), ), ( "flow", models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", to="caluma_workflow.Flow", ), ), ( "task", models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", to="caluma_workflow.Task", ), ), ( "workflow", models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", to="caluma_workflow.Workflow", ), ), ], options={ "verbose_name": "historical task flow", "ordering": ("-history_date", "-history_id"), "get_latest_by": "history_date", }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name="HistoricalWorkflow", fields=[ ("created_at", models.DateTimeField(blank=True, editable=False)), ("modified_at", models.DateTimeField(blank=True, editable=False)), ( "created_by_user", models.CharField(blank=True, max_length=150, null=True), ), ( "created_by_group", models.CharField(blank=True, db_index=True, max_length=150, null=True), ), ("history_user_id", models.CharField(max_length=150, null=True)), ("slug", models.SlugField()), ("name", localized_fields.fields.field.LocalizedField(required=[])), ( "description", localized_fields.fields.field.LocalizedField(blank=True, null=True, required=[]), ), ("meta", models.JSONField(default=dict)), ("is_published", models.BooleanField(default=False)), ("is_archived", models.BooleanField(default=False)), ( "allow_all_forms", models.BooleanField( default=False, help_text="Allow workflow to be started with any form", ), ), ( "history_id", models.UUIDField( default=uuid.uuid4, editable=False, primary_key=True, serialize=False, ), ), ("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, ), ), ], options={ "verbose_name": "historical workflow", "ordering": ("-history_date", "-history_id"), "get_latest_by": "history_date", }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name="HistoricalWorkItem", fields=[ ("created_at", models.DateTimeField(blank=True, editable=False)), ("modified_at", models.DateTimeField(blank=True, editable=False)), ( "created_by_user", models.CharField(blank=True, max_length=150, null=True), ), ( "created_by_group", models.CharField(blank=True, db_index=True, max_length=150, null=True), ), ("history_user_id", models.CharField(max_length=150, null=True)), ( "id", models.UUIDField(db_index=True, default=uuid.uuid4, editable=False), ), ( "closed_at", models.DateTimeField( blank=True, help_text= "Time when work item has either been canceled or completed", null=True, ), ), ( "closed_by_user", models.CharField(blank=True, max_length=150, null=True), ), ( "closed_by_group", models.CharField(blank=True, max_length=150, null=True), ), ("deadline", models.DateTimeField(blank=True, null=True)), ( "status", models.CharField( choices=[ ("ready", "Task is ready to be processed."), ("completed", "Task is done."), ("canceled", "Task is cancelled."), ], db_index=True, max_length=50, ), ), ("meta", models.JSONField(default=dict)), ( "addressed_groups", django.contrib.postgres.fields.ArrayField( base_field=models.CharField(max_length=150), default=list, help_text= "Offer work item to be processed by a group of users, such are not committed to process it though.", size=None, ), ), ( "assigned_users", django.contrib.postgres.fields.ArrayField( base_field=models.CharField(max_length=150), default=list, help_text= "Users responsible to undertake given work item.", size=None, ), ), ( "history_id", models.UUIDField( default=uuid.uuid4, editable=False, primary_key=True, serialize=False, ), ), ("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, ), ), ( "case", models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", to="caluma_workflow.Case", ), ), ( "child_case", models.ForeignKey( blank=True, db_constraint=False, help_text="Defines case of a sub-workflow", null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", to="caluma_workflow.Case", ), ), ( "document", models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", to="caluma_form.Document", ), ), ( "task", models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", to="caluma_workflow.Task", ), ), ], options={ "verbose_name": "historical work item", "ordering": ("-history_date", "-history_id"), "get_latest_by": "history_date", }, bases=(simple_history.models.HistoricalChanges, models.Model), ), ]
class Migration(migrations.Migration): dependencies = [ migrations.swappable_dependency(settings.AUTH_USER_MODEL), ('permits', '0004_insert_workflow_status'), ] operations = [ migrations.CreateModel( name='HistoricalWorksObjectPropertyValue', fields=[ ('id', models.IntegerField(auto_created=True, blank=True, db_index=True, verbose_name='ID')), ('value', django.contrib.postgres.fields.jsonb.JSONField()), ('history_id', models.AutoField(primary_key=True, serialize=False)), ('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)), ('property', models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='permits.WorksObjectProperty', verbose_name='caractéristique')), ('works_object_type_choice', models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='permits.WorksObjectTypeChoice', verbose_name='objet des travaux')), ], options={ 'verbose_name': 'historical works object property value', 'ordering': ('-history_date', '-history_id'), 'get_latest_by': 'history_date', }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name='HistoricalPermitRequestValidation', fields=[ ('id', models.IntegerField(auto_created=True, blank=True, db_index=True, verbose_name='ID')), ('validation_status', models.IntegerField(choices=[(0, 'En attente'), (1, 'Approuvé'), (2, 'Refusé')], default=0, verbose_name='Statut de validation')), ('comment_before', models.TextField(blank=True, verbose_name='Commentaires (avant)')), ('comment_during', models.TextField(blank=True, verbose_name='Commentaires (pendant)')), ('comment_after', models.TextField(blank=True, verbose_name='Commentaires (après)')), ('validated_at', models.DateTimeField(null=True, verbose_name='Validé le')), ('history_id', models.AutoField(primary_key=True, serialize=False)), ('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)), ('department', models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='permits.PermitDepartment')), ('history_user', models.ForeignKey( null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)), ('permit_request', models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='permits.PermitRequest')), ('validated_by', models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to=settings.AUTH_USER_MODEL)), ], options={ 'verbose_name': 'historical 3.5 Consultation de la validation par le service', 'ordering': ('-history_date', '-history_id'), 'get_latest_by': 'history_date', }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name='HistoricalPermitRequestGeoTime', fields=[ ('id', models.IntegerField(auto_created=True, blank=True, db_index=True, verbose_name='ID')), ('starts_at', models.DateTimeField(verbose_name='Date planifiée de début')), ('ends_at', models.DateTimeField(verbose_name='Date planifiée de fin')), ('comment', models.CharField(blank=True, max_length=1024, verbose_name='Commentaire')), ('external_link', models.URLField(blank=True, verbose_name='Lien externe')), ('geom', django.contrib.gis.db.models.fields.GeometryCollectionField( null=True, srid=2056, verbose_name='Localisation')), ('history_id', models.AutoField(primary_key=True, serialize=False)), ('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)), ('permit_request', models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='permits.PermitRequest')), ], options={ 'verbose_name': "historical 3.3 Consultation de l'agenda et de la géométrie", 'ordering': ('-history_date', '-history_id'), 'get_latest_by': 'history_date', }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name='HistoricalPermitRequest', fields=[ ('id', models.IntegerField(auto_created=True, blank=True, db_index=True, verbose_name='ID')), ('status', models.PositiveSmallIntegerField(choices=[ (0, 'Brouillon'), (1, 'Envoyée, en attente de traitement'), (4, 'Demande de compléments'), (3, 'En traitement'), (5, 'En validation'), (2, 'Approuvée'), (6, 'Refusée'), (7, 'Annonce réceptionnée') ], default=0, verbose_name='état')), ('created_at', models.DateTimeField(default=django.utils.timezone.now, verbose_name='date de création')), ('validated_at', models.DateTimeField(null=True, verbose_name='date de validation')), ('printed_at', models.DateTimeField(null=True, verbose_name="date d'impression")), ('printed_by', models.CharField(blank=True, max_length=255, verbose_name='imprimé par')), ('printed_file', models.TextField(blank=True, max_length=100, null=True, verbose_name='Permis imprimé')), ('archeology_status', models.PositiveSmallIntegerField( choices=[(0, 'Non pertinent'), (1, 'Inconnu'), (2, 'Pas fouillé'), (3, 'Partiellement fouillé'), (4, 'Déjà fouillé')], default=0, verbose_name='Statut archéologique')), ('intersected_geometries', models.CharField( max_length=1024, null=True, verbose_name='Entités géométriques concernées')), ('price', models.DecimalField(blank=True, decimal_places=2, max_digits=7, null=True, verbose_name='Émolument')), ('exemption', models.TextField(blank=True, verbose_name='Dérogation')), ('opposition', models.TextField(blank=True, verbose_name='Opposition')), ('comment', models.TextField(blank=True, verbose_name='Analyse du service pilote')), ('validation_pdf', models.TextField( max_length=100, validators=[ django.core.validators.FileExtensionValidator( allowed_extensions=['pdf']) ], verbose_name='pdf de validation')), ('creditor_type', models.PositiveSmallIntegerField( blank=True, choices=[ (0, 'Autres'), (2, 'Propriétaire'), (3, 'Entreprise'), (4, "Maître d'ouvrage"), (1, "Requérant si différent de l'auteur de la demande"), (5, 'Sécurité'), (6, 'Association') ], null=True, verbose_name='Destinaire de la facture')), ('is_public', models.BooleanField(default=False, verbose_name='Publier')), ('history_id', models.AutoField(primary_key=True, serialize=False)), ('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)), ('administrative_entity', models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='permits.PermitAdministrativeEntity', verbose_name='commune')), ('author', models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='permits.PermitAuthor', verbose_name='auteur')), ('history_user', models.ForeignKey( null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)), ], options={ 'verbose_name': 'historical 3.1 Consultation de la demande', 'ordering': ('-history_date', '-history_id'), 'get_latest_by': 'history_date', }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name='HistoricalPermitAuthor', fields=[ ('id', models.IntegerField(auto_created=True, blank=True, db_index=True, verbose_name='ID')), ('company_name', models.CharField(blank=True, max_length=100, verbose_name='Raison Sociale')), ('vat_number', models.CharField( blank=True, max_length=19, validators=[ django.core.validators.RegexValidator( message= "Le code d'entreprise doit être de type CHE-123.456.789 (TVA) et vous pouvez le trouver sur le registe fédéral des entreprises https://www.uid.admin.ch/search.aspx", regex='^(CHE-)+\\d{3}\\.\\d{3}\\.\\d{3}(\\sTVA)?$' ) ], verbose_name='Numéro TVA')), ('address', models.CharField(max_length=100, verbose_name='Rue')), ('zipcode', models.PositiveIntegerField(validators=[ django.core.validators.MinValueValidator(1000), django.core.validators.MaxValueValidator(9999) ], verbose_name='NPA')), ('city', models.CharField(max_length=100, verbose_name='Ville')), ('phone_first', models.CharField( max_length=20, validators=[ django.core.validators.RegexValidator( message= 'Seuls les chiffres et les espaces sont autorisés.', regex= '^(((\\+41)\\s?)|(0))?(\\d{2})\\s?(\\d{3})\\s?(\\d{2})\\s?(\\d{2})$' ) ], verbose_name='Téléphone principal')), ('phone_second', models.CharField( blank=True, max_length=20, validators=[ django.core.validators.RegexValidator( message= 'Seuls les chiffres et les espaces sont autorisés.', regex= '^(((\\+41)\\s?)|(0))?(\\d{2})\\s?(\\d{3})\\s?(\\d{2})\\s?(\\d{2})$' ) ], verbose_name='Téléphone secondaire')), ('history_id', models.AutoField(primary_key=True, serialize=False)), ('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)), ('user', models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to=settings.AUTH_USER_MODEL)), ], options={ 'verbose_name': "historical 3.2 Consultation de l'auteur", 'ordering': ('-history_date', '-history_id'), 'get_latest_by': 'history_date', }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name='HistoricalPermitActor', fields=[ ('id', models.IntegerField(auto_created=True, blank=True, db_index=True, verbose_name='ID')), ('first_name', models.CharField(max_length=150, verbose_name='Prénom')), ('last_name', models.CharField(max_length=100, verbose_name='Nom')), ('company_name', models.CharField(max_length=100, verbose_name='Entreprise')), ('vat_number', models.CharField(blank=True, max_length=19, verbose_name='Numéro TVA')), ('address', models.CharField(max_length=100, verbose_name='Adresse')), ('zipcode', models.PositiveIntegerField(verbose_name='NPA')), ('city', models.CharField(max_length=100, verbose_name='Ville')), ('phone', models.CharField(max_length=20, verbose_name='Téléphone')), ('email', models.EmailField(max_length=254, verbose_name='Email')), ('history_id', models.AutoField(primary_key=True, serialize=False)), ('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)), ], options={ 'verbose_name': 'historical Contact', 'ordering': ('-history_date', '-history_id'), 'get_latest_by': 'history_date', }, bases=(simple_history.models.HistoricalChanges, models.Model), ), ]
class Migration(migrations.Migration): dependencies = [ ('catalogue', '0039_historicalproduct_historicalproductattributevalue'), migrations.swappable_dependency(settings.AUTH_USER_MODEL), ('voucher', '0006_auto_20181205_1017'), ('sites', '0002_alter_domain_unique'), ('partner', '0014_historicalstockrecord'), ('offer', '0023_offerassignmentemailattempt'), ] operations = [ migrations.CreateModel( name='HistoricalBenefit', fields=[ ('id', models.IntegerField(auto_created=True, blank=True, db_index=True, verbose_name='ID')), ('type', models.CharField( blank=True, choices= [(b'Percentage', "Discount is a percentage off of the product's value"), (b'Absolute', "Discount is a fixed amount off of the product's value" ), (b'Multibuy', 'Discount is to give the cheapest product for free'), (b'Fixed price', 'Get the products that meet the condition for a fixed price' ), (b'Shipping absolute', 'Discount is a fixed amount of the shipping cost'), (b'Shipping fixed price', 'Get shipping for a fixed price'), (b'Shipping percentage', 'Discount is a percentage off of the shipping cost')], max_length=128, verbose_name='Type')), ('value', oscar.models.fields.PositiveDecimalField( blank=True, decimal_places=2, max_digits=12, null=True, verbose_name='Value')), ('max_affected_items', models.PositiveIntegerField( blank=True, help_text= 'Set this to prevent the discount consuming all items within the range that are in the basket.', null=True, verbose_name='Max Affected Items')), ('proxy_class', oscar.models.fields.NullCharField( default=None, max_length=255, verbose_name='Custom class')), ('history_id', models.AutoField(primary_key=True, serialize=False)), ('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)), ('range', models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='offer.Range', verbose_name='Range')), ], options={ 'ordering': ('-history_date', '-history_id'), 'get_latest_by': 'history_date', 'verbose_name': 'historical Benefit', }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name='HistoricalCondition', fields=[ ('id', models.IntegerField(auto_created=True, blank=True, db_index=True, verbose_name='ID')), ('type', models.CharField( blank=True, choices= [(b'Count', 'Depends on number of items in basket that are in condition range' ), (b'Value', 'Depends on value of items in basket that are in condition range' ), (b'Coverage', 'Needs to contain a set number of DISTINCT items from the condition range' )], max_length=128, verbose_name='Type')), ('value', oscar.models.fields.PositiveDecimalField( blank=True, decimal_places=2, max_digits=12, null=True, verbose_name='Value')), ('proxy_class', oscar.models.fields.NullCharField( default=None, max_length=255, verbose_name='Custom class')), ('enterprise_customer_uuid', models.UUIDField(blank=True, null=True, verbose_name='EnterpriseCustomer UUID')), ('enterprise_customer_name', models.CharField(blank=True, max_length=255, null=True, verbose_name='EnterpriseCustomer Name')), ('enterprise_customer_catalog_uuid', models.UUIDField( blank=True, null=True, verbose_name='EnterpriseCustomerCatalog UUID')), ('program_uuid', models.UUIDField(blank=True, null=True, verbose_name='Program UUID')), ('journal_bundle_uuid', models.UUIDField(blank=True, null=True, verbose_name='JournalBundle UUID')), ('history_id', models.AutoField(primary_key=True, serialize=False)), ('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)), ('range', models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='offer.Range', verbose_name='Range')), ], options={ 'ordering': ('-history_date', '-history_id'), 'get_latest_by': 'history_date', 'verbose_name': 'historical Condition', }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name='HistoricalConditionalOffer', fields=[ ('id', models.IntegerField(auto_created=True, blank=True, db_index=True, verbose_name='ID')), ('name', models.CharField( db_index=True, help_text="This is displayed within the customer's basket", max_length=128, verbose_name='Name')), ('description', models.TextField( blank=True, help_text='This is displayed on the offer browsing page', verbose_name='Description')), ('offer_type', models.CharField(choices=[ (b'Site', 'Site offer - available to all users'), (b'Voucher', 'Voucher offer - only available after entering the appropriate voucher code' ), (b'User', 'User offer - available to certain types of user'), (b'Session', 'Session offer - temporary offer, available for a user for the duration of their session' ) ], default=b'Site', max_length=128, verbose_name='Type')), ('status', models.CharField(default=b'Open', max_length=64, verbose_name='Status')), ('priority', models.IntegerField( default=0, help_text='The highest priority offers are applied first', verbose_name='Priority')), ('start_datetime', models.DateTimeField( blank=True, help_text= 'Offers are active from the start date. Leave this empty if the offer has no start date.', null=True, verbose_name='Start date')), ('end_datetime', models.DateTimeField( blank=True, help_text= 'Offers are active until the end date. Leave this empty if the offer has no expiry date.', null=True, verbose_name='End date')), ('max_global_applications', models.PositiveIntegerField( blank=True, help_text= 'The number of times this offer can be used before it is unavailable', null=True, verbose_name='Max global applications')), ('max_user_applications', models.PositiveIntegerField( blank=True, help_text= 'The number of times a single user can use this offer', null=True, verbose_name='Max user applications')), ('max_basket_applications', models.PositiveIntegerField( blank=True, help_text= 'The number of times this offer can be applied to a basket (and order)', null=True, verbose_name='Max basket applications')), ('max_discount', models.DecimalField( blank=True, decimal_places=2, help_text= 'When an offer has given more discount to orders than this threshold, then the offer becomes unavailable', max_digits=12, null=True, verbose_name='Max discount')), ('total_discount', models.DecimalField(decimal_places=2, default=Decimal('0.00'), max_digits=12, verbose_name='Total Discount')), ('num_applications', models.PositiveIntegerField( default=0, verbose_name='Number of applications')), ('num_orders', models.PositiveIntegerField(default=0, verbose_name='Number of Orders')), ('redirect_url', oscar.models.fields.ExtendedURLField( blank=True, verbose_name='URL redirect (optional)')), ('date_created', models.DateTimeField(blank=True, editable=False, verbose_name='Date Created')), ('email_domains', models.CharField(blank=True, max_length=255, null=True)), ('history_id', models.AutoField(primary_key=True, serialize=False)), ('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)), ('benefit', models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='offer.Benefit', verbose_name='Benefit')), ('condition', models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='offer.Condition', verbose_name='Condition')), ('history_user', models.ForeignKey( null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)), ('partner', models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='partner.Partner')), ('site', models.ForeignKey( blank=True, db_constraint=False, default=None, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='sites.Site', verbose_name='Site')), ], options={ 'ordering': ('-history_date', '-history_id'), 'get_latest_by': 'history_date', 'verbose_name': 'historical Conditional offer', }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name='HistoricalOfferAssignment', fields=[ ('id', models.IntegerField(auto_created=True, blank=True, db_index=True, 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(max_length=128)), ('user_email', models.EmailField(max_length=254)), ('status', models.CharField(choices=[ (b'EMAIL_PENDING', 'Email to user pending.'), (b'ASSIGNED', 'Code successfully assigned to user.'), (b'REDEEMED', 'Code has been redeemed by user.'), (b'EMAIL_BOUNCED', 'Email to user bounced.'), (b'REVOKED', 'Code has been revoked for this user.') ], default=b'EMAIL_PENDING', max_length=255)), ('history_id', models.AutoField(primary_key=True, serialize=False)), ('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)), ('offer', models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='offer.ConditionalOffer')), ('voucher_application', models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='voucher.VoucherApplication')), ], options={ 'ordering': ('-history_date', '-history_id'), 'get_latest_by': 'history_date', 'verbose_name': 'historical offer assignment', }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name='HistoricalRange', fields=[ ('id', models.IntegerField(auto_created=True, blank=True, db_index=True, verbose_name='ID')), ('name', models.CharField(db_index=True, max_length=128, verbose_name='Name')), ('description', models.TextField(blank=True)), ('is_public', models.BooleanField( default=False, help_text='Public ranges have a customer-facing page', verbose_name='Is public?')), ('includes_all_products', models.BooleanField(default=False, verbose_name='Includes all products?')), ('proxy_class', oscar.models.fields.NullCharField( db_index=True, default=None, max_length=255, verbose_name='Custom class')), ('date_created', models.DateTimeField(blank=True, editable=False, verbose_name='Date Created')), ('catalog_query', models.TextField(blank=True, null=True)), ('course_catalog', models.PositiveIntegerField( blank=True, help_text='Course Catalog ID from the Discovery Service.', null=True)), ('enterprise_customer', models.UUIDField( blank=True, help_text= 'UUID for an EnterpriseCustomer from the Enterprise Service.', null=True)), ('enterprise_customer_catalog', models.UUIDField( blank=True, help_text= 'UUID for an EnterpriseCustomerCatalog from the Enterprise Service.', null=True)), ('course_seat_types', models.CharField(blank=True, max_length=255, null=True, validators=[ ecommerce.extensions.offer.models. validate_credit_seat_type ])), ('history_id', models.AutoField(primary_key=True, serialize=False)), ('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)), ('catalog', models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='catalogue.Catalog')), ('history_user', models.ForeignKey( null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)), ], options={ 'ordering': ('-history_date', '-history_id'), 'get_latest_by': 'history_date', 'verbose_name': 'historical Range', }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name='HistoricalRangeProduct', fields=[ ('id', models.IntegerField(auto_created=True, blank=True, db_index=True, verbose_name='ID')), ('display_order', models.IntegerField(default=0)), ('history_id', models.AutoField(primary_key=True, serialize=False)), ('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)), ('product', models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='catalogue.Product')), ('range', models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='offer.Range')), ], options={ 'ordering': ('-history_date', '-history_id'), 'get_latest_by': 'history_date', 'verbose_name': 'historical range product', }, bases=(simple_history.models.HistoricalChanges, models.Model), ), ]
class Migration(migrations.Migration): initial = True dependencies = [ migrations.swappable_dependency(settings.AUTH_USER_MODEL), ('enterprise', '0067_add_role_based_access_control_switch'), ] operations = [ migrations.CreateModel( name='CornerstoneEnterpriseCustomerConfiguration', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('created', model_utils.fields.AutoCreatedField( default=django.utils.timezone.now, editable=False, verbose_name='created')), ('modified', model_utils.fields.AutoLastModifiedField( default=django.utils.timezone.now, editable=False, verbose_name='modified')), ('active', models.BooleanField( help_text='Is this configuration active?')), ('transmission_chunk_size', models.IntegerField( default=500, help_text= 'The maximum number of data items to transmit to the integrated channel with each request.' )), ('cornerstone_base_url', models.CharField( blank=True, help_text= 'The base URL used for API requests to Cornerstone, i.e. https://portalName.csod.com', max_length=255, verbose_name='Cornerstone Base URL')), ('enterprise_customer', models.OneToOneField( help_text= 'Enterprise Customer associated with the configuration.', on_delete=django.db.models.deletion.CASCADE, to='enterprise.EnterpriseCustomer')), ], ), migrations.CreateModel( name='CornerstoneGlobalConfiguration', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('change_date', models.DateTimeField(auto_now_add=True, verbose_name='Change date')), ('enabled', models.BooleanField(default=False, verbose_name='Enabled')), ('completion_status_api_path', models.CharField( help_text= 'The API path for making completion POST requests to Cornerstone.', max_length=255, verbose_name='Completion Status API Path')), ('oauth_api_path', models.CharField( help_text= 'The API path for making OAuth-related POST requests to Cornerstone. This will be used to gain the OAuth access token which is required for other API calls.', max_length=255, verbose_name='OAuth API Path')), ('changed_by', models.ForeignKey(editable=False, null=True, on_delete=django.db.models.deletion.PROTECT, to=settings.AUTH_USER_MODEL, verbose_name='Changed by')), ], ), migrations.CreateModel( name='CornerstoneLearnerDataTransmissionAudit', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('created', model_utils.fields.AutoCreatedField( default=django.utils.timezone.now, editable=False, verbose_name='created')), ('modified', model_utils.fields.AutoLastModifiedField( default=django.utils.timezone.now, editable=False, verbose_name='modified')), ('user_guid', models.CharField(max_length=255)), ('enterprise_course_enrollment_id', models.PositiveIntegerField(blank=True, null=True)), ('course_id', models.CharField( help_text= "The course run's key which is used to uniquely identify the course for Cornerstone.", max_length=255)), ('session_token', models.CharField(max_length=255)), ('callback_url', models.CharField(max_length=255)), ('subdomain', models.CharField(max_length=255)), ('course_completed', models.BooleanField( default=False, help_text= "The learner's course completion status transmitted to Cornerstone." )), ('completed_timestamp', models.DateTimeField( blank=True, help_text='Date time when user completed course', null=True)), ('status', models.CharField(blank=True, max_length=100, null=True)), ('error_message', models.TextField(blank=True, null=True)), ('user', models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name='cornerstone_transmission_audit', to=settings.AUTH_USER_MODEL)), ], ), migrations.CreateModel( name='HistoricalCornerstoneEnterpriseCustomerConfiguration', fields=[ ('id', models.IntegerField(auto_created=True, blank=True, db_index=True, verbose_name='ID')), ('created', model_utils.fields.AutoCreatedField( default=django.utils.timezone.now, editable=False, verbose_name='created')), ('modified', model_utils.fields.AutoLastModifiedField( default=django.utils.timezone.now, editable=False, verbose_name='modified')), ('active', models.BooleanField( help_text='Is this configuration active?')), ('transmission_chunk_size', models.IntegerField( default=500, help_text= 'The maximum number of data items to transmit to the integrated channel with each request.' )), ('cornerstone_base_url', models.CharField( blank=True, help_text= 'The base URL used for API requests to Cornerstone, i.e. https://portalName.csod.com', max_length=255, verbose_name='Cornerstone Base URL')), ('history_id', models.AutoField(primary_key=True, serialize=False)), ('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)), ('enterprise_customer', models.ForeignKey( blank=True, db_constraint=False, help_text= 'Enterprise Customer associated with the configuration.', null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='enterprise.EnterpriseCustomer')), ('history_user', models.ForeignKey( null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)), ], options={ 'ordering': ('-history_date', '-history_id'), 'get_latest_by': 'history_date', 'verbose_name': 'historical cornerstone enterprise customer configuration', }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.AlterUniqueTogether( name='cornerstonelearnerdatatransmissionaudit', unique_together=set([('user', 'course_id')]), ), ]
class Migration(migrations.Migration): dependencies = [ ("metadata", "0013_barriertag"), migrations.swappable_dependency(settings.AUTH_USER_MODEL), ("barriers", "0064_auto_20200623_1522"), ] operations = [ migrations.CreateModel( name="PublicBarrier", fields=[ ( "id", models.AutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID", ), ), ( "created_on", models.DateTimeField(auto_now_add=True, db_index=True, null=True), ), ("modified_on", models.DateTimeField(auto_now=True, null=True)), ("archived", models.BooleanField(default=False)), ("archived_on", models.DateTimeField(blank=True, null=True)), ("archived_reason", models.TextField(blank=True, null=True)), ("unarchived_reason", models.TextField(blank=True, null=True)), ("unarchived_on", models.DateTimeField(blank=True, null=True)), ("title", models.CharField(max_length=255, null=True)), ("summary", models.TextField(null=True)), ( "status", models.PositiveIntegerField( choices=[ (0, "Unfinished"), (1, "Open: Pending action"), (2, "Open: In progress"), (5, "Dormant"), (6, "Archived"), (7, "Unknown"), (3, "Resolved: In part"), (4, "Resolved: In full"), ], default=0, ), ), ("country", models.UUIDField()), ( "sectors", django.contrib.postgres.fields.ArrayField( base_field=models.UUIDField(), blank=True, default=list, size=None, ), ), ( "archived_by", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="+", to=settings.AUTH_USER_MODEL, ), ), ( "barrier", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, to="barriers.BarrierInstance", ), ), ( "categories", models.ManyToManyField(related_name="public_barriers", to="metadata.Category"), ), ( "created_by", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="+", to=settings.AUTH_USER_MODEL, ), ), ( "modified_by", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="+", to=settings.AUTH_USER_MODEL, ), ), ( "unarchived_by", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="+", to=settings.AUTH_USER_MODEL, ), ), ], options={ "abstract": False, }, ), migrations.CreateModel( name="HistoricalPublicBarrier", fields=[ ( "id", models.IntegerField(auto_created=True, blank=True, db_index=True, verbose_name="ID"), ), ( "created_on", models.DateTimeField(blank=True, db_index=True, editable=False, null=True), ), ( "modified_on", models.DateTimeField(blank=True, editable=False, null=True), ), ("archived", models.BooleanField(default=False)), ("archived_on", models.DateTimeField(blank=True, null=True)), ("archived_reason", models.TextField(blank=True, null=True)), ("unarchived_reason", models.TextField(blank=True, null=True)), ("unarchived_on", models.DateTimeField(blank=True, null=True)), ("title", models.CharField(max_length=255, null=True)), ("summary", models.TextField(null=True)), ( "status", models.PositiveIntegerField( choices=[ (0, "Unfinished"), (1, "Open: Pending action"), (2, "Open: In progress"), (5, "Dormant"), (6, "Archived"), (7, "Unknown"), (3, "Resolved: In part"), (4, "Resolved: In full"), ], default=0, ), ), ("country", models.UUIDField()), ( "sectors", django.contrib.postgres.fields.ArrayField( base_field=models.UUIDField(), blank=True, default=list, size=None, ), ), ("history_id", models.AutoField(primary_key=True, serialize=False)), ("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, ), ), ( "archived_by", models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", to=settings.AUTH_USER_MODEL, ), ), ( "barrier", models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", to="barriers.BarrierInstance", ), ), ( "created_by", models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", to=settings.AUTH_USER_MODEL, ), ), ( "history_user", models.ForeignKey( null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="+", to=settings.AUTH_USER_MODEL, ), ), ( "modified_by", models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", to=settings.AUTH_USER_MODEL, ), ), ( "unarchived_by", models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", to=settings.AUTH_USER_MODEL, ), ), ], options={ "verbose_name": "historical public barrier", "ordering": ("-history_date", "-history_id"), "get_latest_by": "history_date", }, bases=(simple_history.models.HistoricalChanges, models.Model), ), ]
class Migration(migrations.Migration): dependencies = [ ("wagtailcore", "0062_comment_models_and_pagesubscription"), migrations.swappable_dependency(settings.AUTH_USER_MODEL), ("core", "0001_initial"), ] operations = [ migrations.CreateModel( name="HistoricalDocument", fields=[ ( "id", models.IntegerField(auto_created=True, blank=True, db_index=True, verbose_name="ID"), ), ("title", models.CharField(max_length=255, verbose_name="title")), ("file", models.TextField(max_length=100, verbose_name="file")), ( "created_at", models.DateTimeField(blank=True, editable=False, verbose_name="created at"), ), ("file_size", models.PositiveIntegerField(editable=False, null=True)), ( "file_hash", models.CharField(blank=True, editable=False, max_length=40), ), ("history_id", models.AutoField(primary_key=True, serialize=False)), ("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, ), ), ( "collection", models.ForeignKey( blank=True, db_constraint=False, default=wagtail.core.models.get_root_collection_id, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", to="wagtailcore.collection", verbose_name="collection", ), ), ( "history_user", models.ForeignKey( null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="+", to=settings.AUTH_USER_MODEL, ), ), ( "uploaded_by_user", models.ForeignKey( blank=True, db_constraint=False, editable=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", to=settings.AUTH_USER_MODEL, verbose_name="uploaded by user", ), ), ], options={ "verbose_name": "historical document", "ordering": ("-history_date", "-history_id"), "get_latest_by": "history_date", }, bases=(simple_history.models.HistoricalChanges, models.Model), ), ]
class Migration(migrations.Migration): dependencies = [ ('accounts', '0013_auto_20190923_2227'), ('contenttypes', '0002_remove_content_type_name'), migrations.swappable_dependency(settings.AUTH_USER_MODEL), ('aonebrains_courses', '0010_openmodule_slug'), ] operations = [ migrations.CreateModel( name='HistoricalOpenSubject', fields=[ ('id', models.IntegerField(auto_created=True, blank=True, db_index=True, verbose_name='ID')), ('title', models.CharField(max_length=200)), ('slug', models.SlugField(editable=False, max_length=200)), ('history_id', models.AutoField(primary_key=True, serialize=False)), ('history_date', models.DateTimeField()), ('history_change_reason', models.TextField(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)), ], options={ 'verbose_name': 'historical Subject', 'ordering': ('-history_date', '-history_id'), 'get_latest_by': 'history_date', }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name='HistoricalOpenModule', fields=[ ('id', models.IntegerField(auto_created=True, blank=True, db_index=True, verbose_name='ID')), ('title', models.CharField(max_length=200)), ('description', models.TextField(blank=True)), ('order', courses.fields.OrderField(blank=True)), ('slug', models.SlugField(editable=False, max_length=200, null=True)), ('history_id', models.AutoField(primary_key=True, serialize=False)), ('history_date', models.DateTimeField()), ('history_change_reason', models.TextField(null=True)), ('history_type', models.CharField(choices=[('+', 'Created'), ('~', 'Changed'), ('-', 'Deleted')], max_length=1)), ('course', models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='aonebrains_courses.OpenCourse')), ('history_user', models.ForeignKey( null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)), ], options={ 'verbose_name': 'historical Module', 'ordering': ('-history_date', '-history_id'), 'get_latest_by': 'history_date', }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name='HistoricalOpenCourse', fields=[ ('id', models.IntegerField(auto_created=True, blank=True, db_index=True, verbose_name='ID')), ('title', models.CharField(max_length=200)), ('preview', models.TextField(max_length=100, null=True)), ('slug', models.SlugField(editable=False, max_length=200)), ('overview', models.TextField()), ('created', models.DateTimeField(blank=True, editable=False)), ('history_id', models.AutoField(primary_key=True, serialize=False)), ('history_date', models.DateTimeField()), ('history_change_reason', models.TextField(null=True)), ('history_type', models.CharField(choices=[('+', 'Created'), ('~', 'Changed'), ('-', 'Deleted')], max_length=1)), ('admin', models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='accounts.SuperAdmin')), ('creator', models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='accounts.Curator')), ('grade', models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='accounts.Grade')), ('history_user', models.ForeignKey( null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)), ('subject', models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='aonebrains_courses.OpenSubject')), ], options={ 'verbose_name': 'historical Course', 'ordering': ('-history_date', '-history_id'), 'get_latest_by': 'history_date', }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name='HistoricalOpenContent', fields=[ ('id', models.IntegerField(auto_created=True, blank=True, db_index=True, verbose_name='ID')), ('object_id', models.PositiveIntegerField()), ('order', courses.fields.OrderField(blank=True)), ('history_id', models.AutoField(primary_key=True, serialize=False)), ('history_date', models.DateTimeField()), ('history_change_reason', models.TextField(null=True)), ('history_type', models.CharField(choices=[('+', 'Created'), ('~', 'Changed'), ('-', 'Deleted')], max_length=1)), ('content_type', models.ForeignKey( blank=True, db_constraint=False, limit_choices_to={ 'model__in': ('atext', 'avideo', 'aimage', 'afile') }, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='contenttypes.ContentType')), ('history_user', models.ForeignKey( null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)), ('module', models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='aonebrains_courses.OpenModule')), ], options={ 'verbose_name': 'historical Content', 'ordering': ('-history_date', '-history_id'), 'get_latest_by': 'history_date', }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name='HistoricalAVideo', fields=[ ('id', models.IntegerField(auto_created=True, blank=True, db_index=True, verbose_name='ID')), ('title', models.CharField(max_length=250)), ('created', models.DateTimeField(blank=True, editable=False)), ('updated', models.DateTimeField(blank=True, editable=False)), ('file', models.TextField(max_length=100)), ('history_id', models.AutoField(primary_key=True, serialize=False)), ('history_date', models.DateTimeField()), ('history_change_reason', models.TextField(null=True)), ('history_type', models.CharField(choices=[('+', 'Created'), ('~', 'Changed'), ('-', 'Deleted')], max_length=1)), ('creator', models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='accounts.Curator')), ('history_user', models.ForeignKey( null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)), ], options={ 'verbose_name': 'historical AVideo', 'ordering': ('-history_date', '-history_id'), 'get_latest_by': 'history_date', }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name='HistoricalAText', fields=[ ('id', models.IntegerField(auto_created=True, blank=True, db_index=True, verbose_name='ID')), ('title', models.CharField(max_length=250)), ('created', models.DateTimeField(blank=True, editable=False)), ('updated', models.DateTimeField(blank=True, editable=False)), ('content', models.TextField()), ('history_id', models.AutoField(primary_key=True, serialize=False)), ('history_date', models.DateTimeField()), ('history_change_reason', models.TextField(null=True)), ('history_type', models.CharField(choices=[('+', 'Created'), ('~', 'Changed'), ('-', 'Deleted')], max_length=1)), ('creator', models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='accounts.Curator')), ('history_user', models.ForeignKey( null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)), ], options={ 'verbose_name': 'historical AText', 'ordering': ('-history_date', '-history_id'), 'get_latest_by': 'history_date', }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name='HistoricalAImage', fields=[ ('id', models.IntegerField(auto_created=True, blank=True, db_index=True, verbose_name='ID')), ('title', models.CharField(max_length=250)), ('created', models.DateTimeField(blank=True, editable=False)), ('updated', models.DateTimeField(blank=True, editable=False)), ('file', models.TextField(max_length=100)), ('history_id', models.AutoField(primary_key=True, serialize=False)), ('history_date', models.DateTimeField()), ('history_change_reason', models.TextField(null=True)), ('history_type', models.CharField(choices=[('+', 'Created'), ('~', 'Changed'), ('-', 'Deleted')], max_length=1)), ('creator', models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='accounts.Curator')), ('history_user', models.ForeignKey( null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)), ], options={ 'verbose_name': 'historical AImage', 'ordering': ('-history_date', '-history_id'), 'get_latest_by': 'history_date', }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name='HistoricalAFile', fields=[ ('id', models.IntegerField(auto_created=True, blank=True, db_index=True, verbose_name='ID')), ('title', models.CharField(max_length=250)), ('created', models.DateTimeField(blank=True, editable=False)), ('updated', models.DateTimeField(blank=True, editable=False)), ('file', models.TextField(max_length=100)), ('history_id', models.AutoField(primary_key=True, serialize=False)), ('history_date', models.DateTimeField()), ('history_change_reason', models.TextField(null=True)), ('history_type', models.CharField(choices=[('+', 'Created'), ('~', 'Changed'), ('-', 'Deleted')], max_length=1)), ('creator', models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='accounts.Curator')), ('history_user', models.ForeignKey( null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)), ], options={ 'verbose_name': 'historical AFile', 'ordering': ('-history_date', '-history_id'), 'get_latest_by': 'history_date', }, bases=(simple_history.models.HistoricalChanges, models.Model), ), ]
class Migration(migrations.Migration): initial = True dependencies = [ migrations.swappable_dependency(settings.AUTH_USER_MODEL), ] operations = [ migrations.CreateModel( name="Kind", fields=[ ( "id", models.AutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID", ), ), ("name", models.CharField(max_length=50, unique=True)), ("lft", models.PositiveIntegerField(editable=False)), ("rght", models.PositiveIntegerField(editable=False)), ("tree_id", models.PositiveIntegerField(db_index=True, editable=False)), ("level", models.PositiveIntegerField(editable=False)), ( "parent", mptt.fields.TreeForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name="children", to="logistics.kind", ), ), ], options={ "abstract": False, }, ), migrations.CreateModel( name="Product", 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" ), ), ( "status", models.IntegerField( choices=[(0, "Inactive"), (1, "Active")], default=1, verbose_name="status", ), ), ( "activate_date", models.DateTimeField( blank=True, help_text="keep empty for an immediate activation", null=True, ), ), ( "deactivate_date", models.DateTimeField( blank=True, help_text="keep empty for indefinite activation", null=True, ), ), ( "pd_num", models.CharField( db_index=True, max_length=100, unique=True, verbose_name="상품번호" ), ), ("name", models.CharField(max_length=200, verbose_name="상품명")), ("price", models.IntegerField(default=0, verbose_name="가격")), ( "size", models.CharField( blank=True, choices=[ ("", "Null"), ("tall", "Tall"), ("grande", "Grande"), ("venti", "Venti"), ], default="", max_length=8, verbose_name="사이즈", ), ), ( "kind", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="kind_set", to="logistics.kind", verbose_name="상품종류", ), ), ], options={ "verbose_name": "상품", "verbose_name_plural": "상품 모음", "ordering": ["pd_num"], }, ), migrations.CreateModel( name="HistoricalProduct", fields=[ ( "id", models.IntegerField( auto_created=True, blank=True, db_index=True, 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" ), ), ( "status", models.IntegerField( choices=[(0, "Inactive"), (1, "Active")], default=1, verbose_name="status", ), ), ( "activate_date", models.DateTimeField( blank=True, help_text="keep empty for an immediate activation", null=True, ), ), ( "deactivate_date", models.DateTimeField( blank=True, help_text="keep empty for indefinite activation", null=True, ), ), ( "pd_num", models.CharField( db_index=True, max_length=100, verbose_name="상품번호" ), ), ("name", models.CharField(max_length=200, verbose_name="상품명")), ("price", models.IntegerField(default=0, verbose_name="가격")), ( "size", models.CharField( blank=True, choices=[ ("", "Null"), ("tall", "Tall"), ("grande", "Grande"), ("venti", "Venti"), ], default="", max_length=8, verbose_name="사이즈", ), ), ("history_change_reason", models.TextField(null=True)), ("history_id", models.AutoField(primary_key=True, serialize=False)), ("history_date", models.DateTimeField()), ( "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, ), ), ( "kind", models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", to="logistics.kind", verbose_name="상품종류", ), ), ], options={ "verbose_name": "historical 상품", "ordering": ("-history_date", "-history_id"), "get_latest_by": "history_date", }, bases=(simple_history.models.HistoricalChanges, models.Model), ), ]
class Migration(migrations.Migration): initial = True dependencies = [migrations.swappable_dependency(settings.AUTH_USER_MODEL)] operations = [ migrations.CreateModel( name="HistoricalSession", fields=[ ( "id", models.UUIDField(db_index=True, default=uuid.uuid4, editable=False), ), ("created", models.DateTimeField(blank=True, editable=False)), ("modified", models.DateTimeField(blank=True, editable=False)), ( "status", models.PositiveSmallIntegerField( choices=[ (0, "Queued"), (1, "Started"), (2, "Running"), (3, "Failed"), (4, "Stopped"), ], default=0, ), ), ( "maximum_duration", models.DurationField(default=datetime.timedelta(0, 600)), ), ("user_finished", models.BooleanField(default=False)), ( "history_id", models.AutoField(primary_key=True, serialize=False), ), ("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, ), ), ( "creator", models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", to=settings.AUTH_USER_MODEL, ), ), ( "history_user", models.ForeignKey( null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="+", to=settings.AUTH_USER_MODEL, ), ), ], options={ "verbose_name": "historical session", "ordering": ("-history_date", "-history_id"), "get_latest_by": "history_date", }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name="Session", fields=[ ( "id", models.UUIDField( default=uuid.uuid4, editable=False, primary_key=True, serialize=False, ), ), ("created", models.DateTimeField(auto_now_add=True)), ("modified", models.DateTimeField(auto_now=True)), ( "status", models.PositiveSmallIntegerField( choices=[ (0, "Queued"), (1, "Started"), (2, "Running"), (3, "Failed"), (4, "Stopped"), ], default=0, ), ), ( "maximum_duration", models.DurationField(default=datetime.timedelta(0, 600)), ), ("user_finished", models.BooleanField(default=False)), ( "creator", models.ForeignKey( null=True, on_delete=django.db.models.deletion.SET_NULL, to=settings.AUTH_USER_MODEL, ), ), ], options={"abstract": False}, ), migrations.CreateModel( name="Workstation", fields=[ ( "id", models.UUIDField( default=uuid.uuid4, editable=False, primary_key=True, serialize=False, ), ), ("created", models.DateTimeField(auto_now_add=True)), ("modified", models.DateTimeField(auto_now=True)), ( "title", models.CharField(max_length=255, verbose_name="title"), ), ( "description", models.TextField(blank=True, null=True, verbose_name="description"), ), ( "slug", django_extensions.db.fields.AutoSlugField( blank=True, editable=False, populate_from="title", verbose_name="slug", ), ), ( "logo", models.ImageField(upload_to=grandchallenge.challenges. models.get_logo_path), ), ], options={"abstract": False}, ), migrations.CreateModel( name="WorkstationImage", fields=[ ( "id", models.UUIDField( default=uuid.uuid4, editable=False, primary_key=True, serialize=False, ), ), ("created", models.DateTimeField(auto_now_add=True)), ("modified", models.DateTimeField(auto_now=True)), ( "staged_image_uuid", models.UUIDField(blank=True, editable=False, null=True), ), ( "image", models.FileField( blank=True, help_text= ".tar.gz archive of the container image produced from the command 'docker save IMAGE | gzip -c > IMAGE.tar.gz'. See https://docs.docker.com/engine/reference/commandline/save/", storage=grandchallenge.core.storage.PrivateS3Storage(), upload_to=grandchallenge.components.models. docker_image_path, validators=[ grandchallenge.core.validators.ExtensionValidator( allowed_extensions=(".tar", ".tar.gz")) ], ), ), ( "image_sha256", models.CharField(editable=False, max_length=71), ), ( "ready", models.BooleanField( default=False, editable=False, help_text="Is this image ready to be used?", ), ), ("status", models.TextField(editable=False)), ("requires_gpu", models.BooleanField(default=False)), ( "requires_gpu_memory_gb", models.PositiveIntegerField(default=4), ), ("requires_memory_gb", models.PositiveIntegerField(default=4)), ( "requires_cpu_cores", models.DecimalField(decimal_places=2, default=Decimal("1.0"), max_digits=4), ), ( "http_port", models.PositiveIntegerField( default=8080, validators=[ django.core.validators.MaxValueValidator(65535) ], ), ), ( "websocket_port", models.PositiveIntegerField( default=4114, validators=[ django.core.validators.MaxValueValidator(65535) ], ), ), ( "initial_path", models.CharField( blank=True, default="Applications/GrandChallengeViewer/index.html", max_length=256, validators=[ django.core.validators.RegexValidator( message= "This path is invalid, it must not start with a /", regex="^(?:[^/][^\\s]*)\\Z", ) ], ), ), ( "creator", models.ForeignKey( null=True, on_delete=django.db.models.deletion.SET_NULL, to=settings.AUTH_USER_MODEL, ), ), ( "workstation", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, to="workstations.Workstation", ), ), ], options={"abstract": False}, ), migrations.AddField( model_name="session", name="workstation_image", field=models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, to="workstations.WorkstationImage", ), ), migrations.AddField( model_name="historicalsession", name="workstation_image", field=models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", to="workstations.WorkstationImage", ), ), ]
class Migration(migrations.Migration): dependencies = [ ('contenttypes', '0002_remove_content_type_name'), migrations.swappable_dependency(settings.AUTH_USER_MODEL), ('courses', '0010_migrate_partner_data_to_courses'), ('catalogue', '0038_coupon_enterprise_id_attribute'), ] operations = [ migrations.CreateModel( name='HistoricalProduct', fields=[ ('id', models.IntegerField(auto_created=True, blank=True, db_index=True, verbose_name='ID')), ('structure', models.CharField(choices=[(b'standalone', 'Stand-alone product'), (b'parent', 'Parent product'), (b'child', 'Child product')], default=b'standalone', max_length=10, verbose_name='Product structure')), ('upc', oscar.models.fields.NullCharField(db_index=True, help_text='Universal Product Code (UPC) is an identifier for a product which is not specific to a particular supplier. Eg an ISBN for a book.', max_length=64, verbose_name='UPC')), ('title', models.CharField(blank=True, max_length=255, verbose_name='Title')), ('slug', models.SlugField(max_length=255, verbose_name='Slug')), ('description', models.TextField(blank=True, verbose_name='Description')), ('rating', models.FloatField(editable=False, null=True, verbose_name='Rating')), ('date_created', models.DateTimeField(blank=True, editable=False, verbose_name='Date created')), ('date_updated', models.DateTimeField(blank=True, db_index=True, editable=False, verbose_name='Date updated')), ('is_discountable', models.BooleanField(default=True, help_text='This flag indicates if this product can be used in an offer or not', verbose_name='Is discountable?')), ('expires', models.DateTimeField(blank=True, help_text='Last date/time on which this product can be purchased.', null=True)), ('history_id', models.AutoField(primary_key=True, serialize=False)), ('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)), ('course', models.ForeignKey(blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='courses.Course')), ('history_user', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)), ('parent', models.ForeignKey(blank=True, db_constraint=False, help_text="Only choose a parent product if you're creating a child product. For example if this is a size 4 of a particular t-shirt. Leave blank if this is a stand-alone product (i.e. there is only one version of this product).", null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='catalogue.Product', verbose_name='Parent product')), ('product_class', models.ForeignKey(blank=True, db_constraint=False, help_text='Choose what type of product this is', null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='catalogue.ProductClass', verbose_name='Product type')), ], options={ 'ordering': ('-history_date', '-history_id'), 'get_latest_by': 'history_date', 'verbose_name': 'historical Product', }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name='HistoricalProductAttributeValue', fields=[ ('id', models.IntegerField(auto_created=True, blank=True, db_index=True, verbose_name='ID')), ('value_text', models.TextField(blank=True, null=True, verbose_name='Text')), ('value_integer', models.IntegerField(blank=True, null=True, verbose_name='Integer')), ('value_boolean', models.NullBooleanField(verbose_name='Boolean')), ('value_float', models.FloatField(blank=True, null=True, verbose_name='Float')), ('value_richtext', models.TextField(blank=True, null=True, verbose_name='Richtext')), ('value_date', models.DateField(blank=True, null=True, verbose_name='Date')), ('value_datetime', models.DateTimeField(blank=True, null=True, verbose_name='DateTime')), ('value_file', models.TextField(blank=True, max_length=255, null=True)), ('value_image', models.TextField(blank=True, max_length=255, null=True)), ('entity_object_id', models.PositiveIntegerField(blank=True, editable=False, null=True)), ('history_id', models.AutoField(primary_key=True, serialize=False)), ('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)), ('attribute', models.ForeignKey(blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='catalogue.ProductAttribute', verbose_name='Attribute')), ('entity_content_type', models.ForeignKey(blank=True, db_constraint=False, editable=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='contenttypes.ContentType')), ('history_user', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)), ('product', models.ForeignKey(blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='catalogue.Product', verbose_name='Product')), ('value_option', models.ForeignKey(blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='catalogue.AttributeOption', verbose_name='Value option')), ], options={ 'ordering': ('-history_date', '-history_id'), 'get_latest_by': 'history_date', 'verbose_name': 'historical Product attribute value', }, bases=(simple_history.models.HistoricalChanges, models.Model), ), ]
class Migration(migrations.Migration): dependencies = [ migrations.swappable_dependency(settings.AUTH_USER_MODEL), ('adserver', '0054_add_payout_status_dates'), ] operations = [ migrations.CreateModel( name='HistoricalPublisherPayout', fields=[ ('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')), ('id', models.UUIDField(db_index=True, default=uuid.uuid4, editable=False)), ('amount', models.DecimalField(decimal_places=2, default=0, max_digits=8, verbose_name='Amount')), ('date', models.DateTimeField(verbose_name='Payout date')), ('method', models.CharField(blank=True, choices=[ ('stripe', 'Stripe (Bank transfer, debit card)'), ('paypal', 'PayPal'), ('opencollective', 'Open Collective'), ('other', 'Other') ], default=None, max_length=100, null=True)), ('note', models.TextField( blank=True, help_text='A publisher-visible note about the payout', null=True, verbose_name='Note')), ('attachment', models.TextField( blank=True, help_text= 'A publisher-visible attachment such as a receipt', max_length=255, null=True, verbose_name='Attachment')), ('start_date', models.DateField(help_text='First day of paid period', null=True, verbose_name='Start Date')), ('end_date', models.DateField(help_text='Last day of paid period', null=True, verbose_name='End Date')), ('status', models.CharField(choices=[('pending', 'Pending'), ('hold', 'On hold'), ('emailed', 'Email sent'), ('paid', 'Payment sent')], default='pending', help_text='Status of this payout', max_length=50)), ('history_id', models.AutoField(primary_key=True, serialize=False)), ('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)), ('publisher', models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='adserver.Publisher')), ], options={ 'verbose_name': 'historical publisher payout', 'ordering': ('-history_date', '-history_id'), 'get_latest_by': 'history_date', }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name='HistoricalPublisherGroup', fields=[ ('id', models.IntegerField(auto_created=True, blank=True, db_index=True, 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')), ('name', models.CharField(help_text='Visible to advertisers', max_length=200, verbose_name='Name')), ('slug', models.SlugField(max_length=200, verbose_name='Publisher group slug')), ('history_id', models.AutoField(primary_key=True, serialize=False)), ('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)), ], options={ 'verbose_name': 'historical publisher group', 'ordering': ('-history_date', '-history_id'), 'get_latest_by': 'history_date', }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name='HistoricalPublisher', fields=[ ('id', models.IntegerField(auto_created=True, blank=True, db_index=True, 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')), ('name', models.CharField(max_length=200, verbose_name='Name')), ('slug', models.SlugField(max_length=200, verbose_name='Publisher Slug')), ('revenue_share_percentage', models.FloatField( default=70.0, help_text= 'Percentage of advertising revenue shared with this publisher', validators=[ django.core.validators.MinValueValidator(0), django.core.validators.MaxValueValidator(100) ])), ('default_keywords', models.CharField( blank=True, default='', help_text= 'A CSV of default keywords for this property. Used for targeting.', max_length=250, verbose_name='Default keywords')), ('unauthed_ad_decisions', models.BooleanField( default=True, help_text= 'Whether this publisher allows unauthenticated ad decision API requests (eg. JSONP)' )), ('allow_paid_campaigns', models.BooleanField(default=False, verbose_name='Allow paid campaigns')), ('allow_affiliate_campaigns', models.BooleanField( default=False, verbose_name='Allow affiliate campaigns')), ('allow_community_campaigns', models.BooleanField( default=True, help_text= 'These are unpaid campaigns that support non-profit projects in our community. Shown only when no paid ads are available', verbose_name='Allow community campaigns')), ('allow_house_campaigns', models.BooleanField( default=True, help_text= 'These are ads for EthicalAds itself. Shown only when no paid ads are available.', verbose_name='Allow house campaigns')), ('payout_method', models.CharField(blank=True, choices=[ ('stripe', 'Stripe (Bank transfer, debit card)'), ('paypal', 'PayPal'), ('opencollective', 'Open Collective'), ('other', 'Other') ], default=None, max_length=100, null=True)), ('stripe_connected_account_id', models.CharField(blank=True, default=None, max_length=200, null=True, verbose_name='Stripe connected account ID')), ('open_collective_name', models.CharField(blank=True, default=None, max_length=200, null=True, verbose_name='Open Collective name')), ('paypal_email', models.EmailField(blank=True, default=None, max_length=254, null=True, verbose_name='PayPal email address')), ('record_views', models.BooleanField( default=False, help_text= 'Record each ad view from this publisher to the database') ), ('record_placements', models.BooleanField( default=False, help_text='Record placement impressions for this publisher' )), ('render_pixel', models.BooleanField( default=False, help_text= 'Render ethical-pixel in ad templates. This is needed for users not using the ad client.' )), ('sampled_ctr', models.FloatField( default=0.0, help_text= 'A periodically calculated CTR from a sample of ads on this publisher.' )), ('history_id', models.AutoField(primary_key=True, serialize=False)), ('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)), ], options={ 'verbose_name': 'historical publisher', 'ordering': ('-history_date', '-history_id'), 'get_latest_by': 'history_date', }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name='HistoricalFlight', fields=[ ('id', models.IntegerField(auto_created=True, blank=True, db_index=True, 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')), ('name', models.CharField(max_length=200, verbose_name='Name')), ('slug', models.SlugField(max_length=200, verbose_name='Flight Slug')), ('start_date', models.DateField( db_index=True, default=datetime.date.today, help_text='This ad will not be shown before this date', verbose_name='Start Date')), ('end_date', models.DateField( default=adserver.models.default_flight_end_date, help_text= 'The target end date for the ad (it may go after this date)', verbose_name='End Date')), ('live', models.BooleanField(default=False, verbose_name='Live')), ('priority_multiplier', models.IntegerField( default=1, help_text= "Multiplies chance of showing this flight's ads [1,1000000]", validators=[ django.core.validators.MinValueValidator(1), django.core.validators.MaxValueValidator(1000000) ], verbose_name='Priority Multiplier')), ('cpc', models.DecimalField(decimal_places=2, default=0, max_digits=5, verbose_name='Cost Per Click')), ('sold_clicks', models.PositiveIntegerField(default=0, verbose_name='Sold Clicks')), ('cpm', models.DecimalField(decimal_places=2, default=0, max_digits=5, verbose_name='Cost Per 1k Impressions')), ('sold_impressions', models.PositiveIntegerField(default=0, verbose_name='Sold Impressions')), ('targeting_parameters', jsonfield.fields.JSONField( blank=True, null=True, validators=[ adserver.validators.TargetingParametersValidator() ], verbose_name='Targeting parameters')), ('total_views', models.PositiveIntegerField( default=0, help_text='Views across all ads in this flight')), ('total_clicks', models.PositiveIntegerField( default=0, help_text='Clicks across all ads in this flight')), ('history_id', models.AutoField(primary_key=True, serialize=False)), ('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)), ('campaign', models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='adserver.Campaign')), ('history_user', models.ForeignKey( null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)), ], options={ 'verbose_name': 'historical flight', 'ordering': ('-history_date', '-history_id'), 'get_latest_by': 'history_date', }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name='HistoricalCampaign', fields=[ ('id', models.IntegerField(auto_created=True, blank=True, db_index=True, 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')), ('name', models.CharField(max_length=200, verbose_name='Name')), ('slug', models.SlugField(max_length=200, verbose_name='Campaign Slug')), ('campaign_type', models.CharField( choices=[('paid', 'Paid'), ('affiliate', 'Affiliate'), ('community', 'Community'), ('house', 'House')], default='paid', help_text= 'Most campaigns are paid but ad server admins can configure other lower priority campaign types.', max_length=20, verbose_name='Campaign Type')), ('history_id', models.AutoField(primary_key=True, serialize=False)), ('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)), ('advertiser', models.ForeignKey( blank=True, db_constraint=False, help_text='The advertiser for this campaign.', null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='adserver.Advertiser')), ('history_user', models.ForeignKey( null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)), ], options={ 'verbose_name': 'historical campaign', 'ordering': ('-history_date', '-history_id'), 'get_latest_by': 'history_date', }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name='HistoricalAdvertiser', fields=[ ('id', models.IntegerField(auto_created=True, blank=True, db_index=True, 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')), ('name', models.CharField(max_length=200, verbose_name='Name')), ('slug', models.SlugField(max_length=200, verbose_name='Advertiser Slug')), ('stripe_customer_id', models.CharField(blank=True, default=None, max_length=200, null=True, verbose_name='Stripe Customer ID')), ('history_id', models.AutoField(primary_key=True, serialize=False)), ('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)), ], options={ 'verbose_name': 'historical advertiser', 'ordering': ('-history_date', '-history_id'), 'get_latest_by': 'history_date', }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name='HistoricalAdvertisement', fields=[ ('id', models.IntegerField(auto_created=True, blank=True, db_index=True, 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')), ('name', models.CharField(max_length=200, verbose_name='Name')), ('slug', models.SlugField(max_length=200, verbose_name='Slug')), ('text', models.TextField( blank=True, help_text= 'For most ad types, the text should be less than 100 characters.', verbose_name='Text')), ('headline', models.CharField( blank=True, help_text= 'An optional headline at the beginning of the ad usually displayed in bold', max_length=200, null=True)), ('content', models.TextField( blank=True, help_text= 'For most ad types, the combined length of the headline, body, and call to action should be less than 100 characters.', null=True)), ('cta', models.CharField( blank=True, help_text= 'An optional call to action displayed at the end of the ad usually in bold', max_length=200, null=True, verbose_name='Call to action')), ('link', models.URLField( help_text= "URL of your landing page. This may contain UTM parameters so you know the traffic came from us. The publisher will be added in the 'ea-publisher' query parameter.", max_length=255, verbose_name='Link URL')), ('image', models.TextField(blank=True, help_text='Sized according to the ad type', max_length=255, null=True, verbose_name='Image')), ('live', models.BooleanField(default=False, verbose_name='Live')), ('history_id', models.AutoField(primary_key=True, serialize=False)), ('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)), ('ad_type', models.ForeignKey( blank=True, db_constraint=False, default=None, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='adserver.AdType')), ('flight', models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='adserver.Flight')), ('history_user', models.ForeignKey( null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)), ], options={ 'verbose_name': 'historical advertisement', 'ordering': ('-history_date', '-history_id'), 'get_latest_by': 'history_date', }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name='HistoricalAdType', fields=[ ('id', models.IntegerField(auto_created=True, blank=True, db_index=True, 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')), ('name', models.CharField(max_length=200, verbose_name='Name')), ('slug', models.SlugField(max_length=200, verbose_name='Slug')), ('has_image', models.BooleanField(default=True, verbose_name='Has image?')), ('image_width', models.PositiveIntegerField(blank=True, null=True)), ('image_height', models.PositiveIntegerField(blank=True, null=True)), ('has_text', models.BooleanField(default=True, verbose_name='Has text?')), ('max_text_length', models.PositiveIntegerField( blank=True, help_text='Max length does not include HTML tags', null=True)), ('allowed_html_tags', models.CharField( blank=True, default='a b strong i em code', help_text='Space separated list of allowed HTML tag names', max_length=255, verbose_name='Allowed HTML tags')), ('default_enabled', models.BooleanField( default=False, help_text= 'Whether this ad type should default to checked when advertisers are creating ads' )), ('template', models.TextField( blank=True, help_text= 'Override the template for rendering this ad type', null=True, verbose_name='Ad template')), ('description', models.CharField( blank=True, default='', help_text= 'A short description of the ad type to guide advertisers.', max_length=255)), ('order', models.PositiveSmallIntegerField(default=0)), ('deprecated', models.BooleanField( default=False, help_text= 'Users cannot select deprecated ad types unless an ad is already that type.' )), ('history_id', models.AutoField(primary_key=True, serialize=False)), ('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)), ], options={ 'verbose_name': 'historical ad type', 'ordering': ('-history_date', '-history_id'), 'get_latest_by': 'history_date', }, bases=(simple_history.models.HistoricalChanges, models.Model), ), ]
class Migration(migrations.Migration): dependencies = [ ('aonebrains_courses', '0011_historicalafile_historicalaimage_historicalatext_historicalavideo_historicalopencontent_historicalop' ), ('accounts', '0013_auto_20190923_2227'), migrations.swappable_dependency(settings.AUTH_USER_MODEL), ('aonebrains_quiz', '0004_auto_20190923_2227'), ] operations = [ migrations.CreateModel( name='HistoricalSitting', fields=[ ('id', models.IntegerField(auto_created=True, blank=True, db_index=True, verbose_name='ID')), ('question_order', models.CharField( max_length=1024, validators=[ django.core.validators.RegexValidator( re.compile('^\\d+(?:,\\d+)*\\Z'), code='invalid', message='Enter only digits separated by commas.') ], verbose_name='Question Order')), ('question_list', models.CharField( max_length=1024, validators=[ django.core.validators.RegexValidator( re.compile('^\\d+(?:,\\d+)*\\Z'), code='invalid', message='Enter only digits separated by commas.') ], verbose_name='Question List')), ('incorrect_questions', models.CharField( blank=True, max_length=1024, validators=[ django.core.validators.RegexValidator( re.compile('^\\d+(?:,\\d+)*\\Z'), code='invalid', message='Enter only digits separated by commas.') ], verbose_name='Incorrect questions')), ('current_score', models.IntegerField(verbose_name='Current Score')), ('complete', models.BooleanField(default=False, verbose_name='Complete')), ('user_answers', models.TextField(blank=True, default='{}', verbose_name='User Answers')), ('start', models.DateTimeField(blank=True, editable=False, verbose_name='Start')), ('end', models.DateTimeField(blank=True, null=True, verbose_name='End')), ('history_id', models.AutoField(primary_key=True, serialize=False)), ('history_date', models.DateTimeField()), ('history_change_reason', models.TextField(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)), ('quiz', models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='aonebrains_quiz.Quiz', verbose_name='Quiz')), ('user', models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='accounts.Student', verbose_name='Student')), ], options={ 'verbose_name': 'historical sitting', 'ordering': ('-history_date', '-history_id'), 'get_latest_by': 'history_date', }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name='HistoricalQuiz', fields=[ ('id', models.IntegerField(auto_created=True, blank=True, db_index=True, verbose_name='ID')), ('title', models.CharField(max_length=60, verbose_name='Title')), ('description', models.TextField(blank=True, help_text='a description of the quiz', verbose_name='Description')), ('slug', models.SlugField(editable=False, help_text='a user friendly url', max_length=60, verbose_name='user friendly url')), ('random_order', models.BooleanField( default=False, help_text= 'Display the questions in a random order or as they are set?', verbose_name='Random Order')), ('max_questions', models.PositiveIntegerField( blank=True, help_text= 'Number of questions to be answered on each attempt.', null=True, verbose_name='Max Questions')), ('answers_at_end', models.BooleanField( default=True, help_text= 'Correct answer is NOT shown after question. Answers displayed at the end.', verbose_name='Answers at end')), ('pass_mark', models.SmallIntegerField( blank=True, default=0, help_text='Percentage required to pass exam.', validators=[ django.core.validators.MaxValueValidator(100) ], verbose_name='Pass Mark')), ('success_text', models.TextField(blank=True, help_text='Displayed if user passes.', verbose_name='Success Text')), ('fail_text', models.TextField(blank=True, help_text='Displayed if user fails.', verbose_name='Fail Text')), ('draft', models.BooleanField( blank=True, default=False, help_text= 'If yes, the quiz is not displayed in the quiz list and can only be taken by users who can edit quizzes.', verbose_name='Draft')), ('history_id', models.AutoField(primary_key=True, serialize=False)), ('history_date', models.DateTimeField()), ('history_change_reason', models.TextField(null=True)), ('history_type', models.CharField(choices=[('+', 'Created'), ('~', 'Changed'), ('-', 'Deleted')], max_length=1)), ('course', models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='aonebrains_courses.OpenCourse', verbose_name='Course')), ('history_user', models.ForeignKey( null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)), ], options={ 'verbose_name': 'historical Quiz', 'ordering': ('-history_date', '-history_id'), 'get_latest_by': 'history_date', }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name='HistoricalProgress', fields=[ ('id', models.IntegerField(auto_created=True, blank=True, db_index=True, verbose_name='ID')), ('score', models.CharField( max_length=1024, validators=[ django.core.validators.RegexValidator( re.compile('^\\d+(?:,\\d+)*\\Z'), code='invalid', message='Enter only digits separated by commas.') ], verbose_name='Score')), ('correct_answer', models.CharField(max_length=10, verbose_name='Correct Answers')), ('wrong_answer', models.CharField(max_length=10, verbose_name='Wrong Answers')), ('history_id', models.AutoField(primary_key=True, serialize=False)), ('history_date', models.DateTimeField()), ('history_change_reason', models.TextField(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)), ('student', models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='accounts.Student', verbose_name='Student')), ], options={ 'verbose_name': 'historical Student Progress', 'ordering': ('-history_date', '-history_id'), 'get_latest_by': 'history_date', }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name='HistoricalMCQQuestion', fields=[ ('id', models.IntegerField(auto_created=True, blank=True, db_index=True, verbose_name='ID')), ('figure', models.TextField(blank=True, max_length=100, null=True, verbose_name='Figure')), ('content', models.CharField( help_text= 'Enter the question text that you want displayed', max_length=1000, null=True, verbose_name='Question')), ('explanation', models.TextField( blank=True, help_text= 'Explanation to be shown after the question has been answered.', max_length=2000, verbose_name='Explanation')), ('answer_order', models.CharField( blank=True, choices=[('content', 'Content'), ('none', 'None')], default='content', help_text= 'The order in which multichoice answer options are displayed to the user', max_length=30, null=True, verbose_name='Answer Order')), ('history_id', models.AutoField(primary_key=True, serialize=False)), ('history_date', models.DateTimeField()), ('history_change_reason', models.TextField(null=True)), ('history_type', models.CharField(choices=[('+', 'Created'), ('~', 'Changed'), ('-', 'Deleted')], max_length=1)), ('course', models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='aonebrains_courses.OpenCourse', verbose_name='Course')), ('history_user', models.ForeignKey( null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)), ('quiz', models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='aonebrains_quiz.Quiz', verbose_name='Quiz')), ], options={ 'verbose_name': 'historical Multiple Choice Question', 'ordering': ('-history_date', '-history_id'), 'get_latest_by': 'history_date', }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name='HistoricalAnswer', fields=[ ('id', models.IntegerField(auto_created=True, blank=True, db_index=True, verbose_name='ID')), ('content', models.CharField( help_text= 'Enter the answer text that you want displayed', max_length=1000, verbose_name='Content')), ('correct', models.BooleanField(default=False, help_text='Is this a correct answer?', verbose_name='Correct')), ('history_id', models.AutoField(primary_key=True, serialize=False)), ('history_date', models.DateTimeField()), ('history_change_reason', models.TextField(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)), ('question', models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='aonebrains_quiz.MCQQuestion', verbose_name='Question')), ], options={ 'verbose_name': 'historical Answer', 'ordering': ('-history_date', '-history_id'), 'get_latest_by': 'history_date', }, bases=(simple_history.models.HistoricalChanges, models.Model), ), ]
class Migration(migrations.Migration): dependencies = [ migrations.swappable_dependency(settings.AUTH_USER_MODEL), ('basket', '0011_add_email_basket_attribute_type'), ('order', '0017_order_partner'), ('core', '0051_ecommercefeatureroleassignment_enterprise_id'), ('invoice', '0006_auto_20180228_1057'), ] operations = [ migrations.CreateModel( name='HistoricalInvoice', fields=[ ('id', models.IntegerField(auto_created=True, blank=True, db_index=True, 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')), ('state', models.CharField(choices=[(b'Not Paid', 'Not Paid'), (b'Paid', 'Paid')], default=b'Not Paid', max_length=255)), ('number', models.CharField(blank=True, max_length=255, null=True)), ('type', models.CharField(blank=True, choices=[(b'Prepaid', 'Prepaid'), (b'Postpaid', 'Postpaid'), (b'Bulk purchase', 'Bulk purchase'), (b'Not applicable', 'Not applicable')], default=b'Prepaid', max_length=255, null=True)), ('payment_date', models.DateTimeField(blank=True, null=True)), ('discount_type', models.CharField(blank=True, choices=[(b'Percentage', 'Percentage'), (b'Fixed', 'Fixed')], default=b'Percentage', max_length=255, null=True)), ('discount_value', models.PositiveIntegerField(blank=True, null=True)), ('tax_deducted_source', models.PositiveIntegerField( blank=True, null=True, validators=[ django.core.validators.MinValueValidator(1), django.core.validators.MaxValueValidator(100) ])), ('history_id', models.AutoField(primary_key=True, serialize=False)), ('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)), ('basket', models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='basket.Basket')), ('business_client', models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='core.BusinessClient')), ('history_user', models.ForeignKey( null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)), ('order', models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='order.Order')), ], options={ 'ordering': ('-history_date', '-history_id'), 'get_latest_by': 'history_date', 'verbose_name': 'historical invoice', }, bases=(simple_history.models.HistoricalChanges, models.Model), ), ]
class Migration(migrations.Migration): dependencies = [ migrations.swappable_dependency(settings.AUTH_USER_MODEL), ("datasets", "0021_historicalcitycouncilattendancelist"), ] operations = [ migrations.CreateModel( name="HistoricalCityCouncilRevenue", fields=[ ( "id", models.IntegerField(auto_created=True, blank=True, db_index=True, verbose_name="ID"), ), ( "created_at", models.DateTimeField(blank=True, editable=False, verbose_name="Criado em"), ), ( "updated_at", models.DateTimeField(blank=True, editable=False, verbose_name="Atualizado em"), ), ("crawled_at", models.DateTimeField(verbose_name="Coletado em")), ("crawled_from", models.URLField(verbose_name="Fonte")), ( "notes", models.TextField(blank=True, null=True, verbose_name="Anotações"), ), ( "external_code", models.CharField(db_index=True, max_length=10, verbose_name="Código externo"), ), ( "budget_unit", models.PositiveIntegerField( default=101, verbose_name="Unidade gestora"), ), ( "published_at", models.DateField(db_index=True, null=True, verbose_name="Publicado em"), ), ( "registered_at", models.DateField(db_index=True, null=True, verbose_name="Registrado em"), ), ( "revenue_type", models.CharField( choices=[ ("orcamentaria", "Orçamentária"), ("nao_orcamentaria", "Não-orçamentária"), ("transferencia", "Transferência"), ], db_index=True, max_length=20, verbose_name="Tipo da receita", ), ), ( "modality", models.CharField(blank=True, max_length=60, null=True, verbose_name="Modalidade"), ), ("description", models.TextField(verbose_name="Descrição")), ( "value", models.DecimalField(decimal_places=2, max_digits=10, verbose_name="Valor"), ), ( "resource", models.CharField( blank=True, default="prefeitura", max_length=200, null=True, verbose_name="Fonte", ), ), ( "legal_status", models.CharField( blank=True, db_index=True, max_length=200, null=True, verbose_name="Natureza", ), ), ( "destination", models.CharField(blank=True, max_length=200, null=True, verbose_name="Destinação"), ), ( "excluded", models.BooleanField(default=False, verbose_name="Excluído?"), ), ("history_id", models.AutoField(primary_key=True, serialize=False)), ("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, ), ), ], options={ "verbose_name": "historical Câmara de Vereadores - Receita", "ordering": ("-history_date", "-history_id"), "get_latest_by": "history_date", }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name="HistoricalCityCouncilExpense", fields=[ ( "id", models.IntegerField(auto_created=True, blank=True, db_index=True, verbose_name="ID"), ), ( "created_at", models.DateTimeField(blank=True, editable=False, verbose_name="Criado em"), ), ( "updated_at", models.DateTimeField(blank=True, editable=False, verbose_name="Atualizado em"), ), ("crawled_at", models.DateTimeField(verbose_name="Coletado em")), ("crawled_from", models.URLField(verbose_name="Fonte")), ( "notes", models.TextField(blank=True, null=True, verbose_name="Anotações"), ), ( "published_at", models.DateField( blank=True, db_index=True, null=True, verbose_name="Publicado em", ), ), ( "phase", models.CharField( choices=[ ("empenho", "Empenho"), ("liquidacao", "Liquidação"), ("pagamento", "Pagamento"), ], db_index=True, max_length=20, verbose_name="Fase", ), ), ( "phase_code", models.CharField( blank=True, db_index=True, max_length=20, null=True, verbose_name="Código da fase", ), ), ( "company_or_person", models.TextField( blank=True, db_index=True, null=True, verbose_name="Empresa ou pessoa", ), ), ( "value", models.DecimalField(decimal_places=2, max_digits=10, verbose_name="Valor"), ), ( "number", models.CharField( blank=True, db_index=True, max_length=50, null=True, verbose_name="Número", ), ), ( "document", models.CharField( blank=True, db_index=True, max_length=50, null=True, verbose_name="CNPJ ou CPF", ), ), ("date", models.DateField(db_index=True, verbose_name="Data")), ( "process_number", models.CharField( blank=True, db_index=True, max_length=50, null=True, verbose_name="Número do processo", ), ), ( "summary", models.TextField(blank=True, db_index=True, null=True, verbose_name="Descrição"), ), ( "legal_status", models.CharField( blank=True, db_index=True, max_length=200, null=True, verbose_name="Natureza", ), ), ( "function", models.CharField( blank=True, db_index=True, max_length=50, null=True, verbose_name="Função", ), ), ( "subfunction", models.CharField( blank=True, db_index=True, max_length=50, null=True, verbose_name="Subfunção", ), ), ( "resource", models.CharField( blank=True, db_index=True, max_length=200, null=True, verbose_name="Fonte", ), ), ( "subgroup", models.CharField( blank=True, db_index=True, max_length=100, null=True, verbose_name="Subgrupos", ), ), ( "group", models.CharField( blank=True, db_index=True, max_length=100, null=True, verbose_name="Grupo", ), ), ( "budget_unit", models.PositiveIntegerField( default=101, verbose_name="Unidade orçamentária"), ), ( "modality", models.CharField( blank=True, choices=[ ("convenio", "Convênio"), ("tomada_de_precos", "Tomada de Preço"), ("pregao", "Pregão"), ("inexigibilidade", "Inexigibilidade"), ("convite", "Convite"), ("concorrencia", "Concorrência"), ("dispensa", "Dispensa"), ("isento", "Isento"), ], db_index=True, max_length=50, null=True, verbose_name="Modalidade", ), ), ( "excluded", models.BooleanField(default=False, verbose_name="Excluído?"), ), ( "external_file_code", models.CharField( blank=True, db_index=True, max_length=50, null=True, verbose_name="Código do arquivo (externo)", ), ), ( "external_file_line", models.CharField( blank=True, db_index=True, max_length=50, null=True, verbose_name="Linha do arquivo (externo)", ), ), ("history_id", models.AutoField(primary_key=True, serialize=False)), ("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, ), ), ], options={ "verbose_name": "historical Câmara de Vereadores - Despesa", "ordering": ("-history_date", "-history_id"), "get_latest_by": "history_date", }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name="HistoricalCityCouncilContract", fields=[ ( "id", models.IntegerField(auto_created=True, blank=True, db_index=True, verbose_name="ID"), ), ( "created_at", models.DateTimeField(blank=True, editable=False, verbose_name="Criado em"), ), ( "updated_at", models.DateTimeField(blank=True, editable=False, verbose_name="Atualizado em"), ), ("crawled_at", models.DateTimeField(verbose_name="Coletado em")), ("crawled_from", models.URLField(verbose_name="Fonte")), ( "notes", models.TextField(blank=True, null=True, verbose_name="Anotações"), ), ( "external_code", models.PositiveIntegerField(db_index=True, verbose_name="Código externo"), ), ( "description", models.TextField(blank=True, db_index=True, null=True, verbose_name="Descrição"), ), ( "details", models.TextField( blank=True, db_index=True, null=True, verbose_name="Objeto do contrato", ), ), ( "company_or_person_document", models.CharField( blank=True, db_index=True, max_length=50, null=True, verbose_name="CNPJ ou CPF", ), ), ( "company_or_person", models.TextField( blank=True, db_index=True, null=True, verbose_name="Empresa ou pessoa", ), ), ( "value", models.DecimalField(decimal_places=2, max_digits=10, verbose_name="Valor"), ), ( "start_date", models.DateField(db_index=True, verbose_name="Data de início"), ), ( "end_date", models.DateField(db_index=True, verbose_name="Data final"), ), ( "excluded", models.BooleanField(default=False, verbose_name="Excluído?"), ), ("history_id", models.AutoField(primary_key=True, serialize=False)), ("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, ), ), ], options={ "verbose_name": "historical Câmara de Vereadores - Contrato", "ordering": ("-history_date", "-history_id"), "get_latest_by": "history_date", }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name="HistoricalCityCouncilBid", fields=[ ( "id", models.IntegerField(auto_created=True, blank=True, db_index=True, verbose_name="ID"), ), ( "created_at", models.DateTimeField(blank=True, editable=False, verbose_name="Criado em"), ), ( "updated_at", models.DateTimeField(blank=True, editable=False, verbose_name="Atualizado em"), ), ("crawled_at", models.DateTimeField(verbose_name="Coletado em")), ("crawled_from", models.URLField(verbose_name="Fonte")), ( "notes", models.TextField(blank=True, null=True, verbose_name="Anotações"), ), ( "external_code", models.CharField(db_index=True, max_length=10, verbose_name="Código externo"), ), ( "modality", models.CharField( blank=True, choices=[ ("tomada_de_precos", "Tomada de Preço"), ("pregao_presencial", "Pregão Presencial"), ("pregao_eletronico", "Pregão Eletrônico"), ("leilao", "Leilão"), ("inexigibilidade", "Inexigibilidade"), ("dispensada", "Dispensada"), ("convite", "Convite"), ("concurso", "Concurso"), ("concorrencia", "Concorrência"), ("chamada_publica", "Chamada Pública"), ], db_index=True, max_length=60, null=True, verbose_name="Modalidade", ), ), ( "code", models.CharField(db_index=True, max_length=15, verbose_name="Código da licitação"), ), ( "code_type", models.CharField( db_index=True, max_length=15, verbose_name="Código do tipo da licitação", ), ), ( "description", models.TextField(db_index=True, verbose_name="Descrição (objeto)"), ), ( "session_at", models.DateTimeField(db_index=True, null=True, verbose_name="Sessão Data / Horário"), ), ( "excluded", models.BooleanField(default=False, verbose_name="Excluído?"), ), ("history_id", models.AutoField(primary_key=True, serialize=False)), ("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, ), ), ], options={ "verbose_name": "historical Câmara de Vereadores - Licitação", "ordering": ("-history_date", "-history_id"), "get_latest_by": "history_date", }, bases=(simple_history.models.HistoricalChanges, models.Model), ), ]
class Migration(migrations.Migration): dependencies = [ migrations.swappable_dependency(settings.AUTH_USER_MODEL), ('catalogue', '0039_historicalproduct_historicalproductattributevalue'), ] operations = [ migrations.CreateModel( name='HistoricalCategory', fields=[ ('id', models.IntegerField(auto_created=True, blank=True, db_index=True, verbose_name='ID')), ('path', models.CharField(db_index=True, max_length=255)), ('depth', models.PositiveIntegerField()), ('numchild', models.PositiveIntegerField(default=0)), ('name', models.CharField(db_index=True, max_length=255, verbose_name='Name')), ('description', models.TextField(blank=True, verbose_name='Description')), ('image', models.TextField(blank=True, max_length=255, null=True, verbose_name='Image')), ('history_id', models.AutoField(primary_key=True, serialize=False)), ('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)), ], options={ 'ordering': ('-history_date', '-history_id'), 'get_latest_by': 'history_date', 'verbose_name': 'historical Category', }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name='HistoricalOption', fields=[ ('id', models.IntegerField(auto_created=True, blank=True, db_index=True, verbose_name='ID')), ('name', models.CharField(max_length=128, verbose_name='Name')), ('type', models.CharField(choices=[(b'Required', 'Required - a value for this option must be specified'), (b'Optional', 'Optional - a value for this option can be omitted')], default=b'Required', max_length=128, verbose_name='Status')), ('history_id', models.AutoField(primary_key=True, serialize=False)), ('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)), ], options={ 'ordering': ('-history_date', '-history_id'), 'get_latest_by': 'history_date', 'verbose_name': 'historical Option', }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name='HistoricalProductAttribute', fields=[ ('id', models.IntegerField(auto_created=True, blank=True, db_index=True, verbose_name='ID')), ('name', models.CharField(max_length=128, verbose_name='Name')), ('code', models.SlugField(max_length=128, validators=[django.core.validators.RegexValidator(message="Code can only contain the letters a-z, A-Z, digits, and underscores, and can't start with a digit.", regex=b'^[a-zA-Z_][0-9a-zA-Z_]*$'), oscar.core.validators.non_python_keyword], verbose_name='Code')), ('type', models.CharField(choices=[(b'text', 'Text'), (b'integer', 'Integer'), (b'boolean', 'True / False'), (b'float', 'Float'), (b'richtext', 'Rich Text'), (b'date', 'Date'), (b'datetime', b'Datetime'), (b'option', 'Option'), (b'multi_option', 'Multi Option'), (b'entity', 'Entity'), (b'file', 'File'), (b'image', 'Image')], default=b'text', max_length=20, verbose_name='Type')), ('required', models.BooleanField(default=False, verbose_name='Required')), ('history_id', models.AutoField(primary_key=True, serialize=False)), ('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)), ('option_group', models.ForeignKey(blank=True, db_constraint=False, help_text='Select an option group if using type "Option" or "Multi Option"', null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='catalogue.AttributeOptionGroup', verbose_name='Option Group')), ('product_class', models.ForeignKey(blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='catalogue.ProductClass', verbose_name='Product type')), ], options={ 'ordering': ('-history_date', '-history_id'), 'get_latest_by': 'history_date', 'verbose_name': 'historical Product attribute', }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name='HistoricalProductCategory', fields=[ ('id', models.IntegerField(auto_created=True, blank=True, db_index=True, verbose_name='ID')), ('history_id', models.AutoField(primary_key=True, serialize=False)), ('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)), ('category', models.ForeignKey(blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='catalogue.Category', verbose_name='Category')), ('history_user', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)), ('product', models.ForeignKey(blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='catalogue.Product', verbose_name='Product')), ], options={ 'ordering': ('-history_date', '-history_id'), 'get_latest_by': 'history_date', 'verbose_name': 'historical Product category', }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name='HistoricalProductClass', fields=[ ('id', models.IntegerField(auto_created=True, blank=True, db_index=True, verbose_name='ID')), ('name', models.CharField(max_length=128, verbose_name='Name')), ('requires_shipping', models.BooleanField(default=True, verbose_name='Requires shipping?')), ('track_stock', models.BooleanField(default=True, verbose_name='Track stock levels?')), ('history_id', models.AutoField(primary_key=True, serialize=False)), ('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)), ], options={ 'ordering': ('-history_date', '-history_id'), 'get_latest_by': 'history_date', 'verbose_name': 'historical Product class', }, bases=(simple_history.models.HistoricalChanges, models.Model), ), ]
class Migration(migrations.Migration): dependencies = [ ('catalogue', '0039_historicalproduct_historicalproductattributevalue'), migrations.swappable_dependency(settings.AUTH_USER_MODEL), ('basket', '0011_add_email_basket_attribute_type'), ('sites', '0002_alter_domain_unique'), ('partner', '0014_historicalstockrecord'), ('order', '0017_order_partner'), ] operations = [ migrations.CreateModel( name='HistoricalLine', fields=[ ('id', models.IntegerField(auto_created=True, blank=True, db_index=True, verbose_name='ID')), ('partner_name', models.CharField(blank=True, max_length=128, verbose_name='Partner name')), ('partner_sku', models.CharField(max_length=128, verbose_name='Partner SKU')), ('partner_line_reference', models.CharField( blank=True, help_text= 'This is the item number that the partner uses within their system', max_length=128, verbose_name='Partner reference')), ('partner_line_notes', models.TextField(blank=True, verbose_name='Partner Notes')), ('title', models.CharField(max_length=255, verbose_name='Title')), ('upc', models.CharField(blank=True, max_length=128, null=True, verbose_name='UPC')), ('quantity', models.PositiveIntegerField(default=1, verbose_name='Quantity')), ('line_price_incl_tax', models.DecimalField(decimal_places=2, max_digits=12, verbose_name='Price (inc. tax)')), ('line_price_excl_tax', models.DecimalField(decimal_places=2, max_digits=12, verbose_name='Price (excl. tax)')), ('line_price_before_discounts_incl_tax', models.DecimalField( decimal_places=2, max_digits=12, verbose_name='Price before discounts (inc. tax)')), ('line_price_before_discounts_excl_tax', models.DecimalField( decimal_places=2, max_digits=12, verbose_name='Price before discounts (excl. tax)')), ('unit_cost_price', models.DecimalField(blank=True, decimal_places=2, max_digits=12, null=True, verbose_name='Unit Cost Price')), ('unit_price_incl_tax', models.DecimalField(blank=True, decimal_places=2, max_digits=12, null=True, verbose_name='Unit Price (inc. tax)')), ('unit_price_excl_tax', models.DecimalField(blank=True, decimal_places=2, max_digits=12, null=True, verbose_name='Unit Price (excl. tax)')), ('unit_retail_price', models.DecimalField(blank=True, decimal_places=2, max_digits=12, null=True, verbose_name='Unit Retail Price')), ('status', models.CharField(blank=True, max_length=255, verbose_name='Status')), ('est_dispatch_date', models.DateField(blank=True, null=True, verbose_name='Estimated Dispatch Date')), ('history_id', models.AutoField(primary_key=True, serialize=False)), ('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)), ('order', models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='order.Order', verbose_name='Order')), ('partner', models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='partner.Partner', verbose_name='Partner')), ('product', models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='catalogue.Product', verbose_name='Product')), ('stockrecord', models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='partner.StockRecord', verbose_name='Stock record')), ], options={ 'ordering': ('-history_date', '-history_id'), 'get_latest_by': 'history_date', 'verbose_name': 'historical Order Line', }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name='HistoricalOrder', fields=[ ('id', models.IntegerField(auto_created=True, blank=True, db_index=True, verbose_name='ID')), ('number', models.CharField(db_index=True, max_length=128, verbose_name='Order number')), ('currency', models.CharField( default=oscar.core.utils.get_default_currency, max_length=12, verbose_name='Currency')), ('total_incl_tax', models.DecimalField(decimal_places=2, max_digits=12, verbose_name='Order total (inc. tax)')), ('total_excl_tax', models.DecimalField(decimal_places=2, max_digits=12, verbose_name='Order total (excl. tax)')), ('shipping_incl_tax', models.DecimalField( decimal_places=2, default=0, max_digits=12, verbose_name='Shipping charge (inc. tax)')), ('shipping_excl_tax', models.DecimalField( decimal_places=2, default=0, max_digits=12, verbose_name='Shipping charge (excl. tax)')), ('shipping_method', models.CharField(blank=True, max_length=128, verbose_name='Shipping method')), ('shipping_code', models.CharField(blank=True, default=b'', max_length=128)), ('status', models.CharField(blank=True, max_length=100, verbose_name='Status')), ('guest_email', models.EmailField(blank=True, max_length=254, verbose_name='Guest email address')), ('date_placed', models.DateTimeField(db_index=True)), ('history_id', models.AutoField(primary_key=True, serialize=False)), ('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)), ('basket', models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='basket.Basket', verbose_name='Basket')), ('billing_address', models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='order.BillingAddress', verbose_name='Billing Address')), ('history_user', models.ForeignKey( null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)), ('partner', models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='partner.Partner')), ('shipping_address', models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='order.ShippingAddress', verbose_name='Shipping Address')), ('site', models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='sites.Site', verbose_name='Site')), ('user', models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to=settings.AUTH_USER_MODEL, verbose_name='User')), ], options={ 'ordering': ('-history_date', '-history_id'), 'get_latest_by': 'history_date', 'verbose_name': 'historical Order', }, bases=(simple_history.models.HistoricalChanges, models.Model), ), ]
class Migration(migrations.Migration): dependencies = [("caluma_form", "0019_remove_answer_value_document")] operations = [ migrations.CreateModel( name="HistoricalAnswer", fields=[ ("created_at", models.DateTimeField(blank=True, editable=False)), ("modified_at", models.DateTimeField(blank=True, editable=False)), ( "created_by_user", models.CharField(blank=True, max_length=150, null=True), ), ( "created_by_group", models.CharField( blank=True, db_index=True, max_length=150, null=True ), ), ("history_user_id", models.CharField(max_length=150, null=True)), ( "id", models.UUIDField(db_index=True, default=uuid.uuid4, editable=False), ), ( "value", django.contrib.postgres.fields.jsonb.JSONField( blank=True, null=True ), ), ("meta", django.contrib.postgres.fields.jsonb.JSONField(default=dict)), ("date", models.DateField(blank=True, null=True)), ( "history_id", models.UUIDField( default=uuid.uuid4, editable=False, primary_key=True, serialize=False, ), ), ("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, ), ), ( "document", models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", to="caluma_form.Document", ), ), ( "file", models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", to="caluma_form.File", ), ), ( "question", models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", to="caluma_form.Question", ), ), ], options={ "verbose_name": "historical answer", "ordering": ("-history_date", "-history_id"), "get_latest_by": "history_date", }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name="HistoricalAnswerDocument", fields=[ ("created_at", models.DateTimeField(blank=True, editable=False)), ("modified_at", models.DateTimeField(blank=True, editable=False)), ( "created_by_user", models.CharField(blank=True, max_length=150, null=True), ), ( "created_by_group", models.CharField( blank=True, db_index=True, max_length=150, null=True ), ), ("history_user_id", models.CharField(max_length=150, null=True)), ( "id", models.UUIDField(db_index=True, default=uuid.uuid4, editable=False), ), ( "sort", models.PositiveIntegerField( db_index=True, default=0, editable=False ), ), ( "history_id", models.UUIDField( default=uuid.uuid4, editable=False, primary_key=True, serialize=False, ), ), ("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, ), ), ( "answer", models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", to="caluma_form.Answer", ), ), ( "document", models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", to="caluma_form.Document", ), ), ], options={ "verbose_name": "historical answer document", "ordering": ("-history_date", "-history_id"), "get_latest_by": "history_date", }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name="HistoricalDocument", fields=[ ("created_at", models.DateTimeField(blank=True, editable=False)), ("modified_at", models.DateTimeField(blank=True, editable=False)), ( "created_by_user", models.CharField(blank=True, max_length=150, null=True), ), ( "created_by_group", models.CharField( blank=True, db_index=True, max_length=150, null=True ), ), ("history_user_id", models.CharField(max_length=150, null=True)), ( "id", models.UUIDField(db_index=True, default=uuid.uuid4, editable=False), ), ( "family", models.UUIDField( db_index=True, help_text="Family id which document belongs too." ), ), ("meta", django.contrib.postgres.fields.jsonb.JSONField(default=dict)), ( "history_id", models.UUIDField( default=uuid.uuid4, editable=False, primary_key=True, serialize=False, ), ), ("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, ), ), ( "form", models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", to="caluma_form.Form", ), ), ], options={ "verbose_name": "historical document", "ordering": ("-history_date", "-history_id"), "get_latest_by": "history_date", }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name="HistoricalFile", fields=[ ("created_at", models.DateTimeField(blank=True, editable=False)), ("modified_at", models.DateTimeField(blank=True, editable=False)), ( "created_by_user", models.CharField(blank=True, max_length=150, null=True), ), ( "created_by_group", models.CharField( blank=True, db_index=True, max_length=150, null=True ), ), ("history_user_id", models.CharField(max_length=150, null=True)), ( "id", models.UUIDField(db_index=True, default=uuid.uuid4, editable=False), ), ("name", models.CharField(max_length=255)), ( "history_id", models.UUIDField( default=uuid.uuid4, editable=False, primary_key=True, serialize=False, ), ), ("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, ), ), ], options={ "verbose_name": "historical file", "ordering": ("-history_date", "-history_id"), "get_latest_by": "history_date", }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name="HistoricalForm", fields=[ ("created_at", models.DateTimeField(blank=True, editable=False)), ("modified_at", models.DateTimeField(blank=True, editable=False)), ( "created_by_user", models.CharField(blank=True, max_length=150, null=True), ), ( "created_by_group", models.CharField( blank=True, db_index=True, max_length=150, null=True ), ), ("history_user_id", models.CharField(max_length=150, null=True)), ("slug", models.SlugField()), ("name", localized_fields.fields.field.LocalizedField(required=[])), ( "description", localized_fields.fields.field.LocalizedField( blank=True, null=True, required=[] ), ), ("meta", django.contrib.postgres.fields.jsonb.JSONField(default=dict)), ("is_published", models.BooleanField(default=False)), ("is_archived", models.BooleanField(default=False)), ( "history_id", models.UUIDField( default=uuid.uuid4, editable=False, primary_key=True, serialize=False, ), ), ("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, ), ), ( "source", models.ForeignKey( blank=True, db_constraint=False, help_text="Reference this form has been copied from", null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", to="caluma_form.Form", ), ), ], options={ "verbose_name": "historical form", "ordering": ("-history_date", "-history_id"), "get_latest_by": "history_date", }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name="HistoricalFormQuestion", fields=[ ("created_at", models.DateTimeField(blank=True, editable=False)), ("modified_at", models.DateTimeField(blank=True, editable=False)), ( "created_by_user", models.CharField(blank=True, max_length=150, null=True), ), ( "created_by_group", models.CharField( blank=True, db_index=True, max_length=150, null=True ), ), ("history_user_id", models.CharField(max_length=150, null=True)), ( "id", models.UUIDField(db_index=True, default=uuid.uuid4, editable=False), ), ( "sort", models.PositiveIntegerField( db_index=True, default=0, editable=False ), ), ( "history_id", models.UUIDField( default=uuid.uuid4, editable=False, primary_key=True, serialize=False, ), ), ("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, ), ), ( "form", models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", to="caluma_form.Form", ), ), ( "question", models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", to="caluma_form.Question", ), ), ], options={ "verbose_name": "historical form question", "ordering": ("-history_date", "-history_id"), "get_latest_by": "history_date", }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name="HistoricalOption", fields=[ ("created_at", models.DateTimeField(blank=True, editable=False)), ("modified_at", models.DateTimeField(blank=True, editable=False)), ( "created_by_user", models.CharField(blank=True, max_length=150, null=True), ), ( "created_by_group", models.CharField( blank=True, db_index=True, max_length=150, null=True ), ), ("history_user_id", models.CharField(max_length=150, null=True)), ("slug", models.SlugField()), ("label", localized_fields.fields.field.LocalizedField(required=[])), ("meta", django.contrib.postgres.fields.jsonb.JSONField(default=dict)), ( "history_id", models.UUIDField( default=uuid.uuid4, editable=False, primary_key=True, serialize=False, ), ), ("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, ), ), ( "source", models.ForeignKey( blank=True, db_constraint=False, help_text="Reference this option has been copied from", null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", to="caluma_form.Option", ), ), ], options={ "verbose_name": "historical option", "ordering": ("-history_date", "-history_id"), "get_latest_by": "history_date", }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name="HistoricalQuestion", fields=[ ("created_at", models.DateTimeField(blank=True, editable=False)), ("modified_at", models.DateTimeField(blank=True, editable=False)), ( "created_by_user", models.CharField(blank=True, max_length=150, null=True), ), ( "created_by_group", models.CharField( blank=True, db_index=True, max_length=150, null=True ), ), ("history_user_id", models.CharField(max_length=150, null=True)), ("slug", models.SlugField()), ("label", localized_fields.fields.field.LocalizedField(required=[])), ( "type", models.CharField( choices=[ ("multiple_choice", "multiple_choice"), ("integer", "integer"), ("float", "float"), ("date", "date"), ("choice", "choice"), ("textarea", "textarea"), ("text", "text"), ("table", "table"), ("form", "form"), ("file", "file"), ("dynamic_choice", "dynamic_choice"), ("dynamic_multiple_choice", "dynamic_multiple_choice"), ("static", "static"), ], max_length=23, ), ), ("is_required", models.TextField(default="false")), ("is_hidden", models.TextField(default="false")), ("is_archived", models.BooleanField(default=False)), ( "placeholder", localized_fields.fields.field.LocalizedField( blank=True, null=True, required=[] ), ), ( "info_text", localized_fields.fields.field.LocalizedField( blank=True, null=True, required=[] ), ), ( "static_content", localized_fields.fields.text_field.LocalizedTextField( blank=True, null=True, required=[] ), ), ( "configuration", django.contrib.postgres.fields.jsonb.JSONField(default=dict), ), ("meta", django.contrib.postgres.fields.jsonb.JSONField(default=dict)), ( "data_source", models.CharField(blank=True, max_length=255, null=True), ), ( "format_validators", django.contrib.postgres.fields.ArrayField( base_field=models.CharField(max_length=255), blank=True, default=list, size=None, ), ), ( "history_id", models.UUIDField( default=uuid.uuid4, editable=False, primary_key=True, serialize=False, ), ), ("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, ), ), ( "row_form", models.ForeignKey( blank=True, db_constraint=False, help_text="Form that represents rows of a TableQuestion", null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", to="caluma_form.Form", ), ), ( "source", models.ForeignKey( blank=True, db_constraint=False, help_text="Reference this question has been copied from", null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", to="caluma_form.Question", ), ), ( "sub_form", models.ForeignKey( blank=True, db_constraint=False, help_text="Form referenced in a FormQuestion", null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", to="caluma_form.Form", ), ), ], options={ "verbose_name": "historical question", "ordering": ("-history_date", "-history_id"), "get_latest_by": "history_date", }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name="HistoricalQuestionOption", fields=[ ("created_at", models.DateTimeField(blank=True, editable=False)), ("modified_at", models.DateTimeField(blank=True, editable=False)), ( "created_by_user", models.CharField(blank=True, max_length=150, null=True), ), ( "created_by_group", models.CharField( blank=True, db_index=True, max_length=150, null=True ), ), ("history_user_id", models.CharField(max_length=150, null=True)), ("id", models.CharField(db_index=True, max_length=255)), ( "sort", models.PositiveIntegerField( db_index=True, default=0, editable=False ), ), ( "history_id", models.UUIDField( default=uuid.uuid4, editable=False, primary_key=True, serialize=False, ), ), ("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, ), ), ( "option", models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", to="caluma_form.Option", ), ), ( "question", models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", to="caluma_form.Question", ), ), ], options={ "verbose_name": "historical question option", "ordering": ("-history_date", "-history_id"), "get_latest_by": "history_date", }, bases=(simple_history.models.HistoricalChanges, models.Model), ), ]
class Migration(migrations.Migration): dependencies = [ ("metadata", "0006_auto_20180903_1349"), migrations.swappable_dependency(settings.AUTH_USER_MODEL), ("barriers", "0010_auto_20180912_1831"), ] operations = [ migrations.CreateModel( name="HistoricalBarrierCompany", fields=[ ( "id", models.IntegerField(auto_created=True, blank=True, db_index=True, verbose_name="ID"), ), ( "created_on", models.DateTimeField(blank=True, db_index=True, editable=False, null=True), ), ( "modified_on", models.DateTimeField(blank=True, editable=False, null=True), ), ("history_id", models.AutoField(primary_key=True, serialize=False)), ("history_change_reason", models.CharField(max_length=100, null=True)), ("history_date", models.DateTimeField()), ( "history_type", models.CharField( choices=[("+", "Created"), ("~", "Changed"), ("-", "Deleted")], max_length=1, ), ), ( "barrier", models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", to="barriers.BarrierInstance", ), ), ( "company", models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", to="barriers.DatahubCompany", ), ), ( "created_by", models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", to=settings.AUTH_USER_MODEL, ), ), ( "history_user", models.ForeignKey( null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="+", to=settings.AUTH_USER_MODEL, ), ), ( "modified_by", models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", to=settings.AUTH_USER_MODEL, ), ), ], options={ "verbose_name": "historical barrier company", "ordering": ("-history_date", "-history_id"), "get_latest_by": "history_date", }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name="HistoricalBarrierContributor", fields=[ ( "id", models.IntegerField(auto_created=True, blank=True, db_index=True, verbose_name="ID"), ), ( "created_on", models.DateTimeField(blank=True, db_index=True, editable=False, null=True), ), ( "modified_on", models.DateTimeField(blank=True, editable=False, null=True), ), ( "kind", models.CharField( choices=[ ("INITIATOR", "Initiator"), ("CONTRIBUTOR", "Contributor"), ("LEAD", "Lead"), ], max_length=25, ), ), ("is_active", models.BooleanField(default=True)), ("history_id", models.AutoField(primary_key=True, serialize=False)), ("history_change_reason", models.CharField(max_length=100, null=True)), ("history_date", models.DateTimeField()), ( "history_type", models.CharField( choices=[("+", "Created"), ("~", "Changed"), ("-", "Deleted")], max_length=1, ), ), ( "barrier", models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", to="barriers.BarrierInstance", ), ), ( "contributor", models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", to=settings.AUTH_USER_MODEL, ), ), ( "created_by", models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", to=settings.AUTH_USER_MODEL, ), ), ( "history_user", models.ForeignKey( null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="+", to=settings.AUTH_USER_MODEL, ), ), ( "modified_by", models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", to=settings.AUTH_USER_MODEL, ), ), ], options={ "verbose_name": "historical barrier contributor", "ordering": ("-history_date", "-history_id"), "get_latest_by": "history_date", }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name="HistoricalBarrierInstance", fields=[ ( "created_on", models.DateTimeField(blank=True, db_index=True, editable=False, null=True), ), ( "modified_on", models.DateTimeField(blank=True, editable=False, null=True), ), ("id", models.UUIDField(db_index=True, default=uuid.uuid4)), ( "problem_status", models.PositiveIntegerField( choices=[ (1, "On the border"), (2, "Long term strategic barrier"), ], null=True, ), ), ("is_resolved", models.NullBooleanField()), ("resolved_date", models.DateField(default=None, null=True)), ("export_country", models.UUIDField(null=True)), ("sectors_affected", models.NullBooleanField()), ( "sectors", django.contrib.postgres.fields.ArrayField( base_field=models.UUIDField(), blank=True, default=None, null=True, size=None, ), ), ("product", models.CharField(max_length=255, null=True)), ( "source", models.CharField( choices=[ ("COMPANY", "Company"), ("TRADE", "Trade Association"), ("GOVT", "Government Lead"), ("OTHER", "Other"), ], help_text="chance of success", max_length=25, null=True, ), ), ("other_source", models.CharField(max_length=255, null=True)), ("barrier_title", models.CharField(max_length=255, null=True)), ("problem_description", models.TextField(null=True)), ( "reported_on", models.DateTimeField(blank=True, db_index=True, editable=False), ), ( "status", models.PositiveIntegerField( choices=[ (0, "Unfinished"), (1, "Screening"), (2, "Open"), (3, "Rejected"), (4, "Resolved"), (5, "Hibernated"), (6, "Archived"), ], default=0, help_text="status of the barrier instance", ), ), ( "status_summary", models.TextField( default=None, help_text="status summary if provided by user", null=True, ), ), ( "status_date", models.DateTimeField( blank=True, editable=False, help_text="date when status action occurred", null=True, ), ), ( "has_legal_infringement", models.PositiveIntegerField( choices=[(1, "Yes"), (2, "No"), (3, "Don't know")], default=None, help_text="Legal obligations infringed", null=True, ), ), ( "wto_infringement", models.NullBooleanField( default=None, help_text="Legal obligations infringed"), ), ( "fta_infringement", models.NullBooleanField( default=None, help_text="Legal obligations infringed"), ), ( "other_infringement", models.NullBooleanField( default=None, help_text="Legal obligations infringed"), ), ( "infringement_summary", models.TextField(default=None, help_text="Summary of infringments", null=True), ), ( "political_sensitivities", models.TextField( default=None, help_text="Political sensitivities to be aware of", null=True, ), ), ( "commercial_sensitivities", models.TextField( default=None, help_text= "Commercial or confidentiality sensitivities to be aware of", null=True, ), ), ("history_id", models.AutoField(primary_key=True, serialize=False)), ("history_change_reason", models.CharField(max_length=100, null=True)), ("history_date", models.DateTimeField()), ( "history_type", models.CharField( choices=[("+", "Created"), ("~", "Changed"), ("-", "Deleted")], max_length=1, ), ), ( "barrier_type", models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", to="metadata.BarrierType", ), ), ( "created_by", models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", to=settings.AUTH_USER_MODEL, ), ), ( "history_user", models.ForeignKey( null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="+", to=settings.AUTH_USER_MODEL, ), ), ( "modified_by", models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", to=settings.AUTH_USER_MODEL, ), ), ], options={ "verbose_name": "historical barrier instance", "ordering": ("-history_date", "-history_id"), "get_latest_by": "history_date", }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name="HistoricalBarrierInteraction", fields=[ ( "id", models.IntegerField(auto_created=True, blank=True, db_index=True, verbose_name="ID"), ), ( "created_on", models.DateTimeField(blank=True, db_index=True, editable=False, null=True), ), ( "modified_on", models.DateTimeField(blank=True, editable=False, null=True), ), ( "kind", models.CharField(choices=[("COMMENT", "Comment")], max_length=25), ), ("text", models.TextField(null=True)), ("pinned", models.BooleanField(default=False)), ("is_active", models.BooleanField(default=True)), ("history_id", models.AutoField(primary_key=True, serialize=False)), ("history_change_reason", models.CharField(max_length=100, null=True)), ("history_date", models.DateTimeField()), ( "history_type", models.CharField( choices=[("+", "Created"), ("~", "Changed"), ("-", "Deleted")], max_length=1, ), ), ( "barrier", models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", to="barriers.BarrierInstance", ), ), ( "created_by", models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", to=settings.AUTH_USER_MODEL, ), ), ( "history_user", models.ForeignKey( null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="+", to=settings.AUTH_USER_MODEL, ), ), ( "modified_by", models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", to=settings.AUTH_USER_MODEL, ), ), ], options={ "verbose_name": "historical barrier interaction", "ordering": ("-history_date", "-history_id"), "get_latest_by": "history_date", }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name="HistoricalBarrierReportStage", fields=[ ( "id", models.IntegerField(auto_created=True, blank=True, db_index=True, verbose_name="ID"), ), ( "created_on", models.DateTimeField(blank=True, db_index=True, editable=False, null=True), ), ( "modified_on", models.DateTimeField(blank=True, editable=False, null=True), ), ( "status", models.PositiveIntegerField( choices=[ (1, "NOT STARTED"), (2, "IN PROGRESS"), (3, "COMPLETED"), ], null=True, ), ), ("history_id", models.AutoField(primary_key=True, serialize=False)), ("history_change_reason", models.CharField(max_length=100, null=True)), ("history_date", models.DateTimeField()), ( "history_type", models.CharField( choices=[("+", "Created"), ("~", "Changed"), ("-", "Deleted")], max_length=1, ), ), ( "barrier", models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", to="barriers.BarrierInstance", ), ), ( "created_by", models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", to=settings.AUTH_USER_MODEL, ), ), ( "history_user", models.ForeignKey( null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="+", to=settings.AUTH_USER_MODEL, ), ), ( "modified_by", models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", to=settings.AUTH_USER_MODEL, ), ), ( "stage", models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", to="barriers.Stage", ), ), ], options={ "verbose_name": "historical barrier report stage", "ordering": ("-history_date", "-history_id"), "get_latest_by": "history_date", }, bases=(simple_history.models.HistoricalChanges, models.Model), ), ]