Beispiel #1
0
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)),
            ],
        ),
    ]
Beispiel #2
0
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', ),
            },
        ),
    ]
Beispiel #3
0
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')]),
        ),
    ]
Beispiel #5
0
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'),
        ),
    ]
Beispiel #7
0
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'),
        ),
    ]
Beispiel #8
0
class Migration(migrations.Migration):

    initial = True

    dependencies = [
        ('auth', '0011_update_proxy_permissions'),
    ]

    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=254,
                                   unique=True,
                                   verbose_name='email address')),
                ('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')),
                ('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',
            },
            managers=[
                ('objects', dashboard.models.CustomUserManager()),
            ],
        ),
    ]