class Migration(migrations.Migration):

    dependencies = [
        ('common', '0015_auto_20191122_1919'),
    ]

    operations = [
        migrations.AlterField(
            model_name='issue',
            name='published',
            field=models.BooleanField(default=False, help_text='If base information are currently public. (can be altered manually and by state changes)', verbose_name='published'),
        ),
        migrations.AlterField(
            model_name='issue',
            name='status',
            field=models.IntegerField(choices=[(1, 'SUBMITTED'), (2, 'WIP'), (3, 'SOLVED'), (4, 'IMPOSSIBLE'), (5, 'DUBLICATE')], default=common.models.StatusTypes(1), help_text='Stage of progress for the solution.', verbose_name='status'),
        ),
        migrations.CreateModel(
            name='Comment',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('author', models.CharField(help_text='Who wrote the content.', max_length=150, verbose_name='author')),
                ('created_at', models.DateTimeField(default=django.utils.timezone.now, help_text='When was the contet written.', verbose_name='creation date')),
                ('content', models.TextField(help_text='Text of the comment', max_length=500, verbose_name='content')),
                ('issue', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='common.Issue')),
            ],
        ),
    ]
Example #2
0
class Migration(migrations.Migration):

    dependencies = [
        ('kubeops_api', '0024_auto_20190927_0641'),
    ]

    operations = [
        migrations.AddField(
            model_name='host',
            name='auto_gather_info',
            field=models.BooleanField(default=True, null=True),
        ),
        migrations.AlterField(
            model_name='host',
            name='password',
            field=common.models.EncryptCharField(blank=True,
                                                 default='KubeOperator@2019',
                                                 max_length=4096,
                                                 null=True),
        ),
        migrations.AlterField(
            model_name='host',
            name='status',
            field=models.CharField(choices=[('VALID', 'valid'),
                                            ('INVALID', 'invalid'),
                                            ('CREATING', 'creating'),
                                            ('UNKNOWN', 'unknown')],
                                   default='UNKNOWN',
                                   max_length=128),
        ),
    ]
Example #3
0
class Migration(migrations.Migration):

    initial = True

    dependencies = [
        ('media_upload', '0001_initial'),
        migrations.swappable_dependency(settings.AUTH_USER_MODEL),
    ]

    operations = [
        migrations.CreateModel(
            name='Merchant',
            fields=[
                ('id',
                 common.models.ULIDField(default=ulid.api.new,
                                         editable=False,
                                         max_length=26,
                                         primary_key=True,
                                         serialize=False,
                                         unique=True)),
                ('created_time',
                 models.DateTimeField(auto_now_add=True,
                                      verbose_name='created time')),
                ('updated_time',
                 models.DateTimeField(auto_now=True,
                                      verbose_name='updated time')),
                ('deleted',
                 models.BooleanField(default=False, verbose_name='deleted')),
                ('name',
                 models.CharField(max_length=30,
                                  verbose_name='merchant name')),
                ('is_active',
                 models.BooleanField(default=True, verbose_name='is active')),
                ('accounts',
                 models.ManyToManyField(to=settings.AUTH_USER_MODEL)),
                ('icon',
                 models.ForeignKey(blank=True,
                                   null=True,
                                   on_delete=django.db.models.deletion.PROTECT,
                                   to='media_upload.Image',
                                   verbose_name='icon')),
            ],
            options={
                'abstract': False,
            },
        ),
    ]
Example #4
0
class Migration(migrations.Migration):

    initial = True

    dependencies = []

    operations = [
        migrations.CreateModel(
            name='Member',
            fields=[
                ('guid',
                 models.CharField(default=uuid.uuid4,
                                  max_length=255,
                                  primary_key=True,
                                  serialize=False)),
                ('student_id', models.CharField(max_length=9)),
                ('avatar', models.URLField(blank=True)),
                ('year',
                 models.CharField(blank=True,
                                  choices=[(73, 73), (74, 74), (75, 75),
                                           (76, 76), (77, 77), (78, 78),
                                           (79, 79), (80, 80), (81, 81),
                                           (82, 82), (83, 83), (84, 84),
                                           (85, 85), (86, 86), (87, 87),
                                           (88, 88), (89, 89), (90, 90),
                                           (91, 91), (92, 92), (93, 93),
                                           (94, 94), (95, 95), (96, 96),
                                           (97, 97), (98, 98), (99, 99),
                                           (100, 100), (101, 101), (102, 102),
                                           (103, 103), (104, 104), (105, 105),
                                           (106, 106), (107, 107), (108, 108),
                                           (109, 109)],
                                  default=109,
                                  max_length=3)),
                ('name', models.CharField(max_length=31)),
                ('foreign_name',
                 models.CharField(blank=True, max_length=31, null=True)),
                ('hobby', models.CharField(max_length=127)),
                ('expertise', models.CharField(max_length=127)),
                ('constellation', models.CharField(max_length=31)),
                ('link', models.URLField(blank=True)),
                ('email', models.EmailField(blank=True, max_length=254)),
                ('education',
                 models.CharField(choices=[('Master', 'Master'),
                                           ('Ph.D.', 'Ph.D.'),
                                           ('EMBA', 'EMBA'), ('EDBA', 'EDBA'),
                                           ('Professor', 'Professor')],
                                  default='Master',
                                  max_length=15)),
                ('is_graduated',
                 models.BooleanField(choices=[(True, True), (False, False)],
                                     default=False)),
            ],
            bases=(common.models.BaseSheet, models.Model),
        ),
    ]
Example #5
0
class Migration(migrations.Migration):

    initial = True

    dependencies = [
        ('auth', '0009_alter_user_last_name_max_length'),
        ('media_upload', '0001_initial'),
    ]

    operations = [
        migrations.CreateModel(
            name='Account',
            fields=[
                ('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')),
                ('id', common.models.ULIDField(default=ulid.api.new, editable=False, max_length=26, primary_key=True, serialize=False, unique=True)),
                ('username', models.CharField(error_messages={'unique': 'A user with that username already exists.'}, max_length=150, unique=True, validators=[django.contrib.auth.validators.UnicodeUsernameValidator()], verbose_name='username')),
                ('email', models.EmailField(error_messages={'unique': 'A user with that email already exists.'}, max_length=254, unique=True, verbose_name='email address')),
                ('display_name', models.CharField(blank=True, max_length=30, null=True, verbose_name='display name')),
                ('is_staff', models.BooleanField(default=False, verbose_name='staff status')),
                ('is_active', models.BooleanField(default=True, verbose_name='active')),
                ('date_joined', models.DateTimeField(default=django.utils.timezone.now, verbose_name='date joined')),
                ('balance', models.IntegerField(default=0, verbose_name='balance')),
                ('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')),
                ('icon', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.PROTECT, to='media_upload.Image', verbose_name='icon')),
                ('user_permissions', models.ManyToManyField(blank=True, help_text='Specific permissions for this user.', related_name='user_set', related_query_name='user', to='auth.Permission', verbose_name='user permissions')),
            ],
            options={
                'verbose_name': 'user',
                'verbose_name_plural': 'users',
            },
        ),
        migrations.CreateModel(
            name='Idm',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('idm', models.CharField(error_messages={'unique': 'This card is already registered'}, max_length=16, unique=True, verbose_name='IDm Number')),
                ('name', models.CharField(blank=True, max_length=255, null=True, verbose_name='card name')),
                ('account', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL, verbose_name='account')),
            ],
        ),
    ]
Example #6
0
class Migration(migrations.Migration):

    initial = True

    dependencies = []

    operations = [
        migrations.CreateModel(
            name='Currency',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('name', common.models.NameField(max_length=150, unique=True)),
                ('base_price',
                 models.DecimalField(
                     decimal_places=5,
                     max_digits=20,
                     validators=[
                         django.core.validators.MinValueValidator(
                             0, 'Prices must be positive')
                     ])),
                ('imutable', models.BooleanField(default=False)),
            ],
        ),
        migrations.CreateModel(
            name='CurrencyPriceChange',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('date', models.DateField()),
                ('new_price',
                 models.DecimalField(
                     decimal_places=5,
                     max_digits=20,
                     validators=[
                         django.core.validators.MinValueValidator(
                             0, 'Prices must be positive')
                     ])),
                ('currency',
                 models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
                                   to='currencies.Currency')),
            ],
        ),
        migrations.AlterUniqueTogether(
            name='currencypricechange',
            unique_together={('date', 'currency')},
        ),
    ]
Example #7
0
class Migration(migrations.Migration):

    initial = True

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

    operations = [
        migrations.CreateModel(
            name='Dictionary',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('modified_at', models.DateTimeField(auto_now_add=True)),
                ('deleted', models.BooleanField(default=False,
                                                editable=False)),
                ('entry', models.CharField(max_length=200)),
                ('key', models.CharField(max_length=200)),
                ('value', models.CharField(max_length=500)),
                ('created_by',
                 models.ForeignKey(
                     on_delete=models.SET(
                         common.models.UserUtils.get_recycle_user),
                     related_name='dictionary_dictionary_created_related',
                     related_query_name='dictionary_dictionarys_created',
                     to=settings.AUTH_USER_MODEL)),
                ('modified_by',
                 models.ForeignKey(
                     on_delete=models.SET(
                         common.models.UserUtils.get_recycle_user),
                     related_name='dictionary_dictionary_modified_related',
                     related_query_name='dictionary_dictionarys_modified',
                     to=settings.AUTH_USER_MODEL)),
                ('owner',
                 models.ForeignKey(
                     on_delete=models.SET(
                         common.models.UserUtils.get_recycle_user),
                     related_name='dictionary_dictionary_owner_related',
                     related_query_name='dictionary_dictionarys_owner',
                     to=settings.AUTH_USER_MODEL)),
            ],
            options={
                'db_table': 'dictionary',
            },
        ),
    ]
Example #8
0
class Migration(migrations.Migration):

    initial = True

    dependencies = [
        ('auth', '0008_alter_user_username_max_length'),
    ]

    operations = [
        migrations.CreateModel(
            name='CustomUser',
            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')),
                ('first_name', models.CharField(blank=True, max_length=30, verbose_name='first name')),
                ('last_name', models.CharField(blank=True, max_length=30, verbose_name='last name')),
                ('is_staff', models.BooleanField(default=False, help_text='Designates whether the user can log into this admin site.', verbose_name='staff status')),
                ('is_active', models.BooleanField(default=True, help_text='Designates whether this user should be treated as active. Unselect this instead of deleting accounts.', verbose_name='active')),
                ('date_joined', models.DateTimeField(default=django.utils.timezone.now, verbose_name='date joined')),
                ('email', models.EmailField(max_length=254, unique=True, verbose_name='email address')),
                ('birthday', models.DateField(blank=True, null=True)),
                ('country', models.CharField(blank=True, max_length=16)),
                ('city', models.CharField(blank=True, max_length=16)),
                ('groups', models.ManyToManyField(blank=True, help_text='The groups this user belongs to. A user will get all permissions granted to each of their groups.', related_name='user_set', related_query_name='user', to='auth.Group', verbose_name='groups')),
                ('user_permissions', models.ManyToManyField(blank=True, help_text='Specific permissions for this user.', related_name='user_set', related_query_name='user', to='auth.Permission', verbose_name='user permissions')),
            ],
            options={
                'verbose_name': 'user',
                'abstract': False,
                'verbose_name_plural': 'users',
            },
            managers=[
                ('objects', common.models.CustomUserManager()),
            ],
        ),
    ]
Example #9
0
class Migration(migrations.Migration):

    initial = True

    dependencies = [
        ('merchants', '0001_initial'),
        migrations.swappable_dependency(settings.AUTH_USER_MODEL),
    ]

    operations = [
        migrations.CreateModel(
            name='Checkout',
            fields=[
                ('id',
                 common.models.ULIDField(default=ulid.api.new,
                                         editable=False,
                                         max_length=26,
                                         primary_key=True,
                                         serialize=False,
                                         unique=True)),
                ('created_time',
                 models.DateTimeField(auto_now_add=True,
                                      verbose_name='created time')),
                ('updated_time',
                 models.DateTimeField(auto_now=True,
                                      verbose_name='updated time')),
                ('deleted',
                 models.BooleanField(default=False, verbose_name='deleted')),
                ('amount', models.IntegerField(verbose_name='amount')),
                ('payment_method',
                 models.IntegerField(choices=[(0, 'FeliCa Card'),
                                              (1, 'QR Code')],
                                     verbose_name='payment method')),
                ('merchant',
                 models.ForeignKey(on_delete=django.db.models.deletion.PROTECT,
                                   to='merchants.Merchant')),
                ('purchaser',
                 models.ForeignKey(on_delete=django.db.models.deletion.PROTECT,
                                   to=settings.AUTH_USER_MODEL)),
            ],
            options={
                'abstract': False,
            },
        ),
    ]
Example #10
0
class Migration(migrations.Migration):

    dependencies = [
        ('common', '0014_auto_20191116_0715'),
    ]

    operations = [
        migrations.AddField(
            model_name='issue',
            name='published',
            field=models.BooleanField(default=False, help_text='If base information are currently public.', verbose_name='published'),
        ),
        migrations.AlterField(
            model_name='issue',
            name='status',
            field=models.IntegerField(choices=[(1, 'SUBMITTED'), (2, 'WIP'), (3, 'SOLVED'), (4, 'IMPOSSIBLE'), (5, 'DUBLICATE')], default=common.models.StatusTypes(1), help_text='Stage of progress for the solution. (can be altered manually and by state changes)', verbose_name='status'),
        ),
    ]
Example #11
0
class Migration(migrations.Migration):

    initial = True

    dependencies = []

    operations = [
        migrations.CreateModel(
            name='Image',
            fields=[
                ('id',
                 common.models.ULIDField(default=ulid.api.new,
                                         editable=False,
                                         max_length=26,
                                         primary_key=True,
                                         serialize=False,
                                         unique=True)),
                ('created_time',
                 models.DateTimeField(auto_now_add=True,
                                      verbose_name='created time')),
                ('updated_time',
                 models.DateTimeField(auto_now=True,
                                      verbose_name='updated time')),
                ('deleted',
                 models.BooleanField(default=False, verbose_name='deleted')),
                ('image',
                 models.ImageField(
                     height_field='height',
                     upload_to=media_upload.models.Image.get_image_path,
                     verbose_name='image',
                     width_field='width')),
                ('height', models.IntegerField(editable=False)),
                ('width', models.IntegerField(editable=False)),
            ],
            options={
                'abstract': False,
            },
        ),
    ]
