# Generated by Django 4.1.1 on 2024-04-07 15:27 from django.conf import settings from django.db import migrations, models import django.db.models.deletion import django.utils.timezone class Migration(migrations.Migration): initial = True dependencies = [ ('auth', '0012_alter_user_first_name_max_length'), ] operations = [ migrations.CreateModel( name='User', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('password', models.CharField(max_length=128, verbose_name='password')), ('last_login', models.DateTimeField(blank=True, null=True, verbose_name='last login')), ('is_superuser', models.BooleanField(default=False, help_text='Designates that this user has all permissions without explicitly assigning them.', verbose_name='superuser status')), ('first_name', models.CharField(blank=True, max_length=150, verbose_name='first name')), ('last_name', models.CharField(blank=True, max_length=150, verbose_name='last name')), ('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')), ('email', models.EmailField(max_length=254, unique=True, verbose_name='Email address')), ('phone', models.CharField(blank=True, max_length=10, null=True, verbose_name='Phone Number')), ('location', models.CharField(blank=True, max_length=100, null=True, verbose_name='Location')), ('company', models.CharField(blank=True, max_length=300, null=True, verbose_name='Company Name')), ('user_type', models.CharField(blank=True, choices=[('1', 'Employee'), ('2', 'Client')], max_length=8, null=True)), ('img', models.FileField(blank=True, null=True, upload_to='media')), ('token', models.CharField(blank=True, max_length=255, null=True)), ('groups', models.ManyToManyField(blank=True, help_text='The groups this user belongs to. A user will get all permissions granted to each of their groups.', related_name='user_set', related_query_name='user', to='auth.group', verbose_name='groups')), ('user_permissions', models.ManyToManyField(blank=True, help_text='Specific permissions for this user.', related_name='user_set', related_query_name='user', to='auth.permission', verbose_name='user permissions')), ], options={ 'verbose_name': 'user', 'verbose_name_plural': 'users', 'abstract': False, }, ), migrations.CreateModel( name='CarParking', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('length', models.CharField(blank=True, max_length=100, null=True)), ('width', models.CharField(blank=True, max_length=100, null=True)), ('height', models.CharField(blank=True, max_length=100, null=True)), ('area', models.CharField(blank=True, max_length=100, null=True)), ('ach', models.CharField(blank=True, max_length=100, null=True)), ('ExAir', models.CharField(blank=True, max_length=100, null=True)), ('FA', models.CharField(blank=True, max_length=100, null=True)), ('createdate', models.DateTimeField(auto_now_add=True, verbose_name='Date')), ], ), migrations.CreateModel( name='datafile', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('file', models.FileField(blank=True, null=True, upload_to='media')), ('date', models.DateTimeField(auto_now_add=True)), ], ), migrations.CreateModel( name='FireDetectionHistory', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('sparepartrequired', models.CharField(blank=True, max_length=10, null=True)), ('remarks', models.TextField(blank=True, null=True)), ('sparepartitemrequired', models.TextField(blank=True, null=True)), ('specs_of_panel', models.CharField(blank=True, max_length=100, null=True)), ('type_of_system', models.CharField(blank=True, max_length=50, null=True)), ('make', models.CharField(blank=True, max_length=50, null=True)), ('loops_zone', models.CharField(blank=True, max_length=50, null=True)), ('repeater_panel', models.CharField(blank=True, max_length=50, null=True)), ('isolator_module', models.CharField(blank=True, max_length=50, null=True)), ('heat_detector', models.CharField(blank=True, max_length=50, null=True)), ('flame_detector', models.CharField(blank=True, max_length=50, null=True)), ('smoke_detector', models.CharField(blank=True, max_length=50, null=True)), ('multi_detector', models.CharField(blank=True, max_length=50, null=True)), ('gas_detector', models.TextField(blank=True, null=True)), ('beam_detector', models.CharField(blank=True, max_length=50, null=True)), ('manual_call_point', models.CharField(blank=True, max_length=50, null=True)), ('hooter_cum_sounder', models.CharField(blank=True, max_length=50, null=True)), ('zone_monitor_module', models.CharField(blank=True, max_length=50, null=True)), ('monitor_module', models.CharField(blank=True, max_length=50, null=True)), ('control_module', models.CharField(blank=True, max_length=50, null=True)), ('power_supply_unit', models.CharField(blank=True, max_length=50, null=True)), ('zener_barrier', models.CharField(blank=True, max_length=50, null=True)), ('siren', models.CharField(blank=True, max_length=50, null=True)), ('cables', models.CharField(blank=True, max_length=50, null=True)), ('special_detector', models.CharField(blank=True, max_length=50, null=True)), ('battery_backup', models.CharField(blank=True, max_length=50, null=True)), ('location', models.TextField(blank=True, null=True)), ('image', models.FileField(blank=True, null=True, upload_to='media')), ('comment', models.TextField(blank=True, null=True)), ('health', models.CharField(blank=True, max_length=50, null=True)), ('client_comment', models.TextField(blank=True, null=True)), ('client_image', models.FileField(blank=True, null=True, upload_to='media')), ('createdate', models.DateTimeField(auto_now_add=True, verbose_name='Date')), ('updatedate', models.DateTimeField(auto_now=True, verbose_name='Date')), ('clientid', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='firedetectionhis_client', to=settings.AUTH_USER_MODEL)), ('empid', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='firedetectionhis_emp', to=settings.AUTH_USER_MODEL)), ], ), migrations.CreateModel( name='FirePumpHistory', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('sparepartrequired', models.CharField(blank=True, max_length=10, null=True)), ('remarks', models.TextField(blank=True, null=True)), ('sparepartitemrequired', models.TextField(blank=True, null=True)), ('hp', models.TextField(blank=True, null=True)), ('head', models.CharField(blank=True, max_length=124, null=True)), ('kw', models.CharField(blank=True, max_length=50, null=True)), ('pumpno', models.CharField(blank=True, max_length=50, null=True)), ('pumptype', models.CharField(blank=True, max_length=55, null=True)), ('rpm', models.CharField(blank=True, max_length=50, null=True)), ('motorno', models.CharField(blank=True, max_length=50, null=True)), ('make', models.CharField(blank=True, max_length=50, null=True)), ('pumptypeno', models.CharField(blank=True, max_length=50, null=True)), ('systempressure', models.CharField(blank=True, max_length=50, null=True)), ('systemflow', models.CharField(blank=True, max_length=50, null=True)), ('systemwatertank', models.CharField(blank=True, max_length=50, null=True)), ('systemhelth', models.CharField(blank=True, max_length=50, null=True)), ('location', models.TextField(blank=True, null=True)), ('image', models.FileField(blank=True, null=True, upload_to='media')), ('comment', models.TextField(blank=True, null=True)), ('health', models.CharField(blank=True, max_length=50, null=True)), ('client_comment', models.TextField(blank=True, null=True)), ('client_image', models.FileField(blank=True, null=True, upload_to='media')), ('createdate', models.DateTimeField(auto_now_add=True, verbose_name='Date')), ('updatedate', models.DateTimeField(auto_now=True, verbose_name='Date')), ('clientid', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='firepumphis_client', to=settings.AUTH_USER_MODEL)), ('empid', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='firepumphis_emp', to=settings.AUTH_USER_MODEL)), ], ), migrations.CreateModel( name='Homepage', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('video', models.TextField(blank=True, null=True)), ('about', models.TextField(blank=True, null=True)), ], ), migrations.CreateModel( name='materialform', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('material', models.CharField(blank=True, max_length=255, null=True)), ('c_value', models.CharField(blank=True, max_length=100, null=True)), ('createdate', models.DateTimeField(auto_now_add=True, verbose_name='Date')), ], ), migrations.CreateModel( name='MechanicalVentilation', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('layerheight', models.CharField(blank=True, max_length=255, null=True)), ('fire_size', models.CharField(blank=True, max_length=100, null=True)), ('pfrate', models.CharField(blank=True, max_length=100, null=True)), ('HGLtemp', models.CharField(blank=True, max_length=100, null=True)), ('firesizeQ', models.CharField(blank=True, max_length=100, null=True)), ('specificheat', models.CharField(blank=True, max_length=100, null=True)), ('heattransfercoeff', models.CharField(blank=True, max_length=100, null=True)), ('Compartmentlength', models.CharField(blank=True, max_length=100, null=True)), ('Compartmentwidth', models.CharField(blank=True, max_length=100, null=True)), ('Compartmentheight', models.CharField(blank=True, max_length=100, null=True)), ('areaodwalls', models.CharField(blank=True, max_length=100, null=True)), ('HCLTemparature', models.CharField(blank=True, max_length=100, null=True)), ('densityHGLrho', models.CharField(blank=True, max_length=100, null=True)), ('fanflowrate_v_e', models.CharField(blank=True, max_length=100, null=True)), ('fanflowrate_ve', models.CharField(blank=True, max_length=100, null=True)), ('createdate', models.DateTimeField(auto_now_add=True, verbose_name='Date')), ], ), migrations.CreateModel( name='Product', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('pname', models.CharField(max_length=50)), ('image', models.FileField(blank=True, null=True, upload_to='media')), ('type', models.CharField(blank=True, max_length=14, null=True)), ('date', models.DateTimeField(auto_now_add=True, verbose_name='Date')), ], ), migrations.CreateModel( name='SiteModelProduct', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('modelno', models.CharField(blank=True, db_index=True, max_length=24, null=True, unique=True)), ('unit', models.CharField(blank=True, max_length=200, null=True)), ('location', models.CharField(blank=True, max_length=100, null=True)), ('status', models.CharField(blank=True, max_length=6, null=True)), ('disable', models.BooleanField(default=False)), ('createdate', models.DateTimeField(auto_now_add=True, verbose_name='Date')), ('clientid', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='smp_client', to=settings.AUTH_USER_MODEL)), ('empid', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='smp_emp', to=settings.AUTH_USER_MODEL)), ('pid', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='smp_product_id', to='mfire.product')), ], ), migrations.CreateModel( name='SmokeVentilation', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('Actual_HRR', models.CharField(blank=True, max_length=255, null=True)), ('Ceilling_area', models.CharField(blank=True, max_length=100, null=True)), ('NDheightHRR', models.CharField(blank=True, max_length=100, null=True)), ('smokelayerheight', models.CharField(blank=True, max_length=100, null=True)), ('NonDiamentionalheight_y', models.CharField(blank=True, max_length=100, null=True)), ('mquantitties', models.CharField(blank=True, max_length=100, null=True)), ('Tau', models.CharField(blank=True, max_length=100, null=True)), ('Accelerationduegravity', models.CharField(blank=True, max_length=100, null=True)), ('lenghtofroom', models.CharField(blank=True, max_length=100, null=True)), ('widthofroom', models.CharField(blank=True, max_length=100, null=True)), ('floorarea', models.CharField(blank=True, max_length=100, null=True)), ('ttfctslheight', models.CharField(blank=True, max_length=100, null=True)), ('createdate', models.DateTimeField(auto_now_add=True, verbose_name='Date')), ], ), migrations.CreateModel( name='staffform', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('type_material', models.CharField(blank=True, max_length=255, null=True)), ('c_value', models.CharField(blank=True, max_length=100, null=True)), ('length', models.CharField(blank=True, max_length=100, null=True)), ('width', models.CharField(blank=True, max_length=100, null=True)), ('height', models.CharField(blank=True, max_length=100, null=True)), ('quantity', models.CharField(blank=True, max_length=100, null=True)), ('areasqrmtr', models.CharField(blank=True, max_length=100, null=True)), ('area', models.CharField(blank=True, max_length=100, null=True)), ('city', models.CharField(blank=True, max_length=100, null=True)), ('state', models.CharField(blank=True, max_length=100, null=True)), ('zone', models.CharField(blank=True, max_length=100, null=True)), ('sub_area', models.CharField(blank=True, max_length=100, null=True)), ('flv', models.CharField(blank=True, max_length=100, null=True)), ('thrishul', models.CharField(blank=True, max_length=100, null=True)), ('grade', models.CharField(blank=True, max_length=100, null=True)), ('hours', models.CharField(blank=True, max_length=100, null=True)), ('createdate', models.DateTimeField(auto_now_add=True, verbose_name='Date')), ], ), migrations.CreateModel( name='SuppresionSystemHistory', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('sparepartrequired', models.CharField(blank=True, max_length=10, null=True)), ('remarks', models.TextField(blank=True, null=True)), ('sparepartitemrequired', models.TextField(blank=True, null=True)), ('specs_of_supression_system', models.CharField(blank=True, max_length=100, null=True)), ('specs_of_panel_and_make', models.CharField(blank=True, max_length=100, null=True)), ('type_of_system', models.CharField(blank=True, max_length=50, null=True)), ('make', models.CharField(blank=True, max_length=50, null=True)), ('loops_zone', models.CharField(blank=True, max_length=50, null=True)), ('model_no_suppresion', models.CharField(blank=True, max_length=50, null=True)), ('capacity_of_clyinder', models.CharField(blank=True, max_length=50, null=True)), ('no_of_cylinders', models.CharField(blank=True, max_length=50, null=True)), ('empty_weight', models.CharField(blank=True, max_length=50, null=True)), ('full_weight', models.CharField(blank=True, max_length=50, null=True)), ('suppression_gas_filled', models.CharField(blank=True, max_length=50, null=True)), ('pressure_gauage_reading', models.TextField(blank=True, null=True)), ('electromagnetic_actuator', models.CharField(blank=True, max_length=50, null=True)), ('pneumatic_actuator', models.CharField(blank=True, max_length=50, null=True)), ('pressure_supervisory_switch', models.CharField(blank=True, max_length=50, null=True)), ('flexible_discharge_hose', models.CharField(blank=True, max_length=50, null=True)), ('flexible_actuator_hose', models.CharField(blank=True, max_length=50, null=True)), ('nozzles_suppresion', models.CharField(blank=True, max_length=50, null=True)), ('abort_switch', models.CharField(blank=True, max_length=50, null=True)), ('heat_detector', models.CharField(blank=True, max_length=50, null=True)), ('manifold', models.CharField(blank=True, max_length=50, null=True)), ('piping', models.CharField(blank=True, max_length=50, null=True)), ('flame_detector', models.CharField(blank=True, max_length=50, null=True)), ('smoke_detector', models.CharField(blank=True, max_length=50, null=True)), ('multi_detector', models.CharField(blank=True, max_length=50, null=True)), ('gas_detector', models.CharField(blank=True, max_length=50, null=True)), ('vesda_detector_panel', models.CharField(blank=True, max_length=50, null=True)), ('manual_call_point', models.CharField(blank=True, max_length=50, null=True)), ('hooter_cum_sounder', models.CharField(blank=True, max_length=50, null=True)), ('zone_monitor_module', models.CharField(blank=True, max_length=50, null=True)), ('monitor_module', models.CharField(blank=True, max_length=50, null=True)), ('control_module', models.CharField(blank=True, max_length=50, null=True)), ('power_supply_unit', models.CharField(blank=True, max_length=50, null=True)), ('manual_gas_release_switch', models.CharField(blank=True, max_length=250, null=True)), ('siren', models.CharField(blank=True, max_length=50, null=True)), ('cables', models.CharField(blank=True, max_length=50, null=True)), ('special_detector', models.CharField(blank=True, max_length=50, null=True)), ('battery_backup', models.CharField(blank=True, max_length=50, null=True)), ('location', models.TextField(blank=True, null=True)), ('image', models.FileField(blank=True, null=True, upload_to='media')), ('comment', models.TextField(blank=True, null=True)), ('health', models.CharField(blank=True, max_length=50, null=True)), ('client_comment', models.TextField(blank=True, null=True)), ('client_image', models.FileField(blank=True, null=True, upload_to='media')), ('createdate', models.DateTimeField(auto_now_add=True, verbose_name='Date')), ('updatedate', models.DateTimeField(auto_now_add=True, verbose_name='Date')), ('clientid', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='suppreionsystemhis_client', to=settings.AUTH_USER_MODEL)), ('empid', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='suppreionsystemhis_emp', to=settings.AUTH_USER_MODEL)), ('smpid', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='suppreionsystemhis_smpid', to='mfire.sitemodelproduct')), ], ), migrations.CreateModel( name='thrishulform', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('thrishul', models.CharField(blank=True, max_length=255, null=True)), ('grade', models.CharField(blank=True, max_length=100, null=True)), ('hours', models.CharField(blank=True, max_length=100, null=True)), ], ), migrations.CreateModel( name='SuppresionSystemService', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('details', models.TextField(blank=True, null=True)), ('details_lable', models.TextField(blank=True, null=True)), ('service_location', models.TextField(blank=True, null=True)), ('qty_required', models.TextField(blank=True, null=True)), ('service_remarks', models.TextField(blank=True, null=True)), ('createdate', models.DateTimeField(auto_now_add=True, verbose_name='Date')), ('updatedate', models.DateTimeField(auto_now_add=True, verbose_name='Date')), ('suppresion_system_id', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='suppreionsystemservice_ssid', to='mfire.suppresionsystemhistory')), ], ), migrations.CreateModel( name='SuppresionSystem', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('sparepartrequired', models.CharField(blank=True, max_length=10, null=True)), ('remarks', models.TextField(blank=True, null=True)), ('sparepartitemrequired', models.TextField(blank=True, null=True)), ('specs_of_supression_system', models.CharField(blank=True, max_length=100, null=True)), ('specs_of_panel_and_make', models.CharField(blank=True, max_length=100, null=True)), ('type_of_system', models.CharField(blank=True, max_length=50, null=True)), ('make', models.CharField(blank=True, max_length=50, null=True)), ('loops_zone', models.CharField(blank=True, max_length=50, null=True)), ('model_no_suppresion', models.CharField(blank=True, max_length=50, null=True)), ('capacity_of_clyinder', models.CharField(blank=True, max_length=50, null=True)), ('no_of_cylinders', models.CharField(blank=True, max_length=50, null=True)), ('empty_weight', models.CharField(blank=True, max_length=50, null=True)), ('full_weight', models.CharField(blank=True, max_length=50, null=True)), ('suppression_gas_filled', models.CharField(blank=True, max_length=50, null=True)), ('pressure_gauage_reading', models.TextField(blank=True, null=True)), ('electromagnetic_actuator', models.CharField(blank=True, max_length=50, null=True)), ('pneumatic_actuator', models.CharField(blank=True, max_length=50, null=True)), ('pressure_supervisory_switch', models.CharField(blank=True, max_length=250, null=True)), ('flexible_discharge_hose', models.CharField(blank=True, max_length=50, null=True)), ('flexible_actuator_hose', models.CharField(blank=True, max_length=50, null=True)), ('nozzles_suppresion', models.CharField(blank=True, max_length=50, null=True)), ('abort_switch', models.CharField(blank=True, max_length=50, null=True)), ('heat_detector', models.CharField(blank=True, max_length=50, null=True)), ('manifold', models.CharField(blank=True, max_length=50, null=True)), ('piping', models.CharField(blank=True, max_length=50, null=True)), ('flame_detector', models.CharField(blank=True, max_length=50, null=True)), ('smoke_detector', models.CharField(blank=True, max_length=50, null=True)), ('multi_detector', models.CharField(blank=True, max_length=50, null=True)), ('gas_detector', models.CharField(blank=True, max_length=50, null=True)), ('vesda_detector_panel', models.CharField(blank=True, max_length=50, null=True)), ('manual_call_point', models.CharField(blank=True, max_length=50, null=True)), ('hooter_cum_sounder', models.CharField(blank=True, max_length=50, null=True)), ('zone_monitor_module', models.CharField(blank=True, max_length=50, null=True)), ('monitor_module', models.CharField(blank=True, max_length=50, null=True)), ('control_module', models.CharField(blank=True, max_length=50, null=True)), ('power_supply_unit', models.CharField(blank=True, max_length=50, null=True)), ('manual_gas_release_switch', models.CharField(blank=True, max_length=250, null=True)), ('siren', models.CharField(blank=True, max_length=50, null=True)), ('cables', models.CharField(blank=True, max_length=50, null=True)), ('special_detector', models.CharField(blank=True, max_length=50, null=True)), ('battery_backup', models.CharField(blank=True, max_length=50, null=True)), ('p_location', models.TextField(blank=True, null=True)), ('location', models.TextField(blank=True, null=True)), ('image', models.FileField(blank=True, null=True, upload_to='media')), ('comment', models.TextField(blank=True, null=True)), ('health', models.CharField(blank=True, max_length=50, null=True)), ('client_comment', models.TextField(blank=True, null=True)), ('client_image', models.FileField(blank=True, null=True, upload_to='media')), ('createdate', models.DateTimeField(auto_now_add=True, verbose_name='Date')), ('updatedate', models.DateTimeField(auto_now_add=True, verbose_name='Date')), ('clientid', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='suppreionsystem_client', to=settings.AUTH_USER_MODEL)), ('empid', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='suppreionsystem_emp', to=settings.AUTH_USER_MODEL)), ('smpid', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='suppreionsystem_smpid', to='mfire.sitemodelproduct')), ], ), migrations.CreateModel( name='SupportTickets', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('assingnote', models.CharField(blank=True, max_length=300, null=True)), ('clint_name', models.CharField(blank=True, max_length=100, null=True)), ('modelno', models.CharField(blank=True, max_length=100, null=True)), ('tickets_id', models.CharField(blank=True, max_length=100, null=True)), ('subject', models.CharField(blank=True, max_length=100, null=True)), ('message', models.TextField(blank=True, null=True)), ('status', models.CharField(blank=True, choices=[('Open', 'Open'), ('Close', 'Close')], max_length=6, null=True)), ('priority', models.CharField(blank=True, choices=[('High', 'High'), ('Medium', 'Medium'), ('Low', 'Low')], max_length=6, null=True)), ('img', models.FileField(blank=True, null=True, upload_to='media')), ('date', models.DateTimeField(auto_now_add=True)), ('assignemp', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='supporttickets_emp', to=settings.AUTH_USER_MODEL)), ('clientid', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='supporttickets_clints', to=settings.AUTH_USER_MODEL)), ], ), migrations.CreateModel( name='SiteModelProductDetailHistory', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('sparepartitemrequired', models.TextField(blank=True, null=True)), ('feno', models.CharField(blank=True, max_length=16, null=True)), ('fetype', models.CharField(blank=True, max_length=16, null=True)), ('capacity', models.CharField(blank=True, max_length=24, null=True)), ('mfgyear', models.TextField(blank=True, null=True)), ('emptycylinderpressure', models.CharField(blank=True, max_length=24, null=True)), ('fullcylinderpressure', models.CharField(blank=True, max_length=24, null=True)), ('netpressure', models.CharField(blank=True, max_length=24, null=True)), ('lastdaterefilling', models.DateField(blank=True, null=True)), ('duedaterefiiling', models.DateField(blank=True, null=True)), ('lastdatehpt', models.DateField(blank=True, null=True)), ('duedatehpt', models.DateField(blank=True, null=True)), ('sparepartrequired', models.CharField(blank=True, max_length=124, null=True)), ('remarks', models.TextField(blank=True, null=True)), ('location', models.TextField(blank=True, null=True)), ('image', models.FileField(blank=True, null=True, upload_to='media')), ('comment', models.TextField(blank=True, null=True)), ('health', models.CharField(blank=True, max_length=50, null=True)), ('client_comment', models.TextField(blank=True, null=True)), ('client_image', models.FileField(blank=True, null=True, upload_to='media')), ('createdate', models.DateTimeField(auto_now_add=True, verbose_name='Date')), ('updatedate', models.DateTimeField(auto_now=True, verbose_name='Date')), ('clientid', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='portablemproducthis_client', to=settings.AUTH_USER_MODEL)), ('empid', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='portablemproducthis_emp', to=settings.AUTH_USER_MODEL)), ('smpid', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='portablemproducthis_smpid', to='mfire.sitemodelproduct')), ], ), migrations.CreateModel( name='SiteModelProductDetail', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('sparepartitemrequired', models.TextField(blank=True, null=True)), ('fetype', models.CharField(blank=True, max_length=55, null=True)), ('capacity', models.CharField(blank=True, max_length=24, null=True)), ('mfgyear', models.TextField(blank=True, null=True)), ('emptycylinderpressure', models.CharField(blank=True, max_length=24, null=True)), ('fullcylinderpressure', models.CharField(blank=True, max_length=24, null=True)), ('netpressure', models.CharField(blank=True, max_length=24, null=True)), ('lastdaterefilling', models.DateField(blank=True, null=True)), ('duedaterefiiling', models.DateField(blank=True, null=True)), ('lastdatehpt', models.DateField(blank=True, null=True)), ('duedatehpt', models.DateField(blank=True, null=True)), ('sparepartrequired', models.CharField(blank=True, max_length=124, null=True)), ('remarks', models.TextField(blank=True, null=True)), ('p_location', models.TextField(blank=True, null=True)), ('location', models.TextField(blank=True, null=True)), ('image', models.FileField(blank=True, null=True, upload_to='media')), ('comment', models.TextField(blank=True, null=True)), ('health', models.CharField(blank=True, max_length=50, null=True)), ('client_comment', models.TextField(blank=True, null=True)), ('client_image', models.FileField(blank=True, null=True, upload_to='media')), ('createdate', models.DateTimeField(auto_now_add=True, verbose_name='Date')), ('updatedate', models.DateTimeField(auto_now=True, verbose_name='Date')), ('clientid', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='portablemproductid_client', to=settings.AUTH_USER_MODEL)), ('empid', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='portablemproductid_emp', to=settings.AUTH_USER_MODEL)), ('smpid', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='portablemproductid_smpid', to='mfire.sitemodelproduct')), ], ), migrations.CreateModel( name='ProductScanUser', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('psu_modelno', models.CharField(blank=True, max_length=100, null=True)), ('psu_latitude', models.CharField(blank=True, max_length=100, null=True)), ('psu_longitude', models.CharField(blank=True, max_length=100, null=True)), ('psu_createdate', models.DateTimeField(auto_now_add=True, verbose_name='Date')), ('product_detail_id', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='product_id', to='mfire.product')), ('psu_emp_id', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='emp_id', to=settings.AUTH_USER_MODEL)), ], ), migrations.CreateModel( name='PortableMonitorHistory', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('sparepartrequired', models.CharField(blank=True, max_length=10, null=True)), ('remarks', models.TextField(blank=True, null=True)), ('sparepartitemrequired', models.TextField(blank=True, null=True)), ('type_of_monitor', models.CharField(blank=True, max_length=100, null=True)), ('moc_body', models.CharField(blank=True, max_length=50, null=True)), ('rotation', models.CharField(blank=True, max_length=50, null=True)), ('capacity', models.CharField(blank=True, max_length=50, null=True)), ('flow', models.CharField(blank=True, max_length=50, null=True)), ('pressure', models.CharField(blank=True, max_length=50, null=True)), ('size', models.CharField(blank=True, max_length=50, null=True)), ('throw_range', models.CharField(blank=True, max_length=50, null=True)), ('foam_tank', models.CharField(blank=True, max_length=50, null=True)), ('foam_inductor', models.CharField(blank=True, max_length=50, null=True)), ('handle_rotation_wheel', models.TextField(blank=True, null=True)), ('foam_inductor_pipe', models.CharField(blank=True, max_length=50, null=True)), ('nozzle_type', models.CharField(blank=True, max_length=50, null=True)), ('operation_manual_electric', models.CharField(blank=True, max_length=50, null=True)), ('location', models.TextField(blank=True, null=True)), ('image', models.FileField(blank=True, null=True, upload_to='media')), ('comment', models.TextField(blank=True, null=True)), ('health', models.CharField(blank=True, max_length=50, null=True)), ('client_comment', models.TextField(blank=True, null=True)), ('client_image', models.FileField(blank=True, null=True, upload_to='media')), ('createdate', models.DateTimeField(auto_now_add=True, verbose_name='Date')), ('updatedate', models.DateTimeField(auto_now=True, verbose_name='Date')), ('clientid', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='portablemhis_client', to=settings.AUTH_USER_MODEL)), ('empid', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='portablemhis_emp', to=settings.AUTH_USER_MODEL)), ('smpid', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='portablemhis_smpid', to='mfire.sitemodelproduct')), ], ), migrations.CreateModel( name='PortableMonitor', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('sparepartrequired', models.CharField(blank=True, max_length=10, null=True)), ('remarks', models.TextField(blank=True, null=True)), ('sparepartitemrequired', models.TextField(blank=True, null=True)), ('type_of_monitor', models.CharField(blank=True, max_length=100, null=True)), ('moc_body', models.CharField(blank=True, max_length=50, null=True)), ('rotation', models.CharField(blank=True, max_length=50, null=True)), ('capacity', models.CharField(max_length=50)), ('flow', models.CharField(blank=True, max_length=50, null=True)), ('pressure', models.CharField(blank=True, max_length=50, null=True)), ('size', models.CharField(blank=True, max_length=50, null=True)), ('throw_range', models.CharField(blank=True, max_length=50, null=True)), ('foam_tank', models.CharField(blank=True, max_length=50, null=True)), ('foam_inductor', models.CharField(blank=True, max_length=50, null=True)), ('handle_rotation_wheel', models.TextField(blank=True, null=True)), ('foam_inductor_pipe', models.CharField(blank=True, max_length=50, null=True)), ('nozzle_type', models.CharField(blank=True, max_length=50, null=True)), ('operation_manual_electric', models.CharField(blank=True, max_length=50, null=True)), ('p_location', models.TextField(blank=True, null=True)), ('location', models.TextField(blank=True, null=True)), ('image', models.FileField(blank=True, null=True, upload_to='media')), ('comment', models.TextField(blank=True, null=True)), ('health', models.CharField(blank=True, max_length=50, null=True)), ('client_comment', models.TextField(blank=True, null=True)), ('client_image', models.FileField(blank=True, null=True, upload_to='media')), ('createdate', models.DateTimeField(auto_now_add=True, verbose_name='Date')), ('updatedate', models.DateTimeField(auto_now=True, verbose_name='Date')), ('clientid', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='portablem_client', to=settings.AUTH_USER_MODEL)), ('empid', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='portablem_emp', to=settings.AUTH_USER_MODEL)), ('smpid', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='portablem_smpid', to='mfire.sitemodelproduct')), ], ), migrations.CreateModel( name='HoseReelHistory', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('sparepartrequired', models.CharField(blank=True, max_length=10, null=True)), ('remarks', models.TextField(blank=True, null=True)), ('sparepartitemrequired', models.TextField(blank=True, null=True)), ('observation', models.TextField(blank=True, null=True)), ('action', models.CharField(blank=True, max_length=124, null=True)), ('hosereel', models.CharField(blank=True, max_length=50, null=True)), ('shutoffnozzel', models.CharField(blank=True, max_length=50, null=True)), ('ballvalve', models.CharField(blank=True, max_length=50, null=True)), ('jubliclip', models.CharField(blank=True, max_length=50, null=True)), ('connectingrubberhose', models.CharField(blank=True, max_length=50, null=True)), ('location', models.TextField(blank=True, null=True)), ('image', models.FileField(blank=True, null=True, upload_to='media')), ('comment', models.TextField(blank=True, null=True)), ('health', models.CharField(blank=True, max_length=50, null=True)), ('client_comment', models.TextField(blank=True, null=True)), ('client_image', models.FileField(blank=True, null=True, upload_to='media')), ('createdate', models.DateTimeField(auto_now_add=True, verbose_name='Date')), ('updatedate', models.DateTimeField(auto_now=True, verbose_name='Date')), ('clientid', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='hosereelhis_client', to=settings.AUTH_USER_MODEL)), ('empid', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='hosereelhis_emp', to=settings.AUTH_USER_MODEL)), ('smpid', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='hosereelhis_smpid', to='mfire.sitemodelproduct')), ], ), migrations.CreateModel( name='HoseReel', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('sparepartrequired', models.CharField(blank=True, max_length=10, null=True)), ('remarks', models.TextField(blank=True, null=True)), ('sparepartitemrequired', models.TextField(blank=True, null=True)), ('observation', models.TextField(blank=True, null=True)), ('action', models.CharField(blank=True, max_length=124, null=True)), ('hosereel', models.CharField(blank=True, max_length=50, null=True)), ('shutoffnozzel', models.CharField(blank=True, max_length=50, null=True)), ('ballvalve', models.CharField(blank=True, max_length=50, null=True)), ('jubliclip', models.CharField(blank=True, max_length=50, null=True)), ('connectingrubberhose', models.CharField(blank=True, max_length=50, null=True)), ('p_location', models.TextField(blank=True, null=True)), ('location', models.TextField(blank=True, null=True)), ('image', models.FileField(blank=True, null=True, upload_to='media')), ('comment', models.TextField(blank=True, null=True)), ('health', models.CharField(blank=True, max_length=50, null=True)), ('client_comment', models.TextField(blank=True, null=True)), ('client_image', models.FileField(blank=True, null=True, upload_to='media')), ('createdate', models.DateTimeField(auto_now_add=True, verbose_name='Date')), ('updatedate', models.DateTimeField(auto_now=True, verbose_name='Date')), ('clientid', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='hosereel_client', to=settings.AUTH_USER_MODEL)), ('empid', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='hosereel_emp', to=settings.AUTH_USER_MODEL)), ('smpid', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='hosereel_smpid', to='mfire.sitemodelproduct')), ], ), migrations.CreateModel( name='FirePumpService', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('details', models.TextField(blank=True, null=True)), ('details_lable', models.TextField(blank=True, null=True)), ('service_location', models.TextField(blank=True, null=True)), ('qty_required', models.TextField(blank=True, null=True)), ('service_remarks', models.TextField(blank=True, null=True)), ('createdate', models.DateTimeField(auto_now_add=True, verbose_name='Date')), ('updatedate', models.DateTimeField(auto_now=True, verbose_name='Date')), ('fire_pump_id', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='firepumpservice_firepumpid', to='mfire.firepumphistory')), ], ), migrations.AddField( model_name='firepumphistory', name='smpid', field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='firepumphis_smpid', to='mfire.sitemodelproduct'), ), migrations.CreateModel( name='FirePump', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('sparepartrequired', models.CharField(blank=True, max_length=10, null=True)), ('remarks', models.TextField(blank=True, null=True)), ('sparepartitemrequired', models.TextField(blank=True, null=True)), ('hp', models.TextField(blank=True, null=True)), ('head', models.CharField(blank=True, max_length=124, null=True)), ('kw', models.CharField(blank=True, max_length=50, null=True)), ('pumpno', models.CharField(blank=True, max_length=50, null=True)), ('pumptype', models.CharField(blank=True, max_length=55, null=True)), ('rpm', models.CharField(blank=True, max_length=50, null=True)), ('motorno', models.CharField(blank=True, max_length=50, null=True)), ('make', models.CharField(blank=True, max_length=50, null=True)), ('pumptypeno', models.CharField(blank=True, max_length=50, null=True)), ('systempressure', models.CharField(blank=True, max_length=50, null=True)), ('systemflow', models.CharField(blank=True, max_length=50, null=True)), ('systemwatertank', models.CharField(blank=True, max_length=50, null=True)), ('systemhelth', models.CharField(blank=True, max_length=50, null=True)), ('p_location', models.TextField(blank=True, null=True)), ('location', models.TextField(blank=True, null=True)), ('image', models.FileField(blank=True, null=True, upload_to='media')), ('comment', models.TextField(blank=True, null=True)), ('health', models.CharField(blank=True, max_length=50, null=True)), ('client_comment', models.TextField(blank=True, null=True)), ('client_image', models.FileField(blank=True, null=True, upload_to='media')), ('createdate', models.DateTimeField(auto_now_add=True, verbose_name='Date')), ('updatedate', models.DateTimeField(auto_now=True, verbose_name='Date')), ('clientid', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='firepump_client', to=settings.AUTH_USER_MODEL)), ('empid', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='firepump_emp', to=settings.AUTH_USER_MODEL)), ('smpid', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='firepump_smpid', to='mfire.sitemodelproduct')), ], ), migrations.CreateModel( name='FireHydrantHPCL', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('hydrantno', models.CharField(blank=True, max_length=255, null=True)), ('size3', models.CharField(blank=True, max_length=255, null=True)), ('size4', models.CharField(blank=True, max_length=255, null=True)), ('size3s', models.CharField(blank=True, max_length=255, null=True)), ('monitor', models.CharField(blank=True, max_length=255, null=True)), ('leftsidelvgv', models.CharField(blank=True, max_length=255, null=True)), ('rightsidelvgv', models.CharField(blank=True, max_length=255, null=True)), ('hydrantblockvalve', models.CharField(blank=True, max_length=255, null=True)), ('offsiteunitarea', models.CharField(blank=True, max_length=255, null=True)), ('engg_location', models.TextField(blank=True, null=True)), ('engg_image', models.FileField(blank=True, null=True, upload_to='media')), ('engg_comment', models.TextField(blank=True, null=True)), ('client_location', models.TextField(blank=True, null=True)), ('client_image', models.FileField(blank=True, null=True, upload_to='media')), ('client_comment', models.TextField(blank=True, null=True)), ('health', models.CharField(blank=True, max_length=50, null=True)), ('createdate', models.DateTimeField(auto_now_add=True, verbose_name='Date')), ('updatedate', models.DateTimeField(auto_now=True, verbose_name='Date')), ('clientid', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='FireHydrantHPCL_client', to=settings.AUTH_USER_MODEL)), ('empid', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='FireHydrantHPCL_emp', to=settings.AUTH_USER_MODEL)), ('smpid', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='FireHydrantHPCL_smpid', to='mfire.sitemodelproduct')), ], ), migrations.CreateModel( name='FireHydrantHistory', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('sparepartrequired', models.CharField(blank=True, max_length=10, null=True)), ('remarks', models.TextField(blank=True, null=True)), ('sparepartitemrequired', models.TextField(blank=True, null=True)), ('hosepipe', models.CharField(blank=True, max_length=50, null=True)), ('hydrantvalve', models.CharField(blank=True, max_length=50, null=True)), ('blackcap', models.CharField(blank=True, max_length=50, null=True)), ('shuntwheel', models.CharField(blank=True, max_length=50, null=True)), ('hosebox', models.CharField(blank=True, max_length=50, null=True)), ('hoses', models.CharField(blank=True, max_length=50, null=True)), ('glasses', models.CharField(blank=True, max_length=50, null=True)), ('branchpipe', models.CharField(blank=True, max_length=50, null=True)), ('fire_hydrant_keys', models.CharField(blank=True, max_length=50, null=True)), ('glasshammer', models.CharField(blank=True, max_length=50, null=True)), ('observation', models.TextField(blank=True, null=True)), ('action', models.CharField(blank=True, max_length=124, null=True)), ('location', models.TextField(blank=True, null=True)), ('image', models.FileField(blank=True, null=True, upload_to='media')), ('comment', models.TextField(blank=True, null=True)), ('health', models.CharField(blank=True, max_length=50, null=True)), ('client_comment', models.TextField(blank=True, null=True)), ('client_image', models.FileField(blank=True, null=True, upload_to='media')), ('createdate', models.DateTimeField(auto_now_add=True, verbose_name='Date')), ('updatedate', models.DateTimeField(auto_now=True, verbose_name='Date')), ('clientid', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='firehydranthis_client', to=settings.AUTH_USER_MODEL)), ('empid', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='firehydranthis_emp', to=settings.AUTH_USER_MODEL)), ('smpid', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='firehydranthis_smpid', to='mfire.sitemodelproduct')), ], ), migrations.CreateModel( name='FireHydrant', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('sparepartrequired', models.CharField(blank=True, max_length=500, null=True)), ('remarks', models.TextField(blank=True, null=True)), ('sparepartitemrequired', models.TextField(blank=True, null=True)), ('hosepipe', models.CharField(blank=True, max_length=50, null=True)), ('hydrantvalve', models.CharField(blank=True, max_length=50, null=True)), ('blackcap', models.CharField(blank=True, max_length=50, null=True)), ('shuntwheel', models.CharField(blank=True, max_length=50, null=True)), ('hosebox', models.CharField(blank=True, max_length=50, null=True)), ('hoses', models.CharField(blank=True, max_length=50, null=True)), ('glasses', models.CharField(blank=True, max_length=50, null=True)), ('branchpipe', models.CharField(blank=True, max_length=50, null=True)), ('fire_hydrant_keys', models.CharField(blank=True, max_length=50, null=True)), ('glasshammer', models.CharField(blank=True, max_length=50, null=True)), ('observation', models.TextField(blank=True, null=True)), ('action', models.CharField(blank=True, max_length=124, null=True)), ('p_location', models.TextField(blank=True, null=True)), ('location', models.TextField(blank=True, null=True)), ('image', models.FileField(blank=True, null=True, upload_to='media')), ('comment', models.TextField(blank=True, null=True)), ('health', models.CharField(blank=True, max_length=50, null=True)), ('client_comment', models.TextField(blank=True, null=True)), ('client_image', models.FileField(blank=True, null=True, upload_to='media')), ('createdate', models.DateTimeField(auto_now_add=True, verbose_name='Date')), ('updatedate', models.DateTimeField(auto_now=True, verbose_name='Date')), ('clientid', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='firehydrant_client', to=settings.AUTH_USER_MODEL)), ('empid', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='firehydrant_emp', to=settings.AUTH_USER_MODEL)), ('smpid', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='firehydrant_smpid', to='mfire.sitemodelproduct')), ], ), migrations.CreateModel( name='FireExtinguisherHPCL', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('FEType', models.CharField(blank=True, max_length=255, null=True)), ('extgno', models.CharField(blank=True, max_length=255, null=True)), ('make', models.CharField(blank=True, max_length=255, null=True)), ('cylinderno', models.CharField(blank=True, max_length=255, null=True)), ('mfgyear', models.DateField(blank=True, null=True, verbose_name='Date')), ('dateofht', models.DateField(blank=True, null=True, verbose_name='Date')), ('duedateht', models.DateField(blank=True, null=True, verbose_name='Date')), ('dateofoverhauling', models.DateField(blank=True, null=True, verbose_name='Date')), ('duedateoverhauling', models.DateField(blank=True, null=True, verbose_name='Date')), ('duedatediscard', models.DateField(blank=True, null=True, verbose_name='Date')), ('certificateno', models.CharField(blank=True, max_length=255, null=True)), ('capacity', models.FloatField(blank=True, max_length=255, null=True)), ('engg_location', models.TextField(blank=True, null=True)), ('engg_image', models.FileField(blank=True, null=True, upload_to='media')), ('engg_comment', models.TextField(blank=True, null=True)), ('client_location', models.TextField(blank=True, null=True)), ('client_image', models.FileField(blank=True, null=True, upload_to='media')), ('client_comment', models.TextField(blank=True, null=True)), ('health', models.CharField(blank=True, max_length=50, null=True)), ('createdate', models.DateTimeField(auto_now_add=True, verbose_name='Engg Date')), ('updatedate', models.DateTimeField(auto_now=True, verbose_name='Client Date')), ('clientid', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='FireExtinguisherHPCL_client', to=settings.AUTH_USER_MODEL)), ('empid', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='FireExtinguisherHPCL_emp', to=settings.AUTH_USER_MODEL)), ('smpid', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='FireExtinguisherHPCL_smpid', to='mfire.sitemodelproduct')), ], ), migrations.CreateModel( name='FireDetectionService', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('details', models.TextField(blank=True, null=True)), ('details_lable', models.TextField(blank=True, null=True)), ('service_location', models.TextField(blank=True, null=True)), ('qty_required', models.TextField(blank=True, null=True)), ('service_remarks', models.TextField(blank=True, null=True)), ('createdate', models.DateTimeField(auto_now_add=True, verbose_name='Date')), ('updatedate', models.DateTimeField(auto_now=True, verbose_name='Date')), ('fire_detection_id', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='firedetectionservice_fireid', to='mfire.firedetectionhistory')), ], ), migrations.AddField( model_name='firedetectionhistory', name='smpid', field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='firedetectionhis_smpid', to='mfire.sitemodelproduct'), ), migrations.CreateModel( name='FireDetection', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('sparepartrequired', models.CharField(blank=True, max_length=10, null=True)), ('remarks', models.TextField(blank=True, null=True)), ('sparepartitemrequired', models.TextField(blank=True, null=True)), ('specs_of_panel', models.CharField(blank=True, max_length=100, null=True)), ('type_of_system', models.CharField(blank=True, max_length=50, null=True)), ('make', models.CharField(blank=True, max_length=50, null=True)), ('loops_zone', models.CharField(blank=True, max_length=50, null=True)), ('repeater_panel', models.CharField(blank=True, max_length=50, null=True)), ('isolator_module', models.CharField(blank=True, max_length=50, null=True)), ('heat_detector', models.CharField(blank=True, max_length=50, null=True)), ('flame_detector', models.CharField(blank=True, max_length=50, null=True)), ('smoke_detector', models.CharField(blank=True, max_length=50, null=True)), ('multi_detector', models.CharField(blank=True, max_length=50, null=True)), ('gas_detector', models.TextField(blank=True, null=True)), ('beam_detector', models.CharField(blank=True, max_length=50, null=True)), ('manual_call_point', models.CharField(blank=True, max_length=50, null=True)), ('hooter_cum_sounder', models.CharField(blank=True, max_length=50, null=True)), ('zone_monitor_module', models.CharField(blank=True, max_length=50, null=True)), ('monitor_module', models.CharField(blank=True, max_length=50, null=True)), ('control_module', models.CharField(blank=True, max_length=50, null=True)), ('power_supply_unit', models.CharField(blank=True, max_length=50, null=True)), ('zener_barrier', models.CharField(blank=True, max_length=50, null=True)), ('siren', models.CharField(blank=True, max_length=50, null=True)), ('cables', models.CharField(blank=True, max_length=50, null=True)), ('special_detector', models.CharField(blank=True, max_length=50, null=True)), ('battery_backup', models.CharField(blank=True, max_length=50, null=True)), ('p_location', models.TextField(blank=True, null=True)), ('location', models.TextField(blank=True, null=True)), ('image', models.FileField(blank=True, null=True, upload_to='media')), ('comment', models.TextField(blank=True, null=True)), ('health', models.CharField(blank=True, max_length=50, null=True)), ('client_comment', models.TextField(blank=True, null=True)), ('client_image', models.FileField(blank=True, null=True, upload_to='media')), ('createdate', models.DateTimeField(auto_now_add=True, verbose_name='Date')), ('updatedate', models.DateTimeField(auto_now=True, verbose_name='Date')), ('clientid', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='firedetection_client', to=settings.AUTH_USER_MODEL)), ('empid', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='firedetection_emp', to=settings.AUTH_USER_MODEL)), ('smpid', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='firedetection_smpid', to='mfire.sitemodelproduct')), ], ), migrations.CreateModel( name='FireBucketHistory', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('sparepartrequired', models.CharField(blank=True, max_length=10, null=True)), ('remarks', models.TextField(blank=True, null=True)), ('sparepartitemrequired', models.TextField(blank=True, null=True)), ('observation', models.TextField(blank=True, null=True)), ('action', models.CharField(blank=True, max_length=124, null=True)), ('numberoffirebuckets', models.CharField(blank=True, db_column='numberofFirebuckets', max_length=50, null=True)), ('buckets', models.CharField(blank=True, max_length=50, null=True)), ('stand', models.CharField(blank=True, max_length=50, null=True)), ('sand', models.CharField(blank=True, max_length=50, null=True)), ('location', models.TextField(blank=True, null=True)), ('image', models.FileField(blank=True, null=True, upload_to='media')), ('comment', models.TextField(blank=True, null=True)), ('health', models.CharField(blank=True, max_length=50, null=True)), ('client_comment', models.TextField(blank=True, null=True)), ('client_image', models.FileField(blank=True, null=True, upload_to='media')), ('createdate', models.DateTimeField(auto_now_add=True, verbose_name='Date')), ('updatedate', models.DateTimeField(auto_now=True, verbose_name='Date')), ('clientid', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='firebuckethis_client', to=settings.AUTH_USER_MODEL)), ('empid', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='firebuckethis_emp', to=settings.AUTH_USER_MODEL)), ('smpid', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='firebuckethis_smpid', to='mfire.sitemodelproduct')), ], ), migrations.CreateModel( name='FireBucket', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('sparepartrequired', models.CharField(blank=True, max_length=10, null=True)), ('remarks', models.TextField(blank=True, null=True)), ('sparepartitemrequired', models.TextField(blank=True, null=True)), ('observation', models.TextField(blank=True, null=True)), ('action', models.CharField(blank=True, max_length=124, null=True)), ('numberoffirebuckets', models.CharField(blank=True, max_length=50, null=True)), ('buckets', models.CharField(blank=True, max_length=50, null=True)), ('stand', models.CharField(blank=True, max_length=50, null=True)), ('sand', models.CharField(blank=True, max_length=50, null=True)), ('p_location', models.TextField(blank=True, null=True)), ('location', models.TextField(blank=True, null=True)), ('image', models.FileField(blank=True, null=True, upload_to='media')), ('comment', models.TextField(blank=True, null=True)), ('health', models.CharField(blank=True, max_length=50, null=True)), ('client_comment', models.TextField(blank=True, null=True)), ('client_image', models.FileField(blank=True, null=True, upload_to='media')), ('createdate', models.DateTimeField(auto_now_add=True, verbose_name='Date')), ('updatedate', models.DateTimeField(auto_now=True, verbose_name='Date')), ('clientid', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='firebucket_client', to=settings.AUTH_USER_MODEL)), ('empid', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='firebucket_emp', to=settings.AUTH_USER_MODEL)), ('smpid', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='firebucket_smpid', to='mfire.sitemodelproduct')), ], ), migrations.CreateModel( name='ControlValveHistory', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('sparepartrequired', models.CharField(blank=True, max_length=10, null=True)), ('remarks', models.TextField(blank=True, null=True)), ('sparepartitemrequired', models.TextField(blank=True, null=True)), ('type_of_valve', models.CharField(blank=True, max_length=100, null=True)), ('moc', models.CharField(blank=True, max_length=50, null=True)), ('size', models.CharField(blank=True, max_length=50, null=True)), ('spindle', models.CharField(blank=True, max_length=50, null=True)), ('wheel_lever', models.CharField(blank=True, max_length=50, null=True)), ('gasket', models.CharField(blank=True, max_length=50, null=True)), ('gland_packing', models.CharField(blank=True, max_length=50, null=True)), ('drain_valve', models.CharField(blank=True, max_length=50, null=True)), ('pressure_guage', models.CharField(blank=True, max_length=50, null=True)), ('pressure', models.CharField(blank=True, max_length=50, null=True)), ('flow', models.TextField(blank=True, null=True)), ('test_valve', models.CharField(blank=True, max_length=50, null=True)), ('soleniod_valve_actuator', models.CharField(blank=True, max_length=50, null=True)), ('internal_disc_flap', models.CharField(blank=True, max_length=50, null=True)), ('gong_bell', models.CharField(blank=True, max_length=11, null=True)), ('location', models.TextField(blank=True, null=True)), ('image', models.FileField(blank=True, null=True, upload_to='media')), ('comment', models.TextField(blank=True, null=True)), ('health', models.CharField(blank=True, max_length=50, null=True)), ('client_comment', models.TextField(blank=True, null=True)), ('client_image', models.FileField(blank=True, null=True, upload_to='media')), ('createdate', models.DateTimeField(auto_now_add=True, verbose_name='Date')), ('updatedate', models.DateTimeField(auto_now=True, verbose_name='Date')), ('clientid', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='controlhis_client', to=settings.AUTH_USER_MODEL)), ('empid', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='controlhis_emp', to=settings.AUTH_USER_MODEL)), ('smpid', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='controlhis_smpid', to='mfire.sitemodelproduct')), ], ), migrations.CreateModel( name='ControlValve', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('sparepartrequired', models.CharField(blank=True, max_length=10, null=True)), ('remarks', models.TextField(blank=True, null=True)), ('sparepartitemrequired', models.TextField(blank=True, null=True)), ('type_of_valve', models.CharField(blank=True, max_length=100, null=True)), ('moc', models.CharField(blank=True, max_length=50, null=True)), ('size', models.CharField(blank=True, max_length=50, null=True)), ('spindle', models.CharField(blank=True, max_length=50, null=True)), ('wheel_lever', models.CharField(blank=True, max_length=50, null=True)), ('gasket', models.CharField(blank=True, max_length=50, null=True)), ('gland_packing', models.CharField(blank=True, max_length=50, null=True)), ('drain_valve', models.CharField(blank=True, max_length=50, null=True)), ('pressure_guage', models.CharField(blank=True, max_length=50, null=True)), ('pressure', models.CharField(blank=True, max_length=50, null=True)), ('flow', models.TextField(blank=True, null=True)), ('test_valve', models.CharField(blank=True, max_length=50, null=True)), ('soleniod_valve_actuator', models.CharField(blank=True, max_length=50, null=True)), ('internal_disc_flap', models.CharField(blank=True, max_length=50, null=True)), ('gong_bell', models.CharField(blank=True, max_length=11, null=True)), ('p_location', models.TextField(blank=True, null=True)), ('location', models.TextField(blank=True, null=True)), ('image', models.FileField(blank=True, null=True, upload_to='media')), ('comment', models.TextField(blank=True, null=True)), ('client_comment', models.TextField(blank=True, null=True)), ('health', models.CharField(blank=True, max_length=50, null=True)), ('client_image', models.FileField(blank=True, null=True, upload_to='media')), ('createdate', models.DateTimeField(auto_now_add=True, verbose_name='Date')), ('updatedate', models.DateTimeField(auto_now=True, verbose_name='Date')), ('clientid', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='control_client', to=settings.AUTH_USER_MODEL)), ('empid', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='control_emp', to=settings.AUTH_USER_MODEL)), ('smpid', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='control_smpid', to='mfire.sitemodelproduct')), ], ), migrations.CreateModel( name='CompanyInspection', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('message', models.TextField(blank=True, null=True)), ('status', models.CharField(blank=True, choices=[('Approve', 'Approve'), ('Pendding', 'Pendding'), ('Reschedule', 'Reschedule')], max_length=20, null=True)), ('inspection_date', models.DateTimeField()), ('reshedul_date', models.CharField(blank=True, max_length=100, null=True)), ('date', models.DateTimeField(auto_now_add=True)), ('assignemp', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='inspection_emp', to=settings.AUTH_USER_MODEL)), ('clientid', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='inspection_clints', to=settings.AUTH_USER_MODEL)), ], ), migrations.CreateModel( name='ClientLocation', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('cl_location', models.TextField()), ('date', models.DateTimeField(auto_now_add=True, verbose_name='Date')), ('client_id', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='clientlocation', to=settings.AUTH_USER_MODEL)), ], ), migrations.CreateModel( name='Alert', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('msg', models.CharField(blank=True, max_length=300, null=True)), ('status', models.CharField(blank=True, max_length=6, null=True)), ('createdate', models.DateTimeField(auto_now_add=True, verbose_name='Date')), ('clientid', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='alert_client', to=settings.AUTH_USER_MODEL)), ('empid', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='alert_emp', to=settings.AUTH_USER_MODEL)), ], ), ]