Пример #1
0
class Migration(migrations.Migration):

    initial = True

    dependencies = [
    ]

    operations = [
        migrations.CreateModel(
            name='Group',
            fields=[
                ('id', models.BigIntegerField(primary_key=True, serialize=False)),
                ('name', models.CharField(max_length=50)),
                ('slug', models.SlugField(unique=True, validators=[core.models.slug_validator])),
                ('description', models.CharField(max_length=200)),
            ],
            options={
                'db_table': 'groups',
            },
        ),
        migrations.CreateModel(
            name='User',
            fields=[
                ('id', models.BigIntegerField(primary_key=True, serialize=False)),
                ('username', models.SlugField(max_length=30, unique=True, validators=[core.models.slug_validator])),
                ('email', models.EmailField(max_length=200, unique=True)),
                ('password', models.CharField(max_length=128)),
                ('last_login', models.IntegerField(default=None, null=True)),
                ('created', models.IntegerField(default=time.time)),
                ('name', models.CharField(max_length=50)),
                ('image', models.ImageField(default='', upload_to=core.models.create_filename)),
                ('password_reset_token', models.CharField(default='', max_length=128)),
                ('password_reset_token_expiry', models.IntegerField(default=0)),
            ],
            options={
                'db_table': 'users',
                'ordering': ['created'],
            },
        ),
        migrations.CreateModel(
            name='UserGroupLink',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('permission', models.IntegerField(choices=[[1, 'invited'], [2, 'member'], [3, 'admin']], default=1)),
                ('group', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='core.group')),
                ('user', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='core.user')),
            ],
            options={
                'db_table': 'user_group_links',
            },
        ),
        migrations.AddField(
            model_name='group',
            name='users',
            field=models.ManyToManyField(related_name='groups', through='core.UserGroupLink', to='core.User'),
        ),
    ]
class Migration(migrations.Migration):

    dependencies = [
        ('core', '0019_auto_20180428_2307'),
    ]

    operations = [
        migrations.AddField(
            model_name='userprofile',
            name='viewer_key',
            field=models.BigIntegerField(default=None, unique=True),
        ),
    ]
Пример #3
0
class Migration(migrations.Migration):

    initial = True

    dependencies = [
    ]

    operations = [
        migrations.CreateModel(
            name='Category',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name', models.CharField(default='', max_length=100)),
                ('slug', models.SlugField(blank=True, unique=True)),
                ('image', models.ImageField(blank=True, upload_to='categories')),
            ],
            options={
                'verbose_name_plural': 'Categories',
                'ordering': ['id'],
            },
        ),
        migrations.CreateModel(
            name='SubCategory',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name', models.CharField(max_length=50)),
                ('slug', models.SlugField(blank=True, unique=True)),
                ('category', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='subcategory', to='core.category')),
            ],
            options={
                'verbose_name_plural': 'SubCategory',
            },
        ),
        migrations.CreateModel(
            name='Product',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('title', models.CharField(max_length=120)),
                ('brand', models.CharField(blank=True, max_length=120)),
                ('short_description', ckeditor.fields.RichTextField(blank=True, null=True)),
                ('detail_specification', ckeditor.fields.RichTextField(blank=True, null=True)),
                ('price', models.BigIntegerField(default='')),
                ('color', models.CharField(blank=True, max_length=100)),
                ('model_no', models.CharField(blank=True, max_length=100)),
                ('published', models.DateTimeField(auto_now=True)),
                ('slug', models.SlugField(blank=True, unique=True)),
                ('category', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='core.category')),
                ('subcategory', models.ForeignKey(default='', on_delete=django.db.models.deletion.CASCADE, to='core.subcategory')),
            ],
        ),
    ]
Пример #4
0
class Migration(migrations.Migration):

    dependencies = [
        ('core', '0011_auto_20210626_0224'),
    ]

    operations = [
        migrations.AlterField(
            model_name='billpaymentdetail',
            name='payment_receipt_image',
            field=models.ImageField(null=True, upload_to=core.models.bill_payment_receipt_image_file_path),
        ),
        migrations.AlterField(
            model_name='billpaymentdetail',
            name='payment_receipt_number',
            field=models.BigIntegerField(),
        ),
    ]
class Migration(migrations.Migration):

    initial = True

    dependencies = [
        migrations.swappable_dependency(settings.AUTH_USER_MODEL),
    ]

    operations = [
        migrations.CreateModel(
            name='ActualExpenditure',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('total', models.BigIntegerField(blank=True, null=True)),
                ('current', models.BigIntegerField(blank=True, null=True)),
                ('capital', models.BigIntegerField(blank=True, null=True)),
            ],
        ),
        migrations.CreateModel(
            name='BlogCategory',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('name', models.CharField(max_length=250, unique=True)),
            ],
        ),
        migrations.CreateModel(
            name='Province',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('name',
                 models.CharField(blank=True,
                                  max_length=250,
                                  null=True,
                                  unique=True)),
                ('code', models.IntegerField(blank=True, null=True)),
            ],
        ),
        migrations.CreateModel(
            name='Year',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('year', models.CharField(max_length=250, unique=True)),
            ],
        ),
        migrations.CreateModel(
            name='TotalBudget',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('total', models.BigIntegerField(blank=True, null=True)),
                ('current', models.BigIntegerField(blank=True, null=True)),
                ('capital', models.BigIntegerField(blank=True, null=True)),
                ('province_name',
                 models.ForeignKey(blank=True,
                                   null=True,
                                   on_delete=django.db.models.deletion.CASCADE,
                                   related_name='data3',
                                   to='core.province')),
                ('year',
                 models.ForeignKey(blank=True,
                                   null=True,
                                   on_delete=django.db.models.deletion.CASCADE,
                                   related_name='data1',
                                   to='core.year')),
            ],
        ),
        migrations.CreateModel(
            name='ProvinceSource',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('source',
                 models.CharField(blank=True, max_length=500, null=True)),
                ('budget', models.BigIntegerField(blank=True, null=True)),
                ('province_name',
                 models.ForeignKey(blank=True,
                                   null=True,
                                   on_delete=django.db.models.deletion.CASCADE,
                                   related_name='data6',
                                   to='core.province')),
                ('year',
                 models.ForeignKey(blank=True,
                                   null=True,
                                   on_delete=django.db.models.deletion.CASCADE,
                                   related_name='data7',
                                   to='core.year')),
            ],
        ),
        migrations.CreateModel(
            name='ProvinceBudget',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('office_name',
                 models.CharField(blank=True, max_length=500, null=True)),
                ('actual_expenditure',
                 models.ManyToManyField(to='core.ActualExpenditure')),
                ('province_name',
                 models.ForeignKey(blank=True,
                                   null=True,
                                   on_delete=django.db.models.deletion.CASCADE,
                                   related_name='data4',
                                   to='core.province')),
                ('total_budget',
                 models.ManyToManyField(to='core.TotalBudget')),
            ],
        ),
        migrations.CreateModel(
            name='Information',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('info_type',
                 models.CharField(choices=[('mission', 'Our Mission'),
                                           ('about', 'About Us'),
                                           ('connect', 'Connect with Us'),
                                           ('terms', 'Terms & Condition'),
                                           ('privacy', 'Privacy')],
                                  max_length=75,
                                  unique=True)),
                ('description', models.TextField()),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('is_active', models.BooleanField(default=True)),
                ('created_by',
                 models.ForeignKey(
                     editable=False,
                     null=True,
                     on_delete=django.db.models.deletion.SET_NULL,
                     related_name='information_admin',
                     to=settings.AUTH_USER_MODEL)),
                ('updated_by',
                 models.ForeignKey(
                     editable=False,
                     null=True,
                     on_delete=django.db.models.deletion.SET_NULL,
                     related_name='information',
                     to=settings.AUTH_USER_MODEL)),
            ],
        ),
        migrations.CreateModel(
            name='Glossary',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('title', models.CharField(max_length=200)),
                ('description', models.TextField(blank=True, null=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('is_active', models.BooleanField(default=True)),
                ('created_by',
                 models.ForeignKey(
                     editable=False,
                     null=True,
                     on_delete=django.db.models.deletion.SET_NULL,
                     related_name='glossary_admin',
                     to=settings.AUTH_USER_MODEL)),
                ('updated_by',
                 models.ForeignKey(
                     editable=False,
                     null=True,
                     on_delete=django.db.models.deletion.SET_NULL,
                     related_name='glossary',
                     to=settings.AUTH_USER_MODEL)),
            ],
            options={
                'ordering': ['-created_at'],
                'get_latest_by': ['-created_at'],
            },
        ),
        migrations.CreateModel(
            name='Blog',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('title', models.CharField(max_length=250)),
                ('content', models.TextField()),
                ('publish',
                 models.DateTimeField(blank=True,
                                      default=django.utils.timezone.now,
                                      null=True)),
                ('status',
                 models.IntegerField(choices=[(0, 'Draft'), (1, 'Publish'),
                                              (2, 'UnPublish')],
                                     default=0)),
                ('photo',
                 models.FileField(blank=True,
                                  upload_to=core.models.get_upload_blog)),
                ('tag', models.TextField()),
                ('meta_title', models.TextField(blank=True, null=True)),
                ('meta_keywords', models.TextField(blank=True, null=True)),
                ('meta_description', models.TextField(blank=True, null=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('is_active', models.BooleanField(default=True)),
                ('author',
                 models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
                                   related_name='content_author',
                                   to=settings.AUTH_USER_MODEL)),
                ('category',
                 models.ForeignKey(blank=True,
                                   null=True,
                                   on_delete=django.db.models.deletion.CASCADE,
                                   related_name='article_categories',
                                   to='core.blogcategory')),
                ('created_by',
                 models.ForeignKey(
                     editable=False,
                     null=True,
                     on_delete=django.db.models.deletion.SET_NULL,
                     related_name='blog_admin',
                     to=settings.AUTH_USER_MODEL)),
                ('updated_by',
                 models.ForeignKey(
                     editable=False,
                     null=True,
                     on_delete=django.db.models.deletion.SET_NULL,
                     related_name='blogs',
                     to=settings.AUTH_USER_MODEL)),
            ],
        ),
        migrations.AddField(
            model_name='actualexpenditure',
            name='province_name',
            field=models.ForeignKey(
                blank=True,
                null=True,
                on_delete=django.db.models.deletion.CASCADE,
                related_name='data5',
                to='core.province'),
        ),
        migrations.AddField(
            model_name='actualexpenditure',
            name='year',
            field=models.ForeignKey(
                blank=True,
                null=True,
                on_delete=django.db.models.deletion.CASCADE,
                related_name='data8',
                to='core.year'),
        ),
    ]