Example #12
0
class Migration(migrations.Migration):

    initial = True

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

    operations = [
        migrations.CreateModel(
            name='User',
            fields=[
                ('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')),
                ('first_name',
                 models.CharField(blank=True,
                                  max_length=150,
                                  verbose_name='first name')),
                ('last_name',
                 models.CharField(blank=True,
                                  max_length=150,
                                  verbose_name='last name')),
                ('is_staff',
                 models.BooleanField(
                     default=False,
                     help_text=
                     'Designates whether the user can log into this admin site.',
                     verbose_name='staff status')),
                ('is_active',
                 models.BooleanField(
                     default=True,
                     help_text=
                     'Designates whether this user should be treated as active. Unselect this instead of deleting accounts.',
                     verbose_name='active')),
                ('date_joined',
                 models.DateTimeField(default=django.utils.timezone.now,
                                      verbose_name='date joined')),
                ('id',
                 models.UUIDField(default=uuid.uuid4,
                                  editable=False,
                                  primary_key=True,
                                  serialize=False)),
                ('created_on', models.DateTimeField(auto_now_add=True)),
                ('updated_on', models.DateTimeField(auto_now=True)),
                ('email', models.EmailField(max_length=254, unique=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={
                'verbose_name': 'user',
                'verbose_name_plural': 'users',
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='UserAction',
            fields=[
                ('id',
                 models.UUIDField(default=uuid.uuid4,
                                  editable=False,
                                  primary_key=True,
                                  serialize=False)),
                ('created_on', models.DateTimeField(auto_now_add=True)),
                ('updated_on', models.DateTimeField(auto_now=True)),
                ('url', models.URLField(max_length=2083)),
                ('method', models.CharField(max_length=64)),
                ('url_name', models.CharField(max_length=256, null=True)),
                ('status_code', models.IntegerField()),
                ('user_agent', models.TextField(null=True)),
                ('user',
                 models.ForeignKey(on_delete=django.db.models.deletion.PROTECT,
                                   related_name='user_actions',
                                   to=settings.AUTH_USER_MODEL)),
            ],
            options={
                'abstract': False,
            },
        ),
    ]
Example #13
0
class Migration(migrations.Migration):

    initial = True

    dependencies = [
        ('dictionary', '0001_initial'),
        migrations.swappable_dependency(settings.AUTH_USER_MODEL),
    ]

    operations = [
        migrations.CreateModel(
            name='Security',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('modified_at', models.DateTimeField(auto_now_add=True)),
                ('deleted', models.BooleanField(default=False,
                                                editable=False)),
                ('code', models.CharField(max_length=20)),
                ('name', models.CharField(max_length=40)),
                ('short_name', models.CharField(max_length=20)),
                ('industry', models.CharField(max_length=20)),
                ('area', models.CharField(max_length=20)),
                ('created_by',
                 models.ForeignKey(
                     on_delete=models.SET(
                         common.models.UserUtils.get_recycle_user),
                     related_name='security_security_created_related',
                     related_query_name='security_securitys_created',
                     to=settings.AUTH_USER_MODEL)),
                ('exchange',
                 models.ForeignKey(on_delete=django.db.models.deletion.PROTECT,
                                   to='dictionary.Exchange')),
                ('modified_by',
                 models.ForeignKey(
                     on_delete=models.SET(
                         common.models.UserUtils.get_recycle_user),
                     related_name='security_security_modified_related',
                     related_query_name='security_securitys_modified',
                     to=settings.AUTH_USER_MODEL)),
                ('owner',
                 models.ForeignKey(
                     on_delete=models.SET(
                         common.models.UserUtils.get_recycle_user),
                     related_name='security_security_owner_related',
                     related_query_name='security_securitys_owner',
                     to=settings.AUTH_USER_MODEL)),
                ('type',
                 models.ForeignKey(on_delete=django.db.models.deletion.PROTECT,
                                   to='dictionary.SecurityType')),
            ],
            options={
                'verbose_name': 'security',
                'verbose_name_plural': 'securities',
                'db_table': 'security',
            },
        ),
    ]
Example #14
0
class Migration(migrations.Migration):

    initial = True

    dependencies = [
        ('auth', '0009_alter_user_last_name_max_length'),
    ]

    operations = [
        migrations.CreateModel(
            name='User',
            fields=[
                ('password',
                 models.CharField(max_length=128, verbose_name='password')),
                ('last_login',
                 models.DateTimeField(blank=True,
                                      null=True,
                                      verbose_name='last login')),
                ('is_superuser',
                 models.BooleanField(
                     default=False,
                     help_text=
                     'Designates that this user has all permissions without explicitly assigning them.',
                     verbose_name='superuser status')),
                ('username',
                 models.CharField(
                     error_messages={
                         'unique': 'A user with that username already exists.'
                     },
                     help_text=
                     'Required. 150 characters or fewer. Letters, digits and @/./+/-/_ only.',
                     max_length=150,
                     unique=True,
                     validators=[
                         django.contrib.auth.validators.
                         UnicodeUsernameValidator()
                     ],
                     verbose_name='username')),
                ('first_name',
                 models.CharField(blank=True,
                                  max_length=30,
                                  verbose_name='first name')),
                ('last_name',
                 models.CharField(blank=True,
                                  max_length=150,
                                  verbose_name='last name')),
                ('email',
                 models.EmailField(blank=True,
                                   max_length=254,
                                   verbose_name='email address')),
                ('is_staff',
                 models.BooleanField(
                     default=False,
                     help_text=
                     'Designates whether the user can log into this admin site.',
                     verbose_name='staff status')),
                ('is_active',
                 models.BooleanField(
                     default=True,
                     help_text=
                     'Designates whether this user should be treated as active. Unselect this instead of deleting accounts.',
                     verbose_name='active')),
                ('date_joined',
                 models.DateTimeField(default=django.utils.timezone.now,
                                      verbose_name='date joined')),
                ('id', models.BigAutoField(primary_key=True, serialize=False)),
                ('created',
                 models.DateTimeField(default=django.utils.timezone.now)),
                ('updated',
                 models.DateTimeField(default=django.utils.timezone.now)),
                ('enabled', models.BooleanField(default=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,
            },
            managers=[
                ('objects', django.contrib.auth.models.UserManager()),
            ],
        ),
        migrations.CreateModel(
            name='Application',
            fields=[
                ('id', models.BigAutoField(primary_key=True, serialize=False)),
                ('created',
                 models.DateTimeField(default=django.utils.timezone.now)),
                ('updated',
                 models.DateTimeField(default=django.utils.timezone.now)),
                ('enabled', models.BooleanField(default=True)),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='Token',
            fields=[
                ('id', models.BigAutoField(primary_key=True, serialize=False)),
                ('created',
                 models.DateTimeField(default=django.utils.timezone.now)),
                ('updated',
                 models.DateTimeField(default=django.utils.timezone.now)),
                ('enabled', models.BooleanField(default=True)),
                ('expires',
                 models.DateTimeField(default=common.models.get_expiration)),
                ('value', models.CharField(max_length=255)),
                ('application',
                 models.ForeignKey(on_delete=django.db.models.deletion.PROTECT,
                                   to='common.Application')),
                ('owner',
                 models.ForeignKey(on_delete=django.db.models.deletion.PROTECT,
                                   to=settings.AUTH_USER_MODEL)),
            ],
            options={
                'abstract': False,
            },
        ),
    ]
Example #15
0
class Migration(migrations.Migration):

    initial = True

    dependencies = [
        ("accounts", "0001_initial"),
        ("cases", "0001_initial"),
    ]

    operations = [
        migrations.CreateModel(
            name="User",
            fields=[
                (
                    "id",
                    models.AutoField(
                        auto_created=True,
                        primary_key=True,
                        serialize=False,
                        verbose_name="ID",
                    ),
                ),
                ("password",
                 models.CharField(max_length=128, verbose_name="password")),
                (
                    "last_login",
                    models.DateTimeField(blank=True,
                                         null=True,
                                         verbose_name="last login"),
                ),
                (
                    "is_superuser",
                    models.BooleanField(
                        default=False,
                        help_text=
                        "Designates that this user has all permissions without explicitly assigning them.",
                        verbose_name="superuser status",
                    ),
                ),
                ("username", models.CharField(max_length=100, unique=True)),
                ("first_name", models.CharField(blank=True, max_length=150)),
                ("last_name", models.CharField(blank=True, max_length=150)),
                ("email", models.EmailField(max_length=255, unique=True)),
                ("is_active", models.BooleanField(default=True)),
                ("is_admin", models.BooleanField(default=False)),
                ("is_staff", models.BooleanField(default=False)),
                (
                    "date_joined",
                    models.DateTimeField(auto_now_add=True,
                                         verbose_name="date joined"),
                ),
                (
                    "role",
                    models.CharField(choices=[("ADMIN", "ADMIN"),
                                              ("USER", "USER")],
                                     max_length=50),
                ),
                (
                    "profile_pic",
                    models.FileField(
                        blank=True,
                        max_length=1000,
                        null=True,
                        upload_to=common.models.img_url,
                    ),
                ),
            ],
            options={
                "abstract": False,
            },
            managers=[
                ("objects", django.contrib.auth.models.UserManager()),
            ],
        ),
        migrations.CreateModel(
            name="Address",
            fields=[
                (
                    "id",
                    models.AutoField(
                        auto_created=True,
                        primary_key=True,
                        serialize=False,
                        verbose_name="ID",
                    ),
                ),
                (
                    "address_line",
                    models.CharField(blank=True,
                                     max_length=255,
                                     null=True,
                                     verbose_name="Address"),
                ),
                (
                    "street",
                    models.CharField(blank=True,
                                     max_length=55,
                                     null=True,
                                     verbose_name="Street"),
                ),
                (
                    "city",
                    models.CharField(blank=True,
                                     max_length=255,
                                     null=True,
                                     verbose_name="City"),
                ),
                (
                    "state",
                    models.CharField(blank=True,
                                     max_length=255,
                                     null=True,
                                     verbose_name="State"),
                ),
                (
                    "postcode",
                    models.CharField(
                        blank=True,
                        max_length=64,
                        null=True,
                        verbose_name="Post/Zip-code",
                    ),
                ),
                (
                    "country",
                    models.CharField(
                        blank=True,
                        choices=[
                            ("GB", "United Kingdom"),
                            ("AF", "Afghanistan"),
                            ("AX", "Aland Islands"),
                            ("AL", "Albania"),
                            ("DZ", "Algeria"),
                            ("AS", "American Samoa"),
                            ("AD", "Andorra"),
                            ("AO", "Angola"),
                            ("AI", "Anguilla"),
                            ("AQ", "Antarctica"),
                            ("AG", "Antigua and Barbuda"),
                            ("AR", "Argentina"),
                            ("AM", "Armenia"),
                            ("AW", "Aruba"),
                            ("AU", "Australia"),
                            ("AT", "Austria"),
                            ("AZ", "Azerbaijan"),
                            ("BS", "Bahamas"),
                            ("BH", "Bahrain"),
                            ("BD", "Bangladesh"),
                            ("BB", "Barbados"),
                            ("BY", "Belarus"),
                            ("BE", "Belgium"),
                            ("BZ", "Belize"),
                            ("BJ", "Benin"),
                            ("BM", "Bermuda"),
                            ("BT", "Bhutan"),
                            ("BO", "Bolivia"),
                            ("BA", "Bosnia and Herzegovina"),
                            ("BW", "Botswana"),
                            ("BV", "Bouvet Island"),
                            ("BR", "Brazil"),
                            ("IO", "British Indian Ocean Territory"),
                            ("BN", "Brunei Darussalam"),
                            ("BG", "Bulgaria"),
                            ("BF", "Burkina Faso"),
                            ("BI", "Burundi"),
                            ("KH", "Cambodia"),
                            ("CM", "Cameroon"),
                            ("CA", "Canada"),
                            ("CV", "Cape Verde"),
                            ("KY", "Cayman Islands"),
                            ("CF", "Central African Republic"),
                            ("TD", "Chad"),
                            ("CL", "Chile"),
                            ("CN", "China"),
                            ("CX", "Christmas Island"),
                            ("CC", "Cocos (Keeling) Islands"),
                            ("CO", "Colombia"),
                            ("KM", "Comoros"),
                            ("CG", "Congo"),
                            ("CD", "Congo, The Democratic Republic of the"),
                            ("CK", "Cook Islands"),
                            ("CR", "Costa Rica"),
                            ("CI", "Cote d'Ivoire"),
                            ("HR", "Croatia"),
                            ("CU", "Cuba"),
                            ("CY", "Cyprus"),
                            ("CZ", "Czech Republic"),
                            ("DK", "Denmark"),
                            ("DJ", "Djibouti"),
                            ("DM", "Dominica"),
                            ("DO", "Dominican Republic"),
                            ("EC", "Ecuador"),
                            ("EG", "Egypt"),
                            ("SV", "El Salvador"),
                            ("GQ", "Equatorial Guinea"),
                            ("ER", "Eritrea"),
                            ("EE", "Estonia"),
                            ("ET", "Ethiopia"),
                            ("FK", "Falkland Islands (Malvinas)"),
                            ("FO", "Faroe Islands"),
                            ("FJ", "Fiji"),
                            ("FI", "Finland"),
                            ("FR", "France"),
                            ("GF", "French Guiana"),
                            ("PF", "French Polynesia"),
                            ("TF", "French Southern Territories"),
                            ("GA", "Gabon"),
                            ("GM", "Gambia"),
                            ("GE", "Georgia"),
                            ("DE", "Germany"),
                            ("GH", "Ghana"),
                            ("GI", "Gibraltar"),
                            ("GR", "Greece"),
                            ("GL", "Greenland"),
                            ("GD", "Grenada"),
                            ("GP", "Guadeloupe"),
                            ("GU", "Guam"),
                            ("GT", "Guatemala"),
                            ("GG", "Guernsey"),
                            ("GN", "Guinea"),
                            ("GW", "Guinea-Bissau"),
                            ("GY", "Guyana"),
                            ("HT", "Haiti"),
                            ("HM", "Heard Island and McDonald Islands"),
                            ("VA", "Holy See (Vatican City State)"),
                            ("HN", "Honduras"),
                            ("HK", "Hong Kong"),
                            ("HU", "Hungary"),
                            ("IS", "Iceland"),
                            ("IN", "India"),
                            ("ID", "Indonesia"),
                            ("IR", "Iran, Islamic Republic of"),
                            ("IQ", "Iraq"),
                            ("IE", "Ireland"),
                            ("IM", "Isle of Man"),
                            ("IL", "Israel"),
                            ("IT", "Italy"),
                            ("JM", "Jamaica"),
                            ("JP", "Japan"),
                            ("JE", "Jersey"),
                            ("JO", "Jordan"),
                            ("KZ", "Kazakhstan"),
                            ("KE", "Kenya"),
                            ("KI", "Kiribati"),
                            ("KP", "Korea, Democratic People's Republic of"),
                            ("KR", "Korea, Republic of"),
                            ("KW", "Kuwait"),
                            ("KG", "Kyrgyzstan"),
                            ("LA", "Lao People's Democratic Republic"),
                            ("LV", "Latvia"),
                            ("LB", "Lebanon"),
                            ("LS", "Lesotho"),
                            ("LR", "Liberia"),
                            ("LY", "Libyan Arab Jamahiriya"),
                            ("LI", "Liechtenstein"),
                            ("LT", "Lithuania"),
                            ("LU", "Luxembourg"),
                            ("MO", "Macao"),
                            ("MK",
                             "Macedonia, The Former Yugoslav Republic of"),
                            ("MG", "Madagascar"),
                            ("MW", "Malawi"),
                            ("MY", "Malaysia"),
                            ("MV", "Maldives"),
                            ("ML", "Mali"),
                            ("MT", "Malta"),
                            ("MH", "Marshall Islands"),
                            ("MQ", "Martinique"),
                            ("MR", "Mauritania"),
                            ("MU", "Mauritius"),
                            ("YT", "Mayotte"),
                            ("MX", "Mexico"),
                            ("FM", "Micronesia, Federated States of"),
                            ("MD", "Moldova"),
                            ("MC", "Monaco"),
                            ("MN", "Mongolia"),
                            ("ME", "Montenegro"),
                            ("MS", "Montserrat"),
                            ("MA", "Morocco"),
                            ("MZ", "Mozambique"),
                            ("MM", "Myanmar"),
                            ("NA", "Namibia"),
                            ("NR", "Nauru"),
                            ("NP", "Nepal"),
                            ("NL", "Netherlands"),
                            ("AN", "Netherlands Antilles"),
                            ("NC", "New Caledonia"),
                            ("NZ", "New Zealand"),
                            ("NI", "Nicaragua"),
                            ("NE", "Niger"),
                            ("NG", "Nigeria"),
                            ("NU", "Niue"),
                            ("NF", "Norfolk Island"),
                            ("MP", "Northern Mariana Islands"),
                            ("NO", "Norway"),
                            ("OM", "Oman"),
                            ("PK", "Pakistan"),
                            ("PW", "Palau"),
                            ("PS", "Palestinian Territory, Occupied"),
                            ("PA", "Panama"),
                            ("PG", "Papua New Guinea"),
                            ("PY", "Paraguay"),
                            ("PE", "Peru"),
                            ("PH", "Philippines"),
                            ("PN", "Pitcairn"),
                            ("PL", "Poland"),
                            ("PT", "Portugal"),
                            ("PR", "Puerto Rico"),
                            ("QA", "Qatar"),
                            ("RE", "Reunion"),
                            ("RO", "Romania"),
                            ("RU", "Russian Federation"),
                            ("RW", "Rwanda"),
                            ("BL", "Saint Barthelemy"),
                            ("SH", "Saint Helena"),
                            ("KN", "Saint Kitts and Nevis"),
                            ("LC", "Saint Lucia"),
                            ("MF", "Saint Martin"),
                            ("PM", "Saint Pierre and Miquelon"),
                            ("VC", "Saint Vincent and the Grenadines"),
                            ("WS", "Samoa"),
                            ("SM", "San Marino"),
                            ("ST", "Sao Tome and Principe"),
                            ("SA", "Saudi Arabia"),
                            ("SN", "Senegal"),
                            ("RS", "Serbia"),
                            ("SC", "Seychelles"),
                            ("SL", "Sierra Leone"),
                            ("SG", "Singapore"),
                            ("SK", "Slovakia"),
                            ("SI", "Slovenia"),
                            ("SB", "Solomon Islands"),
                            ("SO", "Somalia"),
                            ("ZA", "South Africa"),
                            ("GS",
                             "South Georgia and the South Sandwich Islands"),
                            ("ES", "Spain"),
                            ("LK", "Sri Lanka"),
                            ("SD", "Sudan"),
                            ("SR", "Suriname"),
                            ("SJ", "Svalbard and Jan Mayen"),
                            ("SZ", "Swaziland"),
                            ("SE", "Sweden"),
                            ("CH", "Switzerland"),
                            ("SY", "Syrian Arab Republic"),
                            ("TW", "Taiwan, Province of China"),
                            ("TJ", "Tajikistan"),
                            ("TZ", "Tanzania, United Republic of"),
                            ("TH", "Thailand"),
                            ("TL", "Timor-Leste"),
                            ("TG", "Togo"),
                            ("TK", "Tokelau"),
                            ("TO", "Tonga"),
                            ("TT", "Trinidad and Tobago"),
                            ("TN", "Tunisia"),
                            ("TR", "Turkey"),
                            ("TM", "Turkmenistan"),
                            ("TC", "Turks and Caicos Islands"),
                            ("TV", "Tuvalu"),
                            ("UG", "Uganda"),
                            ("UA", "Ukraine"),
                            ("AE", "United Arab Emirates"),
                            ("US", "United States"),
                            ("UM", "United States Minor Outlying Islands"),
                            ("UY", "Uruguay"),
                            ("UZ", "Uzbekistan"),
                            ("VU", "Vanuatu"),
                            ("VE", "Venezuela"),
                            ("VN", "Viet Nam"),
                            ("VG", "Virgin Islands, British"),
                            ("VI", "Virgin Islands, U.S."),
                            ("WF", "Wallis and Futuna"),
                            ("EH", "Western Sahara"),
                            ("YE", "Yemen"),
                            ("ZM", "Zambia"),
                            ("ZW", "Zimbabwe"),
                        ],
                        max_length=3,
                        null=True,
                    ),
                ),
            ],
        ),
        migrations.CreateModel(
            name="Attachments",
            fields=[
                (
                    "id",
                    models.AutoField(
                        auto_created=True,
                        primary_key=True,
                        serialize=False,
                        verbose_name="ID",
                    ),
                ),
                ("file_name", models.CharField(max_length=60)),
                (
                    "created_on",
                    models.DateTimeField(auto_now_add=True,
                                         verbose_name="Created on"),
                ),
                (
                    "attachment",
                    models.FileField(max_length=1001,
                                     upload_to="attachments/%Y/%m/"),
                ),
            ],
        ),
        migrations.CreateModel(
            name="Comment",
            fields=[
                (
                    "id",
                    models.AutoField(
                        auto_created=True,
                        primary_key=True,
                        serialize=False,
                        verbose_name="ID",
                    ),
                ),
                ("comment", models.CharField(max_length=255)),
                ("commented_on", models.DateTimeField(auto_now_add=True)),
                (
                    "account",
                    models.ForeignKey(
                        blank=True,
                        null=True,
                        on_delete=django.db.models.deletion.CASCADE,
                        related_name="accounts_comments",
                        to="accounts.Account",
                    ),
                ),
                (
                    "case",
                    models.ForeignKey(
                        blank=True,
                        null=True,
                        on_delete=django.db.models.deletion.CASCADE,
                        related_name="cases",
                        to="cases.Case",
                    ),
                ),
                (
                    "commented_by",
                    models.ForeignKey(
                        blank=True,
                        null=True,
                        on_delete=django.db.models.deletion.CASCADE,
                        to=settings.AUTH_USER_MODEL,
                    ),
                ),
            ],
        ),
        migrations.CreateModel(
            name="Comment_Files",
            fields=[
                (
                    "id",
                    models.AutoField(
                        auto_created=True,
                        primary_key=True,
                        serialize=False,
                        verbose_name="ID",
                    ),
                ),
                ("updated_on", models.DateTimeField(auto_now_add=True)),
                (
                    "comment_file",
                    models.FileField(default="",
                                     upload_to="comment_files",
                                     verbose_name="File"),
                ),
                (
                    "comment",
                    models.ForeignKey(
                        on_delete=django.db.models.deletion.CASCADE,
                        to="common.Comment"),
                ),
            ],
        ),
        migrations.CreateModel(
            name="Team",
            fields=[
                (
                    "id",
                    models.AutoField(
                        auto_created=True,
                        primary_key=True,
                        serialize=False,
                        verbose_name="ID",
                    ),
                ),
                ("name", models.CharField(max_length=55)),
                ("members",
                 models.ManyToManyField(to=settings.AUTH_USER_MODEL)),
            ],
        ),
    ]
Example #16
0
class Migration(migrations.Migration):

    initial = True

    dependencies = [
        ('accounts', '0001_initial'),
        ('cases', '0001_initial'),
    ]

    operations = [
        migrations.CreateModel(
            name='User',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('password',
                 models.CharField(max_length=128, verbose_name='password')),
                ('last_login',
                 models.DateTimeField(blank=True,
                                      null=True,
                                      verbose_name='last login')),
                ('is_superuser',
                 models.BooleanField(
                     default=False,
                     help_text=
                     'Designates that this user has all permissions without explicitly assigning them.',
                     verbose_name='superuser status')),
                ('username', models.CharField(max_length=100, unique=True)),
                ('first_name', models.CharField(blank=True, max_length=150)),
                ('last_name', models.CharField(blank=True, max_length=150)),
                ('email', models.EmailField(max_length=255, unique=True)),
                ('is_active', models.BooleanField(default=True)),
                ('is_admin', models.BooleanField(default=False)),
                ('is_staff', models.BooleanField(default=False)),
                ('date_joined',
                 models.DateTimeField(auto_now_add=True,
                                      verbose_name='date joined')),
                ('role',
                 models.CharField(choices=[('ADMIN', 'ADMIN'),
                                           ('USER', 'USER'),
                                           ('SALES', 'SALES'),
                                           ('MANAGER', 'MANAGER'),
                                           ('SALES MANAGER', 'SALES MANAGER')],
                                  max_length=50)),
                ('profile_pic',
                 models.FileField(blank=True,
                                  max_length=1000,
                                  null=True,
                                  upload_to=common.models.img_url)),
                ('has_sales_access', models.BooleanField(default=False)),
                ('has_marketing_access', models.BooleanField(default=False)),
            ],
            options={
                'ordering': ['-is_active'],
            },
            managers=[
                ('objects', django.contrib.auth.models.UserManager()),
            ],
        ),
        migrations.CreateModel(
            name='Address',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('address_line',
                 models.CharField(blank=True,
                                  max_length=255,
                                  null=True,
                                  verbose_name='Address')),
                ('street',
                 models.CharField(blank=True,
                                  max_length=55,
                                  null=True,
                                  verbose_name='Street')),
                ('city',
                 models.CharField(blank=True,
                                  max_length=255,
                                  null=True,
                                  verbose_name='City')),
                ('state',
                 models.CharField(blank=True,
                                  max_length=255,
                                  null=True,
                                  verbose_name='State')),
                ('postcode',
                 models.CharField(blank=True,
                                  max_length=64,
                                  null=True,
                                  verbose_name='Post/Zip-code')),
                ('country',
                 models.CharField(
                     blank=True,
                     choices=[('GB', 'United Kingdom'), ('AF', 'Afghanistan'),
                              ('AX', 'Aland Islands'), ('AL', 'Albania'),
                              ('DZ', 'Algeria'), ('AS', 'American Samoa'),
                              ('AD', 'Andorra'), ('AO', 'Angola'),
                              ('AI', 'Anguilla'), ('AQ', 'Antarctica'),
                              ('AG', 'Antigua and Barbuda'),
                              ('AR', 'Argentina'), ('AM', 'Armenia'),
                              ('AW', 'Aruba'), ('AU', 'Australia'),
                              ('AT', 'Austria'), ('AZ', 'Azerbaijan'),
                              ('BS', 'Bahamas'), ('BH', 'Bahrain'),
                              ('BD', 'Bangladesh'), ('BB', 'Barbados'),
                              ('BY', 'Belarus'), ('BE', 'Belgium'),
                              ('BZ', 'Belize'), ('BJ', 'Benin'),
                              ('BM', 'Bermuda'), ('BT', 'Bhutan'),
                              ('BO', 'Bolivia'),
                              ('BA', 'Bosnia and Herzegovina'),
                              ('BW', 'Botswana'), ('BV', 'Bouvet Island'),
                              ('BR', 'Brazil'),
                              ('IO', 'British Indian Ocean Territory'),
                              ('BN', 'Brunei Darussalam'), ('BG', 'Bulgaria'),
                              ('BF', 'Burkina Faso'), ('BI', 'Burundi'),
                              ('KH', 'Cambodia'), ('CM', 'Cameroon'),
                              ('CA', 'Canada'), ('CV', 'Cape Verde'),
                              ('KY', 'Cayman Islands'),
                              ('CF', 'Central African Republic'),
                              ('TD', 'Chad'), ('CL', 'Chile'), ('CN', 'China'),
                              ('CX', 'Christmas Island'),
                              ('CC', 'Cocos (Keeling) Islands'),
                              ('CO', 'Colombia'), ('KM', 'Comoros'),
                              ('CG', 'Congo'),
                              ('CD', 'Congo, The Democratic Republic of the'),
                              ('CK', 'Cook Islands'), ('CR', 'Costa Rica'),
                              ('CI', "Cote d'Ivoire"), ('HR', 'Croatia'),
                              ('CU', 'Cuba'), ('CY', 'Cyprus'),
                              ('CZ', 'Czech Republic'), ('DK', 'Denmark'),
                              ('DJ', 'Djibouti'), ('DM', 'Dominica'),
                              ('DO', 'Dominican Republic'), ('EC', 'Ecuador'),
                              ('EG', 'Egypt'), ('SV', 'El Salvador'),
                              ('GQ', 'Equatorial Guinea'), ('ER', 'Eritrea'),
                              ('EE', 'Estonia'), ('ET', 'Ethiopia'),
                              ('FK', 'Falkland Islands (Malvinas)'),
                              ('FO', 'Faroe Islands'), ('FJ', 'Fiji'),
                              ('FI', 'Finland'), ('FR', 'France'),
                              ('GF', 'French Guiana'),
                              ('PF', 'French Polynesia'),
                              ('TF', 'French Southern Territories'),
                              ('GA', 'Gabon'), ('GM', 'Gambia'),
                              ('GE', 'Georgia'), ('DE', 'Germany'),
                              ('GH', 'Ghana'), ('GI', 'Gibraltar'),
                              ('GR', 'Greece'), ('GL', 'Greenland'),
                              ('GD', 'Grenada'), ('GP', 'Guadeloupe'),
                              ('GU', 'Guam'), ('GT', 'Guatemala'),
                              ('GG', 'Guernsey'), ('GN', 'Guinea'),
                              ('GW', 'Guinea-Bissau'), ('GY', 'Guyana'),
                              ('HT', 'Haiti'),
                              ('HM', 'Heard Island and McDonald Islands'),
                              ('VA', 'Holy See (Vatican City State)'),
                              ('HN', 'Honduras'), ('HK', 'Hong Kong'),
                              ('HU', 'Hungary'), ('IS', 'Iceland'),
                              ('IN', 'India'), ('ID', 'Indonesia'),
                              ('IR', 'Iran, Islamic Republic of'),
                              ('IQ', 'Iraq'), ('IE', 'Ireland'),
                              ('IM', 'Isle of Man'), ('IL', 'Israel'),
                              ('IT', 'Italy'), ('JM', 'Jamaica'),
                              ('JP', 'Japan'), ('JE', 'Jersey'),
                              ('JO', 'Jordan'), ('KZ', 'Kazakhstan'),
                              ('KE', 'Kenya'), ('KI', 'Kiribati'),
                              ('KP', "Korea, Democratic People's Republic of"),
                              ('KR', 'Korea, Republic of'), ('KW', 'Kuwait'),
                              ('KG', 'Kyrgyzstan'),
                              ('LA', "Lao People's Democratic Republic"),
                              ('LV', 'Latvia'), ('LB', 'Lebanon'),
                              ('LS', 'Lesotho'), ('LR', 'Liberia'),
                              ('LY', 'Libyan Arab Jamahiriya'),
                              ('LI', 'Liechtenstein'), ('LT', 'Lithuania'),
                              ('LU', 'Luxembourg'), ('MO', 'Macao'),
                              ('MK',
                               'Macedonia, The Former Yugoslav Republic of'),
                              ('MG', 'Madagascar'), ('MW', 'Malawi'),
                              ('MY', 'Malaysia'), ('MV', 'Maldives'),
                              ('ML', 'Mali'), ('MT', 'Malta'),
                              ('MH', 'Marshall Islands'), ('MQ', 'Martinique'),
                              ('MR', 'Mauritania'), ('MU', 'Mauritius'),
                              ('YT', 'Mayotte'), ('MX', 'Mexico'),
                              ('FM', 'Micronesia, Federated States of'),
                              ('MD', 'Moldova'), ('MC', 'Monaco'),
                              ('MN', 'Mongolia'), ('ME', 'Montenegro'),
                              ('MS', 'Montserrat'), ('MA', 'Morocco'),
                              ('MZ', 'Mozambique'), ('MM', 'Myanmar'),
                              ('NA', 'Namibia'), ('NR', 'Nauru'),
                              ('NP', 'Nepal'), ('NL', 'Netherlands'),
                              ('AN', 'Netherlands Antilles'),
                              ('NC', 'New Caledonia'), ('NZ', 'New Zealand'),
                              ('NI', 'Nicaragua'), ('NE', 'Niger'),
                              ('NG', 'Nigeria'), ('NU', 'Niue'),
                              ('NF', 'Norfolk Island'),
                              ('MP', 'Northern Mariana Islands'),
                              ('NO', 'Norway'), ('OM', 'Oman'),
                              ('PK', 'Pakistan'), ('PW', 'Palau'),
                              ('PS', 'Palestinian Territory, Occupied'),
                              ('PA', 'Panama'), ('PG', 'Papua New Guinea'),
                              ('PY', 'Paraguay'), ('PE', 'Peru'),
                              ('PH', 'Philippines'), ('PN', 'Pitcairn'),
                              ('PL', 'Poland'), ('PT', 'Portugal'),
                              ('PR', 'Puerto Rico'), ('QA', 'Qatar'),
                              ('RE', 'Reunion'), ('RO', 'Romania'),
                              ('RU', 'Russian Federation'), ('RW', 'Rwanda'),
                              ('BL', 'Saint Barthelemy'),
                              ('SH', 'Saint Helena'),
                              ('KN', 'Saint Kitts and Nevis'),
                              ('LC', 'Saint Lucia'), ('MF', 'Saint Martin'),
                              ('PM', 'Saint Pierre and Miquelon'),
                              ('VC', 'Saint Vincent and the Grenadines'),
                              ('WS', 'Samoa'), ('SM', 'San Marino'),
                              ('ST', 'Sao Tome and Principe'),
                              ('SA', 'Saudi Arabia'), ('SN', 'Senegal'),
                              ('RS', 'Serbia'), ('SC', 'Seychelles'),
                              ('SL', 'Sierra Leone'), ('SG', 'Singapore'),
                              ('SK', 'Slovakia'), ('SI', 'Slovenia'),
                              ('SB', 'Solomon Islands'), ('SO', 'Somalia'),
                              ('ZA', 'South Africa'),
                              ('GS',
                               'South Georgia and the South Sandwich Islands'),
                              ('ES', 'Spain'), ('LK', 'Sri Lanka'),
                              ('SD', 'Sudan'), ('SR', 'Suriname'),
                              ('SJ', 'Svalbard and Jan Mayen'),
                              ('SZ', 'Swaziland'), ('SE', 'Sweden'),
                              ('CH', 'Switzerland'),
                              ('SY', 'Syrian Arab Republic'),
                              ('TW', 'Taiwan, Province of China'),
                              ('TJ', 'Tajikistan'),
                              ('TZ', 'Tanzania, United Republic of'),
                              ('TH', 'Thailand'), ('TL', 'Timor-Leste'),
                              ('TG', 'Togo'), ('TK', 'Tokelau'),
                              ('TO', 'Tonga'), ('TT', 'Trinidad and Tobago'),
                              ('TN', 'Tunisia'), ('TR', 'Turkey'),
                              ('TM', 'Turkmenistan'),
                              ('TC', 'Turks and Caicos Islands'),
                              ('TV', 'Tuvalu'), ('UG', 'Uganda'),
                              ('UA', 'Ukraine'), ('AE',
                                                  'United Arab Emirates'),
                              ('US', 'United States'),
                              ('UM', 'United States Minor Outlying Islands'),
                              ('UY', 'Uruguay'), ('UZ', 'Uzbekistan'),
                              ('VU', 'Vanuatu'), ('VE', 'Venezuela'),
                              ('VN', 'Viet Nam'),
                              ('VG', 'Virgin Islands, British'),
                              ('VI', 'Virgin Islands, U.S.'),
                              ('WF', 'Wallis and Futuna'),
                              ('EH', 'Western Sahara'), ('YE', 'Yemen'),
                              ('ZM', 'Zambia'), ('ZW', 'Zimbabwe')],
                     max_length=3,
                     null=True)),
            ],
        ),
        migrations.CreateModel(
            name='APISettings',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('title', models.CharField(max_length=1000)),
                ('apikey', models.CharField(blank=True, max_length=16)),
                ('website', models.URLField(default='', max_length=255)),
                ('created_on', models.DateTimeField(auto_now_add=True)),
            ],
            options={
                'ordering': ('-created_on', ),
            },
        ),
        migrations.CreateModel(
            name='Attachments',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('file_name', models.CharField(max_length=60)),
                ('created_on',
                 models.DateTimeField(auto_now_add=True,
                                      verbose_name='Created on')),
                ('attachment',
                 models.FileField(max_length=1001,
                                  upload_to='attachments/%Y/%m/')),
            ],
        ),
        migrations.CreateModel(
            name='Comment',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('comment', models.CharField(max_length=255)),
                ('commented_on', models.DateTimeField(auto_now_add=True)),
                ('account',
                 models.ForeignKey(blank=True,
                                   null=True,
                                   on_delete=django.db.models.deletion.CASCADE,
                                   related_name='accounts_comments',
                                   to='accounts.Account')),
                ('case',
                 models.ForeignKey(blank=True,
                                   null=True,
                                   on_delete=django.db.models.deletion.CASCADE,
                                   related_name='cases',
                                   to='cases.Case')),
                ('commented_by',
                 models.ForeignKey(blank=True,
                                   null=True,
                                   on_delete=django.db.models.deletion.CASCADE,
                                   to=settings.AUTH_USER_MODEL)),
            ],
        ),
        migrations.CreateModel(
            name='Profile',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('activation_key', models.CharField(max_length=50)),
                ('key_expires', models.DateTimeField()),
                ('user',
                 models.OneToOneField(
                     on_delete=django.db.models.deletion.CASCADE,
                     related_name='profile',
                     to=settings.AUTH_USER_MODEL)),
            ],
        ),
        migrations.CreateModel(
            name='Google',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('google_id', models.CharField(default='', max_length=200)),
                ('google_url', models.CharField(default='', max_length=1000)),
                ('verified_email', models.CharField(default='',
                                                    max_length=200)),
                ('family_name', models.CharField(default='', max_length=200)),
                ('name', models.CharField(default='', max_length=200)),
                ('gender', models.CharField(default='', max_length=10)),
                ('dob', models.CharField(default='', max_length=50)),
                ('given_name', models.CharField(default='', max_length=200)),
                ('email',
                 models.CharField(db_index=True, default='', max_length=200)),
                ('user',
                 models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
                                   related_name='google',
                                   to=settings.AUTH_USER_MODEL)),
            ],
        ),
        migrations.CreateModel(
            name='Document',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('title',
                 models.CharField(blank=True, max_length=1000, null=True)),
                ('document_file',
                 models.FileField(max_length=5000,
                                  upload_to=common.models.document_path)),
                ('created_on', models.DateTimeField(auto_now_add=True)),
                ('status',
                 models.CharField(choices=[('active', 'active'),
                                           ('inactive', 'inactive')],
                                  default='active',
                                  max_length=64)),
                ('created_by',
                 models.ForeignKey(
                     null=True,
                     on_delete=django.db.models.deletion.SET_NULL,
                     related_name='document_uploaded',
                     to=settings.AUTH_USER_MODEL)),
                ('shared_to',
                 models.ManyToManyField(related_name='document_shared_to',
                                        to=settings.AUTH_USER_MODEL)),
            ],
            options={
                'ordering': ('-created_on', ),
            },
        ),
        migrations.CreateModel(
            name='Comment_Files',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('updated_on', models.DateTimeField(auto_now_add=True)),
                ('comment_file',
                 models.FileField(default='',
                                  upload_to='comment_files',
                                  verbose_name='File')),
                ('comment',
                 models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
                                   to='common.Comment')),
            ],
        ),
    ]
