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')]), ), ]