Пример #6
0
class Migration(migrations.Migration):

    initial = True

    dependencies = []

    operations = [
        migrations.CreateModel(
            name='AuthGroup',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('name', models.CharField(max_length=150, unique=True)),
            ],
            options={
                'db_table': 'auth_group',
                'managed': False,
            },
        ),
        migrations.CreateModel(
            name='AuthGroupPermissions',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
            ],
            options={
                'db_table': 'auth_group_permissions',
                'managed': False,
            },
        ),
        migrations.CreateModel(
            name='AuthPermission',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('name', models.CharField(max_length=255)),
                ('codename', models.CharField(max_length=100)),
            ],
            options={
                'db_table': 'auth_permission',
                'managed': False,
            },
        ),
        migrations.CreateModel(
            name='AuthUser',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('password', models.CharField(max_length=128)),
                ('last_login', models.DateTimeField(blank=True, null=True)),
                ('is_superuser', models.BooleanField()),
                ('username', models.CharField(max_length=150, unique=True)),
                ('first_name', models.CharField(max_length=150)),
                ('last_name', models.CharField(max_length=150)),
                ('email', models.CharField(max_length=254)),
                ('is_staff', models.BooleanField()),
                ('is_active', models.BooleanField()),
                ('date_joined', models.DateTimeField()),
            ],
            options={
                'db_table': 'auth_user',
                'managed': False,
            },
        ),
        migrations.CreateModel(
            name='AuthUserGroups',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
            ],
            options={
                'db_table': 'auth_user_groups',
                'managed': False,
            },
        ),
        migrations.CreateModel(
            name='AuthUserUserPermissions',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
            ],
            options={
                'db_table': 'auth_user_user_permissions',
                'managed': False,
            },
        ),
        migrations.CreateModel(
            name='DjangoAdminLog',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('action_time', models.DateTimeField()),
                ('object_id', models.TextField(blank=True, null=True)),
                ('object_repr', models.CharField(max_length=200)),
                ('action_flag', models.SmallIntegerField()),
                ('change_message', models.TextField()),
            ],
            options={
                'db_table': 'django_admin_log',
                'managed': False,
            },
        ),
        migrations.CreateModel(
            name='DjangoContentType',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('app_label', models.CharField(max_length=100)),
                ('model', models.CharField(max_length=100)),
            ],
            options={
                'db_table': 'django_content_type',
                'managed': False,
            },
        ),
        migrations.CreateModel(
            name='DjangoMigrations',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('app', models.CharField(max_length=255)),
                ('name', models.CharField(max_length=255)),
                ('applied', models.DateTimeField()),
            ],
            options={
                'db_table': 'django_migrations',
                'managed': False,
            },
        ),
        migrations.CreateModel(
            name='DjangoSession',
            fields=[
                ('session_key',
                 models.CharField(max_length=40,
                                  primary_key=True,
                                  serialize=False)),
                ('session_data', models.TextField()),
                ('expire_date', models.DateTimeField()),
            ],
            options={
                'db_table': 'django_session',
                'managed': False,
            },
        ),
        migrations.CreateModel(
            name='Role',
            fields=[
                ('id', models.AutoField(primary_key=True, serialize=False)),
                ('name', models.CharField(max_length=50)),
                ('description', models.CharField(max_length=100)),
                ('created_date',
                 models.DateTimeField(auto_now_add=True, null=True)),
                ('is_active', models.BooleanField(default=True, null=True)),
            ],
            options={
                'db_table': 'role',
            },
        ),
        migrations.CreateModel(
            name='User',
            fields=[
                ('id', models.AutoField(primary_key=True, serialize=False)),
                ('first_name', models.CharField(max_length=100)),
                ('last_name', models.CharField(max_length=100)),
                ('email_id',
                 django.contrib.postgres.fields.citext.CIEmailField(
                     max_length=100, unique=True)),
                ('password', models.CharField(max_length=100)),
                ('is_active', models.BooleanField(default=True, null=True)),
                ('created_datetime',
                 models.DateTimeField(auto_now_add=True, null=True)),
                ('role',
                 models.ForeignKey(default=core.models.User.DEFAULT_ROLE,
                                   on_delete=django.db.models.deletion.CASCADE,
                                   to='core.role')),
            ],
            options={
                'db_table': 'user',
            },
        ),
        migrations.CreateModel(
            name='UserAdditionalInfoLog',
            fields=[
                ('id', models.AutoField(primary_key=True, serialize=False)),
                ('user_additional_info_id', models.BigIntegerField()),
                ('user_id', models.BigIntegerField()),
                ('sex', models.CharField(blank=True, max_length=1, null=True)),
                ('dob', models.DateField(blank=True, null=True)),
                ('credit_score', models.IntegerField(blank=True, null=True)),
                ('employment_type',
                 models.CharField(blank=True, max_length=100, null=True)),
                ('annual_salary', models.IntegerField(blank=True, null=True)),
                ('reason', models.CharField(max_length=100)),
                ('created_by', models.IntegerField()),
                ('created_at',
                 models.DateTimeField(auto_now_add=True, null=True)),
            ],
            options={
                'db_table': 'user_additional_info_log',
            },
        ),
        migrations.CreateModel(
            name='UserLog',
            fields=[
                ('id', models.AutoField(primary_key=True, serialize=False)),
                ('user_id', models.BigIntegerField()),
                ('role_id', models.IntegerField()),
                ('user_status_id', models.IntegerField()),
                ('user_type_id', models.IntegerField(blank=True, null=True)),
                ('first_name', models.CharField(max_length=100)),
                ('last_name', models.CharField(max_length=100)),
                ('email_id', models.CharField(max_length=100)),
                ('password', models.CharField(max_length=100)),
                ('is_active', models.BooleanField(default=True, null=True)),
                ('created_datetime',
                 models.DateTimeField(auto_now_add=True, null=True)),
                ('reason', models.CharField(max_length=100)),
                ('created_by', models.IntegerField(default=True, null=True)),
                ('created_at',
                 models.DateTimeField(auto_now_add=True, null=True)),
            ],
            options={
                'db_table': 'user_log',
            },
        ),
        migrations.CreateModel(
            name='UserStatus',
            fields=[
                ('id', models.AutoField(primary_key=True, serialize=False)),
                ('name', models.CharField(max_length=50)),
                ('description', models.CharField(max_length=100)),
                ('created_date',
                 models.DateTimeField(auto_now_add=True, null=True)),
                ('is_active', models.BooleanField(default=True, null=True)),
            ],
            options={
                'db_table': 'user_status',
            },
        ),
        migrations.CreateModel(
            name='UserType',
            fields=[
                ('id', models.AutoField(primary_key=True, serialize=False)),
                ('name', models.CharField(max_length=50)),
                ('description', models.CharField(max_length=100)),
                ('is_active', models.BooleanField(default=True, null=True)),
                ('created_date',
                 models.DateTimeField(auto_now_add=True, null=True)),
                ('deleted_why',
                 models.CharField(blank=True, max_length=100, null=True)),
                ('deleted_at',
                 models.DateTimeField(auto_now_add=True, null=True)),
            ],
            options={
                'db_table': 'user_type',
            },
        ),
        migrations.CreateModel(
            name='UserAdditionalInfo',
            fields=[
                ('id', models.AutoField(primary_key=True, serialize=False)),
                ('sex', models.CharField(blank=True, max_length=1, null=True)),
                ('dob', models.DateField(blank=True, null=True)),
                ('credit_score', models.IntegerField(blank=True, null=True)),
                ('employment_type',
                 models.CharField(blank=True, max_length=100, null=True)),
                ('annual_salary', models.IntegerField(blank=True, null=True)),
                ('user',
                 models.ForeignKey(
                     on_delete=django.db.models.deletion.DO_NOTHING,
                     to='core.user')),
            ],
            options={
                'db_table': 'user_additional_info',
            },
        ),
        migrations.AddField(
            model_name='user',
            name='user_status',
            field=models.ForeignKey(
                default=core.models.User.DEFAULT_USER_STATUS,
                null=True,
                on_delete=django.db.models.deletion.CASCADE,
                to='core.userstatus'),
        ),
        migrations.AddField(
            model_name='user',
            name='user_type',
            field=models.ForeignKey(
                blank=True,
                default=core.models.User.DEFAULT_USER_TYPE,
                null=True,
                on_delete=django.db.models.deletion.CASCADE,
                to='core.usertype'),
        ),
    ]