Example #17
0
class Migration(migrations.Migration):

    initial = True

    dependencies = [
        ('teaching', '0001_initial'),
    ]

    operations = [
        migrations.CreateModel(
            name='College',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created', django_extensions.db.fields.CreationDateTimeField(auto_now_add=True, verbose_name='created')),
                ('modified', django_extensions.db.fields.ModificationDateTimeField(auto_now=True, verbose_name='modified')),
                ('name', models.CharField(max_length=200, unique=True, verbose_name='Název školy')),
                ('type', models.CharField(choices=[('univerzitni', 'univerzitní'), ('neuniverzitni', 'neuniverzitní')], max_length=20, verbose_name='Typ')),
                ('form', models.CharField(choices=[('soukroma', 'soukromá'), ('statni', 'státní'), ('verejna', 'veřejná')], max_length=20, verbose_name='Forma')),
                ('address', models.CharField(max_length=200, verbose_name='Adresa')),
                ('rid', models.CharField(max_length=20, unique=True, verbose_name='RID')),
                ('ic', models.CharField(max_length=20, verbose_name='IČ')),
                ('databox', models.CharField(max_length=20, verbose_name='Datová schránka')),
                ('url', models.URLField(verbose_name='URL')),
                ('code', models.CharField(max_length=30, unique=True, verbose_name='Zkratka')),
            ],
            options={
                'verbose_name': 'Vysoká škola',
                'verbose_name_plural': 'Vysoké školy',
                'ordering': ('name',),
            },
            bases=(models.Model, common.models.GraphModel),
        ),
        migrations.CreateModel(
            name='Faculty',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created', django_extensions.db.fields.CreationDateTimeField(auto_now_add=True, verbose_name='created')),
                ('modified', django_extensions.db.fields.ModificationDateTimeField(auto_now=True, verbose_name='modified')),
                ('name', models.CharField(max_length=200, verbose_name='Název fakulty')),
                ('rid', models.CharField(max_length=20, verbose_name='RID')),
                ('url', models.URLField(verbose_name='URL')),
                ('college', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, to='colleges.college')),
            ],
            options={
                'verbose_name': 'Fakulta vysoké školy',
                'verbose_name_plural': 'Fakulty vysokých škol',
                'ordering': ('name', 'college'),
                'unique_together': {('name', 'college')},
            },
            bases=(models.Model, common.models.GraphModel),
        ),
        migrations.CreateModel(
            name='Course',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created', django_extensions.db.fields.CreationDateTimeField(auto_now_add=True, verbose_name='created')),
                ('modified', django_extensions.db.fields.ModificationDateTimeField(auto_now=True, verbose_name='modified')),
                ('name', models.CharField(max_length=300, verbose_name='Název')),
                ('price', models.IntegerField(verbose_name='Cena')),
                ('sds', models.IntegerField(verbose_name='Standardní doba studia')),
                ('form_present', models.BooleanField(default=False, verbose_name='Prezenční forma studia')),
                ('form_combined', models.BooleanField(default=True, verbose_name='Kombinovaná forma studia')),
                ('url', models.URLField(verbose_name='URL na podrobnější informace')),
                ('note', models.TextField(blank=True, verbose_name='Poznámka')),
                ('faculty', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, to='colleges.faculty', verbose_name='Fakulta')),
                ('subjects', models.ManyToManyField(to='teaching.Subject', verbose_name='Předměty')),
            ],
            options={
                'verbose_name': 'Kurz',
                'verbose_name_plural': 'Kurzy',
                'ordering': ('name', 'faculty', 'faculty__college'),
            },
        ),
    ]
