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):
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', '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 = [
('Home', '0002_remove_teacher_adm_cat'),
]
operations = [
migrations.AddField(
model_name='subject',
name='PRN',
field=models.IntegerField(default=111111,
verbose_name=dashboard.models.Student),
preserve_default=False,
),
]
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='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 = []
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='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 = []
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 = [
('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 = [
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')),
},
),
]