Пример #7
0
class Migration(migrations.Migration):

    initial = True

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

    operations = [
        migrations.CreateModel(
            name='RCUser',
            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')),
                ('is_staff', models.BooleanField(default=False)),
                ('first_name', models.CharField(blank=True, max_length=30)),
                ('last_name', models.CharField(blank=True, max_length=150)),
                ('telegram_uid', models.TextField(unique=True)),
                ('telegram_username', models.TextField(null=True)),
                ('role', models.CharField(default='common', max_length=100)),
                ('tags',
                 django.contrib.postgres.fields.ArrayField(
                     base_field=models.CharField(max_length=100),
                     default=list,
                     size=None)),
            ],
            options={
                'abstract': False,
            },
            managers=[
                ('objects', core.models.RCUserManager()),
            ],
        ),
        migrations.CreateModel(
            name='Gang',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('token', models.CharField(max_length=10)),
                ('default_times',
                 django.contrib.postgres.fields.ArrayField(
                     base_field=models.TimeField(), default=list, size=None)),
            ],
        ),
        migrations.CreateModel(
            name='TelegramChat',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('chat_id', models.BigIntegerField(unique=True)),
                ('type', models.CharField(default='private', max_length=20)),
                ('name', models.CharField(max_length=256)),
                ('created', models.DateTimeField(auto_now_add=True)),
                ('title',
                 models.CharField(blank=True, max_length=255, null=True)),
                ('username',
                 models.CharField(blank=True, max_length=255, null=True)),
                ('first_name',
                 models.CharField(blank=True, max_length=255, null=True)),
                ('last_name',
                 models.CharField(blank=True, max_length=255, null=True)),
                ('state', models.TextField(default='init')),
                ('state_updated', models.DateTimeField(blank=True, null=True)),
            ],
        ),
        migrations.CreateModel(
            name='TelegramMessage',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('message_id', models.BigIntegerField()),
                ('date', models.DateTimeField()),
                ('edit_date', models.DateTimeField(blank=True, null=True)),
                ('text', models.TextField(blank=True, null=True)),
                ('chat',
                 models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
                                   to='core.TelegramChat')),
            ],
        ),
        migrations.CreateModel(
            name='TelegramUser',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('uid', models.BigIntegerField()),
                ('first_name', models.CharField(max_length=30)),
                ('last_name',
                 models.CharField(blank=True, max_length=150, null=True)),
                ('username',
                 models.CharField(blank=True, max_length=100, null=True)),
            ],
        ),
        migrations.CreateModel(
            name='TelegramUpdate',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('update_id', models.BigIntegerField(unique=True)),
                ('edited_message',
                 models.ForeignKey(
                     blank=True,
                     null=True,
                     on_delete=django.db.models.deletion.CASCADE,
                     related_name='telegramupdate_edited_message',
                     to='core.TelegramMessage')),
                ('effective_chat',
                 models.ForeignKey(blank=True,
                                   null=True,
                                   on_delete=django.db.models.deletion.CASCADE,
                                   to='core.TelegramChat')),
                ('effective_message',
                 models.ForeignKey(
                     blank=True,
                     null=True,
                     on_delete=django.db.models.deletion.CASCADE,
                     related_name='telegramupdate_effective_message',
                     to='core.TelegramMessage')),
                ('effective_user',
                 models.ForeignKey(blank=True,
                                   null=True,
                                   on_delete=django.db.models.deletion.CASCADE,
                                   to='core.TelegramUser')),
                ('message',
                 models.ForeignKey(blank=True,
                                   null=True,
                                   on_delete=django.db.models.deletion.CASCADE,
                                   related_name='telegramupdate_message',
                                   to='core.TelegramMessage')),
            ],
        ),
        migrations.AddField(
            model_name='telegrammessage',
            name='from_user',
            field=models.ForeignKey(
                blank=True,
                null=True,
                on_delete=django.db.models.deletion.CASCADE,
                related_name='telegrammessage_from_user',
                to='core.TelegramUser'),
        ),
        migrations.AddField(
            model_name='telegrammessage',
            name='new_chat_members',
            field=models.ManyToManyField(
                related_name='telegrammessage_new_chat_members',
                to='core.TelegramUser'),
        ),
        migrations.CreateModel(
            name='SeparatorQuestion',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('text', models.TextField()),
                ('variants',
                 django.contrib.postgres.fields.ArrayField(
                     base_field=models.CharField(max_length=100), size=None)),
                ('gang',
                 models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
                                   to='core.Gang')),
            ],
        ),
        migrations.CreateModel(
            name='HistoryEntry',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('ts', models.DateTimeField()),
                ('user1',
                 models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
                                   related_name='historyentry_user1',
                                   to=settings.AUTH_USER_MODEL)),
                ('user2',
                 models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
                                   related_name='historyentry_user2',
                                   to=settings.AUTH_USER_MODEL)),
            ],
        ),
        migrations.AddField(
            model_name='rcuser',
            name='gang',
            field=models.ForeignKey(
                on_delete=django.db.models.deletion.CASCADE, to='core.Gang'),
        ),
        migrations.AddField(
            model_name='rcuser',
            name='groups',
            field=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'),
        ),
        migrations.AddField(
            model_name='rcuser',
            name='telegram_chat',
            field=models.ForeignKey(
                blank=True,
                null=True,
                on_delete=django.db.models.deletion.CASCADE,
                related_name='telegram_chat',
                to='core.TelegramChat'),
        ),
        migrations.AddField(
            model_name='rcuser',
            name='user_permissions',
            field=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'),
        ),
    ]