Example #18
0
class Migration(migrations.Migration):

    initial = True

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

    operations = [
        migrations.CreateModel(
            name='AudioAsset',
            fields=[
                ('id',
                 models.BigAutoField(auto_created=True,
                                     primary_key=True,
                                     serialize=False,
                                     verbose_name='ID')),
                ('created',
                 models.DateTimeField(auto_now_add=True,
                                      verbose_name='created')),
                ('modified',
                 models.DateTimeField(auto_now=True,
                                      verbose_name='last modified')),
                ('title',
                 common.models.TruncatingCharField(
                     blank=True,
                     db_index=True,
                     help_text=
                     "If left empty, a title will be generated from the file's metadata.",
                     max_length=255,
                     verbose_name='title')),
                ('file_basename', models.CharField(max_length=512)),
                ('file',
                 models.FileField(
                     blank=True,
                     help_text=
                     'You can provide either an uploaded audio file or a URL to an external asset.',
                     max_length=512,
                     upload_to=common.models.audio_asset_file_upload_to,
                     verbose_name='audio file')),
                ('duration',
                 models.DurationField(default=datetime.timedelta(0),
                                      verbose_name='Audio duration')),
                ('fingerprint', models.UUIDField(db_index=True, null=True)),
                ('status',
                 models.CharField(
                     choices=[('-', 'processing queued'), ('p', 'processing'),
                              ('f', 'processing failed'),
                              ('r', 'ready for play')],
                     db_index=True,
                     default='-',
                     help_text=
                     'You will be able to edit this asset when status is "ready for play."',
                     max_length=1,
                     verbose_name='status')),
                ('task_id', models.UUIDField(null=True)),
                ('artist',
                 common.models.TruncatingCharField(
                     blank=True,
                     help_text=
                     "If left empty, an artist will be generated from the file's metadata.",
                     max_length=255,
                     verbose_name='artist')),
                ('album',
                 common.models.TruncatingCharField(
                     blank=True,
                     help_text=
                     "If left empty, an album will be generated from the file's metadata.",
                     max_length=255,
                     verbose_name='album')),
                ('title_normalized',
                 common.models.TruncatingCharField(db_index=True,
                                                   max_length=255)),
                ('artist_normalized',
                 common.models.TruncatingCharField(db_index=True,
                                                   max_length=255)),
                ('album_normalized',
                 common.models.TruncatingCharField(db_index=True,
                                                   max_length=255)),
                ('uploader',
                 models.ForeignKey(
                     null=True,
                     on_delete=django.db.models.deletion.SET_NULL,
                     to=settings.AUTH_USER_MODEL,
                     verbose_name='uploader')),
            ],
            options={
                'verbose_name': 'audio asset',
                'verbose_name_plural': 'audio assets',
                'ordering': ('title', 'artist', 'album', 'id'),
            },
            bases=(dirtyfields.dirtyfields.DirtyFieldsMixin, models.Model),
        ),
        migrations.CreateModel(
            name='Rotator',
            fields=[
                ('id',
                 models.BigAutoField(auto_created=True,
                                     primary_key=True,
                                     serialize=False,
                                     verbose_name='ID')),
                ('name',
                 models.CharField(max_length=100,
                                  unique=True,
                                  verbose_name='name')),
            ],
            options={
                'ordering': ('name', ),
            },
        ),
        migrations.CreateModel(
            name='Stopset',
            fields=[
                ('id',
                 models.BigAutoField(auto_created=True,
                                     primary_key=True,
                                     serialize=False,
                                     verbose_name='ID')),
                ('name',
                 models.CharField(max_length=100,
                                  unique=True,
                                  verbose_name='name')),
                ('weight',
                 models.FloatField(
                     default=1.0,
                     help_text=
                     "The weight (ie selection bias) for how likely random selection from this playlist/stopset occurs, eg '1.0' is just as likely as all others, '2.0' is 2x as likely, '3.0' is 3x as likely, '0.5' half as likely, and so on. If unsure, leave as '1.0'.",
                     validators=[
                         django.core.validators.MinValueValidator(0.0)
                     ],
                     verbose_name='random weight')),
                ('is_active',
                 models.BooleanField(
                     default=True,
                     help_text=
                     'Whether tracks from this playlist/stopset will be selected. You may want to enable special playlists/stopsets at certain times, for example during the holidays.',
                     verbose_name='currently active')),
            ],
            options={
                'ordering': ('name', ),
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='StopsetRotator',
            fields=[
                ('id',
                 models.BigAutoField(auto_created=True,
                                     primary_key=True,
                                     serialize=False,
                                     verbose_name='ID')),
                ('rotator',
                 models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
                                   related_name='stopset_rotators',
                                   to='autodj.rotator')),
                ('stopset',
                 models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
                                   related_name='stopset_rotators',
                                   to='autodj.stopset')),
            ],
            options={
                'verbose_name': 'rotator in stop set relationship',
                'verbose_name_plural': 'rotator in stop set relationships',
                'ordering': ('id', ),
            },
        ),
        migrations.CreateModel(
            name='RotatorAsset',
            fields=[
                ('id',
                 models.BigAutoField(auto_created=True,
                                     primary_key=True,
                                     serialize=False,
                                     verbose_name='ID')),
                ('created',
                 models.DateTimeField(auto_now_add=True,
                                      verbose_name='created')),
                ('modified',
                 models.DateTimeField(auto_now=True,
                                      verbose_name='last modified')),
                ('title',
                 common.models.TruncatingCharField(
                     blank=True,
                     db_index=True,
                     help_text=
                     "If left empty, a title will be generated from the file's metadata.",
                     max_length=255,
                     verbose_name='title')),
                ('file_basename', models.CharField(max_length=512)),
                ('file',
                 models.FileField(
                     blank=True,
                     help_text=
                     'You can provide either an uploaded audio file or a URL to an external asset.',
                     max_length=512,
                     upload_to=common.models.audio_asset_file_upload_to,
                     verbose_name='audio file')),
                ('duration',
                 models.DurationField(default=datetime.timedelta(0),
                                      verbose_name='Audio duration')),
                ('fingerprint', models.UUIDField(db_index=True, null=True)),
                ('status',
                 models.CharField(
                     choices=[('-', 'processing queued'), ('p', 'processing'),
                              ('f', 'processing failed'),
                              ('r', 'ready for play')],
                     db_index=True,
                     default='-',
                     help_text=
                     'You will be able to edit this asset when status is "ready for play."',
                     max_length=1,
                     verbose_name='status')),
                ('task_id', models.UUIDField(null=True)),
                ('uploader',
                 models.ForeignKey(
                     null=True,
                     on_delete=django.db.models.deletion.SET_NULL,
                     to=settings.AUTH_USER_MODEL,
                     verbose_name='uploader')),
            ],
            options={
                'verbose_name': 'rotator asset',
                'verbose_name_plural': 'rotator assets',
                'ordering': ('title', 'id'),
            },
            bases=(dirtyfields.dirtyfields.DirtyFieldsMixin, models.Model),
        ),
        migrations.AddField(
            model_name='rotator',
            name='rotator_assets',
            field=models.ManyToManyField(blank=True,
                                         db_index=True,
                                         related_name='rotators',
                                         to='autodj.RotatorAsset',
                                         verbose_name='rotator assets'),
        ),
        migrations.CreateModel(
            name='Playlist',
            fields=[
                ('id',
                 models.BigAutoField(auto_created=True,
                                     primary_key=True,
                                     serialize=False,
                                     verbose_name='ID')),
                ('name',
                 models.CharField(max_length=100,
                                  unique=True,
                                  verbose_name='name')),
                ('weight',
                 models.FloatField(
                     default=1.0,
                     help_text=
                     "The weight (ie selection bias) for how likely random selection from this playlist/stopset occurs, eg '1.0' is just as likely as all others, '2.0' is 2x as likely, '3.0' is 3x as likely, '0.5' half as likely, and so on. If unsure, leave as '1.0'.",
                     validators=[
                         django.core.validators.MinValueValidator(0.0)
                     ],
                     verbose_name='random weight')),
                ('is_active',
                 models.BooleanField(
                     default=True,
                     help_text=
                     'Whether tracks from this playlist/stopset will be selected. You may want to enable special playlists/stopsets at certain times, for example during the holidays.',
                     verbose_name='currently active')),
                ('audio_assets',
                 models.ManyToManyField(blank=True,
                                        db_index=True,
                                        related_name='playlists',
                                        to='autodj.AudioAsset',
                                        verbose_name='audio assets')),
            ],
            options={
                'ordering': ('name', ),
                'abstract': False,
            },
        ),
    ]
