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 = []
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 = [
('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 = [
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):
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 = [
('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'),
),
]