# Generated by Django 5.2.4 on 2025-08-06 15:00 import django.db.models.deletion from django.conf import settings from django.db import migrations, models class Migration(migrations.Migration): initial = True dependencies = [ migrations.swappable_dependency(settings.AUTH_USER_MODEL), ] operations = [ migrations.CreateModel( name='Otp', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('email', models.CharField(max_length=255, null=True)), ('status', models.SmallIntegerField(default=1)), ('otp', models.CharField(blank=True, max_length=6)), ('otp_created_at', models.DateTimeField(blank=True, null=True)), ], options={ 'db_table': 'otp', 'ordering': ['pk'], }, ), migrations.CreateModel( name='Notification', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('type', models.CharField(max_length=20)), ('message', models.TextField()), ('status', models.SmallIntegerField(default=0)), ('created_at', models.DateTimeField(auto_now_add=True)), ('user', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='Notifications', to=settings.AUTH_USER_MODEL)), ], options={ 'db_table': 'notification', 'ordering': ['pk'], }, ), migrations.CreateModel( name='Product', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('company_name', models.CharField(max_length=255, null=True)), ('project_name', models.CharField(max_length=255, null=True)), ('application', models.CharField(max_length=255, null=True)), ('country', models.CharField(max_length=255, null=True)), ('deliverydate', models.CharField(max_length=255, null=True)), ('bidclosedate', models.CharField(max_length=255, null=True)), ('s2dailyflow', models.CharField(max_length=255, null=True)), ('s2monthflow', models.CharField(max_length=255, null=True)), ('s2weekflow', models.CharField(max_length=255, null=True)), ('s2maxdailyflow', models.CharField(max_length=255, null=True)), ('s2hourflow', models.CharField(max_length=255, null=True)), ('s2bod', models.CharField(max_length=255, null=True)), ('s2bodout', models.CharField(max_length=255, null=True)), ('s2bodrate', models.CharField(max_length=255, null=True)), ('s2cod', models.CharField(max_length=255, null=True)), ('s2codout', models.CharField(max_length=255, null=True)), ('s2codrate', models.CharField(max_length=255, null=True)), ('s2tss', models.CharField(max_length=255, null=True)), ('s2tssout', models.CharField(max_length=255, null=True)), ('s2tssrate', models.CharField(max_length=255, null=True)), ('s2tn', models.CharField(max_length=255, null=True)), ('s2tnout', models.CharField(max_length=100, null=True)), ('s2tnrate', models.CharField(max_length=100, null=True)), ('s2tp', models.CharField(max_length=100, null=True)), ('s2tpout', models.CharField(max_length=100, null=True)), ('s2tprate', models.CharField(max_length=100, null=True)), ('s2oil', models.CharField(max_length=100, null=True)), ('s2oilout', models.CharField(max_length=100, null=True)), ('s2oilrate', models.CharField(max_length=100, null=True)), ('s2avgwatertemp', models.CharField(max_length=100, null=True)), ('s2avgwatertempout', models.CharField(max_length=100, null=True)), ('s2avgwatertemprate', models.CharField(max_length=100, null=True)), ('s2maxwatertemp', models.CharField(max_length=100, null=True)), ('s2maxwatertempout', models.CharField(max_length=100, null=True)), ('s2maxwatertemprate', models.CharField(max_length=100, null=True)), ('s2minwatertemp', models.CharField(max_length=100, null=True)), ('s2minwatertempout', models.CharField(max_length=100, null=True)), ('s2minwatertemprate', models.CharField(max_length=100, null=True)), ('Davgflux1', models.CharField(max_length=100, null=True)), ('Davgflux2', models.CharField(max_length=100, null=True)), ('Dpeakflux', models.CharField(max_length=100, null=True)), ('Msurfacearea1', models.CharField(max_length=100, null=True)), ('Msurfacearea2', models.CharField(max_length=100, null=True)), ('productcode', models.CharField(max_length=100, null=True)), ('Noofmodule', models.CharField(max_length=100, null=True)), ('Noofmtrain', models.CharField(max_length=100, null=True)), ('Noofmptrain', models.CharField(max_length=100, null=True)), ('TNM', models.CharField(max_length=100, null=True)), ('TMsurfacearea', models.CharField(max_length=100, null=True)), ('Aavgflux1', models.CharField(max_length=100, null=True)), ('Aavgflux2', models.CharField(max_length=100, null=True)), ('Apeakflux1', models.CharField(max_length=100, null=True)), ('Apeakflux2', models.CharField(max_length=100, null=True)), ('s4AT1', models.CharField(max_length=100, null=True)), ('s4AT2', models.CharField(max_length=100, null=True)), ('s4AT3', models.CharField(max_length=100, null=True)), ('s4AT4', models.CharField(max_length=100, null=True)), ('s4AT5', models.CharField(max_length=100, null=True)), ('s4AT6', models.CharField(max_length=100, null=True)), ('s4AT7', models.CharField(max_length=100, null=True)), ('s4TT1', models.CharField(max_length=100, null=True)), ('s4TT2', models.CharField(max_length=100, null=True)), ('s4TT3', models.CharField(max_length=100, null=True)), ('s4TT4', models.CharField(max_length=100, null=True)), ('s4TT5', models.CharField(max_length=100, null=True)), ('s4TT6', models.CharField(max_length=100, null=True)), ('s4TT7', models.CharField(max_length=100, null=True)), ('s4MT1', models.CharField(max_length=100, null=True)), ('s4MT2', models.CharField(max_length=100, null=True)), ('s4MT3', models.CharField(max_length=100, null=True)), ('s4MT4', models.CharField(max_length=100, null=True)), ('s4MT5', models.CharField(max_length=100, null=True)), ('s4MT6', models.CharField(max_length=100, null=True)), ('s4MT7', models.CharField(max_length=100, null=True)), ('status', models.SmallIntegerField(default=1)), ('created_at', models.DateTimeField(auto_now_add=True)), ('updated_at', models.DateTimeField(auto_now=True)), ('created_by', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='product_created_by', to=settings.AUTH_USER_MODEL)), ('updated_by', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='product_updated_by', to=settings.AUTH_USER_MODEL)), ], options={ 'db_table': 'product', 'ordering': ['pk'], }, ), migrations.CreateModel( name='Profiles', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(max_length=255, null=True)), ('phone', models.CharField(max_length=255, null=True)), ('email', models.CharField(max_length=255, null=True)), ('address', models.CharField(max_length=255, null=True)), ('servicename', models.CharField(max_length=255, null=True)), ('gender', models.CharField(max_length=255, null=True)), ('profiles', models.FileField(blank=True, default='../static/dummy.png', null=True, upload_to='uploads/')), ('password', models.CharField(max_length=255, null=True)), ('gstnumber', models.CharField(max_length=255, null=True)), ('pincode', models.CharField(max_length=255, null=True)), ('doj', models.DateField(null=True)), ('gst', models.FileField(blank=True, null=True, upload_to='uploads/')), ('companylogo', models.FileField(blank=True, null=True, upload_to='uploads/')), ('alteremail', models.CharField(max_length=255, null=True)), ('alteremail1', models.CharField(max_length=255, null=True)), ('alteremail2', models.CharField(max_length=255, null=True)), ('pan', models.FileField(blank=True, null=True, upload_to='uploads/')), ('role', models.SmallIntegerField(default=0)), ('status', models.SmallIntegerField(default=1)), ('created_at', models.DateTimeField(auto_now_add=True)), ('updated_at', models.DateTimeField(auto_now=True)), ('user', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='user_profiles', to=settings.AUTH_USER_MODEL)), ], options={ 'db_table': 'profile', }, ), ]