class Migration(migrations.Migration):
dependencies = [
('dashboard', '0008_auto_20170814_2138'),
]
operations = [
migrations.AlterField(
model_name='uploadedfile',
name='category',
field=models.CharField(choices=[('psets', 'PSet Submission'),
('scripts', 'Transcript'),
('notes', 'Notes / Comments'),
('misc', 'Miscellaneous')],
help_text='What kind of file this is',
max_length=10),
),
migrations.AlterField(
model_name='uploadedfile',
name='content',
field=models.FileField(
help_text='The file itself',
upload_to=dashboard.models.content_file_name),
),
]
class Migration(migrations.Migration):
dependencies = [
('dashboard', '0004_auto_20190302_1930'),
]
operations = [
migrations.AlterField(
model_name='uploaddata',
name='upload',
field=models.FileField(default='SIH.csv', upload_to=dashboard.models.user_directory_path),
),
]
class Migration(migrations.Migration):
dependencies = [
('dashboard', '0057_alter_achievement_code'),
]
operations = [
migrations.AlterField(
model_name='semesterdownloadfile',
name='content',
field=models.FileField(help_text='The file itself', upload_to=dashboard.models.download_file_name),
),
]
class Migration(migrations.Migration):
dependencies = [
('dashboard', '0001_initial'),
]
operations = [
migrations.AlterField(
model_name='uploaddata',
name='upload',
field=models.FileField(
upload_to=dashboard.models.user_directory_path),
),
]
class Migration(migrations.Migration):
dependencies = [
('dashboard', '0004_profile_travel'),
]
operations = [
migrations.AddField(
model_name='profile',
name='resume',
field=models.FileField(blank=True,
null=True,
upload_to=dashboard.models.resume_loc),
),
]
class Migration(migrations.Migration):
dependencies = [
('dashboard', '0010_uploadedfile_description'),
]
operations = [
migrations.AlterField(
model_name='uploadedfile',
name='content',
field=models.FileField(
help_text='The file itself',
upload_to=dashboard.models.content_file_name,
validators=[
django.core.validators.FileExtensionValidator(
allowed_extensions=['pdf', 'txt', 'tex'])
]),
),
]
class Migration(migrations.Migration):
dependencies = [
('dashboard', '0001_initial'),
]
operations = [
migrations.CreateModel(
name='File_upload',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('filename',
models.FileField(
upload_to=dashboard.models.File_upload.get_upload_path)),
],
),
migrations.DeleteModel(name='Testmodel', ),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
]
operations = [
migrations.CreateModel(
name='UserProfile',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('title', models.CharField(choices=[('mr.', 'Mr.'), ('miss', 'Miss'), ('mrs.', 'Mrs.'), ('ms.', 'Ms.'), ('dr.', 'Dr.'), ('prof', 'Professor'), ('other', 'Other')], max_length=10)),
('first_name', models.CharField(max_length=30)),
('last_name', models.CharField(max_length=30)),
('mid_name', models.CharField(max_length=30)),
('institution', models.CharField(max_length=30)),
('unit', models.CharField(blank=True, max_length=30)),
('department', models.CharField(max_length=30)),
('degree', models.CharField(choices=[('prof.', 'Prof.'), ('dr.', 'Dr.'), ('post-doc', 'Post-Doc'), ('graduate', 'Graduate'), ('undergraduate', 'Undergraduate'), ('other', 'Other')], max_length=10)),
('country', models.CharField(choices=[('AF', 'Afghanistan'), ('AX', 'Aland Islands'), ('AL', 'Albania'), ('DZ', 'Algeria'), ('AS', 'American Samoa'), ('AD', 'Andorra'), ('AO', 'Angola'), ('AI', 'Anguilla'), ('AQ', 'Antarctica'), ('AG', 'Antigua and Barbuda'), ('AR', 'Argentina'), ('AM', 'Armenia'), ('AW', 'Aruba'), ('AU', 'Australia'), ('AT', 'Austria'), ('AZ', 'Azerbaijan'), ('BS', 'Bahamas'), ('BH', 'Bahrain'), ('BD', 'Bangladesh'), ('BB', 'Barbados'), ('BY', 'Belarus'), ('BE', 'Belgium'), ('BZ', 'Belize'), ('BJ', 'Benin'), ('BM', 'Bermuda'), ('BT', 'Bhutan'), ('BO', 'Bolivia'), ('BQ', 'Bonaire, Saint Eustatius and Saba '), ('BA', 'Bosnia and Herzegovina'), ('BW', 'Botswana'), ('BV', 'Bouvet Island'), ('BR', 'Brazil'), ('IO', 'British Indian Ocean Territory'), ('VG', 'British Virgin Islands'), ('BN', 'Brunei'), ('BG', 'Bulgaria'), ('BF', 'Burkina Faso'), ('BI', 'Burundi'), ('KH', 'Cambodia'), ('CM', 'Cameroon'), ('CA', 'Canada'), ('CV', 'Cape Verde'), ('KY', 'Cayman Islands'), ('CF', 'Central African Republic'), ('TD', 'Chad'), ('CL', 'Chile'), ('CN', 'China'), ('CX', 'Christmas Island'), ('CC', 'Cocos Islands'), ('CO', 'Colombia'), ('KM', 'Comoros'), ('CK', 'Cook Islands'), ('CR', 'Costa Rica'), ('HR', 'Croatia'), ('CU', 'Cuba'), ('CW', 'Curacao'), ('CY', 'Cyprus'), ('CZ', 'Czech Republic'), ('CD', 'Democratic Republic of the Congo'), ('DK', 'Denmark'), ('DJ', 'Djibouti'), ('DM', 'Dominica'), ('DO', 'Dominican Republic'), ('TL', 'East Timor'), ('EC', 'Ecuador'), ('EG', 'Egypt'), ('SV', 'El Salvador'), ('GQ', 'Equatorial Guinea'), ('ER', 'Eritrea'), ('EE', 'Estonia'), ('ET', 'Ethiopia'), ('FK', 'Falkland Islands'), ('FO', 'Faroe Islands'), ('FJ', 'Fiji'), ('FI', 'Finland'), ('FR', 'France'), ('GF', 'French Guiana'), ('PF', 'French Polynesia'), ('TF', 'French Southern Territories'), ('GA', 'Gabon'), ('GM', 'Gambia'), ('GE', 'Georgia'), ('DE', 'Germany'), ('GH', 'Ghana'), ('GI', 'Gibraltar'), ('GR', 'Greece'), ('GL', 'Greenland'), ('GD', 'Grenada'), ('GP', 'Guadeloupe'), ('GU', 'Guam'), ('GT', 'Guatemala'), ('GG', 'Guernsey'), ('GN', 'Guinea'), ('GW', 'Guinea-Bissau'), ('GY', 'Guyana'), ('HT', 'Haiti'), ('HM', 'Heard Island and McDonald Islands'), ('HN', 'Honduras'), ('HK', 'Hong Kong'), ('HU', 'Hungary'), ('IS', 'Iceland'), ('IN', 'India'), ('ID', 'Indonesia'), ('IR', 'Iran'), ('IQ', 'Iraq'), ('IE', 'Ireland'), ('IM', 'Isle of Man'), ('IL', 'Israel'), ('IT', 'Italy'), ('CI', 'Ivory Coast'), ('JM', 'Jamaica'), ('JP', 'Japan'), ('JE', 'Jersey'), ('JO', 'Jordan'), ('KZ', 'Kazakhstan'), ('KE', 'Kenya'), ('KI', 'Kiribati'), ('XK', 'Kosovo'), ('KW', 'Kuwait'), ('KG', 'Kyrgyzstan'), ('LA', 'Laos'), ('LV', 'Latvia'), ('LB', 'Lebanon'), ('LS', 'Lesotho'), ('LR', 'Liberia'), ('LY', 'Libya'), ('LI', 'Liechtenstein'), ('LT', 'Lithuania'), ('LU', 'Luxembourg'), ('MO', 'Macao'), ('MK', 'Macedonia'), ('MG', 'Madagascar'), ('MW', 'Malawi'), ('MY', 'Malaysia'), ('MV', 'Maldives'), ('ML', 'Mali'), ('MT', 'Malta'), ('MH', 'Marshall Islands'), ('MQ', 'Martinique'), ('MR', 'Mauritania'), ('MU', 'Mauritius'), ('YT', 'Mayotte'), ('MX', 'Mexico'), ('FM', 'Micronesia'), ('MD', 'Moldova'), ('MC', 'Monaco'), ('MN', 'Mongolia'), ('ME', 'Montenegro'), ('MS', 'Montserrat'), ('MA', 'Morocco'), ('MZ', 'Mozambique'), ('MM', 'Myanmar'), ('NA', 'Namibia'), ('NR', 'Nauru'), ('NP', 'Nepal'), ('NL', 'Netherlands'), ('NC', 'New Caledonia'), ('NZ', 'New Zealand'), ('NI', 'Nicaragua'), ('NE', 'Niger'), ('NG', 'Nigeria'), ('NU', 'Niue'), ('NF', 'Norfolk Island'), ('KP', 'North Korea'), ('MP', 'Northern Mariana Islands'), ('NO', 'Norway'), ('OM', 'Oman'), ('PK', 'Pakistan'), ('PW', 'Palau'), ('PS', 'Palestinian Territory'), ('PA', 'Panama'), ('PG', 'Papua New Guinea'), ('PY', 'Paraguay'), ('PE', 'Peru'), ('PH', 'Philippines'), ('PN', 'Pitcairn'), ('PL', 'Poland'), ('PT', 'Portugal'), ('PR', 'Puerto Rico'), ('QA', 'Qatar'), ('CG', 'Republic of the Congo'), ('RE', 'Reunion'), ('RO', 'Romania'), ('RU', 'Russia'), ('RW', 'Rwanda'), ('BL', 'Saint Barthelemy'), ('SH', 'Saint Helena'), ('KN', 'Saint Kitts and Nevis'), ('LC', 'Saint Lucia'), ('MF', 'Saint Martin'), ('PM', 'Saint Pierre and Miquelon'), ('VC', 'Saint Vincent and the Grenadines'), ('WS', 'Samoa'), ('SM', 'San Marino'), ('ST', 'Sao Tome and Principe'), ('SA', 'Saudi Arabia'), ('SN', 'Senegal'), ('RS', 'Serbia'), ('SC', 'Seychelles'), ('SL', 'Sierra Leone'), ('SG', 'Singapore'), ('SX', 'Sint Maarten'), ('SK', 'Slovakia'), ('SI', 'Slovenia'), ('SB', 'Solomon Islands'), ('SO', 'Somalia'), ('ZA', 'South Africa'), ('GS', 'South Georgia and the South Sandwich Islands'), ('KR', 'South Korea'), ('SS', 'South Sudan'), ('ES', 'Spain'), ('LK', 'Sri Lanka'), ('SD', 'Sudan'), ('SR', 'Suriname'), ('SJ', 'Svalbard and Jan Mayen'), ('SZ', 'Swaziland'), ('SE', 'Sweden'), ('CH', 'Switzerland'), ('SY', 'Syria'), ('TW', 'Taiwan'), ('TJ', 'Tajikistan'), ('TZ', 'Tanzania'), ('TH', 'Thailand'), ('TG', 'Togo'), ('TK', 'Tokelau'), ('TO', 'Tonga'), ('TT', 'Trinidad and Tobago'), ('TN', 'Tunisia'), ('TR', 'Turkey'), ('TM', 'Turkmenistan'), ('TC', 'Turks and Caicos Islands'), ('TV', 'Tuvalu'), ('VI', 'U.S. Virgin Islands'), ('UG', 'Uganda'), ('UA', 'Ukraine'), ('AE', 'United Arab Emirates'), ('GB', 'United Kingdom'), ('US', 'United States'), ('UM', 'United States Minor Outlying Islands'), ('UY', 'Uruguay'), ('UZ', 'Uzbekistan'), ('VU', 'Vanuatu'), ('VA', 'Vatican'), ('VE', 'Venezuela'), ('VN', 'Vietnam'), ('WF', 'Wallis and Futuna'), ('EH', 'Western Sahara'), ('YE', 'Yemen'), ('ZM', 'Zambia'), ('ZW', 'Zimbabwe')], max_length=30)),
('institution_country', models.CharField(choices=[('AF', 'Afghanistan'), ('AX', 'Aland Islands'), ('AL', 'Albania'), ('DZ', 'Algeria'), ('AS', 'American Samoa'), ('AD', 'Andorra'), ('AO', 'Angola'), ('AI', 'Anguilla'), ('AQ', 'Antarctica'), ('AG', 'Antigua and Barbuda'), ('AR', 'Argentina'), ('AM', 'Armenia'), ('AW', 'Aruba'), ('AU', 'Australia'), ('AT', 'Austria'), ('AZ', 'Azerbaijan'), ('BS', 'Bahamas'), ('BH', 'Bahrain'), ('BD', 'Bangladesh'), ('BB', 'Barbados'), ('BY', 'Belarus'), ('BE', 'Belgium'), ('BZ', 'Belize'), ('BJ', 'Benin'), ('BM', 'Bermuda'), ('BT', 'Bhutan'), ('BO', 'Bolivia'), ('BQ', 'Bonaire, Saint Eustatius and Saba '), ('BA', 'Bosnia and Herzegovina'), ('BW', 'Botswana'), ('BV', 'Bouvet Island'), ('BR', 'Brazil'), ('IO', 'British Indian Ocean Territory'), ('VG', 'British Virgin Islands'), ('BN', 'Brunei'), ('BG', 'Bulgaria'), ('BF', 'Burkina Faso'), ('BI', 'Burundi'), ('KH', 'Cambodia'), ('CM', 'Cameroon'), ('CA', 'Canada'), ('CV', 'Cape Verde'), ('KY', 'Cayman Islands'), ('CF', 'Central African Republic'), ('TD', 'Chad'), ('CL', 'Chile'), ('CN', 'China'), ('CX', 'Christmas Island'), ('CC', 'Cocos Islands'), ('CO', 'Colombia'), ('KM', 'Comoros'), ('CK', 'Cook Islands'), ('CR', 'Costa Rica'), ('HR', 'Croatia'), ('CU', 'Cuba'), ('CW', 'Curacao'), ('CY', 'Cyprus'), ('CZ', 'Czech Republic'), ('CD', 'Democratic Republic of the Congo'), ('DK', 'Denmark'), ('DJ', 'Djibouti'), ('DM', 'Dominica'), ('DO', 'Dominican Republic'), ('TL', 'East Timor'), ('EC', 'Ecuador'), ('EG', 'Egypt'), ('SV', 'El Salvador'), ('GQ', 'Equatorial Guinea'), ('ER', 'Eritrea'), ('EE', 'Estonia'), ('ET', 'Ethiopia'), ('FK', 'Falkland Islands'), ('FO', 'Faroe Islands'), ('FJ', 'Fiji'), ('FI', 'Finland'), ('FR', 'France'), ('GF', 'French Guiana'), ('PF', 'French Polynesia'), ('TF', 'French Southern Territories'), ('GA', 'Gabon'), ('GM', 'Gambia'), ('GE', 'Georgia'), ('DE', 'Germany'), ('GH', 'Ghana'), ('GI', 'Gibraltar'), ('GR', 'Greece'), ('GL', 'Greenland'), ('GD', 'Grenada'), ('GP', 'Guadeloupe'), ('GU', 'Guam'), ('GT', 'Guatemala'), ('GG', 'Guernsey'), ('GN', 'Guinea'), ('GW', 'Guinea-Bissau'), ('GY', 'Guyana'), ('HT', 'Haiti'), ('HM', 'Heard Island and McDonald Islands'), ('HN', 'Honduras'), ('HK', 'Hong Kong'), ('HU', 'Hungary'), ('IS', 'Iceland'), ('IN', 'India'), ('ID', 'Indonesia'), ('IR', 'Iran'), ('IQ', 'Iraq'), ('IE', 'Ireland'), ('IM', 'Isle of Man'), ('IL', 'Israel'), ('IT', 'Italy'), ('CI', 'Ivory Coast'), ('JM', 'Jamaica'), ('JP', 'Japan'), ('JE', 'Jersey'), ('JO', 'Jordan'), ('KZ', 'Kazakhstan'), ('KE', 'Kenya'), ('KI', 'Kiribati'), ('XK', 'Kosovo'), ('KW', 'Kuwait'), ('KG', 'Kyrgyzstan'), ('LA', 'Laos'), ('LV', 'Latvia'), ('LB', 'Lebanon'), ('LS', 'Lesotho'), ('LR', 'Liberia'), ('LY', 'Libya'), ('LI', 'Liechtenstein'), ('LT', 'Lithuania'), ('LU', 'Luxembourg'), ('MO', 'Macao'), ('MK', 'Macedonia'), ('MG', 'Madagascar'), ('MW', 'Malawi'), ('MY', 'Malaysia'), ('MV', 'Maldives'), ('ML', 'Mali'), ('MT', 'Malta'), ('MH', 'Marshall Islands'), ('MQ', 'Martinique'), ('MR', 'Mauritania'), ('MU', 'Mauritius'), ('YT', 'Mayotte'), ('MX', 'Mexico'), ('FM', 'Micronesia'), ('MD', 'Moldova'), ('MC', 'Monaco'), ('MN', 'Mongolia'), ('ME', 'Montenegro'), ('MS', 'Montserrat'), ('MA', 'Morocco'), ('MZ', 'Mozambique'), ('MM', 'Myanmar'), ('NA', 'Namibia'), ('NR', 'Nauru'), ('NP', 'Nepal'), ('NL', 'Netherlands'), ('NC', 'New Caledonia'), ('NZ', 'New Zealand'), ('NI', 'Nicaragua'), ('NE', 'Niger'), ('NG', 'Nigeria'), ('NU', 'Niue'), ('NF', 'Norfolk Island'), ('KP', 'North Korea'), ('MP', 'Northern Mariana Islands'), ('NO', 'Norway'), ('OM', 'Oman'), ('PK', 'Pakistan'), ('PW', 'Palau'), ('PS', 'Palestinian Territory'), ('PA', 'Panama'), ('PG', 'Papua New Guinea'), ('PY', 'Paraguay'), ('PE', 'Peru'), ('PH', 'Philippines'), ('PN', 'Pitcairn'), ('PL', 'Poland'), ('PT', 'Portugal'), ('PR', 'Puerto Rico'), ('QA', 'Qatar'), ('CG', 'Republic of the Congo'), ('RE', 'Reunion'), ('RO', 'Romania'), ('RU', 'Russia'), ('RW', 'Rwanda'), ('BL', 'Saint Barthelemy'), ('SH', 'Saint Helena'), ('KN', 'Saint Kitts and Nevis'), ('LC', 'Saint Lucia'), ('MF', 'Saint Martin'), ('PM', 'Saint Pierre and Miquelon'), ('VC', 'Saint Vincent and the Grenadines'), ('WS', 'Samoa'), ('SM', 'San Marino'), ('ST', 'Sao Tome and Principe'), ('SA', 'Saudi Arabia'), ('SN', 'Senegal'), ('RS', 'Serbia'), ('SC', 'Seychelles'), ('SL', 'Sierra Leone'), ('SG', 'Singapore'), ('SX', 'Sint Maarten'), ('SK', 'Slovakia'), ('SI', 'Slovenia'), ('SB', 'Solomon Islands'), ('SO', 'Somalia'), ('ZA', 'South Africa'), ('GS', 'South Georgia and the South Sandwich Islands'), ('KR', 'South Korea'), ('SS', 'South Sudan'), ('ES', 'Spain'), ('LK', 'Sri Lanka'), ('SD', 'Sudan'), ('SR', 'Suriname'), ('SJ', 'Svalbard and Jan Mayen'), ('SZ', 'Swaziland'), ('SE', 'Sweden'), ('CH', 'Switzerland'), ('SY', 'Syria'), ('TW', 'Taiwan'), ('TJ', 'Tajikistan'), ('TZ', 'Tanzania'), ('TH', 'Thailand'), ('TG', 'Togo'), ('TK', 'Tokelau'), ('TO', 'Tonga'), ('TT', 'Trinidad and Tobago'), ('TN', 'Tunisia'), ('TR', 'Turkey'), ('TM', 'Turkmenistan'), ('TC', 'Turks and Caicos Islands'), ('TV', 'Tuvalu'), ('VI', 'U.S. Virgin Islands'), ('UG', 'Uganda'), ('UA', 'Ukraine'), ('AE', 'United Arab Emirates'), ('GB', 'United Kingdom'), ('US', 'United States'), ('UM', 'United States Minor Outlying Islands'), ('UY', 'Uruguay'), ('UZ', 'Uzbekistan'), ('VU', 'Vanuatu'), ('VA', 'Vatican'), ('VE', 'Venezuela'), ('VN', 'Vietnam'), ('WF', 'Wallis and Futuna'), ('EH', 'Western Sahara'), ('YE', 'Yemen'), ('ZM', 'Zambia'), ('ZW', 'Zimbabwe')], max_length=30)),
('address', models.TextField()),
('phone_number', models.CharField(default='', max_length=20)),
('abstarct_file', models.FileField(help_text='Browse a file', upload_to=dashboard.models.user_directory_path, validators=[django.core.validators.FileExtensionValidator(['pdf', '.docx', 'rtf'])])),
('uploaded_at', models.DateTimeField(blank=True, null=True)),
('accept', models.BooleanField(default=False)),
('paypal_trans_id', models.CharField(max_length=17)),
('user_status', models.CharField(choices=[('waiting', 'Waiting'), ('pending', 'Pending'), ('confirm', 'Confirm'), ('decline', 'Decline')], default='waiting', max_length=30)),
('user_type', models.CharField(choices=[('listener', 'Listener'), ('author', 'Author')], default='listener', max_length=30)),
('update', models.DateTimeField(auto_now=True)),
('timestamp', models.DateTimeField(auto_now_add=True)),
('user', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)),
],
),
]
class Migration(migrations.Migration):
initial = True
dependencies = []
operations = [
migrations.CreateModel(
name='BillingInfo',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('vat_code',
models.CharField(blank=True, max_length=50, null=True)),
('company_name',
models.CharField(blank=True, max_length=50, null=True)),
('payment_point',
models.CharField(blank=True, max_length=100, null=True)),
('payment_currency',
models.CharField(blank=True, max_length=3, null=True)),
('address_1',
models.CharField(blank=True, max_length=300, null=True)),
('address_2',
models.CharField(blank=True, max_length=300, null=True)),
('city', models.CharField(blank=True,
max_length=300,
null=True)),
('state',
models.CharField(blank=True, max_length=300, null=True)),
('zip', models.CharField(blank=True, max_length=300,
null=True)),
('country',
models.CharField(blank=True, max_length=100, null=True)),
('comments',
models.CharField(blank=True, max_length=300, null=True)),
('telephone',
models.CharField(blank=True, max_length=300, null=True)),
],
),
migrations.CreateModel(
name='Hotels',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('hotel_property_id', models.IntegerField(blank=True,
null=True)),
('hotel_status',
models.CharField(blank=True, max_length=3, null=True)),
('hotel_chain_code',
models.CharField(blank=True, max_length=15, null=True)),
('hotel_chain_name',
models.CharField(blank=True, max_length=100, null=True)),
('hotel_name',
models.CharField(blank=True, max_length=100, null=True)),
('hotel_group',
models.CharField(blank=True, max_length=100, null=True)),
('address1',
models.CharField(blank=True, max_length=100, null=True)),
('address2',
models.CharField(blank=True, max_length=100, null=True)),
('address3',
models.CharField(blank=True, max_length=100, null=True)),
('postal_city',
models.CharField(blank=True, max_length=100, null=True)),
('state_code',
models.CharField(blank=True, max_length=100, null=True)),
('state_name',
models.CharField(blank=True, max_length=100, null=True)),
('zip', models.CharField(blank=True, max_length=100,
null=True)),
('airport_city_code',
models.CharField(blank=True, max_length=100, null=True)),
('phone_area_zone',
models.CharField(blank=True, max_length=100, null=True)),
('fax_area_zone',
models.CharField(blank=True, max_length=100, null=True)),
('Location_name',
models.CharField(blank=True, max_length=100, null=True)),
('phone',
models.CharField(blank=True, max_length=100, null=True)),
('hotel_fax',
models.CharField(blank=True, max_length=100, null=True)),
('hotel_email',
models.CharField(blank=True, max_length=100, null=True)),
('website',
models.CharField(blank=True, max_length=100, null=True)),
('country_code',
models.CharField(blank=True, max_length=3, null=True)),
('country_name',
models.CharField(blank=True, max_length=100, null=True)),
('world_area_name',
models.CharField(blank=True, max_length=100, null=True)),
('world_area_code',
models.CharField(blank=True, max_length=100, null=True)),
],
),
migrations.CreateModel(
name='Inbound',
fields=[
('version', models.CharField(max_length=100)),
('uniquebookingid',
models.CharField(max_length=100,
primary_key=True,
serialize=False)),
('pnr', models.CharField(max_length=10)),
('sequnceno', models.CharField(max_length=20)),
('createdate', models.CharField(max_length=100)),
('modifydate', models.CharField(max_length=100)),
('lineno', models.CharField(max_length=100)),
('agencyidtype', models.CharField(max_length=100)),
('agencyid', models.CharField(max_length=100)),
('bookingagent', models.CharField(max_length=100)),
('guestname', models.CharField(max_length=100)),
('corporateid', models.CharField(max_length=100)),
('agentrref1', models.CharField(max_length=100)),
('agentrref2', models.CharField(max_length=100)),
('agentref3', models.CharField(max_length=100)),
('numberofrooms', models.IntegerField(blank=True, null=True)),
('numberofnights', models.IntegerField(blank=True, null=True)),
('datein', models.DateTimeField(auto_now_add=True, null=True)),
('dateout', models.DateTimeField(auto_now_add=True,
null=True)),
('commission_percentage_ob', models.CharField(max_length=100)),
('costprnight', models.FloatField()),
('fixedcommission', models.CharField(max_length=100)),
('currency', models.CharField(max_length=100)),
('sales_fare_code', models.CharField(max_length=100)),
('cwt_rate_access_code', models.CharField(max_length=100)),
('sales_fare_agency_client_id',
models.CharField(max_length=100)),
('rate_description', models.CharField(max_length=100)),
('gds_commission_text', models.CharField(max_length=100)),
('accomodationtype', models.CharField(max_length=100)),
('confirmaitonnumber', models.CharField(max_length=100)),
('hotelpropertyid', models.IntegerField()),
('hotel_chain_code', models.CharField(max_length=100)),
('hotelname', models.CharField(max_length=100)),
('address1', models.CharField(max_length=100)),
('address2', models.CharField(max_length=100)),
('city', models.CharField(max_length=100)),
('state', models.CharField(max_length=100)),
('zip', models.CharField(max_length=100)),
('airportcitycode', models.CharField(max_length=100)),
('phone', models.CharField(max_length=100)),
('fax', models.CharField(max_length=100)),
('countrycode', models.CharField(max_length=100)),
('agentstatuscode', models.CharField(max_length=100)),
('agentpaymentcode', models.CharField(max_length=100)),
('bookingstatuscode',
models.CharField(blank=True, max_length=3, null=True)),
('user_id',
models.CharField(blank=True, max_length=100, null=True)),
('status_date_time',
models.DateTimeField(auto_now_add=True, null=True)),
('conf_no_rooms', models.IntegerField(blank=True, null=True)),
('conf_no_nights', models.IntegerField(blank=True, null=True)),
('conf_datein', models.DateTimeField(blank=True, null=True)),
('conf_dateout', models.DateTimeField(blank=True, null=True)),
('conf_cost_per_nights',
models.FloatField(blank=True, null=True)),
('conf_currency',
models.CharField(blank=True, max_length=3, null=True)),
('conf_commission_percentage',
models.FloatField(blank=True, null=True)),
('is_checkedout', models.BooleanField(default=False)),
('is_paid', models.BooleanField(default=False)),
('is_payment_validated', models.BooleanField(default=False)),
('is_invoiced', models.BooleanField(default=False)),
('payment_date', models.DateTimeField(blank=True, null=True)),
('paid_commission', models.FloatField(blank=True, null=True)),
('vat_amount', models.FloatField(blank=True, null=True)),
('paid_currency',
models.CharField(blank=True, max_length=3, null=True)),
('payment_point',
models.CharField(blank=True, max_length=100, null=True)),
('payment_status',
models.CharField(blank=True, max_length=3, null=True)),
('bank_charge_amount', models.FloatField(blank=True,
null=True)),
],
),
migrations.CreateModel(
name='Invoice',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('status',
models.PositiveSmallIntegerField(
blank=True,
choices=[(1, 'Issued invoice'),
(2, 'Pending for accounting'),
(3, 'Requested for invoice')],
null=True)),
('description',
models.CharField(blank=True, max_length=200, null=True)),
('invoice_number',
models.CharField(
blank=True,
default=dashboard.models.generate_invoice_number,
max_length=100,
null=True)),
('quantity', models.IntegerField(blank=True, null=True)),
('price', models.FloatField(blank=True, null=True)),
('country',
models.CharField(blank=True, max_length=100, null=True)),
('country_code',
models.CharField(blank=True, max_length=2, null=True)),
('timestamp', models.DateTimeField(blank=True, null=True)),
('attachment',
models.BinaryField(blank=True, max_length=200, null=True)),
('issue_date', models.DateTimeField(blank=True, null=True)),
('vat_amount', models.FloatField(blank=True, null=True)),
('bank_charge_amount', models.FloatField(blank=True,
null=True)),
],
),
migrations.CreateModel(
name='PaymentInfo',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('payment_channel',
models.CharField(blank=True, max_length=50, null=True)),
('payment_date', models.DateField(blank=True, null=True)),
('deposit_date', models.DateField(blank=True, null=True)),
('payment_reference',
models.CharField(blank=True, max_length=200, null=True)),
('payment_doc',
models.FileField(blank=True,
null=True,
upload_to='documents/users')),
('description',
models.CharField(blank=True, max_length=200, null=True)),
('paid_commission', models.FloatField(blank=True, null=True)),
('paid_currency',
models.CharField(blank=True, max_length=3, null=True)),
('vat_amount', models.FloatField(blank=True, null=True)),
('bank_charge_amount', models.FloatField(blank=True,
null=True)),
],
),
migrations.CreateModel(
name='User_management',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('company', models.CharField(max_length=100)),
('employee_name', models.CharField(max_length=100)),
('employee_email', models.EmailField(max_length=254)),
('is_suppervisor', models.BooleanField(default=False)),
('is_active', models.BooleanField(default=True)),
('legal_name', models.CharField(max_length=100)),
('address1', models.CharField(max_length=200)),
('address2', models.CharField(max_length=200)),
('city', models.CharField(max_length=45)),
('tax_number', models.CharField(max_length=45)),
('contract_start', models.DateField()),
('contract_end', models.DateField()),
('group_id', models.CharField(max_length=100)),
('chain_id', models.CharField(max_length=100)),
('property_id', models.CharField(max_length=100)),
('scope',
multiselectfield.db.fields.MultiSelectField(choices=[
('Global', 'Global'), ('Region', 'Region'),
('Zeone', 'Zone'), ('Country', 'Country')
],
max_length=27)),
('region', models.CharField(max_length=20)),
('country', models.CharField(max_length=45)),
],
),
migrations.CreateModel(
name='UserProfile',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('role',
models.PositiveSmallIntegerField(blank=True,
choices=[(1, 'Admin'),
(2, 'Supervisor'),
(3, 'Employee')],
null=True)),
('first_name', models.CharField(max_length=50, null=True)),
('last_name', models.CharField(max_length=50, null=True)),
('address',
models.CharField(blank=True, max_length=300, null=True)),
('city', models.CharField(blank=True, max_length=20,
null=True)),
('state', models.CharField(blank=True,
max_length=20,
null=True)),
('zip', models.CharField(blank=True, max_length=20,
null=True)),
('country',
models.CharField(blank=True, max_length=20, null=True)),
('telephone',
models.CharField(blank=True, max_length=20, null=True)),
('website', models.URLField(blank=True, default='',
null=True)),
('image',
models.FileField(blank=True,
default='images/users/Pic.jpg',
null=True,
upload_to='images/users')),
],
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
('auth', '0008_alter_user_username_max_length'),
]
operations = [
migrations.CreateModel(
name='User',
fields=[
('id',
models.AutoField(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')),
('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.ASCIIUsernameValidator(
)
],
verbose_name='username')),
('first_name',
models.CharField(blank=True,
max_length=30,
verbose_name='first name')),
('last_name',
models.CharField(blank=True,
max_length=30,
verbose_name='last name')),
('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')),
('user_type',
models.PositiveSmallIntegerField(choices=[(1, 'Private User'),
(2, 'Company User'),
(3, 'Employee User')
],
editable=False,
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={
'abstract': False,
'verbose_name': 'user',
'verbose_name_plural': 'users',
},
managers=[
('objects', django.contrib.auth.models.UserManager()),
],
),
migrations.CreateModel(
name='AudioFile',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('upload_datetime', models.DateTimeField(auto_now_add=True)),
('file',
models.FileField(
editable=False,
upload_to=dashboard.models._get_relative_file_path)),
('is_public', models.BooleanField(default=False)),
('name', models.CharField(max_length=256)),
('description', models.CharField(blank=True, max_length=500)),
('language_spoken',
models.CharField(choices=[
('af', 'Afrikaans'), ('ar', 'Arabic'),
('ast', 'Asturian'), ('az', 'Azerbaijani'),
('bg', 'Bulgarian'), ('be', 'Belarusian'),
('bn', 'Bengali'), ('br', 'Breton'), ('bs', 'Bosnian'),
('ca', 'Catalan'), ('cs', 'Czech'), ('cy', 'Welsh'),
('da', 'Danish'), ('de', 'German'),
('dsb', 'Lower Sorbian'), ('el', 'Greek'),
('en', 'English'), ('en-au', 'Australian English'),
('en-gb', 'British English'), ('eo', 'Esperanto'),
('es', 'Spanish'), ('es-ar', 'Argentinian Spanish'),
('es-co', 'Colombian Spanish'),
('es-mx', 'Mexican Spanish'),
('es-ni', 'Nicaraguan Spanish'),
('es-ve', 'Venezuelan Spanish'), ('et', 'Estonian'),
('eu', 'Basque'), ('fa', 'Persian'), ('fi', 'Finnish'),
('fr', 'French'), ('fy', 'Frisian'), ('ga', 'Irish'),
('gd', 'Scottish Gaelic'), ('gl', 'Galician'),
('he', 'Hebrew'), ('hi', 'Hindi'), ('hr', 'Croatian'),
('hsb', 'Upper Sorbian'), ('hu', 'Hungarian'),
('ia', 'Interlingua'),
('id', 'Indonesian'), ('io', 'Ido'), ('is', 'Icelandic'),
('it', 'Italian'), ('ja', 'Japanese'), ('ka', 'Georgian'),
('kk', 'Kazakh'), ('km', 'Khmer'), ('kn', 'Kannada'),
('ko', 'Korean'), ('lb', 'Luxembourgish'),
('lt', 'Lithuanian'), ('lv', 'Latvian'),
('mk', 'Macedonian'), ('ml', 'Malayalam'),
('mn', 'Mongolian'), ('mr', 'Marathi'), ('my', 'Burmese'),
('nb', 'Norwegian Bokm\xe5l'), ('ne', 'Nepali'),
('nl', 'Dutch'), ('nn', 'Norwegian Nynorsk'),
('os', 'Ossetic'), ('pa', 'Punjabi'), ('pl', 'Polish'),
('pt', 'Portuguese'), ('pt-br', 'Brazilian Portuguese'),
('ro', 'Romanian'), ('ru', 'Russian'), ('sk', 'Slovak'),
('sl', 'Slovenian'), ('sq', 'Albanian'),
('sr', 'Serbian'), ('sr-latn', 'Serbian Latin'),
('sv', 'Swedish'), ('sw', 'Swahili'), ('ta', 'Tamil'),
('te', 'Telugu'), ('th', 'Thai'), ('tr', 'Turkish'),
('tt', 'Tatar'), ('udm', 'Udmurt'), ('uk', 'Ukrainian'),
('ur', 'Urdu'), ('vi', 'Vietnamese'),
('zh-hans', 'Simplified Chinese'),
('zh-hant', 'Traditional Chinese')
],
editable=False,
max_length=5)),
('duration', models.DurationField(editable=False)),
('uploader',
models.ForeignKey(editable=False,
on_delete=django.db.models.deletion.CASCADE,
related_name='files',
to=settings.AUTH_USER_MODEL)),
],
),
migrations.CreateModel(
name='Company',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=50)),
('vat_no',
models.CharField(
max_length=30,
unique=True,
validators=[vatno_validator.validators.VATNoValidator()
])),
],
),
migrations.CreateModel(
name='CompanyUser',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('phone_number',
phonenumber_field.modelfields.PhoneNumberField(
max_length=128)),
('company',
models.OneToOneField(
on_delete=django.db.models.deletion.CASCADE,
related_name='contact_person',
to='dashboard.Company')),
('user',
models.OneToOneField(
on_delete=django.db.models.deletion.CASCADE,
related_name='company_user',
to=settings.AUTH_USER_MODEL)),
],
options={
'abstract': False,
},
),
migrations.CreateModel(
name='CreditsPacketOffer',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('date_start', models.DateField(default=datetime.date.today)),
('date_end', models.DateField(blank=True, null=True)),
('minutes_per_credit',
models.PositiveSmallIntegerField(validators=[
django.core.validators.MinValueValidator(
5, 'Cannot set minutes per credit value less than 5'),
django.core.validators.MaxValueValidator(
60,
'Cannot set minutes per credit value greater than 60')
])),
('cost_per_credit', models.FloatField()),
],
),
migrations.CreateModel(
name='CreditsPacketPurchase',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('datetime', models.DateTimeField(auto_now_add=True)),
('expiration_date', models.DateField()),
('credits_purchased',
models.PositiveSmallIntegerField(validators=[
django.core.validators.MinValueValidator(
1, 'You cannot buy less than 1 credit')
])),
('credits_remaining', models.PositiveSmallIntegerField()),
('customer',
models.ForeignKey(
null=True,
on_delete=django.db.models.deletion.SET_NULL,
related_name='purchases',
to=settings.AUTH_USER_MODEL)),
('offer',
models.ForeignKey(on_delete=django.db.models.deletion.PROTECT,
related_name='purchases',
to='dashboard.CreditsPacketOffer')),
],
),
migrations.CreateModel(
name='EmployeeUser',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('company',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='employees',
to='dashboard.Company')),
('user',
models.OneToOneField(
on_delete=django.db.models.deletion.CASCADE,
related_name='employee_user',
to=settings.AUTH_USER_MODEL)),
],
options={
'abstract': False,
},
),
migrations.CreateModel(
name='PrivateUser',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('user',
models.OneToOneField(
on_delete=django.db.models.deletion.CASCADE,
related_name='private_user',
to=settings.AUTH_USER_MODEL)),
],
options={
'abstract': False,
},
),
migrations.CreateModel(
name='Transcription',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('offset', models.DurationField()),
('confidence', models.FloatField()),
('text', models.TextField(blank=True)),
('file',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='transcriptions',
to='dashboard.AudioFile')),
],
),
]
class Migration(migrations.Migration):
initial = True
dependencies = []
operations = [
migrations.CreateModel(
name='Attachment',
fields=[
('id',
models.BigAutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('file',
models.FileField(
blank=True,
upload_to=dashboard.models.attachment_directory_path)),
('created_at', models.DateTimeField(auto_now_add=True)),
],
),
migrations.CreateModel(
name='Group',
fields=[
('id',
models.BigAutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('title', models.CharField(blank=True, max_length=20)),
('created_at', models.DateTimeField(auto_now_add=True)),
('updated_at', models.DateTimeField(auto_now_add=True)),
],
),
migrations.CreateModel(
name='Message',
fields=[
('id',
models.BigAutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('content', models.TextField(blank=True, max_length=2000)),
('created_at', models.DateTimeField(auto_now_add=True)),
],
),
migrations.CreateModel(
name='MessageState',
fields=[
('id',
models.BigAutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('read', models.BooleanField(default=False)),
],
),
migrations.CreateModel(
name='MessageThread',
fields=[
('id',
models.BigAutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('content', models.TextField(blank=True, max_length=2000)),
('created_at', models.DateTimeField(auto_now_add=True)),
('attachments',
models.ManyToManyField(to='dashboard.Attachment')),
],
),
]
class Migration(migrations.Migration):
dependencies = [
('dashboard', '0001_initial'),
]
operations = [
migrations.CreateModel(
name='PG',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('pg_name', models.CharField(max_length=120)),
('arealocated', models.CharField(max_length=120)),
('famous_landmark', models.CharField(max_length=120)),
('pg_type',
models.CharField(choices=[('Men', 'Men'), ('Women', 'Women')],
max_length=50)),
],
),
migrations.AlterField(
model_name='customer',
name='mobile_no',
field=models.CharField(max_length=10, unique=True),
),
migrations.CreateModel(
name='PGDetails',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('main1',
models.FileField(upload_to=dashboard.models.pg_name_get)),
('main2',
models.FileField(upload_to=dashboard.models.pg_name_get)),
('single_sharing',
models.FileField(upload_to=dashboard.models.pg_name_get)),
('double_sharing',
models.FileField(upload_to=dashboard.models.pg_name_get)),
('three_sharing',
models.FileField(upload_to=dashboard.models.pg_name_get)),
('four_sharing',
models.FileField(upload_to=dashboard.models.pg_name_get)),
('kitchen',
models.FileField(upload_to=dashboard.models.pg_name_get)),
('bathroom',
models.FileField(upload_to=dashboard.models.pg_name_get)),
('location',
models.FileField(upload_to=dashboard.models.pg_name_get)),
('pg_ob',
models.OneToOneField(
on_delete=django.db.models.deletion.CASCADE,
to='dashboard.PG')),
],
),
migrations.AddField(
model_name='pg',
name='owner',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to='dashboard.Customer'),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = []
operations = [
migrations.CreateModel(
name='Host',
fields=[
('id', models.AutoField(primary_key=True, serialize=False)),
('hostIdentifier', models.CharField(blank=True,
max_length=30)),
('hostIp',
models.CharField(blank=True, max_length=30, unique=True)),
('hostUsername', models.CharField(blank=True, max_length=30)),
('hostPassword', models.CharField(blank=True, max_length=30)),
('status', models.CharField(default='initiated',
max_length=30)),
('hostDocker', models.CharField(blank=True, max_length=30)),
('hostNginx', models.CharField(blank=True, max_length=30)),
('hostMysql', models.CharField(blank=True, max_length=30)),
('hostMongo', models.CharField(blank=True, max_length=30)),
('mysqlUsername', models.CharField(blank=True, max_length=50)),
('mysqlPassword', models.CharField(blank=True, max_length=50)),
('mongoUsername', models.CharField(blank=True, max_length=50)),
('mongoPassword', models.CharField(blank=True, max_length=50)),
],
options={
'permissions': (('view_content', 'View content'), ),
},
),
migrations.CreateModel(
name='hostdeploy',
fields=[
('id', models.AutoField(primary_key=True, serialize=False)),
('hostipdeploy', models.CharField(blank=True, max_length=500)),
('hostiplegacy', models.CharField(blank=True, max_length=500)),
],
),
migrations.CreateModel(
name='hoststatus',
fields=[
('id', models.AutoField(primary_key=True, serialize=False)),
('sshstatus', models.CharField(blank=True, max_length=1000)),
('dockerstatus', models.CharField(blank=True,
max_length=1000)),
('mongostatus', models.CharField(blank=True, max_length=1000)),
('mysqlstatus', models.CharField(blank=True, max_length=1000)),
],
),
migrations.CreateModel(
name='mongoform',
fields=[
('requester', models.CharField(blank=True, max_length=100)),
('id', models.AutoField(primary_key=True, serialize=False)),
('hostip', models.CharField(blank=True, max_length=500)),
('MONGO_INITDB_DATABASE_VALUE',
models.CharField(blank=True, max_length=500)),
('MONGO_INITDB_ROOT_USERNAME_VALUE',
models.CharField(blank=True, max_length=500)),
('MONGO_INITDB_ROOT_PASSWORD_VALUE',
models.CharField(blank=True, max_length=500)),
('status', models.CharField(default='submitted',
max_length=30)),
],
),
migrations.CreateModel(
name='mysqluser',
fields=[
('requester', models.CharField(blank=True, max_length=100)),
('id', models.AutoField(primary_key=True, serialize=False)),
('hostIp', models.CharField(blank=True, max_length=30)),
('MYSQL_DATABASE_NAME_VALUE',
models.CharField(blank=True, max_length=100)),
('MYSQL_USER_NAME_VALUE',
models.CharField(blank=True, max_length=100)),
('MYSQL_PASSWORD_VALUE',
models.CharField(blank=True, max_length=100)),
('status', models.CharField(default='submitted',
max_length=30)),
],
),
migrations.CreateModel(
name='Ports',
fields=[
('id', models.AutoField(primary_key=True, serialize=False)),
('port', models.CharField(blank=True, max_length=30)),
('status', models.CharField(blank=True, max_length=30)),
('projectname', models.CharField(blank=True, max_length=30)),
('ptype', models.CharField(blank=True, max_length=30)),
],
),
migrations.CreateModel(
name='Project',
fields=[
('requester', models.CharField(blank=True, max_length=100)),
('id', models.AutoField(primary_key=True, serialize=False)),
('platform', models.CharField(blank=True, max_length=30)),
('hostIp', models.CharField(blank=True, max_length=30)),
('hostIp_mysql', models.CharField(blank=True, max_length=30)),
('legacy1', models.CharField(default='Yes', max_length=30)),
('envtype', models.CharField(blank=True, max_length=30)),
('project_name',
models.CharField(blank=True, max_length=30, unique=True)),
('application_name', models.CharField(blank=True,
max_length=30)),
('repo_type', models.CharField(blank=True, max_length=256)),
('git_url', models.CharField(blank=True, max_length=256)),
('git_token', models.CharField(blank=True, max_length=256)),
('git_username', models.CharField(blank=True, max_length=256)),
('git_branch', models.CharField(blank=True, max_length=256)),
('status', models.CharField(default='submitted',
max_length=30)),
('approvedBy', models.CharField(blank=True, max_length=256)),
('UBUNTU_VERSION', models.CharField(blank=True,
max_length=256)),
('PHP_VERSION', models.CharField(blank=True, max_length=256)),
('PHP_MODULES', models.CharField(blank=True, max_length=256)),
('fileopp', models.CharField(blank=True, max_length=30)),
('document',
models.FileField(
blank=True, upload_to=dashboard.models.unique_file_path)),
('NGINX_SERVER_ROOT_VALUE',
models.CharField(blank=True, max_length=500)),
('NGINX_STATIC_CONTENT_ACCESS_LOG_VALUE',
models.CharField(blank=True, max_length=500)),
('NGINX_STATIC_CONTENT_EXPIRES_VALUE',
models.CharField(blank=True, max_length=500)),
('total', models.CharField(blank=True, max_length=100)),
('key1', models.CharField(blank=True, max_length=100)),
('value1', models.CharField(blank=True, max_length=100)),
('key2', models.CharField(blank=True, max_length=100)),
('value2', models.CharField(blank=True, max_length=100)),
('key3', models.CharField(blank=True, max_length=100)),
('value3', models.CharField(blank=True, max_length=100)),
('key4', models.CharField(blank=True, max_length=100)),
('value4', models.CharField(blank=True, max_length=100)),
('key5', models.CharField(blank=True, max_length=100)),
('value5', models.CharField(blank=True, max_length=100)),
('MONGO_INITDB_DATABASE_VALUE',
models.CharField(blank=True, max_length=500)),
('MONGO_INITDB_ROOT_USERNAME_VALUE',
models.CharField(blank=True, max_length=500)),
('MONGO_INITDB_ROOT_PASSWORD_VALUE',
models.CharField(blank=True, max_length=500)),
('mongo_version', models.CharField(blank=True,
max_length=500)),
('mysql_version', models.CharField(blank=True, max_length=20)),
('MYSQL_DATABASE_NAME_VALUE',
models.CharField(blank=True, max_length=100)),
('MYSQL_ROOT_PASSWORD_VALUE',
models.CharField(blank=True, max_length=100)),
('MYSQL_USER_NAME_VALUE',
models.CharField(blank=True, max_length=100)),
('MYSQL_PASSWORD_VALUE',
models.CharField(blank=True, max_length=100)),
('MYSQL_CLIENT_DEFAULT_CHARACTER_SET_VALUE',
models.CharField(blank=True, max_length=100)),
('varnish_version', models.CharField(blank=True,
max_length=100)),
('VARNISH_BACKEND_HOST_VALUE',
models.CharField(blank=True, max_length=100)),
('VARNISH_BACKEND_PORT_VALUE',
models.CharField(blank=True, max_length=100)),
('VARNISH_PORT_VALUE',
models.CharField(blank=True, max_length=100)),
('redis_version', models.CharField(blank=True,
max_length=100)),
('REDIS_PASSWORD_VALUE',
models.CharField(blank=True, max_length=100)),
],
options={
'permissions': (('view_content', 'View content'), ),
},
),
migrations.CreateModel(
name='runningstack',
fields=[
('id', models.AutoField(primary_key=True, serialize=False)),
('projectname', models.CharField(blank=True, max_length=50)),
('status', models.CharField(blank=True, max_length=50)),
('url', models.CharField(blank=True, max_length=50)),
('urlStatus', models.CharField(blank=True, max_length=50)),
('hostIp', models.CharField(blank=True, max_length=50)),
('hostStatus', models.CharField(blank=True, max_length=50)),
('nginxport', models.CharField(blank=True, max_length=50)),
('varnishport', models.CharField(blank=True, max_length=50)),
('mysqluname', models.CharField(blank=True, max_length=50)),
('mysqlupwd', models.CharField(blank=True, max_length=50)),
('mysqlstatus', models.CharField(blank=True, max_length=50)),
('mongouname', models.CharField(blank=True, max_length=50)),
('mongoupwd', models.CharField(blank=True, max_length=50)),
('mongostatus', models.CharField(blank=True, max_length=50)),
('approvedBy', models.CharField(blank=True, max_length=256)),
],
),
migrations.CreateModel(
name='status',
fields=[
('id', models.AutoField(primary_key=True, serialize=False)),
('projectname', models.CharField(blank=True, max_length=1000)),
('sshstatus', models.CharField(blank=True, max_length=1000)),
('dockerstatus', models.CharField(blank=True,
max_length=1000)),
('urlstatus', models.CharField(blank=True, max_length=1000)),
('mongostatus', models.CharField(blank=True, max_length=1000)),
('mysqlstatus', models.CharField(blank=True, max_length=1000)),
('nginxstatus', models.CharField(blank=True, max_length=1000)),
('varnishstatus', models.CharField(blank=True,
max_length=1000)),
('redisstatus', models.CharField(blank=True, max_length=1000)),
('mysqlid', models.CharField(blank=True, max_length=1000)),
('mysqlname', models.CharField(blank=True, max_length=1000)),
('mysqlst', models.CharField(blank=True, max_length=1000)),
('mongoid', models.CharField(blank=True, max_length=1000)),
('mongoname', models.CharField(blank=True, max_length=1000)),
('mongost', models.CharField(blank=True, max_length=1000)),
('varnishid', models.CharField(blank=True, max_length=1000)),
('varnishname', models.CharField(blank=True, max_length=1000)),
('varnishst', models.CharField(blank=True, max_length=1000)),
('nginxid', models.CharField(blank=True, max_length=1000)),
('nginxname', models.CharField(blank=True, max_length=1000)),
('nginxst', models.CharField(blank=True, max_length=1000)),
('redisid', models.CharField(blank=True, max_length=1000)),
('redisname', models.CharField(blank=True, max_length=1000)),
('redisst', models.CharField(blank=True, max_length=1000)),
],
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
]
operations = [
migrations.CreateModel(
name='Files',
fields=[
('id',
models.UUIDField(default=uuid.uuid4,
help_text='Unique ID for each uploaded file',
primary_key=True,
serialize=False,
verbose_name='Unique ID')),
('name',
models.CharField(
help_text=
'Enter a name for the file (less than 100 characters)',
max_length=100,
verbose_name='File Name')),
('file',
models.FileField(upload_to=dashboard.models.user_upload_path,
verbose_name='Uploaded File')),
('file_type',
models.CharField(choices=[('v', 'Video'), ('t', 'Text'),
('o', 'Voice'), ('i', 'Image'),
('u', 'Unclassified')],
default='u',
max_length=1,
verbose_name='File Type')),
('upload_datetime',
models.DateTimeField(auto_now_add=True,
verbose_name='Upload Datetime')),
('deleted',
models.BooleanField(default=False,
verbose_name='Is Deleted')),
('delete_datetime',
models.DateTimeField(blank=True,
null=True,
verbose_name='Deletion Datetime')),
('count_analyzed',
models.IntegerField(default=0,
verbose_name='Count of Analysis')),
('delete_by',
models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.SET_NULL,
related_name='delete_by',
to=settings.AUTH_USER_MODEL)),
('upload_by',
models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.SET_NULL,
related_name='upload_by',
to=settings.AUTH_USER_MODEL)),
],
options={
'ordering': ['-upload_datetime'],
'permissions': (('can_view_any_file', 'View Any File'),
('can_delete_any_file', 'Delete Any File')),
},
),
migrations.CreateModel(
name='ImageMetrics',
fields=[
('id',
models.UUIDField(
default=uuid.uuid4,
help_text='Unique Id for each file analysis record',
primary_key=True,
serialize=False,
verbose_name='Unique ID')),
('calc_status',
models.CharField(choices=[('s', 'Success'), ('e', 'Error')],
max_length=1,
null=True,
verbose_name='Analysis Status')),
('marked_image',
models.FileField(null=True,
upload_to=dashboard.models.marked_file_path,
verbose_name='Marked Image')),
('create_datetime',
models.DateTimeField(auto_now_add=True,
verbose_name='Creation Datetime')),
('file_id',
models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.SET_NULL,
to='dashboard.Files')),
],
options={
'ordering': ['-create_datetime'],
},
),
migrations.CreateModel(
name='VideoMetrics',
fields=[
('id',
models.UUIDField(
default=uuid.uuid4,
help_text='Unique Id for each file analysis record',
primary_key=True,
serialize=False,
verbose_name='Unique ID')),
('calc_status',
models.CharField(choices=[('s', 'Success'), ('e', 'Error')],
max_length=1,
null=True,
verbose_name='Analysis Status')),
('marked_video',
models.FileField(null=True,
upload_to=dashboard.models.marked_file_path,
verbose_name='Marked Video')),
('frame_num',
models.IntegerField(null=True,
verbose_name='Number of Frames')),
('fps',
models.FloatField(null=True,
verbose_name='Frame per Second')),
('blink_count',
models.IntegerField(help_text='Number of blinks in the video',
null=True,
verbose_name='Number of Blinks')),
('transcript',
models.TextField(
blank=True,
help_text='Transcript of the speach in the video',
max_length=10000,
null=True,
verbose_name='Video Transcript')),
('create_datetime',
models.DateTimeField(auto_now_add=True,
verbose_name='Creation Datetime')),
('file_id',
models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.SET_NULL,
to='dashboard.Files')),
],
options={
'ordering': ['-create_datetime'],
'permissions': (('can_view_any_metric', 'View Any Metric'),
('can_edit_any_metric', 'Edit Any Metric')),
},
),
]
class Migration(migrations.Migration):
dependencies = [
('dashboard', '0003_newsite_config'),
]
operations = [
migrations.AlterField(
model_name='newsitem',
name='author',
field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.PROTECT, related_name='author', to='coredata.Person'),
),
migrations.AlterField(
model_name='newsitem',
name='content',
field=models.TextField(help_text='Main story content'),
),
migrations.AlterField(
model_name='newsitem',
name='course',
field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.PROTECT, to='coredata.CourseOffering'),
),
migrations.AlterField(
model_name='newsitem',
name='read',
field=models.BooleanField(default=False, help_text='The user has marked the story read'),
),
migrations.AlterField(
model_name='newsitem',
name='source_app',
field=models.CharField(help_text='Application that created the story', max_length=20),
),
migrations.AlterField(
model_name='newsitem',
name='title',
field=models.CharField(help_text='Story title (plain text)', max_length=100),
),
migrations.AlterField(
model_name='newsitem',
name='url',
field=models.URLField(blank=True, help_text='absolute URL for the item: starts with "http://" or "/"', verbose_name='URL'),
),
migrations.AlterField(
model_name='newsitem',
name='user',
field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='user', to='coredata.Person'),
),
migrations.AlterField(
model_name='signature',
name='sig',
field=models.FileField(max_length=500, storage=django.core.files.storage.FileSystemStorage(base_url=None, location='submitted_files'), upload_to=dashboard.models._sig_upload_to),
),
migrations.AlterField(
model_name='signature',
name='user',
field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='coredata.Person'),
),
migrations.AlterField(
model_name='userconfig',
name='user',
field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='coredata.Person'),
),
migrations.AlterField(
model_name='userconfig',
name='value',
field=courselib.json_fields.JSONField(default=dict),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
]
operations = [
migrations.CreateModel(
name='phase_1',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('problem_images',
models.IntegerField(
blank=True,
help_text='Number of images of existing problems',
null=True)),
('problem_images_upload',
models.ImageField(
blank=True,
null=True,
upload_to=dashboard.models.phase_1.upload_path1)),
('FIR_number',
models.IntegerField(blank=True,
help_text='Number of FIRs to be uploaded',
null=True)),
('FIR_upload',
models.FileField(
blank=True,
null=True,
upload_to=dashboard.models.phase_1.upload_path2)),
('news_articles_number',
models.IntegerField(blank=True,
help_text='Number of News Articles',
null=True)),
('news_articles_upload',
models.FileField(
blank=True,
null=True,
upload_to=dashboard.models.phase_1.upload_path3)),
('miscellaneous_upload',
models.FileField(
blank=True,
null=True,
upload_to=dashboard.models.phase_1.upload_path4)),
('miscellaneous_detail',
models.CharField(
blank=True,
help_text='Description of the miscellaneous file uploaded',
max_length=200,
null=True)),
('team',
models.ForeignKey(blank=True,
null=True,
on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
],
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
('auth', '0009_alter_user_last_name_max_length'),
]
operations = [
migrations.CreateModel(
name='User',
fields=[
('password',
models.CharField(max_length=128, verbose_name='password')),
('last_login',
models.DateTimeField(blank=True,
null=True,
verbose_name='last login')),
('is_superuser',
models.BooleanField(
default=False,
help_text=
'Designates that this user has all permissions without explicitly assigning them.',
verbose_name='superuser status')),
('username',
models.CharField(
error_messages={
'unique': 'A user with that username already exists.'
},
help_text=
'Required. 150 characters or fewer. Letters, digits and @/./+/-/_ only.',
max_length=150,
unique=True,
validators=[
django.contrib.auth.validators.
UnicodeUsernameValidator()
],
verbose_name='username')),
('first_name',
models.CharField(blank=True,
max_length=30,
verbose_name='first name')),
('last_name',
models.CharField(blank=True,
max_length=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')),
('id',
models.UUIDField(default=uuid.uuid4,
editable=False,
primary_key=True,
serialize=False)),
('creation_date', models.DateTimeField(auto_now_add=True)),
('email', models.CharField(max_length=200, unique=True)),
('c_credentials', models.TextField()),
('salt', models.CharField(max_length=512)),
('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,
},
managers=[
('objects', dashboard.models.UserManager()),
],
),
migrations.CreateModel(
name='App',
fields=[
('id',
models.CharField(default=cloud.shortuuid.uuid,
editable=False,
max_length=255,
primary_key=True,
serialize=False)),
('creation_date', models.DateTimeField(auto_now_add=True)),
('name', models.CharField(max_length=255)),
('vendor', models.CharField(default='aws', max_length=255)),
('user',
models.ForeignKey(null=True,
on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
],
),
migrations.CreateModel(
name='Event',
fields=[
('id',
models.CharField(default=cloud.shortuuid.uuid,
editable=False,
max_length=255,
primary_key=True,
serialize=False)),
('creation_date', models.DateTimeField(auto_now_add=True)),
('description', models.CharField(editable=False,
max_length=255)),
('target', models.CharField(editable=False, max_length=255)),
('action', models.CharField(max_length=255)),
('amount', models.FloatField(default=0)),
],
),
migrations.CreateModel(
name='Log',
fields=[
('id',
models.CharField(default=cloud.shortuuid.uuid,
editable=False,
max_length=255,
primary_key=True,
serialize=False)),
('creation_date', models.DateTimeField(auto_now_add=True)),
('level', models.CharField(max_length=255)),
('event', models.TextField()),
('user',
models.ForeignKey(null=True,
on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
],
),
migrations.CreateModel(
name='MarketplaceLogic',
fields=[
('id',
models.CharField(default=cloud.shortuuid.uuid,
editable=False,
max_length=255,
primary_key=True,
serialize=False)),
('creation_date', models.DateTimeField(auto_now_add=True)),
('title', models.CharField(max_length=255)),
('category', models.CharField(max_length=255)),
('description', models.TextField()),
('content', models.TextField()),
('logo_image',
models.ImageField(null=True,
upload_to='marketplace_logic_logo_image')),
('function_zip_file',
models.FileField(null=True,
upload_to='marketplace_logic_function_zip')),
('function_name', models.CharField(max_length=255, null=True)),
('handler', models.CharField(max_length=255)),
('runtime', models.CharField(max_length=255)),
('verified', models.BooleanField(default=False)),
('view_count', models.BigIntegerField(default=0)),
('setup_count', models.BigIntegerField(default=0)),
('price', models.BigIntegerField(default=0)),
('user',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
],
),
migrations.CreateModel(
name='Tracker',
fields=[
('id',
models.CharField(default=cloud.shortuuid.uuid,
editable=False,
max_length=255,
primary_key=True,
serialize=False)),
('creation_date', models.DateTimeField(auto_now_add=True)),
('funnel', models.CharField(max_length=255, null=True)),
('user',
models.ForeignKey(blank=True,
null=True,
on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
],
),
migrations.AddField(
model_name='event',
name='tracker',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to='dashboard.Tracker'),
),
migrations.AddField(
model_name='event',
name='user',
field=models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL),
),
]