Example #19
0
class Migration(migrations.Migration):

    initial = True

    dependencies = []

    operations = [
        migrations.CreateModel(
            name='City',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('create_time',
                 models.DateTimeField(auto_now_add=True, verbose_name='创建时间')),
                ('update_time',
                 models.DateTimeField(auto_now=True, verbose_name='更新时间')),
                ('is_deleted',
                 models.BooleanField(default=False,
                                     editable=False,
                                     verbose_name='是否已删除')),
                ('name', models.CharField(max_length=255, verbose_name='名称')),
                ('short_name',
                 models.CharField(blank=True,
                                  max_length=255,
                                  verbose_name='简称')),
                ('lng',
                 models.CharField(blank=True,
                                  max_length=255,
                                  verbose_name='经度')),
                ('lat',
                 models.CharField(blank=True,
                                  max_length=255,
                                  verbose_name='纬度')),
                ('pinyin',
                 models.CharField(blank=True,
                                  max_length=255,
                                  verbose_name='拼音')),
                ('zip_code',
                 models.CharField(blank=True,
                                  max_length=255,
                                  verbose_name='邮编')),
                ('area_code',
                 models.CharField(blank=True,
                                  max_length=255,
                                  verbose_name='区域编码')),
                ('merger_name',
                 models.CharField(blank=True,
                                  max_length=255,
                                  verbose_name='合并名称')),
                ('city_code',
                 models.CharField(blank=True,
                                  max_length=255,
                                  verbose_name='城市编码')),
            ],
            options={
                'verbose_name': '市',
                'verbose_name_plural': '市',
            },
        ),
        migrations.CreateModel(
            name='County',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('create_time',
                 models.DateTimeField(auto_now_add=True, verbose_name='创建时间')),
                ('update_time',
                 models.DateTimeField(auto_now=True, verbose_name='更新时间')),
                ('is_deleted',
                 models.BooleanField(default=False,
                                     editable=False,
                                     verbose_name='是否已删除')),
                ('name',
                 models.CharField(blank=True,
                                  max_length=255,
                                  verbose_name='名称')),
                ('short_name',
                 models.CharField(blank=True,
                                  max_length=255,
                                  verbose_name='简称')),
                ('lng',
                 models.CharField(blank=True,
                                  max_length=255,
                                  verbose_name='经度')),
                ('lat',
                 models.CharField(blank=True,
                                  max_length=255,
                                  verbose_name='纬度')),
                ('pinyin',
                 models.CharField(blank=True,
                                  max_length=255,
                                  verbose_name='拼音')),
                ('zip_code',
                 models.CharField(blank=True,
                                  max_length=255,
                                  verbose_name='邮编')),
                ('area_code',
                 models.CharField(blank=True,
                                  max_length=255,
                                  verbose_name='区域编码')),
                ('merger_name',
                 models.CharField(blank=True,
                                  max_length=255,
                                  verbose_name='合并名称')),
                ('city_code',
                 models.CharField(blank=True,
                                  max_length=255,
                                  verbose_name='城市编码')),
                ('city',
                 models.ForeignKey(null=True,
                                   on_delete=django.db.models.deletion.CASCADE,
                                   related_name='counties',
                                   to='common.City',
                                   verbose_name='市')),
            ],
            options={
                'verbose_name': '区县',
                'verbose_name_plural': '区县',
            },
        ),
        migrations.CreateModel(
            name='File',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('create_time',
                 models.DateTimeField(auto_now_add=True, verbose_name='创建时间')),
                ('update_time',
                 models.DateTimeField(auto_now=True, verbose_name='更新时间')),
                ('is_deleted',
                 models.BooleanField(default=False,
                                     editable=False,
                                     verbose_name='是否已删除')),
                ('file',
                 models.FileField(upload_to=common.models.upload_path,
                                  verbose_name='文件')),
                ('category',
                 models.CharField(max_length=100, verbose_name='文件类别')),
            ],
            options={
                'verbose_name': '文件上传',
                'verbose_name_plural': '文件上传',
            },
        ),
        migrations.CreateModel(
            name='Province',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('create_time',
                 models.DateTimeField(auto_now_add=True, verbose_name='创建时间')),
                ('update_time',
                 models.DateTimeField(auto_now=True, verbose_name='更新时间')),
                ('is_deleted',
                 models.BooleanField(default=False,
                                     editable=False,
                                     verbose_name='是否已删除')),
                ('name', models.CharField(max_length=255, verbose_name='名称')),
                ('short_name',
                 models.CharField(blank=True,
                                  max_length=255,
                                  verbose_name='简称')),
                ('lng',
                 models.CharField(blank=True,
                                  max_length=255,
                                  verbose_name='经度')),
                ('lat',
                 models.CharField(blank=True,
                                  max_length=255,
                                  verbose_name='纬度')),
                ('pinyin',
                 models.CharField(blank=True,
                                  max_length=255,
                                  verbose_name='拼音')),
                ('zip_code',
                 models.CharField(blank=True,
                                  max_length=255,
                                  verbose_name='邮编')),
                ('area_code',
                 models.CharField(blank=True,
                                  max_length=255,
                                  verbose_name='区域编码')),
                ('merger_name',
                 models.CharField(blank=True,
                                  max_length=255,
                                  verbose_name='合并名称')),
                ('city_code',
                 models.CharField(blank=True,
                                  max_length=255,
                                  verbose_name='城市编码')),
            ],
            options={
                'verbose_name': '省',
                'verbose_name_plural': '省',
            },
        ),
        migrations.AddField(
            model_name='city',
            name='province',
            field=models.ForeignKey(
                on_delete=django.db.models.deletion.CASCADE,
                related_name='cities',
                to='common.Province',
                verbose_name='省'),
        ),
    ]
Example #20
0
class Migration(migrations.Migration):

    initial = True

    dependencies = []

    operations = [
        migrations.CreateModel(
            name='Account',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('name', common.models.NameField(max_length=150, unique=True)),
                ('lft',
                 models.PositiveIntegerField(db_index=True, editable=False)),
                ('rght',
                 models.PositiveIntegerField(db_index=True, editable=False)),
                ('tree_id',
                 models.PositiveIntegerField(db_index=True, editable=False)),
                ('level',
                 models.PositiveIntegerField(db_index=True, editable=False)),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='AccountType',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('name', common.models.NameField(max_length=150, unique=True)),
                ('children_allowed', models.BooleanField()),
                ('movements_allowed', models.BooleanField()),
                ('new_accounts_allowed', models.BooleanField()),
            ],
        ),
        migrations.AddField(
            model_name='account',
            name='acc_type',
            field=models.ForeignKey(
                on_delete=django.db.models.deletion.CASCADE,
                to='accounts.AccountType'),
        ),
        migrations.AddField(
            model_name='account',
            name='parent',
            field=mptt.fields.TreeForeignKey(
                blank=True,
                null=True,
                on_delete=django.db.models.deletion.CASCADE,
                related_name='children',
                to='accounts.Account'),
        ),
    ]
Example #21
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')),
                ('is_superuser',
                 models.BooleanField(
                     default=False,
                     help_text=
                     'Designates that this user has all permissions without explicitly assigning them.',
                     verbose_name='superuser status')),
                ('username', models.CharField(max_length=100, unique=True)),
                ('first_name', models.CharField(blank=True, max_length=150)),
                ('last_name', models.CharField(blank=True, max_length=150)),
                ('email', models.EmailField(max_length=255, unique=True)),
                ('is_active', models.BooleanField(default=True)),
                ('is_admin', models.BooleanField(default=False)),
                ('is_staff', models.BooleanField(default=False)),
                ('date_joined',
                 models.DateTimeField(auto_now_add=True,
                                      verbose_name='date joined')),
                ('role',
                 models.CharField(choices=[('ADMIN', 'ADMIN'),
                                           ('CONSULTANT', 'CONSULTANT'),
                                           ('USER', 'USER')],
                                  max_length=50)),
                ('profile_pic',
                 models.FileField(blank=True,
                                  max_length=1000,
                                  null=True,
                                  upload_to=common.models.img_url)),
                ('has_sales_access', models.BooleanField(default=False)),
                ('has_marketing_access', models.BooleanField(default=False)),
            ],
            options={
                'ordering': ['-is_active'],
            },
            managers=[
                ('objects', django.contrib.auth.models.UserManager()),
            ],
        ),
        migrations.CreateModel(
            name='Address',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('address_line',
                 models.CharField(blank=True,
                                  max_length=255,
                                  null=True,
                                  verbose_name='Address')),
                ('street',
                 models.CharField(blank=True,
                                  max_length=55,
                                  null=True,
                                  verbose_name='Street')),
                ('city',
                 models.CharField(blank=True,
                                  max_length=255,
                                  null=True,
                                  verbose_name='City')),
                ('state',
                 models.CharField(blank=True,
                                  max_length=255,
                                  null=True,
                                  verbose_name='State')),
                ('postcode',
                 models.CharField(blank=True,
                                  max_length=64,
                                  null=True,
                                  verbose_name='Post/Zip-code')),
                ('country',
                 models.CharField(blank=True,
                                  choices=[('Botswana', 'Botswana')],
                                  max_length=20,
                                  null=True)),
            ],
        ),
        migrations.CreateModel(
            name='APISettings',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('title', models.CharField(max_length=1000)),
                ('apikey', models.CharField(blank=True, max_length=16)),
                ('website', models.URLField(default='', max_length=255)),
                ('created_on', models.DateTimeField(auto_now_add=True)),
            ],
            options={
                'ordering': ('-created_on', ),
            },
        ),
        migrations.CreateModel(
            name='Attachments',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('file_name', models.CharField(max_length=60)),
                ('created_on',
                 models.DateTimeField(auto_now_add=True,
                                      verbose_name='Created on')),
                ('attachment',
                 models.FileField(max_length=1001,
                                  upload_to='attachments/%Y/%m/')),
            ],
        ),
        migrations.CreateModel(
            name='Comment',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('comment', models.CharField(max_length=255)),
                ('commented_on', models.DateTimeField(auto_now_add=True)),
            ],
        ),
        migrations.CreateModel(
            name='Comment_Files',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('updated_on', models.DateTimeField(auto_now_add=True)),
                ('comment_file',
                 models.FileField(default='',
                                  upload_to='comment_files',
                                  verbose_name='File')),
            ],
        ),
        migrations.CreateModel(
            name='Profile',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('activation_key', models.CharField(max_length=50)),
                ('key_expires', models.DateTimeField()),
                ('user',
                 models.OneToOneField(
                     on_delete=django.db.models.deletion.CASCADE,
                     related_name='profile',
                     to=settings.AUTH_USER_MODEL)),
            ],
        ),
        migrations.CreateModel(
            name='Google',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('google_id', models.CharField(default='', max_length=200)),
                ('google_url', models.CharField(default='', max_length=1000)),
                ('verified_email', models.CharField(default='',
                                                    max_length=200)),
                ('family_name', models.CharField(default='', max_length=200)),
                ('name', models.CharField(default='', max_length=200)),
                ('gender', models.CharField(default='', max_length=10)),
                ('dob', models.CharField(default='', max_length=50)),
                ('given_name', models.CharField(default='', max_length=200)),
                ('email',
                 models.CharField(db_index=True, default='', max_length=200)),
                ('user',
                 models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
                                   related_name='google',
                                   to=settings.AUTH_USER_MODEL)),
            ],
        ),
        migrations.CreateModel(
            name='Document',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('title',
                 models.CharField(blank=True, max_length=1000, null=True)),
                ('document_file',
                 models.FileField(max_length=5000,
                                  upload_to=common.models.document_path)),
                ('created_on', models.DateTimeField(auto_now_add=True)),
                ('status',
                 models.CharField(choices=[('active', 'active'),
                                           ('inactive', 'inactive')],
                                  default='active',
                                  max_length=64)),
                ('created_by',
                 models.ForeignKey(
                     null=True,
                     on_delete=django.db.models.deletion.SET_NULL,
                     related_name='document_uploaded',
                     to=settings.AUTH_USER_MODEL)),
                ('shared_to',
                 models.ManyToManyField(related_name='document_shared_to',
                                        to=settings.AUTH_USER_MODEL)),
            ],
            options={
                'ordering': ('-created_on', ),
            },
        ),
    ]