Пример #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=255, unique=True)),
                ('slug', models.SlugField(blank=True, default='', max_length=255, 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,
            },
        ),
        migrations.CreateModel(
            name='InsertUpdate',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('Inserted_On', models.DateTimeField(default=django.utils.timezone.now)),
                ('Updated_On', models.DateTimeField(blank=True, null=True)),
                ('Inserted_By', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='inserted_byy', to=settings.AUTH_USER_MODEL)),
                ('Updated_By', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='updated_byy', to=settings.AUTH_USER_MODEL)),
            ],
        ),
        migrations.CreateModel(
            name='SetupTable',
            fields=[
                ('insertupdate_ptr', models.OneToOneField(auto_created=True, on_delete=django.db.models.deletion.CASCADE, parent_link=True, primary_key=True, serialize=False, to='core.InsertUpdate')),
                ('Name', models.CharField(max_length=255)),
                ('Description', models.TextField(max_length=500)),
                ('Is_Active', models.BooleanField(default=True)),
                ('System_Used', models.BooleanField(default=False)),
            ],
            bases=('core.insertupdate', models.Model),
        ),
        migrations.CreateModel(
            name='AddressType',
            fields=[
                ('setuptable_ptr', models.OneToOneField(auto_created=True, on_delete=django.db.models.deletion.CASCADE, parent_link=True, primary_key=True, serialize=False, to='core.SetupTable')),
            ],
            bases=('core.setuptable',),
        ),
        migrations.CreateModel(
            name='City',
            fields=[
                ('setuptable_ptr', models.OneToOneField(auto_created=True, on_delete=django.db.models.deletion.CASCADE, parent_link=True, primary_key=True, serialize=False, to='core.SetupTable')),
            ],
            options={
                'verbose_name_plural': 'Cities',
            },
            bases=('core.setuptable',),
        ),
        migrations.CreateModel(
            name='Country',
            fields=[
                ('setuptable_ptr', models.OneToOneField(auto_created=True, on_delete=django.db.models.deletion.CASCADE, parent_link=True, primary_key=True, serialize=False, to='core.SetupTable')),
            ],
            options={
                'verbose_name_plural': 'Countries',
            },
            bases=('core.setuptable',),
        ),
        migrations.CreateModel(
            name='Gender',
            fields=[
                ('setuptable_ptr', models.OneToOneField(auto_created=True, on_delete=django.db.models.deletion.CASCADE, parent_link=True, primary_key=True, serialize=False, to='core.SetupTable')),
            ],
            bases=('core.setuptable',),
        ),
        migrations.CreateModel(
            name='ProfileStatus',
            fields=[
                ('setuptable_ptr', models.OneToOneField(auto_created=True, on_delete=django.db.models.deletion.CASCADE, parent_link=True, primary_key=True, serialize=False, to='core.SetupTable')),
            ],
            options={
                'verbose_name_plural': 'Profile Statuses',
            },
            bases=('core.setuptable',),
        ),
        migrations.CreateModel(
            name='UserType',
            fields=[
                ('setuptable_ptr', models.OneToOneField(auto_created=True, on_delete=django.db.models.deletion.CASCADE, parent_link=True, primary_key=True, serialize=False, to='core.SetupTable')),
            ],
            bases=('core.setuptable',),
        ),
        migrations.CreateModel(
            name='Profile',
            fields=[
                ('insertupdate_ptr', models.OneToOneField(auto_created=True, on_delete=django.db.models.deletion.CASCADE, parent_link=True, primary_key=True, serialize=False, to='core.InsertUpdate')),
                ('Full_Name', models.CharField(max_length=50)),
                ('CNIC', models.BigIntegerField(blank=True, null=True)),
                ('DOB', models.DateField(blank=True, null=True)),
                ('contact', models.BigIntegerField(blank=True, null=True)),
                ('other_contacts', models.TextField(blank=True, max_length=1000, null=True)),
                ('Shop_Name', models.CharField(blank=True, max_length=255, null=True)),
                ('WhatsApp', models.BooleanField(default=False)),
                ('image', models.ImageField(default='pics_default/default_user.png', upload_to=core.models.profile_image_file_path)),
                ('user', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)),
                ('Address_Types', models.ManyToManyField(blank=True, to='core.AddressType')),
                ('Profile_Status', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.DO_NOTHING, to='core.ProfileStatus')),
                ('User_Type', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to='core.UserType')),
                ('city', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.DO_NOTHING, to='core.City')),
                ('country', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.DO_NOTHING, to='core.Country')),
                ('gender', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='profile_gender', to='core.Gender')),
            ],
            bases=('core.insertupdate', models.Model),
        ),
        migrations.AddField(
            model_name='city',
            name='countryy',
            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='city', to='core.Country'),
        ),
    ]
