class Migration(migrations.Migration):
dependencies = [
('adserver_auth', '0003_allow-blank'),
]
operations = [
migrations.CreateModel(
name='HistoricalUser',
fields=[
('id', models.IntegerField(auto_created=True, blank=True, db_index=True, verbose_name='ID')),
('password', models.CharField(max_length=128, verbose_name='password')),
('last_login', models.DateTimeField(blank=True, null=True, verbose_name='last login')),
('is_superuser', models.BooleanField(default=False, help_text='Designates that this user has all permissions without explicitly assigning them.', verbose_name='superuser status')),
('email', models.EmailField(db_index=True, max_length=254, null=True)),
('name', models.CharField(blank=True, default='', max_length=255, verbose_name='name')),
('is_staff', models.BooleanField(default=False, help_text='Is the user allowed to have access to the admin', verbose_name='staff status')),
('is_active', models.BooleanField(default=True, help_text='Designates whether this user should be treated as active. Unselect this instead of deleting accounts.', verbose_name='active')),
('updated_date', models.DateTimeField(blank=True, editable=False, verbose_name='update date')),
('created_date', models.DateTimeField(blank=True, editable=False, verbose_name='create 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)),
],
options={
'verbose_name': 'historical user',
'ordering': ('-history_date', '-history_id'),
'get_latest_by': 'history_date',
},
bases=(simple_history.models.HistoricalChanges, models.Model),
),
]
class Migration(migrations.Migration):
dependencies = [
('course_overviews', '0014_courseoverview_certificate_available_date'),
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
('student', '0020_auto_20190227_2019'),
]
operations = [
migrations.CreateModel(
name='HistoricalCourseEnrollment',
fields=[
('id', models.IntegerField(auto_created=True, blank=True, db_index=True, verbose_name='ID')),
('created', models.DateTimeField(blank=True, db_index=True, editable=False, null=True)),
('is_active', models.BooleanField(default=True)),
('mode', models.CharField(default=u'audit', max_length=100)),
('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)),
('course', models.ForeignKey(blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='course_overviews.CourseOverview')),
('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={
'ordering': ('-history_date', '-history_id'),
'db_table': 'student_courseenrollment_history',
'verbose_name': 'historical course enrollment',
'get_latest_by': 'history_date',
},
bases=(simple_history.models.HistoricalChanges, models.Model),
),
]
class Migration(migrations.Migration):
dependencies = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
('sites', '0002_alter_domain_unique'),
('partner', '0014_historicalstockrecord'),
]
operations = [
migrations.CreateModel(
name='HistoricalPartner',
fields=[
('id', models.IntegerField(auto_created=True, blank=True, db_index=True, verbose_name='ID')),
('name', models.CharField(blank=True, max_length=128, verbose_name='Name')),
('short_code', models.CharField(db_index=True, max_length=8)),
('enable_sailthru', models.BooleanField(default=True, help_text=b'DEPRECATED: Use SiteConfiguration!', verbose_name='Enable Sailthru Reporting')),
('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)),
('default_site', models.ForeignKey(blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='sites.Site')),
('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 Partner',
},
bases=(simple_history.models.HistoricalChanges, models.Model),
),
]
class Migration(migrations.Migration):
dependencies = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
('sites', '0002_update_default_site'),
('notice_board', '0007_alter_sphere_site_related_name'),
]
operations = [
migrations.CreateModel(
name='HistoricalSphere',
fields=[
('id',
models.IntegerField(auto_created=True,
blank=True,
db_index=True,
verbose_name='ID')),
('history_change_reason', models.TextField(null=True)),
('is_open', models.BooleanField(default=True)),
('name', models.CharField(max_length=255)),
('settings',
common.json_field.PostgreSQLJSONField(
default=notice_board.models.default_sphere_settings)),
('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)),
('site',
models.ForeignKey(
blank=True,
db_constraint=False,
null=True,
on_delete=django.db.models.deletion.DO_NOTHING,
related_name='+',
to='sites.Site')),
],
options={
'verbose_name': 'historical sphere',
'db_table': 'nb_sphere_history',
'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),
("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):
dependencies = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
("shopify_sync", "0010_auto_20200819_1929"),
]
operations = [
migrations.CreateModel(
name="HistoricalVariant",
fields=[
("id", models.BigIntegerField(db_index=True)),
("admin_graphql_api_id", models.CharField(max_length=80)),
("created_at", models.DateTimeField(null=True)),
("updated_at", models.DateTimeField(null=True)),
("barcode", models.CharField(max_length=255, null=True)),
(
"compare_at_price",
models.DecimalField(decimal_places=2, max_digits=10, null=True),
),
(
"fulfillment_service",
models.CharField(default="manual", max_length=32),
),
("grams", models.IntegerField()),
(
"inventory_management",
models.CharField(default="blank", max_length=32, null=True),
),
(
"inventory_policy",
models.CharField(default="deny", max_length=32, null=True),
),
("inventory_quantity", models.IntegerField(null=True)),
("option1", models.CharField(max_length=255, null=True)),
("option2", models.CharField(max_length=255, null=True)),
("option3", models.CharField(max_length=255, null=True)),
("position", models.IntegerField(default=1, null=True)),
("price", models.DecimalField(decimal_places=2, max_digits=10)),
("requires_shipping", models.BooleanField(default=True)),
("sku", models.CharField(max_length=255, null=True)),
("taxable", models.BooleanField(default=True)),
("title", 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,
),
),
(
"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="shopify_sync.product",
),
),
(
"session",
models.ForeignKey(
blank=True,
db_constraint=False,
null=True,
on_delete=django.db.models.deletion.DO_NOTHING,
related_name="+",
to="shopify_sync.session",
),
),
],
options={
"verbose_name": "historical variant",
"ordering": ("-history_date", "-history_id"),
"get_latest_by": "history_date",
},
bases=(simple_history.models.HistoricalChanges, models.Model),
),
migrations.CreateModel(
name="HistoricalProduct",
fields=[
("id", models.BigIntegerField(db_index=True)),
("admin_graphql_api_id", models.CharField(max_length=80)),
("created_at", models.DateTimeField(null=True)),
("updated_at", models.DateTimeField(null=True)),
("body_html", models.TextField(default="", null=True)),
("handle", models.CharField(db_index=True, max_length=255)),
("product_type", models.CharField(db_index=True, max_length=255)),
("published_at", models.DateTimeField(null=True)),
("published_scope", models.CharField(default="global", max_length=64)),
("tags", models.CharField(blank=True, max_length=255)),
("template_suffix", models.CharField(max_length=255, null=True)),
("title", models.CharField(db_index=True, max_length=255)),
("vendor", models.CharField(db_index=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,
),
),
(
"history_user",
models.ForeignKey(
null=True,
on_delete=django.db.models.deletion.SET_NULL,
related_name="+",
to=settings.AUTH_USER_MODEL,
),
),
(
"session",
models.ForeignKey(
blank=True,
db_constraint=False,
null=True,
on_delete=django.db.models.deletion.DO_NOTHING,
related_name="+",
to="shopify_sync.session",
),
),
],
options={
"verbose_name": "historical product",
"ordering": ("-history_date", "-history_id"),
"get_latest_by": "history_date",
},
bases=(simple_history.models.HistoricalChanges, models.Model),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
('auth', '0009_alter_user_last_name_max_length'),
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
]
operations = [
migrations.CreateModel(
name='AttributeType',
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=128, unique=True)),
],
options={
'ordering': ['name'],
},
),
migrations.CreateModel(
name='HistoricalResource',
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')),
('name', models.CharField(db_index=True, max_length=128)),
('description', models.TextField()),
('is_available', models.BooleanField(default=True)),
('is_public', models.BooleanField(default=True)),
('is_subscribable', 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)),
('history_user', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)),
],
options={
'get_latest_by': 'history_date',
'verbose_name': 'historical resource',
'ordering': ('-history_date', '-history_id'),
},
bases=(simple_history.models.HistoricalChanges, models.Model),
),
migrations.CreateModel(
name='HistoricalResourceAttribute',
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')),
('value', models.CharField(max_length=512)),
('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)),
],
options={
'get_latest_by': 'history_date',
'verbose_name': 'historical resource attribute',
'ordering': ('-history_date', '-history_id'),
},
bases=(simple_history.models.HistoricalChanges, models.Model),
),
migrations.CreateModel(
name='HistoricalResourceAttributeType',
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')),
('name', models.CharField(max_length=128)),
('is_required', models.BooleanField(default=False)),
('is_unique_per_resource', models.BooleanField(default=False)),
('is_value_unique', models.BooleanField(default=False)),
('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)),
('attribute_type', models.ForeignKey(blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='resources.AttributeType')),
('history_user', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)),
],
options={
'get_latest_by': 'history_date',
'verbose_name': 'historical resource attribute type',
'ordering': ('-history_date', '-history_id'),
},
bases=(simple_history.models.HistoricalChanges, models.Model),
),
migrations.CreateModel(
name='HistoricalResourceType',
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')),
('name', models.CharField(db_index=True, max_length=128)),
('description', models.CharField(max_length=255)),
('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)),
],
options={
'get_latest_by': 'history_date',
'verbose_name': 'historical resource type',
'ordering': ('-history_date', '-history_id'),
},
bases=(simple_history.models.HistoricalChanges, models.Model),
),
migrations.CreateModel(
name='Resource',
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=128, unique=True)),
('description', models.TextField()),
('is_available', models.BooleanField(default=True)),
('is_public', models.BooleanField(default=True)),
('is_subscribable', models.BooleanField(default=True)),
('allowed_groups', models.ManyToManyField(blank=True, to='auth.Group')),
('allowed_users', models.ManyToManyField(blank=True, to=settings.AUTH_USER_MODEL)),
('linked_resources', models.ManyToManyField(blank=True, related_name='_resource_linked_resources_+', to='resources.Resource')),
('parent_resource', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to='resources.Resource')),
],
options={
'ordering': ['name'],
},
),
migrations.CreateModel(
name='ResourceAttribute',
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')),
('value', models.CharField(max_length=512)),
('resource', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='resources.Resource')),
],
),
migrations.CreateModel(
name='ResourceAttributeType',
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=128)),
('is_required', models.BooleanField(default=False)),
('is_unique_per_resource', models.BooleanField(default=False)),
('is_value_unique', models.BooleanField(default=False)),
('attribute_type', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='resources.AttributeType')),
],
options={
'ordering': ['name'],
},
),
migrations.CreateModel(
name='ResourceType',
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=128, unique=True)),
('description', models.CharField(max_length=255)),
],
options={
'ordering': ['name'],
},
),
migrations.AddField(
model_name='resourceattribute',
name='resource_attribute_type',
field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='resources.ResourceAttributeType'),
),
migrations.AddField(
model_name='resource',
name='resource_type',
field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='resources.ResourceType'),
),
migrations.AddField(
model_name='historicalresourceattribute',
name='resource',
field=models.ForeignKey(blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='resources.Resource'),
),
migrations.AddField(
model_name='historicalresourceattribute',
name='resource_attribute_type',
field=models.ForeignKey(blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='resources.ResourceAttributeType'),
),
migrations.AddField(
model_name='historicalresource',
name='parent_resource',
field=models.ForeignKey(blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='resources.Resource'),
),
migrations.AddField(
model_name='historicalresource',
name='resource_type',
field=models.ForeignKey(blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='resources.ResourceType'),
),
migrations.AlterUniqueTogether(
name='resourceattribute',
unique_together={('resource_attribute_type', 'resource')},
),
]
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):
initial = True
dependencies = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
("barriers", "0020_auto_20181025_1545"),
("documents", "0001_initial"),
]
operations = [
migrations.CreateModel(
name="Document",
fields=[
(
"created_on",
models.DateTimeField(auto_now_add=True, db_index=True, null=True),
),
("modified_on", models.DateTimeField(auto_now=True, null=True)),
(
"id",
models.UUIDField(
default=uuid.uuid4, primary_key=True, serialize=False
),
),
("original_filename", models.CharField(max_length=255)),
("size", models.IntegerField(null=True)),
("mime_type", models.CharField(max_length=255, null=True)),
(
"created_by",
models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.SET_NULL,
related_name="+",
to=settings.AUTH_USER_MODEL,
),
),
(
"document",
models.OneToOneField(
on_delete=django.db.models.deletion.CASCADE,
to="documents.Document",
),
),
(
"modified_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="HistoricalDocument",
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)),
("original_filename", models.CharField(max_length=255)),
("size", models.IntegerField(null=True)),
("mime_type", models.CharField(max_length=255, 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,
),
),
(
"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,
),
),
(
"document",
models.ForeignKey(
blank=True,
db_constraint=False,
null=True,
on_delete=django.db.models.deletion.DO_NOTHING,
related_name="+",
to="documents.Document",
),
),
(
"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 document",
"ordering": ("-history_date", "-history_id"),
"get_latest_by": "history_date",
},
bases=(simple_history.models.HistoricalChanges, models.Model),
),
migrations.CreateModel(
name="HistoricalInteraction",
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 interaction",
"ordering": ("-history_date", "-history_id"),
"get_latest_by": "history_date",
},
bases=(simple_history.models.HistoricalChanges, models.Model),
),
migrations.CreateModel(
name="Interaction",
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)),
(
"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)),
(
"barrier",
models.ForeignKey(
on_delete=django.db.models.deletion.PROTECT,
related_name="interactions_documents",
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,
),
),
(
"documents",
models.ManyToManyField(
help_text="Interaction documents",
related_name="documents",
to="interactions.Document",
),
),
(
"modified_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},
),
]
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 = [
('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):
initial = True
dependencies = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
]
operations = [
migrations.CreateModel(
name="Merchant",
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,
),
),
(
"merchant_number",
models.IntegerField(db_index=True,
unique=True,
verbose_name="매장번호"),
),
("name", models.CharField(max_length=50, verbose_name="매장이름")),
(
"type",
models.CharField(default="store",
max_length=30,
verbose_name="매장유형"),
),
(
"merchant_contract",
models.CharField(blank=True,
max_length=50,
verbose_name="매장연락처"),
),
(
"addr",
models.CharField(blank=True,
max_length=200,
verbose_name="매장주소"),
),
(
"addr_detail",
models.CharField(blank=True,
max_length=100,
verbose_name="상세주소"),
),
("addr_city",
models.CharField(max_length=30, verbose_name="시,도")),
("addr_province",
models.CharField(max_length=30, verbose_name="구,동")),
],
options={
"verbose_name": "매장",
"verbose_name_plural": "매장 목록",
"ordering": ["merchant_number"],
},
),
migrations.CreateModel(
name="Partner",
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,
),
),
(
"employee_number",
models.IntegerField(db_index=True,
unique=True,
verbose_name="사원번호"),
),
(
"employment_date",
models.DateTimeField(null=True, verbose_name="입사날짜"),
),
(
"rank",
models.CharField(blank=True,
max_length=30,
verbose_name="직급"),
),
(
"is_store_manager",
models.BooleanField(default=False, verbose_name="매장관리자"),
),
(
"nick_name",
models.CharField(blank=True,
max_length=50,
verbose_name="호칭"),
),
(
"department",
models.CharField(blank=True,
max_length=30,
verbose_name="부서"),
),
(
"merchant",
models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
related_name="merchant_set",
to="client.merchant",
verbose_name="매장",
),
),
],
options={
"verbose_name": "파트너",
"verbose_name_plural": "파트너 목록",
"ordering": ["employee_number"],
},
),
migrations.CreateModel(
name="HistoricalPartner",
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,
),
),
(
"employee_number",
models.IntegerField(db_index=True, verbose_name="사원번호"),
),
(
"employment_date",
models.DateTimeField(null=True, verbose_name="입사날짜"),
),
(
"rank",
models.CharField(blank=True,
max_length=30,
verbose_name="직급"),
),
(
"is_store_manager",
models.BooleanField(default=False, verbose_name="매장관리자"),
),
(
"nick_name",
models.CharField(blank=True,
max_length=50,
verbose_name="호칭"),
),
(
"department",
models.CharField(blank=True,
max_length=30,
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,
),
),
(
"merchant",
models.ForeignKey(
blank=True,
db_constraint=False,
null=True,
on_delete=django.db.models.deletion.DO_NOTHING,
related_name="+",
to="client.merchant",
verbose_name="매장",
),
),
],
options={
"verbose_name": "historical 파트너",
"ordering": ("-history_date", "-history_id"),
"get_latest_by": "history_date",
},
bases=(simple_history.models.HistoricalChanges, models.Model),
),
migrations.CreateModel(
name="HistoricalMerchant",
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,
),
),
(
"merchant_number",
models.IntegerField(db_index=True, verbose_name="매장번호"),
),
("name", models.CharField(max_length=50, verbose_name="매장이름")),
(
"type",
models.CharField(default="store",
max_length=30,
verbose_name="매장유형"),
),
(
"merchant_contract",
models.CharField(blank=True,
max_length=50,
verbose_name="매장연락처"),
),
(
"addr",
models.CharField(blank=True,
max_length=200,
verbose_name="매장주소"),
),
(
"addr_detail",
models.CharField(blank=True,
max_length=100,
verbose_name="상세주소"),
),
("addr_city",
models.CharField(max_length=30, verbose_name="시,도")),
("addr_province",
models.CharField(max_length=30, 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,
),
),
],
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):
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 = [
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 = [
('accounts', '0007_auto_20190827_0214'),
]
operations = [
migrations.CreateModel(
name='HistoricalUser',
fields=[
('id',
models.IntegerField(auto_created=True,
blank=True,
db_index=True,
verbose_name='ID')),
('password',
models.CharField(max_length=128, verbose_name='password')),
('last_login',
models.DateTimeField(blank=True,
null=True,
verbose_name='last login')),
('is_superuser',
models.BooleanField(
default=False,
help_text=
'Designates that this user has all permissions without explicitly assigning them.',
verbose_name='superuser status')),
('username',
models.CharField(
db_index=True,
error_messages={
'unique': 'A user with that username already exists.'
},
help_text=
'Required. 150 characters or fewer. Letters, digits and @/./+/-/_ only.',
max_length=150,
validators=[
django.contrib.auth.validators.
UnicodeUsernameValidator()
],
verbose_name='username')),
('first_name',
models.CharField(blank=True,
max_length=30,
verbose_name='first name')),
('last_name',
models.CharField(blank=True,
max_length=150,
verbose_name='last name')),
('is_staff',
models.BooleanField(
default=False,
help_text=
'Designates whether the user can log into this admin site.',
verbose_name='staff status')),
('date_joined',
models.DateTimeField(default=django.utils.timezone.now,
verbose_name='date joined')),
('email', models.EmailField(db_index=True, max_length=254)),
('address', models.CharField(max_length=150, null=True)),
('country',
django_countries.fields.CountryField(max_length=2)),
('city', models.CharField(max_length=50, null=True)),
('phone', models.CharField(max_length=12, null=True)),
('mobile', models.CharField(max_length=12, null=True)),
('is_active',
models.BooleanField(default=True,
verbose_name='active status')),
('is_student',
models.BooleanField(default=False,
verbose_name='student status')),
('is_teacher',
models.BooleanField(default=False,
verbose_name='teacher status')),
('is_school',
models.BooleanField(default=False,
verbose_name='school status')),
('is_curator',
models.BooleanField(default=False,
verbose_name='curator status')),
('is_editor',
models.BooleanField(default=False,
verbose_name='editor status')),
('is_marketer',
models.BooleanField(default=False,
verbose_name='marketer status')),
('account_type',
models.CharField(choices=[('student', 'SchoolStudent'),
('teacher', 'Teacher'),
('school', 'School'),
('curator', 'Curator'),
('editor', 'Editor'),
('super admin', 'Super Admin'),
('admin', 'Admin')],
max_length=11,
verbose_name='Account 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 user',
'ordering': ('-history_date', '-history_id'),
'get_latest_by': 'history_date',
},
bases=(simple_history.models.HistoricalChanges, models.Model),
),
migrations.CreateModel(
name='HistoricalSuperAdmin',
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)),
('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 super admin',
'ordering': ('-history_date', '-history_id'),
'get_latest_by': 'history_date',
},
bases=(simple_history.models.HistoricalChanges, models.Model),
),
migrations.CreateModel(
name='HistoricalStudent',
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)),
('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 student',
'ordering': ('-history_date', '-history_id'),
'get_latest_by': 'history_date',
},
bases=(simple_history.models.HistoricalChanges, models.Model),
),
migrations.CreateModel(
name='HistoricalGrade',
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.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 class',
'ordering': ('-history_date', '-history_id'),
'get_latest_by': 'history_date',
},
bases=(simple_history.models.HistoricalChanges, models.Model),
),
migrations.CreateModel(
name='HistoricalEditor',
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)),
('admin',
models.ForeignKey(
blank=True,
db_constraint=False,
null=True,
on_delete=django.db.models.deletion.DO_NOTHING,
related_name='+',
to='accounts.SuperAdmin')),
('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 editor',
'ordering': ('-history_date', '-history_id'),
'get_latest_by': 'history_date',
},
bases=(simple_history.models.HistoricalChanges, models.Model),
),
migrations.CreateModel(
name='HistoricalCurator',
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)),
('admin',
models.ForeignKey(
blank=True,
db_constraint=False,
null=True,
on_delete=django.db.models.deletion.DO_NOTHING,
related_name='+',
to='accounts.SuperAdmin')),
('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 curator',
'ordering': ('-history_date', '-history_id'),
'get_latest_by': 'history_date',
},
bases=(simple_history.models.HistoricalChanges, models.Model),
),
]
class Migration(migrations.Migration):
dependencies = [
("barriers", "0070_auto_20200706_1456"),
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
("interactions", "0007_merge_20200326_1110"),
]
operations = [
migrations.CreateModel(
name="PublicBarrierNote",
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)),
("text", models.TextField()),
(
"archived_by",
models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.SET_NULL,
related_name="+",
to=settings.AUTH_USER_MODEL,
),
),
(
"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,
),
),
(
"public_barrier",
models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
related_name="notes",
to="barriers.PublicBarrier",
),
),
],
options={
"abstract": False,
},
bases=(api.barriers.mixins.BarrierRelatedMixin, models.Model),
),
migrations.CreateModel(
name="HistoricalPublicBarrierNote",
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)),
("text", models.TextField()),
("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,
),
),
(
"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,
),
),
(
"public_barrier",
models.ForeignKey(
blank=True,
db_constraint=False,
null=True,
on_delete=django.db.models.deletion.DO_NOTHING,
related_name="+",
to="barriers.PublicBarrier",
),
),
],
options={
"verbose_name": "historical public barrier note",
"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),
('schedules', '0012_auto_20200302_1914'),
]
operations = [
migrations.CreateModel(
name='HistoricalSchedule',
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(
default=True,
help_text='Indicates if this schedule is actively used')),
('start',
models.DateTimeField(
db_index=True,
help_text='Date this schedule went into effect')),
('start_date',
models.DateTimeField(
db_index=True,
help_text='Date this schedule went into effect')),
('upgrade_deadline',
models.DateTimeField(
blank=True,
db_index=True,
help_text=
'Deadline by which the learner must upgrade to a verified seat',
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)),
('enrollment',
models.ForeignKey(
blank=True,
db_constraint=False,
null=True,
on_delete=django.db.models.deletion.DO_NOTHING,
related_name='+',
to='student.CourseEnrollment')),
('history_user',
models.ForeignKey(
null=True,
on_delete=django.db.models.deletion.SET_NULL,
related_name='+',
to=settings.AUTH_USER_MODEL)),
],
options={
'get_latest_by': 'history_date',
'ordering': ('-history_date', '-history_id'),
'verbose_name': 'historical Schedule',
},
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="SiteAlertBanner",
fields=[
(
"id",
models.AutoField(
auto_created=True,
primary_key=True,
serialize=False,
verbose_name="ID",
),
),
("banner_text", models.CharField(max_length=255)),
(
"banner_link",
models.CharField(blank=True, max_length=255, null=True),
),
("activated", models.BooleanField(default=False)),
],
),
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)),
(
"banner_link",
models.CharField(blank=True, max_length=255, null=True),
),
("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),
),
]
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):
initial = True
dependencies = [migrations.swappable_dependency(settings.AUTH_USER_MODEL)]
operations = [
migrations.CreateModel(
name="Post",
fields=[
(
"id",
models.AutoField(
auto_created=True,
primary_key=True,
serialize=False,
verbose_name="ID",
),
),
("created", models.DateTimeField(auto_now_add=True)),
("modified", models.DateTimeField(auto_now=True)),
("title", models.CharField(max_length=1024)),
(
"slug",
django_extensions.db.fields.AutoSlugField(
blank=True,
editable=False,
max_length=1024,
populate_from="title",
),
),
("description", models.TextField()),
("content", models.TextField()),
(
"logo",
models.ImageField(
storage=grandchallenge.core.storage.PublicS3Storage(),
upload_to=grandchallenge.core.storage.get_logo_path,
),
),
("published", models.BooleanField(default=False)),
(
"authors",
models.ManyToManyField(to=settings.AUTH_USER_MODEL),
),
],
options={"ordering": ("-created", )},
),
migrations.CreateModel(
name="HistoricalPost",
fields=[
(
"id",
models.IntegerField(
auto_created=True,
blank=True,
db_index=True,
verbose_name="ID",
),
),
("created", models.DateTimeField(blank=True, editable=False)),
("modified", models.DateTimeField(blank=True, editable=False)),
("title", models.CharField(max_length=1024)),
(
"slug",
django_extensions.db.fields.AutoSlugField(
blank=True,
editable=False,
max_length=1024,
populate_from="title",
),
),
("description", models.TextField()),
("content", models.TextField()),
("logo", models.TextField(max_length=100)),
("published", 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 post",
"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),
('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 = [("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 = [
(
"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 = [
('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),
("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):
initial = True
dependencies = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
("barriers", "0032_auto_20190722_0905"),
]
operations = [
migrations.CreateModel(
name="TeamMember",
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)),
("role", models.CharField(max_length=255, null=True)),
("is_active", models.BooleanField(default=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.PROTECT,
related_name="barrier_team",
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,
),
),
(
"user",
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="HistoricalTeamMember",
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)),
("role", models.CharField(max_length=255, null=True)),
("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,
),
),
(
"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,
),
),
(
"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 team member",
"ordering": ("-history_date", "-history_id"),
"get_latest_by": "history_date",
},
bases=(simple_history.models.HistoricalChanges, models.Model),
),
]
class Migration(migrations.Migration):
dependencies = [
("sites", "0002_alter_domain_unique"),
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
("edc_randomization", "0001_initial"),
]
operations = [
migrations.CreateModel(
name="HistoricalRandomizationList",
fields=[
(
"revision",
django_revision.revision_field.RevisionField(
blank=True,
editable=False,
help_text=
"System field. Git repository tag:branch:commit.",
max_length=75,
null=True,
verbose_name="Revision",
),
),
(
"created",
models.DateTimeField(
blank=True,
default=django_audit_fields.models.audit_model_mixin.
utcnow,
),
),
(
"modified",
models.DateTimeField(
blank=True,
default=django_audit_fields.models.audit_model_mixin.
utcnow,
),
),
(
"user_created",
django_audit_fields.fields.userfield.UserField(
blank=True,
help_text="Updated by admin.save_model",
max_length=50,
verbose_name="user created",
),
),
(
"user_modified",
django_audit_fields.fields.userfield.UserField(
blank=True,
help_text="Updated by admin.save_model",
max_length=50,
verbose_name="user modified",
),
),
(
"hostname_created",
models.CharField(
blank=True,
default=_socket.gethostname,
help_text="System field. (modified on create only)",
max_length=60,
),
),
(
"hostname_modified",
django_audit_fields.fields.hostname_modification_field.
HostnameModificationField(
blank=True,
help_text="System field. (modified on every save)",
max_length=50,
),
),
("device_created", models.CharField(blank=True,
max_length=10)),
("device_modified", models.CharField(blank=True,
max_length=10)),
(
"id",
django_audit_fields.fields.uuid_auto_field.UUIDAutoField(
blank=True,
db_index=True,
editable=False,
help_text="System auto field. UUID primary key.",
),
),
(
"assignment",
django_crypto_fields.fields.encrypted_char_field.
EncryptedCharField(
blank=True,
choices=[("active", "Active: "),
("placebo", "Placebo: ")],
help_text=" (Encryption: RSA local)",
max_length=71,
),
),
(
"subject_identifier",
models.CharField(
db_index=True,
max_length=50,
null=True,
verbose_name="Subject Identifier",
),
),
("sid", models.IntegerField(db_index=True)),
("site_name", models.CharField(max_length=100)),
(
"allocation",
django_crypto_fields.fields.encrypted_char_field.
EncryptedCharField(
blank=True,
help_text=" (Encryption: RSA local)",
max_length=71,
null=True,
verbose_name="Original integer allocation",
),
),
("allocated", models.BooleanField(default=False)),
("allocated_datetime", models.DateTimeField(null=True)),
("allocated_user", models.CharField(max_length=50, null=True)),
("verified", models.BooleanField(default=False)),
("verified_datetime", models.DateTimeField(null=True)),
("verified_user", models.CharField(max_length=50, 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,
),
),
(
"allocated_site",
models.ForeignKey(
blank=True,
db_constraint=False,
null=True,
on_delete=django.db.models.deletion.DO_NOTHING,
related_name="+",
to="sites.Site",
),
),
(
"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 randomization list",
"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),
('enterprise', '0107_remove_branding_config_banner_fields'),
]
operations = [
migrations.CreateModel(
name='HistoricalCanvasEnterpriseCustomerConfiguration',
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.'
)),
('channel_worker_username',
models.CharField(
blank=True,
help_text=
'Enterprise channel worker username to get JWT tokens for authenticating LMS APIs.',
max_length=255,
null=True)),
('catalogs_to_transmit',
models.TextField(
blank=True,
help_text=
'A comma-separated list of catalog UUIDs to transmit.',
null=True)),
('client_id',
models.CharField(
help_text=
'The API Client ID provided to edX by the enterprise customer to be used to make API calls to Canvas on behalf of the customer.',
max_length=255,
null=True,
verbose_name='API Client ID')),
('client_secret',
models.CharField(
help_text=
'The API Client Secret provided to edX by the enterprise customer to be used to make API calls to Canvas on behalf of the customer.',
max_length=255,
null=True,
verbose_name='API Client Secret')),
('canvas_account_id',
models.IntegerField(
help_text=
'Account number to use during api calls. Called account_id in canvas. Required to create courses etc.',
null=True,
verbose_name='Canvas Account Number')),
('canvas_base_url',
models.CharField(
help_text=
'The base URL used for API requests to Canvas, i.e. https://instructure.com.',
max_length=255,
null=True,
verbose_name='Canvas 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={
'verbose_name':
'historical canvas enterprise customer configuration',
'get_latest_by': 'history_date',
'ordering': ('-history_date', '-history_id'),
},
bases=(simple_history.models.HistoricalChanges, models.Model),
),
migrations.CreateModel(
name='CanvasGlobalConfiguration',
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')),
('course_api_path',
models.CharField(
help_text=
'The API path for making course metadata POST/DELETE requests to Canvas.',
max_length=255,
verbose_name='Course Metadata 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='CanvasEnterpriseCustomerConfiguration',
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.'
)),
('channel_worker_username',
models.CharField(
blank=True,
help_text=
'Enterprise channel worker username to get JWT tokens for authenticating LMS APIs.',
max_length=255,
null=True)),
('catalogs_to_transmit',
models.TextField(
blank=True,
help_text=
'A comma-separated list of catalog UUIDs to transmit.',
null=True)),
('client_id',
models.CharField(
help_text=
'The API Client ID provided to edX by the enterprise customer to be used to make API calls to Canvas on behalf of the customer.',
max_length=255,
null=True,
verbose_name='API Client ID')),
('client_secret',
models.CharField(
help_text=
'The API Client Secret provided to edX by the enterprise customer to be used to make API calls to Canvas on behalf of the customer.',
max_length=255,
null=True,
verbose_name='API Client Secret')),
('canvas_account_id',
models.IntegerField(
help_text=
'Account number to use during api calls. Called account_id in canvas. Required to create courses etc.',
null=True,
verbose_name='Canvas Account Number')),
('canvas_base_url',
models.CharField(
help_text=
'The base URL used for API requests to Canvas, i.e. https://instructure.com.',
max_length=255,
null=True,
verbose_name='Canvas Base URL')),
('enterprise_customer',
models.OneToOneField(
help_text=
'Enterprise Customer associated with the configuration.',
on_delete=django.db.models.deletion.CASCADE,
to='enterprise.EnterpriseCustomer')),
],
),
]
class Migration(migrations.Migration):
dependencies = [
("user", "0003_user_legacy_sso_user_id"),
]
operations = [
migrations.CreateModel(
name="HistoricalUser",
fields=[
(
"id",
models.IntegerField(
auto_created=True, blank=True, db_index=True, verbose_name="ID"
),
),
("password", models.CharField(max_length=128, verbose_name="password")),
(
"last_login",
models.DateTimeField(
blank=True, null=True, verbose_name="last login"
),
),
(
"is_superuser",
models.BooleanField(
default=False,
help_text="Designates that this user has all permissions without explicitly assigning them.",
verbose_name="superuser status",
),
),
(
"username",
models.CharField(
db_index=True,
error_messages={
"unique": "A user with that username already exists."
},
help_text="Required. 150 characters or fewer. Letters, digits and @/./+/-/_ only.",
max_length=150,
validators=[
django.contrib.auth.validators.UnicodeUsernameValidator()
],
verbose_name="username",
),
),
(
"first_name",
models.CharField(
blank=True, max_length=150, verbose_name="first name"
),
),
(
"last_name",
models.CharField(
blank=True, max_length=150, verbose_name="last name"
),
),
(
"email",
models.EmailField(
blank=True, max_length=254, verbose_name="email address"
),
),
(
"is_staff",
models.BooleanField(
default=False,
help_text="Designates whether the user can log into this admin site.",
verbose_name="staff status",
),
),
(
"is_active",
models.BooleanField(
default=True,
help_text="Designates whether this user should be treated as active. Unselect this instead of deleting accounts.",
verbose_name="active",
),
),
(
"date_joined",
models.DateTimeField(
default=django.utils.timezone.now, verbose_name="date joined"
),
),
(
"sso_contact_email",
models.EmailField(blank=True, max_length=254, null=True),
),
(
"legacy_sso_user_id",
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,
),
),
(
"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 user",
"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),
("interactions", "0007_merge_20200326_1110"),
]
operations = [
migrations.CreateModel(
name="WTOCommittee",
fields=[
(
"id",
models.UUIDField(default=uuid.uuid4,
primary_key=True,
serialize=False),
),
("name", models.CharField(max_length=255)),
],
options={
"ordering": ("name", ),
},
),
migrations.CreateModel(
name="WTOCommitteeGroup",
fields=[
(
"id",
models.UUIDField(default=uuid.uuid4,
primary_key=True,
serialize=False),
),
("name", models.CharField(max_length=255)),
],
options={
"ordering": ("name", ),
},
),
migrations.CreateModel(
name="WTOProfile",
fields=[
(
"id",
models.UUIDField(default=uuid.uuid4,
primary_key=True,
serialize=False),
),
("wto_has_been_notified", models.BooleanField()),
("wto_should_be_notified", models.NullBooleanField()),
(
"committee_notification_link",
models.CharField(blank=True, max_length=255),
),
(
"member_states",
django.contrib.postgres.fields.ArrayField(
base_field=models.UUIDField(),
blank=True,
default=list,
null=True,
size=None,
),
),
("raised_date", models.DateField(null=True)),
("case_number", models.CharField(blank=True, max_length=255)),
(
"committee_notification_document",
models.ForeignKey(
null=True,
on_delete=django.db.models.deletion.SET_NULL,
related_name="committee_notification_wto_profiles",
to="interactions.Document",
),
),
(
"committee_notified",
models.ForeignKey(
null=True,
on_delete=django.db.models.deletion.SET_NULL,
related_name="committee_notified_wto_profiles",
to="wto.WTOCommittee",
),
),
(
"committee_raised_in",
models.ForeignKey(
null=True,
on_delete=django.db.models.deletion.SET_NULL,
related_name="committee_raised_in_wto_profiles",
to="wto.WTOCommittee",
),
),
(
"meeting_minutes",
models.ForeignKey(
null=True,
on_delete=django.db.models.deletion.SET_NULL,
related_name="meeting_minutes_wto_profiles",
to="interactions.Document",
),
),
],
),
migrations.AddField(
model_name="wtocommittee",
name="wto_committee_group",
field=models.ForeignKey(
on_delete=django.db.models.deletion.PROTECT,
related_name="committees",
to="wto.WTOCommitteeGroup",
),
),
migrations.CreateModel(
name="HistoricalWTOProfile",
fields=[
("id", models.UUIDField(db_index=True, default=uuid.uuid4)),
("wto_has_been_notified", models.BooleanField()),
("wto_should_be_notified", models.NullBooleanField()),
(
"committee_notification_link",
models.CharField(blank=True, max_length=255),
),
(
"member_states",
django.contrib.postgres.fields.ArrayField(
base_field=models.UUIDField(),
blank=True,
default=list,
null=True,
size=None,
),
),
("raised_date", models.DateField(null=True)),
("case_number", models.CharField(blank=True, 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,
),
),
(
"committee_notification_document",
models.ForeignKey(
blank=True,
db_constraint=False,
null=True,
on_delete=django.db.models.deletion.DO_NOTHING,
related_name="+",
to="interactions.Document",
),
),
(
"committee_notified",
models.ForeignKey(
blank=True,
db_constraint=False,
null=True,
on_delete=django.db.models.deletion.DO_NOTHING,
related_name="+",
to="wto.WTOCommittee",
),
),
(
"committee_raised_in",
models.ForeignKey(
blank=True,
db_constraint=False,
null=True,
on_delete=django.db.models.deletion.DO_NOTHING,
related_name="+",
to="wto.WTOCommittee",
),
),
(
"history_user",
models.ForeignKey(
null=True,
on_delete=django.db.models.deletion.SET_NULL,
related_name="+",
to=settings.AUTH_USER_MODEL,
),
),
(
"meeting_minutes",
models.ForeignKey(
blank=True,
db_constraint=False,
null=True,
on_delete=django.db.models.deletion.DO_NOTHING,
related_name="+",
to="interactions.Document",
),
),
],
options={
"verbose_name": "historical wto profile",
"ordering": ("-history_date", "-history_id"),
"get_latest_by": "history_date",
},
bases=(simple_history.models.HistoricalChanges, models.Model),
),
]