Example #22
0
class Migration(migrations.Migration):

    initial = True

    dependencies = [
        ('auth', '0009_alter_user_last_name_max_length'),
    ]

    operations = [
        migrations.CreateModel(
            name='User',
            fields=[
                ('password',
                 models.CharField(max_length=128, verbose_name='password')),
                ('last_login',
                 models.DateTimeField(blank=True,
                                      null=True,
                                      verbose_name='last login')),
                ('created',
                 django_extensions.db.fields.CreationDateTimeField(
                     auto_now_add=True, verbose_name='created')),
                ('modified',
                 django_extensions.db.fields.ModificationDateTimeField(
                     auto_now=True, verbose_name='modified')),
                ('id',
                 models.UUIDField(default=uuid.uuid4,
                                  editable=False,
                                  primary_key=True,
                                  serialize=False)),
                ('first_name',
                 models.CharField(max_length=64, verbose_name='first name')),
                ('last_name',
                 models.CharField(max_length=64, verbose_name='last name')),
                ('username',
                 models.CharField(max_length=255,
                                  unique=True,
                                  verbose_name='username')),
                ('email',
                 models.EmailField(blank=True,
                                   max_length=255,
                                   verbose_name='email address')),
                ('mobile',
                 models.CharField(blank=True,
                                  max_length=255,
                                  validators=[crm.validators.validate_mobile],
                                  verbose_name='mobile')),
                ('user_type',
                 common.models.EnumField(choices=[
                     (crm.models.UserType('site_inactive'), 'site_inactive'),
                     (crm.models.UserType('site_superuser'), 'site_superuser'),
                     (crm.models.UserType('site_support'), 'site_support'),
                     (crm.models.UserType('organization_inactive'),
                      'organization_inactive'),
                     (crm.models.UserType('organization_administrator'),
                      'organization_administrator'),
                     (crm.models.UserType('organization_member'),
                      'organization_member')
                 ],
                                         max_length=64)),
                ('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')),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='Organization',
            fields=[
                ('created',
                 django_extensions.db.fields.CreationDateTimeField(
                     auto_now_add=True, verbose_name='created')),
                ('modified',
                 django_extensions.db.fields.ModificationDateTimeField(
                     auto_now=True, verbose_name='modified')),
                ('id',
                 models.UUIDField(default=uuid.uuid4,
                                  editable=False,
                                  primary_key=True,
                                  serialize=False)),
                ('name', models.CharField(max_length=64)),
                ('slug',
                 django_extensions.db.fields.AutoSlugField(
                     blank=True, editable=False, populate_from=['name'])),
                ('use_email_id', models.BooleanField(default=True)),
            ],
            options={
                'ordering': ['created'],
                'abstract': False,
            },
        ),
        migrations.AddField(
            model_name='user',
            name='organization',
            field=models.ForeignKey(
                blank=True,
                null=True,
                on_delete=django.db.models.deletion.CASCADE,
                to='crm.Organization',
                verbose_name='organization'),
        ),
        migrations.AddField(
            model_name='user',
            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'),
        ),
    ]
class Migration(migrations.Migration):

    dependencies = [
        ('common', '0003_auto_20200509_2050'),
    ]

    operations = [
        migrations.AddField(
            model_name='user',
            name='waist',
            field=models.IntegerField(blank=True, null=True),
        ),
        migrations.CreateModel(
            name='ViceLog',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('preexisting', models.BooleanField(default=False)),
                ('timestamp', models.DateTimeField(auto_now_add=True)),
                ('vice', models.CharField(max_length=128)),
                ('quantity', models.CharField(max_length=128)),
                ('user',
                 models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
                                   to=settings.AUTH_USER_MODEL)),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='ToiletLog',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('preexisting', models.BooleanField(default=False)),
                ('timestamp', models.DateTimeField(auto_now_add=True)),
                ('user',
                 models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
                                   to=settings.AUTH_USER_MODEL)),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='SymptomsLog',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('preexisting', models.BooleanField(default=False)),
                ('timestamp', models.DateTimeField(auto_now_add=True)),
                ('status',
                 models.IntegerField(choices=[(0, 'Okay'), (1, 'Not okay'),
                                              (2, 'Very bad')],
                                     default=0)),
                ('user',
                 models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
                                   to=settings.AUTH_USER_MODEL)),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='StressLog',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('preexisting', models.BooleanField(default=False)),
                ('timestamp', models.DateTimeField(auto_now_add=True)),
                ('level', common.models.IntegerRangeField()),
                ('details', models.TextField()),
                ('user',
                 models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
                                   to=settings.AUTH_USER_MODEL)),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='SleepLog',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('preexisting', models.BooleanField(default=False)),
                ('timestamp', models.DateTimeField(auto_now_add=True)),
                ('start', models.TimeField()),
                ('end', models.TimeField()),
                ('quality', common.models.IntegerRangeField()),
                ('rem', models.BooleanField(blank=True)),
                ('user',
                 models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
                                   to=settings.AUTH_USER_MODEL)),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='NaturalRemediesLog',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('preexisting', models.BooleanField(default=False)),
                ('timestamp', models.DateTimeField(auto_now_add=True)),
                ('natural_remedy', models.CharField(max_length=128)),
                ('user',
                 models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
                                   to=settings.AUTH_USER_MODEL)),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='MedicationLog',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('preexisting', models.BooleanField(default=False)),
                ('timestamp', models.DateTimeField(auto_now_add=True)),
                ('medication', models.CharField(max_length=128)),
                ('dose', models.PositiveIntegerField()),
                ('user',
                 models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
                                   to=settings.AUTH_USER_MODEL)),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='ExerciseLog',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('preexisting', models.BooleanField(default=False)),
                ('timestamp', models.DateTimeField(auto_now_add=True)),
                ('exercise',
                 models.CharField(choices=[
                     ('WA', 'Walking'), ('RU', 'Running'), ('CY', 'Cycling'),
                     ('SW', 'Swimming')
                 ],
                                  max_length=2)),
                ('duration', models.DurationField()),
                ('user',
                 models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
                                   to=settings.AUTH_USER_MODEL)),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='DietLog',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('preexisting', models.BooleanField(default=False)),
                ('timestamp', models.DateTimeField(auto_now_add=True)),
                ('product', models.CharField(max_length=128)),
                ('code', models.CharField(blank=True, max_length=13)),
                ('calories', models.PositiveIntegerField()),
                ('user',
                 models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
                                   to=settings.AUTH_USER_MODEL)),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='CheckupLog',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('preexisting', models.BooleanField(default=False)),
                ('timestamp', models.DateTimeField()),
                ('details', models.TextField()),
                ('user',
                 models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
                                   to=settings.AUTH_USER_MODEL)),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='CardiovascularLog',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('preexisting', models.BooleanField(default=False)),
                ('timestamp', models.DateTimeField(auto_now_add=True)),
                ('pulse', models.PositiveIntegerField()),
                ('systolic_pressure', models.PositiveIntegerField(blank=True)),
                ('diastolic_pressure',
                 models.PositiveIntegerField(blank=True)),
                ('blood_sugar', models.FloatField(blank=True)),
                ('saturation',
                 models.DecimalField(decimal_places=2, max_digits=5)),
                ('user',
                 models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
                                   to=settings.AUTH_USER_MODEL)),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='BodyLog',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('preexisting', models.BooleanField(default=False)),
                ('timestamp', models.DateTimeField(auto_now_add=True)),
                ('height', models.IntegerField(blank=True, null=True)),
                ('weight', models.IntegerField(blank=True, null=True)),
                ('waist', models.IntegerField(blank=True, null=True)),
                ('user',
                 models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
                                   to=settings.AUTH_USER_MODEL)),
            ],
            options={
                'abstract': False,
            },
        ),
    ]
Example #24
0
class Migration(migrations.Migration):

    dependencies = [
        migrations.swappable_dependency(settings.AUTH_USER_MODEL),
        ('valve', '0001_initial'),
    ]

    operations = [
        migrations.CreateModel(
            name='Manufactor',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('create_at',
                 models.DateTimeField(auto_now_add=True, verbose_name='创建时间')),
                ('modified_at',
                 models.DateTimeField(auto_now=True, verbose_name='更新时间')),
                ('name',
                 models.CharField(blank=True,
                                  max_length=255,
                                  null=True,
                                  verbose_name='厂家名称')),
                ('address',
                 models.CharField(blank=True,
                                  max_length=255,
                                  null=True,
                                  verbose_name='厂家地址')),
                ('status',
                 models.BooleanField(default=True, verbose_name='当前状态')),
                ('creator',
                 models.ForeignKey(blank=True,
                                   null=True,
                                   on_delete=django.db.models.deletion.PROTECT,
                                   related_name='manufactor_creator',
                                   to=settings.AUTH_USER_MODEL,
                                   verbose_name='创建人')),
                ('modifier',
                 models.ForeignKey(blank=True,
                                   null=True,
                                   on_delete=django.db.models.deletion.PROTECT,
                                   related_name='manufactor_modifier',
                                   to=settings.AUTH_USER_MODEL,
                                   verbose_name='修改人')),
            ],
            options={
                'verbose_name': '生产厂家基本信息',
                'verbose_name_plural': '生产厂家基本信息',
            },
            bases=(models.Model, common.models.DictMixin),
        ),
        migrations.CreateModel(
            name='Sensor',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('create_at',
                 models.DateTimeField(auto_now_add=True, verbose_name='创建时间')),
                ('modified_at',
                 models.DateTimeField(auto_now=True, verbose_name='更新时间')),
                ('name',
                 models.CharField(blank=True,
                                  max_length=255,
                                  null=True,
                                  verbose_name='传感器名称')),
                ('code',
                 models.CharField(blank=True,
                                  max_length=255,
                                  null=True,
                                  verbose_name='传感器型号')),
                ('serial_number',
                 models.CharField(blank=True,
                                  max_length=255,
                                  null=True,
                                  unique=True,
                                  verbose_name='传感器唯一编号')),
                ('status',
                 models.BooleanField(default=True, verbose_name='当前状态')),
                ('creator',
                 models.ForeignKey(blank=True,
                                   null=True,
                                   on_delete=django.db.models.deletion.PROTECT,
                                   related_name='sensor_creator',
                                   to=settings.AUTH_USER_MODEL,
                                   verbose_name='创建人')),
                ('manufactor',
                 models.ForeignKey(
                     blank=True,
                     null=True,
                     on_delete=django.db.models.deletion.SET_NULL,
                     related_name='sensor_manufactor',
                     to='valve.Manufactor',
                     verbose_name='生产厂家')),
                ('modifier',
                 models.ForeignKey(blank=True,
                                   null=True,
                                   on_delete=django.db.models.deletion.PROTECT,
                                   related_name='sensor_modifier',
                                   to=settings.AUTH_USER_MODEL,
                                   verbose_name='修改人')),
            ],
            options={
                'verbose_name': '传感器设备',
                'verbose_name_plural': '传感器设备',
            },
            bases=(models.Model, common.models.DictMixin),
        ),
        migrations.CreateModel(
            name='Voltage',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('create_at',
                 models.DateTimeField(auto_now_add=True, verbose_name='创建时间')),
                ('modified_at',
                 models.DateTimeField(auto_now=True, verbose_name='更新时间')),
                ('valtage',
                 models.CharField(blank=True,
                                  max_length=255,
                                  null=True,
                                  verbose_name='电压测量量')),
                ('status',
                 models.BooleanField(default=True, verbose_name='当前状态')),
                ('sensor',
                 models.ForeignKey(
                     blank=True,
                     null=True,
                     on_delete=django.db.models.deletion.SET_NULL,
                     related_name='valtage_senor',
                     to='valve.Sensor',
                     verbose_name='所属传感器')),
            ],
            options={
                'verbose_name': '电压测量记录',
                'verbose_name_plural': '电压测量记录',
            },
            bases=(models.Model, common.models.DictMixin),
        ),
        migrations.CreateModel(
            name='WarnInfo',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('create_at',
                 models.DateTimeField(auto_now_add=True, verbose_name='创建时间')),
                ('modified_at',
                 models.DateTimeField(auto_now=True, verbose_name='更新时间')),
                ('warn_info',
                 models.CharField(blank=True,
                                  max_length=255,
                                  null=True,
                                  verbose_name='告警信息')),
                ('sensor',
                 models.ForeignKey(
                     blank=True,
                     null=True,
                     on_delete=django.db.models.deletion.SET_NULL,
                     related_name='warn_senor',
                     to='valve.Sensor',
                     verbose_name='所属传感器')),
            ],
            options={
                'verbose_name': '告警信息记录',
                'verbose_name_plural': '告警信息记录',
            },
            bases=(models.Model, common.models.DictMixin),
        ),
        migrations.DeleteModel(name='News', ),
    ]
class Migration(migrations.Migration):

    initial = True

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

    operations = [
        migrations.CreateModel(
            name='Post',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('title', models.CharField(max_length=160)),
                ('text', models.TextField()),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
            ],
        ),
        migrations.CreateModel(
            name='Tag',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('name', models.CharField(max_length=40)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('is_starter', models.BooleanField(blank=True, default=False)),
            ],
        ),
        migrations.CreateModel(
            name='Support',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('supported_post',
                 models.ForeignKey(blank=True,
                                   null=True,
                                   on_delete=django.db.models.deletion.CASCADE,
                                   related_name='supporters',
                                   to='common.Post')),
                ('supported_user',
                 models.ForeignKey(blank=True,
                                   null=True,
                                   on_delete=django.db.models.deletion.CASCADE,
                                   related_name='supporters',
                                   to=settings.AUTH_USER_MODEL)),
                ('supporter',
                 models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
                                   related_name='supports_made',
                                   to=settings.AUTH_USER_MODEL)),
            ],
        ),
        migrations.CreateModel(
            name='Profile',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('is_organization', models.BooleanField(default=False)),
                ('user',
                 models.OneToOneField(
                     on_delete=django.db.models.deletion.CASCADE,
                     to=settings.AUTH_USER_MODEL)),
            ],
        ),
        migrations.AddField(
            model_name='post',
            name='tags',
            field=models.ManyToManyField(related_name='users',
                                         to='common.Tag'),
        ),
        migrations.AddField(
            model_name='post',
            name='user',
            field=models.ForeignKey(
                on_delete=django.db.models.deletion.CASCADE,
                to=settings.AUTH_USER_MODEL),
        ),
        migrations.CreateModel(
            name='Image',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('image',
                 models.ImageField(upload_to=common.models.image_upload_path)),
                ('order_in_post', models.IntegerField()),
                ('post',
                 models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
                                   to='common.Post')),
            ],
        ),
    ]
