class Migration(migrations.Migration):
dependencies = [
('dashboard', '0012_auto_20190425_0225'),
]
operations = [
migrations.CreateModel(
name='Feedback',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('o_id', models.IntegerField(verbose_name='ID объекта')),
('o_url',
models.CharField(blank=True,
max_length=200,
null=True,
verbose_name='Путь к объекту')),
('name',
models.CharField(blank=True,
max_length=100,
null=True,
verbose_name='Имя')),
('email',
models.CharField(blank=True,
max_length=100,
null=True,
verbose_name='Email')),
('text',
models.TextField(blank=True,
null=True,
verbose_name='Сообщение')),
],
),
migrations.CreateModel(
name='FeedbackImage',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('image',
models.ImageField(max_length=500,
upload_to=dashboard.models.photo_path_2)),
('feedback',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='images',
to='dashboard.Feedback')),
],
options={
'verbose_name': 'Загруженная фотография',
'verbose_name_plural': 'Загруженные фотографии',
},
),
]
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):
initial = True
dependencies = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
]
operations = [
migrations.CreateModel(
name='DecisionTree',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('created_at', models.DateTimeField(auto_now_add=True)),
('name', models.CharField(max_length=200)),
('slug', models.SlugField(default='')),
('owner', models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)),
],
),
migrations.CreateModel(
name='Node',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('created_at', models.DateTimeField(auto_now_add=True)),
('name', models.CharField(max_length=240)),
('slug', models.SlugField(default='')),
('question', dashboard.models.RichTextBleachField()),
('input_type', models.CharField(max_length=240)),
('data_answer', models.TextField(blank=True, null=True)),
('data_logic', models.TextField(blank=True, null=True)),
('new_node', models.BooleanField()),
('start_node', models.BooleanField()),
('end_node', models.BooleanField()),
('decision_tree', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='dashboard.DecisionTree')),
],
),
migrations.AddConstraint(
model_name='node',
constraint=models.UniqueConstraint(fields=('slug', 'decision_tree'), name='unique nodeslug per tree'),
),
migrations.AddConstraint(
model_name='decisiontree',
constraint=models.UniqueConstraint(fields=('owner', 'slug'), name='unique tree slug per user'),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
]
operations = [
migrations.CreateModel(
name='AnnouncementPost',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('title', models.CharField(max_length=220)),
('body', models.TextField(max_length=60000)),
('featured_image',
models.ImageField(
blank=True,
null=True,
upload_to=dashboard.models.upload_location)),
('extra_image_one',
models.ImageField(
blank=True,
null=True,
upload_to=dashboard.models.upload_location)),
('extra_image_two',
models.ImageField(
blank=True,
null=True,
upload_to=dashboard.models.upload_location)),
('extra_image_three',
models.ImageField(
blank=True,
null=True,
upload_to=dashboard.models.upload_location)),
('date_published',
models.DateTimeField(auto_now_add=True,
verbose_name='date published')),
('date_updated',
models.DateTimeField(auto_now=True,
verbose_name='date updated')),
('is_approved', models.BooleanField(default=True)),
('slug', models.SlugField(blank=True, unique=True)),
('author',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
('viewed_by',
models.ManyToManyField(
related_name='announcement_post_viewed_by',
to=settings.AUTH_USER_MODEL)),
],
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
]
operations = [
migrations.CreateModel(
name='NewQuiz',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('thumbnail', models.ImageField(blank=True, null=True, upload_to=dashboard.models.image_location)),
('title', models.CharField(blank=True, default=None, max_length=300, null=True)),
('url', models.CharField(blank=True, default=None, max_length=300, null=True)),
('user', 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 = [
('users', '0001_initial'),
]
operations = [
migrations.CreateModel(
name='Drugs',
fields=[
('drug_id', models.AutoField(primary_key=True, serialize=False)),
('drug_name', models.CharField(max_length=1000)),
('nct_no', models.CharField(max_length=50, unique=True)),
('drug_image_path', models.ImageField(upload_to=dashboard.models.saveimage)),
('min_age', models.IntegerField()),
('max_age', models.IntegerField()),
('other_medications', models.CharField(max_length=2000)),
('comorbid_conditions', models.CharField(max_length=2000)),
('blood_pressure_req', models.IntegerField()),
('posology', models.CharField(max_length=200)),
('efficacy', models.DecimalField(decimal_places=2, max_digits=5)),
('drug_category', models.CharField(max_length=200)),
('upload_date', models.DateTimeField(auto_now_add=True)),
('user', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='users.account')),
],
options={
'db_table': 'drugs',
},
),
]
class Migration(migrations.Migration):
dependencies = [
('dashboard', '0002_auto_20200325_1537'),
]
operations = [
migrations.AlterField(
model_name='apitoken',
name='token',
field=models.CharField(default=dashboard.models.generate_token,
max_length=64),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
]
operations = [
migrations.CreateModel(
name='Referral',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('first_name', models.CharField(max_length=100)),
('last_name', models.CharField(max_length=100)),
('email', models.EmailField(max_length=150)),
('phone_number', models.CharField(max_length=30)),
('alternative_phone_number1', models.CharField(blank=True, max_length=30, null=True)),
('alternative_phone_number2', models.CharField(blank=True, max_length=30, null=True)),
('referred_by', models.ForeignKey(blank=True, null=True, on_delete=models.SET(dashboard.models.get_sentinel_user), related_name='referrals', to=settings.AUTH_USER_MODEL)),
],
),
]
class Migration(migrations.Migration):
dependencies = [
('dashboard', '0004_auto_20190618_1113'),
]
operations = [
migrations.CreateModel(
name='CacheBuildDetails',
fields=[
('cache_build_details_id', models.AutoField(primary_key=True, serialize=False)),
('build_system', models.CharField(max_length=200, verbose_name='Build System')),
('build_tag', models.CharField(max_length=200, verbose_name='Build Tag')),
('build_details_json_str', models.TextField(blank=True, null=True)),
('job_log_json_str', models.TextField(blank=True, null=True)),
('package_name', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='dashboard.Package', to_field='package_name', verbose_name='Package')),
],
options={
'db_table': 'ts_cachebuilddetails',
},
bases=(dashboard.models.ModelMixin, models.Model),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = []
operations = [
migrations.CreateModel(
name='Notification',
fields=[
('notify_id',
models.CharField(default=dashboard.models.gen_uuid,
max_length=36,
primary_key=True,
serialize=False,
unique=True)),
('notify_type', models.CharField(max_length=20)),
('date_added',
models.DateTimeField(auto_now_add=True, null=True)),
('notify_text', models.CharField(max_length=75)),
],
),
]
class Migration(migrations.Migration):
initial = True
dependencies = []
operations = [
migrations.CreateModel(
name='Medicion',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('fecha_hora', models.DateTimeField()),
('energia_activa', models.IntegerField()),
('energia_aparente', models.IntegerField()),
('demanda', models.FloatField()),
],
),
migrations.CreateModel(
name='Nodo',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('nombre', models.CharField(max_length=20)),
('descripcion', models.TextField()),
('fotografia',
models.ImageField(
upload_to=dashboard.models.get_imagen_nodo_dir)),
('padre',
models.ForeignKey(blank=True,
null=True,
on_delete=django.db.models.deletion.CASCADE,
to='dashboard.Nodo')),
],
),
migrations.AddField(
model_name='medicion',
name='nodo',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to='dashboard.Nodo'),
),
]
class Migration(migrations.Migration):
dependencies = [
('dashboard', '0052_auto_20210916_2115'),
]
operations = [
migrations.AlterField(
model_name='achievement',
name='code',
field=models.CharField(max_length=96, null=True, unique=True, validators=[django.core.validators.RegexValidator(message='24-char hex string', regex='[a-f0-9]{24}')]),
),
migrations.AlterField(
model_name='achievement',
name='description',
field=models.TextField(help_text='Text shown beneath this achievement for students who obtain it.'),
),
migrations.AlterField(
model_name='achievement',
name='diamonds',
field=models.SmallIntegerField(default=1, help_text='Number of diamonds for this achievement'),
),
migrations.AlterField(
model_name='achievement',
name='image',
field=models.ImageField(blank=True, help_text='Image for the obtained achievement, at most 1MB.', null=True, upload_to=dashboard.models.achievement_image_file_name, validators=[dashboard.models.validate_at_most_1mb]),
),
migrations.AlterField(
model_name='palaceentry',
name='image',
field=models.ImageField(blank=True, help_text='Optional small photo that will appear next to your entry, no more than 1 megabyte', null=True, upload_to=dashboard.models.palace_image_file_name, validators=[dashboard.models.validate_at_most_1mb]),
),
migrations.AlterField(
model_name='palaceentry',
name='message',
field=models.TextField(blank=True, help_text='You can write a message here', max_length=1024),
),
]
class Migration(migrations.Migration):
dependencies = [
('dashboard', '0011_auto_20200528_2010'),
]
operations = [
migrations.AlterField(
model_name='address',
name='street',
field=models.CharField(default='38 Windsor', max_length=150),
),
migrations.AlterField(
model_name='home',
name='address',
field=models.ForeignKey(
default=dashboard.models.Address(),
on_delete=django.db.models.deletion.CASCADE,
to='dashboard.Address'),
),
migrations.AlterField(
model_name='manufacturer',
name='address',
field=models.ForeignKey(
on_delete=django.db.models.deletion.DO_NOTHING,
to='dashboard.Address'),
),
migrations.AlterField(
model_name='things',
name='mfg',
field=models.ForeignKey(
null=True,
on_delete=django.db.models.deletion.DO_NOTHING,
to='dashboard.Manufacturer'),
),
]
class Migration(migrations.Migration):
dependencies = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
('dashboard', '0001_initial'),
]
operations = [
migrations.AlterField(
model_name='asset',
name='purchase_date',
field=models.DateField(blank=True, null=True, validators=[dashboard.models.validate_purchase_date]),
),
migrations.CreateModel(
name='Task',
fields=[
('ref_code', models.CharField(max_length=100, primary_key=True, serialize=False, unique=True)),
('action', models.TextField()),
('completed', models.BooleanField(default=False)),
('deadline', models.DateTimeField(validators=[dashboard.models.validate_deadline])),
('user', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)),
],
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
('sites', '0002_alter_domain_unique'),
('auth', '0008_alter_user_username_max_length'),
('contenttypes', '0002_remove_content_type_name'),
]
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')),
('email',
models.EmailField(max_length=255,
unique=True,
verbose_name='Email Address')),
('first_name',
models.CharField(blank=True,
max_length=50,
verbose_name='First Name')),
('last_name',
models.CharField(blank=True,
max_length=50,
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')),
('created_by',
models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.SET_NULL,
to=settings.AUTH_USER_MODEL)),
('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_plural': 'users',
'db_table': 'user',
'verbose_name': 'user',
},
managers=[
('objects', dashboard.models.UserManager()),
],
),
migrations.CreateModel(
name='Page',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('page_name',
models.CharField(choices=[('index', 'Home'),
('privacy', 'Privacy'),
('terms', 'Terms')],
max_length=100)),
('page_nav_name',
models.CharField(blank=True, max_length=500, null=True)),
('page_type',
models.CharField(choices=[('landing_page',
'Static Landing Page')],
default='landing_page',
max_length=100)),
('title', models.TextField(blank=True, null=True)),
('sub_title', models.TextField(blank=True, null=True)),
('meta_description', models.TextField(blank=True, null=True)),
('meta_keywords', models.TextField(blank=True, null=True)),
('published', models.BooleanField(default=True)),
('date_published', models.DateTimeField(blank=True,
null=True)),
('created', models.DateTimeField(auto_now_add=True)),
('date_edited', models.DateTimeField(auto_now=True)),
],
options={
'ordering': ['site_info__site__id', 'page_name'],
},
),
migrations.CreateModel(
name='PageItem',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('object_id', models.PositiveIntegerField()),
('configuration', models.TextField(blank=True, null=True)),
('created', models.DateTimeField(auto_now_add=True)),
('date_edited', models.DateTimeField(auto_now=True)),
('content_type',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='contenttypes.ContentType')),
('page',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='dashboard.Page')),
],
),
migrations.CreateModel(
name='SiteFormDataModel',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('domain_name', models.CharField(max_length=150)),
('zipcode', models.CharField(db_index=True, max_length=5)),
('DOB', models.DateField(verbose_name='Date of Birth')),
('gender',
models.CharField(choices=[('male', 'male'),
('female', 'female')],
max_length=50)),
('type',
models.CharField(choices=[('Self', 'Self'),
('Family', 'Family')],
max_length=50)),
('house_income',
models.DecimalField(decimal_places=2, max_digits=20)),
('phone', models.TextField()),
('firstname',
models.CharField(max_length=500, verbose_name='First Name')),
('lastname',
models.CharField(max_length=500, verbose_name='Last Name')),
('email', models.EmailField(db_index=True, max_length=254)),
('CSD', models.DateField(verbose_name='Coverage Start Date')),
('created', models.DateTimeField(auto_now_add=True)),
],
),
migrations.CreateModel(
name='SiteInfo',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('site_title', models.TextField(blank=True, null=True)),
('title_separator',
models.CharField(choices=[('|', '|'), ('-', '-')],
default='|',
max_length=10)),
('phone_number',
models.CharField(blank=True, max_length=20, null=True)),
('email_id',
models.EmailField(blank=True, max_length=254, null=True)),
('main_heading', models.TextField(blank=True, null=True)),
('main_heading_sub', models.TextField(blank=True, null=True)),
('created', models.DateTimeField(auto_now_add=True)),
('date_edited', models.DateTimeField(auto_now=True)),
('published', models.BooleanField(default=True)),
('site',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='sites.Site',
unique=True)),
],
options={
'ordering': ['site__id'],
'verbose_name': 'Site Info',
},
),
migrations.AddField(
model_name='page',
name='site_info',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to='dashboard.SiteInfo'),
),
migrations.AlterUniqueTogether(
name='pageitem',
unique_together=set([('page', 'object_id')]),
),
migrations.AlterUniqueTogether(
name='page',
unique_together=set([('site_info', 'page_name')]),
),
]
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 = [
('account', '0001_initial'),
]
operations = [
migrations.CreateModel(
name='BannerImage',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('title', models.CharField(max_length=200)),
('image', models.ImageField(upload_to='gallery/banner')),
('description', models.CharField(max_length=30)),
],
),
migrations.CreateModel(
name='ContributionList',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('title', models.CharField(max_length=100)),
('date', models.DateField()),
],
),
migrations.CreateModel(
name='EventGallary',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('title', models.CharField(max_length=200)),
('date', models.DateField()),
],
),
migrations.CreateModel(
name='EventType',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('title',
models.CharField(max_length=100,
verbose_name='Event type name')),
],
),
migrations.CreateModel(
name='ExpenseList',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('title', models.CharField(max_length=100)),
('date', models.DateField()),
],
),
migrations.CreateModel(
name='ExpenseType',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('title',
models.CharField(max_length=100,
verbose_name='Expense type name')),
],
),
migrations.CreateModel(
name='UsefulLink',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('title', models.CharField(max_length=200)),
('link', models.CharField(max_length=500)),
],
),
migrations.CreateModel(
name='MonthlyExpense',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('date', models.DateField(blank=True, null=True)),
('ExpenseAmount',
models.IntegerField(default=100,
verbose_name='Expense Amount')),
('EventCategory',
models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.SET_NULL,
to='dashboard.EventType')),
('ExpenseCategory',
models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.SET_NULL,
to='dashboard.ExpenseType')),
('ExpenseTitle',
models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.SET_NULL,
to='dashboard.ExpenseList')),
('whos',
models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.SET_NULL,
to='account.TeamMember')),
],
),
migrations.CreateModel(
name='MonthlyContribution',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('date', models.DateField(blank=True, null=True)),
('amount', models.IntegerField(default=100)),
('paid', models.BooleanField()),
('contri_title',
models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.SET_NULL,
to='dashboard.ContributionList')),
('user',
models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.SET_NULL,
to='account.TeamMember')),
],
),
migrations.CreateModel(
name='GallaryUploadImage',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('image',
models.ImageField(
upload_to=dashboard.models.image_directory_path)),
('title',
models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.SET_NULL,
to='dashboard.EventGallary')),
],
),
migrations.AddField(
model_name='eventgallary',
name='event',
field=models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.SET_NULL,
to='dashboard.EventType'),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = []
operations = [
migrations.CreateModel(
name='Camera',
fields=[
('camera_no',
models.IntegerField(primary_key=True, serialize=False)),
('camera_name',
models.CharField(blank=True, max_length=100, null=True)),
],
),
migrations.CreateModel(
name='Customer',
fields=[
('customer_no',
models.IntegerField(primary_key=True, serialize=False)),
('customer_name', models.CharField(max_length=100)),
('customer_gender',
models.CharField(blank=True,
choices=[('Male', 'Male'),
('Female', 'Female')],
max_length=10,
null=True)),
('customer_age',
models.IntegerField(
blank=True,
null=True,
validators=[
django.core.validators.MaxValueValidator(100),
django.core.validators.MinValueValidator(1)
])),
('customer_market_in', models.BooleanField(default=False)),
('customer_ratings',
djongo.models.fields.EmbeddedModelField(
model_container=dashboard.models.ratings, null=True)),
],
),
migrations.CreateModel(
name='Product',
fields=[
('product_no',
models.IntegerField(primary_key=True, serialize=False)),
('product_class',
models.CharField(blank=True, max_length=100, null=True)),
('product_name', models.CharField(max_length=100)),
],
),
migrations.CreateModel(
name='Realtime',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('realtime_product', models.CharField(max_length=128)),
('realtime_category', models.CharField(max_length=128)),
('realtime_site', models.CharField(max_length=128)),
('realtime_ranking', models.IntegerField(default=10)),
('realtime_date',
models.DateTimeField(default=django.utils.timezone.now)),
('realtime_value', models.IntegerField(default=0)),
],
),
migrations.CreateModel(
name='CameraLog',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('datetime_now', models.DateTimeField(auto_now=True)),
('camera',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='dashboard.Camera')),
('customer',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='dashboard.Customer')),
],
),
migrations.AddField(
model_name='camera',
name='product',
field=models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.CASCADE,
to='dashboard.Product'),
),
]
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):
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', '0002_auto_20180912_2244'),
]
operations = [
migrations.AlterModelOptions(
name='locality',
options={'verbose_name': 'Населенный пункт', 'verbose_name_plural': 'Населенные пункты'},
),
migrations.AlterModelOptions(
name='municipality',
options={'verbose_name': 'Муниципальное образование', 'verbose_name_plural': 'Муниципальные образования'},
),
migrations.AlterModelOptions(
name='objectinfo',
options={'verbose_name': 'Объект', 'verbose_name_plural': 'Объекты'},
),
migrations.AlterModelOptions(
name='species',
options={'verbose_name': 'Видовая принадлежность', 'verbose_name_plural': 'Видовые принадлежности'},
),
migrations.RemoveField(
model_name='objectinfo',
name='id_openData',
),
migrations.AddField(
model_name='objectinfo',
name='_id',
field=models.CharField(blank=True, max_length=200, null=True, verbose_name='ID opendata.mkrf.ru'),
),
migrations.AddField(
model_name='objectinfo',
name='slug',
field=models.SlugField(blank=True, max_length=400, null=True, verbose_name='slugURL'),
),
migrations.AlterField(
model_name='objectinfo',
name='OKN_in_ensemble',
field=models.CharField(blank=True, choices=[('Yes', 'Да'), ('No', 'Нет')], max_length=10, null=True, verbose_name='ОКН входит в ансамбль (да/нет)'),
),
migrations.AlterField(
model_name='objectinfo',
name='actual_address',
field=models.TextField(blank=True, null=True, verbose_name='Актуальный адрес'),
),
migrations.AlterField(
model_name='objectinfo',
name='affiliation_U',
field=models.CharField(blank=True, choices=[('Yes', 'Да'), ('No', 'Нет')], max_length=10, null=True, verbose_name='Принадлежность к ЮНЭСКО'),
),
migrations.AlterField(
model_name='objectinfo',
name='date',
field=models.DateField(blank=True, null=True, verbose_name='Дата'),
),
migrations.AlterField(
model_name='objectinfo',
name='description',
field=models.TextField(blank=True, null=True, verbose_name='Описание'),
),
migrations.AlterField(
model_name='objectinfo',
name='document_on_approved_security',
field=models.TextField(blank=True, null=True, verbose_name='Документ об утвержденых зонах охраны'),
),
migrations.AlterField(
model_name='objectinfo',
name='esp_valuable_object',
field=models.CharField(blank=True, choices=[('Yes', 'Да'), ('No', 'Нет')], max_length=10, null=True, verbose_name='Особо ценный объект'),
),
migrations.AlterField(
model_name='objectinfo',
name='fullAddress',
field=models.TextField(blank=True, null=True, verbose_name='Полный адрес'),
),
migrations.AlterField(
model_name='objectinfo',
name='gen_species_appearance',
field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to='dashboard.Species', verbose_name='Общая видовая принадлежность'),
),
migrations.AlterField(
model_name='objectinfo',
name='has_docs_boundaries',
field=models.CharField(blank=True, choices=[('Yes', 'Да'), ('No', 'Нет')], max_length=10, null=True, verbose_name='Наличие документов о границах территории ОКН'),
),
migrations.AlterField(
model_name='objectinfo',
name='has_docs_of_aprroval',
field=models.CharField(blank=True, choices=[('Yes', 'Да'), ('No', 'Нет')], max_length=10, null=True, verbose_name='Наличие документов об утвержденых зонах охраны'),
),
migrations.AlterField(
model_name='objectinfo',
name='has_passport_OKN',
field=models.CharField(blank=True, choices=[('Yes', 'Да'), ('No', 'Нет'), ('In_work', 'На подготовке')], max_length=5, null=True, verbose_name='Наличие паспорта ОКН'),
),
migrations.AlterField(
model_name='objectinfo',
name='has_rights',
field=models.CharField(blank=True, choices=[('Yes', 'Да'), ('No', 'Нет')], max_length=10, null=True, verbose_name='Наличие зарегистрированных прав/обременений'),
),
migrations.AlterField(
model_name='objectinfo',
name='has_security_obligation',
field=models.CharField(blank=True, choices=[('Yes', 'Да'), ('No', 'Нет'), ('In_work', 'На подготовке')], max_length=5, null=True, verbose_name='Наличие охранного обязательства ОКН'),
),
migrations.AlterField(
model_name='objectinfo',
name='information_sign',
field=models.CharField(blank=True, choices=[('Yes', 'Да'), ('No', 'Нет'), ('In_work', 'На подготовке')], max_length=5, null=True, verbose_name='Наличие уcтановленной информационной надписи установленного образца'),
),
migrations.AlterField(
model_name='objectinfo',
name='information_sign_conformity',
field=models.CharField(blank=True, choices=[('Yes', 'Да'), ('No', 'Нет')], max_length=10, null=True, verbose_name='Наличие информационной надписи, но не соответствующей требованиям'),
),
migrations.AlterField(
model_name='objectinfo',
name='information_sign_photo',
field=models.ImageField(blank=True, null=True, upload_to=dashboard.models.image_folder, verbose_name='Фотография информационной надписи'),
),
migrations.AlterField(
model_name='objectinfo',
name='locality',
field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to='dashboard.Locality', verbose_name='Населенный пункт'),
),
migrations.AlterField(
model_name='objectinfo',
name='management',
field=models.CharField(blank=True, max_length=200, null=True, verbose_name='Под чьим управлением'),
),
migrations.AlterField(
model_name='objectinfo',
name='municipality',
field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to='dashboard.Municipality', verbose_name='Муниципальное образование'),
),
migrations.AlterField(
model_name='objectinfo',
name='nativeName',
field=models.CharField(blank=True, max_length=200, null=True, verbose_name='Наименование'),
),
migrations.AlterField(
model_name='objectinfo',
name='owner',
field=models.CharField(blank=True, max_length=200, null=True, verbose_name='Собственник'),
),
migrations.AlterField(
model_name='objectinfo',
name='owner_contacts',
field=models.TextField(blank=True, null=True, verbose_name='Контактные данные собственника ОКН'),
),
migrations.AlterField(
model_name='objectinfo',
name='photo',
field=models.ImageField(blank=True, null=True, upload_to=dashboard.models.image_folder, verbose_name='Фото'),
),
migrations.AlterField(
model_name='objectinfo',
name='req_of_approval',
field=models.TextField(blank=True, null=True, verbose_name='Реквизиты об утверждении границ территории'),
),
migrations.AlterField(
model_name='objectinfo',
name='requisites_and_title',
field=models.TextField(blank=True, null=True, verbose_name=' Реквизиты и наименование акта органа государственной власти о постановке на государственную охрану объекта культурного наследия'),
),
migrations.AlterField(
model_name='objectinfo',
name='url',
field=models.CharField(blank=True, max_length=200, null=True, verbose_name='URL адрес'),
),
]
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 = [
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 = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
]
operations = [
migrations.CreateModel(
name='_DiseaseModel',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=255, unique=True)),
],
),
migrations.CreateModel(
name='Answer',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('answer', models.CharField(max_length=255)),
],
),
migrations.CreateModel(
name='Question',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('question', models.CharField(max_length=255, unique=True)),
],
),
migrations.CreateModel(
name='UserResponse',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('user',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='responses',
to=settings.AUTH_USER_MODEL)),
],
),
migrations.AddField(
model_name='answer',
name='question',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
related_name='answers',
to='dashboard.Question'),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
('contenttypes', '0002_remove_content_type_name'),
('auth', '0009_alter_user_last_name_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.
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')),
('email',
models.EmailField(max_length=254,
unique=True,
verbose_name='Email')),
('phone_number',
models.CharField(
blank=True,
help_text=
'User Phone Number, example: 09123456790 (Optional)',
max_length=11,
null=True,
unique=True,
validators=[dashboard.models.phone_number_validator],
verbose_name='Phone Number')),
('is_premium',
models.BooleanField(default=False, verbose_name='Premium')),
('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', django.contrib.auth.models.UserManager()),
],
),
migrations.CreateModel(
name='Action',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('type',
models.CharField(choices=[('link created', 'Link Created'),
('link updated', 'Link Updated'),
('link reported', 'Link Reported'),
('contact_us', 'Contact Us')],
max_length=20,
verbose_name='Type of Action')),
('is_read', models.BooleanField(default=False)),
('created', models.DateTimeField(auto_now_add=True)),
('updated', models.DateTimeField(auto_now=True)),
('object_id',
models.PositiveIntegerField(db_index=True,
verbose_name='object id')),
('content_type',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='contenttypes.ContentType',
verbose_name='content type')),
],
options={
'ordering': ('-updated', ),
},
),
]
class Migration(migrations.Migration):
initial = True
dependencies = []
operations = [
migrations.CreateModel(
name='CacheAPI',
fields=[
('cache_api_id',
models.AutoField(primary_key=True, serialize=False)),
('base_url', models.URLField(max_length=800)),
('resource', models.CharField(max_length=200)),
('request_args',
django.contrib.postgres.fields.ArrayField(
base_field=models.CharField(blank=True, max_length=400),
default=list,
size=None)),
('request_kwargs', models.CharField(max_length=1000)),
('response_content', models.TextField(max_length=10000)),
('response_content_json_str',
models.TextField(blank=True, null=True)),
('expiry', models.DateTimeField()),
],
options={
'db_table': 'ts_cacheapi',
},
bases=(dashboard.models.ModelMixin, models.Model),
),
migrations.CreateModel(
name='GraphRule',
fields=[
('graph_rule_id',
models.AutoField(primary_key=True, serialize=False)),
('rule_name', models.CharField(max_length=1000, unique=True)),
('rule_packages',
django.contrib.postgres.fields.ArrayField(
base_field=models.CharField(blank=True, max_length=1000),
default=list,
size=None)),
('rule_languages',
django.contrib.postgres.fields.ArrayField(
base_field=models.CharField(blank=True, max_length=400),
default=list,
size=None)),
('created_on', models.DateTimeField()),
('rule_status', models.BooleanField(default=True)),
('rule_visibility_public', models.BooleanField(default=False)),
('created_by', models.EmailField(max_length=254, null=True)),
],
options={
'verbose_name': 'Graph Rule',
'db_table': 'ts_graphrules',
},
),
migrations.CreateModel(
name='Job',
fields=[
('job_id', models.AutoField(primary_key=True,
serialize=False)),
('job_uuid',
models.UUIDField(default=uuid.uuid4, editable=False)),
('job_type', models.CharField(max_length=200)),
('job_start_time', models.DateTimeField()),
('job_end_time', models.DateTimeField(null=True)),
('job_yml_text',
models.CharField(blank=True, max_length=2000, null=True)),
('job_log_json_str', models.TextField(blank=True, null=True)),
('job_result', models.NullBooleanField()),
('job_remarks', models.CharField(max_length=200, null=True)),
('job_params_json_str', models.TextField(blank=True,
null=True)),
('job_output_json_str', models.TextField(blank=True,
null=True)),
('triggered_by', models.EmailField(max_length=254, null=True)),
('job_visible_on_url', models.BooleanField(default=False)),
],
options={
'verbose_name': 'Job',
'db_table': 'ts_jobs',
},
bases=(dashboard.models.ModelMixin, models.Model),
),
migrations.CreateModel(
name='JobTemplate',
fields=[
('job_template_id',
models.AutoField(primary_key=True, serialize=False)),
('job_template_type',
models.CharField(max_length=100, unique=True)),
('job_template_name', models.CharField(max_length=500)),
('job_template_desc',
models.CharField(blank=True, max_length=1000, null=True)),
('job_template_params',
django.contrib.postgres.fields.ArrayField(
base_field=models.CharField(blank=True, max_length=1000),
default=list,
size=None)),
('job_template_json_str',
models.TextField(blank=True, null=True)),
('job_template_last_accessed',
models.DateTimeField(null=True)),
],
options={
'verbose_name': 'Job Template',
'db_table': 'ts_jobtemplates',
},
bases=(dashboard.models.ModelMixin, models.Model),
),
migrations.CreateModel(
name='Language',
fields=[
('locale_id',
models.CharField(max_length=50,
primary_key=True,
serialize=False,
verbose_name='Locale ID')),
('lang_name',
models.CharField(max_length=400,
unique=True,
verbose_name='Language Name')),
('locale_alias',
models.CharField(blank=True,
max_length=50,
null=True,
unique=True,
verbose_name='Locale Alias')),
('locale_script',
models.CharField(blank=True,
max_length=100,
null=True,
verbose_name='Locale Script')),
('lang_status',
models.BooleanField(verbose_name='Enable/Disable')),
],
options={
'verbose_name': 'Language',
'db_table': 'ts_languages',
},
),
migrations.CreateModel(
name='LanguageSet',
fields=[
('lang_set_id',
models.AutoField(primary_key=True, serialize=False)),
('lang_set_name',
models.CharField(max_length=1000,
verbose_name='Language Set Name')),
('lang_set_slug',
models.CharField(max_length=400,
unique=True,
verbose_name='Language Set SLUG')),
('lang_set_color',
models.CharField(max_length=100,
unique=True,
verbose_name='Tag Colour')),
('locale_ids',
django.contrib.postgres.fields.ArrayField(
base_field=models.CharField(blank=True, max_length=50),
default=list,
null=True,
size=None,
verbose_name='Locale IDs')),
],
options={
'verbose_name': 'Language Set',
'db_table': 'ts_langset',
},
),
migrations.CreateModel(
name='Package',
fields=[
('package_id',
models.AutoField(primary_key=True, serialize=False)),
('package_name',
models.CharField(max_length=1000,
unique=True,
verbose_name='Package Name')),
('upstream_name',
models.CharField(blank=True,
max_length=1000,
null=True,
verbose_name='Upstream Name')),
('component',
models.CharField(blank=True,
max_length=200,
null=True,
verbose_name='Component')),
('upstream_url',
models.URLField(max_length=2000,
unique=True,
verbose_name='Upstream URL')),
('platform_name',
models.CharField(
blank=True,
max_length=1000,
null=True,
verbose_name='Package Name at Translation Platform')),
('platform_url',
models.URLField(
blank=True,
max_length=500,
null=True,
verbose_name='Translation Platform Project URL')),
('products',
django.contrib.postgres.fields.ArrayField(
base_field=models.CharField(blank=True, max_length=400),
default=list,
null=True,
size=None,
verbose_name='Release Streams')),
('package_details_json_str',
models.TextField(blank=True, null=True)),
('details_json_last_updated', models.DateTimeField(null=True)),
('package_name_mapping_json_str',
models.TextField(blank=True, null=True)),
('name_map_last_updated',
models.DateTimeField(blank=True, null=True)),
('release_branch_mapping',
models.TextField(blank=True, null=True)),
('release_branch_map_last_updated',
models.DateTimeField(blank=True, null=True)),
('stats_diff', models.TextField(blank=True, null=True)),
('stats_diff_last_updated',
models.DateTimeField(blank=True, null=True)),
('platform_last_updated',
models.DateTimeField(blank=True, null=True)),
('upstream_last_updated',
models.DateTimeField(blank=True, null=True)),
('downstream_last_updated',
models.DateTimeField(blank=True, null=True)),
('translation_file_ext',
models.CharField(blank=True,
default='po',
max_length=10,
null=True,
verbose_name='Translation Format (po)')),
('created_by', models.EmailField(max_length=254, null=True)),
('maintainers', models.TextField(blank=True, null=True)),
],
options={
'verbose_name': 'Package',
'db_table': 'ts_packages',
},
bases=(dashboard.models.ModelMixin, models.Model),
),
migrations.CreateModel(
name='PackageSet',
fields=[
('package_set_id',
models.AutoField(primary_key=True, serialize=False)),
('package_set_name',
models.CharField(max_length=1000,
verbose_name='Package Set Name')),
('package_set_slug',
models.CharField(max_length=400,
unique=True,
verbose_name='Package Set SLUG')),
('package_set_color',
models.CharField(max_length=100,
unique=True,
verbose_name='Tag Colour')),
('packages',
models.TextField(blank=True,
null=True,
verbose_name='Packages')),
],
options={
'verbose_name': 'Package Set',
'db_table': 'ts_packageset',
},
),
migrations.CreateModel(
name='Platform',
fields=[
('platform_id',
models.AutoField(primary_key=True, serialize=False)),
('engine_name',
models.CharField(max_length=200,
verbose_name='Platform Engine')),
('subject',
models.CharField(max_length=200,
null=True,
verbose_name='Platform Subject')),
('api_url',
models.URLField(max_length=500,
unique=True,
verbose_name='Server URL')),
('platform_slug',
models.CharField(max_length=400,
unique=True,
verbose_name='Platform SLUG')),
('server_status',
models.BooleanField(verbose_name='Enable/Disable')),
('projects_json_str', models.TextField(blank=True, null=True)),
('projects_last_updated', models.DateTimeField(null=True)),
('auth_login_id',
models.CharField(blank=True,
max_length=200,
null=True,
verbose_name='Auth User')),
('auth_token_key',
models.CharField(blank=True,
max_length=200,
null=True,
verbose_name='Auth Token')),
],
options={
'verbose_name': 'Translation Platform',
'db_table': 'ts_platforms',
},
bases=(dashboard.models.ModelMixin, models.Model),
),
migrations.CreateModel(
name='Product',
fields=[
('product_id',
models.AutoField(primary_key=True, serialize=False)),
('product_name',
models.CharField(max_length=200,
verbose_name='Product Name')),
('product_slug',
models.CharField(max_length=400,
unique=True,
verbose_name='Product SLUG')),
('product_server',
models.URLField(max_length=500,
unique=True,
verbose_name='Product Server')),
('product_build_system',
models.CharField(max_length=200,
null=True,
verbose_name='Release Build System')),
('product_build_tags',
django.contrib.postgres.fields.ArrayField(
base_field=models.CharField(blank=True, max_length=200),
default=list,
null=True,
size=None,
verbose_name='Release Build Tags')),
('product_build_tags_last_updated',
models.DateTimeField(null=True)),
('src_pkg_format',
models.CharField(max_length=50,
null=True,
verbose_name='Source Package Format')),
('top_url',
models.URLField(max_length=500,
unique=True,
verbose_name='Top URL')),
('web_url',
models.URLField(max_length=500,
null=True,
unique=True,
verbose_name='Web URL')),
('krb_service',
models.CharField(blank=True,
max_length=200,
null=True,
verbose_name='Kerberos Service')),
('auth_type',
models.CharField(blank=True,
max_length=200,
null=True,
verbose_name='Auth Type')),
('amqp_server',
models.CharField(blank=True,
max_length=500,
null=True,
verbose_name='AMQP Server')),
('msgbus_exchange',
models.CharField(blank=True,
max_length=200,
null=True,
verbose_name='Message Bus Exchange')),
('major_milestones',
django.contrib.postgres.fields.ArrayField(
base_field=models.CharField(blank=True, max_length=1000),
default=list,
null=True,
size=None,
verbose_name='Major Milestones')),
('product_phases',
django.contrib.postgres.fields.ArrayField(
base_field=models.CharField(blank=True, max_length=200),
default=list,
null=True,
size=None,
verbose_name='Release Stream Phases')),
('product_status',
models.BooleanField(verbose_name='Enable/Disable')),
],
options={
'verbose_name': 'Product',
'db_table': 'ts_products',
},
),
migrations.CreateModel(
name='Release',
fields=[
('release_id',
models.AutoField(primary_key=True, serialize=False)),
('release_name',
models.CharField(max_length=500,
verbose_name='Release Name')),
('release_slug',
models.CharField(max_length=500,
unique=True,
verbose_name='Release SLUG')),
('scm_branch',
models.CharField(blank=True,
max_length=100,
null=True,
verbose_name='SCM Branch Name')),
('created_on', models.DateTimeField()),
('current_phase',
models.CharField(max_length=200,
null=True,
verbose_name='Current Phase')),
('calendar_url',
models.URLField(max_length=500,
null=True,
unique=True,
verbose_name='Calender iCal URL')),
('schedule_json_str', models.TextField(blank=True, null=True)),
('sync_calendar',
models.BooleanField(default=True,
verbose_name='Sync Calender')),
('notifications_flag',
models.BooleanField(default=True,
verbose_name='Notification')),
('track_trans_flag',
models.BooleanField(default=True,
verbose_name='Track Translation')),
('created_by', models.EmailField(max_length=254, null=True)),
('language_set_slug',
models.ForeignKey(on_delete=django.db.models.deletion.PROTECT,
to='dashboard.LanguageSet',
to_field='lang_set_slug',
verbose_name='Language Set')),
('product_slug',
models.ForeignKey(on_delete=django.db.models.deletion.PROTECT,
to='dashboard.Product',
to_field='product_slug',
verbose_name='Product')),
],
options={
'verbose_name_plural': 'Release',
'db_table': 'ts_releases',
},
bases=(dashboard.models.ModelMixin, models.Model),
),
migrations.CreateModel(
name='Report',
fields=[
('reports_id',
models.AutoField(primary_key=True, serialize=False)),
('report_subject', models.CharField(max_length=200,
unique=True)),
('report_json_str', models.TextField(blank=True, null=True)),
('report_updated', models.DateTimeField(null=True)),
],
options={
'verbose_name': 'Report',
'db_table': 'ts_reports',
},
bases=(dashboard.models.ModelMixin, models.Model),
),
migrations.CreateModel(
name='SyncStats',
fields=[
('sync_id', models.AutoField(primary_key=True,
serialize=False)),
('job_uuid', models.UUIDField()),
('project_version', models.CharField(max_length=500,
null=True)),
('source', models.CharField(max_length=500, null=True)),
('stats_raw_json_str', models.TextField(blank=True,
null=True)),
('stats_processed_json_str',
models.TextField(blank=True, null=True)),
('sync_iter_count', models.IntegerField()),
('sync_visibility', models.BooleanField()),
('package_name',
models.ForeignKey(on_delete=django.db.models.deletion.PROTECT,
to='dashboard.Package',
to_field='package_name',
verbose_name='Package')),
],
options={
'db_table': 'ts_syncstats',
},
bases=(dashboard.models.ModelMixin, models.Model),
),
migrations.CreateModel(
name='Visitor',
fields=[
('visitor_id',
models.AutoField(primary_key=True, serialize=False)),
('visitor_ip', models.GenericIPAddressField()),
('visitor_user_agent', models.CharField(max_length=500)),
('visitor_accept',
models.CharField(blank=True, max_length=500, null=True)),
('visitor_encoding',
models.CharField(blank=True, max_length=500, null=True)),
('visitor_language',
models.CharField(blank=True, max_length=500, null=True)),
('visitor_host',
models.CharField(blank=True, max_length=500, null=True)),
('first_visit_time', models.DateTimeField()),
('last_visit_time', models.DateTimeField()),
],
options={
'verbose_name': 'Visitor',
'db_table': 'ts_visitors',
},
),
migrations.AddField(
model_name='package',
name='platform_slug',
field=models.ForeignKey(
on_delete=django.db.models.deletion.PROTECT,
to='dashboard.Platform',
to_field='platform_slug',
verbose_name='Translation Platform'),
),
migrations.AddField(
model_name='job',
name='job_template',
field=models.ForeignKey(
null=True,
on_delete=django.db.models.deletion.PROTECT,
to='dashboard.JobTemplate',
verbose_name='Job Template'),
),
migrations.AddField(
model_name='graphrule',
name='rule_release_slug',
field=models.ForeignKey(
on_delete=django.db.models.deletion.PROTECT,
to='dashboard.Release',
to_field='release_slug',
verbose_name='Graph Rule for Release'),
),
]
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 = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
]
operations = [
migrations.CreateModel(
name='Address',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('street',
models.CharField(default='38 Windsor Street', max_length=85)),
('zip', models.CharField(default='06001', max_length=12)),
],
),
migrations.CreateModel(
name='DeviceModels',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name',
models.CharField(default='generic device', max_length=50)),
('max_life', models.PositiveIntegerField()),
('warranty_days', models.PositiveIntegerField()),
('image',
models.ImageField(blank=True,
default='default.jpg',
null=True,
upload_to='device_catalogue')),
('energy_rating',
models.PositiveIntegerField(validators=[
django.core.validators.MinValueValidator(1),
django.core.validators.MaxValueValidator(10)
])),
('safety_rating',
models.IntegerField(validators=[
django.core.validators.MinValueValidator(1),
django.core.validators.MaxValueValidator(10)
])),
('current_consumption', models.IntegerField()),
('model_number', models.CharField(max_length=50)),
('serial_number', models.CharField(max_length=50)),
],
),
migrations.CreateModel(
name='Home',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('address',
models.ForeignKey(default=dashboard.models.Address(),
on_delete=django.db.models.deletion.CASCADE,
to='dashboard.Address')),
('owner',
models.ForeignKey(
on_delete=django.db.models.deletion.DO_NOTHING,
to=settings.AUTH_USER_MODEL)),
],
),
migrations.CreateModel(
name='SubscribersList',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name',
models.CharField(default='my coffee machine',
max_length=150)),
('email', models.EmailField(max_length=254)),
],
),
migrations.CreateModel(
name='ValueStream',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('description',
models.CharField(default='value stream description',
max_length=50)),
('property_name',
models.CharField(default='default property name',
max_length=25)),
('value', models.FloatField(default=0.0)),
('ts', models.DateTimeField(auto_now_add=True)),
],
),
migrations.CreateModel(
name='Thing',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('description',
models.CharField(default='my smart coffee machine',
max_length=120)),
('purchase_date', models.DateField()),
('life_used', models.IntegerField()),
('device_model_info',
models.ForeignKey(
on_delete=django.db.models.deletion.DO_NOTHING,
to='dashboard.DeviceModels')),
('installed_home_id',
models.ManyToManyField(to='dashboard.Home')),
('owner',
models.ForeignKey(
on_delete=django.db.models.deletion.DO_NOTHING,
to=settings.AUTH_USER_MODEL)),
('value_stream_id',
models.ManyToManyField(to='dashboard.ValueStream')),
],
),
migrations.CreateModel(
name='ServiceProvider',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name',
models.CharField(default='generic manufacturer',
max_length=150)),
('phone_number', models.CharField(default='0000',
max_length=14)),
('address',
models.OneToOneField(
on_delete=django.db.models.deletion.DO_NOTHING,
to='dashboard.Address')),
('type_of_device_handled',
models.ManyToManyField(to='dashboard.DeviceModels')),
],
),
migrations.CreateModel(
name='ServiceDetails',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('receipt_email', models.EmailField(max_length=254)),
('date_of_service',
models.DateField(default=django.utils.timezone.now)),
('remarks', models.TextField(default='Service completed')),
('service_provider',
models.ForeignKey(
on_delete=django.db.models.deletion.DO_NOTHING,
to='dashboard.ServiceProvider')),
('thing',
models.OneToOneField(
on_delete=django.db.models.deletion.CASCADE,
to='dashboard.Thing')),
],
),
migrations.CreateModel(
name='Seller',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name',
models.CharField(default='generic seller', max_length=150)),
('phone_number', models.CharField(default='007',
max_length=14)),
('address',
models.OneToOneField(
on_delete=django.db.models.deletion.PROTECT,
to='dashboard.Address')),
('type_of_device_sold',
models.ManyToManyField(to='dashboard.DeviceModels')),
],
),
migrations.CreateModel(
name='Manufacturer',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name',
models.CharField(default='generic manufacturer',
max_length=50)),
('is_certified', models.BooleanField(default=True)),
('phone_number', models.CharField(default='007',
max_length=14)),
('address',
models.OneToOneField(
on_delete=django.db.models.deletion.DO_NOTHING,
to='dashboard.Address')),
],
),
migrations.AddField(
model_name='devicemodels',
name='mfg',
field=models.ForeignKey(
on_delete=django.db.models.deletion.DO_NOTHING,
to='dashboard.Manufacturer'),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
]
operations = [
migrations.CreateModel(
name='Product',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(default='default', max_length=100)),
('description', models.TextField(default='')),
('version', models.CharField(default='1', max_length=100)),
('arch', models.CharField(default='x86-64', max_length=100)),
('type', models.CharField(default='prod', max_length=100)),
('created_date', models.DateTimeField(auto_now_add=True)),
('modified_date', models.DateTimeField(auto_now=True)),
('props',
django.contrib.postgres.fields.jsonb.JSONField(
blank=True,
default=dashboard.models.get_default_data,
null=True)),
],
options={
'ordering': ('name', 'version'),
},
),
migrations.CreateModel(
name='Run',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('run_start',
models.DateTimeField(default=django.utils.timezone.now)),
('run_stop',
models.DateTimeField(default=django.utils.timezone.now)),
('run_duration',
models.CharField(default='d:0 h:0 m:0: s:0', max_length=500)),
('jenkins',
models.CharField(
default=
'https://pit-stg-jenkins.rhev-ci-vms.eng.rdu2.redhat.com/view/Carbon/view/POC/job/MPQE-Runner/14/',
max_length=500)),
('report',
models.CharField(default='http://report', max_length=500)),
('run_step',
models.CharField(choices=[('INITIALIZING', 'Initializing'),
('PROVISIONING', 'Provisioning'),
('ORCHESTRATION', 'Orchestration'),
('EXECUTION', 'Execution'),
('REPORTING', 'Reporting'),
('COMPLETE', 'Complete')],
default='INITIALIZING',
max_length=13)),
('run_status',
models.CharField(choices=[('RUNNING', 'Running'),
('COMPLETE', 'Complete'),
('ERROR', 'Error'),
('ABORT', 'Abort')],
default='RUNNING',
max_length=8)),
],
),
migrations.CreateModel(
name='Solution',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('solution_name',
models.CharField(default='default',
max_length=100,
unique=True)),
('solution_description',
models.TextField(default='description')),
('solution_version',
models.CharField(default='1.0', max_length=100)),
('created_date', models.DateTimeField(auto_now_add=True)),
('modified_date', models.DateTimeField(auto_now=True)),
('carbon_service_checks',
models.TextField(
default=
'dep_check:\n - ci-rhos\n - zabbix-sysops\n - brew\n - covscan\n - polarion\n - rpmdiff\n - umb\n - errata\n - rdo-cloud\n - gerrit:gerrit.host.prod.eng.bos.redhat.com\n'
)),
('carbon_provision',
models.TextField(
default=
'provision:\n - name: test_machine_01\n role: hypervisor\n description: "bare metal server to host OCP_CNS test environment"\n provider: beaker\n credential: beaker\n bkr_jobgroup: ci-ops-pit\n bkr_arch: x86_64\n bkr_tag: "RTT_ACCEPTED"\n bkr_whiteboard: Carbon bare metal server to host OCP_CNS test environment (Internal) - SJM\n bkr_distro: RHEL-7.4\n bkr_variant: Server\n bkr_host_requires_options: ["arch=x86_64", "memory>=65000", "processors>=400"]\n bkr_key_values: ["DISKSPACE>=100000", "HVM=1"]\n bkr_taskparam: [ "RESERVETIME=345600" ]\n ansible_params:\n ansible_user: root\n ansible_ssh_private_key_file: keys/carbon\n\n'
)),
('carbon_orchestration',
models.TextField(
default=
'#orchestrate:\n\n# system configuration\n# product(s) install\n# product(s) configuration\n# test setup\n\norchestrate:\n - name: ansible/ssh_connect.yml\n description: "setup ssh keys for key based authentication to hypervisor"\n orchestrator: ansible\n hosts: localhost\n ansible_options:\n extra_vars:\n username: root\n password: ci-ops-pit\n ansible_galaxy_options:\n roles:\n - rywillia.ssh-copy-id\n\n - name: ansible/find_nic.yml\n description: "find the active network interface card on the hypervisor"\n orchestrator: ansible\n hosts: hypervisor\n\n - name: ansible/master.yml\n description: "install and configure OCP and CNS"\n orchestrator: ansible\n hosts: hypervisor\n\n'
)),
('testtype',
models.CharField(choices=[
('INTEROP', 'Interop'), ('SCENARIO', 'Scenario'),
('SYSTEM-LOAD', 'System-Load'),
('SYSTEM-RELIABILITY', 'System-Reliability'),
('SYSTEM-STRESS', 'System-Stress'),
('SYSTEM-LONGEVITY', 'System-Longevity')
],
default='INTEROP',
max_length=18)),
('carbon_execution',
models.TextField(
default=
'execute:\n - name: OCP System Test\n description: "Load Tests"\n function: STR\n type: non-functional\n objective: load\n ansible_options:\n extra_vars:\n str_key: rhhi_key.key\n str_profile: /rhhi_profile.yml \n username: root\n password: password\n\n'
)),
('carbon_report',
models.TextField(
default=
'report:\n - name: Report Portal\n description: "Dashboard"\n ansible_options:\n extra_vars:\n username: root\n password: password\n'
)),
('carbon_cfg',
models.TextField(
default=
'# carbon config file\n# ==================\n# default settings\n\n[defaults]\nlog_level=debug\ndata_folder=/var/local/carbon\nworkspace=.\ninternal=True\ndep_check_endpoint=http://semaphore.op.redhat.com/api/v1\n\n# credentials settings\n[credentials:beaker]\nkeytab=<keytab>\nkeytab_principal=<keytab_principal>\nusername=<username>\npassword=<password>\n\n[credentials:openstack]\nauth_url=<auth_url>\ntenant_name=<tenant_name>\nusername=<username>\npassword=<password>\n\n'
)),
('solution_repo',
models.CharField(
blank=True,
default=
'https://gitlab.cee.redhat.com/PIT/CSS_OCP_CNS.git',
max_length=1000,
null=True)),
('solution_link',
models.CharField(
blank=True,
default=
'https://docs.engineering.redhat.com/display/MPQE/MPQE+Home',
max_length=1000,
null=True)),
('jira_link',
models.CharField(
blank=True,
default=
'https://projects.engineering.redhat.com/secure/Dashboard.jspa',
max_length=1000,
null=True)),
('defect_link',
models.CharField(blank=True,
default='https://bugzilla.redhat.com/',
max_length=1000,
null=True)),
('tcms_link',
models.CharField(
blank=True,
default=
'https://polarion.engineering.redhat.com/polarion/',
max_length=1000,
null=True)),
],
options={
'ordering': ('solution_name', 'solution_version'),
},
),
migrations.CreateModel(
name='Stack',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('stack_name',
models.CharField(default='default',
max_length=100,
unique=True)),
('products', models.ManyToManyField(to='dashboard.Product')),
],
options={
'ordering': ('stack_name', ),
},
),
migrations.AddField(
model_name='solution',
name='product_stack',
field=models.ForeignKey(
on_delete=django.db.models.deletion.DO_NOTHING,
to='dashboard.Stack'),
),
migrations.AddField(
model_name='run',
name='solution',
field=models.ForeignKey(
on_delete=django.db.models.deletion.DO_NOTHING,
to='dashboard.Solution'),
),
migrations.AddField(
model_name='run',
name='tester',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL),
),
]
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)),
],
),
]