Пример #9
0
class Migration(migrations.Migration):

    initial = True

    dependencies = [
        ('auth', '0012_alter_user_first_name_max_length'),
    ]

    operations = [
        migrations.CreateModel(
            name='Depart',
            fields=[
                ('id',
                 models.BigAutoField(auto_created=True,
                                     primary_key=True,
                                     serialize=False,
                                     verbose_name='ID')),
                ('myid',
                 models.PositiveBigIntegerField(
                     blank=True,
                     null=True,
                     unique=True,
                     validators=[core.models.validate_03],
                     verbose_name='ID')),
                ('name', models.CharField(max_length=32, verbose_name='Name')),
            ],
            options={
                'verbose_name': 'Deparment',
                'verbose_name_plural': 'Deparments',
                'ordering': ('name', ),
            },
        ),
        migrations.CreateModel(
            name='EMail',
            fields=[
                ('id',
                 models.BigAutoField(auto_created=True,
                                     primary_key=True,
                                     serialize=False,
                                     verbose_name='ID')),
                ('email',
                 models.EmailField(max_length=254, verbose_name='Email')),
            ],
            options={
                'verbose_name': 'Email',
                'verbose_name_plural': 'Emails',
                'ordering': ('email', ),
            },
        ),
        migrations.CreateModel(
            name='Membership',
            fields=[
                ('id',
                 models.BigAutoField(auto_created=True,
                                     primary_key=True,
                                     serialize=False,
                                     verbose_name='ID')),
                ('created_at',
                 models.DateTimeField(auto_now_add=True,
                                      verbose_name='Created')),
            ],
        ),
        migrations.CreateModel(
            name='Org',
            fields=[
                ('id',
                 models.BigAutoField(auto_created=True,
                                     primary_key=True,
                                     serialize=False,
                                     verbose_name='ID')),
                ('myid',
                 models.BigIntegerField(blank=True,
                                        null=True,
                                        unique=True,
                                        validators=[core.models.validate_02],
                                        verbose_name='ID')),
                ('name',
                 models.CharField(max_length=40,
                                  unique=True,
                                  verbose_name='Name')),
                ('fullname',
                 models.CharField(blank=True,
                                  max_length=255,
                                  null=True,
                                  verbose_name='Full name')),
                ('vat',
                 models.PositiveBigIntegerField(blank=True,
                                                null=True,
                                                verbose_name='VAT')),
                ('kpp',
                 models.PositiveIntegerField(blank=True,
                                             null=True,
                                             verbose_name='KPP')),
                ('created_at',
                 models.DateTimeField(auto_now_add=True,
                                      verbose_name='Created')),
                ('updated_at',
                 models.DateTimeField(auto_now=True, verbose_name='Updated')),
            ],
            options={
                'verbose_name': 'Organization',
                'verbose_name_plural': 'Organizations',
                'ordering': ('name', ),
            },
        ),
        migrations.CreateModel(
            name='Person',
            fields=[
                ('user_ptr',
                 models.OneToOneField(
                     auto_created=True,
                     on_delete=django.db.models.deletion.CASCADE,
                     parent_link=True,
                     primary_key=True,
                     serialize=False,
                     to='auth.user')),
                ('myid',
                 models.PositiveBigIntegerField(
                     blank=True,
                     null=True,
                     unique=True,
                     validators=[core.models.validate_01],
                     verbose_name='ID')),
                ('mid_name',
                 models.CharField(blank=True,
                                  max_length=32,
                                  null=True,
                                  verbose_name='Middle name')),
                ('phone',
                 models.CharField(blank=True,
                                  max_length=16,
                                  null=True,
                                  unique=True,
                                  verbose_name='Main Phone')),
                ('ptype',
                 models.PositiveSmallIntegerField(blank=True,
                                                  choices=[(1, 'Primary'),
                                                           (2, 'Secondary'),
                                                           (3, 'External'),
                                                           (4, 'Indirect')],
                                                  null=True,
                                                  verbose_name='Type')),
                ('sex',
                 models.BooleanField(blank=True, null=True,
                                     verbose_name='Sex')),
                ('tz',
                 models.CharField(blank=True,
                                  max_length=32,
                                  null=True,
                                  verbose_name='Time zone')),
                ('sn_ok',
                 models.URLField(blank=True,
                                 null=True,
                                 verbose_name='OK profile URL')),
                ('sn_ig',
                 models.URLField(blank=True,
                                 null=True,
                                 verbose_name='Instagram profile URL')),
                ('sn_tg',
                 models.CharField(blank=True,
                                  max_length=32,
                                  null=True,
                                  verbose_name='Telegram account')),
                ('sn_wa',
                 models.CharField(blank=True,
                                  max_length=32,
                                  null=True,
                                  verbose_name='WhatsApp account')),
                ('sn_vb',
                 models.CharField(blank=True,
                                  max_length=32,
                                  null=True,
                                  verbose_name='Viber account')),
                ('updated_at',
                 models.DateTimeField(auto_now=True, verbose_name='Updated')),
                ('statemod_at',
                 models.DateTimeField(null=True,
                                      verbose_name='State updated')),
            ],
            options={
                'verbose_name': 'Person',
                'verbose_name_plural': 'Persons',
                'ordering': ('last_name', 'first_name', 'mid_name'),
            },
            bases=('auth.user', ),
            managers=[
                ('objects', django.contrib.auth.models.UserManager()),
            ],
        ),
        migrations.CreateModel(
            name='SnVK',
            fields=[
                ('id',
                 models.BigAutoField(auto_created=True,
                                     primary_key=True,
                                     serialize=False,
                                     verbose_name='ID')),
                ('url', models.URLField(verbose_name='Profile URL')),
                ('person',
                 models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
                                   to='core.person')),
            ],
            options={
                'verbose_name': 'VK profile',
                'verbose_name_plural': 'VK profiles',
                'ordering': ('url', ),
            },
        ),
        migrations.CreateModel(
            name='SnFB',
            fields=[
                ('id',
                 models.BigAutoField(auto_created=True,
                                     primary_key=True,
                                     serialize=False,
                                     verbose_name='ID')),
                ('url', models.URLField(verbose_name='Profile URL')),
                ('person',
                 models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
                                   to='core.person')),
            ],
            options={
                'verbose_name': 'FB profile',
                'verbose_name_plural': 'FB profiles',
                'ordering': ('url', ),
            },
        ),
        migrations.CreateModel(
            name='Phone',
            fields=[
                ('id',
                 models.BigAutoField(auto_created=True,
                                     primary_key=True,
                                     serialize=False,
                                     verbose_name='ID')),
                ('phone', models.CharField(max_length=16,
                                           verbose_name='Phone')),
                ('person',
                 models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
                                   related_name='phone_set',
                                   to='core.person')),
            ],
            options={
                'verbose_name': 'Phone',
                'verbose_name_plural': 'Phones',
                'ordering': ('phone', ),
            },
        ),
        migrations.AddIndex(
            model_name='person',
            index=models.Index(fields=['myid'],
                               name='core_person_myid_61a213_idx'),
        ),
        migrations.AddIndex(
            model_name='person',
            index=models.Index(fields=['mid_name'],
                               name='core_person_mid_nam_7800ec_idx'),
        ),
        migrations.AddIndex(
            model_name='org',
            index=models.Index(fields=['myid'],
                               name='core_org_myid_e14802_idx'),
        ),
        migrations.AddIndex(
            model_name='org',
            index=models.Index(fields=['name'],
                               name='core_org_name_674726_idx'),
        ),
        migrations.AddField(
            model_name='membership',
            name='depart',
            field=models.ForeignKey(
                on_delete=django.db.models.deletion.CASCADE, to='core.depart'),
        ),
        migrations.AddField(
            model_name='membership',
            name='person',
            field=models.ForeignKey(
                on_delete=django.db.models.deletion.CASCADE, to='core.person'),
        ),
        migrations.AddField(
            model_name='email',
            name='person',
            field=models.ForeignKey(
                on_delete=django.db.models.deletion.CASCADE,
                related_name='email_set',
                to='core.person'),
        ),
        migrations.AddField(
            model_name='depart',
            name='org',
            field=models.ForeignKey(
                on_delete=django.db.models.deletion.CASCADE, to='core.org'),
        ),
        migrations.AddField(
            model_name='depart',
            name='parent',
            field=models.ForeignKey(
                blank=True,
                null=True,
                on_delete=django.db.models.deletion.CASCADE,
                to='core.depart'),
        ),
        migrations.AddField(
            model_name='depart',
            name='persons',
            field=models.ManyToManyField(through='core.Membership',
                                         to='core.Person'),
        ),
        migrations.AlterUniqueTogether(
            name='membership',
            unique_together={('depart', 'person')},
        ),
        migrations.AddIndex(
            model_name='depart',
            index=models.Index(fields=['myid'],
                               name='core_depart_myid_7661a1_idx'),
        ),
        migrations.AddIndex(
            model_name='depart',
            index=models.Index(fields=['name'],
                               name='core_depart_name_5f7327_idx'),
        ),
        migrations.AddIndex(
            model_name='depart',
            index=models.Index(fields=['parent'],
                               name='core_depart_parent__4ee67f_idx'),
        ),
        migrations.AddIndex(
            model_name='depart',
            index=models.Index(fields=['org'],
                               name='core_depart_org_id_f32bed_idx'),
        ),
        migrations.AlterUniqueTogether(
            name='depart',
            unique_together={('name', 'parent_id', 'org_id')},
        ),
    ]