Example #26
0
class Migration(migrations.Migration):

    initial = True

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

    operations = [
        migrations.CreateModel(
            name='Consumer',
            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')),
                ('open_code',
                 models.CharField(default='admin',
                                  help_text='如手机号、邮箱等',
                                  max_length=128,
                                  unique=True,
                                  verbose_name='登录账号')),
                ('category',
                 models.CharField(choices=[('mangage', '管理角色'),
                                           ('maintain', '运维人员')],
                                  default='maintain',
                                  max_length=32,
                                  verbose_name='账号类别')),
                ('name', models.CharField(max_length=128,
                                          verbose_name='用户姓名')),
                ('mobile',
                 models.CharField(blank=True,
                                  default='',
                                  max_length=128,
                                  null=True,
                                  verbose_name='联系电话')),
                ('sex',
                 models.CharField(choices=[('male', '男'), ('female', '女'),
                                           ('other', '未知')],
                                  default='other',
                                  max_length=32,
                                  verbose_name='性别')),
                ('email',
                 models.EmailField(blank=True,
                                   max_length=255,
                                   null=True,
                                   unique=True,
                                   verbose_name='邮箱')),
                ('avator',
                 models.CharField(blank=True,
                                  max_length=128,
                                  null=True,
                                  verbose_name='用户头像')),
                ('is_delete',
                 models.BooleanField(default=False, verbose_name='是否删除')),
                ('status',
                 models.BooleanField(default=True, verbose_name='是否启用')),
                ('is_active',
                 models.BooleanField(default=True, verbose_name='是否激活')),
                ('is_staff',
                 models.BooleanField(default=False, verbose_name='工作人权限')),
                ('is_admin',
                 models.BooleanField(default=False, verbose_name='超级用户权限')),
                ('date_joined',
                 models.DateTimeField(default=django.utils.timezone.now,
                                      verbose_name='创建日期')),
                ('read_fault',
                 models.TextField(blank=True,
                                  default='[]',
                                  null=True,
                                  verbose_name='用户阅读故障数量')),
            ],
            options={
                'verbose_name_plural': '用户信息表',
            },
        ),
        migrations.CreateModel(
            name='Deportment',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('create_at',
                 models.DateTimeField(auto_now_add=True, verbose_name='创建时间')),
                ('modified_at',
                 models.DateTimeField(auto_now=True, verbose_name='更新时间')),
                ('name',
                 models.CharField(blank=True,
                                  max_length=64,
                                  null=True,
                                  verbose_name='组织名称')),
                ('organization_type',
                 models.CharField(blank=True,
                                  choices=[('admin', '管理'),
                                           ('maintain', '运维')],
                                  max_length=18,
                                  null=True,
                                  verbose_name='组织类型')),
                ('belong_dept',
                 models.ForeignKey(blank=True,
                                   null=True,
                                   on_delete=django.db.models.deletion.CASCADE,
                                   related_name='dep_department_data',
                                   to='accounts.Deportment',
                                   verbose_name='数据权限部门')),
                ('create_by',
                 models.ForeignKey(
                     blank=True,
                     null=True,
                     on_delete=django.db.models.deletion.SET_NULL,
                     related_name='dep_create_by_msg',
                     to=settings.AUTH_USER_MODEL,
                     verbose_name='创建人')),
                ('parent',
                 models.ForeignKey(
                     blank=True,
                     null=True,
                     on_delete=django.db.models.deletion.SET_NULL,
                     related_name='department_children',
                     to='accounts.Deportment',
                     verbose_name='所属父级组织')),
                ('update_by',
                 models.ForeignKey(
                     blank=True,
                     null=True,
                     on_delete=django.db.models.deletion.SET_NULL,
                     related_name='dep_update_by_msg',
                     to=settings.AUTH_USER_MODEL,
                     verbose_name='编辑人')),
            ],
            options={
                'verbose_name': '用户组织表',
                'verbose_name_plural': '用户组织表',
            },
            bases=(models.Model, common.models.DictMixin),
        ),
        migrations.CreateModel(
            name='Role',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('code',
                 models.CharField(blank=True,
                                  max_length=255,
                                  null=True,
                                  unique=True,
                                  verbose_name='角色唯一CODE代码')),
                ('name', models.CharField(max_length=64, verbose_name='角色名称')),
                ('intro',
                 models.CharField(blank=True,
                                  max_length=255,
                                  null=True,
                                  verbose_name='角色介绍')),
                ('datas',
                 models.CharField(choices=[('全部', '全部'), ('同级及以下', '同级及以下'),
                                           ('本级及以下', '本级及以下'), ('本级', '本级'),
                                           ('仅本人', '仅本人')],
                                  default='本级及以下',
                                  max_length=50,
                                  verbose_name='数据权限')),
                ('role_permission_list',
                 models.CharField(blank=True,
                                  max_length=1024,
                                  null=True,
                                  verbose_name='角色权限信息')),
                ('status',
                 models.BooleanField(default=True, verbose_name='当前状态')),
                ('creator',
                 models.ForeignKey(blank=True,
                                   null=True,
                                   on_delete=django.db.models.deletion.PROTECT,
                                   related_name='role_creator',
                                   to=settings.AUTH_USER_MODEL,
                                   verbose_name='创建人')),
                ('depts',
                 models.ForeignKey(
                     blank=True,
                     null=True,
                     on_delete=django.db.models.deletion.SET_NULL,
                     to='accounts.Deportment',
                     verbose_name='所属组织')),
                ('modifier',
                 models.ForeignKey(blank=True,
                                   null=True,
                                   on_delete=django.db.models.deletion.PROTECT,
                                   related_name='role_modifier',
                                   to=settings.AUTH_USER_MODEL,
                                   verbose_name='修改人')),
                ('parent',
                 models.ForeignKey(blank=True,
                                   null=True,
                                   on_delete=django.db.models.deletion.PROTECT,
                                   related_name='children',
                                   to='accounts.Role',
                                   verbose_name='所属父级角色')),
            ],
            options={
                'verbose_name_plural': '角色表 ',
            },
        ),
        migrations.CreateModel(
            name='RoleMenu',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('create_at',
                 models.DateTimeField(auto_now_add=True, verbose_name='创建时间')),
                ('modified_at',
                 models.DateTimeField(auto_now=True, verbose_name='更新时间')),
                ('content', models.TextField(verbose_name='角色菜单内容')),
            ],
            options={
                'verbose_name': '角色菜单表',
                'verbose_name_plural': '角色菜单表',
            },
            bases=(models.Model, common.models.DictMixin),
        ),
        migrations.CreateModel(
            name='WechatUser',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('create_at',
                 models.DateTimeField(auto_now_add=True, verbose_name='创建时间')),
                ('modified_at',
                 models.DateTimeField(auto_now=True, verbose_name='更新时间')),
                ('nickname',
                 models.CharField(blank=True,
                                  max_length=64,
                                  null=True,
                                  verbose_name='用户名称')),
                ('headimgurl',
                 models.CharField(blank=True,
                                  max_length=255,
                                  null=True,
                                  verbose_name='用户头像')),
                ('openid',
                 models.CharField(blank=True,
                                  max_length=255,
                                  null=True,
                                  verbose_name='用户openid')),
                ('unionid',
                 models.CharField(blank=True,
                                  max_length=255,
                                  null=True,
                                  verbose_name='用户unionid')),
                ('city',
                 models.CharField(blank=True,
                                  max_length=255,
                                  null=True,
                                  verbose_name='用户所在城市')),
                ('country',
                 models.CharField(blank=True,
                                  max_length=255,
                                  null=True,
                                  verbose_name='用户所在国家')),
                ('province',
                 models.CharField(blank=True,
                                  max_length=255,
                                  null=True,
                                  verbose_name='用户所在省份')),
                ('balance',
                 models.DecimalField(decimal_places=2,
                                     default=0,
                                     max_digits=7,
                                     verbose_name='账户余额')),
                ('status',
                 models.BooleanField(default=True, verbose_name='用户当前状态')),
            ],
            options={
                'verbose_name_plural': '微信用户信息表',
            },
            bases=(models.Model, common.models.DictMixin),
        ),
        migrations.CreateModel(
            name='RoleButton',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('create_at',
                 models.DateTimeField(auto_now_add=True, verbose_name='创建时间')),
                ('modified_at',
                 models.DateTimeField(auto_now=True, verbose_name='更新时间')),
                ('name',
                 models.CharField(blank=True,
                                  max_length=32,
                                  null=True,
                                  verbose_name='权限名称')),
                ('code',
                 models.CharField(blank=True,
                                  max_length=32,
                                  null=True,
                                  verbose_name='code码')),
                ('describe',
                 models.CharField(blank=True,
                                  max_length=256,
                                  null=True,
                                  verbose_name='描述')),
                ('belong_menu',
                 models.CharField(blank=True,
                                  max_length=18,
                                  null=True,
                                  verbose_name='所属菜单')),
                ('status',
                 models.BooleanField(default=False, verbose_name='按钮状态')),
                ('role',
                 models.ManyToManyField(blank=True,
                                        related_name='role_button',
                                        to='accounts.Role',
                                        verbose_name='所属角色')),
            ],
            options={
                'verbose_name': '角色按钮表',
                'verbose_name_plural': '角色按钮表',
            },
            bases=(models.Model, common.models.DictMixin),
        ),
        migrations.CreateModel(
            name='Operational',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('create_at',
                 models.DateTimeField(auto_now_add=True, verbose_name='创建时间')),
                ('modified_at',
                 models.DateTimeField(auto_now=True, verbose_name='更新时间')),
                ('order',
                 models.CharField(blank=True,
                                  max_length=32,
                                  null=True,
                                  verbose_name='工单编号')),
                ('operational_type',
                 models.CharField(choices=[('weixiugongdan', '维修工单'),
                                           ('chakangongdan', '巡检工单')],
                                  max_length=32,
                                  verbose_name='工单类型')),
                ('operational_state',
                 models.CharField(choices=[('urgency', '紧急'),
                                           ('common', '一般')],
                                  max_length=32,
                                  verbose_name='状态属性')),
                ('dispose_time',
                 models.DateTimeField(blank=True,
                                      default=django.utils.timezone.now,
                                      null=True,
                                      verbose_name='处理时间')),
                ('status',
                 models.CharField(blank=True,
                                  choices=[('not_send_order', '尚未派单'),
                                           ('send_order', '派单完成'),
                                           ('not_dispose', '未处理'),
                                           ('dispose', '处理')],
                                  default='not_send_order',
                                  max_length=16,
                                  null=True,
                                  verbose_name='处理状态')),
                ('cause',
                 models.TextField(blank=True, null=True, verbose_name='故障原因')),
                ('process',
                 models.CharField(blank=True,
                                  max_length=128,
                                  null=True,
                                  verbose_name='处理过程')),
                ('resault',
                 models.CharField(blank=True,
                                  max_length=128,
                                  null=True,
                                  verbose_name='处理结果')),
                ('creator',
                 models.ForeignKey(
                     blank=True,
                     null=True,
                     on_delete=django.db.models.deletion.SET_NULL,
                     related_name='fault_submit_creator',
                     to=settings.AUTH_USER_MODEL,
                     verbose_name='维修人员')),
                ('send_user',
                 models.ForeignKey(
                     blank=True,
                     null=True,
                     on_delete=django.db.models.deletion.SET_NULL,
                     related_name='send_user_fault',
                     to=settings.AUTH_USER_MODEL,
                     verbose_name='派单人员')),
            ],
            options={
                'verbose_name': '工单管理',
                'verbose_name_plural': '工单管理',
            },
            bases=(models.Model, common.models.DictMixin),
        ),
        migrations.AddField(
            model_name='consumer',
            name='dept',
            field=models.ForeignKey(
                blank=True,
                null=True,
                on_delete=django.db.models.deletion.SET_NULL,
                related_name='user_deps',
                to='accounts.Deportment',
                verbose_name='组织'),
        ),
        migrations.AddField(
            model_name='consumer',
            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='consumer',
            name='role',
            field=models.ManyToManyField(blank=True,
                                         related_name='role_consumer',
                                         to='accounts.Role',
                                         verbose_name='用户角色'),
        ),
        migrations.AddField(
            model_name='consumer',
            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'),
        ),
        migrations.AddField(
            model_name='consumer',
            name='wechat_user',
            field=models.ForeignKey(
                blank=True,
                null=True,
                on_delete=django.db.models.deletion.CASCADE,
                related_name='wechat_consumer',
                to='accounts.WechatUser',
                verbose_name='微信用户信息'),
        ),
    ]
Example #27
0
class Migration(migrations.Migration):
    initial = True
    dependencies = [("auth", "0011_update_proxy_permissions")]

    operations = [
        migrations.CreateModel(
            name="User",
            fields=[
                (
                    "id",
                    models.UUIDField(
                        default=uuid.uuid4,
                        editable=False,
                        primary_key=True,
                        serialize=False,
                    ),
                ),
                (
                    "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)),
                (
                    "name",
                    models.CharField(blank=True, max_length=255, null=True),
                ),
                ("is_active", models.BooleanField(default=True)),
                ("is_staff", models.BooleanField(default=False)),
                ("date_joined", models.DateTimeField(auto_now_add=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},
            bases=(common.models.UUIDMixin, models.Model),
        )
    ]
Example #28
0
class Migration(migrations.Migration):

    initial = True

    dependencies = [
        ('auth', '0009_alter_user_last_name_max_length'),
        migrations.swappable_dependency(settings.AUTH_USER_MODEL),
    ]

    operations = [
        migrations.CreateModel(
            name='Department',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('created_at', models.DateField(auto_now_add=True, null=True)),
                ('modified_at', models.DateField(auto_now=True, null=True)),
                ('active', models.BooleanField(default=True)),
                ('name', models.CharField(max_length=150,
                                          verbose_name='_Name')),
            ],
            options={
                'verbose_name':
                'Department',
                'verbose_name_plural':
                'Departments',
                'permissions': (('change_between_departments',
                                 'Can change between Departments'), ),
            },
        ),
        migrations.CreateModel(
            name='OwnerGroup',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('created_at', models.DateField(auto_now_add=True, null=True)),
                ('modified_at', models.DateField(auto_now=True, null=True)),
                ('active', models.BooleanField(default=True)),
                ('name', models.CharField(max_length=80, verbose_name='Name')),
            ],
            options={
                'verbose_name': 'Owner group',
                'verbose_name_plural': 'Owner groups',
            },
        ),
        migrations.CreateModel(
            name='UserProfile',
            fields=[
                ('created_at', models.DateField(auto_now_add=True, null=True)),
                ('modified_at', models.DateField(auto_now=True, null=True)),
                ('active', models.BooleanField(default=True)),
                ('user',
                 models.OneToOneField(
                     on_delete=django.db.models.deletion.CASCADE,
                     primary_key=True,
                     related_name='profile',
                     serialize=False,
                     to=settings.AUTH_USER_MODEL)),
                ('gender',
                 models.PositiveSmallIntegerField(blank=True,
                                                  choices=[(1, 'Male'),
                                                           (2, 'Female')],
                                                  null=True,
                                                  verbose_name='Gender')),
                ('avatar',
                 models.ImageField(blank=True,
                                   null=True,
                                   upload_to='',
                                   verbose_name='Avatar')),
                ('is_owner_admin', models.BooleanField(default=False)),
                ('email_is_verified',
                 models.BooleanField(default=False, editable=False)),
                ('forbidden_counter',
                 models.PositiveIntegerField(blank=True,
                                             default=0,
                                             editable=False)),
                ('department',
                 models.ForeignKey(blank=True,
                                   null=True,
                                   on_delete=django.db.models.deletion.CASCADE,
                                   to='members.Department')),
                ('group',
                 models.ManyToManyField(blank=True, to='members.OwnerGroup')),
                ('modified_by',
                 models.ForeignKey(
                     editable=False,
                     null=True,
                     on_delete=django.db.models.deletion.SET_NULL,
                     related_name='userprofile_modified',
                     to=settings.AUTH_USER_MODEL)),
                ('owner',
                 models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
                                   to=settings.AUTH_USER_MODEL)),
            ],
            options={
                'verbose_name': 'User profile',
                'verbose_name_plural': 'User profiles',
            },
        ),
        migrations.AddField(
            model_name='ownergroup',
            name='modified_by',
            field=models.ForeignKey(
                editable=False,
                null=True,
                on_delete=django.db.models.deletion.SET_NULL,
                related_name='ownergroup_modified',
                to=settings.AUTH_USER_MODEL),
        ),
        migrations.AddField(
            model_name='ownergroup',
            name='permission',
            field=models.ManyToManyField(
                blank=True,
                limit_choices_to={
                    'codename__in': [
                        'add_userprofile', 'delete_userprofile',
                        'view_userprofile', 'change_userprofile',
                        'change_between_departments', 'add_department',
                        'change_department', 'view_department',
                        'delete_department', 'add_ownergroup',
                        'change_ownergroup', 'view_ownergroup',
                        'delete_ownergroup'
                    ]
                },
                to='auth.Permission'),
        ),
        migrations.AddField(
            model_name='ownergroup',
            name='user',
            field=models.ForeignKey(editable=False,
                                    on_delete=common.models.SET_OWNER,
                                    related_name='ownergroup_created',
                                    to=settings.AUTH_USER_MODEL),
        ),
        migrations.AddField(
            model_name='department',
            name='group',
            field=models.ManyToManyField(blank=True, to='members.OwnerGroup'),
        ),
        migrations.AddField(
            model_name='department',
            name='modified_by',
            field=models.ForeignKey(
                editable=False,
                null=True,
                on_delete=django.db.models.deletion.SET_NULL,
                related_name='department_modified',
                to=settings.AUTH_USER_MODEL),
        ),
        migrations.AddField(
            model_name='department',
            name='user',
            field=models.ForeignKey(editable=False,
                                    on_delete=common.models.SET_OWNER,
                                    related_name='department_created',
                                    to=settings.AUTH_USER_MODEL),
        ),
    ]
