# Generated by Django 5.0.6 on 2024-11-15 11:06 import django.contrib.auth.models import django.contrib.auth.validators import django.utils.timezone from django.db import migrations, models class Migration(migrations.Migration): initial = True dependencies = [ ('auth', '0012_alter_user_first_name_max_length'), ] operations = [ migrations.CreateModel( name='Account', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('companyid', models.IntegerField(null=True)), ('type', models.CharField(max_length=1, null=True)), ('payment', models.DecimalField(decimal_places=2, max_digits=13, null=True)), ('creditamount', models.IntegerField(null=True)), ('lastpayment', models.DecimalField(decimal_places=2, max_digits=13, null=True)), ('lastpaymentdatetime', models.DateTimeField(null=True)), ('lastcredit', models.IntegerField(null=True)), ('lastcreditdatetime', models.DateTimeField(null=True)), ('balance', models.IntegerField(null=True)), ], options={ 'db_table': 'account', }, ), migrations.CreateModel( name='Branding', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('companyid', models.IntegerField(null=True)), ('logourl', models.FileField(null=True, upload_to='logos/')), ('content', models.TextField(null=True)), ('sociallinks', models.TextField(null=True)), ('status', models.CharField(max_length=1, null=True)), ], options={ 'db_table': 'branding', }, ), migrations.CreateModel( name='Brules', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('workflowid', models.IntegerField(blank=True, null=True)), ('companyid', models.IntegerField(blank=True, null=True)), ('jobdescid', models.IntegerField(blank=True, null=True)), ('paperid', models.IntegerField(blank=True, null=True)), ('passscore', models.IntegerField(blank=True, null=True)), ('passevent', models.IntegerField(blank=True, null=True)), ('failevent', models.IntegerField(blank=True, null=True)), ], options={ 'db_table': 'brules', }, ), migrations.CreateModel( name='CallSchedule', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('candidateid', models.IntegerField(null=True)), ('hrid', models.IntegerField(null=True)), ('paper_id', models.IntegerField(null=True)), ('interviewerid', models.IntegerField(null=True)), ('datentime', models.DateTimeField(null=True)), ('status', models.CharField(max_length=1, null=True)), ('callstarteddtt', models.DateTimeField(null=True)), ('callendeddtt', models.DateTimeField(null=True)), ('instructions', models.CharField(max_length=1000, null=True)), ('intnotes', models.CharField(max_length=1000, null=True)), ('meetinglink', models.CharField(max_length=100, null=True)), ('callendflag', models.CharField(max_length=1, null=True)), ('companyid', models.IntegerField(null=True)), ], options={ 'db_table': 'callschedule', }, ), migrations.CreateModel( name='Candidate', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('candidateid', models.CharField(max_length=100, null=True)), ('firstname', models.CharField(max_length=100, null=True)), ('lastname', models.CharField(max_length=100, null=True)), ('registrationdate', models.DateTimeField(null=True)), ('companyid', models.IntegerField(null=True)), ('email', models.CharField(max_length=100, null=True)), ('mobile', models.CharField(max_length=40, null=True)), ('add1', models.CharField(max_length=100, null=True)), ('add2', models.CharField(max_length=100, null=True)), ('city', models.CharField(max_length=100, null=True)), ('state', models.CharField(max_length=100, null=True)), ('country', models.CharField(max_length=40, null=True)), ('dob', models.DateField(null=True)), ('jobid', models.IntegerField(null=True)), ('status', models.CharField(max_length=1, null=True)), ], options={ 'db_table': 'candidate', }, ), migrations.CreateModel( name='CdnData', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('libraryid', models.CharField(max_length=50, null=True)), ('libraryname', models.CharField(max_length=100, null=True)), ('pullzoneid', models.CharField(max_length=100, null=True)), ('hostname', models.CharField(max_length=100, null=True)), ('authkey', models.CharField(max_length=100, null=True)), ], options={ 'db_table': 'cdndata', }, ), migrations.CreateModel( name='Company', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('name', models.CharField(max_length=100)), ('address1', models.CharField(blank=True, max_length=100, null=True)), ('address2', 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)), ('country', models.CharField(blank=True, max_length=100, null=True)), ('companydomain', models.CharField(blank=True, max_length=100, null=True)), ('status', models.CharField(blank=True, max_length=1, null=True)), ('website', models.CharField(blank=True, max_length=100, null=True)), ('phone1', models.CharField(blank=True, max_length=100, null=True)), ('phone2', models.CharField(blank=True, max_length=100, null=True)), ('email', models.CharField(blank=True, max_length=100, null=True)), ('emaildomain', models.CharField(max_length=100, null=True)), ('companytype', models.CharField(blank=True, max_length=100, null=True)), ('freetrail', models.CharField(max_length=1, null=True)), ('registrationdate', models.DateTimeField(null=True)), ], options={ 'db_table': 'company', }, ), migrations.CreateModel( name='CompanyCredits', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('companyid', models.IntegerField(null=True)), ('transtype', models.CharField(max_length=1, null=True)), ('credits', models.IntegerField(null=True)), ], options={ 'db_table': 'companycredits', }, ), migrations.CreateModel( name='CompanyData', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('companyname', models.CharField(blank=True, max_length=120, null=True)), ('companyemail', models.CharField(blank=True, max_length=120, null=True)), ('location', models.CharField(blank=True, max_length=120, null=True)), ('contactperson', models.CharField(blank=True, max_length=50, null=True)), ('companytype', models.CharField(blank=True, max_length=100, null=True)), ('registerationtime', models.DateTimeField(blank=True, null=True)), ], options={ 'db_table': 'companydata', }, ), migrations.CreateModel( name='Credits', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('companyid', models.IntegerField(null=True)), ('transdatetime', models.DateTimeField(null=True)), ('transtype', models.CharField(max_length=1, null=True)), ('papertype', models.CharField(max_length=1, null=True)), ('points', models.IntegerField(null=True)), ('user', models.IntegerField(null=True)), ('transid', models.IntegerField(null=True)), ('balance', models.IntegerField(null=True)), ], options={ 'db_table': 'credits', }, ), migrations.CreateModel( name='Email_template', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('company_id', models.IntegerField(blank=True, null=True)), ('template_name', models.CharField(max_length=120, null=True)), ('paper_type', models.CharField(max_length=100, null=True)), ('event', models.CharField(max_length=120, null=True)), ('sender_email', models.CharField(max_length=100, null=True)), ('sender_label', models.CharField(max_length=100, null=True)), ('email_subject', models.CharField(blank=True, max_length=300, null=True)), ('email_body', models.CharField(blank=True, max_length=10000, null=True)), ('template_heading', models.CharField(max_length=300, null=True)), ('email_attachment', models.CharField(max_length=250, null=True)), ('email_attachment_path', models.FileField(null=True, upload_to='email_attachments/')), ('email_attachment_name', models.CharField(max_length=120, null=True)), ], options={ 'db_table': 'email_template', }, ), migrations.CreateModel( name='ExtendedHours', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('empid', models.IntegerField(null=True)), ('workcalid', models.IntegerField(null=True)), ('fromdate', models.DateField(null=True)), ('todate', models.DateField(null=True)), ('starttime', models.TimeField(max_length=20, null=True)), ('workhours', models.CharField(max_length=4, null=True)), ('status', models.CharField(max_length=1, null=True)), ('companyid', models.IntegerField(null=True)), ], options={ 'db_table': 'extendedhours', }, ), migrations.CreateModel( name='HolidayCal', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('holidaydt', models.DateField(null=True)), ('type', models.CharField(max_length=1, null=True)), ('description', models.CharField(max_length=100, null=True)), ('companyid', models.IntegerField(null=True)), ], options={ 'db_table': 'holidaycal', }, ), migrations.CreateModel( name='InterviewMedia', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('recorded', models.CharField(max_length=200, null=True)), ('candidateid', models.CharField(max_length=40, null=True)), ('scheduleid', models.IntegerField(null=True)), ], options={ 'db_table': 'interviewmedia', }, ), migrations.CreateModel( name='IvFeedback', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('candidateid', models.IntegerField(null=True)), ('gonogo', models.CharField(max_length=1, null=True)), ('interviewerid', models.IntegerField(null=True)), ('notes', models.CharField(max_length=100, null=True)), ('companyid', models.IntegerField(null=True)), ], options={ 'db_table': 'ivfeedback', }, ), migrations.CreateModel( name='JobDesc', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('jdlibraryid', models.IntegerField(null=True)), ('title', models.CharField(max_length=350, null=True)), ('role', models.CharField(max_length=100, null=True)), ('description', models.CharField(max_length=3024, null=True)), ('expmin', models.IntegerField(null=True)), ('expmax', models.IntegerField(null=True)), ('department', models.CharField(max_length=100, null=True)), ('location', models.CharField(max_length=512, null=True)), ('budget', models.DecimalField(decimal_places=2, max_digits=13, null=True)), ('skillset', models.CharField(max_length=512, null=True)), ('skillnotes', models.CharField(max_length=512, null=True)), ('interviewers', models.CharField(max_length=100, null=True)), ('expjoindate', models.DateField(max_length=11, null=True)), ('positions', models.IntegerField(null=True)), ('createdby', models.IntegerField(null=True)), ('status', models.CharField(max_length=1, null=True)), ('createdon', models.DateTimeField(null=True)), ('companyid', models.IntegerField(null=True)), ], options={ 'db_table': 'jobdesc', }, ), migrations.CreateModel( name='Lookupmaster', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('lookupid', models.IntegerField(null=True)), ('lookupmasterid', models.IntegerField(null=True)), ('lookupname', models.CharField(max_length=150, null=True)), ('lookupparam1', models.TextField(null=True)), ('lookupparam2', models.CharField(max_length=150, null=True)), ('status', models.CharField(max_length=1, null=True)), ('comments', models.CharField(max_length=300, null=True)), ], options={ 'db_table': 'lookupmaster', }, ), migrations.CreateModel( name='Payments', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('companyid', models.IntegerField(null=True)), ('dateofpay', models.DateTimeField(null=True)), ('modeofpay', models.CharField(max_length=1, null=True)), ('amount', models.DecimalField(decimal_places=2, max_digits=13, null=True)), ('credits', models.IntegerField(null=True)), ], options={ 'db_table': 'payments', }, ), migrations.CreateModel( name='QResponse', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('qid', models.IntegerField(null=True)), ('candidateid', models.IntegerField(null=True)), ('callscheduleid', models.IntegerField(null=True)), ('response', models.CharField(max_length=256, null=True)), ('notes', models.CharField(max_length=256, null=True)), ('qrate', models.CharField(max_length=10, null=True)), ('companyid', models.IntegerField(null=True)), ], options={ 'db_table': 'qresponse', }, ), migrations.CreateModel( name='ReferenceId', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('type', models.CharField(max_length=1, null=True)), ('prefix1', models.CharField(max_length=3, null=True)), ('prefix2', models.CharField(max_length=3, null=True)), ('prefix3', models.CharField(max_length=3, null=True)), ('lastid', models.IntegerField(null=True)), ], options={ 'db_table': 'referenceid', }, ), migrations.CreateModel( name='Registration', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('candidateid', models.IntegerField(null=True)), ('jobid', models.IntegerField(null=True)), ('paperid', models.IntegerField(null=True)), ('papertype', models.CharField(blank=True, max_length=1, null=True)), ('companyid', models.IntegerField(null=True)), ('registrationdate', models.DateTimeField(null=True)), ('completiondate', models.DateTimeField(null=True)), ('status', models.CharField(blank=True, max_length=1, null=True)), ], options={ 'db_table': 'registration', }, ), migrations.CreateModel( name='Role', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('Name', models.CharField(max_length=120, null=True)), ('status', models.CharField(max_length=1, null=True)), ], options={ 'db_table': 'role', }, ), migrations.CreateModel( name='RolesPermissions', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('function', models.CharField(max_length=120, null=True)), ('sub_function', models.CharField(max_length=120, null=True)), ('function_category', models.CharField(max_length=120, null=True)), ('function_link', models.CharField(max_length=120, null=True)), ('enable', models.CharField(max_length=260, null=True)), ('function_icon', models.CharField(max_length=120, null=True)), ('orderby', models.IntegerField(null=True)), ], options={ 'db_table': 'rolespermissions', }, ), migrations.CreateModel( name='User', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('name', models.CharField(max_length=100, null=True)), ('mobile', models.CharField(max_length=20, null=True)), ('location', models.CharField(blank=True, max_length=120, null=True)), ('datentime', models.DateTimeField(null=True)), ('email', models.CharField(blank=True, max_length=120, null=True)), ('password', models.CharField(max_length=40, null=True)), ('role', models.CharField(max_length=120, null=True)), ('companyid', models.IntegerField(null=True)), ('status', models.CharField(max_length=1, null=True)), ], options={ 'db_table': 'user', }, ), migrations.CreateModel( name='Vacation', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('empid', models.IntegerField(null=True)), ('fromdate', models.DateField(null=True)), ('todate', models.DateField(null=True)), ('hours', models.IntegerField(null=True)), ('purpose', models.CharField(max_length=30, null=True)), ('type', models.CharField(max_length=1, null=True)), ('companyid', models.IntegerField(null=True)), ], options={ 'db_table': 'vacation', }, ), migrations.CreateModel( name='WorkCal', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('empid', models.IntegerField(null=True)), ('startday', models.CharField(max_length=3, null=True)), ('starttime', models.TimeField(max_length=20, null=True)), ('workhours', models.CharField(max_length=4, null=True)), ('weekoff1', models.CharField(max_length=3, null=True)), ('weekoff2', models.CharField(max_length=3, null=True)), ('companyid', models.IntegerField(null=True)), ], options={ 'db_table': 'workcal', }, ), migrations.CreateModel( name='Workflow', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('jobid', models.IntegerField(null=True)), ('companyid', models.IntegerField(null=True)), ('paperid', models.IntegerField(null=True)), ('papertype', models.CharField(max_length=1, null=True)), ('order', models.IntegerField(null=True)), ('papertitle', models.CharField(blank=True, max_length=120, null=True)), ('paperlibraryid', models.IntegerField(null=True)), ], options={ 'db_table': 'workflow', }, ), migrations.CreateModel( name='User_data', 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=150, verbose_name='first name')), ('last_name', models.CharField(blank=True, max_length=150, verbose_name='last name')), ('email', models.EmailField(blank=True, max_length=254, verbose_name='email address')), ('is_staff', models.BooleanField(default=False, help_text='Designates whether the user can log into this admin site.', verbose_name='staff status')), ('is_active', models.BooleanField(default=True, help_text='Designates whether this user should be treated as active. Unselect this instead of deleting accounts.', verbose_name='active')), ('date_joined', models.DateTimeField(default=django.utils.timezone.now, verbose_name='date joined')), ('id', models.AutoField(primary_key=True, serialize=False)), ('usr_email', models.CharField(max_length=120)), ('usr_password', models.CharField(max_length=60)), ('user', models.CharField(max_length=1, 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={ 'db_table': 'user_data', }, managers=[ ('objects', django.contrib.auth.models.UserManager()), ], ), ]