Пример #10
0
class Migration(migrations.Migration):

    initial = True

    dependencies = []

    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')),
                ('created_at',
                 models.DateTimeField(
                     auto_now_add=True,
                     help_text='Auto added at the time of creation only.',
                     null=True,
                     verbose_name='Created Date')),
                ('updated_at',
                 models.DateTimeField(
                     auto_now=True,
                     help_text='Auto added everytime model is updated.',
                     null=True,
                     verbose_name='Updated Date')),
                ('phone_number',
                 models.CharField(
                     blank=True,
                     help_text='Phone number of the user',
                     max_length=15,
                     unique=True,
                     validators=[
                         django.core.validators.RegexValidator(
                             message=
                             "Phone number must be entered in the format: '999999999'",
                             regex='^\\+?1?\\d{9,14}$')
                     ],
                     verbose_name='phone_number')),
                ('first_name',
                 models.CharField(blank=True,
                                  help_text="User's first name",
                                  max_length=255,
                                  null=True,
                                  verbose_name='first_name')),
                ('last_name',
                 models.CharField(blank=True,
                                  help_text="User's last name",
                                  max_length=255,
                                  null=True,
                                  verbose_name='last_name')),
                ('active',
                 models.BooleanField(default=True,
                                     help_text='Is user active',
                                     verbose_name='is_active')),
                ('staff',
                 models.BooleanField(default=False,
                                     help_text='Is user a staff member',
                                     verbose_name='is_staff')),
                ('admin',
                 models.BooleanField(default=False,
                                     help_text='Is user a superuser/admin',
                                     verbose_name='is_admin')),
                ('email',
                 models.EmailField(blank=True,
                                   help_text='User email Id',
                                   max_length=255,
                                   null=True,
                                   unique=True,
                                   verbose_name='email_id')),
                ('gender',
                 models.CharField(blank=True,
                                  choices=[('M', 'M - MALE'),
                                           ('F', 'F - FEMALE'),
                                           ('O', 'O - OTHER')],
                                  help_text='User gender',
                                  max_length=255,
                                  null=True,
                                  verbose_name='gender')),
                ('user_type',
                 models.CharField(blank=True,
                                  choices=[('R', 'R - REQUESTOR'),
                                           ('G', 'G - GIGSTER')],
                                  help_text='Is user a Requestor/Gigster',
                                  max_length=255,
                                  null=True,
                                  verbose_name='user_type')),
                ('user_rating',
                 models.FloatField(blank=True,
                                   help_text='User overall Rating',
                                   null=True,
                                   verbose_name='User Rating')),
                ('suspended',
                 models.BooleanField(
                     default=False,
                     help_text='Is user suspended by the admin',
                     verbose_name='is_user_suspended')),
                ('suspended_date',
                 models.DateTimeField(
                     auto_now=True,
                     help_text='Auto added when the user is suspended',
                     null=True,
                     verbose_name='Suspended Date')),
                ('city',
                 models.CharField(blank=True,
                                  help_text="User's City",
                                  max_length=255,
                                  null=True,
                                  verbose_name='City')),
            ],
            options={
                'verbose_name': 'User',
                'verbose_name_plural': 'Users',
                'db_table': 'Users',
                'managed': True,
            },
        ),
        migrations.CreateModel(
            name='GigsterProject',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('created_at',
                 models.DateTimeField(
                     auto_now_add=True,
                     help_text='Auto added at the time of creation only.',
                     null=True,
                     verbose_name='Created Date')),
                ('updated_at',
                 models.DateTimeField(
                     auto_now=True,
                     help_text='Auto added everytime model is updated.',
                     null=True,
                     verbose_name='Updated Date')),
                ('gigster_project_choice',
                 models.IntegerField(choices=[(1, 'A - ACCEPT'),
                                              (2, 'R - REJECT')],
                                     null=True,
                                     verbose_name='gigster_project_choice')),
                ('gigster_rating',
                 models.DecimalField(blank=True,
                                     decimal_places=1,
                                     max_digits=2,
                                     null=True,
                                     verbose_name='gigster_rating')),
                ('project_status',
                 models.IntegerField(blank=True,
                                     choices=[(1, 'O - OPEN'),
                                              (2, 'A - ACCEPTED'),
                                              (3, 'C - CLOSED '),
                                              (4, 'S - STARTED'),
                                              (5, 'E - ENDED'),
                                              (6, 'A - APPROVED'),
                                              (7, 'R - RATED'),
                                              (8, 'P - PAID')],
                                     null=True)),
                ('pay_status',
                 models.IntegerField(blank=True,
                                     choices=[(1, 'P - PAID'),
                                              (2, 'U - UNPAID')],
                                     null=True)),
            ],
            options={
                'verbose_name': 'Gigster Project',
                'verbose_name_plural': 'Gigster Projects',
                'db_table': 'Gigster_Project',
                'managed': True,
            },
        ),
        migrations.CreateModel(
            name='GigsterSkills',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('created_at',
                 models.DateTimeField(
                     auto_now_add=True,
                     help_text='Auto added at the time of creation only.',
                     null=True,
                     verbose_name='Created Date')),
                ('updated_at',
                 models.DateTimeField(
                     auto_now=True,
                     help_text='Auto added everytime model is updated.',
                     null=True,
                     verbose_name='Updated Date')),
                ('experience',
                 models.IntegerField(blank=True,
                                     choices=[(1, 'NO EXPERIENCE'),
                                              (2, '3-6 MONTHS EXPERIENCE '),
                                              (3, '6+ MONTHS EXPERIENCE ')],
                                     null=True,
                                     verbose_name='experience')),
                ('certificate',
                 models.ImageField(blank=True,
                                   null=True,
                                   upload_to=core.models.upload_certificate)),
                ('experience_in_word',
                 models.TextField(blank=True,
                                  null=True,
                                  verbose_name='experience_in_word')),
            ],
            options={
                'verbose_name': 'Gigster Skill',
                'verbose_name_plural': 'Gigster Skills',
                'db_table': 'Gigster Skills',
                'managed': True,
            },
        ),
        migrations.CreateModel(
            name='PhoneOTP',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('created_at',
                 models.DateTimeField(
                     auto_now_add=True,
                     help_text='Auto added at the time of creation only.',
                     null=True,
                     verbose_name='Created Date')),
                ('updated_at',
                 models.DateTimeField(
                     auto_now=True,
                     help_text='Auto added everytime model is updated.',
                     null=True,
                     verbose_name='Updated Date')),
                ('phone_number',
                 models.CharField(
                     blank=True,
                     help_text='Phone number to be validated',
                     max_length=15,
                     validators=[
                         django.core.validators.RegexValidator(
                             message=
                             "Phone number must be entered in the format: '999999999'",
                             regex='^\\+?1?\\d{9,14}$')
                     ],
                     verbose_name='phone_number')),
                ('otp',
                 models.CharField(
                     help_text='otp to be send to the Phone number',
                     max_length=6,
                     verbose_name='OTP')),
                ('count',
                 models.IntegerField(default=0,
                                     help_text='Number of OTP send.',
                                     verbose_name='Attempted count')),
                ('is_verified',
                 models.BooleanField(
                     default=False,
                     help_text=
                     'If it is true, this means user has validated otp correctly',
                     verbose_name='is_verified')),
            ],
            options={
                'verbose_name': 'Phone OTP',
                'verbose_name_plural': 'Phone OTPs',
                'db_table': 'PhoneOTP',
                'managed': True,
            },
        ),
        migrations.CreateModel(
            name='Project',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('created_at',
                 models.DateTimeField(
                     auto_now_add=True,
                     help_text='Auto added at the time of creation only.',
                     null=True,
                     verbose_name='Created Date')),
                ('updated_at',
                 models.DateTimeField(
                     auto_now=True,
                     help_text='Auto added everytime model is updated.',
                     null=True,
                     verbose_name='Updated Date')),
                ('project_category',
                 models.IntegerField(blank=True,
                                     choices=[(1, 'Events')],
                                     null=True)),
                ('project_title',
                 models.CharField(blank=True, max_length=255, null=True)),
                ('project_type',
                 models.IntegerField(blank=True,
                                     choices=[(1, 'S - SINGLE-DAY-JOB'),
                                              (2, 'M - MULTI-DAY-JOB')],
                                     null=True)),
                ('no_of_gigsters_required',
                 models.CharField(blank=True, max_length=255, null=True)),
                ('gender_of_gigsters_required',
                 models.IntegerField(blank=True,
                                     choices=[(1, 'M - MALE'),
                                              (2, 'F - FEMALE'),
                                              (3, 'N - NO PARTICULAR CHOICE')],
                                     null=True)),
                ('requirements', models.TextField(blank=True, null=True)),
                ('special_instruction', models.TextField(blank=True,
                                                         null=True)),
                ('project_location', models.TextField(blank=True, null=True)),
                ('arrival_instructions', models.TextField(blank=True,
                                                          null=True)),
                ('project_details', models.TextField(blank=True, null=True)),
                ('project_active', models.BooleanField(default=False)),
                ('duration',
                 models.CharField(blank=True, max_length=255, null=True)),
                ('pay', models.CharField(blank=True, max_length=255,
                                         null=True)),
                ('requestor_rating',
                 models.DecimalField(blank=True,
                                     decimal_places=1,
                                     max_digits=2,
                                     null=True)),
                ('project_subcategory',
                 models.CharField(blank=True, max_length=255, null=True)),
                ('pay_status',
                 models.IntegerField(blank=True,
                                     choices=[(1, 'P - PAID'),
                                              (2, 'U - UNPAID')],
                                     null=True)),
                ('project_status',
                 models.IntegerField(blank=True,
                                     choices=[(0, 'P - PENDING'),
                                              (1, 'O - OPEN'),
                                              (2, 'F - FILLED'),
                                              (3, 'C - CLOSED '),
                                              (4, 'S- STARTED'),
                                              (5, 'E- ENDED'),
                                              (6, 'A - APPROVED'),
                                              (7, 'R - RATED')],
                                     default=0,
                                     null=True)),
            ],
            options={
                'verbose_name': 'Project',
                'verbose_name_plural': 'Projects',
                'db_table': 'Project',
                'managed': True,
            },
        ),
        migrations.CreateModel(
            name='Requestor',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('created_at',
                 models.DateTimeField(
                     auto_now_add=True,
                     help_text='Auto added at the time of creation only.',
                     null=True,
                     verbose_name='Created Date')),
                ('updated_at',
                 models.DateTimeField(
                     auto_now=True,
                     help_text='Auto added everytime model is updated.',
                     null=True,
                     verbose_name='Updated Date')),
                ('company_name',
                 models.CharField(blank=True,
                                  help_text="Requestor's Company name ",
                                  max_length=255,
                                  null=True,
                                  verbose_name='Company_name')),
                ('company_location',
                 models.TextField(blank=True,
                                  help_text="Requestor's Company Address",
                                  null=True,
                                  verbose_name='Company_location')),
                ('postal_code',
                 models.CharField(blank=True,
                                  help_text='Pin Code',
                                  max_length=255,
                                  null=True,
                                  verbose_name='Postal_code')),
                ('company_description',
                 models.TextField(blank=True,
                                  help_text='Company Description',
                                  null=True,
                                  verbose_name='Company_description')),
                ('company_website',
                 models.CharField(blank=True,
                                  help_text='Company Website',
                                  max_length=255,
                                  null=True,
                                  verbose_name='Company_website')),
                ('company_type',
                 models.IntegerField(blank=True,
                                     choices=[
                                         (1, 'Private Limited Company'),
                                         (2, 'Partnership'),
                                         (3, 'Limited Liability Partnership'),
                                         (4, 'Proprietorship'),
                                         (5, 'One Person Company'),
                                         (6, 'Section 8 Company')
                                     ],
                                     help_text='Company type of User',
                                     null=True,
                                     verbose_name='company_type')),
                ('designation',
                 models.CharField(blank=True,
                                  help_text='Designation of Requestor',
                                  max_length=255,
                                  null=True,
                                  verbose_name='Requestor_designation')),
                ('linkedin_profile',
                 models.URLField(blank=True,
                                 help_text='Requestor Linkedin Profile',
                                 max_length=255,
                                 null=True,
                                 verbose_name='Requestor_linkedin')),
                ('is_valid',
                 models.BooleanField(
                     default=False,
                     help_text='Is Requestor verified by the admin')),
            ],
            options={
                'verbose_name': 'Requestor',
                'verbose_name_plural': 'Requestors',
                'db_table': 'Requestor',
                'managed': True,
            },
        ),
        migrations.CreateModel(
            name='Skills',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('created_at',
                 models.DateTimeField(
                     auto_now_add=True,
                     help_text='Auto added at the time of creation only.',
                     null=True,
                     verbose_name='Created Date')),
                ('updated_at',
                 models.DateTimeField(
                     auto_now=True,
                     help_text='Auto added everytime model is updated.',
                     null=True,
                     verbose_name='Updated Date')),
                ('skill_name',
                 models.CharField(blank=True,
                                  max_length=255,
                                  null=True,
                                  verbose_name='Skill')),
            ],
            options={
                'verbose_name': 'Skill',
                'verbose_name_plural': 'Skills',
                'db_table': 'Skills',
                'managed': True,
            },
        ),
        migrations.CreateModel(
            name='UserDevices',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('mac_address',
                 models.CharField(max_length=255, verbose_name='mac_address')),
                ('platform',
                 models.IntegerField(blank=True,
                                     choices=[(1, 'A- Android'),
                                              (2, 'I- IOS')],
                                     null=True,
                                     verbose_name='Platform')),
                ('version',
                 models.CharField(blank=True,
                                  max_length=255,
                                  null=True,
                                  verbose_name='version')),
                ('device_id',
                 models.BigIntegerField(default=1, verbose_name='device_id')),
                ('registration_source',
                 models.IntegerField(
                     blank=True,
                     choices=[(1, 'PLAYSTORE - Android Playstore source'),
                              (2, 'APPSTORE - Apple App Store'),
                              (3, 'ADMIN- Added to the system by the Admin')],
                     null=True,
                     verbose_name='registration_source')),
            ],
            options={
                'verbose_name': 'User Device',
                'verbose_name_plural': 'User Devices',
                'db_table': 'user_devices',
                'managed': True,
            },
        ),
        migrations.CreateModel(
            name='Gigster',
            fields=[
                ('created_at',
                 models.DateTimeField(
                     auto_now_add=True,
                     help_text='Auto added at the time of creation only.',
                     null=True,
                     verbose_name='Created Date')),
                ('updated_at',
                 models.DateTimeField(
                     auto_now=True,
                     help_text='Auto added everytime model is updated.',
                     null=True,
                     verbose_name='Updated Date')),
                ('gigster',
                 models.OneToOneField(
                     on_delete=django.db.models.deletion.CASCADE,
                     primary_key=True,
                     serialize=False,
                     to=settings.AUTH_USER_MODEL)),
                ('vehicles_owned',
                 models.IntegerField(blank=True,
                                     choices=[(1, 'B - BIKE'),
                                              (2, 'S - SCOOTY'),
                                              (3, 'C - CAR')],
                                     null=True)),
                ('dob', models.DateField(blank=True, null=True)),
                ('bio',
                 models.TextField(blank=True,
                                  help_text="Gigster's bio",
                                  null=True)),
                ('aadhar_front',
                 models.ImageField(blank=True,
                                   null=True,
                                   upload_to=core.models.upload_aadhar_front)),
                ('aadhar_back',
                 models.ImageField(blank=True,
                                   null=True,
                                   upload_to=core.models.upload_aadhar_back)),
                ('pan_card',
                 models.ImageField(blank=True,
                                   null=True,
                                   upload_to=core.models.upload_pan_card)),
                ('profile_photo',
                 models.ImageField(
                     blank=True,
                     null=True,
                     upload_to=core.models.upload_gigster_profile_photo)),
                ('driving_licence',
                 models.ImageField(
                     blank=True,
                     null=True,
                     upload_to=core.models.upload_driving_licence)),
                ('rating',
                 models.FloatField(blank=True,
                                   help_text='Gigster overall Rating',
                                   null=True,
                                   verbose_name='Gigster Rating')),
            ],
            options={
                'verbose_name': 'Gigster',
                'verbose_name_plural': 'Gigsters',
                'db_table': 'Gigster',
                'managed': True,
            },
        ),
        migrations.AddField(
            model_name='userdevices',
            name='user',
            field=models.ForeignKey(
                default=1,
                on_delete=django.db.models.deletion.CASCADE,
                to=settings.AUTH_USER_MODEL),
        ),
        migrations.AddField(
            model_name='requestor',
            name='user',
            field=models.OneToOneField(
                help_text='Instance of User Model',
                on_delete=django.db.models.deletion.CASCADE,
                related_name='user',
                to=settings.AUTH_USER_MODEL),
        ),
        migrations.AddField(
            model_name='project',
            name='requestor',
            field=models.ForeignKey(
                default=1,
                on_delete=django.db.models.deletion.CASCADE,
                to='core.Requestor'),
        ),
        migrations.AddField(
            model_name='gigsterskills',
            name='skill',
            field=models.ForeignKey(
                default=1,
                on_delete=django.db.models.deletion.CASCADE,
                to='core.Skills'),
        ),
        migrations.AddField(
            model_name='gigsterproject',
            name='project',
            field=models.ForeignKey(
                default=1,
                on_delete=django.db.models.deletion.CASCADE,
                to='core.Project'),
        ),
        migrations.AddField(
            model_name='gigsterskills',
            name='gigster',
            field=models.ForeignKey(
                default=1,
                on_delete=django.db.models.deletion.CASCADE,
                to='core.Gigster'),
        ),
        migrations.AddField(
            model_name='gigsterproject',
            name='gigster',
            field=models.ForeignKey(
                default=1,
                on_delete=django.db.models.deletion.CASCADE,
                to='core.Gigster'),
        ),
        migrations.AddField(
            model_name='gigster',
            name='skills',
            field=models.ManyToManyField(through='core.GigsterSkills',
                                         to='core.Skills'),
        ),
    ]