Example #29
0
class Migration(migrations.Migration):

    initial = True

    dependencies = [
        ('ansible_api', '0001_initial'),
    ]

    operations = [
        migrations.CreateModel(
            name='Cluster',
            fields=[
                ('project_ptr', models.OneToOneField(auto_created=True, on_delete=django.db.models.deletion.CASCADE, parent_link=True, primary_key=True, serialize=False, to='ansible_api.Project')),
                ('template', models.CharField(blank=True, default='', max_length=64)),
                ('current_task_id', models.CharField(blank=True, default='', max_length=128)),
                ('is_super', models.BooleanField(default=False)),
            ],
            bases=('ansible_api.project',),
        ),
        migrations.CreateModel(
            name='DeployExecution',
            fields=[
                ('id', models.UUIDField(default=uuid.uuid4, primary_key=True, serialize=False)),
                ('timedelta', models.FloatField(default=0.0, null=True, verbose_name='Time')),
                ('state', models.CharField(choices=[('PENDING', 'Pending'), ('STARTED', 'Started'), ('SUCCESS', 'Success'), ('FAILURE', 'Failure'), ('RETRY', 'Retry')], default='PENDING', max_length=16)),
                ('num', models.IntegerField(default=1)),
                ('result_summary', common.models.JsonDictTextField(blank=True, default={}, null=True, verbose_name='Result summary')),
                ('result_raw', common.models.JsonDictTextField(blank=True, default={}, null=True, verbose_name='Result raw')),
                ('date_created', models.DateTimeField(auto_now_add=True, null=True, verbose_name='Create time')),
                ('date_start', models.DateTimeField(null=True, verbose_name='Start time')),
                ('date_end', models.DateTimeField(null=True, verbose_name='End time')),
                ('operation', models.CharField(blank=True, choices=[('install', 'install'), ('upgrade', 'upgrade'), ('uninstall', 'uninstall')], default='install', max_length=128)),
                ('current_task', models.CharField(blank=True, default=None, max_length=128, null=True)),
                ('progress', models.FloatField(blank=True, default=0.0, max_length=64, null=True)),
                ('project', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='ansible_api.Project')),
            ],
            options={
                'ordering': ('-date_created',),
                'get_latest_by': 'date_created',
            },
        ),
        migrations.CreateModel(
            name='Host',
            fields=[
                ('name', models.CharField(max_length=256, validators=[django.core.validators.RegexValidator(message='Enter a valid name consisting of Unicode letters, numbers, underscores, or hyphens, or dot', regex='^[a-zA-Z0-9_\\-\\.]+$')])),
                ('ip', models.GenericIPAddressField(null=True)),
                ('port', models.IntegerField(default=22)),
                ('username', models.CharField(default='root', max_length=256)),
                ('password', common.models.EncryptCharField(blank=True, max_length=4096, null=True)),
                ('private_key', common.models.EncryptCharField(blank=True, max_length=8192, null=True)),
                ('vars', common.models.JsonDictTextField(default={})),
                ('meta', common.models.JsonDictTextField(default={})),
                ('comment', models.TextField(blank=True)),
                ('id', models.UUIDField(default=uuid.uuid4, primary_key=True, serialize=False)),
                ('memory', models.BigIntegerField(default=0)),
                ('os', models.CharField(default='', max_length=128)),
                ('os_version', models.CharField(default='', max_length=128)),
                ('cpu_core', models.IntegerField(default=0)),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='Node',
            fields=[
                ('host_ptr', models.OneToOneField(auto_created=True, on_delete=django.db.models.deletion.CASCADE, parent_link=True, primary_key=True, serialize=False, to='ansible_api.Host')),
                ('host', models.ForeignKey(default=None, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='host', to='openshift_api.Host')),
            ],
            options={
                'abstract': False,
            },
            bases=('ansible_api.host',),
        ),
        migrations.CreateModel(
            name='Package',
            fields=[
                ('id', models.UUIDField(default=uuid.uuid4, primary_key=True, serialize=False)),
                ('name', models.CharField(max_length=20, unique=True, verbose_name='Name')),
                ('meta', common.models.JsonTextField(blank=True, null=True, verbose_name='Meta')),
                ('date_created', models.DateTimeField(auto_now_add=True, verbose_name='Date created')),
            ],
            options={
                'verbose_name': 'Package',
            },
        ),
        migrations.CreateModel(
            name='Role',
            fields=[
            ],
            options={
                'proxy': True,
                'indexes': [],
            },
            bases=('ansible_api.group',),
        ),
        migrations.AddField(
            model_name='host',
            name='node',
            field=models.ForeignKey(default=None, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='node', to='openshift_api.Node'),
        ),
        migrations.AddField(
            model_name='cluster',
            name='package',
            field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, to='openshift_api.Package'),
        ),
    ]
Example #30
0
class Migration(migrations.Migration):

    initial = True

    dependencies = [
        migrations.swappable_dependency(settings.AUTH_USER_MODEL),
        ('crm', '0001_initial'),
    ]

    operations = [
        migrations.CreateModel(
            name='Assignment',
            fields=[
                ('created',
                 django_extensions.db.fields.CreationDateTimeField(
                     auto_now_add=True, verbose_name='created')),
                ('modified',
                 django_extensions.db.fields.ModificationDateTimeField(
                     auto_now=True, verbose_name='modified')),
                ('is_deleted', models.BooleanField(default=False)),
                ('id',
                 models.UUIDField(default=uuid.uuid4,
                                  editable=False,
                                  primary_key=True,
                                  serialize=False)),
                ('status',
                 django_fsm.FSMField(
                     choices=[(role_model.models.Status('formal'), 'formal'),
                              (role_model.models.Status('ad_hoc'), 'ad_hoc'),
                              (role_model.models.Status('adjunct'), 'adjunct')
                              ],
                     default=role_model.models.Status('formal'),
                     max_length=50)),
            ],
            options={
                'base_manager_name': 'objects',
            },
        ),
        migrations.CreateModel(
            name='ContentType',
            fields=[
                ('created',
                 django_extensions.db.fields.CreationDateTimeField(
                     auto_now_add=True, verbose_name='created')),
                ('modified',
                 django_extensions.db.fields.ModificationDateTimeField(
                     auto_now=True, verbose_name='modified')),
                ('is_deleted', models.BooleanField(default=False)),
                ('id',
                 models.UUIDField(default=uuid.uuid4,
                                  editable=False,
                                  primary_key=True,
                                  serialize=False)),
            ],
            options={
                'base_manager_name': 'objects',
            },
        ),
        migrations.CreateModel(
            name='Deliverable',
            fields=[
                ('created',
                 django_extensions.db.fields.CreationDateTimeField(
                     auto_now_add=True, verbose_name='created')),
                ('modified',
                 django_extensions.db.fields.ModificationDateTimeField(
                     auto_now=True, verbose_name='modified')),
                ('is_deleted', models.BooleanField(default=False)),
                ('id',
                 models.UUIDField(default=uuid.uuid4,
                                  editable=False,
                                  primary_key=True,
                                  serialize=False)),
                ('name', models.CharField(max_length=64)),
                ('slug',
                 django_extensions.db.fields.AutoSlugField(
                     blank=True, editable=False, populate_from=['name'])),
                ('organization',
                 models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
                                   related_name='deliverables',
                                   to='crm.Organization')),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='Facet',
            fields=[
                ('created',
                 django_extensions.db.fields.CreationDateTimeField(
                     auto_now_add=True, verbose_name='created')),
                ('modified',
                 django_extensions.db.fields.ModificationDateTimeField(
                     auto_now=True, verbose_name='modified')),
                ('is_deleted', models.BooleanField(default=False)),
                ('id',
                 models.UUIDField(default=uuid.uuid4,
                                  editable=False,
                                  primary_key=True,
                                  serialize=False)),
                ('name', models.CharField(max_length=64)),
                ('slug',
                 django_extensions.db.fields.AutoSlugField(
                     blank=True, editable=False, populate_from=['name'])),
                ('deliverable',
                 models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
                                   related_name='facets',
                                   to='role_model.Deliverable')),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='Format',
            fields=[
                ('created',
                 django_extensions.db.fields.CreationDateTimeField(
                     auto_now_add=True, verbose_name='created')),
                ('modified',
                 django_extensions.db.fields.ModificationDateTimeField(
                     auto_now=True, verbose_name='modified')),
                ('is_deleted', models.BooleanField(default=False)),
                ('id',
                 models.UUIDField(default=uuid.uuid4,
                                  editable=False,
                                  primary_key=True,
                                  serialize=False)),
                ('name', models.CharField(max_length=64)),
                ('slug',
                 django_extensions.db.fields.AutoSlugField(
                     blank=True, editable=False, populate_from=['name'])),
                ('description', models.TextField(max_length=1024)),
                ('deliverable',
                 models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
                                   related_name='formats',
                                   to='role_model.Deliverable')),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='Group',
            fields=[
                ('created',
                 django_extensions.db.fields.CreationDateTimeField(
                     auto_now_add=True, verbose_name='created')),
                ('modified',
                 django_extensions.db.fields.ModificationDateTimeField(
                     auto_now=True, verbose_name='modified')),
                ('is_deleted', models.BooleanField(default=False)),
                ('id',
                 models.UUIDField(default=uuid.uuid4,
                                  editable=False,
                                  primary_key=True,
                                  serialize=False)),
                ('name', models.CharField(max_length=64)),
                ('slug',
                 django_extensions.db.fields.AutoSlugField(
                     blank=True, editable=False, populate_from=['name'])),
                ('organization',
                 models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
                                   related_name='groups',
                                   to='crm.Organization')),
            ],
            options={
                'base_manager_name': 'objects',
            },
        ),
        migrations.CreateModel(
            name='Responsibility',
            fields=[
                ('created',
                 django_extensions.db.fields.CreationDateTimeField(
                     auto_now_add=True, verbose_name='created')),
                ('modified',
                 django_extensions.db.fields.ModificationDateTimeField(
                     auto_now=True, verbose_name='modified')),
                ('id',
                 models.UUIDField(default=uuid.uuid4,
                                  editable=False,
                                  primary_key=True,
                                  serialize=False)),
                ('operator',
                 common.models.EnumField(choices=[
                     (role_model.models.Operator('transform'), 'transform'),
                     (role_model.models.Operator('reduce'), 'reduce'),
                     (role_model.models.Operator('sort'), 'sort'),
                     (role_model.models.Operator('filter'), 'filter'),
                     (role_model.models.Operator('combine'), 'combine')
                 ],
                                         max_length=64)),
            ],
            options={
                'verbose_name_plural': 'responsibilities',
                'base_manager_name': 'objects',
            },
        ),
        migrations.CreateModel(
            name='ResponsibilityInputType',
            fields=[
                ('id',
                 models.UUIDField(default=uuid.uuid4,
                                  editable=False,
                                  primary_key=True,
                                  serialize=False)),
                ('content_type',
                 models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
                                   to='role_model.ContentType')),
                ('responsibility',
                 models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
                                   to='role_model.Responsibility')),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='Role',
            fields=[
                ('created',
                 django_extensions.db.fields.CreationDateTimeField(
                     auto_now_add=True, verbose_name='created')),
                ('modified',
                 django_extensions.db.fields.ModificationDateTimeField(
                     auto_now=True, verbose_name='modified')),
                ('is_deleted', models.BooleanField(default=False)),
                ('id',
                 models.UUIDField(default=uuid.uuid4,
                                  editable=False,
                                  primary_key=True,
                                  serialize=False)),
                ('name', models.CharField(max_length=64)),
                ('slug',
                 django_extensions.db.fields.AutoSlugField(
                     blank=True, editable=False, populate_from=['name'])),
                ('group',
                 models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
                                   related_name='roles',
                                   to='role_model.Group')),
                ('responsibilities',
                 models.ManyToManyField(through='role_model.Assignment',
                                        to='role_model.Responsibility')),
                ('users', models.ManyToManyField(to=settings.AUTH_USER_MODEL)),
            ],
            options={
                'base_manager_name': 'objects',
            },
        ),
        migrations.AddField(
            model_name='responsibility',
            name='input_types',
            field=models.ManyToManyField(
                related_name='outputs',
                through='role_model.ResponsibilityInputType',
                to='role_model.ContentType'),
        ),
        migrations.AddField(
            model_name='responsibility',
            name='organization',
            field=models.ForeignKey(
                on_delete=django.db.models.deletion.CASCADE,
                related_name='responsibilitys',
                to='crm.Organization'),
        ),
        migrations.AddField(
            model_name='responsibility',
            name='output_type',
            field=models.ForeignKey(
                on_delete=django.db.models.deletion.CASCADE,
                related_name='inputs',
                to='role_model.ContentType'),
        ),
        migrations.AddField(
            model_name='contenttype',
            name='deliverable',
            field=models.ForeignKey(
                on_delete=django.db.models.deletion.CASCADE,
                related_name='content_types',
                to='role_model.Deliverable'),
        ),
        migrations.AddField(
            model_name='contenttype',
            name='facet',
            field=models.ForeignKey(
                on_delete=django.db.models.deletion.CASCADE,
                related_name='content_types',
                to='role_model.Facet'),
        ),
        migrations.AddField(
            model_name='contenttype',
            name='format',
            field=models.ForeignKey(
                on_delete=django.db.models.deletion.CASCADE,
                related_name='content_types',
                to='role_model.Format'),
        ),
        migrations.AddField(
            model_name='contenttype',
            name='group',
            field=models.ForeignKey(
                on_delete=django.db.models.deletion.CASCADE,
                related_name='content_types',
                to='role_model.Group'),
        ),
        migrations.AddField(
            model_name='assignment',
            name='responsibility',
            field=models.ForeignKey(
                on_delete=django.db.models.deletion.CASCADE,
                related_name='assignments',
                to='role_model.Responsibility'),
        ),
        migrations.AddField(
            model_name='assignment',
            name='role',
            field=models.ForeignKey(
                on_delete=django.db.models.deletion.CASCADE,
                related_name='assignments',
                to='role_model.Role'),
        ),
        migrations.AlterUniqueTogether(
            name='assignment',
            unique_together={('role', 'responsibility')},
        ),
    ]