class Migration(migrations.Migration):
dependencies = [
('base', '0129_translation_active'),
]
operations = [
migrations.AddIndex(
model_name='translation',
index=partial_index.PartialIndex(
fields=['entity', 'locale', 'plural_form', 'active'],
name='base_transl_entity__fbea1e_partial',
unique=True,
where=partial_index.PQ(active=True)),
),
migrations.AddIndex(
model_name='translation',
index=partial_index.PartialIndex(
fields=['entity', 'locale', 'active'],
name='base_transl_entity__ed9592_partial',
unique=True,
where=partial_index.PQ(('active', True),
('plural_form__isnull', True))),
),
]
class Migration(migrations.Migration):
dependencies = [
("base", "0129_translation_active"),
]
operations = [
migrations.AddIndex(
model_name="translation",
index=partial_index.PartialIndex(
fields=["entity", "locale", "plural_form", "active"],
name="base_transl_entity__fbea1e_partial",
unique=True,
where=partial_index.PQ(active=True),
),
),
migrations.AddIndex(
model_name="translation",
index=partial_index.PartialIndex(
fields=["entity", "locale", "active"],
name="base_transl_entity__ed9592_partial",
unique=True,
where=partial_index.PQ(("active", True),
("plural_form__isnull", True)),
),
),
]
class Migration(migrations.Migration):
dependencies = [
('company', '0009_auto_20190207_1919'),
]
operations = [
migrations.RemoveIndex(
model_name='usercompany',
name='company_use_user_id_099c95_partial',
),
migrations.AlterField(
model_name='company',
name='status',
field=models.PositiveIntegerField(choices=[(1, b'UNVERIFIED'),
(2, b'ACTIVE'),
(3, b'INACTIVE')],
default=1,
help_text='company status'),
),
migrations.AddIndex(
model_name='usercompany',
index=partial_index.PartialIndex(
fields=['user', 'company'],
name='company_use_user_id_a07d1a_partial',
unique=True,
where=partial_index.PQ(status=3)),
),
]
class Migration(migrations.Migration):
dependencies = [
('recipient', '0005_auto_20180723_1753'),
]
operations = [
migrations.CreateModel(
name='RecipientLookup',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('recipient_hash', models.UUIDField(null=True, unique=True)),
('legal_business_name',
models.TextField(db_index=True, null=True)),
('duns', models.TextField(null=True)),
],
options={
'db_table': 'recipient_lookup',
},
),
migrations.AddIndex(
model_name='recipientlookup',
index=partial_index.PartialIndex(
fields=['duns'],
name='recipient_l_duns_bb057a_partial',
unique=True,
where=partial_index.PQ(duns__isnull=False)),
),
]
class Migration(migrations.Migration):
dependencies = [("budgetportal", "0011_govt-func-uniques")]
operations = [
migrations.AddField(
model_name="department",
name="is_vote_primary",
field=models.BooleanField(default=True),
),
migrations.AlterUniqueTogether(
name="department",
unique_together=set([("government", "slug"), ("government", "name")]),
),
migrations.AddIndex(
model_name="department",
index=partial_index.PartialIndex(
fields=["government", "vote_number"],
name="budgetporta_governm_531bf0_partial",
unique=True,
where="is_vote_primary",
where_postgresql="",
where_sqlite="",
),
),
]
class Migration(migrations.Migration):
dependencies = [
('budgetportal', '0011_govt-func-uniques'),
]
operations = [
migrations.AddField(
model_name='department',
name='is_vote_primary',
field=models.BooleanField(default=True),
),
migrations.AlterUniqueTogether(
name='department',
unique_together=set([('government', 'slug'),
('government', 'name')]),
),
migrations.AddIndex(
model_name='department',
index=partial_index.PartialIndex(
fields=[b'government', b'vote_number'],
name='budgetporta_governm_531bf0_partial',
unique=True,
where=b'is_vote_primary',
where_postgresql=b'',
where_sqlite=b''),
),
]
class Migration(migrations.Migration):
atomic = False
dependencies = [
('blobs', '0009_delete_blobexpiration'),
]
operations = [
migrations.RunSQL(
migrations.RunSQL.noop,
migrations.RunSQL.noop,
state_operations=[
migrations.RemoveIndex(
model_name='blobmeta',
name='blobs_blobm_expires_64b92d_partial',
),
migrations.AddIndex(
model_name='blobmeta',
index=partial_index.PartialIndex(
fields=['expires_on'],
name='blobs_blobm_expires_ed7e3d_partial',
unique=False,
where=partial_index.PQ(expires_on__isnull=False)),
)
]),
migrations.RunSQL(
sql=CREATE_INDEX_SQL,
reverse_sql=DROP_INDEX_SQL,
state_operations=[
migrations.AddIndex(
model_name='blobmeta',
index=partial_index.PartialIndex(
fields=['type_code', 'created_on'],
name='blobs_blobm_type_co_23e226_partial',
unique=False,
where=partial_index.PQ(domain='icds-cas')),
),
]),
]
class Migration(migrations.Migration):
dependencies = [
('users', '0039_auto_20210616_1634'),
]
operations = [
migrations.AddIndex(
model_name='userskill',
index=partial_index.PartialIndex(
fields=['skill', 'user'],
name='users_users_skill_i_6ebc32_partial',
unique=True,
where=partial_index.PQ(deleted=False)),
),
]
class Migration(migrations.Migration):
dependencies = [
('company', '0010_auto_20190208_0930'),
]
operations = [
migrations.RemoveIndex(
model_name='usercompany',
name='company_use_user_id_a07d1a_partial',
),
migrations.AddIndex(
model_name='usercompany',
index=partial_index.PartialIndex(fields=['user', 'company'], name='company_use_user_id_9b3056_partial', unique=True, where=partial_index.PQ(status=2)),
),
]
class Migration(migrations.Migration):
dependencies = [
('facility', '0117_patientsample_icmr_category'),
]
operations = [
migrations.CreateModel(
name='FacilityInventoryMinQuantity',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('external_id',
models.UUIDField(db_index=True,
default=uuid.uuid4,
unique=True)),
('created_date',
models.DateTimeField(auto_now_add=True, null=True)),
('modified_date', models.DateTimeField(auto_now=True,
null=True)),
('deleted', models.BooleanField(default=False)),
('min_quantity', models.FloatField(default=0)),
('facility',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='facility.Facility')),
('item',
models.ForeignKey(
null=True,
on_delete=django.db.models.deletion.SET_NULL,
to='facility.FacilityInventoryItem')),
],
bases=(models.Model, care.facility.models.mixins.permissions.
facility.FacilityRelatedPermissionMixin),
),
migrations.AddIndex(
model_name='facilityinventoryminquantity',
index=partial_index.PartialIndex(
fields=['facility', 'item'],
name='facility_fa_facilit_a9eb9a_partial',
unique=True,
where=partial_index.PQ(deleted=False)),
),
]
class Migration(migrations.Migration):
dependencies = [
('recipient', '0010_duns_dba_name'),
]
operations = [
migrations.RemoveIndex(
model_name='recipientlookup',
name='recipient_l_parent__e14231_partial',
),
migrations.AddIndex(
model_name='recipientlookup',
index=partial_index.PartialIndex(
fields=['parent_duns'],
name='recipient_l_parent__efd6d5_partial',
unique=False,
where=partial_index.PQ(parent_duns__isnull=False)),
),
]
class Migration(migrations.Migration):
dependencies = [
('facility', '0053_delete_duplicate_diseases'),
]
operations = [
migrations.AddField(
model_name='disease',
name='deleted',
field=models.BooleanField(default=False),
),
migrations.AddIndex(
model_name='disease',
index=partial_index.PartialIndex(
fields=['patient', 'disease'],
name='facility_di_patient_640ef7_partial',
unique=True,
where=partial_index.PQ(deleted=False)),
),
]
class Migration(migrations.Migration):
dependencies = [
("facility", "0027_auto_20200326_1015"),
]
operations = [
migrations.AlterUniqueTogether(
name="hospitaldoctors",
unique_together=set(),
),
migrations.AddIndex(
model_name="hospitaldoctors",
index=partial_index.PartialIndex(
fields=["facility", "area"],
name="facility_ho_facilit_ec08f4_partial",
unique=True,
where=partial_index.PQ(deleted=False),
),
),
]
class Migration(migrations.Migration):
dependencies = [
("facility", "0028_auto_20200326_1705"),
]
operations = [
migrations.AlterUniqueTogether(
name="facilitycapacity",
unique_together=set(),
),
migrations.AddIndex(
model_name="facilitycapacity",
index=partial_index.PartialIndex(
fields=["facility", "room_type"],
name="facility_fa_facilit_ec2b0e_partial",
unique=True,
where=partial_index.PQ(deleted=False),
),
),
]
class Migration(migrations.Migration):
dependencies = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
('facility', '0114_auto_20200610_1720'),
]
operations = [
migrations.CreateModel(
name='FacilityInventoryItem',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=1000)),
('description', models.TextField(blank=True)),
('min_quantity', models.FloatField()),
],
),
migrations.CreateModel(
name='FacilityInventoryItemTag',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=255)),
],
),
migrations.CreateModel(
name='FacilityInventoryUnit',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=255)),
],
),
migrations.CreateModel(
name='FacilityInventoryUnitConverter',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('multiplier', models.FloatField()),
('from_unit',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='from_unit',
to='facility.FacilityInventoryUnit')),
('to_unit',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='to_unit',
to='facility.FacilityInventoryUnit')),
],
),
migrations.CreateModel(
name='FacilityInventorySummary',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('external_id',
models.UUIDField(db_index=True,
default=uuid.uuid4,
unique=True)),
('created_date',
models.DateTimeField(auto_now_add=True, null=True)),
('modified_date', models.DateTimeField(auto_now=True,
null=True)),
('deleted', models.BooleanField(default=False)),
('quantity', models.FloatField(default=0)),
('is_low', models.BooleanField(default=False)),
('facility',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='facility.Facility')),
('item',
models.ForeignKey(
null=True,
on_delete=django.db.models.deletion.SET_NULL,
to='facility.FacilityInventoryItem')),
],
bases=(models.Model, care.facility.models.mixins.permissions.
facility.FacilityRelatedPermissionMixin),
),
migrations.CreateModel(
name='FacilityInventoryLog',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('external_id',
models.UUIDField(db_index=True,
default=uuid.uuid4,
unique=True)),
('created_date',
models.DateTimeField(auto_now_add=True, null=True)),
('modified_date', models.DateTimeField(auto_now=True,
null=True)),
('deleted', models.BooleanField(default=False)),
('quantity', models.FloatField(default=0)),
('is_incoming', models.BooleanField()),
('created_by',
models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.SET_NULL,
to=settings.AUTH_USER_MODEL)),
('facility',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='facility.Facility')),
('item',
models.ForeignKey(
null=True,
on_delete=django.db.models.deletion.SET_NULL,
to='facility.FacilityInventoryItem')),
('unit',
models.ForeignKey(
null=True,
on_delete=django.db.models.deletion.SET_NULL,
to='facility.FacilityInventoryUnit')),
],
options={
'abstract': False,
},
bases=(models.Model, care.facility.models.mixins.permissions.
facility.FacilityRelatedPermissionMixin),
),
migrations.AddField(
model_name='facilityinventoryitem',
name='allowed_units',
field=models.ManyToManyField(related_name='allowed_units',
to='facility.FacilityInventoryUnit'),
),
migrations.AddField(
model_name='facilityinventoryitem',
name='default_unit',
field=models.ForeignKey(
null=True,
on_delete=django.db.models.deletion.SET_NULL,
related_name='default_unit',
to='facility.FacilityInventoryUnit'),
),
migrations.AddField(
model_name='facilityinventoryitem',
name='tags',
field=models.ManyToManyField(
to='facility.FacilityInventoryItemTag'),
),
migrations.AddIndex(
model_name='facilityinventorysummary',
index=partial_index.PartialIndex(
fields=['facility', 'item'],
name='facility_fa_facilit_ff33b8_partial',
unique=True,
where=partial_index.PQ(deleted=False)),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
("accounts", "0002_auto_20200522_1408"),
]
operations = [
migrations.CreateModel(
name="Ambulance",
fields=[
(
"id",
models.AutoField(
auto_created=True,
primary_key=True,
serialize=False,
verbose_name="ID",
),
),
("active", models.BooleanField(default=True)),
("created_at", models.DateTimeField(auto_now_add=True)),
("updated_at", models.DateTimeField(auto_now=True)),
(
"vehicle_number",
models.CharField(
db_index=True,
max_length=20,
unique=True,
validators=[
django.core.validators.RegexValidator(
code="invalid_vehicle_number",
message=
"Please Enter the vehicle number in all uppercase without spaces, eg: KL13AB1234",
regex=
"^[A-Z]{2}[0-9]{1,2}[A-Z]{0,2}[0-9]{1,4}$",
)
],
),
),
("owner_name", models.CharField(max_length=255)),
(
"owner_phone_number",
models.CharField(
max_length=14,
validators=[
django.core.validators.RegexValidator(
code="invalid_mobile",
message=
"Please Enter 10/11 digit mobile number or landline as 0<std code><phone number>",
regex=
"^((\\+91|91|0)[\\- ]{0,1})?[456789]\\d{9}$",
)
],
),
),
("owner_is_smart_phone", models.BooleanField(default=True)),
("has_oxygen", models.BooleanField()),
("has_ventilator", models.BooleanField()),
("has_suction_machine", models.BooleanField()),
("has_defibrillator", models.BooleanField()),
(
"insurance_valid_till_year",
models.IntegerField(choices=[(2020,
2020), (2021,
2021), (2022,
2022)]),
),
(
"ambulance_type",
models.IntegerField(choices=[(1, "Basic"), (2, "Cardiac"),
(3, "Hearse")],
default=1),
),
(
"price_per_km",
models.DecimalField(decimal_places=2,
max_digits=7,
null=True),
),
("has_free_service", models.BooleanField(default=False)),
(
"created_by",
models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.SET_NULL,
to=settings.AUTH_USER_MODEL,
),
),
(
"primary_district",
models.ForeignKey(
null=True,
on_delete=django.db.models.deletion.PROTECT,
related_name="primary_ambulances",
to="accounts.District",
),
),
(
"secondary_district",
models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.PROTECT,
related_name="secondary_ambulances",
to="accounts.District",
),
),
(
"third_district",
models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.PROTECT,
related_name="third_ambulances",
to="accounts.District",
),
),
],
options={
"abstract": False,
},
),
migrations.CreateModel(
name="Building",
fields=[
(
"id",
models.AutoField(
auto_created=True,
primary_key=True,
serialize=False,
verbose_name="ID",
),
),
("active", models.BooleanField(default=True)),
("created_at", models.DateTimeField(auto_now_add=True)),
("updated_at", models.DateTimeField(auto_now=True)),
("name", models.CharField(max_length=1000)),
(
"num_rooms",
models.IntegerField(
default=0,
validators=[
django.core.validators.MinValueValidator(0)
],
),
),
(
"num_floors",
models.IntegerField(
default=0,
validators=[
django.core.validators.MinValueValidator(0)
],
),
),
(
"num_buildings",
models.IntegerField(
default=0,
validators=[
django.core.validators.MinValueValidator(0)
],
),
),
],
options={
"abstract": False,
},
),
migrations.CreateModel(
name="Facility",
fields=[
(
"id",
models.AutoField(
auto_created=True,
primary_key=True,
serialize=False,
verbose_name="ID",
),
),
("active", models.BooleanField(default=True)),
("created_at", models.DateTimeField(auto_now_add=True)),
("updated_at", models.DateTimeField(auto_now=True)),
("name", models.CharField(max_length=1000)),
("is_active", models.BooleanField(default=True)),
("verified", models.BooleanField(default=False)),
(
"facility_type",
models.IntegerField(choices=[
(1, "Educational Inst"),
(2, "Private Hospital"),
(3, "Other"),
(4, "Hostel"),
(5, "Hotel"),
(6, "Lodge"),
(7, "TeleMedicine"),
(8, "Govt Hospital"),
(9, "Labs"),
(800, "Primary Health Centres"),
(801, "24x7 Public Health Centres"),
(802, "Family Health Centres"),
(803, "Community Health Centres"),
(820, "Urban Primary Health Center"),
(830, "Taluk Hospitals"),
(831, "Taluk Headquarters Hospitals"),
(840, "Women and Child Health Centres"),
(850, "General hospitals"),
(860, "District Hospitals"),
(870, "Govt Medical College Hospitals"),
(950, "Corona Testing Labs"),
(1000, "Corona Care Centre"),
]),
),
(
"location",
location_field.models.spatial.LocationField(blank=True,
null=True,
srid=4326),
),
("address", models.TextField()),
("oxygen_capacity", models.IntegerField(default=0)),
(
"phone_number",
models.CharField(
blank=True,
max_length=14,
validators=[
django.core.validators.RegexValidator(
code="invalid_mobile",
message=
"Please Enter 10/11 digit mobile number or landline as 0<std code><phone number>",
regex=
"^((\\+91|91|0)[\\- ]{0,1})?[456789]\\d{9}$",
)
],
),
),
("corona_testing", models.BooleanField(default=False)),
(
"created_by",
models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.SET_NULL,
to=settings.AUTH_USER_MODEL,
),
),
(
"district",
models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.SET_NULL,
to="accounts.District",
),
),
(
"local_body",
models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.SET_NULL,
to="accounts.LocalBody",
),
),
(
"state",
models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.SET_NULL,
to="accounts.State",
),
),
],
options={
"verbose_name_plural": "Facilities",
},
),
migrations.CreateModel(
name="Inventory",
fields=[
(
"id",
models.AutoField(
auto_created=True,
primary_key=True,
serialize=False,
verbose_name="ID",
),
),
("active", models.BooleanField(default=True)),
("created_at", models.DateTimeField(auto_now_add=True)),
("updated_at", models.DateTimeField(auto_now=True)),
(
"quantitiy",
models.IntegerField(
default=0,
validators=[
django.core.validators.MinValueValidator(0)
],
),
),
(
"facility",
models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to="facility.Facility",
),
),
],
options={
"verbose_name_plural": "Inventories",
},
),
migrations.CreateModel(
name="InventoryItem",
fields=[
(
"id",
models.AutoField(
auto_created=True,
primary_key=True,
serialize=False,
verbose_name="ID",
),
),
("active", models.BooleanField(default=True)),
("created_at", models.DateTimeField(auto_now_add=True)),
("updated_at", models.DateTimeField(auto_now=True)),
("name", models.CharField(max_length=1000)),
("description", models.TextField()),
(
"minimum_stock",
models.IntegerField(
default=0,
validators=[
django.core.validators.MinValueValidator(0)
],
),
),
("unit", models.CharField(max_length=20)),
],
options={
"abstract": False,
},
),
migrations.CreateModel(
name="Room",
fields=[
(
"id",
models.AutoField(
auto_created=True,
primary_key=True,
serialize=False,
verbose_name="ID",
),
),
("active", models.BooleanField(default=True)),
("created_at", models.DateTimeField(auto_now_add=True)),
("updated_at", models.DateTimeField(auto_now=True)),
("num", models.CharField(max_length=1000)),
(
"floor",
models.IntegerField(
default=0,
validators=[
django.core.validators.MinValueValidator(0)
],
),
),
(
"beds_capacity",
models.IntegerField(
default=0,
validators=[
django.core.validators.MinValueValidator(0)
],
),
),
(
"occupied_beds",
models.IntegerField(
default=0,
validators=[
django.core.validators.MinValueValidator(0)
],
),
),
(
"room_type",
models.IntegerField(choices=[
(0, "Total"),
(1, "General Bed"),
(2, "Hostel"),
(3, "Single Room with Attached Bathroom"),
(10, "ICU"),
(20, "Ventilator"),
]),
),
(
"building",
models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to="facility.Building",
),
),
],
options={
"abstract": False,
},
),
migrations.CreateModel(
name="StaffRoomAllocation",
fields=[
(
"id",
models.AutoField(
auto_created=True,
primary_key=True,
serialize=False,
verbose_name="ID",
),
),
("active", models.BooleanField(default=True)),
("created_at", models.DateTimeField(auto_now_add=True)),
("updated_at", models.DateTimeField(auto_now=True)),
(
"room",
models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to="facility.Room"),
),
(
"staff",
models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL,
),
),
],
options={
"abstract": False,
},
),
migrations.CreateModel(
name="InventoryLog",
fields=[
(
"id",
models.AutoField(
auto_created=True,
primary_key=True,
serialize=False,
verbose_name="ID",
),
),
("active", models.BooleanField(default=True)),
("created_at", models.DateTimeField(auto_now_add=True)),
("updated_at", models.DateTimeField(auto_now=True)),
(
"prev_count",
models.IntegerField(
default=0,
validators=[
django.core.validators.MinValueValidator(0)
],
),
),
(
"new_count",
models.IntegerField(
default=0,
validators=[
django.core.validators.MinValueValidator(0)
],
),
),
(
"inventory",
models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to="facility.Inventory",
),
),
(
"updated_by",
models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.SET_NULL,
to=settings.AUTH_USER_MODEL,
),
),
],
options={
"abstract": False,
},
),
migrations.AddField(
model_name="inventory",
name="item",
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to="facility.InventoryItem"),
),
migrations.CreateModel(
name="HospitalDoctors",
fields=[
(
"id",
models.AutoField(
auto_created=True,
primary_key=True,
serialize=False,
verbose_name="ID",
),
),
("active", models.BooleanField(default=True)),
("created_at", models.DateTimeField(auto_now_add=True)),
("updated_at", models.DateTimeField(auto_now=True)),
(
"area",
models.IntegerField(choices=[
(1, "General Medicine"),
(2, "Pulmonology"),
(3, "Critical Care"),
(4, "Paediatrics"),
(5, "Other Speciality"),
]),
),
("count", models.IntegerField()),
(
"facility",
models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to="facility.Facility",
),
),
],
),
migrations.CreateModel(
name="HistoricalFacilityCapacity",
fields=[
(
"id",
models.IntegerField(auto_created=True,
blank=True,
db_index=True,
verbose_name="ID"),
),
("active", models.BooleanField(default=True)),
("created_at", models.DateTimeField(blank=True,
editable=False)),
("updated_at", models.DateTimeField(blank=True,
editable=False)),
(
"room_type",
models.IntegerField(choices=[
(0, "Total"),
(1, "General Bed"),
(2, "Hostel"),
(3, "Single Room with Attached Bathroom"),
(10, "ICU"),
(20, "Ventilator"),
]),
),
(
"total_capacity",
models.IntegerField(
default=0,
validators=[
django.core.validators.MinValueValidator(0)
],
),
),
(
"current_capacity",
models.IntegerField(
default=0,
validators=[
django.core.validators.MinValueValidator(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,
),
),
(
"facility",
models.ForeignKey(
blank=True,
db_constraint=False,
null=True,
on_delete=django.db.models.deletion.DO_NOTHING,
related_name="+",
to="facility.Facility",
),
),
(
"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 facility capacity",
"ordering": ("-history_date", "-history_id"),
"get_latest_by": "history_date",
},
bases=(simple_history.models.HistoricalChanges, models.Model),
),
migrations.CreateModel(
name="FacilityVolunteer",
fields=[
(
"id",
models.AutoField(
auto_created=True,
primary_key=True,
serialize=False,
verbose_name="ID",
),
),
("active", models.BooleanField(default=True)),
("created_at", models.DateTimeField(auto_now_add=True)),
("updated_at", models.DateTimeField(auto_now=True)),
(
"facility",
models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to="facility.Facility",
),
),
(
"volunteer",
models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL,
),
),
],
options={
"abstract": False,
},
),
migrations.CreateModel(
name="FacilityUser",
fields=[
(
"id",
models.AutoField(
auto_created=True,
primary_key=True,
serialize=False,
verbose_name="ID",
),
),
("active", models.BooleanField(default=True)),
("created_at", models.DateTimeField(auto_now_add=True)),
("updated_at", models.DateTimeField(auto_now=True)),
(
"created_by",
models.ForeignKey(
on_delete=django.db.models.deletion.PROTECT,
related_name="created_users",
to=settings.AUTH_USER_MODEL,
),
),
(
"facility",
models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to="facility.Facility",
),
),
(
"user",
models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL,
),
),
],
options={
"abstract": False,
},
),
migrations.CreateModel(
name="FacilityStaff",
fields=[
(
"id",
models.AutoField(
auto_created=True,
primary_key=True,
serialize=False,
verbose_name="ID",
),
),
("active", models.BooleanField(default=True)),
("created_at", models.DateTimeField(auto_now_add=True)),
("updated_at", models.DateTimeField(auto_now=True)),
(
"facility",
models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to="facility.Facility",
),
),
(
"staff",
models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL,
),
),
],
options={
"abstract": False,
},
),
migrations.CreateModel(
name="FacilityLocalGovtBody",
fields=[
(
"id",
models.AutoField(
auto_created=True,
primary_key=True,
serialize=False,
verbose_name="ID",
),
),
("active", models.BooleanField(default=True)),
("created_at", models.DateTimeField(auto_now_add=True)),
("updated_at", models.DateTimeField(auto_now=True)),
(
"district",
models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.SET_NULL,
to="accounts.District",
),
),
(
"facility",
models.OneToOneField(
blank=True,
null=True,
on_delete=django.db.models.deletion.SET_NULL,
to="facility.Facility",
),
),
(
"local_body",
models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.SET_NULL,
to="accounts.LocalBody",
),
),
],
),
migrations.CreateModel(
name="FacilityCapacity",
fields=[
(
"id",
models.AutoField(
auto_created=True,
primary_key=True,
serialize=False,
verbose_name="ID",
),
),
("active", models.BooleanField(default=True)),
("created_at", models.DateTimeField(auto_now_add=True)),
("updated_at", models.DateTimeField(auto_now=True)),
(
"room_type",
models.IntegerField(choices=[
(0, "Total"),
(1, "General Bed"),
(2, "Hostel"),
(3, "Single Room with Attached Bathroom"),
(10, "ICU"),
(20, "Ventilator"),
]),
),
(
"total_capacity",
models.IntegerField(
default=0,
validators=[
django.core.validators.MinValueValidator(0)
],
),
),
(
"current_capacity",
models.IntegerField(
default=0,
validators=[
django.core.validators.MinValueValidator(0)
],
),
),
(
"facility",
models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to="facility.Facility",
),
),
],
),
migrations.AddField(
model_name="facility",
name="users",
field=models.ManyToManyField(
related_name="facilities",
through="facility.FacilityUser",
to=settings.AUTH_USER_MODEL,
),
),
migrations.AddField(
model_name="building",
name="facility",
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to="facility.Facility"),
),
migrations.CreateModel(
name="AmbulanceDriver",
fields=[
(
"id",
models.AutoField(
auto_created=True,
primary_key=True,
serialize=False,
verbose_name="ID",
),
),
("active", models.BooleanField(default=True)),
("created_at", models.DateTimeField(auto_now_add=True)),
("updated_at", models.DateTimeField(auto_now=True)),
("name", models.CharField(max_length=255)),
(
"phone_number",
models.CharField(
max_length=14,
validators=[
django.core.validators.RegexValidator(
code="invalid_mobile",
message=
"Please Enter 10/11 digit mobile number or landline as 0<std code><phone number>",
regex=
"^((\\+91|91|0)[\\- ]{0,1})?[456789]\\d{9}$",
)
],
),
),
("is_smart_phone", models.BooleanField()),
(
"ambulance",
models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to="facility.Ambulance",
),
),
],
options={
"abstract": False,
},
),
migrations.AddIndex(
model_name="hospitaldoctors",
index=partial_index.PartialIndex(
fields=["facility", "area"],
name="facility_ho_facilit_efac7e_partial",
unique=True,
where=partial_index.PQ(active=True),
),
),
migrations.AddConstraint(
model_name="facilitylocalgovtbody",
constraint=models.CheckConstraint(
check=models.Q(
("local_body__isnull", False),
("district__isnull", False),
_connector="OR",
),
name="cons_facilitylocalgovtbody_only_one_null",
),
),
migrations.AddIndex(
model_name="facilitycapacity",
index=partial_index.PartialIndex(
fields=["facility", "room_type"],
name="facility_fa_facilit_9f0bcc_partial",
unique=True,
where=partial_index.PQ(active=True),
),
),
]
class Migration(migrations.Migration):
dependencies = [
('blobs', '0001_squashed_0009_domains'),
('form_processor', '0072_case_attachment_drops'),
]
operations = [
migrations.CreateModel(
name='BlobMeta',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('domain', models.CharField(max_length=255)),
('parent_id',
models.CharField(
help_text='Parent primary key or unique identifier',
max_length=255)), # noqa: E501
(
'name',
models.CharField(
default='',
help_text=
'Optional blob name.\n\n This field is intended to be used by doc types having multiple\n blobs associated with a single document.\n ',
max_length=255),
), # noqa: E501
('key',
models.CharField(
default=corehq.blobs.models.uuid4_hex,
help_text=
"Blob key in the external blob store.\n\n This must be a globally unique value. Historically this was\n `blob_bucket + '/' + identifier` for blobs associated with a\n couch document. Could be a UUID or the result of\n `util.random_url_id(16)`. Defaults to `uuid4().hex`.\n ",
max_length=255)), # noqa: E501
('type_code',
models.PositiveSmallIntegerField(
help_text='Blob type code. See `corehq.blobs.CODES`.')
), # noqa: E501
('content_length', models.PositiveIntegerField()),
('content_type', models.CharField(max_length=255, null=True)),
('properties', corehq.blobs.util.NullJsonField(default=dict)),
('created_on',
models.DateTimeField(default=datetime.datetime.utcnow)),
('expires_on', models.DateTimeField(default=None, null=True)),
],
),
migrations.AddIndex(
model_name='blobmeta',
index=partial_index.PartialIndex(
fields=['expires_on'],
name='blobs_blobm_expires_64b92d_partial',
unique=False,
where='expires_on IS NOT NULL',
where_postgresql=b'',
where_sqlite=b''), # noqa: E501
),
migrations.AlterIndexTogether(
name='blobmeta',
index_together=set([('parent_id', 'type_code', 'name')]),
),
migrations.AlterUniqueTogether(
name='blobmeta',
unique_together=set([('key', )]),
),
migrator.get_migration('delete_blob_meta.sql'),
]
class Migration(migrations.Migration):
dependencies = [
('recipient', '0007_auto_20180802_1757'),
]
operations = [
migrations.AddField(
model_name='recipientlookup',
name='address_line_1',
field=models.TextField(null=True),
),
migrations.AddField(
model_name='recipientlookup',
name='address_line_2',
field=models.TextField(null=True),
),
migrations.AddField(
model_name='recipientlookup',
name='business_types_codes',
field=django.contrib.postgres.fields.ArrayField(
base_field=models.TextField(),
default=list,
null=True,
size=None),
),
migrations.AddField(
model_name='recipientlookup',
name='city',
field=models.TextField(null=True),
),
migrations.AddField(
model_name='recipientlookup',
name='congressional_district',
field=models.TextField(null=True),
),
migrations.AddField(
model_name='recipientlookup',
name='country_code',
field=models.TextField(null=True),
),
migrations.AddField(
model_name='recipientlookup',
name='parent_duns',
field=models.TextField(null=True),
),
migrations.AddField(
model_name='recipientlookup',
name='parent_legal_business_name',
field=models.TextField(null=True),
),
migrations.AddField(
model_name='recipientlookup',
name='state',
field=models.TextField(null=True),
),
migrations.AddField(
model_name='recipientlookup',
name='zip4',
field=models.TextField(null=True),
),
migrations.AddField(
model_name='recipientlookup',
name='zip5',
field=models.TextField(null=True),
),
migrations.AddIndex(
model_name='recipientlookup',
index=partial_index.PartialIndex(
fields=['parent_duns'],
name='recipient_l_parent__e14231_partial',
unique=False,
where=partial_index.PQ(parent_duns__isnull=False)),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = []
operations = [
TrigramExtension(),
migrations.CreateModel(
name='DUNS',
fields=[
('awardee_or_recipient_uniqu',
models.TextField(primary_key=True, serialize=False)),
('legal_business_name', models.TextField(blank=True,
null=True)),
('dba_name', models.TextField(blank=True, null=True)),
('ultimate_parent_unique_ide',
models.TextField(blank=True, null=True)),
('ultimate_parent_legal_enti',
models.TextField(blank=True, null=True)),
('address_line_1', models.TextField(blank=True, null=True)),
('address_line_2', models.TextField(blank=True, null=True)),
('city', models.TextField(blank=True, null=True)),
('state', models.TextField(blank=True, null=True)),
('zip', models.TextField(blank=True, null=True)),
('zip4', models.TextField(blank=True, null=True)),
('country_code', models.TextField(blank=True, null=True)),
('congressional_district',
models.TextField(blank=True, null=True)),
('business_types_codes',
django.contrib.postgres.fields.ArrayField(
base_field=models.TextField(),
default=list,
null=True,
size=None)),
('entity_structure', models.TextField(blank=True, null=True)),
('broker_duns_id', models.TextField()),
('update_date', models.DateField()),
],
options={
'db_table': 'duns',
},
),
migrations.CreateModel(
name='HistoricParentDUNS',
fields=[
('awardee_or_recipient_uniqu', models.TextField()),
('legal_business_name', models.TextField(blank=True,
null=True)),
('ultimate_parent_unique_ide',
models.TextField(blank=True, null=True)),
('ultimate_parent_legal_enti',
models.TextField(blank=True, null=True)),
('broker_historic_duns_id',
models.IntegerField(primary_key=True, serialize=False)),
('year', models.IntegerField(blank=True, null=True)),
],
options={
'db_table': 'historic_parent_duns',
},
),
migrations.CreateModel(
name='RecipientLookup',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('recipient_hash', models.UUIDField(null=True, unique=True)),
('legal_business_name',
models.TextField(db_index=True, null=True)),
('duns', models.TextField(null=True, unique=True)),
('parent_duns', models.TextField(null=True)),
('parent_legal_business_name', models.TextField(null=True)),
('address_line_1', models.TextField(null=True)),
('address_line_2', models.TextField(null=True)),
('city', models.TextField(null=True)),
('state', models.TextField(null=True)),
('zip5', models.TextField(null=True)),
('zip4', models.TextField(null=True)),
('country_code', models.TextField(null=True)),
('congressional_district', models.TextField(null=True)),
('business_types_codes',
django.contrib.postgres.fields.ArrayField(
base_field=models.TextField(),
default=list,
null=True,
size=None)),
],
options={
'db_table': 'recipient_lookup',
},
),
migrations.CreateModel(
name='RecipientProfile',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('recipient_level', models.CharField(max_length=1)),
('recipient_hash', models.UUIDField(db_index=True, null=True)),
('recipient_unique_id',
models.TextField(db_index=True, null=True)),
('recipient_name', models.TextField(db_index=True, null=True)),
('recipient_affiliations',
django.contrib.postgres.fields.ArrayField(
base_field=models.TextField(), default=list, size=None)),
('award_types',
django.contrib.postgres.fields.ArrayField(
base_field=models.TextField(), default=list, size=None)),
('last_12_months',
models.DecimalField(decimal_places=2,
default=0.0,
max_digits=23)),
('last_12_contracts',
models.DecimalField(decimal_places=2,
default=0.0,
max_digits=23)),
('last_12_grants',
models.DecimalField(decimal_places=2,
default=0.0,
max_digits=23)),
('last_12_direct_payments',
models.DecimalField(decimal_places=2,
default=0.0,
max_digits=23)),
('last_12_loans',
models.DecimalField(decimal_places=2,
default=0.0,
max_digits=23)),
('last_12_other',
models.DecimalField(decimal_places=2,
default=0.0,
max_digits=23)),
('last_12_months_count', models.IntegerField(default=0)),
],
options={
'db_table': 'recipient_profile',
'managed': True,
},
),
migrations.CreateModel(
name='StateData',
fields=[
('id', models.TextField(primary_key=True, serialize=False)),
('fips', models.TextField(db_index=True)),
('code', models.TextField()),
('name', models.TextField()),
('type', models.TextField()),
('year', models.IntegerField(db_index=True)),
('population', models.BigIntegerField(blank=True, null=True)),
('pop_source', models.TextField(blank=True, null=True)),
('median_household_income',
models.DecimalField(blank=True,
decimal_places=2,
max_digits=23,
null=True)),
('mhi_source', models.TextField(blank=True, null=True)),
],
options={
'db_table': 'state_data',
},
),
migrations.CreateModel(
name='SummaryAwardRecipient',
fields=[
('award_id',
models.BigIntegerField(primary_key=True, serialize=False)),
('action_date', models.DateField(blank=True, db_index=True)),
('recipient_hash', models.UUIDField(db_index=True, null=True)),
('parent_recipient_unique_id',
models.TextField(db_index=True, null=True)),
],
options={
'db_table': 'summary_award_recipient',
'managed': True,
},
),
migrations.AddIndex(
model_name='recipientprofile',
index=django.contrib.postgres.indexes.GinIndex(
fields=['award_types'], name='recipient_p_award_t_211373_gin'),
),
migrations.AddIndex(
model_name='recipientprofile',
index=models.Index(fields=['recipient_unique_id'],
name='recipient_p_recipie_7039a5_idx'),
),
migrations.AlterUniqueTogether(
name='recipientprofile',
unique_together=set([('recipient_hash', 'recipient_level')]),
),
migrations.AddIndex(
model_name='recipientlookup',
index=partial_index.PartialIndex(
fields=['duns'],
name='recipient_l_duns_bb057a_partial',
unique=True,
where=partial_index.PQ(duns__isnull=False)),
),
migrations.AddIndex(
model_name='recipientlookup',
index=partial_index.PartialIndex(
fields=['parent_duns'],
name='recipient_l_parent__efd6d5_partial',
unique=False,
where=partial_index.PQ(parent_duns__isnull=False)),
),
migrations.RunSQL(sql=[
'alter table only recipient_profile alter column last_12_months set default 0.00',
"alter table only recipient_profile alter column recipient_affiliations set default '{}'::text[]",
'create index idx_recipient_profile_name on recipient_profile using gin (recipient_name gin_trgm_ops)',
], ),
]
class Migration(migrations.Migration):
dependencies = [
('authentication_service', '0005_auto_20180307_1212'),
]
operations = [
migrations.AlterModelOptions(
name='coreuser',
options={},
),
migrations.AddField(
model_name='coreuser',
name='q',
field=authentication_service.models.AutoQueryField(default=''),
preserve_default=False,
),
migrations.AlterField(
model_name='coreuser',
name='country',
field=models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.CASCADE,
to='authentication_service.Country',
verbose_name='country'),
),
migrations.AlterField(
model_name='coreuser',
name='gender',
field=models.CharField(blank=True,
choices=[('female', 'Female'),
('male', 'Male'),
('other', 'Other')],
max_length=10,
null=True,
verbose_name='gender'),
),
migrations.AlterField(
model_name='usersecurityquestion',
name='answer',
field=models.TextField(verbose_name='answer'),
),
migrations.AddIndex(
model_name='coreuser',
index=models.Index(fields=['date_joined'],
name='authenticat_date_jo_188bff_idx'),
),
migrations.AddIndex(
model_name='coreuser',
index=models.Index(fields=['gender'],
name='authenticat_gender_277866_idx'),
),
migrations.AddIndex(
model_name='coreuser',
index=models.Index(fields=['last_login'],
name='authenticat_last_lo_f8ef1c_idx'),
),
migrations.AddIndex(
model_name='coreuser',
index=models.Index(fields=['updated_at'],
name='authenticat_updated_766884_idx'),
),
migrations.AddIndex(
model_name='coreuser',
index=partial_index.PartialIndex(
fields=['is_active'],
name='authenticat_is_acti_7ff3d3_partial',
unique=False,
where='',
where_postgresql='is_active = false',
where_sqlite=''),
),
migrations.AddIndex(
model_name='coreuser',
index=partial_index.PartialIndex(
fields=['email_verified'],
name='authenticat_email_v_74d3e8_partial',
unique=False,
where='',
where_postgresql='email_verified = true',
where_sqlite=''),
),
migrations.AddIndex(
model_name='coreuser',
index=partial_index.PartialIndex(
fields=['msisdn_verified'],
name='authenticat_msisdn__e2202e_partial',
unique=False,
where='',
where_postgresql='msisdn_verified = true',
where_sqlite=''),
),
migrations.AddIndex(
model_name='coreuser',
index=authentication_service.models.TrigramIndex(
fields=['username'], name='authenticat_usernam_ee0130_gin'),
),
migrations.AddIndex(
model_name='coreuser',
index=authentication_service.models.TrigramIndex(
fields=['email'], name='authenticat_email_84c43b_gin'),
),
migrations.AddIndex(
model_name='coreuser',
index=authentication_service.models.TrigramIndex(
fields=['first_name'], name='authenticat_first_n_9c2690_gin'),
),
migrations.AddIndex(
model_name='coreuser',
index=authentication_service.models.TrigramIndex(
fields=['last_name'], name='authenticat_last_na_40dea2_gin'),
),
migrations.AddIndex(
model_name='coreuser',
index=authentication_service.models.TrigramIndex(
fields=['nickname'], name='authenticat_nicknam_ba9efc_gin'),
),
migrations.AddIndex(
model_name='coreuser',
index=authentication_service.models.TrigramIndex(
fields=['q'], name='authenticat_q_2fcb4b_gin'),
),
]
class Migration(migrations.Migration):
replaces = [('authentication_service', '0001_initial'),
('authentication_service', '0002_auto_20180206_0833'),
('authentication_service', '0003_auto_20180208_1505'),
('authentication_service', '0004_auto_20180306_0849'),
('authentication_service', '0005_auto_20180307_1212'),
('authentication_service', '0006_auto_20180424_0848'),
('authentication_service', '0007_auto_20180502_0905'),
('authentication_service', '0008_auto_20180502_1343'),
('authentication_service', '0009_auto_20180515_0917'),
('authentication_service', '0010_coreuser_migration_data'),
('authentication_service', '0011_auto_20180601_1241')]
initial = True
dependencies = [
('auth', '0008_alter_user_username_max_length'),
]
operations = [
migrations.CreateModel(
name='CoreUser',
fields=[
('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(
error_messages={
'unique': 'A user with that username already exists.'
},
help_text=
'Required. 150 characters or fewer. Letters, digits and @/./+/-/_ only.',
max_length=150,
unique=True,
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=30,
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')),
('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')),
('id',
models.UUIDField(default=uuid.uuid1,
editable=False,
primary_key=True,
serialize=False)),
('email',
models.EmailField(blank=True,
max_length=254,
null=True,
unique=True,
verbose_name='email address')),
('email_verified', models.BooleanField(default=False)),
('nickname',
models.CharField(blank=True, max_length=30, null=True)),
('msisdn',
models.CharField(blank=True, max_length=16, null=True)),
('msisdn_verified', models.BooleanField(default=False)),
('gender',
models.CharField(blank=True,
choices=[('female', 'Female'),
('male', 'Male'),
('other', 'Other')],
max_length=10,
null=True)),
('birth_date', models.DateField(blank=True, null=True)),
('avatar',
models.ImageField(blank=True, null=True, upload_to='')),
('is_employee', models.BooleanField(default=False)),
('is_system_user', models.BooleanField(default=False)),
('updated_at', models.DateTimeField(auto_now=True)),
],
options={
'verbose_name': 'user',
'verbose_name_plural': 'users',
'abstract': False,
},
managers=[
('objects', django.contrib.auth.models.UserManager()),
],
),
migrations.CreateModel(
name='Country',
fields=[
('code',
models.CharField(default='a',
max_length=2,
primary_key=True,
serialize=False)),
('name', models.CharField(blank=True,
max_length=100,
null=True)),
],
options={
'verbose_name_plural': 'Countries',
},
),
migrations.CreateModel(
name='QuestionLanguageText',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('language_code',
models.CharField(choices=[
('af', 'Afrikaans'), ('ar', 'Arabic'),
('ast', 'Asturian'), ('az', 'Azerbaijani'),
('bg', 'Bulgarian'), ('be', 'Belarusian'),
('bn', 'Bengali'), ('br', 'Breton'), ('bs', 'Bosnian'),
('ca', 'Catalan'), ('cs', 'Czech'), ('cy', 'Welsh'),
('da', 'Danish'), ('de', 'German'),
('dsb', 'Lower Sorbian'), ('el', 'Greek'),
('en', 'English'), ('en-au', 'Australian English'),
('en-gb', 'British English'), ('eo', 'Esperanto'),
('es', 'Spanish'), ('es-ar', 'Argentinian Spanish'),
('es-co', 'Colombian Spanish'),
('es-mx', 'Mexican Spanish'),
('es-ni', 'Nicaraguan Spanish'),
('es-ve', 'Venezuelan Spanish'), ('et', 'Estonian'),
('eu', 'Basque'), ('fa', 'Persian'), ('fi', 'Finnish'),
('fr', 'French'), ('fy', 'Frisian'), ('ga', 'Irish'),
('gd', 'Scottish Gaelic'), ('gl', 'Galician'),
('he', 'Hebrew'), ('hi', 'Hindi'), ('hr', 'Croatian'),
('hsb', 'Upper Sorbian'), ('hu', 'Hungarian'),
('ia', 'Interlingua'),
('id', 'Indonesian'), ('io', 'Ido'), ('is', 'Icelandic'),
('it', 'Italian'), ('ja', 'Japanese'), ('ka', 'Georgian'),
('kk', 'Kazakh'), ('km', 'Khmer'), ('kn', 'Kannada'),
('ko', 'Korean'), ('lb', 'Luxembourgish'),
('lt', 'Lithuanian'), ('lv', 'Latvian'),
('mk', 'Macedonian'), ('ml', 'Malayalam'),
('mn', 'Mongolian'), ('mr', 'Marathi'), ('my', 'Burmese'),
('nb', 'Norwegian Bokmål'), ('ne', 'Nepali'),
('nl', 'Dutch'), ('nn', 'Norwegian Nynorsk'),
('os', 'Ossetic'), ('pa', 'Punjabi'), ('pl', 'Polish'),
('pt', 'Portuguese'), ('pt-br', 'Brazilian Portuguese'),
('ro', 'Romanian'), ('ru', 'Russian'), ('sk', 'Slovak'),
('sl', 'Slovenian'), ('sq', 'Albanian'),
('sr', 'Serbian'), ('sr-latn', 'Serbian Latin'),
('sv', 'Swedish'), ('sw', 'Swahili'), ('ta', 'Tamil'),
('te', 'Telugu'), ('th', 'Thai'), ('tr', 'Turkish'),
('tt', 'Tatar'), ('udm', 'Udmurt'), ('uk', 'Ukrainian'),
('ur', 'Urdu'), ('vi', 'Vietnamese'),
('zh-hans', 'Simplified Chinese'),
('zh-hant', 'Traditional Chinese')
],
max_length=7)),
('question_text', models.TextField()),
],
),
migrations.CreateModel(
name='SecurityQuestion',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('question_text',
models.TextField(help_text='Default question text')),
],
),
migrations.CreateModel(
name='UserSecurityQuestion',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('answer', models.TextField(verbose_name='answer')),
('language_code',
models.CharField(choices=[
('af', 'Afrikaans'), ('ar', 'Arabic'),
('ast', 'Asturian'), ('az', 'Azerbaijani'),
('bg', 'Bulgarian'), ('be', 'Belarusian'),
('bn', 'Bengali'), ('br', 'Breton'), ('bs', 'Bosnian'),
('ca', 'Catalan'), ('cs', 'Czech'), ('cy', 'Welsh'),
('da', 'Danish'), ('de', 'German'),
('dsb', 'Lower Sorbian'), ('el', 'Greek'),
('en', 'English'), ('en-au', 'Australian English'),
('en-gb', 'British English'), ('eo', 'Esperanto'),
('es', 'Spanish'), ('es-ar', 'Argentinian Spanish'),
('es-co', 'Colombian Spanish'),
('es-mx', 'Mexican Spanish'),
('es-ni', 'Nicaraguan Spanish'),
('es-ve', 'Venezuelan Spanish'), ('et', 'Estonian'),
('eu', 'Basque'), ('fa', 'Persian'), ('fi', 'Finnish'),
('fr', 'French'), ('fy', 'Frisian'), ('ga', 'Irish'),
('gd', 'Scottish Gaelic'), ('gl', 'Galician'),
('he', 'Hebrew'), ('hi', 'Hindi'), ('hr', 'Croatian'),
('hsb', 'Upper Sorbian'), ('hu', 'Hungarian'),
('ia', 'Interlingua'),
('id', 'Indonesian'), ('io', 'Ido'), ('is', 'Icelandic'),
('it', 'Italian'), ('ja', 'Japanese'), ('ka', 'Georgian'),
('kk', 'Kazakh'), ('km', 'Khmer'), ('kn', 'Kannada'),
('ko', 'Korean'), ('lb', 'Luxembourgish'),
('lt', 'Lithuanian'), ('lv', 'Latvian'),
('mk', 'Macedonian'), ('ml', 'Malayalam'),
('mn', 'Mongolian'), ('mr', 'Marathi'), ('my', 'Burmese'),
('nb', 'Norwegian Bokmål'), ('ne', 'Nepali'),
('nl', 'Dutch'), ('nn', 'Norwegian Nynorsk'),
('os', 'Ossetic'), ('pa', 'Punjabi'), ('pl', 'Polish'),
('pt', 'Portuguese'), ('pt-br', 'Brazilian Portuguese'),
('ro', 'Romanian'), ('ru', 'Russian'), ('sk', 'Slovak'),
('sl', 'Slovenian'), ('sq', 'Albanian'),
('sr', 'Serbian'), ('sr-latn', 'Serbian Latin'),
('sv', 'Swedish'), ('sw', 'Swahili'), ('ta', 'Tamil'),
('te', 'Telugu'), ('th', 'Thai'), ('tr', 'Turkish'),
('tt', 'Tatar'), ('udm', 'Udmurt'), ('uk', 'Ukrainian'),
('ur', 'Urdu'), ('vi', 'Vietnamese'),
('zh-hans', 'Simplified Chinese'),
('zh-hant', 'Traditional Chinese')
],
max_length=7)),
('question',
models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to='authentication_service.SecurityQuestion')),
('user',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
],
),
migrations.AddField(
model_name='questionlanguagetext',
name='question',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to='authentication_service.SecurityQuestion'),
),
migrations.AddField(
model_name='coreuser',
name='country',
field=models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.CASCADE,
to='authentication_service.Country'),
),
migrations.AddField(
model_name='coreuser',
name='groups',
field=models.ManyToManyField(
blank=True,
help_text=
'The groups this user belongs to. A user will get all permissions granted to each of their groups.',
related_name='user_set',
related_query_name='user',
to='auth.Group',
verbose_name='groups'),
),
migrations.AddField(
model_name='coreuser',
name='user_permissions',
field=models.ManyToManyField(
blank=True,
help_text='Specific permissions for this user.',
related_name='user_set',
related_query_name='user',
to='auth.Permission',
verbose_name='user permissions'),
),
migrations.RemoveField(
model_name='coreuser',
name='is_employee',
),
migrations.RemoveField(
model_name='coreuser',
name='is_system_user',
),
migrations.AlterField(
model_name='coreuser',
name='birth_date',
field=models.DateField(default=datetime.date(2000, 1, 1)),
preserve_default=False,
),
migrations.CreateModel(
name='OrganisationalUnit',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=100, unique=True)),
('description', models.TextField()),
('created_at', models.DateTimeField(auto_now_add=True)),
('updated_at', models.DateTimeField(auto_now=True)),
],
),
migrations.AddField(
model_name='coreuser',
name='organisational_unit',
field=models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.CASCADE,
to='authentication_service.OrganisationalUnit'),
),
migrations.AddField(
model_name='coreuser',
name='created_at',
field=models.DateTimeField(auto_now_add=True,
default=django.utils.timezone.now),
preserve_default=False,
),
migrations.AlterModelOptions(
name='coreuser',
options={},
),
migrations.AddField(
model_name='coreuser',
name='q',
field=authentication_service.models.AutoQueryField(default=''),
preserve_default=False,
),
migrations.AlterField(
model_name='coreuser',
name='country',
field=models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.CASCADE,
to='authentication_service.Country',
verbose_name='country'),
),
migrations.AlterField(
model_name='coreuser',
name='gender',
field=models.CharField(blank=True,
choices=[('female', 'Female'),
('male', 'Male'),
('other', 'Other')],
max_length=10,
null=True,
verbose_name='gender'),
),
migrations.AddIndex(
model_name='coreuser',
index=models.Index(fields=['date_joined'],
name='authenticat_date_jo_188bff_idx'),
),
migrations.AddIndex(
model_name='coreuser',
index=models.Index(fields=['gender'],
name='authenticat_gender_277866_idx'),
),
migrations.AddIndex(
model_name='coreuser',
index=models.Index(fields=['last_login'],
name='authenticat_last_lo_f8ef1c_idx'),
),
migrations.AddIndex(
model_name='coreuser',
index=models.Index(fields=['updated_at'],
name='authenticat_updated_766884_idx'),
),
migrations.AddIndex(
model_name='coreuser',
index=partial_index.PartialIndex(
fields=['is_active'],
name='authenticat_is_acti_7ff3d3_partial',
unique=False,
where='',
where_postgresql='is_active = false',
where_sqlite=''),
),
migrations.AddIndex(
model_name='coreuser',
index=partial_index.PartialIndex(
fields=['email_verified'],
name='authenticat_email_v_74d3e8_partial',
unique=False,
where='',
where_postgresql='email_verified = true',
where_sqlite=''),
),
migrations.AddIndex(
model_name='coreuser',
index=partial_index.PartialIndex(
fields=['msisdn_verified'],
name='authenticat_msisdn__e2202e_partial',
unique=False,
where='',
where_postgresql='msisdn_verified = true',
where_sqlite=''),
),
migrations.AddIndex(
model_name='coreuser',
index=authentication_service.models.TrigramIndex(
fields=['username'], name='authenticat_usernam_ee0130_gin'),
),
migrations.AddIndex(
model_name='coreuser',
index=authentication_service.models.TrigramIndex(
fields=['email'], name='authenticat_email_84c43b_gin'),
),
migrations.AddIndex(
model_name='coreuser',
index=authentication_service.models.TrigramIndex(
fields=['first_name'], name='authenticat_first_n_9c2690_gin'),
),
migrations.AddIndex(
model_name='coreuser',
index=authentication_service.models.TrigramIndex(
fields=['last_name'], name='authenticat_last_na_40dea2_gin'),
),
migrations.AddIndex(
model_name='coreuser',
index=authentication_service.models.TrigramIndex(
fields=['nickname'], name='authenticat_nicknam_ba9efc_gin'),
),
migrations.AddIndex(
model_name='coreuser',
index=authentication_service.models.TrigramIndex(
fields=['q'], name='authenticat_q_2fcb4b_gin'),
),
migrations.AlterField(
model_name='coreuser',
name='q',
field=authentication_service.models.AutoQueryField(null=True),
),
migrations.AddIndex(
model_name='coreuser',
index=authentication_service.models.TrigramIndex(
fields=['msisdn'], name='authenticat_msisdn_848b4b_gin'),
),
migrations.CreateModel(
name='UserSite',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('site_id', models.IntegerField()),
('consented_at', models.DateTimeField(auto_now_add=True)),
('created_at', models.DateTimeField(auto_now_add=True)),
('updated_at', models.DateTimeField(auto_now=True)),
('user',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
],
),
migrations.AddIndex(
model_name='usersite',
index=models.Index(fields=['site_id'],
name='authenticat_site_id_45d2c8_idx'),
),
migrations.AlterUniqueTogether(
name='usersite',
unique_together=set([('user', 'site_id')]),
),
migrations.AddField(
model_name='coreuser',
name='migration_data',
field=django.contrib.postgres.fields.jsonb.JSONField(blank=True,
default={}),
),
migrations.AlterField(
model_name='questionlanguagetext',
name='language_code',
field=models.CharField(choices=[
('af', 'Afrikaans'), ('ar', 'Arabic'), ('ast', 'Asturian'),
('az', 'Azerbaijani'),
('bg', 'Bulgarian'), ('be', 'Belarusian'), ('bn', 'Bengali'),
('br', 'Breton'), ('bs', 'Bosnian'), ('ca', 'Catalan'),
('cs', 'Czech'), ('cy', 'Welsh'), ('da', 'Danish'),
('de', 'German'), ('dsb', 'Lower Sorbian'), ('el', 'Greek'),
('en', 'English'), ('en-au', 'Australian English'),
('en-gb', 'British English'), ('eo', 'Esperanto'),
('es', 'Spanish'), ('es-ar', 'Argentinian Spanish'),
('es-co', 'Colombian Spanish'), ('es-mx', 'Mexican Spanish'),
('es-ni', 'Nicaraguan Spanish'), ('es-ve',
'Venezuelan Spanish'),
('et', 'Estonian'), ('eu', 'Basque'), ('fa', 'Persian'),
('fi', 'Finnish'), ('fr', 'French'), ('fy', 'Frisian'),
('ga', 'Irish'), ('gd', 'Scottish Gaelic'), ('gl', 'Galician'),
('he', 'Hebrew'), ('hi', 'Hindi'), ('hr', 'Croatian'),
('hsb', 'Upper Sorbian'), ('hu', 'Hungarian'),
('ia', 'Interlingua'), ('id', 'Indonesian'), ('io', 'Ido'),
('is', 'Icelandic'), ('it', 'Italian'), ('ja', 'Japanese'),
('ka', 'Georgian'), ('kk', 'Kazakh'), ('km', 'Khmer'),
('kn', 'Kannada'), ('ko', 'Korean'), ('lb', 'Luxembourgish'),
('lt', 'Lithuanian'), ('lv', 'Latvian'), ('mk', 'Macedonian'),
('ml', 'Malayalam'), ('mn', 'Mongolian'), ('mr', 'Marathi'),
('my', 'Burmese'), ('nb', 'Norwegian Bokmål'),
('ne', 'Nepali'), ('nl', 'Dutch'), ('nn', 'Norwegian Nynorsk'),
('os', 'Ossetic'), ('pa', 'Punjabi'), ('pl', 'Polish'),
('pt', 'Portuguese'), ('pt-br', 'Brazilian Portuguese'),
('ro', 'Romanian'), ('ru', 'Russian'), ('sk', 'Slovak'),
('sl', 'Slovenian'), ('sq', 'Albanian'), ('sr', 'Serbian'),
('sr-latn', 'Serbian Latin'), ('sv', 'Swedish'),
('sw', 'Swahili'), ('ta', 'Tamil'), ('te', 'Telugu'),
('th', 'Thai'), ('tr', 'Turkish'), ('tt', 'Tatar'),
('udm', 'Udmurt'), ('uk', 'Ukrainian'), ('ur', 'Urdu'),
('vi', 'Vietnamese'), ('zh-hans', 'Simplified Chinese'),
('zh-hant', 'Traditional Chinese'), ('tl', 'Tagalog'),
('rw', 'Kinyarwanda'), ('ha', 'Hausa'), ('bn', 'Bengali'),
('my', 'Burmese'), ('ny', 'Chichewa'), ('prs', 'Dari')
],
max_length=7),
),
migrations.AlterField(
model_name='usersecurityquestion',
name='language_code',
field=models.CharField(choices=[
('af', 'Afrikaans'), ('ar', 'Arabic'), ('ast', 'Asturian'),
('az', 'Azerbaijani'),
('bg', 'Bulgarian'), ('be', 'Belarusian'), ('bn', 'Bengali'),
('br', 'Breton'), ('bs', 'Bosnian'), ('ca', 'Catalan'),
('cs', 'Czech'), ('cy', 'Welsh'), ('da', 'Danish'),
('de', 'German'), ('dsb', 'Lower Sorbian'), ('el', 'Greek'),
('en', 'English'), ('en-au', 'Australian English'),
('en-gb', 'British English'), ('eo', 'Esperanto'),
('es', 'Spanish'), ('es-ar', 'Argentinian Spanish'),
('es-co', 'Colombian Spanish'), ('es-mx', 'Mexican Spanish'),
('es-ni', 'Nicaraguan Spanish'), ('es-ve',
'Venezuelan Spanish'),
('et', 'Estonian'), ('eu', 'Basque'), ('fa', 'Persian'),
('fi', 'Finnish'), ('fr', 'French'), ('fy', 'Frisian'),
('ga', 'Irish'), ('gd', 'Scottish Gaelic'), ('gl', 'Galician'),
('he', 'Hebrew'), ('hi', 'Hindi'), ('hr', 'Croatian'),
('hsb', 'Upper Sorbian'), ('hu', 'Hungarian'),
('ia', 'Interlingua'), ('id', 'Indonesian'), ('io', 'Ido'),
('is', 'Icelandic'), ('it', 'Italian'), ('ja', 'Japanese'),
('ka', 'Georgian'), ('kk', 'Kazakh'), ('km', 'Khmer'),
('kn', 'Kannada'), ('ko', 'Korean'), ('lb', 'Luxembourgish'),
('lt', 'Lithuanian'), ('lv', 'Latvian'), ('mk', 'Macedonian'),
('ml', 'Malayalam'), ('mn', 'Mongolian'), ('mr', 'Marathi'),
('my', 'Burmese'), ('nb', 'Norwegian Bokmål'),
('ne', 'Nepali'), ('nl', 'Dutch'), ('nn', 'Norwegian Nynorsk'),
('os', 'Ossetic'), ('pa', 'Punjabi'), ('pl', 'Polish'),
('pt', 'Portuguese'), ('pt-br', 'Brazilian Portuguese'),
('ro', 'Romanian'), ('ru', 'Russian'), ('sk', 'Slovak'),
('sl', 'Slovenian'), ('sq', 'Albanian'), ('sr', 'Serbian'),
('sr-latn', 'Serbian Latin'), ('sv', 'Swedish'),
('sw', 'Swahili'), ('ta', 'Tamil'), ('te', 'Telugu'),
('th', 'Thai'), ('tr', 'Turkish'), ('tt', 'Tatar'),
('udm', 'Udmurt'), ('uk', 'Ukrainian'), ('ur', 'Urdu'),
('vi', 'Vietnamese'), ('zh-hans', 'Simplified Chinese'),
('zh-hant', 'Traditional Chinese'), ('tl', 'Tagalog'),
('rw', 'Kinyarwanda'), ('ha', 'Hausa'), ('bn', 'Bengali'),
('my', 'Burmese'), ('ny', 'Chichewa'), ('prs', 'Dari')
],
max_length=7),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
]
operations = [
migrations.CreateModel(
name='Company',
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)),
('company_id',
models.UUIDField(default=uuid.uuid4,
editable=False,
unique=True,
verbose_name='company id')),
('name',
django.contrib.postgres.fields.citext.CICharField(
max_length=100, unique=True)),
('address',
django.contrib.postgres.fields.citext.CITextField()),
('is_verified', models.BooleanField(default=False)),
('is_active', models.BooleanField(default=True)),
('logo', models.ImageField(upload_to='company/logo/')),
],
options={
'abstract': False,
},
),
migrations.CreateModel(
name='Link',
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)),
('name',
models.PositiveIntegerField(
choices=[(0, 'TWITTER'), (2, 'GOOGLE'), (1,
'FACEBOOK')])),
('url', models.URLField()),
('company',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='links',
to='company.Company')),
],
),
migrations.CreateModel(
name='UserCompany',
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)),
('designation',
models.PositiveIntegerField(choices=[(0, 'HR'), (
1, 'CEO'), (2, 'CTO'), (3, 'SDE-1'), (4, 'SDE-2')])),
('join_on', models.DateTimeField()),
('inactive_on', models.DateTimeField(null=True)),
('status',
models.PositiveIntegerField(
choices=[(1, 'ACTIVE'), (0, 'INVITED'), (2,
'INACTIVE')])),
('is_admin', models.BooleanField(default=False)),
('company',
models.ForeignKey(on_delete=django.db.models.deletion.PROTECT,
related_name='users',
to='company.Company')),
('user',
models.ForeignKey(on_delete=django.db.models.deletion.PROTECT,
related_name='companies',
to=settings.AUTH_USER_MODEL)),
],
),
migrations.AddIndex(
model_name='usercompany',
index=partial_index.PartialIndex(
fields=['user', 'company'],
name='company_use_user_id_ad6b21_partial',
unique=True,
where=partial_index.PQ(status__in=(0, 1))),
),
migrations.AlterUniqueTogether(
name='link',
unique_together=set([('company', 'name')]),
),
]