Пример #11
0
class Migration(migrations.Migration):

    initial = True

    dependencies = []

    operations = [
        migrations.CreateModel(
            name='BlackListFile',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('file',
                 models.FileField(upload_to=core.models.get_black_list_path,
                                  verbose_name='\u6587\u4ef6')),
                ('size',
                 models.BigIntegerField(default=0,
                                        verbose_name='\u5927\u5c0f')),
                ('remark',
                 models.CharField(blank=True,
                                  max_length=255,
                                  null=True,
                                  verbose_name='\u5907\u6ce8')),
            ],
            options={
                'verbose_name': '\u9ed1\u540d\u5355',
                'verbose_name_plural': '\u9ed1\u540d\u5355',
            },
        ),
        migrations.CreateModel(
            name='Job',
            fields=[
                ('id',
                 models.CharField(default=core.models.gen_job_id,
                                  max_length=32,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('name',
                 models.CharField(default='\u626b\u63cf\u4efb\u52a1',
                                  max_length=30,
                                  verbose_name='\u4efb\u52a1\u540d\u79f0')),
                ('port',
                 models.IntegerField(verbose_name='\u626b\u63cf\u7aef\u53e3')),
                ('bandwidth',
                 models.IntegerField(default=100,
                                     verbose_name='\u5e26\u5bbd')),
                ('priority',
                 models.IntegerField(choices=[(0, '\u4f4e'), (1, '\u4e2d'),
                                              (2, '\u9ad8'),
                                              (3, '\u6781\u9ad8')],
                                     default=1,
                                     verbose_name='\u4f18\u5148\u7ea7')),
                ('output_path',
                 models.CharField(blank=True,
                                  max_length=255,
                                  null=True,
                                  verbose_name='\u8f93\u51fa\u6587\u4ef6')),
                ('log_path',
                 models.CharField(blank=True,
                                  max_length=255,
                                  null=True,
                                  verbose_name='\u65e5\u5fd7\u6587\u4ef6')),
                ('status',
                 models.IntegerField(choices=[(0, '\u7b49\u5f85\u6267\u884c'),
                                              (1, '\u6b63\u5728\u6267\u884c'),
                                              (2, '\u6267\u884c\u5b8c\u6210'),
                                              (3, '\u6267\u884c\u9519\u8bef')],
                                     default=0,
                                     verbose_name='\u72b6\u6001')),
                ('progress',
                 models.CharField(blank=True,
                                  max_length=3,
                                  null=True,
                                  verbose_name='\u6267\u884c\u8fdb\u5ea6')),
                ('left_time',
                 models.CharField(blank=True,
                                  max_length=15,
                                  null=True,
                                  verbose_name='\u5269\u4f59\u65f6\u95f4')),
                ('verbosity',
                 models.IntegerField(default=3,
                                     verbose_name='\u65e5\u5fd7\u7ea7\u522b')),
                ('creation_time',
                 models.DateTimeField(
                     default=django.utils.timezone.now,
                     verbose_name='\u521b\u5efa\u65f6\u95f4')),
                ('start_time',
                 models.DateTimeField(
                     blank=True,
                     null=True,
                     verbose_name='\u542f\u52a8\u65f6\u95f4')),
                ('end_time',
                 models.DateTimeField(
                     blank=True,
                     null=True,
                     verbose_name='\u7ed3\u675f\u65f6\u95f4')),
                ('hit_rate',
                 models.CharField(blank=True,
                                  max_length=10,
                                  null=True,
                                  verbose_name='\u547d\u4e2d\u7387')),
                ('remark',
                 models.CharField(blank=True,
                                  max_length=255,
                                  null=True,
                                  verbose_name='\u5907\u6ce8')),
                ('black_list_file',
                 models.ForeignKey(blank=True,
                                   null=True,
                                   on_delete=django.db.models.deletion.CASCADE,
                                   to='core.BlackListFile',
                                   verbose_name='\u9ed1\u540d\u5355')),
            ],
            options={
                'verbose_name': '\u4efb\u52a1',
                'verbose_name_plural': '\u4efb\u52a1',
            },
        ),
        migrations.CreateModel(
            name='WhiteListFile',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('file',
                 models.FileField(upload_to=core.models.get_white_list_path,
                                  verbose_name='\u6587\u4ef6')),
                ('size',
                 models.BigIntegerField(default=0,
                                        verbose_name='\u5927\u5c0f')),
                ('remark',
                 models.CharField(blank=True,
                                  max_length=255,
                                  null=True,
                                  verbose_name='\u5907\u6ce8')),
            ],
            options={
                'verbose_name': '\u767d\u540d\u5355',
                'verbose_name_plural': '\u767d\u540d\u5355',
            },
        ),
        migrations.AddField(
            model_name='job',
            name='white_list_file',
            field=models.ForeignKey(
                blank=True,
                null=True,
                on_delete=django.db.models.deletion.CASCADE,
                to='core.WhiteListFile',
                verbose_name='\u767d\u540d\u5355'),
        ),
    ]